WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ESS34 3385539608 ess342 2 23-Sep-15 00:09 11.2.0.4.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ESS34	3385539608	ess342	2	23-Sep-15 00:09	11.2.0.4.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

essdb4 AIX-Based Systems (64-bit) 80 20 113.00

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
essdb4	AIX-Based Systems (64-bit)	80	20		113.00

Snap Id Snap Time Sessions Cursors/Session Instances

Begin Snap: 36544 04-Mar-16 23:30:15 465 7.2 2

End Snap: 36545 05-Mar-16 00:00:20 438 6.9 2

Elapsed: 30.09 (mins)

DB Time: 98.08 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session	Instances
Begin Snap:	36544	04-Mar-16 23:30:15	465	7.2	2
End Snap:	36545	05-Mar-16 00:00:20	438	6.9	2
Elapsed:		30.09 (mins)
DB Time:		98.08 (mins)

Report Summary

Load Profile

Per
DB Time(s):
DB CPU(s):
Redo size (bytes):
Logical read (blocks):
Block changes:
Physical read (blocks):
Physical write (blocks):
Read IO requests:
Write IO requests:
Read IO (MB):
Write IO (MB):
Global Cache blocks received: Global Cache blocks served:
User calls:
Parses (SQL):
Hard parses (SQL):
SQL Work Area (MB):
Logons:
Executes (SQL):
Rollbacks:
Transactions:
profile"> SecondPer TransactionPer ExecPer Call 3.3 0.6 0.04 0.01 0.2 0.0 0.00 0.00 70,344.3 13,727.8 21,809.4 4,256.2 823.0 160.6 1,573.5 307.1 10.2 2.0 255.7 49.9 3.8 0.7 12.3 2.4 0.1 0.0 class="awrnc"> 71.3 13.9 0.3 0.1 265.0 51.7 33.6 6.6 0.4 0.1 1.2 0.2 0.0 0.0 86.1 16.8 4.6 0.9 5.1

Per
DB Time(s):
DB CPU(s):
Redo size (bytes):
Logical read (blocks):
Block changes:
Physical read (blocks):
Physical write (blocks):
Read IO requests:
Write IO requests:
Read IO (MB):
Write IO (MB):
Global Cache blocks received:		Global Cache blocks served:
User calls:
Parses (SQL):
Hard parses (SQL):
SQL Work Area (MB):
Logons:
Executes (SQL):
Rollbacks:
Transactions:

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 98.74 Soft Parse %: 98.71

Execute to Parse %: 60.91 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 57.31 % Non-Parse CPU: 99.36

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		306.5		5.2
db file scattered read	31,137	193.5	6	3.3	User I/O
db file sequential read	33,783	152.3	5	2.6	User I/O
db file parallel read	4,080	79.6	20	1.4	User I/O
gc cr multi block request	36,428	43.3	1	.7	Cluster
gc current block 2-way	23,093	14.6	1	.2	Cluster
gc cr grant 2-way	14,124	8.3	1	.1	Cluster
gc current grant 2-way	7,208	4.3	1	.1	Cluster
enq: IV - contention	1,103	1.5	1	.0	Other
row cache lock	2,804	1.2	0	.0	Concurrency

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
User I/O	70,948	432	6	7.3	0.2
DB CPU		306		5.2	0.2
Cluster	83,610	73	1	1.2	0.0
System I/O	25,414	12	0	.2	0.0
Other	89,741	6	0	.1	0.0
Concurrency	22,518	3	0	.0	0.0
Network	438,452	1	0	.0	0.0
Commit	326	0	1	.0	0.0
Application	375	0	0	.0	0.0
Configuration	3	0	1	.0	0.0

Host CPU

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

80 20 0.52 0.71 0.5 0.3 0.3 99.2

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
80	20		0.52	0.71	0.5	0.3	0.3	99.2

Instance CPU

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

0.3 33.8 0.0

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

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 269.0 260.5 8.5

Database Requests: 259.5 255.7 3.8

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 2.2 0.0 2.2

Total (MB): 12.6 12.4 0.2

Database (MB): 12.4 12.3 0.1

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 0.1 0.0 0.1

Database (blocks): 1,583.6 1,573.5 10.2

Via Buffer Cache (blocks): 1,582.8 1,573.4 9.4

Direct (blocks): 0.9 0.1 0.8

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	269.0	260.5	8.5
Database Requests:	259.5	255.7	3.8
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	2.2	0.0	2.2
Total (MB):	12.6	12.4	0.2
Database (MB):	12.4	12.3	0.1
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	0.1	0.0	0.1
Database (blocks):	1,583.6	1,573.5	10.2
Via Buffer Cache (blocks):	1,582.8	1,573.4	9.4
Direct (blocks):	0.9	0.1	0.8

Memory Statistics

Begin End

Host Mem (MB): 115,712.0 115,712.0

SGA use (MB): 40,960.0 40,960.0

PGA use (MB): 1,667.5 1,488.9

% Host Mem used for SGA+PGA: 36.84 36.68

	Begin	End
Host Mem (MB):	115,712.0	115,712.0
SGA use (MB):	40,960.0	40,960.0
PGA use (MB):	1,667.5	1,488.9
% Host Mem used for SGA+PGA:	36.84	36.68

Cache Sizes

Begin End

Buffer Cache: 32,000M 32,000M Std Block Size: 8K

Shared Pool Size: 6,200M 6,198M Log Buffer: 72,684K

	Begin	End
Buffer Cache:	32,000M	32,000M	Std Block Size:	8K
Shared Pool Size:	6,200M	6,198M	Log Buffer:	72,684K

Shared Pool Statistics

Begin End

Memory Usage %: 69.04 69.09

% SQL with executions>1: 86.07 90.43

% Memory for SQL w/exec>1: 16.22 16.35

	Begin	End
Memory Usage %:	69.04	69.09
% SQL with executions>1:	86.07	90.43
% Memory for SQL w/exec>1:	16.22	16.35

Main Report

RAC Statistics

Wait Events Statistics

Time Model Statistics

Total time in database user-calls (DB Time): 5884.9s
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	924.87	15.72
DB CPU	306.46	5.21
PL/SQL execution elapsed time	17.16	0.29
parse time elapsed	6.86	0.12
hard parse elapsed time	4.93	0.08
hard parse (sharing criteria) elapsed time	0.57	0.01
connection management call elapsed time	0.14	0.00
hard parse (bind mismatch) elapsed time	0.12	0.00
PL/SQL compilation elapsed time	0.10	0.00
repeated bind elapsed time	0.04	0.00
sequence load elapsed time	0.02	0.00
DB time	5,884.92
background elapsed time	114.17
background cpu time	73.38

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	1,316
AVG_IDLE_TIME	179,208
AVG_IOWAIT_TIME	549
AVG_SYS_TIME	492
AVG_USER_TIME	755
BUSY_TIME	112,397
IDLE_TIME	14,343,767
IOWAIT_TIME	49,176
SYS_TIME	45,641
USER_TIME	66,756
LOAD	1	1
OS_CPU_WAIT_TIME	121,500
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	121,332,826,112
NUM_CPUS	80
NUM_CPU_CORES	20
NUM_LCPUS	80
NUM_VCPUS	20
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_DEFAULT	16,384
TCP_RECEIVE_SIZE_MAX	9,223,372,036,854,775,807
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	9,223,372,036,854,775,807
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
04-Mar 23:30:15	0.52
05-Mar 00:00:20	0.71	0.78	0.46	0.32	99.22	0.34

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 13.8% of Total DB time 5,884.92 (s)
Total FG Wait Time: 503.03 (s) DB CPU time: 306.46 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
User I/O	69,881	0	426	6	7.23
DB CPU			306		5.21
Cluster	81,578	0	71	1	1.21
Other	2,504	6	3	1	0.06
Concurrency	3,151	0	1	0	0.02
System I/O	641	0	1	1	0.01
Commit	324	0	0	1	0.01
Network	434,355	0	0	0	0.01
Application	374	0	0	0	0.00
Configuration	0		0		0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
db file scattered read	31,137	0	193	6	3.37	3.29
db file sequential read	33,783	0	152	5	3.65	2.59
db file parallel read	4,080	0	80	20	0.44	1.35
gc cr multi block request	36,428	0	43	1	3.94	0.74
gc current block 2-way	23,093	0	15	1	2.50	0.25
gc cr grant 2-way	14,124	0	8	1	1.53	0.14
gc current grant 2-way	7,208	0	4	1	0.78	0.07
enq: IV - contention	1,103	0	2	1	0.12	0.03
row cache lock	2,804	0	1	0	0.30	0.02
reliable message	1,078	0	1	1	0.12	0.02
name-service call wait	6	0	1	101	0.00	0.01
control file sequential read	641	0	1	1	0.07	0.01
log file sync	324	0	0	1	0.04	0.01
SQL*Net message to client	434,284	0	0	0	46.94	0.01
gc current grant busy	347	0	0	1	0.04	0.00
gc cr block 2-way	278	0	0	1	0.03	0.00
direct path read	180	0	0	1	0.02	0.00
read by other session	13	0	0	6	0.00	0.00
gc buffer busy acquire	8	0	0	8	0.00	0.00
library cache pin	79	0	0	1	0.01	0.00
library cache lock	52	10	0	1	0.01	0.00
enq: ZH - compression analysis	52	100	0	1	0.01	0.00
direct path write temp	26	0	0	1	0.00	0.00
gc current block congested	31	0	0	1	0.00	0.00
SQL*Net break/reset to client	360	0	0	0	0.04	0.00
IPC send completion sync	24	0	0	1	0.00	0.00
enq: TO - contention	26	100	0	1	0.00	0.00
gc cr disk read	21	0	0	1	0.00	0.00
gc cr grant congested	21	0	0	1	0.00	0.00
gc current grant congested	16	0	0	1	0.00	0.00
library cache: mutex X	121	0	0	0	0.01	0.00
enq: TM - contention	14	0	0	1	0.00	0.00
enq: PS - contention	9	33	0	1	0.00	0.00
cursor: pin S wait on X	1	0	0	4	0.00	0.00
Disk file operations I/O	662	0	0	0	0.07	0.00
cursor: pin S	90	0	0	0	0.01	0.00
gc cr block busy	1	0	0	3	0.00	0.00
PX Deq: Slave Session Stats	9	0	0	0	0.00	0.00
SQL*Net more data to client	45	0	0	0	0.00	0.00
enq: JS - job run lock - synchronize	3	100	0	1	0.00	0.00
gc current block busy	1	0	0	2	0.00	0.00
gc current multi block request	1	0	0	1	0.00	0.00
SQL*Net message from client	434,313	0	672,717	1549	46.95
jobq slave wait	966	100	483	500	0.10
PX Deq: Execution Msg	36	0	0	1	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
db file sequential read	864	0	6	7	0.09	5.42
control file sequential read	7,939	0	3	0	0.86	2.51
db file parallel write	5,824	0	3	0	0.63	2.46
log file parallel write	3,931	0	2	1	0.42	2.18
control file parallel write	2,225	0	2	1	0.24	1.87
os thread startup	28	0	1	40	0.00	0.97
ges inquiry response	1,244	0	1	1	0.13	0.87
db file async I/O submit	4,853	0	1	0	0.52	0.59
gc current block 2-way	827	0	1	1	0.09	0.47
LNS wait on SENDREQ	3,962	0	0	0	0.43	0.35
enq: US - contention	827	0	0	0	0.09	0.34
DFS lock handle	75	88	0	5	0.01	0.33
gc current grant 2-way	455	0	0	1	0.05	0.26
reliable message	73	0	0	4	0.01	0.24
gc cr multi block request	231	0	0	1	0.02	0.20
name-service call wait	3	0	0	62	0.00	0.16
gc cr block 2-way	256	0	0	1	0.03	0.15
row cache process	30,269	0	0	0	3.27	0.14
CGS wait for IPC msg	16,105	100	0	0	1.74	0.12
row cache lock	253	0	0	0	0.03	0.11
ksxr poll remote instances	15,010	100	0	0	1.62	0.10
gc current grant busy	125	0	0	1	0.01	0.07
db file parallel read	8	0	0	10	0.00	0.07
gc cr grant 2-way	118	0	0	1	0.01	0.06
libcache interrupt action by LCK	19,058	0	0	0	2.06	0.05
row cache cleanup	22,491	0	0	0	2.43	0.05
enq: CF - contention	56	45	0	1	0.01	0.04
CSS initialization	1	0	0	50	0.00	0.04
gc current block busy	15	0	0	3	0.00	0.04
gcs log flush sync	27	0	0	1	0.00	0.01
enq: IV - contention	21	0	0	1	0.00	0.01
enq: PS - contention	9	33	0	1	0.00	0.01
enq: WF - contention	19	0	0	1	0.00	0.01
library cache lock	13	8	0	1	0.00	0.01
gc cr block busy	2	0	0	5	0.00	0.01
library cache pin	12	0	0	1	0.00	0.01
CSS operation: action	5	0	0	1	0.00	0.01
PX Deq: reap credit	783	100	0	0	0.08	0.00
enq: TK - Auto Task Serialization	3	100	0	2	0.00	0.00
enq: FB - contention	6	0	0	1	0.00	0.00
enq: TA - contention	6	0	0	1	0.00	0.00
enq: TC - contention2	7	0	0	1	0.00	0.00
enq: TD - KTF dump entries	5	0	0	1	0.00	0.00
enq: PI - contention	3	100	0	1	0.00	0.00
LGWR wait for redo copy	73	0	0	0	0.01	0.00
enq: TX - index contention	1	0	0	3	0.00	0.00
IPC send completion sync	6	0	0	0	0.00	0.00
latch: ges resource hash list	51	0	0	0	0.01	0.00
PX Deq: Signal ACK RSG	9	0	0	0	0.00	0.00
KJC: Wait for msg sends to complete	7	0	0	0	0.00	0.00
enq: TM - contention	1	0	0	2	0.00	0.00
enq: HW - contention	3	0	0	1	0.00	0.00
PX Deq: Slave Session Stats	9	0	0	0	0.00	0.00
log file sync	2	0	0	1	0.00	0.00
PX Deq: Signal ACK EXT	9	0	0	0	0.00	0.00
rdbms ipc message	60,965	57	55,893	917	6.59
gcs remote message	278,744	61	7,194	26	30.13
DIAG idle wait	31,849	66	3,584	113	3.44
Space Manager: slave idle wait	645	98	3,188	4943	0.07
smon timer	9	67	1,890	209981	0.00
Streams AQ: qmn coordinator idle wait	126	50	1,810	14369	0.01
Streams AQ: qmn slave idle wait	63	0	1,810	28737	0.01
pmon timer	602	100	1,806	3000	0.07
GCR sleep	361	100	1,805	5000	0.04
wait for unread message on broadcast channel	4,611	27	1,805	391	0.50
LNS ASYNC end of log	4,801	18	1,804	376	0.52
ges remote message	23,437	66	1,804	77	2.53
PING	728	20	1,794	2465	0.08
PX Idle Wait	12	0	1,690	140830	0.00
SQL*Net message from client	170	0	0	1	0.02
PX Deq: Join ACK	9	0	0	4	0.00
PX Deq: Parse Reply	9	0	0	2	0.00
KSV master wait	1,082	100	0	0	0.12
PX Deq: Execute Reply	9	0	0	1	0.00
class slave wait	8	0	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	128	100	0	0	0.01

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
CGS wait for IPC msg	16.1K	100.0
CSS initialization	1							100.0
CSS operation: action	5	40.0	60.0
DFS lock handle	75	85.3	10.7					4.0
Disk file operations I/O	860	100.0
IPC send completion sync	30	100.0
KJC: Wait for msg sends to complete	20	100.0
LGWR wait for redo copy	73	100.0
LNS wait on SENDREQ	3962	100.0	.0
PX Deq: Signal ACK EXT	9	100.0
PX Deq: Signal ACK RSG	9	100.0
PX Deq: Slave Session Stats	18	100.0
PX Deq: reap credit	843	100.0
SQL*Net break/reset to client	360	100.0
SQL*Net message to client	434.2K	100.0
SQL*Net more data from client	26	100.0
SQL*Net more data to client	45	100.0
control file parallel write	2224	85.8	7.4	4.0	1.4	.6	.4	.2
control file sequential read	8580	97.9	.9	.2	.4	.4	.0	.0
cursor: pin S	90	100.0
cursor: pin S wait on X	1				100.0
db file async I/O submit	4845	99.4	.4	.1	.2
db file parallel read	4088	.8	.8	1.1	18.4	33.9	30.5	14.5
db file parallel write	5806	94.0	4.5	.9	.2	.2	.1	.0
db file scattered read	30.5K	15.5	27.9	12.3	12.3	24.8	6.1	1.0
db file sequential read	33.3K	42.3	4.6	4.8	26.8	19.0	2.1	.4
direct path read	180	87.8	1.7	1.1	5.6	3.9
direct path write	1	100.0
direct path write temp	26	61.5	38.5
enq: AF - task serialization	1	100.0
enq: CF - contention	56	83.9	14.3	1.8
enq: CR - block range reuse ckpt	1	100.0
enq: DR - contention	1	100.0
enq: FB - contention	3	100.0
enq: HW - contention	2	100.0
enq: IV - contention	1124	40.1	43.5	16.2	.1	.1
enq: JS - job run lock - synchronize	3	66.7	33.3
enq: MW - contention	1	100.0
enq: PI - contention	3	66.7	33.3
enq: PS - contention	18	44.4	55.6
enq: TA - contention	6	100.0
enq: TC - contention2	7	100.0
enq: TD - KTF dump entries	4	75.0	25.0
enq: TK - Auto Task Serialization	3	33.3	33.3	33.3
enq: TM - contention	15	93.3		6.7
enq: TO - contention	26	100.0
enq: TX - index contention	1			100.0
enq: US - contention	827	99.6	.2		.1
enq: WF - contention	19	94.7	5.3
enq: ZH - compression analysis	52	100.0
gc buffer busy acquire	8	12.5		12.5	12.5	62.5
gc buffer busy release	1	100.0
gc cr block 2-way	526	88.4	11.6
gc cr block busy	4		25.0	50.0	25.0
gc cr block congested	1	100.0
gc cr disk read	21	100.0
gc cr grant 2-way	13.6K	98.1	1.4	.3	.2
gc cr grant congested	20	100.0
gc cr multi block request	36.4K	42.7	52.3	4.0	1.0	.0
gc current block 2-way	24K	98.2	1.6	.1	.1	.0
gc current block busy	20		40.0	55.0	5.0
gc current block congested	34	91.2	5.9	2.9
gc current grant 2-way	7670	98.1	1.6	.3	.1
gc current grant busy	468	95.5	3.8	.2	.4
gc current grant congested	16	93.8	6.3
gc current multi block request	4	75.0	25.0
gcs log flush sync	37	91.9	5.4	2.7
ges inquiry response	1244	85.0	14.5	.4
ksxr poll remote instances	15K	100.0
latch free	8	100.0
latch: cache buffers chains	4	100.0
latch: cache buffers lru chain	1	100.0
latch: gc element	118	100.0
latch: gcs resource hash	1	100.0
latch: ges resource hash list	56	100.0
libcache interrupt action by LCK	19K	100.0
library cache lock	64	75.0	25.0
library cache pin	90	94.4	5.6
library cache: mutex X	124	99.2				.8
log file parallel write	3933	89.6	5.4	3.8	.7	.3	.1	.1
log file sync	325	75.4	17.8	3.4	1.5	1.2	.3	.3
name-service call wait	9					11.1		88.9
os thread startup	28						60.7	39.3
read by other session	13	7.7	7.7	38.5	23.1	15.4	7.7
reliable message	1149	49.6	47.1	1.1	.8	1.4
row cache cleanup	22.4K	100.0
row cache lock	3040	88.6	11.1	.3	.0
row cache process	30.2K	100.0
DIAG idle wait	31.8K	29.7	1.1	.1	1.9	3.5	4.4	59.3
GCR sleep	361								100.0
KSV master wait	1082	100.0
LNS ASYNC end of log	4803	9.0	1.8	7.4	5.9	6.1	4.7	65.1
PING	733	80.4		.1					19.5
PX Deq: Execute Reply	9	100.0
PX Deq: Execution Msg	36	72.2	19.4	5.6	2.8
PX Deq: Join ACK	9	33.3			44.4	22.2
PX Deq: Parse Reply	9		66.7	33.3
PX Idle Wait	9	33.3						33.3	33.3
SQL*Net message from client	434.2K	79.6	1.7	3.8	7.1	.8	.7	3.3	3.1
Space Manager: slave idle wait	645					.5		.2	99.4
Streams AQ: RAC qmn coordinator idle wait	128	100.0
Streams AQ: qmn coordinator idle wait	126	50.0							50.0
Streams AQ: qmn slave idle wait	63								100.0
class slave wait	8	100.0
gcs remote message	278.3K	10.7	5.9	1.6	5.8	7.4	23.8	44.9
ges remote message	23.4K	19.5	3.1	1.3	1.1	1.4	1.8	71.9
jobq slave wait	981							100.0
pmon timer	602								100.0
rdbms ipc message	60.9K	26.3	2.7	1.8	1.2	1.1	.8	45.1	21.1
smon timer	8							12.5	87.5
wait for unread message on broadcast channel	4596	13.4	19.0	7.9	3.7	1.0	.9	54.1

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
		% of Total Waits
CSS initialization	1		100.0
DFS lock handle	3	96.0		2.7	1.3
control file parallel write	5	99.8	.2	.0
control file sequential read	3	100.0	.0	.0
db file parallel read	593	85.5	12.7	1.8	.0
db file parallel write	2	100.0	.0	.0
db file scattered read	293	99.0	.7	.3	.0
db file sequential read	127	99.6	.3	.1
log file parallel write	2	99.9	.0	.0
log file sync	1	99.7		.3
name-service call wait	8	11.1		88.9
os thread startup	11	60.7	32.1	7.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	5,661	205	2,806	18,292
ess34	226	102	34	21,049
SYS$BACKGROUND	0	0	1	39

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
SYS$USERS	57752	360	2629	1	552
ess34	12136	66	522	0	433810
SYS$BACKGROUND	1062	6	19261	1	3962

Back to Wait Events Statistics
Back to Top

