WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

DB11G 279886783 DB11G 1 07-Oct-13 20:10 11.2.0.3.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
DB11G	279886783	DB11G	1	07-Oct-13 20:10	11.2.0.3.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

ol6-112.localdomain Linux x86 64-bit 2 2 1 2.95

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
ol6-112.localdomain	Linux x86 64-bit	2	2	1	2.95

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 79 07-Oct-13 20:53:32 72 3.3

End Snap: 80 07-Oct-13 21:10:32 71 3.2

Elapsed: 16.99 (mins)

DB Time: 84.04 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	79	07-Oct-13 20:53:32	72	3.3
End Snap:	80	07-Oct-13 21:10:32	71	3.2
Elapsed:		16.99 (mins)
DB Time:		84.04 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 380M 372M Std Block Size: 8K

Shared Pool Size: 196M 204M Log Buffer: 7,356K

	Begin	End
Buffer Cache:	380M	372M	Std Block Size:	8K
Shared Pool Size:	196M	204M	Log Buffer:	7,356K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 5.0 0.1 0.02 0.08

DB CPU(s): 1.2 0.0 0.01 0.02

Redo size: 48,397.4 1,268.4

Logical reads: 1,834.5 48.1

Block changes: 410.5 10.8

Physical reads: 42.7 1.1

Physical writes: 26.5 0.7

User calls: 58.4 1.5

Parses: 12.3 0.3

Hard parses: 1.0 0.0

W/A MB processed: 7.5 0.2

Logons: 0.1 0.0

Executes: 216.0 5.7

Rollbacks: 7.8 0.2

Transactions: 38.2

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	5.0	0.1	0.02	0.08
DB CPU(s):	1.2	0.0	0.01	0.02
Redo size:	48,397.4	1,268.4
Logical reads:	1,834.5	48.1
Block changes:	410.5	10.8
Physical reads:	42.7	1.1
Physical writes:	26.5	0.7
User calls:	58.4	1.5
Parses:	12.3	0.3
Hard parses:	1.0	0.0
W/A MB processed:	7.5	0.2
Logons:	0.1	0.0
Executes:	216.0	5.7
Rollbacks:	7.8	0.2
Transactions:	38.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 100.00

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

Library Hit %: 99.00 Soft Parse %: 91.80

Execute to Parse %: 94.31 Latch Hit %: 99.85

Parse CPU to Parse Elapsd %: 23.78 % Non-Parse CPU: 96.98

Shared Pool Statistics

Begin End

Memory Usage %: 82.49 88.47

% SQL with executions>1: 76.23 77.56

% Memory for SQL w/exec>1: 68.96 59.59

	Begin	End
Memory Usage %:	82.49	88.47
% SQL with executions>1:	76.23	77.56
% Memory for SQL w/exec>1:	68.96	59.59

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		1,201		23.82
db file sequential read	39,575	114	3	2.26	User I/O
library cache: mutex X	2,392	47	20	0.93	Concurrency
log file sync	4,423	37	8	0.74	Commit
latch free	2,800	32	11	0.63	Other

Host CPU (CPUs: 2 Cores: 2 Sockets: 1)

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

9.19 8.78 56.5 29.1 0.2 10.6

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
9.19	8.78	56.5	29.1	0.2	10.6

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

66.9 74.8 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 3,016.8 3,016.8

SGA use (MB): 600.0 600.0

PGA use (MB): 188.5 183.9

% Host Mem used for SGA+PGA: 26.14 25.99

	Begin	End
Host Mem (MB):	3,016.8	3,016.8
SGA use (MB):	600.0	600.0
PGA use (MB):	188.5	183.9
% Host Mem used for SGA+PGA:	26.14	25.99

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): 5042.3s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	4,438.60	88.03
DB CPU	1,200.91	23.82
PL/SQL execution elapsed time	1,134.42	22.50
parse time elapsed	274.43	5.44
hard parse elapsed time	159.65	3.17
PL/SQL compilation elapsed time	7.05	0.14
hard parse (sharing criteria) elapsed time	6.69	0.13
connection management call elapsed time	5.95	0.12
repeated bind elapsed time	4.52	0.09
hard parse (bind mismatch) elapsed time	2.69	0.05
sequence load elapsed time	0.17	0.00
DB time	5,042.30
background elapsed time	381.68
background cpu time	96.19

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	173,390
IDLE_TIME	20,551
IOWAIT_TIME	401
NICE_TIME	846
SYS_TIME	56,512
USER_TIME	109,541
LOAD	9	9
PHYSICAL_MEMORY_BYTES	3,163,295,744
NUM_CPUS	2
NUM_CPU_CORES	2
NUM_CPU_SOCKETS	1
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	3,102,176
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	3,102,176
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
07-Oct 20:53:32	9.19
07-Oct 21:10:32	8.78	89.40	56.48	29.14	10.60	0.21

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 29.6% of Total DB time 5,042.30 (s)
Total FG Wait Time: 293.30 (s) DB CPU time: 1,200.91 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			1,201		23.82
User I/O	40,650	0	119	3	2.36
Concurrency	4,221	0	71	17	1.41
Other	3,775	1	43	11	0.85
Commit	4,423	0	37	8	0.74
Network	31,409	0	14	0	0.27
Configuration	47	0	7	149	0.14
System I/O	2,630	0	2	1	0.03
Application	152	0	1	3	0.01

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
db file sequential read	39,575	0	114	3	1.02	2.26
library cache: mutex X	2,392	0	47	20	0.06	0.93
log file sync	4,423	0	37	8	0.11	0.74
latch free	2,800	0	32	11	0.07	0.63
SQL*Net message to client	31,228	0	13	0	0.80	0.26
enq: HW - contention	44	0	7	157	0.00	0.14
latch: In memory undo latch	553	0	6	11	0.01	0.12
latch: row cache objects	349	0	5	15	0.01	0.11
buffer busy waits	386	0	5	13	0.01	0.10
cursor: pin S	275	0	5	16	0.01	0.09
latch: enqueue hash chains	354	0	4	13	0.01	0.09
latch: object queue header operation	232	0	3	13	0.01	0.06
latch: cache buffers chains	238	0	3	11	0.01	0.05
Disk file operations I/O	304	0	2	5	0.01	0.03
rdbms ipc reply	58	0	2	27	0.00	0.03
db file parallel read	391	0	1	4	0.01	0.03
control file parallel write	195	0	1	7	0.01	0.03
Data file init write	195	0	1	7	0.01	0.03
db file single write	65	0	1	10	0.00	0.01
SQL*Net break/reset to client	152	0	1	3	0.00	0.01
reliable message	131	0	0	4	0.00	0.01
control file sequential read	2,435	0	0	0	0.06	0.01
latch: cache buffers lru chain	37	0	0	11	0.00	0.01
latch: shared pool	25	0	0	15	0.00	0.01
latch: messages	21	0	0	17	0.00	0.01
latch: undo global data	32	0	0	8	0.00	0.00
db file scattered read	65	0	0	4	0.00	0.00
SQL*Net more data to client	141	0	0	2	0.00	0.00
latch: redo allocation	4	0	0	42	0.00	0.00
ADR block file read	44	0	0	4	0.00	0.00
direct path read	48	0	0	2	0.00	0.00
latch: session allocation	16	0	0	6	0.00	0.00
enq: US - contention	8	0	0	10	0.00	0.00
log file switch (private strand flush incomplete)	3	0	0	22	0.00	0.00
SQL*Net more data from client	40	0	0	1	0.00	0.00
enq: TX - index contention	3	0	0	13	0.00	0.00
latch: call allocation	1	0	0	23	0.00	0.00
read by other session	1	0	0	7	0.00	0.00
buffer deadlock	2	100	0	3	0.00	0.00
direct path write	6	0	0	1	0.00	0.00
PL/SQL lock timer	107,542	100	16,468	153	2.76
SQL*Net message from client	31,226	0	15,317	491	0.80
jobq slave wait	2,106	100	1,059	503	0.05
Streams AQ: waiting for messages in the queue	203	100	1,011	4978	0.01
wait for unread message on broadcast channel	1,015	98	1,007	992	0.03

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
log file parallel write	36,652	0	105	3	0.94	27.45
db file async I/O submit	3,658	0	43	12	0.09	11.36
os thread startup	37	0	41	1107	0.00	10.73
LGWR wait for redo copy	1,016	0	8	8	0.03	2.05
control file parallel write	490	0	7	14	0.01	1.82
latch free	361	0	6	18	0.01	1.68
latch: redo allocation	284	0	3	10	0.01	0.77
control file sequential read	1,237	0	1	1	0.03	0.18
latch: cache buffers lru chain	30	0	0	9	0.00	0.07
latch: object queue header operation	38	0	0	7	0.00	0.07
db file sequential read	253	0	0	1	0.01	0.05
latch: cache buffers chains	5	0	0	33	0.00	0.04
latch: checkpoint queue latch	5	0	0	33	0.00	0.04
buffer busy waits	5	0	0	25	0.00	0.03
latch: messages	16	0	0	5	0.00	0.02
latch: enqueue hash chains	6	0	0	12	0.00	0.02
asynch descriptor resize	67	100	0	1	0.00	0.02
Disk file operations I/O	32	0	0	2	0.00	0.02
Parameter File I/O	16	0	0	2	0.00	0.01
library cache: mutex X	1	0	0	30	0.00	0.01
db file single write	12	0	0	2	0.00	0.00
SQL*Net message to client	79	0	0	0	0.00	0.00
latch: In memory undo latch	1	0	0	10	0.00	0.00
latch: shared pool	2	0	0	4	0.00	0.00
latch: row cache objects	2	0	0	3	0.00	0.00
latch: session allocation	1	0	0	5	0.00	0.00
log file single write	2	0	0	2	0.00	0.00
db file scattered read	2	0	0	1	0.00	0.00
latch: redo writing	2	0	0	1	0.00	0.00
rdbms ipc message	41,066	12	10,838	264	1.06
Space Manager: slave idle wait	2,640	57	9,405	3562	0.07
DIAG idle wait	2,014	100	2,020	1003	0.05
shared server idle wait	34	100	1,020	30012	0.00
dispatcher timer	17	100	1,020	60013	0.00
smon timer	80	0	1,014	12673	0.00
Streams AQ: qmn coordinator idle wait	69	52	1,009	14616	0.00
Streams AQ: qmn slave idle wait	37	0	1,008	27251	0.00
pmon timer	337	99	1,008	2992	0.01
SGA: MMAN sleep for component shrink	155	99	2	12	0.00
SQL*Net message from client	105	0	1	11	0.00
class slave wait	4	0	0	5	0.00

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	44	56.8	15.9	11.4	6.8	2.3	4.5	2.3
Data file init write	195	64.6	4.1	9.2	8.2	3.6	4.6	5.6
Disk file operations I/O	333	52.6	14.1	12.6	7.2	6.0	4.2	3.3
LGWR wait for redo copy	1015	35.4	10.5	12.3	13.5	14.6	8.4	5.3
Parameter File I/O	16	43.8	31.3	6.3	6.3	12.5
SQL*Net break/reset to client	154	63.6	6.5	9.7	7.8	8.4	1.9	1.9
SQL*Net message to client	31.3K	97.2	.6	.5	.5	.6	.4	.2
SQL*Net more data from client	41	87.8			7.3	4.9
SQL*Net more data to client	137	92.0	.7	2.9			2.9	1.5
asynch descriptor resize	101	96.0	1.0			2.0	1.0
buffer busy waits	395	16.7	7.3	13.2	17.5	21.3	15.2	8.9
buffer deadlock	2		50.0		50.0
control file parallel write	685	6.0	22.0	20.9	16.5	15.8	10.1	8.8
control file sequential read	3668	98.1	.7	.1	.5	.3	.1	.2
cursor: pin S	278	12.6	3.6	12.2	8.3	27.3	21.9	14.0
db file async I/O submit	3704	42.5	18.8	10.4	8.0	6.8	4.9	8.6
db file parallel read	356	73.0	5.6	3.9	4.5	7.6	3.7	1.7
db file scattered read	67	59.7	4.5	14.9	10.4	3.0	6.0	1.5
db file sequential read	39.4K	68.1	10.1	6.9	5.9	4.7	2.8	1.5
db file single write	77	40.3	16.9	11.7	13.0	7.8	2.6	7.8
direct path read	48	64.6	8.3	16.7		6.3	4.2
direct path write	6	66.7	16.7	16.7
enq: HW - contention	44	2.3	4.5	4.5	2.3	4.5	9.1	72.7
enq: TX - index contention	3				33.3	33.3	33.3
enq: US - contention	8	12.5		50.0		12.5	25.0
latch free	3176	10.2	7.0	13.5	20.5	24.8	16.6	7.4
latch: In memory undo latch	549	17.7	8.2	15.1	16.9	20.4	14.2	7.5
latch: cache buffers chains	241	16.6	9.1	14.1	18.3	14.5	19.5	7.9
latch: cache buffers lru chain	64	18.8	4.7	4.7	21.9	26.6	21.9	1.6
latch: call allocation	1						100.0
latch: checkpoint queue latch	5			20.0		40.0		40.0
latch: enqueue hash chains	360	10.6	6.7	15.0	18.1	21.7	18.9	9.2
latch: messages	34	8.8	17.6	17.6	20.6	26.5	5.9	2.9
latch: object queue header operation	269	13.4	6.3	16.0	16.4	25.7	13.0	9.3
latch: redo allocation	285	19.6	13.7	12.3	21.1	13.3	12.6	7.4
latch: redo writing	2	100.0
latch: row cache objects	353	8.2	5.7	11.0	20.1	20.4	23.5	11.0
latch: session allocation	17		5.9	23.5	52.9	17.6
latch: shared pool	23	34.8	8.7	21.7	13.0	13.0	4.3	4.3
latch: undo global data	34	17.6	14.7	17.6	20.6	11.8	5.9	11.8
library cache: mutex X	2407	7.9	3.2	7.2	11.5	26.6	26.0	17.4
log file parallel write	36.6K	35.3	34.8	15.0	8.5	4.2	1.7	.6
log file sequential read	2	100.0
log file single write	2			100.0
log file switch (private strand flush incomplete)	3					33.3	66.7
log file sync	4439	24.2	16.1	15.8	15.7	13.8	9.1	5.3
os thread startup	36							61.1	38.9
rdbms ipc reply	58	10.3	1.7	20.7	19.0	17.2	13.8	17.2
read by other session	1				100.0
reliable message	131	22.9	22.9	30.5	13.0	7.6	3.1
DIAG idle wait	2014							100.0
PL/SQL lock timer	107.5K							100.0
SGA: MMAN sleep for component shrink	155		.6			92.9	5.8	.6
SQL*Net message from client	31.3K	3.5	1.7	1.5	1.5	1.2	.8	88.3	1.3
Space Manager: slave idle wait	2638	.4	.5	1.4	2.1	2.1	2.4	11.0	80.1
Streams AQ: qmn coordinator idle wait	71	5.6	8.5	18.3	4.2	5.6	4.2	1.4	52.1
Streams AQ: qmn slave idle wait	38	2.6							97.4
Streams AQ: waiting for messages in the queue	202	.5							99.5
class slave wait	4		25.0	50.0		25.0
dispatcher timer	17								100.0
jobq slave wait	2116			.0				100.0
pmon timer	337								100.0
rdbms ipc message	41K	10.7	4.3	6.7	10.5	14.7	18.1	28.7	6.3
shared server idle wait	34								100.0
smon timer	80	1.3					1.3	10.0	87.5
wait for unread message on broadcast channel	1017							99.8	.2

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
ADR block file read	1	97.7	2.3
Data file init write	11	94.4	3.6	1.5	.5
Disk file operations I/O	11	96.7	1.8	1.5
LGWR wait for redo copy	54	94.7	4.4	.9
SQL*Net break/reset to client	3	98.1	1.9
SQL*Net message to client	73	99.8	.2	.0
SQL*Net more data to client	2	98.5	1.5
buffer busy waits	35	91.1	5.8	2.5	.5
control file parallel write	60	91.2	5.4	2.8	.6
control file sequential read	7	99.8	.1	.1
cursor: pin S	39	86.0	11.9	2.2
db file async I/O submit	317	91.4	4.4	2.5	1.3	.4	.1
db file parallel read	6	98.3	1.4	.3
db file scattered read	1	98.5	1.5
db file sequential read	582	98.5	1.2	.2	.0
db file single write	6	92.2	3.9	3.9
enq: HW - contention	32	27.3	18.2	20.5	11.4	18.2	4.5
latch free	236	92.6	6.5	.9	.0
latch: In memory undo latch	41	92.5	6.6	.9
latch: cache buffers chains	19	92.1	6.2	1.7
latch: cache buffers lru chain	1	98.4	1.6
latch: checkpoint queue latch	2	60.0	20.0	20.0
latch: enqueue hash chains	33	90.8	8.6	.6
latch: messages	1	97.1	2.9
latch: object queue header operation	25	90.7	7.8	1.5
latch: redo allocation	21	92.6	6.0	1.4
latch: row cache objects	39	89.0	9.6	.8	.6
latch: shared pool	1	95.7		4.3
latch: undo global data	4	88.2	11.8
library cache: mutex X	419	82.6	13.8	3.6
log file parallel write	228	99.4	.5	.1	.0
log file sync	236	94.7	3.9	1.2	.1
os thread startup	35					16.7	44.4	36.1	2.8
rdbms ipc reply	10	82.8	5.2	6.9	5.2

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	< 2m	>=2m
		% of Total Waits
