WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

TESTIBM 1449334575 TESTIBM 1 10.2.0.2.0 NO brepredbwh04

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 47 20-Apr-06 14:50:34 30 13.4

End Snap: 48 20-Apr-06 15:00:36 30 14.4

Elapsed: 10.03 (mins)

DB Time: 94.39 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	47	20-Apr-06 14:50:34	30	13.4
End Snap:	48	20-Apr-06 15:00:36	30	14.4
Elapsed:		10.03 (mins)
DB Time:		94.39 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 720M 720M Std Block Size: 4K

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

	Begin	End
Buffer Cache:	720M	720M	Std Block Size:	4K
Shared Pool Size:	88M	88M	Log Buffer:	6,956K

Load Profile

Per Second Per Transaction

Redo size: 222,379.79 4,169.47

Logical reads: 7,377.89 138.33

Block changes: 1,745.77 32.73

Physical reads: 310.22 5.82

Physical writes: 109.15 2.05

User calls: 248.87 4.67

Parses: 188.02 3.53

Hard parses: 1.06 0.02

Sorts: 9.35 0.18

Logons: 0.13 0.00

Executes: 877.62 16.45

Transactions: 53.34

	Per Second	Per Transaction
Redo size:	222,379.79	4,169.47
Logical reads:	7,377.89	138.33
Block changes:	1,745.77	32.73
Physical reads:	310.22	5.82
Physical writes:	109.15	2.05
User calls:	248.87	4.67
Parses:	188.02	3.53
Hard parses:	1.06	0.02
Sorts:	9.35	0.18
Logons:	0.13	0.00
Executes:	877.62	16.45
Transactions:	53.34

% Blocks changed per Read: 23.66 Recursive Call %: 86.15

Rollback per transaction %: 0.00 Rows per Sort: 11.38

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 100.00

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

Library Hit %: 99.57 Soft Parse %: 99.44

Execute to Parse %: 78.58 Latch Hit %: 99.94

Parse CPU to Parse Elapsd %: 50.35 % Non-Parse CPU: 96.51

Shared Pool Statistics

Begin End

Memory Usage %: 74.45 74.50

% SQL with executions>1: 88.65 85.96

% Memory for SQL w/exec>1: 80.88 76.66

	Begin	End
Memory Usage %:	74.45	74.50
% SQL with executions>1:	88.65	85.96
% Memory for SQL w/exec>1:	80.88	76.66

Top 5 Timed Events

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

db file sequential read 187,206 4,666 25 82.4 User I/O

enq: TX - row lock contention 11,338 594 52 10.5 Application

CPU time 418 7.4

log file sync 32,421 39 1 .7 Commit

