WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

TESTIBM 1448208628 TESTIBM 1 10.2.0.2.0 NO brepredbwh04

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 377 10-Apr-06 14:50:32 30 12.8

End Snap: 378 10-Apr-06 15:00:34 30 12.7

Elapsed: 10.05 (mins)

DB Time: 83.94 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	377	10-Apr-06 14:50:32	30	12.8
End Snap:	378	10-Apr-06 15:00:34	30	12.7
Elapsed:		10.05 (mins)
DB Time:		83.94 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 624,837.94 4,117.95

Logical reads: 20,300.53 133.79

Block changes: 4,938.62 32.55

Physical reads: 310.14 2.04

Physical writes: 214.27 1.41

User calls: 705.11 4.65

Parses: 533.65 3.52

Hard parses: 0.78 0.01

Sorts: 20.79 0.14

Logons: 0.36 0.00

Executes: 2,473.05 16.30

Transactions: 151.74

	Per Second	Per Transaction
Redo size:	624,837.94	4,117.95
Logical reads:	20,300.53	133.79
Block changes:	4,938.62	32.55
Physical reads:	310.14	2.04
Physical writes:	214.27	1.41
User calls:	705.11	4.65
Parses:	533.65	3.52
Hard parses:	0.78	0.01
Sorts:	20.79	0.14
Logons:	0.36	0.00
Executes:	2,473.05	16.30
Transactions:	151.74

% Blocks changed per Read: 24.33 Recursive Call %: 85.08

Rollback per transaction %: 0.00 Rows per Sort: 10.92

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.92 Redo NoWait %: 99.99

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

Library Hit %: 99.89 Soft Parse %: 99.85

Execute to Parse %: 78.42 Latch Hit %: 99.77

Parse CPU to Parse Elapsd %: 54.38 % Non-Parse CPU: 97.91

Shared Pool Statistics

Begin End

Memory Usage %: 75.25 74.76

% SQL with executions>1: 80.33 85.40

% Memory for SQL w/exec>1: 79.84 77.55

	Begin	End
Memory Usage %:	75.25	74.76
% SQL with executions>1:	80.33	85.40
% Memory for SQL w/exec>1:	79.84	77.55

Top 5 Timed Events

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

db file sequential read 186,728 3,343 18 66.4 User I/O

CPU time 1,188 23.6

log file sync 114,976 435 4 8.6 Commit

enq: TX - row lock contention 9,499 161 17 3.2 Application

