WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

DB 2956334532 db 1 10.2.0.3.0 NO host

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
DB	2956334532	db	1	10.2.0.3.0	NO	host

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 12155 26-Feb-10 20:00:05 63 28.0

End Snap: 12157 26-Feb-10 22:00:12 64 28.2

Elapsed: 120.11 (mins)

DB Time: 3,692.41 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	12155	26-Feb-10 20:00:05	63	28.0
End Snap:	12157	26-Feb-10 22:00:12	64	28.2
Elapsed:		120.11 (mins)
DB Time:		3,692.41 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 7,712M 7,696M Std Block Size: 8K

Shared Pool Size: 384M 400M Log Buffer: 14,344K

	Begin	End
Buffer Cache:	7,712M	7,696M	Std Block Size:	8K
Shared Pool Size:	384M	400M	Log Buffer:	14,344K

Load Profile

Per Second Per Transaction

Redo size: 6,755,257.60 32,466.91

Logical reads: 764,713.65 3,675.34

Block changes: 49,158.79 236.27

Physical reads: 570.98 2.74

Physical writes: 1,408.36 6.77

User calls: 4,731.36 22.74

Parses: 5,689.47 27.34

Hard parses: 1.41 0.01

Sorts: 16,924.41 81.34

Logons: 0.62 0.00

Executes: 19,663.99 94.51

Transactions: 208.07

	Per Second	Per Transaction
Redo size:	6,755,257.60	32,466.91
Logical reads:	764,713.65	3,675.34
Block changes:	49,158.79	236.27
Physical reads:	570.98	2.74
Physical writes:	1,408.36	6.77
User calls:	4,731.36	22.74
Parses:	5,689.47	27.34
Hard parses:	1.41	0.01
Sorts:	16,924.41	81.34
Logons:	0.62	0.00
Executes:	19,663.99	94.51
Transactions:	208.07

% Blocks changed per Read: 6.43 Recursive Call %: 88.21

Rollback per transaction %: 0.00 Rows per Sort: 7.23

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.64 Redo NoWait %: 100.00

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

Library Hit %: 99.64 Soft Parse %: 99.98

Execute to Parse %: 71.07 Latch Hit %: 92.32

Parse CPU to Parse Elapsd %: 18.76 % Non-Parse CPU: 98.53

Shared Pool Statistics

Begin End

Memory Usage %: 59.20 56.70

% SQL with executions>1: 82.62 77.91

% Memory for SQL w/exec>1: 81.36 78.49

	Begin	End
Memory Usage %:	59.20	56.70
% SQL with executions>1:	82.62	77.91
% Memory for SQL w/exec>1:	81.36	78.49

Top 5 Timed Events

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

CPU time 58,086 26.2

latch: cache buffers chains 80,322,310 42,543 1 19.2 Concurrency

log file sync 2,455,545 34,448 14 15.5 Commit

buffer busy waits 19,630,492 19,349 1 8.7 Concurrency

