WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

TESTIBM 1448208628 TESTIBM 1 10.2.0.2.0 NO brepredbwh04

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 379 10-Apr-06 15:10:36 30 14.1

End Snap: 380 10-Apr-06 15:20:36 30 13.1

Elapsed: 10.01 (mins)

DB Time: 96.93 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	379	10-Apr-06 15:10:36	30	14.1
End Snap:	380	10-Apr-06 15:20:36	30	13.1
Elapsed:		10.01 (mins)
DB Time:		96.93 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 212,497.66 4,140.15

Logical reads: 6,749.13 131.50

Block changes: 1,660.48 32.35

Physical reads: 107.69 2.10

Physical writes: 82.31 1.60

User calls: 238.90 4.65

Parses: 179.79 3.50

Hard parses: 0.83 0.02

Sorts: 9.44 0.18

Logons: 0.12 0.00

Executes: 842.02 16.41

Transactions: 51.33

	Per Second	Per Transaction
Redo size:	212,497.66	4,140.15
Logical reads:	6,749.13	131.50
Block changes:	1,660.48	32.35
Physical reads:	107.69	2.10
Physical writes:	82.31	1.60
User calls:	238.90	4.65
Parses:	179.79	3.50
Hard parses:	0.83	0.02
Sorts:	9.44	0.18
Logons:	0.12	0.00
Executes:	842.02	16.41
Transactions:	51.33

% Blocks changed per Read: 24.60 Recursive Call %: 85.89

Rollback per transaction %: 0.00 Rows per Sort: 11.11

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 99.99

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

Library Hit %: 99.63 Soft Parse %: 99.54

Execute to Parse %: 78.65 Latch Hit %: 99.97

Parse CPU to Parse Elapsd %: 27.43 % Non-Parse CPU: 97.07

Shared Pool Statistics

Begin End

Memory Usage %: 75.23 77.50

% SQL with executions>1: 81.72 84.11

% Memory for SQL w/exec>1: 75.38 79.46

	Begin	End
Memory Usage %:	75.23	77.50
% SQL with executions>1:	81.72	84.11
% Memory for SQL w/exec>1:	75.38	79.46

Top 5 Timed Events

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

db file sequential read 63,970 5,109 80 87.9 User I/O

enq: TX - row lock contention 4,395 445 101 7.7 Application

CPU time 262 4.5

log file sync 31,235 29 1 .5 Commit

control file parallel write 293 26 88 .4 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	63,970	5,109	80	87.9	User I/O
enq: TX - row lock contention	4,395	445	101	7.7	Application
CPU time		262		4.5
log file sync	31,235	29	1	.5	Commit
control file parallel write	293	26	88	.4	System I/O

Main Report

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

Time Model Statistics

