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: 443 11-Apr-06 12:50:17 30 12.6

End Snap: 444 11-Apr-06 13:00:19 30 12.2

Elapsed: 10.02 (mins)

DB Time: 86.38 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	443	11-Apr-06 12:50:17	30	12.6
End Snap:	444	11-Apr-06 13:00:19	30	12.2
Elapsed:		10.02 (mins)
DB Time:		86.38 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 573,137.20 4,106.17

Logical reads: 18,257.61 130.80

Block changes: 4,539.92 32.53

Physical reads: 291.79 2.09

Physical writes: 199.89 1.43

User calls: 648.43 4.65

Parses: 482.04 3.45

Hard parses: 1.39 0.01

Sorts: 21.45 0.15

Logons: 0.34 0.00

Executes: 2,270.25 16.26

Transactions: 139.58

	Per Second	Per Transaction
Redo size:	573,137.20	4,106.17
Logical reads:	18,257.61	130.80
Block changes:	4,539.92	32.53
Physical reads:	291.79	2.09
Physical writes:	199.89	1.43
User calls:	648.43	4.65
Parses:	482.04	3.45
Hard parses:	1.39	0.01
Sorts:	21.45	0.15
Logons:	0.34	0.00
Executes:	2,270.25	16.26
Transactions:	139.58

% Blocks changed per Read: 24.87 Recursive Call %: 85.16

Rollback per transaction %: 0.00 Rows per Sort: 10.50

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.92 Redo NoWait %: 99.99

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

Library Hit %: 99.80 Soft Parse %: 99.71

Execute to Parse %: 78.77 Latch Hit %: 99.79

Parse CPU to Parse Elapsd %: 48.87 % Non-Parse CPU: 97.47

Shared Pool Statistics

Begin End

Memory Usage %: 81.75 83.20

% SQL with executions>1: 79.87 80.07

% Memory for SQL w/exec>1: 81.47 74.30

	Begin	End
Memory Usage %:	81.75	83.20
% SQL with executions>1:	79.87	80.07
% Memory for SQL w/exec>1:	81.47	74.30

Top 5 Timed Events

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

db file sequential read 174,607 3,596 21 69.4 User I/O

CPU time 1,028 19.8

log file sync 96,310 402 4 7.8 Commit

enq: TX - row lock contention 9,207 173 19 3.3 Application

log file parallel write 132,163 163 1 3.1 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	174,607	3,596	21	69.4	User I/O
CPU time		1,028		19.8
log file sync	96,310	402	4	7.8	Commit
enq: TX - row lock contention	9,207	173	19	3.3	Application
log file parallel write	132,163	163	1	3.1	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): 5182.8s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	4,606.83	88.89
DB CPU	1,028.04	19.84
PL/SQL execution elapsed time	136.29	2.63
parse time elapsed	61.34	1.18
hard parse elapsed time	28.90	0.56
PL/SQL compilation elapsed time	5.22	0.10
connection management call elapsed time	3.71	0.07
repeated bind elapsed time	1.29	0.02
sequence load elapsed time	1.10	0.02
hard parse (sharing criteria) elapsed time	0.17	0.00
hard parse (bind mismatch) elapsed time	0.04	0.00
DB time	5,182.84
background elapsed time	373.96
background cpu time	95.05

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	175,886	0.00	3,627	21	2.10
Commit	96,310	0.00	402	4	1.15
Application	176,775	0.00	304	2	2.11
System I/O	141,538	0.00	226	2	1.69
Concurrency	9,988	6.54	29	3	0.12
Configuration	83	0.00	8	93	0.00
Other	5,877	0.02	4	1	0.07
Network	196,885	0.00	2	0	2.35

