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: 374 10-Apr-06 14:20:27 28 11.7

End Snap: 376 10-Apr-06 14:40:29 30 11.8

Elapsed: 20.04 (mins)

DB Time: 172.42 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	374	10-Apr-06 14:20:27	28	11.7
End Snap:	376	10-Apr-06 14:40:29	30	11.8
Elapsed:		20.04 (mins)
DB Time:		172.42 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 708M 712M Std Block Size: 16K

Shared Pool Size: 76M 72M Log Buffer: 6,956K

	Begin	End
Buffer Cache:	708M	712M	Std Block Size:	16K
Shared Pool Size:	76M	72M	Log Buffer:	6,956K

Load Profile

Per Second Per Transaction

Redo size: 517,727.49 4,098.47

Logical reads: 16,538.73 130.92

Block changes: 4,083.79 32.33

Physical reads: 260.42 2.06

Physical writes: 179.45 1.42

User calls: 586.14 4.64

Parses: 438.35 3.47

Hard parses: 1.07 0.01

Sorts: 19.33 0.15

Logons: 0.30 0.00

Executes: 2,054.67 16.27

Transactions: 126.32

	Per Second	Per Transaction
Redo size:	517,727.49	4,098.47
Logical reads:	16,538.73	130.92
Block changes:	4,083.79	32.33
Physical reads:	260.42	2.06
Physical writes:	179.45	1.42
User calls:	586.14	4.64
Parses:	438.35	3.47
Hard parses:	1.07	0.01
Sorts:	19.33	0.15
Logons:	0.30	0.00
Executes:	2,054.67	16.27
Transactions:	126.32

% Blocks changed per Read: 24.69 Recursive Call %: 85.18

Rollback per transaction %: 0.00 Rows per Sort: 10.18

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.92 Redo NoWait %: 99.99

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

Library Hit %: 99.82 Soft Parse %: 99.76

Execute to Parse %: 78.67 Latch Hit %: 99.76

Parse CPU to Parse Elapsd %: 57.46 % Non-Parse CPU: 97.69

Shared Pool Statistics

Begin End

Memory Usage %: 79.73 82.86

% SQL with executions>1: 77.17 79.18

% Memory for SQL w/exec>1: 82.21 76.44

	Begin	End
Memory Usage %:	79.73	82.86
% SQL with executions>1:	77.17	79.18
% Memory for SQL w/exec>1:	82.21	76.44

Top 5 Timed Events

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

db file sequential read 312,625 7,340 23 71.0 User I/O

CPU time 1,964 19.0

log file sync 193,623 717 4 6.9 Commit

enq: TX - row lock contention 19,589 473 24 4.6 Application

