WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

WINMDB2 114741071 winmdb2 1 09-Ian-13 20:01 11.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
WINMDB2	114741071	winmdb2	1	09-Ian-13 20:01	11.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

ZERATUL Microsoft Windows IA (32-bit) 4 4 1 3.99

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
ZERATUL	Microsoft Windows IA (32-bit)	4	4	1	3.99

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 24668 18-Ian-13 16:00:02 61 6.3

End Snap: 24670 18-Ian-13 17:00:16 58 5.0

Elapsed: 60.24 (mins)

DB Time: 38.25 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	24668	18-Ian-13 16:00:02	61	6.3
End Snap:	24670	18-Ian-13 17:00:16	58	5.0
Elapsed:		60.24 (mins)
DB Time:		38.25 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 560M 560M Log Buffer: 4,444K

	Begin	End
Buffer Cache:	352M	352M	Std Block Size:	8K
Shared Pool Size:	560M	560M	Log Buffer:	4,444K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.6 0.2 0.00 0.01

DB CPU(s): 0.2 0.1 0.00 0.00

Redo size: 97,992.5 32,247.2

Logical reads: 5,798.9 1,908.3

Block changes: 609.5 200.6

Physical reads: 1,032.0 339.6

Physical writes: 13.1 4.3

User calls: 54.3 17.9

Parses: 177.3 58.3

Hard parses: 9.0 3.0

W/A MB processed: 1.6 0.5

Logons: 0.1 0.0

Executes: 308.3 101.5

Rollbacks: 0.0 0.0

Transactions: 3.0

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.6	0.2	0.00	0.01
DB CPU(s):	0.2	0.1	0.00	0.00
Redo size:	97,992.5	32,247.2
Logical reads:	5,798.9	1,908.3
Block changes:	609.5	200.6
Physical reads:	1,032.0	339.6
Physical writes:	13.1	4.3
User calls:	54.3	17.9
Parses:	177.3	58.3
Hard parses:	9.0	3.0
W/A MB processed:	1.6	0.5
Logons:	0.1	0.0
Executes:	308.3	101.5
Rollbacks:	0.0	0.0
Transactions:	3.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 94.18 Soft Parse %: 94.92

Execute to Parse %: 42.51 Latch Hit %: 99.98

Parse CPU to Parse Elapsd %: 43.92 % Non-Parse CPU: 87.48

Shared Pool Statistics

Begin End

Memory Usage %: 75.36 74.53

% SQL with executions>1: 82.99 59.25

% Memory for SQL w/exec>1: 85.07 70.75

	Begin	End
Memory Usage %:	75.36	74.53
% SQL with executions>1:	82.99	59.25
% Memory for SQL w/exec>1:	85.07	70.75

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
db file sequential read	118,880	935	8	40.72	User I/O
DB CPU		819		35.69
direct path read	231,252	389	2	16.94	User I/O
db file scattered read	7,304	26	4	1.12	User I/O
SQL*Net more data to client	109,409	23	0	1.01	Network

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

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

7.0 3.3 89.7

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
		7.0	3.3		89.7

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

5.8 56.6 0.0

Memory Statistics

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

Begin End

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

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

PGA use (MB): 150.1 125.1

% Host Mem used for SGA+PGA: 29.33 28.72

	Begin	End
