WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

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

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

Host Name Platform CPUs Cores Sockets Memory (GB)

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

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 680 18-Sep-09 02:02:47 28 1.3

End Snap: 681 18-Sep-09 02:24:57 28 1.5

Elapsed: 22.17 (mins)

DB Time: 255.74 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	680	18-Sep-09 02:02:47	28	1.3
End Snap:	681	18-Sep-09 02:24:57	28	1.5
Elapsed:		22.17 (mins)
DB Time:		255.74 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 11.5 0.0 0.02 0.01

DB CPU(s): 1.5 0.0 0.00 0.00

Redo size: 291,222.2 509.7

Logical reads: 3,240.4 5.7

Block changes: 2,358.9 4.1

Physical reads: 1.5 0.0

Physical writes: 13.5 0.0

User calls: 1,291.4 2.3

Parses: 686.1 1.2

Hard parses: 0.2 0.0

W/A MB processed: 0.0 0.0

Logons: 7.5 0.0

Executes: 681.1 1.2

Rollbacks: 0.0 0.0

Transactions: 571.3

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	11.5	0.0	0.02	0.01
DB CPU(s):	1.5	0.0	0.00	0.00
Redo size:	291,222.2	509.7
Logical reads:	3,240.4	5.7
Block changes:	2,358.9	4.1
Physical reads:	1.5	0.0
Physical writes:	13.5	0.0
User calls:	1,291.4	2.3
Parses:	686.1	1.2
Hard parses:	0.2	0.0
W/A MB processed:	0.0	0.0
Logons:	7.5	0.0
Executes:	681.1	1.2
Rollbacks:	0.0	0.0
Transactions:	571.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 96.84 Redo NoWait %: 100.00

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

Library Hit %: 100.06 Soft Parse %: 99.97

Execute to Parse %: -0.73 Latch Hit %: 99.28

Parse CPU to Parse Elapsd %: 30.82 % Non-Parse CPU: 97.24

Shared Pool Statistics

Begin End

Memory Usage %: 92.90 92.74

% SQL with executions>1: 63.52 75.94

% Memory for SQL w/exec>1: 51.11 56.44

	Begin	End
Memory Usage %:	92.90	92.74
% SQL with executions>1:	63.52	75.94
% Memory for SQL w/exec>1:	51.11	56.44

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
log file sync	774,852	10,582	14	68.97	Commit
DB CPU		2,012		13.11
buffer busy waits	120,327	996	8	6.49	Concurrency
latch: In memory undo latch	118,995	762	6	4.97	Concurrency
latch: cache buffers chains	10,247	66	6	0.43	Concurrency

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

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

0.16 12.55 60.5 35.7 1.3 3.6

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.16	12.55	60.5	35.7	1.3	3.6

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

77.7 80.6 0.0

Memory Statistics

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

Begin End

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

SGA use (MB): 171.6 171.6

PGA use (MB): 45.3 47.6

% Host Mem used for SGA+PGA: 10.71 10.82

	Begin	End
Host Mem (MB):	2,025.4	2,025.4
SGA use (MB):	171.6	171.6
PGA use (MB):	45.3	47.6
% Host Mem used for SGA+PGA:	10.71	10.82

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): 15344.1s
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	2,722.03	17.74
DB CPU	2,011.55	13.11
connection management call elapsed time	660.65	4.31
parse time elapsed	205.64	1.34
hard parse elapsed time	4.53	0.03
hard parse (sharing criteria) elapsed time	1.35	0.01
PL/SQL execution elapsed time	0.38	0.00
repeated bind elapsed time	0.20	0.00
sequence load elapsed time	0.02	0.00
PL/SQL compilation elapsed time	0.02	0.00
DB time	15,344.10
background elapsed time	1,372.70
background cpu time	54.43

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
BUSY_TIME	256,300
IDLE_TIME	9,532
IOWAIT_TIME	3,366
NICE_TIME	0
SYS_TIME	94,803
USER_TIME	160,907
LOAD	0	13
PHYSICAL_MEMORY_BYTES	2,123,755,520
NUM_CPUS	2
NUM_CPU_CORES	1
NUM_CPU_SOCKETS	1
GLOBAL_RECEIVE_SIZE_MAX	524,288
GLOBAL_SEND_SIZE_MAX	524,288
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	174,760
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	131,072
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
18-Sep 02:02:47	0.16
18-Sep 02:24:57	12.55	96.41	60.53	35.66	3.59	1.27

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 95.4% of Total DB time 15,344.10 (s)
Total FG Wait Time: 12,630.87 (s) DB CPU time: 2,011.55 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Commit	774,852	0	10,582	14	68.97
DB CPU			2,012		13.11
Concurrency	251,649	0	1,913	8	12.47
Other	8,878	0	73	8	0.48
Application	6,233	0	46	7	0.30
Network	877,814	0	8	0	0.06
User I/O	9,214	0	6	1	0.04
Configuration	44	0	1	24	0.01
System I/O	81	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
log file sync	774,852	0	10,582	14	1.02	68.97
buffer busy waits	120,327	0	996	8	0.16	6.49
latch: In memory undo latch	118,995	0	762	6	0.16	4.97
latch: cache buffers chains	10,247	0	66	6	0.01	0.43
cursor: pin S	1,284	0	63	49	0.00	0.41
enq: TX - row lock contention	6,233	0	46	7	0.01	0.30
latch: enqueue hash chains	4,797	0	37	8	0.01	0.24
latch: session allocation	2,298	0	24	10	0.00	0.16
library cache: mutex X	371	0	20	54	0.00	0.13
latch free	1,513	0	11	7	0.00	0.07
SQL*Net message to client	877,814	0	8	0	1.16	0.06
Disk file operations I/O	8,045	0	6	1	0.01	0.04
latch: row cache objects	245	0	4	15	0.00	0.02
latch: shared pool	130	0	2	12	0.00	0.01
latch: undo global data	197	0	1	6	0.00	0.01
cursor: pin S wait on X	47	0	1	23	0.00	0.01
log file switch (checkpoint incomplete)	20	0	1	26	0.00	0.00
cursor: mutex S	3	100	0	139	0.00	0.00
log file switch (private strand flush incomplete)	15	0	0	26	0.00	0.00
wait list latch free	19	0	0	13	0.00	0.00
latch: redo allocation	27	0	0	8	0.00	0.00
enq: HW - contention	7	0	0	17	0.00	0.00
latch: messages	15	0	0	7	0.00	0.00
direct path write temp	51	0	0	1	0.00	0.00
db file sequential read	1,090	0	0	0	0.00	0.00
direct path sync	1	0	0	34	0.00	0.00
log file switch completion	2	0	0	15	0.00	0.00
latch: Change Notification Hash table latch	2	0	0	11	0.00	0.00
control file sequential read	81	0	0	0	0.00	0.00
SQL*Net message from client	877,814	0	7,693	9	1.16
jobq slave wait	120	100	61	507	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	184,060	0	472	3	0.24	34.39
db file async I/O submit	395	0	105	267	0.00	7.67
control file parallel write	804	0	9	12	0.00	0.69
LGWR wait for redo copy	2,310	0	8	4	0.00	0.61
os thread startup	7	0	4	591	0.00	0.30
latch: redo allocation	255	0	1	5	0.00	0.09
db file single write	66	0	1	17	0.00	0.08
latch free	84	0	1	12	0.00	0.07
latch: call allocation	80	0	1	12	0.00	0.07
asynch descriptor resize	10,009	100	1	0	0.01	0.04
latch: shared pool	36	0	0	12	0.00	0.03
direct path sync	1	0	0	356	0.00	0.03
latch: session allocation	32	0	0	11	0.00	0.03
SQL*Net message to client	30,000	0	0	0	0.04	0.02
control file sequential read	2,007	0	0	0	0.00	0.02
latch: messages	19	0	0	8	0.00	0.01
log file single write	46	0	0	3	0.00	0.01
db file sequential read	273	0	0	0	0.00	0.01
log file sync	2	0	0	32	0.00	0.00
db file scattered read	90	0	0	1	0.00	0.00
latch: row cache objects	1	0	0	52	0.00	0.00
latch: enqueue hash chains	3	0	0	16	0.00	0.00
latch: cache buffers chains	2	0	0	22	0.00	0.00
latch: redo writing	1	0	0	21	0.00	0.00
Disk file operations I/O	18	0	0	1	0.00	0.00
latch: In memory undo latch	2	0	0	5	0.00	0.00
latch: Change Notification Hash table latch	1	0	0	3	0.00	0.00
log file sequential read	46	0	0	0	0.00	0.00
direct path write	5	0	0	0	0.00	0.00
rdbms ipc message	28,804	18	15,074	523	0.04
EMON slave idle wait	1,325	100	6,661	5027	0.00
DIAG idle wait	2,600	100	2,657	1022	0.00
Streams AQ: emn coordinator idle wait	133	100	1,334	10030	0.00
pmon timer	484	91	1,329	2746	0.00
Space Manager: slave idle wait	265	99	1,328	5013	0.00
Streams AQ: qmn coordinator idle wait	84	56	1,318	15691	0.00
Streams AQ: qmn slave idle wait	48	0	1,318	27457	0.00
smon timer	4	100	1,200	300065	0.00
SQL*Net message from client	40,000	0	247	6	0.05
PL/SQL lock timer	3	67	60	20010	0.00
class slave wait	5	0	0	3	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
Disk file operations I/O	8063	93.3	2.5	2.6	1.2	.3	.0	.0
LGWR wait for redo copy	2310	45.5	11.0	15.4	14.5	11.0	2.3	.3
SQL*Net message to client	907.8K	99.9	.0	.0	.0	.0	.0	.0
asynch descriptor resize	10K	99.7	.1	.0	.2	.0	.1
buffer busy waits	120.3K	6.5	7.0	17.1	33.7	26.5	8.0	1.1
control file parallel write	803	26.7	8.5	10.2	10.6	18.7	20.4	5.0
control file sequential read	2087	99.4	.1	.1		.2	.1	.1
cursor: mutex S	3							100.0
cursor: pin S	1284	.7	1.6	8.1	16.3	20.1	17.1	36.1
cursor: pin S wait on X	47					27.7	63.8	8.5
db file async I/O submit	394	1.0	.8	1.3	2.8	4.8	8.1	80.5	.8
db file scattered read	105	99.0						1.0
db file sequential read	1356	99.7			.1		.1	.1
db file single write	66	15.2	4.5	7.6	13.6	22.7	31.8	4.5
direct path read temp	9	100.0
direct path sync	2							100.0
direct path write	8	100.0
direct path write temp	51	72.5	13.7	7.8	5.9
enq: HW - contention	7		28.6		14.3		42.9	14.3
enq: TX - row lock contention	6233	11.8	12.4	22.9	27.2	17.1	7.3	1.5
latch free	1597	4.7	8.0	19.5	33.1	27.9	5.8	.9
latch: Change Notification Hash table latch	3			33.3		66.7
latch: In memory undo latch	119K	18.1	8.1	18.0	30.3	19.3	5.3	.8
latch: cache buffers chains	10.2K	11.6	9.5	20.7	32.8	20.2	4.8	.4
latch: call allocation	80	7.5	5.0	10.0	23.8	27.5	20.0	6.3
latch: enqueue hash chains	4800	3.4	10.7	22.9	35.1	21.9	5.3	.7
latch: messages	34	5.9	8.8	17.6	32.4	29.4	5.9
latch: redo allocation	282	16.3	25.2	24.1	18.8	12.1	3.2	.4
latch: redo writing	1						100.0
latch: row cache objects	246	9.3	1.6	8.1	11.4	33.3	29.3	6.9
latch: session allocation	2330	1.7	4.0	13.0	29.4	44.7	6.2	.9
latch: shared pool	166	5.4	3.0	16.3	16.9	32.5	23.5	2.4
latch: undo global data	197	19.3	21.3	26.4	14.7	14.2	3.0	1.0
library cache: mutex X	371	7.0	1.9	4.6	7.5	11.3	22.1	45.6
log file parallel write	184.1K	63.3	9.4	10.4	7.5	6.8	2.4	.2
log file sequential read	46	100.0
log file single write	46	47.8	10.9	10.9	23.9	4.3	2.2
log file switch (checkpoint incomplete)	20					25.0	55.0	20.0
log file switch (private strand flush incomplete)	15					26.7	53.3	20.0
log file switch completion	2					50.0	50.0
log file sync	774.9K	.1	.4	5.5	26.2	44.0	21.2	2.6	.0
os thread startup	7							85.7	14.3
wait list latch free	19					100.0
DIAG idle wait	2597							93.3	6.7
EMON slave idle wait	1320								100.0
PL/SQL lock timer	3	33.3							66.7
SQL*Net message from client	917.8K	13.0	3.6	14.2	35.1	29.7	3.8	.5	.0
Space Manager: slave idle wait	265								100.0
Streams AQ: emn coordinator idle wait	133								100.0
Streams AQ: qmn coordinator idle wait	84	11.9	2.4			6.0	13.1	10.7	56.0
Streams AQ: qmn slave idle wait	48	2.1							97.9
class slave wait	5	60.0			40.0
jobq slave wait	120							100.0
pmon timer	483	4.3						3.7	91.9
rdbms ipc message	28.8K	40.1	5.3	9.0	12.1	13.0	2.5	4.7	13.3
smon timer	4								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	<2s
		% of Total Waits
