WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

TESTIBM 1449334575 TESTIBM 1 10.2.0.2.0 NO brepredbwh04

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
TESTIBM	1449334575	TESTIBM	1	10.2.0.2.0	NO	brepredbwh04

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 56 20-Apr-06 16:20:44 30 14.6

End Snap: 57 20-Apr-06 16:30:46 30 13.9

Elapsed: 10.02 (mins)

DB Time: 94.60 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	56	20-Apr-06 16:20:44	30	14.6
End Snap:	57	20-Apr-06 16:30:46	30	13.9
Elapsed:		10.02 (mins)
DB Time:		94.60 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 720M 720M Std Block Size: 4K

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

	Begin	End
Buffer Cache:	720M	720M	Std Block Size:	4K
Shared Pool Size:	88M	88M	Log Buffer:	6,956K

Load Profile

Per Second Per Transaction

Redo size: 220,746.17 4,146.34

Logical reads: 7,761.19 145.78

Block changes: 1,724.82 32.40

Physical reads: 313.00 5.88

Physical writes: 105.62 1.98

User calls: 246.53 4.63

Parses: 185.93 3.49

Hard parses: 1.02 0.02

Sorts: 10.00 0.19

Logons: 0.13 0.00

Executes: 871.77 16.37

Transactions: 53.24

	Per Second	Per Transaction
Redo size:	220,746.17	4,146.34
Logical reads:	7,761.19	145.78
Block changes:	1,724.82	32.40
Physical reads:	313.00	5.88
Physical writes:	105.62	1.98
User calls:	246.53	4.63
Parses:	185.93	3.49
Hard parses:	1.02	0.02
Sorts:	10.00	0.19
Logons:	0.13	0.00
Executes:	871.77	16.37
Transactions:	53.24

% Blocks changed per Read: 22.22 Recursive Call %: 86.19

Rollback per transaction %: 0.00 Rows per Sort: 10.83

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 100.00

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

Library Hit %: 99.58 Soft Parse %: 99.45

Execute to Parse %: 78.67 Latch Hit %: 99.95

Parse CPU to Parse Elapsd %: 70.88 % Non-Parse CPU: 97.64

Shared Pool Statistics

Begin End

Memory Usage %: 74.22 74.25

% SQL with executions>1: 87.10 87.63

% Memory for SQL w/exec>1: 79.68 79.85

	Begin	End
Memory Usage %:	74.22	74.25
% SQL with executions>1:	87.10	87.63
% Memory for SQL w/exec>1:	79.68	79.85

Top 5 Timed Events

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

db file sequential read 187,348 4,644 25 81.8 User I/O

CPU time 590 10.4

enq: TX - row lock contention 7,555 393 52 6.9 Application

log file sync 32,031 45 1 .8 Commit