Host Mem (MB):	4,084.6	4,084.6
SGA use (MB):	1,048.0	1,048.0
PGA use (MB):	150.1	125.1
% Host Mem used for SGA+PGA:	29.33	28.72

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): 2295s
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,191.62	95.50
DB CPU	819.07	35.69
parse time elapsed	481.37	20.98
hard parse elapsed time	466.77	20.34
PL/SQL compilation elapsed time	118.00	5.14
failed parse elapsed time	92.70	4.04
hard parse (sharing criteria) elapsed time	62.63	2.73
PL/SQL execution elapsed time	47.32	2.06
hard parse (bind mismatch) elapsed time	21.19	0.92
connection management call elapsed time	15.97	0.70
repeated bind elapsed time	2.81	0.12
sequence load elapsed time	0.62	0.03
DB time	2,294.96
background elapsed time	191.54
background cpu time	20.89

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
AVG_BUSY_TIME	36,976
AVG_IDLE_TIME	324,041
AVG_SYS_TIME	11,810
AVG_USER_TIME	25,074
BUSY_TIME	148,284
IDLE_TIME	1,296,560
SYS_TIME	47,602
USER_TIME	100,685
VM_IN_BYTES	977,985,536
VM_OUT_BYTES	609,021,952
PHYSICAL_MEMORY_BYTES	4,282,986,496
NUM_CPU_CORES	4
NUM_CPUS	4
NUM_CPU_SOCKETS	1

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	%busy	%user	%sys	%idle	%iowait
18-Ian 16:00:02
18-Ian 16:30:09	13.77	10.07	3.70	86.23	0.00
18-Ian 17:00:16	6.76	3.87	2.89	93.24	0.00

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 97.3% of Total DB time 2,294.96 (s)
Total FG Wait Time: 1,412.91 (s) DB CPU time: 819.07 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
User I/O	358,742	0	1,375	4	59.93
DB CPU			819		35.69
Network	254,582	0	24	0	1.03
Commit	12,041	0	7	1	0.29
System I/O	1,269	0	4	3	0.19
Concurrency	173	0	2	10	0.07
Other	213	8	1	3	0.03
Configuration	8	50	0	45	0.02
Application	319	0	0	0	0.01

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
db file sequential read	118,880	0	935	8	10.82	40.72
direct path read	231,252	0	389	2	21.06	16.94
db file scattered read	7,304	0	26	4	0.67	1.12
SQL*Net more data to client	109,409	0	23	0	9.96	1.01
Disk file operations I/O	607	0	20	33	0.06	0.86
log file sync	12,041	0	7	1	1.10	0.29
db file parallel read	118	0	6	51	0.01	0.26
control file sequential read	1,269	0	4	3	0.12	0.19
library cache lock	3	0	2	526	0.00	0.07
read by other session	499	0	1	1	0.05	0.03
ADR block file read	36	0	0	10	0.00	0.02
log file switch (private strand flush incomplete)	4	0	0	90	0.00	0.02
buffer exterminate	16	100	0	15	0.00	0.01
SQL*Net message to client	144,400	0	0	0	13.15	0.01
SQL*Net more data from client	773	0	0	0	0.07	0.01
enq: KO - fast object checkpoint	26	0	0	5	0.00	0.01
row cache lock	1	0	0	49	0.00	0.00
latch: shared pool	143	0	0	0	0.01	0.00
SQL*Net break/reset to client	280	0	0	0	0.03	0.00
direct path write	61	0	0	0	0.01	0.00
enq: RO - fast object reuse	13	0	0	1	0.00	0.00
direct path write temp	15	0	0	0	0.00	0.00
rdbms ipc reply	96	0	0	0	0.01	0.00
enq: CR - block range reuse ckpt	7	0	0	1	0.00	0.00
reliable message	47	0	0	0	0.00	0.00
local write wait	6	0	0	1	0.00	0.00
SQL*Net message from client	144,405	0	127,965	886	13.15
jobq slave wait	7,669	100	3,944	514	0.70
Streams AQ: waiting for messages in the queue	722	100	3,604	4992	0.07
wait for unread message on broadcast channel	3,586	98	3,588	1001	0.33

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
db file sequential read	6,980	0	26	4	0.64	13.75
control file sequential read	4,884	0	21	4	0.44	10.74
log file parallel write	121,838	0	20	0	11.09	10.28
db file parallel write	35,209	0	14	0	3.21	7.25
io done	4,749	0	7	1	0.43	3.55
Disk file operations I/O	179	0	4	24	0.02	2.23
os thread startup	143	0	2	14	0.01	1.02
db file scattered read	482	0	2	4	0.04	0.88
control file parallel write	1,679	0	1	1	0.15	0.73
Parameter File I/O	160	0	0	2	0.01	0.18
LGWR slave I/O	115,608	0	0	0	10.53	0.09
db file single write	66	0	0	2	0.01	0.09
ADR block file read	13	0	0	9	0.00	0.06
DBWR slave I/O	48,604	0	0	0	4.43	0.04
log file sequential read	10	0	0	7	0.00	0.04
ADR file lock	6	0	0	6	0.00	0.02
LGWR wait for redo copy	398	0	0	0	0.04	0.01
reliable message	91	0	0	0	0.01	0.00
rdbms ipc reply	90	0	0	0	0.01	0.00
latch: shared pool	10	0	0	0	0.00	0.00
read by other session	5	0	0	1	0.00	0.00
direct path write	13	0	0	0	0.00	0.00
log file single write	10	0	0	0	0.00	0.00
rdbms ipc message	67,187	22	43,259	644	6.12
i/o slave wait	242,760	8	25,218	104	22.10
DIAG idle wait	7,125	100	7,215	1013	0.65
Streams AQ: qmn coordinator idle wait	258	50	3,614	14009	0.02
Streams AQ: qmn slave idle wait	129	0	3,614	28017	0.01
pmon timer	1,237	95	3,612	2920	0.11
Space Manager: slave idle wait	721	100	3,604	4999	0.07
shared server idle wait	120	100	3,602	30014	0.01
dispatcher timer	60	100	3,601	60014	0.01
smon timer	21	48	3,508	167025	0.00
SGA: MMAN sleep for component shrink	600	72	6	11	0.05
SQL*Net message from client	723	0	5	7	0.07

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	49	38.8			8.2	30.6	18.4	4.1
ADR block file write	10	100.0
ADR file lock	12	75.0				25.0
buffer busy waits	19	100.0
buffer exterminate	16				6.3	81.3	12.5
control file parallel write	1675	94.3	3.6	.5	.4	.3	.7	.2
control file sequential read	6139	70.4	4.0	2.6	5.0	8.1	8.5	1.4
db file parallel read	118	2.5	.8	.8	6.8	22.0	31.4	35.6
db file parallel write	35,2K	94.1	.9	3.0	1.1	.7	.2	.0
db file scattered read	7786	76.5	1.1	1.7	5.3	7.6	6.9	.8	.0
db file sequential read	125,7K	23.6	.9	8.9	26.7	31.2	7.7	1.0	.0
db file single write	66	92.4			1.5		1.5	4.5
DBWR slave I/O	48,6K	100.0
direct path read	231,3K	83.9	8.6	.9	1.6	2.7	2.1	.2
direct path write	74	100.0
direct path write temp	15	100.0
Disk file operations I/O	786	49.2	.9	2.8	1.4	4.3	10.1	31.3
enq: CR - block range reuse ckpt	7	100.0
enq: KO - fast object checkpoint	26	26.9	19.2	34.6	7.7	7.7		3.8
enq: RO - fast object reuse	13	76.9	15.4	7.7
io done	4744	61.9	2.3	30.0	4.4	1.2	.2
latch: cache buffers chains	11	100.0
latch: messages	2	100.0
latch: row cache objects	4	100.0
latch: shared pool	151	94.0	3.3	2.0	.7
LGWR slave I/O	115,6K	100.0
LGWR wait for redo copy	397	100.0
library cache lock	3				33.3			33.3	33.3
local write wait	6	100.0
log file parallel write	121,8K	98.9	.4	.3	.2	.2	.1	.0
log file sequential read	10	50.0				30.0	20.0
log file single write	10	100.0
log file switch (private strand flush incomplete)	4						25.0	75.0
log file sync	12K	94.5	2.6	.7	.7	.9	.5	.1
os thread startup	143				44.1	46.9	4.9	4.2
Parameter File I/O	160	93.1				2.5	.6	3.8
rdbms ipc reply	201	99.0	1.0
read by other session	504	83.7	6.7	3.4	3.4	2.4		.4
reliable message	153	100.0
row cache lock	1							100.0
SQL*Net break/reset to client	280	100.0
SQL*Net message to client	145K	100.0
SQL*Net more data from client	753	100.0
SQL*Net more data to client	109,5K	99.3	.4	.1	.0	.0	.2	.0
undo segment extension	4	100.0
class slave wait	21	100.0
DIAG idle wait	7124							100.0
dispatcher timer	60								100.0
i/o slave wait	240,3K	52.9	3.5	8.9	5.7	8.1	3.1	17.8
jobq slave wait	7676						.0	100.0
pmon timer	1237								100.0
rdbms ipc message	67,2K	34.0	3.7	9.6	6.3	9.3	3.7	16.4	17.0
SGA: MMAN sleep for component shrink	600	11.5	4.7	10.0	8.0	65.2	.7
shared server idle wait	120								100.0
smon timer	22							18.2	81.8
Space Manager: slave idle wait	722								100.0
SQL*Net message from client	145,2K	53.1	24.1	9.7	3.5	3.0	2.3	2.9	1.5
Streams AQ: qmn coordinator idle wait	258	49.6	.4						50.0
Streams AQ: qmn slave idle wait	129								100.0
Streams AQ: waiting for messages in the queue	722					.1			99.9
wait for unread message on broadcast channel	3584					.1	.2	99.8

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
ADR block file read	2	95.9	4.1
control file parallel write	4	99.8	.2
control file sequential read	85	98.6	1.0	.3	.0	.0
db file parallel read	42	64.4	16.1	8.5	8.5	1.7	.8
db file parallel write	16	100.0	.0	.0
db file scattered read	64	99.2	.6	.2	.1		.0	.0
db file sequential read	1299	99.0	.8	.2	.0	.0	.0	.0
db file single write	3	95.5	4.5
direct path read	375	99.8	.1	.0	.0	.0
Disk file operations I/O	246	68.7	13.6	14.4	2.8	.3	.3
enq: KO - fast object checkpoint	1	96.2	3.8
library cache lock	2	33.3		33.3				33.3
log file parallel write	6	100.0	.0	.0
log file switch (private strand flush incomplete)	3	25.0		50.0	25.0
log file sync	7	99.9	.0	.0
os thread startup	6	95.8	2.1		2.1
Parameter File I/O	6	96.3	3.8
read by other session	2	99.6		.2	.2
row cache lock	1		100.0
SQL*Net more data to client	23	100.0	.0	.0	.0	.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
WINMDB2	1,866	742	489	16,731
SYS$USERS	432	78	3,230	4,028
SYS$BACKGROUND	0	0	10	213
WINMDB2XDB	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
WINMDB2	148836	1067	166	2	252205	24
SYS$USERS	209910	309	7	0	2255	0
SYS$BACKGROUND	7880	33	160	2	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 40.3% of Total DB Time (s): 2,295
Captured PL/SQL account for 11.8% of Total DB Time (s): 2,295

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
110.01	29,232	0.00	4.79	96.70	2.94	cd0nwpf4hc43s		insert into objauth$(option$, ...
83.83	4	20.96	3.65	37.74	62.28	4nv7m8st2r4u2	PLSQLDev.exe	select s.synonym_name object_n...
57.22	23	2.49	2.49	95.85	1.02	d9jyjjctjjg05	wmtest.exe	begin WINMADMIN.PKG_USERFIRME....
50.70	6,321	0.01	2.21	1.88	97.91	3ktacv9r56b51		select owner#, name, namespace...
44.89	3,208	0.01	1.96	1.04	99.20	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
37.75	8	4.72	1.64	20.87	79.19	5k36dfnj59wc1	WinMMartor.exe	SELECT :"SYS_B_0" as V, b.TABL...
36.51	5,549	0.01	1.59	69.51	24.36	cm5vu20fhtnq1		select /*+ connect_by_filterin...
36.21	21	1.72	1.58	76.69	22.81	0v6pk7uv9trkp	wmtest.exe	begin WINMADMIN.PKG_USERFIRME....
35.10	60	0.59	1.53	14.04	86.67	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
31.41	13	2.42	1.37	58.80	41.28	6ms3kd9gxx3ph	WinMMartor.exe	WITH crs_constr AS (SELECT dic...
30.99	4,248	0.01	1.35	3.02	97.78	9wtuatndmcpad		update idl_ub1$ set piece#=:1 ...
30.54	6,034	0.01	1.33	1.33	98.67	f946p6b0qhh5t	oradim.exe	SELECT /*+ INDEX(sqlobj$ (sign...
29.79	8,695	0.00	1.30	3.04	97.23	db78fxqxwxt7r		select /+ rule / bucket, end...
29.58	6	4.93	1.29	40.98	58.69	cc95pcpwbnv0a	wmtest_5101.exe	begin BBBB.PKG_IESIRI.SP_GOTOR...
28.99	1,104	0.03	1.26	1.56	98.73	9gq78x8ns3q1x		select source from source$ whe...
24.72	120	0.21	1.08	95.86	0.00	2b064ybzkwf1y	OEM.SystemPool	BEGIN EMD_NOTIFICATION.QUEUE_R...
23.45	68,897	0.00	1.02	6.72	93.16	96g93hntrzjtr		select /+ rule / bucket_cnt,...

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 39.3% of Total CPU Time (s): 819
Captured PL/SQL account for 22.2% of Total CPU Time (s): 819

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
106.38	29,232	0.00	12.99	110.01	96.70	2.94	cd0nwpf4hc43s		insert into objauth$(option$, ...
54.85	23	2.38	6.70	57.22	95.85	1.02	d9jyjjctjjg05	wmtest.exe	begin WINMADMIN.PKG_USERFIRME....
31.64	4	7.91	3.86	83.83	37.74	62.28	4nv7m8st2r4u2	PLSQLDev.exe	select s.synonym_name object_n...
27.77	21	1.32	3.39	36.21	76.69	22.81	0v6pk7uv9trkp	wmtest.exe	begin WINMADMIN.PKG_USERFIRME....
25.38	5,549	0.00	3.10	36.51	69.51	24.36	cm5vu20fhtnq1		select /*+ connect_by_filterin...
23.70	120	0.20	2.89	24.72	95.86	0.00	2b064ybzkwf1y	OEM.SystemPool	BEGIN EMD_NOTIFICATION.QUEUE_R...
18.47	13	1.42	2.26	31.41	58.80	41.28	6ms3kd9gxx3ph	WinMMartor.exe	WITH crs_constr AS (SELECT dic...
16.60	14	1.19	2.03	19.27	86.13	13.35	bcsq5zh9ds763	wmtest.exe	begin BBBB.PKG_GLOBALS.CHECK_C...
15.05	4,388	0.00	1.84	15.22	98.90	0.45	8hbc8bsj1wd83	wmtest.exe	SELECT COUNT(*) FROM CONSTLUNA...
12.12	6	2.02	1.48	29.58	40.98	58.69	cc95pcpwbnv0a	wmtest_5101.exe	begin BBBB.PKG_IESIRI.SP_GOTOR...
8.63	16,110	0.00	1.05	9.31	92.63	2.16	db7404kj5jt39	DBMS_SCHEDULER	declare TYPE attrs_cur IS REF ...

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 42.6% of Total User I/O Wait Time (s): 1,408
Captured PL/SQL account for 6.0% of Total User I/O Wait Time (s): 1,408

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
52.21	4	13.05	3.71	83.83	37.74	62.28	4nv7m8st2r4u2	PLSQLDev.exe	select s.synonym_name object_n...
49.64	6,321	0.01	3.52	50.70	1.88	97.91	3ktacv9r56b51		select owner#, name, namespace...
44.53	3,208	0.01	3.16	44.89	1.04	99.20	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
30.42	60	0.51	2.16	35.10	14.04	86.67	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
30.30	4,248	0.01	2.15	30.99	3.02	97.78	9wtuatndmcpad		update idl_ub1$ set piece#=:1 ...
30.13	6,034	0.00	2.14	30.54	1.33	98.67	f946p6b0qhh5t	oradim.exe	SELECT /*+ INDEX(sqlobj$ (sign...
29.89	8	3.74	2.12	37.75	20.87	79.19	5k36dfnj59wc1	WinMMartor.exe	SELECT :"SYS_B_0" as V, b.TABL...
28.96	8,695	0.00	2.06	29.79	3.04	97.23	db78fxqxwxt7r		select /+ rule / bucket, end...
28.62	1,104	0.03	2.03	28.99	1.56	98.73	9gq78x8ns3q1x		select source from source$ whe...
21.85	68,897	0.00	1.55	23.45	6.72	93.16	96g93hntrzjtr		select /+ rule / bucket_cnt,...
19.33	3,208	0.01	1.37	19.59	2.15	98.66	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
17.36	6,321	0.00	1.23	17.95	2.78	96.70	8swypbbr0m372		select order#, columns, types ...
17.36	6	2.89	1.23	29.58	40.98	58.69	cc95pcpwbnv0a	wmtest_5101.exe	begin BBBB.PKG_IESIRI.SP_GOTOR...
16.42	3	5.47	1.17	18.19	8.15	90.29	gjyx4tg3j6jwu	WinMMartor.exe	SELECT :"SYS_B_0" as V, name, ...
15.91	12,928	0.00	1.13	16.63	3.94	95.66	6aq34nj2zb2n7		select col#, grantee#, privile...
14.26	8	1.78	1.01	17.20	15.69	82.91	1zqrq71g8twt9	WinMMartor.exe	SELECT :"SYS_B_0" as V, a.TABL...

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: 20,958,902
Captured SQL account for 45.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,609,519	12	134,126.58	7.68	7.63	87.54	11.18	bv38jz80qhjwf	wmtest.exe	select * from BBBB.V_const_gra...
1,577,637	4	394,409.25	7.53	83.83	37.74	62.28	4nv7m8st2r4u2	PLSQLDev.exe	select s.synonym_name object_n...
1,168,633	14	83,473.79	5.58	19.27	86.13	13.35	bcsq5zh9ds763	wmtest.exe	begin BBBB.PKG_GLOBALS.CHECK_C...
1,157,415	4,388	263.77	5.52	15.22	98.90	0.45	8hbc8bsj1wd83	wmtest.exe	SELECT COUNT(*) FROM CONSTLUNA...
860,077	2,212	388.82	4.10	9.00	80.58	12.20	fmbawhb7qwyhb	WMEnterprise10.exe	begin :RESULT := WINMADMIN.PKG...
774,843	8	96,855.38	3.70	37.75	20.87	79.19	5k36dfnj59wc1	WinMMartor.exe	SELECT :"SYS_B_0" as V, b.TABL...
488,425	23	21,235.87	2.33	57.22	95.85	1.02	d9jyjjctjjg05	wmtest.exe	begin WINMADMIN.PKG_USERFIRME....
447,711	29,232	15.32	2.14	110.01	96.70	2.94	cd0nwpf4hc43s		insert into objauth$(option$, ...
396,447	3,800	104.33	1.89	14.49	42.73	59.66	33cmj01uf5zfb		delete from col$ where obj#=:1
328,022	13	25,232.46	1.57	31.41	58.80	41.28	6ms3kd9gxx3ph	WinMMartor.exe	WITH crs_constr AS (SELECT dic...
300,083	21	14,289.67	1.43	36.21	76.69	22.81	0v6pk7uv9trkp	wmtest.exe	begin WINMADMIN.PKG_USERFIRME....
237,705	68,897	3.45	1.13	23.45	6.72	93.16	96g93hntrzjtr		select /+ rule / bucket_cnt,...
216,459	5,549	39.01	1.03	36.51	69.51	24.36	cm5vu20fhtnq1		select /*+ connect_by_filterin...

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: 3,729,829
Captured SQL account for 6.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
53,359	8	6,669.88	1.43	37.75	20.87	79.19	5k36dfnj59wc1	WinMMartor.exe	SELECT :"SYS_B_0" as V, b.TABL...
50,611	8	6,326.38	1.36	17.20	15.69	82.91	1zqrq71g8twt9	WinMMartor.exe	SELECT :"SYS_B_0" as V, a.TABL...
26,693	4	6,673.25	0.72	83.83	37.74	62.28	4nv7m8st2r4u2	PLSQLDev.exe	select s.synonym_name object_n...
25,628	4	6,407.00	0.69	9.64	23.13	78.08	356h0w5rdz7b6	WinMMartor.exe	SELECT CASE WHEN OBJECT_NAME L...
25,314	4	6,328.50	0.68	7.51	7.89	92.62	gsk2zxba11r9m	PLSQLDev.exe	select object_name, object_typ...
12,666	2	6,333.00	0.34	4.76	8.85	90.58	bj4y8cxr4zw7v	Oracle_Objects.exe	select * from user_objects ord...
6,231	3,208	1.94	0.17	44.89	1.04	99.20	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
5,445	6,321	0.86	0.15	50.70	1.88	97.91	3ktacv9r56b51		select owner#, name, namespace...
4,849	60	80.82	0.13	35.10	14.04	86.67	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
3,671	1,104	3.33	0.10	28.99	1.56	98.73	9gq78x8ns3q1x		select source from source$ whe...

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: 365,394
Captured SQL account for 16.7% of Total
Total UnOptimized Read Requests: 365,394
Captured SQL account for 16.7% 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
9,143	9,143	4	2,285.75	2.50	4nv7m8st2r4u2	PLSQLDev.exe	select s.synonym_name object_n...
6,157	6,157	3,208	1.92	1.69	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
5,983	5,983	8	747.88	1.64	5k36dfnj59wc1	WinMMartor.exe	SELECT :"SYS_B_0" as V, b.TABL...
5,437	5,437	6,321	0.86	1.49	3ktacv9r56b51		select owner#, name, namespace...
4,534	4,534	60	75.57	1.24	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
3,539	3,539	8,695	0.41	0.97	db78fxqxwxt7r		select /+ rule / bucket, end...
3,455	3,455	3	1,151.67	0.95	gjyx4tg3j6jwu	WinMMartor.exe	SELECT :"SYS_B_0" as V, name, ...
2,643	2,643	3,208	0.82	0.72	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
2,581	2,581	13	198.54	0.71	6ms3kd9gxx3ph	WinMMartor.exe	WITH crs_constr AS (SELECT dic...
2,426	2,426	8	303.25	0.66	1zqrq71g8twt9	WinMMartor.exe	SELECT :"SYS_B_0" as V, a.TABL...

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: 1,114,376
Captured SQL account for 48.3% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
68,897	30,191	0.44	23.45	6.72	93.16	96g93hntrzjtr		select /+ rule / bucket_cnt,...
53,554	1,679	0.03	11.45	11.44	87.44	3g7sxtj9d6zd3		select privilege#, nvl(col#, 0...
32,248	23,780	0.74	4.18	23.52	68.94	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
32,222	32,222	1.00	3.15	94.00	1.57	bcv9qynmu1nv9	DBMS_SCHEDULER	select sys.dbms_standard.dicti...
29,232	9,524	0.33	110.01	96.70	2.94	cd0nwpf4hc43s		insert into objauth$(option$, ...
19,964	19,964	1.00	0.83	94.30	0.00	2skwhauh2cwky		select o.name, u.name from obj...
19,862	19,862	1.00	3.89	57.31	46.23	2h0gb24h6zpnu		insert into access$(d_obj#, or...
16,112	16,112	1.00	6.95	89.73	10.42	8cc6ny309xt6b	WinMService.exe	declare TYPE attrs_cur IS REF ...
16,110	16,110	1.00	9.31	92.63	2.16	db7404kj5jt39	DBMS_SCHEDULER	declare TYPE attrs_cur IS REF ...
15,360	15,360	1.00	2.54	76.11	23.01	4yyb4104skrwj	DBMS_SCHEDULER	update obj$ set obj#=:4, type#...
14,642	14,642	1.00	8.55	24.83	74.00	c49tbx3qqrtm4		insert into dependency$(d_obj#...
14,330	140,076	9.78	6.08	21.54	78.12	2q93zsrvbdw48		select grantee#, privilege#, n...
13,474	171,367	12.72	6.08	31.03	65.88	83taa7kaw59c1		select name, intcol#, segcol#,...
12,928	0	0.00	16.63	3.94	95.66	6aq34nj2zb2n7		select col#, grantee#, privile...
12,611	12	0.00	0.49	88.98	0.00	7gtztzv329wg0		select c.name, u.name from con...
12,502	12,502	1.00	4.85	58.53	44.18	60uw2vh6q9vn2		insert into col$(obj#, name, i...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 640,615
Captured SQL account for 43.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
32,222	32,222	5.03	bcv9qynmu1nv9	DBMS_SCHEDULER	select sys.dbms_standard.dicti...
19,964	19,964	3.12	2skwhauh2cwky		select o.name, u.name from obj...
16,112	16,112	2.52	8cc6ny309xt6b	WinMService.exe	declare TYPE attrs_cur IS REF ...
16,110	16,110	2.51	db7404kj5jt39	DBMS_SCHEDULER	declare TYPE attrs_cur IS REF ...
12,611	12,611	1.97	7gtztzv329wg0		select c.name, u.name from con...
11,423	15,360	1.78	4yyb4104skrwj	DBMS_SCHEDULER	update obj$ set obj#=:4, type#...
10,954	29,232	1.71	cd0nwpf4hc43s		insert into objauth$(option$, ...
10,386	32,248	1.62	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
9,574	9,574	1.49	2z6kunvx470rr	wmtest.exe	select SYS_CONTEXT(:"SYS_B_0",...
8,334	8,334	1.30	gdhz78y24tvnz		delete from ncomp_dll$ where o...
8,067	14,330	1.26	2q93zsrvbdw48		select grantee#, privilege#, n...
7,723	7,723	1.21	9tgj4g8y4rwy8		select type#, blocks, extents,...
6,679	6,679	1.04	47y3mqvyhpkvs	oradim.exe	SELECT obj_type, plan_id, name...
6,671	12,928	1.04	6aq34nj2zb2n7		select col#, grantee#, privile...
6,580	13,474	1.03	83taa7kaw59c1		select name, intcol#, segcol#,...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,074,148	34	0.18	gkd8wxzcu66f7	wmtest.exe	UPDATE TMP_CONTRACT C SET FACT...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
23	42	a5ghc487ryrv2	WinMService.exe	SELECT COUNT(*) FROM FIRMALUNI

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0v6pk7uv9trkp begin WINMADMIN.PKG_USERFIRME.SETUSERINFO(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); end;

1zqrq71g8twt9 SELECT :"SYS_B_0" as V, a.TABLE_NAME FROM ALL_TABLES a WHERE a.temporary = :"SYS_B_1" and a.owner = :"SYS_B_2" ORDER BY a.TABLE_NAME

2b064ybzkwf1y BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;

2h0gb24h6zpnu insert into access$(d_obj#, order#, columns, types) values (:1, :2, :3, :4)

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

2skwhauh2cwky select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#

2z6kunvx470rr select SYS_CONTEXT(:"SYS_B_0", :"SYS_B_1") from dual

33cmj01uf5zfb delete from col$ where obj#=:1

356h0w5rdz7b6 SELECT CASE WHEN OBJECT_NAME LIKE :"SYS_B_0" THEN :"SYS_B_1" ELSE OBJECT_TYPE END OBJECT_TYPE, OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER=:"SYS_B_2" AND OBJECT_TYPE NOT IN (:"SYS_B_3", :"SYS_B_4") ORDER BY OBJECT_TYPE, OBJECT_NAME

39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#

3g7sxtj9d6zd3 select privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 and grantee#=:2 group by privilege#, nvl(col#, 0)

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

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

47y3mqvyhpkvs SELECT obj_type, plan_id, name, flags, last_executed FROM sqlobj$ WHERE signature = :1 AND category = :2

4nv7m8st2r4u2 select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in (:"SYS_B_0", user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in (:"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6", :"SYS_B_7")

4yyb4104skrwj update obj$ set obj#=:4, type#=:5, ctime=:6, mtime=:7, stime=:8, status=:9, dataobj#=:10, flags=:11, oid$=:12, spare1=:13, spare2=:14 where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

5k36dfnj59wc1 SELECT :"SYS_B_0" as V, b.TABLE_NAME, b.COLUMN_NAME, b.DATA_TYPE, b.DATA_LENGTH, b.DATA_PRECISION, b.DATA_SCALE, b.NULLABLE FROM All_Tables a INNER JOIN ALL_TAB_COLUMNS b ON a.table_name = b.TABLE_NAME AND a.owner = b.OWNER WHERE a.temporary = :"SYS_B_1" AND a.owner = :"SYS_B_2" ORDER BY b.TABLE_NAME, b.COLUMN_ID

60uw2vh6q9vn2 insert into col$(obj#, name, intcol#, segcol#, type#, length, precision#, scale, null$, offset, fixedstorage, segcollength, deflength, default$, col#, property, charsetid, charsetform, spare1, spare2, spare3)values(:1, :2, :3, :4, :5, :6, decode(:5, 182/*DTYIYM*/, :7, 183/*DTYIDS*/, :7, decode(:7, 0, null, :7)), decode(:5, 2, decode(:8, -127/*MAXSB1MINAL*/, null, :8), 178, :8, 179, :8, 180, :8, 181, :8, 182, :8, 183, :8, 231, :8, null), :9, 0, :10, :11, decode(:12, 0, null, :12), :13, :14, :15, :16, :17, :18, :19, :20)

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

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

