WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
EPMPLN1293223757epmpln1110.2.0.5.0YESemlnpdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:661225-Mar-14 04:00:121872 20.5
End Snap:661325-Mar-14 05:00:241815 20.7
Elapsed:  60.18 (mins)  
DB Time:  1,839.63 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 140,672M 140,672MStd Block Size: 8K
Shared Pool Size: 12,304M 12,304MLog Buffer: 46,812K

Load Profile

Per SecondPer Transaction
Redo size: 113,305.38 11,197.98
Logical reads: 480,704.32 47,508.03
Block changes: 657.96 65.03
Physical reads: 4,549.60 449.64
Physical writes: 264.83 26.17
User calls: 7,376.53 729.02
Parses: 419.64 41.47
Hard parses: 0.78 0.08
Sorts: 50.08 4.95
Logons: 0.09 0.01
Executes: 3,526.58 348.53
Transactions: 10.12 

% Blocks changed per Read: 0.14Recursive Call %: 15.12
Rollback per transaction %: 29.12Rows per Sort: 2959.62

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.70Redo NoWait %: 100.00
Buffer Hit %: 99.15In-memory Sort %: 99.99
Library Hit %: 99.82Soft Parse %: 99.81
Execute to Parse %: 88.10Latch Hit %: 98.19
Parse CPU to Parse Elapsd %: 0.79% Non-Parse CPU: 98.84

Shared Pool Statistics

BeginEnd
Memory Usage %: 92.07 91.32
% SQL with executions>1: 98.13 97.16
% Memory for SQL w/exec>1: 56.95 59.14

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
cursor: pin S wait on X 2,188,723 42,720 20 38.7Concurrency
CPU time  30,626  27.7 
gc buffer busy 3,754,825 8,551 2 7.7Cluster
SQL*Net message from dblink 92,480 3,151 34 2.9Network
read by other session 1,486,533 2,640 2 2.4User I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 77.09 7.62
Global Cache blocks served: 12.47 1.23
GCS/GES messages received: 2,000.72 197.73
GCS/GES messages sent: 4,240.36 419.08
DBWR Fusion writes: 0.14 0.01
Estd Interconnect traffic (KB) 1,935.44 

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

