WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

TESTIBM 1448208628 TESTIBM 1 10.2.0.2.0 NO brepredbwh04

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
TESTIBM	1448208628	TESTIBM	1	10.2.0.2.0	NO	brepredbwh04

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 437 11-Apr-06 11:50:02 29 11.8

End Snap: 438 11-Apr-06 12:00:04 29 11.9

Elapsed: 10.03 (mins)

DB Time: 87.13 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	437	11-Apr-06 11:50:02	29	11.8
End Snap:	438	11-Apr-06 12:00:04	29	11.9
Elapsed:		10.03 (mins)
DB Time:		87.13 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 712M 712M Std Block Size: 16K

Shared Pool Size: 72M 72M Log Buffer: 6,956K

	Begin	End
Buffer Cache:	712M	712M	Std Block Size:	16K
Shared Pool Size:	72M	72M	Log Buffer:	6,956K

Load Profile

Per Second Per Transaction

Redo size: 507,681.27 4,120.76

Logical reads: 16,394.35 133.07

Block changes: 3,993.80 32.42

Physical reads: 253.20 2.06

Physical writes: 178.53 1.45

User calls: 571.48 4.64

Parses: 431.70 3.50

Hard parses: 1.10 0.01

Sorts: 18.72 0.15

Logons: 0.30 0.00

Executes: 2,009.00 16.31

Transactions: 123.20

	Per Second	Per Transaction
Redo size:	507,681.27	4,120.76
Logical reads:	16,394.35	133.07
Block changes:	3,993.80	32.42
Physical reads:	253.20	2.06
Physical writes:	178.53	1.45
User calls:	571.48	4.64
Parses:	431.70	3.50
Hard parses:	1.10	0.01
Sorts:	18.72	0.15
Logons:	0.30	0.00
Executes:	2,009.00	16.31
Transactions:	123.20

% Blocks changed per Read: 24.36 Recursive Call %: 85.39

Rollback per transaction %: 0.00 Rows per Sort: 10.86

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.91 Redo NoWait %: 99.99

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

Library Hit %: 99.81 Soft Parse %: 99.75

Execute to Parse %: 78.51 Latch Hit %: 99.77

Parse CPU to Parse Elapsd %: 59.01 % Non-Parse CPU: 97.43

Shared Pool Statistics

Begin End

Memory Usage %: 82.92 82.86

% SQL with executions>1: 79.75 67.47

% Memory for SQL w/exec>1: 80.09 75.92

	Begin	End
Memory Usage %:	82.92	82.86
% SQL with executions>1:	79.75	67.47
% Memory for SQL w/exec>1:	80.09	75.92

Top 5 Timed Events

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

db file sequential read 152,180 3,720 24 71.2 User I/O

CPU time 928 17.7

log file sync 86,795 353 4 6.8 Commit

enq: TX - row lock contention 8,547 204 24 3.9 Application

log file parallel write 114,047 139 1 2.7 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	152,180	3,720	24	71.2	User I/O
CPU time		928		17.7
log file sync	86,795	353	4	6.8	Commit
enq: TX - row lock contention	8,547	204	24	3.9	Application
log file parallel write	114,047	139	1	2.7	System I/O

Main Report

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

Time Model Statistics