Disk file operations I/O	2	100.0		.0	.0
LGWR wait for redo copy	7	99.7	.2		.0	.1
SQL*Net message to client	12	100.0	.0	.0
buffer busy waits	1313	98.9	.8	.1	.1	.1	.0
control file parallel write	40	95.0	3.9	.5	.2	.4
control file sequential read	2	99.9	.1
cursor: mutex S	3		33.3		66.7
cursor: pin S	464	63.9	15.0	13.2	3.8	3.6	.5
cursor: pin S wait on X	4	91.5	8.5
db file async I/O submit	320	18.8	6.6	9.6	21.3	30.2	12.7	.8
db file scattered read	1	99.0	1.0
db file sequential read	1	99.9	.1
db file single write	3	95.5	1.5	1.5	1.5
direct path sync	2		50.0			50.0
enq: HW - contention	1	85.7	14.3
enq: TX - row lock contention	92	98.5	1.0	.1	.2	.1
latch free	15	99.1	.8	.1
latch: In memory undo latch	957	99.2	.6	.1	.0	.1
latch: cache buffers chains	44	99.6	.3	.0		.1
latch: call allocation	5	93.8	6.3
latch: enqueue hash chains	35	99.3	.3	.1		.3
latch: redo allocation	1	99.6				.4
latch: row cache objects	17	93.1	6.9
latch: session allocation	22	99.1	.3	.2	.0	.4
latch: shared pool	4	97.6	2.4
latch: undo global data	2	99.0	.5		.5
library cache: mutex X	169	54.4	22.9	12.4	7.3	2.4	.5
log file parallel write	458	99.8	.1	.0	.0	.1	.0
log file switch (checkpoint incomplete)	4	80.0	20.0
log file switch (private strand flush incomplete)	3	80.0	20.0
log file sync	20.2K	97.4	2.1	.1	.1	.3	.0	.0
os thread startup	7				14.3	28.6	42.9	14.3

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	15,346	2,013	1	4,304
SYS$BACKGROUND	0	0	1	8
linuxs.regress.rdbms.dev.us.oracle.com	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	9214	7	251647	1913	0	0	877814	8
SYS$BACKGROUND	453	2	15	4	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 17.3% of Total DB Time (s): 15,344
Captured PL/SQL account for 0.0% of Total DB Time (s): 15,344

