WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ESS34 3385539608 ess341 1 23-Sep-15 00:09 11.2.0.4.0 YES

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

Host Name Platform CPUs Cores Sockets Memory (GB)

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

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
essdb3	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 365 7.0 2

End Snap: 36545 05-Mar-16 00:00:20 354 6.7 2

Elapsed: 30.09 (mins)

DB Time: 2.45 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session	Instances
Begin Snap:	36544	04-Mar-16 23:30:15	365	7.0	2
End Snap:	36545	05-Mar-16 00:00:20	354	6.7	2
Elapsed:		30.09 (mins)
DB Time:		2.45 (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 0.1 0.0 0.00 0.00 0.1 0.0 0.00 0.00 2,348.1 426.9 6,583.3 1,196.9 223.2 40.6 0.2 0.0 1.7 0.3 0.2 0.0 1.3 0.2 0.0 0.0 0.0 0.0 class="awrnc"> 0.2 0.0 71.3 13.0 220.3 40.1 25.8 4.7 0.1 0.0 0.7 0.1 0.1 0.0 50.7 9.2 4.9 0.9 5.5

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 %: 100.00 In-memory Sort %: 100.00

Library Hit %: 99.78 Soft Parse %: 99.80

Execute to Parse %: 49.11 Latch Hit %: 99.97

Parse CPU to Parse Elapsd %: 67.70 % Non-Parse CPU: 98.20

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		96.7		65.9
control file sequential read	3,072	2.1	1	1.4	System I/O
reliable message	1,972	2	1	1.4	Other
library cache: mutex X	5,536	1.3	0	.9	Concurrency
db file sequential read	228	1.3	6	.9	User I/O
Disk file operations I/O	103	.9	9	.6	User I/O
log file sync	625	.7	1	.5	Commit
SQL*Net message to client	359,272	.5	0	.4	Network
name-service call wait	6	.5	83	.3	Other
JS kgl get object wait	2	.2	100	.1	Administrative

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
DB CPU		97		65.9	0.1
System I/O	21,590	13	1	9.1	0.0
Other	55,293	6	0	4.1	0.0
User I/O	855	3	4	2.4	0.0
Concurrency	18,498	3	0	1.9	0.0
Network	363,878	1	0	.8	0.0
Commit	627	1	1	.5	0.0
Cluster	854	1	1	.4	0.0
Administrative	14	0	17	.2	0.0
Application	25	0	3	.1	0.0
Configuration	1	0	1	.0	0.0

Host CPU

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

80 20 1.29 0.93 0.3 0.4 0.1 99.2

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
80	20		1.29	0.93	0.3	0.4	0.1	99.2

Instance CPU

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

0.2 22.1 0.0

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

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 12.1 6.4 5.7

Database Requests: 1.5 0.2 1.3

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 2.2 0.0 2.2

Total (MB): 0.2 0.1 0.1

Database (MB): 0.0 0.0 0.0

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 0.0 0.0 0.0

Database (blocks): 1.8 0.2 1.7

Via Buffer Cache (blocks): 1.8 0.1 1.7

Direct (blocks): 0.0 0.0 0.0

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	12.1	6.4	5.7
Database Requests:	1.5	0.2	1.3
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	2.2	0.0	2.2
Total (MB):	0.2	0.1	0.1
Database (MB):	0.0	0.0	0.0
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	0.0	0.0	0.0
Database (blocks):	1.8	0.2	1.7
Via Buffer Cache (blocks):	1.8	0.1	1.7
Direct (blocks):	0.0	0.0	0.0

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,340.9 1,361.4

% Host Mem used for SGA+PGA: 36.56 36.57

	Begin	End
Host Mem (MB):	115,712.0	115,712.0
SGA use (MB):	40,960.0	40,960.0
PGA use (MB):	1,340.9	1,361.4
% Host Mem used for SGA+PGA:	36.56	36.57

Cache Sizes

Begin End

Buffer Cache: 30,720M 30,720M Std Block Size: 8K

Shared Pool Size: 6,937M 6,938M Log Buffer: 72,684K

	Begin	End
Buffer Cache:	30,720M	30,720M	Std Block Size:	8K
Shared Pool Size:	6,937M	6,938M	Log Buffer:	72,684K

Shared Pool Statistics

Begin End

Memory Usage %: 76.06 76.03

% SQL with executions>1: 94.77 95.22

% Memory for SQL w/exec>1: 32.04 32.26

	Begin	End
Memory Usage %:	76.06	76.03
% SQL with executions>1:	94.77	95.22
% Memory for SQL w/exec>1:	32.04	32.26

Main Report

RAC Statistics

Wait Events Statistics

Time Model Statistics

Total time in database user-calls (DB Time): 146.8s
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	117.64	80.13
DB CPU	96.75	65.90
PL/SQL execution elapsed time	11.15	7.59
parse time elapsed	3.74	2.55
connection management call elapsed time	1.57	1.07
hard parse elapsed time	0.85	0.58
hard parse (sharing criteria) elapsed time	0.63	0.43
RMAN cpu time (backup/restore)	0.08	0.05
hard parse (bind mismatch) elapsed time	0.06	0.04
repeated bind elapsed time	0.03	0.02
PL/SQL compilation elapsed time	0.02	0.01
sequence load elapsed time	0.00	0.00
DB time	146.81
background elapsed time	194.80
background cpu time	149.18

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,306
AVG_IDLE_TIME	179,176
AVG_IOWAIT_TIME	89
AVG_SYS_TIME	693
AVG_USER_TIME	530
BUSY_TIME	111,400
IDLE_TIME	14,341,235
IOWAIT_TIME	12,106
SYS_TIME	62,186
USER_TIME	49,214
LOAD	1	1
OS_CPU_WAIT_TIME	168,100
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	1.29
05-Mar 00:00:20	0.93	0.77	0.34	0.43	99.23	0.08

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 73.0% of Total DB time 146.81 (s)
Total FG Wait Time: 10.40 (s) DB CPU time: 96.75 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			97		65.90
Other	2,201	3	3	1	1.90
User I/O	376	0	2	6	1.60
System I/O	3,080	0	2	1	1.42
Concurrency	6,338	0	1	0	0.98
Commit	625	0	1	1	0.50
Network	359,316	0	1	0	0.37
Cluster	321	0	0	1	0.17
Administrative	2	100	0	100	0.14
Application	23	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
control file sequential read	3,072	0	2	1	0.31	1.41
reliable message	1,972	0	2	1	0.20	1.36
library cache: mutex X	5,536	0	1	0	0.56	0.90
db file sequential read	228	0	1	6	0.02	0.90
Disk file operations I/O	103	0	1	9	0.01	0.60
log file sync	625	0	1	1	0.06	0.50
SQL*Net message to client	359,272	0	1	0	36.18	0.37
name-service call wait	6	0	0	83	0.00	0.34
JS kgl get object wait	2	100	0	100	0.00	0.14
CSS initialization	1	0	0	175	0.00	0.12
direct path read	45	0	0	3	0.00	0.10
gc current grant 2-way	131	0	0	1	0.01	0.06
row cache lock	134	0	0	0	0.01	0.04
gc cr block 2-way	62	0	0	1	0.01	0.04
enq: IV - contention	46	9	0	1	0.00	0.04
gc current block 2-way	53	0	0	1	0.01	0.03
gc current grant busy	30	0	0	1	0.00	0.02
cursor: pin S	630	0	0	0	0.06	0.01
IPC send completion sync	24	0	0	1	0.00	0.01
gc cr grant 2-way	23	0	0	1	0.00	0.01
library cache lock	19	47	0	1	0.00	0.01
enq: PS - contention	6	0	0	3	0.00	0.01
rdbms ipc reply	60	0	0	0	0.01	0.01
library cache pin	17	0	0	1	0.00	0.01
control file parallel write	8	0	0	1	0.00	0.01
gc cr disk read	15	0	0	1	0.00	0.01
gc cr multi block request	7	0	0	1	0.00	0.00
DFS lock handle	6	0	0	1	0.00	0.00
PX Deq: Slave Session Stats	9	0	0	0	0.00	0.00
enq: JS - job run lock - synchronize	4	100	0	1	0.00	0.00
SQL*Net more data to client	37	0	0	0	0.00	0.00
ges inquiry response	2	0	0	1	0.00	0.00
CSS operation: action	1	0	0	2	0.00	0.00
SQL*Net break/reset to client	22	0	0	0	0.00	0.00
enq: CF - contention	1	0	0	1	0.00	0.00
SQL*Net message from client	359,289	0	490,850	1366	36.18
jobq slave wait	326	99	163	499	0.03
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
control file sequential read	8,075	0	4	1	0.81	2.15
log file parallel write	4,005	0	3	1	0.40	1.58
control file parallel write	1,944	0	2	1	0.20	1.01
db file parallel write	2,265	0	1	1	0.23	0.73
os thread startup	18	0	1	57	0.00	0.53
db file sequential read	191	0	1	5	0.02	0.50
db file async I/O submit	2,225	0	1	0	0.22	0.34
LNS wait on SENDREQ	4,001	0	1	0	0.40	0.31
enq: CO - master slave det	601	100	1	1	0.06	0.26
enq: XR - database force logging	597	0	0	1	0.06	0.25
enq: IV - contention	550	0	0	1	0.06	0.20
CGS wait for IPC msg	15,911	100	0	0	1.60	0.14
enq: WF - contention	15	0	0	17	0.00	0.13
CSS initialization	4	0	0	62	0.00	0.13
DFS lock handle	316	55	0	1	0.03	0.13
libcache interrupt action by LCK	11,905	0	0	0	1.20	0.10
name-service call wait	3	0	0	61	0.00	0.09
Disk file operations I/O	269	0	0	1	0.03	0.08
row cache lock	218	0	0	1	0.02	0.08
gc current grant 2-way	181	0	0	1	0.02	0.06
ksxr poll remote instances	8,430	100	0	0	0.85	0.05
ADR block file write	9	0	0	10	0.00	0.05
reliable message	72	0	0	1	0.01	0.05
gc current block 2-way	143	0	0	1	0.01	0.05
enq: TM - contention	2	0	0	42	0.00	0.04
enq: CF - contention	59	44	0	1	0.01	0.04
gc cr block 2-way	97	0	0	1	0.01	0.03
gcs log flush sync	79	0	0	1	0.01	0.03
row cache cleanup	12,321	0	0	0	1.24	0.03
gc current grant busy	66	0	0	1	0.01	0.02
row cache process	13,192	0	0	0	1.33	0.02
ADR block file read	20	0	0	2	0.00	0.02
Backup: MML initialization	4	0	0	8	0.00	0.02
gc current block busy	17	0	0	1	0.00	0.01
enq: TC - contention	5	0	0	3	0.00	0.01
enq: PS - contention	12	50	0	1	0.00	0.01
gc cr grant 2-way	16	0	0	1	0.00	0.01
db file single write	20	0	0	1	0.00	0.01
gc current multi block request	3	0	0	3	0.00	0.01
CSS operation: action	4	0	0	2	0.00	0.00
PX Deq: reap credit	782	100	0	0	0.08	0.00
enq: TD - KTF dump entries	4	0	0	1	0.00	0.00
library cache lock	8	0	0	1	0.00	0.00
library cache pin	8	0	0	1	0.00	0.00
enq: TA - contention	5	0	0	1	0.00	0.00
ges inquiry response	4	0	0	1	0.00	0.00
IPC send completion sync	6	0	0	0	0.00	0.00
enq: TK - Auto Task Serialization	3	100	0	1	0.00	0.00
PX Deq: Signal ACK RSG	9	0	0	0	0.00	0.00
log file sync	2	0	0	1	0.00	0.00
gc buffer busy release	2	0	0	1	0.00	0.00
PX Deq: Slave Session Stats	9	0	0	0	0.00	0.00
enq: FB - contention	2	0	0	1	0.00	0.00
gc cr block busy	1	0	0	1	0.00	0.00
ADR file lock	14	0	0	0	0.00	0.00
rdbms ipc message	53,107	65	55,875	1052	5.35
gcs remote message	401,975	40	7,166	18	40.48
DIAG idle wait	33,288	57	3,544	106	3.35
Space Manager: slave idle wait	483	99	2,406	4981	0.05
Streams AQ: qmn coordinator idle wait	126	50	1,812	14380	0.01
Streams AQ: qmn slave idle wait	63	0	1,812	28760	0.01
GCR sleep	361	100	1,805	5000	0.04
wait for unread message on broadcast channel	4,612	27	1,805	391	0.46
LNS ASYNC end of log	4,844	17	1,804	372	0.49
pmon timer	600	100	1,803	3005	0.06
ges remote message	23,486	65	1,803	77	2.37
smon timer	361	0	1,802	4991	0.04
PING	721	20	1,794	2489	0.07
PX Idle Wait	12	0	1,690	140834	0.00
SQL*Net message from client	676	0	13	19	0.07
PX Deq: Join ACK	9	0	0	2	0.00
KSV master wait	1,084	100	0	0	0.11
PX Deq: Parse Reply	9	0	0	1	0.00
PX Deq: Execute Reply	9	0	0	0	0.00
class slave wait	9	0	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	129	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
ADR block file read	20	75.0		5.0	15.0	5.0
ADR block file write	9				55.6	33.3	11.1
ADR file lock	14	100.0
Backup: MML command to channel	4	100.0
Backup: MML extended initialization	4	100.0
Backup: MML initialization	4				75.0	25.0
CGS wait for IPC msg	15.9K	100.0
CSS initialization	5							100.0
CSS operation: action	5		100.0
DFS lock handle	322	75.8	21.7	2.2	.3
Disk file operations I/O	372	93.5	3.0	.8		.3	1.6	.8
IPC send completion sync	30	76.7	20.0	3.3
JS kgl get object wait	2							100.0
KJC: Wait for msg sends to complete	2	100.0
LGWR wait for redo copy	15	100.0
LNS wait on SENDREQ	4005	100.0
PX Deq: Signal ACK EXT	9	100.0
PX Deq: Signal ACK RSG	9	100.0
PX Deq: Slave Session Stats	18	94.4	5.6
PX Deq: reap credit	842	100.0
SQL*Net break/reset to client	22	100.0
SQL*Net message to client	361.9K	100.0
SQL*Net more data from client	7	100.0
SQL*Net more data to client	37	100.0
control file parallel write	1952	82.9	9.8	4.4	1.7	.8	.1	.2
control file sequential read	11.2K	96.9	1.6	.5	.5	.4	.1	.1
cursor: mutex X	1	100.0
cursor: pin S	628	99.7	.3
db file async I/O submit	2228	99.9	.1
db file parallel write	2268	90.6	6.7	2.0	.5	.1
db file sequential read	430	29.3	1.4	7.2	36.5	24.2	1.4
db file single write	20	90.0	10.0
direct path read	45	64.4		6.7	13.3	11.1	4.4
enq: AF - task serialization	1	100.0
enq: CF - contention	60	78.3	16.7			5.0
enq: CO - master slave det	601	85.9	14.0	.2
enq: DR - contention	1	100.0
enq: FB - contention	1	100.0
enq: IV - contention	596	88.3	10.9	.8
enq: JS - job run lock - synchronize	4	100.0
enq: MW - contention	1	100.0
enq: PS - contention	18	38.9	50.0		11.1
enq: TA - contention	5	100.0
enq: TC - contention	5	40.0		40.0	20.0
enq: TD - KTF dump entries	4	50.0	25.0	25.0
enq: TK - Auto Task Serialization	3	100.0
enq: TM - contention	2	50.0						50.0
enq: TX - index contention	1			100.0
enq: TX - row lock contention	1	100.0
enq: WF - contention	15	80.0	6.7					13.3
enq: XR - database force logging	598	87.8	11.7	.5
gc buffer busy release	3	33.3	66.7
gc cr block 2-way	157	84.7	14.0		1.3
gc cr block busy	6	33.3	50.0	16.7
gc cr disk read	15	100.0
gc cr grant 2-way	39	84.6	15.4
gc cr multi block request	7	71.4	28.6
gc current block 2-way	191	94.8	4.7		.5
gc current block busy	23	4.3	87.0	8.7
gc current grant 2-way	255	89.0	11.0
gc current grant busy	94	90.4	8.5	1.1
gc current split	1	100.0
gcs log flush sync	84	72.6	16.7	9.5	1.2
ges inquiry response	6	100.0
ksxr poll remote instances	8294	100.0
latch free	7	100.0
latch: cache buffers chains	3	100.0
latch: gc element	1	100.0
latch: ges resource hash list	22	100.0
libcache interrupt action by LCK	11.8K	100.0
library cache lock	25	68.0	32.0
library cache pin	23	91.3	8.7
library cache: mutex X	5513	97.5	.4			2.1	.0
log file parallel write	4009	90.8	5.2	2.2	.8	.6	.2	.1
log file sync	623	61.2	30.3	4.8	1.6	1.4	.2	.5
name-service call wait	9				11.1			88.9
os thread startup	18							100.0
rdbms ipc reply	60	90.0	10.0
reliable message	2030	60.8	37.6	1.2	.4
row cache cleanup	12.1K	100.0
row cache lock	305	83.3	15.7	1.0
row cache process	12.9K	100.0
DIAG idle wait	33.3K	41.4	.4	.0	.9	3.4	2.4	51.6
GCR sleep	361								100.0
KSV master wait	1082	100.0
LNS ASYNC end of log	4848	7.2	1.5	2.8	11.8	6.9	4.4	65.5
PING	725	79.7	.4	.1					19.7
PX Deq: Execute Reply	9	100.0
PX Deq: Execution Msg	36	58.3	36.1	5.6
PX Deq: Join ACK	9		66.7	33.3
PX Deq: Parse Reply	9	55.6	44.4
PX Idle Wait	9			22.2	11.1			33.3	33.3
SQL*Net message from client	362.1K	81.4	2.3	1.6	7.6	.9	.3	2.7	3.3
Space Manager: slave idle wait	484								100.0
Streams AQ: RAC qmn coordinator idle wait	129	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	9	100.0
gcs remote message	400.8K	28.4	5.4	3.8	7.0	8.5	21.3	25.6
ges remote message	23.5K	19.6	3.5	1.2	1.0	1.4	1.7	71.6
jobq slave wait	334							100.0
pmon timer	601								100.0
rdbms ipc message	53K	18.4	1.8	2.0	1.1	.8	.7	50.7	24.5
smon timer	362								100.0
wait for unread message on broadcast channel	4597	14.2	18.1	8.1	3.9	.9	1.0	53.8

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1s
		% of Total Waits
CSS initialization	5		60.0	20.0	20.0
Disk file operations I/O	3	99.2	.5			.3
JS kgl get object wait	2			100.0
control file parallel write	4	99.8	.2
control file sequential read	6	99.9	.0	.0
enq: TM - contention	1	50.0		50.0
enq: WF - contention	2	86.7		6.7	6.7
log file parallel write	5	99.9	.1
log file sync	3	99.5	.5
name-service call wait	8	11.1	22.2	66.7
os thread startup	18		83.3	11.1	5.6

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)	Logical Reads (K)
ess34	139	95	11,823
SYS$USERS	7	2	54
SYS$BACKGROUND	0	0	23

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Network Total Wts	Network Wt Time
ess34	144	1	6251	1	0	357900	1
SYS$USERS	432	2	87	0	14	1602	0
SYS$BACKGROUND	287	1	12164	1	0	4003	1

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 65.9% of Total DB Time (s): 147
Captured PL/SQL account for 0.0% of Total DB Time (s): 147

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
10.95	1	10.95	7.46	59.12	2.67	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
9.84	196	0.05	6.70	63.13	0.00	as1vfbtbaq488	JDBC Thin Client	select t1.*, f_csm_getelementL...
6.82	3	2.27	4.65	63.04	0.00	b0vvjbafc1cbv	JDBC Thin Client	select * from (select row_.*, ...
6.60	17	0.39	4.50	62.65	0.00	d1zf2gz3nh6p9	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
6.58	16	0.41	4.48	62.60	0.00	2vrbg89c0b9c3	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
5.91	17	0.35	4.02	62.58	0.00	8z7x4pvgkp15f	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
4.70	68	0.07	3.20	63.39	0.00	60q0qbx52q4hg	JDBC Thin Client	SELECT /+ use_nl(a, b)/ a.PR...
4.50	7,068	0.00	3.07	44.78	0.00	aypazt06z7fq8	JDBC Thin Client	SELECT * FROM (SELECT S.ROWID ...
4.13	44	0.09	2.81	61.85	0.00	5pyybh6rdun9c	JDBC Thin Client	SELECT a.PRODUCT_ID paracode, ...
3.35	13	0.26	2.28	63.33	0.00	bcda3mffuntad	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
3.08	1,160	0.00	2.10	62.09	0.00	3jwmr4t4sd4qj	JDBC Thin Client	select info.info_id, info.info...
2.30	495	0.00	1.57	62.08	0.00	5bp43151r7ux2	JDBC Thin Client	SELECT /*+INDEX(s PK_TF_M_STAF...
2.14	160	0.01	1.46	63.71	0.00	gsngqxt1zb8w8	JDBC Thin Client	SELECT A.MENU_ID MENU_ID, NVL(...
1.74	196	0.01	1.18	63.69	0.00	1kdtdp53axrc0	JDBC Thin Client	select t1.*, f_csm_getelementL...

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

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
6.47	1	6.47	6.69	10.95	59.12	2.67	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
6.21	196	0.03	6.42	9.84	63.13	0.00	as1vfbtbaq488	JDBC Thin Client	select t1.*, f_csm_getelementL...
4.30	3	1.43	4.44	6.82	63.04	0.00	b0vvjbafc1cbv	JDBC Thin Client	select * from (select row_.*, ...
4.14	17	0.24	4.28	6.60	62.65	0.00	d1zf2gz3nh6p9	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
4.12	16	0.26	4.25	6.58	62.60	0.00	2vrbg89c0b9c3	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
3.70	17	0.22	3.82	5.91	62.58	0.00	8z7x4pvgkp15f	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
2.98	68	0.04	3.08	4.70	63.39	0.00	60q0qbx52q4hg	JDBC Thin Client	SELECT /+ use_nl(a, b)/ a.PR...
2.55	44	0.06	2.64	4.13	61.85	0.00	5pyybh6rdun9c	JDBC Thin Client	SELECT a.PRODUCT_ID paracode, ...
2.12	13	0.16	2.19	3.35	63.33	0.00	bcda3mffuntad	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
2.01	7,068	0.00	2.08	4.50	44.78	0.00	aypazt06z7fq8	JDBC Thin Client	SELECT * FROM (SELECT S.ROWID ...
1.91	1,160	0.00	1.98	3.08	62.09	0.00	3jwmr4t4sd4qj	JDBC Thin Client	select info.info_id, info.info...
1.43	495	0.00	1.48	2.30	62.08	0.00	5bp43151r7ux2	JDBC Thin Client	SELECT /*+INDEX(s PK_TF_M_STAF...
1.36	160	0.01	1.41	2.14	63.71	0.00	gsngqxt1zb8w8	JDBC Thin Client	SELECT A.MENU_ID MENU_ID, NVL(...
1.11	196	0.01	1.14	1.74	63.69	0.00	1kdtdp53axrc0	JDBC Thin Client	select t1.*, f_csm_getelementL...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.29	1	0.29	8.39	10.95	59.12	2.67	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
0.02	448	0.00	0.48	0.22	54.04	7.58	144p979y5d4qk	JDBC Thin Client	SELECT count(1) recordcount FR...
0.01	445	0.00	0.39	1.26	61.51	1.07	74w966npt951x	JDBC Thin Client	SELECT s.staff_id STAFFID, s.s...
0.01	1,078	0.00	0.32	0.74	60.09	1.50	gqwdr44z61uhc	JDBC Thin Client	SELECT B.STAFF_ID, A.DEPART_ID...
0.00	1	0.00	0.14	1.14	61.99	0.42	bunssq950snhf		insert into wrh$_sga_target_ad...
0.00	3,986	0.00	0.00	0.42	59.67	0.00	3r98xda66pqkg	JDBC Thin Client	SELECT seq_operate_id.nextval ...
0.00	337	0.00	0.00	0.27	59.30	0.00	0tbgvuuq9kvvq	JDBC Thin Client	select F_SYS_GETSEQID('0769', ...
0.00	949	0.00	0.00	0.59	59.20	0.00	0uznvf6q4j8gv	JDBC Thin Client	select F_SYS_GETSEQID('0769', ...
0.00	733	0.00	0.00	0.16	59.90	0.00	18y91z1j9gkc2	JDBC Thin Client	SELECT eparchy_code, tag_code,...
0.00	196	0.00	0.00	1.74	63.69	0.00	1kdtdp53axrc0	JDBC Thin Client	select t1.*, f_csm_getelementL...

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: 11,885,285
Captured SQL account for 88.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,529,016	196	7,801.10	12.86	9.84	63.1	0	as1vfbtbaq488	JDBC Thin Client	select t1.*, f_csm_getelementL...
1,470,997	1	1,470,997.00	12.38	10.95	59.1	2.7	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
1,230,650	17	72,391.18	10.35	6.60	62.7	0	d1zf2gz3nh6p9	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
1,202,340	16	75,146.25	10.12	6.58	62.6	0	2vrbg89c0b9c3	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
1,104,355	17	64,962.06	9.29	5.91	62.6	0	8z7x4pvgkp15f	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
734,203	68	10,797.10	6.18	4.70	63.4	0	60q0qbx52q4hg	JDBC Thin Client	SELECT /+ use_nl(a, b)/ a.PR...
440,399	495	889.69	3.71	2.30	62.1	0	5bp43151r7ux2	JDBC Thin Client	SELECT /*+INDEX(s PK_TF_M_STAF...
294,561	3	98,187.00	2.48	6.82	63	0	b0vvjbafc1cbv	JDBC Thin Client	select * from (select row_.*, ...
268,582	1,160	231.54	2.26	3.08	62.1	0	3jwmr4t4sd4qj	JDBC Thin Client	select info.info_id, info.info...
254,074	495	513.28	2.14	1.41	61.6	0	978w5zf7fb9kw	JDBC Thin Client	SELECT /*+INDEX(s PK_TF_M_STAF...
246,111	13	18,931.62	2.07	3.35	63.3	0	bcda3mffuntad	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
182,378	5	36,475.60	1.53	1.08	63	0	1tudr8vp9cbz8	JDBC Thin Client	SELECT COUNT(1) FROM TD_B_PART...
182,378	5	36,475.60	1.53	1.11	63.2	0	4kwrndwqfhpvv	JDBC Thin Client	select * from (select row_.*, ...
177,232	44	4,028.00	1.49	4.13	61.9	0	5pyybh6rdun9c	JDBC Thin Client	SELECT a.PRODUCT_ID paracode, ...
139,875	160	874.22	1.18	0.90	61.8	0	fvyxwrszqr6cb	JDBC Thin Client	SELECT /*+INDEX(s PK_TF_M_STAF...
128,776	196	657.02	1.08	1.15	63.2	0	4zgxvz101v3np	JDBC Thin Client	SELECT PRODUCT_ID, PRODUCT_NAM...
123,110	445	276.65	1.04	1.26	61.5	1.1	74w966npt951x	JDBC Thin Client	SELECT s.staff_id STAFFID, s.s...
121,372	13	9,336.31	1.02	0.88	62.7	0	azyy2tkuyq6as	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
119,226	18	6,623.67	1.00	1.35	64.1	0	a1za6987f3czy	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 305
Captured SQL account for 23.6% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
67	1	67.00	21.97	10.95	59.12	2.67	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
2	448	0.00	0.66	0.22	54.04	7.58	144p979y5d4qk	JDBC Thin Client	SELECT count(1) recordcount FR...
1	445	0.00	0.33	1.26	61.51	1.07	74w966npt951x	JDBC Thin Client	SELECT s.staff_id STAFFID, s.s...
1	1	1.00	0.33	1.14	61.99	0.42	bunssq950snhf		insert into wrh$_sga_target_ad...
1	1,078	0.00	0.33	0.74	60.09	1.50	gqwdr44z61uhc	JDBC Thin Client	SELECT B.STAFF_ID, A.DEPART_ID...
0	337	0.00	0.00	0.27	59.30	0.00	0tbgvuuq9kvvq	JDBC Thin Client	select F_SYS_GETSEQID('0769', ...
0	949	0.00	0.00	0.59	59.20	0.00	0uznvf6q4j8gv	JDBC Thin Client	select F_SYS_GETSEQID('0769', ...
0	733	0.00	0.00	0.16	59.90	0.00	18y91z1j9gkc2	JDBC Thin Client	SELECT eparchy_code, tag_code,...
0	196	0.00	0.00	1.74	63.69	0.00	1kdtdp53axrc0	JDBC Thin Client	select t1.*, f_csm_getelementL...
0	5	0.00	0.00	1.08	63.03	0.00	1tudr8vp9cbz8	JDBC Thin Client	SELECT COUNT(1) FROM TD_B_PART...

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: 305
Captured SQL account for 23.3% of Total
Total UnOptimized Read Requests: 305
Captured SQL account for 23.3% 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	%Opt	%Total	SQL Id	SQL Module	SQL Text
67	67	1	67.00	0.00	21.97	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
2	2	448	0.00	0.00	0.66	144p979y5d4qk	JDBC Thin Client	SELECT count(1) recordcount FR...
1	1	1	1.00	0.00	0.33	bunssq950snhf		insert into wrh$_sga_target_ad...
1	1	1,078	0.00	0.00	0.33	gqwdr44z61uhc	JDBC Thin Client	SELECT B.STAFF_ID, A.DEPART_ID...
0	0	337	0.00		0.00	0tbgvuuq9kvvq	JDBC Thin Client	select F_SYS_GETSEQID('0769', ...
0	0	949	0.00		0.00	0uznvf6q4j8gv	JDBC Thin Client	select F_SYS_GETSEQID('0769', ...
0	0	733	0.00		0.00	18y91z1j9gkc2	JDBC Thin Client	SELECT eparchy_code, tag_code,...
0	0	196	0.00		0.00	1kdtdp53axrc0	JDBC Thin Client	select t1.*, f_csm_getelementL...
0	0	5	0.00		0.00	1tudr8vp9cbz8	JDBC Thin Client	SELECT COUNT(1) FROM TD_B_PART...
0	0	16	0.00		0.00	2vrbg89c0b9c3	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...

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: 91,540
Captured SQL account for 50.0% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
7,068	0	0.00	4.50	44.8	0	aypazt06z7fq8	JDBC Thin Client	SELECT * FROM (SELECT S.ROWID ...
3,986	3,985	1.00	0.42	59.7	0	3r98xda66pqkg	JDBC Thin Client	SELECT seq_operate_id.nextval ...
3,896	3,924	1.01	0.56	59.3	0	gfnm5kf4c4sv0	JDBC Thin Client	SELECT trim (PROVINCE_CODE) PR...
3,869	3,576	0.92	0.73	60.3	0	9uz82r5qakdrr	JDBC Thin Client	SELECT B.STANDARD_KIND_CODE FR...
3,543	3,543	1.00	0.52	59.5	0	7huyhmb57bj7j	JDBC Thin Client	SELECT SQL_STMT FROM code_code...
3,342	14,628	4.38	0.88	60.2	0	ddkkhuy6g2xb3	JDBC Thin Client	select a.INTF_CONTEXT_CODE, a....
2,387	2,388	1.00	0.28	58.8	0	7h35uxf5uhmm1	JDBC Thin Client	select sysdate from dual
1,628	1,628	1.00	0.30	59.5	0	9d5gtsgdqdbdd	JDBC Thin Client	SELECT seq_trade_id_poc.nextva...
1,567	1,567	1.00	0.16	58.8	0	520mkxqpf15q8	JDBC Thin Client	select 1 from dual
1,160	796	0.69	3.08	62.1	0	3jwmr4t4sd4qj	JDBC Thin Client	select info.info_id, info.info...
1,152	1,051	0.91	0.40	59.9	0	8gfgrw6whsawh	JDBC Thin Client	SELECT subsys_code, param_attr...
1,078	1,044	0.97	0.74	60.1	1.5	gqwdr44z61uhc	JDBC Thin Client	SELECT B.STAFF_ID, A.DEPART_ID...
968	968	1.00	0.60	59.2	0	99sn55ax21tna	JDBC Thin Client	select F_SYS_GETSEQID('0020', ...
949	949	1.00	0.59	59.2	0	0uznvf6q4j8gv	JDBC Thin Client	select F_SYS_GETSEQID('0769', ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 46,581
Captured SQL account for 54.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
7,209	7,068	15.48	aypazt06z7fq8	JDBC Thin Client	SELECT * FROM (SELECT S.ROWID ...
2,388	2,387	5.13	7h35uxf5uhmm1	JDBC Thin Client	select sysdate from dual
1,717	3,986	3.69	3r98xda66pqkg	JDBC Thin Client	SELECT seq_operate_id.nextval ...
1,610	1,628	3.46	9d5gtsgdqdbdd	JDBC Thin Client	SELECT seq_trade_id_poc.nextva...
1,567	1,567	3.36	520mkxqpf15q8	JDBC Thin Client	select 1 from dual
968	968	2.08	99sn55ax21tna	JDBC Thin Client	select F_SYS_GETSEQID('0020', ...
949	949	2.04	0uznvf6q4j8gv	JDBC Thin Client	select F_SYS_GETSEQID('0769', ...
559	714	1.20	5m6h90d4pbpfy	JDBC Thin Client	SELECT seq_trade_id.nextval FR...
446	446	0.96	dmhyuxw9fx0hc	JDBC Thin Client	SELECT A.PARA_VALUE1 FROM TD_S...
396	396	0.85	aqhnb3czjtsxt	JDBC Thin Client	select F_SYS_GETSEQID('0020', ...

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
148,663,352	2.04	11gb0xb9vp04q	SQL Text Not Available
67,268,640	0.92	fa0uzvspp236d	SQL Text Not Available
50,429,120	0.69	6d1jnnuhkt8wy	SQL Text Not Available
46,277,312	0.64	8q7ppcdk6rvch	SQL Text Not Available
33,982,456	0.47	86v8m3jqnpxmu	SQL Text Not Available
30,766,096	0.42	b5576mqw15vum	SQL Text Not Available
26,878,832	0.37	5d7jn0g21z6zf	SQL Text Not Available
25,176,752	0.35	dzan2tgvtkzdw	SQL Text Not Available
22,783,096	0.31	b0r4bhpm4ztd2	select to_clob(restart\|\|apply_...
21,309,472	0.29	52wa1g9zbygsk	SQL Text Not Available
21,309,416	0.29	5k0m9p5r81awv	SQL Text Not Available
21,132,800	0.29	76prgq1x4k2z3	SQL Text Not Available
21,022,576	0.29	ghc83bfjv10k2	SQL Text Not Available
20,941,208	0.29	3f3hn3fpjzjpc	SQL Text Not Available
20,503,016	0.28	gj0q42166bt62	SQL Text Not Available
20,327,840	0.28	25vwt55t1093f	SQL Text Not Available
20,120,840	0.28	cuv4yub7sc5am	SQL Text Not Available
19,919,456	0.27	9v56t5yjn5fvs	SQL Text Not Available
19,914,736	0.27	9qykrbj46813q	SQL Text Not Available
19,622,832	0.27	12hhcr6ucw6mb	SQL Text Not Available
18,949,456	0.26	3gwrz9gzta4g7	SQL Text Not Available
18,812,160	0.26	5366v39r5n5ux	SQL Text Not Available
18,158,816	0.25	arp476pr8hrba	SQL Text Not Available
16,597,456	0.23	g8z3zsc07gyx8	SQL Text Not Available
15,887,296	0.22	1nktcbcjqsfqv	SQL Text Not Available
15,173,144	0.21	390ngbpv69txy	SQL Text Not Available
15,120,144	0.21	7cfzjgyugq476	SQL Text Not Available
15,014,848	0.21	6yha0qjjasqxg	SQL Text Not Available
14,970,360	0.21	danm6dqvz780s	SQL Text Not Available
14,905,464	0.20	9q5jas50b88ud	SQL Text Not Available
14,069,800	0.19	1r9u733n8t67x	SQL Text Not Available
13,713,328	0.19	8amf6x2gf6cfr	SQL Text Not Available
12,383,208	0.17	dzsjvy781bqf7	SQL Text Not Available
11,911,664	0.16	bya4d80vkp9t8	SQL Text Not Available
11,668,304	0.16	ahdcm6b9m36vu	SQL Text Not Available
11,587,152	0.16	0apbvns24jdc9	SQL Text Not Available
10,171,928	0.14	1fuvut1mhzn6j	SQL Text Not Available
8,106,880	0.11	8qmqtdw8abvdb	SQL Text Not Available
8,078,712	0.11	9tv4b1adcgh6y	SQL Text Not Available
7,994,144	0.11	dqn46uz4zdh6v	SQL Text Not Available
6,995,576	0.10	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
449		5d7jn0g21z6zf		SQL Text Not Available
436		cuv4yub7sc5am		SQL Text Not Available
421		52wa1g9zbygsk		SQL Text Not Available
400		5k0m9p5r81awv		SQL Text Not Available
389		9qykrbj46813q		SQL Text Not Available
354		3f3hn3fpjzjpc		SQL Text Not Available
349		ghc83bfjv10k2		SQL Text Not Available
348		1r9u733n8t67x		SQL Text Not Available
343		6yha0qjjasqxg		SQL Text Not Available
341		9q5jas50b88ud		SQL Text Not Available
341		dqn46uz4zdh6v		SQL Text Not Available
340		12hhcr6ucw6mb		SQL Text Not Available
339		3gwrz9gzta4g7		SQL Text Not Available
337		1fuvut1mhzn6j		SQL Text Not Available
335		4cduyz74jf1np		SQL Text Not Available
330		0apbvns24jdc9		SQL Text Not Available
330		danm6dqvz780s		SQL Text Not Available
320		8amf6x2gf6cfr		SQL Text Not Available
316		bya4d80vkp9t8		SQL Text Not Available
314		76prgq1x4k2z3		SQL Text Not Available
312		fa0uzvspp236d		SQL Text Not Available
309		8q7ppcdk6rvch		SQL Text Not Available
306		9tv4b1adcgh6y		SQL Text Not Available
306		ahdcm6b9m36vu		SQL Text Not Available
305		9v56t5yjn5fvs		SQL Text Not Available
304		390ngbpv69txy		SQL Text Not Available
304		8qmqtdw8abvdb		SQL Text Not Available
303		25vwt55t1093f		SQL Text Not Available
303		g8z3zsc07gyx8		SQL Text Not Available
300		dzsjvy781bqf7		SQL Text Not Available
298		86v8m3jqnpxmu		SQL Text Not Available
297		7cfzjgyugq476		SQL Text Not Available
297		b0r4bhpm4ztd2		select to_clob(restart\|\|apply_...
291		gj0q42166bt62		SQL Text Not Available
290		arp476pr8hrba		SQL Text Not Available
287		1nktcbcjqsfqv		SQL Text Not Available
284		6d1jnnuhkt8wy		SQL Text Not Available
284		b5576mqw15vum		SQL Text Not Available
280		11gb0xb9vp04q		SQL Text Not Available
277		5366v39r5n5ux		SQL Text Not Available
272		dzan2tgvtkzdw		SQL Text Not Available
38	18	a1za6987f3czy	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
38	18	a1za6987f3czy	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
38	18	a1za6987f3czy	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
38	18	a1za6987f3czy	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
38	18	a1za6987f3czy	JDBC Thin Client	SELECT A.PRODUCT_ID, PRODUCT_N...
31	3	b0vvjbafc1cbv	JDBC Thin Client	select * from (select row_.*, ...
31	3	b0vvjbafc1cbv	JDBC Thin Client	select * from (select row_.*, ...
28	5	4kwrndwqfhpvv	JDBC Thin Client	select * from (select row_.*, ...
26	5	1tudr8vp9cbz8	JDBC Thin Client	SELECT COUNT(1) FROM TD_B_PART...
26	488	5shc0vmk95hpx	JDBC Thin Client	select * from (select area.ARE...
22	1,152	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): 1
Captured SQL account for 16.0% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.09	1	14.39	10.95	0.81	59.12	2.67	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0apbvns24jdc9 ** SQL Text Not Available **

0tbgvuuq9kvvq select F_SYS_GETSEQID('0769', 'seq_trade_id_poc') from dual

0uznvf6q4j8gv select F_SYS_GETSEQID('0769', 'seq_operate_id') from dual

11gb0xb9vp04q ** SQL Text Not Available **

12hhcr6ucw6mb ** SQL Text Not Available **

144p979y5d4qk SELECT count(1) recordcount FROM TD_M_DEPARTKIND A, TF_CHL_CHANNEL B, TD_CHL_KINDDEF C WHERE A.DEPART_KIND_CODE = B.CHNL_KIND_ID AND A.CODE_TYPE_CODE = 0 and b.eparchy_code = a.eparchy_code AND b.chnl_kind_id = c.chnl_kind_id and c.standard_kind_code like '2%' AND b.CHNL_ID = :1

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 **

1kdtdp53axrc0 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, Z.ENABLE_TAG, G.SP_PRODUCT_NAME ELEMENT_NAME, G.PRICE_DESCRIBE ELEMENT_DESC, to_char(Z.START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, Z.START_OFFSET, Z.START_UNIT, Z.END_ENABLE_TAG, to_char(Z.END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, Z.END_OFFSET, Z.END_UNIT, ITEM_INDEX, -1 SCORE, -1 REWARD_LIMIT, G.SP_PRODUCT_ID SP_PRODUCT_ID, N.PARTY_ID PARTY_ID, G.SP_ID 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 = 'SP_SERV ICE_' || TO_CHAR(G.SP_SERVICE_ID) AND (area_code = :3 OR area_code = :4 OR area_code = 'ZZZZ')) HAS_ATTR FROM TD_B_PACKAGE_ELEMENT M, (select t.party_id, t.sp_id from td_b_party_service t where t.states='2' AND SYSDATE BETWEEN t.start_date AND t.end_date GROUP BY t.party_id, t.sp_id) N, Td_b_Party_Product G, td_b_element_enable Z WHERE package_id = :5 AND Z.PID(+) = G.SP_SERVICE_ID AND SYSDATE BETWEEN M.start_date AND M.end_date AND (SYSDATE BETWEEN Z.start_date AND Z.end_date or z.start_date is null or z.end_date is null) AND M.element_type_code = 'X' --sp AND M.element_id = G.SP_SERVICE_ID AND N.SP_ID = G.SP_ID AND G.STATE = '4' -- AND N.STATES = '2' -- AND SYSDATE BETWEEN N.start_date AND N.end_date ) t1 WHERE substr(:6 , -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 = :7 AND E.data_code = F.role_code AND E.right_attr = '1' --?????1-?????? AND E.right_tag = '1' --?????1-?? AND F.data_ type = t1.ELEMENT_TYPE_CODE --?????3-???? AND F.data_code = TO_CHAR(t1.element_id)) ORDER BY ITEM_INDEX

1nktcbcjqsfqv ** SQL Text Not Available **

1r9u733n8t67x ** SQL Text Not Available **

1tudr8vp9cbz8 SELECT COUNT(1) FROM TD_B_PARTY_PRODUCT a WHERE a.sp_product_name LIKE '%' || :1 || '%' AND SYSDATE BETWEEN a.start_date and a.end_date AND a.state = '4' and( instr( a.product_city , :2 , 1 , 1 ) > 0 or trim( a.product_city ) = '01' ) AND( a.product_type_code = 1 or a.product_type_code is null ) AND( a.net_tag = :3 or a.net_tag is null or :4 is null ) AND( a.product_mode <> '1' OR a.product_mode IS NULL ) and a.prod_credit != '2' /*?????*/ and( a.province_code = :5 or a.province_code = 'ZZZZ' ) AND EXISTS( SELECT 1 FROM TD_B_PARTY_SERVICE b WHERE a.sp_id = b.sp_id AND a.party_id = b.party_id AND( b.sp_type_code = :6 or :7 is null ) AND b.states = '2' AND SYSDATE BETWEEN b.start_date and b.end_date ) AND EXISTS( SELECT 1 FROM TD_B_PARTY c WHERE c.party_id = a.party_id AND SYSDATE BETWEEN c.start_date and c.end_date ) AND EXISTS( SELECT 1 FROM tf_m_staffdataright e , tf_m_roledataright f WHERE e.staff_id = :8 AND e.data_code = f.role_code AND e.right_attr = '1' AND e.right_t ag = '1' AND f.data_type = 'X' AND f.data_code = to_char( a.sp_service_id ) ) AND A.SP_PRODUCT_ID != '6000000000' /*????????????????*/ ORDER BY a.sp_product_name

25vwt55t1093f ** SQL Text Not Available **

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

390ngbpv69txy ** SQL Text Not Available **

3f3hn3fpjzjpc ** SQL Text Not Available **

3gwrz9gzta4g7 ** SQL Text Not Available **

3jwmr4t4sd4qj select info.info_id, info.info_topic, info.send_date, infos.INST_ID from TF_F_INFO info, TF_F_INFO_INSTANCE infos where 1 = 1 AND info.info_type = :1 AND info.VALID_TIME >=to_date(to_char(SYSDATE, 'yyyy-mm-dd'), 'yyyy-mm-dd') AND info.CREATE_TIME <= to_date(to_char(SYSDATE, 'yyyy-mm-dd'), 'yyyy-mm-dd') AND info.info_id = infos.info_id AND infos.RECE_OBJ in (:2 , :3 , :4 , (select a.para_value1 from td_s_syspara_deflist a where a.eparchy_code='ZZZZ' and a.para_code1='GROUP_AREA_LIMIT' and a.para_code2='0')) AND NOT EXISTS (SELECT 1 FROM TF_F_INFO_INSTANCE_LOG ins where info.info_id = ins.info_id AND ins.rece_obj = :5 AND ins.RECE_OBJ_TYPE = :6 AND ins.inst_status = :7 ) ORDER BY SEND_DATE DESC

3r98xda66pqkg SELECT seq_operate_id.nextval FROM DUAL

4cduyz74jf1np ** SQL Text Not Available **

4kwrndwqfhpvv select * from (select row_.*, rownum rownum_ from (SELECT a.sp_product_id, a.sp_product_name, a.price_describe, a.sp_id, a.party_id, a.sp_service_id, '-1' package_id, to_char(end_date, 'yyyy-mm-dd hh24:mi:ss') End_Date FROM TD_B_PARTY_PRODUCT a WHERE a.sp_product_name LIKE '%' || :1 || '%' AND SYSDATE BETWEEN a.start_date and a.end_date AND a.state = '4' and (instr(a.product_city, :2 , 1, 1) > 0 or trim(a.product_city) = '01') AND (a.product_type_code = 1 or a.product_type_code is null) AND (a.net_tag = :3 or a.net_tag is null or :4 is null) AND (a.product_mode <> '1' OR a.product_mode IS NULL) and a.prod_credit != '2' /*?????*/ and (a.province_code = :5 or a.province_code ='ZZZZ') AND EXISTS (SELECT 1 FROM TD_B_PARTY_SERVICE b WHERE a.sp_id = b.sp_id AND a.party_id = b.party_id AND (b.sp_type_code = :6 or :7 is null) AND b.states = '2' AND SYSDATE BETWEEN b.start_date and b.end_date) AND EXISTS (SELECT 1 FROM TD_B_PARTY c WHERE c.party_id = a.party_id AND SYSDATE BET WEEN c.start_date and c.end_date) AND EXISTS (SELECT 1 FROM tf_m_staffdataright e, tf_m_roledataright f WHERE e.staff_id = :8 AND e.data_code = f.role_code AND e.right_attr = '1' AND e.right_tag = '1' AND f.data_type = 'X' AND f.data_code = to_char(a.sp_service_id)) AND A.SP_PRODUCT_ID!='6000000000'/*????????????????*/ ORDER BY a.sp_product_name) row_ where rownum <= :9 ) where rownum_ > :10

4zgxvz101v3np SELECT 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(START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, MIN_NUMBER, MAX_NUMBER, to_char(CREATE_DATE, 'yyyy-mm-dd hh24:mi:ss') CREATE_DATE, VERSION, PRODUCT_STATE, UPDATE_STAFF_ID, UPDATE_DEPART_ID, to_char(UPDATE_TIME, 'yyyy-mm-dd hh24:mi:ss') UPDATE_TIME, 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_ATTR, a.NEED_EXP, to_number(rsrv_value2) PROD_LOW_COST FROM TD_B_PRODUCT A WHERE A.PRODUCT_ID = :3 AND sysdate BETWEEN A.start_date AND A.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=:4 OR release_area_code=:5 ) AND sysdate BETWEEN start_date AND end_date ) AND (substr(:6 , -8)='SUPERUSR' OR EXISTS (SELECT 1 FROM tf_m_staffdataright C, tf_m_roledataright D WHERE C.staff_id=:7 AND C.data_code=D.role_code AND C.right_attr='1' --?????1-?????? AND C.right_tag='1' --?????1-?? AND D.data_type='P' --?????P-???? AND D.data_code=TO_CHAR(A.product_id) ) )

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 **

5k0m9p5r81awv ** SQL Text Not Available **

5m6h90d4pbpfy SELECT seq_trade_id.nextval FROM DUAL

5pyybh6rdun9c SELECT a.PRODUCT_ID paracode, a.PRODUCT_NAME paraname FROM td_b_product a WHERE sysdate BETWEEN a.start_date AND a.end_date

5shc0vmk95hpx select * from (select area.AREA_CODE, area.AREA_NAME, area.parent_area_code, area.area_level, area.order_no from td_m_staff_depart_rel rel, TD_M_DEPART dept, TD_M_AREA area where rel.DEPART_ID = dept.DEPART_ID and dept.AREA_CODE = area.AREA_CODE and rel.valid_flag = '0' and rel.staff_id = :1 and dept.RSVALUE2 = :2 and area.area_level = '30' and area.VALIDFLAG = '0' union select area2.AREA_CODE, area2.AREA_NAME, area2.parent_area_code, area2.area_level, area2.order_no from td_m_staff_depart_rel rel, TD_M_DEPART dept, TD_M_AREA area, TD_M_AREA area2 where rel.DEPART_ID = dept.DEPART_ID and dept.AREA_CODE = area.AREA_CODE and rel.valid_flag = '0' and rel.staff_id = :3 and dept.RSVALUE2 = :4 and area.area_level = '20' and area2.parent_area_code = area.area_code and area2.area_level = '30' and area2.VALIDFLAG = '0') a order by order_no

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

6d1jnnuhkt8wy ** SQL Text Not Available **

6yha0qjjasqxg ** SQL Text Not Available **

74w966npt951x SELECT s.staff_id STAFFID, s.staff_id STAFFNAME, NVL(s.data_code, ' ') DATA_CODE, NVL(d.data_name, ' ') DATANAME, NVL(s.data_type, ' ') DATA_TYPE, DECODE(s.data_type, '0', '????', '1', '????', '2', '????', '3', '????', '4', '????', '9', '????', ' ') B_DATA_TYPE, NVL(s.right_tag, ' ') RIGHTTAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') B_RIGHTTAG, NVL(s.right_class, ' ') RIGHTCLASS, NVL(s.oper_special, ' ') OPERSPECIAL, NVL(s.rsvalue1, ' ') RSVALUE1, NVL(s.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDITTIME, s.accredit_staff_id ACCREDITSTAFFNAME, NVL(s.remark, ' ') REMARK, d.class_code CLASSCODE FROM tf_m_staffdataright s, td_m_dataright d WHERE s.right_attr='0' AND s.right_tag='1' AND s.data_code=d.data_code AND (s.data_type='0' OR s.data_type='1' OR s.data_type='9') AND (s.rsvalue1 IS NULL OR s.rsvalue1 != '1') AND s.data_type=d.data_type AND s.staff_id=:1 AND s.province_code = :2 AND s.province_code = d.province_code UNI ON SELECT s.staff_id STAFFID, s.staff_id STAFFNAME, NVL(r.data_code, ' ') DATA_CODE, NVL(d.data_name, ' ') DATANAME, NVL(s.data_type, ' ') DATA_TYPE, DECODE(s.data_type, '0', '????', '1', '????', '2', '????', '3', '????', '4', '????', '9', '????', ' ') B_DATA_TYPE, NVL(s.right_tag, ' ') RIGHTTAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') B_RIGHTTAG, NVL(r.right_class, ' ') RIGHTCLASS, NVL(r.oper_special, ' ') OPERSPECIAL, NVL(r.rsvalue1, ' ') RSVALUE1, NVL(r.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDITTIME, s.accredit_staff_id ACCREDITSTAFFNAME, NVL(s.remark, ' ') REMARK, d.class_code CLASSCODE FROM tf_m_staffdataright s, td_m_dataright d, tf_m_roledataright r WHERE s.right_attr='1' AND s.right_tag='1' AND s.data_code=r.role_code AND r.data_code=d.data_code AND s.data_type=d.data_type AND s.data_type=r.data_type AND (r.data_type='0' OR r.data_type='1' OR r.data_type='9') 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_staffdataright WHERE staff_id=s.staff_id AND data_code=r.data_code AND province_code = r.province_code AND data_type=r.data_type) AND s.staff_id=:3 AND r.province_code = :4 AND s.province_code = d.province_code AND d.province_code = r.province_code

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

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 **