SQL*Net break/reset to client 183,645 151 1 3.0 Application

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	186,728	3,343	18	66.4	User I/O
CPU time		1,188		23.6
log file sync	114,976	435	4	8.6	Commit
enq: TX - row lock contention	9,499	161	17	3.2	Application
SQL*Net break/reset to client	183,645	151	1	3.0	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): 5036.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	4,408.87	87.54
DB CPU	1,187.72	23.58
PL/SQL execution elapsed time	144.78	2.87
parse time elapsed	50.92	1.01
hard parse elapsed time	18.46	0.37
PL/SQL compilation elapsed time	5.22	0.10
connection management call elapsed time	3.15	0.06
repeated bind elapsed time	1.42	0.03
sequence load elapsed time	0.44	0.01
hard parse (sharing criteria) elapsed time	0.13	0.00
DB time	5,036.19
background elapsed time	501.19
background cpu time	116.96

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,117	0.00	3,349	18	2.05
Commit	114,976	0.00	435	4	1.26
Application	193,144	0.00	312	2	2.11
Concurrency	10,974	1.52	29	3	0.12
System I/O	141,971	0.00	10	0	1.55
Other	8,754	0.02	9	1	0.10
Configuration	199	0.00	6	32	0.00
Network	214,500	0.00	2	0	2.34

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	186,728	0.00	3,343	18	2.04
log file sync	114,976	0.00	435	4	1.26
enq: TX - row lock contention	9,499	0.00	161	17	0.10
SQL*Net break/reset to client	183,645	0.00	151	1	2.01
buffer busy waits	8,983	0.02	23	3	0.10
log file switch completion	51	0.00	6	108	0.00
log file parallel write	134,763	0.00	5	0	1.47
read by other session	344	0.00	5	14	0.00
control file parallel write	339	0.00	4	12	0.00
rdbms ipc reply	2,032	0.00	3	2	0.02
SQL*Net message to client	213,994	0.00	2	0	2.34
cursor: pin S wait on X	167	98.80	2	12	0.00
latch: In memory undo latch	901	0.00	2	2	0.01
LGWR wait for redo copy	4,234	0.05	2	0	0.05
latch: enqueue hash chains	608	0.00	1	2	0.01
latch: cache buffers chains	513	0.00	1	3	0.01
latch free	404	0.00	1	3	0.00
enq: HW - contention	144	0.00	1	5	0.00
control file sequential read	916	0.00	1	1	0.01
db file scattered read	11	0.00	1	50	0.00
latch: library cache	209	0.00	0	2	0.00
db file parallel write	5,937	0.00	0	0	0.06
enq: TX - contention	16	0.00	0	26	0.00
latch: row cache objects	124	0.00	0	3	0.00
latch: redo allocation	237	0.00	0	1	0.00
enq: US - contention	281	0.00	0	1	0.00
os thread startup	2	0.00	0	93	0.00
latch: session allocation	56	0.00	0	3	0.00
cursor: pin S	776	0.00	0	0	0.01
latch: library cache pin	66	0.00	0	2	0.00
latch: undo global data	38	0.00	0	3	0.00
enq: SQ - contention	1	0.00	0	102	0.00
log file sequential read	8	0.00	0	7	0.00
latch: object queue header operation	30	0.00	0	2	0.00
latch: messages	24	0.00	0	1	0.00
SQL*Net more data to client	489	0.00	0	0	0.01
log file single write	8	0.00	0	3	0.00
latch: cache buffers lru chain	7	0.00	0	2	0.00
latch: shared pool	4	0.00	0	3	0.00
enq: FB - contention	11	0.00	0	1	0.00
latch: redo writing	3	0.00	0	2	0.00
latch: library cache lock	4	0.00	0	1	0.00
library cache load lock	1	0.00	0	2	0.00
SQL*Net more data from client	17	0.00	0	0	0.00
direct path write	18	0.00	0	0	0.00
direct path read	16	0.00	0	0	0.00
SQL*Net message from client	213,989	0.00	2,038	10	2.34
Streams AQ: qmn slave idle wait	22	0.00	602	27349	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	602	13674	0.00
Streams AQ: waiting for messages in the queue	121	100.00	591	4884	0.00
class slave wait	1	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	134,730	0.00	5	0	1.47
control file parallel write	339	0.00	4	12	0.00
events in waitclass Other	4,545	0.04	2	0	0.05
db file sequential read	56	0.00	2	27	0.00
control file sequential read	204	0.00	1	3	0.00
db file parallel write	5,932	0.00	0	0	0.06
os thread startup	2	0.00	0	93	0.00
latch: cache buffers chains	10	0.00	0	18	0.00
db file scattered read	2	0.00	0	64	0.00
log file sequential read	8	0.00	0	7	0.00
log file single write	8	0.00	0	3	0.00
latch: redo writing	3	0.00	0	2	0.00
buffer busy waits	2	0.00	0	1	0.00
latch: shared pool	2	0.00	0	1	0.00
direct path write	14	0.00	0	0	0.00
direct path read	16	0.00	0	0	0.00
rdbms ipc message	121,027	1.39	4,250	35	1.32
smon timer	25	0.00	645	25796	0.00
Streams AQ: qmn slave idle wait	22	0.00	602	27349	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	602	13674	0.00
pmon timer	271	100.00	586	2163	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	130,168
IDLE_TIME	111,144
IOWAIT_TIME	91,259
NICE_TIME	1
SYS_TIME	31,312
USER_TIME	93,366
LOAD	10
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	32,348
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,003.40	1,176.50	185,238	12,163,496
SYS$USERS	26.20	8.70	527	38,143
SYS$BACKGROUND	0.00	0.00	1,142	29,856

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	185484	330260	10947	2866	212490	239
SYS$USERS	519	1473	3	0	1324	5
SYS$BACKGROUND	1132	3355	18	38	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,068	357	92,089	0.03	60.92	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
2,616	191	91,919	0.03	51.94	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
741	410	91,295	0.01	14.72	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
467	62	9,233	0.05	9.28	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
457	53	9,214	0.05	9.08	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
179	49	54,650	0.00	3.56	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
117	35	91,899	0.00	2.32	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
115	51	91,908	0.00	2.29	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
96	57	91,478	0.00	1.90	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
91	58	9,093	0.01	1.81	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
78	23	91,298	0.00	1.55	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
55	40	9,093	0.01	1.09	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...

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
410	741	91,295	0.00	14.72	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
357	3,068	92,089	0.00	60.92	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
191	2,616	91,919	0.00	51.94	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
62	467	9,233	0.01	9.28	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
58	91	9,093	0.01	1.81	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
57	96	91,478	0.00	1.90	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
53	457	9,214	0.01	9.08	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
51	115	91,908	0.00	2.29	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
49	179	54,650	0.00	3.56	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
44	49	91,922	0.00	0.97	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
40	55	9,093	0.00	1.09	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
35	117	91,899	0.00	2.32	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
23	78	91,298	0.00	1.55	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: 12,238,377
Captured SQL account for 90.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
5,633,570	9,233	610.16	46.03	62.06	467.46	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
5,604,705	9,214	608.28	45.80	53.28	457.24	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
2,836,231	91,295	31.07	23.17	410.00	741.24	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
2,239,004	92,089	24.31	18.29	357.15	3067.97	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
924,210	54,650	16.91	7.55	49.10	179.26	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
646,047	91,919	7.03	5.28	191.27	2615.79	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
478,702	91,908	5.21	3.91	51.43	115.08	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
473,281	91,478	5.17	3.87	56.86	95.60	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
466,149	91,899	5.07	3.81	34.95	117.09	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
460,237	91,922	5.01	3.76	44.42	48.71	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
250,240	9,093	27.52	2.04	58.05	91.35	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
187,443	91,298	2.05	1.53	23.35	78.23	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
185,800	91,293	2.04	1.52	14.23	16.28	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
183,848	91,924	2.00	1.50	19.04	19.69	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
182,720	60,097	3.04	1.49	15.80	28.26	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
182,598	91,290	2.00	1.49	11.32	11.46	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
137,199	45,730	3.00	1.12	11.14	11.44	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
136,977	45,658	3.00	1.12	6.15	6.24	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
136,976	45,658	3.00	1.12	11.93	12.11	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
129,736	9,093	14.27	1.06	39.52	54.76	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 186,972
Captured SQL account for 99.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
147,055	92,089	1.60	78.65	357.15	3067.97	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
139,626	91,919	1.52	74.68	191.27	2615.79	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
19,573	9,233	2.12	10.47	62.06	467.46	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
19,566	9,214	2.12	10.46	53.28	457.24	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
16,294	91,295	0.18	8.71	410.00	741.24	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
12,163	54,650	0.22	6.51	49.10	179.26	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
7,087	91,899	0.08	3.79	34.95	117.09	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
3,040	36,647	0.08	1.63	10.81	44.76	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
2,052	9,093	0.23	1.10	58.05	91.35	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
1,001	5,454	0.18	0.54	4.21	14.74	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,490,905
Captured SQL account for 99.1% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
92,089	0	0.00	0.03	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
91,924	91,926	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
91,922	91,926	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
91,919	91,914	1.00	0.03	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
91,908	91,918	1.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
91,899	91,924	1.00	0.00	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
91,478	91,480	1.00	0.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
91,298	91,299	1.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
91,295	91,299	1.00	0.01	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
91,294	91,303	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
91,293	91,300	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
91,290	91,299	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
60,097	60,108	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
54,650	404,665	7.40	0.00	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
45,730	45,733	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
45,658	45,659	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
45,658	45,659	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
36,647	36,648	1.00	0.00	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 321,718
Captured SQL account for 99.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
92,083	92,089	28.62	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
91,909	91,919	28.57	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
91,286	91,295	28.37	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
9,231	9,233	2.87	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
9,139	9,139	2.84	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
9,093	9,093	2.83	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
5,914	5,914	1.84	bsa0wjtftg3uw		select file# from file$ where ...
3,594	3,594	1.12	86708bvah4akq		select name from undo$ where f...
446	446	0.14	2ym6hhaq30r73		select type#, blocks, extents,...
421	421	0.13	0h6b2sajwb74n		select privilege#, level from ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	101,945	169.10	1.11
CPU used when call started	101,894	169.02	1.11
CR blocks created	12,686	21.04	0.14
Cached Commit SCN referenced	68,563	113.73	0.75
Commit SCN cached	213	0.35	0.00
DB time	576,107	955.62	6.30
DBWR checkpoint buffers written	22,095	36.65	0.24
DBWR checkpoints	4	0.01	0.00
DBWR transaction table writes	42	0.07	0.00
DBWR undo block writes	91,581	151.91	1.00
IMU CR rollbacks	11,589	19.22	0.13
IMU Flushes	101,813	168.88	1.11
IMU Redo allocation size	237,642,848	394,192.43	2,597.90
IMU commits	75,388	125.05	0.82
IMU contention	88,373	146.59	0.97
IMU pool not allocated	6,314	10.47	0.07
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	470,735,712	780,837.53	5,146.06
IMU- failed to get a private strand	6,314	10.47	0.07
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for undo segment shrink	22	0.04	0.00
SQL*Net roundtrips to/from client	213,573	354.27	2.33
active txn count during cleanout	19,474	32.30	0.21
application wait time	31,303	51.92	0.34
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	4	0.01	0.00
background checkpoints started	4	0.01	0.00
background timeouts	1,919	3.18	0.02
buffer is not pinned count	6,338,388	10,513.86	69.29
buffer is pinned count	56,565,213	93,828.11	618.37
bytes received via SQL*Net from client	241,935,853	401,313.49	2,644.83
bytes sent via SQL*Net to client	93,428,353	154,975.21	1,021.35
calls to get snapshot scn: kcmgss	1,222,489	2,027.82	13.36
calls to kcmgas	202,905	336.57	2.22
calls to kcmgcs	9,066	15.04	0.10
change write time	4,698	7.79	0.05
cleanout - number of ktugct calls	20,321	33.71	0.22
cleanouts and rollbacks - consistent read gets	8,579	14.23	0.09
cleanouts only - consistent read gets	911	1.51	0.01
cluster key scan block gets	3,089	5.12	0.03
cluster key scans	2,293	3.80	0.03
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	91,916	152.47	1.00
commit batch/immediate requested	91,916	152.47	1.00
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	317	0.53	0.00
commit cleanout failures: cannot pin	2,387	3.96	0.03
commit cleanouts	366,080	607.24	4.00
commit cleanouts successfully completed	363,375	602.75	3.97
commit immediate performed	91,916	152.47	1.00
commit immediate requested	91,916	152.47	1.00
commit txn count during cleanout	3,186	5.28	0.03
concurrency wait time	2,908	4.82	0.03
consistent changes	17,223	28.57	0.19
consistent gets	9,275,018	15,385.03	101.39
consistent gets - examination	7,732,167	12,825.81	84.53
consistent gets direct	0	0.00	0.00
consistent gets from cache	9,275,018	15,385.03	101.39
cursor authentications	92	0.15	0.00
data blocks consistent reads - undo records applied	12,979	21.53	0.14
db block changes	2,977,299	4,938.62	32.55
db block gets	2,963,367	4,915.51	32.40
db block gets direct	8	0.01	0.00
db block gets from cache	2,963,359	4,915.50	32.40
deferred (CURRENT) block cleanout applications	216,145	358.53	2.36
dirty buffers inspected	98,113	162.75	1.07
drop segment calls in space pressure	1,864	3.09	0.02
enqueue conversions	50,764	84.21	0.55
enqueue releases	1,014,558	1,682.91	11.09
enqueue requests	1,014,544	1,682.88	11.09
enqueue timeouts	0	0.00	0.00
enqueue waits	9,844	16.33	0.11
execute count	1,490,905	2,473.05	16.30
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	288,389	478.37	3.15
free buffer requested	292,835	485.74	3.20
global undo segment hints helped	76	0.13	0.00
global undo segment hints were stale	28	0.05	0.00
heap block compress	8,324	13.81	0.09
hot buffers moved to head of LRU	181,014	300.26	1.98
immediate (CR) block cleanout applications	9,490	15.74	0.10
immediate (CURRENT) block cleanout applications	14	0.02	0.00
index fetch by key	2,704,210	4,485.64	29.56
index scans kdiixs1	246,324	408.59	2.69
leaf node 90-10 splits	5	0.01	0.00
leaf node splits	6	0.01	0.00
lob reads	276	0.46	0.00
lob writes	164	0.27	0.00
lob writes unaligned	164	0.27	0.00
local undo segment hints helped	26	0.04	0.00
local undo segment hints were stale	149	0.25	0.00
logons cumulative	217	0.36	0.00
messages received	143,429	237.91	1.57
messages sent	143,429	237.91	1.57
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	1,256,299	2,083.90	13.73
opened cursors cumulative	234,369	388.76	2.56
parse count (hard)	469	0.78	0.01
parse count (total)	321,718	533.65	3.52
parse time cpu	2,478	4.11	0.03
parse time elapsed	4,557	7.56	0.05
physical read IO requests	186,936	310.08	2.04
physical read bytes	3,063,349,248	5,081,360.93	33,488.38
physical read total IO requests	187,863	311.62	2.05
physical read total bytes	3,078,410,240	5,106,343.50	33,653.02
physical read total multi block requests	11	0.02	0.00
physical reads	186,972	310.14	2.04
physical reads cache	186,956	310.12	2.04
physical reads cache prefetch	36	0.06	0.00
physical reads direct	16	0.03	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	81,236	134.75	0.89
physical write bytes	2,116,370,432	3,510,550.43	23,136.05
physical write total IO requests	180,948	300.15	1.98
physical write total bytes	2,554,597,888	4,237,464.57	27,926.73
physical write total multi block requests	155,911	258.62	1.70
physical writes	129,173	214.27	1.41
physical writes direct	24	0.04	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes from cache	129,149	214.23	1.41
physical writes non checkpoint	110,486	183.27	1.21
pinned buffers inspected	5	0.01	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	609	1.01	0.01
recovery blocks read	0	0.00	0.00
recursive calls	2,424,324	4,021.37	26.50
recursive cpu usage	64,889	107.64	0.71
redo blocks read for recovery	0	0.00	0.00
redo blocks written	823,265	1,365.60	9.00
redo buffer allocation retries	35	0.06	0.00
redo entries	858,244	1,423.62	9.38
redo log space requests	51	0.08	0.00
redo log space wait time	554	0.92	0.01
redo ordering marks	5,066	8.40	0.06
redo size	376,689,800	624,837.94	4,117.95
redo synch time	45,487	75.45	0.50
redo synch writes	221,513	367.44	2.42
redo wastage	30,438,648	50,490.41	332.75
redo write time	23,864	39.58	0.26
redo writer latching time	176	0.29	0.00
redo writes	135,010	223.95	1.48
rollback changes - undo records applied	459,580	762.33	5.02
rollbacks only - consistent read gets	4,099	6.80	0.04
rows fetched via callback	2,320,990	3,849.97	25.37
session connect time	0	0.00	0.00
session cursor cache hits	225,330	373.77	2.46
session logical reads	12,238,377	20,300.53	133.79
session uga memory	5,381,740	8,927.01	58.83
session uga memory max	94,837,304	157,312.32	1,036.76
shared hash latch upgrades - no wait	278,569	462.08	3.05
shared hash latch upgrades - wait	81	0.13	0.00
sorts (memory)	12,536	20.79	0.14
sorts (rows)	136,911	227.10	1.50
space was found by tune down	1,854	3.08	0.02
space was not found by tune down	7	0.01	0.00
sql area evicted	151	0.25	0.00
sql area purged	0	0.00	0.00
steps of tune down ret. in space pressure	1,868	3.10	0.02
summed dirty queue length	235,122	390.01	2.57
switch current to new buffer	33	0.05	0.00
table fetch by rowid	30,315,381	50,285.94	331.41
table fetch continued row	161	0.27	0.00
table scan blocks gotten	53,944	89.48	0.59
table scan rows gotten	178,497	296.08	1.95
table scans (short tables)	9,345	15.50	0.10
total number of times SMON posted	25	0.04	0.00
transaction rollbacks	91,916	152.47	1.00
tune down retentions in space pressure	1,861	3.09	0.02
undo change vector size	104,068,928	172,625.37	1,137.68
user I/O wait time	335,586	556.66	3.67
user calls	425,083	705.11	4.65
user commits	91,475	151.74	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	10,165	16.86	0.11
write clones created in foreground	58	0.10	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	24,202	26,993
opened cursors current	385	382
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)	4	23.89

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,144	307	17.83	1.00	17,886	30	8,586	3.10
UNDOTBS1	4	0	210.00	1.00	63,235	105	731	2.87
SYSTEM	1,115	2	24.11	1.01	20	0	0	0.00
SYSAUX	549	1	42.66	1.05	213	0	0	0.00
TEMP	1	0	80.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	549	1	42.66	1.05	213	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	1,115	2	24.11	1.01	20	0	0	0.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	1	0	80.00	1.00	0	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	4	0	210.00	1.00	63,235	105	731	2.87
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	185,144	307	17.83	1.00	17,886	30	8,586	3.10