os thread startup	1	97.2	2.8

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)
DB11G.WORLD	4,817	1,117	39	1,678
SYS$USERS	280	91	5	188
DB11GXDB	0	0	0	0
SYS$BACKGROUND	0	0	0	9

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
DB11G.WORLD	38838	118	4174	71	29699	13
SYS$USERS	1874	2	53	1	1735	0
SYS$BACKGROUND	315	0	53	42	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 48.4% of Total DB Time (s): 5,042
Captured PL/SQL account for 87.2% of Total DB Time (s): 5,042

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,076.23	8,022	0.26	41.18	22.12	1.09	0w2qpuc6u2zsp	JDBC Thin Client	BEGIN :1 := orderentry.neworde...
1,281.50	9,707	0.13	25.41	25.01	0.14	147a57cxq3w5y	JDBC Thin Client	BEGIN :1 := orderentry.browsep...
843.30	23,982	0.04	16.72	17.59	0.75	c13sma6rkr27c	New Order	SELECT PRODUCTS.PRODUCT_ID, PR...
485.58	4,905	0.10	9.63	17.18	17.47	a9gvfh5hx9u98	JDBC Thin Client	BEGIN :1 := orderentry.process...
339.08	3,318	0.10	6.72	17.38	1.73	dcq9a12vtcnuw	JDBC Thin Client	BEGIN :1 := orderentry.newcust...
334.20	8,022	0.04	6.63	18.55	4.68	bymb3ujkr3ubk	New Order	INSERT INTO ORDERS(ORDER_ID, O...
329.45	29,278	0.01	6.53	18.89	0.18	0y1prvxqc2ra9	Browse Products	SELECT PRODUCTS.PRODUCT_ID, PR...
173.57	22,690	0.01	3.44	16.75	1.38	5raw2bzx227wp	Browse Products	INSERT INTO LOGON VALUES (:B2 ...
158.91	4,904	0.03	3.15	13.47	44.54	7hk2m2702ua0g	Process Orders	WITH NEED_TO_PROCESS AS (SELEC...
129.17	4,905	0.03	2.56	16.82	10.86	f9u2k84v884y7	Process Orders	UPDATE /*+ index(orders, order...
127.45	1,641	0.08	2.53	21.69	0.15	apgb2g9q2zjh1		BEGIN :1 := orderentry.browsea...
85.05	3,318	0.03	1.69	15.39	6.39	0bzhqhhj9mpaa	New Customer	INSERT INTO CUSTOMERS(CUSTOMER...
78.35	22,689	0.00	1.55	17.67	0.00	8dq0v1mjngj7t	New Order	SELECT CUSTOMER_ID, CUST_FIRST...
65.87	22,691	0.00	1.31	21.32	0.00	c749bc43qqfz3	Browse Products	SELECT SYSDATE FROM DUAL
63.60	1	63.60	1.26	34.89	0.42	gg8fha483ayww	Admin Connection	select output from table(dbms_...

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 37.9% of Total CPU Time (s): 1,201
Captured PL/SQL account for 81.1% of Total CPU Time (s): 1,201

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
459.30	8,022	0.06	38.25	2,076.23	22.12	1.09	0w2qpuc6u2zsp	JDBC Thin Client	BEGIN :1 := orderentry.neworde...
320.51	9,707	0.03	26.69	1,281.50	25.01	0.14	147a57cxq3w5y	JDBC Thin Client	BEGIN :1 := orderentry.browsep...
148.35	23,982	0.01	12.35	843.30	17.59	0.75	c13sma6rkr27c	New Order	SELECT PRODUCTS.PRODUCT_ID, PR...
83.44	4,905	0.02	6.95	485.58	17.18	17.47	a9gvfh5hx9u98	JDBC Thin Client	BEGIN :1 := orderentry.process...
62.22	29,278	0.00	5.18	329.45	18.89	0.18	0y1prvxqc2ra9	Browse Products	SELECT PRODUCTS.PRODUCT_ID, PR...
61.98	8,022	0.01	5.16	334.20	18.55	4.68	bymb3ujkr3ubk	New Order	INSERT INTO ORDERS(ORDER_ID, O...
58.92	3,318	0.02	4.91	339.08	17.38	1.73	dcq9a12vtcnuw	JDBC Thin Client	BEGIN :1 := orderentry.newcust...
29.07	22,690	0.00	2.42	173.57	16.75	1.38	5raw2bzx227wp	Browse Products	INSERT INTO LOGON VALUES (:B2 ...
27.64	1,641	0.02	2.30	127.45	21.69	0.15	apgb2g9q2zjh1		BEGIN :1 := orderentry.browsea...
22.19	1	22.19	1.85	63.60	34.89	0.42	gg8fha483ayww	Admin Connection	select output from table(dbms_...
21.73	4,905	0.00	1.81	129.17	16.82	10.86	f9u2k84v884y7	Process Orders	UPDATE /*+ index(orders, order...
21.41	4,904	0.00	1.78	158.91	13.47	44.54	7hk2m2702ua0g	Process Orders	WITH NEED_TO_PROCESS AS (SELEC...
14.04	22,691	0.00	1.17	65.87	21.32	0.00	c749bc43qqfz3	Browse Products	SELECT SYSDATE FROM DUAL
13.84	22,689	0.00	1.15	78.35	17.67	0.00	8dq0v1mjngj7t	New Order	SELECT CUSTOMER_ID, CUST_FIRST...
13.09	3,318	0.00	1.09	85.05	15.39	6.39	0bzhqhhj9mpaa	New Customer	INSERT INTO CUSTOMERS(CUSTOMER...

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 97.6% of Total User I/O Wait Time (s): 119
Captured PL/SQL account for 98.0% of Total User I/O Wait Time (s): 119

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
84.84	4,905	0.02	71.09	485.58	17.18	17.47	a9gvfh5hx9u98	JDBC Thin Client	BEGIN :1 := orderentry.process...
70.78	4,904	0.01	59.31	158.91	13.47	44.54	7hk2m2702ua0g	Process Orders	WITH NEED_TO_PROCESS AS (SELEC...
22.54	8,022	0.00	18.89	2,076.23	22.12	1.09	0w2qpuc6u2zsp	JDBC Thin Client	BEGIN :1 := orderentry.neworde...
15.65	8,022	0.00	13.12	334.20	18.55	4.68	bymb3ujkr3ubk	New Order	INSERT INTO ORDERS(ORDER_ID, O...
14.03	4,905	0.00	11.76	129.17	16.82	10.86	f9u2k84v884y7	Process Orders	UPDATE /*+ index(orders, order...
6.33	23,982	0.00	5.30	843.30	17.59	0.75	c13sma6rkr27c	New Order	SELECT PRODUCTS.PRODUCT_ID, PR...
5.87	3,318	0.00	4.92	339.08	17.38	1.73	dcq9a12vtcnuw	JDBC Thin Client	BEGIN :1 := orderentry.newcust...
5.43	3,318	0.00	4.55	85.05	15.39	6.39	0bzhqhhj9mpaa	New Customer	INSERT INTO CUSTOMERS(CUSTOMER...
2.40	22,690	0.00	2.01	173.57	16.75	1.38	5raw2bzx227wp	Browse Products	INSERT INTO LOGON VALUES (:B2 ...
1.84	9,707	0.00	1.54	1,281.50	25.01	0.14	147a57cxq3w5y	JDBC Thin Client	BEGIN :1 := orderentry.browsep...
1.48	1	1.48	1.24	26.25	21.81	5.62	7dwup5bn902rg	sqlplus@ol6-112.localdomain (TNS V1-V3)	BEGIN DBMS_WORKLOAD_REPOSITORY...

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: 1,870,525
Captured SQL account for 97.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,034,752	8,022	128.99	55.32	2,076.23	22.1	1.1	0w2qpuc6u2zsp	JDBC Thin Client	BEGIN :1 := orderentry.neworde...
649,938	23,982	27.10	34.75	843.30	17.6	.8	c13sma6rkr27c	New Order	SELECT PRODUCTS.PRODUCT_ID, PR...
339,216	9,707	34.95	18.13	1,281.50	25	.1	147a57cxq3w5y	JDBC Thin Client	BEGIN :1 := orderentry.browsep...
309,323	8,022	38.56	16.54	334.20	18.5	4.7	bymb3ujkr3ubk	New Order	INSERT INTO ORDERS(ORDER_ID, O...
266,660	29,278	9.11	14.26	329.45	18.9	.2	0y1prvxqc2ra9	Browse Products	SELECT PRODUCTS.PRODUCT_ID, PR...
149,114	4,905	30.40	7.97	485.58	17.2	17.5	a9gvfh5hx9u98	JDBC Thin Client	BEGIN :1 := orderentry.process...
96,185	3,318	28.99	5.14	339.08	17.4	1.7	dcq9a12vtcnuw	JDBC Thin Client	BEGIN :1 := orderentry.newcust...
79,312	22,690	3.50	4.24	173.57	16.7	1.4	5raw2bzx227wp	Browse Products	INSERT INTO LOGON VALUES (:B2 ...
78,492	4,904	16.01	4.20	158.91	13.5	44.5	7hk2m2702ua0g	Process Orders	WITH NEED_TO_PROCESS AS (SELEC...
72,242	1	72,242.00	3.86	63.60	34.9	.4	gg8fha483ayww	Admin Connection	select output from table(dbms_...
71,484	22,689	3.15	3.82	78.35	17.7	0	8dq0v1mjngj7t	New Order	SELECT CUSTOMER_ID, CUST_FIRST...
65,701	4,905	13.39	3.51	129.17	16.8	10.9	f9u2k84v884y7	Process Orders	UPDATE /*+ index(orders, order...
64,507	3,318	19.44	3.45	85.05	15.4	6.4	0bzhqhhj9mpaa	New Customer	INSERT INTO CUSTOMERS(CUSTOMER...
58,975	16	3,685.94	3.15	37.53	30.7	.4	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
40,115	8,023	5.00	2.14	27.58	20.3	0	dwwbq1j9kw64f		select o.name, c.name from con...
26,987	363	74.34	1.44	8.27	34.8	.2	f7nhbjdn5rx9a		INSERT INTO MGMT_VIOLATIONS (T...
25,443	1	25,443.00	1.36	26.25	21.8	5.6	7dwup5bn902rg	sqlplus@ol6-112.localdomain (TNS V1-V3)	BEGIN DBMS_WORKLOAD_REPOSITORY...

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: 43,581
Captured SQL account for 97.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
20,926	4,905	4.27	48.02	485.58	17.18	17.47	a9gvfh5hx9u98	JDBC Thin Client	BEGIN :1 := orderentry.process...
18,122	4,904	3.70	41.58	158.91	13.47	44.54	7hk2m2702ua0g	Process Orders	WITH NEED_TO_PROCESS AS (SELEC...
13,930	8,022	1.74	31.96	2,076.23	22.12	1.09	0w2qpuc6u2zsp	JDBC Thin Client	BEGIN :1 := orderentry.neworde...
7,984	8,022	1.00	18.32	334.20	18.55	4.68	bymb3ujkr3ubk	New Order	INSERT INTO ORDERS(ORDER_ID, O...
5,919	23,982	0.25	13.58	843.30	17.59	0.75	c13sma6rkr27c	New Order	SELECT PRODUCTS.PRODUCT_ID, PR...
2,978	1	2,978.00	6.83	0.89	33.86	15.58	ab7ktcdksu27j	emagent_SQL_oracle_database	/* OracleOEM / SELECT /+ IND...
2,813	3,318	0.85	6.45	339.08	17.38	1.73	dcq9a12vtcnuw	JDBC Thin Client	BEGIN :1 := orderentry.newcust...
2,807	3,318	0.85	6.44	85.05	15.39	6.39	0bzhqhhj9mpaa	New Customer	INSERT INTO CUSTOMERS(CUSTOMER...
2,799	4,905	0.57	6.42	129.17	16.82	10.86	f9u2k84v884y7	Process Orders	UPDATE /*+ index(orders, order...
804	1	804.00	1.84	26.25	21.81	5.62	7dwup5bn902rg	sqlplus@ol6-112.localdomain (TNS V1-V3)	BEGIN DBMS_WORKLOAD_REPOSITORY...
597	197	3.03	1.37	0.86	25.56	27.02	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
445	1	445.00	1.02	63.60	34.89	0.42	gg8fha483ayww	Admin Connection	select output from table(dbms_...

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: 40,433
Captured SQL account for 103.0% of Total
Total UnOptimized Read Requests: 40,433
Captured SQL account for 103.0% 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
21,124	21,124	4,905	4.31	52.24	a9gvfh5hx9u98	JDBC Thin Client	BEGIN :1 := orderentry.process...
18,122	18,122	4,904	3.70	44.82	7hk2m2702ua0g	Process Orders	WITH NEED_TO_PROCESS AS (SELEC...
14,480	14,480	8,022	1.81	35.81	0w2qpuc6u2zsp	JDBC Thin Client	BEGIN :1 := orderentry.neworde...
8,314	8,314	8,022	1.04	20.56	bymb3ujkr3ubk	New Order	INSERT INTO ORDERS(ORDER_ID, O...
5,919	5,919	23,982	0.25	14.64	c13sma6rkr27c	New Order	SELECT PRODUCTS.PRODUCT_ID, PR...
3,077	3,077	3,318	0.93	7.61	dcq9a12vtcnuw	JDBC Thin Client	BEGIN :1 := orderentry.newcust...
2,997	2,997	4,905	0.61	7.41	f9u2k84v884y7	Process Orders	UPDATE /*+ index(orders, order...
2,917	2,917	3,318	0.88	7.21	0bzhqhhj9mpaa	New Customer	INSERT INTO CUSTOMERS(CUSTOMER...
936	936	1	936.00	2.31	7dwup5bn902rg	sqlplus@ol6-112.localdomain (TNS V1-V3)	BEGIN DBMS_WORKLOAD_REPOSITORY...
892	892	1	892.00	2.21	gg8fha483ayww	Admin Connection	select output from table(dbms_...
883	883	22,690	0.04	2.18	5raw2bzx227wp	Browse Products	INSERT INTO LOGON VALUES (:B2 ...
612	612	9,707	0.06	1.51	147a57cxq3w5y	JDBC Thin Client	BEGIN :1 := orderentry.browsep...
597	597	197	3.03	1.48	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...

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: 220,230
Captured SQL account for 77.5% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
29,278	409,892	14.00	329.45	18.9	.2	0y1prvxqc2ra9	Browse Products	SELECT PRODUCTS.PRODUCT_ID, PR...
23,982	108,591	4.53	843.30	17.6	.8	c13sma6rkr27c	New Order	SELECT PRODUCTS.PRODUCT_ID, PR...
22,691	22,691	1.00	65.87	21.3	0	c749bc43qqfz3	Browse Products	SELECT SYSDATE FROM DUAL
22,690	22,690	1.00	173.57	16.7	1.4	5raw2bzx227wp	Browse Products	INSERT INTO LOGON VALUES (:B2 ...
22,689	3,318	0.15	78.35	17.7	0	8dq0v1mjngj7t	New Order	SELECT CUSTOMER_ID, CUST_FIRST...
9,707	9,707	1.00	1,281.50	25	.1	147a57cxq3w5y	JDBC Thin Client	BEGIN :1 := orderentry.browsep...
8,023	8,023	1.00	27.58	20.3	0	dwwbq1j9kw64f		select o.name, c.name from con...
8,022	8,022	1.00	2,076.23	22.1	1.1	0w2qpuc6u2zsp	JDBC Thin Client	BEGIN :1 := orderentry.neworde...
8,022	0	0.00	334.20	18.5	4.7	bymb3ujkr3ubk	New Order	INSERT INTO ORDERS(ORDER_ID, O...
4,905	4,905	1.00	485.58	17.2	17.5	a9gvfh5hx9u98	JDBC Thin Client	BEGIN :1 := orderentry.process...
4,905	4,905	1.00	129.17	16.8	10.9	f9u2k84v884y7	Process Orders	UPDATE /*+ index(orders, order...
4,904	4,904	1.00	158.91	13.5	44.5	7hk2m2702ua0g	Process Orders	WITH NEED_TO_PROCESS AS (SELEC...
3,319	3,319	1.00	7.62	17.1	0	4z3ktqk9zq1j9	New Customer	SELECT CUSTOMER_SEQ.NEXTVAL FR...
3,318	3,318	1.00	85.05	15.4	6.4	0bzhqhhj9mpaa	New Customer	INSERT INTO CUSTOMERS(CUSTOMER...
3,318	3,318	1.00	339.08	17.4	1.7	dcq9a12vtcnuw	JDBC Thin Client	BEGIN :1 := orderentry.newcust...
3,088	2,114	0.68	2.33	18.5	1.9	96g93hntrzjtr		select /+ rule / bucket_cnt,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 12,532
Captured SQL account for 78.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
8,022	8,022	64.01	bymb3ujkr3ubk	New Order	INSERT INTO ORDERS(ORDER_ID, O...
398	398	3.18	b2gnxm5z6r51n		lock table sys.col_usage$ in e...
369	372	2.94	a1j6tn192jgfq		SELECT KEY_PART1_VALUE, KEY_PA...
125	125	1.00	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
42	42	0.34	0k8522rmdzg4k		select privilege# from sysauth...
42	962	0.34	cm5vu20fhtnq1		select /*+ connect_by_filterin...
31	62	0.25	08bqjmf8490s2	sqlplus@ol6-112.localdomain (TNS V1-V3)	SELECT PARAMETER_VALUE FROM MG...
31	306	0.25	3ktacv9r56b51		select owner#, name, namespace...
31	306	0.25	8swypbbr0m372		select order#, columns, types ...
29	831	0.23	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,399,116	1	0.65	53pkuyc2acm21	emagent_SQL_oracle_database	/* OracleOEM / SELECT FROM ...
1,336,327	1	0.62	ab7ktcdksu27j	emagent_SQL_oracle_database	/* OracleOEM / SELECT /+ IND...

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

08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

0bzhqhhj9mpaa INSERT INTO CUSTOMERS(CUSTOMER_ID , CUST_FIRST_NAME , CUST_LAST_NAME , NLS_LANGUAGE , NLS_TERRITORY , CREDIT_LIMIT , CUST_EMAIL , ACCOUNT_MGR_ID ) VALUES (:B9 , :B4 , :B3 , :B8 , :B7 , FLOOR(DBMS_RANDOM.VALUE(:B6 , :B5 )), :B4 ||'.'||:B3 ||'@'||'oracle.com', FLOOR(DBMS_RANDOM.VALUE(:B2 , :B1 )))

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

0w2qpuc6u2zsp BEGIN :1 := orderentry.neworder(:2 , :3 , :4 ); END;

0y1prvxqc2ra9 SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.PRODUCT_ID = :B2 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND ROWNUM < :B1

147a57cxq3w5y BEGIN :1 := orderentry.browseproducts(:2 , :3 , :4 ); END;

350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait

3ktacv9r56b51 select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

3nkd3g3ju5ph1 select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

4z3ktqk9zq1j9 SELECT CUSTOMER_SEQ.NEXTVAL FROM DUAL

53pkuyc2acm21 /* OracleOEM */ SELECT * FROM ( SELECT /*+ ordered */ 1 "OBJECT_TYPE", u.name "USER_NAME", o.name "OBJECT_NAME", ' ' "PARTITION", ' ' "LOB_COLUMN", 1 "SEG_TYPE", tts.name "TABLESPACE", decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) "PROBLEM" FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tab$ t, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = t.obj# AND t.ts# = tts.ts# AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) AND decode (bitand (t.property, 1), 1, 1, 0) = 0 AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 AND decode (bitand (t.property, 1024), 1024, 1, 0) = 0 UNION ALL SELECT /*+ ordered */ 2, u.name, o.name, ' ', ' ', 2, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.ind$ i, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = i.obj# AND i.ts# = tts.ts# AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# not in (4, 8) UNION ALL SELECT /*+ ordered */ 3, u.name, o.name, ' ', ' ', 12, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.clu$ c, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = c.obj# AND c.ts# = tts.ts# AND c.file# = s.file# AND c.block# = s.block# AND c.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tn.name, ' ', ' ', 1, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.ind$ i, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" tn, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = i.obj# AND i.ts# = tts.ts# AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND i.bo# = tn.obj# AND tn.obj# = t.obj# AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# = 4 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, o.name, o.subname, ' ', 3, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND na me != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tabpart$ tp, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = tp.obj# AND tp.ts# = tts.ts# AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 2, u.name, o.name, o.subname, ' ', 4, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.indpart$ ip, sys.seg$ s, sys.ind$ i, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = ip.obj# AND ip.ts# = tts.ts# AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# not in (4, 8) AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tn.name, ' ', ' ', 5, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tab$ t, sys.seg$ s, sys.tab$ iot, sys."_CURRENT_EDITION_OBJ" tn, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = t.obj# AND t.ts# = tts.ts# AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND tn.obj# = t.bobj# AND tn.obj# = iot.obj# AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tn.name, ' ', decode(bitand(c.property, 1), 1, substr(ac.name, 0, 500), c.name), 8, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.lob$ l, sys.seg$ s, sys.col$ c, sys.attrcol$ ac, sys."_CURRENT_EDITION_OBJ" tn, sys.user$ u WHERE tn.owner# = u.user# AND u.type# !=2 AND tn.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.ts# = tts.ts# AND l.file# = s.file# AND l.block# = s.block# AND l.ts# = s.ts# AND c.obj# = ac.obj#(+) AND c.intcol# = ac.intcol#(+) AND bitand(c.property, 32768) != 32768 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tn.name, o.subname, ' ', 3, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.indpart$ ip, sys.seg$ s, sys.ind$ i, sys."_CURRENT_EDITION_OBJ" tn, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = ip.obj# AND ip.ts# = tts.ts# AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# = 4 AND i.bo# = tn.obj# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tbo.name, o.subname, ' ', 13, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tabpart$ tp, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" tbo, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = tp.obj# AND tp.ts# = tts.ts# AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 32), 32, 1, 0) = 1 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 AND tbo.obj# = t.bobj# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tbo.name, po.subname, decode(bitand(c.property, 1), 1, substr(a.name, 0, 500), c.name), 8, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.lobfrag$ lf, sys.seg$ s, sys.lob$ l, sys.partobj$ pobj, sys."_CURRENT_EDITION_OBJ" po, sys."_CURRENT_EDITION_OBJ" tbo, sys.attrcol$ a, sys.col$ c, sys.user$ u WHERE tbo.owner# = u.user# AND u.type# !=2 AND pobj.obj# = tbo.obj# AND lf.ts# = tts.ts# AND lf.file# = s.file# AND lf.block# = s.block# AND lf.ts# = s.ts# AND mod(pobj.spare2, 256) = 0 AND tbo.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.lobj# = lf.parentobj# AND lf.tabfragobj# = po.obj# AND bitand(c.property, 32768) != 32768 AND c.obj# = a.obj#(+) AND c.intcol# = a.intcol#(+) AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, bo.name, o.subname, ' ', 9, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tabsubpart$ tsp, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" bo, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = tsp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 2 AND tsp.ts# = tts.ts# AND tsp.file# = s.file# AND tsp.block# = s.block# AND tsp.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 2, u.name, bo.name, o.subname, ' ', 10, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.indsubpart$ isp, sys.seg$ s, sys.user$ u, sys."_CURRENT_EDITION_OBJ" o, sys."_CURRENT_EDITION_OBJ" bo WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = isp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 1 AND isp.ts# = tts.ts# AND isp.file# = s.file# AND isp.block# = s.block# AND isp.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) ) where rownum < 201 AND LENGTH(lob_column) <= 30

5raw2bzx227wp INSERT INTO LOGON VALUES (:B2 , :B1 )

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;

7dwup5bn902rg BEGIN DBMS_WORKLOAD_REPOSITORY.create_snapshot; END;

7hk2m2702ua0g WITH NEED_TO_PROCESS AS (SELECT ORDER_ID, CUSTOMER_ID FROM ORDERS WHERE ORDER_STATUS <= 4 AND WAREHOUSE_ID = :B1 AND ROWNUM < 10 ) SELECT O.ORDER_ID, OI.LINE_ITEM_ID, OI.PRODUCT_ID, OI.UNIT_PRICE, OI.QUANTITY, O.ORDER_MODE, O.ORDER_STATUS, O.ORDER_TOTAL, O.SALES_REP_ID, O.PROMOTION_ID, C.CUSTOMER_ID, C.CUST_FIRST_NAME, C.CUST_LAST_NAME, C.CREDIT_LIMIT, C.CUST_EMAIL, O.ORDER_DATE FROM ORDERS O, NEED_TO_PROCESS NTP, CUSTOMERS C, ORDER_ITEMS OI WHERE NTP.ORDER_ID = O.ORDER_ID AND C.CUSTOMER_ID = O.CUSTOMER_ID AND OI.ORDER_ID (+) = O.ORDER_ID

8dq0v1mjngj7t SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID FROM CUSTOMERS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

a1j6tn192jgfq SELECT KEY_PART1_VALUE, KEY_PART2_VALUE FROM MGMT_METRICS_COMPOSITE_KEYS WHERE TARGET_GUID = :B2 AND COMPOSITE_KEY = HEXTORAW(:B1 )

a9gvfh5hx9u98 BEGIN :1 := orderentry.processorders(:2 , :3 , :4 ); END;

ab7ktcdksu27j /* OracleOEM */ SELECT /*+ INDEX(ts) */ o.object_type, u.name, o.object_name, o.partition, o.lob_column, o.seg_type, ts.name, 4 FROM ( SELECT 1 "OBJECT_TYPE", o.owner# "USER_NAME#", o.name "OBJECT_NAME", ' ' "PARTITION", ' ' "LOB_COLUMN", 1 "SEG_TYPE", t.ts# "TABLESPACE#" FROM sys."_CURRENT_EDITION_OBJ" o, sys.tab$ t, sys.seg$ s WHERE o.obj# = t.obj# AND t.ts# in (:1, :2) AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND decode (bitand (t.property, 1), 1, 1, 0) = 0 AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 AND decode (bitand (t.property, 1024), 1024, 1, 0) = 0 UNION ALL SELECT 2, o.owner#, o.name, ' ', ' ', 2, i.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.ind$ i, sys.seg$ s WHERE o.obj# = i.obj# AND i.ts# in (:1, :2) AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# not in (4, 8) UNION ALL SELECT 3, o.owner#, o.name, ' ', ' ', 12, c.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.clu$ c, sys.seg$ s WHERE o.obj# = c.obj# AND c.ts# IN (:1, :2) AND c.file# = s.file# AND c.block# = s.block# AND c.ts# = s.ts# UNION ALL SELECT 1, o.owner#, tn.name, ' ', ' ', 1, i.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" tn, sys.ind$ i WHERE o.obj# = i.obj# AND i.ts# IN (:1, :2) AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND i.bo# = tn.obj# AND tn.obj# = t.obj# AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# = 4 UNION ALL SELECT 1, o.owner#, o.name, o.subname, ' ', 3, tp.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.seg$ s, sys.tab$ t, sys.tabpart$ tp WHERE o.obj# = tp.obj# AND tp.ts# IN (:1, :2) AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 UNION ALL SELECT 2, o.owner#, o.name, o.subname, ' ', 4, ip.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.seg$ s, sys.ind$ i, sys.indpart$ ip WHERE o.obj# = ip.obj# AND ip.ts# IN (:1, :2) AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# not in (4, 8) UNION ALL SELECT 1, o.owner#, tn.name, ' ', ' ', 5, t.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" tn, sys.tab$ iot WHERE o.obj# = t.obj# AND t.ts# IN (:1, :2) AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND tn.obj# = t.bobj# AND tn.obj# = iot.obj# AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 UNION ALL SELECT 1, tn.owner#, tn.name, ' ', decode(bitand(c.property, 1), 1, substr(ac.name, 0, 500), c.name), 8, l.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" tn, sys.attrcol$ ac, sys.col$ c, sys.lob$ l WHERE tn.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.ts# IN (:1, :2) AND l.file# = s.file# AND l.block# = s.block# AND l.ts# = s.ts# AND c.obj# = ac.obj#(+) AND c.intcol# = ac.intcol#(+) AND bitand(c.property, 32768) != 32768 UNION ALL SELECT 1, o.owner#, tn.name, o.subname, ' ', 3, ip.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys.ind$ i, sys."_CURRENT_EDITION_OBJ" tn, sys.indpart$ ip WHERE o.obj# = ip.obj# AND ip.ts# IN (:1, :2) AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# = 4 AND i.bo# = tn.obj# UNION ALL SELECT 1, o.owner #, tbo.name, o.subname, ' ', 13, tp.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys."_CURRENT_EDITION_OBJ" tbo, sys.tab$ t, sys.tabpart$ tp WHERE o.obj# = tp.obj# AND tp.ts# IN (:1, :2) AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 32), 32, 1, 0) = 1 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 AND tbo.obj# = t.bobj# UNION ALL SELECT 1, tbo.owner#, tbo.name, po.subname, decode(bitand(c.property, 1), 1, substr(a.name, 0, 500), c.name), 8, lf.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" tbo, sys.attrcol$ a, sys.col$ c, sys.lob$ l, sys."_CURRENT_EDITION_OBJ" po, sys.partobj$ pobj, sys.lobfrag$ lf WHERE pobj.obj# = tbo.obj# AND lf.ts# IN (:1, :2) AND lf.file# = s.file# AND lf.block# = s.block# AND lf.ts# = s.ts# AND mod(pobj.spare2, 256) = 0 AND tbo.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.lobj# = lf.parentobj# AND lf.tabfragobj# = po.obj# AND bitand(c.property, 32768) != 32768 AND c.obj# = a.obj#(+) AND c.intcol# = a.intcol#(+) UNION ALL SELECT 1, o.owner#, bo.name, o.subname, ' ', 9, tsp.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys."_CURRENT_EDITION_OBJ" bo, sys.tabsubpart$ tsp WHERE o.obj# = tsp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 2 AND tsp.file# = s.file# AND tsp.block# = s.block# AND tsp.ts# IN (:1, :2) UNION ALL SELECT 2, o.owner#, bo.name, o.subname, ' ', 10, isp.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys."_CURRENT_EDITION_OBJ" bo, sys.indsubpart$ isp WHERE o.obj# = isp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 1 AND isp.file# = s.file# AND isp.block# = s.block# AND isp.ts# IN (:1, :2) ) o, sys.ts$ ts, sys.user$ u WHERE o.USER_NAME# = u.user# AND u.name NOT IN ('MGMT_VIEW', 'OUTLN', 'ANONYMOUS', 'DMSYS', 'LBACSYS', 'WKPROXY', 'TRACESVR', 'SCOTT', 'ADAMS', 'BLAKE', 'CLARK', 'JONES', 'HR', 'PM', 'OE', 'SH', 'IX') AND u.name NOT IN (SELECT DISTINCT schema_name FROM V$SYSAUX_OCCUPANTS) AND u.name NOT LIKE 'FLOWS!_%' escape '!' AND o.TABLESPACE# = ts.ts# AND u.type# !=2 AND ts.ts# IN (:1, :2) AND rownum < 201

apgb2g9q2zjh1 BEGIN :1 := orderentry.browseandupdateorders(:2 , :3 , :4 ); END;

b2gnxm5z6r51n lock table sys.col_usage$ in exclusive mode nowait

bymb3ujkr3ubk INSERT INTO ORDERS(ORDER_ID, ORDER_DATE, CUSTOMER_ID, WAREHOUSE_ID) VALUES (ORDERS_SEQ.NEXTVAL + :B3 , SYSTIMESTAMP , :B2 , :B1 ) RETURNING ORDER_ID INTO :O0

c13sma6rkr27c SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.CATEGORY_ID = :B3 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND INVENTORIES.WAREHOUSE_ID = :B2 AND ROWNUM < :B1

c749bc43qqfz3 SELECT SYSDATE FROM DUAL

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

cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

dcq9a12vtcnuw BEGIN :1 := orderentry.newcustomer(:2 , :3 , :4 , :5 , :6 , :7 ); END;

dwwbq1j9kw64f select o.name, c.name from con$ c, user$ o where c.con# = :1 and owner# = user#

f7nhbjdn5rx9a INSERT INTO MGMT_VIOLATIONS (TARGET_GUID, POLICY_GUID, KEY_VALUE, COLLECTION_TIMESTAMP, VIOLATION_LEVEL, VIOLATION_TYPE, VIOLATION_DURATION, VIOLATION_GUID, ANNOTATED_FLAG, NOTIFICATION_STATUS, VALUE, STRING_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, ACTION_MESSAGE, ACTION_MESSAGE_NLSID, ACTION_MESSAGE_PARAMS, ADVISORY_ID, CFG_COLL_NAME, CFG_KEY_VALUE, CFG_KEY_OPERATOR, LOAD_TIMESTAMP, USER_NAME) VALUES (:B24 , :B23 , NVL(:B22 , ' '), NVL(:B21 , SYSDATE), :B20 , NVL(:B19 , 0), :B18 , NVL(:B17 , SYS_GUID()), NVL(:B16 , 0), NVL(:B15 , 1), :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , NVL(:B2 , SYSDATE), NVL(:B1 , '<SYSTEM>') )

f9u2k84v884y7 UPDATE /*+ index(orders, order_pk) */ ORDERS SET ORDER_STATUS = FLOOR(DBMS_RANDOM.VALUE(:B3 + 1, :B2 )) WHERE ORDER_ID = :B1

gg8fha483ayww select output from table(dbms_workload_repository.ash_report_html(:1, :2, :3, :4, 0))

SQL Id	SQL Text
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
0bzhqhhj9mpaa	INSERT INTO CUSTOMERS(CUSTOMER_ID , CUST_FIRST_NAME , CUST_LAST_NAME , NLS_LANGUAGE , NLS_TERRITORY , CREDIT_LIMIT , CUST_EMAIL , ACCOUNT_MGR_ID ) VALUES (:B9 , :B4 , :B3 , :B8 , :B7 , FLOOR(DBMS_RANDOM.VALUE(:B6 , :B5 )), :B4 \|\|'.'\|\|:B3 \|\|'@'\|\|'oracle.com', FLOOR(DBMS_RANDOM.VALUE(:B2 , :B1 )))
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0w2qpuc6u2zsp	BEGIN :1 := orderentry.neworder(:2 , :3 , :4 ); END;
0y1prvxqc2ra9	SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.PRODUCT_ID = :B2 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND ROWNUM < :B1
147a57cxq3w5y	BEGIN :1 := orderentry.browseproducts(:2 , :3 , :4 ); END;
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3nkd3g3ju5ph1	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
4z3ktqk9zq1j9	SELECT CUSTOMER_SEQ.NEXTVAL FROM DUAL
53pkuyc2acm21	/* OracleOEM / SELECT FROM ( SELECT /+ ordered / 1 "OBJECT_TYPE", u.name "USER_NAME", o.name "OBJECT_NAME", ' ' "PARTITION", ' ' "LOB_COLUMN", 1 "SEG_TYPE", tts.name "TABLESPACE", decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) "PROBLEM" FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tab$ t, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = t.obj# AND t.ts# = tts.ts# AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) AND decode (bitand (t.property, 1), 1, 1, 0) = 0 AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 AND decode (bitand (t.property, 1024), 1024, 1, 0) = 0 UNION ALL SELECT /+ ordered / 2, u.name, o.name, ' ', ' ', 2, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.ind$ i, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = i.obj# AND i.ts# = tts.ts# AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# not in (4, 8) UNION ALL SELECT /+ ordered / 3, u.name, o.name, ' ', ' ', 12, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.clu$ c, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = c.obj# AND c.ts# = tts.ts# AND c.file# = s.file# AND c.block# = s.block# AND c.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /+ ordered / 1, u.name, tn.name, ' ', ' ', 1, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.ind$ i, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" tn, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = i.obj# AND i.ts# = tts.ts# AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND i.bo# = tn.obj# AND tn.obj# = t.obj# AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# = 4 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /+ ordered / 1, u.name, o.name, o.subname, ' ', 3, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND na me != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tabpart$ tp, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = tp.obj# AND tp.ts# = tts.ts# AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /+ ordered / 2, u.name, o.name, o.subname, ' ', 4, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.indpart$ ip, sys.seg$ s, sys.ind$ i, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = ip.obj# AND ip.ts# = tts.ts# AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# not in (4, 8) AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /+ ordered / 1, u.name, tn.name, ' ', ' ', 5, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tab$ t, sys.seg$ s, sys.tab$ iot, sys."_CURRENT_EDITION_OBJ" tn, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = t.obj# AND t.ts# = tts.ts# AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND tn.obj# = t.bobj# AND tn.obj# = iot.obj# AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /+ ordered / 1, u.name, tn.name, ' ', decode(bitand(c.property, 1), 1, substr(ac.name, 0, 500), c.name), 8, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.lob$ l, sys.seg$ s, sys.col$ c, sys.attrcol$ ac, sys."_CURRENT_EDITION_OBJ" tn, sys.user$ u WHERE tn.owner# = u.user# AND u.type# !=2 AND tn.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.ts# = tts.ts# AND l.file# = s.file# AND l.block# = s.block# AND l.ts# = s.ts# AND c.obj# = ac.obj#(+) AND c.intcol# = ac.intcol#(+) AND bitand(c.property, 32768) != 32768 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /+ ordered / 1, u.name, tn.name, o.subname, ' ', 3, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.indpart$ ip, sys.seg$ s, sys.ind$ i, sys."_CURRENT_EDITION_OBJ" tn, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = ip.obj# AND ip.ts# = tts.ts# AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# = 4 AND i.bo# = tn.obj# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /+ ordered / 1, u.name, tbo.name, o.subname, ' ', 13, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tabpart$ tp, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" tbo, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = tp.obj# AND tp.ts# = tts.ts# AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 32), 32, 1, 0) = 1 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 AND tbo.obj# = t.bobj# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /+ ordered / 1, u.name, tbo.name, po.subname, decode(bitand(c.property, 1), 1, substr(a.name, 0, 500), c.name), 8, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.lobfrag$ lf, sys.seg$ s, sys.lob$ l, sys.partobj$ pobj, sys."_CURRENT_EDITION_OBJ" po, sys."_CURRENT_EDITION_OBJ" tbo, sys.attrcol$ a, sys.col$ c, sys.user$ u WHERE tbo.owner# = u.user# AND u.type# !=2 AND pobj.obj# = tbo.obj# AND lf.ts# = tts.ts# AND lf.file# = s.file# AND lf.block# = s.block# AND lf.ts# = s.ts# AND mod(pobj.spare2, 256) = 0 AND tbo.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.lobj# = lf.parentobj# AND lf.tabfragobj# = po.obj# AND bitand(c.property, 32768) != 32768 AND c.obj# = a.obj#(+) AND c.intcol# = a.intcol#(+) AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /+ ordered / 1, u.name, bo.name, o.subname, ' ', 9, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tabsubpart$ tsp, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" bo, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = tsp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 2 AND tsp.ts# = tts.ts# AND tsp.file# = s.file# AND tsp.block# = s.block# AND tsp.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /+ ordered / 2, u.name, bo.name, o.subname, ' ', 10, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.indsubpart$ isp, sys.seg$ s, sys.user$ u, sys."_CURRENT_EDITION_OBJ" o, sys."_CURRENT_EDITION_OBJ" bo WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = isp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 1 AND isp.ts# = tts.ts# AND isp.file# = s.file# AND isp.block# = s.block# AND isp.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) ) where rownum < 201 AND LENGTH(lob_column) <= 30
5raw2bzx227wp	INSERT INTO LOGON VALUES (:B2 , :B1 )
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;
7dwup5bn902rg	BEGIN DBMS_WORKLOAD_REPOSITORY.create_snapshot; END;
7hk2m2702ua0g	WITH NEED_TO_PROCESS AS (SELECT ORDER_ID, CUSTOMER_ID FROM ORDERS WHERE ORDER_STATUS <= 4 AND WAREHOUSE_ID = :B1 AND ROWNUM < 10 ) SELECT O.ORDER_ID, OI.LINE_ITEM_ID, OI.PRODUCT_ID, OI.UNIT_PRICE, OI.QUANTITY, O.ORDER_MODE, O.ORDER_STATUS, O.ORDER_TOTAL, O.SALES_REP_ID, O.PROMOTION_ID, C.CUSTOMER_ID, C.CUST_FIRST_NAME, C.CUST_LAST_NAME, C.CREDIT_LIMIT, C.CUST_EMAIL, O.ORDER_DATE FROM ORDERS O, NEED_TO_PROCESS NTP, CUSTOMERS C, ORDER_ITEMS OI WHERE NTP.ORDER_ID = O.ORDER_ID AND C.CUSTOMER_ID = O.CUSTOMER_ID AND OI.ORDER_ID (+) = O.ORDER_ID
8dq0v1mjngj7t	SELECT CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID FROM CUSTOMERS WHERE CUSTOMER_ID = :B2 AND ROWNUM < :B1
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
a1j6tn192jgfq	SELECT KEY_PART1_VALUE, KEY_PART2_VALUE FROM MGMT_METRICS_COMPOSITE_KEYS WHERE TARGET_GUID = :B2 AND COMPOSITE_KEY = HEXTORAW(:B1 )
a9gvfh5hx9u98	BEGIN :1 := orderentry.processorders(:2 , :3 , :4 ); END;
ab7ktcdksu27j	/* OracleOEM / SELECT /+ INDEX(ts) */ o.object_type, u.name, o.object_name, o.partition, o.lob_column, o.seg_type, ts.name, 4 FROM ( SELECT 1 "OBJECT_TYPE", o.owner# "USER_NAME#", o.name "OBJECT_NAME", ' ' "PARTITION", ' ' "LOB_COLUMN", 1 "SEG_TYPE", t.ts# "TABLESPACE#" FROM sys."_CURRENT_EDITION_OBJ" o, sys.tab$ t, sys.seg$ s WHERE o.obj# = t.obj# AND t.ts# in (:1, :2) AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND decode (bitand (t.property, 1), 1, 1, 0) = 0 AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 AND decode (bitand (t.property, 1024), 1024, 1, 0) = 0 UNION ALL SELECT 2, o.owner#, o.name, ' ', ' ', 2, i.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.ind$ i, sys.seg$ s WHERE o.obj# = i.obj# AND i.ts# in (:1, :2) AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# not in (4, 8) UNION ALL SELECT 3, o.owner#, o.name, ' ', ' ', 12, c.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.clu$ c, sys.seg$ s WHERE o.obj# = c.obj# AND c.ts# IN (:1, :2) AND c.file# = s.file# AND c.block# = s.block# AND c.ts# = s.ts# UNION ALL SELECT 1, o.owner#, tn.name, ' ', ' ', 1, i.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" tn, sys.ind$ i WHERE o.obj# = i.obj# AND i.ts# IN (:1, :2) AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND i.bo# = tn.obj# AND tn.obj# = t.obj# AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# = 4 UNION ALL SELECT 1, o.owner#, o.name, o.subname, ' ', 3, tp.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.seg$ s, sys.tab$ t, sys.tabpart$ tp WHERE o.obj# = tp.obj# AND tp.ts# IN (:1, :2) AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 UNION ALL SELECT 2, o.owner#, o.name, o.subname, ' ', 4, ip.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.seg$ s, sys.ind$ i, sys.indpart$ ip WHERE o.obj# = ip.obj# AND ip.ts# IN (:1, :2) AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# not in (4, 8) UNION ALL SELECT 1, o.owner#, tn.name, ' ', ' ', 5, t.ts# FROM sys."_CURRENT_EDITION_OBJ" o, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" tn, sys.tab$ iot WHERE o.obj# = t.obj# AND t.ts# IN (:1, :2) AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND tn.obj# = t.bobj# AND tn.obj# = iot.obj# AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 UNION ALL SELECT 1, tn.owner#, tn.name, ' ', decode(bitand(c.property, 1), 1, substr(ac.name, 0, 500), c.name), 8, l.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" tn, sys.attrcol$ ac, sys.col$ c, sys.lob$ l WHERE tn.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.ts# IN (:1, :2) AND l.file# = s.file# AND l.block# = s.block# AND l.ts# = s.ts# AND c.obj# = ac.obj#(+) AND c.intcol# = ac.intcol#(+) AND bitand(c.property, 32768) != 32768 UNION ALL SELECT 1, o.owner#, tn.name, o.subname, ' ', 3, ip.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys.ind$ i, sys."_CURRENT_EDITION_OBJ" tn, sys.indpart$ ip WHERE o.obj# = ip.obj# AND ip.ts# IN (:1, :2) AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# = 4 AND i.bo# = tn.obj# UNION ALL SELECT 1, o.owner #, tbo.name, o.subname, ' ', 13, tp.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys."_CURRENT_EDITION_OBJ" tbo, sys.tab$ t, sys.tabpart$ tp WHERE o.obj# = tp.obj# AND tp.ts# IN (:1, :2) AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 32), 32, 1, 0) = 1 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 AND tbo.obj# = t.bobj# UNION ALL SELECT 1, tbo.owner#, tbo.name, po.subname, decode(bitand(c.property, 1), 1, substr(a.name, 0, 500), c.name), 8, lf.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" tbo, sys.attrcol$ a, sys.col$ c, sys.lob$ l, sys."_CURRENT_EDITION_OBJ" po, sys.partobj$ pobj, sys.lobfrag$ lf WHERE pobj.obj# = tbo.obj# AND lf.ts# IN (:1, :2) AND lf.file# = s.file# AND lf.block# = s.block# AND lf.ts# = s.ts# AND mod(pobj.spare2, 256) = 0 AND tbo.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.lobj# = lf.parentobj# AND lf.tabfragobj# = po.obj# AND bitand(c.property, 32768) != 32768 AND c.obj# = a.obj#(+) AND c.intcol# = a.intcol#(+) UNION ALL SELECT 1, o.owner#, bo.name, o.subname, ' ', 9, tsp.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys."_CURRENT_EDITION_OBJ" bo, sys.tabsubpart$ tsp WHERE o.obj# = tsp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 2 AND tsp.file# = s.file# AND tsp.block# = s.block# AND tsp.ts# IN (:1, :2) UNION ALL SELECT 2, o.owner#, bo.name, o.subname, ' ', 10, isp.ts# FROM sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys."_CURRENT_EDITION_OBJ" bo, sys.indsubpart$ isp WHERE o.obj# = isp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 1 AND isp.file# = s.file# AND isp.block# = s.block# AND isp.ts# IN (:1, :2) ) o, sys.ts$ ts, sys.user$ u WHERE o.USER_NAME# = u.user# AND u.name NOT IN ('MGMT_VIEW', 'OUTLN', 'ANONYMOUS', 'DMSYS', 'LBACSYS', 'WKPROXY', 'TRACESVR', 'SCOTT', 'ADAMS', 'BLAKE', 'CLARK', 'JONES', 'HR', 'PM', 'OE', 'SH', 'IX') AND u.name NOT IN (SELECT DISTINCT schema_name FROM V$SYSAUX_OCCUPANTS) AND u.name NOT LIKE 'FLOWS!_%' escape '!' AND o.TABLESPACE# = ts.ts# AND u.type# !=2 AND ts.ts# IN (:1, :2) AND rownum < 201
apgb2g9q2zjh1	BEGIN :1 := orderentry.browseandupdateorders(:2 , :3 , :4 ); END;
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
bymb3ujkr3ubk	INSERT INTO ORDERS(ORDER_ID, ORDER_DATE, CUSTOMER_ID, WAREHOUSE_ID) VALUES (ORDERS_SEQ.NEXTVAL + :B3 , SYSTIMESTAMP , :B2 , :B1 ) RETURNING ORDER_ID INTO :O0
c13sma6rkr27c	SELECT PRODUCTS.PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY_ID, WEIGHT_CLASS, WARRANTY_PERIOD, SUPPLIER_ID, PRODUCT_STATUS, LIST_PRICE, MIN_PRICE, CATALOG_URL, QUANTITY_ON_HAND FROM PRODUCTS, INVENTORIES WHERE PRODUCTS.CATEGORY_ID = :B3 AND INVENTORIES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND INVENTORIES.WAREHOUSE_ID = :B2 AND ROWNUM < :B1
c749bc43qqfz3	SELECT SYSDATE FROM DUAL
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
dcq9a12vtcnuw	BEGIN :1 := orderentry.newcustomer(:2 , :3 , :4 , :5 , :6 , :7 ); END;
dwwbq1j9kw64f	select o.name, c.name from con$ c, user$ o where c.con# = :1 and owner# = user#
f7nhbjdn5rx9a	INSERT INTO MGMT_VIOLATIONS (TARGET_GUID, POLICY_GUID, KEY_VALUE, COLLECTION_TIMESTAMP, VIOLATION_LEVEL, VIOLATION_TYPE, VIOLATION_DURATION, VIOLATION_GUID, ANNOTATED_FLAG, NOTIFICATION_STATUS, VALUE, STRING_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, ACTION_MESSAGE, ACTION_MESSAGE_NLSID, ACTION_MESSAGE_PARAMS, ADVISORY_ID, CFG_COLL_NAME, CFG_KEY_VALUE, CFG_KEY_OPERATOR, LOAD_TIMESTAMP, USER_NAME) VALUES (:B24 , :B23 , NVL(:B22 , ' '), NVL(:B21 , SYSDATE), :B20 , NVL(:B19 , 0), :B18 , NVL(:B17 , SYS_GUID()), NVL(:B16 , 0), NVL(:B15 , 1), :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , NVL(:B2 , SYSDATE), NVL(:B1 , '<SYSTEM>') )
f9u2k84v884y7	UPDATE /+ index(orders, order_pk) / ORDERS SET ORDER_STATUS = FLOOR(DBMS_RANDOM.VALUE(:B3 + 1, :B2 )) WHERE ORDER_ID = :B1
gg8fha483ayww	select output from table(dbms_workload_repository.ash_report_html(:1, :2, :3, :4, 0))

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	11	0.01	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	1,416	1.39	0.04
Batched IO buffer defrag count	2	0.00	0.00
Batched IO double miss count	681	0.67	0.02
Batched IO same unit count	26	0.03	0.00
Batched IO single block count	324	0.32	0.01
Batched IO vector block count	1,065	1.04	0.03
Batched IO vector read count	368	0.36	0.01
Block Cleanout Optim referenced	38	0.04	0.00
CCursor + sql area evicted	21	0.02	0.00
CPU used by this session	113,225	111.05	2.91
CPU used when call started	110,031	107.91	2.83
CR blocks created	335	0.33	0.01
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	61	0.06	0.00
DB time	2,439,176	2,392.22	62.70
DBWR checkpoint buffers written	5,667	5.56	0.15
DBWR checkpoints	1	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	41	0.04	0.00
DBWR undo block writes	7,077	6.94	0.18
HSC Compressed Segment Block Changes	0	0.00	0.00
HSC Heap Segment Block Changes	47,362	46.45	1.22
HSC OLTP Compressed Blocks	0	0.00	0.00
HSC OLTP Non Compressible Blocks	0	0.00	0.00
HSC OLTP Space Saving	0	0.00	0.00
HSC OLTP inline compression	0	0.00	0.00
HSC OLTP positive compression	0	0.00	0.00
HSC OLTP recursive compression	0	0.00	0.00
Heap Segment Array Inserts	155	0.15	0.00
Heap Segment Array Updates	82	0.08	0.00
IMU CR rollbacks	121	0.12	0.00
IMU Flushes	9,656	9.47	0.25
IMU Redo allocation size	22,900,772	22,459.93	588.65
IMU commits	29,409	28.84	0.76
IMU contention	2,007	1.97	0.05
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	133	0.13	0.00
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	51,577,368	50,584.50	1,325.76
IMU- failed to get a private strand	133	0.13	0.00
Number of read IOs issued	48	0.05	0.00
Requests to/from client	31,142	30.54	0.80
RowCR - row contention	80	0.08	0.00
RowCR attempts	671	0.66	0.02
RowCR hits	1,322	1.30	0.03
SQL*Net roundtrips to/from client	31,143	30.54	0.80
TBS Extension: tasks created	65	0.06	0.00
active txn count during cleanout	563	0.55	0.01
application wait time	51	0.05	0.00
auto extends on undo tablespace	65	0.06	0.00
background checkpoints completed	2	0.00	0.00
background checkpoints started	1	0.00	0.00
background timeouts	4,853	4.76	0.12
branch node splits	17	0.02	0.00
buffer is not pinned count	882,537	865.55	22.68
buffer is pinned count	1,088,286	1,067.34	27.97
bytes received via SQL*Net from client	6,248,733	6,128.44	160.62
bytes sent via SQL*Net to client	3,371,457	3,306.56	86.66
calls to get snapshot scn: kcmgss	231,481	227.02	5.95
calls to kcmgas	42,719	41.90	1.10
calls to kcmgcs	14,106	13.83	0.36
cell physical IO interconnect bytes	795,680,256	780,363.29	20,452.40
change write time	16,458	16.14	0.42
cleanout - number of ktugct calls	676	0.66	0.02
cleanouts and rollbacks - consistent read gets	197	0.19	0.01
cleanouts only - consistent read gets	113	0.11	0.00
cluster key scan block gets	17,144	16.81	0.44
cluster key scans	16,099	15.79	0.41
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	7,953	7.80	0.20
commit batch/immediate requested	7,953	7.80	0.20
commit cleanout failures: block lost	1	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	25	0.02	0.00
commit cleanout failures: cannot pin	155	0.15	0.00
commit cleanouts	59,936	58.78	1.54
commit cleanouts successfully completed	59,755	58.60	1.54
commit immediate performed	7,953	7.80	0.20
commit immediate requested	7,953	7.80	0.20
commit txn count during cleanout	525	0.51	0.01
concurrency wait time	10,731	10.52	0.28
consistent changes	20,442	20.05	0.53
consistent gets	1,299,649	1,274.63	33.41
consistent gets - examination	838,967	822.82	21.57
consistent gets direct	2,857	2.80	0.07
consistent gets from cache	1,296,792	1,271.83	33.33
consistent gets from cache (fastpath)	439,589	431.13	11.30
cursor authentications	275	0.27	0.01
data blocks consistent reads - undo records applied	259	0.25	0.01
db block changes	418,524	410.47	10.76
db block gets	570,878	559.89	14.67
db block gets direct	26	0.03	0.00
db block gets from cache	570,852	559.86	14.67
db block gets from cache (fastpath)	138,240	135.58	3.55
deferred (CURRENT) block cleanout applications	14,739	14.46	0.38
dirty buffers inspected	4,925	4.83	0.13
enqueue conversions	3,673	3.60	0.09
enqueue releases	121,791	119.45	3.13
enqueue requests	121,788	119.44	3.13
enqueue timeouts	0	0.00	0.00
enqueue waits	55	0.05	0.00
exchange deadlocks	2	0.00	0.00
execute count	220,230	215.99	5.66
failed probes on index block reclamation	0	0.00	0.00
file io service time	186	0.18	0.00
file io wait time	154,018,413	151,053.53	3,958.94
free buffer inspected	55,743	54.67	1.43
free buffer requested	55,068	54.01	1.42
heap block compress	145	0.14	0.00
hot buffers moved to head of LRU	36,606	35.90	0.94
immediate (CR) block cleanout applications	310	0.30	0.01
immediate (CURRENT) block cleanout applications	5,742	5.63	0.15
in call idle wait time	4,562,418	4,474.59	117.27
index crx upgrade (positioned)	1,535	1.51	0.04
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	1	0.00	0.00
index fetch by key	255,186	250.27	6.56
index scans kdiixs1	101,180	99.23	2.60
leaf node 90-10 splits	14	0.01	0.00
leaf node splits	153	0.15	0.00
lob reads	5,252	5.15	0.13
lob writes	5,121	5.02	0.13
lob writes unaligned	5,121	5.02	0.13
logical read bytes from cache	15,299,731,456	15,005,209.21	393,268.85
logons cumulative	80	0.08	0.00
max cf enq hold time	1,500	1.47	0.04
messages received	40,544	39.76	1.04
messages sent	40,544	39.76	1.04
min active SCN optimization applied on CR	7,966	7.81	0.20
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	433,810	425.46	11.15
non-idle wait count	139,680	136.99	3.59
non-idle wait time	50,035	49.07	1.29
opened cursors cumulative	255,412	250.50	6.57
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	1,028	1.01	0.03
parse count (total)	12,532	12.29	0.32
parse time cpu	3,630	3.56	0.09
parse time elapsed	15,263	14.97	0.39
physical read IO requests	40,433	39.65	1.04
physical read bytes	357,015,552	350,142.95	9,176.83
physical read total IO requests	44,263	43.41	1.14
physical read total bytes	418,335,744	410,282.71	10,753.03
physical read total multi block requests	27	0.03	0.00
physical reads	43,581	42.74	1.12
physical reads cache	40,724	39.94	1.05
physical reads cache prefetch	1,037	1.02	0.03
physical reads direct	2,857	2.80	0.07
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	8,144	7.99	0.21
physical write bytes	221,708,288	217,440.37	5,698.86
physical write total IO requests	46,784	45.88	1.20
physical write total bytes	377,344,512	370,080.57	9,699.38
physical write total multi block requests	732	0.72	0.02
physical writes	27,064	26.54	0.70
physical writes direct	26	0.03	0.00
physical writes direct (lob)	4	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	27,038	26.52	0.69
physical writes non checkpoint	23,608	23.15	0.61
pinned buffers inspected	2	0.00	0.00
prefetch clients - default	4	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	339	0.33	0.01
recursive calls	474,814	465.67	12.20
recursive cpu usage	56,428	55.34	1.45
redo blocks checksummed by FG (exclusive)	26,000	25.50	0.67
redo blocks written	125,889	123.47	3.24
redo buffer allocation retries	3	0.00	0.00
redo entries	121,123	118.79	3.11
redo log space requests	3	0.00	0.00
redo log space wait time	6	0.01	0.00
redo ordering marks	1,924	1.89	0.05
redo size	49,347,332	48,397.39	1,268.44
redo size for direct writes	356	0.35	0.01
redo subscn max counts	4,069	3.99	0.10
redo synch long waits	574	0.56	0.01
redo synch time	4,515	4.43	0.12
redo synch time (usec)	45,121,574	44,252.98	1,159.82
redo synch writes	27,556	27.03	0.71
redo wastage	13,045,352	12,794.23	335.32
redo write time	11,164	10.95	0.29
redo writes	36,521	35.82	0.94
rollback changes - undo records applied	39,769	39.00	1.02
rollbacks only - consistent read gets	27	0.03	0.00
rows fetched via callback	166,700	163.49	4.28
session connect time	0	0.00	0.00
session cursor cache hits	244,320	239.62	6.28
session logical reads	1,870,525	1,834.52	48.08
shared hash latch upgrades - no wait	27,503	26.97	0.71
shared hash latch upgrades - wait	3	0.00	0.00
sorts (memory)	10,221	10.02	0.26
sorts (rows)	77,094	75.61	1.98
sql area evicted	884	0.87	0.02
sql area purged	0	0.00	0.00
summed dirty queue length	6,887	6.75	0.18
switch current to new buffer	149	0.15	0.00
table fetch by rowid	801,308	785.88	20.60
table fetch continued row	693	0.68	0.02
table scan blocks gotten	15,747	15.44	0.40
table scan rows gotten	273,546	268.28	7.03
table scans (direct read)	2	0.00	0.00
table scans (long tables)	1	0.00	0.00
table scans (short tables)	2,859	2.80	0.07
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	4,730	4.64	0.12
total number of cf enq holders	311	0.31	0.01
total number of times SMON posted	80	0.08	0.00
transaction rollbacks	7,950	7.80	0.20
undo change vector size	13,920,424	13,652.45	357.81
user I/O wait time	11,748	11.52	0.30
user calls	59,546	58.40	1.53
user commits	30,955	30.36	0.80
user rollbacks	7,949	7.80	0.20
workarea executions - optimal	15,808	15.50	0.41
write clones created in background	0	0.00	0.00
write clones created in foreground	13	0.01	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	500,954,688	656,198,896
session cursor cache count	4,989	5,953
session uga memory	116,054,432,240	193,368,268,080
opened cursors current	239	230
logons current	72	71
session uga memory max	455,386,664	538,780,248
session pga memory	259,731,040	314,918,832

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	1	3.53

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)
Buffer Cache Reads	317M	39.44	.310897	0M	0.00	0M	39.9K	3.43
DBWR	5M	0.32	.004903	214M	8.05	.209880	4044	10.11
Others	53M	3.41	.051979	87M	1.53	.085325	5034	3.98
LGWR	0M	0.02	0M	61M	36.46	.059825	73.3K	2.32
Direct Reads	22M	0.05	.021576	0M	0.00	0M	48	2.04
Direct Writes	0M	0.00	0M	0M	0.01	0M	6	0.50
TOTAL:	397M	43.24	.389357	362M	46.05	.355031	122.3K	3.01

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	340M	39.64	.333454	214M	8.13	.209880	3.38	3.41
Control File	57M	3.59	.055902	22M	1.33	.021576	0.51
Log File	0M	0.00	0M	61M	36.45	.059825	0.00
Temp File	0M	0.00	0M	1M	0.00	.000980
Other	0M	0.01	0M	0M	0.01	0M	0.00
TOTAL:	397M	43.24	.389357	298M	45.93	.292263	3.14	3.41

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)
Buffer Cache Reads	317M	39.46	.310897	0M	0.00	0M	39.2K	3.45
Buffer Cache Reads (Data File)	317M	39.46	.310897	0M	0.00	0M	39.2K	3.45
DBWR	5M	0.32	.004903	214M	8.05	.209880	325	0.45
DBWR (Data File)	0M	0.00	0M	214M	8.05	.209880	0
DBWR (Control File)	5M	0.32	.004903	0M	0.00	0M	325	0.45
Others	53M	3.40	.051979	87M	1.52	.085325	3542	0.71
Others (Control File)	52M	3.25	.050998	21M	1.32	.020595	3314	0.51
Others (Data File)	1M	0.15	.000980	66M	0.20	.064729	228	3.56
LGWR	0M	0.02	0M	61M	36.49	.059825	24	0.54
LGWR (Log File)	0M	0.00	0M	61M	36.47	.059825	4	1.00
LGWR (Control File)	0M	0.02	0M	0M	0.02	0M	20	0.45
Direct Writes	0M	0.00	0M	0M	0.01	0M	0
Direct Writes (Data File)	0M	0.00	0M	0M	0.01	0M	0
TOTAL:	375M	43.20	.367781	362M	46.07	.355031	43.1K	3.20

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)
SOE	38,855	38	2.90	1.00	7,191	7	307	13.00
SYSTEM	1,328	1	0.77	3.35	67	0	2	40.00
SYSAUX	847	1	0.89	1.02	467	0	0	0.00
UNDOTBS1	0	0	0.00	0.00	514	1	95	12.53
EXAMPLE	2	0	0.00	1.00	0	0	0	0.00
USERS	2	0	0.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)
EXAMPLE	/u01/app/oracle/oradata/DB11G/example01.dbf	2	0	0.00	1.00	0	0	0	0.00
SOE	/u01/app/oracle/product/11.2.0/db_1/dbs/soe.dbf	38,855	38	2.90	1.00	7,191	7	307	13.00
SYSAUX	/u01/app/oracle/oradata/DB11G/sysaux01.dbf	847	1	0.89	1.02	467	0	0	0.00
SYSTEM	/u01/app/oracle/oradata/DB11G/system01.dbf	1,328	1	0.77	3.35	67	0	2	40.00
UNDOTBS1	/u01/app/oracle/oradata/DB11G/undotbs01.dbf	0	0			514	1	95	12.53
USERS	/u01/app/oracle/oradata/DB11G/users01.dbf	2	0	0.00	1.00	0	0	0	0.00

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	45,663	98	1,868,955	40,850	26,949	0	0	401

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 27,064

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	5,667	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	14	1906	14283	165888	165888	407090
E	0	17	5768	36993	165883	165888	165883

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	36	0.10	4	2.76	382	1	744.00
D	72	0.19	9	2.12	292	1	541.00
D	108	0.29	13	1.72	238	1	417.00
D	144	0.39	18	1.49	205	1	342.00
D	180	0.48	22	1.33	184	1	294.00
D	216	0.58	27	1.23	170	1	263.00
D	252	0.68	31	1.16	160	1	240.00
D	288	0.77	35	1.09	150	1	218.00
D	324	0.87	40	1.04	144	1	203.00
D	360	0.97	44	1.01	139	1	193.00
D	372	1.00	46	1.00	138	1	190.00
D	396	1.06	49	0.98	135	1	184.00
D	432	1.16	53	0.97	134	1	180.00
D	468	1.26	57	0.96	133	1	178.00
D	504	1.35	62	0.95	132	1	175.00
D	540	1.45	66	0.95	131	1	174.00
D	576	1.55	71	0.94	130	1	173.00
D	612	1.65	75	0.94	130	1	172.00
D	648	1.74	80	0.94	130	1	172.00
D	684	1.84	84	0.94	130	1	172.00
D	720	1.94	88	0.94	130	1	172.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	7,653	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	200	63	188.50	0.00	0.00	0.00	0.00	40,960
E	200	57	183.94	0.83	0.45	100.00	0.00	40,960

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	5,021	5,021
64K	128K	14	14
128K	256K	38	38
256K	512K	4	4
512K	1024K	10,740	10,740
1M	2M	6	6
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
25	0.13	9,757.59	633.61	94.00	176	1,649,241
50	0.25	9,757.59	628.22	94.00	146	1,648,385
100	0.50	9,757.59	566.49	95.00	134	1,638,588
150	0.75	9,757.59	22.63	100.00	8	1,552,269
200	1.00	9,757.59	0.00	100.00	0	1,548,677
240	1.20	9,757.59	0.00	100.00	0	1,548,677
280	1.40	9,757.59	0.00	100.00	0	1,548,677
320	1.60	9,757.59	0.00	100.00	0	1,548,677
360	1.80	9,757.59	0.00	100.00	0	1,548,677
400	2.00	9,757.59	0.00	100.00	0	1,548,677
600	3.00	9,757.59	0.00	100.00	0	1,548,677
800	4.00	9,757.59	0.00	100.00	0	1,548,677
1,200	6.00	9,757.59	0.00	100.00	0	1,548,677
1,600	8.00	9,757.59	0.00	100.00	0	1,548,677

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)
156	0.76	2	518	61,488	0.48	67,081	101.79	1,751
164	0.80	10	948	73,375	0.57	55,194	83.75	1,905
168	0.82	13	1,150	79,107	0.62	49,462	75.06	1,962
172	0.84	16	1,295	84,805	0.66	43,764	66.41	1,990
176	0.86	20	1,460	90,353	0.71	38,216	57.99	2,017
180	0.88	24	1,596	96,021	0.75	32,548	49.39	2,037
184	0.90	28	1,624	101,365	0.79	27,204	41.28	2,054
188	0.92	32	1,647	106,994	0.84	21,575	32.74	2,072
192	0.94	36	1,665	112,422	0.88	16,147	24.50	2,088
196	0.96	39	1,781	117,951	0.92	10,618	16.11	2,105
200	0.98	43	1,941	122,857	0.96	5,712	8.67	2,119
204	1.00	47	2,115	127,910	1.00	659	1.00	2,134
208	1.02	51	2,302	127,925	1.00	644	0.98	2,135
212	1.04	54	2,545	127,929	1.00	640	0.97	2,135
216	1.06	57	2,760	127,930	1.00	639	0.97	2,135
220	1.08	61	2,859	127,930	1.00	639	0.97	2,136
224	1.10	65	2,988	127,931	1.00	638	0.97	2,136
228	1.12	68	3,294	127,933	1.00	636	0.97	2,136
232	1.14	72	3,531	127,942	1.00	627	0.95	2,137
236	1.16	73	3,635	127,943	1.00	626	0.95	2,137
240	1.18	78	3,921	127,943	1.00	626	0.95	2,137
252	1.24	89	4,621	127,945	1.00	624	0.95	2,137
276	1.35	113	5,558	127,948	1.00	621	0.94	2,138
300	1.47	137	6,702	127,950	1.00	619	0.94	2,139
324	1.59	161	7,781	127,951	1.00	618	0.94	2,139
348	1.71	185	8,963	127,952	1.00	617	0.94	2,139
372	1.82	209	10,198	127,952	1.00	617	0.94	2,139
396	1.94	233	11,562	127,952	1.00	617	0.94	2,139
420	2.06	257	13,469	127,952	1.00	617	0.94	2,140

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
300	0.50	7,643	289,991
450	0.75	7,360	168,817
600	1.00	7,273	138,137
750	1.25	7,259	131,410
900	1.50	7,251	129,241
1,050	1.75	7,265	128,923
1,200	2.00	7,271	128,827

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	307	4	13
undo header	74	1	11
file header block	8	0	45
undo block	13	0	3

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Waits	Wt Time (s)	Av Wt Time(ms)
HW-Segment High Water Mark	5,710	5,710	44	7	160.45
US-Undo Segment	2,428	2,428	8	0	13.75
TX-Transaction (index contention)	45	45	3	0	20.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	8.39	41,108	2,761	9	49.9/60.1	0/0	0/0/0/636/72704/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
07-Oct 21:08	5,206	25,003	2,761	9	60	0/0	0/0/0/256/27136/0
07-Oct 20:58	3,186	16,105	2,155	8	50	0/0	0/0/0/380/45568/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 dequeue txn counter latch	876	0.00		0	0
ASM db client latch	929	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	19	0.00		0	0
AWR Alerted Metric Element list	8,025	0.00		0	0
Change Notification Hash table latch	334	0.00		0	0
Consistent RBA	36,599	0.00		0	0
DML lock allocation	122,875	0.02	0.68	0	0
Event Group Locks	145	0.00		0	0
FIB s.o chain latch	146	0.00		0	0
FOB s.o list latch	333	0.00		0	0
File State Object Pool Parent Latch	1	0.00		0	0
I/O Staticstics latch	1	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	250,163	0.23	0.96	6	39,500	0.01
JS Sh mem access	3	33.33	1.00	0	0
JS mem alloc latch	2	0.00		0	0
JS queue access latch	3	0.00		0	0
JS queue state obj latch	7,036	0.00		0	0
JS slv state obj latch	66	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
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	493	0.00		0	0
KMG resize request state object freelist	2	0.00		0	0
KTF sga latch	7	0.00		0	341	0.00
KWQMN job cache list latch	1	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	4	0.00		0	0
KWQS pqueue ctx latch	35	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1	0.00		0	0
MQL Tracking Latch	0			0	21	0.00
Memory Management Latch	179	0.00		0	493	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	12	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	435	0.00		0	0
OS process allocation	2,266	0.00		0	0
OS process: request allocation	126	0.00		0	0
PL/SQL warning settings	28,121	0.00		0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	157	0.00		0	0
SGA IO buffer pool latch	3	0.00		0	3	0.00
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	0.00		0	333	0.00
SQL memory manager workarea list latch	72,615	0.00		0	0
Shared B-Tree	134	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
Undo Hint Latch	0			0	405	0.00
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	1	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	3,991	0.00		0	0
active service list	10,170	0.00		0	5,127	0.00
archive control	62	0.00		0	0
begin backup scn array	6	0.00		0	0
buffer pool	4	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	932	0.00		0	0
cache buffers chains	4,212,079	0.15	0.04	3	77,609	0.02
cache buffers lru chain	29,468	0.26	0.86	1	94,165	1.55
cache table scan latch	67	0.00		0	67	0.00
call allocation	2,704	0.04	1.00	0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	134	0.00		0	0
channel operations parent latch	9,304	0.00		0	0
checkpoint queue latch	64,105	0.02	0.50	0	29,500	0.08
client/application info	254,613	1.29	0.84	31	0
compile environment latch	81	0.00		0	0
corrupted undo seg latch	127,625	0.01	0.27	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	19	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	19	0.00		0	0
dml lock allocation	79	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	163	0.00		0	0
enqueue freelist latch	1	0.00		0	39,899	0.01
enqueue hash chains	247,783	0.18	0.81	5	4	0.00
enqueues	31	0.00		0	0
fifth spare latch	1	0.00		0	0
file cache latch	953	0.00		0	0
flashback copy	1	0.00		0	0
fourth Audit Vault latch	1	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	23	0.00		0	0
global ctx hash table latch	5	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	622	0.00		0	797,201	0.00
hash table modification latch	74	0.00		0	0
heartbeat check	1	0.00		0	0
internal temp table object number allocation latch	5	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	19	0.00		0	18	0.00
job_queue_processes free list latch	40	0.00		0	0
job_queue_processes parameter latch	228	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	1	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kgnfs mount latch	1	0.00		0	0
kokc descriptor allocation latch	338	0.00		0	0
ksfv messages	1	0.00		0	0
ksim group membership cache	1	0.00		0	0
kss move lock	9	0.00		0	0
ksuosstats global area	107	0.00		0	0
ksv allocation latch	36	0.00		0	0
ksv class latch	19	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	126	0.00		0	0
ktm global data	325	0.00		0	0
kwqbsn:qsga	52	0.00		0	0
lgwr LWN SCN	36,629	0.00		0	0
list of block allocation	149	0.00		0	0
loader state object freelist	54	0.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	1	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	829	0.00		0	0
messages	130,346	0.04	0.70	0	0
mostly latch-free SCN	36,653	0.00		0	0
msg queue latch	1	0.00		0	0
multiblock read objects	956	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	19	0.00		0	0
object queue header heap	8,376	0.00		0	1,833	0.00
object queue header operation	203,553	0.18	0.76	3	880	0.00
object stats modification	660	0.00		0	0
parallel query alloc buffer	137	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	85	0.00		0	0
parameter table management	460	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	9,210	0.27	0.76	0	7,413	0.19
process allocation	162	0.00		0	63	0.00
process group creation	126	0.00		0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	148	7.43	0.91	0	0
query server freelists	1	0.00		0	0
queued dump request	3	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	189,954	0.20	0.76	3	120,907	0.79
redo copy	1	0.00		0	121,309	1.88
redo writing	115,087	0.00	0.67	0	0
resmgr group change latch	64	0.00		0	0
resmgr:active threads	164	0.00		0	0
resmgr:actses change group	49	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	162	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	2	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	1,453,889	0.05	0.47	5	1,788	0.06
rules engine rule set statistics	100	0.00		0	0
second Audit Vault latch	1	0.00		0	0
second spare latch	1	0.00		0	0
sequence cache	33,980	0.06	0.79	0	0
session allocation	75,970	0.03	0.86	0	75,809	0.05
session idle bit	195,015	0.01	0.75	0	0
session queue latch	1	0.00		0	0
session state list latch	145	0.00		0	0
session switching	83	0.00		0	0
session timer	337	0.00		0	0
shared pool	125,867	0.03	0.66	0	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	6,062	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	84,582	0.01	0.90	0	0
simulator lru latch	17,167	0.17	0.67	0	62,699	1.54
sort extent pool	117	0.00		0	0
space background state object latch	1	0.00		0	0
space background task latch	6,295	5.05	0.98	6	687	0.15
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	1	0.00		0	0
temporary table state object allocation	1	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	44	0.00		0	0
trace latch	1	0.00		0	0
transaction allocation	2,227	0.00		0	0
undo global data	241,486	0.02	0.76	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
cache buffers chains	4,212,079	6,285	244	6,045
client/application info	254,613	3,287	2,763	540
row cache objects	1,453,889	757	355	406
In memory undo latch	250,163	585	563	33
enqueue hash chains	247,783	452	365	92
redo allocation	189,954	374	286	88
object queue header operation	203,553	363	277	94
space background task latch	6,295	318	311	8
cache buffers lru chain	29,468	78	67	11
messages	130,346	53	37	16
shared pool	125,867	44	29	20
undo global data	241,486	42	32	10
simulator lru latch	17,167	30	20	11
post/wait queue	9,210	25	19	6
session allocation	75,970	21	18	4
DML lock allocation	122,875	19	13	6
sequence cache	33,980	19	15	4
session idle bit	195,015	16	12	4
corrupted undo seg latch	127,625	11	3	8
qmn task queue latch	148	11	10	1
checkpoint queue latch	64,105	10	5	5
simulator hash latch	84,582	10	9	1
redo writing	115,087	3	2	1
JS Sh mem access	3	1	1	0
call allocation	2,704	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
DML lock allocation	ktaiam	7	9
DML lock allocation	ktaidm	6	5
In memory undo latch	ktiFlush: child	293	336
In memory undo latch	kticmt: child	113	18
In memory undo latch	ktiFlushMe	86	79
In memory undo latch	ktichg: child	73	121
In memory undo latch	ktiTxnPoolFree	1	0
In memory undo latch	kturbk	1	14
JS Sh mem access	jsksGetShMemLatch	1	1
PC and Classifier lists for WLM	No latch	1	0
cache buffers chains	kcbget: fast exchange	81	59
cache buffers chains	kcbgtcr: fast path	37	18
cache buffers chains	kcbgtcr: fast path (cr pin)	37	16
cache buffers chains	kcbgcur_2	36	45
cache buffers chains	kcbget: fast path	12	1
cache buffers chains	kcbgcur_4	8	9
cache buffers chains	kcbchg1: mod cr pin	6	3
cache buffers chains	kcbnew: new latch again	6	0
cache buffers chains	kcbzgb: scan from tail. nowait	5	0
cache buffers chains	kcbgtcr: kslbegin shared	3	0
cache buffers chains	kcbrls: fast release	3	11
cache buffers chains	kcb_post_apply: kcbhq62	2	4
cache buffers chains	kcbgcur: fast path (shr)	2	1
cache buffers chains	kcbzhngcbk1_1	2	0
cache buffers chains	kcb_commit	1	11
cache buffers chains	kcb_trim_hash_chain	1	0
cache buffers chains	kcbchg1: clear MS bit	1	3
cache buffers chains	kcbesc: escalate	1	1
cache buffers chains	kcbget: pin buffer	1	0
cache buffers chains	kcbgtcr_1	1	0
cache buffers chains	kcbgtcr_2	1	3
cache buffers chains	kcbzib: exchange rls	1	12
cache buffers lru chain	kcbzgws	63	34
cache buffers lru chain	kcbbxsv: move to being written	1	0
cache buffers lru chain	kcbzswcu	1	0
call allocation	ksuprc	1	1
checkpoint queue latch	kcbklbc_cql	5	0
client/application info	ksuinfos_modact	2,789	2,793
client/application info	kskirefrattrmap	3	0
client/application info	ksuinfos_cinfo	1	0
corrupted undo seg latch	ktudiscorrupted	3	3
enqueue hash chains	ksqgtl3	196	228
enqueue hash chains	ksqrcl	165	135
enqueue hash chains	ksqcnl	3	2
enqueue hash chains	ksqcmi: get hash chain latch after wait	1	0
messages	ksaamb: after wakeup	17	25
messages	ksarcv	11	8
messages	ksarcv: after wait	9	6
object queue header operation	kcbo_unlink_q	95	85
object queue header operation	kcbo_switch_cq	81	153
object queue header operation	kcbo_switch_q_bg	48	7
object queue header operation	kcbo_link_q	47	4
object queue header operation	kcbo_switch_mq_bg	11	18
post/wait queue	ksliwat:remove	11	19
post/wait queue	ksliwat:add:nowait	8	0
qmn task queue latch	kwqmnmvtsks: delay to ready list	10	0
redo allocation	kcrfw_redo_gen: redo allocation 1	269	0
redo allocation	kcrfw_redo_gen: redo allocation 3	11	4
redo allocation	kcrfw_redo_gen: redo allocation 2	2	0
redo allocation	kcrfw_redo_write: before write	2	234
redo allocation	kcsra1	1	1
redo writing	kcrfwcr	2	2
row cache objects	kqreqd: reget	262	0
row cache objects	kqrpre: find obj	82	339
row cache objects	kqreqd	7	11
sequence cache	kdnssd	11	0
sequence cache	kdnnxt: cached seq	3	0
sequence cache	kdnss	1	15
session allocation	ksuxds	10	18
session allocation	ksucri_int : SSO	8	0
session idle bit	ksuxds	7	2
session idle bit	ksupuc: set busy	4	4
session idle bit	ksupuc: clear busy	1	6
shared pool	kghalo	24	3
shared pool	kghupr1	3	22
shared pool	kghalp	2	4
shared pool	kghfrunp: clatch: nowait	1	0
simulator hash latch	kcbsacc: lookup dba	5	8
simulator hash latch	kcbs_lookup_setid: lookup dba	3	0
simulator hash latch	kcbsacc: insert dba	1	0
simulator lru latch	kcbs_simulate: simulate set	20	0
space background task latch	ktsj_grab_task	277	311
space background task latch	ktsjCreateTask	33	0
undo global data	ktudnx:child	19	9
undo global data	ktubnd_4	9	0
undo global data	ktusm_stealext_2	3	0
undo global data	ktusmupst: KSLBEGIN	1	1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglpin1 4	2,295
Library Cache	kglpndl1 95	1,813
Cursor Pin	kksfbc [KKSCHLFSP2]	443
Library Cache	kglobpn1 71	94
Library Cache	kgllkc1 57	41
Library Cache	kglpnal1 90	34
Library Cache	kgllkdl1 85	30
Cursor Pin	kksLockDelete [KKSCHLPIN6]	22
Cursor Pin	kksxsccmp [KKSCHLPIN5]	18
Cursor Pin	kkslce [KKSCHLPIN2]	11
Cursor Pin	kksfbc [KKSCHLPIN1]	5

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: 1,870,525
Captured Segments account for 82.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SOE	SOE	INVENTORY_PK	INDEX	286,224	15.30
SOE	SOE	PRD_DESC_PK	INDEX	154,384	8.25
SOE	SOE	INVENTORIES	TABLE	138,976	7.43
SOE	SOE	PRODUCT_INFORMATION	TABLE	137,376	7.34
SOE	SOE	CUSTOMERS_PK	INDEX	115,856	6.19

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 43,581
Captured Segments account for 94.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SOE	SOE	ORDER_PK	INDEX	9,923	22.77
SOE	SOE	INVENTORIES	TABLE	6,663	15.29
SOE	SOE	CUSTOMERS_PK	INDEX	6,084	13.96
SOE	SOE	CUSTOMERS	TABLE	4,709	10.81
SOE	SOE	ITEM_ORDER_IX	INDEX	4,351	9.98

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 40,433
Captured Segments account for 94.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
SOE	SOE	ORDER_PK	INDEX	9,923	24.54
SOE	SOE	INVENTORIES	TABLE	6,663	16.48
SOE	SOE	CUSTOMERS_PK	INDEX	6,084	15.05
SOE	SOE	CUSTOMERS	TABLE	4,709	11.65
SOE	SOE	ITEM_ORDER_IX	INDEX	4,351	10.76

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 40,433
Captured Segments account for 94.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
SOE	SOE	ORDER_PK	INDEX	9,923	24.54
SOE	SOE	INVENTORIES	TABLE	6,663	16.48
SOE	SOE	CUSTOMERS_PK	INDEX	6,084	15.05
SOE	SOE	CUSTOMERS	TABLE	4,709	11.65
SOE	SOE	ITEM_ORDER_IX	INDEX	4,351	10.76

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: 2,857
Captured Segments account for 99.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
SYS	SYSTEM	COL$		TABLE	2,854	99.89

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 27,064
Captured Segments account for 70.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
SOE	SOE	ORDER_PK	INDEX	7,161	26.46
SOE	SOE	ORD_WAREHOUSE_IX	INDEX	5,679	20.98
SOE	SOE	CUSTOMERS_PK	INDEX	2,638	9.75
SOE	SOE	ORDERS	TABLE	1,782	6.58
SOE	SOE	ORD_ORDER_DATE_IX	INDEX	706	2.61

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 8,144
Captured Segments account for 89.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
SOE	SOE	ORD_WAREHOUSE_IX	INDEX	3,995	49.05
SOE	SOE	ORD_ORDER_DATE_IX	INDEX	691	8.48
SOE	SOE	ORDER_PK	INDEX	636	7.81
SOE	SOE	ORDERS	TABLE	598	7.34
SOE	SOE	CUST_UPPER_NAME_IX	INDEX	484	5.94

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 26
Captured Segments account for 84.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_279886783_80	TABLE PARTITION	22	84.62

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 2
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	COL$		TABLE	1	50.00
SYS	SYSTEM	I_OBJ1		INDEX	1	50.00

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
SYSMAN	TEMP	MGMT_TARGET_TEMP_LIST	TABLE	20,032	25.48
SOE	SOE	ORD_WAREHOUSE_IX	INDEX	14,224	18.09
SOE	SOE	ORD_CUSTOMER_IX	INDEX	9,120	11.60
SOE	SOE	ORD_ORDER_DATE_IX	INDEX	8,592	10.93
SOE	SOE	ORDER_PK	INDEX	8,400	10.68

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
SOE	SOE	CUST_EMAIL_IX	INDEX	16	32.65
SOE	SOE	CUST_UPPER_NAME_IX	INDEX	15	30.61
SOE	SOE	CUST_ACCOUNT_MANAGER_IX	INDEX	5	10.20
SOE	SOE	CUST_LNAME_IX	INDEX	5	10.20
SYS	SYSAUX	WRH$_SEG_STAT_OBJ_INDEX	INDEX	2	4.08

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
SYSMAN	SYSAUX	MGMT_LAST_VIOLATION_IDX01		INDEX	1	100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SOE	SOE	ORDERS	TABLE	109	35.50
SOE	SOE	ORD_CUSTOMER_IX	INDEX	86	28.01
SOE	SOE	CUSTOMERS	TABLE	56	18.24
SOE	SOE	LOGON	TABLE	40	13.03
SOE	SOE	ORD_ORDER_DATE_IX	INDEX	10	3.26

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	21	0.00	2	1
dc_files	24	25.00	0	6
dc_global_oids	1,662	1.56	0	44
dc_histogram_data	30,003	2.46	0	1,154
dc_histogram_defs	97,371	3.26	0	2,151
dc_object_grants	243	0.82	0	12
dc_objects	37,544	2.51	1	1,493
dc_profiles	64	1.56	0	2
dc_rollback_segments	10,033	0.00	0	22
dc_segments	7,216	6.49	103	510
dc_sequences	4	100.00	4	0
dc_tablespaces	175,530	0.00	0	7
dc_users	143,447	0.00	0	82
global database name	712	0.00	0	1
outstanding_alerts	10	100.00	0	5
sch_lj_oids	2	100.00	0	0

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	46	4.35	0		0	0
APP CONTEXT	3	0.00	525	0.00	0	0
BODY	398	8.29	122,306	0.05	24	0
CLUSTER	181	1.66	181	1.66	0	0
DBLINK	52	1.92	0		0	0
EDITION	48	2.08	89	2.25	0	0
INDEX	84	45.24	84	45.24	0	0
QUEUE	19	0.00	2,971	0.00	0	0
SCHEMA	1,160	0.26	0		0	0
SQL AREA	5,410	43.55	265,598	0.90	444	20
SQL AREA BUILD	934	88.76	0		0	0
SQL AREA STATS	814	75.06	814	75.06	0	0
SUBSCRIPTION	2	0.00	2	100.00	2	0
TABLE/PROCEDURE	8,370	10.87	158,878	1.51	875	0
TRIGGER	26	0.00	873	0.92	5	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	380.00	372.00	372.00	408.00	1	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	200.00	200.00	200.00	200.00	0	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	600.00	600.00	600.00	600.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	4.00	4.00	4.00	4.00	0	STA/
shared pool	196.00	204.00	168.00	204.00	1	GRO/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	372.00	372.00	372.00	1	0	1
shared pool	204.00	204.00	204.00	1	1	0

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	Target Delta	Final (M)	Sta
10/07 20:54:22	3	bufcache	SHR/DEF	380	-8		372	COM
10/07 20:54:22	3	shared	GRO/DEF	196	8		204	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	134.32		1.82	1.75	12	17	74	74
B	Freeable	23.94	0.00	0.70	0.44	2		34	34
B	PL/SQL	16.51	14.34	0.23	0.51	3	3	72	72
B	SQL	5.45	1.54	0.09	0.10	1	20	61	56
E	Other	133.82		1.83	1.78	12	19	73	73
E	Freeable	27.94	0.00	0.72	0.37	1		39	39
E	PL/SQL	17.67	13.72	0.25	0.48	2	4	71	71
E	SQL	4.80	1.56	0.08	0.10	1	20	60	53

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	398,458,880	390,070,272
Fixed Size	2,230,952
Redo Buffers	7,532,544
Variable Size	218,105,176	226,493,784

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	4.00	4.00	0.00
large	PX msg pool	0.47	0.47	0.00
large	free memory	3.53	3.53	0.00
shared	ASH buffers	4.00	4.00	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGLH0	20.18	21.63	7.16
shared	KGLHD	4.44	5.77	29.92
shared	KGLS	5.08	5.22	2.79
shared	KGLSG	5.02	5.02	0.00
shared	KKSSP	4.26	4.30	0.71
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	PLMCD	4.12	6.75	63.84
shared	SQLA	18.39	31.13	69.31
shared	XDBSC	9.62	9.62	0.00
shared	db_block_hash_buckets	2.79	2.79	0.00
shared	dbktb: trace buffer	2.34	2.34	0.00
shared	dbwriter coalesce buffer	3.79	3.79	0.00
shared	event statistics per sess	3.10	3.10	0.00
shared	free memory	34.31	23.52	-31.45
shared	kglsim hash table bkts	4.00	4.00	0.00
shared	kglsim object batch	2.10	2.10	0.00
shared	ksunfy : SSO free list	2.89	2.89	0.00
shared	obj stats allocation chun	2.46	2.46	0.00
shared	private strands	3.51	3.51	0.00
shared	row cache	7.24	7.24	0.00
shared	write state object	2.16	2.16	0.00
streams	KTG hash buckets	1.26	1.26	0.00
streams	free memory	2.74	2.74	0.00
	buffer_cache	380.00	372.00	-2.11
	fixed_sga	2.13	2.13	0.00
	log_buffer	7.18	7.18	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 CPU Time, descending

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	1007 20:18:50	0.60	0.00	0.00
QMON Coordinator	1007 20:18:40	0.46	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

