WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
CDLD2217133725cdld1110.2.0.4.0YESp780a

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:6382808-Nov-13 10:00:281345 81.0
End Snap:6382908-Nov-13 11:03:041695 17.2
Elapsed:  62.59 (mins)  
DB Time:  23,698.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: 1,498,936.92 38,292.30
Logical reads: 281,143.04 7,182.17
Block changes: 10,638.66 271.78
Physical reads: 2,203.25 56.28
Physical writes: 850.50 21.73
User calls: 1,881.38 48.06
Parses: 625.43 15.98
Hard parses: 32.55 0.83
Sorts: 1,355.86 34.64
Logons: 11.10 0.28
Executes: 18,192.11 464.74
Transactions: 39.14 

% Blocks changed per Read: 3.78Recursive Call %: 91.57
Rollback per transaction %: 51.96Rows per Sort: 62.38

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.89Redo NoWait %: 98.39
Buffer Hit %: 99.24In-memory Sort %: 100.00
Library Hit %: 99.59Soft Parse %: 94.80
Execute to Parse %: 96.56Latch Hit %: 99.48
Parse CPU to Parse Elapsd %: 3.48% Non-Parse CPU: 65.35

Shared Pool Statistics

BeginEnd
Memory Usage %: 91.19 90.89
% SQL with executions>1: 93.23 95.07
% Memory for SQL w/exec>1: 92.01 94.52

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
buffer busy waits 992,734 950,579 958 66.9Concurrency
latch: shared pool 1,163,239 340,062 292 23.9Concurrency
log file switch completion 232,429 227,250 978 16.0Configuration
enq: TX - index contention 333,196 160,840 483 11.3Concurrency
latch free 5,214,816 111,950 21 7.9Other

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 97.61 2.49
Global Cache blocks served: 161.14 4.12
GCS/GES messages received: 788.37 20.14
GCS/GES messages sent: 855.18 21.85
DBWR Fusion writes: 2.09 0.05
Estd Interconnect traffic (KB) 2,391.05 

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

