How to find current running sqls in oracle

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

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