performance

How to find current running sqls in oracle

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

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