WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

BDLMS 3032207194 bdlms 1 01-Nov-11 09:11 11.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
BDLMS	3032207194	bdlms	1	01-Nov-11 09:11	11.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

oraclevm02 AIX-Based Systems (64-bit) 16 8 4.00

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
oraclevm02	AIX-Based Systems (64-bit)	16	8		4.00

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1417 15-Jun-12 00:00:33 37 1.5

End Snap: 1425 15-Jun-12 08:00:49 36 1.5

Elapsed: 480.27 (mins)

DB Time: 12.13 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1417	15-Jun-12 00:00:33	37	1.5
End Snap:	1425	15-Jun-12 08:00:49	36	1.5
Elapsed:		480.27 (mins)
DB Time:		12.13 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 624M 624M Log Buffer: 6,684K

	Begin	End
Buffer Cache:	352M	352M	Std Block Size:	8K
Shared Pool Size:	624M	624M	Log Buffer:	6,684K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.0 0.2 0.01 0.08

DB CPU(s): 0.0 0.0 0.00 0.01

Redo size: 716.4 6,340.0

Logical reads: 20.7 182.9

Block changes: 3.0 26.4

Physical reads: 0.1 0.8

Physical writes: 0.3 2.8

User calls: 0.3 2.8

Parses: 2.1 18.5

Hard parses: 0.0 0.1

W/A MB processed: 0.0 0.1

Logons: 0.1 0.6

Executes: 3.3 29.2

Rollbacks: 0.0 0.0

Transactions: 0.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.0	0.2	0.01	0.08
DB CPU(s):	0.0	0.0	0.00	0.01
Redo size:	716.4	6,340.0
Logical reads:	20.7	182.9
Block changes:	3.0	26.4
Physical reads:	0.1	0.8
Physical writes:	0.3	2.8
User calls:	0.3	2.8
Parses:	2.1	18.5
Hard parses:	0.0	0.1
W/A MB processed:	0.0	0.1
Logons:	0.1	0.6
Executes:	3.3	29.2
Rollbacks:	0.0	0.0
Transactions:	0.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.97 Soft Parse %: 99.72

Execute to Parse %: 36.64 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 6.04 % Non-Parse CPU: 99.55

Shared Pool Statistics

Begin End

Memory Usage %: 84.79 84.73

% SQL with executions>1: 95.93 96.80

% Memory for SQL w/exec>1: 97.06 97.42

	Begin	End
Memory Usage %:	84.79	84.73
% SQL with executions>1:	95.93	96.80
% Memory for SQL w/exec>1:	97.06	97.42

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
OJVM: Generic	270	80	296	10.99	Other
DB CPU		65		8.89
log file sync	917	1	1	0.12	Commit
Disk file operations I/O	1,425	0	0	0.01	User I/O
db file sequential read	26	0	4	0.01	User I/O

Host CPU (CPUs: 16 Cores: 8 Sockets: )

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

3.64 4.61 0.1 0.8 0.0 99.1

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
3.64	4.61	0.1	0.8	0.0	99.1

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

0.0 2.5 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 4,096.0 4,096.0

SGA use (MB): 1,072.0 1,072.0

PGA use (MB): 153.9 156.4

% Host Mem used for SGA+PGA: 29.93 29.99

	Begin	End
Host Mem (MB):	4,096.0	4,096.0
SGA use (MB):	1,072.0	1,072.0
PGA use (MB):	153.9	156.4
% Host Mem used for SGA+PGA:	29.93	29.99

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
Shared Server Statistics
init.ora Parameters

Wait Events Statistics

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

Time Model Statistics

Total time in database user-calls (DB Time): 727.5s
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	712.59	97.95
Java execution elapsed time	661.71	90.95
DB CPU	64.71	8.89
PL/SQL execution elapsed time	10.02	1.38
parse time elapsed	9.58	1.32
connection management call elapsed time	1.18	0.16
failed parse elapsed time	0.10	0.01
hard parse elapsed time	0.07	0.01
repeated bind elapsed time	0.00	0.00
sequence load elapsed time	0.00	0.00
DB time	727.51
background elapsed time	174.37
background cpu time	42.94

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
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	25,717
AVG_IDLE_TIME	2,869,226
AVG_IOWAIT_TIME	46
AVG_SYS_TIME	23,625
AVG_USER_TIME	1,244
BUSY_TIME	425,682
IDLE_TIME	45,922,174
IOWAIT_TIME	3,253
SYS_TIME	392,941
USER_TIME	32,741
LOAD	4	5
OS_CPU_WAIT_TIME	7,466,000
PHYSICAL_MEMORY_BYTES	4,294,967,296
NUM_CPUS	16
NUM_CPU_CORES	8
GLOBAL_RECEIVE_SIZE_MAX	1,048,576
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	16,384
TCP_RECEIVE_SIZE_MAX	9,223,372,036,854,775,807
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	9,223,372,036,854,775,807
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
15-Jun 00:00:33	3.64
15-Jun 01:00:16	0.12	0.91	0.08	0.83	99.09	0.01
15-Jun 02:00:02	0.10	0.94	0.08	0.86	99.06	0.01
15-Jun 03:00:43	0.12	0.92	0.07	0.85	99.08	0.01
15-Jun 04:00:08	3.26	0.89	0.07	0.82	99.11	0.01
15-Jun 05:00:54	5.39	0.94	0.07	0.87	99.06	0.01
15-Jun 06:00:23	5.59	0.90	0.07	0.83	99.10	0.01
15-Jun 07:00:06	2.88	0.92	0.07	0.85	99.08	0.01
15-Jun 08:00:49	4.61	0.92	0.06	0.86	99.08	0.01

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 20.1% of Total DB time 727.51 (s)
Total FG Wait Time: 81.21 (s) DB CPU time: 64.71 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Other	2,296	92	80	35	11.00
DB CPU			65		8.89
Commit	917	0	1	1	0.12
User I/O	1,453	0	0	0	0.03
Concurrency	6	0	0	20	0.02
Network	1,370	0	0	0	0.00
System I/O	320	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
OJVM: Generic	270	30	80	296	0.08	10.99
log file sync	917	0	1	1	0.28	0.12
Disk file operations I/O	1,425	0	0	0	0.44	0.01
db file sequential read	26	0	0	4	0.01	0.01
library cache: mutex X	1	0	0	68	0.00	0.01
buffer busy waits	4	0	0	13	0.00	0.01
enq: JS - queue lock	1	0	0	7	0.00	0.00
read by other session	1	0	0	5	0.00	0.00
SQL*Net message to client	1,370	0	0	0	0.42	0.00
asynch descriptor resize	2,024	100	0	0	0.62	0.00
control file sequential read	320	0	0	0	0.10	0.00
jobq slave wait	62,750	100	31,329	499	19.27
SQL*Net message from client	1,370	0	17	13	0.42

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
os thread startup	1,197	0	71	59	0.37	40.48
db file parallel write	3,999	0	9	2	1.23	4.97
control file parallel write	10,242	0	8	1	3.15	4.72
log file parallel write	5,360	0	5	1	1.65	2.85
db file parallel read	14	0	2	122	0.00	0.98
db file sequential read	441	0	2	4	0.14	0.96
enq: PR - contention	17	0	1	34	0.01	0.34
log file sync	15	0	1	35	0.00	0.30
control file sequential read	31,074	0	0	0	9.54	0.16
Disk file operations I/O	705	0	0	0	0.22	0.03
enq: PV - syncstart	1	0	0	43	0.00	0.02
latch free	57	0	0	0	0.02	0.01
db file scattered read	1	0	0	6	0.00	0.00
LGWR wait for redo copy	99	0	0	0	0.03	0.00
asynch descriptor resize	1,480	100	0	0	0.45	0.00
SQL*Net message to client	1,096	0	0	0	0.34	0.00
rdbms ipc message	136,706	96	374,474	2739	41.99
DIAG idle wait	57,623	100	57,626	1000	17.70
dispatcher timer	481	100	28,860	60001	0.15
shared server idle wait	961	100	28,830	30000	0.30
pmon timer	10,558	95	28,813	2729	3.24
Streams AQ: qmn coordinator idle wait	2,058	50	28,812	14000	0.63
Streams AQ: qmn slave idle wait	1,029	0	28,812	28000	0.32
Space Manager: slave idle wait	5,807	99	28,812	4962	1.78
smon timer	96	100	28,800	300003	0.03
VKRM Idle	1	0	14,400	14399890	0.00
JOX Jit Process Sleep	1,115	95	8,298	7442	0.34
SQL*Net message from client	1,370	0	15	11	0.42
class slave wait	225	0	0	0	0.07

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	2130	99.7	.1	.1	.1
LGWR wait for redo copy	99	100.0
OJVM: Generic	270	64.1	.4				.7	34.8
SQL*Net message to client	2466	100.0
asynch descriptor resize	3504	100.0
buffer busy waits	4	25.0	50.0					25.0
control file parallel write	10.2K	95.9	2.3	.8	.5	.3	.1
control file sequential read	31.4K	100.0	.0			.0
db file parallel read	14		7.1				28.6	64.3
db file parallel write	3999	84.2	1.5	1.2	4.0	7.1	1.4	.6
db file scattered read	1				100.0
db file sequential read	454	36.8	4.0	24.2	30.2	2.9	1.1	.9
direct path sync	1	100.0
enq: JS - queue lock	1				100.0
enq: PR - contention	17	5.9		17.6	5.9	11.8	29.4	29.4
enq: PV - syncstart	1							100.0
latch free	58	94.8	3.4		1.7
latch: messages	1	100.0
latch: redo allocation	5	100.0
latch: row cache objects	1	100.0
library cache: mutex X	1							100.0
log file parallel write	5360	92.9	3.0	1.2	2.0	.6	.1	.2
log file sync	932	88.8	1.9	3.1	4.3	.9	.3	.6
os thread startup	1197							100.0
rdbms ipc reply	1	100.0
read by other session	1				100.0
DIAG idle wait	57.6K							100.0
JOX Jit Process Sleep	1116	4.7						2.5	92.8
SQL*Net message from client	2740				.1	98.4	1.3	.3
Space Manager: slave idle wait	5807	.7						.0	99.3
Streams AQ: qmn coordinator idle wait	2058	50.0							50.0
Streams AQ: qmn slave idle wait	1029								100.0
VKRM Idle	1								100.0
class slave wait	225	98.7	.4	.4	.4
dispatcher timer	481								100.0
jobq slave wait	62.7K	.0	.0	.0	.0	.0	.0	99.9
pmon timer	10.6K	8.9	.1						91.0
rdbms ipc message	136.7K	.6	.3	.4	.2	.3	.2	23.1	75.0
shared server idle wait	961								100.0
smon timer	96								100.0

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
		% of Total Waits
