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

WORKLOAD REPOSITORY report for

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)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 736M 736M Std Block Size: 8K

Shared Pool Size: 736M 736M Log Buffer: 14,372K

	Begin	End
Buffer Cache:	736M	736M	Std Block Size:	8K
Shared Pool Size:	736M	736M	Log Buffer:	14,372K

Load Profile

Per Second Per Transaction

Redo size: 30,038.39 191,881.81

Logical reads: 180,056.65 1,150,181.51

Block changes: 106.97 683.30

Physical reads: 19.47 124.36

Physical writes: 29.05 185.57

User calls: 2.05 13.12

Parses: 1.92 12.28

Hard parses: 0.23 1.48

Sorts: 0.91 5.84

Logons: 0.01 0.04

Executes: 15.77 100.75

Transactions: 0.16

	Per Second	Per Transaction
Redo size:	30,038.39	191,881.81
Logical reads:	180,056.65	1,150,181.51
Block changes:	106.97	683.30
Physical reads:	19.47	124.36
Physical writes:	29.05	185.57
User calls:	2.05	13.12
Parses:	1.92	12.28
Hard parses:	0.23	1.48
Sorts:	0.91	5.84
Logons:	0.01	0.04
Executes:	15.77	100.75
Transactions:	0.16

% Blocks changed per Read: 0.06 Recursive Call %: 94.27

Rollback per transaction %: 0.87 Rows per Sort: 1158.13

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.99

Buffer Hit %: 100.00 In-memory Sort %: 99.85

Library Hit %: 96.72 Soft Parse %: 87.96

Execute to Parse %: 87.81 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 92.73 % Non-Parse CPU: 88.67

Shared Pool Statistics

Begin End

Memory Usage %: 71.71 72.54

% SQL with executions>1: 82.32 91.75

% Memory for SQL w/exec>1: 72.98 77.96

	Begin	End
Memory Usage %:	71.71	72.54
% SQL with executions>1:	82.32	91.75
% Memory for SQL w/exec>1:	72.98	77.96

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 9 85.2

log file parallel write 359 1 2 5.9 System I/O

control file parallel write 354 0 1 4.5 System I/O

SQL*Net more data from client 128 0 3 3.1 Network

db file sequential read 328 0 0 1.1 User I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		9		85.2
log file parallel write	359	1	2	5.9	System I/O
control file parallel write	354	0	1	4.5	System I/O
SQL*Net more data from client	128	0	3	3.1	Network
db file sequential read	328	0	0	1.1	User I/O

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
init.ora Parameters

Time Model Statistics

Total time in database user-calls (DB Time): 10.6s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	9.51	90.00
DB CPU	9.00	85.22
parse time elapsed	1.11	10.53
hard parse elapsed time	1.08	10.24
hard parse (sharing criteria) elapsed time	0.39	3.66
PL/SQL execution elapsed time	0.08	0.80
PL/SQL compilation elapsed time	0.04	0.40
failed parse elapsed time	0.01	0.14
connection management call elapsed time	0.01	0.06
sequence load elapsed time	0.00	0.01
repeated bind elapsed time	0.00	0.01
DB time	10.56
background elapsed time	723.05
background cpu time	722.16

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

