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: 365 10-Apr-06 12:50:03 31 11.0

End Snap: 366 10-Apr-06 13:00:12 31 11.1

Elapsed: 10.15 (mins)

DB Time: 84.61 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	365	10-Apr-06 12:50:03	31	11.0
End Snap:	366	10-Apr-06 13:00:12	31	11.1
Elapsed:		10.15 (mins)
DB Time:		84.61 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 633,235.46 4,086.99

Logical reads: 20,277.09 130.87

Block changes: 5,005.29 32.30

Physical reads: 317.77 2.05

Physical writes: 216.99 1.40

User calls: 717.67 4.63

Parses: 535.93 3.46

Hard parses: 0.92 0.01

Sorts: 21.39 0.14

Logons: 0.37 0.00

Executes: 2,513.17 16.22

Transactions: 154.94

	Per Second	Per Transaction
Redo size:	633,235.46	4,086.99
Logical reads:	20,277.09	130.87
Block changes:	5,005.29	32.30
Physical reads:	317.77	2.05
Physical writes:	216.99	1.40
User calls:	717.67	4.63
Parses:	535.93	3.46
Hard parses:	0.92	0.01
Sorts:	21.39	0.14
Logons:	0.37	0.00
Executes:	2,513.17	16.22
Transactions:	154.94

% Blocks changed per Read: 24.68 Recursive Call %: 84.93

Rollback per transaction %: 0.00 Rows per Sort: 10.37

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.87 Soft Parse %: 99.83

Execute to Parse %: 78.68 Latch Hit %: 99.76

Parse CPU to Parse Elapsd %: 49.72 % Non-Parse CPU: 97.82

Shared Pool Statistics

Begin End

Memory Usage %: 83.40 81.54

% SQL with executions>1: 83.94 67.24

% Memory for SQL w/exec>1: 82.69 75.78

	Begin	End
Memory Usage %:	83.40	81.54
% SQL with executions>1:	83.94	67.24
% Memory for SQL w/exec>1:	82.69	75.78

Top 5 Timed Events

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

db file sequential read 193,234 3,325 17 65.5 User I/O

CPU time 1,219 24.0

log file sync 119,419 449 4 8.9 Commit

enq: TX - row lock contention 11,705 194 17 3.8 Application