Buffer access - local cache %: 99.13
Buffer access - remote cache %: 0.02
Buffer access - disk %: 0.85

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.3
Avg global cache cr block receive time (ms): 0.5
Avg global cache current block receive time (ms): 0.6
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.1
Global cache log flushes for cr blocks served %: 0.1
Avg global cache cr block flush time (ms): 2.1
Avg global cache current block pin time (ms): 0.2
Avg global cache current block send time (ms): 0.1
Global cache log flushes for current blocks served %: 0.0
Avg global cache current block flush time (ms): 0.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.2
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: 7.81
% of indirect sent messages: 91.19
% of flow controlled messages: 1.00


Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 65,298.19 59.16
parse time elapsed 46,743.97 42.35
DB CPU 30,626.42 27.75
connection management call elapsed time 5,888.26 5.33
hard parse elapsed time 3,716.96 3.37
hard parse (sharing criteria) elapsed time 1,100.44 1.00
PL/SQL execution elapsed time 622.24 0.56
sequence load elapsed time 257.54 0.23
hard parse (bind mismatch) elapsed time 225.48 0.20
PL/SQL compilation elapsed time 39.13 0.04
repeated bind elapsed time 2.21 0.00
failed parse elapsed time 0.56 0.00
DB time 110,378.00  
background elapsed time 1,442.05  
background cpu time 555.39  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
Concurrency 3,507,453 62 46,001 13 41.68
CPU time     30,626   27.75
Cluster 6,363,688 0 9,050 1 8.20
User I/O 3,472,524 0 7,754 2 7.03
Network 25,762,880   3,180 0 2.88
Other 279,397 28 284 1 0.26
System I/O 126,468   80 1 0.07
Commit 25,620 0 26 1 0.02
Application 18,270 0 17 1 0.01
Configuration 48   0 1 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
cursor: pin S wait on X 2,188,723 100 42,720 20 59.90
gc buffer busy 3,754,825 0 8,551 2 102.76
SQL*Net message from dblink 92,480   3,151 34 2.53
read by other session 1,486,533 0 2,640 2 40.68
row cache lock 66,466 1 2,470 37 1.82
db file scattered read 972,849   2,462 3 26.63
db file sequential read 916,402   2,452 3 25.08
latch: row cache objects 8,049   402 50 0.22
gc cr multi block request 1,917,319   372 0 52.47
latch: shared pool 5,795   318 55 0.16
rdbms ipc reply 735 17 248 337 0.02
db file parallel read 4,665   152 33 0.13
gc cr grant 2-way 503,893   71 0 13.79
latch: cache buffers chains 1,224,197   51 0 33.50
direct path read temp 57,404   44 1 1.57
gc current block 2-way 125,204   43 0 3.43
control file sequential read 65,665   36 1 1.80
log file sync 25,620 0 26 1 0.70
library cache lock 1,290 1 16 12 0.04
enq: TX - row lock contention 54 52 15 274 0.00
db file parallel write 24,284   14 1 0.66
library cache load lock 25 16 14 557 0.00
log file parallel write 30,800   13 0 0.84
SQL*Net more data from client 54,755   12 0 1.50
SQL*Net message to client 25,328,794   12 0 693.22
DFS lock handle 8,936 0 8 1 0.24
reliable message 275 2 8 30 0.01
wait list latch free 449   8 18 0.01
log file sequential read 2,025   8 4 0.06
Log archive I/O 2,018   7 4 0.06
gc cr block 2-way 18,435   6 0 0.50
gc current grant 2-way 43,064   6 0 1.18
SQL*Net more data to client 194,240   5 0 5.32
enq: WF - contention 23 35 4 174 0.00
os thread startup 47   4 78 0.00
latch: library cache 84   3 36 0.00
library cache pin 1,524   3 2 0.04
direct path write temp 13,647   3 0 0.37
control file parallel write 1,672   2 1 0.05
SQL*Net break/reset to client 18,130   2 0 0.50
name-service call wait 38   2 43 0.00
latch free 3,916   1 0 0.11
latch: KCL gc element parent latch 19,420   1 0 0.53
ksxr poll remote instances 161,491 7 1 0 4.42
utl_file I/O 20,998   1 0 0.57
CGS wait for IPC msg 60,921 100 1 0 1.67
enq: TX - index contention 58   1 9 0.00
kksfbc child completion 11 73 0 40 0.00
gc current grant busy 528   0 0 0.01
latch: ges resource hash list 8,137   0 0 0.22
latch: session allocation 176   0 1 0.00
SQL*Net message to dblink 92,477   0 0 2.53
buffer busy waits 633   0 0 0.02
enq: PS - contention 187   0 0 0.01
PX Deq: reap credit 6,662 97 0 0 0.18
IPC send completion sync 341 96 0 0 0.01
cursor: pin S 6,426   0 0 0.18
enq: CF - contention 125   0 1 0.00
CSS initialization 7   0 9 0.00
latch: object queue header operation 124   0 0 0.00
latch: gcs resource hash 140   0 0 0.00
enq: TO - contention 132   0 0 0.00
gcs log flush sync 18 6 0 3 0.00
LGWR wait for redo copy 224 0 0 0 0.01
gc current multi block request 408   0 0 0.01
direct path read 7   0 4 0.00
CSS operation: action 25   0 1 0.00
enq: TT - contention 48   0 0 0.00
enq: TM - contention 86   0 0 0.00
enq: SQ - contention 1   0 22 0.00
log file switch completion 2   0 11 0.00
enq: MD - contention 57   0 0 0.00
latch: library cache lock 44   0 0 0.00
global enqueue expand wait 1 100 0 19 0.00
enq: HW - contention 42   0 0 0.00
enq: FB - contention 55   0 0 0.00
latch: cache buffers lru chain 65   0 0 0.00
cursor: mutex X 10,516   0 0 0.29
buffer deadlock 8 100 0 2 0.00
PX Deq Credit: send blkd 106 59 0 0 0.00
enq: JS - job run lock - synchronize 9   0 1 0.00
gc cr grant congested 5   0 2 0.00
latch: enqueue hash chains 11   0 1 0.00
SQL*Net more data from dblink 134   0 0 0.00
gc current grant congested 2   0 3 0.00
enq: TA - contention 19   0 0 0.00
direct path write 19   0 0 0.00
enq: TX - allocate ITL entry 3   0 2 0.00
enq: JS - queue lock 1   0 4 0.00
enq: WL - contention 1   0 3 0.00
gc current block congested 1   0 3 0.00
latch: messages 10   0 0 0.00
PX Deq: Signal ACK 30 23 0 0 0.00
gc cr block busy 2   0 1 0.00
enq: JQ - contention 4   0 0 0.00
latch: undo global data 8   0 0 0.00
log file single write 4   0 0 0.00
gc current block busy 1   0 1 0.00
KJC: Wait for msg sends to complete 16   0 0 0.00
enq: PI - contention 2   0 0 0.00
gc cr disk read 1   0 0 0.00
enq: AF - task serialization 1   0 0 0.00
latch: redo allocation 5   0 0 0.00
PX qref latch 1   0 0 0.00
cursor: mutex S 2   0 0 0.00
SQL*Net message from client 25,328,969   1,492,189 59 693.22
gcs remote message 2,307,350 53 56,116 24 63.15
PX Idle Wait 3,156 95 7,575 2400 0.09
Streams AQ: qmn slave idle wait 365   7,041 19291 0.01
Streams AQ: waiting for messages in the queue 1,106 99 7,039 6364 0.03
jobq slave wait 1,238 97 3,556 2873 0.03
DIAG idle wait 17,124   3,525 206 0.47
Streams AQ: qmn coordinator idle wait 326 39 3,520 10799 0.01
ges remote message 250,817 15 3,513 14 6.86
Streams AQ: waiting for time management or cleanup tasks 228 71 3,387 14856 0.01
PX Deq: Execution Msg 907 47 555 612 0.02
PX Deq: Execute Reply 488 48 1 2 0.01
PX Deq: Parse Reply 64 25 0 4 0.00
single-task message 4   0 48 0.00
PX Deq: Join ACK 76 39 0 1 0.00
class slave wait 11   0 3 0.00
PX Deq: Msg Fragment 405 38 0 0 0.01
Streams AQ: RAC qmn coordinator idle wait 331 100 0 0 0.01
PX Deq Credit: need buffer 1 100 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 243,680 29 262 1 6.67
latch: row cache objects 4,220   261 62 0.12
latch: shared pool 1,196   71 59 0.03
control file sequential read 65,041   36 1 1.78
db file parallel write 24,268   14 1 0.66
log file parallel write 30,800   13 0 0.84
log file sequential read 2,025   8 4 0.06
Log archive I/O 2,018   7 4 0.06
os thread startup 47   4 78 0.00
control file parallel write 1,672   2 1 0.05
gc cr block 2-way 383   0 0 0.01
gc current block 2-way 166   0 0 0.00
latch: library cache 4   0 11 0.00
library cache lock 5   0 7 0.00
gc current grant busy 24   0 0 0.00
latch: cache buffers chains 15   0 0 0.00
gc current multi block request 37   0 0 0.00
enq: HW - contention 10   0 0 0.00
enq: TM - contention 6   0 0 0.00
log file single write 4   0 0 0.00
gc current grant 2-way 1   0 0 0.00
buffer busy waits 1   0 0 0.00
rdbms ipc message 245,677 32 67,566 275 6.72
gcs remote message 2,307,246 53 56,115 24 63.15
Streams AQ: qmn slave idle wait 365   7,041 19291 0.01
DIAG idle wait 17,124   3,525 206 0.47
Streams AQ: qmn coordinator idle wait 326 39 3,520 10799 0.01
ges remote message 250,795 15 3,513 14 6.86
pmon timer 1,205 100 3,508 2911 0.03
Streams AQ: waiting for time management or cleanup tasks 228 71 3,387 14856 0.01
smon timer 19 100 3,286 172961 0.00
Streams AQ: RAC qmn coordinator idle wait 331 100 0 0 0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 36,262
AVG_IDLE_TIME 322,719
AVG_IOWAIT_TIME 523
AVG_SYS_TIME 5,393
AVG_USER_TIME 30,744
BUSY_TIME 2,328,425
IDLE_TIME 20,661,801
IOWAIT_TIME 41,194
SYS_TIME 352,722
USER_TIME 1,975,703
LOAD 0
OS_CPU_WAIT_TIME 2.7E+11
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 2,469,888
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 3.4E+11
NUM_CPUS 64
NUM_CPU_SOCKETS 64

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 82,889.20 17,215.00 6,136,120 538,315,482
epmpln 27,594.10 13,461.00 10,329,086 1,196,588,897
SYS$BACKGROUND 0.30 0.20 867 890,744

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 956430 2447 2303158 45128 0 0 2795867 3165
epmpln 2514960 5303 1196433 267 0 0 22968237 15
SYS$BACKGROUND 1348 4 7978 605 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
35,237 41 11,311 3.12 31.92 d9dkp2jmgfvr3 JDBC Thin Client select sa_resource.RES_ID as "...
7,027 5,040 0   6.37 3r0q2w331jup9 oracle@lnodsqy1 (TNS V1-V3) SELECT /*+ USE_HASH ("A1") USE...
5,885 9 440 13.38 5.33 0h6b2sajwb74n   select privilege#, level from ...
5,057 1,567 2 2528.56 4.58 ca4ukj0ujvz3x oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
5,051 1,573 2 2525.60 4.58 9tatc9qjgq2qu oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
3,523 74 0   3.19 4v031pzgh9ab1 DBMS_SCHEDULER call pro_tq_yxcjs_mx_auto ( )
3,118 67 268 11.63 2.82 0cb3kttntx36c DBMS_SCHEDULER INSERT INTO TMP_TQ_YXCJS_MX SE...
2,600 812 1 2599.73 2.36 crar4jfwaf7m6 oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
2,186 1,886 1 2186.43 1.98 c053y9dmm5xh1 JDBC Thin Client BEGIN PRC_O_CONSBASE(:1); END;
2,179 1,881 6 363.21 1.97 7sj50vy1ddv99 JDBC Thin Client INSERT INTO O_CONSBASE SELECT ...
2,061 1,142 1 2061.47 1.87 6mxnqk9th80qf sqlplus@emlnpdb1 (TNS V1-V3) BEGIN DBMS_STATS.GATHER_DATABA...
2,056 1,101 1 2056.21 1.86 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
1,923 742 2 961.48 1.74 gfqm840qr17qq oracle@lnods2 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...
1,915 745 2 957.35 1.73 b820g52hhvtfm oracle@lnods1 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total% Total DB Time SQL IdSQL ModuleSQL Text
5,040 7,027 0   16.46 6.37 3r0q2w331jup9 oracle@lnodsqy1 (TNS V1-V3) SELECT /*+ USE_HASH ("A1") USE...
1,886 2,186 1 1886.38 6.16 1.98 c053y9dmm5xh1 JDBC Thin Client BEGIN PRC_O_CONSBASE(:1); END;
1,881 2,179 6 313.50 6.14 1.97 7sj50vy1ddv99 JDBC Thin Client INSERT INTO O_CONSBASE SELECT ...
1,573 5,051 2 786.42 5.14 4.58 9tatc9qjgq2qu oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
1,567 5,057 2 783.55 5.12 4.58 ca4ukj0ujvz3x oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
1,142 2,061 1 1142.09 3.73 1.87 6mxnqk9th80qf sqlplus@emlnpdb1 (TNS V1-V3) BEGIN DBMS_STATS.GATHER_DATABA...
1,101 2,056 1 1100.59 3.59 1.86 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
812 2,600 1 812.28 2.65 2.36 crar4jfwaf7m6 oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
745 1,915 2 372.45 2.43 1.73 b820g52hhvtfm oracle@lnods1 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...
742 1,923 2 371.19 2.42 1.74 gfqm840qr17qq oracle@lnods2 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...
569 580 99,521 0.01 1.86 0.53 2m8db5h8zy794 JDBC Thin Client select * from (select alia.*, ...
386 448 1 386.31 1.26 0.41 605pnt2r2v42y JDBC Thin Client BEGIN PRC_O_CR_PA_BAL(:1); END...
386 448 1 385.99 1.26 0.41 92gugtwhtkb4h JDBC Thin Client INSERT INTO O_CR_PA_BAL SELECT...
310 306 74 4.19 1.01 0.28 62bv5jwtxafkz JDBC Thin Client select a.acct_no from tmp_a_pa...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
909,228,107 0   52.38 5040.16 7027.21 3r0q2w331jup9 oracle@lnodsqy1 (TNS V1-V3) SELECT /*+ USE_HASH ("A1") USE...
306,010,490 1 306,010,490.00 17.63 1886.38 2186.43 c053y9dmm5xh1 JDBC Thin Client BEGIN PRC_O_CONSBASE(:1); END;
305,423,568 6 50,903,928.00 17.60 1881.01 2179.28 7sj50vy1ddv99 JDBC Thin Client INSERT INTO O_CONSBASE SELECT ...
75,720,261 99,521 760.85 4.36 569.41 580.12 2m8db5h8zy794 JDBC Thin Client select * from (select alia.*, ...
49,545,709 2 24,772,854.50 2.85 1567.10 5057.11 ca4ukj0ujvz3x oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
49,167,744 2 24,583,872.00 2.83 1572.84 5051.20 9tatc9qjgq2qu oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
27,204,665 6,468 4,206.04 1.57 251.23 249.12 83m5qm6bras0m JDBC Thin Client SELECT * FROM (SELECT LI.*, CA...
26,711,364 2 13,355,682.00 1.54 742.38 1922.95 gfqm840qr17qq oracle@lnods2 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...
26,691,361 2 13,345,680.50 1.54 744.89 1914.70 b820g52hhvtfm oracle@lnods1 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...
24,765,598 1 24,765,598.00 1.43 812.28 2599.73 crar4jfwaf7m6 oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
24,436,497 6,389,585 3.82 1.41 278.50 307.04 aymch91s5gkqs oracle@lnodsqy1 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
23,918,633 2,653 9,015.69 1.38 189.17 246.58 ayvx78m6p3fju JDBC Thin Client SELECT * FROM (SELECT LI.*, CA...
23,572,463 74 318,546.80 1.36 256.06 314.87 0f4k35h47njhx oracle@lnods1 (TNS V1-V3) SELECT "A1"."BELONG_DEPT", "A1...
22,086,742 74 298,469.49 1.27 310.06 306.43 62bv5jwtxafkz JDBC Thin Client select a.acct_no from tmp_a_pa...
21,752,542 5,438,298 4.00 1.25 241.00 241.15 b4zcs3an3cnmn oracle@lnods1 (TNS V1-V3) SELECT "METER_ID", "INST_DATE"...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
2,630,754 2 1,315,377.00 16.01 1572.84 5051.20 9tatc9qjgq2qu oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
2,515,109 2 1,257,554.50 15.31 1567.10 5057.11 ca4ukj0ujvz3x oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
1,676,239 1 1,676,239.00 10.20 812.28 2599.73 crar4jfwaf7m6 oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
1,089,781 0   6.63 5040.16 7027.21 3r0q2w331jup9 oracle@lnodsqy1 (TNS V1-V3) SELECT /*+ USE_HASH ("A1") USE...
1,008,176 1 1,008,176.00 6.14 224.91 652.16 bg1zdrp116hrm JDBC Thin Client INSERT INTO O_BUSI_ACT SELECT ...
1,008,176 1 1,008,176.00 6.14 224.91 652.17 cj8q5srj4prnd JDBC Thin Client BEGIN PRC_O_BUSI_ACT(:1); END;
766,263 0   4.66 228.12 614.06 4rq1j4m31t2rm oracle@lnodsqy1 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...
584,574 2 292,287.00 3.56 744.89 1914.70 b820g52hhvtfm oracle@lnods1 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...
567,556 1 567,556.00 3.45 1100.59 2056.21 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
539,476 2 269,738.00 3.28 742.38 1922.95 gfqm840qr17qq oracle@lnods2 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...
500,982 1 500,982.00 3.05 1142.09 2061.47 6mxnqk9th80qf sqlplus@emlnpdb1 (TNS V1-V3) BEGIN DBMS_STATS.GATHER_DATABA...
391,486 1 391,486.00 2.38 386.31 448.28 605pnt2r2v42y JDBC Thin Client BEGIN PRC_O_CR_PA_BAL(:1); END...
391,294 1 391,294.00 2.38 385.99 447.51 92gugtwhtkb4h JDBC Thin Client INSERT INTO O_CR_PA_BAL SELECT...
383,388 1 383,388.00 2.33 103.17 369.82 csr9ggpd4zawc JDBC Thin Client BEGIN PRC_O_LLR_CMPL(:1); END;
303,753 1 303,753.00 1.85 90.74 323.94 gq29uz9g0tcb9 JDBC Thin Client INSERT INTO SA_O_LLR_CMPL SELE...
215,736 1 215,736.00 1.31 1886.38 2186.43 c053y9dmm5xh1 JDBC Thin Client BEGIN PRC_O_CONSBASE(:1); END;
213,829 6 35,638.17 1.30 1881.01 2179.28 7sj50vy1ddv99 JDBC Thin Client INSERT INTO O_CONSBASE SELECT ...
197,039 1 197,039.00 1.20 123.16 144.49 30qgskkwhqvt6 JDBC Thin Client BEGIN PRC_O_CUST_VALUE_EVAL(:1...
197,036 1 197,036.00 1.20 123.14 144.46 gvg46qmtsmdc6 JDBC Thin Client INSERT INTO O_CUST_VALUE_EVAL ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
6,389,585 4,922,914 0.77 0.00 0.00 aymch91s5gkqs oracle@lnodsqy1 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
5,438,298 5,438,006 1.00 0.00 0.00 b4zcs3an3cnmn oracle@lnods1 (TNS V1-V3) SELECT "METER_ID", "INST_DATE"...
99,622 0 0.00 0.00 0.00 g8k48mbcnrt9b JDBC Thin Client select * from (select alia.*, ...
99,521 0 0.00 0.01 0.01 2m8db5h8zy794 JDBC Thin Client select * from (select alia.*, ...
96,357 96,356 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
26,820 754,140 28.12 0.00 0.00 axajjyf55qb9p JDBC Thin Client SELECT id, ip, name, lastupdat...
24,271 24,271 1.00 0.00 0.00 a6vvt01r5w66v JDBC Thin Client select systimestamp from dual
24,167 24,167 1.00 0.00 0.00 8xfbm11gv2rv0 JDBC Thin Client select sa_dept.DEPT_ID as "DEP...
21,529 21,528 1.00 0.00 0.00 4mdhzj69qgg43 JDBC Thin Client UPDATE sys_group_server SET la...
12,057 0 0.00 0.00 0.00 7tc5u8t3mmzgf   select cachedblk, cachehit, lo...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
99,620 99,622 6.57 g8k48mbcnrt9b JDBC Thin Client select * from (select alia.*, ...
99,521 99,521 6.57 2m8db5h8zy794 JDBC Thin Client select * from (select alia.*, ...
96,358 96,357 6.36 2ym6hhaq30r73   select type#, blocks, extents,...
26,820 26,820 1.77 axajjyf55qb9p JDBC Thin Client SELECT id, ip, name, lastupdat...
24,271 24,271 1.60 a6vvt01r5w66v JDBC Thin Client select systimestamp from dual
24,167 24,167 1.59 8xfbm11gv2rv0 JDBC Thin Client select sa_dept.DEPT_ID as "DEP...
21,529 21,529 1.42 4mdhzj69qgg43 JDBC Thin Client UPDATE sys_group_server SET la...
11,310 11,311 0.75 d9dkp2jmgfvr3 JDBC Thin Client select sa_resource.RES_ID as "...
10,118 10,118 0.67 1b27y3nt6u9bw JDBC Thin Client select sa_user.USER_ID as "USE...
9,833 9,833 0.65 4jc5ucwq7a0h2 JDBC Thin Client SELECT * FROM (SELECT NV.* FRO...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,740,157 1 0.02 faww0hfwysxpk sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
2,739,973 1 0.02 5xumgxq6gcqmp DBMS_SCHEDULER create global temporary table ...
2,739,797 1 0.02 9r4j75mjryt6a sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
2,719,038 1 0.02 101qfsakr5t87 DBMS_SCHEDULER create global temporary table ...
2,718,494 1 0.02 f3v7cr8996tw6 sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
2,718,358 1 0.02 fnfvv8wmh4gfp sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
2,718,158 1 0.02 ft2b5tk5pcb8t DBMS_SCHEDULER create global temporary table ...
2,674,274 1 0.02 228m3taq5qfd8 sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
2,673,402 1 0.02 6f8zytx9xtz7a DBMS_SCHEDULER create global temporary table ...
2,673,306 1 0.02 1g7ygustztgs2 DBMS_SCHEDULER create global temporary table ...
2,429,352 1 0.02 1gfb6p1k36dj6 sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
2,100,272 1 0.02 7879mzp3tvg43 DBMS_SCHEDULER create global temporary table ...
2,100,088 1 0.02 95wxg05nskq2q sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
2,083,957 1 0.02 8t7g4rzt1gzc7 sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
2,083,893 1 0.02 77ymahwdhzt7p DBMS_SCHEDULER create global temporary table ...
1,868,406 1 0.01 8vbyw5hqumgkj DBMS_SCHEDULER create global temporary table ...
1,814,276 1 0.01 2q7quf6dfntys sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
1,813,612 1 0.01 8ty34r3uz199j DBMS_SCHEDULER create global temporary table ...
1,813,468 1 0.01 35dw88vgy2zuc sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
1,813,428 1 0.01 0rjdhcgspcc7r DBMS_SCHEDULER create global temporary table ...
1,811,236 1 0.01 982mf3h5wcs61 sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
1,810,016 1 0.01 gvwx5k6wyadar sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
1,809,976 1 0.01 1uqm3qvbus277 DBMS_SCHEDULER create global temporary table ...
1,809,736 1 0.01 7urkvbjgcy30s sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
1,809,512 1 0.01 6znnf8yzkhmyv sqlplus@emlnpdb1 (TNS V1-V3) create global temporary table ...
1,809,448 1 0.01 740nbjv41w09a DBMS_SCHEDULER create global temporary table ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
82 54 32bhha21dkv0v   select col#, intcol#, charseti...
70 490 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
41 1 cqv52axncuvzv JDBC Thin Client SELECT signature, nhash, sqlar...
35 23 g3wrkmxkxzhf2   select cols, audit$, textlengt...
32 8 c1599tjmzu1fc emagent@emlnpdb1 (TNS V1-V3) /* OracleOEM */ BEGIN :message...
31 485 2q93zsrvbdw48   select grantee#, privilege#, n...
30 50 1mjd9xp80vuqa   select node, owner, name from ...
28 440 0h6b2sajwb74n   select privilege#, level from ...
28 12,057 7tc5u8t3mmzgf   select cachedblk, cachehit, lo...
27 32 cjk1ffy5kmm5s   select obj# from oid$ where us...
26 497 1pgp558xspvaa DBMS_SCHEDULER SELECT PROPERTY FROM SYS.TAB$ ...
23 767 04xtrk7uyhknh   select obj#, type#, ctime, mti...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
2,459.64 48.64 5,057.11 1,567.10 2 ca4ukj0ujvz3x oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
2,414.99 47.81 5,051.20 1,572.84 2 9tatc9qjgq2qu oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
1,195.54 45.99 2,599.73 812.28 1 crar4jfwaf7m6 oracle@lnodsqy1 (TNS V1-V3) SELECT "A1"."INS_NAME", "A1"."...
830.06 43.17 1,922.95 742.38 2 gfqm840qr17qq oracle@lnods2 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...
818.45 42.75 1,914.70 744.89 2 b820g52hhvtfm oracle@lnods1 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...
267.77 3.81 7,027.21 5,040.16 0 3r0q2w331jup9 oracle@lnodsqy1 (TNS V1-V3) SELECT /*+ USE_HASH ("A1") USE...
234.28 11.36 2,061.47 1,142.09 1 6mxnqk9th80qf sqlplus@emlnpdb1 (TNS V1-V3) BEGIN DBMS_STATS.GATHER_DATABA...
234.23 11.39 2,056.21 1,100.59 1 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
117.98 18.09 652.16 224.91 1 bg1zdrp116hrm JDBC Thin Client INSERT INTO O_BUSI_ACT SELECT ...
117.98 18.09 652.17 224.91 1 cj8q5srj4prnd JDBC Thin Client BEGIN PRC_O_BUSI_ACT(:1); END;
99.30 16.17 614.06 228.12 0 4rq1j4m31t2rm oracle@lnodsqy1 (TNS V1-V3) SELECT SUBSTR("A3"."PS_ORG_NO"...
14.92 3.33 448.28 386.31 1 605pnt2r2v42y JDBC Thin Client BEGIN PRC_O_CR_PA_BAL(:1); END...
14.91 3.33 447.51 385.99 1 92gugtwhtkb4h JDBC Thin Client INSERT INTO O_CR_PA_BAL SELECT...
12.59 5.10 246.58 189.17 2,653 ayvx78m6p3fju JDBC Thin Client SELECT * FROM (SELECT LI.*, CA...
12.52 3.39 369.82 103.17 1 csr9ggpd4zawc JDBC Thin Client BEGIN PRC_O_LLR_CMPL(:1); END;
10.35 3.20 323.94 90.74 1 gq29uz9g0tcb9 JDBC Thin Client INSERT INTO SA_O_LLR_CMPL SELE...
3.36 0.15 2,186.43 1,886.38 1 c053y9dmm5xh1 JDBC Thin Client BEGIN PRC_O_CONSBASE(:1); END;
3.15 0.14 2,179.28 1,881.01 6 7sj50vy1ddv99 JDBC Thin Client INSERT INTO O_CONSBASE SELECT ...
3.07 0.09 3,522.51 74.49 0 4v031pzgh9ab1 DBMS_SCHEDULER call pro_tq_yxcjs_mx_auto ( )
2.70 0.09 3,117.99 67.34 268 0cb3kttntx36c DBMS_SCHEDULER INSERT INTO TMP_TQ_YXCJS_MX SE...
2.53 0.81 314.87 256.06 74 0f4k35h47njhx oracle@lnods1 (TNS V1-V3) SELECT "A1"."BELONG_DEPT", "A1...
2.51 12.83 19.54 17.74 26,820 axajjyf55qb9p JDBC Thin Client SELECT id, ip, name, lastupdat...
1.54 1.07 144.49 123.16 1 30qgskkwhqvt6 JDBC Thin Client BEGIN PRC_O_CUST_VALUE_EVAL(:1...
1.54 1.07 144.46 123.14 1 gvg46qmtsmdc6 JDBC Thin Client INSERT INTO O_CUST_VALUE_EVAL ...
0.91 0.29 307.04 278.50 6,389,585 aymch91s5gkqs oracle@lnodsqy1 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
0.84 12.36 6.79 5.09 96,357 2ym6hhaq30r73   select type#, blocks, extents,...
0.39 0.94 41.97 13.21 271 2bgqts87amgg6 JDBC Thin Client BEGIN UG_ACCR_LFEE_CALC.UP_LAT...
0.30 0.10 311.56 2.10 268 1x9b90huwf3nt DBMS_SCHEDULER INSERT INTO TMP_TQ_YXCJS_MX SE...
0.29 2.52 11.51 10.72 21,529 4mdhzj69qgg43 JDBC Thin Client UPDATE sys_group_server SET la...
0.13 0.04 306.43 310.06 74 62bv5jwtxafkz JDBC Thin Client select a.acct_no from tmp_a_pa...
0.10 2.13 4.52 1.48 4,264 1yhhj8t99mzpn JDBC Thin Client insert into A_PC_TRAN_CHK(FILE...
0.09 0.04 241.15 241.00 5,438,298 b4zcs3an3cnmn oracle@lnods1 (TNS V1-V3) SELECT "METER_ID", "INST_DATE"...
0.05 0.04 135.26 135.77 9,833 4jc5ucwq7a0h2 JDBC Thin Client SELECT * FROM (SELECT NV.* FRO...
0.04 3.47 1.21 0.49 2,944 2hm549s5cgxqb JDBC Thin Client select cons_no from c_cons whe...
0.02 0.01 249.12 251.23 6,468 83m5qm6bras0m JDBC Thin Client SELECT * FROM (SELECT LI.*, CA...
0.02 0.02 125.89 124.77 497 9fm623d6yqfc8 JDBC Thin Client DECLARE stmt VARCHAR2(31700); ...
0.02 0.00 508.32 3.94 9,767 60xbnxfw0y4xg JDBC Thin Client select lock_name from sa_task_...
0.02 3.41 0.56 0.43 7,263 05mbgav5mj9wz JDBC Thin Client SELECT ORG_NO FROM C_CONS WHER...
0.02 0.42 4.19 4.53 3,004 g8bjbfhv73d31 JDBC Thin Client SELECT NVL(SUM(NVL(RCVBL_PENAL...
0.01 2.58 0.38 0.23 767 04xtrk7uyhknh   select obj#, type#, ctime, mti...
0.01 2.02 0.44 0.45 848 gx4rhfz2g90tx JDBC Thin Client DELETE FROM QRTZ_FIRED_TRIGGER...
0.01 0.00 297.19 302.55 41 5tbw0ux7xt6gu JDBC Thin Client select app_no, emp_no, org_no,...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
05mbgav5mj9wzSELECT ORG_NO FROM C_CONS WHERE CONS_NO= :1 AND ORG_NO LIKE :2
0cb3kttntx36cINSERT INTO TMP_TQ_YXCJS_MX SELECT A.ORG_NO, A.CONS_NO, :B2 , TG_NO, TG_NAME, B.TG_ID FROM C_MP A, G_TG B, C_METER_MP_RELA C, D_METER E WHERE MP_ATTR_CODE = '01' AND STATUS_CODE IN ('01', '02', '03') AND A.TG_ID = B.TG_ID AND B.PUB_PRIV_FLAG = '01' AND C.MP_ID = A.MP_ID AND B.TG_ID = :B1 AND EXISTS (SELECT 1 FROM TMP_TQ_YXCJS@LNJCJG S WHERE KH_AZS + DX_AZS + SX_AZS - KH_CJS - DX_CJS - SX_CJS < 10 AND DATA_DATE = :B2 AND B.TG_ID = S.TG_ID) AND C.METER_ID = E.METER_ID AND E.WIRING_MODE = '1' AND NOT EXISTS (SELECT 1 FROM (SELECT A.CONS_NO N FROM C_MP A, G_TG B, C_METER_MP_RELA C, D_METER E, R_COLL_OBJ D, R_TMNL_RUN F, R_CP_MP_RELA G WHERE MP_ATTR_CODE = '01' AND C.METER_ID = D.METER_ID AND F.CP_NO = G.CP_NO AND A.MP_ID = G.MP_ID AND A.STATUS_CODE IN ('01', '02', '03') AND A.TG_ID = B.TG_ID AND B.TG_ID = :B1 AND EXISTS (SELECT 1 FROM TMP_TQ_YXCJS@LNJCJG S WHERE KH_AZS + DX_AZS + SX_AZS - KH_CJS - DX_CJS - SX_CJS < 10 AND DATA_DATE = :B2 AND B.TG_ID = S.TG_ID) AND B.PUB_PRIV_FLAG = '01' AND C.MP_ID = A.MP_ID AND C.METER_ID = E.METER_ID AND E.WIRING_MODE = '1') M WHERE M.N = A.CONS_NO)
0f4k35h47njhxSELECT "A1"."BELONG_DEPT", "A1"."BELONG_DEPT", "A1"."PR_CODE", "A1"."METER_ID", "A1"."SORT_CODE", "A1"."TYPE_CODE", "A1"."CUR_STATUS_CODE", "A1"."METER_ID", "A1"."BELONG_DEPT", "A2"."INST_DATE", "A2"."METER_ID", "A2"."ORG_NO" FROM "EPM_LN"."D_METER" "A1", "EPM_LN"."C_METER" "A2" WHERE "A2"."ORG_NO" LIKE :1||'%' AND "A1"."METER_ID"="A2"."METER_ID" AND "A1"."BELONG_DEPT"=:2 AND "A1"."CUR_STATUS_CODE"='012' AND "A1"."BELONG_DEPT" LIKE :3||'%' AND ("A1"."SORT_CODE"='10' OR ("A1"."TYPE_CODE"='26' OR "A1"."TYPE_CODE"='27' OR "A1"."TYPE_CODE"='28' OR "A1"."TYPE_CODE"='29'))
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0rjdhcgspcc7rcreate global temporary table sys.ora_temp_1_ds_2478185 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_ID", "ACCT_NO", "ACCT_ID", "AMT", "ACCOUNTANT_NO", "BOOK_TIME", "BOOK_DATE", "ACCT_YM", "ORG_NO", "CONS_NO", "RCVBL_AMT_ID", "RCVBL_YM", "AMT_TYPE", "AREA_NO", "DBCR_FLAG" from "EPM_LN"."A_RCVBL_ENTRY" sample ( .3372806246) t where 1 = 2
101qfsakr5t87create global temporary table sys.ora_temp_1_ds_2478179 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"MR_STATUS_CODE", "EXCP_TYPE_CODE", "LAST_MR_DATE", "THIS_YMD", "SRC_CODE", "RELA_APP_NO", "MR_FACTOR", "ACTUAL_MODE", "METER_DATE", "CHECK_TYPE", "PRC_CODE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "ADJUST_PQ", "ADJUST_MODE", "RECORD_ID", "CONS_MT_ID", "MODIFY_TIMES", "USAGE_TYPE_CODE", "CONTAINER_NO", "T_PRC", "REMARK", "BAR_CODE", "MR_ID", "MR_PLAN_NO", "APP_NO", "CALC_ID", "AMT_YM", "CONS_NO", "ORG_NO", "METER_ID", "MP_ID", "MR_SN", "AVG_PQ", "MR_DIGIT", "READ_TYPE_CODE", "T_FACTOR", "LAST_MR_NUM", "LAST_MR_PQ", "THIS_READ", "THIS_READ_PQ" from "EPM_LN"."ARC_R_DATA" sample ( .9047537812) t where 1 = 2
1b27y3nt6u9bwselect sa_user.USER_ID as "USER_ID", sa_user.DEPT_ID as "DEPT_ID", sa_user.USER_NAME as "USER_NAME", sa_user.PASSWORD as "PASSWORD", sa_user.REAL_NAME as "REAL_NAME", sa_user.IS_LOCK as "IS_LOCK", sa_user.IS_DELETE as "IS_DELETE", sa_user.TELEPHONE as "TELEPHONE", sa_user.PASSWORD_UPDATE_TIME as "PASSWORD_UPDATE_TIME", sa_user.LOCK_TIME as "LOCK_TIME", sa_user.ATTR1 as "ATTR1", sa_user.ATTR2 as "ATTR2", sa_user.ATTR3 as "ATTR3", sa_user.ATTR4 as "ATTR4", sa_user.MAIL as "MAIL", sa_user.GENDER as "GENDER", sa_user.USER_IP as "USER_IP", sa_user.IS_MANAGER as "IS_MANAGER", sa_user.USER_TYPE as "USER_TYPE", sa_user.HIS_PASSWORD1 as "HIS_PASSWORD1", sa_user.HIS_PASSWORD2 as "HIS_PASSWORD2", sa_user.HIS_PASSWORD3 as "HIS_PASSWORD3", sa_user.HIS_PASSWORD4 as "HIS_PASSWORD4", sa_user.HIS_PASSWORD5 as "HIS_PASSWORD5", sa_user.HIS_PASSWORD6 as "HIS_PASSWORD6", sa_user.CREATE_TIME as "CREATE_TIME" from sa_user where sa_user.USER_ID = :1
1g7ygustztgs2create global temporary table sys.ora_temp_1_ds_2478191 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RELA_APP_NO", "METER_DATE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "RECORD_ID", "CONS_MT_ID", "CONTAINER_NO", "REMARK", "BAR_CODE", "CALC_ID", "CONS_NO", "METER_ID", "MP_ID", rowid SYS_DS_ALIAS_0 from "EPM_LN"."ARC_R_DATA" sample ( 11.8768775488) t where 1 = 2
1gfb6p1k36dj6create global temporary table sys.ora_temp_1_ds_2478176 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_AMT_ID", "CALC_ID", "AMT_TYPE", "RCVBL_YM", "CONS_NO", "ORG_NO", "PAY_MODE", "T_PQ", "RCVBL_AMT", "RCVED_AMT", "STATUS_CODE", "SETTLE_FLAG", "PENALTY_BGN_DATE", "RCVBL_INPRICE_AMT", "RCVBL_PL_AMT", "RCVED_IN_PRICE_AMT", "RCVED_PL_AMT", "RCVBL_PENALTY", "RCVED_PENALTY", "RISK_LEVEL_CODE", "RELEASE_DATE", "ACCT_NO", "OWE_AMT", "MP_ID", "TARIFF_ID", "APP_NO", "DISPOSE_AMT", "DISPOSE_INPRICE", "DISPOSE_PL", "DISPOSE_PENALTY", "RENDER_MAN", "RENDER_DATE", "RECE_RPT_NO", "CARD_PRINTED", "PRC_AMT_ID", "CARRYOVER_FLAG", "INVISIBLE_FLAG" from "EPM_LN"."A_RCVBL_FLOW" sample ( .8583477602) t where 1 = 2
1mjd9xp80vuqaselect node, owner, name from syn$ where obj#=:1
1pgp558xspvaaSELECT PROPERTY FROM SYS.TAB$ WHERE OBJ# = :B1
1uqm3qvbus277create global temporary table sys.ora_temp_1_ds_2468483 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"PREPAY_DATE", "PREPAY_YM", "ACCT_NO", "NOTE_ID", "REMA_TYPE", "REMAIN", "PAY_MODE", "PART_CHG_YM", "FREEZE_AMT", "PREPAY_ID", "CHARGE_ID", "PREPAY_AMT", "CONS_NO", "ORG_NO" from "EPM_LN"."A_PREPAY_FLOW" sample ( .6392910113) t where 1 = 2
1x9b90huwf3ntINSERT INTO TMP_TQ_YXCJS_MX SELECT A.ORG_NO, A.CONS_NO, :B2 , TG_NO, TG_NAME, B.TG_ID FROM C_MP A, G_TG B, C_METER_MP_RELA C WHERE MP_ATTR_CODE = '02' AND A.MP_ID = C.MP_ID AND A.STATUS_CODE IN ('01', '02', '03') AND A.TG_ID = B.TG_ID AND B.TG_ID = :B1 AND EXISTS (SELECT 1 FROM TMP_TQ_YXCJS@LNJCJG S WHERE KH_AZS + DX_AZS + SX_AZS - KH_CJS - DX_CJS - SX_CJS < 10 AND DATA_DATE = :B2 AND B.TG_ID = S.TG_ID) AND B.PUB_PRIV_FLAG = '01' AND NOT EXISTS (SELECT 1 FROM (SELECT A.CONS_NO N FROM C_MP A, G_TG B, C_METER_MP_RELA C, R_COLL_OBJ D, R_TMNL_RUN E, R_CP_MP_RELA F WHERE MP_ATTR_CODE = '02' AND A.MP_ID = C.MP_ID AND C.METER_ID = D.METER_ID AND A.MP_ID = F.MP_ID AND E.CP_NO = F.CP_NO AND B.TG_ID = :B1 AND EXISTS (SELECT 1 FROM TMP_TQ_YXCJS@LNJCJG S WHERE KH_AZS + DX_AZS + SX_AZS - KH_CJS - DX_CJS - SX_CJS < 10 AND DATA_DATE = :B2 AND B.TG_ID = S.TG_ID) AND A.STATUS_CODE IN ('01', '02', '03') AND A.TG_ID = B.TG_ID AND B.PUB_PRIV_FLAG = '01') M WHERE M.N = A.CONS_NO)
1yhhj8t99mzpninsert into A_PC_TRAN_CHK(FILE_ID, EXCHG_ID, PL_ORG_CODE, EXCHG_CHANNEL, CONS_NO, EXCHG_YM, EXCHG_AMT, LAST_CHG, THIS_CHG, EXCHG_DATE, ACCT_DATE, RCVBL_NO_DTL_ID, EXCHG_TYPE_CODE, ORG_NO, SERIAL_NO, CANCEL_FLAG, AGENCIES_NO, COUNTER_NO, BANK_NO, ORGN_CONS_NO, RETURN_CODE, REMARK) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
228m3taq5qfd8create global temporary table sys.ora_temp_1_ds_2478192 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RELA_APP_NO", "METER_DATE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "RECORD_ID", "CONS_MT_ID", "CONTAINER_NO", "REMARK", "BAR_CODE", "CALC_ID", "CONS_NO", "METER_ID", "MP_ID", rowid SYS_DS_ALIAS_0 from "EPM_LN"."ARC_R_DATA" sample ( 11.6324341318) t where 1 = 2
2bgqts87amgg6BEGIN UG_ACCR_LFEE_CALC.UP_LATEFEE_CALC_BY_CONSNO(:1, :2); END;
2hm549s5cgxqbselect cons_no from c_cons where (( card_no=:1 ) or ( orgn_cons_no = :2)) and org_no like :3 and status_code<>'9'
2m8db5h8zy794select * from (select alia.*, rownum as rnum from (SELECT instance_id, state_change_time, prolong_time, overtime_count, when_overtime, current_state, objecttype, create_time, time_out_time, schedule_type, timer_type, warning_interval, group_id, version FROM rt_overtime_deal WHERE time_out_time IS NOT NULL AND time_out_time<=:1 AND current_state=1 AND (overtime_count<1 OR overtime_count is NULL) AND handlestate=0 AND version=0) alia where rownum <2) where rnum>=1
2q7quf6dfntyscreate global temporary table sys.ora_temp_1_ds_2468487 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_ID", "ACCT_NO", "ACCT_ID", "AMT", "ACCOUNTANT_NO", "BOOK_TIME", "BOOK_DATE", "ACCT_YM", "ORG_NO", "CONS_NO", "RCVBL_AMT_ID", "RCVBL_YM", "AMT_TYPE", "AREA_NO", "DBCR_FLAG" from "EPM_LN"."A_RCVBL_ENTRY" sample ( .4566128314) t where 1 = 2
2q93zsrvbdw48select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
30qgskkwhqvt6BEGIN PRC_O_CUST_VALUE_EVAL(:1); END;
32bhha21dkv0vselect col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc
35dw88vgy2zuccreate global temporary table sys.ora_temp_1_ds_2478186 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_ID", "ACCT_NO", "ACCT_ID", "AMT", "ACCOUNTANT_NO", "BOOK_TIME", "BOOK_DATE", "ACCT_YM", "ORG_NO", "CONS_NO", "RCVBL_AMT_ID", "RCVBL_YM", "AMT_TYPE", "AREA_NO", "DBCR_FLAG" from "EPM_LN"."A_RCVBL_ENTRY" sample ( .2204509792) t where 1 = 2
3r0q2w331jup9SELECT /*+ USE_HASH ("A1") USE_HASH ("A2") */ "A1"."INS_NAME", "A1"."END_TIME", "A1"."APP_NO", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."APP_MODE", "A2"."PS_ORG_NO", "A2"."PERMENANT_REDUCE_FLAG", "A2"."ELEC_TYPE_CODE", "A2"."APP_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A2"."APP_NO"="A1"."APP_NO" AND "A1"."END_TIME"<:2 AND "A1"."END_TIME">=:3 AND "A1"."STATUS_CODE"='02'
4jc5ucwq7a0h2SELECT * FROM (SELECT NV.* FROM VIEW_WORKITEM_NFLOW NV WHERE NV.USER_ENTITY_ID = :1 UNION ALL SELECT NV.* FROM VIEW_WORKITEM_NFLOW NV, SA_BROLE_USER BU WHERE NV.USER_ENTITY_ID = BU.ROLE_ID AND BU.USER_ID = :2) T WHERE T.WT_WORKTASK_STATUS = '01' AND (T.WT_DEPT_ID IS NULL OR T.WT_DEPT_ID = '' OR T.WT_DEPT_ID = :3)
4mdhzj69qgg43UPDATE sys_group_server SET lastupdate=:1 where id=:2
4rq1j4m31t2rmSELECT SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A3"."APP_NO", SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A2"."CONS_NO", :1, "A2"."CONS_NO", "A2"."CONS_NAME", "A3"."PS_ORG_NO", "A2"."ELEC_ADDR", "A3"."VOLT_CODE", "A2"."TRADE_CODE", NVL("A3"."HEC_INDUSTRY_CODE", '000'), "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ID", "A2"."CONTRACT_CAP", "A1"."INS_NAME" FROM "ARC_S_APP" "A3", "ARC_S_BATCH_CUST_APP" "A2", "P_PROC_INSTANCE" "A1" WHERE "A3"."APP_ID"="A2"."APP_ID" AND "A3"."APP_NO"="A1"."APP_NO" AND "A1"."BGN_TIME">=:2 AND "A1"."BGN_TIME"<:3 AND ("A1"."INS_NAME"='103' OR "A1"."INS_NAME"='112' OR "A1"."INS_NAME"='217') AND "A3"."PS_ORG_NO" LIKE :4
4v031pzgh9ab1call pro_tq_yxcjs_mx_auto ( )
5tbw0ux7xt6guselect app_no, emp_no, org_no, reply_interval, reply_time from ( select a.app_no, a.emp_no, a.org_no, (select b.value from s_wkst_ext_attr b where b.app_no = a.app_no and b.ATTR_INFO_ID = 30000000001600) reply_interval, (select b.value from s_wkst_ext_attr b where b.app_no = a.app_no and b.ATTR_INFO_ID = 30000000000800) reply_time, (select b.value from s_wkst_ext_attr b where b.app_no = a.app_no and b.ATTR_INFO_ID = 30000000001200) continue_flag from s_95598_wkst a where a.busi_type_code = '003' and a.handle_status_code = '05' )where continue_flag = '1'
5xumgxq6gcqmp create global temporary table sys.ora_temp_1_ds_2468490 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"GC_TYPE_CODE", "ABSO_MODE", "USER_TYPE_CODE", "DIVISION_CODE", "RUN_CAP", "CONTRACT_CAP", "POWEROFF_CODE", "ARC_CALC_ID", "HANLE_REMARK", "REMIND_SECT_NO", "AMT_CALC_ID", "CALC_PERIOD", "CALC_ID", "APP_CODE", "YM", "CONS_ID", "ORG_NO", "VERI_RSLT", "VERI_REMARK", "CALC_DATE", "SEND_DATE", "CONS_NO", "CONS_NAME", "CONS_SORT_CODE", "ELEC_ADDR", "TRADE_TYPE_CODE", "ELEC_TYPE_CODE", "VOLT_CODE", "HEC_TRADE_CODE", "CREATE_DATE", "POWERON_DATE", "CANCEL_DATE", "STATUS_CODE", "BUSI_REGION_NO", "TRANSFER_FLAG", "MR_SECT_NO", "GP_CODE", "RENDER_STATUS", "CALC_TYPE", "CALC_TIMES", "PAY_MODE", "USE_MONTH", "DATA_SRC", "ORGN_CONS_NO", "APP_NO_REF", "SHIFT_NO" from "EPM_LN"."ARC_E_CONS_SNAP" sample ( 1.0248965618) t where 1 = 2
605pnt2r2v42yBEGIN PRC_O_CR_PA_BAL(:1); END;
60xbnxfw0y4xgselect lock_name from sa_task_locks where lock_name in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20) for update nowait
62bv5jwtxafkzselect a.acct_no from tmp_a_pay_flow a where not exists (select 1 from a_rcvbl_flow b where b.cons_no = a.cons_no and b.settle_flag in ('01', '02') and b.STATUS_CODE = '01')
6f8zytx9xtz7acreate global temporary table sys.ora_temp_1_ds_2478180 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RELA_APP_NO", "METER_DATE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "RECORD_ID", "CONS_MT_ID", "CONTAINER_NO", "REMARK", "BAR_CODE", "CALC_ID", "CONS_NO", "METER_ID", "MP_ID", rowid SYS_DS_ALIAS_0 from "EPM_LN"."ARC_R_DATA" sample ( 25.0000000000) t where 1 = 2
6mxnqk9th80qfBEGIN DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC; END;
6znnf8yzkhmyvcreate global temporary table sys.ora_temp_1_ds_2468482 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"PREPAY_DATE", "PREPAY_YM", "ACCT_NO", "NOTE_ID", "REMA_TYPE", "REMAIN", "PAY_MODE", "PART_CHG_YM", "FREEZE_AMT", "PREPAY_ID", "CHARGE_ID", "PREPAY_AMT", "CONS_NO", "ORG_NO" from "EPM_LN"."A_PREPAY_FLOW" sample ( .5945832300) t where 1 = 2
740nbjv41w09acreate global temporary table sys.ora_temp_1_ds_2468464 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"PREPAY_DATE", "PREPAY_YM", "ACCT_NO", "NOTE_ID", "REMA_TYPE", "REMAIN", "PAY_MODE", "PART_CHG_YM", "FREEZE_AMT", "PREPAY_ID", "CHARGE_ID", "PREPAY_AMT", "CONS_NO", "ORG_NO" from "EPM_LN"."A_PREPAY_FLOW" sample ( .5982089667) t where 1 = 2
77ymahwdhzt7pcreate global temporary table sys.ora_temp_1_ds_2468434 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_AMT_ID", "CHARGE_ID", "CONS_NO", "ACCT_NO", "NOTE_ID", "MP_ID", rowid SYS_DS_ALIAS_0 from "EPM_LN"."A_RCVED_FLOW" sample ( 9.0744275307) t where 1 = 2
7879mzp3tvg43create global temporary table sys.ora_temp_1_ds_2468431 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVED_AMT_ID", "RCVBL_AMT_ID", "CHARGE_ID", "ORG_NO", "CONS_NO", "RCVED_YM", "RCVED_DATE", "THIS_RCVED_AMT", "THIS_IN_PRICE_AMT", "THIS_PL_AMT", "THIS_PENALTY", "ACCT_NO", "OWE_AMT", "NOTE_ID", "TARIFF_ID", "MP_ID", "RCVBL_YM", "PART_CHG_YM" from "EPM_LN"."A_RCVED_FLOW" sample ( .9074427531) t where 1 = 2
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7sj50vy1ddv99INSERT INTO O_CONSBASE SELECT SEQ_O_CONSBASE.NEXTVAL, A.ORGNO, A.ORGNAME, A.VOLTCODE, A.TRADECODE, A.CONSSORTCODE, A.ELECTCODE, A.CONSNUM, A.RUNCAP, A.CONCAP FROM (SELECT CONS.ORG_NO ORGNO, LINE_CONS.LINEID ORGNAME, CONS.VOLT_CODE VOLTCODE, CONS.TRADE_CODE TRADECODE, CONS.CONS_SORT_CODE CONSSORTCODE, CONS.ELEC_TYPE_CODE ELECTCODE, COUNT(CONS.CONS_ID) CONSNUM, SUM(CONS.RUN_CAP) RUNCAP, SUM(CONS.CONTRACT_CAP) CONCAP FROM C_CONS CONS, (SELECT DISTINCT B.ORG_NO ORGNO, D.LINE_ID LINEID, B.CONS_ID CONSID FROM C_MP B, G_LINE D WHERE B.LINE_ID = D.LINE_ID AND B.ORG_NO = D.ORG_NO AND B.ORG_NO LIKE :B1 ||'%') LINE_CONS, SA_ORG ORG WHERE CONS.CONS_ID = LINE_CONS.CONSID AND CONS.ORG_NO = LINE_CONS.ORGNO AND CONS.ORG_NO = ORG.ORG_NO AND CONS.ORG_NO LIKE :B1 ||'%' GROUP BY CONS.ORG_NO, LINE_CONS.LINEID, CONS.VOLT_CODE, CONS.TRADE_CODE, CONS.CONS_SORT_CODE, CONS.ELEC_TYPE_CODE) A
7tc5u8t3mmzgfselect cachedblk, cachehit, logicalread from tab_stats$ where obj#=:1
7urkvbjgcy30screate global temporary table sys.ora_temp_1_ds_2468444 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"PREPAY_DATE", "PREPAY_YM", "ACCT_NO", "NOTE_ID", "REMA_TYPE", "REMAIN", "PAY_MODE", "PART_CHG_YM", "FREEZE_AMT", "PREPAY_ID", "CHARGE_ID", "PREPAY_AMT", "CONS_NO", "ORG_NO" from "EPM_LN"."A_PREPAY_FLOW" sample ( .6935411072) t where 1 = 2
83m5qm6bras0m SELECT * FROM (SELECT LI.*, CASE WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1 WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN CASE WHEN E.SUSPEND_FLAG = 0 THEN CASE WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1 ELSE 0 END WHEN E.SUSPEND_FLAG = 1 THEN CASE WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1 ELSE 0 END ELSE 0 END ELSE 0 END OVERDUED, CASE WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME ELSE LI.TARGET_TIME_NE END TARGET_TIME, FTM.WORKFORM_TYPE_KIND FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/ WF.PROC_INSTANCE_ID, WF.ACTIVITY_INS_ID, WF.WORKITEM_INS_ID, WF.NAME, WF.CURRENT_ STATE, WF.COMPLETE_TIME, WF.CREATE_TIME, WF.LIMIT_TIME, WF.APP_URL, WF.USER_NAME, WF.USER_ID, WF.USER_ENTITY_TYPE, WF.USER_ENTITY_NAME, WF.USER_ENTITY_ID, WF.PARTICIPANT_TYPE, WF.SEND_TYPE, WF.OVERDUED AS OVERDUED_NE, WF.EXT_PROP, WF.FLOW_DIRECTION, WF.BUSINESSKEY, WF.DEPART_ID, F.INSTANCE_ID AS WI_INSTANCE_ID, F.INSTANCE_NAME AS WI_INSTANCE_NAME, F.WORKFORM_TYPE AS WI_WORKFORM_TYPE, F.BUILDER AS WI_BUILDER, F.START_TIME AS WI_CREATE_TIME, F.INSTANCE_STATUS AS WI_INSTANCE_STATUS, F.BUSINESS AS WI_BUSINESS, F.KEYDATA_ID AS WI_KEYDATA_ID, F.IS_FLOW AS WI_IS_FLOW, F.ATTR1 AS WI_ATTR1, F.DEPT_ID AS WI_DEPT_ID, '' AS WT_DEPT_ID, WF.CURRENT_STATE AS WT_WORKTASK_STATUS, NULL AS WT_TARGET_TIME, '' AS WT_LINK_URL, '' AS WT_LINK_PARAM, '' AS WT_IS_BATCH, U.REAL_NAME AS WI_BUILDER_REALNAME, NULL AS HOWLONG_WILL_OVERDUE, NULL AS HOWLONG_OVERDUED, '' AS ACTIVITY_TMP_ID, O.TIME_OUT_TIME AS TARGET_TIME_NE, B.APPROVAL_STATUS AS BE_APPROVAL_STATUS, ORG.ORG_NO, ORG.ORG_NAME, '' AS VIEW_FLAGS FROM SA_WORKFORM_INST F, (SELECT W.* FROM RT_WORKITEMINST W WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = :1 AND W.PARTICIPANT_TYPE = 0 UNION ALL SELECT W.* FROM RT_WORKITEMINST W, SA_BROLE_USER R WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = R.ROLE_ID AND R.USER_ID = :2 AND W.PARTICIPANT_TYPE = 1) WF, SA_USER U, (SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O, SA_WF_BUSINESS_EXT B, SA_DEPT D, SA_ORG ORG WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+) AND F.BUILDER = U.USER_ID(+) AND U.DEPT_ID = D.DEPT_ID(+) AND D. ORG_NO = ORG.ORG_NO(+) AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+) AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :6))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:7 LIKE (F.DEPT_ID || '%')) OR (:8 = F.DEPT_ID) OR (:9 = F.DEPT_ID) OR (F.DEPT_ID LIKE :10)))))) UNION ALL SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/ WF.PROC_INSTANCE_ID, WF.ACTIVITY_INS_ID, WF.WORKITEM_INS_ID, WF.NAME, WF.CURRENT_STATE, WF.COMPLETE_TIME, WF.CREATE_TIME, WF.LIMIT_TIME, WF.APP_URL, WF.USER_NAME, WF.USER_ID, WF.USER_ENTITY_TYPE, WF.USER_ENTITY_NAME, WF.USER_ENTITY_ID, WF.PARTICIPANT_TYPE, WF.SEND_TYPE, WF.OVERDUED AS OVERDUED_NE, WF.EXT_PROP, WF.FLOW_DIRECTION, WF.BUSINESSKEY, WF.DEPART_ID, F.INSTANCE_ID AS WI_INSTANCE_ID, F.INSTANCE_NAME AS WI_INSTANCE_NAME, F.WORKFORM_TYPE AS WI_WORKFORM_TYPE, F.BUILDER AS WI_BUILDER, F.START_TIME AS WI_CREATE_TIME, F.INSTANCE_STATUS AS WI_INSTANCE_STATUS, F.BUSINESS AS WI_BUSINESS, F.KEYDATA_ID AS WI_KEYDATA_ID, F.IS_FLOW AS WI_IS_FLOW, F.ATTR1 AS WI_ATTR1, F.DEPT_ID AS WI_DEPT_ID, '' AS WT_DEPT_ID, WF.CURRENT_STATE AS WT_WORKTASK_STATUS, NULL AS WT_TARGET_TIME, '' AS WT_LINK_URL, '' AS WT_LINK_PARAM, '' AS WT_IS_BATCH, U.REAL_NAME AS WI_BUILDER_REALNAME, NULL AS HOWLONG_WILL_OVERDUE, NULL AS HOWLONG_OVERDUED, '' AS ACTIVITY_TMP_ID, O.TIME_OUT_TIME AS TARGET_TIME_NE, B.APPROVAL_STATUS AS BE_APPROVAL_STATUS, ORG.ORG_NO, ORG.ORG_NAME, '' AS VIEW_FLAGS FROM SA_WORKFORM_INST F, (SELECT W.* FROM RT_WORKITEMINST W WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = :11 AND W.PARTICIPANT_TYPE = 0 UNION ALL SELECT W.* FROM RT_WORKITEMINST W, SA_BROLE_USER R WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = R.ROLE_ID AND R.USER_ID = :12 AND W.PARTICIPANT_TYPE = 1) WF, SA_USER U, RT_PROCESSINSTANCE P, (SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O, SA_WF_BUSINESS_EXT B, SA_DEPT D, SA_ORG ORG WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID AND P.PARENT_PROCINC_ID IS NOT NULL AND F.PROCINST_ID = P.PARENT_PROCINC_ID AND F.BUILDER = U.USER_ID(+) AND U.DEPT_ID = D.DEPT_ID(+) AND D.ORG_NO = ORG.ORG_NO(+) AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+) AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+) AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:13 LIKE (WF.DEPART_ID || '%')) OR (:14 = WF.DEPART_ID) OR (:15 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :16))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:17 LIKE (F.DEPT_ID || '%')) OR (:18 = F.DEPT_ID) OR (:19 = F.DEPT_ID) OR (F.DEPT_ID LIKE :20)))))) AND NOT EXISTS (SELECT 1 FROM SA_WORKFORM_INST RF WHERE WF.PROC_INSTANC E_ID = RF.PROCINST_ID)) LI, SA_WF_WORKFORM_TYPE_MAP FTM, (SELECT ACT_INST_ID, SUSPEND_FLAG, MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME, MIN(SUSPEND_TIME) AS SUSPEND_TIME FROM (SELECT A.ACT_INST_ID, B.* FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID AND A.PROC_INST_ID = B.PROC_INST_ID AND B.COMPLETE_FLAG = 0) GROUP BY ACT_INST_ID, SUSPEND_FLAG) E WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+) AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T WHERE NOT EXISTS (SELECT 1 FROM SA_WF_WORKITEM_EXCLUDED_USER US WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID AND US.USER_ID = :21)
8t7g4rzt1gzc7create global temporary table sys.ora_temp_1_ds_2468430 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_AMT_ID", "CHARGE_ID", "CONS_NO", "ACCT_NO", "NOTE_ID", "MP_ID", rowid SYS_DS_ALIAS_0 from "EPM_LN"."A_RCVED_FLOW" sample ( 9.1179098594) t where 1 = 2
8ty34r3uz199jcreate global temporary table sys.ora_temp_1_ds_2468486 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_ID", "ACCT_NO", "ACCT_ID", "AMT", "ACCOUNTANT_NO", "BOOK_TIME", "BOOK_DATE", "ACCT_YM", "ORG_NO", "CONS_NO", "RCVBL_AMT_ID", "RCVBL_YM", "AMT_TYPE", "AREA_NO", "DBCR_FLAG" from "EPM_LN"."A_RCVBL_ENTRY" sample ( .5428394804) t where 1 = 2
8vbyw5hqumgkj create global temporary table sys.ora_temp_1_ds_2468453 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"USAGE_TYPE_CODE", "EQUIP_GROUP_NO", "TL_SHARE_FLAG", "LL_SHARE_FLAG", "TL_BILL_FLAG", "LL_BILL_FLAG", "LL_CALC_CODE", "AP_LL_VALUE", "RP_LL_VALUE", "MP_CAP", "LL_SHARE_VALUE", "TL_SHARE_VALUE", "PT_AP_LOSS", "PT_RP_LOSS", "MP_AP_T_PQ", "T_RPQ", "DATA_SRC", "APP_NO_REF", "CHG_DATE", "CALC_TYPE", "CALC_TIMES", "TACTIC_ID", "ELEC_KIND_CODE", "MP_NO", "MP_NAME", "RELA_APP_NO", "MP_ATTR_CODE", "MR_SHARE", "LAST_ACTUAL_DATE", "ACTUAL_DATE", "MP_PARA_SNAP_ID", "PRC_TACTIC_SNAP_ID", "MP_ID", "CALC_ID", "PRC_ID", "YM", "ORG_NO", "MEAS_MODE", "SP_ID", "PQ_CALC_MODE", "MP_LEVEL_NUM", "FQR_VALUE", "FR_DEDUCT_FLAG", "DEDUCT_ORDER", "LINE_ID", "TG_ID" from "EPM_LN"."ARC_E_MP_PARA_SNAP" sample ( 1.0410764552) t where 1 = 2
8xfbm11gv2rv0select sa_dept.DEPT_ID as "DEPT_ID", sa_dept.DEPT_NAME as "DEPT_NAME", sa_dept.PARENT_DEPT_ID as "PARENT_DEPT_ID", sa_dept.IS_DELETE as "IS_DELETE", sa_dept.IS_DATA_DEPT as "IS_DATA_DEPT", sa_dept.DEPT_TREE as "DEPT_TREE", sa_dept.DEPT_TYPE as "DEPT_TYPE", sa_dept.DEPT_SHORTNAME as "DEPT_SHORTNAME", sa_dept.ORDER_ID as "ORDER_ID", sa_dept.ATTR1 as "ATTR1", sa_dept.ATTR2 as "ATTR2", sa_dept.ATTR3 as "ATTR3", sa_dept.ATTR4 as "ATTR4", sa_dept.IS_ORGNIZATION as "IS_ORGNIZATION", sa_dept.IS_BILL as "IS_BILL", sa_dept.IS_DIRECT as "IS_DIRECT", sa_dept.IS_ACCOUNT as "IS_ACCOUNT", sa_dept.DBPAR_NO as "DBPAR_NO", sa_dept.ORG_NO as "ORG_NO" from sa_dept where sa_dept.DEPT_ID=:1
92gugtwhtkb4hINSERT INTO O_CR_PA_BAL SELECT :B1 , NVL(A.ORG_NO, '99999'), NVL(D.EMP_NO, '999999'), SUM(CASE WHEN A.RCVBL_YM = :B1 THEN NVL(A.RCVBL_AMT, 0) ELSE 0 END) AS RCVBL_AMT, SUM(CASE WHEN A.RCVBL_YM = :B1 THEN NVL(A.RCVED_AMT, 0) ELSE 0 END) AS RCVED_AMT, SUM(CASE WHEN A.RCVBL_YM >= SUBSTR(:B1 , 1, 4) || '01' AND A.RCVBL_YM <= :B1 THEN NVL(A.RCVBL_AMT, 0) ELSE 0 END) AS ACCU_RCVBL_AMT, SUM(CASE WHEN A.RCVBL_YM >= SUBSTR(:B1 , 1, 4) || '01' AND A.RCVBL_YM <= :B1 THEN NVL(A.RCVED_AMT, 0) ELSE 0 END) AS ACCU_RCVED_AMT FROM A_RCVBL_FLOW A, A_CR_SECT D, A_CR_RELA F WHERE A.CONS_NO = F.CONS_NO(+) AND F.REMIND_SECT_NO = D.REMIND_SECT_NO(+) AND A.RCVBL_YM >= SUBSTR(:B1 , 1, 4) || '01' AND A.RCVBL_YM <= :B1 AND A.AMT_TYPE <> '04' GROUP BY NVL(A.ORG_NO, '99999'), NVL(D.EMP_NO, '999999')
95wxg05nskq2qcreate global temporary table sys.ora_temp_1_ds_2468450 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVED_AMT_ID", "RCVBL_AMT_ID", "CHARGE_ID", "ORG_NO", "CONS_NO", "RCVED_YM", "RCVED_DATE", "THIS_RCVED_AMT", "THIS_IN_PRICE_AMT", "THIS_PL_AMT", "THIS_PENALTY", "ACCT_NO", "OWE_AMT", "NOTE_ID", "TARIFF_ID", "MP_ID", "RCVBL_YM", "PART_CHG_YM" from "EPM_LN"."A_RCVED_FLOW" sample ( .7266833858) t where 1 = 2
982mf3h5wcs61create global temporary table sys.ora_temp_1_ds_2468473 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_ID", "ACCT_NO", "ACCT_ID", "AMT", "ACCOUNTANT_NO", "BOOK_TIME", "BOOK_DATE", "ACCT_YM", "ORG_NO", "CONS_NO", "RCVBL_AMT_ID", "RCVBL_YM", "AMT_TYPE", "AREA_NO", "DBCR_FLAG" from "EPM_LN"."A_RCVBL_ENTRY" sample ( .5494360643) t where 1 = 2
9fm623d6yqfc8 DECLARE stmt VARCHAR2(31700); currSeq NUMBER; currUserId NUMBER; errorMessage VARCHAR2(32767); objstatus VARCHAR2(100); errorVal VARCHAR2(10); -- purpose of these is because ora_dict* is oracle implicit function and is not l-value (can't be modified) -- we want to modify these because object being changed may not be the one we're interested in (for example -- changing unique index affects table, and DDL on materialized view really affects the 'table' of it...) -- so we have our own name, owner, type ('real' ones) real_ora_dict_obj_name VARCHAR2(4000); real_ora_dict_obj_owner VARCHAR2(100); real_ora_dict_obj_type VARCHAR2(40); otype VARCHAR2(100); disallowDDL NUMBER; indexUnique VARCHAR2(40); moduleNameInfo VARCHAR2(400); oldModuleNameInfo VARCHAR2(400); oldActionInfo VARCHAR2(400); binObject NUMBER; dbRole VARCHAR2(40); dbOpenMode VARCHAR2(40); -- sequence information seqCache NUMBER; seqIncrementBy NUMBER; pieceStmt VARCHAR2(31700); outMessage VARCHAR2(32767); toIgnore VARCHAR2(40); journalId NUMBER; journalIndexOwner VARCHAR2(100); journalType VARCHAR2(40); objectTemporary varchar2(40); objectGenerated varchar2(40); objectSecondary varchar2(40); objectType varchar2(40); userCancelSimulate EXCEPTION; userCancelNestedSimulate EXCEPTION; PRAGMA EXCEPTION_INIT (userCancelSimulate, -1013); PRAGMA EXCEPTION_INIT (userCancelNestedSimulate, -1017); isTypeTable varchar2(40); ntype NUMBER; BEGIN -- IMPORTANT: this check must happen BEFORE ANY PROCESSING -- perfor m check for role of this database -- if database is not PRIMARY/LOGICAL STANDBY, and if it's not READ WRITE -- then this trigger cannot (and should not) operate -- In case of not wanting trigger on LOGICAL STANDBY (or with READ WRITE), -- ddl_disable script can be used on standby to disable the trigger BEGIN IF "GGS".DDLReplication.dbQueried IS NULL THEN SELECT database_role, open_mode INTO dbRole, dbOpenMode FROM v$database; "GGS".DDLReplication.dbQueried := TRUE; END IF; IF NOT ( (dbRole = 'PRIMARY' OR dbRole = 'LOGICAL STANDBY') AND dbOpenMode = 'READ WRITE' ) THEN -- do not write any trace even though it should work as this is standby "GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1); RETURN; -- do not use trigger if not read/write and primary/logical_standby END IF; EXCEPTION WHEN OTHERS THEN -- this should never happen "GGS" .trace_put_line ('DDL', 'Error in obtaining dbrole, open mode, error [' || SQLERRM || ']'); raise_application_error (-20782, "GGS" .DDLReplication.triggerErrorMessage || ':' || SQLERRM); END; -- END OF IMPORTANT CHECK -- the following MUST happen after checking for role of the database -- but BEFORE anything else. Here we check if DDL is recyclebin. Recyclebin -- DDL can happen as 'interrupting' original DDL and shares the same -- memory, thus entirely messing up RDBMS trigger processing and potentially -- causing db to hang. -- set tracing from setup table "GGS" .DDLReplication.setTracing (); -- retrieve first 4K of DDL statement. -- we only use the DDL for history table that doesn't require whole DDL text. IF "GGS" .DDLReplication.getDDLText (stmt) = 0 THEN "GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1); RETURN; END IF; IF "GGS" .DDLReplication.isRecycle(stmt) = 1 THEN IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDL', 'DDL ignored, it is recycle bin DDL, text [' || stmt || ']'); END IF; IF "GGS" .DDLReplication.sql_trace = 1 THEN dbms_session.set_sql_trace(false); END IF; -- just ignore recyclebin objects "GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1); RETURN; END IF; disallowDDL := 0; -- DDL is normally allowed toIgnore := 'NO'; -- do not ignore DDL by default -- used to delete marker entry in cancel error "GGS" .DDLReplication.currentMarkerSeq := NULL; -- support for exceptions testing IF 'FALSE' = 'TRUE' THEN SELECT VALUE INTO errorVal FROM "GGS" ."GGS_SETUP" WHERE property = ', ?!%*$#'; END IF; -- get DDL history sequence, initialize object Id SELECT "GGS" ."GGS_DDL_SEQ" .NEXTVAL INTO "GGS" .DDLReplication.currentDDLSeq FROM dual; "GGS" .DDLReplication.currentObjectId := NULL; IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDL', '************************* Start of log for DDL sequence [' || to_char ("GGS" .DDLReplication.currentDDLSeq) || '], v[ ' || "GGS" .DDLReplication.tversion || '] trace level [' || "GGS" .DDLReplication.trace_level || '], owner schema of DDL package [GGS], objtype [' || ora_dict_obj_type || '] name [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || ']'); END IF; IF "GGS" .filterDDL ( stmt, ora_dict_obj_owner, ora_dict_obj_name, ora_dict_obj_type, ora_sysevent) = 'EXCLUDE' THEN IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDL', 'DDL ignored because filterDDL returned EXCLUDE'); END IF; "GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1); RETURN; END IF; -- check if we want this statement at all before going any further -- this way we avoid some large DDL that we wouldn't want anyway -- per http://ww w.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_26.shtml IF ora_dict_obj_type <> 'TABLESPACE' AND (ora_dict_obj_owner = 'SYS' OR ora_dict_obj_owner = 'SYSTEM' OR ora_dict_obj_owner = 'DBSNMP' OR ora_dict_obj_owner = 'OUTLN' OR ora_dict_obj_owner = 'MDSYS' OR ora_dict_obj_owner = 'SYSMAN' OR ora_dict_obj_owner = 'DMSYS' OR (ora_dict_obj_owner = 'PUBLIC' AND ora_dict_obj_type <> 'SYNONYM') OR ora_dict_obj_owner = 'ORDSYS' OR ora_dict_obj_owner = 'ORDPLUGINS' OR ora_dict_obj_owner = 'CTXSYS' OR ora_dict_obj_owner = 'DSSYS' OR ora_dict_obj_owner = 'PERFSTAT' OR ora_dict_obj_owner = 'WKPROXY' OR ora_dict_obj_owner = 'WKSYS' OR ora_dict_obj_owner = 'WMSYS' OR ora_dict_obj_owner = 'EXFSYS' OR ora_dict_obj_owner = 'XDB' OR ora_dict_obj_owner = 'ANONYMOUS' OR ora_dict_obj_owner = 'ODM' OR ora_dict_obj_owner = 'ODM_MTR' OR ora_dict_obj_owner = 'OLAPSYS' OR ora_dict_obj_owner = 'TRACESVR' OR ora_dict_obj_owner = 'REPADMIN' OR ora_dict_obj_owner = 'AURORA$ORB$UNAUTHENTICATED' OR ora_dict_obj_owner = 'AURORA$JIS$UTILITY$' OR ora_dict_obj_owner = 'OSE$HTTP$ADMIN') THEN IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDL', 'Object [' || ora_dict_obj_owner | | '.' || ora_dict_obj_name || '] is ignored because object name is Oracle-reserved system name'); END IF; toIgnore := 'YES'; END IF; IF upper(substr (ora_dict_obj_name, 1, 5)) = 'MLOG$' OR upper(substr (ora_dict_obj_name, 1, 5)) = 'RUPD$' THEN IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDL', 'Ignoring MLOG$ Object [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || ' as it is temporary'); END IF; toIgnore := 'YES'; END IF; IF upper(substr (ora_dict_obj_name, 1, 6)) = 'OGGQT$' OR upper(substr (ora_dict_obj_name, 1, 3)) = 'AQ$' THEN IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDL', 'Ignoring Queue related Object [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || ' as it is for internal use'); END IF; toIgnore := 'YES'; END IF; IF (upper(ora_dict_obj_name) = upper ('GGS_MARKER') OR upper(ora_dict_obj_name) = upper ('GGS_MARKER_SEQ') OR upper(ora_dict_obj_name) = upper ('GGS_DDL_TRIGGER_BEFORE') OR upper(ora_dict_obj_name) = upper ('GGS_DDL_SEQ') OR upper(ora_dict_obj_name) = upper ('GGS_DDL_HIST') OR upper(ora_dict_obj_name) = upper ('GGS_DDL_HIST_ALT') OR upper(ora_dict_obj_name) = upper ('GGS_ SETUP')) AND upper(ora_dict_obj_owner) = upper ('GGS') AND (upper(ora_sysevent) = upper ('DROP') OR upper(ora_sysevent) = upper ('RENAME')) THEN disallowDDL := 1; raise_application_error (-20782, 'Cannot DROP object used in Oracle GoldenGate replication while trigger is enabled. ' || 'Consult Oracle GoldenGate documentation and/or call Oracle GoldenGate Technical Support if you wish to do so.'); END IF; -- check if this is domain index DDL (related to it) IF ( ora_dict_obj_type = 'TABLE' OR ora_dict_obj_type = 'INDEX') AND ( (substr(ora_dict_obj_name, 1, 3) = 'DR$' AND ( substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$I' OR substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$K' OR substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$N' OR substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$R' OR substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$X' ) ) OR ( -- ignore objects that start with SYS_C, much like we ignore DR$, BIN$ etc. substr (ora_dict_obj_name, 1, 5) = 'SYS_C' ) ) THEN toIgnore := 'YES'; IF "GGS" .DDLReplication.trace_level >= 0 THE N "GGS" .trace_put_line ('DDLTRACE1', 'Object is secondary for INDEX DOMAIN creation, ignored, objtype [' || ora_dict_obj_type || '] name [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || '], error [' || to_char( SQLCODE) || ']'); END IF; END IF; -- check for and ignore Spatial temporary tables used during Spatial index creation. -- Table will look something like M2_12AB$$ IF length (ora_dict_obj_name) > 5 AND substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$$' AND instr (ora_dict_obj_name, '_') > 0 AND substr (ora_dict_obj_name, 1, 1) = 'M' THEN toIgnore := 'YES'; IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Ignoring temporary Spatial table used during Spatial index creation [' || ora_dict_obj_type || '] name [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || '], error [' || to_char( SQLCODE) || ']'); END IF; END IF; IF ora_dict_obj_type = 'TABLE' AND substr(ora_dict_obj_name, 1, 12) = 'SYS_JOURNAL_' THEN BEGIN journalId := to_number (substr(ora_dict_obj_name, 13)); SELECT owner, object_type INTO journalIndexOwner, journalType FROM sys.dba_objects WHERE object_id = journalId; IF journalIndexOwner = ora _dict_obj_owner AND journalType = 'INDEX' THEN -- if SYS_JOURNAL_xxxxx has xxxxx to be existing object of type INDEX, this is online rebuild index, which we ignore toIgnore := 'YES'; END IF; IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Object is secondary for INDEX DOMAIN creation, ignored, objtype [' || ora_dict_obj_type || '] name [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || '], error [' || to_char( SQLCODE) || ']'); END IF; EXCEPTION WHEN OTHERS THEN NULL; -- never mind, this isn't oracle journal table for rebuilding online index END; END IF; -- Ignore Oracle 9i internal 'create/drop summary' when the user creates or drops of meteriazied view that has a SUM column. IF ora_dict_obj_type = 'SUMMARY' THEN toIgnore := 'YES'; IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Object is Oracle internal create summary for materialized views, ignored, objtype [' || ora_dict_obj_type || '] name [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || '], error [' || to_char( SQLCODE) || ']'); END IF; END IF; IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [1.0], objtype [' || ora_dict_obj_type || '] name [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || ']'); END IF; IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [1], original operation = [' || stmt || '], DDL seqno = [' || to_char ("GGS" .DDLReplication.currentDDLSeq) || ']' ); END IF; IF stmt = '' OR stmt IS NULL THEN -- oracle sometimes creates a follow-up DDL without statement and session user -- this statement is related to previous one and is not a user statement, so is ignored "GGS" .trace_put_line ('DDLTRACE1', 'DDL appears empty, ignoring'); IF "GGS" .DDLReplication.sql_trace = 1 THEN dbms_session.set_sql_trace(false); END IF; "GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1); RETURN; END IF; "GGS" .DDLReplication.getVersion(); IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: proceeding with processing'); END IF; -- get user id and object id as of this DDL -- we're looking at TABLE and SEQUENCE (or related! such as CREATE UNIQUE INDEX) for object versioning -- otherwise there is none -- object id is always that of TABLE or SEQUENCE -- get user id of object owne r BEGIN IF "GGS" .DDLReplication.ddlObjUserId = -1 THEN SELECT user# INTO currUserId FROM sys.user$ WHERE name = ora_dict_obj_owner; ELSE currUserId := "GGS" .DDLReplication.ddlObjUserId ; END IF; EXCEPTION WHEN NO_DATA_FOUND THEN currUserId := - 1; WHEN OTHERS THEN currUserId := - 1; END; "GGS" .DDLReplication.currentMasterOwner := ''; "GGS" .DDLReplication.currentMasterName := ''; "GGS" .DDLReplication.currentRowid := ''; real_ora_dict_obj_name := ora_dict_obj_name; real_ora_dict_obj_owner := ora_dict_obj_owner; real_ora_dict_obj_type := ora_dict_obj_type; -- Oracle puts 0 sometimes in these particular predefined variables, at the end, so REPLACE first -- the extract history record query crashes as DDL data seems incomplete real_ora_dict_obj_name := REPLACE (real_ora_dict_obj_name, chr(0), ' '); real_ora_dict_obj_name := rtrim (real_ora_dict_obj_name, ' '); real_ora_dict_obj_owner := REPLACE (real_ora_dict_obj_owner, chr(0), ' '); real_ora_dict_obj_owner := rtrim (real_ora_dict_obj_owner, ' '); real_ora_dict_obj_type := REPLACE (real_ora_dict_obj_type, chr(0), ' '); real_ora_dict_obj_type := rtrim (real_ora_dict_obj_type, ' '); /* the purpose of following code is to obtain this information: object id of table or sequence affected if object i s not a table, then we need to get the name and owner of table affected (base table), this is currentMasterOwner/currentMasterName If operation is CREATE, then no metadata is known here (b/c it's before trigger). */ -- MATERIALIZE VIEW: we're interested in table part of it! -- note: this must happen before checking for TABLE! IF real_ora_dict_obj_type = 'MATERIALIZED VIEW' OR real_ora_dict_obj_type = 'SNAPSHOT' THEN real_ora_dict_obj_type := 'TABLE'; END IF; IF ora_sysevent <> 'CREATE' or ora_dict_obj_type <> 'TABLE' THEN "GGS" .DDLReplication.getDDLObjInfo(ora_dict_obj_type, ora_sysevent, ora_dict_obj_owner, ora_dict_obj_name ); END IF; -- Try to find base object name/owner -- If this is CREATE, there is no need to do it, since it doesn't exist yet -- In case of CREATE, extract will perform resolution of base object owner -- first try easier case when it's not CREATE IF NOT ora_sysevent = 'CREATE' THEN IF real_ora_dict_obj_type = 'INDEX' THEN BEGIN SELECT i.bo#, u.name, o.name , o.owner# INTO "GGS" .DDLReplication.ddlBaseObjNum, "GGS" .DDLReplication.currentMasterOwner, "GGS" .DDLReplication.currentMasterName, "GGS" .DDLReplication.ddlBaseObjUserId FROM sys.ind$ i, sys.obj$ o, sys.user$ u WHERE i.obj# = "GGS" .DDLReplication.ddlObjNum and o.obj# = i.bo# and u.user# = o.owner#; select o.type# into otype FROM sys.obj$ o where o.obj# = "GGS" .DDLReplication.ddlBaseObjNum; "GGS" .DDLReplication.getObjTypeName(otype, otype); real_ora_dict_obj_owner := "GGS" .DDLReplication.currentMasterOwner; real_ora_dict_obj_name := "GGS" .DDLReplication.currentMasterName; IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Non-CREATE INDEX, master object [' || real_ora_dict_obj_owner || '.' || real_ora_dict_obj_name || ']'); END IF; "GGS" .DDLReplication.currentObjectId := "GGS" .DDLReplication.ddlBaseObjNum; IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Non-CREATE INDEX, parent object id: ' || "GGS" .DDLReplication.currentObjectId); END IF; EXCEPTION WHEN NO_DATA_FOUND THEN "GGS" .DDLReplication.currentMasterOwner := ''; "GGS" .DDLReplication.currentMasterName := ''; WHEN OTHERS THEN "GGS&q uot; .DDLReplication.currentMasterOwner := ''; "GGS" .DDLReplication.currentMasterName := ''; END; END IF; IF real_ora_dict_obj_type = 'TRIGGER' THEN BEGIN SELECT tr.baseobject, u.name, o.name INTO "GGS" .DDLReplication.ddlBaseObjNum, "GGS" .DDLReplication.currentMasterOwner, "GGS" .DDLReplication.currentMasterName FROM sys.trigger$ tr, sys.obj$ o, sys.user$ u WHERE tr.obj# = "GGS" .DDLReplication.ddlObjNum and o.obj# = tr.baseobject and u.user# = o.owner#; -- do not set real_ora names b/c trigger changes don't affect GG object resolution EXCEPTION WHEN NO_DATA_FOUND THEN "GGS" .DDLReplication.currentMasterOwner := ''; "GGS" .DDLReplication.currentMasterName := ''; WHEN OTHERS THEN "GGS" .DDLReplication.currentMasterOwner := ''; "GGS" .DDLReplication.currentMasterName := ''; END; END IF; END IF; IF real_ora_dict_obj_type = 'SEQUENCE' THEN BEGIN -- get sequence CACHE/INCREMENTBY information as well as objectid -- which will be used in conjuction with ROWID to resolve sequence seqIncrement By := 0; seqCache := 0; SELECT o.obj#, s.increment$, s.cache INTO "GGS" .DDLReplication.currentObjectId, seqIncrementBy, seqCache FROM sys.obj$ o, sys.seq$ s WHERE o.obj# = "GGS" .DDLReplication.ddlObjNum AND s.obj# = o.obj#; EXCEPTION WHEN NO_DATA_FOUND THEN "GGS" .DDLReplication.currentObjectId := NULL; WHEN OTHERS THEN "GGS" .DDLReplication.currentObjectId := NULL; END; -- now find rowid of this sequence -- in SYS.SEQ$ table (which is what we get from redo log) BEGIN SELECT ROWID INTO "GGS" .DDLReplication.currentRowid FROM sys.seq$ s WHERE s.obj# = "GGS" .DDLReplication.currentObjectId; EXCEPTION WHEN NO_DATA_FOUND THEN "GGS" .DDLReplication.currentRowid := ''; WHEN OTHERS THEN "GGS" .DDLReplication.currentRowid := ''; END; END IF; IF real_ora_dict_obj_type = 'TABLE' THEN BEGIN SELECT o.obj# INTO "GGS" .DDLReplication.currentObjectId FROM sys.obj$ o, sys.tab$ t WHERE ((o.obj# = "GGS" .DDLReplication.ddlObjNum AND o.obj# = t.obj#) AND bitand(t.property, 1) IN (0, 1)); -- account for object table (value 1 f or t.property bitand) EXCEPTION WHEN NO_DATA_FOUND THEN "GGS" .DDLReplication.currentObjectId := NULL; WHEN OTHERS THEN "GGS" .DDLReplication.currentObjectId := NULL; END; END IF; -- CREATE INDEX is special b/c we don't know it's object id, but we have to figure out table's object id!!! IF real_ora_dict_obj_type = 'INDEX' AND ora_sysevent = 'CREATE' THEN -- we need base object id when indexed, it affects tables with no keys (ddlrep_2) BEGIN IF "GGS" .DDLReplication.ddlBaseObjNum <> -1 THEN "GGS" .DDLReplication.currentObjectId := "GGS" .DDLReplication.ddlBaseObjNum; SELECT o.name, u.name into real_ora_dict_obj_name, real_ora_dict_obj_owner from sys.obj$ o , sys.user$ u where o.obj# = "GGS" .DDLReplication.ddlBaseObjNum and u.user# = o.owner# ; ELSE "GGS" .DDLReplication.getTableFromIndex ( stmt, ora_dict_obj_owner, ora_dict_obj_name, real_ora_dict_obj_owner, real_ora_dict_obj_name, otype); IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'CREATE INDEX, parent: [' || otype || '] [' || real_ora_dict_obj_owner || '.' || real_ora_dict_obj_name || ']'); END IF; SELECT o.object_id INTO "GGS" .DDLReplication.currentObjectId FROM dba_objects o WHERE o.object_type = otype AND o.object_name = real_ora_dict_obj_name AND o.owner = real_ora_dict_obj_owner; "GGS" .DDLReplication.ddlBaseObjNum := "GGS" .DDLReplication.currentObjectId ; END IF; IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'CREATE INDEX, parent object id: ' || "GGS" .DDLReplication.currentObjectId); END IF; "GGS" .DDLReplication.currentMasterName := real_ora_dict_obj_name; "GGS" .DDLReplication.currentMasterOwner := real_ora_dict_obj_owner; EXCEPTION WHEN NO_DATA_FOUND THEN "GGS" .DDLReplication.currentObjectId := NULL; WHEN OTHERS THEN "GGS" .DDL Replication.currentObjectId := NULL; END; END IF; IF real_ora_dict_obj_type = 'INDEX' AND ora_sysevent = 'DROP' THEN BEGIN SELECT bitand(i.property, 1) INTO indexUnique FROM sys.ind$ i WHERE i.obj# = "GGS" .DDLReplication.ddlObjNum; IF indexUnique = 1 THEN indexUnique := 'UNIQUE'; ELSE indexUnique := 'NONUNIQUE'; END IF; EXCEPTION WHEN NO_DATA_FOUND THEN indexUnique := 'NONUNIQUE'; WHEN OTHERS THEN indexUnique := 'NONUNIQUE'; END; ELSE indexUnique := 'NONUNIQUE'; END IF; -- for all synonyms, except for CREATE (where not available) -- get table owner/name so it can be used in extract IF real_ora_dict_obj_type = 'SYNONYM' AND ora_sysevent <> 'CREATE' THEN BEGIN SELECT s.owner, s.name INTO "GGS" .DDLReplication.currentMasterOwner, "GGS" .DDLReplication.currentMasterName FROM sys.syn$ s WHERE s.obj# = "GGS" .DDLReplication.ddlObjNum; EXCEPTION WHEN NO_DATA_FOUND THEN IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Could not find table for public synonym: ' || real_ora_dict_obj_name); END IF; -- do nothing, PUBLIC/synName is used END; END IF; /* At this point we have object id of table/sequence as well as base object owner/name (if object is not table) */ IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [2]' ); END IF; -- check if object is valid. -- For example, when compiling triggers, procedures, packages, object may not compile -- in this case DDL is still considered successful and this DDL trigger will not rollback -- however status of object will be INVALID BEGIN SELECT d.status, d.generated, d.temporary, d.secondary, d.object_type, decode(bitand(t.property, 8192), 8192, 'YES', 'NO') INTO objstatus, objectGenerated, objectTemporary, objectSecondary, objectType, isTypeTable FROM dba_objects d, sys.tab$ t WHERE d.object_id = "GGS" .DDLReplication.currentObjectId and t.obj# = "GGS" .DDLReplication.currentObjectId; IF (objstatus <> 'VALID') THEN IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDL', 'DDL operation yielded invalid status, extract will decide if ignored. DDL operation [' || stmt || '], object [' || real_ora_dict_obj_owner || '.' || real_ora_dict_obj_name || '], sta tus [' || objstatus || ']'); END IF; END IF; IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Object atts/type: [gen=' || objectGenerated || ', temp=' || objectTemporary || ', sec=' || objectSecondary || ', type=[' || objectType || ']'); END IF; IF (objectGenerated = 'Y' AND objectType <> 'TABLE PARTITION') OR objectTemporary = 'Y' OR objectSecondary = 'Y' OR isTypeTable = 'YES' THEN toIgnore := 'YES'; END IF; EXCEPTION WHEN OTHERS THEN -- do nothing because for new tables there is no entry NULL; END; -- ignore secondary sequence objects BEGIN IF ora_dict_obj_type = 'SEQUENCE' THEN SELECT d.generated, d.temporary, d.secondary INTO objectGenerated, objectTemporary, objectSecondary FROM dba_objects d WHERE d.object_id = "GGS" .DDLReplication.currentObjectId; IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Sequence Object atts/type: [gen=' || objectGenerated || ', temp=' || objectTemporary || ', sec=' || objectSecondary || ']'); END IF; IF objectGenerated = 'Y' OR objectTemporary = 'Y' OR objectSecondary = 'Y' THEN toIgnore := 'YES'; END IF; END I F; EXCEPTION WHEN OTHERS THEN -- do nothing because for new tables there is no entry IF instr ("GGS" .DDLReplication.raisable_errors, to_char (SQLCODE, 'S00000')) > 0 THEN RAISE; END IF; NULL; END; IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDL', 'DDL operation [' || stmt || '], sequence [' || "GGS" .DDLReplication.currentDDLSeq || '], ' || 'DDL type [' || ora_sysevent || '] ' || ora_dict_obj_type || ', real object type [' || real_ora_dict_obj_type || '], validity [' || objstatus || '], object ID [' || "GGS" .DDLReplication.currentObjectId || '], object [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || '], ' || ' real object [' || real_ora_dict_obj_owner || '.' || real_ora_dict_obj_name || '], ' || ' base object schema [' || "GGS" .DDLReplication.currentMasterOwner || '], ' || ' base object name [' || "GGS" .DDLReplication.currentMasterName || '], ' || ' logged as [' || ora_login_user || ']'); END IF; BEGIN SELECT o.dataobj# INTO "GGS" .DDLReplication.currentDataObjectId FROM sys.obj$ o WHERE o.obj# = "GGS" .DDLReplication.currentObjectId; EXCEPTION WHEN NO_DATA_FOUND THEN "GGS" .DDLReplication.currentDataObjectId := 0; WHEN OTHERS THEN "GGS" .DDLReplication.currentDataObjectId := 0; END; IF ora_dict_obj_type = 'TABLE' and ora_sysevent <> 'CREATE' THEN "GGS".DDLReplication.ddlBaseObjNum := "GGS".DDLReplication.ddlObjNum; END IF; --dbms_output.put_line(ora_dict_obj_type); "GGS".DDLReplication.getObjType(ora_dict_obj_type, ntype); --dbms_output.put_line(ntype); IF "GGS".DDLAux.SKIP_OBJECT( null, "GGS".DDLReplication.ddlBaseObjNum , ora_dict_obj_name, ora_dict_obj_owner , ntype, "GGS" .DDLReplication.currentMasterName , "GGS" .DDLReplication.currentMasterOwner , ora_sysevent) THEN "GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1); RETURN; END IF; -- these are stored in columns of DDL history table -- they are oracle's original just like for marker table -- 'real' ones are used to actually derive metadata *only* "GGS" .DDLReplication.currentObjectName := ora_dict_obj_name; "GGS" .DDLReplication.currentDDLType := ora_sysevent; "GGS" . DDLReplication.currentObjectOwner := ora_dict_obj_owner; "GGS" .DDLReplication.currentObjectType := ora_dict_obj_type; IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [3]' ); END IF; IF real_ora_dict_obj_type = 'INDEX' AND ora_sysevent = 'CREATE' and otype = 'TABLE' THEN "GGS" .trace_put_line ('DDLTRACE1', 'checking create index for parent type:' || otype || ' owner:' || real_ora_dict_obj_owner || ' name:' || real_ora_dict_obj_name || ' object id:' || to_char("GGS" .DDLReplication.currentObjectId)); BEGIN -- test that base table object exists. SELECT t.obj# INTO "GGS" .DDLReplication.currentObjectId FROM sys.tab$ t WHERE t.obj# = "GGS" .DDLReplication.currentObjectId; EXCEPTION WHEN NO_DATA_FOUND THEN BEGIN toIgnore := 'YES'; IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Base table does not exists'); END IF; END; END; END IF; /* insert DDL descriptor string to marker table DDL STATEMENT and related info construct DDL operation descriptor string marker record contains original object name, whereas DDL record contains 'real' (adjusted for INDEX->TABLE) */ "GGS" .DDLReplication.saveM arkerDDL ( to_char ("GGS" .DDLReplication.currentObjectId), ora_dict_obj_owner, ora_dict_obj_name, ora_dict_obj_type, ora_sysevent, to_char ("GGS" .DDLReplication.currentDDLSeq), 'GGS' || '.' || 'GGS_DDL_HIST', ora_login_user, objstatus, indexUnique, "GGS" .DDLReplication.currentMasterOwner, "GGS" .DDLReplication.currentMasterName, stmt, toIgnore); /* Get Start SCN IMPORTANT: start SCN can be obtained *only* after marker record has been written - this is Oracle limitation because transaction had no data so far (even though this is DDL transaction by itself, however in BEFORE trigger there is no start SCN until it's done because transaction hasn't officially started yet!!) */ -- get current module info dbms_application_info.read_module(oldModuleNa meInfo, oldActionInfo); -- 'stamp' current session with unique ddl sequence number -- this works even when we have multiple DDLs happenning in several background processes (all with session id of 0) moduleNameInfo := 'GGS_DDL_MODULE_' || to_char ("GGS" .DDLReplication.currentDDLSeq); dbms_application_info.set_module(moduleNameInfo, null); -- we let potential error here be handled by extract as it should never happen that we can't find SCN SELECT t.start_scnb, t.start_scnw INTO "GGS" .DDLReplication.SCNB, "GGS" .DDLReplication.SCNW FROM v$transaction t, v$session s WHERE t.addr = s.taddr AND t.ses_addr = s.saddr AND s.audsid = USERENV('SESSIONID') AND s.module = moduleNameInfo; IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDL', 'Start SCN found [' || to_char("GGS" .DDLReplication.SCNB + "GGS" .DDLReplication.SCNW * power (2, 32)) || ']'); END IF; -- restore module info dbms_application_info.set_module(oldModuleNameInfo, oldActionInfo); -- do not calculate/record any metadata for objects other than table, index or trigger -- because these are the objects we need to resolve base owner/name for -- also do not calculate metadata for TRUNCATE TABLE -- because customer may have hundreds of those - they don't change table structure!!! IF (NOT real_ora_di ct_obj_type = 'TABLE' AND NOT real_ora_dict_obj_type = 'INDEX' AND NOT real_ora_dict_obj_type = 'TRIGGER' AND NOT real_ora_dict_obj_type = 'SEQUENCE') OR (real_ora_dict_obj_type = 'TABLE' AND ora_sysevent = 'TRUNCATE') OR "GGS" .DDLReplication.stay_metadata = 1 -- do not query db for metadata if STAYMETADATA is ON THEN IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDL', '------------------------- End of log for DDL sequence [' || to_char ("GGS" .DDLReplication.currentDDLSeq) || '], no DDL history metadata recorded for this DDL operation'); END IF; IF "GGS" .DDLReplication.sql_trace = 1 THEN dbms_session.set_sql_trace(false); END IF; "GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1); RETURN; END IF; IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDL', 'Object ID is [' || to_char ("GGS" .DDLReplication.currentObjectId) || ']'); "GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [4]' ); END IF; -- For any CREATE DDL, do the same, because there can't be -- any DML for an object prior to it being created. This also -- eliminates the problem of objects that don't exis t in the context -- of ddl trigger, since this is before ddl trigger. Any CREATE DDL -- suffers from that issue. This way that problem is eliminated. -- For CREATE INDEX DDLs take history as the key sey may change as -- a result of the DDL (bug 14032266). IF (ora_sysevent <> 'CREATE' OR (toIgnore = 'NO' AND real_ora_dict_obj_type = 'INDEX' AND otype = 'TABLE')) THEN "GGS" .DDLReplication.beginHistory (); IF real_ora_dict_obj_type = 'SEQUENCE' THEN /* For sequences, we need sequence object id, name and rowid for the most part in order to map rowid to objectid/name As sequences don't have properties as tables, this is where we must stop gathering metadata as well */ IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [4-seq], sequence cache [' || to_char (seqCache) || '], sequence incrementby [' || to_char (seqIncrementBy) || ']' ); END IF; "GGS" .DDLReplication.saveSeqInfo ( real_ora_dict_obj_owner, real_ora_dict_obj_name, ora_sysevent, to_char(currUserId), seqCache, seqIncrementBy, toIgnore ); ELSE /* BEGIN HISTORY table inserts begin inserting metadata to histo ry */ -- metadata producing calls -- IMPORTANT: here we use real_ora_ values b/c resolution depends on it, also object id is correlated IF "GGS" .DDLReplication.trace_level >= 2 THEN "GGS" .trace_put_line ('DDLTRACE2', 'Goint to call getTableInfo() ' || stmt); END IF; "GGS" .DDLReplication.getTableInfo ( "GGS" .DDLReplication.ddlBaseObjNum, real_ora_dict_obj_name, real_ora_dict_obj_owner, real_ora_dict_obj_type, ora_sysevent, to_char(currUserId), "GGS" .DDLReplication.currentMasterOwner, "GGS" .DDLReplication.currentMasterName, substr (stmt, 1, 4000 - 10), toIgnore ); "GGS" .DDLReplication.getColDefs ( "GGS".DDLReplication.ddlBaseObjNum, real_ora_dict_obj_owner, real_ora_dict_obj_name); IF "GGS" .DDLReplication.useAllKeys = 1 THEN "GGS" .DDLReplication.getKeyColsUseAllKeys ( "GGS" .DDLReplication.ddlBaseObjNum, real_ora_dict_obj_owner, real_ora_dict_obj_name); ELSE "GGS" .DDLReplication.getKeyCols ( "GGS" .DDLReplication.ddlBaseObjNum, real_ora_dict_obj_owner, real_ora_dict_obj_name); END IF; IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [5]' ); END IF; -- end inserting metadata to history /* END HISTORY table inserts */ END IF; /* make sure endHistory record is placed for sequences too */ "GGS" .DDLReplication.endHistory (); END IF; BEGIN IF 'FALSE' = 'TRUE' OR 'FALSE' = 'TRUE' THEN "GGS" .trace_put_line ('DDLTRACE1', 'Trigger: Raising simulated 1013 error'); RAISE userCancelSimulate; END IF; EXCEPTION WHEN OTHERS THEN IF 'FALSE' = 'TRUE' THEN "GGS" .trace_put_line ('DDLTRACE1', 'Trigger: Raising simulated nested 1013 error'); RAISE userCancelNestedSimulate; ELSE RAISE; END IF; END; -- this is always after last executable statement IF "GGS" .DDLReplication.trace_level >= 1 THEN "GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [the end]' ); END IF; -- EXCEPTION S -- handle exceptions (if so specified) IF "GGS" .DDLReplication.trace_level >= 0 THEN "GGS" .trace_put_line ('DDL', '------------------------- End of log for DDL sequence [' || to_char ("GGS" .DDLReplication.currentDDLSeq) || ']'); END IF; IF "GGS" .DDLReplication.sql_trace = 1 THEN dbms_session.set_sql_trace(false); END IF; "GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1); RETURN; EXCEPTION WHEN OTHERS THEN "GGS" .trace_put_line ('DDL', 'Trigger sys.' || 'GGS_DDL_TRIGGER_BEFORE' || ' :Error processing DDL operation [' || stmt || '], error ' || SQLERRM || ', error stack: ' || "GGS" .ddlora_getErrorStack); -- this code will delete any previous garbage from marker data so if trigger commits, nothing is there -- unless we put it down here somewhere (in big trigger exception) or in size handling above -- this way extract doesn't abend from interrupted garbage -- note that this really shouldn't happen (it does when simulated) because oracle actually rollsback transaction IF "GGS" .DDLReplication.currentMarkerSeq IS NOT NULL THEN -- only if marker seqno set BEGIN "GGS" .trace_put_line ('DDL', 'Cleaning up marker sequence [' || "GGS" .DDLReplication.currentMarkerSeq || ']'); DELETE FROM "GGS" ."GGS_MARKER" WHERE seqNo = "GGS" .DDLReplication.currentMarkerSeq; "GGS" .trace_put_line ('DDL', 'Cleaned up [' || SQL%ROWCOUNT || '] rows from marker table'); EXCEPTION WHEN OTHERS THEN NULL; -- this is a curtesy delete, ignore if any error END; END IF; -- we also delete DDL seqno, so it's not accidentally selected in extract if trigger had problems -- and thus incomplete data BEGIN "GGS" .trace_put_line ('DDL', 'Cleaning up DDL sequence [' || "GGS" .DDLReplication.currentDDLSeq || ']'); DELETE FROM "GGS" ."GGS_DDL_HIST" WHERE seqNo = "GGS" .DDLReplication.currentDDLSeq; "GGS" .trace_put_line ('DDL', 'Cleaned up [' || SQL%ROWCOUNT || '] rows from DDL table'); EXCEPTION WHEN OTHERS THEN NULL; -- this is a curtesy delete, ignore if any error END; IF toIgnore = 'YES' THEN -- if we're somehow here, and DDL is ignored anyway, don't error out "GGS" .trace_put_line ('DDL', 'DDL is ignored, error is ignored too.'); IF "GGS" .DDLReplication.sql_trace = 1 THEN dbms_session.set_sql_trace(false); END IF; "GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1); RETURN; END IF; IF SQLCODE = -1013 OR "GGS" .ddlora_errorIsUserCancel THEN -- this is user cancellation error, just exit, never mind all this -- what happens is that Oracle rollsback previous INSERTs but we would have -- started new one here. We just want to ignore everything, hence RETURN "GGS" .trace_put_line ('DDL', 'User cancelled operation'); IF 'FALSE' = 'TRUE' OR 'FALSE' = 'TRUE' THEN "GGS" .trace_put_line ('DDLTRACE1', 'forced user cancel test stack ' || DBMS_UTILITY.format_error_stack); END IF; IF "GGS" .DDLReplication.sql_trace = 1 THEN dbms_session.set_sql_trace(false); END IF; "GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1); RETURN; END IF; IF disallowDDL = 1 THEN IF "GGS" .DDLReplication.sql_trace = 1 THEN dbms_session.set_sql_trace(false); END IF; raise_application_error (-20782, "GGS" .DDLReplication.triggerErrorMessage || ':' || SQLERRM || ', error stack: ' || "GGS" .ddlora_getErrorStack); ELSE /* if there is trouble in trigger try to make sure extract knows about it include min necessary information for end-user to examine trace log */ IF SQLCODE = -6508 THEN -- this is improper installation, alert extract to it so user knows outMessage := 'INSTALLPROBLEM: Oracle could not find properly installed DDL replication package (ORA-6508). Please ' || ' install or upgrade DDL replication package for Oracle (PLSQL code) before proceeding. Please make sure all ' || 'processes that use DDL are shutdown during trigger installation. The actual DDL here may or may not succeed.'; INSERT INTO "GGS" ."GGS_MARKER" ( seqNo, fragmentNo, optime, TYPE, SUBTYPE, marker_text ) VALUES ( -1, 0, TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'), 'DDL', 'DDLINFO', outMessage -- text of marker ); ELSE IF "GGS" .DDLReplication.currentMarkerSeq IS NULL THEN -- only if marker seqno not set SELECT "GGS" ."GGS_MARKER_SEQ" .NEXTVAL INTO "GGS" .DDLReplication.currentMarkerSeq FROM dual; END IF; outMessage := 'ERROR: DDL sequence [' || to_char ("GGS" .DDLReplication.currentDDLSeq) || '], marker sequence [' || to_char ("GGS" .DDLReplication.currentMarkerSeq) || '], DDL trace log file [' || "GGS" .DDLReplication.dumpDir || "GGS" .file_separator || 'ggs_ddl_trace.log], error code ' || to_char(SQLCODE) || ' error message ' || SQLERRM || ', error stack: ' || "GGS" .ddlora_getErrorStack; INSERT INTO "GGS" ."GGS_MARKER" ( seqNo, fragmentNo, optime, TYPE, SUBTYPE, marker_text ) VALUES ( "GGS" .DDLReplication.currentMarkerSeq, 0, TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'), 'DDL', 'DDLINFO', outMessage -- text of marker ); END IF; IF 'FALSE' = 'TRUE' THEN IF "GGS" .DDLReplication.sql_trace = 1 THEN dbms_session.set_sql_trace(false); END IF; raise_application_error (-20782, "GGS" .DDLReplication.triggerErrorMessage || ':' || SQLERRM); END IF; END IF; IF "GGS" .DDLReplication.sql_trace = 1 THEN dbms_session.set_sql_trace(false); END IF; "GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1); END;
9r4j75mjryt6a create global temporary table sys.ora_temp_1_ds_2468448 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"GC_TYPE_CODE", "ABSO_MODE", "USER_TYPE_CODE", "DIVISION_CODE", "RUN_CAP", "CONTRACT_CAP", "POWEROFF_CODE", "ARC_CALC_ID", "HANLE_REMARK", "REMIND_SECT_NO", "AMT_CALC_ID", "CALC_PERIOD", "CALC_ID", "APP_CODE", "YM", "CONS_ID", "ORG_NO", "VERI_RSLT", "VERI_REMARK", "CALC_DATE", "SEND_DATE", "CONS_NO", "CONS_NAME", "CONS_SORT_CODE", "ELEC_ADDR", "TRADE_TYPE_CODE", "ELEC_TYPE_CODE", "VOLT_CODE", "HEC_TRADE_CODE", "CREATE_DATE", "POWERON_DATE", "CANCEL_DATE", "STATUS_CODE", "BUSI_REGION_NO", "TRANSFER_FLAG", "MR_SECT_NO", "GP_CODE", "RENDER_STATUS", "CALC_TYPE", "CALC_TIMES", "PAY_MODE", "USE_MONTH", "DATA_SRC", "ORGN_CONS_NO", "APP_NO_REF", "SHIFT_NO" from "EPM_LN"."ARC_E_CONS_SNAP" sample ( 2.7430978173) t where 1 = 2
9tatc9qjgq2qu SELECT "A1"."INS_NAME", "A1"."INS_NAME", "A1"."APP_NO", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."PS_ORG_NO", "A2"."CONS_NO", "A2"."CONS_NO", "A2"."CONS_NAME", "A2"."PS_ORG_NO", "A2"."ELEC_ADDR", "A2"."VOLT_CODE", "A2"."TRADE_CODE", "A2"."HEC_INDUSTRY_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."APP_ID", "A2"."T_RUN_CAP", "A2"."ORGN_RUN_CAP", "A2"."T_CONTRACT_CAP", "A2"."ORGN_CONTRACT_CAP", "A2"."CONS_ID", "A2"."CUST_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A2"."APP_NO"="A1"."APP_NO" AND "A1"."END_TIME">=:2 AND "A1"."END_TIME"<:3 AND "A1"."INS_NAME"&l t;>'103' AND "A1"."INS_NAME"<>'112' AND "A1"."INS_NAME"<>'217' AND "A1"."STATUS_CODE"='02'
a6vvt01r5w66vselect systimestamp from dual
axajjyf55qb9pSELECT id, ip, name, lastupdate FROM sys_group_server where name=:1
aymch91s5gkqsSELECT /*+ OPAQUE_TRANSFORM */ "METER_ID", "BELONG_DEPT", "SORT_CODE", "TYPE_CODE", "PR_CODE", "CUR_STATUS_CODE" FROM "EPM_LN"."D_METER" "D" WHERE "CUR_STATUS_CODE"='012' AND "BELONG_DEPT" LIKE :1 AND ("SORT_CODE"='10' OR ("TYPE_CODE"='26' OR "TYPE_CODE"='27' OR "TYPE_CODE"='28' OR "TYPE_CODE"='29')) AND "METER_ID"=:2
ayvx78m6p3fju SELECT * FROM (SELECT LI.*, CASE WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1 WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN CASE WHEN E.SUSPEND_FLAG = 0 THEN CASE WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1 ELSE 0 END WHEN E.SUSPEND_FLAG = 1 THEN CASE WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1 ELSE 0 END ELSE 0 END ELSE 0 END OVERDUED, CASE WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME ELSE LI.TARGET_TIME_NE END TARGET_TIME, FTM.WORKFORM_TYPE_KIND FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/ WF.PROC_INSTANCE_ID, WF.ACTIVITY_INS_ID, WF.WORKITEM_INS_ID, WF.NAME, WF.CURRENT_ STATE, WF.COMPLETE_TIME, WF.CREATE_TIME, WF.LIMIT_TIME, WF.APP_URL, WF.USER_NAME, WF.USER_ID, WF.USER_ENTITY_TYPE, WF.USER_ENTITY_NAME, WF.USER_ENTITY_ID, WF.PARTICIPANT_TYPE, WF.SEND_TYPE, WF.OVERDUED AS OVERDUED_NE, WF.EXT_PROP, WF.FLOW_DIRECTION, WF.BUSINESSKEY, WF.DEPART_ID, F.INSTANCE_ID AS WI_INSTANCE_ID, F.INSTANCE_NAME AS WI_INSTANCE_NAME, F.WORKFORM_TYPE AS WI_WORKFORM_TYPE, F.BUILDER AS WI_BUILDER, F.START_TIME AS WI_CREATE_TIME, F.INSTANCE_STATUS AS WI_INSTANCE_STATUS, F.BUSINESS AS WI_BUSINESS, F.KEYDATA_ID AS WI_KEYDATA_ID, F.IS_FLOW AS WI_IS_FLOW, F.ATTR1 AS WI_ATTR1, F.DEPT_ID AS WI_DEPT_ID, '' AS WT_DEPT_ID, WF.CURRENT_STATE AS WT_WORKTASK_STATUS, NULL AS WT_TARGET_TIME, '' AS WT_LINK_URL, '' AS WT_LINK_PARAM, '' AS WT_IS_BATCH, U.REAL_NAME AS WI_BUILDER_REALNAME, NULL AS HOWLONG_WILL_OVERDUE, NULL AS HOWLONG_OVERDUED, '' AS ACTIVITY_TMP_ID, O.TIME_OUT_TIME AS TARGET_TIME_NE, B.APPROVAL_STATUS AS BE_APPROVAL_STATUS, ORG.ORG_NO, ORG.ORG_NAME, '' AS VIEW_FLAGS FROM SA_WORKFORM_INST F, (SELECT W.* FROM RT_WORKITEMINST W WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = :1 AND W.PARTICIPANT_TYPE = 0 UNION ALL SELECT W.* FROM RT_WORKITEMINST W, SA_BROLE_USER R WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = R.ROLE_ID AND R.USER_ID = :2 AND W.PARTICIPANT_TYPE = 1) WF, SA_USER U, (SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O, SA_WF_BUSINESS_EXT B, SA_DEPT D, SA_ORG ORG WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+) AND F.BUILDER = U.USER_ID(+) AND U.DEPT_ID = D.DEPT_ID(+) AND D. ORG_NO = ORG.ORG_NO(+) AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+) AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (:6 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :7))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:8 LIKE (F.DEPT_ID || '%')) OR (:9 = F.DEPT_ID) OR (:10 = F.DEPT_ID) OR (:11 = F.DEPT_ID) OR (F.DEPT_ID LIKE :12)))))) UNION ALL SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/ WF.PROC_INSTANCE_ID, WF.ACTIVITY_INS_ID, WF.WORKITEM_INS_ID, WF.NAME, WF.CURRENT_STATE, WF.COMPLETE_TIME, WF.CREATE_TIME, WF.LIMIT_TIME, WF.APP_URL, WF.USER_NAME, WF.USER_ID, WF.USER_ENTITY_TYPE, WF.USER_ENTITY_NAME, WF.USER_ENTITY_ID, WF.PARTICIPANT_TYPE, WF.SEND_TYPE, WF.OVERDUED AS OVERDUED_NE, WF.EXT_PROP, WF.FLOW_DIRECTION, WF.BUSINESSKEY, WF.DEPART_ID, F.INSTANCE_ID AS WI_INSTANCE_ID, F.INSTANCE_NAME AS WI_INSTANCE_NAME, F.WORKFORM_TYPE AS WI_WORKFORM_TYPE, F.BUILDER AS WI_BUILDER, F.START_TIME AS WI_CREATE_TIME, F.INSTANCE_STATUS AS WI_INSTANCE_STATUS, F.BUSINESS AS WI_BUSINESS, F.KEYDATA_ID AS WI_KEYDATA_ID, F.IS_FLOW AS WI_IS_FLOW, F.ATTR1 AS WI_ATTR1, F.DEPT_ID AS WI_DEPT_ID, '' AS WT_DEPT_ID, WF.CURRENT_STATE AS WT_WORKTASK_STATUS, NULL AS WT_TARGET_TIME, '' AS WT_LINK_URL, '' AS WT_LINK_PARAM, '' AS WT_IS_BATCH, U.REAL_NAME AS WI_BUILDER_REALNAME, NULL AS HOWLONG_WILL_OVERDUE, NULL AS HOWLONG_OVERDUED, '' AS ACTIVITY_TMP_ID, O.TIME_OUT_TIME AS TARGET_TIME_NE, B.APPROVAL_STATUS AS BE_APPROVAL_STATUS, ORG.ORG_NO, ORG.ORG_NAME, '' AS VIEW_FLAGS FROM SA_WORKFORM_INST F, (SELECT W.* FROM RT_WORKITEMINST W WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = :13 AND W.PARTICIPANT_TYPE = 0 UNION ALL SELECT W.* FROM RT_WORKITEMINST W, SA_BROLE_USER R WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR W.CURRENT_STATE = 3) AND W.USER_ID = R.ROLE_ID AND R.USER_ID = :14 AND W.PARTICIPANT_TYPE = 1) WF, SA_USER U, RT_PROCESSINSTANCE P, (SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O, SA_WF_BUSINESS_EXT B, SA_DEPT D, SA_ORG ORG WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID AND P.PARENT_PROCINC_ID IS NOT NULL AND F.PROCINST_ID = P.PARENT_PROCINC_ID AND F.BUILDER = U.USER_ID(+) AND U.DEPT_ID = D.DEPT_ID(+) AND D.ORG_NO = ORG.ORG_NO(+) AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+) AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+) AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:15 LIKE (WF.DEPART_ID || '%')) OR (:16 = WF.DEPART_ID) OR (:17 = WF.DEPART_ID) OR (:18 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :19))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:20 LIKE (F.DEPT_ID || '%')) OR (:21 = F.DEPT_ID) OR (:22 = F.DEPT_ID) OR (:23 = F.DEPT_ID) OR (F.DEPT_ID LIKE :24)))))) AND NOT EXISTS (SELECT 1 FROM SA_WORKFORM_INST RF WHERE WF.PROC_INSTANCE_ID = RF.PROCINST_ID)) LI, SA_WF_WORKFORM_TYPE_MAP FTM, (SELECT ACT_INST_ID, SUSPEND_FLAG, MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME, MIN(SUSPEND_TIME) AS SUSPEND_TIME FROM (SELECT A.ACT_INST_ID, B.* FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID AND A.PROC_INST_ID = B.PROC_INST_ID AND B.COMPLETE_FLAG = 0) GROUP BY ACT_INST_ID, SUSPEND_FLAG) E WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+) AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T WHERE NOT EXISTS (SELECT 1 FROM SA_WF_WORKITEM_EXCLUDED_USER US WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID AND US.USER_ID = :25)
b4zcs3an3cnmnSELECT "METER_ID", "INST_DATE", "ORG_NO" FROM "EPM_LN"."C_METER" "C" WHERE "ORG_NO" LIKE :1 AND "METER_ID"=:2
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
b820g52hhvtfmSELECT SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A3"."APP_NO", SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A2"."CONS_NO", :1, "A2"."CONS_NO", "A2"."CONS_NAME", "A3"."PS_ORG_NO", "A2"."ELEC_ADDR", "A3"."VOLT_CODE", "A2"."TRADE_CODE", NVL("A3"."HEC_INDUSTRY_CODE", '000'), "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ID", "A2"."CONTRACT_CAP", "A1"."INS_NAME" FROM "ARC_S_APP" "A3", "ARC_S_BATCH_CUST_APP" "A2", "P_PROC_INSTANCE" "A1" WHERE "A3"."APP_ID"="A2"."APP_ID" AND "A3"."APP_NO"="A1"."APP_NO" AND "A1"."END_TIME">=:2 AND "A1"."END_TIME"<:3 AND "A1"."STATUS_CODE"='02' AND ("A1"."INS_NAME"='103' OR "A1"."INS_NAME"='112' OR "A1"."INS_NAME"='217') AND "A3"."PS_ORG_NO" LIKE :4
bg1zdrp116hrm INSERT INTO O_BUSI_ACT SELECT :B1 , NVL(A.ORG_NO, '000') AS ORG_NO, NVL(A.DEPT_NO, '000') AS DEPT_NO, NVL(A.PROC_NO, '000') AS PROC_NO, NVL(A.ACT_SORT_CODE, '000') AS ACT_SORT_CODE, NVL(A.HANDLE_EMP_NO, '000') AS HANDLE_EMP_NO, NVL(A.STATUS_CODE, '000') AS STATUS_CODE, SUM(A.HANDLE_CC) AS HANDLE_CC, SUM(A.WKST_NUM) AS WKST_NUM, SUM(A.UNCMPL_NUM) AS UNCMPL_NUM, SUM(A.OT_UNCMPL_NUM) AS OT_UNCMPL_NUM, SUM(A.CMPL_NUM) AS CMPL_NUM, SUM(A.ONTIME_CMPL_NUM) AS ONTIME_CMPL_NUM, SUM(A.OT_CMPL_NUM) AS OT_CMPL_NUM FROM (SELECT NVL(T.ORG_NO, '777') AS ORG_NO, NVL(T.DEPT_ID, '777') AS DEPT_NO, NVL(T.APP_TYPE_CODE, '777') AS PROC_NO, MAX(NAME_1) ACT_SORT_CODE, T.BUILDER HANDLE_EMP_NO, '???' AS STATUS_CODE, CASE WHEN COUNT(S.CONS_NO) = 0 THEN COUNT(DISTINCT(T.APP_NO)) ELSE COUNT(S.CONS_NO) + COUNT(DISTINCT(T.APP_NO)) - COUNT(DISTINCT(S.APP_NO)) END AS HANDLE_CC, COUNT(DISTINCT(T.APP_NO)) AS WKST_NUM, COUNT(DISTINCT(T.APP_NO)) AS UNCMPL_NUM, NVL(CASE WHEN T.OVERDUED = 1 THEN COUNT(DISTINCT(T.APP_NO)) END, 0) AS OT_UNCMPL_NUM, 0 AS CMPL_NUM, 0 AS ONTIME_CMPL_NUM, 0 AS OT_CMPL_NUM FROM (SELECT A.ORG_NO ORG_NO, A.APP_ID APP_ID, A.APP_NO APP_NO, A.APP_TYPE_CODE APP_TYPE_CODE, B.KEYDATA_ID KEYDATA_ID, CASE WHEN D.NAME IS NULL THEN '???????' ELSE D.NAME END AS NAME_1, B.BUILDER BUILDER, C.DEPT_ID DEPT_ID, C.REAL_NAME REAL_NAME, B.IS_FLOW IS_FLOW, B.PROCINST_ID PROCINST_ID, D.PROC_INSTANCE_ID PROC_INSTANCE_ID, E.OVERDUED OVERDUED FROM S_APP A, SA_WORKF ORM_INST B, SA_USER C, RT_ACTINST D, RT_PROCESSINSTANCE E WHERE TO_CHAR(HANDLE_TIME, 'YYYYMMDD') = :B1 AND B.KEYDATA_ID = A.APP_NO AND B.BUILDER = C.USER_ID AND D.PROC_INSTANCE_ID = B.PROCINST_ID AND A.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '715', '716') AND D.CURRENT_STATE = '1' AND E.PROC_INSTANCE_ID(+) = B.PROCINST_ID AND E.PARENT_PROCINC_ID IS NULL) T, S_BATCH_CUST_APP S WHERE S.APP_ID(+) = T.APP_ID GROUP BY T.ORG_NO, T.DEPT_ID, T.APP_TYPE_CODE, T.BUILDER, T.OVERDUED UNION SELECT NVL(A.ORG_NO, '888') AS ORG_NO, NVL(A.DEPT_ID, '888') AS DEPT_NO, NVL(A.APP_TYPE_CODE, '888') AS PROC_NO, '?' AS ACT_SORT_CODE, A.BUILDER AS HANDLE_EMP_NO, '???' AS STATUS_CODE, 0 AS HANDLE_CC, 0 AS WKST_NUM, 0 AS UNCMPL_NUM, 0 AS OT_UNCMPL_NUM, SUM(CMPL_NUM) AS CMPL_NUM, SUM(ONTIME_CMPL_NUM1) + SUM(ONTIME_CMPL_NUM3) AS OT_CMPL_NUM, SUM(ONTIME_CMPL_NUM24) + SUM(ONTIME_CMPL_NUM2) + SUM(ONTIME_CMPL_NUM4) AS ONTIME_CMPL_NUM FROM (SELECT B.ORG_NO, E.DEPT_ID, B.APP_TYPE_CODE, A.BUILDER, 0, 0, 0, 0, COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO)) AS CMPL_NUM, NVL(CASE WHEN D.OVERDUED IS NULL THEN (COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO))) END, 0) AS ONTIME_CMPL_NU M24, NVL(CASE WHEN D.OVERDUED = 2 THEN (COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO))) END, 0) AS ONTIME_CMPL_NUM2, NVL(CASE WHEN D.OVERDUED = 4 THEN (COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO))) END, 0) AS ONTIME_CMPL_NUM4, NVL(CASE WHEN D.OVERDUED = 1 THEN (COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO))) END, 0) AS ONTIME_CMPL_NUM1, NVL(CASE WHEN D.OVERDUED = 3 THEN (COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO))) END, 0) AS ONTIME_CMPL_NUM3 FROM SA_WORKFORM_INST_HISTORY A, ARC_S_APP B, ARC_S_BATCH_CUST_APP C, RT_PROCESSINSTANCE D, SA_USER E WHERE TO_CHAR(A.COMPLETE_TIME, 'YYYYMMDD') = :B1 AND A.KEYDATA_ID = B.APP_NO AND C.APP_ID(+) = B.APP_ID AND D.PROC_INSTANCE_ID(+) = A.PROCINST_ID AND A.BUILDER = E.USER_ID AND D.PARENT_PROCINC_ID IS NULL AND B.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '715', '716') GROUP BY B.ORG_NO, E.DEPT_ID, B.APP_TYPE_CODE, A.BUILDER, D.OVERDUED) A GROUP BY A.ORG_NO, A.DEPT_ID, A.APP_TYPE_CODE, A.BUILDER UNION SELECT NVL(A.ORG_NO, '888') AS ORG_NO, NVL(A.DEPT_ID, '888') AS DEPT_NO, NVL(A.APP_TYPE_CODE, '888') AS PROC_NO, '?' AS ACT_SORT_CODE, A.BUILDER AS HANDLE_EMP_NO, '???' AS STATUS_CODE, SUM(HANDLE_CC) AS HANDLE_CC, SUM(WKST_NUM) AS WKST_NUM, 0 AS UNCMPL_NUM, 0 AS OT_UNCMPL_NUM, 0 AS CMPL_NUM, 0 AS OT_CMPL_NUM, 0 AS ONTIME_CMPL_NUM FROM (SELECT B.ORG_NO, E.DEPT_ID, B.APP_TYPE_CODE, A.BUILDER, CASE WHEN COUNT(C.CONS_NO) = 0 THEN COUNT(DISTINCT(B.APP_NO)) ELSE COUNT(C.CONS_NO) + COUNT(DISTINCT(B.APP_NO)) - COUNT(DISTINCT(C.APP_NO)) END AS HANDLE_CC, COUNT(DISTINCT(B.APP_NO)) AS WKST_NUM FROM SA_WORKFORM_INST_HISTORY A, ARC_S_APP B, ARC_S_BATCH_CUST_APP C, RT_PROCESSINSTANCE D, SA_USER E WHERE TO_CHAR(B.HANDLE_TIME, 'YYYYMMDD') = :B1 AND A.KEYDATA_ID = B.APP_NO AND C.APP_ID(+) = B.APP_ID AND D.PROC_INSTANCE_ID(+) = A.PROCINST_ID AND A.BUILDER = E.USER_ID AND D.PARENT_PROCINC_ID IS NULL AND B.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '715', '716') GROUP BY B.ORG_NO, E.DEPT_ID, B.APP_TYPE_CODE, A.BUILDER, D.OVERDUED) A GROUP BY A.ORG_NO, A.DEPT_ID, A.APP_TYPE_CODE, A.BUILDER UNION SELECT NVL(T.ORG_NO, '999') AS ORG_NO, NVL(T.DEPT_ID, '999') AS DEPT_NO, NVL(T.APP_TYPE_CODE, '999') AS PROC_NO, MAX(NAME_1) AS ACT_SORT_CODE, T.BUILDER AS HANDLE_EMP_NO, '???' AS STATUS_CODE, CASE WHEN COUNT(S.CONS_NO) = 0 THEN COUNT(DISTINCT(T.APP_NO)) ELSE COUNT(S.CONS_NO) + COUNT(DI STINCT(T.APP_NO)) - COUNT(DISTINCT(S.APP_NO)) END AS HANDLE_CC, COUNT(DISTINCT(T.APP_NO)) AS WKST_NUM, COUNT(DISTINCT(T.APP_NO)) AS UNCMPL_NUM, 0 AS OT_UNCMPL_NUM, 0 AS CMPL_NUM, 0 AS ONTIME_CMPL_NUM, 0 AS OT_CMPL_NUM FROM (SELECT A.ORG_NO ORG_NO, A.APP_ID APP_ID, A.APP_NO APP_NO, A.APP_TYPE_CODE APP_TYPE_CODE, B.KEYDATA_ID KEYDATA_ID, CASE WHEN C.WORKTASK_NAME IS NULL THEN '???????' ELSE C.WORKTASK_NAME END AS NAME_1, B.BUILDER BUILDER, C.DEPT DEPT_ID FROM S_APP A, SA_WORKFORM_INST B, SA_WORKTASK C WHERE TO_CHAR(HANDLE_TIME, 'YYYYMMDD') = :B1 AND B.KEYDATA_ID = A.APP_NO AND B.INSTANCE_ID = C.INSTANCE_ID AND B.PROCINST_ID IS NULL AND A.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '715', '716') ) T, S_BATCH_CUST_APP S WHERE S.APP_ID(+) = T.APP_ID GROUP BY T.ORG_NO, T.DEPT_ID, T.APP_TYPE_CODE, T.BUILDER ) A GROUP BY A.ORG_NO, A.DEPT_NO, A.PROC_NO, A.ACT_SORT_CODE, A.HANDLE_EMP_NO, A.STATUS_CODE
c053y9dmm5xh1BEGIN PRC_O_CONSBASE(:1); END;
c1599tjmzu1fc/* OracleOEM */ BEGIN :message := dbms_server_alert.expand_message(:language, :message_id, :argument_1, :argument_2, :argument_3, :argument_4, :argument_5); END;
ca4ukj0ujvz3x SELECT "A1"."INS_NAME", "A1"."APP_NO", "A1"."INS_NAME", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."PS_ORG_NO", "A2"."CONS_NO", "A2"."CONS_NO", "A2"."CONS_NAME", "A2"."PS_ORG_NO", "A2"."ELEC_ADDR", "A2"."VOLT_CODE", "A2"."TRADE_CODE", "A2"."HEC_INDUSTRY_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."CONS_ID", "A2"."CUST_ID", "A2"."APP_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A1"."APP_NO"="A2"."APP_NO" AND "A1"."INS_NAME"<>'103' AND "A1"."INS_NAME"<>'112' AND "A1"."INS_NAME"<>'217' AND "A1"."END_TIME">=:2 AND "A1"."END_TIME"<:3 AND "A1"."STATUS_CODE"='02'
cj8q5srj4prndBEGIN PRC_O_BUSI_ACT(:1); END;
cjk1ffy5kmm5sselect obj# from oid$ where user#=:1 and oid$=:2
cqv52axncuvzvSELECT signature, nhash, sqlarea_hash, last_used, inuse_features, flags, modified, incarnation FROM sql$ WHERE signature = :1
crar4jfwaf7m6 SELECT "A1"."INS_NAME", "A1"."INS_NAME", "A1"."APP_NO", "A1"."BGN_TIME", "A1"."BGN_TIME", "A1"."INS_NAME", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."PS_ORG_NO", "A2"."CONS_NO", "A2"."CONS_NO", "A2"."CONS_NAME", "A2"."PS_ORG_NO", "A2"."ELEC_ADDR", "A2"."VOLT_CODE", "A2"."TRADE_CODE", "A2"."HEC_INDUSTRY_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."APP_ID", "A2"."T_RUN_CAP", "A2"."ORGN_RUN_CAP", "A2"."T_CONTRACT_CAP", "A2"."ORGN_CONTRACT_CAP", "A2"."CONS_ID", "A2"."CUST_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A2"."APP_NO"="A1"."APP_NO" AND "A1"."BGN_TIME">=:2 AND "A1"."BGN_TIME"<:3 AND "A1"."INS_NAME"<>'103' AND "A1"."INS_NAM E"<>'112' AND "A1"."INS_NAME"<>'217'
csr9ggpd4zawcBEGIN PRC_O_LLR_CMPL(:1); END;
d9dkp2jmgfvr3select sa_resource.RES_ID as "RES_ID", sa_resource.MODULE_NAME as "MODULE_NAME", sa_resource.RES_NAME as "RES_NAME", sa_resource.RES_TYPE as "RES_TYPE", sa_resource.PERMISSION_ID as "PERMISSION_ID", sa_resource.ATTR1 as "ATTR1", sa_resource.ATTR2 as "ATTR2", sa_resource.ATTR3 as "ATTR3", sa_resource.ATTR4 as "ATTR4", sa_resource.FOLDER_ID as "FOLDER_ID", sa_resource.HEIGHT as "HEIGHT", sa_resource.PANEL_TITLE as "PANEL_TITLE", sa_resource.B_PANEL as "B_PANEL", sa_resource.VALID_FLAG as "VALID_FLAG", sa_resource.START_TIME as "START_TIME", sa_resource.END_TIME as "END_TIME" from sa_resource where sa_resource.RES_TYPE = 'component' and sa_resource.ATTR1 = :1 and sa_resource.ATTR2 = :2
f3v7cr8996tw6create global temporary table sys.ora_temp_1_ds_2478178 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"MR_STATUS_CODE", "EXCP_TYPE_CODE", "LAST_MR_DATE", "THIS_YMD", "SRC_CODE", "RELA_APP_NO", "MR_FACTOR", "ACTUAL_MODE", "METER_DATE", "CHECK_TYPE", "PRC_CODE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "ADJUST_PQ", "ADJUST_MODE", "RECORD_ID", "CONS_MT_ID", "MODIFY_TIMES", "USAGE_TYPE_CODE", "CONTAINER_NO", "T_PRC", "REMARK", "BAR_CODE", "MR_ID", "MR_PLAN_NO", "APP_NO", "CALC_ID", "AMT_YM", "CONS_NO", "ORG_NO", "METER_ID", "MP_ID", "MR_SN", "AVG_PQ", "MR_DIGIT", "READ_TYPE_CODE", "T_FACTOR", "LAST_MR_NUM", "LAST_MR_PQ", "THIS_READ", "THIS_READ_PQ" from "EPM_LN"."ARC_R_DATA" sample ( .9637362097) t where 1 = 2
faww0hfwysxpk create global temporary table sys.ora_temp_1_ds_2468491 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"GC_TYPE_CODE", "ABSO_MODE", "USER_TYPE_CODE", "DIVISION_CODE", "RUN_CAP", "CONTRACT_CAP", "POWEROFF_CODE", "ARC_CALC_ID", "HANLE_REMARK", "REMIND_SECT_NO", "AMT_CALC_ID", "CALC_PERIOD", "CALC_ID", "APP_CODE", "YM", "CONS_ID", "ORG_NO", "VERI_RSLT", "VERI_REMARK", "CALC_DATE", "SEND_DATE", "CONS_NO", "CONS_NAME", "CONS_SORT_CODE", "ELEC_ADDR", "TRADE_TYPE_CODE", "ELEC_TYPE_CODE", "VOLT_CODE", "HEC_TRADE_CODE", "CREATE_DATE", "POWERON_DATE", "CANCEL_DATE", "STATUS_CODE", "BUSI_REGION_NO", "TRANSFER_FLAG", "MR_SECT_NO", "GP_CODE", "RENDER_STATUS", "CALC_TYPE", "CALC_TIMES", "PAY_MODE", "USE_MONTH", "DATA_SRC", "ORGN_CONS_NO", "APP_NO_REF", "SHIFT_NO" from "EPM_LN"."ARC_E_CONS_SNAP" sample ( 1.1024463483) t where 1 = 2
fnfvv8wmh4gfpcreate global temporary table sys.ora_temp_1_ds_2478190 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"MR_STATUS_CODE", "EXCP_TYPE_CODE", "LAST_MR_DATE", "THIS_YMD", "SRC_CODE", "RELA_APP_NO", "MR_FACTOR", "ACTUAL_MODE", "METER_DATE", "CHECK_TYPE", "PRC_CODE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "ADJUST_PQ", "ADJUST_MODE", "RECORD_ID", "CONS_MT_ID", "MODIFY_TIMES", "USAGE_TYPE_CODE", "CONTAINER_NO", "T_PRC", "REMARK", "BAR_CODE", "MR_ID", "MR_PLAN_NO", "APP_NO", "CALC_ID", "AMT_YM", "CONS_NO", "ORG_NO", "METER_ID", "MP_ID", "MR_SN", "AVG_PQ", "MR_DIGIT", "READ_TYPE_CODE", "T_FACTOR", "LAST_MR_NUM", "LAST_MR_PQ", "THIS_READ", "THIS_READ_PQ" from "EPM_LN"."ARC_R_DATA" sample ( .6104701432) t where 1 = 2
ft2b5tk5pcb8tcreate global temporary table sys.ora_temp_1_ds_2478189 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"MR_STATUS_CODE", "EXCP_TYPE_CODE", "LAST_MR_DATE", "THIS_YMD", "SRC_CODE", "RELA_APP_NO", "MR_FACTOR", "ACTUAL_MODE", "METER_DATE", "CHECK_TYPE", "PRC_CODE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "ADJUST_PQ", "ADJUST_MODE", "RECORD_ID", "CONS_MT_ID", "MODIFY_TIMES", "USAGE_TYPE_CODE", "CONTAINER_NO", "T_PRC", "REMARK", "BAR_CODE", "MR_ID", "MR_PLAN_NO", "APP_NO", "CALC_ID", "AMT_YM", "CONS_NO", "ORG_NO", "METER_ID", "MP_ID", "MR_SN", "AVG_PQ", "MR_DIGIT", "READ_TYPE_CODE", "T_FACTOR", "LAST_MR_NUM", "LAST_MR_PQ", "THIS_READ", "THIS_READ_PQ" from "EPM_LN"."ARC_R_DATA" sample ( .5776913240) t where 1 = 2
g3wrkmxkxzhf2select cols, audit$, textlength, intcols, property, flags, rowid from view$ where obj#=:1
g8bjbfhv73d31SELECT NVL(SUM(NVL(RCVBL_PENALTY, 0)-NVL(RCVED_PENALTY, 0)), 0) PENALTY, MIN(RCVBL_AMT_ID) RCVBL_AMT_ID FROM A_RCVBL_FLOW WHERE CONS_NO = :1 AND ORG_NO LIKE :2 AND SETTLE_FLAG in ('01', '02')
g8k48mbcnrt9bselect * from (select alia.*, rownum as rnum from (SELECT DISTINCT group_id FROM rt_overtime_deal WHERE current_state=:1 AND (create_time is not null) AND (time_out_time is NULL) AND handlestate=0 AND version=0) alia where rownum <2) where rnum>=1
gfqm840qr17qqSELECT SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A3"."APP_NO", SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A1"."CONS_NO", :1, "A1"."CONS_NO", "A1"."CONS_NAME", "A3"."PS_ORG_NO", "A1"."ELEC_ADDR", "A3"."VOLT_CODE", "A1"."TRADE_CODE", NVL("A3"."HEC_INDUSTRY_CODE", '000'), "A1"."ELEC_TYPE_CODE", "A1"."ELEC_TYPE_CODE", 0, "A2"."INS_NAME", "A3"."APP_ID" FROM "ARC_S_APP" "A3", "P_PROC_INSTANCE" "A2", "ARC_S_BATCH_CUST_APP" "A1" WHERE "A2"."APP_NO"="A3"."APP_NO" AND "A3"."APP_ID"="A1"."APP_ID" AND ("A2"."INS_NAME"='103' OR "A2"."INS_NAME"='112' OR "A2"."INS_NAME"='217') AND "A2"."END_TIME">=:2 AND "A2"."END_TIME"<:3 AND "A2"."STATUS_CODE"='02' AND "A3"."PS_ORG_NO" LIKE :4
gq29uz9g0tcb9 INSERT INTO SA_O_LLR_CMPL SELECT AA.ORG_NO, :B3 , AA.CHKUNIT_ID, AA.CHKUNIT_NAME, AA.PPQ, AA.SPQ, AA.LPQ, AA.LLR, AA.LL_IDX, AA.IDX_DIFF, AA.LPQ_DIFF, NVL(CC.LLR, 0), AA.LLR - NVL(CC.LLR, 0), NVL(CC.LPQ, 0), AA.LPQ - NVL(CC.LPQ, 0), NVL(BB.LLR, 0), AA.LLR - NVL(BB.LLR, 0), NVL(BB.LPQ, 0), AA.LPQ - NVL(BB.LPQ, 0) FROM (SELECT A.ORG_NO ORG_NO, A.CHKUNIT_ID, A.CHKUNIT_NAME, D.CHKUNIT_PPQ PPQ, D.CHKUNIT_SPQ SPQ, (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ) LPQ, (CASE WHEN D.CHKUNIT_PPQ != 0 THEN (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ) / D.CHKUNIT_PPQ ELSE 0 END) LLR, NVL(E.LL_IDX_VALUE, 0) LL_IDX, ((CASE WHEN D.CHKUNIT_PPQ != 0 THEN (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ) / D.CHKUNIT_PPQ ELSE 0 END) - NVL(E.LL_IDX_VALUE, 0)) IDX_DIFF, (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ - D.CHKUNIT_PPQ * NVL(E.LL_IDX_VALUE, 0)) LPQ_DIFF FROM G_CHKUNIT A, G_CHKUNIT_COMP B, G_LL_STAT C, G_CHKUNIT_PQ D, G_CHKUNIT_REF_IDX E WHERE A.CHKUNIT_ID = B.CHKUNIT_ID AND A.LINK_FLAG = '0' AND C.DATA_STATUS = '01' AND C.ORG_NO = A.ORG_NO AND C.STAT_ID = D.STAT_ID AND C.STAT_SORT_CODE = '03' AND A.CHKUNIT_ID = C.RANGE_ID AND A.CHKUNIT_ID = E.CHKUNIT_ID(+) AND E.CHK_MONTH(+) = :B3 AND TO_CHAR(C.END_DATE, 'YYYYMM') = :B3 ) AA, (SELECT A.CHKUNIT_ID, A.CHKUNIT_NAME, D.CHKUNIT_PPQ - D.CHKUNIT_SPQ LPQ, CASE WHEN D.CHKUNIT_PPQ != 0 THEN (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ) / D.CHKUNIT_PPQ ELSE 0 END LLR FROM G_CHKUNIT A, G_CHKUNIT_COMP B, G_LL_STAT C, G_CHKUNIT_PQ D WHERE A.CHKUNIT_ID = B.CHKUNIT_ID AND A.LI NK_FLAG = '0' AND A.CHKUNIT_TYPE_CODE = '01' AND B.OBJ_TYPE_CODE = '01' AND C.DATA_STATUS = '01' AND C.ORG_NO = A.ORG_NO AND C.STAT_ID = D.STAT_ID AND C.STAT_SORT_CODE = '03' AND A.CHKUNIT_ID = C.RANGE_ID AND TO_CHAR(C.END_DATE, 'YYYYMM') = :B2 ) BB, (SELECT A.CHKUNIT_ID, A.CHKUNIT_NAME, D.CHKUNIT_PPQ - D.CHKUNIT_SPQ LPQ, CASE WHEN D.CHKUNIT_PPQ != 0 THEN (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ) / D.CHKUNIT_PPQ ELSE 0 END LLR FROM G_CHKUNIT A, G_CHKUNIT_COMP B, G_LL_STAT C, G_CHKUNIT_PQ D WHERE A.CHKUNIT_ID = B.CHKUNIT_ID AND A.LINK_FLAG = '0' AND A.CHKUNIT_TYPE_CODE = '01' AND C.ORG_NO = A.ORG_NO AND C.STAT_ID = D.STAT_ID AND C.STAT_SORT_CODE = '03' AND A.CHKUNIT_ID = C.RANGE_ID AND TO_CHAR(C.END_DATE, 'YYYYMM') = :B1 ) CC WHERE AA.CHKUNIT_ID = BB.CHKUNIT_ID(+) AND AA.CHKUNIT_ID = CC.CHKUNIT_ID(+)
gvg46qmtsmdc6INSERT INTO O_CUST_VALUE_EVAL (SELECT C.ORG_NO AS ORG_NO, TO_CHAR(CV.EVAL_DATE, 'yyyymm') AS YM, NVL(CL.EXECUTOR_NO, '9999') AS EVAL_PERSON, COUNT(DISTINCT CV.CUST_ID) AS VALUE_EVAL_CC, S.CUST_CC - COUNT(DISTINCT CV.CUST_ID) AS VALUE_UNEVAL_CC, S.CUST_CC AS CC FROM S_CUST_VALUE CV, S_CR_EVAL_LOG CL, C_CONS C, (SELECT O.ORG_NO, COUNT(DISTINCT O.CUST_ID) CUST_CC FROM C_CONS O GROUP BY O.ORG_NO) S WHERE CV.CUST_ID = C.CUST_ID AND CV.ID3 = CL.ID(+) AND S.ORG_NO = C.ORG_NO AND TO_CHAR(CV.EVAL_DATE, 'yyyymm') = :B1 GROUP BY C.ORG_NO, TO_CHAR(CV.EVAL_DATE, 'yyyymm'), CL.EXECUTOR_NO, S.CUST_CC)
gvwx5k6wyadarcreate global temporary table sys.ora_temp_1_ds_2468463 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"PREPAY_DATE", "PREPAY_YM", "ACCT_NO", "NOTE_ID", "REMA_TYPE", "REMAIN", "PAY_MODE", "PART_CHG_YM", "FREEZE_AMT", "PREPAY_ID", "CHARGE_ID", "PREPAY_AMT", "CONS_NO", "ORG_NO" from "EPM_LN"."A_PREPAY_FLOW" sample ( .6118683049) t where 1 = 2
gx4rhfz2g90txDELETE FROM QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 2,050,319 567.79 56.11
CPU used when call started 4,072,159 1,127.69 111.45
CR blocks created 41,197 11.41 1.13
Cached Commit SCN referenced 69,381,107 19,213.54 1,898.88
Commit SCN cached 274 0.08 0.01
DB time 16,838,284 4,662.99 460.84
DBWR checkpoint buffers written 138,664 38.40 3.80
DBWR checkpoints 1 0.00 0.00
DBWR fusion writes 513 0.14 0.01
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 4,032 1.12 0.11
DBWR undo block writes 33,782 9.36 0.92
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 18 0.00 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 54 0.01 0.00
PX local messages sent 54 0.01 0.00
PX remote messages recv'd 832 0.23 0.02
PX remote messages sent 727 0.20 0.02
Parallel operations downgraded to serial 36 0.01 0.00
Parallel operations not downgraded 18 0.00 0.00
RowCR - row contention 18 0.00 0.00
RowCR attempts 14,644,208 4,055.39 400.79
RowCR hits 14,948,120 4,139.55 409.11
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 25,243,835 6,990.71 690.89
SQL*Net roundtrips to/from dblink 92,459 25.60 2.53
active txn count during cleanout 36,699 10.16 1.00
application wait time 1,651 0.46 0.05
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 20,906 5.79 0.57
branch node splits 3 0.00 0.00
buffer is not pinned count 859,149,773 237,922.29 23,513.87
buffer is pinned count 583,464,322 161,577.38 15,968.70
bytes received via SQL*Net from client 2,865,427,411 793,515.96 78,423.21
bytes received via SQL*Net from dblink 11,924,334 3,302.18 326.35
bytes sent via SQL*Net to client 4,017,923,716 1,112,674.01 109,965.62
bytes sent via SQL*Net to dblink 10,795,364 2,989.53 295.46
calls to get snapshot scn: kcmgss 13,625,727 3,773.34 372.92
calls to kcmgas 197,726 54.76 5.41
calls to kcmgcs 18,530 5.13 0.51
change write time 2,364 0.65 0.06
cleanout - number of ktugct calls 124,566 34.50 3.41
cleanouts and rollbacks - consistent read gets 9,181 2.54 0.25
cleanouts only - consistent read gets 84,407 23.37 2.31
cluster key scan block gets 332,692 92.13 9.11
cluster key scans 146,811 40.66 4.02
cluster wait time 904,480 250.48 24.75
commit batch performed 688 0.19 0.02
commit batch requested 688 0.19 0.02
commit batch/immediate performed 2,825 0.78 0.08
commit batch/immediate requested 2,825 0.78 0.08
commit cleanout failures: block lost 852 0.24 0.02
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 591 0.16 0.02
commit cleanout failures: cannot pin 66 0.02 0.00
commit cleanouts 68,154 18.87 1.87
commit cleanouts successfully completed 66,645 18.46 1.82
commit immediate performed 2,137 0.59 0.06
commit immediate requested 2,137 0.59 0.06
commit txn count during cleanout 364,240 100.87 9.97
concurrency wait time 4,599,975 1,273.86 125.90
consistent changes 57,590 15.95 1.58
consistent gets 1,733,340,822 480,009.93 47,439.40
consistent gets - examination 829,318,209 229,661.11 22,697.42
consistent gets direct 17 0.00 0.00
consistent gets from cache 1,733,340,844 480,009.94 47,439.40
cursor authentications 635 0.18 0.02
data blocks consistent reads - undo records applied 16,012 4.43 0.44
db block changes 2,375,919 657.96 65.03
db block gets 2,508,078 694.56 68.64
db block gets direct 66,724 18.48 1.83
db block gets from cache 2,441,354 676.08 66.82
deferred (CURRENT) block cleanout applications 17,145 4.75 0.47
dirty buffers inspected 40 0.01 0.00
enqueue conversions 22,646,252 6,271.37 619.80
enqueue deadlocks 0 0.00 0.00
enqueue releases 22,843,174 6,325.91 625.19
enqueue requests 22,851,876 6,328.32 625.43
enqueue timeouts 8,713 2.41 0.24
enqueue waits 845 0.23 0.02
exchange deadlocks 8 0.00 0.00
execute count 12,734,673 3,526.58 348.53
failed probes on index block reclamation 81 0.02 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 15,130,270 4,189.99 414.10
free buffer requested 15,183,520 4,204.74 415.55
gc CPU used by this session 120,500 33.37 3.30
gc blocks lost 0 0.00 0.00
gc cr block build time 43 0.01 0.00
gc cr block flush time 3 0.00 0.00
gc cr block receive time 2,164 0.60 0.06
gc cr block send time 79 0.02 0.00
gc cr blocks received 40,091 11.10 1.10
gc cr blocks served 13,539 3.75 0.37
gc current block flush time 0 0.00 0.00
gc current block pin time 771 0.21 0.02
gc current block receive time 14,983 4.15 0.41
gc current block send time 211 0.06 0.01
gc current blocks received 238,282 65.99 6.52
gc current blocks served 31,492 8.72 0.86
gc local grants 7,509,611 2,079.62 205.53
gc remote grants 7,288,601 2,018.41 199.48
gcs messages sent 15,028,144 4,161.71 411.30
ges messages sent 284,021 78.65 7.77
global enqueue get time 7,174 1.99 0.20
global enqueue gets async 110,288 30.54 3.02
global enqueue gets sync 119,130 32.99 3.26
global enqueue releases 368,240 101.98 10.08
heap block compress 4,112 1.14 0.11
hot buffers moved to head of LRU 1,160,074 321.26 31.75
immediate (CR) block cleanout applications 93,588 25.92 2.56
immediate (CURRENT) block cleanout applications 22,954 6.36 0.63
index crx upgrade (found) 3 0.00 0.00
index crx upgrade (positioned) 55,753 15.44 1.53
index fast full scans (full) 864 0.24 0.02
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 161,032,189 44,594.26 4,407.25
index scans kdiixs1 270,493,518 74,907.12 7,403.07
java call heap collected bytes 0 0.00 0.00
java call heap collected count 0 0.00 0.00
java call heap gc count 0 0.00 0.00
java call heap live object count 0 0.00 0.00
java call heap live object count max 0 0.00 0.00
java call heap live size 0 0.00 0.00
java call heap live size max 0 0.00 0.00
java call heap object count 0 0.00 0.00
java call heap object count max 0 0.00 0.00
java call heap total size 0 0.00 0.00
java call heap total size max 0 0.00 0.00
java call heap used size 0 0.00 0.00
java call heap used size max 0 0.00 0.00
leaf node 90-10 splits 706 0.20 0.02
leaf node splits 1,120 0.31 0.03
lob reads 84,475 23.39 2.31
lob writes 244 0.07 0.01
lob writes unaligned 244 0.07 0.01
logons cumulative 342 0.09 0.01
messages received 192,665 53.35 5.27
messages sent 192,665 53.35 5.27
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 888,339,184 246,005.65 24,312.75
opened cursors cumulative 1,553,689 430.26 42.52
parse count (failures) 62 0.02 0.00
parse count (hard) 2,807 0.78 0.08
parse count (total) 1,515,351 419.64 41.47
parse time cpu 35,560 9.85 0.97
parse time elapsed 4,509,729 1,248.87 123.43
physical read IO requests 2,169,979 600.93 59.39
physical read bytes 1.3E+11 37,270,363.63 3,683,431.53
physical read total IO requests 2,238,110 619.79 61.25
physical read total bytes 1.4E+11 38,154,679.11 3,770,828.46
physical read total multi block requests 1,136,321 314.68 31.10
physical reads 16,428,859 4,549.60 449.64
physical reads cache 14,831,884 4,107.36 405.93
physical reads cache prefetch 12,941,485 3,583.85 354.19
physical reads direct 1,596,975 442.25 43.71
physical reads direct (lob) 7 0.00 0.00
physical reads direct temporary tablespace 1,596,958 442.24 43.71
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 88,186 24.42 2.41
physical write bytes 7,834,017,792 2,169,455.82 214,407.41
physical write total IO requests 157,886 43.72 4.32
physical write total bytes 10,886,795,264 3,014,854.19 297,958.16
physical write total multi block requests 73,884 20.46 2.02
physical writes 956,301 264.83 26.17
physical writes direct 817,021 226.26 22.36
physical writes direct (lob) 11 0.00 0.00
physical writes direct temporary tablespace 816,735 226.18 22.35
physical writes from cache 139,280 38.57 3.81
physical writes non checkpoint 928,761 257.20 25.42
pinned buffers inspected 8,033 2.22 0.22
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 64,994 18.00 1.78
process last non-idle time 3,862 1.07 0.11
queries parallelized 18 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 4,743,219 1,313.53 129.82
recursive cpu usage 1,648,654 456.56 45.12
redo blocks written 418,223 115.82 11.45
redo buffer allocation retries 2 0.00 0.00
redo entries 1,260,223 348.99 34.49
redo log space requests 2 0.00 0.00
redo log space wait time 3 0.00 0.00
redo ordering marks 22,746 6.30 0.62
redo size 409,151,632 113,305.38 11,197.98
redo subscn max counts 3,231 0.89 0.09
redo synch time 2,687 0.74 0.07
redo synch writes 26,987 7.47 0.74
redo wastage 12,179,984 3,372.97 333.35
redo write broadcast ack time 549 0.15 0.02
redo write time 1,519 0.42 0.04
redo writer latching time 7 0.00 0.00
redo writes 30,786 8.53 0.84
rollback changes - undo records applied 193,597 53.61 5.30
rollbacks only - consistent read gets 3,980 1.10 0.11
root node splits 0 0.00 0.00
rows fetched via callback 129,705,896 35,919.14 3,549.89
session connect time 0 0.00 0.00
session cursor cache hits 2,460,059 681.26 67.33
session logical reads 1,735,848,311 480,704.32 47,508.03
shared hash latch upgrades - no wait 13,771,195 3,813.62 376.90
shared hash latch upgrades - wait 1,320,405 365.66 36.14
sorts (disk) 15 0.00 0.00
sorts (memory) 180,833 50.08 4.95
sorts (rows) 535,241,159 148,223.05 14,648.89
sql area evicted 2,126 0.59 0.06
sql area purged 341 0.09 0.01
summed dirty queue length 36 0.01 0.00
switch current to new buffer 4,194 1.16 0.11
table fetch by rowid 496,755,988 137,565.45 13,595.60
table fetch continued row 3,692,075 1,022.44 101.05
table scan blocks gotten 105,630,095 29,251.89 2,890.97
table scan rows gotten 6,491,150,198 1,797,578.71 177,654.78
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 10 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 179,031 49.58 4.90
total number of times SMON posted 0 0.00 0.00
transaction lock background get time 0 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 2,825 0.78 0.08
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 157,625,168 43,650.76 4,314.01
user I/O wait time 773,547 214.22 21.17
user calls 26,637,046 7,376.53 729.02
user commits 25,899 7.17 0.71
user rollbacks 10,639 2.95 0.29
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 202 0.06 0.01
workarea executions - optimal 113,441 31.41 3.10
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

