parallel-px-real time sql monitoring

gistfile1.sql

SQL> with t as (select/*+ materialize */ level id from dual connect by level<=1e3)
  2  select/*+ parallel(t) */ count(*) from t;

  COUNT(*)
----------
      1000

1 row selected.

SQL> @find_sql "with t as (select/*+ materialize%"
Show only first 30 found:

   INST_ID SQL_ID        TO_PURGE                              PHV      EXECS     ELAEXE SQL_TEXT_TRUNC                                                                                      
---------- ------------- ------------------------------ ---------- ---------- ---------- ----------------------------------------------------------------------------------------------------
         1 5suq2a52n7m6s 000007FF27531A40,1162071256    2769823868          1    .392007 with t as (select/*+ materialize */ level id from dual connect by level<=1e3) select/*+ parallel(t)
                                                                                         */ count(*) from t
SQL> ;
  1  select r.SQL_EXEC_ID
  2        ,r.status
  3        ,r.PROCESS_NAME
  4        ,r.PX_IS_CROSS_INSTANCE
  5        ,r.PX_MAXDOP
  6        ,r.PX_QCSID
  7        ,r.PX_SERVER_SET
  8        ,r.PX_SERVER#
  9        ,r.PX_SERVER_GROUP
 10  from v$sql_monitor r
 11* where r.SQL_ID='5suq2a52n7m6s'
SQL> /

SQL_EXEC_ID STATUS              PROCE P  PX_MAXDOP   PX_QCSID PX_SERVER_SET PX_SERVER# PX_SERVER_GROUP
----------- ------------------- ----- - ---------- ---------- ------------- ---------- ---------------
   16777216 DONE (ALL ROWS)     ora   N          2
   16777216 DONE (ALL ROWS)     p000                      132             1          1               1
   16777216 DONE (ALL ROWS)     p001                      132             1          2               1

3 rows selected.