WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
DB1443746072db2210.2.0.4.0YESDB02

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:3561325-Mar-13 16:00:44404 10.1
End Snap:3561525-Mar-13 18:00:20412 10.0
Elapsed:  119.60 (mins)  
DB Time:  903.08 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 23,552M 23,552MStd Block Size: 8K
Shared Pool Size: 2,000M 2,000MLog Buffer: 14,328K

Load Profile

Per SecondPer Transaction
Redo size: 5,843,712.10 83,797.77
Logical reads: 143,655.11 2,059.99
Block changes: 26,022.72 373.16
Physical reads: 169.59 2.43
Physical writes: 598.01 8.58
User calls: 214.56 3.08
Parses: 31.64 0.45
Hard parses: 0.55 0.01
Sorts: 7.72 0.11
Logons: 0.22 0.00
Executes: 583.90 8.37
Transactions: 69.74 

% Blocks changed per Read: 18.11Recursive Call %: 93.39
Rollback per transaction %: 35.23Rows per Sort: 1767.61

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98Redo NoWait %: 99.99
Buffer Hit %: 99.91In-memory Sort %: 99.98
Library Hit %: 99.72Soft Parse %: 98.25
Execute to Parse %: 94.58Latch Hit %: 99.97
Parse CPU to Parse Elapsd %: 71.52% Non-Parse CPU: 99.98

Shared Pool Statistics

BeginEnd
Memory Usage %: 86.37 85.86
% SQL with executions>1: 93.92 74.61
% Memory for SQL w/exec>1: 84.95 77.12

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  39,854  73.6 
Log archive I/O 40,270 3,502 87 6.5System I/O
log file sync 333,595 2,720 8 5.0Commit
db file sequential read 519,767 1,916 4 3.5User I/O
log file parallel write 334,079 1,702 5 3.1System I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 390.95 5.61
Global Cache blocks served: 543.98 7.80
GCS/GES messages received: 1,232.37 17.67
GCS/GES messages sent: 983.76 14.11
DBWR Fusion writes: 55.53 0.80
Estd Interconnect traffic (KB) 7,912.25 

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