Back to IO Stats
Back to Top

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	44,274	98	12,234,721	186,724	129,245	0	0	9,304

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	36	13627	411402	1290240	1290240	1953334
E	0	36	14146	419520	1290240	1290240	1887482

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	68	0.10	4,284	5.70	10,876,315
D	136	0.19	8,568	2.84	5,426,250
D	204	0.29	12,852	2.23	4,244,914
D	272	0.39	17,136	1.86	3,555,425
D	340	0.48	21,420	1.61	3,079,272
D	408	0.58	25,704	1.44	2,737,618
D	476	0.68	29,988	1.30	2,485,356
D	544	0.77	34,272	1.20	2,279,968
D	612	0.87	38,556	1.10	2,105,855
D	680	0.97	42,840	1.02	1,953,760
D	704	1.00	44,352	1.00	1,907,612
D	748	1.06	47,124	0.96	1,823,617
D	816	1.16	51,408	0.90	1,712,292
D	884	1.26	55,692	0.85	1,616,701
D	952	1.35	59,976	0.81	1,536,192
D	1,020	1.45	64,260	0.77	1,467,558
D	1,088	1.55	68,544	0.74	1,410,367
D	1,156	1.64	72,828	0.71	1,360,579
D	1,224	1.74	77,112	0.69	1,317,259
D	1,292	1.84	81,396	0.67	1,281,810
D	1,360	1.93	85,680	0.66	1,249,809

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	140	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	103	44	119.12	0.00	0.00	0.00	0.00	21,094
E	103	45	116.77	0.00	0.00	0.00	0.00	21,094

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	9,936	9,936
64K	128K	3	3
256K	512K	2	2
512K	1024K	202	202

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
13	0.13	1,758.51	49.27	97.00	31
26	0.25	1,758.51	49.27	97.00	30
52	0.50	1,758.51	27.30	98.00	23
77	0.75	1,758.51	0.00	100.00	0
103	1.00	1,758.51	0.00	100.00	0
124	1.20	1,758.51	0.00	100.00	0
144	1.40	1,758.51	0.00	100.00	0
165	1.60	1,758.51	0.00	100.00	0
185	1.80	1,758.51	0.00	100.00	0
206	2.00	1,758.51	0.00	100.00	0
309	3.00	1,758.51	0.00	100.00	0
412	4.00	1,758.51	0.00	100.00	0
618	6.00	1,758.51	0.00	100.00	0
824	8.00	1,758.51	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
32	0.40	8	1,051	2,388,599	0.98	43,337	65.27	7,036,433
40	0.50	15	1,681	2,393,503	0.98	38,433	57.88	7,042,497
48	0.60	22	2,168	2,414,516	0.99	17,420	26.23	7,048,358
56	0.70	29	2,623	2,422,891	1.00	9,045	13.62	7,051,552
64	0.80	36	3,087	2,426,606	1.00	5,330	8.03	7,053,711
72	0.90	43	3,503	2,429,790	1.00	2,146	3.23	7,054,850
80	1.00	51	3,967	2,431,272	1.00	664	1.00	7,055,241
88	1.10	59	4,325	2,432,051	1.00	1	0.00	7,055,478
96	1.20	67	4,849	2,432,350	1.00	1	0.00	7,055,598
104	1.30	74	5,622	2,432,350	1.00	1	0.00	7,055,610
112	1.40	74	5,622	2,432,350	1.00	1	0.00	7,055,619
120	1.50	74	5,622	2,432,351	1.00	1	0.00	7,055,627
128	1.60	74	5,622	2,432,351	1.00	1	0.00	7,055,628
136	1.70	74	5,622	2,432,351	1.00	1	0.00	7,055,629
144	1.80	74	5,622	2,432,351	1.00	1	0.00	7,055,629
152	1.90	74	5,622	2,432,351	1.00	1	0.00	7,055,629
160	2.00	74	5,622	2,432,351	1.00	1	0.00	7,055,629

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
200	0.25	213,609	5,412,903
400	0.50	127,531	3,071,823
600	0.75	97,370	2,275,030
800	1.00	79,669	1,903,472
1,000	1.25	69,550	1,532,866
1,200	1.50	62,253	1,357,556
1,400	1.75	57,931	1,246,965
1,600	2.00	57,933	1,246,965

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	8,562	27	3
file header block	170	1	8
undo header	542	1	1
undo block	19	0	1
1st level bmb	13	0	0
segment header	5	0	0
2nd level bmb	4	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)	9,380	9,380	9,374	166	17.74
HW-Segment High Water Mark	109,705	109,705	133	1	6.09
TX-Transaction	188,988	188,703	15	0	29.33
US-Undo Segment	52,050	52,048	272	0	1.47
SQ-Sequence Cache	29	29	1	0	110.00
FB-Format Block	82	82	11	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	91.53	188,097	0	12	12.7166666666666666666666666666666666667/12.716666666666666666666666666666666666	0/0	10/0/0/3450/216664/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
10-Apr 14:59	91,532	188,097	0	12	13	0/0	10/0/0/3450/216664/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AWR Alerted Metric Element list	2,102	0.00		0	0
Consistent RBA	134,750	0.02	0.16	0	0
FOB s.o list latch	891	0.00		0	0
In memory undo latch	1,768,225	0.74	0.07	2	183,408	0.00
JS queue state obj latch	3,630	0.00		0	0
KMG MMAN ready and startup request latch	200	0.00		0	0
KTF sga latch	2	0.00		0	203	0.00
MQL Tracking Latch	0			0	12	0.00
Memory Management Latch	0			0	200	0.00
OS process	651	0.00		0	0
OS process allocation	635	0.00		0	0
OS process: request allocation	426	0.00		0	0
PL/SQL warning settings	211,076	0.51	0.00	0	0
SGA IO buffer pool latch	10,251	0.00		0	10,235	0.00
SQL memory manager latch	1	0.00		0	200	0.00
SQL memory manager workarea list latch	14,577	0.00		0	0
Shared B-Tree	23	0.00		0	0
Undo Hint Latch	0			0	5,341	0.02
active checkpoint queue latch	6,520	0.00		0	0
active service list	2,492	0.00		0	272	0.00
archive control	3	0.00		0	0
begin backup scn array	1	0.00		0	0
cache buffer handles	1,490	0.00		0	0
cache buffers chains	25,651,111	0.10	0.02	1	290,654	0.06
cache buffers lru chain	390,265	0.16	0.01	0	302,646	0.75
cache table scan latch	0			0	11	0.00
channel handle pool latch	428	0.00		0	0
channel operations parent latch	11,997	0.00		0	0
checkpoint queue latch	190,129	0.01	0.00	0	122,856	0.04
client/application info	1,067	0.00		0	0
compile environment latch	224,668	0.18	0.00	0	0
dml lock allocation	1,283,746	1.03	0.02	1	0
dummy allocation	426	0.00		0	0
enqueue hash chains	2,095,706	0.67	0.04	1	1,370	0.29
enqueues	596,497	0.34	0.01	0	0
event group latch	213	0.00		0	0
file cache latch	4,265	0.00		0	0
global KZLD latch for mem in SGA	211	0.00		0	0
hash table column usage latch	0			0	14,321	0.00
hash table modification latch	1	0.00		0	0
job_queue_processes parameter latch	10	0.00		0	0
kks stats	1,461	0.00		0	0
ksuosstats global area	42	0.00		0	0
ktm global data	69	0.00		0	0
kwqbsn:qsga	23	0.00		0	0
lgwr LWN SCN	134,720	0.00	0.00	0	0
library cache	1,704,639	0.55	0.02	0	1,795	0.17
library cache load lock	2,254	0.00		0	0
library cache lock	415,484	0.29	0.00	0	0
library cache lock allocation	4,038	0.00		0	0
library cache pin	837,901	0.50	0.02	0	0
library cache pin allocation	678	0.00		0	0
list of block allocation	432	0.00		0	0
loader state object freelist	50	0.00		0	0
message pool operations parent latch	2	0.00		0	0
messages	443,239	0.09	0.06	0	0
mostly latch-free SCN	135,278	0.12	0.09	0	0
multiblock read objects	24	0.00		0	0
ncodef allocation latch	13	0.00		0	0
object queue header heap	13,637	0.00		0	611	0.00
object queue header operation	961,498	0.06	0.05	0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	80	0.00		0	0
parameter list	768	0.00		0	0
parameter table allocation management	213	0.00		0	0
post/wait queue	176,793	0.01	0.05	0	114,695	0.33
process allocation	426	0.00		0	213	0.00
process group creation	426	0.00		0	0
qmn task queue latch	88	0.00		0	0
redo allocation	779,385	0.22	0.14	0	853,619	1.27
redo copy	0			0	857,812	0.65
redo writing	420,983	0.00	0.14	0	0
resmgr group change latch	213	0.00		0	0
resmgr:actses active list	423	0.00		0	0
resmgr:actses change group	211	0.00		0	0
resmgr:free threads list	422	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	2,085,737	0.39	0.02	0	964	0.10
sequence cache	1,149	0.00		0	0
session allocation	798,727	0.56	0.01	0	0
session idle bit	1,073,524	0.07	0.03	0	0
session state list latch	428	0.00		0	0
session switching	13	0.00		0	0
session timer	272	0.00		0	0
shared pool	73,470	0.08	0.09	0	0
shared pool sim alloc	2	0.00		0	0
shared pool simulator	42,224	0.00		0	0
simulator hash latch	731,534	0.00	0.13	0	0
simulator lru latch	688,075	0.22	0.06	0	17,539	0.02
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	47	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	112	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	35	0.00		0	0
transaction allocation	7,296	0.00		0	0
transaction branch allocation	13	0.00		0	0
undo global data	1,691,927	0.13	0.02	0	0
user lock	844	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	25,651,111	26,194	516	25,685
enqueue hash chains	2,095,706	14,058	611	13,452
dml lock allocation	1,283,746	13,186	249	12,938
In memory undo latch	1,768,225	13,012	903	12,121
library cache	1,704,639	9,407	213	9,196
row cache objects	2,085,737	8,050	125	7,927
session allocation	798,727	4,494	58	4,438
library cache pin	837,901	4,195	66	4,132
undo global data	1,691,927	2,115	38	2,078
enqueues	596,497	2,053	15	2,038
redo allocation	779,385	1,744	237	1,507
simulator lru latch	688,075	1,531	98	1,433
library cache lock	415,484	1,204	4	1,200
session idle bit	1,073,524	734	19	715
cache buffers lru chain	390,265	617	7	610
object queue header operation	961,498	564	30	534
messages	443,239	413	24	389
mostly latch-free SCN	135,278	158	15	143
shared pool	73,470	58	5	53
Consistent RBA	134,750	25	4	21
redo writing	420,983	21	3	18
post/wait queue	176,793	19	1	18
simulator hash latch	731,534	8	1	7
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	705	753
In memory undo latch	ktichg: child	104	126
In memory undo latch	ktiTxnPoolFree	52	0
In memory undo latch	kticmt: child	38	4
In memory undo latch	kturbk	6	22
cache buffers chains	kcbgtcr: fast path	311	296
cache buffers chains	kcbgcur: kslbegin	122	178
cache buffers chains	kcbgtcr: kslbegin excl	74	38
cache buffers chains	kcbgtcr: kslbegin shared	51	1
cache buffers chains	kcbchg: kslbegin: bufs not pinned	48	107
cache buffers chains	kcbnew: new latch again	22	6
cache buffers chains	kcbzgb: scan from tail. nowait	21	0
cache buffers chains	kcbchg: kslbegin: call CR func	19	42
cache buffers chains	kcbgtcr	19	0
cache buffers chains	kcb_pre_apply: kcbhq61	16	17
cache buffers chains	kcbnlc	12	15
cache buffers chains	kcbrls: kslbegin	10	7
cache buffers chains	kcbzwb	5	4
cache buffers chains	kcbbxsv	4	3
cache buffers chains	kcbget: exchange rls	4	0
cache buffers chains	kcb_post_apply: kcbhq62	3	1
cache buffers chains	kcbcge	1	2
cache buffers chains	kcbget: exchange	1	0
cache buffers chains	kcbget: pin buffer	1	12
cache buffers chains	kcbkzs	1	18
cache buffers chains	kcbzib: finish free bufs	1	4
cache buffers lru chain	kcbzgws	7	3
dml lock allocation	ktaiam	143	196
dml lock allocation	ktaidm	106	53
enqueue hash chains	ksqrcl	318	183
enqueue hash chains	ksqgtl3	293	424
enqueue hash chains	ksqcmi: get hash chain latch after wait	1	4
enqueues	ksqies	9	12
enqueues	ksqdel	3	3
enqueues	ksqgel: create enqueue	3	0
library cache	kglpndl: child: after processing	94	2
library cache	kglpnp: child	46	114
library cache	kglLockCursor	20	1
library cache	kglpndl: child: before processing	12	78
library cache	kgldte: child 0	10	18
library cache	kglobpn: child:	9	0
library cache	kglhdgn: child:	8	0
library cache	kgldti: 2child	3	0
library cache	kglpin	2	0
library cache	kglic	1	0
library cache	kglini: child	1	0
library cache	kglobld	1	0
library cache	kglrtl	1	0
library cache lock	kgllkal: child: multiinstance	2	1
library cache lock	kgllkdl: child: cleanup	2	3
library cache lock	kgllkdl: child: no lock handle	1	0
library cache pin	kglpnp: child	34	35
library cache pin	kglpndl	30	29
messages	ksaamb: after wakeup	15	17
messages	ksarcv: after wait	5	0
messages	ksarcv	4	7
mostly latch-free SCN	kcs04	11	15
mostly latch-free SCN	kcs05	4	0
mostly latch-free SCN	kcs01	3	4
mostly latch-free SCN	kcsnew_scn_rba	1	0
object queue header operation	kcbw_link_q	13	0
object queue header operation	kcbo_switch_cq	10	25
object queue header operation	kcbo_switch_mq_bg	3	0
object queue header operation	kcbo_switch_q_bg	2	0
object queue header operation	kcbw_unlink_q	2	5
post/wait queue	ksliwat:add:nowait	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	234	0
redo allocation	kcrfw_redo_gen: redo allocation 2	1	0
redo allocation	kcrfw_redo_gen: redo allocation 3	1	3
redo allocation	kcrfw_redo_write: more space	1	118
redo writing	kcrfw_cal_target_rba	2	1
redo writing	kcrfwcr	1	2
row cache objects	kqreqd: reget	75	0
row cache objects	kqrpre: find obj	45	111
row cache objects	kqreqd	4	13
row cache objects	kqrso	1	0
session allocation	ksuxds: not user session	19	6
session allocation	ksucri	17	50
session allocation	ksuprc	15	0
session allocation	ksudlc	6	3
session allocation	ksufap: active sessions	1	0
session allocation	ksuxds: KSUSFCLC not set	1	0
session idle bit	ksupuc: clear busy	8	10
session idle bit	ksupuc: set busy	7	5
session idle bit	ksuxds	4	4
shared pool	kghfrunp: clatch: nowait	4	0
shared pool	kghalo	2	3
shared pool	kghupr1	2	0
shared pool	kghfrunp: alloc: session dur	1	0
simulator hash latch	kcbs_get_or_extract_simbufseq	1	0
simulator lru latch	kcbs_simulate: simulate set	86	96
simulator lru latch	kcbs_simbufseq	12	2
slave class create	ksvcreate	1	0
undo global data	ktudba: KSLBEGIN	17	15
undo global data	ktudnx:child	11	4
undo global data	ktubnd:child	3	0
undo global data	ktusmasp: ktugd_tuux	3	2
undo global data	ktuGetRetentionDuration	1	0
undo global data	ktucmt: ktugd_cuux	1	0
undo global data	ktufrbs: child	1	16
undo global data	ktusm_stealext: KSLBEGIN	1	1

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 12,238,377
Captured Segments account for 83.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	3,723,984	30.43
TPCC	USERS	STOCK	TABLE	1,852,064	15.13
TPCC	USERS	CUSTOMER_I2	INDEX	754,864	6.17
TPCC	USERS	CUSTOMER	TABLE	709,024	5.79
TPCC	USERS	CUSTOMER_I1	INDEX	538,544	4.40

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 186,972
Captured Segments account for 99.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	ITEM_ID	INDEX	89,219	47.72
TPCC	USERS	ITEM	TABLE	49,978	26.73
TPCC	USERS	CUSTOMER	TABLE	24,050	12.86
TPCC	USERS	STOCK	TABLE	18,977	10.15
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	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
TPCC	USERS	DISTRICT		TABLE	10,660	56.84
TPCC	USERS	WAREHOUSE		TABLE	8,094	43.16

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	WAREHOUSE	TABLE	522	57.68
TPCC	USERS	HISTORY	TABLE	239	26.41
TPCC	USERS	DISTRICT	TABLE	130	14.36
TPCC	USERS	INORD	INDEX	12	1.33
TPCC	USERS	ORDERS_I1	INDEX	2	0.22

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	14	7.14	2	1
dc_global_oids	61	29.51	0	0
dc_histogram_data	3,216	26.96	0	632
dc_histogram_defs	6,855	29.12	0	777
dc_object_grants	45	13.33	0	8
dc_object_ids	4,018	7.04	0	221
dc_objects	2,099	14.20	0	207
dc_profiles	211	0.00	0	1
dc_rollback_segments	126,648	0.00	0	23
dc_segments	11,051	4.06	6	172
dc_sequences	28	10.71	28	2
dc_tablespace_quotas	3	33.33	0	1
dc_tablespaces	532,668	0.00	0	5
dc_usernames	518	0.00	0	3
dc_users	6,445	0.00	0	16
outstanding_alerts	13	76.92	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	7	42.86	101,336	0.01	4
CLUSTER	20	0.00	37	5.41	2
INDEX	39	51.28	136	19.12	6
SQL AREA	498	67.47	1,711,325	0.07	50
TABLE/PROCEDURE	1,025	20.39	317,276	0.34	353

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	102.05		3.52	10.64	55	55	29	29
	Freeable	12.88	0.00	1.07	0.64	3		12	12
	SQL	1.72	0.77	0.07	0.03	0	8	23	22
	PL/SQL	1.32	0.61	0.05	0.05	0	0	29	29
