WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

OANET 4070728275 oanet2 2 22-2月 -12 23:02 11.2.0.3.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
OANET	4070728275	oanet2	2	22-2月 -12 23:02	11.2.0.3.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

GIO-YW0128 Microsoft Windows x86 64-bit 16 16 4 32.00

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
GIO-YW0128	Microsoft Windows x86 64-bit	16	16	4	32.00

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 4792 16-3月 -12 08:39:55 296 18.4

End Snap: 4793 16-3月 -12 08:59:57 303 18.9

Elapsed: 20.04 (mins)

DB Time: 25.24 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	4792	16-3月 -12 08:39:55	296	18.4
End Snap:	4793	16-3月 -12 08:59:57	303	18.9
Elapsed:		20.04 (mins)
DB Time:		25.24 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 6,464M 6,464M Std Block Size: 8K

Shared Pool Size: 7,296M 7,296M Log Buffer: 30,540K

	Begin	End
Buffer Cache:	6,464M	6,464M	Std Block Size:	8K
Shared Pool Size:	7,296M	7,296M	Log Buffer:	30,540K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 1.3 0.7 0.00 0.00

DB CPU(s): 0.8 0.4 0.00 0.00

Redo size: 38,656.0 20,661.8

Logical reads: 51,846.3 27,712.1

Block changes: 124.8 66.7

Physical reads: 1,604.8 857.8

Physical writes: 7.9 4.2

User calls: 2,254.6 1,205.1

Parses: 112.5 60.1

Hard parses: 1.4 0.8

W/A MB processed: 7.1 3.8

Logons: 9.0 4.8

Executes: 342.0 182.8

Rollbacks: 0.0 0.0

Transactions: 1.9

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.3	0.7	0.00	0.00
DB CPU(s):	0.8	0.4	0.00	0.00
Redo size:	38,656.0	20,661.8
Logical reads:	51,846.3	27,712.1
Block changes:	124.8	66.7
Physical reads:	1,604.8	857.8
Physical writes:	7.9	4.2
User calls:	2,254.6	1,205.1
Parses:	112.5	60.1
Hard parses:	1.4	0.8
W/A MB processed:	7.1	3.8
Logons:	9.0	4.8
Executes:	342.0	182.8
Rollbacks:	0.0	0.0
Transactions:	1.9

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 100.00

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

Library Hit %: 99.03 Soft Parse %: 98.72

Execute to Parse %: 67.11 Latch Hit %: 99.85

Parse CPU to Parse Elapsd %: 97.14 % Non-Parse CPU: 96.27

Shared Pool Statistics

Begin End

Memory Usage %: 87.16 87.07

% SQL with executions>1: 98.11 95.55

% Memory for SQL w/exec>1: 96.66 92.46

	Begin	End
Memory Usage %:	87.16	87.07
% SQL with executions>1:	98.11	95.55
% Memory for SQL w/exec>1:	96.66	92.46

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		902		59.59
log file sync	23,115	294	13	19.44	Commit
gc buffer busy acquire	3,445	82	24	5.42	Cluster
gc current block busy	4,511	79	18	5.25	Cluster
direct path read	15,767	77	5	5.06	User I/O

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

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

5.6 3.6 90.8

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
		5.6	3.6		90.8

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

4.8 52.7 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 32,767.2 32,767.2

SGA use (MB): 14,016.0 14,016.0

PGA use (MB): 1,702.5 1,763.1

% Host Mem used for SGA+PGA: 47.97 48.16

	Begin	End
Host Mem (MB):	32,767.2	32,767.2
SGA use (MB):	14,016.0	14,016.0
PGA use (MB):	1,702.5	1,763.1
% Host Mem used for SGA+PGA:	47.97	48.16

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: 18.81 10.05

Global Cache blocks served: 28.03 14.98

GCS/GES messages received: 89.40 47.78

GCS/GES messages sent: 82.37 44.03

DBWR Fusion writes: 1.76 0.94

Estd Interconnect traffic (KB) 408.25

	Per Second	Per Transaction
Global Cache blocks received:	18.81	10.05
Global Cache blocks served:	28.03	14.98
GCS/GES messages received:	89.40	47.78
GCS/GES messages sent:	82.37	44.03
DBWR Fusion writes:	1.76	0.94
Estd Interconnect traffic (KB)	408.25

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

Buffer access - local cache %: 99.96

Buffer access - remote cache %: 0.04

Buffer access - disk %: 0.00

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0

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

Avg global cache current block receive time (ms): 5.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 %: 2.3

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

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

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

Global cache log flushes for current blocks served %: 20.4

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1

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

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.1

Avg GES message process time (ms): 0.0

% of direct sent messages: 72.58

% of indirect sent messages: 26.81

% of flow controlled messages: 0.61

