WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ORCL 1200893776 orcl 1 23-Nov-10 18:11 11.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORCL	1200893776	orcl	1	23-Nov-10 18:11	11.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

11gR2Base Linux x86 64-bit 2 1.96

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
11gR2Base	Linux x86 64-bit	2			1.96

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 2199 24-Nov-10 11:50:02 33 1.0

End Snap: 2200 24-Nov-10 12:12:32 83 27.3

Elapsed: 22.49 (mins)

DB Time: 931.72 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2199	24-Nov-10 11:50:02	33	1.0
End Snap:	2200	24-Nov-10 12:12:32	83	27.3
Elapsed:		22.49 (mins)
DB Time:		931.72 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 420M 424M Std Block Size: 8K

Shared Pool Size: 304M 300M Log Buffer: 6,564K

	Begin	End
Buffer Cache:	420M	424M	Std Block Size:	8K
Shared Pool Size:	304M	300M	Log Buffer:	6,564K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 41.4 40.3 0.41 0.27

DB CPU(s): 0.8 0.8 0.01 0.01

Redo size: 6,904.5 6,712.9

Logical reads: 24,587.1 23,904.6

Block changes: 25.3 24.6

Physical reads: 23,362.9 22,714.4

Physical writes: 3.6 3.5

User calls: 155.1 150.8

Parses: 15.5 15.0

Hard parses: 4.6 4.5

W/A MB processed: 0.4 0.4

Logons: 0.2 0.2

Executes: 101.0 98.2

Rollbacks: 0.0 0.0

Transactions: 1.0

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	41.4	40.3	0.41	0.27
DB CPU(s):	0.8	0.8	0.01	0.01
Redo size:	6,904.5	6,712.9
Logical reads:	24,587.1	23,904.6
Block changes:	25.3	24.6
Physical reads:	23,362.9	22,714.4
Physical writes:	3.6	3.5
User calls:	155.1	150.8
Parses:	15.5	15.0
Hard parses:	4.6	4.5
W/A MB processed:	0.4	0.4
Logons:	0.2	0.2
Executes:	101.0	98.2
Rollbacks:	0.0	0.0
Transactions:	1.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.89 Redo NoWait %: 100.00

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

Library Hit %: 89.58 Soft Parse %: 70.28

Execute to Parse %: 84.69 Latch Hit %: 99.91

Parse CPU to Parse Elapsd %: 3.19 % Non-Parse CPU: 98.32

Shared Pool Statistics

Begin End

Memory Usage %: 89.70 80.82

% SQL with executions>1: 64.70 36.36

% Memory for SQL w/exec>1: 55.47 56.13

	Begin	End
Memory Usage %:	89.70	80.82
% SQL with executions>1:	64.70	36.36
% Memory for SQL w/exec>1:	55.47	56.13

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
direct path read	248,069	46,559	188	83.28	User I/O
db file sequential read	16,846	4,249	252	7.60	User I/O
db file parallel read	481	1,436	2985	2.57	User I/O
DB CPU		1,123		2.01
enq: KO - fast object checkpoint	666	900	1351	1.61	Application

Host CPU (CPUs: 2 Cores: Sockets: )

Load Average Begin Load Average End %User %System %WIO %Idle

0.24 23.79 13.3 32.7 40.8 51.5

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.24	23.79	13.3	32.7	40.8	51.5

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)

43.0 88.6 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
43.0	88.6	0.0

Begin End

Host Mem (MB): 2,011.4 2,011.4

SGA use (MB): 752.0 752.0

PGA use (MB): 202.6 435.9

% Host Mem used for SGA+PGA: 47.46 59.06

	Begin	End
Host Mem (MB):	2,011.4	2,011.4
SGA use (MB):	752.0	752.0
PGA use (MB):	202.6	435.9
% Host Mem used for SGA+PGA:	47.46	59.06

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
Shared Server Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 55903.4s
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	55,383.89	99.07
DB CPU	1,122.77	2.01
parse time elapsed	738.00	1.32
hard parse elapsed time	236.26	0.42
PL/SQL execution elapsed time	39.85	0.07
hard parse (sharing criteria) elapsed time	37.33	0.07
PL/SQL compilation elapsed time	25.05	0.04
hard parse (bind mismatch) elapsed time	5.71	0.01
connection management call elapsed time	1.66	0.00
repeated bind elapsed time	0.04	0.00
DB time	55,903.45
background elapsed time	606.46
background cpu time	13.26

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
BUSY_TIME	128,160
IDLE_TIME	135,970
IOWAIT_TIME	107,711
NICE_TIME	0
SYS_TIME	86,415
USER_TIME	35,141
LOAD	0	24
PHYSICAL_MEMORY_BYTES	2,109,128,704
NUM_CPUS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
24-Nov 11:50:02	0.24
24-Nov 12:12:32	23.79	48.52	13.30	32.72	51.48	40.78

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 99.8% of Total DB time 55,903.45 (s)
Total FG Wait Time: 54,684.30 (s) DB CPU time: 1,122.77 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
User I/O	269,850	0	52,826	196	94.49
DB CPU			1,123		2.01
Application	1,149	0	965	840	1.73
Concurrency	2,453	0	765	312	1.37
Other	4,033	66	100	25	0.18
Commit	1,211	0	24	19	0.04
Network	208,946	0	3	0	0.01
Configuration	38	0	2	59	0.00
System I/O	497	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
direct path read	248,069	0	46,559	188	178.72	83.28
db file sequential read	16,846	0	4,249	252	12.14	7.60
db file parallel read	481	0	1,436	2985	0.35	2.57
enq: KO - fast object checkpoint	666	0	900	1351	0.48	1.61
read by other session	1,559	0	303	194	1.12	0.54
db file scattered read	1,426	0	273	192	1.03	0.49
latch: shared pool	1,555	0	261	168	1.12	0.47
cursor: pin S wait on X	189	0	261	1380	0.14	0.47
library cache: mutex X	147	0	124	847	0.11	0.22
enq: TX - row lock contention	27	0	63	2342	0.02	0.11
latch free	252	0	52	205	0.18	0.09
cursor: pin S	14	0	39	2768	0.01	0.07
library cache lock	29	0	28	954	0.02	0.05
log file sync	1,211	0	24	19	0.87	0.04
os thread startup	46	0	22	484	0.03	0.04
enq: PR - contention	2	0	17	8529	0.00	0.03
latch: cache buffers chains	256	0	13	51	0.18	0.02
buffer deadlock	2	100	12	5881	0.00	0.02
reliable message	672	0	8	13	0.48	0.02
enq: TX - index contention	23	0	6	273	0.02	0.01
Disk file operations I/O	1,465	0	6	4	1.06	0.01
latch: cache buffers lru chain	108	0	5	42	0.08	0.01
PX Deq: Signal ACK RSG	42	69	3	82	0.03	0.01
buffer busy waits	59	0	3	58	0.04	0.01
library cache load lock	50	0	3	65	0.04	0.01
latch: row cache objects	58	0	3	46	0.04	0.00
SQL*Net message to client	208,400	0	3	0	150.14	0.00
enq: HW - contention	38	0	2	59	0.03	0.00
SQL*Net break/reset to client	456	0	2	4	0.33	0.00
row cache lock	27	0	1	52	0.02	0.00
enq: TX - contention	13	0	1	55	0.01	0.00
PX Deq: Slave Session Stats	144	0	1	4	0.10	0.00
latch: enqueue hash chains	18	0	0	25	0.01	0.00
asynch descriptor resize	2,620	100	0	0	1.89	0.00
flashback log file sync	3	0	0	70	0.00	0.00
control file sequential read	484	0	0	0	0.35	0.00
latch: parallel query alloc buffer	10	0	0	17	0.01	0.00
PX Deq: Signal ACK EXT	83	0	0	2	0.06	0.00
SQL*Net more data to client	416	0	0	0	0.30	0.00
enq: FB - contention	5	0	0	31	0.00	0.00
enq: PS - contention	23	0	0	5	0.02	0.00
CSS initialization	2	0	0	53	0.00	0.00
SQL*Net more data from client	130	0	0	1	0.09	0.00
enq: BF - allocation contention	2	0	0	33	0.00	0.00
latch: object queue header operation	6	0	0	10	0.00	0.00
direct path write	1	0	0	16	0.00	0.00
PX qref latch	7	100	0	2	0.01	0.00
latch: call allocation	5	0	0	1	0.00	0.00
CSS operation: action	2	0	0	2	0.00	0.00
PX Deq: Table Q qref	2	0	0	1	0.00	0.00
CSS operation: query	12	0	0	0	0.01	0.00
SQL*Net message from client	208,349	0	4,663	22	150.11
jobq slave wait	2,695	100	1,350	501	1.94
PX Deq: Table Q Normal	909	61	1,163	1279	0.65
PX Deq: Execute Reply	827	30	578	699	0.60
PX Deq: Execution Msg	887	4	128	145	0.64
PX Deq Credit: send blkd	136	0	10	74	0.10
PX Deq: Parse Reply	69	3	6	91	0.05
PX Deq: Join ACK	77	0	2	30	0.06
PX Deq: Table Q Sample	2	0	0	4	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
Only events with Total Wait Time (s) >= .001 are shown
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
db file async I/O submit	835	0	224	269	0.60	37.01
os thread startup	57	0	85	1485	0.04	13.96
log file parallel write	2,136	0	30	14	1.54	4.99
process diagnostic dump	1	100	30	30237	0.00	4.99
flashback log file write	502	0	14	28	0.36	2.33
enq: PR - contention	2	0	13	6628	0.00	2.19
db file parallel write	546	0	13	24	0.39	2.14
ASM file metadata operation	597	0	12	21	0.43	2.05
control file sequential read	2,478	0	12	5	1.79	1.91
latch: shared pool	72	0	10	144	0.05	1.71
control file parallel write	679	0	8	12	0.49	1.33
db file sequential read	215	0	6	28	0.15	0.98
flashback log file sync	10	0	1	109	0.01	0.18
enq: CF - contention	1	0	1	1024	0.00	0.17
CSS initialization	5	0	1	136	0.00	0.11
Parameter File I/O	64	0	1	10	0.05	0.10
Disk file operations I/O	264	0	1	2	0.19	0.08
log file sync	6	0	0	76	0.00	0.08
latch: cache buffers lru chain	10	0	0	35	0.01	0.06
flashback log file read	18	0	0	17	0.01	0.05
reliable message	14	0	0	19	0.01	0.04
direct path write	8	0	0	33	0.01	0.04
kfk: async disk IO	666	0	0	0	0.48	0.03
LGWR wait for redo copy	15	0	0	10	0.01	0.02
latch: redo allocation	4	0	0	28	0.00	0.02
latch free	3	0	0	34	0.00	0.02
direct path read	6	0	0	13	0.00	0.01
db file scattered read	4	0	0	16	0.00	0.01
latch: row cache objects	1	0	0	38	0.00	0.01
latch: object queue header operation	4	0	0	8	0.00	0.01
latch: parallel query alloc buffer	3	0	0	11	0.00	0.01
ADR block file read	13	0	0	2	0.01	0.00
buffer busy waits	5	0	0	5	0.00	0.00
latch: enqueue hash chains	1	0	0	23	0.00	0.00
SQL*Net more data from client	52	0	0	0	0.04	0.00
CSS operation: action	5	0	0	3	0.00	0.00
rdbms ipc reply	16	0	0	1	0.01	0.00
asynch descriptor resize	157	100	0	0	0.11	0.00
latch: call allocation	3	0	0	3	0.00	0.00
SQL*Net more data to client	52	0	0	0	0.04	0.00
library cache: mutex X	1	0	0	6	0.00	0.00
CSS operation: query	30	0	0	0	0.02	0.00
latch: cache buffers chains	1	0	0	2	0.00	0.00
ADR block file write	5	0	0	0	0.00	0.00
rdbms ipc message	10,652	60	23,725	2227	7.67
PX Idle Wait	3,130	97	6,105	1951	2.26
DIAG idle wait	2,701	100	2,704	1001	1.95
class slave wait	49	0	1,653	33737	0.04
wait for unread message on broadcast channel	1,352	100	1,353	1001	0.97
Space Manager: slave idle wait	269	99	1,352	5027	0.19
shared server idle wait	45	100	1,350	30003	0.03
pmon timer	569	79	1,349	2372	0.41
ASM background timer	368	0	1,349	3667	0.27
Streams AQ: qmn coordinator idle wait	96	50	1,344	14002	0.07
Streams AQ: qmn slave idle wait	49	0	1,343	27418	0.04
smon timer	47	4	1,343	28580	0.03
dispatcher timer	22	100	1,320	60002	0.02
KSV master wait	44	0	10	233	0.03
SQL*Net message from client	157	0	2	10	0.11
SGA: MMAN sleep for component shrink	8	25	0	7	0.01

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
% of Waits: value of .0 indicates value was <.05%; value of null is truly 0
% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	13	76.9	7.7		7.7	7.7
ADR block file write	5	100.0
ADR file lock	6	100.0
ASM file metadata operation	598	86.5	3.0	3.5	1.7	.8	.7	3.5	.3
CSS initialization	7					14.3		85.7
CSS operation: action	7			100.0
CSS operation: query	42	92.9	7.1
Disk file operations I/O	1734	86.5	4.4	3.2	.9	1.5	1.2	2.2
LGWR wait for redo copy	15	60.0	6.7	6.7	6.7		6.7	13.3
PX Deq: Signal ACK EXT	83	79.5	6.0	4.8	2.4	1.2	6.0
PX Deq: Signal ACK RSG	42	35.7	16.7	11.9	14.3	4.8	4.8	7.1	4.8
PX Deq: Slave Session Stats	144	37.5	20.8	18.8	11.8	6.9	2.8	1.4
PX Deq: Table Q qref	2	50.0		50.0
PX qref latch	7	85.7				14.3
Parameter File I/O	64	75.0	1.6	3.1			3.1	17.2
SQL*Net break/reset to client	456	52.0	30.5	7.9	3.7	2.2	1.5	2.2
SQL*Net message to client	208.5K	99.9	.0	.0	.0	.0	.0	.0
SQL*Net more data from client	182	93.4	4.4	.5		1.1		.5
SQL*Net more data to client	468	98.1	1.1	.4	.2			.2
asynch descriptor resize	2780	99.6	.1	.1	.0	.1		.1
buffer busy waits	64	7.8	7.8	4.7	21.9	9.4	9.4	39.1
buffer deadlock	2								100.0
control file parallel write	680	60.0	11.2	7.1	3.7	4.4	6.5	7.2
control file sequential read	2992	80.4	6.3	3.3	1.8	2.0	2.8	3.3
cursor: pin S	14	7.1			7.1	7.1		28.6	50.0
cursor: pin S wait on X	189					7.9	7.9	63.0	21.2
db file async I/O submit	837	18.2	1.7	1.4	1.6	3.2	5.9	64.8	3.3
db file parallel read	481							23.5	76.5
db file parallel write	549	7.7	1.8	3.3	7.7	27.3	34.6	17.7
db file scattered read	1409	28.9	4.5	2.1	1.3	2.1	3.4	55.1	2.7
db file sequential read	17.2K	7.8	1.2	.8	1.5	3.4	4.2	79.8	1.2
direct path read	248.1K	.7	18.2	11.4	2.1	2.6	2.2	60.7	2.1
direct path write	9					22.2	44.4	33.3
enq: BF - allocation contention	2		50.0					50.0
enq: CF - contention	1							100.0
enq: FB - contention	5			20.0			20.0	60.0
enq: HW - contention	38	10.5	5.3	7.9	7.9	2.6	2.6	63.2
enq: KO - fast object checkpoint	666	.5	.6	1.5	1.8	2.6	4.1	69.5	19.5
enq: PR - contention	4							50.0	50.0
enq: PS - contention	23	21.7	30.4	26.1	4.3	4.3	13.0
enq: TX - contention	13		46.2	30.8				23.1
enq: TX - index contention	23				4.3			95.7
enq: TX - row lock contention	27				3.7	3.7	3.7	63.0	25.9
flashback log file read	18	50.0	16.7			11.1	11.1	11.1
flashback log file sync	13	38.5		7.7			15.4	38.5
flashback log file write	503	25.4	11.7	7.2	5.2	10.1	16.3	24.1
kfk: async disk IO	683	98.8		.3		.1	.6	.1
latch free	255	7.1	5.9	3.9	3.1	9.0	13.3	52.5	5.1
latch: cache buffer handles	1	100.0
latch: cache buffers chains	257	33.9	7.4	8.6	6.6	5.8	7.8	30.0
latch: cache buffers lru chain	118	14.4	10.2	6.8	8.5	11.0	11.0	38.1
latch: call allocation	8	62.5	12.5	12.5	12.5
latch: enqueue hash chains	19	15.8	15.8	10.5		5.3	36.8	15.8
latch: object queue header operation	10	60.0				20.0	20.0
latch: parallel query alloc buffer	13	7.7	7.7		7.7	46.2	23.1	7.7
latch: redo allocation	4		25.0		25.0		25.0	25.0
latch: row cache objects	61	21.3	1.6	1.6	6.6	13.1	9.8	45.9
latch: shared pool	1637	11.3	2.8	3.8	4.3	8.4	10.7	55.4	3.2
library cache load lock	50		4.0	2.0	4.0		30.0	60.0
library cache lock	29			3.4			3.4	44.8	48.3
library cache: mutex X	148	5.4	3.4	5.4	10.8	12.8	10.1	30.4	21.6
log file parallel write	2139	38.5	13.2	9.4	7.0	10.2	11.0	10.8
log file sync	1217	9.9	23.7	16.5	12.0	11.1	11.8	14.9
os thread startup	105							81.9	18.1
process diagnostic dump	1								100.0
rdbms ipc reply	16	81.3	12.5	6.3
read by other session	1559	.4	.6	1.7	3.3	5.7	7.5	79.7	1.0
reliable message	686	47.1	16.0	9.6	7.3	4.7	6.9	8.5
row cache lock	27	11.1		14.8	3.7	11.1	7.4	51.9
ASM background timer	369	11.4	2.4	1.4	1.4	1.4	1.6	8.1	72.4
DIAG idle wait	2709							99.9	.1
KSV master wait	44	15.9	13.6	15.9	9.1	6.8	6.8	25.0	6.8
PX Deq Credit: send blkd	136	74.3	9.6	5.1	4.4	2.2	.7		3.7
PX Deq: Execute Reply	827	44.7	5.3	4.0	1.2	1.2	1.3	7.6	34.6
PX Deq: Execution Msg	887	49.5	6.9	6.0	3.7	6.5	7.9	13.4	6.1
PX Deq: Join ACK	77	18.2		6.5	18.2	23.4	14.3	19.5
PX Deq: Parse Reply	69	24.6		7.2	15.9	31.9	7.2	10.1	2.9
PX Deq: Table Q Normal	909	21.0	3.2	3.1	1.5	1.5	.9	5.4	63.4
PX Deq: Table Q Sample	2			100.0
PX Idle Wait	3250	.2		.1	.0	.1	.2	1.8	97.6
SGA: MMAN sleep for component shrink	8	12.5		12.5	37.5	37.5
SQL*Net message from client	208.5K	14.2	61.6	17.8	3.8	1.2	.9	.4	.0
Space Manager: slave idle wait	269	.4							99.6
Streams AQ: qmn coordinator idle wait	98	39.8	8.2	2.0					50.0
Streams AQ: qmn slave idle wait	50	2.0							98.0
class slave wait	48	27.1	6.3		6.3	4.2	4.2	31.3	20.8
dispatcher timer	23								100.0
jobq slave wait	2689			.0			.0	99.9
pmon timer	573	15.0	3.8	1.2	.3			.3	79.2
rdbms ipc message	10.7K	4.9	1.1	1.1	2.1	3.7	2.9	36.0	48.1
shared server idle wait	45								100.0
smon timer	47	4.3				4.3	10.6	59.6	21.3
wait for unread message on broadcast channel	1355							99.9	.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ASM file metadata operation	21	96.2	1.3	.8	.7	.5	.2		.3
CSS initialization	6	14.3		57.1	28.6
Disk file operations I/O	39	97.8	.8	1.2	.1	.1	.1
LGWR wait for redo copy	2	86.7	13.3
PX Deq: Signal ACK RSG	5	88.1		7.1				4.8
PX Deq: Slave Session Stats	2	98.6	1.4
Parameter File I/O	11	82.8	14.1	3.1
SQL*Net break/reset to client	10	97.8	1.3	.4	.4
SQL*Net message to client	8	100.0	.0	.0	.0
SQL*Net more data from client	1	99.5	.5
SQL*Net more data to client	1	99.8	.2
asynch descriptor resize	2	99.9	.0		.0
buffer busy waits	25	60.9	29.7		4.7	1.6	3.1
control file parallel write	49	92.8	3.1	1.8	1.9	.1	.3
control file sequential read	100	96.7	1.9	1.1	.4
cursor: pin S	8	21.4		7.1	7.1	7.1	7.1	28.6	21.4
cursor: pin S wait on X	120	15.9	28.6	3.7	18.0	11.1	1.6	.5	20.6
db file async I/O submit	559	31.9	8.5	12.8	18.4	17.8	7.3	2.0	1.3
db file parallel read	210		.2	.2	2.5	7.9	12.7	20.2	56.3
db file parallel write	97	82.3	12.2	3.6	1.6	.2
db file scattered read	813	42.2	6.1	11.2	14.4	14.3	9.1	2.6	.1
db file sequential read	13.9K	19.0	6.4	13.6	23.7	25.1	11.0	1.2	.0
direct path read	155.2K	37.2	4.3	15.1	21.8	13.0	6.4	1.9	.2
direct path write	3	66.7	22.2	11.1
enq: BF - allocation contention	1	50.0	50.0
enq: CF - contention	1						100.0
enq: FB - contention	3	40.0	60.0
enq: HW - contention	24	36.8	23.7	31.6	7.9
enq: KO - fast object checkpoint	500	11.0	8.6	13.4	16.5	19.5	11.6	5.6	14.0
enq: PR - contention	2				25.0		25.0		50.0
enq: TX - contention	3	76.9			15.4	7.7
enq: TX - index contention	22	4.3	4.3	43.5	8.7	8.7	30.4
enq: TX - row lock contention	18	11.1	7.4	3.7	18.5	14.8	18.5	3.7	22.2
flashback log file read	2	88.9		5.6	5.6
flashback log file sync	5	61.5	23.1		7.7		7.7
flashback log file write	121	75.9	9.9	10.7	2.6	.8
kfk: async disk IO	1	99.9	.1
latch free	146	42.4	12.2	12.9	9.0	12.5	5.9	4.7	.4
latch: cache buffers chains	77	70.0	6.6	9.7	5.8	7.8
latch: cache buffers lru chain	45	61.9	13.6	16.9	7.6
latch: enqueue hash chains	3	84.2	5.3	10.5
latch: parallel query alloc buffer	1	92.3	7.7
latch: redo allocation	1	75.0		25.0
latch: row cache objects	28	54.1	26.2	11.5	4.9	3.3
latch: shared pool	940	41.4	14.8	15.6	13.5	8.5	3.0	2.0	1.2
library cache load lock	30	40.0	14.0	46.0
library cache lock	27	6.9			3.4	6.9	34.5	48.3
library cache: mutex X	56	48.0	4.7	7.4	6.8	5.4	6.1	7.4	14.2
log file parallel write	230	89.2	5.8	3.0	1.4	.5
log file sync	181	85.1	8.0	3.8	2.0	1.2
os thread startup	99		35.2	21.9	16.2	2.9	5.7	12.4	5.7
read by other session	1258	19.2	11.9	20.2	24.8	17.5	5.3	1.0	.1
reliable message	58	91.5	3.2	2.6	2.2	.3	.1
row cache lock	14	48.1		51.9

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m
		% of Total Waits