SQL Statistics

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 12.2% of Total DB Time (s): 5,885
Captured PL/SQL account for 13.8% of Total DB Time (s): 5,885

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
705.96	1	705.96	12.00	28.28	50.52	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
100.64	104	0.97	1.71	63.94	0.03	6dyg6rzs06r7x	DBMS_SCHEDULER	declare ipaddr varchar2(20); S...
100.52	104	0.97	1.71	63.96	0.00	a08zzuwf4busj	DBMS_SCHEDULER	SELECT SQL_TEXT FROM V$OPEN_CU...
95.88	3	31.96	1.63	15.59	71.19	g6xh02jb0ccyr	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
77.56	6	12.93	1.32	22.63	59.84	g63px48cs1j77	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
59.89	3	19.96	1.02	8.00	82.92	8tsfqd4prv88g	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
55.75	3	18.58	0.95	21.02	63.53	f003dcq2fv4v9	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
43.45	11	3.95	0.74	18.41	67.14	bgcz0c964znq0	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
37.52	10	3.75	0.64	20.84	62.98	009gr1md7zsm3	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
35.45	112	0.32	0.60	61.08	1.29	2vrbg89c0b9c3	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...

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 76.0% of Total CPU Time (s): 306
Captured PL/SQL account for 86.9% of Total CPU Time (s): 306

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
199.67	1	199.67	65.15	705.96	28.28	50.52	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
64.35	104	0.62	21.00	100.64	63.94	0.03	6dyg6rzs06r7x	DBMS_SCHEDULER	declare ipaddr varchar2(20); S...
64.29	104	0.62	20.98	100.52	63.96	0.00	a08zzuwf4busj	DBMS_SCHEDULER	SELECT SQL_TEXT FROM V$OPEN_CU...
21.65	112	0.19	7.07	35.45	61.08	1.29	2vrbg89c0b9c3	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
17.55	6	2.93	5.73	77.56	22.63	59.84	g63px48cs1j77	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
14.95	3	4.98	4.88	95.88	15.59	71.19	g6xh02jb0ccyr	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
11.72	3	3.91	3.82	55.75	21.02	63.53	f003dcq2fv4v9	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
8.73	1	8.73	2.85	15.09	57.86	4.10	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
8.00	11	0.73	2.61	43.45	18.41	67.14	bgcz0c964znq0	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
7.82	10	0.78	2.55	37.52	20.84	62.98	009gr1md7zsm3	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
6.46	161	0.04	2.11	10.46	61.76	0.00	71x92bbqtmncu	JDBC Thin Client	SELECT staff_id, depart_id, st...
5.35	232	0.02	1.75	12.07	44.37	19.68	as1vfbtbaq488	JDBC Thin Client	select t1.*, f_csm_getelementL...
4.79	3	1.60	1.56	59.89	8.00	82.92	8tsfqd4prv88g	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
4.33	3	1.44	1.41	6.89	62.89	0.00	5fcqwwcwv1k6k	DBMS_SCHEDULER	select substrb(dump(val, 16, 0...
4.24	3	1.41	1.38	6.75	62.84	0.00	2skrtuku00sn9	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
4.22	3	1.41	1.38	6.72	62.77	0.10	06h78ft4r6qsg	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
4.18	3	1.39	1.36	6.67	62.63	0.00	7p8xsztygapnq	DBMS_SCHEDULER	select substrb(dump(val, 16, 0...
4.08	3	1.36	1.33	6.50	62.74	0.00	208kfzk3p5k5b	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
3.96	11	0.36	1.29	25.22	15.71	45.73	bzscyq07w79ab		delete /*+ dynamic_sampling(4)...
3.92	3	1.31	1.28	6.33	61.94	1.02	611n9wc4an0v0	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
3.65	156	0.02	1.19	8.98	40.69	24.02	60q0qbx52q4hg	JDBC Thin Client	SELECT /+ use_nl(a, b)/ a.PR...
3.20	3	1.07	1.05	5.20	61.55	1.27	d9tmt2ddmhtua	DBMS_SCHEDULER	select substrb(dump(val, 16, 0...
3.19	3	1.06	1.04	5.16	61.97	0.45	f62hx009yhd2p	DBMS_SCHEDULER	select substrb(dump(val, 16, 0...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
356.67	1	356.67	82.57	705.96	28.28	50.52	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
68.25	3	22.75	15.80	95.88	15.59	71.19	g6xh02jb0ccyr	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
49.67	3	16.56	11.50	59.89	8.00	82.92	8tsfqd4prv88g	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
46.41	6	7.74	10.75	77.56	22.63	59.84	g63px48cs1j77	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
35.42	3	11.81	8.20	55.75	21.02	63.53	f003dcq2fv4v9	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
29.17	11	2.65	6.75	43.45	18.41	67.14	bgcz0c964znq0	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
23.63	10	2.36	5.47	37.52	20.84	62.98	009gr1md7zsm3	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
21.67	9	2.41	5.02	25.45	6.98	85.16	bcda3mffuntad	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
11.53	11	1.05	2.67	25.22	15.71	45.73	bzscyq07w79ab		delete /*+ dynamic_sampling(4)...
7.35	1	7.35	1.70	10.19	5.36	72.15	9v9n97qj8z1dg		delete /*+ dynamic_sampling(4)...
7.22	287	0.03	1.67	8.46	5.51	85.37	63kf3an2j0pkc		insert into sys.wri$_optstat_h...
4.60	2	2.30	1.06	8.39	27.02	54.75	bbz1fycndc735	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
4.43	260	0.02	1.03	5.65	11.52	78.37	5bp43151r7ux2	JDBC Thin Client	SELECT /*+INDEX(s PK_TF_M_STAF...

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: 39,373,724
Captured SQL account for 83.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
18,146,992	1	18,146,992.00	46.09	705.96	28.3	50.5	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
8,305,336	112	74,154.79	21.09	35.45	61.1	1.3	2vrbg89c0b9c3	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
2,359,155	1	2,359,155.00	5.99	15.09	57.9	4.1	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
1,978,486	232	8,527.96	5.02	12.07	44.4	19.7	as1vfbtbaq488	JDBC Thin Client	select t1.*, f_csm_getelementL...
1,321,748	156	8,472.74	3.36	8.98	40.7	24	60q0qbx52q4hg	JDBC Thin Client	SELECT /+ use_nl(a, b)/ a.PR...
1,218,370	3	406,123.33	3.09	95.88	15.6	71.2	g6xh02jb0ccyr	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
1,097,886	3	365,962.00	2.79	6.72	62.8	.1	06h78ft4r6qsg	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
1,097,886	3	365,962.00	2.79	6.75	62.8	0	2skrtuku00sn9	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
1,097,886	3	365,962.00	2.79	6.89	62.9	0	5fcqwwcwv1k6k	DBMS_SCHEDULER	select substrb(dump(val, 16, 0...
1,051,848	3	350,616.00	2.67	6.50	62.7	0	208kfzk3p5k5b	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
1,051,848	3	350,616.00	2.67	6.67	62.6	0	7p8xsztygapnq	DBMS_SCHEDULER	select substrb(dump(val, 16, 0...
1,032,381	3	344,127.00	2.62	55.75	21	63.5	f003dcq2fv4v9	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
1,003,236	3	334,412.00	2.55	6.33	61.9	1	611n9wc4an0v0	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
963,369	11	87,579.00	2.45	25.22	15.7	45.7	bzscyq07w79ab		delete /*+ dynamic_sampling(4)...
943,641	12	78,636.75	2.40	3.96	62.1	0	d1zf2gz3nh6p9	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
884,116	6	147,352.67	2.25	77.56	22.6	59.8	g63px48cs1j77	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
865,381	12	72,115.08	2.20	3.53	59.8	1.4	8z7x4pvgkp15f	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
812,620	2	406,310.00	2.06	4.35	61.5	1.5	5xg08nhhywxwx	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
745,280	161	4,629.07	1.89	10.46	61.8	0	71x92bbqtmncu	JDBC Thin Client	SELECT staff_id, depart_id, st...
729,699	3	243,233.00	1.85	59.89	8	82.9	8tsfqd4prv88g	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
729,699	3	243,233.00	1.85	5.20	61.5	1.3	d9tmt2ddmhtua	DBMS_SCHEDULER	select substrb(dump(val, 16, 0...
729,318	3	243,106.00	1.85	5.16	62	.5	f62hx009yhd2p	DBMS_SCHEDULER	select substrb(dump(val, 16, 0...
678,021	2	339,010.50	1.72	6.61	45	23.5	6z6b3mrbuz0rb	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
486,212	2	243,106.00	1.23	8.39	27	54.7	bbz1fycndc735	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...

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: 2,840,624
Captured SQL account for 84.4% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,802,481	1	2,802,481.00	98.66	705.96	28.28	50.52	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
881,457	6	146,909.50	31.03	77.56	22.63	59.84	g63px48cs1j77	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
402,650	3	134,216.67	14.17	95.88	15.59	71.19	g6xh02jb0ccyr	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
371,583	10	37,158.30	13.08	37.52	20.84	62.98	009gr1md7zsm3	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
371,034	11	33,730.36	13.06	43.45	18.41	67.14	bgcz0c964znq0	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
331,771	3	110,590.33	11.68	55.75	21.02	63.53	f003dcq2fv4v9	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
22,746	3	7,582.00	0.80	59.89	8.00	82.92	8tsfqd4prv88g	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
4,573	9	508.11	0.16	25.45	6.98	85.16	bcda3mffuntad	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
2,748	11	249.82	0.10	25.22	15.71	45.73	bzscyq07w79ab		delete /*+ dynamic_sampling(4)...
2,442	2	1,221.00	0.09	6.61	45.01	23.49	6z6b3mrbuz0rb	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...

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: 461,619
Captured SQL account for 36.8% of Total
Total UnOptimized Read Requests: 461,619
Captured SQL account for 36.8% 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
447,301	447,301	1	447,301.00	96.90	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
112,021	112,021	3	37,340.33	24.27	g6xh02jb0ccyr	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
12,689	12,689	6	2,114.83	2.75	g63px48cs1j77	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
11,375	11,375	3	3,791.67	2.46	8tsfqd4prv88g	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
7,309	7,309	11	664.45	1.58	bgcz0c964znq0	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
7,149	7,149	10	714.90	1.55	009gr1md7zsm3	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
5,620	5,620	3	1,873.33	1.22	f003dcq2fv4v9	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
4,573	4,573	9	508.11	0.99	bcda3mffuntad	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
2,748	2,748	11	249.82	0.60	bzscyq07w79ab		delete /*+ dynamic_sampling(4)...
1,658	1,658	2	829.00	0.36	6z6b3mrbuz0rb	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...

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: 155,375
Captured SQL account for 36.5% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
7,143	0	0.00	1.31	59.9	0	aypazt06z7fq8	JDBC Thin Client	SELECT * FROM (SELECT S.ROWID ...
6,436	6,436	1.00	0.43	58.9	1.6	3r98xda66pqkg	JDBC Thin Client	SELECT seq_operate_id.nextval ...
6,375	7,648	1.20	0.52	52.7	7.9	gfnm5kf4c4sv0	JDBC Thin Client	SELECT trim (PROVINCE_CODE) PR...
6,279	1,605	0.26	0.49	54	9.3	9uz82r5qakdrr	JDBC Thin Client	SELECT B.STANDARD_KIND_CODE FR...
3,979	3,980	1.00	0.22	59.3	0	7h35uxf5uhmm1	JDBC Thin Client	select sysdate from dual
3,845	4,773	1.24	0.57	46.3	23.5	ddkkhuy6g2xb3	JDBC Thin Client	select a.INTF_CONTEXT_CODE, a....
3,754	3,754	1.00	0.44	38.3	35.7	7huyhmb57bj7j	JDBC Thin Client	SELECT SQL_STMT FROM code_code...
2,312	2,312	1.00	0.24	58.5	2.2	9d5gtsgdqdbdd	JDBC Thin Client	SELECT seq_trade_id_poc.nextva...
1,683	1,683	1.00	0.52	59.5	0	9zygxum4pups3	JDBC Thin Client	select F_SYS_GETSEQID('0731', ...
1,465	1,302	0.89	0.34	45.7	23.5	8gfgrw6whsawh	JDBC Thin Client	SELECT subsys_code, param_attr...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 60,730
Captured SQL account for 51.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
7,149	7,143	11.77	aypazt06z7fq8	JDBC Thin Client	SELECT * FROM (SELECT S.ROWID ...
3,980	3,979	6.55	7h35uxf5uhmm1	JDBC Thin Client	select sysdate from dual
2,451	6,436	4.04	3r98xda66pqkg	JDBC Thin Client	SELECT seq_operate_id.nextval ...
2,286	2,312	3.76	9d5gtsgdqdbdd	JDBC Thin Client	SELECT seq_trade_id_poc.nextva...
1,683	1,683	2.77	9zygxum4pups3	JDBC Thin Client	select F_SYS_GETSEQID('0731', ...
1,379	1,379	2.27	32p6h39zdtvfk	JDBC Thin Client	select F_SYS_GETSEQID('89', 's...
1,041	1,041	1.71	520mkxqpf15q8	JDBC Thin Client	select 1 from dual
774	853	1.27	5m6h90d4pbpfy	JDBC Thin Client	SELECT seq_trade_id.nextval FR...
758	758	1.25	4jpt2hpaf3115	JDBC Thin Client	select F_SYS_GETSEQID('0731', ...
609	609	1.00	attz06s9rcfwr	JDBC Thin Client	select F_SYS_GETSEQID('0903', ...

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)	% Total	SQL Id	SQL Text
147,063,272	2.26	11gb0xb9vp04q	SQL Text Not Available
63,801,312	0.98	fa0uzvspp236d	SQL Text Not Available
57,066,800	0.88	6d1jnnuhkt8wy	SQL Text Not Available
44,063,480	0.68	8q7ppcdk6rvch	SQL Text Not Available
32,925,184	0.51	86v8m3jqnpxmu	SQL Text Not Available
30,002,536	0.46	7ntngwmf9bf4p	SQL Text Not Available
26,292,896	0.40	5d7jn0g21z6zf	SQL Text Not Available
25,270,456	0.39	dzan2tgvtkzdw	SQL Text Not Available
22,036,336	0.34	3f3hn3fpjzjpc	SQL Text Not Available
21,597,856	0.33	ghc83bfjv10k2	SQL Text Not Available
20,479,872	0.32	76prgq1x4k2z3	SQL Text Not Available
20,284,864	0.31	52wa1g9zbygsk	SQL Text Not Available
19,984,760	0.31	9v56t5yjn5fvs	SQL Text Not Available
19,701,688	0.30	5k0m9p5r81awv	SQL Text Not Available
19,501,904	0.30	5366v39r5n5ux	SQL Text Not Available
19,415,616	0.30	3gwrz9gzta4g7	SQL Text Not Available
19,352,304	0.30	gj0q42166bt62	SQL Text Not Available
19,112,600	0.29	12hhcr6ucw6mb	SQL Text Not Available
18,468,576	0.28	cuv4yub7sc5am	SQL Text Not Available
18,468,336	0.28	25vwt55t1093f	SQL Text Not Available
17,813,512	0.27	g8z3zsc07gyx8	SQL Text Not Available
15,774,248	0.24	1nktcbcjqsfqv	SQL Text Not Available
15,598,776	0.24	9q5jas50b88ud	SQL Text Not Available
15,542,016	0.24	6yha0qjjasqxg	SQL Text Not Available
14,962,448	0.23	7cfzjgyugq476	SQL Text Not Available
14,804,456	0.23	390ngbpv69txy	SQL Text Not Available
14,394,400	0.22	dw9qhngcst6c0	SQL Text Not Available
14,278,184	0.22	danm6dqvz780s	SQL Text Not Available
14,013,208	0.22	1r9u733n8t67x	SQL Text Not Available
13,811,128	0.21	8amf6x2gf6cfr	SQL Text Not Available
13,549,496	0.21	dzsjvy781bqf7	SQL Text Not Available
12,195,520	0.19	0apbvns24jdc9	SQL Text Not Available
11,466,456	0.18	bya4d80vkp9t8	SQL Text Not Available
10,390,816	0.16	1fuvut1mhzn6j	SQL Text Not Available
8,447,152	0.13	9tv4b1adcgh6y	SQL Text Not Available
8,277,392	0.13	dqn46uz4zdh6v	SQL Text Not Available
7,851,968	0.12	28gw35yumb9th	SQL Text Not Available
7,311,296	0.11	4cduyz74jf1np	SQL Text Not Available

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
322		dzsjvy781bqf7		SQL Text Not Available
305		g8z3zsc07gyx8		SQL Text Not Available
304		3f3hn3fpjzjpc		SQL Text Not Available
304		4cduyz74jf1np		SQL Text Not Available
304		6d1jnnuhkt8wy		SQL Text Not Available
304		7ntngwmf9bf4p		SQL Text Not Available
304		ghc83bfjv10k2		SQL Text Not Available
302		0apbvns24jdc9		SQL Text Not Available
302		9tv4b1adcgh6y		SQL Text Not Available
302		dw9qhngcst6c0		SQL Text Not Available
301		9q5jas50b88ud		SQL Text Not Available
300		3gwrz9gzta4g7		SQL Text Not Available
297		6yha0qjjasqxg		SQL Text Not Available
295		dqn46uz4zdh6v		SQL Text Not Available
293		1r9u733n8t67x		SQL Text Not Available
291		9v56t5yjn5fvs		SQL Text Not Available
290		1fuvut1mhzn6j		SQL Text Not Available
286		7cfzjgyugq476		SQL Text Not Available
286		8amf6x2gf6cfr		SQL Text Not Available
286		bya4d80vkp9t8		SQL Text Not Available
285		390ngbpv69txy		SQL Text Not Available
285		5366v39r5n5ux		SQL Text Not Available
284		12hhcr6ucw6mb		SQL Text Not Available
283		76prgq1x4k2z3		SQL Text Not Available
282		5d7jn0g21z6zf		SQL Text Not Available
282		86v8m3jqnpxmu		SQL Text Not Available
279		1nktcbcjqsfqv		SQL Text Not Available
279		52wa1g9zbygsk		SQL Text Not Available
278		28gw35yumb9th		SQL Text Not Available
278		8q7ppcdk6rvch		SQL Text Not Available
277		11gb0xb9vp04q		SQL Text Not Available
277		fa0uzvspp236d		SQL Text Not Available
275		danm6dqvz780s		SQL Text Not Available
272		5k0m9p5r81awv		SQL Text Not Available
272		dzan2tgvtkzdw		SQL Text Not Available
269		25vwt55t1093f		SQL Text Not Available
269		cuv4yub7sc5am		SQL Text Not Available
267		gj0q42166bt62		SQL Text Not Available
39	667	3qz5dycv2z4my	JDBC Thin Client	SELECT subsys_code, param_attr...
31	904	18y91z1j9gkc2	JDBC Thin Client	SELECT eparchy_code, tag_code,...
25	1,465	8gfgrw6whsawh	JDBC Thin Client	SELECT subsys_code, param_attr...

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

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
57.71	1	79.54	705.96	8.17	28.28	50.52	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
9.21	6	12.69	77.56	11.87	22.63	59.84	g63px48cs1j77	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
8.58	3	11.82	95.88	8.94	15.59	71.19	g6xh02jb0ccyr	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
8.12	11	11.19	25.22	32.21	15.71	45.73	bzscyq07w79ab		delete /*+ dynamic_sampling(4)...
5.26	3	7.25	55.75	9.44	21.02	63.53	f003dcq2fv4v9	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
4.47	11	6.16	43.45	10.29	18.41	67.14	bgcz0c964znq0	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
4.32	10	5.96	37.52	11.52	20.84	62.98	009gr1md7zsm3	DBMS_SCHEDULER	/* SQL Analyze(1) / select /...
3.58	3	4.94	59.89	5.98	8.00	82.92	8tsfqd4prv88g	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
2.22	1	3.06	10.19	21.81	5.36	72.15	9v9n97qj8z1dg		delete /*+ dynamic_sampling(4)...
1.35	9	1.86	25.45	5.30	6.98	85.16	bcda3mffuntad	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
1.25	232	1.73	12.07	10.39	44.37	19.68	as1vfbtbaq488	JDBC Thin Client	select t1.*, f_csm_getelementL...
1.24	6	1.70	5.16	23.94	45.11	6.05	d8jh4bh83k9tz	PL/SQL Developer	DECLARE job BINARY_INTEGER := ...
1.12	156	1.54	8.98	12.43	40.69	24.02	60q0qbx52q4hg	JDBC Thin Client	SELECT /+ use_nl(a, b)/ a.PR...
0.69	287	0.96	8.46	8.21	5.51	85.37	63kf3an2j0pkc		insert into sys.wri$_optstat_h...
0.46	2	0.63	6.61	6.90	45.01	23.49	6z6b3mrbuz0rb	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
0.41	298	0.57	3.48	11.88	4.11	83.89	5qg4x6s73p8zj	JDBC Thin Client	select a.dev_code STAFF_ID, a....
0.30	1	0.41	15.09	1.99	57.86	4.10	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
0.24	260	0.33	5.65	4.25	11.52	78.37	5bp43151r7ux2	JDBC Thin Client	SELECT /*+INDEX(s PK_TF_M_STAF...
0.23	2	0.31	8.39	2.69	27.02	54.75	bbz1fycndc735	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
0.14	112	0.19	35.45	0.39	61.08	1.29	2vrbg89c0b9c3	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
0.10	12	0.13	3.53	2.73	59.82	1.37	8z7x4pvgkp15f	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
0.03	612	0.05	0.55	5.94	28.60	48.82	gqwdr44z61uhc	JDBC Thin Client	SELECT B.STAFF_ID, A.DEPART_ID...
0.03	2	0.03	4.35	0.58	61.48	1.47	5xg08nhhywxwx	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
0.02	6,375	0.03	0.52	4.20	52.74	7.91	gfnm5kf4c4sv0	JDBC Thin Client	SELECT trim (PROVINCE_CODE) PR...
0.02	3	0.03	6.33	0.29	61.94	1.02	611n9wc4an0v0	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
0.02	12	0.02	3.96	0.38	62.06	0.00	d1zf2gz3nh6p9	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
0.01	3	0.02	6.67	0.20	62.63	0.00	7p8xsztygapnq	DBMS_SCHEDULER	select substrb(dump(val, 16, 0...
0.01	3	0.01	5.16	0.19	61.97	0.45	f62hx009yhd2p	DBMS_SCHEDULER	select substrb(dump(val, 16, 0...
0.01	3	0.01	5.20	0.16	61.55	1.27	d9tmt2ddmhtua	DBMS_SCHEDULER	select substrb(dump(val, 16, 0...
0.01	3	0.01	6.50	0.12	62.74	0.00	208kfzk3p5k5b	DBMS_SCHEDULER	select min(minbkt), maxbkt, su...
0.01	6,279	0.01	0.49	1.30	53.99	9.35	9uz82r5qakdrr	JDBC Thin Client	SELECT B.STANDARD_KIND_CODE FR...
0.01	3,754	0.01	0.44	1.31	38.30	35.66	7huyhmb57bj7j	JDBC Thin Client	SELECT SQL_STMT FROM code_code...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

009gr1md7zsm3 /* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("RIGHT_CODE")), to_char(substrb(dump(min("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPERED_STAFF_ID")), to_char(substrb(dump(min("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_ATTR")), to_char(substrb(dump(min("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(count("LOG_ID")), to_char(substrb(dump(min("LOG_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LOG_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_TYPE")), to_char(substrb(dump(min("OPER_TYPE "), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_TYPE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_TYPE")), to_char(substrb(dump(min("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(count("ROLE_CODE")), to_char(substrb(dump(min("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(count("AREA_CODE")), to_char(substrb(dump(min("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPER_STAFF_ID")), to_char(substrb(dump(min("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DEPART_ID")), to_char(substrb(dump(min("OPER_DEPART_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DEP ART_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DATE")), to_char(substrb(dump(min("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_CLASS")), to_char(substrb(dump(min("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(count("OPER_SPECIAL")), to_char(substrb(dump(min("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(count("TERM_IP")), to_char(substrb(dump(min("TERM_IP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TERM_IP"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE1")), to_char(substrb(dump(min("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE2 ")), to_char(substrb(dump(min("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE1")), to_char(substrb(dump(min("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE2")), to_char(substrb(dump(min("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(count("USE_TAG")), to_char(substrb(dump(min("USE_TAG"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("USE_TAG"), 16, 0, 32), 1, 120)), to_char(count("TIMES")), to_char(substrb(dump(min("TIMES"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TIMES"), 16, 0, 32), 1, 120)), to_char(count("START_DATE")), to_char(substrb(dump(min("START_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max( "START_DATE"), 16, 0, 32), 1, 120)), to_char(count("END_DATE")), to_char(substrb(dump(min("END_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("END_DATE"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR1")), to_char(substrb(dump(min("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR2")), to_char(substrb(dump(min("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR3")), to_char(substrb(dump(min("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR4")), to_char(substrb(dump(min("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR5")), to_char(subs trb(dump(min("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(count("REMARK")), to_char(substrb(dump(min("REMARK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REMARK"), 16, 0, 32), 1, 120)), to_char(count("PROVINCE_CODE")), to_char(substrb(dump(min("PROVINCE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PROVINCE_CODE"), 16, 0, 32), 1, 120)) from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn /* NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/

06h78ft4r6qsg select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"OPER_STAFF_ID" val, ntile(254) over (order by nlssort("OPER_STAFF_ID", 'NLS_SORT = binary')) bkt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_STAFF_ID" is not null) group by val) group by maxbkt order by maxbkt

0apbvns24jdc9 ** SQL Text Not Available **

11gb0xb9vp04q ** SQL Text Not Available **

12hhcr6ucw6mb ** SQL Text Not Available **

18y91z1j9gkc2 SELECT eparchy_code, tag_code, tag_name, subsys_code, tag_info, tag_char, to_char(tag_number) tag_number, to_char(tag_date, 'yyyy-mm-dd hh24:mi:ss') tag_date, to_char(tag_sequid) tag_sequid, use_tag, to_char(start_date, 'yyyy-mm-dd hh24:mi:ss') start_date, to_char(end_date, 'yyyy-mm-dd hh24:mi:ss') end_date, remark, to_char(update_time, 'yyyy-mm-dd hh24:mi:ss') update_time, update_staff_id, update_depart_id FROM td_s_tag WHERE (eparchy_code = :1 OR eparchy_code = 'ZZZZ') and (PROVINCE_CODE = 'ZZZZ' or PROVINCE_CODE = (select parent_area_code from td_m_area where area_code = :2 )) AND tag_code = :3 AND subsys_code = :4 AND use_tag = :5 AND sysdate between start_date and END_date

1fuvut1mhzn6j ** SQL Text Not Available **

1nktcbcjqsfqv ** SQL Text Not Available **

1r9u733n8t67x ** SQL Text Not Available **

208kfzk3p5k5b select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"OPER_STAFF_ID" val, ntile(254) over (order by nlssort("OPER_STAFF_ID", 'NLS_SORT = binary')) bkt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_STAFF_ID" is not null) group by val) group by maxbkt order by maxbkt

25vwt55t1093f ** SQL Text Not Available **

28gw35yumb9th ** SQL Text Not Available **

2skrtuku00sn9 select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"OPER_DATE" val, ntile(254) over (order by "OPER_DATE") bkt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_DATE" is not null) group by val) group by maxbkt order by maxbkt

2vrbg89c0b9c3 SELECT A.PRODUCT_ID, PRODUCT_NAME, PRODUCT_EXPLAIN, PRODUCT_MODE, NET_TYPE_CODE, BRAND_CODE, GROUP_BRAND_CODE, SERVICE_ID, PRODUCT_OBJ_TYPE, RES_TYPE_CODE, DECLARED_PRODUCT_ID, COMP_TAG, ENABLE_TAG, to_char(START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, START_OFFSET, START_UNIT, END_ENABLE_TAG, to_char(END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, END_OFFSET, END_UNIT, to_char(A.START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(A.END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, MIN_NUMBER, MAX_NUMBER, VERSION, PRODUCT_STATE, b.USE_TAG, a.PREPAY_TAG, (SELECT COUNT(1) FROM td_s_interface_ctrl WHERE (PROVINCE_CODE = 'ZZZZ' OR PROVINCE_CODE = (SELECT tag_info FROM td_s_tag WHERE tag_code = 'PUB_CUR_PROVINCE' and subsys_code = 'PUB' and use_tag = '0' and end_date > sysdate and eparchy_code = 'ZZZZ' and rownum < 2)) and intf_context_code = 'PRODUCT_' || TO_CHAR(A.product_id) AND (area_code = :1 OR area_code = :2 OR area_code = 'ZZZZ')) HAS_AT TR, a.NEED_EXP FROM td_b_ptype_product B, TD_B_PRODUCT A WHERE B.product_type_code = :3 AND B.ROOT = :4 AND sysdate BETWEEN B.start_date AND B.end_date AND sysdate BETWEEN A.start_date AND A.end_date AND A.product_id = B.product_id and not exists (select 1 from td_b_product_item t where t.product_id = a.product_id and t.attr_code = 'WoXiang' and t.attr_value = '1') AND EXISTS (SELECT 1 FROM td_b_product_release WHERE product_id = A.product_id AND (release_area_code = 'ZZZZ' OR release_area_code = :5 OR release_area_code = :6 ) AND sysdate BETWEEN start_date AND end_date) AND (substr(:7 , -8) = 'SUPERUSR' OR EXISTS (SELECT 1 FROM tf_m_staffdataright C, tf_m_roledataright D WHERE C.staff_id = :8 AND C.data_code = D.role_code AND C.right_attr = '1' AND C.right_tag = '1' AND D.data_type = 'P' AND D.data_code = TO_CHAR(A.product_id))) and not exists (select 1 from td_s_product_trans f where f.product_id_a =:9 and f.product_id_b = a.product_id and f.trans_tag = 'A') AND NOT EXISTS (SELECT 1 FROM TD_B_PRODUCT_GROUP WHERE PRODUCT_ID = A.PRODUCT_ID AND SYSDATE BETWEEN START_DATE AND END_DATE AND (EPARCHY_CODE = 'ZZZZ' OR EPARCHY_CODE = :10 )) AND ( NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND start_date <= SYSDATE AND SYSDATE <= end_date) OR EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND ( (sale_area_type = '40' AND (:11 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :12 )) OR (sale_area_type = '30' AND (:13 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :14 )) OR (sale_area_type = '20' AND (:15 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :16 )) OR (sale_area_type = '10' AND sale_area_code = 'ZZZZ') ) AND start_date <= SYSDATE AND SYSDATE <= end_date) ) order by PRODUCT_MODE, b.item_index, a.start_date, a.product_name

32p6h39zdtvfk select F_SYS_GETSEQID('89', 'seq_operate_id') from dual

390ngbpv69txy ** SQL Text Not Available **

3f3hn3fpjzjpc ** SQL Text Not Available **

3gwrz9gzta4g7 ** SQL Text Not Available **

3qz5dycv2z4my SELECT subsys_code, param_attr, param_code, param_name, para_code1, para_code2, para_code3, para_code4, para_code5, para_code6, para_code7, para_code8, para_code9, para_code10, para_code11, para_code12, para_code13, para_code14, para_code15, para_code16, para_code17, para_code18, para_code19, para_code20, para_code21, para_code22, para_code23, para_code24, para_code25, to_char(para_code26, 'yyyy-mm-dd hh24:mi:ss') para_code26, to_char(para_code27, 'yyyy-mm-dd hh24:mi:ss') para_code27, to_char(para_code28, 'yyyy-mm-dd hh24:mi:ss') para_code28, to_char(para_code29, 'yyyy-mm-dd hh24:mi:ss') para_code29, to_char(para_code30, 'yyyy-mm-dd hh24:mi:ss') para_code30, to_char(start_date, 'yyyy-mm-dd hh24:mi:ss') start_date, to_char(end_date, 'yyyy-mm-dd hh24:mi:ss') end_date, eparchy_code, remark, update_staff_id, update_depart_id, to_char(update_time, 'yyyy-mm-dd hh24:mi:ss') update_time FROM td_s_commpara WHERE (subsys_code=:1 AND param_attr=:2 AND param_code=:3 AND para_code1=:4 AND sysdate B ETWEEN start_date AND end_date) AND (eparchy_code=:5 OR eparchy_code='ZZZZ') and (PROVINCE_CODE = 'ZZZZ' or PROVINCE_CODE = (select parent_area_code from td_m_area where area_code =:6 ))

3r98xda66pqkg SELECT seq_operate_id.nextval FROM DUAL

4cduyz74jf1np ** SQL Text Not Available **

4jpt2hpaf3115 select F_SYS_GETSEQID('0731', 'seq_trade_id_poc') from dual

520mkxqpf15q8 select 1 from dual

52wa1g9zbygsk ** SQL Text Not Available **

5366v39r5n5ux ** SQL Text Not Available **

572fbaj0fdw2b select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))

5bp43151r7ux2 SELECT /*+INDEX(s PK_TF_M_STAFFFUNCRIGHT)*/ f.right_code RIGHT_CODE, f.right_name RIGHT_NAME, m.mod_name MOD_NAME, m.mod_type MOD_TYPE FROM tf_m_stafffuncright s, td_m_funcright f, td_s_modfile m WHERE s.right_attr='0' AND s.right_tag='1' AND f.right_attr='0' AND m.mod_code=f.mod_code AND s.right_code=f.right_code AND s.province_code=f.province_code AND f.province_code=m.province_code AND (s.rsvalue1 IS NULL OR s.rsvalue1 != '1') AND s.staff_id = :1 AND s.depart_id = :2 AND s.province_code = :3 UNION SELECT /*+INDEX(s PK_TF_M_STAFFFUNCRIGHT)*/ NVL(f.right_code, ' ') RIGHT_CODE, f.right_name RIGHT_NAME, m.mod_name MOD_NAME, m.mod_type MOD_TYPE FROM tf_m_stafffuncright s, td_m_funcright f, tf_m_rolefuncright r, td_s_modfile m WHERE s.right_attr='1' AND s.right_tag='1' AND s.right_code=r.role_code AND r.right_code=f.right_code AND m.mod_code=f.mod_code AND s.province_code=f.province_code AND f.province_code=m.province_code AND m.province_code=r.province_code AND (r.rsvalue1 IS NULL OR r .rsvalue1 != '1') AND (s.rsvalue1 IS NULL OR s.rsvalue1 != '1') AND NOT EXISTS(SELECT 1 FROM tf_m_stafffuncright WHERE staff_id=s.staff_id AND right_code=r.right_code AND province_code=r.province_code AND r.province_code = :4 AND (right_tag='0' OR rsvalue1 = '1' )) AND s.staff_id = :5 AND s.depart_id = :6 AND s.province_code = :7 UNION SELECT f.right_code RIGHT_CODE, f.right_name RIGHT_NAME, m.mod_name MOD_NAME, m.mod_type MOD_TYPE FROM td_m_funcright f, td_s_modfile m WHERE f.right_attr='0' AND f.class_code='PUB' AND f.province_code = :8 AND f.mod_code=m.mod_code AND f.province_code=m.province_code

5d7jn0g21z6zf ** SQL Text Not Available **

5fcqwwcwv1k6k select substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */max("OPER_TYPE") val, count(*) cnt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_TYPE" is not null group by nlssort("OPER_TYPE", 'NLS_SORT = binary')) order by nlssort(val, 'NLS_SORT = binary')

5k0m9p5r81awv ** SQL Text Not Available **

5m6h90d4pbpfy SELECT seq_trade_id.nextval FROM DUAL

5qg4x6s73p8zj select a.dev_code STAFF_ID, a.chnl_code DEPART_ID, b.depart_name DEPART_NAME, a.dev_name STAFF_NAME, a.linkman_phone SERIAL_NUMBER from td_m_developer a, td_m_depart b, td_m_channel c where a.chnl_code = c.depart_id and b.depart_id = c.real_depart_id and a.dev_code=:1 AND a.province_code = :2 AND a.eparchy_code = :3 union all SELECT STAFF_ID, TD_M_STAFF.DEPART_ID DEPART_ID, TD_M_DEPART.DEPART_NAME DEPART_NAME, STAFF_NAME, SERIAL_NUMBER FROM TD_M_STAFF, TD_M_DEPART WHERE TD_M_STAFF.DEPART_ID = TD_M_DEPART.DEPART_ID and TD_M_STAFF.STAFF_ID=:4 and TD_M_STAFF.PROVINCE_CODE= :5 and TD_M_STAFF.EPARCHY_CODE= :6

5xg08nhhywxwx select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"RIGHT_CODE" val, ntile(254) over (order by nlssort("RIGHT_CODE", 'NLS_SORT = binary')) bkt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "RIGHT_CODE" is not null) group by val) group by maxbkt order by maxbkt

60q0qbx52q4hg SELECT /*+ use_nl(a, b)*/ a.PRODUCT_ID, a.PACKAGE_ID, b.PACKAGE_NAME, b.PACKAGE_TYPE_CODE, b.PACKAGE_DESC, a.FORCE_TAG, a.DEFAULT_TAG, DECODE(:1 , 0, b.MIN_NUMBER, a.MIN_NUMBER) MIN_NUMBER, DECODE(:2 , 0, b.MAX_NUMBER, a.MAX_NUMBER) MAX_NUMBER, a.RSRV_STR1, a.RSRV_STR2, to_char(a.START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(a.END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, a.EPARCHY_CODE, a.UPDATE_STAFF_ID, a.UPDATE_DEPART_ID, to_char(a.UPDATE_TIME, 'yyyy-mm-dd hh24:mi:ss') UPDATE_TIME, a.ITEM_INDEX, b.NEED_EXP FROM TD_B_PRODUCT_PACKAGE a, TD_B_PACKAGE b, td_b_product c WHERE a.PRODUCT_ID = :3 AND a.PRODUCT_ID = c.PRODUCT_ID AND (c.BRAND_CODE != 'FMLY' OR c.BRAND_CODE IS NULL) AND SYSDATE BETWEEN a.START_DATE AND a.end_date AND SYSDATE BETWEEN c.START_DATE AND c.end_date AND (a.EPARCHY_CODE = :4 OR a.EPARCHY_CODE = 'ZZZZ') AND b.PACKAGE_ID = a.PACKAGE_ID AND (substr(:5 , -8) = 'SUPERUSR' OR EXISTS (SELECT /*+ index(F, PK_TF_M_ROLEDATARIGHT)*/ 1 FR OM tf_m_staffdataright E, tf_m_roledataright F WHERE E.staff_id = :6 AND E.data_code = F.role_code AND E.right_attr = '1' --????-1-?????? AND E.right_tag = '1' --????-1-?? AND F.data_type = 'K' --????-k-??? AND F.data_code = TO_CHAR(a.PACKAGE_ID)) OR EXISTS (SELECT 1 FROM tf_m_roledataright T1 WHERE T1.data_type = 'K' AND T1.data_code = TO_CHAR(a.PACKAGE_ID) AND T1.ROLE_CODE = '09ZZZZZZ') ) ORDER BY ITEM_INDEX

611n9wc4an0v0 select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"OPER_DATE" val, ntile(254) over (order by "OPER_DATE") bkt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_DATE" is not null) group by val) group by maxbkt order by maxbkt

63kf3an2j0pkc insert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue, colname) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue, :4 from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2

6d1jnnuhkt8wy ** SQL Text Not Available **

6dyg6rzs06r7x declare ipaddr varchar2(20); STEXT VARCHAR2(4000); BEGIN begin select sys_context('USERENV', 'IP_ADDRESS') into ipaddr FROM dual; exception when others then ipaddr:='-'; end; begin select SQL_TEXT INTO STEXT FROM v$open_cursor WHERE UPPER(sql_text) LIKE 'ALTER%' or UPPER(sql_text) LIKE 'DROP%' or UPPER(sql_text) LIKE 'GRANT%' or UPPER(sql_text) LIKE 'REVOKE%' or UPPER(sql_text) LIKE 'RENAME%'; exception when others then STEXT:='-'; end; insert into sys.stat$log_DDL values (sysdate, user, nvl (ipaddr, '-'), NVL(ora_dict_obj_name, '-'), NVL(ORA_SYSEVENT, '-'), NVL(ora_dict_obj_type, '-'), NVL(ora_dict_obj_owner, '-'), STEXT, to_char(sysdate, 'yyyymmdd') ); exception when others then null; END;

6yha0qjjasqxg ** SQL Text Not Available **

6z6b3mrbuz0rb select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"LOG_ID" val, ntile(254) over (order by "LOG_ID") bkt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "LOG_ID" is not null) group by val) group by maxbkt order by maxbkt

71x92bbqtmncu SELECT staff_id, depart_id, staff_name, job_code, manager_info, sex, email, user_pid, serial_number, to_char(cust_id) cust_id, dimission_tag, to_char(birthday, 'yyyy-mm-dd hh24:mi:ss') birthday, staff_group_id as group_id, cust_hobyy, manager_staff_id, receive_type_code, login_flag, cust_manager_flag, city_code, eparchy_code, remark, rsvalue1, rsvalue2, to_char(update_time, 'yyyy-mm-dd hh24:mi:ss') update_time, update_staff_id, update_depart_id, province_code FROM td_m_staff WHERE staff_id=:1 AND province_code = :2

76prgq1x4k2z3 ** SQL Text Not Available **

7cfzjgyugq476 ** SQL Text Not Available **

7h35uxf5uhmm1 select sysdate from dual

7huyhmb57bj7j SELECT SQL_STMT FROM code_code WHERE tab_name= :1 AND sql_ref = :2

7ntngwmf9bf4p ** SQL Text Not Available **

7p8xsztygapnq select substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */max("OPER_TYPE") val, count(*) cnt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_TYPE" is not null group by nlssort("OPER_TYPE", 'NLS_SORT = binary')) order by nlssort(val, 'NLS_SORT = binary')

86v8m3jqnpxmu ** SQL Text Not Available **

8amf6x2gf6cfr ** SQL Text Not Available **

8gfgrw6whsawh SELECT subsys_code, param_attr, param_code, param_name, para_code1, para_code2, para_code3, para_code4, para_code5, para_code6, para_code7, para_code8, para_code9, para_code10, para_code11, para_code12, para_code13, para_code14, para_code15, para_code16, para_code17, para_code18, para_code19, para_code20, para_code21, para_code22, para_code23, para_code24, para_code25, to_char(para_code26, 'yyyy-mm-dd hh24:mi:ss') para_code26, to_char(para_code27, 'yyyy-mm-dd hh24:mi:ss') para_code27, to_char(para_code28, 'yyyy-mm-dd hh24:mi:ss') para_code28, to_char(para_code29, 'yyyy-mm-dd hh24:mi:ss') para_code29, to_char(para_code30, 'yyyy-mm-dd hh24:mi:ss') para_code30, to_char(start_date, 'yyyy-mm-dd hh24:mi:ss') start_date, to_char(end_date, 'yyyy-mm-dd hh24:mi:ss') end_date, eparchy_code, remark, update_staff_id, update_depart_id, to_char(update_time, 'yyyy-mm-dd hh24:mi:ss') update_time FROM td_s_commpara WHERE (subsys_code = :1 AND param_attr = :2 AND param_code = to_char(:3 ) AND sysdate BETWEEN start_date AND end_date) AND (eparchy_code = :4 OR eparchy_code = 'ZZZZ') and (PROVINCE_CODE = 'ZZZZ' or PROVINCE_CODE = (select parent_area_code from td_m_area where area_code =:5 )) ORDER BY remark

8q7ppcdk6rvch ** SQL Text Not Available **

8tsfqd4prv88g select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"OPERED_STAFF_ID" val, ntile(254) over (order by nlssort("OPERED_STAFF_ID", 'NLS_SORT = binary')) bkt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPERED_STAFF_ID" is not null) group by val) group by maxbkt order by maxbkt

8z7x4pvgkp15f SELECT A.PRODUCT_ID, PRODUCT_NAME, PRODUCT_EXPLAIN, PRODUCT_MODE, NET_TYPE_CODE, BRAND_CODE, GROUP_BRAND_CODE, SERVICE_ID, PRODUCT_OBJ_TYPE, RES_TYPE_CODE, DECLARED_PRODUCT_ID, COMP_TAG, ENABLE_TAG, to_char(START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, START_OFFSET, START_UNIT, END_ENABLE_TAG, to_char(END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, END_OFFSET, END_UNIT, to_char(A.START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(A.END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, MIN_NUMBER, MAX_NUMBER, VERSION, PRODUCT_STATE, b.USE_TAG, a.PREPAY_TAG, a.NEED_EXP, B.product_type_code FROM td_b_ptype_product B, TD_B_PRODUCT A WHERE B.product_type_code=:1 AND B.ROOT=:2 AND sysdate BETWEEN B.start_date AND B.end_date AND sysdate BETWEEN A.start_date AND A.end_date AND A.product_id=B.product_id AND A.PRODUCT_OBJ_TYPE != '1' AND EXISTS (SELECT 1 FROM td_b_product_release WHERE product_id=A.product_id AND (release_area_code = 'ZZZZ' OR release_area_code=: 3 OR release_area_code=:4 ) AND sysdate BETWEEN start_date AND end_date) AND (substr(:5 , -8)= 'SUPERUSR' OR EXISTS (SELECT /*+ index(D, PK_TF_M_ROLEDATARIGHT)*/ 1 FROM tf_m_staffdataright C, tf_m_roledataright D WHERE C.staff_id=:6 AND C.data_code=D.role_code AND C.right_attr='1' --?????1-?????? AND C.right_tag='1' --?????1-?? AND D.data_type='P' --?????2-???? AND D.data_code=TO_CHAR(A.product_id))) AND ( NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND start_date <= SYSDATE AND SYSDATE <= end_date) OR EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND ( (sale_area_type = '40' AND (:7 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :8 )) --?? OR (sale_area_type = '30' AND (:9 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :10 )) --??? OR (sale_area_type = '20' AND (:11 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :12 )) --?? OR (sale_area_type = '10' AND sale_area_code = 'ZZZZ') --?? ) AND start_date <= SYSDATE AND SYSDATE <= end_date) ) order by PRODUCT_MODE, b.item_index, a.start_date, a.product_name, A.RSRV_VALUE2

9d5gtsgdqdbdd SELECT seq_trade_id_poc.nextval FROM DUAL

9q5jas50b88ud ** SQL Text Not Available **

9tv4b1adcgh6y ** SQL Text Not Available **

9uz82r5qakdrr SELECT B.STANDARD_KIND_CODE FROM TD_M_CHANNEL A, TD_M_DEPARTKIND B WHERE A.REAL_DEPART_ID = :1 AND A.CHANNEL_TYPE_ID = B.DEPART_KIND_CODE AND B.EPARCHY_CODE = :2 AND A.CHANNEL_STATE = '10'

9v56t5yjn5fvs ** SQL Text Not Available **

9v9n97qj8z1dg delete /*+ dynamic_sampling(4) */ from sys.wri$_optstat_histhead_history where savtime < :1 and rownum <= NVL(:2, rownum)

9zygxum4pups3 select F_SYS_GETSEQID('0731', 'seq_operate_id') from dual

a08zzuwf4busj SELECT SQL_TEXT FROM V$OPEN_CURSOR WHERE UPPER(SQL_TEXT) LIKE 'ALTER%' OR UPPER(SQL_TEXT) LIKE 'DROP%' OR UPPER(SQL_TEXT) LIKE 'GRANT%' OR UPPER(SQL_TEXT) LIKE 'REVOKE%' OR UPPER(SQL_TEXT) LIKE 'RENAME%'

as1vfbtbaq488 select t1.*, f_csm_getelementLimit(t1.element_id, t1.element_type_code, '0', :1 ) MUTEX_STR, f_csm_getelementLimit(t1.element_id, t1.element_type_code, '2', :2 ) RELY_STR FROM (SELECT PACKAGE_ID, ELEMENT_TYPE_CODE, ELEMENT_ID, FORCE_TAG, DEFAULT_TAG, B.ENABLE_TAG, B.DISCNT_NAME ELEMENT_NAME, B.DISCNT_EXPLAIN ELEMENT_DESC, to_char(B.START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, B.START_OFFSET, B.START_UNIT, B.END_ENABLE_TAG, to_char(B.END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, B.END_OFFSET, B.END_UNIT, ITEM_INDEX, -1 SCORE, -1 REWARD_LIMIT, '-1' SP_PRODUCT_ID, '-1' PARTY_ID, '-1' SP_ID, '-1' PARAMVALUE, (SELECT COUNT(1) FROM td_s_interface_ctrl WHERE (PROVINCE_CODE='ZZZZ' OR PROVINCE_CODE=(SELECT tag_info FROM td_s_tag WHERE tag_code ='PUB_CUR_PROVINCE' and subsys_code = 'PUB' and use_tag ='0' and end_date>sysdate and eparchy_code ='ZZZZ' and rownum<2)) and intf_context_code = 'DISCNT_'||TO_CHAR(b.discnt_code) AND (area_code =:3 OR area_co de=:4 OR area_code='ZZZZ') ) HAS_ATTR FROM TD_B_PACKAGE_ELEMENT a, TD_B_DISCNT b WHERE package_id = :5 AND SYSDATE BETWEEN a.start_date AND a.end_date AND element_type_code = 'D' AND a.element_id = b.discnt_code AND SYSDATE BETWEEN b.start_date AND b.end_date UNION ALL SELECT PACKAGE_ID, ELEMENT_TYPE_CODE, ELEMENT_ID, FORCE_TAG, DEFAULT_TAG, '' ENABLE_TAG, D.SERVICE_NAME ELEMENT_NAME, '' ELEMENT_DESC, '' START_ABSOLUTE_DATE, 0 START_OFFSET, '' START_UNIT, (select nvl(attr_value, '') from td_b_service_item s1 where s1.SERVICE_ID= d.SERVICE_ID and s1.ATTR_CODE ='SERVICE_MODIFY_TAG') END_ENABLE_TAG, '' END_ABSOLUTE_DATE, 0 END_OFFSET, '' END_UNIT, ITEM_INDEX, -1 SCORE, -1 REWARD_LIMIT, '-1' SP_PRODUCT_ID, '-1' PARTY_ID, '-1' SP_ID, '-1' PARAMVALUE, (SELECT COUNT(1) FROM td_s_interface_ctrl WHERE (PROVINCE_CODE='ZZZZ' OR PROVINCE_CODE=(SELECT tag_info FROM td_s_tag WHERE tag_code ='PUB_CUR_PROVINCE' and subsys_code = 'PUB' and use_tag ='0' and end_date>sysdate and eparchy_code ='ZZZZ' and rownum<2)) and intf_context_code = 'SERVICE_'||TO_CHAR(d.service_id) AND (area_code =:6 OR area_code=:7 OR area_code='ZZZZ') ) HAS_ATTR FROM TD_B_PACKAGE_ELEMENT c, TD_B_SERVICE d WHERE package_id = :8 AND SYSDATE BETWEEN c.start_date AND c.end_date AND element_type_code = 'S' AND c.element_id = d.service_id AND SYSDATE BETWEEN d.start_date AND d.end_date )t1 WHERE (substr(:9 , -8)= 'SUPERUSR' OR t1.element_type_code IN ('C', 'A') OR EXISTS (SELECT 1 FROM tf_m_staffdataright E, tf_m_roledataright F WHERE E.staff_id=:10 AND E.data_code=F.role_code AND E.right_attr='1' AND E.right_tag='1' AND F.data_type=t1.ELEMENT_TYPE_CODE AND F.data_code=TO_CHAR(t1.element_id))OR EXISTS (SELECT 1 FROM tf_m_roledataright T2 WHERE T2.data_type = t1.ELEMENT_TYPE_CODE AND T2.data_code = TO_CHAR(t1.element_id) AND T2.ROLE_CODE = '09ZZZZZZ') ) AND (NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE (id_type = '1' AND t1.element_type_code = 'D' OR id_type = '2' AND t1.element_type_code = 'S') AND t1.element_id = pid AND start_date <= SYSDATE AND SYSDATE <= end_date) OR EXISTS(SELECT 1 FROM td_b_product_salearea WHERE (id_type = '1' AND t1.element_type_code = 'D' OR id_type = '2' AND t1.element_type_code = 'S') AND t1.element_id = pid AND ((sale_area_type = '40' AND (:11 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :12 )) OR (sale_area_type = '30' AND (:13 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :14 )) OR (sale_area_type = '20' AND (:15 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :16 )) OR (sale_area_type = '10' AND sale_area_code = 'ZZZZ')) AND start_date <= SYSDATE AND SYSDATE <= end_date)) ORDER BY ITEM_INDEX

attz06s9rcfwr select F_SYS_GETSEQID('0903', 'seq_operate_id') from dual

aypazt06z7fq8 SELECT * FROM (SELECT S.ROWID RECORDID, S.SMS_NOTICE_ID, S.EPARCHY_CODE, S.SMS_CHANNEL_CODE, S.SEND_OBJECT_CODE, C.SEND_OBJECT, C.SEND_OBJECT_DESC, S.SEND_TIME_CODE, S.SEND_COUNT_CODE, S.RECV_OBJECT_TYPE, S.RECV_OBJECT, S.ID, S.SMS_TYPE_CODE, S.SMS_KIND_CODE, S.NOTICE_CONTENT_TYPE, S.NOTICE_CONTENT, S.FORCE_REFER_COUNT, S.FORCE_OBJECT, S.FORCE_START_TIME, S.FORCE_END_TIME, S.SMS_PRIORITY, S.REFER_TIME, S.REFER_STAFF_ID, S.REFER_DEPART_ID, S.DEAL_TIME, S.DEAL_STAFFID, S.DEAL_DEPARTID, S.DEAL_STATE, S.REMARK, S.REVC1, S.REVC2, S.REVC3, S.REVC4 FROM TD_B_SENDTIME A, TD_B_SENDOBJECT C, TI_O_SMS S WHERE S.month = to_number(to_char(sysdate , 'mm')) AND A.SEND_TIME_CODE = S.SEND_TIME_CODE AND S.SEND_OBJECT_CODE = C.SEND_OBJECT_CODE AND (A.EPARCHY_CODE = 'ZZZZ' OR (A.EPARCHY_CODE <> 'ZZZZ' AND A.EPARCHY_CODE = S.EPARCHY_CODE)) AND (C.EPARCHY_CODE = 'ZZZZ' OR (C.EPARCHY_CODE <> 'ZZZZ' AND C.EPARCHY_CODE = S.EPARCHY_CODE)) AND TO_CHAR(SYSDATE, 'HH24 MISS') >= TRIM(SMS_START_TIME) AND TO_CHAR(SYSDATE, 'HH24MISS') <= TRIM(SMS_END_TIME) AND S.DEAL_STATE = '0' and MOD(S.SMS_NOTICE_ID, 20) = :1 ORDER BY SMS_PRIORITY DESC ) WHERE 1 = 1 AND rownum <= :2

b6usrg82hwsa3 call dbms_stats.gather_database_stats_job_proc ( )

bbz1fycndc735 select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"OPERED_STAFF_ID" val, ntile(254) over (order by nlssort("OPERED_STAFF_ID", 'NLS_SORT = binary')) bkt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPERED_STAFF_ID" is not null) group by val) group by maxbkt order by maxbkt

bcda3mffuntad SELECT A.PRODUCT_ID, PRODUCT_NAME, PRODUCT_EXPLAIN, PRODUCT_MODE, NET_TYPE_CODE, BRAND_CODE, GROUP_BRAND_CODE, SERVICE_ID, PRODUCT_OBJ_TYPE, a.RES_TYPE_CODE, DECLARED_PRODUCT_ID, COMP_TAG, ENABLE_TAG, to_char(START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, START_OFFSET, START_UNIT, END_ENABLE_TAG, to_char(END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, END_OFFSET, END_UNIT, to_char(A.START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(A.END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, MIN_NUMBER, MAX_NUMBER, VERSION, PRODUCT_STATE, b.USE_TAG, a.PREPAY_TAG, a.NEED_EXP, B.product_type_code FROM td_b_ptype_product B, TD_B_PRODUCT A, td_s_productlimit C, TD_S_PROD_RES_REL d WHERE B.product_type_code=:1 AND B.ROOT=:2 AND sysdate BETWEEN B.start_date AND B.end_date AND sysdate BETWEEN A.start_date AND A.end_date AND A.product_id=B.product_id AND a.PRODUCT_ID = C.PRODUCT_ID_A AND (C.PRODUCT_ID_B = :3 OR C.PRODUCT_ID_B=-1) AND c.LIMIT_TAG = 'S' AND sysdate BE TWEEN C.start_date AND C.end_date AND D.product_id = a.PRODUCT_ID AND (D.DEVICE_BRAND = :4 or D.DEVICE_BRAND ='-1') AND (D.EPARCHY_CODE =:5 OR D.EPARCHY_CODE='ZZZZ') AND sysdate BETWEEN D.start_date AND D.end_date AND EXISTS (SELECT 1 FROM td_b_product_release WHERE product_id=A.product_id AND (release_area_code = 'ZZZZ' OR release_area_code=:6 OR release_area_code=:7 ) AND sysdate BETWEEN start_date AND end_date) AND (substr(:8 , -8)= 'SUPERUSR' OR EXISTS (SELECT /*+ index(D, PK_TF_M_ROLEDATARIGHT)*/ 1 FROM tf_m_staffdataright C, tf_m_roledataright D WHERE C.staff_id=:9 AND C.data_code=D.role_code AND C.right_attr='1' --???? 1-?????? AND C.right_tag='1' --???? 1-?? AND D.data_type='P' --???? 2-???? AND D.data_code=TO_CHAR(A.product_id)) OR EXISTS (SELECT 1 FROM tf_m_roledataright T2 WHERE T2.data_type = 'P' AND T2.data_code = TO_CHAR(A.product_id) AND T2.ROLE_CODE = '09ZZZZZZ')) AND ( NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND start_d ate <= SYSDATE AND SYSDATE <= end_date) OR EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND ( (sale_area_type = '40' AND (:10 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :11 )) --?? OR (sale_area_type = '30' AND (:12 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :13 )) --??? OR (sale_area_type = '20' AND (:14 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :15 )) --?? OR (sale_area_type = '10' AND sale_area_code = 'ZZZZ') --?? ) AND start_date <= SYSDATE AND SYSDATE <= end_date) ) order by PRODUCT_MODE, b.item_index, b.PRODUCT_ID

bgcz0c964znq0 /* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("RIGHT_CODE")), to_char(substrb(dump(min("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPERED_STAFF_ID")), to_char(substrb(dump(min("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_ATTR")), to_char(substrb(dump(min("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(count("LOG_ID")), to_char(substrb(dump(min("LOG_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LOG_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_TYPE")), to_char(substrb(dump(min("OPER_TYPE "), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_TYPE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_TYPE")), to_char(substrb(dump(min("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(count("ROLE_CODE")), to_char(substrb(dump(min("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(count("AREA_CODE")), to_char(substrb(dump(min("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPER_STAFF_ID")), to_char(substrb(dump(min("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DEPART_ID")), to_char(substrb(dump(min("OPER_DEPART_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DEP ART_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DATE")), to_char(substrb(dump(min("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_CLASS")), to_char(substrb(dump(min("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(count("OPER_SPECIAL")), to_char(substrb(dump(min("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(count("TERM_IP")), to_char(substrb(dump(min("TERM_IP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TERM_IP"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE1")), to_char(substrb(dump(min("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE2 ")), to_char(substrb(dump(min("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE1")), to_char(substrb(dump(min("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE2")), to_char(substrb(dump(min("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(count("USE_TAG")), to_char(substrb(dump(min("USE_TAG"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("USE_TAG"), 16, 0, 32), 1, 120)), to_char(count("TIMES")), to_char(substrb(dump(min("TIMES"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TIMES"), 16, 0, 32), 1, 120)), to_char(count("START_DATE")), to_char(substrb(dump(min("START_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max( "START_DATE"), 16, 0, 32), 1, 120)), to_char(count("END_DATE")), to_char(substrb(dump(min("END_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("END_DATE"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR1")), to_char(substrb(dump(min("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR2")), to_char(substrb(dump(min("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR3")), to_char(substrb(dump(min("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR4")), to_char(substrb(dump(min("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR5")), to_char(subs trb(dump(min("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(count("REMARK")), to_char(substrb(dump(min("REMARK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REMARK"), 16, 0, 32), 1, 120)), to_char(count("PROVINCE_CODE")), to_char(substrb(dump(min("PROVINCE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PROVINCE_CODE"), 16, 0, 32), 1, 120)) from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn /* NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/

bya4d80vkp9t8 ** SQL Text Not Available **

bzscyq07w79ab delete /*+ dynamic_sampling(4) */ from sys.wri$_optstat_histgrm_history where savtime < :1 and rownum <= NVL(:2, rownum)

cuv4yub7sc5am ** SQL Text Not Available **

d1zf2gz3nh6p9 SELECT A.PRODUCT_ID, PRODUCT_NAME, PRODUCT_EXPLAIN, PRODUCT_MODE, NET_TYPE_CODE, BRAND_CODE, GROUP_BRAND_CODE, SERVICE_ID, PRODUCT_OBJ_TYPE, RES_TYPE_CODE, DECLARED_PRODUCT_ID, COMP_TAG, ENABLE_TAG, to_char(START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, START_OFFSET, START_UNIT, END_ENABLE_TAG, to_char(END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, END_OFFSET, END_UNIT, to_char(A.START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(A.END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, MIN_NUMBER, MAX_NUMBER, VERSION, PRODUCT_STATE, b.USE_TAG, a.PREPAY_TAG, a.NEED_EXP, B.product_type_code, C.attr_code, C.attr_value FROM td_b_ptype_product B, TD_B_PRODUCT A, td_b_product_item C WHERE B.product_type_code=:1 AND B.ROOT=:2 AND sysdate BETWEEN B.start_date AND B.end_date AND sysdate BETWEEN A.start_date AND A.end_date AND A.product_id=B.product_id AND C.product_id(+)=B.product_id AND EXISTS (SELECT 1 FROM td_b_product_release WHERE product_id=A.product_id AND (release_area_code = 'ZZZZ' OR release_area_code=:3 OR release_area_code=:4 ) AND sysdate BETWEEN start_date AND end_date) AND (substr(:5 , -8)= 'SUPERUSR' OR EXISTS (SELECT /*+ index(D, PK_TF_M_ROLEDATARIGHT)*/ 1 FROM tf_m_staffdataright C, tf_m_roledataright D WHERE C.staff_id=:6 AND C.data_code=D.role_code AND C.right_attr='1' --?????1-?????? AND C.right_tag='1' --?????1-?? AND D.data_type='P' --?????2-???? AND D.data_code=TO_CHAR(A.product_id))) AND ( NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND start_date <= SYSDATE AND SYSDATE <= end_date) OR EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND ( (sale_area_type = '40' AND (:7 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :8 )) --?? OR (sale_area_type = '30' AND (:9 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :10 )) --??? OR (sale_area_type = '20' AND (:11 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :12 )) - -?? OR (sale_area_type = '10' AND sale_area_code = 'ZZZZ') --?? ) AND start_date <= SYSDATE AND SYSDATE <= end_date) ) order by PRODUCT_MODE, b.item_index, b.PRODUCT_ID, A.RSRV_VALUE2

d8jh4bh83k9tz DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN BIG_CBSS_OPERATION.PR_MONITOR_DB; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

d9tmt2ddmhtua select substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */max("PROVINCE_CODE") val, count(*) cnt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "PROVINCE_CODE" is not null group by nlssort("PROVINCE_CODE", 'NLS_SORT = binary')) order by nlssort(val, 'NLS_SORT = binary')

danm6dqvz780s ** SQL Text Not Available **

ddkkhuy6g2xb3 select a.INTF_CONTEXT_CODE, a.INTF_ELEMENT_ID, a.SHOW_ORDER, a.RIGHT_CODE, a.AREA_CODE, a.ELEMENT_CODE, a.ELEMENT_TYPE, b.INTF_ELEMENT_TYPE_CODE, b.INTF_ELEMENT_PARAM, b.INTF_ELEMENT_LABEL, b.INTF_ELEMENT_HINT, b.INTF_ELEMENT_INIT_VALUE, b.INTF_ELEMENT_CAN_NULL, b.MODIFY_RIGHT_CODE, b.REG_EXPR, b.START_DATE, b.END_DATE from TD_S_INTERFACE_CTRL a, TD_S_INTF_ELEMENT b where a.INTF_CONTEXT_CODE = :1 and (a.AREA_CODE='ZZZZ' or a.AREA_CODE=:2 or a.AREA_CODE=:3 ) and a.INTF_ELEMENT_ID = b.INTF_ELEMENT_ID and b.END_DATE > SYSDATE order by a.SHOW_ORDER asc

dqn46uz4zdh6v ** SQL Text Not Available **

dw9qhngcst6c0 ** SQL Text Not Available **

dzan2tgvtkzdw ** SQL Text Not Available **

dzsjvy781bqf7 ** SQL Text Not Available **

f003dcq2fv4v9 select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"LOG_ID" val, ntile(254) over (order by "LOG_ID") bkt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "LOG_ID" is not null) group by val) group by maxbkt order by maxbkt

f62hx009yhd2p select substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */max("PROVINCE_CODE") val, count(*) cnt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "PROVINCE_CODE" is not null group by nlssort("PROVINCE_CODE", 'NLS_SORT = binary')) order by nlssort(val, 'NLS_SORT = binary')

fa0uzvspp236d ** SQL Text Not Available **

g63px48cs1j77 /* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("RIGHT_CODE")), to_char(substrb(dump(min("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPERED_STAFF_ID")), to_char(substrb(dump(min("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_ATTR")), to_char(substrb(dump(min("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(count("LOG_ID")), to_char(substrb(dump(min("LOG_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LOG_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_TYPE")), to_char(substrb(dump(min("OPER_TYPE "), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_TYPE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_TYPE")), to_char(substrb(dump(min("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(count("ROLE_CODE")), to_char(substrb(dump(min("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(count("AREA_CODE")), to_char(substrb(dump(min("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPER_STAFF_ID")), to_char(substrb(dump(min("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DEPART_ID")), to_char(substrb(dump(min("OPER_DEPART_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DEP ART_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DATE")), to_char(substrb(dump(min("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_CLASS")), to_char(substrb(dump(min("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(count("OPER_SPECIAL")), to_char(substrb(dump(min("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(count("TERM_IP")), to_char(substrb(dump(min("TERM_IP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TERM_IP"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE1")), to_char(substrb(dump(min("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE2 ")), to_char(substrb(dump(min("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE1")), to_char(substrb(dump(min("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE2")), to_char(substrb(dump(min("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(count("USE_TAG")), to_char(substrb(dump(min("USE_TAG"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("USE_TAG"), 16, 0, 32), 1, 120)), to_char(count("TIMES")), to_char(substrb(dump(min("TIMES"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TIMES"), 16, 0, 32), 1, 120)), to_char(count("START_DATE")), to_char(substrb(dump(min("START_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max( "START_DATE"), 16, 0, 32), 1, 120)), to_char(count("END_DATE")), to_char(substrb(dump(min("END_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("END_DATE"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR1")), to_char(substrb(dump(min("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR2")), to_char(substrb(dump(min("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR3")), to_char(substrb(dump(min("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR4")), to_char(substrb(dump(min("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR5")), to_char(subs trb(dump(min("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(count("REMARK")), to_char(substrb(dump(min("REMARK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REMARK"), 16, 0, 32), 1, 120)), to_char(count("PROVINCE_CODE")), to_char(substrb(dump(min("PROVINCE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PROVINCE_CODE"), 16, 0, 32), 1, 120)) from "UCR_CEN1"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN1"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn /* NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/

g6xh02jb0ccyr select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"RIGHT_CODE" val, ntile(254) over (order by nlssort("RIGHT_CODE", 'NLS_SORT = binary')) bkt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "RIGHT_CODE" is not null) group by val) group by maxbkt order by maxbkt

g8z3zsc07gyx8 ** SQL Text Not Available **

gfnm5kf4c4sv0 SELECT trim (PROVINCE_CODE) PROVINCE_CODE FROM td_m_staff WHERE staff_id=:1

ghc83bfjv10k2 ** SQL Text Not Available **

gj0q42166bt62 ** SQL Text Not Available **

gqwdr44z61uhc SELECT B.STAFF_ID, A.DEPART_ID FROM TD_M_DEPART A, TD_M_STAFF B WHERE A.DEPART_ID = B.DEPART_ID AND A.DEPART_ID IN (SELECT D.CHNL_ID FROM TD_CHL_KINDDEF C, TF_CHL_CHANNEL D WHERE C.CHNL_KIND_ID = D.CHNL_KIND_ID AND C.STANDARD_KIND_CODE LIKE '2%') AND B.STAFF_ID = :1 AND B.PROVINCE_CODE = :2 AND A.PROVINCE_CODE = B.PROVINCE_CODE

SQL Id	SQL Text
009gr1md7zsm3	/* SQL Analyze(1) / select /+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /to_char(count("RIGHT_CODE")), to_char(substrb(dump(min("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPERED_STAFF_ID")), to_char(substrb(dump(min("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_ATTR")), to_char(substrb(dump(min("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(count("LOG_ID")), to_char(substrb(dump(min("LOG_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LOG_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_TYPE")), to_char(substrb(dump(min("OPER_TYPE "), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_TYPE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_TYPE")), to_char(substrb(dump(min("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(count("ROLE_CODE")), to_char(substrb(dump(min("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(count("AREA_CODE")), to_char(substrb(dump(min("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPER_STAFF_ID")), to_char(substrb(dump(min("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DEPART_ID")), to_char(substrb(dump(min("OPER_DEPART_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DEP ART_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DATE")), to_char(substrb(dump(min("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_CLASS")), to_char(substrb(dump(min("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(count("OPER_SPECIAL")), to_char(substrb(dump(min("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(count("TERM_IP")), to_char(substrb(dump(min("TERM_IP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TERM_IP"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE1")), to_char(substrb(dump(min("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE2 ")), to_char(substrb(dump(min("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE1")), to_char(substrb(dump(min("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE2")), to_char(substrb(dump(min("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(count("USE_TAG")), to_char(substrb(dump(min("USE_TAG"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("USE_TAG"), 16, 0, 32), 1, 120)), to_char(count("TIMES")), to_char(substrb(dump(min("TIMES"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TIMES"), 16, 0, 32), 1, 120)), to_char(count("START_DATE")), to_char(substrb(dump(min("START_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max( "START_DATE"), 16, 0, 32), 1, 120)), to_char(count("END_DATE")), to_char(substrb(dump(min("END_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("END_DATE"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR1")), to_char(substrb(dump(min("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR2")), to_char(substrb(dump(min("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR3")), to_char(substrb(dump(min("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR4")), to_char(substrb(dump(min("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR5")), to_char(subs trb(dump(min("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(count("REMARK")), to_char(substrb(dump(min("REMARK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REMARK"), 16, 0, 32), 1, 120)), to_char(count("PROVINCE_CODE")), to_char(substrb(dump(min("PROVINCE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PROVINCE_CODE"), 16, 0, 32), 1, 120)) from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn / NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/
06h78ft4r6qsg	select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count() bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)count(val) repsq from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /"OPER_STAFF_ID" val, ntile(254) over (order by nlssort("OPER_STAFF_ID", 'NLS_SORT = binary')) bkt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_STAFF_ID" is not null) group by val) group by maxbkt order by maxbkt
0apbvns24jdc9	SQL Text Not Available
11gb0xb9vp04q	SQL Text Not Available
12hhcr6ucw6mb	SQL Text Not Available
18y91z1j9gkc2	SELECT eparchy_code, tag_code, tag_name, subsys_code, tag_info, tag_char, to_char(tag_number) tag_number, to_char(tag_date, 'yyyy-mm-dd hh24:mi:ss') tag_date, to_char(tag_sequid) tag_sequid, use_tag, to_char(start_date, 'yyyy-mm-dd hh24:mi:ss') start_date, to_char(end_date, 'yyyy-mm-dd hh24:mi:ss') end_date, remark, to_char(update_time, 'yyyy-mm-dd hh24:mi:ss') update_time, update_staff_id, update_depart_id FROM td_s_tag WHERE (eparchy_code = :1 OR eparchy_code = 'ZZZZ') and (PROVINCE_CODE = 'ZZZZ' or PROVINCE_CODE = (select parent_area_code from td_m_area where area_code = :2 )) AND tag_code = :3 AND subsys_code = :4 AND use_tag = :5 AND sysdate between start_date and END_date
1fuvut1mhzn6j	SQL Text Not Available
1nktcbcjqsfqv	SQL Text Not Available
1r9u733n8t67x	SQL Text Not Available
208kfzk3p5k5b	select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count() bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)count(val) repsq from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /"OPER_STAFF_ID" val, ntile(254) over (order by nlssort("OPER_STAFF_ID", 'NLS_SORT = binary')) bkt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_STAFF_ID" is not null) group by val) group by maxbkt order by maxbkt
25vwt55t1093f	SQL Text Not Available
28gw35yumb9th	SQL Text Not Available
2skrtuku00sn9	select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count() bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)count(val) repsq from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /"OPER_DATE" val, ntile(254) over (order by "OPER_DATE") bkt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_DATE" is not null) group by val) group by maxbkt order by maxbkt
2vrbg89c0b9c3	SELECT A.PRODUCT_ID, PRODUCT_NAME, PRODUCT_EXPLAIN, PRODUCT_MODE, NET_TYPE_CODE, BRAND_CODE, GROUP_BRAND_CODE, SERVICE_ID, PRODUCT_OBJ_TYPE, RES_TYPE_CODE, DECLARED_PRODUCT_ID, COMP_TAG, ENABLE_TAG, to_char(START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, START_OFFSET, START_UNIT, END_ENABLE_TAG, to_char(END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, END_OFFSET, END_UNIT, to_char(A.START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(A.END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, MIN_NUMBER, MAX_NUMBER, VERSION, PRODUCT_STATE, b.USE_TAG, a.PREPAY_TAG, (SELECT COUNT(1) FROM td_s_interface_ctrl WHERE (PROVINCE_CODE = 'ZZZZ' OR PROVINCE_CODE = (SELECT tag_info FROM td_s_tag WHERE tag_code = 'PUB_CUR_PROVINCE' and subsys_code = 'PUB' and use_tag = '0' and end_date > sysdate and eparchy_code = 'ZZZZ' and rownum < 2)) and intf_context_code = 'PRODUCT_' \|\| TO_CHAR(A.product_id) AND (area_code = :1 OR area_code = :2 OR area_code = 'ZZZZ')) HAS_AT TR, a.NEED_EXP FROM td_b_ptype_product B, TD_B_PRODUCT A WHERE B.product_type_code = :3 AND B.ROOT = :4 AND sysdate BETWEEN B.start_date AND B.end_date AND sysdate BETWEEN A.start_date AND A.end_date AND A.product_id = B.product_id and not exists (select 1 from td_b_product_item t where t.product_id = a.product_id and t.attr_code = 'WoXiang' and t.attr_value = '1') AND EXISTS (SELECT 1 FROM td_b_product_release WHERE product_id = A.product_id AND (release_area_code = 'ZZZZ' OR release_area_code = :5 OR release_area_code = :6 ) AND sysdate BETWEEN start_date AND end_date) AND (substr(:7 , -8) = 'SUPERUSR' OR EXISTS (SELECT 1 FROM tf_m_staffdataright C, tf_m_roledataright D WHERE C.staff_id = :8 AND C.data_code = D.role_code AND C.right_attr = '1' AND C.right_tag = '1' AND D.data_type = 'P' AND D.data_code = TO_CHAR(A.product_id))) and not exists (select 1 from td_s_product_trans f where f.product_id_a =:9 and f.product_id_b = a.product_id and f.trans_tag = 'A') AND NOT EXISTS (SELECT 1 FROM TD_B_PRODUCT_GROUP WHERE PRODUCT_ID = A.PRODUCT_ID AND SYSDATE BETWEEN START_DATE AND END_DATE AND (EPARCHY_CODE = 'ZZZZ' OR EPARCHY_CODE = :10 )) AND ( NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND start_date <= SYSDATE AND SYSDATE <= end_date) OR EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND ( (sale_area_type = '40' AND (:11 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :12 )) OR (sale_area_type = '30' AND (:13 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :14 )) OR (sale_area_type = '20' AND (:15 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :16 )) OR (sale_area_type = '10' AND sale_area_code = 'ZZZZ') ) AND start_date <= SYSDATE AND SYSDATE <= end_date) ) order by PRODUCT_MODE, b.item_index, a.start_date, a.product_name
32p6h39zdtvfk	select F_SYS_GETSEQID('89', 'seq_operate_id') from dual
390ngbpv69txy	SQL Text Not Available
3f3hn3fpjzjpc	SQL Text Not Available
3gwrz9gzta4g7	SQL Text Not Available
3qz5dycv2z4my	SELECT subsys_code, param_attr, param_code, param_name, para_code1, para_code2, para_code3, para_code4, para_code5, para_code6, para_code7, para_code8, para_code9, para_code10, para_code11, para_code12, para_code13, para_code14, para_code15, para_code16, para_code17, para_code18, para_code19, para_code20, para_code21, para_code22, para_code23, para_code24, para_code25, to_char(para_code26, 'yyyy-mm-dd hh24:mi:ss') para_code26, to_char(para_code27, 'yyyy-mm-dd hh24:mi:ss') para_code27, to_char(para_code28, 'yyyy-mm-dd hh24:mi:ss') para_code28, to_char(para_code29, 'yyyy-mm-dd hh24:mi:ss') para_code29, to_char(para_code30, 'yyyy-mm-dd hh24:mi:ss') para_code30, to_char(start_date, 'yyyy-mm-dd hh24:mi:ss') start_date, to_char(end_date, 'yyyy-mm-dd hh24:mi:ss') end_date, eparchy_code, remark, update_staff_id, update_depart_id, to_char(update_time, 'yyyy-mm-dd hh24:mi:ss') update_time FROM td_s_commpara WHERE (subsys_code=:1 AND param_attr=:2 AND param_code=:3 AND para_code1=:4 AND sysdate B ETWEEN start_date AND end_date) AND (eparchy_code=:5 OR eparchy_code='ZZZZ') and (PROVINCE_CODE = 'ZZZZ' or PROVINCE_CODE = (select parent_area_code from td_m_area where area_code =:6 ))
3r98xda66pqkg	SELECT seq_operate_id.nextval FROM DUAL
4cduyz74jf1np	SQL Text Not Available
4jpt2hpaf3115	select F_SYS_GETSEQID('0731', 'seq_trade_id_poc') from dual
520mkxqpf15q8	select 1 from dual
52wa1g9zbygsk	SQL Text Not Available
5366v39r5n5ux	SQL Text Not Available
572fbaj0fdw2b	select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
5bp43151r7ux2	SELECT /+INDEX(s PK_TF_M_STAFFFUNCRIGHT)/ f.right_code RIGHT_CODE, f.right_name RIGHT_NAME, m.mod_name MOD_NAME, m.mod_type MOD_TYPE FROM tf_m_stafffuncright s, td_m_funcright f, td_s_modfile m WHERE s.right_attr='0' AND s.right_tag='1' AND f.right_attr='0' AND m.mod_code=f.mod_code AND s.right_code=f.right_code AND s.province_code=f.province_code AND f.province_code=m.province_code AND (s.rsvalue1 IS NULL OR s.rsvalue1 != '1') AND s.staff_id = :1 AND s.depart_id = :2 AND s.province_code = :3 UNION SELECT /+INDEX(s PK_TF_M_STAFFFUNCRIGHT)/ NVL(f.right_code, ' ') RIGHT_CODE, f.right_name RIGHT_NAME, m.mod_name MOD_NAME, m.mod_type MOD_TYPE FROM tf_m_stafffuncright s, td_m_funcright f, tf_m_rolefuncright r, td_s_modfile m WHERE s.right_attr='1' AND s.right_tag='1' AND s.right_code=r.role_code AND r.right_code=f.right_code AND m.mod_code=f.mod_code AND s.province_code=f.province_code AND f.province_code=m.province_code AND m.province_code=r.province_code AND (r.rsvalue1 IS NULL OR r .rsvalue1 != '1') AND (s.rsvalue1 IS NULL OR s.rsvalue1 != '1') AND NOT EXISTS(SELECT 1 FROM tf_m_stafffuncright WHERE staff_id=s.staff_id AND right_code=r.right_code AND province_code=r.province_code AND r.province_code = :4 AND (right_tag='0' OR rsvalue1 = '1' )) AND s.staff_id = :5 AND s.depart_id = :6 AND s.province_code = :7 UNION SELECT f.right_code RIGHT_CODE, f.right_name RIGHT_NAME, m.mod_name MOD_NAME, m.mod_type MOD_TYPE FROM td_m_funcright f, td_s_modfile m WHERE f.right_attr='0' AND f.class_code='PUB' AND f.province_code = :8 AND f.mod_code=m.mod_code AND f.province_code=m.province_code
5d7jn0g21z6zf	SQL Text Not Available
5fcqwwcwv1k6k	select substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /max("OPER_TYPE") val, count(*) cnt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_TYPE" is not null group by nlssort("OPER_TYPE", 'NLS_SORT = binary')) order by nlssort(val, 'NLS_SORT = binary')
5k0m9p5r81awv	SQL Text Not Available
5m6h90d4pbpfy	SELECT seq_trade_id.nextval FROM DUAL
5qg4x6s73p8zj	select a.dev_code STAFF_ID, a.chnl_code DEPART_ID, b.depart_name DEPART_NAME, a.dev_name STAFF_NAME, a.linkman_phone SERIAL_NUMBER from td_m_developer a, td_m_depart b, td_m_channel c where a.chnl_code = c.depart_id and b.depart_id = c.real_depart_id and a.dev_code=:1 AND a.province_code = :2 AND a.eparchy_code = :3 union all SELECT STAFF_ID, TD_M_STAFF.DEPART_ID DEPART_ID, TD_M_DEPART.DEPART_NAME DEPART_NAME, STAFF_NAME, SERIAL_NUMBER FROM TD_M_STAFF, TD_M_DEPART WHERE TD_M_STAFF.DEPART_ID = TD_M_DEPART.DEPART_ID and TD_M_STAFF.STAFF_ID=:4 and TD_M_STAFF.PROVINCE_CODE= :5 and TD_M_STAFF.EPARCHY_CODE= :6
5xg08nhhywxwx	select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count() bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)count(val) repsq from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /"RIGHT_CODE" val, ntile(254) over (order by nlssort("RIGHT_CODE", 'NLS_SORT = binary')) bkt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "RIGHT_CODE" is not null) group by val) group by maxbkt order by maxbkt
60q0qbx52q4hg	SELECT /+ use_nl(a, b)/ a.PRODUCT_ID, a.PACKAGE_ID, b.PACKAGE_NAME, b.PACKAGE_TYPE_CODE, b.PACKAGE_DESC, a.FORCE_TAG, a.DEFAULT_TAG, DECODE(:1 , 0, b.MIN_NUMBER, a.MIN_NUMBER) MIN_NUMBER, DECODE(:2 , 0, b.MAX_NUMBER, a.MAX_NUMBER) MAX_NUMBER, a.RSRV_STR1, a.RSRV_STR2, to_char(a.START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(a.END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, a.EPARCHY_CODE, a.UPDATE_STAFF_ID, a.UPDATE_DEPART_ID, to_char(a.UPDATE_TIME, 'yyyy-mm-dd hh24:mi:ss') UPDATE_TIME, a.ITEM_INDEX, b.NEED_EXP FROM TD_B_PRODUCT_PACKAGE a, TD_B_PACKAGE b, td_b_product c WHERE a.PRODUCT_ID = :3 AND a.PRODUCT_ID = c.PRODUCT_ID AND (c.BRAND_CODE != 'FMLY' OR c.BRAND_CODE IS NULL) AND SYSDATE BETWEEN a.START_DATE AND a.end_date AND SYSDATE BETWEEN c.START_DATE AND c.end_date AND (a.EPARCHY_CODE = :4 OR a.EPARCHY_CODE = 'ZZZZ') AND b.PACKAGE_ID = a.PACKAGE_ID AND (substr(:5 , -8) = 'SUPERUSR' OR EXISTS (SELECT /+ index(F, PK_TF_M_ROLEDATARIGHT)/ 1 FR OM tf_m_staffdataright E, tf_m_roledataright F WHERE E.staff_id = :6 AND E.data_code = F.role_code AND E.right_attr = '1' --????-1-?????? AND E.right_tag = '1' --????-1-?? AND F.data_type = 'K' --????-k-??? AND F.data_code = TO_CHAR(a.PACKAGE_ID)) OR EXISTS (SELECT 1 FROM tf_m_roledataright T1 WHERE T1.data_type = 'K' AND T1.data_code = TO_CHAR(a.PACKAGE_ID) AND T1.ROLE_CODE = '09ZZZZZZ') ) ORDER BY ITEM_INDEX
611n9wc4an0v0	select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count() bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)count(val) repsq from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /"OPER_DATE" val, ntile(254) over (order by "OPER_DATE") bkt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_DATE" is not null) group by val) group by maxbkt order by maxbkt
63kf3an2j0pkc	insert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue, colname) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue, :4 from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2
6d1jnnuhkt8wy	SQL Text Not Available
6dyg6rzs06r7x	declare ipaddr varchar2(20); STEXT VARCHAR2(4000); BEGIN begin select sys_context('USERENV', 'IP_ADDRESS') into ipaddr FROM dual; exception when others then ipaddr:='-'; end; begin select SQL_TEXT INTO STEXT FROM v$open_cursor WHERE UPPER(sql_text) LIKE 'ALTER%' or UPPER(sql_text) LIKE 'DROP%' or UPPER(sql_text) LIKE 'GRANT%' or UPPER(sql_text) LIKE 'REVOKE%' or UPPER(sql_text) LIKE 'RENAME%'; exception when others then STEXT:='-'; end; insert into sys.stat$log_DDL values (sysdate, user, nvl (ipaddr, '-'), NVL(ora_dict_obj_name, '-'), NVL(ORA_SYSEVENT, '-'), NVL(ora_dict_obj_type, '-'), NVL(ora_dict_obj_owner, '-'), STEXT, to_char(sysdate, 'yyyymmdd') ); exception when others then null; END;
6yha0qjjasqxg	SQL Text Not Available
6z6b3mrbuz0rb	select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count() bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)count(val) repsq from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /"LOG_ID" val, ntile(254) over (order by "LOG_ID") bkt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "LOG_ID" is not null) group by val) group by maxbkt order by maxbkt
71x92bbqtmncu	SELECT staff_id, depart_id, staff_name, job_code, manager_info, sex, email, user_pid, serial_number, to_char(cust_id) cust_id, dimission_tag, to_char(birthday, 'yyyy-mm-dd hh24:mi:ss') birthday, staff_group_id as group_id, cust_hobyy, manager_staff_id, receive_type_code, login_flag, cust_manager_flag, city_code, eparchy_code, remark, rsvalue1, rsvalue2, to_char(update_time, 'yyyy-mm-dd hh24:mi:ss') update_time, update_staff_id, update_depart_id, province_code FROM td_m_staff WHERE staff_id=:1 AND province_code = :2
76prgq1x4k2z3	SQL Text Not Available
7cfzjgyugq476	SQL Text Not Available
7h35uxf5uhmm1	select sysdate from dual
7huyhmb57bj7j	SELECT SQL_STMT FROM code_code WHERE tab_name= :1 AND sql_ref = :2
7ntngwmf9bf4p	SQL Text Not Available
7p8xsztygapnq	select substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /max("OPER_TYPE") val, count(*) cnt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPER_TYPE" is not null group by nlssort("OPER_TYPE", 'NLS_SORT = binary')) order by nlssort(val, 'NLS_SORT = binary')
86v8m3jqnpxmu	SQL Text Not Available
8amf6x2gf6cfr	SQL Text Not Available
8gfgrw6whsawh	SELECT subsys_code, param_attr, param_code, param_name, para_code1, para_code2, para_code3, para_code4, para_code5, para_code6, para_code7, para_code8, para_code9, para_code10, para_code11, para_code12, para_code13, para_code14, para_code15, para_code16, para_code17, para_code18, para_code19, para_code20, para_code21, para_code22, para_code23, para_code24, para_code25, to_char(para_code26, 'yyyy-mm-dd hh24:mi:ss') para_code26, to_char(para_code27, 'yyyy-mm-dd hh24:mi:ss') para_code27, to_char(para_code28, 'yyyy-mm-dd hh24:mi:ss') para_code28, to_char(para_code29, 'yyyy-mm-dd hh24:mi:ss') para_code29, to_char(para_code30, 'yyyy-mm-dd hh24:mi:ss') para_code30, to_char(start_date, 'yyyy-mm-dd hh24:mi:ss') start_date, to_char(end_date, 'yyyy-mm-dd hh24:mi:ss') end_date, eparchy_code, remark, update_staff_id, update_depart_id, to_char(update_time, 'yyyy-mm-dd hh24:mi:ss') update_time FROM td_s_commpara WHERE (subsys_code = :1 AND param_attr = :2 AND param_code = to_char(:3 ) AND sysdate BETWEEN start_date AND end_date) AND (eparchy_code = :4 OR eparchy_code = 'ZZZZ') and (PROVINCE_CODE = 'ZZZZ' or PROVINCE_CODE = (select parent_area_code from td_m_area where area_code =:5 )) ORDER BY remark
8q7ppcdk6rvch	SQL Text Not Available
8tsfqd4prv88g	select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count() bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)count(val) repsq from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /"OPERED_STAFF_ID" val, ntile(254) over (order by nlssort("OPERED_STAFF_ID", 'NLS_SORT = binary')) bkt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPERED_STAFF_ID" is not null) group by val) group by maxbkt order by maxbkt
8z7x4pvgkp15f	SELECT A.PRODUCT_ID, PRODUCT_NAME, PRODUCT_EXPLAIN, PRODUCT_MODE, NET_TYPE_CODE, BRAND_CODE, GROUP_BRAND_CODE, SERVICE_ID, PRODUCT_OBJ_TYPE, RES_TYPE_CODE, DECLARED_PRODUCT_ID, COMP_TAG, ENABLE_TAG, to_char(START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, START_OFFSET, START_UNIT, END_ENABLE_TAG, to_char(END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, END_OFFSET, END_UNIT, to_char(A.START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(A.END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, MIN_NUMBER, MAX_NUMBER, VERSION, PRODUCT_STATE, b.USE_TAG, a.PREPAY_TAG, a.NEED_EXP, B.product_type_code FROM td_b_ptype_product B, TD_B_PRODUCT A WHERE B.product_type_code=:1 AND B.ROOT=:2 AND sysdate BETWEEN B.start_date AND B.end_date AND sysdate BETWEEN A.start_date AND A.end_date AND A.product_id=B.product_id AND A.PRODUCT_OBJ_TYPE != '1' AND EXISTS (SELECT 1 FROM td_b_product_release WHERE product_id=A.product_id AND (release_area_code = 'ZZZZ' OR release_area_code=: 3 OR release_area_code=:4 ) AND sysdate BETWEEN start_date AND end_date) AND (substr(:5 , -8)= 'SUPERUSR' OR EXISTS (SELECT /+ index(D, PK_TF_M_ROLEDATARIGHT)/ 1 FROM tf_m_staffdataright C, tf_m_roledataright D WHERE C.staff_id=:6 AND C.data_code=D.role_code AND C.right_attr='1' --?????1-?????? AND C.right_tag='1' --?????1-?? AND D.data_type='P' --?????2-???? AND D.data_code=TO_CHAR(A.product_id))) AND ( NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND start_date <= SYSDATE AND SYSDATE <= end_date) OR EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND ( (sale_area_type = '40' AND (:7 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :8 )) --?? OR (sale_area_type = '30' AND (:9 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :10 )) --??? OR (sale_area_type = '20' AND (:11 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :12 )) --?? OR (sale_area_type = '10' AND sale_area_code = 'ZZZZ') --?? ) AND start_date <= SYSDATE AND SYSDATE <= end_date) ) order by PRODUCT_MODE, b.item_index, a.start_date, a.product_name, A.RSRV_VALUE2
9d5gtsgdqdbdd	SELECT seq_trade_id_poc.nextval FROM DUAL
9q5jas50b88ud	SQL Text Not Available
9tv4b1adcgh6y	SQL Text Not Available
9uz82r5qakdrr	SELECT B.STANDARD_KIND_CODE FROM TD_M_CHANNEL A, TD_M_DEPARTKIND B WHERE A.REAL_DEPART_ID = :1 AND A.CHANNEL_TYPE_ID = B.DEPART_KIND_CODE AND B.EPARCHY_CODE = :2 AND A.CHANNEL_STATE = '10'
9v56t5yjn5fvs	SQL Text Not Available
9v9n97qj8z1dg	delete /+ dynamic_sampling(4) / from sys.wri$_optstat_histhead_history where savtime < :1 and rownum <= NVL(:2, rownum)
9zygxum4pups3	select F_SYS_GETSEQID('0731', 'seq_operate_id') from dual
a08zzuwf4busj	SELECT SQL_TEXT FROM V$OPEN_CURSOR WHERE UPPER(SQL_TEXT) LIKE 'ALTER%' OR UPPER(SQL_TEXT) LIKE 'DROP%' OR UPPER(SQL_TEXT) LIKE 'GRANT%' OR UPPER(SQL_TEXT) LIKE 'REVOKE%' OR UPPER(SQL_TEXT) LIKE 'RENAME%'
as1vfbtbaq488	select t1.*, f_csm_getelementLimit(t1.element_id, t1.element_type_code, '0', :1 ) MUTEX_STR, f_csm_getelementLimit(t1.element_id, t1.element_type_code, '2', :2 ) RELY_STR FROM (SELECT PACKAGE_ID, ELEMENT_TYPE_CODE, ELEMENT_ID, FORCE_TAG, DEFAULT_TAG, B.ENABLE_TAG, B.DISCNT_NAME ELEMENT_NAME, B.DISCNT_EXPLAIN ELEMENT_DESC, to_char(B.START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, B.START_OFFSET, B.START_UNIT, B.END_ENABLE_TAG, to_char(B.END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, B.END_OFFSET, B.END_UNIT, ITEM_INDEX, -1 SCORE, -1 REWARD_LIMIT, '-1' SP_PRODUCT_ID, '-1' PARTY_ID, '-1' SP_ID, '-1' PARAMVALUE, (SELECT COUNT(1) FROM td_s_interface_ctrl WHERE (PROVINCE_CODE='ZZZZ' OR PROVINCE_CODE=(SELECT tag_info FROM td_s_tag WHERE tag_code ='PUB_CUR_PROVINCE' and subsys_code = 'PUB' and use_tag ='0' and end_date>sysdate and eparchy_code ='ZZZZ' and rownum<2)) and intf_context_code = 'DISCNT_'\|\|TO_CHAR(b.discnt_code) AND (area_code =:3 OR area_co de=:4 OR area_code='ZZZZ') ) HAS_ATTR FROM TD_B_PACKAGE_ELEMENT a, TD_B_DISCNT b WHERE package_id = :5 AND SYSDATE BETWEEN a.start_date AND a.end_date AND element_type_code = 'D' AND a.element_id = b.discnt_code AND SYSDATE BETWEEN b.start_date AND b.end_date UNION ALL SELECT PACKAGE_ID, ELEMENT_TYPE_CODE, ELEMENT_ID, FORCE_TAG, DEFAULT_TAG, '' ENABLE_TAG, D.SERVICE_NAME ELEMENT_NAME, '' ELEMENT_DESC, '' START_ABSOLUTE_DATE, 0 START_OFFSET, '' START_UNIT, (select nvl(attr_value, '') from td_b_service_item s1 where s1.SERVICE_ID= d.SERVICE_ID and s1.ATTR_CODE ='SERVICE_MODIFY_TAG') END_ENABLE_TAG, '' END_ABSOLUTE_DATE, 0 END_OFFSET, '' END_UNIT, ITEM_INDEX, -1 SCORE, -1 REWARD_LIMIT, '-1' SP_PRODUCT_ID, '-1' PARTY_ID, '-1' SP_ID, '-1' PARAMVALUE, (SELECT COUNT(1) FROM td_s_interface_ctrl WHERE (PROVINCE_CODE='ZZZZ' OR PROVINCE_CODE=(SELECT tag_info FROM td_s_tag WHERE tag_code ='PUB_CUR_PROVINCE' and subsys_code = 'PUB' and use_tag ='0' and end_date>sysdate and eparchy_code ='ZZZZ' and rownum<2)) and intf_context_code = 'SERVICE_'\|\|TO_CHAR(d.service_id) AND (area_code =:6 OR area_code=:7 OR area_code='ZZZZ') ) HAS_ATTR FROM TD_B_PACKAGE_ELEMENT c, TD_B_SERVICE d WHERE package_id = :8 AND SYSDATE BETWEEN c.start_date AND c.end_date AND element_type_code = 'S' AND c.element_id = d.service_id AND SYSDATE BETWEEN d.start_date AND d.end_date )t1 WHERE (substr(:9 , -8)= 'SUPERUSR' OR t1.element_type_code IN ('C', 'A') OR EXISTS (SELECT 1 FROM tf_m_staffdataright E, tf_m_roledataright F WHERE E.staff_id=:10 AND E.data_code=F.role_code AND E.right_attr='1' AND E.right_tag='1' AND F.data_type=t1.ELEMENT_TYPE_CODE AND F.data_code=TO_CHAR(t1.element_id))OR EXISTS (SELECT 1 FROM tf_m_roledataright T2 WHERE T2.data_type = t1.ELEMENT_TYPE_CODE AND T2.data_code = TO_CHAR(t1.element_id) AND T2.ROLE_CODE = '09ZZZZZZ') ) AND (NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE (id_type = '1' AND t1.element_type_code = 'D' OR id_type = '2' AND t1.element_type_code = 'S') AND t1.element_id = pid AND start_date <= SYSDATE AND SYSDATE <= end_date) OR EXISTS(SELECT 1 FROM td_b_product_salearea WHERE (id_type = '1' AND t1.element_type_code = 'D' OR id_type = '2' AND t1.element_type_code = 'S') AND t1.element_id = pid AND ((sale_area_type = '40' AND (:11 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :12 )) OR (sale_area_type = '30' AND (:13 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :14 )) OR (sale_area_type = '20' AND (:15 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :16 )) OR (sale_area_type = '10' AND sale_area_code = 'ZZZZ')) AND start_date <= SYSDATE AND SYSDATE <= end_date)) ORDER BY ITEM_INDEX
attz06s9rcfwr	select F_SYS_GETSEQID('0903', 'seq_operate_id') from dual
aypazt06z7fq8	SELECT * FROM (SELECT S.ROWID RECORDID, S.SMS_NOTICE_ID, S.EPARCHY_CODE, S.SMS_CHANNEL_CODE, S.SEND_OBJECT_CODE, C.SEND_OBJECT, C.SEND_OBJECT_DESC, S.SEND_TIME_CODE, S.SEND_COUNT_CODE, S.RECV_OBJECT_TYPE, S.RECV_OBJECT, S.ID, S.SMS_TYPE_CODE, S.SMS_KIND_CODE, S.NOTICE_CONTENT_TYPE, S.NOTICE_CONTENT, S.FORCE_REFER_COUNT, S.FORCE_OBJECT, S.FORCE_START_TIME, S.FORCE_END_TIME, S.SMS_PRIORITY, S.REFER_TIME, S.REFER_STAFF_ID, S.REFER_DEPART_ID, S.DEAL_TIME, S.DEAL_STAFFID, S.DEAL_DEPARTID, S.DEAL_STATE, S.REMARK, S.REVC1, S.REVC2, S.REVC3, S.REVC4 FROM TD_B_SENDTIME A, TD_B_SENDOBJECT C, TI_O_SMS S WHERE S.month = to_number(to_char(sysdate , 'mm')) AND A.SEND_TIME_CODE = S.SEND_TIME_CODE AND S.SEND_OBJECT_CODE = C.SEND_OBJECT_CODE AND (A.EPARCHY_CODE = 'ZZZZ' OR (A.EPARCHY_CODE <> 'ZZZZ' AND A.EPARCHY_CODE = S.EPARCHY_CODE)) AND (C.EPARCHY_CODE = 'ZZZZ' OR (C.EPARCHY_CODE <> 'ZZZZ' AND C.EPARCHY_CODE = S.EPARCHY_CODE)) AND TO_CHAR(SYSDATE, 'HH24 MISS') >= TRIM(SMS_START_TIME) AND TO_CHAR(SYSDATE, 'HH24MISS') <= TRIM(SMS_END_TIME) AND S.DEAL_STATE = '0' and MOD(S.SMS_NOTICE_ID, 20) = :1 ORDER BY SMS_PRIORITY DESC ) WHERE 1 = 1 AND rownum <= :2
b6usrg82hwsa3	call dbms_stats.gather_database_stats_job_proc ( )
bbz1fycndc735	select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count() bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)count(val) repsq from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /"OPERED_STAFF_ID" val, ntile(254) over (order by nlssort("OPERED_STAFF_ID", 'NLS_SORT = binary')) bkt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "OPERED_STAFF_ID" is not null) group by val) group by maxbkt order by maxbkt
bcda3mffuntad	SELECT A.PRODUCT_ID, PRODUCT_NAME, PRODUCT_EXPLAIN, PRODUCT_MODE, NET_TYPE_CODE, BRAND_CODE, GROUP_BRAND_CODE, SERVICE_ID, PRODUCT_OBJ_TYPE, a.RES_TYPE_CODE, DECLARED_PRODUCT_ID, COMP_TAG, ENABLE_TAG, to_char(START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, START_OFFSET, START_UNIT, END_ENABLE_TAG, to_char(END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, END_OFFSET, END_UNIT, to_char(A.START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(A.END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, MIN_NUMBER, MAX_NUMBER, VERSION, PRODUCT_STATE, b.USE_TAG, a.PREPAY_TAG, a.NEED_EXP, B.product_type_code FROM td_b_ptype_product B, TD_B_PRODUCT A, td_s_productlimit C, TD_S_PROD_RES_REL d WHERE B.product_type_code=:1 AND B.ROOT=:2 AND sysdate BETWEEN B.start_date AND B.end_date AND sysdate BETWEEN A.start_date AND A.end_date AND A.product_id=B.product_id AND a.PRODUCT_ID = C.PRODUCT_ID_A AND (C.PRODUCT_ID_B = :3 OR C.PRODUCT_ID_B=-1) AND c.LIMIT_TAG = 'S' AND sysdate BE TWEEN C.start_date AND C.end_date AND D.product_id = a.PRODUCT_ID AND (D.DEVICE_BRAND = :4 or D.DEVICE_BRAND ='-1') AND (D.EPARCHY_CODE =:5 OR D.EPARCHY_CODE='ZZZZ') AND sysdate BETWEEN D.start_date AND D.end_date AND EXISTS (SELECT 1 FROM td_b_product_release WHERE product_id=A.product_id AND (release_area_code = 'ZZZZ' OR release_area_code=:6 OR release_area_code=:7 ) AND sysdate BETWEEN start_date AND end_date) AND (substr(:8 , -8)= 'SUPERUSR' OR EXISTS (SELECT /+ index(D, PK_TF_M_ROLEDATARIGHT)/ 1 FROM tf_m_staffdataright C, tf_m_roledataright D WHERE C.staff_id=:9 AND C.data_code=D.role_code AND C.right_attr='1' --???? 1-?????? AND C.right_tag='1' --???? 1-?? AND D.data_type='P' --???? 2-???? AND D.data_code=TO_CHAR(A.product_id)) OR EXISTS (SELECT 1 FROM tf_m_roledataright T2 WHERE T2.data_type = 'P' AND T2.data_code = TO_CHAR(A.product_id) AND T2.ROLE_CODE = '09ZZZZZZ')) AND ( NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND start_d ate <= SYSDATE AND SYSDATE <= end_date) OR EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND ( (sale_area_type = '40' AND (:10 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :11 )) --?? OR (sale_area_type = '30' AND (:12 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :13 )) --??? OR (sale_area_type = '20' AND (:14 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :15 )) --?? OR (sale_area_type = '10' AND sale_area_code = 'ZZZZ') --?? ) AND start_date <= SYSDATE AND SYSDATE <= end_date) ) order by PRODUCT_MODE, b.item_index, b.PRODUCT_ID
bgcz0c964znq0	/* SQL Analyze(1) / select /+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /to_char(count("RIGHT_CODE")), to_char(substrb(dump(min("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPERED_STAFF_ID")), to_char(substrb(dump(min("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_ATTR")), to_char(substrb(dump(min("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(count("LOG_ID")), to_char(substrb(dump(min("LOG_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LOG_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_TYPE")), to_char(substrb(dump(min("OPER_TYPE "), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_TYPE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_TYPE")), to_char(substrb(dump(min("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(count("ROLE_CODE")), to_char(substrb(dump(min("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(count("AREA_CODE")), to_char(substrb(dump(min("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPER_STAFF_ID")), to_char(substrb(dump(min("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DEPART_ID")), to_char(substrb(dump(min("OPER_DEPART_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DEP ART_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DATE")), to_char(substrb(dump(min("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_CLASS")), to_char(substrb(dump(min("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(count("OPER_SPECIAL")), to_char(substrb(dump(min("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(count("TERM_IP")), to_char(substrb(dump(min("TERM_IP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TERM_IP"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE1")), to_char(substrb(dump(min("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE2 ")), to_char(substrb(dump(min("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE1")), to_char(substrb(dump(min("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE2")), to_char(substrb(dump(min("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(count("USE_TAG")), to_char(substrb(dump(min("USE_TAG"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("USE_TAG"), 16, 0, 32), 1, 120)), to_char(count("TIMES")), to_char(substrb(dump(min("TIMES"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TIMES"), 16, 0, 32), 1, 120)), to_char(count("START_DATE")), to_char(substrb(dump(min("START_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max( "START_DATE"), 16, 0, 32), 1, 120)), to_char(count("END_DATE")), to_char(substrb(dump(min("END_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("END_DATE"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR1")), to_char(substrb(dump(min("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR2")), to_char(substrb(dump(min("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR3")), to_char(substrb(dump(min("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR4")), to_char(substrb(dump(min("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR5")), to_char(subs trb(dump(min("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(count("REMARK")), to_char(substrb(dump(min("REMARK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REMARK"), 16, 0, 32), 1, 120)), to_char(count("PROVINCE_CODE")), to_char(substrb(dump(min("PROVINCE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PROVINCE_CODE"), 16, 0, 32), 1, 120)) from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn / NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/
bya4d80vkp9t8	SQL Text Not Available
bzscyq07w79ab	delete /+ dynamic_sampling(4) / from sys.wri$_optstat_histgrm_history where savtime < :1 and rownum <= NVL(:2, rownum)
cuv4yub7sc5am	SQL Text Not Available
d1zf2gz3nh6p9	SELECT A.PRODUCT_ID, PRODUCT_NAME, PRODUCT_EXPLAIN, PRODUCT_MODE, NET_TYPE_CODE, BRAND_CODE, GROUP_BRAND_CODE, SERVICE_ID, PRODUCT_OBJ_TYPE, RES_TYPE_CODE, DECLARED_PRODUCT_ID, COMP_TAG, ENABLE_TAG, to_char(START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, START_OFFSET, START_UNIT, END_ENABLE_TAG, to_char(END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, END_OFFSET, END_UNIT, to_char(A.START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(A.END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, MIN_NUMBER, MAX_NUMBER, VERSION, PRODUCT_STATE, b.USE_TAG, a.PREPAY_TAG, a.NEED_EXP, B.product_type_code, C.attr_code, C.attr_value FROM td_b_ptype_product B, TD_B_PRODUCT A, td_b_product_item C WHERE B.product_type_code=:1 AND B.ROOT=:2 AND sysdate BETWEEN B.start_date AND B.end_date AND sysdate BETWEEN A.start_date AND A.end_date AND A.product_id=B.product_id AND C.product_id(+)=B.product_id AND EXISTS (SELECT 1 FROM td_b_product_release WHERE product_id=A.product_id AND (release_area_code = 'ZZZZ' OR release_area_code=:3 OR release_area_code=:4 ) AND sysdate BETWEEN start_date AND end_date) AND (substr(:5 , -8)= 'SUPERUSR' OR EXISTS (SELECT /+ index(D, PK_TF_M_ROLEDATARIGHT)/ 1 FROM tf_m_staffdataright C, tf_m_roledataright D WHERE C.staff_id=:6 AND C.data_code=D.role_code AND C.right_attr='1' --?????1-?????? AND C.right_tag='1' --?????1-?? AND D.data_type='P' --?????2-???? AND D.data_code=TO_CHAR(A.product_id))) AND ( NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND start_date <= SYSDATE AND SYSDATE <= end_date) OR EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND ( (sale_area_type = '40' AND (:7 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :8 )) --?? OR (sale_area_type = '30' AND (:9 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :10 )) --??? OR (sale_area_type = '20' AND (:11 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :12 )) - -?? OR (sale_area_type = '10' AND sale_area_code = 'ZZZZ') --?? ) AND start_date <= SYSDATE AND SYSDATE <= end_date) ) order by PRODUCT_MODE, b.item_index, b.PRODUCT_ID, A.RSRV_VALUE2
d8jh4bh83k9tz	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN BIG_CBSS_OPERATION.PR_MONITOR_DB; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
d9tmt2ddmhtua	select substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /max("PROVINCE_CODE") val, count(*) cnt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "PROVINCE_CODE" is not null group by nlssort("PROVINCE_CODE", 'NLS_SORT = binary')) order by nlssort(val, 'NLS_SORT = binary')
danm6dqvz780s	SQL Text Not Available
ddkkhuy6g2xb3	select a.INTF_CONTEXT_CODE, a.INTF_ELEMENT_ID, a.SHOW_ORDER, a.RIGHT_CODE, a.AREA_CODE, a.ELEMENT_CODE, a.ELEMENT_TYPE, b.INTF_ELEMENT_TYPE_CODE, b.INTF_ELEMENT_PARAM, b.INTF_ELEMENT_LABEL, b.INTF_ELEMENT_HINT, b.INTF_ELEMENT_INIT_VALUE, b.INTF_ELEMENT_CAN_NULL, b.MODIFY_RIGHT_CODE, b.REG_EXPR, b.START_DATE, b.END_DATE from TD_S_INTERFACE_CTRL a, TD_S_INTF_ELEMENT b where a.INTF_CONTEXT_CODE = :1 and (a.AREA_CODE='ZZZZ' or a.AREA_CODE=:2 or a.AREA_CODE=:3 ) and a.INTF_ELEMENT_ID = b.INTF_ELEMENT_ID and b.END_DATE > SYSDATE order by a.SHOW_ORDER asc
dqn46uz4zdh6v	SQL Text Not Available
dw9qhngcst6c0	SQL Text Not Available
dzan2tgvtkzdw	SQL Text Not Available
dzsjvy781bqf7	SQL Text Not Available
f003dcq2fv4v9	select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count() bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)count(val) repsq from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /"LOG_ID" val, ntile(254) over (order by "LOG_ID") bkt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "LOG_ID" is not null) group by val) group by maxbkt order by maxbkt
f62hx009yhd2p	select substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /max("PROVINCE_CODE") val, count(*) cnt from "UCR_CEN4"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN4"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "PROVINCE_CODE" is not null group by nlssort("PROVINCE_CODE", 'NLS_SORT = binary')) order by nlssort(val, 'NLS_SORT = binary')
fa0uzvspp236d	SQL Text Not Available
g63px48cs1j77	/* SQL Analyze(1) / select /+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /to_char(count("RIGHT_CODE")), to_char(substrb(dump(min("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPERED_STAFF_ID")), to_char(substrb(dump(min("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPERED_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_ATTR")), to_char(substrb(dump(min("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_ATTR"), 16, 0, 32), 1, 120)), to_char(count("LOG_ID")), to_char(substrb(dump(min("LOG_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LOG_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_TYPE")), to_char(substrb(dump(min("OPER_TYPE "), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_TYPE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_TYPE")), to_char(substrb(dump(min("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_TYPE"), 16, 0, 32), 1, 120)), to_char(count("ROLE_CODE")), to_char(substrb(dump(min("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ROLE_CODE"), 16, 0, 32), 1, 120)), to_char(count("AREA_CODE")), to_char(substrb(dump(min("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("AREA_CODE"), 16, 0, 32), 1, 120)), to_char(count("OPER_STAFF_ID")), to_char(substrb(dump(min("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_STAFF_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DEPART_ID")), to_char(substrb(dump(min("OPER_DEPART_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DEP ART_ID"), 16, 0, 32), 1, 120)), to_char(count("OPER_DATE")), to_char(substrb(dump(min("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_DATE"), 16, 0, 32), 1, 120)), to_char(count("RIGHT_CLASS")), to_char(substrb(dump(min("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RIGHT_CLASS"), 16, 0, 32), 1, 120)), to_char(count("OPER_SPECIAL")), to_char(substrb(dump(min("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPER_SPECIAL"), 16, 0, 32), 1, 120)), to_char(count("TERM_IP")), to_char(substrb(dump(min("TERM_IP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TERM_IP"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE1")), to_char(substrb(dump(min("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE1"), 16, 0, 32), 1, 120)), to_char(count("EXTEND_VALUE2 ")), to_char(substrb(dump(min("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EXTEND_VALUE2"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE1")), to_char(substrb(dump(min("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE1"), 16, 0, 32), 1, 120)), to_char(count("RSVALUE2")), to_char(substrb(dump(min("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSVALUE2"), 16, 0, 32), 1, 120)), to_char(count("USE_TAG")), to_char(substrb(dump(min("USE_TAG"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("USE_TAG"), 16, 0, 32), 1, 120)), to_char(count("TIMES")), to_char(substrb(dump(min("TIMES"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TIMES"), 16, 0, 32), 1, 120)), to_char(count("START_DATE")), to_char(substrb(dump(min("START_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max( "START_DATE"), 16, 0, 32), 1, 120)), to_char(count("END_DATE")), to_char(substrb(dump(min("END_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("END_DATE"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR1")), to_char(substrb(dump(min("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR1"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR2")), to_char(substrb(dump(min("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR2"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR3")), to_char(substrb(dump(min("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR3"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR4")), to_char(substrb(dump(min("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR4"), 16, 0, 32), 1, 120)), to_char(count("RSRV_STR5")), to_char(subs trb(dump(min("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RSRV_STR5"), 16, 0, 32), 1, 120)), to_char(count("REMARK")), to_char(substrb(dump(min("REMARK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("REMARK"), 16, 0, 32), 1, 120)), to_char(count("PROVINCE_CODE")), to_char(substrb(dump(min("PROVINCE_CODE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PROVINCE_CODE"), 16, 0, 32), 1, 120)) from "UCR_CEN1"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN1"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn / NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/
g6xh02jb0ccyr	select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count() bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)count(val) repsq from (select /+ no_expand_table(t) index_rs(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad /"RIGHT_CODE" val, ntile(254) over (order by nlssort("RIGHT_CODE", 'NLS_SORT = binary')) bkt from "UCR_CEN3"."TL_M_RIGHTLOG" t where TBL$OR$IDX$PART$NUM("UCR_CEN3"."TL_M_RIGHTLOG", 0, 4, 0, "ROWID") = :objn and "RIGHT_CODE" is not null) group by val) group by maxbkt order by maxbkt
g8z3zsc07gyx8	SQL Text Not Available
gfnm5kf4c4sv0	SELECT trim (PROVINCE_CODE) PROVINCE_CODE FROM td_m_staff WHERE staff_id=:1
ghc83bfjv10k2	SQL Text Not Available
gj0q42166bt62	SQL Text Not Available
gqwdr44z61uhc	SELECT B.STAFF_ID, A.DEPART_ID FROM TD_M_DEPART A, TD_M_STAFF B WHERE A.DEPART_ID = B.DEPART_ID AND A.DEPART_ID IN (SELECT D.CHNL_ID FROM TD_CHL_KINDDEF C, TF_CHL_CHANNEL D WHERE C.CHNL_KIND_ID = D.CHNL_KIND_ID AND C.STANDARD_KIND_CODE LIKE '2%') AND B.STAFF_ID = :1 AND B.PROVINCE_CODE = :2 AND A.PROVINCE_CODE = B.PROVINCE_CODE

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	1,485,792	822.99	160.61
execute count	155,375	86.06	16.80
gc cr block receive time	254	0.14	0.03
gc cr blocks received	2,115	1.17	0.23
gc current block receive time	18,017	9.98	1.95
gc current blocks received	126,664	70.16	13.69
logons cumulative	78	0.04	0.01
opened cursors cumulative	94,794	52.51	10.25
parse count (total)	60,730	33.64	6.56
parse time elapsed	342	0.19	0.04
physical reads	2,840,624	1,573.45	307.06
physical writes	18,329	10.15	1.98
redo size	126,996,244	70,344.31	13,727.84
session cursor cache hits	116,680	64.63	12.61
session logical reads	39,373,724	21,809.44	4,256.16
user calls	478,498	265.04	51.72
user commits	915	0.51	0.10
user rollbacks	8,336	4.62	0.90
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	13,676	7.58	1.48

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	45	0.02	0.00
Batched IO (full) vector count	6	0.00	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	2,664	1.48	0.29
Batched IO buffer defrag count	8	0.00	0.00
Batched IO double miss count	12	0.01	0.00
Batched IO same unit count	295	0.16	0.03
Batched IO single block count	23	0.01	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	2,348	1.30	0.25
Batched IO vector read count	40	0.02	0.00
Block Cleanout Optim referenced	127	0.07	0.01
CCursor + sql area evicted	154	0.09	0.02
CPU used by this session	34,261	18.98	3.70
CPU used when call started	9,333	5.17	1.01
CR blocks created	31	0.02	0.00
Cached Commit SCN referenced	11,879	6.58	1.28
Clusterwide global transactions	0	0.00	0.00
Commit SCN cached	72	0.04	0.01
DBWR checkpoint buffers written	11,762	6.52	1.27
DBWR checkpoints	4	0.00	0.00
DBWR fusion writes	156	0.09	0.02
DBWR object drop buffers written	0	0.00	0.00
DBWR parallel query checkpoint buffers written	0	0.00	0.00
DBWR tablespace checkpoint buffers written	84	0.05	0.01
DBWR transaction table writes	78	0.04	0.01
DBWR undo block writes	7,614	4.22	0.82
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	6	0.00	0.00
DX/BB enqueue lock background get time	0	0.00	0.00
DX/BB enqueue lock background gets	0	0.00	0.00
DX/BB enqueue lock foreground requests	0	0.00	0.00
Effective IO time	188,282	104.29	20.35
GTX processes spawned by autotune	0	0.00	0.00
GTX processes stopped by autotune	0	0.00	0.00
HSC Heap Segment Block Changes	168,747	93.47	18.24
Heap Segment Array Inserts	784	0.43	0.08
Heap Segment Array Updates	17	0.01	0.00
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	180	0.10	0.02
PX local messages recv'd	12	0.01	0.00
PX local messages sent	12	0.01	0.00
PX remote messages recv'd	24	0.01	0.00
PX remote messages sent	24	0.01	0.00
Parallel operations downgraded to serial	0	0.00	0.00
Parallel operations not downgraded	6	0.00	0.00
Requests to/from client	434,307	240.57	46.95
RowCR - row contention	0	0.00	0.00
RowCR attempts	6	0.00	0.00
RowCR hits	6	0.00	0.00
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	434,279	240.55	46.94
active txn count during cleanout	809	0.45	0.09
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	18,408	10.20	1.99
branch node splits	2	0.00	0.00
buffer is not pinned count	16,485,864	9,131.66	1,782.06
buffer is pinned count	62,237,364	34,473.81	6,727.64
bytes received via SQL*Net from client	42,732,908	23,670.13	4,619.27
bytes sent via SQL*Net to client	223,752,597	123,938.49	24,186.86
calls to get snapshot scn: kcmgss	1,205,999	668.01	130.36
calls to kcmgas	11,806	6.54	1.28
calls to kcmgcs	45,471	25.19	4.92
cell physical IO interconnect bytes	23,779,122,688	13,171,460.57	2,570,438.08
change write time	562	0.31	0.06
cleanout - number of ktugct calls	928	0.51	0.10
cleanouts and rollbacks - consistent read gets	9	0.00	0.00
cleanouts only - consistent read gets	96	0.05	0.01
cluster key scan block gets	42,925	23.78	4.64
cluster key scans	20,699	11.47	2.24
commit batch/immediate performed	116	0.06	0.01
commit batch/immediate requested	116	0.06	0.01
commit cleanout failures: block lost	15	0.01	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	135	0.07	0.01
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	11,974	6.63	1.29
commit cleanouts successfully completed	11,824	6.55	1.28
commit immediate performed	116	0.06	0.01
commit immediate requested	116	0.06	0.01
commit txn count during cleanout	580	0.32	0.06
consistent changes	546,136	302.51	59.04
consistent gets	36,739,647	20,350.41	3,971.42
consistent gets - examination	1,778,906	985.35	192.29
consistent gets direct	180	0.10	0.02
consistent gets from cache	36,739,467	20,350.31	3,971.40
consistent gets from cache (fastpath)	34,752,137	19,249.51	3,756.58
cursor authentications	136	0.08	0.01
data blocks consistent reads - undo records applied	31	0.02	0.00
db block gets	2,634,046	1,459.02	284.73
db block gets direct	1,355	0.75	0.15
db block gets from cache	2,632,691	1,458.27	284.58
db block gets from cache (fastpath)	289,387	160.29	31.28
deferred (CURRENT) block cleanout applications	2,831	1.57	0.31
dirty buffers inspected	2,565	1.42	0.28
enqueue conversions	1,260	0.70	0.14
enqueue releases	42,042	23.29	4.54
enqueue requests	42,011	23.27	4.54
enqueue timeouts	0	0.00	0.00
enqueue waits	1,049	0.58	0.11
exchange deadlocks	0	0.00	0.00
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	3,142,774	1,740.81	339.72
free buffer requested	3,076,072	1,703.86	332.51
gc blocks compressed	329	0.18	0.04
gc blocks lost	0	0.00	0.00
gc cr block flush time	1	0.00	0.00
gc cr blocks served	196	0.11	0.02
gc current block flush time	2	0.00	0.00
gc current block pin time	0	0.00	0.00
gc current blocks served	258	0.14	0.03
gc force cr disk read	37	0.02	0.00
gc kbytes saved	1,484	0.82	0.16
gc kbytes sent	2,148	1.19	0.23
gc local grants	1,420,595	786.88	153.56
gc read waits	0	0.00	0.00
gc remote grants	1,427,269	790.58	154.28
gcs messages sent	3,046,823	1,687.66	329.35
ges messages sent	8,418	4.66	0.91
global enqueue get time	579	0.32	0.06
global enqueue gets async	3,813	2.11	0.41
global enqueue gets sync	55,848	30.93	6.04
global enqueue releases	52,760	29.22	5.70
global undo segment hints helped	0	0.00	0.00
heap block compress	522	0.29	0.06
hot buffers moved to head of LRU	4,368,924	2,419.98	472.27
immediate (CR) block cleanout applications	105	0.06	0.01
immediate (CURRENT) block cleanout applications	5,979	3.31	0.65
index crx upgrade (positioned)	210	0.12	0.02
index crx upgrade (prefetch)	379	0.21	0.04
index fast full scans (direct read)	0	0.00	0.00
index fast full scans (full)	132	0.07	0.01
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	1,399,762	775.34	151.31
index scans kdiixs1	1,064,992	589.91	115.12
leaf node 90-10 splits	96	0.05	0.01
leaf node splits	327	0.18	0.04
lob reads	427,963	237.05	46.26
lob writes	256,416	142.03	27.72
lob writes unaligned	256,416	142.03	27.72
logical read bytes from cache	322,536,718,336	178,655,862.31	34,865,065.22
max cf enq hold time	0	0.00	0.00
messages received	13,752	7.62	1.49
messages sent	13,752	7.62	1.49
min active SCN optimization applied on CR	283	0.16	0.03
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	34,108,509	18,893.00	3,687.01
non-idle wait count	1,213,912	672.40	131.22
parse count (describe)	7	0.00	0.00
parse count (failures)	3	0.00	0.00
parse count (hard)	782	0.43	0.08
parse time cpu	196	0.11	0.02
physical read IO requests	461,619	255.69	49.90
physical read bytes	23,270,391,808	12,889,670.16	2,515,446.09
physical read total IO requests	470,250	260.48	50.83
physical read total bytes	23,423,533,056	12,974,496.42	2,532,000.11
physical read total multi block requests	20,398	11.30	2.20
physical reads cache	2,840,444	1,573.35	307.04
physical reads cache prefetch	2,771,066	1,534.92	299.54
physical reads direct	180	0.10	0.02
physical reads direct (lob)	180	0.10	0.02
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	6,879	3.81	0.74
physical write bytes	150,151,168	83,170.02	16,230.80
physical write total IO requests	15,339	8.50	1.66
physical write total bytes	355,606,016	196,973.23	38,439.74
physical write total multi block requests	623	0.35	0.07
physical writes direct	1,355	0.75	0.15
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	1,350	0.75	0.15
physical writes from cache	16,974	9.40	1.83
physical writes non checkpoint	17,183	9.52	1.86
pinned buffers inspected	4	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	21	0.01	0.00
process last non-idle time	1,778	0.98	0.19
queries parallelized	6	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	251,298	139.20	27.16
recursive cpu usage	118,299	65.53	12.79
redo KB read	128,137	70.98	13.85
redo KB read (memory)	128,137	70.98	13.85
redo KB read (memory) for transport	128,137	70.98	13.85
redo KB read for transport	128,137	70.98	13.85
redo blocks checksummed by FG (exclusive)	18,845	10.44	2.04
redo blocks written	258,940	143.43	27.99
redo buffer allocation retries	0	0.00	0.00
redo entries	479,578	265.64	51.84
redo log space requests	0	0.00	0.00
redo ordering marks	7,333	4.06	0.79
redo size for direct writes	41,140	22.79	4.45
redo subscn max counts	383	0.21	0.04
redo synch long waits	383	0.21	0.04
redo synch time	45	0.02	0.00
redo synch time (usec)	481,012	266.44	52.00
redo synch time overhead (usec)	2,241,270,928	1,241,459.24	242,273.37
redo synch time overhead count (<128 msec)	0	0.00	0.00
redo synch time overhead count (<2 msec)	694	0.38	0.08
redo synch time overhead count (<32 msec)	0	0.00	0.00
redo synch time overhead count (<8 msec)	2	0.00	0.00
redo synch time overhead count (>=128 msec)	4	0.00	0.00
redo synch writes	795	0.44	0.09
redo wastage	1,240,348	687.04	134.08
redo write broadcast ack count	1,159	0.64	0.13
redo write broadcast ack time	293,196	162.40	31.69
redo write broadcast lgwr post count	0	0.00	0.00
redo write info find	700	0.39	0.08
redo write info find fail	0	0.00	0.00
redo write time	320	0.18	0.03
redo writes	3,936	2.18	0.43
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	116	0.06	0.01
rollbacks only - consistent read gets	22	0.01	0.00
root node splits	0	0.00	0.00
rows fetched via callback	427,085	236.57	46.17
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	33,153	18.36	3.58
shared hash latch upgrades - wait	2	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	35,300	19.55	3.82
sorts (rows)	4,456,913	2,468.72	481.78
sql area evicted	604	0.33	0.07
sql area purged	81	0.04	0.01
summed dirty queue length	5,788	3.21	0.63
switch current to new buffer	2,855	1.58	0.31
table fetch by rowid	38,002,458	21,049.89	4,107.93
table fetch continued row	155,150	85.94	16.77
table scan blocks gotten	4,781,984	2,648.78	516.92
table scan rows gotten	229,374,726	127,052.63	24,794.59
table scans (direct read)	0	0.00	0.00
table scans (long tables)	2	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	20,476	11.34	2.21
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	478	0.26	0.05
total number of cf enq holders	137	0.08	0.01
total number of times SMON posted	2	0.00	0.00
transaction lock background get time	0	0.00	0.00
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction rollbacks	116	0.06	0.01
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	56,184,656	31,121.16	6,073.36
user logons cumulative	34	0.02	0.00
user logouts cumulative	63	0.03	0.01
write clones created in background	0	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
logons current	465	438
opened cursors current	3,370	3,034
session cursor cache count	46,664,732	46,666,032
session pga memory	18,162,357,472	18,123,869,600
session pga memory max	37,066,868,416	36,931,775,104
session uga memory	164,345,798,776	164,329,362,064
session uga memory max	9,939,199,779,648	9,939,352,100,672
workarea memory allocated	63,901	63,727

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

'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)
Buffer Cache Reads	21.6G	254.71	12.279M	0M	0.00	0M	63.7K	5.00
Others	146M	4.78	.081M	73M	2.48	.04M	8630	0.11
DBWR	0M	0.00	0M	132M	3.77	.073M	0
LGWR	0M	0.00	0M	126M	2.22	.07M	0
Direct Writes	0M	0.00	0M	7M	0.02	.004M	0
Direct Reads	2M	0.10	.001M	0M	0.00	0M	0
TOTAL:	21.8G	259.59	12.361M	338M	8.48	.187M	72.3K	4.42

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	21.6G	254.80	12.274M	129M	3.77	.071M	6.14	6.53
Control File	145M	4.75	.08M	70M	2.46	.039M	0.08	9.76
Log File	0M	0.00	0M	126M	2.22	.07M
Temp File	10M	0.01	.006M	10M	0.03	.006M		0.46
TOTAL:	21.8G	259.56	12.36M	335M	8.48	.186M	6.02	6.52

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Buffer Cache Reads	21.6G	254.59	12.277M	0M	0.00	0M	63.5K	5.02
Buffer Cache Reads (Data File)	21.6G	254.59	12.277M	0M	0.00	0M	63.5K	5.02
Others	145M	4.78	.08M	73M	2.48	.04M	8629	0.11
Others (Control File)	145M	4.75	.08M	70M	2.46	.039M	8579	0.11
Others (Data File)	0M	0.03	0M	3M	0.01	.002M	50	0.28
DBWR	0M	0.00	0M	132M	3.77	.073M	0
DBWR (Data File)	0M	0.00	0M	132M	3.77	.073M	0
LGWR	0M	0.00	0M	126M	2.22	.07M	0
LGWR (Log File)	0M	0.00	0M	126M	2.22	.07M	0
Direct Writes	0M	0.00	0M	7M	0.02	.004M	0
Direct Writes (Data File)	0M	0.00	0M	7M	0.02	.004M	0
Direct Reads	2M	0.10	.001M	0M	0.00	0M	0
Direct Reads (Data File)	2M	0.10	.001M	0M	0.00	0M	0
TOTAL:	21.8G	259.47	12.359M	338M	8.48	.187M	72.1K	4.43

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
TBS_CEN_IPARAM	412,046	228	0.39	2.81	269	218.83	0	0	1	10.00
TBS_CEN_DPARAM	40,956	23	3.33	40.86	0	14.85	1	0	23	6.09
SYSAUX	6,196	3	5.06	1.00	3,786	3.43	5	2	0	0.00
SYSTEM	1,031	1	6.91	1.01	903	0.57	7	1	0	0.00
TBS_CEN_IUSR	857	0	8.66	1.00	557	0.47	9	0	0	0.00
UNDOTBS2	396	0	7.40	1.00	749	0.22	7	0	0	0.00
TBS_CEN_DUSR	422	0	8.82	1.00	417	0.23	9	0	0	0.00
TBS_CEN_DEF	273	0	8.35	1.03	121	0.15	8	0	0	0.00
TEMP1	26	0	0.77	51.92	57	0.00	0	0	0	0.00
TBS_ESS_DPARAM	4	0	12.50	1.00	15	0.00	13	0	0	0.00
TBS_ESS_UNISPORTAL	8	0	6.25	1.00	7	0.00	8	0	0	0.00
STAT_LOG	3	0	6.67	1.00	8	0.00	10	0	0	0.00
UNDOTBS1	2	0	15.00	1.00	0	0.00	15	0	0	0.00
USERS	1	0	10.00	1.00	0	0.00	0	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Buffer Waits	Av Buf Wt(ms)
STAT_LOG	/essdata34/oradata/ess34/statlog.dbf	3	0	6.67	1.00	0	10.00	8	0	0	0.00
SYSAUX	/essorasys34/oradata/ess34/sysaux01.dbf	6,196	3	5.06	1.00	3	5.06	3,786	2	0	0.00
SYSTEM	/essorasys34/oradata/ess34/system01.dbf	1,031	1	6.91	1.01	1	6.92	903	1	0	0.00
TBS_CEN_DEF	/essdata34/oradata/ess34/tbs_cen_def_01.dbf	76	0	7.11	1.07	0	7.16	116	0	0	0.00
TBS_CEN_DEF	/essdata34/oradata/ess34/tbs_cen_def_02.dbf	38	0	7.63	1.00	0	7.63	0	0	0	0.00
TBS_CEN_DEF	/essdata34/oradata/ess34/tbs_cen_def_03.dbf	44	0	6.59	1.00	0	6.59	2	0	0	0.00
TBS_CEN_DEF	/essdata34/oradata/ess34/tbs_cen_def_04.dbf	38	0	10.79	1.00	0	10.79	0	0	0	0.00
TBS_CEN_DEF	/essdata34/oradata/ess34/tbs_cen_def_5.dbf	77	0	9.74	1.03	0	9.73	3	0	0	0.00
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_01.dbf	9,038	5	2.70	12.36	4	1.86	0	0	0	0.00
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_02.dbf	6,274	3	3.91	52.37	2	1.25	0	0	0	0.00
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_03.dbf	7,300	4	3.36	42.12	3	1.07	0	0	5	8.00
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_04.dbf	5,549	3	2.35	24.07	2	0.59	0	0	8	3.75
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_07.dbf	4,675	3	5.33	85.38	1	4.54	0	0	0	0.00
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_5.dbf	5,867	3	1.96	20.03	3	0.45	0	0	9	6.67
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_6.dbf	2,253	1	5.94	122.31	0	7.98	0	0	1	10.00
TBS_CEN_DUSR	/essdata34/oradata/ess34/tbs_cen_dusr_01.dbf	116	0	8.79	1.00	0	8.79	70	0	0	0.00
TBS_CEN_DUSR	/essdata34/oradata/ess34/tbs_cen_dusr_02.dbf	130	0	9.08	1.00	0	9.08	103	0	0	0.00
TBS_CEN_DUSR	/essdata34/oradata/ess34/tbs_cen_dusr_3.dbf	34	0	9.12	1.00	0	9.12	32	0	0	0.00
TBS_CEN_DUSR	/essdata34/oradata/ess34/tbs_cen_dusr_4.dbf	142	0	8.52	1.00	0	8.52	212	0	0	0.00
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_01.dbf	52,479	29	0.43	3.41	28	0.18	91	0	0	0.00
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_02.dbf	50,620	28	0.37	3.39	27	0.14	55	0	1	10.00
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_03.dbf	50,054	28	0.40	3.30	26	0.16	68	0	0	0.00
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_04.dbf	46,191	26	0.36	2.78	25	0.15	11	0	0	0.00
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_05.dbf	39,489	22	0.33	2.12	21	0.16	2	0	0	0.00
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_06.dbf	36,963	20	0.33	1.93	20	0.15	7	0	0	0.00
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_07.dbf	36,116	20	0.45	3.33	19	0.20	14	0	0	0.00
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_08.dbf	34,234	19	0.39	2.27	18	0.19	14	0	0	0.00
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_10.dbf	32,912	18	0.44	2.62	17	0.21	3	0	0	0.00
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_9.dbf	32,988	18	0.40	2.25	18	0.20	4	0	0	0.00
TBS_CEN_IUSR	/essdata34/oradata/ess34/tbs_cen_iusr_01.dbf	342	0	9.01	1.00	0	9.01	189	0	0	0.00
TBS_CEN_IUSR	/essdata34/oradata/ess34/tbs_cen_iusr_02.dbf	319	0	8.43	1.00	0	8.43	260	0	0	0.00
TBS_CEN_IUSR	/essdata34/oradata/ess34/tbs_cen_iusr_3.dbf	196	0	8.42	1.00	0	8.42	108	0	0	0.00
TBS_ESS_DPARAM	/essdata34/oradata/ess34/tbs_ess_dparam_01.dbf	4	0	12.50	1.00	0	12.50	15	0	0	0.00
TBS_ESS_UNISPORTAL	/essdata34/oradata/ess34/tbs_ess_unisportal_01.dbf	8	0	6.25	1.00	0	7.50	7	0	0	0.00
TEMP1	/essorasys34/oradata/ess34/temp101.dbf	26	0	0.77	51.92	0		57	0	0
UNDOTBS1	/essorasys34/oradata/ess34/undotbs102.dbf	2	0	15.00	1.00	0	15.00	0	0	0	0.00
UNDOTBS2	/essorasys34/oradata/ess34/undotbs201.dbf	204	0	7.45	1.00	0	7.45	132	0	0	0.00
UNDOTBS2	/essorasys34/oradata/ess34/undotbs202.dbf	192	0	7.34	1.00	0	7.34	617	0	0	0.00
USERS	/essorasys34/oradata/ess34/users_2.dbf	1	0	10.00	1.00	0	0.00	0	0	0	0.00

Back to IO Stats
Back to Top

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	3,749,000	93	39,371,613	2,840,730	16,976	0	0	24

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 18,329

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	11,678	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

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	2	1528	29906	351460	6794766	351460			1
E	0	0	516	2854	259584	6794766	259584			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	3,200	0.10	375	51.31	25,023,034	1	70702482.00
D	6,400	0.20	750	6.15	3,000,403	1	7642608.00
D	9,600	0.30	1,125	1.94	944,391	1	1755396.00
D	12,800	0.40	1,500	1.50	733,733	1	1152197.00
D	16,000	0.50	1,875	1.36	663,602	1	951381.00
D	19,200	0.60	2,249	1.27	617,219	1	818568.00
D	22,400	0.70	2,624	1.19	582,562	1	719332.00
D	25,600	0.80	2,999	1.13	552,206	1	632408.00
D	28,800	0.90	3,374	1.06	518,411	1	535640.00
D	32,000	1.00	3,749	1.00	487,645	1	447543.00
D	35,200	1.10	4,124	0.94	460,712	1	370424.00
D	38,400	1.20	4,499	0.90	437,983	1	305341.00
D	41,600	1.30	4,874	0.86	417,382	1	246354.00
D	44,800	1.40	5,249	0.82	400,551	1	198159.00
D	48,000	1.50	5,624	0.79	386,628	1	158291.00
D	51,200	1.60	5,998	0.77	376,533	1	129384.00
D	54,400	1.70	6,373	0.75	366,396	1	100898.00
D	57,600	1.80	6,748	0.72	351,265	1	99774.00
D	60,800	1.90	7,123	0.66	322,484	1	97635.00
D	64,000	2.00	7,498	0.59	286,628	1	94972.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	2,164	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	10,240	8,304	1,667.55	0.17	0.01	100.00	0.00	1,048,570
E	10,240	8,359	1,488.93	0.00	0.00	0.00	0.00	1,048,570

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	10,985	10,985
64K	128K	149	149
128K	256K	919	919
256K	512K	178	178
512K	1024K	435	435
1M	2M	867	867
2M	4M	139	139
4M	8M	2	2
32M	64M	2	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
1,280	0.13	199,123,140.08	48,510,234.25	80.00	1,477,294	24,552,985,160
2,560	0.25	199,123,140.08	97,863.78	100.00	1	19,752,872,021
5,120	0.50	199,123,140.08	97,859.49	100.00	0	19,752,871,596
7,680	0.75	199,123,140.08	97,859.49	100.00	0	19,752,871,596
10,240	1.00	199,123,140.08	65,425.32	100.00	0	19,749,655,731
12,288	1.20	199,123,140.08	65,069.71	100.00	0	19,749,620,472
14,336	1.40	199,123,140.08	65,069.71	100.00	0	19,749,620,472
16,384	1.60	199,123,140.08	65,069.71	100.00	0	19,749,620,472
18,432	1.80	199,123,140.08	65,069.71	100.00	0	19,749,620,472
20,480	2.00	199,123,140.08	65,069.71	100.00	0	19,749,620,472
30,720	3.00	199,123,140.08	65,069.71	100.00	0	19,749,620,472
40,960	4.00	199,123,140.08	65,069.71	100.00	0	19,749,620,472
61,440	6.00	199,123,140.08	65,069.71	100.00	0	19,749,620,472
81,920	8.00	199,123,140.08	65,069.71	100.00	0	19,749,620,472

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)
6,272	0.89	467	7,589	176,389,931	0.95	9,486,962	13.70	1,477,224
6,400	0.91	595	9,156	177,941,904	0.96	7,934,989	11.46	1,562,887
6,528	0.93	723	10,899	179,583,916	0.97	6,292,977	9.09	1,652,800
6,656	0.95	851	13,146	181,207,200	0.98	4,669,693	6.74	1,739,778
6,784	0.96	979	15,393	182,785,519	0.99	3,091,374	4.46	1,821,832
6,912	0.98	1,104	19,742	184,306,370	1.00	1,570,523	2.27	1,900,741
7,040	1.00	1,232	23,086	185,184,362	1.00	692,531	1.00	1,944,963
7,168	1.02	1,360	25,759	185,185,969	1.00	690,924	1.00	1,945,128
7,296	1.04	1,488	30,165	185,186,779	1.00	690,114	1.00	1,945,200
7,424	1.05	1,615	33,552	185,187,323	1.00	689,570	1.00	1,945,251
7,552	1.07	1,742	36,704	185,187,802	1.00	689,091	1.00	1,945,292
7,680	1.09	1,869	41,388	185,188,214	1.00	688,679	0.99	1,945,324
7,808	1.11	1,997	43,788	185,188,542	1.00	688,351	0.99	1,945,352
7,936	1.13	2,125	46,535	185,188,789	1.00	688,104	0.99	1,945,374
8,064	1.15	2,253	49,288	185,189,005	1.00	687,888	0.99	1,945,391
8,192	1.16	2,380	51,773	185,189,135	1.00	687,758	0.99	1,945,401
8,576	1.22	2,764	60,845	185,189,338	1.00	687,555	0.99	1,945,416
9,344	1.33	3,532	81,484	185,189,665	1.00	687,228	0.99	1,945,437
10,112	1.44	4,300	102,123	185,189,952	1.00	686,941	0.99	1,945,456
10,880	1.55	5,068	122,762	185,190,212	1.00	686,681	0.99	1,945,474
11,648	1.65	5,836	143,401	185,190,481	1.00	686,412	0.99	1,945,491
12,416	1.76	6,604	164,040	185,190,704	1.00	686,189	0.99	1,945,507
13,184	1.87	7,372	184,679	185,190,926	1.00	685,967	0.99	1,945,523
13,952	1.98	8,140	205,318	185,191,147	1.00	685,746	0.99	1,945,537
14,720	2.09	8,908	225,957	185,191,338	1.00	685,555	0.99	1,945,550

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
15,360	0.38	48,697,379	3,000,426,429
20,480	0.50	42,808,374	944,371,893
25,600	0.63	42,003,253	663,586,323
30,720	0.75	41,774,997	582,539,845
35,840	0.88	41,592,392	518,414,623
40,960	1.00	41,501,090	487,644,270
46,080	1.13	41,359,986	438,002,083
51,200	1.25	41,252,083	400,551,003
56,320	1.38	41,210,582	386,604,377
61,440	1.50	41,156,631	366,415,904
66,560	1.63	41,152,481	322,479,156
71,680	1.75	41,148,331	286,637,302
76,800	1.88	41,148,331	286,637,302
81,920	2.00	41,148,331	286,637,302

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

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	24	0	6

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Waits	Av Wt Time(ms)
US-Undo Segment	893	893	827	0.51
CF-Controlfile Transaction	5,158	5,158	56	1.07
ZH-Compression Analyzer (compression analysis)	104	104	52	0.58
PS-PX Process Reservation	39	39	18	1.50
TO-Temp Object	156	156	26	0.73
WF-AWR Flush	23	23	19	0.79
TM-DML	4,105	4,105	15	0.73
TK-Auto Task Serialization (Auto Task Serialization)	3	3	3	1.67
FB-Format Block	10	10	6	0.67
TA-Instance Undo	7	7	6	0.67
TC-Tablespace Checkpoint (contention2)	8	8	7	0.43
TD-KTF map table enqueue (KTF dump entries)	5	5	5	0.60
TX-Transaction (index contention)	1	1	1	3.00
HW-Segment High Water Mark	1,198	1,198	3	0.67
PI-Remote PX Process Spawn Status	6	6	3	0.67
JS-Job Scheduler (job run lock - synchronize)	3	3	3	0.67
DR-Distributed Recovery	1	1	1	1.00
CR-Reuse Block Range (block range reuse ckpt)	366	366	1	0.00
AF-Advisor Framework (task serialization)	13	13	1	0.00
MW-MWIN Schedule	1	1	1	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

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	7.44	2,222	1,287	3	40097.3/40633.3	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
04-Mar 23:59	52	318	1,284	1	40,430	0/0	0/0/0/0/0/0
04-Mar 23:49	5,270	576	682	3	40,097	0/0	0/0/0/0/0/0
04-Mar 23:39	2,113	1,328	1,287	3	40,633	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

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
ASM db client latch	4,085	0.00		0
ASM map operation hash table	1	0.00		0
ASM network state latch	28	0.00		0
AWR Alerted Metric Element list	26,267	0.00		0
Change Notification Hash table latch	627	0.00		0
Consistent RBA	3,930	0.00		0
DML lock allocation	8,278	0.00		0
Event Group Locks	144	0.00		0
FAL Queue	102	0.00		0
FOB s.o list latch	1,415	0.00		0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
IPC other latch	16	0.00		0
IPC stats buffer allocation latch	381	0.00		368	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	5	0.00		0
JS broadcast add buf latch	419	0.00		0
JS broadcast drop buf latch	419	0.00		0
JS broadcast load blnc latch	364	0.00		0
JS mem alloc latch	18	0.00		0
JS queue access latch	19	0.00		0
JS queue state obj latch	11,082	0.00		0
JS slv state obj latch	37	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
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	165,507	0.21	0.00	32,832	0.00
KJCT flow control latch	1,949,022	0.00	0.00	0
KMG MMAN ready and startup request latch	602	0.00		0
KSXR large replies	2	0.00		0
KTF sga latch	16	0.00		586	0.00
KWQMN job cache list latch	128	0.00		0
LGWR NS Write	7,990	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	1	0.00		0
MQL Tracking Latch	0			36	0.00
Memory Management Latch	1	0.00		602	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	1,240	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	470	0.00		0
OS process allocation	3,859	0.00		0
OS process: request allocation	151	0.00		0
PL/SQL warning settings	441	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	39,687	0.00		0
Result Cache: MB Latch	3,050	0.00		0
Result Cache: RC Latch	3,050	0.00		0
SGA IO buffer pool latch	2	0.00		2	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	1	0.00		1,797	0.00
SQL memory manager workarea list latch	261,906	0.00		0
Shared B-Tree	64	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	12,111	0.37	0.00	0
active service list	5,034	0.00		1,103	0.00
archive control	150	0.00		0
archive process latch	216	0.00		0
begin backup scn array	21	0.00		0
buffer pool	1	0.00		0
business card	13	0.00		0
cache buffer handles	7,164	0.00		0
cache buffers chains	84,842,668	0.00	0.01	10,243,182	0.00
cache buffers lru chain	3,011,435	0.00	0.03	7,959,983	0.00
cache table scan latch	31,070	0.00		31,070	0.00
call allocation	1,037	0.19	0.00	0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	205	0.00		0
channel operations parent latch	1,196,336	0.01	0.00	0
checkpoint queue latch	3,020,025	0.00	0.00	16,109	0.00
client/application info	347	0.00		0
compile environment latch	81	0.00		0
corrupted undo seg latch	464	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	28	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	28	0.00		0
dml lock allocation	28	0.00		0
done queue latch	1	0.00		0
dummy allocation	190	0.00		0
eighth spare latch - X parent	1	0.00		0
eleventh spare latch - children	1	0.00		0
enqueue freelist latch	1	0.00		70,961	0.00
enqueue hash chains	101,555	0.00		0
enqueues	1	0.00		0
error message lists	24	0.00		0
fifteenth spare latch - children	1	0.00		0
file cache latch	520	0.00		0
first Audit Vault latch	34	0.00		0
flashback copy	1	0.00		0
fourteenth spare latch - children	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc element	10,147,343	0.07	0.02	303	0.00
gcs commit scn state	1	0.00		0
gcs opaque info freelist	128,320	0.00	0.00	0
gcs partitioned table hash	8,895,224	0.05	0.00	0
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	29	0.00		0
gcs resource freelist	2,669,632	0.01	0.00	310	0.00
gcs resource hash	7,620,574	0.01	0.00	0
gcs resource scan list	1	0.00		0
gcs resource validate list	1	0.00		0
gcs shadows freelist	906	0.00		430	0.00
ges caches resource lists	32,045	0.03	0.11	25,206	0.02
ges deadlock list	332	0.00		0
ges domain table	101,200	0.00		0
ges enqueue table freelist	105,369	0.00		0
ges group table	102,478	0.00		0
ges process hash list	1,869,448	0.00	0.00	0
ges process parent latch	225,235	0.00	0.78	0
ges process table freelist	151	0.00		0
ges resource hash list	228,272	0.12	0.21	2,085	0.00
ges resource scan list	525	0.00		0
ges resource table freelist	4,373	0.00		0
ges timeout list	2,798	0.00		40	0.00
ges value block free list	551	0.00		0
global KZLD latch for mem in SGA	34	0.00		0
global tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	274	0.00		92,538	0.00
hash table modification latch	85	0.00		0
heartbeat check	1	0.00		695	0.00
heartbeat structure management	0			361	0.00
internal temp table object number allocation latch	10	0.00		0
interrupt manipulation	84	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	10	0.00		9	0.00
job_queue_processes free list latch	23	0.00		0
job_queue_processes parameter latch	404	0.00		0
k2q global data latch	1,204	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	5	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	67	0.00		0
ksim membership request latch	0			1,338	0.00
kss move lock	17	0.00		0
ksuosstats global area	184	0.00		0
ksv allocation latch	60	0.00		0
ksv class latch	3,279	0.00		0
ksv msg queue latch	1	0.00		0
ksxp shared latch	151	0.00		0
ksxp so latch	151	0.00		0
ksz_so allocation latch	151	0.00		0
ktm global data	33	0.00		0
kwqbsn:qsga	63	0.00		0
lgwr LWN SCN	4,862	0.02	0.00	0
list of block allocation	648	0.00		0
loader state object freelist	122	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	7	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 local	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	239	0.00		2,227,295	0.00
managed standby latch	72	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	11,767	0.00		0
messages	142,400	0.07	0.00	0
mostly latch-free SCN	4,913	1.06	0.00	0
msg queue latch	1	0.00		0
multiblock read objects	115,683	0.00	0.00	0
name-service memory objects	3,853	0.00		0
name-service namespace bucket	10,698	0.00		0
name-service namespace objects	6	0.00		0
name-service pending queue	2,302	0.00		0
name-service request	18	0.00		0
name-service request queue	19,259	0.00		0
ncodef allocation latch	28	0.00		0
nineth spare latch - X parent	1	0.00		0
object queue header heap	11,037	0.00		32,273	0.00
object queue header operation	6,231,511	0.00	0.00	0
object stats modification	343	0.00		0
parallel query alloc buffer	1,333	0.00		0
parallel query stats	28	0.00		0
parallel txn reco latch	5,310	0.00		0
parameter list	361	0.00		0
parameter table management	337	0.00		0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	25,114	0.00		24,600	0.00
process allocation	8,342	0.00		62	0.00
process group creation	151	0.00		0
process queue	73	0.00		0
process queue reference	1,084	0.00		99	0.00
qmn task queue latch	258	0.00		0
query server freelists	61	0.00		0
query server process	6	0.00		3	0.00
queued dump request	6	0.00		0
queuing load statistics	1	0.00		0
readredo stats and histogram	3,928	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	28,281	0.04	0.00	479,614	0.00
redo copy	1	0.00		479,624	0.02
redo writing	26,479	0.11	0.00	0
resmgr group change latch	59	0.00		0
resmgr:active threads	190	0.00		0
resmgr:actses change group	60	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	189	0.00		0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	61	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	658,134	0.01	0.00	47	0.00
second Audit Vault latch	1	0.00		0
sequence cache	31,609	0.10	0.00	0
session allocation	119,015	0.00		118,813	0.00
session idle bit	1,075,736	0.00	0.00	0
session queue latch	1	0.00		0
session state list latch	169	0.00		0
session switching	118	0.00		0
session timer	602	0.00		0
seventh spare latch - X parent	1	0.00		0
shared pool	82,565	0.00		16	0.00
shared pool sim alloc	27	0.00		0
shared pool simulator	2,443	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	2,881,895	0.00	0.00	0
simulator lru latch	1	0.00		2,643,008	0.01
sixth spare latch - X parent	1	0.00		0
sort extent pool	240	0.00		0
space background state object latch	6	0.00		0
space background task latch	2,510	0.20	0.00	1,205	0.00
state object free list	2	0.00		0
statistics aggregation	336	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	5	0.00		0
temporary table state object allocation	1	0.00		0
tenth spare latch - X parent	1	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
thirteenth spare latch - children	1	0.00		0
threshold alerts latch	162	0.00		0
transaction allocation	223	0.00		0
transaction branch allocation	602	0.00		0
twelfth spare latch - children	1	0.00		0
twenty-fifth spare latch - S par	1	0.00		0
twenty-first spare latch - S par	1	0.00		0
twenty-fourth spare latch - S par	1	0.00		0
twenty-second spare latch - S par	1	0.00		0
twenty-third spare latch - S par	1	0.00		0
undo global data	17,622	0.00		0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0
write info latch	0			5,099	0.02

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
gc element	10,147,343	7,543	120	7,425
gcs resource hash	7,620,574	1,062	1	1,061
cache buffers chains	84,842,668	374	4	370
ges resource hash list	228,272	272	58	216
cache buffers lru chain	3,011,435	39	1	38
ges caches resource lists	32,045	9	1	8
ges process parent latch	225,235	9	7	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
cache buffers chains	kcbgtcr_2	2	1
cache buffers chains	kcbgtcr: fast path (cr pin)	1	3
cache buffers chains	kcbzibmlt: multi-block read: nowait	1	0
cache buffers chains	kcbzwb	1	0
cache buffers lru chain	kcbzgb_2	1	0
channel operations parent latch	ksrwait()	1	1
gc element	kclplz	597	9
gc element	kclplz_1	22	5
gc element	kclnfndnewm	20	25
gc element	KCLUNLNK	2	585
gc element	kclrwrite	1	0
gcs resource hash	kjbcropen	1	0
ges caches resource lists	kjruch: cached obj cleanup	1	0
ges process parent latch	kjata_fg	7	0
ges resource hash list	kjucvl: lock convert request	24	12
ges resource hash list	kjrmas1: lookup master node	17	3
ges resource hash list	kjlrlr: remove lock from resource queue	16	27
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	1	3
object queue header operation	kcbo_unlink_q	1	1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Cursor Pin	kksfbc [KKSCHLPIN1]	86
Library Cache	kglpnal2 91	80
Library Cache	kglpin1 4	27
Library Cache	kglpndl1 95	15
Library Cache	kglpnal1 90	12
Cursor Pin	kkslce [KKSCHLPIN2]	4
Cursor Pin	kksLockDelete [KKSCHLPIN6]	2
Library Cache	kgllkc1 57	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

Total Logical Reads: 39,373,724
Captured Segments account for 85.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
UCR_CEN1	TBS_CEN_DPARAM	TF_M_ROLEDATARIGHT_NEW	TF_M_ROLEDATARIGHT_NEW_07	TABLE PARTITION	9,447,632	23.99
UCR_CEN3	TBS_CEN_IPARAM	IDX_TL_M_RIGHTLOG_DATESTAFF		INDEX	3,293,680	8.37
MISSING	TEMP1	** MISSING: 231557/5464192	MISSING	UNDEFINED	2,243,488	5.70
UCR_CEN4	TBS_CEN_IPARAM	IDX_TL_M_RIGHTLOG_DATESTAFF		INDEX	2,103,696	5.34
UCR_CEN3	TBS_CEN_IPARAM	IDX_TL_M_RIGHTLOG_OPERSTAFF		INDEX	1,459,392	3.71

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	92.79	In-memory Sort %:	100.00
Library Hit %:	98.74	Soft Parse %:	98.71
Execute to Parse %:	60.91	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	57.31	% Non-Parse CPU:	99.36

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
UCR_CEN1	TBS_CEN_DPARAM	TL_M_RIGHTLOG	TL_M_RIGHTLOG_07	TABLE PARTITION	594,637	20.93
UCR_CEN1	TBS_CEN_IPARAM	PK_TL_M_RIGHTLOG		INDEX	446,609	15.72
UCR_CEN3	TBS_CEN_IPARAM	IDX_TL_M_RIGHTLOG_DATERIGHT		INDEX	414,264	14.58
UCR_CEN3	TBS_CEN_IPARAM	IDX_TL_M_RIGHTLOG_LOGID		INDEX	331,774	11.68
UCR_CEN4	TBS_CEN_DPARAM	TL_M_RIGHTLOG	TL_M_RIGHTLOG_02	TABLE PARTITION	226,916	7.99

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
SYS	SYSAUX	I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST	INDEX	2,434	13.28
SYS	SYSAUX	I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST	INDEX	1,404	7.66
SYS	SYSAUX	WRI$_OPTSTAT_HISTGRM_HISTORY	TABLE	824	4.50
UCR_CEN4	TBS_CEN_IPARAM	IDX_TL_M_RIGHTLOG_LOGID	INDEX	632	3.45
SYS	SYSAUX	I_WRI$_OPTSTAT_H_ST	INDEX	526	2.87

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	34	0.00	2	1
dc_files	1,150	0.00	0	50
dc_global_oids	98	9.18	0	13
dc_histogram_data	22,839	6.52	2,755	14,478
dc_histogram_defs	14,035	12.43	1,074	35,758
dc_object_grants	2	0.00	0	5
dc_objects	12,882	1.98	164	2,547
dc_profiles	79	0.00	0	1
dc_rollback_segments	18,958	0.00	0	887
dc_segments	4,019	5.47	5	1,021
dc_sequences	25	4.00	25	6
dc_table_scns	26	100.00	0	0
dc_tablespaces	72,034	0.00	0	25
dc_users	75,362	0.04	0	256
global database name	2,272	0.00	0	1
outstanding_alerts	57	100.00	0	19
sch_lj_objs	2	0.00	0	1
sch_lj_oids	7	28.57	0	4

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	102	0.98	0		0	0
BODY	150	2.00	864	0.35	0	0
CLUSTER	21	4.76	21	4.76	0	0
DBLINK	103	0.00	0		0	0
EDITION	47	0.00	81	0.00	0	0
INDEX	86	0.00	86	4.65	4	0
OBJECT ID	26	100.00	0		0	0
QUEUE	360	0.00	390	0.00	0	0
SCHEMA	155	0.65	0		0	0
SQL AREA	13,765	3.65	178,849	0.95	189	354
SQL AREA BUILD	553	84.27	0		0	0
SQL AREA STATS	595	80.34	595	80.34	0	0
TABLE/PROCEDURE	2,586	5.45	35,723	1.55	138	0
TRANSFORMATION	180	0.00	180	0.00	0	0
TRIGGER	864	0.00	864	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	32,000.00	32,000.00	31,744.00	32,000.00	GRO/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	10,240.00	10,240.00	10,240.00	10,240.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	40,960.00	40,960.00	40,960.00	40,960.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	640.00	640.00	640.00	896.00	SHR/DEF
large pool	1,024.00	1,024.00	1,024.00	1,024.00	STA/
shared pool	7,040.00	7,040.00	6,912.00	7,040.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,176.26		2.52	4.61	43	43	466	466
B	Freeable	457.63	0.00	1.29	4.62	78		356	356
B	PL/SQL	23.26	17.26	0.05	0.09	2	5	466	465
B	SQL	10.77	0.90	0.03	0.02	0	36	429	387
E	Other	1,109.94		2.53	4.72	43	43	439	439
E	Freeable	352.06	0.00	1.07	2.29	40		329	329
E	PL/SQL	18.58	15.17	0.04	0.03	0	0	439	438
E	SQL	8.71	0.29	0.02	0.02	0	11	401	357

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	33,554,432,000
Fixed Size	2,255,784
Redo Buffers	74,428,416
Variable Size	9,126,806,616

Pool	Name	Begin MB	End MB	% Diff
java	free memory	640.00	640.00	0.00
large	free memory	1,016.19	1,016.19	0.00
shared	ASH buffers	160.00	160.00	0.00
shared	Checkpoint queue	156.29	156.29	0.00
shared	FileOpenBlock	121.60	121.60	0.00
shared	KGLH0	253.10	255.43	0.92
shared	SQLA	1,149.82	1,148.90	-0.08
shared	db_block_hash_buckets	178.00	178.00	0.00
shared	dbktb: trace buffer	93.75	93.75	0.00
shared	event statistics per sess	113.39	113.39	0.00
shared	free memory	1,919.20	1,915.88	-0.17
shared	gc name table	96.00	96.00	0.00
shared	gcs resources	892.65	892.65	0.00
shared	gcs shadows	617.99	617.99	0.00
shared	ges big msg buffers	102.46	102.46	0.00
shared	ges enqueues	140.62	140.62	0.00
shared	ges resource	96.80	96.80	0.00
shared	ksunfy : SSO free list	107.87	107.87	0.00
	buffer_cache	32,000.00	32,000.00	0.00
	fixed_sga	2.15	2.15	0.00
	log_buffer	70.98	70.98	0.00

Parameter Name	Begin value	End value (if different)
_gc_policy_time	0
_gc_undo_affinity	FALSE
_serial_direct_read	NEVER
_use_adaptive_log_file_sync	FALSE
audit_file_dest	/oracle/app/oracle/admin/ess34/adump
audit_trail	NONE
cluster_database	TRUE
compatible	11.2.0.4.0
control_files	/essorasys34/oradata/ess34/control01.ctl, /essorasys34/oradata/ess34/control02.ctl
db_block_size	8192
db_domain
db_files	2000
db_name	ess34
deferred_segment_creation	FALSE
diagnostic_dest	/oracle/app/oracle
dispatchers
distributed_lock_timeout	700
event	28401 TRACE NAME CONTEXT FOREVER, LEVEL 1
instance_number	2
large_pool_size	1073741824
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.161.2.9)(PORT=1621))
log_archive_config	DG_CONFIG=(ess34, dgess34)
log_archive_dest_1	LOCATION=/essarch34
log_archive_dest_2	SERVICE=dgess34 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=dgess34
log_archive_dest_state_2	ENABLE
log_archive_format	%t_%s_%r.dbf
open_cursors	1000
parallel_force_local	TRUE
pga_aggregate_target	10737418240
plsql_warnings	DISABLE:ALL
processes	6000
remote_listener	ess34-scan:1621
remote_login_passwordfile	EXCLUSIVE
resource_limit	TRUE
resource_manager_plan
sessions	9040
sga_target	42949672960
spfile	/essorasys34/oradata/ess34/spfileess34.ora
standby_file_management	auto
thread	2
undo_tablespace	UNDOTBS2

	Per Second	Per Transaction
Global Cache blocks received:	71.33	13.92
Global Cache blocks served:	0.25	0.05
GCS/GES messages received:	789.68	154.11
GCS/GES messages sent:	1,692.32	330.26
DBWR Fusion writes:	0.09	0.02
Estd Interconnect traffic (KB)	1,057.43

Buffer access - local cache %:	92.46
Buffer access - remote cache %:	0.33
Buffer access - disk %:	7.21

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	1.2
Avg global cache current block receive time (ms):	1.4
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 %:	3.1
Avg global cache cr block flush time (ms):	1.7
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 %:	8.9
Avg global cache current block flush time (ms):	0.9

Avg message sent queue time (ms):	0.1
Avg message sent queue time on ksxp (ms):	0.6
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.1
% of direct sent messages:	3.48
% of indirect sent messages:	96.48
% of flow controlled messages:	0.04

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	1,368	0.76	0.15
acks for commit broadcast(logical)	1,833	1.02	0.20
broadcast msgs on commit(actual)	2,295	1.27	0.25
broadcast msgs on commit(logical)	2,295	1.27	0.25
broadcast msgs on commit(wasted)	553	0.31	0.06
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	1	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	147	0.08	0.02
gcs ast xid	0	0.00	0.00
gcs blocked converts	664	0.37	0.07
gcs blocked cr converts	1,091	0.60	0.12
gcs compatible basts	125	0.07	0.01
gcs compatible cr basts (global)	55	0.03	0.01
gcs compatible cr basts (local)	63,628	35.24	6.88
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	144	0.08	0.02
gcs dbwr write request msgs	133	0.07	0.01
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	4	0.00	0.00
gcs force cr grant	4	0.00	0.00
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	848	0.47	0.09
gcs immediate (null) converts	6,897	3.82	0.75
gcs immediate cr (compatible) converts	10,629	5.89	1.15
gcs immediate cr (null) converts	1,402,449	776.83	151.60
gcs indirect ast	199	0.11	0.02
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	199	0.11	0.02
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	89	0.05	0.01
gcs msgs process time(ms)	10,492	5.81	1.13
gcs msgs received	1,417,529	785.18	153.23
gcs new served by master	286	0.16	0.03
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	0	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	0	0.00	0.00
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	1	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	6,046	3.35	0.65
gcs side channel msgs logical	150,662	83.45	16.29
gcs stale cr	30	0.02	0.00
gcs undo cr	0	0.00	0.00
gcs write notification msgs	0	0.00	0.00
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	481	0.27	0.05
ges msgs received	8,114	4.49	0.88
global posts dropped	0	0.00	0.00
global posts queue time	0	0.00	0.00
global posts queued	0	0.00	0.00
global posts requested	0	0.00	0.00
global posts sent	0	0.00	0.00
implicit batch messages received	1,415	0.78	0.15
implicit batch messages sent	78,575	43.52	8.49
lmd msg send time(ms)	10	0.01	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	570	0.32	0.06
messages queue sent actual	92,460	51.21	9.99
messages queue sent logical	1,480,305	819.95	160.02
messages received actual	121,094	67.08	13.09
messages received logical	1,425,643	789.68	154.11
messages sent directly	53,687	29.74	5.80
messages sent indirectly	1,488,576	824.54	160.91
messages sent not implicit batched	253	0.14	0.03
messages sent pbatched	1,513,490	838.34	163.60
msgs causing lmd to send msgs	2,504	1.39	0.27
msgs causing lms(s) to send msgs	351	0.19	0.04
msgs received queue time (ms)	1,617	0.90	0.17
msgs received queued	1,425,643	789.68	154.11
msgs sent queue time (ms)	94,263	52.21	10.19
msgs sent queue time on ksxp (ms)	150,343	83.28	16.25
msgs sent queued	1,492,194	826.54	161.30
msgs sent queued on ksxp	267,305	148.06	28.89
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	107,136	59.34	11.58
process batch messages sent	125,628	69.59	13.58

Statistic	Total
CR Block Requests	130
CURRENT Block Requests	57
Data Block Requests	130
Undo Block Requests	0
TX Block Requests	21
Current Results	172
Private results	0
Zero Results	0
Disk Read Results	15
Fail Results	0
Fairness Down Converts	99
Fairness Clears	13
Free GC Elements	0
Flushes	6
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	8
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	0	0.00	0.00	0.00	0.00	0.00
Flushes	23	82.61	17.39	0.00	0.00	0.00
Writes	156	16.67	72.44	0.64	1.92	8.33

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
1	data block	1,982	96.27	1.46	2.27	126,347	96.09	0.02	3.90
1	Others	22	95.45	0.00	4.55	328	100.00	0.00	0.00
1	undo header	110	99.09	0.91	0.00	27	100.00	0.00	0.00

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
1	data block	1.25	1.21	3.43	1.80	1.43	1.40	2.43	2.18
1	others	0.69	0.69		0.82	0.71	0.71
1	undo header	0.59	0.58	2.00		0.83	0.83
1	undo block

Src Inst#	Block Class	Blocks Lost	Immed Blks Received	% 2hop	% 3hop	Immed Blks Received	% 2hop	% 3hop
			CR			Current
1	data block	0	1,908	100.00	0.00	121,402	100.00	0.00
1	others	0	21	100.00	0.00	328	100.00	0.00
1	undo header	0	109	100.00	0.00	27	100.00	0.00
1	undo block	0	0			0

WORKLOAD REPOSITORY report for

Report Summary

Main Report

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

Key Instance Activity Stats

Other Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

Advisory Statistics

Instance Recovery Stats

MTTR Advisory

Buffer Pool Advisory

PGA Aggr Summary

PGA Aggr Target Stats

PGA Aggr Target Histogram

PGA Memory Advisory

Shared Pool Advisory

SGA Target Advisory

Streams Pool Advisory

Java Pool Advisory

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

Segment Statistics

Segments by Logical Reads

Segments by Physical Reads

Segments by Physical Read Requests

Segments by UnOptimized Reads

Segments by Optimized Reads

Segments by Direct Physical Reads

Segments by Physical Writes

Segments by Physical Write Requests

Segments by Direct Physical Writes

Segments by Table Scans

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.00	0.44
Parallel Query	0.00	0.00
DB Locks	0.43	0.11
DB Streams	0.00	0.00
Other	0.01	0.01