Wait Class	Waits	Total Wait Time (s)	Avg wait (ms)	Waits /txn
System I/O	1,960	1	1	17.04
Network	1,436	0	0	12.49
User I/O	13,394	0	0	116.47
Commit	106	0	1	0.92
Other	28	0	2	0.24
Concurrency	2	0	23	0.02
Configuration	3	0	4	0.03
Application	136	0	0	1.18

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	359	0.00	1	2	3.12
control file parallel write	354	0.00	0	1	3.08
SQL*Net more data from client	128	0.00	0	3	1.11
db file sequential read	328	0.00	0	0	2.85
log file sync	106	0.00	0	1	0.92
latch free	27	0.00	0	2	0.23
os thread startup	1	0.00	0	46	0.01
log file switch completion	3	0.00	0	4	0.03
direct path read temp	12,963	0.00	0	0	112.72
control file sequential read	1,243	0.00	0	0	10.81
db file scattered read	66	0.00	0	0	0.57
SQL*Net break/reset to client	136	0.00	0	0	1.18
SQL*Net more data to client	159	0.00	0	0	1.38
log file single write	2	0.00	0	0	0.02
SQL*Net message to client	1,149	0.00	0	0	9.99
buffer busy waits	1	0.00	0	0	0.01
LGWR wait for redo copy	1	0.00	0	0	0.01
direct path write	20	0.00	0	0	0.17
direct path read	15	0.00	0	0	0.13
log file sequential read	2	0.00	0	0	0.02
direct path write temp	2	0.00	0	0	0.02
SQL*Net message from client	1,150	0.00	6,320	5495	10.00
Streams AQ: qmn slave idle wait	26	0.00	713	27412	0.23
Streams AQ: qmn coordinator idle wait	26	100.00	713	27411	0.23
virtual circuit status	24	100.00	703	29297	0.21
class slave wait	1	0.00	0	1	0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	359	0.00	1	2	3.12
control file parallel write	354	0.00	0	1	3.08
os thread startup	1	0.00	0	46	0.01
log file switch completion	3	0.00	0	4	0.03
events in waitclass Other	27	0.00	0	0	0.23
log file single write	2	0.00	0	0	0.02
direct path read	15	0.00	0	0	0.13
log file sequential read	2	0.00	0	0	0.02
direct path write	14	0.00	0	0	0.12
rdbms ipc message	2,489	93.77	5,727	2301	21.64
pmon timer	247	100.00	718	2905	2.15
Streams AQ: qmn slave idle wait	26	0.00	713	27412	0.23
Streams AQ: qmn coordinator idle wait	26	100.00	713	27411	0.23

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	10,259
AVG_IDLE_TIME	62,992
AVG_IOWAIT_TIME	1,078
AVG_SYS_TIME	597
AVG_USER_TIME	9,647
BUSY_TIME	82,264
IDLE_TIME	504,116
IOWAIT_TIME	8,793
SYS_TIME	4,909
USER_TIME	77,355
LOAD	0
OS_CPU_WAIT_TIME	20,947,185,600
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	339,968
VM_OUT_BYTES	0
PHYSICAL_MEMORY_BYTES	68,684,804,096
NUM_CPUS	8
NUM_CPU_SOCKETS	8

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
soadb1	10.50	9.00	14,092	142,291
SYS$USERS	0.10	0.10	26	1,136
SYS$BACKGROUND	0.00	0.00	208	132,136,941
soadb1XDB	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
soadb1	13153	10	1	0	1320	27
SYS$USERS	29	0	0	0	100	0
SYS$BACKGROUND	218	3	1	5	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
717	707	9,289	0.08	6788.38	7cq8d0jqxzum1		delete from smon_scn_time wher...
9	7	1	8.87	83.94	7kdqrb7axts8f	PL/SQL Developer	BEGIN DBMS_STATS.GATHER_TABL...
3	1	1	2.75	26.04	6ztf9hft5sagv	PL/SQL Developer	select /*+ no_parallel(t) no_p...
2	2	1	2.13	20.15	82y1gz30t35sw	PL/SQL Developer	select min(minbkt), maxbkt, su...
2	2	1	1.66	15.69	az15k5mbkwdc3	PL/SQL Developer	select /*+ no_parallel_index(t...
2	2	1	1.61	15.27	6r1wx6quyx5aw	PL/SQL Developer	select /*+ no_parallel_index(t...
0	0	1	0.43	4.12	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	1	0.43	4.04	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
0	0	1	0.33	3.11	dqn15h5mwbf4f	PL/SQL Developer	SELECT * FROM dba_indexes WHER...
0	0	0		2.82	73skk9hdgm3fm	PL/SQL Developer	SELECT * FROM dba_indexes
0	0	1	0.22	2.09	85b5z4wnmjm30	PL/SQL Developer	SELECT * FROM dba_tables WHERE...
0	0	0		1.59	dcjdyjwqttusf	PL/SQL Developer	SELECT * FROM dba_tables

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
707	717	9,289	0.08	6788.38	7cq8d0jqxzum1		delete from smon_scn_time wher...
7	9	1	7.38	83.94	7kdqrb7axts8f	PL/SQL Developer	BEGIN DBMS_STATS.GATHER_TABL...
2	2	1	2.13	20.15	82y1gz30t35sw	PL/SQL Developer	select min(minbkt), maxbkt, su...
2	2	1	1.66	15.69	az15k5mbkwdc3	PL/SQL Developer	select /*+ no_parallel_index(t...
2	2	1	1.61	15.27	6r1wx6quyx5aw	PL/SQL Developer	select /*+ no_parallel_index(t...
1	3	1	1.39	26.04	6ztf9hft5sagv	PL/SQL Developer	select /*+ no_parallel(t) no_p...
0	0	1	0.43	4.12	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	1	0.42	4.04	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
0	0	1	0.33	3.11	dqn15h5mwbf4f	PL/SQL Developer	SELECT * FROM dba_indexes WHER...
0	0	0		2.82	73skk9hdgm3fm	PL/SQL Developer	SELECT * FROM dba_indexes
0	0	1	0.20	2.09	85b5z4wnmjm30	PL/SQL Developer	SELECT * FROM dba_tables WHERE...
0	0	0		1.59	dcjdyjwqttusf	PL/SQL Developer	SELECT * FROM dba_tables

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
Total Buffer Gets: 132,270,874
Captured SQL account for 100.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
132,115,663	9,289	14,222.81	99.88	707.35	716.97	7cq8d0jqxzum1		delete from smon_scn_time wher...
130,358	1	130,358.00	0.10	7.38	8.87	7kdqrb7axts8f	PL/SQL Developer	BEGIN DBMS_STATS.GATHER_TABL...
39,916	1	39,916.00	0.03	1.39	2.75	6ztf9hft5sagv	PL/SQL Developer	select /*+ no_parallel(t) no_p...
18,762	1	18,762.00	0.01	1.66	1.66	az15k5mbkwdc3	PL/SQL Developer	select /*+ no_parallel_index(t...
18,749	1	18,749.00	0.01	1.61	1.61	6r1wx6quyx5aw	PL/SQL Developer	select /*+ no_parallel_index(t...
18,691	1	18,691.00	0.01	2.13	2.13	82y1gz30t35sw	PL/SQL Developer	select min(minbkt), maxbkt, su...
4,213	1	4,213.00	0.00	0.03	0.03	bf8x9bgk7817y	PL/SQL Developer	select /*+ no_parallel(t) no_...
3,556	1	3,556.00	0.00	0.42	0.43	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
2,299	1	2,299.00	0.00	0.33	0.33	dqn15h5mwbf4f	PL/SQL Developer	SELECT * FROM dba_indexes WHER...
1,813	205	8.84	0.00	0.05	0.05	d4fx505x4f6yy		INSERT INTO audit_trail( cikey...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 14,301
Captured SQL account for 91.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
13,990	1	13,990.00	97.83	7.38	8.87	7kdqrb7axts8f	PL/SQL Developer	BEGIN DBMS_STATS.GATHER_TABL...
12,975	1	12,975.00	90.73	1.39	2.75	6ztf9hft5sagv	PL/SQL Developer	select /*+ no_parallel(t) no_p...
74	1	74.00	0.52	0.42	0.43	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
48	2	24.00	0.34	0.03	0.07	21sh40mz4cdkx	PL/SQL Developer	select text from sys.all_sourc...
22	1	22.00	0.15	0.04	0.05	0dwr2vd6vbqzs		SELECT count(*) over () as tot...
14	16	0.88	0.10	0.01	0.01	grwydz59pu6mc		select text from view$ where r...
11	103	0.11	0.08	0.02	0.02	3pphjhb4cv3jw		INSERT INTO CUBE_SCOPE( CIKEY,...
11	103	0.11	0.08	0.04	0.04	435dczbfgs18y		BEGIN INSERT INTO cube_scope(...
5	1	5.00	0.03	0.20	0.22	85b5z4wnmjm30	PL/SQL Developer	SELECT * FROM dba_tables WHERE...
4	8	0.50	0.03	0.00	0.00	04p9rnacfgfsn		INSERT INTO sys.wri$_adv_objec...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 11,586
Captured SQL account for 89.1% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Text
9,289	9,289	1.00	0.08	0.08	7cq8d0jqxzum1	delete from smon_scn_time wher...
205	205	1.00	0.00	0.00	d4fx505x4f6yy	INSERT INTO audit_trail( cikey...
103	103	1.00	0.00	0.00	3pphjhb4cv3jw	INSERT INTO CUBE_SCOPE( CIKEY,...
103	103	1.00	0.00	0.00	435dczbfgs18y	BEGIN INSERT INTO cube_scope(...
103	103	1.00	0.00	0.00	6g4su86aysa1z	INSERT INTO cube_instance( ci...
81	68	0.84	0.00	0.00	96g93hntrzjtr	select /+ rule / bucket_cnt,...
48	48	1.00	0.00	0.00	3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_messa...
41	41	1.00	0.00	0.00	f80h0xb1qvbsk	SELECT sys.wri$_adv_seq_msggro...
25	525	21.00	0.00	0.00	aykvshm7zsabd	select size_for_estimate, ...
22	22	1.00	0.00	0.00	2ym6hhaq30r73	select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,412
Captured SQL account for 55.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
103	103	7.29	3pphjhb4cv3jw		INSERT INTO CUBE_SCOPE( CIKEY,...
103	103	7.29	435dczbfgs18y		BEGIN INSERT INTO cube_scope(...
103	103	7.29	6g4su86aysa1z		INSERT INTO cube_instance( ci...
103	205	7.29	d4fx505x4f6yy		INSERT INTO audit_trail( cikey...
48	48	3.40	3m8smr0v7v1m6		INSERT INTO sys.wri$_adv_messa...
41	41	2.90	f80h0xb1qvbsk		SELECT sys.wri$_adv_seq_msggro...
22	22	1.56	2ym6hhaq30r73		select type#, blocks, extents,...
16	16	1.13	grwydz59pu6mc		select text from view$ where r...
15	15	1.06	49s332uhbnsma		declare vsn va...
14	14	0.99	9m7787camwh4m	PL/SQL Developer	begin :id := sys.dbms_transact...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
2,482,297	1	0.32	31a13pnjps7j3		SELECT source, (case w...
1,653,174	1	0.21	8vkjh60z1g287		select OBJOID, CLSOID, RUNT...
1,363,893	103	0.18	6g4su86aysa1z		INSERT INTO cube_instance( ci...
1,335,876	4	0.17	78m9ryygp65v5	sqlplus@husoaa04 (TNS V1-V3)	SELECT /+ ALL_ROWS / COUNT(*...
1,148,376	2	0.15	10xj8nynmpqtq		SELECT dbin.db_name, dbin.ins...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Text
32	103	6g4su86aysa1z	INSERT INTO cube_instance( ci...
27	1	298ppdduqr7wm	SELECT status FROM sys.wri$_ad...
27	8	dv7aptbr6m6bn	INSERT INTO audit_details ( ci...
26	2	10xj8nynmpqtq	SELECT dbin.db_name, dbin.ins...
25	1	bhvyz9bgyrhb2	SELECT name, datatype, value, ...
24	1	0cn2wm9d7zq8d	SELECT decode(value, 'FATAL', ...
22	1	akh9zqqkx3wj7	select 1, max(id) from sys.wr...
21	1	14566d856s6hs	SELECT owner# FROM sys.wri$_ad...
21	1	31a13pnjps7j3	SELECT source, (case w...
21	1	76natvnhtqqhw	INSERT INTO SYS.WRI$_ADV_TASKS...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

04p9rnacfgfsn INSERT INTO sys.wri$_adv_objects (task_id, id, type, attr1, attr2, attr3, attr4, attr5)VALUES(:1, :2, :3, :4, :5, :6, ' ', :7) RETURNING rowid into :8

0cn2wm9d7zq8d SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'

0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id

10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time

14566d856s6hs SELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1

21sh40mz4cdkx select text from sys.all_source where owner = :owner and name = :name and type = :type order by line

298ppdduqr7wm SELECT status FROM sys.wri$_adv_tasks WHERE id = :1

2ym6hhaq30r73 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC

3m8smr0v7v1m6 INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)

3pphjhb4cv3jw INSERT INTO CUBE_SCOPE( CIKEY, DOMAIN_REF, SCOPE_BIN, CI_PARTITION_DATE ) VALUES ( :B1, :B2, '0', :B3 ) RETURNING SCOPE_BIN INTO :O0

435dczbfgs18y BEGIN INSERT INTO cube_scope( cikey, domain_ref, scope_bin, ci_partition_date ) VALUES ( :1, :2, '0', :3 ) RETURNING scope_bin INTO :4; END;

49s332uhbnsma declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end;

6g4su86aysa1z INSERT INTO cube_instance( cikey, domain_ref, process_id, revision_tag, creation_date, creator, modify_date, modifier, state, priority, title, status, stage, conversation_id, scope_revision, scope_csize, scope_usize, process_guid, process_type, metadata, root_id, parent_id, test_run_id, at_count_id, at_event_id, at_detail_id ) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26 )

6r1wx6quyx5aw select /*+ no_parallel_index(t, "SMON_SCN_TIME_TIM_IDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "SMON_SCN_TIME_TIM_IDX") */ count(*) as nrw, count(distinct sys_op_lbid(134845, 'L', t.rowid)) as nlb, null as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."SMON_SCN_TIME" t where "TIME_MP" is not null

