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: 49 20-Apr-06 15:10:36 30 14.4

End Snap: 50 20-Apr-06 15:20:37 30 14.5

Elapsed: 10.01 (mins)

DB Time: 95.54 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	49	20-Apr-06 15:10:36	30	14.4
End Snap:	50	20-Apr-06 15:20:37	30	14.5
Elapsed:		10.01 (mins)
DB Time:		95.54 (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: 158,175.26 4,228.43

Logical reads: 5,488.20 146.71

Block changes: 1,243.37 33.24

Physical reads: 223.40 5.97

Physical writes: 71.15 1.90

User calls: 176.24 4.71

Parses: 135.56 3.62

Hard parses: 1.04 0.03

Sorts: 7.86 0.21

Logons: 0.09 0.00

Executes: 625.54 16.72

Transactions: 37.41

	Per Second	Per Transaction
Redo size:	158,175.26	4,228.43
Logical reads:	5,488.20	146.71
Block changes:	1,243.37	33.24
Physical reads:	223.40	5.97
Physical writes:	71.15	1.90
User calls:	176.24	4.71
Parses:	135.56	3.62
Hard parses:	1.04	0.03
Sorts:	7.86	0.21
Logons:	0.09	0.00
Executes:	625.54	16.72
Transactions:	37.41

% Blocks changed per Read: 22.66 Recursive Call %: 86.90

Rollback per transaction %: 0.00 Rows per Sort: 11.23

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 99.97

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

Library Hit %: 99.42 Soft Parse %: 99.23

Execute to Parse %: 78.33 Latch Hit %: 99.97

Parse CPU to Parse Elapsd %: 43.87 % Non-Parse CPU: 96.86

Shared Pool Statistics

Begin End

Memory Usage %: 74.49 74.52

% SQL with executions>1: 87.15 86.22

% Memory for SQL w/exec>1: 80.01 77.94

	Begin	End
Memory Usage %:	74.49	74.52
% SQL with executions>1:	87.15	86.22
% Memory for SQL w/exec>1:	80.01	77.94

Top 5 Timed Events

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

db file sequential read 134,284 4,922 37 85.9 User I/O

enq: TX - row lock contention 4,971 416 84 7.3 Application

CPU time 393 6.8

log file sync 23,386 34 1 .6 Commit

control file parallel write 277 29 106 .5 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	134,284	4,922	37	85.9	User I/O
enq: TX - row lock contention	4,971	416	84	7.3	Application
CPU time		393		6.8
log file sync	23,386	34	1	.6	Commit
control file parallel write	277	29	106	.5	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): 5732.5s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	5,667.93	98.87
DB CPU	392.55	6.85
PL/SQL execution elapsed time	25.11	0.44
parse time elapsed	14.90	0.26
hard parse elapsed time	8.40	0.15
PL/SQL compilation elapsed time	2.47	0.04
connection management call elapsed time	1.26	0.02
repeated bind elapsed time	0.29	0.01
hard parse (sharing criteria) elapsed time	0.20	0.00
sequence load elapsed time	0.05	0.00
DB time	5,732.49
background elapsed time	715.64
background cpu time	41.04

Back to Wait Events Statistics
Back to Top

Wait Class

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