Back to Wait Events Statistics
Back to Top

Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file sequential read	174,607	0.00	3,596	21	2.08
log file sync	96,310	0.00	402	4	1.15
enq: TX - row lock contention	9,207	0.00	173	19	0.11
log file parallel write	132,163	0.00	163	1	1.58
SQL*Net break/reset to client	167,568	0.00	131	1	2.00
db file parallel write	8,081	0.00	51	6	0.10
read by other session	1,188	0.00	20	17	0.01
buffer busy waits	7,600	0.00	17	2	0.09
db file scattered read	49	0.00	11	227	0.00
cursor: pin S wait on X	657	99.39	8	12	0.01
control file sequential read	940	0.00	8	8	0.01
log file switch completion	72	0.00	7	99	0.00
control file parallel write	338	0.00	3	10	0.00
SQL*Net message to client	196,327	0.00	2	0	2.34
latch: In memory undo latch	930	0.00	2	2	0.01
LGWR wait for redo copy	3,621	0.00	1	0	0.04
latch: enqueue hash chains	478	0.00	1	2	0.01
latch free	412	0.00	1	2	0.00
latch: cache buffers chains	445	0.00	1	2	0.01
latch: library cache	186	0.00	0	2	0.00
enq: HW - contention	8	0.00	0	48	0.00
direct path read	21	0.00	0	17	0.00
latch: redo allocation	260	0.00	0	1	0.00
latch: row cache objects	83	0.00	0	3	0.00
rdbms ipc reply	391	0.00	0	1	0.00
cursor: pin S	602	0.00	0	0	0.01
enq: SQ - contention	1	0.00	0	163	0.00
os thread startup	2	0.00	0	67	0.00
latch: library cache pin	63	0.00	0	2	0.00
latch: session allocation	36	0.00	0	2	0.00
kksfbc child completion	1	100.00	0	50	0.00
SQL*Net more data to client	541	0.00	0	0	0.01
latch: object queue header operation	26	0.00	0	2	0.00
log file sequential read	8	0.00	0	5	0.00
latch: messages	19	0.00	0	2	0.00
latch: undo global data	14	0.00	0	2	0.00
latch: cache buffers lru chain	10	0.00	0	3	0.00
wait list latch free	2	0.00	0	13	0.00
latch: library cache lock	8	0.00	0	3	0.00
latch: shared pool	5	0.00	0	2	0.00
direct path write	21	0.00	0	0	0.00
cursor: mutex S	1	0.00	0	4	0.00
enq: FB - contention	5	0.00	0	1	0.00
log file single write	8	0.00	0	0	0.00
row cache lock	6	0.00	0	0	0.00
latch: redo writing	2	0.00	0	1	0.00
SQL*Net more data from client	17	0.00	0	0	0.00
library cache load lock	2	0.00	0	0	0.00
SQL*Net message from client	196,327	0.00	3,035	15	2.34
Streams AQ: waiting for messages in the queue	121	99.17	586	4847	0.00
Streams AQ: waiting for time management or cleanup tasks	3	33.33	586	195228	0.00
Streams AQ: qmn slave idle wait	21	0.00	574	27348	0.00
Streams AQ: qmn coordinator idle wait	42	50.00	574	13674	0.00
class slave wait	2	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	132,262	0.00	163	1	1.58
db file parallel write	8,087	0.00	51	6	0.10
db file sequential read	330	0.00	11	33	0.00
control file sequential read	204	0.00	6	28	0.00
control file parallel write	338	0.00	3	10	0.00
events in waitclass Other	4,276	0.00	2	0	0.05
db file scattered read	3	0.00	0	94	0.00
buffer busy waits	18	0.00	0	10	0.00
direct path read	16	0.00	0	9	0.00
os thread startup	2	0.00	0	67	0.00
log file sequential read	8	0.00	0	5	0.00
latch: cache buffers chains	5	0.00	0	2	0.00
direct path write	18	0.00	0	0	0.00
log file single write	8	0.00	0	0	0.00
latch: redo writing	2	0.00	0	1	0.00
log file sync	1	0.00	0	0	0.00
rdbms ipc message	125,390	1.38	6,154	49	1.49
pmon timer	259	100.00	586	2263	0.00
Streams AQ: waiting for time management or cleanup tasks	3	33.33	586	195228	0.00
smon timer	75	0.00	577	7698	0.00
Streams AQ: qmn slave idle wait	21	0.00	574	27348	0.00
Streams AQ: qmn coordinator idle wait	42	50.00	574	13674	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	115,761
IDLE_TIME	125,583
IOWAIT_TIME	100,530
NICE_TIME	1
SYS_TIME	26,197
USER_TIME	84,906
LOAD	9
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	192,484
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,101.30	1,009.00	172,111	10,804,099
SYS$USERS	63.40	16.90	1,320	129,295
SYS$BACKGROUND	0.00	0.00	1,409	39,128

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	173373	353790	9970	2874	194657	221
SYS$USERS	1122	4206	3	1	1657	6
SYS$BACKGROUND	1406	4657	26	33	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,119	313	84,086	0.04	60.18	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
2,648	160	83,856	0.03	51.08	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
869	368	83,843	0.01	16.76	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
453	54	8,396	0.05	8.73	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
443	46	8,363	0.05	8.56	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
286	60	50,373	0.01	5.51	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
169	39	83,829	0.00	3.25	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
104	53	8,455	0.01	2.00	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
102	38	83,845	0.00	1.96	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
100	45	84,109	0.00	1.92	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
71	20	83,833	0.00	1.38	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
70	13	33,474	0.00	1.35	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
56	21	83,847	0.00	1.07	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
54	36	8,455	0.01	1.03	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
368	869	83,843	0.00	16.76	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
313	3,119	84,086	0.00	60.18	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
160	2,648	83,856	0.00	51.08	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
60	286	50,373	0.00	5.51	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
54	453	8,396	0.01	8.73	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
53	104	8,455	0.01	2.00	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
46	443	8,363	0.01	8.56	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
45	100	84,109	0.00	1.92	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
39	45	83,858	0.00	0.87	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
39	169	83,829	0.00	3.25	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
38	102	83,845	0.00	1.96	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
36	54	8,455	0.00	1.03	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
21	56	83,847	0.00	1.07	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
20	71	83,833	0.00	1.38	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
13	70	33,474	0.00	1.35	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
Total Buffer Gets: 10,975,798
Captured SQL account for 88.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
5,014,507	8,396	597.25	45.69	54.25	452.65	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
4,977,806	8,363	595.22	45.35	46.34	443.46	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
2,528,021	83,843	30.15	23.03	368.33	868.79	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
1,952,284	84,086	23.22	17.79	313.13	3119.23	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
843,797	50,373	16.75	7.69	59.88	285.81	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
589,263	83,856	7.03	5.37	160.03	2647.58	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
426,534	83,829	5.09	3.89	39.06	168.56	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
419,951	83,858	5.01	3.83	39.32	45.04	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
349,756	84,109	4.16	3.19	45.07	99.66	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
343,471	83,845	4.10	3.13	38.48	101.84	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
231,972	8,455	27.44	2.11	53.20	103.78	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
172,036	84,108	2.05	1.57	12.95	13.05	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
171,970	83,833	2.05	1.57	20.33	71.45	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
168,687	55,482	3.04	1.54	14.55	27.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
167,796	83,862	2.00	1.53	16.51	17.15	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
167,696	83,832	2.00	1.53	10.14	10.20	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
126,180	42,057	3.00	1.15	5.61	5.63	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
126,174	42,058	3.00	1.15	10.40	10.67	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
125,784	41,927	3.00	1.15	10.05	10.25	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
120,498	8,455	14.25	1.10	35.95	53.59	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: 175,413
Captured SQL account for 99.1% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
134,377	84,086	1.60	76.61	313.13	3119.23	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
127,184	83,856	1.52	72.51	160.03	2647.58	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
19,506	8,396	2.32	11.12	54.25	452.65	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
19,499	8,363	2.33	11.12	46.34	443.46	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
16,455	83,843	0.20	9.38	368.33	868.79	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
12,094	50,373	0.24	6.89	59.88	285.81	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
6,666	83,829	0.08	3.80	39.06	168.56	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
2,960	33,474	0.09	1.69	13.12	70.14	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
2,401	8,455	0.28	1.37	53.20	103.78	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
1,107	5,110	0.22	0.63	5.56	25.01	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,364,790
Captured SQL account for 98.5% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
84,109	84,114	1.00	0.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
84,108	84,116	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
84,086	0	0.00	0.04	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
83,862	83,861	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
83,858	83,861	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
83,856	83,858	1.00	0.03	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
83,847	83,849	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
83,845	83,857	1.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
83,843	83,844	1.00	0.01	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
83,833	83,841	1.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
83,832	83,848	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
83,829	83,862	1.00	0.00	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
55,482	55,485	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
50,373	368,922	7.32	0.01	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
42,058	42,059	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
42,057	42,059	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
41,927	41,927	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
33,474	33,474	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: 289,785
Captured SQL account for 98.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
84,086	84,086	29.02	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
83,855	83,856	28.94	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
83,840	83,843	28.93	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
8,457	8,457	2.92	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
8,455	8,455	2.92	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
8,395	8,396	2.90	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
738	738	0.25	2ym6hhaq30r73		select type#, blocks, extents,...
607	607	0.21	bsa0wjtftg3uw		select file# from file$ where ...
537	537	0.19	grwydz59pu6mc		select text from view$ where r...
390	390	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;