SQL*Net break/reset to client 63,344 35 1 .6 Application

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	187,348	4,644	25	81.8	User I/O
CPU time		590		10.4
enq: TX - row lock contention	7,555	393	52	6.9	Application
log file sync	32,031	45	1	.8	Commit
SQL*Net break/reset to client	63,344	35	1	.6	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): 5676.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,584.78	98.39
DB CPU	590.01	10.39
PL/SQL execution elapsed time	38.26	0.67
parse time elapsed	15.07	0.27
hard parse elapsed time	6.20	0.11
PL/SQL compilation elapsed time	1.10	0.02
connection management call elapsed time	0.79	0.01
repeated bind elapsed time	0.47	0.01
hard parse (sharing criteria) elapsed time	0.15	0.00
sequence load elapsed time	0.01	0.00
DB time	5,676.06
background elapsed time	144.54
background cpu time	51.01

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	187,422	0.00	4,645	25	5.86
Application	70,899	0.00	428	6	2.22
Commit	32,031	0.00	45	1	1.00
Concurrency	994	0.80	4	4	0.03
System I/O	71,383	0.00	4	0	2.23
Configuration	28	0.00	2	59	0.00
Network	75,176	0.00	1	0	2.35
Other	523	0.00	0	1	0.02

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	187,348	0.00	4,644	25	5.85
enq: TX - row lock contention	7,555	0.00	393	52	0.24
log file sync	32,031	0.00	45	1	1.00
SQL*Net break/reset to client	63,344	0.00	35	1	1.98
buffer busy waits	873	0.00	4	5	0.03
log file parallel write	63,348	0.00	2	0	1.98
log file switch completion	12	0.00	1	100	0.00
control file parallel write	311	0.00	1	4	0.01
read by other session	50	0.00	1	22	0.00
control file sequential read	883	0.00	1	1	0.03
SQL*Net message to client	74,731	0.00	1	0	2.34
db file scattered read	6	0.00	1	89	0.00
enq: HW - contention	14	0.00	0	32	0.00
db file parallel write	6,833	0.00	0	0	0.21
latch free	45	0.00	0	3	0.00
os thread startup	2	0.00	0	51	0.00
cursor: pin S wait on X	9	88.89	0	11	0.00
LGWR wait for redo copy	371	0.00	0	0	0.01
latch: In memory undo latch	37	0.00	0	1	0.00
latch: cache buffers chains	47	0.00	0	1	0.00
log file single write	4	0.00	0	9	0.00
latch: enqueue hash chains	33	0.00	0	1	0.00
latch: redo allocation	27	0.00	0	1	0.00
log file sequential read	4	0.00	0	5	0.00
latch: session allocation	13	0.00	0	1	0.00
SQL*Net more data to client	429	0.00	0	0	0.01
enq: FB - contention	4	0.00	0	2	0.00
latch: library cache	21	0.00	0	0	0.00
cursor: pin S	21	0.00	0	0	0.00
latch: undo global data	3	0.00	0	1	0.00
latch: row cache objects	2	0.00	0	2	0.00
latch: shared pool	2	0.00	0	1	0.00
latch: object queue header operation	3	0.00	0	1	0.00
latch: library cache pin	1	0.00	0	1	0.00
SQL*Net more data from client	16	0.00	0	0	0.00
latch: messages	3	0.00	0	0	0.00
direct path write	10	0.00	0	0	0.00
latch: redo writing	2	0.00	0	0	0.00
direct path read	8	0.00	0	0	0.00
SQL*Net message from client	74,731	0.00	2,244	30	2.34
Streams AQ: qmn slave idle wait	22	0.00	602	27346	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	602	13673	0.00
Streams AQ: waiting for messages in the queue	120	100.00	586	4884	0.00
class slave wait	1	0.00	0	2	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	70	0.00	3	45	0.00
log file parallel write	63,349	0.00	2	0	1.98
control file parallel write	311	0.00	1	4	0.01
control file sequential read	162	0.00	0	3	0.01
db file parallel write	6,833	0.00	0	0	0.21
events in waitclass Other	401	0.00	0	0	0.01
os thread startup	2	0.00	0	51	0.00
log file single write	4	0.00	0	9	0.00
log file sequential read	4	0.00	0	5	0.00
latch: redo writing	2	0.00	0	0	0.00
direct path read	8	0.00	0	0	0.00
direct path write	6	0.00	0	0	0.00
rdbms ipc message	64,780	2.77	6,304	97	2.02
Streams AQ: qmn slave idle wait	22	0.00	602	27346	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	602	13673	0.00
pmon timer	229	100.00	589	2572	0.01
smon timer	3	66.67	587	195665	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	70,336
IDLE_TIME	171,530
IOWAIT_TIME	111,657
NICE_TIME	0
SYS_TIME	34,580
USER_TIME	33,782
LOAD	9
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,576
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,633.70	574.30	186,266	4,590,442
SYS$USERS	19.90	15.40	125	18,759
SYS$BACKGROUND	0.00	0.00	951	43,407

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	186357	461862	989	433	73628	69
SYS$USERS	108	308	2	0	1313	4
SYS$BACKGROUND	917	2239	3	11	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
2,975	113	31,778	0.09	52.41	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
2,257	34	31,705	0.07	39.77	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
1,859	159	31,918	0.06	32.74	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
1,136	127	19,220	0.06	20.01	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
570	63	31,730	0.02	10.03	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
424	86	3,242	0.13	7.47	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
421	83	3,239	0.13	7.42	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
311	176	3,149	0.10	5.49	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
293	19	31,936	0.01	5.16	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
230	24	12,688	0.02	4.06	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
174	165	3,146	0.06	3.07	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
106	12	1,871	0.06	1.86	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...
87	13	31,705	0.00	1.52	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...

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
176	311	3,149	0.06	5.49	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
165	174	3,146	0.05	3.07	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
159	1,859	31,918	0.00	32.74	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
127	1,136	19,220	0.01	20.01	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
113	2,975	31,778	0.00	52.41	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
86	424	3,242	0.03	7.47	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
83	421	3,239	0.03	7.42	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
63	570	31,730	0.00	10.03	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
34	2,257	31,705	0.00	39.77	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
24	230	12,688	0.00	4.06	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
19	293	31,936	0.00	5.16	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
13	87	31,705	0.00	1.52	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
12	106	1,871	0.01	1.86	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
Total Buffer Gets: 4,665,415
Captured SQL account for 90.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,998,230	3,242	616.36	42.83	85.70	424.04	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
1,989,835	3,239	614.34	42.65	82.79	421.00	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
1,061,251	31,918	33.25	22.75	158.75	1858.61	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
896,022	31,778	28.20	19.21	112.76	2974.89	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
320,448	19,220	16.67	6.87	126.74	1135.78	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
285,336	31,705	9.00	6.12	34.18	2257.42	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
226,377	3,149	71.89	4.85	176.04	311.46	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
222,150	31,705	7.01	4.76	7.73	8.17	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
194,244	31,730	6.12	4.16	62.80	569.57	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
183,416	3,146	58.30	3.93	164.79	174.08	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
138,196	31,936	4.33	2.96	18.62	292.66	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
128,858	31,705	4.06	2.76	13.18	86.52	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
73,211	31,938	2.29	1.57	6.32	9.44	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
66,791	21,117	3.16	1.43	10.27	40.11	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
65,620	31,924	2.06	1.41	7.80	52.33	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
64,874	16,139	4.02	1.39	4.35	4.42	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
64,592	16,148	4.00	1.38	3.71	3.73	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
63,908	31,954	2.00	1.37	7.16	7.18	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
63,730	31,865	2.00	1.37	6.28	6.30	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
63,506	31,751	2.00	1.36	5.52	6.93	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
63,060	15,765	4.00	1.35	4.60	5.10	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
50,760	12,688	4.00	1.09	23.91	230.34	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 188,152
Captured SQL account for 99.4% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
106,050	31,778	3.34	56.36	112.76	2974.89	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
79,931	31,705	2.52	42.48	34.18	2257.42	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
66,708	31,918	2.09	35.45	158.75	1858.61	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
54,999	19,220	2.86	29.23	126.74	1135.78	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
25,881	31,730	0.82	13.76	62.80	569.57	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
10,440	12,688	0.82	5.55	23.91	230.34	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
7,807	3,239	2.41	4.15	82.79	421.00	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
7,807	3,242	2.41	4.15	85.70	424.04	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
6,372	3,149	2.02	3.39	176.04	311.46	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
5,094	1,871	2.72	2.71	11.69	105.79	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: 524,037
Captured SQL account for 99.7% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
31,954	31,954	1.00	0.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
31,938	31,938	1.00	0.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
31,936	31,936	1.00	0.00	0.01	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
31,924	31,925	1.00	0.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
31,918	31,920	1.00	0.00	0.06	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
31,865	31,865	1.00	0.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
31,778	0	0.00	0.00	0.09	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
31,751	31,751	1.00	0.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
31,730	31,729	1.00	0.00	0.02	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
31,705	31,705	1.00	0.00	0.07	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
31,705	31,705	1.00	0.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
31,705	31,705	1.00	0.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
21,117	21,117	1.00	0.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
19,220	139,997	7.28	0.01	0.06	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
16,148	16,148	1.00	0.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
16,139	16,140	1.00	0.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
15,765	15,765	1.00	0.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
12,688	12,690	1.00	0.00	0.02	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: 111,764
Captured SQL account for 98.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
31,918	31,918	28.56	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
31,781	31,778	28.44	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
31,705	31,705	28.37	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
3,242	3,242	2.90	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
3,149	3,149	2.82	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
3,084	3,084	2.76	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
407	407	0.36	2ym6hhaq30r73		select type#, blocks, extents,...
280	862	0.25	3c1kubcdjnppq		update sys.col_usage$ set eq...
280	280	0.25	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
240	242	0.21	asvzxj61dc5vs		select timestamp, flags from ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

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

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

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

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

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

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

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

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

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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	60,684	100.95	1.90
CPU used when call started	60,561	100.75	1.89
CR blocks created	8,807	14.65	0.28
Cached Commit SCN referenced	3,115	5.18	0.10
Commit SCN cached	1	0.00	0.00
DB time	640,966	1,066.28	20.03
DBWR checkpoint buffers written	7,577	12.60	0.24
DBWR checkpoints	2	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	42	0.07	0.00
DBWR undo block writes	31,843	52.97	1.00
DFO trees parallelized	0	0.00	0.00
IMU CR rollbacks	15,347	25.53	0.48
IMU Flushes	45,163	75.13	1.41
IMU Redo allocation size	110,904,672	184,496.42	3,465.45
IMU commits	15,790	26.27	0.49
IMU contention	32,446	53.98	1.01
IMU pool not allocated	2,909	4.84	0.09
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	161,116,708	268,027.08	5,034.43
IMU- failed to get a private strand	2,909	4.84	0.09
OS Involuntary context switches	45,220	75.23	1.41
OS Page faults	54	0.09	0.00
OS Page reclaims	1,501,887	2,498.48	46.93
OS System time used	34,178	56.86	1.07
OS User time used	32,261	53.67	1.01
OS Voluntary context switches	519,453	864.14	16.23
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	74,740	124.33	2.34
active txn count during cleanout	21,082	35.07	0.66
application wait time	43,078	71.66	1.35
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	1,925	3.20	0.06
branch node splits	0	0.00	0.00
buffer is not pinned count	2,322,727	3,863.99	72.58
buffer is pinned count	19,572,218	32,559.53	611.57
bytes received via SQL*Net from client	84,333,861	140,294.32	2,635.19
bytes sent via SQL*Net to client	33,438,118	55,626.27	1,044.84
calls to get snapshot scn: kcmgss	421,804	701.70	13.18
calls to kcmgas	74,926	124.64	2.34
calls to kcmgcs	15,209	25.30	0.48
change write time	1,436	2.39	0.04
cleanout - number of ktugct calls	15,369	25.57	0.48
cleanouts and rollbacks - consistent read gets	7,304	12.15	0.23
cleanouts only - consistent read gets	5	0.01	0.00
cluster key scan block gets	2,253	3.75	0.07
cluster key scans	1,671	2.78	0.05
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	31,732	52.79	0.99
commit batch/immediate requested	31,732	52.79	0.99
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	474	0.79	0.01
commit cleanout failures: cannot pin	1,284	2.14	0.04
commit cleanouts	129,044	214.67	4.03
commit cleanouts successfully completed	127,286	211.75	3.98
commit immediate performed	31,732	52.79	0.99
commit immediate requested	31,732	52.79	0.99
commit txn count during cleanout	1,837	3.06	0.06
concurrency wait time	441	0.73	0.01
consistent changes	20,602	34.27	0.64
consistent gets	3,576,603	5,949.89	111.76
consistent gets - examination	2,860,394	4,758.43	89.38
consistent gets direct	0	0.00	0.00
consistent gets from cache	3,576,603	5,949.89	111.76
current blocks converted for CR	0	0.00	0.00
cursor authentications	155	0.26	0.00
data blocks consistent reads - undo records applied	16,302	27.12	0.51
db block changes	1,036,823	1,724.82	32.40
db block gets	1,088,809	1,811.30	34.02
db block gets direct	36	0.06	0.00
db block gets from cache	1,088,773	1,811.24	34.02
deferred (CURRENT) block cleanout applications	92,514	153.90	2.89
dirty buffers inspected	25,899	43.08	0.81
doubling up with imu segment	0	0.00	0.00
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	127	0.21	0.00
enqueue releases	301,920	502.26	9.43
enqueue requests	301,921	502.26	9.43
enqueue timeouts	0	0.00	0.00
enqueue waits	7,607	12.65	0.24
exchange deadlocks	0	0.00	0.00
execute count	524,037	871.77	16.37
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	228,907	380.80	7.15
free buffer requested	231,723	385.48	7.24
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	1,150	1.91	0.04
hot buffers moved to head of LRU	82,106	136.59	2.57
immediate (CR) block cleanout applications	7,309	12.16	0.23
immediate (CURRENT) block cleanout applications	140	0.23	0.00
index fast full scans (full)	0	0.00	0.00
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	947,940	1,576.95	29.62
index scans kdiixs1	91,570	152.33	2.86
leaf node 90-10 splits	60	0.10	0.00
leaf node splits	67	0.11	0.00
lob reads	163	0.27	0.01
lob writes	141	0.23	0.00
lob writes unaligned	141	0.23	0.00
local undo segment hints helped	0	0.00	0.00
local undo segment hints were stale	0	0.00	0.00
logons cumulative	77	0.13	0.00
messages received	70,391	117.10	2.20
messages sent	70,391	117.10	2.20
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	618,133	1,028.30	19.31
opened cursors cumulative	85,511	142.25	2.67
parse count (failures)	0	0.00	0.00
parse count (hard)	616	1.02	0.02
parse count (total)	111,764	185.93	3.49
parse time cpu	1,390	2.31	0.04
parse time elapsed	1,961	3.26	0.06
physical read IO requests	188,085	312.89	5.88
physical read bytes	770,670,592	1,282,055.68	24,081.20
physical read total IO requests	188,970	314.36	5.90
physical read total bytes	785,045,504	1,305,969.19	24,530.37
physical read total multi block requests	6	0.01	0.00
physical reads	188,152	313.00	5.88
physical reads cache	188,144	312.99	5.88
physical reads cache prefetch	67	0.11	0.00
physical reads direct	8	0.01	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	28,560	47.51	0.89
physical write bytes	260,046,848	432,603.17	8,125.70
physical write total IO requests	93,537	155.60	2.92
physical write total bytes	426,552,832	709,595.63	13,328.53
physical write total multi block requests	63,935	106.36	2.00
physical writes	63,488	105.62	1.98
physical writes direct	44	0.07	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	63,444	105.54	1.98
physical writes non checkpoint	59,932	99.70	1.87
pinned buffers inspected	0	0.00	0.00
prefetch clients - default	1	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	611	1.02	0.02
queries parallelized	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	925,034	1,538.85	28.90
recursive cpu usage	49,601	82.51	1.55
redo blocks read for recovery	0	0.00	0.00
redo blocks written	295,340	491.32	9.23
redo buffer allocation retries	11	0.02	0.00
redo entries	322,195	535.99	10.07
redo log space requests	12	0.02	0.00
redo log space wait time	123	0.20	0.00
redo ordering marks	1,889	3.14	0.06
redo size	132,695,160	220,746.17	4,146.34
redo synch time	4,720	7.85	0.15
redo synch writes	76,816	127.79	2.40
redo wastage	13,732,996	22,845.64	429.12
redo write time	5,720	9.52	0.18
redo writer latching time	12	0.02	0.00
redo writes	63,565	105.74	1.99
rollback changes - undo records applied	158,660	263.94	4.96
rollbacks only - consistent read gets	1,517	2.52	0.05
rows fetched via callback	814,967	1,355.75	25.47
session connect time	0	0.00	0.00
session cursor cache hits	80,988	134.73	2.53
session logical reads	4,665,415	7,761.19	145.78
session pga memory	65,536	109.02	2.05
session uga memory	1,759,716	2,927.39	54.99
session uga memory max	34,592,468	57,546.60	1,080.91
shared hash latch upgrades - no wait	134,719	224.11	4.21
shared hash latch upgrades - wait	4	0.01	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	6,010	10.00	0.19
sorts (rows)	65,084	108.27	2.03
space was found by tune down	0	0.00	0.00
space was not found by tune down	0	0.00	0.00
sql area evicted	236	0.39	0.01
sql area purged	0	0.00	0.00
steps of tune down ret. in space pressure	0	0.00	0.00
summed dirty queue length	54,330	90.38	1.70
switch current to new buffer	21	0.03	0.00
table fetch by rowid	10,551,860	17,553.64	329.71
table fetch continued row	353	0.59	0.01
table scan blocks gotten	13,969	23.24	0.44
table scan rows gotten	30,583	50.88	0.96
table scans (cache partitions)	0	0.00	0.00
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	186	0.31	0.01
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	31,732	52.79	0.99
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	35,331,644	58,776.26	1,104.01
user I/O wait time	466,645	776.29	14.58
user calls	148,194	246.53	4.63
user commits	32,003	53.24	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	4,837	8.05	0.15
write clones created in background	0	0.00	0.00
write clones created in foreground	13	0.02	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	26,730	27,654
opened cursors current	437	417
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)	2	11.98

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	186,299	310	24.78	1.00	26,897	45	889	6.07
UNDOTBS1	2	0	260.00	1.00	1,198	2	34	0.59
SYSAUX	718	1	24.18	1.07	314	1	0	0.00
SYSTEM	287	0	30.59	1.05	17	0	0	0.00
TEMP	1	0	70.00	1.00	1	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	718	1	24.18	1.07	314	1	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	287	0	30.59	1.05	17	0	0	0.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	1	0	70.00	1.00	1	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	2	0	260.00	1.00	1,198	2	34	0.59
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	186,299	310	24.78	1.00	26,897	45	889	6.07

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	175,966	96	4,657,126	187,892	63,171	0	0	926

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	27	15461	146073	758756	2027520	758756
E	0	28	16765	151147	870713	2027520	870713

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	72	0.10	17,604	1.69	19,144,726
D	144	0.20	35,208	1.49	16,954,846
D	216	0.30	52,812	1.41	15,972,754
D	288	0.40	70,416	1.34	15,224,399
D	360	0.50	88,020	1.29	14,631,420
D	432	0.60	105,624	1.24	14,135,147
D	504	0.70	123,228	1.18	13,457,558
D	576	0.80	140,832	1.09	12,381,744
D	648	0.90	158,436	1.04	11,763,463
D	720	1.00	176,040	1.00	11,358,187
D	792	1.10	193,644	0.97	11,010,579
D	864	1.20	211,248	0.94	10,671,337
D	936	1.30	228,852	0.91	10,368,502
D	1,008	1.40	246,456	0.89	10,099,823
D	1,080	1.50	264,060	0.87	9,857,300
D	1,152	1.60	281,664	0.85	9,618,099
D	1,224	1.70	299,268	0.83	9,409,461
D	1,296	1.80	316,872	0.81	9,197,297
D	1,368	1.90	334,476	0.79	9,007,818
D	1,440	2.00	352,080	0.78	8,831,343

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	159	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	274	200	108.32	0.00	0.00	0.00	0.00	56,115
E	274	200	107.82	0.00	0.00	0.00	0.00	56,115

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	4,625	4,625
64K	128K	5	5
256K	512K	4	4
512K	1024K	200	200

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
34	0.13	4,516.39	1,634.45	73.00	122
69	0.25	4,516.39	508.70	90.00	0
137	0.50	4,516.39	134.64	97.00	0
206	0.75	4,516.39	55.43	99.00	0
274	1.00	4,516.39	0.00	100.00	0
329	1.20	4,516.39	0.00	100.00	0
384	1.40	4,516.39	0.00	100.00	0
438	1.60	4,516.39	0.00	100.00	0
493	1.80	4,516.39	0.00	100.00	0
548	2.00	4,516.39	0.00	100.00	0
822	3.00	4,516.39	0.00	100.00	0
1,096	4.00	4,516.39	0.00	100.00	0
1,644	6.00	4,516.39	0.00	100.00	0
2,192	8.00	4,516.39	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
64	0.73	11	1,349	398,801	0.83	84,042	73.02	6,467,051
76	0.86	22	2,222	449,071	0.93	33,772	29.34	6,501,028
88	1.00	33	2,905	481,692	1.00	1,151	1.00	6,520,367
100	1.14	44	3,439	508,126	1.05	1	0.00	6,528,319
112	1.27	56	3,901	512,411	1.06	1	0.00	6,531,544
124	1.41	67	4,702	512,623	1.06	1	0.00	6,533,275
136	1.55	78	5,200	512,696	1.06	1	0.00	6,534,452
148	1.68	89	5,913	512,719	1.06	1	0.00	6,535,201
160	1.82	100	6,596	512,728	1.06	1	0.00	6,535,454
172	1.95	111	7,288	512,752	1.06	1	0.00	6,535,706
184	2.09	123	7,777	512,759	1.06	1	0.00	6,535,871

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
206	0.25	440,302	19,139,601
412	0.50	329,863	15,220,837
618	0.75	280,090	13,453,930
824	1.00	220,920	11,355,444
1,030	1.25	193,071	10,366,385
1,236	1.50	171,930	9,616,926
1,442	1.75	154,744	9,006,003
1,648	2.00	149,775	8,829,993

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	870	5	6
2nd level bmb	10	0	35
undo header	34	0	1
1st level bmb	8	0	0
undo block	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)	7,542	7,542	7,542	403	53.47
HW-Segment High Water Mark	60	60	8	0	53.75
FB-Format Block	144	144	4	0	2.50

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	32.16	63,710	0	12	80.1/80.1	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
20-Apr 16:27	32,161	63,710	0	12	80	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,125	0.00		0
Consistent RBA	63,380	0.00		0
FOB s.o list latch	320	0.00		0
In memory undo latch	618,867	0.10	0.06	63,804	0.00
JS queue state obj latch	3,600	0.00		0
KMG MMAN ready and startup request latch	201	0.00		0
KTF sga latch	1	0.00		202	0.00
KWQMN job cache list latch	1	0.00		0
MQL Tracking Latch	0			12	0.00
Memory Management Latch	0			201	0.00
OS process	246	0.00		0
OS process allocation	365	0.00		0
OS process: request allocation	156	0.00		0
PL/SQL warning settings	73,206	0.06	0.00	0
SGA IO buffer pool latch	33	0.00		33	0.00
SQL memory manager latch	1	0.00		200	0.00
SQL memory manager workarea list latch	15,155	0.01	0.00	0
Shared B-Tree	23	0.00		0
active checkpoint queue latch	7,000	0.00		0
active service list	1,956	0.00		229	0.00
archive control	2	0.00		0
begin backup scn array	1	0.00		0
cache buffer handles	3,148	0.03	0.00	0
cache buffers chains	9,735,818	0.03	0.02	229,636	0.02
cache buffers lru chain	190,261	0.07	0.00	239,089	0.45
cache table scan latch	0			6	0.00
channel handle pool latch	158	0.00		0
channel operations parent latch	3,066	0.00		0
checkpoint queue latch	116,829	0.00	0.00	61,132	0.01
client/application info	402	0.00		0
compile environment latch	76,986	0.02	0.00	0
dml lock allocation	447,893	0.32	0.01	0
dummy allocation	156	0.00		0
enqueue hash chains	609,602	0.22	0.02	2,613	0.11
enqueues	102,838	0.04	0.03	0
event group latch	78	0.00		0
file cache latch	54	0.00		0
global KZLD latch for mem in SGA	76	0.00		0
hash table column usage latch	294	0.00		15,615	0.00
hash table modification latch	1	0.00		0
job_queue_processes parameter latch	10	0.00		0
kks stats	1,757	0.00		0
ksuosstats global area	43	0.00		0
ktm global data	3	0.00		0
kwqbsn:qsga	23	0.00		0
lgwr LWN SCN	63,382	0.00	0.00	0
library cache	620,508	0.12	0.03	3,274	0.09
library cache load lock	3,214	0.00		0
library cache lock	158,159	0.01	0.00	0
library cache lock allocation	1,549	0.00		0
library cache pin	297,591	0.13	0.00	0
library cache pin allocation	412	0.00		0
list of block allocation	186	0.00		0
loader state object freelist	26	0.00		0
message pool operations parent latch	2	0.00		0
messages	210,686	0.02	0.08	0
mostly latch-free SCN	63,450	0.02	0.14	0
multiblock read objects	12	0.00		0
ncodef allocation latch	11	0.00		0
object queue header heap	14,099	0.01	0.00	172	0.00
object queue header operation	649,658	0.02	0.02	0
object stats modification	1	0.00		0
parallel query alloc buffer	80	0.00		0
parameter list	283	0.00		0
parameter table allocation management	78	0.00		0
post/wait queue	50,264	0.01	0.29	32,104	0.05
process allocation	156	0.64	0.00	77	1.30
process group creation	156	0.00		0
qmn task queue latch	88	0.00		0
redo allocation	316,074	0.05	0.16	321,160	0.24
redo copy	0			321,479	0.19
redo writing	198,098	0.00	0.29	0
resmgr group change latch	80	0.00		0
resmgr:actses active list	153	0.00		0
resmgr:actses change group	76	0.00		0
resmgr:free threads list	152	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	562,057	0.08	0.00	2,315	0.22
sequence cache	624	0.00		0
session allocation	393,720	0.12	0.03	0
session idle bit	372,471	0.01	0.09	0
session state list latch	162	0.00		0
session switching	11	0.00		0
session timer	229	0.00		0
shared pool	67,634	0.19	0.02	0
shared pool simulator	66,601	0.00		0
simulator hash latch	455,995	0.00	0.50	0
simulator lru latch	425,179	0.13	0.03	14,149	0.00
slave class	2	0.00		0
slave class create	8	12.50	1.00	0
sort extent pool	23	0.00		0
state object free list	2	0.00		0
statistics aggregation	112	0.00		0
temp lob duration state obj allocation	2	0.00		0
threshold alerts latch	36	0.00		0
transaction allocation	152	0.00		0
transaction branch allocation	11	0.00		0
undo global data	432,392	0.04	0.02	0
user lock	304	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	9,735,818	2,584	46	2,540
dml lock allocation	447,893	1,421	18	1,403
enqueue hash chains	609,602	1,332	33	1,299
library cache	620,508	743	21	722
In memory undo latch	618,867	613	37	576
simulator lru latch	425,179	548	17	531
session allocation	393,720	485	13	472
row cache objects	562,057	462	2	460
library cache pin	297,591	390	1	389
undo global data	432,392	192	3	189
redo allocation	316,074	166	27	139
object queue header operation	649,658	136	3	133
shared pool	67,634	130	2	128
enqueues	102,838	39	1	38
messages	210,686	39	3	36
session idle bit	372,471	35	3	32
mostly latch-free SCN	63,450	14	2	12
post/wait queue	50,264	7	2	5
redo writing	198,098	7	2	5
simulator hash latch	455,995	2	1	1
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	20	30
In memory undo latch	ktiTxnPoolFree	8	0
In memory undo latch	kticmt: child	6	0
In memory undo latch	kturbk	2	5
In memory undo latch	ktichg: child	1	2
cache buffers chains	kcbgtcr: fast path	23	28
cache buffers chains	kcbgtcr: kslbegin excl	14	1
cache buffers chains	kcbzgb: scan from tail. nowait	10	0
cache buffers chains	kcbchg: kslbegin: bufs not pinned	7	6
cache buffers chains	kcbgcur: kslbegin	7	20
cache buffers chains	kcbchg: kslbegin: call CR func	3	7
cache buffers chains	kcbgtcr: kslbegin shared	3	1
cache buffers chains	kcbbxsv	2	0
cache buffers chains	kcb_post_apply: kcbhq62	1	1
cache buffers chains	kcbget: exchange rls	1	0
cache buffers chains	kcbget: pin buffer	1	2
cache buffers chains	kcbnew: new latch again	1	0
cache buffers chains	kcbnlc	1	5
cache buffers chains	kcbrls: kslbegin	1	2
cache buffers chains	kcbzib: finish free bufs	1	0
cache buffers chains	kcbzwb	1	0
dml lock allocation	ktaiam	9	16
dml lock allocation	ktaidm	9	2
enqueue hash chains	ksqgtl3	19	23
enqueue hash chains	ksqrcl	13	10
enqueue hash chains	ksqcmi: get hash chain latch after wait	1	0
enqueues	ksqgel: create enqueue	1	0
library cache	kglpnp: child	8	9
library cache	kglhdgn: child:	3	0
library cache	kglpndl: child: before processing	3	6
library cache	kgldte: child 0	2	6
library cache	kglpndl: child: after processing	2	0
library cache	kglLockCursor	1	0
library cache	kgldti: 2child	1	0
library cache pin	kglpnp: child	1	1
messages	ksaamb: after wakeup	2	1
messages	ksarcv	1	2
mostly latch-free SCN	kcs04	1	2
mostly latch-free SCN	kcs05	1	0
object queue header operation	kcbo_switch_cq	2	1
object queue header operation	kcbw_unlink_q	1	1
post/wait queue	ksliwat:add:nowait	1	0
post/wait queue	ksliwat:remove	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	26	0
redo allocation	kcrfw_redo_gen: redo allocation 2	1	0
redo writing	kcrfwcr	2	0
row cache objects	kqreqd: reget	1	0
row cache objects	kqrpre: find obj	1	2
session allocation	ksudlc	4	0
session allocation	ksuprc	4	0
session allocation	ksuxds: not user session	3	3
session allocation	ksucri	2	10
session idle bit	ksupuc: clear busy	1	1
session idle bit	ksupuc: set busy	1	2
session idle bit	ksuxds	1	0
shared pool	kghalo	2	1
shared pool	kghfrunp: clatch: nowait	1	0
simulator hash latch	kcbsacc: remove dba	1	0
simulator lru latch	kcbs_simulate: simulate set	17	17
slave class create	ksvcreate	1	0
undo global data	ktudnx:child	2	0
undo global data	ktufrbs: child	1	2