Wait Class	Waits	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	134,359	4,924	37	5.98
Application	51,039	436	9	2.27
Commit	23,386	34	1	1.04
System I/O	49,286	31	1	2.19
Concurrency	411	2	5	0.02
Configuration	23	2	70	0.00
Network	54,102	0	0	2.41
Other	271	0	1	0.01

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	134,284	0.00	4,922	37	5.97
enq: TX - row lock contention	4,971	0.00	416	84	0.22
log file sync	23,386	0.00	34	1	1.04
control file parallel write	277	0.00	29	106	0.01
SQL*Net break/reset to client	46,068	0.00	20	0	2.05
read by other session	69	0.00	2	26	0.00
buffer busy waits	345	0.00	2	5	0.02
log file switch completion	12	0.00	1	111	0.00
log file parallel write	46,322	0.00	1	0	2.06
SQL*Net message to client	53,675	0.00	0	0	2.39
db file scattered read	4	0.00	0	100	0.00
control file sequential read	845	0.00	0	0	0.04
enq: HW - contention	11	0.00	0	25	0.00
latch free	35	0.00	0	4	0.00
db file parallel write	1,838	0.00	0	0	0.08
os thread startup	2	0.00	0	51	0.00
latch: In memory undo latch	19	0.00	0	5	0.00
latch: cache buffers chains	24	0.00	0	3	0.00
LGWR wait for redo copy	183	0.00	0	0	0.01
latch: enqueue hash chains	25	0.00	0	2	0.00
latch: library cache	14	0.00	0	3	0.00
log file single write	2	0.00	0	15	0.00
SQL*Net more data to client	411	0.00	0	0	0.02
latch: library cache pin	4	0.00	0	4	0.00
log file sequential read	2	0.00	0	6	0.00
enq: FB - contention	5	0.00	0	1	0.00
latch: redo allocation	19	0.00	0	0	0.00
latch: object queue header operation	2	0.00	0	1	0.00
latch: row cache objects	1	0.00	0	1	0.00
cursor: pin S	1	0.00	0	1	0.00
SQL*Net more data from client	16	0.00	0	0	0.00
latch: shared pool	2	0.00	0	0	0.00
latch: session allocation	1	0.00	0	0	0.00
direct path write	2	0.00	0	0	0.00
SQL*Net message from client	53,675	0.00	2,643	49	2.39
Streams AQ: waiting for messages in the queue	120	100.00	586	4883	0.01
Streams AQ: qmn slave idle wait	21	0.00	574	27347	0.00
Streams AQ: qmn coordinator idle wait	42	50.00	574	13673	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
control file parallel write	276	0.00	29	106	0.01
db file sequential read	58	0.00	2	39	0.00
log file parallel write	46,327	0.00	1	0	2.06
db file parallel write	1,837	0.00	0	0	0.08
os thread startup	2	0.00	0	51	0.00
events in waitclass Other	205	0.00	0	0	0.01
log file single write	2	0.00	0	15	0.00
log file sequential read	2	0.00	0	6	0.00
latch: shared pool	1	0.00	0	0	0.00
control file sequential read	127	0.00	-0	-0	0.01
rdbms ipc message	47,782	3.39	4,033	84	2.13
pmon timer	218	100.00	586	2689	0.01
Streams AQ: qmn slave idle wait	21	0.00	574	27347	0.00
Streams AQ: qmn coordinator idle wait	42	50.00	574	13673	0.00
smon timer	2	50.00	414	207146	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	107,283
IDLE_TIME	133,087
IOWAIT_TIME	130,267
NICE_TIME	0
SYS_TIME	82,498
USER_TIME	23,410
LOAD	12
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,164
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,707.90	376.80	132,962	3,234,849
SYS$USERS	20.90	14.70	121	19,138
SYS$BACKGROUND	0.00	0.00	1,149	41,379

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	133064	487746	408	181	52680	44
SYS$USERS	121	487	0	0	1231	2
SYS$BACKGROUND	1109	3827	3	10	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
2,960	74	22,695	0.13	51.64	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
2,157	22	22,643	0.10	37.63	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
2,094	101	22,150	0.09	36.53	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
1,358	38	13,334	0.10	23.69	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
691	23	22,654	0.03	12.06	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
345	11	22,176	0.02	6.01	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
269	116	2,165	0.12	4.70	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
261	7	8,826	0.03	4.55	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
253	54	2,203	0.12	4.42	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
251	52	2,196	0.11	4.38	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
122	4	1,256	0.10	2.13	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...
113	108	2,163	0.05	1.97	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
71	8	22,643	0.00	1.24	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...

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
116	269	2,165	0.05	4.70	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
108	113	2,163	0.05	1.97	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
101	2,094	22,150	0.00	36.53	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
74	2,960	22,695	0.00	51.64	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
54	253	2,203	0.02	4.42	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
52	251	2,196	0.02	4.38	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
38	1,358	13,334	0.00	23.69	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
23	691	22,654	0.00	12.06	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
22	2,157	22,643	0.00	37.63	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
11	345	22,176	0.00	6.01	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
8	71	22,643	0.00	1.24	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
7	261	8,826	0.00	4.55	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
4	122	1,256	0.00	2.13	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, 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: 3,297,537
Captured SQL account for 88.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,355,467	2,203	615.28	41.11	54.48	253.43	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
1,347,114	2,196	613.44	40.85	52.45	251.30	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
736,046	22,150	33.23	22.32	100.71	2093.90	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
640,101	22,695	28.20	19.41	73.84	2960.48	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
223,816	13,334	16.79	6.79	37.50	1358.31	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
203,796	22,643	9.00	6.18	21.80	2157.39	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
158,663	22,643	7.01	4.81	4.90	5.31	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
154,717	2,165	71.46	4.69	115.57	269.36	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
138,471	22,654	6.11	4.20	22.82	691.12	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
126,086	2,163	58.29	3.82	108.27	113.05	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
96,259	22,176	4.34	2.92	10.67	344.66	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
92,449	22,643	4.08	2.80	8.44	71.16	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
49,742	22,172	2.24	1.51	3.87	5.49	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
46,289	14,604	3.17	1.40	6.22	27.64	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
45,332	22,664	2.00	1.37	3.35	3.84	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
45,321	22,169	2.04	1.37	4.71	34.71	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
44,452	11,113	4.00	1.35	2.98	3.27	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
44,374	22,187	2.00	1.35	4.61	4.68	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
44,348	11,041	4.02	1.34	2.70	2.95	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
44,262	22,131	2.00	1.34	3.94	4.04	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
44,172	11,042	4.00	1.34	2.31	2.34	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
35,304	8,826	4.00	1.07	7.48	261.06	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: 134,226
Captured SQL account for 98.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
75,934	22,695	3.35	56.57	73.84	2960.48	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
57,011	22,643	2.52	42.47	21.80	2157.39	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
46,686	22,150	2.11	34.78	100.71	2093.90	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
38,632	13,334	2.90	28.78	37.50	1358.31	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
18,759	22,654	0.83	13.98	22.82	691.12	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
7,333	8,826	0.83	5.46	7.48	261.06	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
4,355	2,203	1.98	3.24	54.48	253.43	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
4,353	2,196	1.98	3.24	52.45	251.30	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
4,344	2,165	2.01	3.24	115.57	269.36	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
3,481	1,256	2.77	2.59	3.54	122.35	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: 375,848
Captured SQL account for 98.2% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
22,695	0	0.00	0.13	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
22,664	22,664	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
22,654	22,655	1.00	0.03	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
22,643	22,645	1.00	0.10	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
22,643	22,643	1.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
22,643	22,643	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
22,187	22,187	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
22,176	22,176	1.00	0.02	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
22,172	22,172	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
22,169	22,169	1.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
22,150	22,151	1.00	0.09	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
22,131	22,131	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
14,604	14,604	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
13,334	97,863	7.34	0.10	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
11,113	11,113	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
11,042	11,043	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
11,041	11,041	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
8,826	8,826	1.00	0.03	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: 81,448
Captured SQL account for 97.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
22,694	22,695	27.86	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
22,643	22,643	27.80	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
22,152	22,150	27.20	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
2,232	2,232	2.74	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
2,202	2,203	2.70	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
2,165	2,165	2.66	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
431	431	0.53	2ym6hhaq30r73		select type#, blocks, extents,...
280	866	0.34	3c1kubcdjnppq		update sys.col_usage$ set eq...
280	4	0.34	53btfq0dt9bs9		insert into sys.col_usage$ val...
236	236	0.29	asvzxj61dc5vs		select timestamp, flags 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

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