Total time in database user-calls (DB Time): 5227.8s
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	4,713.02	90.15
DB CPU	927.60	17.74
PL/SQL execution elapsed time	121.19	2.32
parse time elapsed	45.55	0.87
hard parse elapsed time	17.12	0.33
connection management call elapsed time	4.96	0.09
PL/SQL compilation elapsed time	2.21	0.04
repeated bind elapsed time	1.12	0.02
sequence load elapsed time	0.98	0.02
hard parse (sharing criteria) elapsed time	0.24	0.00
DB time	5,227.82
background elapsed time	339.50
background cpu time	82.95

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
User I/O	153,279	0.00	3,743	24	2.07
Commit	86,795	0.00	353	4	1.17
Application	156,713	0.00	327	2	2.11
System I/O	123,485	0.00	226	2	1.67
Concurrency	9,892	1.24	29	3	0.13
Configuration	224	4.02	17	77	0.00
Other	7,004	0.14	9	1	0.09
Network	173,861	0.00	2	0	2.35

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
db file sequential read	152,180	0.00	3,720	24	2.05
log file sync	86,795	0.00	353	4	1.17
enq: TX - row lock contention	8,547	0.00	204	24	0.12
log file parallel write	114,047	0.00	139	1	1.54
SQL*Net break/reset to client	148,166	0.00	123	1	2.00
db file parallel write	8,209	0.00	69	8	0.11
buffer busy waits	8,090	0.01	23	3	0.11
read by other session	1,056	0.00	21	20	0.01
log file switch completion	56	16.07	14	249	0.00
control file sequential read	899	0.00	9	10	0.01
control file parallel write	318	0.00	9	27	0.00
rdbms ipc reply	1,537	0.00	4	2	0.02
enq: HW - contention	165	0.00	3	20	0.00
SQL*Net message to client	173,375	0.00	2	0	2.34
latch: In memory undo latch	868	0.00	2	2	0.01
LGWR wait for redo copy	3,612	0.06	2	0	0.05
cursor: pin S wait on X	123	99.19	1	12	0.00
latch: enqueue hash chains	508	0.00	1	2	0.01
db file scattered read	16	0.00	1	65	0.00
latch free	343	0.00	1	3	0.00
latch: cache buffers chains	429	0.00	1	2	0.01
latch: library cache	187	0.00	0	2	0.00
kksfbc child completion	8	100.00	0	49	0.00
library cache load lock	18	0.00	0	22	0.00
enq: US - contention	174	0.00	0	2	0.00
latch: redo allocation	241	0.00	0	1	0.00
latch: row cache objects	101	0.00	0	3	0.00
row cache lock	2	0.00	0	135	0.00
os thread startup	2	0.00	0	98	0.00
cursor: pin S	432	0.00	0	0	0.01
direct path write	15	0.00	0	10	0.00
latch: session allocation	52	0.00	0	3	0.00
latch: library cache pin	55	0.00	0	2	0.00
latch: undo global data	37	0.00	0	3	0.00
direct path read	12	0.00	0	6	0.00
latch: messages	28	0.00	0	2	0.00
latch: object queue header operation	19	0.00	0	2	0.00
SQL*Net more data to client	469	0.00	0	0	0.01
latch: library cache lock	10	0.00	0	2	0.00
log file sequential read	6	0.00	0	2	0.00
latch: shared pool	6	0.00	0	2	0.00
enq: FB - contention	3	0.00	0	3	0.00
latch: redo writing	3	0.00	0	2	0.00
latch: cache buffers lru chain	8	0.00	0	1	0.00
enq: TX - contention	2	0.00	0	2	0.00
log file single write	6	0.00	0	0	0.00
SQL*Net more data from client	17	0.00	0	0	0.00
cursor: mutex X	1	0.00	0	0	0.00
SQL*Net message from client	173,374	0.00	1,591	9	2.34
Streams AQ: qmn slave idle wait	22	0.00	602	27349	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	602	13674	0.00
Streams AQ: waiting for messages in the queue	120	100.00	586	4884	0.00
class slave wait	1	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
log file parallel write	114,049	0.00	139	1	1.54
db file parallel write	8,209	0.00	69	8	0.11
control file parallel write	318	0.00	9	27	0.00
control file sequential read	177	0.00	8	46	0.00
db file sequential read	138	0.00	3	25	0.00
events in waitclass Other	3,860	0.05	2	0	0.05
os thread startup	2	0.00	0	98	0.00
db file scattered read	4	0.00	0	43	0.00
direct path write	10	0.00	0	15	0.00
direct path read	12	0.00	0	6	0.00
log file sequential read	6	0.00	0	2	0.00
latch: redo writing	3	0.00	0	2	0.00
latch: cache buffers chains	4	0.00	0	1	0.00
latch: shared pool	1	0.00	0	3	0.00
log file single write	6	0.00	0	0	0.00
rdbms ipc message	107,985	1.60	6,165	57	1.46
Streams AQ: qmn slave idle wait	22	0.00	602	27349	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	602	13674	0.00
pmon timer	262	100.00	589	2249	0.00
smon timer	2	50.00	355	177258	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	104,622
IDLE_TIME	137,094
IOWAIT_TIME	106,851
NICE_TIME	0
SYS_TIME	23,759
USER_TIME	76,573
LOAD	10
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	240,400
NUM_CPUS	4
NUM_CPU_SOCKETS	2

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
TESTIBM	5,193.60	918.10	150,401	9,791,078
SYS$USERS	27.30	7.70	607	46,745
SYS$BACKGROUND	0.00	0.00	1,242	33,838

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
TESTIBM	151456	370366	9873	2909	172020	204
SYS$USERS	594	1699	2	0	1319	5
SYS$BACKGROUND	1229	2207	21	31	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
3,547	285	74,429	0.05	67.84	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
2,262	103	55,069	0.04	43.26	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
853	337	74,393	0.01	16.32	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
258	47	44,778	0.01	4.93	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
197	46	7,491	0.03	3.76	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
189	39	7,491	0.03	3.61	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
175	33	74,417	0.00	3.34	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
120	40	74,419	0.00	2.30	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
114	46	74,401	0.00	2.19	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
91	48	7,516	0.01	1.74	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
87	19	74,398	0.00	1.67	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
70	11	29,621	0.00	1.35	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
58	20	74,401	0.00	1.12	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...

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
337	853	74,393	0.00	16.32	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
285	3,547	74,429	0.00	67.84	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
103	2,262	55,069	0.00	43.26	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
48	91	7,516	0.01	1.74	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
47	258	44,778	0.00	4.93	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
46	197	7,491	0.01	3.76	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
46	114	74,401	0.00	2.19	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
40	120	74,419	0.00	2.30	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
39	189	7,491	0.01	3.61	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
37	42	74,439	0.00	0.80	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
33	175	74,417	0.00	3.34	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
20	58	74,401	0.00	1.12	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
19	87	74,398	0.00	1.67	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
11	70	29,621	0.00	1.35	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

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: 9,865,823
Captured SQL account for 88.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
4,566,447	7,491	609.59	46.29	46.36	196.67	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
4,551,214	7,491	607.56	46.13	39.20	188.74	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
2,294,224	74,393	30.84	23.25	337.35	853.05	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
1,782,129	74,429	23.94	18.06	284.82	3546.54	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
743,217	44,778	16.60	7.53	46.99	257.96	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
386,811	55,069	7.02	3.92	103.17	2261.78	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
378,305	74,417	5.08	3.83	33.36	174.86	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
372,717	74,439	5.01	3.78	36.72	41.84	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
363,964	74,401	4.89	3.69	45.99	114.40	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
359,079	74,419	4.83	3.64	39.57	120.06	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
201,934	7,516	26.87	2.05	47.70	91.22	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
152,787	74,398	2.05	1.55	18.83	87.07	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
152,050	74,394	2.04	1.54	11.91	13.04	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
149,664	49,242	3.04	1.52	12.74	25.27	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
148,882	74,441	2.00	1.51	14.85	15.08	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
148,800	74,390	2.00	1.51	9.34	9.36	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
111,835	37,278	3.00	1.13	9.22	10.49	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
111,379	37,123	3.00	1.13	9.59	9.62	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
111,372	37,122	3.00	1.13	5.10	5.12	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
107,117	7,515	14.25	1.09	32.56	46.69	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
99,488	74,401	1.34	1.01	19.52	58.46	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 152,374
Captured SQL account for 80.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
119,139	74,429	1.60	78.19	284.82	3546.54	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
83,820	55,069	1.52	55.01	103.17	2261.78	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
17,405	7,491	2.32	11.42	39.20	188.74	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
17,405	7,491	2.32	11.42	46.36	196.67	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
12,688	74,393	0.17	8.33	337.35	853.05	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
9,077	44,778	0.20	5.96	46.99	257.96	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
5,620	74,417	0.08	3.69	33.36	174.86	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
2,454	29,621	0.08	1.61	10.97	70.45	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
1,792	7,516	0.24	1.18	47.70	91.22	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
846	4,463	0.19	0.56	4.33	23.74	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,208,979
Captured SQL account for 97.5% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
74,441	74,441	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
74,439	74,442	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
74,429	0	0.00	0.05	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
74,419	74,437	1.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
74,417	74,439	1.00	0.00	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
74,401	74,401	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
74,401	74,402	1.00	0.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
74,398	74,407	1.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
74,394	74,400	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
74,393	74,401	1.00	0.01	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
74,390	74,404	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
55,069	55,063	1.00	0.04	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
49,242	49,244	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
44,778	324,461	7.25	0.01	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
37,278	37,278	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
37,123	37,125	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
37,122	37,124	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
29,621	29,621	1.00	0.00	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 259,791
Captured SQL account for 91.8% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
74,438	74,429	28.65	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
74,395	74,393	28.64	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
55,037	55,069	21.19	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
7,516	7,516	2.89	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
7,491	7,491	2.88	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
7,370	7,370	2.84	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
3,524	3,523	1.36	bsa0wjtftg3uw		select file# from file$ where ...
1,997	1,997	0.77	86708bvah4akq		select name from undo$ where f...
628	628	0.24	2ym6hhaq30r73		select type#, blocks, extents,...
348	348	0.13	0h6b2sajwb74n		select privilege#, level from ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

13dn4hkrzfpdy SELECT COUNT(DISTINCT (S_I_ID)) FROM ORDER_LINE, STOCK WHERE OL_W_ID = :B2 AND OL_D_ID = :B4 AND (OL_O_ID < :B3 ) AND OL_O_ID >= (:B3 - 20) AND S_W_ID = :B2 AND S_I_ID = OL_I_ID AND S_QUANTITY < :B1

