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: 349 10-Apr-06 09:30:21 27 11.8

End Snap: 350 10-Apr-06 09:40:28 28 12.0

Elapsed: 10.11 (mins)

DB Time: 95.84 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	349	10-Apr-06 09:30:21	27	11.8
End Snap:	350	10-Apr-06 09:40:28	28	12.0
Elapsed:		10.11 (mins)
DB Time:		95.84 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 123,236.77 4,091.94

Logical reads: 4,034.85 133.97

Block changes: 974.58 32.36

Physical reads: 67.31 2.24

Physical writes: 53.94 1.79

User calls: 140.62 4.67

Parses: 108.65 3.61

Hard parses: 0.94 0.03

Sorts: 8.18 0.27

Logons: 0.09 0.00

Executes: 501.76 16.66

Transactions: 30.12

	Per Second	Per Transaction
Redo size:	123,236.77	4,091.94
Logical reads:	4,034.85	133.97
Block changes:	974.58	32.36
Physical reads:	67.31	2.24
Physical writes:	53.94	1.79
User calls:	140.62	4.67
Parses:	108.65	3.61
Hard parses:	0.94	0.03
Sorts:	8.18	0.27
Logons:	0.09	0.00
Executes:	501.76	16.66
Transactions:	30.12

% Blocks changed per Read: 24.15 Recursive Call %: 87.42

Rollback per transaction %: 0.00 Rows per Sort: 10.59

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95 Redo NoWait %: 99.97

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

Library Hit %: 99.29 Soft Parse %: 99.13

Execute to Parse %: 78.35 Latch Hit %: 99.75

Parse CPU to Parse Elapsd %: 23.98 % Non-Parse CPU: 95.78

Shared Pool Statistics

Begin End

Memory Usage %: 82.54 81.72

% SQL with executions>1: 47.66 79.86

% Memory for SQL w/exec>1: 65.57 72.71

	Begin	End
Memory Usage %:	82.54	81.72
% SQL with executions>1:	47.66	79.86
% Memory for SQL w/exec>1:	65.57	72.71

Top 5 Timed Events

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

db file sequential read 40,356 2,830 70 49.2 User I/O

log file sync 37,108 2,552 69 44.4 Commit

enq: TX - row lock contention 3,591 221 62 3.8 Application

CPU time 172 3.0