6ztf9hft5sagv select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("TIME_DP"), count(distinct "TIME_DP"), count("SCN_BAS"), count(distinct "SCN_BAS"), count("TIM_SCN_MAP"), count(distinct "TIM_SCN_MAP"), count("SCN") from "SYS"."SMON_SCN_TIME" t

73skk9hdgm3fm SELECT * FROM dba_indexes

76natvnhtqqhw INSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , SYSDATE, SYSDATE, 0, 0, :B3 , NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )

78m9ryygp65v5 SELECT /*+ ALL_ROWS */ COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION = :B1

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

7kdqrb7axts8f BEGIN DBMS_STATS.GATHER_TABLE_STATS('sys', 'smon_scn_time', cascade => TRUE); END;

82y1gz30t35sw select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"SCN" val, ntile(254) over (order by "SCN") bkt from "SYS"."SMON_SCN_TIME" t where "SCN" is not null) group by val) group by maxbkt order by maxbkt

85b5z4wnmjm30 SELECT * FROM dba_tables WHERE table_name LIKE '%SMON_SCN_TIME%'

8vkjh60z1g287 select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

9m7787camwh4m begin :id := sys.dbms_transaction.local_transaction_id; end;

akh9zqqkx3wj7 select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1

aykvshm7zsabd select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'

az15k5mbkwdc3 select /*+ no_parallel_index(t, "SMON_SCN_TIME_SCN_IDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "SMON_SCN_TIME_SCN_IDX") */ count(*) as nrw, count(distinct sys_op_lbid(134844, 'L', t.rowid)) as nlb, null as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."SMON_SCN_TIME" t where "SCN" is not null