Total time in database user-calls (DB Time): 5815.5s
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,745.63	98.80
DB CPU	261.73	4.50
PL/SQL execution elapsed time	29.30	0.50
parse time elapsed	24.61	0.42
hard parse elapsed time	17.93	0.31
PL/SQL compilation elapsed time	3.63	0.06
connection management call elapsed time	2.10	0.04
repeated bind elapsed time	0.41	0.01
sequence load elapsed time	0.23	0.00
hard parse (sharing criteria) elapsed time	0.08	0.00
DB time	5,815.51
background elapsed time	369.07
background cpu time	43.62

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	64,110	0.00	5,120	80	2.08
Application	65,257	0.00	465	7	2.12
Commit	31,235	0.00	29	1	1.01
System I/O	66,452	0.00	29	0	2.15
Configuration	24	0.00	5	229	0.00
Concurrency	439	0.23	2	4	0.01
Network	72,061	0.00	1	0	2.34
Other	275	0.00	1	2	0.01

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	63,970	0.00	5,109	80	2.07
enq: TX - row lock contention	4,395	0.00	445	101	0.14
log file sync	31,235	0.00	29	1	1.01
control file parallel write	293	0.00	26	88	0.01
SQL*Net break/reset to client	60,862	0.00	19	0	1.97
read by other session	113	0.00	9	78	0.00
log file switch completion	15	0.00	4	289	0.00
buffer busy waits	385	0.00	2	4	0.01
log file parallel write	60,146	0.00	1	0	1.95
db file scattered read	9	0.00	1	161	0.00
control file sequential read	850	0.00	1	1	0.03
enq: HW - contention	9	0.00	1	129	0.00
SQL*Net message to client	71,702	0.00	1	0	2.33
enq: TX - contention	3	0.00	0	152	0.00
db file parallel write	5,159	0.00	0	0	0.17
os thread startup	2	0.00	0	50	0.00
latch free	21	0.00	0	3	0.00
latch: cache buffers chains	22	0.00	0	1	0.00
LGWR wait for redo copy	218	0.00	0	0	0.01
latch: enqueue hash chains	10	0.00	0	2	0.00
log file single write	2	0.00	0	9	0.00
cursor: pin S wait on X	1	100.00	0	13	0.00
SQL*Net more data to client	343	0.00	0	0	0.01
latch: In memory undo latch	14	0.00	0	1	0.00
log file sequential read	2	0.00	0	4	0.00
enq: FB - contention	3	0.00	0	1	0.00
latch: session allocation	3	0.00	0	1	0.00
latch: shared pool	3	0.00	0	1	0.00
latch: library cache	11	0.00	0	0	0.00
cursor: pin S	1	0.00	0	1	0.00
rdbms ipc reply	10	0.00	0	0	0.00
SQL*Net more data from client	16	0.00	0	0	0.00
latch: redo allocation	5	0.00	0	0	0.00
latch: row cache objects	1	0.00	0	0	0.00
direct path write	10	0.00	0	0	0.00
latch: undo global data	1	0.00	0	0	0.00
direct path read	8	0.00	0	0	0.00
SQL*Net message from client	71,704	0.00	1,289	18	2.33
Streams AQ: qmn slave idle wait	22	0.00	591	26883	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	591	13441	0.00
Streams AQ: waiting for messages in the queue	121	100.00	588	4861	0.00
class slave wait	2	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
control file parallel write	293	0.00	26	88	0.01
db file sequential read	195	0.00	10	52	0.01
log file parallel write	60,218	0.00	1	0	1.95
control file sequential read	149	0.00	1	5	0.00
db file parallel write	5,159	0.00	0	0	0.17
db file scattered read	3	0.00	0	42	0.00
os thread startup	2	0.00	0	50	0.00
events in waitclass Other	233	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	8	0.00	0	0	0.00
direct path write	6	0.00	0	0	0.00
rdbms ipc message	61,834	2.76	4,427	72	2.01
Streams AQ: qmn slave idle wait	22	0.00	591	26883	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	591	13441	0.00
pmon timer	218	100.00	589	2703	0.01
smon timer	4	25.00	470	117449	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	34,046
IDLE_TIME	211,073
IOWAIT_TIME	107,150
NICE_TIME	0
SYS_TIME	9,764
USER_TIME	22,778
LOAD	10
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	32,564
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,723.10	252.10	62,852	3,924,590
SYS$USERS	30.40	6.40	317	38,655
SYS$BACKGROUND	0.00	0.00	766	30,841

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	62983	503845	437	170	70642	59
SYS$USERS	312	2374	0	0	1179	2
SYS$BACKGROUND	771	5403	2	10	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
4,462	91	30,977	0.14	76.72	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
4,015	52	30,897	0.13	69.04	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
874	90	30,822	0.03	15.04	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
354	17	18,526	0.02	6.08	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
312	13	3,087	0.10	5.37	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
304	11	3,085	0.10	5.23	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
199	10	30,894	0.01	3.42	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
196	8	30,897	0.01	3.37	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
173	4	30,822	0.01	2.97	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
122	9	30,896	0.00	2.10	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
100	3	12,295	0.01	1.72	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
70	14	3,113	0.02	1.21	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Elapsed Time (s)	Executions	% Total DB Time	SQL Id	SQL Module	SQL Text
91	4,462	30,977	76.72	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
90	874	30,822	15.04	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
52	4,015	30,897	69.04	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
17	354	18,526	6.08	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
14	70	3,113	1.21	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
13	312	3,087	5.37	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
11	304	3,085	5.23	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
10	199	30,894	3.42	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
9	28	3,113	0.49	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
9	122	30,896	2.10	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
8	196	30,897	3.37	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
4	173	30,822	2.97	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
3	100	12,295	1.72	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

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

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,858,189	3,087	601.94	45.83	12.82	312.30	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
1,849,089	3,085	599.38	45.60	10.74	304.32	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
923,086	30,822	29.95	22.76	89.90	874.42	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
719,539	30,977	23.23	17.74	90.54	4461.81	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
308,743	18,526	16.67	7.61	17.20	353.60	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
217,216	30,897	7.03	5.36	52.37	4015.27	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
157,698	30,894	5.10	3.89	10.20	198.77	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
154,705	30,897	5.01	3.82	6.57	7.78	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
127,198	30,896	4.12	3.14	8.97	121.85	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
126,240	30,897	4.09	3.11	8.00	196.21	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
85,828	3,113	27.57	2.12	13.91	70.36	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
64,492	30,822	2.09	1.59	4.05	172.90	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
63,572	30,895	2.06	1.57	2.95	2.95	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
62,086	20,424	3.04	1.53	3.44	38.88	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
61,794	30,897	2.00	1.52	3.09	3.38	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
61,644	30,822	2.00	1.52	2.12	2.12	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
46,725	15,575	3.00	1.15	1.19	1.76	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
46,725	15,575	3.00	1.15	2.22	3.34	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
45,831	15,277	3.00	1.13	2.04	2.23	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
44,590	3,113	14.32	1.10	9.32	28.26	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 64,702
Captured SQL account for 99.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
48,257	30,977	1.56	74.58	90.54	4461.81	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
45,271	30,897	1.47	69.97	52.37	4015.27	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
7,331	30,822	0.24	11.33	89.90	874.42	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
7,031	3,087	2.28	10.87	12.82	312.30	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
6,914	3,085	2.24	10.69	10.74	304.32	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
5,640	18,526	0.30	8.72	17.20	353.60	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
2,835	30,894	0.09	4.38	10.20	198.77	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
1,225	12,295	0.10	1.89	3.07	100.16	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
1,004	3,113	0.32	1.55	13.91	70.36	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
531	1,896	0.28	0.82	1.72	29.91	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: 505,891
Captured SQL account for 97.6% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
30,977	0	0.00	0.14	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
30,897	30,897	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
30,897	30,899	1.00	0.13	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
30,897	30,897	1.00	0.01	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
30,897	30,897	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
30,896	30,896	1.00	0.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
30,895	30,896	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
30,894	30,896	1.00	0.01	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
30,822	30,822	1.00	0.01	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
30,822	30,821	1.00	0.03	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
30,822	30,822	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
30,820	30,822	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
20,424	20,424	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
18,526	134,901	7.28	0.02	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
15,575	15,575	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
15,575	15,575	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
15,277	15,277	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
12,295	12,295	1.00	0.01	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 108,018
Captured SQL account for 98.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
30,976	30,977	28.68	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
30,897	30,897	28.60	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
30,824	30,822	28.54	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
3,112	3,113	2.88	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
3,109	3,109	2.88	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
3,089	3,087	2.86	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
435	435	0.40	2ym6hhaq30r73		select type#, blocks, extents,...
243	761	0.22	3c1kubcdjnppq		update sys.col_usage$ set eq...
243	0	0.22	53btfq0dt9bs9		insert into sys.col_usage$ val...
243	243	0.22	b2gnxm5z6r51n		lock table sys.col_usage$ in e...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

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

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

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

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

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

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

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

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

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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	23,128	38.50	0.75
CPU used when call started	23,060	38.38	0.75
CR blocks created	6,133	10.21	0.20
Cached Commit SCN referenced	21,506	35.80	0.70
Commit SCN cached	70	0.12	0.00
DB time	658,490	1,096.01	21.35
DBWR checkpoint buffers written	13,164	21.91	0.43
DBWR checkpoints	1	0.00	0.00
DBWR transaction table writes	43	0.07	0.00
DBWR undo block writes	30,596	50.93	0.99
IMU CR rollbacks	6,027	10.03	0.20
IMU Flushes	33,041	54.99	1.07
IMU Redo allocation size	78,542,768	130,729.22	2,547.03
IMU commits	26,862	44.71	0.87
IMU contention	22,685	37.76	0.74
IMU pool not allocated	1,911	3.18	0.06
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	161,424,112	268,679.71	5,234.75
IMU- failed to get a private strand	1,911	3.18	0.06
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for undo segment shrink	1	0.00	0.00
SQL*Net roundtrips to/from client	72,377	120.47	2.35
active txn count during cleanout	10,560	17.58	0.34
application wait time	47,957	79.82	1.56
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	2	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	1,909	3.18	0.06
buffer is not pinned count	2,133,626	3,551.28	69.19
buffer is pinned count	19,228,568	32,004.67	623.56
bytes received via SQL*Net from client	81,525,053	135,693.03	2,643.74
bytes sent via SQL*Net to client	31,941,477	53,164.47	1,035.82
calls to get snapshot scn: kcmgss	406,976	677.38	13.20
calls to kcmgas	69,300	115.35	2.25
calls to kcmgcs	1,807	3.01	0.06
change write time	967	1.61	0.03
cleanout - number of ktugct calls	9,913	16.50	0.32
cleanouts and rollbacks - consistent read gets	4,503	7.49	0.15
cleanouts only - consistent read gets	132	0.22	0.00
cluster key scan block gets	2,986	4.97	0.10
cluster key scans	2,154	3.59	0.07
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	30,850	51.35	1.00
commit batch/immediate requested	30,850	51.35	1.00
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	134	0.22	0.00
commit cleanout failures: cannot pin	388	0.65	0.01
commit cleanouts	123,892	206.21	4.02
commit cleanouts successfully completed	123,370	205.34	4.00
commit immediate performed	30,850	51.35	1.00
commit immediate requested	30,850	51.35	1.00
commit txn count during cleanout	713	1.19	0.02
concurrency wait time	180	0.30	0.01
consistent changes	7,862	13.09	0.25
consistent gets	3,107,713	5,172.58	100.78
consistent gets - examination	2,581,635	4,296.96	83.72
consistent gets direct	0	0.00	0.00
consistent gets from cache	3,107,713	5,172.58	100.78
cursor authentications	88	0.15	0.00
data blocks consistent reads - undo records applied	6,380	10.62	0.21
db block changes	997,626	1,660.48	32.35
db block gets	947,201	1,576.55	30.72
db block gets direct	9	0.01	0.00
db block gets from cache	947,192	1,576.54	30.72
deferred (CURRENT) block cleanout applications	72,279	120.30	2.34
dirty buffers inspected	32,501	54.10	1.05
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	128	0.21	0.00
enqueue releases	289,173	481.31	9.38
enqueue requests	289,164	481.29	9.38
enqueue timeouts	0	0.00	0.00
enqueue waits	4,573	7.61	0.15
execute count	505,891	842.02	16.41
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	105,925	176.31	3.43
free buffer requested	102,206	170.12	3.31
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	2,788	4.64	0.09
hot buffers moved to head of LRU	80,652	134.24	2.62
immediate (CR) block cleanout applications	4,635	7.71	0.15
immediate (CURRENT) block cleanout applications	21	0.03	0.00
index fetch by key	909,726	1,514.18	29.50
index scans kdiixs1	86,773	144.43	2.81
leaf node 90-10 splits	7	0.01	0.00
leaf node splits	9	0.01	0.00
lob reads	286	0.48	0.01
lob writes	145	0.24	0.00
lob writes unaligned	145	0.24	0.00
local undo segment hints helped	0	0.00	0.00
local undo segment hints were stale	0	0.00	0.00
logons cumulative	75	0.12	0.00
messages received	66,154	110.11	2.15
messages sent	66,154	110.11	2.15
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	432,311	719.55	14.02
opened cursors cumulative	81,933	136.37	2.66
parse count (failures)	0	0.00	0.00
parse count (hard)	499	0.83	0.02
parse count (total)	108,018	179.79	3.50
parse time cpu	767	1.28	0.02
parse time elapsed	2,796	4.65	0.09
physical read IO requests	64,676	107.65	2.10
physical read bytes	1,060,077,568	1,764,428.67	34,376.81
physical read total IO requests	65,521	109.06	2.12
physical read total bytes	1,073,890,304	1,787,419.05	34,824.73
physical read total multi block requests	9	0.01	0.00
physical reads	64,702	107.69	2.10
physical reads cache	64,694	107.68	2.10
physical reads cache prefetch	26	0.04	0.00
physical reads direct	8	0.01	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	29,449	49.02	0.95
physical write bytes	810,270,720	1,348,641.77	26,275.93
physical write total IO requests	78,109	130.01	2.53
physical write total bytes	969,810,944	1,614,185.87	31,449.59
physical write total multi block requests	68,100	113.35	2.21
physical writes	49,455	82.31	1.60
physical writes direct	17	0.03	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes from cache	49,438	82.29	1.60
physical writes non checkpoint	39,155	65.17	1.27
pinned buffers inspected	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	596	0.99	0.02
recovery blocks read	0	0.00	0.00
recursive calls	873,362	1,453.65	28.32
recursive cpu usage	14,306	23.81	0.46
redo blocks read for recovery	0	0.00	0.00
redo blocks written	283,568	471.98	9.20
redo buffer allocation retries	10	0.02	0.00
redo entries	275,828	459.10	8.94
redo log space requests	15	0.02	0.00
redo log space wait time	441	0.73	0.01
redo ordering marks	1,054	1.75	0.03
redo size	127,669,656	212,497.66	4,140.15
redo synch time	3,228	5.37	0.10
redo synch writes	74,252	123.59	2.41
redo wastage	12,577,748	20,934.83	407.88
redo write time	5,091	8.47	0.17
redo writer latching time	0	0.00	0.00
redo writes	60,886	101.34	1.97
rollback changes - undo records applied	154,250	256.74	5.00
rollbacks only - consistent read gets	1,628	2.71	0.05
rows fetched via callback	768,425	1,278.99	24.92
session connect time	0	0.00	0.00
session cursor cache hits	77,901	129.66	2.53
session logical reads	4,054,914	6,749.13	131.50
session uga memory	2,168,496	3,609.32	70.32
session uga memory max	35,095,432	58,414.01	1,138.09
shared hash latch upgrades - no wait	98,213	163.47	3.18
shared hash latch upgrades - wait	4	0.01	0.00
sorts (memory)	5,670	9.44	0.18
sorts (rows)	62,992	104.85	2.04
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	122	0.20	0.00
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	174,837	291.00	5.67
switch current to new buffer	5	0.01	0.00
table fetch by rowid	10,294,842	17,135.08	333.85
table fetch continued row	146	0.24	0.00
table scan blocks gotten	13,059	21.74	0.42
table scan rows gotten	37,211	61.94	1.21
table scans (short tables)	201	0.33	0.01
total number of times SMON posted	3	0.00	0.00
transaction rollbacks	30,850	51.35	1.00
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	35,173,504	58,543.96	1,140.63
user I/O wait time	517,233	860.90	16.77
user calls	143,535	238.90	4.65
user commits	30,837	51.33	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	4,588	7.64	0.15
write clones created in foreground	62	0.10	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	28,785	29,628
opened cursors current	423	394
workarea memory allocated	0	342
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	62,807	105	79.95	1.00	9,791	16	482	22.26
UNDOTBS1	4	0	122.50	1.00	18,933	32	16	0.00
SYSTEM	668	1	64.28	1.02	24	0	0	0.00
SYSAUX	373	1	91.53	1.04	173	0	0	0.00
TEMP	1	0	30.00	1.00	37	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	373	1	91.53	1.04	173	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	668	1	64.28	1.02	24	0	0	0.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	1	0	30.00	1.00	37	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	4	0	122.50	1.00	18,933	32	16	0.00
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	62,807	105	79.95	1.00	9,791	16	482	22.26