SQL*Net break/reset to client 303,652 252 1 2.4 Application

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	312,625	7,340	23	71.0	User I/O
CPU time		1,964		19.0
log file sync	193,623	717	4	6.9	Commit
enq: TX - row lock contention	19,589	473	24	4.6	Application
SQL*Net break/reset to client	303,652	252	1	2.4	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): 10345.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	9,299.88	89.89
DB CPU	1,963.58	18.98
PL/SQL execution elapsed time	240.72	2.33
parse time elapsed	87.69	0.85
hard parse elapsed time	31.53	0.30
connection management call elapsed time	7.83	0.08
PL/SQL compilation elapsed time	6.81	0.07
repeated bind elapsed time	2.72	0.03
hard parse (sharing criteria) elapsed time	0.86	0.01
sequence load elapsed time	0.27	0.00
DB time	10,345.46
background elapsed time	1,012.12
background cpu time	194.65

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	313,381	0.00	7,353	23	2.06
Application	323,241	0.00	725	2	2.13
Commit	193,623	0.00	717	4	1.27
Concurrency	19,096	2.74	53	3	0.13
System I/O	233,673	0.00	47	0	1.54
Configuration	238	0.42	22	92	0.00
Other	12,054	0.02	13	1	0.08
Network	356,076	0.00	4	0	2.34

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	312,625	0.00	7,340	23	2.06
log file sync	193,623	0.00	717	4	1.27
enq: TX - row lock contention	19,589	0.00	473	24	0.13
SQL*Net break/reset to client	303,652	0.00	252	1	2.00
buffer busy waits	15,318	0.01	39	3	0.10
control file parallel write	650	0.00	37	57	0.00
log file switch completion	107	0.00	21	198	0.00
read by other session	628	0.00	11	17	0.00
log file parallel write	220,177	0.00	8	0	1.45
cursor: pin S wait on X	525	99.24	6	12	0.00
SQL*Net message to client	355,107	0.00	4	0	2.34
latch: In memory undo latch	1,577	0.00	4	2	0.01
LGWR wait for redo copy	7,035	0.04	3	0	0.05
rdbms ipc reply	1,733	0.00	3	2	0.01
db file scattered read	66	0.00	2	35	0.00
latch: enqueue hash chains	1,017	0.00	2	2	0.01
latch: cache buffers chains	888	0.00	2	2	0.01
latch free	660	0.00	2	3	0.00
enq: TX - contention	16	0.00	2	102	0.00
control file sequential read	1,802	0.00	1	1	0.01
latch: library cache	418	0.00	1	3	0.00
enq: HW - contention	121	0.00	1	6	0.00
db file parallel write	11,016	0.00	1	0	0.07
latch: redo allocation	417	0.00	1	1	0.00
latch: row cache objects	188	0.00	1	3	0.00
latch: library cache pin	143	0.00	0	2	0.00
os thread startup	4	0.00	0	80	0.00
cursor: pin S	738	0.00	0	0	0.00
latch: session allocation	89	0.00	0	2	0.00
enq: US - contention	163	0.00	0	1	0.00
latch: undo global data	70	0.00	0	2	0.00
latch: object queue header operation	47	0.00	0	2	0.00
log file sequential read	14	0.00	0	6	0.00
log file single write	14	0.00	0	6	0.00
latch: shared pool	22	0.00	0	3	0.00
latch: messages	39	0.00	0	2	0.00
SQL*Net more data to client	936	0.00	0	0	0.01
latch: cache buffers lru chain	15	0.00	0	3	0.00
latch: library cache lock	12	0.00	0	3	0.00
enq: FB - contention	14	0.00	0	2	0.00
latch: redo writing	9	0.00	0	1	0.00
direct path read	28	0.00	0	0	0.00
SQL*Net more data from client	33	0.00	0	0	0.00
direct path write	34	0.00	0	0	0.00
library cache load lock	1	0.00	0	1	0.00
latch: checkpoint queue latch	1	0.00	0	0	0.00
undo segment extension	1	100.00	0	0	0.00
SQL*Net message from client	355,103	0.00	4,876	14	2.34
Streams AQ: qmn slave idle wait	43	0.00	1,176	27347	0.00
Streams AQ: qmn coordinator idle wait	86	50.00	1,176	13674	0.00
Streams AQ: waiting for messages in the queue	240	100.00	1,172	4884	0.00
class slave wait	4	0.00	0	3	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
control file parallel write	650	0.00	37	57	0.00
log file parallel write	220,191	0.00	8	0	1.45
db file sequential read	271	0.00	7	26	0.00
events in waitclass Other	7,881	0.04	4	1	0.05
db file scattered read	44	0.00	2	36	0.00
control file sequential read	381	0.00	1	3	0.00
db file parallel write	11,003	0.00	1	0	0.07
os thread startup	4	0.00	0	80	0.00
log file sequential read	14	0.00	0	6	0.00
log file single write	14	0.00	0	6	0.00
buffer busy waits	15	0.00	0	2	0.00
latch: redo writing	8	0.00	0	1	0.00
direct path read	28	0.00	0	0	0.00
latch: cache buffers chains	5	0.00	0	1	0.00
direct path write	28	0.00	0	0	0.00
rdbms ipc message	196,141	1.71	9,910	51	1.29
smon timer	87	1.15	1,390	15972	0.00
Streams AQ: qmn slave idle wait	43	0.00	1,176	27347	0.00
Streams AQ: qmn coordinator idle wait	86	50.00	1,176	13674	0.00
pmon timer	497	100.00	1,175	2365	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	215,855
IDLE_TIME	265,666
IOWAIT_TIME	220,761
NICE_TIME	1
SYS_TIME	52,669
USER_TIME	153,653
LOAD	10
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	33,004
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	10,296.50	1,944.20	309,034	19,729,058
SYS$USERS	48.80	17.80	1,360	82,775
SYS$BACKGROUND	0.00	0.00	2,661	68,825

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	309674	728712	19047	5271	352401	407
SYS$USERS	1331	2728	9	5	2616	8
SYS$BACKGROUND	2390	4004	35	39	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
7,089	576	151,970	0.05	68.53	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
6,216	295	151,956	0.04	60.09	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
1,511	673	151,954	0.01	14.61	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
471	93	15,061	0.03	4.56	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
454	79	15,059	0.03	4.38	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
417	81	91,227	0.00	4.03	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
262	77	151,927	0.00	2.53	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
249	57	151,922	0.00	2.41	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
206	90	151,952	0.00	2.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
198	39	151,932	0.00	1.92	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
179	97	15,201	0.01	1.73	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
107	17	60,705	0.00	1.04	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
673	1,511	151,954	0.00	14.61	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
576	7,089	151,970	0.00	68.53	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
295	6,216	151,956	0.00	60.09	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
97	179	15,201	0.01	1.73	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
93	471	15,061	0.01	4.56	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
90	206	151,952	0.00	2.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
81	417	91,227	0.00	4.03	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
79	454	15,059	0.01	4.38	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
77	262	151,927	0.00	2.53	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
74	83	151,960	0.00	0.80	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
57	249	151,922	0.00	2.41	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
39	198	151,932	0.00	1.92	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
17	107	60,705	0.00	1.04	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: 19,885,784
Captured SQL account for 89.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
9,134,094	15,061	606.47	45.93	93.32	471.31	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
9,101,459	15,059	604.39	45.77	79.11	453.52	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
4,621,344	151,954	30.41	23.24	672.76	1511.23	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
3,585,572	151,970	23.59	18.03	575.92	7089.34	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
1,534,713	91,227	16.82	7.72	80.63	416.95	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
1,068,113	151,956	7.03	5.37	295.28	6216.37	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
771,689	151,922	5.08	3.88	57.07	248.84	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
760,860	151,960	5.01	3.83	74.31	83.15	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
688,830	151,952	4.53	3.46	89.72	206.40	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
680,658	151,927	4.48	3.42	76.66	261.72	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
414,745	15,201	27.28	2.09	96.63	178.82	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
313,520	151,932	2.06	1.58	39.34	198.37	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
309,252	151,974	2.03	1.56	23.56	25.74	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
304,703	100,234	3.04	1.53	25.52	51.29	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
303,916	151,962	2.00	1.53	31.18	32.12	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
303,910	151,946	2.00	1.53	18.87	19.08	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
228,522	76,174	3.00	1.15	10.00	10.07	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
228,507	76,172	3.00	1.15	19.89	21.66	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
227,397	75,800	3.00	1.14	18.28	19.77	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
219,277	15,202	14.42	1.10	65.59	102.16	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: 313,118
Captured SQL account for 99.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
241,852	151,970	1.59	77.24	575.92	7089.34	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
229,967	151,956	1.51	73.44	295.28	6216.37	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
34,654	15,061	2.30	11.07	93.32	471.31	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
34,634	15,059	2.30	11.06	79.11	453.52	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
28,517	151,954	0.19	9.11	672.76	1511.23	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
21,549	91,227	0.24	6.88	80.63	416.95	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
11,663	151,922	0.08	3.72	57.07	248.84	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
5,208	60,705	0.09	1.66	17.37	107.35	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
3,876	15,201	0.25	1.24	96.63	178.82	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
1,778	9,010	0.20	0.57	6.79	33.50	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: 2,470,488
Captured SQL account for 99.3% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
151,974	151,991	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
151,970	0	0.00	0.05	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
151,962	151,962	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
151,960	151,962	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
151,956	151,954	1.00	0.04	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
151,954	151,953	1.00	0.01	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
151,952	151,959	1.00	0.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
151,950	151,958	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
151,946	151,955	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
151,932	151,952	1.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
151,927	151,946	1.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
151,922	151,961	1.00	0.00	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
100,234	100,254	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
91,227	671,469	7.36	0.00	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
76,174	76,173	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
76,172	76,172	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
75,800	75,801	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
60,705	60,715	1.00	0.00	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 527,062
Captured SQL account for 98.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
151,963	151,970	28.83	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
151,937	151,956	28.83	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
151,919	151,954	28.82	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
15,434	15,433	2.93	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
15,202	15,201	2.88	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
15,063	15,061	2.86	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
3,919	3,919	0.74	bsa0wjtftg3uw		select file# from file$ where ...
1,494	1,494	0.28	86708bvah4akq		select name from undo$ where f...
1,097	1,097	0.21	2ym6hhaq30r73		select type#, blocks, extents,...
699	100,234	0.13	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...

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

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 )