No data exists for this section of the report.

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(12733)	0	0			0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(77762)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(77432)	22	22	0.00	0.00	0.24	0.82	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(12733)	0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(77762)	0.00	0.00
SYSMAN.MGMT_TASK_Q(77432)	0.02	0.02	0.01	0.04

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	Dequeue Msgs	Expire Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE	0	0	0
OL6_112_LOCAL_3938_DB11G(41)/SYS.ALERT_QUE	0	0	0	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

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,017	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,017	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/app/oracle/admin/DB11G/adump
audit_trail	DB
compatible	11.2.0.0.0
control_files	/u01/app/oracle/oradata/DB11G/control01.ctl, /u01/app/oracle/fast_recovery_area/DB11G/control02.ctl
db_block_size	8192
db_domain	WORLD
db_name	DB11G
db_recovery_file_dest	/u01/app/oracle/fast_recovery_area
db_recovery_file_dest_size	10485760000
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=DB11GXDB)
job_queue_processes	1000
open_cursors	300
pga_aggregate_target	209715200
processes	150
remote_login_passwordfile	EXCLUSIVE
sga_target	629145600
undo_tablespace	UNDOTBS1
use_large_pages	ONLY

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

This section only displays parameters that have more one value
'(NULL)' indicates a missing parameter value
A blank in the End Snapshot indicates the same value as the BeginSnapshot

Parameter Name	Begin value	End value (if different)
control_files	/u01/app/oracle/fast_recovery_area/DB11G/control02.ctl
control_files	/u01/app/oracle/oradata/DB11G/control01.ctl

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	97.82	In-memory Sort %:	100.00
Library Hit %:	99.00	Soft Parse %:	91.80
Execute to Parse %:	94.31	Latch Hit %:	99.85
Parse CPU to Parse Elapsd %:	23.78	% Non-Parse CPU:	96.98