WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
CRMDB3793421815crmdb2210.2.0.4.0YESxjcrmdb2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:3579606-Jan-13 16:00:252722 6.7
End Snap:3579706-Jan-13 16:30:032720 6.8
Elapsed:  29.64 (mins)  
DB Time:  861.73 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 13,312M 13,312MStd Block Size: 8K
Shared Pool Size: 6,144M 6,144MLog Buffer: 14,308K

Load Profile

Per SecondPer Transaction
Redo size: 799,519.71 6,209.58
Logical reads: 586,796.40 4,557.44
Block changes: 4,763.80 37.00
Physical reads: 13,450.84 104.47
Physical writes: 294.01 2.28
User calls: 8,358.70 64.92
Parses: 2,197.48 17.07
Hard parses: 42.89 0.33
Sorts: 5,057.34 39.28
Logons: 5.65 0.04
Executes: 9,917.05 77.02
Transactions: 128.76 

% Blocks changed per Read: 0.81Recursive Call %: 50.44
Rollback per transaction %: 3.80Rows per Sort: 4.62

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97Redo NoWait %: 100.00
Buffer Hit %: 98.33In-memory Sort %: 100.00
Library Hit %: 99.07Soft Parse %: 98.05
Execute to Parse %: 77.84Latch Hit %: 99.34
Parse CPU to Parse Elapsd %: 1.40% Non-Parse CPU: 99.01

Shared Pool Statistics

BeginEnd
Memory Usage %: 91.68 92.20
% SQL with executions>1: 44.84 73.37
% Memory for SQL w/exec>1: 44.52 76.92

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
library cache lock 283,557 15,315 54 29.6Concurrency
CPU time  15,082  29.2 
db file sequential read 2,188,875 6,944 3 13.4User I/O
db file scattered read 803,391 2,166 3 4.2User I/O
DFS lock handle 12,200 1,454 119 2.8Other

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 3,311.13 25.72
Global Cache blocks served: 5,386.46 41.83
GCS/GES messages received: 21,094.18 163.83
GCS/GES messages sent: 18,227.65 141.57
DBWR Fusion writes: 58.39 0.45
Estd Interconnect traffic (KB) 77,260.75 

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