8qmqtdw8abvdb ** SQL Text Not Available **

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

978w5zf7fb9kw SELECT /*+INDEX(s PK_TF_M_STAFFFUNCRIGHT)*/ s.staff_id STAFFID, s.staff_id STAFF_NAME, NVL(s.right_code, ' ') RIGHT_CODE , NVL(f.right_name, ' ') RIGHT_NAME, NVL(f.right_attr, ' ') RIGHT_ATTR, DECODE(f.right_attr, '0', '????', '1', '??????', '2', '????', ' ') X_RIGHTATTR, NVL(s.right_tag, ' ') RIGHT_TAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') X_RIGHTTAG, NVL(s.extend_value1, ' ') EXTEND_VALUE1, NVL(s.extend_value2, 0) EXTEND_VALUE2, NVL(s.rsvalue1, ' ') RSVALUE1, NVL(s.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDIT_TIME, s.accredit_staff_id X_ACCREDIT_STAFF_ID, NVL(s.remark, ' ') REMARK, NVL(m.mod_name, ' ') MOD_NAME, NVL(m.mod_type, ' ') MOD_TYPE, NVL(f.class_code, ' ') CLASS_CODE 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.mod_code=m.mod_code(+) AND s.right_code=f.right_code AND s.province_code=f.province_code AND f.province_code=m.province_code AND (f. right_attr='1' OR f.right_attr='2') 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)*/ s.staff_id STAFF_ID, s.staff_id STAFF_NAME, NVL(r.right_code, ' ') RIGHT_CODE , NVL(f.right_name, ' ') RIGHT_NAME, NVL(f.right_attr, ' ') RIGHT_ATTR, DECODE(f.right_attr, '0', '????', '1', '??????', '2', '????', ' ') RIGHT_ATTR, NVL(s.right_tag, ' ') RIGHT_TAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') X_RIGHTTAG, NVL(r.extend_value1, ' ') EXTEND_VALUE1, NVL(r.extend_value2, 0) EXTEND_VALUE2, NVL(r.rsvalue1, ' ') RSVALUE1, NVL(r.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDIT_TIME, s.accredit_staff_id X_ACCREDIT_STAFF_ID, NVL(s.remark, ' ') REMARK, NVL(m.mod_name, ' ') MOD_NAME, NVL(m.mod_type, ' ') MOD_TYPE, NVL(f.class_code, ' ') CLASS_CODE FROM tf_m_stafffuncright s, tf_m_rolefuncright r, td_s_modfile m, td_m_funcright f 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 f.mod_code=m.mod_code(+) AND s.province_code=r.province_code AND r.province_code=m.province_code AND m.province_code=f.province_code AND (f.right_attr='1' OR f.right_attr='2') 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 province_code=r.province_code AND r.province_code = :4 AND right_code=r.right_code) AND s.staff_id=:5 AND s.depart_id = :6 AND s.province_code = :7