StatisticBegin ValueEnd Value
session pga memory max 9.6E+12 9.6E+12
session cursor cache count 18,100,776 18,108,005
session uga memory 2.9E+14 2.9E+14
opened cursors current 38,430 37,480
workarea memory allocated 1,606,373 943,641
logons current 1,872 1,815
session uga memory max 5.3E+12 5.3E+12
session pga memory 2.7E+12 2.7E+12

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 1.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
EPSA 1,352,359 375 2.34 9.15 783 0 5,010,330 2.19
EPMIDX 371,333 103 2.77 1.40 29,853 8 192,087 1.84
EPMTMP 172,978 48 25.46 8.22 21,519 6 0 0.00
EPMRANGE1 129,625 36 12.56 6.15 7,103 2 32,356 5.41
EPMDAT1 104,700 29 11.55 10.45 4,680 1 3,728 6.49
TEMP 34,145 9 0.81 7.00 8,937 2 0 0.00
UNDOTBS1 0 0 0.00 0.00 10,387 3 112 0.09
SYSAUX 2,755 1 5.31 2.84 2,586 1 659 3.10
SYSTEM 2,867 1 5.01 1.00 1,713 0 90 2.67
EPCDAT1 2,392 1 3.44 2.57 831 0 3 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
EPCDAT1 /dev/vgepm1/rlvepc_data1 624 0 2.29 1.78 31 0 0 0.00
EPCDAT1 /dev/vgepm1/rlvepc_data2 64 0 6.09 9.44 106 0 0 0.00
EPCDAT1 /dev/vgepm1/rlvepc_data3 120 0 4.33 4.16 103 0 0 0.00
EPCDAT1 /dev/vgepm1/rlvepc_data4 52 0 8.27 8.29 25 0 2 0.00
EPCDAT1 /dev/vgepm1/rlvepc_data5 109 0 6.88 5.19 81 0 0 0.00
EPCDAT1 /dev/vgepm1/rlvepc_data6 453 0 3.31 1.85 144 0 1 0.00
EPCDAT1 /dev/vgepm1/rlvepc_data7 321 0 4.33 2.83 240 0 0 0.00
EPCDAT1 /dev/vgepm1/rlvepc_data8 649 0 2.79 1.84 101 0 0 0.00
EPMDAT1 /dev/vgepm1/rlvepm_data1_001 3,002 1 14.21 5.11 293 0 74 4.32
EPMDAT1 /dev/vgepm1/rlvepm_data1_002 1,830 1 13.88 7.74 26 0 25 5.20
EPMDAT1 /dev/vgepm1/rlvepm_data1_003 1,797 0 20.04 7.89 22 0 25 8.00
EPMDAT1 /dev/vgepm1/rlvepm_data1_004 2,011 1 13.65 7.10 16 0 13 6.92
EPMDAT1 /dev/vgepm1/rlvepm_data1_005 1,684 0 19.61 8.13 33 0 25 6.80
EPMDAT1 /dev/vgepm1/rlvepm_data1_006 2,046 1 12.89 6.86 51 0 27 6.30
EPMDAT1 /dev/vgepm1/rlvepm_data1_007 2,572 1 19.62 5.45 24 0 22 7.27
EPMDAT1 /dev/vgepm1/rlvepm_data1_008 1,710 0 19.49 7.55 33 0 26 6.54
EPMDAT1 /dev/vgepm1/rlvepm_data1_009 1,584 0 12.95 8.23 44 0 28 6.43
EPMDAT1 /dev/vgepm1/rlvepm_data1_010 1,765 0 13.64 7.50 55 0 14 4.29
EPMDAT1 /dev/vgepm1/rlvepm_data1_011 1,911 1 18.41 7.00 81 0 99 6.87
EPMDAT1 /dev/vgepm1/rlvepm_data1_012 1,620 0 21.59 8.22 40 0 61 7.87
EPMDAT1 /dev/vgepm1/rlvepm_data1_013 1,299 0 14.32 10.30 47 0 35 6.29
EPMDAT1 /dev/vgepm1/rlvepm_data1_014 777 0 6.82 14.41 42 0 44 7.05
EPMDAT1 /dev/vgepm1/rlvepm_data1_015 931 0 11.42 12.10 38 0 51 6.67
EPMDAT1 /dev/vgepm1/rlvepm_data1_016 876 0 8.98 12.90 29 0 120 6.42
EPMDAT1 /dev/vgepm1/rlvepm_data1_017 954 0 6.07 11.98 72 0 163 5.89
EPMDAT1 /dev/vgepm1/rlvepm_data1_018 1,015 0 9.90 11.08 38 0 192 5.99
EPMDAT1 /dev/vgepm1/rlvepm_data1_019 1,121 0 11.15 10.13 60 0 113 6.46
EPMDAT1 /dev/vgepm1/rlvepm_data1_020 809 0 11.16 13.80 46 0 64 7.50
EPMDAT1 /dev/vgepm1/rlvepm_data1_021 731 0 8.26 15.29 71 0 67 6.72
EPMDAT1 /dev/vgepm1/rlvepm_data1_022 871 0 8.93 12.74 64 0 88 7.05
EPMDAT1 /dev/vgepm1/rlvepm_data1_023 1,142 0 15.35 9.85 59 0 106 7.17
EPMDAT1 /dev/vgepm1/rlvepm_data1_024 1,235 0 13.12 9.23 49 0 143 6.22
EPMDAT1 /dev/vgepm1/rlvepm_data1_025 1,688 0 4.49 7.06 41 0 176 6.02
EPMDAT1 /dev/vgepm1/rlvepm_data1_026 3,147 1 6.69 3.93 27 0 159 5.66
EPMDAT1 /dev/vgepm1/rlvepm_data1_027 1,716 0 8.78 6.94 23 0 161 6.77
EPMDAT1 /dev/vgepm1/rlvepm_data1_028 855 0 7.86 12.20 23 0 91 6.92
EPMDAT1 /dev/vgepm1/rlvepm_data1_029 1,672 0 6.19 7.19 41 0 69 6.67
EPMDAT1 /dev/vgepm1/rlvepm_data1_030 1,159 0 6.25 10.01 25 0 59 6.61
EPMDAT1 /dev/vgepm1/rlvepm_data1_031 856 0 10.35 21.20 10 0 52 7.12
EPMDAT1 /dev/vgepm1/rlvepm_data1_032 998 0 11.56 18.20 3 0 77 7.40
EPMDAT1 /dev/vgepm1/rlvepm_data1_033 873 0 8.51 20.87 13 0 68 6.62
EPMDAT1 /dev/vgepm1/rlvepm_data1_034 899 0 7.72 20.34 27 0 57 6.49
EPMDAT1 /dev/vgepm1/rlvepm_data1_035 818 0 6.59 22.29 25 0 41 7.56
EPMDAT1 /dev/vgepm1/rlvepm_data1_036 1,831 1 11.45 10.24 29 0 17 7.65
EPMDAT1 /dev/vgepm1/rlvepm_data1_037 1,365 0 8.29 13.62 22 0 28 7.50
EPMDAT1 /dev/vgepm1/rlvepm_data1_038 1,118 0 14.08 16.36 21 0 20 5.50
EPMDAT1 /dev/vgepm1/rlvepm_data1_039 992 0 10.99 18.46 15 0 15 8.00
EPMDAT1 /dev/vgepm1/rlvepm_data1_040 1,041 0 10.37 17.70 21 0 15 6.67
EPMDAT1 /dev/vgepm1/rlvepm_data1_041 1,015 0 12.37 18.07 25 0 16 8.13
EPMDAT1 /dev/vgepm1/rlvepm_data1_042 858 0 5.64 21.44 35 0 11 6.36
EPMDAT1 /dev/vgepm1/rlvepm_data1_043 803 0 5.84 21.61 30 0 17 5.29
EPMDAT1 /dev/vgepm1/rlvepm_data1_044 995 0 13.30 16.83 22 0 17 7.65
EPMDAT1 /dev/vgepm1/rlvepm_data1_045 779 0 6.75 20.94 71 0 13 5.38
EPMDAT1 /dev/vgepm1/rlvepm_data1_046 608 0 6.58 26.60 14 0 51 6.86
EPMDAT1 /dev/vgepm1/rlvepm_data1_047 1,016 0 15.83 15.95 59 0 43 6.51
EPMDAT1 /dev/vgepm1/rlvepm_data1_048 981 0 10.74 16.67 65 0 36 7.22
EPMDAT1 /dev/vgepm1/rlvepm_data1_049 638 0 6.19 25.39 143 0 19 8.42
EPMDAT1 /dev/vgepm1/rlvepm_data1_050 638 0 6.46 25.39 191 0 156 1.22
EPMDAT1 /dev/vgepm1/rlvepm_data1_051 1,419 0 9.68 10.94 23 0 18 6.67
EPMDAT1 /dev/vgepm1/rlvepm_data1_052 2,038 1 8.14 8.33 29 0 18 6.67
EPMDAT1 /dev/vgepm1/rlvepm_data1_053 1,651 0 11.41 10.52 29 0 18 7.22
EPMDAT1 /dev/vgepm1/rlvepm_data1_054 2,717 1 11.91 6.58 25 0 22 7.73
EPMDAT1 /dev/vgepm1/rlvepm_data1_055 1,182 0 12.74 14.45 29 0 13 6.15
EPMDAT1 /dev/vgepm1/rlvepm_data1_056 956 0 8.57 17.83 6 0 21 7.62
EPMDAT1 /dev/vgepm1/rlvepm_data1_057 1,027 0 10.44 10.99 2 0 12 7.50
EPMDAT1 /dev/vgepm1/rlvepm_data1_058 1,629 0 8.08 6.49 36 0 26 6.92
EPMDAT1 /dev/vgepm1/rlvepm_data1_059 1,185 0 9.60 10.01 18 0 20 7.00
EPMDAT1 /dev/vgepm1/rlvepm_data1_060 623 0 15.30 16.75 11 0 22 8.18
EPMDAT1 /dev/vgepm1/rlvepm_data1_061 866 0 13.83 22.19 2 0 35 8.86
EPMDAT1 /dev/vgepm1/rlvepm_data1_062 681 0 12.72 17.67 24 0 34 7.06
EPMDAT1 /dev/vgepm1/rlvepm_data1_063 938 0 10.60 13.61 60 0 75 8.13
EPMDAT1 /dev/vgepm1/rlvepm_data1_064 853 0 9.31 17.08 24 0 46 7.39
EPMDAT1 /dev/vgepm1/rlvepm_data1_065 909 0 12.99 15.75 13 0 55 7.27
EPMDAT1 /dev/vgepm1/rlvepm_data1_066 1,988 1 5.62 7.72 140 0 23 7.39
EPMDAT1 /dev/vgepm1/rlvepm_data1_067 2,528 1 5.03 5.92 153 0 14 8.57
EPMDAT1 /dev/vgepm1/rlvepm_data1_068 1,518 0 7.84 9.65 131 0 14 7.14
EPMDAT1 /dev/vgepm1/rlvepm_data1_069 2,069 1 12.36 7.07 189 0 19 5.79
EPMDAT1 /dev/vgepm1/rlvepm_data1_070 1,926 1 12.79 7.34 188 0 16 8.75
EPMDAT1 /dev/vgepm1/rlvepm_data1_071 1,671 0 7.82 9.10 204 0 12 7.50
EPMDAT1 /dev/vgepm1/rlvepm_data1_072 2,800 1 11.59 5.62 203 0 17 8.82
EPMDAT1 /dev/vgepm1/rlvepm_data1_073 2,183 1 13.80 7.03 292 0 19 4.74
EPMDAT1 /dev/vgepm1/rlvepm_data1_074 2,183 1 11.77 7.17 198 0 24 7.92
EPMDAT1 /dev/vgepm1/rlvepm_data1_075 2,508 1 19.06 5.79 297 0 26 10.38
EPMIDX /dev/vgepm2/rlvepm_data2_001 261 0 2.61 1.18 0 0 63 1.75
EPMIDX /dev/vgepm2/rlvepm_data2_002 264 0 3.07 1.16 0 0 79 1.39
EPMIDX /dev/vgepm2/rlvepm_data2_003 389 0 3.21 1.12 0 0 74 1.76
EPMIDX /dev/vgepm2/rlvepm_data2_004 481 0 2.77 1.12 0 0 48 1.88
EPMIDX /dev/vgepm2/rlvepm_data2_005 714 0 3.00 1.08 0 0 63 1.59
EPMIDX /dev/vgepm2/rlvepm_data2_006 814 0 2.67 1.05 0 0 77 1.56
EPMIDX /dev/vgepm2/rlvepm_data2_007 323 0 2.32 1.12 5 0 70 2.14
EPMIDX /dev/vgepm2/rlvepm_data2_008 309 0 3.01 1.18 5 0 57 2.11
EPMIDX /dev/vgepm2/rlvepm_data2_009 379 0 3.06 1.13 9 0 66 2.27
EPMIDX /dev/vgepm2/rlvepm_data2_010 348 0 4.02 1.17 5 0 53 1.51
EPMIDX /dev/vgepm2/rlvepm_data2_011 285 0 2.11 1.21 21 0 54 1.30
EPMIDX /dev/vgepm2/rlvepm_data2_012 273 0 2.34 1.23 10 0 53 2.08
EPMIDX /dev/vgepm2/rlvepm_data2_013 435 0 3.52 1.10 0 0 70 1.71
EPMIDX /dev/vgepm2/rlvepm_data2_014 538 0 2.73 1.07 3 0 98 1.94
EPMIDX /dev/vgepm2/rlvepm_data2_015 267 0 3.60 1.22 2 0 54 1.85
EPMIDX /dev/vgepm2/rlvepm_data2_016 152 0 3.16 1.39 2 0 71 2.54
EPMIDX /dev/vgepm2/rlvepm_data2_017 213 0 4.46 1.31 4 0 53 0.94
EPMIDX /dev/vgepm2/rlvepm_data2_018 161 0 3.73 1.29 3 0 84 2.50
EPMIDX /dev/vgepm2/rlvepm_data2_019 160 0 3.25 1.23 4 0 85 1.65
EPMIDX /dev/vgepm2/rlvepm_data2_020 131 0 3.51 1.37 4 0 74 2.43
EPMIDX /dev/vgepm2/rlvepm_data2_021 147 0 3.13 1.48 1 0 46 2.61
EPMIDX /dev/vgepm2/rlvepm_data2_022 180 0 3.61 1.34 0 0 62 2.90
EPMIDX /dev/vgepm2/rlvepm_data2_023 232 0 3.97 1.24 10 0 72 1.94
EPMIDX /dev/vgepm2/rlvepm_data2_024 671 0 2.40 1.69 1 0 471 2.04
EPMIDX /dev/vgepm2/rlvepm_data2_025 829 0 2.40 1.52 0 0 605 1.72
EPMIDX /dev/vgepm2/rlvepm_data2_026 763 0 2.33 1.57 1 0 561 1.52
EPMIDX /dev/vgepm2/rlvepm_data2_027 908 0 2.26 1.48 1 0 627 1.66
EPMIDX /dev/vgepm2/rlvepm_data2_028 952 0 2.69 1.53 2 0 608 1.78
EPMIDX /dev/vgepm2/rlvepm_data2_029 1,122 0 2.91 1.48 2 0 522 1.76
EPMIDX /dev/vgepm2/rlvepm_data2_030 1,251 0 2.72 1.44 4 0 604 1.80
EPMIDX /dev/vgepm2/rlvepm_data2_031 978 0 2.55 1.66 7 0 655 1.80
EPMIDX /dev/vgepm2/rlvepm_data2_032 1,381 0 2.40 1.41 39 0 755 1.72
EPMIDX /dev/vgepm2/rlvepm_data2_033 780 0 2.29 1.72 82 0 490 1.84
EPMIDX /dev/vgepm2/rlvepm_data2_034 803 0 2.50 1.15 18 0 380 1.53
EPMIDX /dev/vgepm2/rlvepm_data2_035 903 0 2.61 1.13 15 0 391 1.51
EPMIDX /dev/vgepm2/rlvepm_data2_036 883 0 3.11 1.13 47 0 401 1.52
EPMIDX /dev/vgepm2/rlvepm_data2_037 1,883 1 3.50 1.06 24 0 401 1.80
EPMIDX /dev/vgepm2/rlvepm_data2_038 1,062 0 4.15 1.11 6 0 419 1.58
EPMIDX /dev/vgepm2/rlvepm_data2_039 1,530 0 4.07 1.07 3 0 394 1.62
EPMIDX /dev/vgepm2/rlvepm_data2_040 1,111 0 3.70 1.10 26 0 400 1.93
EPMIDX /dev/vgepm2/rlvepm_data2_041 664 0 2.20 1.18 50 0 487 1.46
EPMIDX /dev/vgepm2/rlvepm_data2_042 587 0 2.69 1.18 24 0 371 1.59
EPMIDX /dev/vgepm2/rlvepm_data2_043 810 0 2.21 1.14 50 0 586 1.45
EPMIDX /dev/vgepm2/rlvepm_data2_044 902 0 1.97 1.13 52 0 572 1.56
EPMIDX /dev/vgepm2/rlvepm_data2_045 900 0 2.17 1.13 40 0 596 1.48
EPMIDX /dev/vgepm2/rlvepm_data2_046 933 0 2.60 1.13 60 0 590 1.76
EPMIDX /dev/vgepm2/rlvepm_data2_047 851 0 2.50 1.14 53 0 477 1.43
EPMIDX /dev/vgepm2/rlvepm_data2_048 620 0 2.50 1.17 48 0 359 1.50
EPMIDX /dev/vgepm2/rlvepm_data2_049 653 0 2.60 1.19 35 0 342 1.52
EPMIDX /dev/vgepm2/rlvepm_data2_050 825 0 2.80 1.16 33 0 457 2.04
EPMIDX /dev/vgepm2/rlvepm_data2_051 633 0 2.76 1.20 31 0 347 2.13
EPMIDX /dev/vgepm2/rlvepm_data2_052 667 0 2.94 1.37 44 0 362 1.96
EPMIDX /dev/vgepm2/rlvepm_data2_053 903 0 2.79 1.26 58 0 379 1.64
EPMIDX /dev/vgepm2/rlvepm_data2_054 1,189 0 2.70 1.19 51 0 708 1.71
EPMIDX /dev/vgepm2/rlvepm_data2_055 1,389 0 2.63 1.17 72 0 868 1.60
EPMIDX /dev/vgepm2/rlvepm_data2_056 1,609 0 2.30 1.15 79 0 996 1.70
EPMIDX /dev/vgepm2/rlvepm_data2_057 2,017 1 2.35 1.12 151 0 1,284 1.77
EPMIDX /dev/vgepm2/rlvepm_data2_058 2,030 1 2.44 1.13 122 0 1,308 1.80
EPMIDX /dev/vgepm2/rlvepm_data2_059 2,211 1 2.00 1.12 166 0 1,484 1.84
EPMIDX /dev/vgepm2/rlvepm_data2_060 2,528 1 1.95 1.10 216 0 1,730 1.94
EPMIDX /dev/vgepm2/rlvepm_data2_061 2,745 1 1.96 1.10 242 0 1,988 1.88
EPMIDX /dev/vgepm2/rlvepm_data2_062 2,832 1 1.98 1.10 242 0 2,039 1.88
EPMIDX /dev/vgepm2/rlvepm_data2_063 3,357 1 2.12 1.10 254 0 2,227 1.61
EPMIDX /dev/vgepm2/rlvepm_data2_064 3,244 1 2.07 1.08 327 0 2,267 1.75
EPMIDX /dev/vgepm2/rlvepm_data2_065 3,551 1 2.33 1.13 424 0 2,506 1.94
EPMIDX /dev/vgepm2/rlvepm_data2_066 3,717 1 2.36 1.12 320 0 2,542 1.88
EPMIDX /dev/vgepm2/rlvepm_data2_067 4,967 1 2.17 1.09 364 0 2,723 1.71
EPMIDX /dev/vgepm2/rlvepm_data2_068 5,781 2 2.29 1.11 427 0 3,015 1.92
EPMIDX /dev/vgepm2/rlvepm_data2_069 6,011 2 2.21 1.12 424 0 3,139 1.80
EPMIDX /dev/vgepm2/rlvepm_data2_070 6,150 2 2.17 1.12 463 0 3,273 1.94
EPMIDX /dev/vgepm2/rlvepm_data2_071 6,444 2 2.23 1.11 491 0 3,567 1.67
EPMIDX /dev/vgepm2/rlvepm_data2_072 6,874 2 2.62 1.11 439 0 3,746 1.78
EPMIDX /dev/vgepm2/rlvepm_data2_073 6,243 2 2.20 1.14 446 0 3,628 1.86
EPMIDX /dev/vgepm2/rlvepm_data2_074 5,528 2 2.32 1.19 478 0 3,706 1.73
EPMIDX /dev/vgepm2/rlvepm_data2_075 6,077 2 2.59 1.16 561 0 3,922 1.84
EPMIDX /dev/vgepm2/rlvepm_data2_076 6,398 2 2.30 1.17 614 0 4,070 1.83
EPMIDX /dev/vgepm2/rlvepm_data2_077 6,498 2 2.35 1.18 660 0 4,077 1.79
EPMIDX /dev/vgepm2/rlvepm_data2_078 6,348 2 2.44 1.17 556 0 4,150 1.79
EPMIDX /dev/vgepm2/rlvepm_data2_079 6,384 2 2.35 1.17 600 0 3,827 1.74
EPMIDX /dev/vgepm2/rlvepm_data2_080 6,395 2 2.43 1.17 552 0 3,792 1.67
EPMIDX /dev/vgepm2/rlvepm_data2_081 6,021 2 2.33 1.21 574 0 3,804 1.81
EPMIDX /dev/vgepm2/rlvepm_data2_082 5,868 2 2.41 1.21 776 0 3,684 1.71
EPMIDX /dev/vgepm2/rlvepm_data2_083 5,944 2 2.68 1.21 730 0 3,758 1.69
EPMIDX /dev/vgepm2/rlvepm_data2_084 5,821 2 2.57 1.26 608 0 3,430 1.73
EPMIDX /dev/vgepm2/rlvepm_data2_085 5,199 1 2.79 1.31 539 0 3,123 1.79
EPMIDX /dev/vgepm2/rlvepm_data2_086 5,245 1 2.85 1.34 507 0 3,168 1.89
EPMIDX /dev/vgepm2/rlvepm_data2_087 4,975 1 2.73 1.36 450 0 2,916 1.70
EPMIDX /dev/vgepm2/rlvepm_data2_088 5,105 1 2.58 1.35 418 0 2,861 1.76
EPMIDX /dev/vgepm2/rlvepm_data2_089 5,927 2 2.65 1.31 455 0 2,834 1.68
EPMIDX /dev/vgepm2/rlvepm_data2_090 5,778 2 2.66 1.32 391 0 2,753 1.96
EPMIDX /dev/vgepm2/rlvepm_data2_091 5,235 1 2.71 1.36 322 0 2,375 1.83
EPMIDX /dev/vgepm2/rlvepm_data2_092 5,366 1 2.18 1.34 351 0 2,491 1.74
EPMIDX /dev/vgepm2/rlvepm_data2_093 4,757 1 2.44 1.38 401 0 2,650 1.83
EPMIDX /dev/vgepm2/rlvepm_data2_094 4,770 1 2.38 1.40 377 0 2,543 1.83
EPMIDX /dev/vgepm2/rlvepm_data2_095 4,938 1 3.76 1.38 427 0 2,472 1.88
EPMIDX /dev/vgepm2/rlvepm_data2_096 4,844 1 3.05 1.39 397 0 2,243 1.89
EPMIDX /dev/vgepm2/rlvepm_data2_097 4,905 1 2.91 1.38 312 0 2,120 1.81
EPMIDX /dev/vgepm2/rlvepm_data2_098 4,907 1 3.01 1.42 340 0 1,975 1.81
EPMIDX /dev/vgepm2/rlvepm_data2_099 4,133 1 2.54 1.51 358 0 2,100 2.04
EPMIDX /dev/vgepm2/rlvepm_data2_100 3,656 1 2.96 1.56 327 0 2,103 1.80
EPMIDX /dev/vgepm2/rlvepm_data2_101 3,855 1 2.76 1.51 317 0 2,259 1.89
EPMIDX /dev/vgepm2/rlvepm_data2_102 4,016 1 2.99 1.49 313 0 2,313 1.88
EPMIDX /dev/vgepm2/rlvepm_data2_103 3,897 1 2.98 1.49 369 0 2,362 1.91
EPMIDX /dev/vgepm2/rlvepm_data2_104 3,637 1 2.64 1.53 372 0 2,364 1.81
EPMIDX /dev/vgepm2/rlvepm_data2_105 3,769 1 2.96 1.47 324 0 2,364 1.84
EPMIDX /dev/vgepm2/rlvepm_data2_106 3,624 1 2.70 1.49 308 0 2,299 1.84
EPMIDX /dev/vgepm2/rlvepm_data2_107 3,303 1 2.51 1.53 304 0 2,116 1.95
EPMIDX /dev/vgepm2/rlvepm_data2_108 2,923 1 3.11 1.65 283 0 1,884 1.92
EPMIDX /dev/vgepm2/rlvepm_data2_109 2,875 1 2.54 1.64 219 0 1,751 1.80
EPMIDX /dev/vgepm2/rlvepm_data2_110 3,750 1 2.93 1.44 260 0 1,794 1.82
EPMIDX /dev/vgepm2/rlvepm_data2_111 3,649 1 2.65 1.43 227 0 1,759 1.96
EPMIDX /dev/vgepm2/rlvepm_data2_112 3,441 1 3.23 1.47 205 0 1,516 1.84
EPMIDX /dev/vgepm2/rlvepm_data2_113 3,274 1 2.66 1.49 190 0 1,346 2.02
EPMIDX /dev/vgepm2/rlvepm_data2_114 2,428 1 2.41 1.61 178 0 1,273 1.85
EPMIDX /dev/vgepm2/rlvepm_data2_115 2,095 1 3.61 1.67 163 0 1,274 1.95
EPMIDX /dev/vgepm2/rlvepm_data2_116 1,879 1 3.25 1.74 150 0 1,092 2.32
EPMIDX /dev/vgepm2/rlvepm_data2_117 1,749 0 4.52 1.81 148 0 1,031 2.53
EPMIDX /dev/vgepm2/rlvepm_data2_118 1,789 0 4.19 1.70 213 0 900 2.43
EPMIDX /dev/vgepm2/rlvepm_data2_119 1,540 0 4.12 1.84 103 0 757 2.10
EPMIDX /dev/vgepm2/rlvepm_data2_120 1,520 0 4.66 1.88 113 0 709 2.64
EPMIDX /dev/vgepm2/rlvepm_data2_121 1,699 0 3.08 1.81 95 0 697 2.12
EPMIDX /dev/vgepm2/rlvepm_data2_122 1,655 0 3.43 1.83 107 0 694 2.18
EPMIDX /dev/vgepm2/rlvepm_data2_123 1,472 0 2.90 1.86 116 0 592 1.98
EPMIDX /dev/vgepm2/rlvepm_data2_124 1,392 0 3.56 2.02 105 0 571 2.24
EPMIDX /dev/vgepm2/rlvepm_data2_125 1,294 0 3.02 2.04 106 0 495 2.34
EPMIDX /dev/vgepm2/rlvepm_data2_126 960 0 3.16 2.17 67 0 445 2.11
EPMIDX /dev/vgepm2/rlvepm_data2_127 1,495 0 2.86 1.88 73 0 454 2.11
EPMIDX /dev/vgepm2/rlvepm_data2_128 1,870 1 2.70 1.54 82 0 321 2.55
EPMIDX /dev/vgepm2/rlvepm_data2_129 1,766 0 2.59 1.67 103 0 335 2.54
EPMIDX /dev/vgepm2/rlvepm_data2_130 1,758 0 2.47 1.57 102 0 337 2.79
EPMIDX /dev/vgepm2/rlvepm_data2_131 774 0 3.26 2.36 123 0 264 2.80
EPMIDX /dev/vgepm2/rlvepm_data2_132 1,170 0 2.97 2.14 139 0 225 2.80
EPMIDX /dev/vgepm2/rlvepm_data2_133 847 0 3.72 2.53 135 0 133 3.08
EPMIDX /dev/vgepm2/rlvepm_data2_134 821 0 3.57 2.66 138 0 94 3.83
EPMIDX /dev/vgepm2/rlvepm_data2_135 890 0 3.79 2.80 153 0 80 3.75
EPMIDX /dev/vgepm2/rlvepm_data2_136 993 0 4.02 2.64 156 0 126 2.78
EPMIDX /dev/vgepm2/rlvepm_data2_137 833 0 3.65 2.94 179 0 142 3.31
EPMIDX /dev/vgepm2/rlvepm_data2_138 1,071 0 4.38 2.42 201 0 392 1.99
EPMIDX /dev/vgepm2/rlvepm_data2_139 1,268 0 3.95 2.16 197 0 344 2.03
EPMIDX /dev/vgepm2/rlvepm_data2_140 1,217 0 5.53 2.08 165 0 438 2.05
EPMIDX /dev/vgepm2/rlvepm_data2_141 1,080 0 2.91 2.22 119 0 442 1.86
EPMIDX /dev/vgepm2/rlvepm_data2_142 1,152 0 3.27 2.05 134 0 413 1.86
EPMIDX /dev/vgepm2/rlvepm_data2_143 1,111 0 3.96 1.94 157 0 423 1.99
EPMIDX /dev/vgepm2/rlvepm_data2_144 1,365 0 5.03 1.68 147 0 433 2.17
EPMIDX /dev/vgepm2/rlvepm_data2_145 896 0 2.75 2.03 142 0 402 1.59
EPMIDX /dev/vgepm2/rlvepm_data2_146 839 0 2.73 1.56 81 0 377 1.78
EPMIDX /dev/vgepm2/rlvepm_data2_147 1,234 0 2.80 2.06 147 0 429 1.72
EPMIDX /dev/vgepm2/rlvepm_data2_148 1,152 0 2.62 2.02 96 0 375 1.60
EPMIDX /dev/vgepm2/rlvepm_data2_149 1,282 0 2.57 2.03 168 0 536 1.77
EPMIDX /dev/vgepm2/rlvepm_data2_150 1,213 0 2.77 2.21 198 0 565 1.70
EPMIDX /dev/vgepm2/rlvepm_data2_151 1,919 1 3.37 1.70 206 0 510 1.82
EPMIDX /dev/vgepm2/rlvepm_data2_152 1,409 0 3.29 1.79 176 0 403 2.08
EPMIDX /dev/vgepm2/rlvepm_data2_153 1,148 0 16.31 1.98 36 0 334 2.31
EPMIDX /dev/vgepm2/rlvepm_data2_154 649 0 6.89 2.26 38 0 306 2.78
EPMIDX /dev/vgepm2/rlvepm_data2_155 401 0 3.79 2.52 23 0 229 2.27
EPMIDX /dev/vgepm2/rlvepm_data2_156 492 0 5.22 3.50 53 0 167 2.57
EPMIDX /dev/vgepm2/rlvepm_data2_157 784 0 2.90 2.36 83 0 124 2.26
EPMIDX /dev/vgepm2/rlvepm_data2_158 818 0 3.23 2.09 54 0 66 2.27
EPMIDX /dev/vgepm2/rlvepm_data2_159 680 0 3.09 2.20 56 0 59 2.03
EPMIDX /dev/vgepm2/rlvepm_data2_160 891 0 3.06 1.93 60 0 74 1.49
EPMIDX /dev/vgepm2/rlvepm_data2_161 1,375 0 2.75 1.96 73 0 78 2.56
EPMIDX /dev/vgepm2/rlvepm_data2_162 1,043 0 3.05 2.22 54 0 51 3.73
EPMIDX /dev/vgepm2/rlvepm_data2_163 1,177 0 2.72 1.92 91 0 87 2.30
EPMIDX /dev/vgepm2/rlvepm_data2_164 1,167 0 3.71 2.09 130 0 75 2.67
EPMIDX /dev/vgepm2/rlvepm_data2_165 1,066 0 3.47 2.23 100 0 77 3.12
EPMIDX /dev/vgepm2/rlvepm_data2_166 844 0 3.03 2.41 108 0 66 2.73
EPMIDX /dev/vgepm2/rlvepm_data2_167 345 0 3.10 2.48 38 0 51 1.96
EPMIDX /dev/vgepm2/rlvepm_data2_168 348 0 3.94 2.41 39 0 51 1.76
EPMIDX /dev/vgepm2/rlvepm_data2_169 306 0 2.91 1.19 0 0 55 1.09
EPMIDX /dev/vgepm2/rlvepm_data2_170 293 0 2.94 1.18 0 0 72 1.67
EPMIDX /dev/vgepm2/rlvepm_data2_171 340 0 3.50 1.16 0 0 63 1.11
EPMIDX /dev/vgepm2/rlvepm_data2_172 261 0 2.61 1.22 0 0 60 1.00
EPMIDX /dev/vgepm2/rlvepm_data2_173 298 0 3.02 1.16 0 0 65 1.23
EPMIDX /dev/vgepm2/rlvepm_data2_174 304 0 3.49 1.18 0 0 58 2.07
EPMIDX /dev/vgepm2/rlvepm_data2_175 268 0 2.99 1.25 0 0 49 2.04
EPMRANGE1 /dev/vgepm3/rlvepm_data3_001 1,029 0 18.05 4.92 6 0 320 4.22
EPMRANGE1 /dev/vgepm3/rlvepm_data3_002 1,981 1 16.86 3.51 67 0 363 7.80
EPMRANGE1 /dev/vgepm3/rlvepm_data3_003 1,994 1 19.67 3.30 141 0 444 6.96
EPMRANGE1 /dev/vgepm3/rlvepm_data3_004 1,988 1 23.90 2.97 231 0 364 9.73
EPMRANGE1 /dev/vgepm3/rlvepm_data3_005 1,289 0 19.42 3.83 115 0 433 5.94
EPMRANGE1 /dev/vgepm3/rlvepm_data3_006 1,310 0 14.66 3.89 85 0 392 5.46
EPMRANGE1 /dev/vgepm3/rlvepm_data3_007 1,685 0 24.85 2.53 33 0 396 8.36
EPMRANGE1 /dev/vgepm3/rlvepm_data3_008 2,122 1 22.66 2.22 54 0 421 9.93
EPMRANGE1 /dev/vgepm3/rlvepm_data3_009 1,575 0 19.84 4.13 105 0 698 5.76
EPMRANGE1 /dev/vgepm3/rlvepm_data3_010 1,775 0 20.04 3.57 201 0 742 5.78
EPMRANGE1 /dev/vgepm3/rlvepm_data3_011 2,221 1 22.35 2.90 100 0 840 5.68
EPMRANGE1 /dev/vgepm3/rlvepm_data3_012 1,116 0 14.71 5.92 43 0 822 3.35
EPMRANGE1 /dev/vgepm3/rlvepm_data3_013 951 0 11.69 6.93 155 0 735 3.24
EPMRANGE1 /dev/vgepm3/rlvepm_data3_014 1,072 0 11.07 6.18 99 0 778 3.20
EPMRANGE1 /dev/vgepm3/rlvepm_data3_015 2,266 1 18.74 4.57 90 0 907 5.20
EPMRANGE1 /dev/vgepm3/rlvepm_data3_016 2,159 1 19.41 4.10 31 0 807 5.25
EPMRANGE1 /dev/vgepm3/rlvepm_data3_017 1,782 0 16.98 4.79 86 0 786 5.19
EPMRANGE1 /dev/vgepm3/rlvepm_data3_018 1,913 1 12.10 4.35 134 0 609 5.85
EPMRANGE1 /dev/vgepm3/rlvepm_data3_019 2,190 1 14.00 3.79 49 0 562 7.53
EPMRANGE1 /dev/vgepm3/rlvepm_data3_020 1,988 1 14.38 3.98 66 0 502 7.67
EPMRANGE1 /dev/vgepm3/rlvepm_data3_021 1,342 0 12.92 5.45 100 0 745 4.31
EPMRANGE1 /dev/vgepm3/rlvepm_data3_022 1,595 0 11.24 4.99 65 0 956 3.63
EPMRANGE1 /dev/vgepm3/rlvepm_data3_023 934 0 9.82 7.37 75 0 1,179 2.49
EPMRANGE1 /dev/vgepm3/rlvepm_data3_024 1,494 0 13.23 5.02 139 0 776 4.20
EPMRANGE1 /dev/vgepm3/rlvepm_data3_025 819 0 15.91 7.73 157 0 401 5.21
EPMRANGE1 /dev/vgepm3/rlvepm_data3_026 1,353 0 17.77 4.88 187 0 394 8.02
EPMRANGE1 /dev/vgepm3/rlvepm_data3_027 1,316 0 18.24 5.46 269 0 473 6.72
EPMRANGE1 /dev/vgepm3/rlvepm_data3_028 1,053 0 8.66 5.84 241 0 587 4.31
EPMRANGE1 /dev/vgepm3/rlvepm_data3_029 928 0 16.20 6.58 297 0 326 6.93
EPMRANGE1 /dev/vgepm3/rlvepm_data3_030 531 0 10.85 9.81 174 0 251 6.10
EPMRANGE1 /dev/vgepm3/rlvepm_data3_031 394 0 9.90 10.66 56 0 172 6.40
EPMRANGE1 /dev/vgepm3/rlvepm_data3_032 487 0 17.06 8.57 70 0 172 6.86
EPMRANGE1 /dev/vgepm3/rlvepm_data3_033 532 0 16.26 7.89 57 0 193 7.20
EPMRANGE1 /dev/vgepm3/rlvepm_data3_034 333 0 10.96 9.40 45 0 127 5.35
EPMRANGE1 /dev/vgepm3/rlvepm_data3_035 385 0 14.62 8.22 79 0 136 6.99
EPMRANGE1 /dev/vgepm3/rlvepm_data3_036 344 0 9.39 9.16 53 0 131 5.65
EPMRANGE1 /dev/vgepm3/rlvepm_data3_037 361 0 16.79 8.75 171 0 130 6.77
EPMRANGE1 /dev/vgepm3/rlvepm_data3_038 402 0 13.13 7.95 64 0 123 5.45
EPMRANGE1 /dev/vgepm3/rlvepm_data3_039 360 0 8.97 8.75 70 0 130 5.77
EPMRANGE1 /dev/vgepm3/rlvepm_data3_040 363 0 12.45 8.71 59 0 128 7.11
EPMRANGE1 /dev/vgepm3/rlvepm_data3_041 271 0 8.15 9.60 101 0 121 6.45
EPMRANGE1 /dev/vgepm3/rlvepm_data3_042 203 0 9.95 10.34 135 0 98 6.53
EPMRANGE1 /dev/vgepm3/rlvepm_data3_043 229 0 15.55 9.28 142 0 73 8.36
EPMRANGE1 /dev/vgepm3/rlvepm_data3_044 233 0 16.31 9.17 304 0 71 8.31
EPMRANGE1 /dev/vgepm3/rlvepm_data3_045 214 0 13.22 9.73 213 0 76 6.97
EPMRANGE1 /dev/vgepm3/rlvepm_data3_046 496 0 24.78 4.29 201 0 76 7.89
EPMRANGE1 /dev/vgepm3/rlvepm_data3_047 82 0 19.51 1.06 0 0 7 18.57
EPMRANGE1 /dev/vgepm3/rlvepm_data3_048 789 0 23.40 1.05 0 0 42 25.71
EPMRANGE1 /dev/vgepm3/rlvepm_data3_049 568 0 25.55 1.05 1 0 43 25.35
EPMRANGE1 /dev/vgepm3/rlvepm_data3_050 345 0 16.99 1.04 18 0 76 10.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_051 63 0 6.67 1.03 3 0 176 1.88
EPMRANGE1 /dev/vgepm3/rlvepm_data3_052 759 0 25.20 1.09 33 0 350 3.60
EPMRANGE1 /dev/vgepm3/rlvepm_data3_053 4 0 12.50 31.50 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_054 8 0 10.00 16.75 0 0 1 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_055 4 0 10.00 31.50 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_056 7 0 7.14 19.57 0 0 1 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_057 6 0 8.33 23.67 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_058 6 0 8.33 22.00 0 0 1 10.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_059 2 0 10.00 1.00 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_060 15 0 5.33 2.87 3 0 2 5.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_061 8 0 5.00 1.88 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_062 24 0 7.08 2.29 0 0 9 5.56
EPMRANGE1 /dev/vgepm3/rlvepm_data3_063 21,593 6 1.49 1.06 0 0 8 8.75
EPMRANGE1 /dev/vgepm3/rlvepm_data3_064 75 0 6.93 16.41 0 0 8 10.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_065 232 0 3.53 6.04 10 0 7 10.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_066 153 0 17.12 4.45 9 0 14 6.43
EPMRANGE1 /dev/vgepm3/rlvepm_data3_067 175 0 5.71 7.66 32 0 12 5.83
EPMRANGE1 /dev/vgepm3/rlvepm_data3_068 135 0 6.67 10.51 103 0 13 6.15
EPMRANGE1 /dev/vgepm3/rlvepm_data3_069 131 0 6.41 9.91 12 0 16 10.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_070 167 0 9.04 9.04 1 0 12 10.83
EPMRANGE1 /dev/vgepm3/rlvepm_data3_071 208 0 7.16 11.88 14 0 12 7.50
EPMRANGE1 /dev/vgepm3/rlvepm_data3_072 225 0 6.98 11.61 26 0 24 4.17
EPMRANGE1 /dev/vgepm3/rlvepm_data3_073 316 0 7.97 10.60 79 0 26 4.23
EPMRANGE1 /dev/vgepm3/rlvepm_data3_074 261 0 6.74 13.11 1 0 31 4.52
EPMRANGE1 /dev/vgepm3/rlvepm_data3_075 292 0 9.59 14.07 22 0 24 7.08
EPMRANGE1 /dev/vgepm3/rlvepm_data3_076 316 0 7.03 14.11 11 0 46 4.78
EPMRANGE1 /dev/vgepm3/rlvepm_data3_077 470 0 18.55 10.78 15 0 60 7.67
EPMRANGE1 /dev/vgepm3/rlvepm_data3_078 371 0 8.63 14.12 21 0 74 3.92
EPMRANGE1 /dev/vgepm3/rlvepm_data3_079 439 0 10.39 12.75 24 0 92 3.91
EPMRANGE1 /dev/vgepm3/rlvepm_data3_080 380 0 6.89 15.77 73 0 88 3.75
EPMRANGE1 /dev/vgepm3/rlvepm_data3_081 435 0 6.51 14.08 54 0 102 4.80
EPMRANGE1 /dev/vgepm3/rlvepm_data3_082 347 0 5.82 15.54 7 0 42 5.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_083 276 0 4.82 17.38 23 0 2 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_084 262 0 8.66 18.90 43 0 1 10.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_085 288 0 12.60 17.15 15 0 3 3.33
EPMRANGE1 /dev/vgepm3/rlvepm_data3_086 332 0 10.12 15.26 7 0 6 3.33
EPMRANGE1 /dev/vgepm3/rlvepm_data3_087 368 0 13.37 13.91 16 0 3 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_088 349 0 11.81 14.32 16 0 5 4.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_089 485 0 10.37 11.34 0 0 1 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_090 448 0 9.84 14.14 32 0 2 5.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_091 663 0 9.74 11.96 24 0 122 4.02
EPMRANGE1 /dev/vgepm3/rlvepm_data3_092 649 0 10.14 12.32 0 0 104 4.71
EPMRANGE1 /dev/vgepm3/rlvepm_data3_093 583 0 5.90 14.06 9 0 115 4.52
EPMRANGE1 /dev/vgepm3/rlvepm_data3_094 539 0 6.09 14.52 0 0 120 4.08
EPMRANGE1 /dev/vgepm3/rlvepm_data3_095 651 0 9.66 11.85 16 0 103 5.44
EPMRANGE1 /dev/vgepm3/rlvepm_data3_096 688 0 11.77 11.20 15 0 128 6.48
EPMRANGE1 /dev/vgepm3/rlvepm_data3_097 655 0 11.08 11.82 6 0 125 7.20
EPMRANGE1 /dev/vgepm3/rlvepm_data3_098 654 0 11.02 10.94 31 0 139 5.76
EPMRANGE1 /dev/vgepm3/rlvepm_data3_099 711 0 10.76 9.97 7 0 155 5.55
EPMRANGE1 /dev/vgepm3/rlvepm_data3_100 657 0 14.00 10.91 19 0 167 5.93
EPMRANGE1 /dev/vgepm3/rlvepm_data3_101 541 0 8.74 13.34 19 0 150 5.40
EPMRANGE1 /dev/vgepm3/rlvepm_data3_102 633 0 9.56 11.42 21 0 182 5.44
EPMRANGE1 /dev/vgepm3/rlvepm_data3_103 667 0 7.53 11.26 34 0 174 4.66
EPMRANGE1 /dev/vgepm3/rlvepm_data3_104 658 0 9.04 11.47 13 0 168 5.24
EPMRANGE1 /dev/vgepm3/rlvepm_data3_105 625 0 9.79 11.83 26 0 172 5.41
EPMRANGE1 /dev/vgepm3/rlvepm_data3_106 771 0 12.91 9.44 22 0 214 6.45
EPMRANGE1 /dev/vgepm3/rlvepm_data3_107 601 0 8.39 11.87 19 0 192 5.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_108 790 0 12.19 8.92 15 0 201 5.27
EPMRANGE1 /dev/vgepm3/rlvepm_data3_109 598 0 7.63 11.54 18 0 201 4.98
EPMRANGE1 /dev/vgepm3/rlvepm_data3_110 818 0 11.44 8.41 4 0 181 5.80
EPMRANGE1 /dev/vgepm3/rlvepm_data3_111 698 0 10.73 9.50 18 0 187 6.26
EPMRANGE1 /dev/vgepm3/rlvepm_data3_112 676 0 10.59 8.60 12 0 196 5.77
EPMRANGE1 /dev/vgepm3/rlvepm_data3_113 758 0 12.30 7.93 26 0 188 7.61
EPMRANGE1 /dev/vgepm3/rlvepm_data3_114 600 0 8.92 9.44 13 0 171 5.56
EPMRANGE1 /dev/vgepm3/rlvepm_data3_115 598 0 8.60 9.57 11 0 202 4.85
EPMRANGE1 /dev/vgepm3/rlvepm_data3_116 684 0 11.65 7.93 6 0 201 5.62
EPMRANGE1 /dev/vgepm3/rlvepm_data3_117 733 0 14.43 7.18 6 0 208 6.11
EPMRANGE1 /dev/vgepm3/rlvepm_data3_118 663 0 14.34 7.79 24 0 170 6.29
EPMRANGE1 /dev/vgepm3/rlvepm_data3_119 605 0 10.35 8.63 11 0 198 4.75
EPMRANGE1 /dev/vgepm3/rlvepm_data3_120 626 0 11.45 8.29 9 0 220 4.86
EPMRANGE1 /dev/vgepm3/rlvepm_data3_121 641 0 14.43 8.55 23 0 217 5.44
EPMRANGE1 /dev/vgepm3/rlvepm_data3_122 602 0 11.88 8.85 12 0 204 5.59
EPMRANGE1 /dev/vgepm3/rlvepm_data3_123 571 0 13.20 9.14 10 0 204 5.34
EPMRANGE1 /dev/vgepm3/rlvepm_data3_124 740 0 15.09 6.99 16 0 184 6.90
EPMRANGE1 /dev/vgepm3/rlvepm_data3_125 631 0 14.88 8.23 10 0 208 5.48
EPMRANGE1 /dev/vgepm3/rlvepm_data3_126 716 0 15.27 7.25 22 0 212 5.80
EPMRANGE1 /dev/vgepm3/rlvepm_data3_127 593 0 13.47 8.73 20 0 226 5.04
EPMRANGE1 /dev/vgepm3/rlvepm_data3_128 502 0 8.94 10.01 23 0 209 5.41
EPMRANGE1 /dev/vgepm3/rlvepm_data3_129 676 0 15.00 7.19 8 0 223 5.20
EPMRANGE1 /dev/vgepm3/rlvepm_data3_130 749 0 13.77 6.54 34 0 208 5.82
EPMRANGE1 /dev/vgepm3/rlvepm_data3_131 605 0 11.22 7.58 24 0 199 5.23
EPMRANGE1 /dev/vgepm3/rlvepm_data3_132 622 0 12.97 7.58 21 0 201 5.72
EPMRANGE1 /dev/vgepm3/rlvepm_data3_133 602 0 11.98 8.04 29 0 216 5.23
EPMRANGE1 /dev/vgepm3/rlvepm_data3_134 697 0 11.46 7.90 30 0 182 5.77
EPMRANGE1 /dev/vgepm3/rlvepm_data3_135 1,474 0 22.27 4.89 44 0 267 9.66
EPMRANGE1 /dev/vgepm3/rlvepm_data3_136 1,542 0 14.48 5.72 40 0 277 8.23
EPMRANGE1 /dev/vgepm3/rlvepm_data3_137 1,220 0 12.83 6.23 49 0 470 4.02
EPMRANGE1 /dev/vgepm3/rlvepm_data3_138 1,173 0 17.20 7.11 61 0 325 6.43
EPMRANGE1 /dev/vgepm3/rlvepm_data3_139 439 0 15.63 8.97 0 0 62 6.77
EPMRANGE1 /dev/vgepm3/rlvepm_data3_140 189 0 5.61 12.70 0 0 30 3.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_141 188 0 6.76 13.38 0 0 25 4.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_142 157 0 5.99 9.55 1 0 33 3.03
EPMRANGE1 /dev/vgepm3/rlvepm_data3_143 151 0 5.76 9.07 0 0 29 3.10
EPMRANGE1 /dev/vgepm3/rlvepm_data3_144 193 0 5.39 7.34 1 0 25 2.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_145 264 0 16.44 4.71 1 0 49 2.24
EPMRANGE1 /dev/vgepm3/rlvepm_data3_146 201 0 3.38 6.48 2 0 30 3.33
EPMRANGE1 /dev/vgepm3/rlvepm_data3_147 141 0 3.26 7.09 0 0 13 2.31
EPMRANGE1 /dev/vgepm3/rlvepm_data3_148 121 0 2.89 8.02 11 0 24 2.50
EPMRANGE1 /dev/vgepm3/rlvepm_data3_149 90 0 4.00 9.22 3 0 13 0.77
EPMRANGE1 /dev/vgepm3/rlvepm_data3_150 94 0 6.70 18.07 0 0 17 1.76
EPMRANGE1 /dev/vgepm3/rlvepm_data3_151 77 0 5.06 10.57 0 0 18 2.22
EPMRANGE1 /dev/vgepm3/rlvepm_data3_152 116 0 6.55 14.83 7 0 12 0.83
EPMRANGE1 /dev/vgepm3/rlvepm_data3_153 147 0 6.73 19.49 0 0 18 2.22
EPMRANGE1 /dev/vgepm3/rlvepm_data3_154 186 0 12.85 19.46 0 0 14 2.14
EPMRANGE1 /dev/vgepm3/rlvepm_data3_155 168 0 11.49 16.24 3 0 18 1.67
EPMRANGE1 /dev/vgepm3/rlvepm_data3_156 152 0 14.41 11.98 0 0 18 3.89
EPMRANGE1 /dev/vgepm3/rlvepm_data3_157 465 0 23.85 7.17 0 0 18 1.11
EPMRANGE1 /dev/vgepm3/rlvepm_data3_158 95 0 6.95 16.62 0 0 15 1.33
EPMRANGE1 /dev/vgepm3/rlvepm_data3_159 212 0 11.51 12.96 0 0 14 2.86
EPMRANGE1 /dev/vgepm3/rlvepm_data3_160 349 0 24.30 9.61 0 0 16 1.88
EPMRANGE1 /dev/vgepm3/rlvepm_data3_161 585 0 26.43 7.02 0 0 11 1.82
EPMRANGE1 /dev/vgepm3/rlvepm_data3_162 537 0 25.10 4.52 0 0 15 2.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_163 342 0 22.66 9.04 0 0 19 1.05
EPMRANGE1 /dev/vgepm3/rlvepm_data3_164 612 0 27.88 5.04 0 0 17 3.53
EPMRANGE1 /dev/vgepm3/rlvepm_data3_165 309 0 24.66 9.89 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_166 634 0 20.77 5.14 0 0 119 2.35
EPMRANGE1 /dev/vgepm3/rlvepm_data3_167 84 0 7.26 24.52 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_168 72 0 7.64 28.44 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_169 72 0 9.58 28.44 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_170 45 0 7.78 28.44 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_171 44 0 7.50 29.07 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_172 18 0 6.67 21.56 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_173 41 0 8.05 28.10 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_174 72 0 7.08 18.18 0 0 14 3.57
EPMRANGE1 /dev/vgepm3/rlvepm_data3_175 378 0 23.25 8.12 0 0 10 4.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_176 288 0 5.14 7.99 0 0 118 1.86
EPMRANGE1 /dev/vgepm3/rlvepm_data3_177 358 0 3.55 4.84 0 0 139 2.95
EPMRANGE1 /dev/vgepm3/rlvepm_data3_178 284 0 4.51 8.88 5 0 126 1.98
EPMRANGE1 /dev/vgepm3/rlvepm_data3_179 905 0 15.38 5.19 0 0 238 2.65
EPMRANGE1 /dev/vgepm3/rlvepm_data3_180 78 0 7.18 27.90 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_181 40 0 8.00 28.75 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_182 268 0 2.80 1.07 0 0 113 2.65
EPMRANGE1 /dev/vgepm3/rlvepm_data3_183 279 0 3.30 5.09 0 0 116 2.67
EPMRANGE1 /dev/vgepm3/rlvepm_data3_184 20 0 2.50 1.00 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_185 19 0 4.74 1.00 0 0 0 0.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_186 706 0 17.35 6.29 0 0 69 3.48
EPMRANGE1 /dev/vgepm3/rlvepm_data3_187 144 0 28.06 22.79 0 0 9 6.67
EPMRANGE1 /dev/vgepm3/rlvepm_data3_188 56 0 8.93 22.77 0 0 6 6.67
EPMRANGE1 /dev/vgepm3/rlvepm_data3_189 288 0 31.49 8.35 0 0 6 10.00
EPMRANGE1 /dev/vgepm3/rlvepm_data3_190 106 0 6.70 21.72 0 0 6 6.67
EPMTMP /dev/vgepm1/rlvepm_temp1 87,737 24 25.12 9.34 14,101 4 0  
EPMTMP /dev/vgepm1/rlvepm_temp2 85,241 24 25.81 7.07 7,418 2 0  
EPSA /dev/vgepm1/rlvepsa_data01 131,746 36 2.32 9.61 124 0 493,756 2.15
EPSA /dev/vgepm1/rlvepsa_data02 137,442 38 2.35 9.11 143 0 507,366 2.18
EPSA /dev/vgepm1/rlvepsa_data03 145,988 40 2.41 8.45 245 0 533,021 2.20
EPSA /dev/vgepm1/rlvepsa_data04 133,631 37 2.38 9.13 42 0 497,354 2.23
EPSA /dev/vgepm1/rlvepsa_data05 128,702 36 2.14 9.59 34 0 487,326 2.10
EPSA /dev/vgepm1/rlvepsa_data06 138,792 38 2.31 8.88 38 0 514,478 2.16
EPSA /dev/vgepm1/rlvepsa_data07 133,940 37 2.49 9.25 32 0 494,228 2.31
EPSA /dev/vgepm1/rlvepsa_data08 132,671 37 2.42 9.28 70 0 491,922 2.26
EPSA /dev/vgepm1/rlvepsa_data09 134,356 37 2.23 9.17 18 0 491,671 2.12
EPSA /dev/vgepm1/rlvepsa_data10 135,091 37 2.35 9.14 37 0 499,208 2.18
SYSAUX /dev/vgsys/rlvsys_sysaux_01 2,755 1 5.31 2.84 2,586 1 659 3.10
SYSTEM /dev/vgsys/rlvsys_system_01 2,867 1 5.01 1.00 1,713 0 90 2.67
TEMP /dev/vgepm1/rlvepc_temp5 28,805 8 0.67 4.64 4,778 1 0  
TEMP /dev/vgsys/rlvsys_temp1 5,340 1 1.54 19.71 4,159 1 0  
UNDOTBS1 /dev/vgsys/rlvsys_undotbs1_1 0 0     3,940 1 52 0.00
UNDOTBS1 /dev/vgsys/rlvsys_undotbs1_2 0 0     1,602 0 23 0.43
UNDOTBS1 /dev/vgsys/rlvsys_undotbs1_3 0 0     1,330 0 7 0.00
UNDOTBS1 /dev/vgsys/rlvsys_undotbs1_4 0 0     2,061 1 21 0.00
UNDOTBS1 /dev/vgsys/rlvsys_undotbs1_5 0 0     1,454 0 9 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 16,854,264 99 1,735,214,125 14,834,798 139,278 0 0 5,241,242
K 1,226,880   0 0 0 0 0 0


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 7 10790 52483 429930 9437130 429930  
E 0 1 2009 6923 183639 9437130 183639  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 14,064 0.10 1,685,043 4.25 1.1E+11
D 28,128 0.20 3,370,086 2.33 61,748,087,956
D 42,192 0.30 5,055,129 1.71 45,190,338,478
D 56,256 0.40 6,740,172 1.43 37,835,443,399
D 70,320 0.50 8,425,215 1.28 33,872,190,315
D 84,384 0.60 10,110,258 1.18 31,397,051,683
D 98,448 0.70 11,795,301 1.12 29,607,123,892
D 112,512 0.80 13,480,344 1.07 28,308,163,367
D 126,576 0.90 15,165,387 1.03 27,299,261,424
D 140,640 1.00 16,850,430 1.00 26,500,328,982
D 140,672 1.00 16,854,264 1.00 26,498,791,160
D 154,704 1.10 18,535,473 0.97 25,821,240,991
D 168,768 1.20 20,220,516 0.95 25,232,054,703
D 182,832 1.30 21,905,559 0.93 24,703,454,857
D 196,896 1.40 23,590,602 0.92 24,256,966,922
D 210,960 1.50 25,275,645 0.90 23,858,948,078
D 225,024 1.60 26,960,688 0.89 23,549,394,881
D 239,088 1.70 28,645,731 0.88 23,281,556,493
D 253,152 1.80 30,330,774 0.87 23,037,156,050
D 267,216 1.90 32,015,817 0.86 22,833,602,794
D 281,280 2.00 33,700,860 0.77 20,339,925,305

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
88.47 85,362 11,120

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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 MemGlobal Mem Bound(K)
B 32,768 26,360 6,952.48 1,410.71 20.29 100.00 0.00 1,048,576
E 32,768 26,745 5,253.99 765.66 14.57 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 68,807 68,807 0 0
64K 128K 157 157 0 0
128K 256K 390 390 0 0
256K 512K 336 336 0 0
512K 1024K 11,357 11,357 0 0
1M 2M 31,510 31,510 0 0
2M 4M 222 220 2 0
4M 8M 128 58 70 0
8M 16M 184 158 26 0
16M 32M 205 165 40 0
32M 64M 275 239 36 0
64M 128M 54 34 20 0
128M 256M 4 0 4 0
256M 512M 22 20 2 0
2G 4G 2 0 2 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
4,096 0.13 153,242,385.37 300,491.36 100.00 1,908
8,192 0.25 153,242,385.37 127,718.34 100.00 0
16,384 0.50 153,242,385.37 127,718.34 100.00 0
24,576 0.75 153,242,385.37 127,718.34 100.00 0
32,768 1.00 153,242,385.37 126,537.60 100.00 0
39,322 1.20 153,242,385.37 24,289.29 100.00 0
45,875 1.40 153,242,385.37 24,289.29 100.00 0
52,429 1.60 153,242,385.37 24,289.29 100.00 0
58,982 1.80 153,242,385.37 24,289.29 100.00 0
65,536 2.00 153,242,385.37 24,289.29 100.00 0
98,304 3.00 153,242,385.37 24,289.29 100.00 0
131,072 4.00 153,242,385.37 24,289.29 100.00 0
196,608 6.00 153,242,385.37 24,289.29 100.00 0
262,144 8.00 153,242,385.37 24,289.29 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
64 0.14 186,841 1,868 96,441 964
112 0.25 175,924 1,759 95,710 957
160 0.36 164,764 1,647 95,015 950
208 0.46 153,247 1,532 94,390 943
256 0.57 141,611 1,416 93,836 938
304 0.68 130,024 1,300 93,325 933
352 0.79 118,326 1,183 92,823 928
400 0.89 106,314 1,063 92,300 922
448 1.00 94,007 940 91,745 917
496 1.11 81,467 814 91,152 911
544 1.21 68,765 687 90,538 905
592 1.32 55,966 559 78,685 786
640 1.43 42,451 424 64,310 643
688 1.54 28,443 284 56,819 568
736 1.64 15,698 156 42,654 426
784 1.75 0 0 3,057 30
832 1.86 0 0 3,057 30
880 1.96 0 0 3,057 30
928 2.07 0 0 3,057 30
976 2.18 0 0 3,057 30

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

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 5,167,674 11,388 2
segment header 7 0 6
1st level bmb 12 0 2
undo block 97 0 0
undo header 16 0 0
2nd level bmb 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 8,657 10 8,647 26 15 582.27
WF-AWR Flush 21 21 0 12 4 341.75
TX-Transaction (index contention) 382 382 0 56 1 9.96
PS-PX Process Reservation 374 314 60 186 0 0.67
CF-Controlfile Transaction 62,912 62,912 0 124 0 0.73
TO-Temp Object 840 840 0 125 0 0.59
TM-DML 55,278 55,278 0 82 0 0.48
TT-Tablespace 6,223 6,223 0 46 0 0.65
MD-Materialized View Log DDL 110 110 0 55 0 0.51
SQ-Sequence Cache 63 63 0 1 0 23.00
HW-Segment High Water Mark 5,378 5,378 0 43 0 0.47
FB-Format Block 87 87 0 49 0 0.39
JS-Job Scheduler (job run lock - synchronize) 12 10 2 9 0 1.89
TA-Instance Undo 19 19 0 19 0 0.47
TX-Transaction (allocate ITL entry) 9 9 0 3 0 1.67
JS-Job Scheduler (queue lock) 10,492 10,492 0 1 0 4.00
WL-Being Written Redo Log 1 1 0 1 0 3.00
JQ-Job Queue 30 30 0 4 0 0.50
AF-Advisor Framework (task serialization) 7 7 0 1 0 1.00
PI-Remote PX Process Spawn Status 66 66 0 2 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 2,528 0.00   0 0  
AWR Alerted Metric Element list 145,961 0.00   0 0  
Consistent RBA 30,798 0.00   0 0  
FAL request queue 74 0.00   0 0  
FAL subheap alocation 74 0.00   0 0  
FIB s.o chain latch 10 0.00   0 0  
FOB s.o list latch 21,322 5.13 0.01 0 0  
JS Sh mem access 18 5.56 1.00 0 0  
JS broadcast add buf latch 797 0.00   0 0  
JS broadcast drop buf latch 790 0.00   0 0  
JS broadcast load blnc latch 678 0.00   0 0  
JS mem alloc latch 148 0.00   0 0  
JS queue access latch 148 0.00   0 0  
JS queue state obj latch 20,984 0.00   0 0  
JS slv state obj latch 792 0.00   0 0  
KCL gc element parent latch 69,018,601 0.16 0.18 1 684 0.00
KJC message pool free list 434,483 0.02 0.02 0 290,017 0.01
KJCT flow control latch 11,412,513 0.04 0.01 0 0  
KMG MMAN ready and startup request latch 1,200 0.00   0 0  
KSXR large replies 224 0.00   0 0  
KTF sga latch 17 0.00   0 1,204 0.00
KWQMN job cache list latch 726 0.14 1.00 0 0  
KWQP Prop Status 2 0.00   0 0  
Memory Management Latch 0     0 1,200 0.00
OS process 1,026 0.00   0 0  
OS process allocation 1,811 0.00   0 0  
OS process: request allocation 431 0.70 0.00 0 0  
PL/SQL warning settings 4,126 0.00   0 0  
SGA IO buffer pool latch 971,753 0.09 0.05 0 971,753 0.08
SQL memory manager latch 1 0.00   0 1,197 0.00
SQL memory manager workarea list latch 238,990 0.00 0.00 0 0  
Shared B-Tree 131 0.00   0 0  
active checkpoint queue latch 34,208 0.01 0.00 0 0  
active service list 8,192 0.11 0.11 0 5,683 0.00
alert log latch 2 0.00   0 0  
archive control 63 0.00   0 0  
archive process latch 1,347 0.00   0 0  
begin backup scn array 27 0.00   0 0  
business card 36 0.00   0 0  
cache buffer handles 1,458,965 0.01 0.00 0 0  
cache buffers chains 2,670,025,662 2.21 0.02 51 54,043,806 0.03
cache buffers lru chain 15,506,652 0.20 0.00 0 95,862,568 0.16
cache table scan latch 0     0 969,538 0.20
channel handle pool latch 452 0.00   0 0  
channel operations parent latch 3,900,519 0.00 0.02 0 0  
checkpoint queue latch 1,841,031 0.00 0.00 0 132,484 0.00
client/application info 6,061 0.00   0 0  
commit callback allocation 817 0.00   0 0  
compile environment latch 360 0.00   0 0  
dictionary lookup 128 0.00   0 0  
dml lock allocation 110,616 0.03 0.22 0 0  
dummy allocation 777 0.13 0.00 0 0  
enqueue hash chains 68,728,004 0.00 0.01 0 610 0.00
enqueues 47,428,233 1.13 0.00 0 0  
error message lists 134 0.75 0.00 0 0  
event group latch 179 0.00   0 0  
file cache latch 4,116 0.00   0 0  
gcs opaque info freelist 271,352 0.01 0.00 0 0  
gcs resource freelist 15,185,436 0.04 0.01 0 14,423 0.03
gcs resource hash 38,270,494 0.01 0.03 0 0  
gcs shadows freelist 35,444 0.00   0 30,036 0.00
ges caches resource lists 264,173 1.30 0.01 0 261,270 1.49
ges deadlock list 2,662 0.00   0 4 0.00
ges domain table 206,201 0.00   0 0  
ges enqueue table freelist 346,641 0.01 0.00 0 0  
ges group table 287,983 0.00 0.25 0 0  
ges process hash list 100,527 0.00   0 0  
ges process parent latch 1,105,729 0.00 0.00 0 0  
ges process table freelist 431 0.00   0 0  
ges resource hash list 1,300,395 0.65 0.96 0 241,042 0.00
ges resource scan list 1,630 0.00   0 0  
ges resource table freelist 273,759 0.02 0.00 0 0  
ges timeout list 89,216 0.01 0.17 0 45,520 0.00
global KZLD latch for mem in SGA 134 0.00   0 0  
global tx hash mapping 22,656,698 0.00 0.00 0 0  
hash table column usage latch 956 0.10 1.00 0 269,685 0.00
hash table modification latch 133 0.00   0 0  
interrupt manipulation 901 0.11 0.00 0 0  
job workq parent latch 0     0 84 0.00
job_queue_processes parameter latch 97 0.00   0 0  
kks stats 14,328 0.04 0.00 0 0  
kokc descriptor allocation latch 686 0.00   0 0  
ksuosstats global area 243 0.00   0 0  
ktm global data 19 0.00   0 0  
kwqbsn:qsga 130 0.00   0 0  
lgwr LWN SCN 31,340 0.20 0.02 0 0  
library cache 2,775,491 0.03 0.09 3 34,872 0.11
library cache load lock 5,524 0.00   0 13 0.00
library cache lock 25,996,025 0.01 0.02 0 0  
library cache lock allocation 11,352 0.04 0.00 0 0  
library cache pin 596,009 0.01 0.00 0 4 0.00
library cache pin allocation 3,067 0.00   0 0  
list of block allocation 2,502 0.00   0 0  
loader state object freelist 604 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 7,947 0.00   0 358,331 0.00
message pool operations parent latch 1,268 0.00   0 0  
messages 770,891 0.05 0.03 0 0  
mostly latch-free SCN 50,809 33.92 0.00 0 0  
multiblock read objects 2,530,563 0.15 0.17 0 0  
name-service memory objects 18,796 0.00   0 0  
name-service namespace bucket 52,516 0.00   0 0  
name-service pending queue 12,348 0.00   0 0  
name-service request 76 0.00   0 0  
name-service request queue 74,210 0.00   0 0  
ncodef allocation latch 58 0.00   0 0  
object queue header heap 67,387 0.00   0 19,326 0.00
object queue header operation 31,046,341 0.00 0.09 0 0  
object stats modification 193 0.00   0 0  
parallel query alloc buffer 1,844 0.05 0.00 0 0  
parallel query stats 176 0.00   0 0  
parallel txn reco latch 35,587 0.00   0 0  
parameter list 80 0.00   0 0  
parameter table management 788 0.00   0 0  
post/wait queue 57,308 0.05 0.00 0 25,666 0.00
process allocation 43,308 0.02 1.00 0 179 0.00
process group creation 431 0.00   0 0  
process queue 584 0.00   0 0  
process queue reference 37,929 0.00   0 1,480 0.07
qmn task queue latch 1,014 13.51 0.10 0 0  
query server freelists 434 0.00   0 0  
query server process 2 0.00   0 18 0.00
queued dump request 17,122 0.00   0 0  
redo allocation 156,489 0.04 0.07 0 1,260,197 0.03
redo copy 0     0 1,260,330 0.02
redo writing 129,610 0.01 0.00 0 0  
resmgr group change latch 1,460 0.00   0 0  
resmgr:active threads 756 0.00   0 0  
resmgr:actses change group 288 0.00   0 0  
resmgr:free threads list 755 0.26 0.00 0 0  
resmgr:resource group CPU method 346 0.29 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 5,768,216 2.59 0.05 402 3,105 201.16
rules engine aggregate statistics 4 0.00   0 0  
rules engine rule set statistics 108 0.00   0 0  
sequence cache 667,823 0.00 0.00 0 0  
session allocation 3,491,325 0.17 0.03 0 0  
session idle bit 55,176,769 0.00 0.02 0 0  
session state list latch 718 0.00   0 0  
session switching 1,317 0.15 0.50 0 0  
session timer 1,205 0.00   0 0  
shared pool 2,903,025 0.33 0.61 318 0  
simulator hash latch 79,694,364 0.00 0.02 0 0  
simulator lru latch 0     0 77,780,337 2.74
slave class 11 0.00   0 0  
slave class create 44 2.27 1.00 0 0  
sort extent pool 11,060 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 3,276 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
temporary table state object allocation 7 0.00   0 0  
threshold alerts latch 347 0.00   0 0  
transaction allocation 136,651,048 0.24 0.00 0 0  
transaction branch allocation 22,653,393 0.10 0.01 0 0  
undo global data 637,905 0.17 0.01 0 0  
user lock 749 6.41 0.42 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 2,670,025,662 59,127,111 1,224,389 57,962,681 0 0 0
enqueues 47,428,233 536,174 1,297 534,885 0 0 0
transaction allocation 136,651,048 326,121 1,433 324,755 0 0 0
row cache objects 5,768,216 149,543 8,049 143,312 0 0 0
KCL gc element parent latch 69,018,601 107,042 19,337 88,314 0 0 0
cache buffers lru chain 15,506,652 31,470 65 31,405 0 0 0
transaction branch allocation 22,653,393 23,070 116 22,956 0 0 0
mostly latch-free SCN 50,809 17,236 65 17,175 0 0 0
shared pool 2,903,025 9,502 5,795 3,807 0 0 0
ges resource hash list 1,300,395 8,512 8,139 374 0 0 0
gcs resource freelist 15,185,436 6,584 95 6,492 0 0 0
session allocation 3,491,325 5,915 176 5,746 0 0 0
KJCT flow control latch 11,412,513 5,063 39 5,030 0 0 0
gcs resource hash 38,270,494 4,127 140 3,998 0 0 0
multiblock read objects 2,530,563 3,787 656 3,158 0 0 0
ges caches resource lists 264,173 3,445 38 3,408 0 0 0
simulator hash latch 79,694,364 2,516 53 2,468 0 0 0
library cache lock 25,996,025 2,276 44 2,233 0 0 0
object queue header operation 31,046,341 1,432 124 1,327 0 0 0
FOB s.o list latch 21,322 1,094 9 1,085 0 0 0
undo global data 637,905 1,070 8 1,062 0 0 0
enqueue hash chains 68,728,004 1,000 11 990 0 0 0
library cache 2,775,491 901 84 820 0 0 0
SGA IO buffer pool latch 971,753 876 42 839 0 0 0
session idle bit 55,176,769 506 12 494 0 0 0
messages 770,891 352 10 342 0 0 0
qmn task queue latch 1,014 137 14 123 0 0 0
KJC message pool free list 434,483 84 2 82 0 0 0
redo allocation 156,489 69 5 64 0 0 0
lgwr LWN SCN 31,340 62 1 61 0 0 0
user lock 749 48 20 29 0 0 0
channel operations parent latch 3,900,519 46 1 45 0 0 0
dml lock allocation 110,616 36 8 29 0 0 0
active service list 8,192 9 1 8 0 0 0
ges group table 287,983 8 2 6 0 0 0
process allocation 43,308 7 7 0 0 0 0
ges timeout list 89,216 6 1 5 0 0 0
session switching 1,317 2 1 1 0 0 0
JS Sh mem access 18 1 1 0 0 0 0
KWQMN job cache list latch 726 1 1 0 0 0 0
hash table column usage latch 956 1 1 0 0 0 0
slave class create 44 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
FOB s.o list latch ksfd_fobd 0 9 9
JS Sh mem access jsksGetShMemLatch 0 1 1
KCL gc element parent latch kclnfndnewm 0 25,402 4,447
KCL gc element parent latch kclplz 0 858 5,400
KCL gc element parent latch kclzcl 0 540 2,673
KCL gc element parent latch KCLUNLNK 0 210 8,787
KCL gc element parent latch kclulb 0 148 5,721
KCL gc element parent latch kclnfnd 0 78 11
KCL gc element parent latch kclrwrite 0 18 77
KCL gc element parent latch kclbla 0 10 2
KCL gc element parent latch kclebs 0 6 68
KCL gc element parent latch kclhngcbk1 0 4 0
KCL gc element parent latch kclgcr 0 3 6
KCL gc element parent latch kclwrt 0 3 2
KCL gc element parent latch kclgrantlk 0 2 17
KCL gc element parent latch kclfwrite1 0 1 69
KCL gc element parent latch kclpdc_3 0 1 0
KCL gc element parent latch kclpto_3 0 1 0
KCL gc element parent latch kclshrsplit 0 1 1
KJC message pool free list kjcsmpav: allocate a msg buffer 0 1 2
KJC message pool free list kjcspfmbq: free vector of msg buffers 0 1 0
KJCT flow control latch kjcts_sqenq: queue a message 0 22 1
KJCT flow control latch kjctcsnd: send normal message 0 6 35
KJCT flow control latch kjcts_sedeqv: dequeue a vector of msgs 0 5 0
KJCT flow control latch kjctr_updatetkt: update ticket info 0 3 0
KWQMN job cache list latch kwqmnuji: update job item 0 1 1
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 25 0
SGA IO buffer pool latch ksfd_free_sgabuffer 0 16 41
active service list kswslogon: session logout 0 7 4
cache buffers chains kcbrls: kslbegin 0 3,205,059 3,413,043
cache buffers chains kcbgtcr: kslbegin excl 0 1,514,810 1,360,199
cache buffers chains kcbgtcr: fast path 0 154,668 49,199
cache buffers chains kcbzwb 0 131,782 189,152
cache buffers chains kclebs_1 0 12,990 2,035
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 3,038 12,139
cache buffers chains kcbzib: finish free bufs 0 2,375 1,602
cache buffers chains kcbzib: multi-block read: nowait 0 288 0
cache buffers chains kcbgcur: kslbegin 0 63 32
cache buffers chains kcbzgb: scan from tail. nowait 0 55 0
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 14 0
cache buffers chains kclwrt 0 12 0
cache buffers chains kcbchg: kslbegin: call CR func 0 4 630
cache buffers chains kcbnlc 0 3 8
cache buffers chains kclwcrs 0 2 6
cache buffers chains kcbcge 0 1 1,310
cache buffers chains kcbget: pin buffer 0 1 0
cache buffers chains kcbgtcr: kslbegin shared 0 1 0
cache buffers chains kcbnew: new latch again 0 1 0
cache buffers chains kclbla 0 1 0
cache buffers chains kcllwr 0 1 0
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 32 40
cache buffers lru chain kcbzar: KSLNBEGIN 0 25 0
cache buffers lru chain kcbzgws 0 8 0
channel operations parent latch ksrapublish() 0 2 0
cost function kzulrl 0 19 19
cost function kzulgt: find user res 0 1 1
dml lock allocation ktaiam 0 8 8
enqueue hash chains ksqgtl3 0 6 7
enqueue hash chains ksqcmi: if lk mode not requested 0 2 1
enqueue hash chains ksqrcl 0 2 2
enqueue hash chains ksqcnl 0 1 0
enqueues ksqgel: create enqueue 0 837 805
enqueues ksqdel 0 364 237
enqueues ksqies 0 94 253
event range base latch No latch 0 37 34
gcs resource freelist kjbrfr free resource 0 64 22
gcs resource freelist kjbralc add resource 0 32 74
gcs resource hash kjbcropen:affinity 0 93 30
gcs resource hash kclzcl 0 33 80
gcs resource hash kjbmdowncvt 0 8 0
gcs resource hash kjblpast 0 4 0
gcs resource hash kjbassume 0 1 1
gcs resource hash kjbmpclose 0 1 1
ges group table kjgagll: move a lock from process lock list to group lock list 0 2 1
ges resource hash list kjakcai: search for resp by resname 0 5,180 10
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 2,594 1
ges resource hash list kjrmas1: lookup master node 0 187 0
ges resource hash list kjlrlr: remove lock from resource queue 0 92 7,659
ges resource hash list kjucvl: lock convert request 0 79 464
ges resource hash list kjrref: find matched resource 0 7 7
ges resource hash list kjcvscn: remove from scan queue 0 2 0
ges resource table freelist kjruch: cached obj cleanup 0 16 0
ges resource table freelist kjrchc2: cached obj cleanup 0 11 0
ges resource table freelist kjchc: clean resource cache 0 10 0
ges resource table freelist kjrm2c: move resource to cache 0 1 37
ges timeout list kjtscn: try to lock timer queue 0 1 0
hash table column usage latch KSXMMON_GETCELEM 0 1 0
lgwr LWN SCN kcs023 0 11 0
library cache kgldte: child 0 0 40 46
library cache kglhdgn: child: 0 12 13
library cache kglobpn: child: 0 5 7
library cache kglScanDependency 0 4 0
library cache kgldti: 2child 0 4 1
library cache kglpndl: child: after processing 0 3 1
library cache kglukp: child 0 2 0
library cache kgldtld: 2child 0 1 1
library cache kglnti 0 1 0
library cache kglpnp: child 0 1 1
library cache lock kgllkdl: child: cleanup 0 21 23
library cache lock kgllkdl: child: no lock handle 0 6 4
messages ksaamb: after wakeup 0 5 5
messages ksarcv: after wait 0 4 2
messages ksarcv 0 1 2
mostly latch-free SCN kcslcu3 0 54 66
mostly latch-free SCN kcs024 0 1 0
multiblock read objects kcbzib: normal mbr free 0 400 294
multiblock read objects kcbzib: mbr get 0 256 362
object queue header operation kcbw_unlink_q 0 116 128
object queue header operation kcbo_ivbo 0 15 1
object queue header operation kcbo_switch_cq 0 9 1
object queue header operation kcbw_link_q 0 8 17
object queue header operation kcbo_switch_mq_bg 0 1 1
process allocation ksucrp 0 4 0
process allocation ksufap: active procs 0 2 4
process allocation ksudlp 0 1 3
redo allocation kcrfw_redo_gen: redo allocation 1 0 5 0
row cache objects kqrbip 0 2,843 3,853
row cache objects kqrigt 0 111 305
row cache objects kqreqd: reget 0 59 19
row cache objects kqrpre: find obj 0 29 81
row cache objects kqreqd 0 17 17
row cache objects kqrbgl 0 2 1
row cache objects kqrso 0 2 3
row cache objects kqrbtm: pop parent 0 1 3
session allocation ksucri 0 78 100
session allocation ksuxds: not user session 0 52 38
session allocation ksuxds: KSUSFCLC not set 0 35 25
session allocation ksudlp 0 8 9
session allocation ksuprc 0 2 1
session allocation ksudlc 0 1 2
session idle bit ksupuc: set busy 0 10 7
session idle bit ksuxds 0 4 1
session idle bit ksupuc: clear busy 0 2 8
session switching kskexeall 0 1 1
shared pool kghfrunp: alloc: wait 0 4,920 4,376
shared pool kghfrunp: clatch: wait 0 4,896 3,750
shared pool kghalo 0 622 469
shared pool kghfre 0 187 814
shared pool kghfrunp: clatch: nowait 0 94 0
shared pool kghupr1 0 31 83
shared pool kghalp 0 27 44
shared pool kghasp 0 7 9
shared pool kghfrh 0 1 0
simulator hash latch kcbsacc: lookup dba 0 37 34
simulator hash latch kcbsacc: insert dba 0 9 0
simulator hash latch kcbsacc: remove dba 0 5 18
simulator hash latch kcbs_lookup_setid: lookup dba 0 2 1
slave class create ksvcreate 0 1 0
transaction allocation ktcxbr 0 1,432 1,432
transaction allocation ktcdod 0 1 0
transaction branch allocation ksupuc 0 115 116
transaction branch allocation ktcbod 0 1 0
undo global data ktudba: KSLBEGIN 0 7 8
undo global data ktucof: at start 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
EPSA_LN EPMIDX IDX_SA_WF_INST_HIS_KEYDATA   INDEX 459,304,368 26.46
EPSA_LN EPSA IDX_WORKFORM_KEYDATAID   INDEX 347,522,400 20.02
EPM_LN EPMIDX PK_C_CONS   INDEX 198,651,152 11.44
EPSA_LN EPSA SA_WORKFORM_INST_HISTORY   TABLE 161,451,952 9.30
FLOW_LN EPMDAT1 PK_LOG_PROCINST   INDEX 64,848,576 3.74

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
EPSA_LN EPSA SA_WORKFORM_INST_HISTORY   TABLE 12,360,712 75.24
EPM_LN EPMDAT1 ARC_S_SP_SCHEME   TABLE 355,128 2.16
EPM_LN EPMDAT1 C_CUST_AGREEMENT   TABLE 88,891 0.54
EPM_LN EPMDAT1 SA_O_LLR_CMPL   TABLE 71,854 0.44
EPM_LN EPMRANGE1 A_RCVED_PL_FLOW A12_1403 TABLE SUBPARTITION 40,691 0.25

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
EPSA_LN EPSA SA_TASK_LOCKS   TABLE 17,296 97.41
EPM_LN EPMDAT1 PK_O_PAY_DAY   INDEX 250 1.41
SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST   INDEX 77 0.43
EPM_LN EPMDAT1 PK_O_BUSI_ACT   INDEX 34 0.19
EPSA_LN EPSA PK_SA_LOG_OP   INDEX 31 0.17

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST   INDEX 6 85.71
SYS SYSTEM TAB$   TABLE 1 14.29

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
EPSA_LN EPSA SA_TASK_LOCKS   TABLE 107 23.67
EPSA_LN EPSA PK_SA_LOG_OP   INDEX 49 10.84
EPSA_LN EPSA IDX_SA_LOG_OP_LOG_TIME   INDEX 46 10.18
EPM_LN EPMIDX AC_RCVED_FLOW_AC_RCVED_PL_FLOW A12_1403 INDEX SUBPARTITION 26 5.75
EPM_LN EPMIDX IDX_A_RCVBL_ENTRY_CONS_NO 01_04_1404 INDEX SUBPARTITION 26 5.75

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
EPSA_LN EPSA SA_WORKFORM_INST_HISTORY   TABLE 3,560,600 97.99
EPM_LN EPMRANGE1 A_RCVBL_FLOW A09_1403 TABLE SUBPARTITION 4,361 0.12
EPM_LN EPMIDX IDX_A_RCVED_FLOW_ACCT_NO A05_1403 INDEX SUBPARTITION 4,337 0.12
EPM_LN EPMIDX AC_FLOW_AC_PREPAY_FLOW_FK A07_1403 INDEX SUBPARTITION 4,294 0.12
EPM_LN EPMIDX AC_RCVED_FLOW_AC_RCVED_PL_FLOW 01_01_1403 INDEX SUBPARTITION 4,272 0.12

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
EPM_LN EPMRANGE1 A_PREPAY_FLOW A12_1403 TABLE SUBPARTITION 7,366 18.37
FLOW_LN EPMDAT1 SYS_GROUP_SERVER   TABLE 5,821 14.52
EPM_LN EPMRANGE1 A_RCVBL_FLOW A07_1403 TABLE SUBPARTITION 3,735 9.32
EPM_LN EPMRANGE1 A_RCVBL_FLOW A09_1403 TABLE SUBPARTITION 3,633 9.06
EPM_LN EPMRANGE1 A_RCVBL_FLOW A06_1403 TABLE SUBPARTITION 3,350 8.36

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
EPM_LN EPMRANGE1 ARC_R_DATA A09_1403 TABLE SUBPARTITION 28,035 11.77
EPM_LN EPMRANGE1 A_RCVBL_FLOW A02_1403 TABLE SUBPARTITION 15,050 6.32
EPM_LN EPMRANGE1 A_PAY_FLOW A09_1403 TABLE SUBPARTITION 12,081 5.07
EPM_LN EPMRANGE1 A_RCVBL_ENTRY 08_02_1403 TABLE SUBPARTITION 10,128 4.25
EPM_LN EPMRANGE1 G_LL_STAT A11 TABLE PARTITION 8,952 3.76

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 65 3.08 0   0 1
dc_constraints 944 33.26 0   944 1
dc_database_links 94,202 0.00 0   0 6
dc_global_oids 835 4.19 0   0 16
dc_histogram_data 58,117 5.87 0   6,058 11,519
dc_histogram_defs 34,767 13.11 0   1,538 6,392
dc_object_grants 15 33.33 0   0 6
dc_object_ids 62,567 2.06 0   108 1,993
dc_objects 12,105 9.28 0   340 3,867
dc_profiles 170 0.00 0   0 1
dc_rollback_segments 343,383 0.00 0   0 1,876
dc_segments 469,968 20.52 0   17 683,766
dc_sequences 62 25.81 0   62 15
dc_table_scns 110 100.00 0   0 0
dc_tablespaces 356,413 0.00 0   0 13
dc_usernames 2,133 0.19 0   0 53
dc_users 189,541 0.00 0   0 91
outstanding_alerts 152 92.11 0   4 26

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 2 2 0
dc_constraints 1,566 0 0
dc_global_oids 35 0 26
dc_histogram_defs 8,690 0 1,771
dc_object_ids 1,510 0 418
dc_objects 2,295 7 947
dc_segments 96,468 3 266,634
dc_sequences 124 2 4
dc_table_scns 110 0 0
dc_usernames 4 0 0
dc_users 1 0 0
outstanding_alerts 298 110 26

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 784 0.51 10,419 0.17 14 0
CLUSTER 42 2.38 56 3.57 1 0
INDEX 1,621 2.34 4,112 3.96 121 0
SQL AREA 11,988 34.82 12,877,307 0.16 948 1,508
TABLE/PROCEDURE 2,858 12.11 264,308 1.05 935 0
TRIGGER 1,323 0.15 1,745 0.17 1 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 56 1 0 1 0
INDEX 4,112 498 35 268 0
TABLE/PROCEDURE 12,557 2,127 148 822 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 3,192.24   1.69 4.84 168 168 1,888 1,888
  SQL 2,143.67 1,722.40 1.16 15.79 322 2,219 1,854 1,819
  Freeable 1,581.44 0.00 1.68 10.72 195   942 942
  PL/SQL 28.94 17.18 0.02 0.13 6 6 1,890 1,874
  JAVA 10.44 10.38 0.80 0.06 1 1 13 13
