is there any mechanism/utility by which we can trigger an ALERT immediately via email or anything whenever a DML query is fired on any specific databases
There are no database level triggers.
If it's not neccessarily "immediatle" you might run a job extracting that info from the Access Log every few minutes.
I have a qry . in that join is taking more time . its showing 10 m in plan.
one of the join column is skewed with one value.
can u pls help me how can we make that join faster.
You can fire such an alert quite easily using TASM. Create an ALERT only Filter and add classifications (Query Characteristics: Only DML statements & Target: Include XXX Databases)