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: 441 11-Apr-06 12:30:12 30 12.5

End Snap: 442 11-Apr-06 12:40:14 30 11.8

Elapsed: 10.03 (mins)

DB Time: 85.65 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	441	11-Apr-06 12:30:12	30	12.5
End Snap:	442	11-Apr-06 12:40:14	30	11.8
Elapsed:		10.03 (mins)
DB Time:		85.65 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 577,603.68 4,162.75

Logical reads: 18,591.61 133.99

Block changes: 4,557.33 32.84

Physical reads: 288.37 2.08

Physical writes: 193.82 1.40

User calls: 645.24 4.65

Parses: 498.92 3.60

Hard parses: 1.32 0.01

Sorts: 21.15 0.15

Logons: 0.33 0.00

Executes: 2,279.32 16.43

Transactions: 138.76

	Per Second	Per Transaction
Redo size:	577,603.68	4,162.75
Logical reads:	18,591.61	133.99
Block changes:	4,557.33	32.84
Physical reads:	288.37	2.08
Physical writes:	193.82	1.40
User calls:	645.24	4.65
Parses:	498.92	3.60
Hard parses:	1.32	0.01
Sorts:	21.15	0.15
Logons:	0.33	0.00
Executes:	2,279.32	16.43
Transactions:	138.76

% Blocks changed per Read: 24.51 Recursive Call %: 85.69

Rollback per transaction %: 0.00 Rows per Sort: 10.65

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.91 Redo NoWait %: 99.99

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

Library Hit %: 99.81 Soft Parse %: 99.73

Execute to Parse %: 78.11 Latch Hit %: 99.78

Parse CPU to Parse Elapsd %: 46.05 % Non-Parse CPU: 97.57

Shared Pool Statistics

Begin End

Memory Usage %: 81.64 83.04

% SQL with executions>1: 82.28 83.85

% Memory for SQL w/exec>1: 73.98 75.89

	Begin	End
Memory Usage %:	81.64	83.04
% SQL with executions>1:	82.28	83.85
% Memory for SQL w/exec>1:	73.98	75.89

Top 5 Timed Events

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

db file sequential read 174,061 3,515 20 68.4 User I/O

CPU time 1,043 20.3

log file sync 96,710 388 4 7.5 Commit

enq: TX - row lock contention 12,737 226 18 4.4 Application

