WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
CDLD2217133725cdld1110.2.0.4.0YESp780a

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:6549716-Jan-14 23:00:19883 93.7
End Snap:6549817-Jan-14 00:00:16883 93.5
Elapsed:  59.95 (mins)  
DB Time:  836.22 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 81,920M 81,920MStd Block Size: 8K
Shared Pool Size: 20,480M 20,480MLog Buffer: 276,284K

Load Profile

Per SecondPer Transaction
Redo size: 2,568,207.10 4,542.45
Logical reads: 110,623.77 195.66
Block changes: 13,636.80 24.12
Physical reads: 900.14 1.59
Physical writes: 643.63 1.14
User calls: 68.70 0.12
Parses: 85.94 0.15
Hard parses: 0.89 0.00
Sorts: 519.66 0.92
Logons: 0.26 0.00
Executes: 1,351.48 2.39
Transactions: 565.38 

% Blocks changed per Read: 12.33Recursive Call %: 98.36
Rollback per transaction %: 0.08Rows per Sort: 5.86

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.19In-memory Sort %: 100.00
Library Hit %: 99.91Soft Parse %: 98.97
Execute to Parse %: 93.64Latch Hit %: 99.96
Parse CPU to Parse Elapsd %: 1.75% Non-Parse CPU: 99.96

Shared Pool Statistics

BeginEnd
Memory Usage %: 89.67 89.67
% SQL with executions>1: 99.37 99.54
% Memory for SQL w/exec>1: 99.10 99.14

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
db file sequential read 3,233,885 16,448 5 32.8User I/O
Backup: sbtwrite2 7,472,909 10,895 1 21.7Administrative
CPU time  7,316  14.6 
Backup: sbtbackup 17 622 36,600 1.2Administrative
log file parallel write 1,802,129 537 0 1.1System I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 8.92 0.02
Global Cache blocks served: 4.88 0.01
GCS/GES messages received: 5,285.58 9.35
GCS/GES messages sent: 3,818.59 6.75
DBWR Fusion writes: 0.28 0.00
Estd Interconnect traffic (KB) 1,888.57 

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

