WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

TOPPROD 2076476065 topprod 1 10-7月 -17 17:07 11.2.0.4.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
TOPPROD	2076476065	topprod	1	10-7月 -17 17:07	11.2.0.4.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

ERPDB Linux x86 64-bit 16 16 2 23.47

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
ERPDB	Linux x86 64-bit	16	16	2	23.47

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 27841 04-8月 -17 19:00:45 98 9.6

End Snap: 27842 04-8月 -17 20:00:52 91 11.1

Elapsed: 60.12 (mins)

DB Time: 81.64 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	27841	04-8月 -17 19:00:45	98	9.6
End Snap:	27842	04-8月 -17 20:00:52	91	11.1
Elapsed:		60.12 (mins)
DB Time:		81.64 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 1.4 0.4 0.00 0.00

DB CPU(s): 0.7 0.2 0.00 0.00

Redo size (bytes): 13,486,054.7 3,515,071.0

Logical read (blocks): 92,450.2 24,096.7

Block changes: 88,435.2 23,050.2

Physical read (blocks): 1,849.9 482.2

Physical write (blocks): 1,695.6 441.9

Read IO requests: 239.0 62.3

Write IO requests: 1,233.3 321.5

Read IO (MB): 14.5 3.8

Write IO (MB): 13.3 3.5

User calls: 668.6 174.3

Parses (SQL): 131.2 34.2

Hard parses (SQL): 14.1 3.7

SQL Work Area (MB): 82.0 21.4

Logons: 0.1 0.0

Executes (SQL): 822.5 214.4

Rollbacks: 0.0 0.0

Transactions: 3.8

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.4	0.4	0.00	0.00
DB CPU(s):	0.7	0.2	0.00	0.00
Redo size (bytes):	13,486,054.7	3,515,071.0
Logical read (blocks):	92,450.2	24,096.7
Block changes:	88,435.2	23,050.2
Physical read (blocks):	1,849.9	482.2
Physical write (blocks):	1,695.6	441.9
Read IO requests:	239.0	62.3
Write IO requests:	1,233.3	321.5
Read IO (MB):	14.5	3.8
Write IO (MB):	13.3	3.5
User calls:	668.6	174.3
Parses (SQL):	131.2	34.2
Hard parses (SQL):	14.1	3.7
SQL Work Area (MB):	82.0	21.4
Logons:	0.1	0.0
Executes (SQL):	822.5	214.4
Rollbacks:	0.0	0.0
Transactions:	3.8

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 92.65 Soft Parse %: 89.26

Execute to Parse %: 84.05 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 64.93 % Non-Parse CPU: 95.97

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		2526.9		51.6
enq: RO - fast object reuse	63	494.1	7843	10.1	Application
enq: KO - fast object checkpoint	43	319.1	7421	6.5	Application
db file sequential read	743,536	263.6	0	5.4	User I/O
free buffer waits	3,796	262.9	69	5.4	Configuration
db file scattered read	50,641	217.8	4	4.4	User I/O
enq: CR - block range reuse ckpt	108	206.2	1909	4.2	Other
log file sync	28,686	172	6	3.5	Commit
log buffer space	167	143.7	860	2.9	Configuration
direct path write	99,589	98.1	1	2.0	User I/O

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
System I/O	233,588	5,571	24	113.7	1.5
DB CPU		2,527		51.6	0.7
Application	2,436	814	334	16.6	0.2
User I/O	981,984	714	1	14.6	0.2
Configuration	4,174	563	135	11.5	0.2
Other	10,687	222	21	4.5	0.1
Commit	28,688	172	6	3.5	0.0
Network	2,888,123	35	0	.7	0.0
Concurrency	300	2	7	.0	0.0

Host CPU

CPUs Cores Sockets Load Average Begin Load Average End %User %System %WIO %Idle

16 16 2 2.22 0.71 4.3 1.2 8.2 94.3

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
16	16	2	2.22	0.71	4.3	1.2	8.2	94.3

Instance CPU

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

5.4 94.9 0.0

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

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 1,587.9 262.3 1,325.6

Database Requests: 1,472.3 239.0 1,233.3

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 87.6 13.7 73.9

Total (MB): 81.4 28.0 53.4

Database (MB): 27.7 14.5 13.3

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 40.0 13.4 26.6

Database (blocks): 3,545.5 1,849.9 1,695.6

Via Buffer Cache (blocks): 2,498.5 1,006.2 1,492.3

Direct (blocks): 1,047.0 843.7 203.3

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	1,587.9	262.3	1,325.6
Database Requests:	1,472.3	239.0	1,233.3
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	87.6	13.7	73.9
Total (MB):	81.4	28.0	53.4
Database (MB):	27.7	14.5	13.3
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	40.0	13.4	26.6
Database (blocks):	3,545.5	1,849.9	1,695.6
Via Buffer Cache (blocks):	2,498.5	1,006.2	1,492.3
Direct (blocks):	1,047.0	843.7	203.3

Memory Statistics

Begin End

Host Mem (MB): 24,030.1 24,030.1

SGA use (MB): 4,000.0 4,000.0

PGA use (MB): 425.9 399.0

% Host Mem used for SGA+PGA: 18.42 18.31

	Begin	End
Host Mem (MB):	24,030.1	24,030.1
SGA use (MB):	4,000.0	4,000.0
PGA use (MB):	425.9	399.0
% Host Mem used for SGA+PGA:	18.42	18.31

Cache Sizes

Begin End

Buffer Cache: 1,648M 1,648M Std Block Size: 8K

Shared Pool Size: 2,016M 2,054M Log Buffer: 18,840K

	Begin	End
Buffer Cache:	1,648M	1,648M	Std Block Size:	8K
Shared Pool Size:	2,016M	2,054M	Log Buffer:	18,840K

Shared Pool Statistics

Begin End

Memory Usage %: 75.78 73.88

% SQL with executions>1: 69.09 86.16

% Memory for SQL w/exec>1: 65.64 89.32

	Begin	End
Memory Usage %:	75.78	73.88
% SQL with executions>1:	69.09	86.16
% Memory for SQL w/exec>1:	65.64	89.32

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	4,501.37	91.89
DB CPU	2,526.91	51.58
parse time elapsed	160.62	3.28
hard parse elapsed time	141.97	2.90
connection management call elapsed time	19.85	0.41
PL/SQL compilation elapsed time	14.95	0.31
PL/SQL execution elapsed time	5.63	0.12
failed parse elapsed time	5.47	0.11
repeated bind elapsed time	1.17	0.02
hard parse (sharing criteria) elapsed time	0.62	0.01
sequence load elapsed time	0.07	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	4,898.69
background elapsed time	6,120.23
background cpu time	584.35

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
BUSY_TIME	327,946
IDLE_TIME	5,388,488
IOWAIT_TIME	471,036
NICE_TIME	0
SYS_TIME	67,940
USER_TIME	248,404
LOAD	2	1
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	41,422,848
VM_OUT_BYTES	206,065,664
PHYSICAL_MEMORY_BYTES	25,197,383,680
NUM_CPUS	16
NUM_CPU_CORES	16
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
04-8月 19:00:45	2.22
04-8月 20:00:52	0.71	5.74	4.35	1.19	94.26	8.24

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 101.3% of Total DB time 4,898.69 (s)
Total FG Wait Time: 2,436.54 (s) DB CPU time: 2,526.91 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			2,527		51.58
Application	2,436	0	814	334	16.61
User I/O	961,891	0	639	1	13.05
Configuration	4,165	0	560	134	11.43
Other	1,084	0	215	199	4.40
Commit	28,686	0	172	6	3.51
Network	2,887,277	0	35	0	0.72
Concurrency	165	0	1	8	0.03
System I/O	3,674	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
enq: RO - fast object reuse	63	0	494	7843	0.00	10.09
enq: KO - fast object checkpoint	43	0	319	7421	0.00	6.51
db file sequential read	743,536	0	264	0	53.72	5.38
free buffer waits	3,796	0	263	69	0.27	5.37
db file scattered read	50,641	0	218	4	3.66	4.45
enq: CR - block range reuse ckpt	108	0	206	1909	0.01	4.21
log file sync	28,686	0	172	6	2.07	3.51
log buffer space	167	0	144	860	0.01	2.93
direct path write	99,589	0	98	1	7.20	2.00
log file switch (private strand flush incomplete)	92	0	96	1041	0.01	1.95
log file switch (checkpoint incomplete)	21	0	45	2122	0.00	0.91
SQL*Net more data to client	406,248	0	25	0	29.35	0.52
direct path read	33,916	0	25	1	2.45	0.50
direct path write temp	13,360	0	22	2	0.97	0.44
db file parallel read	1,494	0	12	8	0.11	0.25
write complete waits	6	0	10	1700	0.00	0.21
SQL*Net more data from client	179,377	0	7	0	12.96	0.15
rdbms ipc reply	13	15	5	361	0.00	0.10
block change tracking buffer space	6	33	3	553	0.00	0.07
log file switch completion	83	0	3	35	0.01	0.06
SQL*Net message to client	2,301,382	0	2	0	166.28	0.04
latch: In memory undo latch	1	0	1	1226	0.00	0.03
ADR block file read	36	0	1	27	0.00	0.02
direct path read temp	16,986	0	1	0	1.23	0.02
SQL*Net message from dblink	134	0	1	4	0.01	0.01
SQL*Net break/reset to client	2,330	0	0	0	0.17	0.01
Data file init write	242	0	0	1	0.02	0.00
latch: shared pool	120	0	0	1	0.01	0.00
reliable message	498	0	0	0	0.04	0.00
Disk file operations I/O	2,116	0	0	0	0.15	0.00
control file sequential read	3,641	0	0	0	0.26	0.00
control file parallel write	33	0	0	1	0.00	0.00
library cache: mutex X	4	0	0	3	0.00	0.00
db file single write	11	0	0	1	0.00	0.00
change tracking file synchronous read	132	0	0	0	0.01	0.00
latch: redo allocation	203	0	0	0	0.01	0.00
latch: row cache objects	16	0	0	0	0.00	0.00
latch: cache buffers lru chain	31	0	0	0	0.00	0.00
ADR block file write	5	0	0	1	0.00	0.00
latch free	32	0	0	0	0.00	0.00
SQL*Net message from client	2,301,381	0	151,721	66	166.28
single-task message	2	0	0	69	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
db file async I/O submit	5,238	0	4,505	860	0.38	73.60
log file parallel write	94,970	0	951	10	6.86	15.55
control file parallel write	5,881	0	64	11	0.42	1.04
db file single write	5,060	0	40	8	0.37	0.66
Log archive I/O	48,417	0	35	1	3.50	0.57
db file sequential read	11,852	0	18	2	0.86	0.30
db file scattered read	1,427	0	16	11	0.10	0.26
log file sequential read	49,487	0	12	0	3.58	0.20
enq: CF - contention	23	0	5	205	0.00	0.08
log buffer space	2	0	3	1681	0.00	0.05
db file parallel write	153	0	3	17	0.01	0.04
control file sequential read	25,348	0	1	0	1.83	0.02
change tracking file synchronous write	175	0	1	5	0.01	0.01
os thread startup	16	0	1	38	0.00	0.01
rdbms ipc reply	69	0	1	8	0.00	0.01
Disk file operations I/O	1,750	0	0	0	0.13	0.01
log file single write	420	0	0	1	0.03	0.00
LGWR wait for redo copy	8,444	0	0	0	0.61	0.00
free buffer waits	7	0	0	11	0.00	0.00
read by other session	5	0	0	8	0.00	0.00
ADR block file read	16	0	0	1	0.00	0.00
latch free	161	0	0	0	0.01	0.00
latch: shared pool	16	0	0	1	0.00	0.00
buffer busy waits	52	0	0	0	0.00	0.00
log file sync	2	0	0	5	0.00	0.00
latch: cache buffers chains	46	0	0	0	0.00	0.00
direct path sync	1	0	0	3	0.00	0.00
asynch descriptor resize	290	100	0	0	0.02	0.00
change tracking file synchronous read	176	0	0	0	0.01	0.00
ADR block file write	5	0	0	0	0.00	0.00
latch: redo allocation	54	0	0	0	0.00	0.00
latch: cache buffers lru chain	35	0	0	0	0.00	0.00
ARCH wait for archivelog lock	115	0	0	0	0.01	0.00
rdbms ipc message	120,350	14	54,847	456	8.70
Space Manager: slave idle wait	5,692	72	23,202	4076	0.41
EMON slave idle wait	3,600	100	18,003	5001	0.26
DIAG idle wait	7,190	100	7,197	1001	0.52
Streams AQ: qmn coordinator idle wait	260	50	3,613	13897	0.02
Streams AQ: qmn slave idle wait	130	0	3,612	27785	0.01
Streams AQ: emn coordinator idle wait	360	100	3,601	10003	0.03
pmon timer	1,254	95	3,601	2871	0.09
smon timer	108	6	3,453	31972	0.01
SQL*Net message from client	1,098	0	1	1	0.08
class slave wait	16	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	52	63.5	1.9		21.2	7.7		5.8
ADR block file write	10	100.0
ADR file lock	12	100.0
ARCH wait for archivelog lock	115	100.0
Data file init write	242	88.0	12.0
Disk file operations I/O	3867	96.9	.7	2.0	.2	.0	.0	.0
LGWR wait for redo copy	8438	100.0
Log archive I/O	48.4K	98.2	1.8	.0	.0	.0	.0	.0
SQL*Net break/reset to client	2330	100.0		.0
SQL*Net message from dblink	134	85.8	6.7	.7	1.5	1.5	2.2	1.5
SQL*Net message to client	2301.8K	100.0
SQL*Net message to dblink	132	100.0
SQL*Net more data from client	179.4K	99.2	.3	.5	.0
SQL*Net more data from dblink	2	100.0
SQL*Net more data to client	406.3K	100.0	.0	.0	.0	.0	.0	.0
SQL*Net more data to dblink	2	100.0
asynch descriptor resize	290	100.0
block change tracking buffer space	6						33.3	66.7
buffer busy waits	61	100.0
change tracking file synchronous read	308	99.4		.6
change tracking file synchronous write	175	84.6	9.7	1.1	1.1	1.7	.6	1.1
control file parallel write	5914	8.6	49.0	29.3	7.3	2.4	1.2	2.0	.2
control file sequential read	29K	99.9		.0	.0	.0		.0
db file async I/O submit	5240	8.1	12.1	11.7	12.2	11.6	7.1	14.8	22.3
db file parallel read	1494	53.3	7.0	7.3	13.7	8.8	6.0	3.9
db file parallel write	153	32.7	22.2	17.0	13.1	9.2	3.3	2.0	.7
db file scattered read	52.1K	68.9	1.6	13.2	9.0	3.7	2.3	1.3	.0
db file sequential read	755.4K	96.6	.4	1.1	1.5	.3	.1	.1	.0
db file single write	5071	71.4	19.0	4.9	.8	.6	.4	2.9	.1
direct path read	33.9K	95.6	.4	1.1	.9	1.1	.7	.2
direct path read temp	17K	100.0
direct path sync	1			100.0
direct path write	99.6K	79.4	17.5	2.1	.4	.4	.1	.1
direct path write temp	13.4K	16.7	73.6	8.3	.5	.6	.3	.1
enq: CF - contention	23	4.3		4.3	8.7	13.0	13.0	52.2	4.3
enq: CR - block range reuse ckpt	108		2.8	60.2	4.6	9.3	6.5	1.9	14.8
enq: KO - fast object checkpoint	43	4.7	2.3	2.3			2.3	7.0	81.4
enq: RO - fast object reuse	63	9.5	4.8			1.6	1.6		82.5
free buffer waits	3803	.3	.1	.2	.2	93.5		3.4	2.3
latch free	193	100.0
latch: In memory undo latch	1								100.0
latch: cache buffers chains	60	100.0
latch: cache buffers lru chain	66	100.0
latch: call allocation	2	100.0
latch: checkpoint queue latch	21	100.0
latch: enqueue hash chains	1	100.0
latch: object queue header operation	24	100.0
latch: redo allocation	257	100.0
latch: row cache objects	19	94.7	5.3
latch: shared pool	134	84.3	4.5	.7	5.2	3.7	1.5
library cache: mutex X	5	80.0				20.0
log buffer space	169			.6		3.0	5.9	58.6	32.0
log file parallel write	94.8K	21.2	13.8	7.6	19.4	32.9	3.5	1.6	.1
log file sequential read	49.5K	100.0	.0	.0	.0	.0
log file single write	420	91.9	5.7	1.2	.7	.2	.2
log file switch (checkpoint incomplete)	21					28.6	14.3	9.5	47.6
log file switch (private strand flush incomplete)	92	1.1				31.5	16.3	12.0	39.1
log file switch completion	83				1.2	27.7	49.4	21.7
log file sync	28.5K	28.5	37.2	11.5	13.9	6.4	1.8	.6	.1
os thread startup	16					43.8	37.5	18.8
rdbms ipc reply	82	29.3	2.4	12.2	20.7	23.2	7.3	2.4	2.4
read by other session	5	80.0						20.0
reliable message	498	99.4			.2	.4
write complete waits	6							50.0	50.0
DIAG idle wait	7189							100.0
EMON slave idle wait	3600								100.0
SQL*Net message from client	2302.1K	95.6	1.8	.7	.5	.5	.5	.2	.1
Space Manager: slave idle wait	5661	.1		.0	.2	.1	.2	11.9	87.5
Streams AQ: emn coordinator idle wait	360								100.0
Streams AQ: qmn coordinator idle wait	260	49.6						.4	50.0
Streams AQ: qmn slave idle wait	130								100.0
class slave wait	16	100.0
pmon timer	1254	.4		.1	.2	.4	.2	3.0	95.8
rdbms ipc message	120.1K	17.4	2.8	12.6	6.1	4.4	21.3	27.7	7.8
single-task message	2				50.0			50.0
smon timer	106							48.1	51.9

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ADR block file read	3	94.2	1.9			3.8
Disk file operations I/O	1	100.0	.0
Log archive I/O	8	100.0	.0	.0
SQL*Net message from dblink	2	98.5	.7			.7
SQL*Net more data to client	114	100.0	.0	.0	.0	.0
block change tracking buffer space	4	33.3				16.7	50.0
change tracking file synchronous write	2	98.9		.6			.6
control file parallel write	130	97.8	.5	.3	.3	.5	.3	.2	.0
control file sequential read	4	100.0		.0		.0
db file async I/O submit	884	62.8	3.5	3.1	3.4	2.5	2.3	2.0	20.3
db file parallel read	58	96.1	2.4	.5	.3	.5	.1
db file parallel write	4	97.4	1.3		.7			.7
db file scattered read	675	98.7	.7	.3	.1	.1	.1	.0	.0
db file sequential read	713	99.9	.0	.0	.0	.0	.0	.0
db file single write	152	97.0	.3	.9	1.1	.6	.1	.1
direct path read	74	99.8	.1	.1	.0		.0
direct path write	81	99.9	.0	.0	.0	.0
direct path write temp	7	99.9	.0	.0
enq: CF - contention	12	43.5	30.4	21.7					4.3
enq: CR - block range reuse ckpt	2	83.3	.9		.9				14.8
enq: KO - fast object checkpoint	3	11.6	2.3			2.3	2.3		81.4
free buffer waits	197	94.3	.1	.2	.4	1.0	1.7	1.8	.5
latch: In memory undo latch	1							100.0
log buffer space	131	9.5	3.6	13.6	11.2	14.8	15.4	18.9	13.0
log file parallel write	1617	98.3	1.0	.4	.1	.1	.1	.1	.0
log file switch (checkpoint incomplete)	3	42.9	4.8		4.8			4.8	42.9
log file switch (private strand flush incomplete)	25	48.9	3.3		1.1	3.3	4.3	15.2	23.9
log file switch completion	18	78.3	6.0	14.5	1.2
log file sync	176	99.3	.3	.1	.1	.0	.0	.1	.0
os thread startup	3	81.3	6.3	6.3	6.3
rdbms ipc reply	4	95.1	1.2				1.2	2.4
read by other session	1	80.0	20.0
write complete waits	4		16.7			16.7	16.7	16.7	33.3

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 4s to 2m	<2s	<4s	<8s	<16s	<32s
		% of Total Waits