SQL*Net break/reset to client 188,704 153 1 3.0 Application

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
db file sequential read	193,234	3,325	17	65.5	User I/O
CPU time		1,219		24.0
log file sync	119,419	449	4	8.9	Commit
enq: TX - row lock contention	11,705	194	17	3.8	Application
SQL*Net break/reset to client	188,704	153	1	3.0	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): 5076.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	4,426.89	87.21
DB CPU	1,219.25	24.02
PL/SQL execution elapsed time	151.22	2.98
parse time elapsed	53.03	1.04
hard parse elapsed time	19.83	0.39
PL/SQL compilation elapsed time	4.30	0.08
connection management call elapsed time	2.92	0.06
repeated bind elapsed time	1.52	0.03
hard parse (sharing criteria) elapsed time	0.41	0.01
sequence load elapsed time	0.04	0.00
DB time	5,076.32
background elapsed time	513.49
background cpu time	120.85

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	193,737	0.00	3,333	17	2.05
Commit	119,419	0.00	449	4	1.27
Application	200,409	0.00	347	2	2.12
Concurrency	11,206	0.85	29	3	0.12
Configuration	196	0.00	11	56	0.00
System I/O	144,658	0.00	11	0	1.53
Other	7,523	0.01	7	1	0.08
Network	220,038	0.00	3	0	2.33

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	193,234	0.00	3,325	17	2.05
log file sync	119,419	0.00	449	4	1.27
enq: TX - row lock contention	11,705	0.00	194	17	0.12
SQL*Net break/reset to client	188,704	0.00	153	1	2.00
buffer busy waits	8,978	0.00	21	2	0.10
log file switch completion	66	0.00	10	157	0.00
read by other session	446	0.00	8	17	0.00
log file parallel write	137,253	0.00	5	0	1.45
control file parallel write	347	0.00	4	12	0.00
latch: library cache	389	0.00	3	7	0.00
SQL*Net message to client	220,005	0.00	3	0	2.33
latch: In memory undo latch	991	0.00	2	2	0.01
LGWR wait for redo copy	4,437	0.02	2	0	0.05
latch: enqueue hash chains	629	0.00	2	2	0.01
rdbms ipc reply	1,117	0.00	1	1	0.01
cursor: pin S wait on X	96	98.96	1	12	0.00
latch: cache buffers chains	530	0.00	1	2	0.01
control file sequential read	1,103	0.00	1	1	0.01
latch free	376	0.00	1	2	0.00
enq: HW - contention	125	0.00	1	5	0.00
db file scattered read	13	0.00	1	46	0.00
enq: TX - contention	11	0.00	1	49	0.00
db file parallel write	5,939	0.00	0	0	0.06
latch: shared pool	35	0.00	0	9	0.00
enq: US - contention	190	0.00	0	2	0.00
latch: redo allocation	257	0.00	0	1	0.00
latch: row cache objects	85	0.00	0	3	0.00
latch: session allocation	69	0.00	0	3	0.00
latch: library cache pin	90	0.00	0	2	0.00
cursor: pin S	319	0.00	0	1	0.00
os thread startup	2	0.00	0	60	0.00
latch: messages	26	0.00	0	3	0.00
latch: undo global data	31	0.00	0	2	0.00
enq: FB - contention	18	0.00	0	3	0.00
latch: object queue header operation	31	0.00	0	2	0.00
log file sequential read	8	0.00	0	5	0.00
log file single write	8	0.00	0	5	0.00
latch: cache buffers lru chain	10	0.00	0	2	0.00
latch: library cache lock	10	0.00	0	2	0.00
latch: cache buffer handles	1	0.00	0	8	0.00
latch: checkpoint queue latch	1	0.00	0	5	0.00
SQL*Net more data to client	15	0.00	0	0	0.00
latch: redo writing	5	0.00	0	0	0.00
SQL*Net more data from client	18	0.00	0	0	0.00
direct path write	24	0.00	0	0	0.00
direct path read	20	0.00	0	0	0.00
SQL*Net message from client	220,004	0.00	1,113	5	2.33
Streams AQ: qmn slave idle wait	22	0.00	594	27023	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	594	13511	0.00
Streams AQ: waiting for messages in the queue	122	99.18	591	4844	0.00
Streams AQ: waiting for time management or cleanup tasks	1	0.00	430	430092	0.00
class slave wait	1	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
db file sequential read	296	0.00	9	31	0.00
log file parallel write	137,279	0.00	5	0	1.45
control file parallel write	347	0.00	4	12	0.00
events in waitclass Other	4,713	0.02	2	0	0.05
control file sequential read	212	0.00	1	3	0.00
db file parallel write	5,920	0.00	0	0	0.06
os thread startup	2	0.00	0	60	0.00
db file scattered read	2	0.00	0	39	0.00
log file sequential read	8	0.00	0	5	0.00
log file single write	8	0.00	0	5	0.00
latch: cache buffers chains	8	0.00	0	2	0.00
log file sync	1	0.00	0	6	0.00
latch: redo writing	5	0.00	0	0	0.00
direct path read	20	0.00	0	0	0.00
direct path write	22	0.00	-0	-1	0.00
rdbms ipc message	121,858	1.39	4,292	35	1.29
Streams AQ: qmn slave idle wait	22	0.00	594	27023	0.00
Streams AQ: qmn coordinator idle wait	44	50.00	594	13511	0.00
pmon timer	275	100.00	593	2157	0.00
Streams AQ: waiting for time management or cleanup tasks	1	0.00	430	430092	0.00
smon timer	2	50.00	367	183718	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	131,511
IDLE_TIME	111,917
IOWAIT_TIME	91,996
NICE_TIME	0
SYS_TIME	31,096
USER_TIME	94,824
LOAD	10
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	32,576
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,049.80	1,215.80	191,260	12,308,952
SYS$USERS	26.80	4.50	700	9,983
SYS$BACKGROUND	0.00	0.00	1,295	31,818

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	191671	327513	11177	2877	218950	249
SYS$USERS	683	1909	4	6	326	1
SYS$BACKGROUND	1295	3635	15	17	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,996	364	93,971	0.03	59.03	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
2,546	205	93,980	0.03	50.15	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
764	418	94,016	0.01	15.04	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
520	64	9,449	0.05	10.23	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
509	55	9,448	0.05	10.04	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
182	50	56,405	0.00	3.58	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
121	48	93,964	0.00	2.39	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
108	35	93,962	0.00	2.13	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
101	56	94,014	0.00	1.99	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
99	60	9,428	0.01	1.95	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
85	24	94,014	0.00	1.68	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
59	41	9,428	0.01	1.17	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
51	46	93,979	0.00	1.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...

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
418	764	94,016	0.00	15.04	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
364	2,996	93,971	0.00	59.03	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
205	2,546	93,980	0.00	50.15	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
64	520	9,449	0.01	10.23	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
60	99	9,428	0.01	1.95	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
56	101	94,014	0.00	1.99	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
55	509	9,448	0.01	10.04	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
50	182	56,405	0.00	3.58	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
48	121	93,964	0.00	2.39	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
46	51	93,979	0.00	1.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
41	59	9,428	0.00	1.17	csv0xdm9c394t	wish8.4@sles10b8 (TNS V1-V3)	SELECT O_ID, O_CARRIER_ID, O...
35	108	93,962	0.00	2.13	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
24	85	94,014	0.00	1.68	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: 12,351,102
Captured SQL account for 89.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
5,695,114	9,449	602.72	46.11	63.71	519.55	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
5,675,914	9,448	600.75	45.95	54.80	509.48	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
2,845,347	94,016	30.26	23.04	418.31	763.69	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
2,212,731	93,971	23.55	17.92	364.41	2996.31	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
943,837	56,405	16.73	7.64	49.80	181.88	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
660,523	93,980	7.03	5.35	204.71	2545.57	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
476,672	93,962	5.07	3.86	35.42	107.98	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
470,565	93,979	5.01	3.81	45.86	50.83	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
421,062	94,014	4.48	3.41	55.76	101.07	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
417,059	93,964	4.44	3.38	48.00	121.20	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
255,334	9,428	27.08	2.07	59.77	98.78	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
193,622	94,014	2.06	1.57	24.15	85.44	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
190,819	94,008	2.03	1.54	14.65	14.70	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
188,624	62,036	3.04	1.53	15.83	25.73	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
188,042	94,015	2.00	1.52	11.84	11.87	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
187,960	93,982	2.00	1.52	19.38	20.36	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
142,335	47,446	3.00	1.15	11.49	12.62	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
139,725	46,574	3.00	1.13	6.27	6.39	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
139,719	46,574	3.00	1.13	12.34	13.36	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
134,598	9,428	14.28	1.09	40.64	59.38	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: 193,559
Captured SQL account for 99.1% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
149,675	93,971	1.59	77.33	364.41	2996.31	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
142,670	93,980	1.52	73.71	204.71	2545.57	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
21,950	9,448	2.32	11.34	54.80	509.48	13dn4hkrzfpdy	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(DISTINCT (S_I_ID)...
21,950	9,449	2.32	11.34	63.71	519.55	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
16,945	94,016	0.18	8.75	418.31	763.69	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
12,777	56,405	0.23	6.60	49.80	181.88	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
6,831	93,962	0.07	3.53	35.42	107.98	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
3,090	37,609	0.08	1.60	10.90	44.05	2k7k32av19mqz	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
2,371	9,428	0.25	1.22	59.77	98.78	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
1,148	5,638	0.20	0.59	4.39	16.76	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: 1,530,812
Captured SQL account for 99.1% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
94,016	94,015	1.00	0.01	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
94,015	94,021	1.00	0.00	g1r3tpjj3b2gh	wish8.4@sles10b8 (TNS V1-V3)	SELECT D_STREET_1, D_STREET_2...
94,014	94,016	1.00	0.00	69gxtaqr1vk8j	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_YTD = D_...
94,014	94,014	1.00	0.00	g5u7xuchhfu62	wish8.4@sles10b8 (TNS V1-V3)	UPDATE WAREHOUSE SET W_YTD = W...
94,012	94,019	1.00	0.00	5xm451a80drbc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO HISTORY (H_C_D_ID,...
94,008	94,020	1.00	0.00	4r83hzuhh3yuv	wish8.4@sles10b8 (TNS V1-V3)	SELECT W_STREET_1, W_STREET_2...
93,982	93,984	1.00	0.00	80ajya2tnyfg2	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO NEW_ORDER (NO_O_ID...
93,980	93,977	1.00	0.03	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
93,979	93,984	1.00	0.00	gwcvcq87cn4sc	wish8.4@sles10b8 (TNS V1-V3)	INSERT INTO ORDERS (O_ID, O_D...
93,971	0	0.00	0.03	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
93,964	93,974	1.00	0.00	bswc46zum45tj	wish8.4@sles10b8 (TNS V1-V3)	UPDATE DISTRICT SET D_NEXT_O_I...
93,962	93,982	1.00	0.00	5mz8u3b34u9gw	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DISCOUNT, C_LAST, C...
62,036	62,047	1.00	0.00	7m5h0wf6stq0q	wish8.4@sles10b8 (TNS V1-V3)	SELECT COUNT(C_ID) FROM CUSTOM...
56,405	412,614	7.32	0.00	4wg725nwpxb1z	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_FIRST, C_MIDDLE, C_...
47,446	47,446	1.00	0.00	95yr4xtfr50hx	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
46,574	46,575	1.00	0.00	1bn3cfn6n3xv5	wish8.4@sles10b8 (TNS V1-V3)	SELECT C_DATA FROM CUSTOMER WH...
46,574	46,574	1.00	0.00	c90b8j61ndux8	wish8.4@sles10b8 (TNS V1-V3)	UPDATE CUSTOMER SET C_BALANCE ...
37,609	37,613	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: 326,445
Captured SQL account for 98.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
93,998	94,016	28.79	aw9ttz9acxbc3	wish8.4@sles10b8 (TNS V1-V3)	BEGIN payment(:p_w_id, :p_d_id...
93,965	93,980	28.78	88fgqncchy6wg	wish8.4@sles10b8 (TNS V1-V3)	SELECT I_PRICE, I_NAME, I_DA...
93,955	93,971	28.78	16dhat4ta7xs9	wish8.4@sles10b8 (TNS V1-V3)	begin neword(:no_w_id, :no_max...
9,448	9,449	2.89	5hyh0360hgx2u	wish8.4@sles10b8 (TNS V1-V3)	BEGIN slev(:st_w_id, :st_d_id,...
9,437	9,437	2.89	d4ujh5yqt1fph	wish8.4@sles10b8 (TNS V1-V3)	BEGIN delivery(:d_w_id, :d_o_c...
9,428	9,428	2.89	gcvvtwcxafqp5	wish8.4@sles10b8 (TNS V1-V3)	BEGIN ostat(:os_w_id, :os_d_id...
2,116	2,117	0.65	bsa0wjtftg3uw		select file# from file$ where ...
1,241	1,242	0.38	86708bvah4akq		select name from undo$ where f...
451	451	0.14	2ym6hhaq30r73		select type#, blocks, extents,...
440	440	0.13	0h6b2sajwb74n		select privilege#, level from ...

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

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

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
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
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	104,257	171.16	1.10
CPU used when call started	104,154	170.99	1.10
CR blocks created	13,052	21.43	0.14
Cached Commit SCN referenced	105,933	173.91	1.12
Commit SCN cached	220	0.36	0.00
DB time	582,010	955.50	6.17
DBWR checkpoint buffers written	21,930	36.00	0.23
DBWR checkpoints	4	0.01	0.00
DBWR transaction table writes	45	0.07	0.00
DBWR undo block writes	94,445	155.05	1.00
IMU CR rollbacks	12,149	19.95	0.13
IMU Flushes	103,054	169.19	1.09
IMU Redo allocation size	242,468,528	398,066.26	2,569.18
IMU commits	79,181	129.99	0.84
IMU contention	89,656	147.19	0.95
IMU pool not allocated	6,625	10.88	0.07
IMU undo allocation size	486,644,392	798,935.49	5,156.44
IMU- failed to get a private strand	6,625	10.88	0.07
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SQL*Net roundtrips to/from client	219,367	360.14	2.32
active txn count during cleanout	21,266	34.91	0.23
application wait time	34,681	56.94	0.37
auto extends on undo tablespace	10	0.02	0.00
background checkpoints completed	5	0.01	0.00
background checkpoints started	4	0.01	0.00
background timeouts	1,933	3.17	0.02
buffer is not pinned count	6,419,503	10,539.05	68.02
buffer is pinned count	58,612,511	96,225.53	621.05
bytes received via SQL*Net from client	249,279,238	409,247.56	2,641.34
bytes sent via SQL*Net to client	94,893,559	155,788.98	1,005.48
calls to get snapshot scn: kcmgss	1,238,100	2,032.62	13.12
calls to kcmgas	207,121	340.04	2.19
calls to kcmgcs	8,490	13.94	0.09
change write time	4,904	8.05	0.05
cleanout - number of ktugct calls	22,222	36.48	0.24
cleanouts and rollbacks - consistent read gets	8,907	14.62	0.09
cleanouts only - consistent read gets	819	1.34	0.01
cluster key scan block gets	3,293	5.41	0.03
cluster key scans	2,483	4.08	0.03
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	94,362	154.92	1.00
commit batch/immediate requested	94,362	154.92	1.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	1	0.00	0.00
commit cleanout failures: callback failure	387	0.64	0.00
commit cleanout failures: cannot pin	2,210	3.63	0.02
commit cleanouts	377,702	620.08	4.00
commit cleanouts successfully completed	375,104	615.82	3.97
commit immediate performed	94,362	154.92	1.00
commit immediate requested	94,362	154.92	1.00
commit txn count during cleanout	3,126	5.13	0.03
concurrency wait time	2,900	4.76	0.03
consistent changes	18,039	29.62	0.19
consistent gets	9,396,191	15,425.95	99.56
consistent gets - examination	7,852,590	12,891.78	83.21
consistent gets from cache	9,396,191	15,425.95	99.56
cursor authentications	85	0.14	0.00
data blocks consistent reads - undo records applied	13,336	21.89	0.14
db block changes	3,048,802	5,005.29	32.30
db block gets	2,954,916	4,851.15	31.31
db block gets direct	8	0.01	0.00
db block gets from cache	2,954,908	4,851.14	31.31
deferred (CURRENT) block cleanout applications	223,216	366.46	2.37
dirty buffers inspected	101,288	166.29	1.07
drop segment calls in space pressure	703	1.15	0.01
enqueue conversions	20,891	34.30	0.22
enqueue releases	940,746	1,544.44	9.97
enqueue requests	940,739	1,544.43	9.97
enqueue timeouts	0	0.00	0.00
enqueue waits	11,848	19.45	0.13
execute count	1,530,812	2,513.17	16.22
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	297,831	488.96	3.16
free buffer requested	302,282	496.26	3.20
global undo segment hints helped	22	0.04	0.00
global undo segment hints were stale	6	0.01	0.00
heap block compress	8,728	14.33	0.09
hot buffers moved to head of LRU	179,931	295.40	1.91
immediate (CR) block cleanout applications	9,726	15.97	0.10
immediate (CURRENT) block cleanout applications	24	0.04	0.00
index fetch by key	2,737,858	4,494.81	29.01
index scans kdiixs1	254,528	417.86	2.70
leaf node 90-10 splits	6	0.01	0.00
leaf node splits	8	0.01	0.00
lob reads	254	0.42	0.00
lob writes	145	0.24	0.00
lob writes unaligned	145	0.24	0.00
local undo segment hints helped	52	0.09	0.00
local undo segment hints were stale	111	0.18	0.00
logons cumulative	227	0.37	0.00
messages received	144,617	237.42	1.53
messages sent	144,616	237.42	1.53
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	1,261,697	2,071.36	13.37
opened cursors cumulative	237,291	389.57	2.51
parse count (hard)	560	0.92	0.01
parse count (total)	326,445	535.93	3.46
parse time cpu	2,664	4.37	0.03
parse time elapsed	5,358	8.80	0.06
physical read IO requests	193,518	317.70	2.05
physical read bytes	3,171,270,656	5,206,349.29	33,602.51
physical read total IO requests	194,632	319.53	2.06
physical read total bytes	3,189,395,456	5,236,105.20	33,794.56
physical read total multi block requests	13	0.02	0.00
physical reads	193,559	317.77	2.05
physical reads cache	193,539	317.74	2.05
physical reads cache prefetch	41	0.07	0.00
physical reads direct	20	0.03	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	83,660	137.35	0.89
physical write bytes	2,165,555,200	3,555,242.68	22,946.04
physical write total IO requests	184,117	302.27	1.95
physical write total bytes	2,614,122,496	4,291,666.11	27,699.02
physical write total multi block requests	158,844	260.78	1.68
physical writes	132,175	216.99	1.40
physical writes direct	28	0.05	0.00
physical writes from cache	132,147	216.95	1.40
physical writes non checkpoint	113,626	186.54	1.20
pinned buffers inspected	4	0.01	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	612	1.00	0.01
recovery blocks read	0	0.00	0.00
recursive calls	2,464,463	4,045.97	26.11
recursive cpu usage	66,435	109.07	0.70
redo blocks read for recovery	0	0.00	0.00
redo blocks written	842,769	1,383.59	8.93
redo buffer allocation retries	50	0.08	0.00
redo entries	862,631	1,416.20	9.14
redo log space requests	72	0.12	0.00
redo log space wait time	1,063	1.75	0.01
redo ordering marks	4,281	7.03	0.05
redo size	385,713,852	633,235.46	4,086.99
redo synch time	46,563	76.44	0.49
redo synch writes	227,636	373.72	2.41
redo wastage	31,097,472	51,053.45	329.51
redo write time	24,193	39.72	0.26
redo writer latching time	224	0.37	0.00
redo writes	137,298	225.41	1.45
rollback changes - undo records applied	471,807	774.58	5.00
rollbacks only - consistent read gets	4,136	6.79	0.04
rows fetched via callback	2,357,516	3,870.39	24.98
session connect time	0	0.00	0.00
session cursor cache hits	227,908	374.16	2.41
session logical reads	12,351,102	20,277.09	130.87
session uga memory	6,159,492	10,112.18	65.27
session uga memory max	99,075,420	162,654.44	1,049.79
shared hash latch upgrades - no wait	289,157	474.72	3.06
shared hash latch upgrades - wait	65	0.11	0.00
sorts (memory)	13,028	21.39	0.14
sorts (rows)	135,124	221.84	1.43
space was found by tune down	693	1.14	0.01
space was not found by tune down	5	0.01	0.00
sql area evicted	217	0.36	0.00
sql area purged	0	0.00	0.00
steps of tune down ret. in space pressure	706	1.16	0.01
summed dirty queue length	238,541	391.62	2.53
switch current to new buffer	35	0.06	0.00
table fetch by rowid	31,378,784	51,515.28	332.49
table fetch continued row	174	0.29	0.00
table scan blocks gotten	47,497	77.98	0.50
table scan rows gotten	101,172	166.10	1.07
table scans (short tables)	4,603	7.56	0.05
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	94,362	154.92	1.00
tune down retentions in space pressure	698	1.15	0.01
undo change vector size	106,357,692	174,609.91	1,126.96
user I/O wait time	333,357	547.28	3.53
user calls	437,147	717.67	4.63
user commits	94,376	154.94	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	10,335	16.97	0.11
write clones created in foreground	49	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	4,919	7,626
opened cursors current	341	344
logons current	31	31

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)	4	23.64

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	191,336	314	17.09	1.00	18,317	30	8,861	3.23
UNDOTBS1	5	0	132.00	1.00	65,003	107	629	2.18
SYSTEM	1,362	2	24.73	1.01	15	0	0	0.00
SYSAUX	585	1	40.12	1.04	251	0	0	0.00
TEMP	2	0	75.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	585	1	40.12	1.04	251	0	0	0.00
SYSTEM	/u02/app/oracle/oradata/TESTIBM/system01.dbf	1,362	2	24.73	1.01	15	0	0	0.00
TEMP	/u02/app/oracle/oradata/TESTIBM/temp01.dbf	2	0	75.00	1.00	0	0	0
UNDOTBS1	/u02/app/oracle/oradata/TESTIBM/undotbs01.dbf	5	0	132.00	1.00	65,003	107	629	2.18
USERS	/u02/app/oracle/oradata/TESTIBM/users01.dbf	191,336	314	17.09	1.00	18,317	30	8,861	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,553	98	12,352,467	193,470	132,385	0	0	9,400

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	36	13111	418198	1290240	1290240
E	0	36	13654	425575	1290240	1290240

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.50	3,002,488
D	136	0.19	8,568	2.78	1,517,251
D	204	0.29	12,852	2.19	1,195,803
D	272	0.38	17,136	1.84	1,003,623
D	340	0.48	21,420	1.60	872,846
D	408	0.58	25,704	1.43	778,449
D	476	0.67	29,988	1.30	707,986
D	544	0.77	34,272	1.19	650,589
D	612	0.86	38,556	1.10	602,741
D	680	0.96	42,840	1.03	561,217
D	708	1.00	44,604	1.00	546,153
D	748	1.06	47,124	0.96	526,295
D	816	1.15	51,408	0.91	496,487
D	884	1.25	55,692	0.86	471,754
D	952	1.34	59,976	0.82	450,238
D	1,020	1.44	64,260	0.79	431,358
D	1,088	1.54	68,544	0.76	416,365
D	1,156	1.63	72,828	0.74	402,290
D	1,224	1.73	77,112	0.71	389,454
D	1,292	1.82	81,396	0.70	380,284
D	1,360	1.92	85,680	0.68	372,183

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	53	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	70	58.54	0.00	0.00	0.00	0.00	21,094
E	103	70	57.38	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	10,280	10,280
64K	128K	3	3
512K	1024K	50	50

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	157.68	21.97	88.00	8
26	0.25	157.68	21.97	88.00	7
52	0.50	157.68	0.00	100.00	0
77	0.75	157.68	0.00	100.00	0
103	1.00	157.68	0.00	100.00	0
124	1.20	157.68	0.00	100.00	0
144	1.40	157.68	0.00	100.00	0
165	1.60	157.68	0.00	100.00	0
185	1.80	157.68	0.00	100.00	0
206	2.00	157.68	0.00	100.00	0
309	3.00	157.68	0.00	100.00	0
412	4.00	157.68	0.00	100.00	0
618	6.00	157.68	0.00	100.00	0
824	8.00	157.68	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
52	0.68	8	1,035	253,204	1.00	238	1.26	1,948,217
60	0.79	15	1,666	253,234	1.00	208	1.10	1,949,266
68	0.89	22	2,476	253,249	1.00	193	1.02	1,949,923
76	1.00	29	3,097	253,253	1.00	189	1.00	1,950,008
84	1.11	36	4,003	253,253	1.00	189	1.00	1,950,015
92	1.21	36	4,003	253,253	1.00	189	1.00	1,950,015
100	1.32	36	4,003	253,253	1.00	189	1.00	1,950,015
108	1.42	36	4,003	253,253	1.00	189	1.00	1,950,015
116	1.53	36	4,003	253,253	1.00	189	1.00	1,950,015
124	1.63	36	4,003	253,253	1.00	189	1.00	1,950,015
132	1.74	36	4,003	253,253	1.00	189	1.00	1,950,015
140	1.84	36	4,003	253,253	1.00	189	1.00	1,950,015
148	1.95	36	4,003	253,253	1.00	189	1.00	1,950,015
156	2.05	36	4,003	253,253	1.00	189	1.00	1,950,015

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	31,788	1,567,034
400	0.50	20,408	901,572
600	0.75	16,490	671,764
800	1.00	14,268	543,279
1,000	1.25	12,950	464,830
1,200	1.50	12,117	415,500
1,400	1.75	11,590	384,370
1,600	2.00	11,598	384,370

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	8,827	29	3
file header block	202	1	3
undo header	355	1	2
undo block	18	0	0
1st level bmb	12	0	0
2nd level bmb	5	0	0
segment header	5	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)	11,572	11,570	11,566	199	17.23
HW-Segment High Water Mark	45,581	45,581	108	1	6.67
TX-Transaction	191,590	191,295	11	1	49.09
US-Undo Segment	21,367	21,367	185	0	1.51
FB-Format Block	96	96	18	0	4.44

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	93.40	190,007	0	12	11.8833333333333333333333333333333333333/11.883333333333333333333333333333333333	0/0	10/0/64/1641/101604/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 12:59	93,399	190,007	0	12	12	0/0	10/0/64/1641/101604/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	2,344	0.00		0	0
Consistent RBA	137,285	0.02	0.17	0	0
FOB s.o list latch	944	0.00		0	0
In memory undo latch	1,820,907	0.73	0.07	2	188,857	0.00
JS queue state obj latch	3,660	0.00		0	0
KMG MMAN ready and startup request latch	203	0.00		0	0
KTF sga latch	1	0.00		0	205	0.00
KWQMN job cache list latch	3	0.00		0	0
MQL Tracking Latch	0			0	12	0.00
Memory Management Latch	0			0	203	0.00
OS process	690	0.00		0	0
OS process allocation	663	0.00		0	0
OS process: request allocation	452	0.00		0	0
PL/SQL warning settings	217,370	0.53	0.00	0	0
SGA IO buffer pool latch	10,554	0.00		0	10,533	0.00
SQL memory manager latch	1	0.00		0	202	0.00
SQL memory manager workarea list latch	14,393	0.00		0	0
Shared B-Tree	23	0.00		0	0
Undo Hint Latch	0			0	2,203	0.00
active checkpoint queue latch	6,455	0.00		0	0
active service list	2,260	0.00		0	275	0.00
archive control	6	0.00		0	0
begin backup scn array	2	0.00		0	0
cache buffer handles	1,635	0.37	0.17	0	0
cache buffers chains	25,875,555	0.10	0.02	1	299,776	0.06
cache buffers lru chain	399,208	0.18	0.01	0	312,417	0.83
cache table scan latch	0			0	13	0.00
channel handle pool latch	454	0.00		0	0
channel operations parent latch	8,052	0.00		0	0
checkpoint queue latch	193,206	0.01	0.07	0	125,505	0.04
client/application info	1,132	0.00		0	0
commit callback allocation	4	0.00		0	0
compile environment latch	229,507	0.20	0.00	0	0
dml lock allocation	1,322,449	1.05	0.02	1	0
dummy allocation	452	0.00		0	0
enqueue hash chains	1,915,777	0.70	0.05	2	1,525	0.33
enqueues	406,166	0.43	0.01	0	0
event group latch	226	0.00		0	0
file cache latch	2,283	0.00		0	0
global KZLD latch for mem in SGA	224	0.00		0	0
hash table column usage latch	0			0	16,133	0.00
hash table modification latch	10	0.00		0	0
job_queue_processes parameter latch	10	0.00		0	0
kks stats	1,591	0.00		0	0
ksuosstats global area	42	0.00		0	0
ktm global data	2	0.00		0	0
kwqbsn:qsga	23	0.00		0	0
lgwr LWN SCN	137,278	0.01	0.00	0	0
library cache	1,757,928	0.59	0.04	3	2,889	0.24
library cache load lock	2,860	0.00		0	0
library cache lock	429,304	0.28	0.01	0	0
library cache lock allocation	4,091	0.00		0	0
library cache pin	863,439	0.52	0.02	0	0
library cache pin allocation	719	0.00		0	0
list of block allocation	460	0.00		0	0
loader state object freelist	62	0.00		0	0
message pool operations parent latch	2	0.00		0	0
messages	444,980	0.10	0.06	0	0
mostly latch-free SCN	137,822	0.12	0.02	0	0
multiblock read objects	28	0.00		0	0
ncodef allocation latch	13	0.00		0	0
object queue header heap	13,563	0.00		0	649	0.00
object queue header operation	988,401	0.05	0.06	0	0
object stats modification	26	0.00		0	0
parallel query alloc buffer	84	0.00		0	0
parameter list	807	0.00		0	0
parameter table allocation management	226	0.00		0	0
post/wait queue	183,073	0.01	0.21	0	119,023	0.36
process allocation	452	0.00		0	226	0.00
process group creation	452	0.00		0	0
qmn task queue latch	88	1.14	1.00	0	0
redo allocation	797,819	0.22	0.15	0	858,036	1.28
redo copy	0			0	862,243	0.68
redo writing	428,698	0.01	0.20	0	0
resmgr group change latch	226	0.00		0	0
resmgr:actses active list	449	0.00		0	0
resmgr:actses change group	224	0.00		0	0
resmgr:free threads list	448	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	1,770,590	0.46	0.01	0	1,310	0.08
rules engine aggregate statistics	1	0.00		0	0
rules engine rule set statistics	2	0.00		0	0
sequence cache	1,130	0.00		0	0
session allocation	750,225	0.62	0.01	0	0
session idle bit	1,102,877	0.07	0.02	0	0
session state list latch	463	0.00		0	0
session switching	13	0.00		0	0
session timer	275	0.00		0	0
shared pool	84,719	0.09	0.45	0	0
shared pool sim alloc	13	0.00		0	0
shared pool simulator	59,177	0.00		0	0
simulator hash latch	728,497	0.00	0.18	0	0
simulator lru latch	683,735	0.23	0.05	0	17,998	0.01
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	27	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	112	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	36	0.00		0	0
trace latch	1	0.00		0	0
transaction allocation	3,350	0.00		0	0
transaction branch allocation	13	0.00		0	0
undo global data	1,399,769	0.14	0.02	0	0
user lock	896	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	25,875,555	26,782	531	26,253
dml lock allocation	1,322,449	13,936	260	13,679
enqueue hash chains	1,915,777	13,368	622	12,753
In memory undo latch	1,820,907	13,253	985	12,286
library cache	1,757,928	10,418	389	10,034
row cache objects	1,770,590	8,211	83	8,130
session allocation	750,225	4,659	68	4,591
library cache pin	863,439	4,473	90	4,383
undo global data	1,399,769	1,956	31	1,925
enqueues	406,166	1,753	12	1,741
redo allocation	797,819	1,748	257	1,491
simulator lru latch	683,735	1,566	75	1,491
library cache lock	429,304	1,213	10	1,204
session idle bit	1,102,877	753	12	741
cache buffers lru chain	399,208	711	10	701
object queue header operation	988,401	541	31	510
messages	444,980	465	26	440
mostly latch-free SCN	137,822	161	3	158
shared pool	84,719	76	34	49
Consistent RBA	137,285	30	5	25
redo writing	428,698	25	5	20
checkpoint queue latch	193,206	14	1	13
post/wait queue	183,073	14	3	11
simulator hash latch	728,497	11	2	9
cache buffer handles	1,635	6	1	5
qmn task queue latch	88	1	1	0
slave class create	8	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	776	857
In memory undo latch	ktichg: child	104	102
In memory undo latch	ktiTxnPoolFree	65	0
In memory undo latch	kticmt: child	36	4
In memory undo latch	kturbk	6	24
cache buffer handles	kcbzgs	1	0
cache buffers chains	kcbgtcr: fast path	322	292
cache buffers chains	kcbgcur: kslbegin	112	170
cache buffers chains	kcbgtcr: kslbegin shared	80	31
cache buffers chains	kcbgtcr: kslbegin excl	73	35
cache buffers chains	kcbchg: kslbegin: bufs not pinned	58	149
cache buffers chains	kcbnew: new latch again	21	3
cache buffers chains	kcbzgb: scan from tail. nowait	21	0
cache buffers chains	kcbrls: kslbegin	18	12
cache buffers chains	kcb_pre_apply: kcbhq61	17	20
cache buffers chains	kcbgtcr	17	0
cache buffers chains	kcbnlc	10	14
cache buffers chains	kcb_post_apply: kcbhq62	9	2
cache buffers chains	kcbzwb	8	2
cache buffers chains	kcbchg: kslbegin: call CR func	7	37
cache buffers chains	kcbbxsv	5	5
cache buffers chains	kcbget: exchange rls	3	1
cache buffers chains	kcbzib: finish free bufs	3	2
cache buffers chains	kcbget: exchange	2	1
cache buffers chains	kcbget: pin buffer	1	4
cache buffers lru chain	kcbzgws	9	3
cache buffers lru chain	kcbbwlru	1	1
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	1	0
dml lock allocation	ktaiam	162	210
dml lock allocation	ktaidm	98	50
enqueue hash chains	ksqrcl	336	199
enqueue hash chains	ksqgtl3	282	418
enqueue hash chains	ksqcmi: get hash chain latch after wait	2	4
enqueue hash chains	ksqcnl	2	1
enqueues	ksqies	9	10
enqueues	ksqdel	2	0
enqueues	ksqgtl2	1	0
event range base latch	No latch	1	1
library cache	kglpndl: child: after processing	120	2
library cache	kglpnp: child	108	191
library cache	kgldte: child 0	33	49
library cache	kglobpn: child:	26	1
library cache	kglLockCursor	24	2
library cache	kgldtld: 2child	8	0
library cache	kglhdgn: child:	7	2
library cache	kgldti: 2child	6	0
library cache	kglpndl: child: before processing	6	140
library cache	kglini: child	5	0
library cache	kglic	2	0
library cache	kglobld	2	0
library cache	kglhdgc: child:	1	0
library cache lock	kgllkal: child: multiinstance	5	0
library cache lock	kgllkdl: child: cleanup	5	10
library cache lock	kgllkdl: child: no lock handle	1	0
library cache pin	kglpndl	55	42
library cache pin	kglpnp: child	35	46
messages	ksaamb: after wakeup	19	15
messages	ksarcv	4	9
messages	ksarcv: after wait	3	2
mostly latch-free SCN	kcs01	4	5
mostly latch-free SCN	kcs05	2	0
mostly latch-free SCN	kcs04	1	3
mostly latch-free SCN	kcsnew_scn_rba	1	0
object queue header operation	kcbw_link_q	13	0
object queue header operation	kcbo_switch_cq	8	25
object queue header operation	kcbo_switch_mq_bg	3	1
object queue header operation	kcbo_switch_q_bg	3	0
object queue header operation	kcbw_unlink_q	2	4
object queue header operation	kcbo_link_q:reget	1	0
object queue header operation	kcbo_swap_buf_bg	1	1
post/wait queue	ksliwat:add:nowait	1	0
post/wait queue	ksliwat:remove	1	0
post/wait queue	kslpstevent:get	1	2
redo allocation	kcrfw_redo_gen: redo allocation 1	246	0
redo allocation	kcrfw_redo_gen: redo allocation 3	5	6
redo allocation	kcrfw_redo_gen: redo allocation 2	3	0
redo allocation	kcrfw_redo_write: before write	3	139
redo writing	kcrfwcr	3	1
redo writing	kcrfw_cal_target_rba	1	1
redo writing	kcrfw_post: rba scn pair	1	0
row cache objects	kqrpre: find obj	45	79
row cache objects	kqreqd: reget	37	0
row cache objects	kqreqd	1	4
session allocation	ksucri	25	60
session allocation	ksuxds: not user session	24	8
session allocation	ksuprc	11	1
session allocation	ksudlc	10	1
session idle bit	ksupuc: set busy	8	2
session idle bit	ksuxds	4	2
session idle bit	ksupuc: clear busy	1	9
shared pool	kghfrunp: clatch: nowait	35	0
shared pool	kghfrunp: alloc: session dur	16	0
shared pool	kghalo	11	3
shared pool	kghupr1	6	31
shared pool	kghfrunp: clatch: wait	3	0
shared pool	kghalp	1	0
simulator hash latch	kcbs_lookup_setid: lookup dba	1	1
simulator hash latch	kcbsacc: lookup dba	1	2
simulator lru latch	kcbs_simulate: simulate set	70	76
simulator lru latch	kcbs_simbufseq	6	0
slave class create	ksvcreate	1	0
undo global data	ktudba: KSLBEGIN	15	11
undo global data	ktudnx:child	10	3
undo global data	ktusm_stealext: KSLBEGIN	3	0
undo global data	ktubnd:child	2	0
undo global data	kturimugur: child	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 12,351,102
Captured Segments account for 84.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCC	USERS	STOCK_I1	INDEX	3,783,936	30.64
TPCC	USERS	STOCK	TABLE	1,875,504	15.18
TPCC	USERS	CUSTOMER_I2	INDEX	772,320	6.25
TPCC	USERS	CUSTOMER	TABLE	734,880	5.95
TPCC	USERS	CUSTOMER_I1	INDEX	555,616	4.50

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 193,559
Captured Segments account for 99.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCC	USERS	ITEM_ID	INDEX	91,935	47.50
TPCC	USERS	ITEM	TABLE	51,248	26.48
TPCC	USERS	CUSTOMER	TABLE	23,913	12.35
TPCC	USERS	STOCK	TABLE	21,443	11.08
TPCC	USERS	CUSTOMER_I2	INDEX	613	0.32

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	DISTRICT		TABLE	12,522	54.69
TPCC	USERS	WAREHOUSE		TABLE	10,374	45.31

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	570	60.70
TPCC	USERS	HISTORY	TABLE	203	21.62
TPCC	USERS	DISTRICT	TABLE	136	14.48
TPCC	USERS	INORD	INDEX	18	1.92
TPCC	USERS	ORDERS	TABLE	9	0.96

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	15	13.33	2	1
dc_files	8	50.00	0	0
dc_global_oids	84	33.33	0	3
dc_histogram_data	3,376	28.23	0	440
dc_histogram_defs	7,597	32.84	0	696
dc_object_grants	41	14.63	0	6
dc_object_ids	4,360	8.37	0	235
dc_objects	2,530	17.91	0	232
dc_profiles	223	0.00	0	1
dc_rollback_segments	54,863	0.00	0	23
dc_segments	6,291	7.09	7	161
dc_sequences	28	14.29	28	1
dc_tablespace_quotas	2	50.00	0	0
dc_tablespaces	505,386	0.00	0	5
dc_usernames	604	0.17	0	4
dc_users	6,911	0.04	0	15
outstanding_alerts	12	83.33	1	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	13	46.15	104,211	0.01	4
CLUSTER	28	3.57	53	3.77	1
INDEX	39	43.59	133	18.05	7
SQL AREA	457	74.18	1,754,434	0.08	206
TABLE/PROCEDURE	1,521	21.30	327,618	0.42	401

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	44.61		1.59	3.99	22	22	28	28
	Freeable	8.31	0.00	0.83	0.34	1		10	10
	SQL	1.22	0.54	0.06	0.03	0	4	22	21
	PL/SQL	0.99	0.36	0.04	0.04	0	0	28	28
E	Other	46.62		1.50	3.80	22	22	31	31
	Freeable	8.81	0.00	0.80	0.37	1		11	11
	SQL	1.62	0.79	0.06	0.03	0	4	25	24
	PL/SQL	1.31	0.63	0.04	0.05	0	0	31	31

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
Fixed Size	1,263,572
Redo Buffers	7,122,944
Variable Size	88,082,476

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.99	0.94	-5.31
shared	FileOpenBlock	1.58	1.58	0.00
shared	Heap0: KGL	0.82	0.86	4.51
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGH: NO ACCESS	3.20	3.20	0.00
shared	KGLS heap	1.09	1.18	8.57
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	PL/SQL MPCODE	0.87		-100.00
shared	db_block_hash_buckets	1.13	1.13	0.00
shared	dbwriter coalesce buffer	1.00	1.00	0.00
shared	event statistics per sess	2.56	2.56	0.00
shared	free memory	12.62	14.03	11.18
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kks stbkt	0.88	0.88	0.00
shared	library cache	3.09	3.13	1.24
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	3.91	2.86	-26.87
	buffer_cache	708.00	708.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.68	Recursive Call %:	84.93
Rollback per transaction %:	0.00	Rows per Sort:	10.37

Buffer Nowait %:	99.92	Redo NoWait %:	99.99
Buffer Hit %:	98.43	In-memory Sort %:	100.00
Library Hit %:	99.87	Soft Parse %:	99.83
Execute to Parse %:	78.68	Latch Hit %:	99.76
Parse CPU to Parse Elapsd %:	49.72	% Non-Parse CPU:	97.82