log file parallel write 133,779 164 1 3.2 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	174,061	3,515	20	68.4	User I/O
CPU time		1,043		20.3
log file sync	96,710	388	4	7.5	Commit
enq: TX - row lock contention	12,737	226	18	4.4	Application
log file parallel write	133,779	164	1	3.2	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): 5139s
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,573.23	88.99
DB CPU	1,043.08	20.30
PL/SQL execution elapsed time	133.29	2.59
parse time elapsed	65.28	1.27
hard parse elapsed time	31.23	0.61
PL/SQL compilation elapsed time	9.52	0.19
connection management call elapsed time	3.60	0.07
repeated bind elapsed time	1.28	0.02
sequence load elapsed time	0.39	0.01
hard parse (sharing criteria) elapsed time	0.36	0.01
DB time	5,139.01
background elapsed time	365.32
background cpu time	96.70

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,308	0.00	3,535	20	2.10
Commit	96,710	0.00	388	4	1.16
Application	181,021	0.00	360	2	2.17
System I/O	142,856	0.00	223	2	1.71
Concurrency	11,565	4.97	33	3	0.14
Other	9,785	0.54	11	1	0.12
Configuration	294	0.00	7	23	0.00
Network	196,670	0.00	2	0	2.36

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,061	0.00	3,515	20	2.08
log file sync	96,710	0.00	388	4	1.16
enq: TX - row lock contention	12,737	0.00	226	18	0.15
log file parallel write	133,779	0.00	164	1	1.60
SQL*Net break/reset to client	168,284	0.00	134	1	2.02
db file parallel write	7,809	0.00	49	6	0.09
buffer busy waits	8,955	0.00	20	2	0.11
read by other session	1,162	0.00	17	15	0.01
control file sequential read	913	0.00	8	9	0.01
cursor: pin S wait on X	577	99.65	7	12	0.01
log file switch completion	67	0.00	5	82	0.00
rdbms ipc reply	3,131	0.00	4	1	0.04
db file scattered read	48	0.00	3	57	0.00
SQL*Net message to client	196,163	0.00	2	0	2.35
library cache load lock	19	0.00	2	111	0.00
control file parallel write	339	0.00	2	6	0.00
latch: In memory undo latch	954	0.00	2	2	0.01
LGWR wait for redo copy	4,312	0.00	2	0	0.05
latch: enqueue hash chains	529	0.00	1	2	0.01
enq: HW - contention	224	0.00	1	5	0.00
latch free	403	0.00	1	2	0.00
enq: US - contention	385	0.00	1	2	0.00
SGA: allocation forcing component growth	66	72.73	1	12	0.00
latch: cache buffers chains	495	0.00	1	2	0.01
latch: library cache	220	0.00	1	3	0.00
latch: redo allocation	289	0.00	0	1	0.00
kksfbc child completion	5	100.00	0	53	0.00
latch: row cache objects	96	0.00	0	3	0.00
row cache lock	2	0.00	0	114	0.00
os thread startup	2	0.00	0	74	0.00
latch: session allocation	79	0.00	0	2	0.00
latch: shared pool	30	0.00	0	4	0.00
cursor: pin S	502	0.00	0	0	0.01
latch: library cache pin	54	0.00	0	1	0.00
latch: undo global data	36	0.00	0	2	0.00
direct path read	16	0.00	0	3	0.00
latch: object queue header operation	23	0.00	0	2	0.00
SQL*Net more data to client	491	0.00	0	0	0.01
latch: library cache lock	9	0.00	0	3	0.00
log file sequential read	8	0.00	0	2	0.00
enq: TX - contention	3	0.00	0	5	0.00
latch: cache buffers lru chain	7	0.00	0	2	0.00
latch: messages	13	0.00	0	1	0.00
direct path write	21	0.00	0	0	0.00
cursor: mutex X	152	0.00	0	0	0.00
log file single write	8	0.00	0	0	0.00
enq: FB - contention	2	0.00	0	1	0.00
SQL*Net more data from client	16	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
undo segment extension	2	0.00	0	0	0.00
SQL*Net message from client	196,160	0.00	1,622	8	2.35
Streams AQ: waiting for messages in the queue	120	100.00	586	4884	0.00
Streams AQ: qmn slave idle wait	21	0.00	574	27347	0.00
Streams AQ: qmn coordinator idle wait	42	50.00	574	13673	0.00
class slave wait	2	0.00	0	1	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	133,764	0.00	164	1	1.60
db file parallel write	7,809	0.00	49	6	0.09
control file sequential read	204	0.00	6	30	0.00
db file sequential read	134	0.00	5	34	0.00
events in waitclass Other	4,601	0.00	2	0	0.06
control file parallel write	339	0.00	2	6	0.00
db file scattered read	4	0.00	0	54	0.00
os thread startup	2	0.00	0	74	0.00
log file switch completion	1	0.00	0	62	0.00
direct path read	16	0.00	0	3	0.00
latch: shared pool	5	0.00	0	5	0.00
log file sequential read	8	0.00	0	2	0.00
direct path write	18	0.00	0	1	0.00
latch: library cache	1	0.00	0	9	0.00
latch: cache buffers chains	8	0.00	0	0	0.00
log file single write	8	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
buffer busy waits	1	0.00	0	0	0.00
rdbms ipc message	129,083	1.34	4,403	34	1.55
smon timer	6	16.67	597	99457	0.00
pmon timer	257	100.00	589	2293	0.00
Streams AQ: qmn slave idle wait	21	0.00	574	27347	0.00
Streams AQ: qmn coordinator idle wait	42	50.00	574	13673	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	117,394
IDLE_TIME	123,510
IOWAIT_TIME	97,873
NICE_TIME	1
SYS_TIME	26,587
USER_TIME	86,142
LOAD	9
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	202,156
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,113.80	1,032.60	172,167	11,135,864
SYS$USERS	35.40	9.60	847	48,550
SYS$BACKGROUND	0.00	0.00	1,223	36,042

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	173268	347008	11537	3328	194791	219
SYS$USERS	832	2303	3	0	1283	3
SYS$BACKGROUND	1209	4324	25	19	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,076	325	83,991	0.04	59.86	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
2,120	133	68,858	0.03	41.25	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
719	306	67,034	0.01	13.99	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
432	55	8,279	0.05	8.41	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
422	47	8,256	0.05	8.22	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
286	61	50,035	0.01	5.57	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
162	39	83,722	0.00	3.16	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
146	60	83,491	0.00	2.83	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
129	51	83,726	0.00	2.51	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
96	53	8,425	0.01	1.86	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
79	22	83,216	0.00	1.53	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
71	13	33,190	0.00	1.38	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
52	21	83,225	0.00	1.01	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
325	3,076	83,991	0.00	59.86	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
306	719	67,034	0.00	13.99	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
133	2,120	68,858	0.00	41.25	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
61	286	50,035	0.00	5.57	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
60	146	83,491	0.00	2.83	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
55	432	8,279	0.01	8.41	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
53	96	8,425	0.01	1.86	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
51	129	83,726	0.00	2.51	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
47	422	8,256	0.01	8.22	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
39	162	83,722	0.00	3.16	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
22	79	83,216	0.00	1.53	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
21	52	83,225	0.00	1.01	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
13	71	33,190	0.00	1.38	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: 11,188,428
Captured SQL account for 88.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
5,040,980	8,279	608.89	45.06	54.91	432.38	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
5,010,155	8,256	606.85	44.78	47.01	422.41	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
2,157,114	67,034	32.18	19.28	306.28	719.12	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
2,087,044	83,991	24.85	18.65	324.86	3076.40	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
834,162	50,035	16.67	7.46	61.16	286.48	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
484,519	83,491	5.80	4.33	59.64	145.59	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
483,834	68,858	7.03	4.32	132.73	2119.60	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
478,087	83,726	5.71	4.27	50.53	129.07	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
427,474	83,722	5.11	3.82	39.36	162.34	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
335,040	66,911	5.01	2.99	31.68	36.02	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
230,432	8,425	27.35	2.06	52.95	95.65	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
171,608	83,216	2.06	1.53	21.59	78.77	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
170,362	83,492	2.04	1.52	12.87	12.98	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
167,694	83,745	2.00	1.50	16.88	19.02	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
167,471	55,067	3.04	1.50	14.45	23.84	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
166,464	83,216	2.00	1.49	10.30	10.36	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
125,136	41,709	3.00	1.12	10.18	10.35	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
124,965	41,655	3.00	1.12	5.47	5.66	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
124,953	41,649	3.00	1.12	10.59	10.95	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
120,398	8,425	14.29	1.08	35.67	48.87	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: 173,539
Captured SQL account for 86.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
133,420	83,991	1.59	76.88	324.86	3076.40	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
104,672	68,858	1.52	60.32	132.73	2119.60	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
19,363	8,279	2.34	11.16	54.91	432.38	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
19,326	8,256	2.34	11.14	47.01	422.41	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
12,731	67,034	0.19	7.34	306.28	719.12	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
12,346	50,035	0.25	7.11	61.16	286.48	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
6,572	83,722	0.08	3.79	39.36	162.34	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
3,019	33,190	0.09	1.74	13.22	70.68	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
1,996	8,425	0.24	1.15	52.95	95.65	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
805	83,225	0.01	0.46	21.07	51.67	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 1,371,694
Captured SQL account for 96.0% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
83,991	0	0.00	0.04	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
83,745	83,745	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
83,726	83,741	1.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
83,722	83,744	1.00	0.00	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
83,492	83,497	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
83,491	83,499	1.00	0.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
83,225	83,228	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
83,216	83,224	1.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
83,216	83,227	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
68,858	68,857	1.00	0.03	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
67,034	67,037	1.00	0.01	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
66,911	66,911	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
55,067	55,069	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
50,035	364,405	7.28	0.01	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
41,709	41,711	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
41,655	41,655	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
41,649	41,654	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
33,190	33,190	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: 300,250
Captured SQL account for 89.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
83,992	83,991	27.97	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
68,854	68,858	22.93	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
67,034	67,034	22.33	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
8,641	8,644	2.88	bsa0wjtftg3uw		select file# from file$ where ...
8,425	8,425	2.81	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
8,307	8,308	2.77	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
8,278	8,279	2.76	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
4,769	4,769	1.59	86708bvah4akq		select name from undo$ where f...
621	621	0.21	2ym6hhaq30r73		select type#, blocks, extents,...
386	55,067	0.13	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	93,397	155.20	1.12
CPU used when call started	93,211	154.89	1.12
CR blocks created	14,366	23.87	0.17
Cached Commit SCN referenced	589	0.98	0.01
Commit SCN cached	1	0.00	0.00
DB time	586,019	973.78	7.02
DBWR checkpoint buffers written	19,966	33.18	0.24
DBWR checkpoints	4	0.01	0.00
DBWR transaction table writes	44	0.07	0.00
DBWR undo block writes	81,677	135.72	0.98
IMU CR rollbacks	13,070	21.72	0.16
IMU Flushes	98,827	164.22	1.18
IMU Redo allocation size	229,817,468	381,883.46	2,752.21
IMU commits	62,374	103.65	0.75
IMU contention	83,601	138.92	1.00
IMU pool not allocated	6,411	10.65	0.08
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	423,572,392	703,842.46	5,072.54
IMU- failed to get a private strand	6,411	10.65	0.08
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for undo segment shrink	4	0.01	0.00
SQL*Net roundtrips to/from client	195,115	324.22	2.34
active txn count during cleanout	24,194	40.20	0.29
application wait time	35,885	59.63	0.43
auto extends on undo tablespace	63	0.10	0.00
background checkpoints completed	4	0.01	0.00
background checkpoints started	4	0.01	0.00
background timeouts	1,919	3.19	0.02
buffer is not pinned count	5,725,249	9,513.54	68.56
buffer is pinned count	52,480,826	87,206.42	628.49
bytes received via SQL*Net from client	220,983,472	367,204.17	2,646.41
bytes sent via SQL*Net to client	85,765,977	142,515.75	1,027.10
calls to get snapshot scn: kcmgss	1,141,841	1,897.38	13.67
calls to kcmgas	191,205	317.72	2.29
calls to kcmgcs	14,838	24.66	0.18
change write time	4,869	8.09	0.06
cleanout - number of ktugct calls	25,271	41.99	0.30
cleanouts and rollbacks - consistent read gets	10,212	16.97	0.12
cleanouts only - consistent read gets	533	0.89	0.01
cluster key scan block gets	4,754	7.90	0.06
cluster key scans	3,717	6.18	0.04
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	83,980	139.55	1.01
commit batch/immediate requested	83,980	139.55	1.01
commit cleanout failures: block lost	4	0.01	0.00
commit cleanout failures: buffer being written	1	0.00	0.00
commit cleanout failures: callback failure	510	0.85	0.01
commit cleanout failures: cannot pin	3,364	5.59	0.04
commit cleanouts	334,600	556.00	4.01
commit cleanouts successfully completed	330,721	549.55	3.96
commit immediate performed	83,980	139.55	1.01
commit immediate requested	83,980	139.55	1.01
commit txn count during cleanout	4,204	6.99	0.05
concurrency wait time	3,347	5.56	0.04
consistent changes	19,507	32.41	0.23
consistent gets	8,412,601	13,979.06	100.75
consistent gets - examination	6,976,930	11,593.44	83.55
consistent gets direct	0	0.00	0.00
consistent gets from cache	8,412,601	13,979.06	100.75
cursor authentications	300	0.50	0.00
data blocks consistent reads - undo records applied	14,880	24.73	0.18
db block changes	2,742,600	4,557.33	32.84
db block gets	2,775,787	4,612.47	33.24
db block gets direct	8	0.01	0.00
db block gets from cache	2,775,779	4,612.46	33.24
deferred (CURRENT) block cleanout applications	200,077	332.46	2.40
dirty buffers inspected	90,958	151.14	1.09
drop segment calls in space pressure	1,585	2.63	0.02
enqueue conversions	55,663	92.49	0.67
enqueue releases	971,158	1,613.76	11.63
enqueue requests	971,173	1,613.78	11.63
enqueue timeouts	0	0.00	0.00
enqueue waits	13,124	21.81	0.16
execute count	1,371,694	2,279.32	16.43
frame signature mismatch	0	0.00	0.00
free buffer inspected	260,124	432.24	3.12
free buffer requested	273,046	453.72	3.27
global undo segment hints helped	50	0.08	0.00
global undo segment hints were stale	10	0.02	0.00
heap block compress	6,540	10.87	0.08
hot buffers moved to head of LRU	165,989	275.82	1.99
immediate (CR) block cleanout applications	10,745	17.85	0.13
immediate (CURRENT) block cleanout applications	9	0.01	0.00
index fetch by key	2,442,594	4,058.81	29.25
index scans kdiixs1	228,065	378.97	2.73
leaf node 90-10 splits	3	0.00	0.00
leaf node splits	3	0.00	0.00
lob reads	341	0.57	0.00
lob writes	147	0.24	0.00
lob writes unaligned	147	0.24	0.00
local undo segment hints helped	147	0.24	0.00
local undo segment hints were stale	318	0.53	0.00
logons cumulative	198	0.33	0.00
messages received	145,449	241.69	1.74
messages sent	145,449	241.69	1.74
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	1,156,201	1,921.24	13.85
opened cursors cumulative	223,418	371.25	2.68
parse count (hard)	797	1.32	0.01
parse count (total)	300,250	498.92	3.60
parse time cpu	2,535	4.21	0.03
parse time elapsed	5,505	9.15	0.07
physical read IO requests	173,431	288.19	2.08
physical read bytes	2,843,262,976	4,724,597.83	34,049.83
physical read total IO requests	174,372	289.75	2.09
physical read total bytes	2,858,320,384	4,749,618.45	34,230.15
physical read total multi block requests	58	0.10	0.00
physical reads	173,539	288.37	2.08
physical reads cache	173,523	288.34	2.08
physical reads cache prefetch	108	0.18	0.00
physical reads direct	16	0.03	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	75,821	125.99	0.91
physical write bytes	1,911,029,760	3,175,523.03	22,885.76
physical write total IO requests	175,009	290.81	2.10
physical write total bytes	2,318,099,456	3,851,943.26	27,760.67
physical write total multi block requests	150,189	249.57	1.80
physical writes	116,640	193.82	1.40
physical writes direct	24	0.04	0.00
physical writes from cache	116,616	193.78	1.40
physical writes non checkpoint	102,878	170.95	1.23
pinned buffers inspected	8	0.01	0.00
prefetch clients - default	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
process last non-idle time	603	1.00	0.01
recovery blocks read	0	0.00	0.00
recursive calls	2,325,045	3,863.48	27.84
recursive cpu usage	59,802	99.37	0.72
redo blocks read for recovery	0	0.00	0.00
redo blocks written	762,557	1,267.13	9.13
redo buffer allocation retries	46	0.08	0.00
redo entries	825,848	1,372.30	9.89
redo log space requests	67	0.11	0.00
redo log space wait time	563	0.94	0.01
redo ordering marks	5,971	9.92	0.07
redo size	347,601,896	577,603.68	4,162.75
redo synch time	40,250	66.88	0.48
redo synch writes	202,718	336.85	2.43
redo wastage	29,454,932	48,944.72	352.74
redo write time	20,066	33.34	0.24
redo writer latching time	212	0.35	0.00
redo writes	133,519	221.87	1.60
rollback changes - undo records applied	419,900	697.74	5.03
rollbacks only - consistent read gets	4,159	6.91	0.05
rows fetched via callback	2,085,935	3,466.16	24.98
session connect time	0	0.00	0.00
session cursor cache hits	213,876	355.39	2.56
session logical reads	11,188,428	18,591.61	133.99
session pga memory	917,504	1,524.60	10.99
session pga memory max	1,114,112	1,851.30	13.34
session uga memory	4,768,136	7,923.12	57.10
session uga memory max	89,649,912	148,969.61	1,073.61
shared hash latch upgrades - no wait	259,169	430.66	3.10
shared hash latch upgrades - wait	82	0.14	0.00
sorts (memory)	12,728	21.15	0.15
sorts (rows)	135,528	225.20	1.62
space was found by tune down	1,562	2.60	0.02
space was not found by tune down	13	0.02	0.00
sql area evicted	394	0.65	0.00
sql area purged	0	0.00	0.00
steps of tune down ret. in space pressure	1,599	2.66	0.02
summed dirty queue length	231,558	384.78	2.77
switch current to new buffer	46	0.08	0.00
table fetch by rowid	28,079,026	46,658.40	336.26
table fetch continued row	201	0.33	0.00
table scan blocks gotten	56,151	93.31	0.67
table scan rows gotten	217,912	362.10	2.61
table scans (short tables)	12,581	20.91	0.15
total number of times SMON posted	5	0.01	0.00
transaction rollbacks	83,980	139.55	1.01
tune down retentions in space pressure	1,575	2.62	0.02
undo change vector size	95,737,408	159,085.09	1,146.51
user I/O wait time	351,547	584.16	4.21
user calls	388,305	645.24	4.65
user commits	83,503	138.76	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	9,924	16.49	0.12
write clones created in foreground	25	0.04	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	10,693	13,270
opened cursors current	375	354
logons current	30	30

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	4	23.93

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,939	286	20.09	1.00	17,913	30	9,008	3.85
UNDOTBS1	8	0	37.50	1.00	58,005	96	1,052	3.17
SYSTEM	1,553	3	24.51	1.01	28	0	12	5.00
SYSAUX	634	1	48.69	1.06	226	0	0	0.00
TEMP	1	0	30.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	634	1	48.69	1.06	226	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	1,553	3	24.51	1.01	28	0	12	5.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	1	0	30.00	1.00	0	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	8	0	37.50	1.00	58,005	96	1,052	3.17
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	171,939	286	20.09	1.00	17,913	30	9,008	3.85

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,787	98	11,188,264	173,707	116,603	0	0	10,114

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	64	10938	362138	1290240	1290240	1365755
E	0	75	13884	393937	1290240	1290240	1659506

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.85	5,466,594
D	136	0.19	8,568	2.86	2,669,086
D	204	0.29	12,852	2.24	2,098,248
D	272	0.38	17,136	1.88	1,761,713
D	340	0.48	21,420	1.62	1,517,266
D	408	0.57	25,704	1.44	1,347,668
D	476	0.67	29,988	1.31	1,222,390
D	544	0.76	34,272	1.20	1,121,408
D	612	0.86	38,556	1.11	1,036,357
D	680	0.96	42,840	1.03	963,880
D	712	1.00	44,856	1.00	934,813
D	748	1.05	47,124	0.97	902,146
D	816	1.15	51,408	0.91	846,733
D	884	1.24	55,692	0.86	800,118
D	952	1.34	59,976	0.81	761,353
D	1,020	1.43	64,260	0.78	728,908
D	1,088	1.53	68,544	0.75	699,793
D	1,156	1.62	72,828	0.72	675,373
D	1,224	1.72	77,112	0.70	654,243
D	1,292	1.81	81,396	0.68	636,201
D	1,360	1.91	85,680	0.66	621,228

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	136	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.17	0.00	0.00	0.00	0.00	21,094
E	103	62	78.42	0.00	0.00	0.00	0.00	21,094

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	9,727	9,727
64K	128K	3	3
512K	1024K	201	201

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	962.82	25.38	97.00	13
26	0.25	962.82	25.38	97.00	12
52	0.50	962.82	0.00	100.00	0
77	0.75	962.82	0.00	100.00	0
103	1.00	962.82	0.00	100.00	0
124	1.20	962.82	0.00	100.00	0
144	1.40	962.82	0.00	100.00	0
165	1.60	962.82	0.00	100.00	0
185	1.80	962.82	0.00	100.00	0
206	2.00	962.82	0.00	100.00	0
309	3.00	962.82	0.00	100.00	0
412	4.00	962.82	0.00	100.00	0
618	6.00	962.82	0.00	100.00	0
824	8.00	962.82	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,043	870,221	0.98	17,868	50.91	3,174,644
64	0.89	15	1,619	881,979	0.99	6,110	17.41	3,177,423
72	1.00	22	2,277	887,738	1.00	351	1.00	3,179,831
80	1.11	29	2,770	891,871	1.00	1	0.00	3,181,271
88	1.22	36	3,272	894,817	1.01	1	0.00	3,182,041
96	1.33	44	3,643	896,422	1.01	1	0.00	3,182,302
104	1.44	51	4,323	896,824	1.01	1	0.00	3,182,368
112	1.56	51	4,556	896,824	1.01	1	0.00	3,182,383
120	1.67	51	4,556	896,824	1.01	1	0.00	3,182,384
128	1.78	51	4,556	896,824	1.01	1	0.00	3,182,384
136	1.89	51	4,556	896,824	1.01	1	0.00	3,182,384
144	2.00	51	4,556	896,824	1.01	1	0.00	3,182,384

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	180,817	5,482,673
400	0.50	64,171	1,767,201
600	0.75	47,190	1,226,051
800	1.00	38,115	937,706
1,000	1.25	33,038	763,855
1,200	1.50	29,980	677,586
1,400	1.75	28,282	623,293
1,600	2.00	28,289	623,293

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	9,032	35	4
file header block	417	2	5
undo header	622	1	2
1st level bmb	15	0	1
undo block	31	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)	12,542	12,544	12,538	232	18.50
HW-Segment High Water Mark	114,505	114,504	207	1	5.85
US-Undo Segment	53,541	53,541	370	1	2.41
TX-Transaction	175,779	175,551	3	0	3.33
FB-Format Block	68	68	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	166.10	341,977	0	12	13.2833333333333333333333333333333333333/16.183333333333333333333333333333333333	0/0	26/0/0/5116/253808/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:47	83,725	174,207	0	11	13	0/0	17/0/0/3554/164896/0
11-Apr 12:37	82,372	167,770	0	12	16	0/0	9/0/0/1562/88912/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	133,742	0.02	0.18	0	0
FIB s.o chain latch	10	0.00		0	0
FOB s.o list latch	850	0.00		0	0
In memory undo latch	1,615,067	0.78	0.08	2	168,030	0.00
JS queue state obj latch	3,600	0.00		0	0
KMG MMAN ready and startup request latch	474	0.00		0	0
KMG resize request state object freelist	16	0.00		0	0
KTF sga latch	1	0.00		0	202	0.00
KWQMN job cache list latch	1	0.00		0	0
MQL Tracking Latch	0			0	12	0.00
Memory Management Latch	344	0.29	0.00	0	468	0.00
OS process	603	0.00		0	0
OS process allocation	604	0.00		0	0
OS process: request allocation	395	0.00		0	0
PL/SQL warning settings	193,359	0.42	0.00	0	0
SGA IO buffer pool latch	9,038	0.00		0	9,038	0.00
SQL memory manager latch	1	0.00		0	199	0.00
SQL memory manager workarea list latch	14,710	0.00		0	0
Shared B-Tree	22	0.00		0	0
Undo Hint Latch	0			0	5,522	0.00
active checkpoint queue latch	8,408	0.00		0	0
active service list	1,882	0.00		0	257	0.00
archive control	3	0.00		0	0
begin backup scn array	2	0.00		0	0
buffer pool	10	0.00		0	0
cache buffer handles	1,458	0.00		0	0
cache buffers chains	23,575,058	0.10	0.02	1	297,526	0.07
cache buffers lru chain	355,061	0.16	0.01	0	286,791	0.75
cache table scan latch	0			0	48	0.00
channel handle pool latch	397	0.00		0	0
channel operations parent latch	16,330	0.00		0	0
checkpoint queue latch	192,386	0.00	0.00	0	114,202	0.02
client/application info	992	0.00		0	0
compile environment latch	206,565	0.11	0.00	0	0
dml lock allocation	1,176,888	0.94	0.03	1	0
dummy allocation	395	0.00		0	0
enqueue hash chains	1,996,408	0.63	0.04	1	1,561	0.32
enqueues	607,186	0.32	0.01	0	0
event group latch	198	0.00		0	0
file cache latch	6,481	0.00		0	0
global KZLD latch for mem in SGA	196	0.00		0	0
hash table column usage latch	299	0.00		0	16,331	0.00
job_queue_processes parameter latch	10	0.00		0	0
kks stats	1,717	0.00		0	0
ksuosstats global area	42	0.00		0	0
ktm global data	14	0.00		0	0
kwqbsn:qsga	22	0.00		0	0
lgwr LWN SCN	133,743	0.01	0.13	0	0
library cache	1,581,244	0.46	0.03	1	3,457	0.43
library cache load lock	3,450	0.06	0.00	0	8	0.00
library cache lock	391,563	0.29	0.01	0	0
library cache lock allocation	3,829	0.00		0	0
library cache pin	771,819	0.41	0.02	0	0
library cache pin allocation	740	0.00		0	0
list of block allocation	397	0.00		0	0
loader state object freelist	50	0.00		0	0
message pool operations parent latch	2	0.00		0	0
messages	455,736	0.07	0.04	0	0
mostly latch-free SCN	134,276	0.11	0.01	0	0
multiblock read objects	124	0.00		0	0
ncodef allocation latch	13	0.00		0	0
object queue header heap	17,424	0.00		0	637	0.00
object queue header operation	889,557	0.04	0.06	0	326	0.00
object stats modification	1	0.00		0	0
parallel query alloc buffer	80	0.00		0	0
parameter list	706	0.00		0	0
parameter table allocation management	202	0.00		0	0
post/wait queue	148,686	0.01	0.06	0	96,646	0.19
process allocation	395	0.00		0	198	0.00
process group creation	395	0.00		0	0
qmn task queue latch	84	0.00		0	0
redo allocation	744,250	0.24	0.16	0	819,823	1.24
redo copy	0			0	823,760	0.68
redo writing	418,793	0.01	0.05	0	0
resmgr group change latch	198	0.00		0	0
resmgr:actses active list	392	0.00		0	0
resmgr:actses change group	196	0.00		0	0
resmgr:free threads list	391	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	2,058,101	0.40	0.01	0	2,381	0.25
sequence cache	1,048	0.00		0	0
session allocation	916,700	0.45	0.02	0	0
session idle bit	984,342	0.06	0.02	0	0
session state list latch	398	0.00		0	0
session switching	13	0.00		0	0
session timer	257	0.00		0	0
shared pool	92,422	0.26	0.13	0	0
shared pool sim alloc	4	0.00		0	0
shared pool simulator	70,556	0.00		0	0
simulator hash latch	656,432	0.00	0.00	0	0
simulator lru latch	615,958	0.20	0.06	0	16,342	0.01
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	28	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	8,016	0.00		0	0
transaction branch allocation	13	0.00		0	0
undo global data	1,641,659	0.11	0.02	0	0
user lock	782	0.13	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,575,058	23,404	496	22,913
In memory undo latch	1,615,067	12,590	953	11,643
enqueue hash chains	1,996,408	12,576	525	12,060
dml lock allocation	1,176,888	11,044	280	10,766
row cache objects	2,058,101	8,210	96	8,115
library cache	1,581,244	7,352	215	7,141
session allocation	916,700	4,141	79	4,066
library cache pin	771,819	3,190	54	3,136
enqueues	607,186	1,929	26	1,903
undo global data	1,641,659	1,848	36	1,812
redo allocation	744,250	1,777	289	1,488
simulator lru latch	615,958	1,228	74	1,154
library cache lock	391,563	1,117	9	1,108
cache buffers lru chain	355,061	578	7	571
session idle bit	984,342	568	11	557
object queue header operation	889,557	390	22	368
messages	455,736	313	13	300
shared pool	92,422	236	30	209
mostly latch-free SCN	134,276	151	2	149
Consistent RBA	133,742	28	5	23
redo writing	418,793	21	1	20
lgwr LWN SCN	133,743	16	2	14
post/wait queue	148,686	16	1	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	675	828
In memory undo latch	ktiTxnPoolFree	96	0
In memory undo latch	kticmt: child	88	3
In memory undo latch	ktichg: child	84	96
In memory undo latch	kturbk	8	25
In memory undo latch	ktiBRacquire	1	0
cache buffers chains	kcbgtcr: fast path	293	276
cache buffers chains	kcbgcur: kslbegin	120	161
cache buffers chains	kcbchg: kslbegin: bufs not pinned	77	116
cache buffers chains	kcbgtcr: kslbegin excl	67	32
cache buffers chains	kcbgtcr: kslbegin shared	43	6
cache buffers chains	kcbzgb: scan from tail. nowait	26	0
cache buffers chains	kcbnlc	24	28
cache buffers chains	kcbrls: kslbegin	21	22
cache buffers chains	kcbnew: new latch again	17	4
cache buffers chains	kcbgtcr	16	0
cache buffers chains	kcb_pre_apply: kcbhq61	9	16
cache buffers chains	kcbchg: kslbegin: call CR func	9	56
cache buffers chains	kcbzwb	8	5
cache buffers chains	kcbso1: set no access	4	1
cache buffers chains	kcbbxsv	3	3
cache buffers chains	kcbget: exchange	3	1
cache buffers chains	kcbget: exchange rls	3	0
cache buffers chains	kcbget: pin buffer	3	4
cache buffers chains	kcbkzs	1	9
cache buffers chains	kcbzib: finish free bufs	1	5
cache buffers lru chain	kcbzgws	6	5
cache buffers lru chain	kcbbxsv: move to being written	1	1
dml lock allocation	ktaiam	151	207
dml lock allocation	ktaidm	129	73
enqueue hash chains	ksqrcl	295	176
enqueue hash chains	ksqgtl3	228	346
enqueue hash chains	ksqcmi: get hash chain latch after wait	1	3
enqueue hash chains	ksqcnl	1	0
enqueues	ksqdel	10	5
enqueues	ksqgel: create enqueue	10	4
enqueues	ksqies	6	17
lgwr LWN SCN	kcs022	2	0
library cache	kglpndl: child: after processing	74	0
library cache	kglpnp: child	74	138
library cache	kglLockCursor	27	4
library cache	kglobpn: child:	10	3
library cache	kglpndl: child: before processing	9	62
library cache	kgldti: 2child	4	0
library cache	kglhdgn: child:	4	1
library cache	kgldtld: 2child	3	0
library cache	kglpin	3	0
library cache	kgldte: child 0	2	7
library cache	kglini: child	1	0
library cache lock	kgllkal: child: multiinstance	6	0
library cache lock	kgllkdl: child: cleanup	3	9
library cache lock	kgllkdl: child: no lock handle	1	0
library cache pin	kglpndl	32	19
library cache pin	kglpnp: child	22	35
messages	ksaamb: after wakeup	10	9
messages	ksarcv	2	4
messages	ksarcv: after wait	1	0
mostly latch-free SCN	kcsnew_scn_rba	3	0
mostly latch-free SCN	kcs01	2	5
mostly latch-free SCN	kcs04	1	4
mostly latch-free SCN	kcs05	1	0
object queue header operation	kcbw_link_q	13	0
object queue header operation	kcbo_switch_cq	7	19
object queue header operation	kcbo_switch_q_bg	1	0
object queue header operation	kcbw_unlink_q	1	3
post/wait queue	ksliwat:add:nowait	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	278	0
redo allocation	kcrfw_redo_gen: redo allocation 3	9	6
redo allocation	kcrfw_redo_gen: redo allocation 2	1	0
redo allocation	kcrfw_redo_write: before write	1	159
redo writing	kcrfw_post: rba scn pair	1	0
row cache objects	kqreqd: reget	48	0
row cache objects	kqrpre: find obj	44	86
row cache objects	kqreqd	4	10
session allocation	ksucri	26	72
session allocation	ksuprc	23	6
session allocation	ksudlc	17	3
session allocation	ksuxds: not user session	15	1
session allocation	ksucrp	1	0
session idle bit	ksupuc: clear busy	9	10
session idle bit	ksupuc: set busy	3	1
session idle bit	ksuxds	3	4
shared pool	kghalo	9	11
shared pool	kghfrunp: alloc: session dur	5	0
shared pool	kgh_next_free	4	5
shared pool	kghupr1	4	11
shared pool	kghfrunp: alloc: wait	3	0
shared pool	kghfrunp: clatch: nowait	3	0
shared pool	kghalp	2	1
shared pool	kghfre	2	1
simulator lru latch	kcbs_simulate: simulate set	74	73
slave class create	ksvcreate	1	0
undo global data	ktudba: KSLBEGIN	15	16
undo global data	ktudnx:child	14	4
undo global data	ktufrbs: child	3	12
undo global data	ktusm_stealext: KSLBEGIN	3	1
undo global data	ktusmupst: KSLBEGIN	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: 11,188,428
Captured Segments account for 83.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	3,350,320	29.94
TPCC	USERS	STOCK	TABLE	1,657,952	14.82
TPCC	USERS	CUSTOMER_I2	INDEX	687,808	6.15
TPCC	USERS	CUSTOMER	TABLE	650,016	5.81
TPCC	USERS	CUSTOMER_I1	INDEX	494,304	4.42

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 173,539
Captured Segments account for 99.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	ITEM_ID	INDEX	81,618	47.03
TPCC	USERS	ITEM	TABLE	44,776	25.80
TPCC	USERS	CUSTOMER	TABLE	24,000	13.83
TPCC	USERS	STOCK	TABLE	18,727	10.79
TPCC	USERS	HISTORY	TABLE	810	0.47

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	Obj. Type	Row Lock Waits	% of Capture
TPCC	USERS	WAREHOUSE	TABLE	13,096	52.17
TPCC	USERS	DISTRICT	TABLE	12,003	47.82
SYS	SYSTEM	SMON_SCN_TIME	TABLE	2	0.01

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,542	83.51
TPCC	USERS	HISTORY	TABLE	635	8.11
TPCC	USERS	WAREHOUSE	TABLE	494	6.31
TPCC	USERS	DISTRICT	TABLE	140	1.79
TPCC	USERS	INORD	INDEX	22	0.28

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	13	30.77	2	1
dc_global_oids	65	32.31	0	0
dc_histogram_data	4,776	32.52	0	478
dc_histogram_defs	8,796	38.99	0	667
dc_object_grants	61	31.15	0	8
dc_object_ids	5,741	8.03	0	246
dc_objects	2,853	18.58	0	213
dc_profiles	195	1.03	0	1
dc_rollback_segments	146,182	0.00	0	23
dc_segments	13,833	4.52	0	179
dc_sequences	26	23.08	26	1
dc_tablespaces	500,467	0.00	0	5
dc_usernames	585	1.20	0	4
dc_users	6,602	0.20	0	15
outstanding_alerts	12	83.33	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	7	42.86	92,817	0.02	11
CLUSTER	49	6.12	133	2.26	0
INDEX	38	81.58	118	27.97	2
SQL AREA	801	55.18	1,581,113	0.13	310
TABLE/PROCEDURE	1,470	18.10	292,582	0.56	578

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	64.90		2.16	4.84	22	22	30	30
	Freeable	9.13	0.00	0.83	0.31	1		11	11
	SQL	1.80	0.86	0.07	0.03	0	5	24	24
	PL/SQL	1.42	0.72	0.05	0.05	0	0	30	30