86708bvah4akq select name from undo$ where file#=:1 and block#=:2 and ts#=:3 and status$ != 1

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;

bsa0wjtftg3uw select file# from file$ where ts#=:1

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
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 )
86708bvah4akq	select name from undo$ where file#=:1 and block#=:2 and ts#=:3 and status$ != 1
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;
bsa0wjtftg3uw	select file# from file$ where ts#=:1
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	167,409	139.23	1.10
CPU used when call started	167,205	139.06	1.10
CR blocks created	22,674	18.86	0.15
Cached Commit SCN referenced	130,651	108.66	0.86
Commit SCN cached	350	0.29	0.00
DB time	1,180,983	982.21	7.78
DBWR checkpoint buffers written	40,091	33.34	0.26
DBWR checkpoints	7	0.01	0.00
DBWR transaction table writes	88	0.07	0.00
DBWR undo block writes	150,533	125.20	0.99
IMU CR rollbacks	20,881	17.37	0.14
IMU Flushes	166,279	138.29	1.09
IMU Redo allocation size	390,954,972	325,151.74	2,573.99
IMU commits	126,255	105.00	0.83
IMU contention	146,947	122.21	0.97
IMU pool not allocated	11,524	9.58	0.08
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	780,892,992	649,457.69	5,141.28
IMU- failed to get a private strand	11,524	9.58	0.08
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	74	0.06	0.00
SQL*Net roundtrips to/from client	354,258	294.63	2.33
active txn count during cleanout	37,417	31.12	0.25
application wait time	72,579	60.36	0.48
auto extends on undo tablespace	3	0.00	0.00
background checkpoints completed	7	0.01	0.00
background checkpoints started	7	0.01	0.00
background timeouts	3,798	3.16	0.03
buffer is not pinned count	10,366,460	8,621.64	68.25
buffer is pinned count	94,316,568	78,441.76	620.97
bytes received via SQL*Net from client	401,239,067	333,704.88	2,641.69
bytes sent via SQL*Net to client	155,324,792	129,181.44	1,022.63
calls to get snapshot scn: kcmgss	1,997,067	1,660.93	13.15
calls to kcmgas	335,263	278.83	2.21
calls to kcmgcs	14,333	11.92	0.09
change write time	7,897	6.57	0.05
cleanout - number of ktugct calls	38,487	32.01	0.25
cleanouts and rollbacks - consistent read gets	15,848	13.18	0.10
cleanouts only - consistent read gets	1,312	1.09	0.01
cluster key scan block gets	7,945	6.61	0.05
cluster key scans	5,999	4.99	0.04
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	151,910	126.34	1.00
commit batch/immediate requested	151,910	126.34	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	618	0.51	0.00
commit cleanout failures: cannot pin	3,810	3.17	0.03
commit cleanouts	608,227	505.85	4.00
commit cleanouts successfully completed	603,799	502.17	3.98
commit immediate performed	151,910	126.34	1.00
commit immediate requested	151,910	126.34	1.00
commit txn count during cleanout	5,208	4.33	0.03
concurrency wait time	5,316	4.42	0.03
consistent changes	31,127	25.89	0.20
consistent gets	15,133,104	12,585.99	99.63
consistent gets - examination	12,598,739	10,478.19	82.95
consistent gets direct	0	0.00	0.00
consistent gets from cache	15,133,104	12,585.99	99.63
cursor authentications	347	0.29	0.00
data blocks consistent reads - undo records applied	23,267	19.35	0.15
db block changes	4,910,253	4,083.79	32.33
db block gets	4,752,669	3,952.73	31.29
db block gets direct	17	0.01	0.00
db block gets from cache	4,752,653	3,952.71	31.29
deferred (CURRENT) block cleanout applications	358,513	298.17	2.36
dirty buffers inspected	161,348	134.19	1.06
drop segment calls in space pressure	1,091	0.91	0.01
enqueue conversions	31,160	25.92	0.21
enqueue releases	1,509,273	1,255.24	9.94
enqueue requests	1,509,274	1,255.24	9.94
enqueue timeouts	0	0.00	0.00
enqueue waits	19,661	16.35	0.13
execute count	2,470,488	2,054.67	16.27
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	478,793	398.21	3.15
free buffer requested	489,994	407.52	3.23
global undo segment hints helped	62	0.05	0.00
global undo segment hints were stale	20	0.02	0.00
heap block compress	13,887	11.55	0.09
hot buffers moved to head of LRU	305,627	254.19	2.01
immediate (CR) block cleanout applications	17,160	14.27	0.11
immediate (CURRENT) block cleanout applications	25	0.02	0.00
index fetch by key	4,413,185	3,670.38	29.06
index scans kdiixs1	413,581	343.97	2.72
leaf node 90-10 splits	9	0.01	0.00
leaf node splits	10	0.01	0.00
lob reads	624	0.52	0.00
lob writes	300	0.25	0.00
lob writes unaligned	300	0.25	0.00
local undo segment hints helped	32	0.03	0.00
local undo segment hints were stale	91	0.08	0.00
logons cumulative	360	0.30	0.00
messages received	233,775	194.43	1.54
messages sent	233,775	194.43	1.54
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	2,078,050	1,728.28	13.68
opened cursors cumulative	386,741	321.65	2.55
parse count (hard)	1,286	1.07	0.01
parse count (total)	527,062	438.35	3.47
parse time cpu	4,534	3.77	0.03
parse time elapsed	7,891	6.56	0.05
physical read IO requests	312,776	260.13	2.06
physical read bytes	5,130,125,312	4,266,652.90	33,775.93
physical read total IO requests	314,606	261.65	2.07
physical read total bytes	5,159,792,640	4,291,326.80	33,971.26
physical read total multi block requests	70	0.06	0.00
physical reads	313,118	260.42	2.06
physical reads cache	313,090	260.39	2.06
physical reads cache prefetch	342	0.28	0.00
physical reads direct	28	0.02	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	134,674	112.01	0.89
physical write bytes	3,535,060,992	2,940,060.39	23,274.28
physical write total IO requests	298,233	248.04	1.96
physical write total bytes	4,263,385,088	3,545,797.27	28,069.45
physical write total multi block requests	256,566	213.38	1.69
physical writes	215,763	179.45	1.42
physical writes direct	45	0.04	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes from cache	215,718	179.41	1.42
physical writes non checkpoint	183,980	153.01	1.21
pinned buffers inspected	6	0.00	0.00
prefetch clients - default	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	1,200	1.00	0.01
recovery blocks read	0	0.00	0.00
recursive calls	4,051,170	3,369.30	26.67
recursive cpu usage	105,360	87.63	0.69
redo blocks read for recovery	0	0.00	0.00
redo blocks written	1,359,971	1,131.07	8.95
redo buffer allocation retries	125	0.10	0.00
redo entries	1,397,561	1,162.33	9.20
redo log space requests	156	0.13	0.00
redo log space wait time	2,163	1.80	0.01
redo ordering marks	7,137	5.94	0.05
redo size	622,503,624	517,727.49	4,098.47
redo synch time	74,894	62.29	0.49
redo synch writes	366,036	304.43	2.41
redo wastage	50,081,048	41,651.70	329.73
redo write time	39,607	32.94	0.26
redo writer latching time	343	0.29	0.00
redo writes	220,294	183.22	1.45
rollback changes - undo records applied	759,550	631.71	5.00
rollbacks only - consistent read gets	6,811	5.66	0.04
rows fetched via callback	3,768,967	3,134.60	24.81
session connect time	0	0.00	0.00
session cursor cache hits	370,465	308.11	2.44
session logical reads	19,885,784	16,538.73	130.92
session pga memory	1,399,976	1,164.34	9.22
session pga memory max	1,858,728	1,545.88	12.24
session uga memory	9,865,512	8,205.01	64.95
session uga memory max	162,787,156	135,387.78	1,071.76
shared hash latch upgrades - no wait	468,606	389.73	3.09
shared hash latch upgrades - wait	177	0.15	0.00
sorts (memory)	23,242	19.33	0.15
sorts (rows)	236,597	196.77	1.56
space was found by tune down	1,086	0.90	0.01
space was not found by tune down	4	0.00	0.00
sql area evicted	511	0.42	0.00
sql area purged	0	0.00	0.00
steps of tune down ret. in space pressure	1,095	0.91	0.01
summed dirty queue length	417,983	347.63	2.75
switch current to new buffer	61	0.05	0.00
table fetch by rowid	50,489,656	41,991.54	332.42
table fetch continued row	368	0.31	0.00
table scan blocks gotten	75,125	62.48	0.49
table scan rows gotten	199,908	166.26	1.32
table scans (short tables)	6,662	5.54	0.04
total number of times SMON posted	86	0.07	0.00
transaction rollbacks	151,910	126.34	1.00
tune down retentions in space pressure	1,090	0.91	0.01
undo change vector size	171,908,752	142,974.09	1,131.82
user I/O wait time	735,199	611.45	4.84
user calls	704,766	586.14	4.64
user commits	151,887	126.32	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	17,873	14.86	0.12
write clones created in foreground	99	0.08	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	16,921	21,472
opened cursors current	327	354
logons current	28	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)	7	20.96

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	308,861	257	23.56	1.00	31,158	26	15,199	3.23
UNDOTBS1	9	0	232.22	1.00	102,935	86	743	2.53
SYSTEM	2,855	2	19.20	1.10	47	0	4	22.50
SYSAUX	1,043	1	20.31	1.06	388	0	0	0.00
TEMP	2	0	70.00	1.00	0	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	/u02/app/oracle/oradata/TESTIBM/sysaux01.dbf	1,043	1	20.31	1.06	388	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	2,855	2	19.20	1.10	47	0	4	22.50
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	2	0	70.00	1.00	0	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	9	0	232.22	1.00	102,935	86	743	2.53
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	308,861	257	23.56	1.00	31,158	26	15,199	3.23

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,794	98	19,882,042	313,058	215,783	0	0	15,943

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	31	10381	339714	1187522	1290240	1187522
E	0	33	13348	349459	1290240	1290240	1992895

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.75	8,875,652
D	136	0.19	8,568	2.87	4,424,116
D	204	0.29	12,852	2.24	3,456,063
D	272	0.38	17,136	1.87	2,891,898
D	340	0.48	21,420	1.62	2,503,071
D	408	0.57	25,704	1.44	2,226,809
D	476	0.67	29,988	1.31	2,021,194
D	544	0.76	34,272	1.20	1,854,661
D	612	0.86	38,556	1.11	1,714,142
D	680	0.96	42,840	1.03	1,592,434
D	712	1.00	44,856	1.00	1,543,657
D	748	1.05	47,124	0.96	1,489,021
D	816	1.15	51,408	0.91	1,399,584
D	884	1.24	55,692	0.86	1,322,855
D	952	1.34	59,976	0.81	1,257,477
D	1,020	1.43	64,260	0.78	1,201,224
D	1,088	1.53	68,544	0.75	1,154,994
D	1,156	1.62	72,828	0.72	1,114,499
D	1,224	1.72	77,112	0.70	1,079,089
D	1,292	1.81	81,396	0.68	1,050,080
D	1,360	1.91	85,680	0.66	1,024,365

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	271	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	47	109.65	0.00	0.00	0.00	0.00	21,094
E	103	47	110.62	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	17,467	17,467
64K	128K	6	6
256K	512K	2	2
512K	1024K	397	397

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	1,445.41	43.95	97.00	26
26	0.25	1,445.41	43.95	97.00	25
52	0.50	1,445.41	21.98	99.00	18
77	0.75	1,445.41	0.00	100.00	0
103	1.00	1,445.41	0.00	100.00	0
124	1.20	1,445.41	0.00	100.00	0
144	1.40	1,445.41	0.00	100.00	0
165	1.60	1,445.41	0.00	100.00	0
185	1.80	1,445.41	0.00	100.00	0
206	2.00	1,445.41	0.00	100.00	0
309	3.00	1,445.41	0.00	100.00	0
412	4.00	1,445.41	0.00	100.00	0
618	6.00	1,445.41	0.00	100.00	0
824	8.00	1,445.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
40	0.56	8	1,028	887,603	0.98	18,799	36.01	5,587,260
48	0.67	15	1,628	893,712	0.99	12,690	24.31	5,594,946
56	0.78	22	2,207	895,665	0.99	10,737	20.57	5,600,329
64	0.89	29	2,759	901,233	0.99	5,169	9.90	5,602,732
72	1.00	37	3,290	905,880	1.00	522	1.00	5,603,768
80	1.11	44	3,745	907,925	1.00	1	0.00	5,604,221
88	1.22	52	4,199	909,962	1.00	1	0.00	5,604,496
96	1.33	60	4,835	909,963	1.00	1	0.00	5,604,579
104	1.44	63	5,278	909,963	1.00	1	0.00	5,604,580
112	1.56	63	5,278	909,963	1.00	1	0.00	5,604,580
120	1.67	63	5,278	909,963	1.00	1	0.00	5,604,580
128	1.78	63	5,278	909,963	1.00	1	0.00	5,604,580
136	1.89	63	5,278	909,963	1.00	1	0.00	5,604,580
144	2.00	63	5,278	909,963	1.00	1	0.00	5,604,580

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	187,114	4,415,402
400	0.50	115,200	2,498,020
600	0.75	85,989	1,850,984
800	1.00	69,444	1,540,561
1,000	1.25	59,565	1,254,787
1,200	1.50	53,845	1,112,285
1,400	1.75	50,569	1,022,162
1,600	2.00	50,571	1,022,162

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	15,167	49	3
file header block	123	1	8
undo header	587	1	2
segment header	11	0	6
undo block	33	0	1
1st level bmb	26	0	0
2nd level bmb	3	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)	19,358	19,357	19,349	485	25.08
TX-Transaction	308,126	307,665	15	2	111.33
HW-Segment High Water Mark	65,855	65,855	112	1	7.14
US-Undo Segment	31,028	31,028	154	0	1.56
FB-Format Block	145	145	14	0	2.14

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	151.04	154,551	0	12	14.65/15.5166666666666666666666666666666666667	0/0	5/0/0/2051/186660/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 14:39	74,994	2	0	12	15	0/0	2/0/0/594/44912/0
10-Apr 14:29	76,047	154,549	0	12	16	0/0	3/0/0/1457/141748/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	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AWR Alerted Metric Element list	4,184	0.00		0	0
Consistent RBA	220,369	0.01	0.12	0	0
FIB s.o chain latch	4	0.00		0	0
FOB s.o list latch	1,535	0.00		0	0
In memory undo latch	2,928,684	0.76	0.07	4	304,216	0.00
JS queue state obj latch	7,200	0.00		0	0
KMG MMAN ready and startup request latch	401	0.00		0	0
KMG resize request state object freelist	2	0.00		0	0
KTF sga latch	3	0.00		0	405	0.00
KWQMN job cache list latch	1	0.00		0	0
MQL Tracking Latch	0			0	24	0.00
Memory Management Latch	20	0.00		0	401	0.00
OS process	1,101	0.00		0	0
OS process allocation	1,136	0.00		0	0
OS process: request allocation	719	0.00		0	0
PL/SQL warning settings	350,078	0.52	0.00	0	0
SGA IO buffer pool latch	16,802	0.00		0	16,841	0.00
SQL memory manager latch	2	0.00		0	390	0.00
SQL memory manager workarea list latch	29,462	0.00		0	0
Shared B-Tree	45	0.00		0	0
Undo Hint Latch	0			0	3,148	0.00
active checkpoint queue latch	11,891	0.00		0	0
active service list	4,172	0.00		0	496	0.00
archive control	6	0.00		0	0
begin backup scn array	3	0.00		0	0
buffer pool	4	0.00		0	0
cache buffer handles	2,766	0.11	0.00	0	0
cache buffers chains	41,802,931	0.10	0.02	2	488,106	0.07
cache buffers lru chain	650,011	0.15	0.02	0	508,321	0.71
cache table scan latch	0			0	66	0.00
channel handle pool latch	723	0.00		0	0
channel operations parent latch	14,298	0.00		0	0
checkpoint queue latch	323,028	0.00	0.08	0	206,189	0.03
client/application info	1,813	0.00		0	0
compile environment latch	369,460	0.20	0.00	0	0
dml lock allocation	2,130,796	1.05	0.02	1	0
dummy allocation	719	0.00		0	0
enqueue hash chains	3,069,024	0.71	0.05	2	3,422	0.06
enqueues	639,418	0.37	0.01	0	0
event group latch	360	0.00		0	0
file cache latch	3,671	0.00		0	0
global KZLD latch for mem in SGA	355	0.00		0	0
hash table column usage latch	256	0.00		0	31,852	0.00
hash table modification latch	4	0.00		0	0
job_queue_processes parameter latch	20	0.00		0	0
kks stats	3,244	0.00		0	0
ksuosstats global area	85	0.00		0	0
ktm global data	237	0.00		0	0
kwqbsn:qsga	45	0.00		0	0
lgwr LWN SCN	220,360	0.01	0.00	0	0
library cache	2,849,494	0.59	0.03	1	6,346	0.16
library cache load lock	5,864	0.00		0	0
library cache lock	702,137	0.30	0.01	0	0
library cache lock allocation	6,926	0.00		0	0
library cache pin	1,394,873	0.56	0.02	0	0
library cache pin allocation	1,327	0.00		0	0
list of block allocation	732	0.00		0	0
loader state object freelist	88	0.00		0	0
message pool operations parent latch	4	0.00		0	0
messages	718,947	0.10	0.06	0	0
mostly latch-free SCN	221,306	0.11	0.04	0	0
multiblock read objects	140	0.00		0	0
ncodef allocation latch	23	0.00		0	0
object queue header heap	24,957	0.00		0	1,163	0.00
object queue header operation	1,608,448	0.05	0.06	0	0
object stats modification	2	0.00		0	0
parallel query alloc buffer	156	0.00		0	0
parameter list	1,300	0.00		0	0
parameter table allocation management	361	0.00		0	0
post/wait queue	297,229	0.01	0.03	0	193,246	0.34
process allocation	719	0.00		0	360	0.00
process group creation	719	0.00		0	0
qmn task queue latch	172	0.00		0	0
redo allocation	1,283,422	0.22	0.15	1	1,390,139	1.35
redo copy	0			0	1,397,276	0.68
redo writing	690,913	0.01	0.18	0	0
resmgr group change latch	363	0.00		0	0
resmgr:actses active list	713	0.00		0	0
resmgr:actses change group	356	0.00		0	0
resmgr:free threads list	711	0.00		0	0
resmgr:schema config	2	0.00		0	0
row cache objects	2,841,992	0.48	0.01	1	4,225	0.24
sequence cache	2,027	0.00		0	0
session allocation	1,343,356	0.58	0.01	0	0
session idle bit	1,778,204	0.07	0.02	0	0
session state list latch	726	0.00		0	0
session switching	23	0.00		0	0
session timer	496	0.00		0	0
shared pool	161,604	0.19	0.07	0	0
shared pool sim alloc	5	0.00		0	0
shared pool simulator	130,372	0.00	1.00	0	0
simulator hash latch	1,195,940	0.00	0.00	0	0
simulator lru latch	1,123,292	0.21	0.06	0	29,069	0.02
slave class	4	0.00		0	0
slave class create	16	12.50	1.00	0	0
sort extent pool	128	0.00		0	0
state object free list	4	0.00		0	0
statistics aggregation	224	0.00		0	0
temp lob duration state obj allocation	4	0.00		0	0
threshold alerts latch	72	0.00		0	0
transaction allocation	4,934	0.00		0	0
transaction branch allocation	23	0.00		0	0
undo global data	2,227,741	0.13	0.02	0	0
user lock	1,424	0.00		0	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	41,802,931	42,778	890	41,895
dml lock allocation	2,130,796	22,363	441	21,927
In memory undo latch	2,928,684	22,216	1,579	20,657
enqueue hash chains	3,069,024	21,711	1,017	20,706
library cache	2,849,494	16,786	421	16,369
row cache objects	2,841,992	13,576	188	13,388
session allocation	1,343,356	7,795	87	7,708
library cache pin	1,394,873	7,794	143	7,652
undo global data	2,227,741	2,964	70	2,894
redo allocation	1,283,422	2,824	416	2,409
enqueues	639,418	2,390	27	2,364
simulator lru latch	1,123,292	2,378	152	2,227
library cache lock	702,137	2,112	12	2,100
session idle bit	1,778,204	1,317	22	1,295
cache buffers lru chain	650,011	956	15	941
object queue header operation	1,608,448	800	47	753
messages	718,947	693	39	654
shared pool	161,604	309	22	287
mostly latch-free SCN	221,306	251	10	241
redo writing	690,913	51	9	42
Consistent RBA	220,369	33	4	29
post/wait queue	297,229	33	1	32
checkpoint queue latch	323,028	12	1	11
slave class create	16	2	2	0
shared pool simulator	130,372	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	1,242	1,339
In memory undo latch	ktichg: child	153	190
In memory undo latch	ktiTxnPoolFree	104	0
In memory undo latch	kticmt: child	66	5
In memory undo latch	kturbk	14	45
cache buffers chains	kcbgtcr: fast path	578	503
cache buffers chains	kcbgcur: kslbegin	205	297
cache buffers chains	kcbchg: kslbegin: bufs not pinned	118	219
cache buffers chains	kcbgtcr: kslbegin excl	108	64
cache buffers chains	kcbgtcr: kslbegin shared	64	10
cache buffers chains	kcbnew: new latch again	50	5
cache buffers chains	kcbzgb: scan from tail. nowait	33	0
cache buffers chains	kcb_pre_apply: kcbhq61	23	25
cache buffers chains	kcbchg: kslbegin: call CR func	21	71
cache buffers chains	kcbgtcr	18	0
cache buffers chains	kcbrls: kslbegin	18	31
cache buffers chains	kcbnlc	13	30
cache buffers chains	kcbzwb	13	6
cache buffers chains	kcbget: exchange rls	10	0
cache buffers chains	kcb_post_apply: kcbhq62	9	9
cache buffers chains	kcbzib: finish free bufs	6	6
cache buffers chains	kcbbxsv	5	3
cache buffers chains	kcbget: pin buffer	4	10
cache buffers chains	kcbcge	3	2
cache buffers chains	kcbbic1	2	1
cache buffers chains	kcbget: exchange	1	2
cache buffers lru chain	kcbzgws	13	6
cache buffers lru chain	kcbbic2	1	4
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	1	0
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	1	0
dml lock allocation	ktaiam	274	361
dml lock allocation	ktaidm	167	80
enqueue hash chains	ksqrcl	526	322
enqueue hash chains	ksqgtl3	483	686
enqueue hash chains	ksqcmi: get hash chain latch after wait	6	9
enqueue hash chains	ksqcnl	2	0
enqueues	ksqies	13	17
enqueues	ksqgel: create enqueue	12	6
enqueues	ksqdel	2	4
library cache	kglpndl: child: after processing	162	1
library cache	kglpnp: child	128	215
library cache	kglLockCursor	37	3
library cache	kgldte: child 0	26	37
library cache	kglobpn: child:	17	2
library cache	kglpndl: child: before processing	14	160
library cache	kglpin	8	0
library cache	kglhdgn: child:	6	1
library cache	kglrtl	2	0
library cache lock	kgllkal: child: multiinstance	6	2
library cache lock	kgllkdl: child: cleanup	6	10
library cache pin	kglpndl	80	69
library cache pin	kglpnp: child	62	74
library cache pin	kglpnal: child: alloc space	1	0
messages	ksaamb: after wakeup	28	19
messages	ksarcv	9	20
messages	ksarcv: after wait	2	0
mostly latch-free SCN	kcs04	8	10
mostly latch-free SCN	kcs01	4	4
mostly latch-free SCN	kcs05	2	0
object queue header operation	kcbw_link_q	21	0
object queue header operation	kcbo_switch_cq	16	43
object queue header operation	kcbo_switch_q_bg	4	0
object queue header operation	kcbw_unlink_q	4	4
object queue header operation	kcbo_swap_buf_bg	1	0
object queue header operation	kcbo_switch_mq_bg	1	0
post/wait queue	ksliwat:add:nowait	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	397	0
redo allocation	kcrfw_redo_gen: redo allocation 3	12	8
redo allocation	kcrfw_redo_gen: redo allocation 2	5	0
redo allocation	kcrfw_redo_write: before write	1	219
redo allocation	kcrfw_redo_write: more space	1	189
redo writing	kcrfw_cal_target_rba	3	0
redo writing	kcrfw_post: rba scn pair	3	0
redo writing	kcrfwcr	3	5
row cache objects	kqreqd: reget	105	0
row cache objects	kqrpre: find obj	78	160
row cache objects	kqreqd	4	25
session allocation	ksucri	29	74
session allocation	ksuxds: not user session	25	10
session allocation	ksudlc	19	3
session allocation	ksuprc	12	0
session allocation	ksucrp	1	0
session allocation	ksuxds: KSUSFCLC not set	1	0
session idle bit	ksupuc: set busy	12	5
session idle bit	ksuxds	8	8
session idle bit	ksupuc: clear busy	4	11
shared pool	kghfrunp: clatch: nowait	21	0
shared pool	kghalo	15	5
shared pool	kghfrunp: alloc: wait	2	0
shared pool	kghupr1	2	14
shared pool	kghalp	1	3
shared pool	kghfre	1	4
shared pool	kghfrunp: alloc: session dur	1	0
shared pool	kghfrunp: clatch: wait	1	3
shared pool simulator	kglsim_upd_newhp	1	0
simulator lru latch	kcbs_simulate: simulate set	140	152
simulator lru latch	kcbs_simbufseq	11	0
simulator lru latch	kcbs_lookup_setid	1	0
slave class create	ksvcreate	2	0
undo global data	ktudba: KSLBEGIN	26	21
undo global data	ktudnx:child	22	14
undo global data	ktubnd:child	10	0
undo global data	kturimugur: child	5	0
undo global data	ktufrbs: child	3	31
undo global data	ktusm_stealext: KSLBEGIN	3	3
undo global data	ktusmasp: ktugd_tuux	1	4

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: 19,885,784
Captured Segments account for 84.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	6,016,192	30.25
TPCC	USERS	STOCK	TABLE	2,992,960	15.05
TPCC	USERS	CUSTOMER_I2	INDEX	1,242,720	6.25
TPCC	USERS	CUSTOMER	TABLE	1,178,432	5.93
TPCC	USERS	CUSTOMER_I1	INDEX	889,200	4.47

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 313,118
Captured Segments account for 98.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	ITEM_ID	INDEX	147,660	47.16
TPCC	USERS	ITEM	TABLE	81,895	26.15
TPCC	USERS	CUSTOMER	TABLE	41,073	13.12
TPCC	USERS	STOCK	TABLE	33,754	10.78
TPCC	USERS	CUSTOMER_I2	INDEX	1,074	0.34

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	21,190	54.90
TPCC	USERS	WAREHOUSE	TABLE	17,402	45.09
SYS	SYSTEM	SMON_SCN_TIME	TABLE	2	0.01

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
TPCC	USERS	WAREHOUSE	TABLE	937	57.66
TPCC	USERS	HISTORY	TABLE	420	25.85
TPCC	USERS	DISTRICT	TABLE	230	14.15
TPCC	USERS	INORD	INDEX	25	1.54
TPCC	USERS	ORDERS	TABLE	7	0.43

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	27	3.70	4	1
dc_global_oids	126	30.95	0	0
dc_histogram_data	7,837	30.22	0	423
dc_histogram_defs	15,912	34.60	0	937
dc_object_grants	109	27.52	0	8
dc_object_ids	9,734	7.73	0	224
dc_objects	5,003	17.49	0	200
dc_profiles	355	0.56	0	1
dc_rollback_segments	77,113	0.00	0	23
dc_segments	10,128	10.77	10	177
dc_sequences	49	12.24	49	1
dc_tablespace_quotas	4	75.00	0	0
dc_tablespaces	811,556	0.00	0	5
dc_usernames	1,015	0.79	0	4
dc_users	12,961	0.11	0	15
outstanding_alerts	25	80.00	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	16	37.50	167,778	0.01	17
CLUSTER	74	5.41	182	2.75	1
INDEX	78	66.67	257	23.35	8
SQL AREA	1,331	50.04	2,833,584	0.12	450
TABLE/PROCEDURE	2,637	19.72	529,856	0.53	941

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	97.65		3.49	10.87	55	55	28	28
	Freeable	8.38	0.00	0.84	0.28	1		10	10
	SQL	1.45	0.63	0.07	0.03	0	8	22	21
	PL/SQL	1.16	0.53	0.04	0.05	0	0	28	28
