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: 425 11-Apr-06 09:40:26 29 11.8

End Snap: 426 11-Apr-06 09:50:30 29 12.2

Elapsed: 10.07 (mins)

DB Time: 95.08 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	425	11-Apr-06 09:40:26	29	11.8
End Snap:	426	11-Apr-06 09:50:30	29	12.2
Elapsed:		10.07 (mins)
DB Time:		95.08 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 234,681.21 4,130.71

Logical reads: 7,570.68 133.25

Block changes: 1,835.15 32.30

Physical reads: 117.92 2.08

Physical writes: 87.84 1.55

User calls: 264.32 4.65

Parses: 198.53 3.49

Hard parses: 1.05 0.02

Sorts: 11.21 0.20

Logons: 0.13 0.00

Executes: 931.16 16.39

Transactions: 56.81

	Per Second	Per Transaction
Redo size:	234,681.21	4,130.71
Logical reads:	7,570.68	133.25
Block changes:	1,835.15	32.30
Physical reads:	117.92	2.08
Physical writes:	87.84	1.55
User calls:	264.32	4.65
Parses:	198.53	3.49
Hard parses:	1.05	0.02
Sorts:	11.21	0.20
Logons:	0.13	0.00
Executes:	931.16	16.39
Transactions:	56.81

% Blocks changed per Read: 24.24 Recursive Call %: 85.88

Rollback per transaction %: 0.00 Rows per Sort: 10.77

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 99.99

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

Library Hit %: 99.63 Soft Parse %: 99.47

Execute to Parse %: 78.68 Latch Hit %: 99.95

Parse CPU to Parse Elapsd %: 23.51 % Non-Parse CPU: 97.04

Shared Pool Statistics

Begin End

Memory Usage %: 78.61 82.43

% SQL with executions>1: 79.20 72.84

% Memory for SQL w/exec>1: 73.65 82.42

	Begin	End
Memory Usage %:	78.61	82.43
% SQL with executions>1:	79.20	72.84
% Memory for SQL w/exec>1:	73.65	82.42

Top 5 Timed Events

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

db file sequential read 71,086 5,009 70 87.8 User I/O

enq: TX - row lock contention 4,848 425 88 7.4 Application

CPU time 302 5.3

log file parallel write 65,998 53 1 .9 System I/O

log file sync 35,132 39 1 .7 Commit

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	71,086	5,009	70	87.8	User I/O
enq: TX - row lock contention	4,848	425	88	7.4	Application
CPU time		302		5.3
log file parallel write	65,998	53	1	.9	System I/O
log file sync	35,132	39	1	.7	Commit

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): 5705s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	5,618.01	98.47
DB CPU	301.92	5.29
PL/SQL execution elapsed time	37.27	0.65
parse time elapsed	34.22	0.60
hard parse elapsed time	23.40	0.41
PL/SQL compilation elapsed time	6.09	0.11
connection management call elapsed time	1.76	0.03
repeated bind elapsed time	0.44	0.01
hard parse (sharing criteria) elapsed time	0.10	0.00
sequence load elapsed time	0.01	0.00
DB time	5,705.04
background elapsed time	400.16
background cpu time	44.10

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	71,393	0.00	5,022	70	2.08
Application	73,128	0.00	448	6	2.13
System I/O	67,109	0.00	75	1	1.95
Commit	35,132	0.00	39	1	1.02
Concurrency	1,276	41.85	14	11	0.04
Configuration	33	0.00	2	68	0.00
Network	80,568	0.00	1	0	2.35
Other	447	0.67	1	1	0.01