control file parallel write 265 49 186 .9 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	40,356	2,830	70	49.2	User I/O
log file sync	37,108	2,552	69	44.4	Commit
enq: TX - row lock contention	3,591	221	62	3.8	Application
CPU time		172		3.0
control file parallel write	265	49	186	.9	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): 5750.3s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	3,185.49	55.40
DB CPU	171.64	2.98
parse time elapsed	31.49	0.55
hard parse elapsed time	23.45	0.41
PL/SQL execution elapsed time	23.35	0.41
PL/SQL compilation elapsed time	7.84	0.14
connection management call elapsed time	1.56	0.03
hard parse (sharing criteria) elapsed time	0.73	0.01
repeated bind elapsed time	0.26	0.00
hard parse (bind mismatch) elapsed time	0.06	0.00
sequence load elapsed time	0.05	0.00
DB time	5,750.31
background elapsed time	845.08
background cpu time	16.67

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
User I/O	40,490	0.00	2,839	70	2.22
Commit	37,108	0.00	2,552	69	2.03
Application	40,128	0.00	232	6	2.20
System I/O	18,458	0.00	51	3	1.01
Concurrency	2,083	31.54	24	11	0.11
Configuration	15	0.00	2	154	0.00
Other	331	15.41	1	3	0.02
Network	44,121	0.00	0	0	2.41

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	40,356	0.00	2,830	70	2.21
log file sync	37,108	0.00	2,552	69	2.03
enq: TX - row lock contention	3,591	0.00	221	62	0.20
control file parallel write	265	0.00	49	186	0.01
buffer busy waits	1,188	0.17	12	10	0.07
SQL*Net break/reset to client	36,537	0.00	10	0	2.00
cursor: pin S wait on X	655	100.00	8	12	0.04
db file scattered read	72	0.00	6	77	0.00
read by other session	58	0.00	4	66	0.00
library cache load lock	19	0.00	3	163	0.00
log file switch completion	12	0.00	2	186	0.00
control file sequential read	854	0.00	1	1	0.05
SGA: allocation forcing component growth	48	93.75	1	12	0.00
latch: In memory undo latch	72	0.00	0	5	0.00
SQL*Net message to client	43,481	0.00	0	0	2.38
log file parallel write	12,163	0.00	0	0	0.67
kksfbc child completion	6	83.33	0	42	0.00
latch: cache buffers chains	97	0.00	0	2	0.01
db file parallel write	5,172	0.00	0	0	0.28
latch free	39	0.00	0	3	0.00
latch: library cache	26	0.00	0	4	0.00
os thread startup	2	0.00	0	44	0.00
LGWR wait for redo copy	147	0.68	0	1	0.01
enq: HW - contention	3	0.00	0	26	0.00
log file single write	2	0.00	0	18	0.00
latch: enqueue hash chains	15	0.00	0	2	0.00
log file sequential read	2	0.00	0	12	0.00
cursor: pin S	61	0.00	0	0	0.00
SQL*Net more data to client	616	0.00	0	0	0.03
latch: shared pool	5	0.00	0	3	0.00
latch: session allocation	5	0.00	0	2	0.00
row cache lock	6	0.00	0	2	0.00
latch: cache buffers lru chain	1	0.00	0	6	0.00
latch: object queue header operation	3	0.00	0	2	0.00
latch: redo allocation	4	0.00	0	1	0.00
cursor: mutex X	13	0.00	0	0	0.00
enq: FB - contention	1	0.00	0	1	0.00
latch: messages	1	0.00	0	1	0.00
SQL*Net more data from client	24	0.00	0	0	0.00
direct path write	4	0.00	0	0	0.00
SQL*Net message from client	43,486	0.00	1,545	36	2.38
Streams AQ: waiting for time management or cleanup tasks	3	33.33	1,265	421506	0.00
Streams AQ: qmn slave idle wait	22	0.00	602	27346	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	602	13673	0.00
Streams AQ: waiting for messages in the queue	121	99.17	590	4878	0.01
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	265	0.00	49	186	0.01
db file sequential read	124	0.00	6	52	0.01
buffer busy waits	2	0.00	0	171	0.00
log file parallel write	12,161	0.00	0	0	0.67
db file parallel write	5,172	0.00	0	0	0.28
os thread startup	2	0.00	0	44	0.00
events in waitclass Other	152	0.66	0	1	0.01
log file single write	2	0.00	0	18	0.00
log file sequential read	2	0.00	0	12	0.00
latch: cache buffers chains	2	0.00	0	6	0.00
latch: shared pool	1	0.00	0	1	0.00
control file sequential read	121	0.00	-0	-1	0.01
rdbms ipc message	8,338	20.08	3,886	466	0.46
Streams AQ: waiting for time management or cleanup tasks	3	33.33	1,265	421506	0.00
Streams AQ: qmn slave idle wait	22	0.00	602	27346	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	602	13673	0.00
pmon timer	215	100.00	589	2739	0.01
smon timer	2	100.00	586	292972	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	22,077
IDLE_TIME	218,161
IOWAIT_TIME	127,487
NICE_TIME	0
SYS_TIME	6,189
USER_TIME	14,790
LOAD	8
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	34,768
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,728.50	166.80	39,265	2,359,575
SYS$USERS	32.80	6.00	787	68,786
SYS$BACKGROUND	0.00	0.00	771	24,395

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	39303	277259	2077	2333	42511	34
SYS$USERS	400	2599	0	0	1470	2
SYS$BACKGROUND	775	3996	7	45	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
2,454	50	18,061	0.14	42.67	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
2,245	14	18,058	0.12	39.04	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
411	67	18,069	0.02	7.15	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
208	10	1,786	0.12	3.62	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
202	9	1,786	0.11	3.51	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
142	10	10,753	0.01	2.46	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
92	8	1,825	0.05	1.60	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
85	6	18,055	0.00	1.48	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
83	10	18,057	0.00	1.44	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
80	5	18,056	0.00	1.39	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
77	3	18,058	0.00	1.34	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
69	5	1,825	0.04	1.20	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...

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
67	411	18,069	0.00	7.15	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
50	2,454	18,061	0.00	42.67	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
14	2,245	18,058	0.00	39.04	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
10	208	1,786	0.01	3.62	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
10	83	18,057	0.00	1.44	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
10	142	10,753	0.00	2.46	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
9	202	1,786	0.00	3.51	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
8	92	1,825	0.00	1.60	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
8	17	18,058	0.00	0.29	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
6	85	18,055	0.00	1.48	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
5	80	18,056	0.00	1.39	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
5	69	1,825	0.00	1.20	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
3	77	18,058	0.00	1.34	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...

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: 2,447,683
Captured SQL account for 86.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,093,522	1,786	612.27	44.68	10.27	208.18	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
1,089,307	1,786	609.91	44.50	8.80	201.56	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
545,782	18,069	30.21	22.30	67.19	411.04	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
421,498	18,061	23.34	17.22	50.45	2453.78	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
181,802	10,753	16.91	7.43	9.98	141.73	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
126,936	18,058	7.03	5.19	13.94	2245.10	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
92,512	18,056	5.12	3.78	4.97	79.70	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
90,484	18,058	5.01	3.70	7.89	16.86	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
77,515	18,057	4.29	3.17	10.01	82.62	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
75,249	18,055	4.17	3.07	6.44	84.85	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
42,527	1,825	23.30	1.74	8.34	92.23	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
37,726	18,058	2.09	1.54	3.25	77.31	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
36,895	18,072	2.04	1.51	2.34	4.31	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
36,190	18,059	2.00	1.48	2.88	4.69	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
36,158	18,069	2.00	1.48	1.75	1.77	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
36,044	11,848	3.04	1.47	2.44	13.04	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
27,368	9,076	3.02	1.12	1.86	2.91	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
26,991	8,996	3.00	1.10	0.89	0.94	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
26,988	8,996	3.00	1.10	2.06	2.28	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 40,834
Captured SQL account for 97.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
29,051	18,061	1.61	71.14	50.45	2453.78	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
27,781	18,058	1.54	68.03	13.94	2245.10	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
4,840	1,786	2.71	11.85	10.27	208.18	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
4,838	1,786	2.71	11.85	8.80	201.56	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
3,580	18,069	0.20	8.77	67.19	411.04	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
2,803	10,753	0.26	6.86	9.98	141.73	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
1,812	1,825	0.99	4.44	8.34	92.23	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
1,475	1,825	0.81	3.61	4.89	69.18	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
1,171	18,056	0.06	2.87	4.97	79.70	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
547	7,316	0.07	1.34	1.37	39.19	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 304,387
Captured SQL account for 97.1% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
18,072	18,070	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
18,069	18,068	1.00	0.02	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
18,069	18,070	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
18,068	18,070	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
18,061	0	0.00	0.14	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
18,059	18,059	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
18,058	18,069	1.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
18,058	18,057	1.00	0.12	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
18,058	18,059	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
18,057	18,068	1.00	0.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
18,056	18,059	1.00	0.00	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
18,055	18,058	1.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
11,848	11,849	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
10,753	79,568	7.40	0.01	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
9,076	9,076	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
8,996	8,996	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
8,996	8,996	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
7,316	7,316	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: 65,913
Captured SQL account for 96.8% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
18,067	18,069	27.41	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
18,057	18,061	27.40	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
18,044	18,058	27.38	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
1,842	1,842	2.79	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
1,825	1,825	2.77	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
1,786	1,786	2.71	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
386	386	0.59	2ym6hhaq30r73		select type#, blocks, extents,...
293	293	0.44	bsa0wjtftg3uw		select file# from file$ where ...
230	627	0.35	3c1kubcdjnppq		update sys.col_usage$ set eq...
230	266	0.35	53btfq0dt9bs9		insert into sys.col_usage$ val...

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

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
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
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	16,465	27.14	0.90
CPU used when call started	16,354	26.96	0.90
CR blocks created	3,603	5.94	0.20
Cached Commit SCN referenced	29,709	48.97	1.63
Commit SCN cached	46	0.08	0.00
DB time	650,257	1,071.91	35.59
DBWR checkpoint buffers written	11,130	18.35	0.61
DBWR checkpoints	1	0.00	0.00
DBWR transaction table writes	42	0.07	0.00
DBWR undo block writes	20,632	34.01	1.13
IMU CR rollbacks	3,352	5.53	0.18
IMU Flushes	20,541	33.86	1.12
IMU Redo allocation size	47,979,676	79,091.51	2,626.15
IMU commits	14,352	23.66	0.79
IMU contention	17,937	29.57	0.98
IMU pool not allocated	1,709	2.82	0.09
IMU undo allocation size	92,252,688	152,072.81	5,049.41
IMU- failed to get a private strand	1,709	2.82	0.09
SQL*Net roundtrips to/from client	43,189	71.19	2.36
active txn count during cleanout	5,789	9.54	0.32
application wait time	23,185	38.22	1.27
background checkpoints completed	0	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	1,863	3.07	0.10
buffer is not pinned count	1,257,777	2,073.37	68.84
buffer is pinned count	7,574,559	12,486.19	414.59
bytes received via SQL*Net from client	48,327,458	79,664.80	2,645.18
bytes sent via SQL*Net to client	19,642,215	32,378.97	1,075.11
calls to get snapshot scn: kcmgss	247,316	407.69	13.54
calls to kcmgas	41,448	68.32	2.27
calls to kcmgcs	3,325	5.48	0.18
change write time	542	0.89	0.03
cleanout - number of ktugct calls	5,781	9.53	0.32
cleanouts and rollbacks - consistent read gets	2,220	3.66	0.12
cleanouts only - consistent read gets	194	0.32	0.01
cluster key scan block gets	11,375	18.75	0.62
cluster key scans	9,878	16.28	0.54
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	18,196	29.99	1.00
commit batch/immediate requested	18,196	29.99	1.00
commit cleanout failures: callback failure	27	0.04	0.00
commit cleanout failures: cannot pin	555	0.91	0.03
commit cleanouts	73,693	121.48	4.03
commit cleanouts successfully completed	73,111	120.52	4.00
commit immediate performed	18,196	29.99	1.00
commit immediate requested	18,196	29.99	1.00
commit txn count during cleanout	697	1.15	0.04
concurrency wait time	2,390	3.94	0.13
consistent changes	4,690	7.73	0.26
consistent gets	1,884,508	3,106.49	103.15
consistent gets - examination	1,569,399	2,587.06	85.90
consistent gets from cache	1,884,508	3,106.49	103.15
cursor authentications	193	0.32	0.01
data blocks consistent reads - undo records applied	3,731	6.15	0.20
db block changes	591,212	974.58	32.36
db block gets	563,175	928.36	30.83
db block gets direct	9	0.01	0.00
db block gets from cache	563,166	928.34	30.82
deferred (CURRENT) block cleanout applications	43,033	70.94	2.36
dirty buffers inspected	16,321	26.90	0.89
enqueue conversions	123	0.20	0.01
enqueue releases	175,408	289.15	9.60
enqueue requests	175,416	289.16	9.60
enqueue waits	3,575	5.89	0.20
execute count	304,387	501.76	16.66
frame signature mismatch	11	0.02	0.00
free buffer inspected	60,073	99.03	3.29
free buffer requested	62,956	103.78	3.45
heap block compress	1,907	3.14	0.10
hot buffers moved to head of LRU	29,771	49.08	1.63
immediate (CR) block cleanout applications	2,414	3.98	0.13
immediate (CURRENT) block cleanout applications	20	0.03	0.00
index fetch by key	576,494	950.31	31.55
index scans kdiixs1	53,953	88.94	2.95
leaf node 90-10 splits	4	0.01	0.00
leaf node splits	4	0.01	0.00
lob reads	186	0.31	0.01
lob writes	1	0.00	0.00
lob writes unaligned	1	0.00	0.00
logons cumulative	54	0.09	0.00
messages received	17,454	28.77	0.96
messages sent	17,453	28.77	0.96
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	255,754	421.59	14.00
opened cursors cumulative	53,389	88.01	2.92
parse count (hard)	573	0.94	0.03
parse count (total)	65,913	108.65	3.61
parse time cpu	724	1.19	0.04
parse time elapsed	3,019	4.98	0.17
physical read IO requests	40,424	66.64	2.21
physical read bytes	669,024,256	1,102,844.80	36,618.73
physical read total IO requests	41,317	68.11	2.26
physical read total bytes	683,343,872	1,126,449.80	37,402.51
physical read total multi block requests	84	0.14	0.00
physical reads	40,834	67.31	2.24
physical reads cache	40,834	67.31	2.24
physical reads cache prefetch	410	0.68	0.02
physical reads direct	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	16,420	27.07	0.90
physical write bytes	536,150,016	883,809.90	29,345.92
physical write total IO requests	25,451	41.95	1.39
physical write total bytes	629,816,320	1,038,212.96	34,472.70
physical write total multi block requests	19,013	31.34	1.04
physical writes	32,724	53.94	1.79
physical writes direct	9	0.01	0.00
physical writes from cache	32,715	53.93	1.79
physical writes non checkpoint	27,683	45.63	1.52
pinned buffers inspected	1	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	4	0.01	0.00
process last non-idle time	677	1.12	0.04
recursive calls	592,844	977.27	32.45
recursive cpu usage	10,698	17.63	0.59
redo blocks written	156,940	258.71	8.59
redo buffer allocation retries	43	0.07	0.00
redo entries	174,376	287.45	9.54
redo log space requests	49	0.08	0.00
redo log space wait time	228	0.38	0.01
redo ordering marks	1,023	1.69	0.06
redo size	74,759,736	123,236.77	4,091.94
redo synch time	261,298	430.73	14.30
redo synch writes	43,891	72.35	2.40
redo wastage	2,980,260	4,912.77	163.12
redo write time	55,365	91.27	3.03
redo writer latching time	6	0.01	0.00
redo writes	12,123	19.98	0.66
rollback changes - undo records applied	90,977	149.97	4.98
rollbacks only - consistent read gets	1,387	2.29	0.08
rows fetched via callback	456,431	752.40	24.98
session connect time	0	0.00	0.00
session cursor cache hits	49,709	81.94	2.72
session logical reads	2,447,683	4,034.85	133.97
session pga memory	1,436,624	2,368.19	78.63
session pga memory max	12,267,092	20,221.54	671.43
session uga memory	2,205,824	3,636.16	120.73
session uga memory max	29,390,276	48,448.04	1,608.66
shared hash latch upgrades - no wait	61,008	100.57	3.34
shared hash latch upgrades - wait	45	0.07	0.00
sorts (memory)	4,963	8.18	0.27
sorts (rows)	52,580	86.67	2.88
sql area evicted	235	0.39	0.01
sql area purged	0	0.00	0.00
summed dirty queue length	108,929	179.56	5.96
switch current to new buffer	12	0.02	0.00
table fetch by rowid	4,147,669	6,837.17	227.02
table fetch continued row	138	0.23	0.01
table scan blocks gotten	11,858	19.55	0.65
table scan rows gotten	145,533	239.90	7.97
table scans (short tables)	492	0.81	0.03
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	18,196	29.99	1.00
undo change vector size	20,703,344	34,128.17	1,133.19
user I/O wait time	283,768	467.77	15.53
user calls	85,303	140.62	4.67
user commits	18,270	30.12	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	3,473	5.73	0.19
write clones created in foreground	33	0.05	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	893	1,637
opened cursors current	319	336
logons current	27	28

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.93

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	39,121	64	70.65	1.00	5,741	9	1,197	13.19
UNDOTBS1	0	0	0.00	0.00	10,618	18	43	9.30
SYSTEM	843	1	58.71	1.44	13	0	13	22.31
SYSAUX	450	1	47.47	1.04	145	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	450	1	47.47	1.04	145	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	843	1	58.71	1.44	13	0	13	22.31
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	0	0			10,618	18	43	9.30
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	39,121	64	70.65	1.00	5,741	9	1,197	13.19

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,776	98	2,444,928	40,783	32,656	0	0	1,242

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	20	11616	83846	1105920	1105920
E	0	19	9314	89735	1105920	1105920

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	4.83	541,621
D	136	0.19	8,568	2.35	264,037
D	204	0.28	12,852	1.89	212,380
D	272	0.38	17,136	1.62	181,375
D	340	0.47	21,420	1.43	160,448
D	408	0.57	25,704	1.30	145,741
D	476	0.66	29,988	1.21	135,924
D	544	0.76	34,272	1.13	127,331
D	612	0.85	38,556	1.07	120,525
D	680	0.95	42,840	1.02	114,606
D	716	1.00	45,108	1.00	112,207
D	748	1.04	47,124	0.98	110,225
D	816	1.14	51,408	0.95	106,588
D	884	1.23	55,692	0.92	103,237
D	952	1.33	59,976	0.90	100,499
D	1,020	1.42	64,260	0.87	97,995
D	1,088	1.52	68,544	0.86	96,274
D	1,156	1.61	72,828	0.85	95,309
D	1,224	1.71	77,112	0.84	94,292
D	1,292	1.80	81,396	0.83	93,210
D	1,360	1.90	85,680	0.83	92,702

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	119	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	72	53.19	0.00	0.00	0.00	0.00	21,094
E	103	71	53.89	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	3,281	3,281
64K	128K	1	1
512K	1024K	189	189

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	248.44	4.98	98.00	3
26	0.25	248.44	4.98	98.00	2
52	0.50	248.44	0.00	100.00	0
77	0.75	248.44	0.00	100.00	0
103	1.00	248.44	0.00	100.00	0
124	1.20	248.44	0.00	100.00	0
144	1.40	248.44	0.00	100.00	0
165	1.60	248.44	0.00	100.00	0
185	1.80	248.44	0.00	100.00	0
206	2.00	248.44	0.00	100.00	0
309	3.00	248.44	0.00	100.00	0
412	4.00	248.44	0.00	100.00	0
618	6.00	248.44	0.00	100.00	0
824	8.00	248.44	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
56	0.78	8	942	25,481	0.86	4,185	58.94	335,069
64	0.89	15	1,789	29,593	1.00	73	1.03	335,723
72	1.00	22	2,449	29,595	1.00	71	1.00	335,903
80	1.11	29	3,294	29,595	1.00	71	1.00	335,931
88	1.22	29	3,448	29,595	1.00	71	1.00	335,932
96	1.33	29	3,448	29,595	1.00	71	1.00	335,932
104	1.44	29	3,448	29,595	1.00	71	1.00	335,932
112	1.56	29	3,448	29,595	1.00	71	1.00	335,932
120	1.67	29	3,448	29,595	1.00	71	1.00	335,932
128	1.78	29	3,448	29,595	1.00	71	1.00	335,932
136	1.89	29	3,448	29,595	1.00	71	1.00	335,932
144	2.00	29	3,448	29,595	1.00	71	1.00	335,932

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	27,768	268,704
400	0.50	16,282	163,252
600	0.75	13,944	129,552
800	1.00	12,718	112,147
1,000	1.25	12,049	102,267
1,200	1.50	11,688	96,985
1,400	1.75	11,512	94,360
1,600	2.00	11,518	94,360

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	1,202	16	13
undo header	34	0	11
undo block	9	0	2
1st level bmb	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)	3,569	3,569	3,567	227	63.61
HW-Segment High Water Mark	318	318	3	0	26.67
FB-Format Block	18	18	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	33.08	67,158	0	11	75.1833333333333333333333333333333333333/77.183333333333333333333333333333333333	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 09:47	15,175	30,580	0	11	75	0/0	0/0/0/0/0/0
10-Apr 09:37	17,907	36,578	0	11	77	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AWR Alerted Metric Element list	2,180	0.00		0
Consistent RBA	12,152	0.00		0
FIB s.o chain latch	12	0.00		0
FOB s.o list latch	248	0.00		0
In memory undo latch	350,265	0.50	0.04	36,831	0.00
JS queue state obj latch	3,600	0.00		0
KMG MMAN ready and startup request latch	269	0.00		0
KMG resize request state object freelist	6	0.00		0
KTF sga latch	2	0.00		203	0.00
KWQMN job cache list latch	8	0.00		0
MQL Tracking Latch	0			12	0.00
Memory Management Latch	127	0.79	0.00	266	0.00
OS process	171	0.00		0
OS process allocation	314	0.00		0
OS process: request allocation	106	0.00		0
PL/SQL warning settings	42,201	1.28	0.00	0
SGA IO buffer pool latch	2,241	0.00		2,241	0.00
SQL memory manager latch	1	0.00		184	0.00
SQL memory manager workarea list latch	13,319	0.00		0
Shared B-Tree	22	0.00		0
active checkpoint queue latch	5,389	0.00		0
active service list	1,309	0.00		214	0.00
archive control	4	0.00		0
begin backup scn array	2	0.00		0
buffer pool	7	0.00		0
cache buffer handles	371	0.00		0
cache buffers chains	5,101,342	0.13	0.01	71,923	0.06
cache buffers lru chain	99,652	0.05	0.02	66,877	0.55
cache table scan latch	0			72	0.00
channel handle pool latch	106	0.00		0
channel operations parent latch	2,847	0.00		0
checkpoint queue latch	72,894	0.00	0.00	28,471	0.03
client/application info	276	0.00		0
commit callback allocation	4	0.00		0
compile environment latch	44,636	0.26	0.00	0
dml lock allocation	258,819	1.01	0.01	0
dummy allocation	106	0.00		0
enqueue hash chains	355,491	0.65	0.01	2,720	0.11
enqueues	63,244	0.92	0.02	0
event group latch	53	0.00		0
file cache latch	329	0.00		0
global KZLD latch for mem in SGA	50	0.00		0
hash table column usage latch	296	0.00		50,700	0.00
hash table modification latch	36	0.00		0
job_queue_processes parameter latch	10	0.00		0
kks stats	232	0.00		0
ksuosstats global area	43	0.00		0
ktm global data	2	0.00		0
kwqbsn:qsga	22	0.00		0
lgwr LWN SCN	12,152	0.00		0
library cache	369,994	0.83	0.01	2,522	0.00
library cache load lock	3,128	0.00		37	0.00
library cache lock	99,006	0.36	0.00	0
library cache lock allocation	1,218	0.00		0
library cache pin	174,329	0.87	0.00	0
library cache pin allocation	390	0.00		0
list of block allocation	100	0.00		0
loader state object freelist	2	0.00		0
messages	48,090	0.06	0.03	0
mostly latch-free SCN	12,184	0.02	0.00	0
multiblock read objects	170	0.00		0
ncodef allocation latch	10	0.00		0
object queue header heap	11,142	0.00		332	0.00
object queue header operation	225,926	0.03	0.04	188	0.00
object stats modification	83	0.00		0
parallel query alloc buffer	72	0.00		0
parameter list	177	0.00		0
parameter table allocation management	59	0.00		0
post/wait queue	38,791	0.00	0.00	37,038	0.15
process allocation	106	0.00		53	0.00
process group creation	106	0.00		0
qmn task queue latch	84	0.00		0
redo allocation	109,690	0.04	0.10	174,587	0.34
redo copy	0			174,833	0.17
redo writing	43,105	0.00		0
resmgr group change latch	56	0.00		0
resmgr:actses active list	103	0.00		0
resmgr:actses change group	51	0.00		0
resmgr:free threads list	102	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	374,145	0.08	0.00	1,947	0.00
rules engine aggregate statistics	1	0.00		0
rules engine rule set statistics	2	0.00		0
sequence cache	166	0.00		0
session allocation	309,960	0.61	0.00	0
session idle bit	215,673	0.13	0.01	0
session state list latch	108	0.00		0
session switching	10	0.00		0
session timer	214	0.00		0
shared pool	54,152	0.19	0.04	0
shared pool sim alloc	13	0.00		0
shared pool simulator	53,082	0.00		0
simulator hash latch	146,565	0.00	0.00	0
simulator lru latch	137,220	0.11	0.02	3,725	0.03
slave class	2	0.00		0
slave class create	8	0.00		0
sort extent pool	18	0.00		0
state object free list	2	0.00		0
statistics aggregation	112	0.00		0
threshold alerts latch	37	0.00		0
trace latch	1	0.00		0
transaction allocation	94	0.00		0
transaction branch allocation	10	0.00		0
undo global data	234,257	0.23	0.00	0
user lock	200	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	5,101,342	6,748	97	6,651
library cache	369,994	3,072	22	3,050
dml lock allocation	258,819	2,605	23	2,582
enqueue hash chains	355,491	2,320	15	2,305
session allocation	309,960	1,879	8	1,871
In memory undo latch	350,265	1,766	72	1,694
enqueues	63,244	583	10	573
session idle bit	215,673	271	3	268
simulator lru latch	137,220	153	3	150
shared pool	54,152	103	4	99
object queue header operation	225,926	67	3	64
cache buffers lru chain	99,652	47	1	46
redo allocation	109,690	42	4	38
messages	48,090	30	1	29

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	33	55
In memory undo latch	ktichg: child	16	3
In memory undo latch	ktiTxnPoolFree	10	0
In memory undo latch	kticmt: child	10	1
In memory undo latch	kturbk	3	13
cache buffers chains	kcbgtcr: fast path	118	83
cache buffers chains	kcbchg: kslbegin: bufs not pinned	20	28
cache buffers chains	kcbgcur: kslbegin	14	27
cache buffers chains	kcbgtcr: kslbegin shared	8	2
cache buffers chains	kcbgtcr: kslbegin excl	6	12
cache buffers chains	kcbnew: new latch again	6	0
cache buffers chains	kcbzgb: scan from tail. nowait	5	0
cache buffers chains	kcbnlc	2	8
cache buffers chains	kcbzwb	2	2
cache buffers chains	kcb_pre_apply: kcbhq61	1	5
cache buffers chains	kcbbxsv	1	1
cache buffers chains	kcbcge	1	1
cache buffers chains	kcbchg: kslbegin: call CR func	1	18
cache buffers chains	kcbrls: kslbegin	1	9
cache buffers lru chain	kcbzgws	1	1
dml lock allocation	ktaiam	17	22
dml lock allocation	ktaidm	6	1
enqueue hash chains	ksqgtl3	9	12
enqueue hash chains	ksqrcl	6	3
enqueues	ksqies	8	8
enqueues	ksqdel	1	0
enqueues	ksqgtl2	1	0
library cache	kglpnp: child	10	19
library cache	kglLockCursor	5	0
library cache	kglobpn: child:	2	0
library cache	kglpndl: child: after processing	2	0
library cache	kglhdgn: child:	1	1
library cache	kglobld	1	0
messages	ksaamb: after wakeup	1	1
object queue header operation	kcbo_switch_cq	1	3
object queue header operation	kcbo_switch_mq_bg	1	0
object queue header operation	kcbw_link_q	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	4	0
session allocation	ksucri	3	8
session allocation	ksuxds: not user session	3	0
session allocation	ksuprc	2	1
session idle bit	ksuxds	2	0
session idle bit	ksupuc: clear busy	1	2
shared pool	kghalo	2	1
shared pool	kghalp	1	0
shared pool	kghfre	1	0
shared pool	kghfrunp: clatch: nowait	1	0
simulator lru latch	kcbs_simulate: simulate set	3	3

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: 2,447,683
Captured Segments account for 84.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	728,672	29.77
TPCC	USERS	STOCK	TABLE	363,680	14.86
TPCC	USERS	CUSTOMER_I2	INDEX	148,848	6.08
TPCC	USERS	CUSTOMER	TABLE	141,984	5.80
TPCC	USERS	CUSTOMER_I1	INDEX	110,352	4.51

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 40,834
Captured Segments account for 97.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	ITEM_ID	INDEX	17,873	43.77
TPCC	USERS	ITEM	TABLE	10,183	24.94
TPCC	USERS	CUSTOMER	TABLE	4,775	11.69
TPCC	USERS	STOCK	TABLE	4,384	10.74
TPCC	USERS	ORDERS	TABLE	989	2.42

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	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
TPCC	USERS	WAREHOUSE		TABLE	3,706	51.93
TPCC	USERS	DISTRICT		TABLE	3,430	48.07

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	ORDERS	TABLE	786	68.11
TPCC	USERS	WAREHOUSE	TABLE	267	23.14
TPCC	USERS	HISTORY	TABLE	56	4.85
TPCC	USERS	DISTRICT	TABLE	45	3.90

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	14	0.00	2	1
dc_files	4	100.00	0	0
dc_global_oids	43	39.53	0	0
dc_histogram_data	5,981	18.07	0	474
dc_histogram_defs	7,174	36.73	0	555
dc_object_grants	58	31.03	0	6
dc_object_ids	4,709	7.96	0	165
dc_objects	1,935	22.58	0	163
dc_profiles	50	0.00	0	1
dc_rollback_segments	109	0.00	0	23
dc_segments	970	37.84	3	136
dc_sequences	5	100.00	5	0
dc_tablespaces	97,867	0.00	0	5
dc_usernames	256	0.78	0	4
dc_users	8,076	0.00	0	15
outstanding_alerts	13	84.62	1	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	6	33.33	20,174	0.07	7
CLUSTER	52	1.92	134	2.24	2
INDEX	19	100.00	25	76.00	0
SQL AREA	333	39.94	351,047	0.45	401
TABLE/PROCEDURE	1,302	21.81	67,194	2.21	512

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	45.09		1.61	3.99	22	22	28	28
	Freeable	5.75	0.00	0.82	0.32	1		7	7
	SQL	1.25	0.50	0.06	0.02	0	3	22	21
	PL/SQL	1.24	0.39	0.04	0.05	0	0	28	28
E	Other	44.33		1.64	4.06	22	22	27	27
	Freeable	7.13	0.00	0.89	0.36	1		8	8
	SQL	1.25	0.52	0.06	0.02	0	8	21	20
	PL/SQL	1.13	0.43	0.04	0.05	0	0	27	27

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	746,586,112
Fixed Size	1,263,572
Redo Buffers	7,122,944
Variable Size	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.73		-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		2.75
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	12.57	13.17	4.70
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kks stbkt	0.88	0.88	0.00
shared	library cache	2.83	2.88	1.67
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.07	2.43	17.30
	buffer_cache	712.00	712.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.15	Recursive Call %:	87.42
Rollback per transaction %:	0.00	Rows per Sort:	10.59

Buffer Nowait %:	99.95	Redo NoWait %:	99.97
Buffer Hit %:	98.33	In-memory Sort %:	100.00
Library Hit %:	99.29	Soft Parse %:	99.13
Execute to Parse %:	78.35	Latch Hit %:	99.75
Parse CPU to Parse Elapsd %:	23.98	% Non-Parse CPU:	95.78