bf8x9bgk7817y select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*) from "SYS"."SMON_SCN_TIME" sample block ( 10.6151823717, 1) t

bhvyz9bgyrhb2 SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1

bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice

d4fx505x4f6yy INSERT INTO audit_trail( cikey, domain_ref, count_id, block, block_csize, block_usize, log, ci_partition_date ) VALUES( :1, :2, :3, :4, :5, :6, :7, :8 )

d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;

dcjdyjwqttusf SELECT * FROM dba_tables

dqn15h5mwbf4f SELECT * FROM dba_indexes WHERE table_name LIKE '%SMON_SCN_TIME%'

dv7aptbr6m6bn INSERT INTO audit_details ( cikey, domain_ref, detail_id, bin_csize, bin_usize, bin, ci_partition_date ) VALUES ( :1, :2, :3, :4, :5, :6, :7 )

f80h0xb1qvbsk SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual

grwydz59pu6mc select text from view$ where rowid=:1

SQL Id	SQL Text
04p9rnacfgfsn	INSERT INTO sys.wri$_adv_objects (task_id, id, type, attr1, attr2, attr3, attr4, attr5)VALUES(:1, :2, :3, :4, :5, :6, ' ', :7) RETURNING rowid into :8
0cn2wm9d7zq8d	SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0dwr2vd6vbqzs	SELECT count() over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash., evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe., nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap. FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count() as cnt FROM (SELECT t1. FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
10xj8nynmpqtq	SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
14566d856s6hs	SELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
21sh40mz4cdkx	select text from sys.all_source where owner = :owner and name = :name and type = :type order by line
298ppdduqr7wm	SELECT status FROM sys.wri$_adv_tasks WHERE id = :1
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
31a13pnjps7j3	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
3m8smr0v7v1m6	INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3pphjhb4cv3jw	INSERT INTO CUBE_SCOPE( CIKEY, DOMAIN_REF, SCOPE_BIN, CI_PARTITION_DATE ) VALUES ( :B1, :B2, '0', :B3 ) RETURNING SCOPE_BIN INTO :O0
435dczbfgs18y	BEGIN INSERT INTO cube_scope( cikey, domain_ref, scope_bin, ci_partition_date ) VALUES ( :1, :2, '0', :3 ) RETURNING scope_bin INTO :4; END;
49s332uhbnsma	declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) \|\| substr(vsn, 4, 2) \|\| substr(vsn, 7, 2) \|\| nvl(substr(vsn, 10, 2), '00')); end if; end;
6g4su86aysa1z	INSERT INTO cube_instance( cikey, domain_ref, process_id, revision_tag, creation_date, creator, modify_date, modifier, state, priority, title, status, stage, conversation_id, scope_revision, scope_csize, scope_usize, process_guid, process_type, metadata, root_id, parent_id, test_run_id, at_count_id, at_event_id, at_detail_id ) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26 )
6r1wx6quyx5aw	select /+ no_parallel_index(t, "SMON_SCN_TIME_TIM_IDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "SMON_SCN_TIME_TIM_IDX") / count(*) as nrw, count(distinct sys_op_lbid(134845, 'L', t.rowid)) as nlb, null as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."SMON_SCN_TIME" t where "TIME_MP" is not null
6ztf9hft5sagv	select /+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring / count(*), count("TIME_DP"), count(distinct "TIME_DP"), count("SCN_BAS"), count(distinct "SCN_BAS"), count("TIM_SCN_MAP"), count(distinct "TIM_SCN_MAP"), count("SCN") from "SYS"."SMON_SCN_TIME" t
73skk9hdgm3fm	SELECT * FROM dba_indexes
76natvnhtqqhw	INSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , SYSDATE, SYSDATE, 0, 0, :B3 , NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )
78m9ryygp65v5	SELECT /+ ALL_ROWS / COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION = :B1
7cq8d0jqxzum1	delete from smon_scn_time where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)
7kdqrb7axts8f	BEGIN DBMS_STATS.GATHER_TABLE_STATS('sys', 'smon_scn_time', cascade => TRUE); END;
82y1gz30t35sw	select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count() bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)count(val) repsq from (select /+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring /"SCN" val, ntile(254) over (order by "SCN") bkt from "SYS"."SMON_SCN_TIME" t where "SCN" is not null) group by val) group by maxbkt order by maxbkt
85b5z4wnmjm30	SELECT * FROM dba_tables WHERE table_name LIKE '%SMON_SCN_TIME%'
8vkjh60z1g287	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9m7787camwh4m	begin :id := sys.dbms_transaction.local_transaction_id; end;
akh9zqqkx3wj7	select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
az15k5mbkwdc3	select /+ no_parallel_index(t, "SMON_SCN_TIME_SCN_IDX") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t, "SMON_SCN_TIME_SCN_IDX") / count(*) as nrw, count(distinct sys_op_lbid(134844, 'L', t.rowid)) as nlb, null as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."SMON_SCN_TIME" t where "SCN" is not null
bf8x9bgk7817y	select /+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring / count(*) from "SYS"."SMON_SCN_TIME" sample block ( 10.6151823717, 1) t
bhvyz9bgyrhb2	SELECT name, datatype, value, flags, nvl(description, 'NULL') FROM sys.wri$_adv_parameters WHERE task_id = :1 ORDER BY 1
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
d4fx505x4f6yy	INSERT INTO audit_trail( cikey, domain_ref, count_id, block, block_csize, block_usize, log, ci_partition_date ) VALUES( :1, :2, :3, :4, :5, :6, :7, :8 )
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dcjdyjwqttusf	SELECT * FROM dba_tables
dqn15h5mwbf4f	SELECT * FROM dba_indexes WHERE table_name LIKE '%SMON_SCN_TIME%'
dv7aptbr6m6bn	INSERT INTO audit_details ( cikey, domain_ref, detail_id, bin_csize, bin_usize, bin, ci_partition_date ) VALUES ( :1, :2, :3, :4, :5, :6, :7 )
f80h0xb1qvbsk	SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual
grwydz59pu6mc	select text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	74,168	100.96	644.94
CPU used when call started	11,686	15.91	101.62
CR blocks created	5,981	8.14	52.01
Cached Commit SCN referenced	3,040	4.14	26.43
Commit SCN cached	2	0.00	0.02
DB time	1,089	1.48	9.47
DBWR checkpoint buffers written	7,347	10.00	63.89
DBWR checkpoints	1	0.00	0.01
DBWR transaction table writes	19	0.03	0.17
DBWR undo block writes	1,950	2.65	16.96
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	53	0.07	0.46
IMU Redo allocation size	78,744	107.19	684.73
IMU commits	0	0.00	0.00
IMU contention	0	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	102	0.14	0.89
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	23,944	32.59	208.21
IMU- failed to get a private strand	102	0.14	0.89
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	1,137	1.55	9.89
active txn count during cleanout	6,000	8.17	52.17
application wait time	1	0.00	0.01
background checkpoints completed	1	0.00	0.01
background checkpoints started	1	0.00	0.01
background timeouts	2,337	3.18	20.32
branch node splits	0	0.00	0.00
buffer is not pinned count	132,063,733	179,774.67	1,148,380.29
buffer is pinned count	26,036	35.44	226.40
bytes received via SQL*Net from client	699,366	952.03	6,081.44
bytes sent via SQL*Net to client	476,435	648.56	4,142.91
calls to get snapshot scn: kcmgss	13,818	18.81	120.16
calls to kcmgas	8,141	11.08	70.79
calls to kcmgcs	87	0.12	0.76
change write time	177	0.24	1.54
cleanout - number of ktugct calls	6,018	8.19	52.33
cleanouts and rollbacks - consistent read gets	5,956	8.11	51.79
cleanouts only - consistent read gets	5	0.01	0.04
cluster key scan block gets	132,028,206	179,726.31	1,148,071.36
cluster key scans	9,722	13.23	84.54
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	13	0.02	0.11
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	1,300	1.77	11.30
commit cleanouts successfully completed	1,287	1.75	11.19
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	68	0.09	0.59
concurrency wait time	4	0.01	0.03
consistent changes	90,475	123.16	786.74
consistent gets	132,205,321	179,967.41	1,149,611.49
consistent gets - examination	122,662	166.98	1,066.63
consistent gets direct	4	0.01	0.03
consistent gets from cache	132,205,318	179,967.41	1,149,611.46
current blocks converted for CR	0	0.00	0.00
cursor authentications	21	0.03	0.18
data blocks consistent reads - undo records applied	90,463	123.14	786.63
db block changes	78,580	106.97	683.30
db block gets	65,605	89.31	570.48
db block gets direct	1,003	1.37	8.72
db block gets from cache	64,602	87.94	561.76
deferred (CURRENT) block cleanout applications	713	0.97	6.20
dirty buffers inspected	0	0.00	0.00
enqueue conversions	150	0.20	1.30
enqueue releases	7,518	10.23	65.37
enqueue requests	7,518	10.23	65.37
enqueue timeouts	0	0.00	0.00
enqueue waits	0	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	11,586	15.77	100.75
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	2,379	3.24	20.69
free buffer requested	9,300	12.66	80.87
heap block compress	5,865	7.98	51.00
hot buffers moved to head of LRU	1	0.00	0.01
immediate (CR) block cleanout applications	5,961	8.11	51.83
immediate (CURRENT) block cleanout applications	116	0.16	1.01
index crx upgrade (positioned)	245	0.33	2.13
index fast full scans (full)	0	0.00	0.00
index fetch by key	24,130	32.85	209.83
index scans kdiixs1	969	1.32	8.43
leaf node 90-10 splits	8	0.01	0.07
leaf node splits	19	0.03	0.17
lob reads	117	0.16	1.02
lob writes	285	0.39	2.48
lob writes unaligned	283	0.39	2.46
logons cumulative	5	0.01	0.04
messages received	1,059	1.44	9.21
messages sent	1,059	1.44	9.21
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	132,075,198	179,790.28	1,148,479.98
opened cursors cumulative	1,701	2.32	14.79
parse count (failures)	72	0.10	0.63
parse count (hard)	170	0.23	1.48
parse count (total)	1,412	1.92	12.28
parse time cpu	102	0.14	0.89
parse time elapsed	110	0.15	0.96
physical read IO requests	13,338	18.16	115.98
physical read bytes	117,153,792	159,478.19	1,018,728.63
physical read total IO requests	14,599	19.87	126.95
physical read total bytes	137,660,416	187,393.28	1,197,047.10
physical read total multi block requests	68	0.09	0.59
physical reads	14,301	19.47	124.36
physical reads cache	1,307	1.78	11.37
physical reads cache prefetch	951	1.29	8.27
physical reads direct	12,994	17.69	112.99
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	12,975	17.66	112.83
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	1,440	1.96	12.52
physical write bytes	174,817,280	237,973.88	1,520,150.26
physical write total IO requests	2,873	3.91	24.98
physical write total bytes	214,862,848	292,486.80	1,868,372.59
physical write total multi block requests	1,414	1.92	12.30
physical writes	21,340	29.05	185.57
physical writes direct	13,993	19.05	121.68
physical writes direct (lob)	12	0.02	0.10
physical writes direct temporary tablespace	13,966	19.01	121.44
physical writes from cache	7,347	10.00	63.89
physical writes non checkpoint	18,004	24.51	156.56
pinned buffers inspected	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	24,831	33.80	215.92
recursive cpu usage	1,029	1.40	8.95
redo blocks read for recovery	0	0.00	0.00
redo blocks written	22,065	30.04	191.87
redo buffer allocation retries	2	0.00	0.02
redo entries	41,541	56.55	361.23
redo log space requests	3	0.00	0.03
redo log space wait time	1	0.00	0.01
redo ordering marks	1,914	2.61	16.64
redo size	22,066,408	30,038.39	191,881.81
redo subscn max counts	5,109	6.95	44.43
redo synch time	9	0.01	0.08
redo synch writes	106	0.14	0.92
redo wastage	190,864	259.82	1,659.69
redo write time	17	0.02	0.15
redo writer latching time	0	0.00	0.00
redo writes	359	0.49	3.12
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	25	0.03	0.22
rows fetched via callback	11,495	15.65	99.96
session connect time	0	0.00	0.00
session cursor cache hits	1,065	1.45	9.26
session logical reads	132,270,874	180,056.65	1,150,181.51
session pga memory	946,600	1,288.58	8,231.30
session pga memory max	111,767,976	152,146.63	971,895.44
session uga memory	2,022,496	2,753.17	17,586.92
session uga memory max	115,878,792	157,742.56	1,007,641.67
shared hash latch upgrades - no wait	17,113	23.30	148.81
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	1	0.00	0.01
sorts (memory)	671	0.91	5.83
sorts (rows)	778,264	1,059.43	6,767.51
sql area evicted	4	0.01	0.03
sql area purged	74	0.10	0.64
summed dirty queue length	0	0.00	0.00
switch current to new buffer	13	0.02	0.11
table fetch by rowid	23,962	32.62	208.37
table fetch continued row	1	0.00	0.01
table scan blocks gotten	31,311	42.62	272.27
table scan rows gotten	565,961	770.43	4,921.40
table scans (cache partitions)	0	0.00	0.00
table scans (long tables)	4	0.01	0.03
table scans (short tables)	260	0.35	2.26
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	0	0.00	0.00
undo change vector size	15,252,824	20,763.24	132,633.25
user I/O wait time	13	0.02	0.11
user calls	1,509	2.05	13.12
user commits	114	0.16	0.99
user rollbacks	1	0.00	0.01
workarea executions - onepass	1	0.00	0.01
workarea executions - optimal	363	0.49	3.16
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	151,251	151,326
opened cursors current	77	103
workarea memory allocated	0	733
logons current	31	30

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	1	4.90

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits
TEMP	13,025	18	0.01	1.07	510	1	0
SYSTEM	97	0	1.03	1.00	400	1	0
SYSAUX	189	0	0.11	1.12	268	0	0
UNDOTBS1	2	0	0.00	1.00	158	0	1
ORABPEL	50	0	0.00	1.00	101	0	0
UNICOMDEV_DATA	1	0	0.00	1.00	1	0	0
UNICOMNODE_DATA	1	0	0.00	1.00	1	0	0
USERS	1	0	0.00	1.00	1	0	0

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
ORABPEL	/soaapp/db/soadb1/orabpel.dbf	23	0	0.00	1.00	5	0	0	0.00
ORABPEL	/soaapp/db/soadb1/orabpel1.dbf	15	0	0.00	1.00	33	0	0	0.00
ORABPEL	/soaapp/db/soadb1/orabpel2.dbf	2	0	0.00	1.00	6	0	0	0.00
ORABPEL	/soaapp/db/soadb1/orabpel3.dbf	1	0	0.00	1.00	4	0	0	0.00
ORABPEL	/soaapp/db/soadb1/orabpel4.dbf	5	0	0.00	1.00	12	0	0	0.00
ORABPEL	/soaapp/db/soadb1/orabpel5.dbf	1	0	0.00	1.00	1	0	0	0.00
ORABPEL	/soaapp/db/soadb1/orabpel6.dbf	2	0	0.00	1.00	39	0	0	0.00
ORABPEL	/soaapp/db/soadb1/orabpel7.dbf	1	0	0.00	1.00	1	0	0	0.00
SYSAUX	/soaapp/db/soadb1/sysaux01.dbf	189	0	0.11	1.12	268	0	0	0.00
SYSTEM	/soaapp/db/soadb1/system01.dbf	97	0	1.03	1.00	400	1	0	0.00
TEMP	/soaapp/db/soadb1/temp01.dbf	13,025	18	0.01	1.07	510	1	0
UNDOTBS1	/soaapp/db/soadb1/undotbs01.dbf	1	0	0.00	1.00	78	0	1	0.00
UNDOTBS1	/soaapp/db/soadb1/undotbs02.dbf	1	0	0.00	1.00	80	0	0	0.00
UNICOMDEV_DATA	/soaapp/db/soadb1/UNICOMDEV_DATA01.DBF	1	0	0.00	1.00	1	0	0	0.00
UNICOMNODE_DATA	/soaapp/db/soadb1/UNICOMNODE_DATA01.DBF	1	0	0.00	1.00	1	0	0	0.00
USERS	/soaapp/db/soadb1/users01.dbf	1	0	0.00	1.00	1	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	91,034	100	132,272,773	1,316	7,347	0	0	1