grwydz59pu6mc select text from view$ where rowid=:1

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;
grwydz59pu6mc	select text from view$ where rowid=:1
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	92,086	153.18	1.10
CPU used when call started	91,871	152.82	1.09
CR blocks created	13,540	22.52	0.16
Cached Commit SCN referenced	646	1.07	0.01
Commit SCN cached	1	0.00	0.00
DB time	591,000	983.09	7.04
DBWR checkpoint buffers written	21,312	35.45	0.25
DBWR checkpoints	3	0.00	0.00
DBWR transaction table writes	43	0.07	0.00
DBWR undo block writes	84,565	140.67	1.01
IMU CR rollbacks	12,733	21.18	0.15
IMU Flushes	95,654	159.11	1.14
IMU Redo allocation size	227,861,496	379,034.46	2,715.55
IMU commits	67,536	112.34	0.80
IMU contention	82,212	136.75	0.98
IMU pool not allocated	4,805	7.99	0.06
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	436,870,408	726,708.74	5,206.42
IMU- failed to get a private strand	4,805	7.99	0.06
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	63	0.10	0.00
SQL*Net roundtrips to/from client	196,000	326.03	2.34
active txn count during cleanout	20,744	34.51	0.25
application wait time	30,250	50.32	0.36
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	3	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	1,923	3.20	0.02
buffer is not pinned count	5,702,876	9,486.41	67.96
buffer is pinned count	52,520,639	87,365.06	625.92
bytes received via SQL*Net from client	221,744,403	368,859.03	2,642.65
bytes sent via SQL*Net to client	86,453,239	143,809.98	1,030.31
calls to get snapshot scn: kcmgss	1,119,675	1,862.51	13.34
calls to kcmgas	184,582	307.04	2.20
calls to kcmgcs	10,555	17.56	0.13
change write time	4,577	7.61	0.05
cleanout - number of ktugct calls	21,782	36.23	0.26
cleanouts and rollbacks - consistent read gets	9,409	15.65	0.11
cleanouts only - consistent read gets	647	1.08	0.01
cluster key scan block gets	4,715	7.84	0.06
cluster key scans	3,767	6.27	0.04
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	83,958	139.66	1.00
commit batch/immediate requested	83,958	139.66	1.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	393	0.65	0.00
commit cleanout failures: cannot pin	3,530	5.87	0.04
commit cleanouts	336,193	559.24	4.01
commit cleanouts successfully completed	332,270	552.71	3.96
commit immediate performed	83,958	139.66	1.00
commit immediate requested	83,958	139.66	1.00
commit txn count during cleanout	4,235	7.04	0.05
concurrency wait time	2,920	4.86	0.03
consistent changes	39,617	65.90	0.47
consistent gets	8,321,040	13,841.57	99.17
consistent gets - examination	6,922,341	11,514.92	82.50
consistent gets direct	5	0.01	0.00
consistent gets from cache	8,321,035	13,841.56	99.17
cursor authentications	192	0.32	0.00
data blocks consistent reads - undo records applied	13,807	22.97	0.16
db block changes	2,729,234	4,539.92	32.53
db block gets	2,654,750	4,416.02	31.64
db block gets direct	9	0.01	0.00
db block gets from cache	2,654,741	4,416.01	31.64
deferred (CURRENT) block cleanout applications	196,314	326.56	2.34
dirty buffers inspected	93,482	155.50	1.11
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	213	0.35	0.00
enqueue releases	775,377	1,289.79	9.24
enqueue requests	775,392	1,289.82	9.24
enqueue timeouts	0	0.00	0.00
enqueue waits	9,023	15.01	0.11
execute count	1,364,790	2,270.25	16.26
frame signature mismatch	0	0.00	0.00
free buffer inspected	268,340	446.37	3.20
free buffer requested	279,268	464.55	3.33
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,455	10.74	0.08
hot buffers moved to head of LRU	173,236	288.17	2.06
immediate (CR) block cleanout applications	10,056	16.73	0.12
immediate (CURRENT) block cleanout applications	29	0.05	0.00
index fetch by key	2,428,896	4,040.33	28.95
index scans kdiixs1	228,970	380.88	2.73
leaf node 90-10 splits	7	0.01	0.00
leaf node splits	9	0.01	0.00
lob reads	4,230	7.04	0.05
lob writes	6,002	9.98	0.07
lob writes unaligned	6,002	9.98	0.07
local undo segment hints helped	0	0.00	0.00
local undo segment hints were stale	0	0.00	0.00
logons cumulative	202	0.34	0.00
messages received	141,420	235.24	1.69
messages sent	141,420	235.24	1.69
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	1,146,442	1,907.04	13.66
opened cursors cumulative	212,831	354.03	2.54
parse count (hard)	833	1.39	0.01
parse count (total)	289,785	482.04	3.45
parse time cpu	2,601	4.33	0.03
parse time elapsed	5,322	8.85	0.06
physical read IO requests	175,183	291.41	2.09
physical read bytes	2,873,966,592	4,780,677.77	34,250.59
physical read total IO requests	176,124	292.97	2.10
physical read total bytes	2,889,195,520	4,806,010.22	34,432.08
physical read total multi block requests	53	0.09	0.00
physical reads	175,413	291.79	2.09
physical reads cache	175,396	291.76	2.09
physical reads cache prefetch	230	0.38	0.00
physical reads direct	17	0.03	0.00
physical reads direct (lob)	5	0.01	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	78,040	129.82	0.93
physical write bytes	1,968,766,976	3,274,930.39	23,462.84
physical write total IO requests	174,013	289.46	2.07
physical write total bytes	2,371,225,088	3,944,396.26	28,259.15
physical write total multi block requests	149,670	248.97	1.78
physical writes	120,164	199.89	1.43
physical writes direct	21	0.03	0.00
physical writes from cache	120,143	199.85	1.43
physical writes non checkpoint	101,846	169.41	1.21
pinned buffers inspected	2	0.00	0.00
prefetch clients - default	5	0.01	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
process last non-idle time	610	1.01	0.01
recovery blocks read	0	0.00	0.00
recursive calls	2,237,522	3,721.99	26.67
recursive cpu usage	58,344	97.05	0.70
redo blocks read for recovery	0	0.00	0.00
redo blocks written	754,924	1,255.77	9.00
redo buffer allocation retries	52	0.09	0.00
redo entries	763,104	1,269.38	9.09
redo log space requests	77	0.13	0.00
redo log space wait time	545	0.91	0.01
redo ordering marks	2,686	4.47	0.03
redo size	344,548,880	573,137.20	4,106.17
redo synch time	41,791	69.52	0.50
redo synch writes	202,130	336.23	2.41
redo wastage	28,730,264	47,791.14	342.39
redo write time	19,859	33.03	0.24
redo writer latching time	182	0.30	0.00
redo writes	132,447	220.32	1.58
rollback changes - undo records applied	419,790	698.30	5.00
rollbacks only - consistent read gets	4,108	6.83	0.05
rows fetched via callback	2,068,388	3,440.64	24.65
session connect time	0	0.00	0.00
session cursor cache hits	203,636	338.74	2.43
session logical reads	10,975,798	18,257.61	130.80
session pga memory	327,680	545.08	3.91
session pga memory max	262,144	436.06	3.12
session uga memory	5,197,072	8,645.03	61.94
session uga memory max	90,078,580	149,840.53	1,073.51
shared hash latch upgrades - no wait	260,363	433.10	3.10
shared hash latch upgrades - wait	78	0.13	0.00
sorts (memory)	12,896	21.45	0.15
sorts (rows)	135,424	225.27	1.61
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	419	0.70	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	324,884	540.43	3.87
switch current to new buffer	19	0.03	0.00
table fetch by rowid	28,094,728	46,733.96	334.82
table fetch continued row	230	0.38	0.00
table scan blocks gotten	38,401	63.88	0.46
table scan rows gotten	188,512	313.58	2.25
table scans (short tables)	1,085	1.80	0.01
total number of times SMON posted	74	0.12	0.00
transaction rollbacks	83,958	139.66	1.00
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	95,248,444	158,440.30	1,135.13
user I/O wait time	363,637	604.89	4.33
user calls	389,813	648.43	4.65
user commits	83,910	139.58	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	10,403	17.30	0.12
write clones created in foreground	31	0.05	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	15,796	18,231
opened cursors current	377	367
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)	3	17.97

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	171,864	286	20.43	1.00	17,397	29	8,543	4.40
UNDOTBS1	4	0	55.00	1.00	60,018	100	214	1.40
SYSTEM	1,829	3	24.73	1.01	27	0	19	4.74
SYSAUX	758	1	56.29	1.29	216	0	0	0.00
TEMP	62	0	46.45	1.00	2	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	758	1	56.29	1.29	216	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	1,829	3	24.73	1.01	27	0	19	4.74
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	62	0	46.45	1.00	2	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	4	0	55.00	1.00	60,018	100	214	1.40
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	171,864	286	20.43	1.00	17,397	29	8,543	4.40

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,774	98	10,972,249	175,051	119,903	0	0	8,808