Back to Latch Statistics
Back to Top

Parent Latch Statistics

only latches with sleeps are shown
ordered by name

Latch Name	Get Requests	Misses	Sleeps	Spin & Sleeps 1->3+
dml lock allocation	448,712	1,423	18	1405/0/0/0
enqueues	103,113	40	1	39/0/0/0
messages	211,045	40	3	37/0/0/0
mostly latch-free SCN	63,562	14	2	12/0/0/0
redo writing	198,402	7	2	5/0/0/0
session allocation	393,894	483	13	470/0/0/0
slave class create	8	1	1	0/0/0/0

Back to Latch Statistics
Back to Top

Child Latch Statistics

only latches with sleeps/gets > 1/100000 are shown
ordered by name, gets desc

Latch Name	Child Num	Get Requests	Misses	Sleeps	Spin & Sleeps 1->3+
In memory undo latch	1	64,883	57	3	54/0/0/0
In memory undo latch	5	63,299	68	9	59/0/0/0
In memory undo latch	6	63,208	76	7	69/0/0/0
In memory undo latch	4	62,925	73	1	72/0/0/0
In memory undo latch	7	62,545	55	2	53/0/0/0
In memory undo latch	8	62,032	46	4	42/0/0/0
In memory undo latch	9	59,115	56	3	53/0/0/0
In memory undo latch	3	59,051	68	4	64/0/0/0
In memory undo latch	10	58,393	51	3	48/0/0/0
In memory undo latch	11	1,691	4	1	3/0/0/0
cache buffers chains	1237	407,816	983	12	973/0/0/0
cache buffers chains	677	100,290	219	3	216/0/0/0
cache buffers chains	110	98,396	141	1	140/0/0/0
cache buffers chains	128	73,006	22	3	19/0/0/0
cache buffers chains	1482	39,159	1	1	0/0/0/0
cache buffers chains	1692	37,331	19	2	17/0/0/0
cache buffers chains	1877	36,939	28	3	25/0/0/0
cache buffers chains	1554	33,362	4	1	3/0/0/0
cache buffers chains	1047	32,637	7	1	6/0/0/0
cache buffers chains	1241	30,496	6	1	5/0/0/0
cache buffers chains	1470	29,335	9	1	8/0/0/0
cache buffers chains	1691	27,592	5	1	4/0/0/0
cache buffers chains	359	25,580	6	1	5/0/0/0
cache buffers chains	1408	8,926	1	1	0/0/0/0
cache buffers chains	1733	8,556	1	1	0/0/0/0
cache buffers chains	371	8,283	1	1	0/0/0/0
cache buffers chains	643	6,031	1	1	0/0/0/0
cache buffers chains	1123	4,660	1	1	0/0/0/0
cache buffers chains	1389	3,821	1	1	0/0/0/0
cache buffers chains	814	3,019	1	1	0/0/0/0
cache buffers chains	172	2,900	1	1	0/0/0/0
cache buffers chains	992	2,846	1	1	0/0/0/0
cache buffers chains	370	2,797	1	1	0/0/0/0
cache buffers chains	1175	2,609	1	1	0/0/0/0
cache buffers chains	166	2,570	1	1	0/0/0/0
cache buffers chains	949	2,417	1	1	0/0/0/0
cache buffers chains	1923	2,197	1	1	0/0/0/0
enqueue hash chains	1	169,575	425	10	415/0/0/0
enqueue hash chains	2	169,028	363	9	354/0/0/0
enqueue hash chains	3	168,515	316	8	308/0/0/0
enqueue hash chains	4	102,602	227	6	221/0/0/0
library cache	4	275,958	387	11	376/0/0/0
library cache	3	105,911	166	3	163/0/0/0
library cache	5	95,124	82	6	76/0/0/0
library cache pin	3	66,523	74	1	73/0/0/0
post/wait queue	5	33,008	4	2	2/0/0/0
redo allocation	1	126,664	160	26	134/0/0/0
session idle bit	4	132,972	18	2	16/0/0/0
session idle bit	1	89,913	11	1	10/0/0/0
shared pool	1	67,629	130	2	128/0/0/0
simulator hash latch	60	27,474	1	1	0/0/0/0
simulator lru latch	6	238,999	364	10	354/0/0/0
simulator lru latch	5	186,004	184	7	177/0/0/0
undo global data	5	86,517	30	2	28/0/0/0
undo global data	1	85,270	46	1	45/0/0/0

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 4,665,415
Captured Segments account for 85.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	1,300,416	27.87
TPCC	USERS	STOCK	TABLE	648,912	13.91
TPCC	USERS	CUSTOMER_I1	INDEX	278,704	5.97
TPCC	USERS	CUSTOMER_I2	INDEX	262,704	5.63
TPCC	USERS	CUSTOMER	TABLE	248,592	5.33

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 188,152
Captured Segments account for 99.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	CUSTOMER		TABLE	97,377	51.75
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	56,897	30.24
TPCC	USERS	ITEM		TABLE	22,918	12.18
TPCC	USERS	STOCK		TABLE	6,691	3.56
TPCC	USERS	CUSTOMER_I2		INDEX	822	0.44

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	10,832	71.70
TPCC	USERS	DISTRICT	TABLE	4,274	28.29
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	INORD	INDEX	634	75.48
TPCC	USERS	HISTORY	TABLE	82	9.76
TPCC	USERS	ORDERS	TABLE	68	8.10
TPCC	USERS	WAREHOUSE	TABLE	32	3.81
TPCC	USERS	DISTRICT	TABLE	24	2.86

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	14	7.14	2	1
dc_global_oids	61	31.15	0	0
dc_histogram_data	877	32.50	0	83
dc_histogram_defs	7,777	37.20	0	892
dc_object_grants	44	27.27	0	5
dc_object_ids	4,947	9.18	0	270
dc_objects	2,490	21.29	0	250
dc_profiles	75	1.33	0	1
dc_rollback_segments	114	0.00	0	24
dc_segments	1,859	22.05	2	98
dc_sequences	18	27.78	18	1
dc_tablespaces	163,321	0.00	0	5
dc_usernames	298	2.35	0	1
dc_users	4,979	0.32	0	14
outstanding_alerts	13	76.92	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	8	25.00	35,046	0.02	6	0
CLUSTER	18	0.00	87	3.45	3	0
INDEX	39	79.49	111	33.33	6	0
SQL AREA	577	73.48	601,186	0.27	123	2
TABLE/PROCEDURE	1,301	23.98	114,141	1.29	424	0

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	90.78		3.03	7.74	32	33	30	30
	Freeable	13.94	0.00	1.16	0.62	3		12	12
	SQL	2.04	1.01	0.08	0.04	0	8	24	23
	PL/SQL	1.58	0.68	0.05	0.06	0	0	30	30