Buffer access - local cache %: 97.77
Buffer access - remote cache %: 0.56
Buffer access - disk %: 1.67

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 5.7
Avg global cache cr block receive time (ms): 1.0
Avg global cache current block receive time (ms): 1.5
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 1.9
Avg global cache cr block flush time (ms): 1.1
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.1
Avg global cache current block flush time (ms): 1.2

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 3.7
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: 20.49
% of indirect sent messages: 76.99
% of flow controlled messages: 2.52

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 34,474.46 66.68
DB CPU 15,082.20 29.17
parse time elapsed 11,076.01 21.42
hard parse elapsed time 4,338.45 8.39
PL/SQL execution elapsed time 2,098.19 4.06
failed parse elapsed time 906.80 1.75
PL/SQL compilation elapsed time 447.94 0.87
sequence load elapsed time 166.77 0.32
connection management call elapsed time 49.83 0.10
hard parse (sharing criteria) elapsed time 26.82 0.05
hard parse (bind mismatch) elapsed time 17.22 0.03
repeated bind elapsed time 0.20 0.00
DB time 51,704.02  
background elapsed time 2,298.30  
background cpu time 1,551.10  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Concurrency 414,431 24.61 16,404 40 1.81
User I/O 6,347,707 0.00 10,582 2 27.73
Cluster 6,755,770 0.01 4,595 1 29.51
Other 472,769 78.93 2,055 4 2.06
System I/O 345,464 0.00 321 1 1.51
Network 15,074,204 0.00 306 0 65.84
Commit 249,195 0.03 287 1 1.09
Configuration 841,645 99.81 187 0 3.68
Application 83,121 0.04 34 0 0.36

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
library cache lock 283,557 10.34 15,315 54 1.24
db file sequential read 2,188,875 0.00 6,944 3 9.56
db file scattered read 803,391 0.00 2,166 3 3.51
DFS lock handle 12,200 23.43 1,454 119 0.05
gc cr multi block request 3,769,306 0.00 1,452 0 16.46
direct path read 3,245,699 0.00 1,130 0 14.18
gc current block 2-way 960,569 0.00 822 1 4.20
gc cr grant 2-way 929,828 0.00 715 1 4.06
gc buffer busy 304,499 0.07 713 2 1.33
cursor: pin S wait on X 72,324 99.99 711 10 0.32
gc cr block 2-way 438,951 0.00 381 1 1.92
db file parallel read 97,277 0.00 329 3 0.42
log file sync 249,195 0.03 287 1 1.09
SQL*Net more data from dblink 387,227 0.00 269 1 1.69
enq: PS - contention 1,684 24.23 205 122 0.01
row cache lock 9,238 0.62 194 21 0.04
enq: HW - contention 1,839 18.92 182 99 0.01
log file parallel write 270,190 0.00 164 1 1.18
enq: TX - index contention 1,496 19.45 155 104 0.01
gc current grant busy 70,119 0.00 131 2 0.31
gc current grant 2-way 166,915 0.00 127 1 0.73
gc current block busy 8,896 0.00 115 13 0.04
db file parallel write 22,056 0.00 96 4 0.10
gc cr block busy 60,727 0.00 94 2 0.27
enq: TT - contention 1,446 11.48 91 63 0.01
enq: CF - contention 204 59.31 62 302 0.00
enq: FB - contention 397 30.98 62 155 0.00
cr request retry 64 98.44 48 748 0.00
gc cr disk read 40,743 0.00 35 1 0.18
control file sequential read 47,995 0.00 26 1 0.21
Log archive I/O 2,197 0.00 26 12 0.01
enq: US - contention 1,481 2.77 22 15 0.01
rdbms ipc reply 393 2.04 20 50 0.00
gcs log flush sync 40,652 34.46 19 0 0.18
enq: WF - contention 44 72.73 16 361 0.00
enq: PW - flush prewarm buffers 31 96.77 15 477 0.00
SQL*Net more data to client 599,410 0.00 14 0 2.62
SQL*Net break/reset to client 78,724 0.00 14 0 0.34
gcs drm freeze in enter server mode 42 38.10 14 325 0.00
SQL*Net message to client 12,006,403 0.00 13 0 52.44
latch free 9,319 0.00 13 1 0.04
KJC: Wait for msg sends to complete 1,039 1.54 11 10 0.00
buffer busy waits 5,014 0.20 9 2 0.02
read by other session 4,441 0.00 9 2 0.02
SQL*Net more data from client 107,176 0.00 8 0 0.47
log file sequential read 2,036 0.00 8 4 0.01
latch: library cache 551 0.00 6 11 0.00
latch: cache buffers chains 41,098 0.00 5 0 0.18
latch: row cache objects 248 0.00 5 19 0.00
enq: TX - contention 414 0.00 4 9 0.00
latch: cache buffers lru chain 328 0.00 3 11 0.00
enq: TX - row lock contention 158 0.63 3 21 0.00
gc remaster 27 0.00 3 116 0.00
direct path write 7,752 0.00 3 0 0.03
undo segment extension 839,714 100.00 3 0 3.67
gc cr grant congested 848 0.00 3 3 0.00
CGS wait for IPC msg 324,052 99.81 3 0 1.42
IPC send completion sync 2,486 98.95 3 1 0.01
enq: SQ - contention 49 0.00 2 44 0.00
enq: TM - contention 4,207 0.00 2 1 0.02
SQL*Net message to dblink 1,973,170 0.00 2 0 8.62
os thread startup 46 0.00 2 41 0.00
latch: shared pool 362 0.00 2 4 0.00
latch: object queue header operation 3,144 0.00 1 0 0.01
gc current block congested 503 0.00 1 3 0.00
gc current retry 180 0.00 1 6 0.00
gc cr block congested 263 0.00 1 4 0.00
control file parallel write 986 0.00 1 1 0.00
name-service call wait 12 0.00 1 73 0.00
reliable message 714 0.00 1 1 0.00
latch: KCL gc element parent latch 3,635 0.00 1 0 0.02
enq: TO - contention 428 0.00 1 1 0.00
gc current multi block request 2,381 0.00 1 0 0.01
enq: TD - KTF dump entries 3 0.00 0 161 0.00
library cache pin 481 0.00 0 1 0.00
gc current grant congested 165 0.00 0 3 0.00
log file switch completion 34 0.00 0 13 0.00
PX Deq: reap credit 18,233 95.68 0 0 0.08
PX Deq Credit: send blkd 523 26.77 0 1 0.00
latch: gcs resource hash 141 0.00 0 3 0.00
kksfbc child completion 8 87.50 0 43 0.00
gc object scan 703 88.34 0 0 0.00
enq: IR - contention 236 0.00 0 1 0.00
ksxr poll remote instances 22,504 48.93 0 0 0.10
latch: ges resource hash list 192 0.00 0 1 0.00
direct path read temp 136 0.00 0 2 0.00
PX Deq: Signal ACK 465 37.85 0 0 0.00
kjbdrmcvtq lmon drm quiesce: ping completion 12 16.67 0 16 0.00
LGWR wait for redo copy 5,697 0.00 0 0 0.02
global enqueue expand wait 18 100.00 0 10 0.00
latch: session allocation 68 0.00 0 2 0.00
wait for scn ack 342 0.00 0 0 0.00
gc current split 40 0.00 0 3 0.00
ges global resource directory to be frozen 12 83.33 0 7 0.00
latch: enqueue hash chains 6 0.00 0 7 0.00
ges2 LMON to wake up LMD - mrcvr 391 3.32 0 0 0.00
gc cr failure 59 0.00 0 1 0.00
gc current block unknown 48 0.00 0 1 0.00
direct path write temp 136 0.00 0 0 0.00
cursor: pin S 19,113 0.00 0 0 0.08
SQL*Net more data to dblink 818 0.00 0 0 0.00
enq: TA - contention 20 0.00 0 1 0.00
latch: library cache lock 4 0.00 0 4 0.00
enq: JQ - contention 14 0.00 0 1 0.00
cursor: mutex X 11 0.00 0 1 0.00
buffer deadlock 562 99.64 0 0 0.00
enq: TX - allocate ITL entry 9 0.00 0 1 0.00
enq: JS - job run lock - synchronize 1 0.00 0 2 0.00
enq: PI - contention 3 0.00 0 1 0.00
log file single write 4 0.00 0 0 0.00
enq: UL - contention 1 0.00 0 2 0.00
enq: AF - task serialization 1 0.00 0 2 0.00
enq: WL - contention 1 0.00 0 1 0.00
enq: TS - contention 1 0.00 0 0 0.00
lock escalate retry 18 94.44 0 0 0.00
latch: redo allocation 1 0.00 0 0 0.00
lock deadlock retry 4 100.00 0 0 0.00
PX qref latch 1 100.00 0 0 0.00
cursor: mutex S 1 0.00 0 0 0.00
SQL*Net message from client 12,000,927 0.00 1,619,141 135 52.42
gcs remote message 8,661,961 95.12 12,475 1 37.83
PX Idle Wait 3,065 66.23 5,547 1810 0.01
jobq slave wait 1,725 94.96 4,872 2825 0.01
DIAG idle wait 8,947 0.04 1,749 195 0.04
Streams AQ: waiting for messages in the queue 382 92.15 1,741 4558 0.00
Streams AQ: qmn slave idle wait 70 0.00 1,725 24646 0.00
Streams AQ: qmn coordinator idle wait 130 46.92 1,719 13221 0.00
ges remote message 549,239 92.75 1,716 3 2.40
virtual circuit status 59 100.00 1,702 28852 0.00
wait for unread message on broadcast channel 1,756 98.46 1,688 961 0.01
Streams AQ: waiting for time management or cleanup tasks 12 0.00 1,592 132651 0.00
SQL*Net message from dblink 1,973,166 0.00 1,536 1 8.62
PX Deq: Execution Msg 5,380 28.83 116 22 0.02
single-task message 621 0.00 29 47 0.00
PX Deq: Execute Reply 367 30.52 10 28 0.00
PX Deq: Parse Reply 513 34.11 3 5 0.00
PX Deq: Join ACK 484 34.71 1 3 0.00
PX Deq: Msg Fragment 1,935 39.33 1 0 0.01
class slave wait 2 0.00 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 134 100.00 0 0 0.00
PX Deq Credit: need buffer 2 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 409,112 85.29 170 0 1.79
log file parallel write 270,185 0.00 164 1 1.18
db file parallel write 22,033 0.00 96 4 0.10
Log archive I/O 2,197 0.00 26 12 0.01
db file sequential read 6,096 0.00 17 3 0.03
enq: PW - flush prewarm buffers 30 100.00 15 493 0.00
log file sequential read 2,036 0.00 8 4 0.01
buffer busy waits 435 2.30 7 17 0.00
control file sequential read 5,586 0.00 4 1 0.02
gc cr grant 2-way 1,932 0.00 2 1 0.01
os thread startup 43 0.00 2 36 0.00
enq: TM - contention 4,205 -0.02 2 0 0.02
control file parallel write 986 0.00 1 1 0.00
gc current grant 2-way 1,048 0.00 1 1 0.00
row cache lock 352 0.00 1 2 0.00
latch: cache buffers chains 169 0.00 1 4 0.00
gc cr multi block request 2,644 0.00 1 0 0.01
gc current block 2-way 1,042 0.00 1 1 0.00
db file parallel read 161 0.00 0 3 0.00
gc object scan 703 88.34 0 0 0.00
direct path read 3,045 0.00 0 0 0.01
gc current grant busy 193 0.00 0 1 0.00
library cache lock 98 0.00 0 1 0.00
db file scattered read 11 0.00 0 5 0.00
gc cr block 2-way 75 0.00 0 1 0.00
direct path write 1,117 0.00 0 0 0.00
gc cr grant congested 4 0.00 0 3 0.00
gc current block busy 6 0.00 0 1 0.00
latch: row cache objects 2 0.00 0 3 0.00
log file single write 4 0.00 0 0 0.00
enq: HW - contention 1 0.00 0 1 0.00
latch: shared pool 1 0.00 0 0 0.00
rdbms ipc message 484,373 6.55 27,097 56 2.12
gcs remote message 8,662,165 95.12 12,475 1 37.84
DIAG idle wait 8,943 0.00 1,748 195 0.04
pmon timer 1,762 97.50 1,734 984 0.01
Streams AQ: qmn slave idle wait 70 0.00 1,725 24646 0.00
Streams AQ: qmn coordinator idle wait 130 46.92 1,719 13221 0.00
ges remote message 549,215 92.75 1,716 3 2.40
smon timer 1,584 0.32 1,659 1047 0.01
Streams AQ: waiting for time management or cleanup tasks 12 0.00 1,592 132651 0.00
PX Deq: Parse Reply 13 46.15 0 3 0.00
PX Deq: Join ACK 15 40.00 0 2 0.00
PX Deq: Execute Reply 26 26.92 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 134 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 69,437
AVG_IDLE_TIME 109,760
AVG_IOWAIT_TIME 14,274
AVG_SYS_TIME 13,476
AVG_USER_TIME 55,897
BUSY_TIME 2,223,658
IDLE_TIME 3,514,203
IOWAIT_TIME 458,514
SYS_TIME 433,208
USER_TIME 1,790,450
LOAD 0
OS_CPU_WAIT_TIME 2,349,700
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 60,129,542,144
NUM_CPUS 32
NUM_CPU_CORES 16

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
crmdb 49,013.10 14,601.10 23,384,122 1,032,872,206
SYS$USERS 2,321.70 454.50 524,739 9,469,501
Listener_crmdb 0.00 0.00 0 0
SYS$BACKGROUND 0.00 0.00 12,250 1,037,159
crmdbXDB 0.00 0.00 0 0

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
crmdb 5959476 978095 411106 1633046 0 0 14935586 30498
SYS$USERS 376200 77732 1463 5454 0 0 111525 119
SYS$BACKGROUND 12306 2506 1971 1925 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
2,083 536 1,034 2.01 4.03 bk7km0ndmgfrt gs05@xjas1 (TNS V1-V3) begin pro_getProduct_info ( :l...
1,711 1,518 191,434 0.01 3.31 cj9cmxzd4vdr8 POcsInterface@xjas2 (TNS V1-V3) select ID_NO , OP_CODE , ROWID...
1,438 1,128 815 1.76 2.78 4fnbx7ckawjvx RChkOfferRel@xjas1 (TNS V1-V3) select b.OFFER_ID, b.OFFER_COD...
1,185 1,153 191,181 0.01 2.29 7sp5b83m9g1wd POcsInterface@xjas2 (TNS V1-V3) select count(*) into :b0 fro...
1,052 10 2,482 0.42 2.03 0uw3krhtasgmn oracle@xjaccdb1 (TNS V1-V3) INSERT INTO "DBCUSTADM"."WCOM...
783 242 35,535 0.02 1.51 97cr4yaa07kaa gs05@xjas1 (TNS V1-V3) SELECT NVL(CONVERT(W.XML_DATA....
776 4 3,383 0.23 1.50 fy5bm7umxky4v SQL*Plus insert into wcommonshortmsg_te...
668 189 177 3.77 1.29 7vfn2da54s0c8   Select Count(*) From Dsrvretu...
667 666 8,142,173 0.00 1.29 5mydb27d7ma0h RProduct_Offer_Detail@xjas2 (TNS V1-V3) SELECT MAX (CNUM) FROM (SELECT...
632 103 1 631.66 1.22 9rj28a59y6g18   DECLARE job BINARY_INTEGER := ...
520 5 0   1.01 gvyfb56frnx0m oracle@xjaccdb1 (TNS V1-V3) SELECT * FROM "PRODUCT"."PRODU...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
1,518 1,711 191,434 0.01 3.31 cj9cmxzd4vdr8 POcsInterface@xjas2 (TNS V1-V3) select ID_NO , OP_CODE , ROWID...
1,153 1,185 191,181 0.01 2.29 7sp5b83m9g1wd POcsInterface@xjas2 (TNS V1-V3) select count(*) into :b0 fro...
1,128 1,438 815 1.38 2.78 4fnbx7ckawjvx RChkOfferRel@xjas1 (TNS V1-V3) select b.OFFER_ID, b.OFFER_COD...
666 667 8,142,173 0.00 1.29 5mydb27d7ma0h RProduct_Offer_Detail@xjas2 (TNS V1-V3) SELECT MAX (CNUM) FROM (SELECT...
536 2,083 1,034 0.52 4.03 bk7km0ndmgfrt gs05@xjas1 (TNS V1-V3) begin pro_getProduct_info ( :l...
289 384 205,336 0.00 0.74 0cnyzhgj9m530 RProdChg@xjas2 (TNS V1-V3) insert into PRODUCT_ORDER_C...
243 363 10 24.26 0.70 8zzf7rctzftr9   select count(*) from UDISTRI...
242 783 35,535 0.01 1.51 97cr4yaa07kaa gs05@xjas1 (TNS V1-V3) SELECT NVL(CONVERT(W.XML_DATA....
216 301 9 24.05 0.58 307kdnswb4hgk   select * from ( select rownum ...
208 499 160 1.30 0.96 aw74vfkpahp1h RPubSelect@xjas2 (TNS V1-V3) select nvl(current_point, :"SY...
189 668 177 1.07 1.29 7vfn2da54s0c8   Select Count(*) From Dsrvretu...
103 632 1 102.70 1.22 9rj28a59y6g18   DECLARE job BINARY_INTEGER := ...
10 1,052 2,482 0.00 2.03 0uw3krhtasgmn oracle@xjaccdb1 (TNS V1-V3) INSERT INTO "DBCUSTADM"."WCOM...
5 520 0   1.01 gvyfb56frnx0m oracle@xjaccdb1 (TNS V1-V3) SELECT * FROM "PRODUCT"."PRODU...
4 776 3,383 0.00 1.50 fy5bm7umxky4v SQL*Plus insert into wcommonshortmsg_te...

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
318,000,716 191,434 1,661.15 30.48 1517.63 1710.91 cj9cmxzd4vdr8 POcsInterface@xjas2 (TNS V1-V3) select ID_NO , OP_CODE , ROWID...
215,360,832 191,181 1,126.48 20.64 1153.46 1184.76 7sp5b83m9g1wd POcsInterface@xjas2 (TNS V1-V3) select count(*) into :b0 fro...
58,775,694 815 72,117.42 5.63 1127.98 1437.53 4fnbx7ckawjvx RChkOfferRel@xjas1 (TNS V1-V3) select b.OFFER_ID, b.OFFER_COD...
56,798,945 8,142,173 6.98 5.44 666.14 666.69 5mydb27d7ma0h RProduct_Offer_Detail@xjas2 (TNS V1-V3) SELECT MAX (CNUM) FROM (SELECT...
35,431,487 146 242,681.42 3.40 176.10 320.21 18qy8ksuyuz2g   select count(*) from dCustRes ...
22,158,438 4,503 4,920.82 2.12 77.35 149.45 b9m7f9c43aaps PStartStopStateBack@xjas1 (TNS V1-V3) select count(distinct t.order_...
11,624,904 764 15,215.84 1.11 66.30 100.48 6ub7p2kpfc4wy wkscan@xjoffon (TNS V1-V3) SELECT HLRCODE, OPTCODE, INSTI...
11,244,936 3 3,748,312.00 1.08 109.30 421.49 cz0b04g3x42ph RPubSelect@xjas2 (TNS V1-V3) select h.attr_val, k.cust_name...
8,982,847 128 70,178.49 0.86 179.01 226.48 8ggxb1gjf4b1z RProduct_Offer_Detail@xjas2 (TNS V1-V3) select OFFER_ID, OFFER_CODE, O...
8,332,369 177 47,075.53 0.80 189.10 667.94 7vfn2da54s0c8   Select Count(*) From Dsrvretu...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
2,981,678 1,034 2,883.63 12.47 535.98 2083.43 bk7km0ndmgfrt gs05@xjas1 (TNS V1-V3) begin pro_getProduct_info ( :l...
1,626,860 7 232,408.57 6.80 74.17 351.10 6bjssyqng22g0 RPubWebRptGen@xjas2 (TNS V1-V3) insert into rbo006mid (...
1,351,802 35,535 38.04 5.65 241.99 783.10 97cr4yaa07kaa gs05@xjas1 (TNS V1-V3) SELECT NVL(CONVERT(W.XML_DATA....
1,328,953 10 132,895.30 5.56 163.59 358.21 7f5ucjrdpv2un RPubWebRptGen@xjas1 (TNS V1-V3) insert into rpd002mid ...
1,206,627 5 241,325.40 5.04 101.90 434.78 9z4zmawpf2zmn   select /*+ all_rows */ a.id_no...
1,023,971 1 1,023,971.00 4.28 84.54 392.35 9kf2tr53jn28g SQL*Plus create table chj_serv_product ...
899,579 4 224,894.75 3.76 66.66 300.08 1mxfs3au6v7xu   select /*+ first_rows */ count...
675,870 160 4,224.19 2.83 207.81 498.64 aw74vfkpahp1h RPubSelect@xjas2 (TNS V1-V3) select nvl(current_point, :"SY...
563,216 177 3,182.01 2.35 189.10 667.94 7vfn2da54s0c8   Select Count(*) From Dsrvretu...
458,448 7,823 58.60 1.92 79.30 264.64 88gsspy0cxnt4 gs05@xjas1 (TNS V1-V3) SELECT NVL(W.XML_DATA.EXTRACT ...
450,780 3,900 115.58 1.88 77.23 261.31 6mddmzpmsduqp gs05@xjas1 (TNS V1-V3) SELECT NVL(W.XML_DATA.EXTRACT ...
381,697 10 38,169.70 1.60 242.61 363.13 8zzf7rctzftr9   select count(*) from UDISTRI...
283,842 1 283,842.00 1.19 102.70 631.66 9rj28a59y6g18   DECLARE job BINARY_INTEGER := ...
260,306 9 28,922.89 1.09 216.43 300.75 307kdnswb4hgk   select * from ( select rownum ...
246,019 15 16,401.27 1.03 34.26 326.00 72c2v7whcdv49   select count(*) from ( select...

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
8,142,173 8,124,548 1.00 0.00 0.00 5mydb27d7ma0h RProduct_Offer_Detail@xjas2 (TNS V1-V3) SELECT MAX (CNUM) FROM (SELECT...
256,435 256,491 1.00 0.00 0.00 a20j388ug1x1p RGetWorkData@xjas2 (TNS V1-V3) select lower(csound(function_n...
205,359 205,331 1.00 0.00 0.00 4d2s7d3b9m2v3 RProdChg@xjas2 (TNS V1-V3) SELECT PROD_DATA_INTN_SEQ.NEXT...
205,336 205,301 1.00 0.00 0.00 0cnyzhgj9m530 RProdChg@xjas2 (TNS V1-V3) insert into PRODUCT_ORDER_C...
191,434 1,202 0.01 0.01 0.01 cj9cmxzd4vdr8 POcsInterface@xjas2 (TNS V1-V3) select ID_NO , OP_CODE , ROWID...
191,181 189,952 0.99 0.01 0.01 7sp5b83m9g1wd POcsInterface@xjas2 (TNS V1-V3) select count(*) into :b0 fro...
114,993 114,818 1.00 0.00 0.00 chkvu0pdg582n oracle@xjaccdb1 (TNS V1-V3) SELECT "PHONE_NO", "REGION_COD...
92,395 20 0.00 0.00 0.00 5rxtdg9bjbwh7 pBookProd@xjas1 (TNS V1-V3) SELECT distinct loginaccept FR...
89,288 25 0.00 0.00 0.00 4yya7jnf3arvu pBookProd@xjas1 (TNS V1-V3) SELECT distinct loginaccept FR...
87,370 28 0.00 0.00 0.00 0u7znxpy6typg pBookProd@xjas1 (TNS V1-V3) SELECT distinct loginaccept FR...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
205,350 205,359 5.26 4d2s7d3b9m2v3 RProdChg@xjas2 (TNS V1-V3) SELECT PROD_DATA_INTN_SEQ.NEXT...
205,249 205,336 5.25 0cnyzhgj9m530 RProdChg@xjas2 (TNS V1-V3) insert into PRODUCT_ORDER_C...
92,395 92,395 2.36 5rxtdg9bjbwh7 pBookProd@xjas1 (TNS V1-V3) SELECT distinct loginaccept FR...
89,288 89,288 2.29 4yya7jnf3arvu pBookProd@xjas1 (TNS V1-V3) SELECT distinct loginaccept FR...
87,370 87,370 2.24 0u7znxpy6typg pBookProd@xjas1 (TNS V1-V3) SELECT distinct loginaccept FR...
81,284 81,284 2.08 0nm4bx2m2zjtu pBookProd@xjas1 (TNS V1-V3) SELECT distinct loginaccept FR...
68,011 68,087 1.74 fa6zas4619538 RPubSelect@xjas2 (TNS V1-V3) select param_value from ssysct...
66,184 66,185 1.69 2ym6hhaq30r73   select type#, blocks, extents,...
58,338 58,338 1.49 43mztqqh8tbcu RGetCanChgBOffer@xjas2 (TNS V1-V3) select OFFER_ID , BAND_ID , ...
46,370 46,382 1.19 a7xs3b8bfz5fz wkupdate@xjoffon (TNS V1-V3) begin EXECUTE IMMEDIATE :sql_n...
45,720 45,718 1.17 awp48dqc6mxxs RProdChg@xjas2 (TNS V1-V3) select structID, parStructID,...
40,468 40,468 1.04 6wqf3krg83v7v PStartStopDeal@xjas1 (TNS V1-V3) select PROVINCE_CODE, ...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
18,909,760   0.29 fg9w4sbqhq680   ** SQL Text Not Available **
18,557,320   0.29 3pvgqbdg14uj9   ** SQL Text Not Available **
18,511,264   0.29 a18fnbq24kzqu   ** SQL Text Not Available **
12,354,512   0.19 3tysc96gbrj76   ** SQL Text Not Available **
11,070,752   0.17 36akjja2z71j6   ** SQL Text Not Available **
10,899,016   0.17 6tzfj5sccsr04   ** SQL Text Not Available **
10,068,784   0.16 g04sx6dqwr5cm   ** SQL Text Not Available **
9,430,752   0.15 cq8t562h0yw0a   ** SQL Text Not Available **
8,091,979 617 0.13 6hx8cr32f4tkk   select * from dcusthigh where ...
5,978,688   0.09 92ufy6fzxj22v   select contract_no from dconus...
5,775,944 924 0.09 19pcusmmbm4bj   select :"SYS_B_0", :"SYS_B_1",...
5,273,168 532 0.08 fh2fy16ur22bf RPubSelect@xjas1 (TNS V1-V3) select a.code_describ from ser...
5,054,960   0.08 bzhubg5vynj32   ** SQL Text Not Available **
4,978,120   0.08 gbpzhwak5pmfd   ** SQL Text Not Available **
4,686,408   0.07 bhr48yp313m9w   ** SQL Text Not Available **
4,330,128 1,020 0.07 8w6tbzkftbryw   select trim(tele_type) from dc...
4,069,399 388 0.06 gqmwndpnk18sw RPubSelect@xjas2 (TNS V1-V3) select a.offer_id, b.offer_na...
3,872,320   0.06 c3xbw04a3f7wp   ** SQL Text Not Available **
3,729,187 621 0.06 0drpma1vwm4p6 RPubSelect@xjas1 (TNS V1-V3) select count(*) from product_o...
3,713,496   0.06 2kc7cjtz9kgkk   select sm_code from dcustmsg w...
3,544,283 354 0.06 fpjt82gmaqvb3   select id_no from (SELECT ID_N...
3,524,320 342 0.05 71tbpwx3f7fps   select count(*) from dpointr...
3,503,920   0.05 9hnagv73nyaxp   select bank_cust from dConmsg ...
3,456,594 438 0.05 0a3jw54wjmyty RPubSelect@xjas2 (TNS V1-V3) select a.SERV_PRODUCT_ID, a....
3,361,147 848 0.05 5rwf3g5hkjrwa RPubSelect@xjas2 (TNS V1-V3) select owner_type from dcustdo...
3,299,331 279 0.05 6as60z0uwcgms   select m.id_no from dsrvtask m...
3,165,906 161 0.05 2rmumh1c7wqxb RPubSelect@xjas2 (TNS V1-V3) select a.member_id, nvl(e.ser...
2,820,917 521 0.04 1s6ctduynv86q RPubSelect@xjas1 (TNS V1-V3) select nvl(trim(user_name), :"...
2,534,337 489 0.04 0qyr0hsfa1v7h RPubSelect@xjas1 (TNS V1-V3) select nation_id from dbcustad...
2,127,501 169 0.03 dur6ypbh2rp4h   select * from ( select row_.*,...
2,044,337 494 0.03 dbpaw529fsp4v RPubSelect@xjas1 (TNS V1-V3) select cust_name from dcustdo...
1,964,486 928 0.03 b00adgz6wc11f   select count(id_no) from DCUST...
1,872,718 230 0.03 brtx0n265qu05 oracle@xjaccdb2 (TNS V1-V3) DELETE FROM "SERV_CHG" "A1" WH...
1,470,419 288 0.02 c5yn9tc797409 RPubSelect@xjas1 (TNS V1-V3) select id_type, id_iccid, owne...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
878   fg9w4sbqhq680   ** SQL Text Not Available **
689   gbpzhwak5pmfd   ** SQL Text Not Available **
528   6tzfj5sccsr04   ** SQL Text Not Available **
514   2kc7cjtz9kgkk   select sm_code from dcustmsg w...
492   g04sx6dqwr5cm   ** SQL Text Not Available **
485   9hnagv73nyaxp   select bank_cust from dConmsg ...
484   92ufy6fzxj22v   select contract_no from dconus...
330   cq8t562h0yw0a   ** SQL Text Not Available **
247   bzhubg5vynj32   ** SQL Text Not Available **
236   c3xbw04a3f7wp   ** SQL Text Not Available **
229   a18fnbq24kzqu   ** SQL Text Not Available **
229   bhr48yp313m9w   ** SQL Text Not Available **
215   36akjja2z71j6   ** SQL Text Not Available **
209   3tysc96gbrj76   ** SQL Text Not Available **
207   3pvgqbdg14uj9   ** SQL Text Not Available **
199 848 5rwf3g5hkjrwa RPubSelect@xjas2 (TNS V1-V3) select owner_type from dcustdo...
175 532 fh2fy16ur22bf RPubSelect@xjas1 (TNS V1-V3) select a.code_describ from ser...
169 924 19pcusmmbm4bj   select :"SYS_B_0", :"SYS_B_1",...
167 521 1s6ctduynv86q RPubSelect@xjas1 (TNS V1-V3) select nvl(trim(user_name), :"...
153 928 b00adgz6wc11f   select count(id_no) from DCUST...
150 489 0qyr0hsfa1v7h RPubSelect@xjas1 (TNS V1-V3) select nation_id from dbcustad...
149 1,020 8w6tbzkftbryw   select trim(tele_type) from dc...
143 621 0drpma1vwm4p6 RPubSelect@xjas1 (TNS V1-V3) select count(*) from product_o...
121 494 dbpaw529fsp4v RPubSelect@xjas1 (TNS V1-V3) select cust_name from dcustdo...
119 388 gqmwndpnk18sw RPubSelect@xjas2 (TNS V1-V3) select a.offer_id, b.offer_na...
107 354 fpjt82gmaqvb3   select id_no from (SELECT ID_N...
98 438 0a3jw54wjmyty RPubSelect@xjas2 (TNS V1-V3) select a.SERV_PRODUCT_ID, a....
90 617 6hx8cr32f4tkk   select * from dcusthigh where ...
87 288 c5yn9tc797409 RPubSelect@xjas1 (TNS V1-V3) select id_type, id_iccid, owne...
85 230 brtx0n265qu05 oracle@xjaccdb2 (TNS V1-V3) DELETE FROM "SERV_CHG" "A1" WH...
80 279 6as60z0uwcgms   select m.id_no from dsrvtask m...
76 342 71tbpwx3f7fps   select count(*) from dpointr...
46 161 2rmumh1c7wqxb RPubSelect@xjas2 (TNS V1-V3) select a.member_id, nvl(e.ser...
29 169 dur6ypbh2rp4h   select * from ( select row_.*,...
29 169 dur6ypbh2rp4h   select * from ( select row_.*,...
29 169 dur6ypbh2rp4h   select * from ( select row_.*,...

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
383.43 57.41 667.94 189.10 177 7vfn2da54s0c8   Select Count(*) From Dsrvretu...
194.11 50.49 384.44 289.28 205,336 0cnyzhgj9m530 RProdChg@xjas2 (TNS V1-V3) insert into PRODUCT_ORDER_C...
192.06 38.52 498.64 207.81 160 aw74vfkpahp1h RPubSelect@xjas2 (TNS V1-V3) select nvl(current_point, :"SY...
177.48 40.82 434.78 101.90 5 9z4zmawpf2zmn   select /*+ all_rows */ a.id_no...
138.84 21.98 631.66 102.70 1 9rj28a59y6g18   DECLARE job BINARY_INTEGER := ...
124.60 41.52 300.08 66.66 4 1mxfs3au6v7xu   select /*+ first_rows */ count...
76.83 23.57 326.00 34.26 15 72c2v7whcdv49   select count(*) from ( select...
58.24 14.84 392.35 84.54 1 9kf2tr53jn28g SQL*Plus create table chj_serv_product ...
57.36 3.35 1,710.91 1,517.63 191,434 cj9cmxzd4vdr8 POcsInterface@xjas2 (TNS V1-V3) select ID_NO , OP_CODE , ROWID...
54.62 4.61 1,184.76 1,153.46 191,181 7sp5b83m9g1wd POcsInterface@xjas2 (TNS V1-V3) select count(*) into :b0 fro...
39.58 12.34 320.72 54.68 38,272 06f4jfv191v0f oracle@xjaccdb1 (TNS V1-V3) SELECT "A1"."OFFER_ID" FROM (...
35.53 1.71 2,083.43 535.98 1,034 bk7km0ndmgfrt gs05@xjas1 (TNS V1-V3) begin pro_getProduct_info ( :l...
34.76 10.85 320.21 176.10 146 18qy8ksuyuz2g   select count(*) from dCustRes ...
34.51 8.19 421.49 109.30 3 cz0b04g3x42ph RPubSelect@xjas2 (TNS V1-V3) select h.attr_val, k.cust_name...
34.44 9.61 358.21 163.59 10 7f5ucjrdpv2un RPubWebRptGen@xjas1 (TNS V1-V3) insert into rpd002mid ...
27.96 20.60 135.73 102.26 114,993 chkvu0pdg582n oracle@xjaccdb1 (TNS V1-V3) SELECT "PHONE_NO", "REGION_COD...
27.58 7.60 363.13 242.61 10 8zzf7rctzftr9   select count(*) from UDISTRI...
27.57 8.28 333.13 25.21 2 asadr6t3dygx9 JDBC Thin Client select sum(bytes/1024/1024) fr...
21.18 14.17 149.45 77.35 4,503 b9m7f9c43aaps PStartStopStateBack@xjas1 (TNS V1-V3) select count(distinct t.order_...
20.03 15.86 126.30 26.66 169 dur6ypbh2rp4h   select * from ( select row_.*,...
17.98 5.12 351.10 74.17 7 6bjssyqng22g0 RPubWebRptGen@xjas2 (TNS V1-V3) insert into rbo006mid (...
12.35 37.60 32.84 31.03 92,395 5rxtdg9bjbwh7 pBookProd@xjas1 (TNS V1-V3) SELECT distinct loginaccept FR...
12.07 37.93 31.83 30.00 89,288 4yya7jnf3arvu pBookProd@xjas1 (TNS V1-V3) SELECT distinct loginaccept FR...
12.07 38.33 31.49 29.73 87,370 0u7znxpy6typg pBookProd@xjas1 (TNS V1-V3) SELECT distinct loginaccept FR...
9.65 53.00 18.21 16.93 20,471 danmkxgxbrq8r wkscan@xjoffon (TNS V1-V3) begin EXECUTE IMMEDIATE :sqlco...
9.25 3.08 300.75 216.43 9 307kdnswb4hgk   select * from ( select rownum ...
7.15 0.68 1,051.94 10.41 2,482 0uw3krhtasgmn oracle@xjaccdb1 (TNS V1-V3) INSERT INTO "DBCUSTADM"."WCOM...
5.20 22.97 22.65 22.32 46,382 a7xs3b8bfz5fz wkupdate@xjoffon (TNS V1-V3) begin EXECUTE IMMEDIATE :sql_n...
4.82 47.06 10.24 10.12 15,514 81z5tmxv3j6d6 wkscan@xjoffon (TNS V1-V3) UPDATE OFFON.TINEXWORK_SEND SE...
4.24 51.12 8.29 8.05 15,473 bd4hahr70fk5h wkupdate@xjoffon (TNS V1-V3) SELECT count(1) FROM OFFON.TIN...
3.95 18.47 21.37 20.99 81,284 0nm4bx2m2zjtu pBookProd@xjas1 (TNS V1-V3) SELECT distinct loginaccept FR...
2.99 33.76 8.86 8.78 15,473 8dfv00s4u89ts wkupdate@xjoffon (TNS V1-V3) UPDATE OFFON.TINEXWORK_SEND SE...
2.90 0.37 776.25 4.28 3,383 fy5bm7umxky4v SQL*Plus insert into wcommonshortmsg_te...
2.76 18.04 15.30 13.39 66,185 2ym6hhaq30r73   select type#, blocks, extents,...
1.80 9.55 18.89 11.85 32,452 04zm43mqh41q1 RCtOEltCreat@xjas2 (TNS V1-V3) insert into dOrderArrayPrtCntt...
1.65 0.49 333.41 52.32 37 fa00mtsqu413z   delete temp_phonesel b WHERE ...
1.35 13.44 10.05 9.69 15,002 9hsvu0mwcusv6 wkupdate@xjoffon (TNS V1-V3) UPDATE OFFON.TINEXWORK_CJ_SEND...
0.88 0.88 100.48 66.30 764 6ub7p2kpfc4wy wkscan@xjoffon (TNS V1-V3) SELECT HLRCODE, OPTCODE, INSTI...
0.85 11.71 7.26 2.58 438 0a3jw54wjmyty RPubSelect@xjas2 (TNS V1-V3) select a.SERV_PRODUCT_ID, a....
0.80 0.10 783.10 241.99 35,535 97cr4yaa07kaa gs05@xjas1 (TNS V1-V3) SELECT NVL(CONVERT(W.XML_DATA....
0.78 3.11 25.07 3.49 1,020 8w6tbzkftbryw   select trim(tele_type) from dc...
0.61 0.33 188.39 146.50 907 619hvrnhyu9ag   SELECT COUNT(PHONE_NO) FROM ON...
0.51 1.02 49.68 1.66 354 fpjt82gmaqvb3   select id_no from (SELECT ID_N...
0.49 0.07 666.69 666.14 8,142,173 5mydb27d7ma0h RProduct_Offer_Detail@xjas2 (TNS V1-V3) SELECT MAX (CNUM) FROM (SELECT...
0.46 15.62 2.97 2.26 617 6hx8cr32f4tkk   select * from dcusthigh where ...
0.39 7.65 5.04 1.81 521 1s6ctduynv86q RPubSelect@xjas1 (TNS V1-V3) select nvl(trim(user_name), :"...
0.36 0.03 1,437.53 1,127.98 815 4fnbx7ckawjvx RChkOfferRel@xjas1 (TNS V1-V3) select b.OFFER_ID, b.OFFER_COD...
0.33 5.36 6.13 1.65 489 0qyr0hsfa1v7h RPubSelect@xjas1 (TNS V1-V3) select nation_id from dbcustad...
0.30 0.11 264.64 79.30 7,823 88gsspy0cxnt4 gs05@xjas1 (TNS V1-V3) SELECT NVL(W.XML_DATA.EXTRACT ...
0.29 1.24 23.66 1.67 924 19pcusmmbm4bj   select :"SYS_B_0", :"SYS_B_1",...
0.29 1.32 21.88 1.92 388 gqmwndpnk18sw RPubSelect@xjas2 (TNS V1-V3) select a.offer_id, b.offer_na...
0.21 28.55 0.74 0.63 230 brtx0n265qu05 oracle@xjaccdb2 (TNS V1-V3) DELETE FROM "SERV_CHG" "A1" WH...
0.17 0.37 47.20 1.59 279 6as60z0uwcgms   select m.id_no from dsrvtask m...
0.13 2.79 4.50 1.81 161 2rmumh1c7wqxb RPubSelect@xjas2 (TNS V1-V3) select a.member_id, nvl(e.ser...
0.11 0.04 261.31 77.23 3,900 6mddmzpmsduqp gs05@xjas1 (TNS V1-V3) SELECT NVL(W.XML_DATA.EXTRACT ...
0.11 0.42 26.40 1.11 848 5rwf3g5hkjrwa RPubSelect@xjas2 (TNS V1-V3) select owner_type from dcustdo...
0.08 0.49 16.71 16.59 205,359 4d2s7d3b9m2v3 RProdChg@xjas2 (TNS V1-V3) SELECT PROD_DATA_INTN_SEQ.NEXT...
0.07 0.03 226.48 179.01 128 8ggxb1gjf4b1z RProduct_Offer_Detail@xjas2 (TNS V1-V3) select OFFER_ID, OFFER_CODE, O...
0.06 0.03 207.46 159.35 117 7mzcnjcrv0ra5 RProduct_Offer_Detail@xjas2 (TNS V1-V3) select b.OFFER_ID, b.OFFER_COD...
0.04 0.19 18.48 0.64 342 71tbpwx3f7fps   select count(*) from dpointr...
0.03 1.67 2.07 2.07 15,002 031qk7f2c37rv wkupdate@xjoffon (TNS V1-V3) SELECT count(1) FROM OFFON.TIN...
0.03 4.48 0.71 0.67 494 dbpaw529fsp4v RPubSelect@xjas1 (TNS V1-V3) select cust_name from dcustdo...
0.02 0.08 28.20 2.18 532 fh2fy16ur22bf RPubSelect@xjas1 (TNS V1-V3) select a.code_describ from ser...
0.01 1.94 0.47 0.44 288 c5yn9tc797409 RPubSelect@xjas1 (TNS V1-V3) select id_type, id_iccid, owne...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
031qk7f2c37rvSELECT count(1) FROM OFFON.TINEXWORK_CJ_SEND WHERE EXWORKSN like :vworkshtsn and DEALFLAG<>'1'
04zm43mqh41q1insert into dOrderArrayPrtCntt201301 ( order_array_id, op_code, bill_type, content_type, row_num, col_num, format_id, print_content, class_code, print_model_id, login_accept, print_order ) values ( :order_array_id , :op_code , :bill_type , :content_type , :row_num , :col_num , :format_id , :print_content , :class_code , :print_model_id , :login_accept , :print_order )
06f4jfv191v0fSELECT "A1"."OFFER_ID" FROM (SELECT "A3"."OFFER_ID" "OFFER_ID" FROM "PRODUCT"."PRODUCT_OFFER_INSTANCE" "A3", "PRODUCT"."PRODUCT_OFFER" "A2" WHERE "A3"."OFFER_ID"="A2"."OFFER_ID" AND "A3"."SERV_ID"=:1 AND "A2"."OFFER_TYPE"=10 ORDER BY "A3"."EFF_DATE" DESC) "A1" WHERE ROWNUM<2
0a3jw54wjmytyselect a.SERV_PRODUCT_ID, a.SERV_ID, a.PRODUCT_ID, a.STATE, b.product_name, to_char(a.CREATED_DATE, :"SYS_B_00"), to_char(a.EFF_DATE, :"SYS_B_01"), to_char(a.EXP_DATE, :"SYS_B_02"), decode(a.STATE, :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11") from serv_product a, product b where a.product_id = b.product_id and b.state<>:"SYS_B_12" and a.serv_id = :"SYS_B_13"
0cnyzhgj9m530 insert into PRODUCT_ORDER_CONTENT ( PRODORDID , CONTENTID , PARCONTENDID , STRUCTVALUE , STLEVEL , STRUCTID , ITEMORDER , FIELDID ) values ( :PRODORDID , :CONTENTID , :PARCONTENDID , :STRUCTVALUE , :STLEVEL , :STRUCTID , :ITEMORDER , :FIELDID )
0drpma1vwm4p6select count(*) from product_offer_instance a, product_offer_attr b where a.eff_date <sysdate and a.exp_date>sysdate and b.offer_id=a.offer_id and a.serv_id=:"SYS_B_0" and b.offer_attr_seq=:"SYS_B_1" and b.offer_id=:"SYS_B_2"
0nm4bx2m2zjtuSELECT distinct loginaccept FROM wProductOffOnChg where substr(SERVID, -1)=8
0qyr0hsfa1v7hselect nation_id from dbcustadm.dcustdocinadd t Where cust_id=:"SYS_B_0"
0u7znxpy6typgSELECT distinct loginaccept FROM wProductOffOnChg where substr(SERVID, -1)=7
0uw3krhtasgmnINSERT INTO "DBCUSTADM"."WCOMMONSHORTMSG" ("COMMAND_ID", "LOGIN_ACCEPT", "MSG_LEVEL", "PHONE_NO", "MSG", "ORDER_CODE", "BACK_CODE", "DX_OP_CODE", "LOGIN_NO", "OP_TIME", "SENT_TIME") SELECT :B0, :B1, :B2, :B3, :B4, :B5, :B6, :B7, :B8, SYSDATE@!, SYSDATE@! FROM "SYS"."DUAL"@! "A2"
18qy8ksuyuz2gselect count(*) from dCustRes a, dChnGroupInfo f, dChnGroupMsg c, sResStatus d, sResCode b , dselfcustres z , sgoodphoneplan c where a.group_id=f.group_id and a.phone_no=z.phone_no(+) and a.region_code=z.region_code(+) and z.price_plan=c.pricing_plan_id(+) and f.parent_group_id=:"SYS_B_0" and a.phone_no >= :"SYS_B_1" and a.phone_no <= :"SYS_B_2" and b.res_code=a.no_type and a.resource_code = d.res_status and b.kind_code=:"SYS_B_3" and d.kind_code = :"SYS_B_4" and a.group_id=c.group_id and f.group_id=c.group_id AND ROWNUM<=:"SYS_B_5" and a.resource_code=:"SYS_B_6" and a.region_code = :"SYS_B_7" and a.region_code = :"SYS_B_8"
19pcusmmbm4bjselect :"SYS_B_0", :"SYS_B_1", a.id_no, nvl(:"SYS_B_2", :"SYS_B_3") from dcusthigh a where a.phone_no=:"SYS_B_4" and substr(a.run_code, :"SYS_B_5", :"SYS_B_6")not in (:"SYS_B_7", :"SYS_B_8")
1mxfs3au6v7xuselect /*+ first_rows */ count(*) from dcusthigh a where :"SYS_B_0"=:"SYS_B_1" and a.turnon_flag = :"SYS_B_2" and (service_no is null or service_no = :"SYS_B_3") and a.sm_code = :"SYS_B_4" and to_char(a.group_id) in (select t.group_id from dChnGroupInfo t where t.parent_group_id = :"SYS_B_5"and t.denorm_level >= :"SYS_B_6")
1s6ctduynv86qselect nvl(trim(user_name), :"SYS_B_0") from dcustmsgext a where a.id_No = :"SYS_B_1"
2kc7cjtz9kgkkselect sm_code from dcustmsg where id_no = :"SYS_B_0"
2rmumh1c7wqxbselect a.member_id, nvl(e.service_no, a.acc_nbr), nvl(f.product_name, :"SYS_B_0"), b.member_role_name, a.short_num, to_char(a.eff_date, :"SYS_B_1"), to_char(a.exp_date, :"SYS_B_2") from group_instance_member a, group_instance_role b, dCustMsg c, Serv d, dAccountIdINfo e, product f where a.member_role_id = b.member_role_id and a.exp_date>sysdate and a.member_object_id=c.id_no(+) and c.id_no = d.serv_id(+) and c.phone_no = e.msisdn(+) and d.product_id = f.product_id(+) and ( substr(e.run_code, :"SYS_B_3", :"SYS_B_4") <> :"SYS_B_5" or e.run_code is null) and a.group_id = (select group_id from product_offer_instance where product_offer_instance_id = :"SYS_B_6")
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
307kdnswb4hgkselect * from ( select rownum rnm, aa.* from ( select a.PHONE_NO, a.USER_NAME, a.ARPU, b.update_data, b.SERVICE_NO , b.login_no, b.remarks, a.id_no , d.login_name from UDISTRIBUTE_LOG b, dCustHigh a, dloginmsg d where a.id_no = b.id_no and a.group_id in ( select t.group_id from dChnGroupInfo t where t.parent_group_id = :"SYS_B_0" and t.denorm_level >= :"SYS_B_1" ) and to_char(b.update_data, :"SYS_B_2") >= :"SYS_B_3" and b.old_service_no=d.login_no(+) order by b.update_data ) aa where rownum <= :"SYS_B_4" ) where rnm >= :"SYS_B_5"
36akjja2z71j6** SQL Text Not Available **
3pvgqbdg14uj9** SQL Text Not Available **
3tysc96gbrj76** SQL Text Not Available **
43mztqqh8tbcuselect OFFER_ID , BAND_ID , PRICING_PLAN_ID , OFFER_ATTR_TYPE , OFFER_NAME , OFFER_COMMENTS , CAN_BE_BUY_ALONE , OFFER_CODE , PRIORITY , STATE , to_char(EFF_DATE, 'yyyymmddhh24miss') , to_char(EXP_DATE, 'yyyymmddhh24miss') , to_char(BEGIN_DATE, 'yyyymmddhh24miss') , to_char(END_DATE, 'yyyymmddhh24miss') , REDOFLAG , MIN_NUM , MAX_NUM , EXP_DATE_OFFSET , EXP_DATE_OFFSET_UNIT , USER_RANGE , OFFER_TYPE , to_char(STATE_CHG_DATE, 'yyyymmddhh24miss') , to_char(OFFER_CRT_DATE, 'yyyymmddhh24miss') , GROUP_TYPE_ID , GROUP_LIMIT_RULE , PROD_OFFER_PUBLISHER , CUSTOM_REQUEST , OPERATION_MODLE , EFF_TYPE , EXP_TYPE , MIN_ORDER_NUM , MAX_ORDER_NUM , IF_CUST_PRICE from PRODUCT_OFFER where OFFER_ID=:v1
4d2s7d3b9m2v3SELECT PROD_DATA_INTN_SEQ.NEXTVAL FROM DUAL
4fnbx7ckawjvx select b.OFFER_ID, b.OFFER_CODE, b.OFFER_NAME, b.OFFER_COMMENTS, b.BAND_ID, b.CAN_BE_BUY_ALONE, b.PRICING_PLAN_ID, b.PRIORITY, b.STATE, to_char(b.EFF_DATE, 'yyyymmdd hh24:mi:ss'), to_char(b.EXP_DATE, 'yyyymmdd hh24:mi:ss'), to_char(b.BEGIN_DATE, 'yyyymmdd hh24:mi:ss'), to_char(b.END_DATE, 'yyyymmdd hh24:mi:ss'), b.REDOFLAG, b.MIN_NUM, b.MAX_NUM, b.EXP_DATE_OFFSET, b.EXP_DATE_OFFSET_UNIT, b.USER_RANGE, b.OFFER_ATTR_TYPE, b.OFFER_TYPE, to_char(b.STATE_CHG_DATE, 'yyyymmdd hh24:mi:ss'), to_char(b.OFFER_CRT_DATE, 'yyyymmdd hh24:mi:ss'), b.GROUP_TYPE_ID, nvl(b.GROUP_LIMIT_RULE, 0), b.PROD_OFFER_PUBLISHER, b.CUSTOM_REQUEST, b.OPERATION_MODLE, a.GROUP_ID, a.REGION_NAME, c.pricing_desc, d.band_name, b.eff_type, b.exp_type, b.MIN_ORDER_NUM, b.MAX_ORDER_NUM, b.IF_CUST_PRICE from REGION a, PRODUCT_OFFER b, PRICING_PLAN c, BAND d where a.offer_id=b.Offer_Id and b.pricing_plan_id=c.pricing_plan_id and b.band_id=d.band_id and b.state='A' and b.Eff_Date<sysdate and b.exp_date>sysdate and b.begin_date<sysdate and b.end_date>sysdate and :region_id_str like '%#'||a.group_id||'#%' and to_number(a.Right_Limit) <= :power_right and (a.Chn_Class_Limit like '%#'||:channel_segment ||'#%' or trim(:channel_segment ) is null) and 0=Offer_Login_Limit_Check(b.offer_id, :login_no )
4yya7jnf3arvuSELECT distinct loginaccept FROM wProductOffOnChg where substr(SERVID, -1)=2
5mydb27d7ma0hSELECT MAX (CNUM) FROM (SELECT COUNT (0) CNUM FROM SBANDOFFER WHERE ELEMENT_CODE = :B2 AND ELEMENT_TYPE = 'gh' AND OFFER_ID = :B1 AND BAND_TYPE = 80 AND STATE = '1' AND EFFDATE <= SYSDATE AND EXPDATE >= SYSDATE UNION SELECT COUNT (0) CNUM FROM DLOGINROLEREL A, SBANDOFFER B WHERE A.LOGIN_NO = :B2 AND A.POWER_CODE = B.ELEMENT_CODE AND ELEMENT_TYPE = 'js' AND BAND_TYPE = 80 AND OFFER_ID = :B1 AND STATE = '1' AND EFFDATE <= SYSDATE AND EXPDATE >= SYSDATE)
5rwf3g5hkjrwaselect owner_type from dcustdoc where cust_id = :"SYS_B_0"
5rxtdg9bjbwh7SELECT distinct loginaccept FROM wProductOffOnChg where substr(SERVID, -1)=5
619hvrnhyu9agSELECT COUNT(PHONE_NO) FROM ONEDAYSHORTMSG A WHERE OP_TIME >= TO_DATE(TO_CHAR(SYSDATE - 1, 'yyyy-mm-dd') || '000000', 'yyyy-mm-ddhh24miss') AND OP_TIME <= TO_DATE(TO_CHAR(SYSDATE - 1, 'yyyy-mm-dd') || '235959', 'yyyy-mm-ddhh24miss')
6as60z0uwcgmsselect m.id_no from dsrvtask m , dcusthigh n where m.id_no = n.id_no and n.phone_no=:"SYS_B_0" and substr(n.run_code, :"SYS_B_1", :"SYS_B_2") not in (:"SYS_B_3", :"SYS_B_4")
6bjssyqng22g0insert into rbo006mid (max_accept, login_accept, op_time, op_code, sm_code, actual_pay, innet_fee, sim_fee, machine_fee, hand_fee, choice_fee, other_fee, phone_no, region_code, Login_no) select 0, login_accept, op_time, op_code, nvl(trim(a.sm_code), 'ZZ'), 0, 0, 0, 0, 0, 0, pay_money, nvl(d.service_no, Phone_no), substr(Org_code, 1, 2), login_no from WLOGINOPR201212 a, sRptStatCfg b, srptstatkind c, daccountidinfo d where total_date>=:bin_begin_time and total_date<=:bin_end_time --and org_group=:bin_org_group and op_code not in (select op_code from srptopcode where query_kind='W') and a.pay_type!='w' and a.phone_no=d.msisdn(+) and (a.op_note!='实时停开机进程' or op_note is null) and Login_no = :Login_No and nvl(trim(a.sm_code), 'ZZ') = b.sm_code(+) and b.stat_kind = c.stat_kind(+) and c.query_kind = :in_type order by Phone_no, op_time, op_code
6hx8cr32f4tkkselect * from dcusthigh where id_no = :"SYS_B_0" and SERVICE_NO=:"SYS_B_1"
6mddmzpmsduqpSELECT NVL(W.XML_DATA.EXTRACT ('/CustInfoRequest/MsgBody/Customer/UserInfoList/UserInfo/ProductList/product['|| :B2 || ']/ProductBaseInfo/ProductId/text()' ).GETSTRINGVAL (), '0'), NVL(W.XML_DATA.EXTRACT ('/CustInfoRequest/MsgBody/Customer/UserInfoList/UserInfo/ProductList/product['|| :B2 || ']/ProductBaseInfo/OperatorFlag/text()').GETSTRINGVAL (), '0'), NVL(W.XML_DATA.EXTRACT ('/CustInfoRequest/MsgBody/Customer/UserInfoList/UserInfo/ProductList/product['|| :B2 || ']/ProductBaseInfo/IsMainProduct/text()').GETSTRINGVAL (), '0' ), NVL(W.XML_DATA.EXTRACT ('/CustInfoRequest/MsgBody/Customer/UserInfoList/UserInfo/ProductList/product['|| :B2 || ']/ProductBaseInfo/EffectDate/text()').GETSTRINGVAL(), '0'), NVL(W.XML_DATA.EXTRACT ('/CustInfoRequest/MsgBody/Customer/UserInfoList/UserInfo/ProductList/product['|| :B2 || ']/ProductBaseInfo/ExpireDate/text()').GETSTRINGVAL(), '0') FROM TPHS_XML_TEMP W WHERE W.ORDER_ID = :B1
6tzfj5sccsr04** SQL Text Not Available **
6ub7p2kpfc4wySELECT HLRCODE, OPTCODE, INSTINFO, EXWORKSN, SVCNUM, WORKSHTSN, PRI FROM (SELECT /*+ INDEX_ASC(A PK_XWORK_CJ_SEND)*/ * FROM OFFON.TINEXWORK_CJ_SEND A WHERE DEALFLAG='0' AND HLRCODE = 'MS3' ORDER BY PRIFLAG, PRI, WORKSHTSN, EXWORKSN) WHERE ROWNUM<=90
6wqf3krg83v7vselect PROVINCE_CODE, PROVINCE_NAME, RUN_FLAG, AGENT_PROV_CODE from sprovincecode where run_flag='Y'
71tbpwx3f7fpsselect count(*) from dpointrelamsg a, dcusthigh b, product_offer c where a.status = any(:"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3") and ceil(months_between(sysdate, a.eff_date)) <= :"SYS_B_4" and a.n_id_no = b.id_no and b.dinner_code = c.offer_id(+) and a.o_id_no = :"SYS_B_5"
72c2v7whcdv49select count(*) from ( select a.id_no , a.cust_id , a.user_name , a.phone_no , a.group_id , to_char(a.contact_date, :"SYS_B_0") contact_date , a.grade_code , a.sm_code , a.run_code , floor(months_between(sysdate, a.open_time)) tele_long , a.score , d.MASTER_SERV_name product_code , a.ARPU from dcusthigh a, serv b , product c, master_server d where a.id_no = b.serv_id and b.product_id =c.product_id and c.master_serv_id=d.MASTER_SERV_ID and a.service_no=:"SYS_B_1" and a.region_code=:"SYS_B_2" )
7f5ucjrdpv2uninsert into rpd002mid (max_accept, org_group, op_code, num, pay_type, actual_pay, prepay_fee , once_fee, deposit) select :in_login_accept, a.org_group, a.op_code, sum(a.num), b.STAT_KIND, sum(a.pay_money), sum(a.prepay_fee), sum(a.once_fee), sum(a.deposit) from twlogin2012 a, srptstatcfg b, srptstatkind c where a.total_date between :in_begin_time and :in_end_time and (a.op_code = :in_function_code1 or :in_function_code2 = 'ZZZZ') and a.sm_code = b.sm_code(+) and b.stat_kind = c.stat_kind(+) and c.query_kind = :in_type and a.org_group in (select org_group from TmpGroup_id) group by a.org_group, a.op_code, b.STAT_KIND
7mzcnjcrv0ra5 select b.OFFER_ID, b.OFFER_CODE, b.OFFER_NAME, b.OFFER_COMMENTS, b.BAND_ID, b.CAN_BE_BUY_ALONE, b.PRICING_PLAN_ID, b.PRIORITY, b.STATE, to_char(b.EFF_DATE, 'yyyymmdd hh24:mi:ss'), to_char(b.EXP_DATE, 'yyyymmdd hh24:mi:ss'), to_char(b.BEGIN_DATE, 'yyyymmdd hh24:mi:ss'), to_char(b.END_DATE, 'yyyymmdd hh24:mi:ss'), b.REDOFLAG, b.MIN_NUM, b.MAX_NUM, b.EXP_DATE_OFFSET, b.EXP_DATE_OFFSET_UNIT, b.USER_RANGE, b.OFFER_ATTR_TYPE, b.OFFER_TYPE, to_char(b.STATE_CHG_DATE, 'yyyymmdd hh24:mi:ss'), to_char(b.OFFER_CRT_DATE, 'yyyymmdd hh24:mi:ss'), b.GROUP_TYPE_ID, nvl(b.GROUP_LIMIT_RULE, 0), b.PROD_OFFER_PUBLISHER, b.CUSTOM_REQUEST, b.OPERATION_MODLE, a.GROUP_ID, a.REGION_NAME, c.pricing_desc, d.band_name, b.eff_type, b.exp_type, b.MIN_ORDER_NUM, b.MAX_ORDER_NUM, b.IF_CUST_PRICE from REGION a, PRODUCT_OFFER b, PRICING_PLAN c, BAND d where a.offer_id=b.Offer_Id and b.pricing_plan_id=c.pricing_plan_id and b.band_id=d.band_id and b.state='A' and b.Eff_Date<sysdate and b.exp_date>sysdate and b.begin_date<sysdate and b.end_date>sysdate and :region_id_str like '%#'||a.group_id||'#%' and to_number(a.Right_Limit) <= :power_right and (a.Chn_Class_Limit like '%#'||:channel_segment ||'#%' or trim(:channel_segment ) is null) and 0=Offer_Login_Limit_Check(b.offer_id, :login_no )
7sp5b83m9g1wdselect count(*) into :b0 from WOCSUSERINTERFACE where ((RET_CODE is null or RET_CODE=' ') or (RET_CODE='0' and mod(ID_NO, 10)=:b1))
7vfn2da54s0c8Select Count(*) From Dsrvreturnrec_Yes Where Trunc(Return_Date) Between Trunc(Sysdate - :"SYS_B_0") - :"SYS_B_1" And Sysdate And return_type =:"SYS_B_2" And phone_no =:"SYS_B_3"
81z5tmxv3j6d6UPDATE OFFON.TINEXWORK_SEND SET DEALFLAG='3' WHERE EXWORKSN = :vtotalex
88gsspy0cxnt4SELECT NVL(W.XML_DATA.EXTRACT ('/CustInfoRequest/MsgBody/Customer/UserInfoList/UserInfo/DiscountInfoList/DiscountInfoListContainer['||:B3 ||']/DiscountAttrList/DiscountAttr['||:B2 ||']/OperatorFlag/text()').GETSTRINGVAL (), '0'), NVL(W.XML_DATA.EXTRACT ('/CustInfoRequest/MsgBody/Customer/UserInfoList/UserInfo/DiscountInfoList/DiscountInfoListContainer['||:B3 ||']/DiscountAttrList/DiscountAttr['||:B2 ||']/AttrCode/text()').GETSTRINGVAL (), '0'), NVL(W.XML_DATA.EXTRACT ('/CustInfoRequest/MsgBody/Customer/UserInfoList/UserInfo/DiscountInfoList/DiscountInfoListContainer['||:B3 ||']/DiscountAttrList/DiscountAttr['||:B2 ||']/AttrValue/text()').GETSTRINGVAL (), '0') FROM TPHS_XML_TEMP W WHERE W.ORDER_ID = :B1
8dfv00s4u89tsUPDATE OFFON.TINEXWORK_SEND SET DEALFLAG='1', FINISHDATE=sysdate WHERE EXWORKSN = :vexworksn
8ggxb1gjf4b1z select OFFER_ID, OFFER_CODE, OFFER_NAME, OFFER_COMMENTS, BAND_ID, CAN_BE_BUY_ALONE, PRICING_PLAN_ID, PRIORITY, STATE, to_char(EFF_DATE, 'yyyymmdd hh24:mi:ss'), to_char(EXP_DATE, 'yyyymmdd hh24:mi:ss'), to_char(BEGIN_DATE, 'yyyymmdd hh24:mi:ss'), to_char(END_DATE, 'yyyymmdd hh24:mi:ss'), REDOFLAG, MIN_NUM, MAX_NUM, EXP_DATE_OFFSET, EXP_DATE_OFFSET_UNIT, USER_RANGE, OFFER_ATTR_TYPE, OFFER_TYPE, to_char(STATE_CHG_DATE, 'yyyymmdd hh24:mi:ss'), to_char(OFFER_CRT_DATE, 'yyyymmdd hh24:mi:ss'), GROUP_TYPE_ID, nvl(GROUP_LIMIT_RULE, 0), PROD_OFFER_PUBLISHER, CUSTOM_REQUEST, OPERATION_MODLE, nvl(GROUP_ID, '00000'), nvl(REGION_NAME, '无地域'), pricing_desc, band_name, eff_type, exp_type, MIN_ORDER_NUM, MAX_ORDER_NUM, IF_CUST_PRICE from ( select b.*, a.GROUP_ID, a.REGION_NAME, c.pricing_desc, d.band_name from REGION a, PRODUCT_OFFER b, PRICING_PLAN c, BAND d where a.offer_id=b.Offer_Id and b.pricing_plan_id=c.pricing_plan_id and b.band_id=d.band_id and b.state='A' and b.Eff_Date<sysdate and b.exp_date>sysdate and b.begin_date<sysdate and b.end_date>sysdate and :region_id_str like '%#'||a.group_id||'#%' and to_number(a.Right_Limit) <= :power_right and (a.Chn_Class_Limit like '%#'||:channel_segment ||'#%' or trim(:channel_segment ) is null) and 0=Offer_Login_Limit_Check(b.offer_id, :login_no ) union select e.*, h.GROUP_ID, h.R EGION_NAME, f.pricing_desc, g.band_name from region h, product_offer e, PRICING_PLAN f, BAND g where e.Offer_Id=h.offer_id(+) and e.pricing_plan_id=f.pricing_plan_id and e.band_id=g.band_id and e.offer_id in (select offer_id from product_offer_instance where serv_id=:serv_id and state='A' and exp_date>sysdate) )
8w6tbzkftbrywselect trim(tele_type) from dcusthigh where phone_no=:"SYS_B_0"
8zzf7rctzftr9select count(*) from UDISTRIBUTE_LOG b, dCustHigh a, dloginmsg d where a.id_no = b.id_no and a.group_id in ( select t.group_id from dChnGroupInfo t where t.parent_group_id = :"SYS_B_0" and t.denorm_level >= :"SYS_B_1" ) and to_char(b.update_data, :"SYS_B_2") >= :"SYS_B_3" and b.old_service_no=d.login_no(+)
92ufy6fzxj22vselect contract_no from dconusermsg WHERE id_no = :"SYS_B_0" AND serial_no = :"SYS_B_1" AND bill_order = (select MIN (bill_order) from dconusermsg WHERE id_no = :"SYS_B_2" AND serial_no = :"SYS_B_3")
97cr4yaa07kaaSELECT NVL(CONVERT(W.XML_DATA.EXTRACT ('/CustInfoRequest/MsgBody/Customer/UserInfoList/UserInfo/ProductList/product['||:B3 ||']/ProductAttrList/ProductAttr['||:B2 ||']/AttrId/text()').GETSTRINGVAL(), 'WE8ISO8859P1', 'utf8'), ' '), NVL(CONVERT(W.XML_DATA.EXTRACT ('/CustInfoRequest/MsgBody/Customer/UserInfoList/UserInfo/ProductList/product['||:B3 ||']/ProductAttrList/ProductAttr['||:B2 ||']/AttrValue/text()').GETSTRINGVAL(), 'WE8ISO8859P1', 'utf8'), ' ') FROM TPHS_XML_TEMP W WHERE W.ORDER_ID = :B1
9hnagv73nyaxpselect bank_cust from dConmsg where contract_no = :"SYS_B_0"
9hsvu0mwcusv6UPDATE OFFON.TINEXWORK_CJ_SEND SET DEALFLAG='1', FINISHDATE=sysdate WHERE EXWORKSN = :vexworksn
9kf2tr53jn28gcreate table chj_serv_product as select a.serv_product_id, a.serv_id, a.product_id, b.agreement_id from serv_product a, serv b where a.agreement_id=0 and a.exp_date>sysdate and b.serv_id=a.serv_id and b.state!='a' and b.agreement_id!=a.agreement_id
9rj28a59y6g18DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN pro_update_line; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
9z4zmawpf2zmnselect /*+ all_rows */ a.id_no, a.phone_no||:"SYS_B_00"||TRANSLATE(a.user_name, :"SYS_B_01", :"SYS_B_02")||:"SYS_B_03"||a.score||:"SYS_B_04" from dcusthigh a where :"SYS_B_05"=:"SYS_B_06" and a.turnon_flag = :"SYS_B_07" and (service_no is null or service_no = :"SYS_B_08") and a.sm_code = :"SYS_B_09" and to_char(a.group_id) in (select t.group_id from dChnGroupInfo t where t.parent_group_id = :"SYS_B_10"and t.denorm_level >= :"SYS_B_11") and substr(a.run_code, :"SYS_B_12", :"SYS_B_13") not in (:"SYS_B_14", :"SYS_B_15") and rownum<=:"SYS_B_16" order by a.arpu desc
a18fnbq24kzqu** SQL Text Not Available **
a20j388ug1x1pselect lower(csound(function_name, :"SYS_B_0")) into :b0 from sfunccode where function_code=:b1
a7xs3b8bfz5fzbegin EXECUTE IMMEDIATE :sql_nu into :cnumber using :vworkshtsn ; end ;
asadr6t3dygx9select sum(bytes/1024/1024) from dba_free_space
aw74vfkpahp1hselect nvl(current_point, :"SYS_B_0") from dbmark.DMARKTOTAL201212 WHERE ID_NO =:"SYS_B_1"
awp48dqc6mxxsselect structID, parStructID, engname, structName, ruleflag, atomflag, datatype, datalen, defvalue, stlevel, itemorder, nuFlag, remark, FIELDID from PRODUCT_ORDER_STRUCT where structID = :v1 order by itemorder
b00adgz6wc11fselect count(id_no) from DCUSTUSERSMSDISABLE a where a.phone_no = :"SYS_B_0"
b9m7f9c43aapsselect count(distinct t.order_id) into :b0 from WSNDCMDDAYINFO t where ((((t.SUCC_FLAG='0' and substr(t.order_id, 1, 1)='G') and not exists (select 1 from wsndcmddayinfo w where (w.order_id=t.order_id and (w.succ_flag is null or w.succ_flag='1')))) and MOD(ID_NO, 10)=:b1) and ROWNUM<=1)
bd4hahr70fk5hSELECT count(1) FROM OFFON.TINEXWORK_SEND WHERE EXWORKSN like :vworkshtsn and DEALFLAG<>'1'
bhr48yp313m9w** SQL Text Not Available **
bk7km0ndmgfrtbegin pro_getProduct_info ( :lc_orderid , :lc_return_flag , :lc_errmsg ) ; END ;
brtx0n265qu05DELETE FROM "SERV_CHG" "A1" WHERE "A1"."ACC_NBR"=:"SYS_B_0" AND TO_CHAR("A1"."BILL_START_TIME", :"SYS_B_1")=:"SYS_B_2" AND "A1"."OP_TYPE"=:"SYS_B_3" AND TO_CHAR("A1"."OP_TIME", :"SYS_B_4")=:"SYS_B_5"
bzhubg5vynj32** SQL Text Not Available **
c3xbw04a3f7wp** SQL Text Not Available **
c5yn9tc797409select id_type, id_iccid, owner_type from dcustdoc where cust_id=:"SYS_B_0"
chkvu0pdg582nSELECT "PHONE_NO", "REGION_CODE", "DISTRICT_CODE", "TOWN_CODE" FROM "DBRESADM"."DCUSTRES" "B" WHERE :1="PHONE_NO"
cj9cmxzd4vdr8select ID_NO , OP_CODE , ROWID , NVL(F_WOCSUSERINTERFACE(SERV_ORDER_ID, LOGIN_ACCEPT, ID_NO, SERVICE_NO, SM_CODE, OP_CODE, OP_TIME), '0') into :b0, :b1, :b2, :b3 from WOCSUSERINTERFACE where ((((RET_CODE is null or RET_CODE=' ') or RET_CODE='0') and mod(ID_NO, 10)=:b4) and ROWNUM=1)
cq8t562h0yw0a** SQL Text Not Available **
cz0b04g3x42phselect h.attr_val, k.cust_name, decode(i.attr_val, '0', '地市级', 1, '全省级', '未知'), a.acc_nbr, short_num, member_role_name, region_name, to_char(a.eff_date, 'YYYYMMDD HH24:MI:SS'), to_char(a.exp_date, 'YYYYMMDD HH24:MI:SS') from group_instance_member a, group_instance b, group_instance_role c, serv d, dcustmsg e, sregioncode f, product_offer_instance g, serv_attr h, serv_attr i, dcustmsg j, dcustdoc k where a.exp_date>sysdate and a.eff_date<sysdate and a.group_id=b.group_id and b.group_type_id=5 AND k.cust_name like '%中华人民共和国乌鲁木齐%' AND b.group_type_id=c.group_type_id AND A.member_role_id=c.member_role_id and a.acc_nbr=d.acc_nbr and d.serv_id=e.id_no and substr(e.belong_code, 1, 2)=f.region_code and b.group_id=g.group_id and g.eff_date<sysdate and g.exp_date>sysdate and g.serv_id=h.serv_id and h.attr_id=20009 and g.serv_id=i.serv_id and i.attr_id=20014 and g.serv_id=j.id_no and j.cust_id=k.cust_id
danmkxgxbrq8rbegin EXECUTE IMMEDIATE :sqlcount INTO :countnum ; END ;
dbpaw529fsp4vselect cust_name from dcustdoc where cust_id=:"SYS_B_0"
dur6ypbh2rp4hselect * from ( select row_.*, rownum rownum_ from ( select a.phone_no, b.res_name, c.group_name, d.status_name, a.good_type, a.op_time, nvl(z.total_prepay, :"SYS_B_00") , nvl(c.code_name, :"SYS_B_01"), a.note from dCustRes a, dChnGroupInfo f, dChnGroupMsg c, sResStatus d, sResCode b , dselfcustres z , sgoodphoneplan c where a.group_id=f.group_id and a.phone_no=z.phone_no(+) and a.region_code=z.region_code(+) and z.price_plan=c.pricing_plan_id(+) and f.parent_group_id=:"SYS_B_02" and a.phone_no >= :"SYS_B_03" and a.phone_no <= :"SYS_B_04" and b.res_code=a.no_type and a.resource_code = d.res_status and b.kind_code=:"SYS_B_05" and d.kind_code = :"SYS_B_06" and a.group_id=c.group_id and f.group_id=c.group_id AND ROWNUM<=:"SYS_B_07" and a.resource_code=:"SYS_B_08" and a.region_code = :"SYS_B_09" and a.region_code = :"SYS_B_10") row_ where rownum <= :"SYS_B_11") where rownum_ >= :"SYS_B_12"
fa00mtsqu413zdelete temp_phonesel b WHERE EXISTS (SELECT 1 FROM DCUSTMSGDEAD a WHERE SM_CODE = 'os' AND a.phone_no=b.phone_no AND TO_CHAR(ADD_MONTHS(RUN_TIME, 2), 'yyyymm') > TO_CHAR(SYSDATE, 'yyyymm'))
fa6zas4619538select param_value from ssysctrlparam where param_id='6'
fg9w4sbqhq680** SQL Text Not Available **
fh2fy16ur22bfselect a.code_describ from serv t, SCODEVALUE a, dcustmsg b WHERE t.billing_cycle_type_id=a.code_value_type AND t.serv_id=b.id_no AND a.code_type_id=:"SYS_B_0" AND b.sm_code=:"SYS_B_1" AND t.serv_id=:"SYS_B_2"
fpjt82gmaqvb3select id_no from (SELECT ID_NO FROM DCUSTHIGH WHERE PHONE_NO = :"SYS_B_0" OR DUMMY_PHONE=:"SYS_B_1" order by id_no asc) where rownum = :"SYS_B_2"
fy5bm7umxky4vinsert into wcommonshortmsg_temp(COMMAND_ID, LOGIN_ACCEPT, MSG_LEVEL, PHONE_NO, MSG, ORDER_CODE, BACK_CODE, DX_OP_CODE, OP_CODE, SEND_ORDER, LOGIN_NO, OP_TIME, SEND_TIME, SHORTMSG_TABLE, CONTENT_ID, SYS_NOTE) values(soffon.nextval, soffon.currval, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", sysdate, sysdate, :"SYS_B_09", :"SYS_B_10", :"SYS_B_11")
g04sx6dqwr5cm** SQL Text Not Available **
gbpzhwak5pmfd** SQL Text Not Available **
gqmwndpnk18swselect a.offer_id, b.offer_name, DECODE (b.offer_type, :"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3"), b.offer_name, a.eff_date, a.exp_date, DECODE (SIGN (a.exp_date - SYSDATE), :"SYS_B_4", :"SYS_B_5", :"SYS_B_6"), :"SYS_B_7", a.state_date, a.handle_login_no from product_offer_instance a, product_offer b WHERE serv_id = :"SYS_B_8" AND a.offer_id = b.offer_id
gvyfb56frnx0mSELECT * FROM "PRODUCT"."PRODUCT_OFFER_INSTANCE"

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 951,561 535.15 4.16
CPU used when call started 936,685 526.78 4.09
CR blocks created 159,300 89.59 0.70
Cached Commit SCN referenced 475,047 267.16 2.07
Commit SCN cached 106 0.06 0.00
DB time 6,229,930 3,503.64 27.21
DBWR checkpoint buffers written 49,744 27.98 0.22
DBWR checkpoints 2 0.00 0.00
DBWR fusion writes 103,818 58.39 0.45
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 1,172 0.66 0.01
DBWR undo block writes 141,375 79.51 0.62
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 184 0.10 0.00
PX local messages recv'd 1,102 0.62 0.00
PX local messages sent 1,102 0.62 0.00
PX remote messages recv'd 3,113 1.75 0.01
PX remote messages sent 2,437 1.37 0.01
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 184 0.10 0.00
RowCR - row contention 1,549 0.87 0.01
RowCR attempts 289,977 163.08 1.27
RowCR hits 290,951 163.63 1.27
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 5 0.00 0.00
SMON posted for undo segment shrink 182 0.10 0.00
SQL*Net roundtrips to/from client 11,977,667 6,736.09 52.32
SQL*Net roundtrips to/from dblink 1,973,998 1,110.15 8.62
active txn count during cleanout 316,494 177.99 1.38
application wait time 3,395 1.91 0.01
background checkpoints completed 2 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 8,778 4.94 0.04
branch node splits 26 0.01 0.00
buffer is not pinned count 93,310,036 52,476.41 407.57
buffer is pinned count 243,907,789 137,170.72 1,065.36
bytes received via SQL*Net from client 3,073,196,552 1,728,327.72 13,423.30
bytes received via SQL*Net from dblink 1,226,144,612 689,568.56 5,355.63
bytes sent via SQL*Net to client 5,014,729,104 2,820,221.61 21,903.64
bytes sent via SQL*Net to dblink 387,752,629 218,067.28 1,693.65
calls to get snapshot scn: kcmgss 24,750,184 13,919.20 108.11
calls to kcmgas 2,225,047 1,251.34 9.72
calls to kcmgcs 250,767 141.03 1.10
change write time 5,994 3.37 0.03
cleanout - number of ktugct calls 318,910 179.35 1.39
cleanouts and rollbacks - consistent read gets 147,147 82.75 0.64
cleanouts only - consistent read gets 66,975 37.67 0.29
cluster key scan block gets 93,363 52.51 0.41
cluster key scans 80,726 45.40 0.35
cluster wait time 459,863 258.62 2.01
commit batch performed 68,972 38.79 0.30
commit batch requested 68,972 38.79 0.30
commit batch/immediate performed 70,137 39.44 0.31
commit batch/immediate requested 70,137 39.44 0.31
commit cleanout failures: block lost 19,277 10.84 0.08
commit cleanout failures: buffer being written 37 0.02 0.00
commit cleanout failures: callback failure 25,300 14.23 0.11
commit cleanout failures: cannot pin 324 0.18 0.00
commit cleanouts 1,695,998 953.81 7.41
commit cleanouts successfully completed 1,651,062 928.54 7.21
commit immediate performed 1,165 0.66 0.01
commit immediate requested 1,165 0.66 0.01
commit txn count during cleanout 257,756 144.96 1.13
concurrency wait time 1,640,386 922.53 7.16
consistent changes 1,380,729 776.50 6.03
consistent gets 1,025,257,464 576,592.11 4,478.18
consistent gets - examination 95,005,919 53,430.15 414.97
consistent gets direct 3,259,617 1,833.17 14.24
consistent gets from cache 1,021,997,714 574,758.87 4,463.94
current blocks converted for CR 564 0.32 0.00
cursor authentications 3,492 1.96 0.02
data blocks consistent reads - undo records applied 884,279 497.31 3.86
db block changes 8,470,662 4,763.80 37.00
db block gets 18,145,370 10,204.73 79.26
db block gets direct 7,922 4.46 0.03
db block gets from cache 18,137,461 10,200.28 79.22
deferred (CURRENT) block cleanout applications 321,972 181.07 1.41
dirty buffers inspected 298,717 167.99 1.30
enqueue conversions 7,303,717 4,107.52 31.90
enqueue deadlocks 0 0.00 0.00
enqueue releases 8,404,162 4,726.40 36.71
enqueue requests 8,406,738 4,727.85 36.72
enqueue timeouts 2,529 1.42 0.01
enqueue waits 12,264 6.90 0.05
exchange deadlocks 822 0.46 0.00
execute count 17,633,831 9,917.05 77.02
failed probes on index block reclamation 35 0.02 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 27,604,738 15,524.56 120.57
free buffer requested 27,002,964 15,186.13 117.95
gc CPU used by this session 271,310 152.58 1.19
gc blocks lost 0 0.00 0.00
gc cr block build time 1,467 0.83 0.01
gc cr block flush time 1,578 0.89 0.01
gc cr block receive time 51,905 29.19 0.23
gc cr block send time 2,546 1.43 0.01
gc cr blocks received 506,754 284.99 2.21
gc cr blocks served 740,164 416.26 3.23
gc current block flush time 694 0.39 0.00
gc current block pin time 11,487 6.46 0.05
gc current block receive time 788,407 443.39 3.44
gc current block send time 30,076 16.91 0.13
gc current blocks received 5,380,870 3,026.13 23.50
gc current blocks served 8,837,681 4,970.20 38.60
gc local grants 12,859,986 7,232.30 56.17
gc remote grants 8,024,719 4,513.00 35.05
gcs messages sent 31,627,190 17,786.74 138.14
ges messages sent 784,004 440.91 3.42
global enqueue get time 1,855,783 1,043.67 8.11
global enqueue gets async 20,600 11.59 0.09
global enqueue gets sync 3,230,988 1,817.07 14.11
global enqueue releases 3,231,418 1,817.31 14.11
heap block compress 27,683 15.57 0.12
hot buffers moved to head of LRU 6,321,684 3,555.24 27.61
immediate (CR) block cleanout applications 214,152 120.44 0.94
immediate (CURRENT) block cleanout applications 149,849 84.27 0.65
index crx upgrade (found) 18 0.01 0.00
index crx upgrade (positioned) 83,555 46.99 0.36
index fast full scans (full) 212,163 119.32 0.93
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 46,693,513 26,259.85 203.95
index scans kdiixs1 16,799,019 9,447.56 73.38
leaf node 90-10 splits 639 0.36 0.00
leaf node splits 7,073 3.98 0.03
lob reads 3,364,798 1,892.32 14.70
lob writes 93,296 52.47 0.41
lob writes unaligned 92,265 51.89 0.40
logons cumulative 10,051 5.65 0.04
messages received 463,214 260.51 2.02
messages sent 462,798 260.27 2.02
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 919,660,166 517,205.50 4,016.95
opened cursors cumulative 3,009,618 1,692.57 13.15
parse count (failures) 25,111 14.12 0.11
parse count (hard) 76,272 42.89 0.33
parse count (total) 3,907,405 2,197.48 17.07
parse time cpu 14,961 8.41 0.07
parse time elapsed 1,069,723 601.60 4.67
physical read IO requests 8,046,310 4,525.15 35.15
physical read bytes ############### 110,189,002.64 855,798.13
physical read total IO requests 8,096,956 4,553.63 35.37
physical read total bytes ############### 111,828,855.71 868,534.27
physical read total multi block requests 807,920 454.36 3.53
physical reads 23,917,383 13,450.84 104.47
physical reads cache 20,652,820 11,614.89 90.21
physical reads cache prefetch 17,570,528 9,881.45 76.75
physical reads direct 3,264,582 1,835.96 14.26
physical reads direct (lob) 3,253,616 1,829.79 14.21
physical reads direct temporary tablespace 2,040 1.15 0.01
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 340,874 191.70 1.49
physical write bytes 4,282,679,296 2,408,525.85 18,706.15
physical write total IO requests 652,534 366.98 2.85
physical write total bytes 8,010,682,368 4,505,108.65 34,989.55
physical write total multi block requests 311,456 175.16 1.36
physical writes 522,788 294.01 2.28
physical writes direct 11,079 6.23 0.05
physical writes direct (lob) 7,779 4.37 0.03
physical writes direct temporary tablespace 2,040 1.15 0.01
physical writes from cache 511,709 287.78 2.24
physical writes non checkpoint 494,592 278.15 2.16
pinned buffers inspected 5,151 2.90 0.02
prefetch clients - default 1 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 4,689 2.64 0.02
process last non-idle time 1,791 1.01 0.01
queries parallelized 156 0.09 0.00
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 6 0.00 0.00
recursive calls 15,128,961 8,508.34 66.08
recursive cpu usage 262,027 147.36 1.14
redo blocks written 3,034,099 1,706.34 13.25
redo buffer allocation retries 20 0.01 0.00
redo entries 4,477,624 2,518.16 19.56
redo log space requests 34 0.02 0.00
redo log space wait time 46 0.03 0.00
redo ordering marks 107,746 60.60 0.47
redo size 1,421,652,376 799,519.71 6,209.58
redo subscn max counts 17,906 10.07 0.08
redo synch time 29,525 16.60 0.13
redo synch writes 249,638 140.39 1.09
redo wastage 81,111,028 45,615.84 354.28
redo write time 19,408 10.91 0.08
redo writer latching time 18 0.01 0.00
redo writes 270,118 151.91 1.18
rollback changes - undo records applied 23,993 13.49 0.10
rollbacks only - consistent read gets 14,919 8.39 0.07
rows fetched via callback 7,839,569 4,408.88 34.24
session connect time 0 0.00 0.00
session cursor cache hits 3,529,935 1,985.19 15.42
session logical reads 1,043,402,049 586,796.40 4,557.44
session pga memory 1,036,168,192 582,728.17 4,525.84
session pga memory max 96,529,277,984 54,286,871.67 421,626.50
session uga memory ############### 248,960,390.13 1,933,585.30
session uga memory max 5,854,275,032 3,292,371.85 25,570.66
shared hash latch upgrades - no wait 884,758 497.58 3.86
shared hash latch upgrades - wait 1,329 0.75 0.01
sorts (disk) 0 0.00 0.00
sorts (memory) 8,992,621 5,057.34 39.28
sorts (rows) 41,512,153 23,345.92 181.32
sql area evicted 40,160 22.59 0.18
sql area purged 22,403 12.60 0.10
summed dirty queue length 561,947 316.03 2.45
switch current to new buffer 51,805 29.13 0.23
table fetch by rowid 145,997,245 82,107.04 637.70
table fetch continued row 1,474,157 829.05 6.44
table scan blocks gotten 583,117,664 327,938.16 2,546.98
table scan rows gotten 35,457,160,188 19,940,668.21 154,871.96
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 777 0.44 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 1,186,159 667.08 5.18
total number of times SMON posted 1,579 0.89 0.01
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 70,137 39.44 0.31
transaction tables consistent read rollbacks 178 0.10 0.00
transaction tables consistent reads - undo records applied 30,954 17.41 0.14
undo change vector size 570,801,696 321,011.81 2,493.18
user I/O wait time 1,058,760 595.43 4.62
user calls 14,862,880 8,358.70 64.92
user commits 220,253 123.87 0.96
user rollbacks 8,692 4.89 0.04
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 5 0.00 0.00
workarea executions - optimal 8,879,192 4,993.55 38.78
write clones created in background 1 0.00 0.00
write clones created in foreground 116 0.07 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current 18,218 18,440
workarea memory allocated 16,262 8,244
logons current 2,722 2,720
session cursor cache count 36,496,904 36,629,557

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 2 4.05

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)
SERVERDESK_DATA01 3,385,590 1,904 0.51 1.06 16,004 9 3,919 1.19
CRMMSG 2,355,923 1,325 2.68 4.11 5,256 3 193,842 2.75
CUSTMSG03 650,061 366 5.35 2.50 34,470 19 5,962 2.13
CUSTMSG03_IDX 215,963 121 4.49 1.02 92,814 52 5,566 2.69
CUSTMSG01 228,160 128 4.19 12.62 10,855 6 690 6.12
CUSTRES01 223,711 126 2.41 1.63 2,986 2 10,240 1.41
CUSTMSG02 188,639 106 3.30 13.53 29,877 17 58,624 1.20
SERVERDESK_IDX01 180,942 102 2.02 1.00 20,117 11 3,013 4.12
CUSTMSG01_IDX 93,214 52 3.60 1.19 22,770 13 461 2.75
CRMMSG_IDX 87,931 49 4.40 2.22 3,168 2 6,354 2.12
WLOG01_IDX 42,324 24 5.89 1.00 33,775 19 166 8.01
CUSTMSG02_IDX 51,387 29 5.93 1.00 8,189 5 1,205 2.43
CUSTRES_IDX 47,402 27 3.75 1.00 4,378 2 5 6.00
WLOG01 48,600 27 3.90 6.29 519 0 3 0.00
OFFON02 44,824 25 8.64 17.79 930 1 434 1.13
OFFON02_IDX 22,009 12 5.69 1.00 15,817 9 1,136 1.29
USERTEMP 21,995 12 3.73 1.36 2,590 1 0 0.00
SYSTEM 23,459 13 3.36 1.07 342 0 4 0.00
WLOG12 21,325 12 3.85 21.13 10 0 0 0.00
UNDOTBS2 2,080 1 4.91 1.00 19,213 11 1,148 6.69
OFFONHIS01_IDX 10,051 6 5.05 1.00 6,947 4 13 0.00
CHNESB_IDX 13,648 8 5.98 1.00 31 0 1 0.00
CHNESB_DATA 13,222 7 4.67 1.00 40 0 4 2.50
WLOG11 11,903 7 2.78 31.29 14 0 0 0.00
INTERFACE 9,219 5 0.61 1.00 1,400 1 0 0.00
OFFON01_IDX 5,853 3 5.28 1.00 3,958 2 7,956 0.69
UNDOTBS1 7,665 4 2.02 1.00 14 0 5,979 1.12
OFFON01 4,075 2 4.95 14.39 1,118 1 4,040 0.83
WLOG09 5,121 3 2.41 29.28 23 0 0 0.00
CUSTRES02 3,795 2 6.27 1.03 692 0 4 10.00
CHN_DATA 3,481 2 7.11 12.75 114 0 0 0.00
WLOG03 3,573 2 1.50 9.16 13 0 0 0.00
WLOG02 3,569 2 4.56 8.08 13 0 0 0.00
SYSAUX 1,724 1 4.51 1.03 814 0 0 0.00
WLOG04 2,179 1 2.65 27.90 18 0 0 0.00
OFFONHIS02_IDX 1,512 1 2.99 1.00 2 0 0 0.00
CHN_RWD_IDX 1,280 1 3.96 1.00 68 0 0 0.00
CHN_RES 1,138 1 7.85 5.47 200 0 8 3.75
CHN_RWD 1,020 1 5.26 2.30 178 0 0 0.00
CHN_MID 1,021 1 4.29 12.83 25 0 0 0.00
CUSTMNGCFG 713 0 3.56 1.38 12 0 0 0.00
OFFONHIS01 700 0 3.61 1.00 2 0 0 0.00
USERS 571 0 3.75 1.20 2 0 0 0.00
OFFONHIS02 561 0 5.06 1.00 2 0 0 0.00
WLOG09_IDX 512 0 6.33 1.00 11 0 0 0.00
WLOG05_IDX 481 0 6.57 1.00 10 0 0 0.00
CTNGCFG_IDX 331 0 2.08 1.00 134 0 0 0.00
TEMP 220 0 2.77 9.65 202 0 0 0.00
WLOG08 395 0 6.78 1.00 25 0 0 0.00
WLOG08_IDX 397 0 5.87 1.00 15 0 0 0.00
WLOG06_IDX 371 0 6.20 1.00 11 0 0 0.00
CUSTHIS01_IDX 313 0 3.58 1.00 53 0 92 11.09
WLOG07 339 0 5.40 1.00 17 0 0 0.00
WLOG07_IDX 340 0 7.00 1.00 11 0 0 0.00
WLOG10 326 0 6.47 1.00 20 0 0 0.00
WLOG03_IDX 327 0 6.24 1.00 10 0 0 0.00
WLOG04_IDX 308 0 6.43 1.00 11 0 0 0.00
WLOG02_IDX 305 0 6.52 1.00 10 0 0 0.00
WLOG06 277 0 5.81 1.00 16 0 0 0.00
CUSTHIS01 267 0 4.04 1.66 24 0 0 0.00
WLOG05 266 0 5.53 1.00 19 0 0 0.00
WLOG12_IDX 260 0 5.69 1.00 10 0 0 0.00
WLOG11_IDX 184 0 5.98 1.00 10 0 0 0.00
WLOG10_IDX 173 0 6.36 1.00 10 0 0 0.00
CHN_CFG 93 0 3.01 2.06 2 0 0 0.00
PERFSTAT 10 0 5.00 1.00 2 0 0 0.00
CHN_RPT 6 0 3.33 1.00 2 0 0 0.00
CIC_MOM_INDEX 3 0 13.33 1.00 1 0 0 0.00
CIC_MOM_TABLE 3 0 13.33 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
CHNESB_DATA /dev/rcrm_data464 1,576 1 5.24 1.00 1 0 0 0.00
CHNESB_DATA /dev/rcrm_data465 1,730 1 4.61 1.00 3 0 0 0.00
CHNESB_DATA /dev/rcrm_data466 1,299 1 4.21 1.00 3 0 0 0.00
CHNESB_DATA /dev/rcrm_data467 1,396 1 4.63 1.00 1 0 0 0.00
CHNESB_DATA /dev/rcrm_data468 2,724 2 4.42 1.00 13 0 2 0.00
CHNESB_DATA /dev/rcrm_data469 1,916 1 4.76 1.00 3 0 0 0.00
CHNESB_DATA /dev/rcrm_data470 1,462 1 4.77 1.00 1 0 0 0.00
CHNESB_DATA /dev/rcrm_data471 1,119 1 4.89 1.00 15 0 2 5.00
CHNESB_IDX /dev/rcrm_data472 3,257 2 5.99 1.00 1 0 0 0.00
CHNESB_IDX /dev/rcrm_data473 3,558 2 5.95 1.00 8 0 0 0.00
CHNESB_IDX /dev/rcrm_data474 2,116 1 5.85 1.00 13 0 1 0.00
CHNESB_IDX /dev/rcrm_data475 2,318 1 5.99 1.00 8 0 0 0.00
CHNESB_IDX /dev/rcrm_data476 2,399 1 6.11 1.00 1 0 0 0.00
CHN_CFG /dev/rcrm_data81 93 0 3.01 2.06 2 0 0 0.00
CHN_DATA /dev/rcrm_data82 3,481 2 7.11 12.75 114 0 0 0.00
CHN_MID /dev/rcrm_data83 1,021 1 4.29 12.83 25 0 0 0.00
CHN_RES /dev/rcrm_data308 33 0 5.45 5.21 1 0 0 0.00
CHN_RES /dev/rcrm_data369 50 0 8.20 8.98 5 0 2 5.00
CHN_RES /dev/rcrm_data407 221 0 11.40 8.38 8 0 0 0.00
CHN_RES /dev/rcrm_data533 422 0 6.35 3.83 106 0 3 3.33
CHN_RES /dev/rcrm_data653 119 0 5.13 2.03 66 0 0 0.00
CHN_RES /dev/rcrm_data831 13 0 3.08 1.00 2 0 0 0.00
CHN_RES /dev/rcrm_data832 12 0 0.83 1.00 2 0 0 0.00
CHN_RES /dev/rcrm_data84 234 0 9.02 6.79 7 0 3 3.33
CHN_RES /dev/rcrm_date198 34 0 10.88 8.12 3 0 0 0.00
CHN_RPT /dev/rcrm_data85 6 0 3.33 1.00 2 0 0 0.00
CHN_RWD /dev/rcrm_data121 34 0 2.06 1.21 2 0 0 0.00
CHN_RWD /dev/rcrm_data122 34 0 4.41 1.18 4 0 0 0.00
CHN_RWD /dev/rcrm_data123 11 0 4.55 1.64 2 0 0 0.00
CHN_RWD /dev/rcrm_data14 147 0 4.35 1.04 16 0 0 0.00
CHN_RWD /dev/rcrm_data181 23 0 3.48 1.30 2 0 0 0.00
CHN_RWD /dev/rcrm_data182 19 0 4.74 1.32 2 0 0 0.00
CHN_RWD /dev/rcrm_data184 23 0 6.09 1.30 4 0 0 0.00
CHN_RWD /dev/rcrm_data196 12 0 3.33 1.50 1 0 0 0.00
CHN_RWD /dev/rcrm_data205 24 0 5.42 1.29 7 0 0 0.00
CHN_RWD /dev/rcrm_data206 38 0 3.95 4.21 2 0 0 0.00
CHN_RWD /dev/rcrm_data214 32 0 5.63 4.81 1 0 0 0.00
CHN_RWD /dev/rcrm_data215 16 0 5.63 8.63 1 0 0 0.00
CHN_RWD /dev/rcrm_data216 25 0 6.40 5.88 2 0 0 0.00
CHN_RWD /dev/rcrm_data226 13 0 4.62 10.38 1 0 0 0.00
CHN_RWD /dev/rcrm_data227 12 0 4.17 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data244 12 0 3.33 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data245 7 0 7.14 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data266 16 0 6.88 8.63 2 0 0 0.00
CHN_RWD /dev/rcrm_data267 33 0 6.67 4.70 12 0 0 0.00
CHN_RWD /dev/rcrm_data286 24 0 4.17 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data287 13 0 6.15 1.00 4 0 0 0.00
CHN_RWD /dev/rcrm_data299 11 0 5.45 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data300 5 0 6.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data303 5 0 8.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data304 10 0 4.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data305 11 0 4.55 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data346 5 0 10.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data347 7 0 7.14 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data355 11 0 7.27 1.00 2 0 0 0.00
CHN_RWD /dev/rcrm_data356 14 0 2.86 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data360 18 0 7.78 7.78 1 0 0 0.00
CHN_RWD /dev/rcrm_data361 34 0 5.88 4.59 18 0 0 0.00
CHN_RWD /dev/rcrm_data362 32 0 2.81 4.81 17 0 0 0.00
CHN_RWD /dev/rcrm_data409 10 0 10.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data410 9 0 13.33 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data411 11 0 10.91 1.00 2 0 0 0.00
CHN_RWD /dev/rcrm_data418 23 0 6.52 1.17 1 0 0 0.00
CHN_RWD /dev/rcrm_data432 5 0 8.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data477 10 0 7.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data480 13 0 4.62 1.00 7 0 0 0.00
CHN_RWD /dev/rcrm_data481 3 0 10.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data52 9 0 6.67 1.78 2 0 0 0.00
CHN_RWD /dev/rcrm_data53 15 0 6.00 1.40 2 0 0 0.00
CHN_RWD /dev/rcrm_data54 12 0 6.67 1.58 2 0 0 0.00
CHN_RWD /dev/rcrm_data540 4 0 7.50 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data541 4 0 7.50 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data542 7 0 4.29 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data543 4 0 10.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data544 3 0 10.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data545 5 0 8.00 1.00 3 0 0 0.00
CHN_RWD /dev/rcrm_data546 7 0 5.71 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data547 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data562 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data563 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data564 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data565 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data566 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data567 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data568 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data570 3 0 0.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data578 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data579 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data580 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data581 7 0 4.29 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data582 4 0 5.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data583 4 0 5.00 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data584 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data585 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data586 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data587 3 0 6.67 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data588 6 0 3.33 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data589 6 0 3.33 1.00 1 0 0 0.00
CHN_RWD /dev/rcrm_data73 14 0 2.86 1.43 1 0 0 0.00
CHN_RWD /dev/rcrm_data743 4 0 5.00 1.00 2 0 0 0.00
CHN_RWD /dev/rcrm_data744 4 0 5.00 1.00 2 0 0 0.00
CHN_RWD /dev/rcrm_data745 6 0 3.33 1.00 2 0 0 0.00
CHN_RWD /dev/rcrm_data746 6 0 3.33 1.00 2 0 0 0.00
CHN_RWD /dev/rcrm_data75 13 0 3.85 1.54 2 0 0 0.00
CHN_RWD /dev/rcrm_data77 13 0 6.15 1.46 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data125 10 0 6.00 1.00 2 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data15 8 0 8.75 1.00 2 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data183 10 0 3.00 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data185 10 0 2.00 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data203 26 0 3.08 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data207 10 0 0.00 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data228 7 0 5.71 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data229 8 0 6.25 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data246 7 0 4.29 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data247 7 0 4.29 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data268 11 0 3.64 1.00 3 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data301 33 0 3.03 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data302 777 0 3.62 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data322 13 0 4.62 1.00 2 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data323 17 0 5.88 1.00 3 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data357 13 0 7.69 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data363 18 0 5.56 1.00 2 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data419 14 0 6.43 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data420 18 0 6.67 1.00 5 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data421 16 0 6.88 1.00 5 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data482 13 0 5.38 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data483 14 0 5.71 1.00 3 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data534 13 0 5.38 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data535 11 0 5.45 1.00 3 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data536 9 0 6.67 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data537 9 0 5.56 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data538 9 0 4.44 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data539 9 0 5.56 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data57 10 0 4.00 1.00 4 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data571 9 0 3.33 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data572 9 0 3.33 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data573 9 0 3.33 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data574 9 0 4.44 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data575 9 0 3.33 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data576 9 0 5.56 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data590 9 0 2.22 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data591 9 0 2.22 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data592 13 0 3.08 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data593 9 0 3.33 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data594 9 0 4.44 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data595 9 0 3.33 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data596 9 0 4.44 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data597 9 0 3.33 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data74 10 0 2.00 1.00 1 0 0 0.00
CHN_RWD_IDX /dev/rcrm_data76 10 0 3.00 1.00 1 0 0 0.00
CIC_MOM_INDEX /dev/rcrm_data427 3 0 13.33 1.00 1 0 0 0.00
CIC_MOM_TABLE /dev/rcrm_data426 3 0 13.33 1.00 1 0 0 0.00
CRMMSG /dev/rcrm_data240 61,377 35 2.55 3.08 98 0 1,960 2.18
CRMMSG /dev/rcrm_data241 63,236 36 2.50 3.74 164 0 2,362 1.77
CRMMSG /dev/rcrm_data257 55,677 31 2.47 3.70 111 0 1,890 1.89
CRMMSG /dev/rcrm_data283 82,619 46 2.94 3.70 248 0 2,650 2.01
CRMMSG /dev/rcrm_data297 89,722 50 2.71 3.27 189 0 2,866 1.70
CRMMSG /dev/rcrm_data324 75,843 43 2.76 3.13 89 0 2,219 1.72
CRMMSG /dev/rcrm_data325 70,953 40 2.67 3.00 83 0 2,429 1.84
CRMMSG /dev/rcrm_data326 64,967 37 2.98 3.23 116 0 2,152 1.87
CRMMSG /dev/rcrm_data327 70,766 40 2.83 3.21 145 0 2,191 2.03
CRMMSG /dev/rcrm_data33 66,898 38 2.78 3.50 146 0 1,947 2.20
CRMMSG /dev/rcrm_data34 89,060 50 2.62 3.29 226 0 2,739 1.80
CRMMSG /dev/rcrm_data35 80,604 45 2.86 3.15 110 0 2,547 1.77
CRMMSG /dev/rcrm_data36 69,796 39 2.83 3.06 187 0 2,304 1.65
CRMMSG /dev/rcrm_data40 76,394 43 2.89 3.34 197 0 2,313 2.58
CRMMSG /dev/rcrm_data408 84,395 47 2.81 3.74 119 0 3,183 1.99
CRMMSG /dev/rcrm_data422 252,530 142 2.41 3.24 248 0 7,333 1.78
CRMMSG /dev/rcrm_data45 100,023 56 2.96 3.36 144 0 2,980 2.04
CRMMSG /dev/rcrm_data46 81,622 46 2.82 3.23 202 0 2,890 1.82
CRMMSG /dev/rcrm_data460 36,017 20 2.90 5.04 149 0 1,612 2.38
CRMMSG /dev/rcrm_data492 29,134 16 2.76 7.54 86 0 1,359 2.47
CRMMSG /dev/rcrm_data51 80,220 45 2.74 3.25 225 0 3,129 1.82
CRMMSG /dev/rcrm_data528 26,736 15 2.87 7.25 70 0 1,424 2.04
CRMMSG /dev/rcrm_data529 16,056 9 2.72 6.78 89 0 1,034 2.34
CRMMSG /dev/rcrm_data55 85,458 48 2.74 3.31 288 0 3,386 1.84
CRMMSG /dev/rcrm_data553 36,939 21 2.15 4.81 75 0 3,365 1.56
CRMMSG /dev/rcrm_data554 31,332 18 2.14 4.07 97 0 2,496 1.53
CRMMSG /dev/rcrm_data56 79,225 45 2.91 3.37 181 0 2,809 2.09
CRMMSG /dev/rcrm_data603 17,954 10 2.33 7.07 156 0 907 2.37
CRMMSG /dev/rcrm_data634 49,905 28 2.40 6.03 16 0 3,801 1.50
CRMMSG /dev/rcrm_data641 45,772 26 2.45 5.29 207 0 1,342 3.27
CRMMSG /dev/rcrm_data642 41,034 23 2.44 6.46 106 0 981 3.43
CRMMSG /dev/rcrm_data663 6,842 4 2.99 5.25 246 0 220 3.27
CRMMSG /dev/rcrm_data664 6,836 4 2.97 5.04 59 0 189 3.33
CRMMSG /dev/rcrm_data701 43,876 25 2.74 7.27 329 0 20,736 3.36
CRMMSG /dev/rcrm_data702 38,920 22 2.66 7.77 12 0 18,732 3.32
CRMMSG /dev/rcrm_data703 36,857 21 2.56 8.10 37 0 19,336 3.26
CRMMSG /dev/rcrm_data704 36,503 21 2.59 7.75 2 0 19,212 3.26
CRMMSG /dev/rcrm_data705 36,642 21 2.44 7.41 2 0 19,423 3.23
CRMMSG /dev/rcrm_data706 37,183 21 2.54 7.45 2 0 19,394 3.31
CRMMSG_IDX /dev/rcrm_data254 9,943 6 4.26 1.91 212 0 709 2.17
CRMMSG_IDX /dev/rcrm_data37 10,466 6 4.79 2.22 300 0 422 2.84
CRMMSG_IDX /dev/rcrm_data38 12,581 7 4.33 2.34 306 0 899 2.36
CRMMSG_IDX /dev/rcrm_data39 12,447 7 4.19 2.33 355 0 883 2.19
CRMMSG_IDX /dev/rcrm_data395 8,428 5 4.54 2.06 290 0 884 1.45
CRMMSG_IDX /dev/rcrm_data397 7,415 4 4.38 2.07 322 0 929 2.06
CRMMSG_IDX /dev/rcrm_data398 7,762 4 4.74 1.81 260 0 790 2.01
CRMMSG_IDX /dev/rcrm_data530 6,670 4 3.93 2.16 267 0 837 2.25
CRMMSG_IDX /dev/rcrm_data607 5,292 3 3.83 2.16 302 0 0 0.00
CRMMSG_IDX /dev/rcrm_data659 3,407 2 3.97 2.19 225 0 1 0.00
CRMMSG_IDX /dev/rcrm_data751 1,426 1 5.31 3.67 131 0 0 0.00
CRMMSG_IDX /dev/rcrm_data752 943 1 4.94 3.92 97 0 0 0.00
CRMMSG_IDX /dev/rcrm_data753 596 0 8.67 5.33 59 0 0 0.00
CRMMSG_IDX /dev/rcrm_data754 555 0 5.46 4.35 42 0 0 0.00
CTNGCFG_IDX /dev/rcrm_data86 331 0 2.08 1.00 134 0 0 0.00
CUSTHIS01 /dev/rcrm_data16 72 0 4.31 1.44 2 0 0 0.00
CUSTHIS01 /dev/rcrm_data17 97 0 3.40 1.31 5 0 0 0.00
CUSTHIS01 /dev/rcrm_data171 58 0 3.97 1.69 6 0 0 0.00
CUSTHIS01 /dev/rcrm_data829 26 0 6.15 3.88 9 0 0 0.00
CUSTHIS01 /dev/rcrm_data830 14 0 3.57 1.00 2 0 0 0.00
CUSTHIS01_IDX /dev/rcrm_data18 165 0 3.76 1.00 21 0 47 10.21
CUSTHIS01_IDX /dev/rcrm_data187 28 0 7.86 1.00 24 0 45 12.00
CUSTHIS01_IDX /dev/rcrm_data638 120 0 2.33 1.00 8 0 0 0.00
CUSTMNGCFG /dev/rcrm_data87 713 0 3.56 1.38 12 0 0 0.00
CUSTMSG01 /dev/rcrm_data166 9,029 5 3.88 11.99 183 0 3 16.67
CUSTMSG01 /dev/rcrm_data189 7,591 4 3.87 10.35 178 0 4 5.00
CUSTMSG01 /dev/rcrm_data19 12,119 7 5.10 3.52 389 0 138 7.39
CUSTMSG01 /dev/rcrm_data20 12,357 7 4.87 3.45 428 0 174 7.36
CUSTMSG01 /dev/rcrm_data21 12,904 7 4.96 4.26 336 0 211 5.17
CUSTMSG01 /dev/rcrm_data22 4,135 2 4.86 16.45 172 0 7 4.29
CUSTMSG01 /dev/rcrm_data248 2,264 1 5.08 16.02 161 0 9 0.00
CUSTMSG01 /dev/rcrm_data249 1,403 1 5.10 16.65 178 0 8 0.00
CUSTMSG01 /dev/rcrm_data252 2,015 1 4.65 16.36 192 0 5 6.00
CUSTMSG01 /dev/rcrm_data255 2,732 2 4.41 15.31 112 0 5 0.00
CUSTMSG01 /dev/rcrm_data269 5,956 3 4.78 13.18 137 0 2 10.00
CUSTMSG01 /dev/rcrm_data270 7,341 4 3.73 7.03 206 0 6 3.33
CUSTMSG01 /dev/rcrm_data271 8,191 5 3.18 6.43 318 0 6 5.00
CUSTMSG01 /dev/rcrm_data272 10,270 6 2.93 4.85 304 0 13 3.85
CUSTMSG01 /dev/rcrm_data276 6,189 3 4.13 18.05 617 0 1 0.00
CUSTMSG01 /dev/rcrm_data277 7,272 4 3.53 13.34 289 0 6 3.33
CUSTMSG01 /dev/rcrm_data278 6,648 4 3.67 11.76 239 0 1 10.00
CUSTMSG01 /dev/rcrm_data298 5,010 3 4.69 17.38 231 0 1 10.00
CUSTMSG01 /dev/rcrm_data332 5,234 3 3.16 10.04 122 0 0 0.00
CUSTMSG01 /dev/rcrm_data333 2,470 1 5.39 10.96 124 0 0 0.00
CUSTMSG01 /dev/rcrm_data334 2,282 1 5.60 11.86 140 0 0 0.00
CUSTMSG01 /dev/rcrm_data335 2,539 1 5.53 9.22 231 0 5 6.00
CUSTMSG01 /dev/rcrm_data343 2,332 1 4.49 19.46 41 0 10 7.00
CUSTMSG01 /dev/rcrm_data344 1,975 1 5.14 15.94 55 0 2 0.00
CUSTMSG01 /dev/rcrm_data345 3,127 2 4.15 19.10 147 0 3 3.33
CUSTMSG01 /dev/rcrm_data348 5,241 3 4.59 17.05 289 0 0 0.00
CUSTMSG01 /dev/rcrm_data349 4,599 3 5.40 12.31 295 0 4 2.50
CUSTMSG01 /dev/rcrm_data364 5,969 3 4.86 13.39 355 0 2 5.00
CUSTMSG01 /dev/rcrm_data365 4,569 3 4.93 15.66 220 0 1 10.00
CUSTMSG01 /dev/rcrm_data366 5,025 3 4.42 17.54 224 0 5 14.00
CUSTMSG01 /dev/rcrm_data372 3,156 2 5.23 14.95 175 0 11 5.45
CUSTMSG01 /dev/rcrm_data373 2,523 1 4.65 21.55 186 0 16 6.25
CUSTMSG01 /dev/rcrm_data374 3,530 2 5.18 14.33 140 0 9 10.00
CUSTMSG01 /dev/rcrm_data376 3,011 2 4.65 19.63 101 0 2 15.00
CUSTMSG01 /dev/rcrm_data377 3,622 2 4.49 20.84 191 0 0 0.00
CUSTMSG01 /dev/rcrm_data378 2,925 2 4.72 16.29 130 0 1 10.00
CUSTMSG01 /dev/rcrm_data379 3,677 2 4.23 18.46 107 0 0 0.00
CUSTMSG01 /dev/rcrm_data380 2,812 2 4.85 16.30 168 0 1 0.00
CUSTMSG01 /dev/rcrm_data381 4,273 2 4.02 22.25 81 0 4 5.00
CUSTMSG01 /dev/rcrm_data383 5,508 3 3.24 17.65 1,436 1 1 10.00
CUSTMSG01 /dev/rcrm_data425 6,626 4 2.75 16.40 73 0 0 0.00
CUSTMSG01 /dev/rcrm_data550 6,919 4 2.28 17.60 326 0 1 0.00
CUSTMSG01 /dev/rcrm_data561 5,649 3 2.49 18.79 207 0 0 0.00
CUSTMSG01 /dev/rcrm_data652 2,677 2 2.32 22.93 173 0 0 0.00
CUSTMSG01 /dev/rcrm_data671 939 1 4.79 21.14 134 0 10 1.00
CUSTMSG01 /dev/rcrm_data672 887 0 3.52 23.02 151 0 2 0.00
CUSTMSG01 /dev/rcrm_data725 97 0 8.76 18.24 15 0 0 0.00
CUSTMSG01 /dev/rcrm_data726 143 0 6.71 13.62 84 0 0 0.00
CUSTMSG01 /dev/rcrm_data727 81 0 10.37 23.22 2 0 0 0.00
CUSTMSG01 /dev/rcrm_data728 126 0 8.49 17.72 50 0 0 0.00
CUSTMSG01 /dev/rcrm_data729 97 0 9.59 26.15 10 0 0 0.00
CUSTMSG01 /dev/rcrm_data730 94 0 8.94 26.96 2 0 0 0.00
CUSTMSG01_IDX /dev/rcrm_data341 1,878 1 4.93 1.20 506 0 0 0.00
CUSTMSG01_IDX /dev/rcrm_data350 28,133 16 1.59 1.03 1,158 1 81 1.11
CUSTMSG01_IDX /dev/rcrm_data351 8,547 5 3.32 1.14 1,363 1 31 2.90
CUSTMSG01_IDX /dev/rcrm_data352 7,710 4 3.14 1.16 1,098 1 47 1.49
CUSTMSG01_IDX /dev/rcrm_data353 6,678 4 3.43 1.19 1,002 1 56 1.96
CUSTMSG01_IDX /dev/rcrm_data354 6,717 4 3.50 1.19 1,215 1 77 5.84
CUSTMSG01_IDX /dev/rcrm_data370 2,518 1 5.42 1.34 766 0 7 1.43
CUSTMSG01_IDX /dev/rcrm_data384 2,214 1 5.75 1.35 685 0 0 0.00
CUSTMSG01_IDX /dev/rcrm_data400 2,337 1 5.27 1.24 621 0 9 7.78
CUSTMSG01_IDX /dev/rcrm_data403 1,273 1 6.09 1.29 450 0 9 15.56
CUSTMSG01_IDX /dev/rcrm_data406 2,109 1 5.84 1.32 756 0 1 0.00
CUSTMSG01_IDX /dev/rcrm_data414 890 1 6.06 1.36 380 0 0 0.00
CUSTMSG01_IDX /dev/rcrm_data462 2,439 1 4.83 1.24 662 0 3 0.00
CUSTMSG01_IDX /dev/rcrm_data484 2,138 1 4.61 1.15 693 0 43 1.63
CUSTMSG01_IDX /dev/rcrm_data485 2,063 1 5.03 1.28 817 0 39 2.82
CUSTMSG01_IDX /dev/rcrm_data548 2,729 2 4.87 1.30 1,163 1 20 2.00
CUSTMSG01_IDX /dev/rcrm_data559 3,133 2 5.80 1.34 1,769 1 38 0.53
CUSTMSG01_IDX /dev/rcrm_data560 2,820 2 5.98 1.47 1,701 1 0 0.00
CUSTMSG01_IDX /dev/rcrm_data650 1,272 1 6.64 2.04 1,099 1 0 0.00
CUSTMSG01_IDX /dev/rcrm_data651 1,537 1 6.28 1.80 1,408 1 0 0.00
CUSTMSG01_IDX /dev/rcrm_data713 1,504 1 4.41 1.17 1,510 1 0 0.00
CUSTMSG01_IDX /dev/rcrm_data714 946 1 5.32 1.26 780 0 0 0.00
CUSTMSG01_IDX /dev/rcrm_data715 472 0 4.77 1.00 293 0 0 0.00
CUSTMSG01_IDX /dev/rcrm_data716 541 0 4.40 1.00 303 0 0 0.00
CUSTMSG01_IDX /dev/rcrm_data717 318 0 6.79 1.00 297 0 0 0.00
CUSTMSG01_IDX /dev/rcrm_data718 298 0 6.48 1.00 275 0 0 0.00
CUSTMSG02 /dev/rcrm_data111 7 0 5.71 1.00 2 0 0 0.00
CUSTMSG02 /dev/rcrm_data112 7 0 5.71 1.00 2 0 0 0.00
CUSTMSG02 /dev/rcrm_data113 7 0 5.71 1.00 2 0 0 0.00
CUSTMSG02 /dev/rcrm_data114 7 0 5.71 1.00 2 0 0 0.00
CUSTMSG02 /dev/rcrm_data115 7 0 5.71 1.00 2 0 0 0.00
CUSTMSG02 /dev/rcrm_data116 398 0 5.03 5.05 211 0 491 0.88
CUSTMSG02 /dev/rcrm_data117 721 0 4.51 6.13 146 0 2,040 0.93
CUSTMSG02 /dev/rcrm_data118 411 0 5.52 6.40 255 0 512 1.05
CUSTMSG02 /dev/rcrm_data119 513 0 3.14 3.16 148 0 524 0.90
CUSTMSG02 /dev/rcrm_data120 4,946 3 3.81 5.03 2,183 1 22,838 0.87
CUSTMSG02 /dev/rcrm_data170 4,255 2 3.76 5.94 2,782 2 1,650 0.90
CUSTMSG02 /dev/rcrm_data217 5,948 3 3.69 4.93 2,194 1 660 1.11
CUSTMSG02 /dev/rcrm_data23 11,212 6 3.82 2.38 1,863 1 11,602 1.36
CUSTMSG02 /dev/rcrm_data24 11,006 6 3.51 2.46 1,944 1 4,891 1.05
CUSTMSG02 /dev/rcrm_data256 3,881 2 3.24 5.22 1,942 1 533 1.16
CUSTMSG02 /dev/rcrm_data282 6,364 4 3.44 4.72 2,918 2 314 1.15
CUSTMSG02 /dev/rcrm_data292 6,457 4 3.09 4.47 2,462 1 30 2.67
CUSTMSG02 /dev/rcrm_data293 6,744 4 3.15 4.21 2,402 1 266 1.20
CUSTMSG02 /dev/rcrm_data436 4,100 2 2.59 4.65 2,195 1 21 2.38
CUSTMSG02 /dev/rcrm_data458 2,323 1 3.29 7.47 1,391 1 7 4.29
CUSTMSG02 /dev/rcrm_data524 3,103 2 3.58 7.18 1,173 1 4,764 1.15
CUSTMSG02 /dev/rcrm_data525 2,444 1 3.62 5.73 608 0 725 1.38
CUSTMSG02 /dev/rcrm_data526 1,956 1 3.67 6.90 802 0 5,059 1.55
CUSTMSG02 /dev/rcrm_data648 28,145 16 3.04 19.13 1,379 1 150 5.00
CUSTMSG02 /dev/rcrm_data649 27,151 15 3.14 19.14 289 0 169 5.68
CUSTMSG02 /dev/rcrm_data657 25,163 14 3.31 20.13 142 0 201 5.07
CUSTMSG02 /dev/rcrm_data658 26,189 15 3.00 20.20 151 0 198 3.43
CUSTMSG02 /dev/rcrm_data683 695 0 5.35 25.46 121 0 141 6.67
CUSTMSG02 /dev/rcrm_data684 671 0 6.07 26.18 9 0 141 6.60
CUSTMSG02 /dev/rcrm_data685 760 0 4.75 23.14 90 0 143 4.83
CUSTMSG02 /dev/rcrm_data686 748 0 4.02 23.43 59 0 140 4.00
CUSTMSG02 /dev/rcrm_data687 1,123 1 3.40 22.78 1 0 200 4.35
CUSTMSG02 /dev/rcrm_data688 1,156 1 2.91 22.12 1 0 214 3.79
CUSTMSG02 /dev/rcrm_data78 7 0 5.71 1.00 2 0 0 0.00
CUSTMSG02 /dev/rcrm_data79 7 0 5.71 1.00 2 0 0 0.00
CUSTMSG02 /dev/rcrm_data80 7 0 5.71 1.00 2 0 0 0.00
CUSTMSG02_IDX /dev/rcrm_data194 7,233 4 5.80 1.01 1,089 1 230 2.83
CUSTMSG02_IDX /dev/rcrm_data225 4,355 2 5.99 1.00 444 0 132 1.14
CUSTMSG02_IDX /dev/rcrm_data25 10,689 6 6.01 1.00 847 0 324 1.33
CUSTMSG02_IDX /dev/rcrm_data291 6,727 4 5.97 1.00 902 1 128 1.48
CUSTMSG02_IDX /dev/rcrm_data415 3,626 2 5.75 1.00 417 0 6 8.33
CUSTMSG02_IDX /dev/rcrm_data431 4,104 2 5.93 1.00 1,028 1 29 7.93
CUSTMSG02_IDX /dev/rcrm_data459 2,331 1 6.04 1.00 335 0 1 10.00
CUSTMSG02_IDX /dev/rcrm_data598 2,336 1 6.01 1.00 957 1 19 5.79
CUSTMSG02_IDX /dev/rcrm_data599 1,981 1 6.14 1.00 671 0 6 5.00
CUSTMSG02_IDX /dev/rcrm_data707 182 0 6.70 1.00 125 0 1 0.00
CUSTMSG02_IDX /dev/rcrm_data708 18 0 6.67 1.00 7 0 0 0.00
CUSTMSG02_IDX /dev/rcrm_data709 17 0 7.06 1.00 10 0 0 0.00
CUSTMSG02_IDX /dev/rcrm_data71 7,766 4 5.84 1.01 1,351 1 329 3.28
CUSTMSG02_IDX /dev/rcrm_data710 8 0 8.75 1.00 2 0 0 0.00
CUSTMSG02_IDX /dev/rcrm_data711 7 0 7.14 1.00 2 0 0 0.00
CUSTMSG02_IDX /dev/rcrm_data712 7 0 7.14 1.00 2 0 0 0.00
CUSTMSG03 /dev/rcrm_data124 13,690 8 6.09 2.33 1,188 1 65 1.85
CUSTMSG03 /dev/rcrm_data157 10,668 6 5.67 2.04 690 0 54 2.04
CUSTMSG03 /dev/rcrm_data161 12,009 7 5.36 2.47 398 0 217 1.06
CUSTMSG03 /dev/rcrm_data162 12,890 7 5.86 2.52 460 0 120 1.33
CUSTMSG03 /dev/rcrm_data167 12,432 7 5.90 2.48 1,069 1 128 2.89
CUSTMSG03 /dev/rcrm_data175 15,016 8 5.68 2.58 656 0 167 2.46
CUSTMSG03 /dev/rcrm_data176 15,096 8 5.34 2.34 742 0 57 3.16
CUSTMSG03 /dev/rcrm_data180 11,622 7 5.88 2.85 634 0 58 5.34
CUSTMSG03 /dev/rcrm_data186 11,328 6 5.60 2.78 558 0 43 4.88
CUSTMSG03 /dev/rcrm_data192 11,717 7 5.54 2.84 458 0 110 3.55
CUSTMSG03 /dev/rcrm_data193 11,347 6 6.14 3.12 594 0 125 3.52
CUSTMSG03 /dev/rcrm_data218 11,441 6 5.54 2.93 373 0 84 1.31
CUSTMSG03 /dev/rcrm_data219 12,559 7 5.82 2.65 358 0 128 2.81
CUSTMSG03 /dev/rcrm_data220 11,488 6 5.73 3.09 384 0 65 3.08
CUSTMSG03 /dev/rcrm_data238 8,354 5 5.27 3.74 250 0 24 5.00
CUSTMSG03 /dev/rcrm_data26 39,210 22 4.38 2.74 2,622 1 332 1.66
CUSTMSG03 /dev/rcrm_data263 11,822 7 5.75 3.32 413 0 66 4.09
CUSTMSG03 /dev/rcrm_data27 40,114 23 4.39 2.66 2,577 1 412 1.82
CUSTMSG03 /dev/rcrm_data273 14,340 8 5.58 2.80 363 0 57 2.81
CUSTMSG03 /dev/rcrm_data274 12,674 7 5.85 2.74 421 0 7 2.86
CUSTMSG03 /dev/rcrm_data275 13,339 8 6.06 2.41 401 0 49 4.08
CUSTMSG03 /dev/rcrm_data28 36,349 20 4.74 2.78 2,434 1 386 1.94
CUSTMSG03 /dev/rcrm_data296 8,791 5 6.41 3.38 365 0 7 1.43
CUSTMSG03 /dev/rcrm_data359 14,161 8 5.56 2.53 635 0 75 3.07
CUSTMSG03 /dev/rcrm_data367 10,906 6 5.50 3.32 548 0 17 3.53
CUSTMSG03 /dev/rcrm_data371 17,479 10 4.48 2.12 685 0 8 2.50
CUSTMSG03 /dev/rcrm_data41 14,232 8 5.22 2.09 895 1 14 2.14
CUSTMSG03 /dev/rcrm_data42 14,810 8 5.54 2.26 811 0 191 1.41
CUSTMSG03 /dev/rcrm_data43 14,070 8 5.80 2.30 687 0 277 2.49
CUSTMSG03 /dev/rcrm_data44 15,577 9 5.57 2.12 950 1 240 1.58
CUSTMSG03 /dev/rcrm_data48 13,047 7 5.36 2.11 704 0 25 2.00
CUSTMSG03 /dev/rcrm_data488 8,891 5 5.26 2.01 390 0 28 2.86
CUSTMSG03 /dev/rcrm_data49 13,912 8 5.70 2.33 596 0 60 3.67
CUSTMSG03 /dev/rcrm_data532 15,843 9 5.07 2.04 445 0 24 1.25
CUSTMSG03 /dev/rcrm_data558 9,082 5 5.80 1.90 331 0 85 2.00
CUSTMSG03 /dev/rcrm_data59 17,603 10 6.17 2.51 498 0 149 2.08
CUSTMSG03 /dev/rcrm_data608 9,234 5 5.58 1.92 421 0 3 0.00
CUSTMSG03 /dev/rcrm_data609 6,413 4 7.04 2.52 247 0 1 0.00
CUSTMSG03 /dev/rcrm_data62 15,053 8 5.58 2.05 1,011 1 1,580 1.99
CUSTMSG03 /dev/rcrm_data63 11,628 7 5.01 2.32 295 0 44 2.05
CUSTMSG03 /dev/rcrm_data64 14,565 8 5.73 2.25 478 0 96 1.77
CUSTMSG03 /dev/rcrm_data647 10,520 6 3.53 1.58 440 0 0 0.00
CUSTMSG03 /dev/rcrm_data66 12,995 7 5.24 2.57 382 0 216 1.02
CUSTMSG03 /dev/rcrm_data665 2,571 1 3.16 1.56 446 0 0 0.00
CUSTMSG03 /dev/rcrm_data67 13,106 7 5.59 2.25 1,192 1 37 2.16
CUSTMSG03 /dev/rcrm_data670 6,630 4 3.62 1.79 883 0 27 1.11
CUSTMSG03 /dev/rcrm_data675 3,124 2 4.97 1.79 589 0 3 0.00
CUSTMSG03 /dev/rcrm_data676 1,274 1 6.73 1.47 339 0 0 0.00
CUSTMSG03 /dev/rcrm_data677 1,706 1 7.47 2.66 450 0 1 0.00
CUSTMSG03 /dev/rcrm_data678 2,469 1 4.61 1.76 445 0 0 0.00
CUSTMSG03 /dev/rcrm_data679 518 0 6.78 2.92 73 0 0 0.00
CUSTMSG03 /dev/rcrm_data680 106 0 5.66 6.26 124 0 0 0.00
CUSTMSG03 /dev/rcrm_data681 136 0 7.21 7.38 3 0 0 0.00
CUSTMSG03 /dev/rcrm_data682 104 0 6.25 4.28 69 0 0 0.00
CUSTMSG03_IDX /dev/rcrm_data160 12,905 7 4.09 1.03 4,944 3 252 1.39
CUSTMSG03_IDX /dev/rcrm_data169 10,776 6 4.45 1.02 4,113 2 295 2.03
CUSTMSG03_IDX /dev/rcrm_data177 11,485 6 4.58 1.03 4,526 3 130 1.54
CUSTMSG03_IDX /dev/rcrm_data230 9,309 5 4.59 1.02 5,653 3 400 3.03
CUSTMSG03_IDX /dev/rcrm_data239 9,624 5 4.47 1.00 6,718 4 159 1.57
CUSTMSG03_IDX /dev/rcrm_data264 12,719 7 4.23 1.02 9,949 6 239 0.75
CUSTMSG03_IDX /dev/rcrm_data285 12,287 7 4.43 1.00 8,490 5 211 5.50
CUSTMSG03_IDX /dev/rcrm_data29 16,426 9 4.48 1.11 4,255 2 291 1.62
CUSTMSG03_IDX /dev/rcrm_data294 11,937 7 4.52 1.00 7,510 4 129 2.64
CUSTMSG03_IDX /dev/rcrm_data342 10,404 6 4.18 1.00 7,130 4 565 3.08
CUSTMSG03_IDX /dev/rcrm_data396 9,333 5 4.41 1.00 5,443 3 458 4.15
CUSTMSG03_IDX /dev/rcrm_data413 8,986 5 4.18 1.00 4,741 3 435 0.78
CUSTMSG03_IDX /dev/rcrm_data429 4,914 3 4.85 1.00 1,353 1 225 1.38
CUSTMSG03_IDX /dev/rcrm_data433 5,917 3 4.43 1.00 1,820 1 315 1.11
CUSTMSG03_IDX /dev/rcrm_data457 5,248 3 4.99 1.00 1,400 1 240 1.00
CUSTMSG03_IDX /dev/rcrm_data47 14,062 8 4.29 1.07 4,694 3 371 1.19
CUSTMSG03_IDX /dev/rcrm_data486 5,799 3 4.98 1.00 456 0 69 1.01
CUSTMSG03_IDX /dev/rcrm_data487 6,175 3 4.64 1.00 322 0 78 2.56
CUSTMSG03_IDX /dev/rcrm_data499 4,301 2 5.24 1.00 670 0 17 177.06
CUSTMSG03_IDX /dev/rcrm_data551 5,637 3 4.88 1.00 772 0 38 0.26
CUSTMSG03_IDX /dev/rcrm_data552 5,944 3 4.94 1.00 1,199 1 30 0.67
CUSTMSG03_IDX /dev/rcrm_data556 4,466 3 5.58 1.00 1,149 1 111 0.36
CUSTMSG03_IDX /dev/rcrm_data557 3,348 2 5.17 1.00 738 0 101 0.79
CUSTMSG03_IDX /dev/rcrm_data719 266 0 6.39 1.00 389 0 0 0.00
CUSTMSG03_IDX /dev/rcrm_data720 32 0 6.88 1.00 10 0 0 0.00
CUSTMSG03_IDX /dev/rcrm_data721 10 0 7.00 1.00 4 0 0 0.00
CUSTMSG03_IDX /dev/rcrm_data722 38 0 8.16 1.00 19 0 0 0.00
CUSTMSG03_IDX /dev/rcrm_data723 84 0 7.02 1.00 73 0 4 0.00
CUSTMSG03_IDX /dev/rcrm_data724 7 0 4.29 1.00 2 0 0 0.00
CUSTMSG03_IDX /dev/rcrm_data89 13,524 8 3.92 1.08 4,272 2 403 3.62
CUSTRES01 /dev/rcrm_data174 15,760 9 2.94 1.73 158 0 1,859 1.61
CUSTRES01 /dev/rcrm_data30 107,477 60 1.31 1.30 494 0 3,855 0.96
CUSTRES01 /dev/rcrm_data309 9,845 6 2.63 1.34 137 0 922 1.79
CUSTRES01 /dev/rcrm_data358 10,579 6 4.56 2.75 71 0 943 1.70
CUSTRES01 /dev/rcrm_data405 9,964 6 2.43 1.65 83 0 733 1.77
CUSTRES01 /dev/rcrm_data434 1,622 1 5.02 1.73 48 0 304 1.88
CUSTRES01 /dev/rcrm_data450 9,221 5 2.92 1.25 239 0 447 1.74
CUSTRES01 /dev/rcrm_data461 23,272 13 2.52 1.60 341 0 1,033 1.55
CUSTRES01 /dev/rcrm_data604 17,373 10 4.29 2.02 564 0 9 2.22
CUSTRES01 /dev/rcrm_data605 13,460 8 4.34 2.16 402 0 70 1.43
CUSTRES01 /dev/rcrm_data661 3,891 2 4.75 4.51 385 0 65 2.31
CUSTRES01 /dev/rcrm_data755 439 0 5.97 4.40 58 0 0 0.00
CUSTRES01 /dev/rcrm_data756 490 0 6.00 2.49 2 0 0 0.00
CUSTRES01 /dev/rcrm_data757 159 0 10.50 5.60 2 0 0 0.00
CUSTRES01 /dev/rcrm_data758 159 0 4.78 5.60 2 0 0 0.00
CUSTRES02 /dev/rcrm_data224 724 0 6.96 1.02 74 0 0 0.00
CUSTRES02 /dev/rcrm_data412 432 0 6.90 1.00 141 0 2 0.00
CUSTRES02 /dev/rcrm_data514 318 0 6.38 1.00 295 0 0 0.00
CUSTRES02 /dev/rcrm_data827 57 0 5.44 1.00 100 0 1 0.00
CUSTRES02 /dev/rcrm_data828 21 0 5.71 1.00 15 0 0 0.00
CUSTRES02 /dev/rcrm_data91 2,243 1 5.94 1.05 67 0 1 40.00
CUSTRES_IDX /dev/rcrm_data221 8,197 5 2.93 1.00 133 0 0 0.00
CUSTRES_IDX /dev/rcrm_data339 9,062 5 3.04 1.00 208 0 2 10.00
CUSTRES_IDX /dev/rcrm_data416 10,848 6 3.04 1.00 461 0 0 0.00
CUSTRES_IDX /dev/rcrm_data531 10,091 6 4.79 1.00 2,265 1 2 5.00
CUSTRES_IDX /dev/rcrm_data660 1,183 1 6.29 1.00 970 1 0 0.00
CUSTRES_IDX /dev/rcrm_data759 76 0 5.79 1.00 67 0 0 0.00
CUSTRES_IDX /dev/rcrm_data760 64 0 6.09 1.00 63 0 0 0.00
CUSTRES_IDX /dev/rcrm_data761 92 0 6.30 1.00 80 0 0 0.00
CUSTRES_IDX /dev/rcrm_data762 77 0 6.10 1.00 72 0 0 0.00
CUSTRES_IDX /dev/rcrm_data90 7,712 4 4.61 1.00 59 0 1 0.00
INTERFACE /dev/rcrm_data673 2,913 2 0.57 1.00 503 0 0 0.00
INTERFACE /dev/rcrm_data674 3,103 2 0.56 1.00 449 0 0 0.00
INTERFACE /dev/rcrm_data92 3,203 2 0.69 1.00 448 0 0 0.00
OFFON01 /dev/rcrm_data179 446 0 7.26 18.57 58 0 1,238 0.93
OFFON01 /dev/rcrm_data211 606 0 5.28 17.27 249 0 119 0.25
OFFON01 /dev/rcrm_data235 279 0 5.52 11.12 149 0 221 0.63
OFFON01 /dev/rcrm_data284 583 0 4.60 18.21 134 0 1,548 0.87
OFFON01 /dev/rcrm_data317 237 0 5.49 11.22 219 0 316 0.70
OFFON01 /dev/rcrm_data401 549 0 4.37 17.21 149 0 465 0.86
OFFON01 /dev/rcrm_data72 491 0 4.64 21.61 89 0 9 0.00
OFFON01 /dev/rcrm_data747 9 0 2.22 1.00 2 0 0 0.00
OFFON01 /dev/rcrm_data748 8 0 3.75 1.00 2 0 0 0.00
OFFON01 /dev/rcrm_data749 8 0 2.50 1.00 2 0 0 0.00
OFFON01 /dev/rcrm_data750 8 0 2.50 1.00 2 0 0 0.00
OFFON01 /dev/rcrm_data93 851 0 4.07 4.00 63 0 124 0.56
OFFON01_IDX /dev/rcrm_data222 1,032 1 5.39 1.00 722 0 353 0.54
OFFON01_IDX /dev/rcrm_data234 1,023 1 5.69 1.00 856 0 4,081 0.71
OFFON01_IDX /dev/rcrm_data319 888 0 5.70 1.00 768 0 442 0.52
OFFON01_IDX /dev/rcrm_data825 14 0 4.29 1.00 3 0 0 0.00
OFFON01_IDX /dev/rcrm_data826 29 0 5.86 1.00 28 0 0 0.00
OFFON01_IDX /dev/rcrm_data94 1,834 1 4.82 1.00 878 0 2,761 0.70
OFFON01_IDX /dev/rcrm_date199 1,033 1 5.25 1.00 703 0 319 0.66
OFFON02 /dev/rcrm_data172 85 0 6.35 11.80 19 0 39 0.77
OFFON02 /dev/rcrm_data202 156 0 7.56 18.60 25 0 234 1.11
OFFON02 /dev/rcrm_data233 109 0 4.68 1.79 1 0 0 0.00
OFFON02 /dev/rcrm_data290 159 0 7.55 11.19 39 0 3 0.00
OFFON02 /dev/rcrm_data318 87 0 6.55 7.60 36 0 31 4.52
OFFON02 /dev/rcrm_data423 556 0 8.83 14.15 13 0 5 0.00
OFFON02 /dev/rcrm_data430 591 0 8.56 19.70 1 0 0 0.00
OFFON02 /dev/rcrm_data478 1,410 1 9.10 20.74 45 0 5 0.00
OFFON02 /dev/rcrm_data493 2,960 2 8.38 20.70 23 0 3 0.00
OFFON02 /dev/rcrm_data494 2,324 1 8.63 19.10 23 0 0 0.00
OFFON02 /dev/rcrm_data606 4,552 3 8.71 19.64 1 0 0 0.00
OFFON02 /dev/rcrm_data635 6,288 4 8.74 19.23 15 0 0 0.00
OFFON02 /dev/rcrm_data636 5,765 3 8.55 19.43 89 0 0 0.00
OFFON02 /dev/rcrm_data654 4,384 2 8.93 16.64 31 0 0 0.00
OFFON02 /dev/rcrm_data655 4,335 2 8.78 16.25 23 0 0 0.00
OFFON02 /dev/rcrm_data656 4,451 3 8.70 16.37 122 0 3 0.00
OFFON02 /dev/rcrm_data69 121 0 5.95 11.32 40 0 111 0.54
OFFON02 /dev/rcrm_data737 1,054 1 7.17 17.06 9 0 0 0.00
OFFON02 /dev/rcrm_data738 1,153 1 8.62 16.28 8 0 0 0.00
OFFON02 /dev/rcrm_data739 1,395 1 7.72 13.81 223 0 0 0.00
OFFON02 /dev/rcrm_data740 951 1 9.31 14.80 106 0 0 0.00
OFFON02 /dev/rcrm_data741 874 0 9.85 14.93 33 0 0 0.00
OFFON02 /dev/rcrm_data742 798 0 10.00 15.12 2 0 0 0.00
OFFON02 /dev/rcrm_data95 266 0 5.75 5.41 3 0 0 0.00
OFFON02_IDX /dev/rcrm_data158 50 0 5.20 1.00 4 0 0 0.00
OFFON02_IDX /dev/rcrm_data164 477 0 4.99 1.00 184 0 694 0.72
OFFON02_IDX /dev/rcrm_data190 558 0 5.25 1.00 247 0 151 0.46
OFFON02_IDX /dev/rcrm_data232 519 0 4.26 1.00 165 0 0 0.00
OFFON02_IDX /dev/rcrm_data288 841 0 4.89 1.00 325 0 117 0.60
OFFON02_IDX /dev/rcrm_data435 788 0 5.23 1.00 397 0 2 10.00
OFFON02_IDX /dev/rcrm_data479 1,563 1 5.01 1.00 469 0 1 10.00
OFFON02_IDX /dev/rcrm_data495 2,167 1 4.50 1.01 842 0 169 4.73
OFFON02_IDX /dev/rcrm_data600 2,586 1 5.77 1.00 1,748 1 1 0.00
OFFON02_IDX /dev/rcrm_data601 2,651 1 5.42 1.00 2,043 1 0 0.00
OFFON02_IDX /dev/rcrm_data602 2,425 1 5.72 1.00 1,714 1 0 0.00
OFFON02_IDX /dev/rcrm_data731 1,229 1 6.86 1.00 1,309 1 1 0.00
OFFON02_IDX /dev/rcrm_data732 1,037 1 6.94 1.00 1,092 1 0 0.00
OFFON02_IDX /dev/rcrm_data733 1,095 1 6.50 1.00 1,214 1 0 0.00
OFFON02_IDX /dev/rcrm_data734 1,173 1 6.88 1.00 1,220 1 0 0.00
OFFON02_IDX /dev/rcrm_data735 1,251 1 6.20 1.00 1,399 1 0 0.00
OFFON02_IDX /dev/rcrm_data736 1,167 1 6.76 1.00 1,302 1 0 0.00
OFFON02_IDX /dev/rcrm_data96 432 0 4.72 1.00 143 0 0 0.00
OFFONHIS01 /dev/rcrm_data97 700 0 3.61 1.00 2 0 0 0.00
OFFONHIS01_IDX /dev/rcrm_data201 2,435 1 4.87 1.00 1,685 1 0 0.00
OFFONHIS01_IDX /dev/rcrm_data662 2,098 1 4.66 1.00 1,880 1 13 0.00
OFFONHIS01_IDX /dev/rcrm_data823 1,150 1 5.19 1.00 1,153 1 0 0.00
OFFONHIS01_IDX /dev/rcrm_data824 1,059 1 5.39 1.00 959 1 0 0.00
OFFONHIS01_IDX /dev/rcrm_data98 3,309 2 5.27 1.00 1,270 1 0 0.00
OFFONHIS02 /dev/rcrm_data99 561 0 5.06 1.00 2 0 0 0.00
OFFONHIS02_IDX /dev/rcrm_data100 1,512 1 2.99 1.00 2 0 0 0.00
PERFSTAT /dev/rcrm_data110 10 0 5.00 1.00 2 0 0 0.00
SERVERDESK_DATA01 /dev/rcrm_data163 2,132 1 1.69 1.91 224 0 6 1.67
SERVERDESK_DATA01 /dev/rcrm_data173 5,916 3 1.59 1.40 305 0 43 1.16
SERVERDESK_DATA01 /dev/rcrm_data178 2,689 2 2.31 2.17 386 0 7 1.43
SERVERDESK_DATA01 /dev/rcrm_data191 2,837 2 1.66 1.91 226 0 8 0.00
SERVERDESK_DATA01 /dev/rcrm_data208 4,468 3 2.50 2.12 258 0 54 1.11
SERVERDESK_DATA01 /dev/rcrm_data212 1,969 1 1.75 1.81 180 0 0 0.00
SERVERDESK_DATA01 /dev/rcrm_data213 1,646 1 2.25 1.80 183 0 7 0.00
SERVERDESK_DATA01 /dev/rcrm_data242 1,106 1 1.96 2.50 217 0 99 2.02
SERVERDESK_DATA01 /dev/rcrm_data243 881 0 2.58 2.78 169 0 132 2.05
SERVERDESK_DATA01 /dev/rcrm_data265 4,244 2 1.59 1.64 284 0 10 1.00
SERVERDESK_DATA01 /dev/rcrm_data279 2,301 1 2.05 5.39 196 0 904 0.88
SERVERDESK_DATA01 /dev/rcrm_data280 1,296 1 2.50 5.84 144 0 119 1.26
SERVERDESK_DATA01 /dev/rcrm_data281 938 1 2.51 6.81 75 0 78 1.79
SERVERDESK_DATA01 /dev/rcrm_data295 2,487 1 1.63 3.16 42 0 34 0.88
SERVERDESK_DATA01 /dev/rcrm_data32 58,622 33 0.95 1.08 2,314 1 219 1.28
SERVERDESK_DATA01 /dev/rcrm_data389 2,321 1 1.71 3.55 151 0 25 0.40
SERVERDESK_DATA01 /dev/rcrm_data390 1,292 1 2.85 5.49 357 0 264 1.36
SERVERDESK_DATA01 /dev/rcrm_data424 1,740 1 1.70 4.36 60 0 641 1.78
SERVERDESK_DATA01 /dev/rcrm_data463 2,417 1 2.05 3.44 37 0 44 1.14
SERVERDESK_DATA01 /dev/rcrm_data491 27,566 16 1.25 1.43 561 0 30 2.00
SERVERDESK_DATA01 /dev/rcrm_data50 6,050 3 1.65 4.24 494 0 3 0.00
SERVERDESK_DATA01 /dev/rcrm_data522 27,565 16 1.19 1.29 714 0 0 0.00
SERVERDESK_DATA01 /dev/rcrm_data523 27,450 15 1.40 1.33 912 1 0 0.00
SERVERDESK_DATA01 /dev/rcrm_data549 738 0 3.13 10.56 676 0 17 5.88
SERVERDESK_DATA01 /dev/rcrm_data60 1,683,181 947 0.46 1.00 1,554 1 39 1.03
SERVERDESK_DATA01 /dev/rcrm_data61 1,503,050 845 0.45 1.00 1,443 1 29 0.34
SERVERDESK_DATA01 /dev/rcrm_data639 994 1 2.48 17.76 528 0 1 0.00
SERVERDESK_DATA01 /dev/rcrm_data644 1,163 1 3.84 12.33 1,106 1 304 0.76
SERVERDESK_DATA01 /dev/rcrm_data645 367 0 3.98 25.01 147 0 2 5.00
SERVERDESK_DATA01 /dev/rcrm_data65 5,135 3 1.63 4.50 398 0 12 0.00
SERVERDESK_DATA01 /dev/rcrm_data689 121 0 5.79 1.00 174 0 67 0.15
SERVERDESK_DATA01 /dev/rcrm_data690 141 0 5.89 1.00 210 0 50 1.00
SERVERDESK_DATA01 /dev/rcrm_data691 157 0 6.43 1.04 251 0 53 0.57
SERVERDESK_DATA01 /dev/rcrm_data692 332 0 5.78 1.00 393 0 17 2.94
SERVERDESK_DATA01 /dev/rcrm_data693 169 0 5.56 1.00 432 0 331 0.85
SERVERDESK_DATA01 /dev/rcrm_data694 109 0 6.97 1.00 203 0 270 0.78
SERVERDESK_IDX01 /dev/rcrm_data142 4,944 3 2.73 1.00 1,026 1 46 2.61
SERVERDESK_IDX01 /dev/rcrm_data155 3,072 2 2.69 1.00 615 0 11 10.00
SERVERDESK_IDX01 /dev/rcrm_data156 2,029 1 3.25 1.00 613 0 51 2.75
SERVERDESK_IDX01 /dev/rcrm_data168 7,960 4 1.80 1.00 527 0 9 3.33
SERVERDESK_IDX01 /dev/rcrm_data188 6,649 4 2.03 1.00 856 0 78 4.62
SERVERDESK_IDX01 /dev/rcrm_data195 6,840 4 2.02 1.00 798 0 52 4.81
SERVERDESK_IDX01 /dev/rcrm_data210 7,211 4 2.23 1.00 947 1 26 3.85
SERVERDESK_IDX01 /dev/rcrm_data231 5,600 3 1.85 1.00 344 0 103 4.08
SERVERDESK_IDX01 /dev/rcrm_data261 6,984 4 2.11 1.00 661 0 42 4.29
SERVERDESK_IDX01 /dev/rcrm_data262 7,438 4 2.32 1.00 1,120 1 205 1.61
SERVERDESK_IDX01 /dev/rcrm_data289 6,949 4 1.93 1.00 442 0 41 3.90
SERVERDESK_IDX01 /dev/rcrm_data316 1,095 1 3.61 1.01 309 0 26 6.15
SERVERDESK_IDX01 /dev/rcrm_data328 6,050 3 1.75 1.00 379 0 21 6.67
SERVERDESK_IDX01 /dev/rcrm_data329 4,982 3 1.72 1.00 348 0 334 0.63
SERVERDESK_IDX01 /dev/rcrm_data330 5,946 3 1.64 1.00 296 0 88 6.82
SERVERDESK_IDX01 /dev/rcrm_data331 8,056 5 1.74 1.00 530 0 13 0.77
SERVERDESK_IDX01 /dev/rcrm_data340 3,323 2 2.11 1.00 389 0 37 3.51
SERVERDESK_IDX01 /dev/rcrm_data368 8,565 5 1.80 1.00 516 0 34 3.24
SERVERDESK_IDX01 /dev/rcrm_data375 7,196 4 2.19 1.00 918 1 26 4.62
SERVERDESK_IDX01 /dev/rcrm_data382 7,326 4 1.70 1.00 557 0 13 3.85
SERVERDESK_IDX01 /dev/rcrm_data385 7,259 4 1.72 1.00 592 0 187 4.55
SERVERDESK_IDX01 /dev/rcrm_data388 6,861 4 1.56 1.00 345 0 60 7.00
SERVERDESK_IDX01 /dev/rcrm_data428 7,065 4 1.84 1.00 731 0 54 5.74
SERVERDESK_IDX01 /dev/rcrm_data489 6,283 4 1.68 1.00 402 0 135 5.19
SERVERDESK_IDX01 /dev/rcrm_data490 7,085 4 1.91 1.01 489 0 56 5.18
SERVERDESK_IDX01 /dev/rcrm_data527 7,620 4 1.68 1.01 451 0 41 5.37
SERVERDESK_IDX01 /dev/rcrm_data555 706 0 6.35 1.00 659 0 26 6.54
SERVERDESK_IDX01 /dev/rcrm_data58 8,474 5 1.93 1.00 1,090 1 82 4.88
SERVERDESK_IDX01 /dev/rcrm_data637 763 0 6.54 1.00 689 0 106 6.23
SERVERDESK_IDX01 /dev/rcrm_data695 333 0 6.58 1.00 333 0 71 6.62
SERVERDESK_IDX01 /dev/rcrm_data696 323 0 6.97 1.00 308 0 100 7.00
SERVERDESK_IDX01 /dev/rcrm_data697 320 0 7.25 1.00 320 0 77 7.53
SERVERDESK_IDX01 /dev/rcrm_data698 316 0 6.93 1.00 313 0 90 7.56
SERVERDESK_IDX01 /dev/rcrm_data699 71 0 6.48 1.00 64 0 11 6.36
SERVERDESK_IDX01 /dev/rcrm_data70 9,056 5 1.90 1.00 926 1 589 3.21
SERVERDESK_IDX01 /dev/rcrm_data700 192 0 6.04 1.00 214 0 72 3.89
SYSAUX /dev/rcrm_data448 146 0 6.64 1.00 65 0 0 0.00
SYSAUX /dev/rcrm_data453 213 0 3.52 1.00 53 0 0 0.00
SYSAUX /dev/rcrm_data454 106 0 4.81 1.00 66 0 0 0.00
SYSAUX /dev/rcrm_data821 19 0 3.68 1.00 12 0 0 0.00
SYSAUX /dev/rcrm_data822 17 0 4.71 1.00 8 0 0 0.00
SYSAUX /dev/rcrmsysaux 1,223 1 4.42 1.05 610 0 0 0.00
SYSTEM /dev/rcrmsystem 23,459 13 3.36 1.07 342 0 4 0.00
TEMP /dev/rcrm_data09 81 0 3.70 12.41 77 0 0  
TEMP /dev/rcrm_data10 11 0 2.73 1.00 4 0 0  
TEMP /dev/rcrm_data11 12 0 5.00 1.00 7 0 0  
TEMP /dev/rcrm_data12 21 0 2.86 1.00 20 0 0  
TEMP /dev/rcrm_data640 95 0 1.68 11.32 94 0 0  
UNDOTBS1 /dev/rcrm_data01 501 0 2.00 1.00 1 0 5,663 0.85
UNDOTBS1 /dev/rcrm_data02 635 0 2.36 1.00 1 0 16 1.88
UNDOTBS1 /dev/rcrm_data03 1,049 1 2.17 1.00 1 0 34 42.65
UNDOTBS1 /dev/rcrm_data04 786 0 2.21 1.00 1 0 45 3.56
UNDOTBS1 /dev/rcrm_data496 702 0 2.17 1.00 1 0 48 2.29
UNDOTBS1 /dev/rcrm_data497 638 0 1.87 1.00 1 0 45 1.33
UNDOTBS1 /dev/rcrm_data763 746 0 2.13 1.00 2 0 42 0.24
UNDOTBS1 /dev/rcrm_data764 810 0 1.85 1.00 2 0 52 0.96
UNDOTBS1 /dev/rcrm_data765 895 1 1.69 1.00 2 0 14 2.86
UNDOTBS1 /dev/rcrm_data766 903 1 1.82 1.00 2 0 20 0.50
UNDOTBS2 /dev/rcrm_data05 1,475 1 5.57 1.00 4,124 2 633 0.03
UNDOTBS2 /dev/rcrm_data06 66 0 4.55 1.00 2,462 1 91 0.00
UNDOTBS2 /dev/rcrm_data07 263 0 2.85 1.00 3,377 2 122 0.00
UNDOTBS2 /dev/rcrm_data08 146 0 2.40 1.00 3,522 2 127 0.00
UNDOTBS2 /dev/rcrm_data819 65 0 4.92 1.00 3,131 2 103 73.11
UNDOTBS2 /dev/rcrm_data820 65 0 4.15 1.00 2,597 1 72 1.81
USERS /dev/rcrm_data13 571 0 3.75 1.20 2 0 0 0.00
USERTEMP /dev/rcrm_data101 4,552 3 3.17 1.19 561 0 0 0.00
USERTEMP /dev/rcrm_data31 9,515 5 3.62 1.21 1,913 1 0 0.00
USERTEMP /dev/rcrm_data404 3,510 2 3.19 1.26 2 0 0 0.00
USERTEMP /dev/rcrm_data498 2,093 1 5.02 2.04 77 0 0 0.00
USERTEMP /dev/rcrm_data610 2,083 1 4.91 1.97 30 0 0 0.00
USERTEMP /dev/rcrm_data666 64 0 5.00 1.00 3 0 0 0.00
USERTEMP /dev/rcrm_data667 85 0 4.82 1.00 2 0 0 0.00
USERTEMP /dev/rcrm_data668 48 0 5.21 1.00 1 0 0 0.00
USERTEMP /dev/rcrm_data669 45 0 5.33 1.00 1 0 0 0.00
WLOG01 /dev/rcrm_data102 1,508 1 4.77 12.73 7 0 0 0.00
WLOG01 /dev/rcrm_data143 788 0 4.38 10.27 7 0 0 0.00
WLOG01 /dev/rcrm_data236 7,088 4 3.83 5.68 139 0 1 0.00
WLOG01 /dev/rcrm_data417 7,233 4 4.26 5.75 10 0 0 0.00
WLOG01 /dev/rcrm_data437 6,280 4 3.89 6.17 44 0 0 0.00
WLOG01 /dev/rcrm_data518 6,723 4 3.83 5.92 26 0 1 0.00
WLOG01 /dev/rcrm_data577 6,112 3 3.56 6.30 23 0 0 0.00
WLOG01 /dev/rcrm_data817 6,238 4 3.76 6.35 79 0 1 0.00
WLOG01 /dev/rcrm_data818 6,630 4 3.88 5.98 184 0 0 0.00
WLOG01_IDX /dev/rcrm_data103 983 1 6.62 1.00 320 0 0 0.00
WLOG01_IDX /dev/rcrm_data237 698 0 7.38 1.00 459 0 0 0.00
WLOG01_IDX /dev/rcrm_data258 899 1 6.90 1.00 518 0 0 0.00
WLOG01_IDX /dev/rcrm_data438 1,404 1 7.13 1.00 1,119 1 0 0.00
WLOG01_IDX /dev/rcrm_data449 297 0 6.97 1.00 27 0 0 0.00
WLOG01_IDX /dev/rcrm_data611 9,200 5 5.41 1.00 7,073 4 25 4.80
WLOG01_IDX /dev/rcrm_data767 8,957 5 5.74 1.00 7,651 4 38 11.05
WLOG01_IDX /dev/rcrm_data768 6,140 3 6.29 1.00 5,400 3 74 9.73
WLOG01_IDX /dev/rcrm_data769 6,184 3 5.76 1.00 4,385 2 15 3.33
WLOG01_IDX /dev/rcrm_data770 7,562 4 5.80 1.00 6,823 4 14 1.43
WLOG02 /dev/rcrm_data104 988 1 3.87 13.47 2 0 0 0.00
WLOG02 /dev/rcrm_data144 1,309 1 3.41 10.88 2 0 0 0.00
WLOG02 /dev/rcrm_data315 446 0 6.37 1.00 1 0 0 0.00
WLOG02 /dev/rcrm_data440 429 0 6.36 1.00 2 0 0 0.00
WLOG02 /dev/rcrm_data520 364 0 6.29 1.00 1 0 0 0.00
WLOG02 /dev/rcrm_data612 9 0 4.44 1.00 1 0 0 0.00
WLOG02 /dev/rcrm_data815 12 0 2.50 1.00 2 0 0 0.00
WLOG02 /dev/rcrm_data816 12 0 3.33 1.00 2 0 0 0.00
WLOG02_IDX /dev/rcrm_data105 31 0 7.42 1.00 2 0 0 0.00
WLOG02_IDX /dev/rcrm_data259 95 0 7.26 1.00 1 0 0 0.00
WLOG02_IDX /dev/rcrm_data314 85 0 6.35 1.00 1 0 0 0.00
WLOG02_IDX /dev/rcrm_data511 65 0 6.46 1.00 1 0 0 0.00
WLOG02_IDX /dev/rcrm_data613 11 0 4.55 1.00 1 0 0 0.00
WLOG02_IDX /dev/rcrm_data813 9 0 3.33 1.00 2 0 0 0.00
WLOG02_IDX /dev/rcrm_data814 9 0 3.33 1.00 2 0 0 0.00
WLOG03 /dev/rcrm_data106 1,105 1 1.72 14.24 2 0 0 0.00
WLOG03 /dev/rcrm_data145 1,182 1 1.68 13.28 2 0 0 0.00
WLOG03 /dev/rcrm_data441 657 0 1.25 1.00 3 0 0 0.00
WLOG03 /dev/rcrm_data509 596 0 0.84 1.00 1 0 0 0.00
WLOG03 /dev/rcrm_data614 9 0 4.44 1.00 1 0 0 0.00
WLOG03 /dev/rcrm_data811 12 0 5.00 1.00 2 0 0 0.00
WLOG03 /dev/rcrm_data812 12 0 5.00 1.00 2 0 0 0.00
WLOG03_IDX /dev/rcrm_data107 51 0 6.27 1.00 2 0 0 0.00
WLOG03_IDX /dev/rcrm_data321 82 0 6.59 1.00 1 0 0 0.00
WLOG03_IDX /dev/rcrm_data336 95 0 5.89 1.00 1 0 0 0.00
WLOG03_IDX /dev/rcrm_data517 65 0 7.23 1.00 1 0 0 0.00
WLOG03_IDX /dev/rcrm_data615 16 0 3.75 1.00 1 0 0 0.00
WLOG03_IDX /dev/rcrm_data809 9 0 5.56 1.00 2 0 0 0.00
WLOG03_IDX /dev/rcrm_data810 9 0 4.44 1.00 2 0 0 0.00
WLOG04 /dev/rcrm_data108 1,022 1 2.43 29.62 2 0 0 0.00
WLOG04 /dev/rcrm_data146 1,038 1 2.43 29.29 2 0 0 0.00
WLOG04 /dev/rcrm_data442 21 0 6.19 1.00 1 0 0 0.00
WLOG04 /dev/rcrm_data502 35 0 8.57 1.00 4 0 0 0.00
WLOG04 /dev/rcrm_data616 45 0 6.44 1.00 5 0 0 0.00
WLOG04 /dev/rcrm_data807 9 0 3.33 1.00 2 0 0 0.00
WLOG04 /dev/rcrm_data808 9 0 2.22 1.00 2 0 0 0.00
WLOG04_IDX /dev/rcrm_data109 34 0 6.76 1.00 2 0 0 0.00
WLOG04_IDX /dev/rcrm_data337 54 0 7.04 1.00 2 0 0 0.00
WLOG04_IDX /dev/rcrm_data338 57 0 5.96 1.00 1 0 0 0.00
WLOG04_IDX /dev/rcrm_data516 68 0 7.06 1.00 1 0 0 0.00
WLOG04_IDX /dev/rcrm_data617 77 0 5.84 1.00 1 0 0 0.00
WLOG04_IDX /dev/rcrm_data805 9 0 5.56 1.00 2 0 0 0.00
WLOG04_IDX /dev/rcrm_data806 9 0 5.56 1.00 2 0 0 0.00
WLOG05 /dev/rcrm_data126 67 0 4.18 1.00 2 0 0 0.00
WLOG05 /dev/rcrm_data147 11 0 6.36 1.00 2 0 0 0.00
WLOG05 /dev/rcrm_data391 61 0 6.07 1.00 2 0 0 0.00
WLOG05 /dev/rcrm_data443 25 0 7.20 1.00 1 0 0 0.00
WLOG05 /dev/rcrm_data504 23 0 5.65 1.00 3 0 0 0.00
WLOG05 /dev/rcrm_data618 63 0 6.83 1.00 5 0 0 0.00
WLOG05 /dev/rcrm_data777 8 0 0.00 1.00 2 0 0 0.00
WLOG05 /dev/rcrm_data778 8 0 1.25 1.00 2 0 0 0.00
WLOG05_IDX /dev/rcrm_data127 57 0 5.96 1.00 2 0 0 0.00
WLOG05_IDX /dev/rcrm_data507 86 0 7.21 1.00 1 0 0 0.00
WLOG05_IDX /dev/rcrm_data619 121 0 7.27 1.00 1 0 0 0.00
WLOG05_IDX /dev/rcrm_data68 113 0 5.84 1.00 1 0 0 0.00
WLOG05_IDX /dev/rcrm_data771 11 0 3.64 1.00 2 0 0 0.00
WLOG05_IDX /dev/rcrm_data772 11 0 3.64 1.00 2 0 0 0.00
WLOG05_IDX /dev/rcrm_data88 82 0 7.07 1.00 1 0 0 0.00
WLOG06 /dev/rcrm_data128 7 0 7.14 1.00 2 0 0 0.00
WLOG06 /dev/rcrm_data148 7 0 4.29 1.00 2 0 0 0.00
WLOG06 /dev/rcrm_data310 105 0 4.29 1.00 1 0 0 0.00
WLOG06 /dev/rcrm_data444 46 0 6.96 1.00 3 0 0 0.00
WLOG06 /dev/rcrm_data451 42 0 7.62 1.00 2 0 0 0.00
WLOG06 /dev/rcrm_data620 52 0 7.50 1.00 2 0 0 0.00
WLOG06 /dev/rcrm_data803 9 0 2.22 1.00 2 0 0 0.00
WLOG06 /dev/rcrm_data804 9 0 3.33 1.00 2 0 0 0.00
WLOG06_IDX /dev/rcrm_data129 11 0 4.55 1.00 2 0 0 0.00
WLOG06_IDX /dev/rcrm_data159 65 0 6.92 1.00 1 0 0 0.00
WLOG06_IDX /dev/rcrm_data253 102 0 6.96 1.00 1 0 0 0.00
WLOG06_IDX /dev/rcrm_data312 64 0 5.94 1.00 1 0 0 0.00
WLOG06_IDX /dev/rcrm_data513 47 0 7.02 1.00 1 0 0 0.00
WLOG06_IDX /dev/rcrm_data621 58 0 6.55 1.00 1 0 0 0.00
WLOG06_IDX /dev/rcrm_data801 12 0 0.00 1.00 2 0 0 0.00
WLOG06_IDX /dev/rcrm_data802 12 0 0.00 1.00 2 0 0 0.00
WLOG07 /dev/rcrm_data130 34 0 4.41 1.00 2 0 0 0.00
WLOG07 /dev/rcrm_data149 108 0 3.33 1.00 1 0 0 0.00
WLOG07 /dev/rcrm_data393 50 0 7.60 1.00 2 0 0 0.00
WLOG07 /dev/rcrm_data501 69 0 7.25 1.00 3 0 0 0.00
WLOG07 /dev/rcrm_data622 54 0 6.30 1.00 4 0 0 0.00
WLOG07 /dev/rcrm_data646 6 0 3.33 1.00 1 0 0 0.00
WLOG07 /dev/rcrm_data799 9 0 3.33 1.00 2 0 0 0.00
WLOG07 /dev/rcrm_data800 9 0 5.56 1.00 2 0 0 0.00
WLOG07_IDX /dev/rcrm_data131 75 0 5.60 1.00 2 0 0 0.00
WLOG07_IDX /dev/rcrm_data165 59 0 8.64 1.00 1 0 0 0.00
WLOG07_IDX /dev/rcrm_data313 73 0 7.40 1.00 1 0 0 0.00
WLOG07_IDX /dev/rcrm_data392 49 0 6.73 1.00 1 0 0 0.00
WLOG07_IDX /dev/rcrm_data505 36 0 6.94 1.00 1 0 0 0.00
WLOG07_IDX /dev/rcrm_data623 36 0 6.94 1.00 1 0 0 0.00
WLOG07_IDX /dev/rcrm_data797 6 0 6.67 1.00 2 0 0 0.00
WLOG07_IDX /dev/rcrm_data798 6 0 6.67 1.00 2 0 0 0.00
WLOG08 /dev/rcrm_data132 102 0 7.75 1.00 2 0 0 0.00
WLOG08 /dev/rcrm_data150 45 0 5.78 1.00 1 0 0 0.00
WLOG08 /dev/rcrm_data394 7 0 5.71 1.00 1 0 0 0.00
WLOG08 /dev/rcrm_data445 40 0 7.75 1.00 6 0 0 0.00
WLOG08 /dev/rcrm_data515 74 0 5.95 1.00 6 0 0 0.00
WLOG08 /dev/rcrm_data624 94 0 7.66 1.00 4 0 0 0.00
WLOG08 /dev/rcrm_data643 9 0 4.44 1.00 1 0 0 0.00
WLOG08 /dev/rcrm_data795 12 0 2.50 1.00 2 0 0 0.00
WLOG08 /dev/rcrm_data796 12 0 4.17 1.00 2 0 0 0.00
WLOG08_IDX /dev/rcrm_data133 41 0 6.59 1.00 2 0 0 0.00
WLOG08_IDX /dev/rcrm_data197 57 0 4.74 1.00 1 0 0 0.00
WLOG08_IDX /dev/rcrm_data223 54 0 6.85 1.00 1 0 0 0.00
WLOG08_IDX /dev/rcrm_data306 68 0 5.59 1.00 1 0 0 0.00
WLOG08_IDX /dev/rcrm_data508 52 0 6.73 1.00 1 0 0 0.00
WLOG08_IDX /dev/rcrm_data625 79 0 6.46 1.00 1 0 0 0.00
WLOG08_IDX /dev/rcrm_data779 11 0 2.73 1.00 2 0 0 0.00
WLOG08_IDX /dev/rcrm_data780 11 0 3.64 1.00 2 0 0 0.00
WLOG08_IDX /dev/rcrm_data793 12 0 4.17 1.00 2 0 0 0.00
WLOG08_IDX /dev/rcrm_data794 12 0 5.00 1.00 2 0 0 0.00
WLOG09 /dev/rcrm_data134 109 0 4.77 1.00 2 0 0 0.00
WLOG09 /dev/rcrm_data151 12 0 5.00 1.00 1 0 0 0.00
WLOG09 /dev/rcrm_data311 27 0 7.04 1.00 1 0 0 0.00
WLOG09 /dev/rcrm_data387 1,640 1 2.33 30.00 4 0 0 0.00
WLOG09 /dev/rcrm_data506 1,630 1 2.26 30.18 7 0 0 0.00
WLOG09 /dev/rcrm_data626 1,691 1 2.37 30.40 4 0 0 0.00
WLOG09 /dev/rcrm_data791 6 0 6.67 1.00 2 0 0 0.00
WLOG09 /dev/rcrm_data792 6 0 6.67 1.00 2 0 0 0.00
WLOG09_IDX /dev/rcrm_data135 21 0 6.19 1.00 2 0 0 0.00
WLOG09_IDX /dev/rcrm_data204 130 0 6.15 1.00 1 0 0 0.00
WLOG09_IDX /dev/rcrm_data386 139 0 5.97 1.00 1 0 0 0.00
WLOG09_IDX /dev/rcrm_data510 131 0 7.18 1.00 1 0 0 0.00
WLOG09_IDX /dev/rcrm_data627 40 0 6.25 1.00 1 0 0 0.00
WLOG09_IDX /dev/rcrm_data789 7 0 2.86 1.00 2 0 0 0.00
WLOG09_IDX /dev/rcrm_data790 6 0 6.67 1.00 2 0 0 0.00
WLOG09_IDX /dev/rcrm_date200 38 0 6.05 1.00 1 0 0 0.00
WLOG10 /dev/rcrm_data136 119 0 6.47 1.00 3 0 0 0.00
WLOG10 /dev/rcrm_data152 13 0 3.85 1.00 2 0 0 0.00
WLOG10 /dev/rcrm_data320 49 0 7.35 1.00 1 0 0 0.00
WLOG10 /dev/rcrm_data446 34 0 7.65 1.00 1 0 0 0.00
WLOG10 /dev/rcrm_data452 49 0 7.14 1.00 3 0 0 0.00
WLOG10 /dev/rcrm_data628 46 0 6.52 1.00 6 0 0 0.00
WLOG10 /dev/rcrm_data773 8 0 1.25 1.00 2 0 0 0.00
WLOG10 /dev/rcrm_data774 8 0 1.25 1.00 2 0 0 0.00
WLOG10_IDX /dev/rcrm_data137 24 0 7.92 1.00 2 0 0 0.00
WLOG10_IDX /dev/rcrm_data209 62 0 6.29 1.00 1 0 0 0.00
WLOG10_IDX /dev/rcrm_data399 39 0 7.69 1.00 1 0 0 0.00
WLOG10_IDX /dev/rcrm_data519 16 0 6.88 1.00 1 0 0 0.00
WLOG10_IDX /dev/rcrm_data629 18 0 3.89 1.00 1 0 0 0.00
WLOG10_IDX /dev/rcrm_data787 7 0 2.86 1.00 2 0 0 0.00
WLOG10_IDX /dev/rcrm_data788 7 0 2.86 1.00 2 0 0 0.00
WLOG11 /dev/rcrm_data138 962 1 3.57 28.48 2 0 0 0.00
WLOG11 /dev/rcrm_data153 911 1 3.27 31.51 1 0 0 0.00
WLOG11 /dev/rcrm_data402 868 0 3.33 30.78 1 0 0 0.00
WLOG11 /dev/rcrm_data447 930 1 3.32 30.55 2 0 0 0.00
WLOG11 /dev/rcrm_data503 1,962 1 2.93 31.39 3 0 0 0.00
WLOG11 /dev/rcrm_data630 6,254 4 2.37 31.93 1 0 0 0.00
WLOG11 /dev/rcrm_data785 8 0 5.00 1.00 2 0 0 0.00
WLOG11 /dev/rcrm_data786 8 0 3.75 1.00 2 0 0 0.00
WLOG11_IDX /dev/rcrm_data139 32 0 7.19 1.00 2 0 0 0.00
WLOG11_IDX /dev/rcrm_data250 51 0 5.29 1.00 1 0 0 0.00
WLOG11_IDX /dev/rcrm_data307 33 0 6.97 1.00 1 0 0 0.00
WLOG11_IDX /dev/rcrm_data521 38 0 7.11 1.00 1 0 0 0.00
WLOG11_IDX /dev/rcrm_data631 14 0 4.29 1.00 1 0 0 0.00
WLOG11_IDX /dev/rcrm_data783 8 0 2.50 1.00 2 0 0 0.00
WLOG11_IDX /dev/rcrm_data784 8 0 2.50 1.00 2 0 0 0.00
WLOG12 /dev/rcrm_data140 3,174 2 4.48 18.00 2 0 0 0.00
WLOG12 /dev/rcrm_data154 5,545 3 3.54 22.79 1 0 0 0.00
WLOG12 /dev/rcrm_data439 1,245 1 4.54 17.32 3 0 0 0.00
WLOG12 /dev/rcrm_data500 3,531 2 3.96 22.19 1 0 0 0.00
WLOG12 /dev/rcrm_data632 7,399 4 3.66 21.46 1 0 0 0.00
WLOG12 /dev/rcrm_data775 431 0 3.76 19.39 2 0 0 0.00
WLOG12_IDX /dev/rcrm_data141 17 0 7.65 1.00 2 0 0 0.00
WLOG12_IDX /dev/rcrm_data251 114 0 5.44 1.00 1 0 0 0.00
WLOG12_IDX /dev/rcrm_data260 50 0 5.80 1.00 1 0 0 0.00
WLOG12_IDX /dev/rcrm_data512 35 0 6.29 1.00 1 0 0 0.00
WLOG12_IDX /dev/rcrm_data633 23 0 5.22 1.00 1 0 0 0.00
WLOG12_IDX /dev/rcrm_data781 9 0 4.44 1.00 2 0 0 0.00
WLOG12_IDX /dev/rcrm_data782 12 0 5.00 1.00 2 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 1,596,608 98 1,039,677,710 20,652,574 511,248 0 0 313,506


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 8 29775 518761 5720582 13160430 5720582  
E 0 5 22755 406549 3145377 13160430 3145377  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 1,328 0.10 159,277 6.34 20,361,196,241
D 2,656 0.20 318,554 3.12 10,009,774,631
D 3,984 0.30 477,831 2.14 6,854,018,668
D 5,312 0.40 637,108 1.76 5,635,090,714
D 6,640 0.50 796,385 1.54 4,932,928,138
D 7,968 0.60 955,662 1.38 4,422,908,465
D 9,296 0.70 1,114,939 1.25 4,021,403,475
D 10,624 0.80 1,274,216 1.15 3,692,466,908
D 11,952 0.90 1,433,493 1.07 3,425,419,364
D 13,280 1.00 1,592,770 1.00 3,215,103,554
D 13,312 1.00 1,596,608 1.00 3,210,214,040
D 14,608 1.10 1,752,047 0.95 3,034,238,624
D 15,936 1.20 1,911,324 0.90 2,889,294,222
D 17,264 1.30 2,070,601 0.86 2,769,605,253
D 18,592 1.40 2,229,878 0.83 2,676,490,926
D 19,920 1.50 2,389,155 0.81 2,599,213,076
D 21,248 1.60 2,548,432 0.79 2,538,732,635
D 22,576 1.70 2,707,709 0.78 2,488,842,807
D 23,904 1.80 2,866,986 0.76 2,444,299,754
D 25,232 1.90 3,026,263 0.75 2,409,822,236
D 26,560 2.00 3,185,540 0.69 2,223,978,490

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
99.92 54,598 44

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 4,608 1,762 3,948.35 17.89 0.45 100.00 0.00 471,850
E 4,608 1,745 3,972.05 5.77 0.15 100.00 0.00 471,850

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 8,822,698 8,822,698 0 0
64K 128K 1,961 1,961 0 0
128K 256K 3,635 3,635 0 0
256K 512K 227 227 0 0
512K 1024K 12,266 12,266 0 0
1M 2M 14,500 14,500 0 0
2M 4M 827 825 2 0
4M 8M 899 899 0 0
8M 16M 33 30 3 0
16M 32M 78 78 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 1 1 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
576 0.13 9,932,944.93 4,207,373.93 70.00 87,242
1,152 0.25 9,932,944.93 4,207,164.35 70.00 87,208
2,304 0.50 9,932,944.93 2,510,499.06 80.00 34,889
3,456 0.75 9,932,944.93 485,146.71 95.00 0
4,608 1.00 9,932,944.93 157,991.54 98.00 0
5,530 1.20 9,932,944.93 136,988.97 99.00 0
6,451 1.40 9,932,944.93 136,988.97 99.00 0
7,373 1.60 9,932,944.93 136,988.97 99.00 0
8,294 1.80 9,932,944.93 136,988.97 99.00 0
9,216 2.00 9,932,944.93 136,988.97 99.00 0
13,824 3.00 9,932,944.93 136,988.97 99.00 0
18,432 4.00 9,932,944.93 136,988.97 99.00 0
27,648 6.00 9,932,944.93 136,988.97 99.00 0
36,864 8.00 9,932,944.93 136,988.97 99.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
1,168 0.19 652 83,807 278,746,535 0.99 2,072,840 4.41 3,911,484,657
1,792 0.29 1,261 118,321 279,482,034 1.00 1,337,341 2.85 3,915,411,067
2,416 0.39 1,884 152,413 279,756,123 1.00 1,063,252 2.26 3,915,878,653
3,040 0.49 2,507 187,048 279,959,827 1.00 859,548 1.83 3,916,136,264
3,664 0.59 3,129 220,689 280,114,768 1.00 704,607 1.50 3,916,301,918
4,288 0.70 3,754 250,765 280,205,272 1.00 614,103 1.31 3,916,412,433
4,912 0.80 4,376 284,058 280,261,711 1.00 557,664 1.19 3,916,498,116
5,536 0.90 4,999 319,054 280,312,053 1.00 507,322 1.08 3,916,566,089
6,160 1.00 5,622 351,712 280,349,414 1.00 469,961 1.00 3,916,623,602
6,784 1.10 6,245 387,764 280,364,734 1.00 454,641 0.97 3,916,675,050
7,408 1.20 6,868 423,513 280,393,694 1.00 425,681 0.91 3,916,718,389
8,032 1.30 7,491 458,273 280,406,535 1.00 412,840 0.88 3,916,759,841
8,656 1.41 8,114 491,615 280,424,251 1.00 395,124 0.84 3,916,797,431
9,280 1.51 8,737 525,701 280,449,850 1.00 369,525 0.79 3,916,834,331
9,904 1.61 9,360 548,907 280,455,460 1.00 363,915 0.77 3,916,872,782
10,528 1.71 9,983 570,419 280,471,852 1.00 347,523 0.74 3,916,907,184
11,152 1.81 10,606 592,020 280,482,637 1.00 336,738 0.72 3,916,953,802
11,776 1.91 11,229 610,147 280,487,820 1.00 331,555 0.71 3,916,993,872
12,400 2.01 12,400 686,418 280,499,151 1.00 320,224 0.68 3,917,035,241

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)
16 0.50 0 0 0 0
32 1.00 0 0 0 0
48 1.50 0 0 0 0
64 2.00 0 0 0 0
80 2.50 0 0 0 0
96 3.00 0 0 0 0
112 3.50 0 0 0 0
128 4.00 0 0 0 0
144 4.50 0 0 0 0
160 5.00 0 0 0 0
176 5.50 0 0 0 0
192 6.00 0 0 0 0
208 6.50 0 0 0 0
224 7.00 0 0 0 0
240 7.50 0 0 0 0
256 8.00 0 0 0 0
272 8.50 0 0 0 0
288 9.00 0 0 0 0
304 9.50 0 0 0 0
320 10.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 302,962 700 2
file header block 15 9 619
undo header 7,053 5 1
2nd level bmb 1,665 3 2
1st level bmb 271 1 4
undo block 951 0 0
segment header 26 0 2

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
PS-PX Process Reservation 2,297 2,102 195 1,260 210 166.78
HW-Segment High Water Mark 9,933 9,519 414 1,467 186 126.94
TX-Transaction (index contention) 1,666 1,662 0 1,191 159 133.34
TT-Tablespace 68,228 68,227 0 1,237 103 83.65
CF-Controlfile Transaction 4,268 4,261 7 75 63 840.23
FB-Format Block 522 522 0 266 63 236.82
US-Undo Segment 2,786 2,786 0 1,375 22 16.25
WF-AWR Flush 31 31 0 12 16 1,355.33
PW-Buffer Cache PreWarm (flush prewarm buffers) 1 1 0 1 15 15,139.00
TX-Transaction 313,264 313,298 5 386 4 9.85
TX-Transaction (row lock contention) 159 159 0 150 3 22.77
TM-DML 452,459 450,506 1,903 4,109 2 0.58
SQ-Sequence Cache 1,403 1,403 0 46 2 47.96
TO-Temp Object 1,096 1,096 0 409 1 1.59
TD-KTF map table enqueue (KTF dump entries) 6 6 0 1 0 495.00
IR-Instance Recovery 1,279 1,279 0 236 0 1.27
JQ-Job Queue 113 108 5 14 0 1.71
TA-Instance Undo 13 13 0 13 0 1.08
TX-Transaction (allocate ITL entry) 14 14 0 9 0 0.56
PI-Remote PX Process Spawn Status 7 7 0 3 0 0.67
AF-Advisor Framework (task serialization) 7 7 0 1 0 2.00
JS-Job Scheduler (job run lock - synchronize) 1 1 0 1 0 2.00
UL-User-defined 1 1 0 1 0 1.00
WL-Being Written Redo Log 2 2 0 1 0 1.00
TS-Temporary Segment 1 1 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
4 135.93 314,690 2,450 119 38.55/53.8666666666666666666666666666666666667 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
06-Jan 16:29 44,077 86,642 1,592 115 39 0/0 0/0/0/0/0/0
06-Jan 16:19 44,207 98,525 2,450 119 54 0/0 0/0/0/0/0/0
06-Jan 16:09 47,641 129,523 1,843 115 44 0/0 0/0/0/0/0/0

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 12,334 0.00   0 0  
AWR Alerted Metric Element list 104,908 0.00   0 0  
Consistent RBA 270,230 0.01 0.00 0 0  
FAL request queue 39 0.00   0 0  
FAL subheap alocation 39 0.00   0 0  
FIB s.o chain latch 12 0.00   0 0  
FOB s.o list latch 108,762 0.04 0.02 0 0  
JS broadcast add buf latch 1,097 0.00   0 0  
JS broadcast drop buf latch 1,098 0.00   0 0  
JS broadcast load blnc latch 1,045 0.00   0 0  
JS mem alloc latch 2 0.00   0 0  
JS queue access latch 2 0.00   0 0  
JS queue state obj latch 43,910 0.00   0 0  
JS slv state obj latch 122 0.00   0 0  
KCL gc element parent latch 113,855,355 0.15 0.02 1 30,530 0.57
KJC message pool free list 1,199,880 0.25 0.00 0 449,606 0.08
KJCT flow control latch 23,016,701 0.03 0.00 0 0  
KMG MMAN ready and startup request latch 597 0.00   0 0  
KTF sga latch 9,228 0.00   0 603 0.00
KWQMN job cache list latch 225 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 35 0.00
Memory Management Latch 0     0 597 0.00
OS process 27,096 0.00   0 0  
OS process allocation 18,657 0.01 0.00 0 0  
OS process: request allocation 17,880 0.03 0.00 0 0  
PL/SQL warning settings 124,773 0.00   0 0  
SGA IO buffer pool latch 555,221 0.30 0.01 0 555,217 0.28
SQL memory manager latch 5 0.00   0 579 0.00
SQL memory manager workarea list latch 1,292,433 0.02 0.00 0 0  
Shared B-Tree 66 0.00   0 0  
active checkpoint queue latch 31,508 0.54 0.00 0 0  
active service list 60,153 0.08 0.02 0 4,240,679 0.02
archive control 73 0.00   0 0  
archive process latch 661 0.00   0 0  
begin backup scn array 7,759 0.00   0 0  
business card 368 0.00   0 0  
cache buffer handles 884,117 0.04 0.00 0 0  
cache buffers chains 2,066,748,754 0.85 0.00 5 83,862,137 0.01
cache buffers lru chain 2,234,327 1.23 0.01 3 93,045,868 1.23
cache table scan latch 0     0 796,450 0.89
channel handle pool latch 20,949 0.00 0.00 0 0  
channel operations parent latch 787,493 0.02 0.00 0 0  
checkpoint queue latch 1,624,467 0.07 0.00 0 899,887 0.01
client/application info 70,728 0.00   0 0  
commit callback allocation 1,204 0.00   0 0  
compile environment latch 10,053 0.00   0 0  
dml lock allocation 904,988 0.12 0.00 0 0  
dummy allocation 20,103 0.00 0.00 0 0  
enqueue hash chains 25,192,088 0.06 0.00 0 6,264 0.02
enqueues 15,896,524 1.64 0.00 1 0  
error message lists 886 0.00   0 0  
event group latch 8,938 0.00   0 0  
file cache latch 6,514 0.00   0 0  
gcs opaque info freelist 15,179,188 0.42 0.00 0 0  
gcs partitioned table hash 232,704,151 0.00 0.00 0 7,684,709 0.00
gcs remaster request queue 32 0.00   0 0  
gcs remastering latch 27,562,846 0.00 15.43 6 0  
gcs resource freelist 18,813,837 0.08 0.00 0 7,429,969 0.03
gcs resource hash 103,421,698 0.74 0.00 0 2,689 0.67
gcs resource scan list 5,400 0.00   0 0  
gcs shadows freelist 12,036,131 0.00 0.00 0 12,011,761 0.00
ges caches resource lists 3,031,607 0.42 0.00 0 940,269 0.47
ges deadlock list 494,022 0.03 0.00 0 27 0.00
ges domain table 6,423,172 0.00 0.00 0 0  
ges enqueue table freelist 6,942,094 0.02 0.00 0 0  
ges group table 9,607,776 0.02 0.00 0 0  
ges process hash list 442,945 0.00   0 0  
ges process parent latch 13,715,596 0.00 0.00 0 0  
ges process table freelist 17,880 0.00   0 0  
ges resource hash list 11,198,437 0.10 0.02 0 716,702 0.07
ges resource scan list 3,614 0.00   0 0  
ges resource table freelist 1,317,277 0.02 0.00 0 0  
ges synchronous data 416 2.40 0.00 0 52,852 0.05
ges timeout list 13,080 0.01 0.00 0 24,837 0.00
global KZLD latch for mem in SGA 8,449 0.00   0 0  
global hanganlyze operation 12 0.00   0 0  
global tx hash mapping 7,659,420 0.01 0.00 0 0  
hash table column usage latch 1,709 0.06 1.00 0 3,035,507 0.00
hash table modification latch 307 0.00   0 0  
job workq parent latch 0     0 208 0.00
job_queue_processes parameter latch 102 0.00   0 0  
kks stats 266,250 0.05 0.02 0 0  
kokc descriptor allocation latch 13,902 0.11 0.00 0 0  
ksuosstats global area 121 0.00   0 0  
ktm global data 1,961 0.00   0 0  
kwqbsn:qsga 65 0.00   0 0  
lgwr LWN SCN 271,508 0.12 0.00 0 0  
library cache 43,720,193 0.32 0.00 6 196,874 0.84
library cache load lock 5,260 0.00   0 0  
library cache lock 14,102,452 0.03 0.00 0 0  
library cache lock allocation 118,443 0.00   0 0  
library cache pin 7,781,227 0.03 0.00 0 2 0.00
library cache pin allocation 35,875 0.00   0 0  
list of block allocation 54,767 0.01 0.00 0 0  
loader state object freelist 5,952,996 0.32 0.00 0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 1,339 0.00   0 381 0.00
message pool operations parent latch 10,832 0.04 0.00 0 0  
messages 1,517,212 0.12 0.00 0 0  
mostly latch-free SCN 296,398 7.36 0.00 0 0  
multiblock read objects 2,994,478 0.14 0.00 0 0  
name-service memory objects 19,011 0.00   0 0  
name-service namespace bucket 23,424 0.00   0 0  
name-service pending queue 10,206 0.00   0 0  
name-service request 24 0.00   0 0  
name-service request queue 29,590 0.00   0 0  
ncodef allocation latch 121 0.00   0 0  
object queue header heap 339,285 0.00 0.00 0 217,008 0.00
object queue header operation 56,649,060 0.04 0.13 1 0  
object stats modification 2,739 0.00   0 0  
parallel query alloc buffer 10,452 0.00   0 0  
parallel query stats 1,527 0.00   0 0  
parallel txn reco latch 38,220 0.00   0 0  
parameter list 77,414 0.00 0.00 0 0  
parameter table allocation management 38,351 0.01 0.00 0 0  
post/wait queue 792,288 0.07 0.00 0 303,742 0.04
process allocation 30,898 0.97 0.33 1 8,829 1.23
process group creation 17,880 0.00   0 0  
process queue 4,474 0.00   0 0  
process queue reference 83,431 0.00 0.00 0 7,764 0.01
qmn task queue latch 268 0.75 0.00 0 0  
query server freelists 3,296 0.00   0 0  
query server process 4 0.00   0 4 0.00
queued dump request 8,943 0.00   0 0  
redo allocation 858,056 0.22 0.00 0 4,466,573 0.58
redo copy 0     0 4,475,393 0.14
redo writing 880,406 0.02 0.00 0 0  
resmgr group change latch 13,598 0.00   0 0  
resmgr:active threads 20,748 0.03 1.00 0 0  
resmgr:actses change group 11,298 0.00   0 0  
resmgr:free threads list 20,101 0.01 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 74,125,877 1.66 0.00 5 2,659 0.53
rules engine aggregate statistics 25 0.00   0 0  
rules engine rule set statistics 150 0.00   0 0  
sequence cache 974,498 0.19 0.00 0 0  
session allocation 1,311,265 0.17 0.03 0 0  
session idle bit 30,335,315 0.02 0.01 0 0  
session state list latch 4,218 0.00   0 0  
session switching 121 0.00   0 0  
session timer 1,761 0.00   0 0  
shared pool 8,002,241 0.20 0.02 2 0  
shared pool simulator 18,726,647 0.04 0.02 1 0  
simulator hash latch 67,504,605 0.01 0.00 1 0  
simulator lru latch 0     0 63,050,500 1.89
slave class 2 0.00   0 0  
slave class create 8 12.50 1.00 0 0  
sort extent pool 10,929 0.11 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 840 0.00   0 0  
temp lob duration state obj allocation 34 0.00   0 0  
temporary table state object allocation 369 0.00   0 0  
threshold alerts latch 900 0.00   0 0  
transaction allocation 3,675,756 0.00 0.00 0 0  
transaction branch allocation 7,359,127 0.38 0.00 3 0  
undo global data 4,754,628 0.02 0.00 0 0  
user lock 34,054 0.04 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 2,066,748,754 17,518,059 41,172 17,478,509 0 0 0
row cache objects 74,125,877 1,231,033 248 1,230,792 0 0 0
gcs resource hash 103,421,698 764,371 141 764,242 0 0 0
enqueues 15,896,524 260,635 154 260,485 0 0 0
KCL gc element parent latch 113,855,355 173,672 3,634 170,351 0 0 0
library cache 43,720,193 138,148 551 137,599 0 0 0
gcs opaque info freelist 15,179,188 63,033 7 63,026 0 0 0
transaction branch allocation 7,359,127 28,310 46 28,264 0 0 0
cache buffers lru chain 2,234,327 27,463 328 27,148 0 0 0
object queue header operation 56,649,060 24,905 3,144 22,331 0 0 0
mostly latch-free SCN 296,398 21,819 14 21,805 0 0 0
loader state object freelist 5,952,996 18,931 1 18,930 0 0 0
shared pool 8,002,241 15,677 361 15,328 0 0 0
gcs resource freelist 18,813,837 14,968 2 14,966 0 0 0
enqueue hash chains 25,192,088 14,327 6 14,321 0 0 0
ges resource hash list 11,198,437 11,711 192 11,519 0 0 0
KJCT flow control latch 23,016,701 6,866 3 6,864 0 0 0
shared pool simulator 18,726,647 6,847 137 6,720 0 0 0
session idle bit 30,335,315 4,944 35 4,909 0 0 0
simulator hash latch 67,504,605 4,881 5 4,876 0 0 0
library cache lock 14,102,452 4,517 4 4,513 0 0 0
multiblock read objects 2,994,478 4,229 1 4,228 0 0 0
session allocation 1,311,265 2,203 68 2,137 0 0 0
redo allocation 858,056 1,912 1 1,911 0 0 0
SGA IO buffer pool latch 555,221 1,692 18 1,677 0 0 0
gcs remastering latch 27,562,846 569 8,782 247 0 0 0
process allocation 30,898 300 99 203 0 0 0
kks stats 266,250 143 3 140 0 0 0
active service list 60,153 46 1 45 0 0 0
FOB s.o list latch 108,762 44 1 43 0 0 0
resmgr:active threads 20,748 7 7 0 0 0 0
hash table column usage latch 1,709 1 1 0 0 0 0
slave class create 8 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
FOB s.o list latch ksfd_allfob 0 1 1
KCL gc element parent latch kclnfndnewm 0 2,016 1,701
KCL gc element parent latch kclplz 0 1,268 690
KCL gc element parent latch kclbla 0 761 13
KCL gc element parent latch kclzcl 0 645 148
KCL gc element parent latch kclnfnd 0 592 249
KCL gc element parent latch kclrwrite 0 481 245
KCL gc element parent latch kclulb 0 313 1,882
KCL gc element parent latch KCLUNLNK 0 169 1,253
KCL gc element parent latch kclgcr 0 94 18
KCL gc element parent latch kclfwrite1 0 93 80
KCL gc element parent latch kclliter 0 43 5
KCL gc element parent latch kclgrantlk 0 41 175
KCL gc element parent latch kclwrt 0 26 81
KCL gc element parent latch kclpto 0 25 8
KCL gc element parent latch kclpto_3 0 12 5
KCL gc element parent latch kclpdc_3 0 10 9
KCL gc element parent latch kclchkping 0 8 0
KCL gc element parent latch kclexpand 0 7 6
KCL gc element parent latch kclprm 0 3 3
KCL gc element parent latch kclshrsplit 0 3 4
KCL gc element parent latch kclebs 0 2 12
KCL gc element parent latch kclpto_1 0 2 0
KCL gc element parent latch kclclose 0 1 1
KCL gc element parent latch kclhngcbk1 0 1 0
KCL gc element parent latch kclpdc_14 0 1 1
KCL gc element parent latch kclrbast 0 1 0
KJCT flow control latch kjctcsnd: send normal message 0 3 0
SGA IO buffer pool latch ksfd_free_sgabuffer 0 12 18
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 6 0
active service list ksws_event: ksws event 0 6 4
cache buffers chains kcbgtcr: kslbegin excl 0 62,048 60,652
cache buffers chains kcbrls: kslbegin 0 8,000 18,536
cache buffers chains kclcls_3 0 4,577 32
cache buffers chains kcbgtcr: fast path 0 4,076 2,211
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 2,510 1,472
cache buffers chains kcbzwb 0 2,196 1,053
cache buffers chains kcbzib: multi-block read: nowait 0 744 0
cache buffers chains kclexpand 0 643 12
cache buffers chains kcbgtcr: kslbegin shared 0 530 369
cache buffers chains kcbzgb: scan from tail. nowait 0 210 0
cache buffers chains kcbget: pin buffer 0 198 103
cache buffers chains kcbgcur: kslbegin 0 183 98
cache buffers chains kcbzib: finish free bufs 0 68 219
cache buffers chains kclbla 0 56 10
cache buffers chains kclwcrs 0 29 10
cache buffers chains kclobj_1 0 27 0
cache buffers chains kcbbxsv 0 26 24
cache buffers chains kclebs_1 0 22 18
cache buffers chains kcbchg: kslbegin: call CR func 0 21 938
cache buffers chains kcbnew: new latch again 0 21 3
cache buffers chains kcbesc: escalate 0 12 2
cache buffers chains kclpto 0 11 0
cache buffers chains kcbget: exchange rls 0 7 3
cache buffers chains kclgrantlk 0 7 0
cache buffers chains kcbgcur: buf pinned 0 6 3
cache buffers chains kcbget: exchange 0 6 8
cache buffers chains kclgrantlk_1 0 6 9
cache buffers chains kcbcge 0 5 224
cache buffers chains kcbgtcr 0 5 5
cache buffers chains kcbnlc 0 5 27
cache buffers chains kclobj 0 5 0
cache buffers chains kclpred 0 3 0
cache buffers chains kclwrt 0 3 3
cache buffers chains kclcsr 0 2 27
cache buffers chains kcbkzs 0 1 6
cache buffers chains kcbnew_1 0 1 0
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 1 0
cache buffers chains kcbzib: exchange rls 0 1 1
cache buffers chains kclfpdb 0 1 0
cache buffers chains kclfpdb_2 0 1 0
cache buffers chains kclpdc_4 0 1 12
cache buffers chains kclpto_1 0 1 27
cache buffers chains kclrls 0 1 90
cache buffers chains kclwlr 0 1 2
cache buffers lru chain kcbzgws 0 189 0
cache buffers lru chain kcbbxsv: move to being written 0 39 57
cache buffers lru chain kcbzgb: posted for free bufs 0 26 139
cache buffers lru chain kcbzar: KSLNBEGIN 0 18 0
cache buffers lru chain kclmvreqbg 0 18 51
cache buffers lru chain kcbbic2 0 12 40
cache buffers lru chain kcbo_link_q 0 6 0
cache buffers lru chain kcbrenounce 0 5 0
cache buffers lru chain kcbzgm 0 3 0
cache buffers lru chain kcbbwlru 0 2 11
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 2 0
cache buffers lru chain kcbzib: move stale buffers 0 2 21
cache buffers lru chain kclmergepi 0 2 0
cache buffers lru chain kclwcrs 0 2 0
cache buffers lru chain H_MK_PI_CR_BG 0 1 0
cache buffers lru chain kcbzswcu 0 1 0
enqueue hash chains ksqcnl 0 2 2
enqueue hash chains ksqgtl3 0 2 4
enqueue hash chains ksqrcl 0 2 0
enqueues ksqdel 0 77 43
enqueues ksqgel: create enqueue 0 69 98
enqueues ksqies 0 8 13
event range base latch No latch 0 2 0
gcs opaque info freelist kjbrcvt save opaque info 0 4 4
gcs opaque info freelist kjbrgrant free opaque info 0 3 3
gcs remastering latch 59 0 8,834 0
gcs remastering latch 43 0 75 0
gcs remastering latch 69 0 18 0
gcs remastering latch 12 0 1 0
gcs resource freelist kjbralc add resource 0 2 1
gcs resource hash kjbcropen:affinity 0 68 13
gcs resource hash kjblocalfile_nolock 0 37 7
gcs resource hash kjbcropen 0 8 5
gcs resource hash kclzcl 0 6 43
gcs resource hash kjbassume 0 5 9
gcs resource hash kjbmpclose 0 4 20
gcs resource hash kjbopen 0 3 0
gcs resource hash kclgrantlk_1 0 2 1
gcs resource hash kjbmpopen 0 2 21
gcs resource hash kjbopen:affinity 0 2 2
gcs resource hash kjbconvert 0 1 2
gcs resource hash kjbmpwrite 0 1 3
gcs resource hash kjbrrcfwst 0 1 0
gcs resource hash kjbrwrdone reget 0 1 0
ges resource hash list kjakcai: search for resp by resname 0 159 3
ges resource hash list kjucvl: lock convert request 0 16 155
ges resource hash list kjlrlr: remove lock from resource queue 0 6 24
ges resource hash list kjrmas1: lookup master node 0 6 0
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 5 0
hash table column usage latch KSXMMON_GETCELEM 0 1 0
kks stats kks stats alloc/free 0 3 3
lgwr LWN SCN kcs023 0 1 0
library cache kglic 0 264 109
library cache kglpndl: child: after processing 0 83 0
library cache kgldte: child 0 0 49 74
library cache kglpin 0 42 9
library cache kglLockCursor 0 28 60
library cache kglobpn: child: 0 16 144
library cache kglhdgn: child: 0 13 65
library cache kgldti: 2child 0 6 5
library cache kglpndl: child: before processing 0 5 32
library cache kglukp: child 0 5 5
library cache kglpnp: child 0 2 5
library cache kglati 0 1 0
library cache lock kgllkdl: child: no lock handle 0 18 34
library cache lock kgllkdl: child: cleanup 0 4 1
loader state object freelist kcblfs 0 1 1
mostly latch-free SCN kcslcu3 0 13 14
multiblock read objects kcbzib: normal mbr free 0 1 1
object queue header operation kclobj_1 0 4,117 1,245
object queue header operation kclobj_3 0 399 221
object queue header operation kcbo_switch_mq_bg 0 176 304
object queue header operation kcbw_unlink_q 0 153 2,369
object queue header operation kcbw_link_q 0 96 609
object queue header operation kcbo_switch_cq 0 63 157
object queue header operation kclobj_2 0 29 12
object queue header operation kcbo_switch_q_bg 0 19 84
object queue header operation kcbw_unlink_q_bg 0 18 41
object queue header operation kcbo_link_q:reget 0 3 6
object queue header operation kcbo_swap_buf 0 2 4
object queue header operation kcbo_swap_buf_bg 0 2 25
process allocation ksucrp 0 46 0
process allocation ksufap: active procs 0 43 20
process allocation ksudlp 0 7 28
process allocation ksuapc 0 3 51
redo allocation kcrfw_redo_gen: redo allocation 1 0 1 0
resmgr:active threads kgskchclass 0 7 0
row cache objects kqreqd: reget 0 191 8
row cache objects kqrpre: find obj 0 29 230
row cache objects kqreqd 0 16 4
row cache objects kqrso 0 11 4
row cache objects kqrigt 0 1 1
session allocation ksucri 0 26 53
session allocation ksufap: active sessions 0 22 0
session allocation ksuxds: not user session 0 17 11
session allocation kspallmod 0 1 0
session allocation ksudlc 0 1 1
session allocation ksuprc 0 1 1
session idle bit ksupuc: set busy 0 40 11
session idle bit ksupuc: clear busy 0 25 52
session idle bit ksuxds 0 1 3
shared pool kghupr1 0 158 164
shared pool kghalo 0 140 103
shared pool kghfre 0 33 76
shared pool kghfrunp: alloc: wait 0 22 0
shared pool kghfrunp: clatch: nowait 0 13 0
shared pool kghalp 0 7 17
shared pool kghfrunp: clatch: wait 0 6 8
shared pool kghasp 0 1 1
shared pool simulator kglsim_unpin_simhp: fast path 0 67 118
shared pool simulator kglsim_unpin_simhp 0 61 10
shared pool simulator kglsim_scan_lru: scan 0 6 6
shared pool simulator kglsim_upd_newhp 0 3 3
simulator hash latch kcbsacc: lookup dba 0 4 5
simulator hash latch kcbsacc: insert dba 0 1 0
slave class create ksvcreate 0 1 0
transaction branch allocation ksupuc 0 44 41
transaction branch allocation ktcbba 0 2 4

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
DBCUSTADM CUSTMSG02 WOCSUSERINTERFACE   TABLE 315,368,064 30.22
DBCUSTADM CUSTMSG02 WOCSUSERINTERFACE$MULTI   INDEX 219,696,800 21.06
DBCRMADM CRMMSG MMSERVICE   TABLE 67,481,344 6.47
PRODUCT CUSTMSG03 PK_SBANDOFFER   INDEX 40,309,488 3.86
WORKFLOWADM SERVERDESK_DATA01 WSNDCMDDAYINFO   TABLE 35,488,080 3.40

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
WORKFLOWADM SERVERDESK_DATA01 SYS_LOB0000061737C00003$$   LOB 3,234,980 13.53
DBCRMADM CRMMSG DCUSTHIGH PART_01 TABLE PARTITION 1,243,104 5.20
DBMARK CRMMSG DMARKTOTAL201212   TABLE 1,108,990 4.64
DBCRMADM CRMMSG DSRVRETURNREC_YES   TABLE 786,678 3.29
DBCRMADM CRMMSG UDISTRIBUTE_LOG   TABLE 783,030 3.27

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
PRODUCT CUSTMSG03_IDX IDX_ORDER_CONTENT_PARCONTENDID   INDEX 715 46.89
WORKFLOWADM SERVERDESK_DATA01 WSNDCMDDAYINFO   TABLE 234 15.34
PRODUCT CUSTMSG03_IDX IDX_ORDER_CONTENT_PRODORDID   INDEX 95 6.23
DBCUSTADM WLOG01_IDX WLOGINOPR201301_ACCEPT   INDEX 78 5.11
WORKFLOWADM SERVERDESK_IDX01 WSNDCMDDAYINFO201301_002   INDEX 50 3.28

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
DBCUSTADM WLOG01_IDX WCHG201301_ACCEPT   INDEX 5 50.00
DBRESADM CUSTRES_IDX IDX_WSIMRESOPR201301_1   INDEX 2 20.00
DBCUSTADM WLOG01_IDX ID_WCHG201301_OP_TIME   INDEX 2 20.00
DBORDERADM CUSTMSG01_IDX DORDERARRAYPRTCNTT201301_PK   INDEX 1 10.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
PRODUCT CUSTMSG03_IDX IDX_ORDER_CONTENT_PARCONTENDID   INDEX 2,170 65.68
WORKFLOWADM SERVERDESK_IDX01 WSNDCMDDAYINFO201301_002   INDEX 257 7.78
PRODUCT CUSTMSG03 PRODUCT_ORDER_CONTENT   TABLE 234 7.08
PRODUCT CUSTMSG03_IDX IDX_ORDER_CONTENT_PRODORDID   INDEX 71 2.15
WORKFLOWADM SERVERDESK_IDX01 WSNDCMDDAYINFO201301_003   INDEX 71 2.15

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
DBCRMADM CRMMSG DSRVRETURNREC_YES   TABLE 86,495 32.20
DBMARK CRMMSG DMARKTOTAL201212   TABLE 32,536 12.11
DBCRMADM CRMMSG DCUSTHIGH PART_01 TABLE PARTITION 31,471 11.72
PRODUCT CUSTMSG02 WPRODUCTOFFONCHG   TABLE 19,643 7.31
DBCUSTADM CUSTMSG02 WOCSUSERINTERFACE$MULTI   INDEX 14,451 5.38

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
WORKFLOWADM SERVERDESK_DATA01 WSNDCMDDAYINFO   TABLE 32,846 6.48
DBCUSTADM CUSTMSG02 WOCSUSERINTERFACE$MULTI   INDEX 31,625 6.24
DBCUSTADM CUSTMSG02 WOCSUSERINTERFACE   TABLE 28,165 5.56
PRODUCT CUSTMSG02 WPRODUCTOFFONCHG   TABLE 21,205 4.18
DBORDERADM CUSTMSG02_IDX WUSERSTARTSTOPINTERFACE_PK2   INDEX 15,090 2.98

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
DBCRMADM CRMMSG DSRVRETURNREC_YES   TABLE 1,651,243 30.69
DBMARK CRMMSG DMARKTOTAL201212   TABLE 793,162 14.74
DBCRMADM CRMMSG DCUSTHIGH PART_09 TABLE PARTITION 334,864 6.22
DBCRMADM CRMMSG DCUSTHIGH PART_01 TABLE PARTITION 238,777 4.44
DBCRMADM CRMMSG DCUSTHIGH PART_06 TABLE PARTITION 191,506 3.56

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 31 6.45 0   0 1
dc_database_links 1,438,245 0.00 0   0 16
dc_files 87,450 0.00 0   0 825
dc_global_oids 10,616 0.08 0   0 43
dc_histogram_data 1,868,747 0.20 0   0 34,243
dc_histogram_defs 4,799,112 0.08 0   0 16,624
dc_object_grants 7,957 0.77 0   0 547
dc_object_ids 1,793,108 0.03 0   0 3,298
dc_objects 112,089 1.03 0   4 3,313
dc_profiles 8,556 0.00 0   0 1
dc_rollback_segments 298,757 0.00 0   10 2,550
dc_segments 353,630 0.46 0   24 4,688
dc_sequences 1,486 58.55 0   1,486 92
dc_tablespace_quotas 20 80.00 0   20 13
dc_tablespaces 1,295,038 0.00 0   0 69
dc_usernames 112,011 0.00 0   0 67
dc_users 19,909,155 0.00 0   0 140
outstanding_alerts 442 93.67 0   24 6

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 2 2 0
dc_constraints 4 0 0
dc_global_oids 9 0 2
dc_histogram_defs 3,704 0 636
dc_object_ids 622 0 1,383
dc_objects 1,219 7 327
dc_rollback_segments 20 0 0
dc_segments 1,666 16 762
dc_sequences 2,970 871 7
dc_tablespace_quotas 40 10 0
dc_usernames 5 0 2
dc_users 2 0 1
outstanding_alerts 864 402 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 6,183 0.02 79,774 0.01 3 0
CLUSTER 40 0.00 72 0.00 0 0
INDEX 19,546 0.16 34,672 0.24 51 0
SQL AREA 481,626 33.97 21,359,551 1.18 26,904 277
TABLE/PROCEDURE 144,498 0.25 6,064,458 0.05 1,350 0
TRIGGER 1,283 0.08 4,886 0.06 2 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 72 0 0 0 0
INDEX 34,672 31 42 1 0
TABLE/PROCEDURE 2,561,843 530 181 214 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 3,197.43   1.17 7.11 347 347 2,728 2,728
  Freeable 434.69 0.00 0.62 0.65 14   697 697
  SQL 282.13 135.70 0.10 0.33 12 598 2,703 1,351
  PL/SQL 30.27 12.17 0.01 0.05 1 3 2,726 2,723
E Other 3,229.72   1.18 7.14 347 347 2,726 2,726
  Freeable 440.38 0.00 0.62 0.48 6   706 706
  SQL 272.69 127.59 0.10 0.24 4 598 2,700 1,353
  PL/SQL 30.36 12.32 0.01 0.05 1 1 2,723 2,720

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 13,958,643,712  
Fixed Size 2,122,472  
Redo Buffers 14,651,392  
Variable Size 7,499,418,904  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 112.00 112.00 0.00
large free memory 128.00 128.00 0.00
shared CCursor 654.08 676.68 3.45
shared Cursor Stats 71.20 71.20 0.00
shared PCursor 434.97 448.66 3.15
shared db_block_hash_buckets 90.00 90.00 0.00
shared free memory 510.99 479.00 -6.26
shared gcs resources 339.50 339.50 0.00
shared gcs shadows 167.39 167.39 0.00
shared ges enqueues 86.40 86.40 0.00
shared kglsim heap 84.55 84.55 0.00
shared kglsim object batch 139.93 139.93 0.00
shared library cache 375.16 370.05 -1.36
shared sql area 2,450.93 2,430.81 -0.82
streams free memory 32.00 32.00 0.00
  buffer_cache 13,312.00 13,312.00 0.00
  fixed_sga 2.02 2.02 0.00
  log_buffer 13.97 13.97 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 Coordinator 125,885 0 0
QMON Slaves 64,644 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 25 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 1,320,073 1,686,181 1808956 1808956
gcs_shadows 1,157,013 1,690,114 1808956 1808956


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_smu_debug_mode 33554432   
audit_file_dest /oracle/admin/crmdb/adump   
audit_sys_operations TRUE   
audit_trail DB, EXTENDED   
background_dump_dest /oracle/admin/crmdb/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.3.0   
control_files /dev/rcrm_ctrl1, /dev/rcrm_ctrl2, /dev/rcrm_ctrl3   
core_dump_dest /oracle/admin/crmdb/cdump   
cursor_sharing EXACT FORCE
db_block_size 8192   
db_cache_size 13958643712   
db_domain      
db_file_multiblock_read_count 32   
db_files 2048   
db_name crmdb   
dispatchers (PROTOCOL=TCP) (SERVICE=crmdbXDB)   
hash_area_size 134217728   
instance_groups CRMDB2   
instance_number 2   
java_pool_size 117440512   
job_queue_processes 20   
large_pool_size 134217728   
local_listener crmdb_listener   
log_archive_dest /archcrmdb2   
log_archive_format crm%t_%s_%r.dbf   
open_cursors 3000   
parallel_instance_group CRMDB2   
pga_aggregate_target 4831838208   
processes 6000   
recyclebin ON   
remote_listener LISTENERS_CRMDB   
remote_login_passwordfile EXCLUSIVE   
service_names Listener_crmdb, crmdb   
session_cached_cursors 200   
sessions 6605   
sga_max_size 21474836480   
sga_target 0   
shared_pool_size 6442450944   
spfile /dev/rcrm_spfile   
streams_pool_size 33554432   
thread 2   
timed_statistics TRUE   
undo_management AUTO   
undo_retention 900   
undo_tablespace UNDOTBS2   
user_dump_dest /oracle/admin/crmdb/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 54,806 30.82 0.24
acks for commit broadcast(logical) 271,362 152.61 1.19
broadcast msgs on commit(actual) 265,019 149.04 1.16
broadcast msgs on commit(logical) 270,182 151.95 1.18
broadcast msgs on commit(wasted) 141,373 79.51 0.62
broadcast on commit wait time(ms) 56,810 31.95 0.25
broadcast on commit waits 151,936 85.45 0.66
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 143 0.08 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 4,650,844 2,615.58 20.31
gcs ast xid 40 0.02 0.00
gcs blocked converts 494,180 277.92 2.16
gcs blocked cr converts 520,604 292.78 2.27
gcs compatible basts 7,087 3.99 0.03
gcs compatible cr basts (global) 58,895 33.12 0.26
gcs compatible cr basts (local) 7,181,564 4,038.82 31.37
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 100,869 56.73 0.44
gcs dbwr write request msgs 68,692 38.63 0.30
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 41,807 23.51 0.18
gcs immediate (null) converts 572,595 322.02 2.50
gcs immediate cr (compatible) converts 100,599 56.58 0.44
gcs immediate cr (null) converts 12,243,497 6,885.59 53.48
gcs indirect ast 1,017,548 572.26 4.44
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 47,933 26.96 0.21
gcs msgs process time(ms) 1,077,862 606.18 4.71
gcs msgs received 36,746,844 20,665.97 160.51
gcs out-of-order msgs 19 0.01 0.00
gcs pings refused 101,266 56.95 0.44
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 444 0.25 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 72 0.04 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 655 0.37 0.00
gcs side channel msgs actual 52,821 29.71 0.23
gcs side channel msgs logical 7,021,036 3,948.54 30.67
gcs stale cr 184,721 103.88 0.81
gcs undo cr 11,333 6.37 0.05
gcs write notification msgs 6,709 3.77 0.03
gcs writes refused 425 0.24 0.00
ges msgs process time(ms) 12,851 7.23 0.06
ges msgs received 761,422 428.21 3.33
global posts dropped 0 0.00 0.00
global posts queue time 2 0.00 0.00
global posts queued 25 0.01 0.00
global posts requested 25 0.01 0.00
global posts sent 26 0.01 0.00
implicit batch messages received 2,043,455 1,149.21 8.93
implicit batch messages sent 1,857,183 1,044.46 8.11
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 360,476 202.73 1.57
messages queue sent actual 4,106,388 2,309.38 17.94
messages queue sent logical 12,410,761 6,979.66 54.21
messages received actual 9,701,831 5,456.19 42.38
messages received logical 37,510,870 21,095.65 163.84
messages sent directly 2,930,294 1,647.96 12.80
messages sent indirectly 11,008,287 6,190.92 48.08
messages sent not implicit batched 2,250,458 1,265.63 9.83
messages sent pbatched 18,690,591 10,511.36 81.64
msgs causing lmd to send msgs 245,458 138.04 1.07
msgs causing lms(s) to send msgs 1,004,582 564.96 4.39
msgs received queue time (ms) 249,764 140.46 1.09
msgs received queued 37,506,340 21,093.10 163.82
msgs sent queue time (ms) 414,603 233.17 1.81
msgs sent queue time on ksxp (ms) 32,480,250 18,266.49 141.87
msgs sent queued 11,643,518 6,548.17 50.86
msgs sent queued on ksxp 8,787,416 4,941.93 38.38
process batch messages received 2,676,359 1,505.15 11.69
process batch messages sent 2,616,648 1,471.57 11.43


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 658,934
CURRENT Block Requests 82,990
Data Block Requests 658,933
Undo Block Requests 11,244
TX Block Requests 61,662
Current Results 690,660
Private results 16,437
Zero Results 33,093
Disk Read Results 1,513
Fail Results 13
Fairness Down Converts 85,279
Fairness Clears 0
Free GC Elements 0
Flushes 14,336
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 24,204
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 8,846,776 99.98 0.00 0.02 0.00 0.00
Flushes 5,826 74.60 24.49 0.84 0.07 0.00
Writes 104,060 2.70 27.00 69.85 0.38 0.07


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 420,637 87.48 12.44 0.08 5,348,002 99.10 0.16 0.74
1 undo header 65,665 96.58 3.35 0.07 940 93.51 6.49 0.00
1 Others 10,697 89.92 10.06 0.02 34,090 98.84 1.09 0.06
1 undo block 9,349 81.86 18.07 0.07 0      


Back to Top

End of Report