Back to Wait Events Statistics
Back to Top

Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file sequential read	71,086	0.00	5,009	70	2.07
enq: TX - row lock contention	4,848	0.00	425	88	0.14
log file parallel write	65,998	0.00	53	1	1.92
log file sync	35,132	0.00	39	1	1.02
SQL*Net break/reset to client	68,280	0.00	24	0	1.99
control file parallel write	284	0.00	21	75	0.01
read by other session	286	0.00	13	45	0.01
cursor: pin S wait on X	534	99.81	6	12	0.02
library cache load lock	23	0.00	3	151	0.00
buffer busy waits	585	0.17	3	5	0.02
log file switch completion	18	0.00	2	104	0.00
db file scattered read	9	0.00	1	99	0.00
SQL*Net message to client	80,237	0.00	1	0	2.34
control file sequential read	823	0.00	1	1	0.02
enq: HW - contention	14	0.00	0	28	0.00
enq: TX - contention	4	0.00	0	80	0.00
latch: cache buffers chains	50	0.00	0	5	0.00
latch: In memory undo latch	47	0.00	0	4	0.00
kksfbc child completion	2	100.00	0	53	0.00
os thread startup	2	0.00	0	49	0.00
LGWR wait for redo copy	318	0.31	0	0	0.01
latch free	25	0.00	0	3	0.00
row cache lock	6	0.00	0	11	0.00
latch: enqueue hash chains	32	0.00	0	1	0.00
latch: library cache	13	0.00	0	3	0.00
log file sequential read	2	0.00	0	16	0.00
SQL*Net more data to client	316	0.00	0	0	0.01
latch: shared pool	6	0.00	0	2	0.00
log file single write	2	0.00	0	6	0.00
latch: redo allocation	22	0.00	0	0	0.00
latch: messages	2	0.00	0	3	0.00
latch: cache buffers lru chain	2	0.00	0	3	0.00
latch: undo global data	1	0.00	0	5	0.00
latch: row cache objects	5	0.00	0	1	0.00
latch: library cache pin	4	0.00	0	1	0.00
latch: session allocation	2	0.00	0	1	0.00
cursor: pin S	32	0.00	0	0	0.00
latch: object queue header operation	3	0.00	0	0	0.00
enq: FB - contention	2	0.00	0	1	0.00
SQL*Net more data from client	15	0.00	0	0	0.00
latch: library cache lock	1	0.00	0	0	0.00
direct path write	8	0.00	0	0	0.00
direct path read	4	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
SQL*Net message from client	80,238	0.00	1,284	16	2.34
Streams AQ: waiting for messages in the queue	120	100.00	586	4883	0.00
Streams AQ: qmn slave idle wait	21	0.00	574	27346	0.00
Streams AQ: qmn coordinator idle wait	42	50.00	574	13673	0.00
Streams AQ: waiting for time management or cleanup tasks	2	100.00	434	216962	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	66,016	0.00	53	1	1.92
control file parallel write	284	0.00	21	75	0.01
control file sequential read	135	0.00	0	2	0.00
os thread startup	2	0.00	0	49	0.00
events in waitclass Other	344	0.29	0	0	0.01
latch: cache buffers chains	4	0.00	0	9	0.00
log file sequential read	2	0.00	0	16	0.00
read by other session	1	0.00	0	25	0.00
db file scattered read	1	0.00	0	13	0.00
log file single write	2	0.00	0	6	0.00
direct path read	4	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
direct path write	6	0.00	0	0	0.00
rdbms ipc message	67,424	2.52	4,637	69	1.96
pmon timer	237	100.00	589	2485	0.01
Streams AQ: qmn slave idle wait	21	0.00	574	27346	0.00
Streams AQ: qmn coordinator idle wait	42	50.00	574	13673	0.00
smon timer	3	66.67	454	151365	0.00
Streams AQ: waiting for time management or cleanup tasks	2	100.00	434	216962	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	37,339
IDLE_TIME	204,028
IOWAIT_TIME	101,832
NICE_TIME	1
SYS_TIME	10,445
USER_TIME	25,210
LOAD	10
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	34,152
NUM_CPUS	4
NUM_CPU_SOCKETS	2

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
TESTIBM	5,663.40	295.50	69,729	4,474,860
SYS$USERS	26.10	4.50	321	41,309
SYS$BACKGROUND	0.00	0.00	1,065	31,072

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	69978	492956	1235	1302	79160	67
SYS$USERS	314	2076	35	39	1131	2
SYS$BACKGROUND	1052	6699	6	14	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
4,393	102	33,910	0.13	76.99	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
4,005	55	33,909	0.12	70.19	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
689	102	33,827	0.02	12.08	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
320	15	3,452	0.09	5.60	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
316	13	3,463	0.09	5.54	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
238	14	20,269	0.01	4.17	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
187	10	33,908	0.01	3.27	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
158	5	33,827	0.00	2.77	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
154	10	33,908	0.00	2.71	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
116	15	3,365	0.03	2.03	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
107	11	33,828	0.00	1.87	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
79	10	3,357	0.02	1.39	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
64	3	13,617	0.00	1.12	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

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	% Total DB Time	SQL Id	SQL Module	SQL Text
102	689	33,827	12.08	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
102	4,393	33,910	76.99	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
55	4,005	33,909	70.19	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
15	320	3,452	5.60	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
15	116	3,365	2.03	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
14	238	20,269	4.17	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
13	316	3,463	5.54	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
11	107	33,828	1.87	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
10	154	33,908	2.71	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
10	187	33,908	3.27	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
10	79	3,357	1.39	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
5	158	33,827	2.77	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
3	64	13,617	1.12	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: 4,574,493
Captured SQL account for 88.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,108,955	3,452	610.94	46.10	15.24	319.71	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
2,107,822	3,463	608.67	46.08	12.84	315.93	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
1,012,539	33,827	29.93	22.13	102.32	689.38	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
786,220	33,910	23.19	17.19	101.90	4392.55	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
338,458	20,269	16.70	7.40	13.75	237.93	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
238,341	33,909	7.03	5.21	55.49	4004.59	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
171,571	33,908	5.06	3.75	9.67	154.38	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
169,779	33,909	5.01	3.71	7.82	10.49	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
138,688	33,908	4.09	3.03	9.61	186.57	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
138,372	33,828	4.09	3.02	10.95	106.73	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
87,505	3,365	26.00	1.91	14.55	116.03	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
70,594	33,827	2.09	1.54	4.61	158.01	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
68,595	33,829	2.03	1.50	3.33	6.55	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
68,099	22,367	3.04	1.49	3.83	25.23	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
67,856	33,910	2.00	1.48	3.61	4.06	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
67,721	33,825	2.00	1.48	2.54	2.75	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
51,021	17,006	3.00	1.12	1.35	1.35	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
51,018	17,006	3.00	1.12	2.71	2.96	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
50,504	16,822	3.00	1.10	2.53	3.21	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 71,254
Captured SQL account for 97.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
54,504	33,910	1.61	76.49	101.90	4392.55	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
52,399	33,909	1.55	73.54	55.49	4004.59	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
7,581	3,452	2.20	10.64	15.24	319.71	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
7,540	3,463	2.18	10.58	12.84	315.93	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
4,435	33,827	0.13	6.22	102.32	689.38	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
3,121	20,269	0.15	4.38	13.75	237.93	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
2,122	3,365	0.63	2.98	14.55	116.03	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
2,049	33,908	0.06	2.88	9.67	154.38	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
1,707	3,357	0.51	2.40	9.53	79.34	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
872	13,617	0.06	1.22	2.88	63.65	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 562,640
Captured SQL account for 97.6% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
33,910	0	0.00	0.13	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
33,910	33,910	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
33,909	33,910	1.00	0.12	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
33,909	33,910	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
33,908	33,910	1.00	0.00	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
33,908	33,910	1.00	0.01	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
33,829	33,829	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
33,828	33,827	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
33,828	33,829	1.00	0.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
33,827	33,827	1.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
33,827	33,828	1.00	0.02	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
33,825	33,828	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
22,367	22,368	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
20,269	147,905	7.30	0.01	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
17,006	17,006	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
17,006	17,006	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
16,822	16,822	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
13,617	13,617	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: 119,961
Captured SQL account for 96.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
33,910	33,910	28.27	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
33,909	33,909	28.27	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
33,827	33,827	28.20	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
3,452	3,452	2.88	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
3,374	3,374	2.81	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
3,365	3,365	2.81	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
468	468	0.39	2ym6hhaq30r73		select type#, blocks, extents,...
230	613	0.19	3c1kubcdjnppq		update sys.col_usage$ set eq...
230	230	0.19	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
199	199	0.17	asvzxj61dc5vs		select timestamp, flags from ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

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

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

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

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

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

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

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

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

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

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

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

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

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

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

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

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

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

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

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

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

