WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

LINUXS 570420430 linuxs 1 17-Sep-09 19:09 11.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
LINUXS	570420430	linuxs	1	17-Sep-09 19:09	11.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

stadf26 Linux IA (32-bit) 2 1 1 1.98

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
stadf26	Linux IA (32-bit)	2	1	1	1.98

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 688 18-Sep-09 03:17:32 28 1.3

End Snap: 689 18-Sep-09 03:27:21 28 1.3

Elapsed: 9.82 (mins)

DB Time: 55.06 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	688	18-Sep-09 03:17:32	28	1.3
End Snap:	689	18-Sep-09 03:27:21	28	1.3
Elapsed:		9.82 (mins)
DB Time:		55.06 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 100M 100M Log Buffer: 6,504K

	Begin	End
Buffer Cache:	16M	16M	Std Block Size:	8K
Shared Pool Size:	100M	100M	Log Buffer:	6,504K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 5.6 0.4 0.03 0.02

DB CPU(s): 1.4 0.1 0.01 0.01

Redo size: 351,169.2 21,755.4

Logical reads: 3,962.5 245.5

Block changes: 2,833.4 175.5

Physical reads: 4.0 0.2

Physical writes: 18.0 1.1

User calls: 229.3 14.2

Parses: 217.4 13.5

Hard parses: 0.1 0.0

W/A MB processed: 0.1 0.0

Logons: 17.0 1.1

Executes: 202.2 12.5

Rollbacks: 0.0 0.0

Transactions: 16.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	5.6	0.4	0.03	0.02
DB CPU(s):	1.4	0.1	0.01	0.01
Redo size:	351,169.2	21,755.4
Logical reads:	3,962.5	245.5
Block changes:	2,833.4	175.5
Physical reads:	4.0	0.2
Physical writes:	18.0	1.1
User calls:	229.3	14.2
Parses:	217.4	13.5
Hard parses:	0.1	0.0
W/A MB processed:	0.1	0.0
Logons:	17.0	1.1
Executes:	202.2	12.5
Rollbacks:	0.0	0.0
Transactions:	16.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 98.95 Redo NoWait %: 99.99

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

Library Hit %: 99.70 Soft Parse %: 99.95

Execute to Parse %: -7.52 Latch Hit %: 99.75

Parse CPU to Parse Elapsd %: 14.04 % Non-Parse CPU: 97.40

Shared Pool Statistics

Begin End

Memory Usage %: 92.06 92.31

% SQL with executions>1: 51.50 70.45

% Memory for SQL w/exec>1: 36.94 74.15

	Begin	End
Memory Usage %:	92.06	92.31
% SQL with executions>1:	51.50	70.45
% Memory for SQL w/exec>1:	36.94	74.15

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		848		25.68
log file sync	23,580	727	31	22.01	Commit
buffer busy waits	12,604	399	32	12.06	Concurrency
library cache: mutex X	1,560	263	169	7.97	Concurrency
latch: In memory undo latch	5,399	72	13	2.18	Concurrency

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

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

0.37 17.61 53.1 43.6 0.9 3.1

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.37	17.61	53.1	43.6	0.9	3.1

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

73.2 75.6 0.0

Memory Statistics

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

Begin End

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

SGA use (MB): 171.6 171.6

PGA use (MB): 43.8 43.6

% Host Mem used for SGA+PGA: 10.63 10.63

	Begin	End
Host Mem (MB):	2,025.4	2,025.4
SGA use (MB):	171.6	171.6
PGA use (MB):	43.8	43.6
% Host Mem used for SGA+PGA:	10.63	10.63

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): 3303.9s
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	1,091.29	33.03
connection management call elapsed time	1,060.72	32.11
DB CPU	848.32	25.68
parse time elapsed	167.72	5.08
hard parse elapsed time	6.91	0.21
PL/SQL execution elapsed time	1.32	0.04
hard parse (bind mismatch) elapsed time	0.28	0.01
hard parse (sharing criteria) elapsed time	0.28	0.01
PL/SQL compilation elapsed time	0.26	0.01
repeated bind elapsed time	0.21	0.01
sequence load elapsed time	0.21	0.01
DB time	3,303.89
background elapsed time	389.88
background cpu time	14.71

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	114,192
IDLE_TIME	3,679
IOWAIT_TIME	1,115
NICE_TIME	0
SYS_TIME	51,392
USER_TIME	62,564
LOAD	0	18
PHYSICAL_MEMORY_BYTES	2,123,755,520
NUM_CPUS	2
NUM_CPU_CORES	1
NUM_CPU_SOCKETS	1
GLOBAL_RECEIVE_SIZE_MAX	524,288
GLOBAL_SEND_SIZE_MAX	524,288
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	174,760
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	131,072
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
18-Sep 03:17:32	0.37
18-Sep 03:27:21	17.61	96.88	53.08	43.60	3.12	0.95

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 75.4% of Total DB time 3,303.89 (s)
Total FG Wait Time: 1,641.78 (s) DB CPU time: 848.32 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Concurrency	24,407	0	856	35	25.90
DB CPU			848		25.68
Commit	23,580	0	727	31	22.01
Application	440	0	33	76	1.01
Other	355	3	11	30	0.33
User I/O	9,585	0	10	1	0.31
Configuration	36	0	3	90	0.10
Network	81,287	0	1	0	0.04
System I/O	81	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
log file sync	23,580	0	727	31	2.48	22.01
buffer busy waits	12,604	0	399	32	1.33	12.06
library cache: mutex X	1,560	0	263	169	0.16	7.97
latch: In memory undo latch	5,399	0	72	13	0.57	2.18
latch: cache buffers chains	3,192	0	56	18	0.34	1.70
latch: row cache objects	1,225	0	44	36	0.13	1.34
enq: TX - row lock contention	440	0	33	76	0.05	1.01
cursor: pin S	55	0	11	201	0.01	0.33
latch: shared pool	369	0	10	28	0.04	0.31
Disk file operations I/O	8,726	0	10	1	0.92	0.30
latch free	161	0	6	38	0.02	0.18
latch: enqueue hash chains	144	0	4	27	0.02	0.12
log file switch (private strand flush incomplete)	10	0	2	214	0.00	0.06
SQL*Net message to client	81,287	0	1	0	8.55	0.04
log file switch (checkpoint incomplete)	11	0	1	67	0.00	0.02
enq: HW - contention	15	0	0	23	0.00	0.01
latch: session allocation	21	0	0	15	0.00	0.01
latch: cache buffers lru chain	1	0	0	229	0.00	0.01
latch: undo global data	6	0	0	30	0.00	0.01
latch: messages	7	0	0	21	0.00	0.00
direct path write temp	51	0	0	2	0.01	0.00
latch: Change Notification Hash table latch	5	0	0	15	0.00	0.00
cursor: mutex S	2	100	0	32	0.00	0.00
db file sequential read	789	0	0	0	0.08	0.00
direct path sync	1	0	0	18	0.00	0.00
library cache load lock	1	0	0	17	0.00	0.00
control file sequential read	81	0	0	0	0.01	0.00
SQL*Net message from client	81,287	0	1,892	23	8.55
jobq slave wait	120	100	61	507	0.01

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	44,414	0	206	5	4.67	52.92
db file async I/O submit	232	0	89	384	0.02	22.86
latch free	273	0	19	70	0.03	4.88
LGWR wait for redo copy	888	0	8	9	0.09	2.01
control file parallel write	368	0	7	19	0.04	1.76
latch: shared pool	242	0	5	22	0.03	1.35
latch: call allocation	244	0	5	20	0.03	1.25
os thread startup	4	0	4	898	0.00	0.92
asynch descriptor resize	10,004	100	2	0	1.05	0.41
latch: redo allocation	51	0	1	15	0.01	0.20
db file single write	30	0	1	23	0.00	0.18
latch: messages	11	0	0	40	0.00	0.11
SQL*Net message to client	30,000	0	0	0	3.15	0.10
latch: session allocation	11	0	0	32	0.00	0.09
latch: row cache objects	7	0	0	41	0.00	0.07
log file single write	22	0	0	12	0.00	0.07
latch: cache buffers chains	3	0	0	43	0.00	0.03
control file sequential read	940	0	0	0	0.10	0.03
latch: checkpoint queue latch	2	0	0	32	0.00	0.02
latch: object queue header operation	1	0	0	43	0.00	0.01
latch: In memory undo latch	1	0	0	36	0.00	0.01
reliable message	2	0	0	14	0.00	0.01
latch: redo writing	1	0	0	23	0.00	0.01
latch: Change Notification Hash table latch	1	0	0	16	0.00	0.00
db file scattered read	175	0	0	0	0.02	0.00
db file sequential read	160	0	0	0	0.02	0.00
Disk file operations I/O	4	0	0	1	0.00	0.00
rdbms ipc message	20,666	11	6,097	295	2.17
EMON slave idle wait	583	100	2,937	5037	0.06
DIAG idle wait	1,140	100	1,175	1031	0.12
smon timer	7	29	677	96774	0.00
SQL*Net message from client	40,000	0	627	16	4.21
Streams AQ: qmn coordinator idle wait	23	91	589	25595	0.00
Space Manager: slave idle wait	117	100	589	5031	0.01
Streams AQ: qmn slave idle wait	21	0	589	28031	0.00
pmon timer	242	79	588	2429	0.03
Streams AQ: emn coordinator idle wait	58	100	582	10027	0.01
class slave wait	2	0	0	52	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
Disk file operations I/O	8730	95.3	.8	.7	.9	1.1	.9	.3
LGWR wait for redo copy	888	33.2	5.4	10.2	17.2	18.6	10.2	5.1
SQL*Net message to client	111.3K	99.9	.0	.0	.0	.0	.0	.0
asynch descriptor resize	10K	99.8	.0	.0	.0	.0	.0	.1
buffer busy waits	12.6K	11.1	4.0	3.6	5.9	14.5	25.1	35.7
control file parallel write	368	11.4	7.3	9.5	12.2	18.5	25.8	15.2
control file sequential read	1021	99.5	.2			.1	.1	.1
cursor: mutex S	2						50.0	50.0
cursor: pin S	55				1.8	1.8	9.1	85.5	1.8
db file async I/O submit	232	.4	1.3	.4	2.6	3.4	6.0	80.6	5.2
db file scattered read	182	100.0
db file sequential read	1002	99.9					.1
db file single write	30	13.3	6.7	23.3	10.0	10.0	26.7	10.0
direct path read temp	9	100.0
direct path sync	1						100.0
direct path write	2	100.0
direct path write temp	51	60.8	13.7	3.9	13.7	7.8
enq: HW - contention	15			6.7	13.3	6.7	46.7	26.7
enq: TX - row lock contention	440		.2	1.8	3.6	9.3	14.5	70.5
latch free	434	2.3	.9	2.5	12.9	20.3	17.5	43.5
latch: Change Notification Hash table latch	6	16.7				33.3	50.0
latch: In memory undo latch	5400	33.0	2.4	5.4	9.9	19.2	20.3	9.7
latch: cache buffers chains	3195	19.4	2.4	5.5	11.2	19.7	26.4	15.4
latch: cache buffers lru chain	1							100.0
latch: call allocation	244	2.9	2.5	7.8	18.9	26.2	24.6	17.2
latch: checkpoint queue latch	2					50.0		50.0
latch: enqueue hash chains	144	1.4	2.8	6.3	9.7	21.5	41.7	16.7
latch: messages	18	5.6		5.6		11.1	38.9	38.9
latch: object queue header operation	1							100.0
latch: redo allocation	51	13.7	5.9	9.8	17.6	25.5	13.7	13.7
latch: redo writing	1						100.0
latch: row cache objects	1232	3.1	.9	2.1	8.2	19.6	30.5	35.6
latch: session allocation	32	9.4		3.1	31.3	21.9	18.8	15.6
latch: shared pool	611	1.8	2.3	7.7	13.7	17.7	32.1	24.7
latch: undo global data	6						83.3	16.7
library cache load lock	1						100.0
library cache: mutex X	1560	.3	.1	.4	1.0	3.8	9.1	84.9	.4
log file parallel write	44.4K	69.4	4.2	5.3	5.7	6.1	5.9	3.3
log file sequential read	22	100.0
log file single write	22	9.1		9.1	27.3	36.4	9.1	9.1
log file switch (checkpoint incomplete)	11						9.1	90.9
log file switch (private strand flush incomplete)	10							100.0
log file sync	23.6K	1.7	1.1	3.0	8.0	18.5	35.6	32.2
os thread startup	4							75.0	25.0
reliable message	2	50.0					50.0
DIAG idle wait	1140							88.2	11.8
EMON slave idle wait	583								100.0
SQL*Net message from client	121.3K	27.5	3.9	11.0	11.3	15.3	17.4	13.6	.0
Space Manager: slave idle wait	117								100.0
Streams AQ: emn coordinator idle wait	58								100.0
Streams AQ: qmn coordinator idle wait	23						4.3	4.3	91.3
Streams AQ: qmn slave idle wait	21								100.0
class slave wait	2							100.0
jobq slave wait	120							100.0
pmon timer	242	3.7					.4	11.6	84.3
rdbms ipc message	20.7K	19.5	2.4	9.1	11.3	17.6	16.6	15.1	8.3
smon timer	7	28.6							71.4

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
		% of Total Waits
