Using the report name awrrpt_2_14644_14645.html AWR Report for DB: BABJDB, Inst: babjdb2, Snaps: 14644-14645

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

BABJDB 1344698690 babjdb2 2 13-Mar-13 02:03 11.2.0.1.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
BABJDB	1344698690	babjdb2	2	13-Mar-13 02:03	11.2.0.1.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

db02 AIX-Based Systems (64-bit) 16 8 90.25

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

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 14644 14-Mar-13 07:00:18 202 1.6

End Snap: 14645 14-Mar-13 08:00:52 205 1.7

Elapsed: 60.57 (mins)

DB Time: 235.09 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	14644	14-Mar-13 07:00:18	202	1.6
End Snap:	14645	14-Mar-13 08:00:52	205	1.7
Elapsed:		60.57 (mins)
DB Time:		235.09 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 20,096M 20,096M Std Block Size: 8K

Shared Pool Size: 3,456M 3,456M Log Buffer: 90,864K

	Begin	End
Buffer Cache:	20,096M	20,096M	Std Block Size:	8K
Shared Pool Size:	3,456M	3,456M	Log Buffer:	90,864K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 3.9 0.1 0.00 0.00

DB CPU(s): 0.6 0.0 0.00 0.00

Redo size: 3,986,898.4 53,651.0

Logical reads: 30,274.0 407.4

Block changes: 14,727.3 198.2

Physical reads: 84.1 1.1

Physical writes: 143.9 1.9

User calls: 1,817.2 24.5

Parses: 1,640.6 22.1

Hard parses: 0.3 0.0

W/A MB processed: 0.1 0.0

Logons: 0.2 0.0

Executes: 1,651.3 22.2

Rollbacks: 28.3 0.4

Transactions: 74.3

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	3.9	0.1	0.00	0.00
DB CPU(s):	0.6	0.0	0.00	0.00
Redo size:	3,986,898.4	53,651.0
Logical reads:	30,274.0	407.4
Block changes:	14,727.3	198.2
Physical reads:	84.1	1.1
Physical writes:	143.9	1.9
User calls:	1,817.2	24.5
Parses:	1,640.6	22.1
Hard parses:	0.3	0.0
W/A MB processed:	0.1	0.0
Logons:	0.2	0.0
Executes:	1,651.3	22.2
Rollbacks:	28.3	0.4
Transactions:	74.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 98.69 Redo NoWait %: 99.97

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

Library Hit %: 99.98 Soft Parse %: 99.98

Execute to Parse %: 0.65 Latch Hit %: 98.86

Parse CPU to Parse Elapsd %: 17.41 % Non-Parse CPU: 99.19

Shared Pool Statistics

Begin End

Memory Usage %: 62.16 62.74

% SQL with executions>1: 94.08 95.61

% Memory for SQL w/exec>1: 94.22 94.37

	Begin	End
Memory Usage %:	62.16	62.74
% SQL with executions>1:	94.08	95.61
% Memory for SQL w/exec>1:	94.22	94.37

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
enq: TX - index contention	47,197	3,409	72	24.17	Concurrency
DB CPU		2,137		15.15
gc buffer busy acquire	251,234	2,134	8	15.13	Cluster
gc buffer busy release	115,850	1,658	14	11.75	Cluster
buffer busy waits	845,541	925	1	6.56	Concurrency

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

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

0.52 2.22 4.4 1.6 0.5 93.9

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.52	2.22	4.4	1.6	0.5	93.9

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

4.2 69.3 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 92,416.0 92,416.0

SGA use (MB): 24,064.0 24,064.0

PGA use (MB): 836.6 845.6

% Host Mem used for SGA+PGA: 26.94 26.95

	Begin	End
Host Mem (MB):	92,416.0	92,416.0
SGA use (MB):	24,064.0	24,064.0
PGA use (MB):	836.6	845.6
% Host Mem used for SGA+PGA:	26.94	26.95

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 236.68 3.18

Global Cache blocks served: 224.14 3.02

GCS/GES messages received: 639.21 8.60

GCS/GES messages sent: 617.20 8.31

DBWR Fusion writes: 17.58 0.24

Estd Interconnect traffic (KB) 3,931.92

	Per Second	Per Transaction
Global Cache blocks received:	236.68	3.18
Global Cache blocks served:	224.14	3.02
GCS/GES messages received:	639.21	8.60
GCS/GES messages sent:	617.20	8.31
DBWR Fusion writes:	17.58	0.24
Estd Interconnect traffic (KB)	3,931.92

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 98.94

Buffer access - remote cache %: 0.78

Buffer access - disk %: 0.28

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.5

Avg global cache cr block receive time (ms): 0.9

Avg global cache current block receive time (ms): 1.7

Avg global cache cr block build time (ms): 0.0

Avg global cache cr block send time (ms): 0.0

Global cache log flushes for cr blocks served %: 12.9

Avg global cache cr block flush time (ms): 2.1

Avg global cache current block pin time (ms): 0.4

Avg global cache current block send time (ms): 0.0

Global cache log flushes for current blocks served %: 12.1

Avg global cache current block flush time (ms): 1.6

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

Avg message sent queue time on ksxp (ms): 0.6

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 74.60

% of indirect sent messages: 24.94

% of flow controlled messages: 0.47

Cluster Interconnect

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
en2	192.168.2.2	N	Oracle Cluster Repository

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	13,118.17	93.00
DB CPU	2,137.49	15.15
sequence load elapsed time	482.44	3.42
parse time elapsed	112.52	0.80
hard parse elapsed time	6.91	0.05
PL/SQL execution elapsed time	4.19	0.03
hard parse (sharing criteria) elapsed time	0.46	0.00
connection management call elapsed time	0.21	0.00
PL/SQL compilation elapsed time	0.05	0.00
repeated bind elapsed time	0.01	0.00
DB time	14,105.47
background elapsed time	647.85
background cpu time	327.20

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	22,102
AVG_IDLE_TIME	342,645
AVG_IOWAIT_TIME	1,724
AVG_SYS_TIME	5,891
AVG_USER_TIME	16,088
BUSY_TIME	355,620
IDLE_TIME	5,484,477
IOWAIT_TIME	29,087
SYS_TIME	96,199
USER_TIME	259,421
LOAD	1	2
OS_CPU_WAIT_TIME	612,300
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	96,905,199,616
NUM_CPUS	16
NUM_CPU_CORES	8
GLOBAL_RECEIVE_SIZE_MAX	1,500,000
GLOBAL_SEND_SIZE_MAX	1,500,000
TCP_RECEIVE_SIZE_DEFAULT	16,384
TCP_RECEIVE_SIZE_MAX	9,223,372,036,854,775,807
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	9,223,372,036,854,775,807
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
14-Mar 07:00:18	0.52
14-Mar 08:00:52	2.22	6.09	4.44	1.65	93.91	0.50

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 98.7% of Total DB time 14,105.47 (s)
Total FG Wait Time: 11,790.23 (s) DB CPU time: 2,137.49 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Cluster	1,397,565	0	5,276	4	37.40
Concurrency	1,116,554	0	4,708	4	33.38
DB CPU			2,137		15.15
Configuration	9,433	2	872	92	6.18
User I/O	213,086	0	419	2	2.97
Commit	187,890	0	349	2	2.47
Application	37,485	0	90	2	0.64
Network	3,513,852	0	59	0	0.42
Other	1,099,640	4	16	0	0.11
System I/O	4,292	0	2	0	0.01
Administrative	1	100	0	100	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: TX - index contention	47,197	0	3,409	72	0.17	24.17
gc buffer busy acquire	251,234	1	2,134	8	0.93	15.13
gc buffer busy release	115,850	0	1,658	14	0.43	11.75
buffer busy waits	845,541	0	925	1	3.13	6.56
gc current block busy	100,245	0	819	8	0.37	5.80
log file switch (checkpoint incomplete)	362	0	395	1092	0.00	2.80
enq: SQ - contention	6,718	0	392	58	0.02	2.78
gc current block 2-way	606,752	0	355	1	2.25	2.52
log file sync	187,890	0	349	2	0.70	2.47
db file sequential read	189,924	0	333	2	0.70	2.36
library cache: mutex X	10,849	0	286	26	0.04	2.03
gc current grant busy	51,570	0	116	2	0.19	0.83
SQL*Net break/reset to client	37,420	0	78	2	0.14	0.55
gc cr block busy	38,887	0	62	2	0.14	0.44
enq: TX - allocate ITL entry	1,577	0	62	39	0.01	0.44
SQL*Net more data from client	62,508	0	55	1	0.23	0.39
db file parallel read	12,540	0	55	4	0.05	0.39
gc cr block 2-way	107,770	0	44	0	0.40	0.31
latch: cache buffers chains	181,574	0	31	0	0.67	0.22
row cache lock	24,169	0	31	1	0.09	0.22
read by other session	9,285	0	29	3	0.03	0.21
gc current split	4,286	0	24	6	0.02	0.17
log file switch completion	542	0	21	39	0.00	0.15
gc current retry	837	0	19	23	0.00	0.14
gc cr disk read	41,836	0	18	0	0.15	0.13
cursor: pin S	1,083	0	14	13	0.00	0.10
enq: TX - row lock contention	54	0	12	228	0.00	0.09
gc cr grant 2-way	27,235	0	12	0	0.10	0.09
library cache load lock	160	0	9	55	0.00	0.06
gc cr multi block request	23,501	0	5	0	0.09	0.03
SQL*Net message to client	3,446,620	0	4	0	12.76	0.03
gc current grant 2-way	8,677	0	4	0	0.03	0.03
gc current block congested	529	0	4	7	0.00	0.03
latch: ges resource hash list	10,828	0	3	0	0.04	0.02
db file scattered read	259	0	2	8	0.00	0.01
gc current multi block request	18,080	0	2	0	0.07	0.01
control file sequential read	4,292	0	2	0	0.02	0.01
undo segment extension	172	98	2	10	0.00	0.01
enq: FB - contention	2,649	0	2	1	0.01	0.01
DFS lock handle	1,031	1	1	1	0.00	0.01
enq: TX - contention	157	0	1	9	0.00	0.01
cr request retry	137	97	1	9	0.00	0.01
latch: row cache objects	3,770	0	1	0	0.01	0.01
buffer deadlock	41,374	100	1	0	0.15	0.01
IPC send completion sync	1,713	0	1	1	0.01	0.01
latch: redo allocation	2,907	0	1	0	0.01	0.01
global enqueue expand wait	106	98	1	10	0.00	0.01
ges message buffer allocation	1,026,737	0	1	0	3.80	0.01
library cache pin	1,627	0	1	1	0.01	0.01
cursor: pin S wait on X	19	0	0	25	0.00	0.00
library cache lock	560	4	0	1	0.00	0.00
enq: HW - contention	62	0	0	7	0.00	0.00
enq: PS - contention	438	1	0	1	0.00	0.00
wait list latch free	32	0	0	10	0.00	0.00
gc cr block congested	94	0	0	3	0.00	0.00
PX Deq: Slave Session Stats	243	0	0	1	0.00	0.00
latch free	941	0	0	0	0.00	0.00
SQL*Net more data to client	4,724	0	0	0	0.02	0.00
JS kgl get object wait	1	100	0	100	0.00	0.00
Disk file operations I/O	1,078	0	0	0	0.00	0.00
enq: TT - contention	104	0	0	1	0.00	0.00
enq: JQ - contention	47	100	0	1	0.00	0.00
gc current grant congested	11	0	0	5	0.00	0.00
latch: cache buffers lru chain	68	0	0	1	0.00	0.00
latch: gc element	1,012	0	0	0	0.00	0.00
gc cr failure	145	0	0	0	0.00	0.00
lock deadlock retry	2,329	100	0	0	0.01	0.00
latch: enqueue hash chains	92	0	0	0	0.00	0.00
PX Deq: reap credit	4,320	100	0	0	0.02	0.00
gc cr grant congested	26	0	0	1	0.00	0.00
lock escalate retry	773	100	0	0	0.00	0.00
KJC: Wait for msg sends to complete	1,069	0	0	0	0.00	0.00
reliable message	20	0	0	1	0.00	0.00
latch: object queue header operation	87	0	0	0	0.00	0.00
latch: undo global data	7	0	0	1	0.00	0.00
PX Deq: Signal ACK RSG	10	50	0	1	0.00	0.00
enq: TM - contention	8	0	0	0	0.00	0.00
rdbms ipc reply	30	0	0	0	0.00	0.00
enq: UL - contention	3	67	0	0	0.00	0.00
enq: JS - job run lock - synchronize	3	100	0	0	0.00	0.00
SQL*Net message from client	3,446,616	0	787,835	229	12.76
jobq slave wait	7,687	100	3,842	500	0.03
PX Deq: Execution Msg	2,526	31	7	3	0.01
PX Deq: Join ACK	15	33	0	2	0.00
PX Deq: Execute Reply	15	33	0	2	0.00
PX Deq: Parse Reply	15	33	0	1	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	232,833	0	216	1	0.86	33.41
gcs log flush sync	319,672	1	131	0	1.18	20.30
os thread startup	142	0	21	150	0.00	3.28
db file parallel write	6,639	0	20	3	0.02	3.03
control file sequential read	27,221	0	10	0	0.10	1.61
reliable message	546	1	4	7	0.00	0.60
db file sequential read	1,129	0	4	3	0.00	0.56
ges lms sync during dynamic remastering and reconfig	48	100	3	63	0.00	0.47
DFS lock handle	3,790	57	2	0	0.01	0.28
gc cr block 2-way	3,929	0	2	0	0.01	0.26
control file parallel write	2,691	0	2	1	0.01	0.24
enq: WF - contention	13	0	1	82	0.00	0.16
LGWR wait for redo copy	18,717	0	1	0	0.07	0.15
ksxr poll remote instances	82,448	100	1	0	0.31	0.12
ges message buffer allocation	361,732	0	0	0	1.34	0.07
latch: cache buffers chains	2,806	0	0	0	0.01	0.06
CGS wait for IPC msg	31,711	100	0	0	0.12	0.04
enq: CF - contention	166	83	0	1	0.00	0.04
enq: CR - block range reuse ckpt	502	0	0	0	0.00	0.04
ASM file metadata operation	1,060	0	0	0	0.00	0.03
row cache lock	287	0	0	0	0.00	0.02
enq: TM - contention	8	38	0	15	0.00	0.02
gc current block 2-way	305	0	0	0	0.00	0.02
gc cr block busy	58	0	0	2	0.00	0.02
latch: redo allocation	266	0	0	0	0.00	0.01
gc cr grant 2-way	350	0	0	0	0.00	0.01
log file sequential read	106	0	0	1	0.00	0.01
gc object scan	11,110	100	0	0	0.04	0.01
library cache pin	180	0	0	0	0.00	0.01
direct path read	7	0	0	9	0.00	0.01
log file single write	106	0	0	1	0.00	0.01
wait for scn ack	18	0	0	3	0.00	0.01
latch: gc element	1,402	0	0	0	0.01	0.01
library cache lock	150	1	0	0	0.00	0.01
kfk: async disk IO	1,225	0	0	0	0.00	0.01
ADR block file write	5	0	0	9	0.00	0.01
gc current grant busy	99	0	0	0	0.00	0.01
PX Deq: reap credit	5,219	100	0	0	0.02	0.01
gc current grant 2-way	131	0	0	0	0.00	0.01
CSS initialization	2	0	0	16	0.00	0.01
direct path write	76	0	0	0	0.00	0.01
rdbms ipc reply	144	0	0	0	0.00	0.00
enq: US - contention	56	0	0	1	0.00	0.00
latch: ges resource hash list	266	0	0	0	0.00	0.00
latch: object queue header operation	180	0	0	0	0.00	0.00
enq: PS - contention	18	33	0	1	0.00	0.00
ADR block file read	13	0	0	2	0.00	0.00
buffer busy waits	127	0	0	0	0.00	0.00
Disk file operations I/O	570	0	0	0	0.00	0.00
latch: cache buffers lru chain	18	0	0	1	0.00	0.00
latch free	42	0	0	0	0.00	0.00
enq: TT - contention	37	68	0	0	0.00	0.00
undo segment extension	2	100	0	5	0.00	0.00
PX Deq: Signal ACK EXT	2	0	0	4	0.00	0.00
enq: HW - contention	18	0	0	0	0.00	0.00
CSS operation: action	4	0	0	2	0.00	0.00
ges DFS hang analysis phase 2 acks	1	0	0	7	0.00	0.00
enq: TA - contention	11	0	0	1	0.00	0.00
PX Deq: Signal ACK RSG	24	50	0	0	0.00	0.00
enq: FB - contention	14	0	0	0	0.00	0.00
IPC send completion sync	17	0	0	0	0.00	0.00
gc current multi block request	57	0	0	0	0.00	0.00
PX Deq: Slave Session Stats	12	0	0	0	0.00	0.00
gc current block busy	2	0	0	1	0.00	0.00
enq: KO - fast object checkpoint	3	0	0	1	0.00	0.00
CSS operation: query	6	0	0	0	0.00	0.00
global enqueue expand wait	2	0	0	1	0.00	0.00
gc cr multi block request	5	0	0	0	0.00	0.00
db file scattered read	5	0	0	0	0.00	0.00
ges inquiry response	2	0	0	1	0.00	0.00
latch: gcs resource hash	14	0	0	0	0.00	0.00
rdbms ipc message	406,292	14	72,268	178	1.50
PX Idle Wait	4,547	90	10,892	2395	0.02
wait for unread message on broadcast channel	7,270	100	7,268	1000	0.03
DIAG idle wait	203,013	96	7,248	36	0.75
gcs remote message	1,856,833	6	7,036	4	6.88
dispatcher timer	61	100	3,660	60001	0.00
ASM background timer	727	0	3,635	4999	0.00
PING	1,472	20	3,633	2468	0.01
Space Manager: slave idle wait	727	100	3,633	4997	0.00
pmon timer	1,369	88	3,632	2653	0.01
shared server idle wait	121	100	3,630	30000	0.00
heartbeat monitor sleep	726	100	3,630	5000	0.00
ges remote message	135,772	23	3,624	27	0.50
Streams AQ: qmn coordinator idle wait	252	50	3,622	14374	0.00
Streams AQ: qmn slave idle wait	126	0	3,622	28749	0.00
smon timer	116	9	3,508	30242	0.00
class slave wait	122	0	1,202	9853	0.00
KSV master wait	2,322	94	0	0	0.01
SQL*Net message from client	72	0	0	2	0.00
PX Deq: Join ACK	30	40	0	1	0.00
PX Deq: Parse Reply	27	37	0	1	0.00
PX Deq: Execute Reply	21	38	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	260	100	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	13	61.5		23.1	15.4
ADR block file write	5			20.0	20.0	60.0
ADR file lock	6	100.0
ASM file metadata operation	1060	99.7	.2					.1
CGS wait for IPC msg	31.7K	100.0	.0
CSS initialization	2	50.0						50.0
CSS operation: action	4	25.0	25.0	50.0
CSS operation: query	6	83.3	16.7
DFS lock handle	4821	90.7	6.3	1.3	1.0	.7	.1	.0
Disk file operations I/O	1648	98.2	1.6	.2
IPC send completion sync	1730	92.1	4.0	2.4	1.1	.5
JS kgl get object wait	1							100.0
KJC: Wait for msg sends to complete	1084	100.0
LGWR wait for redo copy	18.7K	99.5	.3	.1	.0	.0	.0	.0
PX Deq: Signal ACK EXT	5	80.0				20.0
PX Deq: Signal ACK RSG	34	88.2	8.8	2.9
PX Deq: Slave Session Stats	255	85.9	4.3	1.6	4.7	2.7	.8
PX Deq: reap credit	9539	100.0		.0
SQL*Net break/reset to client	37.4K	77.5	7.1	5.8	4.3	2.6	1.5	1.1
SQL*Net message to client	3449.5K	100.0	.0
SQL*Net more data from client	62.6K	95.5	1.2	.9	.7	.6	.5	.5
SQL*Net more data to client	4818	99.9	.1	.0
asynch descriptor resize	1084	100.0
buffer busy waits	845.6K	88.5	4.6	3.0	2.1	1.1	.3	.5	.0
buffer deadlock	41.4K	99.9	.1	.0	.0	.0
control file parallel write	2691	87.7	10.9	1.0	.2	.1	.1
control file sequential read	31.5K	94.3	5.1	.4	.1	.1	.0	.0
cr request retry	137	5.8				94.2
cursor: pin S	1083	84.9	.9	1.8	.2	1.8	1.4	9.0
cursor: pin S wait on X	19					78.9	10.5	10.5
db file parallel read	12.5K	60.0	2.2	2.5	14.6	15.6	4.0	1.1
db file parallel write	6644	49.6	19.7	10.9	8.5	8.0	3.0	.1
db file scattered read	264	51.5	6.8	1.9	9.5	10.6	14.8	4.9
db file sequential read	192K	75.8	4.3	3.2	11.3	4.7	.6	.1
direct path read	7	28.6	28.6			14.3	28.6
direct path write	76	88.2	10.5	1.3
enq: AE - lock	2	100.0
enq: AF - task serialization	1	100.0
enq: CF - contention	168	83.9	5.4	5.4	2.4	1.2	1.2	.6
enq: CR - block range reuse ckpt	502	97.0	2.0	.4	.4	.2
enq: FB - contention	2689	97.1	2.1	.6	.1	.1		.0
enq: HW - contention	107	80.4	6.5	5.6	3.7	.9		2.8
enq: JQ - contention	47	66.0	19.1	10.6	4.3
enq: JS - job run lock - synchronize	3	100.0
enq: KO - fast object checkpoint	3	100.0
enq: PS - contention	456	89.5	3.9	2.4	3.3	.9
enq: PW - flush prewarm buffers	1	100.0
enq: SQ - contention	6719	36.5	26.3	17.4	4.3	3.2	2.8	7.6	1.9
enq: TA - contention	11	100.0
enq: TM - contention	29	96.6						3.4
enq: TQ - DDL contention	1	100.0
enq: TT - contention	141	94.3	3.5	.7	1.4
enq: TX - allocate ITL entry	1577	29.4	6.2	4.9	7.5	11.1	9.6	31.2	.1
enq: TX - contention	157	9.6	24.8	31.8	15.9	3.2	5.1	9.6
enq: TX - index contention	47.1K	17.9	5.4	6.1	9.2	11.4	9.4	40.5	.2
enq: TX - row lock contention	54	11.1		1.9	3.7	20.4	25.9	29.6	7.4
enq: UL - contention	3	100.0
enq: US - contention	56	92.9	5.4	1.8
enq: WF - contention	13	76.9						23.1
gc buffer busy acquire	251.2K	37.5	22.2	16.0	10.2	4.8	2.6	6.7	.0
gc buffer busy release	115.8K	23.8	15.5	18.1	19.6	9.2	3.3	10.5	.0
gc cr block 2-way	111.3K	98.6	.8	.3	.2	.1	.0	.0
gc cr block busy	37.2K	29.2	55.1	11.2	3.4	.8	.3	.1
gc cr block congested	96	91.7	3.1				1.0	4.2
gc cr disk read	41.8K	95.2	1.9	1.6	1.0	.2	.0	.0
gc cr failure	138	100.0
gc cr grant 2-way	26.9K	95.4	2.0	1.5	.9	.2	.0	.0
gc cr grant congested	27	85.2	7.4		3.7	3.7
gc cr multi block request	23.5K	99.3	.6	.1	.0	.0	.0	.0
gc current block 2-way	600.5K	96.4	2.0	.9	.4	.1	.1	.1	.0
gc current block busy	99.4K	13.2	26.7	29.2	18.7	5.2	2.2	4.8	.0
gc current block congested	527	89.6	1.7	1.1	.9	.2	1.9	4.6
gc current grant 2-way	8848	98.7	.6	.3	.2	.2	.0	.1
gc current grant busy	50.3K	88.0	1.4	3.3	3.6	1.6	.6	1.5
gc current grant congested	11	90.9						9.1
gc current multi block request	18.2K	99.6	.3	.0	.0	.0	.0	.0
gc current retry	781	36.6	2.4	4.7	11.0	13.3	10.1	21.8
gc current split	4255	68.3	5.3	7.8	8.9	4.1	1.8	3.7
gc object scan	11.1K	100.0
gc quiesce	1	100.0
gcs log flush sync	319.8K	90.5	6.6	2.5	.4	.1	.0	.0
ges DFS hang analysis phase 2 acks	1				100.0
ges inquiry response	2	100.0
ges lms sync during dynamic remastering and reconfig	48						33.3	66.7
ges message buffer allocation	1389.9K	100.0	.0
ges2 LMON to wake up LMD - mrcvr	2	100.0
global enqueue expand wait	108	2.8	.9			96.3
kfk: async disk IO	1225	99.8	.2
ksxr poll remote instances	82.7K	100.0	.0	.0
latch free	982	93.4	5.1	1.3	.2
latch: cache buffers chains	184.3K	97.1	2.2	.6	.1	.0	.0
latch: cache buffers lru chain	86	93.0	1.2	2.3	1.2	1.2	1.2
latch: checkpoint queue latch	2	100.0
latch: enqueue hash chains	92	89.1	10.9
latch: gc element	2414	99.9	.1
latch: gcs resource hash	20	100.0
latch: ges resource hash list	11.1K	95.2	4.0	.6	.1	.0	.0
latch: messages	5	100.0
latch: object queue header operation	267	98.9	.7	.4
latch: redo allocation	3174	93.6	4.3	1.5	.3	.2
latch: row cache objects	3769	93.7	3.8	1.8	.6	.1		.0
latch: session allocation	1	100.0
latch: shared pool	5	100.0
latch: undo global data	7	71.4		28.6
library cache load lock	160	50.6	12.5	1.3	.6		6.9	28.1
library cache lock	689	93.6	3.2	1.5	1.3	.3		.1
library cache pin	1794	94.5	3.1	1.5	.7	.1		.1
library cache: mutex X	10.8K	82.4	.8	.6	1.2	1.6	2.0	11.4
lock deadlock retry	2329	100.0	.0
lock escalate retry	774	99.7				.3
log file parallel write	233.1K	74.3	16.4	8.0	1.0	.2	.1	.0
log file sequential read	106	82.1	14.2		1.9	1.9
log file single write	106	86.8	10.4	1.9	.9
log file switch (checkpoint incomplete)	362	.6		1.7	4.4	10.2	11.6	31.5	40.1
log file switch completion	542	1.3	1.1	3.7	10.1	16.6	43.4	23.8
log file sync	188K	53.6	24.0	14.5	5.8	1.2	.6	.3
os thread startup	142							100.0
rdbms ipc reply	177	98.9	.6			.6
read by other session	9285	57.4	5.8	8.3	16.9	9.3	1.9	.4
reliable message	566	84.5	12.0	1.2	.5	.4	.5	.9
row cache lock	24.6K	94.7	3.9	.5	.3	.3	.1	.1	.0
undo segment extension	174	37.4				32.8	26.4	3.4
wait for scn ack	18	33.3	22.2	16.7	22.2		5.6
wait list latch free	32					100.0
ASM background timer	727								100.0
DIAG idle wait	203K	2.8	.4	.4	19.1	42.2	13.6	21.4
KSV master wait	2324	99.8	.1		.0			.0
PING	1476	79.1	.7	.3	.2				19.6
PX Deq: Execute Reply	36	80.6		16.7	2.8
PX Deq: Execution Msg	2526	81.9	5.1	3.9	4.4	2.4	1.6	.7	.0
PX Deq: Join ACK	45	62.2	22.2	8.9	6.7
PX Deq: Parse Reply	42	71.4	26.2	2.4
PX Idle Wait	4547		1.1	1.3	1.3	1.3	.9	2.7	91.4
SQL*Net message from client	3449.7K	38.4	23.1	13.8	7.9	5.3	3.8	7.3	.4
Space Manager: slave idle wait	727								100.0
Streams AQ: RAC qmn coordinator idle wait	260	100.0
Streams AQ: qmn coordinator idle wait	252	49.2		.8					50.0
Streams AQ: qmn slave idle wait	126								100.0
class slave wait	121	13.2				7.4	33.1	3.3	43.0
dispatcher timer	61								100.0
gcs remote message	1857.4K	58.5	14.8	9.7	6.4	3.6	3.3	3.7
ges remote message	135.8K	40.5	5.2	5.3	6.5	6.8	6.7	29.1
heartbeat monitor sleep	727								100.0
jobq slave wait	7672							100.0
pmon timer	1369	6.8	1.6	.1	.1	.1		2.3	89.0
rdbms ipc message	406.9K	46.9	9.7	9.3	8.1	5.3	2.9	13.0	4.9
shared server idle wait	121								100.0
smon timer	116					2.6	3.4	57.8	36.2
wait for unread message on broadcast channel	7272					.0		100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ASM file metadata operation	1	99.9		.1
CSS initialization	1	50.0	50.0
DFS lock handle	1	100.0			.0
JS kgl get object wait	1			100.0
LGWR wait for redo copy	1	100.0	.0
SQL*Net break/reset to client	414	98.9	.7	.3	.1	.0
SQL*Net more data from client	323	99.5	.3	.1	.1	.0	.0
buffer busy waits	4266	99.5	.1	.3	.0	.0	.0	.0	.0
control file sequential read	1	100.0			.0
cursor: pin S	97	91.0	3.8	.6	2.6	2.0
cursor: pin S wait on X	2	89.5			10.5
db file parallel read	132	98.9	.9	.1	.0	.0
db file parallel write	9	99.9	.1
db file scattered read	13	95.1	4.5	.4
db file sequential read	277	99.9	.1	.0	.0	.0
enq: CF - contention	1	99.4	.6
enq: FB - contention	1	100.0			.0
enq: HW - contention	3	97.2		1.9	.9
enq: SQ - contention	570	90.4	2.3	1.7	1.8	1.1	.7	.8	1.1
enq: TM - contention	1	96.6		3.4
enq: TX - allocate ITL entry	493	68.7	8.1	15.5	6.8	.6	.2	.1
enq: TX - contention	15	90.4	8.3	1.3
enq: TX - index contention	19.2K	59.3	8.1	15.4	10.5	5.4	1.1	.1	.0
enq: TX - row lock contention	18	63.0	14.8	5.6	3.7	3.7	1.9	3.7	3.7
enq: WF - contention	3	76.9	7.7		7.7		7.7
gc buffer busy acquire	16.9K	93.3	2.7	3.5	.5	.1	.0	.0	.0
gc buffer busy release	12.1K	89.5	2.2	6.3	1.8	.2	.0		.0
gc cr block 2-way	23	100.0	.0	.0	.0
gc cr block busy	30	99.9	.1	.0
gc cr block congested	4	95.8	3.1	1.0
gc cr disk read	1	100.0				.0
gc cr grant 2-way	4	100.0	.0			.0
gc cr multi block request	1	100.0		.0
gc current block 2-way	446	99.9	.0	.0	.0	.0	.0	.0	.0
gc current block busy	4794	95.2	1.0	2.9	.7	.1		.0	.0
gc current block congested	24	95.4	2.1	1.5		.9
gc current grant 2-way	6	99.9	.0	.0		.0
gc current grant busy	747	98.5	.4	.9	.2	.0	.0
gc current grant congested	1	90.9	9.1
gc current multi block request	2	100.0	.0
gc current retry	170	78.2	6.5	12.0	2.7	.5
gc current split	157	96.3	.8	2.0	.8	.1
gcs log flush sync	4	100.0	.0
ges lms sync during dynamic remastering and reconfig	32	33.3	33.3	33.3
latch: row cache objects	1	100.0	.0
library cache load lock	45	71.9	14.4	1.9		11.9
library cache lock	1	99.9		.1
library cache pin	1	99.9	.1
library cache: mutex X	1232	88.6	2.4	2.4	2.9	2.8	.8
log file parallel write	68	100.0	.0	.0	.0
log file switch (checkpoint incomplete)	137	28.5	1.4	1.9	9.7	18.5		6.4	33.7
log file switch completion	129	76.2	13.3	3.9	2.4	4.2
log file sync	617	99.7	.3	.1	.0
os thread startup	142				100.0
read by other session	34	99.6	.2	.1		.0
reliable message	5	99.1	.2			.2	.5
row cache lock	35	99.8	.1	.0	.0	.0	.0	.0	.0
undo segment extension	6	96.6	2.9	.6

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
		% of Total Waits