SQL Id	SQL Text
13dn4hkrzfpdy	SELECT COUNT(DISTINCT (S_I_ID)) FROM ORDER_LINE, STOCK WHERE OL_W_ID = :B2 AND OL_D_ID = :B4 AND (OL_O_ID < :B3 ) AND OL_O_ID >= (:B3 - 20) AND S_W_ID = :B2 AND S_I_ID = OL_I_ID AND S_QUANTITY < :B1
16dhat4ta7xs9	begin neword(:no_w_id, :no_max_w_id, :no_d_id, :no_c_id, :no_o_ol_cnt, :no_c_discount, :no_c_last, :no_c_credit, :no_d_tax, :no_w_tax, :no_d_next_o_id, TO_DATE(:timestamp, 'YYYYMMDDHH24MISS')); END;
1bn3cfn6n3xv5	SELECT C_DATA FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
2k7k32av19mqz	SELECT C_FIRST, C_MIDDLE, C_LAST, C_STREET_1, C_STREET_2, C_CITY, C_STATE, C_ZIP, C_PHONE, C_CREDIT, C_CREDIT_LIM, C_DISCOUNT, C_BALANCE, C_SINCE FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
4r83hzuhh3yuv	SELECT W_STREET_1, W_STREET_2, W_CITY, W_STATE, W_ZIP, W_NAME FROM WAREHOUSE WHERE W_ID = :B1
4wg725nwpxb1z	SELECT C_FIRST, C_MIDDLE, C_ID, C_STREET_1, C_STREET_2, C_CITY, C_STATE, C_ZIP, C_PHONE, C_CREDIT, C_CREDIT_LIM, C_DISCOUNT, C_BALANCE, C_SINCE FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_LAST = :B1 ORDER BY C_FIRST
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
95yr4xtfr50hx	UPDATE CUSTOMER SET C_BALANCE = :B4 WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
asvzxj61dc5vs	select timestamp, flags from fixed_obj$ where obj#=:1
aw9ttz9acxbc3	BEGIN payment(:p_w_id, :p_d_id, :p_c_w_id, :p_c_d_id, :p_c_id, :byname, :p_h_amount, :p_c_last, :p_w_street_1, :p_w_street_2, :p_w_city, :p_w_state, :p_w_zip, :p_d_street_1, :p_d_street_2, :p_d_city, :p_d_state, :p_d_zip, :p_c_first, :p_c_middle, :p_c_street_1, :p_c_street_2, :p_c_city, :p_c_state, :p_c_zip, :p_c_phone, :p_c_since, :p_c_credit, :p_c_credit_lim, :p_c_discount, :p_c_balance, :p_c_data, TO_DATE(:timestamp, 'YYYYMMDDHH24MISS')); END;
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
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	26,244	43.43	0.76
CPU used when call started	26,181	43.33	0.76
CR blocks created	4,788	7.92	0.14
Cached Commit SCN referenced	601	0.99	0.02
Commit SCN cached	52	0.09	0.00
DB time	647,220	1,071.13	18.85
DBWR checkpoint buffers written	16,847	27.88	0.49
DBWR checkpoints	1	0.00	0.00
DBWR transaction table writes	44	0.07	0.00
DBWR undo block writes	34,347	56.84	1.00
IMU CR rollbacks	4,828	7.99	0.14
IMU Flushes	37,477	62.02	1.09
IMU Redo allocation size	89,319,352	147,821.47	2,601.86
IMU commits	29,865	49.43	0.87
IMU contention	26,884	44.49	0.78
IMU pool not allocated	1,491	2.47	0.04
IMU undo allocation size	181,608,180	300,557.36	5,290.23
IMU- failed to get a private strand	1,491	2.47	0.04
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SQL*Net roundtrips to/from client	80,478	133.19	2.34
active txn count during cleanout	8,838	14.63	0.26
application wait time	45,420	75.17	1.32
background checkpoints completed	1	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	1,893	3.13	0.06
buffer is not pinned count	2,417,417	4,000.77	70.42
buffer is pinned count	18,122,160	29,991.76	527.90
bytes received via SQL*Net from client	90,747,588	150,185.17	2,643.47
bytes sent via SQL*Net to client	35,586,003	58,894.02	1,036.62
calls to get snapshot scn: kcmgss	452,119	748.25	13.17
calls to kcmgas	74,689	123.61	2.18
calls to kcmgcs	2,592	4.29	0.08
change write time	1,155	1.91	0.03
cleanout - number of ktugct calls	8,716	14.42	0.25
cleanouts and rollbacks - consistent read gets	3,495	5.78	0.10
cleanouts only - consistent read gets	108	0.18	0.00
cluster key scan block gets	3,595	5.95	0.10
cluster key scans	2,732	4.52	0.08
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	34,376	56.89	1.00
commit batch/immediate requested	34,376	56.89	1.00
commit cleanout failures: callback failure	153	0.25	0.00
commit cleanout failures: cannot pin	361	0.60	0.01
commit cleanouts	137,824	228.10	4.01
commit cleanouts successfully completed	137,310	227.24	4.00
commit immediate performed	34,376	56.89	1.00
commit immediate requested	34,376	56.89	1.00
commit txn count during cleanout	638	1.06	0.02
concurrency wait time	1,360	2.25	0.04
consistent changes	6,330	10.48	0.18
consistent gets	3,519,070	5,823.98	102.51
consistent gets - examination	2,942,148	4,869.19	85.70
consistent gets from cache	3,519,070	5,823.98	102.51
cursor authentications	261	0.43	0.01
data blocks consistent reads - undo records applied	4,940	8.18	0.14
db block changes	1,108,866	1,835.15	32.30
db block gets	1,055,423	1,746.70	30.74
db block gets direct	9	0.01	0.00
db block gets from cache	1,055,414	1,746.69	30.74
deferred (CURRENT) block cleanout applications	81,435	134.77	2.37
dirty buffers inspected	32,366	53.56	0.94
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	125	0.21	0.00
enqueue releases	321,089	531.39	9.35
enqueue requests	321,104	531.42	9.35
enqueue timeouts	0	0.00	0.00
enqueue waits	4,871	8.06	0.14
execute count	562,640	931.16	16.39
frame signature mismatch	10	0.02	0.00
free buffer inspected	107,741	178.31	3.14
free buffer requested	110,898	183.53	3.23
global undo segment hints helped	0	0.00	0.00
heap block compress	2,816	4.66	0.08
hot buffers moved to head of LRU	64,157	106.18	1.87
immediate (CR) block cleanout applications	3,603	5.96	0.10
immediate (CURRENT) block cleanout applications	12	0.02	0.00
index fetch by key	1,036,243	1,714.96	30.19
index scans kdiixs1	95,951	158.80	2.80
leaf node 90-10 splits	4	0.01	0.00
leaf node splits	5	0.01	0.00
lob reads	284	0.47	0.01
lob writes	140	0.23	0.00
lob writes unaligned	140	0.23	0.00
local undo segment hints were stale	0	0.00	0.00
logons cumulative	81	0.13	0.00
messages received	72,541	120.05	2.11
messages sent	72,541	120.05	2.11
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	475,376	786.74	13.85
opened cursors cumulative	90,912	150.46	2.65
parse count (hard)	637	1.05	0.02
parse count (total)	119,961	198.53	3.49
parse time cpu	893	1.48	0.03
parse time elapsed	3,798	6.29	0.11
physical read IO requests	71,224	117.87	2.07
physical read bytes	1,167,425,536	1,932,062.43	34,006.98
physical read total IO requests	72,066	119.27	2.10
physical read total bytes	1,181,002,752	1,954,532.41	34,402.48
physical read total multi block requests	17	0.03	0.00
physical reads	71,254	117.92	2.08
physical reads cache	71,250	117.92	2.08
physical reads cache prefetch	30	0.05	0.00
physical reads direct	4	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	29,423	48.69	0.86
physical write bytes	869,629,952	1,439,217.58	25,332.22
physical write total IO requests	82,412	136.39	2.40
physical write total bytes	1,044,480,512	1,728,591.24	30,425.60
physical write total multi block requests	74,720	123.66	2.18
physical writes	53,078	87.84	1.55
physical writes direct	13	0.02	0.00
physical writes from cache	53,065	87.82	1.55
physical writes non checkpoint	43,443	71.90	1.27
pinned buffers inspected	2	0.00	0.00
prefetch clients - default	3	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
process last non-idle time	591	0.98	0.02
recovery blocks read	0	0.00	0.00
recursive calls	971,538	1,607.87	28.30
recursive cpu usage	16,287	26.95	0.47
redo blocks read for recovery	0	0.00	0.00
redo blocks written	314,103	519.83	9.15
redo buffer allocation retries	10	0.02	0.00
redo entries	303,971	503.07	8.85
redo log space requests	18	0.03	0.00
redo log space wait time	192	0.32	0.01
redo ordering marks	817	1.35	0.02
redo size	141,803,304	234,681.21	4,130.71
redo synch time	4,287	7.09	0.12
redo synch writes	82,750	136.95	2.41
redo wastage	13,526,924	22,386.75	394.04
redo write time	5,623	9.31	0.16
redo writer latching time	9	0.01	0.00
redo writes	66,420	109.92	1.93
rollback changes - undo records applied	171,880	284.46	5.01
rollbacks only - consistent read gets	1,287	2.13	0.04
rows fetched via callback	878,735	1,454.29	25.60
session connect time	0	0.00	0.00
session cursor cache hits	86,186	142.64	2.51
session logical reads	4,574,493	7,570.68	133.25
session pga memory	1,835,008	3,036.90	53.45
session pga memory max	4,521,984	7,483.78	131.72
session uga memory	2,646,900	4,380.56	77.10
session uga memory max	42,753,484	70,756.03	1,245.40
shared hash latch upgrades - no wait	107,521	177.94	3.13
shared hash latch upgrades - wait	18	0.03	0.00
sorts (memory)	6,773	11.21	0.20
sorts (rows)	72,914	120.67	2.12
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.69	0.01
sql area purged	0	0.00	0.00
steps of tune down ret. in space pressure	0	0.00	0.00
summed dirty queue length	201,086	332.79	5.86
switch current to new buffer	10	0.02	0.00
table fetch by rowid	9,827,918	16,264.98	286.29
table fetch continued row	158	0.26	0.00
table scan blocks gotten	14,673	24.28	0.43
table scan rows gotten	39,144	64.78	1.14
table scans (short tables)	192	0.32	0.01
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	34,376	56.89	1.00
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	39,122,732	64,747.22	1,139.64
user I/O wait time	503,930	833.99	14.68
user calls	159,714	264.32	4.65
user commits	34,329	56.81	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	5,014	8.30	0.15
write clones created in foreground	34	0.06	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	1,099	2,141
opened cursors current	341	353
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)	1	5.96

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	69,544	115	70.60	1.00	7,246	12	813	19.31
UNDOTBS1	2	0	80.00	1.00	21,725	36	25	0.40
SYSTEM	1,043	2	51.90	1.01	14	0	33	19.70
SYSAUX	515	1	74.47	1.05	194	0	0	0.00
TEMP	1	0	390.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	515	1	74.47	1.05	194	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	1,043	2	51.90	1.01	14	0	33	19.70
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	1	0	390.00	1.00	0	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	2	0	80.00	1.00	21,725	36	25	0.40
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	69,544	115	70.60	1.00	7,246	12	813	19.31

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,785	98	4,558,621	71,209	52,877	0	0	875

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	23	10529	132872	1290240	1290240
E	0	25	11775	167622	533438	1290240	533438

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.20	838,801
D	136	0.19	8,568	2.63	424,215
D	204	0.29	12,852	2.08	335,336
D	272	0.38	17,136	1.75	282,500
D	340	0.48	21,420	1.53	247,589
D	408	0.57	25,704	1.39	223,699
D	476	0.67	29,988	1.27	205,207
D	544	0.76	34,272	1.17	189,520
D	612	0.86	38,556	1.09	176,743
D	680	0.96	42,840	1.03	165,488
D	712	1.00	44,856	1.00	161,457
D	748	1.05	47,124	0.97	156,908
D	816	1.15	51,408	0.93	150,001
D	884	1.24	55,692	0.89	144,214
D	952	1.34	59,976	0.86	139,299
D	1,020	1.43	64,260	0.84	135,327
D	1,088	1.53	68,544	0.82	131,886
D	1,156	1.62	72,828	0.80	128,951
D	1,224	1.72	77,112	0.79	126,971
D	1,292	1.81	81,396	0.78	125,309
D	1,360	1.91	85,680	0.77	123,706

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	126	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	71	53.66	0.00	0.00	0.00	0.00	21,094
E	103	71	58.16	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	4,801	4,801
64K	128K	3	3
512K	1024K	196	196

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	258.52	2.80	99.00	5
26	0.25	258.52	2.80	99.00	4
52	0.50	258.52	0.00	100.00	0
77	0.75	258.52	0.00	100.00	0
103	1.00	258.52	0.00	100.00	0
124	1.20	258.52	0.00	100.00	0
144	1.40	258.52	0.00	100.00	0
165	1.60	258.52	0.00	100.00	0
185	1.80	258.52	0.00	100.00	0
206	2.00	258.52	0.00	100.00	0
309	3.00	258.52	0.00	100.00	0
412	4.00	258.52	0.00	100.00	0
618	6.00	258.52	0.00	100.00	0
824	8.00	258.52	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
56	0.78	8	1,118	31,300	1.00	60	1.20	583,661
64	0.89	15	1,805	31,307	1.00	53	1.06	584,585
72	1.00	23	2,498	31,310	1.00	50	1.00	585,163
80	1.11	30	3,260	31,310	1.00	50	1.00	585,246
88	1.22	31	3,615	31,310	1.00	50	1.00	585,260
96	1.33	31	3,615	31,310	1.00	50	1.00	585,260
104	1.44	31	3,615	31,310	1.00	50	1.00	585,260
112	1.56	31	3,615	31,310	1.00	50	1.00	585,260
120	1.67	31	3,615	31,310	1.00	50	1.00	585,260
128	1.78	31	3,615	31,310	1.00	50	1.00	585,260
136	1.89	31	3,615	31,310	1.00	50	1.00	585,260
144	2.00	31	3,615	31,310	1.00	50	1.00	585,260

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	60,228	863,678
400	0.50	17,994	254,938
600	0.75	13,843	195,126
800	1.00	11,499	161,568
1,000	1.25	10,258	143,440
1,200	1.50	9,524	132,777
1,400	1.75	9,152	127,364
1,600	2.00	9,158	127,364

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	842	16	19
undo header	25	0	0
segment header	2	0	0
1st level bmb	1	0	0
2nd level bmb	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)	4,832	4,831	4,829	436	90.32
HW-Segment High Water Mark	39	39	12	0	34.17
TX-Transaction	68,671	68,665	4	0	80.00
FB-Format Block	26	26	2	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	27.63	55,416	0	12	114.633333333333333333333333333333333333/114.63333333333333333333333333333333333	0/0	0/0/0/397/5308/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 09:42	27,633	55,416	0	12	115	0/0	0/0/0/397/5308/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AWR Alerted Metric Element list	2,113	0.00		0
Consistent RBA	66,108	0.00		0
FIB s.o chain latch	8	0.00		0
FOB s.o list latch	379	0.00		0
In memory undo latch	666,362	0.15	0.04	68,620	0.00
JS queue state obj latch	3,630	0.00		0
KMG MMAN ready and startup request latch	201	0.00		0
KMG resize request state object freelist	3	0.00		0
KTF sga latch	1	0.00		202	0.00
KWQMN job cache list latch	2	0.00		0
MQL Tracking Latch	0			12	0.00
Memory Management Latch	40	2.50	0.00	201	0.00
Mutex Stats	1	0.00		0
OS process	261	0.00		0
OS process allocation	375	0.00		0
OS process: request allocation	166	0.00		0
PL/SQL warning settings	78,795	0.04	0.00	0
SGA IO buffer pool latch	3,716	0.00		3,738	0.00
SQL memory manager latch	1	0.00		193	0.00
SQL memory manager workarea list latch	13,950	0.00		0
Shared B-Tree	22	0.00		0
active checkpoint queue latch	6,134	0.00		0
active service list	1,698	0.00		237	0.00
begin backup scn array	2	0.00		0
buffer pool	8	0.00		0
cache buffer handles	545	0.00		0
cache buffers chains	9,466,426	0.02	0.02	111,426	0.01
cache buffers lru chain	159,650	0.04	0.04	114,349	0.15
cache table scan latch	0			9	0.00
channel handle pool latch	168	0.00		0
channel operations parent latch	3,034	0.00		0
checkpoint queue latch	101,055	0.00		49,911	0.01
client/application info	417	0.00		0
compile environment latch	82,611	0.04	0.00	0
dml lock allocation	481,238	0.21	0.02	0
dummy allocation	166	0.00		0
enqueue hash chains	644,136	0.15	0.03	2,886	0.00
enqueues	103,107	0.04	0.08	0
event group latch	83	0.00		0
file cache latch	18	0.00		0
global KZLD latch for mem in SGA	81	0.00		0
hash table column usage latch	273	0.00		13,581	0.01
hash table modification latch	5	0.00		0
job_queue_processes parameter latch	10	0.00		0
kks stats	1,386	0.00		0
ksuosstats global area	42	0.00		0
ktm global data	3	0.00		0
kwqbsn:qsga	22	0.00		0
lgwr LWN SCN	66,109	0.00		0
library cache	660,775	0.10	0.02	2,946	0.00
library cache load lock	2,636	0.00		47	0.00
library cache lock	168,327	0.06	0.01	0
library cache lock allocation	1,632	0.00		0
library cache pin	318,816	0.09	0.01	0
library cache pin allocation	392	0.00		0
list of block allocation	174	0.00		0
loader state object freelist	14	0.00		0
message pool operations parent latch	2	0.00		0
messages	216,723	0.02	0.04	0
mostly latch-free SCN	66,175	0.03	0.00	0
multiblock read objects	18	0.00		0
ncodef allocation latch	11	0.00		0
object queue header heap	12,686	0.00		390	0.00
object queue header operation	383,652	0.01	0.11	0
object stats modification	17	0.00		0
parallel query alloc buffer	80	0.00		0
parameter list	314	0.00		0
parameter table allocation management	87	0.00		0
post/wait queue	54,197	0.01	0.33	35,196	0.09
process allocation	166	0.00		83	0.00
process group creation	166	0.00		0
qmn task queue latch	84	0.00		0
redo allocation	335,216	0.04	0.17	302,153	0.27
redo copy	0			302,512	0.19
redo writing	205,473	0.00	0.25	0
resmgr group change latch	83	0.00		0
resmgr:actses active list	163	0.00		0
resmgr:actses change group	81	0.00		0
resmgr:free threads list	162	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	594,171	0.10	0.01	1,195	0.00
sequence cache	619	0.00		0
session allocation	395,218	0.09	0.01	0
session idle bit	400,535	0.01	0.00	0
session state list latch	166	0.00		0
session switching	11	0.00		0
session timer	237	0.00		0
shared pool	62,293	0.17	0.07	0
shared pool sim alloc	4	0.00		0
shared pool simulator	54,433	0.00		0
simulator hash latch	276,257	0.00	0.00	0
simulator lru latch	259,687	0.04	0.02	6,618	0.00
slave class	2	0.00		0
slave class create	8	12.50	1.00	0
sort extent pool	23	0.00		0
state object free list	2	0.00		0
statistics aggregation	112	0.00		0
temp lob duration state obj allocation	2	0.00		0
threshold alerts latch	36	0.00		0
trace latch	1	0.00		0
transaction allocation	170	0.00		0
transaction branch allocation	11	0.00		0
undo global data	427,822	0.02	0.01	0
user lock	326	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	9,466,426	2,071	50	2,021
In memory undo latch	666,362	1,027	46	981
dml lock allocation	481,238	998	18	980
enqueue hash chains	644,136	940	32	908
library cache	660,775	691	13	678
row cache objects	594,171	594	6	588
session allocation	395,218	345	2	343
library cache pin	318,816	288	4	284
redo allocation	335,216	128	22	106
simulator lru latch	259,687	112	2	110
library cache lock	168,327	105	1	104
shared pool	62,293	105	7	98
undo global data	427,822	97	1	96
cache buffers lru chain	159,650	56	2	54
messages	216,723	45	2	43
enqueues	103,107	39	3	36
object queue header operation	383,652	27	3	24
redo writing	205,473	4	1	3
post/wait queue	54,197	3	1	2
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	ktichg: child	17	2
In memory undo latch	ktiFlush: child	15	32
In memory undo latch	ktiTxnPoolFree	8	0
In memory undo latch	kticmt: child	5	0
In memory undo latch	kturbk	1	14
cache buffers chains	kcbgtcr: fast path	43	16
cache buffers chains	kcbgtcr: kslbegin shared	8	4
cache buffers chains	kcbchg: kslbegin: bufs not pinned	6	24
cache buffers chains	kcbgcur: kslbegin	5	14
cache buffers chains	kcbgtcr: kslbegin excl	5	4
cache buffers chains	kcbnew: new latch again	2	1
cache buffers chains	kcb_pre_apply: kcbhq61	1	0
cache buffers chains	kcbbic2	1	0
cache buffers chains	kcbget: exchange	1	0
cache buffers chains	kcbget: exchange rls	1	0
cache buffers chains	kcbget: pin buffer	1	0
cache buffers lru chain	kcbzgws	2	1
dml lock allocation	ktaiam	14	18
dml lock allocation	ktaidm	4	5
enqueue hash chains	ksqrcl	17	9
enqueue hash chains	ksqgtl3	15	22
enqueues	ksqies	2	2
enqueues	ksqgtl2	1	0
library cache	kglpndl: child: after processing	5	0
library cache	kglhdgn: child:	2	0
library cache	kglpnp: child	2	6
library cache	kglobpn: child:	1	0
library cache	kglpin	1	0
library cache	kglpndl: child: before processing	1	12
library cache lock	kgllkal: child: multiinstance	1	0
library cache pin	kglpndl	2	1
library cache pin	kglpnal: child: alloc space	1	0
library cache pin	kglpnp: child	1	3
messages	ksaamb: after wakeup	1	1
messages	ksarcv	1	1
object queue header operation	kcbo_switch_cq	2	1
object queue header operation	kcbw_unlink_q	1	0
post/wait queue	ksliwat:add:nowait	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	22	0
redo writing	kcrfwcr	1	0
row cache objects	kqrpre: find obj	3	5
row cache objects	kqreqd: reget	2	0
row cache objects	kqrso	1	0
session allocation	ksucri	1	3
session allocation	ksuprc	1	0
shared pool	kghalo	4	5
shared pool	kghfre	2	1
shared pool	kgh: quiesce extents	1	0
shared pool	kghfrunp: clatch: nowait	1	0
simulator lru latch	kcbs_simulate: simulate set	2	2
slave class create	ksvcreate	1	0
undo global data	ktudba: KSLBEGIN	1	1

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 4,574,493
Captured Segments account for 84.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	1,414,960	30.93
TPCC	USERS	STOCK	TABLE	704,112	15.39
TPCC	USERS	CUSTOMER_I2	INDEX	281,920	6.16
TPCC	USERS	CUSTOMER	TABLE	265,888	5.81
TPCC	USERS	CUSTOMER_I1	INDEX	201,584	4.41

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 71,254
Captured Segments account for 98.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	ITEM_ID	INDEX	33,576	47.12
TPCC	USERS	ITEM	TABLE	19,345	27.15
TPCC	USERS	STOCK	TABLE	8,017	11.25
TPCC	USERS	CUSTOMER	TABLE	6,383	8.96
TPCC	USERS	ORDERS	TABLE	1,177	1.65

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	6,504	67.00
TPCC	USERS	WAREHOUSE		TABLE	3,204	33.00

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	450	80.79
TPCC	USERS	WAREHOUSE	TABLE	65	11.67
TPCC	USERS	HISTORY	TABLE	28	5.03
TPCC	USERS	DISTRICT	TABLE	12	2.15
TPCC	USERS	INORD	INDEX	2	0.36

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	14	14.29	2	1
dc_global_oids	69	28.99	0	2
dc_histogram_data	4,098	26.89	0	701
dc_histogram_defs	7,423	33.53	0	858
dc_object_grants	44	20.45	0	9
dc_object_ids	4,739	7.03	0	217
dc_objects	2,101	16.04	0	208
dc_profiles	79	0.00	0	1
dc_rollback_segments	109	0.00	0	23
dc_segments	1,792	26.23	1	152
dc_sequences	17	23.53	17	1
dc_tablespace_quotas	1	100.00	0	0
dc_tablespaces	174,882	0.00	0	4
dc_usernames	274	0.73	0	4
dc_users	4,366	0.07	0	15
outstanding_alerts	13	76.92	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	8	50.00	37,754	0.04	6
CLUSTER	37	2.70	107	0.93	0
INDEX	36	61.11	100	27.00	5
SQL AREA	432	37.73	642,541	0.26	372
TABLE/PROCEDURE	1,103	20.49	121,826	1.02	411

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	44.47		1.53	3.92	22	22	29	29
	Freeable	6.50	0.00	0.81	0.35	1		8	8
	SQL	1.45	0.67	0.06	0.03	0	2	23	22
	PL/SQL	1.25	0.58	0.04	0.05	0	0	29	29