E Other 3,006.38   1.66 4.81 168 168 1,816 1,816
  SQL 1,216.22 805.08 0.68 7.96 218 2,083 1,780 1,760
  Freeable 999.31 0.00 1.11 4.57 98   898 898
  PL/SQL 27.16 15.69 0.01 0.14 6 6 1,817 1,817
  JAVA 10.44 10.38 0.80 0.06 1 1 13 13

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 1.6E+11  
Fixed Size 2,394,208  
Redo Buffers 47,935,488  
Variable Size 13,505,660,832  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 103.00 103.00 0.00
java joxlod exec hp 8.64 8.64 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared KQR L PO 846.32 681.74 -19.45
shared db_block_hash_buckets 1,232.00 1,232.00 0.00
shared free memory 975.48 1,068.55 9.54
shared gcs resources 4,100.64 4,100.64 0.00
shared gcs shadows 1,902.51 1,902.51 0.00
shared ges enqueues 264.10 264.10 0.00
shared ges resource 293.10 292.45 -0.22
shared library cache 332.34 331.75 -0.18
shared obj stat memo 519.26 519.31 0.01
shared object queue 269.96 269.96 0.00
shared partitioning d 141.01 162.13 14.97
shared sql area 382.77 426.92 11.53
streams free memory 447.90 447.90 0.00
  buffer_cache 150,912.00 150,912.00 0.00
  fixed_sga 2.28 2.28 0.00
  log_buffer 45.71 45.71 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 5,840,000 0 0