E	Other	102.51		3.42	10.47	55	55	30	30
	Freeable	12.38	0.00	1.03	0.68	3		12	12
	SQL	1.62	0.68	0.07	0.03	0	8	24	23
	PL/SQL	1.43	0.47	0.05	0.05	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	738,197,504
Fixed Size	1,263,572
Redo Buffers	7,122,944
Variable Size	92,276,780

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	10.52	10.78	2.52
shared	KGLS heap	0.93	0.92	-0.97
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KSXR receive buffers	0.99	0.99	0.00
shared	KTI-UNDO	2.36	2.36	0.00
shared	db_block_hash_buckets	1.13	1.13	0.00
shared	dbwriter coalesce buffer	1.00	1.00	0.00
shared	event statistics per sess	2.56	2.56	0.00
shared	free memory	19.80	20.19	1.99
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	library cache	2.87	3.00	4.61
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	3.01	2.17	-27.95
	buffer_cache	704.00	704.00	0.00
	fixed_sga	1.21	1.21	0.00
	log_buffer	6.79	6.79	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Apply
Buffered Queues
Buffered Subscribers
Rule Set

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

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

End of Report

% Blocks changed per Read:	24.33	Recursive Call %:	85.08
Rollback per transaction %:	0.00	Rows per Sort:	10.92

Buffer Nowait %:	99.92	Redo NoWait %:	99.99
Buffer Hit %:	98.47	In-memory Sort %:	100.00
Library Hit %:	99.89	Soft Parse %:	99.85
Execute to Parse %:	78.42	Latch Hit %:	99.77
Parse CPU to Parse Elapsd %:	54.38	% Non-Parse CPU:	97.91