E	Other	46.42		1.60	3.91	22	22	29	29
	Freeable	8.88	0.00	0.68	0.37	1		13	13
	SQL	1.62	0.72	0.07	0.03	0	2	23	22
	PL/SQL	1.25	0.61	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	738,197,504	746,586,112
Fixed Size	1,263,572
Redo Buffers	7,122,944
Variable Size	92,276,780	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	0.93		-100.00
shared	FileOpenBlock	1.58	1.58	0.00
shared	Heap0: KGL	0.84		-100.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGH: NO ACCESS		6.89
shared	KGLS heap	1.21	0.85	-29.57
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KSXR pending messages que	0.80	0.80	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	17.11	12.65	-26.06
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kks stbkt	0.88	0.88	0.00
shared	library cache	3.01	2.90	-3.57
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.44	2.41	-29.98
	buffer_cache	704.00	712.00	1.14
	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.24	Recursive Call %:	85.88
Rollback per transaction %:	0.00	Rows per Sort:	10.77

Buffer Nowait %:	99.98	Redo NoWait %:	99.99
Buffer Hit %:	98.44	In-memory Sort %:	100.00
Library Hit %:	99.63	Soft Parse %:	99.47
Execute to Parse %:	78.68	Latch Hit %:	99.95
Parse CPU to Parse Elapsd %:	23.51	% Non-Parse CPU:	97.04