E	Other	98.71		3.29	10.51	55	55	30	30
	Freeable	9.06	0.00	0.82	0.37	1		11	11
	SQL	1.59	0.71	0.07	0.02	0	8	24	23
	PL/SQL	1.27	0.61	0.04	0.05	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	742,391,808	746,586,112
Fixed Size	1,263,572
Redo Buffers	7,122,944
Variable Size	88,082,476	83,888,172

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	4.00	4.00	0.00
large	PX msg pool	1.02	1.02	0.00
large	free memory	2.98	2.98	0.00
shared	ASH buffers	8.00	8.00	0.00
shared	CCursor	0.82		-100.00
shared	FileOpenBlock	1.58	1.58	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGH: NO ACCESS	3.20	7.03	119.50
shared	KGLS heap	1.01	1.05	3.73
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	KSXR pending messages que	0.80	0.80	0.00
shared	KSXR receive buffers	0.99	0.99	0.00
shared	KTI-UNDO	2.36	2.36	0.00
shared	db_block_hash_buckets	1.13	1.13	0.00
shared	dbwriter coalesce buffer	1.00	1.00	0.00
shared	event statistics per sess	2.56	2.56	0.00
shared	free memory	15.40	12.34	-19.91
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kks stbkt	0.88	0.88	0.00
shared	library cache	3.00	2.88	-4.06
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.84	2.43	-14.53
	buffer_cache	708.00	712.00	0.56
	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.69	Recursive Call %:	85.18
Rollback per transaction %:	0.00	Rows per Sort:	10.18

Buffer Nowait %:	99.92	Redo NoWait %:	99.99
Buffer Hit %:	98.43	In-memory Sort %:	100.00
Library Hit %:	99.82	Soft Parse %:	99.76
Execute to Parse %:	78.67	Latch Hit %:	99.76
Parse CPU to Parse Elapsd %:	57.46	% Non-Parse CPU:	97.69