QMON Coordinator 460,000 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 4 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 14,575,765 24,717,436 20564126 20564126
ges_procs 1,817 2,840 3001 3001
processes 1,818 2,842 3000 3000
sessions 1,843 3,305 3305 3305


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_enable_shared_pool_durations FALSE   
_gc_affinity_time 0   
_gc_undo_affinity FALSE   
_library_cache_advice FALSE   
_optim_peek_user_binds FALSE   
_undo_autotune FALSE   
audit_file_dest /oracle/admin/epmpln/adump   
background_dump_dest /oracle/admin/epmpln/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.5.0   
control_file_record_keep_time 100   
control_files /dev/vgsys/rlvsys_control1, /dev/vgsys/rlvsys_control2, /dev/vgsys/rlvsys_control3   
core_dump_dest /oracle/admin/epmpln/cdump   
db_block_size 8192   
db_cache_size 51539607552   
db_domain      
db_file_multiblock_read_count 32   
db_files 1024   
db_keep_cache_size 10737418240   
db_name epmpln   
instance_number 1   
job_queue_processes 10   
log_archive_dest_1 location=/emarch1   
log_archive_format arch_%t_%s_%r   
log_buffer 47194112   
open_cursors 5000   
optimizer_index_caching 90   
optimizer_index_cost_adj 50   
pga_aggregate_target 34359738368   
processes 3000   
recyclebin OFF   
remote_login_passwordfile EXCLUSIVE   
service_names      
session_cached_cursors 400   
sessions 3305   
sga_max_size 171798691840   
sga_target 171798691840   
shared_pool_size 12884901888   
spfile /dev/vgsys/rlvsys_spfile   
thread 1   
undo_management AUTO   
undo_retention 14400   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/admin/epmpln/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 17,253 4.78 0.47
acks for commit broadcast(logical) 17,840 4.94 0.49
broadcast msgs on commit(actual) 30,716 8.51 0.84
broadcast msgs on commit(logical) 30,786 8.53 0.84
broadcast msgs on commit(wasted) 1,304 0.36 0.04
broadcast on commit wait time(ms) 4,042 1.12 0.11
broadcast on commit waits 23,775 6.58 0.65
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 4 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 15,853 4.39 0.43
gcs ast xid 0 0.00 0.00
gcs blocked converts 1,427 0.40 0.04
gcs blocked cr converts 22,338 6.19 0.61
gcs compatible basts 84 0.02 0.00
gcs compatible cr basts (global) 222 0.06 0.01
gcs compatible cr basts (local) 134,239 37.17 3.67
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 485 0.13 0.01
gcs dbwr write request msgs 318 0.09 0.01
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 30,974 8.58 0.85
gcs immediate (null) converts 11,133 3.08 0.30
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 7,512,155 2,080.32 205.60
gcs indirect ast 12,202 3.38 0.33
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 105 0.03 0.00
gcs msgs process time(ms) 105,237 29.14 2.88
gcs msgs received 7,038,034 1,949.03 192.62
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 0 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 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 side channel msgs actual 85,524 23.68 2.34
gcs side channel msgs logical 769,823 213.19 21.07
gcs stale cr 0 0.00 0.00
gcs undo cr 0 0.00 0.00
gcs write notification msgs 17 0.00 0.00
gcs writes refused 2 0.00 0.00
ges msgs process time(ms) 6,563 1.82 0.18
ges msgs received 186,657 51.69 5.11
global posts dropped 0 0.00 0.00
global posts queue time 1 0.00 0.00
global posts queued 4 0.00 0.00
global posts requested 4 0.00 0.00
global posts sent 4 0.00 0.00
implicit batch messages received 38,551 10.68 1.06
implicit batch messages sent 921,707 255.25 25.23
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 82,692 22.90 2.26
messages queue sent actual 1,303,401 360.95 35.67
messages queue sent logical 7,607,822 2,106.82 208.22
messages received actual 1,216,232 336.81 33.29
messages received logical 7,224,604 2,000.69 197.73
messages sent directly 644,413 178.46 17.64
messages sent indirectly 7,526,346 2,084.25 205.99
messages sent not implicit batched 381,684 105.70 10.45
messages sent pbatched 7,183,425 1,989.29 196.60
msgs causing lmd to send msgs 108,765 30.12 2.98
msgs causing lms(s) to send msgs 3,486 0.97 0.10
msgs received queue time (ms) 13,790 3.82 0.38
msgs received queued 7,224,253 2,000.60 197.72
msgs sent queue time (ms) 346,185 95.87 9.47
msgs sent queue time on ksxp (ms) 497,018 137.64 13.60
msgs sent queued 7,605,866 2,106.27 208.16
msgs sent queued on ksxp 2,858,910 791.71 78.24
number of ges deadlock detected 0 0.00 0.00
process batch messages received 943,380 261.25 25.82
process batch messages sent 1,035,216 286.68 28.33


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 13,417
CURRENT Block Requests 129
Data Block Requests 13,417
Undo Block Requests 0
TX Block Requests 24
Current Results 13,522
Private results 1
Zero Results 23
Disk Read Results 0
Fail Results 0
Fairness Down Converts 3,132
Fairness Clears 0
Free GC Elements 0
Flushes 14
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 3
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 31,489 99.36 0.13 0.51 0.00 0.00
Flushes 4 75.00 25.00 0.00 0.00 0.00
Writes 513 51.85 45.22 0.78 1.36 0.78


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 39,866 99.50 0.01 0.49 238,043 97.85 0.00 2.15
2 Others 161 100.00 0.00 0.00 205 100.00 0.00 0.00
2 undo header 62 100.00 0.00 0.00 12 100.00 0.00 0.00
2 undo block 4 100.00 0.00 0.00 0      


Back to Top

End of Report