Back to IO Stats
Back to Top

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	44,274	98	4,021,959	64,438	49,333	0	0	503

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	22	7888	165353	1290240	1290240	1949717
E	0	22	8249	149525	1290240	1290240	1686928

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	68	0.10	4,284	5.72	12,004,750
D	136	0.19	8,568	2.85	5,976,237
D	204	0.29	12,852	2.23	4,672,832
D	272	0.39	17,136	1.87	3,914,267
D	340	0.48	21,420	1.61	3,388,854
D	408	0.58	25,704	1.44	3,011,449
D	476	0.68	29,988	1.30	2,734,268
D	544	0.77	34,272	1.20	2,508,094
D	612	0.87	38,556	1.10	2,315,836
D	680	0.97	42,840	1.02	2,149,611
D	704	1.00	44,352	1.00	2,098,565
D	748	1.06	47,124	0.96	2,006,120
D	816	1.16	51,408	0.90	1,883,287
D	884	1.26	55,692	0.85	1,777,868
D	952	1.35	59,976	0.81	1,689,523
D	1,020	1.45	64,260	0.77	1,613,426
D	1,088	1.55	68,544	0.74	1,550,074
D	1,156	1.64	72,828	0.71	1,495,025
D	1,224	1.74	77,112	0.69	1,447,258
D	1,292	1.84	81,396	0.67	1,408,509
D	1,360	1.93	85,680	0.65	1,373,563

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	131	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	103	38	127.71	0.00	0.00	0.00	0.00	21,094
E	103	38	128.28	0.00	0.00	0.00	0.00	21,094

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	4,377	4,377
64K	128K	3	3
256K	512K	2	2
512K	1024K	204	204

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
13	0.13	2,080.32	59.35	97.00	36
26	0.25	2,080.32	59.35	97.00	35
52	0.50	2,080.32	37.38	98.00	28
77	0.75	2,080.32	0.00	100.00	0
103	1.00	2,080.32	0.00	100.00	0
124	1.20	2,080.32	0.00	100.00	0
144	1.40	2,080.32	0.00	100.00	0
165	1.60	2,080.32	0.00	100.00	0
185	1.80	2,080.32	0.00	100.00	0
206	2.00	2,080.32	0.00	100.00	0
309	3.00	2,080.32	0.00	100.00	0
412	4.00	2,080.32	0.00	100.00	0
618	6.00	2,080.32	0.00	100.00	0
824	8.00	2,080.32	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
32	0.40	9	1,059	3,233,045	0.99	43,549	57.53	7,785,868
40	0.50	16	1,673	3,237,980	0.99	38,614	51.01	7,792,752
48	0.60	23	2,182	3,259,028	0.99	17,566	23.20	7,799,288
56	0.70	30	2,541	3,267,425	1.00	9,169	12.11	7,802,987
64	0.80	38	3,012	3,271,156	1.00	5,438	7.18	7,805,512
72	0.90	45	3,349	3,274,346	1.00	2,248	2.97	7,806,795
80	1.00	52	3,704	3,275,837	1.00	757	1.00	7,807,288
88	1.10	60	4,066	3,276,624	1.00	1	0.00	7,807,607
96	1.20	68	4,545	3,276,924	1.00	1	0.00	7,807,782
104	1.30	76	4,961	3,276,924	1.00	1	0.00	7,807,794
112	1.40	84	5,629	3,276,924	1.00	1	0.00	7,807,803
120	1.50	86	5,949	3,276,925	1.00	1	0.00	7,807,811
128	1.60	86	5,949	3,276,925	1.00	1	0.00	7,807,812
136	1.70	86	5,949	3,276,925	1.00	1	0.00	7,807,813
144	1.80	86	5,949	3,276,925	1.00	1	0.00	7,807,813
152	1.90	86	5,949	3,276,925	1.00	1	0.00	7,807,813
160	2.00	86	5,949	3,276,925	1.00	1	0.00	7,807,813

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
200	0.25	243,206	5,979,001
400	0.50	144,963	3,390,179
600	0.75	110,644	2,509,043
800	1.00	90,939	2,099,442
1,000	1.25	79,033	1,690,261
1,200	1.50	70,787	1,495,642
1,400	1.75	65,814	1,374,295
1,600	2.00	65,830	1,374,295

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	482	11	22
undo header	15	0	0
1st level bmb	1	0	0
segment header	1	0	0
undo block	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	4,423	4,421	4,421	460	103.98
HW-Segment High Water Mark	49	49	8	1	146.25
TX-Transaction	61,469	61,455	3	0	156.67
FB-Format Block	33	33	3	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	30.06	60,495	0	12	17.8666666666666666666666666666666666667/17.866666666666666666666666666666666666	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
10-Apr 15:19	30,062	60,495	0	12	18	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,130	0.00		0
Consistent RBA	60,408	0.00	0.00	0
FOB s.o list latch	313	0.00		0
In memory undo latch	595,030	0.12	0.02	61,434	0.00
JS queue state obj latch	3,660	0.00		0
KMG MMAN ready and startup request latch	203	0.00		0
KTF sga latch	1	0.00		204	0.00
MQL Tracking Latch	0			12	0.00
Memory Management Latch	0			203	0.00
OS process	237	0.00		0
OS process allocation	361	0.00		0
OS process: request allocation	150	0.00		0
PL/SQL warning settings	70,504	0.01	0.00	0
SGA IO buffer pool latch	3,318	0.00		3,318	0.00
SQL memory manager latch	1	0.00		194	0.00
SQL memory manager workarea list latch	14,219	0.00		0
Shared B-Tree	23	0.00		0
active checkpoint queue latch	5,312	0.00		0
active service list	1,958	0.00		219	0.00
archive control	1	0.00		0
begin backup scn array	1	0.00		0
cache buffer handles	571	0.00		0
cache buffers chains	8,431,074	0.01	0.02	101,115	0.02
cache buffers lru chain	147,886	0.03	0.00	106,451	0.11
cache table scan latch	0			9	0.00
channel handle pool latch	152	0.00		0
channel operations parent latch	3,072	0.00		0
checkpoint queue latch	91,149	0.00		45,750	0.01
client/application info	382	0.00		0
compile environment latch	73,911	0.04	0.00	0
dml lock allocation	431,048	0.17	0.02	0
dummy allocation	150	0.00		0
enqueue hash chains	578,226	0.11	0.02	2,845	0.07
enqueues	93,251	0.03	0.00	0
event group latch	75	0.00		0
file cache latch	33	0.00		0
global KZLD latch for mem in SGA	73	0.00		0
hash table column usage latch	258	0.00		14,081	0.00
job_queue_processes parameter latch	10	0.00		0
kks stats	1,522	0.00		0
ksuosstats global area	43	0.00		0
ktm global data	6	0.00		0
kwqbsn:qsga	23	0.00		0
lgwr LWN SCN	60,404	0.00		0
library cache	593,754	0.07	0.03	1,997	0.10
library cache load lock	2,576	0.00		0
library cache lock	149,891	0.05	0.00	0
library cache lock allocation	1,478	0.00		0
library cache pin	286,291	0.07	0.00	0
library cache pin allocation	396	0.00		0
list of block allocation	156	0.00		0
loader state object freelist	26	0.00		0
message pool operations parent latch	2	0.00		0
messages	197,293	0.03	0.00	0
mostly latch-free SCN	60,439	0.00	0.00	0
multiblock read objects	20	0.00		0
ncodef allocation latch	10	0.00		0
object queue header heap	10,919	0.00		432	0.00
object queue header operation	349,218	0.01	0.00	0
object stats modification	2	0.00		0
parallel query alloc buffer	80	0.00		0
parameter list	271	0.00		0
parameter table allocation management	75	0.00		0
post/wait queue	48,268	0.01	0.20	31,361	0.13
process allocation	150	0.00		75	0.00
process group creation	150	0.00		0
qmn task queue latch	88	0.00		0
redo allocation	303,423	0.03	0.05	271,423	0.20
redo copy	0			271,671	0.15
redo writing	187,333	0.00	0.00	0
resmgr group change latch	76	0.00		0
resmgr:actses active list	147	0.00		0
resmgr:actses change group	73	0.00		0
resmgr:free threads list	146	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	537,528	0.07	0.00	894	0.00
sequence cache	659	0.00		0
session allocation	346,487	0.06	0.01	0
session idle bit	358,556	0.01	0.04	0
session state list latch	150	0.00		0
session switching	10	0.00		0
session timer	219	0.00		0
shared pool	61,791	0.07	0.07	0
shared pool sim alloc	3	0.00		0
shared pool simulator	43,506	0.00	1.00	0
simulator hash latch	248,995	0.00	0.00	0
simulator lru latch	234,177	0.03	0.07	6,000	0.02
slave class	2	0.00		0
slave class create	8	12.50	1.00	0
sort extent pool	23	0.00		0
state object free list	2	0.00		0
statistics aggregation	112	0.00		0
temp lob duration state obj allocation	2	0.00		0
threshold alerts latch	36	0.00		0
transaction allocation	152	0.00		0
transaction branch allocation	10	0.00		0
undo global data	388,835	0.02	0.01	0
user lock	292	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	8,431,074	1,153	23	1,130
dml lock allocation	431,048	730	12	718
In memory undo latch	595,030	699	14	685
enqueue hash chains	578,226	642	10	632
library cache	593,754	435	11	425
row cache objects	537,528	380	1	379
session allocation	346,487	219	3	216
redo allocation	303,423	99	5	94
undo global data	388,835	74	1	73
simulator lru latch	234,177	70	5	65
shared pool	61,791	45	3	42
session idle bit	358,556	25	1	24
post/wait queue	48,268	5	1	4
shared pool simulator	43,506	1	1	0
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	8	12
In memory undo latch	ktiTxnPoolFree	2	0
In memory undo latch	kticmt: child	2	0
In memory undo latch	ktbgfc	1	0
In memory undo latch	ktichg: child	1	0
cache buffers chains	kcbgtcr: fast path	26	19
cache buffers chains	kcbgcur: kslbegin	8	3
cache buffers chains	kcbchg: kslbegin: bufs not pinned	4	10
cache buffers chains	kcbgtcr: kslbegin excl	3	3
cache buffers chains	kcb_post_apply: kcbhq63	1	2
cache buffers chains	kcbchg: kslbegin: call CR func	1	8
cache buffers chains	kcbget: pin buffer	1	0
cache buffers chains	kcbgtcr: kslbegin shared	1	0
cache buffers chains	kcbnew: new latch again	1	0
cache buffers chains	kcbnlc	1	3
cache buffers chains	kcbso1: set no access	1	0
dml lock allocation	ktaiam	6	8
dml lock allocation	ktaidm	6	4
enqueue hash chains	ksqrcl	9	2
enqueue hash chains	ksqgtl3	1	8
library cache	kglpndl: child: after processing	7	0
library cache	kglhdgn: child:	2	0
library cache	kglLockCursor	1	0
post/wait queue	ksliwat:remove	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	5	0
row cache objects	kqrpre: find obj	1	1
session allocation	ksucri	2	3
session allocation	ksuprc	1	0
session idle bit	ksuxds	1	1
shared pool	kghalo	1	0
shared pool	kghfrunp: alloc: session dur	1	0
shared pool	kghfrunp: clatch: nowait	1	0
shared pool	kghupr1	1	3
shared pool simulator	kglsim_upd_newhp	1	0
simulator lru latch	kcbs_simulate: simulate set	4	5
simulator lru latch	kcbs_simbufseq	1	0
slave class create	ksvcreate	1	0
undo global data	ktudnx:child	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 4,054,914
Captured Segments account for 83.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	1,201,120	29.62
TPCC	USERS	STOCK	TABLE	596,976	14.72
TPCC	USERS	CUSTOMER_I2	INDEX	250,288	6.17
TPCC	USERS	CUSTOMER	TABLE	233,376	5.76
TPCC	USERS	CUSTOMER_I1	INDEX	174,656	4.31

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 64,702
Captured Segments account for 97.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	ITEM_ID	INDEX	29,195	45.12
TPCC	USERS	ITEM	TABLE	15,288	23.63
TPCC	USERS	CUSTOMER	TABLE	10,584	16.36
TPCC	USERS	STOCK	TABLE	6,571	10.16
TPCC	USERS	CUSTOMER_I2	INDEX	286	0.44

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
TPCC	USERS	DISTRICT	TABLE	5,836	67.78
TPCC	USERS	WAREHOUSE	TABLE	2,772	32.20
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	WAREHOUSE	TABLE	62	74.70
TPCC	USERS	DISTRICT	TABLE	11	13.25
TPCC	USERS	HISTORY	TABLE	10	12.05

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	0.00	2	1
dc_global_oids	61	31.15	0	0
dc_histogram_data	3,176	22.04	0	570
dc_histogram_defs	7,016	31.56	0	757
dc_object_grants	44	11.36	0	5
dc_object_ids	4,291	6.80	0	241
dc_objects	2,029	16.12	0	222
dc_profiles	73	0.00	0	1
dc_rollback_segments	111	0.00	0	23
dc_segments	1,869	22.69	5	165
dc_sequences	19	21.05	19	2
dc_tablespace_quotas	1	100.00	0	0
dc_tablespaces	157,575	0.00	0	5
dc_usernames	259	0.77	0	4
dc_users	4,657	0.02	0	15
outstanding_alerts	12	83.33	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	8	37.50	33,855	0.02	4
CLUSTER	26	0.00	56	3.57	2
INDEX	38	42.11	115	23.48	11
SQL AREA	512	66.60	577,498	0.24	112
TABLE/PROCEDURE	1,186	18.97	109,868	1.13	466

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	111.60		3.72	11.71	62	62	30	30
	Freeable	12.69	0.00	1.15	0.82	4		11	11
	SQL	1.93	0.93	0.08	0.04	0	8	24	23
	PL/SQL	1.56	0.74	0.05	0.06	0	0	30	30
