soadb@husoaa04[/export/home/oracledb/oracle]cat awrsqlrpt_1_24998_24999.html AWR SQL Report

WORKLOAD REPOSITORY SQL Report

Snapshot Period Summary

DB Name DB Id Instance Inst num Release RAC Host

SOADB1 96954648 soadb1 1 10.2.0.4.0 NO husoaa04

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
SOADB1	96954648	soadb1	1	10.2.0.4.0	NO	husoaa04

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 24998 13-Dec-13 23:00:18 31 2.5

End Snap: 24999 13-Dec-13 23:12:32 30 3.4

Elapsed: 12.24 (mins)

DB Time: 0.18 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	24998	13-Dec-13 23:00:18	31	2.5
End Snap:	24999	13-Dec-13 23:12:32	30	3.4
Elapsed:		12.24 (mins)
DB Time:		0.18 (mins)

SQL Summary

SQL Id	Elapsed Time (ms)	Module	Action	SQL Text
7cq8d0jqxzum1	716,971			delete from smon_scn_time where thread=0 and scn = (select min(scn) f...

SQL ID: 7cq8d0jqxzum1

1st Capture and Last Capture Snap IDs refer to Snapshot IDs witin the snapshot range
delete from smon_scn_time where thread=0 and scn = (select min(scn) f...

#	Plan Hash Value	Total Elapsed Time(ms)	Executions	1st Capture Snap ID	Last Capture Snap ID
1	1877588614	716,971	9,289	24999	24999

Plan Statistics

% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Stat Name	Statement Total	Per Execution	% Snap Total
Elapsed Time (ms)	716,971	77.18	6788.38
CPU Time (ms)	707,354	76.15	7858.42
Executions	9,289
Buffer Gets	132,115,663	14,222.81	99.88
Disk Reads	0	0.00	0.00
Parse Calls	0	0.00	0.00
Rows	9,289	1.00
User I/O Wait Time (ms)	0
Cluster Wait Time (ms)	0
Application Wait Time (ms)	0
Concurrency Wait Time (ms)	0
Invalidations	0
Version Count	1
Sharable Mem(KB)	21

Back to Plan 1(PHV: 1877588614)
Back to Top

Execution Plan

Id	Operation	Name	Rows	Bytes	Cost (%CPU)	Time
0	DELETE STATEMENT				57 (100)
1	DELETE	SMON_SCN_TIME
2	TABLE ACCESS BY INDEX ROWID	SMON_SCN_TIME	1	14	2 (0)	00:00:01
3	INDEX UNIQUE SCAN	SMON_SCN_TIME_SCN_IDX	1		1 (0)	00:00:01
4	SORT AGGREGATE		1	7
5	TABLE ACCESS CLUSTER	SMON_SCN_TIME	1253	8771	55 (0)	00:00:01
6	INDEX UNIQUE SCAN	SMON_SCN_TO_TIME_IDX	1		0 (0)

Back to Plan 1(PHV: 1877588614)
Back to Top

Full SQL Text

SQL Id SQL Text

7cq8d0jqxzum1 delete from smon_scn_time where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)