99sn55ax21tna select F_SYS_GETSEQID('0020', 'seq_operate_id') from dual

9d5gtsgdqdbdd SELECT seq_trade_id_poc.nextval FROM DUAL

9q5jas50b88ud ** SQL Text Not Available **

9qykrbj46813q ** 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 **

a1za6987f3czy 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, td_s_productlimit 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 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 BETWEEN C.start_date AND C.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=:4 OR release_area_code=:5 ) AND sysdate BETWEEN start_date AND end_date) AND (substr(:6 , -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=:7 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_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 (:8 IS NULL OR sale_area_code = 'ZZ ZZ' OR sale_area_code = :9 )) --?? OR (sale_area_type = '30' AND (:10 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :11 )) --??? OR (sale_area_type = '20' AND (:12 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :13 )) --?? 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

ahdcm6b9m36vu ** SQL Text Not Available **

aqhnb3czjtsxt select F_SYS_GETSEQID('0020', 'seq_trade_id_poc') from dual

arp476pr8hrba ** SQL Text Not Available **

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

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

azyy2tkuyq6as 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, td_s_productlimit C, TD_S_PROD_SPEC_LIMIT 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 B ETWEEN C.start_date AND C.end_date AND D.product_id = a.PRODUCT_ID AND D.ID_TYPE= '0' AND D.ID = :4 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 T1 WHERE T1.data_type = 'P' AND T1.data_code = TO_CHAR(A.product_id) AND T1.ROLE_CODE = '09ZZZZZZ')) AND ( NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND start_date <= SYSDATE A ND 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

b0r4bhpm4ztd2 select to_clob(restart||apply_name) , case when elaps <= 0 then to_number(null) else coord_total_received/elaps end rate_received_txn , case when elaps <= 0 then to_number(null) else coord_total_applied/elaps end rate_applied_txn , case when elaps <= 0 then to_number(null) else coord_total_rollbacks/elaps end rate_rollbacks_txn , case when elaps <= 0 then to_number(null) else server_total_messages_applied/elaps end server_apply_rate , server_elapsed_apply_time/ decode(server_total_messages_applied, 0, to_number(null) , server_total_messages_applied) server_apply_time_pm , server_elapsed_dequeue_time/ decode(server_total_messages_applied, 0, to_number(null) , server_total_messages_applied) server_deq_time_pm , case when elaps <= 0 then to_number(null) else reader_total_messages_dequeued/elaps end reader_rate_deq from (select e.apply_name , decode( e.startup_time, b.startup_time, null, '*') restart , e.reader_total_messages_dequeued - nvl(b.reader_total_message s_dequeued, 0) reader_total_messages_dequeued , e.coord_total_received - nvl(b.coord_total_received, 0) coord_total_received , e.coord_total_applied - nvl(b.coord_total_applied, 0) coord_total_applied , e.coord_total_rollbacks - nvl(b.coord_total_rollbacks, 0) coord_total_rollbacks , e.coord_total_wait_deps - nvl(b.coord_total_wait_deps, 0) coord_total_wait_deps , e.coord_total_wait_cmts - nvl(b.coord_total_wait_cmts, 0) coord_total_wait_commits , e.server_total_messages_applied - nvl(b.server_total_messages_applied, 0) server_total_messages_applied , e.server_elapsed_dequeue_time - nvl(b.server_elapsed_dequeue_time, 0) server_elapsed_dequeue_time , e.server_elapsed_apply_time - nvl(b.server_elapsed_apply_time, 0) server_elapsed_apply_time , case when e.startup_time = b.startup_time then :ela else (cast(:e_eitvtime as date) - e.startup_time)*24*3600 end elaps from dba_hist_streams_apply_sum b , dba_hist_streams_apply_sum e where b.snap_id (+)= :bid and e.snap_id = :e id and e.instance_number = :inst_num and b.instance_number (+)= e.instance_number and e.dbid = :dbid and b.dbid (+)= e.dbid and b.apply_name (+)= e.apply_name and b.startup_time (+)= e.startup_time order by e.apply_name )

b0vvjbafc1cbv select * from (select row_.*, rownum rownum_ from (SELECT /*+ first_rows */ serial_number, NVL(to_char(fee_code_fee/100), '0') fee_code_fee, product_id, sim_card_no, nvl(to_char(advance_pay/100), '0') advance_pay, net_type_code, nvl(to_char(low_cost/100), '0') low_cost, lease_property_tag, decode(lease_property_tag, 0, nvl(lease_length, 0)||'?', lease_length) lease_length, number_src, num_thaw_pro, first_month_amount, end_month_amount, number_type FROM (SELECT serial_number, fee_code_fee, product_id, sim_card_no, advance_pay, net_type_code, low_cost, lease_length, lease_property_tag, a.number_src, a.num_thaw_pro, a.first_month_amount, a.end_month_amount, a.number_type FROM tf_r_mphonecode_idle a WHERE 1 = 1 AND (sim_card_no is null OR sim_card_no = '') AND code_state_code = '9' AND preopen_tag = '0' AND eparchy_code = :1 AND INSTR(:2 , NUMBER_TYPE) > 0 AND code_type_code <> 'J' AND stock_id = :3 AND stock_level <> :4 AND package_flag = '0' AND SERIAL_NUMBER LIKE '% ' || :5 || '%' AND product_id is null UNION ALL SELECT serial_number, fee_code_fee, product_id, sim_card_no, advance_pay, net_type_code, low_cost, lease_length, lease_property_tag, B.number_src, B.num_thaw_pro, B.first_month_amount, B.end_month_amount, B.number_type FROM tf_r_mphonecode_idle B, (SELECT DISTINCT * FROM(SELECT TO_CHAR(M.POOL_CODE) POOL_CODE, '3' NUMBER_SRC FROM TD_M_POOL_AUTH M WHERE ((M.AUTH_OBJ_TYPE = '0' AND M.AUTH_OBJ = :6 ) OR (M.AUTH_OBJ_TYPE = '1' AND M.AUTH_OBJ = :7 ) ) AND EXISTS (SELECT 1 FROM TD_M_POOL B WHERE B.POOL_CODE = M.POOL_CODE AND B.POOL_TYPE = '0' AND B.EPARCHY_CODE = M.EPARCHY_CODE AND B.EPARCHY_CODE = :8 AND B.VALID_TAG = '0') UNION ALL SELECT TO_CHAR(M.POOL_ID) POOL_CODE, '1|2' NUMBER_SRC FROM TF_R_POOL_USER M WHERE ((M.USER_LEVEL = 'A' AND M.USER_ID = :9 ) OR (M.USER_LEVEL = 'B' AND M.USER_ID = :10 ) OR (M.USER_LEVEL IN ('C', 'D') AND M.USER_ID = :11 ) OR (M.USER_LEVEL = 'E' AND M.USER_ID = :12 ) OR (M.USER_LEVEL = 'F' AND M.USER_ID = :13 )) AND EXISTS (SELECT 1 FROM TF_R_POOL B WHERE M.POOL_ID = B.POOL_ID)) D)C WHERE 1 = 1 AND (B.sim_card_no is null OR B.sim_card_no = '') AND B.code_state_code = '9' AND B.preopen_tag = '0' AND B.eparchy_code = :14 AND INSTR(:15 , NUMBER_TYPE) > 0 AND code_type_code <> 'J' AND B.stock_level = :16 AND B.package_flag = '0' AND B.SERIAL_NUMBER LIKE '%' || :17 || '%' AND B.product_id is null AND B.POOL_CODE = C.POOL_CODE ) t WHERE NOT EXISTS (SELECT /*+INDEX(f PK_TF_R_TEMPOCCUPY)*/ 1 FROM tf_r_tempoccupy f WHERE f.res_no = t.serial_number AND res_type_code = '0' AND ( (occupy_staff_id != :18 AND (f.res_state_code='3' OR f.valid_time > SYSDATE) ) OR (occupy_staff_id = :19 AND f.res_state_code = '3' ) ) ) AND rownum < 2001 order by decode(number_type, '176', 1, '175', 2, 3) ) row_ where rownum <= :20 ) where rownum_ > :21

b5576mqw15vum ** SQL Text Not Available **

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

bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice

bya4d80vkp9t8 ** SQL Text Not Available **

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

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

dmhyuxw9fx0hc SELECT A.PARA_VALUE1 FROM TD_S_SYSPARA_DEFLIST A WHERE A.EPARCHY_CODE = 'ZZZZ' AND A.PARA_ATTR = '1000' AND A.PARA_CODE1 = 'GROUP_AREA_LIMIT' AND A.PARA_CODE2 = '0'

dqn46uz4zdh6v ** SQL Text Not Available **

dzan2tgvtkzdw ** SQL Text Not Available **

dzsjvy781bqf7 ** SQL Text Not Available **

fa0uzvspp236d ** SQL Text Not Available **

fvyxwrszqr6cb SELECT /*+INDEX(s PK_TF_M_STAFFFUNCRIGHT)*/ s.staff_id STAFF_ID, NVL(s.right_code, ' ') RIGHT_CODE , NVL(f.right_name, ' ') RIGHT_NAME, NVL(f.right_attr, ' ') RIGHT_ATTR, DECODE(f.right_attr, '0', '????', '1', '??????', '2', '????', ' ') X_RIGHTATTR, NVL(s.right_tag, ' ') RIGHT_TAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') X_RIGHTTAG, NVL(s.extend_value1, ' ') EXTEND_VALUE1, NVL(s.extend_value2, 0) EXTEND_VALUE2, NVL(s.rsvalue1, ' ') RSVALUE1, NVL(s.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDIT_TIME, NVL(s.remark, ' ') REMARK, NVL(m.mod_name, ' ') MOD_NAME, NVL(m.mod_type, ' ') MODT_YPE, NVL(f.class_code, ' ') CLASS_CODE 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.mod_code = m.mod_code(+) AND s.right_code = f.right_code AND s.province_code = m.province_code AND s.province_code = f.province_code AND f.right_attr = '0' 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)*/ s.staff_id STAFF_ID, NVL(r.right_code, ' ') RIGHT_CODE , NVL(f.right_name, ' ') RIGHT_NAME, NVL(f.right_attr, ' ') RIGHT_ATTR, DECODE(f.right_attr, '0', '????', '1', '??????', '2', '????', ' ') X_RIGHTATTR, NVL(s.right_tag, ' ') RIGHT_TAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') X_RIGHTTAG, NVL(r.extend_value1, ' ') EXTEND_VALUE1, NVL(r.extend_value2, 0) EXTEND_VALUE2, NVL(r.rsvalue1, ' ') RSVALUE1, NVL(r.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDIT_TIME, NVL(s.remark, ' ') REMARK, NVL(m.mod_name, ' ') MOD_NAME, NVL(m.mod_type, ' ') MOD_TYPE, NVL(f.class_code, ' ') CLASS_CODE FROM tf_m_stafffuncright s, tf_m_rolefuncright r, td_s_modfile m, td_m_funcright f WHERE s.right_attr = '1' AND s.right_tag = '1' AND s.right_code = r.role_cod e AND r.right_code = f.right_code AND f.mod_code = m.mod_code(+) AND s.province_code = m.province_code AND s.province_code = f.province_code AND s.province_code = r.province_code AND f.right_attr = '0' 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 (rsvalue1 IS NULL OR rsvalue1 !='1')) AND s.staff_id = :5 AND s.depart_Id = :6 AND s.province_code = :7

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

