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.