SQL Monitoring List
                                                                               =====================


================================================================================================================================================================================
|      Status      | Duration |    SQL Id     | Exec Id  |      Start       | User  |   Module/Action    | Dop | DB Time | IOs  |                   SQL Text                   |
================================================================================================================================================================================
| DONE (ALL ROWS)  |    0.06s | 526mvccm5nfy4 | 16777216 |    03/21/2011    | SCOTT | SQL*Plus/-         |     |   0.06s |   15 | SELECT /*+ MONITOR */ d.dname,               |
|                  |          |               |          |     13:36:08     |       |                    |     |         |      | WM_CONCAT(e.ename) AS employees FROM emp e   |
|                  |          |               |          |                  |       |                    |     |         |      | JOIN dept d ON e.deptno = d.deptno GROUP BY  |
|                  |          |               |          |                  |       |                    |     |         |      | d.dname ORDER BY d.dname                     |
| DONE             |      13s | 6gvch1xu9ca3g | 16777216 |    03/21/2011    | SYS   |                    |     |     12s | 1451 | DECLARE job BINARY_INTEGER := :job;          |
|                  |          |               |          |     13:02:29     |       |                    |     |         |      | next_date DATE := :mydate; broken BOOLEAN := |
|                  |          |               |          |                  |       |                    |     |         |      | FALSE; BEGIN                                 |
|                  |          |               |          |                  |       |                    |     |         |      | EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); |
|                  |          |               |          |                  |       |                    |     |         |      | :mydate := next_date; IF broken THEN :b :=   |
|                  |          |               |          |                  |       |                    |     |         |      | 1; ELSE :b := 0; ...                         |
| DONE             |      18s | c2p32r5mzv8hb | 16777216 |    03/21/2011    |       | MMON_SLAVE/Advisor |     |     17s |  564 | BEGIN prvt_advisor.delete_expired_tasks;     |
|                  |          |               |          |     13:02:20     |       | Task Ma            |     |         |      | END;                                         |
| DONE (FIRST N    |      21s | f6cz4n8y72xdc | 16777216 |    03/21/2011    |       | MMON_SLAVE/Check   |     |     21s |  587 | SELECT space_usage_kbytes FROM               |
| ROWS)            |          |               |          |     13:02:17     |       | SMB Size           |     |         |      | v$sysaux_occupants WHERE occupant_name =     |
|                  |          |               |          |                  |       |                    |     |         |      | 'SQL_MANAGEMENT_BASE'                        |
================================================================================================================================================================================