Elapsed Time (s)	Executions	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,436.74	800,000	15.88	16.55	0.25	b6vvz2u69xdma	stage6@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
41.84	10,000	0.27	43.72	0.66	4vs91dcv7u1p6	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
36.35	10,000	0.24	30.26	0.00	087hdmn8v6ur7	stage1@stadf26 (TNS V1-V3)	select empno, ename from myemp...
26.98	10,002	0.18	48.53	0.00	0k8522rmdzg4k		select privilege# from sysauth...
21.20	20,040	0.14	45.24	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
20.67	10,000	0.13	38.88	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
16.28	10,000	0.11	40.89	0.00	459f3z9u4fb3u		select value$ from props$ wher...
14.15	10,000	0.09	36.96	0.01	9whcc4w2ws87n	stage6@stadf26 (TNS V1-V3)	select region_id, region_name ...
13.62	10,000	0.09	49.35	0.41	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
11.85	10,000	0.08	39.06	0.00	5ur69atw3vfhj		select decode(failover_method,...

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 24.3% of Total CPU Time (s): 2,012
Captured PL/SQL account for 0.2% of Total CPU Time (s): 2,012

CPU Time (s)	Executions	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
403.26	800,000	20.05	2,436.74	16.55	0.25	b6vvz2u69xdma	stage6@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
18.29	10,000	0.91	41.84	43.72	0.66	4vs91dcv7u1p6	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
13.09	10,002	0.65	26.98	48.53	0.00	0k8522rmdzg4k		select privilege# from sysauth...
11.00	10,000	0.55	36.35	30.26	0.00	087hdmn8v6ur7	stage1@stadf26 (TNS V1-V3)	select empno, ename from myemp...
9.59	20,040	0.48	21.20	45.24	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
8.03	10,000	0.40	20.67	38.88	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
6.72	10,000	0.33	13.62	49.35	0.41	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
6.66	10,000	0.33	16.28	40.89	0.00	459f3z9u4fb3u		select value$ from props$ wher...
5.23	10,000	0.26	14.15	36.96	0.01	9whcc4w2ws87n	stage6@stadf26 (TNS V1-V3)	select region_id, region_name ...
4.63	10,000	0.23	11.85	39.06	0.00	5ur69atw3vfhj		select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
6.00	800,000	0.00	73.97	2,436.74	16.55	0.25	b6vvz2u69xdma	stage6@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
0.39	2	0.20	4.87	1.12	17.80	35.31	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...
0.28	10,000	0.00	3.39	41.84	43.72	0.66	4vs91dcv7u1p6	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
0.24	1	0.24	2.95	0.29	20.87	83.31	5dfmd823r8dsp		insert into wrh$_memory_resize...
0.11	1	0.11	1.33	1.84	94.47	5.89	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
0.07	1	0.07	0.81	2.04	5.43	3.20	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
0.06	10,000	0.00	0.70	13.62	49.35	0.41	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
0.05	0		0.56	1.52	96.47	2.98	48jvprb98hg2c	sqlplus@stadf26 (TNS V1-V3)	begin :eid := DBMS_WORKLOAD_RE...
0.03	1	0.03	0.37	0.49	91.75	6.12	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.01	1	0.01	0.13	0.17	35.53	6.32	gkqrnt9wwp6fp	MMON_SLAVE	select regid, username, locati...

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: 4,310,544
Captured SQL account for 81.6% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
3,203,690	800,000	4.00	74.32	2,436.74	16.55	0.25	b6vvz2u69xdma	stage6@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
50,048	10,002	5.00	1.16	26.98	48.53	0.00	0k8522rmdzg4k		select privilege# from sysauth...
44,786	10,000	4.48	1.04	36.35	30.26	0.00	087hdmn8v6ur7	stage1@stadf26 (TNS V1-V3)	select empno, ename from myemp...
40,148	20,040	2.00	0.93	21.20	45.24	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
40,000	10,000	4.00	0.93	16.28	40.89	0.00	459f3z9u4fb3u		select value$ from props$ wher...
31,287	10,000	3.13	0.73	41.84	43.72	0.66	4vs91dcv7u1p6	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
31,069	10,000	3.11	0.72	13.62	49.35	0.41	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
30,024	10,000	3.00	0.70	14.15	36.96	0.01	9whcc4w2ws87n	stage6@stadf26 (TNS V1-V3)	select region_id, region_name ...
30,000	10,000	3.00	0.70	11.85	39.06	0.00	5ur69atw3vfhj		select decode(failover_method,...
10,941	1	10,941.00	0.25	1.84	94.47	5.89	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...

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: 1,992
Captured SQL account for 66.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
665	1	665.00	33.38	1.84	94.47	5.89	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
588	1	588.00	29.52	2.04	5.43	3.20	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
438	0		21.99	1.52	96.47	2.98	48jvprb98hg2c	sqlplus@stadf26 (TNS V1-V3)	begin :eid := DBMS_WORKLOAD_RE...
279	1	279.00	14.01	0.49	91.75	6.12	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
63	1	63.00	3.16	0.29	20.87	83.31	5dfmd823r8dsp		insert into wrh$_memory_resize...
50	659	0.08	2.51	0.10	70.35	2.83	96g93hntrzjtr		select /+ rule / bucket_cnt,...
44	1	44.00	2.21	0.01	97.42	4.62	6wm3n4d7bnddg		SELECT source, (case when tim...
39	1	39.00	1.96	0.11	100.09	0.81	d87cd6s72f197		insert into wrh$_seg_stat (sna...
32	1	32.00	1.61	0.07	100.98	1.20	14wnf35dahb7v		SELECT A.ID, A.TYPE FROM SYS.W...
30	57	0.53	1.51	0.03	77.20	4.23	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
27	172	0.16	1.36	0.03	102.06	2.18	9tgj4g8y4rwy8		select type#, blocks, extents,...
26	632	0.04	1.31	0.62	37.41	0.13	3c1kubcdjnppq		update sys.col_usage$ set equa...
26	5	5.20	1.31	0.10	100.25	0.70	70th7d08hqjf7		SELECT B.TYPE FROM SYS.WRI$_AD...
25	2	12.50	1.26	1.12	17.80	35.31	fdjtrdaz8hpvg		INSERT /*+ APPEND LEADING(@"SE...
21	29	0.72	1.05	0.01	96.36	10.33	3ktacv9r56b51		select owner#, name, namespace...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

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

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
571	571	1	571.00	40.76	2ntzsd2w869g8	sqlplus@stadf26 (TNS V1-V3)	begin :bid := DBMS_WORKLOAD_RE...
498	498	0		35.55	48jvprb98hg2c	sqlplus@stadf26 (TNS V1-V3)	begin :eid := DBMS_WORKLOAD_RE...
129	129	1	129.00	9.21	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...
50	50	659	0.08	3.57	96g93hntrzjtr		select /+ rule / bucket_cnt,...
30	30	1	30.00	2.14	1cq3qr774cu45		insert into WRH$_IOSTAT_FILETY...
30	30	57	0.53	2.14	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
28	28	1	28.00	2.00	14wnf35dahb7v		SELECT A.ID, A.TYPE FROM SYS.W...
27	27	172	0.16	1.93	9tgj4g8y4rwy8		select type#, blocks, extents,...
26	26	632	0.04	1.86	3c1kubcdjnppq		update sys.col_usage$ set equa...
26	26	5	5.20	1.86	70th7d08hqjf7		SELECT B.TYPE FROM SYS.WRI$_AD...
25	25	1	25.00	1.78	9ctt1scmwbmbg		begin dbsnmp.bsln_internal.mai...
21	21	29	0.72	1.50	3ktacv9r56b51		select owner#, name, namespace...
19	19	9	2.11	1.36	130dvvr5s8bgn		select obj#, dataobj#, part#, ...

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: 906,053
Captured SQL account for 99.7% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
800,000	759,998	0.95	2,436.74	16.55	0.25	b6vvz2u69xdma	stage6@stadf26 (TNS V1-V3)	update myemp set sal = :sal wh...
20,040	70	0.00	21.20	45.24	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
10,002	20,040	2.00	26.98	48.53	0.00	0k8522rmdzg4k		select privilege# from sysauth...
10,000	70,165	7.02	36.35	30.26	0.00	087hdmn8v6ur7	stage1@stadf26 (TNS V1-V3)	select empno, ename from myemp...
10,000	10,000	1.00	20.67	38.88	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
10,000	10,000	1.00	16.28	40.89	0.00	459f3z9u4fb3u		select value$ from props$ wher...
10,000	10,000	1.00	41.84	43.72	0.66	4vs91dcv7u1p6	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...
10,000	10,000	1.00	11.85	39.06	0.00	5ur69atw3vfhj		select decode(failover_method,...
10,000	10,000	1.00	14.15	36.96	0.01	9whcc4w2ws87n	stage6@stadf26 (TNS V1-V3)	select region_id, region_name ...
10,000	10,000	1.00	13.62	49.35	0.41	f711myt0q6cma	stage6@stadf26 (TNS V1-V3)	insert into sys.aud$( sessioni...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 912,642
Captured SQL account for 98.3% of Total

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

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

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

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

130dvvr5s8bgn select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#

14wnf35dahb7v SELECT A.ID, A.TYPE FROM SYS.WRI$_ADV_DEFINITIONS A WHERE A.NAME = :B1

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

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

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

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

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

48jvprb98hg2c begin :eid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;

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

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

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

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

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

70th7d08hqjf7 SELECT B.TYPE FROM SYS.WRI$_ADV_TASKS A, SYS.WRI$_ADV_DEFINITIONS B WHERE A.ADVISOR_ID = B.ID AND A.ID = :B1

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

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

9ctt1scmwbmbg begin dbsnmp.bsln_internal.maintain_thresholds; end;

9tgj4g8y4rwy8 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

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

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

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

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

d87cd6s72f197 insert into wrh$_seg_stat (snap_id, dbid, instance_number, ts#, obj#, dataobj#, logical_reads_total, logical_reads_delta, buffer_busy_waits_total, buffer_busy_waits_delta, db_block_changes_total, db_block_changes_delta, physical_reads_total, physical_reads_delta, physical_writes_total, physical_writes_delta, physical_reads_direct_total, physical_reads_direct_delta, physical_writes_direct_total, physical_writes_direct_delta, itl_waits_total, itl_waits_delta, row_lock_waits_total, row_lock_waits_delta, gc_buffer_busy_total, gc_buffer_busy_delta, gc_cr_blocks_received_total, gc_cr_blocks_received_delta, gc_cu_blocks_received_total, gc_cu_blocks_received_delta, space_used_total, space_used_delta, space_allocated_total, space_allocated_delta, table_scans_total, table_scans_delta, chain_row_excess_total, chain_row_excess_delta, physical_read_requests_total, physical_read_requests_delta, physical_write_requests_total, physical_write_requests_delta, optimized_physical_reads_total, optimized_physical_reads_delta) select :snap_id, :dbid, :instance_number, tsn_kewrseg, objn_kewrseg, objd_kewrseg, log_rds_kewrseg, log_rds_dl_kewrseg, buf_busy_wts_kewrseg, buf_busy_wts_dl_kewrseg, db_blk_chgs_kewrseg, db_blk_chgs_dl_kewrseg, phy_rds_kewrseg, phy_rds_dl_kewrseg, phy_wrts_kewrseg, phy_wrts_dl_kewrseg, phy_rds_drt_kewrseg, phy_rds_drt_dl_kewrseg, phy_wrts _drt_kewrseg, phy_wrts_drt_dl_kewrseg, itl_wts_kewrseg, itl_wts_dl_kewrseg, row_lck_wts_kewrseg, row_lck_wts_dl_kewrseg, gc_buf_busy_kewrseg, gc_buf_busy_dl_kewrseg, gc_cr_blks_rcv_kewrseg, gc_cr_blks_rcv_dl_kewrseg, gc_cu_blks_rcv_kewrseg, gc_cu_blks_rcv_dl_kewrseg, space_used_kewrseg, space_used_dl_kewrseg, space_alloc_kewrseg, space_alloc_dl_kewrseg, tbl_scns_kewrseg, tbl_scns_dl_kewrseg, chn_exc_kewrseg, chn_exc_dl_kewrseg, phy_rd_reqs_kewrseg, phy_rd_reqs_dl_kewrseg, phy_wrt_reqs_kewrseg, phy_wrt_reqs_dl_kewrseg, opt_phy_rds_kewrseg, opt_phy_rds_dl_kewrseg from X$KEWRTSEGSTAT order by objn_kewrseg, objd_kewrseg

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

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

gkqrnt9wwp6fp select regid, username, location_name, subscription_name from table(dbms_client_result_cache.cache_cleanup (:flags))

SQL Id	SQL Text
087hdmn8v6ur7	select empno, ename from myemp where empno > :EMPNO order by empno
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
130dvvr5s8bgn	select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#
14wnf35dahb7v	SELECT A.ID, A.TYPE FROM SYS.WRI$_ADV_DEFINITIONS A WHERE A.NAME = :B1
1cq3qr774cu45	insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
2ntzsd2w869g8	begin :bid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
48jvprb98hg2c	begin :eid := DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end;
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
5dfmd823r8dsp	insert into wrh$_memory_resize_ops (snap_id, dbid, instance_number, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status) select snap_id, dbid, instance_num, component, oper_type, start_time, max(end_time), target_size, max(oper_mode), max(parameter), max(initial_size), max(final_size), max(status) from (select :snap_id snap_id, :dbid dbid, :instance_number instance_num, component, oper_type, start_time, end_time, target_size, oper_mode, parameter, initial_size, final_size, status from v$memory_resize_ops where :begin_interval_time <= end_time and end_time < :end_interval_time) group by snap_id, dbid, instance_num, component, oper_type, start_time, target_size
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
70th7d08hqjf7	SELECT B.TYPE FROM SYS.WRI$_ADV_TASKS A, SYS.WRI$_ADV_DEFINITIONS B WHERE A.ADVISOR_ID = B.ID AND A.ID = :B1
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9ctt1scmwbmbg	begin dbsnmp.bsln_internal.maintain_thresholds; end;
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
9whcc4w2ws87n	select region_id, region_name from regions where region_id = :regionID
ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
b6vvz2u69xdma	update myemp set sal = :sal where empno = :id
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d87cd6s72f197	insert into wrh$_seg_stat (snap_id, dbid, instance_number, ts#, obj#, dataobj#, logical_reads_total, logical_reads_delta, buffer_busy_waits_total, buffer_busy_waits_delta, db_block_changes_total, db_block_changes_delta, physical_reads_total, physical_reads_delta, physical_writes_total, physical_writes_delta, physical_reads_direct_total, physical_reads_direct_delta, physical_writes_direct_total, physical_writes_direct_delta, itl_waits_total, itl_waits_delta, row_lock_waits_total, row_lock_waits_delta, gc_buffer_busy_total, gc_buffer_busy_delta, gc_cr_blocks_received_total, gc_cr_blocks_received_delta, gc_cu_blocks_received_total, gc_cu_blocks_received_delta, space_used_total, space_used_delta, space_allocated_total, space_allocated_delta, table_scans_total, table_scans_delta, chain_row_excess_total, chain_row_excess_delta, physical_read_requests_total, physical_read_requests_delta, physical_write_requests_total, physical_write_requests_delta, optimized_physical_reads_total, optimized_physical_reads_delta) select :snap_id, :dbid, :instance_number, tsn_kewrseg, objn_kewrseg, objd_kewrseg, log_rds_kewrseg, log_rds_dl_kewrseg, buf_busy_wts_kewrseg, buf_busy_wts_dl_kewrseg, db_blk_chgs_kewrseg, db_blk_chgs_dl_kewrseg, phy_rds_kewrseg, phy_rds_dl_kewrseg, phy_wrts_kewrseg, phy_wrts_dl_kewrseg, phy_rds_drt_kewrseg, phy_rds_drt_dl_kewrseg, phy_wrts _drt_kewrseg, phy_wrts_drt_dl_kewrseg, itl_wts_kewrseg, itl_wts_dl_kewrseg, row_lck_wts_kewrseg, row_lck_wts_dl_kewrseg, gc_buf_busy_kewrseg, gc_buf_busy_dl_kewrseg, gc_cr_blks_rcv_kewrseg, gc_cr_blks_rcv_dl_kewrseg, gc_cu_blks_rcv_kewrseg, gc_cu_blks_rcv_dl_kewrseg, space_used_kewrseg, space_used_dl_kewrseg, space_alloc_kewrseg, space_alloc_dl_kewrseg, tbl_scns_kewrseg, tbl_scns_dl_kewrseg, chn_exc_kewrseg, chn_exc_dl_kewrseg, phy_rd_reqs_kewrseg, phy_rd_reqs_dl_kewrseg, phy_wrt_reqs_kewrseg, phy_wrt_reqs_dl_kewrseg, opt_phy_rds_kewrseg, opt_phy_rds_dl_kewrseg from X$KEWRTSEGSTAT order by objn_kewrseg, objd_kewrseg
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fdjtrdaz8hpvg	INSERT /+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial# , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_model , service_hash, program, module, action, client_id, machine, port, ecid , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a. flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_session_serial# , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance#, a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.delta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (h.is_awr_sample = 'Y') ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and a.need_awr_sample = 'Y')
gkqrnt9wwp6fp	select regid, username, location_name, subscription_name from table(dbms_client_result_cache.cache_cleanup (:flags))

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	5	0.00	0.00
CCursor + sql area evicted	4	0.00	0.00
CPU used by this session	140,281	105.45	0.18
CPU used when call started	137,942	103.70	0.18
CR blocks created	4,071	3.06	0.01
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	49	0.04	0.00
DB time	1,470,042	1,105.08	1.93
DBWR checkpoint buffers written	1,502	1.13	0.00
DBWR checkpoints	23	0.02	0.00
DBWR thread checkpoint buffers written	1,502	1.13	0.00
DBWR transaction table writes	440	0.33	0.00
DBWR undo block writes	16,083	12.09	0.02
HSC Heap Segment Block Changes	781,540	587.51	1.03
Heap Segment Array Inserts	89	0.07	0.00
Heap Segment Array Updates	88	0.07	0.00
IMU CR rollbacks	433	0.33	0.00
IMU Flushes	113,922	85.64	0.15
IMU Redo allocation size	45,446,304	34,163.58	59.80
IMU commits	606,068	455.60	0.80
IMU contention	113,757	85.52	0.15
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	41,541	31.23	0.05
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	310,946,764	233,749.57	409.13
IMU- failed to get a private strand	37,739	28.37	0.05
LOB table id lookup cache misses	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	877,814	659.88	1.16
active txn count during cleanout	44,282	33.29	0.06
application wait time	4,614	3.47	0.01
background checkpoints completed	22	0.02	0.00
background checkpoints started	23	0.02	0.00
background timeouts	5,470	4.11	0.01
buffer is not pinned count	869,794	653.85	1.14
buffer is pinned count	4,446	3.34	0.01
bytes received via SQL*Net from client	289,042,068	217,283.04	380.31
bytes sent via SQL*Net to client	179,375,842	134,843.10	236.02
calls to get snapshot scn: kcmgss	1,688,923	1,269.62	2.22
calls to kcmgas	789,384	593.41	1.04
calls to kcmgcs	110,161	82.81	0.14
cell physical IO interconnect bytes	637,221,888	479,022.00	838.44
change write time	7,433	5.59	0.01
cleanout - number of ktugct calls	87,779	65.99	0.12
cleanouts and rollbacks - consistent read gets	2,366	1.78	0.00
cleanouts only - consistent read gets	1,886	1.42	0.00
cluster key scan block gets	1,288	0.97	0.00
cluster key scans	776	0.58	0.00
commit batch/immediate performed	3	0.00	0.00
commit batch/immediate requested	3	0.00	0.00
commit cleanout failures: buffer being written	3	0.00	0.00
commit cleanout failures: callback failure	1,255	0.94	0.00
commit cleanout failures: cannot pin	114,614	86.16	0.15
commit cleanouts	780,916	587.04	1.03
commit cleanouts successfully completed	665,044	499.94	0.88
commit immediate performed	3	0.00	0.00
commit immediate requested	3	0.00	0.00
commit txn count during cleanout	117,559	88.37	0.15
concurrency wait time	191,726	144.13	0.25
consistent changes	10,254	7.71	0.01
consistent gets	1,235,422	928.71	1.63
consistent gets - examination	1,010,374	759.53	1.33
consistent gets from cache	1,235,422	928.71	1.63
consistent gets from cache (fastpath)	217,677	163.64	0.29
cursor authentications	57	0.04	0.00
data blocks consistent reads - undo records applied	8,550	6.43	0.01
db block changes	3,137,907	2,358.87	4.13
db block gets	3,075,122	2,311.68	4.05
db block gets direct	64	0.05	0.00
db block gets from cache	3,075,058	2,311.63	4.05
db block gets from cache (fastpath)	600	0.45	0.00
deferred (CURRENT) block cleanout applications	139,054	104.53	0.18
dirty buffers inspected	13,044	9.81	0.02
enqueue conversions	312	0.23	0.00
enqueue releases	1,636,061	1,229.88	2.15
enqueue requests	1,636,062	1,229.89	2.15
enqueue timeouts	1	0.00	0.00
enqueue waits	6,240	4.69	0.01
execute count	906,053	681.11	1.19
file io service time	0	0.00	0.00
file io wait time	104,424,685	78,499.69	137.40
free buffer inspected	18,866	14.18	0.02
free buffer requested	23,707	17.82	0.03
heap block compress	182	0.14	0.00
hot buffers moved to head of LRU	1,908	1.43	0.00
immediate (CR) block cleanout applications	4,252	3.20	0.01
immediate (CURRENT) block cleanout applications	86	0.06	0.00
index crx upgrade (positioned)	0	0.00	0.00
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	2	0.00	0.00
index fetch by key	803,872	604.30	1.06
index scans kdiixs1	46,065	34.63	0.06
leaf node 90-10 splits	20	0.02	0.00
leaf node splits	24	0.02	0.00
lob reads	0	0.00	0.00
lob writes	14	0.01	0.00
lob writes unaligned	14	0.01	0.00
logons cumulative	10,008	7.52	0.01
max cf enq hold time	440	0.33	0.00
messages received	92,715	69.70	0.12
messages sent	92,715	69.70	0.12
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	15	0.01	0.00
no work - consistent read gets	116,917	87.89	0.15
non-idle wait count	3,150,165	2,368.09	4.14
non-idle wait time	1,323,388	994.84	1.74
opened cursors cumulative	915,266	688.04	1.20
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	231	0.17	0.00
parse count (total)	912,642	686.06	1.20
parse time cpu	5,561	4.18	0.01
parse time elapsed	18,045	13.57	0.02
physical read IO requests	1,401	1.05	0.00
physical read bytes	16,318,464	12,267.16	21.47
physical read total IO requests	3,603	2.71	0.00
physical read total bytes	51,215,360	38,500.38	67.39
physical read total multi block requests	0	0.00	0.00
physical reads	1,992	1.50	0.00
physical reads cache	1,929	1.45	0.00
physical reads cache prefetch	537	0.40	0.00
physical reads direct	63	0.05	0.00
physical reads direct temporary tablespace	63	0.05	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	12,773	9.60	0.02
physical write bytes	146,907,136	110,435.24	193.30
physical write total IO requests	111,275	83.65	0.15
physical write total bytes	586,006,528	440,521.62	771.05
physical write total multi block requests	185	0.14	0.00
physical writes	17,933	13.48	0.02
physical writes direct	421	0.32	0.00
physical writes direct temporary tablespace	357	0.27	0.00
physical writes from cache	17,512	13.16	0.02
physical writes non checkpoint	17,349	13.04	0.02
pinned buffers inspected	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	2,002,481	1,505.34	2.63
recursive cpu usage	34,270	25.76	0.05
redo blocks checksummed by FG (exclusive)	21,132	15.89	0.03
redo blocks read for recovery	0	0.00	0.00
redo blocks written	832,626	625.91	1.10
redo buffer allocation retries	37	0.03	0.00
redo entries	970,093	729.25	1.28
redo entries for lost write detection	1,327	1.00	0.00
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	48	0.04	0.00
redo log space wait time	92	0.07	0.00
redo ordering marks	3,651	2.74	0.00
redo size	387,400,012	291,222.15	509.73
redo size for direct writes	460	0.35	0.00
redo size for lost write detection	82,864	62.29	0.11
redo subscn max counts	4,917	3.70	0.01
redo synch time	1,059,717	796.63	1.39
redo synch writes	780,054	586.39	1.03
redo wastage	24,747,944	18,603.90	32.56
redo write time	49,595	37.28	0.07
redo writes	92,030	69.18	0.12
rollback changes - undo records applied	4	0.00	0.00
rollbacks only - consistent read gets	1,524	1.15	0.00
rows fetched via callback	1,549	1.16	0.00
securefile allocation bytes	0	0.00	0.00
securefile allocation chunks	0	0.00	0.00
securefile bytes cleartext	0	0.00	0.00
securefile bytes encrypted	0	0.00	0.00
securefile compressed bytes	0	0.00	0.00
securefile inode ioreap time	0	0.00	0.00
securefile inode read time	0	0.00	0.00
securefile inode write time	0	0.00	0.00
securefile number of flushes	0	0.00	0.00
securefile uncompressed bytes	0	0.00	0.00
segemnt dispenser load empty	0	0.00	0.00
segment cfs allocations	0	0.00	0.00
segment chunks allocation from disepnser	0	0.00	0.00
segment dispenser allocations	0	0.00	0.00
segment dispenser load tasks	0	0.00	0.00
segment prealloc bytes	0	0.00	0.00
segment prealloc ops	0	0.00	0.00
segment prealloc tasks	0	0.00	0.00
segment prealloc time (ms)	0	0.00	0.00
segment total chunk allocation	0	0.00	0.00
session cursor cache hits	804,164	604.52	1.06
session logical reads	4,310,544	3,240.39	5.67
shared hash latch upgrades - no wait	3,341	2.51	0.00
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	51,176	38.47	0.07
sorts (rows)	80,201	60.29	0.11
sql area evicted	152	0.11	0.00
sql area purged	0	0.00	0.00
summed dirty queue length	14,453	10.86	0.02
switch current to new buffer	567	0.43	0.00
table fetch by rowid	7,146	5.37	0.01
table fetch continued row	117	0.09	0.00
table scan blocks gotten	50,361	37.86	0.07
table scan rows gotten	965,532	725.82	1.27
table scans (long tables)	1	0.00	0.00
table scans (short tables)	40,082	30.13	0.05
temp space allocated (bytes)	1,048,576	788.25	1.38
total cf enq hold time	4,580	3.44	0.01
total number of cf enq holders	85	0.06	0.00
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	3	0.00	0.00
undo change vector size	124,964,132	93,939.91	164.42
user I/O wait time	811	0.61	0.00
user calls	1,717,923	1,291.42	2.26
user commits	760,011	571.33	1.00
user rollbacks	0	0.00	0.00
workarea executions - onepass	2	0.00	0.00
workarea executions - optimal	10,577	7.95	0.01
write clones created in background	0	0.00	0.00
write clones created in foreground	484	0.36	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
opened cursors current	37	41
logons current	28	28
session uga memory max	166,958,936	2,592,313,868
session pga memory	60,805,252	63,419,464
session pga memory max	71,897,864	75,036,364
session cursor cache count	2,415	92,786
session uga memory	64,441,188,824	69,189,499,180

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)	23	62.24

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
LGWR	9M	0.46	.006765	411M	73.64	.308963	93.1K	4.55
DBWR	0M	0.00	0M	137M	9.64	.102987	395	264.61
Others	25M	1.20	.018793	10M	0.48	.007517	2805	6.51
Buffer Cache Reads	15M	1.04	.011276	0M	0.00	0M	1386	0.06
Direct Writes	0M	0.00	0M	3M	0.04	.002255	59	3.47
Direct Reads	0M	0.01	0M	0M	0.00	0M	9	0.00
Streams AQ	0M	0.00	0M	0M	0.00	0M	3	6.33
TOTAL:	49M	2.71	.036835	561M	83.80	.421723	97.8K	5.59

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read
Log File	0M	0.03	0M	407M	73.47	.305956	0.00
Data File	15M	1.10	.011276	139M	9.69	.104491	0.11
Control File	33M	1.57	.024807	13M	0.60	.009772	0.09
Temp File	0M	0.01	0M	2M	0.04	.001503	0.00
TOTAL:	48M	2.71	.036083	561M	83.80	.421723	0.10

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
LGWR	9M	0.46	.006765	411M	73.64	.308963	658	0.19
LGWR (Log File)	0M	0.03	0M	407M	73.47	.305956	92	1.37
LGWR (Control File)	9M	0.43	.006765	4M	0.17	.003006	566	0.00
DBWR	0M	0.00	0M	137M	9.64	.102987	0
DBWR (Data File)	0M	0.00	0M	137M	9.64	.102987	0
Others	25M	1.20	.018793	10M	0.48	.007517	1657	0.79
Others (Control File)	24M	1.14	.018041	9M	0.43	.006765	1522	0.13
Others (Data File)	1M	0.05	.000751	1M	0.05	.000751	135	8.20
Buffer Cache Reads	15M	1.04	.011276	0M	0.00	0M	1388	0.06
Buffer Cache Reads (Data File)	15M	1.04	.011276	0M	0.00	0M	1388	0.06
Direct Writes	0M	0.00	0M	3M	0.04	.002255	0
Direct Writes (Data File)	0M	0.00	0M	3M	0.04	.002255	0
Streams AQ	0M	0.00	0M	0M	0.00	0M	3	6.33
Streams AQ (Data File)	0M	0.00	0M	0M	0.00	0M	3	6.33
Direct Reads	0M	0.01	0M	0M	0.00	0M	0
Direct Reads (Data File)	0M	0.01	0M	0M	0.00	0M	0
TOTAL:	49M	2.71	.036835	561M	83.80	.421723	3706	0.42

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
UD1	34	0	0.00	1.00	11,972	9	1,423	2.75
SYSAUX	753	1	0.05	1.08	385	0	0	0.00
SYSTEM	615	0	0.16	1.78	211	0	134,841	7.32
TEMP	11	0	0.00	5.91	52	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	/ade/b/3050220379/oracle/dbs/t_ax1.f	753	1	0.05	1.08	385	0	0	0.00
SYSTEM	/ade/b/3050220379/oracle/dbs/t_db1.f	615	0	0.16	1.78	211	0	134,841	7.32
TEMP	/ade/b/3050220379/oracle/dbs/t_tmp1.f	11	0	0.00	5.91	52	0	0
UD1	/ade/b/3050220379/oracle/dbs/t_undo1.f	34	0	0.00	1.00	11,972	9	1,423	2.75

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	1,984	100	4,306,983	1,937	17,443	0	0	136,264

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 17,933

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	780	0	0	0	722

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

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

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	11	283	3706	3849	41472	3849
E	0	13	522	36123	41472	41472	135292

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	4	0.25	0	1.62	40	1	395.00
D	8	0.50	1	1.26	31	1	308.00
D	12	0.75	1	1.15	28	1	280.00
D	16	1.00	2	1.00	25	1	245.00
D	20	1.25	2	0.95	23	1	231.00
D	24	1.50	3	0.93	23	1	228.00
D	28	1.75	3	0.91	22	1	222.00
D	32	2.00	4	0.90	22	1	220.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
86.05	47	8

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin Snap E: End Snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	29	4	45.32	0.00	0.00	0.00	0.00	5,939
E	29	4	47.57	0.00	0.00	0.00	0.00	5,939

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs	1-Pass Execs
2K	4K	10,559	10,559	0
64K	128K	4	4	0
256K	512K	4	4	0
512K	1024K	24	24	0
2M	4M	2	0	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
15	0.50	195.58	100.00	2	168,443
22	0.75	195.58	100.00	2	168,443
29	1.00	195.58	100.00	2	168,443
35	1.20	195.58	100.00	2	168,443
41	1.40	195.58	100.00	2	168,443
46	1.60	195.58	100.00	1	168,443
52	1.80	195.58	100.00	1	168,443
58	2.00	195.58	100.00	1	168,443
87	3.00	195.58	100.00	0	168,443
116	4.00	195.58	100.00	0	168,443
174	6.00	195.58	100.00	0	168,443
232	8.00	195.58	100.00	0	168,443

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
88	0.88	7	663	12,038	1.00	241	1.04	283
100	1.00	19	1,554	12,047	1.00	232	1.00	448
112	1.12	31	2,349	12,056	1.00	223	0.96	449
124	1.24	43	3,155	12,060	1.00	219	0.94	449
136	1.36	52	3,784	12,060	1.00	219	0.94	449
148	1.48	55	3,976	12,061	1.00	218	0.94	449
160	1.60	55	3,976	12,061	1.00	218	0.94	449
172	1.72	55	3,976	12,061	1.00	218	0.94	449
184	1.84	55	3,976	12,061	1.00	218	0.94	449
196	1.96	55	3,976	12,061	1.00	218	0.94	449
208	2.08	55	3,976	12,061	1.00	218	0.94	449

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	134,837	987	7
undo header	1,421	4	3
segment header	4	0	13
undo block	2	0	5

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	6,421	6,421	0	6,233	46	7.42
HW-Segment High Water Mark	330	330	0	7	0	17.14

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
3	14.40	693,546	1,075	8	18.9/28.9	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
18-Sep 02:21	7,650	368,729	1,075	6	29	0/0	0/0/0/0/0/0
18-Sep 02:11	6,753	324,817	471	8	19	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0	0
ASM db client latch	891	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	32	0.00		0	0
AWR Alerted Metric Element list	9,772	0.00		0	0
Change Notification Hash table latch	1,649,678	0.02	0.01	0	0
Consistent RBA	92,056	0.00		0	0
DML lock allocation	1,641,760	0.21	0.21	4	0
Event Group Locks	10,008	0.00		0	0
FOB s.o list latch	16,123	0.02	0.33	0	0
File State Object Pool Parent Latch	1	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	3,187,944	4.94	0.77	762	796,495	0.52
JS Sh mem access	3	0.00		0	0
JS mem alloc latch	4	0.00		0	0
JS queue access latch	5	0.00		0	0
JS queue state obj latch	7,934	0.00		0	0
JS slv state obj latch	5	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	1	0.00		0	0
KJCT flow control latch	1	0.00		0	0
KKCN reg stat latch	4	0.00		0	0
KMG MMAN ready and startup request latch	438	0.00		0	0
KTF sga latch	8	0.00		0	445	0.00
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1	0.00		0	0
MQL Tracking Latch	0			0	26	0.00
Memory Management Latch	1	0.00		0	438	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	7	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	30,200	0.00		0	0
OS process allocation	20,481	0.05	0.90	0	0
OS process: request allocation	20,014	0.02	0.60	0	0
PL/SQL warning settings	10,014	0.00		0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	23	0.00		0	0
SGA IO buffer pool latch	2,502	0.00		0	2,502	0.00
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	59	0.00		0	436	0.00
SQL memory manager workarea list latch	33,290	0.00		0	0
Shared B-Tree	48	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	1	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	954	0.00		0	0
active service list	52,924	0.06	0.63	0	909	0.00
begin backup scn array	8	0.00		0	0
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	121	0.00		0	0
cache buffers chains	18,492,394	0.55	0.11	66	23,137	0.10
cache buffers lru chain	19,820	0.01	0.00	0	45,057	0.04
cache table scan latch	105	0.00		0	105	0.00
call allocation	31,353	0.30	0.84	1	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	20,015	0.05	0.36	0	0
channel operations parent latch	38,168	0.00		0	0
checkpoint queue latch	39,821	0.00		0	17,579	0.00
client/application info	70,017	0.00		0	0
compile environment latch	10,008	0.00		0	0
corrupted undo seg latch	15	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	32	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	32	0.00		0	0
dml lock allocation	32	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	20,017	0.07	0.53	0	0
enqueue hash chains	3,279,499	1.07	0.14	37	11	0.00
enqueues	69,223	0.05	0.69	0	0
fifth spare latch	1	0.00		0	0
file cache latch	215	0.00		0	0
flashback copy	1	0.00		0	0
gc element	1	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs partitioned table hash	1	0.00		0	0
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs resource freelist	1	0.00		0	0
gcs resource hash	1	0.00		0	0
gcs resource scan list	1	0.00		0	0
gcs shadows freelist	1	0.00		0	0
ges domain table	1	0.00		0	0
ges enqueue table freelist	1	0.00		0	0
ges group table	1	0.00		0	0
ges process hash list	1	0.00		0	0
ges process parent latch	1	0.00		0	0
ges resource hash list	1	0.00		0	0
ges resource scan list	1	0.00		0	0
ges resource table freelist	1	0.00		0	0
ges value block free list	1	0.00		0	0
global KZLD latch for mem in SGA	10,000	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	297	0.00		0	5,295	0.00
hash table modification latch	10	0.00		0	0
heartbeat check	1	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	2	0.00		0	1	0.00
job_queue_processes free list latch	6	0.00		0	0
job_queue_processes parameter latch	286	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	23	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kks stats	801	0.00		0	0
kokc descriptor allocation latch	34	0.00		0	0
kpon sga structure	2	0.00		0	0
ksfv messages	1	0.00		0	0
kss move lock	11	0.00		0	0
ksuosstats global area	92	0.00		0	0
ksv allocation latch	52	0.00		0	0
ksv class latch	21	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	20,014	0.07	0.40	0	0
ktm global data	7	0.00		0	0
kwqbsn:qsga	47	0.00		0	0
lgwr LWN SCN	92,253	0.00	0.50	0	0
list of block allocation	20,029	0.01	0.50	0	0
loader state object freelist	4	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	5	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	1	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	1	0.00		0	0
messages	240,016	0.05	0.29	0	0
mostly latch-free SCN	92,501	0.10	0.31	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	242	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	32	0.00		0	0
object queue header heap	2,137	0.00		0	689	0.00
object queue header operation	93,362	0.01	0.00	0	0
object stats modification	82	0.00		0	0
parallel query alloc buffer	173	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	456	0.00		0	0
parameter table management	20,017	0.00		0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	286,335	0.07	0.10	0	879,882	0.13
process allocation	20,021	0.13	0.89	0	10,005	0.02
process group creation	20,014	0.01	0.00	0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	195	6.15	1.00	0	0
query server freelists	1	0.00		0	0
queued dump request	4	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	1,824,770	0.18	0.09	1	968,565	0.39
redo copy	1	0.00		0	970,104	1.10
redo writing	283,571	0.00	1.00	0	0
resmgr group change latch	10,002	0.00		0	0
resmgr:active threads	20,017	0.00		0	0
resmgr:actses change group	10,007	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	20,016	0.06	0.17	0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	1	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	714,383	0.23	0.15	4	446	0.22
second spare latch	1	0.00		0	0
sequence cache	30,034	0.03	0.22	0	0
session allocation	2,490,166	0.19	0.48	24	830,015	0.40
session idle bit	4,255,833	0.15	0.12	6	0
session queue latch	1	0.00		0	0
session state list latch	28	0.00		0	0
session switching	50,068	0.00		0	0
session timer	484	0.00		0	0
shared pool	455,518	0.26	0.14	2	0
shared pool sim alloc	9	0.00		0	0
shared pool simulator	4,143	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	71,651	0.00	1.00	0	0
simulator lru latch	1	0.00		0	69,362	0.02
sort extent pool	55	0.00		0	0
space background task latch	975	0.00		0	878	0.00
state object free list	2	0.00		0	0
statistics aggregation	336	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	1	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
third spare latch	1	0.00		0	0
threshold alerts latch	34	0.00		0	0
trace latch	17	0.00		0	0
transaction allocation	40,038	0.00	0.50	0	0
undo global data	3,969,253	0.02	0.22	1	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
In memory undo latch	3,187,944	157,584	121,926	38,596
cache buffers chains	18,492,394	100,811	10,659	90,566
enqueue hash chains	3,279,499	35,252	4,961	30,452
session idle bit	4,255,833	6,268	731	5,538
session allocation	2,490,166	4,842	2,335	2,512
DML lock allocation	1,641,760	3,410	733	2,705
redo allocation	1,824,770	3,255	307	2,973
row cache objects	714,383	1,631	251	1,385
shared pool	455,518	1,177	167	1,011
undo global data	3,969,253	975	216	778
Change Notification Hash table latch	1,649,678	311	3	308
post/wait queue	286,335	199	19	181
messages	240,016	122	35	88
mostly latch-free SCN	92,501	97	30	68
call allocation	31,353	95	80	15
enqueues	69,223	35	24	14
active service list	52,924	32	20	12
process allocation	20,021	27	24	4
dummy allocation	20,017	15	8	7
ksz_so allocation latch	20,014	15	6	9
qmn task queue latch	195	12	12	0
resmgr:free threads list	20,016	12	2	10
channel handle pool latch	20,015	11	4	7
OS process allocation	20,481	10	9	1
sequence cache	30,034	9	2	7
OS process: request allocation	20,014	5	3	2
FOB s.o list latch	16,123	3	1	2
lgwr LWN SCN	92,253	2	1	1
list of block allocation	20,029	2	1	1
transaction allocation	40,038	2	1	1
redo writing	283,571	1	1	0
simulator hash latch	71,651	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
Change Notification Hash table latch	ktcncGetInbandNotifications	3	1
DML lock allocation	ktaidm	544	144
DML lock allocation	ktaiam	189	589
FOB s.o list latch	ksfd_fobd	1	0
In memory undo latch	kticmt: child	86,688	15,762
In memory undo latch	ktiFlush: child	24,355	107,302
In memory undo latch	ktichg: child	12,831	0
In memory undo latch	ktiTxnPoolFree	15	5
In memory undo latch	ktiBRacquire	6	0
In memory undo latch	kturbk	2	1,385
OS process allocation	kso_new_process:2	8	3
OS process allocation	kso_delete_process:1	1	6
OS process: request allocation	kso_new_process	3	1
active service list	kswslogon: session logout	15	10
active service list	kswsgsnp: get service name ptr	2	6
active service list	kswslogon: session login	2	4
active service list	kswsite: service iterator	1	0
cache buffers chains	kcbnlc	3,698	324
cache buffers chains	kcbgcur_2	2,831	8,018
cache buffers chains	kcbgtcr: fast path (cr pin)	1,723	42
cache buffers chains	kcb_post_apply: kcbhq62	747	149
cache buffers chains	kcb_commit	741	276
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	359	92
cache buffers chains	kcb_pre_apply: kcbhq61	247	433
cache buffers chains	kcbzpbuf	170	519
cache buffers chains	kcbzwb	97	661
cache buffers chains	kcbgtcr: fast path	68	118
cache buffers chains	kcbchg1: kslbegin: call CR func	25	38
cache buffers chains	kcbrls_2	21	35
cache buffers chains	kcb_is_private	2	10
cache buffers chains	kcbnew: new latch again	1	2
call allocation	ksuxds	51	44
call allocation	ksudlp: top call	22	14
call allocation	ksucrp: top call	7	22
channel handle pool latch	ksrchconnect()	3	3
channel handle pool latch	ksrchdelete()	1	1
dummy allocation	ktcscnfy	6	6
dummy allocation	ktcdod	2	2
enqueue hash chains	ksqrcl	3,170	758
enqueue hash chains	ksqgtl3	1,778	4,202
enqueue hash chains	ksqcmi: get hash chain latch after wait	11	1
enqueue hash chains	ksqcnl	2	0
enqueues	ksqgel: create enqueue	16	17
enqueues	ksqdel	8	7
ksz_so allocation latch	ksznfy1	5	3
ksz_so allocation latch	ksz_parent_so_del1	1	3
lgwr LWN SCN	kcs022	1	0
list of block allocation	ktlabl	1	0
messages	ksaamb: after wakeup	28	15
messages	ksarcv	3	14
messages	ksaclr	2	4
messages	ksarcv: after wait	2	2
mostly latch-free SCN	kcs04	16	28
mostly latch-free SCN	kcs05	14	3
post/wait queue	ksliwat:add:nowait	10	0
post/wait queue	ksliwat:remove	7	6
post/wait queue	kslpstevent:get	2	8
process allocation	ksucrp:1	20	0
process allocation	ksudlp	3	13
process allocation	ksuapc	1	11
qmn task queue latch	kwqmnmvtsks: delay to ready list	11	0
qmn task queue latch	kwqmnaddtsk: add task	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	279	0
redo allocation	kcrf_pvt_strand_bind	14	26
redo allocation	kcrf_pvt_strand_unbind	12	0
redo allocation	kcrfw_redo_gen: redo allocation 2	1	0
redo allocation	kcrfw_redo_gen: redo allocation 3	1	3
redo writing	kcrfw_cal_target_rba	1	0
resmgr:free threads list	kskthrcreate	2	2
row cache objects	kqreqd: reget	192	0
row cache objects	kqrpre: find obj	51	189
row cache objects	kqreqd	4	61
row cache objects	kqrso	4	1
sequence cache	kdnssd	2	0
session allocation	ksuxds	1,058	2,090
session allocation	ksucri_int : SSO	1,056	24
session allocation	ksucri_int : licensing	155	97
session allocation	ksuxds_int	66	124
session idle bit	ksupuc: set busy	273	220
session idle bit	ksuxds	246	299
session idle bit	ksupuc: clear busy	213	213
shared pool	kghalo	86	86
shared pool	kghupr1	54	43
shared pool	kghfre	26	38
shared pool	kghalp	1	0
simulator hash latch	kcbsacc: lookup dba	1	1
transaction allocation	ktcxbr	1	0
undo global data	ktudnx:child	180	37
undo global data	ktudba: KSLBEGIN	24	59
undo global data	ktufrbs_2	12	120

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Cursor Pin	kksfbc [KKSCHLPIN1]	1,926	0
Library Cache	kglhdgn2 106	1,554	-17
Library Cache	kgllkdl1 85	775	33
Cursor Pin	kkslce [KKSCHLPIN2]	209	-33
Cursor Pin	kksLockDelete [KKSCHLPIN6]	131	0
Library Cache	kglhdgn1 62	12	4
Library Cache	kgllkc1 57	8	98
Library Cache	kglpndl1 95	7	47
Library Cache	kglpin1 4	4	0
hash table	kkscsSearchChildList [KKSHBKLOC2]	3	0
Library Cache	kglini1 32	1	0
Library Cache	kglpnal1 90	1	-7

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: 4,310,544
Captured Segments account for 48.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
OCIHOL	SYSTEM	SYS_C004756	INDEX	799,840	18.56
OCIHOL	SYSTEM	MYEMP	TABLE	760,976	17.65
SYS	SYSTEM	AUD$	TABLE	172,592	4.00
SYS	SYSTEM	I_SYSAUTH1	INDEX	160,176	3.72
SYS	SYSTEM	PROPS$	TABLE	159,968	3.71

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 1,992
Captured Segments account for 54.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	I_OBJ2	INDEX	579	29.07
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	69	3.46
SYS	SYSTEM	ICOL$	TABLE	43	2.16
SYS	SYSTEM	HIST_HEAD$	TABLE	38	1.91
SYS	SYSTEM	CCOL$	TABLE	19	0.95

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 1,401
Captured Segments account for 43.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
SYS	SYSTEM	I_OBJ2	INDEX	112	7.99
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	69	4.93
SYS	SYSTEM	ICOL$	TABLE	43	3.07
SYS	SYSTEM	HIST_HEAD$	TABLE	38	2.71
SYS	SYSTEM	CCOL$	TABLE	19	1.36

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 1,401
Captured Segments account for 43.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
SYS	SYSTEM	I_OBJ2	INDEX	112	7.99
SYS	SYSAUX	WRH$_SQL_PLAN	TABLE	69	4.93
SYS	SYSTEM	ICOL$	TABLE	43	3.07
SYS	SYSTEM	HIST_HEAD$	TABLE	38	2.71
SYS	SYSTEM	CCOL$	TABLE	19	1.36

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: 17,933
Captured Segments account for 4.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYS	SYSTEM	AUD$		TABLE	395	2.20
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_570420430_665	TABLE PARTITION	70	0.39
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	29	0.16
OCIHOL	SYSTEM	MYEMP		TABLE	24	0.13
SYS	SYSAUX	CRC$_RESULT_CACHE_STATS		TABLE	17	0.09

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 12,773
Captured Segments account for 2.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
SYS	SYSTEM	AUD$		TABLE	73	0.57
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	27	0.21
OCIHOL	SYSTEM	MYEMP		TABLE	23	0.18
SYS	SYSAUX	CRC$_RESULT_CACHE_STATS		TABLE	16	0.13
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY_PK	WRH$_ACTIVE_570420430_665	INDEX PARTITION	15	0.12

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 421
Captured Segments account for 15.2% of Total

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

Back to Segment Statistics
Back to Top

Segments by Table Scans

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

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

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
OCIHOL	SYSTEM	MYEMP		TABLE	171,600	92.81
SYS	SYSTEM	AUD$		TABLE	11,680	6.32
SYS	SYSTEM	COL_USAGE$		TABLE	624	0.34
SYS	SYSAUX	CRC$_RESULT_CACHE_STATS		TABLE	144	0.08
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_570420430_665	TABLE PARTITION	112	0.06

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

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

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
OCIHOL	SYSTEM	MYEMP		TABLE	134,600	99.82
SYS	SYSTEM	AUD$		TABLE	241	0.18

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	29	0.00	2	1
dc_free_extents	12	0.00	0	3
dc_global_oids	52	9.62	0	101
dc_histogram_data	271	9.23	0	310
dc_histogram_defs	2,967	52.44	0	2,255
dc_objects	12,036	1.09	1	1,450
dc_profiles	10,002	0.00	0	1
dc_rollback_segments	370	0.00	0	28
dc_segments	992	32.36	16	1,057
dc_sequences	5	80.00	5	4
dc_tablespaces	1,679	0.00	0	4
dc_users	271,512	0.01	0	78
global database name	10,881	0.00	0	2
outstanding_alerts	2	0.00	0	1
sch_lj_oids	3	33.33	0	2

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	20	5.00	23	17.39	3
CLUSTER	25	8.00	16	12.50	0
DBLINK	20,001	0.00	0		0
EDITION	10,006	0.00	20,007	0.00	1
INDEX	21	90.48	21	90.48	0
LOCATION	22	50.00	22	50.00	0
QUEUE	0		264	0.00	0
SCHEMA	20,239	0.00	0		0
SQL AREA	111,634	0.37	967,137	-0.13	105
SUBSCRIPTION	4	50.00	4	50.00	0
TABLE/PROCEDURE	10,975	0.06	21,977	2.60	437

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	16.00	16.00	16.00	16.00	STA/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	32.00	32.00	32.00	32.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	0.00	0.00	0.00	0.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	48.00	48.00	48.00	48.00	STA/
large pool	0.00	0.00	0.00	0.00	STA/
shared pool	100.00	100.00	100.00	100.00	STA/
streams pool	0.00	0.00	0.00	0.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

B: Begin Snap E: End Snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	39.68		1.42	2.02	11	11	28	28
	Freeable	4.44	0.00	0.63	0.78	2		7	7
	SQL	0.75	0.61	0.04	0.15	1	2	17	9
	PL/SQL	0.48	0.41	0.02	0.04	0	0	28	28
E	Other	40.24		1.44	2.04	11	11	28	28
	Freeable	6.19	0.00	1.03	1.10	3		6	6
	SQL	0.69	0.60	0.04	0.16	1	3	17	9
	PL/SQL	0.48	0.41	0.02	0.04	0	0	28	28

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	48.00	48.00	0.00
shared	ASH buffers	4.00	4.00	0.00
shared	CCUR	4.08	3.95	-3.04
shared	FileOpenBlock	3.79	3.79	0.00
shared	KCB Table Scan Buffer	3.80	3.80	0.00
shared	KGLH0	2.88	2.98	3.32
shared	KGLHD	1.71	1.28	-25.28
shared	KGLS	3.07	4.12	34.29
shared	KGLSG	3.52	3.52	0.00
shared	KQR M PO	1.41	1.86	32.26
shared	KSFD SGA I/O b	3.79	3.79	0.00
shared	PCUR	2.99	2.81	-6.10
shared	PLMCD	1.02		-100.00
shared	PX msg pool	3.14	3.14	0.00
shared	SQLA	8.09	9.67	19.61
shared	XDBSC	7.86	5.35	-31.96
shared	dbktb: trace buffer	1.56	1.56	0.00
shared	event statistics per sess	1.84	1.84	0.00
shared	free memory	7.10	7.26	2.21
shared	kglsim hash table bkts	2.00	2.00	0.00
shared	kse signatures	1.83	1.83	0.00
shared	ksunfy : SSO free list	1.78	1.78	0.00
shared	message pool freequeue	1.09	1.09	0.00
shared	obj stats allocation chun	2.21	2.21	0.00
shared	row cache	3.62	3.62	0.00
	buffer_cache	16.00	16.00	0.00
	fixed_sga	1.27	1.27	0.00
	log_buffer	6.35	6.35	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Shared Server Statistics

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

Shared Servers Activity

Values represent averages for all samples

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

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

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

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	96.84	Redo NoWait %:	100.00
Buffer Hit %:	99.96	In-memory Sort %:	100.00
Library Hit %:	100.06	Soft Parse %:	99.97
Execute to Parse %:	-0.73	Latch Hit %:	99.28
Parse CPU to Parse Elapsd %:	30.82	% Non-Parse CPU:	97.24