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: 57 20-Apr-06 16:30:46 30 13.9

End Snap: 58 20-Apr-06 16:40:47 30 14.5

Elapsed: 10.02 (mins)

DB Time: 94.37 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	57	20-Apr-06 16:30:46	30	13.9
End Snap:	58	20-Apr-06 16:40:47	30	14.5
Elapsed:		10.02 (mins)
DB Time:		94.37 (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: 215,122.33 4,132.68

Logical reads: 7,901.92 151.80

Block changes: 1,766.31 33.93

Physical reads: 313.96 6.03

Physical writes: 106.04 2.04

User calls: 242.55 4.66

Parses: 187.78 3.61

Hard parses: 2.38 0.05

Sorts: 14.57 0.28

Logons: 0.13 0.00

Executes: 869.03 16.69

Transactions: 52.05

	Per Second	Per Transaction
Redo size:	215,122.33	4,132.68
Logical reads:	7,901.92	151.80
Block changes:	1,766.31	33.93
Physical reads:	313.96	6.03
Physical writes:	106.04	2.04
User calls:	242.55	4.66
Parses:	187.78	3.61
Hard parses:	2.38	0.05
Sorts:	14.57	0.28
Logons:	0.13	0.00
Executes:	869.03	16.69
Transactions:	52.05

% Blocks changed per Read: 22.35 Recursive Call %: 88.13

Rollback per transaction %: 0.00 Rows per Sort: 10.02

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 100.00

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

Library Hit %: 99.14 Soft Parse %: 98.73

Execute to Parse %: 78.39 Latch Hit %: 99.94

Parse CPU to Parse Elapsd %: 73.77 % Non-Parse CPU: 95.92

Shared Pool Statistics

Begin End

Memory Usage %: 74.25 74.48

% SQL with executions>1: 87.63 86.94

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

	Begin	End
Memory Usage %:	74.25	74.48
% SQL with executions>1:	87.63	86.94
% Memory for SQL w/exec>1:	79.85	80.19

Top 5 Timed Events

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

db file sequential read 186,281 4,665 25 82.4 User I/O

CPU time 612 10.8

enq: TX - row lock contention 6,605 359 54 6.3 Application

log file sync 31,747 46 1 .8 Commit

SQL*Net break/reset to client 62,438 33 1 .6 Application

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	186,281	4,665	25	82.4	User I/O
CPU time		612		10.8
enq: TX - row lock contention	6,605	359	54	6.3	Application
log file sync	31,747	46	1	.8	Commit
SQL*Net break/reset to client	62,438	33	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): 5662.3s
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,569.58	98.36
DB CPU	612.12	10.81
PL/SQL execution elapsed time	41.67	0.74
parse time elapsed	37.05	0.65
hard parse elapsed time	25.54	0.45
PL/SQL compilation elapsed time	2.82	0.05
connection management call elapsed time	1.66	0.03
hard parse (sharing criteria) elapsed time	0.96	0.02
repeated bind elapsed time	0.54	0.01
sequence load elapsed time	0.34	0.01
hard parse (bind mismatch) elapsed time	0.14	0.00
DB time	5,662.32
background elapsed time	150.50
background cpu time	53.67

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	186,619	0.00	4,676	25	5.96
Application	69,043	0.00	392	6	2.21
Commit	31,747	0.00	46	1	1.01
Concurrency	1,346	28.53	9	7	0.04
System I/O	69,843	0.00	4	0	2.23
Network	74,867	0.00	1	0	2.39
Configuration	22	0.00	1	24	0.00
Other	634	0.32	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	186,281	0.00	4,665	25	5.95
enq: TX - row lock contention	6,605	0.00	359	54	0.21
log file sync	31,747	0.00	46	1	1.01
SQL*Net break/reset to client	62,438	0.00	33	1	2.00
db file scattered read	248	0.00	10	39	0.01
cursor: pin S wait on X	384	100.00	5	12	0.01
buffer busy waits	833	0.00	3	4	0.03
log file parallel write	62,202	0.00	2	0	1.99
read by other session	48	0.00	2	34	0.00
control file parallel write	294	0.00	1	3	0.01
library cache load lock	14	0.00	1	63	0.00
control file sequential read	897	0.00	1	1	0.03
SQL*Net message to client	74,324	0.00	1	0	2.38
log file switch completion	9	0.00	0	43	0.00
db file parallel write	6,446	0.00	0	0	0.21
enq: HW - contention	12	0.00	0	12	0.00
os thread startup	2	0.00	0	62	0.00
kksfbc child completion	2	100.00	0	50	0.00
latch free	45	0.00	0	2	0.00
latch: library cache	23	0.00	0	3	0.00
LGWR wait for redo copy	319	0.00	0	0	0.01
latch: cache buffers chains	29	0.00	0	2	0.00
latch: library cache lock	10	0.00	0	4	0.00
latch: row cache objects	2	0.00	0	19	0.00
latch: In memory undo latch	34	0.00	0	1	0.00
log file single write	2	0.00	0	15	0.00
latch: enqueue hash chains	37	0.00	0	1	0.00
SQL*Net more data to client	525	0.00	0	0	0.02
latch: redo allocation	25	0.00	0	1	0.00
cursor: pin S	189	0.00	0	0	0.01
latch: shared pool	13	0.00	0	1	0.00
log file sequential read	2	0.00	0	4	0.00
latch: session allocation	7	0.00	0	1	0.00
SQL*Net more data from client	18	0.00	0	0	0.00
latch: object queue header operation	5	0.00	0	0	0.00
direct path write	8	0.00	0	0	0.00
latch: cache buffers lru chain	2	0.00	0	1	0.00
direct path read	34	0.00	0	0	0.00
enq: FB - contention	1	0.00	0	1	0.00
latch: library cache pin	2	0.00	0	0	0.00
latch: messages	2	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
SQL*Net message from client	74,323	0.00	2,776	37	2.38
Streams AQ: waiting for time management or cleanup tasks	30	100.00	1,363	45434	0.00
Streams AQ: waiting for messages in the queue	119	100.00	581	4883	0.00
Streams AQ: qmn slave idle wait	21	0.00	574	27346	0.00
Streams AQ: qmn coordinator idle wait	42	50.00	574	13673	0.00

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	62,198	0.00	2	0	1.99
control file parallel write	294	0.00	1	3	0.01
control file sequential read	141	0.00	1	5	0.00
db file scattered read	12	0.00	1	54	0.00
db file parallel write	6,446	0.00	0	0	0.21
os thread startup	2	0.00	0	62	0.00
events in waitclass Other	345	0.00	0	0	0.01
db file sequential read	30	0.00	0	2	0.00
log file single write	2	0.00	0	15	0.00
log file sequential read	2	0.00	0	4	0.00
direct path write	6	0.00	0	0	0.00
latch: redo writing	1	0.00	0	0	0.00
direct path read	4	0.00	0	0	0.00
rdbms ipc message	63,632	2.80	4,579	72	2.03
Streams AQ: waiting for time management or cleanup tasks	30	100.00	1,363	45434	0.00
smon timer	3	66.67	590	196616	0.00
pmon timer	231	100.00	586	2537	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

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	72,240
IDLE_TIME	166,575
IOWAIT_TIME	108,347
NICE_TIME	0
SYS_TIME	34,818
USER_TIME	35,462
LOAD	9
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,800
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,614.40	571.40	184,601	4,473,036
SYS$USERS	66.90	43.20	3,708	250,893
SYS$BACKGROUND	0.00	0.00	1,183	40,676

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	184625	463245	1329	866	72676	71
SYS$USERS	999	1933	14	12	1980	3
SYS$BACKGROUND	1044	2547	2	12	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,983	111	30,858	0.10	52.68	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
2,285	34	30,830	0.07	40.35	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
1,804	157	31,097	0.06	31.87	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
1,119	130	18,538	0.06	19.75	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
566	63	30,831	0.02	9.99	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
375	80	3,076	0.12	6.62	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
372	77	3,075	0.12	6.57	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
315	177	3,138	0.10	5.56	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
259	17	31,125	0.01	4.57	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
233	24	12,569	0.02	4.12	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
171	166	3,138	0.05	3.03	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
110	13	1,876	0.06	1.95	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...
76	13	30,822	0.00	1.34	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
177	315	3,138	0.06	5.56	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
166	171	3,138	0.05	3.03	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
157	1,804	31,097	0.01	31.87	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
130	1,119	18,538	0.01	19.75	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
111	2,983	30,858	0.00	52.68	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
80	375	3,076	0.03	6.62	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
77	372	3,075	0.03	6.57	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
63	566	30,831	0.00	9.99	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
34	2,285	30,830	0.00	40.35	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
24	233	12,569	0.00	4.12	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
17	259	31,125	0.00	4.57	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
13	110	1,876	0.01	1.95	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...
13	76	30,822	0.00	1.34	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...

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,750,197
Captured SQL account for 88.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,875,919	3,076	609.86	39.49	80.13	375.08	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
1,868,920	3,075	607.78	39.34	77.41	372.08	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
1,031,578	31,097	33.17	21.72	157.38	1804.46	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
869,532	30,858	28.18	18.31	110.93	2982.82	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
311,592	18,538	16.81	6.56	129.83	1118.57	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
277,497	30,830	9.00	5.84	33.84	2284.56	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
225,043	3,138	71.72	4.74	176.62	314.73	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
216,027	30,820	7.01	4.55	7.54	8.03	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
188,046	30,831	6.10	3.96	63.30	565.89	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
183,044	3,138	58.33	3.85	165.59	171.30	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
133,268	31,125	4.28	2.81	17.05	258.89	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
125,235	30,822	4.06	2.64	12.84	75.94	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
112,403	1	112,403.00	2.37	12.24	26.32	0a59tkkpx31vx	Admin Connection	select output from table(dbms_...
71,326	31,120	2.29	1.50	6.18	9.85	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
64,668	20,421	3.17	1.36	10.09	42.57	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
63,680	31,111	2.05	1.34	7.44	47.32	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
63,032	15,682	4.02	1.33	4.28	4.44	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
62,773	15,683	4.00	1.32	3.68	4.55	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
62,276	31,129	2.00	1.31	7.04	7.09	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
62,168	31,075	2.00	1.31	6.17	6.23	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
61,755	30,839	2.00	1.30	5.63	7.37	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
61,721	15,417	4.00	1.30	4.55	5.58	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
50,353	12,569	4.01	1.06	23.95	233.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,738
Captured SQL account for 98.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
103,493	30,858	3.35	54.83	110.93	2982.82	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
78,000	30,830	2.53	41.33	33.84	2284.56	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
66,306	31,097	2.13	35.13	157.38	1804.46	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
54,658	18,538	2.95	28.96	129.83	1118.57	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
25,394	30,831	0.82	13.45	63.30	565.89	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
10,466	12,569	0.83	5.55	23.95	233.28	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
6,632	3,076	2.16	3.51	80.13	375.08	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
6,630	3,075	2.16	3.51	77.41	372.08	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
6,557	3,138	2.09	3.47	176.62	314.73	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
5,369	1,876	2.86	2.84	12.97	110.42	89k9fqaq5b5sy	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_BALANCE, C_FIRST, C...
3,301	1	3,301.00	1.75	12.24	26.32	0a59tkkpx31vx	Admin Connection	select output from table(dbms_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 522,414
Captured SQL account for 98.8% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
31,129	31,129	1.00	0.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
31,125	31,125	1.00	0.00	0.01	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
31,120	31,120	1.00	0.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
31,111	31,111	1.00	0.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
31,097	31,098	1.00	0.01	0.06	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
31,075	31,075	1.00	0.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
30,858	0	0.00	0.00	0.10	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
30,839	30,839	1.00	0.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
30,831	30,831	1.00	0.00	0.02	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
30,830	30,832	1.00	0.00	0.07	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
30,822	30,822	1.00	0.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
30,820	30,821	1.00	0.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
20,421	20,421	1.00	0.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
18,538	136,289	7.35	0.01	0.06	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
15,683	15,683	1.00	0.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
15,682	15,683	1.00	0.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
15,417	15,417	1.00	0.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
12,569	12,568	1.00	0.00	0.02	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
5,869	4,692	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,881
Captured SQL account for 97.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
31,101	31,097	27.55	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
30,856	30,858	27.33	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
30,828	30,830	27.31	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
3,138	3,138	2.78	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
3,076	3,076	2.72	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
3,023	3,023	2.68	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
976	979	0.86	grwydz59pu6mc		select text from view$ where r...
732	732	0.65	2ym6hhaq30r73		select type#, blocks, extents,...
438	438	0.39	8swypbbr0m372		select order#, columns, types ...
438	438	0.39	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	63,111	104.98	2.02
CPU used when call started	62,997	104.80	2.01
CR blocks created	7,916	13.17	0.25
Cached Commit SCN referenced	3,293	5.48	0.11
Commit SCN cached	1	0.00	0.00
DB time	640,017	1,064.66	20.45
DBWR checkpoint buffers written	7,374	12.27	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	39	0.06	0.00
DBWR undo block writes	31,921	53.10	1.02
DFO trees parallelized	0	0.00	0.00
IMU CR rollbacks	15,078	25.08	0.48
IMU Flushes	44,705	74.37	1.43
IMU Redo allocation size	109,848,984	182,732.92	3,510.45
IMU commits	16,378	27.24	0.52
IMU contention	32,232	53.62	1.03
IMU pool not allocated	1,457	2.42	0.05
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	161,769,132	269,101.68	5,169.66
IMU- failed to get a private strand	1,457	2.42	0.05
OS Involuntary context switches	48,188	80.16	1.54
OS Page faults	50	0.08	0.00
OS Page reclaims	1,549,104	2,576.92	49.50
OS System time used	34,631	57.61	1.11
OS User time used	34,183	56.86	1.09
OS Voluntary context switches	512,943	853.28	16.39
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,797	122.76	2.36
active txn count during cleanout	19,633	32.66	0.63
application wait time	38,716	64.40	1.24
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,900	3.16	0.06
branch node splits	1	0.00	0.00
buffer is not pinned count	2,281,468	3,795.20	72.91
buffer is pinned count	19,572,099	32,558.03	625.47
bytes received via SQL*Net from client	82,621,515	137,440.24	2,640.34
bytes sent via SQL*Net to client	33,324,836	55,435.60	1,064.96
calls to get snapshot scn: kcmgss	478,790	796.46	15.30
calls to kcmgas	71,549	119.02	2.29
calls to kcmgcs	14,661	24.39	0.47
change write time	1,376	2.29	0.04
cleanout - number of ktugct calls	13,592	22.61	0.43
cleanouts and rollbacks - consistent read gets	6,646	11.06	0.21
cleanouts only - consistent read gets	13	0.02	0.00
cluster key scan block gets	6,030	10.03	0.19
cluster key scans	4,300	7.15	0.14
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	31,131	51.79	0.99
commit batch/immediate requested	31,131	51.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	368	0.61	0.01
commit cleanout failures: cannot pin	1,223	2.03	0.04
commit cleanouts	125,731	209.15	4.02
commit cleanouts successfully completed	124,140	206.51	3.97
commit immediate performed	31,131	51.79	0.99
commit immediate requested	31,131	51.79	0.99
commit txn count during cleanout	1,663	2.77	0.05
concurrency wait time	890	1.48	0.03
consistent changes	68,781	114.42	2.20
consistent gets	3,538,887	5,886.91	113.09
consistent gets - examination	2,783,405	4,630.17	88.95
consistent gets direct	30	0.05	0.00
consistent gets from cache	3,538,857	5,886.86	113.09
current blocks converted for CR	0	0.00	0.00
cursor authentications	531	0.88	0.02
data blocks consistent reads - undo records applied	15,574	25.91	0.50
db block changes	1,061,806	1,766.31	33.93
db block gets	1,211,302	2,014.99	38.71
db block gets direct	36	0.06	0.00
db block gets from cache	1,211,266	2,014.93	38.71
deferred (CURRENT) block cleanout applications	90,285	150.19	2.89
dirty buffers inspected	26,719	44.45	0.85
doubling up with imu segment	0	0.00	0.00
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	123	0.20	0.00
enqueue releases	294,933	490.62	9.43
enqueue requests	294,926	490.61	9.42
enqueue timeouts	0	0.00	0.00
enqueue waits	6,497	10.81	0.21
exchange deadlocks	0	0.00	0.00
execute count	522,414	869.03	16.69
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	228,553	380.20	7.30
free buffer requested	242,665	403.67	7.75
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,125	1.87	0.04
hot buffers moved to head of LRU	89,727	149.26	2.87
immediate (CR) block cleanout applications	6,659	11.08	0.21
immediate (CURRENT) block cleanout applications	133	0.22	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	931,940	1,550.27	29.78
index scans kdiixs1	95,892	159.52	3.06
leaf node 90-10 splits	55	0.09	0.00
leaf node splits	63	0.10	0.00
lob reads	8,331	13.86	0.27
lob writes	13,500	22.46	0.43
lob writes unaligned	13,500	22.46	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	79	0.13	0.00
messages received	68,410	113.80	2.19
messages sent	68,410	113.80	2.19
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	641,661	1,067.40	20.51
opened cursors cumulative	92,785	154.35	2.97
parse count (failures)	0	0.00	0.00
parse count (hard)	1,429	2.38	0.05
parse count (total)	112,881	187.78	3.61
parse time cpu	2,498	4.16	0.08
parse time elapsed	3,386	5.63	0.11
physical read IO requests	185,878	309.21	5.94
physical read bytes	773,070,848	1,285,997.30	24,705.06
physical read total IO requests	186,781	310.71	5.97
physical read total bytes	787,784,704	1,310,473.69	25,175.27
physical read total multi block requests	248	0.41	0.01
physical reads	188,738	313.96	6.03
physical reads cache	188,704	313.91	6.03
physical reads cache prefetch	2,860	4.76	0.09
physical reads direct	34	0.06	0.00
physical reads direct (lob)	30	0.05	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,776	47.87	0.92
physical write bytes	261,099,520	434,337.01	8,343.97
physical write total IO requests	91,953	152.96	2.94
physical write total bytes	422,728,192	703,205.04	13,509.15
physical write total multi block requests	62,262	103.57	1.99
physical writes	63,745	106.04	2.04
physical writes direct	40	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,705	105.97	2.04
physical writes non checkpoint	60,173	100.10	1.92
pinned buffers inspected	2	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	600	1.00	0.02
queries parallelized	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	1,082,259	1,800.33	34.59
recursive cpu usage	51,869	86.28	1.66
redo blocks read for recovery	0	0.00	0.00
redo blocks written	287,457	478.18	9.19
redo buffer allocation retries	8	0.01	0.00
redo entries	306,911	510.54	9.81
redo log space requests	9	0.01	0.00
redo log space wait time	43	0.07	0.00
redo ordering marks	1,061	1.76	0.03
redo size	129,319,712	215,122.33	4,132.68
redo synch time	4,826	8.03	0.15
redo synch writes	75,197	125.09	2.40
redo wastage	13,202,136	21,961.65	421.90
redo write time	5,606	9.33	0.18
redo writer latching time	8	0.01	0.00
redo writes	61,955	103.06	1.98
rollback changes - undo records applied	155,655	258.93	4.97
rollbacks only - consistent read gets	1,289	2.14	0.04
rows fetched via callback	787,192	1,309.49	25.16
session connect time	0	0.00	0.00
session cursor cache hits	87,564	145.66	2.80
session logical reads	4,750,197	7,901.92	151.80
session pga memory max	524,288	872.15	16.75
session uga memory	2,006,916	3,338.49	64.14
session uga memory max	38,847,704	64,622.85	1,241.46
shared hash latch upgrades - no wait	137,448	228.64	4.39
shared hash latch upgrades - wait	5	0.01	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	8,761	14.57	0.28
sorts (rows)	87,776	146.01	2.81
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	698	1.16	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	52,428	87.21	1.68
switch current to new buffer	29	0.05	0.00
table fetch by rowid	10,532,372	17,520.52	336.58
table fetch continued row	1,012	1.68	0.03
table scan blocks gotten	28,794	47.90	0.92
table scan rows gotten	814,608	1,355.09	26.03
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)	524	0.87	0.02
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	31,131	51.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	34,424,420	57,264.75	1,100.10
user I/O wait time	465,296	774.02	14.87
user calls	145,809	242.55	4.66
user commits	31,292	52.05	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	7,358	12.24	0.24
write clones created in background	0	0.00	0.00
write clones created in foreground	10	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	27,654	28,648
opened cursors current	417	434
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	184,553	307	25.09	1.00	27,436	46	847	5.58
SYSAUX	1,146	2	26.28	3.42	309	1	0	0.00
UNDOTBS1	1	0	70.00	1.00	1,181	2	30	0.33
SYSTEM	812	1	18.55	1.11	15	0	0	0.00
TEMP	121	0	7.11	1.02	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	1,146	2	26.28	3.42	309	1	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	812	1	18.55	1.11	15	0	0	0.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	121	0	7.11	1.02	1	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	1	0	70.00	1.00	1,181	2	30	0.33
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	184,553	307	25.09	1.00	27,436	46	847	5.58

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,758,362	189,011	63,978	0	0	873

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	16765	151147	870713	2027520	870713
E	0	28	16608	150830	870983	2027520	870983

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,549,403
D	144	0.20	35,208	1.50	17,290,122
D	216	0.30	52,812	1.41	16,278,604
D	288	0.40	70,416	1.34	15,509,936
D	360	0.50	88,020	1.29	14,897,006
D	432	0.60	105,624	1.25	14,382,730
D	504	0.70	123,228	1.19	13,687,936
D	576	0.80	140,832	1.09	12,596,400
D	648	0.90	158,436	1.04	11,963,451
D	720	1.00	176,040	1.00	11,547,137
D	792	1.10	193,644	0.97	11,187,609
D	864	1.20	211,248	0.94	10,837,805
D	936	1.30	228,852	0.91	10,526,966
D	1,008	1.40	246,456	0.89	10,251,132
D	1,080	1.50	264,060	0.87	10,000,497
D	1,152	1.60	281,664	0.84	9,754,568
D	1,224	1.70	299,268	0.83	9,540,132
D	1,296	1.80	316,872	0.81	9,322,942
D	1,368	1.90	334,476	0.79	9,128,211
D	1,440	2.00	352,080	0.77	8,947,613

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	252	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.82	0.00	0.00	0.00	0.00	56,115
E	274	200	107.95	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	7,048	7,048
64K	128K	3	3
256K	512K	2	2
512K	1024K	311	311

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,768.41	1,657.23	74.00	128
69	0.25	4,768.41	508.70	90.00	0
137	0.50	4,768.41	134.64	97.00	0
206	0.75	4,768.41	55.43	99.00	0
274	1.00	4,768.41	0.00	100.00	0
329	1.20	4,768.41	0.00	100.00	0
384	1.40	4,768.41	0.00	100.00	0
438	1.60	4,768.41	0.00	100.00	0
493	1.80	4,768.41	0.00	100.00	0
548	2.00	4,768.41	0.00	100.00	0
822	3.00	4,768.41	0.00	100.00	0
1,096	4.00	4,768.41	0.00	100.00	0
1,644	6.00	4,768.41	0.00	100.00	0
2,192	8.00	4,768.41	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	13	1,367	423,453	0.83	85,459	71.94	6,697,231
76	0.86	24	2,032	473,733	0.93	35,179	29.61	6,732,048
88	1.00	35	2,825	507,724	1.00	1,188	1.00	6,752,229
100	1.14	46	3,467	534,374	1.05	1	0.00	6,760,499
112	1.27	57	3,926	538,661	1.06	1	0.00	6,763,825
124	1.41	69	4,653	538,873	1.06	1	0.00	6,765,585
136	1.55	81	5,249	538,946	1.06	1	0.00	6,766,814
148	1.68	93	5,957	538,969	1.06	1	0.00	6,767,570
160	1.82	105	6,572	538,978	1.06	1	0.00	6,767,823
172	1.95	117	7,318	539,002	1.06	1	0.00	6,768,075
184	2.09	129	7,803	539,009	1.06	1	0.00	6,768,256

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	451,374	19,545,082
412	0.50	337,902	15,506,527
618	0.75	286,741	13,685,829
824	1.00	226,578	11,545,326
1,030	1.25	197,946	10,525,874
1,236	1.50	176,241	9,753,491
1,442	1.75	158,660	9,126,580
1,648	2.00	153,586	8,946,473

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	823	4	5
2nd level bmb	12	0	34
undo header	27	0	0
1st level bmb	15	0	1
undo block	2	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)	6,569	6,569	6,569	368	56.08
HW-Segment High Water Mark	46	46	7	0	21.43
FB-Format Block	139	139	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	31.71	62,340	0	11	76.5/76.5	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:37	31,713	62,340	0	11	77	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,131	0.00		0
Consistent RBA	62,196	0.00	0.00	0
FOB s.o list latch	343	0.00		0
In memory undo latch	624,573	0.09	0.06	62,893	0.00
JS queue state obj latch	3,600	0.00		0
KMG MMAN ready and startup request latch	200	0.00		0
KTF sga latch	2	0.00		202	0.00
KWQMN job cache list latch	34	0.00		0
MQL Tracking Latch	0			12	0.00
Memory Management Latch	0			200	0.00
OS process	249	0.00		0
OS process allocation	366	0.00		0
OS process: request allocation	158	0.00		0
PL/SQL warning settings	72,203	0.07	0.00	0
SGA IO buffer pool latch	33	0.00		33	0.00
SQL memory manager latch	1	0.00		199	0.00
SQL memory manager workarea list latch	16,788	0.00		0
Shared B-Tree	22	0.00		0
active checkpoint queue latch	6,657	0.00		0
active service list	1,952	0.00		230	0.00
archive control	7	0.00		0
begin backup scn array	3	0.00		0
cache buffer handles	3,124	0.00		0
cache buffers chains	10,092,076	0.02	0.01	243,331	0.03
cache buffers lru chain	204,940	0.08	0.01	251,383	0.45
cache table scan latch	0			248	0.00
channel handle pool latch	160	0.00		0
channel operations parent latch	3,045	0.00		0
checkpoint queue latch	116,008	0.00	0.00	60,313	0.01
client/application info	397	0.00		0
compile environment latch	76,084	0.02	0.00	0
dml lock allocation	440,819	0.30	0.01	0
dummy allocation	158	0.00		0
enqueue hash chains	598,926	0.20	0.03	2,462	0.00
enqueues	101,733	0.04	0.00	0
event group latch	79	0.00		0
file cache latch	23	0.00		0
global KZLD latch for mem in SGA	77	0.00		0
hash table column usage latch	0			61,271	0.00
job_queue_processes parameter latch	10	0.00		0
kks stats	3,063	0.00		0
ksuosstats global area	41	0.00		0
ktm global data	3	0.00		0
kwqbsn:qsga	22	0.00		0
lgwr LWN SCN	62,194	0.00		0
library cache	654,133	0.12	0.03	6,245	0.10
library cache load lock	5,980	0.03	0.00	7	0.00
library cache lock	171,110	0.03	0.21	0
library cache lock allocation	1,787	0.00		0
library cache pin	302,676	0.12	0.01	0
library cache pin allocation	652	0.00		0
list of block allocation	192	0.00		0
loader state object freelist	34	0.00		0
message pool operations parent latch	2	0.00		0
messages	206,329	0.02	0.06	0
mostly latch-free SCN	62,266	0.03	0.11	0
multiblock read objects	506	0.00		0
ncodef allocation latch	11	0.00		0
object queue header heap	13,482	0.00		127	0.00
object queue header operation	676,577	0.02	0.04	0
object stats modification	1	0.00		0
parallel query alloc buffer	80	0.00		0
parameter list	291	0.00		0
parameter table allocation management	79	0.00		0
post/wait queue	49,561	0.01	0.00	31,762	0.06
process allocation	158	0.00		79	0.00
process group creation	158	0.00		0
qmn task queue latch	84	0.00		0
redo allocation	311,714	0.05	0.16	307,658	0.21
redo copy	0			307,931	0.18
redo writing	194,011	0.00	0.25	0
resmgr group change latch	79	0.00		0
resmgr:actses active list	155	0.00		0
resmgr:actses change group	77	0.00		0
resmgr:free threads list	154	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	713,458	0.08	0.00	5,250	0.21
sequence cache	657	0.00		0
session allocation	691,901	0.34	0.00	0
session idle bit	368,707	0.01	0.06	0
session state list latch	160	0.00		0
session switching	11	0.00		0
session timer	230	0.00		0
shared pool	128,861	0.25	0.04	0
shared pool sim alloc	1	0.00		0
shared pool simulator	137,380	0.00		0
simulator hash latch	451,710	0.00	0.00	0
simulator lru latch	419,987	0.13	0.04	14,820	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	160	0.00		0
transaction branch allocation	11	0.00		0
undo global data	426,010	0.05	0.00	0
user lock	308	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	10,092,076	2,432	29	2,403
session allocation	691,901	2,382	7	2,375
dml lock allocation	440,819	1,341	20	1,321
enqueue hash chains	598,926	1,200	37	1,163
library cache	654,133	799	23	776
In memory undo latch	624,573	578	34	544
row cache objects	713,458	568	2	566
simulator lru latch	419,987	564	21	543
library cache pin	302,676	358	2	356
shared pool	128,861	323	13	310
cache buffers lru chain	204,940	170	2	168
redo allocation	311,714	153	25	128
object queue header operation	676,577	128	5	123
library cache lock	171,110	48	10	38
session idle bit	368,707	36	2	34
messages	206,329	32	2	30
mostly latch-free SCN	62,266	19	2	17
redo writing	194,011	4	1	3
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	25	30
In memory undo latch	kticmt: child	6	1
In memory undo latch	ktiTxnPoolFree	2	0
In memory undo latch	ktichg: child	1	1
cache buffers chains	kcbgtcr: fast path	26	24
cache buffers chains	kcbgtcr: kslbegin excl	10	3
cache buffers chains	kcbzgb: scan from tail. nowait	6	0
cache buffers chains	kcbchg: kslbegin: call CR func	5	8
cache buffers chains	kcbgtcr: kslbegin shared	5	0
cache buffers chains	kcbgcur: kslbegin	4	15
cache buffers chains	kcbnew: new latch again	3	0
cache buffers chains	kcbrls: kslbegin	2	3
cache buffers chains	kcb_post_apply: kcbhq62	1	0
cache buffers chains	kcbchg: kslbegin: bufs not pinned	1	9
cache buffers chains	kcbget: exchange	1	0
cache buffers chains	kcbnlc	1	1
cache buffers lru chain	kcbzgws	2	1
dml lock allocation	ktaiam	16	19
dml lock allocation	ktaidm	4	1
enqueue hash chains	ksqrcl	22	11
enqueue hash chains	ksqgtl3	15	25
library cache	kglpndl: child: after processing	7	0
library cache	kgldte: child 0	4	7
library cache	kglobpn: child:	3	0
library cache	kglpnp: child	2	5
library cache	kglLockCursor	1	0
library cache	kglhdgc: child:	1	0
library cache	kglhdgn: child:	1	1
library cache	kglrtl	1	0
library cache lock	kgllkal: child: multiinstance	6	0
library cache lock	kgllkdl: child: cleanup	4	10
library cache pin	kglpndl	2	0
messages	ksaamb: after wakeup	2	1
mostly latch-free SCN	kcs04	1	2
mostly latch-free SCN	kcs05	1	0
object queue header operation	kcbo_switch_cq	3	2
object queue header operation	kcbo_switch_q_bg	1	0
object queue header operation	kcbw_unlink_q	1	3
redo allocation	kcrfw_redo_gen: redo allocation 1	25	0
redo writing	kcrfwcr	1	0
row cache objects	kqreqd: reget	1	0
row cache objects	kqrpre: find obj	1	2
session allocation	ksudlc	5	0
session allocation	ksucri	1	7
session allocation	ksuxds: not user session	1	0
session idle bit	ksupuc: clear busy	1	2
session idle bit	ksupuc: set busy	1	0
shared pool	kghalo	11	3
shared pool	kghfrunp: clatch: nowait	3	0
shared pool	kghfre	1	0
shared pool	kghupr1	1	9
simulator lru latch	kcbs_simulate: simulate set	21	21
slave class create	ksvcreate	1	0

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	440,119	1,338	20	1318/0/0/0
messages	206,012	31	2	29/0/0/0
mostly latch-free SCN	62,166	19	2	17/0/0/0
redo writing	193,743	4	1	3/0/0/0
session allocation	691,621	2,382	7	2375/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	2	64,364	61	6	55/0/0/0
In memory undo latch	6	63,887	56	7	49/0/0/0
In memory undo latch	5	62,774	61	3	58/0/0/0
In memory undo latch	1	62,506	60	3	57/0/0/0
In memory undo latch	4	62,052	53	1	52/0/0/0
In memory undo latch	8	61,850	64	3	61/0/0/0
In memory undo latch	9	61,165	46	3	43/0/0/0
In memory undo latch	10	61,054	59	1	58/0/0/0
In memory undo latch	7	59,741	61	7	54/0/0/0
cache buffers chains	1237	405,291	968	10	958/0/0/0
cache buffers chains	1421	95,834	125	1	124/0/0/0
cache buffers chains	128	70,464	30	2	28/0/0/0
cache buffers chains	749	34,182	4	1	3/0/0/0
cache buffers chains	1476	31,504	2	1	1/0/0/0
cache buffers chains	92	27,015	3	1	2/0/0/0
cache buffers chains	1209	26,035	8	1	7/0/0/0
cache buffers chains	1489	24,246	3	1	2/0/0/0
cache buffers chains	1756	23,330	3	1	2/0/0/0
cache buffers chains	1877	22,811	4	1	3/0/0/0
cache buffers chains	318	9,442	1	1	0/0/0/0
cache buffers chains	327	8,472	1	1	0/0/0/0
cache buffers chains	143	3,284	2	1	1/0/0/0
cache buffers chains	390	3,166	2	1	1/0/0/0
cache buffers chains	524	2,584	3	1	2/0/0/0
cache buffers chains	972	2,571	1	1	0/0/0/0
cache buffers chains	1455	2,508	2	1	1/0/0/0
cache buffers chains	1993	2,413	1	1	0/0/0/0
cache buffers chains	33	2,277	1	1	0/0/0/0
enqueue hash chains	1	166,789	401	12	389/0/0/0
enqueue hash chains	2	166,224	338	12	326/0/0/0
enqueue hash chains	4	100,526	186	12	174/0/0/0
library cache	4	278,224	400	12	388/0/0/0
library cache	2	121,736	135	3	132/0/0/0
library cache	5	102,929	108	8	100/0/0/0
library cache lock	4	134,110	42	9	33/0/0/0
library cache lock	5	9,156	1	1	0/0/0/0
library cache pin	3	68,424	63	1	62/0/0/0
redo allocation	1	124,277	151	24	127/0/0/0
redo allocation	2	62,920	2	1	1/0/0/0
session idle bit	4	55,866	2	1	1/0/0/0
shared pool	1	128,849	323	13	310/0/0/0
simulator lru latch	6	234,246	372	15	357/0/0/0
simulator lru latch	5	185,842	192	6	186/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,750,197
Captured Segments account for 83.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	1,248,544	26.28
TPCC	USERS	STOCK	TABLE	621,856	13.09
TPCC	USERS	CUSTOMER_I1	INDEX	276,160	5.81
TPCC	USERS	CUSTOMER_I2	INDEX	259,120	5.45
TPCC	USERS	CUSTOMER	TABLE	243,120	5.12

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 188,738
Captured Segments account for 100.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	CUSTOMER		TABLE	97,787	51.81
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	AILABLE **	UNDEFINED	56,385	29.87
TPCC	USERS	ITEM		TABLE	22,700	12.03
TPCC	USERS	STOCK		TABLE	5,654	3.00
SYS	SYSAUX	WRH$_LATCH_CHILDREN	49334575_0	TABLE PARTITION	2,066	1.09

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	9,520	72.04
TPCC	USERS	DISTRICT	TABLE	3,694	27.95
SYS	SYSTEM	SMON_SCN_TIME	TABLE	1	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	641	80.23
TPCC	USERS	ORDERS	TABLE	63	7.88
TPCC	USERS	HISTORY	TABLE	52	6.51
TPCC	USERS	WAREHOUSE	TABLE	32	4.01
TPCC	USERS	DISTRICT	TABLE	11	1.38

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	169	17.16	0	1
dc_histogram_data	3,049	32.17	0	64
dc_histogram_defs	30,015	19.82	0	925
dc_object_grants	121	31.40	0	8
dc_object_ids	13,864	6.78	0	272
dc_objects	7,164	16.26	0	260
dc_profiles	77	3.90	0	1
dc_rollback_segments	114	0.00	0	24
dc_segments	5,733	16.22	4	101
dc_sequences	21	38.10	21	0
dc_tablespaces	167,677	0.00	0	5
dc_usernames	469	4.48	0	4
dc_users	8,985	0.55	0	14
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	7	28.57	34,883	0.06	16	0
CLUSTER	52	0.00	275	2.55	7	0
INDEX	109	71.56	321	27.73	11	0
SQL AREA	1,063	78.36	604,314	0.59	499	3
TABLE/PROCEDURE	2,537	18.64	117,514	2.40	1,024	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.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
E	Other	90.57		3.02	7.74	32	33	30	30
	Freeable	13.81	0.00	1.15	0.63	3		12	12
	SQL	2.01	0.99	0.08	0.04	0	8	24	23
	PL/SQL	1.58	0.70	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	1.07	2.20
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.66	22.46	-0.88
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	library cache	3.17	3.18	0.19
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.36	2.40	1.97
	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.35	Recursive Call %:	88.13
Rollback per transaction %:	0.00	Rows per Sort:	10.02

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	96.03	In-memory Sort %:	100.00
Library Hit %:	99.14	Soft Parse %:	98.73
Execute to Parse %:	78.39	Latch Hit %:	99.94
Parse CPU to Parse Elapsd %:	73.77	% Non-Parse CPU:	95.92