SQL*Net break/reset to client 64,840 25 0 .4 Application

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	187,206	4,666	25	82.4	User I/O
enq: TX - row lock contention	11,338	594	52	10.5	Application
CPU time		418		7.4
log file sync	32,421	39	1	.7	Commit
SQL*Net break/reset to client	64,840	25	0	.4	Application

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): 5663.2s
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	5,579.09	98.51
DB CPU	417.53	7.37
PL/SQL execution elapsed time	37.51	0.66
parse time elapsed	20.88	0.37
hard parse elapsed time	11.04	0.19
PL/SQL compilation elapsed time	3.08	0.05
connection management call elapsed time	0.98	0.02
repeated bind elapsed time	0.40	0.01
hard parse (sharing criteria) elapsed time	0.16	0.00
sequence load elapsed time	0.10	0.00
DB time	5,663.21
background elapsed time	140.02
background cpu time	50.49

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	187,233	0.00	4,667	25	5.84
Application	76,178	0.00	620	8	2.37
Commit	32,421	0.00	39	1	1.01
Concurrency	1,122	3.21	4	3	0.03
System I/O	73,523	0.00	3	0	2.29
Network	76,348	0.00	1	0	2.38
Configuration	15	0.00	1	48	0.00
Other	615	0.00	0	0	0.02

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	187,206	0.00	4,666	25	5.84
enq: TX - row lock contention	11,338	0.00	594	52	0.35
log file sync	32,421	0.00	39	1	1.01
SQL*Net break/reset to client	64,840	0.00	25	0	2.02
buffer busy waits	1,018	0.00	3	3	0.03
log file parallel write	64,758	0.00	2	0	2.02
control file parallel write	295	0.00	1	3	0.01
SQL*Net message to client	75,925	0.00	1	0	2.37
cursor: pin S wait on X	36	100.00	1	15	0.00
control file sequential read	865	0.00	0	1	0.03
log file switch completion	7	0.00	0	55	0.00
enq: HW - contention	8	0.00	0	43	0.00
db file scattered read	5	0.00	0	47	0.00
db file parallel write	7,601	0.00	0	0	0.24
read by other session	12	0.00	0	12	0.00
os thread startup	2	0.00	0	55	0.00
latch free	53	0.00	0	2	0.00
LGWR wait for redo copy	363	0.00	0	0	0.01
rdbms ipc reply	62	0.00	0	0	0.00
latch: In memory undo latch	26	0.00	0	1	0.00
latch: enqueue hash chains	36	0.00	0	1	0.00
latch: cache buffers chains	20	0.00	0	1	0.00
SQL*Net more data to client	407	0.00	0	0	0.01
log file single write	2	0.00	0	6	0.00
latch: redo allocation	34	0.00	0	0	0.00
enq: FB - contention	4	0.00	0	3	0.00
latch: library cache	16	0.00	0	1	0.00
latch: session allocation	7	0.00	0	1	0.00
log file sequential read	2	0.00	0	4	0.00
latch: cache buffers lru chain	3	0.00	0	1	0.00
latch: library cache pin	4	0.00	0	0	0.00
cursor: pin S	43	0.00	0	0	0.00
latch: object queue header operation	4	0.00	0	0	0.00
latch: undo global data	1	0.00	0	1	0.00
SQL*Net more data from client	16	0.00	0	0	0.00
latch: messages	5	0.00	0	0	0.00
direct path write	6	0.00	0	0	0.00
direct path read	4	0.00	0	0	0.00
SQL*Net message from client	75,924	0.00	1,287	17	2.37
Streams AQ: qmn slave idle wait	22	0.00	602	27346	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	602	13673	0.00
Streams AQ: waiting for messages in the queue	120	100.00	586	4883	0.00
class slave wait	2	0.00	0	2	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
db file sequential read	96	0.00	2	22	0.00
log file parallel write	64,767	0.00	2	0	2.02
control file parallel write	296	0.00	1	3	0.01
control file sequential read	141	0.00	0	2	0.00
db file parallel write	7,552	0.00	0	0	0.24
events in waitclass Other	466	0.00	0	0	0.01
os thread startup	2	0.00	0	55	0.00
buffer busy waits	2	0.00	0	15	0.00
log file single write	2	0.00	0	6	0.00
log file sequential read	2	0.00	0	4	0.00
direct path write	2	0.00	0	0	0.00
direct path read	4	0.00	0	0	0.00
rdbms ipc message	66,266	2.69	5,325	80	2.07
Streams AQ: qmn slave idle wait	22	0.00	602	27346	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	602	13673	0.00
smon timer	15	0.00	589	39298	0.00
pmon timer	219	100.00	589	2689	0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	52,637
IDLE_TIME	187,080
IOWAIT_TIME	107,128
NICE_TIME	0
SYS_TIME	20,793
USER_TIME	29,917
LOAD	10
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,880
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,663.70	402.30	185,798	4,385,936
SYS$USERS	23.20	15.50	259	17,701
SYS$BACKGROUND	0.00	0.00	1,167	40,741

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	185801	462824	1115	377	74855	70
SYS$USERS	257	687	1	0	1243	3
SYS$BACKGROUND	1142	2830	4	14	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,098	113	32,573	0.10	54.70	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
2,351	34	32,551	0.07	41.51	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
1,973	161	32,286	0.06	34.84	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
1,093	129	19,260	0.06	19.29	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
586	67	32,550	0.02	10.35	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
457	19	32,310	0.01	8.06	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
368	80	3,176	0.12	6.50	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
365	77	3,175	0.12	6.45	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
230	25	13,032	0.02	4.07	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
136	11	3,181	0.04	2.40	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
106	12	1,901	0.06	1.88	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...
106	13	32,551	0.00	1.87	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
58	8	32,301	0.00	1.02	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...

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
161	1,973	32,286	0.00	34.84	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
129	1,093	19,260	0.01	19.29	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
113	3,098	32,573	0.00	54.70	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
80	368	3,176	0.03	6.50	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
77	365	3,175	0.02	6.45	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
67	586	32,550	0.00	10.35	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
34	2,351	32,551	0.00	41.51	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
25	230	13,032	0.00	4.07	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
19	457	32,310	0.00	8.06	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
13	106	32,551	0.00	1.87	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
12	106	1,901	0.01	1.88	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...
11	136	3,181	0.00	2.40	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
8	58	32,301	0.00	1.02	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...

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: 4,438,049
Captured SQL account for 90.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,920,269	3,176	604.62	43.27	79.57	368.05	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
1,913,758	3,175	602.76	43.12	76.79	365.16	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
1,076,949	32,286	33.36	24.27	160.61	1973.20	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
920,448	32,573	28.26	20.74	113.16	3097.57	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
321,544	19,260	16.69	7.25	129.17	1092.64	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
292,941	32,551	9.00	6.60	34.24	2350.93	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
228,079	32,550	7.01	5.14	7.42	7.69	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
200,192	32,550	6.15	4.51	67.09	586.42	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
146,294	32,310	4.53	3.30	19.16	456.56	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
133,450	32,551	4.10	3.01	13.17	105.98	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
73,927	32,309	2.29	1.67	5.94	6.82	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
67,042	21,175	3.17	1.51	9.71	33.14	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
66,662	32,301	2.06	1.50	7.79	57.75	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
65,136	32,566	2.00	1.47	5.74	6.85	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
65,106	16,197	4.02	1.47	4.31	4.47	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
64,792	16,198	4.00	1.46	3.61	3.62	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
64,622	32,311	2.00	1.46	7.17	7.18	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
64,550	32,275	2.00	1.45	6.24	6.24	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
64,368	16,092	4.00	1.45	4.50	4.52	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
53,204	3,181	16.73	1.20	10.50	136.10	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
52,124	13,032	4.00	1.17	25.42	230.23	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 186,609
Captured SQL account for 100.1% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
108,233	32,573	3.32	58.00	113.16	3097.57	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
81,467	32,551	2.50	43.66	34.24	2350.93	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
65,360	32,286	2.02	35.03	160.61	1973.20	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
53,650	19,260	2.79	28.75	129.17	1092.64	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
26,682	32,550	0.82	14.30	67.09	586.42	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
10,662	13,032	0.82	5.71	25.42	230.23	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
6,371	3,175	2.01	3.41	76.79	365.16	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
6,371	3,176	2.01	3.41	79.57	368.05	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
6,327	3,181	1.99	3.39	10.50	136.10	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
5,231	1,901	2.75	2.80	12.49	106.34	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: 527,918
Captured SQL account for 100.4% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
32,573	0	0.00	0.00	0.10	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
32,566	32,566	1.00	0.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
32,551	32,549	1.00	0.00	0.07	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
32,551	32,551	1.00	0.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
32,550	32,552	1.00	0.00	0.02	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
32,550	32,550	1.00	0.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
32,311	32,311	1.00	0.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
32,310	32,311	1.00	0.00	0.01	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
32,309	32,309	1.00	0.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
32,301	32,301	1.00	0.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
32,286	32,287	1.00	0.00	0.06	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
32,275	32,275	1.00	0.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
21,175	21,175	1.00	0.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
19,260	140,534	7.30	0.01	0.06	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
16,198	16,198	1.00	0.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
16,197	16,198	1.00	0.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
16,092	16,092	1.00	0.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
13,032	13,031	1.00	0.00	0.02	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: 113,098
Captured SQL account for 99.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
32,574	32,573	28.80	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
32,551	32,551	28.78	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
32,288	32,286	28.55	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
3,316	3,316	2.93	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
3,181	3,181	2.81	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
3,175	3,176	2.81	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
411	411	0.36	2ym6hhaq30r73		select type#, blocks, extents,...
266	266	0.24	asvzxj61dc5vs		select timestamp, flags from ...
204	572	0.18	3c1kubcdjnppq		update sys.col_usage$ set eq...
164	164	0.15	8swypbbr0m372		select order#, columns, types ...

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

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

