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: 429 11-Apr-06 10:20:36 29 12.1

End Snap: 430 11-Apr-06 10:30:40 29 11.7

Elapsed: 10.07 (mins)

DB Time: 86.05 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	429	11-Apr-06 10:20:36	29	12.1
End Snap:	430	11-Apr-06 10:30:40	29	11.7
Elapsed:		10.07 (mins)
DB Time:		86.05 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 514,027.25 4,091.55

Logical reads: 16,179.92 128.79

Block changes: 4,041.16 32.17

Physical reads: 255.18 2.03

Physical writes: 179.27 1.43

User calls: 580.85 4.62

Parses: 431.38 3.43

Hard parses: 1.06 0.01

Sorts: 18.63 0.15

Logons: 0.30 0.00

Executes: 2,036.78 16.21

Transactions: 125.63

	Per Second	Per Transaction
Redo size:	514,027.25	4,091.55
Logical reads:	16,179.92	128.79
Block changes:	4,041.16	32.17
Physical reads:	255.18	2.03
Physical writes:	179.27	1.43
User calls:	580.85	4.62
Parses:	431.38	3.43
Hard parses:	1.06	0.01
Sorts:	18.63	0.15
Logons:	0.30	0.00
Executes:	2,036.78	16.21
Transactions:	125.63

% Blocks changed per Read: 24.98 Recursive Call %: 85.13

Rollback per transaction %: 0.00 Rows per Sort: 10.67

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.92 Redo NoWait %: 99.98

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

Library Hit %: 99.82 Soft Parse %: 99.75

Execute to Parse %: 78.82 Latch Hit %: 99.75

Parse CPU to Parse Elapsd %: 61.83 % Non-Parse CPU: 97.68

Shared Pool Statistics

Begin End

Memory Usage %: 82.14 82.47

% SQL with executions>1: 78.50 85.99

% Memory for SQL w/exec>1: 80.28 81.24

	Begin	End
Memory Usage %:	82.14	82.47
% SQL with executions>1:	78.50	85.99
% Memory for SQL w/exec>1:	80.28	81.24

Top 5 Timed Events

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

db file sequential read 153,852 3,633 24 70.4 User I/O

CPU time 981 19.0

log file sync 96,815 367 4 7.1 Commit

enq: TX - row lock contention 9,991 239 24 4.6 Application