ASM file metadata operation	2	99.7	.2	.2
buffer deadlock	2			100.0
cursor: pin S	3	78.6			21.4
cursor: pin S wait on X	39	79.4	2.6	14.3	3.2	.5
db file async I/O submit	11	98.7	.6	.5	.2
db file parallel read	271	43.7	30.4	21.8	4.2
db file scattered read	2	99.9	.1
db file sequential read	7	100.0	.0
direct path read	607	99.8	.2	.0	.0	.0
enq: KO - fast object checkpoint	93	86.0	4.7	5.7	1.7	2.0
enq: PR - contention	2	50.0			25.0	25.0
enq: TX - row lock contention	6	77.8	11.1	7.4			3.7
latch free	1	99.6	.4
latch: shared pool	19	98.8	1.2
library cache: mutex X	21	85.8	9.5	4.7
os thread startup	6	94.3	2.9	1.9			1.0
process diagnostic dump	1					100.0
read by other session	1	99.9	.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
orcl	55,800	1,107	31,526	33,137
SYS$USERS	101	15	1	29
ADHOC	0	0	0	0
BATCH_LOW	0	0	0	0
BATCH_STD	0	0	0	0
DSS	0	0	0	0
OLTP	0	0	0	0
SYS$BACKGROUND	0	0	0	13
orclXDB	0	0	0	0

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 seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
orcl	268977	52814	2431	764	208946	3
SYS$USERS	873	11	22	1	0	0
SYS$BACKGROUND	571	9	117	94	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 User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
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
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 98.4% of Total DB Time (s): 55,903
Captured PL/SQL account for 73.3% of Total DB Time (s): 55,903

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
39,744.49	74	537.09	71.09	1.71	98.09	72vydb3ncbn3s	Agent.exe	DECLARE trades E_TradeList; BE...
39,631.92	74	535.57	70.89	1.72	98.36	58h9dvw8qzy7w	Agent.exe	SELECT T_ID FROM E_TRADE WHERE...
7,503.15	543	13.82	13.42	2.83	90.14	bqjghjzaphzb2	Agent.exe	SELECT T_CHRG, T_EXEC_NAME, EX...
848.61	144	5.89	1.52	0.19	99.89	2vcn91b1wtmc6	Agent.exe	SELECT TH_DTS, TH_ST_ID FROM E...
797.20	36	22.14	1.43	1.44	86.57	318ng5h3q5x79	Agent.exe	Select T_BID_PRICE, T_EXEC_NAM...
772.89	70	11.04	1.38	0.24	99.68	8h5jmzqcfpgzb	Agent.exe	SELECT CT_AMT, CT_NAME, CT_DTS...
749.01	144	5.20	1.34	0.23	99.84	309b84z4mv9jb	Agent.exe	SELECT SE_CASH_TYPE, SE_CASH_D...
741.11	2,280	0.33	1.33	0.35	99.05	84nxzpqwn91j5	Agent.exe	Select to_char(TH_DTS, 'mm/dd/...
681.47	70	9.74	1.22	0.33	99.18	15p4z9yvdc8ua	Agent.exe	SELECT T_EXEC_NAME, T_BID_PRIC...
573.14	2,141	0.27	1.03	0.33	98.67	g4gkdzc5fb01z	Agent.exe	Select CT_AMT, to_char(CT_DTS,...

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 - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 89.3% of Total CPU Time (s): 1,123
Captured PL/SQL account for 62.3% of Total CPU Time (s): 1,123

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
681.04	74	9.20	60.66	39,744.49	1.71	98.09	72vydb3ncbn3s	Agent.exe	DECLARE trades E_TradeList; BE...
680.10	74	9.19	60.57	39,631.92	1.72	98.36	58h9dvw8qzy7w	Agent.exe	SELECT T_ID FROM E_TRADE WHERE...
212.36	543	0.39	18.91	7,503.15	2.83	90.14	bqjghjzaphzb2	Agent.exe	SELECT T_CHRG, T_EXEC_NAME, EX...
44.89	413	0.11	4.00	421.30	10.65	71.22	48ay2b94rz41x	Agent.exe	SELECT DM_DATE, DM_CLOSE, DM_H...
11.50	36	0.32	1.02	797.20	1.44	86.57	318ng5h3q5x79	Agent.exe	Select T_BID_PRICE, T_EXEC_NAM...
8.07	31,342	0.00	0.72	185.69	4.35	93.52	8v93w0n1dm76k	Agent.exe	SELECT DM_CLOSE FROM E_DAILY_M...
6.10	21	0.29	0.54	52.76	11.56	19.75	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
4.21	31,342	0.00	0.37	4.86	86.64	6.13	7rq305gd2gpzw	Agent.exe	SELECT S_NUM_OUT FROM E_SECURI...
4.14	31,342	0.00	0.37	4.93	83.96	0.00	4j9awnaff2xjr	Agent.exe	SELECT LT_PRICE FROM E_LAST_TR...
4.12	80	0.05	0.37	251.40	1.64	45.25	5pnb5ryzbx5xx	Agent.exe	SELECT TH_DTS, T_QTY, T_S_SYMB...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 99.6% of Total User I/O Wait Time (s): 52,834
Captured PL/SQL account for 74.4% of Total User I/O Wait Time (s): 52,834

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
38,985.23	74	526.83	73.79	39,744.49	1.71	98.09	72vydb3ncbn3s	Agent.exe	DECLARE trades E_TradeList; BE...
38,983.03	74	526.80	73.78	39,631.92	1.72	98.36	58h9dvw8qzy7w	Agent.exe	SELECT T_ID FROM E_TRADE WHERE...
6,763.60	543	12.46	12.80	7,503.15	2.83	90.14	bqjghjzaphzb2	Agent.exe	SELECT T_CHRG, T_EXEC_NAME, EX...
847.66	144	5.89	1.60	848.61	0.19	99.89	2vcn91b1wtmc6	Agent.exe	SELECT TH_DTS, TH_ST_ID FROM E...
770.44	70	11.01	1.46	772.89	0.24	99.68	8h5jmzqcfpgzb	Agent.exe	SELECT CT_AMT, CT_NAME, CT_DTS...
747.85	144	5.19	1.42	749.01	0.23	99.84	309b84z4mv9jb	Agent.exe	SELECT SE_CASH_TYPE, SE_CASH_D...
734.08	2,280	0.32	1.39	741.11	0.35	99.05	84nxzpqwn91j5	Agent.exe	Select to_char(TH_DTS, 'mm/dd/...
690.17	36	19.17	1.31	797.20	1.44	86.57	318ng5h3q5x79	Agent.exe	Select T_BID_PRICE, T_EXEC_NAM...
675.92	70	9.66	1.28	681.47	0.33	99.18	15p4z9yvdc8ua	Agent.exe	SELECT T_EXEC_NAME, T_BID_PRIC...
565.49	2,141	0.26	1.07	573.14	0.33	98.67	g4gkdzc5fb01z	Agent.exe	Select CT_AMT, to_char(CT_DTS,...
531.13	2,280	0.23	1.01	536.00	0.34	99.09	7yphsb8fr4vus	Agent.exe	Select SE_AMT, to_char(SE_CASH...

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 as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 33,179,610
Captured SQL account for 99.6% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
24,589,609	74	332,292.01	74.11	39,744.49	1.71	98.09	72vydb3ncbn3s	Agent.exe	DECLARE trades E_TradeList; BE...
24,588,932	74	332,282.86	74.11	39,631.92	1.72	98.36	58h9dvw8qzy7w	Agent.exe	SELECT T_ID FROM E_TRADE WHERE...
6,215,461	543	11,446.52	18.73	7,503.15	2.83	90.14	bqjghjzaphzb2	Agent.exe	SELECT T_CHRG, T_EXEC_NAME, EX...
1,129,204	413	2,734.15	3.40	421.30	10.65	71.22	48ay2b94rz41x	Agent.exe	SELECT DM_DATE, DM_CLOSE, DM_H...
414,661	36	11,518.36	1.25	797.20	1.44	86.57	318ng5h3q5x79	Agent.exe	Select T_BID_PRICE, T_EXEC_NAM...
125,368	31,342	4.00	0.38	185.69	4.35	93.52	8v93w0n1dm76k	Agent.exe	SELECT DM_CLOSE FROM E_DAILY_M...
97,696	80	1,221.20	0.29	251.40	1.64	45.25	5pnb5ryzbx5xx	Agent.exe	SELECT TH_DTS, T_QTY, T_S_SYMB...
94,028	31,342	3.00	0.28	4.93	83.96	0.00	4j9awnaff2xjr	Agent.exe	SELECT LT_PRICE FROM E_LAST_TR...
94,026	31,342	3.00	0.28	4.86	86.64	6.13	7rq305gd2gpzw	Agent.exe	SELECT S_NUM_OUT FROM E_SECURI...
50,622	141	359.02	0.15	10.00	9.01	2.68	fjpgrrp53dtxj	Agent.exe	SELECT B_NAME, NVL(SUM(TR_QTY...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 31,527,638
Captured SQL account for 100.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
24,567,193	74	331,989.09	77.92	39,631.92	1.72	98.36	58h9dvw8qzy7w	Agent.exe	SELECT T_ID FROM E_TRADE WHERE...
24,567,193	74	331,989.09	77.92	39,744.49	1.71	98.09	72vydb3ncbn3s	Agent.exe	DECLARE trades E_TradeList; BE...
6,241,772	543	11,494.98	19.80	7,503.15	2.83	90.14	bqjghjzaphzb2	Agent.exe	SELECT T_CHRG, T_EXEC_NAME, EX...
419,561	36	11,654.47	1.33	797.20	1.44	86.57	318ng5h3q5x79	Agent.exe	Select T_BID_PRICE, T_EXEC_NAM...
105,994	80	1,324.93	0.34	251.40	1.64	45.25	5pnb5ryzbx5xx	Agent.exe	SELECT TH_DTS, T_QTY, T_S_SYMB...
80,672	413	195.33	0.26	421.30	10.65	71.22	48ay2b94rz41x	Agent.exe	SELECT DM_DATE, DM_CLOSE, DM_H...
33,963	98	346.56	0.11	251.62	0.75	17.21	5jctjh9wmayy6	Agent.exe	SELECT T_ID FROM E_TRADE WHERE...
33,700	97	347.42	0.11	231.81	0.83	10.11	83vnfyd1m59nq	Agent.exe	DECLARE tradeid INT; BEGIN SEL...
18,541	40	463.53	0.06	96.23	1.19	22.47	6h7xku2zvpgsh	Agent.exe	Select T_CA_ID, T_EXEC_NAME, D...
11,521	194	59.39	0.04	18.23	4.91	85.65	7vnf1z0t36s99	Agent.exe	SELECT C_ID FROM E_CUSTOMER WH...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 271,322
Captured SQL account for 96.6% of Total
Total UnOptimized Read Requests: 271,322
Captured SQL account for 96.6% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
192,407	192,407	74	2,600.09	70.91	72vydb3ncbn3s	Agent.exe	DECLARE trades E_TradeList; BE...
192,401	192,401	74	2,600.01	70.91	58h9dvw8qzy7w	Agent.exe	SELECT T_ID FROM E_TRADE WHERE...
41,899	41,899	543	77.16	15.44	bqjghjzaphzb2	Agent.exe	SELECT T_CHRG, T_EXEC_NAME, EX...
3,072	3,072	36	85.33	1.13	318ng5h3q5x79	Agent.exe	Select T_BID_PRICE, T_EXEC_NAM...
2,701	2,701	144	18.76	1.00	2vcn91b1wtmc6	Agent.exe	SELECT TH_DTS, TH_ST_ID FROM E...
2,589	2,589	144	17.98	0.95	309b84z4mv9jb	Agent.exe	SELECT SE_CASH_TYPE, SE_CASH_D...
2,588	2,588	70	36.97	0.95	15p4z9yvdc8ua	Agent.exe	SELECT T_EXEC_NAME, T_BID_PRIC...
2,467	2,467	70	35.24	0.91	8h5jmzqcfpgzb	Agent.exe	SELECT CT_AMT, CT_NAME, CT_DTS...
2,007	2,007	2,280	0.88	0.74	84nxzpqwn91j5	Agent.exe	Select to_char(TH_DTS, 'mm/dd/...
1,781	1,781	413	4.31	0.66	48ay2b94rz41x	Agent.exe	SELECT DM_DATE, DM_CLOSE, DM_H...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 136,325
Captured SQL account for 83.8% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
31,342	31,342	1.00	4.93	83.96	0.00	4j9awnaff2xjr	Agent.exe	SELECT LT_PRICE FROM E_LAST_TR...
31,342	31,342	1.00	4.86	86.64	6.13	7rq305gd2gpzw	Agent.exe	SELECT S_NUM_OUT FROM E_SECURI...
31,342	31,342	1.00	185.69	4.35	93.52	8v93w0n1dm76k	Agent.exe	SELECT DM_CLOSE FROM E_DAILY_M...
2,280	2,280	1.00	536.00	0.34	99.09	7yphsb8fr4vus	Agent.exe	Select SE_AMT, to_char(SE_CASH...
2,280	5,436	2.38	741.11	0.35	99.05	84nxzpqwn91j5	Agent.exe	Select to_char(TH_DTS, 'mm/dd/...
2,141	2,085	0.97	573.14	0.33	98.67	g4gkdzc5fb01z	Agent.exe	Select CT_AMT, to_char(CT_DTS,...
1,274	3,576	2.81	1.01	24.69	1.25	cm5vu20fhtnq1		select /*+ connect_by_filterin...
780	780	1.00	289.63	0.23	88.90	3904n1ntv7txj	Agent.exe	Select T_BID_PRICE, T_EXEC_NAM...
780	780	1.00	247.29	0.45	84.39	6dafh4gs0k2jc	Agent.exe	Declare ex_name Varchar2(65); ...
559	357	0.64	0.58	25.50	59.82	3c1kubcdjnppq		update sys.col_usage$ set equa...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 20,873
Captured SQL account for 47.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
1,274	1,274	6.10	cm5vu20fhtnq1		select /*+ connect_by_filterin...
555	543	2.66	bqjghjzaphzb2	Agent.exe	SELECT T_CHRG, T_EXEC_NAME, EX...
543	543	2.60	9ba2vwvw6z4z8	Agent.exe	SELECT C_L_NAME, C_F_NAME, B_N...
415	413	1.99	48ay2b94rz41x	Agent.exe	SELECT DM_DATE, DM_CLOSE, DM_H...
413	413	1.98	2mw82wp65dyv5	Agent.exe	SELECT S_NAME, CO_ID, CO_NAME,...
413	413	1.98	37h9f39wxj92r	Agent.exe	SELECT NI_HEADLINE, NI_SUMMARY...
413	413	1.98	9wfnvt8hnx49f	Agent.exe	SELECT CO_NAME, IN_NAME FROM E...
413	413	1.98	dbf6bmt9at48f	Agent.exe	SELECT FI_YEAR, FI_QTR, FI_QTR...
413	413	1.98	gzjm68u0xahd4	Agent.exe	SELECT LT_PRICE, LT_OPEN_PRICE...
321	321	1.54	6w6tz0ppcxb7u	Agent.exe	SELECT WI_S_SYMB FROM E_WATCH_...
221	202	1.06	0v3dvmc22qnam		insert into sys.col_usage$ (ob...
221	559	1.06	3c1kubcdjnppq		update sys.col_usage$ set equa...
221	221	1.06	b2gnxm5z6r51n		lock table sys.col_usage$ in e...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0v3dvmc22qnam insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) 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)

15p4z9yvdc8ua SELECT T_EXEC_NAME, T_BID_PRICE, T_TRADE_PRICE, T_IS_CASH, TT_IS_MRKT FROM E_TRADE, E_TRADE_TYPE WHERE T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND T_TT_ID = TT_ID AND ROWNUM <= :B1

2mw82wp65dyv5 SELECT S_NAME, CO_ID, CO_NAME, CO_SP_RATE, CO_CEO, CO_DESC, CO_OPEN_DATE, CO_ST_ID, NVL(CA.AD_LINE1, CHR(0)), NVL(CA.AD_LINE2, CHR(0)), ZCA.ZC_TOWN, ZCA.ZC_DIV, CA.AD_ZC_CODE, NVL(CA.AD_CTRY, CHR(0)), S_NUM_OUT, S_START_DATE, S_EXCH_DATE, S_PE, S_52WK_HIGH, S_52WK_HIGH_DATE, S_52WK_LOW, S_52WK_LOW_DATE, S_DIVIDEND, S_YIELD, NVL(EA.AD_LINE1, CHR(0)), NVL(EA.AD_LINE2, CHR(0)), ZEA.ZC_TOWN, ZEA.ZC_DIV, NVL(EA.AD_CTRY, CHR(0)), EA.AD_ZC_CODE, NVL(EX_DESC, CHR(0)), EX_NAME, EX_NUM_SYMB, EX_OPEN, EX_CLOSE FROM E_SECURITY, E_COMPANY, E_ADDRESS CA, E_ADDRESS EA, E_ZIP_CODE ZCA, E_ZIP_CODE ZEA, E_EXCHANGE WHERE S_SYMB = :B1 AND CO_ID = S_CO_ID AND CA.AD_ID = CO_AD_ID AND EA.AD_ID = EX_AD_ID AND EX_ID = S_EX_ID AND CA.AD_ZC_CODE = ZCA.ZC_CODE AND EA.AD_ZC_CODE = ZEA.ZC_CODE

2vcn91b1wtmc6 SELECT TH_DTS, TH_ST_ID FROM E_TRADE_HISTORY WHERE TH_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND ROWNUM <= (3 * :B1 ) ORDER BY TH_DTS

309b84z4mv9jb SELECT SE_CASH_TYPE, SE_CASH_DUE_DATE, SE_AMT FROM E_SETTLEMENT WHERE SE_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND ROWNUM <= :B1

318ng5h3q5x79 Select T_BID_PRICE, T_EXEC_NAME, Decode(T_IS_CASH, 'Y', 1, 'N', 0), T_ID, NVL(T_TRADE_PRICE, 0) From E_TRADE Where T_CA_ID = :acct_id And T_DTS >= to_date(:start_dts, 'mm/dd/YYYY') And T_DTS <= to_date(:end_dts, 'mm/dd/YYYY') And Rownum <= :max_trades order by T_DTS asc

37h9f39wxj92r SELECT NI_HEADLINE, NI_SUMMARY, NI_DTS, NI_SOURCE, NVL(NI_AUTHOR, CHR(0)) FROM E_NEWS_XREF, E_NEWS_ITEM WHERE NI_ID = NX_NI_ID AND NX_CO_ID = :B1 AND ROWNUM <= 2

3904n1ntv7txj Select T_BID_PRICE, T_EXEC_NAME, Case When T_IS_CASH = 'Y' Then 1 Else 0 End, TT_IS_MRKT, NVL(T_TRADE_PRICE, 0) From E_TRADE, E_TRADE_TYPE Where T_ID = :trade_id And T_TT_ID = TT_ID

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

48ay2b94rz41x SELECT DM_DATE, DM_CLOSE, DM_HIGH, DM_LOW, DM_VOL FROM E_DAILY_MARKET WHERE DM_S_SYMB = :B3 AND DM_DATE >= TO_DATE(:B2 , 'mm/dd/YYYY') AND ROWNUM <= :B1 ORDER BY DM_DATE ASC

4j9awnaff2xjr SELECT LT_PRICE FROM E_LAST_TRADE WHERE LT_S_SYMB = :symbol

58h9dvw8qzy7w SELECT T_ID FROM E_TRADE WHERE T_CA_ID = :B4 AND T_DTS BETWEEN TO_DATE(:B3 , 'mm/dd/YYYY') AND TO_DATE(:B2 , 'mm/dd/YYYY') AND ROWNUM <= :B1 ORDER BY T_DTS

5jctjh9wmayy6 SELECT T_ID FROM E_TRADE WHERE T_CA_ID = :B2 AND T_DTS >= TO_DATE(:B1 , 'mm/dd/YYYY') AND ROWNUM <= 1 ORDER BY T_DTS ASC

5pnb5ryzbx5xx SELECT TH_DTS, T_QTY, T_S_SYMB, T_ID, ST_NAME From (Select T_ID As ID From E_TRADE Where T_CA_ID = :acct_id And Rownum <= 10 Order By T_DTS DESC), E_TRADE, E_TRADE_HISTORY, E_STATUS_TYPE Where T_ID = ID And TH_T_ID = T_ID And ST_ID = TH_ST_ID Order by TH_DTS Desc

6dafh4gs0k2jc Declare ex_name Varchar2(65); Begin If :num_update < :max_updates Then Select Trim(T_EXEC_NAME) Into ex_name From E_TRADE Where T_ID = :trade_id; :num_found := :num_found + SQL%ROWCOUNT; If ex_name Like '% X %' Then ex_name := Replace(ex_name, ' X ', ' '); Else ex_name := Replace(ex_name, ' ', ' X '); End If; Update E_TRADE Set T_EXEC_NAME = ex_name Where T_ID = :trade_id; :num_update := :num_update + SQL%ROWCOUNT; End If;End;

6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

6h7xku2zvpgsh Select T_CA_ID, T_EXEC_NAME, Decode(T_IS_CASH, 'Y', 1, 'N', 0), NVL(T_TRADE_PRICE, 0) TRADE_PRICE, T_QTY, Trim(S_NAME), T_DTS, T_ID, T_TT_ID, TT_NAME From E_TRADE, E_TRADE_TYPE, E_SECURITY Where T_S_SYMB = :symbol And T_DTS >= to_date(:start_dts, 'mm/dd/YYYY') And T_DTS <= to_date(:end_dts, 'mm/dd/YYYY') And TT_ID = T_TT_ID And S_SYMB = T_S_SYMB And Rownum <= :max_trades Order By T_DTS Asc

6w6tz0ppcxb7u SELECT WI_S_SYMB FROM E_WATCH_ITEM, E_WATCH_LIST WHERE WI_WL_ID = WL_ID AND WL_C_ID = :B1

72vydb3ncbn3s DECLARE trades E_TradeList; BEGIN SELECT T_ID BULK COLLECT INTO trades FROM E_TRADE WHERE T_CA_ID = :acct_id AND T_DTS BETWEEN TO_DATE(:start_trade_dts, 'mm/dd/YYYY') AND TO_DATE(:end_trade_dts, 'mm/dd/YYYY') AND ROWNUM <= :maxtrades ORDER BY T_DTS; OPEN :t_cursor for SELECT T_ID, T_EXEC_NAME, T_BID_PRICE, T_TRADE_PRICE, T_IS_CASH, TT_IS_MRKT FROM E_TRADE, E_TRADE_TYPE WHERE T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) and T_TT_ID = TT_ID AND ROWNUM <= :maxtrades; OPEN :se_cursor for SELECT SE_CASH_TYPE, SE_CASH_DUE_DATE, SE_AMT FROM E_SETTLEMENT WHERE SE_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND ROWNUM <= :maxtrades; OPEN :ct_cursor for SELECT T_ID, T_IS_CASH, CT_AMT, CT_NAME, CT_DTS FROM E_CASH_TRANSACTION, E_TRADE WHERE CT_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND T_ID = CT_T_ID AND T_IS_CASH = 'Y' AND ROWNUM <= :maxtrades; OPEN :th_cursor for SELECT TH_DTS, TH_ST_ID FROM E_TRADE_HISTORY WHERE TH_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND ROWNUM <= (3 * :maxtrades) ORDER BY TH_DTS; END;

7rq305gd2gpzw SELECT S_NUM_OUT FROM E_SECURITY WHERE S_SYMB = :symbol

7vnf1z0t36s99 SELECT C_ID FROM E_CUSTOMER WHERE C_TAX_ID = :B1

7yphsb8fr4vus Select SE_AMT, to_char(SE_CASH_DUE_DATE, 'mm/dd/YYYY'), SE_CASH_TYPE From E_SETTLEMENT Where SE_T_ID = :trade_id

83vnfyd1m59nq DECLARE tradeid INT; BEGIN SELECT T_ID INTO tradeid FROM E_TRADE WHERE T_CA_ID = :acct_id AND T_DTS >= to_date(:start_trade_dts, 'mm/dd/YYYY') AND ROWNUM <= 1 ORDER BY T_DTS ASC; OPEN :hh_cursor for SELECT HH_H_T_ID, HH_T_ID, HH_BEFORE_QTY, HH_AFTER_QTY FROM E_HOLDING_HISTORY WHERE HH_H_T_ID = tradeid AND ROWNUM <= :maxtrades; END;

84nxzpqwn91j5 Select to_char(TH_DTS, 'mm/dd/YYYY'), TH_ST_ID From E_TRADE_HISTORY Where TH_T_ID = :trade_id order by TH_DTS

8h5jmzqcfpgzb SELECT CT_AMT, CT_NAME, CT_DTS FROM E_CASH_TRANSACTION, E_TRADE WHERE CT_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND T_ID = CT_T_ID AND T_IS_CASH = 'Y' AND ROWNUM <= :B1

8v93w0n1dm76k SELECT DM_CLOSE FROM E_DAILY_MARKET WHERE DM_S_SYMB = :symbol AND DM_DATE = to_date(:dm_date, 'mm/dd/YYYY')

9ba2vwvw6z4z8 SELECT C_L_NAME, C_F_NAME, B_NAME FROM E_CUSTOMER_ACCOUNT, E_CUSTOMER, E_BROKER WHERE CA_ID = :B1 AND C_ID = CA_C_ID AND B_ID = CA_B_ID

9wfnvt8hnx49f SELECT CO_NAME, IN_NAME FROM E_COMPANY_COMPETITOR, E_COMPANY, E_INDUSTRY WHERE CP_CO_ID = :B1 AND CO_ID = CP_COMP_CO_ID AND IN_ID = CP_IN_ID

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

bqjghjzaphzb2 SELECT T_CHRG, T_EXEC_NAME, EX_NAME, S_NAME, ST_NAME, T_S_SYMB, T_DTS, T_ID, T_QTY, TT_NAME FROM E_TRADE, E_STATUS_TYPE, E_TRADE_TYPE, E_SECURITY, E_EXCHANGE WHERE T_CA_ID = :B1 AND ST_ID = T_ST_ID AND TT_ID = T_TT_ID AND S_SYMB = T_S_SYMB AND EX_ID = S_EX_ID AND ROWNUM <= 50 ORDER BY T_DTS DESC

cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

dbf6bmt9at48f SELECT FI_YEAR, FI_QTR, FI_QTR_START_DATE, FI_REVENUE, FI_NET_EARN, FI_BASIC_EPS, FI_DILUT_EPS, FI_MARGIN, FI_INVENTORY, FI_ASSETS, FI_LIABILITY, FI_OUT_BASIC, FI_OUT_DILUT FROM E_FINANCIAL WHERE FI_CO_ID = :B1 AND ROWNUM <= 20 ORDER BY FI_YEAR ASC, FI_QTR

fjpgrrp53dtxj SELECT B_NAME, NVL(SUM(TR_QTY * TR_BID_PRICE), 0) FROM E_BROKER, E_TRADE_REQUEST, E_SECURITY, E_COMPANY, E_INDUSTRY, E_SECTOR WHERE B_NAME IN (:broker1, :broker2, :broker3, :broker4, :broker5, :broker6, :broker7, :broker8, :broker9, :broker10, :broker11, :broker12, :broker13, :broker14, :broker15, :broker16, :broker17, :broker18, :broker19, :broker20, :broker21, :broker22, :broker23, :broker24, :broker25, :broker26, :broker27, :broker28, :broker29, :broker30, :broker31, :broker32, :broker33, :broker34, :broker35, :broker36, :broker37, :broker38, :broker39, :broker40) AND B_ID = TR_B_ID AND TR_S_SYMB = S_SYMB AND S_CO_ID = CO_ID AND CO_IN_ID = IN_ID AND IN_SC_ID = SC_ID AND SC_NAME = :sector_name GROUP BY B_NAME ORDER BY 2 DESC

g4gkdzc5fb01z Select CT_AMT, to_char(CT_DTS, 'mm/dd/YYYY') , Nvl(CT_NAME, chr(0)) From E_CASH_TRANSACTION Where CT_T_ID = :trade_id

gzjm68u0xahd4 SELECT LT_PRICE, LT_OPEN_PRICE, LT_VOL FROM E_LAST_TRADE WHERE LT_S_SYMB = :B1

SQL Id	SQL Text
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) 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)
15p4z9yvdc8ua	SELECT T_EXEC_NAME, T_BID_PRICE, T_TRADE_PRICE, T_IS_CASH, TT_IS_MRKT FROM E_TRADE, E_TRADE_TYPE WHERE T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND T_TT_ID = TT_ID AND ROWNUM <= :B1
2mw82wp65dyv5	SELECT S_NAME, CO_ID, CO_NAME, CO_SP_RATE, CO_CEO, CO_DESC, CO_OPEN_DATE, CO_ST_ID, NVL(CA.AD_LINE1, CHR(0)), NVL(CA.AD_LINE2, CHR(0)), ZCA.ZC_TOWN, ZCA.ZC_DIV, CA.AD_ZC_CODE, NVL(CA.AD_CTRY, CHR(0)), S_NUM_OUT, S_START_DATE, S_EXCH_DATE, S_PE, S_52WK_HIGH, S_52WK_HIGH_DATE, S_52WK_LOW, S_52WK_LOW_DATE, S_DIVIDEND, S_YIELD, NVL(EA.AD_LINE1, CHR(0)), NVL(EA.AD_LINE2, CHR(0)), ZEA.ZC_TOWN, ZEA.ZC_DIV, NVL(EA.AD_CTRY, CHR(0)), EA.AD_ZC_CODE, NVL(EX_DESC, CHR(0)), EX_NAME, EX_NUM_SYMB, EX_OPEN, EX_CLOSE FROM E_SECURITY, E_COMPANY, E_ADDRESS CA, E_ADDRESS EA, E_ZIP_CODE ZCA, E_ZIP_CODE ZEA, E_EXCHANGE WHERE S_SYMB = :B1 AND CO_ID = S_CO_ID AND CA.AD_ID = CO_AD_ID AND EA.AD_ID = EX_AD_ID AND EX_ID = S_EX_ID AND CA.AD_ZC_CODE = ZCA.ZC_CODE AND EA.AD_ZC_CODE = ZEA.ZC_CODE
2vcn91b1wtmc6	SELECT TH_DTS, TH_ST_ID FROM E_TRADE_HISTORY WHERE TH_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND ROWNUM <= (3 * :B1 ) ORDER BY TH_DTS
309b84z4mv9jb	SELECT SE_CASH_TYPE, SE_CASH_DUE_DATE, SE_AMT FROM E_SETTLEMENT WHERE SE_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND ROWNUM <= :B1
318ng5h3q5x79	Select T_BID_PRICE, T_EXEC_NAME, Decode(T_IS_CASH, 'Y', 1, 'N', 0), T_ID, NVL(T_TRADE_PRICE, 0) From E_TRADE Where T_CA_ID = :acct_id And T_DTS >= to_date(:start_dts, 'mm/dd/YYYY') And T_DTS <= to_date(:end_dts, 'mm/dd/YYYY') And Rownum <= :max_trades order by T_DTS asc
37h9f39wxj92r	SELECT NI_HEADLINE, NI_SUMMARY, NI_DTS, NI_SOURCE, NVL(NI_AUTHOR, CHR(0)) FROM E_NEWS_XREF, E_NEWS_ITEM WHERE NI_ID = NX_NI_ID AND NX_CO_ID = :B1 AND ROWNUM <= 2
3904n1ntv7txj	Select T_BID_PRICE, T_EXEC_NAME, Case When T_IS_CASH = 'Y' Then 1 Else 0 End, TT_IS_MRKT, NVL(T_TRADE_PRICE, 0) From E_TRADE, E_TRADE_TYPE Where T_ID = :trade_id And T_TT_ID = TT_ID
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
48ay2b94rz41x	SELECT DM_DATE, DM_CLOSE, DM_HIGH, DM_LOW, DM_VOL FROM E_DAILY_MARKET WHERE DM_S_SYMB = :B3 AND DM_DATE >= TO_DATE(:B2 , 'mm/dd/YYYY') AND ROWNUM <= :B1 ORDER BY DM_DATE ASC
4j9awnaff2xjr	SELECT LT_PRICE FROM E_LAST_TRADE WHERE LT_S_SYMB = :symbol
58h9dvw8qzy7w	SELECT T_ID FROM E_TRADE WHERE T_CA_ID = :B4 AND T_DTS BETWEEN TO_DATE(:B3 , 'mm/dd/YYYY') AND TO_DATE(:B2 , 'mm/dd/YYYY') AND ROWNUM <= :B1 ORDER BY T_DTS
5jctjh9wmayy6	SELECT T_ID FROM E_TRADE WHERE T_CA_ID = :B2 AND T_DTS >= TO_DATE(:B1 , 'mm/dd/YYYY') AND ROWNUM <= 1 ORDER BY T_DTS ASC
5pnb5ryzbx5xx	SELECT TH_DTS, T_QTY, T_S_SYMB, T_ID, ST_NAME From (Select T_ID As ID From E_TRADE Where T_CA_ID = :acct_id And Rownum <= 10 Order By T_DTS DESC), E_TRADE, E_TRADE_HISTORY, E_STATUS_TYPE Where T_ID = ID And TH_T_ID = T_ID And ST_ID = TH_ST_ID Order by TH_DTS Desc
6dafh4gs0k2jc	Declare ex_name Varchar2(65); Begin If :num_update < :max_updates Then Select Trim(T_EXEC_NAME) Into ex_name From E_TRADE Where T_ID = :trade_id; :num_found := :num_found + SQL%ROWCOUNT; If ex_name Like '% X %' Then ex_name := Replace(ex_name, ' X ', ' '); Else ex_name := Replace(ex_name, ' ', ' X '); End If; Update E_TRADE Set T_EXEC_NAME = ex_name Where T_ID = :trade_id; :num_update := :num_update + SQL%ROWCOUNT; End If;End;
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6h7xku2zvpgsh	Select T_CA_ID, T_EXEC_NAME, Decode(T_IS_CASH, 'Y', 1, 'N', 0), NVL(T_TRADE_PRICE, 0) TRADE_PRICE, T_QTY, Trim(S_NAME), T_DTS, T_ID, T_TT_ID, TT_NAME From E_TRADE, E_TRADE_TYPE, E_SECURITY Where T_S_SYMB = :symbol And T_DTS >= to_date(:start_dts, 'mm/dd/YYYY') And T_DTS <= to_date(:end_dts, 'mm/dd/YYYY') And TT_ID = T_TT_ID And S_SYMB = T_S_SYMB And Rownum <= :max_trades Order By T_DTS Asc
6w6tz0ppcxb7u	SELECT WI_S_SYMB FROM E_WATCH_ITEM, E_WATCH_LIST WHERE WI_WL_ID = WL_ID AND WL_C_ID = :B1
72vydb3ncbn3s	DECLARE trades E_TradeList; BEGIN SELECT T_ID BULK COLLECT INTO trades FROM E_TRADE WHERE T_CA_ID = :acct_id AND T_DTS BETWEEN TO_DATE(:start_trade_dts, 'mm/dd/YYYY') AND TO_DATE(:end_trade_dts, 'mm/dd/YYYY') AND ROWNUM <= :maxtrades ORDER BY T_DTS; OPEN :t_cursor for SELECT T_ID, T_EXEC_NAME, T_BID_PRICE, T_TRADE_PRICE, T_IS_CASH, TT_IS_MRKT FROM E_TRADE, E_TRADE_TYPE WHERE T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) and T_TT_ID = TT_ID AND ROWNUM <= :maxtrades; OPEN :se_cursor for SELECT SE_CASH_TYPE, SE_CASH_DUE_DATE, SE_AMT FROM E_SETTLEMENT WHERE SE_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND ROWNUM <= :maxtrades; OPEN :ct_cursor for SELECT T_ID, T_IS_CASH, CT_AMT, CT_NAME, CT_DTS FROM E_CASH_TRANSACTION, E_TRADE WHERE CT_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND T_ID = CT_T_ID AND T_IS_CASH = 'Y' AND ROWNUM <= :maxtrades; OPEN :th_cursor for SELECT TH_DTS, TH_ST_ID FROM E_TRADE_HISTORY WHERE TH_T_ID IN (SELECT * from TABLE(Cast(trades as E_TradeList))) AND ROWNUM <= (3 * :maxtrades) ORDER BY TH_DTS; END;
7rq305gd2gpzw	SELECT S_NUM_OUT FROM E_SECURITY WHERE S_SYMB = :symbol
7vnf1z0t36s99	SELECT C_ID FROM E_CUSTOMER WHERE C_TAX_ID = :B1
7yphsb8fr4vus	Select SE_AMT, to_char(SE_CASH_DUE_DATE, 'mm/dd/YYYY'), SE_CASH_TYPE From E_SETTLEMENT Where SE_T_ID = :trade_id
83vnfyd1m59nq	DECLARE tradeid INT; BEGIN SELECT T_ID INTO tradeid FROM E_TRADE WHERE T_CA_ID = :acct_id AND T_DTS >= to_date(:start_trade_dts, 'mm/dd/YYYY') AND ROWNUM <= 1 ORDER BY T_DTS ASC; OPEN :hh_cursor for SELECT HH_H_T_ID, HH_T_ID, HH_BEFORE_QTY, HH_AFTER_QTY FROM E_HOLDING_HISTORY WHERE HH_H_T_ID = tradeid AND ROWNUM <= :maxtrades; END;
84nxzpqwn91j5	Select to_char(TH_DTS, 'mm/dd/YYYY'), TH_ST_ID From E_TRADE_HISTORY Where TH_T_ID = :trade_id order by TH_DTS
8h5jmzqcfpgzb	SELECT CT_AMT, CT_NAME, CT_DTS FROM E_CASH_TRANSACTION, E_TRADE WHERE CT_T_ID IN (SELECT * FROM TABLE(CAST(:B2 AS E_TRADELIST))) AND T_ID = CT_T_ID AND T_IS_CASH = 'Y' AND ROWNUM <= :B1
8v93w0n1dm76k	SELECT DM_CLOSE FROM E_DAILY_MARKET WHERE DM_S_SYMB = :symbol AND DM_DATE = to_date(:dm_date, 'mm/dd/YYYY')
9ba2vwvw6z4z8	SELECT C_L_NAME, C_F_NAME, B_NAME FROM E_CUSTOMER_ACCOUNT, E_CUSTOMER, E_BROKER WHERE CA_ID = :B1 AND C_ID = CA_C_ID AND B_ID = CA_B_ID
9wfnvt8hnx49f	SELECT CO_NAME, IN_NAME FROM E_COMPANY_COMPETITOR, E_COMPANY, E_INDUSTRY WHERE CP_CO_ID = :B1 AND CO_ID = CP_COMP_CO_ID AND IN_ID = CP_IN_ID
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
bqjghjzaphzb2	SELECT T_CHRG, T_EXEC_NAME, EX_NAME, S_NAME, ST_NAME, T_S_SYMB, T_DTS, T_ID, T_QTY, TT_NAME FROM E_TRADE, E_STATUS_TYPE, E_TRADE_TYPE, E_SECURITY, E_EXCHANGE WHERE T_CA_ID = :B1 AND ST_ID = T_ST_ID AND TT_ID = T_TT_ID AND S_SYMB = T_S_SYMB AND EX_ID = S_EX_ID AND ROWNUM <= 50 ORDER BY T_DTS DESC
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
dbf6bmt9at48f	SELECT FI_YEAR, FI_QTR, FI_QTR_START_DATE, FI_REVENUE, FI_NET_EARN, FI_BASIC_EPS, FI_DILUT_EPS, FI_MARGIN, FI_INVENTORY, FI_ASSETS, FI_LIABILITY, FI_OUT_BASIC, FI_OUT_DILUT FROM E_FINANCIAL WHERE FI_CO_ID = :B1 AND ROWNUM <= 20 ORDER BY FI_YEAR ASC, FI_QTR
fjpgrrp53dtxj	SELECT B_NAME, NVL(SUM(TR_QTY * TR_BID_PRICE), 0) FROM E_BROKER, E_TRADE_REQUEST, E_SECURITY, E_COMPANY, E_INDUSTRY, E_SECTOR WHERE B_NAME IN (:broker1, :broker2, :broker3, :broker4, :broker5, :broker6, :broker7, :broker8, :broker9, :broker10, :broker11, :broker12, :broker13, :broker14, :broker15, :broker16, :broker17, :broker18, :broker19, :broker20, :broker21, :broker22, :broker23, :broker24, :broker25, :broker26, :broker27, :broker28, :broker29, :broker30, :broker31, :broker32, :broker33, :broker34, :broker35, :broker36, :broker37, :broker38, :broker39, :broker40) AND B_ID = TR_B_ID AND TR_S_SYMB = S_SYMB AND S_CO_ID = CO_ID AND CO_IN_ID = IN_ID AND IN_SC_ID = SC_ID AND SC_NAME = :sector_name GROUP BY B_NAME ORDER BY 2 DESC
g4gkdzc5fb01z	Select CT_AMT, to_char(CT_DTS, 'mm/dd/YYYY') , Nvl(CT_NAME, chr(0)) From E_CASH_TRANSACTION Where CT_T_ID = :trade_id
gzjm68u0xahd4	SELECT LT_PRICE, LT_OPEN_PRICE, LT_VOL FROM E_LAST_TRADE WHERE LT_S_SYMB = :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

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	199	0.15	0.14
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	6,438	4.77	4.64
Batched IO buffer defrag count	90	0.07	0.06
Batched IO double miss count	536	0.40	0.39
Batched IO same unit count	1,538	1.14	1.11
Batched IO single block count	36	0.03	0.03
Batched IO slow jump count	6	0.00	0.00
Batched IO vector block count	4,812	3.57	3.47
Batched IO vector read count	482	0.36	0.35
Block Cleanout Optim referenced	7	0.01	0.01
CCursor + sql area evicted	99	0.07	0.07
CPU used by this session	107,873	79.94	77.72
CPU used when call started	101,091	74.91	72.83
CR blocks created	654	0.48	0.47
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	16	0.01	0.01
DB time	5,903,930	4,374.98	4,253.55
DBWR checkpoint buffers written	4,466	3.31	3.22
DBWR checkpoints	676	0.50	0.49
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	900	0.67	0.65
DBWR revisited being-written buffer	3	0.00	0.00
DBWR tablespace checkpoint buffers written	102	0.08	0.07
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	171	0.13	0.12
DBWR undo block writes	549	0.41	0.40
DFO trees parallelized	23	0.02	0.02
HSC Heap Segment Block Changes	9,196	6.81	6.63
Heap Segment Array Inserts	98	0.07	0.07
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	247,268	183.23	178.15
PX local messages recv'd	1,795	1.33	1.29
PX local messages sent	1,798	1.33	1.30
Parallel operations downgraded 1 to 25 pct	2	0.00	0.00
Parallel operations downgraded 25 to 50 pct	21	0.02	0.02
Parallel operations downgraded to serial	3,057	2.27	2.20
RowCR - row contention	41	0.03	0.03
RowCR attempts	866	0.64	0.62
RowCR hits	1,139	0.84	0.82
SMON posted for undo segment shrink	4	0.00	0.00
SQL*Net roundtrips to/from client	208,400	154.43	150.14
TBS Extension: tasks created	2	0.00	0.00
TBS Extension: tasks executed	2	0.00	0.00
active txn count during cleanout	3,123	2.31	2.25
application wait time	96,461	71.48	69.50
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	6,522	4.83	4.70
buffer is not pinned count	541,668	401.39	390.25
buffer is pinned count	56,313	41.73	40.57
bytes received via SQL*Net from client	8,330,451	6,173.11	6,001.77
bytes sent via SQL*Net to client	32,778,388	24,289.73	23,615.55
calls to get snapshot scn: kcmgss	133,789	99.14	96.39
calls to kcmgas	3,209	2.38	2.31
calls to kcmgcs	72,126	53.45	51.96
cell physical IO interconnect bytes	258,531,383,296	191,579,231.40	186,261,803.53
change write time	224	0.17	0.16
cleanout - number of ktugct calls	1,839	1.36	1.32
cleanouts and rollbacks - consistent read gets	1,355	1.00	0.98
cleanouts only - consistent read gets	161	0.12	0.12
cluster key scan block gets	2,389	1.77	1.72
cluster key scans	1,243	0.92	0.90
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	8	0.01	0.01
commit batch/immediate requested	8	0.01	0.01
commit cleanout failures: buffer being written	6	0.00	0.00
commit cleanout failures: callback failure	6	0.00	0.00
commit cleanout failures: cannot pin	15	0.01	0.01
commit cleanouts	8,711	6.46	6.28
commit cleanouts successfully completed	8,684	6.44	6.26
commit immediate performed	8	0.01	0.01
commit immediate requested	8	0.01	0.01
commit txn count during cleanout	318	0.24	0.23
concurrency wait time	85,880	63.64	61.87
consistent changes	1,538	1.14	1.11
consistent gets	33,147,548	24,563.29	23,881.52
consistent gets - examination	490,679	363.61	353.52
consistent gets direct	31,331,299	23,217.40	22,572.98
consistent gets from cache	1,816,249	1,345.89	1,308.54
consistent gets from cache (fastpath)	1,310,977	971.47	944.51
cursor authentications	572	0.42	0.41
data blocks consistent reads - undo records applied	19,447	14.41	14.01
db block changes	34,188	25.33	24.63
db block gets	32,062	23.76	23.10
db block gets direct	222	0.16	0.16
db block gets from cache	31,840	23.59	22.94
db block gets from cache (fastpath)	7,575	5.61	5.46
deferred (CURRENT) block cleanout applications	4,172	3.09	3.01
dirty buffers inspected	5	0.00	0.00
enqueue conversions	3,912	2.90	2.82
enqueue releases	37,483	27.78	27.01
enqueue requests	37,745	27.97	27.19
enqueue timeouts	211	0.16	0.15
enqueue waits	802	0.59	0.58
exchange deadlocks	2	0.00	0.00
execute count	136,325	101.02	98.22
failed probes on index block reclamation	0	0.00	0.00
file io service time	172,256	127.65	124.10
file io wait time	4,957,309,085	3,673,509.39	3,571,548.33
flashback log write bytes	23,904,256	17,713.74	17,222.09
flashback log writes	460	0.34	0.33
free buffer inspected	20,298	15.04	14.62
free buffer requested	41,556	30.79	29.94
heap block compress	25	0.02	0.02
hot buffers moved to head of LRU	15,694	11.63	11.31
immediate (CR) block cleanout applications	1,516	1.12	1.09
immediate (CURRENT) block cleanout applications	247	0.18	0.18
index crx upgrade (positioned)	3	0.00	0.00
index fast full scans (full)	417	0.31	0.30
index fetch by key	168,969	125.21	121.74
index scans kdiixs1	17,867	13.24	12.87
leaf node 90-10 splits	38	0.03	0.03
leaf node splits	48	0.04	0.03
lob reads	8	0.01	0.01
lob writes	2	0.00	0.00
lob writes unaligned	2	0.00	0.00
logons cumulative	240	0.18	0.17
max cf enq hold time	90	0.07	0.06
messages received	4,819	3.57	3.47
messages sent	4,819	3.57	3.47
min active SCN optimization applied on CR	4	0.00	0.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	32,570,246	24,135.49	23,465.60
non-idle wait count	563,378	417.48	405.89
non-idle wait time	5,514,828	4,086.65	3,973.22
opened cursors cumulative	21,141	15.67	15.23
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	6,204	4.60	4.47
parse count (total)	20,873	15.47	15.04
parse time cpu	1,886	1.40	1.36
parse time elapsed	59,195	43.87	42.65
physical read IO requests	271,322	201.06	195.48
physical read bytes	258,274,410,496	191,388,807.13	186,076,664.62
physical read total IO requests	274,471	203.39	197.75
physical read total bytes	258,332,882,944	191,432,136.90	186,118,791.75
physical read total multi block requests	247,905	183.70	178.61
physical reads	31,527,638	23,362.89	22,714.44
physical reads cache	37,650	27.90	27.13
physical reads cache prefetch	18,722	13.87	13.49
physical reads direct	31,489,988	23,334.99	22,687.31
physical reads direct (lob)	2	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads for flashback new	384	0.28	0.28
physical reads prefetch warmup	12,449	9.23	8.97
physical write IO requests	2,538	1.88	1.83
physical write bytes	39,362,560	29,168.80	28,359.19
physical write total IO requests	8,862	6.57	6.38
physical write total bytes	152,539,136	113,035.91	109,898.51
physical write total multi block requests	187	0.14	0.13
physical writes	4,805	3.56	3.46
physical writes direct	222	0.16	0.16
physical writes direct (lob)	2	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	4,583	3.40	3.30
physical writes non checkpoint	3,494	2.59	2.52
pinned buffers inspected	257	0.19	0.19
prefetch warmup blocks aged out before use	1,795	1.33	1.29
process last non-idle time	142	0.11	0.10
queries parallelized	23	0.02	0.02
recursive calls	153,515	113.76	110.60
recursive cpu usage	77,167	57.18	55.60
redo blocks checksummed by FG (exclusive)	6,790	5.03	4.89
redo blocks written	19,784	14.66	14.25
redo buffer allocation retries	0	0.00	0.00
redo entries	20,064	14.87	14.46
redo k-bytes read total	0	0.00	0.00
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	444	0.33	0.32
redo size	9,317,440	6,904.49	6,712.85
redo size for direct writes	1,836,296	1,360.75	1,322.98
redo subscn max counts	1,987	1.47	1.43
redo synch time	2,416	1.79	1.74
redo synch writes	1,295	0.96	0.93
redo wastage	555,308	411.50	400.08
redo write time	3,187	2.36	2.30
redo writes	2,136	1.58	1.54
rollback changes - undo records applied	162	0.12	0.12
rollbacks only - consistent read gets	10,492	7.77	7.56
rows fetched via callback	153,816	113.98	110.82
session connect time	0	0.00	0.00
session cursor cache hits	16,463	12.20	11.86
session logical reads	33,179,610	24,587.05	23,904.62
shared hash latch upgrades - no wait	21,320	15.80	15.36
shared hash latch upgrades - wait	2	0.00	0.00
sorts (memory)	11,577	8.58	8.34
sorts (rows)	124,537	92.29	89.72
sql area evicted	5,528	4.10	3.98
sql area purged	0	0.00	0.00
summed dirty queue length	7	0.01	0.01
switch current to new buffer	59	0.04	0.04
table fetch by rowid	197,879	146.63	142.56
table fetch continued row	362	0.27	0.26
table scan blocks gotten	32,483,436	24,071.17	23,403.05
table scan rows gotten	1,811,522,529	1,342,390.58	1,305,131.51
table scans (direct read)	2,240	1.66	1.61
table scans (long tables)	5,681	4.21	4.09
table scans (rowid ranges)	338	0.25	0.24
table scans (short tables)	1,063	0.79	0.77
total cf enq hold time	7,580	5.62	5.46
total number of cf enq holders	138	0.10	0.10
total number of times SMON posted	45	0.03	0.03
transaction rollbacks	8	0.01	0.01
undo change vector size	2,656,212	1,968.33	1,913.70
user I/O wait time	5,283,484	3,915.21	3,806.54
user calls	209,267	155.07	150.77
user commits	1,330	0.99	0.96
user rollbacks	58	0.04	0.04
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	9,797	7.26	7.06
write clones created in background	1	0.00	0.00
write clones created in foreground	22	0.02	0.02

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 uga memory	4,956,587,618,568	5,059,736,169,528
opened cursors current	33	2,269
logons current	33	83
session uga memory max	3,151,897,128	3,564,272,760
session pga memory	3,540,748,312	3,776,182,952
session pga memory max	3,694,364,696	4,155,464,904
session cursor cache count	72,627	75,705

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)	0	0.00

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
ordered by (Data Read + Write) desc

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	240.3G	183.84	182.304	0M	0.00	0M	248.1K	187.14
Buffer Cache Reads	295M	17.27	.218603	0M	0.00	0M	19.5K	379.93
Others	55M	2.33	.040756	91M	1.47	.067433	4384	8.60
DBWR	0M	0.00	0M	35M	1.87	.025936	837	346.45
LGWR	0M	0.00	0M	20M	3.23	.014820	0
Direct Writes	0M	0.00	0M	1M	0.01	.000741	0
Streams AQ	0M	0.01	0M	0M	0.00	0M	10	69.70
TOTAL:	240.6G	203.45	182.564	147M	6.58	.108931	272.8K	198.52

Back to IO Stats
Back to Top

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Small Read and Large Read are average service times, in milliseconds
Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	240.5G	201.17	182.528	38M	1.89	.028159	308.56	187.42
Control File	49M	2.22	.036310	22M	1.01	.016302	3.68	37.67
Flashback Log	3M	0.01	.002223	46M	0.37	.034087	15.88	21.00
Other	3M	0.04	.002223	21M	0.08	.015561	8.00	8.86
Log File	0M	0.00	0M	20M	3.24	.014820
Temp File	0M	0.00	0M	0M	0.00	0M	116.50
TOTAL:	240.6G	203.44	182.568	147M	6.59	.108931	273.77	187.40

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	240.3G	183.84	182.304	0M	0.00	0M	0
Direct Reads (Data File)	240.3G	183.84	182.304	0M	0.00	0M	0
Buffer Cache Reads	294M	17.27	.217862	0M	0.00	0M	18.5K	244.49
Buffer Cache Reads (Data File)	294M	17.27	.217862	0M	0.00	0M	18.5K	244.49
Others	52M	2.29	.038533	70M	1.39	.051872	3601	7.41
Others (Control File)	49M	2.22	.036310	21M	1.01	.015561	2997	3.74
Others (Flashback Log)	3M	0.01	.002223	47M	0.37	.034828	523	27.71
Others (Data File)	0M	0.06	0M	2M	0.01	.001482	81	12.04
DBWR	0M	0.00	0M	35M	1.87	.025936	0
DBWR (Data File)	0M	0.00	0M	35M	1.87	.025936	0
LGWR	0M	0.00	0M	20M	3.24	.014820	0
LGWR (Log File)	0M	0.00	0M	20M	3.24	.014820	0
Direct Writes	0M	0.00	0M	1M	0.01	.000741	0
Direct Writes (Data File)	0M	0.00	0M	1M	0.01	.000741	0
Streams AQ	0M	0.01	0M	0M	0.00	0M	10	69.70
Streams AQ (Data File)	0M	0.01	0M	0M	0.00	0M	10	69.70
TOTAL:	240.6G	203.41	182.561	126M	6.51	.093369	22.1K	205.84

Back to IO Stats
Back to Top

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)
TPCE_TRADE_DATA	248,884	184	3.24	126.11	994	1	244	330.12
TPCE_TRADE_HISTORY_IDX	2,581	2	159.05	1.25	11	0	95	320.21
TPCE_SETTLEMENT_DATA	2,313	2	164.38	1.29	265	0	25	244.40
TPCE_DAILY_MARKET_DATA	2,417	2	57.19	35.45	8	0	1,037	126.75
TPCE_TRADE_HISTORY_DATA	2,368	2	185.03	1.25	29	0	14	165.71
TPCE_CASH_TRANSACTION_DATA	2,227	2	373.42	1.33	143	0	47	231.06
TPCE_TRADE_IDX	2,263	2	236.54	1.59	6	0	16	157.50
TPCE_SETTLEMENT_IDX	2,112	2	126.27	1.27	6	0	20	363.00
TPCE_CASH_TRANSACTION_IDX	2,041	2	253.43	1.27	3	0	27	280.74
SYSTEM	1,044	1	0.00	1.01	42	0	76	20.79
TPCE_DAILY_MARKET_IDX	937	1	130.53	1.82	0	0	6	98.33
UNDOTBS1	292	0	0.00	1.00	341	0	9	7.78
TPCE_REF_DATA	610	0	3.49	4.86	0	0	60	72.83
SYSAUX	155	0	0.00	3.30	450	0	0	0.00
TPCE_WATCH_LIST_DATA	324	0	1.70	15.86	0	0	12	167.50
TPCE_CUSTOMER_DATA	205	0	3.12	56.46	0	0	4	167.50
TPCE_COMPANY_DATA	165	0	1.21	57.43	0	0	4	7.50
TPCE_HOLDING_HISTORY_DATA	16	0	80.63	1.00	88	0	68	2.65
TPCE_WATCH_ITEM_IDX	104	0	256.35	3.64	0	0	7	181.43
TPCE_CUSTOMER_ACCOUNT_DATA	40	0	72.75	9.55	33	0	6	68.33
TPCE_ZIP_CODE_DATA	56	0	190.89	5.89	0	0	11	77.27
TPCE_HOLDING_DATA	4	0	132.50	1.00	46	0	0	0.00
TPCE_HOLDING_SUMMARY_DATA	4	0	92.50	1.00	22	0	0	0.00
TPCE_TRADE_REQUEST_DATA	4	0	115.00	1.00	18	0	0	0.00
TPCE_FINANCIAL_DATA	20	0	187.00	6.70	0	0	3	116.67
TPCE_SECURITY_DATA	18	0	97.22	20.67	0	0	17	114.12
TPCE_NEWS_ITEM_DATA	17	0	136.47	5.18	0	0	2	85.00
TPCE_LAST_TRADE_DATA	4	0	195.00	8.25	12	0	3	0.00
TPCE_ADDRESS_DATA	12	0	140.00	5.25	0	0	20	77.50
TPCE_HOLDING_SUMMARY_IDX	4	0	155.00	1.00	6	0	0	0.00
TPCE_ZIP_CODE_IDX	9	0	44.44	5.33	0	0	24	39.58
TPCE_HOLDING_HISTORY_IDX	4	0	167.50	1.00	4	0	0	0.00
TPCE_HOLDING_IDX	4	0	65.00	1.00	4	0	0	0.00
TPCE_TRADE_REQUEST_IDX	4	0	45.00	1.00	4	0	0	0.00
TPCE_FINANCIAL_IDX	6	0	46.67	5.00	0	0	24	84.17
TPCE_ACCOUNT_PERMISSION_IDX	4	0	222.50	7.50	0	0	0	0.00
TPCE_BROKER_DATA	1	0	70.00	1.00	3	0	6	43.33
TPCE_NEWS_ITEM_IDX	3	0	133.33	9.33	0	0	3	136.67
TPCE_REF_IDX	3	0	200.00	1.00	0	0	11	62.73
TPCE_ADDRESS_IDX	2	0	110.00	14.00	0	0	26	110.00
TPCE_COMPANY_COMPETITOR_IDX	2	0	150.00	14.00	0	0	6	95.00
TPCE_CUSTOMER_ACCOUNT_IDX	2	0	20.00	14.00	0	0	3	20.00
TPCE_CUSTOMER_IDX	2	0	65.00	14.00	0	0	6	38.33
TPCE_LAST_TRADE_IDX	2	0	150.00	14.00	0	0	2	135.00
TPCE_NEWS_XREF_IDX	2	0	160.00	2.50	0	0	1	0.00
TPCE_SECURITY_IDX	2	0	200.00	14.00	0	0	0	0.00
TEMP	1	0	0.00	1.00	0	0	0	0.00
TPCE_BIGTEMP	1	0	190.00	1.00	0	0	0	0.00
TPCE_BROKER_IDX	1	0	370.00	1.00	0	0	5	252.00
TPCE_COMMISSION_RATE_DATA	1	0	260.00	1.00	0	0	4	260.00
TPCE_COMMISSION_RATE_IDX	1	0	50.00	1.00	0	0	4	27.50
TPCE_COMPANY_IDX	1	0	180.00	1.00	0	0	0	0.00
TPCE_INDUSTRY_DATA	1	0	390.00	1.00	0	0	0	0.00
TPCE_INDUSTRY_IDX	1	0	90.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	+DATA/orcl/datafile/sysaux.258.716405081	155	0	0.00	3.30	450	0	0	0.00
SYSTEM	+DATA/orcl/datafile/system.259.716405187	1,044	1	0.00	1.01	42	0	76	20.79
TEMP	+DATA/orcl/tempfile/temp.265.716405987	1	0	0.00	1.00	0	0	0
TPCE_ACCOUNT_PERMISSION_IDX	/u01/app/oradata/TPCE/tpce_account_permission_idx01.dbf	4	0	222.50	7.50	0	0	0	0.00
TPCE_ADDRESS_DATA	/u01/app/oradata/TPCE/tpce_address_data01.dbf	12	0	140.00	5.25	0	0	20	77.50
TPCE_ADDRESS_IDX	/u01/app/oradata/TPCE/tpce_address_idx01.dbf	2	0	110.00	14.00	0	0	26	110.00
TPCE_BIGTEMP	/u01/app/oradata/TPCE/tpce_bigtemp.tmp	1	0	190.00	1.00	0	0	0
TPCE_BROKER_DATA	/u01/app/oradata/TPCE/tpce_broker_data01.dbf	1	0	70.00	1.00	3	0	6	43.33
TPCE_BROKER_IDX	/u01/app/oradata/TPCE/tpce_broker_idx01.dbf	1	0	370.00	1.00	0	0	5	252.00
TPCE_CASH_TRANSACTION_DATA	/u01/app/oradata/TPCE/tpce_cash_transaction_data01.dbf	2,227	2	373.42	1.33	143	0	47	231.06
TPCE_CASH_TRANSACTION_IDX	/u01/app/oradata/TPCE/tpce_cash_transaction_idx01.dbf	2,041	2	253.43	1.27	3	0	27	280.74
TPCE_COMMISSION_RATE_DATA	/u01/app/oradata/TPCE/tpce_commission_rate_data01.dbf	1	0	260.00	1.00	0	0	4	260.00
TPCE_COMMISSION_RATE_IDX	/u01/app/oradata/TPCE/tpce_commission_rate_idx01.dbf	1	0	50.00	1.00	0	0	4	27.50
TPCE_COMPANY_COMPETITOR_IDX	/u01/app/oradata/TPCE/tpce_company_competitor_idx01.dbf	2	0	150.00	14.00	0	0	6	95.00
TPCE_COMPANY_DATA	/u01/app/oradata/TPCE/tpce_company_data01.dbf	165	0	1.21	57.43	0	0	4	7.50
TPCE_COMPANY_IDX	/u01/app/oradata/TPCE/tpce_company_idx01.dbf	1	0	180.00	1.00	0	0	0	0.00
TPCE_CUSTOMER_ACCOUNT_DATA	/u01/app/oradata/TPCE/tpce_customer_account_data01.dbf	40	0	72.75	9.55	33	0	6	68.33
TPCE_CUSTOMER_ACCOUNT_IDX	/u01/app/oradata/TPCE/tpce_customer_account_idx01.dbf	2	0	20.00	14.00	0	0	3	20.00
TPCE_CUSTOMER_DATA	/u01/app/oradata/TPCE/tpce_customer_data01.dbf	205	0	3.12	56.46	0	0	4	167.50
TPCE_CUSTOMER_IDX	/u01/app/oradata/TPCE/tpce_customer_idx01.dbf	2	0	65.00	14.00	0	0	6	38.33
TPCE_DAILY_MARKET_DATA	/u01/app/oradata/TPCE/tpce_daily_market_data01.dbf	2,417	2	57.19	35.45	8	0	1,037	126.75
TPCE_DAILY_MARKET_IDX	/u01/app/oradata/TPCE/tpce_daily_market_idx01.dbf	937	1	130.53	1.82	0	0	6	98.33
TPCE_FINANCIAL_DATA	/u01/app/oradata/TPCE/tpce_financial_data01.dbf	20	0	187.00	6.70	0	0	3	116.67
TPCE_FINANCIAL_IDX	/u01/app/oradata/TPCE/tpce_financial_idx01.dbf	6	0	46.67	5.00	0	0	24	84.17
TPCE_HOLDING_DATA	/u01/app/oradata/TPCE/tpce_holding_data01.dbf	4	0	132.50	1.00	46	0	0	0.00
TPCE_HOLDING_HISTORY_DATA	/u01/app/oradata/TPCE/tpce_holding_history_data01.dbf	16	0	80.63	1.00	88	0	68	2.65
TPCE_HOLDING_HISTORY_IDX	/u01/app/oradata/TPCE/tpce_holding_history_idx01.dbf	4	0	167.50	1.00	4	0	0	0.00
TPCE_HOLDING_IDX	/u01/app/oradata/TPCE/tpce_holding_idx01.dbf	4	0	65.00	1.00	4	0	0	0.00
TPCE_HOLDING_SUMMARY_DATA	/u01/app/oradata/TPCE/tpce_holding_summary_data01.dbf	4	0	92.50	1.00	22	0	0	0.00
TPCE_HOLDING_SUMMARY_IDX	/u01/app/oradata/TPCE/tpce_holding_summary_idx01.dbf	4	0	155.00	1.00	6	0	0	0.00
TPCE_INDUSTRY_DATA	/u01/app/oradata/TPCE/tpce_industry_data01.dbf	1	0	390.00	1.00	0	0	0	0.00
TPCE_INDUSTRY_IDX	/u01/app/oradata/TPCE/tpce_industry_idx01.dbf	1	0	90.00	1.00	0	0	0	0.00
TPCE_LAST_TRADE_DATA	/u01/app/oradata/TPCE/tpce_last_trade_data01.dbf	4	0	195.00	8.25	12	0	3	0.00
TPCE_LAST_TRADE_IDX	/u01/app/oradata/TPCE/tpce_last_trade_idx01.dbf	2	0	150.00	14.00	0	0	2	135.00
TPCE_NEWS_ITEM_DATA	/u01/app/oradata/TPCE/tpce_news_item_data01.dbf	17	0	136.47	5.18	0	0	2	85.00
TPCE_NEWS_ITEM_IDX	/u01/app/oradata/TPCE/tpce_news_item_idx01.dbf	3	0	133.33	9.33	0	0	3	136.67
TPCE_NEWS_XREF_IDX	/u01/app/oradata/TPCE/tpce_news_xref_idx01.dbf	2	0	160.00	2.50	0	0	1	0.00
TPCE_REF_DATA	/u01/app/oradata/TPCE/tpce_ref_data01.dbf	610	0	3.49	4.86	0	0	60	72.83
TPCE_REF_IDX	/u01/app/oradata/TPCE/tpce_ref_idx01.dbf	3	0	200.00	1.00	0	0	11	62.73
TPCE_SECURITY_DATA	/u01/app/oradata/TPCE/tpce_security_data01.dbf	18	0	97.22	20.67	0	0	17	114.12
TPCE_SECURITY_IDX	/u01/app/oradata/TPCE/tpce_security_idx01.dbf	2	0	200.00	14.00	0	0	0	0.00
TPCE_SETTLEMENT_DATA	/u01/app/oradata/TPCE/tpce_settlement_data01.dbf	2,313	2	164.38	1.29	265	0	25	244.40
TPCE_SETTLEMENT_IDX	/u01/app/oradata/TPCE/tpce_settlement_idx01.dbf	2,112	2	126.27	1.27	6	0	20	363.00
TPCE_TRADE_DATA	/u01/app/oradata/TPCE/tpce_trade_data01.dbf	248,884	184	3.24	126.11	994	1	244	330.12
TPCE_TRADE_HISTORY_DATA	/u01/app/oradata/TPCE/tpce_trade_history_data01.dbf	2,368	2	185.03	1.25	29	0	14	165.71
TPCE_TRADE_HISTORY_IDX	/u01/app/oradata/TPCE/tpce_trade_history_idx01.dbf	2,581	2	159.05	1.25	11	0	95	320.21
TPCE_TRADE_IDX	/u01/app/oradata/TPCE/tpce_trade_idx01.dbf	2,263	2	236.54	1.59	6	0	16	157.50
TPCE_TRADE_REQUEST_DATA	/u01/app/oradata/TPCE/tpce_trade_request_data01.dbf	4	0	115.00	1.00	18	0	0	0.00
TPCE_TRADE_REQUEST_IDX	/u01/app/oradata/TPCE/tpce_trade_request_idx01.dbf	4	0	45.00	1.00	4	0	0	0.00
TPCE_WATCH_ITEM_IDX	/u01/app/oradata/TPCE/tpce_watch_item_idx01.dbf	104	0	256.35	3.64	0	0	7	181.43
TPCE_WATCH_LIST_DATA	/u01/app/oradata/TPCE/tpce_watch_list_data01.dbf	324	0	1.70	15.86	0	0	12	167.50
TPCE_ZIP_CODE_DATA	/u01/app/oradata/TPCE/tpce_zip_code_data01.dbf	56	0	190.89	5.89	0	0	11	77.27
TPCE_ZIP_CODE_IDX	/u01/app/oradata/TPCE/tpce_zip_code_idx01.dbf	9	0	44.44	5.33	0	0	24	39.58
UNDOTBS1	+DATA/orcl/datafile/undotbs1.260.716405283	292	0	0.00	1.00	341	0	9	7.78

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

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	52,046	98	1,847,715	37,637	4,583	0	0	1,958

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 4,805

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	3,464	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
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 RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	21	369	1313	2360	424602	2360
E	0	21	379	2719	21163	424602	21163

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

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 (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	40	0.09	5	2.16	161	1	14053.00
D	80	0.19	10	1.20	89	1	6375.00
D	120	0.28	15	1.07	80	1	5365.00
D	160	0.38	20	1.04	77	1	5097.00
D	200	0.47	25	1.01	75	1	4927.00
D	240	0.57	29	1.00	75	1	4848.00
D	280	0.66	34	1.00	75	1	4833.00
D	320	0.75	39	1.00	75	1	4829.00
D	360	0.85	44	1.00	75	1	4824.00
D	400	0.94	49	1.00	74	1	4820.00
D	424	1.00	52	1.00	74	1	4815.00
D	440	1.04	54	1.00	74	1	4804.00
D	480	1.13	59	1.00	74	1	4801.00
D	520	1.23	64	1.00	74	1	4801.00
D	560	1.32	69	1.00	74	1	4801.00
D	600	1.42	74	1.00	74	1	4801.00
D	640	1.51	79	1.00	74	1	4801.00
D	680	1.60	83	1.00	74	1	4801.00
D	720	1.70	88	0.97	72	1	4599.00
D	760	1.79	93	0.94	70	1	4374.00
D	800	1.89	98	0.90	67	1	4049.00

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	571	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	150	9	202.59	0.00	0.00	0.00	0.00	30,720
E	150	9	435.93	0.00	0.00	0.00	0.00	30,720

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	9,041	9,041
64K	128K	24	24
512K	1024K	656	656
1M	2M	68	68
4M	8M	2	2

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	Estd Time
19	0.13	1,801.94	833.07	68.00	137	2,359,873
38	0.25	1,801.94	833.07	68.00	137	2,359,873
75	0.50	1,801.94	833.07	68.00	137	2,359,873
113	0.75	1,801.94	828.81	68.00	136	2,356,059
150	1.00	1,801.94	17.57	99.00	135	1,629,524
180	1.20	1,801.94	9.14	99.00	129	1,621,979
210	1.40	1,801.94	4.16	100.00	123	1,617,515
240	1.60	1,801.94	4.16	100.00	112	1,617,515
270	1.80	1,801.94	0.00	100.00	108	1,613,792
300	2.00	1,801.94	0.00	100.00	108	1,613,792
450	3.00	1,801.94	0.00	100.00	0	1,613,792
600	4.00	1,801.94	0.00	100.00	0	1,613,792
900	6.00	1,801.94	0.00	100.00	0	1,613,792
1,200	8.00	1,801.94	0.00	100.00	0	1,613,792

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 (K)
236	0.79	19	2,852	25,920	0.99	1,124	1.24	230
268	0.89	51	6,021	26,013	1.00	1,031	1.14	386
300	1.00	83	8,053	26,138	1.00	906	1.00	388
332	1.11	115	10,132	26,203	1.00	841	0.93	389
364	1.21	147	11,898	26,228	1.00	816	0.90	390
396	1.32	179	13,224	26,236	1.00	808	0.89	390
428	1.43	211	14,599	26,238	1.00	806	0.89	390
460	1.53	243	16,048	26,239	1.00	805	0.89	390
492	1.64	270	17,272	26,240	1.00	804	0.89	391
524	1.75	279	17,710	26,240	1.00	804	0.89	391
556	1.85	279	17,710	26,240	1.00	804	0.89	391
588	1.96	279	17,710	26,240	1.00	804	0.89	391
620	2.07	279	17,710	26,240	1.00	804	0.89	391

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
376	0.50	58,551	88,998
564	0.75	56,887	74,673
752	1.00	56,767	74,494
940	1.25	56,740	74,233
1,128	1.50	56,024	67,208
1,316	1.75	55,985	67,208
1,504	2.00	55,985	67,208

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
4	1.00	0	0	0	0
8	2.00	0	0	0	0
12	3.00	0	0	0	0
16	4.00	0	0	0	0
20	5.00	0	0	0	0
24	6.00	0	0	0	0
28	7.00	0	0	0	0
32	8.00	0	0	0	0
36	9.00	0	0	0	0
40	10.00	0	0	0	0
44	11.00	0	0	0	0
48	12.00	0	0	0	0
52	13.00	0	0	0	0
56	14.00	0	0	0	0
60	15.00	0	0	0	0
64	16.00	0	0	0	0
68	17.00	0	0	0	0
72	18.00	0	0	0	0
76	19.00	0	0	0	0
80	20.00	0	0	0	0

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,653	248	150
extent map	60	29	487
segment header	138	17	120
1st level bmb	67	10	152
2nd level bmb	31	1	48
undo header	6	0	7
undo block	3	0	10

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	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
KO-Multiple Object Checkpoint (fast object checkpoint)	6,084	6,084	0	666	900	1,351.68
TX-Transaction (row lock contention)	27	27	0	27	63	2,341.48
PR-Process Startup	103	103	0	4	30	7,580.00
TX-Transaction (index contention)	23	23	0	23	6	272.17
HW-Segment High Water Mark	200	200	0	38	2	59.21
CF-Controlfile Transaction	717	717	0	1	1	1,030.00
TX-Transaction	1,908	1,908	0	13	1	55.38
FB-Format Block	86	86	0	5	0	30.00
PS-PX Process Reservation	636	434	202	23	0	4.78
BF-BLOOM FILTER (allocation contention)	21	18	3	2	0	35.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
2	0.39	1,771	752	21	24.1/25.6	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
24-Nov 12:06	129	979	665	8	24	0/0	0/0/0/0/0/0
24-Nov 11:56	261	792	752	21	26	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
Mutex Sleep Summary
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
AQ deq hash table latch	1	0.00		0	0
AQ deq log cmt cbk chunk latch	0			0	2	0.00
AQ ht cmt cbk chunk latch	0			0	2	0.00
ASM Keyed state latch	369	0.00		0	0
ASM allocation	127	0.00		0	0
ASM db client latch	1,971	0.00		0	0
ASM map headers	90	0.00		0	0
ASM map load waiting list	15	0.00		0	0
ASM map operation freelist	212	0.00		0	0
ASM map operation hash table	62,763	0.00		0	0
ASM network background latch	796	0.00		0	0
ASM network state latch	57	0.00		0	0
AWR Alerted Metric Element list	11,653	0.00		0	0
Bloom filter list latch	9	0.00		0	0
Change Notification Hash table latch	455	0.00		0	0
Consistent RBA	2,136	0.00		0	0
DML lock allocation	10,180	0.00		0	0
Event Group Locks	156	0.00		0	0
FAL Queue	34	0.00		0	0
FIB s.o chain latch	54	0.00		0	0
FOB s.o list latch	2,102	2.47	1.04	12	0
File State Object Pool Parent Latch	1	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	1	0.00		0	0
JS Sh mem access	3	0.00		0	0
JS broadcast autostart latch	21	0.00		0	0
JS mem alloc latch	4	0.00		0	0
JS queue access latch	5	0.00		0	0
JS queue state obj latch	16,462	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KFK SGA Libload latch	472	0.00		0	0
KFMD SGA	357	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	1	0.00		0	0
KJCT flow control latch	1	0.00		0	0
KMG MMAN ready and startup request latch	454	0.00		0	0
KMG resize request state object freelist	8	0.00		0	0
KTF sga latch	8	0.00		0	389	0.00
KWQMN job cache list latch	2	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	12	0.00		0	0
KWQS pqueue ctx latch	37	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	423	0.00		0	0
MQL Tracking Latch	0			0	26	0.00
Memory Management Latch	137	0.00		0	454	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	8	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	2,030	0.00		0	0
OS process allocation	1,078	0.00		0	0
OS process: request allocation	220	0.00		0	0
PL/SQL warning settings	1,251	0.00		0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	13,501	1.36	0.23	1	4	0.00
Reserved Space Latch	30	0.00		0	0
SGA IO buffer pool latch	344	2.03	1.00	1	344	8.43
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	1,467	1.36	0.90	0	447	0.00
SQL memory manager workarea list latch	133,987	0.00		0	0
Shared B-Tree	140	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	363	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	6,008	0.00		0	0
active service list	5,067	0.04	0.50	0	3,050	0.00
archive control	22	0.00		0	0
archive process latch	102	0.00		0	0
begin backup scn array	21	0.00		0	0
buffer pool	18	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	3,576	0.11	0.25	0	0
cache buffers chains	3,358,455	0.02	0.37	13	221,980	0.05
cache buffers lru chain	23,955	0.57	0.89	5	367,278	1.59
cache table scan latch	475	0.00		0	475	0.00
call allocation	2,310	0.48	0.73	0	2	0.00
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	349	0.00		0	0
channel operations parent latch	16,902	0.00		0	0
checkpoint queue latch	38,907	0.00		0	7,463	0.00
client/application info	1,544	0.00		0	0
compile environment latch	246	0.00		0	0
corrupted undo seg latch	494	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	27	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	27	0.00		0	0
dml lock allocation	43	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	443	0.23	1.00	0	0
enqueue hash chains	80,855	0.05	0.51	0	330	0.00
enqueues	61,112	0.03	0.37	0	0
error message lists	215	1.40	0.00	0	0
fifth spare latch	1	0.00		0	0
file cache latch	663	0.00		0	0
flashback FBA barrier	1	0.00		0	0
flashback SCN barrier	2	0.00		0	0
flashback allocation	5,144	0.00		0	0
flashback copy	1	0.00		0	3,826	0.05
flashback hint SCN barrier	1	0.00		0	0
flashback mapping	455	0.00		0	0
flashback marker cache	1	0.00		0	0
flashback sync request	442	0.00		0	0
gc element	1	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs partitioned table hash	1	0.00		0	0
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs resource freelist	1	0.00		0	0
gcs resource hash	1	0.00		0	0
gcs resource scan list	1	0.00		0	0
gcs shadows freelist	1	0.00		0	0
ges domain table	1	0.00		0	0
ges enqueue table freelist	1	0.00		0	0
ges group table	1	0.00		0	0
ges process hash list	1	0.00		0	0
ges process parent latch	1	0.00		0	0
ges resource hash list	1	0.00		0	0
ges resource scan list	1	0.00		0	0
ges resource table freelist	1	0.00		0	0
ges value block free list	1	0.00		0	0
global KZLD latch for mem in SGA	50	0.00		0	0
global ctx hash table latch	2	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	362	0.28	1.00	0	30,882	0.17
hash table modification latch	97	0.00		0	0
heartbeat check	1	0.00		0	0
hint flashback FBA barrier	1	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	25	0.00		0	24	0.00
job_queue_processes free list latch	50	0.00		0	0
job_queue_processes parameter latch	293	0.00		0	0
k2q lock allocation	1	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kks stats	31,508	0.21	0.97	10	0
kokc descriptor allocation latch	234	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	33	0.00		0	0
ksuosstats global area	94	0.00		0	0
ksv allocation latch	90	0.00		0	0
ksv class latch	314	0.00		0	0
ksv instance latch	8	0.00		0	0
ksv msg queue latch	37	0.00		0	36	0.00
ksz_so allocation latch	220	0.00		0	0
ktm global data	19	0.00		0	0
kwqbsn:qsga	51	0.00		0	0
lgwr LWN SCN	2,282	0.00		0	0
list of block allocation	182	0.00		0	0
loader state object freelist	4,506	0.07	1.00	0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	5	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	2	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	842	0.00		0	237	0.42
managed standby latch	34	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	2,191	0.00		0	0
messages	28,245	0.02	0.00	0	0
mostly latch-free SCN	2,283	0.00		0	0
msg queue latch	1	0.00		0	0
multiblock read objects	5,506	0.04	0.00	0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	27	0.00		0	0
object queue header heap	5,559	0.00		0	484	0.00
object queue header operation	101,444	0.04	0.28	0	2,890	3.15
object stats modification	309	0.00		0	0
parallel query alloc buffer	1,787	1.12	0.90	0	0
parallel query stats	185	1.62	0.00	0	0
parameter list	1,353	0.00		0	0
parameter table management	451	0.00		0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	2,022	0.00		0	1,342	0.00
process allocation	3,358	0.92	9.48	4	155	0.00
process group creation	220	0.00		0	0
process queue	2,981	0.00		0	0
process queue reference	50,266	0.01	0.17	0	2,844	0.25
qmn task queue latch	200	0.00		0	0
query server freelists	954	0.21	0.00	0	0
query server process	46	39.13	2.06	23	4	50.00
queued dump request	5	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	6,752	0.06	1.00	0	20,032	0.17
redo copy	5	0.00		0	20,045	0.23
redo writing	10,091	0.01	0.00	0	0
reservation so alloc latch	12	0.00		0	0
resmgr group change latch	289	0.00		0	0
resmgr:active threads	443	0.00		0	0
resmgr:actses change group	200	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	442	0.00		0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	118	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	299,914	0.05	0.37	3	2,075	0.19
rules engine aggregate statistics	2	0.00		0	0
rules engine rule set statistics	104	0.00		0	0
second spare latch	1	0.00		0	0
segmented array pool	30	0.00		0	0
sequence cache	242	0.00		0	0
session allocation	5,403	0.00		0	1,826	0.11
session idle bit	420,127	0.01	0.19	0	0
session queue latch	1	0.00		0	0
session state list latch	424	0.00		0	0
session switching	353	0.00		0	0
session timer	570	0.00		0	0
shared pool	317,474	0.99	0.61	271	0
shared pool sim alloc	423	0.00		0	0
shared pool simulator	51,024	0.01	0.67	0	0
sim partition latch	1	0.00		0	0
simulator hash latch	146,769	0.00	1.00	0	0
simulator lru latch	2,480	0.04	1.00	0	119,706	0.26
sort extent pool	90	0.00		0	0
space background state object latch	2	0.00		0	0
space background task latch	1,003	0.10	1.00	0	902	0.00
state object free list	2	0.00		0	0
statistics aggregation	2,520	0.00		0	0
tablespace key chain	119	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
third spare latch	1	0.00		0	0
threshold alerts latch	350	0.00		0	0
trace latch	76	0.00		0	0
transaction allocation	489	0.00		0	0
undo global data	29,312	0.01	0.00	0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	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
shared pool	317,474	3,152	1,924	1,548
cache buffers chains	3,358,455	756	276	499
Real-time plan statistics latch	13,501	183	42	143
row cache objects	299,914	159	59	100
cache buffers lru chain	23,955	137	122	22
kks stats	31,508	65	63	2
FOB s.o list latch	2,102	52	54	0
session idle bit	420,127	47	9	40
enqueue hash chains	80,855	37	19	18
object queue header operation	101,444	36	10	26
process allocation	3,358	31	294	2
SQL memory manager latch	1,467	20	18	2
parallel query alloc buffer	1,787	20	18	7
enqueues	61,112	19	7	12
query server process	46	18	37	0
call allocation	2,310	11	8	3
SGA IO buffer pool latch	344	7	7	0
process queue reference	50,266	6	1	5
cache buffer handles	3,576	4	1	3
redo allocation	6,752	4	4	0
loader state object freelist	4,506	3	3	0
shared pool simulator	51,024	3	2	1
active service list	5,067	2	1	1
dummy allocation	443	1	1	0
hash table column usage latch	362	1	1	0
simulator hash latch	146,769	1	1	0
simulator lru latch	2,480	1	1	0
space background task latch	1,003	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
FOB s.o list latch	ksfd_allfob	54	54
Real-time plan statistics latch	keswxAddNewPlanEntry	42	42
SGA IO buffer pool latch	ksfd_free_sgabuffer	5	7
SGA IO buffer pool latch	ksfd_alloc_sgabuffer	2	0
SQL memory manager latch	qesmmIQueryRefreshBound	18	18
active service list	kswslogon: session logout	1	0
cache buffer handles	kcbzgs	1	1
cache buffers chains	kcbgtcr: fast path (cr pin)	132	96
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	50	2
cache buffers chains	kcbzwb	36	49
cache buffers chains	kcbgtcr: fast path	20	19
cache buffers chains	kcbrls_2	17	12
cache buffers chains	kcbgtcr_2	13	11
cache buffers chains	kcbrls_1	9	70
cache buffers chains	kcbgtcr: kslbegin excl	5	9
cache buffers chains	kcbgtcr: kslbegin shared	5	1
cache buffers chains	kcbzibmlt: prewarm reads: nowait get	4	0
cache buffers chains	kcbnlc	2	14
cache buffers chains	kcbzibmlt: multi-block read: nowait	2	0
cache buffers chains	kcbbic2	1	0
cache buffers chains	kcbgcur: fast path (shr)	1	3
cache buffers chains	kcbgcur_2	1	1
cache buffers chains	kcbgcur_6	1	1
cache buffers chains	kcbget: pin buffer	1	1
cache buffers chains	kcbgtcr_1	1	0
cache buffers chains	kcbzgb: scan from tail. nowait	1	0
cache buffers chains	kcbzib: finish processing buffer	1	2
cache buffers chains	kcbzibmlt: exchange rls	1	0
cache buffers lru chain	kcbzgws	39	37
cache buffers lru chain	kcbz_prewarm_islocal	37	1
cache buffers lru chain	kcbzgpwb: KSLBEGIN use prewarm buffers	32	65
cache buffers lru chain	kcbzar: KSLNBEGIN	5	0
cache buffers lru chain	kcbzgm	5	0
cache buffers lru chain	kcbzfw	2	0
cache buffers lru chain	kcbbic2	1	10
cache buffers lru chain	kcbz_decr_wspwbcnt	1	6
call allocation	ksuxds	5	3
call allocation	ksuprc	2	2
call allocation	kxfpRecvSessStats	1	2
dummy allocation	ktcdod	1	1
enqueue hash chains	ksqgtl3	9	15
enqueue hash chains	ksqrcl	8	6
enqueue hash chains	ksqcmi: kslgpl	2	0
enqueues	ksqdel	3	4
enqueues	ksqgel: create enqueue	2	6
enqueues	ksqgtl2	2	0
hash table column usage latch	KSXMMON_GETCELEM	1	0
kks stats	kksAllocChildStat	63	63
loader state object freelist	kcblgs	3	3
object queue header operation	kcbo_link_q	4	2
object queue header operation	kcbo_switch_cq	2	4
object queue header operation	kcbw_make_free_nowait	2	0
object queue header operation	kcbo_unlink_q	1	0
object queue header operation	kcbo_unlink_q_bg	1	0
object queue header operation	kcbo_write_q	1	0
parallel query alloc buffer	kxfpbalo	13	8
parallel query alloc buffer	kxfpbfre	5	10
process allocation	ksuapc	262	0
process allocation	ksufap: active procs	31	294
process allocation	ksucrp:1	1	0
process queue reference	kxfpqrsnd	1	0
query server process	kxfpg1srv	37	37
redo allocation	kcrfw_redo_gen: redo allocation 1	3	0
redo allocation	kcrfw_redo_gen: redo allocation 2	1	0
row cache objects	kqreqd: reget	37	0
row cache objects	kqrpre: find obj	14	49
row cache objects	kqrpre: init complete	2	2
row cache objects	kqreqd	1	4
row cache objects	kqrso	1	0
session idle bit	ksupuc: set busy	9	5
session idle bit	ksupuc: clear busy	3	7
shared pool	kghalo	713	724
shared pool	kghupr1	563	718
shared pool	kghalp	473	325
shared pool	kghfre	53	69
shared pool	kgh_heap_sizes	47	40
shared pool	kgh: add to quiesced list check	36	19
shared pool	kghasp	19	20
shared pool	kghquiesce_extent choose ds	9	0
shared pool	kghquiesce_extent quiesced if free	4	0
shared pool	kghfrunp: alloc: cursor dur	3	3
shared pool	kghfree_extents: scan	2	4
shared pool	kghfrunp: clatch: nowait	2	0
shared pool	kghfrunp: clatch: wait	2	4
shared pool	kgh: sim resz update	1	2
shared pool	kghfru	1	0
shared pool simulator	kglsim_upd_newhp	2	1
simulator hash latch	kcbsacc: lookup dba	1	1
simulator lru latch	kcbs_simulate: simulate set	1	0
space background task latch	ktsjCreateTask	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Cursor Pin	kkslce [KKSCHLPIN2]	35,821	1
Library Cache	kglhdgh1 64	13,250	16
Library Cache	kglpin1 4	9,360	3
Library Cache	kglhdgn2 106	5,664	0
Library Cache	kglget2 2	5,179	3
Library Cache	kglhdgn1 62	3,591	82
Library Cache	kgllkdl1 85	2,277	1
Cursor Pin	kksfbc [KKSCHLPIN1]	112	0
Cursor Pin	kksfbc [KKSCHLFSP2]	9	0
Library Cache	kgldtin1 42	5	4,042
Library Cache	kglobpn1 71	5	0
Library Cache	kglpndl1 95	3	5,823
Library Cache	kglati1 45	1	5
Library Cache	kglkhfs1 52	1	4,653
Library Cache	kglllal3 111	1	3
Cursor Pin	kksLockDelete [KKSCHLPIN6]	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 Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 33,179,610
Captured Segments account for 99.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TPCE	TPCE_TRADE_DATA	E_TRADE	TABLE	31,268,448	94.24
TPCE	TPCE_DAILY_MARKET_DATA	E_DAILY_MARKET	TABLE	1,157,936	3.49
TPCE	TPCE_DAILY_MARKET_IDX	E_DAILY_MARKET_PK_IDX	INDEX	96,352	0.29
TPCE	TPCE_SECURITY_DATA	E_SECURITY	TABLE	84,288	0.25
TPCE	TPCE_SECURITY_IDX	E_SECURITY_PK_IDX	INDEX	73,232	0.22

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 31,527,638
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
TPCE	TPCE_TRADE_DATA	E_TRADE	TABLE	31,385,936	99.55
TPCE	TPCE_DAILY_MARKET_DATA	E_DAILY_MARKET	TABLE	85,675	0.27
TPCE	TPCE_CUSTOMER_DATA	E_CUSTOMER	TABLE	11,574	0.04
TPCE	TPCE_COMPANY_DATA	E_COMPANY	TABLE	9,476	0.03
TPCE	TPCE_WATCH_LIST_DATA	E_WATCH_LIST	TABLE	5,139	0.02

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 271,322
Captured Segments account for 99.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
TPCE	TPCE_TRADE_DATA	E_TRADE	TABLE	248,882	91.73
TPCE	TPCE_TRADE_HISTORY_IDX	E_TRADE_HISTORY_PK_IDX	INDEX	2,581	0.95
TPCE	TPCE_DAILY_MARKET_DATA	E_DAILY_MARKET	TABLE	2,417	0.89
TPCE	TPCE_TRADE_HISTORY_DATA	E_TRADE_HISTORY	TABLE	2,368	0.87
TPCE	TPCE_SETTLEMENT_DATA	E_SETTLEMENT	TABLE	2,313	0.85

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 271,322
Captured Segments account for 99.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
TPCE	TPCE_TRADE_DATA	E_TRADE	TABLE	248,882	91.73
TPCE	TPCE_TRADE_HISTORY_IDX	E_TRADE_HISTORY_PK_IDX	INDEX	2,581	0.95
TPCE	TPCE_DAILY_MARKET_DATA	E_DAILY_MARKET	TABLE	2,417	0.89
TPCE	TPCE_TRADE_HISTORY_DATA	E_TRADE_HISTORY	TABLE	2,368	0.87
TPCE	TPCE_SETTLEMENT_DATA	E_SETTLEMENT	TABLE	2,313	0.85

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 31,489,988
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Direct Reads	%Total
TPCE	TPCE_TRADE_DATA	E_TRADE	TABLE	31,382,208	99.66
TPCE	TPCE_DAILY_MARKET_DATA	E_DAILY_MARKET	TABLE	77,568	0.25
TPCE	TPCE_CUSTOMER_DATA	E_CUSTOMER	TABLE	11,520	0.04
TPCE	TPCE_COMPANY_DATA	E_COMPANY	TABLE	9,420	0.03
TPCE	TPCE_WATCH_LIST_DATA	E_WATCH_LIST	TABLE	5,136	0.02

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 4,805
Captured Segments account for 70.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
TPCE	TPCE_TRADE_DATA	E_TRADE		TABLE	995	20.71
TPCE	TPCE_HOLDING_HISTORY_DATA	E_HOLDING_HISTORY		TABLE	772	16.07
TPCE	TPCE_SETTLEMENT_DATA	E_SETTLEMENT		TABLE	340	7.08
TPCE	TPCE_CASH_TRANSACTION_DATA	E_CASH_TRANSACTION		TABLE	309	6.43
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	237	4.93

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 2,538
Captured Segments account for 69.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
TPCE	TPCE_TRADE_DATA	E_TRADE	TABLE	994	39.16
TPCE	TPCE_SETTLEMENT_DATA	E_SETTLEMENT	TABLE	265	10.44
TPCE	TPCE_CASH_TRANSACTION_DATA	E_CASH_TRANSACTION	TABLE	143	5.63
TPCE	TPCE_HOLDING_HISTORY_DATA	E_HOLDING_HISTORY	TABLE	87	3.43
TPCE	TPCE_CUSTOMER_ACCOUNT_DATA	E_CUSTOMER_ACCOUNT	TABLE	33	1.30

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 222
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1200893776_2190	TABLE PARTITION	220	99.10
SYS	SYSAUX	SYS_LOB0000005938C00038$$		LOB	2	0.90

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 6,098
Captured Segments account for 93.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
TPCE	TPCE_TRADE_DATA	E_TRADE	TABLE	951	15.60
TPCE	TPCE_SECURITY_DATA	E_SECURITY	TABLE	787	12.91
TPCE	TPCE_REF_DATA	E_TRADE_TYPE	TABLE	685	11.23
TPCE	TPCE_TRADE_REQUEST_DATA	E_TRADE_REQUEST	TABLE	650	10.66
TPCE	TPCE_REF_DATA	E_STATUS_TYPE	TABLE	635	10.41

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
TPCE	TPCE_HOLDING_HISTORY_DATA	E_HOLDING_HISTORY	TABLE	1,456	11.48
TPCE	TPCE_TRADE_HISTORY_IDX	E_TRADE_HISTORY_PK_IDX	INDEX	1,376	10.84
TPCE	TPCE_HOLDING_SUMMARY_DATA	E_HOLDING_SUMMARY	TABLE	992	7.82
TPCE	TPCE_HOLDING_SUMMARY_IDX	E_HOLDING_SUMMARY_PK_IDX	INDEX	944	7.44
TPCE	TPCE_HOLDING_HISTORY_IDX	E_HOLDING_HISTORY_PK_IDX	INDEX	832	6.56

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
TPCE	TPCE_BROKER_DATA	E_BROKER	TABLE	26	52.00
TPCE	TPCE_TRADE_HISTORY_IDX	E_TRADE_HISTORY_PK_IDX	INDEX	21	42.00
TPCE	TPCE_HOLDING_SUMMARY_IDX	E_HOLDING_SUMMARY_PK_IDX	INDEX	2	4.00
TPCE	TPCE_TRADE_DATA	E_TRADE	TABLE	1	2.00

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	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
TPCE	TPCE_HOLDING_HISTORY_DATA	E_HOLDING_HISTORY		TABLE	68	61.26
TPCE	TPCE_TRADE_HISTORY_IDX	E_TRADE_HISTORY_PK_IDX		INDEX	37	33.33
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	2	1.80
TPCE	TPCE_BROKER_DATA	E_BROKER		TABLE	2	1.80
TPCE	TPCE_LAST_TRADE_DATA	E_LAST_TRADE		TABLE	1	0.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	38	0.00	2	1
dc_global_oids	1,828	0.71	0	89
dc_histogram_data	1,600	7.44	0	1,563
dc_histogram_defs	19,624	6.64	0	3,380
dc_object_grants	138	5.07	0	107
dc_objects	27,925	0.91	4	2,720
dc_profiles	75	0.00	0	2
dc_rollback_segments	584	0.00	0	39
dc_segments	23,449	0.55	49	1,011
dc_sequences	1	100.00	1	5
dc_tablespaces	7,940	0.00	0	83
dc_users	16,530	0.01	0	111
global database name	1,021	0.00	0	1
outstanding_alerts	161	0.62	2	80
sch_lj_oids	3	0.00	0	6

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
APP CONTEXT	7	14.29	7	14.29	0	0
BODY	488	1.23	1,085	4.33	41	0
CLUSTER	39	2.56	26	3.85	0	0
DBLINK	105	1.90	0		0	0
EDITION	88	0.00	162	0.00	0	0
INDEX	25	56.00	25	56.00	0	0
QUEUE	24	0.00	76	0.00	0	0
RULESET	2	0.00	2	0.00	0	0
SCHEMA	352	0.00	0		0	0
SQL AREA	25,216	65.88	152,708	11.95	302	28
SUBSCRIPTION	5	0.00	5	0.00	0	0
TABLE/PROCEDURE	20,126	0.39	29,736	2.79	545	0
TRIGGER	12	8.33	25	16.00	3	0

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

Min/Max sizes since instance startup
Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
ordered by Component

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	420.00	424.00	396.00	432.00	4	GRO/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	152.00	152.00	152.00	152.00	0	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	752.00	752.00	752.00	752.00	0	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	4.00	4.00	4.00	4.00	0	STA/
large pool	8.00	8.00	8.00	8.00	0	STA/
shared pool	304.00	300.00	292.00	328.00	4	SHR/DEF
streams pool	4.00	4.00	4.00	4.00	0	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

Resizes, Grows, Shrinks - Operations captured by AWR if there are operations on the same component for the same operation_type, target_size, and with the same start_time only one operation is captured
ordered by Component

Component	Min Size (Mb)	Max Size (Mb)	Avg Size (Mb)	Re- Sizes	Grows	Shrinks
DEFAULT buffer cache	396.00	424.00	410.00	4	2	2
shared pool	300.00	328.00	314.00	4	2	2

Back to Memory Statistics
Back to Top

Memory Resize Ops

Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred Delta : change in size of the component Target Delta: displayed only if final size <> target_size
Status: COMplete/CANcelled/INActive/PENding/ERRor
ordered by start_time desc,component

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Final (M)	Sta
11/24 12:05:10	3	bufcache	GRO/DEF	412	12	424	COM
11/24 12:05:10	3	shared	SHR/DEF	312	-12	300	COM
11/24 12:03:10	9	bufcache	GRO/DEF	396	16	412	COM
11/24 12:03:10	9	shared	SHR/DEF	328	-16	312	COM
11/24 11:54:08	8	bufcache	SHR/DEF	408	-12	396	COM
11/24 11:54:08	8	shared	GRO/DEF	316	12	328	COM
11/24 11:50:35	1	bufcache	SHR/DEF	420	-12	408	COM
11/24 11:50:35	1	shared	GRO/DEF	304	12	316	COM

Back to Memory Statistics
Back to Top

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	178.30		5.09	8.26	30	31	35	35
	Freeable	22.88	0.00	2.86	6.27	18		8	8
	SQL	0.93	0.74	0.07	0.20	1	2	13	8
	PL/SQL	0.50	0.40	0.02	0.04	0	1	33	33
E	Other	372.35		2.98	4.64	30	31	125	125
	Freeable	51.75	0.00	0.72	0.39	1		72	72
	SQL	6.85	3.12	0.07	0.09	1	6	93	60
	PL/SQL	5.03	4.33	0.04	0.05	0	0	123	95

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	440,401,920	444,596,224
Fixed Size	2,217,712
Redo Buffers	6,721,536
Variable Size	360,712,464	356,518,160

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	ASM map operations hashta	0.38	0.38	0.00
large	PX msg pool	6.56	6.56	0.00
large	free memory	1.06	1.06	0.00
shared	ASH buffers	4.00	4.00	0.00
shared	CCUR	22.56	24.95	10.61
shared	FileOpenBlock	3.79	3.79	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGLH0	9.95	5.57	-44.04
shared	KGLHD	9.06	10.39	14.67
shared	KGLS	15.02	3.72	-75.22
shared	KGLSG	5.02	5.02	0.00
shared	KKSSP		3.00
shared	KQR L PO	3.60		-100.00
shared	KQR M PO	3.14		-100.00
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	PCUR	11.42	26.56	132.57
shared	PLDIA	5.17		-100.00
shared	PLMCD	11.82	6.12	-48.24
shared	SQLA	80.63	54.12	-32.88
shared	SQLP	3.32		-100.00
shared	dbwriter coalesce buffer	3.79	3.79	0.00
shared	event statistics per sess		3.03
shared	flashback generation buff	3.80	3.80	0.00
shared	free memory	31.33	57.53	83.64
shared	kglsim hash table bkts	4.00	4.00	0.00
shared	private strands	3.51	3.51	0.00
shared	row cache	7.23	7.23	0.00
streams	KTG hash buckets	1.26	1.26	0.00
streams	free memory	2.73	2.73	0.00
	buffer_cache	420.00	424.00	0.95
	fixed_sga	2.11	2.11	0.00
	log_buffer	6.41	6.41	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by Foreground CPU Time, descending

Session Type	First Logon	Foreground CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	1123 18:57:48	0.05	0.70	0.00
QMON Coordinator	1123 18:57:38	0.02	0.00	0.00

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 Capture Rate

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

Streams Apply Rate

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 Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Rule Sets ordered by Evaluations
* indicates Rule Set activity (re)started between Begin/End snaps
SQL per Eval - average # of SQL statements executed for non-SQL free evals
CPU(s),Ela(s) per Eval - avg CPU and Elapsed time per evaluation includes both SQL free and non-SQL free evals

Rule	Evals	No-SQL Eval%	SQL Execs	CPU(s)	Ela(s)	Eval /Sec	SQL per Eval	Ela(s) per Eval	CPU(s) per Eval	Reloads
SYS.ALERT_QUE_R	2	0.00	0	0.00	0.00	0.00	0.00	0.00	0.00	0

Back to Streams Statistics
Back to Top

Persistent Queues

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps
%Exp Msgs - % of msgs enqueued with expiry
%Delay Msgs - % of msgs enqueued with delay
%Trasf Time - % of Enqueue time spent in transformation
%Eval Time - % of Enqueue time spent in rule evaluation

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(11324)	2	0	100.00	0.00	0.02	0.00	0.00	4.65
SYS.AQ$_ALERT_QT_E(11323)	0	0			0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(82486)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(82156)	21	21	0.00	0.00	0.60	2.65	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps

Queue Name	Enqueue Msgs/sec	Dequeue Msgs/sec	Avg Enqueue sec / msg	Avg Dequeue sec / msg
SYS.ALERT_QUE(11324)	0.00	0.00	0.01
SYS.AQ$_ALERT_QT_E(11323)	0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(82486)	0.00	0.00
SYSMAN.MGMT_TASK_Q(82156)	0.02	0.02	0.03	0.13

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Ordered by Queue Name, Subscriber Name
* indicates Subscriber activity (re)started between Begin/End snaps

Subscriber/Queue	Enqueue Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
B1GR2BASE_3938_ORCL(62)/SYS.ALERT_QUE	2	0.00	0.00	0.00
HAE_SUB(1)/SYS.ALERT_QUE	0
TRAINING_1830_ORCL(41)/SYS.ALERT_QUE	2	0.00	0.00	0.00
TRAINING_3872_ORCL(61)/SYS.ALERT_QUE	2	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

only rows with Current or Maximum Utilization > 80% of Limit are shown
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
processes	126	127	150	150

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections	Avg Active Connections	Avg Total Shared Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	1	0	1	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec	Disp Queue Per Sec	Server Msgs/Sec	Server KB/Sec	Common Queue Total	Disp Queue Total	Server Total Msgs	Server Total(KB)
0	0	0	0.00	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Statistics are combined for all servers
Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
1,358	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

Ordered by %Busy, descending
Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle	Total Queued	Total Queue Wait (s)	Avg Queue Wait (ms)
D000	0.00	1,358	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

if IP/Public/Source at End snap is different a '*' is displayed

Parameter Name	Begin value	End value (if different)
_enable_automatic_maintenance	0
audit_file_dest	/u01/app/oracle/admin/orcl/adump
audit_trail	DB
compatible	11.2.0.0.0
control_files	+DATA/orcl/controlfile/current.257.716404861, +FRA/orcl/controlfile/current.256.716404861
db_block_size	8192
db_cache_size	394264576
db_create_file_dest	+DATA
db_create_online_log_dest_1	+DATA
db_domain
db_name	orcl
db_recovery_file_dest	+FRA
db_recovery_file_dest_size	17179869184
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=orclXDB)
java_pool_size	4194304
job_queue_processes	1000
large_pool_size	4194304
open_cursors	300
pga_aggregate_target	157286400
processes	150
remote_login_passwordfile	EXCLUSIVE
resource_manager_plan
service_names	orcl, OLTP, DSS, ADHOC, BATCH_STD, BATCH_LOW
sga_max_size	813694976
sga_target	788529152
shared_pool_size	134217728
streams_pool_size	4194304
timed_statistics	TRUE
undo_tablespace	UNDOTBS1

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	99.89	Redo NoWait %:	100.00
Buffer Hit %:	97.96	In-memory Sort %:	100.00
Library Hit %:	89.58	Soft Parse %:	70.28
Execute to Parse %:	84.69	Latch Hit %:	99.91
Parse CPU to Parse Elapsd %:	3.19	% Non-Parse CPU:	98.32