16dhat4ta7xs9 begin neword(:no_w_id, :no_max_w_id, :no_d_id, :no_c_id, :no_o_ol_cnt, :no_c_discount, :no_c_last, :no_c_credit, :no_d_tax, :no_w_tax, :no_d_next_o_id, TO_DATE(:timestamp, 'YYYYMMDDHH24MISS')); END;

1bn3cfn6n3xv5 SELECT C_DATA FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1

2k7k32av19mqz SELECT C_FIRST, C_MIDDLE, C_LAST, C_STREET_1, C_STREET_2, C_CITY, C_STATE, C_ZIP, C_PHONE, C_CREDIT, C_CREDIT_LIM, C_DISCOUNT, C_BALANCE, C_SINCE FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1

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

4r83hzuhh3yuv SELECT W_STREET_1, W_STREET_2, W_CITY, W_STATE, W_ZIP, W_NAME FROM WAREHOUSE WHERE W_ID = :B1

4wg725nwpxb1z SELECT C_FIRST, C_MIDDLE, C_ID, C_STREET_1, C_STREET_2, C_CITY, C_STATE, C_ZIP, C_PHONE, C_CREDIT, C_CREDIT_LIM, C_DISCOUNT, C_BALANCE, C_SINCE FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_LAST = :B1 ORDER BY C_FIRST

5hyh0360hgx2u BEGIN slev(:st_w_id, :st_d_id, :threshold); END;

5mz8u3b34u9gw SELECT C_DISCOUNT, C_LAST, C_CREDIT, W_TAX FROM CUSTOMER, WAREHOUSE WHERE WAREHOUSE.W_ID = :B3 AND CUSTOMER.C_W_ID = :B3 AND CUSTOMER.C_D_ID = :B2 AND CUSTOMER.C_ID = :B1

