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: 354 10-Apr-06 10:20:38 29 12.7

End Snap: 355 10-Apr-06 10:30:45 29 12.9

Elapsed: 10.12 (mins)

DB Time: 96.20 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	354	10-Apr-06 10:20:38	29	12.7
End Snap:	355	10-Apr-06 10:30:45	29	12.9
Elapsed:		10.12 (mins)
DB Time:		96.20 (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: 309,739.72 4,151.26

Logical reads: 9,972.50 133.66

Block changes: 2,435.96 32.65

Physical reads: 153.69 2.06

Physical writes: 117.57 1.58

User calls: 350.39 4.70

Parses: 263.76 3.54

Hard parses: 1.11 0.01

Sorts: 15.15 0.20

Logons: 0.18 0.00

Executes: 1,231.57 16.51

Transactions: 74.61

	Per Second	Per Transaction
Redo size:	309,739.72	4,151.26
Logical reads:	9,972.50	133.66
Block changes:	2,435.96	32.65
Physical reads:	153.69	2.06
Physical writes:	117.57	1.58
User calls:	350.39	4.70
Parses:	263.76	3.54
Hard parses:	1.11	0.01
Sorts:	15.15	0.20
Logons:	0.18	0.00
Executes:	1,231.57	16.51
Transactions:	74.61

% Blocks changed per Read: 24.43 Recursive Call %: 85.79

Rollback per transaction %: 0.00 Rows per Sort: 10.11

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97 Redo NoWait %: 99.99

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

Library Hit %: 99.69 Soft Parse %: 99.58

Execute to Parse %: 78.58 Latch Hit %: 99.91

Parse CPU to Parse Elapsd %: 22.91 % Non-Parse CPU: 97.23

Shared Pool Statistics

Begin End

Memory Usage %: 82.64 82.34

% SQL with executions>1: 71.30 75.08

% Memory for SQL w/exec>1: 77.19 75.82

	Begin	End
Memory Usage %:	82.64	82.34
% SQL with executions>1:	71.30	75.08
% Memory for SQL w/exec>1:	77.19	75.82

Top 5 Timed Events

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

db file sequential read 93,799 5,139 55 89.0 User I/O

CPU time 431 7.5

enq: TX - row lock contention 4,155 207 50 3.6 Application

log file sync 51,628 186 4 3.2 Commit

SQL*Net break/reset to client 93,222 40 0 .7 Application

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	93,799	5,139	55	89.0	User I/O
CPU time		431		7.5
enq: TX - row lock contention	4,155	207	50	3.6	Application
log file sync	51,628	186	4	3.2	Commit
SQL*Net break/reset to client	93,222	40	0	.7	Application

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
init.ora Parameters

Time Model Statistics

Total time in database user-calls (DB Time): 5772.1s
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,512.23	95.50
DB CPU	431.48	7.48
PL/SQL execution elapsed time	51.63	0.89
parse time elapsed	50.00	0.87
hard parse elapsed time	37.63	0.65
PL/SQL compilation elapsed time	9.26	0.16
connection management call elapsed time	4.33	0.08
repeated bind elapsed time	0.56	0.01
sequence load elapsed time	0.40	0.01
hard parse (sharing criteria) elapsed time	0.32	0.01
DB time	5,772.06
background elapsed time	426.17
background cpu time	61.96

Back to Wait Events Statistics
Back to Top

Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	94,058	0.00	5,153	55	2.08
Application	97,377	0.00	246	3	2.15
Commit	51,628	0.00	186	4	1.14
Configuration	44	0.00	9	207	0.00
Concurrency	1,856	1.02	6	3	0.04
System I/O	92,655	0.00	6	0	2.05
Other	1,064	0.00	2	1	0.02
Network	108,899	0.00	1	0	2.40

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	93,799	0.00	5,139	55	2.07
enq: TX - row lock contention	4,155	0.00	207	50	0.09
log file sync	51,628	0.00	186	4	1.14
SQL*Net break/reset to client	93,222	0.00	40	0	2.06
log file switch completion	28	0.00	9	315	0.00
read by other session	225	0.00	8	37	0.00
db file scattered read	14	0.00	6	407	0.00
buffer busy waits	1,643	0.00	5	3	0.04
log file parallel write	84,708	0.00	2	0	1.87
control file parallel write	320	0.00	2	7	0.01
control file sequential read	876	0.00	1	1	0.02
enq: TX - contention	4	0.00	1	270	0.00
SQL*Net message to client	108,536	0.00	1	0	2.40
library cache load lock	5	0.00	1	125	0.00
row cache lock	5	0.00	0	66	0.00
enq: HW - contention	15	0.00	0	19	0.00
db file parallel write	6,743	0.00	0	0	0.15
log file single write	4	0.00	0	66	0.00
cursor: pin S wait on X	19	100.00	0	12	0.00
LGWR wait for redo copy	813	0.00	0	0	0.02
log file sequential read	4	0.00	0	39	0.00
latch: enqueue hash chains	90	0.00	0	2	0.00
os thread startup	2	0.00	0	44	0.00
latch: cache buffers chains	69	0.00	0	1	0.00
latch: session allocation	19	0.00	0	3	0.00
latch: In memory undo latch	67	0.00	0	1	0.00
latch free	65	0.00	0	1	0.00
latch: redo allocation	46	0.00	0	1	0.00
latch: library cache	30	0.00	0	1	0.00
latch: row cache objects	6	0.00	0	3	0.00
SQL*Net more data to client	346	0.00	0	0	0.01
enq: FB - contention	5	0.00	0	3	0.00
latch: undo global data	4	0.00	0	2	0.00
latch: library cache pin	7	0.00	0	1	0.00
latch: object queue header operation	4	0.00	0	1	0.00
cursor: pin S	5	0.00	0	0	0.00
latch: shared pool	2	0.00	0	1	0.00
rdbms ipc reply	7	0.00	0	0	0.00
latch: messages	2	0.00	0	0	0.00
latch: library cache lock	1	0.00	0	0	0.00
SQL*Net more data from client	17	0.00	0	0	0.00
direct path write	12	0.00	0	0	0.00
direct path read	8	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
SQL*Net message from client	108,537	0.00	2,047	19	2.40
Streams AQ: waiting for messages in the queue	124	99.19	598	4826	0.00
Streams AQ: qmn slave idle wait	22	0.00	595	27064	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	595	13532	0.00
Streams AQ: waiting for time management or cleanup tasks	3	33.33	306	101907	0.00
class slave wait	1	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
db file sequential read	251	0.00	28	113	0.01
log file parallel write	84,624	0.00	2	0	1.87
control file parallel write	329	0.00	2	7	0.01
db file scattered read	3	0.00	1	317	0.00
control file sequential read	181	0.00	1	4	0.00
log file single write	6	0.00	0	49	0.00
db file parallel write	6,796	0.00	0	0	0.15
events in waitclass Other	866	0.00	0	0	0.02
log file sequential read	6	0.00	0	31	0.00
log file switch completion	1	0.00	0	165	0.00
read by other session	1	0.00	0	159	0.00
library cache load lock	1	0.00	0	157	0.00
row cache lock	3	0.00	0	49	0.00
os thread startup	2	0.00	0	44	0.00
direct path write	8	0.00	0	0	0.00
direct path read	8	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
rdbms ipc message	84,451	2.09	4,555	54	1.86
pmon timer	248	100.00	603	2429	0.01
Streams AQ: qmn slave idle wait	22	0.00	595	27064	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	595	13532	0.00
smon timer	3	33.33	402	133905	0.00
Streams AQ: waiting for time management or cleanup tasks	3	33.33	306	101907	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	51,892
IDLE_TIME	195,050
IOWAIT_TIME	122,044
NICE_TIME	0
SYS_TIME	14,964
USER_TIME	34,238
LOAD	11
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	34,208
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,699.60	426.40	91,866	6,024,859
SYS$USERS	54.80	7.90	493	41,967
SYS$BACKGROUND	0.00	0.00	1,225	38,360

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	92328	494535	1843	538	107253	98
SYS$USERS	480	4551	8	48	1324	2
SYS$BACKGROUND	1210	15937	6	39	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,129	129	46,608	0.09	71.53	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
3,795	42	46,623	0.08	65.74	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
735	25	4,741	0.16	12.73	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
731	22	4,740	0.15	12.67	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
587	150	45,650	0.01	10.17	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
230	13	27,448	0.01	3.98	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
160	9	46,623	0.00	2.77	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
102	14	46,619	0.00	1.78	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
91	7	45,646	0.00	1.57	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
67	3	18,201	0.00	1.15	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	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
150	587	45,650	0.00	10.17	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
129	4,129	46,608	0.00	71.53	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
42	3,795	46,623	0.00	65.74	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
25	735	4,741	0.01	12.73	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
22	731	4,740	0.00	12.67	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
15	53	45,945	0.00	0.93	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
14	102	46,619	0.00	1.78	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
13	15	46,622	0.00	0.26	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
13	230	27,448	0.00	3.98	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
9	160	46,623	0.00	2.77	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
7	91	45,646	0.00	1.57	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
3	67	18,201	0.00	1.15	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: 6,055,272
Captured SQL account for 90.4% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,907,811	4,741	613.33	48.02	25.49	735.00	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
2,898,174	4,740	611.43	47.86	21.92	731.31	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
1,364,271	45,650	29.89	22.53	150.07	587.10	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
1,078,456	46,608	23.14	17.81	129.04	4128.97	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
457,762	27,448	16.68	7.56	12.61	229.73	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
327,562	46,623	7.03	5.41	42.17	3794.61	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
235,434	46,623	5.05	3.89	9.47	159.77	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
233,436	46,622	5.01	3.86	13.32	14.85	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
188,949	46,619	4.05	3.12	14.21	102.48	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
186,330	45,945	4.06	3.08	14.96	53.40	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
94,122	45,646	2.06	1.55	7.27	90.54	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
93,246	46,622	2.00	1.54	6.13	6.16	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
93,089	45,945	2.03	1.54	5.02	5.02	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
92,459	30,400	3.04	1.53	5.29	21.69	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
91,300	45,649	2.00	1.51	3.83	3.87	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
71,207	4,700	15.15	1.18	8.03	38.16	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
69,546	23,182	3.00	1.15	4.14	4.48	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
69,087	23,029	3.00	1.14	2.08	2.08	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
67,863	22,621	3.00	1.12	3.67	3.92	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: 93,319
Captured SQL account for 100.5% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
73,719	46,608	1.58	79.00	129.04	4128.97	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
69,953	46,623	1.50	74.96	42.17	3794.61	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
10,778	4,740	2.27	11.55	21.92	731.31	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
10,778	4,741	2.27	11.55	25.49	735.00	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
7,471	45,650	0.16	8.01	150.07	587.10	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
5,492	27,448	0.20	5.89	12.61	229.73	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
3,733	46,623	0.08	4.00	9.47	159.77	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
1,471	18,201	0.08	1.58	2.53	66.65	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
747	4,700	0.16	0.80	8.03	38.16	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
571	2,768	0.21	0.61	1.22	23.69	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 747,806
Captured SQL account for 99.9% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
46,623	46,623	1.00	0.00	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
46,623	46,616	1.00	0.08	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
46,622	46,623	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
46,622	46,622	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
46,619	46,622	1.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
46,608	0	0.00	0.09	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
45,948	45,948	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
45,945	45,947	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
45,945	45,947	1.00	0.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
45,650	45,650	1.00	0.01	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
45,649	45,650	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
45,646	45,650	1.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
30,400	30,401	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
27,448	199,963	7.29	0.01	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
23,182	23,182	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
23,029	23,029	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
22,621	22,621	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
18,201	18,201	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: 160,154
Captured SQL account for 99.3% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
46,620	46,608	29.11	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
46,620	46,623	29.11	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
45,645	45,650	28.50	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
4,740	4,741	2.96	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
4,700	4,700	2.93	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
4,542	4,542	2.84	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
578	578	0.36	2ym6hhaq30r73		select type#, blocks, extents,...
286	866	0.18	3c1kubcdjnppq		update sys.col_usage$ set eq...
286	1	0.18	53btfq0dt9bs9		insert into sys.col_usage$ val...
286	286	0.18	b2gnxm5z6r51n		lock table sys.col_usage$ in e...

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

53btfq0dt9bs9 insert into sys.col_usage$ values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)

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

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

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

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

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

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

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

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

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

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

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

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
53btfq0dt9bs9	insert into sys.col_usage$ values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
5hyh0360hgx2u	BEGIN slev(:st_w_id, :st_d_id, :threshold); END;
5mz8u3b34u9gw	SELECT C_DISCOUNT, C_LAST, C_CREDIT, W_TAX FROM CUSTOMER, WAREHOUSE WHERE WAREHOUSE.W_ID = :B3 AND CUSTOMER.C_W_ID = :B3 AND CUSTOMER.C_D_ID = :B2 AND CUSTOMER.C_ID = :B1
5xm451a80drbc	INSERT INTO HISTORY (H_C_D_ID, H_C_W_ID, H_C_ID, H_D_ID, H_W_ID, H_DATE, H_AMOUNT, H_DATA) VALUES (:B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
69gxtaqr1vk8j	UPDATE DISTRICT SET D_YTD = D_YTD + :B3 WHERE D_W_ID = :B2 AND D_ID = :B1
7m5h0wf6stq0q	SELECT COUNT(C_ID) FROM CUSTOMER WHERE C_LAST = :B3 AND C_D_ID = :B2 AND C_W_ID = :B1
80ajya2tnyfg2	INSERT INTO NEW_ORDER (NO_O_ID, NO_D_ID, NO_W_ID) VALUES (:B3 , :B2 , :B1 )
88fgqncchy6wg	SELECT I_PRICE, I_NAME, I_DATA FROM ITEM WHERE I_ID = :B1
89k9fqaq5b5sy	SELECT C_BALANCE, C_FIRST, C_MIDDLE, C_ID FROM CUSTOMER WHERE C_LAST = :B3 AND C_D_ID = :B2 AND C_W_ID = :B1 ORDER BY C_FIRST
95yr4xtfr50hx	UPDATE CUSTOMER SET C_BALANCE = :B4 WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
aw9ttz9acxbc3	BEGIN payment(:p_w_id, :p_d_id, :p_c_w_id, :p_c_d_id, :p_c_id, :byname, :p_h_amount, :p_c_last, :p_w_street_1, :p_w_street_2, :p_w_city, :p_w_state, :p_w_zip, :p_d_street_1, :p_d_street_2, :p_d_city, :p_d_state, :p_d_zip, :p_c_first, :p_c_middle, :p_c_street_1, :p_c_street_2, :p_c_city, :p_c_state, :p_c_zip, :p_c_phone, :p_c_since, :p_c_credit, :p_c_credit_lim, :p_c_discount, :p_c_balance, :p_c_data, TO_DATE(:timestamp, 'YYYYMMDDHH24MISS')); END;
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
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	38,657	63.66	0.85
CPU used when call started	38,485	63.38	0.85
CR blocks created	5,547	9.14	0.12
Cached Commit SCN referenced	67,704	111.50	1.49
Commit SCN cached	107	0.18	0.00
DB time	649,890	1,070.31	14.34
DBWR checkpoint buffers written	19,644	32.35	0.43
DBWR checkpoints	3	0.00	0.00
DBWR transaction table writes	42	0.07	0.00
DBWR undo block writes	45,827	75.47	1.01
IMU CR rollbacks	5,236	8.62	0.12
IMU Flushes	48,431	79.76	1.07
IMU Redo allocation size	115,358,464	189,985.23	2,546.26
IMU commits	38,552	63.49	0.85
IMU contention	42,378	69.79	0.94
IMU pool not allocated	4,570	7.53	0.10
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	234,108,988	385,556.89	5,167.40
IMU- failed to get a private strand	4,570	7.53	0.10
SMON posted for undo segment shrink	1	0.00	0.00
SQL*Net roundtrips to/from client	107,168	176.50	2.37
active txn count during cleanout	9,004	14.83	0.20
application wait time	25,002	41.18	0.55
background checkpoints completed	3	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	1,957	3.22	0.04
buffer is not pinned count	3,185,318	5,245.94	70.31
buffer is pinned count	1,049,542	1,728.50	23.17
bytes received via SQL*Net from client	120,465,059	198,395.35	2,658.98
bytes sent via SQL*Net to client	46,637,109	76,807.21	1,029.40
calls to get snapshot scn: kcmgss	600,011	988.17	13.24
calls to kcmgas	99,772	164.32	2.20
calls to kcmgcs	3,188	5.25	0.07
change write time	1,779	2.93	0.04
cleanout - number of ktugct calls	9,135	15.04	0.20
cleanouts and rollbacks - consistent read gets	3,920	6.46	0.09
cleanouts only - consistent read gets	270	0.44	0.01
cluster key scan block gets	4,320	7.11	0.10
cluster key scans	3,342	5.50	0.07
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	46,119	75.95	1.02
commit batch/immediate requested	46,119	75.95	1.02
commit cleanout failures: block lost	3	0.00	0.00
commit cleanout failures: callback failure	157	0.26	0.00
commit cleanout failures: cannot pin	664	1.09	0.01
commit cleanouts	181,800	299.41	4.01
commit cleanouts successfully completed	180,976	298.05	3.99
commit immediate performed	46,119	75.95	1.02
commit immediate requested	46,119	75.95	1.02
commit txn count during cleanout	1,028	1.69	0.02
concurrency wait time	599	0.99	0.01
consistent changes	7,126	11.74	0.16
consistent gets	4,648,036	7,654.91	102.59
consistent gets - examination	3,937,058	6,483.99	86.90
consistent gets direct	0	0.00	0.00
consistent gets from cache	4,648,036	7,654.91	102.59
cursor authentications	151	0.25	0.00
data blocks consistent reads - undo records applied	5,593	9.21	0.12
db block changes	1,479,109	2,435.96	32.65
db block gets	1,407,236	2,317.59	31.06
db block gets direct	9	0.01	0.00
db block gets from cache	1,407,227	2,317.58	31.06
deferred (CURRENT) block cleanout applications	106,504	175.40	2.35
dirty buffers inspected	48,533	79.93	1.07
enqueue conversions	131	0.22	0.00
enqueue releases	422,801	696.32	9.33
enqueue requests	422,794	696.30	9.33
enqueue waits	4,245	6.99	0.09
execute count	747,806	1,231.57	16.51
frame signature mismatch	0	0.00	0.00
free buffer inspected	145,645	239.86	3.21
free buffer requested	145,583	239.76	3.21
heap block compress	4,468	7.36	0.10
hot buffers moved to head of LRU	97,131	159.97	2.14
immediate (CR) block cleanout applications	4,190	6.90	0.09
immediate (CURRENT) block cleanout applications	18	0.03	0.00
index fetch by key	1,380,853	2,274.14	30.48
index scans kdiixs1	128,394	211.45	2.83
leaf node 90-10 splits	4	0.01	0.00
leaf node splits	4	0.01	0.00
lob reads	318	0.52	0.01
lob writes	120	0.20	0.00
lob writes unaligned	120	0.20	0.00
logons cumulative	111	0.18	0.00
messages received	90,834	149.60	2.00
messages sent	90,834	149.60	2.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	576,433	949.33	12.72
opened cursors cumulative	120,584	198.59	2.66
parse count (hard)	671	1.11	0.01
parse count (total)	160,154	263.76	3.54
parse time cpu	1,196	1.97	0.03
parse time elapsed	5,220	8.60	0.12
physical read IO requests	93,274	153.61	2.06
physical read bytes	1,528,938,496	2,518,027.09	33,747.68
physical read total IO requests	94,180	155.11	2.08
physical read total bytes	1,543,687,168	2,542,316.86	34,073.22
physical read total multi block requests	13	0.02	0.00
physical reads	93,319	153.69	2.06
physical reads cache	93,307	153.67	2.06
physical reads cache prefetch	45	0.07	0.00
physical reads direct	12	0.02	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	43,715	71.99	0.96
physical write bytes	1,169,588,224	1,926,208.83	25,815.88
physical write total IO requests	106,732	175.78	2.36
physical write total bytes	1,398,889,472	2,303,847.80	30,877.15
physical write total multi block requests	94,614	155.82	2.09
physical writes	71,386	117.57	1.58
physical writes direct	21	0.03	0.00
physical writes from cache	71,365	117.53	1.58
physical writes non checkpoint	54,730	90.14	1.21
pinned buffers inspected	2	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	615	1.01	0.01
recursive calls	1,284,926	2,116.16	28.36
recursive cpu usage	24,094	39.68	0.53
redo blocks written	415,784	684.76	9.18
redo buffer allocation retries	53	0.09	0.00
redo entries	414,488	682.63	9.15
redo log space requests	60	0.10	0.00
redo log space wait time	1,151	1.90	0.03
redo ordering marks	2,355	3.88	0.05
redo size	188,073,028	309,739.72	4,151.26
redo synch time	19,234	31.68	0.42
redo synch writes	110,304	181.66	2.43
redo wastage	17,434,884	28,713.72	384.83
redo write time	12,566	20.70	0.28
redo writer latching time	21	0.03	0.00
redo writes	83,850	138.09	1.85
rollback changes - undo records applied	230,595	379.77	5.09
rollbacks only - consistent read gets	1,621	2.67	0.04
rows fetched via callback	1,179,535	1,942.59	26.04
session connect time	0	0.00	0.00
session cursor cache hits	114,282	188.21	2.52
session logical reads	6,055,272	9,972.50	133.66
session pga memory	720,896	1,187.25	15.91
session pga memory max	655,360	1,079.32	14.47
session uga memory	2,966,548	4,885.64	65.48
session uga memory max	51,461,708	84,752.90	1,135.89
shared hash latch upgrades - no wait	144,373	237.77	3.19
shared hash latch upgrades - wait	15	0.02	0.00
sorts (memory)	9,201	15.15	0.20
sorts (rows)	93,025	153.20	2.05
sql area evicted	200	0.33	0.00
sql area purged	0	0.00	0.00
summed dirty queue length	146,677	241.56	3.24
switch current to new buffer	5	0.01	0.00
table fetch by rowid	1,531,876	2,522.86	33.81
table fetch continued row	201	0.33	0.00
table scan blocks gotten	20,041	33.01	0.44
table scan rows gotten	55,404	91.25	1.22
table scans (short tables)	300	0.49	0.01
total number of times SMON posted	2	0.00	0.00
transaction rollbacks	46,119	75.95	1.02
undo change vector size	51,576,160	84,941.39	1,138.42
user I/O wait time	511,830	842.94	11.30
user calls	212,758	350.39	4.70
user commits	45,305	74.61	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	6,608	10.88	0.15
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	6,631	7,969
opened cursors current	369	374
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)	3	17.79

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	91,781	151	53.59	1.00	11,523	19	1,816	7.09
UNDOTBS1	4	0	197.50	1.00	32,277	53	30	0.00
SYSTEM	1,143	2	80.77	1.01	13	0	5	56.00
SYSAUX	589	1	196.62	1.07	195	0	3	140.00
TEMP	1	0	350.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	589	1	196.62	1.07	195	0	3	140.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	1,143	2	80.77	1.01	13	0	5	56.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	1	0	350.00	1.00	0	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	4	0	197.50	1.00	32,277	53	30	0.00
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	91,781	151	53.59	1.00	11,523	19	1,816	7.09

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,812	98	6,091,089	93,738	71,981	0	0	1,867

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	25	11753	206814	1105920	1105920	1280474
E	0	25	11046	210478	1105920	1105920	1252807

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.29	2,791,489
D	136	0.19	8,568	2.68	1,413,892
D	204	0.28	12,852	2.14	1,131,870
D	272	0.38	17,136	1.81	955,931
D	340	0.47	21,420	1.59	837,877
D	408	0.57	25,704	1.42	751,827
D	476	0.66	29,988	1.30	685,141
D	544	0.76	34,272	1.19	629,924
D	612	0.85	38,556	1.11	584,413
D	680	0.95	42,840	1.04	546,335
D	716	1.00	45,108	1.00	527,847
D	748	1.04	47,124	0.97	512,568
D	816	1.14	51,408	0.91	482,464
D	884	1.23	55,692	0.87	456,839
D	952	1.33	59,976	0.83	436,353
D	1,020	1.42	64,260	0.79	418,614
D	1,088	1.52	68,544	0.76	403,542
D	1,156	1.61	72,828	0.74	390,911
D	1,224	1.71	77,112	0.72	379,974
D	1,292	1.80	81,396	0.70	370,524
D	1,360	1.90	85,680	0.69	362,412

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	134	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	66	67.75	0.00	0.00	0.00	0.00	21,094
E	103	66	68.15	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	6,371	6,371
64K	128K	3	3
512K	1024K	205	205

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	948.50	51.27	95.00	19
26	0.25	948.50	51.27	95.00	18
52	0.50	948.50	0.00	100.00	0
77	0.75	948.50	0.00	100.00	0
103	1.00	948.50	0.00	100.00	0
124	1.20	948.50	0.00	100.00	0
144	1.40	948.50	0.00	100.00	0
165	1.60	948.50	0.00	100.00	0
185	1.80	948.50	0.00	100.00	0
206	2.00	948.50	0.00	100.00	0
309	3.00	948.50	0.00	100.00	0
412	4.00	948.50	0.00	100.00	0
618	6.00	948.50	0.00	100.00	0
824	8.00	948.50	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,088	106,235	0.87	15,540	50.78	2,534,657
64	0.89	15	1,822	118,032	0.97	3,743	12.23	2,538,577
72	1.00	22	2,401	121,469	1.00	306	1.00	2,541,087
80	1.11	29	2,889	121,532	1.00	243	0.79	2,542,396
88	1.22	37	3,293	121,556	1.00	219	0.72	2,543,067
96	1.33	45	3,720	121,563	1.00	212	0.69	2,543,313
104	1.44	53	4,255	121,565	1.00	210	0.69	2,543,357
112	1.56	58	4,950	121,565	1.00	210	0.69	2,543,359
120	1.67	58	4,950	121,565	1.00	210	0.69	2,543,359
128	1.78	58	4,950	121,565	1.00	210	0.69	2,543,359
136	1.89	58	4,950	121,565	1.00	210	0.69	2,543,359
144	2.00	58	4,950	121,565	1.00	210	0.69	2,543,359

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	107,209	1,463,345
400	0.50	61,670	867,874
600	0.75	49,167	709,605
800	1.00	39,217	531,102
1,000	1.25	34,729	452,021
1,200	1.50	32,084	404,912
1,400	1.75	30,400	375,277
1,600	2.00	30,395	375,277

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	1,841	14	7
segment header	3	0	87
undo header	26	0	0
undo block	5	0	0
1st level bmb	4	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,144	4,144	4,144	212	51.28
TX-Transaction	92,662	92,611	4	1	277.50
HW-Segment High Water Mark	65	65	12	0	24.17
FB-Format Block	41	41	5	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	86.22	172,092	0	12	23.5833333333333333333333333333333333333/24.566666666666666666666666666666666666	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
10-Apr 10:37	41,366	82,440	0	12	25	0/0	0/0/0/0/0/0
10-Apr 10:27	44,854	89,652	0	12	24	0/0	0/0/0/0/0/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,106	0.00		0
Consistent RBA	84,569	0.01	0.33	0
FOB s.o list latch	474	0.00		0
In memory undo latch	882,765	0.27	0.03	92,491	0.00
JS queue state obj latch	3,690	0.00		0
KMG MMAN ready and startup request latch	206	0.00		0
KTF sga latch	1	0.00		207	0.00
KWQMN job cache list latch	8	0.00		0
MQL Tracking Latch	0			13	0.00
Memory Management Latch	0			206	0.00
OS process	345	0.00		0
OS process allocation	435	0.00		0
OS process: request allocation	221	0.00		0
PL/SQL warning settings	106,416	0.14	0.00	0
SGA IO buffer pool latch	5,074	0.00		5,074	0.00
SQL memory manager latch	1	0.00		205	0.00
SQL memory manager workarea list latch	16,498	0.00		0
Shared B-Tree	23	0.00		0
active checkpoint queue latch	7,169	0.00		0
active service list	2,108	0.00		247	0.00
archive control	3	0.00		0
begin backup scn array	2	0.00		0
cache buffer handles	708	0.00		0
cache buffers chains	12,653,511	0.04	0.01	147,428	0.02
cache buffers lru chain	216,475	0.07	0.00	150,615	0.31
cache table scan latch	0			13	0.00
channel handle pool latch	223	0.45	0.00	0
channel operations parent latch	3,243	0.00		0
checkpoint queue latch	129,840	0.00	0.00	66,681	0.01
client/application info	552	0.00		0
commit callback allocation	4	0.00		0
compile environment latch	110,818	0.05	0.00	0
dml lock allocation	647,637	0.40	0.02	0
dummy allocation	221	0.00		0
enqueue hash chains	857,024	0.27	0.04	1,981	0.20
enqueues	130,357	0.07	0.01	0
event group latch	110	0.00		0
file cache latch	42	0.00		0
global KZLD latch for mem in SGA	108	0.00		0
hash table column usage latch	295	0.00		14,910	0.00
hash table modification latch	1	0.00		0
job_queue_processes parameter latch	10	0.00		0
kks stats	1,869	0.00		0
ksuosstats global area	44	0.00		0
ktm global data	5	0.00		0
kwqbsn:qsga	23	0.00		0
lgwr LWN SCN	84,568	0.00	0.00	0
library cache	888,806	0.22	0.02	3,651	0.00
library cache load lock	3,257	0.00		26	0.00
library cache lock	225,591	0.11	0.00	0
library cache lock allocation	2,174	0.00		0
library cache pin	430,636	0.25	0.01	0
library cache pin allocation	514	0.00		0
list of block allocation	228	0.00		0
loader state object freelist	26	0.00		0
message pool operations parent latch	2	0.00		0
messages	278,069	0.03	0.02	0
mostly latch-free SCN	84,705	0.04	0.05	0
multiblock read objects	26	0.00		0
ncodef allocation latch	12	0.00		0
object queue header heap	14,836	0.00		534	0.00
object queue header operation	511,681	0.02	0.04	0
object stats modification	1	0.00		0
parallel query alloc buffer	84	0.00		0
parameter list	409	0.00		0
parameter table allocation management	111	0.00		0
post/wait queue	81,147	0.01	0.17	51,624	0.15
process allocation	221	0.45	0.00	109	0.92
process group creation	221	0.00		0
qmn task queue latch	88	0.00		0
redo allocation	437,695	0.07	0.15	416,858	0.58
redo copy	0			417,919	0.30
redo writing	263,296	0.01	0.06	0
resmgr group change latch	110	0.00		0
resmgr:actses active list	218	0.00		0
resmgr:actses change group	108	0.00		0
resmgr:free threads list	217	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	792,019	0.22	0.00	2,701	0.00
rules engine aggregate statistics	1	0.00		0
rules engine rule set statistics	2	0.00		0
sequence cache	708	0.00		0
session allocation	495,381	0.12	0.03	0
session idle bit	539,898	0.02	0.06	0
session state list latch	225	0.00		0
session switching	12	0.00		0
session timer	247	0.00		0
shared pool	76,934	0.08	0.03	0
shared pool sim alloc	4	0.00		0
shared pool simulator	77,251	0.00		0
simulator hash latch	368,908	0.00		0
simulator lru latch	346,898	0.08	0.02	8,808	0.00
slave class	2	0.00		0
slave class create	8	0.00		0
sort extent pool	24	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	37	0.00		0
transaction allocation	224	0.00		0
transaction branch allocation	12	0.00		0
undo global data	567,753	0.05	0.01	0
user lock	434	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	12,653,511	4,872	73	4,800
dml lock allocation	647,637	2,609	50	2,559
In memory undo latch	882,765	2,402	67	2,335
enqueue hash chains	857,024	2,344	93	2,251
library cache	888,806	1,978	30	1,949
row cache objects	792,019	1,751	6	1,745
library cache pin	430,636	1,060	7	1,053
session allocation	495,381	617	19	598
redo allocation	437,695	313	46	268
undo global data	567,753	309	4	305
simulator lru latch	346,898	263	4	259
library cache lock	225,591	258	1	257
messages	278,069	96	2	94
enqueues	130,357	92	1	91
object queue header operation	511,681	91	4	87
session idle bit	539,898	89	5	84
shared pool	76,934	60	2	59
mostly latch-free SCN	84,705	38	2	36
redo writing	263,296	16	1	15
Consistent RBA	84,569	6	2	4
post/wait queue	81,147	6	1	5

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	42	60
In memory undo latch	kticmt: child	12	0
In memory undo latch	ktichg: child	7	4
In memory undo latch	ktiTxnPoolFree	6	0
cache buffers chains	kcbgtcr: fast path	54	50
cache buffers chains	kcbgtcr: kslbegin excl	10	7
cache buffers chains	kcbchg: kslbegin: bufs not pinned	8	19
cache buffers chains	kcbgtcr: kslbegin shared	8	1
cache buffers chains	kcbzgb: scan from tail. nowait	6	0
cache buffers chains	kcb_post_apply: kcbhq62	5	1
cache buffers chains	kcbgcur: kslbegin	5	19
cache buffers chains	kcbnlc	5	4
cache buffers chains	kcbgtcr	3	0
cache buffers chains	kcbnew: new latch again	3	0
cache buffers chains	kcbbic1	2	2
cache buffers chains	kcb_pre_apply: kcbhq61	1	0
cache buffers chains	kcbchg: kslbegin: call CR func	1	10
cache buffers chains	kcbget: exchange rls	1	0
cache buffers chains	kcbget: pin buffer	1	1
cache buffers chains	kcbrls: kslbegin	1	2
cache buffers chains	kcbzib: finish free bufs	1	0
dml lock allocation	ktaiam	28	39
dml lock allocation	ktaidm	22	11
enqueue hash chains	ksqrcl	49	24
enqueue hash chains	ksqgtl3	42	67
enqueues	ksqdel	1	0
library cache	kglpndl: child: after processing	10	0
library cache	kglpnp: child	8	14
library cache	kglhdgn: child:	3	0
library cache	kglobpn: child:	3	0
library cache	kglLockCursor	2	0
library cache	kglpndl: child: before processing	2	11
library cache	kgldte: child 0	1	6
library cache	kgldti: 2child	1	0
library cache lock	kgllkdl: child: cleanup	1	1
library cache pin	kglpndl	6	1
library cache pin	kglpnp: child	1	6
messages	ksaamb: after wakeup	2	1
mostly latch-free SCN	kcs01	1	3
mostly latch-free SCN	kcs04	1	2
mostly latch-free SCN	kcs05	1	0
mostly latch-free SCN	kcsnew_scn_rba	1	0
object queue header operation	kcbw_link_q	3	0
object queue header operation	kcbw_unlink_q	1	0
post/wait queue	ksliwat:remove	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	45	0
redo allocation	kcrfw_redo_gen: redo allocation 3	1	0
redo writing	kcrfwcr	1	0
row cache objects	kqreqd: reget	5	0
row cache objects	kqrpre: find obj	1	6
session allocation	ksucri	7	18
session allocation	ksuxds: not user session	7	1
session allocation	ksudlc	3	0
session allocation	ksuprc	2	0
session idle bit	ksuxds	3	1
session idle bit	ksupuc: set busy	2	0
shared pool	kghalo	2	0
shared pool	kghfrunp: clatch: nowait	1	0
simulator lru latch	kcbs_simulate: simulate set	3	4
simulator lru latch	kcbs_simbufseq	1	0
undo global data	ktudnx:child	2	0
undo global data	ktubnd:child	1	0
undo global data	ktudba: 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: 6,055,272
Captured Segments account for 85.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	1,917,088	31.66
TPCC	USERS	STOCK	TABLE	948,016	15.66
TPCC	USERS	CUSTOMER_I2	INDEX	375,024	6.19
TPCC	USERS	CUSTOMER	TABLE	354,144	5.85
TPCC	USERS	CUSTOMER_I1	INDEX	268,480	4.43

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 93,319
Captured Segments account for 98.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	ITEM_ID	INDEX	44,969	48.19
TPCC	USERS	ITEM	TABLE	24,676	26.44
TPCC	USERS	CUSTOMER	TABLE	10,575	11.33
TPCC	USERS	STOCK	TABLE	10,532	11.29
SYS	SYSTEM	HISTGRM$	TABLE	364	0.39

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	5,980	71.91
TPCC	USERS	WAREHOUSE		TABLE	2,336	28.09

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	1,449	90.17
TPCC	USERS	WAREHOUSE	TABLE	84	5.23
TPCC	USERS	HISTORY	TABLE	63	3.92
TPCC	USERS	DISTRICT	TABLE	10	0.62
TPCC	USERS	INORD	INDEX	1	0.06

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	13	7.69	2	1
dc_global_oids	76	30.26	0	0
dc_histogram_data	3,754	34.63	0	401
dc_histogram_defs	7,770	39.52	0	613
dc_object_grants	63	31.75	0	5
dc_object_ids	4,831	9.46	0	165
dc_objects	2,632	20.02	0	157
dc_profiles	110	1.82	0	1
dc_rollback_segments	110	0.00	0	23
dc_segments	2,051	28.67	6	136
dc_sequences	21	33.33	21	1
dc_tablespace_quotas	1	100.00	0	0
dc_tablespaces	237,078	0.00	0	5
dc_usernames	399	1.50	0	3
dc_users	6,054	0.79	0	16
outstanding_alerts	13	84.62	1	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	11	45.45	51,548	0.02	5
CLUSTER	39	5.13	87	3.45	1
INDEX	38	73.68	107	28.97	3
SQL AREA	602	72.76	866,585	0.21	135
TABLE/PROCEDURE	1,522	20.37	164,358	0.95	468

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	52.82		1.82	4.03	22	22	29	29
	Freeable	11.69	0.00	1.06	0.96	4		11	11
	SQL	1.38	0.58	0.06	0.03	0	5	23	23
	PL/SQL	1.29	0.30	0.04	0.05	0	0	29	29