Advisory Statistics

Instance Recovery Stats
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	9	1726	8284	36671	92160	36671
E	0	9	1755	8630	51984	92160	51984

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	64	0.09	7,916	5303.53	###############
D	128	0.17	15,832	1.37	111,216,618
D	192	0.26	23,748	1.04	84,038,694
D	256	0.35	31,664	1.03	83,363,859
D	320	0.43	39,580	1.02	82,897,820
D	384	0.52	47,496	1.02	82,521,848
D	448	0.61	55,412	1.01	82,303,235
D	512	0.70	63,328	1.01	82,111,715
D	576	0.78	71,244	1.01	81,871,600
D	640	0.87	79,160	1.01	81,695,561
D	704	0.96	87,076	1.00	81,299,115
D	736	1.00	91,034	1.00	81,199,756
D	768	1.04	94,992	1.00	81,100,098
D	832	1.13	102,908	1.00	80,886,028
D	896	1.22	110,824	0.99	80,713,112
D	960	1.30	118,740	0.99	80,518,694
D	1,024	1.39	126,656	0.99	80,289,966
D	1,088	1.48	134,572	0.98	79,904,140
D	1,152	1.57	142,488	0.98	79,537,909
D	1,216	1.65	150,404	0.97	79,069,515
D	1,280	1.74	158,320	0.96	78,254,765

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
60.11	172	114

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	6,540	5,857	75.42	0.00	0.00	0.00	0.00	669,690
E	6,540	5,856	77.37	0.72	0.93	100.00	0.00	669,690

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	327	327	0
64K	128K	3	3	0
128K	256K	6	6	0
512K	1024K	17	17	0
1M	2M	10	10	0
2M	4M	4	4	0
4M	8M	3	3	0
64M	128M	1	0	1

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %
818	0.13	33,683.56	2,451.24	93.00
1,635	0.25	33,683.56	2,451.24	93.00
3,270	0.50	33,683.56	2,451.24	93.00
4,905	0.75	33,683.56	2,451.24	93.00
6,540	1.00	33,683.56	2,451.24	93.00
7,848	1.20	33,683.56	1,800.23	95.00
9,156	1.40	33,683.56	1,800.23	95.00
10,464	1.60	33,683.56	1,800.23	95.00
11,772	1.80	33,683.56	1,800.23	95.00
13,080	2.00	33,683.56	1,800.23	95.00
19,620	3.00	33,683.56	1,800.23	95.00
26,160	4.00	33,683.56	1,800.23	95.00
39,240	6.00	33,683.56	1,800.23	95.00
52,320	8.00	33,683.56	1,800.23	95.00

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
416	0.57	96	6,393	469,633	0.88	64,874	189.69	47,123,631
496	0.67	169	12,471	510,785	0.96	23,722	69.36	47,133,920
576	0.78	248	19,942	530,024	0.99	4,483	13.11	47,139,146
656	0.89	327	28,973	533,799	1.00	708	2.07	47,140,393
736	1.00	406	38,058	534,165	1.00	342	1.00	47,140,602
816	1.11	419	39,439	534,165	1.00	342	1.00	47,140,624
896	1.22	419	39,439	534,165	1.00	342	1.00	47,140,624
976	1.33	419	39,439	534,165	1.00	342	1.00	47,140,624
1,056	1.43	419	39,439	534,165	1.00	342	1.00	47,140,624
1,136	1.54	419	39,439	534,165	1.00	342	1.00	47,140,624
1,216	1.65	419	39,439	534,165	1.00	342	1.00	47,140,624
1,296	1.76	419	39,439	534,165	1.00	342	1.00	47,140,624
1,376	1.87	419	39,439	534,165	1.00	342	1.00	47,140,624
1,456	1.98	419	39,439	534,165	1.00	342	1.00	47,140,624
1,536	2.09	419	39,439	534,165	1.00	342	1.00	47,140,624

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
768	0.50	26,323	111,349,203
1,152	0.75	18,548	83,002,374
1,536	1.00	18,317	81,199,740
1,920	1.25	18,117	79,632,585
2,304	1.50	17,952	78,349,629
2,688	1.75	17,952	78,349,629
3,072	2.00	17,952	78,349,629

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	1.00	0	0	0	0
32	2.00	0	0	0	0
48	3.00	0	0	0	0
64	4.00	0	0	0	0
80	5.00	0	0	0	0
96	6.00	0	0	0	0
112	7.00	0	0	0	0
128	8.00	0	0	0	0
144	9.00	0	0	0	0
160	10.00	0	0	0	0
176	11.00	0	0	0	0
192	12.00	0	0	0	0
208	13.00	0	0	0	0
224	14.00	0	0	0	0
240	15.00	0	0	0	0
256	16.00	0	0	0	0
272	17.00	0	0	0	0
288	18.00	0	0	0	0
304	19.00	0	0	0	0
320	20.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
undo header	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	1.63	188	0	4	5760/5760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
13-Dec 23:09	1,627	188	0	4	5,760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
ASM db client latch	489	0.00		0
AWR Alerted Metric Element list	2,832	0.00		0
Consistent RBA	360	0.00		0
FOB s.o list latch	57	0.00		0
In memory undo latch	442	0.00		267	0.00
JS mem alloc latch	5	0.00		0
JS queue access latch	5	0.00		0
JS queue state obj latch	5,256	0.00		0
KMG MMAN ready and startup request latch	244	0.00		0
KTF sga latch	0			224	0.00
KWQP Prop Status	2	0.00		0
MQL Tracking Latch	0			15	0.00
Memory Management Latch	0			244	0.00
OS process	24	0.00		0
OS process allocation	259	0.00		0
OS process: request allocation	11	0.00		0
PL/SQL warning settings	180	0.00		0
SGA IO buffer pool latch	66	0.00		66	0.00
SQL memory manager latch	1	0.00		244	0.00
SQL memory manager workarea list latch	16,852	0.00		0
Shared B-Tree	29	0.00		0
active checkpoint queue latch	1,151	0.00		0
active service list	1,486	0.00		247	0.00
archive control	3	0.00		0
begin backup scn array	12	0.00		0
cache buffer handles	92	0.00		0
cache buffers chains	264,788,202	0.00	0.00	10,266	0.00
cache buffers lru chain	15,796	0.00		15,253	0.00
cache table scan latch	0			66	0.00
channel handle pool latch	15	0.00		0
channel operations parent latch	3,447	0.00		0
checkpoint queue latch	37,124	0.00		7,138	0.00
client/application info	29	0.00		0
compile environment latch	5	0.00		0
dictionary lookup	1	0.00		0
dml lock allocation	1,609	0.00		0
dummy allocation	11	0.00		0
enqueue hash chains	15,240	0.00		0
enqueues	13,246	0.00		0
event group latch	5	0.00		0
file cache latch	39	0.00		0
global KZLD latch for mem in SGA	4	0.00		0
hash table column usage latch	1	0.00		45,027	0.00
hash table modification latch	2	0.00		0
job_queue_processes parameter latch	12	0.00		0
kks stats	187	0.00		0
kokc descriptor allocation latch	2	0.00		0
ksuosstats global area	51	0.00		0
kwqbsn:qsga	28	0.00		0
lgwr LWN SCN	359	0.00		0
library cache	15,156	0.00		18	0.00
library cache load lock	208	0.00		0
library cache lock	7,379	0.00		0
library cache lock allocation	145	0.00		0
library cache pin	4,322	0.00		0
library cache pin allocation	74	0.00		0
list of block allocation	121	0.00		0
loader state object freelist	36	0.00		0
logminer context allocation	1	0.00		0
longop free list parent	1	0.00		1	0.00
message pool operations parent latch	2	0.00		0
messages	6,958	0.00		0
mostly latch-free SCN	359	0.00		0
multiblock read objects	132	0.00		0
ncodef allocation latch	11	0.00		0
object queue header heap	4,703	0.00		5	0.00
object queue header operation	33,659	0.00		0
object stats modification	14	0.00		0
parallel query alloc buffer	100	0.00		0
parameter list	15	0.00		0
parameter table allocation management	6	0.00		0
post/wait queue	168	0.00		109	0.00
process allocation	11	0.00		5	0.00
process group creation	11	0.00		0
qmn task queue latch	104	25.00	1.00	0
redo allocation	2,265	0.00		41,625	0.01
redo copy	0			41,626	0.00
redo writing	2,757	0.00		0
resmgr group change latch	6	0.00		0
resmgr:active threads	9	0.00		0
resmgr:actses change group	4	0.00		0
resmgr:free threads list	8	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	90,641	0.00		0
rules engine rule set statistics	100	0.00		0
sequence cache	165	0.00		0
session allocation	14,422	0.00		0
session idle bit	3,168	0.00		0
session state list latch	26	0.00		0
session switching	11	0.00		0
session timer	247	0.00		0
shared pool	16,067	0.00		0
shared pool simulator	4,229	0.00		0
simulator hash latch	8,255,916	0.00	0.00	0
simulator lru latch	7,429	0.19	0.00	8,248,216	0.00
slave class	2	0.00		0
slave class create	7	14.29	1.00	0
sort extent pool	134	0.00		0
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
temporary table state object allocation	1	0.00		0
threshold alerts latch	32	0.00		0
transaction allocation	15	0.00		0
transaction branch allocation	247	0.00		0
undo global data	13,182	0.00		0
user lock	16	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets	Sleep1	Sleep2	Sleep3
qmn task queue latch	104	26	26	0	0	0	0
slave class create	7	1	1	0	0	0	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
cache buffers chains	kcbchg: kslbegin: bufs not pinned	2	0
event range base latch	No latch	26	26
slave class create	ksvcreate	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 132,270,874
Captured Segments account for 99.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	SMON_SCN_TIME	TABLE	132,080,592	99.86
SYS	SYSTEM	SMON_SCN_TIME_SCN_IDX	INDEX	37,616	0.03
SYS	SYSTEM	SMON_SCN_TIME_TIM_IDX	INDEX	19,024	0.01
SYS	SYSTEM	SMON_SCN_TO_TIME_IDX	INDEX	9,296	0.01
SYS	SYSTEM	OBJ$	TABLE	5,968	0.00

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 14,301
Captured Segments account for 8.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	991	6.93
SYS	SYSAUX	WRH$_SQL_PLAN_PK		INDEX	18	0.13
ORABPEL	ORABPEL	CUBE_SCOPE	SCOPE_1312	TABLE PARTITION	10	0.07
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	4648_24976	INDEX PARTITION	8	0.06
SYS	SYSAUX	SYS_LOB0000009001C00038$$		LOB	6	0.04

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	15	0.00	2	1
dc_database_links	8	0.00	0	1
dc_files	60	0.00	0	15
dc_global_oids	6	0.00	0	173
dc_histogram_data	2,877	3.37	28	67,711
dc_histogram_defs	3,557	2.28	9	5,103
dc_object_grants	190	10.00	0	294
dc_object_ids	2,754	0.62	1	2,319
dc_objects	1,002	1.00	4	1,955
dc_profiles	4	0.00	0	1
dc_rollback_segments	532	0.00	0	272
dc_segments	929	0.00	3	1,690
dc_sequences	6	16.67	6	11
dc_table_scns	1	100.00	0	0
dc_tablespaces	10,113	0.00	0	11
dc_usernames	25	0.00	0	60
dc_users	10,234	0.00	0	92
outstanding_alerts	9	0.00	0	9

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	26	0.00	88	0.00	0	0
CLUSTER	19	0.00	39	0.00	0	0
INDEX	32	31.25	103	11.65	0	0
SQL AREA	555	10.99	12,770	3.16	117	5
TABLE/PROCEDURE	347	2.59	1,764	3.91	17	0
TRIGGER	21	0.00	22	0.00	0	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