gsngqxt1zb8w8 SELECT A.MENU_ID MENU_ID, NVL(A.PARENT_MENU_ID, ' ') PARENT_MENU_ID, NVL(A.RIGHT_CODE, ' ') RIGHT_CODE, NVL(A.SUBSYS_CODE, ' ') SUBSYS_CODE, NVL(A.MENU_TITLE, ' ') MENU_TITLE, NVL(A.MENU_TEXT, ' ') MENU_TEXT, NVL(A.IMAGE_INDEX, -1) IMAGE_INDEX, NVL(A.SHOW_ORDER, -1) SHOW_ORDER, NVL(A.TOOLBAR_INDEX, -1) TOOLBAR_INDEX, NVL(A.SHORT_KEY, ' ') SHORT_KEY, NVL(A.CLASS_LEVEL, 1) CLASS_LEVEL FROM TD_B_SYSTEMGUIMENU A WHERE 1 = 1 AND (SUBSYS_CODE = :1 OR SUBSYS_CODE = 'PUB') AND NOT EXISTS (SELECT 1 FROM TD_B_HIDEMENUITEM WHERE MENU_ID = A.MENU_ID AND PROVINCE_CODE = A.PROVINCE_CODE AND STAFF_ID = :2 AND DEPART_ID = :3 AND PROVINCE_CODE = :4 ) AND A.PROVINCE_CODE = :5 ORDER BY A.SHOW_ORDER