6ms3kd9gxx3ph WITH crs_constr AS (SELECT dict.table_name, dict.constraint_name, dict.constraint_type, dict.R_Constraint_name, dict.delete_rule, dict.search_condition FROM All_Constraints dict WHERE dict.owner = :"SYS_B_00" AND dict.GENERATED = :"SYS_B_01" ), crs_cols AS ( SELECT dict.column_name, dict.position, dict.constraint_name FROM All_Cons_Columns dict WHERE dict.owner = :"SYS_B_02") SELECT :"SYS_B_03" as V, c.TABLE_NAME, cc.column_name, cc.position ColPos, c.CONSTRAINT_NAME, c.CONSTRAINT_TYPE, NVL(c.R_CONSTRAINT_NAME, :"SYS_B_04") R_CONSTRAINT_NAME, NVL(c.DELETE_RULE, :"SYS_B_05") DELETE_RULE, rc.table_name r_table_name, cr.r_column_name, cr.position r_colpos, c.SEARCH_CONDITION FROM crs_constr c, crs_constr rc, crs_cols cc, (select cc.constraint_name, cc.column_name r_column_name, cc.position FROM crs_constr rc, crs_cols cc WHERE rc.constraint_name = cc.constraint_name and cc.position is not null ) cr WHERE c.constraint_name = cc.constraint_name and c.r_constraint_name = rc.constraint_name(+) AND rc.constraint_name = cr.constraint_name(+) ORDER BY DECODE(c.CONSTRAINT_TYPE, :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", :"SYS_B_12", :"SYS_B_13") , c.TABLE_NAME, c.CONSTRAINT_NAME, ColPos

7gtztzv329wg0 select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#

83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#

8cc6ny309xt6b declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_stmt varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt1 varchar2(512); m_var varchar2(512); m_o_stmt VARCHAR2(5120); PRAGMA AUTONOMOUS_TRANSACTION; begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'', ''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select SYS_CONTEXT(''USERENV'', ''CURRENT_USER'') from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; m_stmt:='select sdo_geor_def.getSqlText from dual'; execute immediate m_stmt into m_o_stmt; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='select column_name from dba_tab_columns where owner=:1 and table_name=:2'; open m_cur for m_stmt using m_owner, m_name; loop fetch m_cur into m_column; exit when m_cur%NOTFOUND; m_stmt:='select sdo_geor_def.isDropColumn(:1) from dual'; execute immediate m_stmt into m_stmt1 using SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_column); if (trim(m_stmt1)='TRUE') then m_stmt:='begin sdo_geor_def.doAlterDropColumn(:1, :2, :3); end;'; execute immediate m_stmt using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_column); end if; end loop; end if; if (m_event='DROP' and m_type='USER') then m_stmt:='insert into sdo_geor_ddl__table$$ values (1)'; EXECUTE IMMEDIATE m_stmt; commit; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='select count(*) from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_NAME=:2'; EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner, m_name; if(m_cnt!=0) then m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if((m_cnt=0)and (m_user!='SYS' and m_user!='SYSTEM' and m_user!='MDSYS'and m_owner!='MDSYS' and m_owner!='SYS')) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be dropped.'')'; execute immediate m_stmt; end if; end if; m_stmt:='insert into sdo_geor_ddl__table$$ values (2)'; EXECUTE IMMEDIATE m_stmt; commit; end if; if(m_user='SYS' or m_user='SYSTEM' or m_user='MDSYS' or m_owner='MDSYS' or m_o wner='SYS') then return; end if; if (m_event='RENAME' and m_type='TABLE') then m_stmt:='select count(*) from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_NAME=:2'; EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner, m_name; if(m_cnt!=0) then m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be renamed directly.'')'; execute immediate m_stmt; end if; end if; end if; if (m_type='TRIGGER' and m_event='DROP') then m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1, ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be dropped.'')'; execute immediate m_stmt; end if; end if; if (m_type='TRIGGER' and m_event='ALTER') then m_o_stmt:=upper(trim(m_o_stmt)); if(instr(m_o_stmt, ' COMPILE ')>0 or instr(m_o_stmt, ' ENABLE ')>0 or substr(m_o_stmt, length(m_o_stmt)-8, 8)=' COMPILE' or substr(m_o_stmt, length(m_o_stmt)-7, 7)=' ENABLE' ) then return; end if; m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1 , ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be altered.'')'; execute immediate m_stmt; end if; end if; if (m_type='TRIGGER' and m_event='CREATE') then m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1, ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster reserved names cannot be used to create regular triggers.'')'; execute immediate m_stmt; end if; end if; Exception when others then if(sqlcode=-13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt, 11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, '''||m_stmt||''')'; execute immediate m_stmt; end if; end;

8hbc8bsj1wd83 SELECT COUNT(*) FROM CONSTLUNA WHERE CODCONST1 = :B1 AND USERID = PKG_GLOBALS.GETUSERID

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

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

9gq78x8ns3q1x select source from source$ where obj#=:1 order by line

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

9wtuatndmcpad update idl_ub1$ set piece#=:1 , length=:2 , piece=:3 where obj#=:4 and part=:5 and piece#=:6 and version=:7

a5ghc487ryrv2 SELECT COUNT(*) FROM FIRMALUNI

bcsq5zh9ds763 begin BBBB.PKG_GLOBALS.CHECK_CONSTANTE_USER; end;

bcv9qynmu1nv9 select sys.dbms_standard.dictionary_obj_type from dual

bj4y8cxr4zw7v select * from user_objects order by object_Name

bv38jz80qhjwf select * from BBBB.V_const_gramada

c49tbx3qqrtm4 insert into dependency$(d_obj#, d_timestamp, order#, p_obj#, p_timestamp, property, d_attrs)values (:1, :2, :3, :4, :5, :6, :7)

cc95pcpwbnv0a begin BBBB.PKG_IESIRI.SP_GOTORECORD(:1); end;

cd0nwpf4hc43s insert into objauth$(option$, grantor#, obj#, privilege#, grantee#, col#, sequence#) values(decode(:1, 0, null, :1), :2, :3, :4, :5, decode(:6, 0, null, :6), object_grant.nextval)

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

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

d9jyjjctjjg05 begin WINMADMIN.PKG_USERFIRME.SETGRANTS(:1, :2); end;

db7404kj5jt39 declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt varchar2(512); m_ret varchar2(3000); m_ret1 varchar2(512); m_o_stmt VARCHAR2(5120); begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'', ''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select sys.dbms_standard.login_user from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='CREATE') then m_stmt:='select sdo_geor_def.listAllGeoRasterFieldsStr(:1, :2) from dual'; execute immediate m_stmt into m_ret using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name); m_ret:=trim(m_ret); while (length(m_ret)!=0) loop if (instr(m_ret, ' $$__## ')!=0) t hen m_ret1:=trim(substr(m_ret, 1, instr(m_ret, ' $$__## ')-1)); m_ret:=trim(substr(m_ret, instr(m_ret, ' $$__## ')+8)); else m_ret1:=trim(m_ret); m_ret:=''; end if; m_stmt:='begin SDO_GEOR_UTL.createDMLTrigger(:1, :2); end;'; execute immediate m_stmt using m_owner||'.'||m_name, SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME(m_ret1); end loop; return; end if; if (m_name!='MDSYS' and m_type='USER' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='TRUNCATE') then m_stmt:='call sdo_geor_def.doTruncateTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='call sdo_geor_def.doAlterRenameTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='RENAME') then m_stmt:='call sdo_geor_def.doRenameTable()'; execute immediate m_stmt; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='delete from sdo_geor_ddl__table$$ where id=2'; EXECUTE IMMEDIATE m_stmt; end if; if (m_type='USER' and m_event='DROP') then m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; end if; Exception when others then if(sqlcode=-13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt, 11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, '''||m_stmt||''')'; execute immediate m_stmt; end if; end;

db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

f946p6b0qhh5t SELECT /*+ INDEX(sqlobj$ (signature category obj_type plan_id)) */ DISTINCT category FROM sqlobj$ WHERE signature = :1

fmbawhb7qwyhb begin :RESULT := WINMADMIN.PKG_SETTASK.TASKURI_NOI(:2); end;

gdhz78y24tvnz delete from ncomp_dll$ where obj#=:1 returning dllname into :2

gjyx4tg3j6jwu SELECT :"SYS_B_0" as V, name, type, line, text FROM all_source WHERE type = :"SYS_B_1" AND owner = :"SYS_B_2" AND NAME <= :"SYS_B_3" ORDER BY name, line

gkd8wxzcu66f7 UPDATE TMP_CONTRACT C SET FACTURAT = (SELECT MAX(NVL(FACTURAT, 0)) FROM TMP_CONTRACT2 WHERE CODCONTRACT = C.CODCONTRACT), VALOARE = (SELECT SUM(VALOARE * (1 + NVL(PROCDISC, 0) / 100)) + SUM(NVL(TVA, 0) * (1 + NVL(PROCDISC, 0) / 100)) FROM TMP_CONTRACT1 WHERE CODCONTRACT = C.CODCONTRACT), VALDISC = (SELECT SUM(VALOARE * NVL(PROCDISC, 0) / 100) + SUM(NVL(TVA, 0) * NVL(PROCDISC, 0) / 100) FROM TMP_CONTRACT1 WHERE CODCONTRACT = C.CODCONTRACT), SOLDPART = DECODE(C.TIPDOC, 10, -1, 27, 1, 0 ) * (SELECT SUM(NVL(SOLDLEI, 0)) FROM V_SOLDPART WHERE CODPART = C.PARTENER)

gsk2zxba11r9m select object_name, object_type from sys.user_objects o where o.object_type in (:"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6")

SQL Id	SQL Text
0v6pk7uv9trkp	begin WINMADMIN.PKG_USERFIRME.SETUSERINFO(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); end;
1zqrq71g8twt9	SELECT :"SYS_B_0" as V, a.TABLE_NAME FROM ALL_TABLES a WHERE a.temporary = :"SYS_B_1" and a.owner = :"SYS_B_2" ORDER BY a.TABLE_NAME
2b064ybzkwf1y	BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
2h0gb24h6zpnu	insert into access$(d_obj#, order#, columns, types) values (:1, :2, :3, :4)
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2skwhauh2cwky	select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
2z6kunvx470rr	select SYS_CONTEXT(:"SYS_B_0", :"SYS_B_1") from dual
33cmj01uf5zfb	delete from col$ where obj#=:1
356h0w5rdz7b6	SELECT CASE WHEN OBJECT_NAME LIKE :"SYS_B_0" THEN :"SYS_B_1" ELSE OBJECT_TYPE END OBJECT_TYPE, OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER=:"SYS_B_2" AND OBJECT_TYPE NOT IN (:"SYS_B_3", :"SYS_B_4") ORDER BY OBJECT_TYPE, OBJECT_NAME
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3g7sxtj9d6zd3	select privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 and grantee#=:2 group by privilege#, nvl(col#, 0)
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3nkd3g3ju5ph1	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
47y3mqvyhpkvs	SELECT obj_type, plan_id, name, flags, last_executed FROM sqlobj$ WHERE signature = :1 AND category = :2
4nv7m8st2r4u2	select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in (:"SYS_B_0", user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in (:"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6", :"SYS_B_7")
4yyb4104skrwj	update obj$ set obj#=:4, type#=:5, ctime=:6, mtime=:7, stime=:8, status=:9, dataobj#=:10, flags=:11, oid$=:12, spare1=:13, spare2=:14 where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
5k36dfnj59wc1	SELECT :"SYS_B_0" as V, b.TABLE_NAME, b.COLUMN_NAME, b.DATA_TYPE, b.DATA_LENGTH, b.DATA_PRECISION, b.DATA_SCALE, b.NULLABLE FROM All_Tables a INNER JOIN ALL_TAB_COLUMNS b ON a.table_name = b.TABLE_NAME AND a.owner = b.OWNER WHERE a.temporary = :"SYS_B_1" AND a.owner = :"SYS_B_2" ORDER BY b.TABLE_NAME, b.COLUMN_ID
60uw2vh6q9vn2	insert into col$(obj#, name, intcol#, segcol#, type#, length, precision#, scale, null$, offset, fixedstorage, segcollength, deflength, default$, col#, property, charsetid, charsetform, spare1, spare2, spare3)values(:1, :2, :3, :4, :5, :6, decode(:5, 182/DTYIYM/, :7, 183/DTYIDS/, :7, decode(:7, 0, null, :7)), decode(:5, 2, decode(:8, -127/MAXSB1MINAL/, null, :8), 178, :8, 179, :8, 180, :8, 181, :8, 182, :8, 183, :8, 231, :8, null), :9, 0, :10, :11, decode(:12, 0, null, :12), :13, :14, :15, :16, :17, :18, :19, :20)
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6ms3kd9gxx3ph	WITH crs_constr AS (SELECT dict.table_name, dict.constraint_name, dict.constraint_type, dict.R_Constraint_name, dict.delete_rule, dict.search_condition FROM All_Constraints dict WHERE dict.owner = :"SYS_B_00" AND dict.GENERATED = :"SYS_B_01" ), crs_cols AS ( SELECT dict.column_name, dict.position, dict.constraint_name FROM All_Cons_Columns dict WHERE dict.owner = :"SYS_B_02") SELECT :"SYS_B_03" as V, c.TABLE_NAME, cc.column_name, cc.position ColPos, c.CONSTRAINT_NAME, c.CONSTRAINT_TYPE, NVL(c.R_CONSTRAINT_NAME, :"SYS_B_04") R_CONSTRAINT_NAME, NVL(c.DELETE_RULE, :"SYS_B_05") DELETE_RULE, rc.table_name r_table_name, cr.r_column_name, cr.position r_colpos, c.SEARCH_CONDITION FROM crs_constr c, crs_constr rc, crs_cols cc, (select cc.constraint_name, cc.column_name r_column_name, cc.position FROM crs_constr rc, crs_cols cc WHERE rc.constraint_name = cc.constraint_name and cc.position is not null ) cr WHERE c.constraint_name = cc.constraint_name and c.r_constraint_name = rc.constraint_name(+) AND rc.constraint_name = cr.constraint_name(+) ORDER BY DECODE(c.CONSTRAINT_TYPE, :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", :"SYS_B_12", :"SYS_B_13") , c.TABLE_NAME, c.CONSTRAINT_NAME, ColPos
7gtztzv329wg0	select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8cc6ny309xt6b	declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_stmt varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt1 varchar2(512); m_var varchar2(512); m_o_stmt VARCHAR2(5120); PRAGMA AUTONOMOUS_TRANSACTION; begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'', ''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select SYS_CONTEXT(''USERENV'', ''CURRENT_USER'') from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; m_stmt:='select sdo_geor_def.getSqlText from dual'; execute immediate m_stmt into m_o_stmt; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='select column_name from dba_tab_columns where owner=:1 and table_name=:2'; open m_cur for m_stmt using m_owner, m_name; loop fetch m_cur into m_column; exit when m_cur%NOTFOUND; m_stmt:='select sdo_geor_def.isDropColumn(:1) from dual'; execute immediate m_stmt into m_stmt1 using SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_column); if (trim(m_stmt1)='TRUE') then m_stmt:='begin sdo_geor_def.doAlterDropColumn(:1, :2, :3); end;'; execute immediate m_stmt using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_column); end if; end loop; end if; if (m_event='DROP' and m_type='USER') then m_stmt:='insert into sdo_geor_ddl__table$$ values (1)'; EXECUTE IMMEDIATE m_stmt; commit; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='select count() from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_NAME=:2'; EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner, m_name; if(m_cnt!=0) then m_stmt:='select count() from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if((m_cnt=0)and (m_user!='SYS' and m_user!='SYSTEM' and m_user!='MDSYS'and m_owner!='MDSYS' and m_owner!='SYS')) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be dropped.'')'; execute immediate m_stmt; end if; end if; m_stmt:='insert into sdo_geor_ddl__table$$ values (2)'; EXECUTE IMMEDIATE m_stmt; commit; end if; if(m_user='SYS' or m_user='SYSTEM' or m_user='MDSYS' or m_owner='MDSYS' or m_o wner='SYS') then return; end if; if (m_event='RENAME' and m_type='TABLE') then m_stmt:='select count() from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_NAME=:2'; EXECUTE IMMEDIATE m_stmt into m_cnt using m_owner, m_name; if(m_cnt!=0) then m_stmt:='select count() from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''The referenced raster data table(RDT) cannot be renamed directly.'')'; execute immediate m_stmt; end if; end if; end if; if (m_type='TRIGGER' and m_event='DROP') then m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1, ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count() from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be dropped.'')'; execute immediate m_stmt; end if; end if; if (m_type='TRIGGER' and m_event='ALTER') then m_o_stmt:=upper(trim(m_o_stmt)); if(instr(m_o_stmt, ' COMPILE ')>0 or instr(m_o_stmt, ' ENABLE ')>0 or substr(m_o_stmt, length(m_o_stmt)-8, 8)=' COMPILE' or substr(m_o_stmt, length(m_o_stmt)-7, 7)=' ENABLE' ) then return; end if; m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1 , ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count() from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster DML triggers cannot be altered.'')'; execute immediate m_stmt; end if; end if; if (m_type='TRIGGER' and m_event='CREATE') then m_stmt:='select REGEXP_SUBSTR(:1, ''GRDMLTR_.+'', 1, 1, ''i'') from dual'; EXECUTE IMMEDIATE m_stmt into m_var using m_name; if(m_var is null) then return; end if; m_stmt:='select count(*) from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt into m_cnt; if(m_cnt=0) then m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, ''GeoRaster reserved names cannot be used to create regular triggers.'')'; execute immediate m_stmt; end if; end if; Exception when others then if(sqlcode=-13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt, 11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, '''\|\|m_stmt\|\|''')'; execute immediate m_stmt; end if; end;
8hbc8bsj1wd83	SELECT COUNT(*) FROM CONSTLUNA WHERE CODCONST1 = :B1 AND USERID = PKG_GLOBALS.GETUSERID
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9gq78x8ns3q1x	select source from source$ where obj#=:1 order by line
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
9wtuatndmcpad	update idl_ub1$ set piece#=:1 , length=:2 , piece=:3 where obj#=:4 and part=:5 and piece#=:6 and version=:7
a5ghc487ryrv2	SELECT COUNT(*) FROM FIRMALUNI
bcsq5zh9ds763	begin BBBB.PKG_GLOBALS.CHECK_CONSTANTE_USER; end;
bcv9qynmu1nv9	select sys.dbms_standard.dictionary_obj_type from dual
bj4y8cxr4zw7v	select * from user_objects order by object_Name
bv38jz80qhjwf	select * from BBBB.V_const_gramada
c49tbx3qqrtm4	insert into dependency$(d_obj#, d_timestamp, order#, p_obj#, p_timestamp, property, d_attrs)values (:1, :2, :3, :4, :5, :6, :7)
cc95pcpwbnv0a	begin BBBB.PKG_IESIRI.SP_GOTORECORD(:1); end;
cd0nwpf4hc43s	insert into objauth$(option$, grantor#, obj#, privilege#, grantee#, col#, sequence#) values(decode(:1, 0, null, :1), :2, :3, :4, :5, decode(:6, 0, null, :6), object_grant.nextval)
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d9jyjjctjjg05	begin WINMADMIN.PKG_USERFIRME.SETGRANTS(:1, :2); end;
db7404kj5jt39	declare TYPE attrs_cur IS REF CURSOR; m_cur attrs_cur; m_event varchar2(512); m_user varchar2(512); m_owner varchar2(512); m_user1 varchar2(512); m_type varchar2(512); m_name varchar2(5120); m_column varchar2(5120); m_cnt NUMBER; m_stmt varchar2(512); m_ret varchar2(3000); m_ret1 varchar2(512); m_o_stmt VARCHAR2(5120); begin m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual'; execute immediate m_stmt into m_type; if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER')) then return; end if; m_stmt:='select sys.dbms_standard.sysevent from dual'; execute immediate m_stmt into m_event; m_stmt:='select SYS_CONTEXT(''USERENV'', ''SESSION_USER'') from dual'; execute immediate m_stmt into m_user; m_stmt:='select sys.dbms_standard.login_user from dual'; execute immediate m_stmt into m_user1; m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual'; execute immediate m_stmt into m_owner; m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual'; execute immediate m_stmt into m_name; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='CREATE') then m_stmt:='select sdo_geor_def.listAllGeoRasterFieldsStr(:1, :2) from dual'; execute immediate m_stmt into m_ret using SYS.DBMS_ASSERT.SCHEMA_NAME(m_owner), SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(m_name); m_ret:=trim(m_ret); while (length(m_ret)!=0) loop if (instr(m_ret, ' $$__## ')!=0) t hen m_ret1:=trim(substr(m_ret, 1, instr(m_ret, ' $$__## ')-1)); m_ret:=trim(substr(m_ret, instr(m_ret, ' $$__## ')+8)); else m_ret1:=trim(m_ret); m_ret:=''; end if; m_stmt:='begin SDO_GEOR_UTL.createDMLTrigger(:1, :2); end;'; execute immediate m_stmt using m_owner\|\|'.'\|\|m_name, SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME(m_ret1); end loop; return; end if; if (m_name!='MDSYS' and m_type='USER' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='DROP') then m_stmt:='call sdo_geor_def.doDropUserAndTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='TRUNCATE') then m_stmt:='call sdo_geor_def.doTruncateTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='ALTER') then m_stmt:='call sdo_geor_def.doAlterRenameTable()'; execute immediate m_stmt; end if; if (m_owner!='MDSYS' and m_owner!='SYS' and m_type='TABLE' and m_event='RENAME') then m_stmt:='call sdo_geor_def.doRenameTable()'; execute immediate m_stmt; end if; if (m_event='DROP' and m_type='TABLE') then m_stmt:='delete from sdo_geor_ddl__table$$ where id=2'; EXECUTE IMMEDIATE m_stmt; end if; if (m_type='USER' and m_event='DROP') then m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; end if; Exception when others then if(sqlcode=-13391) then m_stmt:=sqlerrm; m_stmt:=substr(m_stmt, 11); m_stmt:='call mderr.raise_md_error(''MD'', ''SDO'', -13391, '''\|\|m_stmt\|\|''')'; execute immediate m_stmt; end if; end;
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
f946p6b0qhh5t	SELECT /+ INDEX(sqlobj$ (signature category obj_type plan_id)) / DISTINCT category FROM sqlobj$ WHERE signature = :1
fmbawhb7qwyhb	begin :RESULT := WINMADMIN.PKG_SETTASK.TASKURI_NOI(:2); end;
gdhz78y24tvnz	delete from ncomp_dll$ where obj#=:1 returning dllname into :2
gjyx4tg3j6jwu	SELECT :"SYS_B_0" as V, name, type, line, text FROM all_source WHERE type = :"SYS_B_1" AND owner = :"SYS_B_2" AND NAME <= :"SYS_B_3" ORDER BY name, line
gkd8wxzcu66f7	UPDATE TMP_CONTRACT C SET FACTURAT = (SELECT MAX(NVL(FACTURAT, 0)) FROM TMP_CONTRACT2 WHERE CODCONTRACT = C.CODCONTRACT), VALOARE = (SELECT SUM(VALOARE * (1 + NVL(PROCDISC, 0) / 100)) + SUM(NVL(TVA, 0) * (1 + NVL(PROCDISC, 0) / 100)) FROM TMP_CONTRACT1 WHERE CODCONTRACT = C.CODCONTRACT), VALDISC = (SELECT SUM(VALOARE * NVL(PROCDISC, 0) / 100) + SUM(NVL(TVA, 0) * NVL(PROCDISC, 0) / 100) FROM TMP_CONTRACT1 WHERE CODCONTRACT = C.CODCONTRACT), SOLDPART = DECODE(C.TIPDOC, 10, -1, 27, 1, 0 ) * (SELECT SUM(NVL(SOLDLEI, 0)) FROM V_SOLDPART WHERE CODPART = C.PARTENER)
gsk2zxba11r9m	select object_name, object_type from sys.user_objects o where o.object_type in (:"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6")

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
active txn count during cleanout	4,059	1.12	0.37
application wait time	16	0.00	0.00
background checkpoints completed	6	0.00	0.00
background checkpoints started	5	0.00	0.00
background timeouts	15,083	4.17	1.37
Batched IO block miss count	1,611	0.45	0.15
Batched IO (bound) vector count	204	0.06	0.02
Batched IO buffer defrag count	6	0.00	0.00
Batched IO double miss count	70	0.02	0.01
Batched IO (full) vector count	0	0.00	0.00
Batched IO same unit count	839	0.23	0.08
Batched IO single block count	103	0.03	0.01
Batched IO slow jump count	1,611	0.45	0.15
Batched IO (space) vector count	0	0.00	0.00
Batched IO vector block count	664	0.18	0.06
Batched IO vector read count	121	0.03	0.01
Block Cleanout Optim referenced	184	0.05	0.02
branch node splits	0	0.00	0.00
buffer is not pinned count	7,379,171	2,041.68	671.87
buffer is pinned count	33,758,093	9,340.22	3,073.67
bytes received via SQL*Net from client	23,285,356	6,442.61	2,120.13
bytes sent via SQL*Net to client	477,475,326	132,108.34	43,474.03
Cached Commit SCN referenced	96	0.03	0.01
calls to get snapshot scn: kcmgss	1,058,987	293.00	96.42
calls to kcmgas	123,874	34.27	11.28
calls to kcmgcs	248,452	68.74	22.62
CCursor + sql area evicted	486	0.13	0.04
cell physical IO interconnect bytes	31,668,633,088	8,762,108.07	2,883,422.84
change write time	3,496	0.97	0.32
cleanout - number of ktugct calls	7,335	2.03	0.67
cleanouts and rollbacks - consistent read gets	97	0.03	0.01
cleanouts only - consistent read gets	3,285	0.91	0.30
cluster key scan block gets	876,328	242.46	79.79
cluster key scans	512,804	141.88	46.69
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	4	0.00	0.00
commit batch/immediate requested	4	0.00	0.00
commit cleanout failures: block lost	4,867	1.35	0.44
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	170	0.05	0.02
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	171,537	47.46	15.62
commit cleanouts successfully completed	166,500	46.07	15.16
commit immediate performed	4	0.00	0.00
commit immediate requested	4	0.00	0.00
Commit SCN cached	1	0.00	0.00
commit txn count during cleanout	13,066	3.62	1.19
concurrency wait time	362	0.10	0.03
consistent changes	65,490	18.12	5.96
consistent gets	18,460,050	5,107.54	1,680.78
consistent gets - examination	2,830,015	783.01	257.67
consistent gets direct	3,562,039	985.55	324.32
consistent gets from cache	14,898,011	4,122.00	1,356.46
consistent gets from cache (fastpath)	8,293,930	2,294.77	755.16
CPU used by this session	80,626	22.31	7.34
CPU used when call started	78,129	21.62	7.11
CR blocks created	466	0.13	0.04
cursor authentications	3,726	1.03	0.34
data blocks consistent reads - undo records applied	2,294	0.63	0.21
db block changes	2,202,941	609.51	200.58
db block gets	2,498,799	691.37	227.52
db block gets direct	141	0.04	0.01
db block gets from cache	2,498,658	691.33	227.50
db block gets from cache (fastpath)	588,187	162.74	53.55
DB time	1,334,456	369.22	121.50
DBWR checkpoint buffers written	20,045	5.55	1.83
DBWR checkpoints	44	0.01	0.00
DBWR object drop buffers written	14	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	604	0.17	0.05
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	113	0.03	0.01
DBWR undo block writes	20,307	5.62	1.85
deferred (CURRENT) block cleanout applications	63,266	17.50	5.76
dirty buffers inspected	12,746	3.53	1.16
enqueue conversions	5,710	1.58	0.52
enqueue deadlocks	0	0.00	0.00
enqueue releases	307,818	85.17	28.03
enqueue requests	307,495	85.08	28.00
enqueue timeouts	0	0.00	0.00
enqueue waits	46	0.01	0.00
exchange deadlocks	0	0.00	0.00
execute count	1,114,376	308.33	101.46
failed probes on index block reclamation	0	0.00	0.00
file io service time	2,846	0.79	0.26
file io wait time	1,035,409,294	286,478.05	94,273.81
free buffer inspected	194,153	53.72	17.68
free buffer requested	213,042	58.94	19.40
heap block compress	4,563	1.26	0.42
Heap Segment Array Inserts	6,408	1.77	0.58
Heap Segment Array Updates	361	0.10	0.03
hot buffers moved to head of LRU	107,259	29.68	9.77
HSC Compressed Segment Block Changes	0	0.00	0.00
HSC Heap Segment Block Changes	456,783	126.38	41.59
HSC IDL Compressed Blocks	0	0.00	0.00
HSC OLTP positive compression	0	0.00	0.00
HSC OLTP recursive compression	0	0.00	0.00
HSC OLTP Space Saving	0	0.00	0.00
immediate (CR) block cleanout applications	3,382	0.94	0.31
immediate (CURRENT) block cleanout applications	21,704	6.01	1.98
IMU commits	2,290	0.63	0.21
IMU contention	33	0.01	0.00
IMU CR rollbacks	358	0.10	0.03
IMU- failed to get a private strand	62	0.02	0.01
IMU Flushes	3,905	1.08	0.36
IMU ktichg flush	180	0.05	0.02
IMU pool not allocated	62	0.02	0.01
IMU recursive-transaction flush	5	0.00	0.00
IMU Redo allocation size	2,519,956	697.22	229.44
IMU undo allocation size	15,345,728	4,245.87	1,397.23
index crx upgrade (positioned)	6,476	1.79	0.59
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	403	0.11	0.04
index fetch by key	1,146,167	317.12	104.36
index scans kdiixs1	8,083,832	2,236.64	736.03
leaf node splits	466	0.13	0.04
leaf node 90-10 splits	261	0.07	0.02
lob reads	6,562	1.82	0.60
LOB table id lookup cache misses	0	0.00	0.00
lob writes	441	0.12	0.04
lob writes unaligned	404	0.11	0.04
logons cumulative	394	0.11	0.04
max cf enq hold time	62	0.02	0.01
messages received	75,578	20.91	6.88
messages sent	75,578	20.91	6.88
min active SCN optimization applied on CR	2	0.00	0.00
no buffer to keep pinned count	3,378,526	934.77	307.61
no work - consistent read gets	15,220,570	4,211.24	1,385.83
non-idle wait count	1,151,176	318.51	104.81
non-idle wait time	150,938	41.76	13.74
Number of read IOs issued	231,250	63.98	21.06
opened cursors cumulative	956,285	264.59	87.07
parse count (describe)	83	0.02	0.01
parse count (failures)	972	0.27	0.09
parse count (hard)	32,543	9.00	2.96
parse count (total)	640,615	177.25	58.33
parse time cpu	10,251	2.84	0.93
parse time elapsed	23,341	6.46	2.13
physical read bytes	30,556,471,296	8,454,394.07	2,782,160.73
physical read IO requests	365,394	101.10	33.27
physical read total bytes	30,842,022,912	8,533,400.76	2,808,160.15
physical read total IO requests	371,705	102.84	33.84
physical read total multi block requests	222,277	61.50	20.24
physical reads	3,729,829	1,031.97	339.60
physical reads cache	168,183	46.53	15.31
physical reads cache prefetch	34,600	9.57	3.15
physical reads direct	3,561,646	985.44	324.29
physical reads direct (lob)	8,851	2.45	0.81
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write bytes	389,120,000	107,662.10	35,429.30
physical write IO requests	24,391	6.75	2.22
physical write total bytes	826,610,176	228,707.30	75,262.69
physical write total IO requests	86,027	23.80	7.83
physical write total multi block requests	1,476	0.41	0.13
physical writes	47,212	13.06	4.30
physical writes direct	141	0.04	0.01
physical writes direct (lob)	67	0.02	0.01
physical writes direct temporary tablespace	57	0.02	0.01
physical writes from cache	47,071	13.02	4.29
physical writes non checkpoint	43,712	12.09	3.98
pinned buffers inspected	40	0.01	0.00
prefetch clients - 16k	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
process last non-idle time	3,736	1.03	0.34
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	9,597,753	2,655.52	873.87
recursive cpu usage	60,894	16.85	5.54
redo blocks checksummed by FG (exclusive)	135,097	37.38	12.30
redo blocks read for recovery	0	0.00	0.00
redo blocks written	745,635	206.30	67.89
redo buffer allocation retries	4	0.00	0.00
redo entries	1,104,198	305.51	100.54
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	5	0.00	0.00
redo log space wait time	37	0.01	0.00
redo ordering marks	18,057	5.00	1.64
redo size	354,171,280	97,992.45	32,247.23
redo size for direct writes	3,848	1.06	0.35
redo subscn max counts	24,819	6.87	2.26
redo synch time	674	0.19	0.06
redo synch writes	12,407	3.43	1.13
redo wastage	15,132,760	4,186.95	1,377.83
redo write time	2,100	0.58	0.19
redo writes	57,918	16.02	5.27
rollback changes - undo records applied	19,985	5.53	1.82
rollbacks only - consistent read gets	377	0.10	0.03
root node splits	0	0.00	0.00
RowCR - row contention	75	0.02	0.01
RowCR attempts	626	0.17	0.06
RowCR hits	522	0.14	0.05
rows fetched via callback	154,140	42.65	14.03
session connect time	0	0.00	0.00
session cursor cache hits	307,668	85.13	28.01
session logical reads	20,958,902	5,798.93	1,908.30
shared hash latch upgrades - no wait	172,149	47.63	15.67
shared hash latch upgrades - wait	0	0.00	0.00
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	2	0.00	0.00
SMON posted for undo segment shrink	10	0.00	0.00
sorts (memory)	362,363	100.26	32.99
sorts (rows)	46,835,184	12,958.40	4,264.33
sql area evicted	12,102	3.35	1.10
sql area purged	15,938	4.41	1.45
SQL*Net roundtrips to/from client	144,467	39.97	13.15
summed dirty queue length	135,366	37.45	12.33
switch current to new buffer	24,060	6.66	2.19
table fetch by rowid	17,325,084	4,793.52	1,577.45
table fetch continued row	43,403	12.01	3.95
table scan blocks gotten	6,100,797	1,687.97	555.48
table scan rows gotten	892,399,054	246,909.83	81,252.76
table scans (direct read)	62	0.02	0.01
table scans (long tables)	67	0.02	0.01
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	74,353	20.57	6.77
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
total cf enq hold time	3,542	0.98	0.32
total number of cf enq holders	161	0.04	0.01
total number of times SMON posted	12	0.00	0.00
transaction rollbacks	4	0.00	0.00
transaction tables consistent read rollbacks	1	0.00	0.00
transaction tables consistent reads - undo records applied	298	0.08	0.03
undo change vector size	135,813,916	37,577.13	12,365.83
user calls	196,412	54.34	17.88
user commits	10,983	3.04	1.00
user I/O wait time	140,715	38.93	12.81
user rollbacks	0	0.00	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	271,387	75.09	24.71
write clones created in background	6	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session uga memory	61,914,711,858,792	62,206,769,557,516
opened cursors current	382	289
logons current	61	58
session uga memory max	71,534,185,940	72,154,233,304
session pga memory	26,019,285,228	26,121,854,828
session pga memory max	30,560,964,084	30,467,646,580
session cursor cache count	1,472,803	1,486,919

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)	5	4.98

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	27,2G	63.98	7,69864	0M	0.00	0M	231,3K	1.68
Buffer Cache Reads	1,3G	37.08	,363835	0M	0.00	0M	133,6K	7.48
DBWR	0M	0.00	0M	370M	6.72	,102371	0
LGWR	2M	0.04	,000553	363M	16.10	,100435	521	3.74
Others	270M	1.71	,074703	52M	0.95	,014387	9597	2.41
Direct Writes	0M	0.00	0M	1M	0.02	,000276	89	0.54
Streams AQ	0M	0.00	0M	0M	0.00	0M	8	9.75
TOTAL:	28,7G	102.81	8,13774	786M	23.79	,217471	375,1K	3.77

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	28,5G	101.05	8,06220	364M	6.68	,100711	7.34	1.52
Log File	0M	0.00	0M	361M	16.07	,099881	6.30
Control File	271M	1.70	,074980	53M	0.93	,014664	3.22	9.59
Temp File	1M	0.04	,000276	4M	0.08	,001106	9.28
Other	0M	0.02	0M	0M	0.03	0M	5.47
TOTAL:	28,7G	102.81	8,13746	782M	23.79	,216364	7.18	1.52

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	27,2G	63.98	7,69864	0M	0.00	0M	0
Direct Reads (Data File)	27,2G	63.98	7,69864	0M	0.00	0M	0
Buffer Cache Reads	1,3G	37.08	,364112	0M	0.00	0M	133,4K	7.40
Buffer Cache Reads (Data File)	1,3G	37.08	,364112	0M	0.00	0M	133,4K	7.40
DBWR	0M	0.00	0M	370M	6.72	,102371	0
DBWR (Data File)	0M	0.00	0M	370M	6.72	,102371	0
LGWR	2M	0.04	,000553	363M	16.10	,100435	145	8.92
LGWR (Log File)	0M	0.00	0M	361M	16.07	,099881	20	3.15
LGWR (Control File)	2M	0.03	,000553	2M	0.03	,000553	125	9.84
Others	270M	1.69	,074703	52M	0.92	,014387	6187	3.41
Others (Control File)	269M	1.66	,074427	51M	0.90	,014110	6014	3.29
Others (Data File)	1M	0.03	,000276	1M	0.02	,000276	173	7.49
Direct Writes	0M	0.00	0M	1M	0.02	,000276	0
Direct Writes (Data File)	0M	0.00	0M	1M	0.02	,000276	0
Streams AQ	0M	0.00	0M	0M	0.00	0M	8	9.75
Streams AQ (Data File)	0M	0.00	0M	0M	0.00	0M	8	9.75
TOTAL:	28,7G	102.80	8,13801	786M	23.76	,217471	139,7K	7.23

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)
SYSTEM	335,625	93	2.49	10.95	19,215	5	531	1.24
SYSAUX	23,029	6	4.12	1.23	2,663	1	0	0.00
WMDATA	6,338	2	8.25	3.94	370	0	0	0.00
UNDOTBS2	100	0	4.90	1.00	1,586	0	12	0.00
WMINDX	207	0	7.20	1.01	257	0	0	0.00
WINMDB_TEMP	139	0	8.78	1.31	296	0	0	0.00
EXAMPLE	16	0	3.75	1.50	0	0	0	0.00
TEMP	7	0	4.29	1.00	4	0	0	0.00
ZZZ_TMP	5	0	26.00	1.00	0	0	0	0.00
USERS	3	0	3.33	1.00	0	0	0	0.00
ORABI_BIPLATFORM	2	0	0.00	1.00	0	0	0	0.00
ORABI_MDS	2	0	0.00	1.00	0	0	0	0.00
ZZZ_DATA	2	0	0.00	1.00	0	0	0	0.00
ZZZ_IDX	2	0	0.00	1.00	0	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
EXAMPLE	F:\ORADATA\WINMDB2\EXAMPLE01.DBF	16	0	3.75	1.50	0	0	0	0.00
ORABI_BIPLATFORM	F:\ORADATA\WINMDB2\ORABI_BIPLATFORM.DBF	2	0	0.00	1.00	0	0	0	0.00
ORABI_MDS	F:\ORADATA\WINMDB2\ORABI_MDS.DBF	2	0	0.00	1.00	0	0	0	0.00
SYSAUX	F:\ORADATA\WINMDB2\SYSAUX01.DBF	23,029	6	4.12	1.23	2,663	1	0	0.00
SYSTEM	F:\ORADATA\WINMDB2\SYSTEM01.DBF	335,625	93	2.49	10.95	19,215	5	531	1.24
TEMP	F:\ORADATA\WINMDB2\TEMP01.DBF	7	0	4.29	1.00	4	0	0
UNDOTBS2	F:\ORADATA\WINMDB2\UNDOTBS02.DBF	100	0	4.90	1.00	1,586	0	12	0.00
USERS	F:\ORADATA\WINMDB2\USERS01.DBF	3	0	3.33	1.00	0	0	0	0.00
WINMDB_TEMP	F:\ORADATA\WINMDB2\WINMDB_TEMP.DBF	139	0	8.78	1.31	296	0	0
WMDATA	F:\ORADATA\WINMDB2\WMDATA.DBF	6,338	2	8.25	3.94	370	0	0	0.00
WMINDX	F:\ORADATA\WINMDB2\WMINDX.DBF	207	0	7.20	1.01	257	0	0	0.00
ZZZ_DATA	F:\ORADATA\WINMDB2\ZZZ_DATA.DBF	2	0	0.00	1.00	0	0	0	0.00
ZZZ_IDX	F:\ORADATA\WINMDB2\ZZZ_IDX.DBF	2	0	0.00	1.00	0	0	0	0.00
ZZZ_TMP	F:\ORADATA\WINMDB2\ZZZ_TMP.DBF	5	0	26.00	1.00	0	0	0

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
16k	6,539	100	1,157,959	209	288	0	0	0
D	42,312	99	16,243,300	167,997	46,783	0	0	544

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 47,212

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	19,441	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

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

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	60	6072	190152	318492	318492	337230
E	0	54	2356	27206	199233	318492	199233

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	32	0.09	4	1.54	47,256	1	195724.00
D	64	0.18	8	1.43	43,973	1	170078.00
D	96	0.27	12	1.33	40,835	1	145557.00
D	128	0.36	16	1.24	37,884	1	122498.00
D	160	0.45	20	1.15	35,123	1	100922.00
D	192	0.55	24	1.12	34,221	1	93879.00
D	224	0.64	28	1.09	33,373	1	87248.00
D	256	0.73	32	1.06	32,551	1	80832.00
D	288	0.82	36	1.04	31,758	1	74631.00
D	320	0.91	40	1.01	30,989	1	68627.00
D	352	1.00	44	1.00	30,646	1	65946.00
D	384	1.09	48	0.99	30,321	1	63402.00
D	416	1.18	52	0.98	30,016	1	61018.00
D	448	1.27	56	0.97	29,730	1	58787.00
D	480	1.36	60	0.96	29,463	1	56696.00
D	512	1.45	64	0.95	29,255	1	55072.00
D	544	1.55	68	0.95	29,045	1	53431.00
D	576	1.64	72	0.94	28,829	1	51747.00
D	608	1.73	76	0.93	28,609	1	50024.00
D	640	1.82	80	0.93	28,385	1	48277.00
16k	8	0.08	1	4.86	389	2	2971.00
16k	16	0.15	1	3.29	263	2	1974.00
16k	24	0.23	2	2.57	206	2	1517.00
16k	32	0.31	2	2.21	176	2	1282.00
16k	40	0.38	3	2.04	163	2	1174.00
16k	48	0.46	3	1.84	147	2	1052.00
16k	56	0.54	4	1.53	122	2	850.00
16k	64	0.62	4	1.44	116	2	797.00
16k	72	0.69	5	1.39	111	2	761.00
16k	80	0.77	5	1.31	105	2	714.00
16k	88	0.85	6	1.20	96	2	641.00
16k	96	0.92	6	1.13	90	2	596.00
16k	104	1.00	7	1.00	80	2	514.00
16k	112	1.08	7	0.90	72	2	449.00
16k	120	1.15	8	0.84	67	2	414.00
16k	128	1.23	8	0.79	64	2	384.00
16k	136	1.31	9	0.74	59	2	348.00
16k	144	1.38	9	0.68	55	2	314.00
16k	152	1.46	10	0.65	52	2	294.00
16k	160	1.54	10	0.62	50	2	273.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	5,599	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	256,887	256,887
64K	128K	180	180
128K	256K	11,374	11,374
256K	512K	178	178
512K	1024K	2,546	2,546
1M	2M	155	155
2M	4M	55	55
8M	16M	24	24

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
87	0.13	531,603.20	46,407.88	92.00	3,671	371,587,884
174	0.25	531,603.20	630.01	100.00	9	342,158,513
348	0.50	531,603.20	142.71	100.00	0	341,845,239
522	0.75	531,603.20	0.00	100.00	0	341,753,496
696	1.00	531,603.20	0.00	100.00	0	341,753,496
835	1.20	531,603.20	0.00	100.00	0	341,753,496
974	1.40	531,603.20	0.00	100.00	0	341,753,496
1,114	1.60	531,603.20	0.00	100.00	0	341,753,496
1,253	1.80	531,603.20	0.00	100.00	0	341,753,496
1,392	2.00	531,603.20	0.00	100.00	0	341,753,496
2,088	3.00	531,603.20	0.00	100.00	0	341,753,496
2,784	4.00	531,603.20	0.00	100.00	0	341,753,496
4,176	6.00	531,603.20	0.00	100.00	0	341,753,496
5,568	8.00	531,603.20	0.00	100.00	0	341,753,496

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)
504	0.90	51	5,208	1,910,427	1.00	30,094	1.08	83,520
560	1.00	107	9,069	1,912,657	1.00	27,864	1.00	94,415
616	1.10	163	16,279	1,915,032	1.00	25,489	0.91	94,559
672	1.20	219	22,498	1,917,223	1.00	23,298	0.84	94,693
728	1.30	275	26,519	1,919,178	1.00	21,343	0.77	94,814
784	1.40	330	30,250	1,920,909	1.00	19,612	0.70	94,923
840	1.50	386	34,030	1,922,436	1.01	18,085	0.65	95,020
896	1.60	442	38,512	1,923,778	1.01	16,743	0.60	95,107
952	1.70	498	43,080	1,924,960	1.01	15,561	0.56	95,184
1,008	1.80	554	50,421	1,925,995	1.01	14,526	0.52	95,252
1,064	1.90	610	57,952	1,926,912	1.01	13,609	0.49	95,313
1,120	2.00	666	61,596	1,927,731	1.01	12,790	0.46	95,372

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
786	0.75	284,577	38,676,648
1,048	1.00	222,326	30,644,678
1,310	1.25	207,186	28,980,672
1,572	1.50	198,826	28,980,672
1,834	1.75	192,757	28,980,672
2,096	2.00	191,912	28,980,672

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
8	1.00	0	0	0	0
16	2.00	0	0	0	0
24	3.00	0	0	0	0
32	4.00	0	0	0	0
40	5.00	0	0	0	0
48	6.00	0	0	0	0
56	7.00	0	0	0	0
64	8.00	0	0	0	0
72	9.00	0	0	0	0
80	10.00	0	0	0	0
88	11.00	0	0	0	0
96	12.00	0	0	0	0
104	13.00	0	0	0	0
112	14.00	0	0	0	0
120	15.00	0	0	0	0
128	16.00	0	0	0	0
136	17.00	0	0	0	0
144	18.00	0	0	0	0
152	19.00	0	0	0	0
160	20.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	531	1	1
undo header	12	0	0
undo block	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Waits	Av Wt Time(ms)
KO-Multiple Object Checkpoint (fast object checkpoint)	234	234	26	4.19
CR-Reuse Block Range (block range reuse ckpt)	588	588	7	4.43
RO-Multiple Object Reuse (fast object reuse)	117	117	13	1.23

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
5	23.26	64,942	976	6	19,2/29,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-Ian 16:53	1,972	11,942	976	4	29	0/0	0/0/0/0/0/0
18-Ian 16:43	1,632	4,514	368	3	19	0/0	0/0/0/0/0/0
18-Ian 16:33	884	1,619	964	3	29	0/0	0/0/0/0/0/0
18-Ian 16:23	2,739	2,920	356	5	20	0/0	0/0/0/0/0/0
18-Ian 16:13	7,099	16,042	953	6	30	0/0	0/0/0/0/0/0
18-Ian 16:03	8,932	27,905	344	5	20	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
active checkpoint queue latch	17,631	0.00		0
active service list	9,243	0.00		5,052	0.00
AQ deq hash table latch	2	0.00		0
AQ dequeue txn counter latch	3,126	0.00		0
ASM db client latch	2,819	0.00		0
ASM map operation hash table	2	0.00		0
ASM network state latch	59	0.00		0
AWR Alerted Metric Element list	27,326	0.00		0
begin backup scn array	74	0.00		0
buffer pool	224	0.00		0
business card	2	0.00		0
cache buffer handles	61,430	0.00		0
cache buffers chains	37,223,235	0.00	0.05	555,070	0.00
cache buffers lru chain	132,404	0.04	0.00	403,663	0.03
cache table scan latch	0			7,786	0.00
call allocation	42,458	0.00	0.00	0
cas latch	2	0.00		0
change notification client cache latch	2	0.00		0
Change Notification Hash table latch	1,215	0.00		0
channel handle pool latch	710	0.00		0
channel operations parent latch	25,191	0.00		0
checkpoint queue latch	595,598	0.00	0.00	51,212	0.01
client/application info	6,298	0.00		0
compile environment latch	394	0.00		0
Consistent RBA	57,945	0.02	0.00	0
corrupted undo seg latch	59,959	0.00		0
cp cmon/server latch	2	0.00		0
cp pool latch	2	0.00		0
cp server hash latch	2	0.00		0
cp sga latch	59	0.00		0
cvmap freelist lock	2	0.00		0
deferred cleanup latch	59	0.00		0
direct msg latch	82,107	0.00		0
dml lock allocation	73	0.00		0
DML lock allocation	824,167	0.00	0.00	0
done queue latch	76,747	0.00		82,107	0.01
dummy allocation	793	0.00		0
enqueue hash chains	621,226	0.00	0.00	0
enqueues	172,424	0.00	0.00	0
Event Group Locks	328	0.00		0
FIB s.o chain latch	40	0.00		0
fifth spare latch	2	0.00		0
file cache latch	521	0.00		0
File State Object Pool Parent Latch	2	0.00		0
flashback copy	2	0.00		0
FOB s.o list latch	1,557	0.00		0
gc element	2	0.00		0
gcs commit scn state	2	0.00		0
gcs partitioned table hash	2	0.00		0
gcs pcm hashed value bucket hash	2	0.00		0
gcs resource freelist	2	0.00		0
gcs resource hash	2	0.00		0
gcs resource scan list	2	0.00		0
gcs shadows freelist	2	0.00		0
ges domain table	2	0.00		0
ges enqueue table freelist	2	0.00		0
ges group table	2	0.00		0
ges process hash list	2	0.00		0
ges process parent latch	2	0.00		0
ges resource hash list	2	0.00		0
ges resource scan list	2	0.00		0
ges resource table freelist	2	0.00		0
ges value block free list	2	0.00		0
global KZLD latch for mem in SGA	183	0.00		0
global tx hash mapping	21,974	0.00		0
granule operation	2	0.00		0
hash table column usage latch	4,804	0.00		3,320,729	0.00
hash table modification latch	240	0.00		0
heartbeat check	2	0.00		0
In memory undo latch	69,968	0.00		10,218	0.00
internal temp table object number allocation latch	205	0.00		0
intra txn parallel recovery	2	0.00		0
io pool granule metadata list	2	0.00		0
i/o slave adaptor	222	0.00		0
IPC stats buffer allocation latch	2	0.00		0
job workq parent latch	70	0.00		68	4.41
job_queue_processes free list latch	144	0.00		0
job_queue_processes parameter latch	853	0.00		0
JS mem alloc latch	5	0.00		0
JS queue access latch	7	0.00		0
JS queue state obj latch	26,204	0.00		0
JS Sh mem access	10	0.00		0
JS slv state obj latch	120,009	0.03	0.00	0
kcbtsemkid latch	5	0.00		0
kdlx hb parent latch	2	0.00		0
KFC FX Hash Latch	2	0.00		0
KFC Hash Latch	2	0.00		0
KFCL LE Freelist	2	0.00		0
kgb parent	2	0.00		0
KGNFS-NFS:SHM structure	2	0.00		0
KGNFS-NFS:SVR LIST	2	0.00		0
KJC message pool free list	2	0.00		0
KJCT flow control latch	2	0.00		0
kks stats	157,077	0.00		0
KMG MMAN ready and startup request latch	1,798	0.00		0
KMG resize request state object freelist	20	0.00		0
kokc descriptor allocation latch	430,844	0.00	0.00	0
krbmrosl	2	0.00		0
ksfv messages	162,922	0.00		0
kss move lock	44	0.00		0
ksuosstats global area	247	0.00		0
ksv allocation latch	143	0.00		0
ksv class latch	86	0.00		0
ksv msg queue latch	2	0.00		0
ksz_so allocation latch	655	0.00		0
KTF sga latch	2,333	0.00		1,010	0.00
ktm global data	44	0.00		0
kwqbsn:qsga	235	0.00		0
KWQMN job cache list latch	2	0.00		0
KWQP Prop Status	4	0.00		0
KWQS pqsubs latch	12	0.00		0
KWQS pqueue ctx latch	301	0.00		0
k2q lock allocation	2	0.00		0
lgwr LWN SCN	58,179	0.01	0.00	0
list of block allocation	2,599	0.00		0
loader state object freelist	9,082	0.00		0
lob segment dispenser latch	2	0.00		0
lob segment hash table latch	14	0.00		0
lob segment query latch	2	0.00		0
Locator state objects pool parent latch	2	0.00		0
lock DBA buffer during media recovery	2	0.00		0
logical standby cache	2	0.00		0
logminer context allocation	4	0.00		0
logminer work area	2	0.00		0
longop free list parent	887	0.00		8	0.00
Lsod array latch	2	0.00		0
mapped buffers lru chain	2	0.00		0
Memory Management Latch	850	0.12	0.00	1,798	0.00
Memory Queue	2	0.00		0
Memory Queue Message Subscriber #1	2	0.00		0
Memory Queue Message Subscriber #2	2	0.00		0
Memory Queue Message Subscriber #3	2	0.00		0
Memory Queue Message Subscriber #4	2	0.00		0
Memory Queue Subscriber	2	0.00		0
message pool operations parent latch	577	0.00		0
messages	234,677	0.04	0.02	0
MinActiveScn Latch	15	0.00		0
mostly latch-free SCN	58,218	0.05	0.00	0
MQL Tracking Latch	0			70	0.00
msg queue latch	2	0.00		153,749	2.92
multiblock read objects	22,226	0.00		0
Mutex	2	0.00		0
Mutex Stats	2	0.00		0
name-service namespace bucket	2	0.00		0
ncodef allocation latch	59	0.00		0
object queue header heap	153,186	0.00		8,557	0.02
object queue header operation	717,776	0.01	0.00	8,416	0.42
object stats modification	2,210	0.00		0
OS process	1,847	0.00		0
OS process allocation	2,427	0.00		0
OS process: request allocation	655	0.00		0
parallel query alloc buffer	478	0.00		0
parallel query stats	2	0.00		0
parameter list	1,849	0.00		0
parameter table management	835	0.00		0
peshm	2	0.00		0
pesom_free_list	2	0.00		0
pesom_hash_node	2	0.00		0
PL/SQL warning settings	68,813	0.00		0
post/wait queue	20,441	0.00	0.00	12,060	0.00
process allocation	798	0.00		326	0.00
process group creation	655	0.00		0
process queue	2	0.00		0
process queue reference	2	0.00		0
PX hash array latch	2	0.00		0
qmn task queue latch	525	0.00		0
QMT	2	0.00		0
query server freelists	2	0.00		0
queued dump request	12	0.00		0
queuing load statistics	2	0.00		0
Real-time plan statistics latch	4,235	0.00		0
recovery domain hash list	2	0.00		0
redo allocation	198,249	0.09	0.00	1,107,480	0.01
redo copy	2	0.00		1,107,499	0.04
redo writing	194,444	0.00	0.00	0
resmgr group change latch	1,279	0.00		0
resmgr:active threads	793	0.00		0
resmgr:actses change group	273	0.00		0
resmgr:actses change state	2	0.00		0
resmgr:free threads list	791	0.00		0
resmgr:plan CPU method	2	0.00		0
resmgr:resource group CPU method	2	0.00		0
resmgr:schema config	162	0.00		0
resmgr:session queuing	2	0.00		0
rm cas latch	2	0.00		0
row cache objects	16,681,024	0.06	0.00	34,639	0.06
rules engine rule set statistics	200	0.00		0
second spare latch	2	0.00		0
sequence cache	106,424	0.00		0
session allocation	81,434	0.00		27,108	0.00
session idle bit	419,550	0.00	0.00	0
session queue latch	82,109	0.00		0
session state list latch	540	0.00		0
session switching	1,706	0.00		0
session timer	1,237	0.00		0
SGA blob parent	2	0.00		0
SGA bucket locks	2	0.00		0
SGA heap locks	2	0.00		0
SGA IO buffer pool latch	7,786	0.00		7,786	0.00
SGA pool locks	2	0.00		0
Shared B-Tree	668	0.00		0
shared pool	5,347,536	0.11	0.03	0
shared pool sim alloc	2	0.00		0
shared pool simulator	466,722	0.00		0
sim partition latch	2	0.00		0
simulator hash latch	984,406	0.00		0
simulator lru latch	26,072	0.02	0.00	941,555	0.01
sort extent pool	4,801	0.00		0
space background state object latch	8	0.00		0
space background task latch	2,666	0.00		2,400	0.00
SQL memory manager latch	122	0.00		1,195	0.00
SQL memory manager workarea list latch	921,739	0.00		0
state object free list	4	0.00		0
statistics aggregation	1,120	0.00		0
Streams Generic	2	0.00		0
tablespace key chain	3	0.00		0
temp lob duration state obj allocation	31	0.00		0
temporary table state object allocation	64	0.00		0
test excl. parent l0	2	0.00		0
test excl. parent2 l0	2	0.00		0
Testing	2	0.00		0
third spare latch	2	0.00		0
threshold alerts latch	216	0.00		0
Token Manager	2	0.00		0
transaction allocation	131,361	0.00		0
transaction branch allocation	22,961	0.00		0
undo global data	193,805	0.00		0
virtual circuit buffers	2	0.00		0
virtual circuit holder	2	0.00		0
virtual circuit queues	2	0.00		0
WCR: sync	2	0.00		0
Write State Object Pool Parent Latch	2	0.00		0
XDB NFS Security Latch	2	0.00		0
XDB unused session pool	2	0.00		0
XDB used session pool	2	0.00		0
X$KSFQP	5	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
row cache objects	16,681,024	9,532	4	9,528
shared pool	5,347,536	5,913	190	5,770
cache buffers chains	37,223,235	218	11	207
messages	234,677	98	2	96

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
cache buffers chains	kcbgtcr_2	8	0
cache buffers chains	kcbgtcr: fast path (cr pin)	2	10
cache buffers chains	kcbrls_1	1	1
messages	ksarcv	1	1
messages	ksarcv: after wait	1	1
row cache objects	kqreqd: reget	4	0
shared pool	kghalo	109	60
shared pool	kgh_next_free	40	0
shared pool	kghupr1	22	54
shared pool	kgh: add to quiesced list check	5	0
shared pool	kghquiesce_extent quiesced if free	5	0
shared pool	kgh: add extent to quiesced list	2	0
shared pool	kghfrh	2	0
shared pool	kghfrunp: alloc: wait	2	0
shared pool	kgh: sim resz update	1	0
shared pool	kghfre	1	19
shared pool	kgh_heap_sizes	1	6

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

No data exists for this section of the report.

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: 20,958,902
Captured Segments account for 84.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	AUD$	TABLE	3,234,144	15.43
BBBB	WMDATA	CONSTLUNA	TABLE	2,447,984	11.68
SYS	SYSTEM	I_OBJAUTH1	INDEX	1,915,616	9.14
WINMADMIN	WMDATA	SETTASK	TABLE	848,736	4.05
BBBB	WMINDX	IDX_CONSTLUNA_CODCONST1	INDEX	800,096	3.82

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 3,729,829
Captured Segments account for 97.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	AUD$	TABLE	3,218,325	86.29
SYS	SYSTEM	OBJ$	TABLE	324,353	8.70
SYS	SYSTEM	DEPENDENCY$	TABLE	19,675	0.53
SYS	SYSTEM	ICOL$	TABLE	12,617	0.34
SYS	SYSTEM	I_OBJAUTH1	INDEX	10,732	0.29

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 365,394
Captured Segments account for 84.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
SYS	SYSTEM	AUD$	TABLE	201,159	55.05
SYS	SYSTEM	OBJ$	TABLE	22,571	6.18
SYS	SYSTEM	ICOL$	TABLE	12,617	3.45
SYS	SYSTEM	I_OBJAUTH1	INDEX	10,732	2.94
SYS	SYSTEM	IDL_UB1$	TABLE	9,894	2.71

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 365,394
Captured Segments account for 84.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
SYS	SYSTEM	AUD$	TABLE	201,159	55.05
SYS	SYSTEM	OBJ$	TABLE	22,571	6.18
SYS	SYSTEM	ICOL$	TABLE	12,617	3.45
SYS	SYSTEM	I_OBJAUTH1	INDEX	10,732	2.94
SYS	SYSTEM	IDL_UB1$	TABLE	9,894	2.71

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

Total Direct Physical Reads: 3,561,646
Captured Segments account for 99.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Direct Reads	%Total
SYS	SYSTEM	AUD$	TABLE	3,218,318	90.36
SYS	SYSTEM	OBJ$	TABLE	322,378	9.05
SYS	SYSAUX	SYS_LOB0000000207C00005$$	LOB	8,507	0.24

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 47,212
Captured Segments account for 35.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
SYS	SYSTEM	IDL_UB1$	TABLE	4,643	9.83
SYS	SYSTEM	I_DEPENDENCY2	INDEX	2,234	4.73
SYS	SYSTEM	OBJ$	TABLE	1,012	2.14
SYS	SYSTEM	IDL_UB2$	TABLE	971	2.06
SYS	SYSTEM	ICOL$	TABLE	914	1.94

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 24,391
Captured Segments account for 61.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
SYS	SYSTEM	IDL_UB1$	TABLE	4,472	18.33
SYS	SYSTEM	I_DEPENDENCY2	INDEX	2,027	8.31
SYS	SYSTEM	IDL_UB2$	TABLE	931	3.82
SYS	SYSTEM	OBJ$	TABLE	899	3.69
SYS	SYSTEM	ICOL$	TABLE	702	2.88

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 141
Captured Segments account for 59.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	SYS_LOB0000000207C00005$$		LOB	54	38.30
SYS	SYSAUX	SYS_LOB0000006213C00038$$		LOB	11	7.80
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_114741071_24635	TABLE PARTITION	7	4.96
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	4	2.84
UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNAVAILABLE	UNDEFINED	3	2.13

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 470
Captured Segments account for 57.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_USER2	INDEX	181	38.51
SYS	SYSTEM	OBJ$	TABLE	52	11.06
SYS	SYSTEM	I_OBJ2	INDEX	28	5.96
SYS	SYSTEM	DEPENDENCY$	TABLE	5	1.06
SYS	SYSTEM	AUD$	TABLE	2	0.43

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
SYS	SYSTEM	I_COL1	INDEX	65,904	8.93
SYS	SYSTEM	I_COL3	INDEX	65,392	8.86
SYS	SYSTEM	I_COL2	INDEX	64,528	8.75
SYS	SYSTEM	OBJAUTH$	TABLE	55,072	7.47
SYS	SYSTEM	I_SOURCE1	INDEX	54,592	7.40

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	OBJAUTH$		TABLE	9	100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	68	0.00	4	1
dc_constraints	2	100.00	2	0
dc_files	11	100.00	0	0
dc_global_oids	224,248	0.16	16	90
dc_histogram_data	253,313	3.42	0	3,348
dc_histogram_defs	298,801	23.05	143	13,452
dc_object_grants	448,391	12.89	0	2,595
dc_objects	1,027,629	3.37	22,078	11,216
dc_profiles	303	0.33	0	2
dc_rollback_segments	1,125	0.00	0	26
dc_segments	224,995	3.17	53	2,447
dc_sequences	2,724	2.75	2,724	7
dc_table_scns	1,585	100.00	0	0
dc_tablespaces	942,553	0.00	0	15
dc_users	2,972,077	0.06	1	286
global database name	7,970	0.00	0	1
outstanding_alerts	60	83.33	0	10
qmtmrctn_cache_entries	6	100.00	0	0
qmtmrctq_cache_entries	244	100.00	0	0
sch_lj_oids	5	80.00	0	0
smo rowcache	223	100.00	0	1

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	121,959	1.29	154,747	2.26	639	770
CLUSTER	6,237	0.21	1,299	1.08	1	0
DBLINK	368	0.27	0		0	0
EDITION	267	0.00	517	0.00	0	0
HINTSET OBJECT	28,481	23.45	28,481	25.91	17	0
INDEX	395	29.87	315	40.95	4	0
OBJECT ID	1,721	100.00	0		0	0
QUEUE	8,554	0.00	10,270	0.02	2	0
SCHEMA	46,894	0.03	0		0	0
SQL AREA	296,057	32.76	1,636,488	5.18	10,699	17,059
SUBSCRIPTION	13	0.00	13	7.69	1	0
TABLE/PROCEDURE	934,001	2.59	886,691	7.46	13,392	1,288
TEMPORARY TABLE	12	33.33	12	100.00	8	0
TRIGGER	64,456	0.11	64,565	0.13	16	0
XML SCHEMA	14	28.57	18	66.67	2	0

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	352.00	352.00	344.00	496.00	10	SHR/DEF
DEFAULT 16K buffer cache	104.00	104.00	104.00	104.00	0	INI/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
java pool	8.00	8.00	8.00	8.00	0	STA/
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
large pool	8.00	8.00	8.00	8.00	0	STA/
PGA Target	696.00	696.00	696.00	696.00	0	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	1,048.00	1,048.00	1,048.00	1,048.00	0	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
shared pool	560.00	560.00	416.00	568.00	10	GRO/DEF
streams pool	8.00	8.00	8.00	8.00	0	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

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

Component	Min Size (Mb)	Max Size (Mb)	Avg Size (Mb)	Re- Sizes	Grows	Shrinks
DEFAULT buffer cache	352.00	400.00	368.80	10	5	5
shared pool	512.00	560.00	543.20	10	5	5

Back to Memory Statistics
Back to Top

Memory Resize Ops

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

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Final (M)	Sta
01/18 16:30:38	0	bufcache	SHR/DEF	376	-24	352	COM
01/18 16:30:38	0	shared	GRO/DEF	536	24	560	COM
01/18 16:27:08	0	bufcache	SHR/DEF	400	-24	376	COM
01/18 16:27:08	0	shared	GRO/DEF	512	24	536	COM
01/18 16:26:07	0	bufcache	GRO/DEF	376	24	400	COM
01/18 16:26:07	0	shared	SHR/DEF	536	-24	512	COM
01/18 16:25:37	0	bufcache	GRO/DEF	352	24	376	COM
01/18 16:25:37	0	shared	SHR/DEF	560	-24	536	COM
01/18 16:15:05	6	bufcache	SHR/DEF	376	-24	352	COM
01/18 16:15:05	6	shared	GRO/DEF	536	24	560	COM
01/18 16:13:34	0	bufcache	GRO/DEF	352	24	376	COM
01/18 16:13:34	0	shared	SHR/DEF	560	-24	536	COM
01/18 16:07:03	0	bufcache	SHR/DEF	376	-24	352	COM
01/18 16:07:03	0	shared	GRO/DEF	536	24	560	COM
01/18 16:06:33	0	bufcache	GRO/DEF	352	24	376	COM
01/18 16:06:33	0	shared	SHR/DEF	560	-24	536	COM
01/18 16:03:02	0	bufcache	SHR/DEF	376	-24	352	COM
01/18 16:03:02	0	shared	GRO/DEF	536	24	560	COM
01/18 16:02:02	0	bufcache	GRO/DEF	352	24	376	COM
01/18 16:02:02	0	shared	SHR/DEF	560	-24	536	COM

Back to Memory Statistics
Back to Top

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	119.69		1.90	1.97	12	38	63	63
	PL/SQL	28.43	14.08	0.47	1.11	8	22	61	61
	SQL	5.81	0.75	0.14	0.16	1	52	43	40
E	Other	100.97		1.68	1.59	7	38	60	60
	PL/SQL	20.79	6.83	0.36	1.06	8	23	58	58
	SQL	3.58	0.43	0.09	0.11	0	28	39	35

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	478,150,656
Fixed Size	1,375,876
Redo Buffers	4,550,656
Variable Size	612,368,764

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	8.00	8.00	0.00
large	free memory	0.50	0.50	0.00
large	PX msg pool	7.50	7.50	0.00
shared	ASH buffers	8.00	8.00	0.00
shared	CCUR	54.83	47.62	-13.16
shared	dbktb: trace buffer	23.44	23.44	0.00
shared	event statistics per sess	27.80	27.80	0.00
shared	FileOpenBlock	7.60	7.60	0.00
shared	free memory	138.01	142.61	3.34
shared	KGH: NO ACCESS	100.11	76.46	-23.62
shared	KGLHD	9.10	8.94	-1.77
shared	KGLH0	18.99	20.83	9.74
shared	KGLS	13.47	16.92	25.68
shared	kglsim heap	6.98	6.98	0.00
shared	kglsim object batch	11.04	11.04	0.00
shared	KQR M PO	10.73	12.14	13.21
shared	ksunfy : SSO free list	24.06	24.06	0.00
shared	KTI-UNDO	16.30	16.30	0.00
shared	PCUR	18.68	17.01	-8.93
shared	PLDIA	9.61	7.27	-24.34
shared	PLMCD	11.58	7.80	-32.60
shared	private strands	16.78	16.78	0.00
shared	SQLA	36.26	40.71	12.27
streams	free memory	8.00	8.00	0.00
	buffer_cache	456.00	456.00	0.00
	fixed_sga	1.31	1.31	0.00
	log_buffer	4.34	4.34	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by Foreground CPU Time, descending

Session Type	First Logon	Foreground CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Coordinator	0109 20:23:56	0.00	0.00	0.00
QMON Slaves	0109 20:24:06	0.00	0.09	0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

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

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(12343)	0	0			0.00	0.00
SYS.AQ$_ALERT_QT_E(12342)	0	0			0.00	0.00
SYSMAN.MGMT_NOTIFY_Q(2607428)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(2607098)	61	61	0.00	0.00	0.64	0.46	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

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

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

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

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

Subscriber/Queue	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE
ZERATUL_THINV_3938_WINMDB2(41)/SYS.ALERT_QUE	0.00	0.00	0.00
ZERATUL_1830_WINMDB2(61)/SYS.ALERT_QUE	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Shared Server Statistics

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

Shared Servers Activity

Values represent averages for all samples

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

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

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
3,612	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

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

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

Back to Shared Server Statistics
Back to Top

init.ora Parameters

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

Parameter Name	Begin value	End value (if different)
audit_file_dest	E:\APP32\MARIAN\ADMIN\WINMDB2\ADUMP
audit_trail	DB
compatible	11.2.0.0.0
_connect_by_use_union_all	FALSE
control_files	F:\ORADATA\WINMDB2\CONTROL01.CTL, F:\ORADATA\WINMDB2\CONTROL02.CTL
cursor_sharing	FORCE
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	WINMDB2
db_recovery_file_dest	D:\Archives\Backups
db_recovery_file_dest_size	161061273600
dbwr_io_slaves	4
db_16k_cache_size	109051904
diagnostic_dest	E:\APP32\MARIAN
disk_asynch_io	FALSE
dispatchers	(PROTOCOL=TCP) (SERVICE=WINMDB2XDB)
memory_target	1828716544
nls_language	ROMANIAN
nls_territory	ROMANIA
open_cursors	600
optimizer_capture_sql_plan_baselines	TRUE
processes	1500
remote_login_passwordfile	EXCLUSIVE
result_cache_max_size	157286400
result_cache_mode	MANUAL
sec_case_sensitive_logon	FALSE
session_cached_cursors	150
sessions	2272
smtp_out_server	mail.thinvest.ro
undo_tablespace	UNDOTBS2

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.03	In-memory Sort %:	100.00
Library Hit %:	94.18	Soft Parse %:	94.92
Execute to Parse %:	42.51	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	43.92	% Non-Parse CPU:	87.48