Disk file operations I/O	29	99.7	.3	.0		.0
LGWR wait for redo copy	45	94.9	4.5	.3		.2
SQL*Net message to client	6	100.0	.0
asynch descriptor resize	6	99.9	.0	.0	.0	.0
buffer busy waits	4503	64.3	25.1	8.7	1.3	.5	.0
control file parallel write	56	84.8	13.3	1.1	.3	.5
control file sequential read	1	99.9	.1
cursor: mutex S	1	50.0	50.0
cursor: pin S	48	12.7	10.9	20.0	32.7	20.0	1.8	1.8
db file async I/O submit	199	14.2	7.3	9.1	11.2	31.0	22.0	5.2
db file single write	3	90.0	6.7			3.3
enq: HW - contention	4	73.3	26.7
enq: TX - row lock contention	310	29.5	25.2	28.4	15.5	1.4
latch free	189	56.5	20.7	12.2	5.1	4.8	.7
latch: In memory undo latch	525	90.3	8.9	.5	.0	.3
latch: cache buffers chains	491	84.6	13.5	1.4	.2	.3
latch: cache buffers lru chain	1				100.0
latch: call allocation	42	82.8	15.6	1.2		.4
latch: checkpoint queue latch	1	50.0	50.0
latch: enqueue hash chains	24	83.3	13.2		2.1	1.4
latch: messages	7	61.1	27.8	11.1
latch: object queue header operation	1		100.0
latch: redo allocation	7	86.3	9.8	3.9
latch: row cache objects	439	64.4	23.2	9.4	1.9	1.1
latch: session allocation	5	84.4	9.4	3.1	3.1
latch: shared pool	151	75.3	20.5	3.6		.7
latch: undo global data	1	83.3	16.7
library cache: mutex X	1332	14.6	17.3	25.2	23.8	14.0	4.6	.4
log file parallel write	1464	96.7	2.9	.3	.1	.1	.0
log file single write	2	90.9	9.1
log file switch (checkpoint incomplete)	10	9.1	36.4	54.5
log file switch (private strand flush incomplete)	10		10.0	50.0	20.0		20.0
log file sync	7599	67.8	26.1	4.8	.5	.8	.1
os thread startup	4					25.0	50.0	25.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

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)
SYS$USERS	3,304	848	1	2,330
SYS$BACKGROUND	0	0	1	5
linuxs.regress.rdbms.dev.us.oracle.com	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	9580	10	24406	856	0	0	81287	1
SYS$BACKGROUND	369	1	23	4	0	0	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 36.3% of Total DB Time (s): 3,304
Captured PL/SQL account for 0.1% of Total DB Time (s): 3,304

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
757.08	10,000	0.08	22.91	16.33	1.21	b6vvz2u69xdma	stage6@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
107.35	10,000	0.01	3.25	18.67	0.00	087hdmn8v6ur7	stage1@stadf26 (TNS V1-V3)	select empno, ename from myemp...
92.71	10,000	0.01	2.81	16.74	0.75	4vs91dcv7u1p6	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
38.66	10,000	0.00	1.17	17.50	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
35.57	10,000	0.00	1.08	30.37	0.00	0k8522rmdzg4k		select privilege# from sysauth...
32.63	10,000	0.00	0.99	20.80	0.28	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
31.02	20,000	0.00	0.94	26.93	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
29.35	10,000	0.00	0.89	14.28	0.00	5ur69atw3vfhj		select decode(failover_method,...
25.60	9,999	0.00	0.77	22.26	0.00	459f3z9u4fb3u		select value$ from props$ wher...
17.30	10,000	0.00	0.52	25.17	0.00	9whcc4w2ws87n	stage6@stadf26 (TNS V1-V3)	select region_id, region_name ...

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 25.5% of Total CPU Time (s): 848
Captured PL/SQL account for 0.1% of Total CPU Time (s): 848

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
123.64	10,000	0.01	14.57	757.08	16.33	1.21	b6vvz2u69xdma	stage6@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
20.04	10,000	0.00	2.36	107.35	18.67	0.00	087hdmn8v6ur7	stage1@stadf26 (TNS V1-V3)	select empno, ename from myemp...
15.52	10,000	0.00	1.83	92.71	16.74	0.75	4vs91dcv7u1p6	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
10.80	10,000	0.00	1.27	35.57	30.37	0.00	0k8522rmdzg4k		select privilege# from sysauth...
8.35	20,000	0.00	0.98	31.02	26.93	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
6.79	10,000	0.00	0.80	32.63	20.80	0.28	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
6.77	10,000	0.00	0.80	38.66	17.50	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
5.70	9,999	0.00	0.67	25.60	22.26	0.00	459f3z9u4fb3u		select value$ from props$ wher...
4.35	10,000	0.00	0.51	17.30	25.17	0.00	9whcc4w2ws87n	stage6@stadf26 (TNS V1-V3)	select region_id, region_name ...
4.19	10,000	0.00	0.49	29.35	14.28	0.00	5ur69atw3vfhj		select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
9.17	10,000	0.00	84.00	757.08	16.33	1.21	b6vvz2u69xdma	stage6@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
0.84	1	0.84	7.65	0.89	7.67	94.29	5dfmd823r8dsp		insert into wrh$_memory_resize...
0.69	10,000	0.00	6.35	92.71	16.74	0.75	4vs91dcv7u1p6	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
0.15	1	0.15	1.34	0.79	80.11	18.49	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
0.09	10,000	0.00	0.84	32.63	20.80	0.28	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
0.02	465	0.00	0.21	1.22	39.90	1.88	bvd8tmw61unaa		insert into SYS.invalidation_r...
0.02	1	0.02	0.18	0.20	91.06	9.87	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...
0.02	465	0.00	0.15	3.97	30.87	0.42	1agbzmyp179a8		select location_name, user#, u...
0.02	1	0.02	0.14	3.00	25.38	0.51	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
0.01	465	0.00	0.12	2.49	31.02	0.54	a34puxuqsrcxu	stage6@stadf26 (TNS V1-V3)	insert into CRC$_RESULT_CACHE_...

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: 2,334,767
Captured SQL account for 98.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,599,277	10,000	159.93	68.50	757.08	16.33	1.21	b6vvz2u69xdma	stage6@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
398,078	10,000	39.81	17.05	107.35	18.67	0.00	087hdmn8v6ur7	stage1@stadf26 (TNS V1-V3)	select empno, ename from myemp...
50,000	10,000	5.00	2.14	35.57	30.37	0.00	0k8522rmdzg4k		select privilege# from sysauth...
40,000	20,000	2.00	1.71	31.02	26.93	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
39,997	9,999	4.00	1.71	25.60	22.26	0.00	459f3z9u4fb3u		select value$ from props$ wher...
32,228	10,000	3.22	1.38	92.71	16.74	0.75	4vs91dcv7u1p6	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
31,834	10,000	3.18	1.36	32.63	20.80	0.28	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
30,000	10,000	3.00	1.28	29.35	14.28	0.00	5ur69atw3vfhj		select decode(failover_method,...
30,000	10,000	3.00	1.28	17.30	25.17	0.00	9whcc4w2ws87n	stage6@stadf26 (TNS V1-V3)	select region_id, region_name ...
15,547	465	33.43	0.67	3.67	38.06	0.10	8ngh5ms3xddy6	stage6@stadf26 (TNS V1-V3)	delete from CRC$_RESULT_CACHE_...

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: 2,326
Captured SQL account for 65.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,292	1	1,292.00	55.55	3.00	25.38	0.51	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
621	1	621.00	26.70	0.79	80.11	18.49	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
116	1	116.00	4.99	1.00	22.89	0.48	fcc0ux2rx45kt	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
63	1	63.00	2.71	0.89	7.67	94.29	5dfmd823r8dsp		insert into wrh$_memory_resize...
50	1	50.00	2.15	0.01	101.95	6.07	6wm3n4d7bnddg		SELECT source, (case when tim...
50	1	50.00	2.15	0.20	91.06	9.87	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...
21	467	0.04	0.90	0.55	38.19	0.13	3c1kubcdjnppq		update sys.col_usage$ set equa...
11	4	2.75	0.47	0.48	57.55	0.05	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DECODE(...
9	2	4.50	0.39	0.52	10.95	0.07	1gfaj4z5hn1kf		delete from dependency$ where ...
6	1	6.00	0.26	0.01	94.61	2.38	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...

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: 1,142
Captured SQL account for 15.0% of Total
Total UnOptimized Read Requests: 1,142
Captured SQL account for 15.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
611	611	1	611.00	53.50	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
116	116	1	116.00	10.16	fcc0ux2rx45kt	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
50	50	1	50.00	4.38	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...
49	49	4	12.25	4.29	bn4b3vjw2mj3u		SELECT OBJOID, CLSOID, DECODE(...
30	30	1	30.00	2.63	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
9	9	2	4.50	0.79	1gfaj4z5hn1kf		delete from dependency$ where ...
9	9	1	9.00	0.79	5dfmd823r8dsp		insert into wrh$_memory_resize...
6	6	1	6.00	0.53	89sdz401dc5uf		select program_oid, schedule_e...
5	5	465	0.01	0.44	a34puxuqsrcxu	stage6@stadf26 (TNS V1-V3)	insert into CRC$_RESULT_CACHE_...
5	5	10,000	0.00	0.44	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...

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: 119,136
Captured SQL account for 98.9% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
20,000	0	0.00	31.02	26.93	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
10,000	70,181	7.02	107.35	18.67	0.00	087hdmn8v6ur7	stage1@stadf26 (TNS V1-V3)	select empno, ename from myemp...
10,000	20,000	2.00	35.57	30.37	0.00	0k8522rmdzg4k		select privilege# from sysauth...
10,000	10,000	1.00	38.66	17.50	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
10,000	10,000	1.00	92.71	16.74	0.75	4vs91dcv7u1p6	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
10,000	10,000	1.00	29.35	14.28	0.00	5ur69atw3vfhj		select decode(failover_method,...
10,000	10,000	1.00	17.30	25.17	0.00	9whcc4w2ws87n	stage6@stadf26 (TNS V1-V3)	select region_id, region_name ...
10,000	760,000	76.00	757.08	16.33	1.21	b6vvz2u69xdma	stage6@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
10,000	10,000	1.00	32.63	20.80	0.28	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
9,999	10,000	1.00	25.60	22.26	0.00	459f3z9u4fb3u		select value$ from props$ wher...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 128,098
Captured SQL account for 91.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
20,000	20,000	15.61	cm5vu20fhtnq1		select /*+ connect_by_filterin...
10,000	10,000	7.81	087hdmn8v6ur7	stage1@stadf26 (TNS V1-V3)	select empno, ename from myemp...
10,000	10,000	7.81	0k8522rmdzg4k		select privilege# from sysauth...
10,000	10,000	7.81	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
10,000	9,999	7.81	459f3z9u4fb3u		select value$ from props$ wher...
10,000	10,000	7.81	4vs91dcv7u1p6	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
10,000	10,000	7.81	5ur69atw3vfhj		select decode(failover_method,...
10,000	10,000	7.81	9whcc4w2ws87n	stage6@stadf26 (TNS V1-V3)	select region_id, region_name ...
10,000	10,000	7.81	b6vvz2u69xdma	stage6@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
10,000	10,000	7.81	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

087hdmn8v6ur7 select empno, ename from myemp where empno > :EMPNO order by empno

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

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

1agbzmyp179a8 select location_name, user#, user_context, context_size, presentation, version, status, any_context, context_type, qosflags, payload_callback, timeout, r.reg_id, reg_time, ntfn_grouping_class, ntfn_grouping_value, ntfn_grouping_type, ntfn_grouping_start_time, ntfn_grouping_repeat_count, state, session_key from reg$ r left outer join regz$ rz on r.reg_id = rz.reg_id where subscription_name = :1 and namespace = :2 order by location_name, user#, presentation, version

1cq3qr774cu45 insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)

1gfaj4z5hn1kf delete from dependency$ where d_obj#=:1

2ntzsd2w869g8 begin :bid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;

3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln

459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'

4vs91dcv7u1p6 insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)

5dfmd823r8dsp insert into wrh$_memory_resize_ops (snap_id, dbid, instance_number, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status) select snap_id, dbid, instance_num, component, oper_type, start_time, max(end_time), target_size, max(oper_mode), max(parameter), max(initial_size), max(final_size), max(status) from (select :snap_id snap_id, :dbid dbid, :instance_number instance_num, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status from v$memory_resize_ops where :begin_interval_time <= end_time and end_time < :end_interval_time) group by snap_id, dbid, instance_num, component, oper_type, start_time, target_size

5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1

6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC

89sdz401dc5uf select program_oid, schedule_expr, schedule_id, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, last_enabled_time, class_oid, next_run_date, last_start_date, last_end_date, retry_count, run_count, failure_count, running_instance, running_slave, flags, job_status, creator, client_id, guid, char_env, start_date, end_date, instance_id, fw_name, fw_oid, destination, credential_name, credential_owner, credential_oid, dest_oid, job_dest_id, run_invoker, program_action, schedule_limit, priority, job_weight, number_of_args, max_runs, max_failures, max_run_duration, comments, user_callback, user_callback_ctx, nls_env, source, env, database_role, owner_udn, dist_flags from sys.scheduler$_job where obj# = :1

8ngh5ms3xddy6 delete from CRC$_RESULT_CACHE_STATS where CACHE_ID = :1

9whcc4w2ws87n select region_id, region_name from regions where region_id = :regionID

a34puxuqsrcxu insert into CRC$_RESULT_CACHE_STATS values (:1, :2, :3, :4)

ab3swhv5g138y select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID

b6vvz2u69xdma update myemp set sal = :sal where empno = :id

bn4b3vjw2mj3u SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1

bvd8tmw61unaa insert into SYS.invalidation_registry$(regid, regflags, numobjs, objarray, plsqlcallback, changelag, username) values(:1, :2, :3, :4, :5, :6, :7)

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

f711myt0q6cma insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)

fcc0ux2rx45kt DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; BEGIN begin dbms_rlmgr_dr.cleanup_events; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

fdjtrdaz8hpvg INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a. flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')

SQL Id	SQL Text
087hdmn8v6ur7	select empno, ename from myemp where empno > :EMPNO order by empno
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1agbzmyp179a8	select location_name, user#, user_context, context_size, presentation, version, status, any_context, context_type, qosflags, payload_callback, timeout, r.reg_id, reg_time, ntfn_grouping_class, ntfn_grouping_value, ntfn_grouping_type, ntfn_grouping_start_time, ntfn_grouping_repeat_count, state, session_key from reg$ r left outer join regz$ rz on r.reg_id = rz.reg_id where subscription_name = :1 and namespace = :2 order by location_name, user#, presentation, version
1cq3qr774cu45	insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
2ntzsd2w869g8	begin :bid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
5dfmd823r8dsp	insert into wrh$_memory_resize_ops (snap_id, dbid, instance_number, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status) select snap_id, dbid, instance_num, component, oper_type, start_time, max(end_time), target_size, max(oper_mode), max(parameter), max(initial_size), max(final_size), max(status) from (select :snap_id snap_id, :dbid dbid, :instance_number instance_num, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status from v$memory_resize_ops where :begin_interval_time <= end_time and end_time < :end_interval_time) group by snap_id, dbid, instance_num, component, oper_type, start_time, target_size
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
89sdz401dc5uf	select program_oid, schedule_expr, schedule_id, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, last_enabled_time, class_oid, next_run_date, last_start_date, last_end_date, retry_count, run_count, failure_count, running_instance, running_slave, flags, job_status, creator, client_id, guid, char_env, start_date, end_date, instance_id, fw_name, fw_oid, destination, credential_name, credential_owner, credential_oid, dest_oid, job_dest_id, run_invoker, program_action, schedule_limit, priority, job_weight, number_of_args, max_runs, max_failures, max_run_duration, comments, user_callback, user_callback_ctx, nls_env, source, env, database_role, owner_udn, dist_flags from sys.scheduler$_job where obj# = :1
8ngh5ms3xddy6	delete from CRC$_RESULT_CACHE_STATS where CACHE_ID = :1
9whcc4w2ws87n	select region_id, region_name from regions where region_id = :regionID
a34puxuqsrcxu	insert into CRC$_RESULT_CACHE_STATS values (:1, :2, :3, :4)
ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
b6vvz2u69xdma	update myemp set sal = :sal where empno = :id
bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
bvd8tmw61unaa	insert into SYS.invalidation_registry$(regid, regflags, numobjs, objarray, plsqlcallback, changelag, username) values(:1, :2, :3, :4, :5, :6, :7)
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fcc0ux2rx45kt	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; BEGIN begin dbms_rlmgr_dr.cleanup_events; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fdjtrdaz8hpvg	INSERT /+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a. flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')

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	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	4	0.01	0.00
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	38,896	66.01	4.09
CPU used when call started	36,714	62.31	3.86
CR blocks created	4,478	7.60	0.47
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	193	0.33	0.02
DB time	235,665	399.96	24.78
DBWR checkpoint buffers written	1,227	2.08	0.13
DBWR checkpoints	11	0.02	0.00
DBWR thread checkpoint buffers written	1,227	2.08	0.13
DBWR transaction table writes	201	0.34	0.02
DBWR undo block writes	9,183	15.59	0.97
HSC Heap Segment Block Changes	788,755	1,338.65	82.93
Heap Segment Array Inserts	552	0.94	0.06
Heap Segment Array Updates	11	0.02	0.00
IMU CR rollbacks	70,584	119.79	7.42
IMU Flushes	4,500	7.64	0.47
IMU Redo allocation size	65,179,764	110,620.80	6,853.09
IMU commits	4,201	7.13	0.44
IMU contention	4,476	7.60	0.47
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	864	1.47	0.09
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	190,106,060	322,641.30	19,988.02
IMU- failed to get a private strand	864	1.47	0.09
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for undo segment shrink	3	0.01	0.00
SQL*Net roundtrips to/from client	81,287	137.96	8.55
active txn count during cleanout	12,663	21.49	1.33
application wait time	3,333	5.66	0.35
background checkpoints completed	10	0.02	0.00
background checkpoints started	11	0.02	0.00
background timeouts	2,400	4.07	0.25
buffer is not pinned count	110,830	188.10	11.65
buffer is pinned count	4,484	7.61	0.47
bytes received via SQL*Net from client	28,116,967	47,719.12	2,956.26
bytes sent via SQL*Net to client	41,958,497	71,210.48	4,411.58
calls to get snapshot scn: kcmgss	941,366	1,597.65	98.98
calls to kcmgas	43,604	74.00	4.58
calls to kcmgcs	108,172	183.59	11.37
cell physical IO interconnect bytes	347,546,624	589,843.87	36,541.54
change write time	4,534	7.69	0.48
cleanout - number of ktugct calls	6,518	11.06	0.69
cleanouts and rollbacks - consistent read gets	4,165	7.07	0.44
cleanouts only - consistent read gets	151	0.26	0.02
cluster key scan block gets	245	0.42	0.03
cluster key scans	191	0.32	0.02
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	140	0.24	0.01
commit cleanout failures: cannot pin	676	1.15	0.07
commit cleanouts	35,736	60.65	3.76
commit cleanouts successfully completed	34,920	59.26	3.67
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	1,045	1.77	0.11
concurrency wait time	86,021	145.99	9.04
consistent changes	433,664	736.00	45.60
consistent gets	1,437,182	2,439.13	151.11
consistent gets - examination	430,353	730.38	45.25
consistent gets direct	0	0.00	0.00
consistent gets from cache	1,437,182	2,439.13	151.11
consistent gets from cache (fastpath)	998,999	1,695.47	105.04
cursor authentications	14	0.02	0.00
data blocks consistent reads - undo records applied	430,124	729.99	45.22
db block changes	1,669,513	2,833.44	175.53
db block gets	897,585	1,523.35	94.37
db block gets direct	10	0.02	0.00
db block gets from cache	897,575	1,523.33	94.37
db block gets from cache (fastpath)	5,819	9.88	0.61
deferred (CURRENT) block cleanout applications	14,199	24.10	1.49
dirty buffers inspected	6,881	11.68	0.72
enqueue conversions	161	0.27	0.02
enqueue releases	91,896	155.96	9.66
enqueue requests	91,896	155.96	9.66
enqueue timeouts	0	0.00	0.00
enqueue waits	455	0.77	0.05
execute count	119,136	202.19	12.53
file io service time	0	0.00	0.00
file io wait time	88,747,306	150,618.80	9,331.02
free buffer inspected	16,836	28.57	1.77
free buffer requested	18,576	31.53	1.95
heap block compress	306	0.52	0.03
hot buffers moved to head of LRU	2,038	3.46	0.21
immediate (CR) block cleanout applications	4,316	7.32	0.45
immediate (CURRENT) block cleanout applications	1,917	3.25	0.20
index crx upgrade (positioned)	0	0.00	0.00
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	2	0.00	0.00
index fetch by key	802,798	1,362.48	84.41
index scans kdiixs1	45,445	77.13	4.78
leaf node 90-10 splits	15	0.03	0.00
leaf node splits	18	0.03	0.00
lob reads	0	0.00	0.00
lob writes	8	0.01	0.00
lob writes unaligned	8	0.01	0.00
logons cumulative	10,005	16.98	1.05
max cf enq hold time	140	0.24	0.01
messages received	22,686	38.50	2.39
messages sent	22,687	38.50	2.39
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	14	0.02	0.00
no work - consistent read gets	891,799	1,513.53	93.77
non-idle wait count	250,151	424.55	26.30
non-idle wait time	195,940	332.54	20.60
opened cursors cumulative	128,220	217.61	13.48
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	64	0.11	0.01
parse count (total)	128,098	217.40	13.47
parse time cpu	2,208	3.75	0.23
parse time elapsed	15,725	26.69	1.65
physical read IO requests	1,142	1.94	0.12
physical read bytes	19,054,592	32,338.78	2,003.43
physical read total IO requests	2,218	3.76	0.23
physical read total bytes	36,129,792	61,318.21	3,798.74
physical read total multi block requests	0	0.00	0.00
physical reads	2,326	3.95	0.24
physical reads cache	2,263	3.84	0.24
physical reads cache prefetch	1,130	1.92	0.12
physical reads direct	63	0.11	0.01
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	63	0.11	0.01
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	7,324	12.43	0.77
physical write bytes	86,622,208	147,012.16	9,107.58
physical write total IO requests	30,273	51.38	3.18
physical write total bytes	311,416,832	528,525.66	32,742.81
physical write total multi block requests	132	0.22	0.01
physical writes	10,574	17.95	1.11
physical writes direct	367	0.62	0.04
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	357	0.61	0.04
physical writes from cache	10,207	17.32	1.07
physical writes non checkpoint	10,098	17.14	1.06
pinned buffers inspected	7	0.01	0.00
pinned cursors current	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	1,176,618	1,996.91	123.71
recursive cpu usage	14,626	24.82	1.54
redo blocks checksummed by FG (exclusive)	231,214	392.41	24.31
redo blocks read for recovery	0	0.00	0.00
redo blocks written	429,014	728.11	45.11
redo buffer allocation retries	22	0.04	0.00
redo entries	340,103	577.21	35.76
redo entries for lost write detection	1,063	1.80	0.11
redo k-bytes read for recovery	0	0.00	0.00
redo k-bytes read total	0	0.00	0.00
redo log space requests	46	0.08	0.00
redo log space wait time	284	0.48	0.03
redo ordering marks	4,757	8.07	0.50
redo size	206,915,220	351,169.21	21,755.36
redo size for direct writes	104	0.18	0.01
redo size for lost write detection	85,684	145.42	9.01
redo subscn max counts	6,339	10.76	0.67
redo synch time	72,895	123.71	7.66
redo synch writes	30,434	51.65	3.20
redo wastage	5,745,512	9,751.08	604.09
redo write time	21,521	36.52	2.26
redo writes	22,207	37.69	2.33
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	539	0.91	0.06
rows fetched via callback	1,920	3.26	0.20
securefile allocation bytes	0	0.00	0.00
securefile allocation chunks	0	0.00	0.00
securefile bytes cleartext	0	0.00	0.00
securefile bytes encrypted	0	0.00	0.00
securefile compressed bytes	0	0.00	0.00
securefile inode ioreap time	0	0.00	0.00
securefile inode read time	0	0.00	0.00
securefile inode write time	0	0.00	0.00
securefile number of flushes	0	0.00	0.00
securefile uncompressed bytes	0	0.00	0.00
segemnt dispenser load empty	0	0.00	0.00
segment cfs allocations	0	0.00	0.00
segment chunks allocation from disepnser	0	0.00	0.00
segment dispenser allocations	0	0.00	0.00
segment dispenser load tasks	0	0.00	0.00
segment prealloc bytes	0	0.00	0.00
segment prealloc ops	0	0.00	0.00
segment prealloc tasks	0	0.00	0.00
segment prealloc time (ms)	0	0.00	0.00
segment total chunk allocation	0	0.00	0.00
session cursor cache hits	11,243	19.08	1.18
session logical reads	2,334,767	3,962.48	245.48
shared hash latch upgrades - no wait	3,896	6.61	0.41
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	52,253	88.68	5.49
sorts (rows)	76,915	130.54	8.09
sql area evicted	41	0.07	0.00
sql area purged	0	0.00	0.00
summed dirty queue length	7,793	13.23	0.82
switch current to new buffer	1,652	2.80	0.17
table fetch by rowid	4,660	7.91	0.49
table fetch continued row	34	0.06	0.00
table scan blocks gotten	52,581	89.24	5.53
table scan rows gotten	964,275	1,636.53	101.39
table scans (long tables)	1	0.00	0.00
table scans (short tables)	42,375	71.92	4.46
temp space allocated (bytes)	1,048,576	1,779.61	110.25
total cf enq hold time	4,060	6.89	0.43
total number of cf enq holders	41	0.07	0.00
total number of times SMON posted	5	0.01	0.00
transaction rollbacks	0	0.00	0.00
undo change vector size	75,511,348	128,155.20	7,939.37
user I/O wait time	1,092	1.85	0.11
user calls	135,131	229.34	14.21
user commits	9,511	16.14	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	2	0.00	0.00
workarea executions - optimal	10,208	17.32	1.07
write clones created in background	2	0.00	0.00
write clones created in foreground	248	0.42	0.03

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
opened cursors current	36	37
logons current	28	28
session uga memory max	5,310,853,300	7,912,615,288
session pga memory	63,805,452	66,288,592
session pga memory max	75,815,568	77,905,492
session cursor cache count	193,027	289,762
session uga memory	73,939,439,416	78,687,542,664

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)	11	67.21

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)
LGWR	4M	0.50	.006788	212M	38.67	.359798	22.7K	8.67
DBWR	0M	0.00	0M	80M	12.34	.135773	233	382.98
Buffer Cache Reads	17M	1.94	.028851	0M	0.00	0M	1143	0.01
Others	11M	1.33	.018668	4M	0.49	.006788	1328	8.83
Direct Writes	0M	0.00	0M	3M	0.09	.005091	53	15.19
Direct Reads	0M	0.02	0M	0M	0.00	0M	9	0.00
Streams AQ	0M	0.02	0M	0M	0.00	0M	11	0.00
TOTAL:	32M	3.80	.054309	299M	51.59	.507452	25.5K	11.71

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
Log File	0M	0.04	0M	210M	38.48	.356404	0.00
Data File	18M	2.02	.030548	81M	12.39	.137470	0.01
Control File	17M	1.73	.028851	6M	0.62	.010182	0.09
Temp File	0M	0.02	0M	3M	0.09	.005091	0.00
TOTAL:	35M	3.81	.059400	300M	51.59	.509149	0.05

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)
LGWR	4M	0.50	.006788	212M	38.67	.359798	316	0.78
LGWR (Log File)	0M	0.04	0M	210M	38.48	.356404	44	5.57
LGWR (Control File)	4M	0.46	.006788	2M	0.19	.003394	272	0.00
DBWR	0M	0.00	0M	80M	12.34	.135773	0
DBWR (Data File)	0M	0.00	0M	80M	12.34	.135773	0
Buffer Cache Reads	18M	1.96	.030548	0M	0.00	0M	1152	0.01
Buffer Cache Reads (Data File)	18M	1.96	.030548	0M	0.00	0M	1152	0.01
Others	12M	1.33	.020365	4M	0.49	.006788	812	0.95
Others (Control File)	12M	1.27	.020365	4M	0.44	.006788	749	0.12
Others (Data File)	0M	0.06	0M	0M	0.05	0M	63	10.79
Direct Writes	0M	0.00	0M	3M	0.09	.005091	0
Direct Writes (Data File)	0M	0.00	0M	3M	0.09	.005091	0
Streams AQ	0M	0.02	0M	0M	0.00	0M	11	0.00
Streams AQ (Data File)	0M	0.02	0M	0M	0.00	0M	11	0.00
Direct Reads	0M	0.02	0M	0M	0.00	0M	0
Direct Reads (Data File)	0M	0.02	0M	0M	0.00	0M	0
TOTAL:	34M	3.82	.057703	299M	51.59	.507452	2291	0.45

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)
UD1	23	0	0.00	1.00	6,710	11	1,124	9.13
SYSAUX	544	1	0.04	1.07	297	1	0	0.00
SYSTEM	530	1	0.08	3.06	263	0	23,281	16.66
TEMP	10	0	0.00	6.40	54	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	/ade/b/3050220379/oracle/dbs/t_ax1.f	544	1	0.04	1.07	297	1	0	0.00
SYSTEM	/ade/b/3050220379/oracle/dbs/t_db1.f	530	1	0.08	3.06	263	0	23,281	16.66
TEMP	/ade/b/3050220379/oracle/dbs/t_tmp1.f	10	0	0.00	6.40	54	0	0
UD1	/ade/b/3050220379/oracle/dbs/t_undo1.f	23	0	0.00	1.00	6,710	11	1,124	9.13

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	1,984	100	2,334,652	2,244	10,067	0	0	24,405

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 10,574

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	928	0	0	0	299

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	11	183	421	41472	41472	158442
E	0	13	779	42245	41472	41472	133235

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	4	0.25	0	1.45	53	1	533.00
D	8	0.50	1	1.18	43	1	433.00
D	12	0.75	1	1.10	40	1	403.00
D	16	1.00	2	1.00	37	1	367.00
D	20	1.25	2	0.94	35	1	347.00
D	24	1.50	3	0.93	34	1	341.00
D	28	1.75	3	0.90	33	1	329.00
D	32	2.00	4	0.87	32	1	321.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
84.82	43	8

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	29	4	43.76	0.00	0.00	0.00	0.00	5,939
E	29	4	43.64	0.00	0.00	0.00	0.00	5,939

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	1-Pass Execs
2K	4K	10,184	10,184	0
64K	128K	2	2	0
256K	512K	2	2	0
512K	1024K	20	20	0
2M	4M	2	0	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
15	0.50	750.68	17.96	98.00	5	1,150,730
22	0.75	750.68	17.96	98.00	5	1,150,730
29	1.00	750.68	3.81	99.00	5	1,129,541
35	1.20	750.68	3.81	99.00	5	1,129,541
41	1.40	750.68	0.00	100.00	4	1,123,841
46	1.60	750.68	0.00	100.00	2	1,123,841
52	1.80	750.68	0.00	100.00	2	1,123,841
58	2.00	750.68	0.00	100.00	1	1,123,841
87	3.00	750.68	0.00	100.00	0	1,123,841
116	4.00	750.68	0.00	100.00	0	1,123,841
174	6.00	750.68	0.00	100.00	0	1,123,841
232	8.00	750.68	0.00	100.00	0	1,123,841

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)
88	0.88	6	399	17,530	1.00	649	1.04	381
100	1.00	18	1,125	17,553	1.00	626	1.00	758
112	1.12	29	1,671	17,581	1.00	598	0.96	760
124	1.24	41	2,194	17,590	1.00	589	0.94	761
136	1.36	54	2,895	17,592	1.00	587	0.94	761
148	1.48	66	3,718	17,593	1.00	586	0.94	761
160	1.60	78	4,525	17,593	1.00	586	0.94	761
172	1.72	85	5,021	17,593	1.00	586	0.94	761
184	1.84	87	5,140	17,593	1.00	586	0.94	761
196	1.96	87	5,140	17,593	1.00	586	0.94	761
208	2.08	87	5,140	17,593	1.00	586	0.94	761

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	23,269	388	17
undo block	953	8	9
undo header	171	2	12
segment header	12	0	19

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	440	440	0	440	33	75.80
HW-Segment High Water Mark	193	193	0	15	0	22.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
3	4.49	15,251	790	12	28.2/28.2	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
18-Sep 03:21	4,489	15,251	790	12	28	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0	0
ASM db client latch	404	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	43	0.00		0	0
AWR Alerted Metric Element list	4,253	0.00		0	0
Change Notification Hash table latch	850,104	0.00	0.21	0	0
Consistent RBA	22,219	0.00		0	0
DML lock allocation	69,374	0.02	0.75	0	0
Event Group Locks	10,005	0.00		0	0
FOB s.o list latch	17,459	0.07	0.67	0	0
File State Object Pool Parent Latch	1	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	612,791	0.96	1.14	72	10,132	0.04
JS Sh mem access	1	0.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	3,494	0.00		0	0
JS slv state obj latch	5	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
KKCN reg stat latch	930	0.00		0	0
KMG MMAN ready and startup request latch	193	0.00		0	0
KTF sga latch	4	0.00		0	198	0.00
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1	0.00		0	0
MQL Tracking Latch	0			0	12	0.00
Memory Management Latch	1	0.00		0	193	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	4	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	30,053	0.00		0	0
OS process allocation	20,218	0.26	0.87	2	0
OS process: request allocation	20,008	0.13	0.67	1	0
PL/SQL warning settings	10,008	0.00		0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	50	0.00		0	0
SGA IO buffer pool latch	1,327	0.00		0	1,355	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	939	0.00		0	192	0.00
SQL memory manager workarea list latch	77,736	0.00		0	0
Shared B-Tree	22	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	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	470	0.00		0	0
active service list	51,352	0.10	0.71	2	763	0.00
begin backup scn array	2	0.00		0	0
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	39	0.00		0	0
cache buffers chains	8,829,262	0.19	0.26	56	20,641	0.10
cache buffers lru chain	14,082	0.01	0.50	0	32,149	0.17
cache table scan latch	182	0.00		0	182	0.00
call allocation	30,455	0.89	0.90	5	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	20,009	0.23	0.51	3	0
channel operations parent latch	33,693	0.01	0.50	0	0
checkpoint queue latch	21,678	0.01	1.00	0	10,589	0.00
client/application info	70,014	0.01	0.40	0	0
compile environment latch	10,005	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	43	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	43	0.00		0	0
dml lock allocation	43	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	20,011	0.24	0.27	0	0
enqueue hash chains	184,843	0.14	0.66	4	7	0.00
enqueues	49,071	0.12	0.81	2	0
fifth spare latch	1	0.00		0	0
file cache latch	87	0.00		0	0
flashback copy	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	10,000	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	212	0.00		0	6,271	0.00
hash table modification latch	11	0.00		0	0
heartbeat check	1	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	2	0.00		0	1	0.00
job_queue_processes free list latch	4	0.00		0	0
job_queue_processes parameter latch	125	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	11	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kks stats	136	0.00		0	0
kokc descriptor allocation latch	4	0.00		0	0
kpon sga structure	465	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	5	0.00		0	0
ksuosstats global area	42	0.00		0	0
ksv allocation latch	51	0.00		0	0
ksv class latch	9	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	20,008	0.25	0.66	2	0
ktm global data	10	0.00		0	0
kwqbsn:qsga	21	0.00		0	0
lgwr LWN SCN	22,411	0.00		0	0
list of block allocation	20,015	0.03	0.17	0	0
loader state object freelist	2	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	3	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	1	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	19	0.00		0	0
messages	82,029	0.03	0.75	1	0
mostly latch-free SCN	22,441	0.02	0.00	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	368	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	43	0.00		0	0
object queue header heap	1,083	0.00		0	517	0.00
object queue header operation	58,553	0.00	0.50	0	0
object stats modification	8	0.00		0	0
parallel query alloc buffer	77	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	225	0.00		0	0
parameter table management	20,011	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	32,086	0.02	0.60	0	29,467	0.05
process allocation	20,012	0.52	4.81	8	9,998	0.06
process group creation	20,008	0.02	0.40	0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	87	21.84	1.00	0	0
query server freelists	1	0.00		0	0
queued dump request	2	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	87,153	0.11	0.58	1	339,900	0.11
redo copy	1	0.00		0	340,060	0.90
redo writing	67,936	0.00	1.00	0	0
resmgr group change latch	10,002	0.00		0	0
resmgr:active threads	20,011	0.00		0	0
resmgr:actses change group	10,004	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	20,010	0.30	0.52	2	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	1	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	713,333	1.02	0.17	45	81	0.00
second spare latch	1	0.00		0	0
sequence cache	31,465	0.13	0.85	1	0
session allocation	122,839	0.04	0.65	1	40,946	0.12
session idle bit	301,204	0.01	0.31	0	0
session queue latch	1	0.00		0	0
session state list latch	14	0.00		0	0
session switching	50,064	0.00	0.00	0	0
session timer	233	0.00		0	0
shared pool	464,754	0.71	0.19	16	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	911	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	49,562	0.00		0	0
simulator lru latch	1	0.00		0	48,159	0.13
sort extent pool	66	0.00		0	0
space background state object latch	2	0.00		0	0
space background task latch	430	0.00		0	386	0.00
state object free list	2	0.00		0	0
statistics aggregation	336	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj 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	16	0.00		0	0
trace latch	1	0.00		0	0
transaction allocation	42,804	0.01	0.75	0	0
undo global data	148,271	0.01	0.35	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	8,829,262	16,448	4,330	13,254
row cache objects	713,333	7,243	1,267	6,011
In memory undo latch	612,791	5,909	6,717	516
shared pool	464,754	3,279	628	2,668
call allocation	30,455	272	246	28
enqueue hash chains	184,843	257	169	113
process allocation	20,012	104	500	7
redo allocation	87,153	92	53	41
resmgr:free threads list	20,010	60	31	29
enqueues	49,071	58	47	12
OS process allocation	20,218	53	46	7
active service list	51,352	51	36	15
ksz_so allocation latch	20,008	50	33	18
session allocation	122,839	49	32	17
dummy allocation	20,011	48	13	35
channel handle pool latch	20,009	47	24	23
sequence cache	31,465	40	34	6
session idle bit	301,204	36	11	25
Change Notification Hash table latch	850,104	34	7	28
OS process: request allocation	20,008	27	18	10
messages	82,029	24	18	6
qmn task queue latch	87	19	19	0
undo global data	148,271	17	6	11
DML lock allocation	69,374	12	9	4
FOB s.o list latch	17,459	12	8	5
list of block allocation	20,015	6	1	5
client/application info	70,014	5	2	3
post/wait queue	32,086	5	3	2
process group creation	20,008	5	2	3
channel operations parent latch	33,693	4	2	2
transaction allocation	42,804	4	3	1
cache buffers lru chain	14,082	2	1	1
checkpoint queue latch	21,678	2	2	0
object queue header operation	58,553	2	1	1
redo writing	67,936	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
Change Notification Hash table latch	ktcn_gen_content_from_cv	5	8
Change Notification Hash table latch	ktcnUpdateDescriptors	2	0
DML lock allocation	ktaidm	7	4
DML lock allocation	ktaiam	2	5
FOB s.o list latch	ksfd_allfob	4	4
FOB s.o list latch	ksfd_fobd	4	5
In memory undo latch	ktichg: child	4,366	1,511
In memory undo latch	ktiFlush: child	1,735	2,972
In memory undo latch	kticmt: child	686	25
In memory undo latch	kturbk	32	2,312
In memory undo latch	kticflush_2	1	0
OS process allocation	kso_new_process:2	32	26
OS process allocation	kso_delete_process:1	13	18
OS process allocation	ksosp_scrub:1	1	2
OS process: request allocation	kso_new_process	17	16
OS process: request allocation	ksoreqholder_delete	1	2
active service list	kswslogon: session logout	23	22
active service list	kswsgsnp: get service name ptr	11	9
active service list	kswslogon: session login	2	5
cache buffers chains	kcbgtcr: fast path (cr pin)	2,922	485
cache buffers chains	kcbgcur_2	431	808
cache buffers chains	kcbrls_1	284	1,484
cache buffers chains	kcbchg1: kslbegin: call CR func	266	451
cache buffers chains	kcb_post_apply: kcbhq62	132	107
cache buffers chains	kcbgtcr: fast path	108	240
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	98	299
cache buffers chains	kcbnlc	63	17
cache buffers chains	kcbzwb	59	269
cache buffers chains	kcb_pre_apply: kcbhq61	26	180
cache buffers chains	kcbso1: set no access	23	54
cache buffers chains	kcbzpbuf	10	11
cache buffers chains	kcb_commit	4	11
cache buffers chains	kcbrls_2	1	3
cache buffers lru chain	kcbzgb	1	1
call allocation	ksuxds	125	158
call allocation	ksudlp: top call	84	47
call allocation	ksucrp: top call	35	40
call allocation	ksudlc : rec call	1	0
call allocation	ksuprc	1	1
channel handle pool latch	ksrchconnect()	24	16
channel operations parent latch	ksrchdelete_sub()	2	2
checkpoint queue latch	kcbklbc_cql	2	0
client/application info	ksuinfos_modact	2	2
dummy allocation	ktcscnfy	11	11
dummy allocation	ktcdod	2	2
enqueue hash chains	ksqgtl3	110	132
enqueue hash chains	ksqrcl	58	37
enqueue hash chains	ksqcmi: get hash chain latch after wait	1	0
enqueues	ksqdel	25	20
enqueues	ksqgel: create enqueue	22	27
ksz_so allocation latch	ksznfy1	28	27
ksz_so allocation latch	ksz_parent_so_del1	5	6
list of block allocation	ktcdod	1	1
messages	ksaamb: after wakeup	9	8
messages	ksarcv	5	6
messages	ksarcv: after wait	3	3
messages	ksaclr	1	1
object queue header operation	kcbo_link_q	1	0
post/wait queue	ksliwat:add:nowait	3	0
process allocation	ksuapc	404	329
process allocation	ksucrp:1	64	0
process allocation	ksudlp	32	171
process group creation	ksupgprem	2	2
qmn task queue latch	kwqmnmvtsks: delay to ready list	19	0
redo allocation	kcrfw_redo_gen: redo allocation 1	53	0
redo writing	kcrfw_post: rba scn pair	1	0
resmgr:free threads list	kskthrcreate	25	23
resmgr:free threads list	kskthrsod	6	11
row cache objects	kqreqd: reget	985	6
row cache objects	kqrpre: find obj	240	1,050
row cache objects	kqreqd	31	206
row cache objects	kqrso	11	5
sequence cache	kdnssd	31	0
sequence cache	kdnnxt: cached seq	3	0
session allocation	ksuxds	18	32
session allocation	ksucri_int : SSO	14	0
session idle bit	ksupuc: set busy	6	3
session idle bit	ksupuc: clear busy	4	4
session idle bit	ksuxds	1	4
shared pool	kghalo	274	387
shared pool	kghupr1	272	157
shared pool	kghfre	80	79
shared pool	kghalp	2	4
transaction allocation	ktcdod	3	3
undo global data	ktudnx:child	4	0
undo global data	ktudba: KSLBEGIN	2	3

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kglhdgn2 106	4,504	64
Library Cache	kgllkdl1 85	2,017	91
Library Cache	kglhdgn1 62	73	132
Cursor Pin	kkslce [KKSCHLPIN2]	47	0
Library Cache	kglpin1 4	29	98
Library Cache	kgllkc1 57	27	-295
Library Cache	kglpndl1 95	12	47
Cursor Pin	kksLockDelete [KKSCHLPIN6]	9	0
Library Cache	kglpnal1 90	4	42
hash table	kkshGetNextChild [KKSHBKLOC1]	2	0
Cursor Pin	kksfbc [KKSCHLFSP2]	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 2,334,767
Captured Segments account for 90.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
OCIHOL	SYSTEM	SYS_C004756	INDEX	800,000	34.26
OCIHOL	SYSTEM	MYEMP	TABLE	760,000	32.55
SYS	SYSTEM	AUD$	TABLE	171,792	7.36
SYS	SYSTEM	I_SYSAUTH1	INDEX	160,000	6.85
SYS	SYSTEM	PROPS$	TABLE	159,952	6.85

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 2,326
Captured Segments account for 70.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	I_OBJ2	INDEX	1,282	55.12
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	80	3.44
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	50	2.15
SYS	SYSTEM	HIST_HEAD$	TABLE	21	0.90
SYS	SYSTEM	ICOL$	TABLE	17	0.73

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 1,142
Captured Segments account for 49.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
SYS	SYSTEM	I_OBJ2	INDEX	198	17.34
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	80	7.01
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	50	4.38
SYS	SYSTEM	HIST_HEAD$	TABLE	21	1.84
SYS	SYSTEM	ICOL$	TABLE	17	1.49

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 1,142
Captured Segments account for 49.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
SYS	SYSTEM	I_OBJ2	INDEX	198	17.34
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	80	7.01
SYS	SYSAUX	WRH$_SQL_PLAN_PK	INDEX	50	4.38
SYS	SYSTEM	HIST_HEAD$	TABLE	21	1.84
SYS	SYSTEM	ICOL$	TABLE	17	1.49

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 10,574
Captured Segments account for 5.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYS	SYSTEM	AUD$		TABLE	346	3.27
SYS	SYSAUX	CRC$_RESULT_CACHE_STATS		TABLE	50	0.47
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_570420430_665	TABLE PARTITION	21	0.20
SYS	SYSTEM	COL_USAGE$		TABLE	14	0.13
SYS	SYSAUX	WRH$_LATCH_PK	WRH$_LATCH_570420430_665	INDEX PARTITION	14	0.13

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 7,324
Captured Segments account for 5.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
SYS	SYSTEM	AUD$		TABLE	178	2.43
SYS	SYSAUX	CRC$_RESULT_CACHE_STATS		TABLE	18	0.25
SYS	SYSTEM	COL_USAGE$		TABLE	13	0.18
SYS	SYSAUX	WRH$_LATCH_PK	WRH$_LATCH_570420430_665	INDEX PARTITION	13	0.18
SYS	SYSAUX	CRC$_RCSTATSPK		INDEX	10	0.14

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 367
Captured Segments account for 2.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_570420430_665	TABLE PARTITION	10	2.72

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 3
Captured Segments account for 66.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_OBJ2		INDEX	2	66.67

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
OCIHOL	SYSTEM	MYEMP	TABLE	746,032	96.48
SYS	SYSTEM	REG$	TABLE	14,592	1.89
SYS	SYSTEM	AUD$	TABLE	8,016	1.04
SYS	SYSAUX	CRC$_RESULT_CACHE_STATS	TABLE	2,912	0.38
SYS	SYSTEM	COL_USAGE$	TABLE	464	0.06

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
OCIHOL	SYSTEM	MYEMP		TABLE	440	100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
OCIHOL	SYSTEM	MYEMP		TABLE	22,076	94.83
SYS	SYSTEM	AUD$		TABLE	1,204	5.17

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	14	0.00	2	1
dc_free_extents	6	50.00	0	3
dc_global_oids	1,871	0.05	0	12
dc_histogram_data	164	20.12	0	155
dc_histogram_defs	564	51.60	0	1,173
dc_objects	11,295	0.51	1	650
dc_profiles	10,002	0.00	0	1
dc_rollback_segments	202	0.00	0	28
dc_segments	121	35.54	4	341
dc_sequences	26	7.69	26	4
dc_tablespaces	2,483	0.00	0	4
dc_users	273,898	0.00	0	16
global database name	10,388	0.00	0	1
outstanding_alerts	1	0.00	0	1
sch_lj_oids	2	100.00	0	2

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	9	22.22	11	18.18	0
CLUSTER	23	4.35	16	6.25	0
DBLINK	20,000	0.00	0		0
EDITION	10,002	0.00	20,003	0.00	1
INDEX	1	100.00	1	100.00	0
LOCATION	5,115	0.22	5,115	0.22	0
QUEUE	0		116	0.00	0
SCHEMA	20,059	0.00	0		0
SQL AREA	118,427	0.23	181,372	0.07	23
SUBSCRIPTION	930	50.00	930	50.00	0
TABLE/PROCEDURE	10,752	0.62	21,308	0.40	34

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)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	16.00	16.00	16.00	16.00	STA/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	32.00	32.00	32.00	32.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	0.00	0.00	0.00	0.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	48.00	48.00	48.00	48.00	STA/
large pool	0.00	0.00	0.00	0.00	STA/
shared pool	100.00	100.00	100.00	100.00	STA/
streams pool	0.00	0.00	0.00	0.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

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	38.99		1.39	2.01	11	11	28	28
	Freeable	3.56	0.00	0.59	0.74	2		6	6
	SQL	0.75	0.62	0.04	0.13	1	3	17	10
	PL/SQL	0.48	0.41	0.02	0.04	0	0	28	28
E	Other	39.98		1.43	2.04	11	11	28	28
	Freeable	2.44	0.00	0.49	0.50	1		5	5
	SQL	0.76	0.62	0.04	0.13	1	3	17	10
	PL/SQL	0.48	0.41	0.02	0.04	0	0	28	28

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	16,777,216
Fixed Size	1,335,276
Redo Buffers	6,660,096
Variable Size	155,189,268

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	48.00	48.00	0.00
shared	ASH buffers	4.00	4.00	0.00
shared	CCUR	4.08	4.05	-0.58
shared	FileOpenBlock	3.79	3.79	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGLH0	1.56	1.65	5.72
shared	KGLHD	1.09	1.27	16.46
shared	KGLS	2.95	2.62	-11.08
shared	KGLSG	3.52	3.52	0.00
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	PCUR	2.08	2.08	0.37
shared	PLMCD	2.73	2.88	5.40
shared	PX msg pool	3.14	3.14	0.00
shared	SQLA	11.67	11.83	1.40
shared	XDBSC	5.35	5.35	0.00
shared	dbktb: trace buffer	1.56	1.56	0.00
shared	event statistics per sess	1.84	1.84	0.00
shared	free memory	7.94	7.69	-3.18
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kse signatures	1.83	1.83	0.00
shared	ksunfy : SSO free list	1.78	1.78	0.00
shared	message pool freequeue	1.09	1.09	0.00
shared	obj stats allocation chun	2.21	2.21	0.00
shared	row cache	3.62	3.62	0.00
	buffer_cache	16.00	16.00	0.00
	fixed_sga	1.27	1.27	0.00
	log_buffer	6.35	6.35	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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams 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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

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

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

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

Parameter Name	Begin value	End value (if different)
O7_DICTIONARY_ACCESSIBILITY	FALSE
_assm_default	FALSE
_auto_bmr	disabled
_cgs_node_kill_escalation	FALSE
_controlfile_enqueue_holding_time	300
_controlfile_enqueue_holding_time_tracking_size	25
_controlfile_update_check	HIGH
_db_block_bad_write_check	TRUE
_db_block_check_for_debug	TRUE
_db_cache_process_cr_pin_max	500
_dead_process_scan_interval	10
_disable_adaptive_shrunk_aggregation	FALSE
_disable_cpu_check	TRUE
_diskmon_pipe_name	/ade/b/3050220379/oracle/work/pipe1
_enable_NUMA_support	FALSE
_enable_automatic_sqltune	FALSE
_fix_control	6670551:OFF
_force_oltp_compress	TRUE
_gc_integrity_checks	2
_ges_dd_debug	2
_high_priority_processes	VKTM
_hm_analysis_oradebug_node_dump_level	4
_hm_analysis_oradebug_sys_dump_level	10
_hm_analysis_output_disk	TRUE
_kcl_debug	TRUE
_kdz_hcc_flags	15
_kgl_kqr_cap_so_stacks	TRUE
_kill_enqueue_blocker	3
_kse_signature_entries	60000
_kse_signature_limit	7
_ksu_diag_kill_time	30
_ksuitm_addon_trccmd	/ade/b/3050220379/oracle/rdbms/test/tkin/sosd/tkinksuitm.sh
_lm_dd_interval	5
_lm_rcvr_hang_allow_time	150
_lm_validate_pbatch	TRUE
_lm_validate_resource_type	TRUE
_log_archive_security_enabled	FALSE
_optimizer_autostats_job	FALSE
_optimizer_cost_model	fixed
_oradbg_pathname	/ade/b/3050220379/oracle/rdbms/utl/oradbg
_pgactx_cap_stacks	TRUE
_qa_lrg_type	1
_realfree_heap_mode	3
_recovery_asserts	TRUE
_recovery_verify_writes	TRUE
_redo_compatibility_check	TRUE
_sga_early_trace	1
_shared_io_pool_size	0
_smm_auto_cost_enabled	FALSE
_trace_buffers	FGS:512;BGS:1024
_trace_events	10432:6:ALL, 10435:6:LMON, LMD0, 10427:6:ALL, 10429:6:ALL, 10434:6:LMD0, LMS0, LMS1, LMS2, LMS3, LMS4, LMS5, LMS6, LMS7, LMS8, LMS9, 10401:8:ALL, 10249:5:FGS, 10257:1:ALL, 10720:1:ALL:FAST, 10722:1:ALL:FAST, 10298:1:ALL
_trace_files_public	TRUE
audit_trail	DB
cell_offload_processing	FALSE
client_result_cache_size	65536
commit_point_strength	1
compatible	11.2.0.0.0
control_files	/ade/b/3050220379/oracle/dbs/t_cf1.f
db_block_checking	true
db_block_checksum	true
db_block_size	8192
db_cache_size	16777216
db_domain	regress.rdbms.dev.us.oracle.com
db_name	linuxs
diagnostic_dest	/ade/b/3050220379/oracle/log
event	10808 trace name context forever, level 7, 10809 trace name context forever, level 37, 29715 trace name context forever, level 3, 29718 trace name context forever, level 5, 10235 trace name context forever, level 2, 10828 trace name context forever, level 0, 10753 trace name context forever, level 1, 19392 trace name context forever, level 2, 19394 trace name context forever, level 8, 19396 trace name context forever, level 2, 10324 trace name context forever, level 1, 1578 trace name errorstack level 1; na
global_names	FALSE
ifile	/ade/b/3050220379/oracle/work/tkinit.ora
instance_name	linuxs
instance_number	1
java_pool_size	50331648
log_archive_trace	8191
log_checkpoints_to_alert	TRUE
nls_length_semantics	BYTE
open_cursors	300
open_links	10
open_links_per_instance	20
pga_aggregate_target	30408704
plsql_optimize_level	2
processes	100
remote_login_passwordfile	SHARED
service_names	linuxs.regress.rdbms.dev.us.oracle.com
sessions	172
shared_pool_size	104857600
transactions	21
transactions_per_rollback_segment	21
undo_management	AUTO

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	98.95	Redo NoWait %:	99.99
Buffer Hit %:	99.90	In-memory Sort %:	100.00
Library Hit %:	99.70	Soft Parse %:	99.95
Execute to Parse %:	-7.52	Latch Hit %:	99.75
Parse CPU to Parse Elapsd %:	14.04	% Non-Parse CPU:	97.40