control file parallel write	1	100.0	.0
db file async I/O submit	1065	79.7	15.6	4.2	.5
db file scattered read	4	100.0	.0
enq: CF - contention	1	95.7	4.3
enq: CR - block range reuse ckpt	16	85.2		1.9	12.0	.9
enq: KO - fast object checkpoint	35	18.6		32.6	48.8
enq: RO - fast object reuse	52	17.5	4.8	28.6	44.4	4.8
free buffer waits	18	99.5	.4	.1
log buffer space	22	87.0	10.7	2.4
log file parallel write	34	100.0	.0	.0
log file switch (checkpoint incomplete)	9	57.1	19.0	23.8
log file switch (private strand flush incomplete)	22	76.1	20.7	3.3
log file sync	13	100.0	.0
write complete waits	2	66.7	16.7	16.7

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)
topprod	4,870	2,521	6,489	332,979
SYS$USERS	29	5	46	95
SYS$BACKGROUND	0	0	138	288

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
topprod	954713	627	160	1	2886294	35
SYS$USERS	7178	12	3	0	1094	0
SYS$BACKGROUND	20085	75	134	1	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 20.3% of Total DB Time (s): 4,899
Captured PL/SQL account for 0.2% of Total DB Time (s): 4,899

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
172.51	6	28.75	3.52	89.30	9.85	fwbtm6g368j79	ORACLE.EXE	SELECT "A1"."IMM01", '', TO_CH...
156.76	5	31.35	3.20	83.39	15.70	6k38zq7rf14c8	ORACLE.EXE	SELECT "A1"."PMM01", "A1"."PMM...
80.45	9	8.94	1.64	0.90	2.36	78hqmypm5qfmb	fglrun-bin@PAYERP-AP (TNS V1-V3)	select SUM(rvb07) from rvb_fil...
62.50	6	10.42	1.28	9.73	0.58	1vdsz959xtu4p	ORACLE.EXE	SELECT "A2"."RVB01", "A2"."RVB...
50.64	6	8.44	1.03	27.16	24.17	1sjkusdtcpg9c	ORACLE.EXE	SELECT "A3"."OGB01", "A3"."OGB...
45.27	16	2.83	0.92	25.97	0.26	3kz8jkurqn3c8	ORACLE.EXE	SELECT "A2"."RVA01", "A2"."RVA...
35.05	6	5.84	0.72	8.57	5.60	0wjyd6jkgp4h6	ORACLE.EXE	SELECT "A1"."RVA01", TO_CHAR("...
30.74	6	5.12	0.63	21.61	46.32	7wj19b74z7yy4	ORACLE.EXE	SELECT "A1"."OGA01", TO_CHAR("...
26.89	3	8.96	0.55	2.74	0.30	358zavwbh5f6n	ORACLE.EXE	SELECT "PMM01", "PMM04", "PMM0...
26.45	3	8.82	0.54	2.91	0.44	b45u3b52kx4v7	ORACLE.EXE	SELECT "PMM01", "PMM04", "PMM0...

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

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
154.05	6	25.68	6.10	172.51	89.30	9.85	fwbtm6g368j79	ORACLE.EXE	SELECT "A1"."IMM01", '', TO_CH...
130.72	5	26.14	5.17	156.76	83.39	15.70	6k38zq7rf14c8	ORACLE.EXE	SELECT "A1"."PMM01", "A1"."PMM...
15.18	15	1.01	0.60	15.29	99.27	0.03	6g4dgxt73981r	fglrun-bin@PAYERP-AP (TNS V1-V3)	select distinct omf00, omf01, ...
13.75	6	2.29	0.54	50.64	27.16	24.17	1sjkusdtcpg9c	ORACLE.EXE	SELECT "A3"."OGB01", "A3"."OGB...
12.72	69,368	0.00	0.50	14.45	88.04	11.78	60uw2vh6q9vn2		insert into col$(obj#, name, i...
11.76	16	0.73	0.47	45.27	25.97	0.26	3kz8jkurqn3c8	ORACLE.EXE	SELECT "A2"."RVA01", "A2"."RVA...
10.18	5,222	0.00	0.40	13.09	77.74	21.91	33cmj01uf5zfb		delete from col$ where obj#=:1
9.98	6	1.66	0.39	20.84	47.87	28.95	591q7n5r70vkw	ORACLE.EXE	SELECT "A3"."OGB01", "A3"."OGB...
9.29	50,826	0.00	0.37	18.31	50.73	49.36	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
7.49	53,404	0.00	0.30	9.00	83.29	16.04	83taa7kaw59c1		select name, intcol#, segcol#,...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
24.61	5	4.92	3.45	156.76	83.39	15.70	6k38zq7rf14c8	ORACLE.EXE	SELECT "A1"."PMM01", "A1"."PMM...
16.99	6	2.83	2.38	172.51	89.30	9.85	fwbtm6g368j79	ORACLE.EXE	SELECT "A1"."IMM01", '', TO_CH...
14.24	6	2.37	2.00	30.74	21.61	46.32	7wj19b74z7yy4	ORACLE.EXE	SELECT "A1"."OGA01", TO_CHAR("...
12.83	49,296	0.00	1.80	15.26	29.07	84.07	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
12.24	6	2.04	1.72	50.64	27.16	24.17	1sjkusdtcpg9c	ORACLE.EXE	SELECT "A3"."OGB01", "A3"."OGB...
9.04	50,826	0.00	1.27	18.31	50.73	49.36	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
9.00	1	9.00	1.26	11.90	29.83	75.62	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
7.59	3	2.53	1.06	8.65	12.09	87.72	7ksjhpjvkn647	ORACLE.EXE	SELECT "OMF03", "OMF16", "OMF1...
7.52	6	1.25	1.05	8.71	16.65	86.34	7vun041qzbkmz	ORACLE.EXE	SELECT "A1"."RVU01", "A1"."RVU...
6.98	8,840	0.00	0.98	7.56	4.85	92.29	62p83a4v443bf	fglrun-bin@PAYERP-AP (TNS V1-V3)	select gae04, gav03, gav04, ga...

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: 333,497,789
Captured SQL account for 24.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
46,969,738	5	9,393,947.60	14.08	156.76	83.4	15.7	6k38zq7rf14c8	ORACLE.EXE	SELECT "A1"."PMM01", "A1"."PMM...
8,544,060	6	1,424,010.00	2.56	50.64	27.2	24.2	1sjkusdtcpg9c	ORACLE.EXE	SELECT "A3"."OGB01", "A3"."OGB...
7,201,212	6	1,200,202.00	2.16	172.51	89.3	9.8	fwbtm6g368j79	ORACLE.EXE	SELECT "A1"."IMM01", '', TO_CH...
6,492,431	6	1,082,071.83	1.95	20.84	47.9	29	591q7n5r70vkw	ORACLE.EXE	SELECT "A3"."OGB01", "A3"."OGB...
1,590,745	6	265,124.17	0.48	12.49	40.8	1	355gqw3b8pcuy	ORACLE.EXE	SELECT "A1"."OGA01", TO_CHAR("...
1,588,856	6	264,809.33	0.48	30.74	21.6	46.3	7wj19b74z7yy4	ORACLE.EXE	SELECT "A1"."OGA01", TO_CHAR("...
921,156	69,368	13.28	0.28	14.45	88	11.8	60uw2vh6q9vn2		insert into col$(obj#, name, i...
628,229	5,222	120.30	0.19	13.09	77.7	21.9	33cmj01uf5zfb		delete from col$ where obj#=:1
461,085	50,826	9.07	0.14	18.31	50.7	49.4	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
410,643	6	68,440.50	0.12	62.50	9.7	.6	1vdsz959xtu4p	ORACLE.EXE	SELECT "A2"."RVB01", "A2"."RVB...

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: 6,673,346
Captured SQL account for 24.4% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
243,785	6	40,630.83	3.65	6.49	72.98	26.44	40h437t5013u3	ORACLE.EXE	SELECT "A1"."RVV01", "A1"."RVV...
155,437	6	25,906.17	2.33	62.50	9.73	0.58	1vdsz959xtu4p	ORACLE.EXE	SELECT "A2"."RVB01", "A2"."RVB...
140,472	6	23,412.00	2.10	4.97	75.32	6.73	fb6wkr62s47mv	ORACLE.EXE	SELECT "A2"."INB01", "A2"."INB...
124,858	1	124,858.00	1.87	11.90	29.83	75.62	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
116,132	9	12,903.56	1.74	80.45	0.90	2.36	78hqmypm5qfmb	fglrun-bin@PAYERP-AP (TNS V1-V3)	select SUM(rvb07) from rvb_fil...
101,937	6	16,989.50	1.53	8.71	16.65	86.34	7vun041qzbkmz	ORACLE.EXE	SELECT "A1"."RVU01", "A1"."RVU...
100,020	5	20,004.00	1.50	10.53	39.23	61.43	b3k1j7c3djjqd	ORACLE.EXE	SELECT "DBTYPE", "SFA01", "SFA...
89,567	6	14,927.83	1.34	50.64	27.16	24.17	1sjkusdtcpg9c	ORACLE.EXE	SELECT "A3"."OGB01", "A3"."OGB...
78,946	6	13,157.67	1.18	5.07	61.83	7.59	dkyqv38h875m3	ORACLE.EXE	SELECT "A2"."RVV01", "A2"."RVV...
76,021	6	12,670.17	1.14	20.84	47.87	28.95	591q7n5r70vkw	ORACLE.EXE	SELECT "A3"."OGB01", "A3"."OGB...
73,210	6	12,201.67	1.10	30.74	21.61	46.32	7wj19b74z7yy4	ORACLE.EXE	SELECT "A1"."OGA01", TO_CHAR("...
71,836	6	11,972.67	1.08	35.05	8.57	5.60	0wjyd6jkgp4h6	ORACLE.EXE	SELECT "A1"."RVA01", TO_CHAR("...

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: 862,141
Captured SQL account for 14.6% of Total
Total UnOptimized Read Requests: 862,141
Captured SQL account for 14.6% 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
34,046	34,046	6	5,674.33	3.95	1sjkusdtcpg9c	ORACLE.EXE	SELECT "A3"."OGB01", "A3"."OGB...
20,700	20,700	6	3,450.00	2.40	0wjyd6jkgp4h6	ORACLE.EXE	SELECT "A1"."RVA01", TO_CHAR("...
20,501	20,501	6	3,416.83	2.38	591q7n5r70vkw	ORACLE.EXE	SELECT "A3"."OGB01", "A3"."OGB...
11,866	11,866	49,296	0.24	1.38	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
6,356	6,356	6	1,059.33	0.74	fwbtm6g368j79	ORACLE.EXE	SELECT "A1"."IMM01", '', TO_CH...
5,310	5,310	94,901	0.06	0.62	9tgj4g8y4rwy8		select type#, blocks, extents,...
4,010	4,010	3	1,336.67	0.47	7ksjhpjvkn647	ORACLE.EXE	SELECT "OMF03", "OMF16", "OMF1...
3,304	3,304	6	550.67	0.38	7wj19b74z7yy4	ORACLE.EXE	SELECT "A1"."OGA01", TO_CHAR("...
3,242	3,242	6	540.33	0.38	40h437t5013u3	ORACLE.EXE	SELECT "A1"."RVV01", "A1"."RVV...
2,065	2,065	6	344.17	0.24	1vdsz959xtu4p	ORACLE.EXE	SELECT "A2"."RVB01", "A2"."RVB...

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: 2,966,879
Captured SQL account for 24.8% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
102,745	95,155	0.93	4.70	63.7	38.5	3nkd3g3ju5ph1		select obj#, type#, ctime, mti...
94,901	94,057	0.99	5.94	55.5	55.3	9tgj4g8y4rwy8		select type#, blocks, extents,...
69,368	69,368	1.00	14.45	88	11.8	60uw2vh6q9vn2		insert into col$(obj#, name, i...
53,404	1,186,686	22.22	9.00	83.3	16	83taa7kaw59c1		select name, intcol#, segcol#,...
53,382	349,781	6.55	5.18	53.2	45.8	2q93zsrvbdw48		select grantee#, privilege#, n...
50,826	57,064	1.12	18.31	50.7	49.4	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
49,296	49,296	1.00	15.26	29.1	84.1	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
48,316	48,316	1.00	5.74	95.2	4.2	c49tbx3qqrtm4		insert into dependency$(d_obj#...
48,019	48,019	1.00	3.82	95.4	1.7	2h0gb24h6zpnu		insert into access$(d_obj#, or...
8,840	7,875	0.89	7.56	4.9	92.3	62p83a4v443bf	fglrun-bin@PAYERP-AP (TNS V1-V3)	select gae04, gav03, gav04, ga...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 473,177
Captured SQL account for 38.3% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
8,840	8,840	1.87	62p83a4v443bf	fglrun-bin@PAYERP-AP (TNS V1-V3)	select gae04, gav03, gav04, ga...
8,768	8,768	1.85	fcyws29qzab6f	fglrun-bin@PAYERP-AP (TNS V1-V3)	select gaj03, gaj04, gaj05, ga...
7,887	7,887	1.67	gdhz78y24tvnz		delete from ncomp_dll$ where o...
7,878	7,878	1.66	9y7s2afnkqs9d		delete from idl_ub2$ where obj...
7,878	7,878	1.66	d5jd9b2xct7xz		delete from idl_char$ where ob...
7,878	7,878	1.66	dvpfc386d6dmm		delete from idl_sb4$ where obj...
7,878	7,878	1.66	gsqxm6zz3w2by		delete from idl_ub1$ where obj...
7,875	7,875	1.66	a0u7bj627dfqt	fglrun-bin@PAYERP-AP (TNS V1-V3)	select gbs06 from gbs_file whe...
7,419	7,419	1.57	bvn085xhxfn9f		insert into sys.wri$_optstat_h...
6,226	6,226	1.32	74anujtt8zw4h		select o.owner#, o.name, o.nam...
6,078	6,078	1.28	1qpdxynxddx8j	fglrun-bin@PAYERP-AP (TNS V1-V3)	select gav12, gav13, gav16, ga...
5,545	5,545	1.17	8w4c8u9udsuyy		select count(*) from ( select ...
5,370	5,370	1.13	1gfaj4z5hn1kf		delete from dependency$ where ...
5,370	5,370	1.13	20vv6ttajyjzq		delete from access$ where d_ob...
5,220	5,222	1.10	2wdrw5tqputaq		delete from cdef$ where obj#=:...
5,070	5,222	1.07	33cmj01uf5zfb		delete from col$ where obj#=:1
5,042	7,712	1.07	cd0nwpf4hc43s		insert into objauth$(option$, ...
5,029	5,029	1.06	2jfqzrxhrm93b		select /+ rule / c.name, u.n...
5,029	5,029	1.06	2skwhauh2cwky		select o.name, u.name from obj...

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,464,042	6	0.07	40ju0vrjd86s5	fglrun-bin@PAYERP-AP (TNS V1-V3)	create table tt36208
1,091,813	6	0.05	cu8mztahhpwhr	ORACLE.EXE	SELECT DISTINCT "A2"."IMM01", ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0wjyd6jkgp4h6 SELECT "A1"."RVA01", TO_CHAR("A1"."RVACOND", 'yyyyMMdd'), "A1"."RVA05", "A1"."RVACONF", TO_CHAR("A1"."RVA06", 'yyyyMMdd'), "A1"."PMC081", "A1"."RVA10" FROM "HT_RVA_VIEW" "A1" WHERE "A1"."RVA10"<>'SUB' AND "A1"."DBTYPE"='1'

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

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

1qpdxynxddx8j select gav12, gav13, gav16, gav17, gav18, gav19, gav21, gav24, gav25, gav31, gav33, gav34, gav36, gav37 from gav_file where gav01 = :p1 AND gav02 = :p2 AND gav_file.gav08 = :p3 AND gav_file.gav11 = :p4

1sjkusdtcpg9c SELECT "A3"."OGB01", "A3"."OGB03", "A3"."OGBUD02", "A3"."OGBUD03", "A3"."OGBUD04", "A3"."OGBUD06", "A3"."OGBUD01", "A3"."OGB04", "A3"."OGB12", "A3"."OGB09", "A3"."OGB091", "A3"."OGB092", "A3"."OEBUD02", "A3"."OEBUD03", "A3"."OGBUD07" FROM "HTOGB1_VIEW" "A3", "HTOGA1_VIEW" "A2", "HTOGA1_VIEW" "A1" WHERE "A1"."OGA09"='1' AND "A3"."OGB01"="A1"."OGA01" AND "A3"."DBTYPE"='1' AND "A2"."OGACONF"='Y' AND ("A2"."OGA09"='0' AND SUBSTR("A2"."OGA01", 1, 4)='S841' OR "A2"."OGA09"='1' AND SUBSTR("A3"."OGB09", 4, 1)='3') AND "A3"."OGB01"="A2"."OGA01" AND "A3"."DBTYPE"='1' AND "A1"."OGA01"=ANY (SELECT "A5"."OGB01" FROM "HTOGB1_VIEW" "A5", "HTOGA1_VIEW" "A4" WHERE "A5"."DBTYPE"='1' AND "A4"."OGACONF"='Y' AND ("A4"."OGA09"='0' AND SUBSTR("A4"."OGA01", 1, 4)='S841' OR "A4"."OGA09"='1' AND SUBSTR("A5"."OGB09", 4, 1)='3') AND "A5"."OGB01"="A4"."OGA01" AND "A4"."DBTYPE"='1' AND "A5"."DBTYPE"='1') AND "A1"."DBTYPE"='1' AND "A2"."DBTYPE"='1'

1vdsz959xtu4p SELECT "A2"."RVB01", "A2"."RVB02", "A2"."RVB05", "A2"."RVB051", "A2"."IMA021", "A2"."RVB07", "A2"."RVB36", "A2"."RVB37", "A2"."RVB38", "A2"."RVB40", "A2"."RVB30", "A2"."RVB29", '', '' FROM "HT_RVB_VIEW" "A2", "HT_RVA_VIEW" "A1" WHERE "A1"."RVA10"<>'SUB' AND "A2"."RVB01"="A1"."RVA01" AND "A2"."DBTYPE"='1' AND "A1"."DBTYPE"='1'

20vv6ttajyjzq delete from access$ where d_obj#=:1

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

2jfqzrxhrm93b select /*+ rule */ 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#

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#

2wdrw5tqputaq delete from cdef$ where obj#=:1

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

355gqw3b8pcuy SELECT "A1"."OGA01", TO_CHAR("A1"."OGA69", 'yyyyMMdd'), TO_CHAR("A1"."OGACOND", 'yyyyMMdd'), "A1"."OGAORIG", "A1"."OGACONF", "A1"."OGAUD06", "A1"."OGA03", "A1"."OGA032", "A1"."OCC18" FROM "HTOGA1_VIEW" "A1" WHERE "A1"."OGA09"='0' AND "A1"."OGA01"=ANY (SELECT "A3"."OGB01" FROM "HTOGB1_VIEW" "A3", "HTOGA1_VIEW" "A2" WHERE "A3"."DBTYPE"='1' AND "A2"."OGACONF"='Y' AND ("A2"."OGA09"='0' AND SUBSTR("A2"."OGA01", 1, 4)='S841' OR "A2"."OGA09"='1' AND SUBSTR("A3"."OGB09", 4, 1)='3') AND "A3"."OGB01"="A2"."OGA01" AND "A3"."DBTYPE "='1' AND "A2"."DBTYPE"='1') AND "A1"."DBTYPE"='1'

358zavwbh5f6n SELECT "PMM01", "PMM04", "PMM09", "PMM22", "PMN02", "PMN04", "CGWJL", "PMM25", "PMN16", "PMC909", "PMCUD13", "RVB07_N" FROM "PO_PMM_VIEW" "T" WHERE "PMN16"='2' AND "PMM22"='RMB' AND "PMN04"='105010090' AND "CGWJL">0 AND "PMM25"<>'0' AND ("PMM01"='ZP20-16100639' OR "PMC909"='Y' AND "PMM04">=TO_CHAR("PMCUD13", 'yyyy-MM-dd')) AND LOWER("PMM09")='c0298'

3kz8jkurqn3c8 SELECT "A2"."RVA01", "A2"."RVA02", "A2"."RVA03", "A2"."RVA04", "A2"."RVA05", "A2"."RVA06", "A2"."RVA07", "A2"."RVA08", "A2"."RVA09", "A2"."RVA10", "A2"."RVAPRSW", "A2"."RVA20", "A2"."RVA21", "A2"."RVA22", "A2"."RVA23", "A2"."RVA24", "A2"."RVA25", "A2"."RVA26", "A2"."RVA27", "A2"."RVA28", "A2"."RVA99", "A2"."RVACONF", "A2"."RVAPRNO", "A2"."RVAACTI", "A2"."RVAUSER", "A2"."RVAGRUP", "A2"."RVAMODU", "A2"."RVADATE", "A2"."RVAS PC", "A2"."RVA100", "A2"."RVAUD01", "A2"."RVAUD02", "A2"."RVAUD03", "A2"."RVAUD04", "A2"."RVAUD05", "A2"."RVAUD06", "A2"."RVAUD07", "A2"."RVAUD08", "A2"."RVAUD09", "A2"."RVAUD10", "A2"."RVAUD11", "A2"."RVAUD12", "A2"."RVAUD13", "A2"."RVAUD14", "A2"."RVAUD15", "A2"."RVA00", "A2"."RVA111", "A2"."RVA112", "A2"."RVA113", "A2"."RVA114", "A2"."RVA115", "A2"."RVA116", "A2"."RVA117", "A2"."RVA29", "A2"."RVA30", "A2"."RVA31", "A2"."RVACOND" , "A2"."RVACONU", "A2"."RVACRAT", "A2"."RVAPLANT", "A2"."RVALEGAL", "A2"."RVAORIU", "A2"."RVAORIG", "A2"."RVA32", "A2"."RVA33", "A2"."RVAMKSG", "A2"."RVACONT", "A2"."RVA34", "A1"."RVB01", "A1"."RVB02", "A1"."RVB03", "A1"."RVB04", "A1"."RVB05", "A1"."RVB06", "A1"."RVB07", "A1"."RVB08", "A1"."RVB09", "A1"."RVB10", "A1"."RVB11", "A1"."RVB12", "A1"."RVB13", "A1"."RVB14", "A1"."RVB15", "A1"."RVB16", "A1"."RVB17", "A1"."RVB18 ", "A1"."RVB19", "A1"."RVB20", "A1"."RVB21", "A1"."RVB22", "A1"."RVB25", "A1"."RVB26", "A1"."RVB27", "A1"."RVB28", "A1"."RVB29", "A1"."RVB30", "A1"."RVB31", "A1"."RVB32", "A1"."RVB33", "A1"."RVB34", "A1"."RVB35", "A1"."RVB36", "A1"."RVB37", "A1"."RVB38", "A1"."RVB39", "A1"."RVB40", "A1"."RVB41", "A1"."RVB80", "A1"."RVB81", "A1"."RVB82", "A1"."RVB83", "A1"."RVB84", "A1"."RVB85", "A1"."RVB86", "A1"."RVB87", " A1"."RVB88", "A1"."RVB88T", "A1"."RVB10T", "A1"."RVB331", "A1"."RVB332", "A1"."RVB930", "A1"."RVBUD01", "A1"."RVBUD02", "A1"."RVBUD03", "A1"."RVBUD04", "A1"."RVBUD05", "A1"."RVBUD06", "A1"."RVBUD07", "A1"."RVBUD08", "A1"."RVBUD09", "A1"."RVBUD10", "A1"."RVBUD11", "A1"."RVBUD12", "A1"."RVBUD13", "A1"."RVBUD14", "A1"."RVBUD15", "A1"."RVB051", "A1"."RVB89", "A1"."RVB90", "A1"."RVB90_FAC", "A1"."RVB42", "A1"."RVB43", "A1"."RVB44", "A1" ."RVB45", "A1"."RVBPLANT", "A1"."RVBLEGAL", "A1"."RVB93", "A1"."RVB919" FROM "NLPM01"."RVA_FILE" "A2", "NLPM01"."RVB_FILE" "A1" WHERE "A2"."RVAUD05"='Y' AND "A2"."RVA01"="A1"."RVB01"(+)

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

40h437t5013u3 SELECT "A1"."RVV01", "A1"."RVV02", "A1"."RVV31", "A1"."IMA02", "A1"."IMA021", "A1"."RVV17", "A1"."RVV32", "A1"."RVV33", "A1"."RVV34", "A1"."RVV171", "A1"."RVV172", "A1"."RVVUD03", "A1"."GEM02" FROM "CRVV_VIEW" "A1" WHERE EXISTS (SELECT 1 FROM "CRVU_VIEW" "A2" WHERE "A2"."RVU00"<>'3' AND TO_CHAR(NVL("A2"."RVUDATE", "A2"."RVU03"), 'yyyyMMdd')>'20170728' AND "A2"."RVU01"="A1"."RVV01" AND "A2"."DBTYPE"='1') AND "A1"."DBTYPE"='1'

40ju0vrjd86s5 create table tt36208

591q7n5r70vkw SELECT "A3"."OGB01", "A3"."OGB03", "A3"."OGBUD02", "A3"."OGBUD03", "A3"."OGBUD04", "A3"."OGBUD06", "A3"."OGBUD01", "A3"."OGB04", "A3"."OGB12", "A3"."OGB09", "A3"."OGB091", "A3"."OGB092", "A3"."OEBUD02", "A3"."OEBUD03", "A3"."OGBUD07" FROM "HTOGB1_VIEW" "A3", "HTOGA1_VIEW" "A2", "HTOGA1_VIEW" "A1" WHERE "A1"."OGA09"='0' AND "A3"."OGB01"="A1"."OGA01" AND "A3"."DBTYPE"='1' AND "A2"."OGACONF"='Y' AND ("A2"."OGA09"='0' AND SUBSTR("A2"."OGA01", 1, 4)='S841' OR "A2"."OGA09"='1' AND SUBSTR("A3"."OGB09", 4, 1)='3') AND "A3"."OGB01"="A2"."OGA01" AND "A3"."DBTYPE"='1' AND "A1"."OGA01"=ANY (SELECT "A5"."OGB01" FROM "HTOGB1_VIEW" "A5", "HTOGA1_VIEW" "A4" WHERE "A5"."DBTYPE"='1' AND "A4"."OGACONF"='Y' AND ("A4"."OGA09"='0' AND SUBSTR("A4"."OGA01", 1, 4)='S841' OR "A4"."OGA09"='1' AND SUBSTR("A5"."OGB09", 4, 1)='3') AND "A5"."OGB01"="A4"."OGA01" AND "A4"."DBTYPE"='1' AND "A5"."DBTYPE"='1') AND "A1"."DBTYPE"='1' AND "A2"."DBTYPE"='1'

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)

62p83a4v443bf select gae04, gav03, gav04, gav09, gav10, gav07, gav14, gav15, gav32, gaq03 from gae_file LEFT OUTER JOIN gav_file ON gae01 = gav01 AND gae02 = gav02 AND gae11 = gav08 AND gae12 = gav11 LEFT OUTER JOIN gaq_file ON gae02 = gaq01 AND gae03 = gaq02 where gae01 = :p1 AND gae02 = :p2 AND gae03 = :p3 AND gae11 = :p4 AND gae12 = :p5

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

6g4dgxt73981r select distinct omf00, omf01, omf02, omf03, omf05, omf051, omf06, omf061, omf07, omf08, omf22, omf27, omf271, omf30, omf24, omfpost, omf04, '', '', '', '', '', '', omf31, omf32, omf33, omfuser, omfgrup, omforiu, omforig, omfmodu, omfdate, ta_omf01, ta_omf02, ta_omf03, ta_omf04, ta_omf05, ta_omf06, ta_omf07, ta_omf08, ta_omf09, ta_omf11, ta_omf12, ta_omf13, ta_omf14, ta_omf17, ta_omf16, ta_omf19, ta_omf18, ta_omf26 from omf_file, occ_file, gem_file where omf00 = :p1

6k38zq7rf14c8 SELECT "A1"."PMM01", "A1"."PMM02", "A1"."PMM04", "A1"."PMM09", "A1"."PMM18", "A1"."PMM12", "A1"."PMM21", "A1"."PMM22", "A1"."PMM42", "A1"."PMM43", "A1"."PMM909", "A1"."TA_IMA03", "A1"."IMA021", "A1"."PMN33" FROM (SELECT DISTINCT "A4"."PMM01" "PMM01", "A4"."PMM02" "PMM02", TO_CHAR("A4"."PMM04", 'yyyyMMdd') "PMM04", "A4"."PMM09" "PMM09", "A4"."PMM18" "PMM18", "A4"."PMM12" "PMM12", "A4"."PMM21" "PMM21", "A4"."PMM22" "PMM22", "A4"."PMM42" "PMM42", "A4"."PMM43" "PMM43", "A4"."PMM909" "PMM909", '' "TA_IMA03", '' "IMA021", '' "PMN33" FROM "TOA_PMN_VIEW" "A5", "TOA_PMM_VIEW" "A4", LATERAL( (SELECT "A6"."DBTYPE" "DBTYPE_0", "A6"."SFB01" "SFB01", "A6"."SFB02" "SFB02", "A6"."SFB03" "SFB03", "A6"."SFB04" "SFB04", "A6"."SFB05" "SFB05_5", "A6"."SFB06" "SFB06", "A6"."SFB07" "SFB07", "A6"."SFB071" "SFB071", "A6"."SFB08" "SFB08", "A6"."SFB081" "SFB081", "A6"."SFB09" "SFB09", "A6"."SFB10" "SFB10", "A6"."SFB11" "SFB11", "A6"."SFB111" "SFB111", "A6"."SFB12" "SFB12", "A6"."SFB121" "SFB121", "A6"."SFB122" "SFB122", "A6"."SFB13" "SFB13", "A6"."SFB14" "SFB14", "A6"."SFB15" "SFB15", "A6"."SFB16" "SFB16", "A6"."SFB17" "SFB17", "A6"."SFB18" "SFB18", "A6"."SFB19" "SFB19", "A6"."SFB20" "SFB20", "A6"."SFB21" "SFB21", "A6"."SFB22" "SFB22", "A6"."SFB221" "SFB221", "A6"."SFB222" "SFB222", "A6"."SFB23" "SFB23", "A6"."SFB24" "SFB24", "A6"."SFB25" "SFB25", "A6"."SFB251" "SFB251", "A6"."SFB26" "SFB26", "A6"."SFB27" "SFB27", "A6"."SFB271" "SFB271", "A6"."SFB28" "SFB28", "A6"."SFB29" "SFB29", "A6"."SFB30" "SFB30", "A6"."SFB31" "SFB31", "A6"."SFB32" "SFB32", "A6"."SFB33" "SFB33", "A6"."SFB34" "SFB34", "A6"."SFB35" "SFB35", "A6"."SFB36" "SFB36", "A6"."SFB37" "SFB37", "A6"."SFB38" "SFB38", "A6"."SFB39" "SFB39", "A6"."SFB40" "SFB40", "A6"."SFB41" "SFB41", "A6"."SFB42" "SF B42", "A6"."SFB81" "SFB81", "A6"."SFB82" "SFB82", "A6"."SFB85" "SFB85", "A6"."SFB86" "SFB86", "A6"."SFB87" "SFB87", "A6"."SFB88" "SFB88", "A6"."SFB91" "SFB91", "A6"."SFB92" "SFB92", "A6"."SFB93" "SFB93", "A6"."SFB94" "SFB94", "A6"."SFB95" "SFB95", "A6"."SFB96" "SFB96", "A6"."SFB97" "SFB97", "A6"."SFB98" "SFB98", "A6"."SFB99" "SFB99", "A6"."SFB100" "SFB100", "A6"."SFB101" "SFB101", "A6"."SFBACTI" "SFBACTI", "A6"."SFBUSER" "SFBU SER", "A6"."SFBGRUP" "SFBGRUP", "A6"."SFBMODU" "SFBMODU", "A6"."SFBDATE" "SFBDATE", "A6"."SFB1001" "SFB1001", "A6"."SFB1002" "SFB1002", "A6"."SFB1003" "SFB1003", "A6"."SFB102" "SFB102", "A6"."SFB50" "SFB50", "A6"."SFB51" "SFB51", "A6"."SFB103" "SFB103", "A6"."SFBUD01" "SFBUD01", "A6"."SFBUD02" "SFBUD02", "A6"."SFBUD03" "SFBUD03", "A6"."SFBUD04" "SFBUD04", "A6"."SFBUD05" "SFBUD05", "A6"."SFBUD06" "SFBUD06", "A6"."SFBUD07" "SFBUD07", "A6"."SFBUD08" "SFBUD08 ", "A6"."SFBUD09" "SFBUD09", "A6"."SFBUD10" "SFBUD10", "A6"."SFBUD11" "SFBUD11", "A6"."SFBUD12" "SFBUD12", "A6"."SFBUD13" "SFBUD13", "A6"."SFBUD14" "SFBUD14", "A6"."SFBUD15" "SFBUD15", "A6"."SFB43" "SFB43", "A6"."SFB44" "SFB44", "A6"."SFBMKSG" "SFBMKSG", "A6"."SFBPLANT" "SFBPLANT", "A6"."SFBLEGAL" "SFBLEGAL", "A6"."SFBORIU" "SFBORIU", "A6"."SFBORIG" "SFBORIG", "A6"."SFB104" "SFB104", "A6"."SFB919" "SFB919", "A6"."SFB89" "SFB89", "A6"."TA_SFB01" "TA_SFB01 ", "A6"."TA_SFB02" "TA_SFB02", "A6"."TA_SFB03" "TA_SFB03", "A6"."TA_SFB04" "TA_SFB04", "A6"."TA_SFB05" "TA_SFB05", "A6"."TA_SFB06" "TA_SFB06", "A6"."TA_SFB07" "TA_SFB07", "A6"."TA_SFB08" "TA_SFB08", "A6"."TA_SFB09" "TA_SFB09", "A6"."TA_SFB10" "TA_SFB10", "A6"."TA_SFB11" "TA_SFB11" FROM "TOA_SFB_VIEW" "A6" WHERE "A5"."PMN41"="A6"."SFB01" AND "A6"."DBTYPE"='1' AND "A5"."DBTYPE"='1'))(+) "A3", LATERAL( (SELECT "A7"."DBTYPE" "DBTYPE", "A7"."IMA01" "IMA01", "A7"."IMA02" "IMA02", "A7". "IMA021" "IMA021", "A7"."IMA03" "IMA03", "A7"."IMA04" "IMA04", "A7"."IMA05" "IMA05", "A7"."IMA06" "IMA06", "A7"."IMA07" "IMA07", "A7"."IMA08" "IMA08", "A7"."IMA09" "IMA09", "A7"."IMA10" "IMA10", "A7"."IMA11" "IMA11", "A7"."IMA12" "IMA12", "A7"."IMA13" "IMA13", "A7"."IMA14" "IMA14", "A7"."IMA15" "IMA15", "A7"."IMA16" "IMA16", "A7"."IMA17" "IMA17", "A7"."IMA17_FAC" "IMA17_FAC", "A7"."IMA18" "IMA18", "A7"."IMA19" "IMA19", "A7". "IMA20" "IMA20", "A7"."IMA21" "IMA21", "A7"."IMA22" "IMA22", "A7"."IMA23" "IMA23", "A7"."IMA24" "IMA24", "A7"."IMA25" "IMA25", "A7"."IMA26" "IMA26", "A7"."IMA261" "IMA261", "A7"."IMA262" "IMA262", "A7"."IMA27" "IMA27", "A7"."IMA271" "IMA271", "A7"."IMA28" "IMA28", "A7"."IMA29" "IMA29", "A7"."IMA30" "IMA30", "A7"."IMA31" "IMA31", "A7"."IMA31_FAC" "IMA31_FAC", "A7"."IMA32" "IMA32", "A7"."IMA33" "IMA33", "A7"."IMA34" "IMA34", "A7 "."IMA35" "IMA35", "A7"."IMA36" "IMA36", "A7"."IMA37" "IMA37", "A7"."IMA38" "IMA38", "A7"."IMA39" "IMA39", "A7"."IMA40" "IMA40", "A7"."IMA41" "IMA41", "A7"."IMA42" "IMA42", "A7"."IMA43" "IMA43", "A7"."IMA44" "IMA44", "A7"."IMA44_FAC" "IMA44_FAC", "A7"."IMA45" "IMA45", "A7"."IMA46" "IMA46", "A7"."IMA47" "IMA47", "A7"."IMA48" "IMA48", "A7"."IMA49" "IMA49", "A7"."IMA491" "IMA491", "A7"."IMA50" "IMA50", "A7"."IMA51" "IMA51", "A7 "."IMA52" "IMA52", "A7"."IMA53" "IMA53", "A7"."IMA531" "IMA531", "A7"."IMA532" "IMA532", "A7"."IMA54" "IMA54", "A7"."IMA55" "IMA55", "A7"."IMA55_FAC" "IMA55_FAC", "A7"."IMA56" "IMA56", "A7"."IMA561" "IMA561", "A7"."IMA562" "IMA562", "A7"."IMA57" "IMA57", "A7"."IMA571" "IMA571", "A7"."IMA58" "IMA58", "A7"."IMA59" "IMA59", "A7"."IMA60" "IMA60", "A7"."IMA61" "IMA61", "A7"."IMA62" "IMA62", "A7"."IMA63" "IMA63", "A7"."IMA63_FAC" "IMA63_FAC ", "A7"."IMA64" "IMA64", "A7"."IMA641" "IMA641", "A7"."IMA65" "IMA65", "A7"."IMA66" "IMA66", "A7"."IMA67" "IMA67", "A7"."IMA68" "IMA68", "A7"."IMA69" "IMA69", "A7"."IMA70" "IMA70", "A7"."IMA71" "IMA71", "A7"."IMA72" "IMA72", "A7"."IMA73" "IMA73", "A7"."IMA74" "IMA74", "A7"."IMA86" "IMA86", "A7"."IMA86_FAC" "IMA86_FAC", "A7"."IMA87" "IMA87", "A7"."IMA871" "IMA871", "A7"."IMA872" "IMA872", "A7"."IMA873" "IMA873", "A7"."IMA874" " IMA874", "A7"."IMA88" "IMA88", "A7"."IMA881" "IMA881", "A7"."IMA89" "IMA89", "A7"."IMA90" "IMA90", "A7"."IMA91" "IMA91", "A7"."IMA92" "IMA92", "A7"."IMA93" "IMA93", "A7"."IMA94" "IMA94", "A7"."IMA95" "IMA95", "A7"."IMA75" "IMA75", "A7"."IMA76" "IMA76", "A7"."IMA77" "IMA77", "A7"."IMA78" "IMA78", "A7"."IMA79" "IMA79", "A7"."IMA80" "IMA80", "A7"."IMA81" "IMA81", "A7"."IMA82" "IMA82", "A7"."IMA83" "IMA83", "A7"."IMA84" "IMA84 ", "A7"."IMA85" "IMA85", "A7"."IMA851" "IMA851", "A7"."IMA852" "IMA852", "A7"."IMA853" "IMA853", "A7"."IMA96" "IMA96", "A7"."IMA97" "IMA97", "A7"."IMA98" "IMA98", "A7"."IMA99" "IMA99", "A7"."IMA100" "IMA100", "A7"."IMA101" "IMA101", "A7"."IMA102" "IMA102", "A7"."IMA103" "IMA103", "A7"."IMA104" "IMA104", "A7"."IMA105" "IMA105", "A7"."IMA106" "IMA106", "A7"."IMA107" "IMA107", "A7"."IMA108" "IMA108", "A7"."IMA109" "IMA109", "A7"."IMA110 " "IMA110", "A7"."IMA111" "IMA111", "A7"."IMA121" "IMA121", "A7"."IMA122" "IMA122", "A7"."IMA123" "IMA123", "A7"."IMA124" "IMA124", "A7"."IMA125" "IMA125", "A7"."IMA126" "IMA126", "A7"."IMA127" "IMA127", "A7"."IMA128" "IMA128", "A7"."IMA129" "IMA129", "A7"."IMA130" "IMA130", "A7"."IMA131" "IMA131", "A7"."IMA132" "IMA132", "A7"."IMA133" "IMA133", "A7"."IMA134" "IMA134", "A7"."IMA135" "IMA135", "A7"."IMA136" "IMA136", "A7"."IMA137" "IMA137", "A7"."IMA138" "IMA138", "A7"."IMA139" "IMA139", "A7"."IMA140" "IMA140", "A7"."IMA141" "IMA141", "A7"."IMA142" "IMA142", "A7"."IMA143" "IMA143", "A7"."IMA144" "IMA144", "A7"."IMA145" "IMA145", "A7"."IMA146" "IMA146", "A7"."IMA147" "IMA147", "A7"."IMA148" "IMA148", "A7"."IMA901" "IMA901", "A7"."IMA902" "IMA902", "A7"."IMA903" "IMA903", "A7"."IMA904" "IMA904", "A7"."IMA905" "IMA905", "A7"."IMA906" "IMA906", "A7"."IMA907" "IMA907", "A7"."IMA908 " "IMA908", "A7"."IMA909" "IMA909", "A7"."IMA910" "IMA910", "A7"."IMAACTI" "IMAACTI", "A7"."IMAUSER" "IMAUSER", "A7"."IMAGRUP" "IMAGRUP", "A7"."IMAMODU" "IMAMODU", "A7"."IMADATE" "IMADATE", "A7"."IMAAG" "IMAAG", "A7"."IMAAG1" "IMAAG1", "A7"."IMAUD01" "IMAUD01", "A7"."IMAUD02" "IMAUD02", "A7"."IMAUD03" "IMAUD03", "A7"."IMAUD04" "IMAUD04", "A7"."IMAUD05" "IMAUD05", "A7"."IMAUD06" "IMAUD06", "A7"."IMAUD07" "IMAUD07", "A7"."IMAUD08" "IMAUD08", "A7"."IMAUD09 " "IMAUD09", "A7"."IMAUD10" "IMAUD10", "A7"."IMAUD11" "IMAUD11", "A7"."IMAUD12" "IMAUD12", "A7"."IMAUD13" "IMAUD13", "A7"."IMAUD14" "IMAUD14", "A7"."IMAUD15" "IMAUD15", "A7"."IMA1001" "IMA1001", "A7"."IMA1002" "IMA1002", "A7"."IMA1003" "IMA1003", "A7"."IMA1004" "IMA1004", "A7"."IMA1005" "IMA1005", "A7"."IMA1006" "IMA1006", "A7"."IMA1007" "IMA1007", "A7"."IMA1008" "IMA1008", "A7"."IMA1009" "IMA1009", "A7"."IMA1010" "IMA1010", "A7"."IMA1011" "IMA1011", "A7". "IMA1012" "IMA1012", "A7"."IMA1013" "IMA1013", "A7"."IMA1014" "IMA1014", "A7"."IMA1015" "IMA1015", "A7"."IMA1016" "IMA1016", "A7"."IMA1017" "IMA1017", "A7"."IMA1018" "IMA1018", "A7"."IMA1019" "IMA1019", "A7"."IMA1020" "IMA1020", "A7"."IMA1021" "IMA1021", "A7"."IMA1022" "IMA1022", "A7"."IMA1023" "IMA1023", "A7"."IMA1024" "IMA1024", "A7"."IMA1025" "IMA1025", "A7"."IMA1026" "IMA1026", "A7"."IMA1027" "IMA1027", "A7"."IMA1028" "IMA1028", "A7"."IMA1029" "IMA1029", "A 7"."IMA911" "IMA911", "A7"."IMA912" "IMA912", "A7"."IMA913" "IMA913", "A7"."IMA914" "IMA914", "A7"."IMA391" "IMA391", "A7"."IMA1321" "IMA1321", "A7"."IMA1911" "IMA1911", "A7"."IMA1912" "IMA1912", "A7"."IMA1913" "IMA1913", "A7"."IMA1914" "IMA1914", "A7"."IMA1915" "IMA1915", "A7"."IMA1916" "IMA1916", "A7"."IMA1919" "IMA1919", "A7"."IMA1401" "IMA1401", "A7"."IMA915" "IMA915", "A7"."IMA916" "IMA916", "A7"."IMA917" "IMA917", "A7"."IMA150" "IMA150", "A7". "IMA151" "IMA151", "A7"."IMA152" "IMA152", "A7"."IMA918" "IMA918", "A7"."IMA919" "IMA919", "A7"."IMA920" "IMA920", "A7"."IMA921" "IMA921", "A7"."IMA922" "IMA922", "A7"."IMA923" "IMA923", "A7"."IMA924" "IMA924", "A7"."IMA925" "IMA925", "A7"."IMA601" "IMA601", "A7"."IMA153" "IMA153", "A7"."IMA926" "IMA926", "A7"."IMA154" "IMA154", "A7"."IMA155" "IMA155", "A7"."IMA149" "IMA149", "A7"."IMA1491" "IMA1491", "A7"."IMAORIU" "IMAORIU", "A7"."IMAORIG" "IMAORIG", "A7"."IMA9021" "IMA9021", "A7"."IMA022" "IMA022", "A7"."IMA251" "IMA251", "A7"."IMA940" "IMA940", "A7"."IMA941" "IMA941", "A7"."IMA156" "IMA156", "A7"."IMA157" "IMA157", "A7"."IMA158" "IMA158", "A7"."IMA927" "IMA927", "A7"."IMA120" "IMA120", "A7"."IMA159" "IMA159", "A7"."IMA928" "IMA928", "A7"."IMA929" "IMA929", "A7"."IMA160" "IMA160", "A7"."IMA161" "IMA161", "A7"."IMA162" "IMA162", "A7"."IMA163" "IMA163", "A7"."IMA1631" "IMA1631", "A7"."IMA721" "IMA721", "A7"."IMA171" "IMA171", "A7"."IMA172" "IMA172", "A7"."IMA1030" "IMA1030", "A7"."IMA930" "IMA930", "A7"."IMA931" "IMA931", "A7"."IMA932" "IMA932", "A7"."IMA933" "IMA933", "A7"."IMA934" "IMA934", "A7"."IMA164" "IMA164", "A7"."IMA1641" "IMA1641", "A7"."TA_IMA01" "TA_IMA01", "A7"."TA_IMA02" "TA_IMA02", "A7"."TA_IMA03" "TA_IMA03", "A7"."TA_IMA04" "TA_IMA04", "A7"."TA_IMA05" "TA_IMA05", "A7"."TA_IMA06" "TA_IMA06", "A7"."TA_IMA07" "TA_IMA07 ", "A7"."TA_IMA08" "TA_IMA08", "A7"."TA_IMA09" "TA_IMA09", "A7"."TA_IMA10" "TA_IMA10", "A7"."TA_IMA11" "TA_IMA11", "A7"."TA_IMA12" "TA_IMA12", "A7"."TA_IMA13" "TA_IMA13", "A7"."TA_IMA14" "TA_IMA14", "A7"."TA_IMA15" "TA_IMA15", "A7"."TA_IMA16" "TA_IMA16", "A7"."TA_IMA17" "TA_IMA17", "A7"."TA_IMA18" "TA_IMA18" FROM "TOA_IMA_VIEW" "A7" WHERE "A3"."SFB05_5"="A7"."IMA01" AND "A3"."DBTYPE_0"='1' AND "A7"."DBTYPE"='1'))(+) "A2" WHERE "A4"."PMM18"='Y' AND "A4"."PMM02"='SUB' AND "A4"."PMM09"='C0349' AND "A5"."PMN65"='2' AND "A5"."PMN01"="A4"."PMM01" AND "A5"."DBTYPE"='1' AND "A4"."DBTYPE"='1') "A1"

74anujtt8zw4h select o.owner#, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property, 0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o where d.p_obj#=:1 and (d.p_timestamp=nvl(:2, d.p_timestamp) or d.property=2) and o.owner#=nvl(:3, o.owner#) and d.d_obj#=o.obj# order by o.obj#

78hqmypm5qfmb select SUM(rvb07) from rvb_file, rva_file where rvb34 = :p1 AND rvb01 = rva01 AND rvb19 = '1' AND rva10 = 'SUB' AND rvaconf = 'Y'

7ksjhpjvkn647 SELECT "OMF03", "OMF16", "OMF19", "TA_OGB16", "OGA14" FROM "TOA_OMF_VIEW" "TOA_OMF_VIEW" WHERE "OGA14" IS NOT NULL AND EXTRACT(YEAR FROM "OMF03")=EXTRACT(YEAR FROM :1)

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

7vun041qzbkmz SELECT "A1"."RVU01", "A1"."RVU00", TO_CHAR("A1"."RVU03", 'yyyyMMdd'), "A1"."RVU04", "A1"."RVUCONF", TO_CHAR("A1"."RVUCRAT", 'yyyyMMdd'), "A1"."PMC081", TO_CHAR(NVL("A1"."RVUDATE", "A1"."RVU03"), 'yyyyMMdd') FROM "CRVU_VIEW" "A1" WHERE "A1"."RVU00"<>'3' AND TO_CHAR(NVL("A1"."RVUDATE", "A1"."RVU03"), 'yyyyMMdd')>'20170728' AND "A1"."DBTYPE"='1'

7wj19b74z7yy4 SELECT "A1"."OGA01", TO_CHAR("A1"."OGA69", 'yyyyMMdd'), TO_CHAR("A1"."OGACOND", 'yyyyMMdd'), "A1"."OGAORIG", "A1"."OGACONF", "A1"."OGAUD06", "A1"."OGA03", "A1"."OGA032", "A1"."OCC18", "A1"."OGA011" FROM "HTOGA1_VIEW" "A1" WHERE "A1"."OGA09"='1' AND "A1"."OGA01"=ANY (SELECT "A3"."OGB01" FROM "HTOGB1_VIEW" "A3", "HTOGA1_VIEW" "A2" WHERE "A3"."DBTYPE"='1' AND "A2"."OGACONF"='Y' AND ("A2"."OGA09"='0' AND SUBSTR("A2"."OGA01", 1, 4)='S841' OR "A2"."OGA09"='1' AND SUBSTR("A3"."OGB09", 4, 1)='3') AND "A3"."OGB01"="A2"."OGA01 " AND "A3"."DBTYPE"='1' AND "A2"."DBTYPE"='1') AND "A1"."DBTYPE"='1'

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#

8w4c8u9udsuyy select count(*) from ( select u.name from registry$ r, user$ u where r.status in (1, 3, 5) and r.namespace = 'SERVER' and r.schema# = u.user# and u.name = :1 union all select u.name from registry$ r, registry$schemas s, user$ u where r.status in (1, 3, 5) and r.namespace = 'SERVER' and r.cid = s.cid and s.schema# = u.user# and u.name = :1)

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

9y7s2afnkqs9d delete from idl_ub2$ where obj#=:1 and part=:2

a0u7bj627dfqt select gbs06 from gbs_file where gbs01 = :p1 AND gbs02 = :p2 AND gbs03 = :p3 AND gbs04 = :p4 AND gbs05 = :p5

b3k1j7c3djjqd SELECT "DBTYPE", "SFA01", "SFA03", "SFA08", "SFA27", "SFA12", "SFA11", "SFA05", "SFA16", "SFA161", "SFA065", "SFA06" FROM "SFA_VIEW" "SFA_VIEW" WHERE "DBTYPE"='1'

b45u3b52kx4v7 SELECT "PMM01", "PMM04", "PMM09", "PMM22", "PMN02", "PMN04", "CGWJL", "PMM25", "PMN16", "PMC909", "PMCUD13", "RVB07_N" FROM "PO_PMM_VIEW" "T" WHERE "PMN16"='2' AND "PMM22"='RMB' AND "PMN04"='105010103' AND "CGWJL">0 AND "PMM25"<>'0' AND ("PMM01"='ZP20-16100639' OR "PMC909"='Y' AND "PMM04">=TO_CHAR("PMCUD13", 'yyyy-MM-dd')) AND LOWER("PMM09")='c0298'

bvn085xhxfn9f insert into sys.wri$_optstat_histhead_history (obj#, intcol#, flags, expression, colname, savtime) values (:1, :2, :3, :4, :5, :6)

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

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)

cu8mztahhpwhr SELECT DISTINCT "A2"."IMM01", TO_CHAR("A2"."IMM17", 'yyyyMMdd'), '' FROM "IMM_VIEW" "A2", "IMN_VIEW" "A1" WHERE ("A1"."IMN05"<>' ' OR "A1"."IMN16"<>' ') AND "A2"."IMM01"="A1"."IMN01"(+) AND "A2"."DBTYPE"='1' AND "A1"."DBTYPE"(+)='1'

d5jd9b2xct7xz delete from idl_char$ where obj#=:1 and part=:2

dkyqv38h875m3 SELECT "A2"."RVV01", "A2"."RVV02", "A2"."RVV31", "A2"."RVV171", "A2"."RVV18", "A2"."RVV172", "A2"."RVV32", "A2"."RVV33", "A2"."RVV34" FROM "WRVV_VIEW" "A2", "WRVU_VIEW" "A1" WHERE "A1"."RVU00"<>'3' AND "A2"."RVV01"="A1"."RVU01" AND "A2"."DBTYPE"='1' AND "A1"."DBTYPE"='1'

dvpfc386d6dmm delete from idl_sb4$ where obj#=:1 and part=:2

fb6wkr62s47mv SELECT "A2"."INB01", "A2"."INB03", "A2"."INB04", CASE WHEN "A1"."INA00"='1' THEN "A2"."INB09" ELSE (-"A2"."INB09") END , "A2"."INB05", "A2"."INB06", "A2"."INB07", "A2"."INB08_FAC", CASE WHEN "A1"."INA00"='1' THEN "A2"."INB16" ELSE (-"A2"."INB16") END , "A2"."INB11", "A2"."INB12", "A2"."INB15" FROM "INB_VIEW" "A2", "INA_VIEW" "A1" WHERE "A2"."INB01"="A1"."INA01"(+) AND "A2"."DBTYPE"='1' AND "A1"."DBTYPE"(+)='1'

fcyws29qzab6f select gaj03, gaj04, gaj05, gaj06, gaj12 from gaj_file where gaj01 = :p1 AND gaj02 = :p2 AND gaj11 = :p3

fwbtm6g368j79 SELECT "A1"."IMM01", '', TO_CHAR("A1"."IMM17", 'yyyyMMdd'), "A1"."IMM03", "A1"."IMM04", TO_CHAR("A1"."IMM02", 'yyyyMMdd') FROM "IMM_VIEW" "A1" WHERE "A1"."IMM01"=ANY (SELECT "A2"."IMN01" FROM "IMN_VIEW" "A2" WHERE "A2"."DBTYPE"='1') AND "A1"."DBTYPE"='1'

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

gsqxm6zz3w2by delete from idl_ub1$ where obj#=:1 and part=:2

SQL Id	SQL Text
0wjyd6jkgp4h6	SELECT "A1"."RVA01", TO_CHAR("A1"."RVACOND", 'yyyyMMdd'), "A1"."RVA05", "A1"."RVACONF", TO_CHAR("A1"."RVA06", 'yyyyMMdd'), "A1"."PMC081", "A1"."RVA10" FROM "HT_RVA_VIEW" "A1" WHERE "A1"."RVA10"<>'SUB' AND "A1"."DBTYPE"='1'
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1qpdxynxddx8j	select gav12, gav13, gav16, gav17, gav18, gav19, gav21, gav24, gav25, gav31, gav33, gav34, gav36, gav37 from gav_file where gav01 = :p1 AND gav02 = :p2 AND gav_file.gav08 = :p3 AND gav_file.gav11 = :p4
1sjkusdtcpg9c	SELECT "A3"."OGB01", "A3"."OGB03", "A3"."OGBUD02", "A3"."OGBUD03", "A3"."OGBUD04", "A3"."OGBUD06", "A3"."OGBUD01", "A3"."OGB04", "A3"."OGB12", "A3"."OGB09", "A3"."OGB091", "A3"."OGB092", "A3"."OEBUD02", "A3"."OEBUD03", "A3"."OGBUD07" FROM "HTOGB1_VIEW" "A3", "HTOGA1_VIEW" "A2", "HTOGA1_VIEW" "A1" WHERE "A1"."OGA09"='1' AND "A3"."OGB01"="A1"."OGA01" AND "A3"."DBTYPE"='1' AND "A2"."OGACONF"='Y' AND ("A2"."OGA09"='0' AND SUBSTR("A2"."OGA01", 1, 4)='S841' OR "A2"."OGA09"='1' AND SUBSTR("A3"."OGB09", 4, 1)='3') AND "A3"."OGB01"="A2"."OGA01" AND "A3"."DBTYPE"='1' AND "A1"."OGA01"=ANY (SELECT "A5"."OGB01" FROM "HTOGB1_VIEW" "A5", "HTOGA1_VIEW" "A4" WHERE "A5"."DBTYPE"='1' AND "A4"."OGACONF"='Y' AND ("A4"."OGA09"='0' AND SUBSTR("A4"."OGA01", 1, 4)='S841' OR "A4"."OGA09"='1' AND SUBSTR("A5"."OGB09", 4, 1)='3') AND "A5"."OGB01"="A4"."OGA01" AND "A4"."DBTYPE"='1' AND "A5"."DBTYPE"='1') AND "A1"."DBTYPE"='1' AND "A2"."DBTYPE"='1'
1vdsz959xtu4p	SELECT "A2"."RVB01", "A2"."RVB02", "A2"."RVB05", "A2"."RVB051", "A2"."IMA021", "A2"."RVB07", "A2"."RVB36", "A2"."RVB37", "A2"."RVB38", "A2"."RVB40", "A2"."RVB30", "A2"."RVB29", '', '' FROM "HT_RVB_VIEW" "A2", "HT_RVA_VIEW" "A1" WHERE "A1"."RVA10"<>'SUB' AND "A2"."RVB01"="A1"."RVA01" AND "A2"."DBTYPE"='1' AND "A1"."DBTYPE"='1'
20vv6ttajyjzq	delete from access$ where d_obj#=:1
2h0gb24h6zpnu	insert into access$(d_obj#, order#, columns, types) values (:1, :2, :3, :4)
2jfqzrxhrm93b	select /+ rule / 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#
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#
2wdrw5tqputaq	delete from cdef$ where obj#=:1
33cmj01uf5zfb	delete from col$ where obj#=:1
355gqw3b8pcuy	SELECT "A1"."OGA01", TO_CHAR("A1"."OGA69", 'yyyyMMdd'), TO_CHAR("A1"."OGACOND", 'yyyyMMdd'), "A1"."OGAORIG", "A1"."OGACONF", "A1"."OGAUD06", "A1"."OGA03", "A1"."OGA032", "A1"."OCC18" FROM "HTOGA1_VIEW" "A1" WHERE "A1"."OGA09"='0' AND "A1"."OGA01"=ANY (SELECT "A3"."OGB01" FROM "HTOGB1_VIEW" "A3", "HTOGA1_VIEW" "A2" WHERE "A3"."DBTYPE"='1' AND "A2"."OGACONF"='Y' AND ("A2"."OGA09"='0' AND SUBSTR("A2"."OGA01", 1, 4)='S841' OR "A2"."OGA09"='1' AND SUBSTR("A3"."OGB09", 4, 1)='3') AND "A3"."OGB01"="A2"."OGA01" AND "A3"."DBTYPE "='1' AND "A2"."DBTYPE"='1') AND "A1"."DBTYPE"='1'
358zavwbh5f6n	SELECT "PMM01", "PMM04", "PMM09", "PMM22", "PMN02", "PMN04", "CGWJL", "PMM25", "PMN16", "PMC909", "PMCUD13", "RVB07_N" FROM "PO_PMM_VIEW" "T" WHERE "PMN16"='2' AND "PMM22"='RMB' AND "PMN04"='105010090' AND "CGWJL">0 AND "PMM25"<>'0' AND ("PMM01"='ZP20-16100639' OR "PMC909"='Y' AND "PMM04">=TO_CHAR("PMCUD13", 'yyyy-MM-dd')) AND LOWER("PMM09")='c0298'
3kz8jkurqn3c8	SELECT "A2"."RVA01", "A2"."RVA02", "A2"."RVA03", "A2"."RVA04", "A2"."RVA05", "A2"."RVA06", "A2"."RVA07", "A2"."RVA08", "A2"."RVA09", "A2"."RVA10", "A2"."RVAPRSW", "A2"."RVA20", "A2"."RVA21", "A2"."RVA22", "A2"."RVA23", "A2"."RVA24", "A2"."RVA25", "A2"."RVA26", "A2"."RVA27", "A2"."RVA28", "A2"."RVA99", "A2"."RVACONF", "A2"."RVAPRNO", "A2"."RVAACTI", "A2"."RVAUSER", "A2"."RVAGRUP", "A2"."RVAMODU", "A2"."RVADATE", "A2"."RVAS PC", "A2"."RVA100", "A2"."RVAUD01", "A2"."RVAUD02", "A2"."RVAUD03", "A2"."RVAUD04", "A2"."RVAUD05", "A2"."RVAUD06", "A2"."RVAUD07", "A2"."RVAUD08", "A2"."RVAUD09", "A2"."RVAUD10", "A2"."RVAUD11", "A2"."RVAUD12", "A2"."RVAUD13", "A2"."RVAUD14", "A2"."RVAUD15", "A2"."RVA00", "A2"."RVA111", "A2"."RVA112", "A2"."RVA113", "A2"."RVA114", "A2"."RVA115", "A2"."RVA116", "A2"."RVA117", "A2"."RVA29", "A2"."RVA30", "A2"."RVA31", "A2"."RVACOND" , "A2"."RVACONU", "A2"."RVACRAT", "A2"."RVAPLANT", "A2"."RVALEGAL", "A2"."RVAORIU", "A2"."RVAORIG", "A2"."RVA32", "A2"."RVA33", "A2"."RVAMKSG", "A2"."RVACONT", "A2"."RVA34", "A1"."RVB01", "A1"."RVB02", "A1"."RVB03", "A1"."RVB04", "A1"."RVB05", "A1"."RVB06", "A1"."RVB07", "A1"."RVB08", "A1"."RVB09", "A1"."RVB10", "A1"."RVB11", "A1"."RVB12", "A1"."RVB13", "A1"."RVB14", "A1"."RVB15", "A1"."RVB16", "A1"."RVB17", "A1"."RVB18 ", "A1"."RVB19", "A1"."RVB20", "A1"."RVB21", "A1"."RVB22", "A1"."RVB25", "A1"."RVB26", "A1"."RVB27", "A1"."RVB28", "A1"."RVB29", "A1"."RVB30", "A1"."RVB31", "A1"."RVB32", "A1"."RVB33", "A1"."RVB34", "A1"."RVB35", "A1"."RVB36", "A1"."RVB37", "A1"."RVB38", "A1"."RVB39", "A1"."RVB40", "A1"."RVB41", "A1"."RVB80", "A1"."RVB81", "A1"."RVB82", "A1"."RVB83", "A1"."RVB84", "A1"."RVB85", "A1"."RVB86", "A1"."RVB87", " A1"."RVB88", "A1"."RVB88T", "A1"."RVB10T", "A1"."RVB331", "A1"."RVB332", "A1"."RVB930", "A1"."RVBUD01", "A1"."RVBUD02", "A1"."RVBUD03", "A1"."RVBUD04", "A1"."RVBUD05", "A1"."RVBUD06", "A1"."RVBUD07", "A1"."RVBUD08", "A1"."RVBUD09", "A1"."RVBUD10", "A1"."RVBUD11", "A1"."RVBUD12", "A1"."RVBUD13", "A1"."RVBUD14", "A1"."RVBUD15", "A1"."RVB051", "A1"."RVB89", "A1"."RVB90", "A1"."RVB90_FAC", "A1"."RVB42", "A1"."RVB43", "A1"."RVB44", "A1" ."RVB45", "A1"."RVBPLANT", "A1"."RVBLEGAL", "A1"."RVB93", "A1"."RVB919" FROM "NLPM01"."RVA_FILE" "A2", "NLPM01"."RVB_FILE" "A1" WHERE "A2"."RVAUD05"='Y' AND "A2"."RVA01"="A1"."RVB01"(+)
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
40h437t5013u3	SELECT "A1"."RVV01", "A1"."RVV02", "A1"."RVV31", "A1"."IMA02", "A1"."IMA021", "A1"."RVV17", "A1"."RVV32", "A1"."RVV33", "A1"."RVV34", "A1"."RVV171", "A1"."RVV172", "A1"."RVVUD03", "A1"."GEM02" FROM "CRVV_VIEW" "A1" WHERE EXISTS (SELECT 1 FROM "CRVU_VIEW" "A2" WHERE "A2"."RVU00"<>'3' AND TO_CHAR(NVL("A2"."RVUDATE", "A2"."RVU03"), 'yyyyMMdd')>'20170728' AND "A2"."RVU01"="A1"."RVV01" AND "A2"."DBTYPE"='1') AND "A1"."DBTYPE"='1'
40ju0vrjd86s5	create table tt36208
591q7n5r70vkw	SELECT "A3"."OGB01", "A3"."OGB03", "A3"."OGBUD02", "A3"."OGBUD03", "A3"."OGBUD04", "A3"."OGBUD06", "A3"."OGBUD01", "A3"."OGB04", "A3"."OGB12", "A3"."OGB09", "A3"."OGB091", "A3"."OGB092", "A3"."OEBUD02", "A3"."OEBUD03", "A3"."OGBUD07" FROM "HTOGB1_VIEW" "A3", "HTOGA1_VIEW" "A2", "HTOGA1_VIEW" "A1" WHERE "A1"."OGA09"='0' AND "A3"."OGB01"="A1"."OGA01" AND "A3"."DBTYPE"='1' AND "A2"."OGACONF"='Y' AND ("A2"."OGA09"='0' AND SUBSTR("A2"."OGA01", 1, 4)='S841' OR "A2"."OGA09"='1' AND SUBSTR("A3"."OGB09", 4, 1)='3') AND "A3"."OGB01"="A2"."OGA01" AND "A3"."DBTYPE"='1' AND "A1"."OGA01"=ANY (SELECT "A5"."OGB01" FROM "HTOGB1_VIEW" "A5", "HTOGA1_VIEW" "A4" WHERE "A5"."DBTYPE"='1' AND "A4"."OGACONF"='Y' AND ("A4"."OGA09"='0' AND SUBSTR("A4"."OGA01", 1, 4)='S841' OR "A4"."OGA09"='1' AND SUBSTR("A5"."OGB09", 4, 1)='3') AND "A5"."OGB01"="A4"."OGA01" AND "A4"."DBTYPE"='1' AND "A5"."DBTYPE"='1') AND "A1"."DBTYPE"='1' AND "A2"."DBTYPE"='1'
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)
62p83a4v443bf	select gae04, gav03, gav04, gav09, gav10, gav07, gav14, gav15, gav32, gaq03 from gae_file LEFT OUTER JOIN gav_file ON gae01 = gav01 AND gae02 = gav02 AND gae11 = gav08 AND gae12 = gav11 LEFT OUTER JOIN gaq_file ON gae02 = gaq01 AND gae03 = gaq02 where gae01 = :p1 AND gae02 = :p2 AND gae03 = :p3 AND gae11 = :p4 AND gae12 = :p5
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6g4dgxt73981r	select distinct omf00, omf01, omf02, omf03, omf05, omf051, omf06, omf061, omf07, omf08, omf22, omf27, omf271, omf30, omf24, omfpost, omf04, '', '', '', '', '', '', omf31, omf32, omf33, omfuser, omfgrup, omforiu, omforig, omfmodu, omfdate, ta_omf01, ta_omf02, ta_omf03, ta_omf04, ta_omf05, ta_omf06, ta_omf07, ta_omf08, ta_omf09, ta_omf11, ta_omf12, ta_omf13, ta_omf14, ta_omf17, ta_omf16, ta_omf19, ta_omf18, ta_omf26 from omf_file, occ_file, gem_file where omf00 = :p1
6k38zq7rf14c8	SELECT "A1"."PMM01", "A1"."PMM02", "A1"."PMM04", "A1"."PMM09", "A1"."PMM18", "A1"."PMM12", "A1"."PMM21", "A1"."PMM22", "A1"."PMM42", "A1"."PMM43", "A1"."PMM909", "A1"."TA_IMA03", "A1"."IMA021", "A1"."PMN33" FROM (SELECT DISTINCT "A4"."PMM01" "PMM01", "A4"."PMM02" "PMM02", TO_CHAR("A4"."PMM04", 'yyyyMMdd') "PMM04", "A4"."PMM09" "PMM09", "A4"."PMM18" "PMM18", "A4"."PMM12" "PMM12", "A4"."PMM21" "PMM21", "A4"."PMM22" "PMM22", "A4"."PMM42" "PMM42", "A4"."PMM43" "PMM43", "A4"."PMM909" "PMM909", '' "TA_IMA03", '' "IMA021", '' "PMN33" FROM "TOA_PMN_VIEW" "A5", "TOA_PMM_VIEW" "A4", LATERAL( (SELECT "A6"."DBTYPE" "DBTYPE_0", "A6"."SFB01" "SFB01", "A6"."SFB02" "SFB02", "A6"."SFB03" "SFB03", "A6"."SFB04" "SFB04", "A6"."SFB05" "SFB05_5", "A6"."SFB06" "SFB06", "A6"."SFB07" "SFB07", "A6"."SFB071" "SFB071", "A6"."SFB08" "SFB08", "A6"."SFB081" "SFB081", "A6"."SFB09" "SFB09", "A6"."SFB10" "SFB10", "A6"."SFB11" "SFB11", "A6"."SFB111" "SFB111", "A6"."SFB12" "SFB12", "A6"."SFB121" "SFB121", "A6"."SFB122" "SFB122", "A6"."SFB13" "SFB13", "A6"."SFB14" "SFB14", "A6"."SFB15" "SFB15", "A6"."SFB16" "SFB16", "A6"."SFB17" "SFB17", "A6"."SFB18" "SFB18", "A6"."SFB19" "SFB19", "A6"."SFB20" "SFB20", "A6"."SFB21" "SFB21", "A6"."SFB22" "SFB22", "A6"."SFB221" "SFB221", "A6"."SFB222" "SFB222", "A6"."SFB23" "SFB23", "A6"."SFB24" "SFB24", "A6"."SFB25" "SFB25", "A6"."SFB251" "SFB251", "A6"."SFB26" "SFB26", "A6"."SFB27" "SFB27", "A6"."SFB271" "SFB271", "A6"."SFB28" "SFB28", "A6"."SFB29" "SFB29", "A6"."SFB30" "SFB30", "A6"."SFB31" "SFB31", "A6"."SFB32" "SFB32", "A6"."SFB33" "SFB33", "A6"."SFB34" "SFB34", "A6"."SFB35" "SFB35", "A6"."SFB36" "SFB36", "A6"."SFB37" "SFB37", "A6"."SFB38" "SFB38", "A6"."SFB39" "SFB39", "A6"."SFB40" "SFB40", "A6"."SFB41" "SFB41", "A6"."SFB42" "SF B42", "A6"."SFB81" "SFB81", "A6"."SFB82" "SFB82", "A6"."SFB85" "SFB85", "A6"."SFB86" "SFB86", "A6"."SFB87" "SFB87", "A6"."SFB88" "SFB88", "A6"."SFB91" "SFB91", "A6"."SFB92" "SFB92", "A6"."SFB93" "SFB93", "A6"."SFB94" "SFB94", "A6"."SFB95" "SFB95", "A6"."SFB96" "SFB96", "A6"."SFB97" "SFB97", "A6"."SFB98" "SFB98", "A6"."SFB99" "SFB99", "A6"."SFB100" "SFB100", "A6"."SFB101" "SFB101", "A6"."SFBACTI" "SFBACTI", "A6"."SFBUSER" "SFBU SER", "A6"."SFBGRUP" "SFBGRUP", "A6"."SFBMODU" "SFBMODU", "A6"."SFBDATE" "SFBDATE", "A6"."SFB1001" "SFB1001", "A6"."SFB1002" "SFB1002", "A6"."SFB1003" "SFB1003", "A6"."SFB102" "SFB102", "A6"."SFB50" "SFB50", "A6"."SFB51" "SFB51", "A6"."SFB103" "SFB103", "A6"."SFBUD01" "SFBUD01", "A6"."SFBUD02" "SFBUD02", "A6"."SFBUD03" "SFBUD03", "A6"."SFBUD04" "SFBUD04", "A6"."SFBUD05" "SFBUD05", "A6"."SFBUD06" "SFBUD06", "A6"."SFBUD07" "SFBUD07", "A6"."SFBUD08" "SFBUD08 ", "A6"."SFBUD09" "SFBUD09", "A6"."SFBUD10" "SFBUD10", "A6"."SFBUD11" "SFBUD11", "A6"."SFBUD12" "SFBUD12", "A6"."SFBUD13" "SFBUD13", "A6"."SFBUD14" "SFBUD14", "A6"."SFBUD15" "SFBUD15", "A6"."SFB43" "SFB43", "A6"."SFB44" "SFB44", "A6"."SFBMKSG" "SFBMKSG", "A6"."SFBPLANT" "SFBPLANT", "A6"."SFBLEGAL" "SFBLEGAL", "A6"."SFBORIU" "SFBORIU", "A6"."SFBORIG" "SFBORIG", "A6"."SFB104" "SFB104", "A6"."SFB919" "SFB919", "A6"."SFB89" "SFB89", "A6"."TA_SFB01" "TA_SFB01 ", "A6"."TA_SFB02" "TA_SFB02", "A6"."TA_SFB03" "TA_SFB03", "A6"."TA_SFB04" "TA_SFB04", "A6"."TA_SFB05" "TA_SFB05", "A6"."TA_SFB06" "TA_SFB06", "A6"."TA_SFB07" "TA_SFB07", "A6"."TA_SFB08" "TA_SFB08", "A6"."TA_SFB09" "TA_SFB09", "A6"."TA_SFB10" "TA_SFB10", "A6"."TA_SFB11" "TA_SFB11" FROM "TOA_SFB_VIEW" "A6" WHERE "A5"."PMN41"="A6"."SFB01" AND "A6"."DBTYPE"='1' AND "A5"."DBTYPE"='1'))(+) "A3", LATERAL( (SELECT "A7"."DBTYPE" "DBTYPE", "A7"."IMA01" "IMA01", "A7"."IMA02" "IMA02", "A7". "IMA021" "IMA021", "A7"."IMA03" "IMA03", "A7"."IMA04" "IMA04", "A7"."IMA05" "IMA05", "A7"."IMA06" "IMA06", "A7"."IMA07" "IMA07", "A7"."IMA08" "IMA08", "A7"."IMA09" "IMA09", "A7"."IMA10" "IMA10", "A7"."IMA11" "IMA11", "A7"."IMA12" "IMA12", "A7"."IMA13" "IMA13", "A7"."IMA14" "IMA14", "A7"."IMA15" "IMA15", "A7"."IMA16" "IMA16", "A7"."IMA17" "IMA17", "A7"."IMA17_FAC" "IMA17_FAC", "A7"."IMA18" "IMA18", "A7"."IMA19" "IMA19", "A7". "IMA20" "IMA20", "A7"."IMA21" "IMA21", "A7"."IMA22" "IMA22", "A7"."IMA23" "IMA23", "A7"."IMA24" "IMA24", "A7"."IMA25" "IMA25", "A7"."IMA26" "IMA26", "A7"."IMA261" "IMA261", "A7"."IMA262" "IMA262", "A7"."IMA27" "IMA27", "A7"."IMA271" "IMA271", "A7"."IMA28" "IMA28", "A7"."IMA29" "IMA29", "A7"."IMA30" "IMA30", "A7"."IMA31" "IMA31", "A7"."IMA31_FAC" "IMA31_FAC", "A7"."IMA32" "IMA32", "A7"."IMA33" "IMA33", "A7"."IMA34" "IMA34", "A7 "."IMA35" "IMA35", "A7"."IMA36" "IMA36", "A7"."IMA37" "IMA37", "A7"."IMA38" "IMA38", "A7"."IMA39" "IMA39", "A7"."IMA40" "IMA40", "A7"."IMA41" "IMA41", "A7"."IMA42" "IMA42", "A7"."IMA43" "IMA43", "A7"."IMA44" "IMA44", "A7"."IMA44_FAC" "IMA44_FAC", "A7"."IMA45" "IMA45", "A7"."IMA46" "IMA46", "A7"."IMA47" "IMA47", "A7"."IMA48" "IMA48", "A7"."IMA49" "IMA49", "A7"."IMA491" "IMA491", "A7"."IMA50" "IMA50", "A7"."IMA51" "IMA51", "A7 "."IMA52" "IMA52", "A7"."IMA53" "IMA53", "A7"."IMA531" "IMA531", "A7"."IMA532" "IMA532", "A7"."IMA54" "IMA54", "A7"."IMA55" "IMA55", "A7"."IMA55_FAC" "IMA55_FAC", "A7"."IMA56" "IMA56", "A7"."IMA561" "IMA561", "A7"."IMA562" "IMA562", "A7"."IMA57" "IMA57", "A7"."IMA571" "IMA571", "A7"."IMA58" "IMA58", "A7"."IMA59" "IMA59", "A7"."IMA60" "IMA60", "A7"."IMA61" "IMA61", "A7"."IMA62" "IMA62", "A7"."IMA63" "IMA63", "A7"."IMA63_FAC" "IMA63_FAC ", "A7"."IMA64" "IMA64", "A7"."IMA641" "IMA641", "A7"."IMA65" "IMA65", "A7"."IMA66" "IMA66", "A7"."IMA67" "IMA67", "A7"."IMA68" "IMA68", "A7"."IMA69" "IMA69", "A7"."IMA70" "IMA70", "A7"."IMA71" "IMA71", "A7"."IMA72" "IMA72", "A7"."IMA73" "IMA73", "A7"."IMA74" "IMA74", "A7"."IMA86" "IMA86", "A7"."IMA86_FAC" "IMA86_FAC", "A7"."IMA87" "IMA87", "A7"."IMA871" "IMA871", "A7"."IMA872" "IMA872", "A7"."IMA873" "IMA873", "A7"."IMA874" " IMA874", "A7"."IMA88" "IMA88", "A7"."IMA881" "IMA881", "A7"."IMA89" "IMA89", "A7"."IMA90" "IMA90", "A7"."IMA91" "IMA91", "A7"."IMA92" "IMA92", "A7"."IMA93" "IMA93", "A7"."IMA94" "IMA94", "A7"."IMA95" "IMA95", "A7"."IMA75" "IMA75", "A7"."IMA76" "IMA76", "A7"."IMA77" "IMA77", "A7"."IMA78" "IMA78", "A7"."IMA79" "IMA79", "A7"."IMA80" "IMA80", "A7"."IMA81" "IMA81", "A7"."IMA82" "IMA82", "A7"."IMA83" "IMA83", "A7"."IMA84" "IMA84 ", "A7"."IMA85" "IMA85", "A7"."IMA851" "IMA851", "A7"."IMA852" "IMA852", "A7"."IMA853" "IMA853", "A7"."IMA96" "IMA96", "A7"."IMA97" "IMA97", "A7"."IMA98" "IMA98", "A7"."IMA99" "IMA99", "A7"."IMA100" "IMA100", "A7"."IMA101" "IMA101", "A7"."IMA102" "IMA102", "A7"."IMA103" "IMA103", "A7"."IMA104" "IMA104", "A7"."IMA105" "IMA105", "A7"."IMA106" "IMA106", "A7"."IMA107" "IMA107", "A7"."IMA108" "IMA108", "A7"."IMA109" "IMA109", "A7"."IMA110 " "IMA110", "A7"."IMA111" "IMA111", "A7"."IMA121" "IMA121", "A7"."IMA122" "IMA122", "A7"."IMA123" "IMA123", "A7"."IMA124" "IMA124", "A7"."IMA125" "IMA125", "A7"."IMA126" "IMA126", "A7"."IMA127" "IMA127", "A7"."IMA128" "IMA128", "A7"."IMA129" "IMA129", "A7"."IMA130" "IMA130", "A7"."IMA131" "IMA131", "A7"."IMA132" "IMA132", "A7"."IMA133" "IMA133", "A7"."IMA134" "IMA134", "A7"."IMA135" "IMA135", "A7"."IMA136" "IMA136", "A7"."IMA137" "IMA137", "A7"."IMA138" "IMA138", "A7"."IMA139" "IMA139", "A7"."IMA140" "IMA140", "A7"."IMA141" "IMA141", "A7"."IMA142" "IMA142", "A7"."IMA143" "IMA143", "A7"."IMA144" "IMA144", "A7"."IMA145" "IMA145", "A7"."IMA146" "IMA146", "A7"."IMA147" "IMA147", "A7"."IMA148" "IMA148", "A7"."IMA901" "IMA901", "A7"."IMA902" "IMA902", "A7"."IMA903" "IMA903", "A7"."IMA904" "IMA904", "A7"."IMA905" "IMA905", "A7"."IMA906" "IMA906", "A7"."IMA907" "IMA907", "A7"."IMA908 " "IMA908", "A7"."IMA909" "IMA909", "A7"."IMA910" "IMA910", "A7"."IMAACTI" "IMAACTI", "A7"."IMAUSER" "IMAUSER", "A7"."IMAGRUP" "IMAGRUP", "A7"."IMAMODU" "IMAMODU", "A7"."IMADATE" "IMADATE", "A7"."IMAAG" "IMAAG", "A7"."IMAAG1" "IMAAG1", "A7"."IMAUD01" "IMAUD01", "A7"."IMAUD02" "IMAUD02", "A7"."IMAUD03" "IMAUD03", "A7"."IMAUD04" "IMAUD04", "A7"."IMAUD05" "IMAUD05", "A7"."IMAUD06" "IMAUD06", "A7"."IMAUD07" "IMAUD07", "A7"."IMAUD08" "IMAUD08", "A7"."IMAUD09 " "IMAUD09", "A7"."IMAUD10" "IMAUD10", "A7"."IMAUD11" "IMAUD11", "A7"."IMAUD12" "IMAUD12", "A7"."IMAUD13" "IMAUD13", "A7"."IMAUD14" "IMAUD14", "A7"."IMAUD15" "IMAUD15", "A7"."IMA1001" "IMA1001", "A7"."IMA1002" "IMA1002", "A7"."IMA1003" "IMA1003", "A7"."IMA1004" "IMA1004", "A7"."IMA1005" "IMA1005", "A7"."IMA1006" "IMA1006", "A7"."IMA1007" "IMA1007", "A7"."IMA1008" "IMA1008", "A7"."IMA1009" "IMA1009", "A7"."IMA1010" "IMA1010", "A7"."IMA1011" "IMA1011", "A7". "IMA1012" "IMA1012", "A7"."IMA1013" "IMA1013", "A7"."IMA1014" "IMA1014", "A7"."IMA1015" "IMA1015", "A7"."IMA1016" "IMA1016", "A7"."IMA1017" "IMA1017", "A7"."IMA1018" "IMA1018", "A7"."IMA1019" "IMA1019", "A7"."IMA1020" "IMA1020", "A7"."IMA1021" "IMA1021", "A7"."IMA1022" "IMA1022", "A7"."IMA1023" "IMA1023", "A7"."IMA1024" "IMA1024", "A7"."IMA1025" "IMA1025", "A7"."IMA1026" "IMA1026", "A7"."IMA1027" "IMA1027", "A7"."IMA1028" "IMA1028", "A7"."IMA1029" "IMA1029", "A 7"."IMA911" "IMA911", "A7"."IMA912" "IMA912", "A7"."IMA913" "IMA913", "A7"."IMA914" "IMA914", "A7"."IMA391" "IMA391", "A7"."IMA1321" "IMA1321", "A7"."IMA1911" "IMA1911", "A7"."IMA1912" "IMA1912", "A7"."IMA1913" "IMA1913", "A7"."IMA1914" "IMA1914", "A7"."IMA1915" "IMA1915", "A7"."IMA1916" "IMA1916", "A7"."IMA1919" "IMA1919", "A7"."IMA1401" "IMA1401", "A7"."IMA915" "IMA915", "A7"."IMA916" "IMA916", "A7"."IMA917" "IMA917", "A7"."IMA150" "IMA150", "A7". "IMA151" "IMA151", "A7"."IMA152" "IMA152", "A7"."IMA918" "IMA918", "A7"."IMA919" "IMA919", "A7"."IMA920" "IMA920", "A7"."IMA921" "IMA921", "A7"."IMA922" "IMA922", "A7"."IMA923" "IMA923", "A7"."IMA924" "IMA924", "A7"."IMA925" "IMA925", "A7"."IMA601" "IMA601", "A7"."IMA153" "IMA153", "A7"."IMA926" "IMA926", "A7"."IMA154" "IMA154", "A7"."IMA155" "IMA155", "A7"."IMA149" "IMA149", "A7"."IMA1491" "IMA1491", "A7"."IMAORIU" "IMAORIU", "A7"."IMAORIG" "IMAORIG", "A7"."IMA9021" "IMA9021", "A7"."IMA022" "IMA022", "A7"."IMA251" "IMA251", "A7"."IMA940" "IMA940", "A7"."IMA941" "IMA941", "A7"."IMA156" "IMA156", "A7"."IMA157" "IMA157", "A7"."IMA158" "IMA158", "A7"."IMA927" "IMA927", "A7"."IMA120" "IMA120", "A7"."IMA159" "IMA159", "A7"."IMA928" "IMA928", "A7"."IMA929" "IMA929", "A7"."IMA160" "IMA160", "A7"."IMA161" "IMA161", "A7"."IMA162" "IMA162", "A7"."IMA163" "IMA163", "A7"."IMA1631" "IMA1631", "A7"."IMA721" "IMA721", "A7"."IMA171" "IMA171", "A7"."IMA172" "IMA172", "A7"."IMA1030" "IMA1030", "A7"."IMA930" "IMA930", "A7"."IMA931" "IMA931", "A7"."IMA932" "IMA932", "A7"."IMA933" "IMA933", "A7"."IMA934" "IMA934", "A7"."IMA164" "IMA164", "A7"."IMA1641" "IMA1641", "A7"."TA_IMA01" "TA_IMA01", "A7"."TA_IMA02" "TA_IMA02", "A7"."TA_IMA03" "TA_IMA03", "A7"."TA_IMA04" "TA_IMA04", "A7"."TA_IMA05" "TA_IMA05", "A7"."TA_IMA06" "TA_IMA06", "A7"."TA_IMA07" "TA_IMA07 ", "A7"."TA_IMA08" "TA_IMA08", "A7"."TA_IMA09" "TA_IMA09", "A7"."TA_IMA10" "TA_IMA10", "A7"."TA_IMA11" "TA_IMA11", "A7"."TA_IMA12" "TA_IMA12", "A7"."TA_IMA13" "TA_IMA13", "A7"."TA_IMA14" "TA_IMA14", "A7"."TA_IMA15" "TA_IMA15", "A7"."TA_IMA16" "TA_IMA16", "A7"."TA_IMA17" "TA_IMA17", "A7"."TA_IMA18" "TA_IMA18" FROM "TOA_IMA_VIEW" "A7" WHERE "A3"."SFB05_5"="A7"."IMA01" AND "A3"."DBTYPE_0"='1' AND "A7"."DBTYPE"='1'))(+) "A2" WHERE "A4"."PMM18"='Y' AND "A4"."PMM02"='SUB' AND "A4"."PMM09"='C0349' AND "A5"."PMN65"='2' AND "A5"."PMN01"="A4"."PMM01" AND "A5"."DBTYPE"='1' AND "A4"."DBTYPE"='1') "A1"
74anujtt8zw4h	select o.owner#, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property, 0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o where d.p_obj#=:1 and (d.p_timestamp=nvl(:2, d.p_timestamp) or d.property=2) and o.owner#=nvl(:3, o.owner#) and d.d_obj#=o.obj# order by o.obj#
78hqmypm5qfmb	select SUM(rvb07) from rvb_file, rva_file where rvb34 = :p1 AND rvb01 = rva01 AND rvb19 = '1' AND rva10 = 'SUB' AND rvaconf = 'Y'
7ksjhpjvkn647	SELECT "OMF03", "OMF16", "OMF19", "TA_OGB16", "OGA14" FROM "TOA_OMF_VIEW" "TOA_OMF_VIEW" WHERE "OGA14" IS NOT NULL AND EXTRACT(YEAR FROM "OMF03")=EXTRACT(YEAR FROM :1)
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7vun041qzbkmz	SELECT "A1"."RVU01", "A1"."RVU00", TO_CHAR("A1"."RVU03", 'yyyyMMdd'), "A1"."RVU04", "A1"."RVUCONF", TO_CHAR("A1"."RVUCRAT", 'yyyyMMdd'), "A1"."PMC081", TO_CHAR(NVL("A1"."RVUDATE", "A1"."RVU03"), 'yyyyMMdd') FROM "CRVU_VIEW" "A1" WHERE "A1"."RVU00"<>'3' AND TO_CHAR(NVL("A1"."RVUDATE", "A1"."RVU03"), 'yyyyMMdd')>'20170728' AND "A1"."DBTYPE"='1'
7wj19b74z7yy4	SELECT "A1"."OGA01", TO_CHAR("A1"."OGA69", 'yyyyMMdd'), TO_CHAR("A1"."OGACOND", 'yyyyMMdd'), "A1"."OGAORIG", "A1"."OGACONF", "A1"."OGAUD06", "A1"."OGA03", "A1"."OGA032", "A1"."OCC18", "A1"."OGA011" FROM "HTOGA1_VIEW" "A1" WHERE "A1"."OGA09"='1' AND "A1"."OGA01"=ANY (SELECT "A3"."OGB01" FROM "HTOGB1_VIEW" "A3", "HTOGA1_VIEW" "A2" WHERE "A3"."DBTYPE"='1' AND "A2"."OGACONF"='Y' AND ("A2"."OGA09"='0' AND SUBSTR("A2"."OGA01", 1, 4)='S841' OR "A2"."OGA09"='1' AND SUBSTR("A3"."OGB09", 4, 1)='3') AND "A3"."OGB01"="A2"."OGA01 " AND "A3"."DBTYPE"='1' AND "A2"."DBTYPE"='1') AND "A1"."DBTYPE"='1'
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#
8w4c8u9udsuyy	select count(*) from ( select u.name from registry$ r, user$ u where r.status in (1, 3, 5) and r.namespace = 'SERVER' and r.schema# = u.user# and u.name = :1 union all select u.name from registry$ r, registry$schemas s, user$ u where r.status in (1, 3, 5) and r.namespace = 'SERVER' and r.cid = s.cid and s.schema# = u.user# and u.name = :1)
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
9y7s2afnkqs9d	delete from idl_ub2$ where obj#=:1 and part=:2
a0u7bj627dfqt	select gbs06 from gbs_file where gbs01 = :p1 AND gbs02 = :p2 AND gbs03 = :p3 AND gbs04 = :p4 AND gbs05 = :p5
b3k1j7c3djjqd	SELECT "DBTYPE", "SFA01", "SFA03", "SFA08", "SFA27", "SFA12", "SFA11", "SFA05", "SFA16", "SFA161", "SFA065", "SFA06" FROM "SFA_VIEW" "SFA_VIEW" WHERE "DBTYPE"='1'
b45u3b52kx4v7	SELECT "PMM01", "PMM04", "PMM09", "PMM22", "PMN02", "PMN04", "CGWJL", "PMM25", "PMN16", "PMC909", "PMCUD13", "RVB07_N" FROM "PO_PMM_VIEW" "T" WHERE "PMN16"='2' AND "PMM22"='RMB' AND "PMN04"='105010103' AND "CGWJL">0 AND "PMM25"<>'0' AND ("PMM01"='ZP20-16100639' OR "PMC909"='Y' AND "PMM04">=TO_CHAR("PMCUD13", 'yyyy-MM-dd')) AND LOWER("PMM09")='c0298'
bvn085xhxfn9f	insert into sys.wri$_optstat_histhead_history (obj#, intcol#, flags, expression, colname, savtime) values (:1, :2, :3, :4, :5, :6)
c49tbx3qqrtm4	insert into dependency$(d_obj#, d_timestamp, order#, p_obj#, p_timestamp, property, d_attrs)values (:1, :2, :3, :4, :5, :6, :7)
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)
cu8mztahhpwhr	SELECT DISTINCT "A2"."IMM01", TO_CHAR("A2"."IMM17", 'yyyyMMdd'), '' FROM "IMM_VIEW" "A2", "IMN_VIEW" "A1" WHERE ("A1"."IMN05"<>' ' OR "A1"."IMN16"<>' ') AND "A2"."IMM01"="A1"."IMN01"(+) AND "A2"."DBTYPE"='1' AND "A1"."DBTYPE"(+)='1'
d5jd9b2xct7xz	delete from idl_char$ where obj#=:1 and part=:2
dkyqv38h875m3	SELECT "A2"."RVV01", "A2"."RVV02", "A2"."RVV31", "A2"."RVV171", "A2"."RVV18", "A2"."RVV172", "A2"."RVV32", "A2"."RVV33", "A2"."RVV34" FROM "WRVV_VIEW" "A2", "WRVU_VIEW" "A1" WHERE "A1"."RVU00"<>'3' AND "A2"."RVV01"="A1"."RVU01" AND "A2"."DBTYPE"='1' AND "A1"."DBTYPE"='1'
dvpfc386d6dmm	delete from idl_sb4$ where obj#=:1 and part=:2
fb6wkr62s47mv	SELECT "A2"."INB01", "A2"."INB03", "A2"."INB04", CASE WHEN "A1"."INA00"='1' THEN "A2"."INB09" ELSE (-"A2"."INB09") END , "A2"."INB05", "A2"."INB06", "A2"."INB07", "A2"."INB08_FAC", CASE WHEN "A1"."INA00"='1' THEN "A2"."INB16" ELSE (-"A2"."INB16") END , "A2"."INB11", "A2"."INB12", "A2"."INB15" FROM "INB_VIEW" "A2", "INA_VIEW" "A1" WHERE "A2"."INB01"="A1"."INA01"(+) AND "A2"."DBTYPE"='1' AND "A1"."DBTYPE"(+)='1'
fcyws29qzab6f	select gaj03, gaj04, gaj05, gaj06, gaj12 from gaj_file where gaj01 = :p1 AND gaj02 = :p2 AND gaj11 = :p3
fwbtm6g368j79	SELECT "A1"."IMM01", '', TO_CHAR("A1"."IMM17", 'yyyyMMdd'), "A1"."IMM03", "A1"."IMM04", TO_CHAR("A1"."IMM02", 'yyyyMMdd') FROM "IMM_VIEW" "A1" WHERE "A1"."IMM01"=ANY (SELECT "A2"."IMN01" FROM "IMN_VIEW" "A2" WHERE "A2"."DBTYPE"='1') AND "A1"."DBTYPE"='1'
gdhz78y24tvnz	delete from ncomp_dll$ where obj#=:1 returning dllname into :2
gsqxm6zz3w2by	delete from idl_ub1$ where obj#=:1 and part=:2

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Key Instance Activity Stats
Other Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	319,014,636	88,435.24	23,050.19
execute count	2,966,879	822.46	214.37
logons cumulative	290	0.08	0.02
opened cursors cumulative	1,119,747	310.41	80.91
parse count (total)	473,177	131.17	34.19
parse time elapsed	15,702	4.35	1.13
physical reads	6,673,346	1,849.94	482.18
physical writes	6,116,427	1,695.56	441.94
redo size	48,648,582,080	13,486,054.65	3,515,070.96
session cursor cache hits	162,920	45.16	11.77
session logical reads	333,497,789	92,450.16	24,096.66
user calls	2,412,017	668.64	174.28
user commits	13,833	3.83	1.00
user rollbacks	7	0.00	0.00
workarea executions - multipass	0	0.00	0.00
workarea executions - onepass	12	0.00	0.00
workarea executions - optimal	598,052	165.79	43.21

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	2,161	0.60	0.16
Batched IO (full) vector count	1	0.00	0.00
Batched IO (space) vector count	34	0.01	0.00
Batched IO block miss count	17,877	4.96	1.29
Batched IO buffer defrag count	115	0.03	0.01
Batched IO double miss count	716	0.20	0.05
Batched IO same unit count	9,834	2.73	0.71
Batched IO single block count	821	0.23	0.06
Batched IO slow jump count	1	0.00	0.00
Batched IO vector block count	7,247	2.01	0.52
Batched IO vector read count	1,441	0.40	0.10
Block Cleanout Optim referenced	268	0.07	0.02
CCursor + sql area evicted	171	0.05	0.01
CPU used by this session	220,971	61.26	15.97
CPU used when call started	220,242	61.05	15.91
CR blocks created	997,978	276.65	72.11
Cached Commit SCN referenced	207	0.06	0.01
Commit SCN cached	91,664	25.41	6.62
DBWR checkpoint buffers written	4,050,866	1,122.96	292.69
DBWR checkpoints	211	0.06	0.02
DBWR object drop buffers written	125	0.03	0.01
DBWR revisited being-written buffer	4,990	1.38	0.36
DBWR tablespace checkpoint buffers written	6,118	1.70	0.44
DBWR thread checkpoint buffers written	123,707	34.29	8.94
DBWR transaction table writes	1,602	0.44	0.12
DBWR undo block writes	1,719,043	476.54	124.21
HSC Heap Segment Block Changes	151,967,808	42,127.56	10,980.33
Heap Segment Array Inserts	2,484,404	688.71	179.51
Heap Segment Array Updates	1,447	0.40	0.10
IMU CR rollbacks	2	0.00	0.00
IMU Flushes	1,497	0.41	0.11
IMU Redo allocation size	3,494,864	968.82	252.52
IMU commits	5,930	1.64	0.43
IMU contention	21	0.01	0.00
IMU ktichg flush	47	0.01	0.00
IMU pool not allocated	74	0.02	0.01
IMU recursive-transaction flush	2	0.00	0.00
IMU undo allocation size	10,095,816	2,798.70	729.47
IMU- failed to get a private strand	74	0.02	0.01
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	33,916	9.40	2.45
Requests to/from client	2,301,316	637.96	166.28
RowCR - row contention	5	0.00	0.00
RowCR attempts	743	0.21	0.05
RowCR hits	576	0.16	0.04
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	2,301,320	637.96	166.28
SQL*Net roundtrips to/from dblink	132	0.04	0.01
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	11	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	794,868	220.35	57.43
auto extends on undo tablespace	11	0.00	0.00
background checkpoints completed	104	0.03	0.01
background checkpoints started	105	0.03	0.01
background timeouts	17,889	4.96	1.29
branch node splits	12	0.00	0.00
buffer is not pinned count	18,936,931	5,249.58	1,368.28
buffer is pinned count	249,596,916	69,191.69	18,034.46
bytes received via SQL*Net from client	6,310,348,300	1,749,315.16	455,950.02
bytes received via SQL*Net from dblink	28,470	7.89	2.06
bytes sent via SQL*Net to client	1,321,472,980	366,330.45	95,482.15
bytes sent via SQL*Net to dblink	31,717	8.79	2.29
calls to get snapshot scn: kcmgss	1,328,211	368.20	95.97
calls to kcmgas	466,289	129.26	33.69
calls to kcmgcs	3,381,402	937.37	244.32
cell physical IO interconnect bytes	307,937,320,448	85,364,451.62	22,249,806.39
change write time	74,470	20.64	5.38
cleanout - number of ktugct calls	2,231,506	618.60	161.24
cleanouts and rollbacks - consistent read gets	81	0.02	0.01
cleanouts only - consistent read gets	1,436,156	398.12	103.77
cluster key scan block gets	319,588	88.59	23.09
cluster key scans	281,995	78.17	20.38
commit batch performed	1	0.00	0.00
commit batch requested	1	0.00	0.00
commit batch/immediate performed	529	0.15	0.04
commit batch/immediate requested	529	0.15	0.04
commit cleanout failures: block lost	54,563	15.13	3.94
commit cleanout failures: buffer being written	18,406	5.10	1.33
commit cleanout failures: callback failure	321	0.09	0.02
commit cleanout failures: cannot pin	48	0.01	0.00
commit cleanouts	951,039	263.64	68.72
commit cleanouts successfully completed	877,701	243.31	63.42
commit immediate performed	528	0.15	0.04
commit immediate requested	528	0.15	0.04
commit txn count during cleanout	1,445,847	400.81	104.47
consistent changes	61,002,559	16,910.75	4,407.70
consistent gets	159,554,999	44,230.84	11,528.54
consistent gets - examination	78,817,112	21,849.19	5,694.88
consistent gets direct	2,752,732	763.10	198.90
consistent gets from cache	156,802,263	43,467.74	11,329.64
consistent gets from cache (fastpath)	77,477,596	21,477.85	5,598.09
cursor authentications	580	0.16	0.04
data blocks consistent reads - undo records applied	60,996,899	16,909.18	4,407.29
db block gets	173,942,536	48,219.26	12,568.10
db block gets direct	386,927	107.26	27.96
db block gets from cache	173,555,609	48,112.00	12,540.15
db block gets from cache (fastpath)	6,553,489	1,816.72	473.52
deferred (CURRENT) block cleanout applications	618,376	171.42	44.68
dirty buffers inspected	1,680,090	465.74	121.39
enqueue conversions	506,172	140.32	36.57
enqueue deadlocks	0	0.00	0.00
enqueue releases	811,119	224.85	58.61
enqueue requests	811,143	224.86	58.61
enqueue timeouts	22	0.01	0.00
enqueue waits	237	0.07	0.02
exchange deadlocks	3	0.00	0.00
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
free buffer inspected	9,653,953	2,676.21	697.54
free buffer requested	8,798,876	2,439.17	635.76
heap block compress	17,110,895	4,743.37	1,236.34
hot buffers moved to head of LRU	1,910,131	529.51	138.02
immediate (CR) block cleanout applications	1,436,237	398.14	103.77
immediate (CURRENT) block cleanout applications	149,479	41.44	10.80
index crx upgrade (positioned)	10,108	2.80	0.73
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	356,607	98.86	25.77
index fetch by key	12,014,797	3,330.67	868.12
index scans kdiixs1	1,612,893	447.12	116.54
leaf node 90-10 splits	286	0.08	0.02
leaf node splits	1,748	0.48	0.13
lob reads	104	0.03	0.01
lob writes	1,585	0.44	0.11
lob writes unaligned	243	0.07	0.02
logical read bytes from cache	2,706,291,515,392	750,221,151.52	195,541,294.46
max cf enq hold time	4,760	1.32	0.34
messages received	134,556	37.30	9.72
messages sent	134,547	37.30	9.72
min active SCN optimization applied on CR	3	0.00	0.00
no buffer to keep pinned count	1,603	0.44	0.12
no work - consistent read gets	75,650,276	20,971.29	5,466.06
non-idle wait count	4,214,333	1,168.27	304.50
parse count (describe)	13	0.00	0.00
parse count (failures)	1,115	0.31	0.08
parse count (hard)	50,833	14.09	3.67
parse time cpu	10,195	2.83	0.74
physical read IO requests	862,141	239.00	62.29
physical read bytes	54,668,050,432	15,154,733.89	3,950,003.64
physical read total IO requests	946,080	262.27	68.36
physical read total bytes	105,991,393,280	29,382,268.93	7,658,337.66
physical read total multi block requests	101,384	28.11	7.33
physical reads cache	3,629,727	1,006.21	262.26
physical reads cache prefetch	2,825,916	783.38	204.18
physical reads direct	3,043,619	843.73	219.91
physical reads direct (lob)	10,182	2.82	0.74
physical reads direct temporary tablespace	346,367	96.02	25.03
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	4,448,920	1,233.30	321.45
physical write bytes	50,105,769,984	13,890,007.13	3,620,359.10
physical write total IO requests	4,781,840	1,325.59	345.51
physical write total bytes	201,945,927,168	55,982,182.69	14,591,468.73
physical write total multi block requests	220,280	61.06	15.92
physical writes direct	733,294	203.28	52.98
physical writes direct (lob)	3	0.00	0.00
physical writes direct temporary tablespace	346,367	96.02	25.03
physical writes from cache	5,383,133	1,492.28	388.95
physical writes non checkpoint	5,013,725	1,389.87	362.26
pinned buffers inspected	1,171	0.32	0.08
pinned cursors current	21	0.01	0.00
prefetch clients - default	10	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	5	0.00	0.00
process last non-idle time	3,555	0.99	0.26
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	4,940,228	1,369.50	356.95
recursive cpu usage	16,053	4.45	1.16
redo KB read	49,402,779	13,695.13	3,569.56
redo blocks checksummed by FG (exclusive)	17,280,647	4,790.43	1,248.60
redo blocks written	98,407,627	27,279.94	7,110.38
redo buffer allocation retries	534	0.15	0.04
redo entries	161,101,909	44,659.66	11,640.31
redo log space requests	1,750	0.49	0.13
redo ordering marks	5,675	1.57	0.41
redo size for direct writes	3,183,786,936	882,589.44	230,042.41
redo subscn max counts	522,252	144.78	37.73
redo synch long waits	82	0.02	0.01
redo synch poll writes	0	0.00	0.00
redo synch polls	0	0.00	0.00
redo synch time	17,202	4.77	1.24
redo synch time (usec)	172,126,444	47,715.81	12,436.88
redo synch time overhead (usec)	11,717,627	3,248.29	846.65
redo synch time overhead count (<128 msec)	8	0.00	0.00
redo synch time overhead count (<2 msec)	28,620	7.93	2.07
redo synch time overhead count (<32 msec)	19	0.01	0.00
redo synch time overhead count (<8 msec)	20	0.01	0.00
redo synch time overhead count (>=128 msec)	4	0.00	0.00
redo synch writes	28,691	7.95	2.07
redo wastage	24,091,100	6,678.38	1,740.69
redo write info find	28,679	7.95	2.07
redo write info find fail	8	0.00	0.00
redo write time	95,193	26.39	6.88
redo writes	94,860	26.30	6.85
rollback changes - undo records applied	3,526,147	977.50	254.78
rollbacks only - consistent read gets	997,898	276.63	72.10
root node splits	0	0.00	0.00
rows fetched via callback	1,518,357	420.91	109.71
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	793,235	219.90	57.31
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	6	0.00	0.00
sorts (memory)	520,115	144.18	37.58
sorts (rows)	114,022,410	31,608.58	8,238.61
sql area evicted	48,580	13.47	3.51
sql area purged	5,557	1.54	0.40
summed dirty queue length	7,571,750	2,098.99	547.09
switch current to new buffer	1,427,236	395.65	103.12
table fetch by rowid	14,876,229	4,123.89	1,074.87
table fetch continued row	1,421,604	394.09	102.72
table scan blocks gotten	62,342,766	17,282.27	4,504.54
table scan rows gotten	1,736,138,853	481,281.52	125,443.56
table scans (direct read)	158	0.04	0.01
table scans (long tables)	126	0.03	0.01
table scans (short tables)	437,842	121.38	31.64
temp space allocated (bytes)	4,194,304	1,162.72	303.06
total cf enq hold time	67,680	18.76	4.89
total number of cf enq holders	2,564	0.71	0.19
total number of times SMON posted	101	0.03	0.01
transaction rollbacks	9	0.00	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	13,623,485,124	3,776,617.06	984,355.86
user logons cumulative	274	0.08	0.02
user logouts cumulative	273	0.08	0.02
write clones created in background	11	0.00	0.00
write clones created in foreground	136,130	37.74	9.84

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
logons current	98	91
opened cursors current	943	1,012
session cursor cache count	7,144,436	7,151,073
session pga memory	664,792,144	631,217,688
session pga memory max	2,097,377,680	1,682,779,608
session uga memory	15,360,390,488	15,359,774,624
session uga memory max	594,289,788,496	594,922,836,000
workarea memory allocated	1,759	1,406

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)	105	104.79

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	47.6G	19.89	13.518M	47.5G	17.74	13.492M	135.4K	1.20
LGWR	183M	3.36	.051M	93.9G	74.48	26.647M	204.2K	8.83
DBWR	1M	0.02	0M	41.1G	1201.88	11.658M	5295	850.02
Buffer Cache Reads	27.7G	224.86	7.86M	0M	0.00	0M	805.2K	0.61
Direct Reads	23.2G	14.11	6.588M	498M	4.44	.138M	50.9K	0.35
Direct Writes	13M	0.00	.004M	5.1G	26.87	1.45M	112.9K	0.49
Streams AQ	0M	0.01	0M	0M	0.00	0M	49	5.24
TOTAL:	98.7G	262.25	28.02M	188.1G	1325.41	53.384M	1314K	5.35

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
Log File	47.1G	13.72	13.374M	93.8G	73.90	26.637M	0.03	0.00
Data File	48.3G	235.69	13.713M	44.1G	1230.95	12.507M	0.37	4.76
Archive Log	0M	0.00	0M	47.1G	13.39	13.374M
Temp File	2.6G	4.73	.75M	2.6G	3.76	.751M	0.03	0.00
Control File	659M	8.04	.183M	185M	3.28	.051M	0.04	0.04
Other	0M	0.09	0M	15M	0.18	.004M	0.50
TOTAL:	98.7G	262.25	28.02M	187.9G	1325.46	53.325M	0.36	2.02

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	47.6G	19.81	13.518M	47.5G	17.56	13.488M	76.5K	0.51
Others (Log File)	47.1G	13.60	13.374M	0M	0.00	0M	49.1K	0.00
Others (Archive Log)	0M	0.00	0M	47.1G	13.39	13.374M	0
Others (Control File)	476M	4.77	.132M	152M	2.70	.042M	17.2K	0.07
Others (Data File)	41M	1.43	.011M	260M	1.47	.072M	10.2K	3.69
LGWR	183M	3.36	.051M	93.9G	74.48	26.646M	12.6K	0.01
LGWR (Log File)	0M	0.12	0M	93.8G	73.90	26.637M	840	0.10
LGWR (Control File)	183M	3.25	.051M	33M	0.58	.009M	11.7K	0.00
DBWR	1M	0.02	0M	41.1G	1201.72	11.655M	55	0.00
DBWR (Data File)	0M	0.00	0M	41.1G	1201.72	11.655M	0
DBWR (Control File)	1M	0.02	0M	0M	0.00	0M	55	0.00
Buffer Cache Reads	27.7G	224.86	7.858M	0M	0.00	0M	802.2K	0.58
Buffer Cache Reads (Data File)	27.7G	224.86	7.858M	0M	0.00	0M	802.2K	0.58
Direct Reads	23.2G	14.11	6.588M	498M	4.44	.138M	0
Direct Reads (Data File)	23.2G	14.11	6.588M	498M	4.44	.138M	0
Direct Writes	13M	0.00	.004M	5.1G	26.87	1.45M	0
Direct Writes (Data File)	13M	0.00	.004M	5.1G	26.87	1.45M	0
Streams AQ	0M	0.01	0M	0M	0.00	0M	49	5.24
Streams AQ (Data File)	0M	0.01	0M	0M	0.00	0M	49	5.24
TOTAL:	98.7G	262.16	28.019M	188G	1325.07	53.378M	891.4K	0.57

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
DBS1	261,489	72	1.43	21.25	3,035,179	52.07	1	841	0	0.00
UNDOTBS1	513,264	142	0.08	1.00	1,392,985	142.28	0	386	22	0.00
SYSTEM	52,943	15	1.47	1.46	5,125	14.45	1	1	55	0.73
TEMP	17,045	5	0.01	20.32	13,556	0.02	3	4	0	0.00
BLOBDBS1	10,136	3	0.01	1.01	0	2.80	0	0	0	0.00
SYSAUX	6,332	2	3.18	20.60	913	1.45	2	0	0	0.00
AUDIT	633	0	4.38	61.40	460	0.09	9	0	0	0.00
TEMPTABS	201	0	2.04	1.00	533	0.06	2	0	0	0.00
RPTDBS1	61	0	2.46	1.00	115	0.02	3	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
AUDIT	/u2/oradb/oradata/topprod/aud01.dbf	633	0	4.38	61.40	0	8.82	460	0	0	0.00
BLOBDBS1	/u2/oradb/oradata/topprod/blobdbs1.dbf	1	0	10.00	1.00	0	0.00	0	0	0	0.00
BLOBDBS1	/u2/oradb/oradata/topprod/blobdbs12.dbf	8	0	5.00	1.00	0	3.75	0	0	0	0.00
BLOBDBS1	/u2/oradb/oradata/topprod/blobdbs13.dbf	1	0	10.00	1.00	0	0.00	0	0	0	0.00
BLOBDBS1	/u2/oradb/oradata/topprod/blobdbs24.dbf	10,126	3	0.00	1.01	3	0.00	0	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-01.dbf	5,226	1	3.41	19.26	1	2.11	89,826	25	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-02.dbf	6,445	2	3.35	4.61	2	3.19	27	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-03.dbf	11,572	3	2.46	12.12	3	2.24	26,482	7	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-04.dbf	7,345	2	1.25	17.86	2	0.82	10,250	3	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-05.dbf	8,501	2	1.63	16.30	2	1.29	75	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-06.dbf	11,865	3	1.52	13.96	2	0.85	2,335	1	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-07.dbf	9,947	3	1.28	9.90	2	1.02	31	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-08.dbf	8,464	2	1.06	9.79	2	0.78	7	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-09.dbf	7,377	2	1.33	12.07	2	0.78	6	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-10.dbf	5,340	1	0.98	12.23	1	0.74	1	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-11.dbf	9,269	3	0.55	11.29	2	0.33	9	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-12.dbf	7,647	2	0.85	20.01	2	0.47	86,867	24	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-13.dbf	7,437	2	1.51	20.57	2	0.77	76,040	21	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-14.dbf	7,908	2	1.76	16.89	2	1.92	1,391	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-15.dbf	11,268	3	0.22	12.67	3	0.14	1,942	1	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-16.dbf	4,442	1	1.54	21.18	1	0.39	59,911	17	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-17.dbf	4,199	1	0.50	10.04	1	0.23	87	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-18.dbf	5,227	1	1.58	8.52	1	1.39	22	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-19.dbf	4,957	1	0.77	9.25	1	0.62	9	0	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-20.dbf	14,633	4	0.53	11.32	3	0.48	59,442	16	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-21.dbf	6,372	2	0.72	22.45	1	0.09	62,042	17	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-22.dbf	5,855	2	0.50	23.93	1	0.27	57,571	16	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-23.dbf	11,081	3	0.67	21.20	2	0.24	65,079	18	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-24.dbf	8,160	2	0.55	20.37	1	0.46	86,954	24	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-25.dbf	10,058	3	0.99	17.78	2	0.30	109,836	30	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-26.dbf	8,271	2	0.80	34.07	1	0.44	168,504	47	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-27.dbf	9,102	3	1.56	22.15	2	0.31	137,991	38	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-28.dbf	4,372	1	2.85	34.60	1	2.25	122,604	34	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-29.dbf	3,809	1	1.95	43.20	1	0.10	129,048	36	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-30.dbf	1,152	0	1.54	74.66	0	0.93	73,236	20	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-31.dbf	6,289	2	1.44	47.56	1	0.82	189,038	52	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-32.dbf	7,357	2	2.29	41.10	1	0.73	231,532	64	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-33.dbf	4,915	1	1.76	52.17	1	0.26	259,151	72	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-34.dbf	5,425	2	4.79	55.89	1	0.92	344,269	95	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-35.dbf	5,462	2	3.67	45.54	1	0.58	290,933	81	0	0.00
DBS1	/u2/oradb/oradata2/topprod/dbs1-34.dbf	4,740	1	1.72	58.56	1	0.60	292,631	81	0	0.00
RPTDBS1	/u2/oradb/oradata/topprod/rptdbs1-01.dbf	44	0	3.18	1.00	0	3.41	96	0	0	0.00
RPTDBS1	/u2/oradb/oradata/topprod/rptdbs1-02.dbf	17	0	0.59	1.00	0	1.18	19	0	0	0.00
SYSAUX	/u2/oradb/oradata/topprod/sysaux01.dbf	6,332	2	3.18	20.60	1	2.05	913	0	0	0.00
SYSTEM	/u2/oradb/oradata/topprod/system01.dbf	52,943	15	1.47	1.46	14	1.32	5,125	1	55	0.73
TEMP	/u2/oradb/oradata/topprod/temp01.dbf	17,045	5	0.01	20.32	0	3.10	13,556	4	0
TEMPTABS	/u2/oradb/oradata/topprod/temptabs.dbf	201	0	2.04	1.00	0	2.04	533	0	0	0.00
UNDOTBS1	/u2/oradb/oradata/topprod/undotbs01.dbf	513,264	142	0.08	1.00	142	0.08	1,392,985	386	22	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	202,712	99	330,292,468	3,629,725	5,383,133	24122	47	76

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 6,116,427

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	4,041,575	0	0	181	2,992

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	119	30	2719	455204	2488320	2488320	5778469		80212
E	137	40	6170	597883	2488320	2488320	4958915		68606

Back to Advisory Statistics
Back to Top

MTTR Advisory

Only rows at end snap are displayed
Estimated Writes and I/Os are in thousands

Size for Est (s)	Dirty Limit	Est Cache Writes	Est Cache Write Fctr	Est Total Writes	Est Total Write Fctr
13	1,860	66,592	2.68	72,435	2.36
52	29,375	26,607	1.07	32,449	1.06
92	57,463	25,292	1.02	31,135	1.02
132	85,551	24,907	1.00	30,750	1.00
172	113,478	24,823	1.00	30,666	1.00

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	160	0.10	20	9.22	2,221,575	1	796178.00
D	320	0.19	39	6.98	1,681,767	1	587730.00
D	480	0.29	59	5.26	1,267,640	1	427814.00
D	640	0.39	79	3.97	955,381	1	307234.00
D	800	0.49	98	3.01	724,928	1	218244.00
D	960	0.58	118	2.32	557,840	1	153723.00
D	1,120	0.68	138	1.82	438,559	1	107662.00
D	1,280	0.78	158	1.47	353,725	1	74903.00
D	1,440	0.87	177	1.22	293,466	1	51634.00
D	1,600	0.97	197	1.04	250,384	1	34998.00
D	1,648	1.00	203	1.00	240,865	1	31322.00
D	1,760	1.07	217	0.91	218,658	1	22747.00
D	1,920	1.17	236	0.82	196,367	1	14139.00
D	2,080	1.26	256	0.74	178,997	1	7432.00
D	2,240	1.36	276	0.69	165,265	1	5909.00
D	2,400	1.46	295	0.64	153,927	1	5905.00
D	2,560	1.55	315	0.60	144,755	1	5902.00
D	2,720	1.65	335	0.57	137,145	1	5900.00
D	2,880	1.75	354	0.54	130,664	1	5898.00
D	3,040	1.84	374	0.52	124,708	1	5896.00
D	3,200	1.94	394	0.49	118,974	1	5894.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
97.95	291,012	6,088

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	1-Pass Execs
2K	4K	394,973	394,973	0
64K	128K	2,117	2,117	0
128K	256K	113	113	0
256K	512K	8	8	0
512K	1024K	21,447	21,447	0
1M	2M	178,754	178,754	0
2M	4M	176	176	0
4M	8M	150	150	0
8M	16M	152	152	0
16M	32M	112	112	0
64M	128M	4	4	0
128M	256M	44	44	0
256M	512M	8	0	8
512M	1024M	4	0	4
1G	2G	2	2	0

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
268	0.13	167,333,389.36	5,189,998.71	97.00	32,121	17,755,111,092
536	0.25	167,333,389.36	1,098,183.45	99.00	1,606	17,334,005,089
1,072	0.50	167,333,389.36	852,931.03	99.00	0	17,308,765,125
1,608	0.75	167,333,389.36	851,568.63	99.00	0	17,308,624,915
2,144	1.00	167,333,389.36	12,099.07	100.00	0	17,222,231,555
2,573	1.20	167,333,389.36	5,977.57	100.00	0	17,221,601,565
3,002	1.40	167,333,389.36	5,977.57	100.00	0	17,221,601,565
3,430	1.60	167,333,389.36	5,977.57	100.00	0	17,221,601,565
3,859	1.80	167,333,389.36	5,977.57	100.00	0	17,221,601,565
4,288	2.00	167,333,389.36	5,977.57	100.00	0	17,221,601,565
6,432	3.00	167,333,389.36	5,977.57	100.00	0	17,221,601,565
8,576	4.00	167,333,389.36	5,977.57	100.00	0	17,221,601,565
12,864	6.00	167,333,389.36	5,977.57	100.00	0	17,221,601,565
17,152	8.00	167,333,389.36	5,977.57	100.00	0	17,221,601,565

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)
1,568	0.70	179	26,135	4,470,029	0.56	3,548,488	90.50	600,521
1,792	0.80	402	55,010	6,157,719	0.77	1,860,798	47.46	706,542
2,016	0.90	626	84,611	7,450,418	0.93	568,099	14.49	778,771
2,080	0.93	689	91,885	7,712,661	0.97	305,856	7.80	792,208
2,096	0.94	705	93,916	7,749,669	0.97	268,848	6.86	793,465
2,112	0.94	721	95,626	7,781,179	0.98	237,338	6.05	794,433
2,128	0.95	737	97,784	7,812,703	0.98	205,814	5.25	795,395
2,144	0.96	753	100,013	7,844,211	0.98	174,306	4.45	796,348
2,160	0.96	769	102,310	7,875,812	0.99	142,705	3.64	797,317
2,176	0.97	784	104,552	7,905,728	0.99	112,789	2.88	798,153
2,192	0.98	800	106,629	7,924,063	0.99	94,454	2.41	798,763
2,208	0.99	816	108,463	7,942,495	1.00	76,022	1.94	799,367
2,224	0.99	832	110,685	7,960,864	1.00	57,653	1.47	799,969
2,240	1.00	848	112,461	7,979,309	1.00	39,208	1.00	800,585
2,256	1.01	864	113,587	7,979,367	1.00	39,150	1.00	800,611
2,272	1.01	880	114,738	7,979,392	1.00	39,125	1.00	800,625
2,288	1.02	896	115,852	7,979,415	1.00	39,102	1.00	800,636
2,304	1.03	912	116,954	7,979,436	1.00	39,081	1.00	800,648
2,320	1.04	928	118,059	7,979,461	1.00	39,056	1.00	800,658
2,336	1.04	944	119,106	7,979,488	1.00	39,029	1.00	800,676
2,352	1.05	960	120,163	7,979,511	1.00	39,006	0.99	800,688
2,368	1.06	975	121,278	7,979,530	1.00	38,987	0.99	800,699
2,384	1.06	991	122,344	7,979,548	1.00	38,969	0.99	800,710
2,464	1.10	1,070	128,510	7,979,631	1.00	38,886	0.99	800,753
2,688	1.20	1,293	142,775	7,979,834	1.00	38,683	0.99	800,851
2,912	1.30	1,513	159,125	7,980,009	1.00	38,508	0.98	800,974
3,136	1.40	1,737	177,262	7,980,171	1.00	38,346	0.98	801,047
3,360	1.50	1,961	194,660	7,980,324	1.00	38,193	0.97	801,117
3,584	1.60	2,185	213,858	7,980,505	1.00	38,012	0.97	801,201
3,808	1.70	2,408	230,867	7,980,655	1.00	37,862	0.97	801,283
4,032	1.80	2,631	247,054	7,980,805	1.00	37,712	0.96	801,352
4,256	1.90	2,853	257,689	7,980,954	1.00	37,563	0.96	801,418
4,480	2.00	3,076	268,498	7,981,088	1.00	37,429	0.95	801,476

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,000	0.50	4,945,719	1,852,548,312
3,000	0.75	1,116,601	1,052,412,382
4,000	1.00	829,262	240,859,702
5,000	1.25	811,682	182,041,763
6,000	1.50	811,018	169,565,230
7,000	1.75	810,438	159,449,123
8,000	2.00	810,438	131,051,764

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	1.00	0	0	0	0
32	2.00	0	0	0	0
48	3.00	0	0	0	0
64	4.00	0	0	0	0
80	5.00	0	0	0	0
96	6.00	0	0	0	0
112	7.00	0	0	0	0
128	8.00	0	0	0	0
144	9.00	0	0	0	0
160	10.00	0	0	0	0
176	11.00	0	0	0	0
192	12.00	0	0	0	0
208	13.00	0	0	0	0
224	14.00	0	0	0	0
240	15.00	0	0	0	0
256	16.00	0	0	0	0
272	17.00	0	0	0	0
288	18.00	0	0	0	0
304	19.00	0	0	0	0
320	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	Avg Time (ms)
data block	55	1
undo header	16	0
undo block	6	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	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse)	630	630	0	63	494	7,841.59
KO-Multiple Object Checkpoint (fast object checkpoint)	430	430	0	43	319	7,420.23
CR-Reuse Block Range (block range reuse ckpt)	2,784	2,784	0	108	206	1,909.72
CF-Controlfile Transaction	6,623	6,612	11	23	5	204.35

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	1,713.00	59,850	1,959	6	1440/1440	0/0	0/0/0/38/79912/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
04-8月 19:55	375,413	10,258	1,796	6	1,440	0/0	0/0/0/38/79912/0
04-8月 19:45	561,374	2,100	1,959	5	1,440	0/0	0/0/0/0/0/0
04-8月 19:35	503,632	935	1,892	5	1,440	0/0	0/0/0/0/0/0
04-8月 19:25	234,219	17,740	1,881	6	1,440	0/0	0/0/0/0/0/0
04-8月 19:15	16,586	8,129	1,857	5	1,440	0/0	0/0/0/0/0/0
04-8月 19:05	21,772	20,688	1,256	6	1,440	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0	0
ASM db client latch	3,135	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	127	0.00		0	0
AWR Alerted Metric Element list	32,154	0.00		0	0
Change Notification Hash table latch	1,198	0.00		0	0
Consistent RBA	95,136	0.02	0.12	0	0
DML lock allocation	277,632	0.00		0	0
Event Group Locks	581	0.00		0	0
FAL Queue	354	0.00		0	0
FIB s.o chain latch	1,134	0.00		0	0
FOB s.o list latch	6,327	0.00		0	0
File State Object Pool Parent Latch	1	0.00		0	0
I/O Staticstics latch	1	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	1,068,476	0.00	1.00	1	8,725	0.00
JS Sh mem access	1	0.00		0	0
JS queue access latch	1	0.00		0	0
JS slv state obj latch	1	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	1	0.00		0	0
KJCT flow control latch	1	0.00		0	0
KMG MMAN ready and startup request latch	1,200	0.00		0	0
KTF sga latch	21	0.00		0	1,156	0.00
KWQMN job cache list latch	1	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	3	0.00		0	0
KWQS pqueue ctx latch	6	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	1	0.00		0	1,200	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	40	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	1,262	0.00		0	0
OS process allocation	7,817	0.00		0	0
OS process: request allocation	587	0.00		0	0
PL/SQL warning settings	14,632	0.00		0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	20,022	0.00		0	0
Reserved Space Latch	420	0.00		0	0
SGA IO buffer pool latch	36,843	0.00		0	130,197	0.00
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	121	0.00		0	1,169	0.00
SQL memory manager workarea list latch	1,630,312	0.00	0.00	0	0
Shared B-Tree	142	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
Undo Hint Latch	0			0	22	0.00
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	233,479	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	34,684	0.02	0.00	0	0
active service list	3,469	0.03	0.00	0	2,873	0.00
alert log latch	210	0.00		0	0
archive control	499	0.00		0	0
archive process latch	1,167	0.00		0	0
begin backup scn array	99,571	0.00		0	0
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	3,542,558	0.01	0.00	0	0
cache buffers chains	1,160,078,695	0.00	0.07	0	18,283,336	0.00
cache buffers lru chain	8,434,335	0.03	0.03	0	19,764,589	0.04
cache table scan latch	52,069	0.00		0	52,069	0.00
call allocation	5,512	0.05	0.67	0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	647	0.00		0	0
channel operations parent latch	26,308	0.00		0	0
checkpoint queue latch	8,303,468	0.00	0.05	0	5,304,767	0.00
client/application info	2,092	0.00		0	0
compile environment latch	290	0.00		0	0
corrupted undo seg latch	10,578,450	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	127	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	127	0.00		0	0
dml lock allocation	1,835	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	588	0.00		0	0
eighth spare latch - X parent	1	0.00		0	0
eleventh spare latch - children	1	0.00		0	0
enqueue freelist latch	1	0.00		0	1,253,730	0.00
enqueue hash chains	2,129,274	0.01	0.01	0	362	0.00
enqueues	2	0.00		0	0
fifteenth spare latch - children	1	0.00		0	0
file cache latch	4,767	0.00		0	0
first Audit Vault latch	274	0.00		0	0
flashback copy	1	0.00		0	0
fourteenth spare latch - children	1	0.00		0	0
fourth Audit Vault latch	1	0.00		0	0
gc element	1	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs partitioned table hash	1	0.00		0	0
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs resource freelist	1	0.00		0	0
gcs resource hash	1	0.00		0	0
gcs resource scan list	1	0.00		0	0
gcs resource validate list	1	0.00		0	0
gcs shadows freelist	1	0.00		0	0
ges domain table	1	0.00		0	0
ges enqueue table freelist	1	0.00		0	0
ges group table	1	0.00		0	0
ges process hash list	1	0.00		0	0
ges process parent latch	1	0.00		0	0
ges resource hash list	1	0.00		0	0
ges resource scan list	1	0.00		0	0
ges resource table freelist	1	0.00		0	0
ges value block free list	1	0.00		0	0
global KZLD latch for mem in SGA	274	0.00		0	0
global tx hash mapping	515,314	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	3,247	0.00		0	311,031	0.00
hash table modification latch	468	0.00		0	0
heartbeat check	1	0.00		0	0
internal temp table object number allocation latch	15	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	1	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	105	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kgnfs mount latch	1	0.00		0	0
kokc descriptor allocation latch	54	0.00		0	0
krbmrosl	96	0.00		0	0
ksfv messages	1	0.00		0	0
ksim group membership cache	1	0.00		0	0
kss move lock	33	0.00		0	0
ksuosstats global area	363	0.00		0	0
ksv allocation latch	199	0.00		0	0
ksv class latch	81	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	587	0.00		0	0
ktm global data	434	0.00		0	0
kwqbsn:qsga	131	0.00		0	0
lgwr LWN SCN	95,455	0.18	0.00	0	0
list of block allocation	100,059	0.00		0	0
loader state object freelist	1,090	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	13	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	2	0.00		0	0
logminer local	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	54	0.00		0	51	0.00
managed standby latch	249	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	1,495	0.00		0	0
messages	426,605	0.01	0.00	0	0
mostly latch-free SCN	99,257	2.19	0.01	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	199,330	0.00	0.00	0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	127	0.00		0	0
nineth spare latch - X parent	1	0.00		0	0
object queue header heap	220,964	0.00		0	26,328	0.00
object queue header operation	30,667,210	0.01	0.01	0	0
object stats modification	6,357	0.00		0	0
parallel query alloc buffer	473	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	2,678	0.00		0	0
parameter table management	4,563	0.00		0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	92,970	0.07	0.00	0	65,499	0.13
process allocation	603	0.00		0	290	0.00
process group creation	587	0.00		0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	529	0.00		0	0
query server freelists	1	0.00		0	0
queued dump request	12	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	404,181	1.61	0.04	0	161,100,591	0.01
redo copy	1	0.00		0	161,103,283	0.01
redo writing	326,389	0.00	0.00	0	0
reservation so alloc latch	210	0.00		0	0
resmgr group change latch	275	0.00		0	0
resmgr:active threads	588	0.00		0	0
resmgr:actses change group	291	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	587	0.00		0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	81	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	21,136,046	0.01	0.01	0	34,478	0.04
rules engine rule set statistics	100	0.00		0	0
second Audit Vault latch	1	0.00		0	0
sequence cache	25,098	0.00		0	0
session allocation	74,201	0.00		0	73,637	0.00
session idle bit	4,897,147	0.00	0.00	0	0
session queue latch	1	0.00		0	0
session state list latch	72	0.00		0	0
session switching	425	0.00		0	0
session timer	1,254	0.00		0	0
seventh spare latch - X parent	1	0.00		0	0
shared pool	5,455,681	0.01	0.32	0	21,117	0.08
shared pool sim alloc	1	0.00		0	0
shared pool simulator	373,731	0.00		0	0
sim partition latch	2	0.00		0	43,817	0.00
simulator hash latch	23,029,892	0.00	0.00	0	0
simulator lru latch	4,714,951	0.02	0.01	0	17,643,197	0.01
sixth spare latch - X parent	1	0.00		0	0
sort extent pool	3,439	0.00		0	0
space background state object latch	10	0.00		0	0
space background task latch	14,209	4.52	0.26	0	2,486	0.16
state object free list	12	0.00		0	0
statistics aggregation	336	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	118	0.00		0	0
tenth spare latch - X parent	1	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
thirteenth spare latch - children	1	0.00		0	0
threshold alerts latch	217	0.00		0	0
transaction allocation	6,615	0.00		0	0
transaction branch allocation	516,448	0.00	0.09	0	0
twelfth spare latch - children	1	0.00		0	0
twenty-fifth spare latch - S par	1	0.00		0	0
twenty-first spare latch - S par	1	0.00		0	0
twenty-fourth spare latch - S par	1	0.00		0	0
twenty-second spare latch - S par	1	0.00		0	0
twenty-third spare latch - S par	1	0.00		0	0
undo global data	5,116,758	0.00	0.00	0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0
write info latch	0			0	95,044	0.00

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
redo allocation	404,181	6,513	260	6,256
object queue header operation	30,667,210	4,350	24	4,326
cache buffers lru chain	8,434,335	2,336	68	2,270
mostly latch-free SCN	99,257	2,172	28	2,144
row cache objects	21,136,046	1,905	19	1,886
simulator lru latch	4,714,951	923	11	912
cache buffers chains	1,160,078,695	893	65	833
space background task latch	14,209	642	166	493
shared pool	5,455,681	448	143	316
checkpoint queue latch	8,303,468	404	21	383
enqueue hash chains	2,129,274	124	1	123
transaction branch allocation	516,448	23	2	21
Consistent RBA	95,136	17	2	15
call allocation	5,512	3	2	1
In memory undo latch	1,068,476	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlushMe	1	0
PC and Classifier lists for WLM	No latch	19	0
cache buffers chains	kcbgcur_2	36	10
cache buffers chains	kcbgtcr: fast path (cr pin)	13	32
cache buffers chains	kcbchg1: mod cr pin	12	8
cache buffers chains	kcbgtcr_2	3	2
cache buffers chains	kcbnew: new latch again	3	0
cache buffers chains	kcbzwb	3	1
cache buffers chains	kcbbxsv	2	0
cache buffers chains	kcbnlc	2	3
cache buffers chains	kcbzibmlt: multi-block read: nowait	2	0
cache buffers chains	kcbchg1: aux pin	1	1
cache buffers chains	kcbchg1: clear MS bit	1	5
cache buffers chains	kcbgtcr: fast path	1	1
cache buffers lru chain	kcbzgws	45	0
cache buffers lru chain	kcbbwlru	6	1
cache buffers lru chain	kcbzgb_1	6	1
cache buffers lru chain	kcbo_link_q	4	0
cache buffers lru chain	kcbzgb	3	25
cache buffers lru chain	kcbbic2	2	35
cache buffers lru chain	kcbzar: KSLNBEGIN	1	0
cache buffers lru chain	kcbzgm	1	0
call allocation	ksudlp: top call	1	0
call allocation	ksuxds	1	2
checkpoint queue latch	kcbbwdl: thread checkpoint queue	19	0
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	1	0
checkpoint queue latch	kcbkllrba: compute lowest lrba	1	1
enqueue hash chains	ksqrcl	1	0
lgwr LWN SCN	kcs023	26	0
mostly latch-free SCN	kcslcu3	2	28
mostly latch-free SCN	kcsnew_scn_rba	2	0
object queue header operation	kcbo_unlink_q	11	1
object queue header operation	kcbo_link_q	7	2
object queue header operation	kcbo_switch_cq	3	1
object queue header operation	kcbo_switch_mq_bg	3	14
object queue header operation	kcbo_switch_q_bg	3	13
object queue header operation	kcbo_sw_buf	2	0
object queue header operation	kcbo_write_q	2	0
redo allocation	kcrfw_redo_gen: redo allocation 1	253	0
redo allocation	kcrfw_redo_write: before write	4	30
redo allocation	kcrfw_redo_gen: redo allocation 2	3	0
row cache objects	kqrpre: find obj	7	16
row cache objects	kqreqd: reget	4	0
row cache objects	kqrcmt: while loop	1	0
row cache objects	kqreqd	1	2
shared pool	kghalo	130	32
shared pool	kghalp	4	22
shared pool	kghfrunp: clatch: nowait	4	0
shared pool	kghupr1	4	81
shared pool	kgh_heap_sizes	2	1
shared pool	kghfrunp: alloc: wait	2	0
shared pool	kghfrunp: clatch: wait	2	0
shared pool	kgh_next_free	1	0
simulator lru latch	kcbs_simulate: simulate set	11	0
space background task latch	ktsj_grab_task	147	166
transaction branch allocation	ksupuc	2	2

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kgllkdl1 85	4	0
Library Cache	kglhdgn2 106	3	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

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

Segments by Logical Reads

Total Logical Reads: 333,497,789
Captured Segments account for 69.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
NLPM01	DBS1	SFB_FILE	TABLE	49,378,416	14.81
NLPM170804	DBS1	TC_MST_FILE	TABLE	35,838,240	10.75
NLPM170804	DBS1	MST_FILE	TABLE	32,950,752	9.88
NLPM170804	DBS1	TC_MSH_FILE	TABLE	14,669,472	4.40
NLPM170804	DBS1	TC_MSS_FILE	TABLE	14,513,856	4.35

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 6,673,346
Captured Segments account for 54.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
NLPM170804	DBS1	TLF_FILE	TABLE	929,318	13.93
NLPM170804	DBS1	TC_MST_FILE	TABLE	827,655	12.40
NLPM170804	DBS1	TC_RVBC_FILE	TABLE	462,089	6.92
NLPM01	DBS1	OGB_FILE	TABLE	351,824	5.27
NLPM170804	DBS1	MST_FILE	TABLE	296,610	4.44

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 862,141
Captured Segments account for 14.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
NLPM01	DBS1	OGB_FILE	TABLE	54,991	6.38
NLPM170804	DBS1	TC_MSS_FILE	TABLE	17,117	1.99
NLPM170804	DBS1	TC_MST_FILE	TABLE	9,470	1.10
NLPM01	DBS1	IMA_FILE	TABLE	6,496	0.75
NLPM01	DBS1	OGA_FILE	TABLE	6,117	0.71

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 862,141
Captured Segments account for 14.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
NLPM01	DBS1	OGB_FILE	TABLE	54,991	6.38
NLPM170804	DBS1	TC_MSS_FILE	TABLE	17,117	1.99
NLPM170804	DBS1	TC_MST_FILE	TABLE	9,470	1.10
NLPM01	DBS1	IMA_FILE	TABLE	6,496	0.75
NLPM01	DBS1	OGA_FILE	TABLE	6,117	0.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,043,619
Captured Segments account for 40.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Direct Reads	%Total
NLPM170804	DBS1	TC_RVBC_FILE	TABLE	461,596	15.17
NLPM170804	DBS1	TC_MST_FILE	TABLE	459,420	15.09
NLPM01	DBS1	OGB_FILE	TABLE	299,264	9.83

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 6,116,427
Captured Segments account for 62.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
NLPM170804	DBS1	TC_MST_FILE	TABLE	689,947	11.28
NLPM170804	DBS1	TLF_FILE	TABLE	475,693	7.78
NLPM170804	DBS1	TC_MSS_FILE	TABLE	456,135	7.46
NLPM170804	DBS1	MST_FILE	TABLE	373,924	6.11
NLPM170804	DBS1	TLFC_FILE	TABLE	279,763	4.57

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 4,448,920
Captured Segments account for 59.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
NLPM170804	DBS1	TC_MST_FILE	TABLE	583,354	13.11
NLPM170804	DBS1	TC_MSS_FILE	TABLE	396,495	8.91
NLPM170804	DBS1	MST_FILE	TABLE	356,302	8.01
NLPM170804	DBS1	TLFC_FILE	TABLE	218,318	4.91
NLPM170804	DBS1	MSS_FILE	TABLE	199,336	4.48

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 733,294
Captured Segments account for 53.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Direct Writes	%Total
NLPM170804	DBS1	TIC_MST_03	INDEX	70,352	9.59
NLPM170804	DBS1	TC_RVBC03_INDEX	INDEX	61,158	8.34
NLPM170804	DBS1	TPC_MSS_PK	INDEX	50,755	6.92
NLPM170804	DBS1	TIC_MST_02	INDEX	45,466	6.20
NLPM170804	DBS1	TPC_RVBC_PK	INDEX	40,409	5.51

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 356,733
Captured Segments account for 99.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
NLPM01	DBS1	PMC_02	INDEX	178,213	49.96
NLPM01	DBS1	PMC_PK	INDEX	178,213	49.96
NLPM170804	DBS1	TLF_FILE	TABLE	11	0.00
NLPM170804	DBS1	TC_MSS_FILE	TABLE	5	0.00
NLPM170804	DBS1	TC_MST_FILE	TABLE	5	0.00

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
NLPM170804	DBS1	TC_MST_FILE	TABLE	50,041,264	24.29
NLPM170804	DBS1	MST_FILE	TABLE	48,543,520	23.57
NLPM170804	DBS1	TC_MSH_FILE	TABLE	20,424,848	9.92
NLPM170804	DBS1	TC_MSS_FILE	TABLE	19,874,560	9.65
NLPM170804	DBS1	MSS_FILE	TABLE	18,961,920	9.21

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	SEG$		TABLE	49	98.00
SYS	SYSTEM	I_HH_OBJ#_INTCOL#		INDEX	1	2.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	67	0.00	2	1
dc_constraints	4,907	50.56	4,907	1
dc_global_oids	82	0.00	0	26
dc_histogram_data	2,697	0.63	0	282
dc_histogram_defs	189,955	8.17	7,556	19,939
dc_object_grants	30,983	0.00	0	85
dc_objects	569,799	18.22	14,988	98,742
dc_profiles	843	0.00	0	2
dc_rollback_segments	9,440	0.00	0	89
dc_segments	296,276	32.04	2,394	70,692
dc_sequences	396	0.51	396	3
dc_table_scns	88	100.00	0	0
dc_tablespaces	4,382,321	0.00	0	12
dc_users	1,539,955	0.24	1	1,137
global database name	8,056	0.00	0	1
outstanding_alerts	62	0.00	0	10

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	823	0.97	0		0	0
BODY	77	14.29	36,525	0.04	2	0
CLUSTER	130	1.54	130	1.54	0	0
DBLINK	1,077	0.37	0		0	0
EDITION	289	0.00	563	0.00	0	0
INDEX	2,274	16.97	1,925	40.05	16	0
OBJECT ID	3,698	100.00	0		0	0
QUEUE	1	0.00	721	0.00	0	0
SCHEMA	115,989	0.00	0		0	0
SQL AREA	209,929	12.97	3,307,134	2.64	2,373	8,941
SQL AREA BUILD	26,871	92.18	0		0	0
SQL AREA STATS	29,423	93.00	29,423	93.00	0	0
TABLE/PROCEDURE	209,894	27.37	519,049	33.31	7,806	2
TRIGGER	26,220	0.00	26,220	0.00	0	0

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	1,648.00	1,648.00	1,552.00	3,120.00	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	2,144.00	2,144.00	2,144.00	2,144.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	4,000.00	4,000.00	4,000.00	4,000.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	16.00	16.00	16.00	64.00	SHR/DEF
large pool	32.00	32.00	32.00	32.00	STA/
shared pool	2,240.00	2,240.00	720.00	2,336.00	GRO/DEF
streams pool	16.00	16.00	16.00	16.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

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

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	316.83		3.23	5.49	28	32	98	98
B	Freeable	96.69	0.00	1.53	3.24	20		63	63
B	SQL	8.29	2.45	0.10	0.19	1	215	81	74
B	PL/SQL	4.13	1.77	0.04	0.16	1	1	98	98
E	Other	283.64		3.12	5.27	27	32	91	91
E	Freeable	104.06	0.00	1.55	3.51	21		67	67
E	SQL	8.12	2.34	0.11	0.19	1	38	74	66
E	PL/SQL	3.21	1.72	0.04	0.14	1	1	91	91

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,728,053,248
Fixed Size	2,265,224
Redo Buffers	19,292,160
Variable Size	4,664,070,008

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	16.00	16.00	0.00
large	CTWR dba buffer	2.36	2.36	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	17.86	17.86	0.00
large	krcc extent chunk	3.96	3.96	0.00
shared	ASH buffers	32.00	32.00	0.00
shared	KGH: NO ACCESS	95.52	95.52	0.00
shared	KGLDA	27.19		-100.00
shared	KGLH0	568.41	403.18	-29.07
shared	KGLHD	103.13	66.03	-35.97
shared	KGLS		238.20
shared	KQR L PO		97.61
shared	KQR M PO		44.54
shared	SQLA	479.88	478.33	-0.32
shared	SQLP	159.36		-100.00
shared	free memory	488.09	536.45	9.91
shared	kglsim heap	23.45	23.45	0.00
shared	kglsim object batch	38.51	38.51	0.00
streams	KTG hash buckets	0.63	0.63	0.00
streams	free memory	15.37	15.37	0.00
	buffer_cache	1,648.00	1,648.00	0.00
	fixed_sga	2.16	2.16	0.00
	log_buffer	18.40	18.40	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by CPU Time, descending

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	0710 17:16:07	0.09	0.32	0.00
QMON Coordinator	0710 17:15:57	0.06	0.00	0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

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

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(13069)	0	0			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(13069)	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

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

Subscriber/Queue	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE
NGERPDB_3872ITOPPROD(24)/SYS.ALERT_QUE	0.00	0.00	0.00
NGERPDB_3872_ITOPPROD(4)/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	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u2/oradb/admin/topprod/adump
audit_trail	DB
compatible	11.2.0.4.0
control_files	/u2/oradb/oradata/topprod/control01.ctl, /u2/oradb/oradata/topprod/control02.ctl
db_block_size	8192
db_domain
db_flash_cache_size	0
db_name	topprod
db_recovery_file_dest	/u2/archivelog
db_recovery_file_dest_size	214748364800
deferred_segment_creation	FALSE
diagnostic_dest	/u2/oradb
fast_start_mttr_target	3600
log_archive_dest
log_checkpoints_to_alert	TRUE
memory_target	6442450944
open_cursors	300
plsql_warnings	DISABLE:ALL
processes	900
remote_login_passwordfile	EXCLUSIVE
sessions	1376
undo_retention	86400
undo_tablespace	UNDOTBS1

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

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

Parameter Name	Begin value	End value (if different)
control_files	/u2/oradb/oradata/topprod/control01.ctl
control_files	/u2/oradb/oradata/topprod/control02.ctl

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	98.90	In-memory Sort %:	100.00
Library Hit %:	92.65	Soft Parse %:	89.26
Execute to Parse %:	84.05	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	64.93	% Non-Parse CPU:	95.97