E	Other	53.13		1.83	4.02	22	22	29	29
	Freeable	12.13	0.00	1.10	0.96	4		11	11
	SQL	1.70	0.78	0.07	0.03	0	5	23	23
	PL/SQL	1.40	0.57	0.05	0.05	0	0	29	29

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	4.00	4.00	0.00
large	PX msg pool	1.02	1.02	0.00
large	free memory	2.98	2.98	0.00
shared	ASH buffers	8.00	8.00	0.00
shared	FileOpenBlock	1.58	1.58	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGH: NO ACCESS	3.31	3.31	0.00
shared	KGLS heap	0.77	0.82	6.21
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	12.50	12.72	1.75
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kks stbkt	0.88	0.88	0.00
shared	library cache	2.79	2.79	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.12	2.33	9.71
	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	ASYNCH
job_queue_processes	10
open_cursors	300
pga_aggregate_target	108003328
processes	300
remote_login_passwordfile	EXCLUSIVE
sessions	335
sga_target	838860800
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/opt/oracle/admin/TESTIBM/udump

End of Report

% Blocks changed per Read:	24.43	Recursive Call %:	85.79
Rollback per transaction %:	0.00	Rows per Sort:	10.11

Buffer Nowait %:	99.97	Redo NoWait %:	99.99
Buffer Hit %:	98.46	In-memory Sort %:	100.00
Library Hit %:	99.69	Soft Parse %:	99.58
Execute to Parse %:	78.58	Latch Hit %:	99.91
Parse CPU to Parse Elapsd %:	22.91	% Non-Parse CPU:	97.23