OJVM: Generic	94	65.2	4.1	1.1			29.6
buffer busy waits	1	75.0	25.0
db file parallel read	9	35.7	35.7	14.3		7.1	7.1
db file parallel write	25	99.4	.5	.1
db file sequential read	4	99.1	.7	.2
enq: PR - contention	5	70.6	11.8	17.6
enq: PV - syncstart	1		100.0
library cache: mutex X	1			100.0
log file parallel write	13	99.8	.1	.0	.1
log file sync	6	99.4	.3	.1	.2
os thread startup	1197		91.6	8.3	.1

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	728	65	0	405
SYS$BACKGROUND	0	0	3	190
bdlms	0	0	0	0
bdlmsXDB	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts
SYS$USERS	1453	0	6	0	1370
SYS$BACKGROUND	1162	3	1197	71	0
bdlms	0	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 4.1% of Total DB Time (s): 728
Captured PL/SQL account for 47.4% of Total DB Time (s): 728

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Text
332.36	80	4.15	45.68	0.88	0.01	f8f7gbzbstcyx	DECLARE job BINARY_INTEGER := ...
9.43	479	0.02	1.30	50.27	0.59	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
7.70	608	0.01	1.06	0.26	0.12	aq8yqxyyb40nn	update sys.job$ set this_date=...
5.21	608	0.01	0.72	0.77	0.00	cumjq42201t37	select u1.user#, u2.user#, u3....
1.92	1	1.92	0.26	2.61	92.55	ajymgnp1qnruw	select o.name, o.owner# from o...
1.65	27,140	0.00	0.23	0.00	0.00	cm5vu20fhtnq1	select /*+ connect_by_filterin...
1.44	8	0.18	0.20	57.65	0.17	bunssq950snhf	insert into wrh$_sga_target_ad...
1.34	8	0.17	0.18	62.80	0.03	dayq182sk41ks	insert into wrh$_memory_target...
1.33	8	0.17	0.18	63.01	0.00	bm2pwrpcr8ru6	select sga_size s, sga_size_fa...
1.13	704	0.00	0.16	0.00	0.00	49s332uhbnsma	declare vsn varchar2(20); beg...

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 7.9% of Total CPU Time (s): 65
Captured PL/SQL account for 14.0% of Total CPU Time (s): 65

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
4.74	479	0.01	7.32	9.43	50.27	0.59	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
2.93	80	0.04	4.53	332.36	0.88	0.01	f8f7gbzbstcyx		DECLARE job BINARY_INTEGER := ...
0.84	8	0.11	1.30	1.33	63.01	0.00	bm2pwrpcr8ru6		select sga_size s, sga_size_fa...
0.84	8	0.11	1.30	1.34	62.80	0.03	dayq182sk41ks		insert into wrh$_memory_target...
0.83	444	0.00	1.28	0.91	91.24	1.64	3am9cfkvx7gq1		CALL MGMT_ADMIN_DATA.EVALUATE_...
0.83	8	0.10	1.28	1.44	57.65	0.17	bunssq950snhf		insert into wrh$_sga_target_ad...
0.24	21	0.01	0.37	0.55	43.81	0.00	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
0.18	8	0.02	0.28	0.34	53.10	0.00	5dfmd823r8dsp		insert into wrh$_memory_resize...
0.16	1,035	0.00	0.25	0.24	66.21	6.60	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
0.16	8	0.02	0.25	0.43	37.21	24.25	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1.78	1	1.78	48.31	1.92	2.61	92.55	ajymgnp1qnruw		select o.name, o.owner# from o...
0.29	8	0.04	7.93	0.39	20.67	75.25	fnk7155mk2jq6		insert into wrh$_sysmetric_his...
0.26	5	0.05	7.17	0.28	7.21	95.02	fh2sspdq8rm9p		insert into wrh$_waitclassmetr...
0.10	8	0.01	2.84	0.43	37.21	24.25	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.07	132	0.00	1.78	0.07	0.00	91.49	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
0.06	479	0.00	1.52	9.43	50.27	0.59	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0.05	80	0.00	1.29	332.36	0.88	0.01	f8f7gbzbstcyx		DECLARE job BINARY_INTEGER := ...
0.05	2	0.02	1.25	0.05	42.42	97.50	bwsz40d3hc8q7		insert into wrh$_librarycache ...
0.05	4	0.01	1.25	0.05	0.00	99.50	87gaftwrm2h68		select o.owner#, o.name, o.nam...
0.04	1	0.04	1.14	0.08	24.08	50.51	bxywuzvtp6wjg	DBMS_SCHEDULER	call dbms_scheduler.auto_purge...

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: 595,440
Captured SQL account for 65.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
240,033	479	501.11	40.31	9.43	50.27	0.59	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
100,772	27,140	3.71	16.92	1.65	0.00	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
73,503	444	165.55	12.34	0.91	91.24	1.64	3am9cfkvx7gq1		CALL MGMT_ADMIN_DATA.EVALUATE_...
37,835	21	1,801.67	6.35	0.55	43.81	0.00	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
35,836	6	5,972.67	6.02	0.14	58.48	0.00	7qjhf5dzmazsr		SELECT snap_id , OBJ#, DATAOBJ...
35,833	7	5,119.00	6.02	0.12	56.68	0.54	gjm43un5cy843		SELECT SUM(USED), SUM(TOTAL) F...
32,865	883	37.22	5.52	0.49	2.03	0.00	0k8522rmdzg4k		select privilege# from sysauth...
23,266	508	45.80	3.91	0.21	27.98	0.00	4jrfrtx4u6zcx		SELECT TASK_TGT.TARGET_GUID TA...
18,672	1,556	12.00	3.14	0.32	9.52	0.05	fsbqktj5vw6n9		select next_run_date, obj#, ru...
17,253	5,751	3.00	2.90	0.91	1.10	0.00	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
10,426	80	130.33	1.75	332.36	0.88	0.01	f8f7gbzbstcyx		DECLARE job BINARY_INTEGER := ...
10,059	1,035	9.72	1.69	0.24	66.21	6.60	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
7,556	8	944.50	1.27	0.43	37.21	24.25	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...

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,570
Captured SQL account for 92.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,204	1	2,204.00	85.76	1.92	2.61	92.55	ajymgnp1qnruw		select o.name, o.owner# from o...
125	8	15.63	4.86	0.39	20.67	75.25	fnk7155mk2jq6		insert into wrh$_sysmetric_his...
24	5	4.80	0.93	0.28	7.21	95.02	fh2sspdq8rm9p		insert into wrh$_waitclassmetr...
15	8	1.88	0.58	0.43	37.21	24.25	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
11	1	11.00	0.43	0.08	24.08	50.51	bxywuzvtp6wjg	DBMS_SCHEDULER	call dbms_scheduler.auto_purge...
8	1	8.00	0.31	0.04	0.00	97.10	36g2yq0mxjx2y		insert into wrh$_pgastat (snap...
7	132	0.05	0.27	0.07	0.00	91.49	5h7w8ykwtb2xt		INSERT INTO SYS.WRI$_ADV_PARAM...
5	1	5.00	0.19	0.03	0.00	88.46	84k66tf2s7y1c		insert into wrh$_bg_event_summ...
5	80	0.06	0.19	332.36	0.88	0.01	f8f7gbzbstcyx		DECLARE job BINARY_INTEGER := ...
4	479	0.01	0.16	9.43	50.27	0.59	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...

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: 2,567
Captured SQL account for 119.8% of Total
Total UnOptimized Read Requests: 2,567
Captured SQL account for 119.8% 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 Text
2,204	2,204	1	2,204.00	85.86	ajymgnp1qnruw	select o.name, o.owner# from o...
324	324	479	0.68	12.62	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
321	321	444	0.72	12.50	3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_...
320	320	704	0.45	12.47	49s332uhbnsma	declare vsn varchar2(20); beg...
280	280	7	40.00	10.91	gjm43un5cy843	SELECT SUM(USED), SUM(TOTAL) F...
154	154	21	7.33	6.00	ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME...
150	150	15	10.00	5.84	bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(...
125	125	8	15.63	4.87	fnk7155mk2jq6	insert into wrh$_sysmetric_his...
84	84	12	7.00	3.27	7mgr3uwydqq8j	select decode(open_mode, 'MOU...
24	24	5	4.80	0.93	fh2sspdq8rm9p	insert into wrh$_waitclassmetr...

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: 95,140
Captured SQL account for 63.1% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
27,140	50,346	1.86	1.65	0.00	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
5,751	608	0.11	0.91	1.10	0.00	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
2,977	2,977	1.00	0.08	0.00	0.00	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
1,730	1,730	1.00	0.18	10.94	0.00	5kyb5bvnu3s04		SELECT DISTINCT METRIC_GUID FR...
1,556	1,556	1.00	0.32	9.52	0.05	fsbqktj5vw6n9		select next_run_date, obj#, ru...
1,372	981	0.72	0.09	11.61	0.00	08bqjmf8490s2	sqlplus@oraclevm02 (TNS V1-V3)	SELECT PARAMETER_VALUE FROM MG...
1,035	1,035	1.00	0.24	66.21	6.60	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
1,002	0	0.00	0.03	69.03	0.00	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
1,002	1,000	1.00	0.14	43.90	0.00	g00cj285jmgsw		update sys.mon_mods$ set inser...
967	967	1.00	0.07	0.00	0.00	bfujkg8dw1aax		SELECT UPPER(PARAMETER_VALUE) ...
960	19,200	20.00	0.31	6.37	0.00	aykvshm7zsabd		select size_for_estimate, size...
958	479	0.50	0.04	25.42	0.00	c8h3jdwaa532q	EM_PING	SELECT TO_NUMBER(PARAMETER_VAL...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 60,278
Captured SQL account for 77.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
27,141	27,140	45.03	cm5vu20fhtnq1		select /*+ connect_by_filterin...
1,556	1,556	2.58	fsbqktj5vw6n9		select next_run_date, obj#, ru...
1,356	1,372	2.25	08bqjmf8490s2	sqlplus@oraclevm02 (TNS V1-V3)	SELECT PARAMETER_VALUE FROM MG...
1,002	1,002	1.66	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
1,002	1,002	1.66	g00cj285jmgsw		update sys.mon_mods$ set inser...
958	2,977	1.59	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
958	958	1.59	c8h3jdwaa532q	EM_PING	SELECT TO_NUMBER(PARAMETER_VAL...
883	883	1.46	0k8522rmdzg4k		select privilege# from sysauth...
704	704	1.17	49s332uhbnsma		declare vsn varchar2(20); beg...
608	608	1.01	47a50dvdgnxc2		update sys.job$ set failures=0...
608	608	1.01	aq8yqxyyb40nn		update sys.job$ set this_date=...
608	608	1.01	cumjq42201t37		select u1.user#, u2.user#, u3....

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

089dbukv1aanh SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL

08bqjmf8490s2 SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

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

18naypzfmabd6 INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))

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

36g2yq0mxjx2y insert into wrh$_pgastat (snap_id, dbid, instance_number, name, value) select :snap_id, :dbid, :instance_number, name, value from v$pgastat where value > 0

3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)

47a50dvdgnxc2 update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4

49s332uhbnsma declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end;

4jrfrtx4u6zcx SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), MGMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POL ICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC

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

5h7w8ykwtb2xt INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )

5kyb5bvnu3s04 SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1

5ms6rbzdnq16t select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job

6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;

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

7mgr3uwydqq8j select decode(open_mode, 'MOUNTED', 0, 'READ WRITE', 1, 'READ ONLY', 1, 'READ ONLY WITH APPLY', 1, 2) dbstate into :dbstate from v$database

7qjhf5dzmazsr SELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id

84k66tf2s7y1c insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id

87gaftwrm2h68 select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1

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

ajymgnp1qnruw select o.name, o.owner# from obj$ o, type$ t where o.oid$ = t.tvoid and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007

aq8yqxyyb40nn update sys.job$ set this_date=:1 where job=:2

aykvshm7zsabd select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'

bfujkg8dw1aax SELECT UPPER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

bm2pwrpcr8ru6 select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size

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

bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice

bwsz40d3hc8q7 insert into wrh$_librarycache (snap_id, dbid, instance_number, namespace, gets, gethits, pins, pinhits, reloads, invalidations, dlm_lock_requests, dlm_pin_requests, dlm_pin_releases, dlm_invalidation_requests, dlm_invalidations) select :snap_id, :dbid, :instance_number, namespace, gets, gethits, pins, pinhits, reloads, invalidations, dlm_lock_requests, dlm_pin_requests, dlm_pin_releases, dlm_invalidation_requests, dlm_invalidations from v$librarycache

bxywuzvtp6wjg call dbms_scheduler.auto_purge ( )

c8h3jdwaa532q SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

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

cumjq42201t37 select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name

dayq182sk41ks insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice

f8f7gbzbstcyx DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN wb_rti_service_job.check_service(2); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

fh2sspdq8rm9p insert into wrh$_waitclassmetric_history (snap_id, dbid, instance_number, wait_class_id, begin_time, end_time, intsize, group_id, average_waiter_count, dbtime_in_wait, time_waited, wait_count, time_waited_fg, wait_count_fg) select :snap_id, :dbid, :instance_number, wait_id, begtime, endtime, intsize_csec, groupid, average_waiter_count, dbtime_in_wait, time_waited, wait_count, time_waited_fg, wait_count_fg from x$kewmevmv

fnk7155mk2jq6 insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime

fsbqktj5vw6n9 select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1

g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

gjm43un5cy843 SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)

SQL Id	SQL Text
089dbukv1aanh	SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
08bqjmf8490s2	SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
36g2yq0mxjx2y	insert into wrh$_pgastat (snap_id, dbid, instance_number, name, value) select :snap_id, :dbid, :instance_number, name, value from v$pgastat where value > 0
3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
47a50dvdgnxc2	update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
49s332uhbnsma	declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) \|\| substr(vsn, 4, 2) \|\| substr(vsn, 7, 2) \|\| nvl(substr(vsn, 10, 2), '00')); end if; end;
4jrfrtx4u6zcx	SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), MGMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POL ICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC
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
5h7w8ykwtb2xt	INSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
5kyb5bvnu3s04	SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
5ms6rbzdnq16t	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
7mgr3uwydqq8j	select decode(open_mode, 'MOUNTED', 0, 'READ WRITE', 1, 'READ ONLY', 1, 'READ ONLY WITH APPLY', 1, 2) dbstate into :dbstate from v$database
7qjhf5dzmazsr	SELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /+ ordered use_nl(t2) index(t2) / t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id
84k66tf2s7y1c	insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
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
ajymgnp1qnruw	select o.name, o.owner# from obj$ o, type$ t where o.oid$ = t.tvoid and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
bfujkg8dw1aax	SELECT UPPER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
bm2pwrpcr8ru6	select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size
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
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
bwsz40d3hc8q7	insert into wrh$_librarycache (snap_id, dbid, instance_number, namespace, gets, gethits, pins, pinhits, reloads, invalidations, dlm_lock_requests, dlm_pin_requests, dlm_pin_releases, dlm_invalidation_requests, dlm_invalidations) select :snap_id, :dbid, :instance_number, namespace, gets, gethits, pins, pinhits, reloads, invalidations, dlm_lock_requests, dlm_pin_requests, dlm_pin_releases, dlm_invalidation_requests, dlm_invalidations from v$librarycache
bxywuzvtp6wjg	call dbms_scheduler.auto_purge ( )
c8h3jdwaa532q	SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cumjq42201t37	select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
dayq182sk41ks	insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice
f8f7gbzbstcyx	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN wb_rti_service_job.check_service(2); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fh2sspdq8rm9p	insert into wrh$_waitclassmetric_history (snap_id, dbid, instance_number, wait_class_id, begin_time, end_time, intsize, group_id, average_waiter_count, dbtime_in_wait, time_waited, wait_count, time_waited_fg, wait_count_fg) select :snap_id, :dbid, :instance_number, wait_id, begtime, endtime, intsize_csec, groupid, average_waiter_count, dbtime_in_wait, time_waited, wait_count, time_waited_fg, wait_count_fg from x$kewmevmv
fnk7155mk2jq6	insert into wrh$_sysmetric_history (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, value from x$kewmdrmv order by groupid, metricid, begtime
fsbqktj5vw6n9	select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
gjm43un5cy843	SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /+ ORDERED / SUM(D.BYTES)/(10241024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(10241024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(10241024) BYTES FROM (SELECT /+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	11	0.00	0.00
Batched IO (full) vector count	2	0.00	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	2,334	0.08	0.72
Batched IO buffer defrag count	10	0.00	0.00
Batched IO double miss count	1	0.00	0.00
Batched IO same unit count	166	0.01	0.05
Batched IO single block count	0	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	2,170	0.08	0.67
Batched IO vector read count	14	0.00	0.00
Block Cleanout Optim referenced	23	0.00	0.01
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	2,402	0.08	0.74
CPU used when call started	665	0.02	0.20
CR blocks created	99	0.00	0.03
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	3,167,943	109.94	972.96
DBWR checkpoint buffers written	9,219	0.32	2.83
DBWR checkpoints	0	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	624	0.02	0.19
DBWR undo block writes	1,772	0.06	0.54
HSC Compressed Segment Block Changes	0	0.00	0.00
HSC Heap Segment Block Changes	12,464	0.43	3.83
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	906	0.03	0.28
Heap Segment Array Updates	35	0.00	0.01
IMU CR rollbacks	1	0.00	0.00
IMU Flushes	578	0.02	0.18
IMU Redo allocation size	446,768	15.50	137.21
IMU commits	3,140	0.11	0.96
IMU contention	3	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	14,238,168	494.10	4,372.90
IMU- failed to get a private strand	0	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	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
RowCR - row contention	0	0.00	0.00
RowCR attempts	1,419	0.05	0.44
RowCR hits	1,419	0.05	0.44
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	1,370	0.05	0.42
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	465	0.02	0.14
application wait time	0	0.00	0.00
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	130,665	4.53	40.13
branch node splits	0	0.00	0.00
buffer is not pinned count	241,545	8.38	74.18
buffer is pinned count	121,399	4.21	37.28
bytes received via SQL*Net from client	184,950	6.42	56.80
bytes sent via SQL*Net to client	999,969	34.70	307.12
calls to get snapshot scn: kcmgss	106,810	3.71	32.80
calls to kcmgas	7,157	0.25	2.20
calls to kcmgcs	41,936	1.46	12.88
cell physical IO interconnect bytes	972,779,520	33,757.86	298,765.21
change write time	144	0.00	0.04
cleanout - number of ktugct calls	481	0.02	0.15
cleanouts only - consistent read gets	10	0.00	0.00
cluster key scan block gets	17,714	0.61	5.44
cluster key scans	15,818	0.55	4.86
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	1	0.00	0.00
commit batch/immediate requested	1	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	31	0.00	0.01
commit cleanout failures: cannot pin	1	0.00	0.00
commit cleanouts	17,836	0.62	5.48
commit cleanouts successfully completed	17,804	0.62	5.47
commit immediate performed	1	0.00	0.00
commit immediate requested	1	0.00	0.00
commit txn count during cleanout	229	0.01	0.07
concurrency wait time	7,071	0.25	2.17
consistent changes	327	0.01	0.10
consistent gets	516,260	17.92	158.56
consistent gets - examination	167,885	5.83	51.56
consistent gets direct	0	0.00	0.00
consistent gets from cache	516,260	17.92	158.56
consistent gets from cache (fastpath)	332,167	11.53	102.02
cursor authentications	41	0.00	0.01
data blocks consistent reads - undo records applied	234	0.01	0.07
db block changes	86,040	2.99	26.43
db block gets	79,180	2.75	24.32
db block gets direct	1	0.00	0.00
db block gets from cache	79,179	2.75	24.32
db block gets from cache (fastpath)	21,798	0.76	6.69
deferred (CURRENT) block cleanout applications	9,815	0.34	3.01
dirty buffers inspected	3	0.00	0.00
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	5,821	0.20	1.79
enqueue releases	260,499	9.04	80.01
enqueue requests	260,499	9.04	80.01
enqueue timeouts	0	0.00	0.00
enqueue waits	19	0.00	0.01
exchange deadlocks	0	0.00	0.00
execute count	95,140	3.30	29.22
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	16,946,850	588.10	5,204.81
free buffer inspected	4,712	0.16	1.45
free buffer requested	4,470	0.16	1.37
global undo segment hints helped	0	0.00	0.00
heap block compress	231	0.01	0.07
hot buffers moved to head of LRU	9,339	0.32	2.87
immediate (CR) block cleanout applications	10	0.00	0.00
immediate (CURRENT) block cleanout applications	4,926	0.17	1.51
index crx upgrade (positioned)	0	0.00	0.00
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	288	0.01	0.09
index fetch by key	89,787	3.12	27.58
index scans kdiixs1	105,597	3.66	32.43
java call heap collected bytes	4,876,800	169.24	1,497.79
java call heap collected count	24,320	0.84	7.47
java call heap gc count	80	0.00	0.02
java call heap live object count	0	0.00	0.00
java call heap live object count max	0	0.00	0.00
java call heap live size	0	0.00	0.00
java call heap live size max	0	0.00	0.00
java call heap object count	24,320	0.84	7.47
java call heap object count max	24,320	0.84	7.47
java call heap total size	104,857,600	3,638.82	32,204.42
java call heap total size max	104,857,600	3,638.82	32,204.42
java call heap used size	4,876,800	169.24	1,497.79
java call heap used size max	4,876,800	169.24	1,497.79
java session heap live object count	0	0.00	0.00
java session heap live object count max	0	0.00	0.00
java session heap live size	23,592,960	818.73	7,246.00
java session heap live size max	23,592,960	818.73	7,246.00
java session heap object count	0	0.00	0.00
java session heap object count max	0	0.00	0.00
java session heap used size	23,592,960	818.73	7,246.00
java session heap used size max	23,592,960	818.73	7,246.00
leaf node 90-10 splits	185	0.01	0.06
leaf node splits	224	0.01	0.07
lob reads	240	0.01	0.07
lob writes	12	0.00	0.00
lob writes unaligned	12	0.00	0.00
local undo segment hints helped	0	0.00	0.00
logons cumulative	2,100	0.07	0.64
max cf enq hold time	8	0.00	0.00
messages received	9,993	0.35	3.07
messages sent	9,993	0.35	3.07
min active SCN optimization applied on CR	8	0.00	0.00
no buffer to keep pinned count	1	0.00	0.00
no work - consistent read gets	292,580	10.15	89.86
non-idle wait count	67,249	2.33	20.65
non-idle wait time	17,853	0.62	5.48
opened cursors cumulative	86,544	3.00	26.58
parse count (describe)	0	0.00	0.00
parse count (failures)	160	0.01	0.05
parse count (hard)	168	0.01	0.05
parse count (total)	60,278	2.09	18.51
parse time cpu	29	0.00	0.01
parse time elapsed	480	0.02	0.15
physical read IO requests	2,567	0.09	0.79
physical read bytes	21,053,440	730.61	6,466.04
physical read total IO requests	34,025	1.18	10.45
physical read total bytes	538,558,464	18,689.31	165,404.93
physical read total multi block requests	0	0.00	0.00
physical reads	2,570	0.09	0.79
physical reads cache	2,570	0.09	0.79
physical reads cache prefetch	2,159	0.07	0.66
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	6,903	0.24	2.12
physical write bytes	75,554,816	2,621.94	23,204.80
physical write total IO requests	32,754	1.14	10.06
physical write total bytes	434,221,056	15,068.55	133,360.28
physical write total multi block requests	77	0.00	0.02
physical writes	9,223	0.32	2.83
physical writes direct	1	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	1	0.00	0.00
physical writes from cache	9,222	0.32	2.83
physical writes non checkpoint	2,025	0.07	0.62
pinned buffers inspected	0	0.00	0.00
pinned cursors current	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	665,712	23.10	204.46
recursive cpu usage	1,095	0.04	0.34
redo blocks checksummed by FG (exclusive)	27,502	0.95	8.45
redo blocks read for recovery	0	0.00	0.00
redo blocks written	45,032	1.56	13.83
redo buffer allocation retries	0	0.00	0.00
redo entries	27,913	0.97	8.57
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	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	904	0.03	0.28
redo size	20,642,932	716.36	6,339.97
redo size for direct writes	0	0.00	0.00
redo subscn max counts	2,782	0.10	0.85
redo synch time	148	0.01	0.05
redo synch writes	1,195	0.04	0.37
redo wastage	1,630,028	56.57	500.62
redo write time	573	0.02	0.18
redo writes	5,360	0.19	1.65
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	2	0.00	0.00
root node splits	0	0.00	0.00
rows fetched via callback	37,278	1.29	11.45
session connect time	0	0.00	0.00
session cursor cache hits	59,059	2.05	18.14
session logical reads	595,440	20.66	182.87
shared hash latch upgrades - no wait	15,196	0.53	4.67
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	82,993	2.88	25.49
sorts (rows)	497,288	17.26	152.73
space was found by tune down	0	0.00	0.00
space was not found by tune down	0	0.00	0.00
sql area evicted	3	0.00	0.00
sql area purged	160	0.01	0.05
steps of tune down ret. in space pressure	0	0.00	0.00
summed dirty queue length	3	0.00	0.00
switch current to new buffer	107	0.00	0.03
table fetch by rowid	80,562	2.80	24.74
table fetch continued row	0	0.00	0.00
table scan blocks gotten	45,846	1.59	14.08
table scan rows gotten	2,206,870	76.58	677.79
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	16,573	0.58	5.09
total cf enq hold time	474	0.02	0.15
total number of cf enq holders	224	0.01	0.07
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	1	0.00	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	7,308,300	253.62	2,244.56
user I/O wait time	364	0.01	0.11
user calls	9,139	0.32	2.81
user commits	3,256	0.11	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	30,559	1.06	9.39
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory	237,028,779,656	238,728,605,864
session pga memory max	253,503,481,480	255,321,600,168
session cursor cache count	6,399,739	6,434,941
session uga memory	371,297,223,790,624	373,998,863,372,816
opened cursors current	55	55
workarea memory allocated	2,743	2,743
logons current	37	36
session uga memory max	295,126,441,920	296,514,942,184

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	493M	1.09	.017108	320M	0.71	.011104	41.7K	0.03
DBWR	0M	0.00	0M	72M	0.24	.002498	0
LGWR	0M	0.00	0M	23M	0.19	.000798	0
Buffer Cache Reads	20M	0.09	.000694	0M	0.00	0M	405	8.07
Direct Writes	0M	0.00	0M	0M	0.00	0M	0
TOTAL:	513M	1.18	.017802	415M	1.14	.014401	42.1K	0.11

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
Control File	493M	1.09	.017108	321M	0.71	.011139	0.00
Data File	21M	0.09	.000728	72M	0.24	.002498	1.01
Log File	0M	0.00	0M	23M	0.19	.000798
Temp File	0M	0.00	0M	0M	0.00	0M	0.00
TOTAL:	514M	1.18	.017837	416M	1.14	.014436	0.08

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)
Others	493M	1.09	.017108	320M	0.71	.011104	31.5K	0.00
Others (Control File)	493M	1.09	.017108	320M	0.71	.011104	31.4K	0.00
Others (Data File)	0M	0.00	0M	0M	0.00	0M	64	0.00
DBWR	0M	0.00	0M	72M	0.24	.002498	0
DBWR (Data File)	0M	0.00	0M	72M	0.24	.002498	0
LGWR	0M	0.00	0M	23M	0.19	.000798	0
LGWR (Log File)	0M	0.00	0M	23M	0.19	.000798	0
Buffer Cache Reads	20M	0.09	.000694	0M	0.00	0M	391	3.97
Buffer Cache Reads (Data File)	20M	0.09	.000694	0M	0.00	0M	391	3.97
Direct Writes	0M	0.00	0M	0M	0.00	0M	0
Direct Writes (Data File)	0M	0.00	0M	0M	0.00	0M	0
TOTAL:	513M	1.18	.017802	415M	1.14	.014401	31.8K	0.05

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
SYSAUX	351	4.62	1.01	5,049	0	0.00
SYSTEM	2,218	0.06	1.00	416	5	10.00
BODAUNDO	0	0.00	0.00	1,325	0	0.00
BODA_DATA	5	6.00	1.00	112	0	0.00
TEMP	1	0.00	1.00	1	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
BODAUNDO	/home/oracle/db/oracle/oradata/bdlms/boda_undo.dbf	0			1,325	0	0.00
BODA_DATA	/home/oracle/db/oracle/oradata/bdlms/boda_data01.dbf	5	6.00	1.00	112	0	0.00
SYSAUX	/home/oracle/db/oracle/oradata/bdlms/sysaux01.dbf	351	4.62	1.01	5,049	0	0.00
SYSTEM	/home/oracle/db/oracle/oradata/bdlms/system01.dbf	2,218	0.06	1.00	416	5	10.00
TEMP	/home/oracle/db/oracle/oradata/bdlms/temp01.dbf	1	0.00	1.00	1	0

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	43,340	100	595,395	2,574	9,222	0	0	5

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 9,223

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	9,219	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	8	378	1569	1738	165888	1738
E	0	8	378	1497	1418	165888	1418

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	32	0.09	4	171.58	2,627,873	1	6815146.00
D	64	0.18	8	92.77	1,420,787	1	3670129.00
D	96	0.27	12	7.54	115,501	1	269252.00
D	128	0.36	16	1.52	23,320	1	29079.00
D	160	0.45	20	1.34	20,459	1	21625.00
D	192	0.55	24	1.19	18,263	1	15901.00
D	224	0.64	28	1.12	17,086	1	12837.00
D	256	0.73	32	1.07	16,361	1	10948.00
D	288	0.82	35	1.04	15,888	1	9714.00
D	320	0.91	39	1.02	15,569	1	8882.00
D	352	1.00	43	1.00	15,315	1	8222.00
D	384	1.09	47	0.99	15,119	1	7711.00
D	416	1.18	51	0.98	14,943	1	7252.00
D	448	1.27	55	0.96	14,764	1	6786.00
D	480	1.36	59	0.95	14,564	1	6264.00
D	512	1.45	63	0.93	14,308	1	5597.00
D	544	1.55	67	0.91	13,954	1	4675.00
D	576	1.64	71	0.88	13,515	1	3532.00
D	608	1.73	75	0.85	12,997	1	2513.00
D	640	1.82	79	0.78	11,979	1	2511.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	326	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	29,808	29,808
64K	128K	548	548
256K	512K	2	2
512K	1024K	168	168
1M	2M	17	17
4M	8M	16	16

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
72	0.13	316,058.79	80,033.37	80.00	3,741	147,188,143
144	0.25	316,058.79	15,949.04	95.00	277	123,374,361
288	0.50	316,058.79	2,370.81	99.00	1	118,328,680
432	0.75	316,058.79	1,289.07	100.00	0	117,926,703
576	1.00	316,058.79	984.30	100.00	0	117,813,452
691	1.20	316,058.79	883.62	100.00	0	117,776,037
806	1.40	316,058.79	883.62	100.00	0	117,776,037
922	1.60	316,058.79	883.62	100.00	0	117,776,037
1,037	1.80	316,058.79	883.62	100.00	0	117,776,037
1,152	2.00	316,058.79	883.62	100.00	0	117,776,037
1,728	3.00	316,058.79	883.62	100.00	0	117,776,037
2,304	4.00	316,058.79	883.62	100.00	0	117,776,037
3,456	6.00	316,058.79	883.62	100.00	0	117,776,037
4,608	8.00	316,058.79	883.62	100.00	0	117,776,037

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)
368	0.59	12	1,003	1,950,882	1.00	14,460	1.30	33,273
432	0.69	77	5,455	1,951,338	1.00	14,004	1.26	165,518
496	0.79	141	7,845	1,953,278	1.00	12,064	1.08	165,665
560	0.90	205	10,286	1,953,850	1.00	11,492	1.03	165,720
624	1.00	269	11,851	1,954,193	1.00	11,149	1.00	165,757
688	1.10	332	13,357	1,954,523	1.00	10,819	0.97	165,798
752	1.21	396	14,825	1,954,925	1.00	10,417	0.93	165,847
816	1.31	460	16,281	1,955,244	1.00	10,098	0.91	165,886
880	1.41	524	17,818	1,955,428	1.00	9,914	0.89	165,907
944	1.51	588	19,524	1,955,568	1.00	9,774	0.88	165,925
1,008	1.62	652	21,271	1,955,698	1.00	9,644	0.87	165,943
1,072	1.72	716	23,136	1,955,808	1.00	9,534	0.86	165,958
1,136	1.82	780	25,116	1,955,901	1.00	9,441	0.85	165,973
1,200	1.92	843	27,419	1,955,988	1.00	9,354	0.84	165,984
1,264	2.03	907	29,810	1,956,060	1.00	9,282	0.83	165,994

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
804	0.75	213,973	19,582,242
1,072	1.00	208,185	15,315,378
1,340	1.25	204,833	15,315,378
1,608	1.50	203,438	16,617,185
1,876	1.75	203,022	16,617,185
2,144	2.00	202,939	15,315,378

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	0.50	0	0	0	0
32	1.00	0	0	0	0
48	1.50	0	0	0	0
64	2.00	0	0	0	0
80	2.50	0	0	0	0
96	3.00	0	0	0	0
112	3.50	0	0	0	0
128	4.00	0	0	0	0
144	4.50	0	0	0	0
160	5.00	0	0	0	0
176	5.50	0	0	0	0
192	6.00	0	0	0	0
208	6.50	0	0	0	0
224	7.00	0	0	0	0
240	7.50	0	0	0	0
256	8.00	0	0	0	0
272	8.50	0	0	0	0
288	9.00	0	0	0	0
304	9.50	0	0	0	0
320	10.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)	JP 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
32	1.00	9	173	28,614	1.00	11,149	1.00	241,534
48	1.50	20	362	28,614	1.00	11,149	1.00	423,459
64	2.00	22	406	28,614	1.00	11,149	1.00	423,459

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

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Waits	Wt Time (s)	Av Wt Time(ms)
PR-Process Startup	1,197	1,197	17	1	34.41
PV-KSV slave startup (syncstart)	225	225	1	0	43.00
JS-Job Scheduler (queue lock)	104,480	104,480	1	0	7.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
9	1.15	5,471	1,072	4	66756.8/67307.6	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
15-Jun 07:55	7	69	991	1	67,196	0/0	0/0/0/0/0/0
15-Jun 07:45	9	81	391	1	67,200	0/0	0/0/0/0/0/0
15-Jun 07:35	8	62	996	3	67,200	0/0	0/0/0/0/0/0
15-Jun 07:25	6	82	396	1	67,217	0/0	0/0/0/0/0/0
15-Jun 07:15	9	68	998	1	67,200	0/0	0/0/0/0/0/0
15-Jun 07:05	103	242	397	4	66,805	0/0	0/0/0/0/0/0
15-Jun 06:55	10	73	1,001	4	67,187	0/0	0/0/0/0/0/0
15-Jun 06:45	8	90	401	2	67,208	0/0	0/0/0/0/0/0
15-Jun 06:35	6	55	1,003	1	67,229	0/0	0/0/0/0/0/0
15-Jun 06:25	10	82	403	2	67,207	0/0	0/0/0/0/0/0
15-Jun 06:15	6	60	1,007	2	67,241	0/0	0/0/0/0/0/0
15-Jun 06:05	101	240	407	3	66,817	0/0	0/0/0/0/0/0
15-Jun 05:55	9	71	1,012	3	67,198	0/0	0/0/0/0/0/0
15-Jun 05:45	8	76	412	2	67,202	0/0	0/0/0/0/0/0
15-Jun 05:35	7	78	1,014	1	67,215	0/0	0/0/0/0/0/0
15-Jun 05:25	5	65	414	1	67,228	0/0	0/0/0/0/0/0
15-Jun 05:15	9	156	1,018	2	67,198	0/0	0/0/0/0/0/0
15-Jun 05:05	101	167	418	3	66,816	0/0	0/0/0/0/0/0
15-Jun 04:55	8	77	1,022	1	67,164	0/0	0/0/0/0/0/0
15-Jun 04:45	7	62	421	2	67,164	0/0	0/0/0/0/0/0
15-Jun 04:35	6	77	1,025	1	67,172	0/0	0/0/0/0/0/0
15-Jun 04:25	6	64	426	2	67,168	0/0	0/0/0/0/0/0
15-Jun 04:15	11	155	1,028	2	67,146	0/0	0/0/0/0/0/0
15-Jun 04:05	105	160	428	3	66,757	0/0	0/0/0/0/0/0
15-Jun 03:55	9	78	1,032	1	67,189	0/0	0/0/0/0/0/0
15-Jun 03:45	5	62	432	1	67,210	0/0	0/0/0/0/0/0
15-Jun 03:35	12	80	1,035	3	67,176	0/0	0/0/0/0/0/0
15-Jun 03:25	8	159	435	2	67,210	0/0	0/0/0/0/0/0
15-Jun 03:15	6	60	1,039	2	67,218	0/0	0/0/0/0/0/0
15-Jun 03:05	101	168	438	3	66,807	0/0	0/0/0/0/0/0
15-Jun 02:55	7	64	1,042	1	67,231	0/0	0/0/0/0/0/0
15-Jun 02:45	13	97	443	2	67,210	0/0	0/0/0/0/0/0
15-Jun 02:35	10	68	1,048	3	67,236	0/0	0/0/0/0/0/0
15-Jun 02:25	7	89	447	1	67,257	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	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	8	0.00		0
ASM db client latch	19,204	0.00		0
ASM map operation hash table	8	0.00		0
ASM network state latch	503	0.00		0
AWR Alerted Metric Element list	205,511	0.00		0
Change Notification Hash table latch	9,603	0.00		0
Consistent RBA	5,360	0.00		0
DML lock allocation	21,580	0.00		0
Event Group Locks	1,479	0.00		0
FOB s.o list latch	4,255	0.00		0
File State Object Pool Parent Latch	8	0.00		0
IPC stats buffer allocation latch	8	0.00		0
In memory undo latch	46,368	0.00		9,930	0.00
JOX JIT latch	102	51.96	1.00	102	0.00
JOX SGA heap latch	3,120	0.00		0
JS Sh mem access	58	6.90	1.00	0
JS broadcast autostart latch	606	0.00		0
JS mem alloc latch	69	0.00		0
JS queue access latch	77	0.00		0
JS queue state obj latch	208,960	0.00		0
JS slv state obj latch	8,928	0.00		0
KFC FX Hash Latch	8	0.00		0
KFC Hash Latch	8	0.00		0
KFCL LE Freelist	8	0.00		0
KGNFS-NFS:SHM structure	8	0.00		0
KGNFS-NFS:SVR LIST	8	0.00		0
KJC message pool free list	8	0.00		0
KJCT flow control latch	8	0.00		0
KMG MMAN ready and startup request latch	9,606	0.00		0
KTF sga latch	148	0.00		8,772	0.00
KWQMN job cache list latch	4	0.00		0
KWQP Prop Status	16	0.00		0
KWQS pqsubs latch	20	0.00		0
KWQS pqueue ctx latch	608	0.00		0
Locator state objects pool parent latch	8	0.00		0
Lsod array latch	8	0.00		0
MQL Tracking Latch	0			576	0.00
Memory Management Latch	8	0.00		9,606	0.00
Memory Queue	8	0.00		0
Memory Queue Message Subscriber #1	8	0.00		0
Memory Queue Message Subscriber #2	8	0.00		0
Memory Queue Message Subscriber #3	8	0.00		0
Memory Queue Message Subscriber #4	8	0.00		0
Memory Queue Subscriber	8	0.00		0
MinActiveScn Latch	160	0.00		0
Mutex	8	0.00		0
Mutex Stats	8	0.00		0
OS process	11,606	0.00		0
OS process allocation	17,336	0.00		0
OS process: request allocation	2,943	0.00		0
PL/SQL warning settings	3,849	0.00		0
PX hash array latch	8	0.00		0
QMT	8	0.00		0
Real-time plan statistics latch	53,675	0.00		0
SGA blob parent	8	0.00		0
SGA bucket locks	8	0.00		0
SGA heap locks	8	0.00		0
SGA pool locks	8	0.00		0
SQL memory manager latch	968	0.00		9,602	0.00
SQL memory manager workarea list latch	651,166	0.00		0
Shared B-Tree	2,705	0.00		0
Streams Generic	8	0.00		0
Testing	8	0.00		0
Token Manager	8	0.00		0
WCR: sync	8	0.00		0
Write State Object Pool Parent Latch	8	0.00		0
X$KSFQP	8	0.00		0
XDB NFS Security Latch	8	0.00		0
XDB unused session pool	8	0.00		0
XDB used session pool	8	0.00		0
active checkpoint queue latch	23,208	0.00		0
active service list	66,666	0.00	0.00	15,578	0.00
buffer pool	8	0.00		0
business card	8	0.00		0
cache buffer handles	1,944	0.00		0
cache buffers chains	1,293,605	0.00	0.00	10,549	0.00
cache buffers lru chain	9,651	0.00		17,680	0.00
cache table scan latch	1	0.00		1	0.00
call allocation	9,376	0.00		0
cas latch	8	0.00		0
change notification client cache latch	8	0.00		0
channel handle pool latch	3,210	0.00		0
channel operations parent latch	146,347	0.00		0
checkpoint queue latch	3,183,120	0.00		9,060	0.00
client/application info	15,636	0.00		0
compile environment latch	2,100	0.00		0
corrupted undo seg latch	7	0.00		0
cp cmon/server latch	8	0.00		0
cp pool latch	8	0.00		0
cp server hash latch	8	0.00		0
cp sga latch	503	0.00		0
cvmap freelist lock	8	0.00		0
database property service latch	6	0.00		0
deferred cleanup latch	503	0.00		0
dml lock allocation	503	0.00		0
done queue latch	8	0.00		0
dummy allocation	4,209	0.00		0
enqueue hash chains	526,918	0.00		0
enqueues	484,225	0.00	0.00	0
fifth spare latch	8	0.00		0
file cache latch	1,671	0.00		0
flashback copy	8	0.00		0
gc element	8	0.00		0
gcs commit scn state	8	0.00		0
gcs partitioned table hash	8	0.00		0
gcs pcm hashed value bucket hash	8	0.00		0
gcs resource freelist	8	0.00		0
gcs resource hash	8	0.00		0
gcs resource scan list	8	0.00		0
gcs shadows freelist	8	0.00		0
ges domain table	8	0.00		0
ges enqueue table freelist	8	0.00		0
ges group table	8	0.00		0
ges process hash list	8	0.00		0
ges process parent latch	8	0.00		0
ges resource hash list	8	0.00		0
ges resource scan list	8	0.00		0
ges resource table freelist	8	0.00		0
ges value block free list	8	0.00		0
global KZLD latch for mem in SGA	274	0.00		0
global tx hash mapping	8	0.00		0
granule operation	8	0.00		0
hash table column usage latch	66	0.00		40	0.00
hash table modification latch	662	0.00		0
heartbeat check	8	0.00		0
intra txn parallel recovery	8	0.00		0
io pool granule metadata list	8	0.00		0
job workq parent latch	637	0.00		629	0.32
job_queue_processes free list latch	1,301	0.00		0
job_queue_processes parameter latch	6,883	0.00		0
k2q lock allocation	8	0.00		0
kdlx hb parent latch	8	0.00		0
kgb parent	8	0.00		0
kks stats	50	0.00		0
kmcptab latch	3	0.00		0
kmcpvec latch	0			1	0.00
kokc descriptor allocation latch	4,104	0.00		0
ksfv messages	8	0.00		0
kss move lock	458	0.00		0
ksuosstats global area	1,945	0.00		0
ksv allocation latch	1,403	0.00		0
ksv class latch	908	0.00		0
ksv msg queue latch	8	0.00		0
ksz_so allocation latch	2,943	0.00		0
ktm global data	148	0.00		0
kwqbsn:qsga	1,045	0.00		0
lgwr LWN SCN	13,135	0.00		0
list of block allocation	2,162	0.00		0
loader state object freelist	2	0.00		0
lob segment dispenser latch	8	0.00		0
lob segment hash table latch	104	0.00		0
lob segment query latch	8	0.00		0
lock DBA buffer during media recovery	8	0.00		0
logical standby cache	8	0.00		0
logminer context allocation	16	0.00		0
logminer work area	8	0.00		0
longop free list parent	8	0.00		0
mapped buffers lru chain	8	0.00		0
message pool operations parent latch	1,230	0.00		0
messages	289,560	0.00	1.00	0
mostly latch-free SCN	13,135	0.00		0
msg queue latch	8	0.00		0
multiblock read objects	90	0.00		0
name-service namespace bucket	8	0.00		0
ncodef allocation latch	503	0.00		0
object queue header heap	1,725	0.00		259	0.00
object queue header operation	39,233	0.00		0
object stats modification	19	0.00		0
parallel query alloc buffer	3,536	0.00		0
parallel query stats	8	0.00		0
parameter list	2,370	0.00		0
parameter table management	4,223	0.00		0
peshm	8	0.00		0
pesom_free_list	46,548	0.00		0
pesom_hash_node	63,828	0.01	0.00	0
pesom_heap_alloc	560	0.18	0.00	0
post/wait queue	1,472	0.00		944	0.00
process allocation	4,140	0.00		1,471	0.00
process group creation	2,943	0.00		0
process queue	8	0.00		0
process queue reference	8	0.00		0
qmn task queue latch	6,246	0.00		0
query server freelists	8	0.00		0
queued dump request	96	0.00		0
queuing load statistics	8	0.00		0
recovery domain hash list	8	0.00		0
redo allocation	51,500	0.01	1.00	27,931	0.01
redo copy	8	0.00		27,932	0.70
redo writing	59,461	0.00		0
resmgr group change latch	3,568	0.00		0
resmgr:active threads	5,772	0.02	1.00	1,194	0.00
resmgr:actses change group	1,211	0.00		0
resmgr:actses change state	33	0.00		0
resmgr:free threads list	4,251	0.00		0
resmgr:method mem alloc latch	4	0.00		0
resmgr:resource group CPU method	776	0.00		0
resmgr:schema config	2,155	0.00		119	0.00
rm cas latch	8	0.00		0
row cache objects	410,908	0.03	0.01	0
rules engine aggregate statistics	4	0.00		0
rules engine rule set statistics	808	0.00		0
second spare latch	8	0.00		0
sequence cache	2,878	0.00		0
session allocation	11,202	0.00		3,725	0.00
session idle bit	19,912	0.00		0
session queue latch	8	0.00		0
session state list latch	4,980	0.00		0
session switching	8,877	0.00		0
session timer	10,558	0.00		0
shared pool	146,229	0.01	0.00	0
shared pool sim alloc	8	0.00		0
shared pool simulator	80	0.00		0
sim partition latch	8	0.00		0
simulator hash latch	36,541	0.00		0
simulator lru latch	3,643	0.00		32,696	0.00
sort extent pool	893	0.00		0
space background state object latch	78	0.00		0
space background task latch	21,378	0.00		19,208	0.00
state object free list	16	0.00		0
statistics aggregation	4,480	0.00		0
tablespace key chain	8	0.00		0
temp lob duration state obj allocation	16	0.00		0
temporary table state object allocation	2	0.00		0
test excl. parent l0	8	0.00		0
test excl. parent2 l0	8	0.00		0
third spare latch	8	0.00		0
threshold alerts latch	1,281	0.00		0
transaction allocation	6,990	0.00		0
undo global data	28,567	0.00		0
virtual circuit buffers	8	0.00		0
virtual circuit holder	8	0.00		0
virtual circuit queues	8	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
row cache objects	410,908	123	1	122
JOX JIT latch	102	53	53	0
redo allocation	51,500	5	5	0
JS Sh mem access	58	4	4	0
messages	289,560	1	1	0
resmgr:active threads	5,772	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
JS Sh mem access	jsksGetShMemLatch	4	4
PC and Classifier lists for WLM	No latch	53	53
messages	ksaamb: after wakeup	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	5	0
resmgr:active threads	kgsksimsetup1	1	0
row cache objects	kqreqd	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kglpin1 4	5,270	66

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: 595,440
Captured Segments account for 83.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_SYSAUTH1	INDEX	144,448	24.26
SYS	SYSAUX	WRH$_SEG_STAT_OBJ_PK	INDEX	47,312	7.95
SYS	SYSTEM	I_OBJ2	INDEX	39,136	6.57
SYS	SYSTEM	JOB$	TABLE	32,448	5.45
SYS	SYSTEM	I_OBJ#	INDEX	22,672	3.81

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 2,570
Captured Segments account for 92.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	TYPE$	TABLE	2,159	84.01
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY	TABLE	56	2.18
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY_INDEX	INDEX	51	1.98
SYS	SYSTEM	OBJ$	TABLE	30	1.17
SYS	SYSAUX	WRH$_SYSMETRIC_SUMMARY	TABLE	16	0.62

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 2,567
Captured Segments account for 92.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
SYS	SYSTEM	TYPE$	TABLE	2,159	84.11
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY	TABLE	56	2.18
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY_INDEX	INDEX	51	1.99
SYS	SYSTEM	OBJ$	TABLE	30	1.17
SYS	SYSAUX	WRH$_SYSMETRIC_SUMMARY	TABLE	16	0.62

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 2,567
Captured Segments account for 92.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
SYS	SYSTEM	TYPE$	TABLE	2,159	84.11
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY	TABLE	56	2.18
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY_INDEX	INDEX	51	1.99
SYS	SYSTEM	OBJ$	TABLE	30	1.17
SYS	SYSAUX	WRH$_SYSMETRIC_SUMMARY	TABLE	16	0.62

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: 9,223
Captured Segments account for 37.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK		INDEX	979	10.61
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01		INDEX	240	2.60
SYS	SYSAUX	SMON_SCN_TIME		TABLE	195	2.11
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM	WRH$_EVENT__3032207194_1397	TABLE PARTITION	163	1.77
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	WRH$_EVENT__3032207194_1397	INDEX PARTITION	157	1.70

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 6,903
Captured Segments account for 36.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	835	12.10
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01	INDEX	205	2.97
SYS	SYSAUX	SMON_SCN_TIME	TABLE	164	2.38
SYSMAN	SYSAUX	MGMT_METRICS_1HOUR_PK	INDEX	114	1.65
OWBSYS	BODA_DATA	WB_RT_SERVICE_JOB_LOGS	TABLE	96	1.39

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 288
Captured Segments account for 99.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_SYSAUTH1		INDEX	242	84.03
SYS	SYSTEM	I_OBJ2		INDEX	43	14.93

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01	INDEX	1,392	13.47
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_02	INDEX	1,104	10.68
SYS	SYSTEM	I_JOB_NEXT	INDEX	832	8.05
SYSMAN	SYSAUX	MGMT_CURRENT_METRICS_PK	INDEX	752	7.28
SYS	SYSAUX	WRH$_SYSMETRIC_HISTORY_INDEX	INDEX	704	6.81

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
SYS	SYSAUX	SMON_SCN_TIME_TIM_IDX		INDEX	2	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
SYS	SYSTEM	JOB$		TABLE	4	100.00

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	515	0.00	16	1
dc_files	64	0.00	0	8
dc_global_oids	3,432	0.00	0	229
dc_histogram_defs	16	0.00	0	5,274
dc_objects	8,931	0.09	48	5,357
dc_profiles	924	0.00	0	1
dc_rollback_segments	15,446	0.00	0	46
dc_segments	146	0.00	35	2,752
dc_sequences	5	20.00	5	13
dc_tablespaces	5,214	0.00	0	11
dc_users	85,662	0.00	0	171
global database name	22,199	0.00	0	1
outstanding_alerts	308	0.65	4	7
sch_lj_oids	44	0.00	0	22

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	9,154	0.00	12,823	0.00	0	0
DBLINK	564	0.00	0		0	0
EDITION	2,204	0.00	3,103	0.00	0	0
JAVA DATA	240	0.00	0		0	0
QUEUE	502	0.00	1,761	0.00	0	0
RULESET	4	0.00	4	0.00	0	0
SCHEMA	1,177	0.00	0		0	0
SQL AREA	13,999	0.17	145,548	0.24	160	160
SUBSCRIPTION	48	0.00	48	0.00	0	0
TABLE/PROCEDURE	830,919	0.00	846,059	0.00	0	0
TRIGGER	48	0.00	493	0.00	0	0

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	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	352.00	352.00	352.00	704.00	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	576.00	576.00	576.00	576.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	1,072.00	1,072.00	1,072.00	1,072.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	32.00	32.00	32.00	32.00	STA/
large pool	16.00	16.00	16.00	16.00	STA/
shared pool	624.00	624.00	272.00	624.00	GRO/DEF
streams pool	32.00	32.00	16.00	32.00	GRO/IMM

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	Freeable	78.69	0.00	3.75	7.74	34		21	21
	Other	69.22		1.77	2.16	12	41	39	39
	PL/SQL	3.02	2.13	0.08	0.17	1	2	37	37
	JAVA	2.37	2.36	2.37	0.00	2	3	1	1
	SQL	0.66	0.18	0.03	0.04	0	8	23	17
E	Freeable	79.19	0.00	3.77	7.73	34		21	21
	Other	71.11		1.87	2.18	12	41	38	38
	PL/SQL	3.04	2.15	0.08	0.17	1	2	36	36
	JAVA	2.37	2.36	1.18	1.67	2	5	2	2
	SQL	0.66	0.18	0.03	0.04	0	8	24	17

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	369,098,752
Fixed Size	2,207,488
Redo Buffers	6,844,416
Variable Size	1,342,177,536

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	JOXLE	22.21	22.21	0.00
java	free memory	8.80	8.80	0.00
java	joxs heap	0.99	0.99	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	8.19	8.19	0.00
shared	ASH buffers	13.60	13.60	0.00
shared	CCUR	44.20	44.24	0.10
shared	FileOpenBlock	11.19	11.19	0.00
shared	KGLH0	11.95	11.95	0.00
shared	KGLHD	20.09	20.10	0.03
shared	KGLS	14.98	14.98	0.00
shared	PCUR	47.01	47.04	0.05
shared	PLMCD	12.21	12.21	0.00
shared	SQLA	203.49	203.48	-0.01
shared	XDBSC	9.55	9.55	0.00
shared	dbwriter coalesce buffer	8.01	8.01	0.00
shared	free memory	94.90	95.27	0.40
shared	kglsim object batch	9.75	9.75	0.00
shared	row cache	7.23	7.23	0.00
streams	KGH: NO ACCESS	15.99	15.99	0.00
streams	KTG hash buckets	0.63	0.63	0.00
streams	Sender info	0.88	0.88	0.00
streams	free memory	31.21	31.21	0.00
	buffer_cache	352.00	352.00	0.00
	fixed_sga	2.11	2.11	0.00
	log_buffer	6.53	6.53	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by Foreground CPU Time, descending

Session Type	First Logon	Foreground CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	1101 09:55:32	0.14	0.00	0.00
QMON Coordinator	1101 09:55:22	0.11	0.00	0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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

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

Back to Streams Statistics
Back to Top

Persistent Queues

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

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(12343)	4	0	100.00	0.00	0.00	0.00	0.00	24.34
SYS.AQ$_ALERT_QT_E(12342)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(79788)	508	508	0.00	0.00	0.08	0.53	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

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

Queue Name	Enqueue Msgs/sec	Dequeue Msgs/sec	Avg Enqueue sec / msg	Avg Dequeue sec / msg
SYS.ALERT_QUE(12343)	0.00	0.00	0.00
SYS.AQ$_ALERT_QT_E(12342)	0.00	0.00
SYSMAN.MGMT_TASK_Q(79788)	0.02	0.02	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

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

Subscriber/Queue	Enqueue Msgs	Dequeue Msgs	Expire Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE	0	0	0
ORACLEVM02_1830_BDLMS(41)/SYS.ALERT_QUE	4	0	0	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Shared Server Statistics

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

Shared Servers Activity

Values represent averages for all samples

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

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

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
28,816	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

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

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

Back to Shared Server Statistics
Back to Top

init.ora Parameters

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

Parameter Name	Begin value	End value (if different)
audit_file_dest	/home/oracle/db/oracle/admin/bdlms/adump
audit_trail	DB
compatible	11.2.0.0.0
control_files	/home/oracle/db/oracle/oradata/bdlms/control01.ctl, /home/oracle/db/oracle/flash_recovery_area/bdlms/control02.ctl
db_block_size	8192
db_domain
db_name	bdlms
db_recovery_file_dest	/home/oracle/db/oracle/flash_recovery_area
db_recovery_file_dest_size	4039114752
diagnostic_dest	/home/oracle/db/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=bdlmsXDB)
job_queue_processes	1000
memory_target	1728053248
open_cursors	300
processes	150
remote_login_passwordfile	EXCLUSIVE
resource_manager_plan	SCHEDULER[0x3006]:DEFAULT_MAINTENANCE_PLAN
undo_tablespace	BODAUNDO

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.57	In-memory Sort %:	100.00
Library Hit %:	99.97	Soft Parse %:	99.72
Execute to Parse %:	36.64	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	6.04	% Non-Parse CPU:	99.55