Buffer access - local cache %: 99.20
Buffer access - remote cache %: 0.03
Buffer access - disk %: 0.76

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 165.3
Avg global cache cr block receive time (ms): 7.4
Avg global cache current block receive time (ms): 2.1
Avg global cache cr block build time (ms): 0.3
Avg global cache cr block send time (ms): 0.1
Global cache log flushes for cr blocks served %: 3.2
Avg global cache cr block flush time (ms): 58.4
Avg global cache current block pin time (ms): 1.4
Avg global cache current block send time (ms): 1.3
Global cache log flushes for current blocks served %: 0.1
Avg global cache current block flush time (ms): 9.7

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 44.4
Avg message sent queue time on ksxp (ms): 21.3
Avg message received queue time (ms): 46.4
Avg GCS message process time (ms): 9.3
Avg GES message process time (ms): 0.5
% of direct sent messages: 28.58
% of indirect sent messages: 67.69
% of flow controlled messages: 3.73

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 1,214,464.43 85.41
parse time elapsed 187,893.52 13.21
DB CPU 19,164.30 1.35
connection management call elapsed time 7,401.42 0.52
hard parse elapsed time 3,939.41 0.28
sequence load elapsed time 3,410.65 0.24
failed parse elapsed time 2,722.74 0.19
hard parse (sharing criteria) elapsed time 1,501.44 0.11
PL/SQL execution elapsed time 897.15 0.06
PL/SQL compilation elapsed time 828.74 0.06
hard parse (bind mismatch) elapsed time 36.75 0.00
repeated bind elapsed time 4.01 0.00
DB time 1,421,893.17  
background elapsed time 84,820.66  
background cpu time 1,315.72  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Concurrency 32,446,836 12.19 1,734,327 53 220.72
Configuration 243,529 99.53 256,341 1053 1.66
Other 842,523,165 0.53 237,827 0 5,731.22
Cluster 849,883 11.03 28,101 33 5.78
User I/O 4,415,767 0.03 22,793 5 30.04
Commit 74,165 15.54 12,823 173 0.50
System I/O 1,214,242 0.00 1,095 1 8.26
Application 84,465 0.85 475 6 0.57
Network 7,305,179 0.00 166 0 49.69

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
buffer busy waits 992,734 98.01 950,579 958 6.75
latch: shared pool 1,163,239 0.00 340,062 292 7.91
log file switch completion 232,429 99.92 227,250 978 1.58
enq: TX - index contention 333,196 98.40 160,840 483 2.27
latch free 5,214,816 0.02 111,950 21 35.47
library cache lock 346,681 65.15 107,771 311 2.36
latch: library cache 342,036 0.02 100,694 294 2.33
ges enter server mode 130,349 99.85 63,575 488 0.89
enq: SQ - contention 9,802 99.34 28,616 2919 0.07
enq: US - contention 282,743 10.84 26,307 93 1.92
cursor: pin S wait on X 2,421,139 100.00 23,695 10 16.47
latch: row cache objects 138,868 0.00 22,906 165 0.94
row cache lock 27,075 24.90 21,567 797 0.18
db file sequential read 4,061,316 0.00 19,969 5 27.63
log file sync 74,165 15.54 12,823 173 0.50
gc current request 18,315 100.00 10,741 586 0.12
gc buffer busy 127,442 51.31 8,527 67 0.87
latch: gcs resource hash 26,423 0.00 8,152 309 0.18
gcs enter server mode 16,613 99.99 8,105 488 0.11
enq: CF - contention 18,016 86.15 7,652 425 0.12
latch: cache buffers chains 267,150 0.00 5,850 22 1.82
latch: KCL gc element parent latch 15,575 0.19 3,159 203 0.11
gc current retry 5,320 99.77 3,106 584 0.04
gc domain validation 1,305 99.85 2,543 1948 0.01
read by other session 89,976 1.30 1,639 18 0.61
gc current grant busy 19,644 12.10 1,411 72 0.13
db file scattered read 204,523 0.00 1,059 5 1.39
enq: PS - contention 2,054 92.60 1,009 491 0.01
latch: messages 2,752 1.56 881 320 0.02
cursor: pin S 832,423,770 0.00 712 0 5,662.52
latch: ges resource hash list 7,004 0.00 682 97 0.05
enq: TT - contention 11,218 11.23 603 54 0.08
enq: PR - contention 184 98.37 593 3222 0.00
wait for split-brain resolution 5,993 99.93 586 98 0.04
enq: TO - contention 9,196 13.32 584 64 0.06
enq: JQ - contention 1,249 96.88 571 457 0.01
gcs resource directory to be unfrozen 383 66.06 565 1475 0.00
gc cr grant 2-way 138,015 0.29 556 4 0.94
kst: async disk IO 938 0.00 555 592 0.01
ges2 LMON to wake up lms - mrcvr 2 20,670 99.98 405 20 0.14
ges lmd/lmses to freeze in rcfg - mrcvr 36,346 99.22 384 11 0.25
db file parallel write 1,019,514 0.00 373 0 6.94
enq: TX - row lock contention 948 74.58 373 394 0.01
gc current grant 2-way 100,037 0.24 331 3 0.68
gc cr multi block request 101,157 0.23 316 3 0.69
os thread startup 341 73.31 253 741 0.00
gcs log flush sync 25,134 33.57 241 10 0.17
checkpoint completed 52 61.54 226 4339 0.00
gc current block 2-way 242,866 0.01 205 1 1.65
gc cr request 156 99.36 190 1217 0.00
enq: TX - allocate ITL entry 380 96.58 180 474 0.00
name-service call wait 381 87.40 167 439 0.00
latch: cache buffers lru chain 1,758 4.66 157 89 0.01
PX Nsq: PQ load info query 156 99.36 149 958 0.00
PX Deq Credit: send blkd 9,867 0.56 127 13 0.07
gc cr block 2-way 29,397 0.09 120 4 0.20
latch: checkpoint queue latch 1,121 0.00 111 99 0.01
SQL*Net break/reset to client 81,285 0.00 94 1 0.55
latch: library cache lock 320 0.00 90 280 0.00
log file sequential read 67,509 0.00 88 1 0.46
gcs drm freeze in enter server mode 169 85.21 77 455 0.00
SQL*Net more data from client 56,995 0.00 76 1 0.39
latch: redo writing 808 0.00 70 86 0.01
db file parallel read 13,566 0.00 69 5 0.09
LNS wait on SENDREQ 627 0.00 64 102 0.00
latch: redo allocation 1,456 0.00 63 44 0.01
rdbms ipc reply 2,131 1.55 57 27 0.01
gc cr disk read 64,637 0.00 47 1 0.44
latch: object queue header operation 9,180 5.77 40 4 0.06
log file parallel write 86,844 0.00 38 0 0.59
direct path read temp 5,178 0.00 31 6 0.04
Log archive I/O 7,918 0.00 31 4 0.05
direct path write temp 18,617 0.00 21 1 0.13
cursor: mutex X 26,413,192 0.00 21 0 179.67
ARCH wait on SENDREQ 1,069 0.00 15 14 0.01
latch: enqueue hash chains 712 0.00 14 20 0.00
ksdxexeotherwait 789,125 100.00 14 0 5.37
enq: WF - contention 35 65.71 11 326 0.00
LGWR wait for redo copy 2,998 36.42 11 4 0.02
ges LMON to get to FTDONE 529 98.11 10 19 0.00
latch: undo global data 48 0.00 9 190 0.00
reliable message 286 3.15 9 31 0.00
enq: TM - contention 2,228 0.58 8 3 0.02
control file sequential read 28,847 0.00 7 0 0.20
ges2 LMON to wake up LMD - mrcvr 481 56.34 7 15 0.00
wait for a undo record 126 46.83 7 56 0.00
kjbdrmcvtq lmon drm quiesce: ping completion 158 20.89 7 44 0.00
global enqueue expand wait 715 100.00 7 10 0.00
wait list latch free 669 0.00 7 10 0.00
Streams AQ: qmn coordinator waiting for slave to start 2 50.00 6 2975 0.00
latch activity 60 100.00 6 98 0.00
SQL*Net more data to client 338,426 0.00 6 0 2.30
wait for scn ack 274 2.19 5 17 0.00
SQL*Net message to client 6,908,059 0.00 5 0 46.99
latch: session allocation 193 0.00 5 24 0.00
direct path read 21,005 0.00 5 0 0.14
gc remaster 13 7.69 5 347 0.00
ksdxexeother 2,742,144 100.00 4 0 18.65
enq: TQ - INI contention 2 50.00 4 1754 0.00
CGS wait for IPC msg 631,493 99.76 3 0 4.30
kksfbc child completion 68 100.00 3 49 0.00
wait for stopper event to be increased 43 65.12 3 74 0.00
gc current block busy 171 0.00 3 18 0.00
DFS lock handle 3,654 0.00 2 1 0.02
wait for membership synchronization 106 100.00 2 20 0.00
ges global resource directory to be frozen 161 98.14 2 10 0.00
control file parallel write 2,595 0.00 1 0 0.02
gc current multi block request 1,299 0.00 1 1 0.01
enq: TX - contention 782 0.00 1 1 0.01
enq: FB - contention 1,274 0.00 1 1 0.01
ARCH wait on ATTACH 1 0.00 1 781 0.00
PX Deq: Test for msg 218 0.00 1 3 0.00
PX Deq: Signal ACK 118 31.36 1 6 0.00
library cache pin 860 0.00 1 1 0.01
latch: cache buffer handles 57 0.00 0 7 0.00
ksxr poll remote instances 43,963 72.19 0 0 0.30
latch: parallel query alloc buffer 7 0.00 0 38 0.00
gc claim 69 0.00 0 3 0.00
direct path write 1,586 0.00 0 0 0.01
kjctssqmg: quick message send wait 183 100.00 0 1 0.00
resmgr:internal state change 1 100.00 0 98 0.00
PX Deq: reap credit 5,228 97.05 0 0 0.04
enq: HW - contention 58 0.00 0 1 0.00
library cache load lock 1 0.00 0 39 0.00
gc cr block busy 34 0.00 0 1 0.00
wait for record update 1 100.00 0 29 0.00
PX qref latch 19,847 82.36 0 0 0.14
ges reconfiguration to start 1 100.00 0 20 0.00
IPC send completion sync 37 97.30 0 0 0.00
log file single write 28 0.00 0 0 0.00
KJC: Wait for msg sends to complete 149 0.00 0 0 0.00
gc current block congested 1 0.00 0 9 0.00
buffer deadlock 399 98.25 0 0 0.00
enq: TA - contention 19 0.00 0 0 0.00
gc current grant congested 2 0.00 0 2 0.00
gc current split 2 0.00 0 2 0.00
enq: UL - contention 1 0.00 0 3 0.00
enq: MD - contention 1 0.00 0 3 0.00
enq: WL - contention 4 0.00 0 0 0.00
enq: PW - flush prewarm buffers 3 0.00 0 1 0.00
gc cr grant congested 1 0.00 0 2 0.00
recovery read 48 0.00 0 0 0.00
enq: RT - contention 2 0.00 0 0 0.00
enq: DR - contention 1 0.00 0 1 0.00
ges inquiry response 1 0.00 0 1 0.00
enq: IR - contention 1 0.00 0 0 0.00
enq: WR - contention 1 0.00 0 0 0.00
lock deadlock retry 68 100.00 0 0 0.00
control file single write 1 0.00 0 0 0.00
ges lmd/lmses to unfreeze in rcfg - mrcvr 1 0.00 0 0 0.00
ARCH wait on DETACH 2 0.00 0 0 0.00
lock escalate retry 12 91.67 0 0 0.00
cursor: mutex S 3 0.00 0 0 0.00
cr request retry 1 100.00 0 0 0.00
SQL*Net message from client 6,907,081 0.00 2,519,717 365 46.99
gcs remote message 4,482,968 97.27 84,181 19 30.50
PX Idle Wait 3,112 95.73 7,465 2399 0.02
Streams AQ: qmn slave idle wait 113 17.70 3,385 29955 0.00
Streams AQ: waiting for time management or cleanup tasks 42 78.57 3,343 79598 0.00
ges remote message 361,788 55.50 2,953 8 2.46
Streams AQ: qmn coordinator idle wait 200 62.00 2,806 14029 0.00
EMON idle wait 573 100.00 2,784 4858 0.00
wait for unread message on broadcast channel 2,342 100.00 2,286 976 0.02
DIAG idle wait 11,327 0.00 2,236 197 0.08
LNS ASYNC end of log 206,734 100.02 2,025 10 1.41
jobq slave wait 663 95.17 1,888 2848 0.00
Streams AQ: waiting for messages in the queue 393 98.73 1,871 4761 0.00
PX Deq: Par Recov Execute 87,322 0.60 1,531 18 0.59
PX Deq: Txn Recovery Start 186 33.87 170 913 0.00
PX Deq: Par Recov Change Vector 222,519 0.00 112 1 1.51
PX Deq: Par Recov Reply 954 0.63 29 30 0.01
PX Deq: Execute Reply 378 21.16 8 21 0.00
PX Deq Credit: need buffer 5,545 0.00 2 0 0.04
PX Deq: Execution Msg 224 11.61 1 6 0.00
PX Deq: Join ACK 134 28.36 1 8 0.00
PX Deq: Parse Reply 114 35.09 0 1 0.00
PX Deq: Msg Fragment 105 12.38 0 1 0.00
class slave wait 9 0.00 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 208 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
events in waitclass Other 4,465,972 96.56 22,879 5 30.38
buffer busy waits 2,668 69.75 1,771 664 0.02
latch: library cache 4,554 1.80 1,707 375 0.03
latch: shared pool 3,244 1.66 913 281 0.02
kst: async disk IO 950 0.00 589 620 0.01
db file parallel write 1,019,515 0.00 373 0 6.94
os thread startup 341 73.31 252 740 0.00
gc current grant 2-way 289 35.29 125 431 0.00
gc domain validation 61 101.64 120 1963 0.00
log file sequential read 68,353 0.00 89 1 0.46
gc cr multi block request 77 74.03 74 967 0.00
latch: redo writing 808 0.00 70 86 0.01
LNS wait on SENDREQ 635 0.00 65 102 0.00
latch: row cache objects 590 0.00 61 103 0.00
log file parallel write 88,041 0.00 39 0 0.60
row cache lock 718 1.25 34 48 0.00
Log archive I/O 8,091 0.00 31 4 0.06
latch: cache buffers chains 636 0.00 19 31 0.00
ARCH wait on SENDREQ 1,069 0.00 15 14 0.01
enq: TM - contention 2,140 0.61 8 4 0.01
db file sequential read 492 0.00 6 12 0.00
control file sequential read 15,708 0.00 5 0 0.11
control file parallel write 2,631 0.00 1 0 0.02
ARCH wait on ATTACH 1 0.00 1 781 0.00
gc current block 2-way 62 0.00 1 11 0.00
db file scattered read 11 0.00 0 20 0.00
direct path read 4,002 0.00 0 0 0.03
gc cr grant 2-way 118 0.00 0 1 0.00
gc buffer busy 2 0.00 0 31 0.00
gc current block busy 1 0.00 0 30 0.00
enq: HW - contention 14 0.00 0 1 0.00
log file single write 32 0.00 0 0 0.00
gc current multi block request 14 0.00 0 1 0.00
gc current block congested 1 0.00 0 9 0.00
gc cr block 2-way 22 0.00 0 0 0.00
direct path write 895 0.00 0 0 0.01
control file single write 1 0.00 0 0 0.00
ARCH wait on DETACH 2 0.00 0 0 0.00
library cache lock 4 -2275.00 -89 -22323 0.00
gcs remote message 4,528,179 97.24 85,318 19 30.80
rdbms ipc message 289,278 18.55 56,144 194 1.97
Streams AQ: waiting for time management or cleanup tasks 42 78.57 3,343 79598 0.00
ges remote message 407,120 50.14 2,993 7 2.77
Streams AQ: qmn coordinator idle wait 200 62.00 2,806 14029 0.00
EMON idle wait 573 100.00 2,784 4858 0.00
pmon timer 1,012 86.46 2,239 2212 0.01
DIAG idle wait 11,326 0.00 2,236 197 0.08
LNS ASYNC end of log 209,840 100.00 2,055 10 1.43
smon timer 55,459 0.69 1,816 33 0.38
PX Deq: Par Recov Reply 954 0.63 29 30 0.01
PX Deq Credit: need buffer 5,545 0.00 2 0 0.04
PX Deq: Join ACK 43 18.60 1 24 0.00
PX Deq: Parse Reply 20 40.00 0 1 0.00
PX Deq: Execute Reply 28 28.57 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 208 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 1,381,955.30 17,870.90 7,919,549 977,314,805
cdld 3,874.30 339.20 145,087 48,564,424
SYS$BACKGROUND 0.00 0.00 180,999 2,422,897

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 4249081 2246492 31326279 141822335 0 0 6818306 3679
cdld 141413 12510 28794 753593 0 0 123256 273
SYS$BACKGROUND 7081 1512 12598 469495 0 0 633 6453

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
664,504 472 4,031 164.85 46.73 4h3tnm388am71   UPDATE ad53a5 SET yae361 = ...
439,806 932 23,890 18.41 30.93 9mq90p42frzgz   INSERT INTO ae09 ( ...
156,963 4 1,052 149.20 11.04 fqc41dwwy880b   SELECT yae115, yae092, yae093 ...
16,515 2 432 38.23 1.16 275gymhxpdpzm JDBC Thin Client UPDATE ad53a4 SET yae3...
11,037 9 93 118.68 0.78 0p8zasbpsfwjv   UPDATE ad53a5 SET yae361 = ...
9,028 1 799 11.30 0.63 cqu92kh8vnyqq   UPDATE ad53a4 SET yae041=:1...
8,892 72 38,762 0.23 0.63 c68g2tvxm20sa   BEGIN pkg_COMM.prc_GetSequence...
8,338 13 1,834 4.55 0.59 5vp6pp9kp47b9   SELECT SEQ_A_YAE500.NEXTVAL FR...
7,882 2 1,196 6.59 0.55 34y4r72q56aqf JDBC Thin Client UPDATE yhcip_ad60 a SET...
6,923 0 1,952 3.55 0.49 byqns0178a0a1 JDBC Thin Client SELECT SEQ_DEFAULT.NEXTVAL fro...

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,080 3,225 454 4.58 0.23 42zwm4yvnztgd JDBC Thin Client SELECT a.yae092 as...
2,036 3,154 462 4.41 0.22 3azdwnhw8a094 JDBC Thin Client SELECT SYSDATE FROM dual
964 1,495 298 3.24 0.11 3b30nr0bm162u JDBC Thin Client SELECT id FROM T_SYSJMS_WLSTOR...
963 1,867 163 5.91 0.13 bts4wka9bk320 SQL*Plus SELECT NVL(SUM(A.AKC226), 0), ...
932 439,806 23,890 0.04 30.93 9mq90p42frzgz   INSERT INTO ae09 ( ...
912 1,501 815 1.12 0.11 9v53122v2dxza JDBC Thin Client select distinct (to_ch...
866 2,876 251 3.45 0.20 36n0mn04vqu6v   BEGIN pkg_p_jjzj.prc_crtQuidsF...
526 851 480 1.10 0.06 2nxwgzg58v6zu JDBC Thin Client select max(aae003) as aae0...
495 694 59,929 0.01 0.05 2hwxauy2yymjv JDBC Thin Client SELECT FB02.AAC003 AS NAME FRO...
491 726 59,947 0.01 0.05 1zvcgsyrftw4u JDBC Thin Client SELECT FB02.AAC003 AS NAME FRO...
472 664,504 4,031 0.12 46.73 4h3tnm388am71   UPDATE ad53a5 SET yae361 = ...
4 156,963 1,052 0.00 11.04 fqc41dwwy880b   SELECT yae115, yae092, yae093 ...
2 16,515 432 0.00 1.16 275gymhxpdpzm JDBC Thin Client UPDATE ad53a4 SET yae3...

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
136,232,409 163 835,781.65 12.90 962.90 1866.74 bts4wka9bk320 SQL*Plus SELECT NVL(SUM(A.AKC226), 0), ...
121,555,125 815 149,147.39 11.51 912.17 1501.00 9v53122v2dxza JDBC Thin Client select distinct (to_ch...
91,464,043 7,467 12,249.10 8.66 423.60 1293.40 260ggyxcr4xbf   SELECT a.yae051 yae051, a.yae1...
60,250,484 59,929 1,005.36 5.71 495.23 694.19 2hwxauy2yymjv JDBC Thin Client SELECT FB02.AAC003 AS NAME FRO...
60,246,507 59,947 1,005.00 5.71 490.50 725.73 1zvcgsyrftw4u JDBC Thin Client SELECT FB02.AAC003 AS NAME FRO...
59,770,540 251 238,129.64 5.66 866.19 2875.93 36n0mn04vqu6v   BEGIN pkg_p_jjzj.prc_crtQuidsF...
46,781,166 7 6,683,023.71 4.43 362.28 760.90 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
36,915,953 1,229 30,037.39 3.50 245.03 962.90 62cz48p67jzt9   SELECT COUNT(1) FROM CC52 WHER...
36,743,574 1,866 19,691.09 3.48 345.62 1480.00 ch3fs7uy0cfsv   BEGIN pkg_W_comm.prc_w_main(:1...
36,095,538 174 207,445.62 3.42 71.99 115.80 87zh2fkrfr7sk w3wp.exe select null, co.owner, co.ta...
32,429,468 699 46,394.09 3.07 338.65 6774.45 fpqbpgdtsnja5   BEGIN pkg_W_comm.prc_w_Query(:...
26,985,166 1,823 14,802.61 2.56 328.50 1906.23 8wqj8zn151043   BEGIN pkg_S_COMM.prc_s_main (:...
18,264,473 10 1,826,447.30 1.73 120.45 3191.67 5akx9pr1af5fz   BEGIN pkg_F_Tellership.prc_Crt...
15,696,922 410 38,285.18 1.49 424.76 1514.82 2t161650jhd42   BEGIN pkg_P_Comm.prc_P_crtFina...
14,497,629 921 15,741.18 1.37 77.27 2476.78 bdu0zfmdt5v54 JDBC Thin Client BEGIN pkg_J_Dyff.Prc_J_qzsh (:...
14,338,972 26,227,967 0.55 1.36 439.04 440.51 5kv0g5aamcn4h   INSERT INTO TMP_AD05COLUMNFILT...
14,179,884 5,063 2,800.69 1.34 227.15 544.96 c4bsu2cz1jhtw   BEGIN pkg_COMM.prc_CrtFinanceI...
13,050,171 26,235,477 0.50 1.24 373.44 453.17 2rau9dc88kngh   UPDATE TMP_AD05COLUMNFILTER SE...
11,991,231 146 82,131.72 1.14 117.75 4037.28 5j31x1u543s8t   insert into tmp_we01(yae051, ...

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
1,364,602 2 682,301.00 16.49 395.57 949.53 5r0daanc938a3   select * from (select rownum a...
407,839 10 40,783.90 4.93 120.45 3191.67 5akx9pr1af5fz   BEGIN pkg_F_Tellership.prc_Crt...
279,063 0   3.37 33.52 1866.53 78r7hwf2vr6hx SQL*Plus DECLARE s_yab003 CHAR(4); ...
263,113 16,631 15.82 3.18 78.15 1155.10 71fss6gf7fm4r oraclecdld1@p590lp2 (TNS V1-V3) SELECT "AKC190", "YKA105", "YK...
122,016 1,866 65.39 1.47 345.62 1480.00 ch3fs7uy0cfsv   BEGIN pkg_W_comm.prc_w_main(:1...
60,644 251 241.61 0.73 866.19 2875.93 36n0mn04vqu6v   BEGIN pkg_p_jjzj.prc_crtQuidsF...
50,115 921 54.41 0.61 77.27 2476.78 bdu0zfmdt5v54 JDBC Thin Client BEGIN pkg_J_Dyff.Prc_J_qzsh (:...
28,054 82,127 0.34 0.34 117.15 2100.07 58h5tztfjz526   SELECT AKC190, YKA103, YKD00...
27,379 107,587 0.25 0.33 152.44 277.40 36p2gr6241mtz   UPDATE IC01 SET YIC586 = SYSDA...
22,499 45 499.98 0.27 321.42 637.52 9rtkyw3tgmwct   select distinct b.yka316 as ...

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
26,235,477 3,393,265 0.13 0.00 0.00 2rau9dc88kngh   UPDATE TMP_AD05COLUMNFILTER SE...
26,227,967 1,809 0.00 0.00 0.00 5kv0g5aamcn4h   INSERT INTO TMP_AD05COLUMNFILT...
180,176 1,179 0.01 0.00 0.00 3ffm1jwvzzv2t   INSERT INTO tmp_ad04_m2 (aae07...
172,185 1,391 0.01 0.00 0.00 39dmujs4s995n   INSERT INTO tmp_ad04_m2 (aae07...
160,425 941 0.01 0.00 0.00 26n1c5v5mdrwp   INSERT INTO tmp_ad04_m2 (aae07...
130,214 914 0.01 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
129,073 128,710 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
107,587 107,587 1.00 0.00 0.00 36p2gr6241mtz   UPDATE IC01 SET YIC586 = SYSDA...
96,651 480 0.00 0.00 0.00 ck0anvagmvwda   INSERT INTO tmp_ad04_m2 (aae07...
92,279 481 0.01 0.00 0.00 gt99a8nm62p38   INSERT INTO tmp_ad04_m2 (aae07...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
130,171 130,214 5.54 0h6b2sajwb74n   select privilege#, level from ...
129,066 129,073 5.50 2ym6hhaq30r73   select type#, blocks, extents,...
101,757 160,425 4.33 26n1c5v5mdrwp   INSERT INTO tmp_ad04_m2 (aae07...
99,775 172,185 4.25 39dmujs4s995n   INSERT INTO tmp_ad04_m2 (aae07...
99,240 180,176 4.23 3ffm1jwvzzv2t   INSERT INTO tmp_ad04_m2 (aae07...
69,610 96,651 2.96 ck0anvagmvwda   INSERT INTO tmp_ad04_m2 (aae07...
65,154 92,279 2.77 gt99a8nm62p38   INSERT INTO tmp_ad04_m2 (aae07...
43,455 43,489 1.85 0k8522rmdzg4k   select privilege# from sysauth...
41,903 41,903 1.78 grwydz59pu6mc   select text from view$ where r...
39,035 39,036 1.66 gj2dg4jc2x3fq w3wp.exe select 99 / 100, 1 - to_numbe...
36,376 60,295 1.55 cfbd91skrtfhn   INSERT INTO tmp_ad04_m2 (aae07...
35,037 59,697 1.49 9t8hdsbdh5twh   INSERT INTO tmp_ad04_m2 (aae07...
33,666 45,780 1.43 d1yt7291tb8pq   INSERT INTO tmp_ad04_m2 (aae07...
31,532 44,672 1.34 70q69du492r5c   INSERT INTO tmp_ad04_m2 (aae07...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
18,519,213 2,063 0.09 9css6bw8u84yt   SELECT a.aaa100 as ...
17,623,095 127 0.08 45t5rk1v0wvrg w3wp.exe SELECT AAA103 FROM AA10A1 WHER...
8,812,498 405 0.04 8hzay2zw3yc4x JDBC Thin Client select aaa103 from cdsi2.aa10...
7,246,514 375 0.03 6r6g3vwg9p393 w3wp.exe select * from (select null tab...
6,840,996 1 0.03 ap8yt8ftwz7hj JDBC Thin Client select /*+ RESULT_CACHE */aaa1...
4,882,160 174 0.02 87zh2fkrfr7sk w3wp.exe select null, co.owner, co.ta...
4,095,126 1 0.02 fhw6psnfb8g61 PB90.EXE select * from (select null tab...
4,040,125 280 0.02 5mw0ksn1paxn5   INSERT INTO tmp_ic04i5 ( ...
3,425,387 1 0.02 gadmm2rr3u5n8 JDBC Thin Client select /*+ RESULT_CACHE */aaa1...
3,423,537 1 0.02 83gbn49knry1z JDBC Thin Client select /*+ RESULT_CACHE */aaa1...
3,296,658 8 0.02 63v12phpwckzq JDBC Thin Client select * from (select rownum a...
3,104,852 241 0.01 ck45pb7dq63qp JDBC Thin Client SELECT a.ahb530 as...
2,405,099 38 0.01 34njtkggt2way JDBC Thin Client select * from (select rownum a...
1,961,121 420 0.01 c213cg9humu1t JDBC Thin Client SELECT c.yae093 as...
1,724,577 39 0.01 0mtvc3f6f7020   select distinct b.yka316 as ...
1,590,960 1,110 0.01 ddkfkj8czzdzh   SELECT COUNT(*) FROM (SELECT A...
1,556,420 9,560 0.01 911y3badh7v5h   INSERT INTO AD04A1 (AAE076, A...
1,362,616 45 0.01 9rtkyw3tgmwct   select distinct b.yka316 as ...
1,161,582 1,593 0.01 7y8kvxzuyg6fw   INSERT INTO tmp_ad04 (aae076, ...
1,153,134 6 0.01 azjrxwjb4yphu JDBC Thin Client select * from (select rownum a...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
528 9,560 911y3badh7v5h   INSERT INTO AD04A1 (AAE076, A...
288 280 5mw0ksn1paxn5   INSERT INTO tmp_ic04i5 ( ...
225 38 34njtkggt2way JDBC Thin Client select * from (select rownum a...
225 38 34njtkggt2way JDBC Thin Client select * from (select rownum a...
225 38 34njtkggt2way JDBC Thin Client select * from (select rownum a...
202 357 6xf29xtgxg9x7 JDBC Thin Client INSERT INTO yhcip_ad60 ( ...
182 503 2gaw5rszx83h0 JDBC Thin Client SELECT a.yae092 as...
172 799 cqu92kh8vnyqq   UPDATE ad53a4 SET yae041=:1...
135 8 63v12phpwckzq JDBC Thin Client select * from (select rownum a...
88 127 45t5rk1v0wvrg w3wp.exe SELECT AAA103 FROM AA10A1 WHER...
71 39 0mtvc3f6f7020   select distinct b.yka316 as ...
69 4,746 0z45hcav2cpnj   select yab275 from AD53...
69 4,746 0z45hcav2cpnj   select yab275 from AD53...
69 1,110 ddkfkj8czzdzh   SELECT COUNT(*) FROM (SELECT A...
61 70 7ccb5zt2cvj99 JDBC Thin Client select c.*, b.ywe005 a...
48 241 ck45pb7dq63qp JDBC Thin Client SELECT a.ahb530 as...
45 46 58nu3sw11004g JDBC Thin Client SELECT a.yhb440 as...
45 46 58nu3sw11004g JDBC Thin Client SELECT a.yhb440 as...
44 1,196 34y4r72q56aqf JDBC Thin Client UPDATE yhcip_ad60 a SET...
44 6,848 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
40 420 c213cg9humu1t JDBC Thin Client SELECT c.yae093 as...
39 224 0jsdzq8h7w7sn JDBC Thin Client DELETE yhcip_ad60 WHERE ...
39 146 5j31x1u543s8t   insert into tmp_we01(yae051, ...
37 1,441 523gqjsz2xgau JDBC Thin Client UPDATE yhcip_ad60 a SET...
37 225 92kgyt769cwys JDBC Thin Client INSERT INTO yhcip_ad61 ( ...
35 383 dtb0h253k5trk JDBC Thin Client SELECT c.yae093 as...
35 1 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
34 432 275gymhxpdpzm JDBC Thin Client UPDATE ad53a4 SET yae3...
32 216 c3hhngpbpvvmk SEVERITY EVALUATION SELECT MARKER_TIMESTAMP FROM M...
30 1 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...
30 4,031 4h3tnm388am71   UPDATE ad53a5 SET yae361 = ...
30 987 c1hphn9z0jt78   SELECT * FROM ad53a4 WHERE ...
29 23,890 9mq90p42frzgz   INSERT INTO ae09 ( ...
27 93 0p8zasbpsfwjv   UPDATE ad53a5 SET yae361 = ...
26 59,697 9t8hdsbdh5twh   INSERT INTO tmp_ad04_m2 (aae07...
26 51 fzaba7vnxp10s   SELECT YAD104, YAA011, YAA01...
26 51 fzaba7vnxp10s   SELECT YAD104, YAA011, YAA01...
26 51 fzaba7vnxp10s   SELECT YAD104, YAA011, YAA01...
26 28,587 gav6pch9hqa72   INSERT INTO tmp_ad04_m2 (aae07...
25 60,295 cfbd91skrtfhn   INSERT INTO tmp_ad04_m2 (aae07...
25 509 fasvw7q199577   select u.name, o.name, t.upda...
23 1,593 7y8kvxzuyg6fw   INSERT INTO tmp_ad04 (aae076, ...
22 6 azjrxwjb4yphu JDBC Thin Client select * from (select rownum a...
22 6 azjrxwjb4yphu JDBC Thin Client select * from (select rownum a...
22 6 azjrxwjb4yphu JDBC Thin Client select * from (select rownum a...
22 6 azjrxwjb4yphu JDBC Thin Client select * from (select rownum a...
22 6 azjrxwjb4yphu JDBC Thin Client select * from (select rownum a...
21 670 83smvp7gzztc5   SELECT a.aab001 as...
21 405 8hzay2zw3yc4x JDBC Thin Client select aaa103 from cdsi2.aa10...
21 128 gzk323qfgm4v3   SELECT YAD104 YAD104, YAD060 ...

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
6,492.88 39.32 16,514.66 1.55 432 275gymhxpdpzm JDBC Thin Client UPDATE ad53a4 SET yae3...
1,404.85 0.90 156,963.45 4.42 1,052 fqc41dwwy880b   SELECT yae115, yae092, yae093 ...
361.88 0.08 439,806.41 932.49 23,890 9mq90p42frzgz   INSERT INTO ae09 ( ...
238.43 3.02 7,882.32 1.58 1,196 34y4r72q56aqf JDBC Thin Client UPDATE yhcip_ad60 a SET...
204.74 67.92 301.43 3.98 41,903 grwydz59pu6mc   select text from view$ where r...
200.61 10.84 1,850.44 2.44 5,630 d0v32cx3t77ar JDBC Thin Client SELECT SUM(AJC097) FROM JC13 W...
153.04 0.02 664,503.97 471.99 4,031 4h3tnm388am71   UPDATE ad53a5 SET yae361 = ...
144.70 19.02 760.90 362.28 7 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
135.46 94.42 143.47 6.21 129,073 2ym6hhaq30r73   select type#, blocks, extents,...
58.53 2.36 2,476.78 77.27 921 bdu0zfmdt5v54 JDBC Thin Client BEGIN pkg_J_Dyff.Prc_J_qzsh (:...
53.63 1.68 3,191.67 120.45 10 5akx9pr1af5fz   BEGIN pkg_F_Tellership.prc_Crt...
51.39 33.41 153.82 2.84 6,848 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
23.75 0.27 8,891.71 72.02 38,762 c68g2tvxm20sa   BEGIN pkg_COMM.prc_GetSequence...
20.52 0.71 2,875.93 866.19 251 36n0mn04vqu6v   BEGIN pkg_p_jjzj.prc_crtQuidsF...
12.11 1.11 1,095.60 19.97 9,560 911y3badh7v5h   INSERT INTO AD04A1 (AAE076, A...
11.44 0.60 1,906.23 328.50 1,823 8wqj8zn151043   BEGIN pkg_S_COMM.prc_s_main (:...
9.12 0.62 1,480.00 345.62 1,866 ch3fs7uy0cfsv   BEGIN pkg_W_comm.prc_w_main(:1...
9.08 0.43 2,100.07 117.15 82,127 58h5tztfjz526   SELECT AKC190, YKA103, YKD00...
5.54 3.99 138.82 1.38 503 2gaw5rszx83h0 JDBC Thin Client SELECT a.yae092 as...
5.38 0.36 1,514.82 424.76 410 2t161650jhd42   BEGIN pkg_P_Comm.prc_P_crtFina...
4.99 0.27 1,835.73 1.07 670 83smvp7gzztc5   SELECT a.aab001 as...
4.58 0.25 1,866.53 33.52 0 78r7hwf2vr6hx SQL*Plus DECLARE s_yab003 CHAR(4); ...
4.41 0.23 1,929.11 465.28 10,183 bq82udbn5skfj   BEGIN PKG_RollBack.prc_Operati...
1.63 0.02 6,774.45 338.65 699 fpqbpgdtsnja5   BEGIN pkg_W_comm.prc_w_Query(:...
1.23 0.44 277.40 152.44 107,587 36p2gr6241mtz   UPDATE IC01 SET YIC586 = SYSDA...
0.74 0.02 4,037.28 117.75 146 5j31x1u543s8t   insert into tmp_we01(yae051, ...
0.38 26.77 1.42 0.33 357 6xf29xtgxg9x7 JDBC Thin Client INSERT INTO yhcip_ad60 ( ...
0.37 0.04 949.53 395.57 2 5r0daanc938a3   select * from (select rownum a...
0.34 0.04 954.91 1.04 1,441 523gqjsz2xgau JDBC Thin Client UPDATE yhcip_ad60 a SET...
0.20 0.14 138.83 0.15 224 0jsdzq8h7w7sn JDBC Thin Client DELETE yhcip_ad60 WHERE ...
0.18 0.02 962.90 245.03 1,229 62cz48p67jzt9   SELECT COUNT(1) FROM CC52 WHER...
0.15 0.75 20.59 0.09 509 fasvw7q199577   select u.name, o.name, t.upda...
0.13 0.01 1,155.10 78.15 16,631 71fss6gf7fm4r oraclecdld1@p590lp2 (TNS V1-V3) SELECT "AKC190", "YKA105", "YK...
0.12 0.02 637.52 321.42 45 9rtkyw3tgmwct   select distinct b.yka316 as ...
0.12 0.00 6,923.44 0.41 1,952 byqns0178a0a1 JDBC Thin Client SELECT SEQ_DEFAULT.NEXTVAL fro...
0.11 0.01 1,293.40 423.60 7,467 260ggyxcr4xbf   SELECT a.yae051 yae051, a.yae1...
0.07 0.00 1,866.74 962.90 163 bts4wka9bk320 SQL*Plus SELECT NVL(SUM(A.AKC226), 0), ...
0.06 0.00 8,337.53 12.61 1,834 5vp6pp9kp47b9   SELECT SEQ_A_YAE500.NEXTVAL FR...
0.05 0.01 544.96 227.15 5,063 c4bsu2cz1jhtw   BEGIN pkg_COMM.prc_CrtFinanceI...
0.05 0.01 453.17 373.44 26,235,477 2rau9dc88kngh   UPDATE TMP_AD05COLUMNFILTER SE...
0.05 0.00 1,474.93 30.78 38 34njtkggt2way JDBC Thin Client select * from (select rownum a...
0.04 0.00 933.65 0.22 225 92kgyt769cwys JDBC Thin Client INSERT INTO yhcip_ad61 ( ...
0.02 0.00 603.13 377.28 1,930 2jd7hg76uhvhb JDBC Thin Client SELECT seq_aae790.NEXTVAL from...
0.01 0.01 115.80 71.99 174 87zh2fkrfr7sk w3wp.exe select null, co.owner, co.ta...
0.01 0.55 2.02 0.35 1,110 ddkfkj8czzdzh   SELECT COUNT(*) FROM (SELECT A...
0.01 0.20 4.01 0.96 127 45t5rk1v0wvrg w3wp.exe SELECT AAA103 FROM AA10A1 WHER...
0.01 0.00 476.66 306.33 39 0mtvc3f6f7020   select distinct b.yka316 as ...
0.01 22.13 0.03 0.03 46 58nu3sw11004g JDBC Thin Client SELECT a.yhb440 as...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0jsdzq8h7w7sn DELETE yhcip_ad60 WHERE yad608 = :1
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0mtvc3f6f7020 select distinct b.yka316 as yka316, b.ykb037 as ykb037, b.ykc179 as ykc179, b.yke150 as yke150, b.aae030 as aae030, b.yke151 as yke151, (select sum(nvl(count(1), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1' group by c.akc190, c.yka103 having sum(c.yka107) + sum(c.yka065) > 0) as ykb009, (case when b.yke239 = '1' then (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') + (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) else (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') end) as yka107, (select nvl(sum(nvl(c.yka065, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') as yka065, (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb03 7 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) as bckkje, (case when b.yke239 = '1' then (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') + (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) else (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c. ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') end) - (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) as sjbfje, (select sum(nvl(count(1), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') in ('0', '2') group by c.akc190, c.yka103 having sum(c.yka065) + sum(c.yka107) >= 0) as bcbyzfrc, (select sum(nvl(sum(nvl(c.yka107, 0)), 0) + nvl(sum(nvl(c.yka065, 0)), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') in ('0', '2') group by c.akc190, c.yka103 having sum(c.yka065) + sum(c.yka107) >= 0) as bcbyzf, b.ykb053 as ykb053, b.akb020 as akb020, b.yab138 as yab138, b.ykb010 as ykb010, b.yka108 as yka108, a.yka032 as yka032, a.aae011 as aae011, a.aae036 as aae036, a.yab003 as yab003, a.ykc151 as ykc151, a.ykc152 as ykc152, a.ykb048 as ykb048, a.ykc153 as ykc153, a.ykc154 as ykc154, a.ykb049 as ykb049, a.yke097 as yke097, c.aae036 as yke058, a.yab141 as yab141, a.yke032 as yke032 from kc32k1 c, kb03k4 d, kb12k3 b, kb12k1 a WHERE a.akb020 = b.akb020 and a.ykb010 = b.ykb010 and a.yab138 = b.yab138 and d.ykb010 = a.ykb010 and d.aae075 = c.aae075 and b.ykb010 is not null and b.yab138 = :1 AND b.YKA108 = :2 AND b.AKB020 = :3 AND b.yka316 = :4 AND b.AKB020 in (select akb020 from kb01 where akb021 like :5||'%') order by yke05 8
0p8zasbpsfwjvUPDATE ad53a5 SET yae361 = :1, yae362 = :2, yae363 = sysdate WHERE yae092 = :3
0z45hcav2cpnj select yab275 from AD53A4 where yae092 = :1
1zvcgsyrftw4uSELECT FB02.AAC003 AS NAME FROM FB02 WHERE FB02.YFB000 IN (SELECT FB01.YFB000 FROM FB01 WHERE FB01.YFB027 = :B2 ) AND FB02.AAC008 = '01' AND YAB003 = :B1 UNION SELECT FB03.AAB004 AS NAME FROM FB03 WHERE FB03.YFB000 IN (SELECT FB01.YFB000 FROM FB01 WHERE FB01.YFB027 = :B2 ) AND FB03.AAC008 = '01' AND YAB003 = :B1
260ggyxcr4xbfSELECT a.yae051 yae051, a.yae100 yae100, a.yae101 yae101, a.yae103 yae103, a.yae162 yae162, a.yae163 yae163, a.yae114 yae114, a.yae049 yae049, a.aaa831 aaa831, a.yae270 yae270, a.yae315 yae315 FROM (select yae049, yae051, yae100, yae101, yae103, yae162, yae163, yae114, aaa831, yae270, yae315 from ad52 where level = :1 and nvl(yae270, '0')!='1' and (yae162 = '0' or yae162=:2) and yae163='1' start with yae049= (select yae049 from ad52 where yae100 is null) connect by prior yae049=yae100) a, ad54 b where a.yae049 = b.yae106 AND b.yae107 = '100050' AND b.yae093 = :3 union select yae051, yae100, yae101, yae103, yae162, yae163, yae114, yae049, aaa831, yae270, yae315 from ad52 where level = :4 and nvl(yae270, '0')!='1' and (yae162 = '0' or yae162=:5) and yae163='0' start with yae049= (select yae049 from ad52 where yae100 is null) connect by prior yae049=yae100
26n1c5v5mdrwpINSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.yab158), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
275gymhxpdpzm UPDATE ad53a4 SET yae361 = '0' , yae362 = 0 WHERE yae092 = :1
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
2gaw5rszx83h0 SELECT a.yae092 as userId, a.yab109 as departId, a.aac003 as "name" , a.aac004 as sex , a.yab003 as orgId , a.yae041 as loginId, a.yae042 as password, a.yae113 as lastLoginRoleId, a.yae376 as lastLoginDepartId, a.yae378 as leaderId, a.yae361 as locked, a.yae362 as passwordFaultNum, a.yae363 as passwordEditTime, a.yae114 as orderId, a.aae100 as available, a.aae011 as operator, a.aae036 as operateTime, a.yad53g as workMode, a.yae098 as phone, a.yae222 as email, a.aae005 as aae005, a.aae006 as aae006, a.aae007 as aae007, a.yae061 as yae061 FROM ad53a4 a WHERE a.yae041 = :1 AND a.aae100 = :2
2hwxauy2yymjvSELECT FB02.AAC003 AS NAME FROM FB02 WHERE FB02.YFB000 IN (SELECT FB01.YFB000 FROM FB01 WHERE FB01.YFB027 = :B2 ) AND FB02.AAC008 = '02' AND YAB003=:B1 UNION SELECT FB03.AAB004 AS NAME FROM FB03 WHERE FB03.YFB000 IN (SELECT FB01.YFB000 FROM FB01 WHERE FB01.YFB027 = :B2 ) AND FB03.AAC008 = '02' AND YAB003=:B1
2jd7hg76uhvhbSELECT seq_aae790.NEXTVAL from dual
2nxwgzg58v6zu select max(aae003) as aae002 from ja04
2rau9dc88knghUPDATE TMP_AD05COLUMNFILTER SET EXIST = '1' WHERE COLNAME = :B1
2t161650jhd42BEGIN pkg_P_Comm.prc_P_crtFinancialInterface(:1, :2, :3, :4, :5, :6, :7, :8, :9); 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
34njtkggt2way select * from (select rownum as myrownum, c.* from ( SELECT a.ahb530 as ahb530, a.ahb400 as ahb400, b.ahb401 as ahb401, b.aab013 as aab013, b.yhb407 as yhb407, b.yad082 as yad082, b.aae008 as aae008, b.aae010 as aae010, a.yha430 as yha430, c.yhc20a as yhc20a, c.yha433 as yha433, c.aab054 as aab054, c.yha432 as yha432, a.yhb440 as yhb440, d.yhb441 as yhb441, d.yhb442 as yhb442, d.yhb443 as yhb443, d.yae113 as yae113_hb44, a.aae030 as aae030, a.aae031 as aae031, a.ahb531 as ahb531, a.yhb531 as yhb531, a.yhb532 as yhb532, a.yhb53l as yhb53l, a.yhb53m as yhb53m, a.yae113 as yae113, a.yhb53p as yhb53p, a.yhb533 as yhb533, a.yhb534 as yhb534, a.yhb535 as yhb535, a.yhb539 as yhb539, a.yhb53b as yhb53b, a.yhb53n as yhb53n, a.yhb53o as yhb53o, a.yhb53a as yhb53a, a.ahc40g as ahc40g, a.yhb53k as yhb53k, a.yhb53c as yhb53c, a.yhb408 as yhb408, a.yhb53j as yhb53j, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae 401 as yae401, a.yhb53u as yhb53u, a.yae422 as yae422, a.yae412 as yae412, a.yae415 as yae415, a.yae402 as yae402, a.yhb53v as yhb53v, a.yae430 as yae430, a.yae429 as yae429, a.yae431 as yae431, a.yae433 as yae433, a.yhb53d as yhb53d, a.yhb53e as yhb53e, a.yhb53f as yhb53f, a.yhb53g as yhb53g, a.yhb53t as yhb53t, a.yhb53q as yhb53q, a.yhb53r as yhb53r, a.yhb53s as yhb53s, a.yhb53h as yhb53h, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.aae163 as aae163, a.yhb53w as yhb53w, nvl(e.trainnum, 0) as trainnum, nvl(e.jobnum, 0) as jobnum, nvl(e.subnum, 0) as subnum FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d. yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.yhb53b = :1 AND (a.yhb53c = '01' or a.yhb53c = '02' or a.yhb53c = '03' or a.yhb53c = '04') AND a.aae011 like '%'||:2||'%' AND a.aae036 < TO_DATE(:3, 'yyyy-MM-dd')+1 order by a.aae036 desc ) c)where myrownum<=10 and myrownum>0
34y4r72q56aqf UPDATE yhcip_ad60 a SET a.yad605 = sysdate WHERE a.yad608 = :1
36n0mn04vqu6vBEGIN pkg_p_jjzj.prc_crtQuidsFinaPlan(:1, :2, :3, :4, :5, :6, :7); END;
36p2gr6241mtzUPDATE IC01 SET YIC586 = SYSDATE, YIC585 = :B6 WHERE YAE202 = :B5 AND AAC001 = :B4 AND AAE002 = :B3 AND NVL(AAE120, '0') = :B2 AND YIC585 = :B1
39dmujs4s995nINSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.aab214), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
3azdwnhw8a094SELECT SYSDATE FROM dual
3b30nr0bm162uSELECT id FROM T_SYSJMS_WLSTORE where id = -1
3ffm1jwvzzv2tINSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.aab215), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
42zwm4yvnztgd SELECT a.yae092 as userId, a.yab109 as departId, a.aac003 as "name" , a.aac004 as sex , a.yab003 as orgId , a.yae041 as loginId, a.yae042 as password, a.yae113 as lastLoginRoleId, a.yae376 as lastLoginDepartId, a.yae378 as leaderId, a.yae361 as locked, a.yae362 as passwordFaultNum, a.yae363 as passwordEditTime, a.yae114 as orderId, a.aae100 as available, a.aae011 as operator, a.aae036 as operateTime, a.yad53g as workMode, a.yae098 as phone, a.yae222 as email, a.aae005 as aae005, a.aae006 as aae006, a.aae007 as aae007, a.yae061 as yae061 FROM ad53a4 a WHERE 1 = 1 AND a.yae092 = :1
45t5rk1v0wvrgSELECT AAA103 FROM AA10A1 WHERE AAA100 = :B2 AND AAA102 = :B1
4h3tnm388am71UPDATE ad53a5 SET yae361 = null, yae362 = null, yae363 = null WHERE yae092 = :1
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
523gqjsz2xgau UPDATE yhcip_ad60 a SET a.yad605 = sysdate, a.yad606 = (select yae051 from ad52 where yae049 = :1) WHERE a.yad608 = :2
58h5tztfjz526SELECT AKC190, YKA103, YKD007, AKA130, YKC117, YKA032, AAC001, AAB001, AAB019, AAB020, YAB136, AAB021, AAC003, AAC004, AAC006, AKC023, YKC021, AKC021, YKC120, YKC150, YAC080, AKB020, AKB021, YKB006, AKB023, AKA101, AKA123, YKA026, YKA093, AAE013, YKE098, YAB139, YKA055, YKA056, YKA111, YKA057, NVL(YKA254, 0), NVL(YKC148, 0), NVL(YKA224, 0), AKB063, YKC173, YKC156, AKC025, NVL(YKA346, 0), NVL(YKA347, 0) FROM KC24K1 WHERE AKC190 = :B3 AND YKA103 = :B2 AND YKD007 = :B1
58nu3sw11004g SELECT a.yhb440 as yhb440, a.ahb400 as ahb400, b.ahb401 as ahb401, a.yae113 as yae113, a.yhb445 as yhb445, a.yhb441 as yhb441, a.yhb442 as yhb442, a.yhb443 as yhb443, a.yhb444 as yhb444, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.yhb446 as yhb446, a.yhb447 as yhb447, a.aae163 as aae163 FROM hb44 a, hb40 b WHERE a.ahb400 = b.ahb400 AND a.ahb400 = :1 AND a.yae113 = :2 AND a.yhb445 = :3 AND a.yhb443 >= TO_DATE(:4, 'yyyy-MM-dd') AND a.yhb443 < TO_DATE(:5, 'yyyy-MM-dd')+1 AND a.yhb446 = :6 order by a.aae036 desc
5akx9pr1af5fzBEGIN pkg_F_Tellership.prc_CrtBankConsignColl (:1, :2, :3, :4, :5, :6, :7, :8, :9); END;
5j31x1u543s8tinsert into tmp_we01(yae051, ywe001, ywe006, tmp000, tmp001, tmp002, tmp003, tmp004, tmp005, tmp006, tmp007, tmp008, tmp009, tmp010, tmp011, tmp012, tmp013, tmp014, tmp015, tmp016, tmp017, tmp018, tmp019, tmp020, tmp021, tmp022, tmp023)select :"SYS_B_0", WC02A1.ywe001, WC02A1.ywe006, :"SYS_B_1", to_char(we01.ywe003, :"SYS_B_2"), WC02A1.AAB001, WC02A1.YWE007, WC02A1.YWE008, WC02A1.AAC001, WC02A1.AAC003, WC02A1.AAC002, WC02A1.AAC013, WC02A1.AAE140, to_char(WC02A1.AAC030, :"SYS_B_3"), to_char(WC02A1.AAC040), WC02A1.YWE010, WC02A1.AAE013, WC02A1.YAB139, to_char(WC02A1.AAE011), to_char(WC02A1.AAE036, :"SYS_B_4"), WC02A1.YAB003, WC02A1.YWE015, to_char(WC02A1.YAE032), to_char(WC02A1.YAE033, :"SYS_B_5"), WC02A1.AAE061, WC02A1.YAC210, WC02A1.AAE150 from WC02A1, we01 where we01.ywe001 = WC02A1.ywe001 AND upper(we01.yae049) = upper(:"SYS_B_6") and WC02A1.aab001 = :"SYS_B_7" and WC02A1.yab139 = :"SYS_B_8" and WC02A1.ywe007 <> :"SYS_B_9"
5kv0g5aamcn4hINSERT INTO TMP_AD05COLUMNFILTER (COLNAME, EXIST, AD05COLNAME) SELECT :B1 , '1', :B2 FROM DUAL WHERE EXISTS (SELECT * FROM TMP_AD05COLUMNFILTER WHERE COLNAME = :B1 ) AND NOT EXISTS (SELECT * FROM TMP_AD05COLUMNFILTER WHERE COLNAME = :B1 AND AD05COLNAME = :B2 )
5mw0ksn1paxn5 INSERT INTO tmp_ic04i5 ( YAB281, AAE001, AAE041, AAE042, AIC020, AAA042, AAA041, BJ, AIC072, LX, AIC075, HJ, AIC041, YAD110, AIC079, AAA043, AAE013) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
5r0daanc938a3 select * from (select rownum as myrownum, c.* from ( select * from ( SELECT a.yic052 as yic052, a.aac001 as aac001, b.aac003 as aac003, a.aae003 as aae003, a.aab001 as aab001, a.aae117 as aae117, sum(case when a.yae104 ='1' then (case when a.yic570 in ('011', '012', '013', '014', '015', '016', '017', '018', '019') then a.aic142 else 0 end ) else 0 end) as jbylj, sum(case when a.yae104 ='1' then (case when a.yic570 in ('101', '105') then a.aic142 else 0 end ) else 0 end) as gghlf, sum(case when a.yae104 ='1' then (case when a.yic570 not in ('011', '012', '013', '014', '015', '016', '017', '018', '019', '101', '105') then a.aic142 else 0 end ) else 0 end) as qtdy, sum(case when a.yae104 ='2' then a.aic142 else 0 end ) as bfylj, sum(case when a.yae104 ='7' then a.aic142 else 0 end ) as zfsbjzbf, sum(case when a.yae104 ='3' then -a.aic142 else 0 end ) as tfylj, sum(case when a.yae104 ='5' then a.aic142 else 0 end ) as tzbfylj, sum(decode(a.yae104, '3', -a.aic142, a.aic142)) as dyhj, a.yab003 as yab003 FROM v_ic14_ic14i1 a, ac01 b where a.aac001 = b.aac001 AND a.yae104 != '4' AND a.aae003 >= :1 AND a.aae003 <= :2 group by a.yic052, a.aac001, b.aac003, a.aae003, a.aab001, a.aae117, a.yab003 )order by aae003 desc ) c)where myrownum<=20 and myrownum>0
5vp6pp9kp47b9SELECT SEQ_A_YAE500.NEXTVAL FROM DUAL
62cz48p67jzt9SELECT COUNT(1) FROM CC52 WHERE AAC001 = :B4 AND YCC523 >= :B3 AND YCC523 <= :B2 AND AAB001 = :B1 AND (SFTF ='0' OR SFTF IS NULL)
63v12phpwckzq select * from (select rownum as myrownum, c.* from ( SELECT a.ahb530 as ahb530, a.ahb400 as ahb400, b.ahb401 as ahb401, b.aab013 as aab013, b.yhb407 as yhb407, b.yad082 as yad082, b.aae008 as aae008, b.aae010 as aae010, a.yha430 as yha430, c.yhc20a as yhc20a, c.yha433 as yha433, c.aab054 as aab054, c.yha432 as yha432, a.yhb440 as yhb440, d.yhb441 as yhb441, d.yhb442 as yhb442, d.yhb443 as yhb443, d.yae113 as yae113_hb44, a.aae030 as aae030, a.aae031 as aae031, a.ahb531 as ahb531, a.yhb531 as yhb531, a.yhb532 as yhb532, a.yhb53l as yhb53l, a.yhb53m as yhb53m, a.yae113 as yae113, a.yhb53p as yhb53p, a.yhb533 as yhb533, a.yhb534 as yhb534, a.yhb535 as yhb535, a.yhb539 as yhb539, a.yhb53b as yhb53b, a.yhb53n as yhb53n, a.yhb53o as yhb53o, a.yhb53a as yhb53a, a.ahc40g as ahc40g, a.yhb53k as yhb53k, a.yhb53c as yhb53c, a.yhb408 as yhb408, a.yhb53j as yhb53j, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae 401 as yae401, a.yhb53u as yhb53u, a.yae422 as yae422, a.yae412 as yae412, a.yae415 as yae415, a.yae402 as yae402, a.yhb53v as yhb53v, a.yae430 as yae430, a.yae429 as yae429, a.yae431 as yae431, a.yae433 as yae433, a.yhb53d as yhb53d, a.yhb53e as yhb53e, a.yhb53f as yhb53f, a.yhb53g as yhb53g, a.yhb53t as yhb53t, a.yhb53q as yhb53q, a.yhb53r as yhb53r, a.yhb53s as yhb53s, a.yhb53h as yhb53h, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.aae163 as aae163, a.yhb53w as yhb53w, nvl(e.trainnum, 0) as trainnum, nvl(e.jobnum, 0) as jobnum, nvl(e.subnum, 0) as subnum FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d. yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.yhb53b = :1 AND (a.yhb53c = '05' or a.yhb53c = '06' or a.yhb53c = '07' or a.yhb53c = '09' or a.yhb53c = '08') AND e.trainnum IS NOT NULL AND a.yae429 = :2 AND a.aae011 like '%'||:3||'%' AND a.aae036 < TO_DATE(:4, 'yyyy-MM-dd')+1 order by a.aae036 desc ) c)where myrownum<=10 and myrownum>0
6r6g3vwg9p393select * from (select null table_qualifier, decode (o1.owner, :"SYS_B_00", chr(:"SYS_B_01"), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner, :"SYS_B_02", decode(o1.object_type, :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", o1.object_type), :"SYS_B_07", decode(o1.object_type, :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", o1.object_type), o1.object_type) table_type, null remarks from all_objects o1 where o1.object_type in (:"SYS_B_12", :"SYS_B_13")union select null table_qualifier, decode (o2.owner , :"SYS_B_14", chr(:"SYS_B_15"), o2.owner) table_owner, o2.object_name table_name, :"SYS_B_16" table_type, null remarks from all_objects o2, all_objects o3, all_synonyms s where o2.object_type = :"SYS_B_17" and o3.object_type in (:"SYS_B_18", :"SYS_B_19") and o2.owner = s.owner and o2.object_name = s.synonym_name and s.table_owner = o3.owner and s.table_name = o3.object_name) tables where :"SYS_B_20"=:"SYS_B_21" and table_owner like :"SYS_B_22" escape :"SYS_B_23" and table_name like :"SYS_B_24" escape :"SYS_B_25" order by :"SYS_B_26", :"SYS_B_27", :"SYS_B_28"
6xf29xtgxg9x7 INSERT INTO yhcip_ad60 ( yad608, yad600, aae017, yae092, yad601, aac003, aae005, yad602, yad604, yad607, yad603, yad605, yad606) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, SYSDATE, SYSDATE, :11)
70q69du492r5cINSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.yab260), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
71fss6gf7fm4rSELECT "AKC190", "YKA105", "YKA003", "YKA001", "YKA094", "YKA095", "AKC226", "AKC225", "YKA315", "YKA319", "YKE123", "YKE216" FROM "KC22K2" "B" WHERE "AKC190"=:1 AND "YKE216"='01'
78r7hwf2vr6hx DECLARE s_yab003 CHAR(4); CURSOR cur_yab003 IS SELECT yab003 FROM yh00_yab003_tj_lk ORDER BY yab003; cursor cur_ykb010 IS SELECT a.ykb010 FROM yh00_ykb010_2013_10 a WHERE a.yab138 = s_yab003 AND NOT EXISTS (SELECT 1 FROM YH00_KC24K2_2013_10 WHERE ykb010 = a.ykb010); BEGIN OPEN cur_yab003; LOOP FETCH cur_yab003 INTO s_yab003; EXIT WHEN cur_yab003%notfound; FOR cur_1 IN cur_ykb010 LOOP BEGIN INSERT INTO YH00_KC24K2_2013_10 SELECT B.AKC190, --AKC190, VARCHAR2(20) not null, B.YKA103, --YKA103, VARCHAR2(20) not null, B.YKD007, --YKD007, VARCHAR2(6) not null, B.AKA213, --AKA213, VARCHAR2(6) not null, A.AAC001, --AAC001, VARCHAR2(20), A.AKB020, --AKB020, VARCHAR2(20), A.AKB023, --AKB023, VARCHAR2(6), A.AKA101, --AKA101, VARCHAR2(6), A.AKA130, --AKA130, VARCHAR2(6), A.AKC021, --AKC021, VARCHAR2(6), B.YKB010, --YKB010, VARCHAR2(20), A.AKB063, --AKB063, NUMBER(6), --???? A.YKA055, --YKA055, NUMBER(14, 2), --????? A.YKA056, --YKA056, NUMBER( 14, 2), --????? A.YKA057, --YKA057, NUMBER(14, 2), --?????? A.YKA111, --YKA111, NUMBER(14, 2), --?????? B.YKA107, --YKA107, NUMBER(14, 2), --???? NULL , --YKA107, NUMBER(14, 2), --???? B.YKA065, --YKA065, NUMBER(14, 2), --???????? B.YKA115, --YKA115, NUMBER(14, 2), --????? B.YKA058, --YKA058, NUMBER(14, 2), --??????? NULL , --TCZFBF, NUMBER(14, 2), --?????? NULL , --ZFFYZB, NUMBER(14, 2), --?????? NULL , --MLNYPF, NUMBER(14, 2), --?????? NULL , --MLWYPF, NUMBER(14, 2), --?????? NULL , --ZCNJCF, NUMBER(14, 2), --???????? NULL , --ZCWJCF, NUMBER(14, 2), --???????? NULL , --ZCNFWF, NUMBER(14, 2), --???????? NULL , --ZCWFWF, NUMBER(14, 2), --???????? NULL, NULL, NULL, A.YAB139, --YAB139, CHAR(4), B.YKB037, --YKB037, CHAR(4), NULL , --AAE076, VARCHAR2(20), NULL , --YWDDSJ, DATE, NULL , --AAB191 DATE b.yka054, NULL, NULL, NULL FROM kc24k1 a, kc24k2 b WHERE a.akc190 = b.akc190 AND a.yka103 = b.yka103 AND a.ykd007 = b.ykd007 AND b.aka213 = '0101' AND b.ykb010 = cur_1.ykb010 AND a.aka130 IN ('0101', '0201', '0202', '0302', '0301', '0304', '0305', '0306', '0307', '0308') AND 1 = (SELECT count(DISTINCT d.ykd007) FROM kc24k2 d WHERE d.akc190 = b.akc190 AND d.yka103 = b.yka103); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line('???'|| cur_1.ykb010 ||SQLERRM); RETURN; END; commit; END LOOP; DELETE FROM yh00_yab003_tj_lk WHERE yab003 = s_yab003; COMMIT; END LOOP; CLOSE cur_yab003; END;
7ccb5zt2cvj99select c.*, b.ywe005 as companyOrPersonId, b.ywe004 as identityType, b.aac002 as idCard, b.ywe006 as companyOrPersonName from ( SELECT a.yae092 as userId, a.yab109 as departId, a.aac003 as "name" , a.aac004 as sex , a.yab003 as orgId , a.yae041 as loginId, a.yae042 as password, a.yae113 as lastLoginRoleId, a.yae376 as lastLoginDepartId, a.yae378 as leaderId, a.yae361 as locked, a.yae362 as passwordFaultNum, a.yae363 as passwordEditTime, a.yae114 as orderId, a.aae100 as available, a.aae011 as operator, a.aae036 as operateTime, a.yad53g as workMode, a.yae098 as phone, a.yae222 as email, a.aae005 as aae005, a.aae006 as aae006, a.aae007 as aae007, a.yae061 as yae061 FROM ad53a4 a where 1=1 and a.aae100 = 1 AND a.yae041 = :1 AND a.aae100 = :2 ) c left join yhcip_wd01 b on c.userId = b.yae092
7y8kvxzuyg6fwINSERT INTO tmp_ad04 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT :1, trim(:2), :3, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.aab214), 0), :4, TO_DATE(:5, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:6) FROM ab15a1, ad05 WHERE ab15a1.aae076 = :7 AND ab15a1.aae076=:8 AND ab15a1.yab003 = :9 AND LOWER(TRIM(ad05.aad050)) = :10 AND ad05.yad104 = :11 AND ad05.yab003 = :12 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:13 AND ad05.yad037 = :14 GROUP BY ad05.yad104, ad05.aad031, ad05.aad032, ab15a1.yab003
83gbn49knry1zselect /*+ RESULT_CACHE */aaa100, aaa102, aaa103, aae120 FROM cdsi2.aa10a1 WHERE aaa100 in ('AAC004', 'YKC156', 'AAC005', 'AAC008', 'AAC009', 'YAC214', 'YAD050') order by aaa100, aaa102
83smvp7gzztc5 SELECT a.aab001 as aab001, a.yab003 as yab003, a.aae140 as aae140, a.aac001 as aac001, a.aac012 as aac012, a.aac014 as aac014, a.aac013 as aac013, a.aac020 as aac020, a.aac031 as aac031, a.aac015 as aac015, a.aac030 as aac030, a.yac002 as yac002, a.yab013 as yab013, a.yac033 as yac033, a.yac004 as yac004, a.aac040 as aac040, a.yae103 as yae103, a.yae097 as yae097, a.yae100 as yae100, a.yae101 as yae101, a.yae102 as yae102, a.aae013 as aae013, a.aae011 as aae011, a.aae036 as aae036, b.aac003 as aac003, c.aab004 as aab004, (select max(yae204) from kc03 where aac001=:1 group by aac001) as aae036_01 FROM ac02 a, ac01 b, ab01 c WHERE a.aac001 = b.aac001 AND a.aab001 = c.aab001 AND a.aae140= '03' AND a.aac001 = :2 AND a.yab003 = :3 order by a.aae036 desc
87zh2fkrfr7sk select null, co.owner, co.table_name, co.column_name, decode(data_type, :"SYS_B_000", :"SYS_B_001", :"SYS_B_002", :"SYS_B_003", :"SYS_B_004", :"SYS_B_005", :"SYS_B_006", -:"SYS_B_007", :"SYS_B_008", -:"SYS_B_009", :"SYS_B_010", :"SYS_B_011", :"SYS_B_012", -:"SYS_B_013", :"SYS_B_014", :"SYS_B_015", :"SYS_B_016", :"SYS_B_017", :"SYS_B_018"), data_type, decode(data_type, :"SYS_B_019", :"SYS_B_020", :"SYS_B_021", :"SYS_B_022", :"SYS_B_023", :"SYS_B_024", :"SYS_B_025", :"SYS_B_026", :"SYS_B_027", :"SYS_B_028", :"SYS_B_029", decode(data_precision, null, decode(data_scale, null, :"SYS_B_030", :"SYS_B_031", :"SYS_B_032", :"SYS_B_033"), data_precision), data_length), decode(data_type, :"SYS_B_034", :"SYS_B_035", :"SYS_B_036", :"SYS_B_037", :"SYS_B_038", decode(data_precision, null, decode(data_scale, null, :"SYS_B_039", :"SYS_B_040", :"SYS_B_041", :"SYS_B_042"), data_precision + :"SYS_B_043"), :"SYS_B_044", :"SYS_B_045", :"SYS_B_046", :"SYS_B_047", data_length), decode(data_type, :"SYS_B_048", :"SYS_B_049", :"SYS_B_050", null, data_scale), decode(data_type, :"SYS_B_051", :"SYS_B_052", :"SYS_B_053", :"SYS_B_054", :"SYS_B_055", :"SYS_B_056", null), decode(nullable, :"SYS_B_057", :"SYS_B_058", :"SYS_B_059", :"SYS_B_060", :"SYS_B_061"), null, co.column_id from all_tab_columns co where :"SYS_B_062"=:"SYS_B_063" and co.owner like :"SYS_B_064" escape :"SYS_B_065" and co.table_name like :"SYS_B_066" escape :"SYS_B_067" union select null, decode (sy.owner, :"SYS_B_068", chr(:"SYS_B_069"), sy.owner), sy.synonym_name, co.column_name, decode(data_type, :"SYS_B_070", :"SYS_B_071", :"SYS_B_072", :"SYS_B_073", :"SYS_B_074", :"SYS_B_075", :"SYS_B_076", -:"SYS_B_077", :"SYS_B_078", -:"SYS_B_079", :"SYS_B_080", :"SYS_B_081", :"SYS_B_082", -:"SYS_B_083", :"SYS_B_084", :"SYS_B_085", :"SYS_B_086", :"SYS_B_087", :"SYS_B_088"), data_type, decode(data_type, :"SYS_B_089", :"SYS_B_090", :"SYS_B_091", :"SYS_B_092", :"SYS_B_093", :"SYS_B_094", :"SYS_B_095", :"SYS_B_096", :"SYS_B_097", :"SYS_B_098", :"SYS_B_099", decode(data_precision, null, decode(data_scale, null, :"SYS_B_100", :"SYS_B_101", :"SYS_B_102", :"SYS_B_103"), data_precision), data_length), decode(data_type, :"SYS_B_104", :"SYS_B_105", :"SYS_B_106", :"SYS_B_107", :"SYS_B_108", decode(data_precision, null, decode(data_scale, null, :"SYS_B_109", :"SYS_B_110", :"SYS_B_111", :"SYS_B_112"), data_precision + :"SYS_B_113"), :"SYS_B_114", :"SYS_B_115", :"SYS_B_116", :"SYS_B_117", data_length), decode(data_type, :"SYS_B_118", :"SYS_B_119", :"SYS_B_120", null, data_scale), decode(data_type, :"SYS_B_121", :"SYS_B_122", :"SYS_B_123", :"SYS_B_124", :"SYS_B_125", :"SYS_B_126", null), decode(nullable, :"SYS_B_127", :"SYS_B_128", :"SYS_B_129", :"SYS_B_130", :"SYS_B_131"), null, co.column_id from all_tab_columns co, all_synonyms sy where co.owner = sy.table_owne r and co.table_name = sy.table_name and sy.owner like :"SYS_B_132" escape :"SYS_B_133" and sy.synonym_name like :"SYS_B_134" escape :"SYS_B_135" order by :"SYS_B_136", :"SYS_B_137", :"SYS_B_138", :"SYS_B_139"
8hzay2zw3yc4xselect aaa103 from cdsi2.aa10a1 WHERE aaa100 =:1 and aaa102 =:2
8wqj8zn151043BEGIN pkg_S_COMM.prc_s_main (:1, :2, :3, :4, :5, :6); END;
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 )
92kgyt769cwys INSERT INTO yhcip_ad61 ( yad608, yad600, aae017, yae092, yad601, aac003, aae005, yad602, yad604, yad607, yad603, yad605, yad606, yad611) SELECT yad608, yad600, aae017, yae092, yad601, aac003, aae005, yad602, yad604, yad607, yad603, SYSDATE, yad606, ROUND((SYSDATE - yad603)*24*3600) FROM yhcip_ad60 WHERE yad608 = :1
9css6bw8u84yt SELECT a.aaa100 as codeType, a.aaa102 as codeValue, a.aaa101 as codeTypeDESC, a.aaa103 as codeDESC, a.yab003 as orgId, a.aae120 as validFlag FROM aa10a1 a WHERE a.aaa100 = :1 AND a.aaa102 = :2 AND a.yab003 = :3 ORDER BY a.aaa100 , a.aaa102
9mq90p42frzgz INSERT INTO ae09 ( aae217, yae041, yab109, yae093, aae206, aae213, aae214, aae215, aae216, aae211, aae013, aac003, aae218, yab110, yae043) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15)
9rtkyw3tgmwct select distinct b.yka316 as yka316, b.ykb037 as ykb037, b.ykc179 as ykc179, b.yke150 as yke150, b.aae030 as aae030, b.yke151 as yke151, (select sum(nvl(count(1), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1' group by c.akc190, c.yka103 having sum(c.yka107) + sum(c.yka065) > 0) as ykb009, (case when b.yke239 = '1' then (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') + (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) else (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') end) as yka107, (select nvl(sum(nvl(c.yka065, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') as yka065, (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb03 7 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) as bckkje, (case when b.yke239 = '1' then (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') + (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) else (select nvl(sum(nvl(c.yka107, 0)), 0) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c. ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') = '1') end) - (select nvl(sum(nvl(e.yka324, 0)), 0) from kb09k4 e where e.akc190 in (select d.akc190 from kb03k9 d where d.ykb053 = b.ykb053 and d.akb020 = b.akb020 and d.yka316 = b.yka316 and d.ykb037 = b.ykb037 and d.yab138 = b.yab138) and e.akb020 = b.akb020 and e.ykb010 = b.ykb010) as sjbfje, (select sum(nvl(count(1), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') in ('0', '2') group by c.akc190, c.yka103 having sum(c.yka065) + sum(c.yka107) >= 0) as bcbyzfrc, (select sum(nvl(sum(nvl(c.yka107, 0)), 0) + nvl(sum(nvl(c.yka065, 0)), 0)) from kb03k9 c where c.ykb053 = b.ykb053 and c.akb020 = b.akb020 and c.yka316 = b.yka316 and c.ykb037 = b.ykb037 and c.yab138 = b.yab138 and nvl(c.yke248, '1') in ('0', '2') group by c.akc190, c.yka103 having sum(c.yka065) + sum(c.yka107) >= 0) as bcbyzf, b.ykb053 as ykb053, b.akb020 as akb020, b.yab138 as yab138, b.ykb010 as ykb010, b.yka108 as yka108, a.yka032 as yka032, a.aae011 as aae011, a.aae036 as aae036, a.yab003 as yab003, a.ykc151 as ykc151, a.ykc152 as ykc152, a.ykb048 as ykb048, a.ykc153 as ykc153, a.ykc154 as ykc154, a.ykb049 as ykb049, a.yke097 as yke097, c.aae036 as yke058, a.yab141 as yab141, a.yke032 as yke032 from kc32k1 c, kb03k4 d, kb12k3 b, kb12k1 a WHERE a.akb020 = b.akb020 and a.ykb010 = b.ykb010 and a.yab138 = b.yab138 and d.ykb010 = a.ykb010 and d.aae075 = c.aae075 and b.ykb010 is not null and b.yab138 = :1 AND b.YKA108 = :2 AND b.AKB020 = :3 AND b.yka316 = :4 order by yke058
9t8hdsbdh5twhINSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.yab160), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
9v53122v2dxza select distinct (to_char(to_date(sdate, 'yyyymmdd'), 'YYYY') || '?' || to_char(to_date(sdate, 'yyyymmdd'), 'mm') || '?' || to_char(to_date(sdate, 'yyyymmdd'), 'dd') || '?' )as sdate, s, f_getnotice(b.sdate, b.s, b.cnum, :1) as con, decode(b.cnum, 1, '???', 2, '???', 3, '???', 4, '???', 5, '???', 6, '???') as th, TO_CHAR(TO_DATE(sdate, 'YYYYMMDD'), 'DAY') as week, cnum from fb_dateweek b where sdate = to_char(trunc(to_date(substr(f_getQuerySartDateByCurDate(''), 0, 8), 'yyyy-mm-dd')+:2), 'yyyymmdd') order by sdate, s, cnum
ap8yt8ftwz7hjselect /*+ RESULT_CACHE */aaa100, aaa102, aaa103, aae120 FROM cdsi2.aa10a1 WHERE aaa100 in ('YAC210', 'AAC031') order by aaa100, aaa102
azjrxwjb4yphu select * from (select rownum as myrownum, c.* from ( SELECT a.ahb530 as ahb530, a.ahb400 as ahb400, b.ahb401 as ahb401, b.aab013 as aab013, b.yhb407 as yhb407, b.yad082 as yad082, b.aae008 as aae008, b.aae010 as aae010, a.yha430 as yha430, c.yhc20a as yhc20a, c.yha433 as yha433, c.aab054 as aab054, c.yha432 as yha432, a.yhb440 as yhb440, d.yhb441 as yhb441, d.yhb442 as yhb442, d.yhb443 as yhb443, d.yae113 as yae113_hb44, a.aae030 as aae030, a.aae031 as aae031, a.ahb531 as ahb531, a.yhb531 as yhb531, a.yhb532 as yhb532, a.yhb53l as yhb53l, a.yhb53m as yhb53m, a.yae113 as yae113, a.yhb53p as yhb53p, a.yhb533 as yhb533, a.yhb534 as yhb534, a.yhb535 as yhb535, a.yhb539 as yhb539, a.yhb53b as yhb53b, a.yhb53n as yhb53n, a.yhb53o as yhb53o, a.yhb53a as yhb53a, a.ahc40g as ahc40g, a.yhb53k as yhb53k, a.yhb53c as yhb53c, a.yhb408 as yhb408, a.yhb53j as yhb53j, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae 401 as yae401, a.yhb53u as yhb53u, a.yae422 as yae422, a.yae412 as yae412, a.yae415 as yae415, a.yae402 as yae402, a.yhb53v as yhb53v, a.yae430 as yae430, a.yae429 as yae429, a.yae431 as yae431, a.yae433 as yae433, a.yhb53d as yhb53d, a.yhb53e as yhb53e, a.yhb53f as yhb53f, a.yhb53g as yhb53g, a.yhb53t as yhb53t, a.yhb53q as yhb53q, a.yhb53r as yhb53r, a.yhb53s as yhb53s, a.yhb53h as yhb53h, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.aae163 as aae163, a.yhb53w as yhb53w, nvl(e.trainnum, 0) as trainnum, nvl(e.jobnum, 0) as jobnum, nvl(e.subnum, 0) as subnum FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d. yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.yhb53b = :1 AND a.yhb53k = :2 AND a.yhb53c = :3 AND e.trainnum IS NOT NULL AND a.aae017 like :4||'%' AND a.aae036 < TO_DATE(:5, 'yyyy-MM-dd')+1 order by a.aae036 desc ) c)where myrownum<=10 and myrownum>0
bdu0zfmdt5v54BEGIN pkg_J_Dyff.Prc_J_qzsh (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); END;
bq82udbn5skfjBEGIN PKG_RollBack.prc_OperationLog (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
bts4wka9bk320SELECT NVL(SUM(A.AKC226), 0), NVL(SUM(A.YKA315), 0) FROM KC22K2 A WHERE A.AKB020 = :B2 AND A.YKA094 = :B1 AND EXISTS (SELECT 1 FROM KC24K2 WHERE AKC190 = A.AKC190 AND AAE036 >= :B4 AND AAE036 < :B3 AND AKB020 = A.AKB020 AND AKA130 IN ('0301', '0302', '0304', '0305', '0306', '0307', '0308'))
byqns0178a0a1SELECT SEQ_DEFAULT.NEXTVAL from dual
c1hphn9z0jt78SELECT * FROM ad53a4 WHERE yae092 = :1 AND aae100 = '1'
c213cg9humu1t SELECT c.yae093 as roleId, c.yab109 as departId, c.aae100 as available, c.aae011 as operator, c.aae036 as operateTime FROM ad53a4 a, ad53a6 b , ad53a7 c WHERE a.yae092 = b.yae092 AND b.yae093 = c.yae093 AND b.yab109 = c.yab109 AND a.yae092 = :1 AND b.yae092 = :2 AND a.aae100 = :3 AND c.aae100 = :4 UNION SELECT d.yae374 as roleId, d.yab109 as departId, d.aae100 as available, d.aae011 as operator, d.aae036 as operateTime FROM ad53a4 a, ad53a6 b , ad53a7 c, ad53a3 d, ad53a4 e WHERE a.yae092 = b.yae092 AND b.yae093 = c.yae093 AND d.yae093 = c.yae093 AND b.yae093 = d.yae093 AND b.yab109 = c.yab109 AND d.yab109 = c.yab109 AND b.yab109 = d.yab109 AND d.yae375 = a.yae092 AND d.yae092 = e.yae092 AND e.yae092 = :5 AND d.yae092 = :6 AND a.aae100 = :7 AND c.aae100 = :8 AND d.aae100 = :9 AND e.aae100 = :10 AND ( d.aae030 IS NULL OR TRUNC(d.aae030, 'DD') <= :11 ) AND ( d.aae031 IS NULL OR TRUNC(d.aae031 + 1, 'DD') > :12 )
c3hhngpbpvvmkSELECT MARKER_TIMESTAMP FROM MGMT_AVAILABILITY_MARKER WHERE TARGET_GUID = :B1
c4bsu2cz1jhtwBEGIN pkg_COMM.prc_CrtFinanceInterface (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11); END;
c68g2tvxm20saBEGIN pkg_COMM.prc_GetSequence (:1, :2, :3, :4, :5); END;
cfbd91skrtfhnINSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.aab213), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
ch3fs7uy0cfsvBEGIN pkg_W_comm.prc_w_main(:1, :2, :3, :4, :5, :6); END;
ck0anvagmvwdaINSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.yab157), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
ck45pb7dq63qp SELECT a.ahb530 as ahb530, a.ahb400 as ahb400, b.ahb401 as ahb401, b.aab013 as aab013, b.yhb407 as yhb407, b.yad082 as yad082, b.aae008 as aae008, b.aae010 as aae010, a.yha430 as yha430, c.yhc20a as yhc20a, c.yha433 as yha433, c.aab054 as aab054, c.yha432 as yha432, a.yhb440 as yhb440, d.yhb441 as yhb441, d.yhb442 as yhb442, d.yhb443 as yhb443, d.yae113 as yae113_hb44, a.aae030 as aae030, a.aae031 as aae031, a.ahb531 as ahb531, a.yhb531 as yhb531, a.yhb532 as yhb532, a.yhb53l as yhb53l, a.yhb53m as yhb53m, a.yae113 as yae113, a.yhb53p as yhb53p, a.yhb533 as yhb533, a.yhb534 as yhb534, a.yhb535 as yhb535, a.yhb539 as yhb539, a.yhb53b as yhb53b, a.yhb53n as yhb53n, a.yhb53o as yhb53o, a.yhb53a as yhb53a, a.ahc40g as ahc40g, a.yhb53k as yhb53k, a.yhb53c as yhb53c, a.yhb408 as yhb408, a.yhb53j as yhb53j, a.yae421 as yae421, a.yae411 as yae411, a.yae414 as yae414, a.yae401 as yae401, a.yhb53u as yhb53u, a.yae422 as yae422, a.yae412 as yae412, a.yae415 as yae415, a.yae402 as yae402, a.yhb53v as yhb53v, a.yae430 as yae430, a.yae429 as yae429, a.yae431 as yae431, a.yae433 as yae433, a.yhb53d as yhb53d, a.yhb53e as yhb53e, a.yhb53f as yhb53f, a.yhb53g as yhb53g, a.yhb53t as yhb53t, a.yhb53q as yhb53q, a.yhb53r as yhb53r, a.yhb53s as yhb53s, a.yhb53h as yhb53h, a.aae076 as aae076, a.aja015 as aja015, a.aae013 as aae013, a.aae011 as aae011, a.yae116 as yae116, a.aae017 as aae017, a.aae036 as aae036, a.aae163 as aae163, a.yhb53w as yhb53w, nvl(e.trainnum, 0) as trainnum, nvl(e.jobnum, 0) as jobnum, nvl(e.subnum, 0) as subnum FROM hb53 a, hb40 b, ha43 c, hb44all d, (SELECT a.ahb530 AS ahb530, COUNT(1) AS trainnum, NVL(SUM(CASE WHEN a.ahc40h = 'Y' THEN 1 ELSE 0 END), 0) AS jobnum, NVL(SUM(CASE WHEN a.yae421 IS NOT NULL THEN 1 ELSE 0 END), 0) AS subnum FROM hc40 a WHERE 1 = 1 GROUP BY a.ahb530 ) e WHERE a.ahb400 = b.ahb400 AND a.yha430 = c.yha430 AND a.yhb440 = d.yhb440(+) AND a.ahb530 = e.ahb530(+) AND a.ahb5 30 = :1
cqu92kh8vnyqqUPDATE ad53a4 SET yae041=:1, yae042=:2, yab109=:3, yae116=:4, yae113=:5, yab003=:6, yab275=:7, aac002=:8, aae218=:9, yae525=:10, yae524=:11 WHERE yae092=:12 AND aae100 = '1'
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;
d0v32cx3t77arSELECT SUM(AJC097) FROM JC13 WHERE AJE080 = :B1 AND AJA002 = '101' AND AJA005 = '1'
d1yt7291tb8pqINSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.yab261), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
ddkfkj8czzdzhSELECT COUNT(*) FROM (SELECT A.AAC001, A.AAE001 FROM KC60 A WHERE A.AAC001 = :B2 AND A.AAE001 = :B1 UNION ALL SELECT A.AAC001, A.AAE001 FROM KC60K1 A WHERE A.AAC001 = :B2 AND A.AAE001 = :B1 )
dtb0h253k5trk SELECT c.yae093 as roleId, c.yab109 as departId, c.aae100 as available, c.aae011 as operator, c.aae036 as operateTime FROM ad53a4 a, ad53a6 b , ad53a7 c WHERE a.yae092 = b.yae092 AND b.yae093 = c.yae093 AND b.yab109 = c.yab109 AND b.yae093 = :1 AND c.yae093 = :2 AND b.yab109 = :3 AND c.yab109 = :4 AND a.yae092 = :5 AND b.yae092 = :6 AND a.aae100 = :7 AND c.aae100 = :8
fasvw7q199577select u.name, o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o, user$ u, trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# and bitand(property, 16)=0 and bitand(property, 8)=0 order by o.obj#
fhw6psnfb8g61select * from (select null table_qualifier, decode (o1.owner, 'PUBLIC', chr(0), o1.owner) table_owner, o1.object_name table_name, decode(o1.owner, 'SYS', decode(o1.object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', o1.object_type), 'SYSTEM', decode(o1.object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', o1.object_type), o1.object_type) table_type, null remarks from all_objects o1 where o1.object_type in ('TABLE', 'VIEW')union select null table_qualifier, decode (o2.owner , 'PUBLIC', chr(0), o2.owner) table_owner, o2.object_name table_name, 'SYNONYM' table_type, null remarks from all_objects o2, all_objects o3, all_synonyms s where o2.object_type = 'SYNONYM' and o3.object_type in ('TABLE', 'VIEW') and o2.owner = s.owner and o2.object_name = s.synonym_name and s.table_owner = o3.owner and s.table_name = o3.object_name) tables where 1=1 and table_owner like 'CDSI2' escape '\' and table_name like 'KB01' escape '\' order by 4, 2, 3
fpqbpgdtsnja5BEGIN pkg_W_comm.prc_w_Query(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15); END;
fqc41dwwy880bSELECT yae115, yae092, yae093 FROM wd04 WHERE yae092 = :1 AND yae093 = :2 AND aae100 = '1'
fzaba7vnxp10sSELECT YAD104, YAA011, YAA012, YAD060 FROM AD04A1 WHERE AAE076 = :B2 AND YAB003 = :B1
gadmm2rr3u5n8select /*+ RESULT_CACHE */aaa100, aaa102, aaa103, aae120 FROM cdsi2.aa10a1 WHERE aaa100 in ('AAC011') order by aaa100, aaa102
gav6pch9hqa72INSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.aab212), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gj2dg4jc2x3fqselect 99 / 100, 1 - to_number(to_char(to_date('1997-11-02', 'yyyy-mm-dd'), 'D')), '00.00.0000 '||banner from v$version where banner like 'Oracle%'
grwydz59pu6mcselect text from view$ where rowid=:1
gt99a8nm62p38INSERT INTO tmp_ad04_m2 (aae076, aae075, aad030, yad104, aad031, aad032, aad033, aae011, aae036, yab003) SELECT ab15a1.aae076, ab15a1.aae076, :1, ad05.yad104, ad05.aad031, ad05.aad032, NVL(SUM(ab15a1.yab159), 0), :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS'), trim(ab15a1.yab003||:4) FROM ab15a1, ad05 WHERE ab15a1.aae076 in (SELECT DISTINCT aae076 FROM tmp_aae076) AND ab15a1.yab003 = :6 AND LOWER(TRIM(ad05.aad050)) = :7 AND ad05.yad104 = :8 AND ad05.yab003 = :9 AND ab15a1.aae140 = ad05.aad053 AND ab15a1.yae316 = ad05.aad055 AND ab15a1.yaa009 = ad05.aad057 AND ad05.aad051 =:10 AND ad05.yad037 = :11 GROUP BY ad05.yad104, ab15a1.aae076, ad05.aad031, ad05.aad032, ab15a1.aae076, ab15a1.yab003
gzk323qfgm4v3SELECT YAD104 YAD104, YAD060 YAD060, SUM(YAA008) YAA008 FROM AD04A1 WHERE AAE076 = :B1 GROUP BY YAD104, YAD060

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 1,811,037 482.24 12.32
CPU used when call started 9,119,591 2,428.36 62.04
CR blocks created 1,150,180 306.27 7.82
Cached Commit SCN referenced 9,862 2.63 0.07
Commit SCN cached 14 0.00 0.00
DB time 135,248,196 36,013.75 920.02
DBWR checkpoint buffers written 1,668,093 444.18 11.35
DBWR checkpoints 22 0.01 0.00
DBWR fusion writes 7,849 2.09 0.05
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 7,601 2.02 0.05
DBWR undo block writes 509,170 135.58 3.46
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 40 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 396,107 105.47 2.69
PX local messages sent 390,464 103.97 2.66
PX remote messages recv'd 235 0.06 0.00
PX remote messages sent 260 0.07 0.00
Parallel operations downgraded 75 to 99 pct 0 0.00 0.00
Parallel operations downgraded to serial 2 0.00 0.00
Parallel operations not downgraded 40 0.01 0.00
RowCR - row contention 735 0.20 0.00
RowCR attempts 409,941 109.16 2.79
RowCR hits 408,940 108.89 2.78
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 1 0.00 0.00
SMON posted for undo segment recovery 1 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 6,822,470 1,816.68 46.41
active txn count during cleanout 3,425,937 912.25 23.30
application wait time 48,467 12.91 0.33
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 5 0.00 0.00
background checkpoints started 6 0.00 0.00
background timeouts 26,773 7.13 0.18
branch node splits 152 0.04 0.00
buffer is not pinned count 400,441,106 106,629.04 2,723.98
buffer is pinned count 4,850,445,260 1,291,571.54 32,994.88
bytes received via SQL*Net from client 665,004,860 177,076.81 4,523.66
bytes sent via SQL*Net to client 1,697,817,441 452,093.07 11,549.31
calls to get snapshot scn: kcmgss 88,675,195 23,612.34 603.21
calls to kcmgas 4,338,145 1,155.16 29.51
calls to kcmgcs 165,523 44.08 1.13
change write time 53,516 14.25 0.36
cleanout - number of ktugct calls 1,348,508 359.08 9.17
cleanouts and rollbacks - consistent read gets 1,011,757 269.41 6.88
cleanouts only - consistent read gets 72,823 19.39 0.50
cluster key scan block gets 19,131,082 5,094.20 130.14
cluster key scans 9,532,066 2,538.19 64.84
cluster wait time 2,811,646 748.68 19.13
commit batch performed 3 0.00 0.00
commit batch requested 3 0.00 0.00
commit batch/immediate performed 880 0.23 0.01
commit batch/immediate requested 880 0.23 0.01
commit cleanout failures: block lost 48,647 12.95 0.33
commit cleanout failures: buffer being written 1 0.00 0.00
commit cleanout failures: callback failure 32,176 8.57 0.22
commit cleanout failures: cannot pin 959 0.26 0.01
commit cleanouts 1,642,992 437.49 11.18
commit cleanouts successfully completed 1,561,209 415.72 10.62
commit immediate performed 877 0.23 0.01
commit immediate requested 877 0.23 0.01
commit txn count during cleanout 308,226 82.07 2.10
concurrency wait time 164,051,219 43,683.39 1,115.95
consistent changes 32,972,948 8,780.00 224.30
consistent gets 1,014,966,636 270,264.26 6,904.25
consistent gets - examination 199,673,011 53,168.72 1,358.26
consistent gets direct 17,567 4.68 0.12
consistent gets from cache 1,014,949,141 270,259.61 6,904.13
current blocks converted for CR 83 0.02 0.00
cursor authentications 9,048 2.41 0.06
data blocks consistent reads - undo records applied 20,374,139 5,425.20 138.59
db block changes 39,953,070 10,638.66 271.78
db block gets 40,855,763 10,879.03 277.92
db block gets direct 4,636 1.23 0.03
db block gets from cache 40,867,188 10,882.07 278.00
deferred (CURRENT) block cleanout applications 455,315 121.24 3.10
dirty buffers inspected 10,689 2.85 0.07
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 96,445 25.68 0.66
enqueue deadlocks 0 0.00 0.00
enqueue releases 2,562,412 682.32 17.43
enqueue requests 2,616,727 696.78 17.80
enqueue timeouts 55,518 14.78 0.38
enqueue waits 333,081 88.69 2.27
exchange deadlocks 403 0.11 0.00
execute count 68,319,724 18,192.11 464.74
failed probes on index block reclamation 9,157 2.44 0.06
frame signature mismatch 0 0.00 0.00
free buffer inspected 9,358,978 2,492.10 63.66
free buffer requested 11,699,788 3,115.41 79.59
gc CPU used by this session 92,731 24.69 0.63
gc blocks lost 0 0.00 0.00
gc claim blocks lost 1 0.00 0.00
gc cr block build time 16,183 4.31 0.11
gc cr block flush time 90,439 24.08 0.62
gc cr block receive time 25,200 6.71 0.17
gc cr block send time 5,732 1.53 0.04
gc cr blocks received 33,961 9.04 0.23
gc cr blocks served 483,198 128.67 3.29
gc current block flush time 165 0.04 0.00
gc current block pin time 16,954 4.51 0.12
gc current block receive time 70,918 18.88 0.48
gc current block send time 16,153 4.30 0.11
gc current blocks received 332,625 88.57 2.26
gc current blocks served 121,963 32.48 0.83
gc local grants 7,749,192 2,063.45 52.71
gc remote grants 605,170 161.14 4.12
gcs messages sent 2,877,996 766.35 19.58
ges messages sent 333,605 88.83 2.27
global enqueue get time 32,000,306 8,521.01 217.68
global enqueue gets async 11,222 2.99 0.08
global enqueue gets sync 1,924,234 512.38 13.09
global enqueue releases 1,911,436 508.98 13.00
global undo segment hints helped 0 0.00 0.00
global undo segment hints were stale 0 0.00 0.00
heap block compress 291,030 77.50 1.98
hot buffers moved to head of LRU 5,335,990 1,420.86 36.30
immediate (CR) block cleanout applications 1,084,581 288.80 7.38
immediate (CURRENT) block cleanout applications 357,868 95.29 2.43
index crx upgrade (found) 11 0.00 0.00
index crx upgrade (positioned) 19,390,091 5,163.17 131.90
index fast full scans (direct read) 0 0.00 0.00
index fast full scans (full) 3,129 0.83 0.02
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 102,426,066 27,273.91 696.75
index scans kdiixs1 115,502,820 30,755.97 785.70
leaf node 90-10 splits 1,875 0.50 0.01
leaf node splits 34,757 9.26 0.24
lob reads 165,429 44.05 1.13
lob writes 226,195 60.23 1.54
lob writes unaligned 225,985 60.18 1.54
local undo segment hints helped 0 0.00 0.00
local undo segment hints were stale 0 0.00 0.00
logons cumulative 41,702 11.10 0.28
messages received 1,193,327 317.76 8.12
messages sent 1,193,179 317.72 8.12
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 780,904,934 207,938.56 5,312.06
opened cursors cumulative 1,279,726 340.76 8.71
parse count (failures) 98,428 26.21 0.67
parse count (hard) 122,239 32.55 0.83
parse count (total) 2,348,774 625.43 15.98
parse time cpu 664,010 176.81 4.52
parse time elapsed 19,094,851 5,084.56 129.89
physical read IO requests 4,653,934 1,239.24 31.66
physical read bytes 67,782,549,504 18,049,067.09 461,086.96
physical read total IO requests 4,756,841 1,266.65 32.36
physical read total bytes 85,330,504,192 22,721,718.30 580,455.93
physical read total multi block requests 280,992 74.82 1.91
physical reads 8,274,231 2,203.25 56.28
physical reads cache 8,089,317 2,154.01 55.03
physical reads cache prefetch 3,625,997 965.53 24.67
physical reads direct 184,806 49.21 1.26
physical reads direct (lob) 17,366 4.62 0.12
physical reads direct temporary tablespace 162,991 43.40 1.11
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 1,249,955 332.84 8.50
physical write bytes 26,165,346,304 6,967,281.32 177,988.29
physical write total IO requests 1,683,182 448.20 11.45
physical write total bytes 46,324,465,664 12,335,230.75 315,119.56
physical write total multi block requests 493,158 131.32 3.35
physical writes 3,194,012 850.50 21.73
physical writes direct 1,342,009 357.35 9.13
physical writes direct (lob) 3,647 0.97 0.02
physical writes direct temporary tablespace 1,336,428 355.86 9.09
physical writes from cache 1,852,003 493.15 12.60
physical writes non checkpoint 2,849,693 758.81 19.38
pinned buffers inspected 325 0.09 0.00
prefetch clients - default 3 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 130 0.03 0.00
process last non-idle time 3,860 1.03 0.03
queries parallelized 33 0.01 0.00
recovery blocks read 175,383 46.70 1.19
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 76,792,962 20,448.35 522.38
recursive cpu usage 726,413 193.43 4.94
redo blocks read for recovery 3,177,270 846.04 21.61
redo blocks written 11,455,059 3,050.24 77.92
redo buffer allocation retries 137,303 36.56 0.93
redo entries 21,170,115 5,637.16 144.01
redo log space requests 341,176 90.85 2.32
redo log space wait time 23,354,599 6,218.84 158.87
redo ordering marks 324,131 86.31 2.20
redo size 5,629,197,648 1,498,936.92 38,292.30
redo subscn max counts 59,280 15.79 0.40
redo synch time 1,330,227 354.21 9.05
redo synch writes 69,681 18.55 0.47
redo wastage 38,901,888 10,358.75 264.63
redo write time 5,866 1.56 0.04
redo writer latching time 1,149 0.31 0.01
redo writes 88,389 23.54 0.60
rollback changes - undo records applied 1,252,479 333.51 8.52
rollbacks only - consistent read gets 124,174 33.06 0.84
rows fetched via callback 35,953,491 9,573.66 244.57
session connect time 5,786,320 1,540.78 39.36
session cursor cache hits 1,514,487 403.28 10.30
session logical reads 1,055,821,459 281,143.04 7,182.17
session uga memory ############### 51,927,188.09 1,326,547.74
session uga memory max 27,710,686,216 7,378,772.83 188,500.38
shared hash latch upgrades - no wait 25,916,833 6,901.11 176.30
shared hash latch upgrades - wait 274 0.07 0.00
sorts (disk) 3 0.00 0.00
sorts (memory) 5,091,873 1,355.86 34.64
sorts (rows) 317,632,904 84,578.96 2,160.68
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 25,155 6.70 0.17
sql area purged 20,291 5.40 0.14
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 118,432 31.54 0.81
switch current to new buffer 1,519,120 404.51 10.33
table fetch by rowid 2,499,560,503 665,580.38 17,003.12
table fetch continued row 13,295,759 3,540.38 90.44
table scan blocks gotten 338,913,419 90,245.51 2,305.44
table scan rows gotten 15,435,688,574 4,110,199.17 105,000.40
table scans (cache partitions) 2 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 12 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 8,569,999 2,282.01 58.30
total number of times SMON posted 54,949 14.63 0.37
transaction lock background get time 0 0.00 0.00
transaction lock background gets 778 0.21 0.01
transaction lock foreground requests 778 0.21 0.01
transaction lock foreground wait time 1,331 0.35 0.01
transaction rollbacks 1,071 0.29 0.01
transaction tables consistent read rollbacks 47 0.01 0.00
transaction tables consistent reads - undo records applied 10,183 2.71 0.07
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 2,925,221,044 778,924.83 19,898.65
user I/O wait time 2,308,113 614.60 15.70
user calls 7,065,432 1,881.38 48.06
user commits 70,623 18.81 0.48
user rollbacks 76,383 20.34 0.52
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 3 0.00 0.00
workarea executions - optimal 4,421,424 1,177.33 30.08
write clones created in background 323 0.09 0.00
write clones created in foreground 169 0.05 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 605,224,788 605,501,323
opened cursors current 108,947 29,181
workarea memory allocated 12,252,426 13,602,429
logons current 1,345 1,695

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 6 5.75

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 4,195,788 1,117 213.47 1.79 1,002,176 267 1,136,146 856.59
JYDATA 174,170 46 22.77 1.70 10,142 3 1,633 940.01
NNC_DATA01 109,399 29 0.64 1.01 701 0 1,171 3.04
SHORDATA 30,456 8 4.82 1.12 72,657 19 276 424.28
UNDOTBS2 32,946 9 11657.40 1.00 29,834 8 11 991.82
TEMP 9,560 3 14.06 18.37 51,578 14 0 0.00
UNDOTBS1 3,952 1 4.78 1.00 47,055 13 6,165 484.34
JYINDEX 32,231 9 208.91 1.08 17,804 5 26 150.00
DATA_A 9,024 2 3738.86 1.00 8,628 2 0 0.00
IUFO 13,015 3 0.26 1.00 6 0 298 1.95
NNC_INDEX01 2,430 1 5.92 1.00 1,525 0 0 0.00
SYSAUX 1,517 0 142.74 1.01 1,685 0 0 0.00
SYSTEM 2,561 1 32.58 1.40 506 0 19 12.11
TEMPDATA 2,094 1 1.51 1.00 76 0 37 4.86
DATA_CW_INDEX01 1,137 0 7.04 1.00 596 0 30 4.67
NNC_INDEX03 1,133 0 3.86 1.00 271 0 0 0.00
LDGGSJ 840 0 7.31 1.00 15 0 0 0.00
CDLDZC 377 0 4.08 4.76 254 0 617 999.85
NNC_DATA03 512 0 5.80 1.00 45 0 0 0.00
USERS 502 0 0.36 1.01 2 0 0 0.00
NNC_DATA02 242 0 6.45 2.86 3 0 0 0.00
LDJG 78 0 8.72 1.45 92 0 0 0.00
JYLOBDATA 125 0 608.32 1.00 25 0 2 0.00
JYSHORTDATA 82 0 3.05 1.00 53 0 0 0.00
NNC_INDEX02 114 0 6.67 1.00 2 0 0 0.00
GGFW 89 0 0.67 1.00 4 0 2 0.00
GDZC 32 0 7.81 1.00 21 0 0 0.00
JYTEMP 29 0 2.41 1.00 17 0 0 0.00
DANGAN 20 0 1.00 1.00 4 0 0 0.00
XNH_DATA 13 0 17.69 1.00 4 0 0 0.00
SYBX_DATA 10 0 7.00 1.00 4 0 0 0.00
LDYL 3 0 20.00 1.00 1 0 0 0.00
PENSION_DATA 3 0 20.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 377 0 4.08 4.76 254 0 617 999.85
DANGAN /dev/rcdld_dangan01 10 0 1.00 1.00 2 0 0 0.00
DANGAN /dev/rcdld_dangan02 10 0 1.00 1.00 2 0 0 0.00
DATA /dev/rcdld_data01 11,644 3 107.81 2.18 2,125 1 761 3.94
DATA /dev/rcdld_data02 22,536 6 68.95 1.94 1,919 1 51,220 997.05
DATA /dev/rcdld_data03 13,171 4 300.89 2.14 2,386 1 1,248 793.01
DATA /dev/rcdld_data04 17,038 5 204.48 1.98 2,674 1 257 5.25
DATA /dev/rcdld_data05 11,869 3 177.06 2.40 1,807 0 74 2.30
DATA /dev/rcdld_data06 19,449 5 119.15 1.92 2,181 1 764 826.43
DATA /dev/rcdld_data07 15,449 4 314.48 2.63 2,463 1 74,170 985.40
DATA /dev/rcdld_data08 18,585 5 78.58 1.53 2,250 1 113 3.98
DATA /dev/rcdld_data09 22,076 6 121.95 1.49 2,479 1 87 1.84
DATA /dev/rcdld_data10 14,463 4 271.33 3.19 3,485 1 796 5.01
DATA /dev/rcdld_data100 7,244 2 381.21 2.63 2,292 1 1,236 524.94
DATA /dev/rcdld_data101 6,851 2 245.44 1.32 2,560 1 93 19.25
DATA /dev/rcdld_data102 9,173 2 211.14 2.06 2,357 1 153 4.77
DATA /dev/rcdld_data103 7,842 2 205.58 2.21 2,805 1 173 72.20
DATA /dev/rcdld_data104 6,130 2 220.23 1.33 2,349 1 58 5.86
DATA /dev/rcdld_data105 7,674 2 212.24 2.18 2,316 1 131 3.28
DATA /dev/rcdld_data106 7,059 2 197.95 2.26 2,370 1 233 3.99
DATA /dev/rcdld_data107 6,661 2 245.77 1.18 2,170 1 257 4.36
DATA /dev/rcdld_data108 6,901 2 264.25 2.29 2,194 1 406 4.06
DATA /dev/rcdld_data109 8,056 2 205.75 3.03 2,144 1 315 72.92
DATA /dev/rcdld_data11 12,600 3 162.60 4.84 2,490 1 899 974.00
DATA /dev/rcdld_data110 7,721 2 159.15 3.10 1,916 1 225 4.40
DATA /dev/rcdld_data111 7,664 2 285.22 2.14 2,254 1 305 3.64
DATA /dev/rcdld_data112 6,283 2 347.44 2.37 1,935 1 167 4.37
DATA /dev/rcdld_data113 7,389 2 380.54 2.22 2,132 1 601 3.16
DATA /dev/rcdld_data114 6,213 2 455.62 2.37 2,208 1 174 4.25
DATA /dev/rcdld_data115 7,196 2 208.41 2.81 1,970 1 78 7.31
DATA /dev/rcdld_data116 7,329 2 371.24 2.35 2,392 1 140 3.86
DATA /dev/rcdld_data117 7,786 2 334.09 2.55 2,480 1 265 3.96
DATA /dev/rcdld_data118 7,319 2 329.40 2.29 2,173 1 207 4.06
DATA /dev/rcdld_data119 6,962 2 354.76 1.25 2,488 1 195 4.21
DATA /dev/rcdld_data12 22,135 6 117.89 2.36 2,524 1 79,693 996.67
DATA /dev/rcdld_data120 8,492 2 737.97 1.27 2,791 1 214 2.52
DATA /dev/rcdld_data121 9,766 3 530.91 1.98 2,721 1 98 3.47
DATA /dev/rcdld_data122 9,482 3 457.52 2.01 2,944 1 176 3.41
DATA /dev/rcdld_data123 12,229 3 345.18 1.80 3,060 1 195 3.44
DATA /dev/rcdld_data124 10,792 3 484.77 2.55 2,969 1 122 3.93
DATA /dev/rcdld_data125 12,888 3 319.63 1.72 2,674 1 372 23.23
DATA /dev/rcdld_data126 14,776 4 632.37 1.64 3,563 1 317 3.97
DATA /dev/rcdld_data127 12,759 3 757.27 1.75 3,550 1 325 4.00
DATA /dev/rcdld_data128 12,446 3 433.72 1.83 2,652 1 266 2.52
DATA /dev/rcdld_data129 12,783 3 274.49 1.27 3,007 1 225 3.29
DATA /dev/rcdld_data13 18,414 5 140.40 2.46 2,235 1 345 2.75
DATA /dev/rcdld_data130 11,668 3 237.67 1.22 3,292 1 227 3.22
DATA /dev/rcdld_data131 12,312 3 191.29 1.71 2,563 1 312 2.34
DATA /dev/rcdld_data132 14,202 4 338.65 1.49 2,978 1 483 2.26
DATA /dev/rcdld_data133 13,359 4 242.52 1.71 2,380 1 336 2.71
DATA /dev/rcdld_data134 13,896 4 292.86 1.63 3,064 1 582 3.20
DATA /dev/rcdld_data135 14,673 4 222.79 1.58 2,874 1 550 3.56
DATA /dev/rcdld_data136 14,846 4 104.75 2.72 2,257 1 649 2.56
DATA /dev/rcdld_data137 14,591 4 270.52 2.08 2,913 1 472 2.18
DATA /dev/rcdld_data138 14,046 4 259.58 1.57 3,155 1 725 2.50
DATA /dev/rcdld_data139 14,556 4 99.74 1.56 2,617 1 896 2.52
DATA /dev/rcdld_data14 22,154 6 151.30 2.78 2,729 1 653 3.08
DATA /dev/rcdld_data140 14,938 4 111.01 1.52 2,841 1 494 3.42
DATA /dev/rcdld_data141 17,949 5 36.15 1.73 1,128 0 799 8.24
DATA /dev/rcdld_data142 19,576 5 36.20 1.66 2,078 1 578 95.26
DATA /dev/rcdld_data143 20,216 5 36.44 1.82 1,133 0 549 3.83
DATA /dev/rcdld_data144 14,593 4 64.05 1.69 2,266 1 459 4.10
DATA /dev/rcdld_data145 13,035 3 118.96 1.55 2,616 1 685 3.12
DATA /dev/rcdld_data146 16,945 5 178.25 1.56 3,083 1 1,016 4.11
DATA /dev/rcdld_data147 18,126 5 66.48 1.91 2,649 1 779 9.60
DATA /dev/rcdld_data148 19,724 5 44.22 2.09 2,222 1 884 3.65
DATA /dev/rcdld_data149 17,353 5 46.66 1.94 2,286 1 725 3.31
DATA /dev/rcdld_data15 21,947 6 116.87 2.42 2,347 1 284 4.61
DATA /dev/rcdld_data150 18,755 5 80.61 1.36 2,396 1 587 3.44
DATA /dev/rcdld_data151 14,728 4 57.92 1.45 2,358 1 564 3.46
DATA /dev/rcdld_data152 15,559 4 88.04 1.42 2,631 1 632 3.23
DATA /dev/rcdld_data153 9,770 3 152.32 3.63 2,749 1 263 2.97
DATA /dev/rcdld_data154 11,354 3 110.28 1.27 2,203 1 611 3.29
DATA /dev/rcdld_data155 10,151 3 98.32 2.53 2,380 1 515 3.22
DATA /dev/rcdld_data156 8,125 2 141.07 1.30 1,946 1 668 2.46
DATA /dev/rcdld_data157 11,231 3 86.64 1.11 2,071 1 312 3.97
DATA /dev/rcdld_data158 5,514 1 214.91 1.21 1,152 0 217 3.18
DATA /dev/rcdld_data159 6,738 2 110.93 2.24 939 0 303 3.17
DATA /dev/rcdld_data16 14,646 4 210.16 3.40 2,619 1 49 5.51
DATA /dev/rcdld_data160 8,609 2 114.62 1.99 1,200 0 313 3.39
DATA /dev/rcdld_data161 10,594 3 102.15 3.37 1,843 0 366 3.06
DATA /dev/rcdld_data162 7,258 2 144.28 2.36 1,562 0 853 3.63
DATA /dev/rcdld_data163 9,501 3 46.80 1.42 1,093 0 543 2.80
DATA /dev/rcdld_data164 9,906 3 55.13 2.71 1,018 0 854 2.88
DATA /dev/rcdld_data165 6,987 2 60.37 1.26 1,088 0 622 2.68
DATA /dev/rcdld_data166 15,209 4 32.44 2.09 1,014 0 529 2.78
DATA /dev/rcdld_data167 10,184 3 41.55 1.18 991 0 655 2.55
DATA /dev/rcdld_data168 8,019 2 48.54 1.23 827 0 417 3.45
DATA /dev/rcdld_data169 15,259 4 193.08 1.78 4,698 1 1,206 2.65
DATA /dev/rcdld_data17 10,677 3 192.88 2.33 2,021 1 586 5.46
DATA /dev/rcdld_data170 14,228 4 133.86 2.45 3,727 1 1,795 3.28
DATA /dev/rcdld_data171 14,692 4 135.87 2.86 5,095 1 210 12.38
DATA /dev/rcdld_data172 14,534 4 133.75 2.47 4,983 1 252 4.48
DATA /dev/rcdld_data173 13,477 4 204.53 1.74 5,399 1 866 4.47
DATA /dev/rcdld_data174 12,361 3 412.22 1.77 4,517 1 977 3.97
DATA /dev/rcdld_data175 12,135 3 223.21 2.41 4,371 1 282 4.72
DATA /dev/rcdld_data176 12,411 3 151.70 1.76 4,065 1 551 4.07
DATA /dev/rcdld_data177 13,133 3 302.62 1.70 4,488 1 903 5.33
DATA /dev/rcdld_data178 12,641 3 322.66 1.75 4,197 1 505 25.84
DATA /dev/rcdld_data179 11,205 3 182.24 1.75 3,304 1 394 5.23
DATA /dev/rcdld_data18 13,607 4 121.44 1.92 2,217 1 172 65.35
DATA /dev/rcdld_data180 13,970 4 222.58 1.65 3,096 1 290 3.00
DATA /dev/rcdld_data181 12,396 3 326.51 1.22 3,613 1 503 2.03
DATA /dev/rcdld_data182 12,916 3 131.96 1.63 2,860 1 507 3.63
DATA /dev/rcdld_data183 11,271 3 208.48 1.80 3,586 1 322 4.44
DATA /dev/rcdld_data184 8,884 2 232.64 1.86 3,050 1 189 3.44
DATA /dev/rcdld_data185 13,473 4 268.53 2.12 4,135 1 1,025 3.73
DATA /dev/rcdld_data186 13,118 3 156.88 1.64 3,143 1 268 3.88
DATA /dev/rcdld_data187 9,227 2 270.42 1.99 3,298 1 1,000 3.13
DATA /dev/rcdld_data188 9,777 3 235.41 1.95 3,447 1 707 3.22
DATA /dev/rcdld_data189 10,645 3 312.52 1.86 4,106 1 441 4.51
DATA /dev/rcdld_data19 22,792 6 189.15 1.51 2,261 1 106 3.49
DATA /dev/rcdld_data190 12,897 3 111.37 2.12 3,635 1 627 3.41
DATA /dev/rcdld_data191 9,699 3 191.73 1.85 3,037 1 46,524 978.12
DATA /dev/rcdld_data192 11,312 3 195.64 1.80 3,506 1 136,135 994.48
DATA /dev/rcdld_data193 9,877 3 220.69 1.81 3,706 1 81,822 994.89
DATA /dev/rcdld_data194 10,483 3 167.48 1.77 4,452 1 404 3.71
DATA /dev/rcdld_data195 20,350 5 110.96 1.65 5,222 1 728 3.59
DATA /dev/rcdld_data196 13,097 3 352.91 1.64 4,464 1 1,373 2.81
DATA /dev/rcdld_data197 11,036 3 152.37 1.14 4,239 1 307 2.90
DATA /dev/rcdld_data198 15,048 4 92.68 1.47 4,576 1 1,373 2.81
DATA /dev/rcdld_data199 16,338 4 92.37 1.83 4,794 1 541 3.38
DATA /dev/rcdld_data20 12,438 3 313.08 1.84 2,222 1 340 2.76
DATA /dev/rcdld_data200 13,570 4 107.75 1.68 4,639 1 683 207.12
DATA /dev/rcdld_data201 14,751 4 106.77 1.56 4,531 1 147 2.99
DATA /dev/rcdld_data202 15,874 4 83.32 1.51 5,374 1 1,137 2.33
DATA /dev/rcdld_data203 23,621 6 60.65 1.34 5,934 2 1,047 4.06
DATA /dev/rcdld_data204 17,703 5 59.00 1.40 5,595 1 600 324.57
DATA /dev/rcdld_data205 18,259 5 49.59 1.45 2,976 1 346 3.76
DATA /dev/rcdld_data206 20,090 5 73.96 1.03 3,345 1 607 3.56
DATA /dev/rcdld_data207 19,877 5 79.05 1.03 4,021 1 751 3.28
DATA /dev/rcdld_data208 14,944 4 151.10 1.66 3,652 1 323 195.76
DATA /dev/rcdld_data209 17,481 5 159.76 1.50 4,084 1 756 3.65
DATA /dev/rcdld_data21 11,651 3 265.94 2.65 2,226 1 422 3.06
DATA /dev/rcdld_data210 12,979 3 183.18 1.09 4,028 1 921 22.17
DATA /dev/rcdld_data211 12,244 3 214.96 1.07 4,506 1 101 3.56
DATA /dev/rcdld_data212 12,684 3 52.06 1.10 4,512 1 1,128 3.33
DATA /dev/rcdld_data213 11,422 3 85.90 1.02 3,045 1 906 3.89
DATA /dev/rcdld_data214 12,702 3 77.10 1.42 3,660 1 13 1.54
DATA /dev/rcdld_data215 11,109 3 76.06 1.00 2,836 1 330 4.12
DATA /dev/rcdld_data216 10,872 3 99.23 1.12 3,009 1 42 4.29
DATA /dev/rcdld_data217 10,937 3 68.45 1.01 3,621 1 1,097 0.58
DATA /dev/rcdld_data218 9,278 2 156.97 1.02 2,769 1 117 4.02
DATA /dev/rcdld_data219 12,804 3 140.19 1.71 3,092 1 576 3.39
DATA /dev/rcdld_data22 15,896 4 294.67 3.03 2,270 1 3,311 2.31
DATA /dev/rcdld_data220 10,004 3 156.56 1.16 3,123 1 505 5.56
DATA /dev/rcdld_data221 8,928 2 274.08 1.27 2,888 1 245 4.73
DATA /dev/rcdld_data222 8,874 2 104.64 1.94 3,120 1 431 4.78
DATA /dev/rcdld_data223 8,846 2 137.27 1.17 3,115 1 1,320 4.23
DATA /dev/rcdld_data224 10,138 3 195.69 1.07 3,237 1 26 3.85
DATA /dev/rcdld_data225 11,199 3 116.73 1.07 3,211 1 733 2.40
DATA /dev/rcdld_data226 9,527 3 105.54 1.09 2,766 1 175 2.06
DATA /dev/rcdld_data227 12,214 3 103.32 1.06 3,676 1 106 4.72
DATA /dev/rcdld_data228 10,341 3 139.16 1.71 2,536 1 98 2.65
DATA /dev/rcdld_data229 13,126 3 189.21 1.62 3,888 1 1,507 3.16
DATA /dev/rcdld_data23 14,224 4 169.07 2.72 2,175 1 928 4.05
DATA /dev/rcdld_data230 14,069 4 152.35 1.11 4,497 1 322 4.53
DATA /dev/rcdld_data231 13,887 4 105.46 1.04 5,854 2 729 3.85
DATA /dev/rcdld_data232 14,607 4 142.06 1.56 5,475 1 702 4.19
DATA /dev/rcdld_data233 11,115 3 113.92 1.04 2,710 1 629 20.11
DATA /dev/rcdld_data234 12,391 3 86.89 1.03 4,284 1 248 4.07
DATA /dev/rcdld_data235 9,378 2 113.43 1.03 2,440 1 170 4.35
DATA /dev/rcdld_data236 13,336 4 79.73 1.03 2,680 1 1,514 1.17
DATA /dev/rcdld_data237 10,860 3 102.48 1.02 3,711 1 2,457 0.32
DATA /dev/rcdld_data238 9,278 2 100.57 1.05 2,728 1 658 0.68
DATA /dev/rcdld_data239 15,889 4 64.86 1.15 7,834 2 3,465 1.75
DATA /dev/rcdld_data24 16,210 4 142.47 2.55 2,337 1 129,175 986.27
DATA /dev/rcdld_data240 22,821 6 37.28 1.62 10,101 3 570 184.16
DATA /dev/rcdld_data241 17,996 5 63.16 1.07 6,254 2 198 3.89
DATA /dev/rcdld_data242 18,409 5 44.70 1.20 10,304 3 1,291 4.24
DATA /dev/rcdld_data243 23,940 6 46.49 1.35 12,951 3 1,210 3.91
DATA /dev/rcdld_data244 19,397 5 59.53 1.07 3,484 1 592 4.22
DATA /dev/rcdld_data245 23,224 6 41.08 1.08 9,565 3 1,667 22.91
DATA /dev/rcdld_data246 20,747 6 44.09 1.21 5,962 2 1,896 3.47
DATA /dev/rcdld_data247 18,571 5 41.01 1.09 4,985 1 1,757 3.85
DATA /dev/rcdld_data248 16,099 4 48.69 1.07 3,710 1 1,508 3.90
DATA /dev/rcdld_data249 21,082 6 32.15 1.10 1,897 1 29 3.10
DATA /dev/rcdld_data25 17,889 5 429.69 1.41 2,671 1 1,207 1.76
DATA /dev/rcdld_data250 16,863 4 31.41 1.05 5,050 1 1,883 3.87
DATA /dev/rcdld_data251 17,879 5 46.52 1.10 2,872 1 143 2.80
DATA /dev/rcdld_data252 15,679 4 103.68 1.12 4,160 1 2,123 4.39
DATA /dev/rcdld_data253 17,785 5 50.28 1.84 5,965 2 2,599 4.42
DATA /dev/rcdld_data254 15,881 4 98.97 1.16 5,353 1 2,679 66.39
DATA /dev/rcdld_data255 13,852 4 145.26 1.14 3,461 1 166 75.30
DATA /dev/rcdld_data256 16,455 4 53.76 1.16 6,261 2 880 29.90
DATA /dev/rcdld_data257 13,512 4 67.48 1.13 5,432 1 2,461 67.31
DATA /dev/rcdld_data258 13,633 4 47.89 1.24 2,735 1 726 215.88
DATA /dev/rcdld_data259 17,162 5 31.90 1.55 3,293 1 426 4.13
DATA /dev/rcdld_data26 13,610 4 216.19 1.91 2,508 1 1,055 633.40
DATA /dev/rcdld_data260 25,214 7 36.53 1.10 5,048 1 21 5.24
DATA /dev/rcdld_data261 29,622 8 20.00 1.11 5,957 2 1,853 9.53
DATA /dev/rcdld_data262 27,692 7 38.72 1.03 4,095 1 1,783 4.60
DATA /dev/rcdld_data263 29,759 8 40.39 1.78 3,197 1 1,426 5.14
DATA /dev/rcdld_data264 30,078 8 47.47 1.81 2,879 1 481 4.93
DATA /dev/rcdld_data265 25,514 7 48.65 1.88 2,247 1 210 5.10
DATA /dev/rcdld_data266 28,074 7 44.93 1.77 2,061 1 520 4.33
DATA /dev/rcdld_data267 28,888 8 49.60 1.70 3,015 1 614 4.46
DATA /dev/rcdld_data268 38,524 10 38.74 1.55 2,448 1 650 4.28
DATA /dev/rcdld_data269 34,969 9 27.21 1.60 3,942 1 996 6.00
DATA /dev/rcdld_data27 14,084 4 1021.81 1.95 3,374 1 87,216 998.21
DATA /dev/rcdld_data270 33,714 9 48.09 1.52 3,265 1 101 5.35
DATA /dev/rcdld_data271 35,927 10 35.97 1.37 1,683 0 658 4.22
DATA /dev/rcdld_data272 30,369 8 27.28 1.45 2,117 1 624 6.25
DATA /dev/rcdld_data273 65,656 17 222.28 1.24 39,616 11 648 6.14
DATA /dev/rcdld_data274 53,501 14 331.37 1.29 30,330 8 998 4.65
DATA /dev/rcdld_data275 45,669 12 348.74 1.22 30,759 8 436 3.60
DATA /dev/rcdld_data276 35,438 9 344.56 1.03 24,896 7 388 4.90
DATA /dev/rcdld_data277 32,274 9 338.72 1.00 18,062 5 54 3.52
DATA /dev/rcdld_data278 36,006 10 144.49 1.00 16,840 4 69 340.00
DATA /dev/rcdld_data279 28,429 8 74.28 1.00 13,959 4 34 2.65
DATA /dev/rcdld_data28 15,088 4 860.69 1.30 3,373 1 200 6.15
DATA /dev/rcdld_data280 21,500 6 640.34 1.00 13,803 4 60 7.83
DATA /dev/rcdld_data281 14,183 4 3089.06 1.01 8,565 2 97 27.22
DATA /dev/rcdld_data282 9,935 3 6088.04 1.01 5,322 1 74 2.03
DATA /dev/rcdld_data29 17,467 5 751.38 1.31 3,594 1 133 7.14
DATA /dev/rcdld_data30 12,755 3 270.83 1.38 1,965 1 116 6.38
DATA /dev/rcdld_data31 10,931 3 310.89 1.51 2,151 1 42 5.71
DATA /dev/rcdld_data32 23,310 6 3640.58 1.14 9,662 3 30 4.67
DATA /dev/rcdld_data33 12,408 3 304.62 1.23 2,601 1 148 12.30
DATA /dev/rcdld_data34 12,040 3 693.55 1.39 2,833 1 310 4.68
DATA /dev/rcdld_data35 11,271 3 421.95 1.23 2,092 1 436 5.69
DATA /dev/rcdld_data36 10,854 3 267.48 1.39 2,068 1 91 4.95
DATA /dev/rcdld_data37 11,717 3 312.58 1.66 2,335 1 101 4.85
DATA /dev/rcdld_data38 9,617 3 377.37 1.44 2,116 1 157 5.92
DATA /dev/rcdld_data39 9,558 3 306.81 1.31 1,913 1 807 778.69
DATA /dev/rcdld_data40 11,189 3 288.27 1.26 1,918 1 232 210.30
DATA /dev/rcdld_data41 9,192 2 328.26 1.30 1,881 1 32 9.69
DATA /dev/rcdld_data42 12,891 3 222.01 2.62 1,991 1 62 21.13
DATA /dev/rcdld_data43 13,148 4 198.98 1.72 1,921 1 315 148.29
DATA /dev/rcdld_data44 14,676 4 164.69 1.24 1,903 1 840 6.90
DATA /dev/rcdld_data45 12,502 3 202.56 1.33 2,120 1 44 7.50
DATA /dev/rcdld_data46 14,671 4 190.97 1.15 2,315 1 255 14.51
DATA /dev/rcdld_data47 11,426 3 258.47 1.20 2,242 1 159 3.21
DATA /dev/rcdld_data48 11,010 3 230.91 1.24 1,884 1 253 6.48
DATA /dev/rcdld_data49 11,380 3 232.10 1.23 2,247 1 98 4.59
DATA /dev/rcdld_data50 22,100 6 164.86 1.44 2,291 1 259 3.98
DATA /dev/rcdld_data51 18,339 5 109.56 2.08 1,682 0 92 3.59
DATA /dev/rcdld_data52 16,649 4 173.45 2.41 2,297 1 19 5.26
DATA /dev/rcdld_data53 18,144 5 210.44 2.10 2,385 1 266 5.53
DATA /dev/rcdld_data54 22,175 6 205.43 1.58 2,432 1 236 13.52
DATA /dev/rcdld_data55 23,053 6 128.77 2.60 2,162 1 6,697 1.17
DATA /dev/rcdld_data56 17,923 5 205.97 2.11 2,236 1 6,248 1.80
DATA /dev/rcdld_data57 10,321 3 231.32 1.38 2,346 1 298 5.13
DATA /dev/rcdld_data58 13,762 4 341.32 2.84 1,925 1 170 7.82
DATA /dev/rcdld_data59 11,149 3 179.01 2.10 1,489 0 209 1.58
DATA /dev/rcdld_data60 13,127 3 173.84 2.38 1,317 0 437 2.43
DATA /dev/rcdld_data61 11,880 3 161.34 2.79 1,502 0 98 6.02
DATA /dev/rcdld_data62 12,376 3 157.50 2.92 2,028 1 30 5.67
DATA /dev/rcdld_data63 17,395 5 112.26 1.70 1,647 0 282 9.15
DATA /dev/rcdld_data64 11,854 3 212.76 3.14 1,782 0 314 8.38
DATA /dev/rcdld_data65 10,949 3 210.80 1.81 1,825 0 146 7.88
DATA /dev/rcdld_data66 19,954 5 79.76 2.23 1,690 0 602 26.15
DATA /dev/rcdld_data67 16,803 4 134.06 2.88 1,372 0 541 13.51
DATA /dev/rcdld_data68 16,165 4 199.90 2.06 1,604 0 1,348 11.11
DATA /dev/rcdld_data69 18,104 5 111.68 1.97 1,595 0 792 14.87
DATA /dev/rcdld_data70 16,761 4 138.05 1.17 1,392 0 899 4.29
DATA /dev/rcdld_data71 18,308 5 139.07 1.64 1,421 0 221 41.99
DATA /dev/rcdld_data72 18,777 5 91.17 1.77 1,335 0 782 13.26
DATA /dev/rcdld_data73 15,191 4 98.48 2.24 1,523 0 374 20.75
DATA /dev/rcdld_data74 16,237 4 86.15 2.61 1,721 0 226 24.69
DATA /dev/rcdld_data75 13,208 4 107.24 3.86 1,387 0 883 714.11
DATA /dev/rcdld_data76 11,319 3 119.13 4.43 1,207 0 602 357.48
DATA /dev/rcdld_data77 13,532 4 112.27 2.99 1,219 0 581 14.20
DATA /dev/rcdld_data78 13,441 4 99.64 2.44 1,440 0 276 36.96
DATA /dev/rcdld_data79 14,863 4 76.37 2.79 1,137 0 407 21.89
DATA /dev/rcdld_data80 13,581 4 79.36 2.75 1,510 0 745 99.72
DATA /dev/rcdld_data81 14,055 4 84.24 3.47 1,650 0 185,320 997.83
DATA /dev/rcdld_data82 13,770 4 75.74 3.33 1,341 0 88,283 992.19
DATA /dev/rcdld_data83 12,477 3 80.90 3.72 1,540 0 469 22.22
DATA /dev/rcdld_data84 16,924 5 67.76 2.90 1,781 0 625 15.52
DATA /dev/rcdld_data85 10,837 3 115.16 4.46 1,728 0 385 27.17
DATA /dev/rcdld_data86 10,709 3 105.60 4.49 1,411 0 379 27.65
DATA /dev/rcdld_data87 10,635 3 100.05 3.02 1,683 0 399 12.58
DATA /dev/rcdld_data88 7,867 2 203.10 2.51 1,327 0 2,599 893.37
DATA /dev/rcdld_data90 9,198 2 96.46 4.28 1,710 0 1,765 661.76
DATA /dev/rcdld_data91 9,714 3 137.58 5.42 1,783 0 1,418 699.06
DATA /dev/rcdld_data92 9,976 3 104.68 4.89 2,125 1 277 14.44
DATA /dev/rcdld_data93 10,379 3 149.43 4.67 2,203 1 1,036 793.67
DATA /dev/rcdld_data94 8,576 2 168.99 5.44 1,963 1 2,205 842.85
DATA /dev/rcdld_data95 10,333 3 180.06 3.08 2,138 1 433 9.77
DATA /dev/rcdld_data96 10,947 3 173.70 3.89 2,200 1 240 25.04
DATA /dev/rcdld_data97 9,565 3 259.79 3.61 2,532 1 888 828.43
DATA /dev/rcdld_data98 13,533 4 290.60 2.67 2,570 1 2,620 968.11
DATA /dev/rcdld_data99 12,816 3 113.57 2.51 2,468 1 2,893 887.25
DATA_A /dev/rcdld_data_a01 757 0 4125.61 1.00 739 0 0 0.00
DATA_A /dev/rcdld_data_a02 538 0 3959.11 1.00 517 0 0 0.00
DATA_A /dev/rcdld_data_a03 444 0 4027.32 1.00 424 0 0 0.00
DATA_A /dev/rcdld_data_a04 504 0 3952.56 1.00 489 0 0 0.00
DATA_A /dev/rcdld_data_a05 334 0 3851.68 1.00 316 0 0 0.00
DATA_A /dev/rcdld_data_a06 336 0 3855.36 1.00 323 0 0 0.00
DATA_A /dev/rcdld_data_a07 639 0 3835.93 1.00 624 0 0 0.00
DATA_A /dev/rcdld_data_a08 797 0 3812.75 1.00 758 0 0 0.00
DATA_A /dev/rcdld_data_a09 354 0 3651.86 1.00 335 0 0 0.00
DATA_A /dev/rcdld_data_a10 412 0 3680.95 1.00 401 0 0 0.00
DATA_A /dev/rcdld_data_a11 484 0 3673.95 1.00 468 0 0 0.00
DATA_A /dev/rcdld_data_a12 374 0 3601.15 1.00 361 0 0 0.00
DATA_A /dev/rcdld_data_a13 316 0 3569.81 1.00 302 0 0 0.00
DATA_A /dev/rcdld_data_a14 633 0 3568.82 1.00 591 0 0 0.00
DATA_A /dev/rcdld_data_a15 492 0 3462.56 1.00 438 0 0 0.00
DATA_A /dev/rcdld_data_a16 263 0 3428.90 1.00 246 0 0 0.00
DATA_A /dev/rcdld_data_a17 278 0 3536.91 1.00 266 0 0 0.00
DATA_A /dev/rcdld_data_a18 229 0 3491.88 1.00 216 0 0 0.00
DATA_A /dev/rcdld_data_a19 242 0 3494.34 1.00 229 0 0 0.00
DATA_A /dev/rcdld_data_a20 598 0 3476.64 1.00 585 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx01 62 0 7.42 1.00 16 0 1 10.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx02 96 0 6.46 1.00 25 0 2 10.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx03 122 0 8.20 1.00 157 0 3 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx04 83 0 9.64 1.00 25 0 1 10.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx05 48 0 7.08 1.00 14 0 5 4.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx06 210 0 8.81 1.00 59 0 13 6.15
DATA_CW_INDEX01 /dev/rcdld_cw_indx07 88 0 5.00 1.00 72 0 1 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx08 168 0 4.88 1.00 174 0 4 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx09 16 0 5.00 1.00 3 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx10 14 0 2.86 1.00 2 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx11 14 0 3.57 1.00 3 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx12 13 0 3.85 1.00 4 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx13 15 0 4.00 1.00 2 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx14 16 0 2.50 1.00 2 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx15 25 0 6.80 1.00 7 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx16 19 0 3.68 1.00 4 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx17 22 0 4.55 1.00 5 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx18 18 0 5.00 1.00 5 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx19 20 0 4.50 1.00 2 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx20 13 0 4.62 1.00 2 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx21 16 0 4.38 1.00 3 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx22 21 0 30.95 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx23 18 0 3.33 1.00 4 0 0 0.00
GDZC /dev/rcdld_gdzc1 15 0 9.33 1.00 3 0 0 0.00
GDZC /dev/rcdld_gdzc2 17 0 6.47 1.00 18 0 0 0.00
GGFW /dev/rcdld_ggfw 89 0 0.67 1.00 4 0 2 0.00
IUFO /dev/rnnc_iufo 13,015 3 0.26 1.00 6 0 298 1.95
JYDATA /dev/rcdld_jydata01 45,965 12 20.47 1.63 2,437 1 157 779.68
JYDATA /dev/rcdld_jydata02 42,052 11 31.39 1.78 2,703 1 33 1.82
JYDATA /dev/rcdld_jydata03 40,454 11 26.69 1.87 2,554 1 1,141 990.02
JYDATA /dev/rcdld_jydata04 45,699 12 13.69 1.54 2,448 1 302 936.92
JYINDEX /dev/rcdld_jyindex01 32,231 9 208.91 1.08 17,804 5 26 150.00
JYLOBDATA /dev/rcdld_jylobdata 125 0 608.32 1.00 25 0 2 0.00
JYSHORTDATA /dev/rcdld_jyshortdat 82 0 3.05 1.00 53 0 0 0.00
JYTEMP /dev/rcdld_jytemp 29 0 2.41 1.00 17 0 0  
LDGGSJ /dev/rcdld_gongan 840 0 7.31 1.00 15 0 0 0.00
LDJG /dev/rcdld_ldjg01 78 0 8.72 1.45 92 0 0 0.00
LDYL /dev/rcdld_yldata01 3 0 20.00 1.00 1 0 0 0.00
NNC_DATA01 /dev/rnnc_data01 66,506 18 0.45 1.02 175 0 630 3.32
NNC_DATA01 /dev/rnnc_data1_1 32,307 9 0.90 1.01 358 0 367 3.13
NNC_DATA01 /dev/rnnc_data1_2 10,586 3 1.07 1.00 168 0 174 1.84
NNC_DATA02 /dev/rnnc_data02 242 0 6.45 2.86 3 0 0 0.00
NNC_DATA03 /dev/rnnc_data03 512 0 5.80 1.00 45 0 0 0.00
NNC_INDEX01 /dev/rnnc_ind01_01 775 0 5.97 1.00 515 0 0 0.00
NNC_INDEX01 /dev/rnnc_index01 1,514 0 5.97 1.00 730 0 0 0.00
NNC_INDEX01 /dev/rnnc_index04 141 0 5.11 1.00 280 0 0 0.00
NNC_INDEX02 /dev/rnnc_index02 114 0 6.67 1.00 2 0 0 0.00
NNC_INDEX03 /dev/rnnc_index03 1,133 0 3.86 1.00 271 0 0 0.00
PENSION_DATA /dev/rcdld_sbpenda1 3 0 20.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor1 5 0 10.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor10 5 0 10.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor11 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor12 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor13 5 0 10.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor14 5 0 10.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor15 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor16 9 0 3.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor17 9 0 3.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor18 9 0 3.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor19 9 0 3.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor2 9 0 3.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor20 9 0 3.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor21 9 0 3.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor22 9 0 3.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor23 11 0 7.27 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor24 10 0 8.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor25 9 0 3.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor26 132 0 0.30 1.00 2 0 3 0.00
SHORDATA /dev/rcdld_sbshor27 10 0 8.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor28 50 0 2.00 1.00 2 0 2 0.00
SHORDATA /dev/rcdld_sbshor29 10 0 7.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor3 10 0 3.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor30 10 0 7.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor31 10 0 6.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor32 51 0 1.37 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor33 8 0 11.25 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor34 29 0 4.83 1.00 15 0 0 0.00
SHORDATA /dev/rcdld_sbshor35 136 0 0.74 1.00 11 0 66 869.24
SHORDATA /dev/rcdld_sbshor36 256 0 0.43 1.00 4 0 9 0.00
SHORDATA /dev/rcdld_sbshor37 15 0 5.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor38 77 0 5.45 1.14 34 0 1 0.00
SHORDATA /dev/rcdld_sbshor39 12 0 5.83 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor4 10 0 8.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor40 69 0 2.75 1.00 25 0 2 5.00
SHORDATA /dev/rcdld_sbshor41 49 0 5.92 1.00 52 0 0 0.00
SHORDATA /dev/rcdld_sbshor42 23 0 8.26 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor43 21 0 5.71 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor44 58 0 2.59 1.00 2 0 2 0.00
SHORDATA /dev/rcdld_sbshor45 36 0 8.61 1.00 35 0 0 0.00
SHORDATA /dev/rcdld_sbshor46 553 0 0.90 1.00 21 0 24 1.25
SHORDATA /dev/rcdld_sbshor47 208 0 1.78 1.00 18 0 8 0.00
SHORDATA /dev/rcdld_sbshor48 97 0 3.81 1.00 28 0 3 0.00
SHORDATA /dev/rcdld_sbshor49 92 0 6.52 1.00 104 0 0 0.00
SHORDATA /dev/rcdld_sbshor5 10 0 8.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor50 231 0 1.04 1.00 19 0 15 0.67
SHORDATA /dev/rcdld_sbshor51 58 0 5.86 1.00 96 0 0 0.00
SHORDATA /dev/rcdld_sbshor52 18 0 7.22 1.00 3 0 0 0.00
SHORDATA /dev/rcdld_sbshor53 14 0 7.14 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor54 12 0 8.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor55 53 0 2.26 1.00 2 0 2 0.00
SHORDATA /dev/rcdld_sbshor56 104 0 2.40 1.29 2 0 2 0.00
SHORDATA /dev/rcdld_sbshor57 87 0 3.91 1.83 29 0 1 0.00
SHORDATA /dev/rcdld_sbshor58 64 0 8.59 2.91 2 0 2 0.00
SHORDATA /dev/rcdld_sbshor59 23 0 16.52 6.30 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor6 10 0 8.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor60 61 0 15.41 3.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor61 117 0 7.61 2.04 157 0 0 0.00
SHORDATA /dev/rcdld_sbshor62 62 0 13.55 2.97 21 0 0 0.00
SHORDATA /dev/rcdld_sbshor63 124 0 3.95 1.98 42 0 6 1.67
SHORDATA /dev/rcdld_sbshor64 42 0 12.62 3.90 40 0 0 0.00
SHORDATA /dev/rcdld_sbshor65 18 0 25.00 7.78 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor66 28 0 17.86 5.36 3 0 0 0.00
SHORDATA /dev/rcdld_sbshor67 34 0 15.29 4.59 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor68 34 0 20.59 4.59 17 0 61 973.93
SHORDATA /dev/rcdld_sbshor69 121 0 2.40 1.00 27 0 2 10.00
SHORDATA /dev/rcdld_sbshor7 10 0 8.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor70 29 0 7.59 1.00 19 0 0 0.00
SHORDATA /dev/rcdld_sbshor71 159 0 2.14 1.00 20 0 6 1.67
SHORDATA /dev/rcdld_sbshor72 96 0 13.96 2.27 150 0 0 0.00
SHORDATA /dev/rcdld_sbshor73 66 0 13.79 2.85 113 0 0 0.00
SHORDATA /dev/rcdld_sbshor74 284 0 5.77 1.00 538 0 0 0.00
SHORDATA /dev/rcdld_sbshor75 168 0 7.92 1.73 202 0 1 0.00
SHORDATA /dev/rcdld_sbshor76 320 0 5.00 1.38 354 0 5 4.00
SHORDATA /dev/rcdld_sbshor77 236 0 5.17 1.52 326 0 1 0.00
SHORDATA /dev/rcdld_sbshor78 292 0 6.85 1.42 492 0 0 0.00
SHORDATA /dev/rcdld_sbshor79 86 0 5.47 1.00 150 0 0 0.00
SHORDATA /dev/rcdld_sbshor8 10 0 8.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor80 145 0 15.03 1.84 282 0 0 0.00
SHORDATA /dev/rcdld_sbshor81 333 0 5.50 1.00 597 0 0 0.00
SHORDATA /dev/rcdld_sbshor82 813 0 4.44 1.15 1,024 0 13 0.77
SHORDATA /dev/rcdld_sbshor83 1,056 0 5.85 1.12 9,634 3 6 0.00
SHORDATA /dev/rcdld_sbshor84 1,401 0 6.22 1.09 5,872 2 0 0.00
SHORDATA /dev/rcdld_sbshor85 1,430 0 4.38 1.09 2,782 1 1 30.00
SHORDATA /dev/rcdld_sbshor86 1,603 0 4.78 1.08 3,142 1 2 0.00
SHORDATA /dev/rcdld_sbshor87 1,984 1 5.08 1.06 4,487 1 0 0.00
SHORDATA /dev/rcdld_sbshor88 2,150 1 4.98 1.24 6,088 2 4 0.00
SHORDATA /dev/rcdld_sbshor89 2,157 1 3.89 1.03 12,157 3 8 12.50
SHORDATA /dev/rcdld_sbshor9 10 0 8.00 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor90 1,494 0 4.68 1.00 2,998 1 4 0.00
SHORDATA /dev/rcdld_sbshor91 1,390 0 5.04 1.00 2,777 1 2 35.00
SHORDATA /dev/rcdld_sbshor92 1,638 0 4.84 1.00 3,523 1 1 0.00
SHORDATA /dev/rcdld_sbshor93 1,300 0 4.77 1.00 2,267 1 3 0.00
SHORDATA /dev/rcdld_sbshor94 1,257 0 4.39 1.00 2,292 1 2 0.00
SHORDATA /dev/rcdld_sbshor95 1,758 0 5.16 1.00 3,741 1 0 0.00
SHORDATA /dev/rcdld_sbshor96 1,616 0 4.32 1.00 3,035 1 3 0.00
SHORDATA /dev/rcdld_sbshor97 1,671 0 3.53 1.00 2,704 1 3 0.00
SYBX_DATA /dev/rcdld_sydata01 2 0 25.00 1.00 2 0 0 0.00
SYBX_DATA /dev/rcdld_sydata02 8 0 2.50 1.00 2 0 0 0.00
SYSAUX /dev/rcdld_sysaux01 473 0 355.67 1.03 564 0 0 0.00
SYSAUX /dev/rcdld_sysaux02 315 0 41.11 1.00 267 0 0 0.00
SYSAUX /dev/rcdld_sysaux03 239 0 44.23 1.03 247 0 0 0.00
SYSAUX /dev/rcdld_sysaux04 133 0 6.47 1.00 162 0 0 0.00
SYSAUX /dev/rcdld_sysaux05 157 0 143.69 1.00 247 0 0 0.00
SYSAUX /dev/rcdld_sysaux06 200 0 6.80 1.00 198 0 0 0.00
SYSTEM /dev/rcdld_system01 2,114 1 37.35 1.29 242 0 19 12.11
SYSTEM /dev/rcdld_system02 291 0 10.82 1.70 149 0 0 0.00
SYSTEM /dev/rcdld_system03 156 0 8.46 2.26 115 0 0 0.00
TEMP /dev/rcdld_temp01 504 0 4.94 1.82 828 0 0  
TEMP /dev/rcdld_temp02 163 0 4.66 1.03 517 0 0  
TEMP /dev/rcdld_temp03 5,944 2 20.48 27.83 49,548 13 0  
TEMP /dev/rcdld_temp05 2,949 1 3.19 3.09 685 0 0  
TEMPDATA /dev/rtempdata01 133 0 0.60 1.00 2 0 2 0.00
TEMPDATA /dev/rtempdata02 51 0 1.37 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata03 51 0 1.76 1.00 2 0 2 5.00
TEMPDATA /dev/rtempdata04 10 0 8.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata05 51 0 1.76 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata06 215 0 0.51 1.00 2 0 2 0.00
TEMPDATA /dev/rtempdata07 10 0 8.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata08 10 0 8.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata09 51 0 1.57 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata10 10 0 8.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata11 10 0 8.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata12 10 0 8.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata13 51 0 1.76 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata14 10 0 8.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata15 10 0 8.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata16 10 0 8.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata29 90 0 0.89 1.00 2 0 4 0.00
TEMPDATA /dev/rtempdata30 133 0 0.45 1.00 2 0 4 0.00
TEMPDATA /dev/rtempdata31 49 0 1.02 1.00 2 0 2 0.00
TEMPDATA /dev/rtempdata32 90 0 0.56 1.00 2 0 4 0.00
TEMPDATA /dev/rtempdata33 133 0 0.75 1.00 2 0 2 10.00
TEMPDATA /dev/rtempdata34 92 0 0.54 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata35 10 0 4.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata36 92 0 1.09 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata37 10 0 9.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata38 92 0 1.09 1.00 2 0 1 10.00
TEMPDATA /dev/rtempdata39 172 0 0.87 1.00 2 0 3 26.67
TEMPDATA /dev/rtempdata40 10 0 9.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata41 92 0 0.98 1.00 2 0 6 10.00
TEMPDATA /dev/rtempdata42 51 0 1.96 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata43 50 0 2.00 1.00 2 0 3 0.00
TEMPDATA /dev/rtempdata44 10 0 9.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata45 51 0 1.96 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata46 50 0 2.00 1.00 2 0 1 0.00
TEMPDATA /dev/rtempdata47 10 0 9.00 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata48 53 0 1.70 1.00 2 0 0 0.00
TEMPDATA /dev/rtempdata49 51 0 1.18 1.00 2 0 1 0.00
TEMPDATA /dev/rtempdata50 10 0 6.00 1.00 2 0 0 0.00
UNDOTBS1 /dev/rcdld_undo01_01 687 0 5.41 1.00 12,105 3 3,882 527.40
UNDOTBS1 /dev/rcdld_undo01_02 617 0 4.91 1.00 10,029 3 1,656 560.03
UNDOTBS1 /dev/rcdld_undo01_03 748 0 5.23 1.00 10,191 3 377 29.66
UNDOTBS1 /dev/rcdld_undo01_04 749 0 4.45 1.00 8,186 2 144 0.00
UNDOTBS1 /dev/rcdld_undo01_05 1,151 0 4.25 1.00 6,544 2 106 0.00
UNDOTBS2 /dev/rcdld_undo02_01 16,992 5 12145.93 1.00 15,338 4 0 0.00
UNDOTBS2 /dev/rcdld_undo02_02 15,954 4 11137.08 1.00 14,496 4 11 991.82
USERS /dev/rcdld_users01 502 0 0.36 1.01 2 0 0 0.00
XNH_DATA /dev/rcdld_xnh01 3 0 20.00 1.00 1 0 0 0.00
XNH_DATA /dev/rcdld_xnh02 3 0 20.00 1.00 1 0 0 0.00
XNH_DATA /dev/rcdld_xnh03 3 0 20.00 1.00 1 0 0 0.00
XNH_DATA /dev/rcdld_xnh04 4 0 12.50 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,825,280 99 1,054,546,114 7,911,812 1,853,259 0 0 1,148,357


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 52 285979 2103708 10898486 15092100 10898486  
E 0 43 60877 297805 3207967 15092100 3207967  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 8,192 0.10 982,528 2.41 ###############
D 16,384 0.20 1,965,056 1.51 67,600,962,807
D 24,576 0.30 2,947,584 1.31 58,678,634,727
D 32,768 0.40 3,930,112 1.22 54,470,842,632
D 40,960 0.50 4,912,640 1.12 50,284,935,823
D 49,152 0.60 5,895,168 1.08 48,370,968,339
D 57,344 0.70 6,877,696 1.05 47,104,738,842
D 65,536 0.80 7,860,224 1.03 46,137,558,906
D 73,728 0.90 8,842,752 1.01 45,339,239,844
D 81,920 1.00 9,825,280 1.00 44,707,221,720
D 90,112 1.10 10,807,808 0.99 44,171,608,704
D 98,304 1.20 11,790,336 0.98 43,710,163,295
D 106,496 1.30 12,772,864 0.97 43,300,993,477
D 114,688 1.40 13,755,392 0.96 42,947,995,135
D 122,880 1.50 14,737,920 0.95 42,634,254,392
D 131,072 1.60 15,720,448 0.95 42,341,071,408
D 139,264 1.70 16,702,976 0.94 42,082,560,863
D 147,456 1.80 17,685,504 0.94 41,850,900,810
D 155,648 1.90 18,668,032 0.93 41,635,281,746
D 163,840 2.00 19,650,560 0.90 40,339,327,465

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
94.11 81,773 5,117

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 14,357 7,381.01 235.81 3.19 100.00 0.00 1,048,576
E 20,480 16,480 4,456.75 60.32 1.35 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 4,322,025 4,322,025 0 0
64K 128K 18,514 18,514 0 0
128K 256K 12,563 12,563 0 0
256K 512K 900 900 0 0
512K 1024K 35,298 35,298 0 0
1M 2M 30,536 30,536 0 0
2M 4M 814 814 0 0
4M 8M 79 79 0 0
8M 16M 19 19 0 0
16M 32M 7 7 0 0
32M 64M 9 9 0 0
128M 256M 2 2 0 0
256M 512M 2 2 0 0
512M 1024M 3 1 2 0
2G 4G 1 0 1 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 262,913,732.96 65,603,423.64 80.00 1,471,302
5,120 0.25 262,913,732.96 20,479,956.62 93.00 33,171
10,240 0.50 262,913,732.96 12,728,847.66 95.00 234
15,360 0.75 262,913,732.96 12,728,792.55 95.00 228
20,480 1.00 262,913,732.96 7,842,734.09 97.00 203
24,576 1.20 262,913,732.96 6,912,093.53 97.00 197
28,672 1.40 262,913,732.96 6,912,093.53 97.00 193
32,768 1.60 262,913,732.96 6,912,093.53 97.00 187
36,864 1.80 262,913,732.96 6,912,093.53 97.00 174
40,960 2.00 262,913,732.96 6,912,093.53 97.00 168
61,440 3.00 262,913,732.96 6,912,093.53 97.00 42
81,920 4.00 262,913,732.96 6,912,093.53 97.00 0
122,880 6.00 262,913,732.96 6,912,093.53 97.00 0
163,840 8.00 262,913,732.96 6,912,093.53 97.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
2,064 0.10 2,064 147,798 1,170,082,695 1.00 4,490,303 3.41 3,191,018,585
4,112 0.20 4,112 197,326 1,171,969,993 1.00 2,603,005 1.98 3,205,965,075
6,160 0.30 6,160 246,160 1,172,547,471 1.00 2,025,527 1.54 3,208,695,360
8,208 0.40 8,208 314,801 1,172,811,079 1.00 1,761,919 1.34 3,210,332,289
10,256 0.50 10,256 384,604 1,172,995,210 1.00 1,577,788 1.20 3,211,409,902
12,304 0.60 12,304 446,827 1,173,067,588 1.00 1,505,410 1.14 3,212,131,582
14,352 0.70 14,352 510,421 1,173,129,349 1.00 1,443,649 1.10 3,212,663,960
16,400 0.80 16,400 569,249 1,173,173,068 1.00 1,399,930 1.06 3,213,079,373
18,448 0.90 18,448 630,725 1,173,203,497 1.00 1,369,501 1.04 3,213,414,504
20,496 1.00 20,496 696,419 1,173,257,401 1.00 1,315,597 1.00 3,213,702,392
22,544 1.10 22,544 757,035 1,173,271,788 1.00 1,301,210 0.99 3,213,951,744
24,592 1.20 24,592 817,563 1,173,283,055 1.00 1,289,943 0.98 3,214,169,908
26,640 1.30 26,640 892,255 1,173,300,824 1.00 1,272,174 0.97 3,214,369,860
28,688 1.40 28,688 983,322 1,173,323,278 1.00 1,249,720 0.95 3,214,556,670
30,736 1.50 30,736 1,055,067 1,173,338,484 1.00 1,234,514 0.94 3,214,730,002
32,784 1.60 32,784 1,126,717 1,173,352,004 1.00 1,220,994 0.93 3,214,892,089
34,832 1.70 34,832 1,201,057 1,173,368,722 1.00 1,204,276 0.92 3,215,045,764
36,880 1.80 36,880 1,269,890 1,173,381,393 1.00 1,191,605 0.91 3,215,192,385
38,928 1.90 38,928 1,348,196 1,173,393,221 1.00 1,179,777 0.90 3,215,329,991
40,976 2.00 40,976 1,654,916 1,173,402,338 1.00 1,170,660 0.89 3,215,457,458

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

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 898,835 735,919 819
1st level bmb 239,827 239,484 999
undo header 5,654 3,021 534
segment header 1,717 5 3
undo block 786 1 1
system undo header 50 0 6
extent map 37 0 5
2nd level bmb 2 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (index contention) 17,917 17,911 0 5,170 161,991 31,332.87
US-Undo Segment 946,713 945,804 0 251,429 26,988 107.34
SQ-Sequence Cache 6,356 6,318 0 76 9,200 121,051.66
CF-Controlfile Transaction 11,010 10,603 407 714 7,914 11,083.45
PS-PX Process Reservation 605 553 54 140 1,033 7,379.45
TT-Tablespace 157,887 157,887 0 9,743 619 63.52
PR-Process Startup 67 67 0 3 607 202,361.00
TO-Temp Object 71,336 16,445 54,891 61,164 600 9.81
JQ-Job Queue 173 51 122 39 585 15,000.46
TX-Transaction (row lock contention) 876 873 1 235 377 1,605.41
TX-Transaction (allocate ITL entry) 142 142 0 13 185 14,198.69
TM-DML 226,295 226,296 0 2,092 16 7.63
WF-AWR Flush 38 28 10 11 12 1,062.64
TQ-Queue table enqueue (INI contention) 48 48 0 1 7 7,318.00
TX-Transaction 131,777 131,782 3 746 1 1.49
FB-Format Block 2,385 2,385 0 1,181 1 0.84
HW-Segment High Water Mark 27,547 27,547 0 56 0 0.91
TA-Instance Undo 13 13 0 13 0 0.62
PW-Buffer Cache PreWarm (flush prewarm buffers) 5 1 4 5 0 1.00
UL-User-defined 1 1 0 1 0 4.00
WL-Being Written Redo Log 33 13 20 5 0 0.60
MD-Materialized View Log DDL 1 1 0 1 0 3.00
WR-LNS archiving log 5 5 0 2 0 0.50
DR-Distributed Recovery 2 2 0 1 0 1.00
IR-Instance Recovery 5 5 0 1 0 1.00
RT-Redo Thread 3 2 1 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 2,163 0.00   0 0  
AWR Alerted Metric Element list 89,240 0.00   0 0  
Consistent RBA 88,281 0.04 0.00 0 0  
FAL request queue 93 0.00   0 0  
FAL subheap alocation 91 1.10 1.00 0 0  
FIB s.o chain latch 308 0.32 0.00 0 0  
FOB s.o list latch 340,503 0.63 0.16 98 0  
JS broadcast add buf latch 10,983 0.00   0 0  
JS broadcast drop buf latch 10,983 0.00   0 0  
JS broadcast load blnc latch 10,915 0.00   0 0  
JS queue state obj latch 327,450 0.00   0 0  
JS slv state obj latch 32 0.00   0 0  
KCL gc element parent latch 86,243,227 0.01 1.76 3159 12,912 0.44
KJC destination ctx free list 111 0.00   0 0  
KJC message pool free list 205,266 2.62 0.83 195 28,877 0.08
KJCT flow control latch 3,259,233 0.01 0.00 0 0  
KMG MMAN ready and startup request latch 1,255 0.00   0 0  
KPON ksr channel latch 575 0.00   0 0  
KSXR large replies 135 0.00   0 0  
KTF sga latch 12 0.00   0 733 0.00
KWQMN job cache list latch 260 0.00   0 0  
KWQMN to-be-Stopped Buffer list Latch 1 0.00   0 0  
LGWR NS Write 1,397 0.07 0.00 0 0  
Memory Management Latch 0     0 1,255 0.00
OS process 124,001 0.00   0 0  
OS process allocation 84,303 0.08 0.17 0 0  
OS process: request allocation 82,783 0.32 1.72 105 0  
PL/SQL warning settings 56,476 0.00   0 0  
SGA IO buffer pool latch 126,887 0.06 0.13 1 128,355 0.07
SQL memory manager latch 4,274 39.89 1.32 2 1,062 0.09
SQL memory manager workarea list latch 6,031,760 0.00 0.01 0 0  
Shared B-Tree 84 0.00   0 0  
active checkpoint queue latch 1,033,972 0.38 0.00 0 0  
active service list 209,212 0.10 0.07 1 5,428 0.00
alert log latch 2,056 0.00   0 0  
archive control 298 0.00   0 0  
archive process latch 1,263 0.00   0 0  
begin backup scn array 3,677 0.00   0 0  
business card 88 0.00   0 0  
cache buffer handles 168,392 0.06 0.55 0 0  
cache buffers chains 2,063,874,972 0.35 0.04 5866 21,306,447 1.22
cache buffers lru chain 8,017,809 0.07 0.30 157 25,117,391 0.12
cache table scan latch 0     0 204,294 0.06
channel anchor 1,148 0.00   0 0  
channel handle pool latch 112,146 0.36 9.61 1118 0  
channel operations parent latch 3,004,362 0.15 0.08 0 0  
checkpoint queue latch 54,092,073 0.00 0.57 111 1,455,094 0.00
client/application info 243,503 0.00   0 0  
commit callback allocation 12,766 0.00   0 0  
compile environment latch 41,641 0.00   0 0  
database property service latch 3 0.00   0 0  
dictionary lookup 1 0.00   0 0  
dml lock allocation 453,735 0.26 54.56 19174 0  
dummy allocation 82,104 0.18 0.12 0 0  
enqueue hash chains 8,265,439 0.11 0.08 14 269,911 0.01
enqueues 5,034,283 1.38 0.00 32 0  
error message lists 227 0.44 0.00 0 0  
event group latch 41,583 0.00 0.00 0 0  
file cache latch 7,520 0.00   0 0  
gcs domain validate latch 1,799 0.17 0.00 0 0  
gcs drop object freelist 2 0.00   0 0  
gcs opaque info freelist 753,334 0.04 0.00 0 0  
gcs partitioned table hash 121,053,113 0.00   0 7,470,737 0.00
gcs remaster request queue 244 0.41 0.00 0 0  
gcs remastering latch 23,068,040 0.00 11.06 5 0  
gcs resource freelist 8,100,368 0.00 0.04 0 557,913 0.00
gcs resource hash 84,681,876 0.00 6.56 8152 46 0.00
gcs resource scan list 92 0.00   0 0  
gcs resource validate list 10,545,750 0.38 0.04 37 0  
gcs shadows freelist 6,774,967 0.00 0.00 0 636,829 0.00
generalized trace enabling latch 1 0.00   0 0  
ges caches resource lists 1,731,843 0.22 0.09 31 567,443 0.12
ges deadlock list 250,460 0.01 0.00 0 6,860 0.00
ges domain table 3,834,240 0.01 0.13 10 0  
ges enqueue table freelist 3,897,296 0.01 0.73 46 0  
ges group table 5,455,948 0.09 0.05 67 0  
ges process hash list 266,223 0.00 1.00 0 5 0.00
ges process parent latch 8,170,120 0.00 0.00 0 38 0.00
ges process table freelist 82,784 0.20 12.61 577 0  
ges resource hash list 10,329,141 0.17 0.40 677 555,923 0.09
ges resource scan list 497,691 0.63 0.00 0 0  
ges resource table freelist 554,569 0.01 0.07 0 1 0.00
ges synchronous data 156 3.85 0.00 0 259,648 0.00
ges timeout list 11,596 0.00   0 32,745 0.00
global KZLD latch for mem in SGA 41,003 0.00   0 0  
global tx hash mapping 118,556 0.00   0 3 0.00
hash table column usage latch 2,823 0.00   0 2,298,734 0.00
hash table modification latch 230 0.00   0 0  
intra txn parallel recovery 17,058 0.04 0.00 0 35 0.00
job workq parent latch 0     0 90 0.00
job_queue_processes parameter latch 78 0.00   0 0  
kks stats 139,122 0.03 0.50 0 0  
kokc descriptor allocation latch 1,556 0.00   0 0  
ksuosstats global area 164 0.00   0 0  
ktm global data 55,377 0.00   0 0  
kwqbsn:qsga 84 0.00   0 0  
lgwr LWN SCN 88,331 0.10 0.00 0 0  
library cache 9,829,450 0.10 0.92 100693 149,009 0.20
library cache load lock 20,698 0.00   0 0  
library cache lock 6,250,520 0.03 0.17 90 0  
library cache lock allocation 217,499 0.02 0.96 1 0  
library cache pin 2,948,679 0.03 0.00 0 142 0.00
library cache pin allocation 27,551 0.00   0 0  
list of block allocation 120,353 0.06 1.39 15 0  
loader state object freelist 26,705 0.01 0.00 0 0  
longop free list parent 1,499 0.00   0 63,493 0.00
message pool operations parent latch 121,209 0.01 0.00 0 0  
messages 2,850,458 0.50 0.19 881 0  
mostly latch-free SCN 109,091 17.79 0.00 0 0  
multiblock read objects 858,422 0.04 0.00 0 0  
name-service memory objects 24,596 0.00   0 0  
name-service namespace bucket 32,983 0.00   0 0  
name-service namespace objects 8 0.00   0 0  
name-service pending queue 8,226 0.00   0 0  
name-service request 96 0.00   0 0  
name-service request queue 31,345 0.00   0 0  
ncodef allocation latch 172 0.00   0 0  
object queue header heap 311,534 0.00   0 315,447 0.00
object queue header operation 46,746,521 0.09 0.31 44 0  
object stats modification 28,122 0.05 0.21 1 0  
parallel query alloc buffer 1,906 0.47 0.78 0 0  
parallel query stats 237 7.59 0.89 0 0  
parallel txn reco latch 467,384 0.44 0.00 0 0  
parameter list 855 0.58 0.00 0 0  
parameter table allocation management 154,128 0.10 0.72 3 0  
post/wait queue 903,761 0.02 0.00 0 333,784 0.02
process allocation 100,688 1.56 3171.35 48660 40,758 2.02
process group creation 82,782 0.05 0.00 0 0  
process queue 779 0.00   0 0  
process queue reference 5,832,777 0.09 0.00 0 610,458 3.25
qmn state object latch 4 0.00   0 0  
qmn task queue latch 353 0.00   0 0  
query server freelists 703 3.27 0.78 0 0  
query server process 42 0.00   0 3 0.00
queued dump request 11,296 0.00   0 0  
redo allocation 1,714,488 0.26 0.32 63 21,285,271 0.35
redo copy 0     0 21,292,305 0.05
redo writing 1,738,198 0.28 0.16 70 0  
resmgr group change latch 41,211 0.00   0 0  
resmgr:active threads 85,365 0.00   0 0  
resmgr:actses change group 41,175 0.00   0 0  
resmgr:actses change state 1,631 0.00   0 0  
resmgr:free threads list 82,103 0.24 0.23 2 0  
resmgr:resource group CPU method 1,631 0.00   0 0  
resmgr:vc list latch 1,631 0.00   0 0  
row cache objects 43,750,766 16.24 0.02 22869 14,266 14.73
rules engine aggregate statistics 16 0.00   0 0  
rules engine rule set statistics 32 0.00   0 0  
sequence cache 642,009 0.09 0.00 0 0  
session allocation 2,784,040 0.30 0.02 5 0  
session idle bit 14,651,427 0.00 0.00 0 0  
session state list latch 85,012 0.25 0.10 1 0  
session switching 169 0.00   0 0  
session timer 976 0.00   0 0  
shared pool 5,844,731 0.19 3.50 339736 0  
shared pool simulator 18,877,945 0.07 0.04 13667 0  
simulator hash latch 72,646,807 0.00 0.00 0 0  
simulator lru latch 0     0 71,628,262 0.32
slave class 11 0.00   0 0  
slave class create 45 2.22 1.00 0 0  
sort extent pool 169,638 1.24 0.13 76 0  
state object free list 2 0.00   0 0  
statistics aggregation 339 0.00   0 0  
temp lob duration state obj allocation 148 0.00   0 0  
temporary table state object allocation 1,989 0.05 0.00 0 0  
threshold alerts latch 761 0.00   0 0  
trace latch 805 1.74 0.14 0 0  
transaction allocation 2,476,791 0.01 0.98 8 0  
transaction branch allocation 119,197 0.00 0.00 0 0  
undo global data 51,350,006 0.02 0.00 9 1 0.00
user lock 188,982 0.91 2.17 27871 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 2,063,874,972 7,191,577 269,702 6,975,210 0 0 0
row cache objects 43,750,766 7,104,882 110,721 6,996,179 0 0 0
enqueues 5,034,283 69,676 299 69,481 0 0 0
object queue header operation 46,746,521 41,541 12,766 29,208 0 0 0
gcs resource validate list 10,545,750 40,057 1,487 38,575 0 0 0
ges resource hash list 10,329,141 17,736 7,007 12,296 0 0 0
messages 2,850,458 14,141 2,752 14,012 0 0 0
shared pool simulator 18,877,945 13,573 569 13,250 0 0 0
shared pool 5,844,731 11,388 39,841 6,890 0 0 0
undo global data 51,350,006 10,639 48 10,610 0 0 0
library cache 9,829,450 9,592 8,794 7,817 0 0 0
enqueue hash chains 8,265,439 9,466 712 8,759 0 0 0
KCL gc element parent latch 86,243,227 9,068 15,964 3,418 0 0 0
session allocation 2,784,040 8,370 193 8,177 0 0 0
cache buffers lru chain 8,017,809 5,777 1,761 4,534 0 0 0
KJC message pool free list 205,266 5,378 4,472 1,041 0 0 0
ges group table 5,455,948 5,158 243 5,140 0 0 0
redo writing 1,738,198 4,901 808 4,318 0 0 0
redo allocation 1,714,488 4,496 1,456 3,109 0 0 0
channel operations parent latch 3,004,362 4,404 345 4,098 0 0 0
gcs resource hash 84,681,876 4,026 26,423 3,063 0 0 0
active checkpoint queue latch 1,033,972 3,957 7 3,951 0 0 0
ges caches resource lists 1,731,843 3,770 334 3,465 0 0 0
ges resource scan list 497,691 3,124 8 3,116 0 0 0
FOB s.o list latch 340,503 2,142 350 2,118 0 0 0
sort extent pool 169,638 2,110 270 2,095 0 0 0
parallel txn reco latch 467,384 2,042 1 2,041 0 0 0
checkpoint queue latch 54,092,073 1,962 1,121 1,189 0 0 0
library cache lock 6,250,520 1,851 320 1,831 0 0 0
user lock 188,982 1,723 3,734 540 0 0 0
SQL memory manager latch 4,274 1,705 2,245 68 0 0 0
process allocation 100,688 1,573 4,988,541 671 0 0 0
dml lock allocation 453,735 1,195 65,203 313 0 0 0
channel handle pool latch 112,146 407 3,912 134 0 0 0
ges domain table 3,834,240 267 36 264 0 0 0
OS process: request allocation 82,783 262 451 120 0 0 0
ges enqueue table freelist 3,897,296 240 175 218 0 0 0
session state list latch 85,012 213 22 199 0 0 0
active service list 209,212 201 14 187 0 0 0
resmgr:free threads list 82,103 199 45 154 0 0 0
ges process table freelist 82,784 163 2,056 56 0 0 0
parameter table allocation management 154,128 154 111 49 0 0 0
gcs remastering latch 23,068,040 152 1,681 19 0 0 0
dummy allocation 82,104 147 18 129 0 0 0
transaction allocation 2,476,791 124 122 7 0 0 0
cache buffer handles 168,392 103 57 47 0 0 0
SQL memory manager workarea list latch 6,031,760 91 1 90 0 0 0
SGA IO buffer pool latch 126,887 72 9 64 0 0 0
OS process allocation 84,303 71 12 59 0 0 0
list of block allocation 120,353 67 93 23 0 0 0
gcs resource freelist 8,100,368 53 2 51 0 0 0
library cache lock allocation 217,499 48 46 4 0 0 0
ges resource table freelist 554,569 42 3 40 0 0 0
kks stats 139,122 36 18 18 0 0 0
query server freelists 703 23 18 5 0 0 0
parallel query stats 237 18 16 3 0 0 0
object stats modification 28,122 14 3 13 0 0 0
trace latch 805 14 2 12 0 0 0
parallel query alloc buffer 1,906 9 7 2 0 0 0
FAL subheap alocation 91 1 1 0 0 0 0
ges process hash list 266,223 1 1 0 0 0 0
slave class create 45 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
FAL subheap alocation krsfgfrbffa(), on-the-fly sub-FAL allocation during FAL archive 0 1 1
FOB s.o list latch ksfd_allfob 0 350 349
KCL gc element parent latch kclnfndnewm 0 13,383 4,025
KCL gc element parent latch kclliter 0 2,754 503
KCL gc element parent latch kclnfnd 0 331 260
KCL gc element parent latch kclplz 0 295 1,117
KCL gc element parent latch kclfwrite1 0 206 481
KCL gc element parent latch kclrwrite 0 197 2,469
KCL gc element parent latch kclnfndnew 0 195 2
KCL gc element parent latch kclwrt 0 163 15
KCL gc element parent latch kclzcl 0 121 198
KCL gc element parent latch kclbla 0 22 137
KCL gc element parent latch kclulb 0 18 4,308
KCL gc element parent latch kclrdone 0 14 3
KCL gc element parent latch kclhngcbk1 0 13 0
KCL gc element parent latch kclebs 0 10 549
KCL gc element parent latch KCLUNLNK 0 5 3,339
KCL gc element parent latch kclexpand 0 4 72
KCL gc element parent latch kclshrsplit 0 4 5
KCL gc element parent latch kclgcr 0 2 160
KJC message pool free list kjcsmpav: allocate a msg buffer 0 4,472 4,472
OS process allocation kso_new_process:2 0 11 11
OS process allocation kso_fork:1 0 1 0
OS process: request allocation kso_new_process 0 451 451
SGA IO buffer pool latch ksfd_free_sgabuffer 0 6 9
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 3 0
SQL memory manager latch qesmmIQueryRefreshBound 0 2,245 2,245
SQL memory manager workarea list latch qesmmIRefreshBound 0 1 0
active checkpoint queue latch kcbzck1: Check checkpoint complete 0 6 1
active checkpoint queue latch kcbstc1: Start a new checkpoint 0 1 6
active service list ksws_event: ksws event 0 86 78
active service list kswssyis: find service entry 1 0 4 0
cache buffer handles kcbzgs 0 57 56
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 233,236 241,222
cache buffers chains kcbgtcr: kslbegin excl 0 191,116 154,524
cache buffers chains kcbzgb: scan from tail. nowait 0 75,863 0
cache buffers chains kclcls_3 0 61,181 573
cache buffers chains kcbrls: kslbegin 0 16,711 34,777
cache buffers chains kcbchg: kslbegin: call CR func 0 2,828 110,879
cache buffers chains kcbzwb 0 2,392 37,902
cache buffers chains kcbgtcr: fast path 0 1,293 892
cache buffers chains kcbgcur: kslbegin 0 923 282
cache buffers chains kcbgtcr: kslbegin shared 0 599 518
cache buffers chains kcbget: pin buffer 0 305 289
cache buffers chains kcbso1: set no access 0 296 6
cache buffers chains kcbgcur: buf pinned 0 197 197
cache buffers chains kcbgkcbcr 0 72 1,091
cache buffers chains kcbcge 0 63 3,237
cache buffers chains kcbzib: multi-block read: nowait 0 58 0
cache buffers chains kcbbxsv 0 35 18
cache buffers chains kcbnlc 0 19 100
cache buffers chains kclexpand 0 9 0
cache buffers chains kclbla 0 7 3
cache buffers chains kcbgtcr 0 5 2
cache buffers chains kclwrt 0 5 0
cache buffers chains kcbbic1 0 4 0
cache buffers chains kcbnew: new latch again 0 4 14
cache buffers chains kcbzib: finish free bufs 0 4 19
cache buffers chains kcbbic2 0 3 4
cache buffers chains kclwlr 0 3 1
cache buffers chains kcbget: exchange 0 2 50
cache buffers chains kclclaim 0 2 2
cache buffers chains kclebs_1 0 2 1
cache buffers chains kclrls 0 2 617
cache buffers chains kcbget: exchange rls 0 1 27
cache buffers chains kcbtema 0 1 0
cache buffers chains kclpto 0 1 0
cache buffers lru chain kcbzgws 0 861 0
cache buffers lru chain kcbo_ivd_proc 0 424 115
cache buffers lru chain kcbbxsv: move to being written 0 327 786
cache buffers lru chain kcbbic2 0 49 214
cache buffers lru chain kcbo_link_q 0 33 1
cache buffers lru chain kcbtema 0 33 85
cache buffers lru chain kcbbwlru 0 24 460
cache buffers lru chain kcbzgb: posted for free bufs 0 4 90
cache buffers lru chain kcbzswcu 0 4 0
cache buffers lru chain kcbgtcr:CR Scan:best 0 2 0
cache buffers lru chain kcbzfw 0 1 12
channel handle pool latch ksrchconnect() 0 3,948 3,837
channel operations parent latch ksrchdelete() 0 400 46
channel operations parent latch ksrwait() 0 108 359
channel operations parent latch ksrapublish() 0 2 79
channel operations parent latch ksrsconsume() 0 2 2
checkpoint queue latch kcbkubc 0 998 141
checkpoint queue latch kcbbwrcv: recovery checkpoint buffers 0 66 1
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 30 577
checkpoint queue latch kclrdone 0 22 102
checkpoint queue latch kcbwrcl: Switch buffers 0 2 1
checkpoint queue latch kcbbcrcv: check recovery queue 0 1 16
checkpoint queue latch kcbkllrba: compute lowest lrba 0 1 313
checkpoint queue latch kcbswcu: Switch buffers 0 1 0
cost function kzulgt: find user res 0 95,826 15,670
cost function kzulrl 0 61 80,150
dml lock allocation ktaiam 0 65,023 51,550
dml lock allocation ktaidm 0 124 12,990
dummy allocation ktcscnfy 0 18 18
enqueue hash chains ksqcmi: if lk mode not requested 0 345 127
enqueue hash chains ksqrcl 0 339 152
enqueue hash chains ksqcmi: if lk mode requested 0 19 424
enqueue hash chains ksucallcbksafely: ksqhngcbk1 0 7 0
enqueue hash chains ksqgtl3 0 2 9
enqueues ksqgel: create enqueue 0 153 72
enqueues ksqdel 0 132 133
enqueues ksqies 0 14 94
event range base latch No latch 0 37 17
gcs remastering latch 59 0 1,555 1
gcs remastering latch 43 0 133 0
gcs resource freelist kjbrfr free resource 0 2 0
gcs resource hash kjblocalfile_nolock 0 18,413 12,058
gcs resource hash kjbmpclose 0 3,037 2,362
gcs resource hash kjbcropen:affinity 0 2,181 2,902
gcs resource hash kjbmpopen 0 1,262 677
gcs resource hash kjbopen:affinity 0 949 751
gcs resource hash kclzcl 0 248 1,876
gcs resource hash kclrwrite 0 170 1,343
gcs resource hash kjbcropen 0 79 439
gcs resource hash kjbconvert 0 47 683
gcs resource hash kjbmpwrite 0 8 95
gcs resource hash kjbopen 0 8 106
gcs resource hash kjbrrcres_99 0 5 0
gcs resource hash kjbassume 0 4 318
gcs resource hash kclgrantlk_1 0 3 0
gcs resource hash kjbmpconvert 0 3 9
gcs resource hash kjbrrcfwst 0 3 14
gcs resource hash kjbrwrdone reget 0 2 0
gcs resource hash kclfwrite1 0 1 2,428
gcs resource validate list enq res to validate list 0 1,487 1,487
ges domain table kjdmlad: add a lock to an xid-hashed lock list 0 36 36
ges enqueue table freelist kjlalc: lock allocation 0 173 167
ges enqueue table freelist kjlfr: remove lock from parent object 0 2 8
ges group table kjgdgll: move a lock from group lock list to process lock list 0 227 0
ges group table kjgagll: move a lock from process lock list to group lock list 0 16 242
ges process hash list kjakiqa: set inquiry response 0 1 0
ges process table freelist kjpalc: process allocation 0 2,056 1,987
ges resource hash list kjlrlr: remove lock from resource queue 0 3,014 3,662
ges resource hash list kjrref: find matched resource 0 1,469 1,887
ges resource hash list kjcvscn: remove from scan queue 0 922 0
ges resource hash list kjrmas1: lookup master node 0 902 99
ges resource hash list kjucvl: lock convert request 0 625 1,339
ges resource hash list kjakcai: search for resp by resname 0 61 13
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 6 0
ges resource hash list kjruch: move resource from cache to freelist 0 4 0
ges resource scan list kjcvmsc: add to scan_q 0 7 8
ges resource scan list kjcvscn: traverse scan_q 0 1 0
ges resource table freelist kjrm2c: move resource to cache 0 255 334
ges resource table freelist kjruch: cached obj cleanup 0 59 0
ges resource table freelist kjrchc: cached obj cleanup 0 18 0
ges resource table freelist kjralc: resource allocation 0 3 0
ges resource table freelist kjrchc2: cached obj cleanup 0 2 0
kks stats kks stats alloc/free 0 18 18
library cache kglobpn: child: 0 67,033 110,255
library cache kglpndl: child: after processing 0 32,265 7
library cache kgldti: 2child 0 21,169 3
library cache kglpndl: child: before processing 0 7,855 3,870
library cache kglLockCursor 0 1,422 29,255
library cache kgldte: child 0 0 269 1,660
library cache kglhdgn: child: 0 139 95,243
library cache kqlmbpil: parent 0 74 16
library cache kglpnp: child 0 47 29,467
library cache kglpin 0 27 37
library cache kglukp: child 0 25 2,935
library cache kglrtl 0 11 6
library cache kglScanDependency 0 10 0
library cache kglati 0 4 0
library cache kgldtld: 2child 0 3 2
library cache kglic 0 3 0
library cache kglini: child 0 1 0
library cache lock kgllkdl: child: no lock handle 0 211,162 61,436
library cache lock kgllkdl: child: cleanup 0 253 254
library cache lock kgllkal: child: multiinstance 0 67 66
library cache lock allocation kgllkget 0 46 45
list of block allocation ktlabl 0 90 91
list of block allocation ktcdod 0 2 2
list of block allocation ktlbbl 0 1 0
messages ksaamb: after wakeup 0 2,676 1,003
messages ksarcv 0 47 37
messages ksarcv: after wait 0 27 1,639
messages ksarcr 0 1 0
messages ksarcr: inside loop 0 1 29
object queue header operation kclobj_3 0 13,349 9
object queue header operation kcbo_ivbo 0 2,825 14,816
object queue header operation kcbw_unlink_q 0 424 916
object queue header operation kcbo_switch_q_bg 0 323 195
object queue header operation kcb_flush_undo_segment 0 251 4
object queue header operation kcbo_switch_mq_bg 0 206 548
object queue header operation kcbw_link_q 0 167 674
object queue header operation kcbo_switch_cq 0 39 263
object queue header operation kclobj_1 0 4 2
object queue header operation kcbo_link_q:reget 0 2 13
object queue header operation kcbw_unlink_q_bg 0 1 126
object stats modification ksolsnfy 0 3 0
parallel query alloc buffer kxfpbalo 0 7 6
parallel query stats kxfprst: KSLBEGIN:1 0 16 16
parallel txn reco latch ktprxrtf 0 1 1
parameter table allocation management ksp_param_table_free 0 106 4
process allocation ksuapc 0 4,987,125 4,912,186
process allocation ksucrp 0 366 0
process allocation ksufap: active procs 0 30 43,461
process allocation ksudlp 0 24 31,841
query server freelists kxfpobadf 0 18 18
redo allocation kcrfw_redo_gen: redo allocation 1 0 1,371 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 66 99
redo allocation kcrfw_redo_gen: redo allocation 2 0 9 0
redo allocation kcrfw_redo_write: before write 0 8 706
redo allocation kcrfw_redo_write: more space 0 2 651
redo writing kcrfwcr 0 287 765
redo writing kcrfw_post: after write 0 263 0
redo writing kcrfw_post: rba scn pair 0 239 0
redo writing kcrfw_cal_target_rba 0 15 0
redo writing kcrfsr: rba scn pair 0 4 43
resmgr:free threads list kgskthrcreate 0 45 43
row cache objects kqreqd 0 61,015 35,797
row cache objects kqrpre: find obj 0 40,919 65,241
row cache objects kqreqd: reget 0 36,478 35,170
row cache objects kqrigt 0 300 2,547
row cache objects kqrso 0 87 30
row cache objects kqrbgl 0 35 27
row cache objects kqrpup 0 8 1
row cache objects kqrbtm: pop parent 0 6 11
row cache objects kqrcmt: while loop 0 6 6
row cache objects kqrbpr: KQRMX 0 3 5
row cache objects kqrbpr: got immediately 0 3 3
row cache objects kqrbip 0 2 1
row cache objects kqrbpr: KQRRSNRL 0 2 7
row cache objects kqrcmt: clear flag 0 2 8
row cache objects ksucallcbksafely: kqrhngc 0 2 0
session allocation ksucri 0 74 123
session allocation ksucrp 0 56 50
session allocation ksuprc 0 27 0
session allocation ksuxds: not user session 0 22 15
session allocation ksufap: active sessions 0 12 0
session allocation ksudlp 0 2 2
session state list latch kpseqd 0 12 0
session state list latch kpscad 0 8 0
session state list latch kpseqa 0 2 13
shared pool kghupr1 0 1,154,444 65,150
shared pool kghalo 0 8,100 1,077,278
shared pool kghfrunp: clatch: nowait 0 506 0
shared pool kghfre 0 328 6,296
shared pool kghfrunp: alloc: wait 0 110 2
shared pool kghalp 0 61 11,937
shared pool kghfrh 0 59 1
shared pool kghfrunp: clatch: wait 0 17 6,142
shared pool kghasp 0 5 3
shared pool simulator kglsim_unpin_simhp 0 46,481 3,098
shared pool simulator kglsim_upd_newhp 0 279 2
shared pool simulator kglsim_unpin_simhp: fast path 0 162 43,827
shared pool simulator kglsim_scan_lru: scan 0 12 13
shared pool simulator kglsim_chg_simhp_free 0 6 0
shared pool simulator kglsim_scan_lru: rebalance 0 1 0
slave class create ksvcreate 0 1 0
sort extent pool ktstaddextent1 0 265 90
sort extent pool ktstallobj1 0 3 93
sort extent pool ktstsmonmsg 0 2 87
trace latch kstipg 0 2 2
transaction allocation ktcxbr 0 122 119
undo global data ktucof: at start 0 41 0
undo global data ktudba: KSLBEGIN 0 7 20
unknown latch ksscldo1 0 2 493

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
LDZC CDLDZC FB01   TABLE 108,659,104 10.29
CDSI2 DATA KC22K2   TABLE 89,294,640 8.46
CDSI2 DATA IDX_AD52_1   INDEX 55,331,824 5.24
CDJY JYDATA CC52   TABLE 37,619,968 3.56
CDSI2 DATA KC24K2_T P_092003 TABLE PARTITION 33,798,144 3.20

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
CDSI2 DATA IC14   TABLE 1,402,654 16.95
CDSI2 DATA KC82K1   TABLE 436,569 5.28
CDSI2 DATA AD11A7   TABLE 384,593 4.65
CDSI2 DATA KC24K2_T 20_DEFAULT TABLE PARTITION 304,811 3.68
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 298,499 3.61

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
CDSI2 DATA SYS_C00190575   INDEX 3,645 18.36
CDSI2 DATA IDX$$_CE730001_2   INDEX 3,428 17.26
CDSI2 DATA IDX$$_2EFAC0001   INDEX 3,120 15.71
CDSI2 DATA IDX_AD04A1_13   INDEX 1,503 7.57
CDSI2 DATA IDX_AE09_AAE211   INDEX 1,370 6.90

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
CDSI2 DATA SYS_C00190575   INDEX 7 17.95
CDSI2 DATA IDX_KC24K2_LOCAL 20_DEFAULT INDEX PARTITION 6 15.38
CDSI2 DATA FK_AD04A3_BM_YAD050   INDEX 5 12.82
CDSI2 DATA IDX_AE09_AAE211   INDEX 4 10.26
CDSI2 DATA IDX_KC22K2_02   INDEX 3 7.69

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
CDSI2 DATA AD53A5   TABLE 688,612 69.85
CDSI2 DATA AE09   TABLE 262,647 26.64
CDSISE DATA YHCIP_AD60   TABLE 8,761 0.89
CDSI2 DATA IDX_AB15A1_AAE076   INDEX 8,150 0.83
CDSI2 DATA AD53A4   TABLE 4,722 0.48

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
CDSI2 DATA IDX$$_2EFAC0001   INDEX 22,144 37.94
CDSI2 DATA IDX_AD04A1_09   INDEX 9,651 16.54
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 9,037 15.48
CDSI2 DATA KC24K1 YKC105_40 TABLE PARTITION 6,095 10.44
CDSI2 DATA KC24K2_T 20_DEFAULT TABLE PARTITION 5,889 10.09

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
CDSI2 DATA KC21K1   TABLE 3,786 11.15
CDSI2 DATA KC22K1   TABLE 2,695 7.94
CDSI2 DATA IDX_KB03K9_AKC190YKE248   INDEX 1,914 5.64
CDSI2 DATA KC74K1   TABLE 1,024 3.02
CDJY JYDATA AC01   TABLE 941 2.77

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
CDSI2 DATA AC01   TABLE 51,360 15.44
CDJY JYDATA CC03   TABLE 42,942 12.91
CDSI2 DATA KC74K1   TABLE 26,998 8.12
CDSI2 DATA KC71K1   TABLE 20,961 6.30
CDSI2 DATA KC21K1   TABLE 19,033 5.72

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 54 0.00 0   2 1
dc_database_links 82,106 0.00 0   0 3
dc_files 48,546 0.00 0   0 522
dc_global_oids 4,915 0.08 0   0 72
dc_histogram_data 1,707,285 0.01 0   0 55,063
dc_histogram_defs 641,620 0.06 0   0 42,163
dc_object_grants 1,849 0.22 0   0 264
dc_object_ids 1,917,727 0.01 0   1 8,306
dc_objects 159,662 0.13 0   3 15,936
dc_profiles 41,077 0.00 0   0 1
dc_rollback_segments 3,696,253 0.00 0   1,222 2,684
dc_segments 291,165 0.16 0   720 16,326
dc_sequences 6,566 5.42 0   6,560 195
dc_table_scns 1 100.00 0   0 0
dc_tablespace_quotas 12 25.00 0   7 12
dc_tablespaces 3,577,588 0.00 0   0 34
dc_usernames 216,297 0.10 0   0 27
dc_users 3,887,142 0.01 0   0 62
outstanding_alerts 374 52.14 0   16 5

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 4 0 0
dc_global_oids 4 0 0
dc_histogram_defs 420 0 545
dc_object_ids 161 0 34
dc_objects 209 0 187
dc_rollback_segments 2,592 47 0
dc_segments 1,836 11 100
dc_sequences 12,987 349 2
dc_table_scns 1 0 0
dc_tablespace_quotas 24 4 0
dc_usernames 208 0 199
dc_users 153 0 141
outstanding_alerts 697 248 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 4,903 0.08 260,661 0.07 173 0
CLUSTER 108 0.00 133 0.00 0 0
INDEX 1,695 0.24 2,957 0.17 1 0
SQL AREA 676,700 17.61 70,860,748 0.41 127,382 19,559
TABLE/PROCEDURE 169,575 0.50 1,377,267 0.73 4,415 0
TRIGGER 1,910 0.10 21,101 0.31 61 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 133 0 0 0 0
INDEX 2,957 4 5 4 0
TABLE/PROCEDURE 480,534 847 956 29 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 5,775.75   4.28 28.23 1,020 1,020 1,348 1,348
  Freeable 886.63 0.00 1.05 1.02 22   843 843
  SQL 660.15 466.83 0.51 1.61 30 1,412 1,291 1,265
  PL/SQL 61.29 29.85 0.05 0.09 1 2 1,348 1,347
E Other 3,756.83   2.17 24.94 1,025 1,025 1,734 1,734
  Freeable 529.75 0.00 0.94 1.34 32   561 561
  SQL 145.46 102.07 0.09 0.44 7 7 1,635 1,617
  PL/SQL 26.54 14.69 0.02 0.04 0 1 1,732 1,731

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 85,899,345,920  
Fixed Size 2,297,640  
Redo Buffers 282,914,816  
Variable Size 21,743,272,152  

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 1,692.70 1,643.29 -2.92
shared Cursor Stats 220.88 220.88 0.00
shared PCursor 634.67 616.86 -2.81
shared db_block_hash_buckets 720.00 720.00 0.00
shared free memory 1,804.46 1,866.14 3.42
shared gcs resources 1,720.14 1,720.14 0.00
shared gcs shadows 1,030.03 1,030.03 0.00
shared kglsim object batch 293.37 293.37 0.00
shared kkj jobq wor 1,681.83 1,681.83 0.00
shared library cache 825.21 815.14 -1.22
shared sql area 7,931.13 7,935.23 0.05
shared sql area:PLSQL 333.36 328.54 -1.44
  buffer_cache 81,920.00 81,920.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

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 9,496,036 11,092,960 11132041 11132041
gcs_shadows 11,100,908 11,131,529 11132041 11132041
ges_procs 1,734 4,552 5001 5001
processes 1,735 4,556 5000 5000
sessions 1,910 4,945 5505 5505


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_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 85899345920   
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 SERVICE=rep LGWR async DB_UNIQUE_NAME=rep REOPEN=60 MAX_FAILURE=600   
log_archive_dest_3      
log_archive_dest_4      
log_archive_dest_state_2 enable   
log_archive_format cdld1_%t_%s_%r.arc   
log_archive_max_processes 4   
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   
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) 115,073 30.64 0.78
acks for commit broadcast(logical) 171,452 45.65 1.17
broadcast msgs on commit(actual) 86,799 23.11 0.59
broadcast msgs on commit(logical) 88,423 23.55 0.60
broadcast msgs on commit(wasted) 13,864 3.69 0.09
broadcast on commit wait time(ms) 21,299 5.67 0.14
broadcast on commit waits 58,230 15.51 0.40
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 118 0.03 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 51 0.01 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 90,402 24.07 0.61
gcs ast xid 2 0.00 0.00
gcs blocked converts 60,601 16.14 0.41
gcs blocked cr converts 502,267 133.74 3.42
gcs compatible basts 5,480 1.46 0.04
gcs compatible cr basts (global) 1,966 0.52 0.01
gcs compatible cr basts (local) 327,561 87.22 2.23
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 2,898 0.77 0.02
gcs dbwr write request msgs 5,210 1.39 0.04
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 82,977 22.10 0.56
gcs immediate (null) converts 397,689 105.90 2.71
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 469,280 124.96 3.19
gcs indirect ast 603,720 160.76 4.11
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 3,791 1.01 0.03
gcs msgs process time(ms) 25,626,681 6,823.85 174.32
gcs msgs received 2,761,698 735.38 18.79
gcs out-of-order msgs 23 0.01 0.00
gcs pings refused 9 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 8 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 78 0.02 0.00
gcs side channel msgs actual 148,775 39.62 1.01
gcs side channel msgs logical 607,573 161.78 4.13
gcs stale cr 135,189 36.00 0.92
gcs undo cr 1,476 0.39 0.01
gcs write notification msgs 514 0.14 0.00
gcs writes refused 117 0.03 0.00
ges msgs process time(ms) 97,516 25.97 0.66
ges msgs received 199,001 52.99 1.35
global posts dropped 0 0.00 0.00
global posts queue time 42 0.01 0.00
global posts queued 16 0.00 0.00
global posts requested 16 0.00 0.00
global posts sent 16 0.00 0.00
implicit batch messages received 162,131 43.17 1.10
implicit batch messages sent 144,860 38.57 0.99
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 96,756 25.76 0.66
messages queue sent actual 763,155 203.21 5.19
messages queue sent logical 1,041,443 277.31 7.08
messages received actual 2,372,884 631.85 16.14
messages received logical 2,960,846 788.41 20.14
messages sent directly 741,366 197.41 5.04
messages sent indirectly 1,756,106 467.61 11.95
messages sent not implicit batched 618,320 164.65 4.21
messages sent pbatched 1,611,278 429.05 10.96
msgs causing lmd to send msgs 33,796 9.00 0.23
msgs causing lms(s) to send msgs 86,505 23.03 0.59
msgs received queue time (ms) 137,298,411 36,559.68 933.96
msgs received queued 2,960,998 788.45 20.14
msgs sent queue time (ms) 45,836,479 12,205.29 311.80
msgs sent queue time on ksxp (ms) 35,224,092 9,379.43 239.61
msgs sent queued 1,033,173 275.11 7.03
msgs sent queued on ksxp 1,655,155 440.73 11.26
process batch messages received 340,612 90.70 2.32
process batch messages sent 348,692 92.85 2.37


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 43,347
CURRENT Block Requests 439,952
Data Block Requests 43,347
Undo Block Requests 1,476
TX Block Requests 435,896
Current Results 482,820
Private results 202
Zero Results 212
Disk Read Results 0
Fail Results 61
Fairness Down Converts 7,287
Fairness Clears 0
Free GC Elements 0
Flushes 15,486
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 301,469,364
Light Works 444
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 124,067 99.42 0.13 0.36 0.08 0.00
Flushes 170 70.00 18.82 7.65 3.53 0.00
Writes 7,840 74.85 6.85 10.46 6.33 1.52


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 32,240 99.93 0.07 0.00 326,099 99.98 0.02 0.00
2 Others 892 99.44 0.56 0.00 5,380 98.20 1.80 0.00
2 undo header 698 99.71 0.29 0.00 504 99.01 0.99 0.00
2 undo block 85 98.82 1.18 0.00 16 100.00 0.00 0.00


Back to Top

End of Report