3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln

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 )

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

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

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

asvzxj61dc5vs select timestamp, flags from fixed_obj$ where obj#=:1

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;

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

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
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
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
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 )
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
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
95yr4xtfr50hx	UPDATE CUSTOMER SET C_BALANCE = :B4 WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
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;
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
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	43,027	71.53	1.34
CPU used when call started	42,914	71.34	1.34
CR blocks created	10,461	17.39	0.33
Cached Commit SCN referenced	2,944	4.89	0.09
Commit SCN cached	1	0.00	0.00
DB time	639,807	1,063.63	19.94
DBWR checkpoint buffers written	8,239	13.70	0.26
DBWR checkpoints	1	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	43	0.07	0.00
DBWR undo block writes	32,920	54.73	1.03
DFO trees parallelized	0	0.00	0.00
IMU CR rollbacks	18,170	30.21	0.57
IMU Flushes	46,992	78.12	1.46
IMU Redo allocation size	114,357,720	190,110.15	3,564.43
IMU commits	16,072	26.72	0.50
IMU contention	35,302	58.69	1.10
IMU pool not allocated	1,472	2.45	0.05
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	165,402,828	274,968.38	5,155.47
IMU- failed to get a private strand	1,472	2.45	0.05
OS Involuntary context switches	37,609	62.52	1.17
OS Page faults	44	0.07	0.00
OS Page reclaims	1,515,719	2,519.76	47.24
OS System time used	20,339	33.81	0.63
OS User time used	28,519	47.41	0.89
OS Voluntary context switches	527,315	876.62	16.44
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
SMON posted for undo segment shrink	12	0.02	0.00
SQL*Net roundtrips to/from client	75,468	125.46	2.35
active txn count during cleanout	26,272	43.68	0.82
application wait time	61,849	102.82	1.93
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	1	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	1,909	3.17	0.06
branch node splits	0	0.00	0.00
buffer is not pinned count	2,144,096	3,564.38	66.83
buffer is pinned count	695,608	1,156.39	21.68
bytes received via SQL*Net from client	84,970,259	141,255.95	2,648.45
bytes sent via SQL*Net to client	33,558,126	55,787.58	1,045.98
calls to get snapshot scn: kcmgss	424,431	705.58	13.23
calls to kcmgas	76,530	127.22	2.39
calls to kcmgcs	15,864	26.37	0.49
change write time	1,292	2.15	0.04
cleanout - number of ktugct calls	20,299	33.75	0.63
cleanouts and rollbacks - consistent read gets	8,527	14.18	0.27
cleanouts only - consistent read gets	10	0.02	0.00
cluster key scan block gets	2,269	3.77	0.07
cluster key scans	1,676	2.79	0.05
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	32,332	53.75	1.01
commit batch/immediate requested	32,332	53.75	1.01
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	1	0.00	0.00
commit cleanout failures: callback failure	734	1.22	0.02
commit cleanout failures: cannot pin	1,559	2.59	0.05
commit cleanouts	129,168	214.73	4.03
commit cleanouts successfully completed	126,874	210.92	3.95
commit immediate performed	32,332	53.75	1.01
commit immediate requested	32,332	53.75	1.01
commit txn count during cleanout	2,367	3.93	0.07
concurrency wait time	392	0.65	0.01
consistent changes	23,343	38.81	0.73
consistent gets	3,326,741	5,530.43	103.69
consistent gets - examination	2,784,498	4,629.00	86.79
consistent gets direct	0	0.00	0.00
consistent gets from cache	3,326,741	5,530.43	103.69
current blocks converted for CR	0	0.00	0.00
cursor authentications	158	0.26	0.00
data blocks consistent reads - undo records applied	18,760	31.19	0.58
db block changes	1,050,140	1,745.77	32.73
db block gets	1,111,308	1,847.46	34.64
db block gets direct	37	0.06	0.00
db block gets from cache	1,111,271	1,847.40	34.64
deferred (CURRENT) block cleanout applications	90,307	150.13	2.81
dirty buffers inspected	25,791	42.88	0.80
doubling up with imu segment	0	0.00	0.00
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	137	0.23	0.00
enqueue releases	308,489	512.84	9.62
enqueue requests	308,491	512.84	9.62
enqueue timeouts	0	0.00	0.00
enqueue waits	11,280	18.75	0.35
exchange deadlocks	0	0.00	0.00
execute count	527,918	877.62	16.45
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	223,770	372.00	6.97
free buffer requested	232,475	386.47	7.25
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	1,003	1.67	0.03
hot buffers moved to head of LRU	72,296	120.19	2.25
immediate (CR) block cleanout applications	8,537	14.19	0.27
immediate (CURRENT) block cleanout applications	141	0.23	0.00
index fast full scans (full)	0	0.00	0.00
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	921,074	1,531.21	28.71
index scans kdiixs1	91,585	152.25	2.85
leaf node 90-10 splits	57	0.09	0.00
leaf node splits	67	0.11	0.00
lob reads	158	0.26	0.00
lob writes	146	0.24	0.00
lob writes unaligned	146	0.24	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	80	0.13	0.00
messages received	72,186	120.00	2.25
messages sent	72,186	120.00	2.25
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	442,247	735.20	13.78
opened cursors cumulative	86,277	143.43	2.69
parse count (failures)	0	0.00	0.00
parse count (hard)	638	1.06	0.02
parse count (total)	113,098	188.02	3.53
parse time cpu	1,458	2.42	0.05
parse time elapsed	2,896	4.81	0.09
physical read IO requests	186,569	310.16	5.82
physical read bytes	764,350,464	1,270,668.76	23,824.16
physical read total IO requests	187,440	311.60	5.84
physical read total bytes	778,540,032	1,294,257.73	24,266.43
physical read total multi block requests	5	0.01	0.00
physical reads	186,609	310.22	5.82
physical reads cache	186,605	310.22	5.82
physical reads cache prefetch	40	0.07	0.00
physical reads direct	4	0.01	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 IO requests	29,454	48.96	0.92
physical write bytes	268,931,072	447,075.43	8,382.35
physical write total IO requests	95,367	158.54	2.97
physical write total bytes	436,121,088	725,014.86	13,593.53
physical write total multi block requests	64,827	107.77	2.02
physical writes	65,657	109.15	2.05
physical writes direct	41	0.07	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	65,616	109.08	2.05
physical writes non checkpoint	61,632	102.46	1.92
pinned buffers inspected	1	0.00	0.00
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	598	0.99	0.02
queries parallelized	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	931,220	1,548.08	29.03
recursive cpu usage	31,990	53.18	1.00
redo blocks read for recovery	0	0.00	0.00
redo blocks written	298,221	495.77	9.30
redo buffer allocation retries	6	0.01	0.00
redo entries	325,356	540.88	10.14
redo log space requests	7	0.01	0.00
redo log space wait time	39	0.06	0.00
redo ordering marks	1,215	2.02	0.04
redo size	133,769,004	222,379.79	4,169.47
redo synch time	4,100	6.82	0.13
redo synch writes	77,511	128.86	2.42
redo wastage	14,083,680	23,412.94	438.98
redo write time	5,635	9.37	0.18
redo writer latching time	7	0.01	0.00
redo writes	64,558	107.32	2.01
rollback changes - undo records applied	161,660	268.75	5.04
rollbacks only - consistent read gets	1,962	3.26	0.06
rows fetched via callback	787,964	1,309.92	24.56
session connect time	0	0.00	0.00
session cursor cache hits	81,683	135.79	2.55
session logical reads	4,438,049	7,377.89	138.33
session pga memory	524,288	871.58	16.34
session pga memory max	262,144	435.79	8.17
session uga memory	2,376,540	3,950.80	74.07
session uga memory max	36,415,880	60,538.36	1,135.05
shared hash latch upgrades - no wait	134,397	223.42	4.19
shared hash latch upgrades - wait	5	0.01	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	5,624	9.35	0.18
sorts (rows)	64,023	106.43	2.00
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	238	0.40	0.01
sql area purged	0	0.00	0.00
steps of tune down ret. in space pressure	0	0.00	0.00
summed dirty queue length	55,393	92.09	1.73
switch current to new buffer	34	0.06	0.00
table fetch by rowid	1,039,199	1,727.58	32.39
table fetch continued row	401	0.67	0.01
table scan blocks gotten	14,010	23.29	0.44
table scan rows gotten	30,557	50.80	0.95
table scans (cache partitions)	0	0.00	0.00
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	218	0.36	0.01
total number of times SMON posted	13	0.02	0.00
transaction rollbacks	32,332	53.75	1.01
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	35,491,344	59,001.39	1,106.24
user I/O wait time	464,006	771.37	14.46
user calls	149,706	248.87	4.67
user commits	32,083	53.34	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	4,766	7.92	0.15
write clones created in background	0	0.00	0.00
write clones created in foreground	13	0.02	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	18,597	19,573
opened cursors current	403	433
logons current	30	30

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	1	5.98

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	185,845	309	24.90	1.00	27,989	47	981	3.39
UNDOTBS1	1	0	80.00	1.00	1,230	2	44	1.59
SYSAUX	916	2	24.55	1.04	277	0	0	0.00
SYSTEM	480	1	27.85	1.00	18	0	0	0.00
TEMP	1	0	230.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	916	2	24.55	1.04	277	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	480	1	27.85	1.00	18	0	0	0.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	1	0	230.00	1.00	0	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	1	0	80.00	1.00	1,230	2	44	1.59
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	185,845	309	24.90	1.00	27,989	47	981	3.39

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	175,966	96	4,447,342	186,870	65,391	0	0	1,034

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	30	20619	156953	917876	2027520	917876
E	0	30	20204	152827	910656	2027520	910656

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	72	0.10	17,604	1.63	16,153,036
D	144	0.20	35,208	1.46	14,427,764
D	216	0.30	52,812	1.38	13,658,627
D	288	0.40	70,416	1.32	13,073,989
D	360	0.50	88,020	1.27	12,624,613
D	432	0.60	105,624	1.24	12,261,264
D	504	0.70	123,228	1.18	11,704,972
D	576	0.80	140,832	1.08	10,742,555
D	648	0.90	158,436	1.03	10,220,812
D	720	1.00	176,040	1.00	9,905,253
D	792	1.10	193,644	0.97	9,635,457
D	864	1.20	211,248	0.95	9,371,485
D	936	1.30	228,852	0.92	9,131,793
D	1,008	1.40	246,456	0.90	8,923,690
D	1,080	1.50	264,060	0.88	8,738,597
D	1,152	1.60	281,664	0.86	8,552,815
D	1,224	1.70	299,268	0.85	8,389,868
D	1,296	1.80	316,872	0.83	8,222,786
D	1,368	1.90	334,476	0.82	8,074,214
D	1,440	2.00	352,080	0.80	7,934,331

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	159	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	274	203	103.96	0.00	0.00	0.00	0.00	56,115
E	274	203	104.52	0.00	0.00	0.00	0.00	56,115

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	4,558	4,558
64K	128K	3	3
256K	512K	4	4
512K	1024K	200	200

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
34	0.13	2,630.70	1,498.44	64.00	87
69	0.25	2,630.70	508.70	84.00	0
137	0.50	2,630.70	134.64	95.00	0
206	0.75	2,630.70	55.43	98.00	0
274	1.00	2,630.70	0.00	100.00	0
329	1.20	2,630.70	0.00	100.00	0
384	1.40	2,630.70	0.00	100.00	0
438	1.60	2,630.70	0.00	100.00	0
493	1.80	2,630.70	0.00	100.00	0
548	2.00	2,630.70	0.00	100.00	0
822	3.00	2,630.70	0.00	100.00	0
1,096	4.00	2,630.70	0.00	100.00	0
1,644	6.00	2,630.70	0.00	100.00	0
2,192	8.00	2,630.70	0.00	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.73	14	1,401	210,782	0.75	70,283	79.96	4,541,841
76	0.86	23	2,153	251,625	0.90	29,440	33.49	4,569,866
88	1.00	34	2,967	280,186	1.00	879	1.00	4,583,436
100	1.14	45	3,830	294,085	1.05	1	0.00	4,589,081
112	1.27	57	4,471	298,341	1.06	1	0.00	4,591,337
124	1.41	69	5,189	298,532	1.07	1	0.00	4,592,532
136	1.55	80	5,759	298,597	1.07	1	0.00	4,593,458
148	1.68	92	6,322	298,610	1.07	1	0.00	4,593,796
160	1.82	103	6,932	298,613	1.07	1	0.00	4,593,899
172	1.95	114	7,586	298,623	1.07	1	0.00	4,594,017
184	2.09	125	8,580	298,623	1.07	1	0.00	4,594,060

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
206	0.25	341,374	16,148,476
412	0.50	256,586	13,070,690
618	0.75	218,884	11,702,125
824	1.00	169,304	9,902,788
1,030	1.25	148,013	9,129,380
1,236	1.50	132,084	8,551,057
1,442	1.75	118,913	8,072,753
1,648	2.00	115,071	7,933,123

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	966	3	3
2nd level bmb	7	0	14
undo header	39	0	2
1st level bmb	14	0	0
undo block	5	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)	11,300	11,299	11,297	610	53.96
HW-Segment High Water Mark	110	110	6	0	58.33
FB-Format Block	138	138	4	0	5.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	33.24	65,406	0	11	29.1666666666666666666666666666666666667/29.166666666666666666666666666666666666	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
20-Apr 14:57	33,244	65,406	0	11	29	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AWR Alerted Metric Element list	2,125	0.00		0
Consistent RBA	64,782	0.01	0.00	0
FOB s.o list latch	338	0.00		0
In memory undo latch	647,143	0.10	0.04	64,867	0.00
JS queue state obj latch	3,600	0.00		0
KMG MMAN ready and startup request latch	201	0.00		0
KTF sga latch	2	0.00		202	0.00
KWQMN job cache list latch	1	0.00		0
MQL Tracking Latch	0			12	0.00
Memory Management Latch	0			201	0.00
OS process	255	0.00		0
OS process allocation	371	0.00		0
OS process: request allocation	162	0.00		0
PL/SQL warning settings	74,406	0.07	0.00	0
SGA IO buffer pool latch	31	0.00		31	0.00
SQL memory manager latch	1	0.00		200	0.00
SQL memory manager workarea list latch	14,729	0.00		0
Shared B-Tree	23	0.00		0
active checkpoint queue latch	7,751	0.00		0
active service list	1,968	0.00		219	0.00
archive control	2	0.00		0
begin backup scn array	1	0.00		0
cache buffer handles	3,016	0.00		0
cache buffers chains	9,467,447	0.03	0.01	230,925	0.02
cache buffers lru chain	197,831	0.08	0.02	243,324	0.46
cache table scan latch	0			5	0.00
channel handle pool latch	164	0.00		0
channel operations parent latch	3,397	0.00		0
checkpoint queue latch	125,517	0.00	0.00	62,131	0.01
client/application info	422	0.00		0
compile environment latch	77,713	0.03	0.00	0
dml lock allocation	454,702	0.37	0.02	0
dummy allocation	162	0.00		0
enqueue hash chains	630,401	0.25	0.02	3,089	0.06
enqueues	111,610	0.04	0.00	0
event group latch	81	0.00		0
file cache latch	147	0.00		0
global KZLD latch for mem in SGA	79	0.00		0
hash table column usage latch	225	0.00		15,015	0.00
hash table modification latch	1	0.00		0
job_queue_processes parameter latch	10	0.00		0
kks stats	1,801	0.00		0
ksuosstats global area	42	0.00		0
ktm global data	43	0.00		0
kwqbsn:qsga	23	0.00		0
lgwr LWN SCN	64,777	0.00		0
library cache	630,156	0.13	0.02	3,320	0.15
library cache load lock	3,218	0.00		0
library cache lock	161,026	0.01	0.00	0
library cache lock allocation	1,579	0.00		0
library cache pin	302,708	0.15	0.01	0
library cache pin allocation	506	0.00		0
list of block allocation	184	0.00		0
loader state object freelist	14	0.00		0
message pool operations parent latch	2	0.00		0
messages	216,675	0.02	0.12	0
mostly latch-free SCN	64,839	0.02	0.00	0
multiblock read objects	48	0.00		0
ncodef allocation latch	11	0.00		0
object queue header heap	15,676	0.00		203	0.00
object queue header operation	657,945	0.02	0.03	0
object stats modification	1	0.00		0
parallel query alloc buffer	80	0.00		0
parameter list	280	0.00		0
parameter table allocation management	81	0.00		0
post/wait queue	50,730	0.01	0.00	32,441	0.06
process allocation	162	0.00		81	0.00
process group creation	162	0.00		0
qmn task queue latch	88	0.00		0
redo allocation	323,553	0.05	0.20	325,979	0.23
redo copy	0			326,290	0.18
redo writing	202,977	0.00	0.00	0
resmgr group change latch	84	0.00		0
resmgr:actses active list	159	0.00		0
resmgr:actses change group	79	0.00		0
resmgr:free threads list	158	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	570,108	0.07	0.00	2,264	0.09
sequence cache	608	0.00		0
session allocation	396,918	0.08	0.02	0
session idle bit	377,974	0.01	0.00	0
session state list latch	166	0.00		0
session switching	11	0.00		0
session timer	218	0.00		0
shared pool	68,238	0.10	0.00	0
shared pool sim alloc	1	0.00		0
shared pool simulator	66,009	0.00		0
simulator hash latch	449,056	0.00	0.00	0
simulator lru latch	418,808	0.14	0.04	13,764	0.00
slave class	2	0.00		0
slave class create	8	12.50	1.00	0
sort extent pool	35	0.00		0
state object free list	2	0.00		0
statistics aggregation	112	0.00		0
temp lob duration state obj allocation	2	0.00		0
threshold alerts latch	36	0.00		0
transaction allocation	160	0.00		0
transaction branch allocation	11	0.00		0
undo global data	453,553	0.06	0.00	0
user lock	316	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	9,467,447	3,145	22	3,123
dml lock allocation	454,702	1,660	31	1,629
enqueue hash chains	630,401	1,592	36	1,556
library cache	630,156	819	16	803
In memory undo latch	647,143	649	26	623
simulator lru latch	418,808	571	21	550
library cache pin	302,708	453	4	449
session allocation	396,918	330	7	323
undo global data	453,553	268	1	267
redo allocation	323,553	168	34	134
cache buffers lru chain	197,831	166	3	163
object queue header operation	657,945	148	4	144
messages	216,675	41	5	36
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	17	23
In memory undo latch	kticmt: child	4	1
In memory undo latch	ktichg: child	3	1
In memory undo latch	ktiTxnPoolFree	2	0
cache buffers chains	kcbgtcr: fast path	18	22
cache buffers chains	kcbgcur: kslbegin	11	16
cache buffers chains	kcbgtcr: kslbegin excl	8	0
cache buffers chains	kcbgtcr: kslbegin shared	6	0
cache buffers chains	kcbchg: kslbegin: bufs not pinned	4	10
cache buffers chains	kcbnlc	3	1
cache buffers chains	kcbzgb: scan from tail. nowait	3	0
cache buffers chains	kcbrls: kslbegin	1	0
cache buffers lru chain	kcbzgws	3	2
dml lock allocation	ktaiam	19	22
dml lock allocation	ktaidm	10	7
enqueue hash chains	ksqgtl3	19	21
enqueue hash chains	ksqrcl	17	15
library cache	kglpndl: child: after processing	5	0
library cache	kglpnp: child	5	7
library cache	kgldte: child 0	1	4
library cache	kglic	1	0
library cache	kglini: child	1	0
library cache	kglobld	1	1
library cache	kglobpn: child:	1	0
library cache	kglpndl: child: before processing	1	5
library cache pin	kglpnp: child	3	3
library cache pin	kglpndl	1	1
messages	ksaamb: after wakeup	5	0
object queue header operation	kcbo_switch_cq	2	2
object queue header operation	kcbw_link_q	1	0
object queue header operation	kcbw_unlink_q	1	2
redo allocation	kcrfw_redo_gen: redo allocation 1	34	0
session allocation	ksucri	2	4
session allocation	ksuxds: not user session	2	1
session allocation	ksudlc	1	2
session allocation	ksufap: active sessions	1	0
session allocation	ksuprc	1	0
shared pool	kghfrunp: clatch: nowait	1	0
simulator lru latch	kcbs_simulate: simulate set	20	20
simulator lru latch	kcbs_simbufseq	1	1
slave class create	ksvcreate	1	0
undo global data	ktudba: KSLBEGIN	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