buffer busy waits	20	100.0	.0
enq: SQ - contention	73	98.9	1.1
enq: TX - index contention	19	100.0	.0	.0
enq: TX - row lock contention	2	96.3	1.9	1.9
gc buffer busy acquire	3	100.0	.0
gc buffer busy release	3	100.0	.0
gc current block 2-way	5	100.0	.0
gc current block busy	3	100.0	.0
log file switch (checkpoint incomplete)	122	66.3	33.7
row cache lock	4	100.0	.0

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)
babjdb	13,988	2,069	211	109,187
SYS$USERS	116	68	91	498
SYS$BACKGROUND	0	0	4	320
babjdbXDB	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Network Total Wts	Network Wt Time
babjdb	121416	386	1115844	4708	0	3513461	59
SYS$USERS	91662	32	710	0	1	338	0
SYS$BACKGROUND	1790	4	3702	22	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
SQL ordered by Cluster Wait Time
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 93.1% of Total DB Time (s): 14,105
Captured PL/SQL account for 0.0% of Total DB Time (s): 14,105

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
9,748.67	26,524	0.37	69.11	10.36	0.24	b9yah4avy5n3c	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_PRE_M...
654.00	2,546,100	0.00	4.64	13.38	0.00	921wc95x40hk2	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_CHN_PRE_MIN_se...
299.98	18,619	0.02	2.13	2.93	1.08	g2qckpurz2mqk	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_ST...
262.77	22,193	0.01	1.86	3.22	1.30	2h3h5j29r9zhw	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_ST...
259.77	20,029	0.01	1.84	3.61	0.86	1t9gwmb77gkpu	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...
200.61	17,939	0.01	1.42	5.37	1.09	7duj5j208p6ad	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_ST...
198.81	20,029	0.01	1.41	3.18	4.01	8ynj1nfjyy4qu	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...
178.82	8	22.35	1.27	17.10	63.76	b9rdqhhfpx6w3	grid_appserver@app07 (TNS V1-V3)	SELECT COUNT(1) FROM ( SELECT ...
156.28	40,133	0.00	1.11	1.53	0.00	9tcvnq0hdspsa	SOD_DataImport@node04 (TNS V1-V3)	select RADA_CHN_DOR_L3_ST_PD_F...
115.68	1,332,392	0.00	0.82	31.40	0.00	7gtztzv329wg0		select c.name, u.name from con...

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

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,009.66	26,524	0.04	47.24	9,748.67	10.36	0.24	b9yah4avy5n3c	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_PRE_M...
87.51	2,546,100	0.00	4.09	654.00	13.38	0.00	921wc95x40hk2	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_CHN_PRE_MIN_se...
45.42	107	0.42	2.12	49.88	91.05	0.09	1rnmj1y7wwjbv	SOD_DataImport@node04 (TNS V1-V3)	delete from OCEN_TSC_GLB_MUL_T...
42.66	13	3.28	2.00	91.25	46.75	33.82	7xz67tyjpuzf0	JDBC Thin Client	select a.tablespace_name, trun...
36.32	1,332,392	0.00	1.70	115.68	31.40	0.00	7gtztzv329wg0		select c.name, u.name from con...
30.58	8	3.82	1.43	178.82	17.10	63.76	b9rdqhhfpx6w3	grid_appserver@app07 (TNS V1-V3)	SELECT COUNT(1) FROM ( SELECT ...
22.95	1,332,696	0.00	1.07	61.30	37.44	0.00	2skwhauh2cwky		select o.name, u.name from obj...
20.65	117	0.18	0.97	23.34	88.48	0.16	1u8cb2ybu33hh	SOD_DataImport@node04 (TNS V1-V3)	select V_BBB from OCEN_TSC_GLB...
10.78	17,939	0.00	0.50	200.61	5.37	1.09	7duj5j208p6ad	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_ST...
9.38	20,029	0.00	0.44	259.77	3.61	0.86	1t9gwmb77gkpu	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
114.02	8	14.25	26.98	178.82	17.10	63.76	b9rdqhhfpx6w3	grid_appserver@app07 (TNS V1-V3)	SELECT COUNT(1) FROM ( SELECT ...
61.75	1	61.75	14.61	67.39	6.65	91.64	86pf4un9055xs	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
45.12	2	22.56	10.68	51.18	9.30	88.16	5yjnyp1yr49kv	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
30.86	13	2.37	7.30	91.25	46.75	33.82	7xz67tyjpuzf0	JDBC Thin Client	select a.tablespace_name, trun...
23.84	26,524	0.00	5.64	9,748.67	10.36	0.24	b9yah4avy5n3c	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_PRE_M...
22.09	2,348	0.01	5.23	26.58	8.13	83.13	0zha71gxcgdvd	SOD_DataImport@node04 (TNS V1-V3)	insert into UPAR_ARD_GLB_MUL_M...
8.48	2	4.24	2.01	15.56	8.74	54.51	019u8pu0dfk5b	grid_appserver@app08 (TNS V1-V3)	select count(1), sum(D_FILE_SI...
7.98	20,029	0.00	1.89	198.81	3.18	4.01	8ynj1nfjyy4qu	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...
5.97	2	2.98	1.41	9.40	28.19	63.47	5xrq60dyjjrz4	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
5.22	844	0.01	1.24	20.80	14.28	25.12	gfxfu9fgsy7bj	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...

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: 110,012,697
Captured SQL account for 105.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
87,900,602	26,524	3,314.00	79.90	9,748.67	10.36	0.24	b9yah4avy5n3c	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_PRE_M...
6,658,154	1,332,696	5.00	6.05	61.30	37.44	0.00	2skwhauh2cwky		select o.name, u.name from obj...
3,772,914	107	35,260.88	3.43	49.88	91.05	0.09	1rnmj1y7wwjbv	SOD_DataImport@node04 (TNS V1-V3)	delete from OCEN_TSC_GLB_MUL_T...
3,669,483	8	458,685.38	3.34	178.82	17.10	63.76	b9rdqhhfpx6w3	grid_appserver@app07 (TNS V1-V3)	SELECT COUNT(1) FROM ( SELECT ...
2,665,626	1,332,392	2.00	2.42	115.68	31.40	0.00	7gtztzv329wg0		select c.name, u.name from con...
2,661,802	117	22,750.44	2.42	23.34	88.48	0.16	1u8cb2ybu33hh	SOD_DataImport@node04 (TNS V1-V3)	select V_BBB from OCEN_TSC_GLB...
1,410,040	4,906	287.41	1.28	11.54	20.37	23.51	fq3ws1wmh1kpn	SOD_DataImport@node04 (TNS V1-V3)	select Q20013, Q20001, Q20010,...
1,133,699	68	16,672.04	1.03	6.51	72.55	8.31	6cnp4yajja560	grid_appserver@app08 (TNS V1-V3)	select count(1), sum(D_FILE_SI...
610,181	22,193	27.49	0.55	262.77	3.22	1.30	2h3h5j29r9zhw	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_ST...
595,819	18,619	32.00	0.54	299.98	2.93	1.08	g2qckpurz2mqk	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_ST...

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: 305,620
Captured SQL account for 90.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
90,396	13	6,953.54	29.58	91.25	46.75	33.82	7xz67tyjpuzf0	JDBC Thin Client	select a.tablespace_name, trun...
89,308	8	11,163.50	29.22	178.82	17.10	63.76	b9rdqhhfpx6w3	grid_appserver@app07 (TNS V1-V3)	SELECT COUNT(1) FROM ( SELECT ...
47,374	1	47,374.00	15.50	67.39	6.65	91.64	86pf4un9055xs	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
23,369	2	11,684.50	7.65	51.18	9.30	88.16	5yjnyp1yr49kv	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
8,004	2	4,002.00	2.62	9.40	28.19	63.47	5xrq60dyjjrz4	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
3,813	26,524	0.14	1.25	9,748.67	10.36	0.24	b9yah4avy5n3c	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_PRE_M...
3,762	2	1,881.00	1.23	15.56	8.74	54.51	019u8pu0dfk5b	grid_appserver@app08 (TNS V1-V3)	select count(1), sum(D_FILE_SI...
2,933	2,348	1.25	0.96	26.58	8.13	83.13	0zha71gxcgdvd	SOD_DataImport@node04 (TNS V1-V3)	insert into UPAR_ARD_GLB_MUL_M...
1,052	844	1.25	0.34	20.80	14.28	25.12	gfxfu9fgsy7bj	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...
1,011	20,029	0.05	0.33	198.81	3.18	4.01	8ynj1nfjyy4qu	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...

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: 298,207
Captured SQL account for 92.7% of Total
Total UnOptimized Read Requests: 298,207
Captured SQL account for 92.7% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
94,348	94,348	13	7,257.54	31.64	7xz67tyjpuzf0	JDBC Thin Client	select a.tablespace_name, trun...
89,305	89,305	8	11,163.13	29.95	b9rdqhhfpx6w3	grid_appserver@app07 (TNS V1-V3)	SELECT COUNT(1) FROM ( SELECT ...
47,374	47,374	1	47,374.00	15.89	86pf4un9055xs	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
23,369	23,369	2	11,684.50	7.84	5yjnyp1yr49kv	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
7,941	7,941	2	3,970.50	2.66	5xrq60dyjjrz4	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
3,813	3,813	26,524	0.14	1.28	b9yah4avy5n3c	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_PRE_M...
3,450	3,450	2	1,725.00	1.16	019u8pu0dfk5b	grid_appserver@app08 (TNS V1-V3)	select count(1), sum(D_FILE_SI...
1,052	1,052	844	1.25	0.35	gfxfu9fgsy7bj	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...
1,011	1,011	20,029	0.05	0.34	8ynj1nfjyy4qu	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...
857	857	2,348	0.36	0.29	0zha71gxcgdvd	SOD_DataImport@node04 (TNS V1-V3)	insert into UPAR_ARD_GLB_MUL_M...

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: 6,000,768
Captured SQL account for 97.8% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,546,100	2,546,005	1.00	654.00	13.38	0.00	921wc95x40hk2	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_CHN_PRE_MIN_se...
1,332,696	1,331,896	1.00	61.30	37.44	0.00	2skwhauh2cwky		select o.name, u.name from obj...
1,332,392	163	0.00	115.68	31.40	0.00	7gtztzv329wg0		select c.name, u.name from con...
97,292	95,026	0.98	4.29	11.90	0.00	9tgj4g8y4rwy8		select type#, blocks, extents,...
66,908	66,908	1.00	50.76	4.00	0.00	d93zvfq19vj9c	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_CHN_REP_seq.ne...
55,794	55,794	1.00	4.83	4.35	0.00	fxs3jmauhy220	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_C_MUL_MIN_MAIN...
55,718	55,718	1.00	12.33	1.54	0.00	5ba4r4a9s15h1	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_C_MUL_MIN_OTH_...
40,133	40,132	1.00	156.28	1.53	0.00	9tcvnq0hdspsa	SOD_DataImport@node04 (TNS V1-V3)	select RADA_CHN_DOR_L3_ST_PD_F...
29,656	29,656	1.00	45.91	4.18	0.00	063412ux1n026	SOD_DataImport@node04 (TNS V1-V3)	select RADA_CHN_DOR_L3_ST_VW_F...
26,524	1,215,357	45.82	9,748.67	10.36	0.24	b9yah4avy5n3c	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_PRE_M...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 5,961,799
Captured SQL account for 98.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
2,543,178	2,546,100	42.66	921wc95x40hk2	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_CHN_PRE_MIN_se...
1,332,289	1,332,392	22.35	7gtztzv329wg0		select c.name, u.name from con...
1,332,250	1,332,696	22.35	2skwhauh2cwky		select o.name, u.name from obj...
97,292	97,292	1.63	9tgj4g8y4rwy8		select type#, blocks, extents,...
66,908	66,908	1.12	d93zvfq19vj9c	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_CHN_REP_seq.ne...
55,794	55,794	0.94	fxs3jmauhy220	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_C_MUL_MIN_MAIN...
55,716	55,718	0.93	5ba4r4a9s15h1	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_C_MUL_MIN_OTH_...
40,130	40,133	0.67	9tcvnq0hdspsa	SOD_DataImport@node04 (TNS V1-V3)	select RADA_CHN_DOR_L3_ST_PD_F...
29,652	29,656	0.50	063412ux1n026	SOD_DataImport@node04 (TNS V1-V3)	select RADA_CHN_DOR_L3_ST_VW_F...
26,524	26,524	0.44	b9yah4avy5n3c	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_PRE_M...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
32	150	gqvt3zxmq3k53	grid_appserver@app05 (TNS V1-V3)	SELECT COLUMN_NAME, DATA_TYPE,...
28	0	arx2rgss6k33m	perl@db01 (TNS V1-V3)	SELECT s.inst_id, s.name, i.i...
28	0	dbp7qgbgvmqgz	perl@db01 (TNS V1-V3)	SELECT mt.inst_id, service_na...
24	50	4gjq0xf0rw497	SEVERITY EVALUATION	SELECT /+ cardinality(d 20) ...
24	50	4gjq0xf0rw497	SEVERITY EVALUATION	SELECT /+ cardinality(d 20) ...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

%Total - Cluster Time as a percentage of Total Cluster Wait Time
%Clu - Cluster Time as a percentage of Elapsed Time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Only SQL with Cluster Wait Time > .005 seconds is reported
Total Cluster Wait Time (s): 5,278
Captured SQL account for 99.8% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
4,282.62	26,524	43.93	9,748.67	81.14	10.36	0.24	b9yah4avy5n3c	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_PRE_M...
169.87	18,619	56.63	299.98	3.22	2.93	1.08	g2qckpurz2mqk	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_ST...
147.52	22,193	56.14	262.77	2.80	3.22	1.30	2h3h5j29r9zhw	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_ST...
137.68	20,029	69.25	198.81	2.61	3.18	4.01	8ynj1nfjyy4qu	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...
121.02	17,939	60.33	200.61	2.29	5.37	1.09	7duj5j208p6ad	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_ST...
119.42	20,029	45.97	259.77	2.26	3.61	0.86	1t9gwmb77gkpu	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...
63.87	7,497	62.27	102.56	1.21	4.95	1.30	fpxk90ad86u1q	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_ST...
36.07	8	20.17	178.82	0.68	17.10	63.76	b9rdqhhfpx6w3	grid_appserver@app07 (TNS V1-V3)	SELECT COUNT(1) FROM ( SELECT ...
27.75	18,140	63.92	43.41	0.53	6.22	0.00	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
26.43	3,540	45.29	58.36	0.50	2.96	1.06	3cq5ad9qn6x8h	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_ST...
22.86	16,305	41.40	55.23	0.43	8.27	6.54	awfzp9zc8swfu	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L3_PU...
18.10	13	19.84	91.25	0.34	46.75	33.82	7xz67tyjpuzf0	JDBC Thin Client	select a.tablespace_name, trun...
16.59	2,383	39.03	42.50	0.31	13.27	5.52	csjqdb3x7sgzf	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_C_MUL_MIN...
10.76	7,304	87.95	12.24	0.20	11.77	0.00	axmdf8vq7k1rh		select increment$, minvalue, m...
10.07	2,882	40.02	25.16	0.19	26.55	11.04	faf45qdmw5k1j	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_REP_T...
7.89	40,133	5.05	156.28	0.15	1.53	0.00	9tcvnq0hdspsa	SOD_DataImport@node04 (TNS V1-V3)	select RADA_CHN_DOR_L3_ST_PD_F...
6.16	2	39.57	15.56	0.12	8.74	54.51	019u8pu0dfk5b	grid_appserver@app08 (TNS V1-V3)	select count(1), sum(D_FILE_SI...
5.40	20,043	35.03	15.42	0.10	12.77	2.27	55dn7dk4cmcwk	SOD_DataImport@node04 (TNS V1-V3)	select Q10004, Q10051, Q10061,...
5.23	2,546,100	0.80	654.00	0.10	13.38	0.00	921wc95x40hk2	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_CHN_PRE_MIN_se...
4.54	66,908	8.95	50.76	0.09	4.00	0.00	d93zvfq19vj9c	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_CHN_REP_seq.ne...
4.04	2,379	26.17	15.46	0.08	25.88	14.09	9p6frhrxfnc2t	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_C_MUL_MIN...
3.74	29,656	8.14	45.91	0.07	4.18	0.00	063412ux1n026	SOD_DataImport@node04 (TNS V1-V3)	select RADA_CHN_DOR_L3_ST_VW_F...
2.80	20,042	6.21	45.14	0.05	1.57	0.00	7v922w0gt4jsc	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_CHN_MUL_HOR_se...
2.44	461	10.04	24.35	0.05	0.04	0.00	7pc9byd9t453f	SOD_DataImport@node04 (TNS V1-V3)	select UPAR_FILE_DATA_F_seq.ne...
2.20	844	10.58	20.80	0.04	14.28	25.12	gfxfu9fgsy7bj	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_CHN_MUL_H...
1.96	3,687	14.55	13.46	0.04	9.51	4.64	a90mvyvbmpys6	SOD_DataImport@node04 (TNS V1-V3)	insert into SURF_WEA_GLB_MUL_H...
1.88	2,348	7.09	26.58	0.04	8.13	83.13	0zha71gxcgdvd	SOD_DataImport@node04 (TNS V1-V3)	insert into UPAR_ARD_GLB_MUL_M...
1.48	16,305	13.37	11.05	0.03	7.24	0.00	a5vw0yk0gpkjp	SOD_DataImport@node04 (TNS V1-V3)	select RADA_CHN_DOR_L3_PUP_F_s...
1.17	55,718	9.52	12.33	0.02	1.54	0.00	5ba4r4a9s15h1	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_C_MUL_MIN_OTH_...
1.16	1	1.72	67.39	0.02	6.65	91.64	86pf4un9055xs	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
0.91	4,906	7.91	11.54	0.02	20.37	23.51	fq3ws1wmh1kpn	SOD_DataImport@node04 (TNS V1-V3)	select Q20013, Q20001, Q20010,...
0.88	2	1.72	51.18	0.02	9.30	88.16	5yjnyp1yr49kv	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
0.80	2	8.56	9.40	0.02	28.19	63.47	5xrq60dyjjrz4	grid_appserver@app06 (TNS V1-V3)	SELECT * FROM ( SELECT ROWNUM ...
0.75	68	11.50	6.51	0.01	72.55	8.31	6cnp4yajja560	grid_appserver@app08 (TNS V1-V3)	select count(1), sum(D_FILE_SI...
0.60	692	47.62	1.26	0.01	24.68	16.07	8usxu4fh2qmtr	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L2_FM...
0.55	20,007	3.18	17.39	0.01	3.22	0.00	gdc07yrmhcwat	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_CHN_MUL_HOR_O_...
0.54	711	45.54	1.19	0.01	33.74	17.40	4a6fqxy161t8r	SOD_DataImport@node04 (TNS V1-V3)	insert into RADA_CHN_DOR_L2_QC...
0.54	4,906	7.71	7.00	0.01	3.00	0.00	4m7g0041v4jtj	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_GLB_MUL_HOR_O_...
0.53	4,906	16.31	3.23	0.01	11.14	0.00	fxps09f8pa4tg	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_GLB_MUL_HOR_se...
0.12	520	8.82	1.31	0.00	6.11	70.24	8axyb930js92v	SOD_DataImport@node04 (TNS V1-V3)	insert into UPAR_GPS_C_F_TAB(V...
0.07	97,292	1.56	4.29	0.00	11.90	0.00	9tgj4g8y4rwy8		select type#, blocks, extents,...
0.05	107	0.10	49.88	0.00	91.05	0.09	1rnmj1y7wwjbv	SOD_DataImport@node04 (TNS V1-V3)	delete from OCEN_TSC_GLB_MUL_T...
0.05	21	58.61	0.08	0.00	0.00	24.59	dgyxnnwur743r	SOD_DataImport@node04 (TNS V1-V3)	insert into SATE_ORB_RAW_F_TAB...
0.03	58	8.77	0.31	0.00	16.00	52.35	9mg29jx94d5f7	SOD_DataImport@node04 (TNS V1-V3)	insert into OCEN_BUOY_C_FTM_F_...
0.02	117	0.10	23.34	0.00	88.48	0.16	1u8cb2ybu33hh	SOD_DataImport@node04 (TNS V1-V3)	select V_BBB from OCEN_TSC_GLB...
0.02	55,794	0.43	4.83	0.00	4.35	0.00	fxs3jmauhy220	SOD_DataImport@node04 (TNS V1-V3)	select SURF_WEA_C_MUL_MIN_MAIN...
0.01	14	1.58	0.52	0.00	1.91	4.94	gbs98t2pxxma0	SOD_DataImport@node04 (TNS V1-V3)	update SURF_WEA_CHN_MUL_HOR_TA...
0.01	3	1.59	0.35	0.00	73.47	15.46	ab3swhv5g138y		select OBJOID, CLSOID, RUNTIME...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

019u8pu0dfk5b select count(1), sum(D_FILE_SIZE) from RADA_CHN_DOR_L3_PUP_F_TAB WHERE (( ( D_DATA_ID LIKE '%J.0003.0001%' AND V07021 = '15' ) OR ( D_DATA_ID LIKE '%J.0003.0001%' AND V07021 = '24' ) OR ( D_DATA_ID LIKE '%J.0003.0001%' AND V07021 = '5' ) OR ( D_DATA_ID LIKE '%J.0003.0002%' AND V07021 = '5' ) OR ( D_DATA_ID LIKE '%J.0003.0002%' AND V07021 = '24' ) OR ( D_DATA_ID LIKE '%J.0003.0002%' AND V07021 = '15' ) OR ( D_DATA_ID LIKE '%J.0003.0003%' ) OR ( D_DATA_ID LIKE '%J.0003.0004%' ) OR ( D_DATA_ID LIKE '%J.0003.0005%' ) OR ( D_DATA_ID LIKE '%J.0003.0006%' ) OR ( D_DATA_ID LIKE '%J.0003.0007%' ) OR ( D_DATA_ID LIKE '%J.0003.0008%' ) OR ( D_DATA_ID LIKE '%J.0003.0009%' ) OR ( D_DATA_ID LIKE '%J.0003.0010%' ) OR ( D_DATA_ID LIKE '%J.0003.0011%' ) OR ( D_DATA_ID LIKE '%J.0003.0012%' ) OR ( D_DATA_ID LIKE '%J.0003.0013%' ) OR ( D_DATA_ID LIKE '%J.0003.0014%' ) ))and(V01301 in ('Z9001', 'Z9010'))and(d_datetime between to_date('20130313152335', 'yy-mm-dd hh24:mi:ss') and to_date('20130314152335', 'yy-mm-dd hh24:mi:ss'))

063412ux1n026 select RADA_CHN_DOR_L3_ST_VW_F_seq.nextval from dual

0zha71gxcgdvd insert into UPAR_ARD_GLB_MUL_MUT_AMD_TAB(V_BBB, V04001_02, V04002_02, V04003_02, V04004_02, V04005_02, V01301, V05001, V06001, V04001, V04002, V04003, V04004, V04005, V04006, V07010, V07002, V08009, V12001, V12003, V13003, V11001, V11002, V11031, V02061, V02062, V02005, V11036, Q07010, Q07002, Q08009, Q12001, Q12003, Q13003, Q11001, Q11002, Q11031, Q02061, Q02062, Q02005, Q11036, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , sysdate, to_date(:43 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:44 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :45 )

1rnmj1y7wwjbv delete from OCEN_TSC_GLB_MUL_TAB where D_RECORD_ID=:1

1t9gwmb77gkpu insert into SURF_WEA_CHN_MUL_HOR_TAB(V01301, V01300, V05001, V06001, V07001, V07031, V07032_04, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V10004, V10051, V10061, V10062, V10301, V10301_052, V10302, V10302_052, V12001, V12011, V12011_052, V12012, V12012_052, V12405, V12016, V12017, V12003, V13003, V13007, V13007_052, V13004, V13019, V13020, V13021, V13022, V13023, V04080_04, V13011, V13033, V11290, V11291, V11292, V11293, V11296, V11042, V11042_052, V11201, V11202, V11211, V11046, V11046_052, V11503_06, V11504_06, V11503_12, V11504_12, V12120, V12311, V12311_052, V12121, V12121_052, V12013, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, V12030_080, V12030_160, V12030_320, V12314, V12315, V12315_052, V12316, V12316_052, V20001_701_01, V20001_701_10, V20059, V20059_052, V20001, V20010, V20051, V20011, V20013, V20350_01, V20350_02, V20350_03, V20350_04, V20350_05, V20350_06, V20350_07, V20350_08, V20350_11, V20350_12, V20350_13, V20003, V04080_05, V20004, V20005, V20062, V13013, V13330, V20330_01, V20331_01, V20330_02, V20331_02, Q10004, Q10051, Q10061, Q10062, Q10301, Q10301_052, Q10302, Q10302_052, Q12001, Q12011, Q12011_052, Q12012, Q12012_052, Q12405, Q12016, Q12017, Q12003, Q13003, Q13007, Q13007_052, Q13004, Q13019, Q13020, Q13021, Q13022, Q13023, Q04080_04, Q13011, Q13033, Q11290, Q11291, Q11292, Q11293, Q11296, Q11042, Q11042_052, Q11201, Q11202, Q11211, Q11046, Q11046_052, Q11503_06, Q11504_06, Q11503_12, Q11504_12, Q12120, Q12311, Q12311_052, Q12121, Q12121_052, Q12013, Q12030_005, Q12030_010, Q12030_015, Q12030_020, Q12030_040, Q12030_080, Q12030_160, Q12030_320, Q12314, Q12315, Q12315_052, Q12316, Q12316_052, Q20001_701_01, Q20001_701_10, Q20059, Q20059_052, Q20001, Q20010, Q20051, Q20011, Q20013, Q20350_01, Q20350_02, Q20350_03, Q20350_04, Q20350_05, Q20350_06, Q20350_07, Q20350_08, Q20350_11, Q20350_12, Q20350_13, Q20003, Q04080_05, Q20004, Q20005, Q20062, Q13013, Q13330, Q20330_01, Q20331_01, Q20330_02, Q20331_02, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , sysdate, to_date(:206 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:207 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :208 )

1u8cb2ybu33hh select V_BBB from OCEN_TSC_GLB_MUL_O_K_TAB where V01301=:1 and V05001=:2 and V06001=:3 and V04001=:4 and V04002=:5 and V04003=:6 and V04004=:7 and V04005=:8 and D_DATA_ID=:9

2h3h5j29r9zhw insert into RADA_CHN_DOR_L3_ST_PD_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V07021, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , sysdate, to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 , :16 , :17 , :18 , to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), :20 )

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

3cq5ad9qn6x8h insert into RADA_CHN_DOR_L3_ST_VW_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V10002, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , sysdate, to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 , :16 , :17 , :18 , to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), :20 )

4a6fqxy161t8r insert into RADA_CHN_DOR_L2_QC_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_RADAR_MODEL, V_SCANNING_MODE, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , sysdate, to_date(:13 , 'yyyy-mm-dd HH24:MI:SS'), :14 , :15 , :16 , :17 , to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), :19 )

4gjq0xf0rw497 SELECT /*+ cardinality(d 20) */ MAX(MGMT_GLOBAL.ADJUST_TZ(MARKER_TIMESTAMP, T.TIMEZONE_REGION, :B3 )) FROM MGMT_AVAILABILITY_MARKER M, MGMT_TARGETS T, TABLE(CAST(:B1 AS MGMT_METRIC_DETAILS_ARRAY)) D WHERE T.TARGET_GUID = M.TARGET_GUID AND T.TARGET_GUID = D.TARGET_GUID AND M.MARKER_AVAIL_STATUS = :B2

4m7g0041v4jtj select SURF_WEA_GLB_MUL_HOR_O_seq.nextval from dual

4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1

55dn7dk4cmcwk select Q10004, Q10051, Q10061, Q10062, Q10301, Q10301_052, Q10302, Q10302_052, Q12001, Q12011, Q12011_052, Q12012, Q12012_052, Q12405, Q12016, Q12017, Q12003, Q13003, Q13007, Q13007_052, Q13004, Q13019, Q13020, Q13021, Q13022, Q13023, Q04080_04, Q13011, Q13033, Q11290, Q11291, Q11292, Q11293, Q11296, Q11042, Q11042_052, Q11201, Q11202, Q11211, Q11046, Q11046_052, Q11503_06, Q11504_06, Q11503_12, Q11504_12, Q12120, Q12311, Q12311_052, Q12121, Q12121_052, Q12013, Q12030_005, Q12030_010, Q12030_015, Q12030_020, Q12030_040, Q12030_080, Q12030_160, Q12030_320, Q12314, Q12315, Q12315_052, Q12316, Q12316_052, Q20001_701_01, Q20001_701_10, Q20059, Q20059_052, Q20001, Q20010, Q20051, Q20011, Q20013, Q20350_01, Q20350_02, Q20350_03, Q20350_04, Q20350_05, Q20350_06, Q20350_07, Q20350_08, Q20350_11, Q20350_12, Q20350_13, Q20003, Q04080_05, Q20004, Q20005, Q20062, Q13013, Q13330, Q20330_01, Q20331_01, Q20330_02, Q20331_02, D_RECORD_ID from SURF_WEA_CHN_MUL_HOR_TAB where V01301=:1 and V05001=:2 and V06001=:3 and V04001=:4 and V04002=:5 and V04003=:6 and V04004=:7 for update

5ba4r4a9s15h1 select SURF_WEA_C_MUL_MIN_OTH_seq.nextval from dual

5xrq60dyjjrz4 SELECT * FROM ( SELECT ROWNUM MYNUM, TB.* FROM ( SELECT V01300, V02301, V04001, V04002, V04003, V04004, V04005, V05001, V06001, V07001, V11046, V11211, V13011_24, V13013, V13019, V13020, V13021, V20001, V20003, V20066, V20302_017, V20326, V20401, V20402, V01301, V_ACODE FROM SURF_WEA_CHN_MUL_FTM_WSET_TAB t WHERE ((V_ACODE >= 420000 and V_ACODE <= 429999) or (V_ACODE >= 430000 and V_ACODE <= 439999))and(d_datetime between to_date('20121201000000', 'yy-mm-dd hh24:mi:ss') and to_date('20121202235959', 'yy-mm-dd hh24:mi:ss')) and ( D_DATA_ID = 'A.0024.0001.S001' ) ) TB ) WHERE ( MYNUM > 0 )

5yjnyp1yr49kv SELECT * FROM ( SELECT ROWNUM MYNUM, TB.* FROM ( SELECT V01300, V02301, V04001, V04002, V04003, V04004, V04005, V05001, V06001, V07001, V11046, V11211, V13011_24, V13013, V13019, V13020, V13021, V20001, V20003, V20066, V20302_017, V20326, V20401, V20402, V01301, V_ACODE FROM SURF_WEA_CHN_MUL_FTM_WSET_TAB t WHERE (V05001 >= 30 AND V05001 <= 45 AND V06001 >= 90 AND V06001 <= 110)and(d_datetime between to_date('20121128000000', 'yy-mm-dd hh24:mi:ss') and to_date('20121129235959', 'yy-mm-dd hh24:mi:ss') or d_datetime between to_date('20121201000000', 'yy-mm-dd hh24:mi:ss') and to_date('20121203235959', 'yy-mm-dd hh24:mi:ss')) and ( D_DATA_ID = 'A.0024.0001.S001' ) ) TB ) WHERE ( MYNUM > 0 )

6cnp4yajja560 select count(1), sum(D_FILE_SIZE) from NAFP_T639_FOR_FTM_F_TAB WHERE (d_datetime between to_date('20130314000000', 'yy-mm-dd hh24:mi:ss') and to_date('20130314000000', 'yy-mm-dd hh24:mi:ss')) and D_DATA_ID = 'F.0003.0001.S001'

7duj5j208p6ad insert into RADA_CHN_DOR_L3_ST_PD_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , sysdate, to_date(:13 , 'yyyy-mm-dd HH24:MI:SS'), :14 , :15 , :16 , :17 , to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), :19 )

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

7pc9byd9t453f select UPAR_FILE_DATA_F_seq.nextval from dual

7v922w0gt4jsc select SURF_WEA_CHN_MUL_HOR_seq.nextval from dual

7xz67tyjpuzf0 select a.tablespace_name, trunc(a.totalspace / 1024 / 1024 / 1024, 2) totalspace, trunc(1-b.freespace/a.totalspace, 2) usepert from (select tablespace_name, sum(bytes) totalspace from dba_data_files ddf where tablespace_name not in ('SYSTEM', 'SYSAUX') group by tablespace_name) a, (select tablespace_name, sum(bytes) freespace from dba_free_space dfs where tablespace_name not in ('SYSTEM', 'SYSAUX') group by tablespace_name) b where a.tablespace_name = b.tablespace_name

86pf4un9055xs SELECT * FROM ( SELECT ROWNUM MYNUM, TB.* FROM ( SELECT V01300, V02301, V04001, V04002, V04003, V04004, V04005, V05001, V06001, V07001, V11046, V11211, V13011_24, V13013, V13019, V13020, V13021, V20001, V20003, V20066, V20302_017, V20326, V20401, V20402, V01301, V_ACODE FROM SURF_WEA_CHN_MUL_FTM_WSET_TAB t WHERE (V01301 in ('53698'))and(d_datetime between to_date('20121101000000', 'yy-mm-dd hh24:mi:ss') and to_date('20121231235959', 'yy-mm-dd hh24:mi:ss')) and ( D_DATA_ID = 'A.0024.0001.S001' ) ) TB ) WHERE ( MYNUM > 0 )

8axyb930js92v insert into UPAR_GPS_C_F_TAB(V01300, V04001, V04002, V04003, V04004, V04005, V04300, V_FILE_NAME, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , sysdate, to_date(:9 , 'yyyy-mm-dd HH24:MI:SS'), :10 , :11 , :12 , :13 , to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 )

8usxu4fh2qmtr insert into RADA_CHN_DOR_L2_FMT_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_RADAR_MODEL, V_SCANNING_MODE, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , sysdate, to_date(:13 , 'yyyy-mm-dd HH24:MI:SS'), :14 , :15 , :16 , :17 , to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), :19 )

8ynj1nfjyy4qu insert into SURF_WEA_CHN_MUL_HOR_I_TAB(I10004, I10051, I10061, I10062, I10301, I10301_052, I10302, I10302_052, I12001, I12011, I12011_052, I12012, I12012_052, I12405, I12016, I12017, I12003, I13003, I13007, I13007_052, I13004, I13019, I13020, I13021, I13022, I13023, I04080_04, I13011, I13033, I11290, I11291, I11292, I11293, I11296, I11042, I11042_052, I11201, I11202, I11211, I11046, I11046_052, I11503_06, I11504_06, I11503_12, I11504_12, I12120, I12311, I12311_052, I12121, I12121_052, I12013, I12030_005, I12030_010, I12030_015, I12030_020, I12030_040, I12030_080, I12030_160, I12030_320, I12314, I12315, I12315_052, I12316, I12316_052, I20001_701_01, I20001_701_10, I20059, I20059_052, I20001, I20010, I20051, I20011, I20013, I20350_01, I20350_02, I20350_03, I20350_04, I20350_05, I20350_06, I20350_07, I20350_08, I20350_11, I20350_12, I20350_13, I20003, I04080_05, I20004, I20005, I20062, I13013, I13330, I20330_01, I20331_01, I20330_02, I20331_02, D_DATETIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , to_date(:96 , 'yyyy-mm-dd HH24:MI:SS'), :97 )

921wc95x40hk2 select SURF_WEA_CHN_PRE_MIN_seq.nextval from dual

9mg29jx94d5f7 insert into OCEN_BUOY_C_FTM_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_NAME, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , sysdate, to_date(:9 , 'yyyy-mm-dd HH24:MI:SS'), :10 , :11 , :12 , :13 , to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 )

9p6frhrxfnc2t insert into SURF_WEA_C_MUL_MIN_MAIN_TAB(V_BBB, V01301, V01300, V05001, V06001, V07001, V07031, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V04005, V10004, V12001, V13003, V11288, V11289, V12314, V12120, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, Q10004, Q12001, Q13003, Q11288, Q11289, Q12314, Q12120, Q12030_005, Q12030_010, Q12030_015, Q12030_020, Q12030_040, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , sysdate, to_date(:41 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:42 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :43 )

9tcvnq0hdspsa select RADA_CHN_DOR_L3_ST_PD_F_seq.nextval from dual

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

a5vw0yk0gpkjp select RADA_CHN_DOR_L3_PUP_F_seq.nextval from dual

a90mvyvbmpys6 insert into SURF_WEA_GLB_MUL_HOR_TAB(V04001_02, V04002_02, V04003_02, V04004_02, V01301, V01300, V05001, V06001, V07001, V07031, V07032_01, V07032_02, V07032_03, V07032_04, V02002, V02004, V02001, V_NCODE, V01015, V04001, V04002, V04003, V04004, V04005, V20013, V20001, V20010, V11001, V11002, V12001, V12003, V13003, V10004, V10051, V07004, V10009, V10063, V10061, V13019, V13011_02, V13020, V13021, V13011_09, V13022, V13011_15, V13011_18, V13023, V20003, V20004, V20005, V20011, V20350_11, V20350_12, V20350_13, V10062, V12405, V12014, V12016, V12015, V12017, V12013, V20062, V13013, V13340, V14032_01, V14032_24, V14016_01, V14015, V14021_01, V14020, V14023_01, V14022, V14002_01, V14001, V14004_01, V14003, V14025_01, V14024, V20054_01, V20054_02, V20054_03, V20012, V05021, V07021, V20012_01, V20011_01, V20013_01, V20012_02, V20011_02, V20013_02, V20012_03, V20011_03, V20013_03, V20012_04, V20011_04, V20013_04, V20063_01, V20063_02, V20063_03, Q20013, Q20001, Q20010, Q11001, Q11002, Q12001, Q12003, Q13003, Q10004, Q10051, Q07004, Q10009, Q10063, Q10061, Q13019, Q13011_02, Q13020, Q13021, Q13011_09, Q13022, Q13011_15, Q13011_18, Q13023, Q20003, Q20004, Q20005, Q20011, Q20350_11, Q20350_12, Q20350_13, Q10062, Q12405, Q12014, Q12016, Q12015, Q12017, Q12013, Q20062, Q13013, Q13340, Q14032_01, Q14032_24, Q14016_01, Q14015, Q14021_01, Q14020, Q14023_01, Q14022, Q14002_01, Q14001, Q14004_01, Q14003, Q14025_01, Q14024, Q20054_01, Q20054_02, Q20054_03, Q20012, Q05021, Q07021, Q20012_01, Q2 0011_01, Q20013_01, Q20012_02, Q20011_02, Q20013_02, Q20012_03, Q20011_03, Q20013_03, Q20012_04, Q20011_04, Q20013_04, Q20063_01, Q20063_02, Q20063_03, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , sysdate, to_date(:176 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:177 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :178 )

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

arx2rgss6k33m SELECT s.inst_id, s.name, i.instance_name FROM gv$active_services s, gv$instance i WHERE s.name = :p1 AND s.inst_id = i.inst_id

awfzp9zc8swfu insert into RADA_CHN_DOR_L3_PUP_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V07021, V_COVERING_AREA, V_DPI, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , sysdate, to_date(:16 , 'yyyy-mm-dd HH24:MI:SS'), :17 , :18 , :19 , :20 , to_date(:21 , 'yyyy-mm-dd HH24:MI:SS'), :22 )

axmdf8vq7k1rh select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1

b9rdqhhfpx6w3 SELECT COUNT(1) FROM ( SELECT ROWNUM MYNUM, TB.* FROM ( SELECT D_DATETIME, V12001 FROM SURF_WEA_CHN_MUL_HOR_TAB t WHERE (d_datetime between to_date('20130313070000', 'yy-mm-dd hh24:mi:ss') and to_date('20130314060000', 'yy-mm-dd hh24:mi:ss')) and ( D_DATA_ID = 'A.0012.0001.S001' ) ) TB ) WHERE ( MYNUM > 0 )

b9yah4avy5n3c insert into SURF_WEA_CHN_PRE_MIN_TAB(V_BBB, V01301, V01300, V05001, V06001, V07001, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V04005, V13011, Q13011, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , sysdate, to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :20 )

csjqdb3x7sgzf insert into SURF_WEA_C_MUL_MIN_OTH_TAB(V_BBB, V01301, V01300, V05001, V06001, V07001, V07031, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V04005, V10301, V10301_052, V10302, V10302_052, V12011, V12011_052, V12012, V12012_052, V12003, V13007, V13007_052, V13004, V13019, V13033, V11290, V11291, V11292, V11293, V11296, V11042, V11042_052, V11201, V11202, V11211, V11046, V11046_052, V12311, V12311_052, V12121, V12121_052, V12030_080, V12030_160, V12030_320, V12315, V12315_052, V12316, V12316_052, V20001_701_01, V20001_701_10, V20059, V20059_052, Q10301, Q10301_052, Q10302, Q10302_052, Q12011, Q12011_052, Q12012, Q12012_052, Q12003, Q13007, Q13007_052, Q13004, Q13019, Q13033, Q11290, Q11291, Q11292, Q11293, Q11296, Q11042, Q11042_052, Q11201, Q11202, Q11211, Q11046, Q11046_052, Q12311, Q12311_052, Q12121, Q12121_052, Q12030_080, Q12030_160, Q12030_320, Q12315, Q12315_052, Q12316, Q12316_052, Q20001_701_01, Q20001_701_10, Q20059, Q20059_052, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , sysdate, to_date(:99 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:100 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :101 )

d93zvfq19vj9c select SURF_WEA_CHN_REP_seq.nextval from dual

dbp7qgbgvmqgz SELECT mt.inst_id, service_name, TO_CHAR(CAST(begin_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, TO_CHAR(CAST(end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, intsize_csec, group_id, cpupercall, dbtimepercall, callspersec, dbtimepersec FROM gv$servicemetric_history mt , gv$active_services ast WHERE service_name = :p1 AND end_time >= SYSDATE - 5/(60*24) AND group_id = 6 and mt.service_name = ast.name and mt.inst_id = ast.inst_id ORDER BY mt.inst_id asc, end_time DESC

dgyxnnwur743r insert into SATE_ORB_RAW_F_TAB(V01007_01, V01310, V02019_01, V02402, V04001, V04002, V04003, V04004, V04005, V04006, V05040, V05301, V05310, V_CCCC, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_LEVEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_VSTORAGE_SITE, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , sysdate, to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), :20 , :21 , :22 , :23 , :24 , to_date(:25 , 'yyyy-mm-dd HH24:MI:SS'), :26 )

faf45qdmw5k1j insert into SURF_WEA_CHN_REP_TAB(V_BBB, V_CCCC, V_TT, V01301, V01300, V05001, V06001, V_NCODE, V_ACODE, V04001, V04002, V04003, V04004, V04005, V_LEN, V_REPORT, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , sysdate, to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :20 )

fpxk90ad86u1q insert into RADA_CHN_DOR_L3_ST_VW_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , sysdate, to_date(:13 , 'yyyy-mm-dd HH24:MI:SS'), :14 , :15 , :16 , :17 , to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), :19 )

fq3ws1wmh1kpn select Q20013, Q20001, Q20010, Q11001, Q11002, Q12001, Q12003, Q13003, Q10004, Q10051, Q07004, Q10009, Q10063, Q10061, Q13019, Q13011_02, Q13020, Q13021, Q13011_09, Q13022, Q13011_15, Q13011_18, Q13023, Q20003, Q20004, Q20005, Q20011, Q20350_11, Q20350_12, Q20350_13, Q10062, Q12405, Q12014, Q12016, Q12015, Q12017, Q12013, Q20062, Q13013, Q13340, Q14032_01, Q14032_24, Q14016_01, Q14015, Q14021_01, Q14020, Q14023_01, Q14022, Q14002_01, Q14001, Q14004_01, Q14003, Q14025_01, Q14024, Q20054_01, Q20054_02, Q20054_03, Q20012, Q05021, Q07021, Q20012_01, Q20011_01, Q20013_01, Q20012_02, Q20011_02, Q20013_02, Q20012_03, Q20011_03, Q20013_03, Q20012_04, Q20011_04, Q20013_04, Q20063_01, Q20063_02, Q20063_03, D_RECORD_ID from SURF_WEA_GLB_MUL_HOR_TAB where V01301=:1 and V05001=:2 and V06001=:3 and V04001=:4 and V04002=:5 and V04003=:6 and V04004=:7 and V04005=:8 for update

fxps09f8pa4tg select SURF_WEA_GLB_MUL_HOR_seq.nextval from dual

fxs3jmauhy220 select SURF_WEA_C_MUL_MIN_MAIN_seq.nextval from dual

g2qckpurz2mqk insert into RADA_CHN_DOR_L3_ST_VW_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V07021, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , sysdate, to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 , :16 , :17 , :18 , to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), :20 )

gbs98t2pxxma0 update SURF_WEA_CHN_MUL_HOR_TAB set Q10004=:1 , V10004=:2 , Q10051=:3 , V10051=:4 , Q10061=:5 , V10061=:6 , Q10062=:7 , V10062=:8 , Q10301=:9 , V10301=:10 , Q10301_052=:11 , V10301_052=:12 , Q10302=:13 , V10302=:14 , Q10302_052=:15 , V10302_052=:16 , Q12001=:17 , V12001=:18 , Q12011=:19 , V12011=:20 , Q12011_052=:21 , V12011_052=:22 , Q12012=:23 , V12012=:24 , Q12012_052=:25 , V12012_052=:26 , Q12405=:27 , V12405=:28 , Q12016=:29 , V12016=:30 , Q12017=:31 , V12017=:32 , Q12003=:33 , V12003=:34 , Q13003=:35 , V13003=:36 , Q13007=:37 , V13007=:38 , Q13007_052=:39 , V13007_052=:40 , Q13004=:41 , V13004=:42 , Q13019=:43 , V13019=:44 , Q13020=:45 , V13020=:46 , Q13021=:47 , V13021=:48 , Q13022=:49 , V13022=:50 , Q13023=:51 , V13023=:52 , Q04080_04=:53 , V04080_04=:54 , Q13011=:55 , V13011=:56 , Q13033=:57 , V13033=:58 , Q11290=:59 , V11290=:60 , Q11291=:61 , V11291=:62 , Q11292=:63 , V11292=:64 , Q11293=:65 , V11293=:66 , Q11296=:67 , V11296=:68 , Q11042=:69 , V11042=:70 , Q11042_052=:71 , V11042_052=:72 , Q11201=:73 , V11201=:74 , Q11202=:75 , V11202=:76 , Q11211=:77 , V11211=:78 , Q11046=:79 , V11046=:80 , Q11046_052=:81 , V11046_052=:82 , Q11503_06=:83 , V11503_06=:84 , Q11504_06=:85 , V11504_06=:86 , Q11503_12=:87 , V11503_12=:88 , Q11504_12=:89 , V11504_12=:90 , Q12120=:91 , V12120=:92 , Q12311=:93 , V12311=:94 , Q12311_052=:95 , V12311_052=:96 , Q12121=:97 , V12121=:98 , Q12121_052=:99 , V12121_052=:100 , Q12013=:101 , V12013=:102 , Q12030_005=:103 , V12030_005=:104 , Q12030 _010=:105 , V12030_010=:106 , Q12030_015=:107 , V12030_015=:108 , Q12030_020=:109 , V12030_020=:110 , Q12030_040=:111 , V12030_040=:112 , Q12030_080=:113 , V12030_080=:114 , Q12030_160=:115 , V12030_160=:116 , Q12030_320=:117 , V12030_320=:118 , Q12314=:119 , V12314=:120 , Q12315=:121 , V12315=:122 , Q12315_052=:123 , V12315_052=:124 , Q12316=:125 , V12316=:126 , Q12316_052=:127 , V12316_052=:128 , Q20001_701_01=:129 , V20001_701_01=:130 , Q20001_701_10=:131 , V20001_701_10=:132 , Q20059=:133 , V20059=:134 , Q20059_052=:135 , V20059_052=:136 , Q20001=:137 , V20001=:138 , Q20010=:139 , V20010=:140 , Q20051=:141 , V20051=:142 , Q20011=:143 , V20011=:144 , Q20013=:145 , V20013=:146 , Q20350_01=:147 , V20350_01=:148 , Q20350_02=:149 , V20350_02=:150 , Q20350_03=:151 , V20350_03=:152 , Q20350_04=:153 , V20350_04=:154 , Q20350_05=:155 , V20350_05=:156 , Q20350_06=:157 , V20350_06=:158 , Q20350_07=:159 , V20350_07=:160 , Q20350_08=:161 , V20350_08=:162 , Q20350_11=:163 , V20350_11=:164 , Q20350_12=:165 , V20350_12=:166 , Q20350_13=:167 , V20350_13=:168 , Q20003=:169 , V20003=:170 , Q04080_05=:171 , V04080_05=:172 , Q20004=:173 , V20004=:174 , Q20005=:175 , V20005=:176 , Q20062=:177 , V20062=:178 , Q13013=:179 , V13013=:180 , Q13330=:181 , V13330=:182 , Q20330_01=:183 , V20330_01=:184 , Q20331_01=:185 , V20331_01=:186 , Q20330_02=:187 , V20330_02=:188 , Q20331_02=:189 , V20331_02=:190 , D_UPDATE_TIME=sysdate where D_RECORD_ID=:191

gdc07yrmhcwat select SURF_WEA_CHN_MUL_HOR_O_seq.nextval from dual

gfxfu9fgsy7bj insert into SURF_WEA_CHN_MUL_HOR_O_TAB(V_BBB, V01301, V01300, V05001, V06001, V07001, V07031, V07032_04, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V10004, V10051, V10061, V10062, V10301, V10301_052, V10302, V10302_052, V12001, V12011, V12011_052, V12012, V12012_052, V12405, V12016, V12017, V12003, V13003, V13007, V13007_052, V13004, V13019, V13020, V13021, V13022, V13023, V04080_04, V13011, V13033, V11290, V11291, V11292, V11293, V11296, V11042, V11042_052, V11201, V11202, V11211, V11046, V11046_052, V11503_06, V11504_06, V11503_12, V11504_12, V12120, V12311, V12311_052, V12121, V12121_052, V12013, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, V12030_080, V12030_160, V12030_320, V12314, V12315, V12315_052, V12316, V12316_052, V20001_701_01, V20001_701_10, V20059, V20059_052, V20001, V20010, V20051, V20011, V20013, V20350_01, V20350_02, V20350_03, V20350_04, V20350_05, V20350_06, V20350_07, V20350_08, V20350_11, V20350_12, V20350_13, V20003, V04080_05, V20004, V20005, V20062, V13013, V13330, V20330_01, V20331_01, V20330_02, V20331_02, Q10004, Q10051, Q10061, Q10062, Q10301, Q10301_052, Q10302, Q10302_052, Q12001, Q12011, Q12011_052, Q12012, Q12012_052, Q12405, Q12016, Q12017, Q12003, Q13003, Q13007, Q13007_052, Q13004, Q13019, Q13020, Q13021, Q13022, Q13023, Q04080_04, Q13011, Q13033, Q11290, Q11291, Q11292, Q11293, Q11296, Q11042, Q11042_052, Q11201, Q11202, Q11211, Q11046, Q11046_052, Q11503_06, Q11504_06, Q11503_12, Q11504_12, Q12120, Q12311, Q1 2311_052, Q12121, Q12121_052, Q12013, Q12030_005, Q12030_010, Q12030_015, Q12030_020, Q12030_040, Q12030_080, Q12030_160, Q12030_320, Q12314, Q12315, Q12315_052, Q12316, Q12316_052, Q20001_701_01, Q20001_701_10, Q20059, Q20059_052, Q20001, Q20010, Q20051, Q20011, Q20013, Q20350_01, Q20350_02, Q20350_03, Q20350_04, Q20350_05, Q20350_06, Q20350_07, Q20350_08, Q20350_11, Q20350_12, Q20350_13, Q20003, Q04080_05, Q20004, Q20005, Q20062, Q13013, Q13330, Q20330_01, Q20331_01, Q20330_02, Q20331_02, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , :206 , sysdate, to_date(:207 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:208 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :209 )

gqvt3zxmq3k53 SELECT COLUMN_NAME, DATA_TYPE, DATA_SCALE FROM DBA_TAB_COLUMNS WHERE TABLE_NAME in ( 'SURF_WEA_CHN_MUL_HOR_TAB' ) AND OWNER = 'CIMISS' ORDER BY COLUMN_NAME

SQL Id	SQL Text
019u8pu0dfk5b	select count(1), sum(D_FILE_SIZE) from RADA_CHN_DOR_L3_PUP_F_TAB WHERE (( ( D_DATA_ID LIKE '%J.0003.0001%' AND V07021 = '15' ) OR ( D_DATA_ID LIKE '%J.0003.0001%' AND V07021 = '24' ) OR ( D_DATA_ID LIKE '%J.0003.0001%' AND V07021 = '5' ) OR ( D_DATA_ID LIKE '%J.0003.0002%' AND V07021 = '5' ) OR ( D_DATA_ID LIKE '%J.0003.0002%' AND V07021 = '24' ) OR ( D_DATA_ID LIKE '%J.0003.0002%' AND V07021 = '15' ) OR ( D_DATA_ID LIKE '%J.0003.0003%' ) OR ( D_DATA_ID LIKE '%J.0003.0004%' ) OR ( D_DATA_ID LIKE '%J.0003.0005%' ) OR ( D_DATA_ID LIKE '%J.0003.0006%' ) OR ( D_DATA_ID LIKE '%J.0003.0007%' ) OR ( D_DATA_ID LIKE '%J.0003.0008%' ) OR ( D_DATA_ID LIKE '%J.0003.0009%' ) OR ( D_DATA_ID LIKE '%J.0003.0010%' ) OR ( D_DATA_ID LIKE '%J.0003.0011%' ) OR ( D_DATA_ID LIKE '%J.0003.0012%' ) OR ( D_DATA_ID LIKE '%J.0003.0013%' ) OR ( D_DATA_ID LIKE '%J.0003.0014%' ) ))and(V01301 in ('Z9001', 'Z9010'))and(d_datetime between to_date('20130313152335', 'yy-mm-dd hh24:mi:ss') and to_date('20130314152335', 'yy-mm-dd hh24:mi:ss'))
063412ux1n026	select RADA_CHN_DOR_L3_ST_VW_F_seq.nextval from dual
0zha71gxcgdvd	insert into UPAR_ARD_GLB_MUL_MUT_AMD_TAB(V_BBB, V04001_02, V04002_02, V04003_02, V04004_02, V04005_02, V01301, V05001, V06001, V04001, V04002, V04003, V04004, V04005, V04006, V07010, V07002, V08009, V12001, V12003, V13003, V11001, V11002, V11031, V02061, V02062, V02005, V11036, Q07010, Q07002, Q08009, Q12001, Q12003, Q13003, Q11001, Q11002, Q11031, Q02061, Q02062, Q02005, Q11036, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , sysdate, to_date(:43 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:44 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :45 )
1rnmj1y7wwjbv	delete from OCEN_TSC_GLB_MUL_TAB where D_RECORD_ID=:1
1t9gwmb77gkpu	insert into SURF_WEA_CHN_MUL_HOR_TAB(V01301, V01300, V05001, V06001, V07001, V07031, V07032_04, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V10004, V10051, V10061, V10062, V10301, V10301_052, V10302, V10302_052, V12001, V12011, V12011_052, V12012, V12012_052, V12405, V12016, V12017, V12003, V13003, V13007, V13007_052, V13004, V13019, V13020, V13021, V13022, V13023, V04080_04, V13011, V13033, V11290, V11291, V11292, V11293, V11296, V11042, V11042_052, V11201, V11202, V11211, V11046, V11046_052, V11503_06, V11504_06, V11503_12, V11504_12, V12120, V12311, V12311_052, V12121, V12121_052, V12013, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, V12030_080, V12030_160, V12030_320, V12314, V12315, V12315_052, V12316, V12316_052, V20001_701_01, V20001_701_10, V20059, V20059_052, V20001, V20010, V20051, V20011, V20013, V20350_01, V20350_02, V20350_03, V20350_04, V20350_05, V20350_06, V20350_07, V20350_08, V20350_11, V20350_12, V20350_13, V20003, V04080_05, V20004, V20005, V20062, V13013, V13330, V20330_01, V20331_01, V20330_02, V20331_02, Q10004, Q10051, Q10061, Q10062, Q10301, Q10301_052, Q10302, Q10302_052, Q12001, Q12011, Q12011_052, Q12012, Q12012_052, Q12405, Q12016, Q12017, Q12003, Q13003, Q13007, Q13007_052, Q13004, Q13019, Q13020, Q13021, Q13022, Q13023, Q04080_04, Q13011, Q13033, Q11290, Q11291, Q11292, Q11293, Q11296, Q11042, Q11042_052, Q11201, Q11202, Q11211, Q11046, Q11046_052, Q11503_06, Q11504_06, Q11503_12, Q11504_12, Q12120, Q12311, Q12311_052, Q12121, Q12121_052, Q12013, Q12030_005, Q12030_010, Q12030_015, Q12030_020, Q12030_040, Q12030_080, Q12030_160, Q12030_320, Q12314, Q12315, Q12315_052, Q12316, Q12316_052, Q20001_701_01, Q20001_701_10, Q20059, Q20059_052, Q20001, Q20010, Q20051, Q20011, Q20013, Q20350_01, Q20350_02, Q20350_03, Q20350_04, Q20350_05, Q20350_06, Q20350_07, Q20350_08, Q20350_11, Q20350_12, Q20350_13, Q20003, Q04080_05, Q20004, Q20005, Q20062, Q13013, Q13330, Q20330_01, Q20331_01, Q20330_02, Q20331_02, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , sysdate, to_date(:206 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:207 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :208 )
1u8cb2ybu33hh	select V_BBB from OCEN_TSC_GLB_MUL_O_K_TAB where V01301=:1 and V05001=:2 and V06001=:3 and V04001=:4 and V04002=:5 and V04003=:6 and V04004=:7 and V04005=:8 and D_DATA_ID=:9
2h3h5j29r9zhw	insert into RADA_CHN_DOR_L3_ST_PD_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V07021, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , sysdate, to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 , :16 , :17 , :18 , to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), :20 )
2skwhauh2cwky	select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
3cq5ad9qn6x8h	insert into RADA_CHN_DOR_L3_ST_VW_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V10002, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , sysdate, to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 , :16 , :17 , :18 , to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), :20 )
4a6fqxy161t8r	insert into RADA_CHN_DOR_L2_QC_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_RADAR_MODEL, V_SCANNING_MODE, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , sysdate, to_date(:13 , 'yyyy-mm-dd HH24:MI:SS'), :14 , :15 , :16 , :17 , to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), :19 )
4gjq0xf0rw497	SELECT /+ cardinality(d 20) / MAX(MGMT_GLOBAL.ADJUST_TZ(MARKER_TIMESTAMP, T.TIMEZONE_REGION, :B3 )) FROM MGMT_AVAILABILITY_MARKER M, MGMT_TARGETS T, TABLE(CAST(:B1 AS MGMT_METRIC_DETAILS_ARRAY)) D WHERE T.TARGET_GUID = M.TARGET_GUID AND T.TARGET_GUID = D.TARGET_GUID AND M.MARKER_AVAIL_STATUS = :B2
4m7g0041v4jtj	select SURF_WEA_GLB_MUL_HOR_O_seq.nextval from dual
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
55dn7dk4cmcwk	select Q10004, Q10051, Q10061, Q10062, Q10301, Q10301_052, Q10302, Q10302_052, Q12001, Q12011, Q12011_052, Q12012, Q12012_052, Q12405, Q12016, Q12017, Q12003, Q13003, Q13007, Q13007_052, Q13004, Q13019, Q13020, Q13021, Q13022, Q13023, Q04080_04, Q13011, Q13033, Q11290, Q11291, Q11292, Q11293, Q11296, Q11042, Q11042_052, Q11201, Q11202, Q11211, Q11046, Q11046_052, Q11503_06, Q11504_06, Q11503_12, Q11504_12, Q12120, Q12311, Q12311_052, Q12121, Q12121_052, Q12013, Q12030_005, Q12030_010, Q12030_015, Q12030_020, Q12030_040, Q12030_080, Q12030_160, Q12030_320, Q12314, Q12315, Q12315_052, Q12316, Q12316_052, Q20001_701_01, Q20001_701_10, Q20059, Q20059_052, Q20001, Q20010, Q20051, Q20011, Q20013, Q20350_01, Q20350_02, Q20350_03, Q20350_04, Q20350_05, Q20350_06, Q20350_07, Q20350_08, Q20350_11, Q20350_12, Q20350_13, Q20003, Q04080_05, Q20004, Q20005, Q20062, Q13013, Q13330, Q20330_01, Q20331_01, Q20330_02, Q20331_02, D_RECORD_ID from SURF_WEA_CHN_MUL_HOR_TAB where V01301=:1 and V05001=:2 and V06001=:3 and V04001=:4 and V04002=:5 and V04003=:6 and V04004=:7 for update
5ba4r4a9s15h1	select SURF_WEA_C_MUL_MIN_OTH_seq.nextval from dual
5xrq60dyjjrz4	SELECT * FROM ( SELECT ROWNUM MYNUM, TB.* FROM ( SELECT V01300, V02301, V04001, V04002, V04003, V04004, V04005, V05001, V06001, V07001, V11046, V11211, V13011_24, V13013, V13019, V13020, V13021, V20001, V20003, V20066, V20302_017, V20326, V20401, V20402, V01301, V_ACODE FROM SURF_WEA_CHN_MUL_FTM_WSET_TAB t WHERE ((V_ACODE >= 420000 and V_ACODE <= 429999) or (V_ACODE >= 430000 and V_ACODE <= 439999))and(d_datetime between to_date('20121201000000', 'yy-mm-dd hh24:mi:ss') and to_date('20121202235959', 'yy-mm-dd hh24:mi:ss')) and ( D_DATA_ID = 'A.0024.0001.S001' ) ) TB ) WHERE ( MYNUM > 0 )
5yjnyp1yr49kv	SELECT * FROM ( SELECT ROWNUM MYNUM, TB.* FROM ( SELECT V01300, V02301, V04001, V04002, V04003, V04004, V04005, V05001, V06001, V07001, V11046, V11211, V13011_24, V13013, V13019, V13020, V13021, V20001, V20003, V20066, V20302_017, V20326, V20401, V20402, V01301, V_ACODE FROM SURF_WEA_CHN_MUL_FTM_WSET_TAB t WHERE (V05001 >= 30 AND V05001 <= 45 AND V06001 >= 90 AND V06001 <= 110)and(d_datetime between to_date('20121128000000', 'yy-mm-dd hh24:mi:ss') and to_date('20121129235959', 'yy-mm-dd hh24:mi:ss') or d_datetime between to_date('20121201000000', 'yy-mm-dd hh24:mi:ss') and to_date('20121203235959', 'yy-mm-dd hh24:mi:ss')) and ( D_DATA_ID = 'A.0024.0001.S001' ) ) TB ) WHERE ( MYNUM > 0 )
6cnp4yajja560	select count(1), sum(D_FILE_SIZE) from NAFP_T639_FOR_FTM_F_TAB WHERE (d_datetime between to_date('20130314000000', 'yy-mm-dd hh24:mi:ss') and to_date('20130314000000', 'yy-mm-dd hh24:mi:ss')) and D_DATA_ID = 'F.0003.0001.S001'
7duj5j208p6ad	insert into RADA_CHN_DOR_L3_ST_PD_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , sysdate, to_date(:13 , 'yyyy-mm-dd HH24:MI:SS'), :14 , :15 , :16 , :17 , to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), :19 )
7gtztzv329wg0	select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
7pc9byd9t453f	select UPAR_FILE_DATA_F_seq.nextval from dual
7v922w0gt4jsc	select SURF_WEA_CHN_MUL_HOR_seq.nextval from dual
7xz67tyjpuzf0	select a.tablespace_name, trunc(a.totalspace / 1024 / 1024 / 1024, 2) totalspace, trunc(1-b.freespace/a.totalspace, 2) usepert from (select tablespace_name, sum(bytes) totalspace from dba_data_files ddf where tablespace_name not in ('SYSTEM', 'SYSAUX') group by tablespace_name) a, (select tablespace_name, sum(bytes) freespace from dba_free_space dfs where tablespace_name not in ('SYSTEM', 'SYSAUX') group by tablespace_name) b where a.tablespace_name = b.tablespace_name
86pf4un9055xs	SELECT * FROM ( SELECT ROWNUM MYNUM, TB.* FROM ( SELECT V01300, V02301, V04001, V04002, V04003, V04004, V04005, V05001, V06001, V07001, V11046, V11211, V13011_24, V13013, V13019, V13020, V13021, V20001, V20003, V20066, V20302_017, V20326, V20401, V20402, V01301, V_ACODE FROM SURF_WEA_CHN_MUL_FTM_WSET_TAB t WHERE (V01301 in ('53698'))and(d_datetime between to_date('20121101000000', 'yy-mm-dd hh24:mi:ss') and to_date('20121231235959', 'yy-mm-dd hh24:mi:ss')) and ( D_DATA_ID = 'A.0024.0001.S001' ) ) TB ) WHERE ( MYNUM > 0 )
8axyb930js92v	insert into UPAR_GPS_C_F_TAB(V01300, V04001, V04002, V04003, V04004, V04005, V04300, V_FILE_NAME, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , sysdate, to_date(:9 , 'yyyy-mm-dd HH24:MI:SS'), :10 , :11 , :12 , :13 , to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 )
8usxu4fh2qmtr	insert into RADA_CHN_DOR_L2_FMT_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_RADAR_MODEL, V_SCANNING_MODE, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , sysdate, to_date(:13 , 'yyyy-mm-dd HH24:MI:SS'), :14 , :15 , :16 , :17 , to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), :19 )
8ynj1nfjyy4qu	insert into SURF_WEA_CHN_MUL_HOR_I_TAB(I10004, I10051, I10061, I10062, I10301, I10301_052, I10302, I10302_052, I12001, I12011, I12011_052, I12012, I12012_052, I12405, I12016, I12017, I12003, I13003, I13007, I13007_052, I13004, I13019, I13020, I13021, I13022, I13023, I04080_04, I13011, I13033, I11290, I11291, I11292, I11293, I11296, I11042, I11042_052, I11201, I11202, I11211, I11046, I11046_052, I11503_06, I11504_06, I11503_12, I11504_12, I12120, I12311, I12311_052, I12121, I12121_052, I12013, I12030_005, I12030_010, I12030_015, I12030_020, I12030_040, I12030_080, I12030_160, I12030_320, I12314, I12315, I12315_052, I12316, I12316_052, I20001_701_01, I20001_701_10, I20059, I20059_052, I20001, I20010, I20051, I20011, I20013, I20350_01, I20350_02, I20350_03, I20350_04, I20350_05, I20350_06, I20350_07, I20350_08, I20350_11, I20350_12, I20350_13, I20003, I04080_05, I20004, I20005, I20062, I13013, I13330, I20330_01, I20331_01, I20330_02, I20331_02, D_DATETIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , to_date(:96 , 'yyyy-mm-dd HH24:MI:SS'), :97 )
921wc95x40hk2	select SURF_WEA_CHN_PRE_MIN_seq.nextval from dual
9mg29jx94d5f7	insert into OCEN_BUOY_C_FTM_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_NAME, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , sysdate, to_date(:9 , 'yyyy-mm-dd HH24:MI:SS'), :10 , :11 , :12 , :13 , to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 )
9p6frhrxfnc2t	insert into SURF_WEA_C_MUL_MIN_MAIN_TAB(V_BBB, V01301, V01300, V05001, V06001, V07001, V07031, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V04005, V10004, V12001, V13003, V11288, V11289, V12314, V12120, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, Q10004, Q12001, Q13003, Q11288, Q11289, Q12314, Q12120, Q12030_005, Q12030_010, Q12030_015, Q12030_020, Q12030_040, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , sysdate, to_date(:41 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:42 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :43 )
9tcvnq0hdspsa	select RADA_CHN_DOR_L3_ST_PD_F_seq.nextval from dual
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
a5vw0yk0gpkjp	select RADA_CHN_DOR_L3_PUP_F_seq.nextval from dual
a90mvyvbmpys6	insert into SURF_WEA_GLB_MUL_HOR_TAB(V04001_02, V04002_02, V04003_02, V04004_02, V01301, V01300, V05001, V06001, V07001, V07031, V07032_01, V07032_02, V07032_03, V07032_04, V02002, V02004, V02001, V_NCODE, V01015, V04001, V04002, V04003, V04004, V04005, V20013, V20001, V20010, V11001, V11002, V12001, V12003, V13003, V10004, V10051, V07004, V10009, V10063, V10061, V13019, V13011_02, V13020, V13021, V13011_09, V13022, V13011_15, V13011_18, V13023, V20003, V20004, V20005, V20011, V20350_11, V20350_12, V20350_13, V10062, V12405, V12014, V12016, V12015, V12017, V12013, V20062, V13013, V13340, V14032_01, V14032_24, V14016_01, V14015, V14021_01, V14020, V14023_01, V14022, V14002_01, V14001, V14004_01, V14003, V14025_01, V14024, V20054_01, V20054_02, V20054_03, V20012, V05021, V07021, V20012_01, V20011_01, V20013_01, V20012_02, V20011_02, V20013_02, V20012_03, V20011_03, V20013_03, V20012_04, V20011_04, V20013_04, V20063_01, V20063_02, V20063_03, Q20013, Q20001, Q20010, Q11001, Q11002, Q12001, Q12003, Q13003, Q10004, Q10051, Q07004, Q10009, Q10063, Q10061, Q13019, Q13011_02, Q13020, Q13021, Q13011_09, Q13022, Q13011_15, Q13011_18, Q13023, Q20003, Q20004, Q20005, Q20011, Q20350_11, Q20350_12, Q20350_13, Q10062, Q12405, Q12014, Q12016, Q12015, Q12017, Q12013, Q20062, Q13013, Q13340, Q14032_01, Q14032_24, Q14016_01, Q14015, Q14021_01, Q14020, Q14023_01, Q14022, Q14002_01, Q14001, Q14004_01, Q14003, Q14025_01, Q14024, Q20054_01, Q20054_02, Q20054_03, Q20012, Q05021, Q07021, Q20012_01, Q2 0011_01, Q20013_01, Q20012_02, Q20011_02, Q20013_02, Q20012_03, Q20011_03, Q20013_03, Q20012_04, Q20011_04, Q20013_04, Q20063_01, Q20063_02, Q20063_03, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , sysdate, to_date(:176 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:177 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :178 )
ab3swhv5g138y	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
arx2rgss6k33m	SELECT s.inst_id, s.name, i.instance_name FROM gv$active_services s, gv$instance i WHERE s.name = :p1 AND s.inst_id = i.inst_id
awfzp9zc8swfu	insert into RADA_CHN_DOR_L3_PUP_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V07021, V_COVERING_AREA, V_DPI, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , sysdate, to_date(:16 , 'yyyy-mm-dd HH24:MI:SS'), :17 , :18 , :19 , :20 , to_date(:21 , 'yyyy-mm-dd HH24:MI:SS'), :22 )
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b9rdqhhfpx6w3	SELECT COUNT(1) FROM ( SELECT ROWNUM MYNUM, TB.* FROM ( SELECT D_DATETIME, V12001 FROM SURF_WEA_CHN_MUL_HOR_TAB t WHERE (d_datetime between to_date('20130313070000', 'yy-mm-dd hh24:mi:ss') and to_date('20130314060000', 'yy-mm-dd hh24:mi:ss')) and ( D_DATA_ID = 'A.0012.0001.S001' ) ) TB ) WHERE ( MYNUM > 0 )
b9yah4avy5n3c	insert into SURF_WEA_CHN_PRE_MIN_TAB(V_BBB, V01301, V01300, V05001, V06001, V07001, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V04005, V13011, Q13011, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , sysdate, to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :20 )
csjqdb3x7sgzf	insert into SURF_WEA_C_MUL_MIN_OTH_TAB(V_BBB, V01301, V01300, V05001, V06001, V07001, V07031, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V04005, V10301, V10301_052, V10302, V10302_052, V12011, V12011_052, V12012, V12012_052, V12003, V13007, V13007_052, V13004, V13019, V13033, V11290, V11291, V11292, V11293, V11296, V11042, V11042_052, V11201, V11202, V11211, V11046, V11046_052, V12311, V12311_052, V12121, V12121_052, V12030_080, V12030_160, V12030_320, V12315, V12315_052, V12316, V12316_052, V20001_701_01, V20001_701_10, V20059, V20059_052, Q10301, Q10301_052, Q10302, Q10302_052, Q12011, Q12011_052, Q12012, Q12012_052, Q12003, Q13007, Q13007_052, Q13004, Q13019, Q13033, Q11290, Q11291, Q11292, Q11293, Q11296, Q11042, Q11042_052, Q11201, Q11202, Q11211, Q11046, Q11046_052, Q12311, Q12311_052, Q12121, Q12121_052, Q12030_080, Q12030_160, Q12030_320, Q12315, Q12315_052, Q12316, Q12316_052, Q20001_701_01, Q20001_701_10, Q20059, Q20059_052, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , sysdate, to_date(:99 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:100 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :101 )
d93zvfq19vj9c	select SURF_WEA_CHN_REP_seq.nextval from dual
dbp7qgbgvmqgz	SELECT mt.inst_id, service_name, TO_CHAR(CAST(begin_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, TO_CHAR(CAST(end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') time, intsize_csec, group_id, cpupercall, dbtimepercall, callspersec, dbtimepersec FROM gv$servicemetric_history mt , gv$active_services ast WHERE service_name = :p1 AND end_time >= SYSDATE - 5/(60*24) AND group_id = 6 and mt.service_name = ast.name and mt.inst_id = ast.inst_id ORDER BY mt.inst_id asc, end_time DESC
dgyxnnwur743r	insert into SATE_ORB_RAW_F_TAB(V01007_01, V01310, V02019_01, V02402, V04001, V04002, V04003, V04004, V04005, V04006, V05040, V05301, V05310, V_CCCC, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_LEVEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_VSTORAGE_SITE, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , sysdate, to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), :20 , :21 , :22 , :23 , :24 , to_date(:25 , 'yyyy-mm-dd HH24:MI:SS'), :26 )
faf45qdmw5k1j	insert into SURF_WEA_CHN_REP_TAB(V_BBB, V_CCCC, V_TT, V01301, V01300, V05001, V06001, V_NCODE, V_ACODE, V04001, V04002, V04003, V04004, V04005, V_LEN, V_REPORT, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , sysdate, to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :20 )
fpxk90ad86u1q	insert into RADA_CHN_DOR_L3_ST_VW_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , sysdate, to_date(:13 , 'yyyy-mm-dd HH24:MI:SS'), :14 , :15 , :16 , :17 , to_date(:18 , 'yyyy-mm-dd HH24:MI:SS'), :19 )
fq3ws1wmh1kpn	select Q20013, Q20001, Q20010, Q11001, Q11002, Q12001, Q12003, Q13003, Q10004, Q10051, Q07004, Q10009, Q10063, Q10061, Q13019, Q13011_02, Q13020, Q13021, Q13011_09, Q13022, Q13011_15, Q13011_18, Q13023, Q20003, Q20004, Q20005, Q20011, Q20350_11, Q20350_12, Q20350_13, Q10062, Q12405, Q12014, Q12016, Q12015, Q12017, Q12013, Q20062, Q13013, Q13340, Q14032_01, Q14032_24, Q14016_01, Q14015, Q14021_01, Q14020, Q14023_01, Q14022, Q14002_01, Q14001, Q14004_01, Q14003, Q14025_01, Q14024, Q20054_01, Q20054_02, Q20054_03, Q20012, Q05021, Q07021, Q20012_01, Q20011_01, Q20013_01, Q20012_02, Q20011_02, Q20013_02, Q20012_03, Q20011_03, Q20013_03, Q20012_04, Q20011_04, Q20013_04, Q20063_01, Q20063_02, Q20063_03, D_RECORD_ID from SURF_WEA_GLB_MUL_HOR_TAB where V01301=:1 and V05001=:2 and V06001=:3 and V04001=:4 and V04002=:5 and V04003=:6 and V04004=:7 and V04005=:8 for update
fxps09f8pa4tg	select SURF_WEA_GLB_MUL_HOR_seq.nextval from dual
fxs3jmauhy220	select SURF_WEA_C_MUL_MIN_MAIN_seq.nextval from dual
g2qckpurz2mqk	insert into RADA_CHN_DOR_L3_ST_VW_F_TAB(V01301, V04001, V04002, V04003, V04004, V04005, V04006, V07021, V_FILE_FORMAT, V_FILE_NAME, V_FILE_NAME_SOURCE, V_PROD_TYPE, V_RADAR_MODEL, D_IYMDHM, D_RYMDHM, D_DATA_ID, D_STORAGE_SITE, D_FILE_SIZE, D_FILE_SAVE_HIERARCHY, D_DATETIME, D_FILE_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , sysdate, to_date(:14 , 'yyyy-mm-dd HH24:MI:SS'), :15 , :16 , :17 , :18 , to_date(:19 , 'yyyy-mm-dd HH24:MI:SS'), :20 )
gbs98t2pxxma0	update SURF_WEA_CHN_MUL_HOR_TAB set Q10004=:1 , V10004=:2 , Q10051=:3 , V10051=:4 , Q10061=:5 , V10061=:6 , Q10062=:7 , V10062=:8 , Q10301=:9 , V10301=:10 , Q10301_052=:11 , V10301_052=:12 , Q10302=:13 , V10302=:14 , Q10302_052=:15 , V10302_052=:16 , Q12001=:17 , V12001=:18 , Q12011=:19 , V12011=:20 , Q12011_052=:21 , V12011_052=:22 , Q12012=:23 , V12012=:24 , Q12012_052=:25 , V12012_052=:26 , Q12405=:27 , V12405=:28 , Q12016=:29 , V12016=:30 , Q12017=:31 , V12017=:32 , Q12003=:33 , V12003=:34 , Q13003=:35 , V13003=:36 , Q13007=:37 , V13007=:38 , Q13007_052=:39 , V13007_052=:40 , Q13004=:41 , V13004=:42 , Q13019=:43 , V13019=:44 , Q13020=:45 , V13020=:46 , Q13021=:47 , V13021=:48 , Q13022=:49 , V13022=:50 , Q13023=:51 , V13023=:52 , Q04080_04=:53 , V04080_04=:54 , Q13011=:55 , V13011=:56 , Q13033=:57 , V13033=:58 , Q11290=:59 , V11290=:60 , Q11291=:61 , V11291=:62 , Q11292=:63 , V11292=:64 , Q11293=:65 , V11293=:66 , Q11296=:67 , V11296=:68 , Q11042=:69 , V11042=:70 , Q11042_052=:71 , V11042_052=:72 , Q11201=:73 , V11201=:74 , Q11202=:75 , V11202=:76 , Q11211=:77 , V11211=:78 , Q11046=:79 , V11046=:80 , Q11046_052=:81 , V11046_052=:82 , Q11503_06=:83 , V11503_06=:84 , Q11504_06=:85 , V11504_06=:86 , Q11503_12=:87 , V11503_12=:88 , Q11504_12=:89 , V11504_12=:90 , Q12120=:91 , V12120=:92 , Q12311=:93 , V12311=:94 , Q12311_052=:95 , V12311_052=:96 , Q12121=:97 , V12121=:98 , Q12121_052=:99 , V12121_052=:100 , Q12013=:101 , V12013=:102 , Q12030_005=:103 , V12030_005=:104 , Q12030 _010=:105 , V12030_010=:106 , Q12030_015=:107 , V12030_015=:108 , Q12030_020=:109 , V12030_020=:110 , Q12030_040=:111 , V12030_040=:112 , Q12030_080=:113 , V12030_080=:114 , Q12030_160=:115 , V12030_160=:116 , Q12030_320=:117 , V12030_320=:118 , Q12314=:119 , V12314=:120 , Q12315=:121 , V12315=:122 , Q12315_052=:123 , V12315_052=:124 , Q12316=:125 , V12316=:126 , Q12316_052=:127 , V12316_052=:128 , Q20001_701_01=:129 , V20001_701_01=:130 , Q20001_701_10=:131 , V20001_701_10=:132 , Q20059=:133 , V20059=:134 , Q20059_052=:135 , V20059_052=:136 , Q20001=:137 , V20001=:138 , Q20010=:139 , V20010=:140 , Q20051=:141 , V20051=:142 , Q20011=:143 , V20011=:144 , Q20013=:145 , V20013=:146 , Q20350_01=:147 , V20350_01=:148 , Q20350_02=:149 , V20350_02=:150 , Q20350_03=:151 , V20350_03=:152 , Q20350_04=:153 , V20350_04=:154 , Q20350_05=:155 , V20350_05=:156 , Q20350_06=:157 , V20350_06=:158 , Q20350_07=:159 , V20350_07=:160 , Q20350_08=:161 , V20350_08=:162 , Q20350_11=:163 , V20350_11=:164 , Q20350_12=:165 , V20350_12=:166 , Q20350_13=:167 , V20350_13=:168 , Q20003=:169 , V20003=:170 , Q04080_05=:171 , V04080_05=:172 , Q20004=:173 , V20004=:174 , Q20005=:175 , V20005=:176 , Q20062=:177 , V20062=:178 , Q13013=:179 , V13013=:180 , Q13330=:181 , V13330=:182 , Q20330_01=:183 , V20330_01=:184 , Q20331_01=:185 , V20331_01=:186 , Q20330_02=:187 , V20330_02=:188 , Q20331_02=:189 , V20331_02=:190 , D_UPDATE_TIME=sysdate where D_RECORD_ID=:191
gdc07yrmhcwat	select SURF_WEA_CHN_MUL_HOR_O_seq.nextval from dual
gfxfu9fgsy7bj	insert into SURF_WEA_CHN_MUL_HOR_O_TAB(V_BBB, V01301, V01300, V05001, V06001, V07001, V07031, V07032_04, V02001, V02301, V_ACODE, V04001, V04002, V04003, V04004, V10004, V10051, V10061, V10062, V10301, V10301_052, V10302, V10302_052, V12001, V12011, V12011_052, V12012, V12012_052, V12405, V12016, V12017, V12003, V13003, V13007, V13007_052, V13004, V13019, V13020, V13021, V13022, V13023, V04080_04, V13011, V13033, V11290, V11291, V11292, V11293, V11296, V11042, V11042_052, V11201, V11202, V11211, V11046, V11046_052, V11503_06, V11504_06, V11503_12, V11504_12, V12120, V12311, V12311_052, V12121, V12121_052, V12013, V12030_005, V12030_010, V12030_015, V12030_020, V12030_040, V12030_080, V12030_160, V12030_320, V12314, V12315, V12315_052, V12316, V12316_052, V20001_701_01, V20001_701_10, V20059, V20059_052, V20001, V20010, V20051, V20011, V20013, V20350_01, V20350_02, V20350_03, V20350_04, V20350_05, V20350_06, V20350_07, V20350_08, V20350_11, V20350_12, V20350_13, V20003, V04080_05, V20004, V20005, V20062, V13013, V13330, V20330_01, V20331_01, V20330_02, V20331_02, Q10004, Q10051, Q10061, Q10062, Q10301, Q10301_052, Q10302, Q10302_052, Q12001, Q12011, Q12011_052, Q12012, Q12012_052, Q12405, Q12016, Q12017, Q12003, Q13003, Q13007, Q13007_052, Q13004, Q13019, Q13020, Q13021, Q13022, Q13023, Q04080_04, Q13011, Q13033, Q11290, Q11291, Q11292, Q11293, Q11296, Q11042, Q11042_052, Q11201, Q11202, Q11211, Q11046, Q11046_052, Q11503_06, Q11504_06, Q11503_12, Q11504_12, Q12120, Q12311, Q1 2311_052, Q12121, Q12121_052, Q12013, Q12030_005, Q12030_010, Q12030_015, Q12030_020, Q12030_040, Q12030_080, Q12030_160, Q12030_320, Q12314, Q12315, Q12315_052, Q12316, Q12316_052, Q20001_701_01, Q20001_701_10, Q20059, Q20059_052, Q20001, Q20010, Q20051, Q20011, Q20013, Q20350_01, Q20350_02, Q20350_03, Q20350_04, Q20350_05, Q20350_06, Q20350_07, Q20350_08, Q20350_11, Q20350_12, Q20350_13, Q20003, Q04080_05, Q20004, Q20005, Q20062, Q13013, Q13330, Q20330_01, Q20331_01, Q20330_02, Q20331_02, D_DATA_ID, D_IYMDHM, D_RYMDHM, D_DATETIME, D_UPDATE_TIME, D_RECORD_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 , :116 , :117 , :118 , :119 , :120 , :121 , :122 , :123 , :124 , :125 , :126 , :127 , :128 , :129 , :130 , :131 , :132 , :133 , :134 , :135 , :136 , :137 , :138 , :139 , :140 , :141 , :142 , :143 , :144 , :145 , :146 , :147 , :148 , :149 , :150 , :151 , :152 , :153 , :154 , :155 , :156 , :157 , :158 , :159 , :160 , :161 , :162 , :163 , :164 , :165 , :166 , :167 , :168 , :169 , :170 , :171 , :172 , :173 , :174 , :175 , :176 , :177 , :178 , :179 , :180 , :181 , :182 , :183 , :184 , :185 , :186 , :187 , :188 , :189 , :190 , :191 , :192 , :193 , :194 , :195 , :196 , :197 , :198 , :199 , :200 , :201 , :202 , :203 , :204 , :205 , :206 , sysdate, to_date(:207 , 'yyyy-mm-dd HH24:MI:SS'), to_date(:208 , 'yyyy-mm-dd HH24:MI:SS'), sysdate, :209 )
gqvt3zxmq3k53	SELECT COLUMN_NAME, DATA_TYPE, DATA_SCALE FROM DBA_TAB_COLUMNS WHERE TABLE_NAME in ( 'SURF_WEA_CHN_MUL_HOR_TAB' ) AND OWNER = 'CIMISS' ORDER BY COLUMN_NAME

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	12,437	3.42	0.05
CCursor + sql area evicted	5	0.00	0.00
CPU used by this session	168,442	46.35	0.62
CPU used when call started	146,077	40.20	0.54
CR blocks created	110,290	30.35	0.41
Cached Commit SCN referenced	25,403	6.99	0.09
Commit SCN cached	71,411	19.65	0.26
DB time	1,783,370	490.76	6.60
DBWR checkpoint buffers written	437,635	120.43	1.62
DBWR checkpoints	55	0.02	0.00
DBWR fusion writes	63,883	17.58	0.24
DBWR object drop buffers written	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	423,378	116.51	1.57
DBWR transaction table writes	4,299	1.18	0.02
DBWR undo block writes	259,279	71.35	0.96
DFO trees parallelized	17	0.00	0.00
HSC Heap Segment Block Changes	3,511,718	966.38	13.00
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	3,323,874	914.68	12.31
Heap Segment Array Updates	451	0.12	0.00
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	44	0.01	0.00
PX local messages sent	44	0.01	0.00
PX remote messages recv'd	888	0.24	0.00
PX remote messages sent	888	0.24	0.00
Parallel operations not downgraded	17	0.00	0.00
RowCR - row contention	1	0.00	0.00
RowCR attempts	7,307	2.01	0.03
RowCR hits	7,306	2.01	0.03
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	106	0.03	0.00
SQL*Net roundtrips to/from client	3,447,322	948.65	12.77
active txn count during cleanout	2,734,535	752.51	10.13
application wait time	9,009	2.48	0.03
background checkpoints completed	49	0.01	0.00
background checkpoints started	53	0.01	0.00
background timeouts	30,584	8.42	0.11
branch node splits	186	0.05	0.00
buffer is not pinned count	15,844,964	4,360.31	58.68
buffer is pinned count	18,198,755	5,008.04	67.39
bytes received via SQL*Net from client	2,142,406,937	589,560.52	7,933.61
bytes sent via SQL*Net to client	1,420,898,937	391,011.58	5,261.77
calls to get snapshot scn: kcmgss	6,171,046	1,698.19	22.85
calls to kcmgas	1,712,990	471.39	6.34
calls to kcmgcs	4,610,847	1,268.84	17.07
cell physical IO interconnect bytes	22,414,810,112	6,168,243.28	83,004.90
change write time	20,947	5.76	0.08
cleanout - number of ktugct calls	2,048,701	563.77	7.59
cleanouts only - consistent read gets	10,285	2.83	0.04
cluster key scan block gets	1,822,846	501.62	6.75
cluster key scans	1,514,533	416.78	5.61
cluster wait time	527,795	145.24	1.95
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	5,944	1.64	0.02
commit batch/immediate requested	5,944	1.64	0.02
commit cleanout failures: block lost	76,976	21.18	0.29
commit cleanout failures: buffer being written	284	0.08	0.00
commit cleanout failures: callback failure	19,594	5.39	0.07
commit cleanout failures: cannot pin	3,721	1.02	0.01
commit cleanouts	1,848,723	508.74	6.85
commit cleanouts successfully completed	1,748,148	481.07	6.47
commit immediate performed	5,944	1.64	0.02
commit immediate requested	5,944	1.64	0.02
commit txn count during cleanout	489,633	134.74	1.81
concurrency wait time	473,012	130.17	1.75
consistent changes	16,594	4.57	0.06
consistent gets	32,660,282	8,987.65	120.95
consistent gets - examination	8,077,670	2,222.86	29.91
consistent gets direct	0	0.00	0.00
consistent gets from cache	32,660,282	8,987.65	120.95
consistent gets from cache (fastpath)	24,046,617	6,617.29	89.05
cursor authentications	254	0.07	0.00
data blocks consistent reads - undo records applied	12,582	3.46	0.05
db block changes	53,517,541	14,727.28	198.18
db block gets	77,352,446	21,286.31	286.45
db block gets direct	57	0.02	0.00
db block gets from cache	77,352,389	21,286.30	286.45
db block gets from cache (fastpath)	28,726,222	7,905.06	106.38
deferred (CURRENT) block cleanout applications	290,248	79.87	1.07
dirty buffers inspected	36,626	10.08	0.14
enqueue conversions	12,693	3.49	0.05
enqueue releases	1,144,864	315.05	4.24
enqueue requests	1,144,953	315.08	4.24
enqueue timeouts	67	0.02	0.00
enqueue waits	59,902	16.48	0.22
exchange deadlocks	72,610	19.98	0.27
execute count	6,000,768	1,651.33	22.22
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	3,620,917,629	996,426.06	13,408.72
free buffer inspected	1,270,979	349.76	4.71
free buffer requested	1,617,524	445.12	5.99
gc CPU used by this session	53,416	14.70	0.20
gc blocks compressed	468,261	128.86	1.73
gc blocks lost	0	0.00	0.00
gc cr block build time	97	0.03	0.00
gc cr block flush time	3,203	0.88	0.01
gc cr block read wait time	0	0.00	0.00
gc cr block receive time	13,994	3.85	0.05
gc cr block send time	253	0.07	0.00
gc cr blocks received	159,870	43.99	0.59
gc cr blocks served	115,826	31.87	0.43
gc current block flush time	13,805	3.80	0.05
gc current block pin time	28,742	7.91	0.11
gc current block receive time	121,290	33.38	0.45
gc current block send time	2,126	0.59	0.01
gc current blocks received	700,199	192.69	2.59
gc current blocks served	698,668	192.26	2.59
gc kbytes saved	1,574,087	433.17	5.83
gc kbytes sent	4,941,864	1,359.93	18.30
gc local grants	402,780	110.84	1.49
gc remote grants	199,473	54.89	0.74
gcs messages sent	2,134,602	587.41	7.90
ges messages sent	108,261	29.79	0.40
global enqueue get time	358,733	98.72	1.33
global enqueue gets async	30,304	8.34	0.11
global enqueue gets sync	6,525,975	1,795.86	24.17
global enqueue releases	6,508,348	1,791.01	24.10
heap block compress	2,677,680	736.86	9.92
hot buffers moved to head of LRU	1,138,675	313.35	4.22
immediate (CR) block cleanout applications	10,285	2.83	0.04
immediate (CURRENT) block cleanout applications	142,138	39.11	0.53
index crx upgrade (positioned)	1,302	0.36	0.00
index crx upgrade (prefetch)	176	0.05	0.00
index fast full scans (full)	41	0.01	0.00
index fetch by key	4,486,015	1,234.49	16.61
index scans kdiixs1	3,866,139	1,063.91	14.32
leaf node 90-10 splits	1,999	0.55	0.01
leaf node splits	39,403	10.84	0.15
lob reads	0	0.00	0.00
lob writes	279	0.08	0.00
lob writes unaligned	153	0.04	0.00
logons cumulative	638	0.18	0.00
max cf enq hold time	0	0.00	0.00
messages received	324,285	89.24	1.20
messages sent	324,285	89.24	1.20
min active SCN optimization applied on CR	2,502	0.69	0.01
no buffer to keep pinned count	56	0.02	0.00
no work - consistent read gets	21,355,026	5,876.61	79.08
non-idle wait count	14,195,249	3,906.33	52.57
non-idle wait time	1,221,284	336.08	4.52
opened cursors cumulative	4,658,616	1,281.99	17.25
parse count (describe)	27	0.01	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	992	0.27	0.00
parse count (total)	5,961,799	1,640.60	22.08
parse time cpu	1,724	0.47	0.01
parse time elapsed	9,902	2.72	0.04
physical read IO requests	298,207	82.06	1.10
physical read bytes	2,503,639,040	688,966.56	9,271.29
physical read total IO requests	329,899	90.78	1.22
physical read total bytes	3,020,928,000	831,317.27	11,186.88
physical read total multi block requests	64	0.02	0.00
physical reads	305,620	84.10	1.13
physical reads cache	302,871	83.35	1.12
physical reads cache prefetch	98,916	27.22	0.37
physical reads direct	2,749	0.76	0.01
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	226,175	62.24	0.84
physical write bytes	4,284,686,336	1,179,085.95	15,866.74
physical write total IO requests	592,589	163.07	2.19
physical write total bytes	19,393,882,112	5,336,926.01	71,818.02
physical write total multi block requests	39,832	10.96	0.15
physical writes	523,033	143.93	1.94
physical writes direct	1,464	0.40	0.01
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	521,569	143.53	1.93
physical writes non checkpoint	369,508	101.68	1.37
pinned buffers inspected	4,675	1.29	0.02
pinned cursors current	5	0.00	0.00
prefetch clients - default	6	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	14,014	3.86	0.05
process last non-idle time	3,663	1.01	0.01
queries parallelized	17	0.00	0.00
recovery blocks read	0	0.00	0.00
recursive calls	21,877,627	6,020.42	81.02
recursive cpu usage	19,206	5.29	0.07
redo blocks checksummed by FG (exclusive)	15,920,046	4,380.97	58.95
redo blocks written	29,423,930	8,097.06	108.96
redo buffer allocation retries	3,087	0.85	0.01
redo entries	29,901,424	8,228.46	110.73
redo log space requests	7,658	2.11	0.03
redo log space wait time	41,578	11.44	0.15
redo ordering marks	224,326	61.73	0.83
redo size	14,488,010,152	3,986,898.43	53,650.95
redo size for direct writes	200	0.06	0.00
redo subscn max counts	93,671	25.78	0.35
redo synch time	38,035	10.47	0.14
redo synch writes	189,590	52.17	0.70
redo wastage	92,344,028	25,411.79	341.96
redo write broadcast ack count	37,209	10.24	0.14
redo write broadcast ack time	11,765,562	3,237.72	43.57
redo write time	24,276	6.68	0.09
redo writes	232,959	64.11	0.86
rollback changes - undo records applied	9,537,457	2,624.58	35.32
root node splits	3	0.00	0.00
rows fetched via callback	26,612	7.32	0.10
scheduler wait time	0	0.00	0.00
session connect time	0	0.00	0.00
session cursor cache hits	451,018	124.11	1.67
session logical reads	110,012,697	30,273.96	407.39
shared hash latch upgrades - no wait	34,810	9.58	0.13
shared hash latch upgrades - wait	89	0.02	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	36,169	9.95	0.13
sorts (rows)	2,319,097	638.18	8.59
sql area evicted	132	0.04	0.00
sql area purged	484	0.13	0.00
summed dirty queue length	88,641	24.39	0.33
switch current to new buffer	25,587	7.04	0.09
table fetch by rowid	13,268,018	3,651.17	49.13
table fetch continued row	405	0.11	0.00
table scan blocks gotten	6,679,534	1,838.11	24.74
table scan rows gotten	663,139,230	182,486.67	2,455.69
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (short tables)	26,900	7.40	0.10
temp space allocated (bytes)	3,145,728	865.66	11.65
total cf enq hold time	5,469	1.50	0.02
total number of cf enq holders	2,728	0.75	0.01
total number of times SMON posted	106	0.03	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction lock foreground wait time	0	0.00	0.00
transaction rollbacks	5,944	1.64	0.02
transaction tables consistent read rollbacks	172	0.05	0.00
transaction tables consistent reads - undo records applied	911	0.25	0.00
undo change vector size	1,813,019,716	498,917.75	6,713.84
user I/O wait time	42,347	11.65	0.16
user calls	6,603,473	1,817.18	24.45
user commits	167,326	46.05	0.62
user rollbacks	102,716	28.27	0.38
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	5,183	1.43	0.02
write clones created in background	59	0.02	0.00
write clones created in foreground	1,892	0.52	0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	6,023,404,248	6,156,531,312
session cursor cache count	147,867	147,367
session uga memory	4,721,298,695,120	4,850,182,778,440
opened cursors current	321	351
logons current	202	205
session uga memory max	20,491,868,848	20,830,007,584
session pga memory	4,977,546,648	5,101,498,672

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)	53	52.51

Back to Instance Activity Statistics
Back to Top

IO Stats

IOStat by Function summary
IOStat by Filetype summary
IOStat by Function/Filetype summary
Tablespace IO Stats
File IO Stats

IOStat by Function summary

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
LGWR	243M	4.31	.066870	14G	100.36	3.95827	16.3K	0.04
DBWR	0M	0.00	0M	4G	61.85	1.12193	0
Buffer Cache Reads	2.3G	81.61	.653566	0M	0.00	0M	205.1K	1.63
Others	250M	4.41	.068796	33M	0.59	.009081	18.2K	0.16
Direct Reads	21M	0.76	.005778	5M	0.17	.001375	0
Direct Writes	0M	0.00	0M	7M	0.22	.001926	0
TOTAL:	2.8G	91.09	.795012	18.1G	163.19	5.09259	239.5K	1.41

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	0M	0.03	0M	14G	100.21	3.95607	0.48
Data File	2.3G	82.38	.660446	4G	62.23	1.12578	1.06	22.84
Control File	493M	8.67	.135666	42M	0.74	.011557	0.09
Temp File	1M	0.00	.000275	0M	0.01	0M	3.00
TOTAL:	2.8G	91.09	.796388	18.1G	163.19	5.09341	0.96	22.84

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
LGWR	243M	4.31	.066870	14G	100.36	3.95855	15.8K	0.03
LGWR (Log File)	0M	0.03	0M	14G	100.21	3.95634	212	0.36
LGWR (Control File)	243M	4.28	.066870	8M	0.15	.002201	15.5K	0.03
DBWR	0M	0.00	0M	4G	61.85	1.12193	0
DBWR (Data File)	0M	0.00	0M	4G	61.85	1.12193	0
Buffer Cache Reads	2.3G	81.62	.653566	0M	0.00	0M	192.6K	1.47
Buffer Cache Reads (Data File)	2.3G	81.62	.653566	0M	0.00	0M	192.6K	1.47
Others	249M	4.41	.068521	33M	0.59	.009081	16K	0.15
Others (Control File)	249M	4.39	.068521	33M	0.59	.009081	16K	0.15
Others (Data File)	0M	0.02	0M	0M	0.00	0M	73	0.00
Direct Reads	21M	0.76	.005778	5M	0.17	.001375	0
Direct Reads (Data File)	21M	0.76	.005778	5M	0.17	.001375	0
Direct Writes	0M	0.00	0M	7M	0.22	.001926	0
Direct Writes (Data File)	0M	0.00	0M	7M	0.22	.001926	0
TOTAL:	2.8G	91.10	.794737	18.1G	163.20	5.09286	224.4K	1.28

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SOD_BDB_BIGDATA_1	204,258	56	1.04	164,567	45	1,438,599	2.76
SOD_COMN_BIGINDEX_2	51,621	14	1.00	20	0	0	0.00
UNDOTBS2	19	0	1.00	51,150	14	937	0.05
BIG_SOD_BDB_DATA_1	25,837	7	1.00	19	0	0	0.00
SOD_BDB_DATA_1	6,792	2	1.00	4,476	1	123	1.22
SYSAUX	1,115	0	1.06	5,312	1	0	0.00
SOD_BDB_BIDX_MIN_01	3,041	1	1.00	20	0	0	0.00
SOD_BDB_BDAT_MIN_01	1,064	0	1.00	20	0	0	0.00
SOD_BDB_BDAT_MIN_02	1,052	0	1.00	20	0	0	0.00
SOD_BDB_BDAT_MIN_03	1,026	0	1.00	20	0	0	0.00
DATA_ELMT_SURF_4_TS	968	0	1.00	19	0	0	0.00
SYSTEM	456	0	1.00	182	0	594	40.67
USERS	421	0	1.00	39	0	0	0.00
DATA_ELMT_OCEN_01_TS	71	0	1.00	19	0	0	0.00
TEST	50	0	1.00	19	0	0	0.00
INDEX_ELMT_SURF_3_TS	45	0	1.00	19	0	0	0.00
SOD_TEMP_DATA_2	15	0	1.00	32	0	0	0.00
DATA_ELMT_OCEN_02_TS	19	0	1.00	19	0	0	0.00
DATA_ELMT_OCEN_03_TS	19	0	1.00	19	0	0	0.00
RMANTS	19	0	1.00	19	0	0	0.00
SOD_COMN_BIGINDEX_1	19	0	1.00	19	0	0	0.00
TBS_RDB_DATA_01	19	0	1.00	19	0	0	0.00
TBS_RDB_DATA_02	19	0	1.00	19	0	0	0.00
TBS_RDB_INDEX_00	19	0	1.00	19	0	0	0.00
UNDOTBS1	19	0	1.00	19	0	1,404	0.48

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
BIG_SOD_BDB_DATA_1	+DATA/babjdb/datafile/big_sod_bdb_data_1.282.757188661	25,837	7	1.00	19	0	0	0.00
DATA_ELMT_OCEN_01_TS	+DATA/babjdb/datafile/data_elmt_ocen_01_ts.273.755806937	71	0	1.00	19	0	0	0.00
DATA_ELMT_OCEN_02_TS	+DATA/babjdb/datafile/data_elmt_ocen_02_ts.274.755806959	19	0	1.00	19	0	0	0.00
DATA_ELMT_OCEN_03_TS	+DATA/babjdb/datafile/data_elmt_ocen_03_ts.275.755806981	19	0	1.00	19	0	0	0.00
DATA_ELMT_SURF_4_TS	+DATA/babjdb/datafile/data_elmt_surf_4_ts.280.755975709	968	0	1.00	19	0	0	0.00
INDEX_ELMT_SURF_3_TS	+DATA/babjdb/datafile/index_elmt_surf_3_ts.281.755976381	45	0	1.00	19	0	0	0.00
RMANTS	+DATA/babjdb/datafile/rman.ts	19	0	1.00	19	0	0	0.00
SOD_BDB_BDAT_MIN_01	+DATA/babjdb/datafile/sod_bdb_bdat_min_01.288.764977539	1,064	0	1.00	20	0	0	0.00
SOD_BDB_BDAT_MIN_02	+DATA/babjdb/datafile/sod_bdb_bdat_min_02.289.764977879	1,052	0	1.00	20	0	0	0.00
SOD_BDB_BDAT_MIN_03	+DATA/babjdb/datafile/sod_bdb_bdat_min_03.290.764978221	1,026	0	1.00	20	0	0	0.00
SOD_BDB_BIDX_MIN_01	+DATA/babjdb/datafile/sod_bdb_bidx_min_01.291.764978653	3,041	1	1.00	20	0	0	0.00
SOD_BDB_BIGDATA_1	+DATA/babjdb/datafile/sod_bdb_bigdata_1.283.758043817	204,258	56	1.04	164,567	45	1,438,599	2.76
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_1.268.755783427	1,959	1	1.00	53	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_1.326.791929435	231	0	1.00	465	0	1	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_1.327.791929717	63	0	1.00	118	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_1.dbf	145	0	1.00	24	0	1	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_10.dbf	51	0	1.00	21	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_11.dbf	77	0	1.00	21	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_12.dbf	38	0	1.00	20	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_13.dbf	39	0	1.00	26	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_14.dbf	84	0	1.00	111	0	9	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_15.dbf	61	0	1.00	32	0	13	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_16.dbf	59	0	1.00	37	0	13	1.54
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_17.dbf	84	0	1.00	39	0	12	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_18.dbf	64	0	1.00	32	0	19	3.16
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_19.dbf	63	0	1.00	20	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_2.dbf	761	0	1.00	30	0	10	2.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_20.dbf	71	0	1.00	294	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_21.dbf	126	0	1.00	36	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_22.dbf	213	0	1.00	275	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_23.dbf	324	0	1.00	402	0	1	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_24.dbf	202	0	1.00	440	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_25.dbf	146	0	1.00	350	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_26.dbf	116	0	1.00	19	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_27.dbf	63	0	1.00	21	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_28.dbf	66	0	1.00	21	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_29.dbf	50	0	1.00	25	0	1	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_3.dbf	113	0	1.00	30	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_30.dbf	65	0	1.00	29	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_31.dbf	69	0	1.00	48	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_32.dbf	74	0	1.00	36	0	1	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_33.dbf	128	0	1.00	32	0	1	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_34.dbf	95	0	1.00	559	0	8	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_35.dbf	46	0	1.00	19	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_36.dbf	74	0	1.00	19	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_37.dbf	47	0	1.00	19	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_38.dbf	47	0	1.00	19	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_39.dbf	52	0	1.00	24	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_4.dbf	106	0	1.00	26	0	1	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_40.dbf	61	0	1.00	19	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_41.dbf	78	0	1.00	163	0	2	5.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_42.dbf	68	0	1.00	70	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_43.dbf	68	0	1.00	30	0	2	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_44.dbf	80	0	1.00	121	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_45.dbf	50	0	1.00	58	0	11	0.91
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_46.dbf	44	0	1.00	52	0	14	2.14
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_5.dbf	42	0	1.00	29	0	3	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_6.dbf	46	0	1.02	60	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_7.dbf	66	0	1.00	39	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_8.dbf	53	0	1.00	22	0	0	0.00
SOD_BDB_DATA_1	+DATA/babjdb/datafile/sod_bdb_data_9.dbf	64	0	1.00	21	0	0	0.00
SOD_COMN_BIGINDEX_1	+DATA/babjdb/datafile/sod_comn_bigindex_1.285.758047143	19	0	1.00	19	0	0	0.00
SOD_COMN_BIGINDEX_2	+DATA/babjdb/datafile/sod_comn_bigindex_2.286.758050149	51,621	14	1.00	20	0	0	0.00
SOD_TEMP_DATA_2	+DATA/babjdb/tempfile/sod_temp_data_2.287.760631017	15	0	1.00	32	0	0
SYSAUX	+DATA/babjdb/datafile/sysaux.260.755707851	1,115	0	1.06	5,312	1	0	0.00
SYSTEM	+DATA/babjdb/datafile/system.259.755707847	456	0	1.00	182	0	594	40.67
TBS_RDB_DATA_01	+DATA/babjdb/datafile/tbs_rdb_data_01.271.755880535	19	0	1.00	19	0	0	0.00
TBS_RDB_DATA_02	+DATA/babjdb/datafile/tbs_rdb_data_02.272.755878109	19	0	1.00	19	0	0	0.00
TBS_RDB_INDEX_00	+DATA/babjdb/datafile/tbs_rdb_index_00.276.755881611	19	0	1.00	19	0	0	0.00
TEST	+DATA/babjdb/datafile/test.321.790120515	50	0	1.00	19	0	0	0.00
UNDOTBS1	+DATA/babjdb/datafile/undotbs1.261.755707853	19	0	1.00	19	0	1,404	0.48
UNDOTBS2	+DATA/babjdb/datafile/undotbs2.263.755707863	19	0	1.00	51,150	14	937	0.05
USERS	+DATA/babjdb/datafile/users.264.755707863	383	0	1.00	19	0	0	0.00
USERS	+DATA/babjdb/datafile/users_1.dbf	38	0	1.00	20	0	0	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	2,378,446	100	109,841,616	302,792	521,569	0	0	1,442,492

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 523,033

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	410,300	0	0	14,257	13,078

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

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

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	1	4270	5571	1824768	1824768	4672381			1
E	0	34	17568	1832499	1824768	1824768	3660523			19

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	1,920	0.10	227	20.42	1,019,477	1	1843238.00
D	3,840	0.19	455	14.74	736,017	1	1330736.00
D	5,760	0.29	682	10.44	521,228	1	942393.00
D	7,680	0.38	909	7.14	356,607	1	644754.00
D	9,600	0.48	1,136	4.91	245,228	1	443378.00
D	11,520	0.57	1,364	3.58	178,908	1	323469.00
D	13,440	0.67	1,591	2.61	130,384	1	235738.00
D	15,360	0.76	1,818	1.93	96,404	1	174299.00
D	17,280	0.86	2,045	1.38	69,124	1	124978.00
D	19,200	0.96	2,273	1.02	50,796	1	91839.00
D	20,096	1.00	2,379	1.00	49,917	1	90251.00
D	21,120	1.05	2,500	0.98	48,913	1	88436.00
D	23,040	1.15	2,727	0.95	47,651	1	86154.00
D	24,960	1.24	2,954	0.90	44,878	1	81140.00
D	26,880	1.34	3,182	0.88	43,968	1	79495.00
D	28,800	1.43	3,409	0.88	43,727	1	79060.00
D	30,720	1.53	3,636	0.87	43,588	1	78808.00
D	32,640	1.62	3,863	0.87	43,329	1	78339.00
D	34,560	1.72	4,091	0.86	43,017	1	77776.00
D	36,480	1.82	4,318	0.86	42,800	1	77383.00
D	38,400	1.91	4,545	0.84	41,830	1	75630.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	4,978	4,978
64K	128K	12	12
128K	256K	2	2
256K	512K	2	2
512K	1024K	136	136
1M	2M	41	41
4M	8M	12	12

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
1,616	0.13	4,156,767.84	519.59	100.00	1	499,271,028
3,232	0.25	4,156,767.84	519.59	100.00	0	499,271,028
6,464	0.50	4,156,767.84	519.59	100.00	0	499,271,028
9,696	0.75	4,156,767.84	519.59	100.00	0	499,271,028
12,928	1.00	4,156,767.84	40.22	100.00	0	499,213,458
15,514	1.20	4,156,767.84	0.00	100.00	0	499,208,628
18,099	1.40	4,156,767.84	0.00	100.00	0	499,208,628
20,685	1.60	4,156,767.84	0.00	100.00	0	499,208,628
23,270	1.80	4,156,767.84	0.00	100.00	0	499,208,628
25,856	2.00	4,156,767.84	0.00	100.00	0	499,208,628
38,784	3.00	4,156,767.84	0.00	100.00	0	499,208,628
51,712	4.00	4,156,767.84	0.00	100.00	0	499,208,628
77,568	6.00	4,156,767.84	0.00	100.00	0	499,208,628
103,424	8.00	4,156,767.84	0.00	100.00	0	499,208,628

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)
3,072	0.89	2	134	1,790,767	1.00	12,670	1.00	2,646
3,456	1.00	388	19,008	1,790,771	1.00	12,666	1.00	373,489
3,840	1.11	772	32,284	1,791,418	1.00	12,019	0.95	373,508
4,224	1.22	1,155	43,120	1,792,035	1.00	11,402	0.90	373,525
4,608	1.33	1,539	53,148	1,792,567	1.00	10,870	0.86	373,541
4,992	1.44	1,923	63,619	1,792,984	1.00	10,453	0.83	373,553
5,376	1.56	2,307	74,295	1,793,282	1.00	10,155	0.80	373,563
5,760	1.67	2,690	84,905	1,793,478	1.00	9,959	0.79	373,570
6,144	1.78	3,074	95,492	1,793,598	1.00	9,839	0.78	373,575
6,528	1.89	3,458	105,921	1,793,669	1.00	9,768	0.77	373,578
6,912	2.00	3,842	116,209	1,793,710	1.00	9,727	0.77	373,580

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
6,016	0.25	2,640,437	1,040,268,446
9,024	0.38	2,125,066	751,028,283
12,032	0.50	1,438,699	363,880,854
15,040	0.63	1,117,430	182,554,281
18,048	0.75	1,027,655	133,041,691
21,056	0.88	917,861	70,528,366
24,064	1.00	881,880	49,906,854
27,072	1.13	877,823	48,619,257
30,080	1.25	871,829	45,789,539
33,088	1.38	869,978	44,861,271
36,096	1.50	869,360	44,471,998
39,104	1.63	868,655	43,893,078
42,112	1.75	866,803	42,680,342
45,120	1.88	866,097	42,680,342
48,128	2.00	866,097	42,680,342

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	363,382	2,580	7
2nd level bmb	256,682	865	3
1st level bmb	819,232	553	1
segment header	227	1	4
undo header	2,284	1	0
undo block	51	0	1
file header block	7	0	1

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (index contention)	49,187	49,158	0	47,197	3,411	72.27
SQ-Sequence Cache	24,784	24,784	0	6,718	392	58.32
TX-Transaction (allocate ITL entry)	1,603	1,570	32	1,577	62	39.05
TX-Transaction (row lock contention)	55	55	0	54	12	227.89
FB-Format Block	5,428	5,428	0	2,665	2	0.67
TX-Transaction	233,038	233,047	0	157	1	9.00
WF-AWR Flush	21	21	0	13	1	81.54
HW-Segment High Water Mark	4,190	4,190	0	82	0	5.60
PS-PX Process Reservation	523	522	1	456	0	0.82
CF-Controlfile Transaction	13,014	13,009	5	168	0	1.56
CR-Reuse Block Range (block range reuse ckpt)	2,510	2,510	0	502	0	0.50
TM-DML	431,391	431,402	0	17	0	7.65
JQ-Job Queue	63	35	28	47	0	1.94
TT-Tablespace	94,469	94,469	0	141	0	0.56
US-Undo Segment	107	107	0	56	0	0.63
TA-Instance Undo	12	12	0	11	0	0.45
JS-Job Scheduler (job run lock - synchronize)	4	3	1	3	0	1.00
KO-Multiple Object Checkpoint (fast object checkpoint)	8	8	0	3	0	0.67
UL-User-defined	4	4	0	3	0	0.33
AE-Edition Lock (lock)	69	69	0	2	0	0.50
AF-Advisor Framework (task serialization)	13	13	0	1	0	1.00
TQ-Queue table enqueue (DDL contention)	2	2	0	1	0	1.00
PW-Buffer Cache PreWarm (flush prewarm buffers)	1	1	0	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
4	182.09	184,756	1,048	139	19.3/29.5	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
14-Mar 07:50	173,667	166,450	1,037	127	29	0/0	0/0/0/0/0/0
14-Mar 07:40	8,004	17,622	435	139	19	0/0	0/0/0/0/0/0
14-Mar 07:30	190	226	1,042	3	29	0/0	0/0/0/0/0/0
14-Mar 07:20	204	390	441	3	19	0/0	0/0/0/0/0/0
14-Mar 07:10	23	68	1,048	1	29	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 Keyed state latch	319	0.00		0	0
ASM db client latch	7,568	0.00		0	0
ASM map operation freelist	175	0.00		0	0
ASM map operation hash table	1,857,256	0.00	0.00	0	0
ASM network background latch	4,176	0.00		0	0
ASM network state latch	114	0.00		0	0
AWR Alerted Metric Element list	39,247	0.00		0	0
Change Notification Hash table latch	1,211	0.00		0	0
Consistent RBA	233,262	0.11	0.00	0	0
DML lock allocation	3,771,305	0.00	0.00	0	0
Event Group Locks	162	0.00		0	0
FOB s.o list latch	3,183	0.00		0	0
File State Object Pool Parent Latch	1	0.00		0	0
IPC other latch	31	0.00		0	0
IPC stats buffer allocation latch	1,364	0.00		0	1,381	0.00
In memory undo latch	1	0.00		0	0
JS Sh mem access	9	11.11	1.00	0	0
JS broadcast add buf latch	7,815	0.00		0	0
JS broadcast drop buf latch	7,816	0.00		0	0
JS broadcast load blnc latch	7,711	0.00		0	0
JS mem alloc latch	16	0.00		0	0
JS queue access latch	17	0.00		0	0
JS queue state obj latch	277,612	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
KFK SGA Libload latch	2,440	0.00		0	0
KFMD SGA	777	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	159,247	0.45	0.00	0	20,796	0.24
KJCT flow control latch	2,944,075	0.09	0.00	0	0
KMG MMAN ready and startup request latch	1,211	0.00		0	0
KSXR large replies	2	0.00		0	0
KTF sga latch	28	0.00		0	1,095	0.00
KWQMN job cache list latch	307	0.00		0	0
KWQS pqsubs latch	8	0.00		0	0
KWQS pqueue ctx latch	32	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	2,443	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	1	0.00		0	1,211	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	20	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	1,327	0.00		0	0
OS process allocation	2,098	0.00		0	0
OS process: request allocation	319	0.00		0	0
PL/SQL warning settings	20,987	0.00		0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	16,663	0.00		0	0
SGA IO buffer pool latch	5,731	0.05	0.00	0	6,643	0.59
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	122	0.00		0	1,210	0.00
SQL memory manager workarea list latch	2,744,372	0.01	0.01	0	0
Shared B-Tree	271	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	1	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	13,728	0.09	0.00	0	0
active service list	160,389	0.00		0	2,519	0.00
begin backup scn array	3	0.00		0	0
buffer pool	1	0.00		0	0
business card	35	0.00		0	0
cache buffer handles	120,828	0.04	0.00	0	0
cache buffers chains	329,940,406	0.91	0.07	31	3,681,388	0.72
cache buffers lru chain	1,560,663	0.14	0.04	0	3,659,687	0.20
cache table scan latch	264	0.00		0	264	0.00
call allocation	4,545	0.00		0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	357	0.00		0	0
channel operations parent latch	4,922,153	0.00	0.00	0	0
checkpoint queue latch	1,831,261	0.05	0.00	0	968,090	0.01
client/application info	4,021	0.00		0	0
compile environment latch	639	0.00		0	0
corrupted undo seg latch	28,618,315	1.22	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	114	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	114	0.00		0	0
dml lock allocation	118	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	1,276	0.00		0	0
enqueue hash chains	3,560,281	0.63	0.00	0	5,657	0.07
enqueues	916,115	0.29	0.00	0	0
error message lists	73	0.00		0	0
fifth spare latch	1	0.00		0	0
file cache latch	3,964	0.00		0	0
flashback copy	1	0.00		0	0
gc element	7,352,812	0.23	0.15	0	22,876	0.37
gcs commit scn state	1	0.00		0	0
gcs opaque info freelist	1,679,324	0.16	0.00	0	0
gcs partitioned table hash	24,705,541	0.21	0.00	0	232,752	0.01
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs remaster request queue	7	0.00		0	0
gcs remastering latch	3,331,246	3.30	0.00	0	2,190	4.20
gcs resource freelist	329,303	0.04	0.00	0	118,174	0.00
gcs resource hash	7,708,694	0.09	0.00	0	31,718	0.02
gcs resource scan list	63,464	0.02	0.00	0	0
gcs shadows freelist	240,797	0.02	0.00	0	436,590	0.00
ges DFS wait callback info	5	0.00		0	1	0.00
ges caches resource lists	5,223,781	0.07	0.01	0	77,705	0.20
ges deadlock list	99,832	0.02	0.00	0	41	0.00
ges domain table	12,990,175	0.00	0.00	0	0
ges enqueue table freelist	13,039,228	0.15	0.00	0	0
ges group table	19,432,557	0.05	0.00	0	0
ges process hash list	27,386	0.00		0	0
ges process parent latch	26,212,915	0.00	0.00	0	0
ges process table freelist	319	0.00		0	0
ges resource hash list	19,399,702	4.57	0.01	3	49,249	0.04
ges resource scan list	15,290	0.01	0.00	0	0
ges resource table freelist	72,476	0.00		0	0
ges timeout list	20,242	0.03	0.00	0	6,483	0.00
ges value block free list	513	0.00		0	0
global KZLD latch for mem in SGA	19	0.00		0	0
global ctx hash table latch	1	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	279	0.00		0	144,987	0.00
hash table modification latch	309	0.00		0	0
heartbeat check	1	0.00		0	910	0.00
heartbeat structure management	0			0	727	0.00
internal temp table object number allocation latch	37	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	68	0.00		0	67	0.00
job_queue_processes free list latch	140	0.00		0	0
job_queue_processes parameter latch	7,798	0.00		0	0
k2q global data latch	2,424	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	53	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kks stats	1,468	0.00		0	0
kokc descriptor allocation latch	422	0.00		0	0
ksfv messages	1	0.00		0	0
ksim membership request latch	356	0.00		0	2,654	0.00
kss move lock	35	0.00		0	0
ksuosstats global area	390	0.00		0	0
ksv allocation latch	181	0.00		0	0
ksv class latch	7,381	0.00		0	0
ksv msg queue latch	107	0.00		0	106	0.00
ksxp shared latch	319	0.00		0	0
ksxp so latch	319	0.00		0	0
ksz_so allocation latch	319	0.00		0	0
ktm global data	237	0.00		0	0
kwqbsn:qsga	174	0.00		0	0
lgwr LWN SCN	236,404	0.95	0.00	0	0
list of block allocation	61,018	0.02	0.00	0	0
loader state object freelist	928	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	1	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	1	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	11,192	0.00		0	0
messages	1,220,427	0.09	0.00	0	0
mostly latch-free SCN	254,568	7.85	0.00	0	0
msg queue latch	1	0.00		0	0
multiblock read objects	89,768	0.01	0.00	0	0
name-service memory objects	22,396	0.00		0	0
name-service namespace bucket	136,145	0.00		0	0
name-service pending queue	8,044	0.00		0	0
name-service request queue	46,765	0.00		0	0
ncodef allocation latch	114	0.00		0	0
object queue header heap	134,794	0.00	0.00	0	51,707	0.00
object queue header operation	18,191,056	0.05	0.03	0	0
object stats modification	137,554	0.00	0.00	0	0
parallel query alloc buffer	4,157	0.00		0	0
parallel query stats	490	0.00		0	0
parallel txn reco latch	4,728	0.00		0	0
parameter list	158	0.00		0	0
parameter table management	1,398	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	897,307	0.13	0.00	0	516,685	0.06
process allocation	16,962	0.00		0	161	0.00
process group creation	319	0.00		0	0
process queue	1,433	0.00		0	0
process queue reference	27,321	0.00		0	2,358	0.00
qmn task queue latch	528	0.38	0.00	0	0
query server freelists	984	0.00		0	0
queued dump request	13	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	1,113,536	24.13	0.01	1	29,624,201	5.56
redo copy	1	0.00		0	29,903,614	0.11
redo writing	851,230	0.05	0.00	0	0
resmgr group change latch	770	0.00		0	0
resmgr:active threads	1,324	0.00		0	0
resmgr:actses change group	505	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	1,275	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	369	0.00		0	0
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	39,247,713	5.59	0.00	1	78	0.00
rules engine aggregate statistics	4	0.00		0	0
rules engine rule set statistics	8	0.00		0	0
second spare latch	1	0.00		0	0
sequence cache	8,699,947	1.17	0.00	0	0
session allocation	936,214	0.25	0.00	0	312,073	0.01
session idle bit	13,516,392	0.03	0.01	0	0
session queue latch	1	0.00		0	0
session state list latch	1,300	0.00		0	0
session switching	905	0.00		0	0
session timer	1,356	0.00		0	0
shared pool	324,323	0.01	0.21	0	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	2,886	0.00		0	0
sim partition latch	1	0.00		0	0
simulator hash latch	5,133,198	0.00	0.01	0	0
simulator lru latch	1	0.00		0	5,070,633	0.16
sort extent pool	308	0.00		0	0
space background state object latch	10	0.00		0	0
space background task latch	2,684	0.00		0	2,424	0.00
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	5	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
third spare latch	1	0.00		0	0
threshold alerts latch	361	0.00		0	0
transaction allocation	750,770	0.00	0.00	0	0
undo global data	4,181,938	0.03	0.00	0	1	0.00
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	329,940,406	3,001,595	200,689	2,825,112
row cache objects	39,247,713	2,195,228	3,901	2,191,457
ges resource hash list	19,399,702	886,365	11,170	875,335
corrupted undo seg latch	28,618,315	350,322	494	349,839
redo allocation	1,113,536	268,687	3,287	265,514
gcs remastering latch	3,331,246	109,986	26	109,961
sequence cache	8,699,947	102,002	190	101,812
enqueue hash chains	3,560,281	22,322	92	22,230
mostly latch-free SCN	254,568	19,972	74	19,900
ges enqueue table freelist	13,039,228	19,332	86	19,247
gc element	7,352,812	16,665	2,515	14,252
ges group table	19,432,557	10,308	26	10,282
object queue header operation	18,191,056	9,475	276	9,208
gcs resource hash	7,708,694	6,807	21	6,787
session idle bit	13,516,392	4,418	39	4,379
ges caches resource lists	5,223,781	3,837	20	3,817
enqueues	916,115	2,645	5	2,640
gcs opaque info freelist	1,679,324	2,613	13	2,600
KJCT flow control latch	2,944,075	2,539	11	2,528
session allocation	936,214	2,308	1	2,307
lgwr LWN SCN	236,404	2,243	1	2,242
cache buffers lru chain	1,560,663	2,208	91	2,122
undo global data	4,181,938	1,459	7	1,452
post/wait queue	897,307	1,193	5	1,188
messages	1,220,427	1,123	5	1,118
checkpoint queue latch	1,831,261	879	2	877
KJC message pool free list	159,247	712	2	710
ges domain table	12,990,175	479	1	478
SQL memory manager workarea list latch	2,744,372	287	2	285
simulator hash latch	5,133,198	77	1	76
shared pool	324,323	24	5	19
JS Sh mem access	9	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
JS Sh mem access	jsksGetShMemLatch	1	1
KJC message pool free list	kjcspfmbq: free vector of msg buffers	2	0
KJCT flow control latch	kjctcsnd: send normal message	6	4
KJCT flow control latch	kjcts_sedeqv2: dequeue a vector of msgs	2	1
KJCT flow control latch	kjcts_sqenq: queue a message	2	3
KJCT flow control latch	kjctr_updatetkt: update ticket info	1	2
SQL memory manager workarea list latch	qesmmIUnRegisterWorkArea	2	0
cache buffers chains	kcbgtcr: fast path (cr pin)	93,445	26,789
cache buffers chains	kcbzwb	59,747	38,851
cache buffers chains	kcbgcur_2	18,871	13,277
cache buffers chains	kcbgcur: fast path (shr)	6,967	4,265
cache buffers chains	kcbget: pin buffer	6,118	8,224
cache buffers chains	kcbrls_2	4,832	25,137
cache buffers chains	kcbchg1: kslbegin: call CR func	4,808	26,970
cache buffers chains	kclwlr	2,976	2,494
cache buffers chains	kcbget: exchange rls	2,455	2,346
cache buffers chains	kcbgcur_1	2,367	899
cache buffers chains	kcbget: exchange	2,166	3,687
cache buffers chains	kcbgtcr: kslbegin excl	2,058	9,957
cache buffers chains	kcbgcur_5	1,997	1,829
cache buffers chains	kcbrls_1	1,312	25,626
cache buffers chains	kclbla	1,235	613
cache buffers chains	kcbesc: escalate	874	178
cache buffers chains	kcbchg1: kslbegin: bufs not pinned	723	21,080
cache buffers chains	kcbgtcr_2	646	714
cache buffers chains	kclpto	631	0
cache buffers chains	kcllkopesc	476	62
cache buffers chains	kcbgtcr: fast path	459	272
cache buffers chains	kcbgcur: deadlock	325	501
cache buffers chains	kcbso1: set no access	314	400
cache buffers chains	kcbzibmlt: multi-block read: nowait	263	0
cache buffers chains	kcl_fairness	262	277
cache buffers chains	kcbsod1	260	391
cache buffers chains	kclpto_1	162	1,613
cache buffers chains	kclfpdb	132	0
cache buffers chains	kcbzib: finish processing buffer	67	199
cache buffers chains	kcbbxsv	47	52
cache buffers chains	kcbzgb: scan from tail. nowait	44	0
cache buffers chains	kcbzib: exchange rls	37	152
cache buffers chains	kclwcrs	37	26
cache buffers chains	kclcsr	25	12
cache buffers chains	kclwrt	17	1
cache buffers chains	kcbnlc	14	90
cache buffers chains	kcbbic1	12	1
cache buffers chains	kclrls	11	115
cache buffers chains	kclfpdb_2	9	6
cache buffers chains	kcbgcur_6	8	14
cache buffers chains	kclpdc_5	6	370
cache buffers chains	kclpdcl	4	0
cache buffers chains	kcbgtcr	3	1
cache buffers chains	kcbgtcr: kslbegin shared	3	3
cache buffers chains	kclcls_3	3	10
cache buffers chains	kclcsr_2	2	1
cache buffers chains	kclgrantlk_1	2	0
cache buffers chains	kcbnew: new latch again	1	0
cache buffers chains	kcbzhngcbk1_1	1	0
cache buffers chains	kclpdc_3	1	14
cache buffers chains	kclpdcl_1	1	96
cache buffers lru chain	kcbzgws	48	0
cache buffers lru chain	kcbzgb_2	32	5
cache buffers lru chain	kcbo_link_q	4	0
cache buffers lru chain	kcbzgb	4	66
cache buffers lru chain	kclmvreqbg	2	9
cache buffers lru chain	kcbbxsv: move to being written	1	0
checkpoint queue latch	kclmergepi_3	2	1
corrupted undo seg latch	ktudiscorrupted	494	494
enqueue hash chains	ksqcmi: if lk mode not requested	47	22
enqueue hash chains	ksqrcl	36	9
enqueue hash chains	ksqcmi: if lk mode requested	7	58
enqueue hash chains	ksqgtl3	2	3
enqueues	ksqdel	4	4
enqueues	ksqgel: create enqueue	1	1
gc element	kclchkping	1,487	83
gc element	kclbla	734	42
gc element	kclpto	202	1,147
gc element	kclpto_3	107	39
gc element	kclnfndnewm	86	587
gc element	kclfwrite1	81	113
gc element	kclpto_1	48	0
gc element	kclhngcbk1_1	34	0
gc element	kclwrt	25	27
gc element	kclrwrite	24	91
gc element	kclpdc_3	14	17
gc element	kcl_fairness	13	2
gc element	kcllwr	12	12
gc element	KCLUNLNK	11	465
gc element	kclpdcl	6	4
gc element	kclfwrite2	5	8
gc element	kclulb	5	136
gc element	kclebs	4	22
gc element	kclnfnd	4	23
gc element	kclplz	4	46
gc element	kclnfnds	2	3
gc element	kclplz_1	2	15
gcs opaque info freelist	kjbrcvt save opaque info	7	8
gcs opaque info freelist	kjbrinfofree free opaque info	6	5
gcs remastering latch	kjfcdrmrfg end step	26	0
gcs resource hash	kjbassume	9	1
gcs resource hash	kjbopen	3	0
gcs resource hash	kjbcropen:affinity	2	1
gcs resource hash	kclfwrite1	1	0
gcs resource hash	kclrwrite	1	3
gcs resource hash	kjbcrconvert	1	0
gcs resource hash	kjblocalobj_nolock	1	1
gcs resource hash	kjbmpconvert	1	8
gcs resource hash	kjbrdrmcvtq_98	1	0
gcs resource hash	kjbrrcfwst	1	0
ges domain table	kjdmlad: add a lock to an xid-hashed lock list	1	1
ges enqueue table freelist	kjlalc: lock allocation	46	65
ges enqueue table freelist	kjlfr: remove lock from parent object	40	21
ges group table	kjgdgll: move a lock from group lock list to process lock list	15	4
ges group table	kjgagll: move a lock from process lock list to group lock list	11	22
ges resource hash list	kjlrlr: remove lock from resource queue	5,824	204
ges resource hash list	kjuscl: lock close request	2,863	7,143
ges resource hash list	kjrmas1: lookup master node	1,806	222
ges resource hash list	kjakcai: search for resp by resname	218	34
ges resource hash list	kjcvscn: remove from scan queue	171	0
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	162	10
ges resource hash list	kjrref: find matched resource	122	3,522
ges resource hash list	kjucvl: lock convert request	3	35
ges resource hash list	kjtscn: try lock res with nowait	1	0
ges resource table freelist	kjrm2c: move resource to cache	17	19
ges resource table freelist	kjruch: cached obj cleanup	2	0
ges resource table freelist	kjrchc: cached obj cleanup	1	1
lgwr LWN SCN	kcs023	18	0
messages	ksaamb: after wakeup	2	3
messages	ksarcv	2	0
messages	ksarcv: after wait	1	2
mostly latch-free SCN	kcslcu3	56	75
mostly latch-free SCN	kcs024	1	0
object queue header operation	kclobj_6	70	5
object queue header operation	kcbo_switch_mq_bg	56	80
object queue header operation	kcbo_link_q	55	38
object queue header operation	kclbufs	45	58
object queue header operation	kcbo_switch_cq	41	54
object queue header operation	kcbo_switch_q_bg	35	42
object queue header operation	kcbo_unlink_q_bg	22	43
object queue header operation	kcbo_unlink_q	19	19
object queue header operation	kclobj_1	2	0
object queue header operation	kcbo_sw_buf	1	0
post/wait queue	kslpstevent:get	3	1
post/wait queue	ksliwat:add:nowait	1	0
post/wait queue	kslpstevent:reget	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	2,352	0
redo allocation	kcrfw_redo_gen: redo allocation 3	590	3,020
redo allocation	kcrfw_redo_gen: redo allocation 2	284	0
redo allocation	kcrfw_redo_write: before write	33	116
redo allocation	kcrfw_post: more space	28	151
row cache objects	kqrpre: find obj	2,320	1,961
row cache objects	kqreqd: reget	1,352	124
row cache objects	kqreqd	228	1,812
row cache objects	kqrbgl	1	1
sequence cache	kdnssd	170	2
sequence cache	kdnnxt: cached seq	10	4
sequence cache	kdnss	10	183
session allocation	ksuxds_int	1	1
session idle bit	ksupuc: set busy	25	11
session idle bit	ksupuc: clear busy	18	29
shared pool	kghupr1	3	2
shared pool	kghalo	2	2
simulator hash latch	kcbsacc: lookup dba	1	1
undo global data	ktusmupst: KSLBEGIN	4	4
undo global data	ktudba: KSLBEGIN	3	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	kglpin1 4	2,031,597	-0
Cursor Pin	kksfbc [KKSCHLPIN1]	141,972	0
Library Cache	kglpnal2 91	41,587	0
Library Cache	kglpndl1 95	7,156	0
Cursor Pin	kksLockDelete [KKSCHLPIN6]	4,380	0
Library Cache	kglpnck1 88	1,605	0
Library Cache	kglpnal1 90	1,176	-0
Cursor Pin	kksfbc [KKSCHLFSP2]	260	0
Library Cache	kglhdgn2 106	110	-0
Cursor Pin	kkslce [KKSCHLPIN2]	48	-10
Library Cache	kgllkdl1 85	10	-0
Library Cache	kglllal3 111	3	-0
Library Cache	kgllldl2 112	2	-1

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 Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 110,012,697
Captured Segments account for 73.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
CIMISS	SOD_BDB_BIGDATA_1	SURF_WEA_CHN_PRE_MIN_UKH	SYS_P346505	INDEX PARTITION	21,269,072	19.33
CIMISS	SOD_BDB_BIGDATA_1	SURF_WEA_CHN_PRE_MIN_TAB	SYS_P346505	TABLE PARTITION	17,755,184	16.14
CIMISS	SOD_BDB_BIGDATA_1	SURF_WEA_CHN_PRE_MIN_UKH	SYS_P346472	INDEX PARTITION	11,778,528	10.71
CIMISS	SOD_BDB_BIGDATA_1	SURF_WEA_CHN_PRE_MIN_TAB	SYS_P346472	TABLE PARTITION	10,399,680	9.45
SYS	SYSTEM	I_CDEF4		INDEX	2,685,648	2.44

Buffer Nowait %:	98.69	Redo NoWait %:	99.97
Buffer Hit %:	99.72	In-memory Sort %:	100.00
Library Hit %:	99.98	Soft Parse %:	99.98
Execute to Parse %:	0.65	Latch Hit %:	98.86
Parse CPU to Parse Elapsd %:	17.41	% Non-Parse CPU:	99.19

Buffer access - local cache %:	98.94
Buffer access - remote cache %:	0.78
Buffer access - disk %:	0.28

Avg global enqueue get time (ms):	0.5
Avg global cache cr block receive time (ms):	0.9
Avg global cache current block receive time (ms):	1.7
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	12.9
Avg global cache cr block flush time (ms):	2.1
Avg global cache current block pin time (ms):	0.4
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	12.1
Avg global cache current block flush time (ms):	1.6

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.6
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	74.60
% of indirect sent messages:	24.94
% of flow controlled messages:	0.47

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
CIMISS	SOD_BDB_BIGDATA_1	SURF_WEA_CHN_MUL_HOR_TAB	SYS_P345572	TABLE PARTITION	69,060	22.60
CIMISS	SOD_BDB_BIGDATA_1	SURF_WEA_CHN_MUL_HOR_TAB	SYS_P346364	TABLE PARTITION	13,884	4.54
CIMISS	SOD_BDB_BIGDATA_1	SURF_WEA_CHN_MUL_HOR_TAB_UK_01	SYS_P345572	INDEX PARTITION	7,136	2.33
CIMISS	SOD_BDB_BIGDATA_1	SURF_WEA_CHN_MUL_FTM_WSET_TAB	SYS_P310856	TABLE PARTITION	6,671	2.18
CIMISS	SOD_BDB_BIGDATA_1	SURF_WEA_CHN_MUL_FTM_WSET_TAB	SYS_P310919	TABLE PARTITION	6,670	2.18

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	64	1.56	1	1
dc_files	1,022	0.00	0	73
dc_global_oids	3,986	0.03	0	91
dc_histogram_data	18,006	0.93	0	15,794
dc_histogram_defs	21,928	3.01	0	20,682
dc_objects	18,710	0.72	10	4,152
dc_profiles	52	0.00	0	1
dc_rollback_segments	491,983	0.00	0	397
dc_segments	34,767	15.47	401	17,822
dc_sequences	18,093	40.30	18,093	45
dc_tablespaces	10,978,235	0.00	0	27
dc_users	1,406,428	0.00	0	237
global database name	4,527	0.00	0	1
outstanding_alerts	137	97.81	4	0
sch_lj_oids	12	16.67	0	12

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
APP CONTEXT	7	0.00	7	0.00	0	0
BODY	5,058	0.10	11,425	0.05	0	0
CLUSTER	252	0.00	80	0.00	0	0
DBLINK	40	0.00	0		0	0
EDITION	60	0.00	108	0.00	0	0
INDEX	592	0.00	580	10.17	18	0
OBJECT ID	2	100.00	0		0	0
QUEUE	28	0.00	1,404	0.00	0	0
RULESET	4	0.00	4	0.00	0	0
SCHEMA	1,148	0.00	0		0	0
SQL AREA	32,684	2.42	8,813,045	0.02	746	484
SUBSCRIPTION	7	0.00	7	0.00	0	0
TABLE/PROCEDURE	7,371	0.27	5,797,714	0.01	561	0
TRIGGER	21,148	0.00	21,262	0.00	0	0

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases
BODY	0	11,394	11,394
CLUSTER	80	80	80
DBLINK	40	0	0
EDITION	60	60	60
INDEX	580	580	580
QUEUE	0	1,404	1,404
RULESET	0	4	4
SCHEMA	49	0	0
SUBSCRIPTION	0	7	7
TABLE/PROCEDURE	13,796	5,795,354	5,795,354
TRIGGER	0	21,262	21,262

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	20,096.00	20,096.00	19,968.00	20,352.00	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	12,928.00	12,928.00	12,928.00	12,928.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	24,064.00	24,064.00	24,064.00	24,064.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	128.00	128.00	128.00	128.00	STA/
large pool	128.00	128.00	128.00	128.00	STA/
shared pool	3,456.00	3,456.00	3,200.00	3,584.00	GRO/DEF
streams pool	0.00	0.00	0.00	0.00	STA/

	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	700.79		3.39	2.55	18	18	207	207
	Freeable	116.50	0.00	0.68	1.08	11		172	172
	PL/SQL	11.82	3.69	0.06	0.28	3	3	205	204
	SQL	7.49	0.32	0.04	0.03	0	7	177	171
E	Other	714.26		3.40	2.53	18	18	210	210
	Freeable	113.88	0.00	0.68	1.10	11		167	167
	PL/SQL	12.20	3.91	0.06	0.28	3	3	208	207
	SQL	5.25	0.51	0.03	0.04	0	7	181	174

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	21,072,183,296
Fixed Size	2,214,952
Redo Buffers	93,044,736
Variable Size	17,448,305,624

Pool	Name	Begin MB	End MB	% Diff
java	free memory	128.00	128.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	119.81	119.81	0.00
shared	ASM extent pointer array	42.08	42.08	0.00
shared	CCUR	53.90	55.63	3.21
shared	FileOpenBlock	105.56	105.56	0.00
shared	KCL name table	96.00	96.00	0.00
shared	KGH: NO ACCESS	255.85	255.85	0.00
shared	KQR L PO		38.34
shared	PCUR	47.99	48.88	1.87
shared	SQLA	347.51	353.97	1.86
shared	db_block_hash_buckets	178.00	178.00	0.00
shared	free memory	1,307.66	1,287.82	-1.52
shared	gcs resources	397.76	397.76	0.00
shared	gcs shadows	287.27	287.27	0.00
shared	ges enqueues	44.71	44.71	0.00
	buffer_cache	20,096.00	20,096.00	0.00
	fixed_sga	2.11	2.11	0.00
	log_buffer	88.73	88.73	0.00

Name	Total Disp Time (s)	%Busy	%Idle
D000	3,634	0.00	100.00
D000	3,634	0.00	100.00
D000	3,634	0.00	100.00
D000	3,634	0.00	100.00
Sum
Avg		0.00	100.00
Std		0.00	0.00

Parameter Name	Begin value	End value (if different)
_resource_manager_always_on	FALSE
audit_file_dest	/space/sys_software/oracle/app/admin/babjdb/adump
audit_trail	DB
cluster_database	TRUE
compatible	11.2.0.0.0
control_files	+DATA/babjdb/controlfile/current.256.755707847
db_block_size	8192
db_create_file_dest	+DATA
db_domain
db_name	babjdb
deferred_segment_creation	FALSE
diagnostic_dest	/space/sys_software/oracle/app
dispatchers	(PROTOCOL=TCP) (SERVICE=babjdbXDB)
instance_number	2
local_listener	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=db02_vip)(PORT=1521))))
log_archive_dest	+REVDG
memory_target	38788923392
open_cursors	800
processes	1500
remote_listener	scanip:1521
remote_login_passwordfile	EXCLUSIVE
sessions	2272
spfile	+DATA/babjdb/spfilebabjdb.ora
thread	2
undo_tablespace	UNDOTBS2

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	323,267	88.96	1.20
acks for commit broadcast(logical)	388,685	106.96	1.44
broadcast msgs on commit(actual)	227,925	62.72	0.84
broadcast msgs on commit(logical)	232,920	64.10	0.86
broadcast msgs on commit(wasted)	36,525	10.05	0.14
broadcast on commit wait time(ms)	7,785	2.14	0.03
broadcast on commit waits	37,190	10.23	0.14
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
false posts waiting for scn acks	16	0.00	0.00
flow control messages received	47	0.01	0.00
flow control messages sent	0	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	11	0.00	0.00
gcs assume no cvt	398,624	109.70	1.48
gcs ast xid	4,257	1.17	0.02
gcs blocked converts	854,505	235.15	3.16
gcs blocked cr converts	174,080	47.90	0.64
gcs compatible basts	529	0.15	0.00
gcs compatible cr basts (global)	13,997	3.85	0.05
gcs compatible cr basts (local)	0	0.00	0.00
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	61,399	16.90	0.23
gcs dbwr write request msgs	32,683	8.99	0.12
gcs delta msgs sent	0	0.00	0.00
gcs delta push aborted by cancel	0	0.00	0.00
gcs delta push aborted by remastering	0	0.00	0.00
gcs delta push cancelled	0	0.00	0.00
gcs delta push cancelled at master	0	0.00	0.00
gcs delta push cancelled by close	0	0.00	0.00
gcs delta push cancelled by consign	0	0.00	0.00
gcs delta push cancelled by cvt ping	0	0.00	0.00
gcs delta push cancelled by dwncvt	0	0.00	0.00
gcs delta push create pi	0	0.00	0.00
gcs delta update master msgs sent	0	0.00	0.00
gcs delta wait aborted by remastering	0	0.00	0.00
gcs delta wait cancelled	0	0.00	0.00
gcs error msgs	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	7,169	1.97	0.03
gcs immediate (null) converts	107,543	29.59	0.40
gcs immediate cr (compatible) converts	174,285	47.96	0.65
gcs immediate cr (null) converts	157,255	43.27	0.58
gcs indirect ast	188,688	51.92	0.70
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	186,582	51.34	0.69
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	22,506	6.19	0.08
gcs msgs process time(ms)	43,130	11.87	0.16
gcs msgs received	2,207,776	607.55	8.18
gcs new served by master	93,063	25.61	0.34
gcs out-of-order msgs	272	0.07	0.00
gcs pings refused	7,067	1.94	0.03
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	6,493	1.79	0.02
gcs reader bypass N->Xw ping local	0	0.00	0.00
gcs reader bypass N->Xw ping remote	0	0.00	0.00
gcs reader bypass grant X on assume	0	0.00	0.00
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	0	0.00	0.00
gcs reader bypass grant immediate	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	4,141	1.14	0.02
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	9,086	2.50	0.03
gcs side channel msgs logical	955,150	262.84	3.54
gcs stale cr	94,682	26.06	0.35
gcs undo cr	1,715	0.47	0.01
gcs write notification msgs	5,673	1.56	0.02
gcs writes refused	3,953	1.09	0.01
ges msgs process time(ms)	1,242	0.34	0.00
ges msgs received	115,035	31.66	0.43
global posts dropped	0	0.00	0.00
global posts queue time	50	0.01	0.00
global posts queued	32	0.01	0.00
global posts requested	32	0.01	0.00
global posts sent	32	0.01	0.00
implicit batch messages received	42,758	11.77	0.16
implicit batch messages sent	37,833	10.41	0.14
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	7,656	2.11	0.03
messages queue sent actual	651,491	179.28	2.41
messages queue sent logical	103,126	28.38	0.38
messages received actual	1,986,245	546.59	7.36
messages received logical	2,322,763	639.19	8.60
messages sent directly	1,220,941	335.99	4.52
messages sent indirectly	408,160	112.32	1.51
messages sent not implicit batched	83	0.02	0.00
messages sent pbatched	861,804	237.16	3.19
msgs causing lmd to send msgs	34,211	9.41	0.13
msgs causing lms(s) to send msgs	63,394	17.45	0.23
msgs received queue time (ms)	19,618	5.40	0.07
msgs received queued	2,322,728	639.18	8.60
msgs sent queue time (ms)	12,439	3.42	0.05
msgs sent queue time on ksxp (ms)	1,199,525	330.09	4.44
msgs sent queued	706,210	194.34	2.62
msgs sent queued on ksxp	1,890,896	520.35	7.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	363,794	100.11	1.35
process batch messages sent	565,012	155.48	2.09