enq: TX - index contention 2,254,492 18,625 8 8.4 Concurrency

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		58,086		26.2
latch: cache buffers chains	80,322,310	42,543	1	19.2	Concurrency
log file sync	2,455,545	34,448	14	15.5	Commit
buffer busy waits	19,630,492	19,349	1	8.7	Concurrency
enq: TX - index contention	2,254,492	18,625	8	8.4	Concurrency

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): 221544.5s
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	185,690.13	83.82
DB CPU	58,085.94	26.22
parse time elapsed	5,169.72	2.33
PL/SQL execution elapsed time	3,480.59	1.57
hard parse elapsed time	1,211.31	0.55
sequence load elapsed time	195.37	0.09
PL/SQL compilation elapsed time	72.87	0.03
repeated bind elapsed time	47.43	0.02
hard parse (sharing criteria) elapsed time	47.29	0.02
hard parse (bind mismatch) elapsed time	46.37	0.02
connection management call elapsed time	28.45	0.01
failed parse elapsed time	0.34	0.00
DB time	221,544.48
background elapsed time	32,797.71
background cpu time	969.84

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	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Concurrency	102,878,339	0.60	87,477	1	68.61
Commit	2,455,545	0.00	34,448	14	1.64
Other	4,347,578	78.96	20,337	5	2.90
User I/O	2,871,647	0.00	15,964	6	1.92
Configuration	27,752	16.62	208	8	0.02
Network	39,060,626	0.00	43	0	26.05
System I/O	587,261	0.00	26	0	0.39
Application	4,052	0.00	4	1	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)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
latch: cache buffers chains	80,322,310	0.00	42,543	1	53.57
log file sync	2,455,545	0.00	34,448	14	1.64
buffer busy waits	19,630,492	0.00	19,349	1	13.09
enq: TX - index contention	2,254,492	0.09	18,625	8	1.50
buffer exterminate	17,492	94.62	16,370	936	0.01
db file sequential read	2,789,491	0.00	15,396	6	1.86
cursor: pin S wait on X	611,903	99.74	6,571	11	0.41
wait list latch free	173,190	0.00	1,898	11	0.12
SGA: allocation forcing component growth	112,244	98.65	1,208	11	0.07
buffer deadlock	3,467,702	95.32	598	0	2.31
db file scattered read	37,899	0.00	370	10	0.03
library cache load lock	576	8.33	364	632	0.00
read by other session	43,288	0.00	197	5	0.03
latch: undo global data	191,879	0.00	144	1	0.13
enq: SQ - contention	15,101	0.14	120	8	0.01
latch free	117,810	0.00	82	1	0.08
log file switch completion	5,751	0.00	80	14	0.00
SQL*Net message to client	39,040,260	0.00	39	0	26.04
control file parallel write	4,746	0.00	16	3	0.00
latch: library cache	13,941	0.00	14	1	0.01
latch: redo allocation	25,157	0.00	13	0	0.02
log file parallel write	576,429	0.00	10	0	0.38
enq: TX - allocate ITL entry	2,258	0.00	8	4	0.00
latch: cache buffers lru chain	13,870	0.00	6	0	0.01
LGWR wait for redo copy	34,793	0.00	5	0	0.02
cursor: pin S	176,600	0.00	5	0	0.12
enq: TX - row lock contention	16	0.00	4	252	0.00
latch: library cache lock	5,085	0.00	4	1	0.00
kksfbc child completion	98	69.39	3	35	0.00
SQL*Net more data from client	2,194	0.00	2	1	0.00
latch: enqueue hash chains	4,185	0.00	2	1	0.00
latch: library cache pin	2,795	0.00	2	1	0.00
os thread startup	68	0.00	2	29	0.00
SQL*Net more data to client	18,172	0.00	2	0	0.01
latch: object queue header operation	10,416	0.00	2	0	0.01
latch: shared pool	2,109	0.00	1	1	0.00
db file parallel read	11	0.00	1	133	0.00
rdbms ipc reply	1,103	0.00	1	1	0.00
latch: session allocation	684	0.00	1	1	0.00
db file parallel write	961	0.00	0	0	0.00
control file sequential read	4,745	0.00	0	0	0.00
log file single write	190	0.00	0	1	0.00
SQL*Net break/reset to client	4,036	0.00	0	0	0.00
latch: checkpoint queue latch	305	0.00	0	0	0.00
cursor: mutex X	19,761	0.00	0	0	0.01
undo segment extension	4,619	99.37	0	0	0.00
enq: HW - contention	19	0.00	0	1	0.00
latch: cache buffer handles	27	0.00	0	1	0.00
cursor: mutex S	14,794	0.00	0	0	0.01
latch: messages	23	0.00	0	0	0.00
latch: row cache objects	6	0.00	0	1	0.00
direct path write	483	0.00	0	0	0.00
direct path read	475	0.00	0	0	0.00
log file sequential read	190	0.00	0	0	0.00
latch: redo writing	4	0.00	0	0	0.00
row cache lock	7	0.00	0	0	0.00
SQL*Net message from client	39,040,247	0.00	102,119	3	26.04
Streams AQ: qmn slave idle wait	257	0.00	7,012	27284	0.00
Streams AQ: qmn coordinator idle wait	522	50.77	7,012	13433	0.00
jobq slave wait	1,266	88.31	3,533	2790	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100.00	2,471	2470679	0.00
SGA: MMAN sleep for component shrink	14,979	99.53	162	11	0.01
PL/SQL lock timer	1	100.00	1	978	0.00
class slave wait	6	0.00	0	0	0.00

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
control file parallel write	4,746	0.00	16	3	0.00
log file parallel write	576,431	0.00	10	0	0.38
events in waitclass Other	45,913	0.00	9	0	0.03
db file sequential read	405	0.00	3	8	0.00
os thread startup	68	0.00	2	29	0.00
db file scattered read	65	0.00	1	12	0.00
latch: cache buffers chains	268	0.00	0	1	0.00
db file parallel write	961	0.00	0	0	0.00
latch: shared pool	227	0.00	0	1	0.00
log file single write	190	0.00	0	1	0.00
buffer busy waits	129	0.00	0	0	0.00
direct path read	475	0.00	0	0	0.00
direct path write	475	0.00	0	0	0.00
log file sequential read	190	0.00	0	0	0.00
latch: redo writing	3	0.00	0	0	0.00
latch: library cache lock	2	0.00	0	0	0.00
control file sequential read	3,381	0.00	-0	-0	0.00
rdbms ipc message	222,950	8.47	49,093	220	0.15
pmon timer	4,753	60.07	7,030	1479	0.00
Streams AQ: qmn slave idle wait	257	0.00	7,012	27284	0.00
Streams AQ: qmn coordinator idle wait	522	50.77	7,012	13433	0.00
smon timer	375	1.07	7,010	18694	0.00
Streams AQ: waiting for time management or cleanup tasks	1	100.00	2,471	2470679	0.00
SGA: MMAN sleep for component shrink	14,979	99.53	162	11	0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	5,664,647
IDLE_TIME	5,752,680
IOWAIT_TIME	1,075,858
NICE_TIME	0
SYS_TIME	505,642
USER_TIME	5,021,419
LOAD	17
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	86,164
NUM_CPUS	16
NUM_CPU_SOCKETS	4

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
db	202,897.60	55,047.30	1,917,035	5,325,899,571
SYS$USERS	18,645.60	3,038.20	2,192,059	184,529,739
SYS$BACKGROUND	0.00	0.00	5,274	335,964

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
db	1502567	880919	102849188	8741941	36848529	3715
SYS$USERS	1364542	713521	29617	5594	2198875	561
SYS$BACKGROUND	4564	1965	694	245	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
68,376	25,760	855,259	0.08	30.86	d4k5y7x311ty3	wsql@other_host (TNS V1-V3)	declare p_reqid number; be...
57,956	36,297	16,025,112	0.00	26.16	f5ayhb84bcwfs		SELECT VAL_BODY FROM IN_VALUES...
43,515	13,849	31,795,543	0.00	19.64	07kc288684rp9	wsql@other_host (TNS V1-V3)	INSERT INTO IN_VALUES (REQUEST...
10,908	1,310	414,469	0.03	4.92	63ppp6nrwk5qf	wsql@other_host (TNS V1-V3)	declare ri number; begin ri:=:...
7,517	618	367,378	0.02	3.39	838f8ksr03958	wsql@other_host (TNS V1-V3)	INSERT INTO RADIUS_LOG (APID, ...
6,482	309	8	810.21	2.93	gc3jj7ur0hg2s		DECLARE job BINARY_INTEGER := ...
4,950	1,470	320,588	0.02	2.23	fhxnx237xy239	wsql@other_host (TNS V1-V3)	DELETE FROM RADIUS_SESSION WHE...
3,752	60	93,624	0.04	1.69	405gcnun6b2t4	wsql@other_host (TNS V1-V3)	INSERT INTO MASK_STAT (MASK, M...
2,458	1,450	969,029	0.00	1.11	dwa3bwp2znkg4		SELECT VAL_BODY, POS, 1 ORD FR...
1,938	1,931	3,929,227	0.00	0.87	63z1wm3mj4yxv		SELECT AIPID FROM AUTH_MAP AM,...

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
36,297	57,956	16,025,112	0.00	26.16	f5ayhb84bcwfs		SELECT VAL_BODY FROM IN_VALUES...
25,760	68,376	855,259	0.03	30.86	d4k5y7x311ty3	wsql@other_host (TNS V1-V3)	declare p_reqid number; be...
13,849	43,515	31,795,543	0.00	19.64	07kc288684rp9	wsql@other_host (TNS V1-V3)	INSERT INTO IN_VALUES (REQUEST...
1,931	1,938	3,929,227	0.00	0.87	63z1wm3mj4yxv		SELECT AIPID FROM AUTH_MAP AM,...
1,470	4,950	320,588	0.00	2.23	fhxnx237xy239	wsql@other_host (TNS V1-V3)	DELETE FROM RADIUS_SESSION WHE...
1,467	1,915	922,607	0.00	0.86	gcaxrbj6dk2f2		SELECT MIN(VAL_BODY) FROM IN_V...
1,450	2,458	969,029	0.00	1.11	dwa3bwp2znkg4		SELECT VAL_BODY, POS, 1 ORD FR...
1,310	10,908	414,469	0.00	4.92	63ppp6nrwk5qf	wsql@other_host (TNS V1-V3)	declare ri number; begin ri:=:...
1,271	1,888	560,287	0.00	0.85	f6f3g8grbd1bj	wsql@other_host (TNS V1-V3)	begin au...
1,092	1,373	316,175	0.00	0.62	gcjmx3t8t76hx	wsql@other_host (TNS V1-V3)	declare ret number; spfid ...
618	7,517	367,378	0.00	3.39	838f8ksr03958	wsql@other_host (TNS V1-V3)	INSERT INTO RADIUS_LOG (APID, ...
309	6,482	8	38.63	2.93	gc3jj7ur0hg2s		DECLARE job BINARY_INTEGER := ...
60	3,752	93,624	0.00	1.69	405gcnun6b2t4	wsql@other_host (TNS V1-V3)	INSERT INTO MASK_STAT (MASK, M...

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: 5,510,842,395
Captured SQL account for 85.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,994,369,840	855,259	3,501.13	54.34	25759.65	68375.60	d4k5y7x311ty3	wsql@other_host (TNS V1-V3)	declare p_reqid number; be...
2,905,597,928	16,025,112	181.32	52.73	36296.97	57955.66	f5ayhb84bcwfs		SELECT VAL_BODY FROM IN_VALUES...
474,317,490	3,929,227	120.72	8.61	1931.24	1937.67	63z1wm3mj4yxv		SELECT AIPID FROM AUTH_MAP AM,...
266,870,324	31,795,543	8.39	4.84	13848.64	43515.15	07kc288684rp9	wsql@other_host (TNS V1-V3)	INSERT INTO IN_VALUES (REQUEST...
247,482,377	766,007	323.08	4.49	929.36	930.94	ghhjngw17k9zn		SELECT MM.DMID, DOMAINID, CLSR...
154,918,111	969,029	159.87	2.81	1450.11	2457.89	dwa3bwp2znkg4		SELECT VAL_BODY, POS, 1 ORD FR...
143,583,164	922,607	155.63	2.61	1466.62	1914.52	gcaxrbj6dk2f2		SELECT MIN(VAL_BODY) FROM IN_V...
131,513,879	320,588	410.23	2.39	1470.40	4949.79	fhxnx237xy239	wsql@other_host (TNS V1-V3)	DELETE FROM RADIUS_SESSION WHE...
122,575,821	403,243	303.98	2.22	572.45	675.63	gxu8m1nw5fvcz	wsql@other_host (TNS V1-V3)	SELECT DMID, CLSRV, ID FROM CL...
84,820,885	560,287	151.39	1.54	1271.22	1887.87	f6f3g8grbd1bj	wsql@other_host (TNS V1-V3)	begin au...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 4,114,705
Captured SQL account for 24.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,115,647	8	139,455.88	27.11	309.02	6481.71	gc3jj7ur0hg2s		DECLARE job BINARY_INTEGER := ...
644,190	855,259	0.75	15.66	25759.65	68375.60	d4k5y7x311ty3	wsql@other_host (TNS V1-V3)	declare p_reqid number; be...
173,504	31,795,543	0.01	4.22	13848.64	43515.15	07kc288684rp9	wsql@other_host (TNS V1-V3)	INSERT INTO IN_VALUES (REQUEST...
155,242	62	2,503.90	3.77	56.91	968.17	frnj6gn4wx6cb		DELETE FROM RADIUS_LOG WHERE L...
151,583	127,337	1.19	3.68	345.88	1582.64	8gm1mw66n7ckz	wsql@other_host (TNS V1-V3)	DELETE FROM RADIUS_SESSION WHE...
148,941	367,378	0.41	3.62	618.13	7516.77	838f8ksr03958	wsql@other_host (TNS V1-V3)	INSERT INTO RADIUS_LOG (APID, ...
124,156	269,661	0.46	3.02	435.53	870.25	4hwtx4qgzvt3r	wsql@other_host (TNS V1-V3)	UPDATE RADIUS_LOG SET TEST_DAT...
55,578	1,918,568	0.03	1.35	388.40	627.96	c684ztf7b542a	wsql@other_host (TNS V1-V3)	SELECT MM.DMID, DOMAINID, CLSR...
54,635	124,667	0.44	1.33	247.32	1078.08	4m56yad7j8nh3	wsql@other_host (TNS V1-V3)	begin ...
53,300	4	13,325.00	1.30	4.27	261.70	gnqy76tthk38s		SELECT NVL(MIN(LOG_ID), 0) FRO...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 141,706,805
Captured SQL account for 58.8% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
31,795,543	31,793,378	1.00	07kc288684rp9	wsql@other_host (TNS V1-V3)	INSERT INTO IN_VALUES (REQUEST...
16,025,112	14,163,208	0.88	f5ayhb84bcwfs		SELECT VAL_BODY FROM IN_VALUES...
5,160,703	894,874	0.17	8wqs1pm2hw2d6		SELECT ID, CLSRV, STARTDATE, E...
3,929,227	1,359,761	0.35	63z1wm3mj4yxv		SELECT AIPID FROM AUTH_MAP AM,...
1,918,568	1,153,275	0.60	c684ztf7b542a	wsql@other_host (TNS V1-V3)	SELECT MM.DMID, DOMAINID, CLSR...
1,365,045	1,365,072	1.00	bxwr9dpk74y6r		SELECT TZSPEC FROM AUTH_SERVIC...
1,359,299	1,359,351	1.00	dxpmwddr1u2zk		SELECT TYPECONNECT, NAS_PORT F...
1,335,446	1,334,945	1.00	2fkha82bjcw66	wsql@other_host (TNS V1-V3)	select in_id.nextval from dual
1,335,378	935,162	0.70	fm9730y9ky36u	wsql@other_host (TNS V1-V3)	select a...
969,029	525,425	0.54	dwa3bwp2znkg4		SELECT VAL_BODY, POS, 1 ORD FR...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 41,000,666
Captured SQL account for 40.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
1,335,558	1,335,446	3.26	2fkha82bjcw66	wsql@other_host (TNS V1-V3)	select in_id.nextval from dual
1,335,456	1,335,378	3.26	fm9730y9ky36u	wsql@other_host (TNS V1-V3)	select a...
855,167	855,259	2.09	d4k5y7x311ty3	wsql@other_host (TNS V1-V3)	declare p_reqid number; be...
583,026	923,577	1.42	cvua9shru1dta	wsql@other_host (TNS V1-V3)	SELECT MAX(FDEFAULT) FROM AUTH...
560,365	560,287	1.37	f6f3g8grbd1bj	wsql@other_host (TNS V1-V3)	begin au...
414,673	494,223	1.01	fchc10m8dnvnt		UPDATE AUTH_IP SET IPLOCK = NU...
414,463	414,469	1.01	63ppp6nrwk5qf	wsql@other_host (TNS V1-V3)	declare ri number; begin ri:=:...
410,960	922,835	1.00	bya143zstrjrf		SELECT MIN(HID) FROM AUTH_HOST...
410,850	922,607	1.00	gcaxrbj6dk2f2		SELECT MIN(VAL_BODY) FROM IN_V...
397,208	969,029	0.97	dwa3bwp2znkg4		SELECT VAL_BODY, POS, 1 ORD FR...

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
7,542,974	240	1.80	aykvshm7zsabd		select size_for_estimate, ...
2,872,757	930	0.68	3qhfkqtus2ub5	wsql@other_host (TNS V1-V3)	select spid, a.sfid, source_di...

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
2,963	403,243	gxu8m1nw5fvcz	wsql@other_host (TNS V1-V3)	SELECT DMID, CLSRV, ID FROM CL...
1,281	1,918,568	c684ztf7b542a	wsql@other_host (TNS V1-V3)	SELECT MM.DMID, DOMAINID, CLSR...
720	316,175	gcjmx3t8t76hx	wsql@other_host (TNS V1-V3)	declare ret number; spfid ...
631	560,287	f6f3g8grbd1bj	wsql@other_host (TNS V1-V3)	begin au...
201	766,007	ghhjngw17k9zn		SELECT MM.DMID, DOMAINID, CLSR...
140	53,941	6yu8ymu8xtzt8	wsql@other_host (TNS V1-V3)	SELECT MM.DMID, DOMAINID, CLSR...
29	31,795,543	07kc288684rp9	wsql@other_host (TNS V1-V3)	INSERT INTO IN_VALUES (REQUEST...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

07kc288684rp9 INSERT INTO IN_VALUES (REQUEST_ID, ATTR_COD, VENDORCOD, VAL_BODY, POS) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 )

2fkha82bjcw66 select in_id.nextval from dual

3qhfkqtus2ub5 select spid, a.sfid, source_dir, source_file, arch_dir, cron_str, asid, domainid, file_type, ascii(file_delim), nvl(ascii(file_opt_inc), 0), nvl(d_pos, 0), nvl(d_off, 0), nvl(d_serv, 0), nvl(a.tz, 0) from auth_stat_point a, auth_stat_files b where a.sfid=b.sfid

405gcnun6b2t4 INSERT INTO MASK_STAT (MASK, MDATE, USE1, USE2, DMID, TMID, SERVID, COST, SERVDOMID, FID, TDID, TDFID, REMARK, RATTR, TDIDBILL, USEFACT, ASID, PCOST, EDATE, SESSKEY) VALUES(:B19 , :B18 , :B6 /:B5 , 1, :B17 , :B16 , :B15 , :B14 *:B6 /:B5 , :B13 , :B12 , :B11 , :B10 , RTRIM(:B9 ), :B8 , :B7 , :B6 /:B5 , :B4 , :B3 , :B2 , :B1 )

4hwtx4qgzvt3r UPDATE RADIUS_LOG SET TEST_DATE=:B1 WHERE RID=:B2

4m56yad7j8nh3 begin auth_log.l_acode:=3; auth_log.l_ares:=:BRES; auth_log.l_session:=:BPASS; auth_log.make; end;

63ppp6nrwk5qf declare ri number; begin ri:=:REQID; ins_iv(ri, 202, 9997, :BV1, 1); ins_iv(ri, 1, 0, :BV2, 3); ins_iv(ri, 61, 0, :BV3, 5); ins_iv(ri, 5, 0, :BV4, 7); ins_iv(ri, 87, 0, :BV5, 8); ins_iv(ri, 4, 0, :BV6, 10); ins_iv(ri, 44, 0, :BV7, 11); ins_iv(ri, 100, 9999, :BV8, 13); ins_iv(ri, 1, 9999, :BV9, 15); ins_iv(ri, 17, 9999, :BV10, 16); ins_iv(ri, 15, 9999, :BV11, 17); ins_iv(ri, 7, 9999, :BV12, 18); ins_iv(ri, 51, 9999, :BV13, 19); ins_iv(ri, 52, 9999, :BV14, 20); end;

63z1wm3mj4yxv SELECT AIPID FROM AUTH_MAP AM, (SELECT HGID, LEVEL LHG FROM HOST_GROUP START WITH HGID IN(SELECT HGID FROM HOST_GLINK WHERE HID = :B1 ) CONNECT BY PRIOR HGUP = HGID ) HG WHERE DOMAINID = :B3 AND AM.HGID = HG.HGID AND ASID = :B2 ORDER BY AIPID DESC, HG.LHG

6yu8ymu8xtzt8 SELECT MM.DMID, DOMAINID, CLSRV FROM MAP_MAIN MM, AUTH_SPEC_PARAMS ASP WHERE VENDORCOD = :B4 AND DOMAINID = :B3 AND MM.DMID = ASP.DMID AND CLOSED = 4 AND ATTRCOD = 1 AND VALUE = :B2 AND TYPECONNECT = :B1 ORDER BY CLSRV DESC

838f8ksr03958 INSERT INTO RADIUS_LOG (APID, ASID, RID, HID, NAS_PORT, COME_FROM, SESSIONID, USER_NAME, USER_DOM, DMID, CLSRV, AUTH_DATE, AUTH_CODE, AUTH_RES, LOG_ID, DC_CODE) VALUES (:B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , RADIUS_LOG_ID.NEXTVAL, :B1 ) RETURNING ROWID INTO :O0

8gm1mw66n7ckz DELETE FROM RADIUS_SESSION WHERE ROWID = :B1

8wqs1pm2hw2d6 SELECT ID, CLSRV, STARTDATE, ENDDATE FROM CLFPRINTS WHERE STARTDATE<=:B2 AND (ENDDATE IS NULL OR ENDDATE>:B2 ) AND FPRINT=:B1 ORDER BY ENDDATE DESC

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

bxwr9dpk74y6r SELECT TZSPEC FROM AUTH_SERVICE WHERE ASID=:B1

bya143zstrjrf SELECT MIN(HID) FROM AUTH_HOST WHERE HADDR=:B1

c684ztf7b542a SELECT MM.DMID, DOMAINID, CLSRV FROM MAP_MAIN MM, AUTH_SPEC_PARAMS ASP WHERE VENDORCOD = :B4 AND DOMAINID = :B3 AND MM.DMID = ASP.DMID AND CLOSED !=4 AND ATTRCOD = 1 AND VALUE = :B2 AND ROWNUM <= 1 AND TYPECONNECT = :B1

cvua9shru1dta SELECT MAX(FDEFAULT) FROM AUTH_PARAMS WHERE ASID = :B1 AND FINIT = 200

d4k5y7x311ty3 declare p_reqid number; begin p_reqid:=:REQID; auth_account.radius_reply(p_reqid, :ID, :CODE, :HOST, :VEC, to_date(:DTS, 'dd.mm.yyyy hh24:mi:ss')); end;

dwa3bwp2znkg4 SELECT VAL_BODY, POS, 1 ORD FROM IN_VALUES A, RADIUS_ATTRIBUTES B WHERE A.ATTR_COD=B.ATTRCOD AND A.VENDORCOD=B.VENDORCOD AND A.REQUEST_ID=:B2 AND B.ATTRNAME=:B1 UNION SELECT VAL_BODY, POS, 2 ORD FROM OUT_VALUES A, RADIUS_ATTRIBUTES B WHERE A.ATTR_COD=B.ATTRCOD AND A.VENDORCOD=B.VENDORCOD AND A.REQUEST_ID=:B2 AND B.ATTRNAME=:B1 AND :B3 =1 ORDER BY 3, 2

dxpmwddr1u2zk SELECT TYPECONNECT, NAS_PORT FROM AUTH_SERVICE WHERE ASID = :B1

f5ayhb84bcwfs SELECT VAL_BODY FROM IN_VALUES WHERE REQUEST_ID = :B3 AND ATTR_COD = :B2 AND VENDORCOD = :B1

f6f3g8grbd1bj begin auth_account.authentificate( :BNAME, :BDOM, :BSID, :BRET, :BCODE, :BMSG, :BFPRINT); end;

fchc10m8dnvnt UPDATE AUTH_IP SET IPLOCK = NULL, NAS_PORT = NULL, HID = NULL, MDATE = SYSDATE WHERE HID = :B2 AND NAS_PORT = :B1

fhxnx237xy239 DELETE FROM RADIUS_SESSION WHERE HID=:B2 AND NAS_PORT=:B1

fm9730y9ky36u select a.attrtype, a.attrname, b.val_body from radius_attributes a, out_values b where a.attrcod=b.attr_cod and a.vendorcod=b.vendorcod and b.request_id=:BND_ID_ order by pos

frnj6gn4wx6cb DELETE FROM RADIUS_LOG WHERE LOG_ID >= :B4 AND LOG_ID < :B3 AND ROWNUM<=:B2 AND (AUTH_DATE IS NULL OR AUTH_DATE < SYSDATE - :B1 )

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

gcaxrbj6dk2f2 SELECT MIN(VAL_BODY) FROM IN_VALUES WHERE REQUEST_ID=:B1 AND ATTR_COD=4 AND VENDORCOD=0

gcjmx3t8t76hx declare ret number; spfid number; begin ret:=db_stat.find_sp(:FP); spfid:=db_stat.get_current_sp; :RES:=ret; :SPF:=spfid; end;

ghhjngw17k9zn SELECT MM.DMID, DOMAINID, CLSRV FROM MAP_MAIN MM, AUTH_SPEC_PARAMS ASP WHERE VENDORCOD = :B3 AND CLOSED != 4 AND DOMAINID IN( SELECT DOMAINID FROM AUTH_DOMAINS START WITH DOMAINID = :B4 CONNECT BY PRIOR DOMAINID = DOMAINIDUP) AND MM.DMID = ASP.DMID AND ATTRCOD = 1 AND VALUE = :B2 AND ROWNUM <= 1 AND TYPECONNECT = :B1

gnqy76tthk38s SELECT NVL(MIN(LOG_ID), 0) FROM RADIUS_LOG

gxu8m1nw5fvcz SELECT DMID, CLSRV, ID FROM CLFPRINTS FPT WHERE FPRINT = :B2 AND STARTDATE <= :B1 AND (ENDDATE > :B1 OR ENDDATE IS NULL) AND EXISTS( SELECT * FROM AUTH_SPEC_PARAMS ASP WHERE CLSRV = FPT.CLSRV AND EXISTS (SELECT * FROM MAP_MAIN WHERE DMID = ASP.DMID AND DOMAINID IN( SELECT DOMAINID FROM AUTH_DOMAINS START WITH DOMAINID = :B3 CONNECT BY PRIOR DOMAINID = DOMAINIDUP)))

SQL Id	SQL Text
07kc288684rp9	INSERT INTO IN_VALUES (REQUEST_ID, ATTR_COD, VENDORCOD, VAL_BODY, POS) VALUES (:B5 , :B4 , :B3 , :B2 , :B1 )
2fkha82bjcw66	select in_id.nextval from dual
3qhfkqtus2ub5	select spid, a.sfid, source_dir, source_file, arch_dir, cron_str, asid, domainid, file_type, ascii(file_delim), nvl(ascii(file_opt_inc), 0), nvl(d_pos, 0), nvl(d_off, 0), nvl(d_serv, 0), nvl(a.tz, 0) from auth_stat_point a, auth_stat_files b where a.sfid=b.sfid
405gcnun6b2t4	INSERT INTO MASK_STAT (MASK, MDATE, USE1, USE2, DMID, TMID, SERVID, COST, SERVDOMID, FID, TDID, TDFID, REMARK, RATTR, TDIDBILL, USEFACT, ASID, PCOST, EDATE, SESSKEY) VALUES(:B19 , :B18 , :B6 /:B5 , 1, :B17 , :B16 , :B15 , :B14 *:B6 /:B5 , :B13 , :B12 , :B11 , :B10 , RTRIM(:B9 ), :B8 , :B7 , :B6 /:B5 , :B4 , :B3 , :B2 , :B1 )
4hwtx4qgzvt3r	UPDATE RADIUS_LOG SET TEST_DATE=:B1 WHERE RID=:B2
4m56yad7j8nh3	begin auth_log.l_acode:=3; auth_log.l_ares:=:BRES; auth_log.l_session:=:BPASS; auth_log.make; end;
63ppp6nrwk5qf	declare ri number; begin ri:=:REQID; ins_iv(ri, 202, 9997, :BV1, 1); ins_iv(ri, 1, 0, :BV2, 3); ins_iv(ri, 61, 0, :BV3, 5); ins_iv(ri, 5, 0, :BV4, 7); ins_iv(ri, 87, 0, :BV5, 8); ins_iv(ri, 4, 0, :BV6, 10); ins_iv(ri, 44, 0, :BV7, 11); ins_iv(ri, 100, 9999, :BV8, 13); ins_iv(ri, 1, 9999, :BV9, 15); ins_iv(ri, 17, 9999, :BV10, 16); ins_iv(ri, 15, 9999, :BV11, 17); ins_iv(ri, 7, 9999, :BV12, 18); ins_iv(ri, 51, 9999, :BV13, 19); ins_iv(ri, 52, 9999, :BV14, 20); end;
63z1wm3mj4yxv	SELECT AIPID FROM AUTH_MAP AM, (SELECT HGID, LEVEL LHG FROM HOST_GROUP START WITH HGID IN(SELECT HGID FROM HOST_GLINK WHERE HID = :B1 ) CONNECT BY PRIOR HGUP = HGID ) HG WHERE DOMAINID = :B3 AND AM.HGID = HG.HGID AND ASID = :B2 ORDER BY AIPID DESC, HG.LHG
6yu8ymu8xtzt8	SELECT MM.DMID, DOMAINID, CLSRV FROM MAP_MAIN MM, AUTH_SPEC_PARAMS ASP WHERE VENDORCOD = :B4 AND DOMAINID = :B3 AND MM.DMID = ASP.DMID AND CLOSED = 4 AND ATTRCOD = 1 AND VALUE = :B2 AND TYPECONNECT = :B1 ORDER BY CLSRV DESC
838f8ksr03958	INSERT INTO RADIUS_LOG (APID, ASID, RID, HID, NAS_PORT, COME_FROM, SESSIONID, USER_NAME, USER_DOM, DMID, CLSRV, AUTH_DATE, AUTH_CODE, AUTH_RES, LOG_ID, DC_CODE) VALUES (:B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , RADIUS_LOG_ID.NEXTVAL, :B1 ) RETURNING ROWID INTO :O0
8gm1mw66n7ckz	DELETE FROM RADIUS_SESSION WHERE ROWID = :B1
8wqs1pm2hw2d6	SELECT ID, CLSRV, STARTDATE, ENDDATE FROM CLFPRINTS WHERE STARTDATE<=:B2 AND (ENDDATE IS NULL OR ENDDATE>:B2 ) AND FPRINT=:B1 ORDER BY ENDDATE DESC
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
bxwr9dpk74y6r	SELECT TZSPEC FROM AUTH_SERVICE WHERE ASID=:B1
bya143zstrjrf	SELECT MIN(HID) FROM AUTH_HOST WHERE HADDR=:B1
c684ztf7b542a	SELECT MM.DMID, DOMAINID, CLSRV FROM MAP_MAIN MM, AUTH_SPEC_PARAMS ASP WHERE VENDORCOD = :B4 AND DOMAINID = :B3 AND MM.DMID = ASP.DMID AND CLOSED !=4 AND ATTRCOD = 1 AND VALUE = :B2 AND ROWNUM <= 1 AND TYPECONNECT = :B1
cvua9shru1dta	SELECT MAX(FDEFAULT) FROM AUTH_PARAMS WHERE ASID = :B1 AND FINIT = 200
d4k5y7x311ty3	declare p_reqid number; begin p_reqid:=:REQID; auth_account.radius_reply(p_reqid, :ID, :CODE, :HOST, :VEC, to_date(:DTS, 'dd.mm.yyyy hh24:mi:ss')); end;
dwa3bwp2znkg4	SELECT VAL_BODY, POS, 1 ORD FROM IN_VALUES A, RADIUS_ATTRIBUTES B WHERE A.ATTR_COD=B.ATTRCOD AND A.VENDORCOD=B.VENDORCOD AND A.REQUEST_ID=:B2 AND B.ATTRNAME=:B1 UNION SELECT VAL_BODY, POS, 2 ORD FROM OUT_VALUES A, RADIUS_ATTRIBUTES B WHERE A.ATTR_COD=B.ATTRCOD AND A.VENDORCOD=B.VENDORCOD AND A.REQUEST_ID=:B2 AND B.ATTRNAME=:B1 AND :B3 =1 ORDER BY 3, 2
dxpmwddr1u2zk	SELECT TYPECONNECT, NAS_PORT FROM AUTH_SERVICE WHERE ASID = :B1
f5ayhb84bcwfs	SELECT VAL_BODY FROM IN_VALUES WHERE REQUEST_ID = :B3 AND ATTR_COD = :B2 AND VENDORCOD = :B1
f6f3g8grbd1bj	begin auth_account.authentificate( :BNAME, :BDOM, :BSID, :BRET, :BCODE, :BMSG, :BFPRINT); end;
fchc10m8dnvnt	UPDATE AUTH_IP SET IPLOCK = NULL, NAS_PORT = NULL, HID = NULL, MDATE = SYSDATE WHERE HID = :B2 AND NAS_PORT = :B1
fhxnx237xy239	DELETE FROM RADIUS_SESSION WHERE HID=:B2 AND NAS_PORT=:B1
fm9730y9ky36u	select a.attrtype, a.attrname, b.val_body from radius_attributes a, out_values b where a.attrcod=b.attr_cod and a.vendorcod=b.vendorcod and b.request_id=:BND_ID_ order by pos
frnj6gn4wx6cb	DELETE FROM RADIUS_LOG WHERE LOG_ID >= :B4 AND LOG_ID < :B3 AND ROWNUM<=:B2 AND (AUTH_DATE IS NULL OR AUTH_DATE < SYSDATE - :B1 )
gc3jj7ur0hg2s	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN clear_radius_log; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
gcaxrbj6dk2f2	SELECT MIN(VAL_BODY) FROM IN_VALUES WHERE REQUEST_ID=:B1 AND ATTR_COD=4 AND VENDORCOD=0
gcjmx3t8t76hx	declare ret number; spfid number; begin ret:=db_stat.find_sp(:FP); spfid:=db_stat.get_current_sp; :RES:=ret; :SPF:=spfid; end;
ghhjngw17k9zn	SELECT MM.DMID, DOMAINID, CLSRV FROM MAP_MAIN MM, AUTH_SPEC_PARAMS ASP WHERE VENDORCOD = :B3 AND CLOSED != 4 AND DOMAINID IN( SELECT DOMAINID FROM AUTH_DOMAINS START WITH DOMAINID = :B4 CONNECT BY PRIOR DOMAINID = DOMAINIDUP) AND MM.DMID = ASP.DMID AND ATTRCOD = 1 AND VALUE = :B2 AND ROWNUM <= 1 AND TYPECONNECT = :B1
gnqy76tthk38s	SELECT NVL(MIN(LOG_ID), 0) FROM RADIUS_LOG
gxu8m1nw5fvcz	SELECT DMID, CLSRV, ID FROM CLFPRINTS FPT WHERE FPRINT = :B2 AND STARTDATE <= :B1 AND (ENDDATE > :B1 OR ENDDATE IS NULL) AND EXISTS( SELECT * FROM AUTH_SPEC_PARAMS ASP WHERE CLSRV = FPT.CLSRV AND EXISTS (SELECT * FROM MAP_MAIN WHERE DMID = ASP.DMID AND DOMAINID IN( SELECT DOMAINID FROM AUTH_DOMAINS START WITH DOMAINID = :B3 CONNECT BY PRIOR DOMAINID = DOMAINIDUP)))

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
active txn count during cleanout	364,679,287	50,604.83	243.22
application wait time	413	0.06	0.00
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	95	0.01	0.00
background checkpoints started	95	0.01	0.00
background timeouts	21,277	2.95	0.01
branch node splits	1,088	0.15	0.00
buffer is not pinned count	502,037,343	69,665.36	334.82
buffer is pinned count	746,831,038	103,634.23	498.08
bytes received via SQL*Net from client	5,512,196,015	764,901.49	3,676.25
bytes sent via SQL*Net to client	3,267,880,853	453,468.44	2,179.45
Cached Commit SCN referenced	86,677	12.03	0.06
calls to get snapshot scn: kcmgss	182,504,979	25,325.36	121.72
calls to kcmgas	37,473,381	5,200.00	24.99
calls to kcmgcs	23,063,958	3,200.48	15.38
change write time	140,953	19.56	0.09
cleanout - number of ktugct calls	53,507,499	7,424.98	35.69
cleanouts and rollbacks - consistent read gets	27,223,459	3,777.67	18.16
cleanouts only - consistent read gets	434,689	60.32	0.29
cluster key scan block gets	56,947	7.90	0.04
cluster key scans	20,549	2.85	0.01
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	40,933	5.68	0.03
commit batch/immediate requested	40,933	5.68	0.03
commit cleanout failures: block lost	8,376	1.16	0.01
commit cleanout failures: buffer being written	59,603	8.27	0.04
commit cleanout failures: callback failure	1,178,262	163.50	0.79
commit cleanout failures: cannot pin	111,277	15.44	0.07
commit cleanouts	20,521,934	2,847.73	13.69
commit cleanouts successfully completed	19,164,416	2,659.36	12.78
commit immediate performed	40,933	5.68	0.03
commit immediate requested	40,933	5.68	0.03
Commit SCN cached	4	0.00	0.00
commit txn count during cleanout	5,651,746	784.27	3.77
concurrency wait time	8,747,817	1,213.89	5.83
consistent changes	3,001,616,890	416,520.24	2,001.87
consistent gets	5,061,189,916	702,317.49	3,375.46
consistent gets - examination	3,754,722,572	521,025.17	2,504.14
consistent gets direct	0	0.00	0.00
consistent gets from cache	5,061,189,918	702,317.49	3,375.46
CPU used by this session	5,304,852	736.13	3.54
CPU used when call started	5,151,332	714.83	3.44
CR blocks created	28,798,586	3,996.24	19.21
current blocks converted for CR	2,938	0.41	0.00
cursor authentications	7,080	0.98	0.00
data blocks consistent reads - undo records applied	2,995,468,136	415,667.01	1,997.77
db block changes	354,258,536	49,158.79	236.27
db block gets	449,652,661	62,396.18	299.89
db block gets direct	683	0.09	0.00
db block gets from cache	449,651,978	62,396.09	299.89
DB time	22,332,641	3,099.00	14.89
DBWR checkpoint buffers written	10,072,620	1,397.73	6.72
DBWR checkpoints	95	0.01	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	31,546	4.38	0.02
DBWR thread checkpoint buffers written	1,261,093	175.00	0.84
DBWR transaction table writes	13,610	1.89	0.01
DBWR undo block writes	2,616,910	363.14	1.75
deferred (CURRENT) block cleanout applications	2,777,962	385.48	1.85
dirty buffers inspected	30,000	4.16	0.02
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	70,843	9.83	0.05
enqueue deadlocks	0	0.00	0.00
enqueue releases	10,631,101	1,475.23	7.09
enqueue requests	10,631,800	1,475.32	7.09
enqueue timeouts	662	0.09	0.00
enqueue waits	1,945,107	269.91	1.30
exchange deadlocks	3,468,389	481.29	2.31
execute count	141,706,805	19,663.99	94.51
failed probes on index block reclamation	44,844	6.22	0.03
frame signature mismatch	4	0.00	0.00
free buffer inspected	21,173,055	2,938.09	14.12
free buffer requested	40,558,819	5,628.16	27.05
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	852,655	118.32	0.57
hot buffers moved to head of LRU	3,490,331	484.34	2.33
immediate (CR) block cleanout applications	27,676,272	3,840.51	18.46
immediate (CURRENT) block cleanout applications	2,627,865	364.66	1.75
IMU commits	0	0.00	0.00
IMU contention	0	0.00	0.00
IMU CR rollbacks	0	0.00	0.00
IMU- failed to get a private strand	1,499,164	208.03	1.00
IMU Flushes	0	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	1,499,164	208.03	1.00
IMU recursive-transaction flush	0	0.00	0.00
IMU Redo allocation size	0	0.00	0.00
IMU undo allocation size	0	0.00	0.00
index crx upgrade (found)	73,898	10.25	0.05
index crx upgrade (positioned)	27,856,832	3,865.56	18.58
index fast full scans (full)	11	0.00	0.00
index fetch by key	2,610,280	362.22	1.74
index scans kdiixs1	568,538,739	78,893.44	379.18
java call heap collected bytes	0	0.00	0.00
java call heap collected count	0	0.00	0.00
java call heap gc count	0	0.00	0.00
java call heap live object count	0	0.00	0.00
java call heap live object count max	0	0.00	0.00
java call heap live size	0	0.00	0.00
java call heap live size max	0	0.00	0.00
java call heap object count	0	0.00	0.00
java call heap object count max	0	0.00	0.00
java call heap total size	0	0.00	0.00
java call heap total size max	0	0.00	0.00
java call heap used size	0	0.00	0.00
java call heap used size max	0	0.00	0.00
leaf node splits	232,577	32.27	0.16
leaf node 90-10 splits	28,980	4.02	0.02
lob reads	406	0.06	0.00
lob writes	350	0.05	0.00
lob writes unaligned	350	0.05	0.00
local undo segment hints helped	0	0.00	0.00
local undo segment hints were stale	0	0.00	0.00
logons cumulative	4,445	0.62	0.00
messages received	614,761	85.31	0.41
messages sent	614,762	85.31	0.41
Misses for writing mapping	0	0.00	0.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	1,171,573,814	162,573.78	781.36
opened cursors cumulative	34,868,889	4,838.59	23.26
parse count (failures)	55	0.01	0.00
parse count (hard)	10,183	1.41	0.01
parse count (total)	41,000,666	5,689.47	27.34
parse time cpu	85,553	11.87	0.06
parse time elapsed	456,034	63.28	0.30
physical read bytes	33,707,663,360	4,677,453.73	22,480.63
physical read IO requests	2,828,567	392.51	1.89
physical read total bytes	33,786,766,848	4,688,430.55	22,533.39
physical read total IO requests	2,834,906	393.39	1.89
physical read total multi block requests	38,836	5.39	0.03
physical reads	4,114,705	570.98	2.74
physical reads cache	4,114,230	570.91	2.74
physical reads cache prefetch	1,286,548	178.53	0.86
physical reads direct	475	0.07	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write bytes	83,142,639,616	11,537,312.62	55,450.27
physical write IO requests	9,899,390	1,373.69	6.60
physical write total bytes	###############	18,593,882.41	89,365.34
physical write total IO requests	10,621,280	1,473.87	7.08
physical write total multi block requests	1,623,062	225.22	1.08
physical writes	10,149,248	1,408.36	6.77
physical writes direct	1,158	0.16	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	10,148,090	1,408.20	6.77
physical writes non checkpoint	4,074,046	565.34	2.72
pinned buffers inspected	119,738	16.62	0.08
prefetch clients - default	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	7,207	1.00	0.00
recursive aborts on index block reclamation	94	0.01	0.00
recursive calls	255,020,039	35,387.93	170.08
recursive cpu usage	4,812,418	667.80	3.21
redo blocks written	98,860,817	13,718.45	65.93
redo buffer allocation retries	1,992	0.28	0.00
redo entries	188,798,141	26,198.63	125.92
redo log space requests	5,753	0.80	0.00
redo log space wait time	8,248	1.14	0.01
redo ordering marks	1,821,450	252.75	1.21
redo size	48,681,176,204	6,755,257.60	32,466.91
redo subscn max counts	3,858,349	535.40	2.57
redo synch time	3,530,170	489.87	2.35
redo synch writes	2,064,800	286.52	1.38
redo wastage	281,215,664	39,022.97	187.55
redo write time	555,632	77.10	0.37
redo writer latching time	517	0.07	0.00
redo writes	576,446	79.99	0.38
rollback changes - undo records applied	241,301	33.48	0.16
rollbacks only - consistent read gets	3,493,288	484.75	2.33
rows fetched via callback	1,129,427	156.73	0.75
session connect time	7,566	1.05	0.01
session cursor cache hits	7,848,086	1,089.04	5.23
session logical reads	5,510,842,395	764,713.65	3,675.34
session pga memory	270,660,688	37,558.31	180.51
session pga memory max	657,781,840	91,277.29	438.69
session uga memory	###############	129,348,224.65	621,669.42
session uga memory max	7,076,838,336	982,019.53	4,719.75
shared hash latch upgrades - no wait	35,312,815	4,900.19	23.55
shared hash latch upgrades - wait	304,918	42.31	0.20
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	357	0.05	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	121,964,277	16,924.41	81.34
sorts (rows)	881,489,363	122,320.13	587.89
space was found by tune down	0	0.00	0.00
space was not found by tune down	0	0.00	0.00
sql area evicted	7,945	1.10	0.01
sql area purged	55	0.01	0.00
SQL*Net roundtrips to/from client	39,032,361	5,416.34	26.03
steps of tune down ret. in space pressure	0	0.00	0.00
summed dirty queue length	57,721	8.01	0.04
switch current to new buffer	4,068,453	564.56	2.71
table fetch by rowid	238,791,889	33,136.03	159.26
table fetch continued row	1,054	0.15	0.00
table scan blocks gotten	190,241,159	26,398.87	126.88
table scan rows gotten	2,563,997,512	355,793.86	1,710.01
table scans (cache partitions)	0	0.00	0.00
table scans (long tables)	21	0.00	0.00
table scans (short tables)	36,074,373	5,005.87	24.06
total number of times SMON posted	371	0.05	0.00
transaction rollbacks	40,933	5.68	0.03
transaction tables consistent read rollbacks	535	0.07	0.00
transaction tables consistent reads - undo records applied	152,112	21.11	0.10
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	18,885,804,500	2,620,694.17	12,595.50
user calls	34,096,101	4,731.36	22.74
user commits	1,499,403	208.07	1.00
user I/O wait time	1,596,488	221.54	1.06
user rollbacks	6	0.00	0.00
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	103,499,310	14,362.11	69.03
write clones created in background	133	0.02	0.00
write clones created in foreground	1,116,803	154.97	0.74

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	254,074,446	254,158,106
opened cursors current	1,761	1,807
workarea memory allocated	0	3,826
logons current	63	64

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)	95	47.46

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)
DB	2,806,206	389	5.62	1.46	7,426,175	1,030	12,257,952	1.55
UNDOTBS1	16,668	2	3.96	1.00	2,467,059	342	7,410,013	0.16
SYSTEM	2,573	0	6.30	1.80	1,008	0	206	0.19
SYSAUX	2,424	0	4.93	1.05	769	0	0	0.00
USERS	95	0	3.89	1.00	95	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)
DB	/oracle/oradata/db/db01.dbf	2,806,206	389	5.62	1.46	7,426,175	1,030	12,257,952	1.55
SYSAUX	/oracle/oradata/db/sysaux01.dbf	2,424	0	4.93	1.05	769	0	0	0.00
SYSTEM	/oracle/oradata/db/system01.dbf	2,573	0	6.30	1.80	1,008	0	206	0.19
UNDOTBS1	/oracle/oradata/db/undotbs01.dbf	16,668	2	3.96	1.00	2,467,059	342	7,410,013	0.16
USERS	/oracle/oradata/db/users01.dbf	95	0	3.89	1.00	95	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	951,521	100	5,468,230,083	4,114,084	10,144,005	0	0	19,668,991

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	60	75	53348	842958	3774870	3774870	6872390
E	60	66	45000	683647	3774870	3774870	6657851

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	768	0.10	94,992	1.63	14,635,267,628
D	1,536	0.20	189,984	1.56	13,993,455,581
D	2,304	0.30	284,976	1.49	13,357,611,891
D	3,072	0.40	379,968	1.42	12,726,976,197
D	3,840	0.50	474,960	1.35	12,100,394,351
D	4,608	0.60	569,952	1.28	11,477,064,201
D	5,376	0.70	664,944	1.21	10,856,424,555
D	6,144	0.80	759,936	1.14	10,238,049,224
D	6,912	0.89	854,928	1.07	9,621,624,067
D	7,680	0.99	949,920	1.00	9,006,893,585
D	7,728	1.00	955,857	1.00	8,968,563,297
D	8,448	1.09	1,044,912	0.94	8,393,608,007
D	9,216	1.19	1,139,904	0.87	7,781,737,833
D	9,984	1.29	1,234,896	0.80	7,171,072,271
D	10,752	1.39	1,329,888	0.73	6,561,427,858
D	11,520	1.49	1,424,880	0.66	5,952,637,387
D	12,288	1.59	1,519,872	0.60	5,344,535,699
D	13,056	1.69	1,614,864	0.53	4,736,956,797
D	13,824	1.79	1,709,856	0.46	4,129,745,087
D	14,592	1.89	1,804,848	0.39	3,522,751,295
D	15,360	1.99	1,899,840	0.33	2,915,839,513

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
100.00	208,264	0

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	200	92	183.24	0.00	0.00	0.00	0.00	40,960
E	200	90	200.34	7.16	3.57	100.00	0.00	40,960

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
2K	4K	103,328,849	103,328,849
64K	128K	1,540	1,540
128K	256K	116	116
256K	512K	4	4
512K	1024K	58	58
1M	2M	232	232
2M	4M	420	420
4M	8M	440	440
8M	16M	220	220
16M	32M	8	8

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
25	0.13	608,766,281.56	26,405,327.47	96.00	1,353,532
50	0.25	608,766,281.56	26,403,525.11	96.00	1,353,499
100	0.50	608,766,281.56	17,538,655.08	97.00	655,338
150	0.75	608,766,281.56	86,753.01	100.00	0
200	1.00	608,766,281.56	68,122.58	100.00	0
240	1.20	608,766,281.56	35,291.85	100.00	0
280	1.40	608,766,281.56	34,114.70	100.00	0
320	1.60	608,766,281.56	32,559.39	100.00	0
360	1.80	608,766,281.56	29,691.63	100.00	0
400	2.00	608,766,281.56	26,934.53	100.00	0
600	3.00	608,766,281.56	19,620.04	100.00	0
800	4.00	608,766,281.56	19,620.04	100.00	0
1,200	6.00	608,766,281.56	19,620.04	100.00	0
1,600	8.00	608,766,281.56	19,620.04	100.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
64	0.16	54	3,264	153,738,429	0.98	8,660,362	1.49	246,923,918
112	0.28	100	5,762	154,142,714	0.98	8,256,077	1.42	247,126,837
160	0.40	147	8,489	154,546,978	0.99	7,851,813	1.35	247,329,654
208	0.52	194	11,421	154,951,195	0.99	7,447,596	1.28	247,532,379
256	0.64	242	14,382	155,355,341	0.99	7,043,450	1.21	247,735,085
304	0.76	289	16,824	155,759,399	0.99	6,639,392	1.14	247,937,746
352	0.88	336	19,753	156,163,358	1.00	6,235,433	1.07	248,140,356
400	1.00	383	23,047	156,567,214	1.00	5,831,577	1.00	248,342,892
448	1.12	430	25,888	156,970,967	1.00	5,427,824	0.93	248,545,389
496	1.24	476	28,335	157,374,623	1.01	5,024,168	0.86	248,747,877
544	1.36	523	31,269	157,778,190	1.01	4,620,601	0.79	248,950,305
592	1.48	570	34,215	158,181,680	1.01	4,217,111	0.72	249,152,701
640	1.60	617	36,950	158,585,107	1.01	3,813,684	0.65	249,355,078
688	1.72	664	39,938	158,988,486	1.02	3,410,305	0.58	249,557,435
736	1.84	711	42,692	159,391,830	1.02	3,006,961	0.52	249,759,778
784	1.96	758	45,672	159,795,151	1.02	2,603,640	0.45	249,962,111
832	2.08	832	61,873	160,198,461	1.02	2,200,330	0.38	250,164,439

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,048	0.25	307,979,672	13,933,542,067
4,096	0.50	298,260,994	12,672,563,685
6,144	0.75	287,517,842	10,809,795,477
8,192	1.00	276,885,433	8,968,551,794
10,240	1.25	267,554,405	7,140,760,938
12,288	1.50	258,306,433	5,321,938,635
14,336	1.75	254,402,351	4,112,080,998
16,384	2.00	254,208,533	2,903,120,216

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

Java Pool Size(M)	JP 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
32	0.50	15	343	5	1.00	5,831,578	1.00	363
48	0.75	18	362	5	1.00	5,831,578	1.00	363
64	1.00	18	362	5	1.00	5,831,578	1.00	363
80	1.25	18	362	5	1.00	5,831,578	1.00	363
96	1.50	18	362	5	1.00	5,831,578	1.00	363
112	1.75	18	362	5	1.00	5,831,578	1.00	363
128	2.00	18	362	5	1.00	5,831,578	1.00	363

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	12,238,656	18,867	2
undo block	7,129,717	1,014	0
undo header	281,262	174	1
1st level bmb	1,533	81	53
2nd level bmb	18,527	4	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)	1,932,535	1,932,534	0	1,930,206	19,088	9.89
SQ-Sequence Cache	144,402	144,400	0	13,054	123	9.41
TX-Transaction (allocate ITL entry)	1,815	1,815	0	1,810	9	4.76
TX-Transaction (row lock contention)	597	15	582	10	4	414.00
HW-Segment High Water Mark	2,228	2,228	0	19	0	0.53

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	2,818.19	2,570,562	507	40	15/21.45	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
26-Feb 22:02	207,604	190,796	233	38	17	0/0	0/0/0/0/0/0
26-Feb 21:52	223,148	206,629	141	37	15	0/0	0/0/0/0/0/0
26-Feb 21:42	234,408	211,762	124	38	15	0/0	0/0/0/0/0/0
26-Feb 21:32	217,320	198,377	181	38	16	0/0	0/0/0/0/0/0
26-Feb 21:22	224,832	204,850	493	39	21	0/0	0/0/0/0/0/0
26-Feb 21:12	220,716	192,227	124	40	15	0/0	0/0/0/0/0/0
26-Feb 21:02	232,441	214,117	323	39	18	0/0	0/0/0/0/0/0
26-Feb 20:52	165,015	146,296	0	37	15	0/0	0/0/0/0/0/0
26-Feb 20:42	196,280	178,113	15	39	15	0/0	0/0/0/0/0/0
26-Feb 20:32	232,210	216,918	242	38	17	0/0	0/0/0/0/0/0
26-Feb 20:22	222,480	208,136	507	38	21	0/0	0/0/0/0/0/0
26-Feb 20:12	219,743	196,206	141	39	15	0/0	0/0/0/0/0/0
26-Feb 20:02	221,997	206,135	242	38	17	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
active checkpoint queue latch	4,177	0.00		0	0
active service list	30,810	0.00		0	3,884	0.00
ASM db client latch	6,021	0.00		0	0
AWR Alerted Metric Element list	27,046	0.00		0	0
begin backup scn array	30	0.00		0	0
buffer pool	6,599	0.00		0	0
cache buffer handles	1,941,294	0.05	0.03	0	0
cache buffers chains	14,196,574,201	10.09	0.06	42537	53,155,872	12.64
cache buffers lru chain	30,012,741	0.73	0.06	6	73,462,657	1.31
cache table scan latch	37,906	0.00		0	37,906	0.00
channel handle pool latch	8,415	0.00		0	0
channel operations parent latch	52,380	0.00		0	0
checkpoint queue latch	14,613,272	0.03	0.07	0	10,352,964	0.04
client/application info	21,198	0.00		0	0
compile environment latch	2,087,334	0.00		0	0
Consistent RBA	576,977	0.05	0.50	0	0
dml lock allocation	11,973,924	0.52	0.02	1	0
dummy allocation	8,889	0.00		0	0
enqueue hash chains	23,613,039	2.76	0.01	2	21,071	0.67
enqueues	6,355,205	3.28	0.01	1	0
event group latch	4,206	0.00		0	0
FIB s.o chain latch	930	0.00		0	0
file cache latch	2,251	0.00		0	0
FOB s.o list latch	16,912	0.00		0	0
global KZLD latch for mem in SGA	4,258	0.00		0	0
global tx hash mapping	122,730	0.00		0	0
hash table column usage latch	703	0.00		0	43,799	0.00
hash table modification latch	134	0.00		0	0
In memory undo latch	0			0	1,499,164	0.06
job workq parent latch	0			0	476	0.00
job_queue_processes parameter latch	318	0.00		0	0
JS mem alloc latch	10	0.00		0	0
JS queue access latch	10	0.00		0	0
JS queue state obj latch	43,320	0.00		0	0
JS slv state obj latch	391	0.00		0	0
kks stats	31,353	0.01	0.00	0	0
KMG MMAN ready and startup request latch	36,184	0.01	0.00	0	0
KMG resize request state object freelist	889	0.34	0.00	0	0
ksuosstats global area	484	0.00		0	0
KTF sga latch	21	0.00		0	2,377	0.00
ktm global data	1,089	0.00		0	0
kwqbsn:qsga	257	0.00		0	0
KWQMN job cache list latch	1	0.00		0	0
lgwr LWN SCN	579,195	0.31	0.01	0	0
library cache	200,863,351	0.32	0.02	14	20,633	7.75
library cache load lock	9,034	0.58	0.00	0	368	0.00
library cache lock	143,875,095	0.20	0.02	4	0
library cache lock allocation	428,663	0.00	0.14	0	0
library cache pin	83,592,502	0.14	0.02	2	0
library cache pin allocation	95,941	0.00		0	0
list of block allocation	675,243	0.02	0.10	0	0
loader state object freelist	1,148	0.00		0	0
longop free list parent	14	0.00		0	14	0.00
Memory Management Latch	38,822	0.06	0.13	0	35,862	0.00
message pool operations parent latch	4	0.00		0	0
messages	1,563,801	0.04	0.04	0	0
mostly latch-free SCN	658,990	11.26	0.02	1	0
MQL Tracking Latch	0			0	144	0.00
multiblock read objects	122,704	0.00		0	0
ncodef allocation latch	1,903	0.00		0	0
object queue header heap	2,279	0.00		0	1,782	0.00
object queue header operation	56,947,014	0.13	0.14	2	223,053	0.02
object stats modification	2	0.00		0	0
OS process	13,023	0.00		0	0
OS process allocation	11,084	0.00		0	0
OS process: request allocation	8,411	0.00		0	0
parallel query alloc buffer	960	0.00		0	0
parameter list	13,758	0.00		0	0
parameter table allocation management	9,365	0.01	0.00	0	0
PL/SQL warning settings	5,422,229	0.00		0	0
post/wait queue	3,778,750	1.01	0.00	0	2,459,973	0.05
process allocation	8,411	0.00		0	4,206	0.00
process group creation	8,411	0.00		0	0
qmn task queue latch	1,028	0.00		0	0
redo allocation	2,592,781	8.61	0.11	13	188,511,486	2.36
redo copy	0			0	188,798,347	0.07
redo writing	2,312,623	0.04	0.00	0	0
resmgr group change latch	4,248	0.00		0	0
resmgr:actses active list	8,879	0.00		0	0
resmgr:actses change group	4,236	0.00		0	0
resmgr:free threads list	8,877	0.00		0	0
resmgr:schema config	2	0.00		0	0
row cache objects	2,550,055	0.01	0.02	0	3,725	0.00
sequence cache	8,160,876	0.18	0.01	0	0
session allocation	8,475,588	1.15	0.01	0	0
session idle bit	70,267,747	0.02	0.02	0	0
session state list latch	8,783	0.00		0	0
session switching	1,902	0.00		0	0
session timer	3,885	0.00		0	0
SGA IO buffer pool latch	154,820	0.00	0.00	0	372,741	0.00
Shared B-Tree	257	0.00		0	0
shared pool	2,529,370	0.20	0.41	1	0
shared pool simulator	922,045	0.00	0.40	0	0
simulator hash latch	302,885,922	0.01	0.01	0	0
simulator lru latch	302,016,659	3.03	0.01	79	411,532	0.23
slave class	6	0.00		0	0
slave class create	24	8.33	1.00	0	0
sort extent pool	2,326	0.00		0	0
SQL memory manager latch	2	0.00		0	2,397	0.00
SQL memory manager workarea list latch	165,112	0.00		0	0
state object free list	24	0.00		0	0
statistics aggregation	224	0.00		0	0
temp lob duration state obj allocation	4	0.00		0	0
threshold alerts latch	321	0.00		0	0
transaction allocation	456,780	0.00	0.00	0	0
transaction branch allocation	116,914	0.00	0.00	0	0
undo global data	3,527,537,876	0.44	0.01	144	9,332	0.00
user lock	16,505	0.02	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
cache buffers chains	14,196,574,201	1,433,131,741	80,320,344	1,364,192,356
undo global data	3,527,537,876	15,414,622	191,893	15,251,974
simulator lru latch	302,016,659	9,162,873	112,705	9,066,055
enqueue hash chains	23,613,039	650,616	4,185	646,650
library cache	200,863,351	645,617	13,940	633,725
library cache lock	143,875,095	287,325	5,082	283,123
redo allocation	2,592,781	223,188	25,154	201,966
cache buffers lru chain	30,012,741	218,139	13,869	206,131
enqueues	6,355,205	208,448	1,510	206,956
library cache pin	83,592,502	118,513	2,795	116,089
session allocation	8,475,588	97,857	681	97,217
object queue header operation	56,947,014	76,310	10,417	66,539
mostly latch-free SCN	658,990	74,175	1,450	72,919
dml lock allocation	11,973,924	61,714	1,251	60,668
post/wait queue	3,778,750	38,113	49	38,064
simulator hash latch	302,885,922	35,018	352	34,727
session idle bit	70,267,747	14,544	249	14,310
sequence cache	8,160,876	14,484	74	14,415
shared pool	2,529,370	5,119	2,109	3,247
checkpoint queue latch	14,613,272	4,574	305	4,334
lgwr LWN SCN	579,195	1,782	16	1,768
cache buffer handles	1,941,294	948	27	927
redo writing	2,312,623	867	4	863
messages	1,563,801	548	23	528
row cache objects	2,550,055	380	6	374
Consistent RBA	576,977	264	132	152
list of block allocation	675,243	103	10	94
Memory Management Latch	38,822	23	3	21
library cache lock allocation	428,663	7	1	6
shared pool simulator	922,045	5	2	3
slave class create	24	2	2	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 buffer handles	kcbzgs	20	19
cache buffer handles	kcbzfs	7	8
cache buffers chains	kcbchg: kslbegin: bufs not pinned	77,047,555	89,399,850
cache buffers chains	kcbchg: kslbegin: call CR func	50,337,794	75,022,405
cache buffers chains	kcbgtcr: kslbegin excl	22,446,478	2,014,572
cache buffers chains	kcbget: pin buffer	8,570,268	3,536,164
cache buffers chains	kcbzwb	5,690,209	1,237,693
cache buffers chains	kcbzgb: scan from tail. nowait	2,675,382	0
cache buffers chains	kcbgcur: kslbegin	2,223,630	704,995
cache buffers chains	kcbrls: kslbegin	1,252,189	1,763,575
cache buffers chains	kcbgtcr: fast path	1,093,812	329,421
cache buffers chains	kcbcge	302,269	413,339
cache buffers chains	kcbget: exchange rls	187,986	294,785
cache buffers chains	kcbnlc	186,155	98,053
cache buffers chains	kcbget: exchange	177,333	326,622
cache buffers chains	kcbso1: set no access	49,588	27,155
cache buffers chains	kcb_is_private	9,226	19,131
cache buffers chains	kcbesc: escalate	4,949	5,454
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	1,022	0
cache buffers chains	kcbnew: new latch again	515	16
cache buffers chains	kcbbxsv	379	171
cache buffers chains	kcbwxb	165	138
cache buffers chains	kcbzib: multi-block read: nowait	109	0
cache buffers chains	kcbbic1	103	84
cache buffers chains	kcbbic2	54	103
cache buffers chains	kcbzib: finish free bufs	44	51
cache buffers chains	kcbgtcr: kslbegin shared	29	13
cache buffers chains	kcbw_examine_granule	25	0
cache buffers chains	kcbw_next_free	23	0
cache buffers chains	kcbzcg	5	87
cache buffers chains	kcbgtcr	2	1
cache buffers chains	kcbkzs	2	9
cache buffers chains	kcbzib: exchange rls	2	3
cache buffers chains	kcbchg: no fast path	1	51
cache buffers lru chain	kcbzgws	9,810	0
cache buffers lru chain	kcbzgb: posted for free bufs	2,190	8,466
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	1,289	0
cache buffers lru chain	kcbzswcu	253	2,152
cache buffers lru chain	kcbbxsv: move to being written	220	2,561
cache buffers lru chain	kcbbic2	38	655
cache buffers lru chain	kcbw_activate_granule	29	23
cache buffers lru chain	kcbzar: KSLNBEGIN	28	0
cache buffers lru chain	kcbw_quiesce_granule	4	7
cache buffers lru chain	kcbkflb : age buffer out	3	0
cache buffers lru chain	kcbo_link_q	3	1
cache buffers lru chain	kcbzgm	3	0
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	146	10
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	111	0
checkpoint queue latch	kcbswcu: Switch buffers	29	257
checkpoint queue latch	kcbkubc	18	35
dml lock allocation	ktaiam	962	930
dml lock allocation	ktaidm	288	320
enqueue hash chains	ksqrcl	2,464	798
enqueue hash chains	ksqgtl3	1,127	1,104
enqueue hash chains	ksqcmi: get hash chain latch after wait	592	2,282
enqueue hash chains	ksqcmi: kslgpl	2	0
enqueues	ksqdel	1,129	1,141
enqueues	ksqgel: create enqueue	271	221
enqueues	ksqies	110	148
lgwr LWN SCN	kcs023	412	0
library cache	kglLockCursor	3,768	3,906
library cache	kglpndl: child: after processing	3,054	164
library cache	kglpnp: child	2,704	4,147
library cache	kglobpn: child:	899	891
library cache	kglpndl: child: before processing	699	2,810
library cache	kgldte: child 0	387	423
library cache	kglhdgn: child:	292	58
library cache	kglpin	179	23
library cache	kglic	66	0
library cache	kgldti: 2child	19	7
library cache	kglati	6	1
library cache	kglhdgc: child:	5	2
library cache	kglrtl	5	0
library cache	kglobld	4	30
library cache	kgldtld: 2child	3	0
library cache	kglScanDependency	3	0
library cache	kglhdbrnl: child	1	0
library cache lock	kgllkdl: child: cleanup	2,688	2,688
library cache lock	kgllkal: child: multiinstance	2,394	2,394
library cache lock	kgllkdl: child: no lock handle	389	96
library cache lock allocation	kgllkrel	1	0
library cache pin	kglpndl	1,564	1,175
library cache pin	kglpnp: child	1,009	1,352
library cache pin	kglpnal: child: alloc space	222	268
list of block allocation	ktlabl	10	8
Memory Management Latch	kmgs_create_request2	13	9
messages	ksaamb: after wakeup	17	16
messages	ksarcv	5	4
messages	ksarcr	1	1
mostly latch-free SCN	kcslcu3	1,039	1,466
mostly latch-free SCN	kcs01	75	132
mostly latch-free SCN	kcsnew_scn_rba	57	0
mostly latch-free SCN	kcs024	15	0
object queue header operation	kcbo_switch_cq	14,222	12,454
object queue header operation	kcbw_unlink_q	13,847	3,419
object queue header operation	kcbw_link_q	3,949	3,728
object queue header operation	kcbo_swap_buf	1,950	3,525
object queue header operation	kcbo_switch_mq_bg	162	8,335
object queue header operation	kcbo_switch_q_bg	75	2,459
object queue header operation	kcbw_unlink_q_bg	10	294
post/wait queue	ksliwat:remove	46	48
post/wait queue	ksliwat:add:nowait	1	0
post/wait queue	kslpstevent:get	1	1
post/wait queue	kslpstevent:reget	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	19,292	0
redo allocation	kcrfw_redo_gen: redo allocation 3	3,920	21,696
redo allocation	kcrfw_redo_gen: redo allocation 2	1,284	0
redo allocation	kcrfw_redo_write: more space	391	2,091
redo allocation	kcrfw_redo_write: before write	266	1,366
redo writing	kcrfw_post: rba scn pair	2	0
redo writing	kcrfw_cal_target_rba	1	0
redo writing	kcrfws: outside the loop	1	1
row cache objects	kqreqd: reget	2	0
row cache objects	kqrpre: find obj	2	2
row cache objects	kqrcmt: while loop	1	0
row cache objects	kqrpup	1	1
sequence cache	kdnssd	47	3
sequence cache	kdnnxt: cached seq	22	2
sequence cache	kdnss	5	69
session allocation	ksuxds: not user session	245	365
session allocation	ksucri	114	245
session allocation	ksuprc	114	18
session allocation	ksuxds: KSUSFCLC not set	105	0
session allocation	ksudlc	90	52
session allocation	ksudlp	6	0
session allocation	kspallmod	4	0
session allocation	ksucrp	2	1
session allocation	ksursi	1	0
session idle bit	ksupuc: set busy	237	80
session idle bit	ksupuc: clear busy	109	268
session idle bit	ksuxds	39	37
shared pool	kghfrunp: clatch: wait	1,204	1,370
shared pool	kghfrunp: alloc: wait	945	884
shared pool	kghalo	449	627
shared pool	kghfrunp: clatch: nowait	250	0
shared pool	kgh_next_free	165	196
shared pool	kghfre	164	67
shared pool	kghfrunp: alloc: session dur	106	55
shared pool	kghupr1	104	211
shared pool	kgh: sim resz update	82	18
shared pool	kghfrunp	40	9
shared pool	kgh: quiesce extents	28	1
shared pool	kghalp	15	29
shared pool	kghasp	4	3
shared pool	kghfrh	4	4
shared pool	kgh: add new extent	3	4
shared pool	kghquiesce: clatch: nowait	3	0
shared pool simulator	kglsim_unpin_simhp	1	1
shared pool simulator	kglsim_upd_newhp	1	1
simulator hash latch	kcbsacc: lookup dba	305	312
simulator hash latch	kcbs_lookup_setid: lookup dba	27	5
simulator hash latch	kcbs_get_or_extract_simbufseq	14	31
simulator hash latch	kcbsacc: insert dba	4	0
simulator hash latch	kcbsacc: remove dba	2	4
simulator lru latch	kcbs_simulate: simulate set	110,991	112,280
simulator lru latch	kcbs_simbufseq	632	391
simulator lru latch	kcbs_shrink_pool	521	0
simulator lru latch	kcbs_free_granule_sim_buffers	211	1
simulator lru latch	kcbs_resize_pool : interpolation	159	2
simulator lru latch	kcbs_grow_pool	89	0
simulator lru latch	kcbs_lookup_setid	84	0
slave class create	ksvcreate	2	0
undo global data	kturimugur: child	139,370	69,986
undo global data	ktudba: KSLBEGIN	51,857	121,126
undo global data	ktudnx:child	448	519
undo global data	ktubnd:child	101	106
undo global data	ktufrbs: child	51	142
undo global data	ktusmasp: ktugd_tuux	46	3
undo global data	ktusm_end_fu	6	0
undo global data	ktugnb: KSLBEGIN	5	3
undo global data	kturar: KSLBEGIN	1	1

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Reads

No data exists for this section of the report.

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	134	2.24	4	1
dc_global_oids	80	37.50	0	2
dc_histogram_data	10,190	39.75	0	613
dc_histogram_defs	104,377	7.77	0	1,189
dc_object_grants	216	0.00	0	6
dc_object_ids	53,528	5.33	0	394
dc_objects	21,481	0.46	1	493
dc_profiles	4,237	0.40	0	1
dc_rollback_segments	3,764	0.00	0	40
dc_segments	30,151	2.19	13	474
dc_sequences	131,256	0.00	131,256	6
dc_tablespaces	253,437	0.04	0	6
dc_usernames	9,657	0.47	0	6
dc_users	76,656	0.01	0	9
outstanding_alerts	88	62.50	0	6

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	47	80.85	8,010,736	0.00	42	0
CLUSTER	1,260	0.16	2,054	0.78	14	0
INDEX	54	20.37	175	6.29	0	0
SQL AREA	5,028	30.41	156,244,002	0.46	9,212	3,061
TABLE/PROCEDURE	7,734	4.06	30,747,241	0.00	1,906	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	154.97		2.46	3.38	22	24	63	63
	Freeable	18.94	0.00	0.73	0.32	1		26	26
	SQL	4.85	2.18	0.09	0.06	0	5	54	49
	PL/SQL	4.49	2.37	0.07	0.05	0	0	63	63
E	Other	168.20		2.63	3.62	22	25	64	64
	Freeable	17.88	0.00	0.78	0.98	5		23	23
	SQL	10.08	7.12	0.18	0.55	4	7	55	51
	PL/SQL	4.45	3.08	0.07	0.05	0	0	64	64

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	8,086,618,112	8,069,840,896
Fixed Size	2,086,448
Redo Buffers	14,688,256
Variable Size	486,541,776	503,318,992

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	46.90	46.90	0.00
java	joxlod exec hp	16.54	16.54	0.00
large	free memory	14.97	14.97	0.00
large	PX msg pool	1.03	1.03	0.00
shared	ASH buffers	29.00	29.00	0.00
shared	CCursor	17.97	17.58	-2.18
shared	db_block_hash_buckets	45.00	45.00	0.00
shared	free memory	156.68	173.21	10.55
shared	KGH: NO ACCESS	366.10	285.33	-22.06
shared	kglsim object batch	7.93	7.93	0.00
shared	library cache	16.04	16.09	0.29
shared	PCursor	8.56	8.20	-4.22
shared	row cache		7.16
shared	sql area	23.05	21.82	-5.32
	buffer_cache	7,712.00	7,696.00	-0.21
	fixed_sga	1.99	1.99	0.00
	log_buffer	14.01	14.01	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	79	148	170	170

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/oracle/admin/db/adump
background_dump_dest	/oracle/admin/db/bdump
compatible	10.2.0.1.0
control_files	/oracle/oradata/db/control01.ctl, /oracle/oradata/db/control02.ctl, /oracle/oradata/db/control03.ctl
core_dump_dest	/oracle/admin/db/cdump
db_block_size	8192
db_domain
db_name	db
db_writer_processes	4
fast_start_mttr_target	60
filesystemio_options	ASYNCH
job_queue_processes	2
log_checkpoints_to_alert	FALSE
open_cursors	300
pga_aggregate_target	209715200
processes	150
remote_login_passwordfile	EXCLUSIVE
sga_target	8589934592
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/admin/db/udump

End of Report

% Blocks changed per Read:	6.43	Recursive Call %:	88.21
Rollback per transaction %:	0.00	Rows per Sort:	7.23

Buffer Nowait %:	99.64	Redo NoWait %:	100.00
Buffer Hit %:	99.93	In-memory Sort %:	100.00
Library Hit %:	99.64	Soft Parse %:	99.98
Execute to Parse %:	71.07	Latch Hit %:	92.32
Parse CPU to Parse Elapsd %:	18.76	% Non-Parse CPU:	98.53