53btfq0dt9bs9 insert into sys.col_usage$ values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)

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

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

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
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
53btfq0dt9bs9	insert into sys.col_usage$ values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
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
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
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	41,222	68.61	1.83
CPU used when call started	41,083	68.38	1.83
CR blocks created	6,220	10.35	0.28
Cached Commit SCN referenced	2,726	4.54	0.12
Commit SCN cached	1	0.00	0.00
DB time	647,010	1,076.84	28.79
DBWR checkpoint buffers written	2,057	3.42	0.09
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	14	0.02	0.00
DBWR undo block writes	22,979	38.24	1.02
DFO trees parallelized	0	0.00	0.00
IMU CR rollbacks	11,122	18.51	0.49
IMU Flushes	32,241	53.66	1.43
IMU Redo allocation size	78,797,344	131,145.08	3,505.84
IMU commits	11,945	19.88	0.53
IMU contention	23,753	39.53	1.06
IMU pool not allocated	1,462	2.43	0.07
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	116,537,740	193,957.70	5,184.99
IMU- failed to get a private strand	1,462	2.43	0.07
OS Involuntary context switches	28,023	46.64	1.25
OS Page faults	32	0.05	0.00
OS Page reclaims	1,096,538	1,825.01	48.79
OS System time used	23,301	38.78	1.04
OS User time used	22,128	36.83	0.98
OS Voluntary context switches	381,060	634.21	16.95
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	0	0.00	0.00
SQL*Net roundtrips to/from client	53,496	89.04	2.38
active txn count during cleanout	14,507	24.14	0.65
application wait time	43,675	72.69	1.94
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	1,789	2.98	0.08
branch node splits	1	0.00	0.00
buffer is not pinned count	1,630,571	2,713.81	72.55
buffer is pinned count	13,618,288	22,665.38	605.90
bytes received via SQL*Net from client	59,850,575	99,611.34	2,662.87
bytes sent via SQL*Net to client	23,828,792	39,659.06	1,060.19
calls to get snapshot scn: kcmgss	303,657	505.39	13.51
calls to kcmgas	53,498	89.04	2.38
calls to kcmgcs	9,903	16.48	0.44
change write time	931	1.55	0.04
cleanout - number of ktugct calls	10,051	16.73	0.45
cleanouts and rollbacks - consistent read gets	5,126	8.53	0.23
cleanouts only - consistent read gets	6	0.01	0.00
cluster key scan block gets	2,281	3.80	0.10
cluster key scans	1,713	2.85	0.08
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	23,048	38.36	1.03
commit batch/immediate requested	23,048	38.36	1.03
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	235	0.39	0.01
commit cleanout failures: cannot pin	641	1.07	0.03
commit cleanouts	90,866	151.23	4.04
commit cleanouts successfully completed	89,990	149.77	4.00
commit immediate performed	23,048	38.36	1.03
commit immediate requested	23,048	38.36	1.03
commit txn count during cleanout	949	1.58	0.04
concurrency wait time	194	0.32	0.01
consistent changes	14,614	24.32	0.65
consistent gets	2,512,410	4,181.49	111.78
consistent gets - examination	1,998,774	3,326.63	88.93
consistent gets direct	0	0.00	0.00
consistent gets from cache	2,512,410	4,181.49	111.78
current blocks converted for CR	0	0.00	0.00
cursor authentications	173	0.29	0.01
data blocks consistent reads - undo records applied	11,568	19.25	0.51
db block changes	747,070	1,243.37	33.24
db block gets	785,099	1,306.67	34.93
db block gets direct	39	0.06	0.00
db block gets from cache	785,060	1,306.60	34.93
deferred (CURRENT) block cleanout applications	63,949	106.43	2.85
dirty buffers inspected	17,815	29.65	0.79
doubling up with imu segment	0	0.00	0.00
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	124	0.21	0.01
enqueue releases	217,007	361.17	9.66
enqueue requests	217,008	361.17	9.66
enqueue timeouts	0	0.00	0.00
enqueue waits	4,987	8.30	0.22
exchange deadlocks	0	0.00	0.00
execute count	375,848	625.54	16.72
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	175,474	292.05	7.81
free buffer requested	166,225	276.65	7.40
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	700	1.17	0.03
hot buffers moved to head of LRU	57,231	95.25	2.55
immediate (CR) block cleanout applications	5,132	8.54	0.23
immediate (CURRENT) block cleanout applications	139	0.23	0.01
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	662,493	1,102.61	29.48
index scans kdiixs1	67,004	111.52	2.98
leaf node 90-10 splits	58	0.10	0.00
leaf node splits	67	0.11	0.00
lob reads	166	0.28	0.01
lob writes	149	0.25	0.01
lob writes unaligned	149	0.25	0.01
local undo segment hints helped	0	0.00	0.00
local undo segment hints were stale	0	0.00	0.00
logons cumulative	55	0.09	0.00
messages received	48,139	80.12	2.14
messages sent	48,140	80.12	2.14
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	441,482	734.77	19.64
opened cursors cumulative	63,924	106.39	2.84
parse count (failures)	0	0.00	0.00
parse count (hard)	627	1.04	0.03
parse count (total)	81,448	135.56	3.62
parse time cpu	1,234	2.05	0.05
parse time elapsed	2,813	4.68	0.13
physical read IO requests	134,177	223.32	5.97
physical read bytes	549,793,792	915,040.41	24,461.37
physical read total IO requests	135,028	224.73	6.01
physical read total bytes	563,655,680	938,111.21	25,078.11
physical read total multi block requests	4	0.01	0.00
physical reads	134,226	223.40	5.97
physical reads cache	134,226	223.40	5.97
physical reads cache prefetch	50	0.08	0.00
physical reads direct	0	0.00	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	17,650	29.38	0.79
physical write bytes	175,112,192	291,445.14	7,791.07
physical write total IO requests	64,955	108.11	2.89
physical write total bytes	297,130,496	494,524.34	13,219.90
physical write total multi block requests	46,254	76.98	2.06
physical writes	42,752	71.15	1.90
physical writes direct	39	0.06	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	42,713	71.09	1.90
physical writes non checkpoint	41,103	68.41	1.83
pinned buffers inspected	2	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	597	0.99	0.03
queries parallelized	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	702,158	1,168.63	31.24
recursive cpu usage	33,567	55.87	1.49
redo blocks read for recovery	0	0.00	0.00
redo blocks written	211,822	352.54	9.42
redo buffer allocation retries	59	0.10	0.00
redo entries	226,741	377.37	10.09
redo log space requests	62	0.10	0.00
redo log space wait time	136	0.23	0.01
redo ordering marks	1,198	1.99	0.05
redo size	95,038,184	158,175.26	4,228.43
redo synch time	3,568	5.94	0.16
redo synch writes	54,761	91.14	2.44
redo wastage	9,989,420	16,625.73	444.45
redo write time	4,127	6.87	0.18
redo writer latching time	7	0.01	0.00
redo writes	46,297	77.05	2.06
rollback changes - undo records applied	115,237	191.79	5.13
rollbacks only - consistent read gets	1,102	1.83	0.05
rows fetched via callback	567,029	943.73	25.23
session connect time	0	0.00	0.00
session cursor cache hits	60,158	100.12	2.68
session logical reads	3,297,537	5,488.20	146.71
session pga memory	393,216	654.44	17.49
session uga memory	1,314,856	2,188.36	58.50
session uga memory max	27,960,328	46,535.32	1,244.01
shared hash latch upgrades - no wait	97,067	161.55	4.32
shared hash latch upgrades - wait	4	0.01	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	4,722	7.86	0.21
sorts (rows)	53,026	88.25	2.36
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	240	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	98,525	163.98	4.38
switch current to new buffer	15	0.02	0.00
table fetch by rowid	7,349,095	12,231.35	326.98
table fetch continued row	385	0.64	0.02
table scan blocks gotten	10,228	17.02	0.46
table scan rows gotten	28,109	46.78	1.25
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)	244	0.41	0.01
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	23,048	38.36	1.03
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	25,277,888	42,070.84	1,124.66
user I/O wait time	491,923	818.72	21.89
user calls	105,891	176.24	4.71
user commits	22,476	37.41	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	3,941	6.56	0.18
write clones created in background	0	0.00	0.00
write clones created in foreground	86	0.14	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	20,462	21,176
opened cursors current	432	436
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.99

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	132,974	221	36.66	1.00	16,496	27	408	8.77
SYSAUX	810	1	33.51	1.04	194	0	0	0.00
UNDOTBS1	0	0	0.00	0.00	769	1	12	0.00
SYSTEM	411	1	38.10	1.03	14	0	0	0.00
TEMP	1	0	40.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	810	1	33.51	1.04	194	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	411	1	38.10	1.03	14	0	0	0.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	1	0	40.00	1.00	0	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	0	0			769	1	12	0.00
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	132,974	221	36.66	1.00	16,496	27	408	8.77

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	3,296,831	134,215	42,103	0	0	412

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	33	18271	276153	842012	2027520	842012
E	0	43	21664	477515	763071	2027520	763071

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.64	16,752,764
D	144	0.20	35,208	1.46	14,928,249
D	216	0.30	52,812	1.38	14,113,241
D	288	0.40	70,416	1.32	13,496,569
D	360	0.50	88,020	1.28	13,017,522
D	432	0.60	105,624	1.24	12,627,175
D	504	0.70	123,228	1.18	12,047,764
D	576	0.80	140,832	1.09	11,064,573
D	648	0.90	158,436	1.03	10,524,761
D	720	1.00	176,040	1.00	10,191,192
D	792	1.10	193,644	0.97	9,904,710
D	864	1.20	211,248	0.94	9,626,377
D	936	1.30	228,852	0.92	9,373,846
D	1,008	1.40	246,456	0.90	9,153,602
D	1,080	1.50	264,060	0.88	8,956,915
D	1,152	1.60	281,664	0.86	8,760,998
D	1,224	1.70	299,268	0.84	8,589,044
D	1,296	1.80	316,872	0.83	8,413,643
D	1,368	1.90	334,476	0.81	8,256,623
D	1,440	2.00	352,080	0.80	8,109,240

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	154	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	200	107.97	0.00	0.00	0.00	0.00	56,115
E	274	200	107.79	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	3,740	3,740
64K	128K	3	3
256K	512K	4	4
512K	1024K	195	195

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	3,028.58	1,541.29	66.00	94
69	0.25	3,028.58	508.70	86.00	0
137	0.50	3,028.58	134.64	96.00	0
206	0.75	3,028.58	55.43	98.00	0
274	1.00	3,028.58	0.00	100.00	0
329	1.20	3,028.58	0.00	100.00	0
384	1.40	3,028.58	0.00	100.00	0
438	1.60	3,028.58	0.00	100.00	0
493	1.80	3,028.58	0.00	100.00	0
548	2.00	3,028.58	0.00	100.00	0
822	3.00	3,028.58	0.00	100.00	0
1,096	4.00	3,028.58	0.00	100.00	0
1,644	6.00	3,028.58	0.00	100.00	0
2,192	8.00	3,028.58	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	12	1,326	251,640	0.77	77,351	82.20	4,951,854
76	0.86	23	2,303	297,683	0.91	31,308	33.27	4,981,426
88	1.00	34	3,002	328,050	1.00	941	1.00	4,996,195
100	1.14	46	3,671	341,957	1.04	1	0.00	5,002,165
112	1.27	57	4,412	346,215	1.06	1	0.00	5,004,573
124	1.41	68	5,086	346,406	1.06	1	0.00	5,005,801
136	1.55	80	5,807	346,472	1.06	1	0.00	5,006,780
148	1.68	91	6,285	346,489	1.06	1	0.00	5,007,325
160	1.82	102	6,712	346,493	1.06	1	0.00	5,007,465
172	1.95	113	7,504	346,504	1.06	1	0.00	5,007,601
184	2.09	124	8,420	346,508	1.06	1	0.00	5,007,671

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	364,296	16,749,444
412	0.50	273,272	13,493,910
618	0.75	232,780	12,045,987
824	1.00	180,850	10,189,466
1,030	1.25	158,017	9,372,271
1,236	1.50	140,892	8,759,884
1,442	1.75	126,806	8,255,505
1,648	2.00	122,685	8,107,758

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	380	3	8
2nd level bmb	14	1	39
undo header	9	0	0
1st level bmb	4	0	0
undo block	3	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)	4,967	4,966	4,966	427	85.99
HW-Segment High Water Mark	144	144	9	0	32.22
FB-Format Block	126	126	5	0	2.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	21.46	41,947	0	12	73.5833333333333333333333333333333333333/73.583333333333333333333333333333333333	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 15:17	21,460	41,947	0	12	74	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,150	0.00		0
Consistent RBA	46,345	0.00	0.00	0
FOB s.o list latch	232	0.00		0
In memory undo latch	452,016	0.06	0.07	45,823	0.00
JS queue state obj latch	3,600	0.00		0
KMG MMAN ready and startup request latch	200	0.00		0
KTF sga latch	1	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			200	0.00
OS process	180	0.00		0
OS process allocation	320	0.00		0
OS process: request allocation	112	0.00		0
PL/SQL warning settings	52,405	0.04	0.00	0
SGA IO buffer pool latch	9	0.00		9	0.00
SQL memory manager latch	1	0.00		190	0.00
SQL memory manager workarea list latch	14,217	0.00		0
Shared B-Tree	23	0.00		0
active checkpoint queue latch	1,839	0.00		0
active service list	1,313	0.00		218	0.00
archive control	2	0.00		0
begin backup scn array	1	0.00		0
cache buffer handles	2,734	0.11	0.00	0
cache buffers chains	6,956,093	0.01	0.03	165,853	0.01
cache buffers lru chain	128,557	0.07	0.00	171,878	0.24
cache table scan latch	0			4	0.00
channel handle pool latch	114	0.00		0
channel operations parent latch	2,907	0.00		0
checkpoint queue latch	64,671	0.02	0.00	43,536	0.01
client/application info	282	0.00		0
compile environment latch	54,458	0.02	0.00	0
dml lock allocation	321,283	0.13	0.02	0
dummy allocation	112	0.00		0
enqueue hash chains	439,500	0.12	0.05	2,954	0.07
enqueues	75,253	0.03	0.05	0
event group latch	56	0.00		0
file cache latch	115	0.00		0
global KZLD latch for mem in SGA	54	0.00		0
hash table column usage latch	286	0.00		14,529	0.00
hash table modification latch	1	0.00		0
job_queue_processes parameter latch	10	0.00		0
kks stats	1,696	0.00		0
ksuosstats global area	42	0.00		0
ktm global data	2	0.00		0
kwqbsn:qsga	23	0.00		0
lgwr LWN SCN	46,344	0.00		0
library cache	456,795	0.06	0.05	3,448	0.06
library cache load lock	3,040	0.00		0
library cache lock	119,688	0.02	0.00	0
library cache lock allocation	1,208	0.00		0
library cache pin	216,782	0.05	0.03	0
library cache pin allocation	354	0.00		0
list of block allocation	138	0.00		0
loader state object freelist	2	0.00		0
message pool operations parent latch	2	0.00		0
messages	147,898	0.01	0.00	0
mostly latch-free SCN	46,367	0.01	0.00	0
multiblock read objects	8	0.00		0
ncodef allocation latch	11	0.00		0
object queue header heap	3,802	0.00		142	0.00
object queue header operation	454,997	0.01	0.03	0
object stats modification	1	0.00		0
parallel query alloc buffer	76	0.00		0
parameter list	213	0.00		0
parameter table allocation management	56	0.00		0
post/wait queue	36,342	0.01	1.00	23,435	0.02
process allocation	112	0.00		56	0.00
process group creation	112	0.00		0
qmn task queue latch	88	0.00		0
redo allocation	229,772	0.05	0.18	226,651	0.13
redo copy	0			226,775	0.14
redo writing	141,524	0.00	0.00	0
resmgr group change latch	56	0.00		0
resmgr:actses active list	109	0.00		0
resmgr:actses change group	54	0.00		0
resmgr:free threads list	108	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	428,185	0.05	0.00	2,371	0.25
sequence cache	529	0.00		0
session allocation	355,786	0.12	0.00	0
session idle bit	266,299	0.00	0.00	0
session state list latch	112	0.00		0
session switching	11	0.00		0
session timer	218	0.00		0
shared pool	64,773	0.10	0.03	0
shared pool sim alloc	1	0.00		0
shared pool simulator	69,310	0.00		0
simulator hash latch	312,562	0.00	0.00	0
simulator lru latch	290,680	0.08	0.08	10,040	0.00
slave class	2	0.00		0
slave class create	8	12.50	1.00	0
sort extent pool	22	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	114	0.00		0
transaction branch allocation	11	0.00		0
undo global data	312,050	0.02	0.00	0
user lock	216	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	6,956,093	955	24	931
enqueue hash chains	439,500	540	25	515
dml lock allocation	321,283	426	9	417
session allocation	355,786	416	1	415
library cache	456,795	294	14	280
In memory undo latch	452,016	260	19	241
simulator lru latch	290,680	247	20	227
row cache objects	428,185	226	1	225
library cache pin	216,782	119	4	115
redo allocation	229,772	108	19	89
object queue header operation	454,997	63	2	61
shared pool	64,773	62	2	60
enqueues	75,253	19	1	18
post/wait queue	36,342	3	3	0
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	14	16
In memory undo latch	kticmt: child	3	0
In memory undo latch	ktiTxnPoolFree	2	0
cache buffers chains	kcbgtcr: fast path	11	14
cache buffers chains	kcbchg: kslbegin: bufs not pinned	7	3
cache buffers chains	kcbgtcr: kslbegin excl	6	1
cache buffers chains	kcbgcur: kslbegin	2	7
cache buffers chains	kcbgtcr: kslbegin shared	2	0
cache buffers chains	kcbnlc	2	2
cache buffers chains	kcb_pre_apply: kcbhq61	1	0
cache buffers chains	kcbget: pin buffer	1	0
cache buffers chains	kcbnew: new latch again	1	0
dml lock allocation	ktaiam	7	8
dml lock allocation	ktaidm	2	1
enqueue hash chains	ksqgtl3	13	15
enqueue hash chains	ksqrcl	12	10
enqueues	ksqdel	1	0
library cache	kglpnp: child	6	11
library cache	kglpndl: child: before processing	4	2
library cache	kglpndl: child: after processing	3	0
library cache	kglic	1	0
library cache pin	kglpndl	3	3
library cache pin	kglpnp: child	1	1
object queue header operation	kcbw_link_q	2	0
post/wait queue	ksliwat:add:nowait	3	0
redo allocation	kcrfw_redo_gen: redo allocation 1	20	0
row cache objects	kqreqd: reget	1	0
session allocation	ksudlc	1	0
shared pool	kghalo	1	1
shared pool	kghupr1	1	1
simulator lru latch	kcbs_simulate: simulate set	18	20
simulator lru latch	kcbs_simbufseq	2	0
slave class create	ksvcreate	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	321,015	429	9	420/0/0/0
enqueues	75,226	19	1	18/0/0/0
session allocation	355,722	415	1	414/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	1	46,930	24	3	21/0/0/0
In memory undo latch	3	46,861	26	1	25/0/0/0
In memory undo latch	5	45,754	27	2	25/0/0/0
In memory undo latch	9	44,964	21	1	20/0/0/0
In memory undo latch	6	44,718	30	4	26/0/0/0
In memory undo latch	7	44,264	24	2	22/0/0/0
In memory undo latch	2	43,851	29	1	28/0/0/0
In memory undo latch	4	42,026	28	1	27/0/0/0
In memory undo latch	10	40,868	28	4	24/0/0/0
cache buffers chains	1237	297,880	415	7	408/0/0/0
cache buffers chains	110	69,968	49	1	48/0/0/0
cache buffers chains	128	46,164	6	1	5/0/0/0
cache buffers chains	910	27,269	9	1	8/0/0/0
cache buffers chains	858	17,954	3	1	2/0/0/0
cache buffers chains	383	17,451	3	1	2/0/0/0
cache buffers chains	1069	8,956	1	1	0/0/0/0
cache buffers chains	951	6,205	1	1	0/0/0/0
cache buffers chains	925	4,894	2	1	1/0/0/0
cache buffers chains	498	3,336	1	1	0/0/0/0
cache buffers chains	1021	2,553	2	1	1/0/0/0
cache buffers chains	1562	1,947	1	1	0/0/0/0
cache buffers chains	358	1,936	1	1	0/0/0/0
cache buffers chains	554	1,885	1	1	0/0/0/0
cache buffers chains	619	1,712	1	1	0/0/0/0
cache buffers chains	1941	1,690	1	1	0/0/0/0
cache buffers chains	1254	1,681	1	1	0/0/0/0
enqueue hash chains	1	122,579	185	11	174/0/0/0
enqueue hash chains	2	122,258	140	8	132/0/0/0
enqueue hash chains	3	120,359	150	4	146/0/0/0
enqueue hash chains	4	74,313	67	2	65/0/0/0
library cache	4	201,067	169	7	162/0/0/0
library cache	2	84,261	39	4	35/0/0/0
library cache	3	79,196	47	2	45/0/0/0
library cache	5	69,013	32	1	31/0/0/0
library cache pin	4	98,834	66	1	65/0/0/0
library cache pin	2	52,243	30	3	27/0/0/0
post/wait queue	5	23,940	1	1	0/0/0/0
post/wait queue	4	12,406	2	2	0/0/0/0
redo allocation	1	92,696	108	19	89/0/0/0
shared pool	1	64,767	62	2	60/0/0/0
simulator lru latch	6	164,054	153	16	137/0/0/0
simulator lru latch	5	126,616	94	4	90/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: 3,297,537
Captured Segments account for 85.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	898,944	27.26
TPCC	USERS	STOCK	TABLE	451,680	13.70
TPCC	USERS	CUSTOMER_I1	INDEX	198,784	6.03
TPCC	USERS	CUSTOMER_I2	INDEX	186,112	5.64
TPCC	USERS	CUSTOMER	TABLE	175,920	5.33

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 134,226
Captured Segments account for 99.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	CUSTOMER		TABLE	69,920	52.09
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	41,453	30.88
TPCC	USERS	ITEM		TABLE	16,603	12.37
TPCC	USERS	STOCK		TABLE	3,657	2.72
TPCC	USERS	CUSTOMER_I2		INDEX	564	0.42

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	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
TPCC	USERS	WAREHOUSE		TABLE	7,384	74.59
TPCC	USERS	DISTRICT		TABLE	2,516	25.41

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	266	79.64
TPCC	USERS	HISTORY	TABLE	26	7.78
TPCC	USERS	WAREHOUSE	TABLE	16	4.79
TPCC	USERS	ORDERS	TABLE	15	4.49
TPCC	USERS	DISTRICT	TABLE	10	2.99

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	13	7.69	2	1
dc_global_oids	66	30.30	0	0
dc_histogram_data	888	28.38	0	64
dc_histogram_defs	7,434	39.29	0	941
dc_object_grants	53	28.30	0	8
dc_object_ids	4,955	9.49	0	276
dc_objects	2,454	21.35	0	262
dc_profiles	53	1.89	0	1
dc_rollback_segments	69	0.00	0	24
dc_segments	1,904	22.69	7	112
dc_sequences	17	41.18	17	0
dc_tablespaces	119,898	0.00	0	5
dc_usernames	249	2.41	0	3
dc_users	4,498	0.27	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	7	28.57	25,354	0.04	8	0
CLUSTER	18	0.00	85	3.53	3	0
INDEX	39	82.05	103	36.89	6	0
SQL AREA	686	61.08	432,491	0.38	136	1
TABLE/PROCEDURE	1,285	21.95	83,218	1.73	458	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	90.75		3.03	7.75	32	33	30	30
	Freeable	13.50	0.00	1.13	0.63	3		12	12
	SQL	2.15	1.13	0.09	0.04	0	8	24	23
	PL/SQL	1.58	0.87	0.05	0.06	0	0	30	30
E	Other	91.04		3.03	7.74	32	33	30	30
	Freeable	12.94	0.00	1.08	0.68	3		12	12
	SQL	2.25	1.22	0.09	0.04	0	8	24	23
	PL/SQL	1.58	0.95	0.05	0.06	0	0	30	30

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	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.07	1.17	9.28
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.45	22.42	-0.12
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	library cache	3.20	3.20	-0.01
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.45	2.36	-3.65
	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:	22.66	Recursive Call %:	86.90
Rollback per transaction %:	0.00	Rows per Sort:	11.23

Buffer Nowait %:	99.99	Redo NoWait %:	99.97
Buffer Hit %:	95.93	In-memory Sort %:	100.00
Library Hit %:	99.42	Soft Parse %:	99.23
Execute to Parse %:	78.33	Latch Hit %:	99.97
Parse CPU to Parse Elapsd %:	43.87	% Non-Parse CPU:	96.86