DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
NDMIS | 3941636119 | ndmis2 | 2 | 10.2.0.5.0 | YES | ndora2 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 26471 | 27-Mar-13 16:30:17 | 1718 | 24.0 |
End Snap: | 26472 | 27-Mar-13 17:01:41 | 55 | 2.1 |
Elapsed: | 31.40 (mins) | |||
DB Time: | 5,144.56 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 22,832M | 22,816M | Std Block Size: | 8K |
Shared Pool Size: | 3,696M | 3,712M | Log Buffer: | 47,052K |
Per Second | Per Transaction | |
---|---|---|
Redo size: | 32,764.15 | 8,961.78 |
Logical reads: | 34,924.10 | 9,552.57 |
Block changes: | 125.83 | 34.42 |
Physical reads: | 225.12 | 61.58 |
Physical writes: | 74.49 | 20.38 |
User calls: | 728.27 | 199.20 |
Parses: | 86.16 | 23.57 |
Hard parses: | 7.37 | 2.01 |
Sorts: | 65.50 | 17.92 |
Logons: | 1.58 | 0.43 |
Executes: | 780.75 | 213.55 |
Transactions: | 3.66 |
% Blocks changed per Read: | 0.36 | Recursive Call %: | 68.30 |
Rollback per transaction %: | 8.74 | Rows per Sort: | 145.52 |
Buffer Nowait %: | 99.53 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 99.39 | In-memory Sort %: | 100.00 |
Library Hit %: | 96.79 | Soft Parse %: | 91.45 |
Execute to Parse %: | 88.96 | Latch Hit %: | 98.73 |
Parse CPU to Parse Elapsd %: | 0.77 | % Non-Parse CPU: | 68.13 |
Begin | End | |
---|---|---|
Memory Usage %: | 68.03 | 66.12 |
% SQL with executions>1: | 76.68 | 74.45 |
% Memory for SQL w/exec>1: | 80.72 | 74.63 |
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
---|---|---|---|---|---|
gc buffer busy | 327,209 | 280,993 | 859 | 91.0 | Cluster |
gc cr request | 132,323 | 163,498 | 1,236 | 53.0 | Cluster |
latch: library cache | 309,683 | 87,793 | 283 | 28.4 | Concurrency |
ges enter server mode | 171,798 | 84,157 | 490 | 27.3 | Other |
latch free | 594,262 | 48,744 | 82 | 15.8 | Other |
Begin | End | |
---|---|---|
Number of Instances: | 2 | 2 |
Per Second | Per Transaction | |
---|---|---|
Global Cache blocks received: | 116.56 | 31.88 |
Global Cache blocks served: | 114.66 | 31.36 |
GCS/GES messages received: | 436.25 | 119.32 |
GCS/GES messages sent: | 1,090.50 | 298.28 |
DBWR Fusion writes: | 3.67 | 1.00 |
Estd Interconnect traffic (KB) | 2,147.95 |
Buffer access - local cache %: | 99.06 |
Buffer access - remote cache %: | 0.33 |
Buffer access - disk %: | 0.61 |
Avg global enqueue get time (ms): | 177.6 |
Avg global cache cr block receive time (ms): | 230.8 |
Avg global cache current block receive time (ms): | 108.1 |
Avg global cache cr block build time (ms): | 9.1 |
Avg global cache cr block send time (ms): | 0.4 |
Global cache log flushes for cr blocks served %: | 0.8 |
Avg global cache cr block flush time (ms): | 317.9 |
Avg global cache current block pin time (ms): | 8.1 |
Avg global cache current block send time (ms): | 4.7 |
Global cache log flushes for current blocks served %: | 0.1 |
Avg global cache current block flush time (ms): | 223.3 |
Avg message sent queue time (ms): | 15.1 |
Avg message sent queue time on ksxp (ms): | 124.3 |
Avg message received queue time (ms): | 6.9 |
Avg GCS message process time (ms): | 3.3 |
Avg GES message process time (ms): | 0.4 |
% of direct sent messages: | 9.85 |
% of indirect sent messages: | 88.32 |
% of flow controlled messages: | 1.84 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 220,606.64 | 71.47 |
parse time elapsed | 65,947.68 | 21.36 |
hard parse elapsed time | 25,076.24 | 8.12 |
connection management call elapsed time | 17,287.83 | 5.60 |
PL/SQL compilation elapsed time | 7,957.08 | 2.58 |
PL/SQL execution elapsed time | 5,984.34 | 1.94 |
hard parse (sharing criteria) elapsed time | 3,254.32 | 1.05 |
hard parse (bind mismatch) elapsed time | 2,654.58 | 0.86 |
DB CPU | 1,351.66 | 0.44 |
failed parse elapsed time | 527.29 | 0.17 |
repeated bind elapsed time | 67.26 | 0.02 |
sequence load elapsed time | 0.45 | 0.00 |
DB time | 308,673.54 | |
background elapsed time | 30,679.94 | |
background cpu time | 152.51 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %Total Call Time |
---|---|---|---|---|---|
Cluster | 777,981 | 64 | 511,848 | 658 | 165.82 |
Other | 17,480,207 | 2 | 185,781 | 11 | 60.19 |
Concurrency | 2,263,783 | 51 | 179,814 | 79 | 58.25 |
Application | 79,373 | 98 | 38,175 | 481 | 12.37 |
Commit | 69,443 | 91 | 6,188 | 89 | 2.00 |
User I/O | 180,946 | 0 | 2,049 | 11 | 0.66 |
CPU time | 1,352 | 0.44 | |||
Network | 1,669,888 | 1,327 | 1 | 0.43 | |
Configuration | 883 | 20 | 224 | 254 | 0.07 |
System I/O | 37,800 | 37 | 1 | 0.01 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
gc buffer busy | 327,209 | 93 | 280,993 | 859 | 47.50 |
gc cr request | 132,323 | 100 | 163,498 | 1236 | 19.21 |
latch: library cache | 309,683 | 0 | 87,793 | 283 | 44.96 |
ges enter server mode | 171,798 | 100 | 84,157 | 490 | 24.94 |
latch free | 594,262 | 0 | 48,744 | 82 | 86.27 |
enq: TX - row lock contention | 78,294 | 99 | 38,154 | 487 | 11.37 |
latch: shared pool | 111,725 | 0 | 30,693 | 275 | 16.22 |
gc current request | 24,689 | 100 | 23,443 | 950 | 3.58 |
row cache lock | 51,627 | 12 | 22,969 | 445 | 7.50 |
gc cr multi block request | 111,771 | 12 | 18,061 | 162 | 16.23 |
latch: session allocation | 53,724 | 0 | 15,455 | 288 | 7.80 |
gcs enter server mode | 29,292 | 100 | 14,381 | 491 | 4.25 |
enq: TX - index contention | 25,025 | 99 | 12,157 | 486 | 3.63 |
enq: US - contention | 36,247 | 59 | 11,404 | 315 | 5.26 |
cursor: pin S wait on X | 1,115,466 | 100 | 10,954 | 10 | 161.94 |
latch: row cache objects | 33,396 | 0 | 9,252 | 277 | 4.85 |
log file sync | 69,443 | 91 | 6,188 | 89 | 10.08 |
gc cr failure | 3,191 | 99 | 3,948 | 1237 | 0.46 |
gc current block 2-way | 68,525 | 3 | 3,946 | 58 | 9.95 |
gc current block congested | 3,438 | 89 | 3,929 | 1143 | 0.50 |
latch: KCL gc element parent latch | 13,976 | 3,151 | 225 | 2.03 | |
gc current retry | 3,454 | 99 | 3,047 | 882 | 0.50 |
gc cr block 2-way | 26,455 | 7 | 2,868 | 108 | 3.84 |
gc cr block congested | 2,367 | 90 | 2,749 | 1161 | 0.34 |
enq: CF - contention | 4,402 | 99 | 2,723 | 619 | 0.64 |
latch: cache buffers chains | 27,063 | 2,421 | 89 | 3.93 | |
gc cr grant 2-way | 58,920 | 2 | 1,974 | 33 | 8.55 |
latch: library cache lock | 5,881 | 0 | 1,642 | 279 | 0.85 |
latch: gcs resource hash | 6,647 | 1,522 | 229 | 0.97 | |
gc current grant busy | 6,528 | 30 | 1,485 | 227 | 0.95 |
gcs resource directory to be unfrozen | 663 | 93 | 1,299 | 1959 | 0.10 |
db file sequential read | 154,160 | 1,239 | 8 | 22.38 | |
library cache lock | 4,117 | 44 | 1,221 | 297 | 0.60 |
SQL*Net message from dblink | 23,609 | 942 | 40 | 3.43 | |
enq: JS - job recov lock | 700 | 100 | 884 | 1263 | 0.10 |
gc cr grant congested | 856 | 69 | 853 | 996 | 0.12 |
ges2 LMON to wake up lms - mrcvr 2 | 33,110 | 100 | 658 | 20 | 4.81 |
db file scattered read | 19,093 | 648 | 34 | 2.77 | |
gc current block busy | 748 | 25 | 311 | 416 | 0.11 |
os thread startup | 406 | 61 | 266 | 655 | 0.06 |
SQL*Net more data from client | 7,588 | 263 | 35 | 1.10 | |
enq: TH - metric threshold evaluation | 90 | 98 | 262 | 2913 | 0.01 |
gc current grant 2-way | 5,565 | 3 | 244 | 44 | 0.81 |
library cache load lock | 236 | 23 | 237 | 1003 | 0.03 |
buffer busy waits | 1,287 | 14 | 203 | 158 | 0.19 |
gc domain validation | 112 | 91 | 200 | 1786 | 0.02 |
latch: object queue header operation | 1,469 | 22 | 164 | 112 | 0.21 |
latch: cache buffers lru chain | 1,100 | 5 | 164 | 149 | 0.16 |
latch: ges resource hash list | 1,088 | 142 | 130 | 0.16 | |
KJC: Wait for msg sends to complete | 182 | 67 | 118 | 651 | 0.03 |
read by other session | 1,819 | 3 | 118 | 65 | 0.26 |
gc current grant congested | 117 | 66 | 116 | 989 | 0.02 |
SQL*Net message to client | 1,298,645 | 109 | 0 | 188.54 | |
enq: HW - contention | 637 | 28 | 94 | 148 | 0.09 |
ges lmd/lmses to freeze in rcfg - mrcvr | 8,107 | 95 | 78 | 10 | 1.18 |
checkpoint completed | 32 | 74 | 2321 | 0.00 | |
gc cr block busy | 586 | 4 | 70 | 120 | 0.09 |
gc recovery quiesce | 174 | 22 | 56 | 323 | 0.03 |
wait for scn ack | 594 | 95 | 55 | 93 | 0.09 |
latch: redo writing | 196 | 55 | 281 | 0.03 | |
gcs log flush sync | 3,116 | 46 | 49 | 16 | 0.45 |
ges LMD to inherit communication channels | 497 | 96 | 47 | 94 | 0.07 |
db file parallel read | 1,164 | 35 | 30 | 0.17 | |
gc current multi block request | 263 | 19 | 33 | 127 | 0.04 |
latch: messages | 142 | 1 | 28 | 198 | 0.02 |
latch: redo allocation | 181 | 26 | 144 | 0.03 | |
rdbms ipc reply | 1,573 | 1 | 26 | 17 | 0.23 |
inactive session | 24 | 100 | 23 | 977 | 0.00 |
CSS initialization | 17 | 22 | 1309 | 0.00 | |
cursor: pin S | 16,418,246 | 20 | 0 | 2,383.60 | |
gc current split | 31 | 45 | 20 | 641 | 0.00 |
DFS lock handle | 863 | 4 | 19 | 22 | 0.13 |
PX Deq: Signal ACK | 65 | 18 | 18 | 280 | 0.01 |
SQL*Net break/reset to client | 371 | 16 | 42 | 0.05 | |
db file parallel write | 9,629 | 15 | 2 | 1.40 | |
Streams AQ: qmn coordinator waiting for slave to start | 3 | 67 | 12 | 4161 | 0.00 |
ges reconfiguration to start | 650 | 96 | 12 | 18 | 0.09 |
control file sequential read | 19,024 | 11 | 1 | 2.76 | |
ksdxexeotherwait | 983 | 100 | 10 | 10 | 0.14 |
SGA: allocation forcing component growth | 918 | 99 | 9 | 10 | 0.13 |
ges generic event | 883 | 100 | 9 | 10 | 0.13 |
SQL*Net more data from dblink | 5,218 | 9 | 2 | 0.76 | |
name-service call wait | 134 | 1 | 9 | 64 | 0.02 |
PX Deq: Test for msg | 356 | 0 | 8 | 23 | 0.05 |
reliable message | 55 | 13 | 8 | 137 | 0.01 |
enq: TQ - INI contention | 3 | 33 | 7 | 2339 | 0.00 |
latch: enqueue hash chains | 115 | 7 | 59 | 0.02 | |
library cache pin | 715 | 0 | 7 | 9 | 0.10 |
LGWR wait for redo copy | 888 | 71 | 6 | 7 | 0.13 |
latch: checkpoint queue latch | 84 | 6 | 75 | 0.01 | |
log file parallel write | 8,559 | 6 | 1 | 1.24 | |
cr request retry | 13 | 100 | 6 | 451 | 0.00 |
ges LMON to get to FTDONE | 281 | 92 | 5 | 19 | 0.04 |
SQL*Net more data to client | 311,217 | 5 | 0 | 45.18 | |
PX Deq Credit: send blkd | 191 | 3 | 5 | 24 | 0.03 |
ges inquiry response | 10 | 80 | 4 | 428 | 0.00 |
enq: TT - contention | 99 | 3 | 4 | 42 | 0.01 |
Wait for Table Lock | 4 | 100 | 4 | 977 | 0.00 |
direct path read | 2,582 | 4 | 1 | 0.37 | |
recovery read | 48 | 4 | 74 | 0.01 | |
direct path write temp | 1,212 | 3 | 3 | 0.18 | |
gc object scan | 620 | 97 | 3 | 5 | 0.09 |
enq: WF - contention | 19 | 26 | 3 | 142 | 0.00 |
wait for votes | 91 | 100 | 3 | 29 | 0.01 |
direct path read temp | 434 | 3 | 6 | 0.06 | |
enq: TO - contention | 42 | 5 | 3 | 61 | 0.01 |
enq: TM - contention | 692 | 0 | 1 | 2 | 0.10 |
enq: PS - contention | 99 | 2 | 1 | 13 | 0.01 |
latch: parallel query alloc buffer | 107 | 1 | 11 | 0.02 | |
wait for a undo record | 244 | 0 | 1 | 4 | 0.04 |
CSS operation: data query | 6 | 1 | 161 | 0.00 | |
kksfbc child completion | 17 | 100 | 1 | 49 | 0.00 |
enq: TX - contention | 375 | 1 | 2 | 0.05 | |
control file parallel write | 478 | 1 | 1 | 0.07 | |
CSS operation: action | 361 | 1 | 2 | 0.05 | |
cursor: mutex S | 510,250 | 1 | 0 | 74.08 | |
kjctssqmg: quick message send wait | 285 | 98 | 1 | 2 | 0.04 |
ksxr poll remote instances | 52,374 | 38 | 0 | 0 | 7.60 |
latch: cache buffer handles | 41 | 0 | 10 | 0.01 | |
enq: SQ - contention | 17 | 0 | 24 | 0.00 | |
enq: IR - contention | 2 | 0 | 154 | 0.00 | |
enq: PR - contention | 4 | 0 | 73 | 0.00 | |
CGS wait for IPC msg | 31,354 | 99 | 0 | 0 | 4.55 |
gc current block unknown | 25 | 0 | 9 | 0.00 | |
log file sequential read | 52 | 0 | 4 | 0.01 | |
direct path write | 482 | 0 | 0 | 0.07 | |
cursor: mutex X | 66,905 | 0 | 0 | 9.71 | |
enq: FB - contention | 32 | 0 | 3 | 0.00 | |
global enqueue expand wait | 12 | 83 | 0 | 8 | 0.00 |
SQL*Net break/reset to dblink | 11 | 0 | 4 | 0.00 | |
PX Deq: reap credit | 2,434 | 98 | 0 | 0 | 0.35 |
buffer deadlock | 3,696 | 100 | 0 | 0 | 0.54 |
wait for stopper event to be increased | 1 | 0 | 22 | 0.00 | |
SQL*Net message to dblink | 23,592 | 0 | 0 | 3.43 | |
ges2 LMON to wake up LMD - mrcvr | 14 | 0 | 1 | 0.00 | |
IPC send completion sync | 16 | 100 | 0 | 0 | 0.00 |
CSS operation: query | 2 | 0 | 3 | 0.00 | |
gc claim | 13 | 0 | 0 | 0.00 | |
lock deadlock retry | 439 | 100 | 0 | 0 | 0.06 |
log file single write | 8 | 0 | 0 | 0.00 | |
enq: RT - contention | 2 | 0 | 0 | 0.00 | |
enq: TA - contention | 3 | 0 | 0 | 0.00 | |
latch: library cache pin | 1 | 0 | 1 | 0.00 | |
enq: JQ - contention | 1 | 0 | 1 | 0.00 | |
enq: TX - allocate ITL entry | 1 | 0 | 0 | 0.00 | |
PX qref latch | 286 | 78 | 0 | 0 | 0.04 |
gc cr disk read | 1 | 0 | 0 | 0.00 | |
SQL*Net more data to dblink | 19 | 0 | 0 | 0.00 | |
enq: PW - flush prewarm buffers | 1 | 0 | 0 | 0.00 | |
control file single write | 1 | 0 | 0 | 0.00 | |
enq: PG - contention | 1 | 0 | 0 | 0.00 | |
enq: PE - contention | 1 | 0 | 0 | 0.00 | |
ges lmd/lmses to unfreeze in rcfg - mrcvr | 1 | 0 | 0 | 0.00 | |
lock escalate retry | 3 | 67 | 0 | 0 | 0.00 |
ges global resource directory to be frozen | 1 | 0 | 0 | 0.00 | |
Log archive I/O | 1 | 0 | 0 | 0.00 | |
SQL*Net message from client | 1,300,860 | 1,521,772 | 1170 | 188.86 | |
gcs remote message | 1,066,663 | 71 | 23,538 | 22 | 154.86 |
PX Idle Wait | 1,655 | 90 | 3,973 | 2400 | 0.24 |
virtual circuit status | 64 | 100 | 1,875 | 29297 | 0.01 |
DIAG idle wait | 7,631 | 1 | 1,509 | 198 | 1.11 |
Streams AQ: qmn slave idle wait | 51 | 14 | 1,444 | 28308 | 0.01 |
Streams AQ: qmn coordinator idle wait | 173 | 64 | 1,305 | 7544 | 0.03 |
PX Deq: Txn Recovery Start | 820 | 64 | 1,286 | 1568 | 0.12 |
jobq slave wait | 369 | 100 | 1,080 | 2927 | 0.05 |
ges remote message | 437,342 | 65 | 933 | 2 | 63.49 |
Streams AQ: waiting for messages in the queue | 137 | 93 | 612 | 4468 | 0.02 |
Streams AQ: waiting for time management or cleanup tasks | 16 | 69 | 350 | 21898 | 0.00 |
class slave wait | 61 | 89 | 266 | 4356 | 0.01 |
PX Deq: Join ACK | 199 | 54 | 236 | 1187 | 0.03 |
PX Deq: Par Recov Execute | 1,900 | 2 | 154 | 81 | 0.28 |
PX Deq: Execution Msg | 126 | 48 | 126 | 998 | 0.02 |
PX Deq: Parse Reply | 39 | 38 | 14 | 350 | 0.01 |
PX Deq: Par Recov Reply | 86 | 5 | 7 | 85 | 0.01 |
PX Deq: Par Recov Change Vector | 4,536 | 5 | 1 | 0.66 | |
Streams AQ: RAC qmn coordinator idle wait | 176 | 100 | 4 | 21 | 0.03 |
single-task message | 7 | 0 | 32 | 0.00 | |
PX Deq: Msg Fragment | 26 | 8 | 0 | 1 | 0.00 |
PX Deq: Execute Reply | 24 | 21 | 0 | 1 | 0.00 |
PX Deq Credit: need buffer | 72 | 0 | 0 | 0.01 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
events in waitclass Other | 170,958 | 73 | 17,252 | 101 | 24.82 |
gc cr failure | 863 | 99 | 1,087 | 1259 | 0.13 |
gc current retry | 875 | 99 | 1,073 | 1226 | 0.13 |
latch: shared pool | 3,103 | 17 | 733 | 236 | 0.45 |
latch: library cache | 1,297 | 3 | 340 | 262 | 0.19 |
os thread startup | 405 | 61 | 266 | 656 | 0.06 |
latch: row cache objects | 831 | 1 | 214 | 257 | 0.12 |
row cache lock | 1,340 | 2 | 102 | 76 | 0.19 |
gc domain validation | 48 | 92 | 89 | 1861 | 0.01 |
latch: redo writing | 196 | 55 | 281 | 0.03 | |
latch: cache buffers chains | 271 | 45 | 165 | 0.04 | |
db file parallel write | 9,586 | 15 | 2 | 1.39 | |
gc cr block congested | 9 | 78 | 12 | 1290 | 0.00 |
control file sequential read | 18,831 | 11 | 1 | 2.73 | |
library cache lock | 149 | 13 | 11 | 76 | 0.02 |
buffer busy waits | 20 | 55 | 11 | 549 | 0.00 |
gc cr multi block request | 103 | 2 | 11 | 103 | 0.01 |
gc cr grant 2-way | 200 | 4 | 10 | 49 | 0.03 |
db file sequential read | 921 | 9 | 10 | 0.13 | |
log file parallel write | 8,555 | 6 | 1 | 1.24 | |
gc current block congested | 3 | 33 | 6 | 1938 | 0.00 |
gc current grant 2-way | 95 | 4 | 5 | 52 | 0.01 |
db file scattered read | 116 | 3 | 29 | 0.02 | |
library cache pin | 61 | 2 | 3 | 54 | 0.01 |
gc object scan | 620 | 97 | 3 | 5 | 0.09 |
gc cr block 2-way | 82 | 2 | 28 | 0.01 | |
gc cr grant congested | 2 | 1 | 689 | 0.00 | |
enq: TM - contention | 646 | 0 | 1 | 2 | 0.09 |
control file parallel write | 479 | 1 | 1 | 0.07 | |
gc current grant congested | 1 | 0 | 445 | 0.00 | |
latch: library cache lock | 3 | 67 | 0 | 93 | 0.00 |
log file sequential read | 52 | 0 | 4 | 0.01 | |
enq: HW - contention | 275 | 0 | 0 | 0.04 | |
db file parallel read | 6 | 0 | 15 | 0.00 | |
log file single write | 8 | 0 | 0 | 0.00 | |
control file single write | 1 | 0 | 0 | 0.00 | |
Log archive I/O | 1 | 0 | 0 | 0.00 | |
gc buffer busy | 1 | 0 | 0 | 0.00 | |
gcs remote message | 1,066,677 | 71 | 23,546 | 22 | 154.86 |
rdbms ipc message | 93,157 | 25 | 19,159 | 206 | 13.52 |
DIAG idle wait | 7,521 | 1,487 | 198 | 1.09 | |
Streams AQ: qmn slave idle wait | 47 | 13 | 1,387 | 29510 | 0.01 |
pmon timer | 1,010 | 82 | 1,322 | 1308 | 0.15 |
Streams AQ: qmn coordinator idle wait | 173 | 64 | 1,305 | 7544 | 0.03 |
smon timer | 6 | 83 | 991 | 165137 | 0.00 |
ges remote message | 437,294 | 65 | 934 | 2 | 63.49 |
Streams AQ: waiting for time management or cleanup tasks | 16 | 69 | 350 | 21898 | 0.00 |
class slave wait | 57 | 95 | 266 | 4662 | 0.01 |
PX Deq: Par Recov Reply | 86 | 5 | 7 | 85 | 0.01 |
Streams AQ: RAC qmn coordinator idle wait | 176 | 100 | 4 | 21 | 0.03 |
PX Deq: Join ACK | 67 | 0 | 1 | 0.01 | |
PX Deq Credit: need buffer | 72 | 0 | 0 | 0.01 |
Statistic | Total |
---|---|
NUM_LCPUS | 0 |
NUM_VCPUS | 0 |
AVG_BUSY_TIME | 5,947 |
AVG_IDLE_TIME | 185,594 |
AVG_IOWAIT_TIME | 32,069 |
AVG_SYS_TIME | 2,388 |
AVG_USER_TIME | 3,536 |
BUSY_TIME | 381,928 |
IDLE_TIME | 11,879,510 |
IOWAIT_TIME | 2,053,835 |
SYS_TIME | 154,013 |
USER_TIME | 227,915 |
LOAD | 29 |
OS_CPU_WAIT_TIME | 1,583,300 |
RSRC_MGR_CPU_WAIT_TIME | 0 |
VM_IN_BYTES | 834,916,352 |
VM_OUT_BYTES | 5,303,087,104 |
PHYSICAL_MEMORY_BYTES | 66,571,993,088 |
NUM_CPUS | 64 |
NUM_CPU_CORES | 32 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
---|---|---|---|---|
ndmis | 302,620.30 | 1,348.60 | 403,136 | 66,116,454 |
SYS$USERS | 5,806.00 | 3.20 | 10,588 | 30,666 |
SYS$BACKGROUND | 4.30 | 0.10 | 8,661 | 122,566 |
nd_mis | 0.00 | 0.00 | 0 | 0 |
ndmisXDB | 0.00 | 0.00 | 0 | 0 |
Service Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
---|---|---|---|---|---|---|---|---|
ndmis | 177408 | 2007 | 2205924 | 165081 | 0 | 0 | 1654901 | 1073 |
SYS$USERS | 1455 | 24 | 2936 | 597 | 0 | 0 | 866 | 0 |
SYS$BACKGROUND | 2067 | 17 | 12436 | 1759 | 0 | 0 | 0 | 0 |
nd_mis | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | CPU Time (s) | Executions | Elap per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
39,982 | 3 | 998 | 40.06 | 12.95 | fgu2g3jt27ka4 | JDBC Thin Client | select count(1) from indy_onli... |
17,211 | 75 | 1,107 | 15.55 | 5.58 | 483awj0kbnfqr | JDBC Thin Client | declare linkid varchar2(128); ... |
13,725 | 11 | 711 | 19.30 | 4.45 | 0ptxn6whczpaj | JDBC Thin Client | begin insert into indy_online_... |
13,469 | 4 | 1,110 | 12.13 | 4.36 | 7q0mrfy5py47y | JDBC Thin Client | INSERT INTO INDY_USE_LOG(LOG_I... |
13,199 | 7 | 711 | 18.56 | 4.28 | fcgwwxtw17p55 | JDBC Thin Client | INSERT INTO INDY_ONLINE_USER(L... |
4,925 | 171 | 772 | 6.38 | 1.60 | f3zd7grha43by | JDBC Thin Client | select count(1) from indy_onli... |
3,674 | 74 | 1,052 | 3.49 | 1.19 | ff40ndudptw4c | JDBC Thin Client | DELETE FROM INDY_ONLINE_USER W... |
3,415 | 0 | 37 | 92.30 | 1.11 | 4bm46js67ss7t | JDBC Thin Client | update ol$_objects set D_03 = ... |
3,110 | 0 | 7 | 444.32 | 1.01 | f1ypmrqprt2j2 | JDBC Thin Client | update ol$_objects set S_15 = ... |
3,042 | 2 | 1,129 | 2.69 | 0.99 | cjz46bvt9kd0t | JDBC Thin Client | INSERT INTO OL$_OBJECTS (OBJ_I... |
CPU Time (s) | Elapsed Time (s) | Executions | CPU per Exec (s) | % Total | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
171 | 4,925 | 772 | 0.22 | 12.68 | 1.60 | f3zd7grha43by | JDBC Thin Client | select count(1) from indy_onli... |
75 | 17,211 | 1,107 | 0.07 | 5.58 | 5.58 | 483awj0kbnfqr | JDBC Thin Client | declare linkid varchar2(128); ... |
74 | 3,674 | 1,052 | 0.07 | 5.48 | 1.19 | ff40ndudptw4c | JDBC Thin Client | DELETE FROM INDY_ONLINE_USER W... |
63 | 262 | 31,462 | 0.00 | 4.69 | 0.08 | 964zgsudcdac7 | JDBC Thin Client | SELECT D.ATTR_URI FROM OL$_ATT... |
29 | 2,716 | 1,165 | 0.03 | 2.17 | 0.88 | 9g4jrwq86jnb7 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKANDUP... |
24 | 233 | 1,205 | 0.02 | 1.78 | 0.08 | 5wfhpq886xacr | JDBC Thin Client | SELECT /*+index(t, NK_OL$_REFS... |
19 | 1,745 | 3,587 | 0.01 | 1.42 | 0.57 | a41yvpfth003x | JDBC Thin Client | select * from v$_ST_Equipment ... |
12 | 1,103 | 51 | 0.23 | 0.86 | 0.36 | dbgctn9f6071v | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
11 | 28 | 2 | 5.71 | 0.84 | 0.01 | 2jbjm1m7dstzs | JDBC Thin Client | SELECT * FROM sgpm.o_org WHERE... |
11 | 29 | 69 | 0.16 | 0.84 | 0.01 | awvtdy3vc6fum | JDBC Thin Client | SELECT codeId, codeSortId, par... |
Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
9,945,902 | 31,462 | 316.12 | 15.12 | 63.35 | 261.75 | 964zgsudcdac7 | JDBC Thin Client | SELECT D.ATTR_URI FROM OL$_ATT... |
8,824,930 | 1,165 | 7,575.05 | 13.41 | 29.30 | 2716.16 | 9g4jrwq86jnb7 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKANDUP... |
8,540,809 | 1,205 | 7,087.81 | 12.98 | 24.01 | 232.96 | 5wfhpq886xacr | JDBC Thin Client | SELECT /*+index(t, NK_OL$_REFS... |
7,229,488 | 106,458 | 67.91 | 10.99 | 10.65 | 36.76 | fc42s7rxq7chg | JDBC Thin Client | SELECT CLS_URI FROM OL$_CLASSE... |
3,481,466 | 69 | 50,456.03 | 5.29 | 11.36 | 28.71 | awvtdy3vc6fum | JDBC Thin Client | SELECT codeId, codeSortId, par... |
1,716,033 | 942 | 1,821.69 | 2.61 | 4.91 | 817.99 | bsm6gmajgmhuu | JDBC Thin Client | select * from indy_menu where ... |
1,393,116 | 20,485 | 68.01 | 2.12 | 3.58 | 28.91 | 1gcnmuw9xtb3k | JDBC Thin Client | SELECT CLS_URI FROM OL$_CLASSE... |
1,288,250 | 1 | 1,288,250.00 | 1.96 | 9.07 | 278.79 | 7hg004b3d9kkg | JDBC Thin Client | select b.name deptName, a.USER... |
923,160 | 59 | 15,646.78 | 1.40 | 5.85 | 1223.80 | ab0n17bxfj28d | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
764,279 | 1,461 | 523.12 | 1.16 | 2.21 | 968.66 | 450w20twk6ku5 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKNAMEM... |
751,342 | 419 | 1,793.18 | 1.14 | 2.17 | 157.94 | avjzuwm5npxv7 | JDBC Thin Client | select * from indy_menu where ... |
750,044 | 91 | 8,242.24 | 1.14 | 4.84 | 1497.10 | 7xn6xppmpg9u7 | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
709,255 | 3 | 236,418.33 | 1.08 | 3.24 | 306.04 | 0k5gsd7bnr1wr | JDBC Thin Client | select b.workingBeginDateMin, ... |
690,873 | 612 | 1,128.88 | 1.05 | 2.72 | 2189.32 | g0mmxhhfz1q9g | JDBC Thin Client | select * from v$_LowArea where... |
Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
76,785 | 1 | 76,785.00 | 18.10 | 8.73 | 515.40 | 3dkx4wzwqd49x | JDBC Thin Client | SELECT PROCESSID, SW_PROCESSID... |
48,656 | 82 | 593.37 | 11.47 | 7.15 | 1935.01 | 4ydgzsjh9kb57 | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
28,159 | 4 | 7,039.75 | 6.64 | 9.57 | 27.15 | 0jat7ccc9fvct | JDBC Thin Client | Select Pc.Obj_Id, Pc.Cls_Uri, ... |
17,003 | 19 | 894.89 | 4.01 | 9.94 | 2316.21 | 598k07tzg7tud | JDBC Thin Client | Select Ass.Obj_Id, ass.CLS_URI... |
5,748 | 59 | 97.42 | 1.36 | 5.85 | 1223.80 | ab0n17bxfj28d | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
5,334 | 91 | 58.62 | 1.26 | 4.84 | 1497.10 | 7xn6xppmpg9u7 | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
5,329 | 14 | 380.64 | 1.26 | 7.63 | 431.93 | 5nnxqj41g9xk6 | JDBC Thin Client | Select Pc.Obj_Id, Pc.Cls_Uri, ... |
3,449 | 1,557 | 2.22 | 0.81 | 1.84 | 1859.30 | 9yyb7wvndk114 | JDBC Thin Client | select * from v$_ST_DYLine whe... |
3,368 | 612 | 5.50 | 0.79 | 2.72 | 2189.32 | g0mmxhhfz1q9g | JDBC Thin Client | select * from v$_LowArea where... |
3,087 | 110 | 28.06 | 0.73 | 1.32 | 275.36 | 1r7mjtz9kp72t | JDBC Thin Client | select * from (select /*+rule*... |
Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
122,146 | 121,974 | 1.00 | 0.00 | 0.00 | 646v5z184310m | JDBC Thin Client | select t.s_01 from olive.ol$_o... |
106,458 | 106,256 | 1.00 | 0.00 | 0.00 | fc42s7rxq7chg | JDBC Thin Client | SELECT CLS_URI FROM OL$_CLASSE... |
31,462 | 31,344 | 1.00 | 0.00 | 0.01 | 964zgsudcdac7 | JDBC Thin Client | SELECT D.ATTR_URI FROM OL$_ATT... |
20,485 | 20,486 | 1.00 | 0.00 | 0.00 | 1gcnmuw9xtb3k | JDBC Thin Client | SELECT CLS_URI FROM OL$_CLASSE... |
18,507 | 16,747 | 0.90 | 0.00 | 0.00 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt,... | |
16,962 | 33,139 | 1.95 | 0.00 | 0.01 | cfrwbnuu2xtam | JDBC Thin Client | select side_b from ol$_associa... |
16,906 | 16,894 | 1.00 | 0.00 | 0.11 | g4rzpg6rj116d | JDBC Thin Client | BEGIN OL$_RULE_CORE.SETSTRATTR... |
15,841 | 15,794 | 1.00 | 0.00 | 0.08 | bunvx480ynf57 | JDBC Thin Client | SELECT 1 FROM DUAL |
8,932 | 8,932 | 1.00 | 0.00 | 0.00 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
6,729 | 6,728 | 1.00 | 0.00 | 0.01 | 7gfjbwmcxjx9s | JDBC Thin Client | SELECT COUNT(*) FROM OL$_OBJEC... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
8,932 | 8,932 | 5.50 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
6,149 | 6,152 | 3.79 | grwydz59pu6mc | select text from view$ where r... | |
5,217 | 5,231 | 3.21 | 0h6b2sajwb74n | select privilege#, level from ... | |
3,174 | 3,174 | 1.96 | 1cjy8v3c0agny | select sys_nc_oid$ from xdb.xd... | |
2,445 | 2,450 | 1.51 | 3pxuuh0sx2sqx | Begin Dbms_Application_Info.Se... | |
2,435 | 2,478 | 1.50 | 0k8522rmdzg4k | select privilege# from sysauth... | |
2,401 | 2,457 | 1.48 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
2,394 | 2,471 | 1.47 | 459f3z9u4fb3u | select value$ from props$ wher... | |
2,383 | 2,430 | 1.47 | 5ur69atw3vfhj | select decode(failover_method,... | |
2,086 | 15,841 | 1.29 | bunvx480ynf57 | JDBC Thin Client | SELECT 1 FROM DUAL |
1,936 | 2,824 | 1.19 | 449xyhjkn7apn | JDBC Thin Client | select * from v$_ST_EquipmentC... |
1,921 | 2,500 | 1.18 | d3gsxy5k0u8hw | JDBC Thin Client | select * from v$_ST_Asset wher... |
1,914 | 5,848 | 1.18 | 8b9zc43w360qt | JDBC Thin Client | SELECT O_28 partitionField FRO... |
1,827 | 3,587 | 1.13 | a41yvpfth003x | JDBC Thin Client | select * from v$_ST_Equipment ... |
1,785 | 4,457 | 1.10 | 02djppxs4a73n | JDBC Thin Client | update ol$_locks t set t.obj =... |
1,676 | 6,644 | 1.03 | 7xgzx0zrnt0fc | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
1,355,817 | 3 | 0.03 | f5yun5dynkskv | plsqldev.exe | select s.synonym_name as obje... |
1,154,013 | 18 | 0.03 | f8uvk4ymbh19z | JDBC Thin Client | SELECT NAME, TYPE, ACTION_URL,... |
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
540 | 1,113 | dczy7gkm3mpax | JDBC Thin Client | update ol$_objects set S_04 = ... |
540 | 1,113 | dczy7gkm3mpax | JDBC Thin Client | update ol$_objects set S_04 = ... |
428 | 8,932 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
312 | 82 | 48hzu5y6ztvb8 | JDBC Thin Client | update ol$_objects set O_04 = ... |
312 | 82 | 48hzu5y6ztvb8 | JDBC Thin Client | update ol$_objects set O_04 = ... |
284 | 18,507 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt,... | |
220 | 30 | 27znnd1xfzpnp | JDBC Thin Client | update ol$_objects set S_63 = ... |
220 | 30 | 27znnd1xfzpnp | JDBC Thin Client | update ol$_objects set S_63 = ... |
209 | 414 | czxzy970jq50g | JDBC Thin Client | update ol$_objects set S_27 = ... |
209 | 414 | czxzy970jq50g | JDBC Thin Client | update ol$_objects set S_27 = ... |
199 | 53 | 2mah5fag4pzzv | JDBC Thin Client | update ol$_objects set O_05 = ... |
199 | 53 | 2mah5fag4pzzv | JDBC Thin Client | update ol$_objects set O_05 = ... |
175 | 56 | 1ks9z4mvpjt33 | JDBC Thin Client | update ol$_objects set D_03 = ... |
175 | 56 | 1ks9z4mvpjt33 | JDBC Thin Client | update ol$_objects set D_03 = ... |
173 | 1,333 | 04xtrk7uyhknh | select obj#, type#, ctime, mti... | |
142 | 100 | 4bzh761vk20q0 | JDBC Thin Client | update ol$_objects set D_07 = ... |
142 | 100 | 4bzh761vk20q0 | JDBC Thin Client | update ol$_objects set D_07 = ... |
135 | 1 | c4zp1p9yb7brg | JDBC Thin Client | update ol$_objects set S_63 = ... |
134 | 6,152 | grwydz59pu6mc | select text from view$ where r... | |
111 | 8 | 1nbxgk51xtn9p | JDBC Thin Client | update ol$_objects set S_63 = ... |
111 | 8 | 1nbxgk51xtn9p | JDBC Thin Client | update ol$_objects set S_63 = ... |
93 | 2,430 | 5ur69atw3vfhj | select decode(failover_method,... | |
89 | 122,146 | 646v5z184310m | JDBC Thin Client | select t.s_01 from olive.ol$_o... |
68 | 86 | 5f4yasqwng66g | JDBC Thin Client | update ol$_objects set N_52 = ... |
68 | 86 | 5f4yasqwng66g | JDBC Thin Client | update ol$_objects set N_52 = ... |
63 | 25 | 41wp41sp2ns44 | JDBC Thin Client | SELECT TASKID FROM WF_TASK WHE... |
50 | 27 | 91hakq9n36htp | JDBC Thin Client | SELECT TEXT_VALUE FROM WF_ITEM... |
45 | 711 | 0ptxn6whczpaj | JDBC Thin Client | begin insert into indy_online_... |
45 | 748 | 26sr8u5xavn56 | JDBC Thin Client | SELECT CLS_VIEW FROM OL$_CLASS... |
44 | 40 | 02upj301bbpz7 | JDBC Thin Client | update ol$_objects set S_63 = ... |
44 | 40 | 02upj301bbpz7 | JDBC Thin Client | update ol$_objects set S_63 = ... |
40 | 1,165 | 9g4jrwq86jnb7 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKANDUP... |
38 | 9 | 2p70njsc3jdvy | JDBC Thin Client | DELETE FROM SGPM.P_TASK_ASSIGN... |
37 | 1,107 | 483awj0kbnfqr | JDBC Thin Client | declare linkid varchar2(128); ... |
37 | 9 | fbg5fqdjsvbw9 | JDBC Thin Client | DELETE INDYWF_WORKLIST_COM WHE... |
37 | 9 | fbg5fqdjsvbw9 | JDBC Thin Client | DELETE INDYWF_WORKLIST_COM WHE... |
36 | 68 | dh48uzmwms409 | JDBC Thin Client | update ol$_objects set D_03 = ... |
36 | 68 | dh48uzmwms409 | JDBC Thin Client | update ol$_objects set D_03 = ... |
36 | 16,906 | g4rzpg6rj116d | JDBC Thin Client | BEGIN OL$_RULE_CORE.SETSTRATTR... |
35 | 419 | avjzuwm5npxv7 | JDBC Thin Client | select * from indy_menu where ... |
34 | 1,461 | 450w20twk6ku5 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKNAMEM... |
34 | 711 | fcgwwxtw17p55 | JDBC Thin Client | INSERT INTO INDY_ONLINE_USER(L... |
32 | 9 | 80hn6zhb2zpf4 | JDBC Thin Client | DELETE FROM OWF_MGR.WF_NOTIFIC... |
32 | 772 | f3zd7grha43by | JDBC Thin Client | select count(1) from indy_onli... |
31 | 1,052 | ff40ndudptw4c | JDBC Thin Client | DELETE FROM INDY_ONLINE_USER W... |
31 | 9 | gtfzp7x4sg6xu | JDBC Thin Client | DELETE FROM OWF_MGR.WF_ITEM_AC... |
30 | 18 | 6229274rb7bpc | JDBC Thin Client | SELECT * FROM (SELECT row_.*, ... |
30 | 9 | 9trfmfyhqpm5p | JDBC Thin Client | UPDATE INDYWF_INSTANCES_CUR SE... |
29 | 379 | 218prcturdt25 | JDBC Thin Client | DELETE FROM p_task WHERE task_... |
29 | 16,962 | cfrwbnuu2xtam | JDBC Thin Client | select side_b from ol$_associa... |
29 | 2,549 | dnctudjagb520 | JDBC Thin Client | select * from v$_ST_AssetModel... |
29 | 9 | g7sx2r79bnt4v | JDBC Thin Client | INSERT INTO INDYWF_WORKLIST_HI... |
28 | 5,231 | 0h6b2sajwb74n | select privilege#, level from ... | |
27 | 2,500 | d3gsxy5k0u8hw | JDBC Thin Client | select * from v$_ST_Asset wher... |
27 | 17 | ggak0dvtsppv3 | JDBC Thin Client | SELECT /*+ leading(wias) index... |
26 | 100 | 8d3y3sqaj9f3s | JDBC Thin Client | SELECT * FROM (SELECT row_.*, ... |
26 | 100 | 8d3y3sqaj9f3s | JDBC Thin Client | SELECT * FROM (SELECT row_.*, ... |
25 | 703 | d7qa0bq22h0p3 | JDBC Thin Client | SELECT A FROM OL$_ASSOCIATIONS... |
25 | 612 | g0mmxhhfz1q9g | JDBC Thin Client | select * from v$_LowArea where... |
24 | 2,478 | 0k8522rmdzg4k | select privilege# from sysauth... | |
24 | 1,921 | 1f5c885f3vvfx | JDBC Thin Client | select /*+ index(v$_ST_Asset I... |
24 | 2,824 | 449xyhjkn7apn | JDBC Thin Client | select * from v$_ST_EquipmentC... |
23 | 45 | 8rdg2n7g8ftk3 | JDBC Thin Client | update ol$_objects set O_10 = ... |
23 | 45 | 8rdg2n7g8ftk3 | JDBC Thin Client | update ol$_objects set O_10 = ... |
23 | 998 | fgu2g3jt27ka4 | JDBC Thin Client | select count(1) from indy_onli... |
Cluster Wait Time (s) | CWT % of Elapsd Time | Elapsed Time(s) | CPU Time(s) | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
38,429.33 | 96.12 | 39,981.80 | 2.67 | 998 | fgu2g3jt27ka4 | JDBC Thin Client | select count(1) from indy_onli... |
7,414.22 | 43.08 | 17,211.23 | 75.39 | 1,107 | 483awj0kbnfqr | JDBC Thin Client | declare linkid varchar2(128); ... |
6,331.40 | 47.01 | 13,468.78 | 3.57 | 1,110 | 7q0mrfy5py47y | JDBC Thin Client | INSERT INTO INDY_USE_LOG(LOG_I... |
2,462.99 | 98.63 | 2,497.15 | 0.10 | 30 | 573u87gdj8xm1 | JDBC Thin Client | SELECT COUNT(*) CUN FROM T_WT_... |
2,360.45 | 47.93 | 4,924.65 | 171.45 | 772 | f3zd7grha43by | JDBC Thin Client | select count(1) from indy_onli... |
1,851.01 | 76.78 | 2,410.80 | 1.30 | 8 | g8w9fba2jp4ph | JDBC Thin Client | select * from st_institution_r... |
1,696.45 | 79.30 | 2,139.16 | 0.59 | 342 | fgyb29rrzf9jf | JDBC Thin Client | insert into P_TASK( TASK_ID , ... |
1,675.54 | 78.87 | 2,124.38 | 3.98 | 354 | 93dtuy0vt2k7q | JDBC Thin Client | SELECT task_id FROM p_task WHE... |
1,443.62 | 85.06 | 1,697.22 | 0.83 | 2,500 | d3gsxy5k0u8hw | JDBC Thin Client | select * from v$_ST_Asset wher... |
1,134.73 | 65.03 | 1,745.02 | 19.15 | 3,587 | a41yvpfth003x | JDBC Thin Client | select * from v$_ST_Equipment ... |
1,122.32 | 60.36 | 1,859.30 | 1.84 | 1,557 | 9yyb7wvndk114 | JDBC Thin Client | select * from v$_ST_DYLine whe... |
1,073.10 | 29.21 | 3,673.95 | 74.02 | 1,052 | ff40ndudptw4c | JDBC Thin Client | DELETE FROM INDY_ONLINE_USER W... |
1,034.76 | 47.26 | 2,189.32 | 2.72 | 612 | g0mmxhhfz1q9g | JDBC Thin Client | select * from v$_LowArea where... |
924.16 | 90.72 | 1,018.72 | 0.77 | 40 | 7wgzpzkd96b4p | JDBC Thin Client | SELECT n.id id, n.name name, n... |
807.22 | 32.83 | 2,458.64 | 0.60 | 379 | 218prcturdt25 | JDBC Thin Client | DELETE FROM p_task WHERE task_... |
745.06 | 5.64 | 13,199.36 | 7.07 | 711 | fcgwwxtw17p55 | JDBC Thin Client | INSERT INTO INDY_ONLINE_USER(L... |
745.06 | 5.43 | 13,725.46 | 11.00 | 711 | 0ptxn6whczpaj | JDBC Thin Client | begin insert into indy_online_... |
644.94 | 78.84 | 817.99 | 4.91 | 942 | bsm6gmajgmhuu | JDBC Thin Client | select * from indy_menu where ... |
568.06 | 18.68 | 3,041.67 | 1.68 | 1,129 | cjz46bvt9kd0t | JDBC Thin Client | INSERT INTO OL$_OBJECTS (OBJ_I... |
552.03 | 28.53 | 1,935.01 | 7.15 | 82 | 4ydgzsjh9kb57 | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
469.42 | 61.18 | 767.31 | 7.29 | 2,824 | 449xyhjkn7apn | JDBC Thin Client | select * from v$_ST_EquipmentC... |
359.37 | 24.00 | 1,497.10 | 4.84 | 91 | 7xn6xppmpg9u7 | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
339.14 | 35.01 | 968.66 | 2.21 | 1,461 | 450w20twk6ku5 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKNAMEM... |
333.25 | 14.31 | 2,328.67 | 0.26 | 136 | 5z8x0pna8fk4a | JDBC Thin Client | DELETE FROM OL$_ASSOCIATIONS T... |
333.25 | 13.35 | 2,495.86 | 0.50 | 136 | cm7kjhuwrrq3g | JDBC Thin Client | begin begin OL$_Core.DeleteAss... |
300.13 | 27.21 | 1,102.86 | 11.58 | 51 | dbgctn9f6071v | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
295.09 | 76.24 | 387.07 | 0.15 | 1,810 | 0cxypy0hx9g11 | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
235.52 | 76.61 | 307.41 | 0.76 | 7 | 7vzpyu7p1t79j | JDBC Thin Client | select APPLY_ID, APPLY_CD, APP... |
221.10 | 25.00 | 884.35 | 1.30 | 5,848 | 8b9zc43w360qt | JDBC Thin Client | SELECT O_28 partitionField FRO... |
217.91 | 96.59 | 225.60 | 0.08 | 1 | 4bqz0z7vq1k3j | JDBC Thin Client | SELECT ORGID ORG_NO, ORGNAME O... |
212.83 | 17.39 | 1,223.80 | 5.85 | 59 | ab0n17bxfj28d | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
202.34 | 7.45 | 2,716.16 | 29.30 | 1,165 | 9g4jrwq86jnb7 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKANDUP... |
178.01 | 34.54 | 515.40 | 8.73 | 1 | 3dkx4wzwqd49x | JDBC Thin Client | SELECT PROCESSID, SW_PROCESSID... |
177.78 | 64.56 | 275.36 | 1.32 | 110 | 1r7mjtz9kp72t | JDBC Thin Client | select * from (select /*+rule*... |
128.21 | 55.04 | 232.96 | 24.01 | 1,205 | 5wfhpq886xacr | JDBC Thin Client | SELECT /*+index(t, NK_OL$_REFS... |
88.92 | 5.36 | 1,658.20 | 0.30 | 150 | 5ursqxfwnrz2m | JDBC Thin Client | insert into olive.ol$_event_lo... |
68.51 | 36.78 | 186.24 | 0.53 | 1,113 | dczy7gkm3mpax | JDBC Thin Client | update ol$_objects set S_04 = ... |
62.58 | 14.49 | 431.93 | 7.63 | 14 | 5nnxqj41g9xk6 | JDBC Thin Client | Select Pc.Obj_Id, Pc.Cls_Uri, ... |
57.92 | 40.36 | 143.50 | 0.32 | 1,921 | 1f5c885f3vvfx | JDBC Thin Client | select /*+ index(v$_ST_Asset I... |
41.16 | 1.78 | 2,316.21 | 9.94 | 19 | 598k07tzg7tud | JDBC Thin Client | Select Ass.Obj_Id, ass.CLS_URI... |
38.64 | 59.69 | 64.74 | 1.03 | 122,146 | 646v5z184310m | JDBC Thin Client | select t.s_01 from olive.ol$_o... |
37.72 | 55.06 | 68.52 | 0.09 | 4,537 | 6pcrpqf5dkunf | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
35.13 | 12.07 | 291.11 | 0.48 | 1,571 | 95jvxjj84rcct | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
34.58 | 30.24 | 114.38 | 0.86 | 65 | 9vrbr3jjprusn | JDBC Thin Client | SELECT B OBJ_ID, (SELECT S_01 ... |
31.33 | 21.16 | 148.12 | 0.26 | 2 | bvnkf18n91h4q | JDBC Thin Client | select a.line_id, a.line_name,... |
31.18 | 22.34 | 139.53 | 0.19 | 100 | 8d3y3sqaj9f3s | JDBC Thin Client | SELECT * FROM (SELECT row_.*, ... |
31.13 | 26.87 | 115.87 | 0.11 | 6,644 | 7xgzx0zrnt0fc | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
28.36 | 9.27 | 306.04 | 3.24 | 3 | 0k5gsd7bnr1wr | JDBC Thin Client | select b.workingBeginDateMin, ... |
28.28 | 51.68 | 54.71 | 0.18 | 100 | 4bzh761vk20q0 | JDBC Thin Client | update ol$_objects set D_07 = ... |
23.78 | 15.06 | 157.94 | 2.17 | 419 | avjzuwm5npxv7 | JDBC Thin Client | select * from indy_menu where ... |
23.15 | 1.35 | 1,719.21 | 0.52 | 288 | a1ymvq7wx3y4v | JDBC Thin Client | UPDATE V$_ST_IDENTIFIEDOBJECT ... |
18.00 | 21.77 | 82.70 | 0.17 | 18,507 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt,... | |
16.97 | 0.97 | 1,741.39 | 0.51 | 40 | 02upj301bbpz7 | JDBC Thin Client | update ol$_objects set S_63 = ... |
14.92 | 1.04 | 1,431.13 | 0.19 | 54 | g8mb1ky69dcp6 | JDBC Thin Client | update ol$_objects set N_42 = ... |
13.74 | 20.49 | 67.07 | 0.53 | 46 | 9rn5ah9npmbc8 | JDBC Thin Client | WITH CLS_LIST AS (SELECT (SELE... |
12.34 | 33.14 | 37.23 | 5.86 | 6,729 | 7gfjbwmcxjx9s | JDBC Thin Client | SELECT COUNT(*) FROM OL$_OBJEC... |
8.30 | 8.94 | 92.83 | 0.17 | 18 | 6229274rb7bpc | JDBC Thin Client | SELECT * FROM (SELECT row_.*, ... |
7.42 | 34.33 | 21.60 | 0.25 | 703 | d7qa0bq22h0p3 | JDBC Thin Client | SELECT A FROM OL$_ASSOCIATIONS... |
7.16 | 84.56 | 8.46 | 0.06 | 53 | 2mah5fag4pzzv | JDBC Thin Client | update ol$_objects set O_05 = ... |
6.72 | 83.17 | 8.08 | 0.03 | 2 | 6mv6h2kff55p2 | JDBC Thin Client | select distinct k.org_name, t.... |
5.84 | 11.49 | 50.85 | 0.12 | 2,549 | dnctudjagb520 | JDBC Thin Client | select * from v$_ST_AssetModel... |
5.06 | 62.16 | 8.14 | 0.05 | 30 | 27znnd1xfzpnp | JDBC Thin Client | update ol$_objects set S_63 = ... |
4.09 | 1.29 | 317.43 | 2.48 | 2,699 | b0mb9f2wdgnrk | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
4.06 | 19.32 | 21.01 | 2.87 | 82 | 48hzu5y6ztvb8 | JDBC Thin Client | update ol$_objects set O_04 = ... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
CPU used by this session | 4,062,334 | 2,156.19 | 589.77 |
CPU used when call started | 98,634 | 52.35 | 14.32 |
CR blocks created | 8,913 | 4.73 | 1.29 |
Cached Commit SCN referenced | 141,350 | 75.03 | 20.52 |
Commit SCN cached | 45 | 0.02 | 0.01 |
DB time | 24,448,194 | 12,976.53 | 3,549.39 |
DBWR checkpoint buffers written | 33,818 | 17.95 | 4.91 |
DBWR checkpoints | 16 | 0.01 | 0.00 |
DBWR fusion writes | 6,919 | 3.67 | 1.00 |
DBWR object drop buffers written | 0 | 0.00 | 0.00 |
DBWR parallel query checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 509 | 0.27 | 0.07 |
DBWR undo block writes | 7,800 | 4.14 | 1.13 |
DFO trees parallelized | 13 | 0.01 | 0.00 |
Misses for writing mapping | 1 | 0.00 | 0.00 |
PX local messages recv'd | 8,540 | 4.53 | 1.24 |
PX local messages sent | 8,109 | 4.30 | 1.18 |
PX remote messages recv'd | 50 | 0.03 | 0.01 |
PX remote messages sent | 71 | 0.04 | 0.01 |
Parallel operations downgraded to serial | 0 | 0.00 | 0.00 |
Parallel operations not downgraded | 13 | 0.01 | 0.00 |
RowCR - row contention | 431 | 0.23 | 0.06 |
RowCR attempts | 17,004 | 9.03 | 2.47 |
RowCR hits | 16,723 | 8.88 | 2.43 |
SMON posted for dropping temp segment | 0 | 0.00 | 0.00 |
SMON posted for instance recovery | 1 | 0.00 | 0.00 |
SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 1,280,305 | 679.56 | 185.87 |
SQL*Net roundtrips to/from dblink | 23,587 | 12.52 | 3.42 |
active txn count during cleanout | 10,624 | 5.64 | 1.54 |
application wait time | 3,817,513 | 2,026.25 | 554.23 |
auto extends on undo tablespace | 0 | 0.00 | 0.00 |
background checkpoints completed | 0 | 0.00 | 0.00 |
background checkpoints started | 0 | 0.00 | 0.00 |
background timeouts | 5,437 | 2.89 | 0.79 |
branch node splits | 16 | 0.01 | 0.00 |
buffer is not pinned count | 15,978,702 | 8,481.12 | 2,319.79 |
buffer is pinned count | 24,129,811 | 12,807.54 | 3,503.17 |
bytes received via SQL*Net from client | 97,092,051 | 51,534.18 | 14,095.83 |
bytes received via SQL*Net from dblink | 12,370,369 | 6,565.90 | 1,795.93 |
bytes sent via SQL*Net to client | 993,599,560 | 527,379.34 | 144,250.81 |
bytes sent via SQL*Net to dblink | 2,789,802 | 1,480.76 | 405.02 |
calls to get snapshot scn: kcmgss | 2,461,127 | 1,306.31 | 357.31 |
calls to kcmgas | 102,957 | 54.65 | 14.95 |
calls to kcmgcs | 1,529 | 0.81 | 0.22 |
change write time | 5,230 | 2.78 | 0.76 |
cleanout - number of ktugct calls | 12,131 | 6.44 | 1.76 |
cleanouts and rollbacks - consistent read gets | 5,178 | 2.75 | 0.75 |
cleanouts only - consistent read gets | 2,684 | 1.42 | 0.39 |
cluster key scan block gets | 69,304 | 36.78 | 10.06 |
cluster key scans | 49,003 | 26.01 | 7.11 |
cluster wait time | 51,184,723 | 27,167.65 | 7,431.00 |
commit batch performed | 2,809 | 1.49 | 0.41 |
commit batch requested | 2,809 | 1.49 | 0.41 |
commit batch/immediate performed | 2,988 | 1.59 | 0.43 |
commit batch/immediate requested | 2,988 | 1.59 | 0.43 |
commit cleanout failures: block lost | 653 | 0.35 | 0.09 |
commit cleanout failures: buffer being written | 2 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 825 | 0.44 | 0.12 |
commit cleanout failures: cannot pin | 52 | 0.03 | 0.01 |
commit cleanouts | 39,977 | 21.22 | 5.80 |
commit cleanouts successfully completed | 38,445 | 20.41 | 5.58 |
commit immediate performed | 179 | 0.10 | 0.03 |
commit immediate requested | 179 | 0.10 | 0.03 |
commit txn count during cleanout | 6,701 | 3.56 | 0.97 |
concurrency wait time | 16,945,384 | 8,994.21 | 2,460.13 |
consistent changes | 46,120 | 24.48 | 6.70 |
consistent gets | 65,468,267 | 34,749.02 | 9,504.68 |
consistent gets - examination | 17,020,316 | 9,033.98 | 2,471.01 |
consistent gets direct | 3,367 | 1.79 | 0.49 |
consistent gets from cache | 65,464,898 | 34,747.23 | 9,504.20 |
current blocks converted for CR | 56 | 0.03 | 0.01 |
cursor authentications | 2,284 | 1.21 | 0.33 |
data blocks consistent reads - undo records applied | 15,549 | 8.25 | 2.26 |
db block changes | 237,076 | 125.83 | 34.42 |
db block gets | 329,829 | 175.07 | 47.88 |
db block gets direct | 1,579 | 0.84 | 0.23 |
db block gets from cache | 328,250 | 174.23 | 47.66 |
deferred (CURRENT) block cleanout applications | 17,377 | 9.22 | 2.52 |
dirty buffers inspected | 122 | 0.06 | 0.02 |
drop segment calls in space pressure | 0 | 0.00 | 0.00 |
enqueue conversions | 56,687 | 30.09 | 8.23 |
enqueue deadlocks | 0 | 0.00 | 0.00 |
enqueue releases | 130,676 | 69.36 | 18.97 |
enqueue requests | 130,681 | 69.36 | 18.97 |
enqueue timeouts | 23 | 0.01 | 0.00 |
enqueue waits | 17,715 | 9.40 | 2.57 |
exchange deadlocks | 4,454 | 2.36 | 0.65 |
execute count | 1,470,962 | 780.75 | 213.55 |
failed probes on index block reclamation | 1 | 0.00 | 0.00 |
frame signature mismatch | 0 | 0.00 | 0.00 |
free buffer inspected | 642,771 | 341.17 | 93.32 |
free buffer requested | 648,323 | 344.11 | 94.12 |
gc CPU used by this session | 13,002 | 6.90 | 1.89 |
gc blocks lost | 0 | 0.00 | 0.00 |
gc claim blocks lost | 13 | 0.01 | 0.00 |
gc cr block build time | 21,906 | 11.63 | 3.18 |
gc cr block flush time | 6,421 | 3.41 | 0.93 |
gc cr block receive time | 594,813 | 315.71 | 86.35 |
gc cr block send time | 1,070 | 0.57 | 0.16 |
gc cr blocks received | 25,768 | 13.68 | 3.74 |
gc cr blocks served | 24,067 | 12.77 | 3.49 |
gc current block flush time | 5,605 | 2.98 | 0.81 |
gc current block pin time | 154,649 | 82.08 | 22.45 |
gc current block receive time | 2,095,844 | 1,112.42 | 304.27 |
gc current block send time | 90,823 | 48.21 | 13.19 |
gc current blocks received | 193,841 | 102.89 | 28.14 |
gc current blocks served | 191,950 | 101.88 | 27.87 |
gc local grants | 239,948 | 127.36 | 34.84 |
gc remote grants | 165,124 | 87.64 | 23.97 |
gcs messages sent | 1,909,154 | 1,013.33 | 277.17 |
ges messages sent | 145,383 | 77.17 | 21.11 |
global enqueue get time | 3,073,565 | 1,631.38 | 446.22 |
global enqueue gets async | 33,638 | 17.85 | 4.88 |
global enqueue gets sync | 139,421 | 74.00 | 20.24 |
global enqueue releases | 169,609 | 90.02 | 24.62 |
global undo segment hints helped | 0 | 0.00 | 0.00 |
global undo segment hints were stale | 0 | 0.00 | 0.00 |
heap block compress | 2,218 | 1.18 | 0.32 |
hot buffers moved to head of LRU | 528,211 | 280.36 | 76.69 |
immediate (CR) block cleanout applications | 7,865 | 4.17 | 1.14 |
immediate (CURRENT) block cleanout applications | 6,497 | 3.45 | 0.94 |
index crx upgrade (found) | 17 | 0.01 | 0.00 |
index crx upgrade (positioned) | 6,626 | 3.52 | 0.96 |
index fast full scans (full) | 32,069 | 17.02 | 4.66 |
index fast full scans (rowid ranges) | 0 | 0.00 | 0.00 |
index fetch by key | 6,554,119 | 3,478.77 | 951.53 |
index scans kdiixs1 | 1,760,865 | 934.63 | 255.64 |
leaf node 90-10 splits | 81 | 0.04 | 0.01 |
leaf node splits | 500 | 0.27 | 0.07 |
lob reads | 4,400 | 2.34 | 0.64 |
lob writes | 9,110 | 4.84 | 1.32 |
lob writes unaligned | 9,046 | 4.80 | 1.31 |
local undo segment hints helped | 0 | 0.00 | 0.00 |
local undo segment hints were stale | 0 | 0.00 | 0.00 |
logons cumulative | 2,971 | 1.58 | 0.43 |
messages received | 61,008 | 32.38 | 8.86 |
messages sent | 61,008 | 32.38 | 8.86 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 47,438,464 | 25,179.22 | 6,887.12 |
opened cursors cumulative | 221,531 | 117.58 | 32.16 |
parse count (failures) | 749 | 0.40 | 0.11 |
parse count (hard) | 13,877 | 7.37 | 2.01 |
parse count (total) | 162,334 | 86.16 | 23.57 |
parse time cpu | 43,078 | 22.86 | 6.25 |
parse time elapsed | 5,604,515 | 2,974.75 | 813.66 |
physical read IO requests | 196,047 | 104.06 | 28.46 |
physical read bytes | 3,474,530,304 | 1,844,199.20 | 504,432.39 |
physical read total IO requests | 215,376 | 114.32 | 31.27 |
physical read total bytes | 3,885,343,744 | 2,062,249.34 | 564,074.30 |
physical read total multi block requests | 21,672 | 11.50 | 3.15 |
physical reads | 424,137 | 225.12 | 61.58 |
physical reads cache | 401,103 | 212.90 | 58.23 |
physical reads cache prefetch | 221,915 | 117.79 | 32.22 |
physical reads direct | 22,498 | 11.94 | 3.27 |
physical reads direct (lob) | 3,233 | 1.72 | 0.47 |
physical reads direct temporary tablespace | 19,138 | 10.16 | 2.78 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 40,784 | 21.65 | 5.92 |
physical write bytes | 1,149,698,048 | 610,232.76 | 166,913.19 |
physical write total IO requests | 60,553 | 32.14 | 8.79 |
physical write total bytes | 1,304,995,840 | 692,661.19 | 189,459.33 |
physical write total multi block requests | 21,950 | 11.65 | 3.19 |
physical writes | 140,344 | 74.49 | 20.38 |
physical writes direct | 95,531 | 50.71 | 13.87 |
physical writes direct (lob) | 903 | 0.48 | 0.13 |
physical writes direct temporary tablespace | 94,237 | 50.02 | 13.68 |
physical writes from cache | 44,813 | 23.79 | 6.51 |
physical writes non checkpoint | 133,004 | 70.60 | 19.31 |
pinned buffers inspected | 290 | 0.15 | 0.04 |
prefetch clients - default | 11 | 0.01 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 10 | 0.01 | 0.00 |
process last non-idle time | 2,000 | 1.06 | 0.29 |
queries parallelized | 13 | 0.01 | 0.00 |
recovery blocks read | 6,851 | 3.64 | 0.99 |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
recursive calls | 2,956,325 | 1,569.15 | 429.20 |
recursive cpu usage | 32,913 | 17.47 | 4.78 |
redo blocks read for recovery | 91,488 | 48.56 | 13.28 |
redo blocks written | 129,012 | 68.48 | 18.73 |
redo buffer allocation retries | 0 | 0.00 | 0.00 |
redo entries | 129,309 | 68.63 | 18.77 |
redo log space requests | 0 | 0.00 | 0.00 |
redo log space wait time | 0 | 0.00 | 0.00 |
redo ordering marks | 4,905 | 2.60 | 0.71 |
redo size | 61,728,716 | 32,764.15 | 8,961.78 |
redo subscn max counts | 1,511 | 0.80 | 0.22 |
redo synch time | 39,652 | 21.05 | 5.76 |
redo synch writes | 6,816 | 3.62 | 0.99 |
redo wastage | 2,517,100 | 1,336.02 | 365.43 |
redo write broadcast ack time | 195,027 | 103.52 | 28.31 |
redo write time | 987 | 0.52 | 0.14 |
redo writer latching time | 647 | 0.34 | 0.09 |
redo writes | 8,528 | 4.53 | 1.24 |
rollback changes - undo records applied | 1,374 | 0.73 | 0.20 |
rollbacks only - consistent read gets | 3,928 | 2.08 | 0.57 |
root node splits | 1 | 0.00 | 0.00 |
rows fetched via callback | 2,544,588 | 1,350.61 | 369.42 |
session connect time | 1,987,652 | 1,055.00 | 288.57 |
session cursor cache hits | 131,085 | 69.58 | 19.03 |
session logical reads | 65,798,128 | 34,924.10 | 9,552.57 |
shared hash latch upgrades - no wait | 123,535 | 65.57 | 17.93 |
shared hash latch upgrades - wait | 685 | 0.36 | 0.10 |
sorts (disk) | 1 | 0.00 | 0.00 |
sorts (memory) | 123,411 | 65.50 | 17.92 |
sorts (rows) | 17,959,031 | 9,532.23 | 2,607.29 |
space was found by tune down | 0 | 0.00 | 0.00 |
space was not found by tune down | 0 | 0.00 | 0.00 |
sql area evicted | 12,676 | 6.73 | 1.84 |
sql area purged | 749 | 0.40 | 0.11 |
steps of tune down ret. in space pressure | 0 | 0.00 | 0.00 |
summed dirty queue length | 152 | 0.08 | 0.02 |
switch current to new buffer | 2,977 | 1.58 | 0.43 |
table fetch by rowid | 13,598,097 | 7,217.55 | 1,974.17 |
table fetch continued row | 90,197 | 47.87 | 13.09 |
table scan blocks gotten | 25,120,531 | 13,333.39 | 3,647.00 |
table scan rows gotten | 401,863,671 | 213,299.81 | 58,342.58 |
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) | 212,060 | 112.56 | 30.79 |
total number of times SMON posted | 1 | 0.00 | 0.00 |
transaction lock background get time | 0 | 0.00 | 0.00 |
transaction lock background gets | 536 | 0.28 | 0.08 |
transaction lock foreground requests | 536 | 0.28 | 0.08 |
transaction lock foreground wait time | 338 | 0.18 | 0.05 |
transaction rollbacks | 2,988 | 1.59 | 0.43 |
transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
tune down retentions in space pressure | 0 | 0.00 | 0.00 |
undo change vector size | 18,535,680 | 9,838.30 | 2,691.01 |
user I/O wait time | 204,821 | 108.71 | 29.74 |
user calls | 1,372,077 | 728.27 | 199.20 |
user commits | 6,286 | 3.34 | 0.91 |
user rollbacks | 602 | 0.32 | 0.09 |
workarea executions - onepass | 24 | 0.01 | 0.00 |
workarea executions - optimal | 87,797 | 46.60 | 12.75 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 8 | 0.00 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
session pga memory max | 4.9E+13 | 4.9E+13 |
session cursor cache count | 13,084,089 | 13,104,138 |
session uga memory | 8.2E+14 | 8.2E+14 |
opened cursors current | 41,317 | 113 |
workarea memory allocated | 24,499 | 113,511 |
logons current | 1,718 | 55 |
session uga memory max | 5.1E+12 | 5.1E+12 |
session pga memory | 2.6E+12 | 2.6E+12 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 0 | 0.00 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
DATA_OL | 75,044 | 40 | 34.94 | 2.50 | 9,708 | 5 | 19,673 | 777.45 |
IDX_OL | 37,973 | 20 | 47.29 | 1.00 | 13,555 | 7 | 18,620 | 871.97 |
DATA_BI | 47,797 | 25 | 2.52 | 1.33 | 8 | 0 | 1,340 | 422.09 |
DATA_WF | 10,270 | 5 | 74.42 | 1.02 | 1,850 | 1 | 12,933 | 813.36 |
DATA_P | 6,198 | 3 | 34.02 | 13.04 | 635 | 0 | 26,185 | 992.40 |
IDX_WF | 3,009 | 2 | 442.36 | 1.00 | 3,531 | 2 | 193,914 | 987.21 |
IDX_BI | 6,525 | 3 | 2.10 | 1.00 | 3 | 0 | 4 | 40.00 |
TEMP | 2,475 | 1 | 15.24 | 7.88 | 3,939 | 2 | 0 | 0.00 |
IDX_P | 1,952 | 1 | 204.66 | 1.00 | 1,206 | 1 | 1,164 | 938.23 |
SYSTEM | 2,401 | 1 | 14.48 | 1.22 | 73 | 0 | 103 | 186.02 |
IDX_SG | 597 | 0 | 527.69 | 1.00 | 1,051 | 1 | 4,170 | 898.14 |
DATA_SG | 374 | 0 | 676.68 | 1.00 | 1,144 | 1 | 7,632 | 406.96 |
UNDOTBS1 | 813 | 0 | 1505.15 | 1.00 | 674 | 0 | 17,429 | 951.62 |
SYSAUX | 818 | 0 | 217.74 | 1.05 | 541 | 0 | 0 | 0.00 |
UNDOTBS2 | 40 | 0 | 82.00 | 1.00 | 1,305 | 1 | 371 | 5.34 |
DATA_YP | 207 | 0 | 580.63 | 1.00 | 1,105 | 1 | 0 | 0.00 |
IDX_SCA7 | 650 | 0 | 970.66 | 1.00 | 566 | 0 | 7 | 7.14 |
IDX_BI1 | 530 | 0 | 16.92 | 1.00 | 0 | 0 | 9 | 684.44 |
DATA_BI10 | 473 | 0 | 2.73 | 8.27 | 0 | 0 | 0 | 0.00 |
IDX_SCA | 90 | 0 | 369.22 | 1.00 | 54 | 0 | 0 | 0.00 |
DATA_BI9 | 79 | 0 | 44.68 | 4.87 | 6 | 0 | 640 | 274.94 |
IDX_SCA6 | 52 | 0 | 616.35 | 1.00 | 30 | 0 | 1 | 0.00 |
IDX_SCA5 | 41 | 0 | 580.24 | 1.00 | 31 | 0 | 0 | 0.00 |
IDX_SCA4 | 38 | 0 | 565.00 | 1.00 | 30 | 0 | 0 | 0.00 |
LOB_SCA | 36 | 0 | 195.00 | 1.00 | 18 | 0 | 0 | 0.00 |
IDX_SCA3 | 26 | 0 | 486.54 | 1.00 | 18 | 0 | 0 | 0.00 |
DATA_BI2 | 35 | 0 | 747.43 | 15.26 | 1 | 0 | 0 | 0.00 |
DATA_BI11 | 28 | 0 | 5.71 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_SCA14 | 23 | 0 | 675.22 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA2 | 14 | 0 | 331.43 | 1.00 | 7 | 0 | 28 | 17.14 |
DATA_SCA6 | 13 | 0 | 473.08 | 1.00 | 7 | 0 | 9 | 0.00 |
DATA_SCA10 | 13 | 0 | 450.00 | 1.00 | 6 | 0 | 0 | 0.00 |
DATA_SCA22 | 11 | 0 | 559.09 | 1.00 | 8 | 0 | 0 | 0.00 |
DATA_SCA8 | 13 | 0 | 342.31 | 1.00 | 6 | 0 | 12 | 7.50 |
DATA_BI8 | 17 | 0 | 4.71 | 1.00 | 1 | 0 | 1,861 | 543.16 |
DATA_SCA1 | 12 | 0 | 385.83 | 1.00 | 6 | 0 | 8 | 8.75 |
DATA_SCA11 | 11 | 0 | 454.55 | 1.00 | 7 | 0 | 0 | 0.00 |
DATA_SCA24 | 11 | 0 | 498.18 | 1.00 | 7 | 0 | 5 | 4.00 |
DATA_BI7 | 16 | 0 | 6.88 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_SCA13 | 10 | 0 | 454.00 | 1.00 | 6 | 0 | 0 | 0.00 |
DATA_SCA16 | 10 | 0 | 464.00 | 1.00 | 6 | 0 | 0 | 0.00 |
DATA_SCA18 | 9 | 0 | 655.56 | 1.00 | 6 | 0 | 0 | 0.00 |
IDX_SCA1 | 12 | 0 | 205.83 | 1.00 | 3 | 0 | 4 | 5.00 |
DATA_SCA3 | 11 | 0 | 215.45 | 1.00 | 3 | 0 | 15 | 8.00 |
DATA_SCA7 | 11 | 0 | 176.36 | 1.00 | 3 | 0 | 8 | 11.25 |
DATA_SCA9 | 9 | 0 | 482.22 | 1.00 | 5 | 0 | 0 | 0.00 |
IDX_SCA2 | 10 | 0 | 234.00 | 1.00 | 4 | 0 | 12 | 1.67 |
DATA_SCA12 | 7 | 0 | 812.86 | 1.00 | 6 | 0 | 0 | 0.00 |
DATA_SCA17 | 9 | 0 | 373.33 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA15 | 8 | 0 | 456.25 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA19 | 8 | 0 | 455.00 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA23 | 8 | 0 | 370.00 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA21 | 6 | 0 | 690.00 | 1.00 | 5 | 0 | 0 | 0.00 |
DATA_SCA5 | 9 | 0 | 155.56 | 1.00 | 2 | 0 | 0 | 0.00 |
DATA_SCA20 | 6 | 0 | 558.33 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA4 | 5 | 0 | 758.00 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_BI6 | 3 | 0 | 1166.67 | 1.00 | 3 | 0 | 385 | 152.21 |
IDX_YP | 0 | 0 | 0.00 | 0.00 | 5 | 0 | 0 | 0.00 |
DATA_BI12 | 1 | 0 | 10.00 | 1.00 | 3 | 0 | 28 | 469.29 |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|---|
DATA_BI | /dev/rndmis_4g_003 | 1,820 | 1 | 3.73 | 1.56 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_025 | 2,811 | 1 | 2.61 | 1.36 | 3 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_030 | 2,165 | 1 | 1.60 | 1.43 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_037 | 1,547 | 1 | 2.05 | 1.61 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_038 | 920 | 0 | 3.09 | 2.05 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_043 | 831 | 0 | 1.78 | 1.44 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_044 | 798 | 0 | 1.78 | 1.46 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_046 | 863 | 0 | 2.18 | 1.56 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_048 | 857 | 0 | 1.76 | 1.56 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_049 | 976 | 1 | 2.51 | 1.41 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_050 | 1,055 | 1 | 2.20 | 1.34 | 0 | 0 | 28 | 499.29 |
DATA_BI | /dev/rndmis_4g_053 | 1,053 | 1 | 2.13 | 1.34 | 1 | 0 | 13 | 193.08 |
DATA_BI | /dev/rndmis_4g_057 | 1,076 | 1 | 2.11 | 1.34 | 1 | 0 | 24 | 565.83 |
DATA_BI | /dev/rndmis_4g_060 | 1,070 | 1 | 1.93 | 1.39 | 0 | 0 | 25 | 578.80 |
DATA_BI | /dev/rndmis_4g_061 | 1,065 | 1 | 1.88 | 1.34 | 0 | 0 | 12 | 438.33 |
DATA_BI | /dev/rndmis_4g_067 | 1,130 | 1 | 2.20 | 1.33 | 0 | 0 | 16 | 521.25 |
DATA_BI | /dev/rndmis_4g_068 | 1,143 | 1 | 4.37 | 1.21 | 0 | 0 | 19 | 690.00 |
DATA_BI | /dev/rndmis_4g_081 | 1,222 | 1 | 2.58 | 1.27 | 0 | 0 | 44 | 708.86 |
DATA_BI | /dev/rndmis_4g_101 | 1,281 | 1 | 3.49 | 1.28 | 0 | 0 | 220 | 330.05 |
DATA_BI | /dev/rndmis_4g_102 | 1,267 | 1 | 5.16 | 1.29 | 0 | 0 | 108 | 480.74 |
DATA_BI | /dev/rndmis_4g_106 | 1,266 | 1 | 2.73 | 1.29 | 0 | 0 | 109 | 463.67 |
DATA_BI | /dev/rndmis_4g_113 | 1,276 | 1 | 3.50 | 1.29 | 0 | 0 | 161 | 506.21 |
DATA_BI | /dev/rndmis_4g_114 | 1,274 | 1 | 3.31 | 1.28 | 0 | 0 | 2 | 0.00 |
DATA_BI | /dev/rndmis_4g_115 | 1,302 | 1 | 3.15 | 1.32 | 2 | 0 | 181 | 257.40 |
DATA_BI | /dev/rndmis_4g_116 | 1,246 | 1 | 5.91 | 1.30 | 0 | 0 | 186 | 554.95 |
DATA_BI | /dev/rndmis_4g_127 | 1,260 | 1 | 3.10 | 1.29 | 0 | 0 | 126 | 175.24 |
DATA_BI | /dev/rndmis_4g_133 | 1,048 | 1 | 1.81 | 1.35 | 0 | 0 | 66 | 525.76 |
DATA_BI | /dev/rndmis_4g_134 | 1,950 | 1 | 2.35 | 1.20 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_135 | 1,918 | 1 | 2.14 | 1.18 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_146 | 1,820 | 1 | 1.69 | 1.20 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_152 | 1,047 | 1 | 2.02 | 1.33 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_155 | 787 | 0 | 5.40 | 1.31 | 1 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_156 | 775 | 0 | 1.38 | 1.30 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_160 | 779 | 0 | 1.26 | 1.31 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_163 | 783 | 0 | 1.28 | 1.30 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_164 | 1,681 | 1 | 1.55 | 1.14 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_167 | 2,635 | 1 | 0.88 | 1.09 | 0 | 0 | 0 | 0.00 |
DATA_BI10 | /dev/rndmis_8g_021 | 473 | 0 | 2.73 | 8.27 | 0 | 0 | 0 | 0.00 |
DATA_BI11 | /dev/rndmis_8g_022 | 28 | 0 | 5.71 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_BI12 | /dev/rndmis_8g_023 | 1 | 0 | 10.00 | 1.00 | 3 | 0 | 28 | 469.29 |
DATA_BI2 | /dev/rndmis_8g_008 | 35 | 0 | 747.43 | 15.26 | 1 | 0 | 0 | 0.00 |
DATA_BI6 | /dev/rndmis_8g_015 | 3 | 0 | 1166.67 | 1.00 | 3 | 0 | 385 | 152.21 |
DATA_BI7 | /dev/rndmis_8g_018 | 16 | 0 | 6.88 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_BI8 | /dev/rndmis_8g_019 | 17 | 0 | 4.71 | 1.00 | 1 | 0 | 1,861 | 543.16 |
DATA_BI9 | /dev/rndmis_8g_020 | 79 | 0 | 44.68 | 4.87 | 6 | 0 | 640 | 274.94 |
DATA_OL | /dev/rndmis_4g_015 | 5,251 | 3 | 13.97 | 2.39 | 180 | 0 | 166 | 329.70 |
DATA_OL | /dev/rndmis_4g_016 | 3,960 | 2 | 17.47 | 3.28 | 134 | 0 | 398 | 141.88 |
DATA_OL | /dev/rndmis_4g_017 | 3,694 | 2 | 23.91 | 3.36 | 225 | 0 | 2,745 | 833.82 |
DATA_OL | /dev/rndmis_4g_018 | 3,809 | 2 | 18.35 | 2.81 | 223 | 0 | 2,834 | 731.19 |
DATA_OL | /dev/rndmis_4g_019 | 4,297 | 2 | 28.72 | 2.44 | 220 | 0 | 1,787 | 617.80 |
DATA_OL | /dev/rndmis_4g_020 | 3,691 | 2 | 17.55 | 2.65 | 168 | 0 | 198 | 65.05 |
DATA_OL | /dev/rndmis_4g_021 | 3,583 | 2 | 19.55 | 2.73 | 135 | 0 | 132 | 186.29 |
DATA_OL | /dev/rndmis_4g_022 | 4,344 | 2 | 12.24 | 2.59 | 149 | 0 | 136 | 21.69 |
DATA_OL | /dev/rndmis_4g_023 | 3,981 | 2 | 15.97 | 2.70 | 180 | 0 | 1,175 | 898.14 |
DATA_OL | /dev/rndmis_4g_024 | 3,895 | 2 | 16.99 | 3.04 | 170 | 0 | 114 | 16.40 |
DATA_OL | /dev/rndmis_4g_026 | 1,510 | 1 | 8.60 | 2.56 | 41 | 0 | 26 | 272.69 |
DATA_OL | /dev/rndmis_4g_028 | 1,508 | 1 | 9.81 | 3.10 | 52 | 0 | 8 | 12.50 |
DATA_OL | /dev/rndmis_4g_034 | 1,542 | 1 | 29.84 | 3.74 | 168 | 0 | 72 | 311.94 |
DATA_OL | /dev/rndmis_4g_035 | 1,375 | 1 | 34.64 | 2.90 | 181 | 0 | 1,133 | 953.74 |
DATA_OL | /dev/rndmis_4g_040 | 3,042 | 2 | 95.00 | 2.39 | 343 | 0 | 143 | 329.23 |
DATA_OL | /dev/rndmis_4g_041 | 2,064 | 1 | 29.34 | 2.73 | 358 | 0 | 130 | 59.77 |
DATA_OL | /dev/rndmis_4g_058 | 2,601 | 1 | 57.23 | 2.05 | 295 | 0 | 106 | 402.83 |
DATA_OL | /dev/rndmis_4g_059 | 2,355 | 1 | 57.93 | 2.07 | 394 | 0 | 135 | 483.56 |
DATA_OL | /dev/rndmis_4g_071 | 2,676 | 1 | 81.93 | 2.29 | 580 | 0 | 449 | 173.59 |
DATA_OL | /dev/rndmis_4g_072 | 2,373 | 1 | 60.88 | 1.86 | 623 | 0 | 85 | 263.18 |
DATA_OL | /dev/rndmis_4g_075 | 2,377 | 1 | 44.39 | 1.95 | 636 | 0 | 194 | 499.79 |
DATA_OL | /dev/rndmis_4g_079 | 1,064 | 1 | 40.30 | 1.89 | 357 | 0 | 975 | 923.35 |
DATA_OL | /dev/rndmis_4g_080 | 1,122 | 1 | 76.65 | 1.63 | 412 | 0 | 132 | 348.48 |
DATA_OL | /dev/rndmis_4g_083 | 1,056 | 1 | 36.01 | 1.73 | 286 | 0 | 49 | 2.04 |
DATA_OL | /dev/rndmis_4g_084 | 768 | 0 | 53.37 | 1.95 | 209 | 0 | 971 | 983.71 |
DATA_OL | /dev/rndmis_4g_085 | 633 | 0 | 64.11 | 2.27 | 302 | 0 | 1,093 | 980.66 |
DATA_OL | /dev/rndmis_4g_086 | 767 | 0 | 53.68 | 1.93 | 227 | 0 | 1,099 | 996.67 |
DATA_OL | /dev/rndmis_4g_087 | 959 | 1 | 39.38 | 1.72 | 395 | 0 | 25 | 423.20 |
DATA_OL | /dev/rndmis_4g_088 | 864 | 0 | 41.47 | 1.68 | 240 | 0 | 9 | 3.33 |
DATA_OL | /dev/rndmis_4g_092 | 843 | 0 | 53.05 | 1.39 | 253 | 0 | 2,210 | 979.23 |
DATA_OL | /dev/rndmis_4g_210 | 735 | 0 | 51.58 | 1.07 | 210 | 0 | 901 | 994.97 |
DATA_OL | /dev/rndmis_4g_211 | 359 | 0 | 339.97 | 1.33 | 428 | 0 | 0 | 0.00 |
DATA_OL | /dev/rndmis_4g_212 | 120 | 0 | 51.42 | 1.98 | 55 | 0 | 1 | 160.00 |
DATA_OL | /dev/rndmis_4g_213 | 379 | 0 | 38.84 | 1.45 | 418 | 0 | 2 | 55.00 |
DATA_OL | /dev/rndmis_8g_043 | 685 | 0 | 50.88 | 1.75 | 233 | 0 | 18 | 460.00 |
DATA_OL | /dev/rndmis_8g_044 | 762 | 0 | 41.08 | 1.55 | 228 | 0 | 22 | 95.91 |
DATA_P | /dev/rndmis_4g_004 | 329 | 0 | 26.35 | 6.64 | 52 | 0 | 3 | 3.33 |
DATA_P | /dev/rndmis_4g_027 | 54 | 0 | 146.48 | 8.26 | 43 | 0 | 5 | 0.00 |
DATA_P | /dev/rndmis_4g_031 | 99 | 0 | 76.77 | 7.36 | 27 | 0 | 2,137 | 998.18 |
DATA_P | /dev/rndmis_4g_032 | 63 | 0 | 79.05 | 10.98 | 40 | 0 | 39 | 672.82 |
DATA_P | /dev/rndmis_4g_033 | 115 | 0 | 4.52 | 13.77 | 17 | 0 | 11 | 337.27 |
DATA_P | /dev/rndmis_4g_064 | 30 | 0 | 14.00 | 12.93 | 0 | 0 | 2,107 | 1007.58 |
DATA_P | /dev/rndmis_4g_065 | 48 | 0 | 298.75 | 11.23 | 0 | 0 | 3 | 0.00 |
DATA_P | /dev/rndmis_4g_074 | 24 | 0 | 37.08 | 11.63 | 7 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_099 | 40 | 0 | 75.25 | 2.15 | 8 | 0 | 3 | 0.00 |
DATA_P | /dev/rndmis_4g_104 | 29 | 0 | 5.17 | 13.69 | 10 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_109 | 11 | 0 | 5.45 | 2.09 | 8 | 0 | 1 | 10.00 |
DATA_P | /dev/rndmis_4g_121 | 1 | 0 | 10.00 | 1.00 | 3 | 0 | 8 | 985.00 |
DATA_P | /dev/rndmis_4g_122 | 3 | 0 | 10.00 | 1.00 | 0 | 0 | 31 | 925.16 |
DATA_P | /dev/rndmis_4g_123 | 13 | 0 | 10.77 | 1.00 | 0 | 0 | 13 | 767.69 |
DATA_P | /dev/rndmis_4g_124 | 6 | 0 | 3.33 | 1.00 | 0 | 0 | 7 | 4.29 |
DATA_P | /dev/rndmis_4g_128 | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_136 | 6 | 0 | 3.33 | 3.67 | 0 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_137 | 0 | 0 | 1 | 0 | 0 | 0.00 | ||
DATA_P | /dev/rndmis_4g_139 | 2 | 0 | 5.00 | 1.00 | 0 | 0 | 2 | 10.00 |
DATA_P | /dev/rndmis_4g_141 | 2 | 0 | 15.00 | 1.00 | 2 | 0 | 3 | 6.67 |
DATA_P | /dev/rndmis_4g_142 | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 3 | 3.33 |
DATA_P | /dev/rndmis_4g_143 | 80 | 0 | 2.00 | 2.46 | 2 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_144 | 6 | 0 | 5.00 | 1.00 | 0 | 0 | 1 | 780.00 |
DATA_P | /dev/rndmis_4g_148 | 367 | 0 | 3.92 | 14.99 | 18 | 0 | 2 | 0.00 |
DATA_P | /dev/rndmis_4g_149 | 499 | 0 | 16.25 | 11.29 | 93 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_150 | 356 | 0 | 20.67 | 15.42 | 19 | 0 | 1,070 | 998.99 |
DATA_P | /dev/rndmis_4g_153 | 359 | 0 | 77.69 | 15.30 | 9 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_154 | 377 | 0 | 99.18 | 14.62 | 61 | 0 | 4,611 | 946.24 |
DATA_P | /dev/rndmis_4g_158 | 358 | 0 | 112.96 | 15.34 | 22 | 0 | 36 | 551.11 |
DATA_P | /dev/rndmis_4g_159 | 402 | 0 | 23.23 | 13.83 | 1 | 0 | 1 | 10.00 |
DATA_P | /dev/rndmis_4g_165 | 355 | 0 | 25.27 | 15.46 | 0 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_166 | 367 | 0 | 11.17 | 14.99 | 12 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_168 | 465 | 0 | 8.92 | 11.88 | 29 | 0 | 3 | 983.33 |
DATA_P | /dev/rndmis_4g_169 | 320 | 0 | 6.41 | 14.06 | 0 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_170 | 315 | 0 | 1.84 | 14.26 | 9 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_8g_035 | 41 | 0 | 160.98 | 1.00 | 51 | 0 | 16,042 | 1008.38 |
DATA_P | /dev/rndmis_8g_038 | 47 | 0 | 26.17 | 1.00 | 24 | 0 | 27 | 545.93 |
DATA_P | /dev/rndmis_8g_061 | 306 | 0 | 3.86 | 14.65 | 66 | 0 | 16 | 403.13 |
DATA_P | /dev/rndmis_8g_062 | 301 | 0 | 3.36 | 14.90 | 0 | 0 | 0 | 0.00 |
DATA_SCA1 | /dev/rndmis_4g_176 | 12 | 0 | 385.83 | 1.00 | 6 | 0 | 8 | 8.75 |
DATA_SCA10 | /dev/rndmis_4g_187 | 13 | 0 | 450.00 | 1.00 | 6 | 0 | 0 | 0.00 |
DATA_SCA11 | /dev/rndmis_4g_188 | 11 | 0 | 454.55 | 1.00 | 7 | 0 | 0 | 0.00 |
DATA_SCA12 | /dev/rndmis_4g_189 | 7 | 0 | 812.86 | 1.00 | 6 | 0 | 0 | 0.00 |
DATA_SCA13 | /dev/rndmis_4g_190 | 10 | 0 | 454.00 | 1.00 | 6 | 0 | 0 | 0.00 |
DATA_SCA14 | /dev/rndmis_4g_191 | 23 | 0 | 675.22 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA15 | /dev/rndmis_4g_192 | 8 | 0 | 456.25 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA16 | /dev/rndmis_4g_193 | 10 | 0 | 464.00 | 1.00 | 6 | 0 | 0 | 0.00 |
DATA_SCA17 | /dev/rndmis_4g_194 | 9 | 0 | 373.33 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA18 | /dev/rndmis_4g_195 | 9 | 0 | 655.56 | 1.00 | 6 | 0 | 0 | 0.00 |
DATA_SCA19 | /dev/rndmis_4g_196 | 8 | 0 | 455.00 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA2 | /dev/rndmis_4g_177 | 14 | 0 | 331.43 | 1.00 | 7 | 0 | 28 | 17.14 |
DATA_SCA20 | /dev/rndmis_4g_197 | 6 | 0 | 558.33 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA21 | /dev/rndmis_4g_198 | 6 | 0 | 690.00 | 1.00 | 5 | 0 | 0 | 0.00 |
DATA_SCA22 | /dev/rndmis_4g_199 | 11 | 0 | 559.09 | 1.00 | 8 | 0 | 0 | 0.00 |
DATA_SCA23 | /dev/rndmis_4g_200 | 8 | 0 | 370.00 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA24 | /dev/rndmis_4g_201 | 11 | 0 | 498.18 | 1.00 | 7 | 0 | 5 | 4.00 |
DATA_SCA3 | /dev/rndmis_4g_178 | 11 | 0 | 215.45 | 1.00 | 3 | 0 | 15 | 8.00 |
DATA_SCA4 | /dev/rndmis_4g_179 | 5 | 0 | 758.00 | 1.00 | 4 | 0 | 0 | 0.00 |
DATA_SCA5 | /dev/rndmis_4g_180 | 9 | 0 | 155.56 | 1.00 | 2 | 0 | 0 | 0.00 |
DATA_SCA6 | /dev/rndmis_4g_181 | 13 | 0 | 473.08 | 1.00 | 7 | 0 | 9 | 0.00 |
DATA_SCA7 | /dev/rndmis_4g_182 | 11 | 0 | 176.36 | 1.00 | 3 | 0 | 8 | 11.25 |
DATA_SCA8 | /dev/rndmis_4g_183 | 13 | 0 | 342.31 | 1.00 | 6 | 0 | 12 | 7.50 |
DATA_SCA9 | /dev/rndmis_4g_186 | 9 | 0 | 482.22 | 1.00 | 5 | 0 | 0 | 0.00 |
DATA_SG | /dev/rndmis_4g_009 | 352 | 0 | 696.25 | 1.00 | 1,027 | 1 | 7,006 | 438.78 |
DATA_SG | /dev/rndmis_8g_013 | 11 | 0 | 322.73 | 1.00 | 94 | 0 | 626 | 50.85 |
DATA_SG | /dev/rndmis_8g_014 | 11 | 0 | 404.55 | 1.00 | 23 | 0 | 0 | 0.00 |
DATA_WF | /dev/rndmis_4g_005 | 2,943 | 2 | 157.21 | 1.05 | 1,180 | 1 | 10,137 | 902.04 |
DATA_WF | /dev/rndmis_4g_036 | 4,657 | 2 | 41.12 | 1.02 | 383 | 0 | 1,380 | 278.52 |
DATA_WF | /dev/rndmis_4g_107 | 2,670 | 1 | 41.24 | 1.00 | 287 | 0 | 1,416 | 699.77 |
DATA_YP | /dev/rndmis_4g_007 | 207 | 0 | 580.63 | 1.00 | 1,105 | 1 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_001 | 392 | 0 | 2.73 | 1.00 | 0 | 0 | 1 | 160.00 |
IDX_BI | /dev/rndmis_4g_039 | 131 | 0 | 1.30 | 1.00 | 0 | 0 | 3 | 0.00 |
IDX_BI | /dev/rndmis_4g_045 | 137 | 0 | 1.39 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_047 | 133 | 0 | 2.03 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_051 | 142 | 0 | 1.90 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_052 | 135 | 0 | 2.74 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_054 | 147 | 0 | 1.84 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_055 | 141 | 0 | 1.63 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_056 | 136 | 0 | 1.40 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_062 | 155 | 0 | 1.68 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_063 | 123 | 0 | 1.63 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_066 | 2 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_073 | 15 | 0 | 6.00 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_082 | 27 | 0 | 5.56 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_100 | 138 | 0 | 3.41 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_103 | 151 | 0 | 1.66 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_105 | 171 | 0 | 2.46 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_117 | 219 | 0 | 2.51 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_118 | 204 | 0 | 1.62 | 1.00 | 2 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_119 | 305 | 0 | 1.84 | 1.00 | 1 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_120 | 396 | 0 | 2.73 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_132 | 351 | 0 | 1.99 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_147 | 258 | 0 | 2.05 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_151 | 276 | 0 | 2.03 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_157 | 275 | 0 | 2.73 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_161 | 263 | 0 | 1.44 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_162 | 283 | 0 | 2.19 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_171 | 259 | 0 | 1.54 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_172 | 285 | 0 | 3.23 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_174 | 498 | 0 | 1.87 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_175 | 377 | 0 | 1.27 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI1 | /dev/rndmis_8g_016 | 530 | 0 | 16.92 | 1.00 | 0 | 0 | 9 | 684.44 |
IDX_OL | /dev/rndmis_4g_011 | 2,929 | 2 | 19.92 | 1.00 | 154 | 0 | 3,170 | 913.81 |
IDX_OL | /dev/rndmis_4g_012 | 3,043 | 2 | 16.26 | 1.00 | 153 | 0 | 2,036 | 794.97 |
IDX_OL | /dev/rndmis_4g_013 | 3,081 | 2 | 17.90 | 1.00 | 181 | 0 | 742 | 399.51 |
IDX_OL | /dev/rndmis_4g_014 | 3,350 | 2 | 21.77 | 1.00 | 338 | 0 | 479 | 97.54 |
IDX_OL | /dev/rndmis_4g_029 | 2,173 | 1 | 48.09 | 1.00 | 692 | 0 | 188 | 117.39 |
IDX_OL | /dev/rndmis_4g_069 | 2,846 | 2 | 21.46 | 1.00 | 367 | 0 | 60 | 308.17 |
IDX_OL | /dev/rndmis_4g_070 | 2,670 | 1 | 25.21 | 1.00 | 320 | 0 | 84 | 296.31 |
IDX_OL | /dev/rndmis_4g_076 | 2,614 | 1 | 22.76 | 1.00 | 246 | 0 | 48 | 108.13 |
IDX_OL | /dev/rndmis_4g_077 | 1,325 | 1 | 55.48 | 1.00 | 801 | 0 | 3,439 | 993.79 |
IDX_OL | /dev/rndmis_4g_078 | 1,263 | 1 | 49.71 | 1.00 | 781 | 0 | 36 | 766.39 |
IDX_OL | /dev/rndmis_4g_089 | 1,247 | 1 | 54.02 | 1.00 | 721 | 0 | 19 | 284.21 |
IDX_OL | /dev/rndmis_4g_090 | 1,563 | 1 | 46.54 | 1.00 | 836 | 0 | 41 | 372.44 |
IDX_OL | /dev/rndmis_4g_091 | 1,440 | 1 | 64.46 | 1.00 | 923 | 0 | 1,021 | 990.59 |
IDX_OL | /dev/rndmis_4g_093 | 1,153 | 1 | 89.95 | 1.00 | 612 | 0 | 259 | 720.69 |
IDX_OL | /dev/rndmis_4g_094 | 1,205 | 1 | 89.05 | 1.00 | 872 | 0 | 50 | 73.60 |
IDX_OL | /dev/rndmis_4g_095 | 1,079 | 1 | 60.66 | 1.00 | 446 | 0 | 29 | 138.28 |
IDX_OL | /dev/rndmis_4g_096 | 965 | 1 | 41.47 | 1.00 | 433 | 0 | 1,856 | 989.88 |
IDX_OL | /dev/rndmis_4g_097 | 928 | 0 | 142.58 | 1.00 | 783 | 0 | 4,423 | 976.06 |
IDX_OL | /dev/rndmis_4g_098 | 868 | 0 | 225.47 | 1.00 | 1,527 | 1 | 469 | 823.16 |
IDX_OL | /dev/rndmis_4g_108 | 537 | 0 | 166.54 | 1.00 | 722 | 0 | 39 | 521.54 |
IDX_OL | /dev/rndmis_4g_110 | 409 | 0 | 58.61 | 1.00 | 297 | 0 | 7 | 2.86 |
IDX_OL | /dev/rndmis_4g_111 | 479 | 0 | 75.14 | 1.00 | 436 | 0 | 12 | 145.00 |
IDX_OL | /dev/rndmis_4g_112 | 445 | 0 | 71.03 | 1.00 | 288 | 0 | 28 | 223.57 |
IDX_OL | /dev/rndmis_8g_024 | 195 | 0 | 179.44 | 1.00 | 356 | 0 | 4 | 10.00 |
IDX_OL | /dev/rndmis_8g_025 | 166 | 0 | 226.69 | 1.00 | 270 | 0 | 81 | 821.73 |
IDX_P | /dev/rndmis_4g_002 | 375 | 0 | 617.33 | 1.00 | 368 | 0 | 13 | 898.46 |
IDX_P | /dev/rndmis_4g_130 | 338 | 0 | 128.73 | 1.00 | 210 | 0 | 30 | 194.00 |
IDX_P | /dev/rndmis_4g_131 | 320 | 0 | 156.34 | 1.00 | 223 | 0 | 18 | 365.56 |
IDX_P | /dev/rndmis_4g_173 | 336 | 0 | 124.58 | 1.00 | 239 | 0 | 23 | 305.65 |
IDX_P | /dev/rndmis_4g_217 | 352 | 0 | 55.03 | 1.00 | 89 | 0 | 1,075 | 986.87 |
IDX_P | /dev/rndmis_4g_218 | 231 | 0 | 57.23 | 1.00 | 77 | 0 | 5 | 22.00 |
IDX_SCA | /dev/rndmis_4g_208 | 82 | 0 | 365.24 | 1.00 | 47 | 0 | 0 | 0.00 |
IDX_SCA | /dev/rndmis_4g_219 | 8 | 0 | 410.00 | 1.00 | 7 | 0 | 0 | 0.00 |
IDX_SCA1 | /dev/rndmis_4g_184 | 12 | 0 | 205.83 | 1.00 | 3 | 0 | 4 | 5.00 |
IDX_SCA2 | /dev/rndmis_4g_185 | 10 | 0 | 234.00 | 1.00 | 4 | 0 | 12 | 1.67 |
IDX_SCA3 | /dev/rndmis_4g_202 | 14 | 0 | 322.86 | 1.00 | 7 | 0 | 0 | 0.00 |
IDX_SCA3 | /dev/rndmis_4g_220 | 12 | 0 | 677.50 | 1.00 | 11 | 0 | 0 | 0.00 |
IDX_SCA4 | /dev/rndmis_4g_203 | 18 | 0 | 625.00 | 1.00 | 13 | 0 | 0 | 0.00 |
IDX_SCA4 | /dev/rndmis_4g_221 | 20 | 0 | 511.00 | 1.00 | 17 | 0 | 0 | 0.00 |
IDX_SCA5 | /dev/rndmis_4g_204 | 21 | 0 | 534.76 | 1.00 | 14 | 0 | 0 | 0.00 |
IDX_SCA5 | /dev/rndmis_4g_222 | 20 | 0 | 628.00 | 1.00 | 17 | 0 | 0 | 0.00 |
IDX_SCA6 | /dev/rndmis_4g_205 | 36 | 0 | 658.06 | 1.00 | 16 | 0 | 1 | 0.00 |
IDX_SCA6 | /dev/rndmis_4g_223 | 16 | 0 | 522.50 | 1.00 | 14 | 0 | 0 | 0.00 |
IDX_SCA7 | /dev/rndmis_8g_011 | 501 | 0 | 1026.77 | 1.00 | 441 | 0 | 5 | 10.00 |
IDX_SCA7 | /dev/rndmis_8g_034 | 149 | 0 | 782.01 | 1.00 | 125 | 0 | 2 | 0.00 |
IDX_SG | /dev/rndmis_4g_010 | 597 | 0 | 527.69 | 1.00 | 1,051 | 1 | 4,170 | 898.14 |
IDX_WF | /dev/rndmis_4g_006 | 2,182 | 1 | 483.62 | 1.00 | 2,428 | 1 | 188,927 | 991.19 |
IDX_WF | /dev/rndmis_4g_042 | 827 | 0 | 333.48 | 1.00 | 1,103 | 1 | 4,987 | 836.39 |
IDX_YP | /dev/rndmis_4g_008 | 0 | 0 | 5 | 0 | 0 | 0.00 | ||
LOB_SCA | /dev/rndmis_8g_001 | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_002 | 1 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_003 | 1 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_004 | 1 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_005 | 1 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_006 | 16 | 0 | 9.38 | 1.00 | 0 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_017 | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_026 | 4 | 0 | 975.00 | 1.00 | 7 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_028 | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_029 | 1 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_039 | 1 | 0 | 680.00 | 1.00 | 2 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_040 | 5 | 0 | 444.00 | 1.00 | 9 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_063 | 1 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_064 | 1 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | 0.00 |
SYSAUX | /dev/rndmis_4g_225 | 101 | 0 | 66.14 | 1.00 | 69 | 0 | 0 | 0.00 |
SYSAUX | /dev/rsysaux_4g | 717 | 0 | 239.09 | 1.05 | 472 | 0 | 0 | 0.00 |
SYSTEM | /dev/rsystem_4g | 2,401 | 1 | 14.48 | 1.22 | 73 | 0 | 103 | 186.02 |
TEMP | /dev/rndmis_8g_056 | 134 | 0 | 89.78 | 1.00 | 3,027 | 2 | 0 | |
TEMP | /dev/rtemp01_16g | 279 | 0 | 4.77 | 17.34 | 268 | 0 | 0 | |
TEMP | /dev/rtemp02_16g | 2,062 | 1 | 11.81 | 7.04 | 644 | 0 | 0 | |
UNDOTBS1 | /dev/rndmis_8g_030 | 123 | 0 | 1122.68 | 1.00 | 79 | 0 | 86 | 136.74 |
UNDOTBS1 | /dev/rndmis_8g_031 | 51 | 0 | 1147.45 | 1.00 | 50 | 0 | 7 | 0.00 |
UNDOTBS1 | /dev/rndmis_8g_036 | 57 | 0 | 1126.32 | 1.00 | 44 | 0 | 132 | 464.92 |
UNDOTBS1 | /dev/rundo_1a_16g | 249 | 0 | 1634.50 | 1.00 | 224 | 0 | 2,198 | 873.57 |
UNDOTBS1 | /dev/rundo_1b_16g | 333 | 0 | 1669.34 | 1.00 | 277 | 0 | 15,006 | 972.45 |
UNDOTBS2 | /dev/rndmis_8g_032 | 7 | 0 | 45.71 | 1.00 | 67 | 0 | 1 | 110.00 |
UNDOTBS2 | /dev/rndmis_8g_033 | 3 | 0 | 3.33 | 1.00 | 35 | 0 | 54 | 5.74 |
UNDOTBS2 | /dev/rndmis_8g_037 | 9 | 0 | 317.78 | 1.00 | 116 | 0 | 50 | 5.80 |
UNDOTBS2 | /dev/rundo_2a_16g | 11 | 0 | 4.55 | 1.00 | 524 | 0 | 143 | 4.20 |
UNDOTBS2 | /dev/rundo_2b_16g | 10 | 0 | 4.00 | 1.00 | 563 | 0 | 123 | 5.45 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 2,727,688 | 99 | 65,774,966 | 394,536 | 44,842 | 0 | 0 | 307,134 |
Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual Redo Blks | Target Redo Blks | Log File Size Redo Blks | Log Ckpt Timeout Redo Blks | Log Ckpt Interval Redo Blks | |
---|---|---|---|---|---|---|---|---|
B | 0 | 12 | 16550 | 81274 | 578222 | 5640120 | 578222 | |
E | 0 | 5 | 2684 | 16954 | 420866 | 5640120 | 420866 |
P | Size for Est (M) | Size Factor | Buffers for Estimate | Est Phys Read Factor | Estimated Physical Reads |
---|---|---|---|---|---|
D | 2,272 | 0.10 | 272,214 | 3.08 | 11,307,090,167 |
D | 4,544 | 0.20 | 544,428 | 2.60 | 9,567,465,313 |
D | 6,816 | 0.30 | 816,642 | 2.22 | 8,139,226,115 |
D | 9,088 | 0.40 | 1,088,856 | 1.91 | 7,007,409,758 |
D | 11,360 | 0.50 | 1,361,070 | 1.66 | 6,111,543,229 |
D | 13,632 | 0.60 | 1,633,284 | 1.47 | 5,398,329,247 |
D | 15,904 | 0.70 | 1,905,498 | 1.31 | 4,827,509,321 |
D | 18,176 | 0.80 | 2,177,712 | 1.19 | 4,367,482,167 |
D | 20,448 | 0.90 | 2,449,926 | 1.09 | 3,993,119,342 |
D | 22,720 | 1.00 | 2,722,140 | 1.00 | 3,684,608,225 |
D | 22,816 | 1.00 | 2,733,642 | 1.00 | 3,673,704,092 |
D | 24,992 | 1.10 | 2,994,354 | 0.93 | 3,426,541,211 |
D | 27,264 | 1.20 | 3,266,568 | 0.87 | 3,207,133,245 |
D | 29,536 | 1.29 | 3,538,782 | 0.82 | 3,017,134,867 |
D | 31,808 | 1.39 | 3,810,996 | 0.78 | 2,849,362,470 |
D | 34,080 | 1.49 | 4,083,210 | 0.73 | 2,698,136,838 |
D | 36,352 | 1.59 | 4,355,424 | 0.70 | 2,558,852,241 |
D | 38,624 | 1.69 | 4,627,638 | 0.66 | 2,427,841,083 |
D | 40,896 | 1.79 | 4,899,852 | 0.63 | 2,302,256,044 |
D | 43,168 | 1.89 | 5,172,066 | 0.59 | 2,179,869,119 |
D | 45,440 | 1.99 | 5,444,280 | 0.56 | 2,058,936,536 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
98.37 | 10,253 | 170 |
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 Mem | Global Mem Bound(K) | |
---|---|---|---|---|---|---|---|---|
B | 6,144 | 1,817 | 5,099.21 | 1.12 | 0.02 | 100.00 | 0.00 | 629,140 |
E | 6,144 | 4,953 | 764.34 | 0.00 | 0.00 | 0.00 | 0.00 | 629,140 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 72,508 | 72,508 | 0 | 0 |
64K | 128K | 2,294 | 2,294 | 0 | 0 |
128K | 256K | 1,197 | 1,197 | 0 | 0 |
256K | 512K | 1,526 | 1,526 | 0 | 0 |
512K | 1024K | 9,865 | 9,865 | 0 | 0 |
1M | 2M | 228 | 228 | 0 | 0 |
2M | 4M | 169 | 169 | 0 | 0 |
4M | 8M | 25 | 1 | 24 | 0 |
8M | 16M | 11 | 11 | 0 | 0 |
16M | 32M | 2 | 2 | 0 | 0 |
32M | 64M | 1 | 1 | 0 | 0 |
64M | 128M | 5 | 5 | 0 | 0 |
PGA Target Est (MB) | Size Factr | W/A MB Processed | Estd Extra W/A MB Read/ Written to Disk | Estd PGA Cache Hit % | Estd PGA Overalloc Count |
---|---|---|---|---|---|
768 | 0.13 | 63,377,508.94 | 39,987,424.18 | 61.00 | 671,343 |
1,536 | 0.25 | 63,377,508.94 | 39,476,610.13 | 62.00 | 658,173 |
3,072 | 0.50 | 63,377,508.94 | 24,420,852.20 | 72.00 | 343,910 |
4,608 | 0.75 | 63,377,508.94 | 7,954,266.78 | 89.00 | 35,367 |
6,144 | 1.00 | 63,377,508.94 | 2,970,528.89 | 96.00 | 2,384 |
7,373 | 1.20 | 63,377,508.94 | 2,778,555.77 | 96.00 | 2,187 |
8,602 | 1.40 | 63,377,508.94 | 2,778,457.02 | 96.00 | 2,026 |
9,830 | 1.60 | 63,377,508.94 | 2,778,457.02 | 96.00 | 1,790 |
11,059 | 1.80 | 63,377,508.94 | 2,778,432.25 | 96.00 | 1,470 |
12,288 | 2.00 | 63,377,508.94 | 2,778,421.43 | 96.00 | 1,308 |
18,432 | 3.00 | 63,377,508.94 | 2,778,358.20 | 96.00 | 859 |
24,576 | 4.00 | 63,377,508.94 | 2,778,176.08 | 96.00 | 79 |
36,864 | 6.00 | 63,377,508.94 | 2,777,546.25 | 96.00 | 0 |
49,152 | 8.00 | 63,377,508.94 | 2,777,546.25 | 96.00 | 0 |
Shared Pool Size(M) | SP Size Factr | Est LC Size (M) | Est LC Mem Obj | Est LC Time Saved (s) | Est LC Time Saved Factr | Est LC Load Time (s) | Est LC Load Time Factr | Est LC Mem Obj Hits (K) |
---|---|---|---|---|---|---|---|---|
2,576 | 0.69 | 442 | 30,749 | 104,824,926 | 1.00 | 776,544 | 1.12 | 2,319,222 |
2,960 | 0.79 | 817 | 52,672 | 104,853,193 | 1.00 | 748,277 | 1.08 | 2,327,767 |
3,344 | 0.90 | 1,199 | 77,962 | 104,881,067 | 1.00 | 720,403 | 1.04 | 2,336,294 |
3,728 | 1.00 | 1,581 | 102,098 | 104,908,650 | 1.00 | 692,820 | 1.00 | 2,344,795 |
4,112 | 1.10 | 1,964 | 125,952 | 104,935,850 | 1.00 | 665,620 | 0.96 | 2,353,258 |
4,496 | 1.21 | 2,347 | 153,844 | 104,962,627 | 1.00 | 638,843 | 0.92 | 2,361,675 |
4,880 | 1.31 | 2,730 | 180,789 | 104,989,000 | 1.00 | 612,470 | 0.88 | 2,370,047 |
5,264 | 1.41 | 3,112 | 206,341 | 105,014,976 | 1.00 | 586,494 | 0.85 | 2,378,369 |
5,648 | 1.52 | 3,495 | 234,613 | 105,040,544 | 1.00 | 560,926 | 0.81 | 2,386,639 |
6,032 | 1.62 | 3,878 | 264,980 | 105,065,790 | 1.00 | 535,680 | 0.77 | 2,394,865 |
6,416 | 1.72 | 4,261 | 291,139 | 105,090,770 | 1.00 | 510,700 | 0.74 | 2,403,055 |
6,800 | 1.82 | 4,644 | 319,035 | 105,115,518 | 1.00 | 485,952 | 0.70 | 2,411,213 |
7,184 | 1.93 | 5,027 | 347,073 | 105,140,070 | 1.00 | 461,400 | 0.67 | 2,419,343 |
7,568 | 2.03 | 5,410 | 376,311 | 105,164,456 | 1.00 | 437,014 | 0.63 | 2,427,449 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
6,656 | 0.25 | 38,577,806 | 12,122,830,189 |
13,312 | 0.50 | 26,657,934 | 7,512,708,790 |
19,968 | 0.75 | 19,497,564 | 4,682,493,215 |
26,624 | 1.00 | 16,895,636 | 3,673,696,230 |
33,280 | 1.25 | 15,298,998 | 3,055,045,785 |
39,936 | 1.50 | 14,520,110 | 2,743,516,345 |
46,592 | 1.75 | 14,337,637 | 2,602,813,779 |
53,248 | 2.00 | 14,334,258 | 2,207,524,065 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
16 | 1.00 | 0 | 0 | 0 | 0 |
32 | 2.00 | 0 | 0 | 0 | 0 |
48 | 3.00 | 0 | 0 | 0 | 0 |
64 | 4.00 | 0 | 0 | 0 | 0 |
80 | 5.00 | 0 | 0 | 0 | 0 |
96 | 6.00 | 0 | 0 | 0 | 0 |
112 | 7.00 | 0 | 0 | 0 | 0 |
128 | 8.00 | 0 | 0 | 0 | 0 |
144 | 9.00 | 0 | 0 | 0 | 0 |
160 | 10.00 | 0 | 0 | 0 | 0 |
176 | 11.00 | 0 | 0 | 0 | 0 |
192 | 12.00 | 0 | 0 | 0 | 0 |
208 | 13.00 | 0 | 0 | 0 | 0 |
224 | 14.00 | 0 | 0 | 0 | 0 |
240 | 15.00 | 0 | 0 | 0 | 0 |
256 | 16.00 | 0 | 0 | 0 | 0 |
272 | 17.00 | 0 | 0 | 0 | 0 |
288 | 18.00 | 0 | 0 | 0 | 0 |
304 | 19.00 | 0 | 0 | 0 | 0 |
320 | 20.00 | 0 | 0 | 0 | 0 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 288,768 | 269,363 | 933 |
undo block | 15,508 | 14,633 | 944 |
undo header | 2,314 | 1,953 | 844 |
1st level bmb | 133 | 36 | 267 |
2nd level bmb | 90 | 9 | 105 |
segment header | 32 | 2 | 75 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
TX-Transaction (row lock contention) | 742 | 696 | 3 | 711 | 12,498 | 17,578.44 |
US-Undo Segment | 15,114 | 15,106 | 0 | 14,950 | 11,809 | 789.90 |
CF-Controlfile Transaction | 18,139 | 18,127 | 12 | 43 | 2,800 | 65,110.47 |
JS-Job Scheduler (job recov lock) | 1 | 1 | 0 | 1 | 905 | 905,200.00 |
IR-Instance Recovery | 2 | 2 | 0 | 2 | 824 | 411,921.00 |
TX-Transaction (index contention) | 218 | 206 | 0 | 205 | 775 | 3,781.79 |
TH-Threshold Chain (metric threshold evaluation) | 11 | 11 | 0 | 2 | 268 | 134,243.50 |
HW-Segment High Water Mark | 1,489 | 1,488 | 1 | 443 | 98 | 220.76 |
TQ-Queue table enqueue (INI contention) | 24 | 24 | 0 | 2 | 7 | 3,593.50 |
TT-Tablespace | 1,762 | 1,762 | 0 | 96 | 6 | 65.45 |
WF-AWR Flush | 30 | 30 | 0 | 14 | 3 | 197.36 |
TO-Temp Object | 313 | 313 | 0 | 40 | 3 | 66.95 |
TM-DML | 20,146 | 20,143 | 0 | 683 | 1 | 2.02 |
PS-PX Process Reservation | 675 | 673 | 2 | 96 | 1 | 13.72 |
TX-Transaction | 12,930 | 12,929 | 1 | 356 | 1 | 2.76 |
SQ-Sequence Cache | 43 | 43 | 0 | 17 | 0 | 24.12 |
PR-Process Startup | 147 | 147 | 0 | 4 | 0 | 75.25 |
FB-Format Block | 48 | 48 | 0 | 29 | 0 | 3.83 |
RT-Redo Thread | 2 | 2 | 0 | 2 | 0 | 5.00 |
JQ-Job Queue | 4 | 1 | 3 | 1 | 0 | 2.00 |
PG-Global Parameter | 2 | 2 | 0 | 1 | 0 | 1.00 |
PW-Buffer Cache PreWarm (flush prewarm buffers) | 1 | 0 | 1 | 1 | 0 | 1.00 |
TX-Transaction (allocate ITL entry) | 1 | 1 | 0 | 1 | 0 | 1.00 |
TA-Instance Undo | 4 | 4 | 0 | 3 | 0 | 0.00 |
PE-Parameter | 4 | 4 | 0 | 1 | 0 | 0.00 |
Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
4 | 6.44 | 14,898 | 609 | 121 | 0/11340.8 | 0/0 | 0/0/0/0/0/0 |
End Time | Num Undo Blocks | Number of Transactions | Max Qry Len (s) | Max Tx Concy | Tun Ret (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
27-Mar 16:56 | 0 | 0 | 0 | 0 | 0 | 0/0 | 0/0/0/0/0/0 |
27-Mar 16:46 | 3,121 | 6,081 | 609 | 85 | 11,341 | 0/0 | 0/0/0/0/0/0 |
27-Mar 16:36 | 3,322 | 8,817 | 304 | 121 | 11,328 | 0/0 | 0/0/0/0/0/0 |
Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
---|---|---|---|---|---|---|
ASM db client latch | 1,154 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 28,285 | 0.00 | 0 | 0 | ||
Consistent RBA | 8,552 | 0.01 | 0.00 | 0 | 0 | |
FAL request queue | 22 | 0.00 | 0 | 0 | ||
FAL subheap alocation | 22 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 4 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 65,553 | 1.67 | 0.31 | 80 | 0 | |
JS broadcast add buf latch | 175 | 0.00 | 0 | 0 | ||
JS broadcast drop buf latch | 175 | 0.00 | 0 | 0 | ||
JS broadcast load blnc latch | 150 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 2 | 0.00 | 0 | 0 | ||
JS queue access latch | 2 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 6,300 | 0.00 | 0 | 0 | ||
KCL gc element parent latch | 6,604,679 | 0.10 | 2.10 | 3150 | 69,698 | 0.04 |
KJC destination ctx free list | 51 | 0.00 | 0 | 0 | ||
KJC message pool free list | 71,688 | 1.47 | 1.11 | 104 | 13,389 | 3.02 |
KJCT flow control latch | 982,542 | 0.01 | 0.00 | 0 | 0 | |
KMG MMAN ready and startup request latch | 367 | 0.00 | 0 | 0 | ||
KMG resize request state object freelist | 2 | 0.00 | 0 | 0 | ||
KSXR large replies | 4 | 0.00 | 0 | 0 | ||
KTF sga latch | 13,332 | 0.00 | 0 | 279 | 0.36 | |
KWQMN job cache list latch | 243 | 0.00 | 0 | 0 | ||
KWQMN to-be-Stopped Buffer list Latch | 1 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 2 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 17 | 0.00 | ||
Memory Management Latch | 23 | 0.00 | 0 | 366 | 0.00 | |
OS process | 16,638 | 0.00 | 0 | 0 | ||
OS process allocation | 10,174 | 3.71 | 16.74 | 1788 | 0 | |
OS process: request allocation | 8,970 | 1.63 | 2.47 | 84 | 0 | |
PL/SQL warning settings | 16,577 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 13,004 | 0.26 | 4.26 | 36 | 13,005 | 2.11 |
SQL memory manager latch | 42 | 52.38 | 0.73 | 0 | 310 | 0.00 |
SQL memory manager workarea list latch | 132,923 | 0.02 | 0.00 | 0 | 0 | |
Shared B-Tree | 37 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 14,192 | 0.44 | 0.03 | 0 | 0 | |
active service list | 17,694 | 2.72 | 0.21 | 0 | 6,831 | 0.04 |
archive control | 25 | 0.00 | 0 | 0 | ||
archive process latch | 360 | 0.00 | 0 | 0 | ||
begin backup scn array | 883 | 0.00 | 0 | 0 | ||
buffer pool | 1 | 0.00 | 0 | 0 | ||
business card | 36 | 0.00 | 0 | 0 | ||
cache buffer handles | 66,048 | 0.08 | 0.75 | 0 | 0 | |
cache buffers chains | 117,545,179 | 1.87 | 0.01 | 2413 | 1,738,919 | 0.99 |
cache buffers lru chain | 688,613 | 0.18 | 0.87 | 164 | 1,229,156 | 0.38 |
cache table scan latch | 0 | 0 | 19,158 | 0.10 | ||
channel handle pool latch | 7,878 | 4.82 | 5.33 | 566 | 0 | |
channel operations parent latch | 1,329,106 | 0.00 | 0.00 | 0 | 0 | |
checkpoint queue latch | 451,157 | 0.02 | 0.86 | 6 | 35,821 | 0.02 |
client/application info | 18,468 | 0.04 | 0.00 | 0 | 0 | |
commit callback allocation | 184 | 0.00 | 0 | 0 | ||
compile environment latch | 2,964 | 0.00 | 0 | 0 | ||
database property service latch | 3 | 0.00 | 0 | 0 | ||
dml lock allocation | 40,405 | 0.27 | 0.00 | 0 | 0 | |
dummy allocation | 7,495 | 2.87 | 1.70 | 79 | 0 | |
enqueue hash chains | 404,318 | 0.62 | 0.05 | 7 | 52,079 | 0.03 |
enqueues | 622,994 | 0.39 | 0.00 | 0 | 0 | |
error message lists | 352 | 3.41 | 0.00 | 0 | 0 | |
event group latch | 3,718 | 0.11 | 0.00 | 0 | 0 | |
file cache latch | 1,697 | 0.00 | 0 | 0 | ||
gcs domain validate latch | 203 | 0.00 | 0 | 0 | ||
gcs drop object freelist | 1 | 0.00 | 0 | 0 | ||
gcs opaque info freelist | 380,980 | 0.13 | 0.00 | 0 | 0 | |
gcs partitioned table hash | 22,724,309 | 0.00 | 0 | 88,805 | 0.00 | |
gcs remastering latch | 982,771 | 0.00 | 0.00 | 0 | 412 | 0.00 |
gcs resource freelist | 3,303,939 | 0.00 | 0.00 | 0 | 100,257 | 0.00 |
gcs resource hash | 9,580,556 | 0.12 | 0.58 | 1522 | 52 | 0.00 |
gcs resource scan list | 104 | 0.00 | 0 | 0 | ||
gcs resource validate list | 460,534 | 0.09 | 0.08 | 0 | 0 | |
gcs shadows freelist | 1,596,083 | 0.00 | 0.00 | 0 | 189,616 | 0.00 |
generalized trace enabling latch | 1 | 0.00 | 0 | 0 | ||
ges caches resource lists | 100,692 | 0.25 | 1.20 | 72 | 71,542 | 0.17 |
ges deadlock list | 6,562 | 0.06 | 0.00 | 0 | 694 | 0.00 |
ges domain table | 277,620 | 0.00 | 0.20 | 0 | 0 | |
ges enqueue table freelist | 354,571 | 0.01 | 0.31 | 3 | 0 | |
ges group table | 389,333 | 0.02 | 0.00 | 0 | 0 | |
ges process hash list | 73,278 | 0.00 | 0 | 0 | ||
ges process parent latch | 768,281 | 0.00 | 0.48 | 3 | 0 | |
ges process table freelist | 7,882 | 1.10 | 2.39 | 51 | 0 | |
ges resource hash list | 1,307,440 | 0.74 | 0.11 | 141 | 202,898 | 0.01 |
ges resource scan list | 30,929 | 0.38 | 0.00 | 0 | 0 | |
ges resource table freelist | 107,817 | 0.03 | 0.68 | 4 | 0 | |
ges synchronous data | 41 | 2.44 | 0.00 | 0 | 5,058 | 0.02 |
ges timeout list | 36,143 | 0.02 | 0.00 | 0 | 135,754 | 0.00 |
global KZLD latch for mem in SGA | 2,479 | 0.00 | 0 | 0 | ||
global hanganlyze operation | 89 | 0.00 | 0 | 0 | ||
global tx hash mapping | 35,114 | 0.00 | 0 | 15 | 0.00 | |
hash table column usage latch | 1,299 | 0.15 | 0.00 | 0 | 390,314 | 0.00 |
hash table modification latch | 126 | 0.00 | 0 | 0 | ||
internal temp table object number allocation latc | 5 | 0.00 | 0 | 0 | ||
interrupt manipulation | 721 | 3.19 | 0.00 | 0 | 0 | |
intra txn parallel recovery | 5,897 | 0.27 | 0.00 | 0 | 0 | |
job workq parent latch | 0 | 0 | 2 | 0.00 | ||
job_queue_processes parameter latch | 13 | 0.00 | 0 | 0 | ||
kks stats | 91,352 | 2.11 | 3.27 | 1525 | 0 | |
kokc descriptor allocation latch | 172,732 | 0.00 | 0 | 0 | ||
ksuosstats global area | 47 | 0.00 | 0 | 0 | ||
ktm global data | 19 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 36 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 8,574 | 0.06 | 0.00 | 0 | 0 | |
library cache | 2,722,513 | 1.22 | 9.35 | 87777 | 83,327 | 3.67 |
library cache load lock | 9,195 | 0.29 | 0.00 | 0 | 99 | 0.00 |
library cache lock | 5,131,156 | 0.29 | 0.40 | 1641 | 0 | |
library cache lock allocation | 34,956 | 0.13 | 0.76 | 1 | 0 | |
library cache pin | 733,600 | 0.35 | 0.00 | 0 | 141 | 0.00 |
library cache pin allocation | 15,925 | 0.00 | 0 | 0 | ||
list of block allocation | 2,809 | 0.04 | 29.00 | 8 | 0 | |
loader state object freelist | 2,768 | 0.04 | 0.00 | 0 | 0 | |
logminer context allocation | 1 | 0.00 | 0 | 0 | ||
longop free list parent | 6,411 | 0.00 | 0 | 95 | 0.00 | |
message pool operations parent latch | 237 | 0.00 | 0 | 0 | ||
messages | 271,952 | 0.12 | 0.43 | 28 | 0 | |
mostly latch-free SCN | 9,084 | 4.91 | 0.00 | 0 | 0 | |
multiblock read objects | 99,441 | 0.06 | 1.69 | 25 | 0 | |
name-service memory objects | 5,073 | 0.02 | 0.00 | 0 | 6 | 16.67 |
name-service namespace bucket | 20,869 | 0.00 | 0 | 0 | ||
name-service namespace objects | 8 | 0.00 | 0 | 0 | ||
name-service pending queue | 2,718 | 0.00 | 0 | 0 | ||
name-service request | 264 | 0.00 | 0 | 0 | ||
name-service request queue | 21,273 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 199 | 0.00 | 0 | 0 | ||
object queue header heap | 16,515 | 0.01 | 0.00 | 0 | 14,697 | 0.01 |
object queue header operation | 1,650,747 | 0.11 | 0.79 | 164 | 1,916 | 0.84 |
object stats modification | 60 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 1,989 | 7.29 | 0.74 | 1 | 0 | |
parallel query stats | 206 | 1.46 | 0.00 | 0 | 0 | |
parallel txn reco latch | 8,353 | 0.06 | 0.00 | 0 | 0 | |
parameter list | 23,989 | 2.44 | 0.00 | 0 | 0 | |
parameter table management | 7,583 | 0.04 | 1.00 | 0 | 0 | |
post/wait queue | 153,002 | 0.04 | 0.00 | 0 | 72,598 | 0.03 |
process allocation | 23,402 | 3.08 | 606.74 | 4355 | 3,361 | 10.62 |
process group creation | 7,892 | 0.29 | 0.00 | 0 | 0 | |
process queue | 9,431 | 0.00 | 0 | 0 | ||
process queue reference | 822,215 | 0.05 | 0.00 | 0 | 14,927 | 1.92 |
qmn state object latch | 4 | 0.00 | 0 | 0 | ||
qmn task queue latch | 233 | 17.17 | 0.00 | 0 | 0 | |
query server freelists | 843 | 1.54 | 0.00 | 0 | 0 | |
query server process | 130 | 2.31 | 4.67 | 3 | 1 | 0.00 |
queued dump request | 7,422 | 0.00 | 0 | 0 | ||
redo allocation | 43,714 | 0.29 | 1.43 | 26 | 129,360 | 1.01 |
redo copy | 0 | 0 | 129,610 | 1.98 | ||
redo writing | 41,088 | 0.09 | 5.16 | 55 | 0 | |
reg$ timeout service time | 1 | 0.00 | 0 | 0 | ||
resmgr group change latch | 2,658 | 0.00 | 0 | 0 | ||
resmgr:active threads | 7,484 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 2,641 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 7,483 | 2.29 | 1.25 | 59 | 0 | |
resmgr:resource group CPU method | 1,746 | 0.11 | 0.00 | 0 | 0 | |
resmgr:schema config | 1 | 0.00 | 0 | 0 | ||
row cache objects | 5,337,337 | 3.69 | 0.17 | 9224 | 19,091 | 5.39 |
rules engine aggregate statistics | 28 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 156 | 0.00 | 0 | 0 | ||
sequence cache | 13,343 | 6.98 | 0.00 | 0 | 0 | |
session allocation | 881,511 | 0.67 | 5.52 | 15447 | 0 | |
session idle bit | 3,189,928 | 0.00 | 0.01 | 0 | 0 | |
session state list latch | 6,404 | 8.57 | 0.00 | 0 | 0 | |
session switching | 27,961 | 0.23 | 51.63 | 965 | 0 | |
session timer | 916 | 0.00 | 0 | 0 | ||
shared pool | 1,274,319 | 1.36 | 6.26 | 30680 | 0 | |
shared pool simulator | 110,770 | 0.12 | 6.00 | 213 | 0 | |
simulator hash latch | 3,419,806 | 0.00 | 0.89 | 10 | 0 | |
simulator lru latch | 291 | 0.69 | 2.00 | 1 | 3,387,309 | 2.70 |
slave class | 5 | 0.00 | 0 | 0 | ||
slave class create | 22 | 4.55 | 1.00 | 0 | 0 | |
sort extent pool | 3,819 | 0.55 | 4.81 | 21 | 0 | |
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 983 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 363 | 0.00 | 0 | 0 | ||
temporary table state object allocation | 314 | 0.00 | 0 | 0 | ||
threshold alerts latch | 586 | 0.00 | 0 | 0 | ||
trace latch | 857 | 16.69 | 8.87 | 360 | 0 | |
transaction allocation | 8,994 | 0.00 | 0 | 0 | ||
transaction branch allocation | 33,129 | 0.02 | 0.00 | 0 | 0 | |
undo global data | 239,586 | 0.17 | 0.00 | 0 | 33 | 0.00 |
user lock | 13,644 | 20.88 | 20.47 | 38325 | 0 |
Latch Name | Get Requests | Misses | Sleeps | Spin Gets | Sleep1 | Sleep2 | Sleep3 |
---|---|---|---|---|---|---|---|
cache buffers chains | 117,545,179 | 2,197,268 | 27,063 | 2,179,209 | 0 | 0 | 0 |
row cache objects | 5,337,337 | 196,719 | 33,396 | 194,303 | 0 | 0 | 0 |
library cache | 2,722,513 | 33,104 | 309,504 | 14,358 | 0 | 0 | 0 |
shared pool | 1,274,319 | 17,351 | 108,663 | 5,853 | 0 | 0 | 0 |
library cache lock | 5,131,156 | 14,731 | 5,881 | 14,224 | 0 | 0 | 0 |
gcs resource hash | 9,580,556 | 11,419 | 6,647 | 9,252 | 0 | 0 | 0 |
ges resource hash list | 1,307,440 | 9,657 | 1,089 | 8,915 | 0 | 0 | 0 |
KCL gc element parent latch | 6,604,679 | 6,671 | 13,976 | 1,923 | 0 | 0 | 0 |
session allocation | 881,511 | 5,924 | 32,703 | 3,512 | 0 | 0 | 0 |
user lock | 13,644 | 2,849 | 58,323 | 533 | 0 | 0 | 0 |
library cache pin | 733,600 | 2,586 | 1 | 2,585 | 0 | 0 | 0 |
enqueue hash chains | 404,318 | 2,496 | 115 | 2,385 | 0 | 0 | 0 |
enqueues | 622,994 | 2,452 | 8 | 2,444 | 0 | 0 | 0 |
kks stats | 91,352 | 1,925 | 6,299 | 262 | 0 | 0 | 0 |
object queue header operation | 1,650,747 | 1,858 | 1,469 | 1,083 | 0 | 0 | 0 |
cache buffers lru chain | 688,613 | 1,266 | 1,100 | 675 | 0 | 0 | 0 |
FOB s.o list latch | 65,553 | 1,093 | 339 | 1,007 | 0 | 0 | 0 |
KJC message pool free list | 71,688 | 1,056 | 1,171 | 186 | 0 | 0 | 0 |
process allocation | 23,402 | 720 | 436,850 | 43 | 0 | 0 | 0 |
session state list latch | 6,404 | 549 | 2 | 547 | 0 | 0 | 0 |
active service list | 17,694 | 481 | 101 | 384 | 0 | 0 | 0 |
gcs resource validate list | 460,534 | 398 | 30 | 368 | 0 | 0 | 0 |
channel handle pool latch | 7,878 | 380 | 2,024 | 58 | 0 | 0 | 0 |
OS process allocation | 10,174 | 377 | 6,310 | 21 | 0 | 0 | 0 |
messages | 271,952 | 329 | 142 | 275 | 0 | 0 | 0 |
ges caches resource lists | 100,692 | 252 | 302 | 162 | 0 | 0 | 0 |
dummy allocation | 7,495 | 215 | 365 | 109 | 0 | 0 | 0 |
resmgr:free threads list | 7,483 | 171 | 214 | 156 | 0 | 0 | 0 |
OS process: request allocation | 8,970 | 146 | 361 | 28 | 0 | 0 | 0 |
parallel query alloc buffer | 1,989 | 145 | 107 | 41 | 0 | 0 | 0 |
session idle bit | 3,189,928 | 143 | 1 | 142 | 0 | 0 | 0 |
trace latch | 857 | 143 | 1,269 | 78 | 0 | 0 | 0 |
shared pool simulator | 110,770 | 138 | 828 | 17 | 0 | 0 | 0 |
redo allocation | 43,714 | 127 | 181 | 25 | 0 | 0 | 0 |
checkpoint queue latch | 451,157 | 98 | 84 | 31 | 0 | 0 | 0 |
ges process table freelist | 7,882 | 87 | 208 | 41 | 0 | 0 | 0 |
session switching | 27,961 | 65 | 3,356 | 11 | 0 | 0 | 0 |
active checkpoint queue latch | 14,192 | 63 | 2 | 62 | 0 | 0 | 0 |
multiblock read objects | 99,441 | 58 | 98 | 39 | 0 | 0 | 0 |
cache buffer handles | 66,048 | 55 | 41 | 14 | 0 | 0 | 0 |
simulator hash latch | 3,419,806 | 46 | 41 | 37 | 0 | 0 | 0 |
ges enqueue table freelist | 354,571 | 45 | 14 | 39 | 0 | 0 | 0 |
library cache lock allocation | 34,956 | 45 | 34 | 11 | 0 | 0 | 0 |
redo writing | 41,088 | 38 | 196 | 22 | 0 | 0 | 0 |
SGA IO buffer pool latch | 13,004 | 34 | 145 | 5 | 0 | 0 | 0 |
ges resource table freelist | 107,817 | 28 | 19 | 22 | 0 | 0 | 0 |
ges process parent latch | 768,281 | 27 | 13 | 25 | 0 | 0 | 0 |
SQL memory manager latch | 42 | 22 | 16 | 6 | 0 | 0 | 0 |
sort extent pool | 3,819 | 21 | 101 | 12 | 0 | 0 | 0 |
ges domain table | 277,620 | 10 | 2 | 8 | 0 | 0 | 0 |
parameter table management | 7,583 | 3 | 3 | 0 | 0 | 0 | 0 |
query server process | 130 | 3 | 14 | 0 | 0 | 0 | 0 |
simulator lru latch | 291 | 2 | 4 | 0 | 0 | 0 | 0 |
list of block allocation | 2,809 | 1 | 29 | 0 | 0 | 0 | 0 |
slave class create | 22 | 1 | 1 | 0 | 0 | 0 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
FOB s.o list latch | ksfd_allfob | 0 | 227 | 272 |
FOB s.o list latch | ksfd_fobd | 0 | 112 | 67 |
KCL gc element parent latch | kclnfndnewm | 0 | 9,842 | 3,782 |
KCL gc element parent latch | kclrwrite | 0 | 1,481 | 1,201 |
KCL gc element parent latch | kclnfnd | 0 | 1,062 | 511 |
KCL gc element parent latch | kclfwrite1 | 0 | 526 | 213 |
KCL gc element parent latch | kclplz | 0 | 415 | 706 |
KCL gc element parent latch | kclgcr | 0 | 237 | 158 |
KCL gc element parent latch | kclbla | 0 | 209 | 118 |
KCL gc element parent latch | kclwrt | 0 | 130 | 35 |
KCL gc element parent latch | kclzcl | 0 | 86 | 88 |
KCL gc element parent latch | kcl_get_le_latch | 0 | 79 | 0 |
KCL gc element parent latch | kclnfndnew | 0 | 44 | 0 |
KCL gc element parent latch | kclulb | 0 | 42 | 6,449 |
KCL gc element parent latch | kcllwr | 0 | 40 | 3 |
KCL gc element parent latch | kclrbast | 0 | 7 | 0 |
KCL gc element parent latch | kclfwrite2 | 0 | 4 | 0 |
KCL gc element parent latch | kclpto_3 | 0 | 4 | 1 |
KCL gc element parent latch | KCLUNLNK | 0 | 3 | 714 |
KCL gc element parent latch | kclchkping | 0 | 1 | 0 |
KCL gc element parent latch | kclebs | 0 | 1 | 128 |
KCL gc element parent latch | kclexpand | 0 | 1 | 4 |
KCL gc element parent latch | kclgrantlk | 0 | 1 | 68 |
KCL gc element parent latch | kclrdone | 0 | 1 | 0 |
KJC message pool free list | kjcsmpav: allocate a msg buffer | 0 | 1,158 | 1,171 |
KJC message pool free list | kjcspfmbq: free vector of msg buffers | 0 | 13 | 0 |
OS process allocation | kso_new_process:2 | 0 | 6,302 | 6,215 |
OS process allocation | ksosp_scrub:1 | 0 | 4 | 89 |
OS process allocation | kso_delete_process:1 | 0 | 2 | 2 |
OS process: request allocation | kso_new_process | 0 | 324 | 330 |
OS process: request allocation | ksoreqholder_delete | 0 | 37 | 31 |
SGA IO buffer pool latch | ksfd_alloc_sgabuffer | 0 | 126 | 0 |
SGA IO buffer pool latch | ksfd_free_sgabuffer | 0 | 19 | 145 |
SQL memory manager latch | qesmmIQueryRefreshBound | 0 | 16 | 16 |
active checkpoint queue latch | kcbbacq: scan active checkpoints | 0 | 2 | 2 |
active service list | kswslogon: session login | 0 | 186 | 186 |
active service list | kswslogon: session logout | 0 | 105 | 98 |
cache buffer handles | kcbzgs | 0 | 41 | 41 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 47,522 | 50,612 |
cache buffers chains | kcbchg: kslbegin: bufs not pinned | 0 | 7,848 | 3,160 |
cache buffers chains | kcbzwb | 0 | 2,941 | 2,839 |
cache buffers chains | kcbrls: kslbegin | 0 | 2,702 | 5,305 |
cache buffers chains | kcbgtcr: fast path | 0 | 1,039 | 616 |
cache buffers chains | kclcls_3 | 0 | 913 | 18 |
cache buffers chains | kcbgtcr: kslbegin shared | 0 | 449 | 337 |
cache buffers chains | kcbget: pin buffer | 0 | 447 | 223 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 350 | 0 |
cache buffers chains | kcbzib: multi-block read: nowait | 0 | 155 | 0 |
cache buffers chains | kcbgcur: kslbegin | 0 | 115 | 110 |
cache buffers chains | kcbbxsv | 0 | 71 | 69 |
cache buffers chains | kclbla | 0 | 65 | 23 |
cache buffers chains | kcbbic1 | 0 | 53 | 1 |
cache buffers chains | kcbzib: finish free bufs | 0 | 49 | 34 |
cache buffers chains | kcbchg: kslbegin: call CR func | 0 | 39 | 1,105 |
cache buffers chains | kcbgtcr | 0 | 38 | 8 |
cache buffers chains | kclebs_1 | 0 | 35 | 27 |
cache buffers chains | kclwrt | 0 | 31 | 1 |
cache buffers chains | kcbnew: new latch again | 0 | 23 | 1 |
cache buffers chains | kcbgcur: buf pinned | 0 | 20 | 9 |
cache buffers chains | kclwcrs | 0 | 20 | 17 |
cache buffers chains | kcbso1: set no access | 0 | 19 | 14 |
cache buffers chains | kclgrantlk | 0 | 15 | 0 |
cache buffers chains | kclexpandlock | 0 | 9 | 5 |
cache buffers chains | kcbzhngcbk1: get hash chain latch no wait | 0 | 7 | 0 |
cache buffers chains | kcbsod1 | 0 | 5 | 12 |
cache buffers chains | kcbnlc | 0 | 4 | 97 |
cache buffers chains | kclgrantlk_1 | 0 | 3 | 0 |
cache buffers chains | kclswrite | 0 | 3 | 0 |
cache buffers chains | kcbesc: escalate | 0 | 2 | 1 |
cache buffers chains | kclclaim | 0 | 2 | 0 |
cache buffers chains | kcbibr | 0 | 1 | 0 |
cache buffers chains | kclpto_1 | 0 | 1 | 1 |
cache buffers lru chain | kcbzgb: wait - one set in buffer pool | 0 | 408 | 129 |
cache buffers lru chain | kcbzgws | 0 | 260 | 0 |
cache buffers lru chain | kcbbxsv: move to being written | 0 | 153 | 287 |
cache buffers lru chain | kcbo_link_q | 0 | 81 | 3 |
cache buffers lru chain | kclmvreqbg | 0 | 78 | 98 |
cache buffers lru chain | kcbbic2 | 0 | 27 | 142 |
cache buffers lru chain | H_MK_PI_CR_BG | 0 | 24 | 0 |
cache buffers lru chain | kcbzgb: posted for free bufs | 0 | 13 | 236 |
cache buffers lru chain | kcbw_quiesce_granule | 0 | 11 | 1 |
cache buffers lru chain | kcbzfw | 0 | 9 | 24 |
cache buffers lru chain | kcbibr | 0 | 8 | 31 |
cache buffers lru chain | kcbzib: move stale buffers | 0 | 8 | 53 |
cache buffers lru chain | kcbbwlru | 0 | 7 | 28 |
cache buffers lru chain | kclrecfree | 0 | 4 | 0 |
cache buffers lru chain | kcbgtcr:CR Scan:KCBRSKIP | 0 | 3 | 0 |
cache buffers lru chain | kclmvreq | 0 | 2 | 22 |
cache buffers lru chain | kcbo_ivd_proc | 0 | 1 | 39 |
cache buffers lru chain | kcbrenounce | 0 | 1 | 0 |
cache buffers lru chain | kcbzswcu | 0 | 1 | 0 |
cache buffers lru chain | kclmergepi | 0 | 1 | 0 |
channel handle pool latch | ksrchconnect() | 0 | 2,078 | 1,880 |
checkpoint queue latch | kcbkubc | 0 | 64 | 56 |
checkpoint queue latch | kclmergepi_3 | 0 | 15 | 1 |
checkpoint queue latch | kcbk_get_cqlt_nowait2 | 0 | 3 | 0 |
checkpoint queue latch | kcbbwthc: thread checkpoint buffers | 0 | 1 | 17 |
checkpoint queue latch | kcbkllrba: compute lowest lrba | 0 | 1 | 10 |
cost function | kzulgt: find user res | 0 | 104,525 | 56,654 |
cost function | kzulrl | 0 | 26,213 | 74,097 |
dummy allocation | ktcscnfy | 0 | 365 | 365 |
enqueue hash chains | ksqgtl3 | 0 | 105 | 111 |
enqueue hash chains | ksqrcl | 0 | 6 | 4 |
enqueue hash chains | ksqcmi: if lk mode requested | 0 | 3 | 0 |
enqueue hash chains | ksqcmi: if lk mode not requested | 0 | 1 | 0 |
enqueues | ksqies | 0 | 5 | 7 |
enqueues | ksqdel | 0 | 1 | 0 |
enqueues | ksqgel: create enqueue | 0 | 1 | 1 |
enqueues | ksqgtl2 | 0 | 1 | 0 |
event range base latch | No latch | 0 | 262 | 1,707 |
gcs resource hash | kjbmpclose | 0 | 2,766 | 81 |
gcs resource hash | kjbcropen | 0 | 1,046 | 977 |
gcs resource hash | kjblocalfile_nolock | 0 | 862 | 1,041 |
gcs resource hash | kclzcl | 0 | 646 | 270 |
gcs resource hash | kjbmpopen | 0 | 386 | 60 |
gcs resource hash | kjbcropen:affinity | 0 | 244 | 1,544 |
gcs resource hash | kclrwrite | 0 | 189 | 967 |
gcs resource hash | kjbcrconvert | 0 | 99 | 283 |
gcs resource hash | kjbassume | 0 | 90 | 247 |
gcs resource hash | kjbconvert | 0 | 53 | 491 |
gcs resource hash | kclgrantlk_1 | 0 | 42 | 43 |
gcs resource hash | kclfwrite1 | 0 | 39 | 249 |
gcs resource hash | kjbopen | 0 | 35 | 53 |
gcs resource hash | kjbmpwrite | 0 | 33 | 2 |
gcs resource hash | kjbcrcomplete | 0 | 31 | 87 |
gcs resource hash | kjbopen:affinity | 0 | 28 | 128 |
gcs resource hash | kjbmpconvert | 0 | 15 | 18 |
gcs resource hash | kjbrwrdone reget | 0 | 11 | 0 |
gcs resource hash | kclpdc | 0 | 10 | 34 |
gcs resource hash | kjbrrcfwst | 0 | 9 | 1 |
gcs resource hash | kjblpast | 0 | 4 | 1 |
gcs resource hash | kclcfusion | 0 | 2 | 0 |
gcs resource hash | kclrwrite_1 | 0 | 1 | 0 |
gcs resource hash | kclrwrite_3 | 0 | 1 | 0 |
gcs resource hash | kjblpbast | 0 | 1 | 30 |
gcs resource hash | kjblpwreq | 0 | 1 | 0 |
gcs resource hash | kjbmdowncvt | 0 | 1 | 0 |
gcs resource hash | kjbmpcreatepi | 0 | 1 | 0 |
gcs resource hash | kjbmpflushpi | 0 | 1 | 0 |
gcs resource validate list | enq res to validate list | 0 | 30 | 30 |
ges domain table | kjdmlad: add a lock to an xid-hashed lock list | 0 | 2 | 3 |
ges enqueue table freelist | kjlalc: lock allocation | 0 | 12 | 10 |
ges enqueue table freelist | kjlfr: remove lock from parent object | 0 | 2 | 4 |
ges process parent latch | kjlrem: detach lock from group | 0 | 13 | 0 |
ges process table freelist | kjpalc: process allocation | 0 | 208 | 208 |
ges resource hash list | kjrmas1: lookup master node | 0 | 647 | 51 |
ges resource hash list | kjucvl: lock convert request | 0 | 274 | 13 |
ges resource hash list | kjrref: find matched resource | 0 | 110 | 971 |
ges resource hash list | kjcvscn: remove from scan queue | 0 | 38 | 0 |
ges resource hash list | kjakcai: search for resp by resname | 0 | 10 | 5 |
ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 9 | 49 |
ges resource hash list | kjruch: move resource from cache to freelist | 0 | 1 | 0 |
ges resource table freelist | kjruch: cached obj cleanup | 0 | 231 | 0 |
ges resource table freelist | kjrm2c: move resource to cache | 0 | 61 | 302 |
ges resource table freelist | kjralc: resource allocation | 0 | 19 | 5 |
ges resource table freelist | kjrchc: cached obj cleanup | 0 | 10 | 0 |
kks stats | kks stats alloc/free | 0 | 6,296 | 6,293 |
library cache | kgldti: 2child | 0 | 85,875 | 3,022 |
library cache | kgldte: child 0 | 0 | 55,771 | 75,871 |
library cache | kglpin | 0 | 39,716 | 4,956 |
library cache | kglobpn: child: | 0 | 27,921 | 24,291 |
library cache | kglukp: child | 0 | 15,852 | 3,464 |
library cache | kglpndl: child: before processing | 0 | 13,276 | 21,454 |
library cache | kglati | 0 | 4,954 | 9 |
library cache | kglhdgn: child: | 0 | 4,553 | 86,524 |
library cache | kglpndl: child: after processing | 0 | 3,249 | 47 |
library cache | kglLockCursor | 0 | 2,722 | 12,825 |
library cache | kglpnp: child | 0 | 1,472 | 19,503 |
library cache | kgldtld: 2child | 0 | 174 | 531 |
library cache | kglhdbrnl: child | 0 | 45 | 4,875 |
library cache | kglrtl | 0 | 40 | 57 |
library cache | kglhdgc: child: | 0 | 32 | 19 |
library cache | kglobld | 0 | 24 | 76 |
library cache | kqlmbpil: parent | 0 | 17 | 24 |
library cache | kglini: child | 0 | 11 | 6 |
library cache | kglScanDependency | 0 | 6 | 0 |
library cache | kglic | 0 | 6 | 99 |
library cache | kglnti | 0 | 2 | 20 |
library cache lock | kgllkdl: child: no lock handle | 0 | 39,167 | 27,656 |
library cache lock | kgllkdl: child: cleanup | 0 | 4,871 | 1,855 |
library cache lock | kgllkal: child: multiinstance | 0 | 738 | 2,309 |
library cache lock | ksucallcbksafely: kqllhng | 0 | 6 | 0 |
library cache lock | kglget: un-set reserved lock | 0 | 4 | 0 |
library cache lock allocation | kgllkget | 0 | 33 | 31 |
library cache lock allocation | kgllkrel | 0 | 1 | 3 |
library cache pin | kglpnal: child: alloc space | 0 | 1 | 1 |
list of block allocation | ktcdod | 0 | 29 | 29 |
messages | ksaamb: after wakeup | 0 | 119 | 77 |
messages | ksarcv | 0 | 12 | 5 |
messages | ksarcv: after wait | 0 | 11 | 60 |
multiblock read objects | kcbzib: mbr get | 0 | 87 | 20 |
multiblock read objects | kcbzib: normal mbr free | 0 | 11 | 77 |
object queue header operation | kcbw_unlink_q | 0 | 658 | 327 |
object queue header operation | kcbo_ivbo | 0 | 361 | 700 |
object queue header operation | kcbw_make_free_nowait | 0 | 134 | 0 |
object queue header operation | kcbo_switch_q_bg | 0 | 95 | 68 |
object queue header operation | kcbo_switch_mq_bg | 0 | 76 | 123 |
object queue header operation | kcbw_link_q | 0 | 57 | 15 |
object queue header operation | kclobj_2 | 0 | 27 | 14 |
object queue header operation | kclobj_3 | 0 | 24 | 109 |
object queue header operation | kcb_flush_undo_segment | 0 | 11 | 15 |
object queue header operation | kclobj_1 | 0 | 4 | 6 |
object queue header operation | kcbo_switch_cq | 0 | 3 | 44 |
object queue header operation | kcbw_unlink_q_bg | 0 | 2 | 13 |
parallel query alloc buffer | kxfpbalo | 0 | 86 | 101 |
parallel query alloc buffer | kxfpbfre | 0 | 21 | 7 |
parameter table management | ksp_param_table_free | 0 | 3 | 1 |
process allocation | ksuapc | 0 | 439,154 | 437,339 |
process allocation | ksucrp | 0 | 331 | 0 |
process allocation | ksudlp | 0 | 7 | 1,525 |
process allocation | ksufap: active procs | 0 | 4 | 593 |
query server process | kxfpg1srv | 0 | 13 | 2 |
query server process | kxfpcrer | 0 | 1 | 12 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 140 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 3 | 0 | 40 | 66 |
redo allocation | kcrfw_redo_gen: redo allocation 2 | 0 | 1 | 0 |
redo writing | kcrfw_post: after write | 0 | 180 | 0 |
redo writing | kcrfwcr | 0 | 8 | 177 |
redo writing | kcrfw_post: rba scn pair | 0 | 6 | 0 |
redo writing | kcrfsr: rba scn pair | 0 | 1 | 19 |
redo writing | kcrfw_cal_target_rba | 0 | 1 | 0 |
resmgr:free threads list | kgskthrcreate | 0 | 213 | 187 |
resmgr:free threads list | kgskthrsod | 0 | 1 | 27 |
row cache objects | kqrbip | 0 | 26,263 | 34 |
row cache objects | kqreqd | 0 | 3,453 | 85 |
row cache objects | kqreqd: reget | 0 | 1,326 | 33 |
row cache objects | kqrpre: find obj | 0 | 1,323 | 8,983 |
row cache objects | kqrigt | 0 | 431 | 22,919 |
row cache objects | kqrso | 0 | 224 | 123 |
row cache objects | kqrbgl | 0 | 51 | 72 |
row cache objects | kqrbtm: pop parent | 0 | 24 | 47 |
row cache objects | kqrbfr | 0 | 3 | 109 |
row cache objects | kqrpre: init complete | 0 | 3 | 411 |
row cache objects | kqrsrd | 0 | 3 | 312 |
row cache objects | ksucallcbksafely: kqrhngc | 0 | 3 | 0 |
row cache objects | kqrbpr: KQRRSNRL | 0 | 2 | 11 |
row cache objects | kqrcmt: while loop | 0 | 2 | 16 |
session allocation | ksucrp | 0 | 49,247 | 41,421 |
session allocation | ksucri | 0 | 1,889 | 8,185 |
session allocation | ksuxds: KSUSFCLC not set | 0 | 1,643 | 1,203 |
session allocation | ksuxds: not user session | 0 | 472 | 2,840 |
session allocation | ksudlc | 0 | 226 | 0 |
session allocation | ksuprc | 0 | 205 | 12 |
session allocation | ksudlp | 0 | 5 | 0 |
session allocation | ksufap: active sessions | 0 | 3 | 0 |
session idle bit | ksuxds | 0 | 1 | 1 |
session state list latch | kpseqd | 0 | 2 | 0 |
session switching | kskexeall | 0 | 3,355 | 2,958 |
shared pool | kghalo | 0 | 42,272 | 78,006 |
shared pool | kgh_next_free | 0 | 34,805 | 967 |
shared pool | kghfrh | 0 | 17,689 | 32 |
shared pool | kghfrunp: clatch: nowait | 0 | 7,490 | 0 |
shared pool | kghupr1 | 0 | 7,409 | 16,664 |
shared pool | kghfrunp: clatch: wait | 0 | 7,217 | 24,216 |
shared pool | kghfre | 0 | 6,656 | 10,937 |
shared pool | kghfrunp: alloc: wait | 0 | 2,153 | 424 |
shared pool | kghalp | 0 | 639 | 4,471 |
shared pool | kghasp | 0 | 29 | 94 |
shared pool | kghfree_extents: scan | 0 | 2 | 30 |
shared pool | kghfen: not perm alloc class | 0 | 1 | 1 |
shared pool | kghfrunp: alloc: session dur | 0 | 1 | 0 |
shared pool simulator | kglsim_unpin_simhp | 0 | 493 | 286 |
shared pool simulator | kglsim_upd_newhp | 0 | 211 | 111 |
shared pool simulator | kglsim_chg_simhp_free | 0 | 71 | 134 |
shared pool simulator | kglsim_chg_simhp_inval | 0 | 24 | 0 |
shared pool simulator | kglsim_scan_lru: scan | 0 | 16 | 255 |
shared pool simulator | kglsim_chg_simhp_noob | 0 | 11 | 42 |
shared pool simulator | kglsim_scan_lru: rebalance | 0 | 2 | 0 |
simulator hash latch | kcbsacc: lookup dba | 0 | 32 | 41 |
simulator hash latch | kcbs_lookup_setid: lookup dba | 0 | 9 | 0 |
simulator lru latch | kcbs_shrink_pool | 0 | 4 | 0 |
slave class create | ksvcreate | 0 | 1 | 0 |
sort extent pool | ktstdt: return extent | 0 | 92 | 32 |
sort extent pool | ktstdt: dealloc sort extent | 0 | 9 | 0 |
trace latch | kstipg | 0 | 1,269 | 1,269 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
OLIVE | IDX_OL | PK_OL$_ATTR_DEFS | INDEX | 10,611,056 | 16.13 | |
OLIVE | DATA_OL | OL$_CLASSES | TABLE | 9,691,840 | 14.73 | |
OLIVE | IDX_OL | OL$_OBJECTS_U1 | INDEX | 5,792,064 | 8.80 | |
AMBER | IDX_WF | NDX_INDY_USER_PROFILE | INDEX | 3,309,872 | 5.03 | |
AMBER | IDX_WF | UK_USER_ACTION_BAK | INDEX | 3,269,776 | 4.97 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
OLIVE | DATA_OL | OL$_ASSOCIATIONS | TABLE | 24,186 | 5.70 | |
OLIVE | DATA_OL | OL$_OBJECTS_R01 | P_1340513 | TABLE PARTITION | 16,847 | 3.97 |
OLIVE | IDX_OL | OL$_OBJECTS_U1 | INDEX | 7,597 | 1.79 | |
OLIVE | IDX_OL | OL$_ASSOCIATIONS_N1 | INDEX | 7,128 | 1.68 | |
OLIVE | IDX_OL | NK_OL$_REFS_URI_A | INDEX | 4,322 | 1.02 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
PMS | DATA_P | T_YXDZ_CZPZB | TABLE | 244 | 17.63 | |
OLIVE | DATA_OL | OL$_OBJECTS | _134030904 | TABLE PARTITION | 104 | 7.51 |
OLIVE | DATA_OL | OL$_OBJECTS | _134011708 | TABLE PARTITION | 94 | 6.79 |
OLIVE | DATA_OL | OL$_OBJECTS | _134061413 | TABLE PARTITION | 88 | 6.36 |
OLIVE | DATA_OL | OL$_OBJECTS_R01 | P_1340610 | TABLE PARTITION | 82 | 5.92 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
---|---|---|---|---|---|---|
OLIVE | IDX_OL | OL$_EVENT_LOG_D1 | INDEX | 1 | 100.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
PMS | DATA_P | T_YXDZ_CZPZB | TABLE | 244 | 31.73 | |
OLIVE | IDX_OL | OL$_EVENT_LOG_D1 | INDEX | 141 | 18.34 | |
SGPM | IDX_SG | PK_P_TASK | INDEX | 136 | 17.69 | |
SGPM | IDX_SG | PK_P_TASK_PARA | INDEX | 105 | 13.65 | |
AMBER | IDX_WF | IDX_ONLINE_USER | INDEX | 39 | 5.07 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | GC Buffer Busy | % of Capture |
---|---|---|---|---|---|---|
AMBER | IDX_WF | IDX_ONLINE_USER | INDEX | 168,021 | 66.57 | |
AMBER | IDX_WF | IDX_USE_LOG | INDEX | 17,283 | 6.85 | |
PMS | DATA_P | T_WT_ISSUE_LSH_WH | TABLE | 16,051 | 6.36 | |
OLIVE | IDX_OL | NK_OL$_REFS_URI_A | INDEX | 8,127 | 3.22 | |
SGPM | DATA_SG | P_TASK | TABLE | 7,619 | 3.02 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
---|---|---|---|---|---|---|
SGPM | DATA_SG | P_TASK | TABLE | 3,413 | 13.25 | |
AMBER | IDX_WF | IDX_ONLINE_USER | INDEX | 2,471 | 9.59 | |
OLIVE | DATA_OL | OL$_ASSOCIATIONS | TABLE | 1,379 | 5.35 | |
OLIVE | IDX_OL | NK_OL$_REFS_URI_A | INDEX | 1,251 | 4.85 | |
OLIVE | IDX_OL | OL$_OBJECTS_U1 | INDEX | 1,191 | 4.62 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
---|---|---|---|---|---|---|
SCADA | IDX_SCA | SCADA_SUBAREA_MEASURE_SUM | TABLE | 21,236 | 10.96 | |
OLIVE | DATA_OL | OL$_OBJECTS_R01 | P_1340412 | TABLE PARTITION | 15,097 | 7.79 |
OLIVE | DATA_OL | OL$_ASSOCIATIONS | TABLE | 13,824 | 7.13 | |
OLIVE | DATA_OL | OL$_OBJECTS_R01 | P_1340625 | TABLE PARTITION | 13,646 | 7.04 |
OLIVE | DATA_OL | OL$_OBJECTS_R01 | P_1340106 | TABLE PARTITION | 13,281 | 6.85 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 18 | 5.56 | 0 | 1 | 1 | |
dc_database_links | 18,310 | 0.02 | 0 | 0 | 5 | |
dc_global_oids | 86,814 | 0.15 | 0 | 0 | 88 | |
dc_histogram_data | 794,631 | 4.15 | 0 | 0 | 10,956 | |
dc_histogram_defs | 252,503 | 7.44 | 0 | 6 | 5,256 | |
dc_object_grants | 282 | 32.27 | 0 | 0 | 49 | |
dc_object_ids | 318,634 | 0.62 | 0 | 1 | 1,788 | |
dc_objects | 31,721 | 4.55 | 0 | 2 | 911 | |
dc_profiles | 2,478 | 0.04 | 0 | 0 | 1 | |
dc_rollback_segments | 120,475 | 0.09 | 0 | 638 | 952 | |
dc_segments | 45,753 | 19.58 | 0 | 14 | 2,578 | |
dc_sequences | 26 | 57.69 | 0 | 26 | 0 | |
dc_table_scns | 85 | 7.06 | 0 | 0 | 3 | |
dc_tablespace_quotas | 40 | 35.00 | 0 | 0 | 8 | |
dc_tablespaces | 168,880 | 0.07 | 0 | 0 | 67 | |
dc_usernames | 13,029 | 0.17 | 0 | 0 | 24 | |
dc_users | 360,417 | 0.01 | 0 | 0 | 72 | |
outstanding_alerts | 306 | 94.12 | 0 | 28 | 4 |
Cache | GES Requests | GES Conflicts | GES Releases |
---|---|---|---|
dc_awr_control | 3 | 1 | 0 |
dc_database_links | 3 | 0 | 3 |
dc_global_oids | 128 | 0 | 117 |
dc_histogram_defs | 18,771 | 0 | 21,017 |
dc_object_ids | 1,961 | 0 | 1,546 |
dc_objects | 1,442 | 0 | 1,209 |
dc_profiles | 1 | 0 | 1 |
dc_rollback_segments | 1,296 | 114 | 0 |
dc_segments | 9,250 | 0 | 8,479 |
dc_sequences | 52 | 2 | 13 |
dc_table_scns | 6 | 0 | 5 |
dc_tablespace_quotas | 34 | 0 | 6 |
dc_tablespaces | 118 | 0 | 77 |
dc_usernames | 23 | 0 | 15 |
dc_users | 24 | 0 | 6 |
outstanding_alerts | 576 | 128 | 138 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
BODY | 508 | 4.72 | 69,607 | 0.09 | 39 | 0 |
CLUSTER | 87 | 3.45 | 140 | 2.86 | 1 | 0 |
INDEX | 1,263 | 1.90 | 15,257 | 0.64 | 11 | 0 |
JAVA DATA | 1 | 100.00 | 1 | 100.00 | 0 | 0 |
JAVA RESOURCE | 1 | 100.00 | 1 | 100.00 | 0 | 0 |
JAVA SOURCE | 1 | 100.00 | 1 | 100.00 | 0 | 0 |
SQL AREA | 101,011 | 23.78 | 1,806,326 | 3.60 | 2,878 | 1,155 |
TABLE/PROCEDURE | 13,593 | 6.99 | 273,002 | 1.57 | 1,797 | 0 |
TRIGGER | 235 | 3.40 | 2,994 | 0.43 | 5 | 0 |
Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
---|---|---|---|---|---|
CLUSTER | 140 | 3 | 3 | 3 | 0 |
INDEX | 15,257 | 24 | 25 | 23 | 0 |
JAVA DATA | 1 | 1 | 1 | 0 | 0 |
JAVA RESOURCE | 1 | 1 | 2 | 0 | 0 |
JAVA SOURCE | 1 | 1 | 2 | 0 | 0 |
TABLE/PROCEDURE | 57,428 | 594 | 488 | 365 | 0 |
TRIGGER | 1 | 8 | 10 | 7 | 0 |
Category | Alloc (MB) | Used (MB) | Avg Alloc (MB) | Std Dev Alloc (MB) | Max Alloc (MB) | Hist Max Alloc (MB) | Num Proc | Num Alloc | |
---|---|---|---|---|---|---|---|---|---|
B | Other | 4,284.94 | 2.49 | 8.83 | 354 | 354 | 1,720 | 1,720 | |
Freeable | 630.44 | 0.00 | 0.63 | 0.36 | 4 | 995 | 995 | ||
PL/SQL | 154.50 | 43.25 | 0.09 | 2.19 | 91 | 91 | 1,719 | 1,719 | |
SQL | 121.71 | 5.06 | 0.07 | 0.07 | 0 | 210 | 1,685 | 1,682 | |
E | Other | 728.81 | 3.90 | 26.05 | 354 | 354 | 187 | 187 | |
Freeable | 33.44 | 0.00 | 0.98 | 0.99 | 6 | 34 | 34 | ||
SQL | 1.77 | 0.11 | 0.08 | 0.09 | 0 | 2 | 23 | 19 | |
PL/SQL | 0.47 | 0.30 | 0.00 | 0.01 | 0 | 0 | 185 | 56 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 23,941,087,232 | 23,924,310,016 |
Fixed Size | 2,147,040 | |
Redo Buffers | 48,181,248 | |
Variable Size | 3,925,871,904 | 3,942,649,120 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 16.00 | 16.00 | 0.00 |
large | PX msg pool | 1.03 | 1.54 | 50.00 |
large | free memory | 14.97 | 14.46 | -3.43 |
shared | ASH buffers | 68.00 | 68.00 | 0.00 |
shared | CCursor | 72.35 | -100.00 | |
shared | Checkpoint queue | 62.52 | 62.52 | 0.00 |
shared | KGH: NO ACCESS | 2,030.74 | 1,999.82 | -1.52 |
shared | db_block_hash_buckets | 180.00 | 180.00 | 0.00 |
shared | free memory | 1,181.57 | 1,257.47 | 6.42 |
shared | gcs resources | 626.14 | 626.14 | 0.00 |
shared | gcs shadows | 294.06 | 294.06 | 0.00 |
shared | ges enqueues | 109.87 | 109.87 | 0.00 |
shared | kglsim object batch | 75.65 | 75.65 | 0.00 |
shared | library cache | 98.35 | 96.88 | -1.50 |
shared | obj stat memo | 134.54 | 134.56 | 0.01 |
shared | sql area | 87.05 | 88.68 | 1.88 |
shared | trace buffer | 71.30 | ||
streams | KGH: NO ACCESS | 15.99 | 15.99 | 0.00 |
streams | free memory | 16.00 | 16.00 | 0.00 |
buffer_cache | 22,832.00 | 22,816.00 | -0.07 | |
fixed_sga | 2.05 | 2.05 | 0.00 | |
log_buffer | 45.95 | 45.95 | 0.00 |
Session Type | CPU Time | User I/O Time | Sys I/O Time |
---|---|---|---|
QMON Slaves | 540,000 | 996,691 | 0 |
QMON Coordinator | 80,000 | 0 | 0 |
Ruleset Name | Evals | Fast Evals | SQL Execs | CPU Time | Elapsed Time |
---|---|---|---|---|---|
SYS.ALERT_QUE_R | 28 | 0 | 0 | 13 | 112 |
Resource Name | Current Utilization | Maximum Utilization | Initial Allocation | Limit |
---|---|---|---|---|
gcs_resources | 1,369,926 | 3,420,531 | 3177578 | 3177578 |
ges_procs | 187 | 4,018 | 5001 | 5001 |
processes | 188 | 4,565 | 5000 | 5000 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_file_dest | /oracle/product/admin/ndmis/adump | |
background_dump_dest | /oracle/product/admin/ndmis/bdump | |
cluster_database | TRUE | |
cluster_database_instances | 2 | |
compatible | 10.2.0.5.0 | |
control_files | /dev/rctrl_01_128m, /dev/rctrl_02_128m, /dev/rctrl_03_128m | |
core_dump_dest | /oracle/product/admin/ndmis/cdump | |
db_block_size | 8192 | |
db_domain | ||
db_file_multiblock_read_count | 16 | |
db_files | 2000 | |
db_name | ndmis | |
dispatchers | (PROTOCOL=TCP) (SERVICE=ndmisXDB) | |
instance_number | 2 | |
job_queue_processes | 20 | |
local_listener | (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.6.73)(PORT = 1521)) | |
log_archive_dest | /arch02 | |
log_archive_dest_1 | ||
nls_language | AMERICAN | |
nls_length_semantics | BYTE | |
open_cursors | 3000 | |
optimizer_index_cost_adj | 20 | |
optimizer_mode | ALL_ROWS | |
pga_aggregate_target | 6442450944 | |
processes | 5000 | |
remote_listener | LISTENERS_NDMIS | |
remote_login_passwordfile | EXCLUSIVE | |
service_names | nd_mis, ndmis | |
sessions | 5505 | |
sga_target | 27917287424 | |
spfile | /dev/rspfile_128m | |
thread | 2 | |
undo_management | AUTO | |
undo_tablespace | UNDOTBS2 | |
user_dump_dest | /oracle/product/admin/ndmis/udump |
Statistic | Total | per Second | per Trans |
---|---|---|---|
acks for commit broadcast(actual) | 6,572 | 3.49 | 0.95 |
acks for commit broadcast(logical) | 10,577 | 5.61 | 1.54 |
broadcast msgs on commit(actual) | 8,295 | 4.40 | 1.20 |
broadcast msgs on commit(logical) | 8,519 | 4.52 | 1.24 |
broadcast msgs on commit(wasted) | 2,234 | 1.19 | 0.32 |
broadcast on commit wait time(ms) | 267,033 | 141.73 | 38.77 |
broadcast on commit waits | 5,879 | 3.12 | 0.85 |
dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
false posts waiting for scn acks | 571 | 0.30 | 0.08 |
flow control messages received | 32 | 0.02 | 0.00 |
flow control messages sent | 0 | 0.00 | 0.00 |
gcs assume cvt | 0 | 0.00 | 0.00 |
gcs assume no cvt | 91,601 | 48.62 | 13.30 |
gcs ast xid | 16 | 0.01 | 0.00 |
gcs blocked converts | 14,133 | 7.50 | 2.05 |
gcs blocked cr converts | 25,824 | 13.71 | 3.75 |
gcs compatible basts | 256 | 0.14 | 0.04 |
gcs compatible cr basts (global) | 3,201 | 1.70 | 0.46 |
gcs compatible cr basts (local) | 174,306 | 92.52 | 25.31 |
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 | 4,869 | 2.58 | 0.71 |
gcs dbwr write request msgs | 4,120 | 2.19 | 0.60 |
gcs error msgs | 2 | 0.00 | 0.00 |
gcs forward cr to pinged instance | 0 | 0.00 | 0.00 |
gcs immediate (compatible) converts | 4,333 | 2.30 | 0.63 |
gcs immediate (null) converts | 25,676 | 13.63 | 3.73 |
gcs immediate cr (compatible) converts | 60 | 0.03 | 0.01 |
gcs immediate cr (null) converts | 237,341 | 125.98 | 34.46 |
gcs indirect ast | 61,719 | 32.76 | 8.96 |
gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
gcs lms write request msgs | 1,858 | 0.99 | 0.27 |
gcs msgs process time(ms) | 2,202,919 | 1,169.26 | 319.82 |
gcs msgs received | 669,263 | 355.23 | 97.16 |
gcs out-of-order msgs | 43 | 0.02 | 0.01 |
gcs pings refused | 102 | 0.05 | 0.01 |
gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
gcs queued converts | 35 | 0.02 | 0.01 |
gcs recovery claim msgs | 0 | 0.00 | 0.00 |
gcs refuse xid | 11 | 0.01 | 0.00 |
gcs regular cr | 0 | 0.00 | 0.00 |
gcs retry convert request | 25 | 0.01 | 0.00 |
gcs side channel msgs actual | 18,578 | 9.86 | 2.70 |
gcs side channel msgs logical | 284,463 | 150.99 | 41.30 |
gcs stale cr | 6 | 0.00 | 0.00 |
gcs undo cr | 1,326 | 0.70 | 0.19 |
gcs write notification msgs | 273 | 0.14 | 0.04 |
gcs writes refused | 27 | 0.01 | 0.00 |
ges msgs process time(ms) | 54,931 | 29.16 | 7.97 |
ges msgs received | 152,643 | 81.02 | 22.16 |
global posts dropped | 0 | 0.00 | 0.00 |
global posts queue time | 33 | 0.02 | 0.00 |
global posts queued | 30 | 0.02 | 0.00 |
global posts requested | 30 | 0.02 | 0.00 |
global posts sent | 30 | 0.02 | 0.00 |
implicit batch messages received | 46,787 | 24.83 | 6.79 |
implicit batch messages sent | 62,450 | 33.15 | 9.07 |
lmd msg send time(ms) | 0 | 0.00 | 0.00 |
lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
messages flow controlled | 30,818 | 16.36 | 4.47 |
messages queue sent actual | 266,260 | 141.32 | 38.66 |
messages queue sent logical | 461,880 | 245.16 | 67.06 |
messages received actual | 452,301 | 240.07 | 65.67 |
messages received logical | 821,935 | 436.26 | 119.33 |
messages sent directly | 165,094 | 87.63 | 23.97 |
messages sent indirectly | 1,480,987 | 786.07 | 215.01 |
messages sent not implicit batched | 203,834 | 108.19 | 29.59 |
messages sent pbatched | 1,552,984 | 824.29 | 225.46 |
msgs causing lmd to send msgs | 97,220 | 51.60 | 14.11 |
msgs causing lms(s) to send msgs | 11,385 | 6.04 | 1.65 |
msgs received queue time (ms) | 5,675,249 | 3,012.29 | 823.93 |
msgs received queued | 821,848 | 436.22 | 119.32 |
msgs sent queue time (ms) | 6,911,785 | 3,668.61 | 1,003.45 |
msgs sent queue time on ksxp (ms) | 58,378,312 | 30,985.84 | 8,475.36 |
msgs sent queued | 457,809 | 242.99 | 66.46 |
msgs sent queued on ksxp | 469,682 | 249.30 | 68.19 |
number of ges deadlock detected | 0 | 0.00 | 0.00 |
process batch messages received | 63,843 | 33.89 | 9.27 |
process batch messages sent | 166,503 | 88.38 | 24.17 |
Statistic | Total |
---|---|
CR Block Requests | 21,793 |
CURRENT Block Requests | 2,094 |
Data Block Requests | 21,796 |
Undo Block Requests | 441 |
TX Block Requests | 1,295 |
Current Results | 21,604 |
Private results | 67 |
Zero Results | 2,207 |
Disk Read Results | 0 |
Fail Results | 3 |
Fairness Down Converts | 3,981 |
Fairness Clears | 0 |
Free GC Elements | 0 |
Flushes | 202 |
Flushes Queued | 0 |
Flush Queue Full | 0 |
Flush Max Time (us) | 0 |
Light Works | 310 |
Errors | 0 |
Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
---|---|---|---|---|---|---|
Pins | 191,084 | 99.53 | 0.14 | 0.22 | 0.06 | 0.04 |
Flushes | 251 | 58.17 | 18.73 | 10.36 | 6.37 | 6.37 |
Writes | 6,774 | 31.92 | 25.26 | 14.79 | 17.57 | 10.47 |
CR | Current | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
1 | data block | 23,718 | 96.91 | 2.17 | 0.92 | 192,780 | 97.84 | 0.28 | 1.88 |
1 | undo header | 1,215 | 97.78 | 1.15 | 1.07 | 73 | 93.15 | 6.85 | 0.00 |
1 | Others | 387 | 97.93 | 1.03 | 1.03 | 792 | 99.37 | 0.25 | 0.38 |
1 | undo block | 390 | 94.62 | 3.08 | 2.31 | 33 | 96.97 | 0.00 | 3.03 |