only latches with sleeps are shown
ordered by name

Latch Name	Get Requests	Misses	Sleeps	Spin & Sleeps 1->3+
dml lock allocation	453,916	1,654	31	1623/0/0/0
messages	216,245	41	5	36/0/0/0
session allocation	397,746	329	7	322/0/0/0
slave class create	8	1	1	0/0/0/0

Back to Latch Statistics
Back to Top

Child Latch Statistics

only latches with sleeps/gets > 1/100000 are shown
ordered by name, gets desc

Latch Name	Child Num	Get Requests	Misses	Sleeps	Spin & Sleeps 1->3+
In memory undo latch	6	70,153	71	5	66/0/0/0
In memory undo latch	3	67,066	54	1	53/0/0/0
In memory undo latch	4	66,657	61	2	59/0/0/0
In memory undo latch	10	65,989	59	4	55/0/0/0
In memory undo latch	2	65,461	75	6	69/0/0/0
In memory undo latch	5	65,204	58	2	56/0/0/0
In memory undo latch	7	63,466	64	1	63/0/0/0
In memory undo latch	8	60,442	91	2	89/0/0/0
In memory undo latch	1	59,932	59	3	56/0/0/0
cache buffers chains	1237	423,575	1,314	12	1302/0/0/0
cache buffers chains	128	61,692	15	1	14/0/0/0
cache buffers chains	72	43,979	2	1	1/0/0/0
cache buffers chains	910	36,078	65	2	63/0/0/0
cache buffers chains	242	23,713	7	2	5/0/0/0
cache buffers chains	1508	23,256	16	1	15/0/0/0
cache buffers chains	465	2,684	2	1	1/0/0/0
cache buffers chains	474	2,067	1	1	0/0/0/0
cache buffers chains	1348	1,869	1	1	0/0/0/0
cache buffers lru chain	6	98,944	89	1	88/0/0/0
cache buffers lru chain	5	98,887	77	2	75/0/0/0
enqueue hash chains	1	175,111	524	10	514/0/0/0
enqueue hash chains	2	174,625	466	20	446/0/0/0
enqueue hash chains	3	173,519	348	5	343/0/0/0
library cache	4	280,266	417	13	404/0/0/0
library cache	5	96,017	79	4	75/0/0/0
library cache pin	2	72,979	117	3	114/0/0/0
library cache pin	3	67,989	66	1	65/0/0/0
redo allocation	1	129,433	164	33	131/0/0/0
redo allocation	2	65,655	4	1	3/0/0/0
simulator lru latch	6	240,772	409	19	390/0/0/0
simulator lru latch	5	178,146	162	2	160/0/0/0
undo global data	1	89,813	42	1	41/0/0/0

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: 4,438,049
Captured Segments account for 84.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	1,242,704	28.00
TPCC	USERS	STOCK	TABLE	619,088	13.95
TPCC	USERS	CUSTOMER_I1	INDEX	283,248	6.38
TPCC	USERS	CUSTOMER_I2	INDEX	266,304	6.00
TPCC	USERS	CUSTOMER	TABLE	247,808	5.58

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 186,609
Captured Segments account for 100.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	CUSTOMER		TABLE	96,784	51.86
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	57,965	31.06
TPCC	USERS	ITEM		TABLE	23,211	12.44
TPCC	USERS	STOCK		TABLE	6,066	3.25
TPCC	USERS	CUSTOMER_I2		INDEX	647	0.35

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	WAREHOUSE	TABLE	17,296	76.63
TPCC	USERS	DISTRICT	TABLE	5,274	23.37
SYS	SYSTEM	SMON_SCN_TIME	TABLE	2	0.01

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	INORD	INDEX	766	78.97
TPCC	USERS	HISTORY	TABLE	73	7.53
TPCC	USERS	WAREHOUSE	TABLE	59	6.08
TPCC	USERS	ORDERS	TABLE	44	4.54
TPCC	USERS	DISTRICT	TABLE	28	2.89

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	14.29	2	1
dc_global_oids	61	31.15	0	0
dc_histogram_data	810	31.11	0	74
dc_histogram_defs	7,507	39.66	0	927
dc_object_grants	50	24.00	0	5
dc_object_ids	4,721	9.62	0	284
dc_objects	2,463	21.03	0	265
dc_profiles	79	1.27	0	1
dc_rollback_segments	172	0.00	0	24
dc_segments	1,788	23.15	7	100
dc_sequences	19	36.84	19	1
dc_tablespaces	166,661	0.00	0	5
dc_usernames	304	2.63	0	2
dc_users	5,064	0.28	0	15
outstanding_alerts	12	83.33	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	10	20.00	35,694	0.02	6	0
CLUSTER	21	0.00	84	4.76	4	0
INDEX	38	86.84	102	35.29	3	0
SQL AREA	576	73.26	607,337	0.28	163	2
TABLE/PROCEDURE	1,373	24.76	115,842	1.31	451	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	87.21		2.91	7.77	32	33	30	30
	Freeable	13.44	0.00	1.12	0.64	3		12	12
	SQL	1.95	0.96	0.08	0.04	0	8	24	23
	PL/SQL	1.37	0.75	0.05	0.05	0	0	30	30