B: Begin snap E: End snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	57.14		1.73	3.91	22	23	33	33
	Freeable	17.44	0.00	1.25	1.15	5		14	14
	SQL	0.53	0.28	0.02	0.04	0	4	25	19
	PL/SQL	0.32	0.24	0.01	0.01	0	0	31	31
E	Other	56.75		1.77	3.97	22	23	32	32
	Freeable	18.88	0.00	1.18	1.10	5		16	16
	SQL	1.41	1.09	0.06	0.17	1	98	24	17
	PL/SQL	0.34	0.25	0.01	0.01	0	0	30	30

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	771,751,936
Fixed Size	2,056,504
Redo Buffers	14,716,928
Variable Size	822,087,368

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	ASH buffers	15.50	15.50	0.00
shared	CCursor	33.09	33.46	1.10
shared	FileOpenBlock	11.83	11.83	0.00
shared	Heap0: KGL	10.31	10.38	0.73
shared	KQR M SO	30.84	30.89	0.14
shared	KTI-UNDO	24.38	24.38	0.00
shared	PCursor	12.31	12.36	0.41
shared	VIRTUAL CIRCUITS	7.36	7.36	0.00
shared	XDB Schema Cac	9.09	9.09	0.00
shared	event statistics per sess	29.25	29.25	0.00
shared	free memory	208.19	202.07	-2.94
shared	library cache	20.05	20.12	0.32
shared	private strands	46.08	46.08	0.00
shared	sessions	17.30	17.30	0.00
shared	sql area	128.12	133.28	4.02
shared	transaction	7.68	7.68	0.00
streams	free memory	16.00	16.00	0.00
	buffer_cache	736.00	736.00	0.00
	fixed_sga	1.96	1.96	0.00
	log_buffer	14.04	14.04	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Apply