Cluster Interconnect

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

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
prvnic	192.168.0.128	N

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): 1514.3s
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	912.02	60.23
DB CPU	902.37	59.59
connection management call elapsed time	436.31	28.81
parse time elapsed	41.15	2.72
hard parse elapsed time	30.81	2.03
hard parse (sharing criteria) elapsed time	12.08	0.80
PL/SQL execution elapsed time	9.52	0.63
repeated bind elapsed time	0.48	0.03
sequence load elapsed time	0.01	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
failed parse elapsed time	0.00	0.00
DB time	1,514.27
background elapsed time	411.69
background cpu time	30.72

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
AVG_BUSY_TIME	11,013
AVG_IDLE_TIME	109,229
AVG_SYS_TIME	4,327
AVG_USER_TIME	6,626
BUSY_TIME	177,181
IDLE_TIME	1,748,715
SYS_TIME	70,238
USER_TIME	106,977
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	34,358,849,536
NUM_CPUS	16
NUM_CPU_CORES	16
NUM_CPU_SOCKETS	4

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
16-3月 08:39:55	0.00
16-3月 08:59:57	0.00	9.20	5.55	3.65	90.80	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 102.1% of Total DB time 1,514.27 (s)
Total FG Wait Time: 644.01 (s) DB CPU time: 902.37 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			902		59.59
Commit	23,115	0	294	13	19.44
Cluster	31,049	0	233	8	15.39
User I/O	26,234	0	95	4	6.28
Network	2,749,598	0	11	0	0.70
Other	22,877	85	6	0	0.38
Concurrency	7,029	0	3	0	0.23
System I/O	879	0	1	1	0.06
Application	496	0	0	1	0.03
Configuration	87	2	0	3	0.02

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
log file sync	23,115	0	294	13	10.27	19.44
gc buffer busy acquire	3,445	0	82	24	1.53	5.42
gc current block busy	4,511	0	79	18	2.00	5.25
direct path read	15,767	0	77	5	7.01	5.06
gc current block 2-way	9,576	0	27	3	4.26	1.76
gc buffer busy release	1,219	0	20	16	0.54	1.32
gc cr block 2-way	7,514	0	15	2	3.34	1.02
db file sequential read	1,265	0	9	7	0.56	0.57
SQL*Net more data to client	128,836	0	8	0	57.26	0.52
direct path write	462	0	6	13	0.21	0.41
gc cr block busy	258	0	5	20	0.11	0.34
PX Nsq: PQ load info query	18	100	4	200	0.01	0.24
gc current grant busy	3,664	0	3	1	1.63	0.22
SQL*Net message to client	2,608,198	0	2	0	1,159.20	0.16
read by other session	361	0	2	6	0.16	0.13
library cache: mutex X	1,137	0	2	2	0.51	0.13
Disk file operations I/O	8,374	0	2	0	3.72	0.11
control file sequential read	879	0	1	1	0.39	0.06
PX Deq: Slave Session Stats	684	0	1	1	0.30	0.04
library cache lock	9	0	1	64	0.00	0.04
enq: KO - fast object checkpoint	118	0	0	4	0.05	0.03
gc cr grant 2-way	527	0	0	1	0.23	0.03
reliable message	742	0	0	1	0.33	0.03
buffer busy waits	1,355	0	0	0	0.60	0.03
enq: PS - contention	401	20	0	1	0.18	0.02
latch: cache buffers chains	4,444	0	0	0	1.98	0.02
enq: HW - contention	87	2	0	3	0.04	0.02
PX Deq: reap credit	19,401	100	0	0	8.62	0.02
PX Deq: Signal ACK RSG	424	0	0	0	0.19	0.01
SQL*Net more data from client	12,564	0	0	0	5.58	0.01
db file parallel read	5	0	0	32	0.00	0.01
CSS initialization	22	0	0	6	0.01	0.01
gc current grant 2-way	201	0	0	1	0.09	0.01
gc cr multi block request	39	0	0	3	0.02	0.01
CSS operation: action	22	0	0	5	0.01	0.01
row cache lock	39	0	0	2	0.02	0.00
ADR block file read	8	0	0	9	0.00	0.00
gc current multi block request	58	0	0	1	0.03	0.00
cursor: pin S wait on X	2	0	0	30	0.00	0.00
gc current block congested	16	0	0	3	0.01	0.00
gc cr block congested	19	0	0	2	0.01	0.00
SQL*Net break/reset to client	378	0	0	0	0.17	0.00
CSS operation: query	66	0	0	0	0.03	0.00
PX Deq: Signal ACK EXT	424	0	0	0	0.19	0.00
enq: TX - index contention	6	0	0	3	0.00	0.00
enq: FB - contention	4	0	0	3	0.00	0.00
library cache pin	11	0	0	1	0.00	0.00
IPC send completion sync	522	0	0	0	0.23	0.00
latch: ges resource hash list	17	0	0	0	0.01	0.00
SQL*Net message from client	2,608,192	0	1,109,065	425	1,159.20
wait for unread message on broadcast channel	1,210	99	1,203	994	0.54
Streams AQ: waiting for messages in the queue	254	97	1,200	4726	0.11
PX Deq Credit: send blkd	5,484	0	8	1	2.44
PX Deq: Execution Msg	2,548	0	4	2	1.13
PX Deq: Execute Reply	2,303	0	1	0	1.02
PX Deq: Join ACK	424	0	1	2	0.19
PX Deq: Parse Reply	424	0	1	1	0.19
PX Deq: Msg Fragment	16	0	0	2	0.01

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	22,414	0	211	9	9.96	51.28
db file parallel write	5,210	0	55	11	2.32	13.44
gcs log flush sync	9,844	18	52	5	4.38	12.67
Streams AQ: qmn coordinator waiting for slave to start	3	100	15	5005	0.00	3.65
control file parallel write	581	0	9	16	0.26	2.21
os thread startup	18	0	8	417	0.01	1.82
control file sequential read	3,742	0	7	2	1.66	1.70
enq: WF - contention	22	0	1	31	0.01	0.16
name-service call wait	8	0	1	79	0.00	0.15
gc current block 2-way	311	0	1	2	0.14	0.12
ges inquiry response	873	0	0	1	0.39	0.12
gc cr block 2-way	290	0	0	1	0.13	0.08
gc current block busy	20	0	0	14	0.01	0.07
CSS operation: data query	60	0	0	3	0.03	0.04
gc current grant busy	132	0	0	1	0.06	0.03
enq: TM - contention	3	67	0	40	0.00	0.03
CGS wait for IPC msg	9,017	100	0	0	4.01	0.02
db file sequential read	10	0	0	7	0.00	0.02
ASM file metadata operation	364	0	0	0	0.16	0.02
gc buffer busy release	8	0	0	8	0.00	0.01
DFS lock handle	88	97	0	1	0.04	0.01
gc current multi block request	3	0	0	18	0.00	0.01
reliable message	44	0	0	1	0.02	0.01
enq: KO - fast object checkpoint	81	0	0	1	0.04	0.01
SQL*Net message to client	42,258	0	0	0	18.78	0.01
CSS group membership query	20	0	0	2	0.01	0.01
gc cr block busy	4	0	0	10	0.00	0.01
asynch descriptor resize	10,590	100	0	0	4.71	0.01
LGWR wait for redo copy	586	0	0	0	0.26	0.01
CSS operation: action	20	0	0	1	0.01	0.01
enq: CF - contention	37	100	0	1	0.02	0.01
log file sync	2	0	0	14	0.00	0.01
PX Deq: reap credit	3,991	104	0	0	1.77	0.01
latch: call allocation	186	0	0	0	0.08	0.01
enq: PI - contention	8	100	0	3	0.00	0.00
gc current grant 2-way	20	0	0	1	0.01	0.00
ksxr poll remote instances	1,980	100	0	0	0.88	0.00
latch free	9	0	0	2	0.00	0.00
row cache lock	28	0	0	1	0.01	0.00
row cache cleanup	3,246	0	0	0	1.44	0.00
direct path write	1	0	0	12	0.00	0.00
CSS initialization	2	0	0	6	0.00	0.00
PX Deq: Slave Session Stats	6	0	0	2	0.00	0.00
enq: US - contention	3	0	0	3	0.00	0.00
row cache process	3,425	0	0	0	1.52	0.00
db file async I/O submit	4,675	0	0	0	2.08	0.00
enq: PS - contention	8	50	0	1	0.00	0.00
PX Deq: Signal ACK RSG	6	0	0	1	0.00	0.00
Disk file operations I/O	65	0	0	0	0.03	0.00
enq: TA - contention	4	0	0	1	0.00	0.00
libcache interrupt action by LCK	3,153	0	0	0	1.40	0.00
CSS operation: query	26	0	0	0	0.01	0.00
enq: TD - KTF dump entries	3	0	0	1	0.00	0.00
gc cr grant 2-way	2	0	0	1	0.00	0.00
latch: active service list	54	0	0	0	0.02	0.00
rdbms ipc message	65,287	29	29,153	447	29.02
PX Idle Wait	272	0	9,053	33282	0.12
class slave wait	187	0	2,741	14660	0.08
wait for unread message on broadcast channel	2,407	100	2,407	1000	1.07
DIAG idle wait	31,370	72	2,399	76	13.94
gcs remote message	221,109	64	2,330	11	98.27
Space Manager: slave idle wait	366	98	1,804	4930	0.16
smon timer	9	33	1,502	166889	0.00
Streams AQ: qmn slave idle wait	55	5	1,385	25179	0.02
PING	831	12	1,213	1459	0.37
Streams AQ: waiting for time management or cleanup tasks	137	85	1,212	8849	0.06
ASM background timer	244	0	1,205	4940	0.11
GCR sleep	241	100	1,205	5000	0.11
pmon timer	497	74	1,202	2419	0.22
ges remote message	13,661	77	1,202	88	6.07
dispatcher timer	20	100	1,200	60002	0.01
shared server idle wait	40	100	1,200	30001	0.02
Streams AQ: qmn coordinator idle wait	89	48	1,190	13368	0.04
SQL*Net message from client	52,830	0	91	2	23.48
heartbeat monitor sleep	6	0	0	2	0.00
PX Deq: Join ACK	6	0	0	2	0.00
KSV master wait	850	95	0	0	0.38
PX Deq: Parse Reply	6	0	0	1	0.00
PX Deq: Execute Reply	6	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	8			37.5	25.0	25.0	12.5
ASM file metadata operation	363	99.7					.3
CGS wait for IPC msg	9020	100.0
CSS group membership query	20		25.0	75.0
CSS initialization	24	50.0				50.0
CSS operation: action	42	21.4		26.2	47.6	4.8
CSS operation: data query	60			93.3	6.7
CSS operation: query	92	87.0	1.1	12.0
DFS lock handle	71	98.6	1.4
Disk file operations I/O	8432	99.8	.0	.0	.1	.1	.0
IPC send completion sync	553	100.0
LGWR wait for redo copy	586	100.0
PX Deq: Signal ACK EXT	430	100.0
PX Deq: Signal ACK RSG	430	87.9	10.5	.9	.2		.5
PX Deq: Slave Session Stats	697	69.4	8.2	20.7	1.7
PX Deq: reap credit	23.6K	100.0
PX Nsq: PQ load info query	18							100.0
PX qref latch	2	100.0
SQL*Net break/reset to client	378	99.2	.8
SQL*Net message to client	2654.5K	100.0
SQL*Net more data from client	12.6K	100.0	.0
SQL*Net more data to client	128.4K	99.5	.3	.1	.0	.0	.0	.0
Streams AQ: qmn coordinator waiting for slave to start	3								100.0
asynch descriptor resize	10.6K	100.0
buffer busy waits	1356	94.9	1.5	3.2	.4
control file parallel write	581			.2	14.5	71.9	9.0	4.5
control file sequential read	4621	93.2	2.3	.6	1.0	1.3	.5	1.2
cursor: mutex X	1	100.0
cursor: pin S	1	100.0
cursor: pin S wait on X	2					50.0		50.0
db file async I/O submit	4677	100.0
db file parallel read	5					60.0	20.0	20.0
db file parallel write	5211	1.9	1.7	4.2	32.7	51.9	5.6	1.9
db file sequential read	1271	26.7	3.5	3.7	32.6	30.4	1.8	1.3
direct path read	15.7K	43.4	14.4	10.8	14.8	11.3	3.3	2.0
direct path write	463	6.7	6.5	14.3	26.8	24.2	11.4	10.2
enq: CF - contention	38	92.1	2.6	2.6	2.6
enq: CR - block range reuse ckpt	1	100.0
enq: DR - contention	1	100.0
enq: FB - contention	4	50.0			50.0
enq: HW - contention	87	63.2	26.4	3.4		1.1	3.4	2.3
enq: KO - fast object checkpoint	199	97.5	.5	.5		1.0		.5
enq: PI - contention	8	50.0	25.0		12.5	12.5
enq: PS - contention	409	89.7	8.1	1.2	.5	.5
enq: TA - contention	3	100.0
enq: TD - KTF dump entries	2	100.0
enq: TM - contention	3	66.7						33.3
enq: TX - index contention	14	35.7			21.4	35.7	7.1
enq: US - contention	2	100.0
enq: WF - contention	22	81.8	4.5					13.6
gc buffer busy acquire	3444	15.1	24.6	8.0	14.2	16.7	12.6	8.8
gc buffer busy release	1227	11.3	6.3	13.9	30.5	17.8	11.4	8.8
gc cr block 2-way	7793	17.1	69.7	10.4	1.7	.8	.1	.2
gc cr block busy	263	.4		2.7	27.4	47.9	11.8	9.9
gc cr block congested	19	21.1	57.9	5.3	10.5	5.3
gc cr grant 2-way	529	89.8	7.8	.8	.8	.6	.4
gc cr grant congested	1	100.0
gc cr multi block request	39	10.3	43.6	33.3	7.7	5.1
gc current block 2-way	9855	12.1	58.3	21.6	4.4	2.8	.4	.3
gc current block busy	4546	.2	1.2	7.2	28.2	35.9	21.7	5.7
gc current block congested	16	6.3	25.0	62.5		6.3
gc current grant 2-way	223	92.8	5.4	1.3	.4
gc current grant busy	3786	86.5	10.8	1.0	1.1	.4	.2	.1
gc current multi block request	59	81.4	15.3		1.7	1.7
gc current retry	1	100.0
gc current split	8	100.0
gcs log flush sync	9855	20.7	8.0	14.0	36.8	16.8	3.7
ges inquiry response	875	97.9	1.7	.2	.1
ksxr poll remote instances	1967	100.0
latch free	25	92.0			8.0
latch: active service list	85	100.0
latch: cache buffers chains	4457	100.0
latch: cache buffers lru chain	1	100.0
latch: call allocation	191	100.0
latch: enqueue hash chains	1	100.0
latch: gc element	58	100.0
latch: gcs resource hash	1	100.0
latch: ges resource hash list	17	100.0
latch: parallel query alloc buffer	1	100.0
latch: row cache objects	1	100.0
latch: shared pool	26	100.0
libcache interrupt action by LCK	3130	100.0
library cache lock	9	77.8	11.1					11.1
library cache pin	11	90.9			9.1
library cache: mutex X	1121	82.6				16.6	.8
lock escalate retry	4	100.0
log file parallel write	22.4K			1.9	73.6	18.3	4.6	1.6
log file sync	23K	.1	.1	3.9	52.2	32.1	8.2	3.3
name-service call wait	8						12.5	87.5
os thread startup	18					44.4		38.9	16.7
read by other session	361	17.5	20.8	12.5	29.9	15.5	2.2	1.7
reliable message	776	92.1	1.9	3.9	1.7	.3		.1
row cache cleanup	3220	100.0
row cache lock	65	87.7	1.5		4.6	6.2
row cache process	3394	100.0
wait list latch free	2	100.0
ASM background timer	243							1.2	98.8
DIAG idle wait	31.4K	2.6	.8	2.0	.3	2.5	40.4	51.4
GCR sleep	241								100.0
KSV master wait	862	100.0
PING	831	88.1	.2						11.7
PX Deq Credit: send blkd	5484	1.4	97.7	.6	.3
PX Deq: Execute Reply	2309	96.6	1.3	.6	.7	.4	.2	.2
PX Deq: Execution Msg	2523	70.4	16.2	9.1	1.3	1.5	.8	.6
PX Deq: Join ACK	430	62.3	1.2	32.6	2.3	1.2		.5
PX Deq: Msg Fragment	16		93.8	6.3
PX Deq: Parse Reply	430	40.9	47.9	9.8		1.2	.2
PX Deq: Table Q Normal	1	100.0
PX Idle Wait	265			8.7	34.3	3.0	1.1	7.5	45.3
SQL*Net message from client	2665K	91.8	4.0	2.1	.7	.2	.1	.8	.3
Space Manager: slave idle wait	363	.3						.8	98.9
Streams AQ: RAC qmn coordinator idle wait	90	100.0
Streams AQ: qmn coordinator idle wait	89	48.3							51.7
Streams AQ: qmn slave idle wait	55								100.0
Streams AQ: waiting for messages in the queue	254					3.5		.8	95.7
Streams AQ: waiting for time management or cleanup tasks	137	15.3						43.8	40.9
class slave wait	185	35.7	.5	2.2	3.8			28.1	29.7
dispatcher timer	20								100.0
gcs remote message	221K	7.2	6.9	5.5	11.9	42.2	26.4
ges remote message	13.6K	10.4	1.1	1.5	.7	1.9	1.8	82.7
heartbeat monitor sleep	6		83.3		16.7
pmon timer	498	6.0	1.4	1.2	1.2	.6	.4	6.2	82.9
rdbms ipc message	65.2K	37.8	2.7	5.6	2.7	5.0	5.4	31.0	9.8
shared server idle wait	40								100.0
smon timer	7	14.3							85.7
wait for unread message on broadcast channel	3616	.1						99.9

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
PX Nsq: PQ load info query	18				100.0
SQL*Net more data to client	1	100.0	.0
control file parallel write	26	95.5	1.9	1.9	.7
control file sequential read	56	98.8	.9	.3
cursor: pin S wait on X	1	50.0	50.0
db file parallel read	1	80.0		20.0
db file parallel write	101	98.1	.8	.9	.2
db file sequential read	16	98.7	.7	.6
direct path read	311	98.0	1.3	.5	.1
direct path write	47	89.8	7.1	3.0
enq: HW - contention	2	97.7	2.3
enq: KO - fast object checkpoint	1	99.5				.5
enq: TM - contention	1	66.7		33.3
enq: WF - contention	3	86.4	4.5		4.5	4.5
gc buffer busy acquire	302	91.2	2.7	.9	1.6	3.2	.4
gc buffer busy release	108	91.2	4.6	2.0	1.3	.8
gc cr block 2-way	13	99.8		.0		.2
gc cr block busy	26	90.1	3.8	3.8	1.5	.8
gc current block 2-way	29	99.7	.1		.0	.2
gc current block busy	259	94.3	3.7	.6	.2	1.2	.0
gc current grant busy	3	99.9	.1			.0
library cache lock	1	88.9					11.1
log file parallel write	366	98.4	.8	.5	.3	.0
log file sync	770	96.7	1.5	.8	.7	.3
name-service call wait	7	12.5		87.5
os thread startup	9	44.4		33.3		5.6		11.1	5.6
read by other session	6	98.3	1.7
reliable message	1	99.9	.1

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
Streams AQ: qmn coordinator waiting for slave to start	3			100.0
os thread startup	1	94.4	5.6

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)
oanet	1,242	881	818	61,123
SYS$USERS	272	21	1,112	1,137
SYS$BACKGROUND	0	0	0	28
oanetXDB	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
oanet	24194	67	7017	3	2747898	11
SYS$USERS	2040	29	4	1	1378	0
SYS$BACKGROUND	75	0	3207	8	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 36.0% of Total DB Time (s): 1,514
Captured PL/SQL account for 0.0% of Total DB Time (s): 1,514

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
126.60	10,610	0.01	8.36	5.69	0.97	4vs91dcv7u1p6		insert into sys.aud$( sessioni...
89.57	10,599	0.01	5.92	5.56	0.30	f711myt0q6cma		insert into sys.aud$( sessioni...
37.91	1	37.91	2.50	24.03	75.00	d15cdr0zt3vtp	Oracle Enterprise Manager.Metric Engine	SELECT TO_CHAR(current_timesta...
36.78	3	12.26	2.43	98.48	0.00	8vx0yn7u2n6xn	JDBC Thin Client	select FRAMNAME, USER_CODE fro...
25.12	21,204	0.00	1.66	83.02	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
22.73	43	0.53	1.50	20.59	74.87	9w2qykn1r44zd	JDBC Thin Client	select count(*) as CNT from de...
16.61	2,825	0.01	1.10	93.27	0.00	c3m2v78k06wvy	JDBC Thin Client	SELECT NULL AS table_cat, c.ow...
12.26	115	0.11	0.81	98.47	0.00	3a30ztcktkh6c		select max(sms_send_seq)as sms...
12.05	37,815	0.00	0.80	93.63	0.00	6501mstynpg0v	JDBC Thin Client	SELECT FRAMNAME2 FROM V_RPT_FR...
9.77	84	0.12	0.65	99.93	0.01	afxn34s636ba8	JDBC Thin Client	select C_FLOW_INID, C_FLOW_INI...

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 29.0% of Total CPU Time (s): 902
Captured PL/SQL account for 0.0% of Total CPU Time (s): 902

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
36.22	3	12.07	4.01	36.78	98.48	0.00	8vx0yn7u2n6xn	JDBC Thin Client	select FRAMNAME, USER_CODE fro...
20.86	21,204	0.00	2.31	25.12	83.02	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
15.49	2,825	0.01	1.72	16.61	93.27	0.00	c3m2v78k06wvy	JDBC Thin Client	SELECT NULL AS table_cat, c.ow...
12.07	115	0.10	1.34	12.26	98.47	0.00	3a30ztcktkh6c		select max(sms_send_seq)as sms...
11.28	37,815	0.00	1.25	12.05	93.63	0.00	6501mstynpg0v	JDBC Thin Client	SELECT FRAMNAME2 FROM V_RPT_FR...
10.06	26,961	0.00	1.12	9.50	105.90	0.00	c4f1v62z1pfgz	JDBC Thin Client	SELECT FRAMNAME3 FROM V_RPT_FR...
9.77	84	0.12	1.08	9.77	99.93	0.01	afxn34s636ba8	JDBC Thin Client	select C_FLOW_INID, C_FLOW_INI...
9.39	26,961	0.00	1.04	9.43	99.60	0.00	chr72bqg3x425	JDBC Thin Client	SELECT FRAMNAME5 FROM V_RPT_FR...
9.11	1	9.11	1.01	37.91	24.03	75.00	d15cdr0zt3vtp	Oracle Enterprise Manager.Metric Engine	SELECT TO_CHAR(current_timesta...
9.00	77	0.12	1.00	9.33	96.47	0.01	guh4ntbgbt1mc	JDBC Thin Client	select PACT_NAME, PACT_NAME fr...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
28.43	1	28.43	29.88	37.91	24.03	75.00	d15cdr0zt3vtp	Oracle Enterprise Manager.Metric Engine	SELECT TO_CHAR(current_timesta...
17.02	43	0.40	17.88	22.73	20.59	74.87	9w2qykn1r44zd	JDBC Thin Client	select count(*) as CNT from de...
1.53	325	0.00	1.60	5.35	30.59	28.53	0a9y4ku4gwmt0	JDBC Thin Client	select count(*) as CNT from (s...
1.22	10,610	0.00	1.28	126.60	5.69	0.97	4vs91dcv7u1p6		insert into sys.aud$( sessioni...
0.87	496	0.00	0.91	6.16	9.12	14.08	d1ra7j6na0h1a	JDBC Thin Client	INSERT INTO DEAL_INFO (FLOW_IN...
0.27	10,599	0.00	0.29	89.57	5.56	0.30	f711myt0q6cma		insert into sys.aud$( sessioni...
0.18	23	0.01	0.19	5.07	92.95	3.50	6xj082k5dca3t	JDBC Thin Client	select count(*) as CNT from (s...
0.09	30	0.00	0.09	6.42	95.45	1.41	04qrcm4qcz690	JDBC Thin Client	select count(*) as CNT from (s...
0.02	36	0.00	0.02	9.32	23.28	0.17	0sck1avakd8up	JDBC Thin Client	select 1 from sys_file2 where ...
0.01	5	0.00	0.01	0.07	0.00	13.83	9czdtfuk44rks	JDBC Thin Client	select * from framedepartment ...

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: 62,352,253
Captured SQL account for 57.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
12,214,944	3	4,071,648.00	19.59	36.78	98.5	0	8vx0yn7u2n6xn	JDBC Thin Client	select FRAMNAME, USER_CODE fro...
4,305,699	37,815	113.86	6.91	12.05	93.6	0	6501mstynpg0v	JDBC Thin Client	SELECT FRAMNAME2 FROM V_RPT_FR...
3,952,680	26,961	146.61	6.34	9.50	105.9	0	c4f1v62z1pfgz	JDBC Thin Client	SELECT FRAMNAME3 FROM V_RPT_FR...
3,952,680	26,961	146.61	6.34	9.43	99.6	0	chr72bqg3x425	JDBC Thin Client	SELECT FRAMNAME5 FROM V_RPT_FR...
1,478,246	563	2,625.66	2.37	8.06	100.3	0	20fdfnf0rad6f	JDBC Thin Client	select item_seq from tree_def ...
1,113,468	1	1,113,468.00	1.79	37.91	24	75	d15cdr0zt3vtp	Oracle Enterprise Manager.Metric Engine	SELECT TO_CHAR(current_timesta...
1,076,040	402	2,676.72	1.73	6.60	100.9	0	5nhtksz627ru6	JDBC Thin Client	select item_seq from tree_def ...
801,554	43	18,640.79	1.29	22.73	20.6	74.9	9w2qykn1r44zd	JDBC Thin Client	select count(*) as CNT from de...
713,645	84	8,495.77	1.14	9.77	99.9	0	afxn34s636ba8	JDBC Thin Client	select C_FLOW_INID, C_FLOW_INI...
667,230	115	5,802.00	1.07	12.26	98.5	0	3a30ztcktkh6c		select max(sms_send_seq)as sms...
624,643	105	5,948.98	1.00	7.48	96.4	0	bkqkgwk70vnwp	JDBC Thin Client	select C_FLOW_INID, C_FLOW_INI...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 1,929,962
Captured SQL account for 98.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,111,758	1	1,111,758.00	57.61	37.91	24.03	75.00	d15cdr0zt3vtp	Oracle Enterprise Manager.Metric Engine	SELECT TO_CHAR(current_timesta...
785,054	43	18,257.07	40.68	22.73	20.59	74.87	9w2qykn1r44zd	JDBC Thin Client	select count(*) as CNT from de...
153	325	0.47	0.01	5.35	30.59	28.53	0a9y4ku4gwmt0	JDBC Thin Client	select count(*) as CNT from (s...
104	496	0.21	0.01	6.16	9.12	14.08	d1ra7j6na0h1a	JDBC Thin Client	INSERT INTO DEAL_INFO (FLOW_IN...
35	23	1.52	0.00	5.07	92.95	3.50	6xj082k5dca3t	JDBC Thin Client	select count(*) as CNT from (s...
9	30	0.30	0.00	6.42	95.45	1.41	04qrcm4qcz690	JDBC Thin Client	select count(*) as CNT from (s...
6	40	0.15	0.00	0.51	75.77	0.56	4cm2gyfvm41za	JDBC Thin Client	select * from (select record_c...
5	36	0.14	0.00	9.32	23.28	0.17	0sck1avakd8up	JDBC Thin Client	select 1 from sys_file2 where ...
3	38	0.08	0.00	6.51	95.41	0.14	1g4zgsm9xpd4m	JDBC Thin Client	select SIGN_PROJECTNAME, SIGN_...
3	105	0.03	0.00	7.48	96.36	0.03	bkqkgwk70vnwp	JDBC Thin Client	select C_FLOW_INID, C_FLOW_INI...

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: 29,426
Captured SQL account for 21.5% of Total
Total UnOptimized Read Requests: 29,426
Captured SQL account for 21.5% 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
3,916	3,916	43	91.07	13.31	9w2qykn1r44zd	JDBC Thin Client	select count(*) as CNT from de...
2,191	2,191	1	2,191.00	7.45	d15cdr0zt3vtp	Oracle Enterprise Manager.Metric Engine	SELECT TO_CHAR(current_timesta...
153	153	325	0.47	0.52	0a9y4ku4gwmt0	JDBC Thin Client	select count(*) as CNT from (s...
35	35	23	1.52	0.12	6xj082k5dca3t	JDBC Thin Client	select count(*) as CNT from (s...
28	28	4	7.00	0.10	9juw6s4yy5pzp	emagent_SQL_rac_database	/* OracleOEM */ SELECT SUM(bro...
9	9	30	0.30	0.03	04qrcm4qcz690	JDBC Thin Client	select count(*) as CNT from (s...
3	3	38	0.08	0.01	1g4zgsm9xpd4m	JDBC Thin Client	select SIGN_PROJECTNAME, SIGN_...
2	2	20	0.10	0.01	bccrrd3sz1p7t	JDBC Thin Client	select PACT_NAME, PACT_NAME fr...
1	1	84	0.01	0.00	afxn34s636ba8	JDBC Thin Client	select C_FLOW_INID, C_FLOW_INI...
1	1	21	0.05	0.00	ahxtwjz5p0g30	JDBC Thin Client	SELECT * FROM(SELECT TMP_TBL_A...

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: 411,236
Captured SQL account for 58.1% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
37,815	26,961	0.71	12.05	93.6	0	6501mstynpg0v	JDBC Thin Client	SELECT FRAMNAME2 FROM V_RPT_FR...
36,104	40,952	1.13	4.73	85.7	0	1dubnbpk10f80	JDBC Thin Client	select * from(select f2.fram_c...
26,961	26,961	1.00	9.50	105.9	0	c4f1v62z1pfgz	JDBC Thin Client	SELECT FRAMNAME3 FROM V_RPT_FR...
26,961	26,961	1.00	9.43	99.6	0	chr72bqg3x425	JDBC Thin Client	SELECT FRAMNAME5 FROM V_RPT_FR...
21,204	434,225	20.48	25.12	83	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
10,612	10,612	1.00	1.75	51.6	0	459f3z9u4fb3u		select value$ from props$ wher...
10,611	21,202	2.00	2.81	81.5	0	0k8522rmdzg4k		select privilege# from sysauth...
10,610	10,610	1.00	126.60	5.7	1	4vs91dcv7u1p6		insert into sys.aud$( sessioni...
10,609	10,609	1.00	3.16	46.9	0	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
10,603	10,607	1.00	0.90	64.1	0	5ur69atw3vfhj		select decode(failover_method,...
10,599	10,599	1.00	89.57	5.6	.3	f711myt0q6cma		insert into sys.aud$( sessioni...
7,882	276	0.04	1.04	112.7	0	c4d6d9kwzwkqt	JDBC Thin Client	select user_sign from usersign...
6,038	0	0.00	3.59	98.3	0	cb7zvbajzhbq7	JDBC Thin Client	select dept_code from framedep...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 135,250
Captured SQL account for 66.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
10,614	10,609	7.85	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
10,612	21,204	7.85	cm5vu20fhtnq1		select /*+ connect_by_filterin...
10,611	10,611	7.85	0k8522rmdzg4k		select privilege# from sysauth...
10,611	10,610	7.85	4vs91dcv7u1p6		insert into sys.aud$( sessioni...
10,592	10,599	7.83	f711myt0q6cma		insert into sys.aud$( sessioni...
10,587	10,612	7.83	459f3z9u4fb3u		select value$ from props$ wher...
10,585	10,603	7.83	5ur69atw3vfhj		select decode(failover_method,...
7,876	7,882	5.82	c4d6d9kwzwkqt	JDBC Thin Client	select user_sign from usersign...
446	2,825	0.33	c3m2v78k06wvy	JDBC Thin Client	SELECT NULL AS table_cat, c.ow...
391	391	0.29	169m46hd90w10	JDBC Thin Client	SELECT U_NAME FROM USERS WHERE...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
17,127,256	1	0.22	dqtu59yjn126m	JDBC Thin Client	select user_code from user_dep...
17,087,486	1	0.22	bp0pj777358k3	JDBC Thin Client	select FRAMNAME, FULL_NAME, US...
9,116,808	3	0.12	da7mkv3ngfq7a	JDBC Thin Client	select FRAMNAME, USER_CODE fro...
4,670,287	1	0.06	gknkvjn6rhx0a	JDBC Thin Client	select user_code from user_dep...
3,881,218	130	0.05	bdra985w3wh0b	JDBC Thin Client	select record_code, record_tit...
3,374,238	4	0.04	7wt7phk4xns75	emagent_SQL_rac_database	select a.capture_name streams_...
3,360,911	8	0.04	5fk0v8km2f811	perl.exe	select propagation_name, 'BUFF...
3,126,621	3	0.04	2jjupb5f06d56	JDBC Thin Client	select FULL_NAME, USER_CODE fr...
2,999,794	7	0.04	9w44d8wu6p1b7	JDBC Thin Client	select record_code, record_tit...
2,783,858	130	0.04	bdra985w3wh0b	JDBC Thin Client	select record_code, record_tit...
2,553,010	40	0.03	4cm2gyfvm41za	JDBC Thin Client	select * from (select record_c...
2,507,151	104	0.03	b8k52qq2a8z9d	JDBC Thin Client	select record_code, record_tit...
2,419,412	13	0.03	0y5hsh9q9ppra	JDBC Thin Client	select * from (select record_c...
2,168,344	1	0.03	gd6navngbca3a	JDBC Thin Client	select record_code, record_tit...
1,947,428	37	0.03	1bkx3ssq6ra7s	JDBC Thin Client	select record_code, record_tit...
1,935,518	1	0.03	a94uh0q35gtby	JDBC Thin Client	select record_code, record_tit...
1,851,359	496	0.02	d1ra7j6na0h1a	JDBC Thin Client	INSERT INTO DEAL_INFO (FLOW_IN...
1,762,005	3	0.02	bjn4vnyg20p7s	JDBC Thin Client	select count(record_code) from...
1,657,929	4	0.02	9juw6s4yy5pzp	emagent_SQL_rac_database	/* OracleOEM */ SELECT SUM(bro...
1,469,064	1	0.02	4d22aajhnssyu	JDBC Thin Client	select * from (select record_c...
1,355,439	104	0.02	b8k52qq2a8z9d	JDBC Thin Client	select record_code, record_tit...
1,345,153	4	0.02	9juw6s4yy5pzp	emagent_SQL_rac_database	/* OracleOEM */ SELECT SUM(bro...
1,229,978	19	0.02	5d6a214cx2gs2	JDBC Thin Client	select max(r.appr_right) as ap...
1,196,172	37	0.02	1bkx3ssq6ra7s	JDBC Thin Client	select record_code, record_tit...
1,168,047	104	0.02	b8k52qq2a8z9d	JDBC Thin Client	select record_code, record_tit...
1,156,825	1	0.02	5j172bxj700h5	JDBC Thin Client	select record_code, record_tit...
1,148,203	13	0.02	8ugs0u05kzhdc	JDBC Thin Client	select record_code, record_tit...
1,137,470	7	0.01	ahpsj2bwkvju4	JDBC Thin Client	select max(r.appr_right) as ap...

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
81	7	9w44d8wu6p1b7	JDBC Thin Client	select record_code, record_tit...
81	7	9w44d8wu6p1b7	JDBC Thin Client	select record_code, record_tit...
81	7	9w44d8wu6p1b7	JDBC Thin Client	select record_code, record_tit...
71	13	0y5hsh9q9ppra	JDBC Thin Client	select * from (select record_c...
71	13	0y5hsh9q9ppra	JDBC Thin Client	select * from (select record_c...
68	104	b8k52qq2a8z9d	JDBC Thin Client	select record_code, record_tit...
68	104	b8k52qq2a8z9d	JDBC Thin Client	select record_code, record_tit...
68	104	b8k52qq2a8z9d	JDBC Thin Client	select record_code, record_tit...
48	37	1bkx3ssq6ra7s	JDBC Thin Client	select record_code, record_tit...
48	37	1bkx3ssq6ra7s	JDBC Thin Client	select record_code, record_tit...
48	37	1bkx3ssq6ra7s	JDBC Thin Client	select record_code, record_tit...
47	3	bjn4vnyg20p7s	JDBC Thin Client	select count(record_code) from...
47	3	bjn4vnyg20p7s	JDBC Thin Client	select count(record_code) from...
47	3	bjn4vnyg20p7s	JDBC Thin Client	select count(record_code) from...
44	1	a94uh0q35gtby	JDBC Thin Client	select record_code, record_tit...
44	1	a94uh0q35gtby	JDBC Thin Client	select record_code, record_tit...
44	1	a94uh0q35gtby	JDBC Thin Client	select record_code, record_tit...
40	1	4d22aajhnssyu	JDBC Thin Client	select * from (select record_c...
40	1	4d22aajhnssyu	JDBC Thin Client	select * from (select record_c...
36	8	5fk0v8km2f811	perl.exe	select propagation_name, 'BUFF...
26	1	14k3tts5qwqsu	JDBC Thin Client	select record_code, record_tit...
26	1	14k3tts5qwqsu	JDBC Thin Client	select record_code, record_tit...
26	1	14k3tts5qwqsu	JDBC Thin Client	select record_code, record_tit...
25	3	2bb8n2s65zttk	JDBC Thin Client	select record_code, record_tit...
25	3	2bb8n2s65zttk	JDBC Thin Client	select record_code, record_tit...
24	1	5j172bxj700h5	JDBC Thin Client	select record_code, record_tit...
24	1	5j172bxj700h5	JDBC Thin Client	select record_code, record_tit...
24	496	d1ra7j6na0h1a	JDBC Thin Client	INSERT INTO DEAL_INFO (FLOW_IN...
23	40	4cm2gyfvm41za	JDBC Thin Client	select * from (select record_c...
22	1	gd6navngbca3a	JDBC Thin Client	select record_code, record_tit...
21	7	ahpsj2bwkvju4	JDBC Thin Client	select max(r.appr_right) as ap...
21	130	bdra985w3wh0b	JDBC Thin Client	select record_code, record_tit...
21	130	bdra985w3wh0b	JDBC Thin Client	select record_code, record_tit...
21	130	bdra985w3wh0b	JDBC Thin Client	select record_code, record_tit...

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): 235
Captured SQL account for 88.9% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
113.70	10,610	48.49	126.60	89.81	5.69	0.97	4vs91dcv7u1p6		insert into sys.aud$( sessioni...
83.23	10,599	35.49	89.57	92.92	5.56	0.30	f711myt0q6cma		insert into sys.aud$( sessioni...
4.79	496	2.04	6.16	77.78	9.12	14.08	d1ra7j6na0h1a	JDBC Thin Client	INSERT INTO DEAL_INFO (FLOW_IN...
2.86	36	1.22	9.32	30.73	23.28	0.17	0sck1avakd8up	JDBC Thin Client	select 1 from sys_file2 where ...
2.52	325	1.07	5.35	47.04	30.59	28.53	0a9y4ku4gwmt0	JDBC Thin Client	select count(*) as CNT from (s...
0.15	38	0.06	6.51	2.24	95.41	0.14	1g4zgsm9xpd4m	JDBC Thin Client	select SIGN_PROJECTNAME, SIGN_...
0.14	84	0.06	9.77	1.48	99.93	0.01	afxn34s636ba8	JDBC Thin Client	select C_FLOW_INID, C_FLOW_INI...
0.13	23	0.05	5.07	2.53	92.95	3.50	6xj082k5dca3t	JDBC Thin Client	select count(*) as CNT from (s...
0.12	40	0.05	0.51	23.96	75.77	0.56	4cm2gyfvm41za	JDBC Thin Client	select * from (select record_c...
0.11	30	0.05	6.42	1.74	95.45	1.41	04qrcm4qcz690	JDBC Thin Client	select count(*) as CNT from (s...
0.10	77	0.04	9.33	1.12	96.47	0.01	guh4ntbgbt1mc	JDBC Thin Client	select PACT_NAME, PACT_NAME fr...
0.08	43	0.03	22.73	0.34	20.59	74.87	9w2qykn1r44zd	JDBC Thin Client	select count(*) as CNT from de...
0.06	23	0.03	4.66	1.33	98.38	0.00	1rfb4y9054rxc	JDBC Thin Client	SELECT * FROM(SELECT TMP_TBL_A...
0.06	21	0.02	4.33	1.29	97.38	0.01	ahxtwjz5p0g30	JDBC Thin Client	SELECT * FROM(SELECT TMP_TBL_A...
0.05	105	0.02	7.48	0.67	96.36	0.03	bkqkgwk70vnwp	JDBC Thin Client	select C_FLOW_INID, C_FLOW_INI...
0.04	20	0.02	3.91	1.09	94.56	0.04	bccrrd3sz1p7t	JDBC Thin Client	select PACT_NAME, PACT_NAME fr...
0.04	130	0.02	3.98	1.03	100.03	0.00	bdra985w3wh0b	JDBC Thin Client	select record_code, record_tit...
0.04	12	0.02	4.16	0.95	98.20	0.00	d2gfcw9ut156m	JDBC Thin Client	select count(*) as CNT from (s...
0.04	53	0.02	6.50	0.58	97.03	0.00	16hmhrs8q5zxc	JDBC Thin Client	select C_FLOW_INID, C_FLOW_INI...
0.03	13	0.01	0.21	15.61	81.68	0.47	0y5hsh9q9ppra	JDBC Thin Client	select * from (select record_c...
0.03	8	0.01	3.23	0.95	97.49	0.00	fuv260cu4xtpp	JDBC Thin Client	SELECT * FROM(SELECT TMP_TBL_A...
0.02	5	0.01	0.07	29.86	0.00	13.83	9czdtfuk44rks	JDBC Thin Client	select * from framedepartment ...
0.01	37	0.00	0.26	4.23	82.42	0.00	1bkx3ssq6ra7s	JDBC Thin Client	select record_code, record_tit...
0.01	7	0.00	0.19	5.68	81.31	0.00	9w44d8wu6p1b7	JDBC Thin Client	select record_code, record_tit...
0.01	3	0.00	0.09	11.05	65.98	0.00	bjn4vnyg20p7s	JDBC Thin Client	select count(record_code) from...
0.01	1	0.00	6.77	0.14	52.09	0.00	a8j39qb13tqkr	emagent_SQL_oracle_database	SELECT :B1 TASK_ID, F.FINDING_...
0.01	2	0.00	0.02	24.65	71.34	0.00	f5um7r3gqsh8k	JDBC Thin Client	select * from (select record_c...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

04qrcm4qcz690 select count(*) as CNT from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6, :7) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2

0a9y4ku4gwmt0 select count(*) as CNT from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (CC.fini_flag=3 and CC.read_flag=0) and CC.deal_man=:1 group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and C.deal_man=:27 and A.if_efec<>2

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

0sck1avakd8up select 1 from sys_file2 where file_name=:1 and (flow_inid=:2 or ref_inid=:3)

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

0y5hsh9q9ppra select * from (select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1))) order by crt_date desc, record_code asc, record_pri asc) where rownum<=:10

14k3tts5qwqsu select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10, :11, :12, :13) and r.deny_right=1))) order by record_pri asc, crt_date desc

169m46hd90w10 SELECT U_NAME FROM USERS WHERE U_NAME = :1

16hmhrs8q5zxc select C_FLOW_INID, C_FLOW_INID from YW_HS_PAY

1bkx3ssq6ra7s select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7) and r.deny_right=1))) order by record_pri asc, crt_date desc

1dubnbpk10f80 select * from(select f2.fram_code, f2.fram_name, f2.para_seq, f2.fram_type, f2.ordr_no, '' as startdate, '' as enddate from framework f1, framework f2, position p where f1.para_seq=f2.fram_seq and f1.fram_seq=p.posi_seq and (f2.fram_type=0 or f2.fram_type=1) and p.empl_id=:1 and p.empl_id not in (select user_code from framehistory where user_code=:2 and to_date(start_date || ' 00:00:00', 'YYYY-MM-DD HH24:MI:SS')<:3 and to_date(end_date || ' 23:59:59', 'YYYY-MM-DD HH24:MI:SS')>:4) union all select '' as fram_code, fram_name, null as para_seq, 0 as fram_type, 9999 as ordr_no, start_date || ' 00:00:00' as startdate, end_date || ' 23:59:59' as enddate from framehistory where user_code=:5 and to_date(start_date || ' 00:00:00', 'YYYY-MM-DD HH24:MI:SS')<:6 and to_date(end_date || ' 23:59:59', 'YYYY-MM-DD HH24:MI:SS')>:7) tmpTab order by LENGTH(fram_code), NVL(to_number(para_seq), 0) asc, ordr_no asc, fram_type asc

1g4zgsm9xpd4m select SIGN_PROJECTNAME, SIGN_PROJECTNAME from YW_ZT_CONTRACT_APPR

1rfb4y9054rxc SELECT * FROM(SELECT TMP_TBL_A.*, rownum as LAYER_A_ROWNUM FROM( select A.flow_inid from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6, :7) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2 order by C.rece_date desc) TMP_TBL_A WHERE rownum <= 20 ) TMP_TBL_B WHERE LAYER_A_ROWNUM >= 1

20fdfnf0rad6f select item_seq from tree_def where item_type=2 and ( crt_user=:1 or ( exists( select 1 from right_def where right_def.item_seq=tree_def.item_seq and right_def.user_name IN (:2, :3, :4, :5, :6, :7, :8) having (min(op_acc) = 0 ))))

2bb8n2s65zttk select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15) and r.deny_right=1))) order by record_pri asc, crt_date desc

2jjupb5f06d56 select FULL_NAME, USER_CODE from V_FORM_ZJXMZ

3a30ztcktkh6c select max(sms_send_seq)as sms_send_seq_max from sms_tbl_sended

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

4cm2gyfvm41za select * from (select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1)) or ( (crt_user=:10 or ( exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:11 and r.view_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:12) and r.view_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:13, :14, :15, :16, :17, :18) and r.view_right=1)))) and not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:19 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:20) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:21, :22, :23, :24, :25, :26) and r.deny_right=1)))) order by crt_date desc, record_code asc, record_pri asc) where rownum<=:27

4d22aajhnssyu select * from (select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10) and r.deny_right=1))) order by crt_date desc, record_code asc, record_pri asc) where rownum<=:11

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

5d6a214cx2gs2 select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 1 and r.folder_code=t.folder_code and r.folder_code in(:1, :2) and r.user_code=:3 group by t.folder_code union all select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 2 and r.folder_code in(:4, :5) and r.folder_code=t.folder_code and r.user_code in (select grop_code from user_group where user_code=:6) group by t.folder_code union all select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 3 and r.user_code in (:7, :8, :9, :10, :11, :12) and r.folder_code=t.folder_code and r.folder_code in(:13, :14) group by t.folder_code

5fk0v8km2f811 select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance

5j172bxj700h5 select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6) and r.deny_right=1))) order by record_pri asc, crt_date desc

5nhtksz627ru6 select item_seq from tree_def where item_type=2 and ( crt_user=:1 or ( exists( select 1 from right_def where right_def.item_seq=tree_def.item_seq and right_def.user_name IN (:2, :3, :4, :5, :6, :7, :8, :9) having (min(op_acc) = 0 ))))

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

6501mstynpg0v SELECT FRAMNAME2 FROM V_RPT_FRAMEDEPARTMENT WHERE USER_CODE=:B1 AND ROWNUM=1

6xj082k5dca3t select count(*) as CNT from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2

7wt7phk4xns75 select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status

8ugs0u05kzhdc select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 and crt_date > TO_DATE(:2, 'YYYY-MM-DD')) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:3 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:4 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:5, :6, :7, :8, :9, :10) and r.deny_right=1))) order by crt_date desc, record_code asc, record_pri asc

8vx0yn7u2n6xn select FRAMNAME, USER_CODE from V_YW_USER_AREANAME

9czdtfuk44rks select * from framedepartment where fram_code like :1

9juw6s4yy5pzp /* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS )

9w2qykn1r44zd select count(*) as CNT from deal_info d left join step_inst si on d.step_inco=si.step_inco left join step_def sd on si.step_code=sd.step_code where si.send_flag=0 and d.flow_inid=:1 and (sd.step_tag=:2 or sd.step_name=:3)

9w44d8wu6p1b7 select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10, :11) and r.deny_right=1))) order by record_pri asc, crt_date desc

a8j39qb13tqkr SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(F_ALL.TASK_ID) FINDING_COUNT, F_CURR.FINDING_NAME FROM (SELECT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ) F_CURR, (SELECT T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ) TASKS, DBA_ADVISOR_FINDINGS F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME AND F_ALL.TYPE<>'INFORMATION' AND F_ALL.TYPE<>'WARNING' AND F_ALL.PARENT=0 GROUP BY F_CURR.FINDING_NAME) HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID

a94uh0q35gtby select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10) and r.deny_right=1))) order by record_pri asc, crt_date desc

afxn34s636ba8 select C_FLOW_INID, C_FLOW_INID from YW_ZT_CONTRACT_APPR

ahpsj2bwkvju4 select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 1 and r.folder_code=t.folder_code and r.folder_code in(:1, :2, :3) and r.user_code=:4 group by t.folder_code union all select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 2 and r.folder_code in(:5, :6, :7) and r.folder_code=t.folder_code and r.user_code in (select grop_code from user_group where user_code=:8) group by t.folder_code union all select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 3 and r.user_code in (:9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20) and r.folder_code=t.folder_code and r.folder_code in(:21, :22, :23) group by t.folder_code

ahxtwjz5p0g30 SELECT * FROM(SELECT TMP_TBL_A.*, rownum as LAYER_A_ROWNUM FROM( select A.flow_inid from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2 order by C.rece_date desc) TMP_TBL_A WHERE rownum <= 20 ) TMP_TBL_B WHERE LAYER_A_ROWNUM >= 1

b8k52qq2a8z9d select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8) and r.deny_right=1))) order by record_pri asc, crt_date desc

bccrrd3sz1p7t select PACT_NAME, PACT_NAME from YW_HS_PAY

bdra985w3wh0b select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1))) order by record_pri asc, crt_date desc

bjn4vnyg20p7s select count(record_code) from pu_record where (record_status=1 and ( folder_code =:1)) and (( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1))))

bkqkgwk70vnwp select C_FLOW_INID, C_FLOW_INID from YW_HS_PAY_1

bp0pj777358k3 select FRAMNAME, FULL_NAME, USER_CODE from V_CENTER_LEADERASDIFO_ZJ where USER_CODE is not null

c3m2v78k06wvy SELECT NULL AS table_cat, c.owner AS table_schem, c.table_name, c.column_name, c.position AS key_seq, c.constraint_name AS pk_name FROM all_cons_columns c, all_constraints k WHERE k.constraint_type = 'P' AND k.table_name = :1 AND k.owner like :2 escape '/' AND k.constraint_name = c.constraint_name AND k.table_name = c.table_name AND k.owner = c.owner ORDER BY column_name

c4d6d9kwzwkqt select user_sign from usersign where user_code=:1

c4f1v62z1pfgz SELECT FRAMNAME3 FROM V_RPT_FRAMEDEPARTMENT WHERE USER_CODE=:B1 AND ROWNUM=1

cb7zvbajzhbq7 select dept_code from framedepartment where fram_code in (select max(f.fram_code) from pt_style_config a, user_dept d, framedepartment f, framedepartment fd where a.sys_id=:1 and a.user_code=f.dept_code and d.user_code=:2 and d.fram_seq = fd.dept_code and fd.fram_code like f.fram_code||'%')

chr72bqg3x425 SELECT FRAMNAME5 FROM V_RPT_FRAMEDEPARTMENT WHERE USER_CODE=:B1 AND ROWNUM=1

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

d15cdr0zt3vtp SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, COUNT(username) AS failed_count FROM sys.dba_audit_session WHERE returncode != 0 AND TO_CHAR(timestamp, 'YYYY-MM-DD HH24:MI:SS') >= TO_CHAR(current_timestamp - TO_DSINTERVAL('0 0:30:00'), 'YYYY-MM-DD HH24:MI:SS')

d1ra7j6na0h1a INSERT INTO DEAL_INFO (FLOW_INID, STEP_INCO, DEAL_INDX, PERI_MAN, STEP_MAN, DEAL_MAN, FULL_NAME, AGEN_MEN, DEAL_EFFE, STEP_CHOI, CHOI_CONT, NEXT_EFFE, NEXT_MAN, CURR_MAN, STEP_TYPE, RECE_DATE, FINI_DATE, FINI_FLAG, READ_FLAG, SAVE_DATE, DEAL_SIGN, DEL_FLAG, NOTE_MAN, URGE_INFO, DEAL_NOTE, URGE_DATE, REMIND_TYPE, TIME_SET, URGE_TIMES, URGE_SET, URGE_FINI_FLAG, REGI_FLAG, FSUB_INID, FW_MAN, FSUB_FLAG, STEP_INDEX, BACK_FLAG, OPEN_DATE, SELF_SCORE, OTHER_SCORE, OPEN_TERM, DEAL_TERM, PRE_DEAL_IDX, SUB_DEAL_CNT, APPEND_PATH, HAS_SYNC, ALLOGRAPH, ARCH_FLAG, CA_SIGN_STATE, FORM_SIGN_VERIFY_DATA, ALLOGRAPH_DATE, DEAL_COMM, AGEN_FLAG, FLOW_ID, STEP_CODE, DREDGE_REASON, DREDGE_MAN, DREDGE_DATE, URGE_COUNT) 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)

d2gfcw9ut156m select count(*) as CNT from (select max(CC.step_index) as max_step_index from deal_info CC, flow_inst AA where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and AA.fins_name like :1 and CC.deal_man in (:2, :3, :4, :5, :6, :7, :8) and AA.flow_inid=CC.flow_inid group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2

da7mkv3ngfq7a select FRAMNAME, USER_CODE from V_CENTER_LEADERASDIFO_ZJ

dqtu59yjn126m select user_code from user_dept where fram_code in(: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, :207, :208, :209, :210, :211, :212, :213, :214, :215, :216, :217, :218, :219, :220, :221, :222, :223, :224, :225, :226, :227, :228, :229, :230, :231, :232, :233, :234, :235, :236, :237, :238, :239, :240, :241, :242, :243, :244, :245, :246, :247, :248, :249, :250, :251, :252, :253, :254, :255, :256, :257, :258, :259, :260, :261, :262, :263, :264, :265, :266, :267, :268, :269, :270, :271, :272, :273, :274, :275, :276, :277, :278, :279, :280, :281, :282, :283, :284, :285, :286, :287, :288, :289, :290, :291, :292, :293, :294, :295, :296, :297, :298, :299, :300, :301, :302, :303, :304, :305, :306, :307, :308, :309, :310, :311, :312, :313, :314, :315, :316, :317, :318, :319, :320, :321, :322, :323, :324, :325, :326, :327, :328, :329, :330, :331, :332, :333, :334, :335, :336, :337, :338, :339, :340, :341, :342, :343, :344, :345, :346, :347, :348, :349, :350, :351, :352, :353, :354, :355, :356, :357, :358, :359, :360, :361, :362, :363, :364, :365, :366, :367, :368, :369, :370, :371, :372, :373, :374, :375, :376, :377, :378, :379, :380, :381, :382, :383, :384, :385, :386, :387, :388, :389, :390, :391, :392, :393, :394, :395, :396, :397, :398, :399, :400, :401, :402, :403, :404, :405, :406, :407, :408, :409, :410, :411, :412, :413, :414, :415, :416, :417, :418, :419, :420, :421, :422, :423, :424, :425, :426, :427, :428, :429, :430, :431, :432, :433, :434, :435, :436, :437, :438, :439, :440, :441, :442, :443, :444, :445, :446, :447, :448, :449, :450, :451, :452, :453, :454, :455, :456, :457, :458, :459, :460, :461, :462, :463, :464, :465, :466, :467, :468, :469, :470, :471, :472, :473, :474, :475, :476, :477, :478, :479, :480, :481, :482, :483, :484, :485, :486, :487, :488, :489, :490, :491, :492, :493, :494, :495, :496, :497, :498, :499, :500) or fram_code in(:501, :502, :503, :504, :505, :506, :507, :508, :509, :510, :511, :512, :513, :514, :515, :516, :517, :518, :519, :520, :521, :522, :523, :524, :525, :526, :527, :528, :529, :530, :531, :532, :533, :534, :535, :536, :537, :538, :539, :540, :541, :542, :543, :544, :545, :546, :547, :548, :549, :550, :551, :552, :553, :554, :555, :556, :557, :558, :559, :560, :561, :562, :563, :564, :565, :566, :567, :568, :569, :570, :571, :572, :573, :574, :575, :576, :577, :578, :579, :580, :581, :582, :583, :584, :585, :586, :587, :588, :589, :590, :591, :592, :593, :594, :595, :596, :597, :598, :599, :600, :601, :602, :603, :604, :605, :606, :607, :608, :609, :610, :611, :612, :613, :614, :615, :616, :617, :618, :619, :620, :621, :622, :623, :624, :625, :626, :627, :628, :629, :630, :631, :632, :633, :634, :635, :636, :637, :638, :639, :640, :641, :642, :643, :644, :645, :646, :647, :648, :649, :650, :651, :652, :653, :654, :655, :656, :657, :658, :659, :660, :661, :662, :663, :664, :665, :666, :667, :668, :669, :670, :671, :672, :673, :67 4, :675, :676, :677, :678, :679, :680, :681, :682, :683, :684, :685, :686, :687, :688, :689, :690, :691, :692, :693, :694, :695, :696, :697, :698, :699, :700, :701, :702, :703, :704, :705, :706, :707, :708, :709, :710, :711, :712, :713, :714, :715, :716, :717, :718, :719, :720, :721, :722, :723, :724, :725, :726, :727, :728, :729, :730, :731, :732, :733, :734, :735, :736, :737, :738, :739, :740, :741, :742, :743, :744, :745, :746, :747, :748, :749, :750, :751, :752, :753, :754, :755, :756, :757, :758, :759, :760, :761, :762, :763, :764, :765, :766, :767, :768, :769, :770, :771, :772, :773, :774, :775, :776, :777, :778, :779, :780, :781, :782, :783, :784, :785, :786, :787, :788, :789, :790, :791, :792, :793, :794, :795, :796, :797, :798, :799, :800, :801, :802, :803, :804, :805, :806, :807, :808, :809, :810, :811, :812, :813, :814, :815, :816, :817, :818, :819, :820, :821, :822, :823, :824, :825, :826, :827, :828, :829, :830, :831, :832, :833, :834, :835, :836, :837, :838, :839, :840, :841, :842, :843, :844, :845, :846, :847, :848, :849, :850, :851, :852, :853, :854, :855, :856, :857, :858, :859, :860, :861, :862, :863, :864, :865, :866, :867, :868, :869, :870, :871, :872, :873, :874, :875, :876, :877, :878, :879, :880, :881, :882, :883, :884, :885, :886, :887, :888, :889, :890, :891, :892, :893, :894, :895, :896, :897, :898, :899, :900, :901, :902, :903, :904, :905, :906, :907, :908, :909, :910, :911, :912, :913, :914, :915, :916, :917, :918, :919, :920, :921, :922, :923, :924, :925, :926, :927, :928, :929, :930, :931, :932, :933, :934, :935, :936, :937, :938, :939, :940, :941, :942, :943, :944, :945, :946, :947, :948, :949, :950, :951, :952, :953, :954, :955, :956, :957, :958, :959, :960, :961, :962, :963, :964, :965, :966, :967, :968, :969, :970, :971, :972, :973, :974, :975, :976, :977, :978, :979, :980, :981, :982, :983, :984, :985, :986, :987, :988, :989, :990, :991, :992, :993, :994, :995, :996, :997, :998, :999, :1000) or fram_code in(:1001, :1002, :1003, :1004, :1005, :1006, :1007, :1008, :1009, :1010, :1011, :1012, :1013, :1014, :1015, :1016, :1017, :1018, :1019, :1020, :1021, :1022, :1023, :1024, :1025, :1026, :1027, :1028, :1029, :1030, :1031, :1032, :1033, :1034, :1035, :1036, :1037, :1038, :1039, :1040, :1041, :1042, :1043, :1044, :1045, :1046, :1047, :1048, :1049, :1050, :1051, :1052, :1053, :1054, :1055, :1056, :1057, :1058, :1059, :1060, :1061, :1062, :1063, :1064, :1065, :1066, :1067, :1068, :1069, :1070, :1071, :1072, :1073, :1074, :1075, :1076, :1077, :1078, :1079, :1080, :1081, :1082, :1083, :1084, :1085, :1086, :1087, :1088, :1089, :1090, :1091, :1092, :1093, :1094, :1095, :1096, :1097, :1098, :1099, :1100, :1101, :1102, :1103, :1104, :1105, :1106, :1107, :1108, :1109, :1110, :1111, :1112, :1113, :1114, :1115, :1116, :1117, :1118, :1119, :1120, :1121, :1122, :1123, :1124, :1125, :1126, :1127, :1128, :1129, :1130, :1131, :1132, :1133, :1134, :1135, :1136, :1137, :1138, :1139, :1140, :1141, :1142, :1143, :1144, :1145, :1146, :1147, :1148, :1149, :1150, :1151, :1152, :1153, :1154, :1155, :1156, :1157, :1158, :1159, :1160, :1161, :1162, :1163, :1164, :1165, :1166, :1167, :1168, :1169, :1170, :1171, :1172, :1173, :1174, :1175, :1176, :1177, :1178, :1179, :1180, :1181, :1182, :1183, :1184, :1185, :1186, :1187, :1188, :1189, :1190, :1191, :1192, :1193, :1194, :1195, :1196, :1197, :1198, :1199, :1200, :1201, :1202, :1203, :1204, :1205, :1206, :1207, :1208, :1209, :1210, :1211, :1212, :1213, :1214, :1215, :1216, :1217, :1218, :1219, :1220, :1221, :1222, :1223, :1224, :1225, :1226, :1227, :1228, :1229, :1230, :1231, :1232, :1233, :1234, :1235, :1236, :1237, :1238, :1239, :1240, :1241, :1242, :1243, :1244, :1245, :1246, :1247, :1248, :1249, :1250, :1251, :1252, :1253, :1254, :1255, :1256, :1257, :1258, :1259, :1260, :1261, :1262, :1263, :1264, :1265, :1266, :1267, :1268, :1269, :1270, :1271, :1272, :1273, :1274, :1275, :1276, :1277, :1278, :1279, :1280, :1281, :1282, :1283, :1284, :1285, :1286, :1287, :1288, :1289, : 1290, :1291, :1292, :1293, :1294, :1295, :1296, :1297, :1298, :1299, :1300, :1301, :1302, :1303, :1304, :1305, :1306, :1307, :1308, :1309, :1310, :1311, :1312, :1313, :1314, :1315, :1316, :1317, :1318, :1319, :1320, :1321, :1322, :1323, :1324, :1325, :1326, :1327, :1328, :1329, :1330, :1331, :1332, :1333, :1334, :1335, :1336, :1337, :1338, :1339, :1340, :1341, :1342, :1343, :1344, :1345, :1346, :1347, :1348, :1349, :1350, :1351, :1352, :1353, :1354, :1355, :1356, :1357, :1358, :1359, :1360, :1361, :1362, :1363, :1364, :1365, :1366, :1367, :1368, :1369, :1370, :1371, :1372, :1373, :1374, :1375, :1376, :1377, :1378, :1379, :1380, :1381, :1382, :1383, :1384, :1385, :1386, :1387, :1388, :1389, :1390, :1391, :1392, :1393, :1394, :1395, :1396, :1397, :1398, :1399, :1400, :1401, :1402, :1403, :1404, :1405, :1406, :1407, :1408, :1409, :1410, :1411, :1412, :1413, :1414, :1415, :1416, :1417, :1418, :1419, :1420, :1421, :1422, :1423, :1424, :1425, :1426, :1427, :1428, :1429, :1430, :1431, :1432, :1433, :1434, :1435, :1436, :1437, :1438, :1439, :1440, :1441, :1442, :1443, :1444, :1445, :1446, :1447, :1448, :1449, :1450, :1451, :1452, :1453, :1454, :1455, :1456, :1457, :1458, :1459, :1460, :1461, :1462, :1463, :1464, :1465, :1466, :1467, :1468, :1469, :1470, :1471, :1472, :1473, :1474, :1475, :1476, :1477, :1478, :1479, :1480, :1481, :1482, :1483, :1484, :1485, :1486, :1487, :1488, :1489, :1490, :1491, :1492, :1493, :1494, :1495, :1496, :1497, :1498, :1499, :1500) or fram_code in(:1501, :1502, :1503, :1504, :1505, :1506, :1507, :1508, :1509, :1510, :1511, :1512, :1513, :1514, :1515, :1516, :1517, :1518, :1519, :1520, :1521, :1522, :1523, :1524, :1525, :1526, :1527, :1528, :1529, :1530, :1531, :1532, :1533, :1534, :1535, :1536, :1537, :1538, :1539, :1540, :1541, :1542, :1543, :1544, :1545, :1546, :1547, :1548, :1549, :1550, :1551, :1552, :1553, :1554, :1555, :1556, :1557, :1558, :1559, :1560, :1561, :1562, :1563, :1564, :1565, :1566, :1567, :1568, :1569, :1570, :1571, :1572, :1573, :1574, :1575, :1576, :1577, :1578, :1579, :1580, :1581, :1582, :1583, :1584, :1585, :1586, :1587, :1588, :1589, :1590, :1591, :1592, :1593, :1594, :1595, :1596, :1597, :1598, :1599, :1600, :1601, :1602, :1603, :1604, :1605, :1606, :1607, :1608, :1609, :1610, :1611, :1612, :1613, :1614, :1615, :1616, :1617, :1618, :1619, :1620, :1621, :1622, :1623, :1624, :1625, :1626, :1627, :1628, :1629, :1630, :1631, :1632, :1633, :1634, :1635, :1636, :1637, :1638, :1639, :1640, :1641, :1642, :1643, :1644, :1645, :1646)

f5um7r3gqsh8k select * from (select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10, :11, :12) and r.deny_right=1))) order by record_pri asc, crt_date desc) where rownum<=:13

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

fuv260cu4xtpp SELECT * FROM(SELECT TMP_TBL_A.*, rownum as LAYER_A_ROWNUM FROM( select A.flow_inid from (select max(CC.step_index) as max_step_index from deal_info CC, flow_inst AA where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and AA.fins_name like :1 and CC.deal_man in (:2, :3, :4, :5, :6, :7, :8) and AA.flow_inid=CC.flow_inid group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2 order by C.rece_date desc) TMP_TBL_A WHERE rownum <= 20 ) TMP_TBL_B WHERE LAYER_A_ROWNUM >= 1

gd6navngbca3a select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1)) or ( (crt_user=:10 or ( exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:11 and r.view_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:12) and r.view_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:13, :14, :15, :16, :17, :18) and r.view_right=1)))) and not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:19 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:20) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:21, :22, :23, :24, :25, :26) and r.deny_right=1)))) order by crt_date desc, record_code asc, record_pri asc

gknkvjn6rhx0a select user_code from user_dept where fram_code in(: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, :207, :208, :209, :210, :211, :212, :213, :214, :215, :216, :217, :218, :219, :220, :221, :222, :223, :224, :225, :226, :227, :228, :229, :230, :231, :232, :233, :234, :235, :236, :237, :238, :239, :240, :241, :242, :243, :244, :245, :246, :247, :248, :249, :250, :251, :252, :253, :254, :255, :256, :257, :258, :259, :260, :261, :262, :263, :264, :265, :266, :267, :268, :269, :270, :271, :272, :273, :274, :275, :276, :277, :278, :279, :280, :281, :282, :283, :284, :285, :286, :287, :288, :289, :290, :291, :292, :293, :294, :295, :296, :297, :298, :299, :300, :301, :302, :303, :304, :305, :306, :307, :308, :309, :310, :311, :312, :313, :314, :315, :316, :317, :318, :319, :320, :321, :322, :323, :324, :325, :326, :327, :328, :329, :330, :331, :332, :333, :334, :335, :336, :337, :338, :339, :340, :341, :342, :343, :344, :345, :346, :347, :348, :349, :350, :351, :352, :353, :354, :355, :356, :357, :358, :359, :360, :361, :362, :363, :364, :365, :366, :367, :368, :369, :370, :371, :372, :373, :374, :375, :376, :377, :378, :379, :380, :381, :382, :383, :384, :385, :386, :387, :388, :389, :390, :391, :392, :393, :394, :395, :396, :397, :398, :399, :400, :401, :402, :403, :404, :405, :406, :407, :408, :409, :410, :411, :412, :413, :414, :415, :416, :417, :418, :419, :420, :421, :422, :423, :424, :425, :426, :427, :428, :429, :430, :431, :432, :433, :434, :435, :436, :437, :438, :439, :440, :441, :442, :443, :444, :445, :446, :447, :448, :449, :450, :451, :452, :453, :454, :455, :456, :457, :458, :459, :460, :461, :462, :463, :464, :465, :466, :467, :468, :469, :470, :471, :472, :473, :474, :475, :476, :477, :478, :479, :480, :481, :482, :483, :484, :485, :486, :487, :488, :489, :490, :491, :492, :493, :494, :495, :496, :497, :498, :499, :500) or fram_code in(:501, :502, :503, :504, :505, :506, :507, :508, :509, :510, :511, :512, :513, :514, :515, :516, :517, :518, :519, :520, :521, :522, :523, :524, :525, :526, :527, :528, :529, :530, :531, :532, :533, :534, :535, :536, :537, :538, :539, :540, :541, :542, :543, :544, :545, :546, :547, :548, :549, :550, :551, :552, :553, :554, :555, :556, :557, :558, :559, :560, :561, :562, :563, :564, :565, :566, :567, :568, :569, :570, :571, :572, :573, :574, :575, :576, :577, :578, :579, :580, :581, :582, :583, :584, :585, :586, :587, :588, :589, :590, :591, :592, :593, :594, :595, :596, :597, :598, :599, :600, :601, :602, :603, :604, :605, :606, :607, :608, :609, :610, :611, :612, :613, :614, :615, :616, :617, :618, :619, :620, :621, :622, :623, :624, :625, :626, :627, :628, :629, :630, :631, :632, :633, :634, :635, :636, :637, :638, :639, :640, :641, :642, :643, :644, :645, :646, :647, :648, :649, :650, :651, :652, :653, :654, :655, :656, :657, :658, :659, :660, :661, :662, :663, :664, :665, :666, :667, :668, :669, :670, :671, :672, :673, :67 4, :675, :676, :677, :678, :679, :680, :681, :682, :683, :684, :685, :686, :687, :688, :689, :690, :691, :692, :693, :694, :695, :696, :697, :698, :699, :700, :701, :702, :703, :704, :705, :706, :707, :708, :709, :710, :711, :712, :713, :714, :715, :716, :717, :718, :719, :720, :721, :722, :723, :724, :725, :726, :727, :728, :729, :730, :731, :732, :733, :734, :735, :736, :737, :738, :739, :740, :741, :742, :743, :744, :745, :746, :747, :748, :749, :750, :751, :752, :753, :754, :755, :756, :757, :758, :759, :760, :761, :762, :763, :764, :765, :766, :767, :768, :769, :770, :771, :772, :773, :774, :775, :776, :777, :778, :779, :780, :781, :782, :783, :784, :785, :786, :787, :788, :789, :790, :791, :792, :793, :794, :795, :796, :797, :798, :799, :800, :801, :802, :803, :804, :805, :806, :807, :808, :809, :810, :811, :812, :813, :814, :815, :816, :817, :818, :819, :820, :821, :822, :823, :824, :825, :826, :827, :828, :829, :830, :831, :832, :833, :834, :835, :836, :837, :838, :839, :840, :841, :842, :843, :844, :845, :846, :847, :848, :849, :850, :851, :852, :853, :854, :855, :856, :857, :858, :859, :860, :861, :862, :863, :864, :865, :866, :867, :868, :869, :870, :871, :872, :873, :874, :875, :876, :877, :878, :879, :880, :881, :882, :883, :884, :885, :886, :887, :888, :889, :890, :891, :892, :893, :894, :895, :896, :897, :898, :899, :900, :901, :902, :903, :904, :905, :906, :907, :908, :909, :910, :911, :912, :913, :914, :915, :916, :917, :918, :919, :920, :921, :922, :923, :924, :925, :926, :927, :928, :929, :930, :931, :932, :933, :934, :935, :936, :937, :938, :939, :940, :941, :942, :943, :944, :945, :946, :947, :948, :949, :950, :951, :952, :953, :954, :955, :956, :957, :958, :959, :960, :961, :962, :963, :964, :965, :966, :967, :968, :969, :970, :971, :972, :973, :974, :975, :976, :977, :978, :979, :980, :981, :982, :983, :984, :985, :986, :987, :988, :989, :990, :991, :992, :993, :994, :995, :996, :997, :998, :999, :1000) or fram_code in(:1001, :1002, :1003, :1004, :1005, :1006, :1007, :1008, :1009, :1010, :1011, :1012, :1013, :1014, :1015, :1016, :1017, :1018, :1019, :1020, :1021, :1022, :1023, :1024, :1025, :1026, :1027, :1028, :1029, :1030, :1031, :1032, :1033, :1034, :1035, :1036, :1037, :1038, :1039, :1040, :1041, :1042, :1043, :1044, :1045, :1046, :1047, :1048, :1049, :1050, :1051, :1052, :1053, :1054, :1055, :1056, :1057, :1058, :1059, :1060, :1061, :1062, :1063, :1064, :1065, :1066, :1067, :1068, :1069, :1070, :1071, :1072, :1073, :1074, :1075, :1076, :1077, :1078, :1079, :1080, :1081, :1082, :1083, :1084, :1085, :1086, :1087, :1088, :1089, :1090, :1091, :1092, :1093, :1094, :1095, :1096, :1097, :1098, :1099, :1100, :1101, :1102, :1103, :1104, :1105, :1106, :1107, :1108, :1109, :1110, :1111, :1112, :1113, :1114, :1115, :1116, :1117, :1118, :1119, :1120, :1121, :1122, :1123, :1124, :1125, :1126, :1127, :1128, :1129, :1130, :1131, :1132, :1133, :1134, :1135, :1136, :1137, :1138, :1139, :1140, :1141, :1142, :1143, :1144, :1145, :1146, :1147, :1148, :1149, :1150, :1151, :1152, :1153, :1154, :1155, :1156, :1157, :1158, :1159, :1160, :1161, :1162, :1163, :1164, :1165, :1166, :1167, :1168, :1169, :1170, :1171, :1172, :1173, :1174, :1175, :1176, :1177, :1178, :1179, :1180, :1181, :1182)

guh4ntbgbt1mc select PACT_NAME, PACT_NAME from YW_HS_PAY_1

SQL Id	SQL Text
04qrcm4qcz690	select count(*) as CNT from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6, :7) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2
0a9y4ku4gwmt0	select count(*) as CNT from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (CC.fini_flag=3 and CC.read_flag=0) and CC.deal_man=:1 group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and C.deal_man=:27 and A.if_efec<>2
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0sck1avakd8up	select 1 from sys_file2 where file_name=:1 and (flow_inid=:2 or ref_inid=:3)
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0y5hsh9q9ppra	select * from (select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1))) order by crt_date desc, record_code asc, record_pri asc) where rownum<=:10
14k3tts5qwqsu	select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10, :11, :12, :13) and r.deny_right=1))) order by record_pri asc, crt_date desc
169m46hd90w10	SELECT U_NAME FROM USERS WHERE U_NAME = :1
16hmhrs8q5zxc	select C_FLOW_INID, C_FLOW_INID from YW_HS_PAY
1bkx3ssq6ra7s	select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7) and r.deny_right=1))) order by record_pri asc, crt_date desc
1dubnbpk10f80	select * from(select f2.fram_code, f2.fram_name, f2.para_seq, f2.fram_type, f2.ordr_no, '' as startdate, '' as enddate from framework f1, framework f2, position p where f1.para_seq=f2.fram_seq and f1.fram_seq=p.posi_seq and (f2.fram_type=0 or f2.fram_type=1) and p.empl_id=:1 and p.empl_id not in (select user_code from framehistory where user_code=:2 and to_date(start_date \|\| ' 00:00:00', 'YYYY-MM-DD HH24:MI:SS')<:3 and to_date(end_date \|\| ' 23:59:59', 'YYYY-MM-DD HH24:MI:SS')>:4) union all select '' as fram_code, fram_name, null as para_seq, 0 as fram_type, 9999 as ordr_no, start_date \|\| ' 00:00:00' as startdate, end_date \|\| ' 23:59:59' as enddate from framehistory where user_code=:5 and to_date(start_date \|\| ' 00:00:00', 'YYYY-MM-DD HH24:MI:SS')<:6 and to_date(end_date \|\| ' 23:59:59', 'YYYY-MM-DD HH24:MI:SS')>:7) tmpTab order by LENGTH(fram_code), NVL(to_number(para_seq), 0) asc, ordr_no asc, fram_type asc
1g4zgsm9xpd4m	select SIGN_PROJECTNAME, SIGN_PROJECTNAME from YW_ZT_CONTRACT_APPR
1rfb4y9054rxc	SELECT * FROM(SELECT TMP_TBL_A.*, rownum as LAYER_A_ROWNUM FROM( select A.flow_inid from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6, :7) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2 order by C.rece_date desc) TMP_TBL_A WHERE rownum <= 20 ) TMP_TBL_B WHERE LAYER_A_ROWNUM >= 1
20fdfnf0rad6f	select item_seq from tree_def where item_type=2 and ( crt_user=:1 or ( exists( select 1 from right_def where right_def.item_seq=tree_def.item_seq and right_def.user_name IN (:2, :3, :4, :5, :6, :7, :8) having (min(op_acc) = 0 ))))
2bb8n2s65zttk	select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15) and r.deny_right=1))) order by record_pri asc, crt_date desc
2jjupb5f06d56	select FULL_NAME, USER_CODE from V_FORM_ZJXMZ
3a30ztcktkh6c	select max(sms_send_seq)as sms_send_seq_max from sms_tbl_sended
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4cm2gyfvm41za	select * from (select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1)) or ( (crt_user=:10 or ( exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:11 and r.view_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:12) and r.view_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:13, :14, :15, :16, :17, :18) and r.view_right=1)))) and not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:19 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:20) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:21, :22, :23, :24, :25, :26) and r.deny_right=1)))) order by crt_date desc, record_code asc, record_pri asc) where rownum<=:27
4d22aajhnssyu	select * from (select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10) and r.deny_right=1))) order by crt_date desc, record_code asc, record_pri asc) where rownum<=:11
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
5d6a214cx2gs2	select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 1 and r.folder_code=t.folder_code and r.folder_code in(:1, :2) and r.user_code=:3 group by t.folder_code union all select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 2 and r.folder_code in(:4, :5) and r.folder_code=t.folder_code and r.user_code in (select grop_code from user_group where user_code=:6) group by t.folder_code union all select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 3 and r.user_code in (:7, :8, :9, :10, :11, :12) and r.folder_code=t.folder_code and r.folder_code in(:13, :14) group by t.folder_code
5fk0v8km2f811	select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance
5j172bxj700h5	select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6) and r.deny_right=1))) order by record_pri asc, crt_date desc
5nhtksz627ru6	select item_seq from tree_def where item_type=2 and ( crt_user=:1 or ( exists( select 1 from right_def where right_def.item_seq=tree_def.item_seq and right_def.user_name IN (:2, :3, :4, :5, :6, :7, :8, :9) having (min(op_acc) = 0 ))))
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6501mstynpg0v	SELECT FRAMNAME2 FROM V_RPT_FRAMEDEPARTMENT WHERE USER_CODE=:B1 AND ROWNUM=1
6xj082k5dca3t	select count(*) as CNT from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2
7wt7phk4xns75	select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status
8ugs0u05kzhdc	select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 and crt_date > TO_DATE(:2, 'YYYY-MM-DD')) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:3 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:4 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:5, :6, :7, :8, :9, :10) and r.deny_right=1))) order by crt_date desc, record_code asc, record_pri asc
8vx0yn7u2n6xn	select FRAMNAME, USER_CODE from V_YW_USER_AREANAME
9czdtfuk44rks	select * from framedepartment where fram_code like :1
9juw6s4yy5pzp	/* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS )
9w2qykn1r44zd	select count(*) as CNT from deal_info d left join step_inst si on d.step_inco=si.step_inco left join step_def sd on si.step_code=sd.step_code where si.send_flag=0 and d.flow_inid=:1 and (sd.step_tag=:2 or sd.step_name=:3)
9w44d8wu6p1b7	select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10, :11) and r.deny_right=1))) order by record_pri asc, crt_date desc
a8j39qb13tqkr	SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(F_ALL.TASK_ID) FINDING_COUNT, F_CURR.FINDING_NAME FROM (SELECT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ) F_CURR, (SELECT T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ) TASKS, DBA_ADVISOR_FINDINGS F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME AND F_ALL.TYPE<>'INFORMATION' AND F_ALL.TYPE<>'WARNING' AND F_ALL.PARENT=0 GROUP BY F_CURR.FINDING_NAME) HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID
a94uh0q35gtby	select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10) and r.deny_right=1))) order by record_pri asc, crt_date desc
afxn34s636ba8	select C_FLOW_INID, C_FLOW_INID from YW_ZT_CONTRACT_APPR
ahpsj2bwkvju4	select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 1 and r.folder_code=t.folder_code and r.folder_code in(:1, :2, :3) and r.user_code=:4 group by t.folder_code union all select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 2 and r.folder_code in(:5, :6, :7) and r.folder_code=t.folder_code and r.user_code in (select grop_code from user_group where user_code=:8) group by t.folder_code union all select max(r.appr_right) as appr_right, max(r.view_right) as view_right, max(r.access_right) as access_right , max(r.deny_right) as deny_right, max(r.mgr_right) as mgr_right, max(r.other_right) as other_right, t.folder_code from pu_right r, pu_folder t where r.user_type = 3 and r.user_code in (:9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20) and r.folder_code=t.folder_code and r.folder_code in(:21, :22, :23) group by t.folder_code
ahxtwjz5p0g30	SELECT * FROM(SELECT TMP_TBL_A.*, rownum as LAYER_A_ROWNUM FROM( select A.flow_inid from (select max(CC.step_index) as max_step_index from deal_info CC where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and CC.deal_man in (:1, :2, :3, :4, :5, :6) group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2 order by C.rece_date desc) TMP_TBL_A WHERE rownum <= 20 ) TMP_TBL_B WHERE LAYER_A_ROWNUM >= 1
b8k52qq2a8z9d	select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8) and r.deny_right=1))) order by record_pri asc, crt_date desc
bccrrd3sz1p7t	select PACT_NAME, PACT_NAME from YW_HS_PAY
bdra985w3wh0b	select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1))) order by record_pri asc, crt_date desc
bjn4vnyg20p7s	select count(record_code) from pu_record where (record_status=1 and ( folder_code =:1)) and (( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1))))
bkqkgwk70vnwp	select C_FLOW_INID, C_FLOW_INID from YW_HS_PAY_1
bp0pj777358k3	select FRAMNAME, FULL_NAME, USER_CODE from V_CENTER_LEADERASDIFO_ZJ where USER_CODE is not null
c3m2v78k06wvy	SELECT NULL AS table_cat, c.owner AS table_schem, c.table_name, c.column_name, c.position AS key_seq, c.constraint_name AS pk_name FROM all_cons_columns c, all_constraints k WHERE k.constraint_type = 'P' AND k.table_name = :1 AND k.owner like :2 escape '/' AND k.constraint_name = c.constraint_name AND k.table_name = c.table_name AND k.owner = c.owner ORDER BY column_name
c4d6d9kwzwkqt	select user_sign from usersign where user_code=:1
c4f1v62z1pfgz	SELECT FRAMNAME3 FROM V_RPT_FRAMEDEPARTMENT WHERE USER_CODE=:B1 AND ROWNUM=1
cb7zvbajzhbq7	select dept_code from framedepartment where fram_code in (select max(f.fram_code) from pt_style_config a, user_dept d, framedepartment f, framedepartment fd where a.sys_id=:1 and a.user_code=f.dept_code and d.user_code=:2 and d.fram_seq = fd.dept_code and fd.fram_code like f.fram_code\|\|'%')
chr72bqg3x425	SELECT FRAMNAME5 FROM V_RPT_FRAMEDEPARTMENT WHERE USER_CODE=:B1 AND ROWNUM=1
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d15cdr0zt3vtp	SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, COUNT(username) AS failed_count FROM sys.dba_audit_session WHERE returncode != 0 AND TO_CHAR(timestamp, 'YYYY-MM-DD HH24:MI:SS') >= TO_CHAR(current_timestamp - TO_DSINTERVAL('0 0:30:00'), 'YYYY-MM-DD HH24:MI:SS')
d1ra7j6na0h1a	INSERT INTO DEAL_INFO (FLOW_INID, STEP_INCO, DEAL_INDX, PERI_MAN, STEP_MAN, DEAL_MAN, FULL_NAME, AGEN_MEN, DEAL_EFFE, STEP_CHOI, CHOI_CONT, NEXT_EFFE, NEXT_MAN, CURR_MAN, STEP_TYPE, RECE_DATE, FINI_DATE, FINI_FLAG, READ_FLAG, SAVE_DATE, DEAL_SIGN, DEL_FLAG, NOTE_MAN, URGE_INFO, DEAL_NOTE, URGE_DATE, REMIND_TYPE, TIME_SET, URGE_TIMES, URGE_SET, URGE_FINI_FLAG, REGI_FLAG, FSUB_INID, FW_MAN, FSUB_FLAG, STEP_INDEX, BACK_FLAG, OPEN_DATE, SELF_SCORE, OTHER_SCORE, OPEN_TERM, DEAL_TERM, PRE_DEAL_IDX, SUB_DEAL_CNT, APPEND_PATH, HAS_SYNC, ALLOGRAPH, ARCH_FLAG, CA_SIGN_STATE, FORM_SIGN_VERIFY_DATA, ALLOGRAPH_DATE, DEAL_COMM, AGEN_FLAG, FLOW_ID, STEP_CODE, DREDGE_REASON, DREDGE_MAN, DREDGE_DATE, URGE_COUNT) 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)
d2gfcw9ut156m	select count(*) as CNT from (select max(CC.step_index) as max_step_index from deal_info CC, flow_inst AA where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and AA.fins_name like :1 and CC.deal_man in (:2, :3, :4, :5, :6, :7, :8) and AA.flow_inid=CC.flow_inid group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2
da7mkv3ngfq7a	select FRAMNAME, USER_CODE from V_CENTER_LEADERASDIFO_ZJ
dqtu59yjn126m	select user_code from user_dept where fram_code in(: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, :207, :208, :209, :210, :211, :212, :213, :214, :215, :216, :217, :218, :219, :220, :221, :222, :223, :224, :225, :226, :227, :228, :229, :230, :231, :232, :233, :234, :235, :236, :237, :238, :239, :240, :241, :242, :243, :244, :245, :246, :247, :248, :249, :250, :251, :252, :253, :254, :255, :256, :257, :258, :259, :260, :261, :262, :263, :264, :265, :266, :267, :268, :269, :270, :271, :272, :273, :274, :275, :276, :277, :278, :279, :280, :281, :282, :283, :284, :285, :286, :287, :288, :289, :290, :291, :292, :293, :294, :295, :296, :297, :298, :299, :300, :301, :302, :303, :304, :305, :306, :307, :308, :309, :310, :311, :312, :313, :314, :315, :316, :317, :318, :319, :320, :321, :322, :323, :324, :325, :326, :327, :328, :329, :330, :331, :332, :333, :334, :335, :336, :337, :338, :339, :340, :341, :342, :343, :344, :345, :346, :347, :348, :349, :350, :351, :352, :353, :354, :355, :356, :357, :358, :359, :360, :361, :362, :363, :364, :365, :366, :367, :368, :369, :370, :371, :372, :373, :374, :375, :376, :377, :378, :379, :380, :381, :382, :383, :384, :385, :386, :387, :388, :389, :390, :391, :392, :393, :394, :395, :396, :397, :398, :399, :400, :401, :402, :403, :404, :405, :406, :407, :408, :409, :410, :411, :412, :413, :414, :415, :416, :417, :418, :419, :420, :421, :422, :423, :424, :425, :426, :427, :428, :429, :430, :431, :432, :433, :434, :435, :436, :437, :438, :439, :440, :441, :442, :443, :444, :445, :446, :447, :448, :449, :450, :451, :452, :453, :454, :455, :456, :457, :458, :459, :460, :461, :462, :463, :464, :465, :466, :467, :468, :469, :470, :471, :472, :473, :474, :475, :476, :477, :478, :479, :480, :481, :482, :483, :484, :485, :486, :487, :488, :489, :490, :491, :492, :493, :494, :495, :496, :497, :498, :499, :500) or fram_code in(:501, :502, :503, :504, :505, :506, :507, :508, :509, :510, :511, :512, :513, :514, :515, :516, :517, :518, :519, :520, :521, :522, :523, :524, :525, :526, :527, :528, :529, :530, :531, :532, :533, :534, :535, :536, :537, :538, :539, :540, :541, :542, :543, :544, :545, :546, :547, :548, :549, :550, :551, :552, :553, :554, :555, :556, :557, :558, :559, :560, :561, :562, :563, :564, :565, :566, :567, :568, :569, :570, :571, :572, :573, :574, :575, :576, :577, :578, :579, :580, :581, :582, :583, :584, :585, :586, :587, :588, :589, :590, :591, :592, :593, :594, :595, :596, :597, :598, :599, :600, :601, :602, :603, :604, :605, :606, :607, :608, :609, :610, :611, :612, :613, :614, :615, :616, :617, :618, :619, :620, :621, :622, :623, :624, :625, :626, :627, :628, :629, :630, :631, :632, :633, :634, :635, :636, :637, :638, :639, :640, :641, :642, :643, :644, :645, :646, :647, :648, :649, :650, :651, :652, :653, :654, :655, :656, :657, :658, :659, :660, :661, :662, :663, :664, :665, :666, :667, :668, :669, :670, :671, :672, :673, :67 4, :675, :676, :677, :678, :679, :680, :681, :682, :683, :684, :685, :686, :687, :688, :689, :690, :691, :692, :693, :694, :695, :696, :697, :698, :699, :700, :701, :702, :703, :704, :705, :706, :707, :708, :709, :710, :711, :712, :713, :714, :715, :716, :717, :718, :719, :720, :721, :722, :723, :724, :725, :726, :727, :728, :729, :730, :731, :732, :733, :734, :735, :736, :737, :738, :739, :740, :741, :742, :743, :744, :745, :746, :747, :748, :749, :750, :751, :752, :753, :754, :755, :756, :757, :758, :759, :760, :761, :762, :763, :764, :765, :766, :767, :768, :769, :770, :771, :772, :773, :774, :775, :776, :777, :778, :779, :780, :781, :782, :783, :784, :785, :786, :787, :788, :789, :790, :791, :792, :793, :794, :795, :796, :797, :798, :799, :800, :801, :802, :803, :804, :805, :806, :807, :808, :809, :810, :811, :812, :813, :814, :815, :816, :817, :818, :819, :820, :821, :822, :823, :824, :825, :826, :827, :828, :829, :830, :831, :832, :833, :834, :835, :836, :837, :838, :839, :840, :841, :842, :843, :844, :845, :846, :847, :848, :849, :850, :851, :852, :853, :854, :855, :856, :857, :858, :859, :860, :861, :862, :863, :864, :865, :866, :867, :868, :869, :870, :871, :872, :873, :874, :875, :876, :877, :878, :879, :880, :881, :882, :883, :884, :885, :886, :887, :888, :889, :890, :891, :892, :893, :894, :895, :896, :897, :898, :899, :900, :901, :902, :903, :904, :905, :906, :907, :908, :909, :910, :911, :912, :913, :914, :915, :916, :917, :918, :919, :920, :921, :922, :923, :924, :925, :926, :927, :928, :929, :930, :931, :932, :933, :934, :935, :936, :937, :938, :939, :940, :941, :942, :943, :944, :945, :946, :947, :948, :949, :950, :951, :952, :953, :954, :955, :956, :957, :958, :959, :960, :961, :962, :963, :964, :965, :966, :967, :968, :969, :970, :971, :972, :973, :974, :975, :976, :977, :978, :979, :980, :981, :982, :983, :984, :985, :986, :987, :988, :989, :990, :991, :992, :993, :994, :995, :996, :997, :998, :999, :1000) or fram_code in(:1001, :1002, :1003, :1004, :1005, :1006, :1007, :1008, :1009, :1010, :1011, :1012, :1013, :1014, :1015, :1016, :1017, :1018, :1019, :1020, :1021, :1022, :1023, :1024, :1025, :1026, :1027, :1028, :1029, :1030, :1031, :1032, :1033, :1034, :1035, :1036, :1037, :1038, :1039, :1040, :1041, :1042, :1043, :1044, :1045, :1046, :1047, :1048, :1049, :1050, :1051, :1052, :1053, :1054, :1055, :1056, :1057, :1058, :1059, :1060, :1061, :1062, :1063, :1064, :1065, :1066, :1067, :1068, :1069, :1070, :1071, :1072, :1073, :1074, :1075, :1076, :1077, :1078, :1079, :1080, :1081, :1082, :1083, :1084, :1085, :1086, :1087, :1088, :1089, :1090, :1091, :1092, :1093, :1094, :1095, :1096, :1097, :1098, :1099, :1100, :1101, :1102, :1103, :1104, :1105, :1106, :1107, :1108, :1109, :1110, :1111, :1112, :1113, :1114, :1115, :1116, :1117, :1118, :1119, :1120, :1121, :1122, :1123, :1124, :1125, :1126, :1127, :1128, :1129, :1130, :1131, :1132, :1133, :1134, :1135, :1136, :1137, :1138, :1139, :1140, :1141, :1142, :1143, :1144, :1145, :1146, :1147, :1148, :1149, :1150, :1151, :1152, :1153, :1154, :1155, :1156, :1157, :1158, :1159, :1160, :1161, :1162, :1163, :1164, :1165, :1166, :1167, :1168, :1169, :1170, :1171, :1172, :1173, :1174, :1175, :1176, :1177, :1178, :1179, :1180, :1181, :1182, :1183, :1184, :1185, :1186, :1187, :1188, :1189, :1190, :1191, :1192, :1193, :1194, :1195, :1196, :1197, :1198, :1199, :1200, :1201, :1202, :1203, :1204, :1205, :1206, :1207, :1208, :1209, :1210, :1211, :1212, :1213, :1214, :1215, :1216, :1217, :1218, :1219, :1220, :1221, :1222, :1223, :1224, :1225, :1226, :1227, :1228, :1229, :1230, :1231, :1232, :1233, :1234, :1235, :1236, :1237, :1238, :1239, :1240, :1241, :1242, :1243, :1244, :1245, :1246, :1247, :1248, :1249, :1250, :1251, :1252, :1253, :1254, :1255, :1256, :1257, :1258, :1259, :1260, :1261, :1262, :1263, :1264, :1265, :1266, :1267, :1268, :1269, :1270, :1271, :1272, :1273, :1274, :1275, :1276, :1277, :1278, :1279, :1280, :1281, :1282, :1283, :1284, :1285, :1286, :1287, :1288, :1289, : 1290, :1291, :1292, :1293, :1294, :1295, :1296, :1297, :1298, :1299, :1300, :1301, :1302, :1303, :1304, :1305, :1306, :1307, :1308, :1309, :1310, :1311, :1312, :1313, :1314, :1315, :1316, :1317, :1318, :1319, :1320, :1321, :1322, :1323, :1324, :1325, :1326, :1327, :1328, :1329, :1330, :1331, :1332, :1333, :1334, :1335, :1336, :1337, :1338, :1339, :1340, :1341, :1342, :1343, :1344, :1345, :1346, :1347, :1348, :1349, :1350, :1351, :1352, :1353, :1354, :1355, :1356, :1357, :1358, :1359, :1360, :1361, :1362, :1363, :1364, :1365, :1366, :1367, :1368, :1369, :1370, :1371, :1372, :1373, :1374, :1375, :1376, :1377, :1378, :1379, :1380, :1381, :1382, :1383, :1384, :1385, :1386, :1387, :1388, :1389, :1390, :1391, :1392, :1393, :1394, :1395, :1396, :1397, :1398, :1399, :1400, :1401, :1402, :1403, :1404, :1405, :1406, :1407, :1408, :1409, :1410, :1411, :1412, :1413, :1414, :1415, :1416, :1417, :1418, :1419, :1420, :1421, :1422, :1423, :1424, :1425, :1426, :1427, :1428, :1429, :1430, :1431, :1432, :1433, :1434, :1435, :1436, :1437, :1438, :1439, :1440, :1441, :1442, :1443, :1444, :1445, :1446, :1447, :1448, :1449, :1450, :1451, :1452, :1453, :1454, :1455, :1456, :1457, :1458, :1459, :1460, :1461, :1462, :1463, :1464, :1465, :1466, :1467, :1468, :1469, :1470, :1471, :1472, :1473, :1474, :1475, :1476, :1477, :1478, :1479, :1480, :1481, :1482, :1483, :1484, :1485, :1486, :1487, :1488, :1489, :1490, :1491, :1492, :1493, :1494, :1495, :1496, :1497, :1498, :1499, :1500) or fram_code in(:1501, :1502, :1503, :1504, :1505, :1506, :1507, :1508, :1509, :1510, :1511, :1512, :1513, :1514, :1515, :1516, :1517, :1518, :1519, :1520, :1521, :1522, :1523, :1524, :1525, :1526, :1527, :1528, :1529, :1530, :1531, :1532, :1533, :1534, :1535, :1536, :1537, :1538, :1539, :1540, :1541, :1542, :1543, :1544, :1545, :1546, :1547, :1548, :1549, :1550, :1551, :1552, :1553, :1554, :1555, :1556, :1557, :1558, :1559, :1560, :1561, :1562, :1563, :1564, :1565, :1566, :1567, :1568, :1569, :1570, :1571, :1572, :1573, :1574, :1575, :1576, :1577, :1578, :1579, :1580, :1581, :1582, :1583, :1584, :1585, :1586, :1587, :1588, :1589, :1590, :1591, :1592, :1593, :1594, :1595, :1596, :1597, :1598, :1599, :1600, :1601, :1602, :1603, :1604, :1605, :1606, :1607, :1608, :1609, :1610, :1611, :1612, :1613, :1614, :1615, :1616, :1617, :1618, :1619, :1620, :1621, :1622, :1623, :1624, :1625, :1626, :1627, :1628, :1629, :1630, :1631, :1632, :1633, :1634, :1635, :1636, :1637, :1638, :1639, :1640, :1641, :1642, :1643, :1644, :1645, :1646)
f5um7r3gqsh8k	select * from (select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9, :10, :11, :12) and r.deny_right=1))) order by record_pri asc, crt_date desc) where rownum<=:13
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fuv260cu4xtpp	SELECT * FROM(SELECT TMP_TBL_A.*, rownum as LAYER_A_ROWNUM FROM( select A.flow_inid from (select max(CC.step_index) as max_step_index from deal_info CC, flow_inst AA where CC.fini_flag >=0 and CC.step_type<>5 and CC.step_type<>4 and CC.del_flag=0 and (1=1) and AA.fins_name like :1 and CC.deal_man in (:2, :3, :4, :5, :6, :7, :8) and AA.flow_inid=CC.flow_inid group by CC.flow_inid ) M , flow_inst A, deal_info C where A.flow_inid=C.flow_inid and A.flow_id not in(: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) and (A.del_flag=0) and C.step_index=M.max_step_index and A.if_efec<>2 order by C.rece_date desc) TMP_TBL_A WHERE rownum <= 20 ) TMP_TBL_B WHERE LAYER_A_ROWNUM >= 1
gd6navngbca3a	select record_code, record_title, crt_date from pu_record where ( folder_code=:1 and record_status = 1 and (decode(invalid_date, null, sysdate, invalid_date)+1-sysdate)>0 ) and ( not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:2 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:3 ) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:4, :5, :6, :7, :8, :9) and r.deny_right=1)) or ( (crt_user=:10 or ( exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:11 and r.view_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:12) and r.view_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:13, :14, :15, :16, :17, :18) and r.view_right=1)))) and not exists ( select pr.record_code from pu_recordright pr where pr.record_code=pu_record.record_code and pr.record_code in ( select r.record_code from pu_recordright r where r.user_type = 1 and r.user_code=:19 and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 2 and r.user_code in (select grop_code from user_group where user_code=:20) and r.deny_right=1 union all select r.record_code from pu_recordright r where r.user_type = 3 and r.user_code in(:21, :22, :23, :24, :25, :26) and r.deny_right=1)))) order by crt_date desc, record_code asc, record_pri asc
gknkvjn6rhx0a	select user_code from user_dept where fram_code in(: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, :207, :208, :209, :210, :211, :212, :213, :214, :215, :216, :217, :218, :219, :220, :221, :222, :223, :224, :225, :226, :227, :228, :229, :230, :231, :232, :233, :234, :235, :236, :237, :238, :239, :240, :241, :242, :243, :244, :245, :246, :247, :248, :249, :250, :251, :252, :253, :254, :255, :256, :257, :258, :259, :260, :261, :262, :263, :264, :265, :266, :267, :268, :269, :270, :271, :272, :273, :274, :275, :276, :277, :278, :279, :280, :281, :282, :283, :284, :285, :286, :287, :288, :289, :290, :291, :292, :293, :294, :295, :296, :297, :298, :299, :300, :301, :302, :303, :304, :305, :306, :307, :308, :309, :310, :311, :312, :313, :314, :315, :316, :317, :318, :319, :320, :321, :322, :323, :324, :325, :326, :327, :328, :329, :330, :331, :332, :333, :334, :335, :336, :337, :338, :339, :340, :341, :342, :343, :344, :345, :346, :347, :348, :349, :350, :351, :352, :353, :354, :355, :356, :357, :358, :359, :360, :361, :362, :363, :364, :365, :366, :367, :368, :369, :370, :371, :372, :373, :374, :375, :376, :377, :378, :379, :380, :381, :382, :383, :384, :385, :386, :387, :388, :389, :390, :391, :392, :393, :394, :395, :396, :397, :398, :399, :400, :401, :402, :403, :404, :405, :406, :407, :408, :409, :410, :411, :412, :413, :414, :415, :416, :417, :418, :419, :420, :421, :422, :423, :424, :425, :426, :427, :428, :429, :430, :431, :432, :433, :434, :435, :436, :437, :438, :439, :440, :441, :442, :443, :444, :445, :446, :447, :448, :449, :450, :451, :452, :453, :454, :455, :456, :457, :458, :459, :460, :461, :462, :463, :464, :465, :466, :467, :468, :469, :470, :471, :472, :473, :474, :475, :476, :477, :478, :479, :480, :481, :482, :483, :484, :485, :486, :487, :488, :489, :490, :491, :492, :493, :494, :495, :496, :497, :498, :499, :500) or fram_code in(:501, :502, :503, :504, :505, :506, :507, :508, :509, :510, :511, :512, :513, :514, :515, :516, :517, :518, :519, :520, :521, :522, :523, :524, :525, :526, :527, :528, :529, :530, :531, :532, :533, :534, :535, :536, :537, :538, :539, :540, :541, :542, :543, :544, :545, :546, :547, :548, :549, :550, :551, :552, :553, :554, :555, :556, :557, :558, :559, :560, :561, :562, :563, :564, :565, :566, :567, :568, :569, :570, :571, :572, :573, :574, :575, :576, :577, :578, :579, :580, :581, :582, :583, :584, :585, :586, :587, :588, :589, :590, :591, :592, :593, :594, :595, :596, :597, :598, :599, :600, :601, :602, :603, :604, :605, :606, :607, :608, :609, :610, :611, :612, :613, :614, :615, :616, :617, :618, :619, :620, :621, :622, :623, :624, :625, :626, :627, :628, :629, :630, :631, :632, :633, :634, :635, :636, :637, :638, :639, :640, :641, :642, :643, :644, :645, :646, :647, :648, :649, :650, :651, :652, :653, :654, :655, :656, :657, :658, :659, :660, :661, :662, :663, :664, :665, :666, :667, :668, :669, :670, :671, :672, :673, :67 4, :675, :676, :677, :678, :679, :680, :681, :682, :683, :684, :685, :686, :687, :688, :689, :690, :691, :692, :693, :694, :695, :696, :697, :698, :699, :700, :701, :702, :703, :704, :705, :706, :707, :708, :709, :710, :711, :712, :713, :714, :715, :716, :717, :718, :719, :720, :721, :722, :723, :724, :725, :726, :727, :728, :729, :730, :731, :732, :733, :734, :735, :736, :737, :738, :739, :740, :741, :742, :743, :744, :745, :746, :747, :748, :749, :750, :751, :752, :753, :754, :755, :756, :757, :758, :759, :760, :761, :762, :763, :764, :765, :766, :767, :768, :769, :770, :771, :772, :773, :774, :775, :776, :777, :778, :779, :780, :781, :782, :783, :784, :785, :786, :787, :788, :789, :790, :791, :792, :793, :794, :795, :796, :797, :798, :799, :800, :801, :802, :803, :804, :805, :806, :807, :808, :809, :810, :811, :812, :813, :814, :815, :816, :817, :818, :819, :820, :821, :822, :823, :824, :825, :826, :827, :828, :829, :830, :831, :832, :833, :834, :835, :836, :837, :838, :839, :840, :841, :842, :843, :844, :845, :846, :847, :848, :849, :850, :851, :852, :853, :854, :855, :856, :857, :858, :859, :860, :861, :862, :863, :864, :865, :866, :867, :868, :869, :870, :871, :872, :873, :874, :875, :876, :877, :878, :879, :880, :881, :882, :883, :884, :885, :886, :887, :888, :889, :890, :891, :892, :893, :894, :895, :896, :897, :898, :899, :900, :901, :902, :903, :904, :905, :906, :907, :908, :909, :910, :911, :912, :913, :914, :915, :916, :917, :918, :919, :920, :921, :922, :923, :924, :925, :926, :927, :928, :929, :930, :931, :932, :933, :934, :935, :936, :937, :938, :939, :940, :941, :942, :943, :944, :945, :946, :947, :948, :949, :950, :951, :952, :953, :954, :955, :956, :957, :958, :959, :960, :961, :962, :963, :964, :965, :966, :967, :968, :969, :970, :971, :972, :973, :974, :975, :976, :977, :978, :979, :980, :981, :982, :983, :984, :985, :986, :987, :988, :989, :990, :991, :992, :993, :994, :995, :996, :997, :998, :999, :1000) or fram_code in(:1001, :1002, :1003, :1004, :1005, :1006, :1007, :1008, :1009, :1010, :1011, :1012, :1013, :1014, :1015, :1016, :1017, :1018, :1019, :1020, :1021, :1022, :1023, :1024, :1025, :1026, :1027, :1028, :1029, :1030, :1031, :1032, :1033, :1034, :1035, :1036, :1037, :1038, :1039, :1040, :1041, :1042, :1043, :1044, :1045, :1046, :1047, :1048, :1049, :1050, :1051, :1052, :1053, :1054, :1055, :1056, :1057, :1058, :1059, :1060, :1061, :1062, :1063, :1064, :1065, :1066, :1067, :1068, :1069, :1070, :1071, :1072, :1073, :1074, :1075, :1076, :1077, :1078, :1079, :1080, :1081, :1082, :1083, :1084, :1085, :1086, :1087, :1088, :1089, :1090, :1091, :1092, :1093, :1094, :1095, :1096, :1097, :1098, :1099, :1100, :1101, :1102, :1103, :1104, :1105, :1106, :1107, :1108, :1109, :1110, :1111, :1112, :1113, :1114, :1115, :1116, :1117, :1118, :1119, :1120, :1121, :1122, :1123, :1124, :1125, :1126, :1127, :1128, :1129, :1130, :1131, :1132, :1133, :1134, :1135, :1136, :1137, :1138, :1139, :1140, :1141, :1142, :1143, :1144, :1145, :1146, :1147, :1148, :1149, :1150, :1151, :1152, :1153, :1154, :1155, :1156, :1157, :1158, :1159, :1160, :1161, :1162, :1163, :1164, :1165, :1166, :1167, :1168, :1169, :1170, :1171, :1172, :1173, :1174, :1175, :1176, :1177, :1178, :1179, :1180, :1181, :1182)
guh4ntbgbt1mc	select PACT_NAME, PACT_NAME from YW_HS_PAY_1

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	2	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	123	0.10	0.05
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	33	0.03	0.01
Batched IO same unit count	18	0.01	0.01
Batched IO single block count	19	0.02	0.01
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	75	0.06	0.03
Batched IO vector read count	16	0.01	0.01
Block Cleanout Optim referenced	0	0.00	0.00
CCursor + sql area evicted	43	0.04	0.02
CPU used by this session	72,264	60.09	32.12
CPU used when call started	70,010	58.21	31.12
CR blocks created	2,815	2.34	1.25
Cached Commit SCN referenced	811,950	675.14	360.87
Commit SCN cached	17	0.01	0.01
DB time	355,438	295.55	157.97
DBWR checkpoint buffers written	5,609	4.66	2.49
DBWR checkpoints	6	0.00	0.00
DBWR fusion writes	2,113	1.76	0.94
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	51	0.04	0.02
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	86	0.07	0.04
DBWR undo block writes	1,019	0.85	0.45
DFO trees parallelized	162	0.13	0.07
Effective IO time	76,600,983	63,694.18	34,044.88
HSC Heap Segment Block Changes	26,267	21.84	11.67
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	142	0.12	0.06
Heap Segment Array Updates	12	0.01	0.01
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	28,123	23.38	12.50
PX local messages recv'd	2,040	1.70	0.91
PX local messages sent	2,040	1.70	0.91
PX remote messages recv'd	2,726	2.27	1.21
PX remote messages sent	8,210	6.83	3.65
Parallel operations not downgraded	162	0.13	0.07
Requests to/from client	2,610,167	2,170.37	1,160.07
RowCR - row contention	1	0.00	0.00
RowCR attempts	4,360	3.63	1.94
RowCR hits	4,344	3.61	1.93
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	2	0.00	0.00
SQL*Net roundtrips to/from client	2,610,210	2,170.41	1,160.09
active txn count during cleanout	1,569	1.30	0.70
application wait time	66	0.05	0.03
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	8,684	7.22	3.86
branch node splits	0	0.00	0.00
buffer is not pinned count	23,036,870	19,155.30	10,238.61
buffer is pinned count	30,032,937	24,972.57	13,347.97
bytes received via SQL*Net from client	98,589,813	81,978.03	43,817.69
bytes sent via SQL*Net to client	1,260,772,705	1,048,340.19	560,343.42
calls to get snapshot scn: kcmgss	464,838	386.52	206.59
calls to kcmgas	61,937	51.50	27.53
calls to kcmgcs	1,170,989	973.68	520.44
cell physical IO interconnect bytes	16,089,043,968	13,378,138.18	7,150,686.21
change write time	221	0.18	0.10
cleanout - number of ktugct calls	4,762	3.96	2.12
cleanouts and rollbacks - consistent read gets	316	0.26	0.14
cleanouts only - consistent read gets	1,837	1.53	0.82
cluster key scan block gets	434,021	360.89	192.90
cluster key scans	87,752	72.97	39.00
cluster wait time	23,469	19.51	10.43
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	9	0.01	0.00
commit batch/immediate requested	9	0.01	0.00
commit cleanout failures: block lost	40	0.03	0.02
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	19	0.02	0.01
commit cleanout failures: cannot pin	1,875	1.56	0.83
commit cleanouts	33,086	27.51	14.70
commit cleanouts successfully completed	31,152	25.90	13.85
commit immediate performed	9	0.01	0.00
commit immediate requested	9	0.01	0.00
commit txn count during cleanout	4,331	3.60	1.92
concurrency wait time	1,108	0.92	0.49
consistent changes	965	0.80	0.43
consistent gets	62,202,564	51,721.81	27,645.58
consistent gets - examination	15,934,776	13,249.86	7,082.12
consistent gets direct	1,941,499	1,614.37	862.89
consistent gets from cache	60,261,069	50,107.45	26,782.70
consistent gets from cache (fastpath)	43,257,788	35,969.11	19,225.68
cursor authentications	768	0.64	0.34
data blocks consistent reads - undo records applied	771	0.64	0.34
db block changes	150,039	124.76	66.68
db block gets	149,839	124.59	66.60
db block gets direct	2,238	1.86	0.99
db block gets from cache	147,601	122.73	65.60
db block gets from cache (fastpath)	26,861	22.34	11.94
deferred (CURRENT) block cleanout applications	15,995	13.30	7.11
dirty buffers inspected	280	0.23	0.12
enqueue conversions	1,549	1.29	0.69
enqueue releases	99,732	82.93	44.33
enqueue requests	99,743	82.94	44.33
enqueue timeouts	6	0.00	0.00
enqueue waits	794	0.66	0.35
exchange deadlocks	8	0.01	0.00
execute count	411,236	341.95	182.77
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	78,485,296	65,261.00	34,882.35
free buffer inspected	18,115	15.06	8.05
free buffer requested	29,195	24.28	12.98
gc blocks compressed	22,312	18.55	9.92
gc blocks lost	0	0.00	0.00
gc cr block flush time	378	0.31	0.17
gc cr block receive time	1,695	1.41	0.75
gc cr blocks received	8,136	6.77	3.62
gc cr blocks served	12,876	10.71	5.72
gc current block flush time	4,940	4.11	2.20
gc current block pin time	97	0.08	0.04
gc current block receive time	8,323	6.92	3.70
gc current blocks received	14,487	12.05	6.44
gc current blocks served	20,830	17.32	9.26
gc kbytes saved	74,044	61.57	32.91
gc kbytes sent	195,604	162.65	86.94
gc local grants	1,770	1.47	0.79
gc read wait time	69	0.06	0.03
gc read wait timeouts	10	0.01	0.00
gc read waits	63	0.05	0.03
gc reader bypass grants	0	0.00	0.00
gc remote grants	4,921	4.09	2.19
gcs messages sent	95,470	79.38	42.43
ges messages sent	3,589	2.98	1.60
global enqueue get time	341	0.28	0.15
global enqueue gets async	99	0.08	0.04
global enqueue gets sync	198,505	165.06	88.22
global enqueue releases	197,173	163.95	87.63
heap block compress	400	0.33	0.18
hot buffers moved to head of LRU	338	0.28	0.15
immediate (CR) block cleanout applications	2,153	1.79	0.96
immediate (CURRENT) block cleanout applications	2,322	1.93	1.03
in call idle wait time	5,427,767	4,513.22	2,412.34
index crx upgrade (positioned)	18,849	15.67	8.38
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	22,378	18.61	9.95
index fast full scans (rowid ranges)	1,456	1.21	0.65
index fetch by key	10,836,976	9,011.01	4,816.43
index scans kdiixs1	6,696,574	5,568.24	2,976.26
leaf node 90-10 splits	30	0.02	0.01
leaf node splits	97	0.08	0.04
lob reads	7,344	6.11	3.26
lob writes	170	0.14	0.08
lob writes unaligned	129	0.11	0.06
logical read bytes from cache	494,867,832,832	411,485,621.04	219,941,259.04
logons cumulative	10,849	9.02	4.82
max cf enq hold time	0	0.00	0.00
messages received	44,907	37.34	19.96
messages sent	44,907	37.34	19.96
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	44,740,257	37,201.80	19,884.56
non-idle wait count	3,043,349	2,530.56	1,352.60
non-idle wait time	100,509	83.57	44.67
opened cursors cumulative	274,244	228.04	121.89
parse count (describe)	0	0.00	0.00
parse count (failures)	8	0.01	0.00
parse count (hard)	1,736	1.44	0.77
parse count (total)	135,250	112.46	60.11
parse time cpu	3,362	2.80	1.49
parse time elapsed	3,461	2.88	1.54
physical read IO requests	29,426	24.47	13.08
physical read bytes	15,810,248,704	13,146,318.22	7,026,777.20
physical read total IO requests	34,053	28.32	15.13
physical read total bytes	15,885,993,984	13,209,300.88	7,060,441.77
physical read total multi block requests	5,753	4.78	2.56
physical reads	1,929,962	1,604.78	857.76
physical reads cache	1,237	1.03	0.55
physical reads cache prefetch	25	0.02	0.01
physical reads direct	1,928,725	1,603.75	857.21
physical reads direct (lob)	31,850	26.48	14.16
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	7,655	6.37	3.40
physical write bytes	77,398,016	64,356.92	34,399.12
physical write total IO requests	53,773	44.71	23.90
physical write total bytes	203,049,984	168,837.30	90,244.44
physical write total multi block requests	131	0.11	0.06
physical writes	9,448	7.86	4.20
physical writes direct	2,238	1.86	0.99
physical writes direct (lob)	2,231	1.86	0.99
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	7,210	6.00	3.20
physical writes non checkpoint	5,965	4.96	2.65
pinned buffers inspected	7	0.01	0.00
pinned cursors current	76	0.06	0.03
prefetch clients - default	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	1,200	1.00	0.53
queries parallelized	162	0.13	0.07
recovery blocks read	0	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	1,792,256	1,490.27	796.56
recursive cpu usage	13,953	11.60	6.20
redo KB read	0	0.00	0.00
redo blocks checksummed by FG (exclusive)	40,674	33.82	18.08
redo blocks read for recovery	0	0.00	0.00
redo blocks written	104,112	86.57	46.27
redo buffer allocation retries	0	0.00	0.00
redo entries	86,175	71.66	38.30
redo k-bytes read for recovery	0	0.00	0.00
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	988	0.82	0.44
redo size	46,489,100	38,655.97	20,661.82
redo size for direct writes	18,414,264	15,311.57	8,184.12
redo subscn max counts	1,300	1.08	0.58
redo synch long waits	132	0.11	0.06
redo synch time	28,833	23.97	12.81
redo synch time (usec)	294,834,515	245,156.70	131,037.56
redo synch writes	23,166	19.26	10.30
redo wastage	5,116,360	4,254.28	2,273.94
redo write broadcast ack count	86	0.07	0.04
redo write broadcast ack time	1,188,932	988.60	528.41
redo write broadcast lgwr post count	0	0.00	0.00
redo write time	21,433	17.82	9.53
redo writes	22,419	18.64	9.96
rollback changes - undo records applied	126	0.10	0.06
rollbacks only - consistent read gets	165	0.14	0.07
root node splits	0	0.00	0.00
rows fetched via callback	5,606,726	4,662.03	2,491.88
session connect time	0	0.00	0.00
session cursor cache hits	139,864	116.30	62.16
session logical reads	62,352,253	51,846.28	27,712.11
shared hash latch upgrades - no wait	333,193	277.05	148.09
shared hash latch upgrades - wait	1,418	1.18	0.63
sorts (disk)	0	0.00	0.00
sorts (memory)	405,144	336.88	180.06
sorts (rows)	2,484,302	2,065.71	1,104.13
sql area evicted	1,983	1.65	0.88
sql area purged	8	0.01	0.00
summed dirty queue length	1,743	1.45	0.77
switch current to new buffer	686	0.57	0.30
table fetch by rowid	20,164,671	16,767.05	8,962.08
table fetch continued row	212,565	176.75	94.47
table scan blocks gotten	31,990,109	26,599.97	14,217.83
table scan rows gotten	4,170,576,334	3,467,859.66	1,853,589.48
table scans (direct read)	44	0.04	0.02
table scans (long tables)	1	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	522,567	434.52	232.25
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	3,232	2.69	1.44
total number of cf enq holders	61	0.05	0.03
total number of times SMON posted	5	0.00	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	9	0.01	0.00
transaction tables consistent read rollbacks	3	0.00	0.00
transaction tables consistent reads - undo records applied	150	0.12	0.07
undo change vector size	6,795,092	5,650.16	3,020.04
user I/O wait time	9,515	7.91	4.23
user calls	2,711,451	2,254.59	1,205.09
user commits	2,241	1.86	1.00
user rollbacks	9	0.01	0.00
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	356,284	296.25	158.35
write clones created in background	0	0.00	0.00
write clones created in foreground	3	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session pga memory max	72,088,237,728	72,193,372,912
session cursor cache count	89,218,437	89,335,631
session uga memory	75,019,827,485,048	75,020,410,249,432
opened cursors current	5,448	5,719
workarea memory allocated	0	1,326
logons current	296	303
session uga memory max	10,002,568,929,112	10,019,495,177,656
session pga memory	60,091,673,632	60,135,777,744

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

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)
Direct Reads	14.7G	23.32	12.5274	0M	0.00	0M	0
Others	72M	3.90	.059868	34M	2.56	.028271	5274	3.32
LGWR	0M	0.00	0M	100M	37.33	.083150	22.4K	9.55
DBWR	0M	0.00	0M	56M	4.52	.046564	0
Buffer Cache Reads	10M	1.03	.008315	0M	0.00	0M	1211	7.16
Direct Writes	0M	0.00	0M	3M	0.26	.002494	0
TOTAL:	14.8G	28.25	12.5956	193M	44.66	.160480	28.9K	8.31

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	14.7G	24.40	12.5366	75M	6.36	.062362	3.44	30.78
Log File	0M	0.00	0M	100M	37.32	.083150
Control File	72M	3.84	.059868	18M	0.96	.014967	1.75
TOTAL:	14.8G	28.24	12.5964	193M	44.65	.160480	3.17	30.78

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Direct Reads	14.7G	23.32	12.5274	0M	0.00	0M	0
Direct Reads (Data File)	14.7G	23.32	12.5274	0M	0.00	0M	0
Others	72M	3.89	.059868	33M	2.55	.027439	4683	1.77
Others (Control File)	72M	3.84	.059868	18M	0.96	.014967	4617	1.75
Others (Data File)	0M	0.05	0M	15M	1.59	.012472	66	3.29
LGWR	0M	0.00	0M	100M	37.32	.083150	0
LGWR (Log File)	0M	0.00	0M	100M	37.32	.083150	0
DBWR	0M	0.00	0M	56M	4.52	.046564	0
DBWR (Data File)	0M	0.00	0M	56M	4.52	.046564	0
Buffer Cache Reads	10M	1.03	.008315	0M	0.00	0M	1206	7.05
Buffer Cache Reads (Data File)	10M	1.03	.008315	0M	0.00	0M	1206	7.05
Direct Writes	0M	0.00	0M	3M	0.26	.002494	0
Direct Writes (Data File)	0M	0.00	0M	3M	0.26	.002494	0
TOTAL:	14.8G	28.24	12.5956	192M	44.64	.159649	5889	2.85

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
COMPANY01	24,783	21	0.34	32.84	5,903	5	2,565	3.48
SYSTEM	2,194	2	0.01	506.73	536	0	2,969	27.92
PUBLISH01	2,442	2	0.01	1.72	21	0	6	1.67
SYSAUX	8	0	8.75	1.00	989	1	2	0.00
UNDOTBS2	0	0	0.00	0.00	207	0	57	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
COMPANY01	+DATA/oanet/datafile/company01.278.771404483	870	1	0.84	76.29	152	0	205	4.83
COMPANY01	+DATA/oanet/datafile/company01.279.771404731	1,351	1	0.33	49.85	166	0	57	6.49
COMPANY01	+DATA/oanet/datafile/company01.280.771404979	1,024	1	0.38	65.29	185	0	123	3.66
COMPANY01	+DATA/oanet/datafile/company01.281.771405227	2,253	2	0.35	30.14	310	0	109	3.12
COMPANY01	+DATA/oanet/datafile/company01.282.771405475	2,247	2	0.18	30.63	342	0	174	3.22
COMPANY01	+DATA/oanet/datafile/company01.283.771405723	2,562	2	0.19	26.74	298	0	210	2.43
COMPANY01	+DATA/oanet/datafile/company01.284.771405971	1,191	1	0.40	22.09	706	1	45	3.56
COMPANY01	+DATA/oanet/datafile/company01.285.771406219	1,979	2	0.29	12.91	1,945	2	293	1.71
COMPANY01	+DATA/oanet/datafile/company01.286.771406469	725	1	0.65	38.37	244	0	45	4.44
COMPANY01	+DATA/oanet/datafile/company01.287.771406717	1,122	1	0.40	25.06	194	0	841	3.26
COMPANY01	+DATA/oanet/datafile/company01.288.771406967	2,846	2	0.20	10.61	180	0	86	3.37
COMPANY01	+DATA/oanet/datafile/company01.289.771407217	1,181	1	0.41	56.86	206	0	142	3.24
COMPANY01	+DATA/oanet/datafile/company01.290.771407465	1,184	1	0.50	56.74	268	0	75	2.80
COMPANY01	+DATA/oanet/datafile/company01.291.771407715	2,714	2	0.32	25.28	349	0	73	7.40
COMPANY01	+DATA/oanet/datafile/company01.292.771407963	1,534	1	0.50	43.84	358	0	87	7.01
PUBLISH01	+DATA/oanet/datafile/publish01.269.771400015	2,442	2	0.01	1.72	21	0	6	1.67
SYSAUX	+DATA/oanet/datafile/sysaux.257.771398519	8	0	8.75	1.00	989	1	2	0.00
SYSTEM	+DATA/oanet/datafile/system.256.771398519	2,194	2	0.01	506.73	536	0	2,969	27.92
UNDOTBS2	+DATA/oanet/datafile/undotbs2.264.771398729	0	0			207	0	57	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	763,560	100	60,376,898	1,237	7,210	0	0	5,646

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 9,448

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	5,558	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

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

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	0	1132	8793	31237	2073600	31237			0
E	0	1	1933	31475	116415	2073600	116415			0

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	640	0.10	76	2.88	47,393	1	82339.00
D	1,280	0.20	151	1.32	21,824	1	30389.00
D	1,920	0.30	227	1.09	17,908	1	22434.00
D	2,560	0.40	302	1.04	17,088	1	20767.00
D	3,200	0.50	378	1.02	16,837	1	20256.00
D	3,840	0.59	454	1.01	16,712	1	20004.00
D	4,480	0.69	529	1.01	16,621	1	19818.00
D	5,120	0.79	605	1.00	16,551	1	19676.00
D	5,760	0.89	680	1.00	16,508	1	19590.00
D	6,400	0.99	756	1.00	16,479	1	19529.00
D	6,464	1.00	764	1.00	16,477	1	19525.00
D	7,040	1.09	832	1.00	16,460	1	19490.00
D	7,680	1.19	907	1.00	16,441	1	19453.00
D	8,320	1.29	983	1.00	16,429	1	19429.00
D	8,960	1.39	1,058	1.00	16,422	1	19414.00
D	9,600	1.49	1,134	1.00	16,418	1	19406.00
D	10,240	1.58	1,210	1.00	16,415	1	19400.00
D	10,880	1.68	1,285	1.00	16,413	1	19396.00
D	11,520	1.78	1,361	1.00	16,412	1	19393.00
D	12,160	1.88	1,436	1.00	16,410	1	19390.00
D	12,800	1.98	1,512	0.85	14,028	1	14549.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	8,475	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	346,047	346,047
64K	128K	278	278
128K	256K	98	98
256K	512K	284	284
512K	1024K	8,430	8,430
1M	2M	1,130	1,130
2M	4M	10	10
4M	8M	10	10

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
936	0.13	4,438,409.73	257,886.56	95.00	57,600	6,337,570,504
1,872	0.25	4,438,409.73	183.84	100.00	0	5,989,805,136
3,744	0.50	4,438,409.73	183.84	100.00	0	5,989,805,136
5,616	0.75	4,438,409.73	183.84	100.00	0	5,989,805,136
7,488	1.00	4,438,409.73	183.84	100.00	0	5,989,805,136
8,986	1.20	4,438,409.73	0.00	100.00	0	5,989,557,052
10,483	1.40	4,438,409.73	0.00	100.00	0	5,989,557,052
11,981	1.60	4,438,409.73	0.00	100.00	0	5,989,557,052
13,478	1.80	4,438,409.73	0.00	100.00	0	5,989,557,052
14,976	2.00	4,438,409.73	0.00	100.00	0	5,989,557,052
22,464	3.00	4,438,409.73	0.00	100.00	0	5,989,557,052
29,952	4.00	4,438,409.73	0.00	100.00	0	5,989,557,052
44,928	6.00	4,438,409.73	0.00	100.00	0	5,989,557,052
59,904	8.00	4,438,409.73	0.00	100.00	0	5,989,557,052

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)
2,688	0.37	48	17,460	5,055,714	0.11	39,423,148	1178.96	188,065
3,456	0.47	815	34,833	7,119,849	0.16	37,359,013	1117.23	245,993
4,224	0.58	1,583	52,086	13,240,779	0.30	31,238,083	934.18	280,133
4,992	0.68	2,351	69,890	21,286,892	0.48	23,191,970	693.56	319,800
5,760	0.79	3,118	87,705	29,331,842	0.66	15,147,020	452.97	359,389
6,528	0.89	3,886	105,939	37,374,833	0.84	7,104,029	212.45	398,893
6,656	0.91	4,014	109,035	38,715,267	0.87	5,763,595	172.36	405,474
6,720	0.92	4,078	110,583	39,385,326	0.89	5,093,536	152.32	408,763
6,784	0.93	4,142	112,121	40,055,896	0.90	4,422,966	132.27	412,052
6,848	0.94	4,206	113,655	40,726,442	0.92	3,752,420	112.22	415,342
6,912	0.95	4,270	115,189	41,396,999	0.93	3,081,863	92.16	418,632
6,976	0.96	4,334	116,723	42,067,732	0.95	2,411,130	72.11	421,923
7,040	0.96	4,398	118,257	42,738,759	0.96	1,740,103	52.04	425,238
7,104	0.97	4,462	119,791	43,410,990	0.98	1,067,872	31.93	428,631
7,168	0.98	4,526	121,325	43,757,224	0.98	721,638	21.58	430,161
7,232	0.99	4,590	122,859	44,102,981	0.99	375,881	11.24	431,648
7,296	1.00	4,654	124,334	44,445,423	1.00	33,439	1.00	433,136
7,360	1.01	4,718	125,764	44,445,945	1.00	32,917	0.98	433,166
7,424	1.02	4,782	127,194	44,445,998	1.00	32,864	0.98	433,169
7,488	1.03	4,846	128,624	44,446,048	1.00	32,814	0.98	433,173
7,552	1.04	4,910	130,054	44,446,093	1.00	32,769	0.98	433,175
7,616	1.04	4,974	131,484	44,446,138	1.00	32,724	0.98	433,178
7,680	1.05	5,038	132,914	44,446,183	1.00	32,679	0.98	433,181
7,744	1.06	5,102	134,344	44,446,230	1.00	32,632	0.98	433,184
7,808	1.07	5,166	135,776	44,446,268	1.00	32,594	0.97	433,187
7,872	1.08	5,230	137,600	44,446,317	1.00	32,545	0.97	433,190
8,064	1.11	5,422	143,112	44,446,430	1.00	32,432	0.97	433,199
8,832	1.21	6,190	161,951	44,446,793	1.00	32,069	0.96	433,225
9,600	1.32	6,958	180,223	44,447,130	1.00	31,732	0.95	433,250
10,368	1.42	7,725	199,207	44,447,524	1.00	31,338	0.94	433,277
11,136	1.53	8,493	217,410	44,447,852	1.00	31,010	0.93	433,300
11,904	1.63	9,261	237,107	44,448,176	1.00	30,686	0.92	433,321
12,672	1.74	10,029	256,618	44,448,522	1.00	30,340	0.91	433,340
13,440	1.84	10,797	275,865	44,448,787	1.00	30,075	0.90	433,358
14,208	1.95	11,565	295,112	44,448,999	1.00	29,863	0.89	433,372
14,976	2.05	12,333	305,300	44,449,256	1.00	29,606	0.89	433,387

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
3,504	0.25	40,607,138	46,980,214
5,256	0.38	32,415,612	46,980,214
7,008	0.50	16,311,809	46,980,214
8,760	0.63	1,133,707	21,633,999
10,512	0.75	1,123,722	16,939,767
12,264	0.88	1,122,712	16,690,968
14,016	1.00	1,121,927	16,476,770
15,768	1.13	1,121,029	16,567,392
17,520	1.25	1,120,468	16,567,392
19,272	1.38	1,119,908	16,407,568
21,024	1.50	1,117,328	13,906,394
22,776	1.63	1,116,206	13,906,394
24,528	1.75	1,115,645	13,906,394
26,280	1.88	1,114,972	13,906,394
28,032	2.00	1,114,523	13,906,394

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	4,257	68	16
segment header	1,287	25	19
undo header	56	0	0
undo block	1	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
WF-AWR Flush	22	22	0	22	1	30.45
KO-Multiple Object Checkpoint (fast object checkpoint)	628	628	0	199	0	2.42
HW-Segment High Water Mark	259	254	5	88	0	4.63
PS-PX Process Reservation	1,534	1,544	0	409	0	0.61
TM-DML	28,692	28,692	0	3	0	36.33
CF-Controlfile Transaction	2,644	2,644	0	38	0	2.03
TX-Transaction (index contention)	9	9	0	7	0	6.71
PI-Remote PX Process Spawn Status	8	8	0	8	0	2.00
FB-Format Block	13	13	0	4	0	0.00
TA-Instance Undo	5	5	0	4	0	0.00
TD-KTF map table enqueue (KTF dump entries)	3	3	0	3	0	0.00
US-Undo Segment	4	4	0	3	0	0.00
CR-Reuse Block Range (block range reuse ckpt)	186	186	0	1	0	0.00
DR-Distributed Recovery	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
5	0.96	23,460	1,126	5	23.7/33.8	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
16-3月 08:58	564	14,063	523	5	24	0/0	0/0/0/0/0/0
16-3月 08:48	397	9,397	1,126	4	34	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
AQ deq log cmt cbk chunk latch	16	0.00		0
AQ deq log statistics latch	8	0.00		0
AQ dequeue txn counter latch	1,342	0.00		0
AQ ht cmt cbk chunk latch	16	0.00		0
ASM Keyed state latch	21,166	0.12	0.00	0
ASM allocation	92	0.00		0
ASM db client latch	1,082	0.00		0
ASM map operation freelist	2,769	0.00		0
ASM map operation hash table	175,627	0.01	0.00	0
ASM network background latch	550	0.00		0
ASM network state latch	261	0.00		0
AWR Alerted Metric Element list	14,096	0.00		0
Change Notification Hash table latch	401	0.00		0
Consistent RBA	22,417	0.00		0
DML lock allocation	984,948	0.00	0.00	0
Event Group Locks	21,440	0.00	0.00	0
FAL Queue	32	0.00		0
FIB s.o chain latch	8	0.00		0
FOB s.o list latch	16,667	0.01	0.00	0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
IPC other latch	1	0.00		0
IPC stats buffer allocation latch	1	0.00		0
In memory undo latch	1	0.00		0
JS Sh mem access	3	0.00		0
JS broadcast add buf latch	277	0.00		0
JS broadcast drop buf latch	277	0.00		0
JS broadcast load blnc latch	242	0.00		0
JS mem alloc latch	1	0.00		0
JS queue access latch	2	0.00		0
JS queue state obj latch	8,712	0.00		0
JS slv state obj latch	1	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KFK SGA Libload latch	88	0.00		0
KFMD SGA	12	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	15,561	0.08	0.00	289	0.00
KJCT flow control latch	147,346	0.03	0.00	0
KMG MMAN ready and startup request latch	401	0.00		0
KTF sga latch	10	0.00		389	0.00
KWQMN job cache list latch	374	0.00		0
KWQS pqsubs latch	16	0.00		0
KWQS pqueue ctx latch	44	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	137,897	0.19	0.00	0
MQL Tracking Latch	0			24	0.00
Memory Management Latch	1	0.00		401	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	829	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	42,403	0.00		0
OS process allocation	23,634	0.02	0.00	0
OS process: request allocation	21,165	0.12	0.00	0
PL/SQL warning settings	11,232	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	5,260	0.61	0.13	0
SGA IO buffer pool latch	24	0.00		24	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	41	0.00		397	0.00
SQL memory manager workarea list latch	99,698	0.00		0
Shared B-Tree	328	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	1	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	23,201	0.72	0.00	0
active service list	703,911	0.05	0.24	258,708	0.02
archive control	51	0.00		0
archive process latch	96	0.00		0
begin backup scn array	2,222	0.00		0
buffer pool	1	0.00		0
business card	313	0.00		0
cache buffer handles	77,216	0.03	0.00	0
cache buffers chains	105,707,157	0.17	0.03	196,420	0.02
cache buffers lru chain	33,609	0.01	0.33	198,102	0.09
call allocation	42,807	0.75	0.73	0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	21,207	0.08	0.00	0
channel operations parent latch	229,773	0.01	0.00	0
checkpoint queue latch	784,313	0.00	0.00	17,740	0.00
client/application info	76,038	0.00	0.00	0
compile environment latch	10,851	0.01	0.00	0
corrupted undo seg latch	387	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	139	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	139	0.00		0
dml lock allocation	139	0.00		0
done queue latch	1	0.00		0
dummy allocation	21,697	0.53	0.01	0
enqueue freelist latch	1	0.00		73,201	0.02
enqueue hash chains	284,133	0.13	0.00	2	0.00
error message lists	1,022	2.35	0.00	0
fifth spare latch	1	0.00		0
file cache latch	159	0.00		0
flashback copy	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc element	197,253	0.22	0.14	12,749	0.02
gcr global ctx	6	0.00		0
gcs commit scn state	1	0.00		0
gcs opaque info freelist	37,797	0.01	0.00	0
gcs partitioned table hash	1,913,142	0.00	0.00	1,093	0.00
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	1	0.00		0
gcs resource freelist	5,335	0.00		5,598	0.00
gcs resource hash	167,863	0.10	0.01	762	0.13
gcs resource scan list	1,931	0.00		0
gcs shadows freelist	8,193	0.00		12,564	0.00
ges DFS wait callback info	2	0.00		0
ges caches resource lists	102,862	0.01	0.00	14,837	0.01
ges deadlock list	56	0.00		0
ges domain table	394,670	0.00	0.00	0
ges enqueue table freelist	395,453	0.01	0.00	0
ges group table	397,172	0.00	0.00	0
ges process hash list	219,174	0.00		0
ges process parent latch	804,168	0.00	0.00	0
ges process table freelist	21,165	0.06	0.00	0
ges resource hash list	769,289	0.15	0.01	1,194	0.00
ges resource scan list	51	0.00		0
ges resource table freelist	1,339	0.00		0
ges timeout list	614	0.00		4	0.00
ges value block free list	1	0.00		0
global KZLD latch for mem in SGA	10,568	0.00		0
global tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	51	0.00		759,850	0.01
hash table modification latch	54	0.00		0
heartbeat check	1	0.00		340	0.00
heartbeat structure management	0			241	0.00
interrupt manipulation	2,316	4.79	0.00	0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	1	0.00		0
job_queue_processes parameter latch	263	0.00		0
k2q global data latch	802	0.00		0
k2q lock allocation	1	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kgnfs mount latch	1	0.00		0
kokc descriptor allocation latch	164	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	847	0.35	0.00	0
ksim membership request latch	0			882	0.00
kss move lock	21	0.00		0
ksuosstats global area	171	0.00		0
ksv allocation latch	177	0.00		0
ksv class latch	2,986	0.00		0
ksv instance latch	4	0.00		0
ksv msg queue latch	7	0.00		6	0.00
ksxp shared latch	21,164	0.00		0
ksxp so latch	21,165	0.11	0.00	0
ksz_so allocation latch	21,164	0.00	0.00	0
ktm global data	36	0.00		0
kwqbsn:qsga	69	0.00		0
lgwr LWN SCN	22,700	0.00	0.00	0
list of block allocation	21,453	0.14	0.00	0
loader state object freelist	15,148	0.01	0.00	0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	5	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	2	0.00		1	0.00
managed standby latch	32	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	3,095	0.00		0
messages	212,838	0.26	0.00	0
mostly latch-free SCN	22,878	0.59	0.00	0
msg queue latch	1	0.00		0
multiblock read objects	2,108	0.00		0
name-service memory objects	13,238	0.00		0
name-service namespace bucket	14,288	0.01	0.00	0
name-service pending queue	6,406	0.00		0
name-service request	16	0.00		0
name-service request queue	22,208	0.00		0
ncodef allocation latch	139	0.00		0
object queue header heap	182,820	0.00		1,593	0.00
object queue header operation	471,488	0.00	0.00	0
object stats modification	1	0.00		0
parallel query alloc buffer	4,901	2.59	0.01	0
parallel query stats	756	5.69	0.26	0
parallel txn reco latch	265	0.00		0
parameter list	96,039	0.08	0.00	0
parameter table management	45,710	0.25	0.02	0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	57,894	0.03	0.00	49,326	0.03
process allocation	26,848	0.12	0.06	10,578	0.11
process group creation	21,164	0.00		0
process queue	2,430	0.91	0.00	0
process queue reference	143,906	0.01	0.00	12,777	0.02
qmn state object latch	3	0.00		0
qmn task context latch	3	0.00		0
qmn task queue latch	199	0.00		0
query server freelists	1,893	0.11	0.00	0
query server process	198	0.00		0
queued dump request	4	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	67,894	0.09	0.00	86,194	0.10
redo copy	1	0.00		86,226	1.33
redo writing	90,803	0.12	0.00	0
resmgr group change latch	10,855	0.06	0.00	0
resmgr:active threads	21,713	0.00		0
resmgr:actses change group	10,852	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	21,695	0.73	0.00	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	97	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	3,567,083	0.05	0.00	48	0.00
rules engine aggregate statistics	4	0.00		0
rules engine rule set statistics	8	0.00		0
second Audit Vault latch	1	0.00		0
second spare latch	1	0.00		0
sequence cache	32,165	0.00		0
session allocation	59,713	0.03	0.00	38,043	0.01
session idle bit	5,447,359	0.01	0.00	0
session queue latch	1	0.00		0
session state list latch	21,670	0.29	0.00	0
session switching	10,715	0.11	0.00	0
session timer	497	0.00		0
shared pool	931,767	0.34	0.01	0
shared pool sim alloc	1	0.00		0
shared pool simulator	6,170	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	3,636,612	0.00	0.00	0
simulator lru latch	1	0.00		3,636,401	0.19
sort extent pool	166	0.00		0
space background state object latch	4	0.00		0
space background task latch	1,543	2.07	0.19	802	0.37
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	2	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	62	0.00		0
transaction allocation	248,244	0.00	0.00	0
undo global data	78,502	0.01	0.00	0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	105,707,157	184,456	5,412	180,635
shared pool	931,767	3,178	26	3,152
row cache objects	3,567,083	1,746	1	1,745
ges resource hash list	769,289	1,148	17	1,131
gc element	197,253	425	60	367
active service list	703,911	379	91	301
enqueue hash chains	284,133	374	1	373
call allocation	42,807	320	234	134
Lsod array latch	137,897	256	1	255
gcs resource hash	167,863	174	1	173
parallel query alloc buffer	4,901	127	1	126
dummy allocation	21,697	116	1	115
parameter table management	45,710	115	2	113
parallel query stats	756	43	11	34
Real-time plan statistics latch	5,260	32	4	28
process allocation	26,848	32	2	30
space background task latch	1,543	32	6	26
cache buffers lru chain	33,609	3	1	2

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
Lsod array latch	kfklsodtablCleanup	1	1
PC and Classifier lists for WLM	No latch	1	0
Real-time plan statistics latch	keswxAddNewPlanEntry	4	4
active service list	kswslogon: session logout	128	87
active service list	kswsite: service iterator	4	0
cache buffers chains	kcbgtcr: fast path (cr pin)	2,807	2,074
cache buffers chains	kcbgcur_2	1,328	285
cache buffers chains	kcbzwb	670	224
cache buffers chains	kcbgtcr: kslbegin excl	348	309
cache buffers chains	kcbgtcr_2	196	125
cache buffers chains	kcbrls: fast release	161	1,103
cache buffers chains	kcbrls_2	128	1,278
cache buffers chains	kcbgtcr: fast path	111	141
cache buffers chains	kcbrls_1	98	294
cache buffers chains	kcllkopesc	22	2
cache buffers chains	kclbla	18	1
cache buffers chains	kcbchg1: clear MS bit	10	25
cache buffers chains	kclwrt	10	0
cache buffers chains	kcbgcur_4	5	34
cache buffers chains	kcbchg1: mod cr pin	3	1
cache buffers chains	kcl_fairness	3	0
cache buffers chains	kcbzar_fpin_1	2	23
cache buffers chains	kcbzib: finish processing buffer	2	4
cache buffers chains	kclgrantlk	2	0
cache buffers chains	kclrls	2	1
cache buffers chains	kcbbxsv	1	3
cache buffers chains	kclcqchk	1	0
cache buffers chains	kclcsr_2	1	0
cache buffers lru chain	kcbzgb	1	1
call allocation	ksuxds	234	227
dummy allocation	ktcscnfy	1	1
enqueue hash chains	ksqgtl3	1	1
gc element	kclnfndnewm	93	2
gc element	kclbla	2	0
gc element	kclfwrite1	2	0
gc element	kclchkping	1	0
gc element	kclcqchk	1	0
gcs resource hash	kjbcrcomplete	1	0
ges resource hash list	kjrmas1: lookup master node	13	3
ges resource hash list	kjlrlr: remove lock from resource queue	3	3
ges resource hash list	kjakoca: search for resp by resname	1	0
parallel query alloc buffer	kxfpbalo	1	1
parallel query stats	kxfprst: KSLBEGIN:1	11	11
parameter table management	ksp_param_table_free	4	0
parameter table management	kspcpy	2	0
process allocation	ksufap: active procs	2	0
row cache objects	kqreqd: reget	1	0
shared pool	kghalo	14	7
shared pool	kghfre	12	17
space background task latch	ktsj_grab_task	5	6

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglhdgn2 106	526
Library Cache	kgllkdl1 85	344
Library Cache	kglpnal2 91	207
Library Cache	kgllkc1 57	182
Library Cache	kglhdgn1 62	135
Library Cache	kglpin1 4	105
Library Cache	kglpndl1 95	47
Library Cache	kglget2 2	45
Library Cache	kgllkal1 80	19
Library Cache	kglpnal1 90	14
Cursor Pin	kkslce [KKSCHLPIN2]	10
Library Cache	kglget1 1	2
Cursor Stat	kkocsStoreBindAwareStats [KKSSTALOC8]	1
Cursor Pin	kksfbc [KKSCHLFSP2]	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: 62,352,253
Captured Segments account for 96.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
COMPANY	COMPANY01	FRAMEDEPARTMENT	TABLE	24,930,512	39.98
COMPANY	COMPANY01	PK_FRAMEWORK	INDEX	5,865,552	9.41
COMPANY	COMPANY01	FRAMEWORK	TABLE	4,230,096	6.78
COMPANY	COMPANY01	PK_RIGHT_DEF	INDEX	3,644,288	5.84
COMPANY	COMPANY01	PK_BASE_USER	INDEX	1,717,248	2.75

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.03	Soft Parse %:	98.72
Execute to Parse %:	67.11	Latch Hit %:	99.85
Parse CPU to Parse Elapsd %:	97.14	% Non-Parse CPU:	96.27

Buffer access - local cache %:	99.96
Buffer access - remote cache %:	0.04
Buffer access - disk %:	0.00

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	2.1
Avg global cache current block receive time (ms):	5.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 %:	2.3
Avg global cache cr block flush time (ms):	12.9
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	20.4
Avg global cache current block flush time (ms):	11.6

Avg message sent queue time (ms):	0.1
Avg message sent queue time on ksxp (ms):	3.2
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.1
Avg GES message process time (ms):	0.0
% of direct sent messages:	72.58
% of indirect sent messages:	26.81
% of flow controlled messages:	0.61

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	AUD$	TABLE	1,111,758	57.61
COMPANY	COMPANY01	STEP_DEF	TABLE	785,060	40.68
COMPANY	COMPANY01	SYS_LOB0000077229C00006$$	LOB	11,962	0.62
STPUBLISH	PUBLISH01	SYS_LOB0000077160C00006$$	LOB	3,036	0.16
COMPANY	COMPANY01	DEAL_INFO_COMIDX02	INDEX	715	0.04

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_SYSAUTH1	INDEX	21,140	94.46
COMPANY	COMPANY01	PK_BASE_USER	INDEX	456	2.04
COMPANY	COMPANY01	FLOW_INST_COMIDX02	INDEX	266	1.19
COMPANY	COMPANY01	FLOW_INST_COMIDX01	INDEX	10	0.04
COMPANY	COMPANY01	STEP_INST_COMIDX1	INDEX	9	0.04

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
DBWIZARD_UNITE	COMPANY01	PK_LOG_RECORD	INDEX	5	62.50
COMPANY	COMPANY01	DEAL_INFO_COMIDX02	INDEX	1	12.50
COMPANY	COMPANY01	DEAL_INFO_STEP_INCO	INDEX	1	12.50
COMPANY	COMPANY01	IX_DEAL_INFO	INDEX	1	12.50

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	22	9.09	0	1
dc_global_oids	1,537	0.00	0	74
dc_histogram_data	437,799	0.01	0	5,149
dc_histogram_defs	183,704	0.02	0	6,971
dc_object_grants	49	0.00	0	10
dc_objects	114,798	0.01	0	2,560
dc_profiles	10,587	0.00	0	2
dc_rollback_segments	2,790	0.00	0	55
dc_segments	41,408	0.00	4	1,723
dc_sequences	4	50.00	4	4
dc_tablespaces	109,535	0.00	0	11
dc_users	756,770	0.00	0	127
global database name	11,826	0.00	0	1
outstanding_alerts	18	88.89	4	9
sch_lj_oids	1	0.00	0	14

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	21,136	0.00	0		0	0
BODY	16	0.00	2,575	0.00	0	0
DBLINK	21,145	0.00	0		0	0
EDITION	10,577	0.00	21,145	0.00	0	0
INDEX	1	0.00	1	0.00	0	0
QUEUE	2,936	0.00	3,490	0.00	0	0
RULESET	0		4	0.00	0	0
SCHEMA	10,568	0.00	0		0	0
SQL AREA	135,803	0.50	506,647	0.87	849	8
SQL AREA BUILD	1,738	93.56	0		0	0
SQL AREA STATS	1,710	76.08	1,710	76.08	0	0
TABLE/PROCEDURE	18,510	0.00	54,887	0.04	18	0
TRANSFORMATION	121	0.00	121	0.00	0	0
TRIGGER	17	0.00	356	0.00	0	0

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	6,464.00	6,464.00	6,464.00	6,848.00	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	7,488.00	7,488.00	7,488.00	7,488.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	14,016.00	14,016.00	14,016.00	14,016.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	64.00	64.00	64.00	64.00	STA/
large pool	64.00	64.00	64.00	64.00	STA/
shared pool	7,296.00	7,296.00	6,912.00	7,296.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	1,380.52		4.60	5.96	55	144	300	300
B	Freeable	251.19	0.00	0.98	1.36	21		257	257
B	PL/SQL	53.35	4.37	0.18	1.97	34	34	297	297
B	SQL	15.23	2.62	0.06	0.07	0	145	267	261
E	Other	1,434.77		4.54	5.83	55	144	316	316
E	Freeable	259.19	0.00	1.00	1.36	21		259	259
E	PL/SQL	53.50	4.47	0.17	1.92	34	34	314	305
E	SQL	15.73	2.52	0.06	0.07	0	145	283	266

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	6,777,995,264
Fixed Size	2,265,256
Redo Buffers	31,272,960
Variable Size	15,636,369,240

Pool	Name	Begin MB	End MB	% Diff
java	free memory	64.00	64.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	55.81	55.81	0.00
shared	KGLH0	1,302.16	1,300.00	-0.17
shared	KGLHD	199.98	199.61	-0.18
shared	SQLA	3,948.60	3,942.99	-0.14
shared	free memory	936.85	943.57	0.72
shared	gcs resources	179.22	179.22	0.00
shared	gcs shadows	104.55	104.55	0.00
	buffer_cache	6,464.00	6,464.00	0.00
	fixed_sga	2.16	2.16	0.00
	log_buffer	29.82	29.82	0.00

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

Parameter Name	Begin value	End value (if different)
audit_file_dest	D:\APP\DATABASE\ADMIN\OANET\ADUMP
audit_trail	DB
cluster_database	TRUE
compatible	11.2.0.0.0
control_files	+DATA/oanet/controlfile/current.260.771398611, +FLASHBACK/oanet/controlfile/current.256.771398611
db_block_size	8192
db_create_file_dest	+DATA
db_domain
db_file_multiblock_read_count	512
db_name	oanet
db_recovery_file_dest	+FLASHBACK
db_recovery_file_dest_size	644245094400
diagnostic_dest	D:\APP\DATABASE
dispatchers	(PROTOCOL=TCP) (SERVICE=oanetXDB)
instance_number	2
local_listener	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.0.126)(PORT=1521))))
log_archive_dest_1	location=USE_DB_RECOVERY_FILE_DEST
log_archive_dest_2	location=d:\archive
memory_target	22548578304
nls_language	SIMPLIFIED CHINESE
nls_territory	CHINA
open_cursors	1000
processes	800
remote_listener	gioracoa:1521, LISTENERS_OANET
remote_login_passwordfile	EXCLUSIVE
session_cached_cursors	200
sessions	1232
spfile	+DATA/oanet/spfileoanet.ora
thread	2
undo_tablespace	UNDOTBS2

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	22,513	18.72	10.01
acks for commit broadcast(logical)	23,091	19.20	10.26
broadcast msgs on commit(actual)	21,547	17.92	9.58
broadcast msgs on commit(logical)	22,404	18.63	9.96
broadcast msgs on commit(wasted)	632	0.53	0.28
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	10,868	9.04	4.83
gcs ast xid	8	0.01	0.00
gcs blocked converts	13,828	11.50	6.15
gcs blocked cr converts	10,022	8.33	4.45
gcs compatible basts	11	0.01	0.00
gcs compatible cr basts (global)	1,156	0.96	0.51
gcs compatible cr basts (local)	6,057	5.04	2.69
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	1,645	1.37	0.73
gcs dbwr write request msgs	1,256	1.04	0.56
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 force cr block only	44	0.04	0.02
gcs force cr grant	64	0.05	0.03
gcs force cr no current	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	507	0.42	0.23
gcs immediate (null) converts	983	0.82	0.44
gcs immediate cr (compatible) converts	765	0.64	0.34
gcs immediate cr (null) converts	5,281	4.39	2.35
gcs indirect ast	1,931	1.61	0.86
gcs indirect bidless ast	265	0.22	0.12
gcs indirect fg ast	1,666	1.39	0.74
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	579	0.48	0.26
gcs msgs process time(ms)	11,440	9.51	5.08
gcs msgs received	103,783	86.30	46.13
gcs new served by master	820	0.68	0.36
gcs out-of-order msgs	4	0.00	0.00
gcs pings refused	239	0.20	0.11
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	138	0.11	0.06
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	0	0.00	0.00
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	1,744	1.45	0.78
gcs side channel msgs logical	24,477	20.35	10.88
gcs stale cr	0	0.00	0.00
gcs undo cr	35	0.03	0.02
gcs write notification msgs	136	0.11	0.06
gcs writes refused	67	0.06	0.03
ges msgs process time(ms)	90	0.07	0.04
ges msgs received	3,728	3.10	1.66
global posts dropped	0	0.00	0.00
global posts queue time	10	0.01	0.00
global posts queued	4	0.00	0.00
global posts requested	4	0.00	0.00
global posts sent	4	0.00	0.00
implicit batch messages received	1,484	1.23	0.66
implicit batch messages sent	2,087	1.74	0.93
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	415	0.35	0.18
messages queue sent actual	17,001	14.14	7.56
messages queue sent logical	5,249	4.36	2.33
messages received actual	95,823	79.68	42.59
messages received logical	107,511	89.40	47.78
messages sent directly	49,760	41.38	22.12
messages sent indirectly	18,384	15.29	8.17
messages sent not implicit batched	0	0.00	0.00
messages sent pbatched	36,375	30.25	16.17
msgs causing lmd to send msgs	1,382	1.15	0.61
msgs causing lms(s) to send msgs	8,046	6.69	3.58
msgs received queue time (ms)	2,631	2.19	1.17
msgs received queued	107,511	89.40	47.78
msgs sent queue time (ms)	3,070	2.55	1.36
msgs sent queue time on ksxp (ms)	295,046	245.33	131.13
msgs sent queued	20,759	17.26	9.23
msgs sent queued on ksxp	91,224	75.85	40.54
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	29,836	24.81	13.26
process batch messages sent	32,068	26.66	14.25

Statistic	Total
CR Block Requests	9,486
CURRENT Block Requests	3,391
Data Block Requests	9,486
Undo Block Requests	35
TX Block Requests	947
Current Results	12,650
Private results	2
Zero Results	216
Disk Read Results	0
Fail Results	0
Fairness Down Converts	7,956
Fairness Clears	252
Free GC Elements	0
Flushes	292
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	38
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	725	54.21	45.66	0.14	0.00	0.00
Flushes	4,255	3.29	56.90	38.92	0.89	0.00
Writes	2,113	0.00	35.21	61.57	2.13	1.09

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
1	data block	4,687	96.33	3.31	0.36	13,247	65.67	34.21	0.12
1	Others	2,410	95.60	4.27	0.12	1,221	98.77	1.23	0.00
1	undo header	1,025	99.12	0.49	0.39	9	100.00	0.00	0.00
1	undo block	10	100.00	0.00	0.00	0

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
1	data block	2.36	1.66	22.57	3.74	7.87	2.82	17.59	2.96
1	others	3.61	3.06	15.94	5.01	2.34	2.24	10.17
1	undo header	1.41	1.31	21.36	1.68	1.02	1.02
1	undo block	1.13	1.13

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

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
1	data block	0	4,515	100.00	0.00	8,699	100.00	0.00
1	others	0	2,304	100.00	0.00	1,206	100.00	0.00
1	undo header	0	1,016	100.00	0.00	9	100.00	0.00
1	undo block	0	10	100.00	0.00	0

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.16	0.10
Parallel Query	0.07	0.01
DB Locks	0.02	0.02
DB Streams	0.00	0.00
Other	0.01	0.00