E	Other	86.89		3.00	7.89	32	33	29	29
	Freeable	13.44	0.00	1.12	0.64	3		12	12
	SQL	1.90	0.92	0.08	0.04	0	8	23	22
	PL/SQL	1.33	0.70	0.05	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	754,974,720
Fixed Size	1,263,716
Redo Buffers	7,122,944
Variable Size	100,665,244

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	11.71	11.71	0.00
shared	KGLS heap	1.13	1.21	7.16
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KTI-UNDO	2.36	2.36	0.00
shared	db_block_hash_buckets	4.25	4.25	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	22.49	22.44	-0.19
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	library cache	3.21	3.19	-0.64
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.33	2.33	0.16
	buffer_cache	720.00	720.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	/u01/app/oracle/admin/TESTIBM/adump
background_dump_dest	/u01/app/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, /u02/app/oracle/oradata/TESTIBM/control03.ctl
core_dump_dest	/u01/app/oracle/admin/TESTIBM/cdump
db_block_size	4096
db_domain
db_file_multiblock_read_count	16
db_name	TESTIBM
filesystemio_options	asynch
job_queue_processes	10
open_cursors	300
pga_aggregate_target	287309824
processes	300
remote_login_passwordfile	EXCLUSIVE
sessions	335
sga_target	864026624
statistics_level	ALL
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/u01/app/oracle/admin/TESTIBM/udump

End of Report

% Blocks changed per Read:	23.66	Recursive Call %:	86.15
Rollback per transaction %:	0.00	Rows per Sort:	11.38

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	95.80	In-memory Sort %:	100.00
Library Hit %:	99.57	Soft Parse %:	99.44
Execute to Parse %:	78.58	Latch Hit %:	99.94
Parse CPU to Parse Elapsd %:	50.35	% Non-Parse CPU:	96.51