Buffer access - local cache %: 99.18
Buffer access - remote cache %: 0.01
Buffer access - disk %: 0.81

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.2
Avg global cache cr block receive time (ms): 0.5
Avg global cache current block receive time (ms): 0.5
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 2.2
Avg global cache cr block flush time (ms): 0.6
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.2
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.3
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: 31.74
% of indirect sent messages: 34.76
% of flow controlled messages: 33.49

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 49,952.55 99.56
RMAN cpu time (backup/restore) 8,786.83 17.51
DB CPU 7,316.41 14.58
parse time elapsed 192.63 0.38
PL/SQL execution elapsed time 150.16 0.30
hard parse elapsed time 6.53 0.01
failed parse elapsed time 4.30 0.01
PL/SQL compilation elapsed time 0.69 0.00
hard parse (sharing criteria) elapsed time 0.60 0.00
sequence load elapsed time 0.48 0.00
connection management call elapsed time 0.20 0.00
repeated bind elapsed time 0.19 0.00
hard parse (bind mismatch) elapsed time 0.01 0.00
inbound PL/SQL rpc elapsed time 0.00 0.00
DB time 50,173.46  
background elapsed time 16,586.97  
background cpu time 9,559.63  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 3,238,127 0.00 16,454 5 1.59
Administrative 7,472,972 0.00 11,713 2 3.67
System I/O 3,406,572 0.00 1,172 0 1.68
Cluster 1,715,541 0.00 482 0 0.84
Other 613,682 85.46 278 0 0.30
Concurrency 10,987 0.03 269 24 0.01
Network 242,823 0.00 110 0 0.12
Application 6,016 0.00 4 1 0.00
Configuration 19,602 92.68 1 0 0.01
Commit 1,459 0.00 1 1 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 3,233,885 0.00 16,448 5 1.59
Backup: sbtwrite2 7,472,909 0.00 10,895 1 3.67
Backup: sbtbackup 17 0.00 622 36600 0.00
log file parallel write 1,802,129 0.00 537 0 0.89
db file parallel write 1,177,926 0.00 371 0 0.58
gc cr grant 2-way 1,232,237 0.00 346 0 0.61
library cache lock 5,927 0.00 261 44 0.00
enq: PS - contention 736 0.00 204 278 0.00
Backup: sbtclose2 18 0.00 176 9766 0.00
log file sequential read 368,305 0.00 174 0 0.18
gc current grant 2-way 422,378 0.00 118 0 0.21
LNS wait on SENDREQ 985 0.00 107 109 0.00
RMAN backup & recovery I/O 959 0.00 64 67 0.00
PX Deq: Signal ACK 215 77.67 37 170 0.00
Backup: sbtinfo2 18 0.00 19 1066 0.00
control file sequential read 43,409 0.00 15 0 0.02
gc current block 2-way 23,642 0.00 10 0 0.01
log switch/archive 1 100.00 10 9766 0.00
Log archive I/O 9,805 0.00 9 1 0.00
os thread startup 110 0.00 6 56 0.00
PX Deq Credit: send blkd 923 13.98 6 6 0.00
db file parallel read 455 0.00 5 11 0.00
enq: TT - contention 11,980 0.00 5 0 0.01
SQL*Net break/reset to client 5,686 0.00 4 1 0.00
DFS lock handle 6,118 0.00 3 1 0.00
gc cr block 2-way 6,680 0.00 3 0 0.00
SQL*Net more data from client 183 0.00 3 15 0.00
gc current multi block request 25,197 0.00 3 0 0.01
reliable message 287 0.70 2 9 0.00
CGS wait for IPC msg 446,936 100.00 2 0 0.22
control file parallel write 3,975 0.00 2 1 0.00
name-service call wait 30 0.00 2 67 0.00
enq: FB - contention 5,358 0.00 2 0 0.00
wait for scn ack 2,251 0.00 1 1 0.00
gc current grant busy 4,162 0.00 1 0 0.00
gc buffer busy 20 60.00 1 60 0.00
buffer busy waits 728 0.00 1 1 0.00
log file sync 1,459 0.00 1 1 0.00
IPC send completion sync 2,033 98.97 1 0 0.00
log file switch completion 43 0.00 1 19 0.00
enq: CF - contention 2,083 0.29 1 0 0.00
enq: HW - contention 1,381 0.00 1 0 0.00
row cache lock 2,051 0.00 0 0 0.00
enq: TC - contention 23 0.00 0 20 0.00
LGWR wait for redo copy 52,207 0.00 0 0 0.03
ksxr poll remote instances 61,011 94.34 0 0 0.03
db file scattered read 35 0.00 0 9 0.00
enq: TM - contention 235 0.00 0 1 0.00
direct path read 2,981 0.00 0 0 0.00
direct path read temp 24 0.00 0 11 0.00
gc cr multi block request 1,200 0.00 0 0 0.00
SQL*Net message to client 240,568 0.00 0 0 0.12
PX Deq: reap credit 19,471 90.51 0 0 0.01
gcs log flush sync 317 9.46 0 0 0.00
enq: TO - contention 322 0.00 0 0 0.00
gc current block busy 8 0.00 0 13 0.00
latch: cache buffers chains 2,127 0.00 0 0 0.00
latch free 38 0.00 0 2 0.00
control file single write 36 0.00 0 2 0.00
enq: JQ - contention 70 0.00 0 1 0.00
undo segment extension 18,176 99.96 0 0 0.01
enq: RS - prevent file delete 86 0.00 0 0 0.00
switch logfile command 2 0.00 0 16 0.00
enq: RO - fast object reuse 86 0.00 0 0 0.00
ges inquiry response 55 0.00 0 1 0.00
cursor: pin S wait on X 3 100.00 0 10 0.00
rdbms ipc reply 141 0.00 0 0 0.00
db file single write 75 0.00 0 0 0.00
SQL*Net more data to client 1,087 0.00 0 0 0.00
enq: BR - file shrink 38 0.00 0 0 0.00
gc cr block busy 17 0.00 0 1 0.00
library cache pin 36 0.00 0 0 0.00
enq: US - contention 23 0.00 0 0 0.00
latch: KCL gc element parent latch 704 0.00 0 0 0.00
enq: TA - contention 28 0.00 0 0 0.00
direct path write 671 0.00 0 0 0.00
log file single write 28 0.00 0 0 0.00
enq: CT - state 15 0.00 0 0 0.00
latch: session allocation 25 0.00 0 0 0.00
enq: WF - contention 11 0.00 0 0 0.00
read by other session 1 0.00 0 4 0.00
enq: PI - contention 10 0.00 0 0 0.00
Backup: sbtinit 2 0.00 0 2 0.00
enq: UL - contention 6 0.00 0 0 0.00
KJC: Wait for msg sends to complete 44 0.00 0 0 0.00
enq: WL - contention 4 0.00 0 1 0.00
latch: cache buffers lru chain 27 0.00 0 0 0.00
enq: WR - contention 4 0.00 0 0 0.00
enq: SQ - contention 1 0.00 0 1 0.00
enq: PW - flush prewarm buffers 3 0.00 0 0 0.00
enq: AF - task serialization 1 0.00 0 1 0.00
latch: object queue header operation 26 0.00 0 0 0.00
latch: shared pool 4 0.00 0 0 0.00
log buffer space 1 0.00 0 0 0.00
Backup: sbtend 2 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
latch: ges resource hash list 10 0.00 0 0 0.00
Backup: sbtcommand 2 0.00 0 0 0.00
buffer deadlock 6 100.00 0 0 0.00
cursor: pin S 12 0.00 0 0 0.00
latch: gcs resource hash 2 0.00 0 0 0.00
Backup: sbtinit2 2 0.00 0 0 0.00
SQL*Net message from client 240,566 0.00 2,262,192 9404 0.12
gcs remote message 10,418,284 82.67 126,077 12 5.12
jobq slave wait 7,917 98.90 23,004 2906 0.00
PX Idle Wait 4,567 84.43 10,020 2194 0.00
Streams AQ: qmn slave idle wait 383 0.00 7,012 18308 0.00
Streams AQ: waiting for time management or cleanup tasks 274 71.53 3,598 13132 0.00
Streams AQ: waiting for messages in the queue 738 98.51 3,514 4761 0.00
wait for unread message on broadcast channel 3,614 99.17 3,511 972 0.00
DIAG idle wait 17,972 0.00 3,511 195 0.01
EMON idle wait 731 98.22 3,510 4801 0.00
Streams AQ: qmn coordinator idle wait 385 32.99 3,506 9106 0.00
ges remote message 123,660 81.92 3,503 28 0.06
LNS ASYNC end of log 332,126 100.00 3,248 10 0.16
PX Deq: Execution Msg 4,137 34.95 2,721 658 0.00
PX Deq: Execute Reply 62 35.48 17 276 0.00
PX Deq: Join ACK 54 37.04 13 249 0.00
PX Deq: Parse Reply 54 38.89 12 222 0.00
PX Deq: Msg Fragment 1,967 54.25 0 0 0.00
class slave wait 4 0.00 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 385 100.00 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
log file parallel write 1,802,109 0.00 537 0 0.89
db file parallel write 1,177,926 0.00 371 0 0.58
log file sequential read 367,950 0.00 172 0 0.18
LNS wait on SENDREQ 985 0.00 107 109 0.00
events in waitclass Other 571,981 88.29 30 0 0.28
Log archive I/O 9,456 0.00 8 1 0.00
control file sequential read 22,556 0.00 7 0 0.01
os thread startup 110 0.00 6 56 0.00
control file parallel write 3,454 0.00 2 1 0.00
db file sequential read 12 0.00 0 25 0.00
row cache lock 426 0.00 0 1 0.00
gc cr block 2-way 545 0.00 0 0 0.00
direct path read 2,936 0.00 0 0 0.00
enq: TM - contention 234 0.00 0 1 0.00
gc current block 2-way 235 0.00 0 0 0.00
gc current grant busy 95 0.00 0 0 0.00
enq: RO - fast object reuse 86 0.00 0 0 0.00
gc cr multi block request 52 0.00 0 0 0.00
buffer busy waits 148 0.00 0 0 0.00
library cache lock 26 0.00 0 0 0.00
log file single write 28 0.00 0 0 0.00
gc current grant 2-way 23 0.00 0 0 0.00
direct path write 656 0.00 0 0 0.00
library cache pin 18 0.00 0 0 0.00
gc current block busy 1 0.00 0 1 0.00
log buffer space 1 0.00 0 0 0.00
latch: cache buffers chains 23 0.00 0 0 0.00
gcs remote message 10,418,299 82.67 126,077 12 5.12
rdbms ipc message 1,637,580 3.61 75,197 46 0.81
Streams AQ: qmn slave idle wait 383 0.00 7,012 18308 0.00
Streams AQ: waiting for time management or cleanup tasks 274 71.53 3,598 13132 0.00
DIAG idle wait 17,973 0.00 3,511 195 0.01
EMON idle wait 731 98.22 3,510 4801 0.00
pmon timer 1,212 100.00 3,507 2893 0.00
Streams AQ: qmn coordinator idle wait 385 32.99 3,506 9106 0.00
ges remote message 123,665 81.92 3,503 28 0.06
smon timer 64,391 1.14 3,494 54 0.03
LNS ASYNC end of log 332,125 100.00 3,248 10 0.16
PX Deq: Execute Reply 39 38.46 9 230 0.00
PX Deq: Join ACK 30 40.00 8 277 0.00
PX Deq: Parse Reply 30 40.00 8 261 0.00
Streams AQ: RAC qmn coordinator idle wait 385 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 49,840.50 7,138.40 3,039,109 363,517,667
cdld 350.70 178.10 196,351 31,553,592
SYS$BACKGROUND 0.00 0.00 3,706 2,823,838

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 3036899 1639134 9727 26205 7472994 1171254 149294 16
cdld 196351 5725 437 21 0 0 92321 6
SYS$BACKGROUND 4894 571 813 649 0 0 985 10715

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
3,510 113 0   7.00 9pvmj3q1cdzjf PL/SQL Developer DECLARE S_AKB020 VARCHAR2(3...
3,510 2,047 0   7.00 2ma2h79ga40xt   begin pkg_P_peddleryBankPlan.p...
3,510 2,047 0   7.00 9n4t5dggv4xmf   DECLARE job BINARY_INTEGER := ...
3,510 75 0   7.00 76tj3ydckv1zh PL/SQL Developer DECLARE S_AKB020 VARCHAR2(3...
3,510 2,172 0   7.00 ctjd4zjkwtzd4 PL/SQL Developer -- Created on 2014/1/16 by ADM...
3,510 586 0   7.00 dw1r4570txun4 PL/SQL Developer DECLARE S_AKC190 VARCHAR2(30...
3,508 2,171 6,788 0.52 6.99 2f1ysgumu2xm8 PL/SQL Developer INSERT INTO YH00_2013_SF SELEC...
3,507 75 18,153 0.19 6.99 fcs9k9n13g2qj PL/SQL Developer UPDATE YH00_CX_ZKZFQK M SET M....
3,490 104 184 18.97 6.96 0j9j9wz41t8f3 PL/SQL Developer SELECT (SELECT M.YKD064 FROM K...
3,030 1,041 685,393 0.00 6.04 f0965dzx1vkh4 PL/SQL Developer INSERT INTO YH00_KC24K1UNIONKC...
1,703 55 1 1703.35 3.39 cjzvy1p7cpm3w   DECLARE job BINARY_INTEGER := ...
1,703 55 1 1703.32 3.39 csjnw12bztq13   begin pkg_prc_control.prc_pedd...
1,687 54 1 1686.85 3.36 fbjk8zytbx6bm   DECLARE job BINARY_INTEGER := ...
1,687 54 1 1686.85 3.36 13jg558pwq85n   begin pkg_prc_control.prc_pedd...
1,666 49 1 1666.27 3.32 2ua81jgsmfanc   DECLARE job BINARY_INTEGER := ...
1,666 49 1 1666.27 3.32 bxk65jdxjq28p   begin pkg_prc_control.prc_pedd...
1,602 1,025 82,121 0.02 3.19 czfu3p9zwchc0 JDBC Thin Client INSERT INTO AB15A1 (AAC008, Y...
760 659 82,122 0.01 1.51 3j27p10h5j7ht JDBC Thin Client SELECT YAB136, AAB020 FROM AB...
702 648 82,121 0.01 1.40 5hab2vxpa4pqx JDBC Thin Client SELECT SEQ_A_AAE068.NEXTVAL FR...
672 229 18 37.31 1.34 9k6ajgwq410st   SELECT DISTINCT AAE076 FROM AD...
668 324 82,121 0.01 1.33 911y3badh7v5h JDBC Thin Client INSERT INTO AD04A1 (AAE076, A...
597 62 1 596.98 1.19 9ufxybd8n97ty   DECLARE job BINARY_INTEGER := ...
597 62 1 596.97 1.19 0j9aqx2jc5k3q   begin pkg_prc_control.prc_pedd...
521 14 4,705 0.11 1.04 01ad3nku2zq10   INSERT INTO IC01( YAE202, AAB...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
2,172 3,510 0   7.00 ctjd4zjkwtzd4 PL/SQL Developer -- Created on 2014/1/16 by ADM...
2,171 3,508 6,788 0.32 6.99 2f1ysgumu2xm8 PL/SQL Developer INSERT INTO YH00_2013_SF SELEC...
2,047 3,510 0   7.00 2ma2h79ga40xt   begin pkg_P_peddleryBankPlan.p...
2,047 3,510 0   7.00 9n4t5dggv4xmf   DECLARE job BINARY_INTEGER := ...
1,041 3,030 685,393 0.00 6.04 f0965dzx1vkh4 PL/SQL Developer INSERT INTO YH00_KC24K1UNIONKC...
1,025 1,602 82,121 0.01 3.19 czfu3p9zwchc0 JDBC Thin Client INSERT INTO AB15A1 (AAC008, Y...
659 760 82,122 0.01 1.51 3j27p10h5j7ht JDBC Thin Client SELECT YAB136, AAB020 FROM AB...
648 702 82,121 0.01 1.40 5hab2vxpa4pqx JDBC Thin Client SELECT SEQ_A_AAE068.NEXTVAL FR...
586 3,510 0   7.00 dw1r4570txun4 PL/SQL Developer DECLARE S_AKC190 VARCHAR2(30...
324 668 82,121 0.00 1.33 911y3badh7v5h JDBC Thin Client INSERT INTO AD04A1 (AAE076, A...
229 672 18 12.71 1.34 9k6ajgwq410st   SELECT DISTINCT AAE076 FROM AD...
113 3,510 0   7.00 9pvmj3q1cdzjf PL/SQL Developer DECLARE S_AKB020 VARCHAR2(3...
104 3,490 184 0.56 6.96 0j9j9wz41t8f3 PL/SQL Developer SELECT (SELECT M.YKD064 FROM K...
75 3,507 18,153 0.00 6.99 fcs9k9n13g2qj PL/SQL Developer UPDATE YH00_CX_ZKZFQK M SET M....
75 3,510 0   7.00 76tj3ydckv1zh PL/SQL Developer DECLARE S_AKB020 VARCHAR2(3...
62 597 1 62.36 1.19 9ufxybd8n97ty   DECLARE job BINARY_INTEGER := ...
62 597 1 62.35 1.19 0j9aqx2jc5k3q   begin pkg_prc_control.prc_pedd...
55 1,703 1 55.40 3.39 cjzvy1p7cpm3w   DECLARE job BINARY_INTEGER := ...
55 1,703 1 55.39 3.39 csjnw12bztq13   begin pkg_prc_control.prc_pedd...
54 1,687 1 54.48 3.36 13jg558pwq85n   begin pkg_prc_control.prc_pedd...
54 1,687 1 54.48 3.36 fbjk8zytbx6bm   DECLARE job BINARY_INTEGER := ...
49 1,666 1 49.44 3.32 2ua81jgsmfanc   DECLARE job BINARY_INTEGER := ...
49 1,666 1 49.44 3.32 bxk65jdxjq28p   begin pkg_prc_control.prc_pedd...
14 521 4,705 0.00 1.04 01ad3nku2zq10   INSERT INTO IC01( YAE202, AAB...

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
193,246,869 6,788 28,468.90 48.56 2170.67 3508.26 2f1ysgumu2xm8 PL/SQL Developer INSERT INTO YH00_2013_SF SELEC...
193,225,252 0   48.56 2171.68 3509.77 ctjd4zjkwtzd4 PL/SQL Developer -- Created on 2014/1/16 by ADM...
90,524,680 0   22.75 585.91 3509.77 dw1r4570txun4 PL/SQL Developer DECLARE S_AKC190 VARCHAR2(30...
38,891,178 6 6,481,863.00 9.77 279.92 423.54 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
37,866,501 685,393 55.25 9.52 1041.07 3030.46 f0965dzx1vkh4 PL/SQL Developer INSERT INTO YH00_KC24K1UNIONKC...
34,107,655 685,388 49.76 8.57 104.22 105.38 7b2c0ktaqd6fx PL/SQL Developer SELECT A.AKC190 FROM YH01_SL_K...
32,925,918 37,506 877.88 8.27 233.62 359.00 a6ws36ztq6vhq   SELECT COUNT(1) FROM CC72 A, ...
27,647,298 39 708,905.08 6.95 137.58 270.26 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
10,223,747 0   2.57 2046.97 3509.78 2ma2h79ga40xt   begin pkg_P_peddleryBankPlan.p...
10,223,747 0   2.57 2046.97 3509.78 9n4t5dggv4xmf   DECLARE job BINARY_INTEGER := ...
8,306,323 685,390 12.12 2.09 112.70 112.71 3mkbk42c6c74n PL/SQL Developer UPDATE YH01_SL_KC21K1 SET BZ =...
8,251,555 685,387 12.04 2.07 97.91 101.31 62z9n48tdtdzv PL/SQL Developer UPDATE YH01_SL_KC21K1 SET BZ =...
8,128,830 82,121 98.99 2.04 323.97 668.24 911y3badh7v5h JDBC Thin Client INSERT INTO AD04A1 (AAE076, A...
6,608,147 0   1.66 112.86 3509.81 9pvmj3q1cdzjf PL/SQL Developer DECLARE S_AKB020 VARCHAR2(3...
4,726,047 184 25,685.04 1.19 103.80 3489.84 0j9j9wz41t8f3 PL/SQL Developer SELECT (SELECT M.YKD064 FROM K...

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
656,515 18,153 36.17 20.28 74.86 3506.83 fcs9k9n13g2qj PL/SQL Developer UPDATE YH00_CX_ZKZFQK M SET M....
656,290 0   20.27 74.53 3509.77 76tj3ydckv1zh PL/SQL Developer DECLARE S_AKB020 VARCHAR2(3...
607,662 0   18.77 585.91 3509.77 dw1r4570txun4 PL/SQL Developer DECLARE S_AKC190 VARCHAR2(30...
603,834 685,393 0.88 18.65 1041.07 3030.46 f0965dzx1vkh4 PL/SQL Developer INSERT INTO YH00_KC24K1UNIONKC...
532,043 184 2,891.54 16.43 103.80 3489.84 0j9j9wz41t8f3 PL/SQL Developer SELECT (SELECT M.YKD064 FROM K...
531,818 0   16.42 112.86 3509.81 9pvmj3q1cdzjf PL/SQL Developer DECLARE S_AKB020 VARCHAR2(3...
309,703 18 17,205.72 9.56 228.72 671.55 9k6ajgwq410st   SELECT DISTINCT AAE076 FROM AD...
194,502 1 194,502.00 6.01 55.40 1703.35 cjzvy1p7cpm3w   DECLARE job BINARY_INTEGER := ...
194,500 1 194,500.00 6.01 55.39 1703.32 csjnw12bztq13   begin pkg_prc_control.prc_pedd...
193,489 1 193,489.00 5.98 54.48 1686.85 13jg558pwq85n   begin pkg_prc_control.prc_pedd...
193,489 1 193,489.00 5.98 54.48 1686.85 fbjk8zytbx6bm   DECLARE job BINARY_INTEGER := ...
190,453 1 190,453.00 5.88 49.44 1666.27 2ua81jgsmfanc   DECLARE job BINARY_INTEGER := ...
190,453 1 190,453.00 5.88 49.44 1666.27 bxk65jdxjq28p   begin pkg_prc_control.prc_pedd...
150,111 39 3,849.00 4.64 137.58 270.26 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
99,818 1 99,818.00 3.08 29.79 499.41 67d54579qy6dj   DECLARE job BINARY_INTEGER := ...
99,818 1 99,818.00 3.08 29.79 499.40 93nzp5fx0by8m   begin pkg_prc_control.prc_pedd...
86,714 0   2.68 2171.68 3509.77 ctjd4zjkwtzd4 PL/SQL Developer -- Created on 2014/1/16 by ADM...
86,646 6,788 12.76 2.68 2170.67 3508.26 2f1ysgumu2xm8 PL/SQL Developer INSERT INTO YH00_2013_SF SELEC...
76,993 0   2.38 2046.97 3509.78 2ma2h79ga40xt   begin pkg_P_peddleryBankPlan.p...
76,993 0   2.38 2046.97 3509.78 9n4t5dggv4xmf   DECLARE job BINARY_INTEGER := ...
70,706 82,121 0.86 2.18 323.97 668.24 911y3badh7v5h JDBC Thin Client INSERT INTO AD04A1 (AAE076, A...
62,990 4,705 13.39 1.95 13.51 520.80 01ad3nku2zq10   INSERT INTO IC01( YAE202, AAB...
62,890 1 62,890.00 1.94 62.35 596.97 0j9aqx2jc5k3q   begin pkg_prc_control.prc_pedd...
62,890 1 62,890.00 1.94 62.36 596.98 9ufxybd8n97ty   DECLARE job BINARY_INTEGER := ...
56,713 1,233 46.00 1.75 9.71 488.91 2bj93t0d0fhhn   INSERT INTO KC82( YAE202, AAB...
49,465 1,251 39.54 1.53 8.20 405.02 76jfs9110c9fq   INSERT INTO KC03( YAE202, AAB...
48,886 614 79.62 1.51 7.27 426.37 du910b77fbbzv   INSERT INTO JC01( YAE202, AAB...
40,769 619 65.86 1.26 6.49 333.20 9ryg7fzy8x9xg   INSERT INTO LC10( YAE202, AAB...
32,746 618 52.99 1.01 5.09 275.18 3gtkhqnqqt758   INSERT INTO LC10L3( YAE202, A...

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
685,393 715,257 1.04 0.00 0.00 f0965dzx1vkh4 PL/SQL Developer INSERT INTO YH00_KC24K1UNIONKC...
685,390 685,390 1.00 0.00 0.00 3mkbk42c6c74n PL/SQL Developer UPDATE YH01_SL_KC21K1 SET BZ =...
685,388 685,388 1.00 0.00 0.00 7b2c0ktaqd6fx PL/SQL Developer SELECT A.AKC190 FROM YH01_SL_K...
685,387 685,387 1.00 0.00 0.00 62z9n48tdtdzv PL/SQL Developer UPDATE YH01_SL_KC21K1 SET BZ =...
192,661 192,636 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
82,122 82,122 1.00 0.01 0.01 3j27p10h5j7ht JDBC Thin Client SELECT YAB136, AAB020 FROM AB...
82,121 82,121 1.00 0.01 0.01 5hab2vxpa4pqx JDBC Thin Client SELECT SEQ_A_AAE068.NEXTVAL FR...
82,121 82,121 1.00 0.00 0.01 911y3badh7v5h JDBC Thin Client INSERT INTO AD04A1 (AAE076, A...
82,121 82,121 1.00 0.01 0.02 czfu3p9zwchc0 JDBC Thin Client INSERT INTO AB15A1 (AAC008, Y...
37,506 37,506 1.00 0.01 0.01 a6ws36ztq6vhq   SELECT COUNT(1) FROM CC72 A, ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
192,674 192,661 62.33 2ym6hhaq30r73   select type#, blocks, extents,...
2,879 2,879 0.93 5aa4qy7098w5k   SELECT seq, message#, fac, hdr...
2,578 2,578 0.83 grwydz59pu6mc   select text from view$ where r...
2,252 2,252 0.73 bsa0wjtftg3uw   select file# from file$ where ...
1,180 26,888 0.38 a9tw6wzcnuhc7   SELECT COUNT(*) FROM AC01A2 WH...
1,175 26,888 0.38 21nu6hk03af9m   SELECT COUNT(*) FROM AA94 WHER...
1,158 26,888 0.37 fvydfb8k9ypjn   SELECT COUNT(1) FROM AC25 WHER...
1,124 1,206 0.36 5qcsazjun2h9c   SELECT AAB165 FROM AB08 WHERE ...
1,118 1,208 0.36 fk16s4326pt1y   UPDATE AB08 SET YAB040 = NVL(Y...
978 5,497 0.32 44dyf2pgs7xvh   SELECT AAE076 FROM AD04A1 WHER...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
11,158,864 0 0.05 710mp6r3fujag emagent_SQL_rac_database select capture_name streams_...
10,279,785 3 0.05 83gbn49knry1z JDBC Thin Client select /*+ RESULT_CACHE */aaa1...
8,828,730 285 0.04 8hzay2zw3yc4x JDBC Thin Client select aaa103 from cdsi2.aa10...
6,857,118 1 0.03 6chnq116xhjgr JDBC Thin Client select /*+ RESULT_CACHE */aaa1...
6,849,079 1 0.03 7mwrcjvtw1tz6 JDBC Thin Client select /*+ RESULT_CACHE */aaa1...
4,128,353 1 0.02 5b6yvng00bn76   SELECT t.* FROM(select aae07...
3,972,260 0 0.02 26zpagbuyygf9 emagent@p780b (TNS V1-V3) /* OracleOEM */ S...
3,373,917 0 0.02 5z6m72y6knsfr emagent_SQL_rac_database SELECT m.tablespace_name, m....
3,098,039 1 0.01 15pf0yqrmk8r0   SELECT t.* FROM(select aae07...
2,534,898 0 0.01 501kary3x38sj emagent_SQL_rac_database select r.apply_name apply_na...
1,800,750 0 0.01 3y9bat7nwcjy5 DBMS_SCHEDULER SELECT ELAPSED_TIME FROM DBA_S...
1,534,270 0 0.01 3y9bat7nwcjy5 DBMS_SCHEDULER SELECT ELAPSED_TIME FROM DBA_S...
1,338,708 82,121 0.01 911y3badh7v5h JDBC Thin Client INSERT INTO AD04A1 (AAE076, A...
1,280,238 3 0.01 da1pz1v3wu12d rman@p780a (TNS V1-V3) SELECT decode(count(distinct d...
1,208,103 3 0.01 g5g0whrt4ngqt JDBC Thin Client SELECT 1 FROM USER_TAB_COLUMNS...
1,186,660 0 0.01 bhjxxwujr3ac3 perl@p780a (TNS V1-V3) SELECT distinct ast.name, mt...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
50 0 3y9bat7nwcjy5 DBMS_SCHEDULER SELECT ELAPSED_TIME FROM DBA_S...
50 0 3y9bat7nwcjy5 DBMS_SCHEDULER SELECT ELAPSED_TIME FROM DBA_S...
45 82,121 911y3badh7v5h JDBC Thin Client INSERT INTO AD04A1 (AAE076, A...
42 0 710mp6r3fujag emagent_SQL_rac_database select capture_name streams_...
31 3 da1pz1v3wu12d rman@p780a (TNS V1-V3) SELECT decode(count(distinct d...
30 0 bkbp21n9f0p4z perl@p780a (TNS V1-V3) SELECT s.name, s.inst_id, i...
29 1,229 0z45hcav2cpnj   select yab275 from AD53...
29 1,229 0z45hcav2cpnj   select yab275 from AD53...
28 0 26zpagbuyygf9 emagent@p780b (TNS V1-V3) /* OracleOEM */ S...
28 0 5z6m72y6knsfr emagent_SQL_rac_database SELECT m.tablespace_name, m....
28 0 bhjxxwujr3ac3 perl@p780a (TNS V1-V3) SELECT distinct ast.name, mt...
26 15 dbffgzt7bkp1s JDBC Thin Client SELECT COUNT(1) FROM AD53A4 A,...
25 1 8zjmhqrtjgpwk JDBC Thin Client SELECT COUNT(*) FROM KC82K1 WH...
25 3 g5g0whrt4ngqt JDBC Thin Client SELECT 1 FROM USER_TAB_COLUMNS...
25 3 g5g0whrt4ngqt JDBC Thin Client SELECT 1 FROM USER_TAB_COLUMNS...
23 8 bqfx5q2jas08u emagent@p780a (TNS V1-V3) SELECT TASK_LIST.TASK_ID FROM ...
23 8 bqfx5q2jas08u emagent@p780a (TNS V1-V3) SELECT TASK_LIST.TASK_ID FROM ...
22 47 4h3tnm388am71   UPDATE ad53a5 SET yae361 = ...
21 47 2gy6aw7w4v301   SELECT yae092, aae036, aae100,...
21 216 c3hhngpbpvvmk SEVERITY EVALUATION SELECT MARKER_TIMESTAMP FROM M...

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
92.51 2.64 3,506.83 74.86 18,153 fcs9k9n13g2qj PL/SQL Developer UPDATE YH00_CX_ZKZFQK M SET M....
92.48 2.63 3,509.77 74.53 0 76tj3ydckv1zh PL/SQL Developer DECLARE S_AKB020 VARCHAR2(3...
90.79 2.59 3,509.77 585.91 0 dw1r4570txun4 PL/SQL Developer DECLARE S_AKC190 VARCHAR2(30...
89.18 2.94 3,030.46 1,041.07 685,393 f0965dzx1vkh4 PL/SQL Developer INSERT INTO YH00_KC24K1UNIONKC...
79.88 2.28 3,509.81 112.86 0 9pvmj3q1cdzjf PL/SQL Developer DECLARE S_AKB020 VARCHAR2(3...
79.56 2.28 3,489.84 103.80 184 0j9j9wz41t8f3 PL/SQL Developer SELECT (SELECT M.YKD064 FROM K...
42.93 6.39 671.55 228.72 18 9k6ajgwq410st   SELECT DISTINCT AAE076 FROM AD...
30.30 1.78 1,703.35 55.40 1 cjzvy1p7cpm3w   DECLARE job BINARY_INTEGER := ...
30.30 1.78 1,703.32 55.39 1 csjnw12bztq13   begin pkg_prc_control.prc_pedd...
29.51 1.75 1,686.85 54.48 1 13jg558pwq85n   begin pkg_prc_control.prc_pedd...
29.51 1.75 1,686.85 54.48 1 fbjk8zytbx6bm   DECLARE job BINARY_INTEGER := ...
29.38 1.76 1,666.27 49.44 1 2ua81jgsmfanc   DECLARE job BINARY_INTEGER := ...
29.38 1.76 1,666.27 49.44 1 bxk65jdxjq28p   begin pkg_prc_control.prc_pedd...
20.77 7.68 270.26 137.58 39 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
15.02 3.01 499.41 29.79 1 67d54579qy6dj   DECLARE job BINARY_INTEGER := ...
15.02 3.01 499.40 29.79 1 93nzp5fx0by8m   begin pkg_prc_control.prc_pedd...
13.98 0.40 3,509.77 2,171.68 0 ctjd4zjkwtzd4 PL/SQL Developer -- Created on 2014/1/16 by ADM...
13.98 0.40 3,508.26 2,170.67 6,788 2f1ysgumu2xm8 PL/SQL Developer INSERT INTO YH00_2013_SF SELEC...
11.00 0.31 3,509.78 2,046.97 0 2ma2h79ga40xt   begin pkg_P_peddleryBankPlan.p...
11.00 0.31 3,509.78 2,046.97 0 9n4t5dggv4xmf   DECLARE job BINARY_INTEGER := ...
10.30 1.54 668.24 323.97 82,121 911y3badh7v5h JDBC Thin Client INSERT INTO AD04A1 (AAE076, A...
9.76 1.63 596.97 62.35 1 0j9aqx2jc5k3q   begin pkg_prc_control.prc_pedd...
9.76 1.63 596.98 62.36 1 9ufxybd8n97ty   DECLARE job BINARY_INTEGER := ...
9.01 1.73 520.80 13.51 4,705 01ad3nku2zq10   INSERT INTO IC01( YAE202, AAB...
8.13 1.66 488.91 9.71 1,233 2bj93t0d0fhhn   INSERT INTO KC82( YAE202, AAB...
7.17 1.77 405.02 8.20 1,251 76jfs9110c9fq   INSERT INTO KC03( YAE202, AAB...
6.92 1.62 426.37 7.27 614 du910b77fbbzv   INSERT INTO JC01( YAE202, AAB...
5.80 1.74 333.20 6.49 619 9ryg7fzy8x9xg   INSERT INTO LC10( YAE202, AAB...
4.72 1.72 275.18 5.09 618 3gtkhqnqqt758   INSERT INTO LC10L3( YAE202, A...
2.50 2.03 123.20 4.10 619 3v81f1y0khj46   DELETE LC10L1 A WHERE EXISTS(S...
1.89 1.58 119.84 14.08 12,801 6a5xdfgafb00d   SELECT AAE002 FROM KC82 WHERE ...
1.23 1.21 101.31 97.91 685,387 62z9n48tdtdzv PL/SQL Developer UPDATE YH01_SL_KC21K1 SET BZ =...
0.88 2.12 41.46 2.10 619 8yacyt32bayx9   DELETE LC10L2 WHERE AAE076 = :...
0.72 0.04 1,601.62 1,025.23 82,121 czfu3p9zwchc0 JDBC Thin Client INSERT INTO AB15A1 (AAC008, Y...
0.42 1.84 22.69 5.05 5,108 96az0qfha9q6t   INSERT INTO AB15( AAE068, AAE...
0.42 2.31 18.06 6.66 5,118 2syt553rnawzg   UPDATE AD04A1 SET YAA011 = :B1...
0.29 0.07 423.54 279.92 6 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
0.28 1.58 17.95 3.91 1,208 fk16s4326pt1y   UPDATE AB08 SET YAB040 = NVL(Y...
0.23 2.71 8.56 2.97 5,108 9wjb9xj5uy9ju   DELETE FROM AB15A1 WHERE AAE07...
0.22 0.19 112.71 112.70 685,390 3mkbk42c6c74n PL/SQL Developer UPDATE YH01_SL_KC21K1 SET BZ =...
0.21 0.19 105.38 104.22 685,388 7b2c0ktaqd6fx PL/SQL Developer SELECT A.AKC190 FROM YH01_SL_K...
0.17 1.42 12.01 1.41 619 0hvpvwkgf0njg   INSERT INTO TMP_LC10L1( YAE202...
0.15 2.13 7.06 1.70 624 f6rzw79yf94jj   SELECT SUM( NVL(YLC237, 0)+ NV...
0.09 7.62 1.24 1.20 12,809 7bv08yw84kyym JDBC Thin Client SELECT YAB136 FROM AB01 WHERE ...
0.08 1.67 5.07 3.14 6,689 fzyyh6dg11312   SELECT YAA012, YAA011, AAB19...
0.07 0.80 8.40 8.40 192,661 2ym6hhaq30r73   select type#, blocks, extents,...
0.07 26.36 0.25 0.25 2,879 5aa4qy7098w5k   SELECT seq, message#, fac, hdr...
0.06 4.05 1.42 1.42 5,497 44dyf2pgs7xvh   SELECT AAE076 FROM AD04A1 WHER...
0.05 74.04 0.07 0.07 216 c3hhngpbpvvmk SEVERITY EVALUATION SELECT MARKER_TIMESTAMP FROM M...
0.05 1.08 4.20 2.65 26,888 fvydfb8k9ypjn   SELECT COUNT(1) FROM AC25 WHER...
0.04 62.88 0.06 0.04 8 bqfx5q2jas08u emagent@p780a (TNS V1-V3) SELECT TASK_LIST.TASK_ID FROM ...
0.02 11.16 0.19 0.12 780 9hkpknh64tfvw JDBC Thin Client select yab003 as yab139 from ...
0.01 0.30 2.15 1.89 26,888 a9tw6wzcnuhc7   SELECT COUNT(*) FROM AC01A2 WH...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
01ad3nku2zq10INSERT INTO IC01( YAE202, AAB001, AAC001, AAE003, AAE002, YAE010, YAE203, AAE143, AIC020, AAA041, YIC509, YAA017, AAA042, AAA043, YIC486, YIC487, YIC488, YIC510, YIC600, YIC599, YIC224, YIC225, YIC226, AAE037, YAE204, AAE114, AIC024, AIC025, AIC026, AIC027, YIC227, YIC228, YIC229, AAE038, YAE205, AAE115, AAE061, YAE206, AAE076, YAB003, YIC585, YAE211, AAE120, AAE011, YAC210, YAC211, YAC212, AAE036) SELECT YAE202, AAB001, AAC001, AAE003, AAE002, YAE010, YAE203, AAE143, AIC020, AAA041, YIC509, YAA017, AAA042, AAA043, YIC486, YIC487, YIC488, YIC510, YIC600, YIC599, YIC224, YIC225, YIC226, AAE037, YAE204, AAE114, AIC024, AIC025, AIC026, AIC027, YIC227, YIC228, YIC229, AAE038, YAE205, AAE115, AAE061, YAE206, AAE076, YAB003, YIC585, AAC001, :B2 , AAE011, YAC210, YAC211, YAC212, AAE036 FROM TMP_IC01I1 WHERE AAE076 = :B1
0hvpvwkgf0njgINSERT INTO TMP_LC10L1( YAE202, AAB001, AAC001, AAE003, AAE002, AAE143, ALC001, AAA042, YAE010, YAE203, YLC237, YLC238, YLC239, YLC229, AAE038, YAE205, AAE115, YAE206, AAE061, AAE076, YAB003, AAE011, YAC210, YAC211, YAC212, AAE036) SELECT A.YAE202, A.AAB001, A.AAC001, A.AAE003, A.AAE002, A.AAE143, A.ALC001, A.AAA042, A.YAE010, A.YAE203, A.YLC237, A.YLC238, A.YLC239, A.YLC229, A.AAE038, A.YAE205, A.AAE115, A.YAE206, A.AAE061, A.AAE076, A.YAB003, A.AAE011, A.YAC210, A.YAC211, A.YAC212, A.AAE036 FROM TMP_LC10L2 A, LC10L1 B WHERE A.AAE076 = :B1 AND A.YAE202 = B.YAE202 AND NVL(A.YLC237, 0) = NVL(B.YLC237, 0) AND NVL(A.YLC238, 0) = NVL(B.YLC238, 0) AND NVL(A.YLC239, 0) = NVL(B.YLC239, 0)
0j9aqx2jc5k3qbegin pkg_prc_control.prc_pedderyBank_timing(25008079, '100000575907216', '100000575911892', :prm_AppCode, :prm_errmsg) ; end ;
0j9j9wz41t8f3 SELECT (SELECT M.YKD064 FROM KB01 M WHERE B.AKB020 = M.AKB020) AS YKD064, B.AKC190, B.YKA103, B.YKD007, B.YKA032, B.AKB020, (SELECT M.AKB021 FROM KB01 M WHERE B.AKB020 = M.AKB020) AS AKB021, (SELECT M.AKB023 FROM KB01 M WHERE B.AKB020 = M.AKB020) AS AKB023, (SELECT M.AKA101 FROM KB01 M WHERE B.AKB020 = M.AKB020) AS AKA101, B.AAC001, NULL AS AAC003, NULL AS AKC021, B.YKA054, B.YKC121, NULL AS AKB063, B.YKA055, NULL AS YKA056, NULL AS YKA057, NULL AS YKA111, B.YKA107, (SELECT SUM(M.YKA107) FROM KC24KB M WHERE B.AKC190 = M.AKC190) AS DBZF, B.YKC125, B.YKA058, NULL AS YKC148, B.YKB010, (SELECT M.YKB053 FROM KB03K9 M WHERE B.AKC190 = M.AKC190 AND B.YKA103 = M.YKA103 AND B.YKD007 = M.YKD007 AND B.YKA316 = M.YKA316) AS YKB053, B.YKA316, B.AAE036, '0101' AS XZLB, CASE WHEN B.YKA054 IN ('02', '03') THEN (SELECT G.YKC139 + G.YKC182 FROM CDSI2.KB11K9 G WHERE G.AKC190 = B.AKC190 AND G.YKA103 = B.YKA103 AND G.YKD007 = B.YKD007) ELSE 0 END AS DEZFJE, 0 AS YPF, TO_CHAR(B.AAE036, 'yyyymm') AS AAE002, NVL((SELECT E.YKA324 FROM CDSI2.KB09K4 E WHERE E.AKC190 = B.AKC190 AND E.YKA103 = B.YKA103 AND E.YKD007 = B.YKD007 AND E.AKA213 = '0101'), 0) AS YKA324, NVL((SELECT M.YKD088 FROM KB03K9 M WHERE B.AKC190 = M.AKC190 AND B.YKA103 = M.YKA103 AND B.YKD007 = M.YKD007 AND B.YKA316 = M.YKA316), 0) AS YKD088, TO_CHAR(SYSDATE, 'yyyymmdd') AS ZXSJ, (SELECT M.YKE248 FROM KB03K9 M WHERE B.AKC190 = M.AKC190 AND B.YKA103 = M.YKA103 AND B.YKD007 = M.YKD007 AND B.YKA316 = M .YKA316) AS YKE248, B.AKA130 FROM KC24K2 B WHERE B.YKA316 ='31' AND B.AKA213 = '0101' AND B.AKB020 = :B1 AND B.YKA107 <> 0 AND B.YKA032 = '2' AND B.AAE036 BETWEEN TO_DATE('2013-06-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2013-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS') AND 1 = (SELECT COUNT(DISTINCT E.YKD007) FROM KC24K2 E WHERE B.AKC190 = E.AKC190 AND B.YKA103 = E.YKA103)
0z45hcav2cpnj select yab275 from AD53A4 where yae092 = :1
13jg558pwq85nbegin pkg_prc_control.prc_pedderybankunit_timing(1000046, '100000574282061', '100000574997993', :prm_AppCode, :prm_errmsg) ; end ;
15pf0yqrmk8r0 SELECT t.* FROM(select aae076 , yad063 , yad064 , yad067, yad052 , yaa009, yad060 , sum(yaa007) as t_yaa007, SUM(yaa008) AS t_yaa008, trunc(yad009) as yad009, yaa011 , yaa012 , yad092, yaa014, aab191, CASE WHEN (SELECT COUNT(1) FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1) END yae205, aae011 , trunc(aae036) as aae036 from ad04a1 a where aad030='ab15a1' and yad063 = :1 AND yaa009 = :2 AND yad067 BETWEEN :3 AND :4 AND yab003 = :5 AND yad060 = :6 group by aae076, yad063, yad064, yad067, yad052, yaa009, yad060, trunc(yad009), yaa011, yaa012, yad092, yaa014, aab191, aae011, trunc(aae036) union all select aae076 , yad063 , yad064 , yad067, yad052 , yaa009, yad060 , sum(yaa007) as t_yaa007, SUM(yaa008) AS t_yaa008, trunc(yad009) as yad009, yaa011 , yaa012 , yad092, yaa014, aab191, CASE WHE N (SELECT COUNT(1) FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1) END yae205, aae011 , trunc(aae036) as aae036 from yh00_trans_ad04a1 a where aad030='ab15a1' and yad063 = :7 AND yaa009 = :8 AND yad067 BETWEEN :9 AND :10 AND yab003 = :11 AND yad060 = :12 group by aae076, yad063, yad064, yad067, yad052, yaa009, yad060, trunc(yad009), yaa011, yaa012, yad092, yaa014, aab191, aae011, trunc(aae036) ) t WHERE 1 =1
21nu6hk03af9mSELECT COUNT(*) FROM AA94 WHERE YAA308='546DJ' AND YAA309 = :B1
26zpagbuyygf9/* OracleOEM */ SELECT blocking_sid, num_blocked FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked FROM ( SELECT l.id1, l.id2, MAX(DECODE(l.block, 1, i.instance_name||'-'||l.sid, 2, i.instance_name||'-'||l.sid, 0 )) blocking_sid, SUM(DECODE(l.request, 0, 0, 1 )) num_blocked FROM gv$lock l, gv$instance i WHERE ( l.block!= 0 OR l.request > 0 ) AND l.inst_id = i.inst_id GROUP BY l.id1, l.id2) GROUP BY blocking_sid ORDER BY num_blocked DESC) WHERE num_blocked != 0 AND blocking_sid != '0'
2bj93t0d0fhhnINSERT INTO KC82( YAE202, AAB001, AAC001, AAE003, AAE002, AAE143, YAE010, AAC008, AKC023, AKC021, AAB019, AAB020, AKC010, AAA041, AAA042, YKC175, YKC063, YKC064, YKC071, YKC072, YKC073, AAE037, YAE204, AAE114, AKC061, YKC065, YKC066, AKC062, YKC067, YKC068, YKC172, AAE038, YAE205, AAE115, AAE061, YAE206, AAE076, YKE586, YKC277, YAB003, YAE211, AAE120, AAE001, YKE260, YKC265, YKC266, YKC276, AAB034, YAE424, YAC200, AAE011, YAC210, YAC211, YAC212, YKC346, AAE036) SELECT YAE202, AAB001, AAC001, AAE003, AAE002, AAE143, YAE010, AAC008, AKC023, AKC021, AAB019, AAB020, AKC010, AAA041, AAA042, YKC175, YKC063, YKC064, YKC071, YKC072, YKC073, AAE037, YAE204, AAE114, AKC061, YKC065, YKC066, AKC062, YKC067, YKC068, YKC172, AAE038, YAE205, AAE115, AAE061, YAE206, AAE076, YKE586, YKC277, YAB003, AAC001, :B2 , AAE001, YKE260, YKC265, YKC266, YKC276, AAB034, YAE424, YAC200, AAE011, YAC210, YAC211, YAC212, YKC346, AAE036 FROM TMP_KC82K1 WHERE AAE076 = :B1
2f1ysgumu2xm8INSERT INTO YH00_2013_SF SELECT A.YKB037, A.YKB010, A.AKA130, SUM(A.YKA055), SUM(A.YKA107), NVL((SELECT NVL(SUM(YKA074), 0) FROM KB17K1 WHERE YKB010 = A.YKB010), 0), SUM(A.YKA065) FROM YH00_KC24K2_2013_GY A WHERE YKB010 = :B1 GROUP BY A.YKB037, A.YKB010, A.AKA130
2gy6aw7w4v301SELECT yae092, aae036, aae100, yae361, yae362, yae363 FROM ad53a5 WHERE yae092 = :1
2ma2h79ga40xtbegin pkg_P_peddleryBankPlan.prc_P_BankPlanControl('???????', 201401, 100000000013132, '0000', 1000080, TO_DATE('20140116', 'yyyymmdd'), :prm_AppCode, :prm_errmsg) ; end ;
2syt553rnawzgUPDATE AD04A1 SET YAA011 = :B1 WHERE AAE076 = :B2 AND YAA011 <> :B1
2ua81jgsmfancDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin pkg_prc_control.prc_execprc_one('100000348405113') ; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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
3gtkhqnqqt758INSERT INTO LC10L3( YAE202, AAB001, AAC001, AAE003, AAE002, AAE143, ALC001, AAA042, YAE010, YAE203, YLC237, YLC238, YLC239, YLC229, AAE038, YAE205, AAE115, YAE206, AAE076, YAB003, AAE011, YAC210, YAC211, YAC212, AAE036) SELECT YAE202, AAB001, AAC001, AAE003, AAE002, AAE143, ALC001, AAA042, YAE010, YAE203, YLC237, YLC238, YLC239, YLC229, AAE038, YAE205, AAE115, YAE206, AAE076, YAB003, AAE011, YAC210, YAC211, YAC212, AAE036 FROM TMP_LC10L2 WHERE AAE076 = :B1
3j27p10h5j7htSELECT YAB136, AAB020 FROM AB01 WHERE AAB001 = :B1
3mkbk42c6c74nUPDATE YH01_SL_KC21K1 SET BZ = '0' WHERE AKC190 = :B1 AND BZ = '3'
3v81f1y0khj46DELETE LC10L1 A WHERE EXISTS(SELECT 1 FROM TMP_LC10L1 B WHERE B.AAE076 = :B1 AND B.YAE202 = A.YAE202)
3y9bat7nwcjy5SELECT ELAPSED_TIME FROM DBA_SCHEDULER_RUNNING_JOBS WHERE JOB_NAME = 'AUTO_SPACE_ADVISOR_JOB'
44dyf2pgs7xvhSELECT AAE076 FROM AD04A1 WHERE AAE076 = :B1 AND ROWNUM = 1 FOR UPDATE NOWAIT
4bndapumf09zd SELECT /*+ NO_CPU_COSTING */ tsname, bsize total, used, bsize - used tsleft, useratio used_per, 100 - useratio free_per FROM (SELECT d.tablespace_name tsname, round(nvl(a.bytes / 1024 / 1024, 0), 2) bsize, round(nvl(a.bytes - nvl(f.bytes, 0), 0) / 1024 / 1024, 2) used, round(nvl((a.bytes - nvl(f.bytes, 0)) / a.bytes * 100, 0), 2) useratio FROM sys.dba_tablespaces d, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) a, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_free_space GROUP BY tablespace_name) f WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND NOT (d.extent_management LIKE 'LOCAL' AND d.contents LIKE 'TEMPORARY') UNION ALL SELECT d.tablespace_name tsname, round(nvl(a.bytes / 1024 / 1024, 0), 2) bsize, round(nvl(t.bytes, 0) / 1024 / 1024, 2) used, round(nvl(t.bytes / a.bytes * 100, 0), 2) useratio FROM sys.dba_tablespaces d, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_temp_files GROUP BY tablespace_name) a, (SELECT tablespace_name, SUM(bytes_cached) bytes FROM v$temp_extent_pool GROUP BY tablespace_name) t WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND d.extent_management LIKE 'LOCAL' AND d.contents LIKE 'TEMPORARY') x order by tsname
4h3tnm388am71UPDATE ad53a5 SET yae361 = null, yae362 = null, yae363 = null WHERE yae092 = :1
501kary3x38sj select r.apply_name apply_name, total_messages_dequeued, total_messages_spilled from gv$streams_apply_reader r, dba_apply a, dba_queues q, dba_queue_tables t where r.apply_name = a.apply_name and a.queue_name = q.name and a.queue_owner = q.owner and q.queue_table = t.queue_table and q.owner=t.owner and r.inst_id = t.owner_instance
5aa4qy7098w5kSELECT seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5, count(*) over () from sys.wri$_adv_message_groups WHERE id = :1 ORDER BY seq
5b6yvng00bn76 SELECT t.* FROM(select aae076 , yad063 , yad064 , yad067, yad052 , yaa009, yad060 , sum(yaa007) as t_yaa007, SUM(yaa008) AS t_yaa008, trunc(yad009) as yad009, yaa011 , yaa012 , yad092, yaa014, aab191, CASE WHEN (SELECT COUNT(1) FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1) END yae205, aae011 , trunc(aae036) as aae036 from ad04a1 a where aad030='ab15a1' and yad063 = :1 AND yaa009 = :2 AND yad067 BETWEEN :3 AND :4 AND yab003 = :5 group by aae076, yad063, yad064, yad067, yad052, yaa009, yad060, trunc(yad009), yaa011, yaa012, yad092, yaa014, aab191, aae011, trunc(aae036) union all select aae076 , yad063 , yad064 , yad067, yad052 , yaa009, yad060 , sum(yaa007) as t_yaa007, SUM(yaa008) AS t_yaa008, trunc(yad009) as yad009, yaa011 , yaa012 , yad092, yaa014, aab191, CASE WHEN (SELECT COUNT(1) FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1) END yae205, aae011 , trunc(aae036) as aae036 from yh00_trans_ad04a1 a where aad030='ab15a1' and yad063 = :6 AND yaa009 = :7 AND yad067 BETWEEN :8 AND :9 AND yab003 = :10 group by aae076, yad063, yad064, yad067, yad052, yaa009, yad060, trunc(yad009), yaa011, yaa012, yad092, yaa014, aab191, aae011, trunc(aae036) ) t WHERE 1 =1
5hab2vxpa4pqxSELECT SEQ_A_AAE068.NEXTVAL FROM DUAL
5qcsazjun2h9cSELECT AAB165 FROM AB08 WHERE AAB001 = :B4 AND AAE003 = :B3 AND YAE010 = :B2 AND AAE140 = :B1
5z6m72y6knsfr SELECT m.tablespace_name, m.used_percent, (m.tablespace_size - m.used_space)*t.block_size/1024/1024 mb_free FROM dba_tablespace_usage_metrics m, dba_tablespaces t, v$parameter p WHERE p.name='statistics_level' and p.value!='BASIC' AND t.tablespace_name = m.tablespace_name
62z9n48tdtdzvUPDATE YH01_SL_KC21K1 SET BZ = '3' WHERE AKC190 = :B1 AND BZ = '1'
67d54579qy6djDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin pkg_prc_control.prc_execprc_one('100000348405054') ; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6a5xdfgafb00dSELECT AAE002 FROM KC82 WHERE AAC001 = :B6 AND AAE143 IN (:B5 , :B4 ) AND AAE002 >= :B3 AND AAE002 < :B2 AND SUBSTR(TO_CHAR(AAE002), 5, 2) IN ('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12') AND NVL(AAE120, :B1 ) = :B1 GROUP BY AAE002 ORDER BY AAE002 DESC
6chnq116xhjgrselect /*+ RESULT_CACHE */aaa100, aaa102, aaa103, aae120 FROM cdsi2.aa10a1 WHERE aaa100 in ('YAC210', 'AAC031', 'YAC033', 'YKC150') order by aaa100, aaa102
710mp6r3fujag select capture_name streams_name, 'capture' streams_type , (available_message_create_time-capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select dba_propagation.propagation_name streams_name, 'propagation' streams_type, null streams_latency , total_msgs total_messages from gv$propagation_sender, dba_propagation where source_queue_owner=queue_schema and source_queue_name=queue_name and dblink='"'||destination_queue_owner ||'"' ||'.'||'"' ||destination_queue_name||'"@'||destination_dblink union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STREAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPL IED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT apply_name, state, lwm_time as apply_time, lwm_message_create_time as create_time FROM gv$streams_apply_coordinator ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name
76jfs9110c9fqINSERT INTO KC03( YAE202, AAB001, AAC001, AAE003, AAE002, AAE143, YAE010, YAE203, AAC008, AKC023, AKC021, AKC025, AAB019, AAB020, AKC010, AAA041, AAA042, YAA028, YAA310, YKC176, YKC175, YKC063, YKC064, YKC071, YKC326, YKC072, YKC073, AAE037, YAE204, AAE114, AKC061, YKC065, YKC066, AKC062, YKC327, YKC067, YKC068, YKC172, AAE038, YAE205, AAE115, AAE061, YAE206, AAE076, YAB003, YAE211, AAE120, AAE011, YAC210, YAC211, YAC212, AAE036) SELECT YAE202, AAB001, AAC001, AAE003, AAE002, AAE143, YAE010, YAE203, AAC008, AKC023, AKC021, AKC025, AAB019, AAB020, AKC010, AAA041, AAA042, YAA028, YAA310, YKC176, YKC175, YKC063, YKC064, YKC071, YKC326, YKC072, YKC073, AAE037, YAE204, AAE114, AKC061, YKC065, YKC066, AKC062, YKC327, YKC067, YKC068, YKC172, AAE038, YAE205, AAE115, AAE061, YAE206, AAE076, YAB003, AAC001, :B2 , AAE011, YAC210, YAC211, YAC212, AAE036 FROM TMP_KC03K1 WHERE AAE076 = :B1
76tj3ydckv1zh DECLARE S_AKB020 VARCHAR2(30); N_COUNT NUMBER(15):=0; S_YAD081 VARCHAR2(30); S_AKC190 VARCHAR2(30); S_YKA103 VARCHAR2(30); S_YKD007 VARCHAR2(30); CURSOR cur_getakc190 IS SELECT akc190, YKA103, YKD007 FROM yh00_cx_zkzfqk; -- CURSOR cur_getakb020 IS -- select a.akb020 -- from kb01 a -- WHERE a.akb023 = '03' -- order by a.akb020; BEGIN OPEN cur_getakc190; LOOP FETCH cur_getakc190 INTO S_AKC190, S_YKA103, S_YKD007; EXIT WHEN cur_getakc190%NOTFOUND; N_COUNT := N_COUNT + 1; BEGIN UPDATE yh00_cx_zkzfqk M SET M.YPF = (SELECT NVL(SUM(yka315), 0) FROM kc72k1 a WHERE A.akc190 = S_AKC190 AND YKA001 IN ('010101', '010102', '010103', '010201', '010202', '010203', '010301', '010302', '010303', '010401', '010403')) WHERE M.AKC190 = S_AKC190 AND M.YKA103 = S_YKA103 AND M.YKD007 = S_YKD007; EXCEPTION WHEN no_data_found THEN GOTO LABEL_NEXT; END; <<LABEL_NEXT>> IF N_COUNT = 1000 THEN COMMIT; N_COUNT := 0; END IF; END LOOP; CLOSE cur_getakc190; COMMIT; END;
7b2c0ktaqd6fxSELECT A.AKC190 FROM YH01_SL_KC21K1 A WHERE ROWNUM = 1 AND A.BZ = '1'
7bv08yw84kyymSELECT YAB136 FROM AB01 WHERE AAB001 = :B1
7mwrcjvtw1tz6select /*+ RESULT_CACHE */aaa100, aaa102, aaa103, aae120 FROM cdsi2.aa10a1 WHERE aaa100 in ('AAC004', 'AAC005', 'AAC008', 'AAC009', 'YAC214') order by aaa100, aaa102
83gbn49knry1zselect /*+ RESULT_CACHE */aaa100, aaa102, aaa103, aae120 FROM cdsi2.aa10a1 WHERE aaa100 in ('AAC004', 'YKC156', 'AAC005', 'AAC008', 'AAC009', 'YAC214', 'YAD050') order by aaa100, aaa102
8hzay2zw3yc4xselect aaa103 from cdsi2.aa10a1 WHERE aaa100 =:1 and aaa102 =:2
8yacyt32bayx9DELETE LC10L2 WHERE AAE076 = :B1
8zjmhqrtjgpwkSELECT COUNT(*) FROM KC82K1 WHERE AAC001 = :B2 AND AAE002 = :B1
911y3badh7v5hINSERT INTO AD04A1 (AAE076, AAD030, AAE075, YAD062, YAD104, YAD067, YAD016, YAD063, YAD064, YAD136, AAE008, YAD076, YAD075, YAA009, YAD052, YAD060, YAA010, YAA007, YAA008, YAD009, YAA011, YAA012, AAB191, YAD073, YAD107, YAD110, YAD091, YAD092, AAE013, YAD068, YAA013, YAA014, YAA016, AAE011, AAE036, YAB003) VALUES (:B26 , LOWER(TRIM(:B25 )), :B24 , LOWER(TRIM(:B23 )), :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , 0, :B8 , :B7 , :B6 , NULL, NULL, NULL, NULL, NULL, NULL, :B5 , NULL, NULL, NULL, :B4 , :B3 , :B2 , :B1 )
93nzp5fx0by8mbegin pkg_prc_control.prc_pedderybankunit_timing(22829920, '100000570365199', '100000573094830', :prm_AppCode, :prm_errmsg) ; end ;
96az0qfha9q6tINSERT INTO AB15( AAE068, AAE076, AAB001, AAC001, AAC008, AAE140, AAE003, AAB230, YAE010, YAE203, YAE316, YAA009, YAD060, YAB225, AAB019, AAB020, AAB021, AAE064, AAE065, AAB191, AAB210, YAB157, YAB158, YAB291, YAB220, AAB212, AAB213, YAB292, YAB159, YAB160, AAB214, AAB215, YAB258, YAB259, YAB293, YAB260, YAB261, YAB294, YAB003, AAE011, YAC211, AAE036) SELECT AAE068, AAE076, AAB001, AAC001, AAC008, AAE140, AAE003, AAB230, YAE010, YAE203, YAE316, YAA009, YAD060, YAB225, AAB019, AAB020, AAB021, AAE064, AAE065, :B4 , AAB210, YAB157, YAB158, YAB291, YAB220, AAB212, AAB213, YAB292, YAB159, YAB160, AAB214, AAB215, YAB258, YAB259, YAB293, YAB260, YAB261, YAB294, YAB003, :B3 , YAC211, :B2 FROM AB15A1 WHERE AAE076 = :B1
9hkpknh64tfvw select yab003 as yab139 from cdsi2.ac02 where aac001 =:1 and aae140 in ('01', '03') and aac031 in ('1', '2') order by aac031, aae140
9k6ajgwq410stSELECT DISTINCT AAE076 FROM AD04A1 WHERE YAD104 IN(:B18 , :B17 , :B16 , :B15 , :B14 , :B13 ) AND YAD016 = :B12 AND YAA011 = :B11 AND YAA012 = :B10 AND YAA009 = :B9 AND YAD060 IN(:B8 , :B7 , :B6 , :B5 , :B4 , :B3 ) AND AAE076 >= :B2 AND AAE076 <= :B1
9n4t5dggv4xmfDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin pkg_prc_control.prc_execprc_one('100000348398827') ; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
9pvmj3q1cdzjf DECLARE S_AKB020 VARCHAR2(30); N_COUNT NUMBER(15):=0; S_YAD081 VARCHAR2(30); CURSOR cur_getakb020 IS --SELECT to_char(b.yad081), a.akb020 -- FROM kb01 a, ad11a5 b -- WHERE b.yad081 IN (201306, 201307, 201308, 201309, 201310) -- AND a.akb023 <> '04' -- AND a.akb022 <> '04' -- and b.yab003 = '0000' -- ORDER by akb020; SELECT AKB020 FROM KB01 a WHERE akb023 <> '04' and akb022 <> '04' AND exists (select 1 from kb01k1 b where a.akb020=b.akb020 and b.ykb002 in ('1', '2')) AND exists (select 1 from kb01k4 c where a.akb020 = c.akb020 and c.aka130 in ('0301', '0309', '0310', '0306')) ORDER by akb020; CURSOR cur_getjsxx IS SELECT (SELECT m.ykd064 FROM kb01 m WHERE b.akb020 = m.akb020) AS ykd064, b.akc190, b.yka103, b.ykd007, b.yka032, b.akb020, (SELECT m.akb021 FROM kb01 m WHERE b.akb020 = m.akb020) AS akb021, (SELECT m.akb023 FROM kb01 m WHERE b.akb020 = m.akb020) AS akb023, (SELECT m.aka101 FROM kb01 m WHERE b.akb020 = m.akb020) AS aka101, b.aac001, --(SELECT a.aac003 -- FROM kc24k1 a -- WHERE a.akc190 = b.akc190 -- AND a.yka103 = b.yka103 -- AND a .ykd007 = b.ykd007) AS aac003, NULL AS AAC003, --(SELECT a.akc021 -- FROM kc24k1 a -- WHERE a.akc190 = b.akc190 -- AND a.yka103 = b.yka103 -- AND a.ykd007 = b.ykd007) AS akc021, NULL AS AKC021, --NULL AS akc192, --NULL AS akc194, b.yka054, b.ykc121, --(SELECT a.akb063 -- FROM kc24k1 a -- WHERE a.akc190 = b.akc190 -- AND a.yka103 = b.yka103 -- AND a.ykd007 = b.ykd007) AS akb063, NULL AS AKB063, b.yka055, --(SELECT a.yka056 -- FROM kc24k1 a -- WHERE a.akc190 = b.akc190 -- AND a.yka103 = b.yka103 -- AND a.ykd007 = b.ykd007) AS yka056, NULL AS YKA056, --(SELECT a.yka057 -- FROM kc24k1 a -- WHERE a.akc190 = b.akc190 -- AND a.yka103 = b.yka103 -- AND a.ykd007 = b.ykd007) AS yka057, NULL AS YKA057, --(SELECT a.yka111 -- FROM kc24k1 a -- WHERE a.akc190 = b.akc190 -- AND a.yka103 = b.yka103 -- AND a.ykd007 = b.ykd007) AS yka111, NULL AS YKA111, b.yka107, ----?????? (SELECT SUM(M.yka107) FROM kc24kb m WHERE b.akc190 = m.akc190) AS dbzf, b.ykc125, ----???? b.yka058, ----??????? --(SELECT a.YKC148 -- FROM kc24k1 a -- WHERE a.akc190 = b.akc190 -- AND a.yka103 = b.yka103 -- AND a.ykd007 = b.ykd007) AS YKC148, NULL AS YKC148, b.ykb010, (SELECT m.ykb053 FROM kb03k9 m WHERE b.akc190 = m.akc190 AND b.yka103 = m.yka103 AND b.ykd007 = m.ykd007 AND b.yka316 = m.yka316) AS ykb053, b.yka316, b.aae036, ----???? '0101' AS xzlb, case WHEN b.yka054 IN ('02', '03') THEN (SELECT G.ykc139 + G.ykc182 FROM cdsi2.kb11k9 G WHERE G.akc190 = b.akc190 AND G.YKA103 = b.YKA103 AND g.YKD007 = b.YKD007) ELSE 0 END AS dezfje, --NVL(((SELECT NVL(SUM(NVL(m.yka315, 0)), 0) -- FROM kc22k1 m -- WHERE m.akc190 = b.akc190 -- AND m.yka001 IN -- ('010101', '010102', '010103', '010201', -- '010202', '010203', '010301', '010302', -- '010303', '010401', '010403')) + -- (SELECT NVL(SUM(NVL(n.yka315, 0)), 0) -- FROM kc22k2 n -- WHERE n.akc190 = b.akc190 -- AND n.yka001 IN -- ('010101', '010102', '010103', '010201', -- '010202', '010203', '010301', '010302', -- '010303', '010401', '010403'))), -- 0) AS ypf, 0 AS ypf, --NULL AS bfsj, --NULL AS yaa012, --NULL AS aab191, TO_CHAR(b.aae036, 'yyyymm') AS aae002, NVL((SELECT E.YKA324 FROM cdsi2.KB09K4 E WHERE E.AKC190 = b.AKC190 AND E.YKA103 = b.YKA103 AND E.YKD007 = b.YKD007 AND E.AKA213 = '0101'), 0) AS yka324, NVL((SELECT m.ykd088 FROM kb03k9 m WHERE b.akc190 = m.akc190 AND b.yka103 = m.yka103 AND b.ykd007 = m.ykd007 AND b.yka316 = m.yka316), 0) AS ykd088, TO_CHAR(SYSDATE, 'yyyymmdd') AS zxsj, (SELECT m.yke248 FROM kb03k9 m WHERE b.akc 190 = m.akc190 AND b.yka103 = m.yka103 AND b.ykd007 = m.ykd007 AND b.yka316 = m.yka316) AS yke248, b.aka130 FROM KC24K2 B WHERE B.YKA316 ='31' AND B.AKA213 = '0101' AND B.AKB020 = S_AKB020 AND B.YKA107 <> 0 AND B.YKA032 = '2' --AND TO_CHAR(b.aae036, 'yyyymm') = S_YAD081 AND B.AAE036 BETWEEN TO_DATE('2013-06-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2013-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS') AND 1 = (select count(DISTINCT e.ykd007) FROM KC24K2 e WHERE B.akc190 = e.akc190 AND B.yka103 = e.yka103); -- CURSOR cur_getakb020 IS -- select a.akb020 -- from kb01 a -- WHERE a.akb023 = '03' -- order by a.akb020; BEGIN OPEN cur_getakb020; LOOP FETCH cur_getakb020 INTO S_AKB020; EXIT WHEN cur_getakb020%NOTFOUND; FOR rec_cur1 IN cur_getjsxx LOOP N_COUNT := N_COUNT + 1; BEGIN INSERT INTO yh00_cz_zkzfqk (ykd064, akc190, yka103, ykd007, yka032, akb020, akb021, akb023, aka101, aac001, aac003, akc021, yka054, ykc121, akb063, yka055, yka056, yka057, yka111, yka107, dbzf , ykc125, yka058, YKC148, ykb010, ykb053, yka316, aae036, xzlb , dezfje, ypf , aae002, yka324, ykd088, zxsj, aka130, yke248 ) VALUES (rec_cur1.ykd064, rec_cur1.akc190, rec_cur1.yka103, rec_cur1.ykd007, rec_cur1.yka032, rec_cur1.akb020, rec_cur1.akb021, rec_cur1.akb023, rec_cur1.aka101, rec_cur1.aac001, rec_cur1.aac003, rec_cur1.akc021, rec_cur1.yka054, rec_cur1.ykc121, rec_cur1.akb063, rec_cur1.yka055, rec_cur1.yka056, rec_cur1.yka057, rec_cur1.yka111, rec_cur1.yka107, rec_cur1.dbzf , rec_cur1.ykc125, rec_cur1.yka058, rec_cur1.YKC148, rec_cur1.ykb010, rec_cur1.ykb053, rec_cur1.yka316, rec_cur1.aae036, rec_cur1.xzlb , rec_cur1.dezfje, rec_cur1.ypf , rec_cur1.aae002, rec_cur1.yka324, rec_cur1.ykd088, rec_cur1.zxsj, rec_cur1.aka130, rec_cur1.yke248 ); EXCEPTION WHEN no_data_found THEN GOTO LABEL_NEXT; END; <<LABEL_NEXT>> IF N_COUNT = 200 THEN COMMIT; N_COUNT := 0; END IF; END LOOP; commit; END LOOP; CLOSE cur_getakb020; END;
9ryg7fzy8x9xgINSERT INTO LC10( YAE202, AAB001, AAC001, AAE003, AAE002, AAE143, ALC001, AAA042, YAE010, YAE203, YLC237, YLC238, YLC239, YLC229, AAE038, YAE205, AAE115, YAE206, AAE061, AAE076, YAB003, YAE211, AAE011, YAC210, YAC211, YAC212, AAE036) SELECT YAE202, AAB001, AAC001, AAE003, AAE002, AAE143, ALC001, AAA042, YAE010, YAE203, YLC237, YLC238, YLC239, YLC229, AAE038, YAE205, AAE115, YAE206, AAE061, AAE076, YAB003, AAC001, AAE011, YAC210, YAC211, YAC212, AAE036 FROM TMP_LC10L1 WHERE AAE076 = :B1
9ufxybd8n97tyDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin pkg_prc_control.prc_execprc_one('100000348405045') ; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
9wjb9xj5uy9juDELETE FROM AB15A1 WHERE AAE076 = :B1
a6ws36ztq6vhqSELECT COUNT(1) FROM CC72 A, CB8A B WHERE A.YCC720 = B.YCC720 AND B.YAE435 = 'Y' AND AAC001 IN (SELECT AAC001 FROM AC01 WHERE AAC002 = :B1 )
a9tw6wzcnuhc7SELECT COUNT(*) FROM AC01A2 WHERE AAC001 = :B1 AND YAC050 IN('44', '45')
bhjxxwujr3ac3 SELECT distinct ast.name, mt.inst_id, TO_CHAR(CAST(mt.begin_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') begintime, TO_CHAR(CAST(mt.end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') endtime, mt.intsize_csec, mt.group_id, mt.cpupercall, mt.dbtimepercall, mt.callspersec, mt.dbtimepersec FROM gv$servicemetric_history mt , gv$active_services ast WHERE end_time >= SYSDATE - 5/(60*24) AND group_id = 6 AND mt.service_name = ast.name AND mt.inst_id = ast.inst_id ORDER BY ast.name, mt.inst_id asc, endtime DESC
bkbp21n9f0p4z SELECT s.name, s.inst_id, i.instance_name FROM gv$active_services s, gv$instance i WHERE s.inst_id = i.inst_id ORDER BY s.name
bqfx5q2jas08uSELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (SELECT * FROM DBA_ADVISOR_TASKS ORDER BY TASK_ID DESC) T, DBA_ADVISOR_PARAMETERS_PROJ P1, DBA_ADVISOR_PARAMETERS_PROJ P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (SYSDATE - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = TO_CHAR(:B1 ) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1
bsa0wjtftg3uwselect file# from file$ where ts#=:1
bxk65jdxjq28pbegin pkg_prc_control.prc_pedderybankunit_timing(12321279, '100000556148957', '100000575096577', :prm_AppCode, :prm_errmsg) ; end ;
c3hhngpbpvvmkSELECT MARKER_TIMESTAMP FROM MGMT_AVAILABILITY_MARKER WHERE TARGET_GUID = :B1
cjzvy1p7cpm3wDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin pkg_prc_control.prc_execprc_one('100000348405076') ; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
cr3p21gxu7sdhDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN declare prm_AppCode VARCHAR2(500); prm_ErrorMsg VARCHAR2(500); begin PKG_J_STUDENT.PRC_J_DYALL(prm_AppCode=> prm_AppCode, prm_ErrorMsg=>prm_ErrorMsg); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
csjnw12bztq13begin pkg_prc_control.prc_pedderybankunit_timing(22829920, '100000574178634', '100000574836560', :prm_AppCode, :prm_errmsg) ; end ;
ctjd4zjkwtzd4-- Created on 2014/1/16 by ADMINISTRATOR declare cursor cur_ykb010 is select ykb010 from YH00_YKB010_2013_GY a WHERE not exists (select 1 from yh00_2013_sf where ykb010 = a.ykb010); begin for cur1 in cur_ykb010 loop insert into yh00_2013_sf select a.ykb037, a.ykb010, a.aka130, sum(a.yka055), sum(a.yka107), nvl((select nvl(sum(yka074), 0) from kb17k1 where ykb010 = a.ykb010), 0), sum(a.yka065) from yh00_kc24k2_2013_gy a where ykb010 = cur1.ykb010 group by a.ykb037, a.ykb010, a.aka130; commit; end loop; end;
czfu3p9zwchc0INSERT INTO AB15A1 (AAC008, YAE010, AAB001, AAE140, YAB225, YAA009, YAE316, AAE068, AAE003, AAB019, YAD060, AAB230, AAB022, AAB021, YAB003, AAC001, AAB020, AAE076, YAE203, AAE064, AAB191, AAB210, YAB157, YAB158, YAB220, AAB212, AAB213, YAB159, YAB160, AAB214, AAB215, YAB258, YAB259, YAB260, YAB261, AAE011, AAE036, AAE065, YAB291, YAB292, YAB293, YAB294, YAC211 ) SELECT :B33 , :B32 , :B1 , :B31 , :B30 , :B29 , :B28 , PKG_COMM.FUN_GETSEQUENCE(NULL, 'aae068'), :B27 , AB01.AAB019, :B26 , :B25 , AB01.AAB022, AB01.AAB021, :B24 , :B23 , AB01.AAB020, :B22 , NULL, NULL, NULL, 0 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , NULL, :B6 , :B5 , :B4 , :B3 , :B2 FROM AB01 WHERE AAB001 = :B1
da1pz1v3wu12dSELECT decode(count(distinct device_type) over (partition by RMAN_STATUS_RECID, RMAN_STATUS_STAMP), 1, first_value(device_type) over (partition by RMAN_STATUS_RECID, RMAN_STATUS_STAMP), 0, null, '*') device_type from GV$BACKUP_SYNC_IO where 'OUTPUT' = TYPE and rman_status_recid = :row_id and rman_status_stamp = :row_stamp UNION ALL SELECT decode(count(distinct device_type) over (partition by RMAN_STATUS_RECID, RMAN_STATUS_STAMP), 1, first_value(device_type) over (partition by RMAN_STATUS_RECID, RMAN_STATUS_STAMP), 0, null, '*') device_type from GV$BACKUP_ASYNC_IO where 'OUTPUT' = TYPE and rman_status_recid = :row_id and rman_status_stamp = :row_stamp
dbffgzt7bkp1sSELECT COUNT(1) FROM AD53A4 A, YHCIP_WD01 B WHERE A.YAE092 = B.YAE092 AND B.YWE004 ='2' AND B.YWE005 = :B1 AND A.AAE100 ='1'
du910b77fbbzvINSERT INTO JC01( YAE202, AAB001, AAC001, AAE003, AAE002, AAC013, AAE143, AAA041, AAA042, YAE010, YAE203, AJC020, AJC030, YJC002, YJC003, AAE037, YAE204, AAE114, AJC031, YJC004, YJC005, YJC006, AAE038, YAE205, AAE115, YAE206, AAE061, AAE076, YAB003, YAE211, AAE120, YJE003, AAE011, YAC210, YAC211, YAC212, AAE036) SELECT YAE202, AAB001, AAC001, AAE003, AAE002, AAC013, AAE143, AAA041, AAA042, YAE010, YAE203, AJC020, AJC030, YJC002, YJC003, AAE037, YAE204, AAE114, AJC031, YJC004, YJC005, YJC006, AAE038, YAE205, AAE115, YAE206, AAE061, AAE076, YAB003, AAC001, :B2 , YJE003, AAE011, YAC210, YAC211, YAC212, AAE036 FROM TMP_JC01J1 WHERE AAE076 = :B1
dw1r4570txun4 DECLARE S_AKC190 VARCHAR2(30); N_COUNT NUMBER(14, 2); -- CURSOR cur_getakc190 IS -- select akc190 -- FROM kc21k1 -- ORDER BY akc190; -- CURSOR cur_getaka130 IS -- select aka130 -- from bm_aka130 WHERE aka130 IN ('0101', '0201', '0202', '0301', '0302', '0301', '0304', '0305', '0306', '0307', '0308'); BEGIN <<lable_next>> --EXECUTE IMMEDIATE 'alter session set cursor_sharing=EXACT'; SELECT a.AKC190 INTO S_AKC190 FROM yh01_SL_KC21K1 a WHERE ROWNUM = 1 AND a.bz = '1'; IF S_AKC190 = '' OR S_AKC190 IS NULL THEN RETURN; END IF; BEGIN UPDATE yh01_SL_KC21K1 SET bz = '3' WHERE AKC190 = S_AKC190 AND bz = '1'; IF SQL%ROWCOUNT = 0 THEN ROLLBACK; GOTO lable_next; END IF; commit; EXCEPTION WHEN OTHERS THEN GOTO lable_next; END; BEGIN INSERT INTO YH00_KC24K1UNIONKC24K2 select A.AKC190, --????, VARCHAR2 A.YKA103, --????, VARCHAR2 A.YKD007, --????, VARCHAR2 A.YKC117, --?????, VARCHAR2 A.AKA130, --????, VARCHAR2 A.YKA032, --????, VARCHAR2 A.AAC001, --????, VARCHAR2 A.AAB001, --????, VARCHAR2 A.AAB019, --????, VARCHAR2 A.AAB020, --????, VARCHAR2 A.YAB136, --??????, VARC HAR2 A.AAB021, --????_AAB021, VARCHAR2 A.AAC003, --??, VARCHAR2 A.AAC004, --??, VARCHAR2 A.AAC006, --????, DATE A.AKC023, --????, NUMBER A.YKC021, --??????, NUMBER A.AKC021, --??????, VARCHAR2 A.YKC120, --??????, VARCHAR2 A.YKC150, --??????, VARCHAR2 A.YAC080, --??????, VARCHAR2 A.AKB020, --??????, VARCHAR2 A.AKB021, --??????, VARCHAR2 A.YKB006, --??????????, VARCHAR2 A.AKB023, --??????, VARCHAR2 A.AKA101, --??????, VARCHAR2 A.AKA123, --?????, VARCHAR2 A.YKA026, --????, VARCHAR2 A.YKA093, --??????, VARCHAR2 A.AAE013, --??, VARCHAR2 A.YKE098, --??????, DATE A.YAB139, --?????????, CHAR A.YKA055, --?????, NUMBER A.YKA056, --?????, NUMBER A.YKA111, --??????, NUMBER A.YKA057, --??????, NUMBER A.YKA254, --???, NUMBER A.YKC148, --???, NUMBER A.YKA224, --????, NUMBER A.AKB063, --????, NUMBER A.YKC173, --??????, VARCHAR2 A.YKE152, --???????, VARCHAR2 A.YKE153, --????, VARCHAR2 A.YKC105, --????, VARCHAR2 A.YKD003, --??????, VARCHAR2 A.YKA091, --??????, NUMBER A.YKE149, --????????, NUMBER A.YKA330, --????, VARCHAR2 A.YKC156, --????????, VARCHAR2 A.AKC025, --????????, VARCHAR2 A.YKA346, --???, NUMBER A.YKA347, --??????, NUMBER A.YKE239, --?????????, VARCHAR2 A.YKA386, --???, NUMBER A.YKA387, --???, NUMBER A.YKE493, --??????, NUMBER A.YKE494, --????????, NUMBER B.AKA213, --????, VARCHAR2, B.AAE073, --????, VARCHAR2 B.YKD002, --???????????????????????????, VARCHAR2 B.YKA115, --?????, NUMBER B.YKA058, --???????, NUMBER B.YKC125, --????, NUMBER B.YKA107, --????, NUMBER B.YKA065, --????????, NUMBER B.YKC177, --??????????, NUMBER B.YKC121, --??????, VARCHAR2 B.YKA054, --????, VARCHAR2 B.YKA222, --????????????(1, 0, -1), NUMBER B.YKA307, --????????????, NUMBER B.YKA234, --??????, NUMBER B.YKA308, --?????????????, NUMBER B.YKE119, --????????, NUMBE R B.YKA110, --???, VARCHAR2 B.AAE011, --???, NUMBER B.YKC141, --?????, VARCHAR2 B.AAE036, --????, DATE B.YAB003, --??????, CHAR B.YKA316, --????(??/??/??), VARCHAR2 B.YKB037, --?????, CHAR B.YKB010, --?????, VARCHAR2 B.YKE495, --????????, VARCHAR2 B.YKE484, --??????????, VARCHAR2 B.YKE535, --???, NUMBER B.YKE536, --???, NUMBER B.YKA399, --?????????, NUMBER B.YKA395, --?????????, NUMBER B.YKA396, --?????????, NUMBER B.YKA397 --????, NUMBER from cdsi2.KC24K1 A, cdsi2.KC24K2 B --????????(??????) WHERE A.AKC190 = S_AKC190 AND A.AKC190 = B.AKC190 AND A.YKA103 = B.YKA103 AND A.YKD007 = B.YKD007; COMMIT; EXCEPTION WHEN no_data_found THEN GOTO lable_next; END; UPDATE yh01_SL_KC21K1 SET bz = '0' WHERE AKC190 = S_AKC190 AND bz = '3'; commit; GOTO lable_next; -- dbms_output.put_line(s_aac001); -- RETURN; GOTO lable_next; EXCEPTION WHEN OTHERS THEN dbms_output.put_line('??AKC190??'||S_AKC190 || SQLERRM); END;
f0965dzx1vkh4INSERT INTO YH00_KC24K1UNIONKC24K2 SELECT A.AKC190, A.YKA103, A.YKD007, A.YKC117, A.AKA130, A.YKA032, A.AAC001, A.AAB001, A.AAB019, A.AAB020, A.YAB136, A.AAB021, A.AAC003, A.AAC004, A.AAC006, A.AKC023, A.YKC021, A.AKC021, A.YKC120, A.YKC150, A.YAC080, A.AKB020, A.AKB021, A.YKB006, A.AKB023, A.AKA101, A.AKA123, A.YKA026, A.YKA093, A.AAE013, A.YKE098, A.YAB139, A.YKA055, A.YKA056, A.YKA111, A.YKA057, A.YKA254, A.YKC148, A.YKA224, A.AKB063, A.YKC173, A.YKE152, A.YKE153, A.YKC105, A.YKD003, A.YKA091, A.YKE149, A.YKA330, A.YKC156, A.AKC025, A.YKA346, A.YKA347, A.YKE239, A.YKA386, A.YKA387, A.YKE493, A.YKE494, B.AKA213, B.AAE073, B.YKD002, B.YKA115, B.YKA058, B.YKC125, B.YKA107, B.YKA065, B.YKC177, B.YKC121, B.YKA054, B.YKA222, B.YKA307, B.YKA234, B.YKA308, B.YKE119, B.YKA110, B.AAE011, B.YKC141, B.AAE036, B.YAB003, B.YKA316, B.YKB037, B.YKB010, B.YKE495, B.YKE484, B.YKE535, B.YKE536, B.YKA399, B.YKA395, B.YKA396, B.YKA397 FROM CDSI2.KC24K1 A, CDSI2.KC24K2 B WHERE A.AKC190 = :B1 AND A.AKC190 = B.AKC190 AND A.YKA103 = B.YKA103 AND A.YKD007 = B.YKD007
f6rzw79yf94jjSELECT SUM( NVL(YLC237, 0)+ NVL(YLC238, 0)+ NVL(YLC239, 0)+ NVL(YLC229, 0)) FROM LC10L2 WHERE AAE076 = :B1
fbjk8zytbx6bmDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin pkg_prc_control.prc_execprc_one('100000348405084') ; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fcs9k9n13g2qjUPDATE YH00_CX_ZKZFQK M SET M.YPF = (SELECT NVL(SUM(YKA315), 0) FROM KC72K1 A WHERE A.AKC190 = :B3 AND YKA001 IN ('010101', '010102', '010103', '010201', '010202', '010203', '010301', '010302', '010303', '010401', '010403')) WHERE M.AKC190 = :B3 AND M.YKA103 = :B2 AND M.YKD007 = :B1
fk16s4326pt1yUPDATE AB08 SET YAB040 = NVL(YAB040, 0) + NVL(:B14 , 0), AAB155 = NVL(AAB155, 0) + NVL(:B13 , 0), AAB156 = NVL(AAB156, 0) - NVL(:B12 , 0), AAB165 = DECODE(SIGN(NVL(AAB156, 0) - NVL(:B12 , 0)), 1, AAB165, :B11 ), YAB144 = NVL(YAB144, 0) + NVL(:B10 , 0), YAB060 = NVL(YAB060, 0) + NVL(:B9 , 0), YAB151 = NVL(YAB151, 0) + NVL(:B8 , 0), YAB153 = NVL(YAB153, 0) + NVL(:B7 , 0), YAB154 = NVL(YAB154, 0) + NVL(:B6 , 0), YAB155 = NVL(YAB155, 0) + NVL(:B5 , 0) WHERE AAB001 = :B4 AND AAE003 = :B3 AND YAE010 = :B2 AND AAE140 = :B1
fvydfb8k9ypjnSELECT COUNT(1) FROM AC25 WHERE AAC001 = :B2 AND YAC060 IN('B3') AND YAE212 = '1' AND YAE221 = '1' AND AAE140 = '03' AND TO_CHAR(YAE213, 'yyyymm') <= TO_CHAR(TO_DATE(:B1 , 'yyyymm'), 'yyyymm')
fzyyh6dg11312SELECT YAA012, YAA011, AAB191, YAD060, YAB003 FROM AD04A1 WHERE AAE076 = :B1 AND ROWNUM = 1
g5g0whrt4ngqtSELECT 1 FROM USER_TAB_COLUMNS WHERE LOWER(TABLE_NAME) = :B1 AND LOWER(COLUMN_NAME) = 'yab003'
grwydz59pu6mcselect text from view$ where rowid=: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 604,818 168.14 0.30
CPU used when call started 25,621 7.12 0.01
CR blocks created 8,542 2.37 0.00
Cached Commit SCN referenced 10,064 2.80 0.00
Commit SCN cached 4 0.00 0.00
DB time 5,628,718 1,564.77 2.77
DBWR checkpoint buffers written 2,250,386 625.60 1.11
DBWR checkpoints 65 0.02 0.00
DBWR fusion writes 1,015 0.28 0.00
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 27,334 7.60 0.01
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 8,275 2.30 0.00
DBWR undo block writes 516,457 143.57 0.25
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 20 0.01 0.00
DML statements parallelized 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 75 0.02 0.00
PX local messages sent 75 0.02 0.00
PX remote messages recv'd 3,118 0.87 0.00
PX remote messages sent 3,164 0.88 0.00
Parallel operations downgraded 75 to 99 pct 0 0.00 0.00
Parallel operations downgraded to serial 1,797 0.50 0.00
Parallel operations not downgraded 20 0.01 0.00
RowCR - row contention 131 0.04 0.00
RowCR attempts 160,676 44.67 0.08
RowCR hits 168,197 46.76 0.08
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 39 0.01 0.00
SQL*Net roundtrips to/from client 240,315 66.81 0.12
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 158,194 43.98 0.08
application wait time 426 0.12 0.00
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 7 0.00 0.00
background checkpoints started 7 0.00 0.00
background timeouts 21,151 5.88 0.01
branch node splits 489 0.14 0.00
buffer is not pinned count 36,394,679 10,117.65 17.90
buffer is pinned count 85,414,419 23,745.05 42.00
bytes received via SQL*Net from client 10,466,021 2,909.53 5.15
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 48,013,181 13,347.58 23.61
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 7,786,392 2,164.60 3.83
calls to kcmgas 6,099,701 1,695.71 3.00
calls to kcmgcs 106,724 29.67 0.05
change write time 17,352 4.82 0.01
cleanout - number of ktugct calls 317,569 88.28 0.16
cleanouts and rollbacks - consistent read gets 5,625 1.56 0.00
cleanouts only - consistent read gets 33,939 9.43 0.02
cluster key scan block gets 22,784,853 6,334.15 11.20
cluster key scans 11,484,745 3,192.74 5.65
cluster wait time 48,219 13.40 0.02
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 165 0.05 0.00
commit batch/immediate requested 165 0.05 0.00
commit cleanout failures: block lost 44,760 12.44 0.02
commit cleanout failures: buffer being written 5 0.00 0.00
commit cleanout failures: callback failure 168,531 46.85 0.08
commit cleanout failures: cannot pin 64 0.02 0.00
commit cleanouts 15,780,449 4,386.94 7.76
commit cleanouts successfully completed 15,567,089 4,327.62 7.65
commit immediate performed 165 0.05 0.00
commit immediate requested 165 0.05 0.00
commit txn count during cleanout 361,569 100.52 0.18
concurrency wait time 26,877 7.47 0.01
consistent changes 4,495,460 1,249.73 2.21
consistent gets 332,777,960 92,511.66 163.63
consistent gets - examination 26,882,472 7,473.28 13.22
consistent gets direct 97 0.03 0.00
consistent gets from cache 332,777,863 92,511.64 163.63
current blocks converted for CR 8 0.00 0.00
cursor authentications 303 0.08 0.00
data blocks consistent reads - undo records applied 3,930,120 1,092.57 1.93
db block changes 49,053,550 13,636.80 24.12
db block gets 65,151,890 18,112.11 32.04
db block gets direct 124 0.03 0.00
db block gets from cache 65,151,932 18,112.12 32.04
deferred (CURRENT) block cleanout applications 11,415,923 3,173.61 5.61
dirty buffers inspected 57,397 15.96 0.03
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 2,239 0.62 0.00
enqueue deadlocks 0 0.00 0.00
enqueue releases 5,414,388 1,505.19 2.66
enqueue requests 5,414,833 1,505.31 2.66
enqueue timeouts 524 0.15 0.00
enqueue waits 20,541 5.71 0.01
exchange deadlocks 12 0.00 0.00
execute count 4,861,486 1,351.48 2.39
failed probes on index block reclamation 329 0.09 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 3,803,818 1,057.45 1.87
free buffer requested 5,461,305 1,518.23 2.69
gc CPU used by this session 108,399 30.13 0.05
gc blocks lost 0 0.00 0.00
gc cr block build time 33 0.01 0.00
gc cr block flush time 16 0.00 0.00
gc cr block receive time 402 0.11 0.00
gc cr block send time 44 0.01 0.00
gc cr blocks received 7,661 2.13 0.00
gc cr blocks served 11,805 3.28 0.01
gc current block flush time 0 0.00 0.00
gc current block pin time 16 0.00 0.00
gc current block receive time 1,207 0.34 0.00
gc current block send time 14 0.00 0.00
gc current blocks received 24,423 6.79 0.01
gc current blocks served 5,756 1.60 0.00
gc local grants 1,691,593 470.26 0.83
gc remote grants 1,722,677 478.90 0.85
gcs messages sent 13,638,967 3,791.61 6.71
ges messages sent 97,041 26.98 0.05
global enqueue get time 49,832 13.85 0.02
global enqueue gets async 6,437 1.79 0.00
global enqueue gets sync 2,579,516 717.10 1.27
global enqueue releases 2,573,229 715.35 1.27
global undo segment hints helped 0 0.00 0.00
global undo segment hints were stale 0 0.00 0.00
heap block compress 27,758 7.72 0.01
hot buffers moved to head of LRU 853,472 237.26 0.42
immediate (CR) block cleanout applications 39,778 11.06 0.02
immediate (CURRENT) block cleanout applications 2,510,733 697.98 1.23
index crx upgrade (found) 5 0.00 0.00
index crx upgrade (positioned) 169,385 47.09 0.08
index fast full scans (full) 77 0.02 0.00
index fetch by key 41,786,465 11,616.56 20.55
index scans kdiixs1 5,834,506 1,621.98 2.87
leaf node 90-10 splits 1,577 0.44 0.00
leaf node splits 107,908 30.00 0.05
lob reads 3,196 0.89 0.00
lob writes 2,982 0.83 0.00
lob writes unaligned 2,980 0.83 0.00
local undo segment hints helped 0 0.00 0.00
local undo segment hints were stale 0 0.00 0.00
logons cumulative 945 0.26 0.00
messages received 4,119,267 1,145.15 2.03
messages sent 4,119,267 1,145.15 2.03
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 304,408,358 84,624.97 149.68
opened cursors cumulative 304,590 84.68 0.15
parse count (failures) 2,620 0.73 0.00
parse count (hard) 3,187 0.89 0.00
parse count (total) 309,139 85.94 0.15
parse time cpu 315 0.09 0.00
parse time elapsed 18,017 5.01 0.01
physical read IO requests 3,236,182 899.65 1.59
physical read bytes 26,525,294,592 7,373,983.32 13,042.53
physical read total IO requests 8,168,379 2,270.79 4.02
physical read total bytes ############### 672,062,191.88 1,188,691.37
physical read total multi block requests 4,885,534 1,358.17 2.40
physical reads 3,237,951 900.14 1.59
physical reads cache 3,233,382 898.87 1.59
physical reads cache prefetch 948 0.26 0.00
physical reads direct 4,569 1.27 0.00
physical reads direct (lob) 93 0.03 0.00
physical reads direct temporary tablespace 1,536 0.43 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 1,343,185 373.40 0.66
physical write bytes 18,966,347,776 5,272,609.95 9,325.78
physical write total IO requests 5,378,987 1,495.35 2.64
physical write total bytes 49,518,118,400 13,765,946.23 24,348.14
physical write total multi block requests 3,984,642 1,107.72 1.96
physical writes 2,315,228 643.63 1.14
physical writes direct 780 0.22 0.00
physical writes direct (lob) 9 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 2,314,448 643.41 1.14
physical writes non checkpoint 1,559,535 433.55 0.77
pinned buffers inspected 15 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 1 0.00 0.00
process last non-idle time 4,445 1.24 0.00
queries parallelized 18 0.01 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 14,792,841 4,112.38 7.27
recursive cpu usage 427,284 118.78 0.21
redo blocks written 19,606,143 5,450.47 9.64
redo buffer allocation retries 98 0.03 0.00
redo entries 26,926,703 7,485.57 13.24
redo log space requests 106 0.03 0.00
redo log space wait time 83 0.02 0.00
redo ordering marks 480,583 133.60 0.24
redo size 9,238,215,904 2,568,207.10 4,542.45
redo subscn max counts 59,687 16.59 0.03
redo synch time 118 0.03 0.00
redo synch writes 1,805 0.50 0.00
redo wastage 477,907,776 132,857.49 234.99
redo write time 69,718 19.38 0.03
redo writer latching time 39 0.01 0.00
redo writes 1,803,322 501.32 0.89
rollback changes - undo records applied 28,555 7.94 0.01
rollbacks only - consistent read gets 958 0.27 0.00
rows fetched via callback 1,449,423 402.94 0.71
session connect time 0 0.00 0.00
session cursor cache hits 215,854 60.01 0.11
session logical reads 397,929,842 110,623.77 195.66
session pga memory 696,258,816 193,558.68 342.35
session pga memory max 20,520,112,384 5,704,553.66 10,089.77
session uga memory ############### 126,568,894.22 223,865.22
session uga memory max 16,061,754,432 4,465,138.32 7,897.59
shared hash latch upgrades - no wait 704,783 195.93 0.35
shared hash latch upgrades - wait 21 0.01 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 1,869,286 519.66 0.92
sorts (rows) 10,950,326 3,044.17 5.38
space was found by tune down 0 0.00 0.00
space was not found by tune down 0 0.00 0.00
sql area evicted 497 0.14 0.00
sql area purged 60 0.02 0.00
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 216,708 60.24 0.11
switch current to new buffer 1,421,815 395.26 0.70
table fetch by rowid 27,337,872 7,599.88 13.44
table fetch continued row 200,463 55.73 0.10
table scan blocks gotten 231,738,247 64,422.81 113.95
table scan rows gotten 8,912,081,003 2,477,542.20 4,382.08
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 0 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 233,233 64.84 0.11
total number of times SMON posted 63,662 17.70 0.03
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 165 0.05 0.00
transaction tables consistent read rollbacks 206 0.06 0.00
transaction tables consistent reads - undo records applied 40,100 11.15 0.02
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 3,416,005,948 949,643.40 1,679.66
user I/O wait time 1,644,149 457.07 0.81
user calls 247,130 68.70 0.12
user commits 2,032,086 564.92 1.00
user rollbacks 1,668 0.46 0.00
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 1,835,250 510.20 0.90
write clones created in background 0 0.00 0.00
write clones created in foreground 22 0.01 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 130,234,348 130,237,905
opened cursors current 82,740 82,552
workarea memory allocated 877,520 871,550
logons current 883 883

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 7 7.01

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)
DATA 2,947,027 819 19.97 1.00 1,210,444 337 163 0.12
SHORDATA 109,194 30 215.92 1.00 89,426 25 0 0.00
NNC_DATA01 159,129 44 0.29 1.00 3 0 0 0.00
UNDOTBS1 367 0 6.46 1.00 42,817 12 452 2.28
IUFO 16,576 5 0.29 1.00 1 0 0 0.00
SYSAUX 826 0 5.77 1.00 2,378 1 3 3.33
TEMPDATA 2,444 1 0.51 1.00 51 0 0 0.00
USERS 613 0 0.24 1.00 1 0 0 0.00
DATA_CW_INDEX01 321 0 3556.45 1.00 277 0 0 0.00
JYDATA 516 0 8126.82 1.67 8 0 0 0.00
TEMP 254 0 1952.60 6.11 137 0 0 0.00
SYSTEM 33 0 5.76 1.00 327 0 118 1.36
DATA_A 96 0 83841.88 1.00 20 0 0 0.00
JYLOBDATA 110 0 236.36 1.00 2 0 0 0.00
JYINDEX 59 0 14460.17 1.00 2 0 0 0.00
JYSHORTDATA 59 0 1930.51 1.00 2 0 0 0.00
CDLDZC 7 0 1.43 1.00 50 0 0 0.00
GGFW 56 0 0.54 1.00 1 0 0 0.00
NNC_INDEX01 11 0 10.00 1.00 4 0 0 0.00
XNH_DATA 9 0 0.00 1.00 4 0 0 0.00
GDZC 9 0 1.11 1.00 3 0 0 0.00
SYBX_DATA 9 0 2.22 1.00 3 0 0 0.00
DANGAN 8 0 2.50 1.00 2 0 0 0.00
LDGGSJ 7 0 31.43 1.00 1 0 0 0.00
UNDOTBS2 3 0 0.00 1.00 2 0 0 0.00
PENSION_DATA 2 0 0.00 1.00 1 0 0 0.00
JYTEMP 0 0 0.00   2 0 0 0.00
LDJG 1 0 0.00 1.00 1 0 0 0.00
LDYL 1 0 0.00 1.00 1 0 0 0.00
NNC_DATA02 1 0 0.00 1.00 1 0 0 0.00
NNC_DATA03 1 0 0.00 1.00 1 0 0 0.00
NNC_INDEX02 1 0 0.00 1.00 1 0 0 0.00
NNC_INDEX03 1 0 0.00 1.00 1 0 0 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)
CDLDZC /dev/rcdld_ldzc 7 0 1.43 1.00 50 0 0 0.00
DANGAN /dev/rcdld_dangan01 4 0 2.50 1.00 1 0 0 0.00
DANGAN /dev/rcdld_dangan02 4 0 2.50 1.00 1 0 0 0.00
DATA /dev/rcdld_data01 4,092 1 6.50 1.00 2,194 1 5 0.00
DATA /dev/rcdld_data02 3,612 1 7.57 1.00 1,961 1 0 0.00
DATA /dev/rcdld_data03 3,711 1 6.87 1.00 2,300 1 0 0.00
DATA /dev/rcdld_data04 4,247 1 6.73 1.00 3,439 1 0 0.00
DATA /dev/rcdld_data05 4,393 1 6.82 1.00 2,447 1 0 0.00
DATA /dev/rcdld_data06 4,994 1 7.93 1.00 2,223 1 0 0.00
DATA /dev/rcdld_data07 4,395 1 7.48 1.00 2,188 1 0 0.00
DATA /dev/rcdld_data08 4,889 1 6.93 1.00 2,971 1 0 0.00
DATA /dev/rcdld_data09 4,647 1 6.84 1.00 2,602 1 0 0.00
DATA /dev/rcdld_data10 4,235 1 7.03 1.00 2,265 1 0 0.00
DATA /dev/rcdld_data100 9,756 3 6.13 1.00 4,164 1 0 0.00
DATA /dev/rcdld_data101 10,233 3 5.54 1.00 4,105 1 0 0.00
DATA /dev/rcdld_data102 10,080 3 6.35 1.00 4,052 1 0 0.00
DATA /dev/rcdld_data103 9,375 3 6.00 1.00 4,503 1 0 0.00
DATA /dev/rcdld_data104 9,829 3 6.01 1.00 4,532 1 0 0.00
DATA /dev/rcdld_data105 9,738 3 6.24 1.00 4,479 1 0 0.00
DATA /dev/rcdld_data106 9,034 3 6.33 1.00 4,150 1 0 0.00
DATA /dev/rcdld_data107 9,854 3 5.97 1.00 5,108 1 0 0.00
DATA /dev/rcdld_data108 9,821 3 6.47 1.00 4,874 1 0 0.00
DATA /dev/rcdld_data109 9,949 3 6.07 1.00 3,915 1 0 0.00
DATA /dev/rcdld_data11 4,209 1 7.59 1.00 2,376 1 0 0.00
DATA /dev/rcdld_data110 9,326 3 5.66 1.00 3,961 1 3 0.00
DATA /dev/rcdld_data111 11,811 3 7.10 1.00 5,196 1 0 0.00
DATA /dev/rcdld_data112 9,788 3 5.56 1.00 4,042 1 0 0.00
DATA /dev/rcdld_data113 10,120 3 5.38 1.00 4,145 1 0 0.00
DATA /dev/rcdld_data114 8,452 2 5.27 1.00 4,174 1 0 0.00
DATA /dev/rcdld_data115 10,046 3 5.00 1.00 4,834 1 0 0.00
DATA /dev/rcdld_data116 10,197 3 5.16 1.00 4,590 1 0 0.00
DATA /dev/rcdld_data117 10,693 3 4.97 1.00 4,609 1 0 0.00
DATA /dev/rcdld_data118 11,207 3 5.06 1.00 4,221 1 0 0.00
DATA /dev/rcdld_data119 11,541 3 5.01 1.00 4,646 1 0 0.00
DATA /dev/rcdld_data12 5,823 2 5.69 1.00 1,934 1 0 0.00
DATA /dev/rcdld_data120 11,876 3 4.94 1.00 5,012 1 2 0.00
DATA /dev/rcdld_data121 12,572 3 4.80 1.00 4,747 1 0 0.00
DATA /dev/rcdld_data122 11,929 3 4.77 1.00 4,581 1 0 0.00
DATA /dev/rcdld_data123 13,691 4 4.90 1.00 5,176 1 0 0.00
DATA /dev/rcdld_data124 13,861 4 4.85 1.00 4,714 1 0 0.00
DATA /dev/rcdld_data125 14,882 4 4.58 1.00 4,705 1 1 0.00
DATA /dev/rcdld_data126 13,349 4 4.98 1.00 4,605 1 0 0.00
DATA /dev/rcdld_data127 14,750 4 4.95 1.00 4,667 1 0 0.00
DATA /dev/rcdld_data128 14,309 4 5.09 1.00 4,265 1 0 0.00
DATA /dev/rcdld_data129 15,606 4 4.65 1.00 4,956 1 0 0.00
DATA /dev/rcdld_data13 4,371 1 5.72 1.00 2,238 1 0 0.00
DATA /dev/rcdld_data130 14,979 4 4.73 1.00 4,948 1 0 0.00
DATA /dev/rcdld_data131 16,910 5 4.63 1.00 4,393 1 0 0.00
DATA /dev/rcdld_data132 14,984 4 4.67 1.00 4,605 1 0 0.00
DATA /dev/rcdld_data133 13,725 4 4.87 1.00 4,305 1 0 0.00
DATA /dev/rcdld_data134 14,872 4 5.18 1.00 5,101 1 0 0.00
DATA /dev/rcdld_data135 15,654 4 5.14 1.00 4,245 1 1 0.00
DATA /dev/rcdld_data136 12,268 3 4.89 1.00 4,453 1 0 0.00
DATA /dev/rcdld_data137 12,936 4 4.78 1.00 4,049 1 0 0.00
DATA /dev/rcdld_data138 14,221 4 4.60 1.00 4,802 1 0 0.00
DATA /dev/rcdld_data139 14,115 4 4.63 1.00 4,388 1 0 0.00
DATA /dev/rcdld_data14 5,933 2 6.02 1.00 2,474 1 0 0.00
DATA /dev/rcdld_data140 12,963 4 4.74 1.00 4,446 1 0 0.00
DATA /dev/rcdld_data141 12,311 3 4.53 1.00 2,391 1 0 0.00
DATA /dev/rcdld_data142 11,715 3 4.75 1.00 4,177 1 0 0.00
DATA /dev/rcdld_data143 11,130 3 4.51 1.00 2,461 1 0 0.00
DATA /dev/rcdld_data144 5,475 2 4.79 1.00 4,286 1 0 0.00
DATA /dev/rcdld_data145 7,586 2 5.55 1.00 4,389 1 0 0.00
DATA /dev/rcdld_data146 6,018 2 5.40 1.00 5,208 1 0 0.00
DATA /dev/rcdld_data147 5,005 1 5.06 1.00 4,086 1 0 0.00
DATA /dev/rcdld_data148 5,238 1 5.06 1.00 3,812 1 1 0.00
DATA /dev/rcdld_data149 4,795 1 5.57 1.00 3,511 1 0 0.00
DATA /dev/rcdld_data15 4,786 1 6.04 1.00 2,307 1 0 0.00
DATA /dev/rcdld_data150 5,697 2 72.19 1.00 3,263 1 0 0.00
DATA /dev/rcdld_data151 5,790 2 79.92 1.00 3,813 1 0 0.00
DATA /dev/rcdld_data152 5,171 1 89.60 1.00 4,138 1 0 0.00
DATA /dev/rcdld_data153 8,799 2 86.60 1.00 3,510 1 0 0.00
DATA /dev/rcdld_data154 8,310 2 157.96 1.00 4,360 1 0 0.00
DATA /dev/rcdld_data155 7,435 2 205.16 1.00 4,486 1 1 0.00
DATA /dev/rcdld_data156 6,530 2 191.86 1.00 3,721 1 0 0.00
DATA /dev/rcdld_data157 6,947 2 161.02 1.00 4,022 1 0 0.00
DATA /dev/rcdld_data158 5,891 2 193.46 1.00 2,567 1 0 0.00
DATA /dev/rcdld_data159 6,017 2 223.32 1.00 2,022 1 0 0.00
DATA /dev/rcdld_data16 5,397 2 6.02 1.00 3,044 1 0 0.00
DATA /dev/rcdld_data160 4,333 1 265.06 1.00 1,580 0 0 0.00
DATA /dev/rcdld_data161 8,915 2 4.40 1.00 4,417 1 0 0.00
DATA /dev/rcdld_data162 5,849 2 4.03 1.00 1,468 0 0 0.00
DATA /dev/rcdld_data163 6,611 2 3.85 1.00 1,765 0 0 0.00
DATA /dev/rcdld_data164 5,949 2 3.93 1.00 1,611 0 0 0.00
DATA /dev/rcdld_data165 4,960 1 4.11 1.00 1,853 1 0 0.00
DATA /dev/rcdld_data166 5,184 1 4.09 1.00 1,492 0 0 0.00
DATA /dev/rcdld_data167 5,518 2 4.03 1.00 1,451 0 0 0.00
DATA /dev/rcdld_data168 6,034 2 3.60 1.00 1,466 0 0 0.00
DATA /dev/rcdld_data169 8,969 2 6.61 1.00 6,108 2 0 0.00
DATA /dev/rcdld_data17 6,515 2 5.24 1.00 3,058 1 0 0.00
DATA /dev/rcdld_data170 9,300 3 5.75 1.00 5,127 1 0 0.00
DATA /dev/rcdld_data171 11,497 3 6.54 1.00 6,976 2 0 0.00
DATA /dev/rcdld_data172 10,525 3 5.53 1.00 7,206 2 0 0.00
DATA /dev/rcdld_data173 8,731 2 5.01 1.00 5,486 2 0 0.00
DATA /dev/rcdld_data174 9,627 3 5.01 1.00 6,326 2 1 0.00
DATA /dev/rcdld_data175 9,430 3 5.38 1.00 7,178 2 0 0.00
DATA /dev/rcdld_data176 7,339 2 5.30 1.00 5,980 2 0 0.00
DATA /dev/rcdld_data177 7,414 2 4.84 1.00 6,310 2 0 0.00
DATA /dev/rcdld_data178 9,171 3 5.11 1.00 6,489 2 0 0.00
DATA /dev/rcdld_data179 8,443 2 5.06 1.00 6,516 2 0 0.00
DATA /dev/rcdld_data18 5,926 2 5.61 1.00 2,039 1 0 0.00
DATA /dev/rcdld_data180 9,650 3 5.35 1.00 5,835 2 0 0.00
DATA /dev/rcdld_data181 9,371 3 5.65 1.00 7,891 2 0 0.00
DATA /dev/rcdld_data182 9,439 3 5.66 1.00 5,962 2 0 0.00
DATA /dev/rcdld_data183 8,500 2 5.40 1.00 6,060 2 0 0.00
DATA /dev/rcdld_data184 8,527 2 5.60 1.00 4,953 1 1 0.00
DATA /dev/rcdld_data185 9,464 3 8.82 1.00 6,090 2 0 0.00
DATA /dev/rcdld_data186 9,549 3 5.57 1.00 5,542 2 0 0.00
DATA /dev/rcdld_data187 8,732 2 6.03 1.00 5,833 2 0 0.00
DATA /dev/rcdld_data188 10,002 3 6.08 1.00 5,668 2 1 0.00
DATA /dev/rcdld_data189 9,372 3 6.27 1.00 6,255 2 1 0.00
DATA /dev/rcdld_data19 6,554 2 5.13 1.00 2,508 1 0 0.00
DATA /dev/rcdld_data190 7,812 2 5.59 1.00 6,276 2 2 0.00
DATA /dev/rcdld_data191 7,756 2 5.30 1.00 7,254 2 1 0.00
DATA /dev/rcdld_data192 9,484 3 5.85 1.00 6,729 2 1 0.00
DATA /dev/rcdld_data193 7,503 2 5.82 1.00 5,749 2 2 0.00
DATA /dev/rcdld_data194 8,213 2 5.06 1.00 6,860 2 0 0.00
DATA /dev/rcdld_data195 10,127 3 6.50 1.00 7,835 2 0 0.00
DATA /dev/rcdld_data196 11,019 3 6.99 1.00 6,863 2 0 0.00
DATA /dev/rcdld_data197 10,615 3 6.66 1.00 5,719 2 0 0.00
DATA /dev/rcdld_data198 9,794 3 6.27 1.00 5,665 2 0 0.00
DATA /dev/rcdld_data199 10,006 3 7.13 1.00 5,984 2 0 0.00
DATA /dev/rcdld_data20 6,100 2 5.57 1.00 2,021 1 0 0.00
DATA /dev/rcdld_data200 10,406 3 6.04 1.00 6,100 2 0 0.00
DATA /dev/rcdld_data201 9,833 3 6.57 1.00 5,272 1 0 0.00
DATA /dev/rcdld_data202 10,246 3 6.67 1.00 4,821 1 0 0.00
DATA /dev/rcdld_data203 6,943 2 6.55 1.00 4,547 1 0 0.00
DATA /dev/rcdld_data204 7,287 2 6.98 1.00 5,219 1 0 0.00
DATA /dev/rcdld_data205 9,235 3 7.38 1.00 5,312 1 0 0.00
DATA /dev/rcdld_data206 5,925 2 7.43 1.00 4,458 1 0 0.00
DATA /dev/rcdld_data207 6,959 2 7.17 1.00 4,948 1 0 0.00
DATA /dev/rcdld_data208 6,334 2 6.75 1.00 4,560 1 0 0.00
DATA /dev/rcdld_data209 7,084 2 7.28 1.00 4,764 1 0 0.00
DATA /dev/rcdld_data21 5,200 1 5.98 1.00 2,110 1 0 0.00
DATA /dev/rcdld_data210 7,264 2 7.32 1.00 4,217 1 0 0.00
DATA /dev/rcdld_data211 7,772 2 7.01 1.00 3,633 1 2 0.00
DATA /dev/rcdld_data212 6,810 2 7.24 1.00 3,391 1 0 0.00
DATA /dev/rcdld_data213 7,062 2 6.91 1.00 4,319 1 0 0.00
DATA /dev/rcdld_data214 7,440 2 7.08 1.00 3,689 1 0 0.00
DATA /dev/rcdld_data215 6,586 2 7.21 1.00 3,352 1 0 0.00
DATA /dev/rcdld_data216 4,488 1 8.20 1.00 3,447 1 0 0.00
DATA /dev/rcdld_data217 7,004 2 6.53 1.00 4,913 1 0 0.00
DATA /dev/rcdld_data218 6,402 2 6.22 1.00 4,712 1 0 0.00
DATA /dev/rcdld_data219 6,559 2 179.16 1.00 4,084 1 0 0.00
DATA /dev/rcdld_data22 7,089 2 5.44 1.00 2,270 1 0 0.00
DATA /dev/rcdld_data220 5,498 2 197.63 1.00 2,738 1 0 0.00
DATA /dev/rcdld_data221 5,897 2 181.87 1.00 2,700 1 0 0.00
DATA /dev/rcdld_data222 5,838 2 194.30 1.00 2,943 1 0 0.00
DATA /dev/rcdld_data223 6,098 2 152.35 1.00 3,114 1 0 0.00
DATA /dev/rcdld_data224 5,903 2 168.45 1.00 3,116 1 0 0.00
DATA /dev/rcdld_data225 6,015 2 30.43 1.00 3,720 1 0 0.00
DATA /dev/rcdld_data226 6,438 2 11.03 1.00 3,808 1 0 0.00
DATA /dev/rcdld_data227 6,253 2 7.53 1.00 3,882 1 0 0.00
DATA /dev/rcdld_data228 7,324 2 7.32 1.00 3,272 1 0 0.00
DATA /dev/rcdld_data229 6,848 2 8.19 1.00 4,463 1 0 0.00
DATA /dev/rcdld_data23 5,563 2 5.39 1.00 2,123 1 0 0.00
DATA /dev/rcdld_data230 5,610 2 8.21 1.00 4,020 1 0 0.00
DATA /dev/rcdld_data231 7,069 2 8.10 1.00 3,851 1 0 0.00
DATA /dev/rcdld_data232 6,365 2 8.08 1.00 4,050 1 0 0.00
DATA /dev/rcdld_data233 4,974 1 8.42 1.00 3,754 1 0 0.00
DATA /dev/rcdld_data234 4,716 1 8.29 1.00 4,463 1 0 0.00
DATA /dev/rcdld_data235 7,315 2 7.26 1.00 4,968 1 0 0.00
DATA /dev/rcdld_data236 9,996 3 6.33 1.00 4,757 1 0 0.00
DATA /dev/rcdld_data237 5,310 1 8.61 1.00 4,881 1 0 0.00
DATA /dev/rcdld_data238 11,719 3 3.95 1.00 4,870 1 1 0.00
DATA /dev/rcdld_data239 13,839 4 3.89 1.00 4,718 1 0 0.00
DATA /dev/rcdld_data24 7,794 2 5.18 1.00 2,084 1 3 0.00
DATA /dev/rcdld_data240 11,734 3 3.76 1.00 4,377 1 0 0.00
DATA /dev/rcdld_data241 13,566 4 3.97 1.00 4,302 1 0 0.00
DATA /dev/rcdld_data242 5,215 1 8.44 1.00 3,919 1 1 0.00
DATA /dev/rcdld_data243 5,095 1 8.22 1.00 4,527 1 0 0.00
DATA /dev/rcdld_data244 6,105 2 8.29 1.00 4,921 1 0 0.00
DATA /dev/rcdld_data245 6,462 2 8.53 1.00 4,474 1 0 0.00
DATA /dev/rcdld_data246 7,624 2 8.31 1.00 4,753 1 0 0.00
DATA /dev/rcdld_data247 6,887 2 8.45 1.00 9,156 3 0 0.00
DATA /dev/rcdld_data248 6,418 2 8.59 1.00 8,261 2 0 0.00
DATA /dev/rcdld_data249 4,720 1 262.86 1.00 4,267 1 0 0.00
DATA /dev/rcdld_data25 9,119 3 5.11 1.00 3,073 1 0 0.00
DATA /dev/rcdld_data250 4,657 1 307.42 1.00 4,479 1 0 0.00
DATA /dev/rcdld_data251 3,595 1 337.08 1.00 4,001 1 0 0.00
DATA /dev/rcdld_data252 6,565 2 8.46 1.00 7,402 2 0 0.00
DATA /dev/rcdld_data253 5,674 2 8.48 1.00 7,307 2 0 0.00
DATA /dev/rcdld_data254 5,018 1 8.53 1.00 6,655 2 0 0.00
DATA /dev/rcdld_data255 5,244 1 7.91 1.00 6,540 2 0 0.00
DATA /dev/rcdld_data256 6,230 2 8.25 1.00 5,373 1 6 0.00
DATA /dev/rcdld_data257 4,417 1 8.22 1.00 4,035 1 0 0.00
DATA /dev/rcdld_data258 4,955 1 8.14 1.00 3,931 1 0 0.00
DATA /dev/rcdld_data259 4,980 1 8.64 1.00 4,421 1 7 0.00
DATA /dev/rcdld_data26 6,678 2 5.29 1.00 2,092 1 1 0.00
DATA /dev/rcdld_data260 6,254 2 8.38 1.00 4,914 1 0 0.00
DATA /dev/rcdld_data261 5,223 1 8.30 1.00 3,733 1 2 0.00
DATA /dev/rcdld_data262 4,247 1 8.29 1.00 3,558 1 1 0.00
DATA /dev/rcdld_data263 4,974 1 84.58 1.00 4,180 1 1 0.00
DATA /dev/rcdld_data264 4,810 1 109.02 1.00 3,572 1 7 0.00
DATA /dev/rcdld_data265 4,176 1 120.37 1.00 2,571 1 6 0.00
DATA /dev/rcdld_data266 5,542 2 151.05 1.00 3,038 1 5 0.00
DATA /dev/rcdld_data267 5,032 1 268.98 1.00 2,920 1 9 0.00
DATA /dev/rcdld_data268 4,248 1 360.89 1.00 2,826 1 7 0.00
DATA /dev/rcdld_data269 4,798 1 281.07 1.00 3,096 1 0 0.00
DATA /dev/rcdld_data27 6,155 2 5.13 1.00 1,811 1 0 0.00
DATA /dev/rcdld_data270 3,868 1 318.76 1.00 2,234 1 2 0.00
DATA /dev/rcdld_data271 4,267 1 280.80 1.00 2,393 1 0 0.00
DATA /dev/rcdld_data272 4,355 1 318.48 1.00 2,818 1 8 0.00
DATA /dev/rcdld_data273 21,276 6 4.87 1.00 7,780 2 0 0.00
DATA /dev/rcdld_data274 28,093 8 4.10 1.00 8,814 2 16 0.00
DATA /dev/rcdld_data275 29,196 8 4.01 1.00 6,617 2 0 0.00
DATA /dev/rcdld_data276 26,810 7 4.12 1.00 5,105 1 0 0.00
DATA /dev/rcdld_data277 24,331 7 4.81 1.00 5,507 2 0 0.00
DATA /dev/rcdld_data278 29,279 8 4.44 1.00 7,113 2 0 0.00
DATA /dev/rcdld_data279 33,347 9 4.15 1.00 7,094 2 0 0.00
DATA /dev/rcdld_data28 5,839 2 6.62 1.00 1,609 0 0 0.00
DATA /dev/rcdld_data280 30,834 9 3.90 1.00 7,111 2 0 0.00
DATA /dev/rcdld_data281 28,523 8 3.78 1.00 6,319 2 0 0.00
DATA /dev/rcdld_data282 26,933 7 3.80 1.00 6,717 2 0 0.00
DATA /dev/rcdld_data283 16,138 4 3.77 1.00 3,864 1 0 0.00
DATA /dev/rcdld_data284 18,482 5 4.20 1.00 4,733 1 0 0.00
DATA /dev/rcdld_data285 28,651 8 3.40 1.00 5,151 1 0 0.00
DATA /dev/rcdld_data286 27,254 8 3.21 1.00 5,713 2 0 0.00
DATA /dev/rcdld_data287 28,653 8 3.38 1.00 6,151 2 0 0.00
DATA /dev/rcdld_data288 27,540 8 3.32 1.00 6,128 2 0 0.00
DATA /dev/rcdld_data289 29,100 8 3.42 1.00 6,807 2 0 0.00
DATA /dev/rcdld_data29 7,762 2 6.33 1.00 1,577 0 0 0.00
DATA /dev/rcdld_data290 26,978 7 3.17 1.00 7,972 2 0 0.00
DATA /dev/rcdld_data291 9,729 3 5.80 1.00 7,765 2 0 0.00
DATA /dev/rcdld_data292 10,687 3 5.37 1.00 9,161 3 0 0.00
DATA /dev/rcdld_data293 7,802 2 6.55 1.00 7,190 2 0 0.00
DATA /dev/rcdld_data294 7,208 2 181.38 1.00 4,557 1 0 0.00
DATA /dev/rcdld_data295 8,273 2 54.58 1.00 3,922 1 0 0.00
DATA /dev/rcdld_data296 4,940 1 108.63 1.00 3,436 1 0 0.00
DATA /dev/rcdld_data297 6,902 2 77.94 1.00 5,252 1 0 0.00
DATA /dev/rcdld_data298 4,806 1 182.44 1.00 4,235 1 0 0.00
DATA /dev/rcdld_data30 8,804 2 6.02 1.00 1,991 1 0 0.00
DATA /dev/rcdld_data31 7,185 2 6.59 1.00 2,067 1 0 0.00
DATA /dev/rcdld_data32 7,373 2 6.44 1.00 1,694 0 0 0.00
DATA /dev/rcdld_data33 4,349 1 7.33 1.00 2,771 1 0 0.00
DATA /dev/rcdld_data34 6,898 2 6.56 1.00 2,178 1 12 0.00
DATA /dev/rcdld_data35 7,079 2 6.33 1.00 2,285 1 9 0.00
DATA /dev/rcdld_data36 6,700 2 5.69 1.00 1,914 1 1 0.00
DATA /dev/rcdld_data37 5,449 2 6.10 1.00 2,204 1 1 0.00
DATA /dev/rcdld_data38 5,724 2 6.59 1.00 2,431 1 0 0.00
DATA /dev/rcdld_data39 6,305 2 6.43 1.00 2,517 1 0 0.00
DATA /dev/rcdld_data40 8,183 2 6.87 1.00 2,584 1 0 0.00
DATA /dev/rcdld_data41 6,573 2 6.30 1.00 2,135 1 0 0.00
DATA /dev/rcdld_data42 7,958 2 6.24 1.00 2,806 1 0 0.00
DATA /dev/rcdld_data43 7,601 2 6.00 1.00 2,745 1 2 0.00
DATA /dev/rcdld_data44 8,108 2 5.48 1.00 2,330 1 0 0.00
DATA /dev/rcdld_data45 7,825 2 5.63 1.00 2,510 1 0 0.00
DATA /dev/rcdld_data46 14,316 4 3.74 1.00 2,542 1 0 0.00
DATA /dev/rcdld_data47 14,735 4 3.64 1.00 2,354 1 0 0.00
DATA /dev/rcdld_data48 15,844 4 3.35 1.00 2,672 1 2 0.00
DATA /dev/rcdld_data49 13,532 4 3.37 1.00 2,206 1 0 0.00
DATA /dev/rcdld_data50 7,947 2 6.30 1.00 2,340 1 0 0.00
DATA /dev/rcdld_data51 8,256 2 6.34 1.00 3,346 1 0 0.00
DATA /dev/rcdld_data52 8,889 2 6.22 1.00 2,078 1 2 0.00
DATA /dev/rcdld_data53 6,368 2 6.45 1.00 2,179 1 2 0.00
DATA /dev/rcdld_data54 8,212 2 5.94 1.00 2,476 1 0 0.00
DATA /dev/rcdld_data55 9,024 3 6.28 1.00 2,861 1 0 0.00
DATA /dev/rcdld_data56 9,057 3 6.47 1.00 1,886 1 4 5.00
DATA /dev/rcdld_data57 12,923 4 3.78 1.00 2,276 1 0 0.00
DATA /dev/rcdld_data58 11,043 3 6.08 1.00 2,954 1 5 0.00
DATA /dev/rcdld_data59 12,310 3 4.79 1.00 3,058 1 0 0.00
DATA /dev/rcdld_data60 7,615 2 5.47 1.00 3,152 1 0 0.00
DATA /dev/rcdld_data61 9,285 3 5.60 1.00 2,987 1 0 0.00
DATA /dev/rcdld_data62 10,675 3 4.98 1.00 2,324 1 0 0.00
DATA /dev/rcdld_data63 7,912 2 5.57 1.00 2,581 1 1 0.00
DATA /dev/rcdld_data64 10,560 3 41.92 1.00 2,298 1 3 0.00
DATA /dev/rcdld_data65 10,481 3 51.72 1.00 2,417 1 3 0.00
DATA /dev/rcdld_data66 12,022 3 45.63 1.00 3,546 1 3 0.00
DATA /dev/rcdld_data67 10,242 3 81.42 1.00 2,611 1 1 0.00
DATA /dev/rcdld_data68 10,919 3 124.03 1.00 2,509 1 1 0.00
DATA /dev/rcdld_data69 12,067 3 130.35 1.00 4,061 1 2 0.00
DATA /dev/rcdld_data70 10,520 3 125.73 1.00 2,493 1 0 0.00
DATA /dev/rcdld_data71 10,146 3 122.52 1.00 2,307 1 0 0.00
DATA /dev/rcdld_data72 11,768 3 102.56 1.00 2,604 1 0 0.00
DATA /dev/rcdld_data73 13,314 4 5.91 1.00 2,431 1 0 0.00
DATA /dev/rcdld_data74 16,378 5 5.75 1.00 3,830 1 0 0.00
DATA /dev/rcdld_data75 15,437 4 5.38 1.00 2,639 1 0 0.00
DATA /dev/rcdld_data76 13,789 4 5.59 1.00 2,767 1 0 0.00
DATA /dev/rcdld_data77 14,893 4 5.51 1.00 2,897 1 0 0.00
DATA /dev/rcdld_data78 14,128 4 5.63 1.00 3,286 1 0 0.00
DATA /dev/rcdld_data79 11,912 3 5.93 1.00 2,859 1 0 0.00
DATA /dev/rcdld_data80 12,830 4 5.84 1.00 2,889 1 0 0.00
DATA /dev/rcdld_data81 16,562 5 5.65 1.00 3,217 1 0 0.00
DATA /dev/rcdld_data82 16,277 5 5.29 1.00 2,981 1 0 0.00
DATA /dev/rcdld_data83 17,145 5 5.87 1.00 3,376 1 0 0.00
DATA /dev/rcdld_data84 14,721 4 5.96 1.00 3,240 1 0 0.00
DATA /dev/rcdld_data85 15,216 4 5.73 1.00 2,927 1 0 0.00
DATA /dev/rcdld_data86 14,840 4 5.91 1.00 3,093 1 0 0.00
DATA /dev/rcdld_data87 16,493 5 5.80 1.00 3,358 1 0 0.00
DATA /dev/rcdld_data88 18,765 5 5.39 1.00 3,744 1 0 0.00
DATA /dev/rcdld_data90 18,459 5 5.44 1.00 3,857 1 0 0.00
DATA /dev/rcdld_data91 13,036 4 5.67 1.00 4,209 1 0 0.00
DATA /dev/rcdld_data92 14,312 4 5.43 1.00 3,990 1 0 0.00
DATA /dev/rcdld_data93 17,700 5 5.37 1.00 4,012 1 0 0.00
DATA /dev/rcdld_data94 16,437 5 5.49 1.00 3,654 1 0 0.00
DATA /dev/rcdld_data95 17,715 5 5.39 1.00 4,254 1 0 0.00
DATA /dev/rcdld_data96 16,391 5 5.56 1.00 4,047 1 0 0.00
DATA /dev/rcdld_data97 17,637 5 5.46 1.00 4,020 1 0 0.00
DATA /dev/rcdld_data98 18,083 5 5.36 1.00 4,375 1 0 0.00
DATA /dev/rcdld_data99 10,467 3 6.25 1.00 4,346 1 0 0.00
DATA_A /dev/rcdld_data_a01 5 0 224542.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a02 5 0 252228.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a03 5 0 237524.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a04 5 0 227920.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a05 5 0 235760.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a06 4 0 241582.50 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a07 4 0 257607.50 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a08 4 0 33502.50 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a09 4 0 6770.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a10 5 0 20.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a11 5 0 20.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a12 5 0 20.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a13 5 0 20.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a14 5 0 20.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a15 5 0 20.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a16 5 0 20.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a17 5 0 20.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a18 5 0 20.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a19 5 0 20.00 1.00 1 0 0 0.00
DATA_A /dev/rcdld_data_a20 5 0 20.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx01 3 0 0.00 1.00 11 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx02 215 0 4.37 1.00 235 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx03 4 0 0.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx04 5 0 4.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx05 6 0 1.67 1.00 2 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx06 7 0 1.43 1.00 2 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx07 5 0 18.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx08 4 0 22.50 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx09 4 0 22.50 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx10 4 0 284800.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx11 4 0 22.50 1.00 4 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx12 5 0 18.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx13 5 0 18.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx14 5 0 18.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx15 5 0 18.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx16 5 0 18.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx17 5 0 18.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx18 5 0 18.00 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx19 5 0 18.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx20 5 0 18.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx21 5 0 18.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx22 5 0 18.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx23 5 0 18.00 1.00 1 0 0 0.00
GDZC /dev/rcdld_gdzc1 2 0 0.00 1.00 1 0 0 0.00
GDZC /dev/rcdld_gdzc2 7 0 1.43 1.00 2 0 0 0.00
GGFW /dev/rcdld_ggfw 56 0 0.54 1.00 1 0 0 0.00
IUFO /dev/rnnc_iufo 16,576 5 0.29 1.00 1 0 0 0.00
JYDATA /dev/rcdld_jydata01 220 0 5356.27 1.67 2 0 0 0.00
JYDATA /dev/rcdld_jydata02 111 0 9418.65 1.05 2 0 0 0.00
JYDATA /dev/rcdld_jydata03 163 0 6384.11 1.09 2 0 0 0.00
JYDATA /dev/rcdld_jydata04 22 0 42226.36 9.09 2 0 0 0.00
JYINDEX /dev/rcdld_jyindex01 59 0 14460.17 1.00 2 0 0 0.00
JYLOBDATA /dev/rcdld_jylobdata 110 0 236.36 1.00 2 0 0 0.00
JYSHORTDATA /dev/rcdld_jyshortdat 59 0 1930.51 1.00 2 0 0 0.00
JYTEMP /dev/rcdld_jytemp 0 0     2 0 0  
LDGGSJ /dev/rcdld_gongan 7 0 31.43 1.00 1 0 0 0.00
LDJG /dev/rcdld_ldjg01 1 0 0.00 1.00 1 0 0 0.00
LDYL /dev/rcdld_yldata01 1 0 0.00 1.00 1 0 0 0.00
NNC_DATA01 /dev/rnnc_data01 79,508 22 0.29 1.00 1 0 0 0.00
NNC_DATA01 /dev/rnnc_data1_1 37,541 10 0.29 1.00 1 0 0 0.00
NNC_DATA01 /dev/rnnc_data1_2 42,080 12 0.29 1.00 1 0 0 0.00
NNC_DATA02 /dev/rnnc_data02 1 0 0.00 1.00 1 0 0 0.00
NNC_DATA03 /dev/rnnc_data03 1 0 0.00 1.00 1 0 0 0.00
NNC_INDEX01 /dev/rnnc_ind01_01 5 0 2.00 1.00 2 0 0 0.00
NNC_INDEX01 /dev/rnnc_index01 1 0 0.00 1.00 1 0 0 0.00
NNC_INDEX01 /dev/rnnc_index04 5 0 20.00 1.00 1 0 0 0.00
NNC_INDEX02 /dev/rnnc_index02 1 0 0.00 1.00 1 0 0 0.00
NNC_INDEX03 /dev/rnnc_index03 1 0 0.00 1.00 1 0 0 0.00
PENSION_DATA /dev/rcdld_sbpenda1 2 0 0.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor1 3,580 1 3.35 1.00 2,173 1 0 0.00
SHORDATA /dev/rcdld_sbshor10 5,333 1 2.46 1.01 2,148 1 0 0.00
SHORDATA /dev/rcdld_sbshor11 3,438 1 2.85 1.01 1,928 1 0 0.00
SHORDATA /dev/rcdld_sbshor12 3,517 1 2.20 1.00 1,837 1 0 0.00
SHORDATA /dev/rcdld_sbshor13 2,208 1 3.00 1.00 1,888 1 0 0.00
SHORDATA /dev/rcdld_sbshor14 4,037 1 2.65 1.00 1,961 1 0 0.00
SHORDATA /dev/rcdld_sbshor15 3,222 1 2.53 1.00 1,734 0 0 0.00
SHORDATA /dev/rcdld_sbshor16 3,778 1 2.37 1.00 1,745 0 0 0.00
SHORDATA /dev/rcdld_sbshor17 2,384 1 3.99 1.00 1,625 0 0 0.00
SHORDATA /dev/rcdld_sbshor18 4,344 1 2.75 1.00 1,781 0 0 0.00
SHORDATA /dev/rcdld_sbshor19 2,215 1 3.26 1.00 1,446 0 0 0.00
SHORDATA /dev/rcdld_sbshor2 2,117 1 8.37 1.00 1,253 0 0 0.00
SHORDATA /dev/rcdld_sbshor20 3,136 1 3.95 1.00 1,275 0 0 0.00
SHORDATA /dev/rcdld_sbshor21 3,741 1 2.81 1.00 1,156 0 0 0.00
SHORDATA /dev/rcdld_sbshor22 2,638 1 3.03 1.00 1,140 0 0 0.00
SHORDATA /dev/rcdld_sbshor23 3,584 1 2.08 1.00 1,297 0 0 0.00
SHORDATA /dev/rcdld_sbshor24 4,232 1 2.33 1.00 1,148 0 0 0.00
SHORDATA /dev/rcdld_sbshor25 9 0 1.11 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor26 8 0 1.25 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor27 10 0 2.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor28 10 0 2.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor29 10 0 2.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor3 5,634 2 2.47 1.00 1,198 0 0 0.00
SHORDATA /dev/rcdld_sbshor30 10 0 2.00 1.00 173 0 0 0.00
SHORDATA /dev/rcdld_sbshor31 10 0 2.00 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor32 10 0 2.00 1.00 179 0 0 0.00
SHORDATA /dev/rcdld_sbshor33 434 0 1.59 1.00 72 0 0 0.00
SHORDATA /dev/rcdld_sbshor34 188 0 3.62 1.00 277 0 0 0.00
SHORDATA /dev/rcdld_sbshor35 130 0 3.23 1.00 411 0 0 0.00
SHORDATA /dev/rcdld_sbshor36 190 0 1.26 1.00 171 0 0 0.00
SHORDATA /dev/rcdld_sbshor37 51 0 6.47 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor38 406 0 1.65 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor39 52 0 6.54 1.00 174 0 0 0.00
SHORDATA /dev/rcdld_sbshor4 5,022 1 2.14 1.00 1,227 0 0 0.00
SHORDATA /dev/rcdld_sbshor40 447 0 1.54 1.00 279 0 0 0.00
SHORDATA /dev/rcdld_sbshor41 74 0 6.08 1.00 303 0 0 0.00
SHORDATA /dev/rcdld_sbshor42 555 0 1.12 1.00 190 0 0 0.00
SHORDATA /dev/rcdld_sbshor43 78 0 6.79 1.00 296 0 0 0.00
SHORDATA /dev/rcdld_sbshor44 94 0 7.02 1.00 782 0 0 0.00
SHORDATA /dev/rcdld_sbshor45 62 0 7.26 1.00 204 0 0 0.00
SHORDATA /dev/rcdld_sbshor46 125 0 5.20 1.00 190 0 0 0.00
SHORDATA /dev/rcdld_sbshor47 435 0 2.39 1.00 154 0 0 0.00
SHORDATA /dev/rcdld_sbshor48 74 0 12.03 1.00 33 0 0 0.00
SHORDATA /dev/rcdld_sbshor49 251 0 2.91 1.00 697 0 0 0.00
SHORDATA /dev/rcdld_sbshor5 2,231 1 3.42 1.00 1,208 0 0 0.00
SHORDATA /dev/rcdld_sbshor50 75 0 6.40 1.00 636 0 0 0.00
SHORDATA /dev/rcdld_sbshor51 129 0 4.50 1.00 355 0 0 0.00
SHORDATA /dev/rcdld_sbshor52 91 0 8.79 1.00 510 0 0 0.00
SHORDATA /dev/rcdld_sbshor53 67 0 7.01 1.00 459 0 0 0.00
SHORDATA /dev/rcdld_sbshor54 58 0 8.62 1.00 456 0 0 0.00
SHORDATA /dev/rcdld_sbshor55 212 0 1694.10 1.00 310 0 0 0.00
SHORDATA /dev/rcdld_sbshor56 290 0 1379.17 1.00 553 0 0 0.00
SHORDATA /dev/rcdld_sbshor57 175 0 2462.51 1.00 288 0 0 0.00
SHORDATA /dev/rcdld_sbshor58 595 0 1228.44 1.00 499 0 0 0.00
SHORDATA /dev/rcdld_sbshor59 183 0 6962.46 1.00 292 0 0 0.00
SHORDATA /dev/rcdld_sbshor6 5,838 2 2.32 1.00 1,484 0 0 0.00
SHORDATA /dev/rcdld_sbshor60 1,100 0 1301.33 1.00 515 0 0 0.00
SHORDATA /dev/rcdld_sbshor61 684 0 1790.42 1.00 164 0 0 0.00
SHORDATA /dev/rcdld_sbshor62 244 0 4263.77 1.00 224 0 0 0.00
SHORDATA /dev/rcdld_sbshor63 89 0 11856.85 1.00 226 0 0 0.00
SHORDATA /dev/rcdld_sbshor64 48 0 26555.63 1.00 231 0 0 0.00
SHORDATA /dev/rcdld_sbshor65 145 0 8154.14 1.00 459 0 0 0.00
SHORDATA /dev/rcdld_sbshor66 166 0 6421.33 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor67 69 0 14957.54 1.00 238 0 0 0.00
SHORDATA /dev/rcdld_sbshor68 112 0 9741.88 1.00 263 0 0 0.00
SHORDATA /dev/rcdld_sbshor69 111 0 9341.26 1.00 99 0 0 0.00
SHORDATA /dev/rcdld_sbshor7 4,493 1 2.50 1.00 1,620 0 0 0.00
SHORDATA /dev/rcdld_sbshor70 104 0 8928.65 1.00 297 0 0 0.00
SHORDATA /dev/rcdld_sbshor71 799 0 158.25 1.00 409 0 0 0.00
SHORDATA /dev/rcdld_sbshor72 1,891 1 0.80 1.00 672 0 0 0.00
SHORDATA /dev/rcdld_sbshor73 575 0 3.36 1.00 1,015 0 0 0.00
SHORDATA /dev/rcdld_sbshor74 193 0 5.44 1.00 968 0 0 0.00
SHORDATA /dev/rcdld_sbshor75 205 0 4.44 1.00 1,278 0 0 0.00
SHORDATA /dev/rcdld_sbshor76 188 0 5.05 1.00 1,364 0 0 0.00
SHORDATA /dev/rcdld_sbshor77 167 0 5.27 1.00 994 0 0 0.00
SHORDATA /dev/rcdld_sbshor78 349 0 3.84 1.00 1,132 0 0 0.00
SHORDATA /dev/rcdld_sbshor79 424 0 3.51 1.00 1,474 0 0 0.00
SHORDATA /dev/rcdld_sbshor8 2,988 1 2.79 1.00 1,035 0 0 0.00
SHORDATA /dev/rcdld_sbshor80 509 0 4.17 1.00 1,684 0 0 0.00
SHORDATA /dev/rcdld_sbshor81 354 0 4.86 1.00 1,469 0 0 0.00
SHORDATA /dev/rcdld_sbshor82 661 0 2082.83 1.00 2,157 1 0 0.00
SHORDATA /dev/rcdld_sbshor83 685 0 1613.64 1.00 1,806 1 0 0.00
SHORDATA /dev/rcdld_sbshor84 698 0 1551.17 1.00 1,976 1 0 0.00
SHORDATA /dev/rcdld_sbshor85 341 0 2984.93 1.00 1,865 1 0 0.00
SHORDATA /dev/rcdld_sbshor86 925 0 1146.12 1.00 2,119 1 0 0.00
SHORDATA /dev/rcdld_sbshor87 1,047 0 881.85 1.00 2,250 1 0 0.00
SHORDATA /dev/rcdld_sbshor88 185 0 4748.38 1.00 2,272 1 0 0.00
SHORDATA /dev/rcdld_sbshor89 291 0 491.20 1.00 1,956 1 0 0.00
SHORDATA /dev/rcdld_sbshor9 4,924 1 1.98 1.00 1,104 0 0 0.00
SHORDATA /dev/rcdld_sbshor90 336 0 85.33 1.00 1,861 1 0 0.00
SHORDATA /dev/rcdld_sbshor91 182 0 3.13 1.00 1,772 0 0 0.00
SHORDATA /dev/rcdld_sbshor92 50 0 6.40 1.00 1,592 0 0 0.00
SHORDATA /dev/rcdld_sbshor93 95 0 3.16 1.00 1,480 0 0 0.00
SHORDATA /dev/rcdld_sbshor94 164 0 2.32 1.00 1,420 0 0 0.00
SHORDATA /dev/rcdld_sbshor95 596 0 0.67 1.00 1,435 0 0 0.00
SHORDATA /dev/rcdld_sbshor96 85 0 4.82 1.00 1,498 0 0 0.00
SHORDATA /dev/rcdld_sbshor97 95 0 3.47 1.00 1,417 0 0 0.00
SYBX_DATA /dev/rcdld_sydata01 1 0 0.00 1.00 1 0 0 0.00
SYBX_DATA /dev/rcdld_sydata02 8 0 2.50 1.00 2 0 0 0.00
SYSAUX /dev/rcdld_sysaux01 320 0 5.25 1.00 684 0 2 5.00
SYSAUX /dev/rcdld_sysaux02 178 0 3.48 1.00 408 0 0 0.00
SYSAUX /dev/rcdld_sysaux03 67 0 6.72 1.00 363 0 0 0.00
SYSAUX /dev/rcdld_sysaux04 82 0 8.17 1.00 337 0 0 0.00
SYSAUX /dev/rcdld_sysaux05 54 0 7.22 1.00 303 0 1 0.00
SYSAUX /dev/rcdld_sysaux06 125 0 7.68 1.00 283 0 0 0.00
SYSTEM /dev/rcdld_system01 20 0 9.00 1.00 198 0 0 0.00
SYSTEM /dev/rcdld_system02 7 0 0.00 1.00 64 0 64 2.50
SYSTEM /dev/rcdld_system03 6 0 1.67 1.00 65 0 54 0.00
TEMP /dev/rcdld_temp01 14 0 5.00 1.14 38 0 0  
TEMP /dev/rcdld_temp02 240 0 2066.21 6.40 14 0 0  
TEMP /dev/rcdld_temp03 0 0     26 0 0  
TEMP /dev/rcdld_temp05 0 0     59 0 0  
TEMPDATA /dev/rtempdata01 163 0 0.43 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata02 61 0 0.49 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata03 61 0 0.66 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata04 10 0 2.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata05 61 0 0.49 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata06 265 0 0.34 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata07 10 0 2.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata08 10 0 2.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata09 61 0 0.49 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata10 8 0 2.50 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata11 8 0 2.50 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata12 8 0 2.50 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata13 59 0 0.51 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata14 9 0 3.33 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata15 9 0 3.33 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata16 9 0 3.33 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata29 110 0 0.36 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata30 161 0 0.43 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata31 59 0 1.19 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata32 108 0 0.19 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata33 159 0 0.57 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata34 108 0 0.28 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata35 6 0 1.67 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata36 109 0 0.37 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata37 7 0 1.43 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata38 109 0 0.18 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata39 211 0 0.33 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata40 7 0 1.43 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata41 109 0 0.18 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata42 58 0 0.69 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata43 58 0 0.17 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata44 7 0 1.43 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata45 58 0 0.86 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata46 58 0 0.52 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata47 7 0 1.43 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata48 58 0 0.34 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata49 58 0 0.52 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata50 7 0 1.43 1.00 1 0 0 0.00
UNDOTBS1 /dev/rcdld_undo01_01 107 0 5.51 1.00 11,566 3 408 0.05
UNDOTBS1 /dev/rcdld_undo01_02 79 0 6.96 1.00 9,299 3 35 28.86
UNDOTBS1 /dev/rcdld_undo01_03 58 0 6.72 1.00 7,734 2 8 0.00
UNDOTBS1 /dev/rcdld_undo01_04 44 0 6.14 1.00 7,020 2 0 0.00
UNDOTBS1 /dev/rcdld_undo01_05 79 0 7.22 1.00 7,198 2 1 0.00
UNDOTBS2 /dev/rcdld_undo02_01 1 0 0.00 1.00 1 0 0 0.00
UNDOTBS2 /dev/rcdld_undo02_02 2 0 0.00 1.00 1 0 0 0.00
USERS /dev/rcdld_users01 613 0 0.24 1.00 1 0 0 0.00
XNH_DATA /dev/rcdld_xnh01 2 0 0.00 1.00 1 0 0 0.00
XNH_DATA /dev/rcdld_xnh02 2 0 0.00 1.00 1 0 0 0.00
XNH_DATA /dev/rcdld_xnh03 2 0 0.00 1.00 1 0 0 0.00
XNH_DATA /dev/rcdld_xnh04 3 0 0.00 1.00 1 0 0 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 9,579,648 99 397,890,459 3,233,351 2,314,763 0 0 736


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 131 177686 1404971 14483863 15092100 14483863  
E 0 72 80756 1593039 8959195 15092100 8959195  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 7,984 0.10 957,581 3.48 11,050,922,300
D 15,968 0.20 1,915,162 2.02 6,405,074,625
D 23,952 0.30 2,872,743 1.48 4,691,626,794
D 31,936 0.40 3,830,324 1.30 4,121,423,069
D 39,920 0.50 4,787,905 1.20 3,800,320,674
D 47,904 0.60 5,745,486 1.13 3,595,631,963
D 55,888 0.70 6,703,067 1.09 3,450,619,299
D 63,872 0.80 7,660,648 1.05 3,341,037,783
D 71,856 0.90 8,618,229 1.02 3,249,035,088
D 79,840 1.00 9,575,810 1.00 3,173,659,125
D 79,872 1.00 9,579,648 1.00 3,173,369,406
D 87,824 1.10 10,533,391 0.98 3,112,061,400
D 95,808 1.20 11,490,972 0.97 3,063,592,275
D 103,792 1.30 12,448,553 0.95 3,025,553,176
D 111,776 1.40 13,406,134 0.94 2,986,454,966
D 119,760 1.50 14,363,715 0.93 2,952,058,901
D 127,744 1.60 15,321,296 0.92 2,921,688,218
D 135,728 1.70 16,278,877 0.91 2,896,123,061
D 143,712 1.80 17,236,458 0.91 2,873,374,404
D 151,696 1.90 18,194,039 0.90 2,851,645,686
D 159,680 2.00 19,151,620 0.87 2,749,577,944

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 18,780 0

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 20,480 15,382 7,462.97 250.82 3.36 100.00 0.00 1,048,576
E 20,480 15,383 5,669.88 244.99 4.32 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 1,830,411 1,830,411 0 0
64K 128K 350 350 0 0
128K 256K 748 748 0 0
256K 512K 18 18 0 0
512K 1024K 2,579 2,579 0 0
1M 2M 1,095 1,095 0 0
2M 4M 1 1 0 0
4M 8M 14 14 0 0
64M 128M 2 2 0 0
512M 1024M 18 18 0 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
2,560 0.13 20,257,485.02 3,153,862.98 87.00 75,901
5,120 0.25 20,257,485.02 1,283,767.42 94.00 2,507
10,240 0.50 20,257,485.02 674,886.51 97.00 0
15,360 0.75 20,257,485.02 674,886.51 97.00 0
20,480 1.00 20,257,485.02 533,520.83 97.00 0
24,576 1.20 20,257,485.02 435,625.36 98.00 0
28,672 1.40 20,257,485.02 435,625.36 98.00 0
32,768 1.60 20,257,485.02 435,625.36 98.00 0
36,864 1.80 20,257,485.02 435,625.36 98.00 0
40,960 2.00 20,257,485.02 435,625.36 98.00 0
61,440 3.00 20,257,485.02 435,625.36 98.00 0
81,920 4.00 20,257,485.02 435,625.36 98.00 0
122,880 6.00 20,257,485.02 435,625.36 98.00 0
163,840 8.00 20,257,485.02 435,625.36 98.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
12,304 0.60 2,261 142,414 67,444,316 0.99 543,513 3.99 3,863,245,818
14,352 0.70 4,263 200,108 67,762,753 1.00 225,076 1.65 3,864,162,793
16,400 0.80 6,297 258,167 67,806,607 1.00 181,222 1.33 3,864,311,517
18,448 0.90 8,325 324,391 67,836,187 1.00 151,642 1.11 3,864,392,607
20,496 1.00 10,365 391,419 67,851,690 1.00 136,139 1.00 3,864,455,707
22,544 1.10 12,411 461,504 67,858,120 1.00 129,709 0.95 3,864,493,202
24,592 1.20 14,455 536,359 67,865,616 1.00 122,213 0.90 3,864,520,670
26,640 1.30 16,498 619,430 67,865,967 1.00 121,862 0.90 3,864,540,165
28,688 1.40 18,545 685,060 67,869,546 1.00 118,283 0.87 3,864,554,457
30,736 1.50 20,590 751,143 67,870,407 1.00 117,422 0.86 3,864,566,609
32,784 1.60 22,635 826,866 67,870,541 1.00 117,288 0.86 3,864,577,605
34,832 1.70 24,681 897,815 67,871,168 1.00 116,661 0.86 3,864,588,454
36,880 1.80 26,728 974,983 67,871,226 1.00 116,603 0.86 3,864,596,531
38,928 1.90 28,775 1,055,987 67,875,520 1.00 112,309 0.83 3,864,604,108
40,976 2.00 30,822 1,147,385 67,875,595 1.00 112,234 0.82 3,864,610,875

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)
384 0.19 0 0 0 0
592 0.29 0 0 0 0
800 0.39 0 0 0 0
1,008 0.49 0 0 0 0
1,216 0.59 0 0 0 0
1,424 0.70 0 0 0 0
1,632 0.80 0 0 0 0
1,840 0.90 0 0 0 0
2,048 1.00 0 0 0 0
2,256 1.10 0 0 0 0
2,464 1.20 0 0 0 0
2,672 1.30 0 0 0 0
2,880 1.41 0 0 0 0
3,088 1.51 0 0 0 0
3,296 1.61 0 0 0 0
3,504 1.71 0 0 0 0
3,712 1.81 0 0 0 0
3,920 1.91 0 0 0 0
4,128 2.02 0 0 0 0
4,336 2.12 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
undo header 449 1 2
data block 283 0 1
undo block 3 0 3
1st 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)
PS-PX Process Reservation 834 802 32 735 209 284.81
TT-Tablespace 246,502 246,501 0 11,790 6 0.49
FB-Format Block 8,550 8,550 0 4,427 2 0.52
CF-Controlfile Transaction 15,691 15,691 0 1,343 1 0.82
HW-Segment High Water Mark 64,565 64,565 0 1,282 1 0.52
TC-Tablespace Checkpoint 45 45 0 22 0 21.77
TM-DML 2,169,270 2,169,265 0 233 0 1.27
TO-Temp Object 21,575 21,575 0 322 0 0.50
JQ-Job Queue 236 126 110 70 0 1.49
RS-Reclaimable Space (prevent file delete) 112 112 0 86 0 0.44
RO-Multiple Object Reuse (fast object reuse) 172 172 0 85 0 0.40
BR-Backup/Restore (file shrink) 75 75 0 38 0 0.42
US-Undo Segment 99 99 0 23 0 0.61
TA-Instance Undo 23 23 0 23 0 0.48
CT-Block Change Tracking (state) 15 15 0 15 0 0.47
WF-AWR Flush 23 23 0 11 0 0.55
PI-Remote PX Process Spawn Status 10 10 0 10 0 0.50
UL-User-defined 9 9 0 6 0 0.50
WR-LNS archiving log 7 7 0 4 0 0.75
PW-Buffer Cache PreWarm (flush prewarm buffers) 3 3 0 3 0 1.00
WL-Being Written Redo Log 10 7 3 4 0 0.50
AF-Advisor Framework (task serialization) 7 7 0 1 0 1.00
SQ-Sequence Cache 484 484 0 1 0 1.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 5,324 0.00   0 0  
AWR Alerted Metric Element list 93,554 0.00   0 0  
Consistent RBA 1,802,804 0.03 0.00 0 0  
FAL request queue 109 0.00   0 0  
FAL subheap alocation 109 0.00   0 0  
FIB s.o chain latch 601 0.00   0 0  
FOB s.o list latch 7,855 0.03 0.00 0 0  
JS broadcast add buf latch 817 0.00   0 0  
JS broadcast drop buf latch 817 0.00   0 0  
JS broadcast load blnc latch 715 0.00   0 0  
JS mem alloc latch 12 0.00   0 0  
JS queue access latch 12 0.00   0 0  
JS queue state obj latch 21,450 0.00   0 0  
JS slv state obj latch 57,205 0.00 0.00 0 0  
KCL gc element parent latch 23,424,827 0.03 0.09 0 827 0.00
KJC message pool free list 1,833,376 0.04 0.00 0 85,303 0.13
KJCT flow control latch 11,135,407 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 1,199 0.00   0 0  
KPON ksr channel latch 773 0.00   0 0  
KSXR large replies 240 0.00   0 0  
KTF sga latch 22 0.00   0 1,210 0.00
KWQMN job cache list latch 900 0.56 0.80 0 0  
KWQP Prop Status 2 0.00   0 0  
LGWR NS Write 2,142 0.00   0 0  
Memory Management Latch 0     0 1,199 0.00
OS process 1,074 0.00   0 0  
OS process allocation 1,915 0.42 0.00 0 0  
OS process: request allocation 316 1.27 0.00 0 0  
PL/SQL warning settings 2,017 0.00   0 0  
SGA IO buffer pool latch 12 0.00   0 12 0.00
SQL memory manager latch 1 0.00   0 1,196 0.00
SQL memory manager workarea list latch 1,235,551 0.00 0.00 0 0  
Shared B-Tree 148 0.00   0 0  
X$KSFQP 126 0.00   0 0  
active checkpoint queue latch 1,190,896 0.14 0.00 0 0  
active service list 21,044 0.09 0.32 0 2,957 0.00
archive control 361 0.00   0 0  
archive process latch 1,429 0.00   0 0  
begin backup scn array 91 0.00   0 0  
business card 40 0.00   0 0  
cache buffer handles 209,325 0.00 0.00 0 0  
cache buffers chains 915,291,128 0.03 0.01 0 4,108,857 0.00
cache buffers lru chain 7,930,037 0.02 0.02 0 5,662,307 0.02
cache table scan latch 0     0 35 0.00
channel anchor 1,546 0.00   0 0  
channel handle pool latch 103,090 0.01 0.00 0 0  
channel operations parent latch 2,627,534 0.14 0.00 0 0  
checkpoint queue latch 62,521,430 0.00 0.00 0 2,169,562 0.00
client/application info 6,626 0.00   0 0  
commit callback allocation 10,963 0.00   0 0  
compile environment latch 954 0.00   0 0  
dml lock allocation 4,340,924 0.02 0.00 0 0  
dummy allocation 1,910 0.58 0.00 0 0  
enqueue hash chains 15,886,623 0.00 0.00 0 18,300 0.00
enqueues 4,251,068 0.08 0.00 0 0  
error message lists 86 0.00   0 0  
event group latch 158 0.00   0 0  
file cache latch 8,972 0.00   0 0  
gcs opaque info freelist 30,012 0.00   0 0  
gcs partitioned table hash 8,682,688 0.00   0 0  
gcs resource freelist 12,163,521 0.00 0.00 0 8,674,153 0.00
gcs resource hash 29,828,824 0.00 0.00 0 0  
gcs shadows freelist 8,791,449 0.00 0.00 0 8,676,569 0.00
ges caches resource lists 2,176,671 0.02 0.00 0 474,786 0.06
ges deadlock list 11,857 0.00   0 8 0.00
ges domain table 5,148,228 0.00   0 0  
ges enqueue table freelist 5,203,684 0.00   0 0  
ges group table 7,694,425 0.00 0.00 0 0  
ges process hash list 79,679 0.00 0.00 0 0  
ges process parent latch 10,397,846 0.00 0.00 0 0  
ges process table freelist 316 1.58 0.00 0 0  
ges resource hash list 5,701,926 0.02 0.01 0 62,950 0.07
ges resource scan list 804 0.00   0 0  
ges resource table freelist 115,947 0.01 0.00 0 0  
ges timeout list 3,494 0.00   0 2,829 0.00
global KZLD latch for mem in SGA 51 0.00   0 0  
hash table column usage latch 399 0.00   0 16,679 0.00
hash table modification latch 126 0.00   0 0  
job workq parent latch 0     0 165 3.03
job_queue_processes parameter latch 113 0.00   0 0  
kks stats 2,637 0.49 0.00 0 0  
kokc descriptor allocation latch 1,834 0.00   0 0  
krbmrosl 375 0.00   0 0  
ksuosstats global area 529 0.00   0 0  
ktm global data 64,471 0.00   0 0  
kwqbsn:qsga 147 0.00   0 0  
lgwr LWN SCN 1,802,716 0.01 0.00 0 0  
library cache 3,042,919 0.02 0.00 0 1,663 0.12
library cache load lock 318 0.00   0 0  
library cache lock 728,476 0.06 0.00 0 0  
library cache lock allocation 5,370 0.02 0.00 0 0  
library cache pin 319,830 0.03 0.00 0 0  
library cache pin allocation 5,931 0.00   0 0  
list of block allocation 151,262 0.01 0.00 0 0  
loader state object freelist 59,952 0.00 0.00 0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 7,703 0.00   0 44 0.00
message pool operations parent latch 134,784 0.01 0.00 0 0  
messages 10,567,583 0.41 0.00 0 0  
mostly latch-free SCN 1,851,213 2.46 0.00 0 0  
multiblock read objects 2,366 0.00   0 0  
name-service memory objects 11,222 0.00   0 0  
name-service namespace bucket 41,481 0.00   0 0  
name-service pending queue 2,020 0.00   0 0  
name-service request 60 0.00   0 0  
name-service request queue 38,864 0.00   0 0  
ncodef allocation latch 58 0.00   0 0  
object queue header heap 309,713 0.00   0 319,154 0.00
object queue header operation 72,011,927 0.02 0.00 0 0  
object stats modification 93,179 0.07 0.00 0 0  
parallel query alloc buffer 6,188 0.00   0 0  
parallel query stats 748 0.00   0 0  
parallel txn reco latch 64,368 0.00   0 0  
parameter list 355 1.13 0.00 0 0  
parameter table allocation management 2,362 0.04 0.00 0 0  
post/wait queue 14,214 0.00   0 1,850 0.00
process allocation 36,043 0.01 0.00 0 157 0.64
process group creation 316 2.53 0.00 0 0  
process queue 2,220 0.00   0 0  
process queue reference 60,418 0.00   0 6,430 0.00
qmn task queue latch 1,030 24.17 0.02 0 0  
query server freelists 1,528 0.00   0 0  
query server process 10 0.00   0 10 0.00
queued dump request 16,573 0.00   0 0  
redo allocation 30,919,110 0.14 0.00 0 26,868,706 0.58
redo copy 0     0 26,925,275 0.19
redo writing 6,805,550 0.08 0.00 0 0  
resmgr group change latch 2,383 0.00   0 0  
resmgr:active threads 1,902 0.00   0 0  
resmgr:actses change group 851 0.00   0 0  
resmgr:free threads list 1,902 0.74 0.00 0 0  
row cache objects 3,218,213 0.03 0.00 0 4 0.00
rules engine aggregate statistics 7 0.00   0 0  
rules engine rule set statistics 114 0.00   0 0  
sequence cache 253,144 0.01 0.00 0 0  
session allocation 8,315,569 0.22 0.00 0 0  
session idle bit 2,564,340 0.00 0.00 0 0  
session state list latch 2,030 1.58 0.00 0 0  
session switching 58 0.00   0 0  
session timer 1,212 0.00   0 0  
shared pool 223,261 0.06 0.03 0 0  
shared pool simulator 2,217,763 0.00 0.01 0 0  
simulator hash latch 28,451,745 0.00 0.00 0 0  
simulator lru latch 0     0 28,075,972 0.08
slave class 4 0.00   0 0  
slave class create 16 6.25 1.00 0 0  
sort extent pool 372,967 0.23 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 504 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
temporary table state object allocation 21 0.00   0 0  
threshold alerts latch 899 0.00   0 0  
transaction allocation 9,846,810 0.00   0 0  
transaction branch allocation 1,212 0.00   0 0  
undo global data 40,368,333 0.01 0.00 0 0  
user lock 409 2.44 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 915,291,128 288,745 2,127 286,881 0 0 0
mostly latch-free SCN 1,851,213 45,609 4 45,605 0 0 0
session allocation 8,315,569 18,116 25 18,092 0 0 0
object queue header operation 72,011,927 12,257 26 12,234 0 0 0
KCL gc element parent latch 23,424,827 7,677 704 6,984 0 0 0
channel operations parent latch 2,627,534 3,775 16 3,761 0 0 0
enqueues 4,251,068 3,569 2 3,567 0 0 0
cache buffers lru chain 7,930,037 1,608 27 1,581 0 0 0
ges resource hash list 5,701,926 888 10 878 0 0 0
library cache 3,042,919 638 1 637 0 0 0
gcs resource hash 29,828,824 573 2 572 0 0 0
qmn task queue latch 1,030 249 4 245 0 0 0
shared pool 223,261 125 4 121 0 0 0
shared pool simulator 2,217,763 73 1 72 0 0 0
active service list 21,044 19 6 13 0 0 0
KWQMN job cache list latch 900 5 4 1 0 0 0
slave class create 16 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclnfndnewm 0 1,878 289
KCL gc element parent latch kclrwrite 0 33 208
KCL gc element parent latch kclplz 0 16 367
KCL gc element parent latch KCLUNLNK 0 5 352
KCL gc element parent latch kclnfnd 0 5 11
KCL gc element parent latch kclhngcbk1 0 4 0
KCL gc element parent latch kclulb 0 3 285
KCL gc element parent latch kclfwrite1 0 2 140
KCL gc element parent latch kclbla 0 1 0
KCL gc element parent latch kclwrt 0 1 0
KCL gc element parent latch kclzcl 0 1 216
KWQMN job cache list latch kwqmnuji: update job item 0 3 3
KWQMN job cache list latch kwqmnprsc: loop 0 1 0
active service list ksws_event: ksws event 0 18 18
cache buffers chains kcbgtcr: kslbegin excl 0 5,372 5,412
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,793 1,278
cache buffers chains kcbrls: kslbegin 0 221 377
cache buffers chains kcbbxsv 0 197 195
cache buffers chains kcbgtcr: fast path 0 38 6
cache buffers chains kcbzgb: scan from tail. nowait 0 31 0
cache buffers chains kcbnlc 0 24 6
cache buffers chains kcbgcur: kslbegin 0 23 20
cache buffers chains kcbget: pin buffer 0 7 13
cache buffers chains kcbzwb 0 6 2
cache buffers chains kcbchg: kslbegin: call CR func 0 3 329
cache buffers chains kcbnew: new latch again 0 1 1
cache buffers chains kclebs_1 0 1 0
cache buffers lru chain kcbzgws 0 27 0
channel operations parent latch ksrwait() 0 12 22
channel operations parent latch ksrchdelete() 0 8 1
channel operations parent latch ksrapublish() 0 2 0
channel operations parent latch ksrsconsume() 0 1 0
enqueues ksqdel 0 1 0
enqueues ksqgel: create enqueue 0 1 1
event range base latch No latch 0 4 4
gcs resource hash kjbcropen:affinity 0 2 0
ges resource hash list kjakcai: search for resp by resname 0 6 0
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 4 0
library cache kqlmbinv: parent 0 1 0
mostly latch-free SCN kcslcu3 0 4 4
object queue header operation kcbo_ivbo 0 100 81
object queue header operation kcbw_link_q 0 14 19
object queue header operation kcbw_unlink_q 0 14 8
object queue header operation kcbo_switch_q_bg 0 3 2
object queue header operation kcbo_swap_buf 0 1 1
object queue header operation kcbo_switch_cq 0 1 10
object queue header operation kcbo_switch_mq_bg 0 1 12
session allocation ksufap: active sessions 0 19 0
session allocation ksudlc 0 3 8
session allocation ksucri 0 2 11
session allocation ksuprc 0 1 4
shared pool kghalo 0 4 3
shared pool simulator kglsim_unpin_simhp 0 1 0
slave class create ksvcreate 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
CDSI2 DATA KB17K1   TABLE 193,153,888 48.54
ONLYREAD SHORDATA YH01_KC21K1_SL_02   INDEX 43,830,208 11.01
CDJY JYDATA CC72   TABLE 32,948,192 8.28
SYS SYSTEM TS$   TABLE 22,621,056 5.68
SYS SYSTEM I_FILE2   INDEX 6,052,496 1.52

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
CDSI2 DATA KC72K1   TABLE 616,113 19.03
CDSI2 DATA FK_KC24K2_T_KC24K1   INDEX 298,316 9.21
CDSI2 DATA IDX_KC24K2_LOCAL2 20_DEFAULT INDEX PARTITION 227,889 7.04
CDSI2 DATA PK_KC24K1_11   INDEX 193,580 5.98
CDSI2 DATA KC24K2_T 20_DEFAULT TABLE PARTITION 95,503 2.95

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 758 12.49
CDSI2 DATA INDEX_KC82_07   INDEX 396 6.52
CDSI2 DATA INDEX_KC82K3_07   INDEX 341 5.62
CDSI2 DATA INDEX_KC82K3_02   INDEX 302 4.98
CDSI2 DATA INDEX_KC82_04   INDEX 294 4.84

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
CDSI2 DATA IDX$$_206C40005   INDEX 13 7.65
CDSI2 DATA IDX$$_EF380003   INDEX 12 7.06
CDSI2 DATA INDEX_KC82K3_04   INDEX 12 7.06
CDSI2 DATA PK_KC82K3   INDEX 12 7.06
CDSI2 DATA IDX_MC09_AAE076   INDEX 11 6.47

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
CDSI2 DATA IDX$$_8B7C0001   INDEX 130 55.56
SYS SYSTEM JOB$   TABLE 99 42.31
SYS SYSTEM I_JOB_NEXT   INDEX 4 1.71
CDSI2 DATA AC02 _AAE140_03 TABLE PARTITION 1 0.43

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
CDSI2 DATA AC02 _AAE140_03 TABLE PARTITION 2 100.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
CDSI2 DATA KC72K1   TABLE 1,111 14.50
CDSI2 DATA KC04   TABLE 1,100 14.36
CDSI2 DATA IDX$$_E9690001   INDEX 721 9.41
CDJY DATA DY41   TABLE 706 9.22
CDSI2 DATA IDX_KC24K2_LOCAL2 20_DEFAULT INDEX PARTITION 521 6.80

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
CDSI2 DATA PK_KC04   INDEX 3,756 15.38
CDSI2 DATA KC24K2_T 20_DEFAULT TABLE PARTITION 3,422 14.01
CDSI2 DATA IDX_KC01_AAC001_YKC150_AKC021   INDEX 1,707 6.99
CDSI2 DATA KC04   TABLE 1,125 4.61
SYS SYSAUX WRI$_ADV_ACTIONS   TABLE 827 3.39

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 66 6.06 0   0 1
dc_database_links 111 0.00 0   0 2
dc_files 20,982 0.00 0   0 538
dc_global_oids 2,164 0.09 0   0 75
dc_histogram_data 19,960 0.19 0   0 56,997
dc_histogram_defs 12,701 1.02 0   0 49,795
dc_object_grants 261 0.00 0   0 263
dc_object_ids 76,336 0.04 0   0 9,815
dc_objects 9,359 0.46 0   0 9,310
dc_profiles 154 0.00 0   0 1
dc_rollback_segments 90,733 0.00 0   0 2,685
dc_segments 5,020 1.41 0   434 11,724
dc_sequences 483 1.24 0   483 169
dc_tablespace_quotas 427 0.00 0   417 9
dc_tablespaces 558,816 0.00 0   0 34
dc_usernames 1,586 0.13 0   0 34
dc_users 303,591 0.00 0   0 65
outstanding_alerts 427 88.29 0   7 67

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 4 4 0
dc_global_oids 2 0 0
dc_histogram_defs 130 0 0
dc_object_ids 30 62 0
dc_objects 43 98 0
dc_segments 936 60 6
dc_sequences 966 5 0
dc_tablespace_quotas 854 0 0
dc_usernames 2 0 0
outstanding_alerts 828 373 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 983 0.00 8,370 0.02 2 0
INDEX 29 0.00 72 12.50 9 0
SQL AREA 8,322 8.18 5,188,818 0.09 2,730 287
TABLE/PROCEDURE 1,110 0.18 140,902 0.09 49 0
TRIGGER 53 5.66 14,364 0.05 3 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
INDEX 72 9 21 63 0
TABLE/PROCEDURE 27,051 18 39 86 17

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 4,364.65   4.93 23.77 691 691 886 885
  Freeable 2,505.31 0.00 3.91 40.35 670   641 641
  SQL 553.18 418.15 0.67 2.46 47 1,447 828 806
  PL/SQL 97.02 28.64 0.11 1.93 57 57 887 887
E Other 4,328.23   4.89 23.78 691 691 886 885
  Freeable 754.25 0.00 1.17 3.79 95   642 642
  SQL 548.07 412.99 0.66 2.46 47 1,447 828 805
  PL/SQL 96.52 28.49 0.11 1.93 57 57 887 887

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 83,751,862,272  
Fixed Size 2,297,640  
Redo Buffers 282,914,816  
Variable Size 23,890,755,800  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 128.00 128.00 0.00
large free memory 128.00 128.00 0.00
shared CCursor 2,198.23 2,199.32 0.05
shared PCursor 603.24 603.63 0.06
shared db_block_hash_buckets 720.00 720.00 0.00
shared free memory 2,115.54 2,116.53 0.05
shared gcs resources 1,720.14 1,720.14 0.00
shared gcs shadows 1,030.03 1,030.03 0.00
shared kkj jobq wor 1,704.12 1,704.12 0.00
shared library cache 723.31 723.34 0.00
shared sql area 7,011.64 7,008.73 -0.04
shared sql area:PLSQL 981.19 981.86 0.07
streams free memory 2,047.99 2,047.99 0.00
  buffer_cache 79,872.00 79,872.00 0.00
  fixed_sga 2.19 2.19 0.00
  log_buffer 269.81 269.81 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 873,113 254,056 0
QMON Coordinator 204,708 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 7 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 3,195,696 10,765,702 11132041 11132041
gcs_shadows 7,191,411 10,816,241 11132041 11132041


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_gc_affinity_time 0   
_gc_undo_affinity FALSE   
_undo_autotune FALSE   
archive_lag_target 600   
audit_file_dest /oracle/app/oracle/admin/cdld/adump   
background_dump_dest /oracle/app/oracle/admin/cdld/bdump   
cluster_database TRUE   
compatible 10.2.0.2.0   
control_files /dev/rcdld_ctrl01, /dev/rcdld_ctrl02, /dev/rcdld_ctrl03   
core_dump_dest /oracle/app/oracle/admin/cdld/cdump   
db_block_size 8192   
db_cache_size 83751862272   
db_domain      
db_file_multiblock_read_count 32   
db_files 600   
db_name cdld   
db_writer_processes 8   
distributed_lock_timeout 60   
instance_number 1   
java_pool_size 134217728   
job_queue_processes 40   
large_pool_size 134217728   
local_listener 10.163.31.40:1521   
log_archive_config dg_config=(cdld, rep)   
log_archive_dest_1 LOCATION=/ora10g/archivelog01   
log_archive_dest_2      
log_archive_dest_3 SERVICE=rep LGWR async DB_UNIQUE_NAME=rep REOPEN=60 MAX_FAILURE=600   
log_archive_dest_state_2 enable   
log_archive_format cdld1_%t_%s_%r.arc   
log_archive_max_processes 4   
max_dump_file_size 100   
nls_language AMERICAN   
nls_territory CHINA   
open_cursors 3000   
optimizer_index_cost_adj 40   
parallel_max_servers 40   
pga_aggregate_target 21474836480   
processes 5000   
remote_listener      
remote_login_passwordfile EXCLUSIVE   
service_names      
session_cached_cursors 100   
sga_max_size 107927830528   
shared_pool_size 21474836480   
spfile /dev/rcdld_spfile   
thread 1   
undo_management AUTO   
undo_retention 10800   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/app/oracle/admin/cdld/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 4,718 1.31 0.00
acks for commit broadcast(logical) 8,101 2.25 0.00
broadcast msgs on commit(actual) 1,802,248 501.02 0.89
broadcast msgs on commit(logical) 1,803,329 501.32 0.89
broadcast msgs on commit(wasted) 157,051 43.66 0.08
broadcast on commit wait time(ms) 149,646 41.60 0.07
broadcast on commit waits 1,131,869 314.66 0.56
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 1,133 0.31 0.00
flow control messages received 0 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 2,352 0.65 0.00
gcs ast xid 0 0.00 0.00
gcs blocked converts 5,023 1.40 0.00
gcs blocked cr converts 10,873 3.02 0.01
gcs compatible basts 155 0.04 0.00
gcs compatible cr basts (global) 204 0.06 0.00
gcs compatible cr basts (local) 11,153 3.10 0.01
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 883 0.25 0.00
gcs dbwr write request msgs 852 0.24 0.00
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 52,717 14.66 0.03
gcs immediate (null) converts 463,717 128.91 0.23
gcs immediate cr (compatible) converts 1 0.00 0.00
gcs immediate cr (null) converts 9,915,488 2,756.49 4.88
gcs indirect ast 560,892 155.93 0.28
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 512 0.14 0.00
gcs msgs process time(ms) 116,600 32.41 0.06
gcs msgs received 18,923,121 5,260.59 9.30
gcs out-of-order msgs 2 0.00 0.00
gcs pings refused 33 0.01 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 2 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 26 0.01 0.00
gcs side channel msgs actual 338,431 94.08 0.17
gcs side channel msgs logical 1,677,199 466.26 0.82
gcs stale cr 0 0.00 0.00
gcs undo cr 0 0.00 0.00
gcs write notification msgs 10 0.00 0.00
gcs writes refused 0 0.00 0.00
ges msgs process time(ms) 1,216 0.34 0.00
ges msgs received 89,882 24.99 0.04
global posts dropped 0 0.00 0.00
global posts queue time 3 0.00 0.00
global posts queued 29 0.01 0.00
global posts requested 29 0.01 0.00
global posts sent 29 0.01 0.00
implicit batch messages received 2,120,136 589.39 1.04
implicit batch messages sent 536,258 149.08 0.26
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 1,809,977 503.17 0.89
messages queue sent actual 3,175,417 882.76 1.56
messages queue sent logical 3,887,957 1,080.84 1.91
messages received actual 5,980,862 1,662.67 2.94
messages received logical 19,020,049 5,287.54 9.35
messages sent directly 1,715,563 476.92 0.84
messages sent indirectly 1,878,811 522.31 0.92
messages sent not implicit batched 2,639,256 733.71 1.30
messages sent pbatched 8,359,369 2,323.89 4.11
msgs causing lmd to send msgs 34,187 9.50 0.02
msgs causing lms(s) to send msgs 957,486 266.18 0.47
msgs received queue time (ms) 49,757 13.83 0.02
msgs received queued 19,021,275 5,287.88 9.35
msgs sent queue time (ms) 119,618 33.25 0.06
msgs sent queue time on ksxp (ms) 1,463,961 406.98 0.72
msgs sent queued 3,838,429 1,067.08 1.89
msgs sent queued on ksxp 5,733,449 1,593.89 2.82
process batch messages received 1,960,636 545.05 0.96
process batch messages sent 1,022,057 284.13 0.50


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 5,547
CURRENT Block Requests 6,256
Data Block Requests 5,547
Undo Block Requests 112
TX Block Requests 2,838
Current Results 11,314
Private results 186
Zero Results 301
Disk Read Results 0
Fail Results 0
Fairness Down Converts 1,266
Fairness Clears 0
Free GC Elements 0
Flushes 256
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 226
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 5,751 99.95 0.00 0.05 0.00 0.00
Flushes 9 100.00 0.00 0.00 0.00 0.00
Writes 1,015 58.52 40.30 0.20 0.49 0.49


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 7,518 99.81 0.19 0.00 24,300 99.97 0.03 0.00
2 Others 97 98.97 1.03 0.00 122 100.00 0.00 0.00
2 undo header 44 95.45 4.55 0.00 6 100.00 0.00 0.00
2 undo block 5 80.00 20.00 0.00 0      


Back to Top

End of Report