Statistic	Total
CR Block Requests	17,173
CURRENT Block Requests	144,984
Data Block Requests	17,176
Undo Block Requests	1,715
TX Block Requests	75,896
Current Results	114,984
Private results	40
Zero Results	793
Disk Read Results	46,258
Fail Results	6
Fairness Down Converts	13,434
Fairness Clears	8,755
Free GC Elements	0
Flushes	14,943
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	1,563
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	698,657	93.37	6.09	0.51	0.02	0.00
Flushes	84,412	53.49	45.38	1.11	0.02	0.00
Writes	63,881	1.42	16.34	81.55	0.62	0.07

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
1	data block	31,383	93.78	5.51	0.71	679,741	85.85	14.07	0.08
1	undo header	79,033	98.39	1.52	0.09	928	95.58	4.31	0.11
1	Others	47,831	28.21	71.71	0.07	19,578	81.31	18.63	0.07
1	undo block	1,623	93.35	6.59	0.06	0

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
1	data block	1.34	1.23	2.87	3.17	1.65	0.63	7.90	6.99
1	undo header	0.44	0.40	2.54	2.55	0.51	0.44	2.01	0.30
1	others	1.31	0.43	1.65	1.47	4.50	1.24	18.78	1.28
1	undo block	0.57	0.40	3.07	0.42

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
1	data block	0	29,431	100.00	0.00	583,587	100.00	0.00
1	undo header	0	77,763	100.00	0.00	887	100.00	0.00
1	others	0	13,495	100.00	0.00	15,918	100.00	0.00
1	undo block	0	1,515	100.00	0.00	0

WORKLOAD REPOSITORY report for

Report Summary

RAC Statistics

Main Report

More RAC Statistics

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

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

SQL ordered by Cluster Wait Time

Complete List of SQL Text

Instance Activity Statistics

Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

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

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

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

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	1.33	1.37
Parallel Query	0.00	0.00
DB Locks	0.15	0.16
DB Streams	0.00	0.00
Other	0.01	0.00

Name	Total	per Remaster Op	Begin Snap	End Snap
remaster ops	2	1.00
remastered objects	4	2.00
replayed locks received	0	0.00
replayed locks sent	0	0.00
resources cleaned	0	0.00
remaster time (s)	4.5	2.26
quiesce time (s)	1.2	0.59
freeze time (s)	0.2	0.11
cleanup time (s)	0.9	0.46
replay time (s)	0.4	0.20
fixwrite time (s)	1.7	0.87
sync time (s)	0.0	0.01
affinity objects			37	37