Advisory Statistics

Instance Recovery Stats
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	74	13684	391660	1290240	1290240	1924674
E	0	73	13817	387342	1290240	1290240	2092967

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.79	7,437,182
D	136	0.19	8,568	2.86	3,667,915
D	204	0.29	12,852	2.25	2,883,445
D	272	0.38	17,136	1.89	2,423,335
D	340	0.48	21,420	1.63	2,090,534
D	408	0.57	25,704	1.45	1,855,415
D	476	0.67	29,988	1.31	1,683,879
D	544	0.76	34,272	1.20	1,544,785
D	612	0.86	38,556	1.11	1,427,307
D	680	0.96	42,840	1.03	1,325,121
D	712	1.00	44,856	1.00	1,283,902
D	748	1.05	47,124	0.96	1,237,432
D	816	1.15	51,408	0.90	1,159,660
D	884	1.24	55,692	0.85	1,094,535
D	952	1.34	59,976	0.81	1,040,898
D	1,020	1.43	64,260	0.77	994,936
D	1,088	1.53	68,544	0.74	955,556
D	1,156	1.62	72,828	0.72	921,446
D	1,224	1.72	77,112	0.69	892,031
D	1,292	1.81	81,396	0.68	867,369
D	1,360	1.91	85,680	0.66	846,117

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	173	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	61	77.04	0.00	0.00	0.00	0.00	21,094
E	103	62	77.36	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	10,157	10,157
64K	128K	3	3
512K	1024K	254	254

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,276.29	33.29	97.00	16
26	0.25	1,276.29	33.29	97.00	15
52	0.50	1,276.29	0.00	100.00	0
77	0.75	1,276.29	0.00	100.00	0
103	1.00	1,276.29	0.00	100.00	0
124	1.20	1,276.29	0.00	100.00	0
144	1.40	1,276.29	0.00	100.00	0
165	1.60	1,276.29	0.00	100.00	0
185	1.80	1,276.29	0.00	100.00	0
206	2.00	1,276.29	0.00	100.00	0
309	3.00	1,276.29	0.00	100.00	0
412	4.00	1,276.29	0.00	100.00	0
618	6.00	1,276.29	0.00	100.00	0
824	8.00	1,276.29	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	7	950	1,292,124	0.97	42,123	88.87	4,473,658
56	0.78	14	1,538	1,312,800	0.98	21,447	45.25	4,476,754
64	0.89	21	1,974	1,321,527	0.99	12,720	26.84	4,479,754
72	1.00	28	2,538	1,333,773	1.00	474	1.00	4,482,010
80	1.11	35	2,956	1,338,325	1.00	1	0.00	4,483,278
88	1.22	42	3,417	1,341,465	1.01	1	0.00	4,483,983
96	1.33	49	3,856	1,342,494	1.01	1	0.00	4,484,292
104	1.44	57	4,317	1,342,819	1.01	1	0.00	4,484,463
112	1.56	62	4,868	1,342,883	1.01	1	0.00	4,484,524
120	1.67	62	4,868	1,342,889	1.01	1	0.00	4,484,527
128	1.78	62	4,868	1,342,889	1.01	1	0.00	4,484,528
136	1.89	62	4,868	1,342,889	1.01	1	0.00	4,484,529
144	2.00	62	4,868	1,342,889	1.01	1	0.00	4,484,529

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	159,018	3,677,010
400	0.50	80,959	2,429,246
600	0.75	59,852	1,687,795
800	1.00	48,422	1,287,018
1,000	1.25	41,993	1,043,514
1,200	1.50	38,107	923,564
1,400	1.75	35,963	848,145
1,600	2.00	35,970	848,145

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,570	38	4
undo header	198	0	1
undo block	14	0	1
1st level bmb	15	0	0
file header block	2	0	0
segment header	1	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,084	9,085	9,077	177	19.54
HW-Segment High Water Mark	812	812	7	0	60.00
SQ-Sequence Cache	27	27	1	0	160.00
FB-Format Block	71	71	5	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	83.79	168,789	0	12	13.1833333333333333333333333333333333333/13.183333333333333333333333333333333333	0/0	0/0/0/2/408/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
11-Apr 12:57	83,794	168,789	0	12	13	0/0	0/0/0/2/408/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	132,406	0.02	0.24	0	0
FIB s.o chain latch	4	0.00		0	0
FOB s.o list latch	848	0.00		0	0
In memory undo latch	1,624,134	0.74	0.08	2	168,090	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
KMG resize request state object freelist	2	0.00		0	0
KTF sga latch	2	0.00		0	202	0.00
KWQMN job cache list latch	8	0.00		0	0
MQL Tracking Latch	0			0	12	0.00
Memory Management Latch	20	0.00		0	201	0.00
OS process	609	0.00		0	0
OS process allocation	607	0.00		0	0
OS process: request allocation	398	0.00		0	0
PL/SQL warning settings	193,605	0.40	0.00	0	0
SGA IO buffer pool latch	9,539	0.00		0	9,598	0.00
SQL memory manager latch	1	0.00		0	199	0.00
SQL memory manager workarea list latch	14,931	0.00		0	0
Shared B-Tree	22	0.00		0	0
Undo Hint Latch	0			0	2	0.00
active checkpoint queue latch	8,681	0.00		0	0
active service list	2,447	0.00		0	261	0.00
archive control	6	0.00		0	0
begin backup scn array	2	0.00		0	0
buffer pool	4	0.00		0	0
cache buffer handles	1,416	0.00		0	0
cache buffers chains	23,078,493	0.10	0.02	1	275,812	0.07
cache buffers lru chain	371,181	0.21	0.01	0	290,314	0.78
cache table scan latch	0			0	49	0.00
channel handle pool latch	400	0.00		0	0
channel operations parent latch	5,471	0.00		0	0
checkpoint queue latch	198,482	0.00	0.00	0	113,527	0.02
client/application info	1,012	0.00		0	0
commit callback allocation	4	0.00		0	0
compile environment latch	203,469	0.11	0.00	0	0
dml lock allocation	1,177,718	0.95	0.03	1	0
dummy allocation	398	0.00		0	0
enqueue hash chains	1,560,198	0.62	0.05	1	1,351	0.22
enqueues	238,316	0.23	0.01	0	0
event group latch	199	0.00		0	0
file cache latch	1,097	0.00		0	0
global KZLD latch for mem in SGA	197	0.00		0	0
hash table column usage latch	307	0.00		0	36,583	0.00
hash table modification latch	1	0.00		0	0
job_queue_processes parameter latch	10	0.00		0	0
kks stats	2,291	0.00		0	0
ksuosstats global area	42	0.00		0	0
ktm global data	205	0.00		0	0
kwqbsn:qsga	22	0.00		0	0
lgwr LWN SCN	132,417	0.01	0.00	0	0
library cache	1,587,852	0.48	0.02	0	4,090	0.10
library cache load lock	3,521	0.03	0.00	0	7	0.00
library cache lock	391,458	0.27	0.01	0	0
library cache lock allocation	3,765	0.03	0.00	0	0
library cache pin	774,086	0.44	0.02	0	0
library cache pin allocation	719	0.00		0	0
list of block allocation	398	0.00		0	0
loader state object freelist	60	0.00		0	0
message pool operations parent latch	2	0.00		0	0
messages	435,199	0.07	0.06	0	0
mostly latch-free SCN	132,890	0.10	0.06	0	0
multiblock read objects	100	0.00		0	0
ncodef allocation latch	13	0.00		0	0
object queue header heap	18,159	0.00		0	803	0.00
object queue header operation	908,792	0.04	0.06	0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	80	0.00		0	0
parameter list	711	0.00		0	0
parameter table allocation management	201	0.00		0	0
post/wait queue	147,440	0.02	0.13	0	96,403	0.24
process allocation	398	0.00		0	199	0.00
process group creation	398	0.00		0	0
qmn task queue latch	84	0.00		0	0
redo allocation	739,162	0.22	0.16	0	764,832	1.20
redo copy	0			0	768,492	0.63
redo writing	414,087	0.00	0.12	0	0
resmgr group change latch	202	0.00		0	0
resmgr:actses active list	395	0.00		0	0
resmgr:actses change group	197	0.00		0	0
resmgr:free threads list	394	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	1,435,489	0.39	0.01	0	2,230	0.00
rules engine aggregate statistics	1	0.00		0	0
rules engine rule set statistics	2	0.00		0	0
sequence cache	1,055	0.00		0	0
session allocation	736,272	0.37	0.01	0	0
session idle bit	982,832	0.05	0.02	0	0
session state list latch	402	0.00		0	0
session switching	13	0.00		0	0
session timer	261	0.00		0	0
shared pool	102,143	0.25	0.02	0	0
shared pool sim alloc	6	0.00		0	0
shared pool simulator	83,464	0.00		0	0
simulator hash latch	649,122	0.00	0.00	0	0
simulator lru latch	608,432	0.19	0.07	0	16,569	0.00
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	97	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	36	0.00		0	0
transaction allocation	400	0.00		0	0
transaction branch allocation	13	0.00		0	0
undo global data	1,056,839	0.11	0.01	0	0
user lock	788	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	23,078,493	21,932	444	21,491
In memory undo latch	1,624,134	12,049	930	11,127
dml lock allocation	1,177,718	11,143	304	10,842
enqueue hash chains	1,560,198	9,704	478	9,233
library cache	1,587,852	7,637	186	7,451
row cache objects	1,435,489	5,577	83	5,495
library cache pin	774,086	3,408	63	3,345
session allocation	736,272	2,731	38	2,694
redo allocation	739,162	1,627	259	1,368
undo global data	1,056,839	1,186	14	1,172
simulator lru latch	608,432	1,172	78	1,095
library cache lock	391,458	1,049	8	1,041
cache buffers lru chain	371,181	770	10	761
enqueues	238,316	546	7	539
session idle bit	982,832	532	9	523
object queue header operation	908,792	408	26	382
messages	435,199	323	19	304
shared pool	102,143	258	5	253
mostly latch-free SCN	132,890	130	8	122
post/wait queue	147,440	30	4	26
Consistent RBA	132,406	21	5	16
redo writing	414,087	17	2	15
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	659	799
In memory undo latch	kticmt: child	92	4
In memory undo latch	ktichg: child	85	99
In memory undo latch	ktiTxnPoolFree	81	1
In memory undo latch	kturbk	13	27
cache buffers chains	kcbgtcr: fast path	279	251
cache buffers chains	kcbgcur: kslbegin	101	150
cache buffers chains	kcbgtcr: kslbegin excl	59	20
cache buffers chains	kcbchg: kslbegin: bufs not pinned	52	101
cache buffers chains	kcbgtcr: kslbegin shared	29	1
cache buffers chains	kcbzgb: scan from tail. nowait	25	0
cache buffers chains	kcbnew: new latch again	23	3
cache buffers chains	kcbnlc	12	25
cache buffers chains	kcbrls: kslbegin	10	9
cache buffers chains	kcbgtcr	8	0
cache buffers chains	kcb_pre_apply: kcbhq61	7	20
cache buffers chains	kcbchg: kslbegin: call CR func	7	47
cache buffers chains	kcbget: exchange rls	5	0
cache buffers chains	kcbso1: set no access	5	0
cache buffers chains	kcb_post_apply: kcbhq62	4	1
cache buffers chains	kcbbxsv	4	3
cache buffers chains	kcbget: pin buffer	4	4
cache buffers chains	kcbzwb	4	1
cache buffers chains	kcbget: exchange	3	0
cache buffers chains	kcbzib: finish free bufs	2	5
cache buffers chains	kcbzib: multi-block read: nowait	1	0
cache buffers lru chain	kcbzgws	10	3
dml lock allocation	ktaiam	195	234
dml lock allocation	ktaidm	112	73
enqueue hash chains	ksqrcl	252	137
enqueue hash chains	ksqgtl3	223	334
enqueue hash chains	ksqcmi: get hash chain latch after wait	2	7
enqueue hash chains	ksucallcbksafely: ksqhngcbk1	1	0
enqueues	ksqies	4	6
enqueues	ksqdel	3	0
library cache	kglpndl: child: after processing	68	0
library cache	kglpnp: child	56	95
library cache	kgldte: child 0	16	21
library cache	kglLockCursor	13	6
library cache	kglobpn: child:	9	0
library cache	kglpndl: child: before processing	7	63
library cache	kglhdgn: child:	4	0
library cache	kgldti: 2child	2	1
library cache	kglic	2	0
library cache	kglpin	1	0
library cache	kglrtl	1	0
library cache lock	kgllkal: child: multiinstance	7	0
library cache lock	kgllkdl: child: cleanup	1	8
library cache pin	kglpnp: child	33	45
library cache pin	kglpndl	30	18
messages	ksaamb: after wakeup	12	11
messages	ksarcv: after wait	4	0
messages	ksarcv	3	8
mostly latch-free SCN	kcs04	5	8
mostly latch-free SCN	kcs01	3	5
mostly latch-free SCN	kcs05	3	0
mostly latch-free SCN	kcsnew_scn_rba	2	0
object queue header operation	kcbw_link_q	13	0
object queue header operation	kcbo_switch_cq	6	23
object queue header operation	kcbw_unlink_q	5	3
object queue header operation	kcbo_switch_q_bg	2	0
post/wait queue	ksliwat:add:nowait	3	0
post/wait queue	ksliwat:remove	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	248	0
redo allocation	kcrfw_redo_gen: redo allocation 3	8	6
redo allocation	kcrfw_redo_write: before write	3	138
redo writing	kcrfw_cal_target_rba	1	2
redo writing	kcrfwcr	1	0
row cache objects	kqreqd: reget	47	0
row cache objects	kqrpre: find obj	31	78
row cache objects	kqreqd	5	5
session allocation	ksuprc	19	0
session allocation	ksudlc	9	0
session allocation	ksucri	7	37
session allocation	ksuxds: not user session	3	1
session idle bit	ksupuc: clear busy	4	6
session idle bit	ksupuc: set busy	4	1
session idle bit	ksuxds	2	3
shared pool	kghfrunp: clatch: nowait	7	0
shared pool	kghalo	2	1
shared pool	kghupr1	2	4
shared pool	kghfrunp: alloc: session dur	1	0
simulator lru latch	kcbs_simulate: simulate set	78	77
slave class create	ksvcreate	1	0
undo global data	ktudnx:child	9	3
undo global data	ktudba: KSLBEGIN	3	4
undo global data	ktufrbs: child	1	7
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: 10,975,798
Captured Segments account for 83.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	3,294,160	30.01
TPCC	USERS	STOCK	TABLE	1,647,184	15.01
TPCC	USERS	CUSTOMER_I2	INDEX	688,880	6.28
TPCC	USERS	CUSTOMER	TABLE	653,360	5.95
TPCC	USERS	CUSTOMER_I1	INDEX	488,432	4.45

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 175,413
Captured Segments account for 98.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	ITEM_ID	INDEX	81,382	46.39
TPCC	USERS	ITEM	TABLE	45,309	25.83
TPCC	USERS	CUSTOMER	TABLE	23,028	13.13
TPCC	USERS	STOCK	TABLE	18,868	10.76
TPCC	USERS	HISTORY	TABLE	811	0.46

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	9,742	52.88
TPCC	USERS	WAREHOUSE		TABLE	8,680	47.12

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,169	83.91
TPCC	USERS	HISTORY	TABLE	644	8.76
TPCC	USERS	WAREHOUSE	TABLE	399	5.43
TPCC	USERS	DISTRICT	TABLE	123	1.67
TPCC	USERS	INORD	INDEX	15	0.20

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	15	0.00	2	1
dc_global_oids	136	17.65	0	2
dc_histogram_data	13,238	11.44	0	789
dc_histogram_defs	17,984	18.34	0	894
dc_object_grants	47	19.15	0	9
dc_object_ids	8,584	5.31	0	230
dc_objects	4,306	12.96	0	213
dc_profiles	198	0.00	0	1
dc_rollback_segments	284	0.00	0	23
dc_segments	4,676	15.91	3	175
dc_sequences	26	19.23	26	1
dc_tablespace_quotas	1	100.00	0	1
dc_tablespaces	428,316	0.00	0	5
dc_usernames	598	0.33	0	2
dc_users	8,216	0.06	0	14
outstanding_alerts	13	76.92	1	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	10	30.00	92,918	0.02	13
CLUSTER	41	4.88	91	3.30	1
INDEX	72	44.44	234	18.38	11
SQL AREA	855	74.50	1,563,240	0.14	161
TABLE/PROCEDURE	1,819	24.52	294,339	0.57	432

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	62.98		2.25	5.01	22	22	28	28
	Freeable	9.13	0.00	0.83	0.33	1		11	11
	SQL	1.68	0.80	0.08	0.03	0	5	22	22
	PL/SQL	1.20	0.64	0.04	0.05	0	0	28	28