SQL Id	SQL Text
0apbvns24jdc9	SQL Text Not Available
0tbgvuuq9kvvq	select F_SYS_GETSEQID('0769', 'seq_trade_id_poc') from dual
0uznvf6q4j8gv	select F_SYS_GETSEQID('0769', 'seq_operate_id') from dual
11gb0xb9vp04q	SQL Text Not Available
12hhcr6ucw6mb	SQL Text Not Available
144p979y5d4qk	SELECT count(1) recordcount FROM TD_M_DEPARTKIND A, TF_CHL_CHANNEL B, TD_CHL_KINDDEF C WHERE A.DEPART_KIND_CODE = B.CHNL_KIND_ID AND A.CODE_TYPE_CODE = 0 and b.eparchy_code = a.eparchy_code AND b.chnl_kind_id = c.chnl_kind_id and c.standard_kind_code like '2%' AND b.CHNL_ID = :1
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
1kdtdp53axrc0	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, Z.ENABLE_TAG, G.SP_PRODUCT_NAME ELEMENT_NAME, G.PRICE_DESCRIBE ELEMENT_DESC, to_char(Z.START_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') START_ABSOLUTE_DATE, Z.START_OFFSET, Z.START_UNIT, Z.END_ENABLE_TAG, to_char(Z.END_ABSOLUTE_DATE, 'yyyy-mm-dd hh24:mi:ss') END_ABSOLUTE_DATE, Z.END_OFFSET, Z.END_UNIT, ITEM_INDEX, -1 SCORE, -1 REWARD_LIMIT, G.SP_PRODUCT_ID SP_PRODUCT_ID, N.PARTY_ID PARTY_ID, G.SP_ID 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 = 'SP_SERV ICE_' \|\| TO_CHAR(G.SP_SERVICE_ID) AND (area_code = :3 OR area_code = :4 OR area_code = 'ZZZZ')) HAS_ATTR FROM TD_B_PACKAGE_ELEMENT M, (select t.party_id, t.sp_id from td_b_party_service t where t.states='2' AND SYSDATE BETWEEN t.start_date AND t.end_date GROUP BY t.party_id, t.sp_id) N, Td_b_Party_Product G, td_b_element_enable Z WHERE package_id = :5 AND Z.PID(+) = G.SP_SERVICE_ID AND SYSDATE BETWEEN M.start_date AND M.end_date AND (SYSDATE BETWEEN Z.start_date AND Z.end_date or z.start_date is null or z.end_date is null) AND M.element_type_code = 'X' --sp AND M.element_id = G.SP_SERVICE_ID AND N.SP_ID = G.SP_ID AND G.STATE = '4' -- AND N.STATES = '2' -- AND SYSDATE BETWEEN N.start_date AND N.end_date ) t1 WHERE substr(:6 , -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 = :7 AND E.data_code = F.role_code AND E.right_attr = '1' --?????1-?????? AND E.right_tag = '1' --?????1-?? AND F.data_ type = t1.ELEMENT_TYPE_CODE --?????3-???? AND F.data_code = TO_CHAR(t1.element_id)) ORDER BY ITEM_INDEX
1nktcbcjqsfqv	SQL Text Not Available
1r9u733n8t67x	SQL Text Not Available
1tudr8vp9cbz8	SELECT COUNT(1) FROM TD_B_PARTY_PRODUCT a WHERE a.sp_product_name LIKE '%' \|\| :1 \|\| '%' AND SYSDATE BETWEEN a.start_date and a.end_date AND a.state = '4' and( instr( a.product_city , :2 , 1 , 1 ) > 0 or trim( a.product_city ) = '01' ) AND( a.product_type_code = 1 or a.product_type_code is null ) AND( a.net_tag = :3 or a.net_tag is null or :4 is null ) AND( a.product_mode <> '1' OR a.product_mode IS NULL ) and a.prod_credit != '2' /?????/ and( a.province_code = :5 or a.province_code = 'ZZZZ' ) AND EXISTS( SELECT 1 FROM TD_B_PARTY_SERVICE b WHERE a.sp_id = b.sp_id AND a.party_id = b.party_id AND( b.sp_type_code = :6 or :7 is null ) AND b.states = '2' AND SYSDATE BETWEEN b.start_date and b.end_date ) AND EXISTS( SELECT 1 FROM TD_B_PARTY c WHERE c.party_id = a.party_id AND SYSDATE BETWEEN c.start_date and c.end_date ) AND EXISTS( SELECT 1 FROM tf_m_staffdataright e , tf_m_roledataright f WHERE e.staff_id = :8 AND e.data_code = f.role_code AND e.right_attr = '1' AND e.right_t ag = '1' AND f.data_type = 'X' AND f.data_code = to_char( a.sp_service_id ) ) AND A.SP_PRODUCT_ID != '6000000000' /????????????????/ ORDER BY a.sp_product_name
25vwt55t1093f	SQL Text Not Available
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
390ngbpv69txy	SQL Text Not Available
3f3hn3fpjzjpc	SQL Text Not Available
3gwrz9gzta4g7	SQL Text Not Available
3jwmr4t4sd4qj	select info.info_id, info.info_topic, info.send_date, infos.INST_ID from TF_F_INFO info, TF_F_INFO_INSTANCE infos where 1 = 1 AND info.info_type = :1 AND info.VALID_TIME >=to_date(to_char(SYSDATE, 'yyyy-mm-dd'), 'yyyy-mm-dd') AND info.CREATE_TIME <= to_date(to_char(SYSDATE, 'yyyy-mm-dd'), 'yyyy-mm-dd') AND info.info_id = infos.info_id AND infos.RECE_OBJ in (:2 , :3 , :4 , (select a.para_value1 from td_s_syspara_deflist a where a.eparchy_code='ZZZZ' and a.para_code1='GROUP_AREA_LIMIT' and a.para_code2='0')) AND NOT EXISTS (SELECT 1 FROM TF_F_INFO_INSTANCE_LOG ins where info.info_id = ins.info_id AND ins.rece_obj = :5 AND ins.RECE_OBJ_TYPE = :6 AND ins.inst_status = :7 ) ORDER BY SEND_DATE DESC
3r98xda66pqkg	SELECT seq_operate_id.nextval FROM DUAL
4cduyz74jf1np	SQL Text Not Available
4kwrndwqfhpvv	select * from (select row_., rownum rownum_ from (SELECT a.sp_product_id, a.sp_product_name, a.price_describe, a.sp_id, a.party_id, a.sp_service_id, '-1' package_id, to_char(end_date, 'yyyy-mm-dd hh24:mi:ss') End_Date FROM TD_B_PARTY_PRODUCT a WHERE a.sp_product_name LIKE '%' \|\| :1 \|\| '%' AND SYSDATE BETWEEN a.start_date and a.end_date AND a.state = '4' and (instr(a.product_city, :2 , 1, 1) > 0 or trim(a.product_city) = '01') AND (a.product_type_code = 1 or a.product_type_code is null) AND (a.net_tag = :3 or a.net_tag is null or :4 is null) AND (a.product_mode <> '1' OR a.product_mode IS NULL) and a.prod_credit != '2' /?????/ and (a.province_code = :5 or a.province_code ='ZZZZ') AND EXISTS (SELECT 1 FROM TD_B_PARTY_SERVICE b WHERE a.sp_id = b.sp_id AND a.party_id = b.party_id AND (b.sp_type_code = :6 or :7 is null) AND b.states = '2' AND SYSDATE BETWEEN b.start_date and b.end_date) AND EXISTS (SELECT 1 FROM TD_B_PARTY c WHERE c.party_id = a.party_id AND SYSDATE BET WEEN c.start_date and c.end_date) AND EXISTS (SELECT 1 FROM tf_m_staffdataright e, tf_m_roledataright f WHERE e.staff_id = :8 AND e.data_code = f.role_code AND e.right_attr = '1' AND e.right_tag = '1' AND f.data_type = 'X' AND f.data_code = to_char(a.sp_service_id)) AND A.SP_PRODUCT_ID!='6000000000'/????????????????*/ ORDER BY a.sp_product_name) row_ where rownum <= :9 ) where rownum_ > :10
4zgxvz101v3np	SELECT 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(START_DATE, 'yyyy-mm-dd hh24:mi:ss') START_DATE, to_char(END_DATE, 'yyyy-mm-dd hh24:mi:ss') END_DATE, MIN_NUMBER, MAX_NUMBER, to_char(CREATE_DATE, 'yyyy-mm-dd hh24:mi:ss') CREATE_DATE, VERSION, PRODUCT_STATE, UPDATE_STAFF_ID, UPDATE_DEPART_ID, to_char(UPDATE_TIME, 'yyyy-mm-dd hh24:mi:ss') UPDATE_TIME, 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_ATTR, a.NEED_EXP, to_number(rsrv_value2) PROD_LOW_COST FROM TD_B_PRODUCT A WHERE A.PRODUCT_ID = :3 AND sysdate BETWEEN A.start_date AND A.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=:4 OR release_area_code=:5 ) AND sysdate BETWEEN start_date AND end_date ) AND (substr(:6 , -8)='SUPERUSR' OR EXISTS (SELECT 1 FROM tf_m_staffdataright C, tf_m_roledataright D WHERE C.staff_id=:7 AND C.data_code=D.role_code AND C.right_attr='1' --?????1-?????? AND C.right_tag='1' --?????1-?? AND D.data_type='P' --?????P-???? AND D.data_code=TO_CHAR(A.product_id) ) )
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
5k0m9p5r81awv	SQL Text Not Available
5m6h90d4pbpfy	SELECT seq_trade_id.nextval FROM DUAL
5pyybh6rdun9c	SELECT a.PRODUCT_ID paracode, a.PRODUCT_NAME paraname FROM td_b_product a WHERE sysdate BETWEEN a.start_date AND a.end_date
5shc0vmk95hpx	select * from (select area.AREA_CODE, area.AREA_NAME, area.parent_area_code, area.area_level, area.order_no from td_m_staff_depart_rel rel, TD_M_DEPART dept, TD_M_AREA area where rel.DEPART_ID = dept.DEPART_ID and dept.AREA_CODE = area.AREA_CODE and rel.valid_flag = '0' and rel.staff_id = :1 and dept.RSVALUE2 = :2 and area.area_level = '30' and area.VALIDFLAG = '0' union select area2.AREA_CODE, area2.AREA_NAME, area2.parent_area_code, area2.area_level, area2.order_no from td_m_staff_depart_rel rel, TD_M_DEPART dept, TD_M_AREA area, TD_M_AREA area2 where rel.DEPART_ID = dept.DEPART_ID and dept.AREA_CODE = area.AREA_CODE and rel.valid_flag = '0' and rel.staff_id = :3 and dept.RSVALUE2 = :4 and area.area_level = '20' and area2.parent_area_code = area.area_code and area2.area_level = '30' and area2.VALIDFLAG = '0') a order by order_no
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
6d1jnnuhkt8wy	SQL Text Not Available
6yha0qjjasqxg	SQL Text Not Available
74w966npt951x	SELECT s.staff_id STAFFID, s.staff_id STAFFNAME, NVL(s.data_code, ' ') DATA_CODE, NVL(d.data_name, ' ') DATANAME, NVL(s.data_type, ' ') DATA_TYPE, DECODE(s.data_type, '0', '????', '1', '????', '2', '????', '3', '????', '4', '????', '9', '????', ' ') B_DATA_TYPE, NVL(s.right_tag, ' ') RIGHTTAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') B_RIGHTTAG, NVL(s.right_class, ' ') RIGHTCLASS, NVL(s.oper_special, ' ') OPERSPECIAL, NVL(s.rsvalue1, ' ') RSVALUE1, NVL(s.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDITTIME, s.accredit_staff_id ACCREDITSTAFFNAME, NVL(s.remark, ' ') REMARK, d.class_code CLASSCODE FROM tf_m_staffdataright s, td_m_dataright d WHERE s.right_attr='0' AND s.right_tag='1' AND s.data_code=d.data_code AND (s.data_type='0' OR s.data_type='1' OR s.data_type='9') AND (s.rsvalue1 IS NULL OR s.rsvalue1 != '1') AND s.data_type=d.data_type AND s.staff_id=:1 AND s.province_code = :2 AND s.province_code = d.province_code UNI ON SELECT s.staff_id STAFFID, s.staff_id STAFFNAME, NVL(r.data_code, ' ') DATA_CODE, NVL(d.data_name, ' ') DATANAME, NVL(s.data_type, ' ') DATA_TYPE, DECODE(s.data_type, '0', '????', '1', '????', '2', '????', '3', '????', '4', '????', '9', '????', ' ') B_DATA_TYPE, NVL(s.right_tag, ' ') RIGHTTAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') B_RIGHTTAG, NVL(r.right_class, ' ') RIGHTCLASS, NVL(r.oper_special, ' ') OPERSPECIAL, NVL(r.rsvalue1, ' ') RSVALUE1, NVL(r.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDITTIME, s.accredit_staff_id ACCREDITSTAFFNAME, NVL(s.remark, ' ') REMARK, d.class_code CLASSCODE FROM tf_m_staffdataright s, td_m_dataright d, tf_m_roledataright r WHERE s.right_attr='1' AND s.right_tag='1' AND s.data_code=r.role_code AND r.data_code=d.data_code AND s.data_type=d.data_type AND s.data_type=r.data_type AND (r.data_type='0' OR r.data_type='1' OR r.data_type='9') 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_staffdataright WHERE staff_id=s.staff_id AND data_code=r.data_code AND province_code = r.province_code AND data_type=r.data_type) AND s.staff_id=:3 AND r.province_code = :4 AND s.province_code = d.province_code AND d.province_code = r.province_code
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
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
8qmqtdw8abvdb	SQL Text Not Available
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
978w5zf7fb9kw	SELECT /+INDEX(s PK_TF_M_STAFFFUNCRIGHT)/ s.staff_id STAFFID, s.staff_id STAFF_NAME, NVL(s.right_code, ' ') RIGHT_CODE , NVL(f.right_name, ' ') RIGHT_NAME, NVL(f.right_attr, ' ') RIGHT_ATTR, DECODE(f.right_attr, '0', '????', '1', '??????', '2', '????', ' ') X_RIGHTATTR, NVL(s.right_tag, ' ') RIGHT_TAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') X_RIGHTTAG, NVL(s.extend_value1, ' ') EXTEND_VALUE1, NVL(s.extend_value2, 0) EXTEND_VALUE2, NVL(s.rsvalue1, ' ') RSVALUE1, NVL(s.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDIT_TIME, s.accredit_staff_id X_ACCREDIT_STAFF_ID, NVL(s.remark, ' ') REMARK, NVL(m.mod_name, ' ') MOD_NAME, NVL(m.mod_type, ' ') MOD_TYPE, NVL(f.class_code, ' ') CLASS_CODE 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.mod_code=m.mod_code(+) AND s.right_code=f.right_code AND s.province_code=f.province_code AND f.province_code=m.province_code AND (f. right_attr='1' OR f.right_attr='2') 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)/ s.staff_id STAFF_ID, s.staff_id STAFF_NAME, NVL(r.right_code, ' ') RIGHT_CODE , NVL(f.right_name, ' ') RIGHT_NAME, NVL(f.right_attr, ' ') RIGHT_ATTR, DECODE(f.right_attr, '0', '????', '1', '??????', '2', '????', ' ') RIGHT_ATTR, NVL(s.right_tag, ' ') RIGHT_TAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') X_RIGHTTAG, NVL(r.extend_value1, ' ') EXTEND_VALUE1, NVL(r.extend_value2, 0) EXTEND_VALUE2, NVL(r.rsvalue1, ' ') RSVALUE1, NVL(r.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDIT_TIME, s.accredit_staff_id X_ACCREDIT_STAFF_ID, NVL(s.remark, ' ') REMARK, NVL(m.mod_name, ' ') MOD_NAME, NVL(m.mod_type, ' ') MOD_TYPE, NVL(f.class_code, ' ') CLASS_CODE FROM tf_m_stafffuncright s, tf_m_rolefuncright r, td_s_modfile m, td_m_funcright f 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 f.mod_code=m.mod_code(+) AND s.province_code=r.province_code AND r.province_code=m.province_code AND m.province_code=f.province_code AND (f.right_attr='1' OR f.right_attr='2') 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 province_code=r.province_code AND r.province_code = :4 AND right_code=r.right_code) AND s.staff_id=:5 AND s.depart_id = :6 AND s.province_code = :7
99sn55ax21tna	select F_SYS_GETSEQID('0020', 'seq_operate_id') from dual
9d5gtsgdqdbdd	SELECT seq_trade_id_poc.nextval FROM DUAL
9q5jas50b88ud	SQL Text Not Available
9qykrbj46813q	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
a1za6987f3czy	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, td_s_productlimit 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 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 BETWEEN C.start_date AND C.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=:4 OR release_area_code=:5 ) AND sysdate BETWEEN start_date AND end_date) AND (substr(:6 , -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=:7 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_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 (:8 IS NULL OR sale_area_code = 'ZZ ZZ' OR sale_area_code = :9 )) --?? OR (sale_area_type = '30' AND (:10 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :11 )) --??? OR (sale_area_type = '20' AND (:12 IS NULL OR sale_area_code = 'ZZZZ' OR sale_area_code = :13 )) --?? 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
ahdcm6b9m36vu	SQL Text Not Available
aqhnb3czjtsxt	select F_SYS_GETSEQID('0020', 'seq_trade_id_poc') from dual
arp476pr8hrba	SQL Text Not Available
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
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
azyy2tkuyq6as	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, td_s_productlimit C, TD_S_PROD_SPEC_LIMIT 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 B ETWEEN C.start_date AND C.end_date AND D.product_id = a.PRODUCT_ID AND D.ID_TYPE= '0' AND D.ID = :4 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 T1 WHERE T1.data_type = 'P' AND T1.data_code = TO_CHAR(A.product_id) AND T1.ROLE_CODE = '09ZZZZZZ')) AND ( NOT EXISTS(SELECT 1 FROM td_b_product_salearea WHERE id_type = '0' AND a.product_id = pid AND start_date <= SYSDATE A ND 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
b0r4bhpm4ztd2	select to_clob(restart\|\|apply_name) , case when elaps <= 0 then to_number(null) else coord_total_received/elaps end rate_received_txn , case when elaps <= 0 then to_number(null) else coord_total_applied/elaps end rate_applied_txn , case when elaps <= 0 then to_number(null) else coord_total_rollbacks/elaps end rate_rollbacks_txn , case when elaps <= 0 then to_number(null) else server_total_messages_applied/elaps end server_apply_rate , server_elapsed_apply_time/ decode(server_total_messages_applied, 0, to_number(null) , server_total_messages_applied) server_apply_time_pm , server_elapsed_dequeue_time/ decode(server_total_messages_applied, 0, to_number(null) , server_total_messages_applied) server_deq_time_pm , case when elaps <= 0 then to_number(null) else reader_total_messages_dequeued/elaps end reader_rate_deq from (select e.apply_name , decode( e.startup_time, b.startup_time, null, '') restart , e.reader_total_messages_dequeued - nvl(b.reader_total_message s_dequeued, 0) reader_total_messages_dequeued , e.coord_total_received - nvl(b.coord_total_received, 0) coord_total_received , e.coord_total_applied - nvl(b.coord_total_applied, 0) coord_total_applied , e.coord_total_rollbacks - nvl(b.coord_total_rollbacks, 0) coord_total_rollbacks , e.coord_total_wait_deps - nvl(b.coord_total_wait_deps, 0) coord_total_wait_deps , e.coord_total_wait_cmts - nvl(b.coord_total_wait_cmts, 0) coord_total_wait_commits , e.server_total_messages_applied - nvl(b.server_total_messages_applied, 0) server_total_messages_applied , e.server_elapsed_dequeue_time - nvl(b.server_elapsed_dequeue_time, 0) server_elapsed_dequeue_time , e.server_elapsed_apply_time - nvl(b.server_elapsed_apply_time, 0) server_elapsed_apply_time , case when e.startup_time = b.startup_time then :ela else (cast(:e_eitvtime as date) - e.startup_time)24*3600 end elaps from dba_hist_streams_apply_sum b , dba_hist_streams_apply_sum e where b.snap_id (+)= :bid and e.snap_id = :e id and e.instance_number = :inst_num and b.instance_number (+)= e.instance_number and e.dbid = :dbid and b.dbid (+)= e.dbid and b.apply_name (+)= e.apply_name and b.startup_time (+)= e.startup_time order by e.apply_name )
b0vvjbafc1cbv	select * from (select row_., rownum rownum_ from (SELECT /+ first_rows / serial_number, NVL(to_char(fee_code_fee/100), '0') fee_code_fee, product_id, sim_card_no, nvl(to_char(advance_pay/100), '0') advance_pay, net_type_code, nvl(to_char(low_cost/100), '0') low_cost, lease_property_tag, decode(lease_property_tag, 0, nvl(lease_length, 0)\|\|'?', lease_length) lease_length, number_src, num_thaw_pro, first_month_amount, end_month_amount, number_type FROM (SELECT serial_number, fee_code_fee, product_id, sim_card_no, advance_pay, net_type_code, low_cost, lease_length, lease_property_tag, a.number_src, a.num_thaw_pro, a.first_month_amount, a.end_month_amount, a.number_type FROM tf_r_mphonecode_idle a WHERE 1 = 1 AND (sim_card_no is null OR sim_card_no = '') AND code_state_code = '9' AND preopen_tag = '0' AND eparchy_code = :1 AND INSTR(:2 , NUMBER_TYPE) > 0 AND code_type_code <> 'J' AND stock_id = :3 AND stock_level <> :4 AND package_flag = '0' AND SERIAL_NUMBER LIKE '% ' \|\| :5 \|\| '%' AND product_id is null UNION ALL SELECT serial_number, fee_code_fee, product_id, sim_card_no, advance_pay, net_type_code, low_cost, lease_length, lease_property_tag, B.number_src, B.num_thaw_pro, B.first_month_amount, B.end_month_amount, B.number_type FROM tf_r_mphonecode_idle B, (SELECT DISTINCT FROM(SELECT TO_CHAR(M.POOL_CODE) POOL_CODE, '3' NUMBER_SRC FROM TD_M_POOL_AUTH M WHERE ((M.AUTH_OBJ_TYPE = '0' AND M.AUTH_OBJ = :6 ) OR (M.AUTH_OBJ_TYPE = '1' AND M.AUTH_OBJ = :7 ) ) AND EXISTS (SELECT 1 FROM TD_M_POOL B WHERE B.POOL_CODE = M.POOL_CODE AND B.POOL_TYPE = '0' AND B.EPARCHY_CODE = M.EPARCHY_CODE AND B.EPARCHY_CODE = :8 AND B.VALID_TAG = '0') UNION ALL SELECT TO_CHAR(M.POOL_ID) POOL_CODE, '1\|2' NUMBER_SRC FROM TF_R_POOL_USER M WHERE ((M.USER_LEVEL = 'A' AND M.USER_ID = :9 ) OR (M.USER_LEVEL = 'B' AND M.USER_ID = :10 ) OR (M.USER_LEVEL IN ('C', 'D') AND M.USER_ID = :11 ) OR (M.USER_LEVEL = 'E' AND M.USER_ID = :12 ) OR (M.USER_LEVEL = 'F' AND M.USER_ID = :13 )) AND EXISTS (SELECT 1 FROM TF_R_POOL B WHERE M.POOL_ID = B.POOL_ID)) D)C WHERE 1 = 1 AND (B.sim_card_no is null OR B.sim_card_no = '') AND B.code_state_code = '9' AND B.preopen_tag = '0' AND B.eparchy_code = :14 AND INSTR(:15 , NUMBER_TYPE) > 0 AND code_type_code <> 'J' AND B.stock_level = :16 AND B.package_flag = '0' AND B.SERIAL_NUMBER LIKE '%' \|\| :17 \|\| '%' AND B.product_id is null AND B.POOL_CODE = C.POOL_CODE ) t WHERE NOT EXISTS (SELECT /+INDEX(f PK_TF_R_TEMPOCCUPY)/ 1 FROM tf_r_tempoccupy f WHERE f.res_no = t.serial_number AND res_type_code = '0' AND ( (occupy_staff_id != :18 AND (f.res_state_code='3' OR f.valid_time > SYSDATE) ) OR (occupy_staff_id = :19 AND f.res_state_code = '3' ) ) ) AND rownum < 2001 order by decode(number_type, '176', 1, '175', 2, 3) ) row_ where rownum <= :20 ) where rownum_ > :21
b5576mqw15vum	SQL Text Not Available
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
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
bya4d80vkp9t8	SQL Text Not Available
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
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
dmhyuxw9fx0hc	SELECT A.PARA_VALUE1 FROM TD_S_SYSPARA_DEFLIST A WHERE A.EPARCHY_CODE = 'ZZZZ' AND A.PARA_ATTR = '1000' AND A.PARA_CODE1 = 'GROUP_AREA_LIMIT' AND A.PARA_CODE2 = '0'
dqn46uz4zdh6v	SQL Text Not Available
dzan2tgvtkzdw	SQL Text Not Available
dzsjvy781bqf7	SQL Text Not Available
fa0uzvspp236d	SQL Text Not Available
fvyxwrszqr6cb	SELECT /+INDEX(s PK_TF_M_STAFFFUNCRIGHT)/ s.staff_id STAFF_ID, NVL(s.right_code, ' ') RIGHT_CODE , NVL(f.right_name, ' ') RIGHT_NAME, NVL(f.right_attr, ' ') RIGHT_ATTR, DECODE(f.right_attr, '0', '????', '1', '??????', '2', '????', ' ') X_RIGHTATTR, NVL(s.right_tag, ' ') RIGHT_TAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') X_RIGHTTAG, NVL(s.extend_value1, ' ') EXTEND_VALUE1, NVL(s.extend_value2, 0) EXTEND_VALUE2, NVL(s.rsvalue1, ' ') RSVALUE1, NVL(s.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDIT_TIME, NVL(s.remark, ' ') REMARK, NVL(m.mod_name, ' ') MOD_NAME, NVL(m.mod_type, ' ') MODT_YPE, NVL(f.class_code, ' ') CLASS_CODE 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.mod_code = m.mod_code(+) AND s.right_code = f.right_code AND s.province_code = m.province_code AND s.province_code = f.province_code AND f.right_attr = '0' 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)/ s.staff_id STAFF_ID, NVL(r.right_code, ' ') RIGHT_CODE , NVL(f.right_name, ' ') RIGHT_NAME, NVL(f.right_attr, ' ') RIGHT_ATTR, DECODE(f.right_attr, '0', '????', '1', '??????', '2', '????', ' ') X_RIGHTATTR, NVL(s.right_tag, ' ') RIGHT_TAG, DECODE(s.right_tag, '0', '??', '1', '??', ' ') X_RIGHTTAG, NVL(r.extend_value1, ' ') EXTEND_VALUE1, NVL(r.extend_value2, 0) EXTEND_VALUE2, NVL(r.rsvalue1, ' ') RSVALUE1, NVL(r.rsvalue2, ' ') RSVALUE2, NVL(TO_CHAR(s.accredit_time, 'yyyy/mm/dd hh24:mi:ss'), ' ') ACCREDIT_TIME, NVL(s.remark, ' ') REMARK, NVL(m.mod_name, ' ') MOD_NAME, NVL(m.mod_type, ' ') MOD_TYPE, NVL(f.class_code, ' ') CLASS_CODE FROM tf_m_stafffuncright s, tf_m_rolefuncright r, td_s_modfile m, td_m_funcright f WHERE s.right_attr = '1' AND s.right_tag = '1' AND s.right_code = r.role_cod e AND r.right_code = f.right_code AND f.mod_code = m.mod_code(+) AND s.province_code = m.province_code AND s.province_code = f.province_code AND s.province_code = r.province_code AND f.right_attr = '0' 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 (rsvalue1 IS NULL OR rsvalue1 !='1')) AND s.staff_id = :5 AND s.depart_Id = :6 AND s.province_code = :7
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
gsngqxt1zb8w8	SELECT A.MENU_ID MENU_ID, NVL(A.PARENT_MENU_ID, ' ') PARENT_MENU_ID, NVL(A.RIGHT_CODE, ' ') RIGHT_CODE, NVL(A.SUBSYS_CODE, ' ') SUBSYS_CODE, NVL(A.MENU_TITLE, ' ') MENU_TITLE, NVL(A.MENU_TEXT, ' ') MENU_TEXT, NVL(A.IMAGE_INDEX, -1) IMAGE_INDEX, NVL(A.SHOW_ORDER, -1) SHOW_ORDER, NVL(A.TOOLBAR_INDEX, -1) TOOLBAR_INDEX, NVL(A.SHORT_KEY, ' ') SHORT_KEY, NVL(A.CLASS_LEVEL, 1) CLASS_LEVEL FROM TD_B_SYSTEMGUIMENU A WHERE 1 = 1 AND (SUBSYS_CODE = :1 OR SUBSYS_CODE = 'PUB') AND NOT EXISTS (SELECT 1 FROM TD_B_HIDEMENUITEM WHERE MENU_ID = A.MENU_ID AND PROVINCE_CODE = A.PROVINCE_CODE AND STAFF_ID = :2 AND DEPART_ID = :3 AND PROVINCE_CODE = :4 ) AND A.PROVINCE_CODE = :5 ORDER BY A.SHOW_ORDER

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	402,927	223.18	40.58
execute count	91,540	50.70	9.22
gc cr block receive time	12	0.01	0.00
gc cr blocks received	173	0.10	0.02
gc current block receive time	17	0.01	0.00
gc current blocks received	225	0.12	0.02
logons cumulative	143	0.08	0.01
opened cursors cumulative	61,178	33.89	6.16
parse count (total)	46,581	25.80	4.69
parse time elapsed	257	0.14	0.03
physical reads	305	0.17	0.03
physical writes	2,990	1.66	0.30
redo size	4,239,108	2,348.06	426.90
session cursor cache hits	49,818	27.59	5.02
session logical reads	11,885,285	6,583.32	1,196.91
user calls	397,743	220.31	40.05
user commits	1,007	0.56	0.10
user rollbacks	8,923	4.94	0.90
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	13,405	7.43	1.35

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	12	0.01	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	54	0.03	0.01
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	33	0.02	0.00
Batched IO single block count	5	0.00	0.00
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	16	0.01	0.00
Batched IO vector read count	7	0.00	0.00
Block Cleanout Optim referenced	34	0.02	0.00
CCursor + sql area evicted	5	0.00	0.00
CPU used by this session	16,206	8.98	1.63
CPU used when call started	8,136	4.51	0.82
CR blocks created	6	0.00	0.00
Cached Commit SCN referenced	0	0.00	0.00
Clusterwide global transactions	15	0.01	0.00
Commit SCN cached	46	0.03	0.00
DBWR checkpoint buffers written	2,825	1.56	0.28
DBWR checkpoints	4	0.00	0.00
DBWR fusion writes	212	0.12	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	230	0.13	0.02
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	61	0.03	0.01
DBWR undo block writes	424	0.23	0.04
DDL statements parallelized	0	0.00	0.00
DFO trees parallelized	6	0.00	0.00
DX/BB enqueue lock background get time	1	0.00	0.00
DX/BB enqueue lock background gets	30	0.02	0.00
DX/BB enqueue lock foreground requests	135	0.07	0.01
Effective IO time	149,527	82.82	15.06
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	2,102	1.16	0.21
Heap Segment Array Inserts	310	0.17	0.03
Heap Segment Array Updates	2	0.00	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	45	0.02	0.00
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 not downgraded	6	0.00	0.00
Requests to/from client	359,950	199.38	36.25
RowCR - row contention	0	0.00	0.00
RowCR attempts	7	0.00	0.00
RowCR hits	7	0.00	0.00
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	360,108	199.47	36.26
SQL*Net roundtrips to/from dblink	0	0.00	0.00
active txn count during cleanout	183	0.10	0.02
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	24,462	13.55	2.46
branch node splits	1	0.00	0.00
buffer is not pinned count	8,327,756	4,612.79	838.65
buffer is pinned count	18,691,185	10,353.14	1,882.29
bytes received via SQL*Net from client	37,617,035	20,836.26	3,788.22
bytes received via SQL*Net from dblink	0	0.00	0.00
bytes sent via SQL*Net to client	223,405,162	123,745.22	22,498.00
bytes sent via SQL*Net to dblink	0	0.00	0.00
calls to get snapshot scn: kcmgss	632,192	350.17	63.66
calls to kcmgas	4,177	2.31	0.42
calls to kcmgcs	28,483	15.78	2.87
cell physical IO interconnect bytes	337,512,960	186,950.09	33,989.22
change write time	29	0.02	0.00
cleanout - number of ktugct calls	259	0.14	0.03
cleanouts and rollbacks - consistent read gets	1	0.00	0.00
cleanouts only - consistent read gets	89	0.05	0.01
cluster key scan block gets	370	0.20	0.04
cluster key scans	348	0.19	0.04
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	187	0.10	0.02
commit batch/immediate requested	187	0.10	0.02
commit cleanout failures: block lost	11	0.01	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	5	0.00	0.00
commit cleanout failures: cannot pin	1	0.00	0.00
commit cleanouts	3,808	2.11	0.38
commit cleanouts successfully completed	3,791	2.10	0.38
commit immediate performed	187	0.10	0.02
commit immediate requested	187	0.10	0.02
commit nowait performed	20	0.01	0.00
commit nowait requested	20	0.01	0.00
commit txn count during cleanout	358	0.20	0.04
commit wait/nowait performed	20	0.01	0.00
commit wait/nowait requested	20	0.01	0.00
consistent changes	387,690	214.74	39.04
consistent gets	10,749,688	5,954.31	1,082.55
consistent gets - examination	1,407,630	779.69	141.76
consistent gets direct	45	0.02	0.00
consistent gets from cache	10,749,634	5,954.28	1,082.54
consistent gets from cache (fastpath)	9,277,162	5,138.67	934.26
cursor authentications	62	0.03	0.01
data blocks consistent reads - undo records applied	6	0.00	0.00
db block gets	1,135,071	628.72	114.31
db block gets direct	0	0.00	0.00
db block gets from cache	1,135,071	628.72	114.31
db block gets from cache (fastpath)	4,976	2.76	0.50
deferred (CURRENT) block cleanout applications	1,303	0.72	0.13
dirty buffers inspected	1	0.00	0.00
drop segment calls in space pressure	0	0.00	0.00
enqueue conversions	7,062	3.91	0.71
enqueue releases	226,100	125.24	22.77
enqueue requests	226,729	125.59	22.83
enqueue timeouts	602	0.33	0.06
enqueue waits	1,320	0.73	0.13
exchange deadlocks	1	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	1,592	0.88	0.16
free buffer requested	86,452	47.89	8.71
gc blocks compressed	63,530	35.19	6.40
gc cr block flush time	7	0.00	0.00
gc cr blocks served	2,113	1.17	0.21
gc current block flush time	3	0.00	0.00
gc current block pin time	1	0.00	0.00
gc current blocks served	126,655	70.15	12.75
gc force cr disk read	42	0.02	0.00
gc kbytes saved	209,899	116.26	21.14
gc kbytes sent	820,246	454.34	82.60
gc local grants	542	0.30	0.05
gc read waits	0	0.00	0.00
gc remote grants	404	0.22	0.04
gcs messages sent	1,417,271	785.03	142.73
ges messages sent	8,114	4.49	0.82
global enqueue get time	417	0.23	0.04
global enqueue gets async	1,104	0.61	0.11
global enqueue gets sync	59,903	33.18	6.03
global enqueue releases	57,969	32.11	5.84
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	42	0.02	0.00
hot buffers moved to head of LRU	18	0.01	0.00
immediate (CR) block cleanout applications	90	0.05	0.01
immediate (CURRENT) block cleanout applications	664	0.37	0.07
index crx upgrade (positioned)	30	0.02	0.00
index crx upgrade (prefetch)	161	0.09	0.02
index fast full scans (full)	142	0.08	0.01
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	1,360,715	753.71	137.03
index scans kdiixs1	655,915	363.31	66.05
leaf node 90-10 splits	11	0.01	0.00
leaf node splits	58	0.03	0.01
lob reads	186,423	103.26	18.77
lob writes	132,457	73.37	13.34
lob writes unaligned	132,457	73.37	13.34
local undo segment hints helped	0	0.00	0.00
local undo segment hints were stale	0	0.00	0.00
logical read bytes from cache	97,359,282,176	53,927,785.30	9,804,560.14
max cf enq hold time	69	0.04	0.01
messages received	8,218	4.55	0.83
messages sent	8,218	4.55	0.83
min active SCN optimization applied on CR	634	0.35	0.06
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	9,058,033	5,017.29	912.19
non-idle wait count	496,303	274.90	49.98
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	92	0.05	0.01
parse time cpu	174	0.10	0.02
physical read IO requests	305	0.17	0.03
physical read bytes	2,498,560	1,383.96	251.62
physical read total IO requests	11,612	6.43	1.17
physical read total bytes	243,097,600	134,652.96	24,481.13
physical read total multi block requests	98	0.05	0.01
physical reads cache	260	0.14	0.03
physical reads cache prefetch	0	0.00	0.00
physical reads direct	45	0.02	0.00
physical reads direct (lob)	45	0.02	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	2,319	1.28	0.23
physical write bytes	24,494,080	13,567.39	2,466.67
physical write total IO requests	10,256	5.68	1.03
physical write total bytes	94,415,360	52,297.13	9,508.09
physical write total multi block requests	27	0.01	0.00
physical writes direct	0	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	2,990	1.66	0.30
physical writes non checkpoint	954	0.53	0.10
pinned buffers inspected	0	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	0	0.00	0.00
process last non-idle time	1,786	0.99	0.18
queries parallelized	6	0.00	0.00
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	141,553	78.41	14.26
recursive cpu usage	536	0.30	0.05
redo KB read	4,303	2.38	0.43
redo KB read (memory)	4,303	2.38	0.43
redo KB read (memory) for transport	4,303	2.38	0.43
redo KB read for transport	4,303	2.38	0.43
redo blocks checksummed by FG (exclusive)	3,514	1.95	0.35
redo blocks written	11,392	6.31	1.15
redo buffer allocation retries	0	0.00	0.00
redo entries	13,149	7.28	1.32
redo log space requests	0	0.00	0.00
redo ordering marks	341	0.19	0.03
redo size for direct writes	0	0.00	0.00
redo subscn max counts	592	0.33	0.06
redo synch long waits	537	0.30	0.05
redo synch time	74	0.04	0.01
redo synch time (usec)	757,872	419.79	76.32
redo synch time overhead (usec)	614,066,424	340,134.41	61,839.52
redo synch time overhead count (<128 msec)	0	0.00	0.00
redo synch time overhead count (<2 msec)	1,151	0.64	0.12
redo synch time overhead count (<32 msec)	0	0.00	0.00
redo synch time overhead count (<8 msec)	4	0.00	0.00
redo synch time overhead count (>=128 msec)	2	0.00	0.00
redo synch writes	1,165	0.65	0.12
redo wastage	1,313,596	727.61	132.29
redo write broadcast ack count	214	0.12	0.02
redo write broadcast ack time	47,967	26.57	4.83
redo write broadcast lgwr post count	0	0.00	0.00
redo write info find	1,157	0.64	0.12
redo write info find fail	0	0.00	0.00
redo write time	448	0.25	0.05
redo writes	4,007	2.22	0.40
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	187	0.10	0.02
rollbacks only - consistent read gets	5	0.00	0.00
root node splits	0	0.00	0.00
rows fetched via callback	415,535	230.17	41.85
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	15,989	8.86	1.61
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	26,603	14.74	2.68
sorts (rows)	535,639	296.69	53.94
space was found by tune down	0	0.00	0.00
sql area evicted	80	0.04	0.01
sql area purged	0	0.00	0.00
steps of tune down ret. in space pressure	0	0.00	0.00
summed dirty queue length	1	0.00	0.00
switch current to new buffer	224	0.12	0.02
table fetch by rowid	12,750,631	7,062.64	1,284.05
table fetch continued row	693	0.38	0.07
table scan blocks gotten	984,706	545.43	99.16
table scan rows gotten	63,446,730	35,143.46	6,389.40
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	18,620	10.31	1.88
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	279	0.15	0.03
total number of cf enq holders	146	0.08	0.01
total number of times SMON posted	362	0.20	0.04
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	187	0.10	0.02
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
tune down retentions in space pressure	0	0.00	0.00
undo change vector size	1,306,480	723.67	131.57
user logons cumulative	115	0.06	0.01
user logouts cumulative	128	0.07	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	365	354
opened cursors current	2,563	2,358
session cursor cache count	60,338,593	60,342,093
session pga memory	20,373,879,744	20,424,167,504
session pga memory max	34,978,114,976	34,952,361,232
session uga memory	185,557,524,080	185,551,013,128
session uga memory max	12,261,137,510,744	12,261,369,331,752
workarea memory allocated	67,018	65,520

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)
Others	222M	5.99	.123M	60M	2.13	.033M	10.8K	0.18
DBWR	0M	0.00	0M	23M	1.29	.013M	0
RMAN	8M	0.28	.004M	1M	0.05	.001M	520	0.14
LGWR	0M	0.00	0M	4M	2.22	.002M	0
Buffer Cache Reads	2M	0.15	.001M	0M	0.00	0M	277	6.84
Direct Reads	0M	0.02	0M	0M	0.00	0M	0
TOTAL:	232M	6.44	.129M	88M	5.68	.049M	11.6K	0.33

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
Control File	228M	6.17	.126M	61M	2.16	.034M	0.10	5.77
Data File	4M	0.27	.002M	28M	1.30	.016M	4.90
Log File	0M	0.00	0M	6M	2.23	.003M
TOTAL:	232M	6.44	.129M	95M	5.68	.053M	0.30	5.77

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	222M	5.99	.123M	60M	2.13	.033M	10.8K	0.18
Others (Control File)	221M	5.93	.122M	60M	2.13	.033M	10.7K	0.15
Others (Data File)	1M	0.06	.001M	0M	0.00	0M	100	2.80
DBWR	0M	0.00	0M	23M	1.29	.013M	0
DBWR (Data File)	0M	0.00	0M	23M	1.29	.013M	0
RMAN	8M	0.28	.004M	1M	0.05	.001M	520	0.14
RMAN (Control File)	7M	0.24	.004M	1M	0.04	.001M	440	0.09
RMAN (Data File)	1M	0.03	.001M	0M	0.01	0M	80	0.43
LGWR	0M	0.00	0M	5M	2.23	.003M	0
LGWR (Log File)	0M	0.00	0M	5M	2.23	.003M	0
Buffer Cache Reads	2M	0.15	.001M	0M	0.00	0M	278	6.80
Buffer Cache Reads (Data File)	2M	0.15	.001M	0M	0.00	0M	278	6.80
Direct Reads	0M	0.02	0M	0M	0.00	0M	0
Direct Reads (Data File)	0M	0.02	0M	0M	0.00	0M	0
TOTAL:	232M	6.44	.129M	89M	5.68	.049M	11.6K	0.33

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes
TBS_CEN_IUSR	38	8.16	1.00	813	0.02	8
SYSAUX	157	4.97	1.00	494	0.09	5
TBS_CEN_DUSR	25	9.20	1.00	526	0.01	8
TBS_CEN_IPARAM	21	7.14	1.00	160	0.01	7
UNDOTBS1	0	0.00	0.00	141	0.00	0
TBS_CEN_DEF	6	6.67	1.00	102	0.00	7
SYSTEM	61	6.89	1.00	21	0.03	7
TBS_CEN_DPARAM	7	5.71	1.00	57	0.00	10
GOLDENGATE	0	0.00	0.00	4	0.00	0
USERS	1	10.00	1.00	0	0.00	10

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Av 1-bk Rd(ms)	Writes
GOLDENGATE	/essdata34/oradata/ess34/goldengate01.dbf	0				4
SYSAUX	/essorasys34/oradata/ess34/sysaux01.dbf	157	4.97	1.00	4.97	494
SYSTEM	/essorasys34/oradata/ess34/system01.dbf	61	6.89	1.00	7.05	21
TBS_CEN_DEF	/essdata34/oradata/ess34/tbs_cen_def_01.dbf	2	5.00	1.00	10.00	11
TBS_CEN_DEF	/essdata34/oradata/ess34/tbs_cen_def_02.dbf	0				1
TBS_CEN_DEF	/essdata34/oradata/ess34/tbs_cen_def_03.dbf	3	6.67	1.00	6.67	77
TBS_CEN_DEF	/essdata34/oradata/ess34/tbs_cen_def_04.dbf	1	10.00	1.00	0.00	1
TBS_CEN_DEF	/essdata34/oradata/ess34/tbs_cen_def_5.dbf	0				12
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_01.dbf	3	6.67	1.00	6.67	9
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_02.dbf	1	0.00	1.00	10.00	20
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_03.dbf	2	10.00	1.00	15.00	13
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_04.dbf	0				6
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_07.dbf	0				2
TBS_CEN_DPARAM	/essdata34/oradata/ess34/tbs_cen_dparam_5.dbf	1	0.00	1.00	10.00	7
TBS_CEN_DUSR	/essdata34/oradata/ess34/tbs_cen_dusr_01.dbf	5	8.00	1.00	8.00	123
TBS_CEN_DUSR	/essdata34/oradata/ess34/tbs_cen_dusr_02.dbf	3	10.00	1.00	10.00	178
TBS_CEN_DUSR	/essdata34/oradata/ess34/tbs_cen_dusr_3.dbf	10	10.00	1.00	9.00	16
TBS_CEN_DUSR	/essdata34/oradata/ess34/tbs_cen_dusr_4.dbf	7	8.57	1.00	7.14	209
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_01.dbf	6	5.00	1.00	5.00	22
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_02.dbf	0				15
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_03.dbf	6	6.67	1.00	6.67	17
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_04.dbf	1	0.00	1.00	0.00	11
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_05.dbf	0				18
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_06.dbf	0				16
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_07.dbf	3	10.00	1.00	10.00	36
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_08.dbf	2	10.00	1.00	10.00	7
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_10.dbf	1	10.00	1.00	10.00	11
TBS_CEN_IPARAM	/essdata34/oradata/ess34/tbs_cen_iparam_9.dbf	2	10.00	1.00	10.00	7
TBS_CEN_IUSR	/essdata34/oradata/ess34/tbs_cen_iusr_01.dbf	23	7.39	1.00	7.39	341
TBS_CEN_IUSR	/essdata34/oradata/ess34/tbs_cen_iusr_02.dbf	10	10.00	1.00	10.00	264
TBS_CEN_IUSR	/essdata34/oradata/ess34/tbs_cen_iusr_3.dbf	5	8.00	1.00	8.00	208
UNDOTBS1	/essorasys34/oradata/ess34/undotbs101.dbf	0				35
UNDOTBS1	/essorasys34/oradata/ess34/undotbs102.dbf	0				106
USERS	/essorasys34/oradata/ess34/users_2.dbf	1	10.00	1.00	10.00	0

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,599,040	100	11,893,019	257	2,990	0	0	0

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 2,990

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	2,595	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	0	870	4059	21531	6794766	21531			0
E	0	0	590	3277	12485	6794766	12485			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,072	0.10	360	155.00	60,331,844	1	341790405.00
D	6,144	0.20	720	10.25	3,988,414	1	21482691.00
D	9,216	0.30	1,080	2.05	797,402	1	3342052.00
D	12,288	0.40	1,440	1.59	620,708	1	2337561.00
D	15,360	0.50	1,800	1.42	552,525	1	1949946.00
D	18,432	0.60	2,159	1.30	506,003	1	1685473.00
D	21,504	0.70	2,519	1.21	469,434	1	1477578.00
D	24,576	0.80	2,879	1.13	438,679	1	1302739.00
D	27,648	0.90	3,239	1.06	411,571	1	1148633.00
D	30,720	1.00	3,599	1.00	389,229	1	1021617.00
D	33,792	1.10	3,959	0.96	372,589	1	927022.00
D	36,864	1.20	4,319	0.92	359,429	1	852209.00
D	39,936	1.30	4,679	0.89	348,162	1	788159.00
D	43,008	1.40	5,039	0.87	338,089	1	730893.00
D	46,080	1.50	5,399	0.85	329,376	1	681363.00
D	49,152	1.60	5,758	0.82	320,900	1	633174.00
D	52,224	1.70	6,118	0.81	313,767	1	592626.00
D	55,296	1.80	6,478	0.79	305,957	1	548227.00
D	58,368	1.90	6,838	0.77	300,369	1	516460.00
D	61,440	2.00	7,198	0.72	282,163	1	412957.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	1,218	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,365	1,340.88	0.00	0.00	0.00	0.00	1,048,570
E	10,240	8,329	1,361.38	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	12,142	12,142
64K	128K	86	86
128K	256K	352	352
256K	512K	2	2
512K	1024K	151	151
1M	2M	596	596
2M	4M	74	74
4M	8M	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	295,715,686.47	23,551,423.91	93.00	776,420	36,652,067,633
2,560	0.25	295,715,686.47	404,105.46	100.00	2	33,994,740,731
5,120	0.50	295,715,686.47	404,101.17	100.00	0	33,994,740,238
7,680	0.75	295,715,686.47	404,101.17	100.00	0	33,994,740,238
10,240	1.00	295,715,686.47	22,312.06	100.00	0	33,950,910,606
12,288	1.20	295,715,686.47	21,436.63	100.00	0	33,950,810,106
14,336	1.40	295,715,686.47	21,436.63	100.00	0	33,950,810,106
16,384	1.60	295,715,686.47	21,436.63	100.00	0	33,950,810,106
18,432	1.80	295,715,686.47	21,436.63	100.00	0	33,950,810,106
20,480	2.00	295,715,686.47	21,436.63	100.00	0	33,950,810,106
30,720	3.00	295,715,686.47	21,436.63	100.00	0	33,950,810,106
40,960	4.00	295,715,686.47	21,436.63	100.00	0	33,950,810,106
61,440	6.00	295,715,686.47	21,436.63	100.00	0	33,950,810,106
81,920	8.00	295,715,686.47	21,436.63	100.00	0	33,950,810,106

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,912	0.89	775	12,089	189,200,450	0.95	11,101,781	9.01	3,779,306
7,040	0.90	903	14,386	191,375,197	0.96	8,927,034	7.24	4,008,068
7,168	0.92	1,031	16,683	193,486,124	0.97	6,816,107	5.53	4,233,878
7,296	0.93	1,157	19,905	195,155,703	0.98	5,146,528	4.18	80,808
7,424	0.95	1,285	22,720	196,705,011	0.99	3,597,220	2.92	219,774
7,552	0.97	1,412	25,037	198,152,743	1.00	2,149,488	1.74	354,699
7,680	0.98	1,540	27,157	199,065,142	1.00	1,237,089	1.00	467,724
7,808	1.00	1,667	30,658	199,069,984	1.00	1,232,247	1.00	467,984
7,936	1.02	1,794	33,622	199,070,436	1.00	1,231,795	1.00	468,009
8,064	1.03	1,922	36,197	199,070,832	1.00	1,231,399	1.00	468,029
8,192	1.05	2,050	39,585	199,071,160	1.00	1,231,071	1.00	468,047
8,320	1.07	2,177	42,913	199,071,478	1.00	1,230,753	1.00	468,063
8,448	1.08	2,305	46,452	199,071,723	1.00	1,230,508	1.00	468,077
8,576	1.10	2,432	50,236	199,071,950	1.00	1,230,281	1.00	468,088
8,704	1.11	2,560	53,984	199,072,124	1.00	1,230,107	1.00	468,097
8,832	1.13	2,688	57,184	199,072,268	1.00	1,229,963	1.00	468,105
8,960	1.15	2,816	60,297	199,072,383	1.00	1,229,848	1.00	468,112
9,600	1.23	3,456	76,218	199,072,885	1.00	1,229,346	1.00	468,139
10,496	1.34	4,352	99,433	199,073,511	1.00	1,228,720	1.00	468,171
11,392	1.46	5,248	122,648	199,074,033	1.00	1,228,198	1.00	468,200
12,288	1.57	6,144	145,863	199,074,566	1.00	1,227,665	1.00	468,226
13,184	1.69	7,040	169,078	199,075,042	1.00	1,227,189	1.00	468,250
14,080	1.80	7,936	192,293	199,075,451	1.00	1,226,780	1.00	468,272
14,976	1.92	8,832	215,508	199,075,844	1.00	1,226,387	1.00	468,293
15,872	2.03	9,728	238,723	199,076,229	1.00	1,226,002	0.99	468,311

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	64,078,791	3,988,424,050
20,480	0.50	45,935,055	797,412,350
25,600	0.63	44,543,744	552,509,802
30,720	0.75	44,072,705	469,448,448
35,840	0.88	43,745,594	411,570,176
40,960	1.00	43,614,750	389,228,462
46,080	1.13	43,444,653	359,413,562
51,200	1.25	43,326,894	338,083,842
56,320	1.38	43,226,580	320,918,867
61,440	1.50	43,143,712	305,972,494
66,560	1.63	43,108,820	300,367,604
71,680	1.75	43,004,144	282,151,712
76,800	1.88	43,004,144	282,151,712
81,920	2.00	43,004,144	282,151,712

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
128	0.50	0	0	0	0
256	1.00	0	0	0	0
384	1.50	0	0	0	0
512	2.00	0	0	0	0
640	2.50	0	0	0	0
768	3.00	0	0	0	0
896	3.50	0	0	0	0
1,024	4.00	0	0	0	0
1,152	4.50	0	0	0	0
1,280	5.00	0	0	0	0
1,408	5.50	0	0	0	0
1,536	6.00	0	0	0	0
1,664	6.50	0	0	0	0
1,792	7.00	0	0	0	0
1,920	7.50	0	0	0	0
2,048	8.00	0	0	0	0
2,176	8.50	0	0	0	0
2,304	9.00	0	0	0	0
2,432	9.50	0	0	0	0
2,560	10.00	0	0	0	0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
CO-KTUCLO Master Slave enq (master slave det)	601	0	601	601	1	1.09
XR-Quiesce / Force Logging (database force logging)	597	597	0	597	1	1.03
WF-AWR Flush	20	20	0	15	0	17.33
CF-Controlfile Transaction	5,168	5,167	0	60	0	1.68
TM-DML	2,179	2,179	0	2	0	42.50
PS-PX Process Reservation	39	39	0	18	0	2.06
TC-Tablespace Checkpoint	12	12	0	5	0	3.00
TD-KTF map table enqueue (KTF dump entries)	5	5	0	4	0	1.75
TA-Instance Undo	11	11	0	5	0	1.00
TK-Auto Task Serialization (Auto Task Serialization)	3	3	0	3	0	1.00
JS-Job Scheduler (job run lock - synchronize)	4	3	1	4	0	0.50
FB-Format Block	5	5	0	2	0	0.50
AF-Advisor Framework (task serialization)	7	7	0	1	0	1.00
DR-Distributed Recovery	1	1	0	1	0	1.00
MW-MWIN Schedule	1	1	0	1	0	1.00
TX-Transaction (row lock contention)	1	1	0	1	0	1.00
HW-Segment High Water Mark	1,527	1,527	0	1	0	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
2	0.32	1,443	891	3	9140.5/9144.5	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
04-Mar 23:59	60	366	891	3	9,145	0/0	0/0/0/0/0/0
04-Mar 23:49	49	391	287	2	9,144	0/0	0/0/0/0/0/0
04-Mar 23:39	209	686	891	3	9,140	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
AQ dequeue txn counter latch	60	0.00		0
ASM db client latch	3,843	0.00		0
ASM map operation hash table	1	0.00		0
ASM network state latch	29	0.00		0
AWR Alerted Metric Element list	23,393	0.00		0
Change Notification Hash table latch	601	0.00		0
Consistent RBA	4,002	0.00		0
DML lock allocation	4,426	0.00		0
Event Group Locks	280	0.00		0
FAL Queue	102	0.00		0
FIB s.o chain latch	40	0.00		0
FOB s.o list latch	594	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	431	0.00		366	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	3	0.00		0
JS broadcast add buf latch	6,485	0.00		0
JS broadcast drop buf latch	6,486	0.00		0
JS broadcast load blnc latch	6,433	0.00		0
JS mem alloc latch	10	0.00		0
JS queue access latch	11	0.00		0
JS queue state obj latch	193,044	0.00		0
JS slv state obj latch	13	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	1,676	0.18	0.00	615	0.00
KJCT flow control latch	210,863	0.00	0.00	0
KMG MMAN ready and startup request latch	602	0.00		0
KSXR large replies	120	0.00		0
KTF sga latch	16	0.00		584	0.00
KWQMN job cache list latch	130	0.00		0
KWQP Prop Status	2	0.00		0
KWQS pqueue ctx latch	2	0.00		0
LGWR NS Write	8,064	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	1	0.00		0
MQL Tracking Latch	0			35	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	641	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	656	0.00		0
OS process allocation	3,943	0.00		0
OS process: request allocation	277	0.00		0
PL/SQL warning settings	472	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	41,377	0.00		0
Result Cache: MB Latch	3,044	0.00		0
Result Cache: RC Latch	3,044	0.00		0
SGA IO buffer pool latch	1	0.00		1	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,791	0.00
SQL memory manager workarea list latch	202,259	0.00		0
Shared B-Tree	69	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	24,408	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	9,483	1.08	0.01	0
active service list	66,148	0.00		1,449	0.00
archive control	150	0.00		0
archive process latch	216	0.00		0
begin backup scn array	20	0.00		0
buffer pool	1	0.00		0
business card	13	0.00		0
cache buffer handles	6,488	0.02	0.00	0
cache buffers chains	23,697,940	0.01	0.00	51,471	0.00
cache buffers lru chain	5,268	0.02	0.00	262,791	0.01
call allocation	772	0.00		0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	416	0.00		0
channel operations parent latch	781,979	0.02	0.01	0
checkpoint queue latch	3,002,213	0.00	0.00	2,761	0.00
client/application info	1,059	0.00		0
compile environment latch	146	0.00		0
corrupted undo seg latch	748	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	29	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	29	0.00		0
device information	100	0.00		0
dml lock allocation	29	0.00		0
done queue latch	1	0.00		0
dummy allocation	304	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		445,727	0.00
enqueue hash chains	471,915	0.00	0.00	2	0.00
error message lists	24	0.00		0
fifteenth spare latch - children	1	0.00		0
file cache latch	398	0.00		0
first Audit Vault latch	105	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	270,331	0.00	0.20	2,062	0.00
gcs commit scn state	1	0.00		0
gcs opaque info freelist	125,852	0.93	0.00	0
gcs partitioned table hash	7,668,363	0.13	0.00	0
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	2	0.00		0
gcs resource freelist	1,261,326	0.00		1,415,195	0.00
gcs resource hash	3,179,699	0.00	0.00	1	0.00
gcs resource scan list	3	0.00		0
gcs resource validate list	1	0.00		0
gcs shadows freelist	1,485,963	0.00		1,488,389	0.00
ges caches resource lists	53,254	0.05	0.00	23,465	0.00
ges deadlock list	80	0.00		0
ges domain table	115,379	0.00		0
ges enqueue table freelist	120,155	0.00		0
ges group table	115,773	0.00		0
ges process hash list	11,641	0.00		0
ges process parent latch	243,716	0.00	1.00	0
ges process table freelist	277	0.00		0
ges resource hash list	249,809	0.05	0.18	43	9.30
ges resource scan list	113	1.77	0.00	0
ges resource table freelist	1,607	0.00		0
ges timeout list	570	0.00		19	0.00
ges value block free list	232	0.00		0
global KZLD latch for mem in SGA	105	0.00		0
global tx hash mapping	166	0.00		0
granule operation	1	0.00		0
hash table column usage latch	119	0.00		19,444	0.00
hash table modification latch	94	0.00		0
heartbeat check	1	0.00		697	0.00
heartbeat structure management	0			361	0.00
internal temp table object number allocation latch	5	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	5	0.00		4	25.00
job_queue_processes free list latch	12	0.00		0
job_queue_processes parameter latch	6,463	0.00		0
k2q global data latch	1,264	0.00		0
k2q lock allocation	181	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	4	0.00		0
krbmrosl	60	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	71	0.00		0
ksim membership request latch	0			1,310	0.00
kss move lock	19	0.00		0
ksuosstats global area	184	0.00		0
ksv allocation latch	65	0.00		0
ksv class latch	3,289	0.00		0
ksv msg queue latch	1	0.00		0
ksxp shared latch	277	0.00		0
ksxp so latch	277	0.00		0
ksz_so allocation latch	277	0.00		0
ktm global data	739	0.00		0
kwqbsn:qsga	65	0.00		0
lgwr LWN SCN	5,353	0.00		0
list of block allocation	217	0.00		0
loader state object freelist	84	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	2	0.00		0
logminer local	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		1	0.00
managed standby latch	72	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	11,748	0.00		0
messages	118,216	0.28	0.00	0
mostly latch-free SCN	5,405	0.89	0.00	0
msg queue latch	1	0.00		0
multiblock read objects	52	0.00		0
name-service memory objects	3,853	0.00		0
name-service namespace bucket	10,687	0.00		0
name-service namespace objects	6	0.00		0
name-service pending queue	1,560	0.00		0
name-service request	18	0.00		0
name-service request queue	18,605	0.00		0
ncodef allocation latch	29	0.00		0
nineth spare latch - X parent	1	0.00		0
object queue header heap	823	0.00		431	0.00
object queue header operation	184,530	0.00	0.00	0
object stats modification	10	0.00		0
parallel query alloc buffer	1,333	0.00		0
parallel query stats	28	0.00		0
parallel txn reco latch	10,620	0.00		0
parameter list	1,113	0.00		0
parameter table management	701	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,369	0.00		24,914	0.00
process allocation	8,448	0.00		133	0.00
process group creation	277	0.00		0
process queue	73	0.00		0
process queue reference	1,027	0.00		99	0.00
qmn task queue latch	384	0.00		0
query server freelists	61	0.00		0
query server process	9	0.00		3	0.00
queued dump request	6	0.00		0
queuing load statistics	1	0.00		0
readredo stats and histogram	3,996	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	30,815	0.02	0.00	13,176	0.13
redo copy	1	0.00		13,182	0.16
redo writing	24,055	0.32	0.00	0
resmgr group change latch	136	0.00		0
resmgr:active threads	304	0.00		0
resmgr:actses change group	136	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	303	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	322,741	0.04	0.00	16	0.00
rules engine rule set statistics	100	0.00		0
second Audit Vault latch	1	0.00		0
sequence cache	22,304	0.12	0.00	0
session allocation	84,839	0.02	0.00	84,542	0.04
session idle bit	885,451	0.00	0.00	0
session queue latch	1	0.00		0
session state list latch	333	0.00		0
session switching	174	0.00		0
session timer	601	0.00		0
seventh spare latch - X parent	1	0.00		0
shared pool	65,956	0.00		11	0.00
shared pool sim alloc	3	0.00		0
shared pool simulator	416	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	724,071	0.00		0
simulator lru latch	1	0.00		723,992	0.11
sixth spare latch - X parent	1	0.00		0
sort extent pool	434	0.00		0
space background state object latch	4	0.00		0
space background task latch	2,182	0.00		1,204	0.00
state object free list	2	0.00		0
statistics aggregation	504	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	4	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	163	0.00		0
transaction allocation	311	0.00		0
transaction branch allocation	721	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	8,371	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			4,225	0.07

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	23,697,940	1,194	4	1,190
gcs opaque info freelist	125,852	1,171	1	1,170
channel operations parent latch	781,979	145	1	144
ges resource hash list	249,809	125	22	103
active checkpoint queue latch	9,483	102	1	101
gc element	270,331	5	1	4
ges process parent latch	243,716	4	4	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
active checkpoint queue latch	kcbbacq: scan active checkpoints	1	1
cache buffers chains	kcbbxsv	6	6
cache buffers chains	kcbgtcr: fast path (cr pin)	3	0
cache buffers chains	kcbget: fast exchange	1	0
channel operations parent latch	ksrsconsume()	1	0
channel operations parent latch	ksrwait()	1	0
gc element	kclrwrite	1	1
gcs opaque info freelist	kjbrinfofree free opaque info	1	0
ges process parent latch	kjata_fg	4	0
ges resource hash list	kjrmas1: lookup master node	9	2
ges resource hash list	kjakcai: search for resp by resname	6	2
ges resource hash list	kjlmfnd: search for lockp by rename and inst id	5	0
ges resource hash list	kjlrlr: remove lock from resource queue	2	6
object queue header operation	kcbo_switch_q_bg	1	1

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglhdgn2 106	1,789
Library Cache	kglpndl1 95	1,541
Library Cache	kglhdgn1 62	1,279
Library Cache	kgllkdl1 85	810
Cursor Pin	kksfbc [KKSCHLPIN1]	625
Library Cache	kglget1 1	242
Library Cache	kglpnal1 90	240
Library Cache	kglpin1 4	222
Library Cache	kglpnal2 91	36
Library Cache	kgllkc1 57	8
Cursor Pin	kksLockDelete [KKSCHLPIN6]	3
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	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: 11,885,285
Captured Segments account for 86.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	4,188,416	35.24
SYS	TEMP1	SYS_TEMP_0FD9D67F6_FEED9793		TABLE	1,353,696	11.39
UCR_CEN1	TBS_CEN_DPARAM	TF_M_ROLEDATARIGHT_NEW	TF_M_ROLEDATARIGHT_NEW_04	TABLE PARTITION	436,864	3.68
UCR_CEN1	TBS_CEN_DPARAM	TF_M_ROLEDATARIGHT_NEW	TF_M_ROLEDATARIGHT_NEW_05	TABLE PARTITION	388,688	3.27
UCR_CEN3	TBS_CEN_DPARAM	TD_B_PRODUCT		TABLE	380,416	3.20

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.78	Soft Parse %:	99.80
Execute to Parse %:	49.11	Latch Hit %:	99.97
Parse CPU to Parse Elapsd %:	67.70	% Non-Parse CPU:	98.20

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	COL_USAGE$		TABLE	11	3.61
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM	WRH$_EVENT__3385539608_36452	TABLE PARTITION	9	2.95
SYS	SYSAUX	WRH$_SYSMETRIC_SUMMARY_INDEX		INDEX	9	2.95
SYS	SYSAUX	WRH$_BG_EVENT_SUMMARY_PK		INDEX	5	1.64
SYS	SYSAUX	WRM$_SNAPSHOT_DETAILS_INDEX		INDEX	5	1.64

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
UCR_CEN3	TBS_CEN_DUSR	TF_R_MPHONECODE_IDLE		TABLE	158	5.28
SYS	SYSAUX	WRH$_LATCH	WRH$_LATCH_3385539608_36452	TABLE PARTITION	54	1.81
SYS	SYSTEM	COL_USAGE$		TABLE	32	1.07
SYS	SYSAUX	WRH$_LATCH_PK	WRH$_LATCH_3385539608_36452	INDEX PARTITION	31	1.04
UCR_CEN3	TBS_CEN_IUSR	PK_TL_M_STAFFLOG		INDEX	23	0.77

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	CR Blocks Received	%Total
SYS	SYSTEM	JOB$		TABLE	24	13.87
SYS	SYSAUX	WRH$_SQLTEXT_PK		INDEX	12	6.94
SYS	SYSTEM	I_MON_MODS$_OBJ		INDEX	10	5.78
SYS	SYSAUX	WRH$_SEG_STAT_OBJ		TABLE	7	4.05
SYS	SYSAUX	WRH$_LATCH	WRH$_LATCH_3385539608_36452	TABLE PARTITION	6	3.47

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	33	6.06	0	1
dc_files	1,150	0.00	0	50
dc_global_oids	71	0.00	0	17
dc_histogram_data	3,069	2.02	0	8,002
dc_histogram_defs	2,272	10.48	0	4,787
dc_object_grants	2	0.00	0	20
dc_objects	14,801	0.27	5	2,181
dc_profiles	214	0.00	0	1
dc_rollback_segments	15,804	0.00	0	887
dc_segments	1,029	0.58	1	1,469
dc_sequences	1	0.00	1	11
dc_tablespaces	30,623	0.00	0	24
dc_users	39,612	0.01	0	152
global database name	1,710	0.00	0	1
outstanding_alerts	57	100.00	0	0
sch_lj_oids	6	33.33	0	8

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
ACCOUNT_STATUS	315	0.32	0		0
BODY	161	0.00	1,300	0.00	0
DBLINK	336	0.00	0		0
EDITION	124	0.00	231	0.00	0
INDEX	14,451	0.00	27	3.70	1
QUEUE	0		30	0.00	0
SCHEMA	111	0.00	0		0
SQL AREA	10,769	0.07	116,463	0.13	66
SQL AREA BUILD	80	63.75	0		0
SQL AREA STATS	75	61.33	75	61.33	0
TABLE/PROCEDURE	15,294	0.01	22,327	0.49	50
TRIGGER	234	0.00	234	0.00	0

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases
ACCOUNT_STATUS	315	0	0
BODY	0	1,297	1,297
DBLINK	336	0	0
EDITION	124	126	126
INDEX	27	27	27
QUEUE	0	30	30
SCHEMA	107	0	0
TABLE/PROCEDURE	719	21,763	21,763
TRIGGER	0	234	234

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	30,720.00	30,720.00	30,720.00	32,512.00	SHR/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	896.00	896.00	896.00	896.00	STA/
large pool	1,024.00	1,024.00	1,024.00	1,024.00	STA/
shared pool	7,808.00	7,808.00	3,456.00	7,808.00	GRO/DEF
streams pool	256.00	256.00	0.00	256.00	GRO/IMM

	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,056.93		2.89	6.46	66	66	366	366
B	Freeable	255.69	0.00	1.03	1.23	14		249	249
B	PL/SQL	18.33	14.02	0.05	0.03	0	0	366	365
B	SQL	10.28	2.39	0.03	0.09	2	19	328	290
E	Other	1,099.15		3.10	6.80	66	66	355	355
E	Freeable	235.00	0.00	1.03	1.28	14		228	228
E	PL/SQL	19.67	15.73	0.06	0.14	3	3	355	354
E	SQL	7.83	0.77	0.02	0.04	0	19	316	277

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	32,212,254,720
Fixed Size	2,255,784
Redo Buffers	74,428,416
Variable Size	10,468,983,896

Pool	Name	Begin MB	End MB	% Diff
java	free memory	896.00	896.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	366.02	365.57	-0.12
shared	SQLA	1,845.75	1,844.60	-0.06
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,660.84	1,663.12	0.14
shared	gc name table	96.00	96.00	0.00
shared	gcs resources	993.43	993.43	0.00
shared	gcs shadows	687.76	687.76	0.00
shared	ges big msg buffers	102.46	102.46	0.00
shared	ges enqueues	142.51	142.51	0.00
shared	ges resource	111.31	111.31	0.00
shared	ksunfy : SSO free list	107.87	107.87	0.00
streams	free memory	255.99	255.99	0.00
	buffer_cache	30,720.00	30,720.00	0.00
	fixed_sga	2.15	2.15	0.00
	log_buffer	70.98	70.98	0.00

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Coordinator	0923 00:19:47	0.08	0.00	0.00
QMON Slaves	0923 00:19:58	0.02	0.00	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	1
large_pool_size	1073741824
local_listener	(ADDRESS=(PROTOCOL=TCP)(HOST=10.161.2.8)(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
service_names	ess34
sessions	9040
sga_target	42949672960
spfile	/essorasys34/oradata/ess34/spfileess34.ora
standby_file_management	auto
thread	1
undo_tablespace	UNDOTBS1

Buffer access - local cache %:	99.99
Buffer access - remote cache %:	0.00
Buffer access - disk %:	0.00

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.7
Avg global cache current block receive time (ms):	0.8
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 %:	1.4
Avg global cache cr block flush time (ms):	2.3
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 %:	0.0
Avg global cache current block flush time (ms):	1.7

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

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	1,680	0.93	0.17
acks for commit broadcast(logical)	2,290	1.27	0.23
broadcast msgs on commit(actual)	1,828	1.01	0.18
broadcast msgs on commit(logical)	1,828	1.01	0.18
broadcast msgs on commit(wasted)	382	0.21	0.04
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	1	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	62,649	34.70	6.31
gcs ast xid	1	0.00	0.00
gcs blocked converts	525	0.29	0.05
gcs blocked cr converts	1,209	0.67	0.12
gcs compatible basts	65	0.04	0.01
gcs compatible cr basts (global)	52	0.03	0.01
gcs compatible cr basts (local)	62,363	34.54	6.28
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	156	0.09	0.02
gcs dbwr write request msgs	94	0.05	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	3	0.00	0.00
gcs force cr grant	2	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	1,017	0.56	0.10
gcs immediate (null) converts	7,175	3.97	0.72
gcs immediate cr (compatible) converts	10,566	5.85	1.06
gcs immediate cr (null) converts	1,408,184	780.00	141.81
gcs indirect ast	21,727	12.03	2.19
gcs indirect bidless ast	91	0.05	0.01
gcs indirect fg ast	21,636	11.98	2.18
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	66	0.04	0.01
gcs msgs process time(ms)	34,140	18.91	3.44
gcs msgs received	3,045,900	1,687.14	306.74
gcs new served by master	191	0.11	0.02
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	1	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	1	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	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	236	0.13	0.02
gcs side channel msgs logical	589	0.33	0.06
gcs stale cr	42	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)	221	0.12	0.02
ges msgs received	8,396	4.65	0.85
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	78,506	43.48	7.91
implicit batch messages sent	1,400	0.78	0.14
lmd msg send time(ms)	0	0.00	0.00
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	91	0.05	0.01
messages queue sent actual	13,276	7.35	1.34
messages queue sent logical	16,177	8.96	1.63
messages received actual	266,964	147.87	26.88
messages received logical	3,054,296	1,691.79	307.58
messages sent directly	6,390	3.54	0.64
messages sent indirectly	8,394	4.65	0.85
messages sent not implicit batched	79	0.04	0.01
messages sent pbatched	1,411,469	781.82	142.14
msgs causing lmd to send msgs	3,836	2.12	0.39
msgs causing lms(s) to send msgs	112,390	62.25	11.32
msgs received queue time (ms)	6,701	3.71	0.67
msgs received queued	3,054,296	1,691.79	307.58
msgs sent queue time (ms)	256	0.14	0.03
msgs sent queue time on ksxp (ms)	76,213	42.21	7.68
msgs sent queued	14,832	8.22	1.49
msgs sent queued on ksxp	120,879	66.96	12.17
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	124,437	68.93	12.53
process batch messages sent	108,577	60.14	10.93

Statistic	Total
CR Block Requests	1,982
CURRENT Block Requests	153
Data Block Requests	1,982
Undo Block Requests	0
TX Block Requests	110
Current Results	2,114
Private results	0
Zero Results	0
Disk Read Results	21
Fail Results	0
Fairness Down Converts	1,819
Fairness Clears	25
Free GC Elements	0
Flushes	30
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	20
Errors	0

Statistic	Total	% <1ms	% <10ms	% <10s
Pins	0	0.00	0.00	0.00
Flushes	18	16.67	83.33	0.00
Writes	212	14.62	84.91	0.47

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
2	data block	130	100.00	0.00	0.00	199	88.44	11.56	0.00
2	Others	21	100.00	0.00	0.00	16	100.00	0.00	0.00
2	undo header	21	71.43	28.57	0.00	6	100.00	0.00	0.00

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

Inst No	Block Class	All	Immed	Busy	All	Immed	Busy
		CR Avg Time (ms)			Current Avg Time (ms)
2	data block	0.86	0.86		0.77	0.70	1.36
2	others	0.78	0.78		0.54	0.54
2	undo header	0.80	0.55	1.44	0.63	0.63
2	undo block

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