WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
CDLD2217133725cdld2210.2.0.4.0YESp780b

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:6549716-Jan-14 23:00:19874 10.2
End Snap:6549817-Jan-14 00:00:16804 10.0
Elapsed:  59.95 (mins)  
DB Time:  147.47 (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: 51,184.83 24,542.78
Logical reads: 23,886.03 11,453.19
Block changes: 330.50 158.47
Physical reads: 5,384.50 2,581.83
Physical writes: 464.73 222.84
User calls: 172.57 82.75
Parses: 83.44 40.01
Hard parses: 0.14 0.07
Sorts: 7.11 3.41
Logons: 0.74 0.35
Executes: 201.54 96.64
Transactions: 2.09 

% Blocks changed per Read: 1.38Recursive Call %: 90.19
Rollback per transaction %: 56.64Rows per Sort: 9735.24

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 79.73In-memory Sort %: 99.98
Library Hit %: 99.77Soft Parse %: 99.83
Execute to Parse %: 58.60Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 5.19% Non-Parse CPU: 99.95

Shared Pool Statistics

BeginEnd
Memory Usage %: 32.23 31.60
% SQL with executions>1: 95.29 98.73
% Memory for SQL w/exec>1: 97.73 99.40

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
db file sequential read 963,078 2,650 3 29.9User I/O
PX Deq: Signal ACK 10,341 1,962 190 22.2Other
CPU time  1,645  18.6 
db file scattered read 894,895 1,553 2 17.6User I/O
gc cr multi block request 943,846 369 0 4.2Cluster

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 4.88 2.34
Global Cache blocks served: 8.90 4.27
GCS/GES messages received: 3,816.86 1,830.16
GCS/GES messages sent: 5,287.38 2,535.26
DBWR Fusion writes: 0.35 0.17
Estd Interconnect traffic (KB) 1,888.41 

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

Buffer access - local cache %: 79.71
Buffer access - remote cache %: 0.02
Buffer access - disk %: 20.27

Global Cache and Enqueue Services - Workload Characteristics

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.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: 5.55
% of indirect sent messages: 94.27
% of flow controlled messages: 0.18

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 8,788.80 99.33
PL/SQL execution elapsed time 2,171.01 24.54
DB CPU 1,645.08 18.59
parse time elapsed 25.51 0.29
hard parse elapsed time 18.85 0.21
connection management call elapsed time 4.50 0.05
hard parse (sharing criteria) elapsed time 0.21 0.00
sequence load elapsed time 0.11 0.00
PL/SQL compilation elapsed time 0.10 0.00
hard parse (bind mismatch) elapsed time 0.10 0.00
failed parse elapsed time 0.03 0.00
repeated bind elapsed time 0.01 0.00
DB time 8,848.48  
background elapsed time 764.43  
background cpu time 457.35  

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,842,201 0.00 4,461 2 378.86
Other 597,900 92.56 1,987 3 79.70
Cluster 1,450,651 0.00 507 0 193.37
System I/O 98,956 0.00 29 0 13.19
Concurrency 8,485 0.38 23 3 1.13
Network 599,577 0.00 6 0 79.92
Commit 2,700 0.00 1 1 0.36
Application 644 0.00 0 0 0.09
Configuration 838 81.03 0 0 0.11

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 963,078 0.00 2,650 3 128.38
PX Deq: Signal ACK 10,341 87.38 1,962 190 1.38
db file scattered read 894,895 0.00 1,553 2 119.29
gc cr multi block request 943,846 0.00 369 0 125.81
direct path read temp 965,057 0.00 245 0 128.64
gc cr grant 2-way 459,474 0.00 123 0 61.25
library cache lock 3,748 0.85 17 5 0.50
control file sequential read 41,746 0.00 11 0 5.56
db file parallel write 36,887 0.00 10 0 4.92
direct path write temp 1,676 0.00 10 6 0.22
gc current grant 2-way 30,750 0.00 8 0 4.10
DFS lock handle 18,675 0.00 8 0 2.49
enq: WF - contention 30 46.67 7 230 0.00
gc cr block 2-way 10,375 0.00 4 0 1.38
LNS wait on SENDREQ 690 0.00 4 6 0.09
os thread startup 63 0.00 4 64 0.01
log file sequential read 7,549 0.00 4 0 1.01
CGS wait for IPC msg 485,519 100.00 2 0 64.72
log file parallel write 8,727 0.00 2 0 1.16
gc current block 2-way 5,263 0.00 2 0 0.70
db file parallel read 286 0.00 2 8 0.04
name-service call wait 30 0.00 2 64 0.00
control file parallel write 3,823 0.00 2 1 0.51
log file sync 2,700 0.00 1 1 0.36
enq: TO - contention 2,931 0.00 1 0 0.39
row cache lock 4,125 0.00 1 0 0.55
SQL*Net more data from client 5,847 0.00 1 0 0.78
enq: CF - contention 1,417 0.00 1 1 0.19
reliable message 2,547 0.00 1 0 0.34
enq: PS - contention 1,409 0.00 1 0 0.19
Log archive I/O 200 0.00 1 3 0.03
enq: XR - database force logging 1,200 0.00 1 0 0.16
enq: TT - contention 1,376 0.00 1 0 0.18
PX Deq Credit: send blkd 2,231 16.94 0 0 0.30
PX Deq: reap credit 39,391 95.30 0 0 5.25
SQL*Net message to client 587,495 0.00 0 0 78.31
direct path write 4,481 0.00 0 0 0.60
rdbms ipc reply 572 0.00 0 1 0.08
gc cr block busy 257 0.00 0 1 0.03
direct path read 12,728 0.00 0 0 1.70
enq: TM - contention 436 0.00 0 0 0.06
gc current grant busy 499 0.00 0 0 0.07
ksxr poll remote instances 27,155 76.80 0 0 3.62
library cache pin 537 0.00 0 0 0.07
gc current block busy 11 0.00 0 10 0.00
log file switch completion 4 0.00 0 22 0.00
enq: RO - fast object reuse 133 0.00 0 1 0.02
enq: TX - index contention 2 0.00 0 29 0.00
latch free 17 0.00 0 3 0.00
enq: AF - task serialization 124 0.00 0 0 0.02
enq: HW - contention 112 0.00 0 0 0.01
SQL*Net more data to client 2,368 0.00 0 0 0.32
SQL*Net break/reset to client 74 0.00 0 0 0.01
gc current block unknown 66 0.00 0 0 0.01
latch: KCL gc element parent latch 2,534 0.00 0 0 0.34
IPC send completion sync 58 100.00 0 0 0.01
enq: TX - contention 1 0.00 0 21 0.00
gc cr grant congested 8 0.00 0 2 0.00
log buffer space 43 0.00 0 0 0.01
gc current multi block request 94 0.00 0 0 0.01
enq: SK - contention 28 0.00 0 0 0.00
enq: IR - contention 25 0.00 0 0 0.00
enq: TC - contention2 46 0.00 0 0 0.01
gcs log flush sync 30 3.33 0 0 0.00
enq: FB - contention 15 0.00 0 1 0.00
ges inquiry response 15 0.00 0 1 0.00
enq: JQ - contention 13 0.00 0 0 0.00
enq: SW - contention 13 0.00 0 0 0.00
log file single write 24 0.00 0 0 0.00
KJC: Wait for msg sends to complete 39 0.00 0 0 0.01
enq: TD - KTF dump entries 17 0.00 0 0 0.00
gc current grant congested 2 0.00 0 2 0.00
SQL*Net more data to dblink 183 0.00 0 0 0.02
undo segment extension 679 100.00 0 0 0.09
SQL*Net message to dblink 2,994 0.00 0 0 0.40
enq: WR - contention 3 0.00 0 0 0.00
enq: WL - contention 3 0.00 0 0 0.00
enq: MW - contention 2 0.00 0 1 0.00
gc current split 2 0.00 0 0 0.00
enq: DR - contention 2 0.00 0 0 0.00
gc buffer busy 4 0.00 0 0 0.00
enq: WP - contention 1 0.00 0 1 0.00
latch: cache buffers lru chain 1 0.00 0 1 0.00
enq: UL - contention 1 0.00 0 0 0.00
LGWR wait for redo copy 27 0.00 0 0 0.00
enq: US - contention 1 0.00 0 0 0.00
latch: session allocation 1 0.00 0 0 0.00
cursor: pin S 48 0.00 0 0 0.01
buffer busy waits 5 0.00 0 0 0.00
PX qref latch 10 70.00 0 0 0.00
latch: cache buffers chains 5 0.00 0 0 0.00
latch: ges resource hash list 1 0.00 0 0 0.00
latch: object queue header operation 1 0.00 0 0 0.00
SQL*Net message from client 587,529 0.00 1,763,155 3001 78.32
gcs remote message 8,168,438 99.88 126,098 15 1,088.83
jobq slave wait 4,263 99.48 12,394 2907 0.57
PX Idle Wait 4,776 85.24 10,930 2288 0.64
Streams AQ: qmn slave idle wait 415 0.00 7,036 16954 0.06
Streams AQ: qmn coordinator idle wait 264 49.62 3,518 13325 0.04
EMON idle wait 728 98.90 3,514 4826 0.10
DIAG idle wait 17,973 0.00 3,511 195 2.40
Streams AQ: waiting for messages in the queue 738 98.51 3,510 4756 0.10
ges remote message 125,235 88.27 3,504 28 16.69
LNS ASYNC end of log 357,532 100.00 3,496 10 47.66
Streams AQ: waiting for time management or cleanup tasks 12 100.00 3,438 286459 0.00
PX Deq: Execution Msg 3,523 20.21 2,219 630 0.47
PX Deq: Join ACK 1,976 33.55 301 152 0.26
PX Deq: Parse Reply 1,994 33.20 162 81 0.27
single-task message 118 0.00 7 62 0.02
PX Deq: Msg Fragment 1,675 0.60 6 3 0.22
PX Deq: Execute Reply 4,711 37.89 5 1 0.63
SQL*Net message from dblink 2,994 0.00 4 1 0.40
PL/SQL lock timer 1 100.00 1 977 0.00
PX Deq Credit: need buffer 124 0.00 0 0 0.02
class slave wait 3 0.00 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 271 99.63 0 0 0.04

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 535,618 94.61 25 0 71.40
db file parallel write 36,887 0.00 10 0 4.92
control file sequential read 24,240 0.00 7 0 3.23
LNS wait on SENDREQ 690 0.00 4 6 0.09
log file sequential read 7,549 0.00 4 0 1.01
os thread startup 53 0.00 3 59 0.01
log file parallel write 8,727 0.00 2 0 1.16
control file parallel write 3,823 0.00 2 1 0.51
library cache lock 1,483 0.00 1 0 0.20
Log archive I/O 200 0.00 1 3 0.03
direct path read 12,698 0.00 0 0 1.69
row cache lock 427 0.00 0 1 0.06
gc cr block 2-way 442 0.00 0 0 0.06
enq: TM - contention 353 0.00 0 0 0.05
gc current block 2-way 225 0.00 0 0 0.03
direct path write 3,182 0.00 0 0 0.42
gc current grant busy 58 0.00 0 0 0.01
enq: RO - fast object reuse 48 0.00 0 0 0.01
log buffer space 43 0.00 0 0 0.01
log file single write 24 0.00 0 0 0.00
library cache pin 15 0.00 0 0 0.00
buffer busy waits 1 0.00 0 0 0.00
latch: cache buffers chains 4 0.00 0 0 0.00
gc current grant 2-way 3 0.00 -0 -2 0.00
gcs remote message 8,168,461 99.88 126,098 15 1,088.84
rdbms ipc message 160,619 39.18 76,409 476 21.41
Streams AQ: qmn slave idle wait 415 0.00 7,036 16954 0.06
Streams AQ: qmn coordinator idle wait 264 49.62 3,518 13325 0.04
EMON idle wait 728 98.90 3,514 4826 0.10
DIAG idle wait 17,973 0.00 3,511 195 2.40
pmon timer 1,244 100.00 3,509 2821 0.17
ges remote message 125,235 88.26 3,504 28 16.69
LNS ASYNC end of log 357,531 100.00 3,496 10 47.66
smon timer 63,965 0.02 3,491 55 8.53
Streams AQ: waiting for time management or cleanup tasks 12 100.00 3,438 286459 0.00
PX Deq: Join ACK 30 40.00 2 66 0.00
PX Deq: Parse Reply 30 40.00 0 0 0.00
PX Deq: Execute Reply 24 25.00 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 271 99.63 0 0 0.04

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 8,298.40 1,414.30 18,835,955 47,236,061
cdld 550.70 231.50 219,642 35,001,600
SYS$BACKGROUND 0.00 0.00 284,703 3,686,536

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 2530961 414830 1190 1706 0 0 349454 104
cdld 219730 18000 939 39 0 0 242422 15
SYS$BACKGROUND 91489 13300 6347 524 0 0 690 436

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,508 997 0   39.65 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
3,109 54 0   35.14 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
2,173 50 56 38.80 24.56 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
585 189 1 585.46 6.62 8swv6ppv567kr DBMS_SCHEDULER select min(minbkt), maxbkt, su...
561 96 1 560.93 6.34 0p5qdps6w53uh DBMS_SCHEDULER select substrb(dump(val, 16, 0...
528 2 111 4.76 5.97 3y9bat7nwcjy5 DBMS_SCHEDULER SELECT ELAPSED_TIME FROM DBA_S...
412 86 0   4.65 an5s7r73zz4yq DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
378 101 1 378.06 4.27 7u9sv4y21vv95 DBMS_SCHEDULER select min(minbkt), maxbkt, su...
331 72 1 330.83 3.74 agcu12j51f95m DBMS_SCHEDULER select min(minbkt), maxbkt, su...
297 109 1 297.11 3.36 gxd92bu7s54fn DBMS_SCHEDULER select min(minbkt), maxbkt, su...
290 104 1 290.21 3.28 39knj4sd72197 DBMS_SCHEDULER select substrb(dump(val, 16, 0...
284 106 1 283.50 3.20 5kq342jtj7fyz DBMS_SCHEDULER select substrb(dump(val, 16, 0...
258 135 41 6.29 2.91 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
218 144 4 54.61 2.47 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
194 76 1 194.41 2.20 1wftkymd8n1rp DBMS_SCHEDULER select min(minbkt), maxbkt, su...
185 115 25,004 0.01 2.09 a6ws36ztq6vhq   SELECT COUNT(1) FROM CC72 A, ...
162 55 1 162.21 1.83 ausr63mw91mz5 DBMS_SCHEDULER select min(minbkt), maxbkt, su...
131 0 72 1.82 1.48 1mjhyad05m8pf perl@p780a (TNS V1-V3) SELECT value ...
119 0 72 1.66 1.35 8j37z6cqf3s9h perl@p780a (TNS V1-V3) SELECT value ...

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
997 3,508 0   39.65 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
189 585 1 188.61 6.62 8swv6ppv567kr DBMS_SCHEDULER select min(minbkt), maxbkt, su...
144 218 4 36.03 2.47 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
135 258 41 3.30 2.91 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
115 185 25,004 0.00 2.09 a6ws36ztq6vhq   SELECT COUNT(1) FROM CC72 A, ...
109 297 1 109.08 3.36 gxd92bu7s54fn DBMS_SCHEDULER select min(minbkt), maxbkt, su...
106 284 1 105.95 3.20 5kq342jtj7fyz DBMS_SCHEDULER select substrb(dump(val, 16, 0...
104 290 1 104.28 3.28 39knj4sd72197 DBMS_SCHEDULER select substrb(dump(val, 16, 0...
101 378 1 100.70 4.27 7u9sv4y21vv95 DBMS_SCHEDULER select min(minbkt), maxbkt, su...
96 561 1 96.27 6.34 0p5qdps6w53uh DBMS_SCHEDULER select substrb(dump(val, 16, 0...
86 412 0   4.65 an5s7r73zz4yq DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
76 194 1 75.50 2.20 1wftkymd8n1rp DBMS_SCHEDULER select min(minbkt), maxbkt, su...
72 331 1 71.81 3.74 agcu12j51f95m DBMS_SCHEDULER select min(minbkt), maxbkt, su...
55 162 1 54.93 1.83 ausr63mw91mz5 DBMS_SCHEDULER select min(minbkt), maxbkt, su...
54 3,109 0   35.14 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
50 2,173 56 0.89 24.56 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
2 528 111 0.02 5.97 3y9bat7nwcjy5 DBMS_SCHEDULER SELECT ELAPSED_TIME FROM DBA_S...
0 131 72 0.00 1.48 1mjhyad05m8pf perl@p780a (TNS V1-V3) SELECT value ...
0 119 72 0.00 1.35 8j37z6cqf3s9h perl@p780a (TNS V1-V3) SELECT value ...

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
29,064,899 41 708,899.98 33.83 135.18 257.87 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
25,248,165 4 6,312,041.25 29.39 144.12 218.43 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
21,950,612 25,004 877.88 25.55 114.61 185.04 a6ws36ztq6vhq   SELECT COUNT(1) FROM CC72 A, ...
17,911,364 0   20.85 996.70 3508.07 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
2,684,166 1 2,684,166.00 3.12 109.08 297.11 gxd92bu7s54fn DBMS_SCHEDULER select min(minbkt), maxbkt, su...
2,684,016 1 2,684,016.00 3.12 96.27 560.93 0p5qdps6w53uh DBMS_SCHEDULER select substrb(dump(val, 16, 0...
2,683,795 1 2,683,795.00 3.12 105.95 283.50 5kq342jtj7fyz DBMS_SCHEDULER select substrb(dump(val, 16, 0...
2,683,735 1 2,683,735.00 3.12 188.61 585.46 8swv6ppv567kr DBMS_SCHEDULER select min(minbkt), maxbkt, su...
2,683,646 1 2,683,646.00 3.12 104.28 290.21 39knj4sd72197 DBMS_SCHEDULER select substrb(dump(val, 16, 0...
2,474,934 707 3,500.61 2.88 4.28 15.71 6ssrk2dqj7jbx   select job, nvl2(last_date, ...
1,981,835 0   2.31 53.54 3109.32 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
1,901,613 1 1,901,613.00 2.21 75.50 194.41 1wftkymd8n1rp DBMS_SCHEDULER select min(minbkt), maxbkt, su...
1,868,613 59 31,671.41 2.17 21.74 32.66 4uxm6mv5074qp w3wp.exe begin cdsi2.pkg_infoservice.P_...
1,867,763 59 31,657.00 2.17 21.73 32.55 6hj5y5vzt7ktg w3wp.exe UPDATE KE13K1 SET YKE291 = '1'...
1,712,322 379 4,518.00 1.99 12.77 21.57 0v8dtgsvzsb0h JDBC Thin Client select rownum, sys.dba_rollba...
1,537,968 12 128,164.00 1.79 17.88 41.39 fy0cr07pnqm4d JDBC Thin Client select tablespace_name, trunc...
1,328,953 56 23,731.30 1.55 49.77 2172.94 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
1,188,769 0   1.38 86.11 411.52 an5s7r73zz4yq DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
1,113,324 488 2,281.40 1.30 9.05 13.69 96w33uzj03afw   SELECT TO_CHAR(B.YAE434, 'YYY...

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
18,354,763 0   94.76 996.70 3508.07 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
3,008,059 1 3,008,059.00 15.53 188.61 585.46 8swv6ppv567kr DBMS_SCHEDULER select min(minbkt), maxbkt, su...
2,598,951 1 2,598,951.00 13.42 109.08 297.11 gxd92bu7s54fn DBMS_SCHEDULER select min(minbkt), maxbkt, su...
2,533,846 1 2,533,846.00 13.08 104.28 290.21 39knj4sd72197 DBMS_SCHEDULER select substrb(dump(val, 16, 0...
2,533,794 1 2,533,794.00 13.08 105.95 283.50 5kq342jtj7fyz DBMS_SCHEDULER select substrb(dump(val, 16, 0...
2,378,720 1 2,378,720.00 12.28 96.27 560.93 0p5qdps6w53uh DBMS_SCHEDULER select substrb(dump(val, 16, 0...
1,859,030 1 1,859,030.00 9.60 75.50 194.41 1wftkymd8n1rp DBMS_SCHEDULER select min(minbkt), maxbkt, su...
1,035,929 1 1,035,929.00 5.35 71.81 330.83 agcu12j51f95m DBMS_SCHEDULER select min(minbkt), maxbkt, su...
823,791 0   4.25 86.11 411.52 an5s7r73zz4yq DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
806,430 1 806,430.00 4.16 100.70 378.06 7u9sv4y21vv95 DBMS_SCHEDULER select min(minbkt), maxbkt, su...
703,890 1 703,890.00 3.63 54.93 162.21 ausr63mw91mz5 DBMS_SCHEDULER select min(minbkt), maxbkt, su...
476,517 56 8,509.23 2.46 49.77 2172.94 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
474,461 0   2.45 53.54 3109.32 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...

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
200,263 200,135 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
25,004 25,004 1.00 0.00 0.01 a6ws36ztq6vhq   SELECT COUNT(1) FROM CC72 A, ...
15,381 15,380 1.00 0.00 0.00 bunvx480ynf57 JDBC Thin Client SELECT 1 FROM DUAL
6,296 6,296 1.00 0.00 0.00 36p2gr6241mtz JDBC Thin Client UPDATE IC01 SET YIC586 = SYSDA...
5,541 456 0.08 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
4,167 0 0.00 0.00 0.00 a1yhyd9zv1vdr w3wp.exe set transaction isolation leve...
3,978 21,710 5.46 0.00 0.00 7w0vtmkutynxv w3wp.exe Select content From Tmp_info...
3,003 3,003 1.00 0.00 0.00 04m2s1cxfa4n4 call126.exe SELECT TO_CHAR ( SYSDATE , 'Y...
3,003 3,003 1.00 0.00 0.00 2cbv3gwa1hxx0 call126.exe declare BEGIN SELECT TO_CHAR (...
2,895 2,895 1.00 0.00 0.00 5aa4qy7098w5k   SELECT seq, message#, fac, hdr...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
200,272 200,263 66.72 2ym6hhaq30r73   select type#, blocks, extents,...
13,140 15,381 4.38 bunvx480ynf57 JDBC Thin Client SELECT 1 FROM DUAL
5,541 5,541 1.85 0h6b2sajwb74n   select privilege#, level from ...
4,167 4,167 1.39 a1yhyd9zv1vdr w3wp.exe set transaction isolation leve...
3,978 3,978 1.33 7w0vtmkutynxv w3wp.exe Select content From Tmp_info...
2,895 2,895 0.96 5aa4qy7098w5k   SELECT seq, message#, fac, hdr...
1,922 1,922 0.64 0k8522rmdzg4k   select privilege# from sysauth...
1,811 3,003 0.60 04m2s1cxfa4n4 call126.exe SELECT TO_CHAR ( SYSDATE , 'Y...
1,811 3,003 0.60 2cbv3gwa1hxx0 call126.exe declare BEGIN SELECT TO_CHAR (...
1,697 1,697 0.57 bsa0wjtftg3uw   select file# from file$ where ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
567,611,744   2.64 4fhaf54p9c3ha   select yke164 , yke170 , yke22...
25,373,328   0.12 9gxn1ssgc881v   select distinct aaa103 into :b...
16,877,272   0.08 dbyztx7kus72y   select akc193 into :b0:b1 fro...
13,397,272   0.06 8f0k8kqug0sq1   select count(1) into :b0 from...
13,245,343 444 0.06 45t5rk1v0wvrg w3wp.exe SELECT AAA103 FROM AA10A1 WHER...
12,744,040   0.06 3y5201hazghm4   select aka130 into :b0:b1 fro...
6,720,256   0.03 7dw31p7nwq339   select aaa103 into :b0:b1 fro...
6,701,752   0.03 a36pbr618749m   select count(1) into :b0 from...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
23,164   4fhaf54p9c3ha   select yke164 , yke170 , yke22...
2,054   9gxn1ssgc881v   select distinct aaa103 into :b...
1,029   dbyztx7kus72y   select akc193 into :b0:b1 fro...
1,026 33 09wravpck2md8 call41.exe select count(1) into :b0 from...
817   8f0k8kqug0sq1   select count(1) into :b0 from...
777   3y5201hazghm4   select aka130 into :b0:b1 fro...
616   8yapya1d8y5nf   select yke463 into :b0:b1 fro...
543   a36pbr618749m   select count(1) into :b0 from...
410   7dw31p7nwq339   select aaa103 into :b0:b1 fro...

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
393.42 11.21 3,508.07 996.70 0 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
67.97 12.12 560.93 96.27 1 0p5qdps6w53uh DBMS_SCHEDULER select substrb(dump(val, 16, 0...
61.43 2.83 2,172.94 49.77 56 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
61.18 1.97 3,109.32 53.54 0 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
57.57 19.38 297.11 109.08 1 gxd92bu7s54fn DBMS_SCHEDULER select min(minbkt), maxbkt, su...
57.51 9.82 585.46 188.61 1 8swv6ppv567kr DBMS_SCHEDULER select min(minbkt), maxbkt, su...
56.62 19.51 290.21 104.28 1 39knj4sd72197 DBMS_SCHEDULER select substrb(dump(val, 16, 0...
56.18 19.82 283.50 105.95 1 5kq342jtj7fyz DBMS_SCHEDULER select substrb(dump(val, 16, 0...
38.63 19.87 194.41 75.50 1 1wftkymd8n1rp DBMS_SCHEDULER select min(minbkt), maxbkt, su...
25.40 6.17 411.52 86.11 0 an5s7r73zz4yq DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
21.31 8.26 257.87 135.18 41 4bndapumf09zd JDBC Thin Client SELECT /*+ NO_CPU_COSTING */ t...
12.30 7.59 162.21 54.93 1 ausr63mw91mz5 DBMS_SCHEDULER select min(minbkt), maxbkt, su...
10.03 3.03 330.83 71.81 1 agcu12j51f95m DBMS_SCHEDULER select min(minbkt), maxbkt, su...
9.58 2.53 378.06 100.70 1 7u9sv4y21vv95 DBMS_SCHEDULER select min(minbkt), maxbkt, su...
8.32 12.06 69.00 6.17 1 24b3xmp4wd3tu   delete from sys.wri$_optstat_h...
6.55 15.83 41.39 17.88 12 fy0cr07pnqm4d JDBC Thin Client select tablespace_name, trunc...
2.90 8.10 35.79 6.20 1 24hc2470c87up   delete from WRH$_SQL_PLAN tab ...
1.20 2.48 48.45 3.06 137 0cu9tuamk86bs w3wp.exe begin cdsi2.pkg_infoservice.P_...
0.46 2.37 19.24 1.10 444 1qt328vkrb4ug w3wp.exe BEGIN PKG_K_DEFRAYINTERFACE_YD...
0.32 1.79 17.60 10.31 6,296 36p2gr6241mtz JDBC Thin Client UPDATE IC01 SET YIC586 = SYSDA...
0.29 0.13 218.43 144.12 4 cr3p21gxu7sdh   DECLARE job BINARY_INTEGER := ...
0.18 0.86 21.57 12.77 379 0v8dtgsvzsb0h JDBC Thin Client select rownum, sys.dba_rollba...
0.18 2.36 7.50 7.49 200,263 2ym6hhaq30r73   select type#, blocks, extents,...
0.11 0.67 15.71 4.28 707 6ssrk2dqj7jbx   select job, nvl2(last_date, ...
0.06 0.18 34.55 6.34 314 frj3pbd1yxzgs call06.exe update ke04 set yke190='3', y...
0.05 2.48 2.14 0.93 1,122 db78fxqxwxt7r   select /*+ rule */ bucket, en...
0.03 2.76 1.04 0.33 504 027mxkbhx1kqr call03.exe declare BEGIN SELECT ykc117 , ...
0.03 2.96 0.96 0.27 504 0zu5yu9bp5bmn call03.exe SELECT YKC117 , AKC021 , YAC...
0.03 0.27 10.44 6.62 56 gnux0zb3sxduk DBMS_SCHEDULER SELECT TIMEPOINT, DELTA_SPACE...
0.01 0.03 31.48 4.53 288 a77y4j8bgy8mz call120.exe insert into KE01K5 (yke014, yk...
0.01 0.56 1.34 1.33 452 awgq3jfn1pryj w3wp.exe begin cdsi2.pkg_infoservice.P_...
0.01 0.06 8.34 5.75 46 8qwcr6jzsysta DBMS_SCHEDULER select sn.end_interval_time ti...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
027mxkbhx1kqrdeclare BEGIN SELECT ykc117 , akc021 , yac080 , ykc120 , ykd002 , ykc150 , ykc156 , akc025 , aae121 , TO_CHAR ( aae035 , 'YYYY-MM-DD HH24:MI:SS' ) , TO_CHAR ( aic162 , 'YYYY-MM-DD HH24:MI:SS' ) INTO :str_ykc117:ind_ykc117 , :str_akc021:ind_akc021 , :str_yac080:ind_yac080 , :str_ykc120:ind_ykc120 , :str_ykd002:ind_ykd002 , :str_ykc150:ind_ykc150 , :str_ykc156:ind_ykc156 , :str_akc025:ind_akc025 , :str_aae121:ind_aae121 , :str_aae035:ind_aae035 , :str_aic162:ind_aic162 FROM kc01k1 WHERE ( yae099 , aac001 ) = ( SELECT MAX ( yae099 ) , MIN ( aac001 ) FROM kc01k1 WHERE aac001 = :str_aac001 AND TRUNC ( aae035 , 'DD' ) <= TRUNC ( TO_DATE ( :str_akc142 , 'YYYY-MM-DD HH24:MI:SS' ) , 'DD' ) ) ; IF SQL % NOTFOUND THEN :appErrCode := :funAppCode -1 ; :appErrMsg := '??????????[' || :str_aac001 || ']?????????!' ; RETURN ; END IF ; EXCEPTION WHEN OTHERS THEN :appErrMsg := '????????????, ????: ' || SQLERRM ( SQLCODE ) ; :appErrCode := :funAppCode -199 ; END ;
04m2s1cxfa4n4SELECT TO_CHAR ( SYSDATE , 'YYYY-MM-DD HH24:MI:SS' ) FROM DUAL
09wravpck2md8select count(1) into :b0 from ke21 where (akb020=:b1 and yke463>='4')
0cu9tuamk86bsbegin cdsi2.pkg_infoservice.P_cx_mxxx_yl(prm_grbm=>:prm_grbm, prm_AppCode=>:prm_AppCode, prm_ErrorMsg=>:prm_ErrorMsg); end;
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
0p5qdps6w53uhselect substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */max("YKA026") val, count(*) cnt from "CDSI2"."KC22K1" t where "YKA026" is not null group by nlssort("YKA026", 'NLS_SORT = binary')) order by nlssort(val, 'NLS_SORT = binary')
0v8dtgsvzsb0hselect rownum, sys.dba_rollback_segs.segment_name Name, v$rollstat.extents Extents, trunc(v$rollstat.rssize/1024/1024, 2) Size_in_Bytes, v$rollstat.xacts XActs, v$rollstat.gets Gets, v$rollstat.waits Waits, trunc(v$rollstat.writes/1024/1024, 2) Writes, sys.dba_rollback_segs.status status, v$rollstat.SHRINKS from v$rollstat, sys.dba_rollback_segs, v$rollname where v$rollname.name(+) = sys.dba_rollback_segs.segment_name and v$rollstat.usn (+) = v$rollname.usn order by rownum
0zu5yu9bp5bmnSELECT YKC117 , AKC021 , YAC080 , YKC120 , YKD002 , YKC150 , YKC156 , AKC025 , AAE121 , TO_CHAR ( AAE035 , 'YYYY-MM-DD HH24:MI:SS' ) , TO_CHAR ( AIC162 , 'YYYY-MM-DD HH24:MI:SS' ) FROM KC01K1 WHERE ( YAE099 , AAC001 ) = ( SELECT MAX ( YAE099 ) , MIN ( AAC001 ) FROM KC01K1 WHERE AAC001 = :B2 AND TRUNC ( AAE035 , 'DD' ) <= TRUNC ( TO_DATE ( :B1 , 'YYYY-MM-DD HH24:MI:SS' ) , 'DD' ) )
1mjhyad05m8pf SELECT value FROM gv$osstat WHERE inst_id = :p1 and stat_name='NUM_CPU_CORES'
1qt328vkrb4ugBEGIN PKG_K_DEFRAYINTERFACE_YDZF.PRC_K_EXPENSELISTINFO_WBJK(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32); END;
1wftkymd8n1rpselect min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"YKE112" val, ntile(254) over (order by nlssort("YKE112", 'NLS_SORT = binary')) bkt from "CDSI2"."KC22K1" t where "YKE112" is not null) group by val) group by maxbkt order by maxbkt
24b3xmp4wd3tudelete from sys.wri$_optstat_histgrm_history where savtime < :1
24hc2470c87updelete from WRH$_SQL_PLAN tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))
2cbv3gwa1hxx0declare BEGIN SELECT TO_CHAR ( sysdate , 'YYYY-MM-DD HH24:MI:SS' ) INTO :str_sysdate FROM DUAL ; EXCEPTION WHEN OTHERS THEN :appErrMsg := '????????, ????: ' || SQLERRM ( SQLCODE ) ; :appErrCode := :funAppCode -1 ; 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
36p2gr6241mtzUPDATE IC01 SET YIC586 = SYSDATE, YIC585 = :B6 WHERE YAE202 = :B5 AND AAC001 = :B4 AND AAE002 = :B3 AND NVL(AAE120, '0') = :B2 AND YIC585 = :B1
39knj4sd72197select substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */max("YKD003") val, count(*) cnt from "CDSI2"."KC22K1" t where "YKD003" is not null group by nlssort("YKD003", 'NLS_SORT = binary')) order by nlssort(val, 'NLS_SORT = binary')
3y5201hazghm4select aka130 into :b0:b1 from kc09 where akc190=:b2
3y9bat7nwcjy5SELECT ELAPSED_TIME FROM DBA_SCHEDULER_RUNNING_JOBS WHERE JOB_NAME = 'AUTO_SPACE_ADVISOR_JOB'
45t5rk1v0wvrgSELECT AAA103 FROM AA10A1 WHERE AAA100 = :B2 AND AAA102 = :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
4fhaf54p9c3haselect yke164 , yke170 , yke221 , yke220 , yke218 , yke173 , aae100 , ykd078 , ykd080 into :b0:b1, :b2:b3, :b4:b5, :b6:b7, :b8:b9, :b10:b11, :b12:b13, :b14:b15, :b16:b17 from ke02 where yke182=:b18:b19
4uxm6mv5074qpbegin cdsi2.pkg_infoservice.P_dxx_grzhxftx(prm_yke294=>:prm_yke294, prm_AppCode=>:prm_AppCode, prm_ErrorMsg=>:prm_ErrorMsg); end;
5aa4qy7098w5kSELECT seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5, count(*) over () from sys.wri$_adv_message_groups WHERE id = :1 ORDER BY seq
5kq342jtj7fyzselect substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */max("YKD040") val, count(*) cnt from "CDSI2"."KC22K1" t where "YKD040" is not null group by nlssort("YKD040", 'NLS_SORT = binary')) order by nlssort(val, 'NLS_SORT = binary')
6hj5y5vzt7ktgUPDATE KE13K1 SET YKE291 = '1', YKE292 = SYSDATE WHERE YKE294 <= :B1 AND YKE291 = '0'
6mcpb06rctk0xcall dbms_space.auto_space_advisor_job_proc ( )
6ssrk2dqj7jbxselect job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
7dw31p7nwq339select aaa103 into :b0:b1 from bm_aka130 where (aka130=:b2 and rownum<2)
7u9sv4y21vv95select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"YKA105" val, ntile(254) over (order by nlssort("YKA105", 'NLS_SORT = binary')) bkt from "CDSI2"."KC22K1" t where "YKA105" is not null) group by val) group by maxbkt order by maxbkt
7w0vtmkutynxvSelect content From Tmp_infoservice order by id
8f0k8kqug0sq1select count(1) into :b0 from bm_yke309 where (yke309=:b1:b2 and rownum<2)
8j37z6cqf3s9h SELECT value FROM gv$osstat WHERE inst_id = :p1 and stat_name='NUM_CPUS'
8qwcr6jzsystaselect sn.end_interval_time timepoint, s.space_used_delta delta_space_usage, s.space_allocated_delta delta_space_alloc, NULL total_space_usage, NULL total_space_alloc, s.instance_number instance_number, s.dataobj# objn from sys.wrh$_seg_stat s, sys.wrh$_seg_stat_obj so, sys.wrm$_snapshot sn , sys.obj$ obj where sn.snap_id = s.snap_id and sn.dbid = s.dbid and s.ts# = so.ts# and s.obj# = so.obj# and s.dataobj# = so.dataobj# and so.dataobj# = (select max(dataobj#) from sys.wrh$_seg_stat_obj where object_name = :1 and object_type = :2 and owner = :3) and obj.obj# = so.obj# and obj.dataobj# = so.dataobj#
8swv6ppv567krselect min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"YKA104" val, ntile(254) over (order by nlssort("YKA104", 'NLS_SORT = binary')) bkt from "CDSI2"."KC22K1" t where "YKA104" is not null) group by val) group by maxbkt order by maxbkt
8szmwam7fysa3insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
8yapya1d8y5nfselect yke463 into :b0:b1 from ke21 where (akb020=:b2 and yke463>='4')
96w33uzj03afwSELECT TO_CHAR(B.YAE434, 'YYYYMMDD') AS ADC450, '090', B.YCB8A1, '30', TO_CHAR(B.YAE434, 'YYYYMMDD'), TO_CHAR(B.YAE434, 'YYYYMMDD'), TO_CHAR(B.AAE036, 'YYYYMMDD'), DECODE(SUBSTR(A.AAE017, 1, 6), '510109', '510140', '510100', '510101', SUBSTR(A.AAE017, 1, 6)) AS AAB229 FROM CC72 A, CB8A B WHERE A.YCC720 = B.YCC720 AND B.YAE435 = 'Y' AND AAC001 IN (SELECT AAC001 FROM AC01 WHERE AAC002 =:B1 ) AND ROWNUM = 1
9gxn1ssgc881vselect distinct aaa103 into :b0:b1 from bm_aka130 where aka130=:b2:b3
a1yhyd9zv1vdrset transaction isolation level read committed
a36pbr618749mselect count(1) into :b0 from kc09 where akc190=:b1
a6ws36ztq6vhqSELECT COUNT(1) FROM CC72 A, CB8A B WHERE A.YCC720 = B.YCC720 AND B.YAE435 = 'Y' AND AAC001 IN (SELECT AAC001 FROM AC01 WHERE AAC002 = :B1 )
a77y4j8bgy8mzinsert into KE01K5 (yke014, yke015, yke182, yke174, yke175, yke176, yke177, yke019, yke197, yke213, yke180) values (:b0:b1, :b2:b3, :b4:b5, :b6:b7, :b8:b9, :b10:b11, :b12:b13, sysdate, :b14:b15, :b16:b17, :b18:b19)
agcu12j51f95mselect min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"AKC190" val, ntile(254) over (order by nlssort("AKC190", 'NLS_SORT = binary')) bkt from "CDSI2"."KC22K1" t where "AKC190" is not null) group by val) group by maxbkt order by maxbkt
an5s7r73zz4yq select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("YKE426"), count(distinct "YKE426"), sum(sys_op_opnsize("YKE426")), substrb(dump(min("YKE426"), 16, 0, 32), 1, 120), substrb(dump(max("YKE426"), 16, 0, 32), 1, 120), count("YKE381"), count(distinct "YKE381"), sum(sys_op_opnsize("YKE381")), substrb(dump(min("YKE381"), 16, 0, 32), 1, 120), substrb(dump(max("YKE381"), 16, 0, 32), 1, 120), count("YKE407"), count(distinct "YKE407"), sum(sys_op_opnsize("YKE407")), substrb(dump(min("YKE407"), 16, 0, 32), 1, 120), substrb(dump(max("YKE407"), 16, 0, 32), 1, 120), count("YKE474"), count(distinct "YKE474"), sum(sys_op_opnsize("YKE474")), substrb(dump(min("YKE474"), 16, 0, 32), 1, 120), substrb(dump(max("YKE474"), 16, 0, 32), 1, 120), count("YKE492"), count(distinct "YKE492"), sum(sys_op_opnsize("YKE492")), substrb(dump(min("YKE492"), 16, 0, 32), 1, 120), substrb(dump(max("YKE492"), 16, 0, 32), 1, 120), count("YKE493"), count(distinct "YKE493"), sum(sys_op_opnsize("YKE493")), substrb(dump(min("YKE493"), 16, 0, 32), 1, 120), substrb(dump(max("YKE493"), 16, 0, 32), 1, 120), count("YKE494"), count(distinct "YKE494"), sum(sys_op_opnsize("YKE494")), substrb(dump(min(substrb("YKE494", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("YKE494", 1, 32)), 16, 0, 32), 1, 120), count("YKE419"), count(distinct "YKE419"), sum(sys_op_opnsize("YKE419")), substrb(dump(min("YKE419"), 16, 0, 32), 1, 12 0), substrb(dump(max("YKE419"), 16, 0, 32), 1, 120), count("YKE420"), count(distinct "YKE420"), sum(sys_op_opnsize("YKE420")), substrb(dump(min("YKE420"), 16, 0, 32), 1, 120), substrb(dump(max("YKE420"), 16, 0, 32), 1, 120), count("YKE533"), count(distinct "YKE533"), sum(sys_op_opnsize("YKE533")), substrb(dump(min("YKE533"), 16, 0, 32), 1, 120), substrb(dump(max("YKE533"), 16, 0, 32), 1, 120), count("YKE534"), count(distinct "YKE534"), sum(sys_op_opnsize("YKE534")), substrb(dump(min(substrb("YKE534", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("YKE534", 1, 32)), 16, 0, 32), 1, 120), count("YKA026"), sum(sys_op_opnsize("YKA026")), count("YKA103"), count(distinct "YKA103"), count("YKB006"), count(distinct "YKB006"), sum(sys_op_opnsize("YKB006")), substrb(dump(min("YKB006"), 16, 0, 32), 1, 120), substrb(dump(max("YKB006"), 16, 0, 32), 1, 120), count(distinct "AAC001"), count("YKC105"), count(distinct "YKC105"), sum(sys_op_opnsize("YKC105")), substrb(dump(min("YKC105"), 16, 0, 32), 1, 120), substrb(dump(max("YKC105"), 16, 0, 32), 1, 120), count(distinct "AAE036"), count("AAE013"), count("YKE123"), count(distinct "YKE123"), count("YKE098"), count("YKD040"), sum(sys_op_opnsize("YKD040")), count("YKD003"), sum(sys_op_opnsize("YKD003")), count("YKB010"), sum(sys_op_opnsize("YKB010")), count("YKE112"), count("YKE201") from "CDSI2"."KC22K1" t
ausr63mw91mz5select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"YKE098" val, ntile(254) over (order by "YKE098") bkt from "CDSI2"."KC22K1" t where "YKE098" is not null) group by val) group by maxbkt order by maxbkt
awgq3jfn1pryjbegin cdsi2.pkg_infoservice.P_cx_grxx(prm_grbm=>:prm_grbm, prm_AppCode=>:prm_AppCode, prm_ErrorMsg=>:prm_ErrorMsg); end;
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
bsa0wjtftg3uwselect file# from file$ where ts#=:1
bunvx480ynf57SELECT 1 FROM DUAL
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;
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dbyztx7kus72yselect akc193 into :b0:b1 from kc21k1 where (akc190=:b2 and rownum<2)
frj3pbd1yxzgsupdate ke04 set yke190='3', yke194=:b0:b1 where ((yab003=:b2:b3 and yke189=:b4:b5) and (yke190='2' or yke190='3'))
fy0cr07pnqm4dselect tablespace_name, trunc(Sqrt(max(blocks)/ sum(blocks)) * (100/Sqrt(Sqrt(count(blocks)))), 2) FSFI, count(blocks) blcn , sum(blocks) sumbl , max(blocks) mxbl from sys.dba_free_space group by tablespace_name
gnux0zb3sxdukSELECT TIMEPOINT, DELTA_SPACE_USAGE, DELTA_SPACE_ALLOC, TOTAL_SPACE_USAGE, TOTAL_SPACE_ALLOC, INSTANCE_NUMBER, OBJN FROM TABLE(DBMS_SPACE.OBJECT_GROWTH_TREND_SWRF(:B1 , :B2 , :B3 , :B4 )) ORDER BY TIMEPOINT
gxd92bu7s54fnselect min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */substrb("AAE013", 1, 32) val, ntile(254) over (order by nlssort(substrb("AAE013", 1, 32), 'NLS_SORT = binary')) bkt from "CDSI2"."KC22K1" t where substrb("AAE013", 1, 32) is not null) group by val) group by maxbkt order by maxbkt

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 149,467 41.55 19.92
CPU used when call started 25,881 7.19 3.45
CR blocks created 3,006 0.84 0.40
Cached Commit SCN referenced 1,840 0.51 0.25
Commit SCN cached 3 0.00 0.00
DB time 3,902,501 1,084.88 520.19
DBWR checkpoint buffers written 94,693 26.32 12.62
DBWR checkpoints 64 0.02 0.01
DBWR fusion writes 1,255 0.35 0.17
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR tablespace checkpoint buffers written 9,719 2.70 1.30
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 1,328 0.37 0.18
DBWR undo block writes 12,987 3.61 1.73
DFO trees parallelized 676 0.19 0.09
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 5,564 1.55 0.74
PX local messages sent 5,564 1.55 0.74
PX remote messages recv'd 3,164 0.88 0.42
PX remote messages sent 3,118 0.87 0.42
Parallel operations downgraded 75 to 99 pct 0 0.00 0.00
Parallel operations downgraded to serial 12 0.00 0.00
Parallel operations not downgraded 676 0.19 0.09
RowCR - row contention 192 0.05 0.03
RowCR attempts 16,309 4.53 2.17
RowCR hits 20,579 5.72 2.74
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 2 0.00 0.00
SQL*Net roundtrips to/from client 581,860 161.76 77.56
SQL*Net roundtrips to/from dblink 2,974 0.83 0.40
active txn count during cleanout 7,036 1.96 0.94
application wait time 29 0.01 0.00
background checkpoints completed 6 0.00 0.00
background checkpoints started 6 0.00 0.00
background timeouts 21,165 5.88 2.82
branch node splits 2 0.00 0.00
buffer is not pinned count 25,996,544 7,226.97 3,465.28
buffer is pinned count 51,221,669 14,239.48 6,827.74
bytes received via SQL*Net from client 59,196,924 16,456.58 7,890.82
bytes received via SQL*Net from dblink 1,051,356 292.27 140.14
bytes sent via SQL*Net to client 103,583,102 28,795.82 13,807.40
bytes sent via SQL*Net to dblink 1,433,042 398.38 191.02
calls to get snapshot scn: kcmgss 1,879,327 522.45 250.51
calls to kcmgas 875,034 243.26 116.64
calls to kcmgcs 12,518 3.48 1.67
change write time 482 0.13 0.06
cleanout - number of ktugct calls 73,104 20.32 9.74
cleanouts and rollbacks - consistent read gets 3,211 0.89 0.43
cleanouts only - consistent read gets 63,977 17.79 8.53
cluster key scan block gets 23,953,672 6,659.05 3,192.97
cluster key scans 12,074,806 3,356.76 1,609.54
cluster wait time 50,798 14.12 6.77
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 3,559 0.99 0.47
commit batch/immediate requested 3,559 0.99 0.47
commit cleanout failures: block lost 763 0.21 0.10
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 3,768 1.05 0.50
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 46,144 12.83 6.15
commit cleanouts successfully completed 41,613 11.57 5.55
commit immediate performed 3,559 0.99 0.47
commit immediate requested 3,559 0.99 0.47
commit txn count during cleanout 129,897 36.11 17.31
concurrency wait time 2,662 0.74 0.35
consistent changes 203,754 56.64 27.16
consistent gets 83,871,357 23,316.01 11,179.87
consistent gets - examination 8,643,942 2,402.99 1,152.22
consistent gets direct 1,330 0.37 0.18
consistent gets from cache 83,870,027 23,315.64 11,179.69
current blocks converted for CR 13 0.00 0.00
cursor authentications 110 0.03 0.01
data blocks consistent reads - undo records applied 30,121 8.37 4.02
db block changes 1,188,856 330.50 158.47
db block gets 2,050,479 570.03 273.32
db block gets direct 1,321 0.37 0.18
db block gets from cache 2,048,992 569.61 273.13
deferred (CURRENT) block cleanout applications 17,708 4.92 2.36
dirty buffers inspected 18,100 5.03 2.41
enqueue conversions 62,275 17.31 8.30
enqueue deadlocks 0 0.00 0.00
enqueue releases 785,781 218.44 104.74
enqueue requests 787,217 218.84 104.93
enqueue timeouts 1,448 0.40 0.19
enqueue waits 9,195 2.56 1.23
exchange deadlocks 2 0.00 0.00
execute count 724,959 201.54 96.64
failed probes on index block reclamation 49 0.01 0.01
free buffer inspected 17,233,028 4,790.73 2,297.12
free buffer requested 17,480,207 4,859.45 2,330.07
gc CPU used by this session 93,523 26.00 12.47
gc blocks lost 0 0.00 0.00
gc cr block build time 19 0.01 0.00
gc cr block flush time 1 0.00 0.00
gc cr block receive time 599 0.17 0.08
gc cr block send time 26 0.01 0.00
gc cr blocks received 11,797 3.28 1.57
gc cr blocks served 7,637 2.12 1.02
gc current block flush time 0 0.00 0.00
gc current block pin time 50 0.01 0.01
gc current block receive time 276 0.08 0.04
gc current block send time 91 0.03 0.01
gc current blocks received 5,741 1.60 0.77
gc current blocks served 24,393 6.78 3.25
gc local grants 8,711,473 2,421.77 1,161.22
gc remote grants 8,711,909 2,421.89 1,161.28
gcs messages sent 18,929,771 5,262.42 2,523.30
ges messages sent 89,763 24.95 11.97
global enqueue get time 2,778 0.77 0.37
global enqueue gets async 9,193 2.56 1.23
global enqueue gets sync 303,798 84.46 40.50
global enqueue releases 282,190 78.45 37.62
heap block compress 5,942 1.65 0.79
hot buffers moved to head of LRU 796,806 221.51 106.21
immediate (CR) block cleanout applications 67,188 18.68 8.96
immediate (CURRENT) block cleanout applications 5,936 1.65 0.79
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 50,959 14.17 6.79
index fast full scans (full) 6 0.00 0.00
index fetch by key 42,622,496 11,848.94 5,681.48
index scans kdiixs1 421,247 117.11 56.15
leaf node 90-10 splits 31 0.01 0.00
leaf node splits 444 0.12 0.06
lob reads 49,694 13.81 6.62
lob writes 27,019 7.51 3.60
lob writes unaligned 25,191 7.00 3.36
logons cumulative 2,656 0.74 0.35
messages received 60,496 16.82 8.06
messages sent 60,496 16.82 8.06
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 74,029,338 20,579.95 9,867.95
opened cursors cumulative 295,771 82.22 39.43
parse count (failures) 12 0.00 0.00
parse count (hard) 508 0.14 0.07
parse count (total) 300,159 83.44 40.01
parse time cpu 90 0.03 0.01
parse time elapsed 1,734 0.48 0.23
physical read IO requests 2,859,674 794.98 381.19
physical read bytes ############### 44,109,841.65 21,150,369.20
physical read total IO requests 2,915,804 810.59 388.67
physical read total bytes ############### 44,431,513.83 21,304,608.83
physical read total multi block requests 1,007,684 280.13 134.32
physical reads 19,368,904 5,384.50 2,581.83
physical reads cache 17,417,370 4,841.98 2,321.70
physical reads cache prefetch 15,565,182 4,327.08 2,074.80
physical reads direct 1,951,535 542.52 260.14
physical reads direct (lob) 30 0.01 0.00
physical reads direct temporary tablespace 1,937,641 538.66 258.28
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 172,596 47.98 23.01
physical write bytes 13,694,771,200 3,807,108.61 1,825,482.70
physical write total IO requests 202,314 56.24 26.97
physical write total bytes 14,463,751,680 4,020,883.06 1,927,986.09
physical write total multi block requests 84,919 23.61 11.32
physical writes 1,671,725 464.73 222.84
physical writes direct 1,555,549 432.44 207.35
physical writes direct (lob) 1,293 0.36 0.17
physical writes direct temporary tablespace 1,551,072 431.19 206.75
physical writes from cache 116,176 32.30 15.49
physical writes non checkpoint 1,633,089 453.99 217.69
pinned buffers inspected 39 0.01 0.01
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 158,436 44.04 21.12
process last non-idle time 3,580 1.00 0.48
queries parallelized 398 0.11 0.05
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 5,706,218 1,586.31 760.63
recursive cpu usage 21,260 5.91 2.83
redo blocks written 376,448 104.65 50.18
redo buffer allocation retries 23 0.01 0.00
redo entries 665,255 184.94 88.68
redo log space requests 19 0.01 0.00
redo log space wait time 9 0.00 0.00
redo ordering marks 11,709 3.26 1.56
redo size 184,119,920 51,184.83 24,542.78
redo subscn max counts 21,187 5.89 2.82
redo synch time 136 0.04 0.02
redo synch writes 6,493 1.81 0.87
redo wastage 2,238,208 622.22 298.35
redo write time 311 0.09 0.04
redo writer latching time 0 0.00 0.00
redo writes 8,723 2.42 1.16
rollback changes - undo records applied 43,828 12.18 5.84
rollbacks only - consistent read gets 908 0.25 0.12
rows fetched via callback 324,622 90.24 43.27
session connect time 0 0.00 0.00
session cursor cache hits 249,136 69.26 33.21
session logical reads 85,921,807 23,886.03 11,453.19
session pga memory 430,478,688 119,671.89 57,381.86
session pga memory max 4,490,368,352 1,248,310.01 598,556.17
session uga memory ############### 32,242,344.66 15,459,985.07
session uga memory max 2,619,260,520 728,147.20 349,141.63
shared hash latch upgrades - no wait 170,670 47.45 22.75
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 6 0.00 0.00
sorts (memory) 25,579 7.11 3.41
sorts (rows) 249,076,147 69,242.48 33,201.30
sql area evicted 11,315 3.15 1.51
sql area purged 116 0.03 0.02
summed dirty queue length 21,724 6.04 2.90
switch current to new buffer 8,408 2.34 1.12
table fetch by rowid 4,631,247 1,287.47 617.33
table fetch continued row 11,985 3.33 1.60
table scan blocks gotten 44,435,598 12,352.97 5,923.17
table scan rows gotten 1,390,042,606 386,428.01 185,289.60
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 26 0.01 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 95,966 26.68 12.79
total number of times SMON posted 63,950 17.78 8.52
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 3,559 0.99 0.47
transaction tables consistent read rollbacks 14 0.00 0.00
transaction tables consistent reads - undo records applied 161 0.04 0.02
undo change vector size 71,082,276 19,760.68 9,475.11
user I/O wait time 445,938 123.97 59.44
user calls 620,773 172.57 82.75
user commits 3,253 0.90 0.43
user rollbacks 4,249 1.18 0.57
workarea executions - multipass 10 0.00 0.00
workarea executions - onepass 7 0.00 0.00
workarea executions - optimal 14,853 4.13 1.98
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 126,638,679 126,656,759
opened cursors current 8,904 8,044
workarea memory allocated 8,162 6,595
logons current 874 804

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 6 6.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
DATA 1,568,739 436 2.55 10.78 78,041 22 0 0.00
TEMP 986,377 274 0.31 1.96 75,394 21 0 0.00
NNC_DATA01 165,420 46 0.22 1.00 18 0 0 0.00
SYSAUX 80,973 23 2.17 3.35 4,047 1 0 0.00
SHORDATA 19,234 5 1.54 1.00 570 0 0 0.00
IUFO 17,231 5 0.21 1.00 6 0 0 0.00
JYDATA 9,899 3 2.44 1.00 5,228 1 0 0.00
JYINDEX 2,288 1 0.56 1.00 3,569 1 0 0.00
TEMPDATA 3,226 1 0.51 1.00 237 0 0 0.00
UNDOTBS2 20 0 2.00 1.00 3,303 1 5 0.00
SYSTEM 1,120 0 8.26 1.00 1,013 0 0 0.00
DATA_A 882 0 4.05 1.00 1,131 0 0 0.00
DATA_CW_INDEX01 615 0 1.93 1.00 141 0 0 0.00
USERS 642 0 0.11 1.00 6 0 0 0.00
UNDOTBS1 128 0 0.94 1.00 28 0 2 0.00
JYLOBDATA 128 0 0.47 1.00 5 0 0 0.00
GGFW 81 0 1.11 1.00 6 0 0 0.00
JYSHORTDATA 75 0 0.67 1.00 5 0 0 0.00
XNH_DATA 54 0 2.04 1.00 24 0 0 0.00
NNC_INDEX01 57 0 1.23 1.00 17 0 0 0.00
DANGAN 54 0 1.85 1.00 14 0 0 0.00
GDZC 33 0 5.15 1.00 11 0 0 0.00
SYBX_DATA 28 0 3.93 1.00 11 0 0 0.00
LDGGSJ 27 0 4.07 1.00 6 0 0 0.00
CDLDZC 21 0 4.29 1.00 5 0 0 0.00
PENSION_DATA 12 0 6.67 1.00 6 0 0 0.00
LDJG 6 0 10.00 1.00 6 0 0 0.00
LDYL 6 0 1.67 1.00 6 0 0 0.00
NNC_DATA02 6 0 1.67 1.00 6 0 0 0.00
NNC_DATA03 6 0 1.67 1.00 6 0 0 0.00
NNC_INDEX02 6 0 1.67 1.00 6 0 0 0.00
NNC_INDEX03 6 0 1.67 1.00 6 0 0 0.00
JYTEMP 0 0 0.00   3 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 21 0 4.29 1.00 5 0 0 0.00
DANGAN /dev/rcdld_dangan01 27 0 1.85 1.00 7 0 0 0.00
DANGAN /dev/rcdld_dangan02 27 0 1.85 1.00 7 0 0 0.00
DATA /dev/rcdld_data01 3,384 1 4.36 11.18 130 0 0 0.00
DATA /dev/rcdld_data02 2,481 1 4.33 8.83 114 0 0 0.00
DATA /dev/rcdld_data03 7,830 2 2.30 12.61 361 0 0 0.00
DATA /dev/rcdld_data04 8,825 2 2.40 13.97 441 0 0 0.00
DATA /dev/rcdld_data05 5,930 2 2.65 13.16 276 0 0 0.00
DATA /dev/rcdld_data06 6,087 2 2.71 13.28 296 0 0 0.00
DATA /dev/rcdld_data07 9,364 3 2.24 12.80 504 0 0 0.00
DATA /dev/rcdld_data08 2,666 1 4.64 8.75 118 0 0 0.00
DATA /dev/rcdld_data09 7,431 2 2.41 11.80 522 0 0 0.00
DATA /dev/rcdld_data10 14,045 4 2.34 13.95 246 0 0 0.00
DATA /dev/rcdld_data100 5,175 1 2.97 15.08 1,779 0 0 0.00
DATA /dev/rcdld_data101 5,346 1 2.83 14.50 2,008 1 0 0.00
DATA /dev/rcdld_data102 6,036 2 2.48 12.60 2,061 1 0 0.00
DATA /dev/rcdld_data103 6,550 2 2.27 11.26 2,158 1 0 0.00
DATA /dev/rcdld_data104 6,465 2 2.41 11.07 1,615 0 0 0.00
DATA /dev/rcdld_data105 5,091 1 2.63 15.28 958 0 0 0.00
DATA /dev/rcdld_data106 4,904 1 2.85 15.95 670 0 0 0.00
DATA /dev/rcdld_data107 5,136 1 2.53 15.25 678 0 0 0.00
DATA /dev/rcdld_data108 4,822 1 2.86 16.18 585 0 0 0.00
DATA /dev/rcdld_data109 4,999 1 2.75 14.62 533 0 0 0.00
DATA /dev/rcdld_data11 11,225 3 2.64 13.30 254 0 0 0.00
DATA /dev/rcdld_data110 4,567 1 2.65 15.31 543 0 0 0.00
DATA /dev/rcdld_data111 8,932 2 2.34 13.55 718 0 0 0.00
DATA /dev/rcdld_data112 5,215 1 2.47 14.86 738 0 0 0.00
DATA /dev/rcdld_data113 8,700 2 2.23 14.97 851 0 0 0.00
DATA /dev/rcdld_data114 8,935 2 2.01 14.85 926 0 0 0.00
DATA /dev/rcdld_data115 4,555 1 3.15 12.71 105 0 0 0.00
DATA /dev/rcdld_data116 4,650 1 2.72 14.56 408 0 0 0.00
DATA /dev/rcdld_data117 4,335 1 2.84 13.94 230 0 0 0.00
DATA /dev/rcdld_data118 3,534 1 3.11 11.79 210 0 0 0.00
DATA /dev/rcdld_data119 3,785 1 2.82 14.62 160 0 0 0.00
DATA /dev/rcdld_data12 6,705 2 2.43 16.10 186 0 0 0.00
DATA /dev/rcdld_data120 4,302 1 2.96 14.04 308 0 0 0.00
DATA /dev/rcdld_data121 4,344 1 2.85 13.30 259 0 0 0.00
DATA /dev/rcdld_data122 7,690 2 1.92 13.16 482 0 0 0.00
DATA /dev/rcdld_data123 8,548 2 1.90 11.96 624 0 0 0.00
DATA /dev/rcdld_data124 5,888 2 2.42 13.25 376 0 0 0.00
DATA /dev/rcdld_data125 4,347 1 2.81 13.56 238 0 0 0.00
DATA /dev/rcdld_data126 4,520 1 2.62 13.37 284 0 0 0.00
DATA /dev/rcdld_data127 4,196 1 2.98 12.27 219 0 0 0.00
DATA /dev/rcdld_data128 4,240 1 2.79 12.85 206 0 0 0.00
DATA /dev/rcdld_data129 4,199 1 2.90 13.02 233 0 0 0.00
DATA /dev/rcdld_data13 6,491 2 2.21 13.13 93 0 0 0.00
DATA /dev/rcdld_data130 4,197 1 2.74 12.93 104 0 0 0.00
DATA /dev/rcdld_data131 6,997 2 2.17 14.02 197 0 0 0.00
DATA /dev/rcdld_data132 4,622 1 2.76 13.37 319 0 0 0.00
DATA /dev/rcdld_data133 7,430 2 2.24 13.61 298 0 0 0.00
DATA /dev/rcdld_data134 4,074 1 2.74 13.80 226 0 0 0.00
DATA /dev/rcdld_data135 3,915 1 3.35 13.55 133 0 0 0.00
DATA /dev/rcdld_data136 4,020 1 3.13 13.98 164 0 0 0.00
DATA /dev/rcdld_data137 3,896 1 3.22 14.05 179 0 0 0.00
DATA /dev/rcdld_data138 2,690 1 3.66 5.41 268 0 0 0.00
DATA /dev/rcdld_data139 1,907 1 4.93 1.54 43 0 0 0.00
DATA /dev/rcdld_data14 10,898 3 1.96 16.60 144 0 0 0.00
DATA /dev/rcdld_data140 1,921 1 4.77 1.65 60 0 0 0.00
DATA /dev/rcdld_data141 1,760 0 4.77 1.18 45 0 0 0.00
DATA /dev/rcdld_data142 2,166 1 3.90 4.51 164 0 0 0.00
DATA /dev/rcdld_data143 3,355 1 3.07 15.09 193 0 0 0.00
DATA /dev/rcdld_data144 3,970 1 3.03 15.17 367 0 0 0.00
DATA /dev/rcdld_data145 2,070 1 4.46 2.49 110 0 0 0.00
DATA /dev/rcdld_data146 1,658 0 5.06 1.27 36 0 0 0.00
DATA /dev/rcdld_data147 1,705 0 4.93 1.47 57 0 0 0.00
DATA /dev/rcdld_data148 1,566 0 4.93 1.21 35 0 0 0.00
DATA /dev/rcdld_data149 1,661 0 4.91 1.20 23 0 0 0.00
DATA /dev/rcdld_data15 11,847 3 1.94 15.53 206 0 0 0.00
DATA /dev/rcdld_data150 1,630 0 4.96 1.20 29 0 0 0.00
DATA /dev/rcdld_data151 1,550 0 5.04 1.22 20 0 0 0.00
DATA /dev/rcdld_data152 1,637 0 4.76 1.29 42 0 0 0.00
DATA /dev/rcdld_data153 3,908 1 3.40 15.02 201 0 0 0.00
DATA /dev/rcdld_data154 4,188 1 3.13 15.31 300 0 0 0.00
DATA /dev/rcdld_data155 3,914 1 3.67 14.44 136 0 0 0.00
DATA /dev/rcdld_data156 3,733 1 3.38 15.07 133 0 0 0.00
DATA /dev/rcdld_data157 3,703 1 2.91 15.23 121 0 0 0.00
DATA /dev/rcdld_data158 3,735 1 2.72 15.14 167 0 0 0.00
DATA /dev/rcdld_data159 3,665 1 2.59 15.44 184 0 0 0.00
DATA /dev/rcdld_data16 3,705 1 3.35 12.71 65 0 0 0.00
DATA /dev/rcdld_data160 3,699 1 2.61 15.22 92 0 0 0.00
DATA /dev/rcdld_data161 2,009 1 3.59 1.24 65 0 0 0.00
DATA /dev/rcdld_data162 1,676 0 4.32 1.28 109 0 0 0.00
DATA /dev/rcdld_data163 1,825 1 3.68 1.25 81 0 0 0.00
DATA /dev/rcdld_data164 1,749 0 4.01 1.21 39 0 0 0.00
DATA /dev/rcdld_data165 1,808 1 3.61 1.20 70 0 0 0.00
DATA /dev/rcdld_data166 1,811 1 3.59 1.20 68 0 0 0.00
DATA /dev/rcdld_data167 1,825 1 3.58 1.32 75 0 0 0.00
DATA /dev/rcdld_data168 1,700 0 3.68 1.34 44 0 0 0.00
DATA /dev/rcdld_data169 6,738 2 2.35 8.11 417 0 0 0.00
DATA /dev/rcdld_data17 7,557 2 2.18 12.89 202 0 0 0.00
DATA /dev/rcdld_data170 6,962 2 2.42 7.83 486 0 0 0.00
DATA /dev/rcdld_data171 6,285 2 2.56 8.73 348 0 0 0.00
DATA /dev/rcdld_data172 5,552 2 2.75 9.93 377 0 0 0.00
DATA /dev/rcdld_data173 5,716 2 2.39 9.64 365 0 0 0.00
DATA /dev/rcdld_data174 6,352 2 2.32 9.15 409 0 0 0.00
DATA /dev/rcdld_data175 8,819 2 1.96 11.30 447 0 0 0.00
DATA /dev/rcdld_data176 5,367 1 2.63 10.33 377 0 0 0.00
DATA /dev/rcdld_data177 9,017 3 1.78 10.99 475 0 0 0.00
DATA /dev/rcdld_data178 4,988 1 2.64 11.15 330 0 0 0.00
DATA /dev/rcdld_data179 5,720 2 2.36 11.01 469 0 0 0.00
DATA /dev/rcdld_data18 6,851 2 2.36 13.15 195 0 0 0.00
DATA /dev/rcdld_data180 5,329 1 2.28 10.48 314 0 0 0.00
DATA /dev/rcdld_data181 5,704 2 2.47 11.09 478 0 0 0.00
DATA /dev/rcdld_data182 5,380 1 2.30 10.44 346 0 0 0.00
DATA /dev/rcdld_data183 10,188 3 1.87 11.31 805 0 0 0.00
DATA /dev/rcdld_data184 9,635 3 1.76 11.10 458 0 0 0.00
DATA /dev/rcdld_data185 6,611 2 2.09 9.49 472 0 0 0.00
DATA /dev/rcdld_data186 11,968 3 1.72 11.85 666 0 0 0.00
DATA /dev/rcdld_data187 9,209 3 1.84 12.35 580 0 0 0.00
DATA /dev/rcdld_data188 11,088 3 1.59 10.99 859 0 0 0.00
DATA /dev/rcdld_data189 10,276 3 1.72 11.26 804 0 0 0.00
DATA /dev/rcdld_data19 7,739 2 2.09 12.94 125 0 0 0.00
DATA /dev/rcdld_data190 8,679 2 1.84 11.53 356 0 0 0.00
DATA /dev/rcdld_data191 8,197 2 1.90 12.24 341 0 0 0.00
DATA /dev/rcdld_data192 10,570 3 1.73 13.83 418 0 0 0.00
DATA /dev/rcdld_data193 8,986 2 1.82 11.99 577 0 0 0.00
DATA /dev/rcdld_data194 9,727 3 1.85 11.84 549 0 0 0.00
DATA /dev/rcdld_data195 5,491 2 2.50 10.12 510 0 0 0.00
DATA /dev/rcdld_data196 5,185 1 2.37 10.62 375 0 0 0.00
DATA /dev/rcdld_data197 5,382 1 2.16 8.73 250 0 0 0.00
DATA /dev/rcdld_data198 4,909 1 2.08 9.63 136 0 0 0.00
DATA /dev/rcdld_data199 5,130 1 2.28 9.29 308 0 0 0.00
DATA /dev/rcdld_data20 8,654 2 2.09 14.26 183 0 0 0.00
DATA /dev/rcdld_data200 5,370 1 2.31 9.96 389 0 0 0.00
DATA /dev/rcdld_data201 4,690 1 2.67 10.44 204 0 0 0.00
DATA /dev/rcdld_data202 6,029 2 1.96 8.23 208 0 0 0.00
DATA /dev/rcdld_data203 2,463 1 3.83 3.44 88 0 0 0.00
DATA /dev/rcdld_data204 6,286 2 1.98 7.31 128 0 0 0.00
DATA /dev/rcdld_data205 7,262 2 1.78 7.14 217 0 0 0.00
DATA /dev/rcdld_data206 7,552 2 1.69 6.28 154 0 0 0.00
DATA /dev/rcdld_data207 5,632 2 1.94 8.20 87 0 0 0.00
DATA /dev/rcdld_data208 6,466 2 1.99 6.97 103 0 0 0.00
DATA /dev/rcdld_data209 6,317 2 1.84 7.20 75 0 0 0.00
DATA /dev/rcdld_data21 7,913 2 2.11 14.06 116 0 0 0.00
DATA /dev/rcdld_data210 7,796 2 1.71 6.64 425 0 0 0.00
DATA /dev/rcdld_data211 7,844 2 1.70 5.82 214 0 0 0.00
DATA /dev/rcdld_data212 8,994 3 1.67 5.41 453 0 0 0.00
DATA /dev/rcdld_data213 9,356 3 1.40 5.10 606 0 0 0.00
DATA /dev/rcdld_data214 8,422 2 1.76 5.92 580 0 0 0.00
DATA /dev/rcdld_data215 10,307 3 1.37 4.61 269 0 0 0.00
DATA /dev/rcdld_data216 12,873 4 1.35 3.03 170 0 0 0.00
DATA /dev/rcdld_data217 13,834 4 1.29 1.99 164 0 0 0.00
DATA /dev/rcdld_data218 10,799 3 1.53 2.20 74 0 0 0.00
DATA /dev/rcdld_data219 1,983 1 4.31 1.82 69 0 0 0.00
DATA /dev/rcdld_data22 8,293 2 2.10 14.19 489 0 0 0.00
DATA /dev/rcdld_data220 10,809 3 1.48 1.33 112 0 0 0.00
DATA /dev/rcdld_data221 10,974 3 1.51 1.41 90 0 0 0.00
DATA /dev/rcdld_data222 9,330 3 1.81 1.53 81 0 0 0.00
DATA /dev/rcdld_data223 7,473 2 2.00 3.47 42 0 0 0.00
DATA /dev/rcdld_data224 8,921 2 1.77 1.22 64 0 0 0.00
DATA /dev/rcdld_data225 8,805 2 1.74 1.56 60 0 0 0.00
DATA /dev/rcdld_data226 8,923 2 1.93 1.61 100 0 0 0.00
DATA /dev/rcdld_data227 7,220 2 1.90 2.47 75 0 0 0.00
DATA /dev/rcdld_data228 1,867 1 4.93 1.06 48 0 0 0.00
DATA /dev/rcdld_data229 1,755 0 4.30 1.07 60 0 0 0.00
DATA /dev/rcdld_data23 8,964 2 2.11 14.45 124 0 0 0.00
DATA /dev/rcdld_data230 1,800 1 4.67 1.06 156 0 0 0.00
DATA /dev/rcdld_data231 1,900 1 3.90 1.06 132 0 0 0.00
DATA /dev/rcdld_data232 1,749 0 4.01 1.00 60 0 0 0.00
DATA /dev/rcdld_data233 1,618 0 4.00 1.00 50 0 0 0.00
DATA /dev/rcdld_data234 1,709 0 3.90 1.00 34 0 0 0.00
DATA /dev/rcdld_data235 1,702 0 3.95 1.00 48 0 0 0.00
DATA /dev/rcdld_data236 1,826 1 3.75 1.00 34 0 0 0.00
DATA /dev/rcdld_data237 1,843 1 3.76 1.00 35 0 0 0.00
DATA /dev/rcdld_data238 1,707 0 3.90 1.00 33 0 0 0.00
DATA /dev/rcdld_data239 1,413 0 4.18 1.00 33 0 0 0.00
DATA /dev/rcdld_data24 8,027 2 2.24 14.41 145 0 0 0.00
DATA /dev/rcdld_data240 1,329 0 4.16 1.00 35 0 0 0.00
DATA /dev/rcdld_data241 1,444 0 4.05 1.00 49 0 0 0.00
DATA /dev/rcdld_data242 1,506 0 4.08 1.00 69 0 0 0.00
DATA /dev/rcdld_data243 1,440 0 4.16 1.00 50 0 0 0.00
DATA /dev/rcdld_data244 1,468 0 4.25 1.00 135 0 0 0.00
DATA /dev/rcdld_data245 1,651 0 4.35 1.00 155 0 0 0.00
DATA /dev/rcdld_data246 1,656 0 3.88 1.00 233 0 0 0.00
DATA /dev/rcdld_data247 1,568 0 3.94 1.00 48 0 0 0.00
DATA /dev/rcdld_data248 1,508 0 3.88 1.00 44 0 0 0.00
DATA /dev/rcdld_data249 3,972 1 2.76 4.08 246 0 0 0.00
DATA /dev/rcdld_data25 7,374 2 1.80 12.85 257 0 0 0.00
DATA /dev/rcdld_data250 5,068 1 2.29 8.78 125 0 0 0.00
DATA /dev/rcdld_data251 4,108 1 2.56 9.76 55 0 0 0.00
DATA /dev/rcdld_data252 1,290 0 4.40 1.00 47 0 0 0.00
DATA /dev/rcdld_data253 1,333 0 4.38 1.00 29 0 0 0.00
DATA /dev/rcdld_data254 1,441 0 4.32 1.00 109 0 0 0.00
DATA /dev/rcdld_data255 1,557 0 4.03 1.00 116 0 0 0.00
DATA /dev/rcdld_data256 1,744 0 4.52 1.00 28 0 0 0.00
DATA /dev/rcdld_data257 1,843 1 4.03 1.07 277 0 0 0.00
DATA /dev/rcdld_data258 9,077 3 1.98 2.48 68 0 0 0.00
DATA /dev/rcdld_data259 7,746 2 2.67 1.48 194 0 0 0.00
DATA /dev/rcdld_data26 9,359 3 2.02 13.01 157 0 0 0.00
DATA /dev/rcdld_data260 4,048 1 2.74 1.97 184 0 0 0.00
DATA /dev/rcdld_data261 4,359 1 3.01 10.39 61 0 0 0.00
DATA /dev/rcdld_data262 1,708 0 4.15 4.09 55 0 0 0.00
DATA /dev/rcdld_data263 4,487 1 3.14 10.11 63 0 0 0.00
DATA /dev/rcdld_data264 4,221 1 2.81 10.90 47 0 0 0.00
DATA /dev/rcdld_data265 4,361 1 2.74 10.38 44 0 0 0.00
DATA /dev/rcdld_data266 4,380 1 3.16 10.39 32 0 0 0.00
DATA /dev/rcdld_data267 4,165 1 2.42 10.95 25 0 0 0.00
DATA /dev/rcdld_data268 4,151 1 3.15 10.77 59 0 0 0.00
DATA /dev/rcdld_data269 4,274 1 2.94 10.67 30 0 0 0.00
DATA /dev/rcdld_data27 9,198 3 1.88 15.87 281 0 0 0.00
DATA /dev/rcdld_data270 2,458 1 3.35 8.57 156 0 0 0.00
DATA /dev/rcdld_data271 4,428 1 3.31 10.48 392 0 0 0.00
DATA /dev/rcdld_data272 3,647 1 3.07 9.86 21 0 0 0.00
DATA /dev/rcdld_data273 4,366 1 3.46 10.37 33 0 0 0.00
DATA /dev/rcdld_data274 3,141 1 3.56 8.73 86 0 0 0.00
DATA /dev/rcdld_data275 5,029 1 2.97 9.01 103 0 0 0.00
DATA /dev/rcdld_data276 5,068 1 3.15 8.98 24 0 0 0.00
DATA /dev/rcdld_data277 4,523 1 2.78 9.88 24 0 0 0.00
DATA /dev/rcdld_data278 3,731 1 3.19 12.45 27 0 0 0.00
DATA /dev/rcdld_data279 2,901 1 3.97 16.38 33 0 0 0.00
DATA /dev/rcdld_data28 8,458 2 2.61 15.69 256 0 0 0.00
DATA /dev/rcdld_data280 2,173 1 4.09 9.29 32 0 0 0.00
DATA /dev/rcdld_data281 1,485 0 4.13 1.00 42 0 0 0.00
DATA /dev/rcdld_data282 1,574 0 4.02 1.00 23 0 0 0.00
DATA /dev/rcdld_data283 942 0 3.77 1.00 120 0 0 0.00
DATA /dev/rcdld_data284 1,113 0 3.66 1.00 118 0 0 0.00
DATA /dev/rcdld_data285 1,070 0 3.38 1.00 71 0 0 0.00
DATA /dev/rcdld_data286 1,131 0 3.32 1.00 36 0 0 0.00
DATA /dev/rcdld_data287 1,314 0 3.44 1.00 142 0 0 0.00
DATA /dev/rcdld_data288 1,324 0 3.52 1.00 47 0 0 0.00
DATA /dev/rcdld_data289 1,592 0 3.55 1.00 39 0 0 0.00
DATA /dev/rcdld_data29 6,182 2 3.61 16.03 339 0 0 0.00
DATA /dev/rcdld_data290 1,633 0 3.50 1.00 80 0 0 0.00
DATA /dev/rcdld_data291 755 0 4.20 1.00 353 0 0 0.00
DATA /dev/rcdld_data292 828 0 3.84 1.00 364 0 0 0.00
DATA /dev/rcdld_data293 2,061 1 3.73 1.00 1,263 0 0 0.00
DATA /dev/rcdld_data294 1,349 0 3.53 1.00 882 0 0 0.00
DATA /dev/rcdld_data295 810 0 6.16 1.00 389 0 0 0.00
DATA /dev/rcdld_data296 847 0 4.84 1.00 220 0 0 0.00
DATA /dev/rcdld_data297 718 0 4.11 1.00 306 0 0 0.00
DATA /dev/rcdld_data298 667 0 3.90 1.01 307 0 0 0.00
DATA /dev/rcdld_data30 5,271 1 3.51 11.27 143 0 0 0.00
DATA /dev/rcdld_data31 8,064 2 2.63 12.71 195 0 0 0.00
DATA /dev/rcdld_data32 8,192 2 2.87 13.89 230 0 0 0.00
DATA /dev/rcdld_data33 5,059 1 3.52 11.93 272 0 0 0.00
DATA /dev/rcdld_data34 7,572 2 2.97 13.31 400 0 0 0.00
DATA /dev/rcdld_data35 3,021 1 5.24 7.29 273 0 0 0.00
DATA /dev/rcdld_data36 2,977 1 5.61 7.63 258 0 0 0.00
DATA /dev/rcdld_data37 7,592 2 2.99 13.29 392 0 0 0.00
DATA /dev/rcdld_data38 7,341 2 3.06 13.77 464 0 0 0.00
DATA /dev/rcdld_data39 7,335 2 3.27 13.62 275 0 0 0.00
DATA /dev/rcdld_data40 8,154 2 2.71 12.20 317 0 0 0.00
DATA /dev/rcdld_data41 6,359 2 3.30 12.02 256 0 0 0.00
DATA /dev/rcdld_data42 7,887 2 2.91 12.63 277 0 0 0.00
DATA /dev/rcdld_data43 5,491 2 3.38 9.64 187 0 0 0.00
DATA /dev/rcdld_data44 5,178 1 3.19 10.62 186 0 0 0.00
DATA /dev/rcdld_data45 7,507 2 2.74 13.37 182 0 0 0.00
DATA /dev/rcdld_data46 8,039 2 2.60 12.48 194 0 0 0.00
DATA /dev/rcdld_data47 4,757 1 3.80 11.30 268 0 0 0.00
DATA /dev/rcdld_data48 4,678 1 3.82 11.58 188 0 0 0.00
DATA /dev/rcdld_data49 5,084 1 3.48 10.31 163 0 0 0.00
DATA /dev/rcdld_data50 12,517 3 2.04 15.62 461 0 0 0.00
DATA /dev/rcdld_data51 10,891 3 1.78 15.53 211 0 0 0.00
DATA /dev/rcdld_data52 11,468 3 1.74 16.54 221 0 0 0.00
DATA /dev/rcdld_data53 10,226 3 1.86 13.91 279 0 0 0.00
DATA /dev/rcdld_data54 9,799 3 2.03 14.51 241 0 0 0.00
DATA /dev/rcdld_data55 7,644 2 2.08 15.84 213 0 0 0.00
DATA /dev/rcdld_data56 7,789 2 2.05 16.33 225 0 0 0.00
DATA /dev/rcdld_data57 8,360 2 2.35 12.60 204 0 0 0.00
DATA /dev/rcdld_data58 9,011 3 2.21 16.56 239 0 0 0.00
DATA /dev/rcdld_data59 9,612 3 2.16 15.46 244 0 0 0.00
DATA /dev/rcdld_data60 9,431 3 1.99 15.84 204 0 0 0.00
DATA /dev/rcdld_data61 9,154 3 2.32 12.71 169 0 0 0.00
DATA /dev/rcdld_data62 13,900 4 1.96 14.39 226 0 0 0.00
DATA /dev/rcdld_data63 11,410 3 1.94 14.28 177 0 0 0.00
DATA /dev/rcdld_data64 13,655 4 1.90 14.26 226 0 0 0.00
DATA /dev/rcdld_data65 13,445 4 1.75 14.45 218 0 0 0.00
DATA /dev/rcdld_data66 2,213 1 5.37 2.71 140 0 0 0.00
DATA /dev/rcdld_data67 2,083 1 5.17 2.90 164 0 0 0.00
DATA /dev/rcdld_data68 2,274 1 4.87 6.14 358 0 0 0.00
DATA /dev/rcdld_data69 2,075 1 5.42 2.83 126 0 0 0.00
DATA /dev/rcdld_data70 2,136 1 4.69 2.77 116 0 0 0.00
DATA /dev/rcdld_data71 2,097 1 5.69 2.77 134 0 0 0.00
DATA /dev/rcdld_data72 2,165 1 5.22 2.66 122 0 0 0.00
DATA /dev/rcdld_data73 2,286 1 5.45 2.97 274 0 0 0.00
DATA /dev/rcdld_data74 3,972 1 3.60 13.89 215 0 0 0.00
DATA /dev/rcdld_data75 4,137 1 3.26 13.31 202 0 0 0.00
DATA /dev/rcdld_data76 3,885 1 3.57 14.06 193 0 0 0.00
DATA /dev/rcdld_data77 3,897 1 3.52 14.01 158 0 0 0.00
DATA /dev/rcdld_data78 4,037 1 3.29 13.68 151 0 0 0.00
DATA /dev/rcdld_data79 4,031 1 3.62 13.44 178 0 0 0.00
DATA /dev/rcdld_data80 3,960 1 3.39 13.47 138 0 0 0.00
DATA /dev/rcdld_data81 4,029 1 3.47 13.74 173 0 0 0.00
DATA /dev/rcdld_data82 4,033 1 3.41 13.43 147 0 0 0.00
DATA /dev/rcdld_data83 3,933 1 3.41 13.75 141 0 0 0.00
DATA /dev/rcdld_data84 4,503 1 2.94 11.70 266 0 0 0.00
DATA /dev/rcdld_data85 4,359 1 3.01 11.96 296 0 0 0.00
DATA /dev/rcdld_data86 4,091 1 3.42 13.47 186 0 0 0.00
DATA /dev/rcdld_data87 3,931 1 3.69 14.03 173 0 0 0.00
DATA /dev/rcdld_data88 3,023 1 4.34 8.63 124 0 0 0.00
DATA /dev/rcdld_data90 2,625 1 4.65 2.42 101 0 0 0.00
DATA /dev/rcdld_data91 5,979 2 2.86 17.31 205 0 0 0.00
DATA /dev/rcdld_data92 6,086 2 2.87 17.02 243 0 0 0.00
DATA /dev/rcdld_data93 8,138 2 2.43 16.90 242 0 0 0.00
DATA /dev/rcdld_data94 6,185 2 2.78 16.83 171 0 0 0.00
DATA /dev/rcdld_data95 8,927 2 2.36 16.68 255 0 0 0.00
DATA /dev/rcdld_data96 6,271 2 2.91 16.92 227 0 0 0.00
DATA /dev/rcdld_data97 6,928 2 2.70 16.90 217 0 0 0.00
DATA /dev/rcdld_data98 6,944 2 2.80 15.93 261 0 0 0.00
DATA /dev/rcdld_data99 8,442 2 2.35 13.60 1,510 0 0 0.00
DATA_A /dev/rcdld_data_a01 67 0 4.63 1.00 78 0 0 0.00
DATA_A /dev/rcdld_data_a02 46 0 4.35 1.00 49 0 0 0.00
DATA_A /dev/rcdld_data_a03 46 0 3.91 1.00 46 0 0 0.00
DATA_A /dev/rcdld_data_a04 50 0 4.80 1.00 77 0 0 0.00
DATA_A /dev/rcdld_data_a05 39 0 3.33 1.00 32 0 0 0.00
DATA_A /dev/rcdld_data_a06 34 0 2.94 1.00 56 0 0 0.00
DATA_A /dev/rcdld_data_a07 31 0 2.26 1.00 34 0 0 0.00
DATA_A /dev/rcdld_data_a08 32 0 3.44 1.00 27 0 0 0.00
DATA_A /dev/rcdld_data_a09 37 0 2.70 1.00 43 0 0 0.00
DATA_A /dev/rcdld_data_a10 48 0 4.79 1.00 68 0 0 0.00
DATA_A /dev/rcdld_data_a11 43 0 3.49 1.00 90 0 0 0.00
DATA_A /dev/rcdld_data_a12 59 0 4.75 1.00 89 0 0 0.00
DATA_A /dev/rcdld_data_a13 38 0 6.05 1.00 69 0 0 0.00
DATA_A /dev/rcdld_data_a14 41 0 3.66 1.00 56 0 0 0.00
DATA_A /dev/rcdld_data_a15 39 0 2.56 1.00 70 0 0 0.00
DATA_A /dev/rcdld_data_a16 43 0 3.26 1.00 59 0 0 0.00
DATA_A /dev/rcdld_data_a17 36 0 2.50 1.00 23 0 0 0.00
DATA_A /dev/rcdld_data_a18 36 0 3.33 1.00 27 0 0 0.00
DATA_A /dev/rcdld_data_a19 50 0 4.00 1.00 53 0 0 0.00
DATA_A /dev/rcdld_data_a20 67 0 6.57 1.00 85 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx01 18 0 3.89 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx02 18 0 3.89 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx03 21 0 3.81 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx04 28 0 2.86 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx05 24 0 2.92 1.00 5 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx06 21 0 4.29 1.00 5 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx07 29 0 1.72 1.00 7 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx08 24 0 1.67 1.00 7 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx09 24 0 1.67 1.00 7 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx10 24 0 1.67 1.00 7 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx11 24 0 1.67 1.00 7 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx12 30 0 1.67 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx13 30 0 1.67 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx14 30 0 1.67 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx15 30 0 1.67 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx16 30 0 1.33 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx17 30 0 1.33 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx18 30 0 1.33 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx19 30 0 1.33 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx20 30 0 1.33 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx21 30 0 1.33 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx22 30 0 1.33 1.00 6 0 0 0.00
DATA_CW_INDEX01 /dev/rcdld_cw_indx23 30 0 1.33 1.00 6 0 0 0.00
GDZC /dev/rcdld_gdzc1 12 0 6.67 1.00 6 0 0 0.00
GDZC /dev/rcdld_gdzc2 21 0 4.29 1.00 5 0 0 0.00
GGFW /dev/rcdld_ggfw 81 0 1.11 1.00 6 0 0 0.00
IUFO /dev/rnnc_iufo 17,231 5 0.21 1.00 6 0 0 0.00
JYDATA /dev/rcdld_jydata01 2,521 1 2.64 1.00 840 0 0 0.00
JYDATA /dev/rcdld_jydata02 2,616 1 2.43 1.00 870 0 0 0.00
JYDATA /dev/rcdld_jydata03 2,492 1 2.25 1.00 2,729 1 0 0.00
JYDATA /dev/rcdld_jydata04 2,270 1 2.45 1.00 789 0 0 0.00
JYINDEX /dev/rcdld_jyindex01 2,288 1 0.56 1.00 3,569 1 0 0.00
JYLOBDATA /dev/rcdld_jylobdata 128 0 0.47 1.00 5 0 0 0.00
JYSHORTDATA /dev/rcdld_jyshortdat 75 0 0.67 1.00 5 0 0 0.00
JYTEMP /dev/rcdld_jytemp 0 0     3 0 0  
LDGGSJ /dev/rcdld_gongan 27 0 4.07 1.00 6 0 0 0.00
LDJG /dev/rcdld_ldjg01 6 0 10.00 1.00 6 0 0 0.00
LDYL /dev/rcdld_yldata01 6 0 1.67 1.00 6 0 0 0.00
NNC_DATA01 /dev/rnnc_data01 82,632 23 0.22 1.00 6 0 0 0.00
NNC_DATA01 /dev/rnnc_data1_1 39,036 11 0.22 1.00 6 0 0 0.00
NNC_DATA01 /dev/rnnc_data1_2 43,752 12 0.21 1.00 6 0 0 0.00
NNC_DATA02 /dev/rnnc_data02 6 0 1.67 1.00 6 0 0 0.00
NNC_DATA03 /dev/rnnc_data03 6 0 1.67 1.00 6 0 0 0.00
NNC_INDEX01 /dev/rnnc_ind01_01 20 0 2.50 1.00 5 0 0 0.00
NNC_INDEX01 /dev/rnnc_index01 6 0 1.67 1.00 6 0 0 0.00
NNC_INDEX01 /dev/rnnc_index04 31 0 0.32 1.00 6 0 0 0.00
NNC_INDEX02 /dev/rnnc_index02 6 0 1.67 1.00 6 0 0 0.00
NNC_INDEX03 /dev/rnnc_index03 6 0 1.67 1.00 6 0 0 0.00
PENSION_DATA /dev/rcdld_sbpenda1 12 0 6.67 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor1 183 0 6.94 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor10 221 0 3.57 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor11 299 0 3.24 1.04 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor12 188 0 2.66 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor13 137 0 2.92 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor14 164 0 2.74 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor15 239 0 2.80 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor16 210 0 3.48 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor17 191 0 3.14 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor18 1,065 0 1.10 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor19 215 0 2.33 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor2 187 0 7.54 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor20 203 0 2.66 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor21 188 0 3.35 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor22 225 0 3.29 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor23 690 0 0.96 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor24 208 0 1.78 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor25 23 0 1.74 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor26 19 0 1.58 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor27 24 0 1.67 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor28 24 0 1.67 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor29 24 0 1.67 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor3 180 0 4.61 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor30 24 0 1.67 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor31 24 0 1.67 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor32 24 0 1.67 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor33 389 0 0.39 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor34 129 0 0.62 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor35 77 0 0.65 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor36 183 0 0.27 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor37 24 0 1.67 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor38 395 0 0.28 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor39 24 0 1.67 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor4 292 0 2.81 1.04 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor40 400 0 0.40 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor41 26 0 1.15 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor42 556 0 0.29 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor43 26 0 1.15 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor44 26 0 1.15 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor45 26 0 1.15 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor46 79 0 0.51 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor47 397 0 0.35 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor48 26 0 1.15 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor49 189 0 0.53 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor5 152 0 2.89 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor50 30 0 1.33 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor51 79 0 0.63 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor52 28 0 1.07 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor53 28 0 1.43 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor54 27 0 1.11 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor55 190 0 0.53 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor56 134 0 0.37 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor57 132 0 0.23 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor58 26 0 1.54 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor59 130 0 0.92 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor6 199 0 2.26 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor60 288 0 0.31 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor61 292 0 0.62 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor62 235 0 0.64 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor63 89 0 1.12 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor64 30 0 2.00 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor65 136 0 0.66 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor66 138 0 0.72 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor67 34 0 1.76 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor68 30 0 1.67 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor69 30 0 2.33 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor7 147 0 3.88 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor70 87 0 1.38 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor71 87 0 1.15 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor72 1,797 0 0.44 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor73 328 0 0.73 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor74 170 0 2.53 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor75 151 0 2.25 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor76 174 0 2.76 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor77 63 0 3.33 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor78 133 0 2.48 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor79 187 0 1.55 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor8 130 0 4.00 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor80 90 0 3.11 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor81 98 0 3.16 1.00 7 0 0 0.00
SHORDATA /dev/rcdld_sbshor82 403 0 1.22 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor83 551 0 1.03 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor84 288 0 1.42 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor85 131 0 2.90 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor86 400 0 0.85 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor87 458 0 0.76 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor88 111 0 2.88 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor89 277 0 1.48 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor9 160 0 5.19 1.00 5 0 0 0.00
SHORDATA /dev/rcdld_sbshor90 243 0 1.03 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor91 249 0 1.69 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor92 99 0 2.42 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor93 171 0 2.40 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor94 189 0 1.27 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor95 688 0 0.51 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor96 141 0 1.13 1.00 6 0 0 0.00
SHORDATA /dev/rcdld_sbshor97 133 0 2.63 1.00 6 0 0 0.00
SYBX_DATA /dev/rcdld_sydata01 6 0 10.00 1.00 6 0 0 0.00
SYBX_DATA /dev/rcdld_sydata02 22 0 2.27 1.00 5 0 0 0.00
SYSAUX /dev/rcdld_sysaux01 6,657 2 4.15 3.81 2,178 1 0 0.00
SYSAUX /dev/rcdld_sysaux02 7,618 2 3.68 4.57 743 0 0 0.00
SYSAUX /dev/rcdld_sysaux03 17,671 5 1.82 2.53 493 0 0 0.00
SYSAUX /dev/rcdld_sysaux04 21,843 6 1.34 2.19 286 0 0 0.00
SYSAUX /dev/rcdld_sysaux05 13,098 4 1.92 3.50 171 0 0 0.00
SYSAUX /dev/rcdld_sysaux06 14,086 4 2.38 5.14 176 0 0 0.00
SYSTEM /dev/rcdld_system01 239 0 9.08 1.00 350 0 0 0.00
SYSTEM /dev/rcdld_system02 499 0 7.78 1.00 366 0 0 0.00
SYSTEM /dev/rcdld_system03 382 0 8.38 1.01 297 0 0 0.00
TEMP /dev/rcdld_temp01 986,377 274 0.31 1.96 75,394 21 0  
TEMPDATA /dev/rtempdata01 183 0 0.38 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata02 77 0 0.52 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata03 77 0 0.52 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata04 24 0 1.67 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata05 77 0 0.52 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata06 289 0 0.24 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata07 24 0 1.25 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata08 24 0 0.83 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata09 77 0 0.65 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata10 20 0 1.50 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata11 20 0 1.00 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata12 20 0 0.50 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata13 73 0 0.41 1.00 5 0 0 0.00
TEMPDATA /dev/rtempdata14 26 0 1.15 1.00 6 0 0 0.00
TEMPDATA /dev/rtempdata15 26 0 1.15 1.00 6 0 0 0.00
TEMPDATA /dev/rtempdata16 26 0 1.15 1.00 6 0 0 0.00
TEMPDATA /dev/rtempdata29 134 0 0.30 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata30 187 0 0.48 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata31 81 0 0.62 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata32 129 0 0.31 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata33 182 0 0.44 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata34 129 0 0.31 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata35 23 0 1.30 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata36 136 0 0.51 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata37 30 0 1.33 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata38 136 0 0.44 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata39 242 0 0.41 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata40 30 0 1.00 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata41 136 0 0.29 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata42 83 0 0.60 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata43 83 0 0.48 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata44 30 0 1.00 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata45 83 0 0.36 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata46 83 0 0.48 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata47 30 0 1.00 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata48 83 0 0.60 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata49 83 0 0.60 1.00 7 0 0 0.00
TEMPDATA /dev/rtempdata50 30 0 1.00 1.00 7 0 0 0.00
UNDOTBS1 /dev/rcdld_undo01_01 24 0 1.67 1.00 5 0 0 0.00
UNDOTBS1 /dev/rcdld_undo01_02 24 0 1.67 1.00 5 0 2 0.00
UNDOTBS1 /dev/rcdld_undo01_03 18 0 1.11 1.00 6 0 0 0.00
UNDOTBS1 /dev/rcdld_undo01_04 31 0 0.32 1.00 6 0 0 0.00
UNDOTBS1 /dev/rcdld_undo01_05 31 0 0.32 1.00 6 0 0 0.00
UNDOTBS2 /dev/rcdld_undo02_01 8 0 1.25 1.00 2,349 1 5 0.00
UNDOTBS2 /dev/rcdld_undo02_02 12 0 2.50 1.00 954 0 0 0.00
USERS /dev/rcdld_users01 642 0 0.11 1.00 6 0 0 0.00
XNH_DATA /dev/rcdld_xnh01 12 0 2.50 1.00 6 0 0 0.00
XNH_DATA /dev/rcdld_xnh02 12 0 2.50 1.00 6 0 0 0.00
XNH_DATA /dev/rcdld_xnh03 12 0 2.50 1.00 6 0 0 0.00
XNH_DATA /dev/rcdld_xnh04 18 0 1.11 1.00 6 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 80 85,916,115 17,416,316 116,176 0 0 7


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 1 8985 24278 170416 15092100 170416  
E 0 0 2685 18817 84169 15092100 84169  

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 1.63 1,218,137,275
D 15,968 0.20 1,915,162 1.30 976,410,726
D 23,952 0.30 2,872,743 1.20 902,175,415
D 31,936 0.40 3,830,324 1.15 860,188,348
D 39,920 0.50 4,787,905 1.11 833,579,306
D 47,904 0.60 5,745,486 1.09 813,798,928
D 55,888 0.70 6,703,067 1.06 796,266,052
D 63,872 0.80 7,660,648 1.03 769,070,597
D 71,856 0.90 8,618,229 1.01 757,783,608
D 79,840 1.00 9,575,810 1.00 749,130,483
D 79,872 1.00 9,579,648 1.00 749,103,039
D 87,824 1.10 10,533,391 0.99 741,157,990
D 95,808 1.20 11,490,972 0.98 731,730,095
D 103,792 1.30 12,448,553 0.97 724,752,125
D 111,776 1.40 13,406,134 0.96 718,661,690
D 119,760 1.50 14,363,715 0.95 713,718,108
D 127,744 1.60 15,321,296 0.95 709,078,518
D 135,728 1.70 16,278,877 0.94 702,809,390
D 143,712 1.80 17,236,458 0.93 696,225,151
D 151,696 1.90 18,194,039 0.92 689,462,945
D 159,680 2.00 19,151,620 0.90 676,712,853

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
29.45 13,272 31,799

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 17,243 2,601.83 7.97 0.31 100.00 0.00 1,048,576
E 20,480 17,306 3,904.34 6.32 0.16 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 11,978 11,978 0 0
64K 128K 115 115 0 0
128K 256K 771 771 0 0
256K 512K 4 4 0 0
512K 1024K 1,066 1,066 0 0
1M 2M 896 896 0 0
4M 8M 15 14 1 0
8M 16M 2 2 0 0
16M 32M 2 0 2 0
128M 256M 2 0 0 2
256M 512M 2 0 0 2
512M 1024M 4 0 0 4
1G 2G 6 0 4 2

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 2,341,107.88 1,322,295.73 64.00 1
5,120 0.25 2,341,107.88 739,603.29 76.00 0
10,240 0.50 2,341,107.88 696,118.64 77.00 0
15,360 0.75 2,341,107.88 639,386.49 79.00 0
20,480 1.00 2,341,107.88 400,168.42 85.00 0
24,576 1.20 2,341,107.88 230,636.10 91.00 0
28,672 1.40 2,341,107.88 228,850.51 91.00 0
32,768 1.60 2,341,107.88 228,850.51 91.00 0
36,864 1.80 2,341,107.88 228,850.51 91.00 0
40,960 2.00 2,341,107.88 228,850.51 91.00 0
61,440 3.00 2,341,107.88 228,850.51 91.00 0
81,920 4.00 2,341,107.88 228,850.51 91.00 0
122,880 6.00 2,341,107.88 228,850.51 91.00 0
163,840 8.00 2,341,107.88 228,850.51 91.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
4,112 0.20 1,958 86,952 963,019,281 1.00 44,737 1.15 1,812,034,270
6,160 0.30 2,503 111,452 963,023,409 1.00 40,609 1.04 1,812,048,178
8,208 0.40 2,794 121,310 963,025,154 1.00 38,864 1.00 1,812,048,653
10,256 0.50 3,085 130,097 963,025,155 1.00 38,863 1.00 1,812,048,771
12,304 0.60 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
14,352 0.70 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
16,400 0.80 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
18,448 0.90 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
20,496 1.00 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
22,544 1.10 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
24,592 1.20 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
26,640 1.30 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
28,688 1.40 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
30,736 1.50 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
32,784 1.60 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
34,832 1.70 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
36,880 1.80 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
38,928 1.90 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784
40,976 2.00 3,221 136,809 963,025,155 1.00 38,863 1.00 1,812,048,784

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
undo header 7 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
WF-AWR Flush 51 51 0 15 7 471.07
TO-Temp Object 3,820 3,820 0 2,920 2 0.58
CF-Controlfile Transaction 15,066 15,066 0 1,386 1 0.73
PS-PX Process Reservation 6,133 4,698 1,435 1,407 1 0.51
XR-Quiesce / Force Logging (database force logging) 1,196 1,196 0 1,196 1 0.53
TT-Tablespace 219,059 219,059 0 1,336 1 0.47
TM-DML 19,671 19,671 0 432 0 0.45
RO-Multiple Object Reuse (fast object reuse) 387 387 0 128 0 0.58
TX-Transaction (index contention) 68 68 0 2 0 29.50
AF-Advisor Framework (task serialization) 163 162 1 124 0 0.43
HW-Segment High Water Mark 17,658 17,656 2 112 0 0.46
TX-Transaction 10,279 10,279 0 1 0 22.00
SK-Shrink Segment 52 52 0 28 0 0.57
IR-Instance Recovery 92 92 0 25 0 0.40
TC-Tablespace Checkpoint (contention2) 30 30 0 23 0 0.39
FB-Format Block 49 49 0 15 0 0.60
JQ-Job Queue 39 29 10 13 0 0.69
SW-Suspend Writes 144 144 0 13 0 0.46
TD-KTF map table enqueue (KTF dump entries) 12 12 0 12 0 0.42
WR-LNS archiving log 6 6 0 3 0 0.67
UL-User-defined 4 4 0 1 0 1.00
WP-AWR Purge 1 1 0 1 0 1.00
WL-Being Written Redo Log 6 6 0 3 0 0.00
DR-Distributed Recovery 2 2 0 2 0 0.00
MW-MWIN Schedule 2 2 0 2 0 0.00
US-Undo Segment 2 2 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 6,948 0.00   0 0  
AWR Alerted Metric Element list 88,387 0.00   0 0  
Consistent RBA 8,732 0.00   0 0  
FAL request queue 107 0.00   0 0  
FAL subheap alocation 107 0.00   0 0  
FIB s.o chain latch 420 0.00   0 0  
FOB s.o list latch 15,487 0.01 0.00 0 0  
JS broadcast add buf latch 818 0.00   0 0  
JS broadcast drop buf latch 818 0.00   0 0  
JS broadcast load blnc latch 715 0.00   0 0  
JS mem alloc latch 12 0.00   0 0  
JS queue access latch 12 0.00   0 0  
JS queue state obj latch 21,450 0.00   0 0  
JS slv state obj latch 171,049 0.00   0 0  
KCL gc element parent latch 80,106,163 0.02 0.16 0 1,750 0.40
KJC message pool free list 331,460 0.01 0.00 0 291,729 0.00
KJCT flow control latch 17,083,935 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 1,199 0.00   0 0  
KPON ksr channel latch 751 0.00   0 0  
KSXR large replies 2 0.00   0 0  
KTF sga latch 24 0.00   0 1,092 0.00
KWQMN job cache list latch 344 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
LGWR NS Write 1,539 0.00   0 0  
Memory Management Latch 0     0 1,199 0.00
OS process 6,441 0.00   0 0  
OS process allocation 5,426 0.07 0.00 0 0  
OS process: request allocation 3,975 0.03 0.00 0 0  
PL/SQL warning settings 39,330 0.00   0 0  
SGA IO buffer pool latch 600,286 0.00 0.00 0 600,287 0.00
SQL memory manager latch 1 0.00   0 1,196 0.00
SQL memory manager workarea list latch 373,164 0.00   0 0  
Shared B-Tree 148 0.00   0 0  
active checkpoint queue latch 49,427 1.05 0.00 0 0  
active service list 27,601 0.03 0.14 0 2,390 0.00
alert log latch 6,168 0.00   0 0  
archive control 650 0.00   0 0  
archive process latch 1,422 0.00   0 0  
begin backup scn array 1,372 0.00   0 0  
business card 1,352 0.00   0 0  
cache buffer handles 1,134 0.00   0 0  
cache buffers chains 184,105,729 0.00 0.00 0 49,866,370 0.00
cache buffers lru chain 572,687 0.04 0.00 0 50,105,326 0.00
cache table scan latch 0     0 896,285 0.00
channel anchor 1,504 0.00   0 0  
channel handle pool latch 30,922 0.00 0.00 0 0  
channel operations parent latch 2,586,296 0.07 0.00 0 0  
checkpoint queue latch 5,312,712 0.00 0.00 0 97,238 0.00
client/application info 15,001 0.00   0 0  
commit callback allocation 7,765 0.00   0 0  
compile environment latch 2,666 0.00   0 0  
dictionary lookup 98 0.00   0 0  
dml lock allocation 39,414 0.00 0.00 0 0  
dummy allocation 5,401 0.04 0.00 0 0  
enqueue hash chains 2,174,431 0.03 0.00 0 1,330 0.00
enqueues 1,546,197 0.07 0.00 0 0  
error message lists 3,070 0.00   0 0  
event group latch 1,954 0.00   0 0  
file cache latch 12,847 0.00   0 0  
gcs opaque info freelist 35,924 0.00 0.00 0 0  
gcs partitioned table hash 1,709,109 0.00   0 0  
gcs resource freelist 19,192,792 0.01 0.00 0 1,693,544 0.00
gcs resource hash 47,479,322 0.00 0.00 0 0  
gcs shadows freelist 1,735,077 0.00   0 1,705,475 0.00
ges caches resource lists 683,588 0.04 0.00 0 500,441 0.03
ges deadlock list 7,441 0.00   0 8 0.00
ges domain table 560,364 0.00   0 0  
ges enqueue table freelist 652,179 0.00   0 0  
ges group table 832,345 0.00 0.00 0 0  
ges process hash list 52,910 0.00   0 0  
ges process parent latch 1,291,425 0.00 0.00 0 0  
ges process table freelist 3,974 0.05 0.00 0 0  
ges resource hash list 1,105,549 0.07 0.00 0 58,060 0.09
ges resource scan list 794 0.00   0 0  
ges resource table freelist 90,985 0.02 0.00 0 0  
ges timeout list 8,732 0.00   0 7,440 0.01
global KZLD latch for mem in SGA 1,895 0.00   0 0  
global tx hash mapping 139,502 0.00 0.00 0 0  
hash table column usage latch 336 0.00   0 6,301 0.00
hash table modification latch 181 0.00   0 0  
job workq parent latch 0     0 64 0.00
job_queue_processes parameter latch 91 0.00   0 0  
kks stats 12,637 0.00   0 0  
kokc descriptor allocation latch 86 0.00   0 0  
ksuosstats global area 530 0.00   0 0  
ktm global data 63,963 0.00   0 0  
kwqbsn:qsga 147 0.00   0 0  
lgwr LWN SCN 8,732 0.01 0.00 0 0  
library cache 1,756,246 0.00 0.00 0 2,020 0.00
library cache load lock 1,072 0.00   0 0  
library cache lock 1,718,043 0.00 0.00 0 0  
library cache lock allocation 20,173 0.00   0 0  
library cache pin 122,911 0.00   0 587 0.00
library cache pin allocation 1,002 0.00   0 0  
list of block allocation 5,172 0.02 0.00 0 0  
loader state object freelist 22,918 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 1,449 0.00   0 5,401,416 0.00
message pool operations parent latch 134,528 0.00   0 0  
messages 425,209 0.27 0.00 0 0  
mostly latch-free SCN 8,914 1.87 0.01 0 0  
multiblock read objects 2,099,780 0.00 0.00 0 0  
name-service memory objects 11,220 0.00   0 0  
name-service namespace bucket 39,716 0.00   0 0  
name-service pending queue 9,242 0.00   0 0  
name-service request 60 0.00   0 0  
name-service request queue 45,610 0.00   0 0  
ncodef allocation latch 60 0.00   0 0  
object queue header heap 234,999 0.00   0 233,419 0.00
object queue header operation 49,267,686 0.00 0.00 0 0  
object stats modification 20,220 0.01 0.00 0 0  
parallel query alloc buffer 13,944 0.01 0.00 0 0  
parallel query stats 2,430 0.00   0 0  
parallel txn reco latch 64,368 0.00   0 0  
parameter list 3,293 0.00   0 0  
parameter table allocation management 7,978 0.00   0 0  
post/wait queue 20,608 0.00   0 2,779 0.00
process allocation 35,348 0.06 0.00 0 1,944 0.51
process group creation 3,975 0.10 0.00 0 0  
process queue 7,388 0.00   0 0  
process queue reference 221,275 0.01 0.00 0 16,258 0.06
qmn task queue latch 1,062 30.32 0.03 0 0  
query server freelists 6,080 0.00   0 0  
query server process 10 0.00   0 10 0.00
queued dump request 17,972 0.00   0 0  
redo allocation 149,331 0.01 0.00 0 665,278 0.03
redo copy 0     0 665,359 0.01
redo writing 77,957 0.23 0.00 0 0  
resmgr group change latch 3,328 0.00   0 0  
resmgr:active threads 5,395 0.00   0 0  
resmgr:actses change group 2,602 0.00   0 0  
resmgr:free threads list 5,395 0.06 0.00 0 0  
row cache objects 2,318,613 0.03 0.00 0 1,005 0.00
rules engine aggregate statistics 4 0.00   0 0  
rules engine rule set statistics 108 0.00   0 0  
sequence cache 15,236 0.00   0 0  
session allocation 386,393 0.03 0.01 0 0  
session idle bit 1,274,918 0.00   0 0  
session state list latch 4,530 0.00   0 0  
session switching 59 0.00   0 0  
session timer 1,244 0.00   0 0  
shared pool 1,631,439 0.01 0.00 0 0  
shared pool sim alloc 2 0.00   0 0  
shared pool simulator 1,133,738 0.00 0.00 0 0  
simulator hash latch 11,232,402 0.00 0.00 0 0  
simulator lru latch 0     0 9,141,647 0.03
slave class 3 0.00   0 0  
slave class create 12 8.33 1.00 0 0  
sort extent pool 148,331 0.57 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 672 0.00   0 0  
temp lob duration state obj allocation 4 0.00   0 0  
temporary table state object allocation 147 0.00   0 0  
threshold alerts latch 896 0.00   0 0  
transaction allocation 9,846,544 0.00   0 0  
transaction branch allocation 126,646 0.02 0.00 0 0  
undo global data 7,442,122 0.00 0.00 0 0  
user lock 7,702 0.12 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
KCL gc element parent latch 80,106,163 15,826 2,542 13,305 0 0 0
cache buffers chains 184,105,729 7,138 5 7,133 0 0 0
channel operations parent latch 2,586,296 1,938 2 1,936 0 0 0
object queue header operation 49,267,686 1,752 1 1,751 0 0 0
ges resource hash list 1,105,549 822 1 821 0 0 0
qmn task queue latch 1,062 322 11 311 0 0 0
KJCT flow control latch 17,083,935 235 1 234 0 0 0
cache buffers lru chain 572,687 210 1 209 0 0 0
mostly latch-free SCN 8,914 167 1 166 0 0 0
session allocation 386,393 100 1 99 0 0 0
active service list 27,601 7 1 6 0 0 0
slave class create 12 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 6,438 461
KCL gc element parent latch kclnfnd 0 8 7
KCL gc element parent latch kclrwrite 0 6 32
KCL gc element parent latch kclbla 0 5 1
KCL gc element parent latch kclplz 0 3 2,526
KCL gc element parent latch kclhngcbk1 0 2 0
KCL gc element parent latch kclulb 0 2 596
KCL gc element parent latch kclfwrite1 0 1 24
KCL gc element parent latch kclwrt 0 1 1
KJCT flow control latch kjctcsnd: send normal message 0 1 1
active service list ksws_event: ksws event 0 2 2
active service list kswssyis: find service entry 1 0 1 0
cache buffers chains kcbbxsv 0 25 28
cache buffers chains kcbzgb: scan from tail. nowait 0 5 0
cache buffers chains kcbgtcr: fast path 0 3 1
cache buffers chains kcbo_write_process 0 3 3
cache buffers chains kclwrt 0 3 0
cache buffers lru chain kcbzgws 0 1 0
channel operations parent latch ksrapublish() 0 2 0
channel operations parent latch ksrmfree() 0 1 0
channel operations parent latch ksrsconsume() 0 1 0
event range base latch No latch 0 11 11
ges resource hash list kjrmas1: lookup master node 0 1 0
mostly latch-free SCN kcslcu3 0 1 1
object queue header operation kcbo_switch_cq 0 2 0
object queue header operation kcbo_ivbo 0 1 1
session allocation ksufap: active sessions 0 1 0
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
SYS SYSTEM TS$   TABLE 23,770,544 27.67
CDJY JYDATA CC72   TABLE 21,970,720 25.57
CDSI2 DATA KC22K1   TABLE 16,532,976 19.24
SYS SYSTEM I_FILE2   INDEX 6,312,064 7.35
SYS SYSTEM I_JOB_NEXT   INDEX 2,624,080 3.05

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
CDSI2 DATA KC22K1   TABLE 15,200,944 78.48
CDSI2 DATA IDX_KC22K1_103   INDEX 477,333 2.46
CDSI2 DATA IDX_KC22K1_AKC190   INDEX 358,545 1.85
CDSI2 DATA PK_KC22K1   INDEX 331,005 1.71
SYS SYSAUX WRH$_SQL_PLAN   TABLE 138,256 0.71

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 350 57.28
CDSI2 DATA IDX_KC22K1_02   INDEX 43 7.04
** UNAVAILABLE ** ** UNAVAILABLE ** ** UNAVAILABLE ** AILABLE ** UNDEFINED 7 1.15
CDSI2 DATA IDX_KC72K1_103   INDEX 7 1.15
CDSI2 DATA IDX$$_2D83A0001   INDEX 6 0.98

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
CDSI2 DATA KC03K1   TABLE 1,123 9.52
CDSI2 DATA KC82K1   TABLE 989 8.38
SYS SYSTEM SEG$   TABLE 717 6.08
CDSI2 DATA IDX_IC01I2_0201   INDEX 635 5.38
CDJY DATA DY41   TABLE 536 4.54

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
CDSI2 DATA KC82K1   TABLE 433 7.54
CDJY DATA DY41   TABLE 359 6.25
CDSI2 DATA AC16   TABLE 291 5.07
CDSI2 DATA IDX_AC02_T_AAC001_AAE140   INDEX 228 3.97
CDSI2 DATA INDEX_KC82K3_02   INDEX 174 3.03

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 114 0.00 0   4 1
dc_database_links 4,875 0.00 0   0 2
dc_files 146,874 0.00 0   0 538
dc_global_oids 5,608 0.04 0   0 60
dc_histogram_data 9,295 12.07 0   407 25,589
dc_histogram_defs 15,605 9.51 0   306 16,554
dc_object_grants 46 17.39 0   0 120
dc_object_ids 12,852 3.00 0   62 4,991
dc_objects 7,335 5.28 0   255 3,854
dc_profiles 1,923 0.00 0   0 1
dc_rollback_segments 120,190 0.00 0   0 2,685
dc_segments 3,664 3.93 0   236 6,784
dc_sequences 115 4.35 0   115 30
dc_tablespaces 336,582 0.00 0   0 50
dc_usernames 10,385 0.01 0   0 50
dc_users 104,972 0.00 0   0 68
outstanding_alerts 424 88.44 0   4 4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 8 0 0
dc_global_oids 2 0 0
dc_histogram_defs 2,076 0 0
dc_object_ids 489 0 0
dc_objects 1,030 0 0
dc_segments 530 8 0
dc_sequences 230 6 0
dc_usernames 1 0 0
outstanding_alerts 823 373 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 1,579 0.13 15,504 0.02 0 0
CLUSTER 15 0.00 24 0.00 0 0
INDEX 120 36.67 554 8.84 0 0
SQL AREA 40,045 7.25 1,662,959 0.21 72 11,336
TABLE/PROCEDURE 2,824 5.98 32,623 1.30 97 0
TRIGGER 258 0.39 435 0.69 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
BODY 2 2 0 2 0
CLUSTER 24 0 0 0 0
INDEX 554 170 21 107 0
TABLE/PROCEDURE 6,400 453 6 285 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 2,268.99   2.60 8.20 178 178 874 873
  Freeable 269.88 0.00 1.65 8.64 111   164 164
  PL/SQL 73.58 13.17 0.08 1.94 57 57 875 875
  SQL 47.50 28.02 0.06 0.30 8 1,026 780 368
E Other 2,160.05   2.68 8.49 178 178 805 804
  Freeable 1,684.38 0.00 11.01 123.79 1,532   153 153
  PL/SQL 71.46 12.24 0.09 2.02 57 57 806 806
  SQL 46.03 27.57 0.06 0.32 8 1,507 745 334

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 358.74 314.40 -12.36
shared db_block_hash_buckets 720.00 720.00 0.00
shared free memory 13,879.23 14,007.71 0.93
shared gcs resources 1,720.14 1,720.14 0.00
shared gcs shadows 1,030.03 1,030.03 0.00
shared sql area 1,337.50 1,251.34 -6.44
streams free memory 2,047.94 2,047.94 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 371,047 0 0
QMON Coordinator 218,075 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 3,194,541 10,760,364 11132041 11132041
gcs_shadows 6,935,288 10,973,252 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 2   
java_pool_size 134217728   
job_queue_processes 40   
large_pool_size 134217728   
local_listener 10.163.31.41:1521   
log_archive_config dg_config=(cdld, rep)   
log_archive_dest_1 LOCATION=/ora10g/archivelog   
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 cdld2_%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 2   
undo_management AUTO   
undo_retention 10800   
undo_tablespace UNDOTBS2   
user_dump_dest /oracle/app/oracle/admin/cdld/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 973,481 270.63 129.76
acks for commit broadcast(logical) 1,801,889 500.92 240.19
broadcast msgs on commit(actual) 8,102 2.25 1.08
broadcast msgs on commit(logical) 8,723 2.42 1.16
broadcast msgs on commit(wasted) 1,985 0.55 0.26
broadcast on commit wait time(ms) 1,426 0.40 0.19
broadcast on commit waits 5,945 1.65 0.79
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 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 11,974 3.33 1.60
gcs ast xid 2 0.00 0.00
gcs blocked converts 7,274 2.02 0.97
gcs blocked cr converts 8,574 2.38 1.14
gcs compatible basts 175 0.05 0.02
gcs compatible cr basts (global) 280 0.08 0.04
gcs compatible cr basts (local) 10,535 2.93 1.40
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 705 0.20 0.09
gcs dbwr write request msgs 621 0.17 0.08
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 53,069 14.75 7.07
gcs immediate (null) converts 465,890 129.52 62.10
gcs immediate cr (compatible) converts 3 0.00 0.00
gcs immediate cr (null) converts 9,938,794 2,762.96 1,324.82
gcs indirect ast 1,722,032 478.72 229.54
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 737 0.20 0.10
gcs msgs process time(ms) 97,151 27.01 12.95
gcs msgs received 13,632,930 3,789.92 1,817.24
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 101 0.03 0.01
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 0 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 43 0.01 0.01
gcs side channel msgs actual 116,305 32.33 15.50
gcs side channel msgs logical 510,092 141.80 67.99
gcs stale cr 0 0.00 0.00
gcs undo cr 0 0.00 0.00
gcs write notification msgs 28 0.01 0.00
gcs writes refused 1 0.00 0.00
ges msgs process time(ms) 1,115 0.31 0.15
ges msgs received 96,933 26.95 12.92
global posts dropped 0 0.00 0.00
global posts queue time 3 0.00 0.00
global posts queued 4 0.00 0.00
global posts requested 4 0.00 0.00
global posts sent 4 0.00 0.00
implicit batch messages received 536,198 149.06 71.47
implicit batch messages sent 2,119,825 589.31 282.57
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 17,554 4.88 2.34
messages queue sent actual 3,810,633 1,059.35 507.95
messages queue sent logical 9,511,187 2,644.08 1,267.82
messages received actual 5,731,877 1,593.45 764.05
messages received logical 13,729,564 3,816.78 1,830.12
messages sent directly 539,278 149.92 71.88
messages sent indirectly 9,159,111 2,546.21 1,220.89
messages sent not implicit batched 1,690,976 470.09 225.40
messages sent pbatched 9,325,198 2,592.38 1,243.03
msgs causing lmd to send msgs 32,031 8.90 4.27
msgs causing lms(s) to send msgs 18,323 5.09 2.44
msgs received queue time (ms) 41,437 11.52 5.52
msgs received queued 13,729,923 3,816.88 1,830.17
msgs sent queue time (ms) 153,233 42.60 20.43
msgs sent queue time on ksxp (ms) 1,526,722 424.42 203.51
msgs sent queued 9,503,759 2,642.02 1,266.83
msgs sent queued on ksxp 5,982,411 1,663.09 797.44
process batch messages received 1,013,372 281.71 135.08
process batch messages sent 1,986,468 552.23 264.79


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 7,498
CURRENT Block Requests 129
Data Block Requests 7,498
Undo Block Requests 5
TX Block Requests 41
Current Results 7,616
Private results 0
Zero Results 9
Disk Read Results 0
Fail Results 0
Fairness Down Converts 793
Fairness Clears 0
Free GC Elements 0
Flushes 18
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 47
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 24,350 99.99 0.00 0.01 0.00 0.00
Flushes 5 100.00 0.00 0.00 0.00 0.00
Writes 1,252 22.52 6.63 69.97 0.64 0.24


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 5,547 99.66 0.34 0.00 3,158 99.75 0.25 0.00
1 Others 3,306 100.00 0.00 0.00 2,443 100.00 0.00 0.00
1 undo header 2,838 91.65 8.35 0.00 79 100.00 0.00 0.00
1 undo block 112 100.00 0.00 0.00 0      


Back to Top

End of Report