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'