V$SQL_PLAN_MONITOR
displays real time plan level monitoring statistics for the currently running sql queries.. Each row in V$SQL_PLAN_MONITOR
corresponds to an operation of the execution plan being monitored.
--- sql_is from v$sql_monitor SELECT sql_id FROM v$sql_monitor; SQL_ID ------- 00tr6c6tngp4x
Use below query to get the plan details:
SELECT sid, sql_id, status, plan_line_id, plan_operation || ' ' || plan_options operation, output_rows FROM v$sql_plan_monitor WHERE status not like '%DONE%' ORDER BY 1,4;
Output
SID SQL_ID STATUS LINE OPERATION ROWS ---------- ------------- ---------- ----- ------------------------- ---------- 82 00tr6c6tngp4x EXECUTING 0 INSERT STATEMENT 0 1 LOAD TABLE CONVENTIONAL 0 2 HASH UNIQUE 0 3 HASH JOIN ANTI 0 4 NESTED LOOPS ANTI 0 5 STATISTICS COLLECTOR 4293890583 6 HASH JOIN 4293890583 7 NESTED LOOPS 1 8 STATISTICS COLLECTOR 1565871 9 MERGE JOIN CARTESIAN 1565871 10 INDEX RANGE SCAN 5381 11 BUFFER SORT 1565871 12 INDEX RANGE SCAN 291 13 INDEX RANGE SCAN 0 14 INDEX FAST FULL SCAN 1860196 15 INDEX RANGE SCAN 69 16 INDEX RANGE SCAN 0 17 rows selected.