log file parallel write 107,582 186 2 3.6 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	153,852	3,633	24	70.4	User I/O
CPU time		981		19.0
log file sync	96,815	367	4	7.1	Commit
enq: TX - row lock contention	9,991	239	24	4.6	Application
log file parallel write	107,582	186	2	3.6	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): 5163.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,617.42	89.43
DB CPU	980.69	18.99
PL/SQL execution elapsed time	122.96	2.38
parse time elapsed	43.16	0.84
hard parse elapsed time	16.27	0.32
connection management call elapsed time	3.67	0.07
PL/SQL compilation elapsed time	3.37	0.07
repeated bind elapsed time	1.12	0.02
sequence load elapsed time	0.76	0.01
hard parse (sharing criteria) elapsed time	0.28	0.01
DB time	5,163.21
background elapsed time	508.10
background cpu time	90.93

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	154,180	0.00	3,641	24	2.03
Application	161,065	0.00	372	2	2.12
Commit	96,815	0.00	367	4	1.28
System I/O	108,829	0.00	207	2	1.43
Concurrency	9,798	0.94	26	3	0.13
Configuration	92	0.00	21	226	0.00
Other	5,862	0.00	5	1	0.08
Network	177,244	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	153,852	0.00	3,633	24	2.03
log file sync	96,815	0.00	367	4	1.28
enq: TX - row lock contention	9,991	0.00	239	24	0.13
log file parallel write	107,582	0.00	186	2	1.42
SQL*Net break/reset to client	151,074	0.00	133	1	1.99
buffer busy waits	7,977	0.01	21	3	0.11
control file parallel write	325	0.00	20	62	0.00
log file switch completion	56	0.00	18	329	0.00
read by other session	282	0.00	8	30	0.00
enq: HW - contention	34	0.00	2	66	0.00
latch: In memory undo latch	866	0.00	2	2	0.01
SQL*Net message to client	176,771	0.00	2	0	2.33
LGWR wait for redo copy	3,503	0.00	2	1	0.05
latch: enqueue hash chains	509	0.00	1	2	0.01
cursor: pin S wait on X	93	97.85	1	12	0.00
control file sequential read	910	0.00	1	1	0.01
latch free	363	0.00	1	2	0.00
latch: cache buffers chains	451	0.00	1	2	0.01
latch: library cache	199	0.00	1	3	0.00
latch: redo allocation	221	0.00	0	2	0.00
db file scattered read	12	0.00	0	27	0.00
latch: row cache objects	121	0.00	0	3	0.00
latch: library cache pin	69	0.00	0	3	0.00
enq: SQ - contention	1	0.00	0	122	0.00
os thread startup	2	0.00	0	58	0.00
cursor: pin S	977	0.00	0	0	0.01
rdbms ipc reply	170	0.00	0	1	0.00
log file single write	6	0.00	0	15	0.00
latch: session allocation	30	0.00	0	3	0.00
latch: object queue header operation	20	0.00	0	3	0.00
latch: undo global data	25	0.00	0	2	0.00
enq: TX - contention	1	0.00	0	45	0.00
log file sequential read	6	0.00	0	7	0.00
latch: messages	20	0.00	0	2	0.00
latch: cache buffers lru chain	10	0.00	0	4	0.00
SQL*Net more data to client	456	0.00	0	0	0.01
enq: FB - contention	13	0.00	0	2	0.00
latch: library cache lock	7	0.00	0	2	0.00
latch: shared pool	8	0.00	0	2	0.00
direct path write	18	0.00	0	0	0.00
row cache lock	5	0.00	0	0	0.00
SQL*Net more data from client	17	0.00	0	0	0.00
direct path read	16	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
SQL*Net message from client	176,774	0.00	1,623	9	2.33
Streams AQ: qmn slave idle wait	22	0.00	602	27348	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	2	0.00	0	1	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	107,594	0.00	186	2	1.42
control file parallel write	325	0.00	20	62	0.00
events in waitclass Other	3,908	0.00	2	1	0.05
db file sequential read	74	0.00	1	14	0.00
control file sequential read	191	0.00	1	4	0.00
os thread startup	2	0.00	0	58	0.00
log file single write	6	0.00	0	15	0.00
db file scattered read	1	0.00	0	45	0.00
log file sequential read	6	0.00	0	7	0.00
buffer busy waits	5	0.00	0	4	0.00
latch: cache buffers chains	2	0.00	0	4	0.00
latch: library cache	1	0.00	0	5	0.00
latch: shared pool	2	0.00	0	1	0.00
direct path write	16	0.00	0	0	0.00
direct path read	16	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
rdbms ipc message	95,489	1.75	4,249	44	1.26
Streams AQ: qmn slave idle wait	22	0.00	602	27348	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	602	13674	0.00
pmon timer	259	100.00	589	2275	0.00
smon timer	26	0.00	576	22149	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	107,606
IDLE_TIME	133,536
IOWAIT_TIME	108,115
NICE_TIME	1
SYS_TIME	25,606
USER_TIME	77,278
LOAD	9
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,236
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,133.50	972.00	152,113	9,681,860
SYS$USERS	25.60	8.80	551	46,419
SYS$BACKGROUND	0.00	0.00	1,238	37,180

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	152389	360306	9776	2606	175403	204
SYS$USERS	539	1477	9	3	1296	4
SYS$BACKGROUND	1238	2287	13	15	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,506	289	75,634	0.05	67.91	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
3,079	152	75,628	0.04	59.63	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
754	338	75,876	0.01	14.61	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
238	47	7,404	0.03	4.60	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
230	39	7,401	0.03	4.45	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
194	39	45,760	0.00	3.76	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
123	28	75,596	0.00	2.37	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
120	36	75,620	0.00	2.33	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
112	44	75,895	0.00	2.18	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
102	20	75,877	0.00	1.97	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
82	48	7,499	0.01	1.58	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
338	754	75,876	0.00	14.61	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
289	3,506	75,634	0.00	67.91	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
152	3,079	75,628	0.00	59.63	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
48	82	7,499	0.01	1.58	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
47	238	7,404	0.01	4.60	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
44	112	75,895	0.00	2.18	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
39	230	7,401	0.01	4.45	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
39	194	45,760	0.00	3.76	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
38	43	75,630	0.00	0.83	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
36	120	75,620	0.00	2.33	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
28	123	75,596	0.00	2.37	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
20	102	75,877	0.00	1.97	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: 9,772,235
Captured SQL account for 89.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
4,449,047	7,404	600.90	45.53	46.60	237.69	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
4,432,084	7,401	598.85	45.35	39.46	229.70	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
2,285,123	75,876	30.12	23.38	338.22	754.15	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
1,756,548	75,634	23.22	17.97	288.94	3506.42	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
770,216	45,760	16.83	7.88	39.41	194.10	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
531,446	75,628	7.03	5.44	151.84	3078.83	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
384,759	75,596	5.09	3.94	28.05	122.59	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
378,659	75,630	5.01	3.87	38.35	43.05	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
315,749	75,895	4.16	3.23	43.95	112.31	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
310,056	75,620	4.10	3.17	36.26	120.39	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
202,636	7,499	27.02	2.07	47.86	81.57	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
156,569	75,877	2.06	1.60	20.08	101.85	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
155,047	75,892	2.04	1.59	12.06	13.13	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
152,511	50,178	3.04	1.56	12.86	26.52	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
151,756	75,864	2.00	1.55	9.27	9.36	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
151,256	75,628	2.00	1.55	15.57	16.09	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
114,117	38,040	3.00	1.17	5.14	5.33	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
114,117	38,039	3.00	1.17	9.84	9.92	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
113,547	37,850	3.00	1.16	9.14	11.16	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
107,086	7,498	14.28	1.10	32.62	44.68	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: 154,120
Captured SQL account for 99.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
119,832	75,634	1.58	77.75	288.94	3506.42	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
114,348	75,628	1.51	74.19	151.84	3078.83	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
18,088	7,401	2.44	11.74	39.46	229.70	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
18,088	7,404	2.44	11.74	46.60	237.69	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
12,627	75,876	0.17	8.19	338.22	754.15	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
9,423	45,760	0.21	6.11	39.41	194.10	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
5,435	75,596	0.07	3.53	28.05	122.59	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
2,335	30,121	0.08	1.52	8.02	45.73	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
1,509	7,499	0.20	0.98	47.86	81.57	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
770	4,418	0.17	0.50	3.28	15.67	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,230,162
Captured SQL account for 99.7% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
75,895	75,903	1.00	0.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
75,892	75,906	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
75,881	75,889	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
75,877	75,883	1.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
75,876	75,877	1.00	0.01	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
75,864	75,878	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
75,634	0	0.00	0.05	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
75,630	75,629	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
75,628	75,630	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
75,628	75,630	1.00	0.04	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
75,620	75,627	1.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
75,596	75,629	1.00	0.00	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
50,178	50,184	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
45,760	336,999	7.36	0.00	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
38,040	38,040	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
38,039	38,039	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
37,850	37,850	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
30,121	30,122	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: 260,540
Captured SQL account for 98.8% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
75,871	75,876	29.12	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
75,622	75,628	29.03	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
75,618	75,634	29.02	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
7,590	7,590	2.91	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
7,499	7,499	2.88	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
7,404	7,404	2.84	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
590	590	0.23	2ym6hhaq30r73		select type#, blocks, extents,...
466	466	0.18	bsa0wjtftg3uw		select file# from file$ where ...
346	50,178	0.13	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
345	345	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 )

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 )
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	84,262	139.51	1.11
CPU used when call started	84,091	139.23	1.11
CR blocks created	12,632	20.91	0.17
Cached Commit SCN referenced	529	0.88	0.01
Commit SCN cached	14	0.02	0.00
DB time	591,356	979.11	7.79
DBWR checkpoint buffers written	20,913	34.63	0.28
DBWR checkpoints	4	0.01	0.00
DBWR transaction table writes	43	0.07	0.00
DBWR undo block writes	75,671	125.29	1.00
IMU CR rollbacks	11,652	19.29	0.15
IMU Flushes	82,701	136.93	1.09
IMU Redo allocation size	195,568,856	323,803.97	2,577.41
IMU commits	62,468	103.43	0.82
IMU contention	72,840	120.60	0.96
IMU pool not allocated	6,403	10.60	0.08
IMU undo allocation size	388,760,084	643,671.30	5,123.49
IMU- failed to get a private strand	6,403	10.60	0.08
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	176,339	291.97	2.32
active txn count during cleanout	20,163	33.38	0.27
application wait time	37,321	61.79	0.49
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,907	3.16	0.03
buffer is not pinned count	5,114,626	8,468.30	67.41
buffer is pinned count	46,573,529	77,111.94	613.79
bytes received via SQL*Net from client	200,069,515	331,255.73	2,636.73
bytes sent via SQL*Net to client	77,716,572	128,675.57	1,024.23
calls to get snapshot scn: kcmgss	986,065	1,632.63	13.00
calls to kcmgas	167,980	278.13	2.21
calls to kcmgcs	7,121	11.79	0.09
change write time	4,061	6.72	0.05
cleanout - number of ktugct calls	20,541	34.01	0.27
cleanouts and rollbacks - consistent read gets	8,749	14.49	0.12
cleanouts only - consistent read gets	648	1.07	0.01
cluster key scan block gets	4,068	6.74	0.05
cluster key scans	3,134	5.19	0.04
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	75,565	125.11	1.00
commit batch/immediate requested	75,565	125.11	1.00
commit cleanout failures: buffer being written	1	0.00	0.00
commit cleanout failures: callback failure	320	0.53	0.00
commit cleanout failures: cannot pin	2,296	3.80	0.03
commit cleanouts	304,129	503.55	4.01
commit cleanouts successfully completed	301,512	499.21	3.97
commit immediate performed	75,565	125.11	1.00
commit immediate requested	75,565	125.11	1.00
commit txn count during cleanout	2,904	4.81	0.04
concurrency wait time	2,611	4.32	0.03
consistent changes	17,261	28.58	0.23
consistent gets	7,451,122	12,336.85	98.20
consistent gets - examination	6,192,899	10,253.60	81.62
consistent gets direct	0	0.00	0.00
consistent gets from cache	7,451,122	12,336.85	98.20
cursor authentications	171	0.28	0.00
data blocks consistent reads - undo records applied	12,968	21.47	0.17
db block changes	2,440,749	4,041.16	32.17
db block gets	2,321,125	3,843.09	30.59
db block gets direct	9	0.01	0.00
db block gets from cache	2,321,116	3,843.08	30.59
deferred (CURRENT) block cleanout applications	177,576	294.01	2.34
dirty buffers inspected	80,667	133.56	1.06
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	163	0.27	0.00
enqueue releases	701,242	1,161.05	9.24
enqueue requests	701,244	1,161.05	9.24
enqueue timeouts	0	0.00	0.00
enqueue waits	9,904	16.40	0.13
execute count	1,230,162	2,036.78	16.21
frame signature mismatch	0	0.00	0.00
free buffer inspected	238,574	395.01	3.14
free buffer requested	243,466	403.11	3.21
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	6,163	10.20	0.08
hot buffers moved to head of LRU	150,878	249.81	1.99
immediate (CR) block cleanout applications	9,397	15.56	0.12
immediate (CURRENT) block cleanout applications	16	0.03	0.00
index fetch by key	2,172,354	3,596.77	28.63
index scans kdiixs1	206,067	341.19	2.72
leaf node 90-10 splits	6	0.01	0.00
leaf node splits	7	0.01	0.00
lob reads	329	0.54	0.00
lob writes	140	0.23	0.00
lob writes unaligned	140	0.23	0.00
local undo segment hints helped	0	0.00	0.00
local undo segment hints were stale	0	0.00	0.00
logons cumulative	184	0.30	0.00
messages received	113,946	188.66	1.50
messages sent	113,946	188.66	1.50
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	1,036,233	1,715.69	13.66
opened cursors cumulative	191,102	316.41	2.52
parse count (hard)	642	1.06	0.01
parse count (total)	260,540	431.38	3.43
parse time cpu	2,279	3.77	0.03
parse time elapsed	3,686	6.10	0.05
physical read IO requests	154,083	255.12	2.03
physical read bytes	2,525,102,080	4,180,819.47	33,278.45
physical read total IO requests	155,016	256.66	2.04
physical read total bytes	2,540,261,376	4,205,918.77	33,478.23
physical read total multi block requests	12	0.02	0.00
physical reads	154,120	255.18	2.03
physical reads cache	154,104	255.15	2.03
physical reads cache prefetch	37	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	67,683	112.06	0.89
physical write bytes	1,773,993,984	2,937,207.43	23,379.56
physical write total IO requests	146,478	242.52	1.93
physical write total bytes	2,137,165,312	3,538,511.34	28,165.81
physical write total multi block requests	126,271	209.07	1.66
physical writes	108,276	179.27	1.43
physical writes direct	25	0.04	0.00
physical writes from cache	108,251	179.23	1.43
physical writes non checkpoint	90,406	149.69	1.19
pinned buffers inspected	1	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
process last non-idle time	611	1.01	0.01
recovery blocks read	0	0.00	0.00
recursive calls	2,008,518	3,325.51	26.47
recursive cpu usage	53,000	87.75	0.70
redo blocks read for recovery	0	0.00	0.00
redo blocks written	677,151	1,121.16	8.92
redo buffer allocation retries	110	0.18	0.00
redo entries	691,811	1,145.43	9.12
redo log space requests	137	0.23	0.00
redo log space wait time	2,444	4.05	0.03
redo ordering marks	3,401	5.63	0.04
redo size	310,458,580	514,027.25	4,091.55
redo synch time	38,215	63.27	0.50
redo synch writes	181,892	301.16	2.40
redo wastage	24,457,700	40,494.69	322.33
redo write time	19,423	32.16	0.26
redo writer latching time	182	0.30	0.00
redo writes	107,637	178.21	1.42
rollback changes - undo records applied	377,825	625.57	4.98
rollbacks only - consistent read gets	3,871	6.41	0.05
rows fetched via callback	1,848,079	3,059.87	24.36
session connect time	0	0.00	0.00
session cursor cache hits	182,481	302.13	2.40
session logical reads	9,772,235	16,179.92	128.79
session uga memory	4,493,624	7,440.11	59.22
session uga memory max	81,189,724	134,426.08	1,070.00
shared hash latch upgrades - no wait	234,471	388.21	3.09
shared hash latch upgrades - wait	80	0.13	0.00
sorts (memory)	11,249	18.63	0.15
sorts (rows)	120,059	198.78	1.58
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	230	0.38	0.00
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	233,187	386.09	3.07
switch current to new buffer	32	0.05	0.00
table fetch by rowid	24,934,107	41,283.48	328.61
table fetch continued row	201	0.33	0.00
table scan blocks gotten	34,053	56.38	0.45
table scan rows gotten	59,516	98.54	0.78
table scans (short tables)	791	1.31	0.01
total number of times SMON posted	26	0.04	0.00
transaction rollbacks	75,564	125.11	1.00
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	85,998,692	142,388.31	1,133.38
user I/O wait time	364,599	603.67	4.81
user calls	350,816	580.85	4.62
user commits	75,878	125.63	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	8,956	14.83	0.12
write clones created in foreground	50	0.08	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	9,422	11,623
opened cursors current	352	340
logons current	29	29

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	4	23.84

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	152,055	252	23.68	1.00	14,814	25	8,071	3.65
UNDOTBS1	4	0	35.00	1.00	52,596	87	186	0.48
SYSTEM	1,275	2	21.06	1.01	23	0	1	100.00
SYSAUX	539	1	25.19	1.06	192	0	0	0.00
TEMP	1	0	110.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	539	1	25.19	1.06	192	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	1,275	2	21.06	1.01	23	0	1	100.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	1	0	110.00	1.00	0	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	4	0	35.00	1.00	52,596	87	186	0.48
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	152,055	252	23.68	1.00	14,814	25	8,071	3.65

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,791	98	9,779,315	154,113	108,000	0	0	8,266

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	34	13406	370381	1290240	1290240	1919317
E	0	33	12935	358332	1290240	1290240	1859056

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	68	0.10	4,284	5.80	4,615,846
D	136	0.19	8,568	2.86	2,279,419
D	204	0.28	12,852	2.25	1,786,356
D	272	0.38	17,136	1.89	1,503,767
D	340	0.47	21,420	1.64	1,301,548
D	408	0.57	25,704	1.45	1,154,454
D	476	0.66	29,988	1.32	1,048,663
D	544	0.76	34,272	1.21	961,097
D	612	0.85	38,556	1.12	887,688
D	680	0.95	42,840	1.04	824,964
D	716	1.00	45,108	1.00	795,632
D	748	1.04	47,124	0.97	770,839
D	816	1.14	51,408	0.91	724,134
D	884	1.23	55,692	0.86	684,126
D	952	1.33	59,976	0.82	650,303
D	1,020	1.42	64,260	0.78	621,304
D	1,088	1.52	68,544	0.75	597,158
D	1,156	1.61	72,828	0.73	578,021
D	1,224	1.71	77,112	0.71	561,541
D	1,292	1.80	81,396	0.69	547,267
D	1,360	1.90	85,680	0.67	534,787

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	135	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	47	113.02	0.00	0.00	0.00	0.00	21,094
E	103	47	112.96	0.00	0.00	0.00	0.00	21,094

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	8,755	8,755
64K	128K	3	3
256K	512K	2	2
512K	1024K	198	198

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	868.68	5.12	99.00	8
26	0.25	868.68	5.12	99.00	7
52	0.50	868.68	2.32	100.00	3
77	0.75	868.68	0.00	100.00	0
103	1.00	868.68	0.00	100.00	0
124	1.20	868.68	0.00	100.00	0
144	1.40	868.68	0.00	100.00	0
165	1.60	868.68	0.00	100.00	0
185	1.80	868.68	0.00	100.00	0
206	2.00	868.68	0.00	100.00	0
309	3.00	868.68	0.00	100.00	0
412	4.00	868.68	0.00	100.00	0
618	6.00	868.68	0.00	100.00	0
824	8.00	868.68	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
48	0.67	8	1,128	457,036	0.95	22,668	82.13	2,982,065
56	0.78	15	1,744	470,038	0.98	9,666	35.02	2,985,082
64	0.89	22	2,317	476,686	0.99	3,018	10.93	2,987,395
72	1.00	29	2,880	479,428	1.00	276	1.00	2,989,208
80	1.11	36	3,266	481,497	1.00	1	0.00	2,989,966
88	1.22	44	3,715	481,511	1.00	1	0.00	2,990,174
96	1.33	51	4,416	481,511	1.00	1	0.00	2,990,203
104	1.44	52	4,784	481,511	1.00	1	0.00	2,990,203
112	1.56	52	4,784	481,511	1.00	1	0.00	2,990,203
120	1.67	52	4,784	481,511	1.00	1	0.00	2,990,203
128	1.78	52	4,784	481,511	1.00	1	0.00	2,990,203
136	1.89	52	4,784	481,511	1.00	1	0.00	2,990,203
144	2.00	52	4,784	481,511	1.00	1	0.00	2,990,203

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	89,086	2,338,528
400	0.50	51,520	1,335,059
600	0.75	40,485	1,075,750
800	1.00	32,018	790,818
1,000	1.25	27,979	667,609
1,200	1.50	25,708	593,351
1,400	1.75	24,352	548,986
1,600	2.00	24,358	548,986

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,058	30	4
undo header	174	0	1
undo block	14	0	0
1st level bmb	13	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,866	9,866	9,856	245	24.89
HW-Segment High Water Mark	605	605	33	2	70.00
SQ-Sequence Cache	25	25	1	0	130.00
TX-Transaction	152,342	152,084	1	0	50.00
FB-Format Block	78	78	13	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	76.22	155,220	0	12	13.2666666666666666666666666666666666667/13.266666666666666666666666666666666666	0/0	5/0/0/954/52100/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
11-Apr 10:22	76,217	155,220	0	12	13	0/0	5/0/0/954/52100/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AWR Alerted Metric Element list	2,092	0.00		0	0
Consistent RBA	107,687	0.02	0.00	0	0
FOB s.o list latch	779	0.00		0	0
In memory undo latch	1,455,944	0.79	0.08	2	151,692	0.00
JS queue state obj latch	3,630	0.00		0	0
KMG MMAN ready and startup request latch	201	0.00		0	0
KTF sga latch	2	0.00		0	203	0.00
KWQMN job cache list latch	1	0.00		0	0
MQL Tracking Latch	0			0	12	0.00
Memory Management Latch	0			0	201	0.00
OS process	561	0.00		0	0
OS process allocation	574	0.00		0	0
OS process: request allocation	365	0.00		0	0
PL/SQL warning settings	174,313	0.58	0.00	0	0
SGA IO buffer pool latch	8,398	0.00		0	8,423	0.00
SQL memory manager latch	1	0.00		0	195	0.00
SQL memory manager workarea list latch	14,390	0.00		0	0
Shared B-Tree	23	0.00		0	0
active checkpoint queue latch	6,236	0.00		0	0
active service list	2,378	0.00		0	259	0.00
archive control	4	0.00		0	0
begin backup scn array	1	0.00		0	0
cache buffer handles	1,408	0.00		0	0
cache buffers chains	20,548,690	0.11	0.02	1	241,682	0.08
cache buffers lru chain	326,254	0.14	0.02	0	253,799	0.69
cache table scan latch	0			0	12	0.00
channel handle pool latch	367	0.00		0	0
channel operations parent latch	4,240	0.00		0	0
checkpoint queue latch	163,901	0.01	0.00	0	101,724	0.04
client/application info	922	0.00		0	0
compile environment latch	183,242	0.19	0.00	0	0
dml lock allocation	1,063,168	1.06	0.02	1	0
dummy allocation	365	0.00		0	0
enqueue hash chains	1,412,500	0.73	0.05	1	1,563	0.45
enqueues	217,346	0.42	0.01	0	0
event group latch	182	0.00		0	0
file cache latch	710	0.00		0	0
global KZLD latch for mem in SGA	180	0.00		0	0
hash table column usage latch	300	0.00		0	16,816	0.00
job_queue_processes parameter latch	10	0.00		0	0
kks stats	1,873	0.00		0	0
ksuosstats global area	42	0.00		0	0
ktm global data	70	0.00		0	0
kwqbsn:qsga	23	0.00		0	0
lgwr LWN SCN	107,672	0.01	0.33	0	0
library cache	1,421,515	0.64	0.02	1	3,301	0.09
library cache load lock	3,014	0.00		0	0
library cache lock	352,086	0.34	0.01	0	0
library cache lock allocation	3,404	0.00		0	0
library cache pin	694,929	0.56	0.02	0	0
library cache pin allocation	662	0.00		0	0
list of block allocation	369	0.00		0	0
loader state object freelist	50	0.00		0	0
message pool operations parent latch	2	0.00		0	0
messages	348,395	0.10	0.06	0	0
mostly latch-free SCN	108,147	0.15	0.03	0	0
multiblock read objects	28	0.00		0	0
ncodef allocation latch	12	0.00		0	0
object queue header heap	13,014	0.00		0	559	0.00
object queue header operation	798,444	0.05	0.05	0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	80	0.00		0	0
parameter list	654	0.00		0	0
parameter table allocation management	183	0.00		0	0
post/wait queue	146,679	0.02	0.00	0	96,681	0.32
process allocation	365	0.00		0	182	0.00
process group creation	365	0.00		0	0
qmn task queue latch	88	0.00		0	0
redo allocation	633,310	0.22	0.16	0	688,443	1.39
redo copy	0			0	692,107	0.69
redo writing	338,646	0.01	0.05	0	0
resmgr group change latch	184	0.00		0	0
resmgr:actses active list	362	0.00		0	0
resmgr:actses change group	180	0.00		0	0
resmgr:free threads list	361	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	1,234,676	0.48	0.02	0	2,437	0.12
sequence cache	991	0.00		0	0
session allocation	635,888	0.53	0.01	0	0
session idle bit	884,501	0.07	0.01	0	0
session state list latch	370	0.00		0	0
session switching	12	0.00		0	0
session timer	259	0.00		0	0
shared pool	83,839	0.13	0.07	0	0
shared pool sim alloc	6	0.00		0	0
shared pool simulator	70,093	0.01	0.00	0	0
simulator hash latch	588,272	0.00	0.00	0	0
simulator lru latch	551,942	0.23	0.08	0	14,476	0.00
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	383	0.00		0	0
transaction branch allocation	12	0.00		0	0
undo global data	951,889	0.14	0.02	0	0
user lock	724	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	20,548,690	23,036	451	22,590
In memory undo latch	1,455,944	11,465	865	10,610
dml lock allocation	1,063,168	11,295	238	11,058
enqueue hash chains	1,412,500	10,256	510	9,748
library cache	1,421,515	9,095	199	8,897
row cache objects	1,234,676	5,961	121	5,842
library cache pin	694,929	3,908	69	3,840
session allocation	635,888	3,397	30	3,367
redo allocation	633,310	1,410	221	1,189
undo global data	951,889	1,356	25	1,331
simulator lru latch	551,942	1,279	104	1,176
library cache lock	352,086	1,187	7	1,180
enqueues	217,346	910	5	905
session idle bit	884,501	633	8	625
cache buffers lru chain	326,254	452	10	442
object queue header operation	798,444	389	20	369
messages	348,395	337	20	317
mostly latch-free SCN	108,147	162	5	157
shared pool	83,839	112	8	105
redo writing	338,646	19	1	18
lgwr LWN SCN	107,672	6	2	4
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	663	718
In memory undo latch	ktichg: child	87	109
In memory undo latch	ktiTxnPoolFree	57	0
In memory undo latch	kticmt: child	52	1
In memory undo latch	kturbk	6	37
cache buffers chains	kcbgtcr: fast path	307	231
cache buffers chains	kcbgcur: kslbegin	107	178
cache buffers chains	kcbchg: kslbegin: bufs not pinned	65	114
cache buffers chains	kcbgtcr: kslbegin excl	52	43
cache buffers chains	kcbgtcr: kslbegin shared	23	3
cache buffers chains	kcbnew: new latch again	17	2
cache buffers chains	kcbgtcr	16	0
cache buffers chains	kcb_pre_apply: kcbhq61	14	11
cache buffers chains	kcbzgb: scan from tail. nowait	14	0
cache buffers chains	kcbrls: kslbegin	13	17
cache buffers chains	kcbzwb	13	3
cache buffers chains	kcbnlc	9	20
cache buffers chains	kcbchg: kslbegin: call CR func	8	37
cache buffers chains	kcbget: exchange rls	7	0
cache buffers chains	kcb_post_apply: kcbhq62	5	1
cache buffers chains	kcbso1: set no access	3	0
cache buffers chains	kcbzib: finish free bufs	2	2
cache buffers chains	kcbbic2	1	1
cache buffers chains	kcbget: exchange	1	2
cache buffers chains	kcbget: pin buffer	1	3
cache buffers chains	kcbnew_1	1	3
cache buffers lru chain	kcbzgws	10	4
dml lock allocation	ktaiam	151	166
dml lock allocation	ktaidm	88	73
enqueue hash chains	ksqrcl	267	151
enqueue hash chains	ksqgtl3	238	352
enqueue hash chains	ksqcmi: get hash chain latch after wait	3	6
enqueue hash chains	ksqcnl	1	0
enqueues	ksqgel: create enqueue	2	0
enqueues	ksqies	2	4
enqueues	ksqdel	1	1
lgwr LWN SCN	kcs022	1	0
library cache	kglpndl: child: after processing	75	1
library cache	kglpnp: child	69	114
library cache	kglLockCursor	17	3
library cache	kgldte: child 0	10	14
library cache	kglpndl: child: before processing	7	64
library cache	kglobpn: child:	5	0
library cache	kglpin	4	1
library cache	kglic	3	0
library cache	kglhdgn: child:	2	0
library cache	kgldti: 2child	1	0
library cache	kgldtld: 2child	1	0
library cache	kglini: child	1	0
library cache lock	kgllkal: child: multiinstance	5	0
library cache lock	kgllkdl: child: cleanup	2	7
library cache pin	kglpndl	40	30
library cache pin	kglpnp: child	28	38
library cache pin	kglpnal: child: alloc space	1	1
messages	ksaamb: after wakeup	12	8
messages	ksarcv	7	12
messages	ksarcv: after wait	1	0
mostly latch-free SCN	kcs04	5	7
mostly latch-free SCN	kcs05	1	0
object queue header operation	kcbw_link_q	12	0
object queue header operation	kcbo_switch_cq	7	16
object queue header operation	kcbw_unlink_q	1	4
redo allocation	kcrfw_redo_gen: redo allocation 1	213	0
redo allocation	kcrfw_redo_write: before write	3	109
redo allocation	kcrfw_redo_gen: redo allocation 2	2	0
redo allocation	kcrfw_redo_gen: redo allocation 3	2	6
redo allocation	kcrfw_redo_write: more space	1	106
redo writing	kcrfwcr	1	0
row cache objects	kqreqd: reget	60	0
row cache objects	kqrpre: find obj	55	103
row cache objects	kqreqd	6	18
session allocation	ksucri	10	28
session allocation	ksudlc	7	1
session allocation	ksuprc	7	0
session allocation	ksuxds: not user session	6	2
session allocation	ksufap: active sessions	1	0
session idle bit	ksupuc: set busy	4	3
session idle bit	ksupuc: clear busy	3	3
session idle bit	ksuxds	2	3
shared pool	kghalo	5	3
shared pool	kghfrunp: clatch: nowait	3	0
shared pool	kghupr1	3	5
simulator lru latch	kcbs_simulate: simulate set	94	103
simulator lru latch	kcbs_simbufseq	10	1
slave class create	ksvcreate	1	0
undo global data	ktudba: KSLBEGIN	15	7
undo global data	ktudnx:child	7	5
undo global data	ktufrbs: child	2	13
undo global data	kturimugur: child	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 9,772,235
Captured Segments account for 84.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	2,939,520	30.08
TPCC	USERS	STOCK	TABLE	1,460,464	14.95
TPCC	USERS	CUSTOMER_I2	INDEX	626,848	6.41
TPCC	USERS	CUSTOMER	TABLE	590,304	6.04
TPCC	USERS	CUSTOMER_I1	INDEX	448,208	4.59

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 154,120
Captured Segments account for 99.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	ITEM_ID	INDEX	73,510	47.70
TPCC	USERS	ITEM	TABLE	40,704	26.41
TPCC	USERS	CUSTOMER	TABLE	17,961	11.65
TPCC	USERS	STOCK	TABLE	17,864	11.59
TPCC	USERS	CUSTOMER_I2	INDEX	533	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,310	52.24
TPCC	USERS	WAREHOUSE		TABLE	9,426	47.76

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
TPCC	USERS	ORDERS	TABLE	6,845	87.89
TPCC	USERS	WAREHOUSE	TABLE	518	6.65
TPCC	USERS	HISTORY	TABLE	276	3.54
TPCC	USERS	DISTRICT	TABLE	133	1.71
TPCC	USERS	INORD	INDEX	14	0.18

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	61	31.15	0	0
dc_histogram_data	3,969	30.99	0	436
dc_histogram_defs	8,162	35.29	0	828
dc_object_grants	53	22.64	0	8
dc_object_ids	5,220	7.85	0	192
dc_objects	2,644	17.70	0	190
dc_profiles	181	0.55	0	1
dc_rollback_segments	184	0.00	0	23
dc_segments	2,626	22.54	3	166
dc_sequences	24	20.83	24	1
dc_tablespace_quotas	2	50.00	0	1
dc_tablespaces	383,717	0.00	0	5
dc_usernames	518	1.16	0	3
dc_users	6,547	0.20	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
BODY	9	33.33	83,504	0.01	6
CLUSTER	38	0.00	88	3.41	3
INDEX	40	75.00	134	23.88	2
SQL AREA	698	74.07	1,409,672	0.12	112
TABLE/PROCEDURE	1,441	24.77	264,198	0.54	367

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	101.08		3.49	11.16	58	58	29	29
	Freeable	9.19	0.00	0.92	0.28	1		10	10
	SQL	1.57	0.71	0.07	0.03	0	2	23	22
	PL/SQL	1.25	0.58	0.04	0.05	0	0	29	29