5xm451a80drbc INSERT INTO HISTORY (H_C_D_ID, H_C_W_ID, H_C_ID, H_D_ID, H_W_ID, H_DATE, H_AMOUNT, H_DATA) VALUES (:B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

69gxtaqr1vk8j UPDATE DISTRICT SET D_YTD = D_YTD + :B3 WHERE D_W_ID = :B2 AND D_ID = :B1

7m5h0wf6stq0q SELECT COUNT(C_ID) FROM CUSTOMER WHERE C_LAST = :B3 AND C_D_ID = :B2 AND C_W_ID = :B1

80ajya2tnyfg2 INSERT INTO NEW_ORDER (NO_O_ID, NO_D_ID, NO_W_ID) VALUES (:B3 , :B2 , :B1 )

86708bvah4akq select name from undo$ where file#=:1 and block#=:2 and ts#=:3 and status$ != 1

88fgqncchy6wg SELECT I_PRICE, I_NAME, I_DATA FROM ITEM WHERE I_ID = :B1

89k9fqaq5b5sy SELECT C_BALANCE, C_FIRST, C_MIDDLE, C_ID FROM CUSTOMER WHERE C_LAST = :B3 AND C_D_ID = :B2 AND C_W_ID = :B1 ORDER BY C_FIRST

95yr4xtfr50hx UPDATE CUSTOMER SET C_BALANCE = :B4 WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1

aw9ttz9acxbc3 BEGIN payment(:p_w_id, :p_d_id, :p_c_w_id, :p_c_d_id, :p_c_id, :byname, :p_h_amount, :p_c_last, :p_w_street_1, :p_w_street_2, :p_w_city, :p_w_state, :p_w_zip, :p_d_street_1, :p_d_street_2, :p_d_city, :p_d_state, :p_d_zip, :p_c_first, :p_c_middle, :p_c_street_1, :p_c_street_2, :p_c_city, :p_c_state, :p_c_zip, :p_c_phone, :p_c_since, :p_c_credit, :p_c_credit_lim, :p_c_discount, :p_c_balance, :p_c_data, TO_DATE(:timestamp, 'YYYYMMDDHH24MISS')); END;

bsa0wjtftg3uw select file# from file$ where ts#=:1

bswc46zum45tj UPDATE DISTRICT SET D_NEXT_O_ID = D_NEXT_O_ID + 1 WHERE D_ID = :B2 AND D_W_ID = :B1 RETURNING D_NEXT_O_ID, D_TAX INTO :O0 , :O1

c90b8j61ndux8 UPDATE CUSTOMER SET C_BALANCE = :B5 , C_DATA = :B4 WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1

csv0xdm9c394t SELECT O_ID, O_CARRIER_ID, O_ENTRY_D FROM (SELECT O_ID, O_CARRIER_ID, O_ENTRY_D FROM ORDERS WHERE O_D_ID = :B3 AND O_W_ID = :B2 AND O_C_ID=:B1 ORDER BY O_ID DESC) WHERE ROWNUM = 1

d4ujh5yqt1fph BEGIN delivery(:d_w_id, :d_o_carrier_id, TO_DATE(:timestamp, 'YYYYMMDDHH24MISS')); END;

g1r3tpjj3b2gh SELECT D_STREET_1, D_STREET_2, D_CITY, D_STATE, D_ZIP, D_NAME FROM DISTRICT WHERE D_W_ID = :B2 AND D_ID = :B1

g5u7xuchhfu62 UPDATE WAREHOUSE SET W_YTD = W_YTD + :B2 WHERE W_ID = :B1

gcvvtwcxafqp5 BEGIN ostat(:os_w_id, :os_d_id, :os_c_id, :byname, :os_c_last, :os_c_first, :os_c_middle, :os_c_balance, :os_o_id, :os_entdate, :os_o_carrier_id); END;

gwcvcq87cn4sc INSERT INTO ORDERS (O_ID, O_D_ID, O_W_ID, O_C_ID, O_ENTRY_D, O_OL_CNT, O_ALL_LOCAL) VALUES (:B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

SQL Id	SQL Text
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
13dn4hkrzfpdy	SELECT COUNT(DISTINCT (S_I_ID)) FROM ORDER_LINE, STOCK WHERE OL_W_ID = :B2 AND OL_D_ID = :B4 AND (OL_O_ID < :B3 ) AND OL_O_ID >= (:B3 - 20) AND S_W_ID = :B2 AND S_I_ID = OL_I_ID AND S_QUANTITY < :B1
16dhat4ta7xs9	begin neword(:no_w_id, :no_max_w_id, :no_d_id, :no_c_id, :no_o_ol_cnt, :no_c_discount, :no_c_last, :no_c_credit, :no_d_tax, :no_w_tax, :no_d_next_o_id, TO_DATE(:timestamp, 'YYYYMMDDHH24MISS')); END;
1bn3cfn6n3xv5	SELECT C_DATA FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
2k7k32av19mqz	SELECT C_FIRST, C_MIDDLE, C_LAST, C_STREET_1, C_STREET_2, C_CITY, C_STATE, C_ZIP, C_PHONE, C_CREDIT, C_CREDIT_LIM, C_DISCOUNT, C_BALANCE, C_SINCE FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
4r83hzuhh3yuv	SELECT W_STREET_1, W_STREET_2, W_CITY, W_STATE, W_ZIP, W_NAME FROM WAREHOUSE WHERE W_ID = :B1
4wg725nwpxb1z	SELECT C_FIRST, C_MIDDLE, C_ID, C_STREET_1, C_STREET_2, C_CITY, C_STATE, C_ZIP, C_PHONE, C_CREDIT, C_CREDIT_LIM, C_DISCOUNT, C_BALANCE, C_SINCE FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_LAST = :B1 ORDER BY C_FIRST
5hyh0360hgx2u	BEGIN slev(:st_w_id, :st_d_id, :threshold); END;
5mz8u3b34u9gw	SELECT C_DISCOUNT, C_LAST, C_CREDIT, W_TAX FROM CUSTOMER, WAREHOUSE WHERE WAREHOUSE.W_ID = :B3 AND CUSTOMER.C_W_ID = :B3 AND CUSTOMER.C_D_ID = :B2 AND CUSTOMER.C_ID = :B1
5xm451a80drbc	INSERT INTO HISTORY (H_C_D_ID, H_C_W_ID, H_C_ID, H_D_ID, H_W_ID, H_DATE, H_AMOUNT, H_DATA) VALUES (:B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
69gxtaqr1vk8j	UPDATE DISTRICT SET D_YTD = D_YTD + :B3 WHERE D_W_ID = :B2 AND D_ID = :B1
7m5h0wf6stq0q	SELECT COUNT(C_ID) FROM CUSTOMER WHERE C_LAST = :B3 AND C_D_ID = :B2 AND C_W_ID = :B1
80ajya2tnyfg2	INSERT INTO NEW_ORDER (NO_O_ID, NO_D_ID, NO_W_ID) VALUES (:B3 , :B2 , :B1 )
86708bvah4akq	select name from undo$ where file#=:1 and block#=:2 and ts#=:3 and status$ != 1
88fgqncchy6wg	SELECT I_PRICE, I_NAME, I_DATA FROM ITEM WHERE I_ID = :B1
89k9fqaq5b5sy	SELECT C_BALANCE, C_FIRST, C_MIDDLE, C_ID FROM CUSTOMER WHERE C_LAST = :B3 AND C_D_ID = :B2 AND C_W_ID = :B1 ORDER BY C_FIRST
95yr4xtfr50hx	UPDATE CUSTOMER SET C_BALANCE = :B4 WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
aw9ttz9acxbc3	BEGIN payment(:p_w_id, :p_d_id, :p_c_w_id, :p_c_d_id, :p_c_id, :byname, :p_h_amount, :p_c_last, :p_w_street_1, :p_w_street_2, :p_w_city, :p_w_state, :p_w_zip, :p_d_street_1, :p_d_street_2, :p_d_city, :p_d_state, :p_d_zip, :p_c_first, :p_c_middle, :p_c_street_1, :p_c_street_2, :p_c_city, :p_c_state, :p_c_zip, :p_c_phone, :p_c_since, :p_c_credit, :p_c_credit_lim, :p_c_discount, :p_c_balance, :p_c_data, TO_DATE(:timestamp, 'YYYYMMDDHH24MISS')); END;
bsa0wjtftg3uw	select file# from file$ where ts#=:1
bswc46zum45tj	UPDATE DISTRICT SET D_NEXT_O_ID = D_NEXT_O_ID + 1 WHERE D_ID = :B2 AND D_W_ID = :B1 RETURNING D_NEXT_O_ID, D_TAX INTO :O0 , :O1
c90b8j61ndux8	UPDATE CUSTOMER SET C_BALANCE = :B5 , C_DATA = :B4 WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
csv0xdm9c394t	SELECT O_ID, O_CARRIER_ID, O_ENTRY_D FROM (SELECT O_ID, O_CARRIER_ID, O_ENTRY_D FROM ORDERS WHERE O_D_ID = :B3 AND O_W_ID = :B2 AND O_C_ID=:B1 ORDER BY O_ID DESC) WHERE ROWNUM = 1
d4ujh5yqt1fph	BEGIN delivery(:d_w_id, :d_o_carrier_id, TO_DATE(:timestamp, 'YYYYMMDDHH24MISS')); END;
g1r3tpjj3b2gh	SELECT D_STREET_1, D_STREET_2, D_CITY, D_STATE, D_ZIP, D_NAME FROM DISTRICT WHERE D_W_ID = :B2 AND D_ID = :B1
g5u7xuchhfu62	UPDATE WAREHOUSE SET W_YTD = W_YTD + :B2 WHERE W_ID = :B1
gcvvtwcxafqp5	BEGIN ostat(:os_w_id, :os_d_id, :os_c_id, :byname, :os_c_last, :os_c_first, :os_c_middle, :os_c_balance, :os_o_id, :os_entdate, :os_o_carrier_id); END;
gwcvcq87cn4sc	INSERT INTO ORDERS (O_ID, O_D_ID, O_W_ID, O_C_ID, O_ENTRY_D, O_OL_CNT, O_ALL_LOCAL) VALUES (:B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

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	82,899	137.76	1.12
CPU used when call started	82,841	137.66	1.12
CR blocks created	11,707	19.45	0.16
Cached Commit SCN referenced	936	1.56	0.01
Commit SCN cached	1	0.00	0.00
DB time	595,712	989.91	8.03
DBWR checkpoint buffers written	22,181	36.86	0.30
DBWR checkpoints	3	0.00	0.00
DBWR transaction table writes	41	0.07	0.00
DBWR undo block writes	74,532	123.85	1.01
IMU CR rollbacks	10,906	18.12	0.15
IMU Flushes	86,329	143.46	1.16
IMU Redo allocation size	203,507,388	338,174.60	2,744.91
IMU commits	57,174	95.01	0.77
IMU contention	73,150	121.56	0.99
IMU pool not allocated	4,841	8.04	0.07
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	380,839,536	632,852.99	5,136.76
IMU- failed to get a private strand	4,841	8.04	0.07
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SQL*Net roundtrips to/from client	172,866	287.26	2.33
active txn count during cleanout	18,494	30.73	0.25
application wait time	32,862	54.61	0.44
auto extends on undo tablespace	28	0.05	0.00
background checkpoints completed	3	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	1,923	3.20	0.03
buffer is not pinned count	5,114,673	8,499.21	68.99
buffer is pinned count	46,573,931	77,393.36	628.19
bytes received via SQL*Net from client	195,831,763	325,419.77	2,641.38
bytes sent via SQL*Net to client	76,160,948	126,559.03	1,027.26
calls to get snapshot scn: kcmgss	987,689	1,641.27	13.32
calls to kcmgas	164,966	274.13	2.23
calls to kcmgcs	11,257	18.71	0.15
change write time	4,146	6.89	0.06
cleanout - number of ktugct calls	19,667	32.68	0.27
cleanouts and rollbacks - consistent read gets	8,203	13.63	0.11
cleanouts only - consistent read gets	624	1.04	0.01
cluster key scan block gets	4,137	6.87	0.06
cluster key scans	3,148	5.23	0.04
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	74,081	123.10	1.00
commit batch/immediate requested	74,083	123.11	1.00
commit cleanout failures: callback failure	381	0.63	0.01
commit cleanout failures: cannot pin	3,315	5.51	0.04
commit cleanouts	296,746	493.11	4.00
commit cleanouts successfully completed	293,050	486.97	3.95
commit immediate performed	74,081	123.10	1.00
commit immediate requested	74,081	123.10	1.00
commit txn count during cleanout	3,966	6.59	0.05
concurrency wait time	2,939	4.88	0.04
consistent changes	15,844	26.33	0.21
consistent gets	7,492,808	12,451.03	101.06
consistent gets - examination	6,248,250	10,382.91	84.28
consistent gets from cache	7,492,808	12,451.03	101.06
cursor authentications	159	0.26	0.00
data blocks consistent reads - undo records applied	11,945	19.85	0.16
db block changes	2,403,399	3,993.80	32.42
db block gets	2,373,013	3,943.31	32.01
db block gets direct	8	0.01	0.00
db block gets from cache	2,373,005	3,943.30	32.01
deferred (CURRENT) block cleanout applications	174,666	290.25	2.36
dirty buffers inspected	80,348	133.52	1.08
drop segment calls in space pressure	867	1.44	0.01
enqueue conversions	27,570	45.81	0.37
enqueue releases	778,757	1,294.08	10.50
enqueue requests	778,755	1,294.08	10.50
enqueue timeouts	0	0.00	0.00
enqueue waits	8,716	14.48	0.12
execute count	1,208,979	2,009.00	16.31
frame signature mismatch	2	0.00	0.00
free buffer inspected	233,096	387.34	3.14
free buffer requested	239,290	397.64	3.23
global undo segment hints helped	25	0.04	0.00
global undo segment hints were stale	2	0.00	0.00
heap block compress	5,759	9.57	0.08
hot buffers moved to head of LRU	144,933	240.84	1.95
immediate (CR) block cleanout applications	8,827	14.67	0.12
immediate (CURRENT) block cleanout applications	17	0.03	0.00
index fetch by key	2,188,136	3,636.09	29.51
index scans kdiixs1	202,284	336.14	2.73
leaf node 90-10 splits	7	0.01	0.00
leaf node splits	9	0.01	0.00
lob reads	356	0.59	0.00
lob writes	159	0.26	0.00
lob writes unaligned	159	0.26	0.00
local undo segment hints helped	63	0.10	0.00
local undo segment hints were stale	128	0.21	0.00
logons cumulative	178	0.30	0.00
messages received	124,083	206.19	1.67
messages sent	124,084	206.19	1.67
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	1,012,600	1,682.67	13.66
opened cursors cumulative	191,963	318.99	2.59
parse count (hard)	660	1.10	0.01
parse count (total)	259,791	431.70	3.50
parse time cpu	2,387	3.97	0.03
parse time elapsed	4,045	6.72	0.05
physical read IO requests	152,329	253.13	2.05
physical read bytes	2,496,495,616	4,148,504.97	33,672.72
physical read total IO requests	153,242	254.65	2.07
physical read total bytes	2,511,358,976	4,173,203.88	33,873.20
physical read total multi block requests	16	0.03	0.00
physical reads	152,374	253.20	2.06
physical reads cache	152,362	253.18	2.06
physical reads cache prefetch	45	0.07	0.00
physical reads direct	12	0.02	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	67,930	112.88	0.92
physical write bytes	1,760,247,808	2,925,058.92	23,742.21
physical write total IO requests	150,938	250.82	2.04
physical write total bytes	2,118,525,952	3,520,420.94	28,574.67
physical write total multi block requests	130,446	216.77	1.76
physical writes	107,437	178.53	1.45
physical writes direct	20	0.03	0.00
physical writes from cache	107,417	178.50	1.45
physical writes non checkpoint	89,433	148.61	1.21
pinned buffers inspected	4	0.01	0.00
prefetch clients - default	3	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
process last non-idle time	602	1.00	0.01
recovery blocks read	0	0.00	0.00
recursive calls	2,009,576	3,339.38	27.11
recursive cpu usage	52,367	87.02	0.71
redo blocks read for recovery	0	0.00	0.00
redo blocks written	668,748	1,111.28	9.02
redo buffer allocation retries	58	0.10	0.00
redo entries	700,519	1,164.07	9.45
redo log space requests	84	0.14	0.00
redo log space wait time	1,426	2.37	0.02
redo ordering marks	3,679	6.11	0.05
redo size	305,513,448	507,681.27	4,120.76
redo synch time	37,152	61.74	0.50
redo synch writes	179,016	297.48	2.41
redo wastage	25,181,072	41,844.18	339.64
redo write time	17,481	29.05	0.24
redo writer latching time	157	0.26	0.00
redo writes	114,047	189.52	1.54
rollback changes - undo records applied	370,415	615.53	5.00
rollbacks only - consistent read gets	3,503	5.82	0.05
rows fetched via callback	1,871,263	3,109.54	25.24
session connect time	0	0.00	0.00
session cursor cache hits	184,090	305.91	2.48
session logical reads	9,865,823	16,394.35	133.07
session uga memory	4,849,232	8,058.12	65.41
session uga memory max	80,176,268	133,231.42	1,081.42
shared hash latch upgrades - no wait	229,859	381.96	3.10
shared hash latch upgrades - wait	62	0.10	0.00
sorts (memory)	11,267	18.72	0.15
sorts (rows)	122,306	203.24	1.65
space was found by tune down	860	1.43	0.01
space was not found by tune down	4	0.01	0.00
sql area evicted	251	0.42	0.00
sql area purged	0	0.00	0.00
steps of tune down ret. in space pressure	873	1.45	0.01
summed dirty queue length	237,013	393.85	3.20
switch current to new buffer	31	0.05	0.00
table fetch by rowid	24,925,056	41,418.75	336.19
table fetch continued row	197	0.33	0.00
table scan blocks gotten	41,090	68.28	0.55
table scan rows gotten	129,466	215.14	1.75
table scans (short tables)	5,970	9.92	0.08
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	74,083	123.11	1.00
tune down retentions in space pressure	864	1.44	0.01
undo change vector size	84,392,096	140,236.99	1,138.28
user I/O wait time	374,601	622.49	5.05
user calls	343,906	571.48	4.64
user commits	74,140	123.20	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	8,994	14.95	0.12
write clones created in foreground	27	0.04	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	4,397	6,594
opened cursors current	342	346
logons current	29	29

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)	3	17.95

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)
USERS	150,295	250	24.49	1.00	14,459	24	8,528	4.95
UNDOTBS1	3	0	70.00	1.00	53,276	89	615	6.11
SYSTEM	1,334	2	23.00	1.01	14	0	0	0.00
SYSAUX	550	1	18.85	1.05	199	0	0	0.00
TEMP	1	0	200.00	1.00	0	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)
SYSAUX	/u02/app/oracle/oradata/TESTIBM/sysaux01.dbf	550	1	18.85	1.05	199	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	1,334	2	23.00	1.01	14	0	0	0.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	1	0	200.00	1.00	0	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	3	0	70.00	1.00	53,276	89	615	6.11
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	150,295	250	24.49	1.00	14,459	24	8,528	4.95

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	44,803	98	9,864,215	152,101	107,484	0	0	9,138

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	74	13850	349414	1290240	1290240
E	0	73	13648	342421	1290240	1290240	1841096

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	68	0.10	4,284	5.80	2,657,507
D	136	0.19	8,568	2.82	1,291,938
D	204	0.29	12,852	2.21	1,015,026
D	272	0.38	17,136	1.86	853,352
D	340	0.48	21,420	1.60	735,221
D	408	0.57	25,704	1.43	654,760
D	476	0.67	29,988	1.30	594,475
D	544	0.76	34,272	1.19	546,816
D	612	0.86	38,556	1.11	506,560
D	680	0.96	42,840	1.03	472,504
D	712	1.00	44,856	1.00	458,309
D	748	1.05	47,124	0.97	444,005
D	816	1.15	51,408	0.91	418,211
D	884	1.24	55,692	0.86	395,951
D	952	1.34	59,976	0.82	376,771
D	1,020	1.43	64,260	0.79	360,612
D	1,088	1.53	68,544	0.76	346,871
D	1,156	1.62	72,828	0.73	335,124
D	1,224	1.72	77,112	0.71	325,450
D	1,292	1.81	81,396	0.69	317,276
D	1,360	1.91	85,680	0.68	311,156

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	137	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	103	71	57.47	0.00	0.00	0.00	0.00	21,094
E	103	71	56.91	0.00	0.00	0.00	0.00	21,094

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	8,785	8,785
64K	128K	3	3
256K	512K	2	2
512K	1024K	201	201

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 PGA Cache Hit %	Estd PGA Overalloc Count
13	0.13	361.94	100.00	3
26	0.25	361.94	100.00	2
52	0.50	361.94	100.00	0
77	0.75	361.94	100.00	0
103	1.00	361.94	100.00	0
124	1.20	361.94	100.00	0
144	1.40	361.94	100.00	0
165	1.60	361.94	100.00	0
185	1.80	361.94	100.00	0
206	2.00	361.94	100.00	0
309	3.00	361.94	100.00	0
412	4.00	361.94	100.00	0
618	6.00	361.94	100.00	0
824	8.00	361.94	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
56	0.78	9	1,196	362,612	0.99	2,370	16.69	1,548,135
64	0.89	16	1,801	364,815	1.00	167	1.18	1,549,212
72	1.00	22	2,341	364,840	1.00	142	1.00	1,549,868
80	1.11	29	3,038	364,844	1.00	138	0.97	1,549,968
88	1.22	33	3,627	364,844	1.00	138	0.97	1,549,977
96	1.33	33	3,627	364,844	1.00	138	0.97	1,549,977
104	1.44	33	3,627	364,844	1.00	138	0.97	1,549,977
112	1.56	33	3,627	364,844	1.00	138	0.97	1,549,977
120	1.67	33	3,627	364,844	1.00	138	0.97	1,549,977
128	1.78	33	3,627	364,844	1.00	138	0.97	1,549,977
136	1.89	33	3,627	364,844	1.00	138	0.97	1,549,977
144	2.00	33	3,627	364,844	1.00	138	0.97	1,549,977

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
200	0.25	72,064	2,732,259
400	0.50	23,600	756,009
600	0.75	18,804	562,191
800	1.00	16,196	456,472
1,000	1.25	14,505	387,408
1,200	1.50	13,451	344,499
1,400	1.75	12,859	319,987
1,600	2.00	12,867	319,987

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	8,510	42	5
file header block	235	3	11
undo header	368	1	3
1st level bmb	16	0	0
undo block	12	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	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	8,422	8,423	8,421	211	25.02
HW-Segment High Water Mark	60,545	60,544	149	3	22.48
US-Undo Segment	28,395	28,395	168	0	2.14
FB-Format Block	68	68	3	0	0.00
TX-Transaction	151,943	151,761	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	130.42	266,250	0	12	14.8166666666666666666666666666666666667/16.833333333333333333333333333333333333	0/0	13/0/0/2822/148236/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
11-Apr 12:07	56,554	113,202	0	12	17	0/0	0/0/0/7/2300/0
11-Apr 11:57	73,861	153,048	0	12	15	0/0	13/0/0/2815/145936/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
AWR Alerted Metric Element list	2,092	0.00		0	0
Consistent RBA	114,066	0.02	0.16	0	0
FOB s.o list latch	752	0.00		0	0
In memory undo latch	1,436,236	0.81	0.07	2	148,372	0.00
JS queue state obj latch	3,600	0.00		0	0
KMG MMAN ready and startup request latch	201	0.00		0	0
KTF sga latch	1	0.00		0	202	0.00
KWQMN job cache list latch	1	0.00		0	0
MQL Tracking Latch	0			0	12	0.00
Memory Management Latch	0			0	201	0.00
Mutex Stats	1	0.00		0	0
OS process	546	0.00		0	0
OS process allocation	565	0.00		0	0
OS process: request allocation	356	0.00		0	0
PL/SQL warning settings	170,773	0.44	0.00	0	0
SGA IO buffer pool latch	8,340	0.00		0	8,319	0.00
SQL memory manager latch	1	0.00		0	197	0.00
SQL memory manager workarea list latch	14,552	0.00		0	0
Shared B-Tree	23	0.00		0	0
Undo Hint Latch	0			0	2,917	0.00
active checkpoint queue latch	8,703	0.00		0	0
active service list	2,070	0.00		0	261	0.00
archive control	4	0.00		0	0
begin backup scn array	1	0.00		0	0
cache buffer handles	1,370	0.00		0	0
cache buffers chains	20,618,072	0.10	0.02	1	237,840	0.07
cache buffers lru chain	326,048	0.13	0.02	0	248,678	0.64
cache table scan latch	0			0	16	0.00
channel handle pool latch	358	0.28	0.00	0	0
channel operations parent latch	9,609	0.00		0	0
checkpoint queue latch	183,576	0.01	0.00	0	101,273	0.03
client/application info	907	0.00		0	0
compile environment latch	181,329	0.10	0.00	0	0
dml lock allocation	1,039,007	1.00	0.02	1	0
dummy allocation	356	0.00		0	0
enqueue hash chains	1,600,294	0.68	0.05	1	1,488	0.34
enqueues	401,017	0.33	0.00	0	0
event group latch	178	0.00		0	0
file cache latch	3,161	0.00		0	0
global KZLD latch for mem in SGA	176	0.00		0	0
hash table column usage latch	0			0	16,867	0.00
hash table modification latch	11	0.00		0	0
job_queue_processes parameter latch	10	0.00		0	0
kks stats	1,712	0.00		0	0
ksuosstats global area	42	0.00		0	0
ktm global data	2	0.00		0	0
kwqbsn:qsga	23	0.00		0	0
lgwr LWN SCN	114,049	0.01	0.00	0	0
library cache	1,393,140	0.51	0.03	0	3,777	0.19
library cache load lock	3,186	0.06	0.00	0	4	0.00
library cache lock	342,539	0.32	0.01	0	0
library cache lock allocation	3,383	0.00		0	0
library cache pin	681,114	0.47	0.02	0	0
library cache pin allocation	710	0.00		0	0
list of block allocation	356	0.00		0	0
loader state object freelist	38	0.00		0	0
message pool operations parent latch	2	0.00		0	0
messages	384,453	0.07	0.10	0	0
mostly latch-free SCN	114,492	0.09	0.02	0	0
multiblock read objects	32	0.00		0	0
ncodef allocation latch	12	0.00		0	0
object queue header heap	17,956	0.00		0	570	0.00
object queue header operation	794,777	0.05	0.05	0	0
object stats modification	28	0.00		0	0
parallel query alloc buffer	80	0.00		0	0
parameter list	639	0.00		0	0
parameter table allocation management	178	0.00		0	0
post/wait queue	131,703	0.02	0.00	0	86,671	0.26
process allocation	356	0.00		0	178	0.00
process group creation	356	0.00		0	0
qmn task queue latch	88	0.00		0	0
redo allocation	645,887	0.24	0.15	0	697,484	1.30
redo copy	0			0	701,024	0.69
redo writing	359,059	0.00	0.20	0	0
resmgr group change latch	181	0.00		0	0
resmgr:actses active list	353	0.00		0	0
resmgr:actses change group	176	0.00		0	0
resmgr:free threads list	352	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	1,567,315	0.40	0.02	0	2,549	0.08
sequence cache	1,015	0.00		0	0
session allocation	729,148	0.43	0.02	0	0
session idle bit	868,481	0.06	0.02	0	0
session state list latch	360	0.00		0	0
session switching	12	0.00		0	0
session timer	261	0.00		0	0
shared pool	85,041	0.15	0.05	0	0
shared pool sim alloc	13	0.00		0	0
shared pool simulator	76,361	0.00		0	0
simulator hash latch	599,054	0.00	0.00	0	0
simulator lru latch	563,324	0.21	0.07	0	14,282	0.00
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	23	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	112	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	35	0.00		0	0
transaction allocation	4,246	0.00		0	0
transaction branch allocation	12	0.00		0	0
undo global data	1,236,361	0.13	0.02	0	0
user lock	704	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	20,618,072	21,118	428	20,693
In memory undo latch	1,436,236	11,603	865	10,748
enqueue hash chains	1,600,294	10,822	508	10,324
dml lock allocation	1,039,007	10,411	241	10,171
library cache	1,393,140	7,118	187	6,932
row cache objects	1,567,315	6,267	101	6,166
library cache pin	681,114	3,189	55	3,134
session allocation	729,148	3,123	50	3,073
undo global data	1,236,361	1,595	37	1,559
redo allocation	645,887	1,554	240	1,316
enqueues	401,017	1,310	6	1,304
simulator lru latch	563,324	1,178	77	1,101
library cache lock	342,539	1,079	10	1,069
session idle bit	868,481	545	13	532
cache buffers lru chain	326,048	423	8	415
object queue header operation	794,777	384	19	365
messages	384,453	288	28	260
shared pool	85,041	127	6	121
mostly latch-free SCN	114,492	106	2	104
Consistent RBA	114,066	19	3	16
redo writing	359,059	15	3	12
slave class create	8	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	622	766
In memory undo latch	ktiTxnPoolFree	83	0
In memory undo latch	ktichg: child	81	68
In memory undo latch	kticmt: child	72	6
In memory undo latch	kturbk	6	25
In memory undo latch	ktuswr	1	0
cache buffers chains	kcbgtcr: fast path	232	212
cache buffers chains	kcbgcur: kslbegin	130	187
cache buffers chains	kcbchg: kslbegin: bufs not pinned	56	88
cache buffers chains	kcbgtcr: kslbegin excl	47	25
cache buffers chains	kcbnlc	30	29
cache buffers chains	kcbnew: new latch again	19	1
cache buffers chains	kcbgtcr: kslbegin shared	17	0
cache buffers chains	kcbzgb: scan from tail. nowait	16	0
cache buffers chains	kcbrls: kslbegin	15	10
cache buffers chains	kcbchg: kslbegin: call CR func	13	40
cache buffers chains	kcbgtcr	13	0
cache buffers chains	kcb_pre_apply: kcbhq61	8	7
cache buffers chains	kcbget: exchange rls	5	0
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	5	0
cache buffers chains	kcb_post_apply: kcbhq62	3	1
cache buffers chains	kcbbxsv	3	5
cache buffers chains	kcbget: pin buffer	3	5
cache buffers chains	kcbzwb	3	4
cache buffers chains	kcbget: exchange	2	0
cache buffers chains	kcbzib: finish free bufs	2	2
cache buffers lru chain	kcbzgws	7	2
cache buffers lru chain	kcbbxsv: move to being written	1	5
dml lock allocation	ktaiam	139	180
dml lock allocation	ktaidm	102	61
enqueue hash chains	ksqrcl	266	153
enqueue hash chains	ksqgtl3	237	350
enqueue hash chains	ksqcmi: get hash chain latch after wait	5	4
enqueues	ksqdel	3	0
enqueues	ksqies	2	5
enqueues	ksqgel: create enqueue	1	1
library cache	kglpndl: child: after processing	84	0
library cache	kglpnp: child	53	106
library cache	kglLockCursor	28	3
library cache	kglpndl: child: before processing	9	73
library cache	kglobpn: child:	5	0
library cache	kgldte: child 0	3	5
library cache	kglhdgn: child:	2	0
library cache	kglpin	2	0
library cache lock	kgllkal: child: multiinstance	8	2
library cache lock	kgllkdl: child: cleanup	2	8
library cache pin	kglpnp: child	28	32
library cache pin	kglpndl	25	21
library cache pin	kglpnal: child: alloc space	2	2
messages	ksaamb: after wakeup	15	16
messages	ksarcv: after wait	6	2
messages	ksarcv	5	10
messages	ksarcr	1	0
messages	ksarcr: inside loop	1	0
mostly latch-free SCN	kcsnew_scn_rba	2	0
mostly latch-free SCN	kcs01	1	3
mostly latch-free SCN	kcs04	1	2
mostly latch-free SCN	kcs05	1	0
object queue header operation	kcbo_switch_cq	8	15
object queue header operation	kcbw_link_q	6	0
object queue header operation	kcbo_switch_q_bg	3	0
object queue header operation	kcbw_unlink_q	2	4
redo allocation	kcrfw_redo_gen: redo allocation 1	228	0
redo allocation	kcrfw_redo_gen: redo allocation 3	8	6
redo allocation	kcrfw_redo_gen: redo allocation 2	3	0
redo allocation	kcrfw_redo_write: before write	1	120
redo writing	kcrfw_post: rba scn pair	2	0
redo writing	kcrfwcr	1	1
row cache objects	kqreqd: reget	55	0
row cache objects	kqrpre: find obj	44	79
row cache objects	kqreqd	1	21
row cache objects	kqrso	1	0
session allocation	ksucri	18	43
session allocation	ksudlc	12	3
session allocation	ksuprc	11	2
session allocation	ksuxds: not user session	9	2
session idle bit	ksupuc: clear busy	5	6
session idle bit	ksuxds	5	2
session idle bit	ksupuc: set busy	3	5
shared pool	kghalo	4	1
shared pool	kghfrunp: alloc: wait	2	0
shared pool	kghfrunp: clatch: nowait	1	0
simulator lru latch	kcbs_simulate: simulate set	77	77
slave class create	ksvcreate	1	0
undo global data	ktudba: KSLBEGIN	18	10
undo global data	ktudnx:child	13	7
undo global data	ktubnd:child	3	0
undo global data	ktuGetRetentionDuration	1	0
undo global data	ktusmasp: ktugd_tuux	1	1
undo global data	ktusmupst: KSLBEGIN	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: 9,865,823
Captured Segments account for 84.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	3,005,120	30.46
TPCC	USERS	STOCK	TABLE	1,490,064	15.10
TPCC	USERS	CUSTOMER_I2	INDEX	605,264	6.13
TPCC	USERS	CUSTOMER	TABLE	573,488	5.81
TPCC	USERS	CUSTOMER_I1	INDEX	432,480	4.38

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 152,374
Captured Segments account for 98.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	ITEM_ID	INDEX	72,113	47.33
TPCC	USERS	ITEM	TABLE	40,613	26.65
TPCC	USERS	CUSTOMER	TABLE	18,283	12.00
TPCC	USERS	STOCK	TABLE	16,744	10.99
TPCC	USERS	HISTORY	TABLE	723	0.47

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
TPCC	USERS	DISTRICT	TABLE	8,742	52.05
TPCC	USERS	WAREHOUSE	TABLE	8,048	47.92
TPCC	USERS	CUSTOMER	TABLE	4	0.02

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	Obj. Type	Buffer Busy Waits	% of Capture
TPCC	USERS	ORDERS	TABLE	6,228	83.50
TPCC	USERS	HISTORY	TABLE	709	9.51
TPCC	USERS	WAREHOUSE	TABLE	402	5.39
TPCC	USERS	DISTRICT	TABLE	109	1.46
TPCC	USERS	INORD	INDEX	8	0.11

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	14	7.14	2	1
dc_global_oids	61	29.51	0	0
dc_histogram_data	3,885	30.91	0	370
dc_histogram_defs	8,303	36.22	0	856
dc_object_grants	53	22.64	0	5
dc_object_ids	4,939	8.65	0	196
dc_objects	2,652	17.61	0	184
dc_profiles	177	0.56	0	1
dc_rollback_segments	74,089	0.00	0	23
dc_segments	7,952	7.91	5	162
dc_sequences	26	23.08	26	1
dc_tablespaces	414,092	0.00	0	5
dc_usernames	500	1.00	0	3
dc_users	6,567	0.21	0	15
outstanding_alerts	13	76.92	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	10	30.00	81,899	0.02	6
CLUSTER	38	5.26	92	3.26	1
INDEX	39	76.92	133	26.32	5
SQL AREA	502	81.47	1,388,919	0.12	238
TABLE/PROCEDURE	1,415	24.17	258,808	0.58	417

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	46.37		1.60	3.91	22	22	29	29
	Freeable	8.56	0.00	0.95	0.26	1		9	9
	SQL	1.55	0.71	0.07	0.03	0	2	23	23
	PL/SQL	1.25	0.65	0.04	0.05	0	0	29	29
E	Other	45.29		1.56	3.92	22	22	29	29
	Freeable	8.88	0.00	0.89	0.33	1		10	10
	SQL	1.57	0.73	0.07	0.02	0	2	23	23
	PL/SQL	1.25	0.65	0.04	0.05	0	0	29	29

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	746,586,112
Fixed Size	1,263,572
Redo Buffers	7,122,944
Variable Size	83,888,172

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	4.00	4.00	0.00
large	PX msg pool	1.02	1.02	0.00
large	free memory	2.98	2.98	0.00
shared	ASH buffers	8.00	8.00	0.00
shared	FileOpenBlock	1.58	1.58	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGH: NO ACCESS	6.99	3.17	-54.58
shared	KGLS heap	0.82	1.05	28.01
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KSXR pending messages que	0.80	0.80	0.00
shared	KSXR receive buffers	0.99	0.99	0.00
shared	KTI-UNDO	2.36	2.36	0.00
shared	db_block_hash_buckets	1.13	1.13	0.00
shared	dbwriter coalesce buffer	1.00	1.00	0.00
shared	event statistics per sess	2.56	2.56	0.00
shared	free memory	12.30	12.34	0.36
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kks stbkt	0.88	0.88	0.00
shared	library cache	2.96	2.95	-0.34
shared	private strands	2.29	2.29	0.00
shared	row cache	3.57	3.57	0.00
shared	sessions	1.54	1.54	0.00
shared	sql area	2.73	2.41	-11.55
	buffer_cache	712.00	712.00	0.00
	fixed_sga	1.21	1.21	0.00
	log_buffer	6.79	6.79	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

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/opt/oracle/admin/TESTIBM/adump
background_dump_dest	/opt/oracle/admin/TESTIBM/bdump
compatible	10.2.0.2.0
control_files	/u02/app/oracle/oradata/TESTIBM/control01.ctl, /u02/app/oracle/oradata/TESTIBM/control02.ctl, /u03/app/oracle/oradata/TESTIBM/control03.ctl
core_dump_dest	/opt/oracle/admin/TESTIBM/cdump
db_block_size	16384
db_domain
db_file_multiblock_read_count	16
db_name	TESTIBM
filesystemio_options	SETALL
job_queue_processes	10
open_cursors	300
pga_aggregate_target	108003328
processes	300
remote_login_passwordfile	EXCLUSIVE
sessions	335
sga_target	838860800
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/opt/oracle/admin/TESTIBM/udump

End of Report

% Blocks changed per Read:	24.36	Recursive Call %:	85.39
Rollback per transaction %:	0.00	Rows per Sort:	10.86

Buffer Nowait %:	99.91	Redo NoWait %:	99.99
Buffer Hit %:	98.46	In-memory Sort %:	100.00
Library Hit %:	99.81	Soft Parse %:	99.75
Execute to Parse %:	78.51	Latch Hit %:	99.77
Parse CPU to Parse Elapsd %:	59.01	% Non-Parse CPU:	97.43