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: 55 20-Apr-06 16:10:43 30 14.4

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

Elapsed: 10.02 (mins)

DB Time: 94.88 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	55	20-Apr-06 16:10:43	30	14.4
End Snap:	56	20-Apr-06 16:20:44	30	14.6
Elapsed:		10.02 (mins)
DB Time:		94.88 (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: 214,744.05 4,108.79

Logical reads: 7,812.84 149.49

Block changes: 1,760.67 33.69

Physical reads: 313.31 5.99

Physical writes: 108.89 2.08

User calls: 242.08 4.63

Parses: 186.56 3.57

Hard parses: 2.08 0.04

Sorts: 12.91 0.25

Logons: 0.13 0.00

Executes: 866.26 16.57

Transactions: 52.26

	Per Second	Per Transaction
Redo size:	214,744.05	4,108.79
Logical reads:	7,812.84	149.49
Block changes:	1,760.67	33.69
Physical reads:	313.31	5.99
Physical writes:	108.89	2.08
User calls:	242.08	4.63
Parses:	186.56	3.57
Hard parses:	2.08	0.04
Sorts:	12.91	0.25
Logons:	0.13	0.00
Executes:	866.26	16.57
Transactions:	52.26

% Blocks changed per Read: 22.54 Recursive Call %: 87.87

Rollback per transaction %: 0.00 Rows per Sort: 10.73

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 100.00

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

Library Hit %: 99.21 Soft Parse %: 98.88

Execute to Parse %: 78.46 Latch Hit %: 99.94

Parse CPU to Parse Elapsd %: 76.18 % Non-Parse CPU: 96.17

Shared Pool Statistics

Begin End

Memory Usage %: 74.33 74.22

% SQL with executions>1: 87.50 87.10

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

	Begin	End
Memory Usage %:	74.33	74.22
% SQL with executions>1:	87.50	87.10
% Memory for SQL w/exec>1:	79.49	79.68

Top 5 Timed Events

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

db file sequential read 188,215 4,792 25 84.2 User I/O

CPU time 541 9.5

enq: TX - row lock contention 6,016 331 55 5.8 Application

log file sync 31,919 42 1 .7 Commit

SQL*Net break/reset to client 61,884 30 0 .5 Application

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	188,215	4,792	25	84.2	User I/O
CPU time		541		9.5
enq: TX - row lock contention	6,016	331	55	5.8	Application
log file sync	31,919	42	1	.7	Commit
SQL*Net break/reset to client	61,884	30	0	.5	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): 5692.8s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	5,605.14	98.46
DB CPU	541.37	9.51
PL/SQL execution elapsed time	40.59	0.71
parse time elapsed	30.23	0.53
hard parse elapsed time	19.27	0.34
PL/SQL compilation elapsed time	3.51	0.06
connection management call elapsed time	1.51	0.03
hard parse (sharing criteria) elapsed time	0.88	0.02
repeated bind elapsed time	0.54	0.01
sequence load elapsed time	0.20	0.00
hard parse (bind mismatch) elapsed time	0.07	0.00
DB time	5,692.83
background elapsed time	137.02
background cpu time	51.00

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	188,350	0.00	4,796	25	6.00
Application	67,900	0.00	362	5	2.16
Commit	31,919	0.00	42	1	1.02
Concurrency	1,195	20.92	7	6	0.04
System I/O	69,961	0.00	3	0	2.23
Network	74,402	0.00	1	0	2.37
Configuration	14	0.00	0	28	0.00
Other	478	0.21	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	188,215	0.00	4,792	25	5.99
enq: TX - row lock contention	6,016	0.00	331	55	0.19
log file sync	31,919	0.00	42	1	1.02
SQL*Net break/reset to client	61,884	0.00	30	0	1.97
cursor: pin S wait on X	251	99.60	3	12	0.01
buffer busy waits	852	0.00	3	3	0.03
read by other session	103	0.00	2	20	0.00
log file parallel write	61,986	0.00	2	0	1.97
db file scattered read	20	0.00	2	82	0.00
control file parallel write	295	0.00	1	3	0.01
SQL*Net message to client	73,876	0.00	1	0	2.35
library cache load lock	7	0.00	0	65	0.00
log file switch completion	8	0.00	0	37	0.00
control file sequential read	873	0.00	0	0	0.03
db file parallel write	6,803	0.00	0	0	0.22
os thread startup	2	0.00	0	55	0.00
latch free	50	0.00	0	2	0.00
enq: HW - contention	5	0.00	0	20	0.00
row cache lock	8	0.00	0	12	0.00
LGWR wait for redo copy	338	0.00	0	0	0.01
kksfbc child completion	1	100.00	0	52	0.00
latch: enqueue hash chains	37	0.00	0	1	0.00
SQL*Net more data to client	509	0.00	0	0	0.02
enq: FB - contention	4	0.00	0	5	0.00
log file single write	2	0.00	0	9	0.00
latch: cache buffers chains	22	0.00	0	1	0.00
latch: In memory undo latch	24	0.00	0	1	0.00
latch: library cache	15	0.00	0	1	0.00
latch: redo allocation	29	0.00	0	0	0.00
latch: shared pool	4	0.00	0	2	0.00
log file sequential read	2	0.00	0	4	0.00
cursor: pin S	2	0.00	0	4	0.00
latch: row cache objects	4	0.00	0	2	0.00
latch: undo global data	4	0.00	0	2	0.00
latch: library cache pin	6	0.00	0	1	0.00
latch: session allocation	9	0.00	0	0	0.00
latch: object queue header operation	3	0.00	0	1	0.00
latch: messages	1	0.00	0	2	0.00
SQL*Net more data from client	17	0.00	0	0	0.00
direct path write	8	0.00	0	0	0.00
direct path read	4	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
SQL*Net message from client	73,877	0.00	2,270	31	2.35
Streams AQ: waiting for messages in the queue	120	100.00	586	4884	0.00
Streams AQ: qmn slave idle wait	21	0.00	574	27346	0.00
Streams AQ: qmn coordinator idle wait	42	50.00	574	13673	0.00
class slave wait	2	0.00	0	3	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	61,982	0.00	2	0	1.97
control file parallel write	295	0.00	1	3	0.01
db file sequential read	38	0.00	0	8	0.00
db file parallel write	6,803	0.00	0	0	0.22
os thread startup	2	0.00	0	55	0.00
control file sequential read	141	0.00	0	1	0.00
events in waitclass Other	368	0.00	0	0	0.01
log file single write	2	0.00	0	9	0.00
log file sequential read	2	0.00	0	4	0.00
direct path read	4	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
direct path write	6	0.00	0	0	0.00
rdbms ipc message	63,458	2.83	4,600	72	2.02
pmon timer	221	100.00	586	2652	0.01
Streams AQ: qmn slave idle wait	21	0.00	574	27346	0.00
Streams AQ: qmn coordinator idle wait	42	50.00	574	13673	0.00
smon timer	2	50.00	501	250290	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	65,125
IDLE_TIME	175,426
IOWAIT_TIME	109,090
NICE_TIME	0
SYS_TIME	29,762
USER_TIME	33,363
LOAD	9
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,764
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,642.30	501.00	186,874	4,417,906
SYS$USERS	51.60	36.80	799	246,252
SYS$BACKGROUND	0.00	0.00	852	38,803

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	186960	476379	1178	644	72404	70
SYS$USERS	612	1354	14	14	1791	3
SYS$BACKGROUND	815	1982	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,991	108	30,929	0.10	52.55	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
2,290	33	30,834	0.07	40.23	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
1,788	156	31,340	0.06	31.40	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
1,125	123	18,961	0.06	19.77	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
566	62	30,856	0.02	9.94	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
430	120	3,088	0.14	7.56	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
343	81	3,175	0.11	6.02	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
339	79	3,172	0.11	5.96	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
290	109	3,080	0.09	5.09	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
248	17	31,390	0.01	4.36	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
230	23	12,392	0.02	4.05	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
107	12	1,824	0.06	1.87	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...
73	13	30,834	0.00	1.29	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
156	1,788	31,340	0.00	31.40	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
123	1,125	18,961	0.01	19.77	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
120	430	3,088	0.04	7.56	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
109	290	3,080	0.04	5.09	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
108	2,991	30,929	0.00	52.55	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
81	343	3,175	0.03	6.02	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
79	339	3,172	0.02	5.96	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
62	566	30,856	0.00	9.94	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
33	2,290	30,834	0.00	40.23	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
23	230	12,392	0.00	4.05	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
17	248	31,390	0.00	4.36	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
13	73	30,834	0.00	1.29	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
12	107	1,824	0.01	1.87	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,696,116
Captured SQL account for 88.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,924,515	3,175	606.15	40.98	81.35	342.61	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
1,916,043	3,172	604.05	40.80	78.61	339.38	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
1,038,460	31,340	33.14	22.11	155.78	1787.63	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
871,746	30,929	28.19	18.56	108.49	2991.36	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
314,207	18,961	16.57	6.69	122.86	1125.43	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
277,470	30,834	9.00	5.91	33.05	2290.21	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
216,040	30,831	7.01	4.60	7.36	7.71	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
188,254	30,856	6.10	4.01	62.21	565.91	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
166,262	3,088	53.84	3.54	120.09	430.24	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
133,916	31,390	4.27	2.85	17.36	248.27	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
125,360	30,834	4.07	2.67	12.58	73.22	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
123,442	3,080	40.08	2.63	109.31	289.87	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
115,862	1	115,862.00	2.47	10.38	18.40	0a59tkkpx31vx	Admin Connection	select output from table(dbms_...
71,399	31,388	2.27	1.52	6.17	7.15	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
64,200	31,367	2.05	1.37	7.47	43.94	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
63,533	15,811	4.02	1.35	4.26	4.35	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
63,332	15,815	4.00	1.35	3.63	3.95	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
62,904	31,394	2.00	1.34	7.16	7.66	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
62,560	31,271	2.00	1.33	6.12	6.19	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
62,048	15,512	4.00	1.32	4.43	4.50	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
61,990	30,881	2.01	1.32	5.70	7.59	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
49,599	12,392	4.00	1.06	22.56	230.28	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,326
Captured SQL account for 99.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
103,505	30,929	3.35	54.96	108.49	2991.36	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
77,898	30,834	2.53	41.36	33.05	2290.21	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
64,740	31,340	2.07	34.38	155.78	1787.63	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
53,582	18,961	2.83	28.45	122.86	1125.43	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
25,296	30,856	0.82	13.43	62.21	565.91	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
12,216	3,088	3.96	6.49	120.09	430.24	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
10,131	12,392	0.82	5.38	22.56	230.28	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
6,125	3,175	1.93	3.25	81.35	342.61	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
6,124	3,172	1.93	3.25	78.61	339.38	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
6,019	3,080	1.95	3.20	109.31	289.87	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
5,074	1,824	2.78	2.69	12.21	106.67	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: 520,691
Captured SQL account for 97.6% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
31,394	31,394	1.00	0.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
31,390	31,391	1.00	0.00	0.01	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
31,388	31,388	1.00	0.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
31,367	31,366	1.00	0.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
31,340	31,341	1.00	0.00	0.06	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
31,271	31,271	1.00	0.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
30,929	0	0.00	0.00	0.10	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
30,881	30,881	1.00	0.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
30,856	30,854	1.00	0.00	0.02	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
30,834	30,830	1.00	0.00	0.07	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
30,834	30,834	1.00	0.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
30,831	30,833	1.00	0.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
18,961	137,156	7.23	0.01	0.06	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
15,815	15,815	1.00	0.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
15,811	15,812	1.00	0.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
15,512	15,512	1.00	0.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
13,746	13,746	1.00	0.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
12,392	12,393	1.00	0.00	0.02	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
5,317	4,239	0.80	0.00	0.00	96g93hntrzjtr		select /+ rule / bucket_cnt,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 112,139
Captured SQL account for 98.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
31,340	31,340	27.95	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
30,930	30,929	27.58	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
30,833	30,834	27.50	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
3,175	3,175	2.83	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
3,088	3,088	2.75	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
3,063	3,063	2.73	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
932	932	0.83	2ym6hhaq30r73		select type#, blocks, extents,...
913	914	0.81	grwydz59pu6mc		select text from view$ where r...
420	420	0.37	8swypbbr0m372		select order#, columns, types ...
420	420	0.37	cqgv56fmuj63x		select owner#, name, namespace...

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

0a59tkkpx31vx select output from table(dbms_workload_repository.awr_report_html(:1, :2, :3, :4))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

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

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

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;

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

cqgv56fmuj63x select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

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

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

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

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

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

grwydz59pu6mc select text from view$ where rowid=:1

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

SQL Id	SQL Text
0a59tkkpx31vx	select output from table(dbms_workload_repository.awr_report_html(:1, :2, :3, :4))
13dn4hkrzfpdy	SELECT COUNT(DISTINCT (S_I_ID)) FROM ORDER_LINE, STOCK WHERE OL_W_ID = :B2 AND OL_D_ID = :B4 AND (OL_O_ID < :B3 ) AND OL_O_ID >= (:B3 - 20) AND S_W_ID = :B2 AND S_I_ID = OL_I_ID AND S_QUANTITY < :B1
16dhat4ta7xs9	begin neword(:no_w_id, :no_max_w_id, :no_d_id, :no_c_id, :no_o_ol_cnt, :no_c_discount, :no_c_last, :no_c_credit, :no_d_tax, :no_w_tax, :no_d_next_o_id, TO_DATE(:timestamp, 'YYYYMMDDHH24MISS')); END;
1bn3cfn6n3xv5	SELECT C_DATA FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
2k7k32av19mqz	SELECT C_FIRST, C_MIDDLE, C_LAST, C_STREET_1, C_STREET_2, C_CITY, C_STATE, C_ZIP, C_PHONE, C_CREDIT, C_CREDIT_LIM, C_DISCOUNT, C_BALANCE, C_SINCE FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
4r83hzuhh3yuv	SELECT W_STREET_1, W_STREET_2, W_CITY, W_STATE, W_ZIP, W_NAME FROM WAREHOUSE WHERE W_ID = :B1
4wg725nwpxb1z	SELECT C_FIRST, C_MIDDLE, C_ID, C_STREET_1, C_STREET_2, C_CITY, C_STATE, C_ZIP, C_PHONE, C_CREDIT, C_CREDIT_LIM, C_DISCOUNT, C_BALANCE, C_SINCE FROM CUSTOMER WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_LAST = :B1 ORDER BY C_FIRST
5hyh0360hgx2u	BEGIN slev(:st_w_id, :st_d_id, :threshold); END;
5mz8u3b34u9gw	SELECT C_DISCOUNT, C_LAST, C_CREDIT, W_TAX FROM CUSTOMER, WAREHOUSE WHERE WAREHOUSE.W_ID = :B3 AND CUSTOMER.C_W_ID = :B3 AND CUSTOMER.C_D_ID = :B2 AND CUSTOMER.C_ID = :B1
5xm451a80drbc	INSERT INTO HISTORY (H_C_D_ID, H_C_W_ID, H_C_ID, H_D_ID, H_W_ID, H_DATE, H_AMOUNT, H_DATA) VALUES (:B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
69gxtaqr1vk8j	UPDATE DISTRICT SET D_YTD = D_YTD + :B3 WHERE D_W_ID = :B2 AND D_ID = :B1
7m5h0wf6stq0q	SELECT COUNT(C_ID) FROM CUSTOMER WHERE C_LAST = :B3 AND C_D_ID = :B2 AND C_W_ID = :B1
80ajya2tnyfg2	INSERT INTO NEW_ORDER (NO_O_ID, NO_D_ID, NO_W_ID) VALUES (:B3 , :B2 , :B1 )
88fgqncchy6wg	SELECT I_PRICE, I_NAME, I_DATA FROM ITEM WHERE I_ID = :B1
89k9fqaq5b5sy	SELECT C_BALANCE, C_FIRST, C_MIDDLE, C_ID FROM CUSTOMER WHERE C_LAST = :B3 AND C_D_ID = :B2 AND C_W_ID = :B1 ORDER BY C_FIRST
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
95yr4xtfr50hx	UPDATE CUSTOMER SET C_BALANCE = :B4 WHERE C_W_ID = :B3 AND C_D_ID = :B2 AND C_ID = :B1
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
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;
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
cqgv56fmuj63x	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
csv0xdm9c394t	SELECT O_ID, O_CARRIER_ID, O_ENTRY_D FROM (SELECT O_ID, O_CARRIER_ID, O_ENTRY_D FROM ORDERS WHERE O_D_ID = :B3 AND O_W_ID = :B2 AND O_C_ID=:B1 ORDER BY O_ID DESC) WHERE ROWNUM = 1
d4ujh5yqt1fph	BEGIN delivery(:d_w_id, :d_o_carrier_id, TO_DATE(:timestamp, 'YYYYMMDDHH24MISS')); END;
g1r3tpjj3b2gh	SELECT D_STREET_1, D_STREET_2, D_CITY, D_STATE, D_ZIP, D_NAME FROM DISTRICT WHERE D_W_ID = :B2 AND D_ID = :B1
g5u7xuchhfu62	UPDATE WAREHOUSE SET W_YTD = W_YTD + :B2 WHERE W_ID = :B1
gcvvtwcxafqp5	BEGIN ostat(:os_w_id, :os_d_id, :os_c_id, :byname, :os_c_last, :os_c_first, :os_c_middle, :os_c_balance, :os_o_id, :os_entdate, :os_o_carrier_id); END;
grwydz59pu6mc	select text from view$ where rowid=:1
gwcvcq87cn4sc	INSERT INTO ORDERS (O_ID, O_D_ID, O_W_ID, O_C_ID, O_ENTRY_D, O_OL_CNT, O_ALL_LOCAL) VALUES (:B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	55,632	92.55	1.77
CPU used when call started	55,486	92.31	1.77
CR blocks created	7,851	13.06	0.25
Cached Commit SCN referenced	2,848	4.74	0.09
Commit SCN cached	1	0.00	0.00
DB time	642,993	1,069.73	20.47
DBWR checkpoint buffers written	7,472	12.43	0.24
DBWR checkpoints	1	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	44	0.07	0.00
DBWR undo block writes	32,717	54.43	1.04
DFO trees parallelized	0	0.00	0.00
IMU CR rollbacks	15,111	25.14	0.48
IMU Flushes	44,253	73.62	1.41
IMU Redo allocation size	108,915,560	181,200.68	3,466.99
IMU commits	16,747	27.86	0.53
IMU contention	31,884	53.04	1.01
IMU pool not allocated	1,469	2.44	0.05
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	161,984,588	269,490.58	5,156.28
IMU- failed to get a private strand	1,469	2.44	0.05
OS Involuntary context switches	42,201	70.21	1.34
OS Page faults	54	0.09	0.00
OS Page reclaims	1,525,143	2,537.35	48.55
OS System time used	29,310	48.76	0.93
OS User time used	31,880	53.04	1.01
OS Voluntary context switches	514,532	856.02	16.38
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	73,577	122.41	2.34
active txn count during cleanout	19,234	32.00	0.61
application wait time	36,160	60.16	1.15
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	1	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	1,915	3.19	0.06
branch node splits	0	0.00	0.00
buffer is not pinned count	2,248,123	3,740.16	71.56
buffer is pinned count	12,639,355	21,027.85	402.34
bytes received via SQL*Net from client	82,642,810	137,491.22	2,630.68
bytes sent via SQL*Net to client	33,261,366	55,336.28	1,058.77
calls to get snapshot scn: kcmgss	477,524	794.45	15.20
calls to kcmgas	71,403	118.79	2.27
calls to kcmgcs	14,422	23.99	0.46
change write time	1,414	2.35	0.05
cleanout - number of ktugct calls	13,213	21.98	0.42
cleanouts and rollbacks - consistent read gets	6,564	10.92	0.21
cleanouts only - consistent read gets	17	0.03	0.00
cluster key scan block gets	5,106	8.49	0.16
cluster key scans	3,734	6.21	0.12
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	30,929	51.46	0.98
commit batch/immediate requested	30,929	51.46	0.98
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	380	0.63	0.01
commit cleanout failures: cannot pin	1,296	2.16	0.04
commit cleanouts	126,183	209.93	4.02
commit cleanouts successfully completed	124,507	207.14	3.96
commit immediate performed	30,929	51.46	0.98
commit immediate requested	30,929	51.46	0.98
commit txn count during cleanout	1,750	2.91	0.06
concurrency wait time	673	1.12	0.02
consistent changes	69,330	115.34	2.21
consistent gets	3,488,746	5,804.16	111.05
consistent gets - examination	2,803,078	4,663.43	89.23
consistent gets direct	0	0.00	0.00
consistent gets from cache	3,488,746	5,804.16	111.05
current blocks converted for CR	0	0.00	0.00
cursor authentications	401	0.67	0.01
data blocks consistent reads - undo records applied	15,574	25.91	0.50
db block changes	1,058,297	1,760.67	33.69
db block gets	1,207,380	2,008.69	38.43
db block gets direct	37	0.06	0.00
db block gets from cache	1,207,343	2,008.63	38.43
deferred (CURRENT) block cleanout applications	90,380	150.36	2.88
dirty buffers inspected	27,270	45.37	0.87
doubling up with imu segment	0	0.00	0.00
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	124	0.21	0.00
enqueue releases	294,086	489.27	9.36
enqueue requests	294,093	489.28	9.36
enqueue timeouts	0	0.00	0.00
enqueue waits	6,014	10.01	0.19
exchange deadlocks	0	0.00	0.00
execute count	520,691	866.26	16.57
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	7	0.01	0.00
free buffer inspected	228,121	379.52	7.26
free buffer requested	242,121	402.81	7.71
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,112	1.85	0.04
hot buffers moved to head of LRU	91,290	151.88	2.91
immediate (CR) block cleanout applications	6,581	10.95	0.21
immediate (CURRENT) block cleanout applications	139	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	938,459	1,561.30	29.87
index scans kdiixs1	94,737	157.61	3.02
leaf node 90-10 splits	59	0.10	0.00
leaf node splits	67	0.11	0.00
lob reads	8,109	13.49	0.26
lob writes	13,577	22.59	0.43
lob writes unaligned	13,577	22.59	0.43
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	68,746	114.37	2.19
messages sent	68,746	114.37	2.19
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	573,065	953.40	18.24
opened cursors cumulative	90,798	151.06	2.89
parse count (failures)	0	0.00	0.00
parse count (hard)	1,252	2.08	0.04
parse count (total)	112,139	186.56	3.57
parse time cpu	2,072	3.45	0.07
parse time elapsed	2,720	4.53	0.09
physical read IO requests	188,089	312.92	5.99
physical read bytes	771,383,296	1,283,335.24	24,554.62
physical read total IO requests	188,975	314.39	6.02
physical read total bytes	785,818,624	1,307,351.01	25,014.12
physical read total multi block requests	20	0.03	0.00
physical reads	188,326	313.31	5.99
physical reads cache	188,322	313.31	5.99
physical reads cache prefetch	237	0.39	0.01
physical reads direct	4	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	29,528	49.13	0.94
physical write bytes	268,099,584	446,032.01	8,534.13
physical write total IO requests	92,711	154.24	2.95
physical write total bytes	429,592,576	714,704.73	13,674.76
physical write total multi block requests	62,150	103.40	1.98
physical writes	65,454	108.89	2.08
physical writes direct	41	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	65,413	108.83	2.08
physical writes non checkpoint	61,716	102.68	1.96
pinned buffers inspected	1	0.00	0.00
prefetch clients - default	3	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	591	0.98	0.02
queries parallelized	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	1,053,628	1,752.90	33.54
recursive cpu usage	44,682	74.34	1.42
redo blocks read for recovery	0	0.00	0.00
redo blocks written	287,101	477.64	9.14
redo buffer allocation retries	7	0.01	0.00
redo entries	304,711	506.94	9.70
redo log space requests	8	0.01	0.00
redo log space wait time	32	0.05	0.00
redo ordering marks	1,059	1.76	0.03
redo size	129,077,712	214,744.05	4,108.79
redo synch time	4,417	7.35	0.14
redo synch writes	75,196	125.10	2.39
redo wastage	13,266,344	22,070.96	422.29
redo write time	5,578	9.28	0.18
redo writer latching time	7	0.01	0.00
redo writes	61,896	102.98	1.97
rollback changes - undo records applied	154,645	257.28	4.92
rollbacks only - consistent read gets	1,310	2.18	0.04
rows fetched via callback	794,651	1,322.05	25.30
session connect time	0	0.00	0.00
session cursor cache hits	85,947	142.99	2.74
session logical reads	4,696,116	7,812.84	149.49
session pga memory	0	0.00	0.00
session pga memory max	0	0.00	0.00
session uga memory	2,087,036	3,472.16	66.43
session uga memory max	38,876,940	64,678.80	1,237.53
shared hash latch upgrades - no wait	135,590	225.58	4.32
shared hash latch upgrades - wait	10	0.02	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	7,762	12.91	0.25
sorts (rows)	83,305	138.59	2.65
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	601	1.00	0.02
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	60,252	100.24	1.92
switch current to new buffer	28	0.05	0.00
table fetch by rowid	7,046,251	11,722.71	224.30
table fetch continued row	1,024	1.70	0.03
table scan blocks gotten	27,067	45.03	0.86
table scan rows gotten	774,796	1,289.01	24.66
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)	509	0.85	0.02
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	30,929	51.46	0.98
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	34,398,500	57,228.11	1,094.97
user I/O wait time	479,219	797.27	15.25
user calls	145,506	242.08	4.63
user commits	31,415	52.26	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	6,991	11.63	0.22
write clones created in background	0	0.00	0.00
write clones created in foreground	12	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	25,744	26,730
opened cursors current	431	437
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)	1	5.99

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,785	311	25.48	1.00	28,012	47	929	5.52
UNDOTBS1	1	0	410.00	1.00	1,203	2	25	1.20
SYSAUX	715	1	25.16	1.31	288	0	0	0.00
SYSTEM	607	1	26.26	1.02	14	0	0	0.00
TEMP	117	0	6.58	1.02	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	715	1	25.16	1.31	288	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	607	1	26.26	1.02	14	0	0	0.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	117	0	6.58	1.02	0	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	1	0	410.00	1.00	1,203	2	25	1.20
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	186,785	311	25.48	1.00	28,012	47	929	5.52

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,700,732	188,388	65,413	0	0	954

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	28	17539	153058	684707	2027520	684707
E	0	27	15461	146073	758756	2027520	758756

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.68	18,740,144
D	144	0.20	35,208	1.49	16,621,131
D	216	0.30	52,812	1.40	15,666,604
D	288	0.40	70,416	1.34	14,939,395
D	360	0.50	88,020	1.29	14,365,765
D	432	0.60	105,624	1.24	13,887,153
D	504	0.70	123,228	1.18	13,227,464
D	576	0.80	140,832	1.09	12,167,375
D	648	0.90	158,436	1.04	11,563,197
D	720	1.00	176,040	1.00	11,170,265
D	792	1.10	193,644	0.97	10,833,373
D	864	1.20	211,248	0.94	10,503,135
D	936	1.30	228,852	0.91	10,207,742
D	1,008	1.40	246,456	0.89	9,946,229
D	1,080	1.50	264,060	0.87	9,711,416
D	1,152	1.60	281,664	0.85	9,479,801
D	1,224	1.70	299,268	0.83	9,276,945
D	1,296	1.80	316,872	0.81	9,069,833
D	1,368	1.90	334,476	0.80	8,884,839
D	1,440	2.00	352,080	0.78	8,713,642

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	249	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	107.88	1.07	0.99	100.00	0.00	56,115
E	274	200	108.32	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	6,681	6,681
64K	128K	5	5
256K	512K	2	2
512K	1024K	305	305

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,357.08	1,622.46	73.00	117
69	0.25	4,357.08	508.70	90.00	0
137	0.50	4,357.08	134.64	97.00	0
206	0.75	4,357.08	55.43	99.00	0
274	1.00	4,357.08	0.00	100.00	0
329	1.20	4,357.08	0.00	100.00	0
384	1.40	4,357.08	0.00	100.00	0
438	1.60	4,357.08	0.00	100.00	0
493	1.80	4,357.08	0.00	100.00	0
548	2.00	4,357.08	0.00	100.00	0
822	3.00	4,357.08	0.00	100.00	0
1,096	4.00	4,357.08	0.00	100.00	0
1,644	6.00	4,357.08	0.00	100.00	0
2,192	8.00	4,357.08	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	14	1,374	373,275	0.82	84,004	73.95	6,223,595
76	0.86	25	2,101	423,531	0.93	33,748	29.71	6,256,967
88	1.00	36	2,881	456,143	1.00	1,136	1.00	6,275,907
100	1.14	47	3,432	482,371	1.06	1	0.00	6,283,635
112	1.27	58	3,944	486,655	1.07	1	0.00	6,286,820
124	1.41	70	4,712	486,866	1.07	1	0.00	6,288,502
136	1.55	81	5,313	486,937	1.07	1	0.00	6,289,638
148	1.68	92	5,907	486,960	1.07	1	0.00	6,290,387
160	1.82	103	6,635	486,968	1.07	1	0.00	6,290,633
172	1.95	114	7,336	486,992	1.07	1	0.00	6,290,883
184	2.09	125	7,776	486,999	1.07	1	0.00	6,291,044

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	429,283	18,736,187
412	0.50	321,813	14,936,681
618	0.75	273,428	13,225,675
824	1.00	215,241	11,168,447
1,030	1.25	188,042	10,205,727
1,236	1.50	167,466	9,478,661
1,442	1.75	150,657	8,883,383
1,648	2.00	145,817	8,712,506

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	915	5	6
2nd level bmb	5	0	14
undo header	25	0	1
1st level bmb	12	0	1

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)	5,999	6,000	6,000	339	56.54
HW-Segment High Water Mark	55	55	5	0	18.00
FB-Format Block	142	142	4	0	7.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	64.50	127,316	0	12	79.8/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
20-Apr 16:17	32,342	63,606	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,129	0.00		0
Consistent RBA	61,951	0.00	0.00	0
FOB s.o list latch	322	0.00		0
In memory undo latch	621,250	0.09	0.04	62,650	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	2	0.00		0
MQL Tracking Latch	0			12	0.00
Memory Management Latch	0			201	0.00
OS process	240	0.00		0
OS process allocation	361	0.00		0
OS process: request allocation	152	0.00		0
PL/SQL warning settings	71,905	0.07	0.00	0
SGA IO buffer pool latch	25	0.00		25	0.00
SQL memory manager latch	1	0.00		200	0.00
SQL memory manager workarea list latch	15,665	0.00		0
Shared B-Tree	22	0.00		0
active checkpoint queue latch	7,066	0.00		0
active service list	1,391	0.00		222	0.00
archive control	4	0.00		0
begin backup scn array	2	0.00		0
cache buffer handles	3,114	0.00		0
cache buffers chains	9,934,689	0.03	0.01	238,753	0.02
cache buffers lru chain	209,277	0.08	0.00	249,341	0.44
cache table scan latch	0			20	0.00
channel handle pool latch	154	0.00		0
channel operations parent latch	3,051	0.00		0
checkpoint queue latch	120,157	0.00	0.00	59,917	0.01
client/application info	382	0.00		0
compile environment latch	76,112	0.02	0.00	0
dml lock allocation	439,407	0.32	0.02	0
dummy allocation	152	0.00		0
enqueue hash chains	594,806	0.22	0.03	2,623	0.15
enqueues	100,165	0.04	0.08	0
event group latch	76	0.00		0
file cache latch	28	0.00		0
global KZLD latch for mem in SGA	74	0.00		0
hash table column usage latch	0			58,982	0.00
job_queue_processes parameter latch	10	0.00		0
kks stats	2,754	0.00		0
ksuosstats global area	42	0.00		0
ktm global data	2	0.00		0
kwqbsn:qsga	22	0.00		0
lgwr LWN SCN	61,944	0.00	0.00	0
library cache	642,621	0.12	0.02	5,995	0.05
library cache load lock	5,524	0.04	0.00	2	0.00
library cache lock	165,821	0.02	0.00	0
library cache lock allocation	1,743	0.00		0
library cache pin	298,653	0.13	0.01	0
library cache pin allocation	734	0.00		0
list of block allocation	181	0.00		0
loader state object freelist	14	0.00		0
message pool operations parent latch	2	0.00		0
messages	206,436	0.02	0.03	0
mostly latch-free SCN	62,002	0.02	0.00	0
multiblock read objects	42	0.00		0
ncodef allocation latch	10	0.00		0
object queue header heap	14,225	0.00		124	0.00
object queue header operation	677,250	0.02	0.02	0
object stats modification	1	0.00		0
parallel query alloc buffer	80	0.00		0
parameter list	284	0.00		0
parameter table allocation management	76	0.00		0
post/wait queue	49,624	0.01	0.00	31,890	0.08
process allocation	152	0.00		76	0.00
process group creation	152	0.00		0
qmn task queue latch	84	0.00		0
redo allocation	310,534	0.05	0.19	304,756	0.20
redo copy	0			305,019	0.18
redo writing	193,748	0.00	0.33	0
resmgr group change latch	76	0.00		0
resmgr:actses active list	149	0.00		0
resmgr:actses change group	74	0.00		0
resmgr:free threads list	148	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	691,761	0.08	0.01	4,779	0.13
sequence cache	575	0.00		0
session allocation	641,316	0.26	0.01	0
session idle bit	367,186	0.01	0.03	0
session state list latch	152	0.00		0
session switching	10	0.00		0
session timer	222	0.00		0
shared pool	117,061	0.21	0.02	0
shared pool sim alloc	2	0.00		0
shared pool simulator	127,617	0.00		0
simulator hash latch	443,264	0.00		0
simulator lru latch	411,754	0.13	0.03	14,839	0.00
slave class	2	0.00		0
slave class create	8	12.50	1.00	0
sort extent pool	21	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	35	0.00		0
transaction allocation	153	0.00		0
transaction branch allocation	10	0.00		0
undo global data	423,404	0.05	0.02	0
user lock	296	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,934,689	2,634	23	2,611
session allocation	641,316	1,649	9	1,640
dml lock allocation	439,407	1,424	26	1,398
enqueue hash chains	594,806	1,309	36	1,273
library cache	642,621	790	15	775
In memory undo latch	621,250	588	24	564
simulator lru latch	411,754	543	19	524
row cache objects	691,761	523	4	519
library cache pin	298,653	401	6	395
shared pool	117,061	243	4	240
undo global data	423,404	204	4	200
redo allocation	310,534	156	29	127
object queue header operation	677,250	135	3	132
enqueues	100,165	40	3	37
messages	206,436	35	1	34
session idle bit	367,186	32	1	31
redo writing	193,748	3	1	2
slave class create	8	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	13	22
In memory undo latch	kticmt: child	6	0
In memory undo latch	ktiTxnPoolFree	2	0
In memory undo latch	ktichg: child	2	0
In memory undo latch	kturbk	1	2
cache buffers chains	kcbgtcr: fast path	17	19
cache buffers chains	kcbgcur: kslbegin	11	16
cache buffers chains	kcbgtcr: kslbegin excl	9	1
cache buffers chains	kcbgtcr: kslbegin shared	6	2
cache buffers chains	kcbchg: kslbegin: bufs not pinned	3	5
cache buffers chains	kcbnew: new latch again	2	1
cache buffers chains	kcbzib: finish free bufs	2	0
cache buffers chains	kcbgtcr	1	0
cache buffers chains	kcbnlc	1	1
cache buffers chains	kcbrls: kslbegin	1	1
cache buffers chains	kcbzgb: scan from tail. nowait	1	0
dml lock allocation	ktaiam	13	24
dml lock allocation	ktaidm	13	2
enqueue hash chains	ksqrcl	23	7
enqueue hash chains	ksqgtl3	13	28
enqueues	ksqdel	1	1
enqueues	ksqgel: create enqueue	1	0
enqueues	ksqies	1	2
library cache	kglpnp: child	5	13
library cache	kglpndl: child: after processing	3	0
library cache	kglrtl	2	0
library cache	kgldte: child 0	1	1
library cache	kglpin	1	0
library cache lock	kgllkdl: child: no lock handle	1	0
library cache pin	kglpnp: child	4	4
library cache pin	kglpndl	2	2
messages	ksarcv: after wait	1	0
object queue header operation	kcbo_switch_cq	1	2
object queue header operation	kcbw_link_q	1	0
object queue header operation	kcbw_unlink_q	1	1
redo allocation	kcrfw_redo_gen: redo allocation 1	30	0
redo writing	kcrfwcr	1	0
row cache objects	kqreqd: reget	2	0
row cache objects	kqrpre: find obj	2	2
session allocation	ksuprc	5	1
session allocation	ksucri	2	7
session allocation	ksudlc	1	1
session allocation	ksuxds: not user session	1	0
session idle bit	ksupuc: clear busy	1	0
shared pool	kghalo	3	0
shared pool	kghfrunp: clatch: nowait	2	0
shared pool	kghupr1	1	3
simulator lru latch	kcbs_simulate: simulate set	18	19
simulator lru latch	kcbs_simbufseq	1	0
slave class create	ksvcreate	1	0
undo global data	ktudba: KSLBEGIN	2	2
undo global data	ktudnx:child	2	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	438,974	1,423	26	1397/0/0/0
enqueues	100,101	40	3	37/0/0/0
messages	206,166	35	1	34/0/0/0
redo writing	193,536	3	1	2/0/0/0
session allocation	641,226	1,652	9	1643/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	8	63,668	62	1	61/0/0/0
In memory undo latch	6	62,922	65	5	60/0/0/0
In memory undo latch	2	62,466	66	2	64/0/0/0
In memory undo latch	3	62,456	50	2	48/0/0/0
In memory undo latch	4	62,332	50	5	45/0/0/0
In memory undo latch	7	62,177	56	1	55/0/0/0
In memory undo latch	9	61,886	64	3	61/0/0/0
In memory undo latch	10	59,675	64	2	62/0/0/0
In memory undo latch	1	56,752	48	3	45/0/0/0
cache buffers chains	1237	401,953	1,110	6	1104/0/0/0
cache buffers chains	1421	96,230	142	1	141/0/0/0
cache buffers chains	128	63,905	13	1	12/0/0/0
cache buffers chains	72	41,583	4	1	3/0/0/0
cache buffers chains	585	31,587	1	1	0/0/0/0
cache buffers chains	709	25,664	4	1	3/0/0/0
cache buffers chains	260	25,558	5	1	4/0/0/0
cache buffers chains	1991	19,070	5	1	4/0/0/0
cache buffers chains	1962	8,211	2	1	1/0/0/0
cache buffers chains	1654	5,593	1	1	0/0/0/0
cache buffers chains	1540	4,616	1	1	0/0/0/0
cache buffers chains	811	4,402	1	1	0/0/0/0
cache buffers chains	713	3,299	2	1	1/0/0/0
cache buffers chains	1512	2,962	1	1	0/0/0/0
cache buffers chains	1046	2,683	1	1	0/0/0/0
cache buffers chains	574	2,644	1	1	0/0/0/0
cache buffers chains	665	1,940	1	1	0/0/0/0
enqueue hash chains	1	165,809	467	16	451/0/0/0
enqueue hash chains	2	165,209	366	13	353/0/0/0
enqueue hash chains	3	164,583	263	5	258/0/0/0
enqueue hash chains	4	99,158	214	2	212/0/0/0
library cache	2	119,629	108	4	104/0/0/0
library cache	3	113,594	176	6	170/0/0/0
library cache	5	101,302	83	2	81/0/0/0
library cache	1	33,601	14	1	13/0/0/0
library cache pin	4	135,101	222	4	218/0/0/0
library cache pin	2	71,995	97	2	95/0/0/0
redo allocation	1	123,782	158	30	128/0/0/0
row cache objects	16	94,193	93	1	92/0/0/0
row cache objects	12	38,312	12	1	11/0/0/0
shared pool	1	117,086	243	4	240/0/0/0
simulator lru latch	6	231,482	406	15	391/0/0/0
simulator lru latch	5	180,094	137	4	133/0/0/0
undo global data	4	84,774	25	4	21/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,696,116
Captured Segments account for 83.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	1,264,320	26.92
TPCC	USERS	STOCK	TABLE	626,304	13.34
TPCC	USERS	CUSTOMER_I1	INDEX	275,424	5.86
TPCC	USERS	CUSTOMER_I2	INDEX	257,664	5.49
TPCC	USERS	CUSTOMER	TABLE	243,696	5.19

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 188,326
Captured Segments account for 99.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	CUSTOMER		TABLE	95,351	50.63
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	55,701	29.58
TPCC	USERS	ITEM		TABLE	22,481	11.94
TPCC	USERS	STOCK		TABLE	5,395	2.86
TPCC	USERS	ORDERS		TABLE	3,825	2.03

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	8,434	70.64
TPCC	USERS	DISTRICT	TABLE	3,504	29.35
SYS	SYSTEM	SMON_SCN_TIME	TABLE	2	0.02

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	664	80.48
TPCC	USERS	HISTORY	TABLE	74	8.97
TPCC	USERS	ORDERS	TABLE	57	6.91
TPCC	USERS	WAREHOUSE	TABLE	19	2.30
TPCC	USERS	DISTRICT	TABLE	11	1.33

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	23.08	2	1
dc_global_oids	136	19.85	0	0
dc_histogram_data	2,086	32.02	0	94
dc_histogram_defs	28,788	18.47	0	596
dc_object_grants	127	32.28	0	11
dc_object_ids	12,515	6.80	0	165
dc_objects	6,706	16.16	0	167
dc_profiles	75	4.00	0	1
dc_rollback_segments	114	0.00	0	24
dc_segments	5,616	16.61	3	77
dc_sequences	19	36.84	19	0
dc_tablespaces	165,901	0.00	0	5
dc_usernames	452	4.20	0	3
dc_users	8,281	0.48	0	15
outstanding_alerts	12	83.33	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	8	25.00	34,565	0.06	18	0
CLUSTER	35	5.71	189	2.12	2	0
INDEX	107	72.90	307	28.99	11	0
SQL AREA	1,128	62.50	601,131	0.53	365	2
TABLE/PROCEDURE	2,311	16.83	115,963	2.30	971	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.63		3.02	7.75	32	33	30	30
	Freeable	13.56	0.00	1.13	0.64	3		12	12
	SQL	2.19	1.14	0.09	0.04	0	8	24	23
	PL/SQL	1.58	0.83	0.05	0.06	0	0	30	30
E	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

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	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.59	22.69	0.44
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	library cache	3.16	3.17	0.37
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.50	2.29	-8.26
	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.54	Recursive Call %:	87.87
Rollback per transaction %:	0.00	Rows per Sort:	10.73

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	95.99	In-memory Sort %:	100.00
Library Hit %:	99.21	Soft Parse %:	98.88
Execute to Parse %:	78.46	Latch Hit %:	99.94
Parse CPU to Parse Elapsd %:	76.18	% Non-Parse CPU:	96.17