E	Other	90.74		3.02	7.74	32	33	30	30
	Freeable	13.50	0.00	1.13	0.66	3		12	12
	SQL	2.06	1.06	0.09	0.04	0	8	24	23
	PL/SQL	1.54	0.76	0.05	0.06	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	754,974,720
Fixed Size	1,263,716
Redo Buffers	7,122,944
Variable Size	100,665,244

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	11.71	11.71	0.00
shared	KGLS heap		1.05
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KTI-UNDO	2.36	2.36	0.00
shared	db_block_hash_buckets	4.25	4.25	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	22.69	22.66	-0.14
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	library cache	3.17	3.17	0.03
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.29	2.36	2.90
	buffer_cache	720.00	720.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	/u01/app/oracle/admin/TESTIBM/adump
background_dump_dest	/u01/app/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, /u02/app/oracle/oradata/TESTIBM/control03.ctl
core_dump_dest	/u01/app/oracle/admin/TESTIBM/cdump
db_block_size	4096
db_domain
db_file_multiblock_read_count	16
db_name	TESTIBM
filesystemio_options	asynch
job_queue_processes	10
open_cursors	300
pga_aggregate_target	287309824
processes	300
remote_login_passwordfile	EXCLUSIVE
sessions	335
sga_target	864026624
statistics_level	ALL
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/u01/app/oracle/admin/TESTIBM/udump

End of Report

% Blocks changed per Read:	22.22	Recursive Call %:	86.19
Rollback per transaction %:	0.00	Rows per Sort:	10.83

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	95.97	In-memory Sort %:	100.00
Library Hit %:	99.58	Soft Parse %:	99.45
Execute to Parse %:	78.67	Latch Hit %:	99.95
Parse CPU to Parse Elapsd %:	70.88	% Non-Parse CPU:	97.64