E	Other	111.67		3.72	11.71	62	62	30	30
	Freeable	13.50	0.00	1.04	0.80	4		13	13
	SQL	1.66	0.70	0.07	0.03	0	8	24	24
	PL/SQL	1.46	0.51	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	738,197,504
Fixed Size	1,263,572
Redo Buffers	7,122,944
Variable Size	92,276,780

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	10.78	10.78	0.00
shared	KGLS heap		1.06
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KSXR receive buffers	0.99	0.99	0.00
shared	KTI-UNDO	2.36	2.36	0.00
shared	PL/SQL MPCODE	1.21		-100.00
shared	db_block_hash_buckets	1.13	1.13	0.00
shared	dbwriter coalesce buffer	1.00	1.00	0.00
shared	event statistics per sess	2.56	2.56	0.00
shared	free memory	19.81	18.00	-9.15
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	library cache	3.00	3.01	0.34
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	1.91	3.49	82.92
	buffer_cache	704.00	704.00	0.00
	fixed_sga	1.21	1.21	0.00
	log_buffer	6.79	6.79	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/opt/oracle/admin/TESTIBM/adump
background_dump_dest	/opt/oracle/admin/TESTIBM/bdump
compatible	10.2.0.2.0
control_files	/u02/app/oracle/oradata/TESTIBM/control01.ctl, /u02/app/oracle/oradata/TESTIBM/control02.ctl, /u03/app/oracle/oradata/TESTIBM/control03.ctl
core_dump_dest	/opt/oracle/admin/TESTIBM/cdump
db_block_size	16384
db_domain
db_file_multiblock_read_count	16
db_name	TESTIBM
filesystemio_options	ASYNCH
job_queue_processes	10
open_cursors	300
pga_aggregate_target	108003328
processes	300
remote_login_passwordfile	EXCLUSIVE
sessions	335
sga_target	838860800
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/opt/oracle/admin/TESTIBM/udump

End of Report

% Blocks changed per Read:	24.60	Recursive Call %:	85.89
Rollback per transaction %:	0.00	Rows per Sort:	11.11

Buffer Nowait %:	99.99	Redo NoWait %:	99.99
Buffer Hit %:	98.40	In-memory Sort %:	100.00
Library Hit %:	99.63	Soft Parse %:	99.54
Execute to Parse %:	78.65	Latch Hit %:	99.97
Parse CPU to Parse Elapsd %:	27.43	% Non-Parse CPU:	97.07