SQL Monitoring List



Status Duration SQL Id User Dop DB Time IOs Start End SQL Text
DONE (ALL ROWS)
0.06s
526mvccm5nfy4 Exec_id:16777216 SCOTT UId:83
Sid:43:255
Mod/Act:SQL*Plus/-
Prg:sqlplus@oel5-11gR2-demo.localdomain (TNS V1-V3)
Svc:SYS$USERS
0s
15
03/21/2011 13:36:08 03/21/2011 13:36:08 SELECT /*+ MONITOR */ d.dname, WM_CONCAT(e.ename) AS employees FROM emp e ... SELECT /*+ MONITOR */ d.dname, 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 Exec_id:16777216 SYS UId:0
Sid:30:3
Prg:oracle@oel5-11gR2-demo.localdomain (J000)
Svc:SYS$USERS

.

.

.

.
13s

.
1451
03/21/2011 13:02:29 03/21/2011 13:02:42 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :... DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broke n THEN :b := 1; ELSE :b := 0; END IF; END;
DONE

.
18s
c2p32r5mzv8hb Exec_id:16777216 UId:0
Sid:23:5
Mod/Act:MMON_SLAVE/Advisor Task Maintenance
Prg:oracle@oel5-11gR2-demo.localdomain (M001)
Svc:SYS$BACKGROUND

.

.

.
18s

.
564
03/21/2011 13:02:20 03/21/2011 13:02:38 BEGIN prvt_advisor.delete_expired_tasks; END; BEGIN prvt_advisor.delete_expired_tasks; END;
DONE (FIRST N ROWS)

.
21s
f6cz4n8y72xdc Exec_id:16777216 UId:0
Sid:25:1
Mod/Act:MMON_SLAVE/Check SMB Size
Prg:oracle@oel5-11gR2-demo.localdomain (M003)
Svc:SYS$BACKGROUND

.

.

.
21s

.
587
03/21/2011 13:02:17 03/21/2011 13:02:38 SELECT space_usage_kbytes FROM v$sysaux_occupants WHERE occupant_name = 'SQL_... SELECT space_usage_kbytes FROM v$sysaux_occupants WHERE occupant_name = 'SQL_MANAGEMENT_BASE'