WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
DB1443746072db2210.2.0.4.0YESDB02

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:3578101-Apr-13 16:00:12400 10.7
End Snap:3578301-Apr-13 18:00:09426 10.2
Elapsed:  119.96 (mins)  
DB Time:  756.55 (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: 4,510,971.24 72,937.52
Logical reads: 126,322.96 2,042.51
Block changes: 19,909.10 321.91
Physical reads: 151.07 2.44
Physical writes: 496.34 8.03
User calls: 206.41 3.34
Parses: 33.98 0.55
Hard parses: 0.48 0.01
Sorts: 7.24 0.12
Logons: 0.15 0.00
Executes: 276.48 4.47
Transactions: 61.85 

% Blocks changed per Read: 15.76Recursive Call %: 90.38
Rollback per transaction %: 47.17Rows per Sort: 1112.83

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96Redo NoWait %: 100.00
Buffer Hit %: 99.91In-memory Sort %: 99.98
Library Hit %: 99.49Soft Parse %: 98.57
Execute to Parse %: 87.71Latch Hit %: 99.97
Parse CPU to Parse Elapsd %: 68.04% Non-Parse CPU: 99.97

Shared Pool Statistics

BeginEnd
Memory Usage %: 84.40 86.17
% SQL with executions>1: 95.25 70.77
% Memory for SQL w/exec>1: 86.72 74.79

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  33,944  74.8 
db file sequential read 526,268 2,008 4 4.4User I/O
Log archive I/O 32,059 1,559 49 3.4System I/O
log file parallel write 256,650 931 4 2.1System I/O
log file sync 235,919 886 4 2.0Commit

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 314.88 5.09
Global Cache blocks served: 1,268.33 20.51
GCS/GES messages received: 2,263.04 36.59
GCS/GES messages sent: 877.50 14.19
DBWR Fusion writes: 51.29 0.83
Estd Interconnect traffic (KB) 13,279.07 

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

Buffer access - local cache %: 99.66
Buffer access - remote cache %: 0.25
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.6
Avg global cache current block receive time (ms): 0.5
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.3
Avg global cache cr block flush time (ms): 10.9
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.0
Avg global cache current block flush time (ms): 16.4

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.3
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.1
% of direct sent messages: 47.23
% of indirect sent messages: 47.16
% of flow controlled messages: 5.61

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 44,422.77 97.86
DB CPU 33,944.36 74.78
PL/SQL execution elapsed time 104.07 0.23
parse time elapsed 14.09 0.03
hard parse elapsed time 5.67 0.01
connection management call elapsed time 2.11 0.00
repeated bind elapsed time 1.19 0.00
hard parse (sharing criteria) elapsed time 0.48 0.00
PL/SQL compilation elapsed time 0.03 0.00
hard parse (bind mismatch) elapsed time 0.00 0.00
DB time 45,392.80  
background elapsed time 4,491.80  
background cpu time 919.48  

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 503,483 0.00 3,427 7 1.13
User I/O 579,847 0.00 2,111 4 1.30
Cluster 3,345,844 0.00 1,446 0 7.52
Commit 235,919 0.60 886 4 0.53
Network 1,877,618 0.00 196 0 4.22
Other 182,055 59.05 95 1 0.41
Concurrency 60,174 0.11 32 1 0.14
Configuration 3,865 0.08 25 6 0.01
Application 1,242 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 526,268 0.00 2,008 4 1.18
Log archive I/O 32,059 0.00 1,559 49 0.07
log file parallel write 256,650 0.00 931 4 0.58
log file sync 235,919 0.60 886 4 0.53
gc cr block 2-way 948,333 0.00 436 0 2.13
log file sequential read 32,303 0.00 424 13 0.07
db file parallel write 92,674 0.00 421 5 0.21
gc current block 2-way 706,412 0.00 264 0 1.59
gc buffer busy 327,142 0.00 220 1 0.73
SQL*Net more data from client 607,039 0.00 194 0 1.36
gc cr multi block request 628,842 0.00 146 0 1.41
gc current grant busy 217,869 0.00 108 0 0.49
gc cr block busy 4,276 0.00 72 17 0.01
direct path read temp 10,855 0.00 52 5 0.02
gcs log flush sync 37,550 77.28 51 1 0.08
control file parallel write 4,479 0.00 50 11 0.01
gc current grant 2-way 207,700 0.00 50 0 0.47
control file sequential read 85,216 0.00 42 0 0.19
gc cr grant 2-way 134,108 0.00 37 0 0.30
gc cr block congested 3,571 0.00 35 10 0.01
db file scattered read 20,646 0.00 33 2 0.05
gc current block busy 1,190 0.00 29 25 0.00
latch: cache buffers chains 53,488 0.00 28 1 0.12
log buffer space 141 1.42 18 130 0.00
gc current multi block request 163,435 0.00 18 0 0.37
gc current block congested 988 0.00 13 13 0.00
direct path write temp 5,138 0.00 10 2 0.01
LGWR wait for redo copy 6,718 5.95 9 1 0.02
gc cr block lost 12 0.00 7 583 0.00
read by other session 1,302 0.00 5 4 0.00
log file switch completion 58 0.00 5 86 0.00
Streams AQ: qmn coordinator waiting for slave to start 1 100.00 5 4892 0.00
gc current block lost 9 0.00 5 513 0.00
latch: KCL gc element parent latch 2,627 0.00 5 2 0.01
enq: WF - contention 30 26.67 4 143 0.00
enq: FB - contention 14,953 0.00 4 0 0.03
direct path read 11,038 0.00 3 0 0.02
latch: object queue header operation 1,840 0.00 3 1 0.00
gc current block unknown 1,642 0.00 3 2 0.00
latch free 739 0.00 2 3 0.00
latch: redo allocation 646 0.00 2 4 0.00
gc current grant congested 131 0.00 2 16 0.00
cr request retry 158 100.00 2 10 0.00
latch: cache buffers lru chain 528 0.00 2 3 0.00
gc cr grant congested 78 0.00 2 19 0.00
row cache lock 4,120 0.00 1 0 0.01
wait list latch free 66 0.00 1 19 0.00
buffer busy waits 1,482 3.71 1 1 0.00
SQL*Net message to client 1,268,542 0.00 1 0 2.85
db file parallel read 70 0.00 1 16 0.00
enq: HW - contention 3,658 0.03 1 0 0.01
latch: gcs resource hash 423 0.00 1 2 0.00
CGS wait for IPC msg 61,046 100.00 1 0 0.14
latch: enqueue hash chains 15 0.00 1 38 0.00
os thread startup 11 0.00 1 46 0.00
library cache lock 974 0.00 0 0 0.00
wait for scn ack 14 14.29 0 24 0.00
lock escalate retry 17 88.24 0 19 0.00
direct path write 4,530 0.00 0 0 0.01
enq: TM - contention 1,238 0.00 0 0 0.00
enq: CF - contention 390 0.00 0 1 0.00
enq: TX - contention 12 0.00 0 20 0.00
log file single write 102 0.00 0 2 0.00
latch: redo writing 7 0.00 0 30 0.00
gc current retry 32 0.00 0 7 0.00
gc cr failure 71 0.00 0 3 0.00
DFS lock handle 11,009 0.00 0 0 0.02
ksxr poll remote instances 17,005 54.74 0 0 0.04
enq: PS - contention 380 0.00 0 0 0.00
latch: ges resource hash list 16,207 0.00 0 0 0.04
cursor: pin S wait on X 10 90.00 0 14 0.00
reliable message 548 0.00 0 0 0.00
PX Deq: reap credit 7,617 92.49 0 0 0.02
enq: TT - contention 337 0.00 0 0 0.00
PX Deq Credit: send blkd 489 72.39 0 0 0.00
KJC: Wait for msg sends to complete 74 0.00 0 1 0.00
enq: TD - KTF dump entries 20 0.00 0 3 0.00
enq: TX - index contention 8 0.00 0 5 0.00
latch: row cache objects 68 0.00 0 1 0.00
SQL*Net more data to client 2,037 0.00 0 0 0.00
latch: session allocation 26 0.00 0 1 0.00
rdbms ipc reply 82 0.00 0 0 0.00
PX Deq: Signal ACK 240 30.83 0 0 0.00
buffer deadlock 4 100.00 0 3 0.00
IPC send completion sync 68 100.00 0 0 0.00
latch: checkpoint queue latch 80 0.00 0 0 0.00
latch: undo global data 35 0.00 0 0 0.00
library cache pin 9 0.00 0 1 0.00
enq: JS - job run lock - synchronize 3 0.00 0 1 0.00
ges inquiry response 6 0.00 0 0 0.00
enq: WL - contention 8 0.00 0 0 0.00
enq: MW - contention 4 0.00 0 0 0.00
enq: DR - contention 4 0.00 0 0 0.00
latch: messages 28 0.00 0 0 0.00
gc current split 3 0.00 0 0 0.00
SQL*Net break/reset to client 4 0.00 0 0 0.00
enq: AF - task serialization 1 0.00 0 1 0.00
latch: library cache 3 0.00 0 0 0.00
enq: TX - allocate ITL entry 1 0.00 0 0 0.00
enq: TA - contention 1 0.00 0 0 0.00
latch: shared pool 1 0.00 0 0 0.00
lock deadlock retry 6 100.00 0 0 0.00
SQL*Net message from client 1,268,527 0.00 2,599,431 2049 2.85
gcs remote message 5,219,654 92.96 13,266 3 11.73
Streams AQ: qmn slave idle wait 276 0.36 7,061 25583 0.00
virtual circuit status 240 100.00 7,026 29275 0.00
PX Idle Wait 2,951 93.87 7,024 2380 0.01
DIAG idle wait 35,585 0.00 7,023 197 0.08
ges remote message 163,795 91.22 7,006 43 0.37
Streams AQ: qmn coordinator idle wait 441 57.60 6,996 15865 0.00
Streams AQ: waiting for time management or cleanup tasks 24 0.00 6,848 285323 0.00
jobq slave wait 56 96.43 159 2834 0.00
PX Deq: Execution Msg 667 7.35 1 1 0.00
PX Deq: Join ACK 413 34.62 0 1 0.00
PX Deq: Parse Reply 385 33.77 0 0 0.00
PX Deq: Msg Fragment 278 2.52 0 0 0.00
PX Deq: Execute Reply 355 36.06 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 537 100.00 0 0 0.00
class slave wait 3 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 32,059 0.00 1,559 49 0.07
log file parallel write 256,650 0.00 931 4 0.58
log file sequential read 32,303 0.00 424 13 0.07
db file parallel write 92,674 0.00 421 5 0.21
events in waitclass Other 151,117 66.38 71 0 0.34
control file parallel write 4,479 0.00 50 11 0.01
control file sequential read 23,968 0.00 34 1 0.05
direct path read 11,038 0.00 3 0 0.02
db file sequential read 77 0.00 1 10 0.00
latch: cache buffers chains 209 0.00 1 3 0.00
buffer busy waits 233 23.61 1 2 0.00
os thread startup 11 0.00 1 46 0.00
row cache lock 1,044 0.00 0 0 0.00
gc current block busy 63 0.00 0 5 0.00
enq: HW - contention 1,106 0.09 0 0 0.00
direct path write 4,527 0.00 0 0 0.01
log file single write 102 0.00 0 2 0.00
latch: redo writing 7 0.00 0 30 0.00
enq: TM - contention 1,224 0.00 0 0 0.00
library cache lock 151 0.00 0 1 0.00
gc current grant congested 1 0.00 0 81 0.00
gc cr block busy 6 0.00 0 12 0.00
gc current grant busy 15 0.00 0 5 0.00
gc cr block 2-way 172 0.00 0 0 0.00
gc current block 2-way 152 0.00 0 0 0.00
gc current grant 2-way 45 0.00 0 0 0.00
gc current multi block request 30 0.00 0 0 0.00
gc cr multi block request 8 0.00 0 0 0.00
gc cr grant 2-way 4 0.00 0 0 0.00
gc buffer busy 1 0.00 0 0 0.00
latch: row cache objects 9 0.00 0 0 0.00
rdbms ipc message 433,008 27.35 85,933 198 0.97
gcs remote message 5,219,647 92.96 13,266 3 11.73
DIAG idle wait 35,586 0.00 7,023 197 0.08
pmon timer 3,034 99.97 7,022 2314 0.01
ges remote message 163,792 91.22 7,006 43 0.37
Streams AQ: qmn coordinator idle wait 441 57.60 6,996 15865 0.00
Streams AQ: waiting for time management or cleanup tasks 24 0.00 6,848 285323 0.00
smon timer 219 0.46 6,770 30912 0.00
PX Deq: Join ACK 59 40.68 0 1 0.00
PX Deq: Parse Reply 54 42.59 0 0 0.00
PX Deq: Execute Reply 42 47.62 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 537 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 443,128
AVG_IDLE_TIME 276,323
AVG_IOWAIT_TIME 7,678
AVG_SYS_TIME 13,843
AVG_USER_TIME 429,076
BUSY_TIME 3,546,724
IDLE_TIME 2,212,290
IOWAIT_TIME 62,457
SYS_TIME 112,403
USER_TIME 3,434,321
LOAD 1
OS_CPU_WAIT_TIME ###############
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 600,981,504
VM_OUT_BYTES 3,403,776
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 42,171.70 32,124.70 960,897 844,331,885
SYS$USERS 3,070.10 1,707.60 114,895 52,901,747
SYS$BACKGROUND 0.00 0.00 11,482 11,460,786
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 445363 124970 58150 2855 0 0 1498207 19513
SYS$USERS 115025 83620 310 93 0 0 375773 40
SYS$BACKGROUND 19455 2545 1713 223 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,856 8,637 5,509 1.97 23.92 7qfa96rjvwpn7   select upper(trim(Contra...
10,833 8,600 5,559 1.95 23.86 9fkdpsxmxuuuc   select sum(tradeFee) as ...
10,702 8,636 5,477 1.95 23.58 0a427kdru2y2z   select upper(trim(Contra...
1,453 1,196 513 2.83 3.20 00rx13qt6xnt1 ftloader@ftloader-comp (TNS V1-V3) UPDATE S_UPLOADFILE SET VERIFY...
1,052 512 2 526.09 2.32 crg3ddq082jcd ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
1,049 808 5,581 0.19 2.31 2m4pb8z36g8dm   select sum(p.tradem...
1,043 811 5,485 0.19 2.30 6mn3ma8z2v8tz   select upper(trim(p.contracti...
780 526 57 13.69 1.72 3dtxbtwzff3xg ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
547 90 2 273.75 1.21 dn6qa7w7wpuz3 ftloader@ftloader-exch (TNS V1-V3) DELETE FROM B_EXCHANGECLIENTIN...
508 310 57 8.92 1.12 2tjgtuv9y423b ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
477 225 57 8.37 1.05 f3s0860d6xzx4 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,637 10,856 5,509 1.57 23.92 7qfa96rjvwpn7   select upper(trim(Contra...
8,636 10,702 5,477 1.58 23.58 0a427kdru2y2z   select upper(trim(Contra...
8,600 10,833 5,559 1.55 23.86 9fkdpsxmxuuuc   select sum(tradeFee) as ...
1,196 1,453 513 2.33 3.20 00rx13qt6xnt1 ftloader@ftloader-comp (TNS V1-V3) UPDATE S_UPLOADFILE SET VERIFY...
811 1,043 5,485 0.15 2.30 6mn3ma8z2v8tz   select upper(trim(p.contracti...
808 1,049 5,581 0.14 2.31 2m4pb8z36g8dm   select sum(p.tradem...
526 780 57 9.23 1.72 3dtxbtwzff3xg ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
512 1,052 2 256.21 2.32 crg3ddq082jcd ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
372 413 81 4.59 0.91 ff05sfkwgqd82   select count(*) from ...
371 410 79 4.70 0.90 brq34n0ckh30z   select * from (select row...
310 508 57 5.44 1.12 2tjgtuv9y423b ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
225 477 57 3.95 1.05 f3s0860d6xzx4 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
90 547 2 45.04 1.21 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
202,036,279 5,509 36,673.86 22.22 8636.67 10855.99 7qfa96rjvwpn7   select upper(trim(Contra...
201,577,151 5,477 36,804.30 22.17 8636.49 10702.48 0a427kdru2y2z   select upper(trim(Contra...
200,919,069 5,559 36,143.02 22.10 8599.60 10832.97 9fkdpsxmxuuuc   select sum(tradeFee) as ...
42,180,427 2 21,090,213.50 4.64 512.42 1052.18 crg3ddq082jcd ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
33,780,207 57 592,635.21 3.72 525.83 780.46 3dtxbtwzff3xg ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
21,429,682 57 375,959.33 2.36 225.08 477.09 f3s0860d6xzx4 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
21,414,325 513 41,743.32 2.36 1195.67 1452.89 00rx13qt6xnt1 ftloader@ftloader-comp (TNS V1-V3) UPDATE S_UPLOADFILE SET VERIFY...
21,157,299 32 661,165.59 2.33 180.06 258.55 60x3brjwuf8wg ftloader@ftloader-comp (TNS V1-V3) DELETE FROM H_COMPCLIENTTRADE ...
20,522,836 57 360,049.75 2.26 178.69 396.52 5w0bk6653fd31 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
16,610,618 5,581 2,976.28 1.83 807.71 1048.76 2m4pb8z36g8dm   select sum(p.tradem...
16,596,543 5,485 3,025.81 1.83 810.74 1042.56 6mn3ma8z2v8tz   select upper(trim(p.contracti...
15,605,273 1 15,605,273.00 1.72 281.94 309.86 4vdwptg0zy9c2 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
15,595,137 2 7,797,568.50 1.72 104.32 152.37 bn5vag98hwdsc ftloader@ftloader-exch (TNS V1-V3) INSERT INTO B_EXCHANGECLIENTIN...
14,681,926 57 257,577.65 1.61 309.82 508.43 2tjgtuv9y423b ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
13,510,880 2 6,755,440.00 1.49 165.84 187.28 d280mar5508fn ftloader@ftloader-exch (TNS V1-V3) UPDATE D_EXCLIENT SET COMPANYI...
11,611,191 57 203,705.11 1.28 248.97 434.03 7atxcf47w434k ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...

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
263,235 2 131,617.50 24.21 512.42 1052.18 crg3ddq082jcd ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
242,424 57 4,253.05 22.30 309.82 508.43 2tjgtuv9y423b ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
241,964 57 4,244.98 22.25 98.34 231.60 cmv9h31tgyvku ftloader@ftloader-comp (TNS V1-V3) INSERT INTO H_COMPCLIENTLIQUID...
171,178 2 85,589.00 15.74 90.07 547.49 dn6qa7w7wpuz3 ftloader@ftloader-exch (TNS V1-V3) DELETE FROM B_EXCHANGECLIENTIN...
60,481 2 30,240.50 5.56 104.32 152.37 bn5vag98hwdsc ftloader@ftloader-exch (TNS V1-V3) INSERT INTO B_EXCHANGECLIENTIN...
57,949 49,020 1.18 5.33 64.25 90.60 4c7auvka8tuwt SQL Loader Conventional Path Load INSERT INTO D_EXCLIENT (UPLO...
49,762 877 56.74 4.58 9.50 350.53 cfz4zjsvyvna2   select sum(tradeFee) as amoun...
41,847 2 20,923.50 3.85 127.33 142.86 ba2gnb2yx62xm ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
33,771 127 265.91 3.11 5.48 282.70 asw9wyj0jrdya   select * from (select row...
32,698 57 573.65 3.01 178.69 396.52 5w0bk6653fd31 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
31,330 57 549.65 2.88 525.83 780.46 3dtxbtwzff3xg ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
26,678 1 26,678.00 2.45 281.94 309.86 4vdwptg0zy9c2 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
21,246 2 10,623.00 1.95 73.61 78.24 2vs7jmbhqf4ud ftloader@ftloader-exch (TNS V1-V3) DELETE FROM D_EXCLIENT WHERE O...
20,441 1 20,441.00 1.88 68.78 73.22 5s1ygwu1wftc7 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
18,950 2 9,475.00 1.74 10.58 128.60 8uzm63zwukdgf ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_201...
18,936 2 9,468.00 1.74 10.48 128.46 3q2dvssqjjb9z ftloader@ftloader-exch (TNS V1-V3) UPDATE D_EXWARRANT SET CLIENTI...
18,561 57 325.63 1.71 225.08 477.09 f3s0860d6xzx4 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...

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
49,020 2,151,126 43.88 0.00 0.00 4c7auvka8tuwt SQL Loader Conventional Path Load INSERT INTO D_EXCLIENT (UPLO...
16,506 16,506 1.00 0.00 0.00 94q21h4pxztn5   insert into S_querylog2 (Use...
11,110 2,275 0.20 0.00 0.00 8qf6j91mzyd8b   select trim(companyid) as...
8,608 8,608 1.00 0.00 0.00 80xjxz9ng49d0   select nvl(sum(amount), 0)*(-1...
8,556 4 0.00 0.00 0.00 dfukfxgqzt4zr   select trim(UPLOADDATE) a...
7,118 7,118 1.00 0.00 0.00 c8rabv4fbn0m2   select count(*) cnt from S_UPL...
7,021 1,241 0.18 0.00 0.00 419wzfvahqftd   select trim(companyid) as comp...
6,596 6,596 1.00 0.00 0.00 44wagnxkb429q   select trim(tradedate) as trad...
6,084 4,817 0.79 0.00 0.00 6k24bmcwygp73   select cf.LastRIGHTByDate as L...
5,581 5,579 1.00 0.14 0.19 2m4pb8z36g8dm   select sum(p.tradem...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
11,110 11,110 4.54 8qf6j91mzyd8b   select trim(companyid) as...
8,604 8,608 3.52 80xjxz9ng49d0   select nvl(sum(amount), 0)*(-1...
8,526 8,556 3.49 dfukfxgqzt4zr   select trim(UPLOADDATE) a...
6,466 7,021 2.64 419wzfvahqftd   select trim(companyid) as comp...
5,581 5,581 2.28 2m4pb8z36g8dm   select sum(p.tradem...
5,578 5,578 2.28 93qahzxxy05yk   select sum(iofund) as iof...
5,577 5,577 2.28 4kq5x7a4z4u61   select sum...
5,576 5,576 2.28 2p2kkxfafykma   select cf.LastRIGHTByDate as...
5,559 5,559 2.27 9fkdpsxmxuuuc   select sum(tradeFee) as ...
5,558 5,558 2.27 5wznbubjmu151   select sum(h.DELI...
5,535 5,535 2.26 cnt7yg6vxwjsr   select trim(tradedate) as...
5,512 5,512 2.25 c0jxhvv0t9aa5   select trim(f.UPLOADDATE) as U...
5,509 5,509 2.25 7qfa96rjvwpn7   select upper(trim(Contra...
5,489 5,489 2.24 df7g4a1dgjhut   select trim(UPLOADDATE...
5,485 5,485 2.24 6mn3ma8z2v8tz   select upper(trim(p.contracti...
5,483 5,483 2.24 59sx298kg9vtk   select upper(trim(l.contrac...
5,480 5,480 2.24 468szzx5xjkj7   select trim(h.UPLOADDATE) as U...
5,479 5,479 2.24 cufhzatnw3p2q   select trim(c1.contractid)...
5,477 5,477 2.24 0a427kdru2y2z   select upper(trim(Contra...
4,607 6,084 1.88 6k24bmcwygp73   select cf.LastRIGHTByDate as L...
4,248 6,596 1.74 44wagnxkb429q   select trim(tradedate) as trad...
4,169 7,118 1.70 c8rabv4fbn0m2   select count(*) cnt from S_UPL...
3,901 4,284 1.59 cr1x70pknnc24   select sum(p.tradema...
3,827 3,944 1.56 6jk9yfhybspy8   select sum(h.DELIVMA...
3,558 16,506 1.45 94q21h4pxztn5   insert into S_querylog2 (Use...
3,355 3,376 1.37 8acpt198p5sth   select upper(trim(p.contractid...
3,041 3,047 1.24 2uhw1qu31ttbj   select sum(tradeFee) as amoun...
3,035 3,042 1.24 gmwrfynvhknk1   select trim(f.UPLOADDATE) as U...
3,023 3,066 1.24 cvvqarnj98y1n   select upper(trim(ContractID))...
3,009 3,073 1.23 1u6jbdkmv48r3   select sum(amou...
2,993 3,078 1.22 7ggnhx1n3c34q   select sum(iofund) as iofundSu...
2,476 2,493 1.01 dyqs2ztpgy41s   select trim(h.UPLOADDATE) as U...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,507,614 5 0.07 8vkjh60z1g287   select OBJOID, CLSOID, RUNT...
1,293,537 2 0.06 31a13pnjps7j3   SELECT source, (case w...
1,228,824 4 0.06 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
51 16,506 94q21h4pxztn5   insert into S_querylog2 (Use...
50 1,799 4jvyst13gg4t8   select trim(q.preregdate) as p...
45 1,824 6sxfazsxu8t2p   select trim(u.userid) as useri...
39 3,066 cvvqarnj98y1n   select upper(trim(ContractID))...
33 3,047 2uhw1qu31ttbj   select sum(tradeFee) as amoun...
33 125 39x4ja4d5bu2x   select trim(q.preregdate) as p...
32 6,084 6k24bmcwygp73   select cf.LastRIGHTByDate as L...
32 3,376 8acpt198p5sth   select upper(trim(p.contractid...
32 2 fqvb8jxywth8n   SELECT startsn.sga_size_factor...
30 18 19rkm1wsf9axx   insert into WRI$_ALERT_HISTORY...
30 56 2814wp22z8vbu   insert into s_queryuserprereg(...
29 7,021 419wzfvahqftd   select trim(companyid) as comp...
29 451 5xacdx058vm1t   select upper(trim(l.contractid...
27 4 10xj8nynmpqtq   SELECT dbin.db_name, dbin.ins...
27 2 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
27 2 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...
27 2 gvynt9bqh451z   SELECT sum(case when snap_id ...
26 4,284 cr1x70pknnc24   select sum(p.tradema...
26 2 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
23 2 31a13pnjps7j3   SELECT source, (case w...
23 127 asw9wyj0jrdya   select * from (select row...
22 2 5an8d9ctcysja   SELECT (case when snap_id = ...
22 2 b5yyh2vc9g8tm   SELECT sx.id, sum(decode(e.sn...
21 2,148 1zp77h050wb9d   SELECT FAILEDTIMES, FAILE...

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
182.08 58.99 308.64 136.66 149 audcbn70dd6d3   select trim(ca.bankid) as bank...
171.99 1.59 10,832.97 8,599.60 5,559 9fkdpsxmxuuuc   select sum(tradeFee) as ...
152.10 1.40 10,855.99 8,636.67 5,509 7qfa96rjvwpn7   select upper(trim(Contra...
148.21 1.38 10,702.48 8,636.49 5,477 0a427kdru2y2z   select upper(trim(Contra...
121.36 27.96 434.03 248.97 57 7atxcf47w434k ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
99.84 32.46 307.60 171.21 57 9wptn3zs4wxhg ftloader@ftloader-comp (TNS V1-V3) DELETE FROM B_CLIACC WHERE SUB...
91.66 18.03 508.43 309.82 57 2tjgtuv9y423b ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
86.10 11.03 780.46 525.83 57 3dtxbtwzff3xg ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
77.42 33.43 231.60 98.34 57 cmv9h31tgyvku ftloader@ftloader-comp (TNS V1-V3) INSERT INTO H_COMPCLIENTLIQUID...
76.03 15.94 477.09 225.08 57 f3s0860d6xzx4 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
67.15 16.94 396.52 178.69 57 5w0bk6653fd31 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
57.37 5.45 1,052.18 512.42 2 crg3ddq082jcd ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
34.53 63.31 54.54 20.11 16,506 94q21h4pxztn5   insert into S_querylog2 (Use...
26.64 14.22 187.28 165.84 2 d280mar5508fn ftloader@ftloader-exch (TNS V1-V3) UPDATE D_EXCLIENT SET COMPANYI...
22.76 7.82 290.87 211.38 57 fnk9j5amqb284 ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
21.10 6.02 350.53 9.50 877 cfz4zjsvyvna2   select sum(tradeFee) as amoun...
19.31 7.47 258.55 180.06 32 60x3brjwuf8wg ftloader@ftloader-comp (TNS V1-V3) DELETE FROM H_COMPCLIENTTRADE ...
15.73 5.94 264.77 199.81 57 17gr1mx53vanf ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
15.17 2.77 547.49 90.07 2 dn6qa7w7wpuz3 ftloader@ftloader-exch (TNS V1-V3) DELETE FROM B_EXCHANGECLIENTIN...
13.26 4.69 282.70 5.48 127 asw9wyj0jrdya   select * from (select row...
8.47 7.59 111.55 23.29 32 9gx5ddb42jj2p ftloader@ftloader-comp (TNS V1-V3) DELETE FROM B_EXCHANGECLIENTMA...
8.34 3.85 216.74 173.88 58 1w8xha904vdan ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
6.62 4.34 152.37 104.32 2 bn5vag98hwdsc ftloader@ftloader-exch (TNS V1-V3) INSERT INTO B_EXCHANGECLIENTIN...
6.25 71.47 8.74 1.73 7,118 c8rabv4fbn0m2   select count(*) cnt from S_UPL...
6.15 3.16 194.93 151.74 57 313g1fc4xtatq ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
5.52 2.32 238.06 147.26 57 4gmpxsqc0h8cm ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
5.28 0.50 1,048.76 807.71 5,581 2m4pb8z36g8dm   select sum(p.tradem...
5.21 0.36 1,452.89 1,195.67 513 00rx13qt6xnt1 ftloader@ftloader-comp (TNS V1-V3) UPDATE S_UPLOADFILE SET VERIFY...
5.16 0.50 1,042.56 810.74 5,485 6mn3ma8z2v8tz   select upper(trim(p.contracti...
4.51 7.00 64.45 60.48 2 gq0ktakkch2d6 ftloader@ftloader-exch (TNS V1-V3) INSERT INTO H_EXCLIENT(UPLOADD...
4.29 43.24 9.92 5.02 7,021 419wzfvahqftd   select trim(companyid) as comp...
3.83 4.22 90.60 64.25 49,020 4c7auvka8tuwt SQL Loader Conventional Path Load INSERT INTO D_EXCLIENT (UPLO...
3.60 11.56 31.16 17.18 5,576 2p2kkxfafykma   select cf.LastRIGHTByDate as...
3.36 1.08 309.86 281.94 1 4vdwptg0zy9c2 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
3.01 54.59 5.51 2.84 5,479 cufhzatnw3p2q   select trim(c1.contractid)...
2.73 3.18 85.83 77.82 82 cs7kbbdra99hs   select * from (select row...
2.58 21.80 11.84 3.45 5,483 59sx298kg9vtk   select upper(trim(l.contrac...
2.40 69.13 3.46 1.61 8,608 80xjxz9ng49d0   select nvl(sum(amount), 0)*(-1...
2.21 12.48 17.69 6.77 6,084 6k24bmcwygp73   select cf.LastRIGHTByDate as L...
1.89 44.32 4.27 1.72 4,284 cr1x70pknnc24   select sum(p.tradema...
1.84 2.35 78.24 73.61 2 2vs7jmbhqf4ud ftloader@ftloader-exch (TNS V1-V3) DELETE FROM D_EXCLIENT WHERE O...
1.71 82.28 2.08 1.01 3,078 7ggnhx1n3c34q   select sum(iofund) as iofundSu...
1.64 38.13 4.30 3.20 3,066 cvvqarnj98y1n   select upper(trim(ContractID))...
1.54 1.20 128.60 10.58 2 8uzm63zwukdgf ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_201...
1.54 1.20 128.46 10.48 2 3q2dvssqjjb9z ftloader@ftloader-exch (TNS V1-V3) UPDATE D_EXWARRANT SET CLIENTI...
1.13 24.93 4.55 2.43 11,110 8qf6j91mzyd8b   select trim(companyid) as...
1.03 6.37 16.21 1.80 3,047 2uhw1qu31ttbj   select sum(tradeFee) as amoun...
0.82 1.12 73.22 68.78 1 5s1ygwu1wftc7 ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
0.78 72.47 1.07 0.71 3,073 1u6jbdkmv48r3   select sum(amou...
0.77 39.05 1.96 1.38 1,804 c8n9a2kcjgq2u   update S_queryUser2 set co...
0.74 0.52 142.86 127.33 2 ba2gnb2yx62xm ftloader@ftloader-exch (TNS V1-V3) begin up_ChkExchUploadFile_200...
0.69 0.44 157.96 149.66 2,148 1zp77h050wb9d   SELECT FAILEDTIMES, FAILE...
0.64 0.67 95.66 90.79 1,278 g8a0pshdz9zds   UPDATE S_QUERYLOGINFAIL SET is...
0.57 17.76 3.24 0.86 451 5xacdx058vm1t   select upper(trim(l.contractid...
0.51 62.77 0.82 0.40 1,799 4jvyst13gg4t8   select trim(q.preregdate) as p...
0.45 43.92 1.03 0.82 872 bd13sdj0ty0q4 SQL Loader Conventional Path Load SELECT 'X' FROM SYS.ALL_OBJECT...
0.44 54.66 0.80 0.38 1,160 aq4js2gkfjru8   update tsq$ set blocks=:3, max...
0.40 0.23 175.24 140.38 57 1jr81ad0apv3x ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_300...
0.39 23.16 1.69 1.03 2,896 d18fym9k71dtn   select trim(u.userid) as useri...
0.38 21.48 1.78 1.31 1,824 6sxfazsxu8t2p   select trim(u.userid) as useri...
0.36 24.05 1.49 0.77 5,577 4kq5x7a4z4u61   select sum...
0.32 0.32 100.24 70.62 30 dqfqqs8zdc3ts ftloader@ftloader-comp (TNS V1-V3) begin up_ChkCompUploadFile_301...
0.32 32.86 0.96 0.95 3,042 gmwrfynvhknk1   select trim(f.UPLOADDATE) as U...
0.29 5.89 4.90 2.11 3,376 8acpt198p5sth   select upper(trim(p.contractid...

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)
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;
1zp77h050wb9dSELECT FAILEDTIMES, FAILEDDATE, FAILEDTIME FROM S_QUERYLOGINFAIL WHERE isactive = 'Y' and USERID = :1
2814wp22z8vbuinsert into s_queryuserprereg(preregdate, preregtime, userid, password, companyid, clienttype, usertype) values( to_char(systimestamp, 'yyyy-mm-dd'), to_char(systimestamp, 'hh24:mi:ss'), :1, substr(to_char(trunc(dbms_random.value(10000000, 99999999))), 1, 4)||dbms_random.string('a', '4'), :2, :3, decode(:4, '3', 'P', '4', 'P', 'C'))
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
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
2vs7jmbhqf4udDELETE FROM D_EXCLIENT WHERE OPENDATE=:B2 AND EXCHANGEID=:B1 AND COMPANYID IS NOT NULL
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
39x4ja4d5bu2xselect 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) and q.companyid=trim(:2)
3dtxbtwzff3xgbegin up_ChkCompUploadFile_3006(PI_TRADEDATE=>:PI_TRADEDATE, PI_COMPID=>:PI_COMPID, PO_ERRORID=>:PO_ERRORID); end;
3q2dvssqjjb9zUPDATE D_EXWARRANT SET CLIENTID=(SELECT CLIENTID FROM B_EXCHANGECLIENTMAP WHERE COMPANYID=D_EXWARRANT.COMPANYID AND EXCHANGEID=D_EXWARRANT.EXCHANGEID AND EXCLIENTID=D_EXWARRANT.EXCLIENTID ) WHERE EXCHANGEID=:B2 AND TRADEDATE=:B1
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
4c7auvka8tuwtINSERT INTO D_EXCLIENT (UPLOADDATE, EXCHANGEID, OPENDATE, NAME, IDENTITY, EXCOMPANYID, EXCLIENTID, LOCATE, ADDRESS, POSTCODE, TELEPHONE, CLIENTTYPE, REALOPENDATE, ORGANCODE, BUSINESSCODE, DEPUTYNAME, DEPUTYIDENTITY, EXCLIENTIDTYPE, CLIENTSTATE, CLIENTREGION, NATIONALITY, IDENTITY_NO, LICENSE_NO, BROKERID) VALUES (:UPLOADDATE, :EXCHANGEID, :OPENDATE, :NAME, :IDENTITY, :EXCOMPANYID, :EXCLIENTID, :LOCATE, :ADDRESS, :POSTCODE, :TELEPHONE, :CLIENTTYPE, :REALOPENDATE, :ORGANCODE, :BUSINESSCODE, :DEPUTYNAME, :DEPUTYIDENTITY, :EXCLIENTIDTYPE, :CLIENTSTATE, :CLIENTREGION, :NATIONALITY, :IDENTITY_NO, :LICENSE_NO, replace(trim(:"BROKERID"), ' '))
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')
4vdwptg0zy9c2begin up_ChkExchUploadFile_2004(PI_TRADEDATE=>:PI_TRADEDATE, PI_EXCHID=>:PI_EXCHID, PO_ERRORID=>:PO_ERRORID); end;
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))
6sxfazsxu8t2pselect trim(u.userid) as userid, trim(u.password) as password, trim(u.usertype) as usertype, trim(u.companyid) as companyid, trim(u.username) as username, trim(u.email) as email, trim(u.phone) as phone, upper(trim(u.status)) as status, upper(trim(u.firstlogin)) as firstlogin, trim(c.companyname) as companyName, trim(c.shortname) as shortName, upper(trim(u.notifystatus)) as notifystatus, trim(u.notifydate) as notifydate, trim(u.notifytime) as notifytime, trim(u.initpassword) as initpassword, trim(u.activedate) as activedate, nvl2(length(trim(u.companyid)), substr(trim(u.userid), length(trim(u.companyid))+1), '') compClientid, u.countlogintimes as countlogintimes, trim(u.lastlogindate) as lastlogindate, trim(u.lastlogintime) as lastlogintime, trim(u.defaultClearingType) as defaultClearingType, trim(u.createstaticfile) as createstaticfile, u.countinitlogintimes as countinitlogintimes from S_queryUser2 u, b_company c where u.companyid =c.companyid(+) and u.userid=:1 and trim(u.password)=trim(PKG_ENCRYPT_DECRYPT.ENCRYPT_3KEY_MODE(:2))
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
8uzm63zwukdgfbegin up_ChkExchUploadFile_2013(PI_TRADEDATE=>:PI_TRADEDATE, PI_EXCHID=>:PI_EXCHID, PO_ERRORID=>:PO_ERRORID); end;
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)
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
ba2gnb2yx62xmbegin up_ChkExchUploadFile_2005(PI_TRADEDATE=>:PI_TRADEDATE, PI_EXCHID=>:PI_EXCHID, PO_ERRORID=>:PO_ERRORID); end;
bd13sdj0ty0q4SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = 'TABLE'
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')
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')
cfz4zjsvyvna2select sum(tradeFee) as amount from h_compclienttrade where clientid=:1 and TradeDate between :2 and :3
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;
cs7kbbdra99hs select * from (select rownum as tmp, a.* from ( select trim(u.userid) as userid, trim(u.password) as password, upper(trim(u.usertype)) as usertype, trim(u.companyid) as companyid, trim(u.username) as username, trim(u.email) as email, trim(u.phone) as phone, upper(trim(u.status)) as status, upper(trim(u.firstlogin)) as firstlogin, trim(c.companyname) as companyName, trim(c.shortname) as shortName, upper(trim(u.notifystatus)) as notifystatus, trim(u.notifydate) as notifydate, trim(u.notifytime) as notifytime, nvl2(length(trim(u.companyid)), substr(trim(u.userid), length(trim(u.companyid))+1), '') compClientid, trim(u.initpassword) as initpassword, trim(u.OPENDATE) as OPENDATE, trim(u.activedate) as activedate, trim(u.OPENTIME) as OPENTIME, u.countinitlogintimes as countinitlogintimes from S_queryUser2 u, b_company c where u.companyid =:1 and upper(trim(u.usertype)) in ('C', 'P') and u.companyid =c.companyid(+) order by u.userid ) a ) WHERE tmp>=:2 and tmp<=:3
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))
d18fym9k71dtnselect trim(u.userid) as userid, trim(u.password) as password, trim(u.usertype) as usertype, trim(u.companyid) as companyid, trim(u.username) as username, trim(u.email) as email, trim(u.phone) as phone, upper(trim(u.status)) as status, upper(trim(u.firstlogin)) as firstlogin, trim(c.companyname) as companyName, trim(c.shortname) as shortName, upper(trim(u.notifystatus)) as notifystatus, trim(u.notifydate) as notifydate, trim(u.notifytime) as notifytime, trim(u.initpassword) as initpassword, trim(u.activedate) as activedate, nvl2(length(trim(u.companyid)), substr(trim(u.userid), length(trim(u.companyid))+1), '') compClientid, u.countlogintimes as countlogintimes, trim(u.lastlogindate) as lastlogindate, trim(u.lastlogintime) as lastlogintime, trim(u.defaultClearingType) as defaultClearingType, trim(u.createstaticfile) as createstaticfile, u.countinitlogintimes as countinitlogintimes from S_queryUser2 u, b_company c where u.companyid =c.companyid(+) and u.userid=:1
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
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
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(+))
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
g8a0pshdz9zdsUPDATE S_QUERYLOGINFAIL SET isactive = 'N' WHERE USERID = :1 and isactive = 'Y'
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')
gq0ktakkch2d6INSERT INTO H_EXCLIENT(UPLOADDATE, EXCHANGEID, OPENDATE, NAME, IDENTITY, EXCOMPANYID, EXCLIENTID, LOCATE, ADDRESS, POSTCODE, TELEPHONE, CHECKTAG, COMPANYID, REALOPENDATE, CLIENTTYPE, ORGANCODE, BUSINESSCODE, DEPUTYNAME, DEPUTYIDENTITY, EXCLIENTIDTYPE, CLIENTSTATE, CLIENTREGION, NATIONALITY , IDENTITY_NO, LICENSE_NO, BROKERID) SELECT UPLOADDATE, UPPER(EXCHANGEID), OPENDATE, NAME, IDENTITY, EXCOMPANYID, EXCLIENTID, LOCATE, ADDRESS, POSTCODE, TELEPHONE, CHECKTAG, COMPANYID, REALOPENDATE, CLIENTTYPE, ORGANCODE, BUSINESSCODE, DEPUTYNAME, DEPUTYIDENTITY, NVL(EXCLIENTIDTYPE, '0'), CLIENTSTATE, CLIENTREGION, NATIONALITY , IDENTITY_NO, LICENSE_NO, BROKERID FROM D_EXCLIENT WHERE OPENDATE=:B2 AND EXCHANGEID=:B1 AND COMPANYID IS NOT NULL
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,355,343 466.17 7.54
CPU used when call started 3,356,328 466.31 7.54
CR blocks created 435,776 60.54 0.98
Cached Commit SCN referenced 1,716 0.24 0.00
Commit SCN cached 2 0.00 0.00
DB time 4,653,678 646.56 10.45
DBWR checkpoint buffers written 3,013,593 418.69 6.77
DBWR checkpoints 17 0.00 0.00
DBWR fusion writes 369,153 51.29 0.83
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 863 0.12 0.00
DBWR undo block writes 2,064,119 286.78 4.64
DFO trees parallelized 144 0.02 0.00
Misses for writing mapping 0 0.00 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 496 0.07 0.00
PX remote messages sent 734 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 6 0.00 0.00
RowCR attempts 1,512,721 210.17 3.40
RowCR hits 1,513,506 210.28 3.40
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,266,782 176.00 2.85
active txn count during cleanout 2,504,545 347.97 5.63
application wait time 29 0.00 0.00
background checkpoints completed 18 0.00 0.00
background checkpoints started 17 0.00 0.00
background timeouts 29,496 4.10 0.07
branch node splits 980 0.14 0.00
buffer is not pinned count 520,522,802 72,318.84 1,169.32
buffer is pinned count 48,933,921,238 6,798,634.72 109,926.57
bytes received via SQL*Net from client 1,574,041,076 218,689.41 3,535.97
bytes sent via SQL*Net to client 156,787,524 21,783.28 352.21
calls to get snapshot scn: kcmgss 4,149,068 576.45 9.32
calls to kcmgas 6,919,953 961.42 15.55
calls to kcmgcs 2,433,914 338.16 5.47
change write time 51,545 7.16 0.12
cleanout - number of ktugct calls 2,750,731 382.17 6.18
cleanouts and rollbacks - consistent read gets 176,716 24.55 0.40
cleanouts only - consistent read gets 160,612 22.31 0.36
cluster key scan block gets 26,004 3.61 0.06
cluster key scans 7,690 1.07 0.02
cluster wait time 144,690 20.10 0.33
commit batch/immediate performed 157 0.02 0.00
commit batch/immediate requested 157 0.02 0.00
commit cleanout failures: block lost 7,094 0.99 0.02
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 47,214 6.56 0.11
commit cleanout failures: cannot pin 18 0.00 0.00
commit cleanouts 2,845,305 395.31 6.39
commit cleanouts successfully completed 2,790,979 387.76 6.27
commit immediate performed 157 0.02 0.00
commit immediate requested 157 0.02 0.00
commit txn count during cleanout 494,410 68.69 1.11
concurrency wait time 3,171 0.44 0.01
consistent changes 28,984,569 4,026.97 65.11
consistent gets 791,069,121 109,907.19 1,777.08
consistent gets - examination 34,990,652 4,861.43 78.60
consistent gets direct 0 0.00 0.00
consistent gets from cache 791,069,127 109,907.20 1,777.08
current blocks converted for CR 14,939 2.08 0.03
cursor authentications 134 0.02 0.00
data blocks consistent reads - undo records applied 28,568,253 3,969.13 64.18
db block changes 143,297,938 19,909.10 321.91
db block gets 118,154,493 16,415.80 265.43
db block gets direct 115 0.02 0.00
db block gets from cache 118,154,378 16,415.78 265.43
deferred (CURRENT) block cleanout applications 1,139,697 158.34 2.56
dirty buffers inspected 2,664 0.37 0.01
enqueue conversions 6,242 0.87 0.01
enqueue releases 1,057,810 146.97 2.38
enqueue requests 1,058,767 147.10 2.38
enqueue timeouts 958 0.13 0.00
enqueue waits 17,719 2.46 0.04
exchange deadlocks 29 0.00 0.00
execute count 1,990,027 276.48 4.47
failed probes on index block reclamation 57 0.01 0.00
free buffer inspected 6,034,307 838.38 13.56
free buffer requested 6,339,867 880.83 14.24
gc CPU used by this session 92,232 12.81 0.21
gc blocks corrupt 0 0.00 0.00
gc blocks lost 96 0.01 0.00
gc cr block build time 9,736 1.35 0.02
gc cr block flush time 4,393 0.61 0.01
gc cr block receive time 89,059 12.37 0.20
gc cr block send time 4,433 0.62 0.01
gc cr blocks received 1,407,083 195.49 3.16
gc cr blocks served 1,524,770 211.84 3.43
gc current block flush time 1,760 0.24 0.00
gc current block pin time 5,682 0.79 0.01
gc current block receive time 45,261 6.29 0.10
gc current block send time 21,850 3.04 0.05
gc current blocks received 859,313 119.39 1.93
gc current blocks served 7,604,169 1,056.49 17.08
gc local grants 630,798 87.64 1.42
gc remote grants 799,774 111.12 1.80
gcs messages sent 6,226,645 865.10 13.99
ges messages sent 89,229 12.40 0.20
global enqueue get time 2,059 0.29 0.00
global enqueue gets async 6,943 0.96 0.02
global enqueue gets sync 342,257 47.55 0.77
global enqueue releases 330,481 45.92 0.74
heap block compress 10,658,525 1,480.84 23.94
hot buffers moved to head of LRU 1,825,540 253.63 4.10
immediate (CR) block cleanout applications 337,331 46.87 0.76
immediate (CURRENT) block cleanout applications 1,135,695 157.79 2.55
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 8,063 1.12 0.02
index fast full scans (full) 239 0.03 0.00
index fetch by key 2,361,863 328.15 5.31
index scans kdiixs1 1,040,594 144.57 2.34
leaf node 90-10 splits 478 0.07 0.00
leaf node splits 197,653 27.46 0.44
lob reads 36 0.01 0.00
lob writes 230 0.03 0.00
lob writes unaligned 230 0.03 0.00
logons cumulative 1,094 0.15 0.00
messages received 401,407 55.77 0.90
messages sent 401,407 55.77 0.90
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 751,534,739 104,414.48 1,688.27
opened cursors cumulative 244,745 34.00 0.55
parse count (failures) 0 0.00 0.00
parse count (hard) 3,490 0.48 0.01
parse count (total) 244,597 33.98 0.55
parse time cpu 856 0.12 0.00
parse time elapsed 1,258 0.17 0.00
physical read IO requests 579,020 80.45 1.30
physical read bytes 8,907,268,096 1,237,531.36 20,009.54
physical read total IO requests 699,991 97.25 1.57
physical read total bytes 43,964,042,240 6,108,144.54 98,762.09
physical read total multi block requests 72,713 10.10 0.16
physical reads 1,087,313 151.07 2.44
physical reads cache 849,984 118.09 1.91
physical reads cache prefetch 306,408 42.57 0.69
physical reads direct 237,329 32.97 0.53
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 226,291 31.44 0.51
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 1,116,884 155.17 2.51
physical write bytes 29,265,321,984 4,065,977.73 65,742.46
physical write total IO requests 1,777,281 246.93 3.99
physical write total bytes ############### 22,599,684.17 365,412.44
physical write total multi block requests 1,131,429 157.20 2.54
physical writes 3,572,427 496.34 8.03
physical writes direct 230,932 32.08 0.52
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 226,291 31.44 0.51
physical writes from cache 3,341,495 464.25 7.51
physical writes non checkpoint 3,322,561 461.62 7.46
pinned buffers inspected 8,443 1.17 0.02
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 1,484 0.21 0.00
process last non-idle time 6,365 0.88 0.01
queries parallelized 144 0.02 0.00
recursive aborts on index block reclamation 43 0.01 0.00
recursive calls 13,952,292 1,938.46 31.34
recursive cpu usage 397,287 55.20 0.89
redo blocks written 32,371,018 4,497.47 72.72
redo buffer allocation retries 1,658 0.23 0.00
redo entries 73,422,019 10,200.89 164.94
redo log space requests 509 0.07 0.00
redo log space wait time 514 0.07 0.00
redo ordering marks 1,910,001 265.37 4.29
redo size 32,468,211,712 4,510,971.24 72,937.52
redo subscn max counts 97,247 13.51 0.22
redo synch time 90,416 12.56 0.20
redo synch writes 235,063 32.66 0.53
redo wastage 144,877,280 20,128.53 325.46
redo write time 96,348 13.39 0.22
redo writer latching time 985 0.14 0.00
redo writes 256,664 35.66 0.58
rollback changes - undo records applied 943,699 131.11 2.12
rollbacks only - consistent read gets 187,250 26.02 0.42
rows fetched via callback 833,269 115.77 1.87
session connect time 0 0.00 0.00
session cursor cache hits 198,440 27.57 0.45
session logical reads 909,223,395 126,322.96 2,042.51
session pga memory 162,585,648 22,588.84 365.24
session pga memory max 787,915,792 109,469.09 1,770.00
session uga memory 12,808,596,728 1,779,562.48 28,773.60
session uga memory max 407,988,792 56,683.93 916.52
shared hash latch upgrades - no wait 1,596,211 221.77 3.59
shared hash latch upgrades - wait 252 0.04 0.00
sorts (disk) 10 0.00 0.00
sorts (memory) 52,120 7.24 0.12
sorts (rows) 58,011,931 8,059.89 130.32
sql area evicted 1,509 0.21 0.00
sql area purged 0 0.00 0.00
summed dirty queue length 3,621 0.50 0.01
switch current to new buffer 389,774 54.15 0.88
table fetch by rowid 24,722,561,385 3,434,829.25 55,537.47
table fetch continued row 3,501,585 486.49 7.87
table scan blocks gotten 83,620,981 11,617.88 187.85
table scan rows gotten 7,791,249,821 1,082,477.35 17,502.49
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 2 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 78,940 10.97 0.18
total number of times SMON posted 218 0.03 0.00
transaction lock background get time 0 0.00 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 157 0.02 0.00
transaction tables consistent read rollbacks 135 0.02 0.00
transaction tables consistent reads - undo records applied 7,717 1.07 0.02
undo change vector size 14,202,472,368 1,973,220.61 31,904.84
user I/O wait time 211,154 29.34 0.47
user calls 1,485,629 206.41 3.34
user commits 235,157 32.67 0.53
user rollbacks 209,994 29.18 0.47
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 188 0.03 0.00
workarea executions - optimal 42,087 5.85 0.09
write clones created in background 0 0.00 0.00
write clones created in foreground 143 0.02 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 494,583 502,598
opened cursors current 4,270 4,347
workarea memory allocated 107,398 471
logons current 400 426

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 17 8.50

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)
UNDOTBS2 136 0 17.43 1.00 386,803 54 908 0.84
MARGIN_D 122,346 17 1.70 3.48 217,428 30 6,942 4.28
MARGIN_B_IDX 119,872 17 3.69 1.00 146,917 20 14,780 0.42
MARGIN_B 149,059 21 2.88 1.00 98,583 14 39 3.08
MARGIN201304 2,234 0 8.25 1.61 115,391 16 236,401 0.51
MARGIN_D_IDX 29,623 4 2.85 1.00 56,593 8 11 0.00
MARGIN_IDX201304 6,948 1 3.45 1.00 69,557 10 64,535 0.75
MARGIN201303 66,937 9 6.74 1.00 184 0 915 4.60
TEMP 23,361 3 6.51 9.69 9,752 1 0 0.00
MARGIN_S 27,495 4 7.63 1.00 4,986 1 99 82.22
MARGIN_S_IDX 8,543 1 9.03 1.00 4,766 1 7 0.00
MARGIN_IDX201303 11,851 2 8.15 1.00 309 0 96 7.60
SYSAUX 503 0 7.71 1.11 842 0 0 0.00
MARGIN201302 865 0 10.72 1.00 120 0 0 0.00
MARGIN_IDX201207 685 0 14.41 1.00 220 0 0 0.00
MARGIN_IDX201211 689 0 16.23 1.00 203 0 0 0.00
MARGIN_IDX201209 587 0 20.48 1.00 242 0 0 0.00
MARGIN_IDX201208 601 0 29.07 1.00 225 0 0 0.00
MARGIN_IDX201301 584 0 12.00 1.00 190 0 0 0.00
MARGIN_IDX201212 564 0 17.41 1.00 200 0 0 0.00
MARGIN_IDX201210 556 0 15.76 1.00 187 0 0 0.00
MARGIN201301 568 0 13.43 1.00 160 0 0 0.00
MARGIN201209 525 0 22.25 1.00 198 0 0 0.00
MARGIN201208 519 0 29.23 1.00 184 0 0 0.00
MARGIN201212 532 0 17.69 1.00 170 0 0 0.00
MARGIN_IDX201302 532 0 9.49 1.00 140 0 0 0.00
MARGIN201211 485 0 18.16 1.00 186 0 0 0.00
MARGIN201210 484 0 17.02 1.00 165 0 0 0.00
MARGIN201207 435 0 32.48 1.00 170 0 0 0.00
SYSTEM 87 0 12.99 1.00 296 0 1 0.00
UNDOTBS1 132 0 16.89 1.00 132 0 4,772 2.72
MARGIN_R 83 0 16.87 1.00 41 0 0 0.00
MARGIN_R_IDX 83 0 16.14 1.00 41 0 0 0.00
MARGIN_C_IDX 80 0 14.75 1.00 41 0 0 0.00
MARGIN_C 77 0 15.19 1.00 41 0 0 0.00
MARGIN 70 0 11.00 1.00 45 0 0 0.00
AUTHCENTER 48 0 14.38 1.00 20 0 0 0.00
AUTHPUB 48 0 15.83 1.00 20 0 0 0.00
USERS 25 0 15.60 1.00 22 0 0 0.00
MARGIN_IDX 11 0 15.45 1.00 17 0 0 0.00
MARGIN_P_IDX 15 0 14.00 1.00 11 0 0 0.00
MARGIN_P 14 0 15.00 1.00 11 0 0 0.00
MARGIN_T 14 0 14.29 1.00 11 0 0 0.00
MARGIN_T_IDX 14 0 19.29 1.00 11 0 0 0.00
MARGIN_IDX201101 3 0 0.00 1.00 0 0 0 0.00
MARGIN_IDX201202 3 0 6.67 1.00 0 0 0 0.00
MARGIN201202 2 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 24 0 14.58 1.00 10 0 0 0.00
AUTHCENTER /dev/vgdatafc4g03/rraw_db_data_fc_4G_613 24 0 14.17 1.00 10 0 0 0.00
AUTHPUB /dev/vgdatafc4g03/rraw_db_data_fc_4G_586 24 0 15.00 1.00 10 0 0 0.00
AUTHPUB /dev/vgdatafc4g03/rraw_db_data_fc_4G_614 24 0 16.67 1.00 10 0 0 0.00
MARGIN /dev/vgdatafc4g01/rraw_db_data_fc_4G_1 19 0 11.05 1.00 25 0 0 0.00
MARGIN /dev/vgdatafc4g04/rraw_db_data_fc_4G_761 25 0 12.00 1.00 10 0 0 0.00
MARGIN /dev/vgdatafc4g04/rraw_db_data_fc_4G_762 26 0 10.00 1.00 10 0 0 0.00
MARGIN201202 /dev/vgdatafc8g03/rraw_db_data_fc_8G_637 2 0 10.00 1.00 0 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_701 24 0 31.67 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_702 24 0 32.50 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_703 24 0 33.75 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_704 24 0 32.92 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_705 24 0 33.33 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_706 24 0 39.58 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_707 24 0 31.67 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_708 24 0 35.00 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_709 24 0 34.58 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_710 24 0 34.17 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_711 24 0 34.58 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_712 24 0 33.33 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_713 24 0 34.58 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_714 24 0 34.17 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_715 31 0 29.35 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_716 34 0 25.88 1.00 10 0 0 0.00
MARGIN201207 /dev/vgdatafc8g03/rraw_db_data_fc_8G_717 34 0 27.06 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_718 34 0 25.00 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_719 34 0 26.76 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_720 34 0 28.53 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_721 34 0 25.88 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_722 34 0 25.00 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_723 34 0 24.41 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_724 23 0 32.61 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_725 23 0 36.52 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_726 23 0 33.04 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_727 23 0 33.91 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_728 23 0 34.78 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_729 23 0 31.30 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_730 23 0 31.30 1.00 10 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_731 32 0 27.81 1.00 11 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_732 32 0 28.75 1.00 11 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_733 32 0 31.56 1.00 11 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_734 32 0 26.88 1.00 11 0 0 0.00
MARGIN201208 /dev/vgdatafc8g03/rraw_db_data_fc_8G_735 26 0 31.92 1.00 10 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_736 32 0 25.00 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_737 32 0 19.06 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_738 32 0 25.63 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_739 32 0 20.63 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_740 32 0 30.00 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_741 32 0 19.38 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_742 29 0 20.69 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_743 29 0 19.66 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_744 29 0 26.21 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_745 29 0 20.34 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_746 29 0 27.59 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_747 29 0 18.28 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_748 29 0 25.86 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_749 29 0 27.24 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g03/rraw_db_data_fc_8G_750 29 0 19.66 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g04/rraw_db_data_fc_8G_751 24 0 12.92 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g04/rraw_db_data_fc_8G_752 24 0 16.25 1.00 11 0 0 0.00
MARGIN201209 /dev/vgdatafc8g04/rraw_db_data_fc_8G_753 24 0 22.92 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_754 24 0 15.83 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_755 31 0 15.81 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_756 31 0 15.81 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_757 31 0 17.74 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_758 34 0 15.59 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_759 34 0 15.29 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_760 34 0 15.59 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_761 34 0 16.76 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_762 34 0 22.35 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_763 34 0 18.82 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_764 34 0 16.76 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_765 34 0 16.18 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_766 34 0 15.88 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_767 35 0 19.14 1.00 11 0 0 0.00
MARGIN201210 /dev/vgdatafc8g04/rraw_db_data_fc_8G_769 26 0 17.31 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_770 26 0 17.31 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_771 26 0 16.15 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_772 26 0 17.69 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_773 26 0 16.15 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_774 29 0 22.41 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_775 29 0 21.03 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_776 29 0 16.90 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_777 29 0 18.62 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_778 29 0 17.93 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_779 29 0 17.93 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_780 29 0 18.62 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_781 29 0 20.34 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_782 29 0 16.55 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_783 29 0 18.97 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_784 29 0 18.62 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_785 29 0 17.59 1.00 11 0 0 0.00
MARGIN201211 /dev/vgdatafc8g04/rraw_db_data_fc_8G_786 33 0 15.76 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_787 33 0 17.88 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_788 33 0 20.00 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_789 36 0 17.50 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_790 36 0 15.56 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_791 36 0 17.50 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_792 36 0 15.28 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_793 28 0 16.79 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_794 28 0 18.21 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_795 28 0 20.36 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_796 28 0 21.79 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_797 28 0 20.36 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_798 28 0 20.00 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_799 28 0 20.36 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_800 28 0 18.57 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_801 32 0 17.19 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_802 32 0 13.44 1.00 10 0 0 0.00
MARGIN201212 /dev/vgdatafc8g04/rraw_db_data_fc_8G_803 34 0 12.65 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_804 34 0 12.35 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_805 34 0 15.00 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_806 33 0 14.85 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_807 33 0 14.55 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_808 33 0 13.94 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_809 33 0 13.64 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_810 33 0 17.58 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_811 33 0 15.45 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_812 33 0 13.03 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_813 33 0 16.06 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_814 33 0 15.15 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_815 33 0 14.24 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_817 34 0 12.35 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_818 49 0 10.41 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_819 40 0 10.50 1.00 10 0 0 0.00
MARGIN201301 /dev/vgdatafc8g04/rraw_db_data_fc_8G_820 47 0 9.57 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_821 77 0 10.39 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_822 62 0 9.03 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_823 77 0 12.08 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_824 67 0 9.55 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_825 84 0 7.26 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_826 57 0 10.88 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_827 85 0 8.94 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_828 92 0 6.85 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_829 85 0 10.47 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_830 94 0 11.38 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_831 37 0 32.16 1.00 10 0 0 0.00
MARGIN201302 /dev/vgdatafc8g04/rraw_db_data_fc_8G_832 48 0 11.88 1.00 10 0 0 0.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_833 3,679 1 7.28 1.00 10 0 26 2.31
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_834 4,039 1 7.23 1.00 10 0 37 2.43
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_835 3,412 0 7.22 1.00 10 0 6 6.67
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_836 4,099 1 6.51 1.00 10 0 1 0.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_837 4,038 1 7.06 1.00 10 0 105 7.81
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_838 4,318 1 6.30 1.00 10 0 1 10.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_839 4,369 1 6.51 1.00 10 0 2 5.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_840 4,295 1 6.79 1.00 10 0 23 1.30
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_841 3,908 1 6.92 1.00 10 0 62 2.10
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_842 4,718 1 6.31 1.00 10 0 116 6.21
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_843 4,254 1 6.44 1.00 10 0 9 4.44
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_844 3,605 1 7.53 1.00 10 0 222 4.46
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_845 4,708 1 5.76 1.00 10 0 36 6.11
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_846 3,887 1 6.56 1.00 10 0 26 5.00
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_847 3,186 0 6.45 1.00 11 0 66 5.30
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_848 2,619 0 7.68 1.00 11 0 38 3.95
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_849 3,080 0 6.85 1.00 11 0 139 3.02
MARGIN201303 /dev/vgdatafc8g04/rraw_db_data_fc_8G_850 723 0 6.25 1.00 11 0 0 0.00
MARGIN201304 /dev/vgdatafc8g04/rraw_db_data_fc_8G_851 224 0 7.14 1.60 11,870 2 8,055 0.63
MARGIN201304 /dev/vgdatafc8g04/rraw_db_data_fc_8G_852 107 0 9.44 2.10 10,657 1 10,289 0.30
MARGIN201304 /dev/vgdatafc8g04/rraw_db_data_fc_8G_853 342 0 7.43 1.50 11,661 2 3,367 0.40
MARGIN201304 /dev/vgdatafc8g04/rraw_db_data_fc_8G_854 402 0 9.73 1.41 11,715 2 18,481 0.39
MARGIN201304 /dev/vgdatafc8g04/rraw_db_data_fc_8G_855 444 0 6.87 1.40 10,510 1 16,188 0.45
MARGIN201304 /dev/vgdatafc8g04/rraw_db_data_fc_8G_856 226 0 9.03 1.52 11,809 2 26,422 0.69
MARGIN201304 /dev/vgdatafc8g04/rraw_db_data_fc_8G_857 96 0 9.90 2.23 12,183 2 45,193 0.42
MARGIN201304 /dev/vgdatafc8g04/rraw_db_data_fc_8G_858 63 0 9.84 2.87 11,169 2 35,131 0.54
MARGIN201304 /dev/vgdatafc8g04/rraw_db_data_fc_8G_859 201 0 7.56 1.59 13,270 2 23,538 0.60
MARGIN201304 /dev/vgdatafc8g04/rraw_db_data_fc_8G_860 129 0 9.22 1.91 10,547 1 49,737 0.52
MARGIN_B /dev/vgdatafc8g01/rraw_db_data_fc_8G_113 64,565 9 3.25 1.00 47,755 7 0 0.00
MARGIN_B /dev/vgdatafc8g01/rraw_db_data_fc_8G_228 35,256 5 2.72 1.00 19,100 3 0 0.00
MARGIN_B /dev/vgdatafc8g01/rraw_db_data_fc_8G_245 24,909 3 2.47 1.00 14,700 2 0 0.00
MARGIN_B /dev/vgdatafc8g01/rraw_db_data_fc_8G_248 24,329 3 2.56 1.00 17,028 2 39 3.08
MARGIN_B_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_37 37,586 5 4.37 1.00 60,553 8 5,432 0.45
MARGIN_B_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_87 27,480 4 3.47 1.00 29,688 4 2,897 0.43
MARGIN_B_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_95 27,827 4 3.58 1.00 26,756 4 2,818 0.38
MARGIN_B_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_96 26,979 4 3.09 1.00 29,920 4 3,633 0.42
MARGIN_C /dev/vgdatafc8g01/rraw_db_data_fc_8G_114 14 0 14.29 1.00 11 0 0 0.00
MARGIN_C /dev/vgdatafc8g01/rraw_db_data_fc_8G_238 21 0 14.29 1.00 10 0 0 0.00
MARGIN_C /dev/vgdatafc8g01/rraw_db_data_fc_8G_241 21 0 16.67 1.00 10 0 0 0.00
MARGIN_C /dev/vgdatafc8g01/rraw_db_data_fc_8G_246 21 0 15.24 1.00 10 0 0 0.00
MARGIN_C_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_38 14 0 14.29 1.00 11 0 0 0.00
MARGIN_C_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_91 21 0 14.76 1.00 10 0 0 0.00
MARGIN_C_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_92 21 0 15.71 1.00 10 0 0 0.00
MARGIN_C_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_99 24 0 14.17 1.00 10 0 0 0.00
MARGIN_D /dev/vgdatafc8g01/rraw_db_data_fc_8G_115 61,430 9 1.69 3.49 109,764 15 3,506 4.76
MARGIN_D /dev/vgdatafc8g01/rraw_db_data_fc_8G_244 60,916 8 1.72 3.47 107,664 15 3,436 3.79
MARGIN_D_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_39 14,901 2 2.84 1.00 27,810 4 4 0.00
MARGIN_D_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_94 14,722 2 2.87 1.00 28,783 4 7 0.00
MARGIN_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_2 11 0 15.45 1.00 17 0 0 0.00
MARGIN_IDX201101 /dev/vgdatafc4g02/rraw_db_data_fc_4G_314 2 0 0.00 1.00 0 0 0 0.00
MARGIN_IDX201101 /dev/vgdatafc4g02/rraw_db_data_fc_4G_324 1 0 0.00 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_527 1 0 10.00 1.00 0 0 0 0.00
MARGIN_IDX201202 /dev/vgdatafc4g03/rraw_db_data_fc_4G_528 1 0 10.00 1.00 0 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_617 24 0 13.33 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_618 24 0 13.75 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_619 24 0 14.58 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_620 24 0 14.58 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_621 24 0 17.50 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_622 24 0 14.58 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_623 31 0 13.55 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_624 34 0 16.47 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_625 34 0 14.12 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_626 34 0 15.59 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_627 34 0 12.65 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_628 34 0 13.82 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_629 34 0 14.12 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_630 34 0 14.12 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_631 34 0 12.94 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_632 34 0 15.00 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_633 34 0 20.88 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_634 34 0 13.24 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_635 34 0 13.24 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_636 34 0 12.65 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_637 34 0 12.65 1.00 10 0 0 0.00
MARGIN_IDX201207 /dev/vgdatafc4g03/rraw_db_data_fc_4G_638 34 0 14.12 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_639 34 0 11.47 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_640 23 0 34.78 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_641 23 0 31.30 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_642 23 0 31.74 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_643 26 0 30.00 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_644 26 0 45.38 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_645 26 0 31.15 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_646 26 0 33.46 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_647 26 0 27.69 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_648 26 0 31.54 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_649 26 0 28.85 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_650 26 0 28.85 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_651 26 0 29.23 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_652 26 0 27.69 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_653 26 0 27.69 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_654 26 0 28.08 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_655 26 0 28.08 1.00 10 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_656 32 0 29.06 1.00 11 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_657 32 0 28.75 1.00 11 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_658 32 0 28.44 1.00 11 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_659 32 0 27.19 1.00 11 0 0 0.00
MARGIN_IDX201208 /dev/vgdatafc4g03/rraw_db_data_fc_4G_660 32 0 26.88 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_661 29 0 20.34 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_662 27 0 18.89 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_663 27 0 25.56 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_664 27 0 19.63 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_665 27 0 19.26 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_666 27 0 18.52 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_667 26 0 25.38 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_668 26 0 18.85 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_669 26 0 25.38 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_670 26 0 27.31 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_671 26 0 19.23 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_672 26 0 23.08 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_673 26 0 18.85 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_674 26 0 21.54 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_675 32 0 25.00 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_676 27 0 17.04 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_677 27 0 19.63 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_678 27 0 19.26 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_679 27 0 17.41 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_680 27 0 18.89 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_681 24 0 13.75 1.00 11 0 0 0.00
MARGIN_IDX201209 /dev/vgdatafc4g03/rraw_db_data_fc_4G_682 24 0 16.25 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_683 31 0 15.16 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_684 34 0 16.76 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_685 34 0 15.00 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_686 34 0 16.47 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_687 34 0 14.71 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_688 34 0 15.88 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_689 35 0 15.14 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_690 35 0 16.57 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_691 35 0 14.86 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_692 35 0 15.71 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_693 35 0 15.71 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_694 35 0 16.86 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_695 35 0 13.43 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_696 29 0 16.55 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_697 29 0 14.48 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_698 26 0 18.46 1.00 11 0 0 0.00
MARGIN_IDX201210 /dev/vgdatafc4g03/rraw_db_data_fc_4G_699 26 0 16.92 1.00 11 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_701 26 0 14.62 1.00 11 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_702 36 0 16.11 1.00 11 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_703 36 0 15.56 1.00 11 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_704 36 0 16.39 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_705 36 0 15.83 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_706 36 0 15.56 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_707 36 0 15.83 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_708 36 0 15.56 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_709 36 0 16.94 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_710 36 0 18.89 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_711 36 0 15.56 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_712 36 0 16.39 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_713 36 0 15.28 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_714 33 0 17.27 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_715 33 0 16.97 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_716 33 0 16.36 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_717 33 0 15.76 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_718 33 0 16.67 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_719 33 0 16.97 1.00 10 0 0 0.00
MARGIN_IDX201211 /dev/vgdatafc4g03/rraw_db_data_fc_4G_720 33 0 15.76 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_721 28 0 16.79 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_722 28 0 18.57 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_723 28 0 19.64 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_724 28 0 16.79 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_725 28 0 18.57 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_726 28 0 18.57 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_727 28 0 16.43 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_728 28 0 16.43 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_729 28 0 17.86 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_730 28 0 20.36 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_731 28 0 18.93 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_732 28 0 17.86 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_733 25 0 16.40 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_734 25 0 16.00 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_735 25 0 16.00 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_736 25 0 20.00 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_737 32 0 15.31 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_738 32 0 15.63 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_739 32 0 15.31 1.00 10 0 0 0.00
MARGIN_IDX201212 /dev/vgdatafc4g03/rraw_db_data_fc_4G_740 32 0 17.50 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_741 37 0 13.78 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_742 36 0 14.17 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_743 33 0 14.24 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_744 37 0 16.49 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_745 36 0 12.22 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_746 34 0 15.88 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_747 35 0 12.00 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_748 27 0 10.37 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_749 28 0 11.07 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g03/rraw_db_data_fc_4G_750 29 0 11.72 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_751 27 0 10.37 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_752 25 0 10.40 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_753 24 0 10.42 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_754 24 0 10.00 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_755 29 0 11.38 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_757 32 0 9.06 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_758 32 0 10.94 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_759 29 0 10.00 1.00 10 0 0 0.00
MARGIN_IDX201301 /dev/vgdatafc4g04/rraw_db_data_fc_4G_760 30 0 9.67 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_763 39 0 8.72 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_764 36 0 8.89 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_765 41 0 8.54 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_766 47 0 7.02 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_767 42 0 8.57 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_768 45 0 6.44 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_769 39 0 29.49 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_770 41 0 7.80 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_771 34 0 6.18 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_772 35 0 9.14 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_773 37 0 7.57 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_774 31 0 6.13 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_775 37 0 10.00 1.00 10 0 0 0.00
MARGIN_IDX201302 /dev/vgdatafc4g04/rraw_db_data_fc_4G_776 28 0 7.86 1.00 10 0 0 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_777 551 0 8.00 1.00 11 0 3 6.67
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_778 567 0 7.48 1.00 11 0 1 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_779 531 0 9.04 1.00 12 0 5 22.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_780 611 0 8.15 1.00 11 0 6 15.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_781 534 0 8.52 1.00 10 0 3 6.67
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_782 685 0 7.90 1.00 10 0 0 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_783 676 0 8.65 1.00 11 0 4 5.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_784 551 0 8.55 1.00 11 0 1 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_785 553 0 7.38 1.00 11 0 1 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_786 649 0 7.84 1.00 11 0 7 11.43
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_787 558 0 7.58 1.00 11 0 2 0.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_788 575 0 7.60 1.00 11 0 2 5.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_789 621 0 8.74 1.00 18 0 8 17.50
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_790 696 0 7.89 1.00 11 0 18 3.33
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_791 634 0 8.30 1.00 18 0 3 6.67
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_792 597 0 8.76 1.00 16 0 9 4.44
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_793 696 0 8.23 1.00 17 0 2 10.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_794 674 0 8.10 1.00 13 0 7 8.57
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_795 333 0 8.56 1.00 24 0 10 2.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_796 390 0 7.49 1.00 38 0 4 5.00
MARGIN_IDX201303 /dev/vgdatafc4g04/rraw_db_data_fc_4G_797 169 0 8.52 1.00 23 0 0 0.00
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_798 566 0 2.63 1.00 6,800 1 8,833 0.79
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_799 533 0 3.94 1.00 5,531 1 5,606 0.83
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_800 525 0 3.37 1.00 5,860 1 12,443 0.89
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_801 607 0 4.65 1.00 5,525 1 3,805 0.43
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_802 534 0 4.83 1.00 6,036 1 2,107 0.93
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_803 595 0 3.09 1.00 4,838 1 2,498 0.82
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_804 561 0 3.40 1.00 3,914 1 1,774 0.72
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_805 595 0 3.70 1.00 5,280 1 2,271 1.01
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_806 619 0 2.92 1.00 5,021 1 3,666 0.82
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_807 478 0 2.93 1.00 4,310 1 6,342 0.70
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_808 477 0 2.39 1.00 4,364 1 4,950 0.44
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_809 443 0 3.21 1.00 5,808 1 2,667 1.03
MARGIN_IDX201304 /dev/vgdatafc4g04/rraw_db_data_fc_4G_810 415 0 3.64 1.00 6,270 1 7,573 0.53
MARGIN_P /dev/vgdatafc8g01/rraw_db_data_fc_8G_116 14 0 15.00 1.00 11 0 0 0.00
MARGIN_P_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_40 15 0 14.00 1.00 11 0 0 0.00
MARGIN_R /dev/vgdatafc8g01/rraw_db_data_fc_8G_118 14 0 17.86 1.00 11 0 0 0.00
MARGIN_R /dev/vgdatafc8g01/rraw_db_data_fc_8G_243 21 0 14.29 1.00 10 0 0 0.00
MARGIN_R /dev/vgdatafc8g02/rraw_db_data_fc_8G_251 24 0 17.50 1.00 10 0 0 0.00
MARGIN_R /dev/vgdatafc8g02/rraw_db_data_fc_8G_252 24 0 17.92 1.00 10 0 0 0.00
MARGIN_R_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_100 24 0 16.25 1.00 10 0 0 0.00
MARGIN_R_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_101 24 0 13.75 1.00 10 0 0 0.00
MARGIN_R_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_43 14 0 15.00 1.00 11 0 0 0.00
MARGIN_R_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_93 21 0 19.52 1.00 10 0 0 0.00
MARGIN_S /dev/vgdatafc8g01/rraw_db_data_fc_8G_112 3,339 0 7.96 1.00 1,059 0 4 42.50
MARGIN_S /dev/vgdatafc8g01/rraw_db_data_fc_8G_213 3,336 0 7.72 1.00 841 0 0 0.00
MARGIN_S /dev/vgdatafc8g01/rraw_db_data_fc_8G_242 4,290 1 8.42 1.00 934 0 1 0.00
MARGIN_S /dev/vgdatafc8g01/rraw_db_data_fc_8G_247 4,174 1 8.21 1.00 1,168 0 3 0.00
MARGIN_S /dev/vgdatafc8g04/rraw_db_data_fc_8G_768 6,938 1 7.59 1.00 367 0 61 99.51
MARGIN_S /dev/vgdatafc8g04/rraw_db_data_fc_8G_816 5,418 1 6.36 1.00 617 0 30 63.33
MARGIN_S_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_36 1,550 0 9.03 1.00 93 0 0 0.00
MARGIN_S_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_56 1,783 0 8.62 1.00 104 0 0 0.00
MARGIN_S_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_97 1,680 0 9.70 1.00 186 0 0 0.00
MARGIN_S_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_98 1,625 0 9.05 1.00 120 0 0 0.00
MARGIN_S_IDX /dev/vgdatafc4g03/rraw_db_data_fc_4G_700 1,056 0 9.48 1.00 2,157 0 0 0.00
MARGIN_S_IDX /dev/vgdatafc4g04/rraw_db_data_fc_4G_756 849 0 7.92 1.00 2,106 0 7 0.00
MARGIN_T /dev/vgdatafc8g01/rraw_db_data_fc_8G_117 14 0 14.29 1.00 11 0 0 0.00
MARGIN_T_IDX /dev/vgdatafc4g01/rraw_db_data_fc_4G_41 14 0 19.29 1.00 11 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_1 179 0 7.32 1.12 379 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_2 77 0 8.70 1.18 87 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_3 70 0 9.43 1.17 119 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_4 86 0 6.51 1.03 102 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_5 56 0 6.96 1.13 86 0 0 0.00
SYSAUX /dev/vgdatafile/rraw_db_sysaux_fc_4G_6 35 0 8.29 1.00 69 0 0 0.00
SYSTEM /dev/vgdatafile/rraw_db_system_fc_4G_1 60 0 9.67 1.00 209 0 1 0.00
SYSTEM /dev/vgdatafile/rraw_db_system_fc_4G_2 27 0 20.37 1.00 87 0 0 0.00
TEMP /dev/vgdatafile/rraw_db_tmp_fc_8G_1 98 0 18.16 25.29 98 0 0  
TEMP /dev/vgdatafile/rraw_db_tmp_fc_8G_10 1,115 0 9.17 21.10 1,115 0 0  
TEMP /dev/vgdatafile/rraw_db_tmp_fc_8G_3 1,303 0 7.48 22.05 1,303 0 0  
TEMP /dev/vgdatafile/rraw_db_tmp_fc_8G_8 20,845 3 6.25 8.23 7,236 1 0  
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_1 11 0 15.45 1.00 11 0 384 5.47
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_10 11 0 19.09 1.00 11 0 54 82.04
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_11 11 0 20.91 1.00 11 0 54 1.11
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_12 11 0 15.45 1.00 11 0 72 17.08
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_2 11 0 15.45 1.00 11 0 153 0.20
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_3 11 0 15.45 1.00 11 0 517 0.83
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_4 11 0 15.45 1.00 11 0 442 6.70
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_5 11 0 17.27 1.00 11 0 115 0.26
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_6 11 0 17.27 1.00 11 0 726 1.06
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_7 11 0 15.45 1.00 11 0 1,356 0.38
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_8 11 0 20.00 1.00 11 0 791 0.46
UNDOTBS1 /dev/vgdatafile/rraw_db_undo_fc_8G_9 11 0 15.45 1.00 11 0 108 0.65
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_13 11 0 16.36 1.00 33,243 5 688 0.80
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_14 11 0 15.45 1.00 28,322 4 0 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_15 12 0 20.83 1.00 33,359 5 0 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_16 11 0 16.36 1.00 33,171 5 142 0.14
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_17 11 0 17.27 1.00 32,833 5 64 2.66
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_18 11 0 17.27 1.00 31,697 4 4 5.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_19 11 0 15.45 1.00 33,496 5 0 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_20 11 0 17.27 1.00 30,931 4 0 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_21 14 0 16.43 1.00 36,725 5 7 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_22 11 0 20.00 1.00 31,762 4 0 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_23 11 0 19.09 1.00 31,286 4 3 0.00
UNDOTBS2 /dev/vgdatafile/rraw_db_undo_fc_8G_24 11 0 17.27 1.00 29,978 4 0 0.00
USERS /dev/vgdatafile/rraw_db_user_fc_4G_1 11 0 15.45 1.00 11 0 0 0.00
USERS /dev/vgdatafile/rraw_db_user_fc_4G_2 14 0 15.71 1.00 11 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,523 100 906,915,558 849,960 3,341,495 0 0 329,519


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 331 89 154527 1847889 3080524 7461270 3080524  
E 336 27 64691 633070 4222594 7461270 4222594  

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.05 2,498,128,270
D 4,704 0.20 564,186 1.48 1,804,660,234
D 7,056 0.30 846,279 1.30 1,582,929,621
D 9,408 0.40 1,128,372 1.21 1,479,976,202
D 11,760 0.50 1,410,465 1.17 1,422,691,808
D 14,112 0.60 1,692,558 1.12 1,371,734,904
D 16,464 0.70 1,974,651 1.09 1,327,423,111
D 18,816 0.80 2,256,744 1.05 1,287,056,097
D 21,168 0.90 2,538,837 1.02 1,250,610,941
D 23,520 1.00 2,820,930 1.00 1,221,174,088
D 23,552 1.00 2,824,768 1.00 1,220,891,095
D 25,872 1.10 3,103,023 0.98 1,199,268,999
D 28,224 1.20 3,385,116 0.97 1,178,179,501
D 30,576 1.30 3,667,209 0.95 1,158,418,259
D 32,928 1.40 3,949,302 0.93 1,139,979,310
D 35,280 1.50 4,231,395 0.92 1,123,027,046
D 37,632 1.60 4,513,488 0.91 1,105,885,992
D 39,984 1.70 4,795,581 0.89 1,088,697,600
D 42,336 1.80 5,077,674 0.88 1,075,796,207
D 44,688 1.90 5,359,767 0.87 1,063,286,363
D 47,040 2.00 5,641,860 0.86 1,049,267,131

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
84.42 15,130 2,792

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,602 941.70 104.88 11.14 100.00 0.00 1,024,000
E 10,000 8,599 870.28 0.46 0.05 100.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 31,476 31,476 0 0
64K 128K 1,498 1,498 0 0
128K 256K 292 292 0 0
256K 512K 296 296 0 0
512K 1024K 7,422 7,422 0 0
1M 2M 523 523 0 0
2M 4M 362 314 48 0
4M 8M 216 156 60 0
8M 16M 122 74 48 0
16M 32M 16 4 12 0
32M 64M 6 0 6 0
64M 128M 46 32 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 4,075,623.90 370,375.98 92.00 123
2,500 0.25 4,075,623.90 336,804.29 92.00 0
5,000 0.50 4,075,623.90 331,459.77 92.00 0
7,500 0.75 4,075,623.90 331,459.77 92.00 0
10,000 1.00 4,075,623.90 331,459.77 92.00 0
12,000 1.20 4,075,623.90 15,986.06 100.00 0
14,000 1.40 4,075,623.90 15,986.06 100.00 0
16,000 1.60 4,075,623.90 15,986.06 100.00 0
18,000 1.80 4,075,623.90 15,986.06 100.00 0
20,000 2.00 4,075,623.90 15,986.06 100.00 0
30,000 3.00 4,075,623.90 15,986.06 100.00 0
40,000 4.00 4,075,623.90 15,986.06 100.00 0
60,000 6.00 4,075,623.90 15,986.06 100.00 0
80,000 8.00 4,075,623.90 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 241 15,580 3,242,127 0.99 52,161 1.50 191,331,597
1,792 0.90 442 30,085 3,249,895 1.00 44,393 1.28 191,364,706
2,000 1.00 649 45,169 3,259,537 1.00 34,751 1.00 191,378,164
2,208 1.10 856 59,984 3,287,080 1.01 7,208 0.21 191,384,579
2,416 1.21 1,063 74,934 3,304,658 1.01 1 0.00 191,388,747
2,624 1.31 1,269 91,114 3,313,800 1.02 1 0.00 191,391,546
2,832 1.42 1,476 106,005 3,320,453 1.02 1 0.00 191,394,177
3,040 1.52 1,683 121,512 3,321,678 1.02 1 0.00 191,396,145
3,248 1.62 1,890 137,799 3,324,568 1.02 1 0.00 191,397,900
3,456 1.73 2,097 153,283 3,324,843 1.02 1 0.00 191,399,270
3,664 1.83 2,304 170,224 3,324,853 1.02 1 0.00 191,400,095
3,872 1.94 2,511 185,812 3,324,857 1.02 1 0.00 191,400,941
4,080 2.04 2,718 201,438 3,325,495 1.02 1 0.00 191,401,358

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 8,887,356 1,804,599,185
12,800 0.50 8,312,222 1,479,964,233
19,200 0.75 8,062,923 1,327,474,930
25,600 1.00 7,889,352 1,220,891,134
32,000 1.25 7,787,593 1,158,381,508
38,400 1.50 7,701,600 1,105,883,189
44,800 1.75 7,652,686 1,075,849,267
51,200 2.00 7,609,299 1,049,233,841

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 322,817 217 1
undo header 1,048 11 11
undo block 4,631 3 1
2nd level bmb 10 0 5
1st level bmb 28 0 0
segment header 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
FB-Format Block 24,057 24,057 0 11,992 5 0.41
WF-AWR Flush 39 39 0 20 4 219.85
HW-Segment High Water Mark 8,876 8,876 0 3,328 1 0.34
TM-DML 264,201 263,267 934 1,228 1 0.54
CF-Controlfile Transaction 16,876 16,872 4 386 0 0.85
TX-Transaction 509,613 509,613 0 11 0 22.36
PS-PX Process Reservation 985 985 0 369 0 0.54
TT-Tablespace 4,625 4,625 0 334 0 0.30
TD-KTF map table enqueue (KTF dump entries) 20 20 0 20 0 3.35
TX-Transaction (index contention) 3,983 3,983 0 8 0 4.88
JS-Job Scheduler (job run lock - synchronize) 6 5 1 3 0 1.33
WL-Being Written Redo Log 36 17 19 8 0 0.38
MW-MWIN Schedule 4 4 0 4 0 0.75
DR-Distributed Recovery 4 4 0 4 0 0.50
AF-Advisor Framework (task serialization) 14 14 0 1 0 0.00
TA-Instance Undo 32 32 0 1 0 0.00
TX-Transaction (allocate ITL entry) 60 60 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 7,971 0.00   0 0  
AWR Alerted Metric Element list 208,738 0.00   0 0  
Consistent RBA 256,703 0.00 0.00 0 0  
FAL request queue 162 0.00   0 0  
FAL subheap alocation 162 0.00   0 0  
FIB s.o chain latch 352 0.00   0 0  
FOB s.o list latch 23,910 0.03 0.00 0 0  
JS Sh mem access 10 10.00 1.00 0 0  
JS broadcast add buf latch 5,848 0.00   0 0  
JS broadcast drop buf latch 5,850 0.00   0 0  
JS broadcast load blnc latch 5,625 0.00   0 0  
JS mem alloc latch 15 0.00   0 0  
JS queue access latch 15 0.00   0 0  
JS queue state obj latch 202,884 0.00   0 0  
JS slv state obj latch 34 0.00   0 0  
KCL gc element parent latch 42,843,333 0.04 0.15 5 212,683 0.10
KJC message pool free list 558,029 0.01 0.20 0 127,189 0.01
KJCT flow control latch 6,977,892 0.02 0.10 0 0  
KMG MMAN ready and startup request latch 2,391 0.00   0 0  
KTF sga latch 34 0.00   0 2,351 0.00
KWQMN job cache list latch 594 0.00   0 0  
Memory Management Latch 0     0 2,391 0.00
OS process 2,781 0.00   0 0  
OS process allocation 4,270 0.00   0 0  
OS process: request allocation 1,836 0.00   0 0  
PL/SQL warning settings 5,179 0.00   0 0  
SGA IO buffer pool latch 136,549 0.00 0.00 0 136,549 0.00
SQL memory manager latch 2 0.00   0 2,371 0.00
SQL memory manager workarea list latch 244,808 0.00   0 0  
Shared B-Tree 255 0.00   0 0  
active checkpoint queue latch 119,527 0.00   0 0  
active service list 54,111 0.00 0.00 0 6,389 0.00
archive control 276 0.00   0 0  
archive process latch 2,730 0.00   0 0  
begin backup scn array 10 0.00   0 0  
business card 288 0.00   0 0  
cache buffer handles 547,566 0.00 0.00 0 0  
cache buffers chains 2,155,290,568 0.03 0.09 28 20,990,848 0.04
cache buffers lru chain 12,290,468 0.10 0.04 2 15,214,739 0.18
cache table scan latch 0     0 20,646 0.00
channel handle pool latch 2,037 0.00   0 0  
channel operations parent latch 596,498 0.00 0.00 0 0  
checkpoint queue latch 6,261,646 0.02 0.08 0 3,649,622 0.01
client/application info 10,539 0.00   0 0  
commit callback allocation 36 0.00   0 0  
compile environment latch 1,094 0.00   0 0  
dml lock allocation 528,545 0.00 0.42 0 0  
dummy allocation 2,162 0.05 0.00 0 0  
enqueue hash chains 2,740,240 0.00 0.15 1 5,546 0.00
enqueues 1,029,962 0.01 0.06 0 0  
error message lists 696 0.00   0 0  
event group latch 931 0.00   0 0  
file cache latch 13,777 0.00   0 0  
gcs opaque info freelist 8,740,340 0.16 0.02 0 0  
gcs partitioned table hash 4,820,235 0.00   0 0  
gcs resource freelist 2,602,475 0.01 0.05 0 475,076 0.00
gcs resource hash 32,771,856 0.01 0.20 1 229 0.00
gcs resource scan list 458 0.00   0 0  
gcs shadows freelist 4,690,405 0.00 0.14 0 4,213,488 0.00
ges caches resource lists 190,096 0.03 0.06 0 146,717 0.02
ges deadlock list 2,000 0.00   0 4 0.00
ges domain table 666,801 0.00   0 0  
ges enqueue table freelist 740,932 0.00 0.50 0 0  
ges group table 978,566 0.00   0 0  
ges process hash list 30,358 0.02 1.00 0 0  
ges process parent latch 1,463,365 0.00   0 0  
ges process table freelist 1,836 0.00   0 0  
ges resource hash list 988,994 1.65 0.99 0 65,715 0.00
ges resource scan list 216 0.00   0 0  
ges resource table freelist 114,255 0.01 0.00 0 0  
ges timeout list 4,462 0.00   0 7,246 0.00
global KZLD latch for mem in SGA 920 0.00   0 0  
hash table column usage latch 264 0.00   0 14,171 0.00
hash table modification latch 209 0.00   0 0  
job workq parent latch 0     0 12 0.00
job_queue_processes parameter latch 6 0.00   0 0  
kks stats 14,662 0.01 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 484 0.00   0 0  
ktm global data 219 0.00   0 0  
kwqbsn:qsga 255 0.00   0 0  
lgwr LWN SCN 257,161 0.06 0.03 0 0  
library cache 897,106 0.01 0.03 0 5,712 0.00
library cache load lock 172 0.00   0 0  
library cache lock 264,960 0.01 0.00 0 0  
library cache lock allocation 4,434 0.00   0 0  
library cache pin 172,802 0.00 0.00 0 0  
library cache pin allocation 41 0.00   0 0  
list of block allocation 242,423 0.00 0.00 0 0  
loader state object freelist 1,328 0.00   0 0  
longop free list parent 50 0.00   0 50 0.00
message pool operations parent latch 2,453 0.00   0 0  
messages 1,389,437 0.02 0.11 0 0  
mostly latch-free SCN 259,128 0.58 0.02 0 0  
multiblock read objects 956,240 0.01 0.08 0 0  
name-service memory objects 53,936 0.00   0 0  
name-service namespace bucket 87,166 0.00   0 0  
name-service pending queue 22,514 0.00   0 0  
name-service request queue 99,635 0.00   0 0  
ncodef allocation latch 144 0.00   0 0  
object queue header heap 867 0.00   0 2,130 0.00
object queue header operation 22,814,715 0.07 0.12 3 0  
object stats modification 2 0.00   0 0  
parallel query alloc buffer 3,836 0.00   0 0  
parallel query stats 589 0.00   0 0  
parallel txn reco latch 19,072 0.00   0 0  
parameter list 9,486 0.00   0 0  
parameter table allocation management 2,166 0.00   0 0  
post/wait queue 453,368 0.00 0.18 0 302,879 0.01
process allocation 61,452 0.01 0.67 0 929 0.22
process group creation 1,836 0.00   0 0  
process queue 1,563 0.00   0 0  
process queue reference 27,624 0.00   0 2,793 0.00
qmn state object latch 2 0.00   0 0  
qmn task queue latch 1,057 8.80 0.99 0 0  
query server freelists 1,298 0.00   0 0  
queued dump request 35,586 0.00   0 0  
redo allocation 803,362 0.27 0.30 2 73,404,808 0.03
redo copy 0     0 73,409,216 0.01
redo writing 921,725 0.00 0.24 0 0  
resmgr group change latch 2,081 0.00   0 0  
resmgr:active threads 2,154 0.00   0 0  
resmgr:actses change group 1,080 0.00   0 0  
resmgr:free threads list 2,152 0.05 0.00 0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 4,008,195 0.08 0.02 0 617 0.00
rules engine aggregate statistics 18 0.00   0 0  
rules engine rule set statistics 36 0.00   0 0  
sequence cache 3,571 0.00   0 0  
session allocation 930,009 0.03 0.08 0 0  
session idle bit 3,432,168 0.00 0.10 0 0  
session state list latch 3,972 0.00   0 0  
session switching 144 0.00   0 0  
session timer 3,033 0.00   0 0  
shared pool 454,771 0.00 0.05 0 0  
shared pool sim alloc 242 0.00   0 0  
shared pool simulator 1,608,380 0.00 0.00 0 0  
sim partition latch 2 0.00   0 17,173 0.01
simulator hash latch 55,230,330 0.01 0.06 2 0  
simulator lru latch 0     0 54,821,841 0.41
slave class 5 0.00   0 0  
slave class create 20 10.00 1.00 0 0  
sort extent pool 2,428 0.04 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 4 0.00   0 0  
threshold alerts latch 2,406 0.00   0 0  
transaction allocation 129,151 0.00   0 0  
transaction branch allocation 3,033 0.00   0 0  
undo global data 4,856,442 0.01 0.06 0 0  
user lock 3,639 0.11 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 2,155,290,568 616,771 53,488 565,829 0 0 0
KCL gc element parent latch 42,843,333 16,996 2,629 14,421 0 0 0
ges resource hash list 988,994 16,365 16,207 159 0 0 0
object queue header operation 22,814,715 15,524 1,840 13,714 0 0 0
gcs opaque info freelist 8,740,340 13,755 220 13,536 0 0 0
cache buffers lru chain 12,290,468 12,796 528 12,277 0 0 0
simulator hash latch 55,230,330 3,325 209 3,121 0 0 0
row cache objects 4,008,195 3,249 68 3,189 0 0 0
redo allocation 803,362 2,135 646 1,491 0 0 0
gcs resource hash 32,771,856 2,129 423 1,711 0 0 0
mostly latch-free SCN 259,128 1,506 29 1,477 0 0 0
KJCT flow control latch 6,977,892 1,188 114 1,076 0 0 0
checkpoint queue latch 6,261,646 953 80 875 0 0 0
undo global data 4,856,442 545 35 511 0 0 0
session allocation 930,009 317 26 291 0 0 0
messages 1,389,437 253 28 225 0 0 0
gcs resource freelist 2,602,475 150 7 143 0 0 0
lgwr LWN SCN 257,161 142 4 138 0 0 0
enqueues 1,029,962 136 8 128 0 0 0
library cache 897,106 114 3 111 0 0 0
enqueue hash chains 2,740,240 101 15 86 0 0 0
qmn task queue latch 1,057 93 92 1 0 0 0
session idle bit 3,432,168 82 8 74 0 0 0
multiblock read objects 956,240 59 5 54 0 0 0
ges caches resource lists 190,096 54 3 51 0 0 0
gcs shadows freelist 4,690,405 37 5 32 0 0 0
KJC message pool free list 558,029 35 7 28 0 0 0
redo writing 921,725 29 7 23 0 0 0
dml lock allocation 528,545 24 10 14 0 0 0
post/wait queue 453,368 22 4 18 0 0 0
shared pool 454,771 20 1 19 0 0 0
ges process hash list 30,358 6 6 0 0 0 0
process allocation 61,452 6 4 2 0 0 0
ges enqueue table freelist 740,932 2 1 1 0 0 0
slave class create 20 2 2 0 0 0 0
JS Sh mem access 10 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 1 1
KCL gc element parent latch kclnfndnewm 0 745 649
KCL gc element parent latch kclnfnd 0 726 402
KCL gc element parent latch kclbla 0 228 35
KCL gc element parent latch kclgrantlk 0 199 45
KCL gc element parent latch kclrwrite 0 177 199
KCL gc element parent latch kclwrt 0 147 79
KCL gc element parent latch kclulb 0 131 721
KCL gc element parent latch kclzcl 0 113 19
KCL gc element parent latch kclfwrite1 0 101 152
KCL gc element parent latch kclplz 0 101 159
KCL gc element parent latch KCLUNLNK 0 100 312
KCL gc element parent latch kclgcr 0 50 77
KCL gc element parent latch kclpdc_3 0 36 3
KCL gc element parent latch kcllwr 0 25 5
KCL gc element parent latch kclebs 0 24 63
KCL gc element parent latch kclchkping 0 15 0
KCL gc element parent latch kclfwrite2 0 11 5
KCL gc element parent latch kclrwrite_1 0 9 4
KCL gc element parent latch kclpto 0 8 10
KCL gc element parent latch kclshrsplit 0 8 1
KCL gc element parent latch kclhngcbk1 0 6 0
KCL gc element parent latch kclswc 0 6 31
KCL gc element parent latch kcllkopesc 0 3 2
KCL gc element parent latch kclpto_3 0 3 4
KCL gc element parent latch kclpdc_14 0 2 0
KCL gc element parent latch kclpdc_15 0 2 1
KCL gc element parent latch kclpdc_7 0 2 0
KCL gc element parent latch kclpdc_1 0 1 1
KJC message pool free list kjcspfmbq: free vector of msg buffers 0 6 0
KJC message pool free list kjcsmpav: allocate a msg buffer 0 1 7
KJCT flow control latch kjctcsnd: send normal message 0 50 75
KJCT flow control latch kjcts_sqenq: queue a message 0 27 22
KJCT flow control latch kjctr_updatetkt: update ticket info 0 19 14
KJCT flow control latch kjcts_sedeqv: dequeue a vector of msgs 0 18 3
active service list ksws_event: ksws event 0 1 1
cache buffers chains kcbgtcr: kslbegin excl 0 51,519 47,034
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 21,424 17,578
cache buffers chains kcbzwb 0 18,541 18,817
cache buffers chains kcbchg: kslbegin: call CR func 0 1,072 8,353
cache buffers chains kcbzgb: scan from tail. nowait 0 827 0
cache buffers chains kcbgtcr: kslbegin shared 0 713 562
cache buffers chains kcbrls: kslbegin 0 551 1,631
cache buffers chains kcbgtcr: fast path 0 325 407
cache buffers chains kcbzib: finish free bufs 0 203 255
cache buffers chains kclebs_1 0 113 194
cache buffers chains kclwrt 0 110 3
cache buffers chains kcbgcur: kslbegin 0 77 126
cache buffers chains kclwcrs 0 47 107
cache buffers chains kclbla 0 29 5
cache buffers chains kcbnew: new latch again 0 22 1
cache buffers chains kcbbxsv 0 11 112
cache buffers chains kcbcge 0 11 496
cache buffers chains kcbget: pin buffer 0 8 9
cache buffers chains kcbget: exchange 0 7 5
cache buffers chains kclpred 0 7 0
cache buffers chains kcbget: exchange rls 0 5 0
cache buffers chains kcbgtcr 0 4 1
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 3 0
cache buffers chains kcbbic2 0 2 0
cache buffers chains kclcsr 0 2 6
cache buffers chains kclgrantlk_1 0 2 1
cache buffers chains kclpdc_1 0 2 0
cache buffers chains kclpto 0 2 0
cache buffers chains kcbbic1 0 1 1
cache buffers chains kcllkopb_1 0 1 2
cache buffers chains kclwlr 0 1 0
cache buffers lru chain kcbzgws 0 209 0
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 98 17
cache buffers lru chain kcbbxsv: move to being written 0 64 32
cache buffers lru chain kclmvreqbg 0 53 119
cache buffers lru chain kcbzgb: posted for free bufs 0 38 209
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 19 0
cache buffers lru chain kcbbic2 0 9 92
cache buffers lru chain H_MK_PI_CR_BG 0 7 0
cache buffers lru chain kclmergepi 0 6 0
cache buffers lru chain kclwcrs 0 6 0
cache buffers lru chain kcbzgm 0 5 0
cache buffers lru chain kcbzswcu 0 5 0
cache buffers lru chain H_MK_PI_CR 0 4 0
cache buffers lru chain kcbbwlru 0 3 23
cache buffers lru chain kcbrenounce 0 1 0
cache buffers lru chain kcbzib: move stale buffers 0 1 36
checkpoint queue latch kcbkubc 0 42 52
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 20 0
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 15 25
checkpoint queue latch kclmergepi_3 0 2 2
checkpoint queue latch kclmergepi_1 0 1 0
dml lock allocation ktaidm 0 7 8
dml lock allocation ktaiam 0 3 2
enqueue hash chains ksqrcl 0 9 5
enqueue hash chains ksqgtl3 0 6 10
enqueues ksqgel: create enqueue 0 3 0
enqueues ksqies 0 3 7
enqueues ksqdel 0 2 1
event range base latch No latch 0 92 92
gcs opaque info freelist kjbrcvt save opaque info 0 122 176
gcs opaque info freelist kjbrgrant free opaque info 0 98 44
gcs resource freelist kjbrfr free resource 0 5 1
gcs resource freelist kjbralc add resource 0 2 6
gcs resource hash kjbmpclose 0 97 26
gcs resource hash kjbmpopen 0 59 24
gcs resource hash kclgrantlk_1 0 45 17
gcs resource hash kclzcl 0 34 17
gcs resource hash kclfwrite1 0 22 31
gcs resource hash kjbcropen:affinity 0 21 28
gcs resource hash kjbopen 0 21 18
gcs resource hash kclrwrite 0 20 48
gcs resource hash kjbcropen 0 14 35
gcs resource hash kjbassume 0 13 45
gcs resource hash kjbconvert 0 11 20
gcs resource hash kjbmpflushpi 0 11 8
gcs resource hash kclpdc 0 10 1
gcs resource hash kjbrwrdone reget 0 8 0
gcs resource hash kjbmpcreatepi 0 7 2
gcs resource hash kjbopen:affinity 0 7 6
gcs resource hash kjbcrconvert 0 5 29
gcs resource hash kjbmdowncvt 0 5 0
gcs resource hash kjbmpconvert 0 5 1
gcs resource hash kjbmpwrite 0 5 5
gcs resource hash kjbcrcomplete 0 2 47
gcs resource hash kjblpwreq 0 1 4
gcs shadows freelist kjblfr free lock 0 4 5
gcs shadows freelist kjblalc add lock 0 1 0
ges enqueue table freelist kjlalc: lock allocation 0 1 1
ges process hash list kjakiqa: set inquiry response 0 6 0
ges resource hash list kjakcai: search for resp by resname 0 9,976 20
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 6,140 1
ges resource hash list kjcvscn: remove from scan queue 0 49 0
ges resource hash list kjrmas1: lookup master node 0 28 0
ges resource hash list kjlrlr: remove lock from resource queue 0 9 13,517
ges resource hash list kjucvl: lock convert request 0 4 2,667
ges resource hash list kjrref: find matched resource 0 1 2
ges resource table freelist kjruch: cached obj cleanup 0 2 0
ges resource table freelist kjrchc: cached obj cleanup 0 1 0
lgwr LWN SCN kcs023 0 19 0
library cache kgldte: child 0 0 1 3
library cache kglhdgn: child: 0 1 0
library cache kglpndl: child: after processing 0 1 0
messages ksaamb: after wakeup 0 20 20
messages ksarcv 0 6 4
messages ksarcv: after wait 0 2 3
mostly latch-free SCN kcslcu3 0 10 33
mostly latch-free SCN kcs024 0 4 0
multiblock read objects kcbzib: mbr get 0 5 1
object queue header operation kcbw_unlink_q 0 1,129 825
object queue header operation kcbo_switch_mq_bg 0 417 620
object queue header operation kcbw_link_q 0 275 112
object queue header operation kcbo_switch_cq 0 226 417
object queue header operation kcbo_switch_q_bg 0 143 149
object queue header operation kcbw_unlink_q_bg 0 9 71
object queue header operation kcbo_swap_buf 0 3 8
post/wait queue ksliwat:add:nowait 0 3 0
post/wait queue ksliwat:remove 0 1 0
process allocation ksufap: active procs 0 3 1
process allocation ksucrp 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 643 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 2 29
redo allocation kcrfw_redo_write: more space 0 1 427
redo writing kcrfw_post: rba scn pair 0 3 0
redo writing kcrfwcr 0 2 5
redo writing kcrfw_cal_target_rba 0 1 2
redo writing kcrfw_post: after write 0 1 0
row cache objects kqreqd: reget 0 31 4
row cache objects kqrpre: find obj 0 26 63
row cache objects kqreqd 0 11 1
session allocation ksufap: active sessions 0 9 0
session allocation ksucri 0 8 11
session allocation ksuxds: not user session 0 6 12
session allocation ksuxds: KSUSFCLC not set 0 2 0
session allocation kxfprdp 0 1 0
session idle bit ksupuc: set busy 0 5 1
session idle bit ksupuc: clear busy 0 2 5
session idle bit ksuxds 0 1 2
shared pool kghfre 0 1 1
simulator hash latch kcbsacc: lookup dba 0 208 208
simulator hash latch kcbs_lookup_setid: lookup dba 0 1 1
slave class create ksvcreate 0 2 0
undo global data ktudba: KSLBEGIN 0 30 31
undo global data ktubnd:child 0 2 0
undo global data ktufrbs: child 0 2 2
undo global data ktusmasp: ktugd_tuux 0 1 1

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 MARGIN201304 H_COMPCLIENTTRADE P20130401 TABLE PARTITION 478,612,608 52.64
MARGIN MARGIN_IDX201304 IX_H_COMPTRADE_DATE_COMPID P20130401 INDEX PARTITION 132,035,456 14.52
MARGIN MARGIN_S S_UPLOADFILE   TABLE 31,792,160 3.50
MARGIN MARGIN201304 H_COMPCLIENTPOS P20130401 TABLE PARTITION 25,705,520 2.83
MARGIN MARGIN_S S_QUERYUSER2   TABLE 22,063,760 2.43

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
MARGIN MARGIN_D D_COMPCLIENTLIQUID   TABLE 242,601 22.31
MARGIN MARGIN_D D_EXCLIENT   TABLE 131,136 12.06
MARGIN MARGIN_B B_EXCHANGECLIENTINFO   TABLE 129,963 11.95
MARGIN MARGIN_B_IDX INDEX_B_EXCLIENT_ID_COMP_EXCH   INDEX 82,627 7.60
MARGIN MARGIN_B_IDX PK_B_EXCHANGECLIENTMAP   INDEX 33,246 3.06

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
MARGIN MARGIN_IDX201304 IX_H_COMPTRADE_DATE_COMPID P20130401 INDEX PARTITION 772 19.03
MARGIN MARGIN_IDX201304 IX_H_COMPTRADE_CLIENTID_DATE P20130401 INDEX PARTITION 598 14.74
MARGIN MARGIN_IDX201304 IX_H_COMPCLTINFO_DATE_COMPID P20130401 INDEX PARTITION 422 10.40
MARGIN MARGIN_IDX201304 IX_H_POSDETAIL_ID_DATE P20130401 INDEX PARTITION 372 9.17
MARGIN MARGIN_IDX201304 IDX_H_EXTRD_DATE_COMPID_EXCHID P20130401 INDEX PARTITION 274 6.76

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
MARGIN MARGIN_IDX201304 IX_H_COMPTRADE_DATE_COMPID P20130401 INDEX PARTITION 11 18.33
MARGIN MARGIN_IDX201304 IX_H_COMPTRADE_CLIENTID_DATE P20130401 INDEX PARTITION 9 15.00
MARGIN MARGIN_IDX201304 IX_H_COMPCLTINFO_DATE_COMPID P20130401 INDEX PARTITION 8 13.33
MARGIN MARGIN_IDX201304 IDX_H_EXTRD_DATE_COMPID_EXCHID P20130401 INDEX PARTITION 7 11.67
MARGIN MARGIN_IDX201304 IX_H_POSDETAIL_DATE_COMPID P20130401 INDEX PARTITION 5 8.33

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
MARGIN MARGIN_IDX201304 IX_H_COMPTRADE_DATE_COMPID P20130401 INDEX PARTITION 413 71.95
MARGIN MARGIN201304 H_COMPCLIENTTRADE P20130401 TABLE PARTITION 47 8.19
MARGIN MARGIN_D D_COMPCLIENTCODE   TABLE 36 6.27
MARGIN MARGIN_S S_QUERYLOG2 P20130401 TABLE PARTITION 21 3.66
MARGIN MARGIN_D D_COMPCLIENTFUNDACC   TABLE 16 2.79

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
MARGIN MARGIN201304 H_COMPCLIENTTRADE P20130401 TABLE PARTITION 235,263 73.13
MARGIN MARGIN_IDX201304 IX_H_COMPTRADE_DATE_COMPID P20130401 INDEX PARTITION 63,259 19.66
MARGIN MARGIN_B_IDX PK_B_CLIACC   INDEX 14,780 4.59
MARGIN MARGIN_D D_COMPCLIENTLIQUID   TABLE 5,952 1.85
MARGIN MARGIN201304 H_COMPCLIENTPOS P20130401 TABLE PARTITION 1,092 0.34

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 532,414 37.84
MARGIN MARGIN201304 H_COMPCLIENTTRADE P20130401 TABLE PARTITION 202,662 14.40
MARGIN MARGIN_IDX201304 IX_H_COMPTRADE_DATE_COMPID P20130401 INDEX PARTITION 92,213 6.55
MARGIN MARGIN_B B_CLIACC   TABLE 74,276 5.28
MARGIN MARGIN_D D_COMPCLIENTLIQUID   TABLE 52,604 3.74

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 182,982 21.29
MARGIN MARGIN_D D_COMPCLIENTLIQUID   TABLE 98,180 11.43
MARGIN MARGIN201304 H_COMPCLIENTTRADE P20130401 TABLE PARTITION 50,830 5.92
MARGIN MARGIN_D D_EXCLIENT   TABLE 46,272 5.38
MARGIN MARGIN_D D_COMPCLIENTTRADE   TABLE 39,083 4.55

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 127 2.36 0   1 1
dc_database_links 1,844 0.00 0   0 1
dc_global_oids 12 0.00 0   0 112
dc_histogram_data 29,985 0.23 0   0 8,827
dc_histogram_defs 9,225 2.49 0   0 7,462
dc_object_ids 16,408 0.29 0   0 2,170
dc_objects 8,275 0.13 0   9 2,680
dc_profiles 926 0.00 0   0 1
dc_rollback_segments 211,004 0.00 0   0 598
dc_segments 11,195 3.74 0   1,497 13,827
dc_sequences 23 8.70 0   23 3
dc_tablespace_quotas 1,484 20.69 0   1,484 4
dc_tablespaces 993,163 0.00 0   0 181
dc_usernames 3,906 0.00 0   0 42
dc_users 67,939 0.00 0   0 58
outstanding_alerts 1,176 85.71 0   0 103

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 230 0 94
dc_object_ids 52 0 0
dc_objects 21 2 7
dc_segments 2,994 419 1,418
dc_sequences 46 3 2
dc_tablespace_quotas 2,968 308 0
outstanding_alerts 2,112 1,008 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 21 0.00 11,116 0.00 0 0
CLUSTER 2 0.00 4 0.00 0 0
INDEX 38 0.00 70 0.00 0 0
SQL AREA 41,717 16.06 2,018,262 0.52 136 2
TABLE/PROCEDURE 2,008 0.00 71,298 0.13 76 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 4 0 0 0 0
INDEX 70 0 0 0 0
TABLE/PROCEDURE 7,561 18 20 19 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 482.54   1.20 3.08 33 38 403 403
  Freeable 335.75 0.00 1.14 1.65 27   295 295
  SQL 113.92 107.88 0.30 5.35 105 233 386 385
  PL/SQL 9.74 7.47 0.02 0.01 0 0 401 401
E Other 498.52   1.16 2.99 33 38 429 429
  Freeable 352.44 0.00 1.13 1.61 27   312 312
  PL/SQL 9.97 7.65 0.02 0.01 0 0 427 427
  SQL 9.64 3.53 0.02 0.02 0 233 412 410

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 40.11 47.64 18.77
shared Checkpoint queue 39.06 39.06 0.00
shared KGH: NO ACCESS 46.09 46.09 0.00
shared KQR L PO 27.56 26.46 -3.99
shared PCursor 30.52 36.43 19.39
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 312.02 276.53 -11.37
shared gcs resources 494.18 494.18 0.00
shared gcs shadows 295.89 295.89 0.00
shared ges enqueues 36.19 36.19 0.00
shared ges resource 25.36 25.36 0.00
shared kglsim object batch 29.26 29.86 2.05
shared library cache 34.24 36.73 7.26
shared sql area 155.75 177.20 13.77
  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,345,576 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) 251,140 34.89 0.56
acks for commit broadcast(logical) 294,893 40.97 0.66
broadcast msgs on commit(actual) 252,405 35.07 0.57
broadcast msgs on commit(logical) 256,665 35.66 0.58
broadcast msgs on commit(wasted) 14,054 1.95 0.03
broadcast on commit wait time(ms) 19,372 2.69 0.04
broadcast on commit waits 19,325 2.68 0.04
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 3 0.00 0.00
flow control messages sent 17 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 3,820,662 530.82 8.58
gcs ast xid 3 0.00 0.00
gcs blocked converts 725,960 100.86 1.63
gcs blocked cr converts 1,480,688 205.72 3.33
gcs compatible basts 214 0.03 0.00
gcs compatible cr basts (global) 200,322 27.83 0.45
gcs compatible cr basts (local) 3,555,260 493.95 7.99
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 308,116 42.81 0.69
gcs dbwr write request msgs 268,262 37.27 0.60
gcs error msgs 1 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 107,248 14.90 0.24
gcs immediate (null) converts 609,931 84.74 1.37
gcs immediate cr (compatible) converts 3,728 0.52 0.01
gcs immediate cr (null) converts 494,666 68.73 1.11
gcs indirect ast 727,488 101.07 1.63
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 79,720 11.08 0.18
gcs msgs process time(ms) 597,899 83.07 1.34
gcs msgs received 16,194,293 2,249.95 36.38
gcs out-of-order msgs 10 0.00 0.00
gcs pings refused 3,684 0.51 0.01
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 57 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 6 0.00 0.00
gcs side channel msgs actual 38,363 5.33 0.09
gcs side channel msgs logical 2,697,561 374.79 6.06
gcs stale cr 0 0.00 0.00
gcs undo cr 0 0.00 0.00
gcs write notification msgs 9,744 1.35 0.02
gcs writes refused 6,877 0.96 0.02
ges msgs process time(ms) 9,196 1.28 0.02
ges msgs received 94,203 13.09 0.21
global posts dropped 0 0.00 0.00
global posts queue time 157 0.02 0.00
global posts queued 18 0.00 0.00
global posts requested 18 0.00 0.00
global posts sent 18 0.00 0.00
implicit batch messages received 621,532 86.35 1.40
implicit batch messages sent 259,425 36.04 0.58
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 267,368 37.15 0.60
messages queue sent actual 1,109,673 154.17 2.49
messages queue sent logical 2,147,200 298.32 4.82
messages received actual 5,046,772 701.17 11.34
messages received logical 16,288,387 2,263.03 36.59
messages sent directly 2,252,177 312.91 5.06
messages sent indirectly 2,248,835 312.44 5.05
messages sent not implicit batched 850,241 118.13 1.91
messages sent pbatched 2,412,016 335.11 5.42
msgs causing lmd to send msgs 28,649 3.98 0.06
msgs causing lms(s) to send msgs 355,388 49.38 0.80
msgs received queue time (ms) 101,136 14.05 0.23
msgs received queued 16,288,251 2,263.01 36.59
msgs sent queue time (ms) 274,167 38.09 0.62
msgs sent queue time on ksxp (ms) 1,148,511 159.57 2.58
msgs sent queued 2,087,613 290.04 4.69
msgs sent queued on ksxp 3,862,136 536.59 8.68
process batch messages received 1,411,290 196.08 3.17
process batch messages sent 936,322 130.09 2.10


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 1,490,147
CURRENT Block Requests 34,723
Data Block Requests 1,490,159
Undo Block Requests 14,561
TX Block Requests 11,837
Current Results 1,425,877
Private results 13,348
Zero Results 85,617
Disk Read Results 3
Fail Results 33
Fairness Down Converts 301,716
Fairness Clears 0
Free GC Elements 0
Flushes 4,033
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 16,215
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 7,603,842 99.98 0.01 0.01 0.00 0.00
Flushes 1,072 19.59 53.82 23.79 2.71 0.09
Writes 370,466 8.30 27.56 61.32 2.81 0.00


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,346,427 98.98 0.17 0.85 841,349 99.72 0.11 0.17
1 undo block 31,882 98.69 0.02 1.29 0      
1 Others 8,938 97.26 2.58 0.16 17,638 98.65 1.28 0.07
1 undo header 22,320 90.88 9.10 0.02 457 98.91 1.09 0.00


Back to Top

End of Report