Buffered Queues
Buffered Subscribers
Rule Set

Streams CPU/IO Usage

Streams processes ordered by CPU usage
CPU and I/O Time in micro seconds

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Coordinator	29,694	0	0
QMON Slaves	6,196	0	0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
SYS.ALERT_QUE_R	0	0	0	0	0

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/soaapp/db/product/admin/soadb1/adump
background_dump_dest	/soaapp/db/product/admin/soadb1/bdump
compatible	10.2.0.3.0
control_files	/soaapp/db/soadb1/control01.ctl, /soaapp/db/soadb1/control02.ctl, /soaapp/db/soadb1/control03.ctl
core_dump_dest	/soaapp/db/product/admin/soadb1/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	soadb1
db_recovery_file_dest	/soaapp/db/flash_recovery_area
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=soadb1XDB)
job_queue_processes	10
local_listener	LISTENER_SOADB
open_cursors	300
pga_aggregate_target	6857687040
processes	3000
remote_login_passwordfile	EXCLUSIVE
sessions	3305
sga_target	1610612736
undo_management	AUTO
undo_retention	1800
undo_tablespace	UNDOTBS1
user_dump_dest	/soaapp/db/product/admin/soadb1/udump
utl_file_dir	/usr/tmp/soadb

End of Report

% Blocks changed per Read:	0.06	Recursive Call %:	94.27
Rollback per transaction %:	0.87	Rows per Sort:	1158.13

Buffer Nowait %:	100.00	Redo NoWait %:	99.99
Buffer Hit %:	100.00	In-memory Sort %:	99.85
Library Hit %:	96.72	Soft Parse %:	87.96
Execute to Parse %:	87.81	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	92.73	% Non-Parse CPU:	88.67