E	Other	100.90		3.48	11.16	58	58	29	29
	Freeable	9.19	0.00	0.92	0.28	1		10	10
	SQL	1.57	0.73	0.07	0.03	0	2	23	22
	PL/SQL	1.25	0.62	0.04	0.05	0	0	29	29

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	4.00	4.00	0.00
large	PX msg pool	1.02	1.02	0.00
large	free memory	2.98	2.98	0.00
shared	ASH buffers	8.00	8.00	0.00
shared	FileOpenBlock	1.58	1.58	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGH: NO ACCESS	14.77	14.99	1.48
shared	KGLS heap	1.13	1.10	-2.64
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	12.86	12.62	-1.88
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	library cache	2.75	2.77	0.49
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.36	2.37	0.17
	buffer_cache	712.00	712.00	0.00
	fixed_sga	1.21	1.21	0.00
	log_buffer	6.79	6.79	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/opt/oracle/admin/TESTIBM/adump
background_dump_dest	/opt/oracle/admin/TESTIBM/bdump
compatible	10.2.0.2.0
control_files	/u02/app/oracle/oradata/TESTIBM/control01.ctl, /u02/app/oracle/oradata/TESTIBM/control02.ctl, /u03/app/oracle/oradata/TESTIBM/control03.ctl
core_dump_dest	/opt/oracle/admin/TESTIBM/cdump
db_block_size	16384
db_domain
db_file_multiblock_read_count	16
db_name	TESTIBM
filesystemio_options	NONE
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.98	Recursive Call %:	85.13
Rollback per transaction %:	0.00	Rows per Sort:	10.67

Buffer Nowait %:	99.92	Redo NoWait %:	99.98
Buffer Hit %:	98.42	In-memory Sort %:	100.00
Library Hit %:	99.82	Soft Parse %:	99.75
Execute to Parse %:	78.82	Latch Hit %:	99.75
Parse CPU to Parse Elapsd %:	61.83	% Non-Parse CPU:	97.68