WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
CDLD2217133725cdld1110.2.0.4.0YESp780a

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:6549116-Jan-14 17:00:051333 96.8
End Snap:6549216-Jan-14 18:00:461144 93.1
Elapsed:  60.69 (mins)  
DB Time:  251.50 (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: 941,638.07 70,811.55
Logical reads: 168,565.13 12,676.16
Block changes: 5,843.80 439.46
Physical reads: 862.63 64.87
Physical writes: 299.41 22.52
User calls: 719.26 54.09
Parses: 195.61 14.71
Hard parses: 9.23 0.69
Sorts: 611.32 45.97
Logons: 3.82 0.29
Executes: 3,515.32 264.35
Transactions: 13.30 

% Blocks changed per Read: 3.47Recursive Call %: 87.52
Rollback per transaction %: 55.78Rows per Sort: 21.43

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99Redo NoWait %: 100.00
Buffer Hit %: 99.49In-memory Sort %: 100.00
Library Hit %: 99.54Soft Parse %: 95.28
Execute to Parse %: 94.44Latch Hit %: 99.93
Parse CPU to Parse Elapsd %: 9.20% Non-Parse CPU: 99.76

Shared Pool Statistics

BeginEnd
Memory Usage %: 89.72 89.69
% SQL with executions>1: 91.72 98.18
% Memory for SQL w/exec>1: 92.84 97.71

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  6,446  42.7 
db file sequential read 2,281,661 4,729 2 31.3User I/O
gc cr grant 2-way 950,480 256 0 1.7Cluster
db file scattered read 170,536 166 1 1.1User I/O
enq: PS - contention 387 142 366 .9Other

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 25.56 1.92
Global Cache blocks served: 7.83 0.59
GCS/GES messages received: 399.51 30.04
GCS/GES messages sent: 1,013.01 76.18
DBWR Fusion writes: 0.20 0.02
Estd Interconnect traffic (KB) 542.97 

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

Buffer access - local cache %: 99.47
Buffer access - remote cache %: 0.02
Buffer access - disk %: 0.51

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.7
Avg global cache cr block receive time (ms): 0.4
Avg global cache current block receive time (ms): 0.5
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 1.4
Avg global cache cr block flush time (ms): 1.0
Avg global cache current block pin time (ms): 0.1
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.7
Avg global cache current block flush time (ms): 1.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.3
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 42.56
% of indirect sent messages: 56.50
% of flow controlled messages: 0.94

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 14,920.68 98.88
DB CPU 6,446.24 42.72
parse time elapsed 172.23 1.14
PL/SQL execution elapsed time 151.33 1.00
hard parse elapsed time 61.53 0.41
failed parse elapsed time 26.69 0.18
connection management call elapsed time 23.56 0.16
sequence load elapsed time 9.43 0.06
hard parse (sharing criteria) elapsed time 1.22 0.01
PL/SQL compilation elapsed time 0.93 0.01
repeated bind elapsed time 0.86 0.01
hard parse (bind mismatch) elapsed time 0.02 0.00
DB time 15,090.10  
background elapsed time 477.94  
background cpu time 257.58  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 2,458,138 0.00 4,900 2 50.77
Cluster 1,453,926 0.00 551 0 30.03
Other 661,026 95.62 207 0 13.65
Concurrency 83,226 0.14 133 2 1.72
System I/O 251,552 0.00 84 0 5.20
Network 2,711,001 0.00 49 0 55.99
Application 7,992 0.79 37 5 0.17
Commit 12,010 0.00 10 1 0.25
Configuration 2,888 92.17 0 0 0.06

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 2,281,661 0.00 4,729 2 47.12
gc cr grant 2-way 950,480 0.00 256 0 19.63
db file scattered read 170,536 0.00 166 1 3.52
enq: PS - contention 387 0.00 142 366 0.01
library cache lock 36,150 0.00 119 3 0.75
gc current grant busy 8,489 0.07 81 10 0.18
gc buffer busy 65,156 0.00 77 1 1.35
gc current grant 2-way 236,885 0.00 66 0 4.89
PX Deq: Signal ACK 317 82.33 55 173 0.01
gc cr multi block request 116,258 0.00 40 0 2.40
LNS wait on SENDREQ 393 0.00 38 98 0.01
db file parallel write 159,395 0.00 38 0 3.29
enq: TX - row lock contention 68 92.65 32 467 0.00
gc current block 2-way 73,319 0.00 30 0 1.51
log file sequential read 24,301 0.00 14 1 0.50
Log archive I/O 3,705 0.00 13 3 0.08
log file parallel write 25,314 0.00 10 0 0.52
log file sync 12,010 0.00 10 1 0.25
row cache lock 13,684 0.01 8 1 0.28
SQL*Net more data from client 11,162 0.00 8 1 0.23
control file sequential read 35,207 0.00 8 0 0.73
SQL*Net break/reset to client 6,922 0.00 5 1 0.14
os thread startup 59 0.00 3 56 0.00
CGS wait for IPC msg 596,002 100.00 3 0 12.31
read by other session 1,296 0.00 2 2 0.03
enq: TT - contention 4,209 0.00 2 0 0.09
SQL*Net message to client 2,634,065 0.00 2 0 54.40
name-service call wait 27 0.00 2 59 0.00
gc current multi block request 903 0.00 1 1 0.02
DFS lock handle 3,445 0.00 1 0 0.07
control file parallel write 3,606 0.00 1 0 0.07
db file parallel read 473 0.00 1 3 0.01
cursor: pin S wait on X 119 100.00 1 10 0.00
gc cr block 2-way 2,395 0.00 1 0 0.05
enq: TO - contention 2,020 0.00 1 0 0.04
direct path read 3,557 0.00 1 0 0.07
SQL*Net more data to client 65,377 0.00 1 0 1.35
enq: CF - contention 1,292 0.00 1 1 0.03
latch: cache buffers chains 32,662 0.00 1 0 0.67
enq: TM - contention 1,001 0.00 1 1 0.02
IPC send completion sync 1,033 98.26 0 0 0.02
enq: TX - index contention 35 0.00 0 9 0.00
gc current block busy 25 0.00 0 11 0.00
gcs log flush sync 409 2.69 0 1 0.01
ksxr poll remote instances 37,930 62.28 0 0 0.78
reliable message 272 0.00 0 1 0.01
log file switch completion 9 0.00 0 18 0.00
PX Deq: reap credit 11,591 95.62 0 0 0.24
latch free 15 0.00 0 5 0.00
PX Deq Credit: send blkd 625 10.72 0 0 0.01
direct path write 615 0.00 0 0 0.01
enq: HW - contention 166 0.00 0 0 0.00
library cache pin 151 0.00 0 0 0.00
enq: JQ - contention 63 0.00 0 1 0.00
enq: FB - contention 128 0.00 0 0 0.00
latch: shared pool 3 0.00 0 14 0.00
enq: SQ - contention 47 0.00 0 1 0.00
rdbms ipc reply 149 0.00 0 0 0.00
gc cr block busy 16 0.00 0 1 0.00
enq: TA - contention 31 0.00 0 0 0.00
global enqueue expand wait 1 100.00 0 10 0.00
buffer busy waits 363 0.00 0 0 0.01
enq: US - contention 13 0.00 0 0 0.00
latch: KCL gc element parent latch 425 0.00 0 0 0.01
undo segment extension 2,666 99.85 0 0 0.06
log file single write 24 0.00 0 0 0.00
enq: WF - contention 11 0.00 0 0 0.00
enq: PI - contention 11 0.00 0 0 0.00
LGWR wait for redo copy 153 0.00 0 0 0.00
latch: session allocation 12 0.00 0 0 0.00
wait for scn ack 3 0.00 0 1 0.00
cursor: pin S 371 0.00 0 0 0.01
KJC: Wait for msg sends to complete 46 0.00 0 0 0.00
enq: WL - contention 3 0.00 0 0 0.00
enq: WR - contention 3 0.00 0 0 0.00
enq: JD - contention 1 0.00 0 1 0.00
enq: AF - task serialization 1 0.00 0 0 0.00
enq: PW - flush prewarm buffers 1 0.00 0 0 0.00
latch: object queue header operation 17 0.00 0 0 0.00
latch: cache buffers lru chain 4 0.00 0 0 0.00
buffer deadlock 6 100.00 0 0 0.00
SQL*Net message to dblink 4 0.00 0 0 0.00
SQL*Net message from client 2,634,247 0.00 2,706,551 1027 54.40
gcs remote message 4,928,703 99.47 127,869 26 101.79
PX Idle Wait 4,257 91.21 9,735 2287 0.09
Streams AQ: qmn slave idle wait 387 0.00 7,077 18287 0.01
jobq slave wait 1,388 97.48 3,890 2803 0.03
Streams AQ: waiting for time management or cleanup tasks 328 72.26 3,615 11022 0.01
wait for unread message on broadcast channel 3,645 99.70 3,554 975 0.08
Streams AQ: waiting for messages in the queue 748 97.73 3,554 4751 0.02
EMON idle wait 728 100.00 3,554 4882 0.02
DIAG idle wait 18,187 0.00 3,553 195 0.38
ges remote message 163,683 90.62 3,543 22 3.38
Streams AQ: qmn coordinator idle wait 381 33.60 3,538 9287 0.01
LNS ASYNC end of log 356,765 100.00 3,489 10 7.37
PX Deq: Execution Msg 2,111 34.39 1,719 814 0.04
PX Deq: Parse Reply 53 41.51 28 525 0.00
PX Deq: Execute Reply 53 33.96 25 466 0.00
PX Deq: Join ACK 48 37.50 17 348 0.00
PX Deq: Msg Fragment 934 48.50 0 0 0.02
class slave wait 2 0.00 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 381 99.74 0 0 0.01
SQL*Net message from dblink 4 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
LNS wait on SENDREQ 393 0.00 38 98 0.01
db file parallel write 159,395 0.00 38 0 3.29
events in waitclass Other 640,694 96.80 34 0 13.23
log file sequential read 24,301 0.00 14 1 0.50
Log archive I/O 3,705 0.00 13 3 0.08
log file parallel write 25,313 0.00 10 0 0.52
control file sequential read 22,553 0.00 5 0 0.47
os thread startup 59 0.00 3 56 0.00
control file parallel write 3,606 0.00 1 0 0.07
enq: TM - contention 1,000 0.00 0 0 0.02
row cache lock 403 0.00 0 1 0.01
gc current block 2-way 295 0.00 0 0 0.01
gc cr block 2-way 281 0.00 0 0 0.01
gc cr multi block request 387 0.00 0 0 0.01
gc current grant busy 52 0.00 0 0 0.00
library cache lock 22 0.00 0 0 0.00
log file single write 24 0.00 0 0 0.00
buffer busy waits 17 0.00 0 0 0.00
direct path read 756 0.00 0 0 0.02
direct path write 156 0.00 0 0 0.00
latch: cache buffers chains 7 0.00 0 0 0.00
gcs remote message 4,928,686 99.47 127,869 26 101.79
rdbms ipc message 188,070 39.39 77,339 411 3.88
Streams AQ: qmn slave idle wait 387 0.00 7,077 18287 0.01
Streams AQ: waiting for time management or cleanup tasks 328 72.26 3,615 11022 0.01
EMON idle wait 728 100.00 3,554 4882 0.02
DIAG idle wait 18,186 0.00 3,553 195 0.38
pmon timer 1,266 100.00 3,548 2802 0.03
ges remote message 163,676 90.62 3,543 22 3.38
smon timer 40,597 1.81 3,539 87 0.84
Streams AQ: qmn coordinator idle wait 381 33.60 3,538 9287 0.01
LNS ASYNC end of log 356,763 100.00 3,489 10 7.37
PX Deq: Execute Reply 35 34.29 12 356 0.00
PX Deq: Parse Reply 31 38.71 12 394 0.00
PX Deq: Join ACK 30 40.00 8 274 0.00
Streams AQ: RAC qmn coordinator idle wait 381 99.74 0 0 0.01

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 14,754.00 6,263.30 2,947,038 579,421,218
cdld 359.90 192.10 201,527 32,961,449
SYS$BACKGROUND 0.00 0.00 1,898 2,860,500

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 2254101 484791 81631 12946 0 0 2564082 507
cdld 201492 4678 950 38 0 0 93413 37
SYS$BACKGROUND 2578 504 646 355 0 0 393 3843

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
3,553 1,379 0   23.54 2ma2h79ga40xt   begin pkg_P_peddleryBankPlan.p...
3,553 1,379 0   23.54 9n4t5dggv4xmf   DECLARE job BINARY_INTEGER := ...
2,817 1,790 5,722 0.49 18.67 2f1ysgumu2xm8 PL/SQL Developer INSERT INTO YH00_2013_SF SELEC...
1,617 1,025 1 1616.90 10.71 dq98rpyapp1yc PL/SQL Developer -- Created on 2014/1/16 by ADM...
1,201 765 0   7.96 ctjd4zjkwtzd4 PL/SQL Developer -- Created on 2014/1/16 by ADM...
1,006 60 1 1006.08 6.67 6crbwr2shryb3   select * from (select rownum a...
924 177 1,154 0.80 6.12 ch3fs7uy0cfsv   BEGIN pkg_W_comm.prc_w_main(:1...
735 472 343 2.14 4.87 9v53122v2dxza JDBC Thin Client select distinct (to_ch...
611 404 10 61.12 4.05 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
513 325 62,510 0.01 3.40 a6ws36ztq6vhq   SELECT COUNT(1) FROM CC72 A, ...
471 301 635 0.74 3.12 fpqbpgdtsnja5   BEGIN pkg_W_comm.prc_w_Query(:...
423 44 1 423.35 2.81 7c1cdxyfn9swm w3wp.exe SELECT COUNT(AAC001) FROM AC05...
350 211 28,489 0.01 2.32 1zvcgsyrftw4u JDBC Thin Client SELECT FB02.AAC003 AS NAME FRO...
346 211 28,489 0.01 2.29 2hwxauy2yymjv JDBC Thin Client SELECT FB02.AAC003 AS NAME FRO...
296 143 60,043 0.00 1.96 ccpmr9nudzx7b   INSERT INTO KC03K1 (YAE202, A...
275 76 4 68.84 1.82 6u5f6dt4trq06   BEGIN pkg_K_Collection.prc_k_b...
268 72 51,029 0.01 1.77 47p05fubd216g   INSERT INTO IC01I1 (YAE202, A...
257 138 40 6.43 1.70 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
229 6 1 229.15 1.52 52x66tcbs0stj   SELECT a.akc190 as akc190, ...
222 38 2 111.19 1.47 d2w9gjm7910xx   SELECT A.YAC097 AS YAC097, A....
214 19 1 213.89 1.42 9081zsd94527r PL/SQL Developer DECLARE prm_AppCode ...
211 40 4 52.80 1.40 9p37wqnbx1a4u   SELECT COUNT(A.AAC001) FROM KC...
203 138 60,041 0.00 1.35 5xwdpy53fdjmm   INSERT INTO KC82K1(YAE202, YA...
202 120 228,938 0.00 1.34 4rrwchuurt68x   UPDATE AC02 SET YAE097 = :B1 W...
202 128 343 0.59 1.34 92t1nzy8gmbrn w3wp.exe select to_char(null), ac.owne...
197 5 943 0.21 1.30 3sjvc03k2z840   SELECT COUNT(1) FROM AB08 WHER...
184 71 3 61.48 1.22 bhv23unz01vax   BEGIN pkg_K_TJ.prc_k_TJ5(:1, :...
184 71 33 5.59 1.22 ccn5kk65rqfhm   SELECT B.YKC265 AS RYLB, B.YKC...
181 179 235,982 0.00 1.20 7d5h537jmdhw0 JDBC Thin Client SELECT YAC210 FROM AC01 WHERE ...
178 178 211,576 0.00 1.18 4uvbrkasjxnp8   SELECT COUNT(1) FROM AA94 WHER...
172 172 238,822 0.00 1.14 0dapqb9f2k6m4 JDBC Thin Client SELECT SEQ_A_YAE202.NEXTVAL FR...
162 162 229,137 0.00 1.07 a19wv2w1wv1y4   SELECT NVL(AAA041, 0), NVL(YA...
160 160 228,941 0.00 1.06 70qydyj0zh0xy   SELECT NVL(YAC053, 0) FROM AA...

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
1,790 2,817 5,722 0.31 18.67 2f1ysgumu2xm8 PL/SQL Developer INSERT INTO YH00_2013_SF SELEC...
1,379 3,553 0   23.54 2ma2h79ga40xt   begin pkg_P_peddleryBankPlan.p...
1,379 3,553 0   23.54 9n4t5dggv4xmf   DECLARE job BINARY_INTEGER := ...
1,025 1,617 1 1025.05 10.71 dq98rpyapp1yc PL/SQL Developer -- Created on 2014/1/16 by ADM...
765 1,201 0   7.96 ctjd4zjkwtzd4 PL/SQL Developer -- Created on 2014/1/16 by ADM...
472 735 343 1.38 4.87 9v53122v2dxza JDBC Thin Client select distinct (to_ch...
404 611 10 40.43 4.05 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
325 513 62,510 0.01 3.40 a6ws36ztq6vhq   SELECT COUNT(1) FROM CC72 A, ...
301 471 635 0.47 3.12 fpqbpgdtsnja5   BEGIN pkg_W_comm.prc_w_Query(:...
211 346 28,489 0.01 2.29 2hwxauy2yymjv JDBC Thin Client SELECT FB02.AAC003 AS NAME FRO...
211 350 28,489 0.01 2.32 1zvcgsyrftw4u JDBC Thin Client SELECT FB02.AAC003 AS NAME FRO...
179 181 235,982 0.00 1.20 7d5h537jmdhw0 JDBC Thin Client SELECT YAC210 FROM AC01 WHERE ...
178 178 211,576 0.00 1.18 4uvbrkasjxnp8   SELECT COUNT(1) FROM AA94 WHER...
177 924 1,154 0.15 6.12 ch3fs7uy0cfsv   BEGIN pkg_W_comm.prc_w_main(:1...
172 172 238,822 0.00 1.14 0dapqb9f2k6m4 JDBC Thin Client SELECT SEQ_A_YAE202.NEXTVAL FR...
162 162 229,137 0.00 1.07 a19wv2w1wv1y4   SELECT NVL(AAA041, 0), NVL(YA...
160 160 228,941 0.00 1.06 70qydyj0zh0xy   SELECT NVL(YAC053, 0) FROM AA...
143 296 60,043 0.00 1.96 ccpmr9nudzx7b   INSERT INTO KC03K1 (YAE202, A...
138 257 40 3.46 1.70 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
138 203 60,041 0.00 1.35 5xwdpy53fdjmm   INSERT INTO KC82K1(YAE202, YA...
128 202 343 0.37 1.34 92t1nzy8gmbrn w3wp.exe select to_char(null), ac.owne...
120 202 228,938 0.00 1.34 4rrwchuurt68x   UPDATE AC02 SET YAE097 = :B1 W...
76 275 4 19.08 1.82 6u5f6dt4trq06   BEGIN pkg_K_Collection.prc_k_b...
72 268 51,029 0.00 1.77 47p05fubd216g   INSERT INTO IC01I1 (YAE202, A...
71 184 3 23.60 1.22 bhv23unz01vax   BEGIN pkg_K_TJ.prc_k_TJ5(:1, :...
71 184 33 2.14 1.22 ccn5kk65rqfhm   SELECT B.YKC265 AS RYLB, B.YKC...
60 1,006 1 60.10 6.67 6crbwr2shryb3   select * from (select rownum a...
44 423 1 44.04 2.81 7c1cdxyfn9swm w3wp.exe SELECT COUNT(AAC001) FROM AC05...
40 211 4 10.06 1.40 9p37wqnbx1a4u   SELECT COUNT(A.AAC001) FROM KC...
38 222 2 19.22 1.47 d2w9gjm7910xx   SELECT A.YAC097 AS YAC097, A....
19 214 1 19.29 1.42 9081zsd94527r PL/SQL Developer DECLARE prm_AppCode ...
6 229 1 5.54 1.52 52x66tcbs0stj   SELECT a.akc190 as akc190, ...
5 197 943 0.00 1.30 3sjvc03k2z840   SELECT COUNT(1) FROM AB08 WHER...

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
162,203,827 5,722 28,347.40 26.43 1790.04 2816.81 2f1ysgumu2xm8 PL/SQL Developer INSERT INTO YH00_2013_SF SELEC...
93,393,738 1 93,393,738.00 15.22 1025.05 1616.90 dq98rpyapp1yc PL/SQL Developer -- Created on 2014/1/16 by ADM...
74,926,099 343 218,443.44 12.21 472.08 734.58 9v53122v2dxza JDBC Thin Client select distinct (to_ch...
68,750,136 0   11.20 765.42 1200.75 ctjd4zjkwtzd4 PL/SQL Developer -- Created on 2014/1/16 by ADM...
65,170,094 10 6,517,009.40 10.62 404.33 611.19 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
55,295,524 343 161,211.44 9.01 128.42 202.24 92t1nzy8gmbrn w3wp.exe select to_char(null), ac.owne...
54,876,530 62,510 877.88 8.94 325.19 512.83 a6ws36ztq6vhq   SELECT COUNT(1) FROM CC72 A, ...
37,980,554 0   6.19 1378.98 3552.68 2ma2h79ga40xt   begin pkg_P_peddleryBankPlan.p...
37,980,554 0   6.19 1378.98 3552.68 9n4t5dggv4xmf   DECLARE job BINARY_INTEGER := ...
35,980,351 28,489 1,262.96 5.86 210.83 350.34 1zvcgsyrftw4u JDBC Thin Client SELECT FB02.AAC003 AS NAME FRO...
35,980,351 28,489 1,262.96 5.86 211.46 345.71 2hwxauy2yymjv JDBC Thin Client SELECT FB02.AAC003 AS NAME FRO...
30,517,235 635 48,058.64 4.97 300.55 470.59 fpqbpgdtsnja5   BEGIN pkg_W_comm.prc_w_Query(:...
28,246,881 40 706,172.03 4.60 138.48 257.17 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
28,227,188 134 210,650.66 4.60 52.84 82.76 87zh2fkrfr7sk w3wp.exe select null, co.owner, co.ta...
11,254,015 1,154 9,752.18 1.83 176.69 924.21 ch3fs7uy0cfsv   BEGIN pkg_W_comm.prc_w_main(:1...
9,156,385 118 77,596.48 1.49 79.65 123.99 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
629,953 0   20.06 1378.98 3552.68 2ma2h79ga40xt   begin pkg_P_peddleryBankPlan.p...
629,953 0   20.06 1378.98 3552.68 9n4t5dggv4xmf   DECLARE job BINARY_INTEGER := ...
589,986 1 589,986.00 18.78 60.10 1006.08 6crbwr2shryb3   select * from (select rownum a...
386,664 4 96,666.00 12.31 76.31 275.37 6u5f6dt4trq06   BEGIN pkg_K_Collection.prc_k_b...
384,457 4 96,114.25 12.24 40.25 211.20 9p37wqnbx1a4u   SELECT COUNT(A.AAC001) FROM KC...
329,688 1 329,688.00 10.50 44.04 423.35 7c1cdxyfn9swm w3wp.exe SELECT COUNT(AAC001) FROM AC05...
296,180 2 148,090.00 9.43 38.44 222.39 d2w9gjm7910xx   SELECT A.YAC097 AS YAC097, A....
153,840 40 3,846.00 4.90 138.48 257.17 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
137,061 1 137,061.00 4.36 19.29 213.89 9081zsd94527r PL/SQL Developer DECLARE prm_AppCode ...
123,433 1,154 106.96 3.93 176.69 924.21 ch3fs7uy0cfsv   BEGIN pkg_W_comm.prc_w_main(:1...
82,526 5,722 14.42 2.63 1790.04 2816.81 2f1ysgumu2xm8 PL/SQL Developer INSERT INTO YH00_2013_SF SELEC...
55,492 51,029 1.09 1.77 72.50 267.66 47p05fubd216g   INSERT INTO IC01I1 (YAE202, A...
54,561 60,043 0.91 1.74 143.48 296.34 ccpmr9nudzx7b   INSERT INTO KC03K1 (YAE202, A...
51,659 1 51,659.00 1.64 5.54 229.15 52x66tcbs0stj   SELECT a.akc190 as akc190, ...
49,276 1 49,276.00 1.57 1025.05 1616.90 dq98rpyapp1yc PL/SQL Developer -- Created on 2014/1/16 by ADM...
39,524 943 41.91 1.26 4.59 196.66 3sjvc03k2z840   SELECT COUNT(1) FROM AB08 WHER...
34,594 3 11,531.33 1.10 70.79 184.43 bhv23unz01vax   BEGIN pkg_K_TJ.prc_k_TJ5(:1, :...
34,593 33 1,048.27 1.10 70.77 184.39 ccn5kk65rqfhm   SELECT B.YKC265 AS RYLB, B.YKC...
33,481 0   1.07 765.42 1200.75 ctjd4zjkwtzd4 PL/SQL Developer -- Created on 2014/1/16 by ADM...
31,732 60,041 0.53 1.01 137.67 203.00 5xwdpy53fdjmm   INSERT INTO KC82K1(YAE202, YA...

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
238,822 238,822 1.00 0.00 0.00 0dapqb9f2k6m4 JDBC Thin Client SELECT SEQ_A_YAE202.NEXTVAL FR...
235,982 235,982 1.00 0.00 0.00 7d5h537jmdhw0 JDBC Thin Client SELECT YAC210 FROM AC01 WHERE ...
229,137 229,137 1.00 0.00 0.00 a19wv2w1wv1y4   SELECT NVL(AAA041, 0), NVL(YA...
228,941 228,941 1.00 0.00 0.00 70qydyj0zh0xy   SELECT NVL(YAC053, 0) FROM AA...
228,940 228,940 1.00 0.00 0.00 bar9h6kn88kd4   SELECT YAC211 FROM AC02 WHERE ...
228,938 228,938 1.00 0.00 0.00 4rrwchuurt68x   UPDATE AC02 SET YAE097 = :B1 W...
211,576 211,576 1.00 0.00 0.00 4uvbrkasjxnp8   SELECT COUNT(1) FROM AA94 WHER...
196,194 196,177 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
120,564 120,564 1.00 0.00 0.00 80btdxayhrfra JDBC Thin Client SELECT NVL(TRUNC(MONTHS_BETWEE...
111,565 111,565 1.00 0.00 0.00 9t0jz72j6cvjt   SELECT AAC006, AAC008 FROM AC...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
196,204 196,194 27.55 2ym6hhaq30r73   select type#, blocks, extents,...
77,487 238,822 10.88 0dapqb9f2k6m4 JDBC Thin Client SELECT SEQ_A_YAE202.NEXTVAL FR...
77,122 79,676 10.83 1vxrqxpuqswaz JDBC Thin Client SELECT SEQ_A_AAE076.NEXTVAL FR...
40,081 40,082 5.63 0h6b2sajwb74n   select privilege#, level from ...
13,411 13,412 1.88 0k8522rmdzg4k   select privilege# from sysauth...
13,177 13,177 1.85 gj2dg4jc2x3fq w3wp.exe select 99 / 100, 1 - to_numbe...
13,125 13,125 1.84 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
10,810 18,625 1.52 cfbd91skrtfhn   INSERT INTO tmp_ad04_m2 (aae07...
10,579 18,150 1.49 9t8hdsbdh5twh   INSERT INTO tmp_ad04_m2 (aae07...
9,350 15,125 1.31 26n1c5v5mdrwp   INSERT INTO tmp_ad04_m2 (aae07...
9,345 16,950 1.31 3ffm1jwvzzv2t   INSERT INTO tmp_ad04_m2 (aae07...
9,268 16,200 1.30 39dmujs4s995n   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
11,158,864 0 0.05 710mp6r3fujag emagent_SQL_rac_database select capture_name streams_...
9,277,253 108 0.04 9css6bw8u84yt   SELECT a.aaa100 as ...
7,235,819 4 0.03 46xx07rqq5tyk JDBC Thin Client SELECT a.aae017 as...
7,235,691 4 0.03 46xx07rqq5tyk JDBC Thin Client SELECT a.aae017 as...
4,678,287 1 0.02 d3vdgnnm2x4f7 PL/SQL Developer SELECT O.OBJECT_TYPE, O.OWNER...
4,415,298 230 0.02 8hzay2zw3yc4x JDBC Thin Client select aaa103 from cdsi2.aa10...
4,142,170 343 0.02 6r6g3vwg9p393 w3wp.exe select * from (select null tab...
3,972,260 0 0.02 26zpagbuyygf9 emagent@p780b (TNS V1-V3) /* OracleOEM */ S...
3,784,841 117 0.02 5b6yvng00bn76   SELECT t.* FROM(select aae07...
3,619,931 1 0.02 1v33gg31ky98t JDBC Thin Client SELECT a.aae017 as...
3,440,610 10 0.02 a0t34vhmbhpgp JDBC Thin Client SELECT aaa100 as co...
3,429,478 4 0.02 6chnq116xhjgr JDBC Thin Client select /*+ RESULT_CACHE */aaa1...
3,429,460 6 0.02 ap8yt8ftwz7hj JDBC Thin Client select /*+ RESULT_CACHE */aaa1...
3,428,865 10 0.02 83gbn49knry1z JDBC Thin Client select /*+ RESULT_CACHE */aaa1...
3,425,568 1 0.02 1f8xymkhnswkm JDBC Thin Client select /*+ RESULT_CACHE */aaa1...
3,425,431 1 0.02 7mwrcjvtw1tz6 JDBC Thin Client select /*+ RESULT_CACHE */aaa1...
3,373,917 0 0.02 5z6m72y6knsfr emagent_SQL_rac_database SELECT m.tablespace_name, m....
3,256,112 134 0.02 87zh2fkrfr7sk w3wp.exe select null, co.owner, co.ta...
3,139,693 54 0.01 5mw0ksn1paxn5   INSERT INTO tmp_ic04i5 ( ...
3,098,039 3 0.01 15pf0yqrmk8r0   SELECT t.* FROM(select aae07...
2,534,898 0 0.01 501kary3x38sj emagent_SQL_rac_database select r.apply_name apply_na...
2,376,440 22 0.01 039bagckh7xdh   SELECT count(aac001) ...
1,215,188 492 0.01 911y3badh7v5h JDBC Thin Client INSERT INTO AD04A1 (AAE076, A...
1,208,103 344 0.01 g5g0whrt4ngqt JDBC Thin Client SELECT 1 FROM USER_TAB_COLUMNS...
1,186,660 0 0.01 bhjxxwujr3ac3 perl@p780a (TNS V1-V3) SELECT distinct ast.name, mt...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
108 54 5mw0ksn1paxn5   INSERT INTO tmp_ic04i5 ( ...
60 15 1mjd9xp80vuqa   select node, owner, name from ...
43 492 911y3badh7v5h JDBC Thin Client INSERT INTO AD04A1 (AAE076, A...
42 0 710mp6r3fujag emagent_SQL_rac_database select capture_name streams_...
42 31 fnj6cnubp1sau PL/SQL Developer begin if :enable = 0 then ...
41 24 367s0wrh1dbmv JDBC Thin Client BEGIN PKG_C_WORKFLOW.PRC_COMPL...
30 0 bkbp21n9f0p4z perl@p780a (TNS V1-V3) SELECT s.name, s.inst_id, i...
29 5,256 0z45hcav2cpnj   select yab275 from AD53...
29 5,256 0z45hcav2cpnj   select yab275 from AD53...
29 3 dccm4dw93qy3b plsqldev.exe begin sys.dbms_application_inf...
28 0 26zpagbuyygf9 emagent@p780b (TNS V1-V3) /* OracleOEM */ S...
28 0 5z6m72y6knsfr emagent_SQL_rac_database SELECT m.tablespace_name, m....
28 0 bhjxxwujr3ac3 perl@p780a (TNS V1-V3) SELECT distinct ast.name, mt...
25 14 8zjmhqrtjgpwk JDBC Thin Client SELECT COUNT(*) FROM KC82K1 WH...
25 1 9c2z7xkx0n7t8 JDBC Thin Client INSERT INTO AA82 (AAE820, AAA...
25 344 g5g0whrt4ngqt JDBC Thin Client SELECT 1 FROM USER_TAB_COLUMNS...
25 344 g5g0whrt4ngqt JDBC Thin Client SELECT 1 FROM USER_TAB_COLUMNS...
24 15 dbffgzt7bkp1s JDBC Thin Client SELECT COUNT(1) FROM AD53A4 A,...
21 335 2gy6aw7w4v301   SELECT yae092, aae036, aae100,...
21 8 bqfx5q2jas08u emagent@p780a (TNS V1-V3) SELECT TASK_LIST.TASK_ID FROM ...
21 8 bqfx5q2jas08u emagent@p780a (TNS V1-V3) SELECT TASK_LIST.TASK_ID FROM ...
21 360 c3hhngpbpvvmk SEVERITY EVALUATION SELECT MARKER_TIMESTAMP FROM M...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
157.77 4.44 3,552.68 1,378.98 0 2ma2h79ga40xt   begin pkg_P_peddleryBankPlan.p...
157.77 4.44 3,552.68 1,378.98 0 9n4t5dggv4xmf   DECLARE job BINARY_INTEGER := ...
84.90 20.05 423.35 44.04 1 7c1cdxyfn9swm w3wp.exe SELECT COUNT(AAC001) FROM AC05...
83.16 41.11 202.26 120.38 228,938 4rrwchuurt68x   UPDATE AC02 SET YAE097 = :B1 W...
79.72 7.92 1,006.08 60.10 1 6crbwr2shryb3   select * from (select rownum a...
37.66 13.68 275.37 76.31 4 6u5f6dt4trq06   BEGIN pkg_K_Collection.prc_k_b...
37.11 17.57 211.20 40.25 4 9p37wqnbx1a4u   SELECT COUNT(A.AAC001) FROM KC...
25.54 11.49 222.39 38.44 2 d2w9gjm7910xx   SELECT A.YAC097 AS YAC097, A....
22.58 45.60 49.50 14.32 10 a0t34vhmbhpgp JDBC Thin Client SELECT aaa100 as co...
20.70 8.05 257.17 138.48 40 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
18.14 8.48 213.89 19.29 1 9081zsd94527r PL/SQL Developer DECLARE prm_AppCode ...
18.05 1.95 924.21 176.69 1,154 ch3fs7uy0cfsv   BEGIN pkg_W_comm.prc_w_main(:1...
13.25 0.47 2,816.81 1,790.04 5,722 2f1ysgumu2xm8 PL/SQL Developer INSERT INTO YH00_2013_SF SELEC...
8.06 3.01 267.66 72.50 51,029 47p05fubd216g   INSERT INTO IC01I1 (YAE202, A...
8.04 0.50 1,616.90 1,025.05 1 dq98rpyapp1yc PL/SQL Developer -- Created on 2014/1/16 by ADM...
7.91 2.67 296.34 143.48 60,043 ccpmr9nudzx7b   INSERT INTO KC03K1 (YAE202, A...
7.04 3.07 229.15 5.54 1 52x66tcbs0stj   SELECT a.akc190 as akc190, ...
5.42 2.76 196.66 4.59 943 3sjvc03k2z840   SELECT COUNT(1) FROM AB08 WHER...
5.23 0.44 1,200.75 765.42 0 ctjd4zjkwtzd4 PL/SQL Developer -- Created on 2014/1/16 by ADM...
4.79 2.36 203.00 137.67 60,041 5xwdpy53fdjmm   INSERT INTO KC82K1(YAE202, YA...
4.77 4.12 115.77 76.27 51,029 4j5a3qp38kwnk   INSERT INTO AC17 (YAC097, AAB...
4.37 2.37 184.43 70.79 3 bhv23unz01vax   BEGIN pkg_K_TJ.prc_k_TJ5(:1, :...
4.37 2.37 184.39 70.77 33 ccn5kk65rqfhm   SELECT B.YKC265 AS RYLB, B.YKC...
3.16 2.26 139.77 95.21 60,041 54hyvw3wggzx7   INSERT INTO KC82K2(YAE202, AA...
2.79 3.58 77.85 72.76 228,940 bar9h6kn88kd4   SELECT YAC211 FROM AC02 WHERE ...
2.52 2.22 113.61 90.49 60,044 fc7x0k5thtyds   INSERT INTO KC03K2 (YAE202, A...
1.58 0.87 181.13 178.81 235,982 7d5h537jmdhw0 JDBC Thin Client SELECT YAC210 FROM AC01 WHERE ...
0.34 0.07 470.59 300.55 635 fpqbpgdtsnja5   BEGIN pkg_W_comm.prc_w_Query(:...
0.22 2.59 8.30 0.28 117 5b6yvng00bn76   SELECT t.* FROM(select aae07...
0.16 3.80 4.09 4.08 13,125 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
0.15 2.39 6.29 1.79 492 911y3badh7v5h JDBC Thin Client INSERT INTO AD04A1 (AAE076, A...
0.12 0.10 123.99 79.65 118 5j31x1u543s8t   insert into tmp_we01(yae051, ...
0.12 0.07 172.33 172.33 238,822 0dapqb9f2k6m4 JDBC Thin Client SELECT SEQ_A_YAE202.NEXTVAL FR...
0.09 75.30 0.12 0.12 360 c3hhngpbpvvmk SEVERITY EVALUATION SELECT MARKER_TIMESTAMP FROM M...
0.05 9.12 0.56 0.56 3,685 3c1kubcdjnppq   update sys.col_usage$ set eq...
0.04 0.01 611.19 404.33 10 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
0.03 7.97 0.34 0.34 3,587 grwydz59pu6mc   select text from view$ where r...
0.02 2.22 0.96 0.66 345 1xxggx2zbgwkd JDBC Thin Client INSERT INTO AD04 (AAE060, AAE...
0.01 6.68 0.20 0.20 1,382 g00cj285jmgsw   update sys.mon_mods$ set inser...
0.01 4.94 0.25 0.07 24 367s0wrh1dbmv JDBC Thin Client BEGIN PKG_C_WORKFLOW.PRC_COMPL...
0.01 0.01 82.76 52.84 134 87zh2fkrfr7sk w3wp.exe select null, co.owner, co.ta...
0.01 0.01 79.40 79.40 111,565 9t0jz72j6cvjt   SELECT AAC006, AAC008 FROM AC...
0.01 0.11 7.88 7.88 196,194 2ym6hhaq30r73   select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
039bagckh7xdh SELECT count(aac001) from (SELECT a.aac001 as aac001 FROM ic01i2 a, ad04a1 b WHERE a.aac001 = :1 AND a.aae076 = b.aae076 AND a.aae143 in ('2', '3') AND b.yaa012 = '2' AND b.yaa011 = '2' AND b.yad060 not in ('P08', 'P09', 'P45', 'P47', 'P48', 'P51') AND a.aae002 > :2 AND a.yab003 = :3 UNION SELECT a.aac001 as aac001 FROM jc01j2 a, ad04a1 b WHERE a.aac001 = :4 AND a.aae076 = b.aae076 AND a.aae143 in ('2', '3') AND b.yaa012 = '2' AND b.yaa011 = '2' AND b.yad060 not in ('P08', 'P09', 'P45', 'P47', 'P48', 'P51') AND a.aae002 > :5 AND a.yab003 = :6 UNION SELECT a.aac001 as aac001 FROM kc03k2 a, ad04a1 b WHERE a.aac001 = :7 AND a.aae076 = b.aae076 AND a.aae143 in ('2', '3', '4') AND b.yaa012 = '2' AND b.yaa011 = '2' AND b.yad060 not in ('P08', 'P09', 'P45', 'P47', 'P48', 'P51') AND a.aae002 > :8 AND a.yab003 = :9 UNION SELECT a.aac001 as aac001 FROM lc10l2 a, ad04a1 b WHERE a.aac001 = :10 AND a.aab001 = :11 AND a.aae076 = b.aae076 AND a.aae143 in ('2', '3', '4') AND b.yaa012 = '2' AND b.yaa011 = '2' AND b.yad060 not in ('P08', 'P09', 'P45', 'P47', 'P48', 'P51') AND a.aae002 > :12 AND a.yab003 = :13 UNION SELECT a.aac001 as aac001 FROM mc09m2 a, ad04a1 b WHERE a.aac001 = :14 AND a.aae076 = b.aae076 AND a.aae143 in ('2', '3', '4') AND b.yaa012 = '2' AND b.yaa011 = '2' AND b.yad060 not in ('P08', 'P09', 'P45', 'P47', 'P48', 'P51') AND a.aae002 > :15 AND a.yab003 = :16 UNION SELECT a.aac001 as aac001 FROM kc82k2 a, ad04a1 b WHERE a.aac001 = :17 AND a.aae076 = b.aae076 AND a.aae143 in ('2', '3', '4') AND a.aae001 IS NULL AND a.aab034 IS NULL AND b.yaa012 = '2' AND b.yaa011 = '2' AND b.yad060 not in ('P08', 'P09', 'P45', 'P47', 'P48', 'P51') AND a.aae002 > :18 AND a.yab003 = :19 UNION SELECT a.aac001 as aac001 FROM ic65i2 a, ad04a1 b WHERE a.aac001 = :20 AND a.aae076 = b.aae076 AND a.aae143 in ('2', '3') AND b.yaa012 = '2' AND b.yaa011 = '2' AND b.yad060 not in ('P08', 'P09', 'P45', 'P47', 'P48', 'P51') AND a.aae002 > :21 AND a.yab003 = :22 )
0dapqb9f2k6m4SELECT SEQ_A_YAE202.NEXTVAL FROM DUAL
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0z45hcav2cpnj select yab275 from AD53A4 where yae092 = :1
15pf0yqrmk8r0 SELECT t.* FROM(select aae076 , yad063 , yad064 , yad067, yad052 , yaa009, yad060 , sum(yaa007) as t_yaa007, SUM(yaa008) AS t_yaa008, trunc(yad009) as yad009, yaa011 , yaa012 , yad092, yaa014, aab191, CASE WHEN (SELECT COUNT(1) FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1) END yae205, aae011 , trunc(aae036) as aae036 from ad04a1 a where aad030='ab15a1' and yad063 = :1 AND yaa009 = :2 AND yad067 BETWEEN :3 AND :4 AND yab003 = :5 AND yad060 = :6 group by aae076, yad063, yad064, yad067, yad052, yaa009, yad060, trunc(yad009), yaa011, yaa012, yad092, yaa014, aab191, aae011, trunc(aae036) union all select aae076 , yad063 , yad064 , yad067, yad052 , yaa009, yad060 , sum(yaa007) as t_yaa007, SUM(yaa008) AS t_yaa008, trunc(yad009) as yad009, yaa011 , yaa012 , yad092, yaa014, aab191, CASE WHE N (SELECT COUNT(1) FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1) END yae205, aae011 , trunc(aae036) as aae036 from yh00_trans_ad04a1 a where aad030='ab15a1' and yad063 = :7 AND yaa009 = :8 AND yad067 BETWEEN :9 AND :10 AND yab003 = :11 AND yad060 = :12 group by aae076, yad063, yad064, yad067, yad052, yaa009, yad060, trunc(yad009), yaa011, yaa012, yad092, yaa014, aab191, aae011, trunc(aae036) ) t WHERE 1 =1
1f8xymkhnswkmselect /*+ RESULT_CACHE */aaa100, aaa102, aaa103, aae120 FROM cdsi2.aa10a1 WHERE aaa100 in ('YAC214', 'AAC004', 'AAC005', 'AAC009', 'AAC011', 'AAC021') order by aaa100, aaa102
1mjd9xp80vuqaselect node, owner, name from syn$ where obj#=:1
1v33gg31ky98t SELECT a.aae017 as aae017, a.yab110 as yab110, a.aae043_real as aae043_real, a.aae043 as aae043, a.acb200 as acb200, a.acb210 as acb210, a.aab004 as aab004, a.acb206 as acb206, a.aae005 as aae005, a.aca111 as aca111, a.aca112 as aca112, a.yca111 as yca111, a.acb21d as acb21d, a.acb21e as acb21e, a.acb21f as acb21f, a.personall as personall, a.aac011_real as aac011_real, a.aac011 as aac011, a.ycb212_real as ycb212_real, a.ycb212 as ycb212, a.acb21h_real as acb21h_real, a.acb21h as acb21h, a.acb217_real as acb217_real, a.acb217 as acb217, a.ycb21d_real as ycb21d_real, a.ycb21d as ycb21d, a.ycb213_real as ycb213_real, a.ycb213 as ycb213, a.ycb21c_real as ycb21c_real, a.ycb21c as ycb21c, a.age_min as age_min, a.age_max as age_max, a.age_between as age_between, a.ytjrs as ytjrs , a.ycgrs as ycgrs , a.yxkqs as yxkqs , a.yxjzrq_real as yxjzrq_real, a.yxjzrq as yxjzrq, a.jbsj_real as jbsj_real, a.jbsj as jbsj, a.xxlx_real as xxlx_real, a.xxl x as xxlx, a.aae005_d as aae005_d FROM cb20_viw a WHERE 1=1 AND TO_CHAR(jbsj_real, 'YYYY-MM-DD') <= '2014-01-16' AND aae017 like '510181'||'%' AND TO_CHAR(jbsj_real, 'YYYY-MM-DD') >= '2013-11-01'
1vxrqxpuqswazSELECT SEQ_A_AAE076.NEXTVAL FROM DUAL
1xxggx2zbgwkdINSERT INTO AD04 (AAE060, AAE076, AAE075, AAD030, YAD104, AAD031, AAD032, AAD033, AAE011, AAE036, YAB003) SELECT SEQ_A_AAE060.NEXTVAL, AAE076, AAE075, AAD030, YAD104, AAD031, DECODE(SIGN(AAD033), -1, DECODE(AAD032, :B1 , :B2 , :B1 ), AAD032), ABS(AAD033), AAE011, AAE036, YAB003 FROM TMP_AD04 WHERE NVL(AAD033, 0) <> 0
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
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
26zpagbuyygf9/* OracleOEM */ SELECT blocking_sid, num_blocked FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked FROM ( SELECT l.id1, l.id2, MAX(DECODE(l.block, 1, i.instance_name||'-'||l.sid, 2, i.instance_name||'-'||l.sid, 0 )) blocking_sid, SUM(DECODE(l.request, 0, 0, 1 )) num_blocked FROM gv$lock l, gv$instance i WHERE ( l.block!= 0 OR l.request > 0 ) AND l.inst_id = i.inst_id GROUP BY l.id1, l.id2) GROUP BY blocking_sid ORDER BY num_blocked DESC) WHERE num_blocked != 0 AND blocking_sid != '0'
2f1ysgumu2xm8INSERT INTO YH00_2013_SF SELECT A.YKB037, A.YKB010, A.AKA130, SUM(A.YKA055), SUM(A.YKA107), NVL((SELECT NVL(SUM(YKA074), 0) FROM KB17K1 WHERE YKB010 = A.YKB010), 0), SUM(A.YKA065) FROM YH00_KC24K2_2013_GY A WHERE YKB010 = :B1 GROUP BY A.YKB037, A.YKB010, A.AKA130
2gy6aw7w4v301SELECT yae092, aae036, aae100, yae361, yae362, yae363 FROM ad53a5 WHERE yae092 = :1
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
2ma2h79ga40xtbegin pkg_P_peddleryBankPlan.prc_P_BankPlanControl('???????', 201401, 100000000013132, '0000', 1000080, TO_DATE('20140116', 'yyyymmdd'), :prm_AppCode, :prm_errmsg) ; 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
367s0wrh1dbmvBEGIN PKG_C_WORKFLOW.PRC_COMPLETETASK(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); END;
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
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
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
3sjvc03k2z840SELECT COUNT(1) FROM AB08 WHERE AAB156 > '0' AND AAB001 = :B1
46xx07rqq5tyk SELECT a.aae017 as aae017, a.yab110 as yab110, a.aae043_real as aae043_real, a.aae043 as aae043, a.acb200 as acb200, a.acb210 as acb210, a.aab004 as aab004, a.acb206 as acb206, a.aae005 as aae005, a.aca111 as aca111, a.aca112 as aca112, a.yca111 as yca111, a.acb21d as acb21d, a.acb21e as acb21e, a.acb21f as acb21f, a.personall as personall, a.aac011_real as aac011_real, a.aac011 as aac011, a.ycb212_real as ycb212_real, a.ycb212 as ycb212, a.acb21h_real as acb21h_real, a.acb21h as acb21h, a.acb217_real as acb217_real, a.acb217 as acb217, a.ycb21d_real as ycb21d_real, a.ycb21d as ycb21d, a.ycb213_real as ycb213_real, a.ycb213 as ycb213, a.ycb21c_real as ycb21c_real, a.ycb21c as ycb21c, a.age_min as age_min, a.age_max as age_max, a.age_between as age_between, a.ytjrs as ytjrs , a.ycgrs as ycgrs , a.yxkqs as yxkqs , a.yxjzrq_real as yxjzrq_real, a.yxjzrq as yxjzrq, a.jbsj_real as jbsj_real, a.jbsj as jbsj, a.xxlx_real as xxlx_real, a.xxl x as xxlx, a.aae005_d as aae005_d FROM cb20_viw a WHERE 1=1 AND TO_CHAR(jbsj_real, 'YYYY-MM-DD') <= '2014-01-31' AND aae017 like '510184'||'%' AND TO_CHAR(jbsj_real, 'YYYY-MM-DD') >= '2013-11-01'
47p05fubd216gINSERT INTO IC01I1 (YAE202, AAB001, AAC001, AAE003, AAE002, YAE010, YAE203, AAE143, AAA041, YIC509, YAA017, AAA042, AAA043, AIC020, YIC486, YIC487, YIC488, YIC510, YIC224, YIC225, YIC226, AIC024, AIC025, AIC026, AIC027, YIC227, YIC228, YIC229, YAE206, AAE076, YAB003, AAE011, AAE036, YAC211, YAC210, YAC212 ) VALUES (:B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , 0, 0, :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , 0, 0, 0, 0, 0, 0, :B8 , NULL, :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
4bndapumf09zd SELECT /*+ NO_CPU_COSTING */ tsname, bsize total, used, bsize - used tsleft, useratio used_per, 100 - useratio free_per FROM (SELECT d.tablespace_name tsname, round(nvl(a.bytes / 1024 / 1024, 0), 2) bsize, round(nvl(a.bytes - nvl(f.bytes, 0), 0) / 1024 / 1024, 2) used, round(nvl((a.bytes - nvl(f.bytes, 0)) / a.bytes * 100, 0), 2) useratio FROM sys.dba_tablespaces d, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) a, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_free_space GROUP BY tablespace_name) f WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND NOT (d.extent_management LIKE 'LOCAL' AND d.contents LIKE 'TEMPORARY') UNION ALL SELECT d.tablespace_name tsname, round(nvl(a.bytes / 1024 / 1024, 0), 2) bsize, round(nvl(t.bytes, 0) / 1024 / 1024, 2) used, round(nvl(t.bytes / a.bytes * 100, 0), 2) useratio FROM sys.dba_tablespaces d, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_temp_files GROUP BY tablespace_name) a, (SELECT tablespace_name, SUM(bytes_cached) bytes FROM v$temp_extent_pool GROUP BY tablespace_name) t WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND d.extent_management LIKE 'LOCAL' AND d.contents LIKE 'TEMPORARY') x order by tsname
4j5a3qp38kwnkINSERT INTO AC17 (YAC097, AAB001, AAC001, AAE140, YAC101, AAE002, YAC105, AKC023, YAC004, AAA041, YAA017, YAC095, AKA042, AAC123, YAC008, YAC009, YAC014, YAC016, YAC017, YAC096, YKC176, AAC131, YAC099, YAC100, AAE076, YAC102, YAC052, AAE011, AAE036, YAB003, YAC202, YAC211, YAC210, YAC212 ) VALUES (:B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , NULL, :B24 , :B23 , :B22 , :B21 , :B20 , :B13 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , 0, :B3 , :B2 , :B1 )
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4rrwchuurt68xUPDATE AC02 SET YAE097 = :B1 WHERE AAC001 = :B3 AND AAE140 = :B2 AND (YAE097 < :B1 OR YAE097 IS NULL)
4uvbrkasjxnp8SELECT COUNT(1) FROM AA94 WHERE YAA309 = :B1 AND YAA308 = '546DJ'
501kary3x38sj select r.apply_name apply_name, total_messages_dequeued, total_messages_spilled from gv$streams_apply_reader r, dba_apply a, dba_queues q, dba_queue_tables t where r.apply_name = a.apply_name and a.queue_name = q.name and a.queue_owner = q.owner and q.queue_table = t.queue_table and q.owner=t.owner and r.inst_id = t.owner_instance
52x66tcbs0stj SELECT a.akc190 as akc190, a.yke149 as yke149, a.yka330 as yka330, a.aka130 as aka130, (select aae002 from kb03k9 where akc190 = a.akc190 and yka103 = a.yka103 and ykd007 = a.ykd007 and aka213 = b.aka213) as aae002 FROM kc24k1 a, kc24k2 b where a.akc190 = b.akc190 and a.yka103 = b.yka103 and a.ykd007 = b.ykd007 and b.yka032 = :1 and a.yke239 ='1' and b.ykb037 = :2 and 1 = (select count(distinct c.ykd007) from kc24k1 c where c.akc190 = b.akc190 and c.yka103 = b.yka103) AND ( a.ykc105 = :3 OR a.ykc105 = :4 ) AND a.akb020 = :5 AND b.akb020 = :6 AND b.aae036 >= :7 AND b.aae036 < :8
54hyvw3wggzx7INSERT INTO KC82K2(YAE202, AAE076, YKE586, YKC277, AAC008, YAE010, AAE143, AAC001, AAB001, YAB003, AKC021, AAB020, AAB019, AAE003, AAE002, AAA041, AAA042, AKC023, AKC010, YKC175, YKC071, YKC063, YKC064, YKC072, YKC073, AKC061, AKC062, YKC065, YKC066, YKC067, YKC068, YKC172, YAE206, AAE061, AAE001, YKE260, YKC265, YKC266, YKC276, AAB034, YAE424, YAC200, AAE011, AAE036, YAC211, YAC210, YAC212 ) VALUES(:B26 , :B25 , NULL, NULL, NULL, :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , 0, :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '01', '01', :B5 , :B4 , :B3 , :B2 , :B1 )
5b6yvng00bn76 SELECT t.* FROM(select aae076 , yad063 , yad064 , yad067, yad052 , yaa009, yad060 , sum(yaa007) as t_yaa007, SUM(yaa008) AS t_yaa008, trunc(yad009) as yad009, yaa011 , yaa012 , yad092, yaa014, aab191, CASE WHEN (SELECT COUNT(1) FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1) END yae205, aae011 , trunc(aae036) as aae036 from ad04a1 a where aad030='ab15a1' and yad063 = :1 AND yaa009 = :2 AND yad067 BETWEEN :3 AND :4 AND yab003 = :5 group by aae076, yad063, yad064, yad067, yad052, yaa009, yad060, trunc(yad009), yaa011, yaa012, yad092, yaa014, aab191, aae011, trunc(aae036) union all select aae076 , yad063 , yad064 , yad067, yad052 , yaa009, yad060 , sum(yaa007) as t_yaa007, SUM(yaa008) AS t_yaa008, trunc(yad009) as yad009, yaa011 , yaa012 , yad092, yaa014, aab191, CASE WHEN (SELECT COUNT(1) FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM ic01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM jc01 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc03 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM lc10 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM mc09 WHERE aae076=a.aae076 AND ROWNUM=1) WHEN (SELECT COUNT(1) FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1)>0 THEN (SELECT yae205 FROM kc82 WHERE aae076=a.aae076 AND ROWNUM=1) END yae205, aae011 , trunc(aae036) as aae036 from yh00_trans_ad04a1 a where aad030='ab15a1' and yad063 = :6 AND yaa009 = :7 AND yad067 BETWEEN :8 AND :9 AND yab003 = :10 group by aae076, yad063, yad064, yad067, yad052, yaa009, yad060, trunc(yad009), yaa011, yaa012, yad092, yaa014, aab191, aae011, trunc(aae036) ) t WHERE 1 =1
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"
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)
5xwdpy53fdjmmINSERT INTO KC82K1(YAE202, YAB003, AAB020, AAB001, AAE143, AAB019, AAC001, AKC021, AAC008, YAE010, AAE003, AAE002, AAA041, AAA042, AKC023, AKC010, YKC175, YKC071, YKC063, YKC064, YKC072, YKC073, AKC061, AKC062, YKC065, YKC066, YKC067, YKC068, YKC172, YAE206, AAE061, AAE076, YKE586, YKC277, AAE001, YKE260, YKC265, YKC266, YKC276, AAB034, YAE424, YAC200, AAE011, AAE036, YAC211, YAC210, YAC212 ) VALUES(:B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , NULL, :B18 , :B17 , :B16 , :B15 , 0, :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , 0, 0, 0, 0, 0, 0, 0, NULL, NULL, :B6 , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '01', '01', :B5 , :B4 , :B3 , :B2 , :B1 )
5z6m72y6knsfr SELECT m.tablespace_name, m.used_percent, (m.tablespace_size - m.used_space)*t.block_size/1024/1024 mb_free FROM dba_tablespace_usage_metrics m, dba_tablespaces t, v$parameter p WHERE p.name='statistics_level' and p.value!='BASIC' AND t.tablespace_name = m.tablespace_name
6chnq116xhjgrselect /*+ RESULT_CACHE */aaa100, aaa102, aaa103, aae120 FROM cdsi2.aa10a1 WHERE aaa100 in ('YAC210', 'AAC031', 'YAC033', 'YKC150') order by aaa100, aaa102
6crbwr2shryb3 select * from (select rownum as myrownum, c.* from ( SELECT a.aae076 as aae076, a.yaa009 as yaa009, a.yad052 as yad052, a.yad060 as yad060, sum(a.yaa007) as yaa007, trunc(a.yad009) as yad009, a.yaa011 as yaa011, a.yaa012 as yaa012, a.yad063 as yad063, a.yad064 as yad064 FROM ad04a1 a WHERE a.yaa012 NOT IN('2', '4') AND a.yaa011 NOT IN('3', '1') AND a.yab003 = :1 AND a.yad060 IN( 'P01', 'P02', 'P03', 'P04', 'P05', 'P06', 'P07', 'P10', 'P11', 'P12', 'P13', 'P14', 'P15', 'P16', 'P17', 'P18', 'P19', 'P20', 'P21', 'P22', 'P23', 'P24', 'P25', 'P26', 'P27', 'P28', 'P29', 'P30', 'P31', 'P32', 'P33', 'P34', 'P35', 'P36', 'P37', 'P38', 'P39', 'P43', 'P44', 'P45', 'P46', 'P50', 'P52', 'P55', 'P59' ) GROUP BY a.aae076, a.yaa009, a.yad052, a.yad060, trunc(a.yad009), a.yaa011, a.yaa012, a. yad063, a.yad064 ) c)where myrownum<=20 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"
6u5f6dt4trq06BEGIN pkg_K_Collection.prc_k_batchPayApply(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10); END;
70qydyj0zh0xySELECT NVL(YAC053, 0) FROM AA22 WHERE YAB003 = :B4 AND AAE140 = :B3 AND YAC105 = :B2 AND AAE041 <= :B1 AND (AAE042 >= :B1 OR AAE042 IS NULL)
710mp6r3fujag select capture_name streams_name, 'capture' streams_type , (available_message_create_time-capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select dba_propagation.propagation_name streams_name, 'propagation' streams_type, null streams_latency , total_msgs total_messages from gv$propagation_sender, dba_propagation where source_queue_owner=queue_schema and source_queue_name=queue_name and dblink='"'||destination_queue_owner ||'"' ||'.'||'"' ||destination_queue_name||'"@'||destination_dblink union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STREAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPL IED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT apply_name, state, lwm_time as apply_time, lwm_message_create_time as create_time FROM gv$streams_apply_coordinator ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name
7c1cdxyfn9swmSELECT COUNT(AAC001) FROM AC05 where yab003=:"SYS_B_0" and aac050=:"SYS_B_1" and aae140=:"SYS_B_2" and to_char(aae036, :"SYS_B_3")>=:"SYS_B_4" and to_char(aae036, :"SYS_B_5")<=:"SYS_B_6" and aac001 in (select aac001 from ac02 where yab003=:"SYS_B_7" and aac031=:"SYS_B_8" and aae140=:"SYS_B_9")
7d5h537jmdhw0SELECT YAC210 FROM AC01 WHERE AAC001 = :B1
7mwrcjvtw1tz6select /*+ RESULT_CACHE */aaa100, aaa102, aaa103, aae120 FROM cdsi2.aa10a1 WHERE aaa100 in ('AAC004', 'AAC005', 'AAC008', 'AAC009', 'YAC214') order by aaa100, aaa102
80btdxayhrfraSELECT NVL(TRUNC(MONTHS_BETWEEN(:B2 , :B1 )/12), 0) FROM DUAL
83gbn49knry1zselect /*+ RESULT_CACHE */aaa100, aaa102, aaa103, aae120 FROM cdsi2.aa10a1 WHERE aaa100 in ('AAC004', 'YKC156', 'AAC005', 'AAC008', 'AAC009', 'YAC214', 'YAD050') order by aaa100, aaa102
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
8zjmhqrtjgpwkSELECT COUNT(*) FROM KC82K1 WHERE AAC001 = :B2 AND AAE002 = :B1
9081zsd94527r DECLARE prm_AppCode VARCHAR2(200); prm_ErrMsg VARCHAR2(2000); var_yab003 VARCHAR2(4); prm_tkze NUMBER(14, 2); --???????????????? CURSOR cur_ac02 IS SELECT aab001, aac001, yab003 FROM ac02 WHERE EXISTS (SELECT aac001 FROM kc01 WHERE EXISTS (SELECT aac001 FROM ac01a2 WHERE yac050 in ('44', '45') AND aac001 = kc01.aac001) AND akc021 = '21' AND aac001 = ac02.aac001) AND aae140 ='41' AND EXISTS(select 1 from kc82 where aac001 = ac02.aac001 and aae002>=201312) ORDER BY aab001, aac001, yab003; BEGIN prm_AppCode := pkg_comm.gn_def_ok; prm_ErrMsg := ''; prm_tkze := 0; FOR rec_index IN cur_ac02 LOOP pkg_P_returnContribution.prc_P_returnContribution (pkg_comm.fun_GetSequence(NULL, 'aae061'), --????? '4' , --???? rec_index.aac001, --???? rec_index.aab001, --???? '41' , --???? 201312, --???? 201401 , --???? rec_index.yab003, --?????? '0' , --???????? '0' , --?????????? 8 9898 , --??? SYSDATE , --???? prm_tkze, --???? prm_AppCode , --???? prm_ErrMsg ); --???? IF prm_AppCode != pkg_comm.gn_def_OK THEN --????? ROLLBACK; GOTO label_continue; END IF; COMMIT; <<label_continue>> var_yab003 := ''; END LOOP; DBMS_OUTPUT.put_line('?????'||prm_ErrMsg); DBMS_OUTPUT.put_line('?????'||prm_AppCode); 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 )
92t1nzy8gmbrnselect to_char(null), ac.owner, ac.table_name, acc.column_name, acc.position, ac.constraint_name from all_constraints ac, all_cons_columns acc where ac.owner=acc.owner and ac.constraint_type=:"SYS_B_0" and ac.constraint_name=acc.constraint_name and ac.owner like :"SYS_B_1" escape :"SYS_B_2" and ac.table_name like :"SYS_B_3" escape :"SYS_B_4"
9c2z7xkx0n7t8INSERT INTO AA82 (AAE820, AAA801, AAE790, AAA821) VALUES (:B2 , 'CC02', :B1 , '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
9n4t5dggv4xmfDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin pkg_prc_control.prc_execprc_one('100000348398827') ; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
9p37wqnbx1a4uSELECT COUNT(A.AAC001) FROM KC82K1 A WHERE A.AAE001 = :B2 AND A.YKE260 = :B1 AND A.YAE424 = '03' AND A.AAE061 IS NULL AND A.YAE206 IS NULL AND A.AAE076 IS NULL AND A.YKE586 IS NOT NULL
9t0jz72j6cvjtSELECT AAC006, AAC008 FROM AC01 WHERE AAC001 = :B1
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
a0t34vhmbhpgp SELECT aaa100 as codeType, aaa102 as codeValue, aaa101 as codeTypeDESC, aaa103 as codeDESC, yab003 as orgId, aae120 as validFlag FROM aa10a1 ORDER BY aaa100, aaa102
a19wv2w1wv1y4SELECT NVL(AAA041, 0), NVL(YAA017, 0), NVL(AAA042, 0), NVL(AAA043, 0) FROM AA05 WHERE AAA040 = :B5 AND YAC211 = :B4 AND AAE041 <= :B1 AND YAB003 = :B3 AND AAE140 = :B2 AND (AAE042 >= :B1 OR AAE042 IS NULL)
a6ws36ztq6vhqSELECT COUNT(1) FROM CC72 A, CB8A B WHERE A.YCC720 = B.YCC720 AND B.YAE435 = 'Y' AND AAC001 IN (SELECT AAC001 FROM AC01 WHERE AAC002 = :B1 )
ap8yt8ftwz7hjselect /*+ RESULT_CACHE */aaa100, aaa102, aaa103, aae120 FROM cdsi2.aa10a1 WHERE aaa100 in ('YAC210', 'AAC031') order by aaa100, aaa102
bar9h6kn88kd4SELECT YAC211 FROM AC02 WHERE AAC001 = :B3 AND AAE140 = :B2 AND YAB003 = :B1
bhjxxwujr3ac3 SELECT distinct ast.name, mt.inst_id, TO_CHAR(CAST(mt.begin_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') begintime, TO_CHAR(CAST(mt.end_time AS TIMESTAMP) AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') endtime, mt.intsize_csec, mt.group_id, mt.cpupercall, mt.dbtimepercall, mt.callspersec, mt.dbtimepersec FROM gv$servicemetric_history mt , gv$active_services ast WHERE end_time >= SYSDATE - 5/(60*24) AND group_id = 6 AND mt.service_name = ast.name AND mt.inst_id = ast.inst_id ORDER BY ast.name, mt.inst_id asc, endtime DESC
bhv23unz01vaxBEGIN pkg_K_TJ.prc_k_TJ5(:1, :2, :3, :4, :5, :6, :7, :8, :9); END;
bkbp21n9f0p4z SELECT s.name, s.inst_id, i.instance_name FROM gv$active_services s, gv$instance i WHERE s.inst_id = i.inst_id ORDER BY s.name
bqfx5q2jas08uSELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (SELECT * FROM DBA_ADVISOR_TASKS ORDER BY TASK_ID DESC) T, DBA_ADVISOR_PARAMETERS_PROJ P1, DBA_ADVISOR_PARAMETERS_PROJ P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (SYSDATE - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = TO_CHAR(:B1 ) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1
c3hhngpbpvvmkSELECT MARKER_TIMESTAMP FROM MGMT_AVAILABILITY_MARKER WHERE TARGET_GUID = :B1
ccn5kk65rqfhm SELECT B.YKC265 AS RYLB, B.YKC346, SUM(B.SSRS) AS SSRS, SUM(B.WSSRS) AS WSSRS FROM (SELECT COUNT(DISTINCT A.AAC001) AS SSRS, DECODE(A.YKC265, NULL, DECODE(A.YAE424, '04', '05', '02', '06'), A.YKC265) AS YKC265, NULL AS WSSRS, NVL(A.YKC346, '01') AS YKC346 FROM KC82 A WHERE A.AAE001 = :B1 AND A.YAB003 = :B6 AND NVL(A.AAB034, '99') = (CASE WHEN :B5 ='99' THEN NVL(A.AAB034, '99') ELSE :B5 END) AND NVL(A.YKC265, '99') = (CASE WHEN :B4 = '01' THEN '01' WHEN :B4 = '02' THEN '02' WHEN :B4 = '03' THEN '03' WHEN :B4 = '04' THEN '04' ELSE NVL(A.YKC265, '99') END) AND TO_CHAR(A.AAE036, 'yyyy-mm-dd') >= TO_CHAR(:B3 , 'yyyy-mm-dd') AND TO_CHAR(A.AAE036, 'yyyy-mm-dd') <= TO_CHAR(:B2 , 'yyyy-mm-dd') AND (CASE WHEN :B1 IS NULL OR :B1 = -1 THEN NVL(:B1 , 0) ELSE A.AAE001 END) = NVL(:B1 , 0) GROUP BY A.YKC265, A.YAE424, A.YKC346 UNION ALL SELECT NULL AS SSRS, DECODE(A.YKC265, NULL, DECODE(A.YAE424, '04', '05', '02', '06'), A.YKC265) AS YKC265, COUNT(DISTINCT A.AAC001) AS WSSRS, NVL(A.YKC346, '01') AS YKC346 FROM KC82K1 A WHERE A.AAE001 = :B1 AND A.YAB003 = :B6 AND NVL(A.AAB034, '99') = (CASE WHEN :B5 ='99' THEN NVL(A.AAB034, '99') ELSE :B5 END) AND NVL(A.YKC265, '99') = (CASE WHEN :B4 = '01' THEN '01' WHEN :B4 = '02' THEN '02' WHEN :B4 = '03' THEN '03' WHEN :B4 = '04' THEN '04' ELSE NVL(A.YKC265, '99') END) AND TO_CHAR(A.AAE036, 'yyyy-mm-dd') >= TO_CHAR(:B3 , 'yyyy-mm-dd') AND TO_CHAR(A.AAE036, 'yyyy-mm-dd') <= TO_CHAR(:B2 , 'yyyy-mm-dd') AND (CASE WHEN :B1 IS NULL OR :B1 = -1 THEN NVL(:B1 , 0) ELSE A.AAE001 END) = NVL(:B1 , 0) GROUP BY A.YKC265, A.YAE424, A.YKC346) B GROUP BY B.YKC265, YKC346 ORDER BY B.YKC265
ccpmr9nudzx7bINSERT INTO KC03K1 (YAE202, AAB001, AAC001, AAE003, AAE002, AAE143, AAB019, AAB020, AKC021, AKC025, AKC023, AKC010, YAE010, YAE203, AAA041, AAA042, YAA028, YKC175, YKC071, YKC063, YKC064, YKC072, YKC073, AKC061, AKC062, YKC065, YKC066, YKC067, YKC068, YKC176, YKC172, YAE206, AAE061, AAE076, YAB003, AAE011, AAE036, YKC326, YKC327, YAA310, YAC211, YAC210, YAC212 ) VALUES (:B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , 0, :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , 0, 0, 0, 0, 0, 0, :B11 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , :B6 , :B5 , 0, :B4 , :B3 , :B2 , :B1 )
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;
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;
ctjd4zjkwtzd4-- Created on 2014/1/16 by ADMINISTRATOR declare cursor cur_ykb010 is select ykb010 from YH00_YKB010_2013_GY a WHERE not exists (select 1 from yh00_2013_sf where ykb010 = a.ykb010); begin for cur1 in cur_ykb010 loop insert into yh00_2013_sf select a.ykb037, a.ykb010, a.aka130, sum(a.yka055), sum(a.yka107), nvl((select nvl(sum(yka074), 0) from kb17k1 where ykb010 = a.ykb010), 0), sum(a.yka065) from yh00_kc24k2_2013_gy a where ykb010 = cur1.ykb010 group by a.ykb037, a.ykb010, a.aka130; commit; end loop; end;
d2w9gjm7910xxSELECT A.YAC097 AS YAC097, A.AAC001 AS AAC001, A.AAE140 AS AAE140, A.AAA040 AS AAA040, A.YAC099 AS YAC099, A.YAC100 AS YAC100, A.YAC105 AS YAC105, A.YAC098 AS YAC098, (CASE WHEN B.YAE097 IS NULL THEN A.YAC098 WHEN TO_NUMBER(TO_CHAR(ADD_MONTHS(TO_DATE(TO_CHAR(B.YAE097), 'YYYYMM'), 1), 'YYYYMM')) >= A.YAC098 THEN TO_NUMBER(TO_CHAR(ADD_MONTHS(TO_DATE(TO_CHAR(B.YAE097), 'YYYYMM'), 1), 'YYYYMM')) ELSE A.YAC098 END) AS BCQKKSQH FROM AC16 A, AC02 B WHERE A.AAB001 = :B7 AND A.YAC107 = :B6 AND A.YAE244 = :B5 AND A.YAC098 <= :B1 AND LOWER(SUBSTR(A.YAC097, 1, 1)) = LOWER(:B4 ) AND A.AAC001 = B.AAC001 AND A.AAE140 = B.AAE140 AND B.YAB003 = :B3 AND B.AAC031 = :B2 AND (B.YAE097 IS NULL OR B.YAE097 < :B1 ) ORDER BY A.AAC001, A.AAE140
d3vdgnnm2x4f7SELECT O.OBJECT_TYPE, O.OWNER, O.OBJECT_NAME FROM SYS.ALL_OBJECTS O WHERE O.OWNER = :B2 AND O.OBJECT_NAME = :B1 AND OBJECT_TYPE IN ('MATERIALIZED VIEW', 'TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') AND ROWNUM = 1
dbffgzt7bkp1sSELECT COUNT(1) FROM AD53A4 A, YHCIP_WD01 B WHERE A.YAE092 = B.YAE092 AND B.YWE004 ='2' AND B.YWE005 = :B1 AND A.AAE100 ='1'
dccm4dw93qy3bbegin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
dq98rpyapp1yc-- Created on 2014/1/16 by ADMINISTRATOR declare cursor cur_ykb010 is select ykb010 from yh00_ykb010_2013_gy; begin for cur1 in cur_ykb010 loop insert into yh00_2013_sf select a.ykb037, a.ykb010, a.aka130, sum(a.yka055), sum(a.yka107), nvl((select nvl(sum(yka074), 0) from kb17k1 where ykb010 = a.ykb010), 0), sum(a.yka065) from yh00_kc24k2_2013_gy a where ykb010 = cur1.ykb010 group by a.ykb037, a.ykb010, a.aka130; commit; end loop; end;
fc7x0k5thtydsINSERT INTO KC03K2 (YAE202, AAB001, AAC001, AAE003, AAE002, AAE143, AAB019, AAB020, AKC021, AKC025, AKC023, AKC010, YAE010, YAE203, AAA041, AAA042, YAA028, YKC175, YKC071, YKC063, YKC064, YKC072, YKC073, AKC061, AKC062, YKC065, YKC066, YKC067, YKC068, YKC176, YKC172, YAE206, AAE061, AAE076, YAB003, AAE011, AAE036, YKC326, YKC327, YAA310, YAC211, YAC210, YAC212 ) VALUES (:B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , 0, :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , 0, 0, 0, 0, 0, 0, :B11 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , :B6 , :B5 , 0, :B4 , :B3 , :B2 , :B1 )
fnj6cnubp1saubegin if :enable = 0 then sys.dbms_output.disable; else sys.dbms_output.enable(:size); end if; end;
fpqbpgdtsnja5BEGIN pkg_W_comm.prc_w_Query(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15); END;
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g5g0whrt4ngqtSELECT 1 FROM USER_TAB_COLUMNS WHERE LOWER(TABLE_NAME) = :B1 AND LOWER(COLUMN_NAME) = 'yab003'
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

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 586,631 161.11 12.12
CPU used when call started 1,378,817 378.67 28.48
CR blocks created 66,456 18.25 1.37
Cached Commit SCN referenced 16,630 4.57 0.34
Commit SCN cached 5 0.00 0.00
DB time 3,938,332 1,081.60 81.34
DBWR checkpoint buffers written 1,083,686 297.62 22.38
DBWR checkpoints 6 0.00 0.00
DBWR fusion writes 734 0.20 0.02
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 6,903 1.90 0.14
DBWR undo block writes 207,853 57.08 4.29
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 18 0.00 0.00
DML statements parallelized 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 60 0.02 0.00
PX local messages sent 60 0.02 0.00
PX remote messages recv'd 1,460 0.40 0.03
PX remote messages sent 1,539 0.42 0.03
Parallel operations downgraded 75 to 99 pct 0 0.00 0.00
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 18 0.00 0.00
RowCR - row contention 177 0.05 0.00
RowCR attempts 55,576 15.26 1.15
RowCR hits 57,856 15.89 1.19
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 19 0.01 0.00
SQL*Net roundtrips to/from client 2,583,415 709.49 53.35
SQL*Net roundtrips to/from dblink 4 0.00 0.00
active txn count during cleanout 337,860 92.79 6.98
application wait time 3,727 1.02 0.08
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 6 0.00 0.00
background checkpoints started 6 0.00 0.00
background timeouts 21,406 5.88 0.44
branch node splits 100 0.03 0.00
buffer is not pinned count 146,260,622 40,168.21 3,020.67
buffer is pinned count 465,211,286 127,763.07 9,607.83
bytes received via SQL*Net from client 162,433,931 44,609.96 3,354.69
bytes received via SQL*Net from dblink 70 0.02 0.00
bytes sent via SQL*Net to client 599,644,859 164,683.17 12,384.24
bytes sent via SQL*Net to dblink 66 0.02 0.00
calls to get snapshot scn: kcmgss 16,107,726 4,423.74 332.67
calls to kcmgas 1,827,699 501.95 37.75
calls to kcmgcs 175,479 48.19 3.62
change write time 5,969 1.64 0.12
cleanout - number of ktugct calls 335,018 92.01 6.92
cleanouts and rollbacks - consistent read gets 64,618 17.75 1.33
cleanouts only - consistent read gets 40,553 11.14 0.84
cluster key scan block gets 23,663,716 6,498.87 488.72
cluster key scans 11,865,083 3,258.56 245.05
cluster wait time 54,981 15.10 1.14
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 426 0.12 0.01
commit batch/immediate requested 426 0.12 0.01
commit cleanout failures: block lost 8,733 2.40 0.18
commit cleanout failures: buffer being written 1 0.00 0.00
commit cleanout failures: callback failure 26,397 7.25 0.55
commit cleanout failures: cannot pin 10 0.00 0.00
commit cleanouts 408,723 112.25 8.44
commit cleanouts successfully completed 373,582 102.60 7.72
commit immediate performed 426 0.12 0.01
commit immediate requested 426 0.12 0.01
commit txn count during cleanout 174,376 47.89 3.60
concurrency wait time 13,327 3.66 0.28
consistent changes 10,857,709 2,981.90 224.24
consistent gets 583,074,840 160,132.47 12,042.02
consistent gets - examination 101,384,136 27,843.58 2,093.85
consistent gets direct 3,217 0.88 0.07
consistent gets from cache 583,071,794 160,131.64 12,041.96
current blocks converted for CR 0 0.00 0.00
cursor authentications 1,058 0.29 0.02
data blocks consistent reads - undo records applied 9,650,860 2,650.46 199.32
db block changes 21,278,446 5,843.80 439.46
db block gets 30,704,728 8,432.58 634.13
db block gets direct 1,015 0.28 0.02
db block gets from cache 30,703,816 8,432.33 634.11
deferred (CURRENT) block cleanout applications 109,409 30.05 2.26
dirty buffers inspected 2,423 0.67 0.05
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 2,109 0.58 0.04
enqueue deadlocks 0 0.00 0.00
enqueue releases 873,714 239.95 18.04
enqueue requests 873,356 239.85 18.04
enqueue timeouts 58 0.02 0.00
enqueue waits 9,312 2.56 0.19
exchange deadlocks 8 0.00 0.00
execute count 12,800,005 3,515.32 264.35
failed probes on index block reclamation 31,847 8.75 0.66
frame signature mismatch 0 0.00 0.00
free buffer inspected 3,459,639 950.14 71.45
free buffer requested 3,906,098 1,072.75 80.67
gc CPU used by this session 59,470 16.33 1.23
gc blocks lost 0 0.00 0.00
gc cr block build time 26 0.01 0.00
gc cr block flush time 13 0.00 0.00
gc cr block receive time 94 0.03 0.00
gc cr block send time 38 0.01 0.00
gc cr blocks received 2,447 0.67 0.05
gc cr blocks served 9,581 2.63 0.20
gc current block flush time 13 0.00 0.00
gc current block pin time 115 0.03 0.00
gc current block receive time 4,818 1.32 0.10
gc current block send time 74 0.02 0.00
gc current blocks received 90,625 24.89 1.87
gc current blocks served 18,912 5.19 0.39
gc local grants 1,571,665 431.63 32.46
gc remote grants 1,619,780 444.85 33.45
gcs messages sent 3,534,795 970.78 73.00
ges messages sent 153,764 42.23 3.18
global enqueue get time 29,965 8.23 0.62
global enqueue gets async 16,009 4.40 0.33
global enqueue gets sync 425,133 116.76 8.78
global enqueue releases 408,627 112.22 8.44
global undo segment hints helped 0 0.00 0.00
global undo segment hints were stale 0 0.00 0.00
heap block compress 121,948 33.49 2.52
hot buffers moved to head of LRU 2,803,880 770.04 57.91
immediate (CR) block cleanout applications 105,171 28.88 2.17
immediate (CURRENT) block cleanout applications 217,181 59.65 4.49
index crx upgrade (found) 3 0.00 0.00
index crx upgrade (positioned) 2,154,186 591.61 44.49
index fast full scans (full) 1,078 0.30 0.02
index fetch by key 86,419,521 23,733.78 1,784.79
index scans kdiixs1 27,015,707 7,419.45 557.95
leaf node 90-10 splits 5,652 1.55 0.12
leaf node splits 25,264 6.94 0.52
lob reads 888 0.24 0.02
lob writes 694 0.19 0.01
lob writes unaligned 540 0.15 0.01
local undo segment hints helped 0 0.00 0.00
local undo segment hints were stale 0 0.00 0.00
logons cumulative 13,925 3.82 0.29
messages received 226,996 62.34 4.69
messages sent 226,996 62.34 4.69
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 475,931,514 130,707.22 9,829.23
opened cursors cumulative 446,693 122.68 9.23
parse count (failures) 31,312 8.60 0.65
parse count (hard) 33,601 9.23 0.69
parse count (total) 712,254 195.61 14.71
parse time cpu 1,567 0.43 0.03
parse time elapsed 17,027 4.68 0.35
physical read IO requests 2,453,129 673.71 50.66
physical read bytes 25,731,145,728 7,066,660.59 531,415.65
physical read total IO requests 2,513,241 690.22 51.91
physical read total bytes 33,800,899,072 9,282,893.34 698,077.22
physical read total multi block requests 194,847 53.51 4.02
physical reads 3,141,004 862.63 64.87
physical reads cache 3,137,037 861.54 64.79
physical reads cache prefetch 693,385 190.43 14.32
physical reads direct 3,972 1.09 0.08
physical reads direct (lob) 2,919 0.80 0.06
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 609,229 167.32 12.58
physical write bytes 8,930,975,744 2,452,754.14 184,448.07
physical write total IO requests 693,068 190.34 14.31
physical write total bytes 19,861,666,816 5,454,699.12 410,195.51
physical write total multi block requests 190,249 52.25 3.93
physical writes 1,090,207 299.41 22.52
physical writes direct 1,171 0.32 0.02
physical writes direct (lob) 977 0.27 0.02
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 1,089,036 299.09 22.49
physical writes non checkpoint 818,042 224.66 16.89
pinned buffers inspected 17 0.00 0.00
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 45 0.01 0.00
process last non-idle time 3,639 1.00 0.08
queries parallelized 18 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 18,367,820 5,044.44 379.34
recursive cpu usage 365,913 100.49 7.56
redo blocks written 6,938,534 1,905.56 143.30
redo buffer allocation retries 24 0.01 0.00
redo entries 10,898,307 2,993.05 225.08
redo log space requests 24 0.01 0.00
redo log space wait time 15 0.00 0.00
redo ordering marks 192,027 52.74 3.97
redo size 3,428,695,352 941,638.07 70,811.55
redo subscn max counts 39,753 10.92 0.82
redo synch time 1,010 0.28 0.02
redo synch writes 14,478 3.98 0.30
redo wastage 8,423,384 2,313.35 173.96
redo write time 1,667 0.46 0.03
redo writer latching time 0 0.00 0.00
redo writes 25,254 6.94 0.52
rollback changes - undo records applied 11,157 3.06 0.23
rollbacks only - consistent read gets 1,046 0.29 0.02
rows fetched via callback 23,234,027 6,380.87 479.84
session connect time 0 0.00 0.00
session cursor cache hits 518,394 142.37 10.71
session logical reads 613,779,866 168,565.13 12,676.16
session pga memory max 200,412,448 55,040.17 4,139.04
session uga memory ############### 86,090,444.25 6,474,035.19
session uga memory max 6,517,530,552 1,789,938.81 134,604.10
shared hash latch upgrades - no wait 2,890,173 793.74 59.69
shared hash latch upgrades - wait 236 0.06 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 2,225,943 611.32 45.97
sorts (rows) 47,702,513 13,100.76 985.18
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 2,883 0.79 0.06
sql area purged 22,962 6.31 0.47
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 2,606 0.72 0.05
switch current to new buffer 392,818 107.88 8.11
table fetch by rowid 228,212,022 62,674.90 4,713.18
table fetch continued row 1,579,204 433.70 32.61
table scan blocks gotten 360,484,089 99,001.37 7,444.94
table scan rows gotten 14,034,125,953 3,854,255.30 289,841.51
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 19 0.01 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 1,394,408 382.95 28.80
total number of times SMON posted 39,840 10.94 0.82
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 426 0.12 0.01
transaction tables consistent read rollbacks 9 0.00 0.00
transaction tables consistent reads - undo records applied 5,778 1.59 0.12
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 1,407,873,716 386,650.71 29,076.28
user I/O wait time 488,415 134.14 10.09
user calls 2,618,981 719.26 54.09
user commits 21,411 5.88 0.44
user rollbacks 27,009 7.42 0.56
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 551,604 151.49 11.39
write clones created in background 0 0.00 0.00
write clones created in foreground 11 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 130,102,719 130,195,323
opened cursors current 129,094 106,538
workarea memory allocated 901,095 935,680
logons current 1,333 1,144

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 6 5.93

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
DATA 2,167,935 595 2.16 1.30 566,215 156 66,285 1.21
NNC_DATA01 169,149 46 0.38 1.22 4 0 0 0.00
SHORDATA 93,532 26 1.51 1.00 8,496 2 3 0.00
UNDOTBS1 74 0 4.46 1.00 29,380 8 113 0.00
IUFO 16,900 5 0.20 1.00 0 0 0 0.00
SYSAUX 2,458 1 3.03 1.02 2,330 1 62 0.65
JYINDEX 3,584 1 2.38 1.00 636 0 0 0.00
JYDATA 2,799 1 2.90 1.01 353 0 298 1.61
TEMPDATA 2,329 1 0.36 1.00 16 0 0 0.00
TEMP 940 0 2.64 2.55 1,069 0 0 0.00
SYSTEM 299 0 3.08 1.00 543 0 0 0.00
LDGGSJ 727 0 5.19 1.00 8 0 0 0.00
USERS 649 0 0.31 1.01 0 0 0 0.00
DATA_CW_INDEX01 230 0 6.04 1.00 108 0 0 0.00
NNC_INDEX01 260 0 5.50 1.00 3 0 0 0.00
JYLOBDATA 108 0 0.19 1.00 1 0 0 0.00
CDLDZC 14 0 6.43 1.00 82 0 4 10.00
JYSHORTDATA 58 0 0.86 1.00 6 0 0 0.00
GGFW 52 0 0.00 1.00 0 0 0 0.00
NNC_DATA03 30 0 4.67 1.00 9 0 0 0.00
NNC_INDEX02 33 0 5.76 1.12 0 0 9 3.33
NNC_DATA02 25 0 4.40 1.00 0 0 0 0.00
NNC_INDEX03 20 0 5.50 1.00 5 0 0 0.00
GDZC 4 0 7.50 1.00 9 0 0 0.00
JYTEMP 0 0 0.00   9 0 0 0.00
SYBX_DATA 3 0 3.33 1.00 1 0 0 0.00
DANGAN 2 0 0.00 1.00 0 0 0 0.00
LDJG 1 0 10.00 1.00 0 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 14 0 6.43 1.00 82 0 4 10.00
DANGAN /dev/rcdld_dangan01 1 0 0.00 1.00 0 0 0 0.00
DANGAN /dev/rcdld_dangan02 1 0 0.00 1.00 0 0 0 0.00
DATA /dev/rcdld_data01 6,198 2 3.01 1.09 2,426 1 41 4.88
DATA /dev/rcdld_data02 5,624 2 2.91 1.22 2,024 1 17 2.35
DATA /dev/rcdld_data03 6,006 2 2.95 1.36 2,308 1 4,811 2.42
DATA /dev/rcdld_data04 4,956 1 3.21 1.24 2,515 1 103 3.20
DATA /dev/rcdld_data05 4,713 1 3.02 1.28 2,244 1 62 3.55
DATA /dev/rcdld_data06 4,946 1 2.78 1.15 2,086 1 77 3.90
DATA /dev/rcdld_data07 12,362 3 1.38 1.57 1,893 1 24 4.17
DATA /dev/rcdld_data08 6,347 2 2.86 1.33 2,222 1 9 3.33
DATA /dev/rcdld_data09 6,888 2 2.34 5.15 1,446 0 77 5.32
DATA /dev/rcdld_data10 5,568 2 2.16 1.36 3,560 1 123 3.82
DATA /dev/rcdld_data100 4,789 1 2.06 1.58 842 0 474 0.46
DATA /dev/rcdld_data101 4,656 1 2.01 1.16 1,082 0 7 7.14
DATA /dev/rcdld_data102 4,725 1 1.84 1.15 754 0 9 2.22
DATA /dev/rcdld_data103 2,949 1 2.70 1.04 914 0 22 2.73
DATA /dev/rcdld_data104 3,545 1 2.48 1.00 858 0 12 4.17
DATA /dev/rcdld_data105 2,915 1 2.60 1.04 794 0 18 5.00
DATA /dev/rcdld_data106 2,732 1 3.18 1.00 1,072 0 11 7.27
DATA /dev/rcdld_data107 3,190 1 3.67 1.00 1,281 0 6 3.33
DATA /dev/rcdld_data108 8,824 2 2.40 1.00 1,742 0 54 4.63
DATA /dev/rcdld_data109 5,604 2 2.77 1.00 1,563 0 17 1.18
DATA /dev/rcdld_data11 7,745 2 2.17 1.43 990 0 136 3.24
DATA /dev/rcdld_data110 3,534 1 3.21 1.00 1,537 0 47 4.47
DATA /dev/rcdld_data111 3,524 1 3.01 1.28 1,485 0 9 8.89
DATA /dev/rcdld_data112 5,089 1 2.40 1.19 1,551 0 18 2.78
DATA /dev/rcdld_data113 4,606 1 2.19 1.50 1,699 0 15 3.33
DATA /dev/rcdld_data114 8,167 2 2.63 1.00 1,430 0 76 4.47
DATA /dev/rcdld_data115 11,328 3 2.07 1.26 2,233 1 11 4.55
DATA /dev/rcdld_data116 7,644 2 1.87 1.22 1,992 1 22 2.27
DATA /dev/rcdld_data117 11,108 3 2.32 1.22 1,695 0 14 1.43
DATA /dev/rcdld_data118 4,456 1 2.67 1.31 1,879 1 15 5.33
DATA /dev/rcdld_data119 7,701 2 1.89 1.12 2,277 1 61 4.10
DATA /dev/rcdld_data12 5,473 2 2.72 1.48 1,775 0 37 3.51
DATA /dev/rcdld_data120 4,252 1 2.76 1.34 1,792 0 33 4.55
DATA /dev/rcdld_data121 4,979 1 2.67 1.11 2,104 1 18 6.67
DATA /dev/rcdld_data122 4,604 1 3.48 1.00 2,878 1 13 3.85
DATA /dev/rcdld_data123 4,497 1 3.43 1.00 3,090 1 13 3.85
DATA /dev/rcdld_data124 8,533 2 1.69 1.00 3,131 1 15 4.00
DATA /dev/rcdld_data125 6,069 2 2.68 1.00 3,063 1 15 3.33
DATA /dev/rcdld_data126 5,938 2 2.99 1.00 3,270 1 12 1.67
DATA /dev/rcdld_data127 5,466 2 3.02 1.00 3,052 1 9 5.56
DATA /dev/rcdld_data128 4,735 1 2.94 1.21 2,546 1 8 5.00
DATA /dev/rcdld_data129 5,084 1 3.53 1.00 3,212 1 7 2.86
DATA /dev/rcdld_data13 6,000 2 2.56 1.73 2,353 1 27 4.81
DATA /dev/rcdld_data130 4,965 1 3.33 1.00 3,518 1 22 5.00
DATA /dev/rcdld_data131 3,680 1 3.21 1.00 3,037 1 13 4.62
DATA /dev/rcdld_data132 4,121 1 3.39 1.00 3,066 1 26 2.31
DATA /dev/rcdld_data133 7,422 2 2.26 1.00 2,664 1 18 2.78
DATA /dev/rcdld_data134 6,190 2 3.37 1.00 4,410 1 16 3.75
DATA /dev/rcdld_data135 4,242 1 3.33 1.01 2,427 1 17 2.35
DATA /dev/rcdld_data136 8,340 2 1.81 1.29 2,893 1 4 7.50
DATA /dev/rcdld_data137 10,767 3 1.97 1.06 3,499 1 6 1.67
DATA /dev/rcdld_data138 5,629 2 2.81 1.03 3,220 1 16 3.13
DATA /dev/rcdld_data139 4,731 1 3.37 1.00 2,590 1 18 2.78
DATA /dev/rcdld_data14 4,666 1 2.46 1.34 1,625 0 74 5.54
DATA /dev/rcdld_data140 5,519 2 3.08 1.00 2,831 1 9 1.11
DATA /dev/rcdld_data141 1,866 1 4.79 1.00 992 0 14 2.86
DATA /dev/rcdld_data142 3,986 1 3.83 1.00 2,210 1 13 3.08
DATA /dev/rcdld_data143 4,880 1 2.43 1.24 1,162 0 16 3.13
DATA /dev/rcdld_data144 6,854 2 2.68 1.13 2,513 1 12 2.50
DATA /dev/rcdld_data145 4,452 1 3.87 1.00 2,365 1 11 0.00
DATA /dev/rcdld_data146 13,370 4 1.95 1.22 3,548 1 16 3.75
DATA /dev/rcdld_data147 7,780 2 2.26 1.23 2,153 1 33 4.55
DATA /dev/rcdld_data148 16,439 5 1.22 1.37 2,888 1 28 2.86
DATA /dev/rcdld_data149 12,036 3 1.67 1.31 2,513 1 27 1.85
DATA /dev/rcdld_data15 6,839 2 1.93 1.47 1,463 0 16 2.50
DATA /dev/rcdld_data150 7,330 2 2.08 1.19 2,336 1 16 1.25
DATA /dev/rcdld_data151 10,715 3 1.52 1.13 2,531 1 42 1.43
DATA /dev/rcdld_data152 6,604 2 2.09 1.20 2,401 1 10 1.00
DATA /dev/rcdld_data153 12,961 4 1.34 1.55 2,745 1 35 3.43
DATA /dev/rcdld_data154 6,260 2 2.34 1.20 2,774 1 14 3.57
DATA /dev/rcdld_data155 11,374 3 1.36 1.39 2,738 1 25 2.00
DATA /dev/rcdld_data156 4,491 1 2.48 1.16 1,774 0 22 2.73
DATA /dev/rcdld_data157 8,690 2 2.02 1.10 2,145 1 16 3.13
DATA /dev/rcdld_data158 3,597 1 2.30 1.24 700 0 8 1.25
DATA /dev/rcdld_data159 2,666 1 2.28 1.08 707 0 7 8.57
DATA /dev/rcdld_data16 4,731 1 2.59 1.61 1,580 0 0 0.00
DATA /dev/rcdld_data160 2,784 1 2.57 1.11 340 0 7 4.29
DATA /dev/rcdld_data161 16,488 5 1.16 1.29 3,363 1 24 1.67
DATA /dev/rcdld_data162 4,111 1 1.49 1.09 406 0 6 5.00
DATA /dev/rcdld_data163 4,350 1 1.66 1.27 527 0 14 0.71
DATA /dev/rcdld_data164 9,757 3 0.82 1.43 896 0 13 1.54
DATA /dev/rcdld_data165 2,886 1 2.09 1.38 495 0 9 5.56
DATA /dev/rcdld_data166 9,979 3 1.08 1.44 748 0 19 2.11
DATA /dev/rcdld_data167 3,014 1 2.21 1.37 392 0 17 1.76
DATA /dev/rcdld_data168 3,632 1 1.86 1.30 276 0 5 6.00
DATA /dev/rcdld_data169 7,293 2 2.92 1.22 4,218 1 9 3.33
DATA /dev/rcdld_data17 6,013 2 2.29 1.20 1,205 0 6 3.33
DATA /dev/rcdld_data170 15,552 4 1.54 1.27 3,930 1 13 1.54
DATA /dev/rcdld_data171 17,465 5 1.80 1.34 5,852 2 91 1.21
DATA /dev/rcdld_data172 19,790 5 1.47 1.34 5,678 2 74 2.03
DATA /dev/rcdld_data173 10,631 3 2.21 1.21 3,849 1 86 1.86
DATA /dev/rcdld_data174 14,815 4 1.88 1.43 4,685 1 6 3.33
DATA /dev/rcdld_data175 24,719 7 1.26 1.40 5,353 1 10 6.00
DATA /dev/rcdld_data176 15,658 4 1.59 1.23 3,461 1 1 10.00
DATA /dev/rcdld_data177 10,099 3 2.51 1.11 4,119 1 2 10.00
DATA /dev/rcdld_data178 9,434 3 2.21 1.12 3,539 1 20 7.50
DATA /dev/rcdld_data179 8,437 2 2.57 1.06 3,731 1 14 2.86
DATA /dev/rcdld_data18 5,927 2 2.30 1.48 1,021 0 27 3.70
DATA /dev/rcdld_data180 9,354 3 2.31 1.12 2,897 1 16 3.13
DATA /dev/rcdld_data181 7,619 2 2.57 1.15 2,848 1 14 3.57
DATA /dev/rcdld_data182 6,267 2 3.44 1.18 3,295 1 20 3.00
DATA /dev/rcdld_data183 9,045 2 2.34 1.12 2,837 1 24 3.33
DATA /dev/rcdld_data184 7,677 2 2.08 1.02 2,031 1 77 2.73
DATA /dev/rcdld_data185 23,368 6 1.31 1.08 2,939 1 75 2.00
DATA /dev/rcdld_data186 11,046 3 1.81 1.02 2,389 1 92 1.30
DATA /dev/rcdld_data187 9,030 2 3.00 1.02 3,049 1 105 2.29
DATA /dev/rcdld_data188 11,556 3 2.17 1.02 2,824 1 42 2.86
DATA /dev/rcdld_data189 9,252 3 2.33 1.00 2,778 1 10 2.00
DATA /dev/rcdld_data19 6,721 2 2.51 1.61 1,046 0 0 0.00
DATA /dev/rcdld_data190 9,485 3 2.01 1.10 2,164 1 13 5.38
DATA /dev/rcdld_data191 12,935 4 1.99 1.08 2,119 1 11 0.00
DATA /dev/rcdld_data192 9,001 2 2.38 1.00 2,116 1 22 1.82
DATA /dev/rcdld_data193 12,792 4 1.82 1.00 2,376 1 8 0.00
DATA /dev/rcdld_data194 7,640 2 2.77 1.00 2,260 1 7 8.57
DATA /dev/rcdld_data195 18,863 5 1.52 1.08 3,425 1 9 3.33
DATA /dev/rcdld_data196 11,006 3 2.32 1.00 2,416 1 15 0.67
DATA /dev/rcdld_data197 7,843 2 2.12 1.00 3,080 1 11 7.27
DATA /dev/rcdld_data198 9,323 3 2.53 1.00 3,101 1 8 2.50
DATA /dev/rcdld_data199 7,485 2 2.32 1.00 2,240 1 6 3.33
DATA /dev/rcdld_data20 4,681 1 2.77 1.10 1,197 0 2 10.00
DATA /dev/rcdld_data200 4,273 1 3.20 1.23 2,396 1 7 5.71
DATA /dev/rcdld_data201 6,502 2 2.40 1.00 2,546 1 6 6.67
DATA /dev/rcdld_data202 10,729 3 2.12 1.00 2,837 1 22 6.36
DATA /dev/rcdld_data203 12,989 4 1.51 1.00 2,370 1 9 8.89
DATA /dev/rcdld_data204 7,685 2 2.46 1.13 2,359 1 6 3.33
DATA /dev/rcdld_data205 10,666 3 1.75 1.00 2,162 1 2 5.00
DATA /dev/rcdld_data206 10,584 3 2.06 1.00 2,428 1 8 1.25
DATA /dev/rcdld_data207 9,022 2 2.23 1.00 2,461 1 1 0.00
DATA /dev/rcdld_data208 4,277 1 3.50 1.23 2,750 1 9 3.33
DATA /dev/rcdld_data209 9,552 3 2.19 1.00 2,637 1 10 7.00
DATA /dev/rcdld_data21 3,548 1 2.48 1.47 903 0 58 4.83
DATA /dev/rcdld_data210 9,832 3 2.03 1.00 2,961 1 3 10.00
DATA /dev/rcdld_data211 8,093 2 2.40 1.00 1,963 1 10 3.00
DATA /dev/rcdld_data212 15,160 4 1.47 1.00 1,843 1 6 3.33
DATA /dev/rcdld_data213 9,949 3 1.21 1.00 2,056 1 9 4.44
DATA /dev/rcdld_data214 2,931 1 3.52 1.00 2,090 1 17 4.71
DATA /dev/rcdld_data215 2,159 1 4.28 1.00 1,506 0 4 2.50
DATA /dev/rcdld_data216 12,551 3 1.57 1.08 1,216 0 8 6.25
DATA /dev/rcdld_data217 3,695 1 4.06 1.00 3,010 1 5 6.00
DATA /dev/rcdld_data218 3,721 1 3.38 1.00 2,111 1 7 5.71
DATA /dev/rcdld_data219 16,399 5 1.70 1.13 2,009 1 11 4.55
DATA /dev/rcdld_data22 3,932 1 2.46 1.17 1,150 0 4 0.00
DATA /dev/rcdld_data220 8,568 2 1.93 1.11 1,097 0 34 2.65
DATA /dev/rcdld_data221 13,098 4 1.59 1.15 1,061 0 50 1.60
DATA /dev/rcdld_data222 10,369 3 2.09 1.02 1,309 0 23 3.91
DATA /dev/rcdld_data223 4,507 1 2.45 1.17 1,338 0 21 4.76
DATA /dev/rcdld_data224 1,296 0 4.82 1.00 324 0 14 3.57
DATA /dev/rcdld_data225 2,581 1 3.92 1.00 1,351 0 3 0.00
DATA /dev/rcdld_data226 6,301 2 1.66 1.00 1,227 0 3 0.00
DATA /dev/rcdld_data227 10,889 3 2.17 1.00 1,884 1 3 3.33
DATA /dev/rcdld_data228 4,002 1 3.92 1.33 1,966 1 5 2.00
DATA /dev/rcdld_data229 8,008 2 3.17 1.00 2,731 1 6 5.00
DATA /dev/rcdld_data23 3,193 1 2.49 1.24 905 0 2 5.00
DATA /dev/rcdld_data230 8,155 2 2.86 1.12 1,883 1 6 5.00
DATA /dev/rcdld_data231 10,435 3 1.44 1.00 660 0 1 0.00
DATA /dev/rcdld_data232 9,461 3 2.64 1.01 1,875 1 17 4.12
DATA /dev/rcdld_data233 1,722 0 4.26 1.05 289 0 15 3.33
DATA /dev/rcdld_data234 3,349 1 3.94 1.00 1,125 0 2 0.00
DATA /dev/rcdld_data235 4,021 1 3.96 1.00 2,265 1 25 3.60
DATA /dev/rcdld_data236 3,375 1 4.28 1.00 1,982 1 36 1.67
DATA /dev/rcdld_data237 5,322 1 2.88 1.00 1,931 1 16 3.75
DATA /dev/rcdld_data238 16,711 5 2.22 1.00 1,967 1 26 5.38
DATA /dev/rcdld_data239 6,133 2 2.26 1.16 1,875 1 21 4.29
DATA /dev/rcdld_data24 3,493 1 2.91 1.43 1,099 0 13 3.08
DATA /dev/rcdld_data240 12,323 3 1.78 1.08 2,013 1 29 2.41
DATA /dev/rcdld_data241 2,715 1 4.35 1.04 1,680 0 19 3.16
DATA /dev/rcdld_data242 6,523 2 3.34 1.02 1,036 0 12 1.67
DATA /dev/rcdld_data243 8,144 2 2.14 1.01 1,178 0 5 2.00
DATA /dev/rcdld_data244 8,705 2 2.83 1.01 1,383 0 4 7.50
DATA /dev/rcdld_data245 6,424 2 2.28 1.02 1,088 0 6 1.67
DATA /dev/rcdld_data246 3,014 1 3.79 1.70 1,209 0 0 0.00
DATA /dev/rcdld_data247 4,107 1 3.40 1.27 1,410 0 1 10.00
DATA /dev/rcdld_data248 4,240 1 3.95 1.26 1,944 1 34 3.53
DATA /dev/rcdld_data249 1,919 1 3.53 1.06 1,102 0 8 2.50
DATA /dev/rcdld_data25 5,091 1 2.86 1.32 1,407 0 83 2.77
DATA /dev/rcdld_data250 2,863 1 3.60 1.04 1,077 0 1 0.00
DATA /dev/rcdld_data251 1,646 0 4.26 1.07 807 0 4 5.00
DATA /dev/rcdld_data252 14,116 4 1.98 1.02 1,725 0 1 10.00
DATA /dev/rcdld_data253 10,110 3 2.36 1.11 1,972 1 1 0.00
DATA /dev/rcdld_data254 2,892 1 4.86 1.04 1,637 0 3 0.00
DATA /dev/rcdld_data255 13,397 4 1.69 1.08 1,963 1 3 0.00
DATA /dev/rcdld_data256 17,158 5 1.35 1.08 2,173 1 1 0.00
DATA /dev/rcdld_data257 6,603 2 1.53 1.14 1,582 0 2 0.00
DATA /dev/rcdld_data258 6,841 2 1.54 1.25 1,571 0 3 3.33
DATA /dev/rcdld_data259 3,132 1 3.15 1.04 1,515 0 1 0.00
DATA /dev/rcdld_data26 6,176 2 2.60 1.11 782 0 24 3.75
DATA /dev/rcdld_data260 7,304 2 2.81 1.02 1,397 0 1 10.00
DATA /dev/rcdld_data261 9,506 3 2.40 1.12 1,327 0 2 10.00
DATA /dev/rcdld_data262 13,473 4 1.89 1.01 1,209 0 7 1.43
DATA /dev/rcdld_data263 16,163 4 1.57 1.97 1,921 1 7 1.43
DATA /dev/rcdld_data264 15,779 4 1.78 2.05 2,900 1 6 3.33
DATA /dev/rcdld_data265 14,856 4 1.52 2.31 2,019 1 7 7.14
DATA /dev/rcdld_data266 13,109 4 1.90 2.57 1,431 0 16 3.75
DATA /dev/rcdld_data267 13,326 4 1.94 2.47 1,781 0 32 0.63
DATA /dev/rcdld_data268 13,638 4 1.69 2.38 1,535 0 56 2.14
DATA /dev/rcdld_data269 11,592 3 2.00 2.52 1,344 0 48 1.46
DATA /dev/rcdld_data27 7,185 2 2.55 1.43 1,262 0 13 2.31
DATA /dev/rcdld_data270 16,707 5 1.35 1.72 1,438 0 379 1.21
DATA /dev/rcdld_data271 13,690 4 1.51 1.15 1,616 0 827 1.05
DATA /dev/rcdld_data272 18,653 5 1.35 1.48 1,770 0 4,340 0.63
DATA /dev/rcdld_data273 17,103 5 1.55 1.62 1,926 1 4,673 0.78
DATA /dev/rcdld_data274 16,578 5 1.36 2.03 1,836 1 3,694 0.53
DATA /dev/rcdld_data275 7,185 2 2.21 3.19 1,106 0 3,496 1.02
DATA /dev/rcdld_data276 1,942 1 4.80 1.00 1,283 0 23 1.74
DATA /dev/rcdld_data277 2,157 1 3.86 1.46 652 0 21 3.81
DATA /dev/rcdld_data278 1,559 0 3.67 1.63 424 0 17 2.94
DATA /dev/rcdld_data279 5,302 1 1.97 1.00 554 0 4,872 0.89
DATA /dev/rcdld_data28 7,452 2 2.10 1.30 1,298 0 43 2.56
DATA /dev/rcdld_data280 1,605 0 4.82 1.00 440 0 18 4.44
DATA /dev/rcdld_data281 877 0 5.29 1.00 646 0 21 4.29
DATA /dev/rcdld_data282 1,245 0 4.55 1.00 589 0 47 1.06
DATA /dev/rcdld_data283 7,297 2 1.91 1.14 1,339 0 7,180 1.00
DATA /dev/rcdld_data284 7,238 2 1.67 1.14 1,329 0 5,941 0.55
DATA /dev/rcdld_data285 2,758 1 2.55 1.00 1,266 0 275 1.27
DATA /dev/rcdld_data286 2,839 1 2.26 1.68 1,070 0 102 1.96
DATA /dev/rcdld_data287 1,827 1 3.24 1.00 969 0 130 2.46
DATA /dev/rcdld_data288 5,038 1 1.75 1.00 1,010 0 4,911 0.58
DATA /dev/rcdld_data289 2,024 1 2.71 1.44 814 0 0 0.00
DATA /dev/rcdld_data29 6,430 2 2.49 1.59 1,416 0 20 1.00
DATA /dev/rcdld_data290 7,359 2 1.83 1.00 1,097 0 0 0.00
DATA /dev/rcdld_data291 6,989 2 2.15 1.18 3,131 1 4,740 1.12
DATA /dev/rcdld_data292 5,593 2 2.18 1.18 2,555 1 5,190 0.78
DATA /dev/rcdld_data293 2,670 1 2.96 1.37 2,117 1 2,052 1.81
DATA /dev/rcdld_data294 2,992 1 2.22 1.29 929 0 2,112 1.28
DATA /dev/rcdld_data295 1,573 0 3.48 1.00 585 0 55 2.18
DATA /dev/rcdld_data296 2,051 1 2.58 1.00 294 0 14 5.00
DATA /dev/rcdld_data297 779 0 5.28 1.00 412 0 11 2.73
DATA /dev/rcdld_data298 903 0 5.12 1.00 384 0 19 4.74
DATA /dev/rcdld_data30 5,372 1 3.20 1.43 2,222 1 2 5.00
DATA /dev/rcdld_data31 6,124 2 2.77 1.51 3,201 1 9 2.22
DATA /dev/rcdld_data32 4,516 1 3.05 1.56 1,801 0 20 1.50
DATA /dev/rcdld_data33 4,315 1 2.84 1.72 1,691 0 32 6.88
DATA /dev/rcdld_data34 5,122 1 2.59 2.01 1,381 0 4 10.00
DATA /dev/rcdld_data35 4,857 1 2.99 1.93 1,702 0 21 7.14
DATA /dev/rcdld_data36 4,813 1 2.28 1.98 1,202 0 25 12.80
DATA /dev/rcdld_data37 9,222 3 2.23 2.22 3,095 1 136 3.75
DATA /dev/rcdld_data38 6,783 2 2.45 1.52 3,010 1 16 15.00
DATA /dev/rcdld_data39 5,387 1 3.22 2.29 2,709 1 17 14.12
DATA /dev/rcdld_data40 4,859 1 3.22 2.34 2,331 1 2 10.00
DATA /dev/rcdld_data41 5,573 2 2.76 2.26 2,849 1 35 3.43
DATA /dev/rcdld_data42 7,281 2 2.15 2.17 4,594 1 9 4.44
DATA /dev/rcdld_data43 4,950 1 2.90 1.16 3,258 1 398 2.76
DATA /dev/rcdld_data44 3,599 1 2.66 1.94 2,725 1 1 0.00
DATA /dev/rcdld_data45 4,633 1 2.40 1.50 3,423 1 3 3.33
DATA /dev/rcdld_data46 4,432 1 2.67 1.55 3,408 1 0 0.00
DATA /dev/rcdld_data47 5,908 2 2.07 1.31 2,874 1 54 3.15
DATA /dev/rcdld_data48 4,937 1 2.29 1.59 2,548 1 2 0.00
DATA /dev/rcdld_data49 10,007 3 1.92 1.16 2,377 1 25 3.20
DATA /dev/rcdld_data50 6,198 2 2.74 1.66 3,783 1 11 3.64
DATA /dev/rcdld_data51 3,957 1 3.57 1.90 3,255 1 5 2.00
DATA /dev/rcdld_data52 7,700 2 2.72 1.43 2,070 1 1 10.00
DATA /dev/rcdld_data53 4,314 1 2.53 1.89 2,396 1 2 0.00
DATA /dev/rcdld_data54 6,159 2 2.70 1.37 2,711 1 3 3.33
DATA /dev/rcdld_data55 4,640 1 2.17 1.80 2,700 1 43 4.88
DATA /dev/rcdld_data56 8,015 2 1.70 1.32 2,195 1 4 0.00
DATA /dev/rcdld_data57 5,225 1 2.31 1.82 1,772 0 26 5.38
DATA /dev/rcdld_data58 5,130 1 2.62 1.51 1,036 0 17 1.18
DATA /dev/rcdld_data59 6,662 2 2.44 1.44 1,343 0 12 2.50
DATA /dev/rcdld_data60 8,101 2 2.35 1.34 1,791 0 29 5.17
DATA /dev/rcdld_data61 7,034 2 2.23 1.39 1,168 0 8 0.00
DATA /dev/rcdld_data62 4,618 1 2.86 1.07 1,464 0 7 0.00
DATA /dev/rcdld_data63 4,565 1 2.49 1.14 424 0 7 4.29
DATA /dev/rcdld_data64 8,422 2 2.08 1.10 456 0 0 0.00
DATA /dev/rcdld_data65 9,166 3 1.72 1.09 562 0 6 1.67
DATA /dev/rcdld_data66 8,835 2 1.97 1.10 1,546 0 8 3.75
DATA /dev/rcdld_data67 5,912 2 2.18 1.16 725 0 3 3.33
DATA /dev/rcdld_data68 6,759 2 2.11 1.11 760 0 1 10.00
DATA /dev/rcdld_data69 5,208 1 2.74 1.12 1,406 0 1 10.00
DATA /dev/rcdld_data70 7,407 2 2.44 1.08 1,292 0 1 0.00
DATA /dev/rcdld_data71 9,835 3 1.74 1.06 461 0 2 5.00
DATA /dev/rcdld_data72 6,000 2 2.14 1.09 425 0 62 4.52
DATA /dev/rcdld_data73 7,008 2 1.96 1.22 1,230 0 4 5.00
DATA /dev/rcdld_data74 5,711 2 2.45 1.23 1,636 0 0 0.00
DATA /dev/rcdld_data75 9,858 3 1.81 1.12 1,353 0 2 5.00
DATA /dev/rcdld_data76 7,490 2 1.64 1.14 1,065 0 27 3.33
DATA /dev/rcdld_data77 8,345 2 1.66 1.25 1,055 0 7 0.00
DATA /dev/rcdld_data78 6,302 2 1.87 1.29 1,074 0 4 2.50
DATA /dev/rcdld_data79 5,700 2 2.12 1.21 1,174 0 17 2.94
DATA /dev/rcdld_data80 6,616 2 1.85 1.28 1,312 0 7 0.00
DATA /dev/rcdld_data81 5,945 2 2.04 1.33 1,318 0 14 5.71
DATA /dev/rcdld_data82 5,414 1 2.01 1.29 1,249 0 4 2.50
DATA /dev/rcdld_data83 6,294 2 2.14 1.26 1,068 0 25 2.00
DATA /dev/rcdld_data84 7,293 2 1.92 1.33 923 0 9 8.89
DATA /dev/rcdld_data85 5,662 2 1.86 1.49 899 0 92 7.28
DATA /dev/rcdld_data86 8,992 2 1.51 1.21 849 0 28 3.93
DATA /dev/rcdld_data87 9,254 3 1.59 1.20 1,486 0 37 3.24
DATA /dev/rcdld_data88 7,818 2 1.56 1.23 1,255 0 7 0.00
DATA /dev/rcdld_data90 8,305 2 1.55 1.21 1,461 0 19 3.68
DATA /dev/rcdld_data91 9,704 3 1.35 1.41 990 0 19 4.74
DATA /dev/rcdld_data92 7,503 2 1.82 1.52 1,254 0 82 3.05
DATA /dev/rcdld_data93 9,795 3 1.41 1.40 1,677 0 22 2.27
DATA /dev/rcdld_data94 7,537 2 1.71 1.61 2,137 1 25 4.00
DATA /dev/rcdld_data95 8,069 2 1.75 1.44 2,055 1 10 2.00
DATA /dev/rcdld_data96 8,918 2 1.58 1.42 1,183 0 20 5.50
DATA /dev/rcdld_data97 9,830 3 1.51 1.39 1,189 0 7 2.86
DATA /dev/rcdld_data98 7,089 2 1.76 1.36 1,194 0 7 1.43
DATA /dev/rcdld_data99 8,123 2 1.76 1.34 1,215 0 208 1.30
DATA_CW_INDEX01 /dev/rcdld_cw_indx01 31 0 4.84 1.00 41 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx02 12 0 5.83 1.00 3 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx03 13 0 8.46 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx04 19 0 5.26 1.00 2 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx05 8 0 8.75 1.00 2 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx06 86 0 5.93 1.00 12 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx07 3 0 0.00 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx08 1 0 0.00 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx09 3 0 6.67 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx11 14 0 5.71 1.00 44 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx12 7 0 7.14 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx14 1 0 10.00 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx15 3 0 6.67 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx16 3 0 6.67 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx17 1 0 0.00 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx18 2 0 5.00 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx19 5 0 6.00 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx20 2 0 5.00 1.00 1 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx21 5 0 6.00 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx22 3 0 6.67 1.00 0 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx23 8 0 10.00 1.00 3 0 0 0.00
GDZC /dev/rcdld_gdzc2 4 0 7.50 1.00 9 0 0 0.00
GGFW /dev/rcdld_ggfw 52 0 0.00 1.00 0 0 0 0.00
IUFO /dev/rnnc_iufo 16,900 5 0.20 1.00 0 0 0 0.00
JYDATA /dev/rcdld_jydata01 717 0 2.58 1.01 104 0 29 2.76
JYDATA /dev/rcdld_jydata02 424 0 3.42 1.04 84 0 254 1.26
JYDATA /dev/rcdld_jydata03 222 0 1.98 1.05 86 0 15 5.33
JYDATA /dev/rcdld_jydata04 1,436 0 3.05 1.00 79 0 0 0.00
JYINDEX /dev/rcdld_jyindex01 3,584 1 2.38 1.00 636 0 0 0.00
JYLOBDATA /dev/rcdld_jylobdata 108 0 0.19 1.00 1 0 0 0.00
JYSHORTDATA /dev/rcdld_jyshortdat 58 0 0.86 1.00 6 0 0 0.00
JYTEMP /dev/rcdld_jytemp 0 0     9 0 0  
LDGGSJ /dev/rcdld_gongan 727 0 5.19 1.00 8 0 0 0.00
LDJG /dev/rcdld_ldjg01 1 0 10.00 1.00 0 0 0 0.00
NNC_DATA01 /dev/rnnc_data01 84,936 23 0.41 1.38 4 0 0 0.00
NNC_DATA01 /dev/rnnc_data1_1 40,666 11 0.42 1.12 0 0 0 0.00
NNC_DATA01 /dev/rnnc_data1_2 43,547 12 0.29 1.00 0 0 0 0.00
NNC_DATA02 /dev/rnnc_data02 25 0 4.40 1.00 0 0 0 0.00
NNC_DATA03 /dev/rnnc_data03 30 0 4.67 1.00 9 0 0 0.00
NNC_INDEX01 /dev/rnnc_ind01_01 93 0 5.27 1.00 2 0 0 0.00
NNC_INDEX01 /dev/rnnc_index01 167 0 5.63 1.00 1 0 0 0.00
NNC_INDEX02 /dev/rnnc_index02 33 0 5.76 1.12 0 0 9 3.33
NNC_INDEX03 /dev/rnnc_index03 20 0 5.50 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor1 2,881 1 1.85 1.00 397 0 0 0.00
SHORDATA /dev/rcdld_sbshor10 4,551 1 1.66 1.00 422 0 0 0.00
SHORDATA /dev/rcdld_sbshor11 4,369 1 1.57 1.00 475 0 0 0.00
SHORDATA /dev/rcdld_sbshor12 2,889 1 1.37 1.00 177 0 0 0.00
SHORDATA /dev/rcdld_sbshor13 3,216 1 1.72 1.00 341 0 0 0.00
SHORDATA /dev/rcdld_sbshor14 4,655 1 1.80 1.00 439 0 0 0.00
SHORDATA /dev/rcdld_sbshor15 3,905 1 1.73 1.00 344 0 0 0.00
SHORDATA /dev/rcdld_sbshor16 4,271 1 1.46 1.00 438 0 0 0.00
SHORDATA /dev/rcdld_sbshor17 3,031 1 1.58 1.00 353 0 0 0.00
SHORDATA /dev/rcdld_sbshor18 3,933 1 1.24 1.00 232 0 0 0.00
SHORDATA /dev/rcdld_sbshor19 4,059 1 1.55 1.00 422 0 0 0.00
SHORDATA /dev/rcdld_sbshor2 3,305 1 1.93 1.00 440 0 0 0.00
SHORDATA /dev/rcdld_sbshor20 3,437 1 1.73 1.00 341 0 0 0.00
SHORDATA /dev/rcdld_sbshor21 4,138 1 1.69 1.00 471 0 0 0.00
SHORDATA /dev/rcdld_sbshor22 2,133 1 1.95 1.00 215 0 0 0.00
SHORDATA /dev/rcdld_sbshor23 4,671 1 1.37 1.00 474 0 0 0.00
SHORDATA /dev/rcdld_sbshor24 4,475 1 1.40 1.00 223 0 0 0.00
SHORDATA /dev/rcdld_sbshor25 4 0 2.50 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor26 4 0 0.00 1.00 3 0 0 0.00
SHORDATA /dev/rcdld_sbshor27 8 0 2.50 1.00 4 0 0 0.00
SHORDATA /dev/rcdld_sbshor28 5 0 2.00 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor29 6 0 3.33 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor3 2,952 1 2.04 1.00 375 0 0 0.00
SHORDATA /dev/rcdld_sbshor30 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor31 7 0 2.86 1.00 3 0 0 0.00
SHORDATA /dev/rcdld_sbshor32 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor33 375 0 0.24 1.01 17 0 0 0.00
SHORDATA /dev/rcdld_sbshor34 110 0 0.36 1.00 3 0 0 0.00
SHORDATA /dev/rcdld_sbshor35 60 0 0.67 1.00 18 0 3 0.00
SHORDATA /dev/rcdld_sbshor36 161 0 0.25 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor37 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor38 369 0 0.19 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor39 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor4 2,573 1 2.14 1.00 196 0 0 0.00
SHORDATA /dev/rcdld_sbshor40 369 0 0.22 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor41 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor42 526 0 0.19 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor43 5 0 2.00 1.00 3 0 0 0.00
SHORDATA /dev/rcdld_sbshor44 5 0 2.00 1.00 10 0 0 0.00
SHORDATA /dev/rcdld_sbshor45 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor46 57 0 0.53 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor47 370 0 0.30 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor48 6 0 1.67 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor49 162 0 0.43 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor5 3,103 1 1.77 1.00 247 0 0 0.00
SHORDATA /dev/rcdld_sbshor50 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor51 58 0 0.52 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor52 5 0 2.00 1.00 3 0 0 0.00
SHORDATA /dev/rcdld_sbshor53 6 0 3.33 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor54 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor55 161 0 0.50 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor56 114 0 0.79 1.15 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor57 111 0 0.45 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor58 5 0 2.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor59 110 0 0.36 1.00 3 0 0 0.00
SHORDATA /dev/rcdld_sbshor6 2,579 1 1.56 1.00 154 0 0 0.00
SHORDATA /dev/rcdld_sbshor60 111 0 0.27 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor61 264 0 0.19 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor62 214 0 0.28 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor63 57 0 0.35 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor64 4 0 2.50 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor65 110 0 0.36 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor66 108 0 0.19 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor67 6 0 5.00 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor68 6 0 5.00 1.00 12 0 0 0.00
SHORDATA /dev/rcdld_sbshor69 5 0 4.00 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor7 2,614 1 1.74 1.00 270 0 0 0.00
SHORDATA /dev/rcdld_sbshor70 62 0 0.48 1.00 3 0 0 0.00
SHORDATA /dev/rcdld_sbshor71 56 0 0.18 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor72 1,666 0 0.19 1.01 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor73 261 0 0.11 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor74 52 0 0.19 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor75 52 0 0.00 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor76 52 0 0.58 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor78 53 0 0.57 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor79 104 0 0.19 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor8 3,461 1 1.64 1.00 359 0 0 0.00
SHORDATA /dev/rcdld_sbshor82 260 0 0.15 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor83 416 0 0.19 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor84 159 0 0.31 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor85 2 0 0.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor86 413 0 0.56 1.00 28 0 0 0.00
SHORDATA /dev/rcdld_sbshor87 685 0 0.77 1.08 122 0 0 0.00
SHORDATA /dev/rcdld_sbshor88 6 0 15.00 12.17 24 0 0 0.00
SHORDATA /dev/rcdld_sbshor89 156 0 0.06 1.00 3 0 0 0.00
SHORDATA /dev/rcdld_sbshor9 2,654 1 1.62 1.00 246 0 0 0.00
SHORDATA /dev/rcdld_sbshor90 176 0 1.14 1.60 78 0 0 0.00
SHORDATA /dev/rcdld_sbshor91 104 0 0.19 1.00 2 0 0 0.00
SHORDATA /dev/rcdld_sbshor92 0 0     1 0 0 0.00
SHORDATA /dev/rcdld_sbshor93 52 0 0.00 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor94 104 0 0.00 1.00 0 0 0 0.00
SHORDATA /dev/rcdld_sbshor95 578 0 0.22 1.01 36 0 0 0.00
SHORDATA /dev/rcdld_sbshor96 52 0 0.00 1.00 1 0 0 0.00
SHORDATA /dev/rcdld_sbshor97 52 0 0.38 1.00 0 0 0 0.00
SYBX_DATA /dev/rcdld_sydata02 3 0 3.33 1.00 1 0 0 0.00
SYSAUX /dev/rcdld_sysaux01 471 0 3.76 1.05 649 0 45 0.67
SYSAUX /dev/rcdld_sysaux02 438 0 3.20 1.04 414 0 0 0.00
SYSAUX /dev/rcdld_sysaux03 535 0 2.32 1.00 381 0 0 0.00
SYSAUX /dev/rcdld_sysaux04 273 0 2.97 1.01 258 0 0 0.00
SYSAUX /dev/rcdld_sysaux05 423 0 2.51 1.01 331 0 17 0.59
SYSAUX /dev/rcdld_sysaux06 318 0 3.68 1.03 297 0 0 0.00
SYSTEM /dev/rcdld_system01 220 0 2.14 1.00 300 0 0 0.00
SYSTEM /dev/rcdld_system02 49 0 5.10 1.00 139 0 0 0.00
SYSTEM /dev/rcdld_system03 30 0 6.67 1.00 104 0 0 0.00
TEMP /dev/rcdld_temp01 139 0 3.53 2.73 184 0 0  
TEMP /dev/rcdld_temp02 44 0 4.32 1.23 231 0 0  
TEMP /dev/rcdld_temp03 325 0 2.18 2.14 337 0 0  
TEMP /dev/rcdld_temp05 432 0 2.52 2.93 317 0 0  
TEMPDATA /dev/rtempdata01 161 0 0.19 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata02 57 0 0.35 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata03 57 0 0.70 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata04 5 0 2.00 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata05 57 0 0.53 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata06 265 0 0.23 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata07 5 0 2.00 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata08 5 0 2.00 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata09 57 0 0.53 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata10 4 0 2.50 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata11 4 0 2.50 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata12 4 0 2.50 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata13 56 0 0.18 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata14 5 0 2.00 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata15 5 0 2.00 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata16 5 0 2.00 1.00 1 0 0 0.00
TEMPDATA /dev/rtempdata29 108 0 0.37 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata30 160 0 0.25 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata31 56 0 0.18 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata32 107 0 0.19 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata33 159 0 0.50 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata34 107 0 0.28 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata35 3 0 3.33 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata36 107 0 0.37 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata37 3 0 3.33 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata38 107 0 0.19 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata39 211 0 0.19 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata40 3 0 3.33 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata41 107 0 0.37 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata42 55 0 0.36 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata43 55 0 0.18 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata44 3 0 3.33 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata45 55 0 0.18 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata46 55 0 0.55 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata47 3 0 3.33 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata48 55 0 0.18 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata49 55 0 0.36 1.00 0 0 0 0.00
TEMPDATA /dev/rtempdata50 3 0 3.33 1.00 0 0 0 0.00
UNDOTBS1 /dev/rcdld_undo01_01 20 0 3.50 1.00 8,497 2 54 0.00
UNDOTBS1 /dev/rcdld_undo01_02 19 0 4.21 1.00 6,337 2 32 0.00
UNDOTBS1 /dev/rcdld_undo01_03 5 0 6.00 1.00 5,100 1 24 0.00
UNDOTBS1 /dev/rcdld_undo01_04 13 0 6.15 1.00 4,344 1 3 0.00
UNDOTBS1 /dev/rcdld_undo01_05 17 0 4.12 1.00 5,102 1 0 0.00
USERS /dev/rcdld_users01 649 0 0.31 1.01 0 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 9,579,648 100 -3,681,275,002 3,137,608 1,089,138 0 0 66,801


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 131 193821 501564 10548958 15092100 10548958  
E 0 37 46852 431162 2296611 15092100 2296611  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 7,984 0.10 957,581 3.49 11,017,975,129
D 15,968 0.20 1,915,162 2.02 6,378,631,455
D 23,952 0.30 2,872,743 1.48 4,668,081,895
D 31,936 0.40 3,830,324 1.30 4,099,378,895
D 39,920 0.50 4,787,905 1.20 3,779,259,326
D 47,904 0.60 5,745,486 1.13 3,575,189,277
D 55,888 0.70 6,703,067 1.09 3,430,907,233
D 63,872 0.80 7,660,648 1.05 3,322,146,110
D 71,856 0.90 8,618,229 1.02 3,230,928,979
D 79,840 1.00 9,575,810 1.00 3,155,884,019
D 79,872 1.00 9,579,648 1.00 3,155,595,070
D 87,824 1.10 10,533,391 0.98 3,094,486,971
D 95,808 1.20 11,490,972 0.97 3,046,210,300
D 103,792 1.30 12,448,553 0.95 3,008,338,436
D 111,776 1.40 13,406,134 0.94 2,969,470,919
D 119,760 1.50 14,363,715 0.93 2,935,182,752
D 127,744 1.60 15,321,296 0.92 2,904,986,925
D 135,728 1.70 16,278,877 0.91 2,879,610,249
D 143,712 1.80 17,236,458 0.91 2,856,944,462
D 151,696 1.90 18,194,039 0.90 2,835,282,637
D 159,680 2.00 19,151,620 0.87 2,733,288,296

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 20,480 14,481 7,057.98 273.75 3.88 100.00 0.00 1,048,576
E 20,480 14,942 6,357.66 307.61 4.84 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 530,106 530,106 0 0
64K 128K 3,822 3,822 0 0
128K 256K 1,433 1,433 0 0
256K 512K 250 250 0 0
512K 1024K 7,691 7,691 0 0
1M 2M 7,848 7,848 0 0
2M 4M 373 373 0 0
4M 8M 4 4 0 0
8M 16M 4 4 0 0
16M 32M 63 63 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
2,560 0.13 20,182,535.30 3,015,060.57 87.00 74,324
5,120 0.25 20,182,535.30 1,176,966.37 94.00 2,305
10,240 0.50 20,182,535.30 644,663.64 97.00 0
15,360 0.75 20,182,535.30 644,663.64 97.00 0
20,480 1.00 20,182,535.30 518,731.58 97.00 0
24,576 1.20 20,182,535.30 421,530.99 98.00 0
28,672 1.40 20,182,535.30 421,530.99 98.00 0
32,768 1.60 20,182,535.30 421,530.99 98.00 0
36,864 1.80 20,182,535.30 421,530.99 98.00 0
40,960 2.00 20,182,535.30 421,530.99 98.00 0
61,440 3.00 20,182,535.30 421,530.99 98.00 0
81,920 4.00 20,182,535.30 421,530.99 98.00 0
122,880 6.00 20,182,535.30 421,530.99 98.00 0
163,840 8.00 20,182,535.30 421,530.99 98.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
12,304 0.60 2,277 140,276 67,275,065 0.99 532,774 3.94 3,847,515,967
14,352 0.70 4,227 199,509 67,587,598 1.00 220,241 1.63 3,848,431,542
16,400 0.80 6,268 256,529 67,631,448 1.00 176,391 1.30 3,848,579,847
18,448 0.90 8,295 325,601 67,657,145 1.00 150,694 1.11 3,848,660,405
20,496 1.00 10,333 390,811 67,672,560 1.00 135,279 1.00 3,848,723,297
22,544 1.10 12,379 460,650 67,678,970 1.00 128,869 0.95 3,848,760,653
24,592 1.20 14,423 536,833 67,686,463 1.00 121,376 0.90 3,848,788,038
26,640 1.30 16,468 619,472 67,686,806 1.00 121,033 0.89 3,848,807,425
28,688 1.40 18,513 684,519 67,690,384 1.00 117,455 0.87 3,848,821,688
30,736 1.50 20,558 750,427 67,691,245 1.00 116,594 0.86 3,848,833,811
32,784 1.60 22,604 826,139 67,691,378 1.00 116,461 0.86 3,848,844,704
34,832 1.70 24,651 897,082 67,692,005 1.00 115,834 0.86 3,848,855,499
36,880 1.80 26,698 975,599 67,692,063 1.00 115,776 0.86 3,848,863,569
38,928 1.90 28,745 1,055,841 67,696,357 1.00 111,482 0.82 3,848,871,138
40,976 2.00 30,791 1,148,908 67,696,432 1.00 111,407 0.82 3,848,877,879

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
384 0.19 0 0 0 0
592 0.29 0 0 0 0
800 0.39 0 0 0 0
1,008 0.49 0 0 0 0
1,216 0.59 0 0 0 0
1,424 0.70 0 0 0 0
1,632 0.80 0 0 0 0
1,840 0.90 0 0 0 0
2,048 1.00 0 0 0 0
2,256 1.10 0 0 0 0
2,464 1.20 0 0 0 0
2,672 1.30 0 0 0 0
2,880 1.41 0 0 0 0
3,088 1.51 0 0 0 0
3,296 1.61 0 0 0 0
3,504 1.71 0 0 0 0
3,712 1.81 0 0 0 0
3,920 1.91 0 0 0 0
4,128 2.02 0 0 0 0
4,336 2.12 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 63,248 72 1
segment header 3,441 8 2
1st level bmb 5 0 8
undo header 101 0 0
undo block 12 0 0
2nd level bmb 4 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
PS-PX Process Reservation 474 456 18 387 145 374.84
TX-Transaction (row lock contention) 312 312 0 5 32 6,499.80
TT-Tablespace 204,057 204,056 0 4,183 2 0.45
TO-Temp Object 3,212 3,212 0 2,011 1 0.56
CF-Controlfile Transaction 14,492 14,492 0 1,265 1 0.66
TM-DML 67,937 67,937 0 974 1 0.58
TX-Transaction (index contention) 1,726 1,726 0 35 0 9.06
JQ-Job Queue 119 79 40 63 0 1.32
HW-Segment High Water Mark 16,919 16,919 0 165 0 0.36
FB-Format Block 275 275 0 117 0 0.50
SQ-Sequence Cache 13,126 13,126 0 47 0 0.47
TA-Instance Undo 25 25 0 25 0 0.52
US-Undo Segment 21 21 0 13 0 0.46
WF-AWR Flush 19 19 0 11 0 0.55
PI-Remote PX Process Spawn Status 9 9 0 9 0 0.44
WR-LNS archiving log 6 6 0 3 0 0.33
AF-Advisor Framework (task serialization) 7 7 0 1 0 1.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 1 1 0 1 0 1.00
WL-Being Written Redo Log 6 6 0 3 0 0.00
JD-Job Queue Date 796 796 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 5,062 0.00   0 0  
AWR Alerted Metric Element list 112,889 0.00   0 0  
Consistent RBA 25,319 0.03 0.00 0 0  
FAL request queue 108 0.00   0 0  
FAL subheap alocation 108 0.00   0 0  
FIB s.o chain latch 132 0.00   0 0  
FOB s.o list latch 54,197 0.01 0.00 0 0  
JS broadcast add buf latch 827 0.00   0 0  
JS broadcast drop buf latch 827 0.00   0 0  
JS broadcast load blnc latch 724 0.00   0 0  
JS queue state obj latch 21,720 0.00   0 0  
JS slv state obj latch 117 0.00   0 0  
KCL gc element parent latch 18,274,674 0.02 0.15 0 791 0.00
KJC message pool free list 102,632 0.06 0.00 0 55,847 0.00
KJCT flow control latch 5,045,303 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 1,214 0.00   0 0  
KPON ksr channel latch 728 0.00   0 0  
KSXR large replies 242 0.00   0 0  
KTF sga latch 24 0.00   0 1,222 0.00
KWQMN job cache list latch 990 0.61 0.67 0 0  
KWQP Prop Status 2 0.00   0 0  
LGWR NS Write 948 0.11 0.00 0 0  
Memory Management Latch 0     0 1,214 0.00
OS process 41,601 0.00   0 0  
OS process allocation 28,757 0.02 0.00 0 0  
OS process: request allocation 27,343 0.03 0.00 0 0  
PL/SQL warning settings 17,318 0.00   0 0  
SGA IO buffer pool latch 18,703 0.01 0.00 0 18,703 0.00
SQL memory manager latch 1 0.00   0 1,211 0.00
SQL memory manager workarea list latch 1,471,757 0.00 0.00 0 0  
Shared B-Tree 149 0.00   0 0  
active checkpoint queue latch 169,531 0.04 0.00 0 0  
active service list 60,065 0.02 0.07 0 3,301 0.00
archive control 276 0.00   0 0  
archive process latch 1,439 0.00   0 0  
begin backup scn array 959 0.00   0 0  
business card 36 0.00   0 0  
cache buffer handles 76,281 0.02 0.00 0 0  
cache buffers chains 1,205,068,507 0.08 0.03 1 16,555,255 0.01
cache buffers lru chain 3,217,930 0.02 0.01 0 19,716,276 0.02
cache table scan latch 0     0 170,450 0.01
channel anchor 1,456 0.00   0 0  
channel handle pool latch 38,674 0.02 0.00 0 0  
channel operations parent latch 2,254,587 0.07 0.00 0 0  
checkpoint queue latch 12,897,694 0.00 0.00 0 937,349 0.00
client/application info 85,027 0.00   0 0  
commit callback allocation 5,001 0.00   0 0  
compile environment latch 13,943 0.00   0 0  
dml lock allocation 135,559 0.01 0.00 0 0  
dummy allocation 28,075 0.03 0.00 0 0  
enqueue hash chains 2,352,202 0.01 0.00 0 5,106 0.00
enqueues 1,566,610 0.05 0.00 0 0  
error message lists 78 0.00   0 0  
event group latch 13,576 0.00   0 0  
file cache latch 7,905 0.00   0 0  
gcs opaque info freelist 110,022 0.01 0.00 0 0  
gcs partitioned table hash 240,445 0.00   0 0  
gcs resource freelist 3,320,176 0.00 0.00 0 226,565 0.00
gcs resource hash 10,537,859 0.00 0.00 0 0  
gcs shadows freelist 206,681 0.00   0 235,693 0.00
ges caches resource lists 957,467 0.11 0.00 0 691,666 0.11
ges deadlock list 72,114 0.00   0 35 0.00
ges domain table 823,425 0.00 0.00 0 0  
ges enqueue table freelist 917,591 0.00   0 0  
ges group table 1,219,849 0.00 0.00 0 0  
ges process hash list 98,198 0.00   0 0  
ges process parent latch 1,837,518 0.00   0 0  
ges process table freelist 27,343 0.01 0.00 0 0  
ges resource hash list 1,556,121 0.03 0.00 0 125,663 0.04
ges resource scan list 342 0.00   0 0  
ges resource table freelist 237,923 0.01 0.00 0 0  
ges timeout list 3,264 0.00   0 2,552 0.00
global KZLD latch for mem in SGA 13,463 0.00   0 0  
global tx hash mapping 148 0.00   0 0  
hash table column usage latch 1,793 0.00   0 251,223 0.00
hash table modification latch 186 0.00   0 0  
job workq parent latch 0     0 146 0.00
job_queue_processes parameter latch 133 0.00   0 0  
kks stats 16,614 0.00   0 0  
kokc descriptor allocation latch 2,018 0.00   0 0  
ksuosstats global area 532 0.00   0 0  
ktm global data 40,602 0.00   0 0  
kwqbsn:qsga 148 0.00   0 0  
lgwr LWN SCN 25,319 0.04 0.00 0 0  
library cache 3,685,503 0.01 0.00 0 11,494 0.00
library cache load lock 1,464 0.00   0 0  
library cache lock 1,352,112 0.01 0.00 0 0  
library cache lock allocation 58,487 0.00   0 0  
library cache pin 1,627,096 0.00 0.00 0 0  
library cache pin allocation 9,394 0.00   0 0  
list of block allocation 38,084 0.01 0.00 0 0  
loader state object freelist 7,906 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 1,455 0.00   0 20 0.00
message pool operations parent latch 85,893 0.00 0.00 0 0  
messages 779,343 0.06 0.00 0 0  
mostly latch-free SCN 27,105 5.93 0.00 0 0  
multiblock read objects 828,276 0.01 0.00 0 0  
name-service memory objects 47,695 0.00   0 0  
name-service namespace bucket 54,785 0.00   0 0  
name-service pending queue 17,432 0.00   0 0  
name-service request 54 0.00   0 0  
name-service request queue 60,668 0.00   0 0  
ncodef allocation latch 61 0.00   0 0  
object queue header heap 231,884 0.00   0 238,701 0.00
object queue header operation 17,786,852 0.04 0.00 0 0  
object stats modification 11,468 0.01 0.00 0 0  
parallel query alloc buffer 3,500 0.00   0 0  
parallel query stats 410 0.00   0 0  
parallel txn reco latch 64,368 0.00   0 0  
parameter list 533 1.13 0.00 0 0  
parameter table allocation management 44,269 0.02 0.56 0 0  
post/wait queue 88,271 0.00 0.00 0 12,449 0.00
process allocation 58,181 0.24 0.01 0 13,515 0.45
process group creation 27,344 0.02 0.00 0 0  
process queue 1,204 0.00   0 0  
process queue reference 31,915 0.00   0 3,107 0.00
qmn task queue latch 1,045 24.50 0.00 0 0  
query server freelists 846 0.00   0 0  
query server process 9 0.00   0 9 0.00
queued dump request 18,187 0.00   0 0  
redo allocation 440,337 0.05 0.00 0 10,896,153 0.05
redo copy 0     0 10,897,613 0.00
redo writing 257,225 0.02 0.00 0 0  
resmgr group change latch 14,354 0.00   0 0  
resmgr:active threads 28,070 0.00   0 0  
resmgr:actses change group 13,894 0.00   0 0  
resmgr:free threads list 28,070 0.04 0.00 0 0  
row cache objects 5,307,678 0.03 0.00 0 297 0.00
rules engine rule set statistics 100 0.00   0 0  
sequence cache 1,088,430 0.01 0.00 0 0  
session allocation 8,325,732 0.10 0.00 0 0  
session idle bit 5,419,120 0.00 0.00 0 0  
session state list latch 29,657 0.05 0.00 0 0  
session switching 61 0.00   0 0  
session timer 1,266 0.00   0 0  
shared pool 1,465,398 0.03 0.01 0 0  
shared pool simulator 9,223,820 0.02 0.00 0 0  
simulator hash latch 43,577,520 0.00 0.00 0 0  
simulator lru latch 0     0 42,925,358 0.21
slave class 2 0.00   0 0  
slave class create 8 12.50 1.00 0 0  
sort extent pool 76,689 1.03 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 504 0.00   0 0  
temp lob duration state obj allocation 5 0.00   0 0  
temporary table state object allocation 422 0.00   0 0  
threshold alerts latch 892 0.00   0 0  
transaction allocation 9,847,005 0.00 0.00 0 0  
transaction branch allocation 1,392 0.00   0 0  
undo global data 33,117,436 0.00 0.00 0 0  
user lock 54,395 0.05 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 1,205,068,507 1,018,266 32,662 986,659 0 0 0
session allocation 8,325,732 7,915 12 7,903 0 0 0
object queue header operation 17,786,852 6,727 17 6,711 0 0 0
KCL gc element parent latch 18,274,674 2,909 424 2,490 0 0 0
channel operations parent latch 2,254,587 1,556 1 1,555 0 0 0
cache buffers lru chain 3,217,930 599 4 595 0 0 0
shared pool 1,465,398 367 3 364 0 0 0
qmn task queue latch 1,045 256 1 255 0 0 0
process allocation 58,181 142 2 140 0 0 0
active service list 60,065 15 1 14 0 0 0
parameter table allocation management 44,269 9 5 4 0 0 0
KWQMN job cache list latch 990 6 4 3 0 0 0
slave class create 8 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclnfndnewm 0 1,138 182
KCL gc element parent latch kclnfnd 0 4 0
KCL gc element parent latch kclhngcbk1 0 3 0
KCL gc element parent latch kclplz 0 3 258
KCL gc element parent latch kclwrt 0 3 0
KCL gc element parent latch kclbla 0 2 0
KCL gc element parent latch KCLUNLNK 0 1 216
KWQMN job cache list latch kwqmnprsc: loop 0 3 0
KWQMN job cache list latch kwqmnuji: update job item 0 1 1
active service list ksws_event: ksws event 0 8 8
cache buffers chains kcbgtcr: kslbegin excl 0 56,662 56,388
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 2,814 869
cache buffers chains kcbrls: kslbegin 0 1,468 4,165
cache buffers chains kcbzgb: scan from tail. nowait 0 1,174 0
cache buffers chains kcbzwb 0 96 216
cache buffers chains kclebs_1 0 32 128
cache buffers chains kcbgtcr: fast path 0 30 19
cache buffers chains kcbget: pin buffer 0 17 11
cache buffers chains kcbgtcr: kslbegin shared 0 17 11
cache buffers chains kclwrt 0 9 0
cache buffers chains kcbbxsv 0 5 12
cache buffers chains kcbgcur: kslbegin 0 4 0
cache buffers chains kcbzib: multi-block read: nowait 0 2 0
cache buffers chains kcbchg: kslbegin: call CR func 0 1 455
cache buffers chains kclbla 0 1 0
cache buffers lru chain kcbzgws 0 4 0
channel handle pool latch ksrchconnect() 0 1 1
channel operations parent latch ksrchdelete() 0 2 0
channel operations parent latch ksrwait() 0 1 3
event range base latch No latch 0 5 1
object queue header operation kcbo_ivbo 0 495 443
object queue header operation kcbw_link_q 0 5 21
object queue header operation kcbo_switch_cq 0 4 4
object queue header operation kcbw_unlink_q 0 3 26
object queue header operation kcbo_switch_mq_bg 0 1 6
parameter table allocation management ksp_param_table_free 0 4 0
process allocation ksucrp 0 2 0
session allocation ksufap: active sessions 0 7 0
session allocation ksuxds: not user session 0 2 0
session allocation ksucri 0 1 3
session allocation ksucrp 0 1 0
session allocation ksudlc 0 1 8
shared pool kghupr1 0 3 2
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
CDSI2 DATA KB17K1   TABLE 161,848,160 26.37
LDZC CDLDZC FB01   TABLE 71,856,192 11.71
CDJY JYDATA CC72   TABLE 54,845,280 8.94
SYS SYSTEM CDEF$   TABLE 26,155,552 4.26
SYS SYSTEM I_CDEF1   INDEX 26,075,808 4.25

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
CDSI2 DATA KC82K1   TABLE 579,801 18.46
CDSI2 DATA AC05   TABLE 301,621 9.60
CDSI2 DATA AC16   TABLE 298,561 9.51
CDSI2 DATA IDX$$_298D60001   INDEX 33,944 1.08
CDSI2 DATA IDX_AC02_T_AAC001_AAE140   INDEX 24,505 0.78

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
CDSI2 DATA IDX_KC60K1_11   INDEX 14,888 45.37
CDSI2 DATA INDEX_KC82K1_04   INDEX 14,031 42.76
CDSI2 DATA IDX_KC60K1_01   INDEX 2,420 7.38
CDSI2 DATA INDEX_KC82K1_05   INDEX 166 0.51
CDSI2 DATA IDX$$_3CB90002   INDEX 122 0.37

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
CDSI2 DATA SYS_C00190575   INDEX 8 24.24
CDSI2 DATA IDX_AE09_AAE211   INDEX 4 12.12
CDSI2 DATA R_61_FK   INDEX 4 12.12
CDSI2 DATA IDX_KC82K1_AAC001_YAC212   INDEX 2 6.06
CDSI2 DATA INDEX_KC82K1_02   INDEX 2 6.06

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
CDSI2 DATA KC82K1   TABLE 212 94.22
CDSI2 DATA PK_KC82K1   INDEX 11 4.89
CDSI2 DATA PK_KC82K2   INDEX 2 0.89

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
CDSI2 DATA AC05   TABLE 36,842 64.53
CDSI2 DATA KC82K1   TABLE 13,428 23.52
CDSI2 DATA IDX$$_298D60001   INDEX 3,181 5.57
CDSI2 DATA IDX_AC05_01   INDEX 2,203 3.86
CDSI2 DATA LC24K1   TABLE 506 0.89

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
CDSI2 DATA IDX_AC02_T_AAC001_AAE140   INDEX 98 4.00
CDSI2 DATA AC01   TABLE 94 3.84
CDSI2 DATA PK_KC24K1_11   INDEX 45 1.84
CDSI2 DATA IDX$$_298D60001   INDEX 44 1.80
CDSI2 DATA PK_AC02_T_NEW   INDEX 24 0.98

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
CDJY JYDATA CC03   TABLE 27,801 30.68
CDJY JYDATA JC10   TABLE 11,235 12.40
CDSI2 DATA IDX_AC02_T_AAC001_AAE140   INDEX 7,914 8.73
CDJY JYDATA JC14   TABLE 6,225 6.87
CDSI2 DATA PK_KC01   INDEX 4,964 5.48

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 61 3.28 0   0 1
dc_database_links 26,922 0.00 0   0 2
dc_files 21,520 0.00 0   0 538
dc_global_oids 2,535 0.00 0   0 73
dc_histogram_data 190,028 0.01 0   0 56,943
dc_histogram_defs 70,255 0.09 0   0 51,133
dc_object_grants 375 0.00 0   0 261
dc_object_ids 199,818 0.00 0   0 9,778
dc_objects 29,289 0.11 0   0 9,320
dc_profiles 13,533 0.00 0   0 1
dc_rollback_segments 88,770 0.00 0   0 2,685
dc_segments 32,026 0.02 0   13 11,706
dc_sequences 13,110 0.12 0   13,110 168
dc_tablespace_quotas 5 80.00 0   1 8
dc_tablespaces 502,062 0.00 0   0 34
dc_usernames 68,978 0.01 0   0 20
dc_users 696,456 0.00 0   0 47
outstanding_alerts 418 89.00 0   0 66

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 2 2 0
dc_histogram_defs 65 0 218
dc_object_ids 9 0 14
dc_objects 32 0 73
dc_segments 34 6 39
dc_sequences 26,220 20 0
dc_tablespace_quotas 10 4 1
dc_usernames 4 0 2
dc_users 3 0 1
outstanding_alerts 816 372 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 2,704 0.04 58,604 0.01 4 0
CLUSTER 11 0.00 15 0.00 0 0
INDEX 227 0.44 397 0.25 0 0
SQL AREA 182,658 27.04 13,389,964 0.48 32,351 585
TABLE/PROCEDURE 61,229 0.24 721,960 0.10 416 0
TRIGGER 146 0.00 1,201 0.17 2 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 15 0 0 0 0
INDEX 397 1 2 1 0
TABLE/PROCEDURE 99,319 149 166 2 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,379.85   4.02 19.38 691 691 1,338 1,337
  Freeable 914.00 0.00 1.00 0.70 14   917 917
  SQL 707.91 504.64 0.55 2.06 47 1,447 1,278 1,202
  PL/SQL 114.74 39.95 0.09 1.57 57 57 1,337 1,335
E Other 4,831.55   4.21 20.90 691 691 1,147 1,146
  Freeable 799.81 0.00 1.01 0.74 14   790 790
  SQL 677.31 506.86 0.62 2.44 47 1,447 1,089 1,049
  PL/SQL 106.37 34.67 0.09 1.69 57 57 1,148 1,147

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 128.00 128.00 0.00
large free memory 128.00 128.00 0.00
shared CCursor 2,202.78 2,200.30 -0.11
shared PCursor 603.86 603.45 -0.07
shared db_block_hash_buckets 720.00 720.00 0.00
shared free memory 2,105.91 2,112.11 0.29
shared gcs resources 1,720.14 1,720.14 0.00
shared gcs shadows 1,030.03 1,030.03 0.00
shared kkj jobq wor 1,704.12 1,704.12 0.00
shared library cache 726.31 726.08 -0.03
shared sql area 6,980.07 6,999.19 0.27
shared sql area:PLSQL 1,006.70 990.67 -1.59
streams free memory 2,047.99 2,047.99 0.00
  buffer_cache 79,872.00 79,872.00 0.00
  fixed_sga 2.19 2.19 0.00
  log_buffer 269.81 269.81 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 1,016,859 28,204 0
QMON Coordinator 233,673 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 2,970,536 10,765,702 11132041 11132041
gcs_shadows 6,983,950 10,816,241 11132041 11132041


Back to Top

init.ora Parameters

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


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 89,005 24.44 1.84
acks for commit broadcast(logical) 110,785 30.43 2.29
broadcast msgs on commit(actual) 24,001 6.59 0.50
broadcast msgs on commit(logical) 25,253 6.94 0.52
broadcast msgs on commit(wasted) 4,898 1.35 0.10
broadcast on commit wait time(ms) 1,915 0.53 0.04
broadcast on commit waits 14,515 3.99 0.30
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 1 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 9,309 2.56 0.19
gcs ast xid 0 0.00 0.00
gcs blocked converts 6,802 1.87 0.14
gcs blocked cr converts 5,890 1.62 0.12
gcs compatible basts 254 0.07 0.01
gcs compatible cr basts (global) 229 0.06 0.00
gcs compatible cr basts (local) 51,600 14.17 1.07
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 640 0.18 0.01
gcs dbwr write request msgs 312 0.09 0.01
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 60,391 16.59 1.25
gcs immediate (null) converts 265,801 73.00 5.49
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 1,532,349 420.84 31.65
gcs indirect ast 243,476 66.87 5.03
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 74 0.02 0.00
gcs msgs process time(ms) 15,053 4.13 0.31
gcs msgs received 1,302,545 357.72 26.90
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 0 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 0 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 1 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 1 0.00 0.00
gcs side channel msgs actual 260,697 71.60 5.38
gcs side channel msgs logical 1,278,857 351.22 26.41
gcs stale cr 0 0.00 0.00
gcs undo cr 0 0.00 0.00
gcs write notification msgs 35 0.01 0.00
gcs writes refused 0 0.00 0.00
ges msgs process time(ms) 1,670 0.46 0.03
ges msgs received 152,162 41.79 3.14
global posts dropped 0 0.00 0.00
global posts queue time 2 0.00 0.00
global posts queued 11 0.00 0.00
global posts requested 11 0.00 0.00
global posts sent 11 0.00 0.00
implicit batch messages received 91,937 25.25 1.90
implicit batch messages sent 346,230 95.09 7.15
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 28,981 7.96 0.60
messages queue sent actual 1,260,156 346.08 26.03
messages queue sent logical 1,812,914 497.89 37.44
messages received actual 968,112 265.88 19.99
messages received logical 1,454,727 399.52 30.04
messages sent directly 1,313,819 360.82 27.13
messages sent indirectly 1,744,272 479.04 36.02
messages sent not implicit batched 913,969 251.01 18.88
messages sent pbatched 647,499 177.83 13.37
msgs causing lmd to send msgs 56,254 15.45 1.16
msgs causing lms(s) to send msgs 2,333 0.64 0.05
msgs received queue time (ms) 7,981 2.19 0.16
msgs received queued 1,454,730 399.52 30.04
msgs sent queue time (ms) 22,706 6.24 0.47
msgs sent queue time on ksxp (ms) 697,399 191.53 14.40
msgs sent queued 1,811,693 497.55 37.42
msgs sent queued on ksxp 2,754,757 756.55 56.89
process batch messages received 199,623 54.82 4.12
process batch messages sent 266,097 73.08 5.50


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 9,070
CURRENT Block Requests 513
Data Block Requests 9,070
Undo Block Requests 150
TX Block Requests 252
Current Results 9,103
Private results 194
Zero Results 284
Disk Read Results 0
Fail Results 0
Fairness Down Converts 1,762
Fairness Clears 0
Free GC Elements 0
Flushes 134
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 8
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 18,936 99.86 0.01 0.13 0.00 0.00
Flushes 130 59.23 40.77 0.00 0.00 0.00
Writes 734 55.04 39.78 0.82 2.18 2.18


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 2,310 99.31 0.69 0.00 90,053 99.97 0.03 0.01
2 Others 95 100.00 0.00 0.00 485 99.79 0.21 0.00
2 undo header 43 100.00 0.00 0.00 1 100.00 0.00 0.00
2 undo block 3 100.00 0.00 0.00 0      


Back to Top

End of Report