Using the report name awrrpt_1_15538_15539.html AWR Report for DB: EDB02, Inst: EDB02, Snaps: 15538-15539

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

EDB02 2742087752 EDB02 1 10.2.0.5.0 NO EDBSRM02

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
EDB02	2742087752	EDB02	1	10.2.0.5.0	NO	EDBSRM02

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 15538 01-Aug-13 03:00:31 1110 .5

End Snap: 15539 01-Aug-13 04:10:49 1102 .5

Elapsed: 70.30 (mins)

DB Time: 250.10 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	15538	01-Aug-13 03:00:31	1110	.5
End Snap:	15539	01-Aug-13 04:10:49	1102	.5
Elapsed:		70.30 (mins)
DB Time:		250.10 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 20,480M 20,480M Std Block Size: 16K

Shared Pool Size: 10,240M 10,240M Log Buffer: 14,264K

	Begin	End
Buffer Cache:	20,480M	20,480M	Std Block Size:	16K
Shared Pool Size:	10,240M	10,240M	Log Buffer:	14,264K

Load Profile

Per Second Per Transaction

Redo size: 510,417.25 8,396.38

Logical reads: 7,967.62 131.07

Block changes: 1,113.65 18.32

Physical reads: 833.27 13.71

Physical writes: 119.24 1.96

User calls: 1,128.34 18.56

Parses: 512.76 8.43

Hard parses: 78.37 1.29

Sorts: 4.41 0.07

Logons: 0.12 0.00

Executes: 516.19 8.49

Transactions: 60.79

	Per Second	Per Transaction
Redo size:	510,417.25	8,396.38
Logical reads:	7,967.62	131.07
Block changes:	1,113.65	18.32
Physical reads:	833.27	13.71
Physical writes:	119.24	1.96
User calls:	1,128.34	18.56
Parses:	512.76	8.43
Hard parses:	78.37	1.29
Sorts:	4.41	0.07
Logons:	0.12	0.00
Executes:	516.19	8.49
Transactions:	60.79

% Blocks changed per Read: 13.98 Recursive Call %: 20.33

Rollback per transaction %: 2.51 Rows per Sort: 604.33

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 100.00

Buffer Hit %: 89.89 In-memory Sort %: 99.99

Library Hit %: 77.76 Soft Parse %: 84.72

Execute to Parse %: 0.66 Latch Hit %: 99.87

Parse CPU to Parse Elapsd %: 8.22 % Non-Parse CPU: 98.30

Shared Pool Statistics

Begin End

Memory Usage %: 48.95 82.82

% SQL with executions>1: 8.77 1.98

% Memory for SQL w/exec>1: 12.93 3.04

	Begin	End
Memory Usage %:	48.95	82.82
% SQL with executions>1:	8.77	1.98
% Memory for SQL w/exec>1:	12.93	3.04

Top 5 Timed Events

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

log file sync 305,235 6,418 21 42.8 Commit

RMAN backup & recovery I/O 3,383 3,035 897 20.2 System I/O

Backup: sbtwrite2 402,540 2,385 6 15.9 Administrative

Backup: sbtbackup 4 1,780 444,919 11.9 Administrative