E	Other	65.62		2.19	4.84	22	22	30	30
	Freeable	9.75	0.00	0.89	0.30	1		11	11
	SQL	1.74	0.82	0.07	0.03	0	5	24	24
	PL/SQL	1.37	0.67	0.05	0.05	0	0	30	30

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	4.00	4.00	0.00
large	PX msg pool	1.02	1.02	0.00
large	free memory	2.98	2.98	0.00
shared	ASH buffers	8.00	8.00	0.00
shared	CCursor		0.84
shared	FileOpenBlock	1.58	1.58	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGH: NO ACCESS	3.28	6.92	110.94
shared	KGLS heap		0.88
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	13.22	12.21	-7.58
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kks stbkt	0.88	0.88	0.00
shared	library cache	2.86	2.85	-0.04
shared	private strands	2.29	2.29	0.00
shared	row cache	3.57	3.57	0.00
shared	sessions	1.54	1.54	0.00
shared	sql area	2.19	2.72	23.99
	buffer_cache	712.00	712.00	0.00
	fixed_sga	1.21	1.21	0.00
	log_buffer	6.79	6.79	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

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

Buffer Nowait %:	99.91	Redo NoWait %:	99.99
Buffer Hit %:	98.45	In-memory Sort %:	100.00
Library Hit %:	99.81	Soft Parse %:	99.73
Execute to Parse %:	78.11	Latch Hit %:	99.78
Parse CPU to Parse Elapsd %:	46.05	% Non-Parse CPU:	97.57