E	Other	63.92		2.28	5.00	22	22	28	28
	Freeable	8.69	0.00	0.72	0.37	1		12	12
	SQL	1.55	0.67	0.07	0.03	0	5	22	22
	PL/SQL	1.21	0.49	0.04	0.05	0	0	28	28

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	742,391,808	746,586,112
Fixed Size	1,263,572
Redo Buffers	7,122,944
Variable Size	88,082,476	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	CCursor	1.01		-100.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.78	14.72	-0.42
shared	KGLS heap	1.28	1.05	-18.01
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	13.87	12.09	-12.81
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	library cache	2.87	2.92	1.83
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.29	2.44	-25.92
	buffer_cache	708.00	712.00	0.56
	fixed_sga	1.21	1.21	0.00
	log_buffer	6.79	6.79	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

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

End of Report

% Blocks changed per Read:	24.87	Recursive Call %:	85.16
Rollback per transaction %:	0.00	Rows per Sort:	10.50

Buffer Nowait %:	99.92	Redo NoWait %:	99.99
Buffer Hit %:	98.40	In-memory Sort %:	100.00
Library Hit %:	99.80	Soft Parse %:	99.71
Execute to Parse %:	78.77	Latch Hit %:	99.79
Parse CPU to Parse Elapsd %:	48.87	% Non-Parse CPU:	97.47