How to find current running sqls in oracle

Use below script to get the current running sql details.   [crayon-5c40d0068692f967072837/]   Output: [crayon-5c40d00686935142156281/]

Get explain plans of a sql query from AWR using DBMS_XPLAN.DISPLAY_AWR

By analyzing the awr report ,you found that there was some issue with a particular sql_id, and you want to get the explain plans associated with that sql_id. We can get the explains using dbms_xplan.d...

Skip to toolbar