Tanel Poder Snapper, brilliant !!!!!

SQL> @snapper ash=sid+event+wait_class 5 1 all
Sampling SID all with interval 5 seconds, taking 1 snapshots...


-- Session Snapper v3.52 by Tanel Poder @ E2SN ( http://tech.e2sn.com )


------------------------------------------------------------------------
Active% |    SID | EVENT                               | WAIT_CLASS
------------------------------------------------------------------------
    43% |    139 | DFS lock handle                     | Other
    34% |    139 | ON CPU                              | ON CPU
     7% |    121 | ASM file metadata operation         | Other
     7% |    139 | control file sequential read        | System I/O
     5% |    155 | db file parallel write              | System I/O
     5% |    139 | local write wait                    | User I/O
     2% |    114 | ASM file metadata operation         | Other
     2% |    155 | control file sequential read        | System I/O
     2% |    139 | db file sequential read             | User I/O
     2% |    139 | control file parallel write         | System I/O


--  End of ASH snap 1, end=2012-01-31 14:37:38, seconds=5, samples_taken=44


SQL> @snapper stat 5 1 139


SQL> @snapper ash 5 1 139
Sampling SID 139 with interval 5 seconds, taking 1 snapshots...


-- Session Snapper v3.52 by Tanel Poder @ E2SN ( http://tech.e2sn.com )


---------------------------------------------------------------------------------
Active% | SQL_ID          | EVENT                               | WAIT_CLASS
---------------------------------------------------------------------------------
    30% | dwju4951auwat   | ON CPU                              | ON CPU
    28% | dwju4951auwat   | DFS lock handle                     | Other
     2% | dwju4951auwat   | db file single write                | User I/O
     2% | dwju4951auwat   | local write wait                    | User I/O


--  End of ASH snap 1, end=2012-01-31 14:33:14, seconds=5, samples_taken=46


SQL> @sqlid dwju4951auwat %
Show SQL text, child cursors and execution stats for SQLID dwju4951auwat child %


HASH_VALUE  CH# SQL_TEXT
---------- ---- ------------------------------------------------------------------------------------------------------------------------------------------------------
1118663001    0 INSERT INTO CNM1 SELECT * FROM V$SESSION


 CH# PARENT_HANDLE    OBJECT_HANDLE     PLAN_HASH     PARSES   H_PARSES EXECUTIONS    FETCHES ROWS_PROCESSED ROWS_PER_FETCH    CPU_SEC    ELA_SEC       LIOS       PIOS      SORTS USERS_EXECUTING
---- ---------------- ---------------- ---------- ---------- ---------- ---------- ---------- -------------- -------------- ---------- ---------- ---------- ---------- ---------- ---------------
   0 000000021A24C328 000000021A24C120  644658511         10          1      67894          0        3049130                12.3964742 304.288453    1240108       1371          0               1