CPU time 1,633 10.9

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
log file sync	305,235	6,418	21	42.8	Commit
RMAN backup & recovery I/O	3,383	3,035	897	20.2	System I/O
Backup: sbtwrite2	402,540	2,385	6	15.9	Administrative
Backup: sbtbackup	4	1,780	444,919	11.9	Administrative
CPU time		1,633		10.9

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): 15006s
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	8,169.17	54.44
DB CPU	1,632.83	10.88
RMAN cpu time (backup/restore)	1,254.39	8.36
parse time elapsed	377.45	2.52
hard parse elapsed time	262.01	1.75
PL/SQL execution elapsed time	35.35	0.24
connection management call elapsed time	0.71	0.00
failed parse elapsed time	0.24	0.00
PL/SQL compilation elapsed time	0.09	0.00
hard parse (sharing criteria) elapsed time	0.07	0.00
sequence load elapsed time	0.02	0.00
repeated bind elapsed time	0.02	0.00
inbound PL/SQL rpc elapsed time	0.00	0.00
DB time	15,005.98
background elapsed time	9,598.40
background cpu time	1,329.03

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
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%Total Call Time
Commit	305,235	18	6,418	21	42.77
System I/O	453,217		4,793	11	31.94
Administrative	402,556		4,202	10	28.00
User I/O	403,321		2,229	6	14.85
CPU time			1,633		10.88
Concurrency	20,523	3	452	22	3.01
Network	2,768,340		44	0	0.30
Application	25		11	431	0.07
Other	2,608	8	9	3	0.06
Configuration	19	5	1	37	0.00

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)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file sync	305,235	18	6,418	21	1.19
RMAN backup & recovery I/O	3,383		3,035	897	0.01
Backup: sbtwrite2	402,540		2,385	6	1.57
Backup: sbtbackup	4		1,780	444919	0.00
db file sequential read	190,959		1,536	8	0.74
db file parallel write	191,870		911	5	0.75
log file parallel write	234,217		611	3	0.91
db file scattered read	202,179		600	3	0.79
os thread startup	419	94	384	917	0.00
Log archive I/O	3,072		158	52	0.01
direct path read temp	7,968		83	10	0.03
SQL*Net message from dblink	4,005		42	10	0.02
Backup: sbtclose2	4		37	9278	0.00
control file parallel write	2,593		37	14	0.01
enq: TX - index contention	357		36	102	0.00
log file sequential read	2,886		29	10	0.01
control file sequential read	15,188		13	1	0.06
latch: shared pool	8,518		13	1	0.03
latch: library cache	6,451		11	2	0.03
SQL*Net break/reset to client	18		11	590	0.00
direct path write temp	1,004		9	9	0.00
library cache lock	18		5	264	0.00
enq: PR - contention	6		5	769	0.00
cursor: pin S wait on X	228	100	2	10	0.00
latch free	1,128		2	2	0.00
cursor: pin S	177	100	2	10	0.00
SQL*Net message to client	2,744,223		2	0	10.70
direct path write	1,110		1	1	0.00
log file switch completion	14		1	43	0.00
SQL*Net more data to dblink	6,836		0	0	0.03
SQL*Net more data from client	9,424		0	0	0.04
Backup: sbtinfo2	4		0	74	0.00
enq: JS - queue lock	140		0	2	0.00
buffer busy waits	3,485		0	0	0.01
enq: RO - fast object reuse	6		0	24	0.00
undo segment extension	3	33	0	33	0.00
rdbms ipc reply	103		0	1	0.00
db file parallel read	1		0	64	0.00
latch: library cache lock	13		0	5	0.00
log file single write	8		0	6	0.00
latch: In memory undo latch	913		0	0	0.00
direct path read	100		0	0	0.00
LGWR wait for redo copy	714		0	0	0.00
enq: CF - contention	5		0	4	0.00
latch: row cache objects	30		0	0	0.00
latch: cache buffers chains	70		0	0	0.00
latch: undo global data	290		0	0	0.00
row cache lock	20		0	0	0.00
SQL*Net message to dblink	3,845		0	0	0.01
latch: redo allocation	2		0	0	0.00
buffer deadlock	22	100	0	0	0.00
latch: redo writing	2		0	0	0.00
enq: TX - row lock contention	1		0	1	0.00
latch: cache buffers lru chain	15		0	0	0.00
latch: object queue header operation	3		0	0	0.00
reliable message	2		0	0	0.00
enq: FB - contention	1		0	0	0.00
Backup: sbtend	2		0	0	0.00
SQL*Net more data to client	7		0	0	0.00
library cache load lock	1		0	0	0.00
Backup: sbterror	2		0	0	0.00
SQL*Net message from client	2,744,320		518,512	189	10.70
Streams AQ: qmn slave idle wait	151		4,107	27197	0.00
Streams AQ: qmn coordinator idle wait	303	50	4,107	13553	0.00
virtual circuit status	140	100	4,079	29139	0.00
jobq slave wait	1,285	87	3,550	2763	0.01
Streams AQ: waiting for time management or cleanup tasks	1	100	2,192	2192444	0.00
single-task message	160		10	62	0.00
class slave wait	8		0	1	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file parallel write	191,844		911	5	0.75
log file parallel write	234,218		611	3	0.91
os thread startup	419	94	384	917	0.00
Log archive I/O	3,072		158	52	0.01
control file parallel write	1,989		36	18	0.01
log file sequential read	2,886		29	10	0.01
control file sequential read	4,183		8	2	0.02
events in waitclass Other	1,003		5	5	0.00
latch: library cache	3		0	118	0.00
log file single write	8		0	6	0.00
direct path read	100		0	0	0.00
direct path write	100		0	0	0.00
latch: redo writing	2		0	0	0.00
latch: shared pool	2		0	0	0.00
buffer busy waits	3		0	0	0.00
rdbms ipc message	248,555	7	54,075	218	0.97
pmon timer	1,412	100	4,114	2914	0.01
Streams AQ: qmn slave idle wait	151		4,107	27197	0.00
Streams AQ: qmn coordinator idle wait	303	50	4,107	13553	0.00
smon timer	45	16	3,942	87605	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100	2,192	2192444	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	29,095
AVG_IDLE_TIME	392,337
AVG_IOWAIT_TIME	91,815
AVG_SYS_TIME	11,363
AVG_USER_TIME	17,607
BUSY_TIME	467,819
IDLE_TIME	6,279,636
IOWAIT_TIME	1,471,150
SYS_TIME	183,896
USER_TIME	283,923
LOAD	1
OS_CPU_WAIT_TIME	713,100
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	8,486,592,512
VM_OUT_BYTES	59,946,004,480
PHYSICAL_MEMORY_BYTES	97,173,635,072
NUM_CPUS	16
NUM_CPU_CORES	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
SYS$USERS	15,012.70	1,635.50	3,519,957	33,508,418
EDB02	0.00	0.00	0	0
EDB02XDB	0.00	0.00	0	0
SYS$BACKGROUND	0.00	0.00	687	110,743

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 seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	402520	2224	20088	68	402556	4202	2767769	44
EDB02	0	0	0	0	0	0	0	0
SYS$BACKGROUND	839	5	428	385	0	0	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
Total DB Time (s): 15,006
Captured SQL account for 17.3% of Total

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
1,630	50	1	1630.45	10.87	bauc50h8wpfca		DECLARE job BINARY_INTEGER := ...
574	120	7	82.04	3.83	c7urjctmjz58d	JDBC Thin Client	SELECT * FROM ( SELECT T.*, RO...
111	41	82,726	0.00	0.74	62nv0dyj9hshd	JDBC Thin Client	INSERT INTO tlog(SEQ, CUTOFFDA...
83	17	1	83.47	0.56	333szqv2aapcy	JDBC Thin Client	select count(*) from ( select ...
30	26	12	2.46	0.20	fcyj38usxvghq		DECLARE job BINARY_INTEGER := ...
25	8	165	0.15	0.17	7jjuh6q597u24	DBMS_SCHEDULER	call APPUSER.AUTOREF ( )
16	4	13	1.23	0.11	gnzkhd0b52nbz		select a.tablespace_name, a.ts...
13	12	9	1.39	0.08	21pkdq8m0nw9h		INSERT INTO SRM_MONITOR_TMP SE...
12	0	330,720	0.00	0.08	9q65xupb28d3b	JDBC Thin Client	SELECT NAME FLD0, XPATH FLD1 F...
9	1	146	0.06	0.06	5gykn228mtuhs		begin sys.dbms_snapshot_utl.se...

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 is the CPU Time divided into the Total CPU Time times 100
Total CPU Time (s): 1,633
Captured SQL account for 18.6% of Total

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total	% Total DB Time	SQL Id	SQL Module	SQL Text
120	574	7	17.13	7.34	3.83	c7urjctmjz58d	JDBC Thin Client	SELECT * FROM ( SELECT T.*, RO...
50	1,630	1	49.70	3.04	10.87	bauc50h8wpfca		DECLARE job BINARY_INTEGER := ...
41	111	82,726	0.00	2.49	0.74	62nv0dyj9hshd	JDBC Thin Client	INSERT INTO tlog(SEQ, CUTOFFDA...
26	30	12	2.13	1.56	0.20	fcyj38usxvghq		DECLARE job BINARY_INTEGER := ...
17	83	1	17.45	1.07	0.56	333szqv2aapcy	JDBC Thin Client	select count(*) from ( select ...
12	13	9	1.33	0.73	0.08	21pkdq8m0nw9h		INSERT INTO SRM_MONITOR_TMP SE...
8	25	165	0.05	0.51	0.17	7jjuh6q597u24	DBMS_SCHEDULER	call APPUSER.AUTOREF ( )
6	6	12	0.48	0.35	0.04	cshzvtwzsy8m1		SELECT A.MONITOR_CONFIG_ID, A....
4	16	13	0.29	0.23	0.11	gnzkhd0b52nbz		select a.tablespace_name, a.ts...
4	4	10	0.38	0.23	0.03	aapaq0sk4z29b		select count(*) records from ...

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: 33,605,474
Captured SQL account for 73.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
16,136,040	82,726	195.05	48.02	40.62	110.73	62nv0dyj9hshd	JDBC Thin Client	INSERT INTO tlog(SEQ, CUTOFFDA...
3,013,087	7	430,441.00	8.97	119.92	574.29	c7urjctmjz58d	JDBC Thin Client	SELECT * FROM ( SELECT T.*, RO...
2,129,554	1	2,129,554.00	6.34	49.70	1630.45	bauc50h8wpfca		DECLARE job BINARY_INTEGER := ...
579,061	82,726	7.00	1.72	0.08	5.76	4qb4gdu1ujchb	JDBC Thin Client	SELECT routing_service_name fl...
546,416	13	42,032.00	1.63	3.82	16.01	gnzkhd0b52nbz		select a.tablespace_name, a.ts...
503,298	12	41,941.50	1.50	25.55	29.55	fcyj38usxvghq		DECLARE job BINARY_INTEGER := ...
496,146	165,384	3.00	1.48	0.09	5.80	07423dwv71y4f	JDBC Thin Client	select biz_service_name FLD0 f...
496,008	165,336	3.00	1.48	0.11	6.35	ckpm2rw6qhbcc	JDBC Thin Client	SELECT availability fld0, subs...
368,814	1	368,814.00	1.10	17.45	83.47	333szqv2aapcy	JDBC Thin Client	select count(*) from ( select ...
330,766	165,384	2.00	0.98	0.09	5.69	8q0tvzf7bsrry	JDBC Thin Client	select routing_service_name FL...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 3,514,528
Captured SQL account for 84.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,578,756	7	368,393.71	73.37	119.92	574.29	c7urjctmjz58d	JDBC Thin Client	SELECT * FROM ( SELECT T.*, RO...
368,403	1	368,403.00	10.48	17.45	83.47	333szqv2aapcy	JDBC Thin Client	select count(*) from ( select ...
303,872	1	303,872.00	8.65	49.70	1630.45	bauc50h8wpfca		DECLARE job BINARY_INTEGER := ...
3,094	13	238.00	0.09	3.82	16.01	gnzkhd0b52nbz		select a.tablespace_name, a.ts...
555	82,726	0.01	0.02	40.62	110.73	62nv0dyj9hshd	JDBC Thin Client	INSERT INTO tlog(SEQ, CUTOFFDA...
351	1	351.00	0.01	0.09	2.55	c2p32r5mzv8hb		BEGIN prvt_advisor.delete_expi...
296	1	296.00	0.01	0.04	1.91	7q2wnyku8mfv0		SELECT T.ID FROM WRI$_ADV_TASK...
251	1	251.00	0.01	0.35	0.84	7fbgvm7ttgqn9	sqlplus@EDBSRM02 (TNS V1-V3)	select t.tablespace_name table...
69	1	69.00	0.00	0.32	0.87	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
58	12	4.83	0.00	25.55	29.55	fcyj38usxvghq		DECLARE job BINARY_INTEGER := ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 2,177,156
Captured SQL account for 77.7% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
330,720	0	0.00	9q65xupb28d3b	JDBC Thin Client	SELECT NAME FLD0, XPATH FLD1 F...
165,384	165,383	1.00	07423dwv71y4f	JDBC Thin Client	select biz_service_name FLD0 f...
165,384	165,383	1.00	8q0tvzf7bsrry	JDBC Thin Client	select routing_service_name FL...
165,338	165,337	1.00	77k74q08vjphm	JDBC Thin Client	SELECT status fld0 FROM partie...
165,336	165,336	1.00	ckpm2rw6qhbcc	JDBC Thin Client	SELECT availability fld0, subs...
158,937	158,937	1.00	8gsqqpgfvqtjb	JDBC Thin Client	SELECT need_reversal FLD0, bfe...
82,726	82,725	1.00	07gqzy7yy9msb	JDBC Thin Client	select value FLD0 from sys_par...
82,726	82,723	1.00	4qb4gdu1ujchb	JDBC Thin Client	SELECT routing_service_name fl...
82,726	82,717	1.00	62nv0dyj9hshd	JDBC Thin Client	INSERT INTO tlog(SEQ, CUTOFFDA...
82,668	82,668	1.00	fmpcdrun0mmzp	JDBC Thin Client	select sfee_rate FLD0 from bip...
56,344	56,344	1.00	dftfzg2c1c081		select biz_service_name FLD0 f...
32,403	32,403	1.00	07tynncydd9g6	JDBC Thin Client	select biz_service_name FLD0 f...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 2,162,682
Captured SQL account for 78.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
330,717	330,720	15.29	9q65xupb28d3b	JDBC Thin Client	SELECT NAME FLD0, XPATH FLD1 F...
165,384	165,384	7.65	07423dwv71y4f	JDBC Thin Client	select biz_service_name FLD0 f...
165,383	165,384	7.65	8q0tvzf7bsrry	JDBC Thin Client	select routing_service_name FL...
165,337	165,338	7.64	77k74q08vjphm	JDBC Thin Client	SELECT status fld0 FROM partie...
165,336	165,336	7.64	ckpm2rw6qhbcc	JDBC Thin Client	SELECT availability fld0, subs...
158,937	158,937	7.35	8gsqqpgfvqtjb	JDBC Thin Client	SELECT need_reversal FLD0, bfe...
82,726	82,726	3.83	4qb4gdu1ujchb	JDBC Thin Client	SELECT routing_service_name fl...
82,726	82,726	3.83	62nv0dyj9hshd	JDBC Thin Client	INSERT INTO tlog(SEQ, CUTOFFDA...
82,725	82,726	3.83	07gqzy7yy9msb	JDBC Thin Client	select value FLD0 from sys_par...
82,668	82,668	3.82	fmpcdrun0mmzp	JDBC Thin Client	select sfee_rate FLD0 from bip...
56,343	56,344	2.61	dftfzg2c1c081		select biz_service_name FLD0 f...
32,403	32,403	1.50	07tynncydd9g6	JDBC Thin Client	select biz_service_name FLD0 f...

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
3,227,875	1	0.03	76natvnhtqqhw		INSERT INTO SYS.WRI$_ADV_TASKS...

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 Module	SQL Text
111	1	76natvnhtqqhw		INSERT INTO SYS.WRI$_ADV_TASKS...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

07423dwv71y4f select biz_service_name FLD0 from action where activity_id=:1 and content_version=:2 and action_code='0'

07gqzy7yy9msb select value FLD0 from sys_para where name='CURRCUTOFFDAY'

07tynncydd9g6 select biz_service_name FLD0 from action where activity_id='T2000001' and content_version='0100' and action_code='1'

21pkdq8m0nw9h INSERT INTO SRM_MONITOR_TMP SELECT T.BIP_ID, T.ACTIVITY_ID, SUM(T.PROCTM_RSP-T.PROCTM_REQ)*24*60*60*1000, NVL(COUNT(*), 0), T.OSN_DUNS, T.HSN_DUNS, NVL(T.RESPONSE_CODE, ' '), T.ODOMAIN_ID, T.HDOMAIN_ID, TO_DATE(:B3 , 'YYYY-MM-DD HH24:MI:SS'), TO_DATE(:B2 , 'YYYY-MM-DD HH24:MI:SS'), T.CUTOFFDAY , :B5 , :B4 FROM TLOG T WHERE PROCTM_RSP>=TO_DATE(:B3 , 'YYYY-MM-DD HH24:MI:SS') AND PROCTM_RSP<TO_DATE(:B2 , 'YYYY-MM-DD HH24:MI:SS') AND T.CUTOFFDAY = :B1 GROUP BY T.BIP_ID, T.ACTIVITY_ID, T.OSN_DUNS, T.HSN_DUNS, NVL(T.RESPONSE_CODE, ' '), T.ODOMAIN_ID, T.HDOMAIN_ID, T.CUTOFFDAY

333szqv2aapcy select count(*) from ( select tab1.HSN_DUNS, tab2.activity_name, tab1.OPART_SEQ, to_char(tab1.OPART_TIME, 'yyyy-MM-dd HH24:mi:ss') OPART_TIME, tab1.RESPONSE_CODE, tab1.cutoffday from tlog tab1 , activity tab2 where tab1.activity_id = tab2.activity_id and (response_code = '0102' or response_code not like '0%') and tab1.activity_id in ('T1000005', 'T1001001', 'T2000701', 'T2031702') ) source , provs where cutoffday = :1 and HSN_DUNS = prov_id||'00'

4qb4gdu1ujchb SELECT routing_service_name fld0 FROM routing_logic where routing_type=:1

5gykn228mtuhs begin sys.dbms_snapshot_utl.set_up@"EDBSRM" (:mown_col, :mas_col, :rollseg_col, :flag_col, :outflag_col, :snaptime_col, :loadertime_col, :num_sid, :snapid_tab, :max_tab_scn_col, :max_dl_scn_col, :max_pmop_scn_col, :trunc_scn_col, :max_ins_tim_col, :max_upd_tim_col, :max_del_tim_col, :max_ins_scn_col, :max_upd_scn_col, :max_del_scn_col, :hdl_col, :hdl_indx_col, :rscn); end;

62nv0dyj9hshd INSERT INTO tlog(SEQ, CUTOFFDAY, BIP_ID, ACTIVITY_ID, ACTIVITY_TYPE, RECON_FLAG, BFEE, BFEE_DIRECTION, AFEE, AFEE_METHOD_ID, AFEE_LOCATION, HDOMAIN_ID, HSN_DUNS, OSN_DUNS, ODOMAIN_ID, HPART_SEQ, OPART_SEQ, RELATE_SEQ, OPART_TIME, HPART_TIME, PROCTM_REQ, PROCTM_RSP, TEST_FLAG, STATUS, RESPONSE_TYPE, RESPONSE_CODE, CLIENT_TYPE, CLIENT_ID, BIP_SEQ_O, CONV_ID, DUP_FLAG, SFEE, ACTION_RELATE) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TO_DATE(:19, 'YYYYMMDDHH24miss'), TO_DATE(:20, 'YYYYMMDDHH24miss'), SYSDATE, TO_DATE(:21, 'YYYYMMDDHH24miss'), :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32)

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 )

77k74q08vjphm SELECT status fld0 FROM parties WHERE domain_id=:1 AND duns=:2

7fbgvm7ttgqn9 select t.tablespace_name tablespace, nvl(tsf.bytes, 0) free FROM sys.dba_tablespaces t, sys.sm$ts_avail tsa, sys.sm$ts_free tsf WHERE t.tablespace_name = tsa.tablespace_name (+) AND t.tablespace_name = tsf.tablespace_name (+) AND t.tablespace_name not in ( select tablespace_name from dba_tablespaces where extent_management = 'LOCAL' and contents = 'TEMPORARY') UNION SELECT t.tablespace_name tablespace, nvl(lt.free, 0) FROM sys.dba_tablespaces t, ( SELECT h.tablespace_name, sum ((h.bytes_free + h.bytes_used) - p.bytes_used) free FROM sys.v_$temp_space_header h, sys.v_$Temp_extent_pool p wHERE p.file_id(+) = h.file_id group by h.tablespace_name ) lt WHERE t.tablespace_name = lt.tablespace_name ORDER BY 1

7jjuh6q597u24 call APPUSER.AUTOREF ( )

7q2wnyku8mfv0 SELECT T.ID FROM WRI$_ADV_TASKS T, WRI$_ADV_PARAMETERS P WHERE T.ID = P.TASK_ID AND T.STATUS <> :B4 AND BITAND(T.PROPERTY, :B3 + :B2 ) = 0 AND P.NAME = 'DAYS_TO_EXPIRE' AND DECODE(P.NAME, 'DAYS_TO_EXPIRE', DECODE(P.VALUE, 'UNLIMITED', :B1 + 1, 'UNUSED', T.MTIME + 30, DECODE(TO_NUMBER(P.VALUE), 0, :B1 + 1, T.MTIME + TO_NUMBER(P.VALUE))), :B1 + 1) < :B1

8gsqqpgfvqtjb SELECT need_reversal FLD0, bfee_direction FLD1, afee_method_id FLD2, recon_flag FLD3, timeout_sc FLD4 FROM activity WHERE activity_id=:1

8q0tvzf7bsrry select routing_service_name FLD0 from routing_logic where routing_type=:1

9q65xupb28d3b SELECT NAME FLD0, XPATH FLD1 FROM action_extract WHERE bip_id=:1 and activity_id=:2 and action_code=:3 and extract_type=:4 order by name

aapaq0sk4z29b select count(*) records from srm_monitor_log t where t.end_time > (to_char(to_date(:1, 'yyyy-mm-dd hh24:mi:ss') - 5 / 24 / 60, 'yyyy-mm-dd hh24:mi:') || '00') and t.end_time <= (to_char(to_date(:2, 'yyyy-mm-dd hh24:mi:ss'), 'yyyy-mm-dd hh24:mi:') || '00')

bauc50h8wpfca DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN creaparttab; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

c2p32r5mzv8hb BEGIN prvt_advisor.delete_expired_tasks; END;

c7urjctmjz58d SELECT * FROM ( SELECT T.*, ROWNUM AS RN FROM ( select prov_desc, activity_name, OPART_SEQ, OPART_TIME, RESPONSE_CODE from ( select tab1.HSN_DUNS, tab2.activity_name, tab1.OPART_SEQ, to_char(tab1.OPART_TIME, 'yyyy-MM-dd HH24:mi:ss') OPART_TIME, tab1.RESPONSE_CODE, tab1.cutoffday from tlog tab1 , activity tab2 where tab1.activity_id = tab2.activity_id and (response_code = '0102' or response_code not like '0%') and tab1.activity_id in ('T1000005', 'T1001001', 'T2000701', 'T2031702') ) source , provs where cutoffday = :1 and HSN_DUNS = prov_id||'00' ) T ) WHERE RN > :2 AND RN <= :3

ckpm2rw6qhbcc SELECT availability fld0, substr(start_time, 1, 12) fld1, substr(end_time, 1, 12) fld2, reason fld3 FROM party_bip WHERE domain_id=:1 AND duns=:2 AND bip_id=:3 AND role=:4

cshzvtwzsy8m1 SELECT A.MONITOR_CONFIG_ID, A.BEGIN_TIME, A.END_TIME FROM SRM_MONITOR_CONFIG A WHERE A.MONITOR_CONFIG_ID NOT IN( SELECT T.MONITOR_CONFIG_ID FROM SRM_MONITOR_LOG T WHERE TRUNC(TO_DATE(T.START_TIME, 'YYYY-MM-DD HH24:MI:SS'))=TRUNC(:B1 ) ) ORDER BY A.MONITOR_CONFIG_ID

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

dftfzg2c1c081 select biz_service_name FLD0 from action where activity_id='T2000003' and content_version='0100' and action_code='1'

fcyj38usxvghq DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN COLLECT_AUTO; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

fmpcdrun0mmzp select sfee_rate FLD0 from bip_activity where bip_id=:1 and activity_id=:2

gnzkhd0b52nbz select a.tablespace_name, a.tsfree, b.tssize, round(a.tsfree/b.tssize, 2) pct_free from (select tablespace_name, to_char(round(sum(bytes)/1048576), '9999999') tsfree from sys.dba_free_space group by tablespace_name) a, (select tablespace_name, to_char(round(sum(bytes)/1048576), '9999999') tssize from sys.dba_data_files group by tablespace_name) b where a.tablespace_name=b.tablespace_name

SQL Id	SQL Text
07423dwv71y4f	select biz_service_name FLD0 from action where activity_id=:1 and content_version=:2 and action_code='0'
07gqzy7yy9msb	select value FLD0 from sys_para where name='CURRCUTOFFDAY'
07tynncydd9g6	select biz_service_name FLD0 from action where activity_id='T2000001' and content_version='0100' and action_code='1'
21pkdq8m0nw9h	INSERT INTO SRM_MONITOR_TMP SELECT T.BIP_ID, T.ACTIVITY_ID, SUM(T.PROCTM_RSP-T.PROCTM_REQ)2460601000, NVL(COUNT(*), 0), T.OSN_DUNS, T.HSN_DUNS, NVL(T.RESPONSE_CODE, ' '), T.ODOMAIN_ID, T.HDOMAIN_ID, TO_DATE(:B3 , 'YYYY-MM-DD HH24:MI:SS'), TO_DATE(:B2 , 'YYYY-MM-DD HH24:MI:SS'), T.CUTOFFDAY , :B5 , :B4 FROM TLOG T WHERE PROCTM_RSP>=TO_DATE(:B3 , 'YYYY-MM-DD HH24:MI:SS') AND PROCTM_RSP<TO_DATE(:B2 , 'YYYY-MM-DD HH24:MI:SS') AND T.CUTOFFDAY = :B1 GROUP BY T.BIP_ID, T.ACTIVITY_ID, T.OSN_DUNS, T.HSN_DUNS, NVL(T.RESPONSE_CODE, ' '), T.ODOMAIN_ID, T.HDOMAIN_ID, T.CUTOFFDAY
333szqv2aapcy	select count(*) from ( select tab1.HSN_DUNS, tab2.activity_name, tab1.OPART_SEQ, to_char(tab1.OPART_TIME, 'yyyy-MM-dd HH24:mi:ss') OPART_TIME, tab1.RESPONSE_CODE, tab1.cutoffday from tlog tab1 , activity tab2 where tab1.activity_id = tab2.activity_id and (response_code = '0102' or response_code not like '0%') and tab1.activity_id in ('T1000005', 'T1001001', 'T2000701', 'T2031702') ) source , provs where cutoffday = :1 and HSN_DUNS = prov_id\|\|'00'
4qb4gdu1ujchb	SELECT routing_service_name fld0 FROM routing_logic where routing_type=:1
5gykn228mtuhs	begin sys.dbms_snapshot_utl.set_up@"EDBSRM" (:mown_col, :mas_col, :rollseg_col, :flag_col, :outflag_col, :snaptime_col, :loadertime_col, :num_sid, :snapid_tab, :max_tab_scn_col, :max_dl_scn_col, :max_pmop_scn_col, :trunc_scn_col, :max_ins_tim_col, :max_upd_tim_col, :max_del_tim_col, :max_ins_scn_col, :max_upd_scn_col, :max_del_scn_col, :hdl_col, :hdl_indx_col, :rscn); end;
62nv0dyj9hshd	INSERT INTO tlog(SEQ, CUTOFFDAY, BIP_ID, ACTIVITY_ID, ACTIVITY_TYPE, RECON_FLAG, BFEE, BFEE_DIRECTION, AFEE, AFEE_METHOD_ID, AFEE_LOCATION, HDOMAIN_ID, HSN_DUNS, OSN_DUNS, ODOMAIN_ID, HPART_SEQ, OPART_SEQ, RELATE_SEQ, OPART_TIME, HPART_TIME, PROCTM_REQ, PROCTM_RSP, TEST_FLAG, STATUS, RESPONSE_TYPE, RESPONSE_CODE, CLIENT_TYPE, CLIENT_ID, BIP_SEQ_O, CONV_ID, DUP_FLAG, SFEE, ACTION_RELATE) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TO_DATE(:19, 'YYYYMMDDHH24miss'), TO_DATE(:20, 'YYYYMMDDHH24miss'), SYSDATE, TO_DATE(:21, 'YYYYMMDDHH24miss'), :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32)
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 )
77k74q08vjphm	SELECT status fld0 FROM parties WHERE domain_id=:1 AND duns=:2
7fbgvm7ttgqn9	select t.tablespace_name tablespace, nvl(tsf.bytes, 0) free FROM sys.dba_tablespaces t, sys.sm$ts_avail tsa, sys.sm$ts_free tsf WHERE t.tablespace_name = tsa.tablespace_name (+) AND t.tablespace_name = tsf.tablespace_name (+) AND t.tablespace_name not in ( select tablespace_name from dba_tablespaces where extent_management = 'LOCAL' and contents = 'TEMPORARY') UNION SELECT t.tablespace_name tablespace, nvl(lt.free, 0) FROM sys.dba_tablespaces t, ( SELECT h.tablespace_name, sum ((h.bytes_free + h.bytes_used) - p.bytes_used) free FROM sys.v_$temp_space_header h, sys.v_$Temp_extent_pool p wHERE p.file_id(+) = h.file_id group by h.tablespace_name ) lt WHERE t.tablespace_name = lt.tablespace_name ORDER BY 1
7jjuh6q597u24	call APPUSER.AUTOREF ( )
7q2wnyku8mfv0	SELECT T.ID FROM WRI$_ADV_TASKS T, WRI$_ADV_PARAMETERS P WHERE T.ID = P.TASK_ID AND T.STATUS <> :B4 AND BITAND(T.PROPERTY, :B3 + :B2 ) = 0 AND P.NAME = 'DAYS_TO_EXPIRE' AND DECODE(P.NAME, 'DAYS_TO_EXPIRE', DECODE(P.VALUE, 'UNLIMITED', :B1 + 1, 'UNUSED', T.MTIME + 30, DECODE(TO_NUMBER(P.VALUE), 0, :B1 + 1, T.MTIME + TO_NUMBER(P.VALUE))), :B1 + 1) < :B1
8gsqqpgfvqtjb	SELECT need_reversal FLD0, bfee_direction FLD1, afee_method_id FLD2, recon_flag FLD3, timeout_sc FLD4 FROM activity WHERE activity_id=:1
8q0tvzf7bsrry	select routing_service_name FLD0 from routing_logic where routing_type=:1
9q65xupb28d3b	SELECT NAME FLD0, XPATH FLD1 FROM action_extract WHERE bip_id=:1 and activity_id=:2 and action_code=:3 and extract_type=:4 order by name
aapaq0sk4z29b	select count(*) records from srm_monitor_log t where t.end_time > (to_char(to_date(:1, 'yyyy-mm-dd hh24:mi:ss') - 5 / 24 / 60, 'yyyy-mm-dd hh24:mi:') \|\| '00') and t.end_time <= (to_char(to_date(:2, 'yyyy-mm-dd hh24:mi:ss'), 'yyyy-mm-dd hh24:mi:') \|\| '00')
bauc50h8wpfca	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN creaparttab; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
c2p32r5mzv8hb	BEGIN prvt_advisor.delete_expired_tasks; END;
c7urjctmjz58d	SELECT * FROM ( SELECT T.*, ROWNUM AS RN FROM ( select prov_desc, activity_name, OPART_SEQ, OPART_TIME, RESPONSE_CODE from ( select tab1.HSN_DUNS, tab2.activity_name, tab1.OPART_SEQ, to_char(tab1.OPART_TIME, 'yyyy-MM-dd HH24:mi:ss') OPART_TIME, tab1.RESPONSE_CODE, tab1.cutoffday from tlog tab1 , activity tab2 where tab1.activity_id = tab2.activity_id and (response_code = '0102' or response_code not like '0%') and tab1.activity_id in ('T1000005', 'T1001001', 'T2000701', 'T2031702') ) source , provs where cutoffday = :1 and HSN_DUNS = prov_id\|\|'00' ) T ) WHERE RN > :2 AND RN <= :3
ckpm2rw6qhbcc	SELECT availability fld0, substr(start_time, 1, 12) fld1, substr(end_time, 1, 12) fld2, reason fld3 FROM party_bip WHERE domain_id=:1 AND duns=:2 AND bip_id=:3 AND role=:4
cshzvtwzsy8m1	SELECT A.MONITOR_CONFIG_ID, A.BEGIN_TIME, A.END_TIME FROM SRM_MONITOR_CONFIG A WHERE A.MONITOR_CONFIG_ID NOT IN( SELECT T.MONITOR_CONFIG_ID FROM SRM_MONITOR_LOG T WHERE TRUNC(TO_DATE(T.START_TIME, 'YYYY-MM-DD HH24:MI:SS'))=TRUNC(:B1 ) ) ORDER BY A.MONITOR_CONFIG_ID
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dftfzg2c1c081	select biz_service_name FLD0 from action where activity_id='T2000003' and content_version='0100' and action_code='1'
fcyj38usxvghq	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN COLLECT_AUTO; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fmpcdrun0mmzp	select sfee_rate FLD0 from bip_activity where bip_id=:1 and activity_id=:2
gnzkhd0b52nbz	select a.tablespace_name, a.tsfree, b.tssize, round(a.tsfree/b.tssize, 2) pct_free from (select tablespace_name, to_char(round(sum(bytes)/1048576), '9999999') tsfree from sys.dba_free_space group by tablespace_name) a, (select tablespace_name, to_char(round(sum(bytes)/1048576), '9999999') tssize from sys.dba_data_files group by tablespace_name) b where a.tablespace_name=b.tablespace_name

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	50,353	11.94	0.20
CPU used when call started	28,425	6.74	0.11
CR blocks created	3,413	0.81	0.01
Cached Commit SCN referenced	1,161	0.28	0.00
Commit SCN cached	1	0.00	0.00
DB time	1,727,253	409.52	6.74
DBWR checkpoint buffers written	430,127	101.98	1.68
DBWR checkpoints	6	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	34,753	8.24	0.14
DBWR undo block writes	143,944	34.13	0.56
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	0	0.00	0.00
IMU CR rollbacks	574	0.14	0.00
IMU Flushes	53,280	12.63	0.21
IMU Redo allocation size	166,323,868	39,434.21	648.69
IMU bind flushes	0	0.00	0.00
IMU commits	202,143	47.93	0.79
IMU contention	7,318	1.74	0.03
IMU ktichg flush	3,376	0.80	0.01
IMU pool not allocated	921	0.22	0.00
IMU recursive-transaction flush	2	0.00	0.00
IMU undo allocation size	821,882,320	194,862.46	3,205.49
IMU- failed to get a private strand	921	0.22	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
RowCR - row contention	1,187	0.28	0.00
RowCR attempts	8,364	1.98	0.03
RowCR hits	7,155	1.70	0.03
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	38	0.01	0.00
SQL*Net roundtrips to/from client	2,743,081	650.37	10.70
SQL*Net roundtrips to/from dblink	3,845	0.91	0.01
active txn count during cleanout	6,841,968	1,622.18	26.68
application wait time	1,077	0.26	0.00
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	17,962	4.26	0.07
branch node splits	13	0.00	0.00
buffer is not pinned count	4,517,912	1,071.16	17.62
buffer is pinned count	3,985,340	944.90	15.54
bytes received via SQL*Net from client	734,379,128	174,116.08	2,864.22
bytes received via SQL*Net from dblink	1,295,936	307.26	5.05
bytes sent via SQL*Net to client	438,265,738	103,909.69	1,709.32
bytes sent via SQL*Net to dblink	15,247,786	3,615.14	59.47
calls to get snapshot scn: kcmgss	2,795,887	662.88	10.90
calls to kcmgas	427,972	101.47	1.67
calls to kcmgcs	6,740,449	1,598.11	26.29
change write time	1,853	0.44	0.01
cleanout - number of ktugct calls	7,034,242	1,667.77	27.43
cleanouts and rollbacks - consistent read gets	642	0.15	0.00
cleanouts only - consistent read gets	3,204	0.76	0.01
cluster key scan block gets	84,907	20.13	0.33
cluster key scans	54,117	12.83	0.21
commit batch performed	147	0.03	0.00
commit batch requested	147	0.03	0.00
commit batch/immediate performed	369	0.09	0.00
commit batch/immediate requested	369	0.09	0.00
commit cleanout failures: block lost	3	0.00	0.00
commit cleanout failures: buffer being written	3	0.00	0.00
commit cleanout failures: callback failure	9,020	2.14	0.04
commit cleanout failures: cannot pin	10,524	2.50	0.04
commit cleanouts	1,254,661	297.47	4.89
commit cleanouts successfully completed	1,235,111	292.84	4.82
commit immediate performed	222	0.05	0.00
commit immediate requested	222	0.05	0.00
commit txn count during cleanout	858,964	203.65	3.35
concurrency wait time	45,227	10.72	0.18
consistent changes	29,820	7.07	0.12
consistent gets	18,855,961	4,470.61	73.54
consistent gets - examination	12,733,835	3,019.10	49.66
consistent gets direct	971	0.23	0.00
consistent gets from cache	18,854,990	4,470.38	73.54
current blocks converted for CR	0	0.00	0.00
cursor authentications	455	0.11	0.00
data blocks consistent reads - undo records applied	2,058	0.49	0.01
db block changes	4,697,084	1,113.65	18.32
db block gets	14,749,520	3,497.01	57.53
db block gets direct	2,004	0.48	0.01
db block gets from cache	14,747,516	3,496.53	57.52
deferred (CURRENT) block cleanout applications	239,214	56.72	0.93
dirty buffers inspected	20,991	4.98	0.08
enqueue conversions	87,037	20.64	0.34
enqueue releases	1,377,162	326.52	5.37
enqueue requests	1,377,138	326.51	5.37
enqueue timeouts	25	0.01	0.00
enqueue waits	514	0.12	0.00
exchange deadlocks	22	0.01	0.00
execute count	2,177,156	516.19	8.49
failed probes on index block reclamation	38	0.01	0.00
free buffer inspected	3,577,972	848.31	13.95
free buffer requested	3,605,221	854.77	14.06
global undo segment hints helped	0	0.00	0.00
heap block compress	5,172	1.23	0.02
hot buffers moved to head of LRU	183,918	43.61	0.72
immediate (CR) block cleanout applications	3,846	0.91	0.02
immediate (CURRENT) block cleanout applications	213,444	50.61	0.83
index crx upgrade (found)	54	0.01	0.00
index crx upgrade (positioned)	349,385	82.84	1.36
index fast full scans (full)	744	0.18	0.00
index fetch by key	2,508,889	594.84	9.79
index scans kdiixs1	689,945	163.58	2.69
leaf node 90-10 splits	9	0.00	0.00
leaf node splits	3,750	0.89	0.01
lob reads	710	0.17	0.00
lob writes	14,425	3.42	0.06
lob writes unaligned	14,425	3.42	0.06
logons cumulative	509	0.12	0.00
messages received	427,315	101.31	1.67
messages sent	427,315	101.31	1.67
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	5,362,995	1,271.53	20.92
opened cursors cumulative	2,153,341	510.54	8.40
parse count (failures)	19	0.00	0.00
parse count (hard)	330,557	78.37	1.29
parse count (total)	2,162,682	512.76	8.43
parse time cpu	2,771	0.66	0.01
parse time elapsed	33,714	7.99	0.13
physical read IO requests	429,994	101.95	1.68
physical read bytes	57,582,026,752	13,652,289.69	224,580.64
physical read total IO requests	649,660	154.03	2.53
physical read total bytes	1.7E+11	39,434,315.86	648,695.86
physical read total multi block requests	436,075	103.39	1.70
physical reads	3,514,528	833.27	13.71
physical reads cache	3,396,904	805.38	13.25
physical reads cache prefetch	3,004,182	712.27	11.72
physical reads direct	117,624	27.89	0.46
physical reads direct (lob)	971	0.23	0.00
physical reads direct temporary tablespace	117,508	27.86	0.46
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	217,343	51.53	0.85
physical write bytes	8,240,103,424	1,953,670.01	32,137.94
physical write total IO requests	700,799	166.15	2.73
physical write total bytes	15,946,042,880	3,780,693.54	62,192.54
physical write total multi block requests	559,599	132.68	2.18
physical writes	502,936	119.24	1.96
physical writes direct	30,135	7.14	0.12
physical writes direct (lob)	1,008	0.24	0.00
physical writes direct temporary tablespace	29,002	6.88	0.11
physical writes from cache	472,801	112.10	1.84
physical writes non checkpoint	340,482	80.73	1.33
pinned buffers inspected	14	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	1,214,251	287.89	4.74
recursive cpu usage	58,501	13.87	0.23
redo blocks written	4,469,676	1,059.73	17.43
redo buffer allocation retries	46	0.01	0.00
redo entries	1,938,178	459.53	7.56
redo log space requests	50	0.01	0.00
redo log space wait time	62	0.01	0.00
redo ordering marks	77,129	18.29	0.30
redo size	2,152,815,436	510,417.25	8,396.38
redo subscn max counts	120,633	28.60	0.47
redo synch time	657,762	155.95	2.57
redo synch writes	249,175	59.08	0.97
redo wastage	63,314,456	15,011.41	246.94
redo write time	64,354	15.26	0.25
redo writer latching time	4	0.00	0.00
redo writes	234,169	55.52	0.91
rollback changes - undo records applied	771	0.18	0.00
rollbacks only - consistent read gets	515	0.12	0.00
root node splits	0	0.00	0.00
rows fetched via callback	1,729,217	409.99	6.74
session connect time	0	0.00	0.00
session cursor cache hits	1,818,700	431.20	7.09
session logical reads	33,605,474	7,967.62	131.07
shared hash latch upgrades - no wait	360,319	85.43	1.41
shared hash latch upgrades - wait	135	0.03	0.00
sorts (disk)	1	0.00	0.00
sorts (memory)	18,587	4.41	0.07
sorts (rows)	11,233,297	2,663.33	43.81
sql area evicted	118,605	28.12	0.46
sql area purged	23	0.01	0.00
summed dirty queue length	37,015	8.78	0.14
switch current to new buffer	82,976	19.67	0.32
table fetch by rowid	3,228,371	765.42	12.59
table fetch continued row	7	0.00	0.00
table scan blocks gotten	4,177,494	990.45	16.29
table scan rows gotten	185,443,044	43,967.23	723.26
table scans (long tables)	24	0.01	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	91,337	21.66	0.36
total number of times SMON posted	38	0.01	0.00
transaction rollbacks	369	0.09	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	1,366,125,652	323,898.69	5,328.14
user I/O wait time	222,685	52.80	0.87
user calls	4,759,059	1,128.34	18.56
user commits	249,959	59.26	0.97
user rollbacks	6,439	1.53	0.03
workarea executions - onepass	4	0.00	0.00
workarea executions - optimal	7,039	1.67	0.03
write clones created in background	0	0.00	0.00
write clones created in foreground	57	0.01	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 pga memory max	4.3E+12	4.3E+12
session cursor cache count	242,002,481	242,028,813
session uga memory	6.9E+15	6.9E+15
opened cursors current	582	522
logons current	1,110	1,102
session uga memory max	5.6E+12	5.6E+12
session pga memory	3.9E+12	3.9E+12

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)	2	1.71

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	Av Buf Wt(ms)
TLOG_DATA	202,819	48	2.98	15.84	1,155	0	187	0.37
APPSTL	98,369	23	8.56	1.00	54,349	13	514	0.12
TLOG_INDEX	86,669	21	7.70	1.00	59,896	14	32	0.31
UNDOTBS1	198	0	10.71	1.00	84,161	20	2,255	0.04
TEMP	37,389	9	47.28	3.18	3,891	1	0	0.00
DLOG_INDEX	96	0	10.52	1.00	4,367	1	14	0.00
DLOG_DATA	484	0	6.61	1.00	3,495	1	230	0.13
SAF_DATA	216	0	9.26	1.00	3,186	1	29	0.00
REPORT_TXN_DATA	2,577	1	2.21	1.00	10	0	0	0.00
REPORT_TXN_INDEX	114	0	7.02	1.00	2,085	0	222	0.09
CONFIG_DATA	754	0	4.27	1.01	406	0	0	0.00
SYSAUX	601	0	8.09	1.00	349	0	0	0.00
SYSTEM	222	0	5.36	1.00	275	0	0	0.00
SAF_INDEX	19	0	6.84	1.00	2	0	0	0.00
CONFIG_INDEX	2	0	30.00	1.00	2	0	0	0.00
SETTLE_TXN_DATA	2	0	30.00	1.00	2	0	0	0.00
SETTLE_TXN_INDEX	2	0	30.00	1.00	2	0	0	0.00
USERS	2	0	25.00	1.00	2	0	0	0.00

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)
APPSTL	/oracle/oradata/EDB02/appstl_30G_01	20,580	5	7.73	1.00	12,855	3	104	0.19
APPSTL	/oracle/oradata/EDB02/appstl_30G_02	19,805	5	9.72	1.00	11,741	3	64	0.00
APPSTL	/oracle/oradata/EDB02/appstl_30G_03	24,832	6	8.46	1.00	13,100	3	110	0.09
APPSTL	/oracle/oradata/EDB02/appstl_30G_04	17,237	4	7.70	1.00	8,426	2	94	0.00
APPSTL	/oracle/oradata/EDB02/appstl_30G_05	15,915	4	9.27	1.00	8,227	2	142	0.21
CONFIG_DATA	/oracle/oradata/EDB02/condata_10G	754	0	4.27	1.01	406	0	0	0.00
CONFIG_INDEX	/oracle/oradata/EDB02/conidx_5G	2	0	30.00	1.00	2	0	0	0.00
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_01	21	0	2.38	1.00	649	0	29	0.34
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_02	2	0	10.00	1.00	353	0	0	0.00
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_03	2	0	10.00	1.00	20	0	0	0.00
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_04	4	0	22.50	1.00	264	0	15	0.00
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_05	7	0	14.29	1.00	552	0	165	0.12
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_06	2	0	25.00	1.00	15	0	0	0.00
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_07	435	0	6.18	1.00	6	0	0	0.00
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_08	2	0	10.00	1.00	220	0	1	0.00
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_09	3	0	10.00	1.00	526	0	0	0.00
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_10	2	0	10.00	1.00	584	0	17	0.00
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_11	2	0	30.00	1.00	298	0	3	0.00
DLOG_DATA	/oracle/oradata/EDB02/dlogdata_30G_12	2	0	25.00	1.00	8	0	0	0.00
DLOG_INDEX	/oracle/oradata/EDB02/dlogidx_30G_01	28	0	14.64	1.00	2,362	1	4	0.00
DLOG_INDEX	/oracle/oradata/EDB02/dlogidx_30G_02	68	0	8.82	1.00	2,005	0	10	0.00
REPORT_TXN_DATA	/oracle/oradata/EDB02/reptxndata_10G_01	2	0	15.00	1.00	2	0	0	0.00
REPORT_TXN_DATA	/oracle/oradata/EDB02/reptxndata_10G_02	2	0	30.00	1.00	2	0	0	0.00
REPORT_TXN_DATA	/oracle/oradata/EDB02/reptxndata_10G_03	2	0	25.00	1.00	2	0	0	0.00
REPORT_TXN_DATA	/oracle/oradata/EDB02/reptxndata_10G_04	19	0	7.37	1.00	2	0	0	0.00
REPORT_TXN_DATA	/oracle/oradata/EDB02/reptxndata_10G_05	2,552	1	2.12	1.00	2	0	0	0.00
REPORT_TXN_INDEX	/oracle/oradata/EDB02/reptxnidx_15G	114	0	7.02	1.00	2,085	0	222	0.09
SAF_DATA	/oracle/oradata/EDB02/safdata_10G_01	75	0	6.67	1.00	510	0	9	0.00
SAF_DATA	/oracle/oradata/EDB02/safdata_10G_02	23	0	12.17	1.00	517	0	4	0.00
SAF_DATA	/oracle/oradata/EDB02/safdata_10G_03	54	0	9.63	1.00	1,119	0	6	0.00
SAF_DATA	/oracle/oradata/EDB02/safdata_10G_04	18	0	15.56	1.00	660	0	4	0.00
SAF_DATA	/oracle/oradata/EDB02/safdata_10G_05	46	0	9.13	1.00	380	0	6	0.00
SAF_INDEX	/oracle/oradata/EDB02/safidx_15G	19	0	6.84	1.00	2	0	0	0.00
SETTLE_TXN_DATA	/oracle/oradata/EDB02/settxndata_2G	2	0	30.00	1.00	2	0	0	0.00
SETTLE_TXN_INDEX	/oracle/oradata/EDB02/settxnidx_1G	2	0	30.00	1.00	2	0	0	0.00
SYSAUX	/oracle/oradata/EDB02/sysaux_10G	601	0	8.09	1.00	349	0	0	0.00
SYSTEM	/oracle/oradata/EDB02/system_10G	222	0	5.36	1.00	275	0	0	0.00
TEMP	/oracle/oradata/EDB02/temp_10G_01	36,779	9	48.03	3.22	3,257	1	0
TEMP	/oracle/oradata/EDB02/temp_10G_02	183	0	0.27	1.00	191	0	0
TEMP	/oracle/oradata/EDB02/temp_10G_03	182	0	0.55	1.00	188	0	0
TEMP	/oracle/oradata/EDB02/temp_10G_04	219	0	4.89	1.00	224	0	0
TEMP	/oracle/oradata/EDB02/temp_10G_05	26	0	0.38	1.00	31	0	0
TLOG_DATA	/oracle/oradata/EDB02/tlogdata_30G_01	43,930	10	2.83	15.95	7	0	0	0.00
TLOG_DATA	/oracle/oradata/EDB02/tlogdata_30G_02	39,776	9	2.83	15.73	327	0	75	0.13
TLOG_DATA	/oracle/oradata/EDB02/tlogdata_30G_03	39,563	9	2.91	15.95	217	0	76	0.79
TLOG_DATA	/oracle/oradata/EDB02/tlogdata_30G_04	39,762	9	3.27	15.86	272	0	9	0.00
TLOG_DATA	/oracle/oradata/EDB02/tlogdata_30G_05	39,788	9	3.08	15.69	332	0	27	0.00
TLOG_INDEX	/oracle/oradata/EDB02/tlogidx_30G_01	46,000	11	7.78	1.00	31,166	7	8	0.00
TLOG_INDEX	/oracle/oradata/EDB02/tlogidx_30G_02	40,669	10	7.62	1.00	28,730	7	24	0.42
UNDOTBS1	/oracle/oradata/EDB02/undotbs_10G_01	48	0	16.46	1.00	17,145	4	16	0.00
UNDOTBS1	/oracle/oradata/EDB02/undotbs_10G_02	45	0	7.56	1.00	16,560	4	22	0.00
UNDOTBS1	/oracle/oradata/EDB02/undotbs_10G_03	36	0	7.22	1.00	17,114	4	17	0.00
UNDOTBS1	/oracle/oradata/EDB02/undotbs_10G_04	41	0	9.51	1.00	16,637	4	20	0.00
UNDOTBS1	/oracle/oradata/EDB02/undotbs_10G_05	28	0	12.14	1.00	16,705	4	2,180	0.04
USERS	/oracle/oradata/EDB02/user_1G	2	0	25.00	1.00	2	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	1,286,400	90	33,597,213	3,397,834	472,801	0	0	3,485

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	92	17132	377033	3650442	5529600	3650442
E	0	77	7479	99440	610792	5529600	610792

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	2,048	0.10	128,640	2.70	11,975,442,147
D	4,096	0.20	257,280	1.18	5,225,741,361
D	6,144	0.30	385,920	1.07	4,729,239,885
D	8,192	0.40	514,560	1.04	4,595,178,875
D	10,240	0.50	643,200	1.02	4,528,248,560
D	12,288	0.60	771,840	1.01	4,489,590,903
D	14,336	0.70	900,480	1.01	4,469,603,300
D	16,384	0.80	1,029,120	1.00	4,457,561,446
D	18,432	0.90	1,157,760	1.00	4,448,088,592
D	20,480	1.00	1,286,400	1.00	4,438,731,159
D	22,528	1.10	1,415,040	1.00	4,427,612,486
D	24,576	1.20	1,543,680	1.00	4,417,769,903
D	26,624	1.30	1,672,320	0.99	4,408,334,986
D	28,672	1.40	1,800,960	0.99	4,399,476,410
D	30,720	1.50	1,929,600	0.99	4,391,712,744
D	32,768	1.60	2,058,240	0.99	4,385,106,795
D	34,816	1.70	2,186,880	0.99	4,379,328,009
D	36,864	1.80	2,315,520	0.99	4,374,298,517
D	38,912	1.90	2,444,160	0.98	4,369,631,463
D	40,960	2.00	2,572,800	0.88	3,909,986,271

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
51.15	3,278	3,130

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	15,360	13,055	1,518.92	29.56	1.95	100.00	0.00	1,048,576
E	15,360	13,118	1,215.88	0.00	0.00	0.00	0.00	1,048,576

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	6,880	6,880	0
64K	128K	25	25	0
128K	256K	2	2	0
256K	512K	2	2	0
512K	1024K	119	119	0
1M	2M	4	4	0
4M	8M	7	7	0
512M	1024M	4	0	4

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 %	Estd PGA Overalloc Count
1,920	0.13	4,468,432.56	1,778,986.50	72.00	14
3,840	0.25	4,468,432.56	1,621,637.18	73.00	0
7,680	0.50	4,468,432.56	1,621,637.18	73.00	0
11,520	0.75	4,468,432.56	1,621,637.18	73.00	0
15,360	1.00	4,468,432.56	1,619,810.74	73.00	0
18,432	1.20	4,468,432.56	1,603,556.49	74.00	0
21,504	1.40	4,468,432.56	1,603,556.49	74.00	0
24,576	1.60	4,468,432.56	1,603,556.49	74.00	0
27,648	1.80	4,468,432.56	1,603,556.49	74.00	0
30,720	2.00	4,468,432.56	1,603,556.49	74.00	0
46,080	3.00	4,468,432.56	1,603,556.49	74.00	0
61,440	4.00	4,468,432.56	1,603,556.49	74.00	0
92,160	6.00	4,468,432.56	1,603,556.49	74.00	0
122,880	8.00	4,468,432.56	1,603,556.49	74.00	0

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 (K)
2,048	0.20	1,070	215,596	630,319,771	1.00	25,037,624	1.03	183,864
3,072	0.30	2,092	282,689	630,901,620	1.00	24,455,775	1.01	326,455
4,096	0.40	3,114	338,112	630,951,019	1.00	24,406,376	1.00	337,265
5,120	0.50	4,137	403,751	630,986,671	1.00	24,370,724	1.00	343,107
6,144	0.60	5,160	461,020	631,004,479	1.00	24,352,916	1.00	346,682
7,168	0.70	6,182	512,836	631,014,791	1.00	24,342,604	1.00	349,011
8,192	0.80	7,205	597,774	631,021,113	1.00	24,336,282	1.00	350,665
9,216	0.90	8,225	708,028	631,024,522	1.00	24,332,873	1.00	351,873
10,240	1.00	9,248	789,290	631,026,477	1.00	24,330,918	1.00	352,778
11,264	1.10	10,271	861,281	631,027,739	1.00	24,329,656	1.00	353,479
12,288	1.20	11,294	927,133	631,028,682	1.00	24,328,713	1.00	354,038
13,312	1.30	12,317	978,785	631,029,448	1.00	24,327,947	1.00	354,498
14,336	1.40	13,340	1,038,240	631,030,118	1.00	24,327,277	1.00	354,888
15,360	1.50	14,363	1,151,549	631,030,698	1.00	24,326,697	1.00	355,218
16,384	1.60	15,386	1,216,696	631,031,236	1.00	24,326,159	1.00	355,512
17,408	1.70	16,409	1,279,785	631,031,740	1.00	24,325,655	1.00	355,772
18,432	1.80	17,432	1,367,059	631,032,221	1.00	24,325,174	1.00	356,008
19,456	1.90	18,455	1,433,150	631,032,682	1.00	24,324,713	1.00	356,221
20,480	2.00	19,477	1,503,513	631,033,098	1.00	24,324,297	1.00	356,411

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

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)
data block	1,202	0	0
undo header	2,249	0	0
1st level bmb	26	0	0
undo block	7	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (index contention)	357	357	0	357	37	104.58
PR-Process Startup	417	417	0	6	5	787.00
JS-Job Scheduler (queue lock)	21,136	21,136	0	140	0	1.84
RO-Multiple Object Reuse (fast object reuse)	36	36	0	4	0	37.75
CF-Controlfile Transaction	2,840	2,839	1	5	0	4.40
TX-Transaction (row lock contention)	1	1	0	1	0	1.00
FB-Format Block	762	762	0	1	0	0.00

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	107.84	293,078	1,718	17	180/180	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
01-Aug 04:18	1,840	30,338	0	5	180	0/0	0/0/0/0/0/0
01-Aug 04:08	1,945	31,720	0	5	180	0/0	0/0/0/0/0/0
01-Aug 03:58	1,991	32,840	0	5	180	0/0	0/0/0/0/0/0
01-Aug 03:48	2,170	34,948	0	7	180	0/0	0/0/0/0/0/0
01-Aug 03:38	2,187	35,800	45	5	180	0/0	0/0/0/0/0/0
01-Aug 03:28	33,585	38,899	1,718	16	180	0/0	0/0/0/0/0/0
01-Aug 03:18	31,677	42,110	1,116	17	180	0/0	0/0/0/0/0/0
01-Aug 03:08	32,441	46,423	514	7	180	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	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,926	0.00		0	0
AWR Alerted Metric Element list	81,199	0.00		0	0
Consistent RBA	234,230	0.00		0	0
FAL request queue	88	0.00		0	0
FAL subheap alocation	88	0.00		0	0
FIB s.o chain latch	490	0.00		0	0
FOB s.o list latch	1,779	0.00		0	0
In memory undo latch	1,823,534	0.07	0.73	0	257,721	0.00
JS Sh mem access	328	6.40	1.00	0	0
JS mem alloc latch	357	0.00		0	0
JS queue access latch	357	0.00		0	0
JS queue state obj latch	42,272	0.00		0	0
KMG MMAN ready and startup request latch	1,405	0.00		0	0
KTF sga latch	10	0.00		0	1,413	0.00
KWQMN job cache list latch	1	0.00		0	0
MQL Tracking Latch	0			0	84	0.00
Memory Management Latch	0			0	1,405	0.00
OS process	3,112	0.00		0	0
OS process allocation	4,126	0.00		0	0
OS process: request allocation	660	0.00		0	0
PL/SQL warning settings	1,388	0.00		0	0
SGA IO buffer pool latch	200,631	0.00		0	200,631	0.00
SQL memory manager latch	1	0.00		0	1,391	0.00
SQL memory manager workarea list latch	105,570	0.00		0	0
Shared B-Tree	151	0.00		0	0
X$KSFQP	30	0.00		0	0
active checkpoint queue latch	197,612	0.03	0.00	0	0
active service list	14,024	0.00		0	2,405	0.00
alert log latch	4	0.00		0	0
archive control	77	0.00		0	0
archive process latch	1,571	0.00		0	0
begin backup scn array	1,011	0.00		0	0
cache buffer handles	16,746	0.01	0.00	0	0
cache buffers chains	74,879,898	0.03	0.00	0	6,650,354	0.00
cache buffers lru chain	1,124,683	0.07	0.02	0	6,815,573	0.01
cache table scan latch	0			0	202,039	0.00
channel handle pool latch	662	0.00		0	0
channel operations parent latch	21,308	0.00		0	0
checkpoint queue latch	1,952,059	0.01	0.00	0	505,268	0.00
client/application info	5,968	0.00		0	0
commit callback allocation	300	0.00		0	0
compile environment latch	509	0.00		0	0
constraint object allocation	294	0.00		0	0
dictionary lookup	5	0.00		0	0
dml lock allocation	1,380,146	0.07	0.00	0	0
dummy allocation	1,026	0.00		0	0
enqueue hash chains	2,842,545	0.02	0.00	0	44	0.00
enqueues	1,112,906	0.11	0.00	0	0
event group latch	326	0.00		0	0
file cache latch	837	0.00		0	0
global KZLD latch for mem in SGA	300	0.00		0	0
global tx hash mapping	12,404	0.00		0	0
hash table column usage latch	255	0.00		0	834,650	0.00
hash table modification latch	88	0.00		0	0
job workq parent latch	0			0	364	0.00
job_queue_processes parameter latch	246	0.00		0	0
kks stats	1,121,207	0.35	0.28	1	0
kokc descriptor allocation latch	12	0.00		0	0
krbmrosl	213	0.00		0	0
ksuosstats global area	283	0.00		0	0
ktm global data	121	0.00		0	0
kwqbsn:qsga	151	0.00		0	0
lgwr LWN SCN	235,105	0.15	0.00	0	0
library cache	10,703,940	0.40	0.15	11	973,271	3.09
library cache load lock	654	0.00		0	0
library cache lock	7,606,833	0.01	0.01	0	343	0.00
library cache lock allocation	39,870	0.00		0	0
library cache pin	2,777,327	0.01	0.00	0	0
library cache pin allocation	1,727	0.00		0	0
list of block allocation	20,329	0.00		0	0
loader state object freelist	9,890	0.00		0	0
longop free list parent	3,767	0.00		0	14	0.00
message pool operations parent latch	12	0.00		0	0
messages	1,139,846	0.05	0.00	0	0
mostly latch-free SCN	235,633	0.35	0.00	0	0
multiblock read objects	404,705	0.00		0	0
ncodef allocation latch	67	0.00		0	0
object queue header heap	5,371	0.00		0	4,881	0.00
object queue header operation	8,744,665	0.01	0.01	0	0
object stats modification	4	0.00		0	0
parallel query alloc buffer	556	0.00		0	0
parameter list	14	0.00		0	0
parameter table management	2,077	0.00		0	0
post/wait queue	412,392	0.00	0.00	0	305,193	0.02
process allocation	660	0.00		0	326	0.00
process group creation	660	0.00		0	0
qmn task queue latch	604	0.17	1.00	0	0
redo allocation	1,225,754	0.02	0.01	0	1,938,040	0.09
redo copy	0			0	1,938,702	0.04
redo writing	905,068	0.02	0.01	0	0
resmgr group change latch	1,342	0.00		0	0
resmgr:active threads	1,011	0.00		0	0
resmgr:actses change group	482	0.00		0	0
resmgr:free threads list	1,010	0.00		0	0
resmgr:resource group CPU method	490	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	23,759,416	0.34	0.00	0	93	1.08
sequence cache	2,648	0.00		0	0
session allocation	519,395	0.20	0.00	0	0
session idle bit	9,778,689	0.01	0.00	0	0
session state list latch	2,123	0.00		0	0
session switching	1,737	0.00		0	0
session timer	1,412	0.00		0	0
shared pool	15,245,462	0.39	0.14	13	0
shared pool simulator	2,025,740	0.01	0.09	1	0
simulator hash latch	2,561,637	0.00	0.00	0	0
simulator lru latch	472,819	0.03	0.01	0	1,655,091	0.02
slave class	8	0.00		0	0
slave class create	44	2.27	1.00	0	0
sort extent pool	145	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	263	0.00		0	0
transaction allocation	8,334	0.00		0	0
transaction branch allocation	2,032	0.00		0	0
undo global data	9,116,147	0.14	0.02	0	0
user lock	1,568	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
row cache objects	23,759,416	80,376	30	80,346
shared pool	15,245,462	60,029	8,518	51,707
library cache	10,703,940	42,376	6,451	39,563
cache buffers chains	74,879,898	21,439	70	21,372
undo global data	9,116,147	12,645	290	12,635
kks stats	1,121,207	3,905	1,080	2,878
In memory undo latch	1,823,534	1,252	913	341
enqueues	1,112,906	1,188	1	1,187
library cache lock	7,606,833	1,000	13	987
dml lock allocation	1,380,146	954	2	952
cache buffers lru chain	1,124,683	828	15	813
session idle bit	9,778,689	515	1	514
object queue header operation	8,744,665	442	3	439
shared pool simulator	2,025,740	202	19	183
redo allocation	1,225,754	184	2	182
simulator lru latch	472,819	161	2	159
redo writing	905,068	143	2	141
JS Sh mem access	328	21	21	0
qmn task queue latch	604	1	1	0
slave class create	44	1	1	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
In memory undo latch	ktiFlush: child	755	338
In memory undo latch	kticmt: child	301	207
In memory undo latch	ktichg: child	2	492
JS Sh mem access	jsksGetShMemLatch	21	21
cache buffers chains	kcbgtcr: fast path	46	7
cache buffers chains	kcbgtcr: kslbegin excl	40	19
cache buffers chains	kcbgcur: kslbegin	22	19
cache buffers chains	kcbchg: kslbegin: bufs not pinned	15	37
cache buffers chains	kcbget: pin buffer	12	0
cache buffers chains	kcbrls: kslbegin	2	23
cache buffers chains	kcbnlc	1	6
cache buffers chains	kcbzwb	1	0
cache buffers lru chain	kcbzgws	13	0
cache buffers lru chain	kcbzar: KSLNBEGIN	2	0
dml lock allocation	ktaidm	2	2
enqueues	ksqdel	1	0
event range base latch	No latch	2	1
kks stats	kks stats alloc/free	1,080	1,080
library cache	kglpndl: child: after processing	199	2
library cache	kglobpn: child:	112	237
library cache	kgldti: 2child	64	32
library cache	kglukp: child	54	83
library cache	kglpin	50	18
library cache	kglhdgn: child:	32	120
library cache	kglivl: child	12	0
library cache	kglhdiv: child	7	0
library cache	kgldte: child 0	3	20
library cache	kglpndl: child: before processing	3	157
library cache	kglhdgc: child:	2	9
library cache	kglScanDependency	1	0
library cache	kglobld	1	13
library cache lock	kgllkdl: child: no lock handle	35	53
library cache lock	kgllkdl: child: cleanup	9	1
library cache lock	kglget: un-set reserved lock	2	0
library cache lock	kgllkal: child: multiinstance	1	12
object queue header operation	kcbo_switch_cq	2	0
object queue header operation	kcbo_switch_q_bg	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	2	0
redo writing	kcrfw_post: rba scn pair	1	0
redo writing	kcrfwcr	1	2
row cache objects	kqreqd: reget	25	2
row cache objects	kqrpre: find obj	4	26
row cache objects	kqreqd	1	2
session idle bit	ksupuc: set busy	1	0
shared pool	kghalo	6,121	3,334
shared pool	kghfrunp: clatch: wait	5,567	5,704
shared pool	kghfrunp: alloc: wait	1,610	1,430
shared pool	kghupr1	481	1,609
shared pool	kghfrunp: clatch: nowait	309	0
shared pool	kghalp	129	1,212
shared pool	kghfre	125	633
shared pool	kghasp	51	300
shared pool	kghfrh	1	0
shared pool simulator	kglsim_unpin_simhp	16	1
shared pool simulator	kglsim_upd_newhp	2	11
shared pool simulator	kglsim_scan_lru: scan	1	5
simulator lru latch	kcbs_simulate: simulate set	2	0
slave class create	ksvcreate	1	0
undo global data	ktumof: KSLBEGIN	286	0
undo global data	ktudba: KSLBEGIN	3	4
undo global data	ktucof: at start	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: 33,605,474
Captured Segments account for 72.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
APPUSER	APPSTL	PKTLOG1		INDEX	9,374,928	27.90
APPUSER	TLOG_DATA	TLOG	G_20130731	TABLE PARTITION	3,213,568	9.56
APPUSER	TLOG_INDEX	GETTRSINFIDX		INDEX	1,110,144	3.30
APPUSER	DLOG_DATA	IND_CUTOFFDAY11		INDEX	1,042,640	3.10
APPUSER	SAF_DATA	PKRUNNING_TRANS11		INDEX	1,015,744	3.02

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 3,514,528
Captured Segments account for 96.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
APPUSER	TLOG_DATA	TLOG	G_20130731	TABLE PARTITION	3,212,119	91.40
APPUSER	APPSTL	PKTLOG1		INDEX	98,359	2.80
APPUSER	TLOG_INDEX	GETTRSINFIDX		INDEX	86,629	2.46
SYS	SYSAUX	WRI$_ADV_PARAMETERS_PK		INDEX	181	0.01
SYS	SYSAUX	WRI$_ADV_PARAMETERS		TABLE	120	0.00

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
APPUSER	APPSTL	PKTLOG1	INDEX	279	70.45
APPUSER	TLOG_INDEX	GETTRSINFIDX	INDEX	48	12.12
APPUSER	REPORT_TXN_INDEX	IND_OSN11	INDEX	38	9.60
APPUSER	DLOG_DATA	IND_CUTOFFDAY11	INDEX	14	3.54
APPUSER	SAF_DATA	PKRUNNING_TRANS11	INDEX	10	2.53

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

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
APPUSER	APPSTL	PKTLOG1		INDEX	473	38.52
APPUSER	DLOG_DATA	IND_CUTOFFDAY11		INDEX	229	18.65
APPUSER	REPORT_TXN_INDEX	IND_OSN11		INDEX	222	18.08
APPUSER	TLOG_DATA	TLOG	G_20130801	TABLE PARTITION	187	15.23
APPUSER	APPSTL	RUNNING_TRANS	S_20130801	TABLE PARTITION	41	3.34

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	75	0.00	2	1
dc_database_links	5,797	0.00	0	5
dc_files	3,500	0.00	0	50
dc_global_oids	1,796	0.00	0	124
dc_histogram_data	353	0.00	0	340
dc_histogram_defs	2,651,939	0.20	49	11,495
dc_object_ids	3,013,584	0.00	3	2,128
dc_objects	587,148	0.01	185	1,590
dc_profiles	650	0.00	0	1
dc_rollback_segments	62,444	0.00	0	2,714
dc_segments	910,277	0.02	43	5,379
dc_sequences	16	0.00	16	4
dc_tablespace_quotas	30	0.00	30	7
dc_tablespaces	22,756	0.00	0	18
dc_usernames	10,631	0.00	0	46
dc_users	651,613	0.00	0	69
global database name	498	0.00	0	1
outstanding_alerts	90	0.00	0	18

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	4,420	0.00	5,594	0.00	0	0
CLUSTER	9	0.00	20	0.00	0	0
INDEX	45	2.22	76	26.32	19	0
SQL AREA	681,579	96.96	2,871,625	34.54	136	43,274
TABLE/PROCEDURE	2,823	0.46	1,583,243	0.02	246	0
TRIGGER	9	0.00	9	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	1,160.93		1.04	2.12	63	63	1,112	1,112
	Freeable	351.63	0.00	0.74	8.82	192		476	476
	SQL	4.09	0.24	0.00	0.06	2	3	1,099	448
	PL/SQL	2.58	0.59	0.00	0.00	0	0	1,110	1,110
E	Other	1,053.06		0.95	0.62	11	11	1,104	1,104
	Freeable	157.06	0.00	0.33	0.71	7		470	470
	SQL	3.83	0.21	0.00	0.06	2	3	1,091	453
	PL/SQL	2.24	0.34	0.00	0.00	0	0	1,102	1,102

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	21,474,836,480
Fixed Size	2,167,704
Redo Buffers	14,606,336
Variable Size	17,179,872,360

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	1,024.00	1,024.00	0.00
large	free memory	5,120.00	5,120.00	0.00
shared	CCursor	744.28	1,269.74	70.60
shared	Cursor Stats	151.76	151.76	0.00
shared	PCursor	1,065.13	1,078.13	1.22
shared	free memory	5,227.13	1,759.39	-66.34
shared	kglsim heap	188.96	188.96	0.00
shared	kglsim object batch	242.72	242.72	0.00
shared	library cache	1,072.68	934.29	-12.90
shared	sql area	932.61	3,997.22	328.60
	buffer_cache	20,480.00	20,480.00	0.00
	fixed_sga	2.07	2.07	0.00
	log_buffer	13.93	13.93	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

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
sessions	1,111	4,511	4511	4511

init.ora Parameters

Parameter Name	Begin value	End value (if different)
_first_spare_parameter	1
_highthreshold_undoretention	10800
audit_file_dest	/oracle/admin/EDB02/adump
background_dump_dest	/oracle/admin/EDB02/bdump
compatible	10.2.0.5.0
control_files	/oracle/oradata/EDB02/control_1G_01, /oracle/oradata/EDB02/control_1G_02, /oracle/oradata/EDB02/control_1G_03
core_dump_dest	/oracle/admin/EDB02/cdump
db_block_size	16384
db_cache_size	21474836480
db_domain
db_file_multiblock_read_count	16
db_name	EDB02
db_recovery_file_dest_size	2684354560000
db_writer_processes	4
dispatchers	(PROTOCOL=TCP) (SERVICE=EDB02XDB)
hash_area_size	314572800
java_pool_size	1073741824
job_queue_processes	10
large_pool_size	5368709120
lock_sga	TRUE
log_archive_dest_1	location=/oracle/arch/
open_cursors	900
optimizer_dynamic_sampling	0
pga_aggregate_target	16106127360
processes	4096
remote_login_passwordfile	EXCLUSIVE
session_cached_cursors	500
sessions	4511
shared_pool_size	10737418240
sort_area_size	314572800
spfile	/oracle/oradata/EDB02/spfile_1G
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/admin/EDB02/udump

End of Report

% Blocks changed per Read:	13.98	Recursive Call %:	20.33
Rollback per transaction %:	2.51	Rows per Sort:	604.33

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	89.89	In-memory Sort %:	99.99
Library Hit %:	77.76	Soft Parse %:	84.72
Execute to Parse %:	0.66	Latch Hit %:	99.87
Parse CPU to Parse Elapsd %:	8.22	% Non-Parse CPU:	98.30