Query to find execution plan using sql_id in oracle database

 

Use below query to find the execution plan of currently running sql using sql_id.

set lines 500

SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('<sql_id',0));

Thanks for going through the post...............