Buffer access - local cache %: 99.63
Buffer access - remote cache %: 0.27
Buffer access - disk %: 0.09

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1
Avg global cache cr block receive time (ms): 0.8
Avg global cache current block receive time (ms): 0.7
Avg global cache cr block build time (ms): 0.1
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.2
Avg global cache cr block flush time (ms): 42.4
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): 47.1

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.5
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.1
% of direct sent messages: 48.77
% of indirect sent messages: 44.58
% of flow controlled messages: 6.65

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 51,367.80 94.80
DB CPU 39,854.10 73.55
PL/SQL execution elapsed time 147.80 0.27
parse time elapsed 13.43 0.02
hard parse elapsed time 6.17 0.01
connection management call elapsed time 3.35 0.01
repeated bind elapsed time 2.94 0.01
hard parse (sharing criteria) elapsed time 0.55 0.00
PL/SQL compilation elapsed time 0.08 0.00
DB time 54,184.83  
background elapsed time 8,144.00  
background cpu time 803.02  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
System I/O 584,140 0.00 7,077 12 1.17
Commit 333,595 3.06 2,720 8 0.67
User I/O 585,238 0.00 2,137 4 1.17
Cluster 3,762,094 0.00 2,114 1 7.52
Network 2,252,230 0.00 318 0 4.50
Other 253,610 63.02 283 1 0.51
Configuration 4,223 0.21 134 32 0.01
Concurrency 37,403 0.20 25 1 0.07
Application 228 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Log archive I/O 40,270 0.00 3,502 87 0.08
log file sync 333,595 3.06 2,720 8 0.67
db file sequential read 519,767 0.00 1,916 4 1.04
log file parallel write 334,079 0.00 1,702 5 0.67
db file parallel write 79,274 0.00 898 11 0.16
log file sequential read 40,620 0.00 709 17 0.08
gc cr block 2-way 1,124,574 0.00 581 1 2.25
gc current block 2-way 786,495 0.00 378 0 1.57
SQL*Net more data from client 863,701 0.00 316 0 1.73
gc buffer busy 171,707 0.01 244 1 0.34
gc cr multi block request 925,846 0.00 213 0 1.85
gcs log flush sync 92,982 87.47 182 2 0.19
control file parallel write 4,586 0.00 169 37 0.01
gc cr block busy 8,423 0.00 150 18 0.02
gc current grant busy 215,108 0.00 120 1 0.43
gc cr block congested 4,678 0.00 108 23 0.01
direct path read temp 12,088 0.00 107 9 0.02
control file sequential read 85,185 0.00 97 1 0.17
log buffer space 748 0.13 95 127 0.00
gc current grant 2-way 223,522 0.00 83 0 0.45
gc current block busy 1,818 0.11 71 39 0.00
db file scattered read 29,780 0.00 65 2 0.06
gc current block congested 1,980 0.00 54 27 0.00
gc cr grant 2-way 96,290 0.00 42 0 0.19
direct path write temp 5,546 0.00 40 7 0.01
log file switch completion 158 5.06 37 237 0.00
LGWR wait for redo copy 14,973 8.79 30 2 0.03
gc current multi block request 200,204 0.00 24 0 0.40
enq: WF - contention 54 61.11 17 313 0.00
latch: cache buffers chains 31,887 0.00 15 0 0.06
gc current grant congested 429 0.00 15 34 0.00
gc cr grant congested 286 0.00 12 43 0.00
latch: KCL gc element parent latch 3,022 0.00 11 4 0.01
gc cr block lost 22 0.00 10 473 0.00
Streams AQ: qmn coordinator waiting for slave to start 2 100.00 10 4990 0.00
buffer busy waits 1,129 6.73 7 6 0.00
gc current block lost 14 0.00 7 477 0.00
latch free 748 0.00 6 8 0.00
enq: FB - contention 18,199 0.00 5 0 0.04
latch: redo allocation 1,322 0.00 5 4 0.00
latch: cache buffers lru chain 1,037 0.00 4 4 0.00
latch: object queue header operation 4,082 0.00 4 1 0.01
direct path read 12,137 0.00 4 0 0.02
read by other session 496 0.00 3 6 0.00
cr request retry 723 100.00 2 3 0.00
direct path write 5,239 0.00 2 0 0.01
latch: gcs resource hash 361 0.00 1 4 0.00
gc current block unknown 624 0.00 1 2 0.00
row cache lock 3,539 0.00 1 0 0.01
SQL*Net message to client 1,344,744 0.00 1 0 2.69
enq: HW - contention 3,295 0.00 1 0 0.01
db file parallel read 185 0.00 1 5 0.00
enq: CF - contention 338 0.00 1 3 0.00
CGS wait for IPC msg 60,204 100.00 1 0 0.12
SQL*Net more data to client 43,785 0.00 1 0 0.09
latch: redo writing 20 0.00 1 27 0.00
wait list latch free 29 0.00 1 18 0.00
os thread startup 11 0.00 1 47 0.00
latch: checkpoint queue latch 105 0.00 1 5 0.00
library cache lock 769 0.00 0 1 0.00
latch: ges resource hash list 17,764 0.00 0 0 0.04
gc current retry 36 0.00 0 12 0.00
log file single write 126 0.00 0 3 0.00
enq: TM - contention 220 0.00 0 1 0.00
latch: undo global data 58 0.00 0 5 0.00
gc cr failure 34 0.00 0 7 0.00
DFS lock handle 12,054 0.00 0 0 0.02
latch: library cache 14 0.00 0 13 0.00
enq: PS - contention 369 0.00 0 0 0.00
PX Deq: reap credit 7,458 92.21 0 0 0.01
ksxr poll remote instances 15,767 55.93 0 0 0.03
buffer deadlock 12 100.00 0 13 0.00
enq: TX - index contention 9 0.00 0 16 0.00
reliable message 556 0.00 0 0 0.00
lock deadlock retry 11 100.00 0 11 0.00
latch: row cache objects 27 0.00 0 3 0.00
enq: TT - contention 284 0.00 0 0 0.00
enq: TX - contention 4 0.00 0 19 0.00
PX Deq Credit: send blkd 448 72.10 0 0 0.00
gc current split 4 0.00 0 15 0.00
wait for scn ack 16 0.00 0 3 0.00
enq: TD - KTF dump entries 21 0.00 0 1 0.00
rdbms ipc reply 83 0.00 0 0 0.00
IPC send completion sync 68 100.00 0 0 0.00
PX Deq: Signal ACK 233 36.05 0 0 0.00
enq: WL - contention 11 0.00 0 1 0.00
SQL*Net break/reset to client 8 0.00 0 1 0.00
library cache pin 14 0.00 0 0 0.00
latch: enqueue hash chains 35 0.00 0 0 0.00
KJC: Wait for msg sends to complete 92 0.00 0 0 0.00
cursor: pin S 2 0.00 0 2 0.00
lock escalate retry 18 77.78 0 0 0.00
enq: DR - contention 4 0.00 0 0 0.00
latch: session allocation 24 0.00 0 0 0.00
enq: JS - job run lock - synchronize 2 0.00 0 1 0.00
latch: messages 26 0.00 0 0 0.00
enq: MW - contention 4 0.00 0 0 0.00
latch: shared pool 4 0.00 0 0 0.00
ges inquiry response 2 0.00 0 0 0.00
enq: AF - task serialization 1 0.00 0 1 0.00
enq: TA - contention 2 0.00 0 0 0.00
enq: TX - allocate ITL entry 2 0.00 0 0 0.00
SQL*Net message from client 1,344,743 0.00 2,581,597 1920 2.69
gcs remote message 4,430,285 90.37 13,291 3 8.85
Streams AQ: qmn slave idle wait 279 0.72 7,092 25419 0.00
DIAG idle wait 35,105 0.00 6,999 199 0.07
PX Idle Wait 2,942 93.88 6,999 2379 0.01
ges remote message 159,359 91.88 6,980 44 0.32
virtual circuit status 239 100.00 6,975 29183 0.00
Streams AQ: qmn coordinator idle wait 397 63.98 6,963 17539 0.00
Streams AQ: waiting for time management or cleanup tasks 24 0.00 6,768 281987 0.00
jobq slave wait 51 94.12 141 2766 0.00
PX Deq: Execution Msg 657 6.85 2 3 0.00
PX Deq: Join ACK 400 35.75 0 1 0.00
PX Deq: Parse Reply 363 33.33 0 0 0.00
PX Deq: Msg Fragment 279 1.43 0 0 0.00
PX Deq: Execute Reply 331 34.74 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 537 100.00 0 0 0.00
class slave wait 6 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
Log archive I/O 40,270 0.00 3,502 87 0.08
log file parallel write 334,080 0.00 1,702 5 0.67
db file parallel write 79,274 0.00 898 11 0.16
log file sequential read 40,620 0.00 709 17 0.08
events in waitclass Other 214,341 70.97 231 1 0.43
control file parallel write 4,586 0.00 169 37 0.01
control file sequential read 23,947 0.00 79 3 0.05
direct path read 12,137 0.00 4 0 0.02
direct path write 5,237 0.00 2 0 0.01
db file sequential read 76 0.00 1 8 0.00
latch: redo writing 20 0.00 1 27 0.00
os thread startup 11 0.00 1 47 0.00
row cache lock 992 0.00 1 1 0.00
log file single write 126 0.00 0 3 0.00
enq: HW - contention 1,111 0.00 0 0 0.00
buffer busy waits 266 28.57 0 1 0.00
latch: cache buffers chains 275 0.00 0 1 0.00
log buffer space 1 0.00 0 169 0.00
gc cr block busy 1 0.00 0 78 0.00
gc cr block congested 1 0.00 0 59 0.00
gc cr multi block request 556 0.00 0 0 0.00
gc current block 2-way 182 0.00 0 0 0.00
gc cr block 2-way 157 0.00 0 0 0.00
library cache lock 111 0.00 0 0 0.00
enq: TM - contention 214 0.00 0 0 0.00
gc current grant 2-way 49 0.00 0 0 0.00
gc current grant busy 21 0.00 0 0 0.00
gc current grant congested 1 0.00 0 5 0.00
gc current multi block request 21 0.00 0 0 0.00
gc cr grant 2-way 8 0.00 0 0 0.00
latch: row cache objects 2 0.00 0 0 0.00
rdbms ipc message 464,267 24.80 81,401 175 0.93
gcs remote message 4,430,289 90.37 13,291 3 8.85
DIAG idle wait 35,105 0.00 6,999 199 0.07
pmon timer 3,577 100.00 6,998 1957 0.01
ges remote message 159,359 91.88 6,980 44 0.32
Streams AQ: qmn coordinator idle wait 397 63.98 6,963 17539 0.00
Streams AQ: waiting for time management or cleanup tasks 24 0.00 6,768 281987 0.00
smon timer 245 0.82 6,758 27585 0.00
PX Deq: Join ACK 58 41.38 0 1 0.00
PX Deq: Parse Reply 50 44.00 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 537 100.00 0 0 0.00
PX Deq: Execute Reply 32 50.00 0 0 0.00
class slave wait 1 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 512,545
AVG_IDLE_TIME 204,791
AVG_IOWAIT_TIME 8,690
AVG_SYS_TIME 14,008
AVG_USER_TIME 498,340
BUSY_TIME 4,102,113
IDLE_TIME 1,639,965
IOWAIT_TIME 70,602
SYS_TIME 113,668
USER_TIME 3,988,445
LOAD 1
OS_CPU_WAIT_TIME ###############
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 443,858,944
VM_OUT_BYTES 4,354,048
PHYSICAL_MEMORY_BYTES 51,507,392,512
NUM_CPUS 8
NUM_CPU_SOCKETS 8

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
db 50,447.80 37,503.00 851,903 952,973,955
SYS$USERS 3,604.50 2,233.30 352,702 57,869,708
SYS$BACKGROUND 0.00 0.00 12,544 19,776,100
dbXDB 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
db 495473 167510 35212 2176 0 0 1962014 31744
SYS$USERS 68585 43044 464 153 0 0 284620 37
SYS$BACKGROUND 21177 3187 1726 177 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
10,526 8,610 4,635 2.27 19.43 7qfa96rjvwpn7   select upper(trim(Contra...
10,455 8,694 4,634 2.26 19.29 0a427kdru2y2z   select upper(trim(Contra...
10,306 8,376 4,662 2.21 19.02 9fkdpsxmxuuuc   select sum(tradeFee) as ...
6,796 5,535 4,604 1.48 12.54 cufhzatnw3p2q   select trim(c1.contractid)...
1,762 1,386 594 2.97 3.25 00rx13qt6xnt1 ftloader@ftloader-comp (TNS V1-V3) UPDATE S_UPLOADFILE SET VERIFY...
1,409 500 3 469.81 2.60 crg3ddq082jcd ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
919 624 66 13.92 1.70 3dtxbtwzff3xg ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
899 749 3 299.58 1.66 4vdwptg0zy9c2 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
801 503 66 12.13 1.48 2tjgtuv9y423b ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
728 93 1 728.48 1.34 dn6qa7w7wpuz3 ftloader@ftloader-exch (TNS V1-V3) DELETE FROM B_EXCHANGECLIENTIN...
717 627 137 5.23 1.32 ff05sfkwgqd82   select count(*) from ...
642 272 66 9.73 1.19 f3s0860d6xzx4 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
631 540 115 5.48 1.16 brq34n0ckh30z   select * from (select row...
563 293 66 8.53 1.04 7atxcf47w434k ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
560 215 66 8.49 1.03 5w0bk6653fd31 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...

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
8,694 10,455 4,634 1.88 19.29 0a427kdru2y2z   select upper(trim(Contra...
8,610 10,526 4,635 1.86 19.43 7qfa96rjvwpn7   select upper(trim(Contra...
8,376 10,306 4,662 1.80 19.02 9fkdpsxmxuuuc   select sum(tradeFee) as ...
5,535 6,796 4,604 1.20 12.54 cufhzatnw3p2q   select trim(c1.contractid)...
1,386 1,762 594 2.33 3.25 00rx13qt6xnt1 ftloader@ftloader-comp (TNS V1-V3) UPDATE S_UPLOADFILE SET VERIFY...
749 899 3 249.58 1.66 4vdwptg0zy9c2 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
627 717 137 4.57 1.32 ff05sfkwgqd82   select count(*) from ...
624 919 66 9.46 1.70 3dtxbtwzff3xg ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
540 631 115 4.70 1.16 brq34n0ckh30z   select * from (select row...
503 801 66 7.63 1.48 2tjgtuv9y423b ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
500 1,409 3 166.74 2.60 crg3ddq082jcd ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
293 563 66 4.43 1.04 7atxcf47w434k ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
272 642 66 4.13 1.19 f3s0860d6xzx4 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
215 560 66 3.26 1.03 5w0bk6653fd31 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
93 728 1 93.46 1.34 dn6qa7w7wpuz3 ftloader@ftloader-exch (TNS V1-V3) DELETE FROM B_EXCHANGECLIENTIN...

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
192,202,473 4,634 41,476.58 18.64 8693.54 10454.86 0a427kdru2y2z   select upper(trim(Contra...
190,799,125 4,635 41,164.86 18.51 8610.03 10526.42 7qfa96rjvwpn7   select upper(trim(Contra...
190,701,018 4,662 40,905.41 18.50 8375.69 10305.82 9fkdpsxmxuuuc   select sum(tradeFee) as ...
103,669,260 4,604 22,517.22 10.06 5535.32 6795.94 cufhzatnw3p2q   select trim(c1.contractid)...
44,146,735 3 14,715,578.33 4.28 748.75 898.75 4vdwptg0zy9c2 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
42,757,619 66 647,842.71 4.15 624.05 918.90 3dtxbtwzff3xg ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
37,882,718 3 12,627,572.67 3.67 500.21 1409.42 crg3ddq082jcd ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
31,382,793 66 475,496.86 3.04 278.48 405.66 60x3brjwuf8wg ftloader@ftloader-comp (TNS V1-V3) DELETE FROM H_COMPCLIENTTRADE ...
25,874,103 66 392,031.86 2.51 272.33 642.14 f3s0860d6xzx4 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
24,783,669 66 375,510.14 2.40 215.31 560.20 5w0bk6653fd31 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
24,719,424 594 41,615.19 2.40 1386.15 1761.63 00rx13qt6xnt1 ftloader@ftloader-comp (TNS V1-V3) UPDATE S_UPLOADFILE SET VERIFY...
22,905,051 66 347,046.23 2.22 503.43 800.59 2tjgtuv9y423b ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
13,953,735 66 211,420.23 1.35 292.59 563.19 7atxcf47w434k ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
10,597,483 66 160,567.92 1.03 263.86 364.26 fnk9j5amqb284 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...

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
256,387 3 85,462.33 21.07 500.21 1409.42 crg3ddq082jcd ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
168,832 1 168,832.00 13.87 93.46 728.48 dn6qa7w7wpuz3 ftloader@ftloader-exch (TNS V1-V3) DELETE FROM B_EXCHANGECLIENTIN...
53,056 3 17,685.33 4.36 748.75 898.75 4vdwptg0zy9c2 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
41,779 66 633.02 3.43 215.31 560.20 5w0bk6653fd31 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
39,597 2 19,798.50 3.25 159.55 194.53 5s1ygwu1wftc7 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
29,008 66 439.52 2.38 624.05 918.90 3dtxbtwzff3xg ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
23,321 66 353.35 1.92 272.33 642.14 f3s0860d6xzx4 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
22,302 135 165.20 1.83 3.37 206.78 asw9wyj0jrdya   select * from (select row...
11,803 66 178.83 0.97 292.59 563.19 7atxcf47w434k ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
9,381 27 347.44 0.77 22.94 107.63 bma6nqksqd6nk ftloader@ftloader-comp (TNS V1-V3) DELETE FROM B_CLIENT WHERE COM...

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
13,990 13,990 1.00 0.00 0.01 94q21h4pxztn5   insert into S_querylog2 (Use...
9,327 862 0.09 0.00 0.00 8qf6j91mzyd8b   select trim(companyid) as...
8,145 8,145 1.00 0.00 0.00 80xjxz9ng49d0   select nvl(sum(amount), 0)*(-1...
8,111 8 0.00 0.00 0.00 dfukfxgqzt4zr   select trim(UPLOADDATE) a...
7,189 1,225 0.17 0.00 0.00 419wzfvahqftd   select trim(companyid) as comp...
6,078 6,078 1.00 0.00 0.00 c8rabv4fbn0m2   select count(*) cnt from S_UPL...
5,561 5,561 1.00 0.00 0.00 44wagnxkb429q   select trim(tradedate) as trad...
4,705 4,705 1.00 0.00 0.01 2p2kkxfafykma   select cf.LastRIGHTByDate as...
4,688 977 0.21 0.00 0.00 cnt7yg6vxwjsr   select trim(tradedate) as...
4,662 4,660 1.00 1.80 2.21 9fkdpsxmxuuuc   select sum(tradeFee) as ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
9,327 9,327 4.11 8qf6j91mzyd8b   select trim(companyid) as...
8,122 8,145 3.58 80xjxz9ng49d0   select nvl(sum(amount), 0)*(-1...
8,062 8,111 3.55 dfukfxgqzt4zr   select trim(UPLOADDATE) a...
6,637 7,189 2.92 419wzfvahqftd   select trim(companyid) as comp...
4,705 4,705 2.07 2p2kkxfafykma   select cf.LastRIGHTByDate as...
4,688 4,688 2.06 cnt7yg6vxwjsr   select trim(tradedate) as...
4,662 4,662 2.05 9fkdpsxmxuuuc   select sum(tradeFee) as ...
4,648 4,648 2.05 c0jxhvv0t9aa5   select trim(f.UPLOADDATE) as U...
4,637 4,637 2.04 59sx298kg9vtk   select upper(trim(l.contrac...
4,635 4,635 2.04 7qfa96rjvwpn7   select upper(trim(Contra...
4,634 4,634 2.04 0a427kdru2y2z   select upper(trim(Contra...
4,626 4,626 2.04 6mn3ma8z2v8tz   select upper(trim(p.contracti...
4,604 4,604 2.03 cufhzatnw3p2q   select trim(c1.contractid)...
4,591 4,591 2.02 468szzx5xjkj7   select trim(h.UPLOADDATE) as U...
4,571 4,571 2.01 df7g4a1dgjhut   select trim(UPLOADDATE...
3,993 4,660 1.76 6k24bmcwygp73   select cf.LastRIGHTByDate as L...
3,916 6,078 1.72 c8rabv4fbn0m2   select count(*) cnt from S_UPL...
3,895 5,561 1.72 44wagnxkb429q   select trim(tradedate) as trad...
3,596 3,667 1.58 6jk9yfhybspy8   select sum(h.DELIVMA...
3,521 3,533 1.55 8acpt198p5sth   select upper(trim(p.contractid...
3,498 3,553 1.54 cvvqarnj98y1n   select upper(trim(ContractID))...
3,467 3,477 1.53 2uhw1qu31ttbj   select sum(tradeFee) as amoun...
3,466 3,487 1.53 gmwrfynvhknk1   select trim(f.UPLOADDATE) as U...
3,463 13,990 1.53 94q21h4pxztn5   insert into S_querylog2 (Use...
2,950 3,767 1.30 c8n9a2kcjgq2u   update S_queryUser2 set co...
2,806 2,831 1.24 dyqs2ztpgy41s   select trim(h.UPLOADDATE) as U...
2,798 2,814 1.23 0u8qy3vqqtsxd   select trim(tradedate) as trad...
2,768 2,786 1.22 4tp3fbb7gcj01   select trim(UPLOADDATE) as UP...
2,704 2,778 1.19 1u6jbdkmv48r3   select sum(amou...
2,676 2,838 1.18 cr1x70pknnc24   select sum(p.tradema...
2,655 2,655 1.17 93qahzxxy05yk   select sum(iofund) as iof...
2,641 2,641 1.16 2m4pb8z36g8dm   select sum(p.tradem...
2,639 2,639 1.16 4kq5x7a4z4u61   select sum...
2,627 2,746 1.16 7ggnhx1n3c34q   select sum(iofund) as iofundSu...
2,623 2,623 1.16 5wznbubjmu151   select sum(h.DELI...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,356,809 2 0.11 31a13pnjps7j3   SELECT source, (case w...
1,369,275 1,369 0.07 bd13sdj0ty0q4 SQL Loader Conventional Path Load SELECT 'X' FROM SYS.ALL_OBJECT...
1,357,750 5 0.06 8vkjh60z1g287   select OBJOID, CLSOID, RUNT...
1,089,792 4 0.05 10xj8nynmpqtq   SELECT dbin.db_name, dbin.ins...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
49 13,990 94q21h4pxztn5   insert into S_querylog2 (Use...
41 1,622 4jvyst13gg4t8   select trim(q.preregdate) as p...
36 3,553 cvvqarnj98y1n   select upper(trim(ContractID))...
32 4,660 6k24bmcwygp73   select cf.LastRIGHTByDate as L...
31 3,533 8acpt198p5sth   select upper(trim(p.contractid...
30 26 19rkm1wsf9axx   insert into WRI$_ALERT_HISTORY...
29 7,189 419wzfvahqftd   select trim(companyid) as comp...
28 3,477 2uhw1qu31ttbj   select sum(tradeFee) as amoun...
27 2 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...
27 504 5xacdx058vm1t   select upper(trim(l.contractid...
27 504 5xacdx058vm1t   select upper(trim(l.contractid...
27 2 fqvb8jxywth8n   SELECT startsn.sga_size_factor...
27 2 gvynt9bqh451z   SELECT sum(case when snap_id ...
26 2,838 cr1x70pknnc24   select sum(p.tradema...
26 2 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
24 4 10xj8nynmpqtq   SELECT dbin.db_name, dbin.ins...
23 535 0bd6u57cgk3jq   select trim(c1.contractid) as ...
23 30 0dnc5mcnwhq8s   select trim(UPLOADDATE) as UP...
23 2 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
23 2 31a13pnjps7j3   SELECT source, (case w...
23 512 59g4fnnu5c6jg   select upper(trim(ContractID))...
22 2 b5yyh2vc9g8tm   SELECT sx.id, sum(decode(e.sn...
22 158 c1589w2xp12tj   select trim(companyid) as comp...
22 35 fkxkgy66sgyh5   select trim(CLIENTID) ...
21 2 5an8d9ctcysja   SELECT (case when snap_id = ...
21 30 d3txjhzy7ha0v   select trim(f.UPLOADDATE) as U...
21 31 dnjd7yg94f5g6   select trim(l.tradedate) as t...

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
213.99 61.37 348.70 137.66 140 audcbn70dd6d3   select trim(ca.bankid) as bank...
166.40 29.55 563.19 292.59 66 7atxcf47w434k ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
158.91 19.85 800.59 503.43 66 2tjgtuv9y423b ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
156.85 1.50 10,454.86 8,693.54 4,634 0a427kdru2y2z   select upper(trim(Contra...
154.47 1.47 10,526.42 8,610.03 4,635 7qfa96rjvwpn7   select upper(trim(Contra...
151.58 10.75 1,409.42 500.21 3 crg3ddq082jcd ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
146.76 1.42 10,305.82 8,375.69 4,662 9fkdpsxmxuuuc   select sum(tradeFee) as ...
129.11 33.44 386.11 199.48 66 9wptn3zs4wxhg ftloader@ftloader-comp (TNS V1-V3) DELETE FROM B_CLIACC WHERE SUB...
112.11 17.46 642.14 272.33 66 f3s0860d6xzx4 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
111.34 1.64 6,795.94 5,535.32 4,604 cufhzatnw3p2q   select trim(c1.contractid)...
99.59 10.84 918.90 624.05 66 3dtxbtwzff3xg ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
90.47 16.15 560.20 215.31 66 5w0bk6653fd31 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
86.52 11.88 728.48 93.46 1 dn6qa7w7wpuz3 ftloader@ftloader-exch (TNS V1-V3) DELETE FROM B_EXCHANGECLIENTIN...
82.21 66.89 122.91 23.50 13,990 94q21h4pxztn5   insert into S_querylog2 (Use...
63.40 45.97 137.92 64.36 39 cmv9h31tgyvku ftloader@ftloader-comp (TNS V1-V3) INSERT INTO H_COMPCLIENTLIQUID...
55.40 13.66 405.66 278.48 66 60x3brjwuf8wg ftloader@ftloader-comp (TNS V1-V3) DELETE FROM H_COMPCLIENTTRADE ...
29.55 3.29 898.75 748.75 3 4vdwptg0zy9c2 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
27.93 24.82 112.54 55.46 2 bn5vag98hwdsc ftloader@ftloader-exch (TNS V1-V3) INSERT INTO B_EXCHANGECLIENTIN...
26.63 16.67 159.77 106.07 27 9f865pzcfwb27 ftloader@ftloader-comp (TNS V1-V3) DELETE FROM H_COMPCLIENTLIQUID...
22.58 6.20 364.26 263.86 66 fnk9j5amqb284 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
20.20 6.02 335.83 237.81 66 17gr1mx53vanf ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
19.28 15.65 123.23 24.63 28 9gx5ddb42jj2p ftloader@ftloader-comp (TNS V1-V3) DELETE FROM B_EXCHANGECLIENTMA...
13.53 31.90 42.42 17.57 4,705 2p2kkxfafykma   select cf.LastRIGHTByDate as...
11.52 0.65 1,761.63 1,386.15 594 00rx13qt6xnt1 ftloader@ftloader-comp (TNS V1-V3) UPDATE S_UPLOADFILE SET VERIFY...
11.41 4.08 279.45 176.47 66 313g1fc4xtatq ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
9.01 8.38 107.63 22.94 27 bma6nqksqd6nk ftloader@ftloader-comp (TNS V1-V3) DELETE FROM B_CLIENT WHERE COM...
8.28 66.61 12.42 3.47 3,767 c8n9a2kcjgq2u   update S_queryUser2 set co...
7.81 3.78 206.78 3.37 135 asw9wyj0jrdya   select * from (select row...
7.18 85.31 8.42 1.51 6,078 c8rabv4fbn0m2   select count(*) cnt from S_UPL...
5.88 3.02 194.53 159.55 2 5s1ygwu1wftc7 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
5.77 19.24 30.00 6.85 4,660 6k24bmcwygp73   select cf.LastRIGHTByDate as L...
5.01 25.30 19.80 6.96 7,189 419wzfvahqftd   select trim(companyid) as comp...
4.72 58.55 8.06 4.06 3,553 cvvqarnj98y1n   select upper(trim(ContractID))...
4.56 1.64 278.71 179.19 66 1w8xha904vdan ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
4.13 1.39 297.85 168.95 66 4gmpxsqc0h8cm ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
3.53 2.22 159.47 118.71 2 d280mar5508fn ftloader@ftloader-exch (TNS V1-V3) UPDATE D_EXCLIENT SET COMPANYI...
2.41 72.47 3.33 1.25 1,369 bd13sdj0ty0q4 SQL Loader Conventional Path Load SELECT 'X' FROM SYS.ALL_OBJECT...
2.35 17.28 13.60 4.47 3,533 8acpt198p5sth   select upper(trim(p.contractid...
2.33 69.17 3.37 1.40 8,145 80xjxz9ng49d0   select nvl(sum(amount), 0)*(-1...
1.88 64.11 2.94 1.28 2,838 cr1x70pknnc24   select sum(p.tradema...
1.76 0.88 200.05 154.05 66 dqfqqs8zdc3ts ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
1.55 5.84 26.58 1.67 3,477 2uhw1qu31ttbj   select sum(tradeFee) as amoun...
1.48 62.64 2.36 1.22 1,330 4fbht24hmaa02   select max(filedate) as tradeD...
1.48 82.51 1.79 0.39 1,622 4jvyst13gg4t8   select trim(q.preregdate) as p...
1.06 0.54 198.57 152.27 66 2257cdtq938fc ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
1.06 0.53 198.43 152.15 66 g0y0fp5byjxs3 ftloader@ftloader-comp (TNS V1-V3) UPDATE S_UPLOADFILE SET VERIFY...
1.03 76.00 1.35 0.89 2,746 7ggnhx1n3c34q   select sum(iofund) as iofundSu...
0.97 55.67 1.74 1.11 3,487 gmwrfynvhknk1   select trim(f.UPLOADDATE) as U...
0.92 34.59 2.65 1.10 4,637 59sx298kg9vtk   select upper(trim(l.contrac...
0.82 22.62 3.61 1.48 535 0bd6u57cgk3jq   select trim(c1.contractid) as ...
0.81 12.26 6.60 2.85 2,814 0u8qy3vqqtsxd   select trim(tradedate) as trad...
0.72 70.21 1.03 0.39 981 aq4js2gkfjru8   update tsq$ set blocks=:3, max...
0.71 24.11 2.94 0.46 504 5xacdx058vm1t   select upper(trim(l.contractid...
0.70 46.96 1.49 0.78 4,626 6mn3ma8z2v8tz   select upper(trim(p.contracti...
0.67 56.43 1.18 0.48 4,688 cnt7yg6vxwjsr   select trim(tradedate) as...
0.65 0.59 111.63 90.39 39 2rpnyuc0wvx72 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
0.57 0.26 218.13 165.04 66 1jr81ad0apv3x ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
0.55 0.26 208.32 156.78 66 frq14xm1pp8dj ftloader@ftloader-comp (TNS V1-V3) UPDATE S_UPLOADFILE SET VERIFY...
0.53 24.57 2.18 0.92 2,641 2m4pb8z36g8dm   select sum(p.tradem...
0.50 63.71 0.78 0.57 2,778 1u6jbdkmv48r3   select sum(amou...
0.30 16.90 1.77 0.58 2,639 4kq5x7a4z4u61   select sum...
0.21 3.52 5.90 0.18 31 dnjd7yg94f5g6   select trim(l.tradedate) as t...
0.19 4.56 4.07 3.73 2,786 4tp3fbb7gcj01   select trim(UPLOADDATE) as UP...
0.18 15.81 1.12 0.63 2,655 93qahzxxy05yk   select sum(iofund) as iof...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
00rx13qt6xnt1UPDATE S_UPLOADFILE SET VERIFYRESULT=DECODE(:B6 , 0, 'Y', 'N'), VERIFYDATE=:B5 , LASTVERIFYTIME=TO_CHAR(SYSDATE, 'HH24:MI:SS') WHERE TRIM(FILEDATE)=:B4 AND UPPER(ORGTYPEID)=:B3 AND TRIM(ORGANID)=:B2 AND FILEID=:B1
0a427kdru2y2z select upper(trim(ContractID)) as ContractID, trim(exchangeid) as exchangeid, trim(TradeSeq) as TradeSeq, trim(tradetime) as tradetime, upper(trim(BSTag)) as BSTag, upper(trim(VHFlag)) as VHFlag, Price, Volumn, Amount, upper(trim(OCTag)) as OCTag, TradeFee, CloseProfitByTrade, CloseProfit from H_CompClientTrade where clientid=:1 and TradeDate=:2 order by upper(trim(ContractID)), trim(TradeSeq)
0bd6u57cgk3jqselect trim(c1.contractid) as contractid, trim(c1.tradeseq) as tradeseq, upper(trim(c1.bstag)) as bstag, c1.position as position, c1.openprice as openprice, c1.lastsettleprice as lastsettleprice, c1.settleprice as settleprice, c1.positionprofitbydate as positionprofitbydate, c1.positionprofitbytrade as positionprofitbytrade, upper(trim(c1.vhflag)) as vhflag, trim(c1.tradeseq) as tradeseq, trim(exclientid) as exclientid from h_compclientposdetail c1 where c1.clientid=:1 and c1.TradeDate=:2 order by decode(exchangeid, 'S', 1, 'Z', 2, 'D', 3, 'J', 4, 5), contractid, c1.tradeseq
0dnc5mcnwhq8sselect trim(UPLOADDATE) as UPLOADDATE, trim(COMPANYID) as COMPANYID, trim(TRADEDATE) as TRADEDATE , trim(a.EXCHANGEID) as EXCHANGEID , trim(COMPCLIENTID ) as COMPCLIENTID , trim(CLIENTID) as CLIENTID , trim(a.COMMODITYID ) as COMMODITYID , VOLUMN , PRICE , AMOUNT , trim(CHECKTAG) as CHECKTAG from H_COMPMORTGAGEDETAILS a where CLIENTID=:1 and TRADEDATE between :2 and :3 order by TradeDate
0u8qy3vqqtsxdselect trim(tradedate) as tradedate, iofund as iofund, trim(note) as type, trim(note) as note from h_compclientfunddetail where clientid=:1 and TradeDate=:2
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
17gr1mx53vanfbegin up_ChkCompUploadFile_3004(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
19rkm1wsf9axxinsert into WRI$_ALERT_HISTORY (sequence_id, reason_id, owner, object_name, subobject_name, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, resolution, metric_value) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29)
1jr81ad0apv3xbegin up_ChkCompUploadFile_3009(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
1u6jbdkmv48r3select sum(amount) as amountSum from h_compclientotherfund where clientid=:1 and TradeDate=:2 and upper(fundtype) not in ('A000', 'A001', 'A003', 'A008')
1w8xha904vdanbegin up_ChkCompUploadFile_3007(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
2257cdtq938fcbegin up_ChkCompUploadFile_3014(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
2m4pb8z36g8dm select sum(p.trademargin) as trademarginsum from h_compclientpos p where p.clientid=:1 and p.TradeDate=:2
2p2kkxfafykma select cf.LastRIGHTByDate as LastRIGHTByDate, cf.LastRIGHTByTrade as LastRIGHTByTrade, cf.TodayRIGHTByDate as TodayRIGHTByDate, cf.TodayRIGHTByTrade as TodayRIGHTByTrade, cf.TotalRights as TotalRights, cf.FreeFund as FreeFund, cf.riskrate as riskrate, cf.MARGINREQUIRED as MARGINREQUIRED, cf.FloatProfitByTrade as FloatProfitByTrade, cf.TodayProfitByDate as TodayProfitByDate, cf.TodayProfitByTrade as TodayProfitByTrade, cf.mortgage as mortgage from h_CompClientFund cf where cf.clientid=:1 and cf.TradeDate=:2
2rpnyuc0wvx72begin up_ChkCompUploadFile_3013(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
2tjgtuv9y423bbegin up_ChkCompUploadFile_3011(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
2uhw1qu31ttbjselect sum(tradeFee) as amount from h_compclienttrade where clientid=:1 and TradeDate=:2
313g1fc4xtatqbegin up_ChkCompUploadFile_3008(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
3dtxbtwzff3xgbegin up_ChkCompUploadFile_3006(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
419wzfvahqftdselect trim(companyid) as companyid, sum(amount) as amount from h_compclientotherfund where clientid=:1 and TradeDate=:2 and upper(trim(fundtype))=:3 group by companyid
44wagnxkb429qselect trim(tradedate) as tradedate, upper(trim(flag)) as flag from s_tradedate where tradedate=:1
468szzx5xjkj7select trim(h.UPLOADDATE) as UPLOADDATE, trim(h.COMPANYID) as COMPANYID, trim(h.TRADEDATE) as TRADEDATE, trim(h.EXCLIENTID) as EXCLIENTID, trim(h.EXCHANGEID) as EXCHANGEID, trim(h.COMPCLIENTID) as COMPCLIENTID, trim(h.CONTRACTID) as CONTRACTID, trim(h.CLIENTID) as CLIENTID, trim(h.TRADESEQ) as TRADESEQ, trim(h.BSTAG) as BSTAG, h.POSITION as POSITION, h.DELIVMARGIN as DELIVMARGIN, h.OPENPRICE as OPENPRICE, h.DELIVSETTLEPRICE as DELIVSETTLEPRICE, trim(h.CHECKTAG) as CHECKTAG, trim(h.NONSETTLEMEMDATA) as NONSETTLEMEMDATA, trim(e.EXCHANGENAME) as EXCHANGENAME from H_COMPDELIVCONTRACTDATA h, b_exchange e where h.EXCHANGEID=e.EXCHANGEID(+) and h.CLIENTID=:1 and h.TRADEDATE=:2
4fbht24hmaa02select max(filedate) as tradeDate from S_UPLOADFILE cf where cf.ORGANID=:1
4gmpxsqc0h8cmbegin up_ChkCompUploadFile_3005(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
4jvyst13gg4t8select trim(q.preregdate) as preregdate, trim(q.preregtime) as preregtime, trim(q.userid) as userid, trim(q.password) as password, trim(q.companyid) as companyid, trim(u.typename) as clientType from s_queryuserprereg q, s_queryusertype u where q.clienttype=u.typecode and q.userid =trim(:1)
4kq5x7a4z4u61 select sum(amount) as amountSum from h_compclientotherfund where clientid=:1 and TradeDate=:2 and upper(fundtype) not in ('A000', 'A001', 'A003', 'A008')
4tp3fbb7gcj01select trim(UPLOADDATE) as UPLOADDATE, trim(COMPANYID) as COMPANYID, trim(TRADEDATE) as TRADEDATE , trim(a.EXCHANGEID) as EXCHANGEID , trim(COMPCLIENTID ) as COMPCLIENTID , trim(CLIENTID) as CLIENTID , trim(a.COMMODITYID ) as COMMODITYID , VOLUMN , PRICE , AMOUNT , trim(CHECKTAG) as CHECKTAG from H_COMPMORTGAGEDETAILS a where CLIENTID=:1 and TRADEDATE=:2
4vdwptg0zy9c2begin up_ChkExchUploadFile_2004(PI_TRADEDATE=>:PI_TRADEDATE, PI_EXCHID=>:PI_EXCHID, PO_ERRORID=>:PO_ERRORID); end;
59g4fnnu5c6jgselect upper(trim(ContractID)) as ContractID, trim(exchangeid) as exchangeid, trim(TradeSeq) as TradeSeq, trim(tradetime) as tradetime, upper(trim(BSTag)) as BSTag, upper(trim(VHFlag)) as VHFlag, Price, Volumn, Amount, upper(trim(OCTag)) as OCTag, TradeFee, CloseProfitByTrade, CloseProfit from H_CompClientTrade where clientid=:1 and TradeDate=:2 order by tradetime, decode(exchangeid, 'S', 1, 'Z', 2, 'D', 3, 'J', 4, 5), trim(TradeSeq)
59sx298kg9vtk select upper(trim(l.contractid)) as contractid, trim(l.tradeseq) as tradeseq, trim(l.bstag) as bstag, l.liquidprice as liquidprice, l.openprice as openprice, l.volumn as volumn, l.lastsettleprice as lastsettleprice, l.closeprofitbydate as closeprofitbydate, l.closeprofitbytrade as closeprofitbytrade, trim(l.opentradeseq) as opentradeseq from h_compclientliquid l where l.clientid=:1 and l.TradeDate=:2 order by upper(trim(l.contractid)), trim(l.tradeseq)
5an8d9ctcysjaSELECT (case when snap_id = :startsn then 1 else 0 end) as start_snap, (case when name = 'maximum PGA allocated' then 1 when name = 'total PGA allocated' then 2 when name = 'over allocation count' then 3 when name = 'recompute count (total)' then 4 else 0 end) as stat_id, value FROM WRH$_PGASTAT pga WHERE pga.dbid = :dbid AND pga.instance_number = :instance_number AND (pga.snap_id = :startsn OR pga.snap_id = :endsn) AND pga.name IN ( 'maximum PGA allocated' , 'total PGA allocated' , 'over allocation count' , 'recompute count (total)' ) ORDER BY snap_id, stat_id
5s1ygwu1wftc7begin up_ChkExchUploadFile_2006(PI_TRADEDATE=>:PI_TRADEDATE, PI_EXCHID=>:PI_EXCHID, PO_ERRORID=>:PO_ERRORID); end;
5w0bk6653fd31begin up_ChkCompUploadFile_3001(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
5wznbubjmu151 select sum(h.DELIVMARGIN) as DELIVMARGINsum from H_COMPDELIVCONTRACTDATA h where h.CLIENTID=:1 and h.TRADEDATE=:2
5xacdx058vm1tselect upper(trim(l.contractid)) as contractid, trim(l.tradeseq) as tradeseq, trim(l.bstag) as bstag, l.liquidprice as liquidprice, l.openprice as openprice, l.volumn as volumn, l.lastsettleprice as lastsettleprice, l.closeprofitbydate as closeprofitbydate, l.closeprofitbytrade as closeprofitbytrade, trim(l.opentradeseq) as opentradeseq from h_compclientliquid l where l.clientid=:1 and l.TradeDate=:2 order by decode(exchangeid, 'S', 1, 'Z', 2, 'D', 3, 'J', 4, 5), tradeseq, opentradeseq
60x3brjwuf8wgDELETE FROM H_COMPCLIENTTRADE WHERE TRADEDATE=:B2 AND COMPANYID=:B1
6jk9yfhybspy8select sum(h.DELIVMARGIN) as DELIVMARGINsum from H_COMPDELIVCONTRACTDATA h where h.CLIENTID=:1 and h.TRADEDATE=:2
6k24bmcwygp73select cf.LastRIGHTByDate as LastRIGHTByDate, cf.LastRIGHTByTrade as LastRIGHTByTrade, cf.TodayRIGHTByDate as TodayRIGHTByDate, cf.TodayRIGHTByTrade as TodayRIGHTByTrade, cf.TotalRights as TotalRights, cf.FreeFund as FreeFund, cf.riskrate as riskrate, cf.MARGINREQUIRED as MARGINREQUIRED, cf.FloatProfitByTrade as FloatProfitByTrade, cf.TodayProfitByDate as TodayProfitByDate, cf.TodayProfitByTrade as TodayProfitByTrade, cf.mortgage as mortgage from h_CompClientFund cf where cf.clientid=:1 and cf.TradeDate=:2
6mn3ma8z2v8tz select upper(trim(p.contractid)) as contractid, p.position as position, p.averageprice as averageprice, p.lastsettleprice as lastsettleprice, p.settleprice as settleprice, p.positionprofitbytrade as positionprofitbytrade, p.positionprofit as positionprofitbydate, p.tradedate as tradedate, p.trademargin as trademargin, upper(trim(p.vhflag)) as vhflag, upper(trim(p.bstag)) as bstag from h_compclientpos p where p.clientid=:1 and p.TradeDate=:2 order by upper(trim(p.contractid))
7atxcf47w434kbegin up_ChkCompUploadFile_3003(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
7ggnhx1n3c34qselect sum(iofund) as iofundSum from h_compclientfunddetail where clientid=:1 and TradeDate=:2
7qfa96rjvwpn7 select upper(trim(ContractID)) as ContractID, trim(exchangeid) as exchangeid, min(trim(TradeSeq)) as TradeSeq, upper(trim(BSTag)) as BSTag, upper(trim(VHFlag)) as VHFlag, Price, sum(Volumn) as Volumn, sum(Amount) as Amount, upper(trim(OCTag)) as OCTag, sum(TradeFee) as TradeFee, sum(CloseProfitByTrade) as CloseProfitByTrade, sum(CloseProfit) as CloseProfit from H_CompClientTrade where clientid=:1 and TradeDate=:2 group by ContractID, exchangeid, BSTag, VHFlag, Price, OCTag order by upper(trim(ContractID))
80xjxz9ng49d0select nvl(sum(amount), 0)*(-1) DELIVFEEsum from H_COMPCLIENTOTHERFUND where fundtype='A003' and CLIENTID=:1 and TRADEDATE=:2
8acpt198p5sthselect upper(trim(p.contractid)) as contractid, p.position as position, p.averageprice as averageprice, p.lastsettleprice as lastsettleprice, p.settleprice as settleprice, p.positionprofitbytrade as positionprofitbytrade, p.positionprofit as positionprofitbydate, p.tradedate as tradedate, p.trademargin as trademargin, upper(trim(p.vhflag)) as vhflag, upper(trim(p.bstag)) as bstag from h_compclientpos p where p.clientid=:1 and p.TradeDate=:2 order by decode(exchangeid, 'S', 1, 'Z', 2, 'D', 3, 'J', 4, 5), contractid
8qf6j91mzyd8b select trim(companyid) as companyid, sum(amount) as amount from h_compclientotherfund where clientid=:1 and TradeDate=:2 and upper(trim(fundtype))=:3 group by companyid
8vkjh60z1g287 select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
93qahzxxy05yk select sum(iofund) as iofundSum from h_compclientfunddetail where clientid=:1 and TradeDate=:2
94q21h4pxztn5insert into S_querylog2 (Userid, logDate, logTime, Type, Content, IPADDR) values (:1, to_char(SYSDATE, 'yyyy-mm-dd'), to_char(SYSDATE, 'hh24:mi:ss'), upper(:2), :3, :4)
9f865pzcfwb27DELETE FROM H_COMPCLIENTLIQUID WHERE TRADEDATE=:B2 AND COMPANYID=:B1
9fkdpsxmxuuuc select sum(tradeFee) as amount from h_compclienttrade where clientid=:1 and TradeDate=:2
9gx5ddb42jj2pDELETE FROM B_EXCHANGECLIENTMAP WHERE COMPANYID=:B1
9wptn3zs4wxhgDELETE FROM B_CLIACC WHERE SUBSTR(TRIM(CLIENTID), 1, 4)=:B1
aq4js2gkfjru8update tsq$ set blocks=:3, maxblocks=:4, grantor#=:5, priv1=:6, priv2=:7, priv3=:8 where ts#=:1 and user#=:2
asw9wyj0jrdyaselect * from (select rownum as tmp, a.* from ( select trim(l.userid) as userid, trim(l.logdate) as logdate, trim(l.logtime) as logtime, trim(l.type) as type, trim(l.content) as content, trim(l.ipaddr) as ipaddr from s_querylog2 l WHERE l.logdate>='2006-04-21' and upper(trim(l.type)) in('LOGIN', 'CHANGEPASSWORD', 'RESETPASSWORD') and l.userID=:1 order by l.userid, l.logdate desc, l.logtime desc, trim(l.type) ) a ) WHERE tmp>=:2 and tmp<=:3
audcbn70dd6d3select trim(ca.bankid) as bankid, trim(ca.bankaccount) as bankaccount, trim(ca.clientid) as clientid, trim(b.bankname) as bankname from b_cliacc ca, b_bank b where trim(ca.bankid) = trim(b.bankid(+)) and ca.clientid=:1
b5yyh2vc9g8tmSELECT sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id between :bid and :eid AND s.status = 0 AND x.ver_type = :exists_type ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = :inst_num AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.id
bd13sdj0ty0q4SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = 'TABLE'
bma6nqksqd6nkDELETE FROM B_CLIENT WHERE COMPANYID=:B1 AND CLIENTID IN ( SELECT CLIENTID FROM D_COMPCLIENTINFO WHERE OPENDATE=:B2 AND COMPANYID=:B1 AND UPPER(TRIM(STATUS))='A' )
bn5vag98hwdscINSERT INTO B_EXCHANGECLIENTINFO(EXCHANGEID, OPENDATE, NAME, IDENTITY, EXCOMPANYID, COMPANYID, EXCLIENTID, LOCATE, ADDRESS, POSTCODE, TELEPHONE, REALOPENDATE, CLIENTTYPE, ORGANCODE, BUSINESSCODE, DEPUTYNAME, DEPUTYIDENTITY, EXCLIENTIDTYPE) SELECT A.EXCHANGEID, A.OPENDATE, A.NAME, A.IDENTITY, A.EXCOMPANYID, A.COMPANYID, A.EXCLIENTID, A.LOCATE, A.ADDRESS, A.POSTCODE, A.TELEPHONE, A.REALOPENDATE, A.CLIENTTYPE, A.ORGANCODE, A.BUSINESSCODE, A.DEPUTYNAME, A.DEPUTYIDENTITY, NVL(A.EXCLIENTIDTYPE, '0') FROM D_EXCLIENT A WHERE A.OPENDATE=:B2 AND A.EXCHANGEID=:B1 AND COMPANYID IS NOT NULL
brq34n0ckh30z select * from (select rownum as tmp, a.* from (select trim(bt.FileDate) as fileDate, trim(bt.CompanyID) as CompanyID, trim(bt.shortName) as companyName, trim(bt.NameAbbr) as NameAbbr, trim(bt.FileName) as FileName, trim(bt.FileID) as FileID, trim(bt.Require) as Require, trim(u.UploadFlag) as UploadFlag, trim(u.LastUploadTime) as LastUploadTime, trim(u.VerifyDate) as VerifyDate, trim(u.VerifyResult) as VerifyResult, trim(u.LastVerifyTime) as LastVerifyTime, trim(u.UploadDate) as UploadDate from S_UploadFile u, (select trim(baseTable.baseDate) as fileDate, trim(c.companyID) as companyID, trim(c.companyName) as companyName, trim(c.shortName) as shortName, trim(fd.NameAbbr) as NameAbbr, trim(fd.FileName) as FileName, trim(fd.FileID) as FileID, trim(fd.Require) as Require, null as UploadFlag, null as LastUploadTime, null as VerifyDate, null as VerifyResult, null as LastVerifyTime, null as UploadDate from b_company c, S_UploadFileDef fd, ( select tradedate as baseDate from S_TRADEDATE whe re upper(flag)='Y' and tradedate<=to_char(systimestamp, 'yyyy-mm-dd') and tradedate>=to_char(add_months(systimestamp, -1), 'yyyy-mm-dd') ) baseTable where upper(trim(fd.orgtypeid)) = 'COMP' and c.companyID = :1 ) bt where trim(bt.fileDate) = trim(u.filedate(+)) and bt.fileDate >=to_char(add_months(systimestamp, -1), 'yyyy-mm-dd') and bt.companyID = trim(u.organID(+)) and trim(bt.FileID) = TRIM(u.fileid(+)) order by FileDate desc, fileid ) a ) WHERE tmp>=:2 and tmp<=:3
c0jxhvv0t9aa5select trim(f.UPLOADDATE) as UPLOADDATE, trim(f.COMPANYID) as COMPANYID, trim(f.TRADEDATE) as TRADEDATE, trim(f.COMPCLIENTID) as COMPCLIENTID, trim(f.CLIENTID) as CLIENTID, upper(trim(f.FUNDTYPE)) as FUNDTYPE, f.AMOUNT as AMOUNT, trim(f.CHECKTAG) as CHECKTAG, trim(f.EXCHANGEID) as EXCHANGEID, trim(e.EXCHANGENAME) as EXCHANGENAME, trim(o.FUNDNAME) as FUNDNAME, trim(f.note) as note from h_compclientotherfund f, b_exchange e, b_otherfund o where f.EXCHANGEID=e.EXCHANGEID(+) and upper(f.FUNDTYPE)=upper(o.FUNDTYPE(+)) and CLIENTID=:1 and TRADEDATE=:2 and upper(f.fundtype) not in ('A000', 'A001', 'A003', 'A008')
c1589w2xp12tjselect trim(companyid) as companyid, sum(amount) as amount from h_compclientotherfund where clientid=:1 and TradeDate between :2 and :3 and upper(trim(fundtype))=:4 group by companyid
c8n9a2kcjgq2uupdate S_queryUser2 set countlogintimes=countlogintimes+1, lastlogindate=to_char(SYSDATE, 'yyyy-mm-dd'), lastlogintime=to_char(SYSDATE, 'hh24:mi:ss') where Userid=:1
c8rabv4fbn0m2select count(*) cnt from S_UPLOADFILE where organid=:1 and filedate=:2 and HASCREATEDSTATICFILE <> 'Y' and fileid in ('3004', '3005', '3006', '3007', '3008', '3010', '3011', '3012', '3013')
cmv9h31tgyvkuINSERT INTO H_COMPCLIENTLIQUID(UPLOADDATE, TRADEDATE, COMPANYID, EXCLIENTID, EXCHANGEID, COMPCLIENTID, CLIENTID, TRADESEQ, CONTRACTID, BSTAG, LIQUIDPRICE, OPENPRICE, VOLUMN, LASTSETTLEPRICE, SETTLEPRICE, CLOSEPROFITBYDATE, CLOSEPROFITBYTRADE, CHECKTAG, OPENTRADESEQ, CURRENCY, TRANSDATE) SELECT /*+ FULL(D_CompClientLiquid) */ UPLOADDATE, TRADEDATE, COMPANYID, EXCLIENTID, UPPER(EXCHANGEID), COMPCLIENTID, TRIM(CLIENTID), TRADESEQ, UPPER(CONTRACTID), UPPER(BSTAG), LIQUIDPRICE, OPENPRICE, VOLUMN, LASTSETTLEPRICE, SETTLEPRICE, CLOSEPROFITBYDATE, CLOSEPROFITBYTRADE, CHECKTAG, OPENTRADESEQ, CURRENCY, TRANSDATE FROM D_COMPCLIENTLIQUID WHERE TRADEDATE=:B2 AND COMPANYID=:B1 AND CHECKTAG='0000'
cnt7yg6vxwjsr select trim(tradedate) as tradedate, iofund as iofund, trim(note) as type, trim(note) as note from h_compclientfunddetail where clientid=:1 and TradeDate=:2
cr1x70pknnc24select sum(p.trademargin) as trademarginsum from h_compclientpos p where p.clientid=:1 and p.TradeDate=:2
crg3ddq082jcdbegin up_ChkExchUploadFile_2001(PI_TRADEDATE=>:PI_TRADEDATE, PI_EXCHID=>:PI_EXCHID, PO_ERRORID=>:PO_ERRORID); end;
cufhzatnw3p2q select trim(c1.contractid) as contractid, trim(c1.tradeseq) as tradeseq, upper(trim(c1.bstag)) as bstag, c1.position as position, c1.openprice as openprice, c1.lastsettleprice as lastsettleprice, c1.settleprice as settleprice, c1.positionprofitbydate as positionprofitbydate, c1.positionprofitbytrade as positionprofitbytrade, upper(trim(c1.vhflag)) as vhflag, trim(c1.tradeseq) as tradeseq, trim(exclientid) as exclientid from h_compclientposdetail c1 where c1.clientid=:1 and c1.TradeDate=:2 order by trim(c1.contractid), trim(c1.tradeseq)
cvvqarnj98y1nselect upper(trim(ContractID)) as ContractID, upper(trim(substr(ContractID, 1, decode(exchangeid, 'D', 1, 2)))) as commodityid, trim(exchangeid) as exchangeid, min(trim(TradeSeq)) as TradeSeq, upper(trim(BSTag)) as BSTag, upper(trim(VHFlag)) as VHFlag, Price, sum(Volumn) as Volumn, sum(Amount) as Amount, upper(trim(OCTag)) as OCTag, sum(TradeFee) as TradeFee, sum(CloseProfitByTrade) as CloseProfitByTrade, sum(CloseProfit) as CloseProfit from H_CompClientTrade where clientid=:1 and TradeDate=:2 group by ContractID, upper(trim(substr(ContractID, 1, decode(exchangeid, 'D', 1, 2)))), exchangeid, BSTag, VHFlag, Price, OCTag order by decode(exchangeid, 'S', 1, 'Z', 2, 'D', 3, 'J', 4, 5), upper(trim(ContractID))
d280mar5508fnUPDATE D_EXCLIENT SET COMPANYID=( SELECT COMPANYID FROM B_EXCHANGECOMPANYMAP WHERE EXCHANGEID=D_EXCLIENT.EXCHANGEID AND EXCOMPANYID=D_EXCLIENT.EXCOMPANYID ) , CHECKTAG='0000' WHERE OPENDATE=:B2 AND EXCHANGEID=:B1
d3txjhzy7ha0vselect trim(f.UPLOADDATE) as UPLOADDATE, trim(f.COMPANYID) as COMPANYID, trim(f.TRADEDATE) as TRADEDATE, trim(f.COMPCLIENTID) as COMPCLIENTID, trim(f.CLIENTID) as CLIENTID, upper(trim(f.FUNDTYPE)) as FUNDTYPE, f.AMOUNT as AMOUNT, trim(f.CHECKTAG) as CHECKTAG, trim(f.EXCHANGEID) as EXCHANGEID, trim(e.EXCHANGENAME) as EXCHANGENAME, trim(o.FUNDNAME) as FUNDNAME, trim(f.note) as note from h_compclientotherfund f, b_exchange e, b_otherfund o where f.EXCHANGEID=e.EXCHANGEID(+) and upper(f.FUNDTYPE)=upper(o.FUNDTYPE(+)) and CLIENTID=:1 and TRADEDATE between :2 and :3 and upper(f.fundtype) not in ('A000', 'A001', 'A003', 'A008') order by TRADEDATE, upper(f.FUNDTYPE)
df7g4a1dgjhut select trim(UPLOADDATE) as UPLOADDATE, trim(COMPANYID) as COMPANYID, trim(TRADEDATE) as TRADEDATE , trim(a.EXCHANGEID) as EXCHANGEID , trim(COMPCLIENTID ) as COMPCLIENTID , trim(CLIENTID) as CLIENTID , trim(a.COMMODITYID ) as COMMODITYID , VOLUMN , PRICE , AMOUNT , trim(CHECKTAG) as CHECKTAG from H_COMPMORTGAGEDETAILS a where CLIENTID=:1 and TRADEDATE=:2
dfukfxgqzt4zrselect trim(UPLOADDATE) as UPLOADDATE , trim(COMPANYID ) as COMPANYID, trim(TRADEDATE ) as TRADEDATE, trim(EXCLIENTID ) as EXCLIENTID, trim(EXCHANGEID ) as EXCHANGEID, trim(COMPCLIENTID ) as COMPCLIENTID, trim(CLIENTID ) as CLIENTID, trim(CONTRACTID ) as CONTRACTID, trim(upper(BSTAG) ) as BSTAG, AVERAGEPRICE , AMOUNT , DELIVSETTLEPRICE , PAYMENT , VOLUMN , DELIVFEE , DELIVPROFIT , CHECKTAG from H_COMPDELIVDETAILS where CLIENTID=:1 and TRADEDATE=:2
dn6qa7w7wpuz3DELETE FROM B_EXCHANGECLIENTINFO WHERE EXCHANGEID=:B1
dnjd7yg94f5g6select trim(l.tradedate) as tradedate, upper(trim(l.contractid)) as contractid, trim(l.tradeseq) as tradeseq, trim(l.bstag) as bstag, l.liquidprice as liquidprice, l.openprice as openprice, l.volumn as volumn, l.lastsettleprice as lastsettleprice, l.closeprofitbydate as closeprofitbydate, l.closeprofitbytrade as closeprofitbytrade, trim(l.opentradeseq) as opentradeseq from h_compclientliquid l where l.clientid=:1 and l.TradeDate between :2 and :3 order by TradeDate, upper(trim(l.contractid)), trim(l.tradeseq)
dqfqqs8zdc3tsbegin up_ChkCompUploadFile_3012(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
dyqs2ztpgy41sselect trim(h.UPLOADDATE) as UPLOADDATE, trim(h.COMPANYID) as COMPANYID, trim(h.TRADEDATE) as TRADEDATE, trim(h.EXCLIENTID) as EXCLIENTID, trim(h.EXCHANGEID) as EXCHANGEID, trim(h.COMPCLIENTID) as COMPCLIENTID, trim(h.CONTRACTID) as CONTRACTID, trim(h.CLIENTID) as CLIENTID, trim(h.TRADESEQ) as TRADESEQ, trim(h.BSTAG) as BSTAG, h.POSITION as POSITION, h.DELIVMARGIN as DELIVMARGIN, h.OPENPRICE as OPENPRICE, h.DELIVSETTLEPRICE as DELIVSETTLEPRICE, trim(h.CHECKTAG) as CHECKTAG, trim(h.NONSETTLEMEMDATA) as NONSETTLEMEMDATA, trim(e.EXCHANGENAME) as EXCHANGENAME from H_COMPDELIVCONTRACTDATA h, b_exchange e where h.EXCHANGEID=e.EXCHANGEID(+) and h.CLIENTID=:1 and h.TRADEDATE=:2
f3s0860d6xzx4begin up_ChkCompUploadFile_3002(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
ff05sfkwgqd82 select count(*) from S_UploadFile u, (select trim(baseTable.baseDate) as fileDate, trim(c.companyID) as companyID, trim(c.companyName) as companyName, trim(c.shortName) as shortName, trim(fd.NameAbbr) as NameAbbr, trim(fd.FileName) as FileName, trim(fd.FileID) as FileID, trim(fd.Require) as Require, null as UploadFlag, null as LastUploadTime, null as VerifyDate, null as VerifyResult, null as LastVerifyTime, null as UploadDate from b_company c, S_UploadFileDef fd, ( select tradedate as baseDate from S_TRADEDATE where upper(flag)='Y' and tradedate<=to_char(systimestamp, 'yyyy-mm-dd') and tradedate>=to_char(add_months(systimestamp, -1), 'yyyy-mm-dd') ) baseTable where upper(trim(fd.orgtypeid)) = 'COMP' and c.companyID = :1 ) bt where trim(bt.fileDate) = trim(u.filedate(+)) and bt.fileDate >=to_char(add_months(systimestamp, -1), 'yyyy-mm-dd') and trim(bt.companyID) = trim(u.organID(+)) and trim(bt.FileID) = TRIM(u.fileid(+))
fkxkgy66sgyh5select trim(CLIENTID) as CLIENTID , sum(VOLUMN ) as VOLUMNSum , sum(PRICE ) as PRICEsum , sum(AMOUNT ) as AMOUNTsum from H_COMPMORTGAGEDETAILS a where CLIENTID=:1 and TRADEDATE between :2 and :3 group by trim(CLIENTID)
fnk9j5amqb284begin up_ChkCompUploadFile_3010(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
fqvb8jxywth8nSELECT startsn.sga_size_factor * 100 as factor, startsn.sga_size as start_size_mb, endsn.sga_size as end_size_mb, (endsn.estd_db_time - startsn.estd_db_time) * 1000000 as dbtime FROM WRH$_SGA_TARGET_ADVICE startsn , WRH$_SGA_TARGET_ADVICE endsn WHERE startsn.dbid = :db_id AND startsn.snap_id = :start_snap AND startsn.instance_number = :inst_num AND startsn.sga_size_factor >= 1 AND endsn.dbid = startsn.dbid AND endsn.snap_id = :end_snap AND endsn.instance_number = startsn.instance_number AND endsn.sga_size_factor = startsn.sga_size_factor ORDER BY startsn.sga_size_factor ASC
frq14xm1pp8djUPDATE S_UPLOADFILE SET VERIFYRESULT='Y', VERIFYDATE=:B5 , LASTVERIFYTIME=TO_CHAR(SYSDATE, 'HH24:MI:SS') WHERE TRIM(FILEDATE)=:B4 AND UPPER(ORGTYPEID)=:B3 AND TRIM(ORGANID)=:B2 AND FILEID=:B1
g0y0fp5byjxs3UPDATE S_UPLOADFILE SET VERIFYRESULT = DECODE (:B6 , 0, 'Y', 'N'), VERIFYDATE = :B5 , LASTVERIFYTIME = TO_CHAR (SYSDATE, 'HH24:MI:SS') WHERE TRIM (FILEDATE) = :B4 AND UPPER (ORGTYPEID) = :B3 AND TRIM (ORGANID) = :B2 AND FILEID = :B1
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gmwrfynvhknk1select trim(f.UPLOADDATE) as UPLOADDATE, trim(f.COMPANYID) as COMPANYID, trim(f.TRADEDATE) as TRADEDATE, trim(f.COMPCLIENTID) as COMPCLIENTID, trim(f.CLIENTID) as CLIENTID, upper(trim(f.FUNDTYPE)) as FUNDTYPE, f.AMOUNT as AMOUNT, trim(f.CHECKTAG) as CHECKTAG, trim(f.EXCHANGEID) as EXCHANGEID, trim(e.EXCHANGENAME) as EXCHANGENAME, trim(o.FUNDNAME) as FUNDNAME, trim(f.note) as note from h_compclientotherfund f, b_exchange e, b_otherfund o where f.EXCHANGEID=e.EXCHANGEID(+) and upper(f.FUNDTYPE)=upper(o.FUNDTYPE(+)) and CLIENTID=:1 and TRADEDATE=:2 and upper(f.fundtype) not in ('A000', 'A001', 'A003', 'A008')
gvynt9bqh451zSELECT sum(case when snap_id = :startsn then value else 0 end) as begin_sga, sum(case when snap_id = :endsn then value else 0 end) as end_sga FROM WRH$_SGA sga WHERE sga.dbid = :dbid AND sga.instance_number = :instance_number AND (sga.snap_id = :startsn OR sga.snap_id = :endsn)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 3,916,212 545.74 7.83
CPU used when call started 3,918,813 546.11 7.83
CR blocks created 393,027 54.77 0.79
Cached Commit SCN referenced 2,780 0.39 0.01
Commit SCN cached 1 0.00 0.00
DB time 5,554,571 774.06 11.10
DBWR checkpoint buffers written 3,606,438 502.58 7.21
DBWR checkpoints 21 0.00 0.00
DBWR fusion writes 398,447 55.53 0.80
DBWR object drop buffers written 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 872 0.12 0.00
DBWR undo block writes 2,495,696 347.79 4.99
DFO trees parallelized 144 0.02 0.00
PX local messages recv'd 780 0.11 0.00
PX local messages sent 780 0.11 0.00
PX remote messages recv'd 480 0.07 0.00
PX remote messages sent 720 0.10 0.00
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 144 0.02 0.00
RowCR - row contention 174 0.02 0.00
RowCR attempts 1,795,688 250.24 3.59
RowCR hits 1,796,728 250.38 3.59
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 1,341,679 186.97 2.68
active txn count during cleanout 2,949,889 411.08 5.89
application wait time 29 0.00 0.00
background checkpoints completed 20 0.00 0.00
background checkpoints started 21 0.00 0.00
background timeouts 29,223 4.07 0.06
branch node splits 1,238 0.17 0.00
buffer is not pinned count 563,009,127 78,458.30 1,125.08
buffer is pinned count 54,888,369,869 7,648,984.37 109,685.04
bytes received via SQL*Net from client 2,195,350,346 305,933.67 4,387.03
bytes sent via SQL*Net to client 258,342,479 36,001.39 516.25
calls to get snapshot scn: kcmgss 7,238,940 1,008.78 14.47
calls to kcmgas 7,973,310 1,111.12 15.93
calls to kcmgcs 3,009,343 419.37 6.01
change write time 83,821 11.68 0.17
cleanout - number of ktugct calls 3,255,015 453.60 6.50
cleanouts and rollbacks - consistent read gets 140,202 19.54 0.28
cleanouts only - consistent read gets 175,494 24.46 0.35
cluster key scan block gets 25,212 3.51 0.05
cluster key scans 7,330 1.02 0.01
cluster wait time 211,358 29.45 0.42
commit batch/immediate performed 215 0.03 0.00
commit batch/immediate requested 215 0.03 0.00
commit cleanout failures: block lost 8,300 1.16 0.02
commit cleanout failures: buffer being written 79 0.01 0.00
commit cleanout failures: callback failure 68,035 9.48 0.14
commit cleanout failures: cannot pin 47 0.01 0.00
commit cleanouts 3,752,135 522.88 7.50
commit cleanouts successfully completed 3,675,674 512.22 7.35
commit immediate performed 215 0.03 0.00
commit immediate requested 215 0.03 0.00
commit txn count during cleanout 623,915 86.95 1.25
concurrency wait time 2,507 0.35 0.01
consistent changes 38,054,545 5,303.10 76.05
consistent gets 872,781,430 121,626.70 1,744.10
consistent gets - examination 45,324,106 6,316.15 90.57
consistent gets direct 0 0.00 0.00
consistent gets from cache 872,781,426 121,626.70 1,744.10
current blocks converted for CR 8,831 1.23 0.02
cursor authentications 52 0.01 0.00
data blocks consistent reads - undo records applied 37,720,139 5,256.50 75.38
db block changes 186,736,484 26,022.72 373.16
db block gets 158,073,537 22,028.38 315.88
db block gets direct 146 0.02 0.00
db block gets from cache 158,073,391 22,028.36 315.88
deferred (CURRENT) block cleanout applications 1,423,976 198.44 2.85
dirty buffers inspected 21,658 3.02 0.04
enqueue conversions 6,192 0.86 0.01
enqueue releases 1,335,708 186.14 2.67
enqueue requests 1,335,749 186.14 2.67
enqueue timeouts 44 0.01 0.00
enqueue waits 19,005 2.65 0.04
exchange deadlocks 37 0.01 0.00
execute count 4,190,023 583.90 8.37
failed probes on index block reclamation 135 0.02 0.00
free buffer inspected 7,407,593 1,032.29 14.80
free buffer requested 7,736,306 1,078.10 15.46
gc CPU used by this session 74,605 10.40 0.15
gc blocks corrupt 0 0.00 0.00
gc blocks lost 139 0.02 0.00
gc cr block build time 12,454 1.74 0.02
gc cr block flush time 15,383 2.14 0.03
gc cr block receive time 141,702 19.75 0.28
gc cr block send time 4,540 0.63 0.01
gc cr blocks received 1,727,588 240.75 3.45
gc cr blocks served 1,609,258 224.26 3.22
gc current block flush time 7,877 1.10 0.02
gc current block pin time 6,597 0.92 0.01
gc current block receive time 77,042 10.74 0.15
gc current block send time 6,491 0.90 0.01
gc current blocks received 1,077,839 150.20 2.15
gc current blocks served 2,294,258 319.72 4.58
gc local grants 701,506 97.76 1.40
gc remote grants 862,539 120.20 1.72
gcs messages sent 6,966,856 970.87 13.92
ges messages sent 92,541 12.90 0.18
global enqueue get time 3,554 0.50 0.01
global enqueue gets async 5,279 0.74 0.01
global enqueue gets sync 440,246 61.35 0.88
global enqueue releases 431,577 60.14 0.86
heap block compress 16,961,136 2,363.62 33.89
hot buffers moved to head of LRU 1,909,095 266.04 3.82
immediate (CR) block cleanout applications 315,697 43.99 0.63
immediate (CURRENT) block cleanout applications 1,472,481 205.20 2.94
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 230 0.03 0.00
index fast full scans (full) 286 0.04 0.00
index fetch by key 3,060,724 426.53 6.12
index scans kdiixs1 1,158,086 161.39 2.31
leaf node 90-10 splits 753 0.10 0.00
leaf node splits 257,086 35.83 0.51
lob reads 40 0.01 0.00
lob writes 251 0.03 0.00
lob writes unaligned 251 0.03 0.00
logons cumulative 1,571 0.22 0.00
messages received 445,836 62.13 0.89
messages sent 445,836 62.13 0.89
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 822,360,551 114,600.29 1,643.35
opened cursors cumulative 227,159 31.66 0.45
parse count (failures) 0 0.00 0.00
parse count (hard) 3,963 0.55 0.01
parse count (total) 227,077 31.64 0.45
parse time cpu 879 0.12 0.00
parse time elapsed 1,229 0.17 0.00
physical read IO requests 585,669 81.62 1.17
physical read bytes 9,969,623,040 1,389,319.65 19,922.59
physical read total IO requests 714,909 99.63 1.43
physical read total bytes 53,706,694,656 7,484,311.68 107,323.67
physical read total multi block requests 91,727 12.78 0.18
physical reads 1,216,995 169.59 2.43
physical reads cache 963,464 134.26 1.93
physical reads cache prefetch 417,283 58.15 0.83
physical reads direct 253,531 35.33 0.51
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 241,394 33.64 0.48
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 848,705 118.27 1.70
physical write bytes 35,154,132,992 4,898,914.18 70,249.54
physical write total IO requests 1,947,298 271.37 3.89
physical write total bytes ############### 28,739,442.50 412,118.37
physical write total multi block requests 1,480,653 206.34 2.96
physical writes 4,291,276 598.01 8.58
physical writes direct 246,775 34.39 0.49
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 241,394 33.64 0.48
physical writes from cache 4,044,501 563.62 8.08
physical writes non checkpoint 3,975,025 553.94 7.94
pinned buffers inspected 12,989 1.81 0.03
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 820 0.11 0.00
process last non-idle time 7,106 0.99 0.01
queries parallelized 144 0.02 0.00
recursive aborts on index block reclamation 27 0.00 0.00
recursive calls 21,755,327 3,031.72 43.47
recursive cpu usage 520,246 72.50 1.04
redo blocks written 41,815,770 5,827.25 83.56
redo buffer allocation retries 14,672 2.04 0.03
redo entries 95,546,150 13,314.86 190.93
redo log space requests 10,309 1.44 0.02
redo log space wait time 3,837 0.53 0.01
redo ordering marks 2,402,856 334.85 4.80
redo size 41,933,911,160 5,843,712.10 83,797.77
redo subscn max counts 154,951 21.59 0.31
redo synch time 278,570 38.82 0.56
redo synch writes 324,035 45.16 0.65
redo wastage 197,026,048 27,456.62 393.72
redo write time 176,153 24.55 0.35
redo writer latching time 3,206 0.45 0.01
redo writes 333,933 46.54 0.67
rollback changes - undo records applied 850,667 118.54 1.70
rollbacks only - consistent read gets 176,518 24.60 0.35
rows fetched via callback 1,016,965 141.72 2.03
session connect time 0 0.00 0.00
session cursor cache hits 185,755 25.89 0.37
session logical reads 1,030,855,117 143,655.11 2,059.99
session pga memory 241,725,832 33,685.77 483.05
session pga memory max 727,757,864 101,416.90 1,454.30
session uga memory 12,929,309,824 1,801,767.64 25,837.02
session uga memory max 556,849,656 77,599.94 1,112.77
shared hash latch upgrades - no wait 1,878,458 261.77 3.75
shared hash latch upgrades - wait 1,243 0.17 0.00
sorts (disk) 11 0.00 0.00
sorts (memory) 55,376 7.72 0.11
sorts (rows) 97,902,650 13,643.25 195.64
sql area evicted 2,369 0.33 0.00
sql area purged 0 0.00 0.00
summed dirty queue length 72,257 10.07 0.14
switch current to new buffer 525,643 73.25 1.05
table fetch by rowid 27,718,343,645 3,862,697.65 55,390.38
table fetch continued row 5,993,628 835.24 11.98
table scan blocks gotten 96,799,384 13,489.51 193.44
table scan rows gotten 8,782,544,412 1,223,893.97 17,550.42
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 3 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 93,148 12.98 0.19
total number of times SMON posted 243 0.03 0.00
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 215 0.03 0.00
transaction tables consistent read rollbacks 199 0.03 0.00
transaction tables consistent reads - undo records applied 13,235 1.84 0.03
undo change vector size 18,147,878,312 2,529,002.73 36,265.44
user I/O wait time 213,708 29.78 0.43
user calls 1,539,680 214.56 3.08
user commits 324,109 45.17 0.65
user rollbacks 176,309 24.57 0.35
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 200 0.03 0.00
workarea executions - optimal 49,071 6.84 0.10
write clones created in background 1 0.00 0.00
write clones created in foreground 348 0.05 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 440,857 452,698
opened cursors current 4,077 4,100
logons current 404 412

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 21 10.54

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)
MARGIN_D 121,319 17 1.94 1.71 180,109 25 388 11.08
MARGIN_B 166,008 23 3.26 1.00 122,389 17 11 2.73
MARGIN_B_IDX 93,045 13 4.27 1.00 139,496 19 13,008 1.02
UNDOTBS2 162 0 27.47 1.00 173,873 24 779 4.02
MARGIN201303 21,366 3 4.38 4.13 86,304 12 100,993 0.73
MARGIN_IDX201303 32,719 5 6.15 1.00 70,867 10 44,929 2.07
MARGIN_D_IDX 27,108 4 2.74 1.00 50,543 7 218 5.41
TEMP 25,320 4 12.72 9.53 10,383 1 0 0.00
MARGIN_S 27,596 4 5.75 5.28 4,572 1 1,358 20.15
MARGIN_S_IDX 10,396 1 9.40 1.00 4,814 1 77 7.01
MARGIN201110 14,604 2 2.37 1.00 0 0 0 0.00
MARGIN201302 12,640 2 7.36 1.00 156 0 286 9.20
MARGIN201111 7,775 1 1.63 6.52 0 0 0 0.00
MARGIN201301 7,248 1 4.49 13.89 208 0 0 0.00
MARGIN_IDX201110 4,849 1 4.73 1.00 0 0 0 0.00
MARGIN_IDX201302 2,201 0 10.04 1.00 189 0 10 11.00
MARGIN_IDX201111 1,647 0 3.35 1.00 0 0 0 0.00
SYSAUX 478 0 9.33 1.13 861 0 0 0.00
MARGIN_IDX201211 777 0 18.35 1.00 260 0 0 0.00
MARGIN_IDX201212 756 0 19.68 1.00 260 0 0 0.00
MARGIN_IDX201301 685 0 19.68 1.00 247 0 0 0.00
MARGIN_IDX201209 618 0 13.43 1.00 286 0 0 0.00
MARGIN_IDX201207 626 0 21.15 1.00 264 0 0 0.00
MARGIN201211 619 0 22.12 1.00 221 0 0 0.00
MARGIN201212 602 0 24.05 1.00 221 0 0 0.00
MARGIN_IDX201208 530 0 19.30 1.00 285 0 0 0.00
MARGIN_IDX201210 586 0 12.87 1.00 221 0 0 0.00
MARGIN201209 535 0 20.41 1.00 234 0 0 0.00
MARGIN201208 522 0 21.78 1.00 222 0 0 0.00
MARGIN201210 525 0 15.28 1.00 195 0 0 0.00
MARGIN 542 0 5.76 12.48 82 0 0 0.00
MARGIN201207 384 0 25.81 1.00 204 0 0 0.00
SYSTEM 206 0 8.20 1.00 254 0 6 51.67
UNDOTBS1 156 0 26.22 1.00 156 0 10,863 1.66
MARGIN_R 218 0 11.28 9.94 49 0 0 0.00
MARGIN_R_IDX 72 0 27.36 1.00 49 0 0 0.00
MARGIN_C_IDX 71 0 26.76 1.00 49 0 0 0.00
MARGIN_C 70 0 26.71 1.00 49 0 0 0.00
AUTHCENTER 38 0 27.63 1.00 24 0 0 0.00
AUTHPUB 38 0 28.68 1.00 24 0 0 0.00
USERS 29 0 23.79 1.00 26 0 0 0.00
MARGIN_T 20 0 20.50 1.00 15 0 0 0.00
MARGIN_P_IDX 21 0 19.52 1.00 13 0 0 0.00
MARGIN_IDX 13 0 25.38 1.00 16 0 0 0.00
MARGIN_P 16 0 26.88 1.00 13 0 0 0.00
MARGIN_T_IDX 16 0 22.50 1.00 13 0 0 0.00
MARGIN_IDX201202 3 0 3.33 1.00 0 0 0 0.00
MARGIN201202 1 0 10.00 1.00 0 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
AUTHCENTER /dev/vgdatafc4g03/rraw_db_data_fc_4G_587 19 0 26.84 1.00 12 0 0 0.00
AUTHCENTER /dev/vgdatafc4g03/rraw_db_data_fc_4G_613 19 0 28.42 1.00 12 0 0 0.00
AUTHPUB /dev/vgdatafc4g03/rraw_db_data_fc_4G_586 19 0 28.42 1.00 12 0 0 0.00
AUTHPUB /dev/vgdatafc4g03/rraw_db_data_fc_4G_614 19 0 28.95 1.00 12 0 0 0.00
MARGIN /dev/vgdatafc4g01/rraw_db_data_fc_4G_1 207 0 6.62 12.25 50 0 0 0.00
MARGIN /dev/vgdatafc4g04/rraw_db_data_fc_4G_761 163 0 4.97 12.58 13 0 0 0.00
MARGIN /dev/vgdatafc4g04/rraw_db_data_fc_4G_762 172 0 5.47 12.66 19 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_572 959 0 2.17 1.00 0 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_573 1,097 0 1.72 1.00 0 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_574 1,144 0 1.80 1.00 0 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_575 1,020 0 1.23 1.00 0 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_576 1,042 0 1.45 1.00 0 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_577 208 0 2.16 1.00 0 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_578 20 0 4.00 1.00 0 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_581 2,006 0 2.94 1.00 0 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_582 2,040 0 3.04 1.00 0 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_583 2,040 0 2.79 1.00 0 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_584 1,399 0 2.23 1.00 0 0 0 0.00
MARGIN201110 /dev/vgdatafc8g03/rraw_db_data_fc_8G_585 1,629 0 2.64 1.00 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_586 1,333 0 1.72 4.96 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_587 1,381 0 1.75 4.84 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_588 1,380 0 1.37 4.88 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_589 1,380 0 1.76 4.88 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_590 1,213 0 1.48 5.42 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_591 192 0 1.98 15.94 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_592 192 0 1.77 15.94 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_593 192 0 1.25 15.94 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_594 192 0 2.19 15.94 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_595 192 0 1.46 15.94 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_596 64 0 1.25 15.94 0 0 0 0.00
MARGIN201111 /dev/vgdatafc8g03/rraw_db_data_fc_8G_597 64 0 2.19 15.94 0 0 0 0.00
MARGIN201202 /dev/vgdatafc8g03/rraw_db_data_fc_8G_639 1 0 10.00 1.00 0 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_701 19 0 26.32 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_702 21 0 27.62 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_703 21 0 25.24 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_704 21 0 27.62 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_705 19 0 35.26 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_706 21 0 39.52 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_707 21 0 25.24 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_708 21 0 25.71 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_709 21 0 24.76 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_710 21 0 24.29 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_711 21 0 25.71 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_712 21 0 25.71 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_713 21 0 26.67 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_714 22 0 25.91 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_715 31 0 20.65 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_716 31 0 20.97 1.00 12 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_717 31 0 20.00 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_718 33 0 22.73 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_719 33 0 19.39 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_720 33 0 24.85 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_721 33 0 19.39 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_722 33 0 21.82 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_723 33 0 32.42 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_724 27 0 22.22 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_725 27 0 19.26 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_726 27 0 22.96 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_727 27 0 18.52 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_728 27 0 18.52 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_729 27 0 20.00 1.00 12 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_730 22 0 21.82 1.00 13 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_731 29 0 25.52 1.00 13 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_732 29 0 20.34 1.00 13 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_733 29 0 22.76 1.00 13 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_734 29 0 18.97 1.00 13 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_735 24 0 17.92 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_736 29 0 20.34 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_737 30 0 20.67 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_738 30 0 18.67 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_739 30 0 26.33 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_740 30 0 19.33 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_741 30 0 19.00 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_742 30 0 17.33 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_743 30 0 17.33 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_744 30 0 18.33 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_745 30 0 29.33 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_746 30 0 29.33 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_747 29 0 19.31 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_748 29 0 19.31 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_749 29 0 20.00 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_750 29 0 20.00 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g04/rraw_db_data_fc_8G_751 30 0 16.00 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g04/rraw_db_data_fc_8G_752 30 0 13.33 1.00 13 0 0 0.00
MARGIN201209 /dev/vgdatafc8g04/rraw_db_data_fc_8G_753 30 0 23.33 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_754 31 0 18.06 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_755 36 0 15.56 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_756 36 0 13.33 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_757 36 0 18.06 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_758 36 0 14.72 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_759 36 0 13.33 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_760 36 0 13.33 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_761 36 0 16.11 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_762 36 0 13.89 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_763 34 0 16.18 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_764 34 0 14.71 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_765 34 0 13.82 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_766 36 0 13.89 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_767 36 0 18.89 1.00 13 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_769 32 0 15.63 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_770 37 0 20.00 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_771 37 0 20.81 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_772 37 0 21.89 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_773 37 0 18.65 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_774 37 0 34.86 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_775 37 0 22.16 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_776 37 0 20.81 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_777 37 0 19.73 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_778 35 0 21.71 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_779 35 0 21.14 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_780 35 0 25.43 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_781 35 0 23.71 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_782 35 0 20.86 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_783 35 0 22.00 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_784 37 0 21.62 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_785 39 0 21.28 1.00 13 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_786 37 0 19.46 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_787 37 0 22.43 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_788 37 0 33.51 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_789 37 0 20.27 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_790 37 0 22.70 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_791 37 0 25.14 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_792 35 0 21.43 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_793 30 0 21.67 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_794 30 0 24.00 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_795 30 0 24.33 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_796 30 0 26.00 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_797 30 0 26.33 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_798 32 0 25.00 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_799 37 0 23.24 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_800 37 0 23.24 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_801 42 0 20.95 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_802 42 0 25.24 1.00 13 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_803 42 0 24.05 1.00 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_804 517 0 4.31 14.39 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_805 609 0 3.89 13.49 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_806 566 0 3.99 13.27 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_807 514 0 3.70 14.43 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_808 515 0 3.94 13.32 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_809 457 0 5.54 13.98 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_810 461 0 5.81 13.91 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_811 578 0 3.70 14.24 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_812 561 0 3.26 14.58 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_813 65 0 18.00 1.98 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_814 43 0 20.23 1.00 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_815 47 0 17.02 2.40 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_817 581 0 3.22 14.53 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_818 575 0 3.37 14.66 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_819 579 0 4.34 14.58 13 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_820 580 0 5.88 14.53 13 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_821 978 0 7.13 1.00 13 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_822 874 0 8.44 1.00 13 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_823 1,036 0 7.39 1.00 13 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_824 1,049 0 8.01 1.00 13 0 12 36.67
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_825 1,393 0 6.63 1.00 13 0 77 8.96
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_826 1,160 0 7.11 1.00 13 0 3 10.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_827 1,263 0 7.32 1.00 13 0 48 9.58
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_828 1,178 0 8.06 1.00 13 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_829 1,279 0 7.10 1.00 13 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_830 1,124 0 7.78 1.00 13 0 1 30.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_831 650 0 5.89 1.00 13 0 98 4.18
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_832 656 0 7.32 1.00 13 0 47 12.13
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_833 409 0 6.50 1.69 225 0 5 0.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_834 318 0 11.35 1.74 13 0 0 0.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_835 336 0 9.11 2.11 13 0 0 0.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_836 397 0 8.36 1.92 19 0 0 0.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_837 408 0 9.22 1.64 18 0 0 0.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_838 263 0 10.68 1.99 14 0 0 0.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_839 212 0 9.81 2.24 15 0 0 0.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_840 253 0 8.97 2.07 16 0 0 0.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_841 3,275 0 3.33 4.45 8,398 1 5,368 0.41
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_842 2,530 0 3.39 5.32 10,555 1 3,536 0.36
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_843 3,203 0 3.81 4.17 10,557 1 10,951 0.51
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_844 1,839 0 4.00 6.59 11,198 2 9,774 0.90
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_845 1,801 0 4.58 7.04 10,080 1 5,790 0.55
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_846 1,736 0 4.72 7.30 8,799 1 12,788 0.85
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_847 910 0 2.88 1.00 7,272 1 21,491 0.88
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_848 1,439 0 3.02 1.00 9,921 1 18,948 0.47
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_849 2,037 0 3.73 1.00 9,191 1 12,342 1.15
MARGIN_B /dev/vgdatafc8g01/rraw_db_data_fc_8G_113 58,277 8 2.90 1.00 40,010 6 11 2.73
MARGIN_B /dev/vgdatafc8g01/rraw_db_data_fc_8G_228 34,056 5 3.29 1.00 28,674 4 0 0.00
MARGIN_B /dev/vgdatafc8g01/rraw_db_data_fc_8G_245 33,891 5 3.69 1.00 28,443 4 0 0.00
MARGIN_B /dev/vgdatafc8g01/rraw_db_data_fc_8G_248 39,784 6 3.39 1.00 25,262 4 0 0.00
MARGIN_B_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_37 27,387 4 4.82 1.00 58,423 8 3,837 1.02
MARGIN_B_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_87 22,814 3 4.07 1.00 28,353 4 2,982 0.87
MARGIN_B_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_95 20,747 3 4.16 1.00 25,089 3 3,213 1.29
MARGIN_B_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_96 22,097 3 3.88 1.00 27,631 4 2,976 0.87
MARGIN_C /dev/vgdatafc8g01/rraw_db_data_fc_8G_114 16 0 22.50 1.00 13 0 0 0.00
MARGIN_C /dev/vgdatafc8g01/rraw_db_data_fc_8G_238 18 0 28.89 1.00 12 0 0 0.00
MARGIN_C /dev/vgdatafc8g01/rraw_db_data_fc_8G_241 18 0 27.78 1.00 12 0 0 0.00
MARGIN_C /dev/vgdatafc8g01/rraw_db_data_fc_8G_246 18 0 27.22 1.00 12 0 0 0.00
MARGIN_C_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_38 16 0 22.50 1.00 13 0 0 0.00
MARGIN_C_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_91 18 0 31.67 1.00 12 0 0 0.00
MARGIN_C_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_92 18 0 26.67 1.00 12 0 0 0.00
MARGIN_C_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_99 19 0 25.79 1.00 12 0 0 0.00
MARGIN_D /dev/vgdatafc8g01/rraw_db_data_fc_8G_115 59,203 8 2.00 1.74 89,204 12 190 19.68
MARGIN_D /dev/vgdatafc8g01/rraw_db_data_fc_8G_244 62,116 9 1.89 1.67 90,905 13 198 2.83
MARGIN_D_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_39 13,344 2 2.72 1.00 25,874 4 61 15.90
MARGIN_D_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_94 13,764 2 2.75 1.00 24,669 3 157 1.34
MARGIN_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_2 13 0 25.38 1.00 16 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_461 126 0 2.94 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_462 251 0 3.11 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_463 251 0 3.31 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_464 250 0 3.32 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_465 251 0 4.90 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_466 252 0 3.02 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_467 252 0 3.53 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_468 249 0 3.41 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_469 251 0 3.31 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_470 126 0 4.21 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_471 125 0 2.24 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_472 329 0 4.50 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_473 1,034 0 6.03 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_474 808 0 7.18 1.00 0 0 0 0.00
MARGIN_IDX201110 /dev/vgdatafc4g02/rraw_db_data_fc_4G_475 294 0 4.32 1.00 0 0 0 0.00
MARGIN_IDX201111 /dev/vgdatafc4g02/rraw_db_data_fc_4G_476 126 0 3.41 1.00 0 0 0 0.00
MARGIN_IDX201111 /dev/vgdatafc4g02/rraw_db_data_fc_4G_477 288 0 4.06 1.00 0 0 0 0.00
MARGIN_IDX201111 /dev/vgdatafc4g02/rraw_db_data_fc_4G_478 125 0 2.40 1.00 0 0 0 0.00
MARGIN_IDX201111 /dev/vgdatafc4g02/rraw_db_data_fc_4G_479 236 0 3.64 1.00 0 0 0 0.00
MARGIN_IDX201111 /dev/vgdatafc4g02/rraw_db_data_fc_4G_480 244 0 3.20 1.00 0 0 0 0.00
MARGIN_IDX201111 /dev/vgdatafc4g02/rraw_db_data_fc_4G_481 125 0 3.68 1.00 0 0 0 0.00
MARGIN_IDX201111 /dev/vgdatafc4g02/rraw_db_data_fc_4G_482 126 0 4.68 1.00 0 0 0 0.00
MARGIN_IDX201111 /dev/vgdatafc4g02/rraw_db_data_fc_4G_483 125 0 2.32 1.00 0 0 0 0.00
MARGIN_IDX201111 /dev/vgdatafc4g02/rraw_db_data_fc_4G_484 126 0 3.02 1.00 0 0 0 0.00
MARGIN_IDX201111 /dev/vgdatafc4g02/rraw_db_data_fc_4G_485 126 0 2.06 1.00 0 0 0 0.00
MARGIN_IDX201202 /dev/vgdatafc4g03/rraw_db_data_fc_4G_526 1 0 0.00 1.00 0 0 0 0.00
MARGIN_IDX201202 /dev/vgdatafc4g03/rraw_db_data_fc_4G_533 1 0 0.00 1.00 0 0 0 0.00
MARGIN_IDX201202 /dev/vgdatafc4g03/rraw_db_data_fc_4G_535 1 0 10.00 1.00 0 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_617 19 0 26.32 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_618 21 0 24.76 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_619 21 0 24.76 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_620 21 0 25.24 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_621 21 0 30.48 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_622 21 0 25.71 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_623 31 0 20.00 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_624 31 0 21.29 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_625 31 0 19.68 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_626 31 0 20.32 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_627 31 0 19.35 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_628 31 0 19.35 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_629 31 0 19.03 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_630 31 0 22.26 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_631 31 0 19.03 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_632 31 0 19.68 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_633 31 0 22.58 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_634 31 0 19.03 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_635 31 0 22.58 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_636 33 0 18.18 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_637 33 0 18.18 1.00 12 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_638 33 0 18.18 1.00 12 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_639 33 0 18.18 1.00 12 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_640 22 0 19.09 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_641 22 0 19.55 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_642 22 0 20.00 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_643 22 0 19.09 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_644 22 0 19.55 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_645 22 0 19.09 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_646 22 0 20.91 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_647 22 0 19.55 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_648 22 0 18.64 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_649 22 0 19.09 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_650 22 0 20.00 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_651 22 0 18.18 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_652 22 0 20.45 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_653 22 0 18.64 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_654 22 0 18.64 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_655 22 0 18.18 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_656 29 0 19.66 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_657 29 0 16.21 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_658 29 0 20.34 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_659 29 0 23.79 1.00 13 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_660 29 0 17.93 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_661 29 0 17.93 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_662 30 0 12.33 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_663 30 0 13.33 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_664 30 0 12.67 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_665 30 0 12.67 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_666 30 0 11.67 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_667 30 0 13.00 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_668 30 0 12.33 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_669 23 0 13.91 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_670 23 0 15.65 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_671 23 0 13.91 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_672 23 0 12.17 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_673 23 0 13.48 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_674 23 0 12.17 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_675 30 0 14.33 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_676 30 0 13.67 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_677 30 0 13.33 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_678 30 0 14.00 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_679 30 0 14.00 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_680 30 0 13.00 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_681 31 0 12.90 1.00 13 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_682 30 0 13.33 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_683 36 0 11.11 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_684 34 0 15.29 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_685 34 0 11.76 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_686 34 0 12.06 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_687 36 0 18.06 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_688 36 0 12.78 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_689 36 0 11.67 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_690 36 0 11.67 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_691 36 0 11.94 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_692 36 0 12.22 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_693 36 0 11.67 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_694 36 0 13.33 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_695 36 0 11.39 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_696 31 0 16.45 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_697 31 0 10.97 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_698 31 0 11.94 1.00 13 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_699 31 0 14.84 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_701 38 0 17.63 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_702 42 0 18.33 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_703 42 0 16.90 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_704 42 0 18.57 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_705 42 0 21.67 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_706 42 0 17.14 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_707 42 0 16.67 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_708 42 0 17.86 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_709 43 0 17.21 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_710 36 0 21.67 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_711 36 0 16.94 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_712 36 0 18.06 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_713 36 0 17.50 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_714 36 0 19.44 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_715 36 0 23.33 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_716 38 0 18.16 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_717 37 0 16.76 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_718 37 0 18.11 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_719 37 0 18.38 1.00 13 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_720 37 0 17.30 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_721 37 0 17.84 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_722 37 0 20.81 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_723 37 0 18.65 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_724 37 0 22.70 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_725 37 0 17.84 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_726 37 0 20.00 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_727 37 0 18.65 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_728 36 0 18.89 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_729 37 0 19.73 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_730 36 0 20.83 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_731 36 0 19.44 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_732 37 0 19.46 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_733 36 0 19.44 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_734 37 0 18.65 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_735 37 0 19.19 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_736 37 0 19.73 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_737 42 0 20.24 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_738 42 0 20.00 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_739 42 0 19.52 1.00 13 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_740 42 0 21.67 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_741 38 0 18.95 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_742 38 0 20.26 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_743 38 0 20.00 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_744 38 0 21.58 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_745 38 0 19.47 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_746 37 0 20.81 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_747 40 0 18.50 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_748 33 0 20.30 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_749 32 0 20.94 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_750 33 0 21.52 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_751 31 0 20.65 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_752 34 0 19.71 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_753 33 0 19.70 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_754 38 0 18.42 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_755 37 0 18.11 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_757 37 0 18.65 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_758 37 0 19.46 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_759 38 0 18.16 1.00 13 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_760 35 0 19.43 1.00 13 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_763 172 0 9.83 1.00 13 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_764 159 0 10.50 1.00 13 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_765 162 0 10.49 1.00 13 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_766 193 0 9.27 1.00 15 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_767 149 0 10.34 1.00 14 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_768 154 0 8.44 1.00 13 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_769 150 0 12.67 1.00 14 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_770 144 0 11.74 1.00 13 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_771 166 0 8.67 1.00 13 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_772 160 0 8.50 1.00 14 0 7 11.43
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_773 164 0 9.57 1.00 14 0 3 10.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_774 179 0 10.00 1.00 13 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_775 163 0 11.23 1.00 14 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_776 86 0 9.53 1.00 13 0 0 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_777 260 0 8.35 1.00 644 0 34 62.06
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_778 260 0 9.69 1.00 261 0 0 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_779 327 0 8.01 1.00 281 0 0 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_780 309 0 8.77 1.00 244 0 1 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_781 255 0 9.06 1.00 235 0 0 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_782 261 0 9.69 1.00 247 0 0 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_783 309 0 9.90 1.00 285 0 1 10.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_784 205 0 12.15 1.00 208 0 0 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_785 288 0 8.02 1.00 288 0 0 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_786 2,881 0 6.38 1.00 7,116 1 3,625 2.71
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_787 3,626 1 6.84 1.00 7,068 1 3,755 2.35
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_788 3,515 0 6.74 1.00 6,071 1 1,918 2.96
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_789 2,471 0 7.93 1.00 5,189 1 2,561 1.76
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_790 2,803 0 6.94 1.00 6,352 1 4,440 1.86
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_791 2,103 0 5.05 1.00 5,932 1 6,860 1.22
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_792 1,823 0 5.24 1.00 5,713 1 2,583 3.64
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_793 3,976 1 4.48 1.00 7,525 1 4,360 1.83
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_794 3,725 1 5.32 1.00 7,560 1 3,988 2.26
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_795 1,533 0 5.39 1.00 4,380 1 6,366 1.80
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_796 1,789 0 3.61 1.00 5,268 1 4,437 1.70
MARGIN_P /dev/vgdatafc8g01/rraw_db_data_fc_8G_116 16 0 26.88 1.00 13 0 0 0.00
MARGIN_P_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_40 21 0 19.52 1.00 13 0 0 0.00
MARGIN_R /dev/vgdatafc8g01/rraw_db_data_fc_8G_118 48 0 9.58 10.83 13 0 0 0.00
MARGIN_R /dev/vgdatafc8g01/rraw_db_data_fc_8G_243 53 0 12.26 10.28 12 0 0 0.00
MARGIN_R /dev/vgdatafc8g02/rraw_db_data_fc_8G_251 66 0 11.21 8.77 12 0 0 0.00
MARGIN_R /dev/vgdatafc8g02/rraw_db_data_fc_8G_252 51 0 11.96 10.25 12 0 0 0.00
MARGIN_R_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_100 19 0 31.05 1.00 12 0 0 0.00
MARGIN_R_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_101 19 0 25.79 1.00 12 0 0 0.00
MARGIN_R_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_43 16 0 25.00 1.00 13 0 0 0.00
MARGIN_R_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_93 18 0 27.22 1.00 12 0 0 0.00
MARGIN_S /dev/vgdatafc8g01/rraw_db_data_fc_8G_112 2,792 0 9.92 1.00 945 0 101 0.59
MARGIN_S /dev/vgdatafc8g01/rraw_db_data_fc_8G_213 2,731 0 9.27 1.00 747 0 84 3.33
MARGIN_S /dev/vgdatafc8g01/rraw_db_data_fc_8G_242 3,368 0 8.93 1.00 886 0 129 2.48
MARGIN_S /dev/vgdatafc8g01/rraw_db_data_fc_8G_247 3,559 0 8.35 1.00 1,023 0 176 4.26
MARGIN_S /dev/vgdatafc8g04/rraw_db_data_fc_8G_768 7,883 1 3.21 8.42 295 0 463 3.65
MARGIN_S /dev/vgdatafc8g04/rraw_db_data_fc_8G_816 7,263 1 2.83 9.20 676 0 405 59.93
MARGIN_S_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_36 1,713 0 9.39 1.00 156 0 8 0.00
MARGIN_S_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_56 1,842 0 9.47 1.00 129 0 15 4.00
MARGIN_S_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_97 1,866 0 9.14 1.00 218 0 6 1.67
MARGIN_S_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_98 1,851 0 9.64 1.00 244 0 14 6.43
MARGIN_S_IDX /dev/vgdatafc4g03/rraw_db_data_fc_4G_700 1,599 0 9.80 1.00 2,063 0 12 5.83
MARGIN_S_IDX /dev/vgdatafc4g04/rraw_db_data_fc_4G_756 1,525 0 8.92 1.00 2,004 0 22 14.09
MARGIN_T /dev/vgdatafc8g01/rraw_db_data_fc_8G_117 20 0 20.50 1.00 15 0 0 0.00
MARGIN_T_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_41 16 0 22.50 1.00 13 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_1 147 0 7.96 1.14 360 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_2 94 0 6.70 1.15 62 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_3 68 0 11.47 1.25 140 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_4 69 0 11.45 1.06 117 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_5 55 0 10.36 1.13 97 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_6 45 0 11.56 1.00 85 0 0 0.00
SYSTEM /dev/vgdatafile/rraw_db_system_fc_4G_1 115 0 8.87 1.00 219 0 6 51.67
SYSTEM /dev/vgdatafile/rraw_db_system_fc_4G_2 91 0 7.36 1.00 35 0 0 0.00
TEMP /dev/vgdatafile/rraw_db_tmp_fc_8G_1 854 0 23.31 21.44 854 0 0  
TEMP /dev/vgdatafile/rraw_db_tmp_fc_8G_10 361 0 20.22 19.21 361 0 0  
TEMP /dev/vgdatafile/rraw_db_tmp_fc_8G_3 1,910 0 16.94 20.19 1,910 0 0  
TEMP /dev/vgdatafile/rraw_db_tmp_fc_8G_8 22,195 3 11.83 8.00 7,258 1 0  
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_1 13 0 29.23 1.00 13 0 6,213 1.32
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_10 13 0 24.62 1.00 13 0 165 5.58
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_11 13 0 26.15 1.00 13 0 86 8.95
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_12 13 0 25.38 1.00 13 0 138 0.51
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_2 13 0 26.15 1.00 13 0 1,381 0.55
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_3 13 0 24.62 1.00 13 0 639 4.24
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_4 13 0 25.38 1.00 13 0 525 0.21
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_5 13 0 25.38 1.00 13 0 100 15.50
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_6 13 0 24.62 1.00 13 0 112 0.09
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_7 13 0 32.31 1.00 13 0 672 2.62
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_8 13 0 25.38 1.00 13 0 729 1.36
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_9 13 0 25.38 1.00 13 0 103 1.36
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_13 13 0 29.23 1.00 13,589 2 467 3.53
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_14 13 0 26.15 1.00 13,882 2 2 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_15 13 0 24.62 1.00 14,956 2 0 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_16 13 0 26.92 1.00 14,600 2 78 1.15
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_17 13 0 26.15 1.00 15,144 2 131 2.21
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_18 13 0 30.77 1.00 14,795 2 1 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_19 13 0 27.69 1.00 14,874 2 0 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_20 13 0 27.69 1.00 15,484 2 0 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_21 16 0 25.00 1.00 13,029 2 69 2.03
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_22 16 0 24.38 1.00 14,503 2 15 5.33
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_23 13 0 28.46 1.00 14,586 2 7 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_24 13 0 33.85 1.00 14,431 2 9 97.78
USERS /dev/vgdatafile/rraw_db_user_fc_4G_1 13 0 24.62 1.00 13 0 0 0.00
USERS /dev/vgdatafile/rraw_db_user_fc_4G_2 16 0 23.13 1.00 13 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 2,824,493 100 1,028,578,643 963,460 4,044,501 0 0 172,945


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 474 46 79223 737008 803833 7461270 803833  
E 342 61 133548 1276402 7461270 7461270 8495925  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 2,352 0.10 282,093 2.00 1,977,407,552
D 4,704 0.20 564,186 1.44 1,426,394,127
D 7,056 0.30 846,279 1.25 1,240,352,785
D 9,408 0.40 1,128,372 1.18 1,162,737,691
D 11,760 0.50 1,410,465 1.14 1,123,321,090
D 14,112 0.60 1,692,558 1.10 1,087,894,667
D 16,464 0.70 1,974,651 1.07 1,058,197,363
D 18,816 0.80 2,256,744 1.04 1,031,923,068
D 21,168 0.90 2,538,837 1.02 1,008,639,187
D 23,520 1.00 2,820,930 1.00 989,426,245
D 23,552 1.00 2,824,768 1.00 989,253,263
D 25,872 1.10 3,103,023 0.99 976,874,602
D 28,224 1.20 3,385,116 0.98 966,222,939
D 30,576 1.30 3,667,209 0.97 955,437,956
D 32,928 1.40 3,949,302 0.96 945,298,362
D 35,280 1.50 4,231,395 0.95 935,587,214
D 37,632 1.60 4,513,488 0.94 925,336,654
D 39,984 1.70 4,795,581 0.92 912,574,198
D 42,336 1.80 5,077,674 0.91 901,897,434
D 44,688 1.90 5,359,767 0.90 892,292,206
D 47,040 2.00 5,641,860 0.89 881,206,154

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
85.81 16,942 2,801

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 10,000 8,593 789.02 0.00 0.00 0.00 0.00 1,024,000
E 10,000 8,602 806.83 0.00 0.00 0.00 0.00 1,024,000

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 27,237 27,237 0 0
64K 128K 14,748 14,748 0 0
128K 256K 220 220 0 0
256K 512K 290 290 0 0
512K 1024K 5,246 5,246 0 0
1M 2M 577 577 0 0
2M 4M 450 420 30 0
4M 8M 224 150 74 0
8M 16M 197 127 70 0
16M 32M 20 8 12 0
32M 64M 2 2 0 0
64M 128M 61 47 14 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
1,250 0.13 3,366,449.92 316,921.90 91.00 123
2,500 0.25 3,366,449.92 283,872.05 92.00 0
5,000 0.50 3,366,449.92 278,527.53 92.00 0
7,500 0.75 3,366,449.92 278,527.53 92.00 0
10,000 1.00 3,366,449.92 278,527.53 92.00 0
12,000 1.20 3,366,449.92 15,986.06 100.00 0
14,000 1.40 3,366,449.92 15,986.06 100.00 0
16,000 1.60 3,366,449.92 15,986.06 100.00 0
18,000 1.80 3,366,449.92 15,986.06 100.00 0
20,000 2.00 3,366,449.92 15,986.06 100.00 0
30,000 3.00 3,366,449.92 15,986.06 100.00 0
40,000 4.00 3,366,449.92 15,986.06 100.00 0
60,000 6.00 3,366,449.92 15,986.06 100.00 0
80,000 8.00 3,366,449.92 15,986.06 100.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,584 0.79 232 16,261 2,690,994 0.99 47,882 1.40 156,383,469
1,792 0.90 437 29,621 2,698,263 1.00 40,613 1.19 156,409,393
2,000 1.00 644 44,675 2,704,738 1.00 34,138 1.00 156,420,833
2,208 1.10 851 59,610 2,727,178 1.01 11,698 0.34 156,425,640
2,416 1.21 1,058 74,333 2,740,230 1.01 1 0.00 156,428,816
2,624 1.31 1,265 90,748 2,749,327 1.02 1 0.00 156,431,175
2,832 1.42 1,472 107,153 2,754,008 1.02 1 0.00 156,433,059
3,040 1.52 1,679 122,477 2,754,938 1.02 1 0.00 156,434,470
3,248 1.62 1,886 139,101 2,755,182 1.02 1 0.00 156,435,533
3,456 1.73 2,093 154,895 2,755,226 1.02 1 0.00 156,436,347
3,664 1.83 2,300 170,042 2,755,232 1.02 1 0.00 156,436,858
3,872 1.94 2,507 184,313 2,755,234 1.02 1 0.00 156,437,190
4,080 2.04 2,714 195,479 2,755,235 1.02 1 0.00 156,437,380

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
6,400 0.25 7,312,094 1,426,404,378
12,800 0.50 6,821,358 1,162,768,365
19,200 0.75 6,643,205 1,058,204,288
25,600 1.00 6,525,738 989,253,331
32,000 1.25 6,468,315 955,420,867
38,400 1.50 6,416,762 925,347,566
44,800 1.75 6,376,955 901,902,262
51,200 2.00 6,341,716 881,226,867

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 161,002 213 1
undo header 1,025 11 11
undo block 10,624 10 1
2nd level bmb 63 3 43
1st level bmb 54 1 13
segment header 2 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
WF-AWR Flush 39 39 0 20 17 864.90
FB-Format Block 29,594 29,594 0 14,758 6 0.43
HW-Segment High Water Mark 8,647 8,647 0 2,978 1 0.41
CF-Controlfile Transaction 16,736 16,729 7 332 1 2.78
TM-DML 350,321 350,321 0 219 0 1.37
PS-PX Process Reservation 984 984 0 360 0 0.58
TX-Transaction (index contention) 8,693 8,693 0 9 0 16.33
TT-Tablespace 4,987 4,987 0 280 0 0.35
TX-Transaction 688,793 688,797 0 4 0 19.75
TD-KTF map table enqueue (KTF dump entries) 20 20 0 20 0 1.45
WL-Being Written Redo Log 60 23 37 11 0 0.82
JS-Job Scheduler (job run lock - synchronize) 5 5 0 2 0 1.50
DR-Distributed Recovery 4 4 0 4 0 0.25
MW-MWIN Schedule 4 4 0 4 0 0.25
TA-Instance Undo 35 35 0 2 0 0.00
TX-Transaction (allocate ITL entry) 138 138 0 2 0 0.00
AF-Advisor Framework (task serialization) 14 14 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 6,378 0.00   0 0  
AWR Alerted Metric Element list 206,627 0.00   0 0  
Consistent RBA 334,180 0.00 0.44 0 0  
FAL request queue 148 0.00   0 0  
FAL subheap alocation 148 0.00   0 0  
FIB s.o chain latch 524 0.00   0 0  
FOB s.o list latch 31,164 0.05 0.00 0 0  
JS Sh mem access 10 20.00 1.00 0 0  
JS broadcast add buf latch 5,788 0.00   0 0  
JS broadcast drop buf latch 5,790 0.00   0 0  
JS broadcast load blnc latch 5,565 0.00   0 0  
JS mem alloc latch 12 0.00   0 0  
JS queue access latch 12 0.00   0 0  
JS queue state obj latch 200,710 0.00   0 0  
JS slv state obj latch 30 0.00   0 0  
KCL gc element parent latch 36,282,810 0.05 0.17 11 230,862 0.05
KJC message pool free list 646,849 0.01 0.15 0 156,811 0.01
KJCT flow control latch 7,178,233 0.02 0.10 0 0  
KMG MMAN ready and startup request latch 2,383 0.00   0 0  
KTF sga latch 35 0.00   0 2,353 0.00
KWQMN job cache list latch 611 0.00   0 0  
Memory Management Latch 0     0 2,383 0.00
OS process 4,272 0.00   0 0  
OS process allocation 5,240 0.00   0 0  
OS process: request allocation 2,813 0.00   0 0  
PL/SQL warning settings 5,551 0.00   0 0  
SGA IO buffer pool latch 124,501 0.00 0.67 0 124,501 0.00
SQL memory manager latch 2 0.00   0 2,321 0.00
SQL memory manager workarea list latch 241,904 0.00   0 0  
Shared B-Tree 254 0.00   0 0  
active checkpoint queue latch 90,256 0.00   0 0  
active service list 56,299 0.00 1.00 0 6,733 0.00
archive control 270 0.00   0 0  
archive process latch 2,669 0.00   0 0  
begin backup scn array 9 0.00   0 0  
business card 288 0.00   0 0  
cache buffer handles 682,223 0.00 0.00 0 0  
cache buffers chains 2,486,061,716 0.03 0.04 15 19,030,582 0.09
cache buffers lru chain 14,302,032 0.14 0.05 4 18,177,430 0.25
cache table scan latch 0     0 29,780 0.00
channel handle pool latch 3,024 0.00   0 0  
channel operations parent latch 558,725 0.00 0.06 0 0  
checkpoint queue latch 6,645,750 0.02 0.09 1 4,518,141 0.01
client/application info 15,933 0.00   0 0  
commit callback allocation 52 0.00   0 0  
compile environment latch 1,571 0.00   0 0  
dml lock allocation 700,539 0.01 0.32 0 0  
dummy allocation 3,134 0.00   0 0  
enqueue hash chains 3,490,024 0.01 0.18 0 9,756 0.01
enqueues 1,111,131 0.03 0.03 2 0  
error message lists 696 0.00   0 0  
event group latch 1,411 0.00   0 0  
file cache latch 13,493 0.00   0 0  
gcs opaque info freelist 3,627,974 0.09 0.02 0 0  
gcs partitioned table hash 2,342,253 0.00   0 0  
gcs resource freelist 2,771,181 0.01 0.06 0 600,345 0.00
gcs resource hash 24,591,881 0.01 0.20 1 523 0.00
gcs resource scan list 1,046 0.00   0 0  
gcs shadows freelist 2,214,094 0.00 0.11 0 1,674,229 0.00
ges caches resource lists 220,919 0.02 0.06 0 156,028 0.02
ges deadlock list 1,570 0.00   0 4 0.00
ges domain table 858,666 0.00   0 0  
ges enqueue table freelist 928,637 0.00 0.33 0 0  
ges group table 1,272,321 0.00 0.25 0 0  
ges process hash list 30,584 0.01 1.00 0 0  
ges process parent latch 1,848,942 0.00   0 0  
ges process table freelist 2,813 0.00   0 0  
ges resource hash list 1,179,399 1.52 0.99 0 76,922 0.00
ges resource scan list 188 0.00   0 0  
ges resource table freelist 135,577 0.01 0.00 0 0  
ges timeout list 4,204 0.00   0 6,551 0.00
global KZLD latch for mem in SGA 1,399 0.00   0 0  
hash table column usage latch 312 0.00   0 21,639 0.00
hash table modification latch 206 0.00   0 0  
job workq parent latch 0     0 10 0.00
job_queue_processes parameter latch 5 0.00   0 0  
kks stats 19,468 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 4 0.00   0 0  
ksuosstats global area 482 0.00   0 0  
ktm global data 245 0.00   0 0  
kwqbsn:qsga 254 0.00   0 0  
lgwr LWN SCN 334,710 0.08 0.01 0 0  
library cache 1,021,481 0.03 0.05 0 22,149 0.00
library cache load lock 170 0.00   0 0  
library cache lock 250,242 0.00   0 0  
library cache lock allocation 6,247 0.00   0 0  
library cache pin 216,523 0.00 0.00 0 1 0.00
library cache pin allocation 38 0.00   0 0  
list of block allocation 320,870 0.00 0.40 0 0  
loader state object freelist 1,572 0.00   0 0  
longop free list parent 97 0.00   0 97 0.00
message pool operations parent latch 2,490 0.00   0 0  
messages 1,509,305 0.02 0.09 0 0  
mostly latch-free SCN 338,549 0.87 0.01 0 0  
multiblock read objects 1,181,668 0.02 0.12 0 0  
name-service memory objects 50,524 0.00   0 0  
name-service namespace bucket 85,421 0.00   0 0  
name-service pending queue 21,270 0.00   0 0  
name-service request queue 96,417 0.00   0 0  
ncodef allocation latch 171 0.00   0 0  
object queue header heap 861 0.00   0 1,877 0.00
object queue header operation 28,035,203 0.09 0.16 4 0  
object stats modification 2 0.00   0 0  
parallel query alloc buffer 3,820 0.00   0 0  
parallel query stats 588 0.00   0 0  
parallel txn reco latch 20,860 0.00   0 0  
parameter list 14,930 0.00   0 0  
parameter table allocation management 3,138 0.00   0 0  
post/wait queue 708,408 0.01 0.15 0 509,423 0.01
process allocation 62,381 0.01 1.00 0 1,411 0.00
process group creation 2,813 0.00   0 0  
process queue 1,560 0.00   0 0  
process queue reference 26,991 0.00   0 2,762 0.00
qmn state object latch 4 0.00   0 0  
qmn task queue latch 1,067 13.21 0.97 0 0  
query server freelists 1,296 0.00   0 0  
queued dump request 35,105 0.00   0 0  
redo allocation 1,088,183 0.44 0.28 5 95,552,473 0.07
redo copy 0     0 95,562,286 0.02
redo writing 1,168,630 0.01 0.31 1 0  
resmgr group change latch 3,058 0.00   0 0  
resmgr:active threads 3,124 0.00   0 0  
resmgr:actses change group 1,558 0.00   0 0  
resmgr:free threads list 3,122 0.00   0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 3,672,475 0.04 0.02 0 1,972 0.00
rules engine aggregate statistics 26 0.00   0 0  
rules engine rule set statistics 52 0.00   0 0  
sequence cache 5,059 0.00   0 0  
session allocation 1,047,305 0.07 0.03 0 0  
session idle bit 3,598,579 0.00 0.01 0 0  
session state list latch 5,910 0.00   0 0  
session switching 171 0.00   0 0  
session timer 3,574 0.00   0 0  
shared pool 462,842 0.01 0.12 0 0  
shared pool sim alloc 276 0.00   0 0  
shared pool simulator 1,977,969 0.00 0.00 0 0  
sim partition latch 2 0.00   0 22,418 0.04
simulator hash latch 62,427,452 0.00 0.09 3 0  
simulator lru latch 0     0 61,907,393 0.43
slave class 6 0.00   0 0  
slave class create 24 8.33 1.00 0 0  
sort extent pool 2,559 0.00   0 0  
state object free list 24 0.00   0 0  
statistics aggregation 1,120 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
threshold alerts latch 2,293 0.00   0 0  
transaction allocation 182,935 0.00   0 0  
transaction branch allocation 3,574 0.00   0 0  
undo global data 5,931,390 0.01 0.12 0 0  
user lock 5,591 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 2,486,061,716 731,426 31,887 702,147 0 0 0
object queue header operation 28,035,203 26,332 4,082 22,361 0 0 0
cache buffers lru chain 14,302,032 19,614 1,037 18,614 0 0 0
ges resource hash list 1,179,399 17,928 17,764 166 0 0 0
KCL gc element parent latch 36,282,810 17,922 3,022 14,985 0 0 0
redo allocation 1,088,183 4,753 1,322 3,434 0 0 0
gcs opaque info freelist 3,627,974 3,423 69 3,354 0 0 0
mostly latch-free SCN 338,549 2,961 40 2,921 0 0 0
simulator hash latch 62,427,452 2,449 214 2,243 0 0 0
gcs resource hash 24,591,881 1,833 361 1,482 0 0 0
KJCT flow control latch 7,178,233 1,529 154 1,376 0 0 0
row cache objects 3,672,475 1,511 27 1,485 0 0 0
checkpoint queue latch 6,645,750 1,118 105 1,014 0 0 0
session allocation 1,047,305 705 24 681 0 0 0
undo global data 5,931,390 475 58 419 0 0 0
enqueues 1,111,131 330 11 319 0 0 0
library cache 1,021,481 287 14 273 0 0 0
messages 1,509,305 279 26 254 0 0 0
lgwr LWN SCN 334,710 259 2 257 0 0 0
multiblock read objects 1,181,668 248 30 219 0 0 0
gcs resource freelist 2,771,181 236 15 221 0 0 0
enqueue hash chains 3,490,024 193 35 158 0 0 0
qmn task queue latch 1,067 141 137 4 0 0 0
session idle bit 3,598,579 122 1 121 0 0 0
dml lock allocation 700,539 81 26 55 0 0 0
redo writing 1,168,630 65 20 45 0 0 0
post/wait queue 708,408 62 9 53 0 0 0
ges caches resource lists 220,919 47 3 44 0 0 0
KJC message pool free list 646,849 39 6 33 0 0 0
shared pool 462,842 34 4 30 0 0 0
ges enqueue table freelist 928,637 21 7 14 0 0 0
gcs shadows freelist 2,214,094 19 2 17 0 0 0
channel operations parent latch 558,725 17 1 16 0 0 0
Consistent RBA 334,180 9 4 5 0 0 0
ges group table 1,272,321 8 2 6 0 0 0
list of block allocation 320,870 5 2 3 0 0 0
process allocation 62,381 4 4 0 0 0 0
SGA IO buffer pool latch 124,501 3 2 2 0 0 0
JS Sh mem access 10 2 2 0 0 0 0
ges process hash list 30,584 2 2 0 0 0 0
slave class create 24 2 2 0 0 0 0
active service list 56,299 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
JS Sh mem access jsksGetShMemLatch 0 2 2
KCL gc element parent latch kclnfndnewm 0 1,078 842
KCL gc element parent latch kclbla 0 439 75
KCL gc element parent latch kclrwrite 0 284 270
KCL gc element parent latch kclnfnd 0 269 179
KCL gc element parent latch kclulb 0 189 895
KCL gc element parent latch kclwrt 0 189 137
KCL gc element parent latch kclzcl 0 185 28
KCL gc element parent latch KCLUNLNK 0 181 338
KCL gc element parent latch kclplz 0 160 291
KCL gc element parent latch kclfwrite1 0 154 203
KCL gc element parent latch kclgrantlk 0 79 13
KCL gc element parent latch kclgcr 0 77 104
KCL gc element parent latch kclpdc_3 0 64 4
KCL gc element parent latch kcllwr 0 31 6
KCL gc element parent latch kclpto 0 29 38
KCL gc element parent latch kclebs 0 24 62
KCL gc element parent latch kclchkping 0 21 1
KCL gc element parent latch kclswc 0 20 29
KCL gc element parent latch kclhngcbk1 0 13 0
KCL gc element parent latch kclfwrite2 0 12 2
KCL gc element parent latch kclrwrite_1 0 11 0
KCL gc element parent latch kclshrsplit 0 8 0
KCL gc element parent latch kclpdc_14 0 6 4
KCL gc element parent latch kcllkopesc 0 5 0
KCL gc element parent latch kclpto_3 0 4 7
KCL gc element parent latch kclpdc_15 0 2 5
KCL gc element parent latch kclpdc_1 0 1 1
KJC message pool free list kjcsmpav: allocate a msg buffer 0 3 6
KJC message pool free list kjcspfmbq: free vector of msg buffers 0 3 0
KJCT flow control latch kjctcsnd: send normal message 0 79 110
KJCT flow control latch kjcts_sqenq: queue a message 0 35 28
KJCT flow control latch kjcts_sedeqv: dequeue a vector of msgs 0 26 4
KJCT flow control latch kjctr_updatetkt: update ticket info 0 14 12
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 2 0
active service list kswssyis: find service entry 1 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 28,844 23,967
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 22,977 21,065
cache buffers chains kcbchg: kslbegin: call CR func 0 4,458 12,157
cache buffers chains kcbzwb 0 4,351 4,005
cache buffers chains kcbgtcr: kslbegin shared 0 2,152 1,954
cache buffers chains kcbzgb: scan from tail. nowait 0 1,369 0
cache buffers chains kcbgtcr: fast path 0 848 889
cache buffers chains kcbrls: kslbegin 0 363 999
cache buffers chains kclwrt 0 129 11
cache buffers chains kcbgcur: kslbegin 0 93 152
cache buffers chains kclebs_1 0 87 153
cache buffers chains kcbzib: finish free bufs 0 76 294
cache buffers chains kclwcrs 0 50 95
cache buffers chains kclbla 0 31 1
cache buffers chains kcbnew: new latch again 0 23 0
cache buffers chains kcbcge 0 17 34
cache buffers chains kcbbxsv 0 16 130
cache buffers chains kcbget: exchange 0 10 4
cache buffers chains kcbget: exchange rls 0 9 0
cache buffers chains kcbget: pin buffer 0 8 13
cache buffers chains kclpred 0 6 0
cache buffers chains kclgrantlk_1 0 5 1
cache buffers chains kclpto 0 5 0
cache buffers chains kcbgtcr 0 4 0
cache buffers chains kclcsr 0 4 9
cache buffers chains kcbbic1 0 3 0
cache buffers chains kclpdc_4 0 2 2
cache buffers chains kcbnlc 0 1 7
cache buffers chains kcbzib: multi-block read: nowait 0 1 0
cache buffers chains kclfbst_1 0 1 1
cache buffers chains kclgrantlk 0 1 0
cache buffers chains kcllwr 0 1 0
cache buffers chains kclpdcl 0 1 8
cache buffers chains kclrwrite_2 0 1 1
cache buffers lru chain kcbzgws 0 419 0
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 222 42
cache buffers lru chain kcbbxsv: move to being written 0 148 90
cache buffers lru chain kclmvreqbg 0 94 237
cache buffers lru chain kcbzgb: posted for free bufs 0 59 410
cache buffers lru chain kcbbic2 0 22 156
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 15 0
cache buffers lru chain kcbzgm 0 14 0
cache buffers lru chain H_MK_PI_CR_BG 0 11 0
cache buffers lru chain kclwcrs 0 11 0
cache buffers lru chain kcbbwlru 0 5 18
cache buffers lru chain H_MK_PI_CR 0 4 0
cache buffers lru chain kcbzswcu 0 4 2
cache buffers lru chain kclmergepi 0 4 0
cache buffers lru chain kcbrenounce 0 2 0
cache buffers lru chain kcbzib: move stale buffers 0 2 78
cache buffers lru chain kcbgtcr:CR Scan:best 0 1 0
channel operations parent latch ksrwait() 0 1 1
checkpoint queue latch kcbkubc 0 48 78
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 27 0
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 18 13
checkpoint queue latch kclmergepi_3 0 7 6
checkpoint queue latch kcbswcu: Switch buffers 0 3 8
checkpoint queue latch kcbnlc: Link buffers into FQ 0 2 0
dml lock allocation ktaiam 0 15 16
dml lock allocation ktaidm 0 11 10
enqueue hash chains ksqgtl3 0 17 17
enqueue hash chains ksqrcl 0 11 17
enqueue hash chains ksqcmi: if lk mode not requested 0 4 1
enqueue hash chains ksqcmi: if lk mode requested 0 3 0
enqueues ksqies 0 8 10
enqueues ksqgel: create enqueue 0 2 0
enqueues ksqdel 0 1 1
event range base latch No latch 0 137 137
gcs opaque info freelist kjbrcvt save opaque info 0 44 43
gcs opaque info freelist kjbrgrant free opaque info 0 25 26
gcs resource freelist kjbrfr free resource 0 10 1
gcs resource freelist kjbralc add resource 0 3 14
gcs resource freelist kjbralc_bg: add resource 0 2 0
gcs resource hash kclzcl 0 46 16
gcs resource hash kjbcropen:affinity 0 44 36
gcs resource hash kjbmpopen 0 39 23
gcs resource hash kjbmpclose 0 34 13
gcs resource hash kjbcropen 0 28 29
gcs resource hash kclpdc 0 22 2
gcs resource hash kclgrantlk_1 0 15 4
gcs resource hash kjbmpconvert 0 15 2
gcs resource hash kjbopen 0 14 22
gcs resource hash kclrwrite 0 13 42
gcs resource hash kclfwrite1 0 12 50
gcs resource hash kjbmpflushpi 0 12 3
gcs resource hash kjbopen:affinity 0 11 7
gcs resource hash kjbmpwrite 0 10 8
gcs resource hash kjbassume 0 9 31
gcs resource hash kjbconvert 0 9 7
gcs resource hash kjbmdowncvt 0 8 0
gcs resource hash kjbmpcreatepi 0 8 2
gcs resource hash kjbcrcomplete 0 5 38
gcs resource hash kjbcrconvert 0 2 15
gcs resource hash kjbrwrdone reget 0 2 0
gcs resource hash kclwrt 0 1 0
gcs resource hash kjblpast 0 1 1
gcs resource hash kjblpwreq 0 1 4
gcs shadows freelist kjblfr free lock 0 2 2
ges enqueue table freelist kjlalc: lock allocation 0 4 3
ges enqueue table freelist kjlfr: remove lock from parent object 0 3 4
ges group table kjgagll: move a lock from process lock list to group lock list 0 1 0
ges group table kjgdgll: move a lock from group lock list to process lock list 0 1 2
ges process hash list kjakiqa: set inquiry response 0 2 0
ges resource hash list kjakcai: search for resp by resname 0 11,561 27
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 6,109 1
ges resource hash list kjcvscn: remove from scan queue 0 45 0
ges resource hash list kjrmas1: lookup master node 0 36 0
ges resource hash list kjlrlr: remove lock from resource queue 0 7 13,886
ges resource hash list kjrref: find matched resource 0 3 4
ges resource hash list kjucvl: lock convert request 0 3 3,846
ges resource table freelist kjruch: cached obj cleanup 0 3 0
lgwr LWN SCN kcs023 0 19 0
library cache kgldte: child 0 0 7 11
library cache kglScanDependency 0 2 0
library cache kglhdgn: child: 0 1 0
library cache kglobpn: child: 0 1 0
library cache kglpndl: child: after processing 0 1 0
library cache kglpndl: child: before processing 0 1 1
library cache kglpnp: child 0 1 0
list of block allocation ktlabl 0 1 2
list of block allocation ktlbbl 0 1 0
messages ksaamb: after wakeup 0 20 19
messages ksarcv 0 4 7
messages ksarcv: after wait 0 2 0
mostly latch-free SCN kcslcu3 0 21 42
mostly latch-free SCN kcsnew_scn_rba 0 4 0
mostly latch-free SCN kcs024 0 2 0
multiblock read objects kcbzib: mbr get 0 17 7
multiblock read objects kcbzib: normal mbr free 0 13 23
object queue header operation kcbw_unlink_q 0 2,539 1,962
object queue header operation kcbo_switch_mq_bg 0 877 1,089
object queue header operation kcbw_link_q 0 730 304
object queue header operation kcbo_switch_cq 0 538 1,098
object queue header operation kcbo_switch_q_bg 0 250 359
object queue header operation kcbo_swap_buf 0 11 15
object queue header operation kcbw_unlink_q_bg 0 11 129
post/wait queue ksliwat:add:nowait 0 4 0
post/wait queue ksliwat:remove 0 2 4
post/wait queue kslpstevent:reget 0 2 2
post/wait queue kslpstevent:get 0 1 3
process allocation ksufap: active procs 0 3 0
process allocation ksucrp 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 1,259 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 39 286
redo allocation kcrfw_redo_write: more space 0 14 666
redo allocation kcrfw_redo_write: before write 0 7 370
redo allocation kcrfw_redo_gen: redo allocation 2 0 3 0
redo writing kcrfw_post: rba scn pair 0 14 1
redo writing kcrfw_post: after write 0 3 0
redo writing kcrfwcr 0 2 17
redo writing kcrfrsn 0 1 1
row cache objects kqreqd: reget 0 12 0
row cache objects kqrpre: find obj 0 8 26
row cache objects kqreqd 0 7 1
session allocation ksucri 0 11 13
session allocation ksuxds: not user session 0 9 11
session allocation ksufap: active sessions 0 4 0
session idle bit ksupuc: clear busy 0 1 0
shared pool kghalo 0 3 1
shared pool kghfre 0 1 2
simulator hash latch kcbsacc: lookup dba 0 206 204
simulator hash latch kcbs_lookup_setid: lookup dba 0 6 9
simulator hash latch kcbsacc: insert dba 0 2 0
slave class create ksvcreate 0 2 0
undo global data ktudba: KSLBEGIN 0 49 52
undo global data ktudnx:child 0 5 2
undo global data ktubnd:child 0 3 0
undo global data ktufrbs: child 0 1 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
MARGIN MARGIN201303 H_COMPCLIENTTRADE P20130309 TABLE PARTITION 460,190,688 44.64
MARGIN MARGIN_IDX201303 IX_H_COMPTRADE_DATE_COMPID P20130309 INDEX PARTITION 128,566,176 12.47
MARGIN MARGIN201303 H_COMPCLIENTPOSDETAIL P20130305 TABLE PARTITION 76,790,736 7.45
MARGIN MARGIN_S S_UPLOADFILE   TABLE 37,853,120 3.67
MARGIN MARGIN_D D_EXCLITRDDETAIL   TABLE 32,618,384 3.16

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
MARGIN MARGIN_B B_EXCHANGECLIENTINFO   TABLE 145,256 11.94
MARGIN MARGIN_D D_EXCLIENT   TABLE 131,063 10.77
MARGIN MARGIN_B_IDX INDEX_B_EXCLIENT_ID_COMP_EXCH   INDEX 70,654 5.81
MARGIN MARGIN_D D_EXCLITRDDETAIL   TABLE 43,684 3.59
MARGIN MARGIN_B B_CLIENT   TABLE 20,012 1.64

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
MARGIN MARGIN_IDX201303 IX_H_COMPTRADE_CLIENTID_DATE P20130309 INDEX PARTITION 1,266 14.41
MARGIN MARGIN_IDX201303 IX_H_COMPTRADE_DATE_COMPID P20130309 INDEX PARTITION 1,073 12.21
MARGIN MARGIN_IDX201303 IX_H_POSDETAIL_DATE_COMPID P20130305 INDEX PARTITION 914 10.40
MARGIN MARGIN_IDX201303 IX_H_COMPCLTINFO_DATE_COMPID P20130305 INDEX PARTITION 858 9.77
MARGIN MARGIN_IDX201303 IX_H_COMCLTFUNACC_DATE_COMPID P20130305 INDEX PARTITION 472 5.37

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
MARGIN MARGIN_IDX201303 IDX_H_EXOTHFD_DATE_COMID_EXID P20130302 INDEX PARTITION 28 20.29
MARGIN MARGIN_IDX201303 IDX_H_EXTRD_DATE_COMPID_EXCHID P20130309 INDEX PARTITION 24 17.39
MARGIN MARGIN_IDX201303 IX_H_COMPTRADE_CLIENTID_DATE P20130309 INDEX PARTITION 24 17.39
MARGIN MARGIN_IDX201303 IX_H_POSDETAIL_ID_DATE P20130305 INDEX PARTITION 10 7.25
MARGIN MARGIN_IDX201303 IX_H_POSDETAIL_DATE_COMPID P20130305 INDEX PARTITION 9 6.52

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
MARGIN MARGIN_IDX201303 IX_H_COMPTRADE_DATE_COMPID P20130309 INDEX PARTITION 136 39.19
MARGIN MARGIN_S S_QUERYLOG2 P20130302 TABLE PARTITION 34 9.80
MARGIN MARGIN_D D_COMPCLIENTCODE   TABLE 29 8.36
MARGIN MARGIN_D D_COMPCLIENTTRADE   TABLE 29 8.36
MARGIN MARGIN_D D_COMPCLIENTLIQUID   TABLE 27 7.78

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
MARGIN MARGIN201303 H_COMPCLIENTTRADE P20130309 TABLE PARTITION 93,871 58.91
MARGIN MARGIN_IDX201303 IX_H_COMPTRADE_DATE_COMPID P20130309 INDEX PARTITION 42,276 26.53
MARGIN MARGIN_B_IDX PK_B_CLIACC   INDEX 13,000 8.16
MARGIN MARGIN201303 H_COMPCLIENTPOSDETAIL P20130305 TABLE PARTITION 6,934 4.35
MARGIN MARGIN_IDX201303 IX_H_POSDETAIL_DATE_COMPID P20130305 INDEX PARTITION 2,256 1.42

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
MARGIN MARGIN_B_IDX PK_B_CLIACC   INDEX 597,908 34.61
MARGIN MARGIN201303 H_COMPCLIENTTRADE P20130309 TABLE PARTITION 158,500 9.17
MARGIN MARGIN_B B_CLIACC   TABLE 88,694 5.13
MARGIN MARGIN201303 H_COMPCLIENTLIQUID P20130309 TABLE PARTITION 86,131 4.99
MARGIN MARGIN_IDX201303 IX_H_COMPTRADE_DATE_COMPID P20130309 INDEX PARTITION 86,005 4.98

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
MARGIN MARGIN_B_IDX PK_B_CLIACC   INDEX 225,347 20.91
MARGIN MARGIN_D D_COMPCLIENTLIQUID   TABLE 223,979 20.78
MARGIN MARGIN201303 H_COMPCLIENTTRADE P20130309 TABLE PARTITION 43,456 4.03
MARGIN MARGIN_B B_EXCHANGECLIENTINFO   TABLE 41,627 3.86
MARGIN MARGIN_B_IDX PK_B_EXCHANGECLIENTMAP   INDEX 31,324 2.91

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 126 2.38 0   1 1
dc_database_links 2,802 0.00 0   0 1
dc_global_oids 12 0.00 0   0 106
dc_histogram_data 35,612 0.25 0   0 8,308
dc_histogram_defs 10,258 1.22 0   0 6,892
dc_object_ids 18,615 0.06 0   0 1,811
dc_objects 9,721 0.10 0   9 1,770
dc_profiles 1,405 0.00 0   0 1
dc_rollback_segments 191,255 0.00 0   0 598
dc_segments 12,811 4.20 0   1,255 8,190
dc_sequences 26 19.23 0   26 9
dc_tablespace_quotas 1,243 20.92 0   1,243 5
dc_tablespaces 895,316 0.00 0   0 179
dc_usernames 5,816 0.00 0   0 42
dc_users 71,047 0.00 0   0 58
outstanding_alerts 1,120 85.71 0   0 19

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 5 3 0
dc_histogram_defs 125 0 2,690
dc_object_ids 12 0 416
dc_objects 20 2 181
dc_segments 2,671 370 1,593
dc_sequences 52 2 0
dc_tablespace_quotas 2,486 257 1
outstanding_alerts 2,060 960 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 23 0.00 10,182 0.00 0 0
CLUSTER 2 0.00 2 0.00 0 0
INDEX 29 0.00 59 1.69 1 0
SQL AREA 35,875 21.79 4,220,443 0.28 48 0
TABLE/PROCEDURE 2,586 0.08 94,848 0.09 71 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 2 0 0 0 0
INDEX 59 0 1 0 0
TABLE/PROCEDURE 8,753 22 59 21 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 457.31   1.12 2.62 22 24 407 407
  Freeable 313.94 0.00 1.13 1.41 22   279 279
  PL/SQL 9.55 7.20 0.02 0.02 0 0 405 405
  SQL 8.50 2.88 0.02 0.01 0 210 390 388
E Other 458.82   1.11 2.60 22 24 415 415
  Freeable 329.94 0.00 1.13 1.39 22   291 291
  PL/SQL 9.57 7.20 0.02 0.02 0 0 413 413
  SQL 8.79 3.08 0.02 0.01 0 210 398 395

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 24,696,061,952  
Fixed Size 2,104,856  
Redo Buffers 14,671,872  
Variable Size 2,130,706,920  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared CCursor 48.21 48.25 0.08
shared Checkpoint queue 39.06 39.06 0.00
shared KGH: NO ACCESS 29.86 29.86 0.00
shared KQR L PO 23.56   -100.00
shared PCursor 35.43 35.73 0.83
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 272.56 282.82 3.77
shared gcs resources 494.18 494.18 0.00
shared gcs shadows 295.89 295.89 0.00
shared ges enqueues 34.35 34.35 0.00
shared ges resource 24.65 24.65 0.00
shared kglsim object batch 24.56 25.25 2.82
shared library cache 37.99 36.98 -2.64
shared sql area 192.55 195.90 1.74
  buffer_cache 23,552.00 23,552.00 0.00
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.99 13.99 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_shadows 2,369,833 2,652,434 3198287 3198287


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_db_block_numa 1   
_enable_NUMA_optimization FALSE   
_gc_affinity_time 0   
_gc_undo_affinity FALSE   
_undo_autotune FALSE   
audit_file_dest /app/oracle/10.2.0/admin/db/adump   
background_dump_dest /app/oracle/10.2.0/admin/db/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.3.0   
control_files /dev/vgdatafile/rraw_db_control_fc_2G_1, /dev/vgdatafile/rraw_db_control_fc_2G_2, /dev/vgdatafile/rraw_db_control_fc_2G_3, /dev/vgdatafile/rraw_db_control_fc_2G_4, /dev/vgdatafile/rraw_db_control_fc_2G_5   
core_dump_dest /app/oracle/10.2.0/admin/db/cdump   
db_block_size 8192   
db_cache_size 22028484608   
db_domain      
db_file_multiblock_read_count 16   
db_files 10000   
db_name db   
dispatchers (PROTOCOL=TCP) (SERVICE=dbXDB)   
fast_start_mttr_target 900   
instance_number 2   
local_listener LISTENER_DB02   
log_archive_dest /archivelog/archive   
max_dump_file_size 50000000   
open_cursors 1000   
optimizer_dynamic_sampling 1   
pga_aggregate_target 10485760000   
processes 1200   
remote_listener LISTENERS_DB   
remote_login_passwordfile EXCLUSIVE   
sessions 1325   
sga_max_size 26843545600   
sga_target 26843545600   
shared_pool_reserved_size 209715200   
shared_pool_size 2097152000   
spfile /dev/vgdatafile/rraw_db_spfile_fc_500m_1   
thread 2   
undo_management AUTO   
undo_retention 10800   
undo_tablespace UNDOTBS2   
user_dump_dest /app/oracle/10.2.0/admin/db/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 150,944 21.03 0.30
acks for commit broadcast(logical) 190,900 26.60 0.38
broadcast msgs on commit(actual) 326,328 45.48 0.65
broadcast msgs on commit(logical) 333,932 46.54 0.67
broadcast msgs on commit(wasted) 17,734 2.47 0.04
broadcast on commit wait time(ms) 24,235 3.38 0.05
broadcast on commit waits 16,669 2.32 0.03
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 6 0.00 0.00
flow control messages received 9 0.00 0.00
flow control messages sent 11 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 1,153,155 160.70 2.30
gcs ast xid 4 0.00 0.00
gcs blocked converts 726,064 101.18 1.45
gcs blocked cr converts 1,681,225 234.29 3.36
gcs compatible basts 158 0.02 0.00
gcs compatible cr basts (global) 196,487 27.38 0.39
gcs compatible cr basts (local) 998,336 139.12 2.00
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 337,409 47.02 0.67
gcs dbwr write request msgs 240,453 33.51 0.48
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 110,350 15.38 0.22
gcs immediate (null) converts 686,843 95.72 1.37
gcs immediate cr (compatible) converts 2,256 0.31 0.00
gcs immediate cr (null) converts 614,825 85.68 1.23
gcs indirect ast 758,002 105.63 1.51
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 111,735 15.57 0.22
gcs msgs process time(ms) 408,173 56.88 0.82
gcs msgs received 8,754,704 1,220.01 17.49
gcs out-of-order msgs 19 0.00 0.00
gcs pings refused 2,138 0.30 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 63 0.01 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 2 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 3 0.00 0.00
gcs side channel msgs actual 38,387 5.35 0.08
gcs side channel msgs logical 3,211,871 447.59 6.42
gcs stale cr 0 0.00 0.00
gcs undo cr 0 0.00 0.00
gcs write notification msgs 9,071 1.26 0.02
gcs writes refused 8,514 1.19 0.02
ges msgs process time(ms) 12,166 1.70 0.02
ges msgs received 88,640 12.35 0.18
global posts dropped 0 0.00 0.00
global posts queue time 336 0.05 0.00
global posts queued 26 0.00 0.00
global posts requested 26 0.00 0.00
global posts sent 26 0.00 0.00
implicit batch messages received 343,476 47.87 0.69
implicit batch messages sent 278,708 38.84 0.56
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 339,093 47.25 0.68
messages queue sent actual 1,174,764 163.71 2.35
messages queue sent logical 2,253,929 314.10 4.50
messages received actual 4,156,018 579.16 8.31
messages received logical 8,843,361 1,232.37 17.67
messages sent directly 2,484,868 346.28 4.97
messages sent indirectly 2,271,558 316.55 4.54
messages sent not implicit batched 896,052 124.87 1.79
messages sent pbatched 2,882,149 401.64 5.76
msgs causing lmd to send msgs 26,867 3.74 0.05
msgs causing lms(s) to send msgs 359,009 50.03 0.72
msgs received queue time (ms) 67,406 9.39 0.13
msgs received queued 8,843,219 1,232.35 17.67
msgs sent queue time (ms) 311,768 43.45 0.62
msgs sent queue time on ksxp (ms) 1,893,189 263.83 3.78
msgs sent queued 2,167,356 302.03 4.33
msgs sent queued on ksxp 4,128,076 575.27 8.25
process batch messages received 998,206 139.11 1.99
process batch messages sent 943,770 131.52 1.89


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 1,552,546
CURRENT Block Requests 56,382
Data Block Requests 1,552,561
Undo Block Requests 22,499
TX Block Requests 24,165
Current Results 1,514,164
Private results 19,920
Zero Results 74,832
Disk Read Results 0
Fail Results 24
Fairness Down Converts 330,891
Fairness Clears 0
Free GC Elements 0
Flushes 3,625
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 24,245
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 2,293,891 99.92 0.02 0.06 0.00 0.00
Flushes 1,673 11.18 43.04 34.43 11.36 0.00
Writes 398,451 2.13 32.22 56.64 8.99 0.03


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 1,650,988 98.88 0.10 1.03 1,051,036 99.59 0.15 0.26
1 undo header 29,213 77.77 22.14 0.09 1,710 98.95 0.82 0.23
1 Others 10,883 94.22 5.32 0.46 19,082 98.58 1.16 0.26
1 undo block 29,022 98.21 0.03 1.76 0      


Back to Top

End of Report