kvamdb1$cat awrrpt_1_19655_19656.html
DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
VAM | 2306309266 | vam1 | 1 | 10.2.0.4.0 | YES | kvamdb1 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 19655 | 09-Feb-12 01:00:43 | 1214 | .7 |
End Snap: | 19656 | 09-Feb-12 02:00:04 | 1123 | .7 |
Elapsed: | 59.35 (mins) | |||
DB Time: | 267.22 (mins) |
Cache Sizes
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 5,248M | 5,248M | Std Block Size: | 8K |
Shared Pool Size: | 1,664M | 1,664M | Log Buffer: | 14,376K |
Load Profile
Per Second | Per Transaction | |
---|---|---|
Redo size: | 909,237.73 | 13,585.18 |
Logical reads: | 318,581.86 | 4,760.02 |
Block changes: | 3,806.42 | 56.87 |
Physical reads: | 36.27 | 0.54 |
Physical writes: | 165.64 | 2.47 |
User calls: | 2,178.03 | 32.54 |
Parses: | 286.16 | 4.28 |
Hard parses: | 6.65 | 0.10 |
Sorts: | 41.23 | 0.62 |
Logons: | 0.91 | 0.01 |
Executes: | 337.13 | 5.04 |
Transactions: | 66.93 |
% Blocks changed per Read: | 1.19 | Recursive Call %: | 21.21 |
Rollback per transaction %: | 0.03 | Rows per Sort: | 11.64 |
Instance Efficiency Percentages (Target 100%)
Buffer Nowait %: | 100.00 | Redo NoWait %: | 99.99 |
Buffer Hit %: | 99.99 | In-memory Sort %: | 100.00 |
Library Hit %: | 94.69 | Soft Parse %: | 97.68 |
Execute to Parse %: | 15.12 | Latch Hit %: | 98.49 |
Parse CPU to Parse Elapsd %: | 87.65 | % Non-Parse CPU: | 99.35 |
Shared Pool Statistics
Begin | End | |
---|---|---|
Memory Usage %: | 56.46 | 56.70 |
% SQL with executions>1: | 83.56 | 82.69 |
% Memory for SQL w/exec>1: | 82.13 | 81.93 |
Top 5 Timed Events
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
---|---|---|---|---|---|
CPU time | 14,720 | 91.8 | |||
Backup: sbtwrite2 | 349,815 | 6,651 | 19 | 41.5 | Administrative |
Backup: sbtbackup | 3 | 3,002 | 1,000,730 | 18.7 | Administrative |
db file sequential read | 121,626 | 682 | 6 | 4.3 | User I/O |
SQL*Net more data to client | 9,893,020 | 282 | 0 | 1.8 | Network |
Begin | End | |
---|---|---|
Number of Instances: | 2 | 2 |
Global Cache Load Profile
Per Second | Per Transaction | |
---|---|---|
Global Cache blocks received: | 90.67 | 1.35 |
Global Cache blocks served: | 317.36 | 4.74 |
GCS/GES messages received: | 966.24 | 14.44 |
GCS/GES messages sent: | 436.25 | 6.52 |
DBWR Fusion writes: | 32.21 | 0.48 |
Estd Interconnect traffic (KB) | 3,538.14 |
Global Cache Efficiency Percentages (Target local+remote 100%)
Buffer access - local cache %: | 99.96 |
Buffer access - remote cache %: | 0.03 |
Buffer access - disk %: | 0.01 |
Global Cache and Enqueue Services - Workload Characteristics
Avg global enqueue get time (ms): | 0.1 |
Avg global cache cr block receive time (ms): | 0.7 |
Avg global cache current block receive time (ms): | 0.7 |
Avg global cache cr block build time (ms): | 0.0 |
Avg global cache cr block send time (ms): | 0.1 |
Global cache log flushes for cr blocks served %: | 1.0 |
Avg global cache cr block flush time (ms): | 1.4 |
Avg global cache current block pin time (ms): | 0.0 |
Avg global cache current block send time (ms): | 0.1 |
Global cache log flushes for current blocks served %: | 0.1 |
Avg global cache current block flush time (ms): | 1.1 |
Global Cache and Enqueue Services - Messaging Statistics
Avg message sent queue time (ms): | 0.0 |
Avg message sent queue time on ksxp (ms): | 0.4 |
Avg message received queue time (ms): | 0.0 |
Avg GCS message process time (ms): | 0.1 |
Avg GES message process time (ms): | 0.0 |
% of direct sent messages: | 32.50 |
% of indirect sent messages: | 66.46 |
% of flow controlled messages: | 1.05 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 15,549.22 | 96.98 |
DB CPU | 14,719.88 | 91.81 |
RMAN cpu time (backup/restore) | 260.92 | 1.63 |
parse time elapsed | 120.19 | 0.75 |
hard parse elapsed time | 64.59 | 0.40 |
connection management call elapsed time | 13.78 | 0.09 |
PL/SQL execution elapsed time | 5.24 | 0.03 |
sequence load elapsed time | 2.44 | 0.02 |
hard parse (sharing criteria) elapsed time | 1.84 | 0.01 |
PL/SQL compilation elapsed time | 0.25 | 0.00 |
hard parse (bind mismatch) elapsed time | 0.17 | 0.00 |
repeated bind elapsed time | 0.09 | 0.00 |
DB time | 16,033.01 | |
background elapsed time | 11,986.34 | |
background cpu time | 840.66 |
Back to Wait Events Statistics
Back to Top
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
Administrative | 349,822 | 0.00 | 9,690 | 28 | 1.47 |
User I/O | 139,902 | 0.00 | 684 | 5 | 0.59 |
Network | 17,365,012 | 0.00 | 351 | 0 | 72.86 |
Cluster | 397,595 | 0.00 | 236 | 1 | 1.67 |
System I/O | 481,720 | 0.00 | 217 | 0 | 2.02 |
Commit | 238,841 | 0.00 | 191 | 1 | 1.00 |
Other | 543,034 | 93.32 | 77 | 0 | 2.28 |
Application | 121,896 | 0.00 | 61 | 0 | 0.51 |
Concurrency | 54,344 | 0.22 | 25 | 0 | 0.23 |
Configuration | 814 | 9.95 | 1 | 1 | 0.00 |
Back to Wait Events Statistics
Back to Top
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
Backup: sbtwrite2 | 349,815 | 0.00 | 6,651 | 19 | 1.47 |
Backup: sbtbackup | 3 | 0.00 | 3,002 | 1000730 | 0.00 |
db file sequential read | 121,626 | 0.00 | 682 | 6 | 0.51 |
SQL*Net more data to client | 9,893,020 | 0.00 | 282 | 0 | 41.51 |
log file sync | 238,841 | 0.00 | 191 | 1 | 1.00 |
gc current block 2-way | 296,045 | 0.00 | 170 | 1 | 1.24 |
log file parallel write | 265,360 | 0.00 | 119 | 0 | 1.11 |
SQL*Net more data from client | 525,991 | 0.00 | 63 | 0 | 2.21 |
SQL*Net break/reset to client | 120,146 | 0.00 | 60 | 0 | 0.50 |
reliable message | 304 | 10.86 | 52 | 170 | 0.00 |
db file parallel write | 179,058 | 0.00 | 46 | 0 | 0.75 |
log file sequential read | 3,426 | 0.00 | 38 | 11 | 0.01 |
Backup: sbtclose2 | 2 | 0.00 | 34 | 17133 | 0.00 |
gc current grant 2-way | 47,975 | 0.00 | 20 | 0 | 0.20 |
gc cr block 2-way | 23,576 | 0.00 | 14 | 1 | 0.10 |
gc current grant busy | 17,003 | 0.00 | 13 | 1 | 0.07 |
control file sequential read | 27,666 | 0.00 | 10 | 0 | 0.12 |
library cache lock | 20,650 | 0.00 | 10 | 0 | 0.09 |
row cache lock | 19,803 | 0.00 | 9 | 0 | 0.08 |
gc current block busy | 629 | 0.00 | 7 | 12 | 0.00 |
SQL*Net message to client | 6,946,001 | 0.00 | 7 | 0 | 29.15 |
gc buffer busy | 829 | 0.97 | 7 | 9 | 0.00 |
Streams AQ: qmn coordinator waiting for slave to start | 1 | 100.00 | 5 | 4890 | 0.00 |
CGS wait for IPC msg | 486,307 | 99.99 | 4 | 0 | 2.04 |
enq: WF - contention | 19 | 36.84 | 4 | 197 | 0.00 |
enq: FB - contention | 4,666 | 0.00 | 3 | 1 | 0.02 |
enq: TC - contention | 6 | 83.33 | 3 | 464 | 0.00 |
enq: TX - index contention | 205 | 0.00 | 3 | 13 | 0.00 |
Backup: sbtinfo2 | 2 | 0.00 | 2 | 1242 | 0.00 |
gc cr block busy | 1,734 | 0.00 | 2 | 1 | 0.01 |
cursor: pin S wait on X | 137 | 86.86 | 2 | 15 | 0.00 |
control file parallel write | 2,743 | 0.00 | 2 | 1 | 0.01 |
gcs log flush sync | 1,919 | 10.11 | 2 | 1 | 0.01 |
name-service call wait | 19 | 0.00 | 1 | 56 | 0.00 |
direct path read | 15,603 | 0.00 | 1 | 0 | 0.07 |
latch free | 488 | 0.00 | 1 | 2 | 0.00 |
Log archive I/O | 3,307 | 0.00 | 1 | 0 | 0.01 |
DFS lock handle | 1,754 | 0.00 | 1 | 0 | 0.01 |
gc current multi block request | 7,752 | 0.00 | 1 | 0 | 0.03 |
os thread startup | 15 | 0.00 | 1 | 50 | 0.00 |
log file switch completion | 51 | 0.00 | 1 | 12 | 0.00 |
enq: TM - contention | 1,166 | 0.00 | 1 | 1 | 0.00 |
RMAN backup & recovery I/O | 92 | 0.00 | 1 | 6 | 0.00 |
ksxr poll remote instances | 36,551 | 42.84 | 1 | 0 | 0.15 |
gc cr disk read | 918 | 0.00 | 0 | 1 | 0.00 |
latch: cache buffers chains | 12,271 | 0.00 | 0 | 0 | 0.05 |
rdbms ipc reply | 950 | 0.00 | 0 | 0 | 0.00 |
enq: HW - contention | 663 | 0.00 | 0 | 1 | 0.00 |
gc cr multi block request | 823 | 0.00 | 0 | 0 | 0.00 |
enq: TT - contention | 480 | 0.00 | 0 | 1 | 0.00 |
library cache pin | 577 | 0.00 | 0 | 0 | 0.00 |
ges inquiry response | 293 | 0.00 | 0 | 1 | 0.00 |
db file scattered read | 57 | 0.00 | 0 | 3 | 0.00 |
enq: RO - fast object reuse | 397 | 0.00 | 0 | 0 | 0.00 |
kksfbc child completion | 3 | 100.00 | 0 | 56 | 0.00 |
enq: CF - contention | 199 | 0.00 | 0 | 1 | 0.00 |
IPC send completion sync | 282 | 98.58 | 0 | 0 | 0.00 |
latch: shared pool | 60 | 0.00 | 0 | 2 | 0.00 |
gc cr grant 2-way | 288 | 0.00 | 0 | 0 | 0.00 |
LGWR wait for redo copy | 3,549 | 0.00 | 0 | 0 | 0.01 |
enq: KO - fast object checkpoint | 186 | 0.00 | 0 | 0 | 0.00 |
enq: PS - contention | 123 | 0.00 | 0 | 1 | 0.00 |
global enqueue expand wait | 6 | 83.33 | 0 | 12 | 0.00 |
local write wait | 42 | 0.00 | 0 | 1 | 0.00 |
PX Deq: reap credit | 4,373 | 94.37 | 0 | 0 | 0.02 |
buffer busy waits | 614 | 0.00 | 0 | 0 | 0.00 |
PX Deq Credit: send blkd | 127 | 12.60 | 0 | 0 | 0.00 |
direct path write | 2,559 | 0.00 | 0 | 0 | 0.01 |
read by other session | 8 | 0.00 | 0 | 5 | 0.00 |
enq: JQ - contention | 40 | 0.00 | 0 | 1 | 0.00 |
log file single write | 68 | 0.00 | 0 | 0 | 0.00 |
enq: SQ - contention | 9 | 0.00 | 0 | 2 | 0.00 |
KJC: Wait for msg sends to complete | 176 | 0.00 | 0 | 0 | 0.00 |
enq: TA - contention | 23 | 0.00 | 0 | 1 | 0.00 |
gc current split | 21 | 0.00 | 0 | 1 | 0.00 |
library cache load lock | 7 | 0.00 | 0 | 2 | 0.00 |
enq: RS - prevent file delete | 17 | 0.00 | 0 | 1 | 0.00 |
enq: WL - contention | 9 | 0.00 | 0 | 1 | 0.00 |
enq: US - contention | 9 | 0.00 | 0 | 1 | 0.00 |
enq: TX - allocate ITL entry | 10 | 0.00 | 0 | 1 | 0.00 |
latch: KCL gc element parent latch | 108 | 0.00 | 0 | 0 | 0.00 |
enq: TX - contention | 1 | 0.00 | 0 | 4 | 0.00 |
latch: object queue header operation | 38 | 0.00 | 0 | 0 | 0.00 |
buffer deadlock | 152 | 96.71 | 0 | 0 | 0.00 |
PX Deq: Signal ACK | 21 | 28.57 | 0 | 0 | 0.00 |
enq: PI - contention | 6 | 0.00 | 0 | 0 | 0.00 |
latch: session allocation | 3 | 0.00 | 0 | 1 | 0.00 |
db file single write | 5 | 0.00 | 0 | 0 | 0.00 |
enq: BR - file shrink | 2 | 0.00 | 0 | 1 | 0.00 |
db file parallel read | 2 | 0.00 | 0 | 0 | 0.00 |
latch: cache buffers lru chain | 4 | 0.00 | 0 | 0 | 0.00 |
gc cr failure | 1 | 0.00 | 0 | 1 | 0.00 |
enq: TX - row lock contention | 1 | 0.00 | 0 | 1 | 0.00 |
latch: row cache objects | 1 | 0.00 | 0 | 1 | 0.00 |
enq: AF - task serialization | 1 | 0.00 | 0 | 0 | 0.00 |
undo segment extension | 81 | 100.00 | 0 | 0 | 0.00 |
enq: CT - state | 1 | 0.00 | 0 | 0 | 0.00 |
latch: library cache | 1 | 0.00 | 0 | 0 | 0.00 |
latch: gcs resource hash | 2 | 0.00 | 0 | 0 | 0.00 |
latch: enqueue hash chains | 1 | 0.00 | 0 | 0 | 0.00 |
cursor: mutex X | 3 | 0.00 | 0 | 0 | 0.00 |
gc object scan | 1 | 100.00 | 0 | 0 | 0.00 |
cr request retry | 1 | 100.00 | 0 | 0 | 0.00 |
SQL*Net message from client | 6,946,093 | 0.00 | 3,274,957 | 471 | 29.15 |
jobq slave wait | 7,122 | 49.42 | 17,299 | 2429 | 0.03 |
gcs remote message | 1,776,929 | 90.40 | 13,566 | 8 | 7.46 |
PX Idle Wait | 2,182 | 94.64 | 5,238 | 2401 | 0.01 |
Streams AQ: qmn slave idle wait | 134 | 2.24 | 3,530 | 26342 | 0.00 |
Streams AQ: waiting for time management or cleanup tasks | 11 | 0.00 | 3,490 | 317314 | 0.00 |
ASM background timer | 1,404 | 0.00 | 3,472 | 2473 | 0.01 |
Streams AQ: waiting for messages in the queue | 367 | 96.73 | 3,469 | 9451 | 0.00 |
DIAG idle wait | 16,852 | 0.00 | 3,467 | 206 | 0.07 |
Streams AQ: qmn coordinator idle wait | 258 | 50.00 | 3,464 | 13426 | 0.00 |
ges remote message | 130,933 | 85.55 | 3,458 | 26 | 0.55 |
class slave wait | 346 | 0.29 | 3,309 | 9563 | 0.00 |
KSV master wait | 359 | 0.00 | 4 | 11 | 0.00 |
PX Deq: Execution Msg | 625 | 33.44 | 1 | 2 | 0.00 |
PX Deq: Parse Reply | 29 | 41.38 | 0 | 2 | 0.00 |
PX Deq: Msg Fragment | 239 | 43.10 | 0 | 0 | 0.00 |
PX Deq: Join ACK | 29 | 37.93 | 0 | 1 | 0.00 |
PX Deq: Execute Reply | 26 | 30.77 | 0 | 0 | 0.00 |
Streams AQ: RAC qmn coordinator idle wait | 258 | 100.00 | 0 | 0 | 0.00 |
Back to Wait Events Statistics
Back to Top
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
log file parallel write | 265,349 | 0.00 | 119 | 0 | 1.11 |
events in waitclass Other | 532,090 | 94.43 | 66 | 0 | 2.23 |
db file parallel write | 179,058 | 0.00 | 46 | 0 | 0.75 |
log file sequential read | 3,426 | 0.00 | 38 | 11 | 0.01 |
control file sequential read | 11,446 | 0.00 | 4 | 0 | 0.05 |
control file parallel write | 2,580 | 0.00 | 2 | 1 | 0.01 |
Log archive I/O | 3,307 | 0.00 | 1 | 0 | 0.01 |
os thread startup | 15 | 0.00 | 1 | 50 | 0.00 |
enq: TM - contention | 1,163 | 0.00 | 1 | 1 | 0.00 |
gc current block 2-way | 633 | 0.00 | 0 | 1 | 0.00 |
gc cr block 2-way | 517 | 0.00 | 0 | 1 | 0.00 |
direct path read | 12,194 | 0.00 | 0 | 0 | 0.05 |
gc current block busy | 4 | 0.00 | 0 | 52 | 0.00 |
enq: RO - fast object reuse | 389 | 0.00 | 0 | 0 | 0.00 |
latch: shared pool | 6 | 0.00 | 0 | 16 | 0.00 |
library cache lock | 169 | 0.00 | 0 | 1 | 0.00 |
enq: KO - fast object checkpoint | 186 | 0.00 | 0 | 0 | 0.00 |
gc current grant busy | 58 | 0.00 | 0 | 1 | 0.00 |
direct path write | 2,553 | 0.00 | 0 | 0 | 0.01 |
log file single write | 68 | 0.00 | 0 | 0 | 0.00 |
enq: HW - contention | 34 | 0.00 | 0 | 1 | 0.00 |
library cache pin | 16 | 0.00 | 0 | 0 | 0.00 |
gc cr multi block request | 16 | 0.00 | 0 | 0 | 0.00 |
latch: cache buffers chains | 102 | 0.00 | 0 | 0 | 0.00 |
gc current multi block request | 7 | 0.00 | 0 | 0 | 0.00 |
buffer busy waits | 5 | 0.00 | 0 | 0 | 0.00 |
latch: row cache objects | 1 | 0.00 | 0 | 1 | 0.00 |
gc object scan | 1 | 100.00 | 0 | 0 | 0.00 |
row cache lock | 1,139 | -0.18 | -8 | -7 | 0.00 |
rdbms ipc message | 461,191 | 12.11 | 51,604 | 112 | 1.94 |
gcs remote message | 1,776,916 | 90.40 | 13,566 | 8 | 7.46 |
Streams AQ: waiting for time management or cleanup tasks | 11 | 0.00 | 3,490 | 317314 | 0.00 |
ASM background timer | 1,404 | 0.00 | 3,472 | 2473 | 0.01 |
DIAG idle wait | 16,852 | 0.00 | 3,467 | 206 | 0.07 |
Streams AQ: qmn coordinator idle wait | 258 | 50.00 | 3,464 | 13426 | 0.00 |
smon timer | 891 | 0.00 | 3,464 | 3887 | 0.00 |
ges remote message | 130,979 | 85.55 | 3,458 | 26 | 0.55 |
pmon timer | 1,959 | 99.90 | 3,447 | 1760 | 0.01 |
class slave wait | 343 | 0.29 | 3,309 | 9647 | 0.00 |
KSV master wait | 221 | 0.00 | 0 | 2 | 0.00 |
PX Deq: Parse Reply | 29 | 41.38 | 0 | 2 | 0.00 |
PX Deq: Join ACK | 29 | 37.93 | 0 | 1 | 0.00 |
PX Deq: Execute Reply | 26 | 30.77 | 0 | 0 | 0.00 |
Streams AQ: RAC qmn coordinator idle wait | 258 | 100.00 | 0 | 0 | 0.00 |
Back to Wait Events Statistics
Back to Top
Statistic | Total |
---|---|
AVG_BUSY_TIME | 114,605 |
AVG_IDLE_TIME | 240,423 |
AVG_IOWAIT_TIME | 0 |
AVG_SYS_TIME | 16,293 |
AVG_USER_TIME | 98,201 |
BUSY_TIME | 1,835,421 |
IDLE_TIME | 3,848,493 |
IOWAIT_TIME | 0 |
SYS_TIME | 262,392 |
USER_TIME | 1,573,029 |
LOAD | 6 |
OS_CPU_WAIT_TIME | 11,900 |
RSRC_MGR_CPU_WAIT_TIME | 0 |
VM_IN_BYTES | 24,936,448 |
VM_OUT_BYTES | 36,937,728 |
PHYSICAL_MEMORY_BYTES | 16,863,617,024 |
NUM_CPUS | 16 |
Back to Wait Events Statistics
Back to Top
Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
---|---|---|---|---|
vam | 15,326.80 | 14,031.40 | 114,911 | 1,125,049,007 |
SYS$USERS | 705.90 | 688.00 | 1,684 | 9,275,440 |
SYS$BACKGROUND | 0.00 | 0.00 | 12,728 | 156,056 |
Back to Wait Events Statistics
Back to Top
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 |
---|---|---|---|---|---|---|---|---|
vam | 114923 | 67365 | 43097 | 1750 | 0 | 0 | 12417746 | 25904 |
SYS$USERS | 9464 | 754 | 6116 | 434 | 349814 | 968987 | 4935124 | 9212 |
SYS$BACKGROUND | 15530 | 255 | 5124 | 296 | 0 | 0 | 0 | 0 |
Back to Wait Events Statistics
Back to Top
Elapsed Time (s) | CPU Time (s) | Executions | Elap per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
7,884 | 7,930 | 42 | 187.71 | 49.17 | c4s83719x437j | select rc.Id as city_id, rn.p... | |
1,477 | 1,249 | 99,186 | 0.01 | 9.22 | anwkyts985z77 | delete from fsti_alarm_trans w... | |
1,472 | 1,247 | 99,186 | 0.01 | 9.18 | gdd5s7nqgssu9 | select addition_id from fsti_a... | |
1,426 | 1,426 | 178 | 8.01 | 8.89 | 4a6cx9kqm5r5h | select Identifier, Node, NodeA... | |
1,123 | 378 | 486 | 2.31 | 7.01 | 6acqpn0qjrctq | SQL Loader Conventional Path Load | INSERT INTO PROD_FZ_WAP_WAP20T... |
425 | 425 | 66 | 6.44 | 2.65 | 1dg7znt919y4p | Select c.Id As cityid, c.cname... | |
310 | 309 | 73 | 4.24 | 1.93 | g269uhxq6ubty | Select c.Id As cityid, c.cname... | |
139 | 139 | 68 | 2.04 | 0.87 | 3rn43k5skpggf | SELECT * FROM ( SELE... | |
110 | 110 | 65 | 1.70 | 0.69 | 3vzt7yt9tja88 | SELECT * FROM ( SELE... | |
108 | 108 | 68 | 1.59 | 0.67 | 9u68cq2puf064 | Select Count(1) From Res_Servi... |
Back to SQL Statistics
Back to Top
CPU Time (s) | Elapsed Time (s) | Executions | CPU per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
7,930 | 7,884 | 42 | 188.80 | 49.17 | c4s83719x437j | select rc.Id as city_id, rn.p... | |
1,426 | 1,426 | 178 | 8.01 | 8.89 | 4a6cx9kqm5r5h | select Identifier, Node, NodeA... | |
1,249 | 1,477 | 99,186 | 0.01 | 9.22 | anwkyts985z77 | delete from fsti_alarm_trans w... | |
1,247 | 1,472 | 99,186 | 0.01 | 9.18 | gdd5s7nqgssu9 | select addition_id from fsti_a... | |
425 | 425 | 66 | 6.44 | 2.65 | 1dg7znt919y4p | Select c.Id As cityid, c.cname... | |
378 | 1,123 | 486 | 0.78 | 7.01 | 6acqpn0qjrctq | SQL Loader Conventional Path Load | INSERT INTO PROD_FZ_WAP_WAP20T... |
309 | 310 | 73 | 4.24 | 1.93 | g269uhxq6ubty | Select c.Id As cityid, c.cname... | |
139 | 139 | 68 | 2.04 | 0.87 | 3rn43k5skpggf | SELECT * FROM ( SELE... | |
110 | 110 | 65 | 1.70 | 0.69 | 3vzt7yt9tja88 | SELECT * FROM ( SELE... | |
108 | 108 | 68 | 1.59 | 0.67 | 9u68cq2puf064 | Select Count(1) From Res_Servi... |
Back to SQL Statistics
Back to Top
Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
567,246,758 | 42 | 13,505,875.19 | 50.00 | 7929.70 | 7883.79 | c4s83719x437j | select rc.Id as city_id, rn.p... | |
225,053,171 | 99,186 | 2,269.00 | 19.84 | 1248.99 | 1477.45 | anwkyts985z77 | delete from fsti_alarm_trans w... | |
225,050,908 | 99,186 | 2,268.98 | 19.84 | 1247.18 | 1471.63 | gdd5s7nqgssu9 | select addition_id from fsti_a... | |
24,442,903 | 178 | 137,319.68 | 2.15 | 1425.92 | 1425.85 | 4a6cx9kqm5r5h | select Identifier, Node, NodeA... | |
16,059,605 | 486 | 33,044.45 | 1.42 | 378.06 | 1123.48 | 6acqpn0qjrctq | SQL Loader Conventional Path Load | INSERT INTO PROD_FZ_WAP_WAP20T... |
6,743,012 | 73 | 92,370.03 | 0.59 | 309.48 | 309.52 | g269uhxq6ubty | Select c.Id As cityid, c.cname... | |
6,390,471 | 68 | 93,977.51 | 0.56 | 138.75 | 138.77 | 3rn43k5skpggf | SELECT * FROM ( SELE... | |
6,381,100 | 68 | 93,839.71 | 0.56 | 108.13 | 108.13 | 9u68cq2puf064 | Select Count(1) From Res_Servi... | |
6,196,415 | 66 | 93,885.08 | 0.55 | 425.30 | 425.32 | 1dg7znt919y4p | Select c.Id As cityid, c.cname... | |
6,005,778 | 64 | 93,840.28 | 0.53 | 102.07 | 102.07 | c9f8hcmhypvmq | Select severity, count(1) as a... |
Back to SQL Statistics
Back to Top
Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
106,824 | 486 | 219.80 | 82.70 | 378.06 | 1123.48 | 6acqpn0qjrctq | SQL Loader Conventional Path Load | INSERT INTO PROD_FZ_WAP_WAP20T... |
472 | 4 | 118.00 | 0.37 | 2.07 | 4.78 | 6bbzx8bac652f | JDBC Thin Client | SELECT t.*, rownum from (SELEC... |
258 | 1,829 | 0.14 | 0.20 | 36.44 | 40.78 | 8cx33vubmug6b | insert into FSTI_ALARM_HISTORY... | |
67 | 296 | 0.23 | 0.05 | 7.02 | 8.12 | 5j90cjhgfvsj8 | insert into FSTI_ALARM_HISTORY... | |
46 | 1,281 | 0.04 | 0.04 | 26.48 | 29.46 | gt22pnh04wan8 | UPDATE FSTI_ALARM_CURRENT SET ... | |
30 | 798 | 0.04 | 0.02 | 0.88 | 11.42 | 1qvjz6ud03wfm | insert into prod_res_ne_detect... | |
24 | 4 | 6.00 | 0.02 | 45.97 | 45.97 | 43xtg2pbayp29 | DECLARE job BINARY_INTEGER := ... | |
8 | 11,452 | 0.00 | 0.01 | 6.91 | 6.95 | dxy8awsx01f1x | update PERF_HOST_STORAGE_DAY_M... | |
7 | 10,075 | 0.00 | 0.01 | 6.77 | 6.81 | gaskb581vzwb1 | update PERF_HOST_STORAGE_HOUR_... | |
6 | 10,077 | 0.00 | 0.00 | 6.33 | 6.33 | 2uxqqt4t7jwn2 | update PERF_HOST_STORAGE_HOUR_... |
Back to SQL Statistics
Back to Top
Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
140,928 | 261,589 | 1.86 | 0.00 | 0.00 | 2aadvhw5r7gfc | select name, ip from CONF_APP_... | |
136,038 | 135,733 | 1.00 | 0.00 | 0.00 | 3tjv3vcff9nj1 | select net_area_id from CONF_A... | |
99,186 | 0 | 0.00 | 0.01 | 0.01 | anwkyts985z77 | delete from fsti_alarm_trans w... | |
99,186 | 1,700 | 0.02 | 0.01 | 0.01 | gdd5s7nqgssu9 | select addition_id from fsti_a... | |
31,082 | 30,856 | 0.99 | 0.00 | 0.00 | 2jfqzrxhrm93b | select /*+ rule */ c.name, u.... | |
21,660 | 1,111 | 0.05 | 0.00 | 0.00 | 8r32rk7uxxkdb | select app_type from res_appli... | |
17,020 | 17,020 | 1.00 | 0.00 | 0.00 | a0u5858g45m8n | select count(1) from dual wher... | |
12,029 | 12,029 | 1.00 | 0.00 | 0.00 | cgrsx2689bca4 | select count(1) from dual wher... | |
12,000 | 40 | 0.00 | 0.00 | 0.00 | dn76n760vxs8b | Insert Into Prod_Fz_Qyzj_Rtp_S... | |
11,452 | 11,333 | 0.99 | 0.00 | 0.00 | dxy8awsx01f1x | update PERF_HOST_STORAGE_DAY_M... |
Back to SQL Statistics
Back to Top
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
140,925 | 140,928 | 13.83 | 2aadvhw5r7gfc | select name, ip from CONF_APP_... | |
135,836 | 136,038 | 13.33 | 3tjv3vcff9nj1 | select net_area_id from CONF_A... | |
99,186 | 99,186 | 9.73 | gdd5s7nqgssu9 | select addition_id from fsti_a... | |
99,185 | 99,186 | 9.73 | anwkyts985z77 | delete from fsti_alarm_trans w... | |
31,082 | 31,082 | 3.05 | 2jfqzrxhrm93b | select /*+ rule */ c.name, u.... | |
21,658 | 21,660 | 2.13 | 8r32rk7uxxkdb | select app_type from res_appli... | |
12,000 | 12,000 | 1.18 | dn76n760vxs8b | Insert Into Prod_Fz_Qyzj_Rtp_S... | |
11,454 | 11,452 | 1.12 | dxy8awsx01f1x | update PERF_HOST_STORAGE_DAY_M... | |
11,447 | 11,450 | 1.12 | f54tpujxcbnc7 | update PERF_HOST_STORAGE_DAY_A... | |
11,444 | 11,444 | 1.12 | gqrmhgpq33afw | update PERF_HOST_STORAGE_DAY_M... | |
11,262 | 11,266 | 1.11 | d2qfc3zqhckw7 | select PERF_HOST_STORAGE_SEQ.n... |
Back to SQL Statistics
Back to Top
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
2,110,080 | 0.12 | 49s332uhbnsma | ** SQL Text Not Available ** |
Back to SQL Statistics
Back to Top
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
491 | 49s332uhbnsma | ** SQL Text Not Available ** | ||
467 | 4,056 | c42pznb7vnkvg | update RES_HOST_PROCESS set ne... | |
79 | 129 | 0fr8zhn4ymu3v | select intcol#, type, flags, l... | |
76 | 19 | cjk1ffy5kmm5s | select obj# from oid$ where us... | |
69 | 296 | 5j90cjhgfvsj8 | insert into FSTI_ALARM_HISTORY... | |
63 | 21 | g3wrkmxkxzhf2 | select cols, audit$, textlengt... | |
61 | 1 | d1m8g1r0jntpj | begin :vsn_min... | |
58 | 129 | 32bhha21dkv0v | select col#, intcol#, charseti... | |
56 | 1 | a20djcagc6vp4 | declare policy ... | |
48 | 3 | 5wc2915k44m38 | select user#, type# from user$... | |
44 | 38 | 9g485acn2n30m | select col#, intcol#, reftyp, ... | |
44 | 38 | 9rfqm06xmuwu0 | select intcol#, toid, versio... | |
44 | 38 | f3g84j69n0tjh | select col#, intcol#, ntab# fr... | |
37 | 345 | 04xtrk7uyhknh | select obj#, type#, ctime, mti... | |
37 | 4 | 5t7dh3thzzrfh | begin dbms_rcvm... | |
32 | 1,100 | 2q93zsrvbdw48 | select grantee#, privilege#, n... | |
32 | 1,100 | 6aq34nj2zb2n7 | select col#, grantee#, privi... | |
31 | 1,767 | 6769wyy3yf66f | select pos#, intcol#, col#, sp... | |
29 | 1,829 | 8cx33vubmug6b | insert into FSTI_ALARM_HISTORY... | |
28 | 21 | dpvv2ua0tfjcv | select cachedblk, cachehit, ... | |
28 | 1,281 | gt22pnh04wan8 | UPDATE FSTI_ALARM_CURRENT SET ... | |
22 | 180 | 7tc5u8t3mmzgf | select cachedblk, cachehit, ... |
Back to SQL Statistics
Back to Top
Cluster Wait Time (s) | CWT % of Elapsd Time | Elapsed Time(s) | CPU Time(s) | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
152.27 | 13.55 | 1,123.48 | 378.06 | 486 | 6acqpn0qjrctq | SQL Loader Conventional Path Load | INSERT INTO PROD_FZ_WAP_WAP20T... |
8.58 | 75.12 | 11.42 | 0.88 | 798 | 1qvjz6ud03wfm | insert into prod_res_ne_detect... | |
2.51 | 6.73 | 37.27 | 36.72 | 140,928 | 2aadvhw5r7gfc | select name, ip from CONF_APP_... | |
2.27 | 29.79 | 7.62 | 7.56 | 11,450 | f54tpujxcbnc7 | update PERF_HOST_STORAGE_DAY_A... | |
2.23 | 32.13 | 6.95 | 6.91 | 11,452 | dxy8awsx01f1x | update PERF_HOST_STORAGE_DAY_M... | |
2.12 | 33.06 | 6.42 | 6.42 | 10,057 | 98vhmww9mb31y | update PERF_HOST_STORAGE_HOUR_... | |
2.11 | 30.63 | 6.89 | 6.89 | 11,444 | gqrmhgpq33afw | update PERF_HOST_STORAGE_DAY_M... | |
2.08 | 30.55 | 6.81 | 6.77 | 10,075 | gaskb581vzwb1 | update PERF_HOST_STORAGE_HOUR_... | |
2.01 | 31.70 | 6.33 | 6.33 | 10,077 | 2uxqqt4t7jwn2 | update PERF_HOST_STORAGE_HOUR_... | |
1.54 | 33.43 | 4.60 | 4.42 | 7,674 | btsd8mnm607a5 | update PERF_ORACLE_ROLLBACK_HO... | |
1.39 | 30.98 | 4.47 | 4.36 | 7,682 | 52rh4tudahskr | update PERF_ORACLE_ROLLBACK_HO... | |
1.37 | 27.39 | 5.01 | 4.94 | 7,668 | 9hxy7mq2w4mxc | update PERF_ORACLE_ROLLBACK_HO... | |
1.32 | 24.36 | 5.40 | 5.40 | 8,910 | gm0926zq11v76 | update PERF_ORACLE_ROLLBACK_DA... | |
1.29 | 20.74 | 6.22 | 5.59 | 4,056 | c42pznb7vnkvg | update RES_HOST_PROCESS set ne... | |
1.25 | 27.02 | 4.62 | 4.60 | 8,888 | 9827cwgknbxj0 | update PERF_ORACLE_ROLLBACK_DA... | |
1.23 | 25.81 | 4.75 | 4.70 | 8,878 | a1wt2f5ha4z3x | update PERF_ORACLE_ROLLBACK_DA... | |
1.01 | 36.72 | 2.76 | 2.75 | 3,883 | 9yuu4zjfdunym | update PERF_INTERFACE_DAY_MIN ... | |
1.01 | 2.48 | 40.78 | 36.44 | 1,829 | 8cx33vubmug6b | insert into FSTI_ALARM_HISTORY... | |
1.01 | 33.87 | 2.97 | 2.97 | 3,892 | ck8ffq53n5hra | update PERF_INTERFACE_DAY_AVG ... | |
0.97 | 35.34 | 2.75 | 2.71 | 3,904 | dg1u46j2f9u7x | update PERF_INTERFACE_DAY_MAX ... | |
0.78 | 2.83 | 27.60 | 23.32 | 1,700 | dtka5gpfn2pk3 | update fsti_alarm_trans set la... | |
0.77 | 2.63 | 29.46 | 26.48 | 1,281 | gt22pnh04wan8 | UPDATE FSTI_ALARM_CURRENT SET ... | |
0.65 | 13.58 | 4.78 | 2.07 | 4 | 6bbzx8bac652f | JDBC Thin Client | SELECT t.*, rownum from (SELEC... |
0.63 | 3.41 | 18.43 | 18.41 | 136,038 | 3tjv3vcff9nj1 | select net_area_id from CONF_A... | |
0.50 | 0.04 | 1,425.85 | 1,425.92 | 178 | 4a6cx9kqm5r5h | select Identifier, Node, NodeA... | |
0.48 | 0.44 | 110.38 | 110.38 | 65 | 3vzt7yt9tja88 | SELECT * FROM ( SELE... | |
0.48 | 0.47 | 100.62 | 100.62 | 66 | 5spcdusnvyta6 | Select Count(1) From Res_Servi... | |
0.47 | 0.43 | 108.13 | 108.13 | 68 | 9u68cq2puf064 | Select Count(1) From Res_Servi... | |
0.46 | 0.33 | 138.77 | 138.75 | 68 | 3rn43k5skpggf | SELECT * FROM ( SELE... | |
0.41 | 1.49 | 27.28 | 23.32 | 1,700 | grk0hgasghg0a | delete from fsti_alarm_trans w... | |
0.40 | 1.46 | 27.59 | 23.85 | 1,700 | cv89mwmx833bg | select a.IDENTIFIER, a.SERIAL,... | |
0.40 | 0.01 | 7,883.79 | 7,929.70 | 42 | c4s83719x437j | select rc.Id as city_id, rn.p... | |
0.38 | 0.37 | 102.07 | 102.07 | 64 | c9f8hcmhypvmq | Select severity, count(1) as a... | |
0.37 | 0.37 | 100.45 | 100.45 | 65 | 2ynctjsphswxs | Select severity, count(1) as a... | |
0.29 | 3.59 | 8.12 | 7.02 | 296 | 5j90cjhgfvsj8 | insert into FSTI_ALARM_HISTORY... | |
0.19 | 4.09 | 4.61 | 4.61 | 31,082 | 2jfqzrxhrm93b | select /*+ rule */ c.name, u.... | |
0.15 | 0.01 | 1,471.63 | 1,247.18 | 99,186 | gdd5s7nqgssu9 | select addition_id from fsti_a... | |
0.14 | 0.03 | 425.32 | 425.30 | 66 | 1dg7znt919y4p | Select c.Id As cityid, c.cname... | |
0.14 | 0.04 | 309.52 | 309.48 | 73 | g269uhxq6ubty | Select c.Id As cityid, c.cname... | |
0.12 | 0.65 | 18.65 | 18.65 | 12,000 | dn76n760vxs8b | Insert Into Prod_Fz_Qyzj_Rtp_S... | |
0.12 | 20.81 | 0.57 | 0.57 | 4,784 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
0.12 | 0.01 | 1,477.45 | 1,248.99 | 99,186 | anwkyts985z77 | delete from fsti_alarm_trans w... | |
0.04 | 11.25 | 0.35 | 0.35 | 112 | bd13sdj0ty0q4 | SQL Loader Conventional Path Load | SELECT 'X' FROM SYS.ALL_OBJECT... |
0.03 | 0.06 | 45.97 | 45.97 | 4 | 43xtg2pbayp29 | DECLARE job BINARY_INTEGER := ... | |
0.02 | 6.68 | 0.23 | 0.18 | 22 | 130dvvr5s8bgn | select obj#, dataobj#, part#... | |
0.01 | 1.40 | 0.77 | 0.77 | 3 | dr5yapf51hwkd | JDBC Thin Client | SELECT /*+ rule */ rownum, db.... |
0.01 | 0.59 | 1.82 | 1.81 | 11,266 | d2qfc3zqhckw7 | select PERF_HOST_STORAGE_SEQ.n... | |
0.01 | 3.94 | 0.26 | 0.25 | 28 | c3zymn7x3k6wy | select obj#, dataobj#, part#... | |
0.01 | 33.98 | 0.02 | 0.01 | 3 | 5wc2915k44m38 | select user#, type# from user$... | |
0.01 | 26.34 | 0.03 | 0.03 | 223 | 8swypbbr0m372 | select order#, columns, types ... | |
0.01 | 0.42 | 1.51 | 1.51 | 9,020 | c0ffn9zgw6rk6 | select PERF_ORACLE_ROLLBACK_SE... |
Back to SQL Statistics
Back to Top
Back to SQL Statistics
Back to Top
Statistic | Total | per Second | per Trans | |
---|---|---|---|---|
CPU used by this session | 1,531,866 | 430.19 | 6.43 | |
CPU used when call started | 1,524,558 | 428.14 | 6.40 | |
CR blocks created | 2,210 | 0.62 | 0.01 | |
Cached Commit SCN referenced | 1,940 | 0.54 | 0.01 | |
Commit SCN cached | 1 | 0.00 | 0.00 | |
DB time | 2,860,688 | 803.37 | 12.00 | |
DBWR checkpoint buffers written | 466,910 | 131.12 | 1.96 | |
DBWR checkpoints | 310 | 0.09 | 0.00 | |
DBWR fusion writes | 114,686 | 32.21 | 0.48 | |
DBWR object drop buffers written | 40 | 0.01 | 0.00 | |
DBWR parallel query checkpoint buffers written | 2,646 | 0.74 | 0.01 | |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 | |
DBWR tablespace checkpoint buffers written | 177 | 0.05 | 0.00 | |
DBWR thread checkpoint buffers written | 73,167 | 20.55 | 0.31 | |
DBWR transaction table writes | 489 | 0.14 | 0.00 | |
DBWR undo block writes | 135,841 | 38.15 | 0.57 | |
DDL statements parallelized | 0 | 0.00 | 0.00 | |
DFO trees parallelized | 12 | 0.00 | 0.00 | |
DML statements parallelized | 0 | 0.00 | 0.00 | |
Misses for writing mapping | 0 | 0.00 | 0.00 | |
PX local messages recv'd | 30 | 0.01 | 0.00 | |
PX local messages sent | 30 | 0.01 | 0.00 | |
PX remote messages recv'd | 471 | 0.13 | 0.00 | |
PX remote messages sent | 502 | 0.14 | 0.00 | |
Parallel operations downgraded to serial | 1,082 | 0.30 | 0.00 | |
Parallel operations not downgraded | 12 | 0.00 | 0.00 | |
RowCR - row contention | 11 | 0.00 | 0.00 | |
RowCR attempts | 1,914 | 0.54 | 0.01 | |
RowCR hits | 1,864 | 0.52 | 0.01 | |
SMON posted for dropping temp segment | 0 | 0.00 | 0.00 | |
SMON posted for instance recovery | 0 | 0.00 | 0.00 | |
SMON posted for undo segment recovery | 0 | 0.00 | 0.00 | |
SMON posted for undo segment shrink | 21 | 0.01 | 0.00 | |
SQL*Net roundtrips to/from client | 6,932,692 | 1,946.91 | 29.09 | |
SQL*Net roundtrips to/from dblink | 0 | 0.00 | 0.00 | |
active txn count during cleanout | 142,276 | 39.96 | 0.60 | |
application wait time | 6,053 | 1.70 | 0.03 | |
background checkpoints completed | 17 | 0.00 | 0.00 | |
background checkpoints started | 17 | 0.00 | 0.00 | |
background timeouts | 14,871 | 4.18 | 0.06 | |
branch node splits | 90 | 0.03 | 0.00 | |
buffer is not pinned count | 72,041,359 | 20,231.40 | 302.28 | |
buffer is pinned count | 408,390,652 | 114,688.51 | 1,713.59 | |
bytes received via SQL*Net from client | 1,341,201,611 | 376,650.19 | 5,627.64 | |
bytes received via SQL*Net from dblink | 0 | 0.00 | 0.00 | |
bytes sent via SQL*Net to client | 27,121,028,698 | 7,616,409.45 | 113,798.98 | |
bytes sent via SQL*Net to dblink | 0 | 0.00 | 0.00 | |
calls to get snapshot scn: kcmgss | 2,372,291 | 666.21 | 9.95 | |
calls to kcmgas | 1,180,236 | 331.45 | 4.95 | |
calls to kcmgcs | 128,471 | 36.08 | 0.54 | |
change write time | 6,893 | 1.94 | 0.03 | |
cleanout - number of ktugct calls | 159,287 | 44.73 | 0.67 | |
cleanouts and rollbacks - consistent read gets | 217 | 0.06 | 0.00 | |
cleanouts only - consistent read gets | 354 | 0.10 | 0.00 | |
cluster key scan block gets | 69,191 | 19.43 | 0.29 | |
cluster key scans | 52,095 | 14.63 | 0.22 | |
cluster wait time | 23,632 | 6.64 | 0.10 | |
commit batch performed | 0 | 0.00 | 0.00 | |
commit batch requested | 0 | 0.00 | 0.00 | |
commit batch/immediate performed | 32,071 | 9.01 | 0.13 | |
commit batch/immediate requested | 32,071 | 9.01 | 0.13 | |
commit cleanout failures: block lost | 1,002 | 0.28 | 0.00 | |
commit cleanout failures: buffer being written | 9 | 0.00 | 0.00 | |
commit cleanout failures: callback failure | 9,742 | 2.74 | 0.04 | |
commit cleanout failures: cannot pin | 130 | 0.04 | 0.00 | |
commit cleanouts | 1,362,296 | 382.57 | 5.72 | |
commit cleanouts successfully completed | 1,351,413 | 379.52 | 5.67 | |
commit immediate performed | 32,071 | 9.01 | 0.13 | |
commit immediate requested | 32,071 | 9.01 | 0.13 | |
commit txn count during cleanout | 62,280 | 17.49 | 0.26 | |
concurrency wait time | 2,483 | 0.70 | 0.01 | |
consistent changes | 8,879 | 2.49 | 0.04 | |
consistent gets | 1,116,598,034 | 313,574.68 | 4,685.21 | |
consistent gets - examination | 3,064,226 | 860.53 | 12.86 | |
consistent gets direct | 3,410 | 0.96 | 0.01 | |
consistent gets from cache | 1,116,596,194 | 313,574.16 | 4,685.20 | |
current blocks converted for CR | 1 | 0.00 | 0.00 | |
cursor authentications | 12,633 | 3.55 | 0.05 | |
data blocks consistent reads - undo records applied | 7,966 | 2.24 | 0.03 | |
db block changes | 13,554,154 | 3,806.42 | 56.87 | |
db block gets | 17,830,008 | 5,007.21 | 74.81 | |
db block gets direct | 158 | 0.04 | 0.00 | |
db block gets from cache | 17,829,850 | 5,007.16 | 74.81 | |
deferred (CURRENT) block cleanout applications | 848,891 | 238.39 | 3.56 | |
dirty buffers inspected | 549 | 0.15 | 0.00 | |
drop segment calls in space pressure | 0 | 0.00 | 0.00 | |
enqueue conversions | 1,684 | 0.47 | 0.01 | |
enqueue deadlocks | 0 | 0.00 | 0.00 | |
enqueue releases | 795,726 | 223.46 | 3.34 | |
enqueue requests | 795,761 | 223.47 | 3.34 | |
enqueue timeouts | 41 | 0.01 | 0.00 | |
enqueue waits | 8,071 | 2.27 | 0.03 | |
exchange deadlocks | 182 | 0.05 | 0.00 | |
execute count | 1,200,473 | 337.13 | 5.04 | |
failed probes on index block reclamation | 0 | 0.00 | 0.00 | |
free buffer inspected | 693,980 | 194.89 | 2.91 | |
free buffer requested | 727,841 | 204.40 | 3.05 | |
gc CPU used by this session | 62,134 | 17.45 | 0.26 | |
gc blocks lost | 0 | 0.00 | 0.00 | |
gc cr block build time | 100 | 0.03 | 0.00 | |
gc cr block flush time | 102 | 0.03 | 0.00 | |
gc cr block receive time | 1,785 | 0.50 | 0.01 | |
gc cr block send time | 663 | 0.19 | 0.00 | |
gc cr blocks received | 26,177 | 7.35 | 0.11 | |
gc cr blocks served | 68,952 | 19.36 | 0.29 | |
gc current block flush time | 58 | 0.02 | 0.00 | |
gc current block pin time | 1,731 | 0.49 | 0.01 | |
gc current block receive time | 20,268 | 5.69 | 0.09 | |
gc current block send time | 9,409 | 2.64 | 0.04 | |
gc current blocks received | 296,691 | 83.32 | 1.24 | |
gc current blocks served | 1,061,111 | 297.99 | 4.45 | |
gc local grants | 333,748 | 93.73 | 1.40 | |
gc remote grants | 68,586 | 19.26 | 0.29 | |
gcs messages sent | 1,439,169 | 404.16 | 6.04 | |
ges messages sent | 114,277 | 32.09 | 0.48 | |
global enqueue get time | 5,100 | 1.43 | 0.02 | |
global enqueue gets async | 20,662 | 5.80 | 0.09 | |
global enqueue gets sync | 532,998 | 149.68 | 2.24 | |
global enqueue releases | 545,955 | 153.32 | 2.29 | |
global undo segment hints helped | 0 | 0.00 | 0.00 | |
heap block compress | 2,551 | 0.72 | 0.01 | |
hot buffers moved to head of LRU | 283,813 | 79.70 | 1.19 | |
immediate (CR) block cleanout applications | 571 | 0.16 | 0.00 | |
immediate (CURRENT) block cleanout applications | 54,549 | 15.32 | 0.23 | |
index crx upgrade (found) | 1,469 | 0.41 | 0.01 | |
index crx upgrade (positioned) | 186,215 | 52.29 | 0.78 | |
index fast full scans (full) | 638 | 0.18 | 0.00 | |
index fast full scans (rowid ranges) | 0 | 0.00 | 0.00 | |
index fetch by key | 3,062,357 | 860.00 | 12.85 | |
index scans kdiixs1 | 327,898 | 92.08 | 1.38 | |
leaf node 90-10 splits | 165 | 0.05 | 0.00 | |
leaf node splits | 18,538 | 5.21 | 0.08 | |
lob reads | 4,366 | 1.23 | 0.02 | |
lob writes | 191 | 0.05 | 0.00 | |
lob writes unaligned | 190 | 0.05 | 0.00 | |
local undo segment hints helped | 0 | 0.00 | 0.00 | |
local undo segment hints were stale | 0 | 0.00 | 0.00 | |
logons cumulative | 3,232 | 0.91 | 0.01 | |
messages received | 563,324 | 158.20 | 2.36 | |
messages sent | 563,260 | 158.18 | 2.36 | |
no buffer to keep pinned count | 0 | 0.00 | 0.00 | |
no work - consistent read gets | 1,112,537,015 | 312,434.22 | 4,668.17 | |
opened cursors cumulative | 944,849 | 265.34 | 3.96 | |
parse count (failures) | 5 | 0.00 | 0.00 | |
parse count (hard) | 23,673 | 6.65 | 0.10 | |
parse count (total) | 1,018,993 | 286.16 | 4.28 | |
parse time cpu | 9,531 | 2.68 | 0.04 | |
parse time elapsed | 10,874 | 3.05 | 0.05 | |
physical read IO requests | 129,181 | 36.28 | 0.54 | |
physical read bytes | 1,062,723,584 | 298,445.09 | 4,459.15 | |
physical read total IO requests | 344,717 | 96.81 | 1.45 | |
physical read total bytes | 97,554,984,448 | 27,396,405.72 | 409,337.64 | |
physical read total multi block requests | 179,845 | 50.51 | 0.75 | |
physical reads | 129,170 | 36.27 | 0.54 | |
physical reads cache | 114,123 | 32.05 | 0.48 | |
physical reads cache prefetch | 549 | 0.15 | 0.00 | |
physical reads direct | 15,604 | 4.38 | 0.07 | |
physical reads direct (lob) | 3,409 | 0.96 | 0.01 | |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 | |
physical reads prefetch warmup | 0 | 0.00 | 0.00 | |
physical write IO requests | 307,948 | 86.48 | 1.29 | |
physical write bytes | 4,831,813,632 | 1,356,920.18 | 20,274.14 | |
physical write total IO requests | 887,716 | 249.30 | 3.72 | |
physical write total bytes | 15,252,521,984 | 4,283,371.91 | 63,999.10 | |
physical write total multi block requests | 604,345 | 169.72 | 2.54 | |
physical writes | 589,821 | 165.64 | 2.47 | |
physical writes direct | 2,711 | 0.76 | 0.01 | |
physical writes direct (lob) | 92 | 0.03 | 0.00 | |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 | |
physical writes from cache | 587,110 | 164.88 | 2.46 | |
physical writes non checkpoint | 520,646 | 146.21 | 2.18 | |
pinned buffers inspected | 23 | 0.01 | 0.00 | |
prefetch clients - default | 0 | 0.00 | 0.00 | |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 | |
prefetched blocks aged out before use | 2 | 0.00 | 0.00 | |
process last non-idle time | 3,615 | 1.02 | 0.02 | |
queries parallelized | 12 | 0.00 | 0.00 | |
recovery blocks read | 0 | 0.00 | 0.00 | |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 | |
recursive calls | 2,088,279 | 586.45 | 8.76 | |
recursive cpu usage | 18,730 | 5.26 | 0.08 | |
redo blocks read for recovery | 0 | 0.00 | 0.00 | |
redo blocks written | 6,727,550 | 1,889.30 | 28.23 | |
redo buffer allocation retries | 656 | 0.18 | 0.00 | |
redo entries | 7,357,926 | 2,066.33 | 30.87 | |
redo log space requests | 663 | 0.19 | 0.00 | |
redo log space wait time | 72 | 0.02 | 0.00 | |
redo ordering marks | 130,890 | 36.76 | 0.55 | |
redo size | 3,237,675,532 | 909,237.73 | 13,585.18 | |
redo subscn max counts | 8,431 | 2.37 | 0.04 | |
redo synch time | 18,056 | 5.07 | 0.08 | |
redo synch writes | 270,536 | 75.97 | 1.14 | |
redo wastage | 95,431,668 | 26,800.11 | 400.43 | |
redo write time | 15,445 | 4.34 | 0.06 | |
redo writer latching time | 14 | 0.00 | 0.00 | |
redo writes | 265,192 | 74.47 | 1.11 | |
rollback changes - undo records applied | 64,198 | 18.03 | 0.27 | |
rollbacks only - consistent read gets | 2,525 | 0.71 | 0.00 | 0.00 |
workarea executions - onepass | 0 | 0.00 | 0.00 | |
workarea executions - optimal | 32,303 | 9.07 | 0.14 | |
write clones created in background | 42 | 0.01 | 0.00 | |
write clones created in foreground | 12 | 0.00 | 0.00 |
Back to Instance Activity Statistics
Back to Top
Statistic | Begin Value | End Value |
---|---|---|
session cursor cache count | 67,953,631 | 68,013,645 |
opened cursors current | 842 | 789 |
workarea memory allocated | 10,010 | 7,179 |
logons current | 1,214 | 1,123 |
Back to Instance Activity Statistics
Back to Top
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 17 | 17.19 |
Back to Instance Activity Statistics
Back to Top
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
OPER_DATA | 68,758 | 19 | 5.15 | 1.00 | 180,841 | 51 | 597 | 4.17 |
OPER_INDEX_DATA | 50,074 | 14 | 5.81 | 1.00 | 92,235 | 26 | 183 | 15.14 |
UNDOTBS1 | 10 | 0 | 5.00 | 1.00 | 10,632 | 3 | 28 | 0.36 |
PERF_DATA | 883 | 0 | 5.90 | 1.00 | 9,717 | 3 | 35 | 7.43 |
RES_CONF_DATA | 3,726 | 1 | 0.52 | 1.01 | 4,906 | 1 | 347 | 1.50 |
PERF_INDEX_DATA | 1,873 | 1 | 5.22 | 1.00 | 3,497 | 1 | 76 | 0.66 |
ITCOL_INDEX_DATA | 1,220 | 0 | 5.35 | 1.00 | 1,351 | 0 | 23 | 1.74 |
ITCOL_DATA | 632 | 0 | 6.68 | 1.00 | 1,695 | 0 | 0 | 0.00 |
ALM_DATA | 285 | 0 | 5.12 | 1.00 | 1,110 | 0 | 4 | 5.00 |
ALM_INDEX_DATA | 157 | 0 | 4.46 | 1.00 | 918 | 0 | 1 | 0.00 |
SYSAUX | 489 | 0 | 3.87 | 1.00 | 323 | 0 | 0 | 0.00 |
FLOW_DATA | 594 | 0 | 1.11 | 1.00 | 18 | 0 | 0 | 0.00 |
RES_CONF_INDEX_DATA | 73 | 0 | 4.66 | 1.00 | 323 | 0 | 0 | 0.00 |
SYSTEM | 168 | 0 | 5.60 | 1.00 | 218 | 0 | 4 | 0.00 |
REP_DATA | 117 | 0 | 0.00 | 1.00 | 38 | 0 | 0 | 0.00 |
TEMP | 50 | 0 | 3.60 | 11.14 | 0 | 0 | 5 | 10.00 |
REP_INDEX_DATA | 18 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
FLOW_INDEX_DATA | 9 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
UNDOTBS2 | 9 | 0 | 0.00 | 1.00 | 9 | 0 | 10 | 0.00 |
USERS | 9 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
VAM_DATA | 9 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
VAM_INDX_DATA | 9 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|---|
ALM_DATA | +DG/vam/datafile/alm_data01.dbf | 17 | 0 | 4.12 | 1.00 | 364 | 0 | 1 | 0.00 |
ALM_DATA | +DG/vam/datafile/alm_data02.dbf | 268 | 0 | 5.19 | 1.00 | 746 | 0 | 3 | 6.67 |
ALM_INDEX_DATA | +DG/vam/datafile/alm_index_data01.dbf | 45 | 0 | 5.56 | 1.00 | 463 | 0 | 1 | 0.00 |
ALM_INDEX_DATA | +DG/vam/datafile/alm_index_data02.dbf | 112 | 0 | 4.02 | 1.00 | 455 | 0 | 0 | 0.00 |
FLOW_DATA | +DG/vam/datafile/flow_data_01.dbf | 99 | 0 | 1.01 | 1.00 | 9 | 0 | 0 | 0.00 |
FLOW_DATA | +DG/vam/datafile/flow_data_02.dbf | 495 | 0 | 1.13 | 1.00 | 9 | 0 | 0 | 0.00 |
FLOW_INDEX_DATA | +DG/vam/datafile/flow_index_data_01.dbf | 9 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
ITCOL_DATA | +DG/vam/datafile/itcol_data_01.dbf | 179 | 0 | 7.88 | 1.00 | 708 | 0 | 0 | 0.00 |
ITCOL_DATA | +DG/vam/datafile/itcol_data_02.dbf | 284 | 0 | 6.80 | 1.00 | 716 | 0 | 0 | 0.00 |
ITCOL_DATA | +DG/vam/datafile/itcol_data_03.dbf | 169 | 0 | 5.21 | 1.00 | 271 | 0 | 0 | 0.00 |
ITCOL_INDEX_DATA | +DG/vam/datafile/itcol_index_data_01.dbf | 165 | 0 | 5.82 | 1.00 | 191 | 0 | 1 | 0.00 |
ITCOL_INDEX_DATA | +DG/vam/datafile/itcol_index_data_02.dbf | 143 | 0 | 7.55 | 1.00 | 169 | 0 | 1 | 0.00 |
ITCOL_INDEX_DATA | +DG/vam/datafile/itcol_index_data_03.dbf | 104 | 0 | 6.63 | 1.00 | 161 | 0 | 1 | 0.00 |
ITCOL_INDEX_DATA | +DG/vam/datafile/itcol_index_data_04.dbf | 136 | 0 | 4.71 | 1.00 | 159 | 0 | 6 | 3.33 |
ITCOL_INDEX_DATA | +DG/vam/datafile/itcol_index_data_06.dbf | 160 | 0 | 4.19 | 1.00 | 184 | 0 | 4 | 0.00 |
ITCOL_INDEX_DATA | +DG/vam/datafile/itcol_index_data_07.dbf | 237 | 0 | 5.82 | 1.00 | 206 | 0 | 4 | 5.00 |
ITCOL_INDEX_DATA | +DG/vam/datafile/itcol_index_data_08.dbf | 176 | 0 | 4.55 | 1.00 | 188 | 0 | 5 | 0.00 |
ITCOL_INDEX_DATA | +DG/vam/datafile/itcol_index_data_09.dbf | 99 | 0 | 3.13 | 1.00 | 93 | 0 | 1 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data01.dbf | 321 | 0 | 6.23 | 1.00 | 872 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data02.dbf | 436 | 0 | 5.48 | 1.00 | 967 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data03.dbf | 345 | 0 | 5.51 | 1.00 | 888 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data04.dbf | 308 | 0 | 5.36 | 1.00 | 810 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data05.dbf | 330 | 0 | 6.18 | 1.00 | 817 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data06.dbf | 333 | 0 | 5.74 | 1.00 | 832 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data07.dbf | 296 | 0 | 5.14 | 1.00 | 1,113 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data08.dbf | 342 | 0 | 5.44 | 1.00 | 930 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data09.dbf | 307 | 0 | 5.77 | 1.00 | 920 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data10.dbf | 317 | 0 | 5.87 | 1.00 | 1,609 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data100.dbf | 246 | 0 | 4.72 | 1.00 | 692 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data101.dbf | 403 | 0 | 4.69 | 1.00 | 789 | 0 | 70 | 1.00 |
OPER_DATA | +DG/vam/datafile/oper_data102.dbf | 302 | 0 | 5.46 | 1.00 | 597 | 0 | 1 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data103.dbf | 317 | 0 | 4.92 | 1.00 | 914 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data104.dbf | 288 | 0 | 4.69 | 1.00 | 462 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data105.dbf | 286 | 0 | 5.31 | 1.00 | 443 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data106.dbf | 284 | 0 | 4.26 | 1.00 | 629 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data107.dbf | 284 | 0 | 3.49 | 1.00 | 480 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data108.dbf | 279 | 0 | 4.80 | 1.00 | 457 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data109.dbf | 267 | 0 | 4.34 | 1.00 | 511 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data11.dbf | 307 | 0 | 5.34 | 1.00 | 927 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data110.dbf | 276 | 0 | 5.33 | 1.00 | 865 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data111.dbf | 277 | 0 | 3.86 | 1.00 | 397 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data112.dbf | 297 | 0 | 4.95 | 1.00 | 427 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data113.dbf | 294 | 0 | 5.27 | 1.00 | 753 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data114.dbf | 311 | 0 | 4.69 | 1.00 | 577 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data115.dbf | 287 | 0 | 4.49 | 1.00 | 508 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data116.dbf | 306 | 0 | 4.41 | 1.00 | 491 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data117.dbf | 300 | 0 | 4.50 | 1.00 | 423 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data118.dbf | 297 | 0 | 4.24 | 1.00 | 445 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data119.dbf | 313 | 0 | 4.79 | 1.00 | 475 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data12.dbf | 299 | 0 | 5.65 | 1.00 | 900 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data120.dbf | 293 | 0 | 4.54 | 1.00 | 401 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data121.dbf | 270 | 0 | 4.78 | 1.00 | 385 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data122.dbf | 269 | 0 | 5.09 | 1.00 | 760 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data123.dbf | 277 | 0 | 4.73 | 1.00 | 436 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data124.dbf | 257 | 0 | 4.94 | 1.00 | 438 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data125.dbf | 261 | 0 | 4.41 | 1.00 | 420 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data126.dbf | 447 | 0 | 5.32 | 1.00 | 1,163 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data127.dbf | 384 | 0 | 5.76 | 1.00 | 1,130 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data128.dbf | 451 | 0 | 5.21 | 1.00 | 1,246 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data129.dbf | 480 | 0 | 5.10 | 1.00 | 1,376 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data13.dbf | 280 | 0 | 5.36 | 1.00 | 830 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data130.dbf | 472 | 0 | 5.40 | 1.00 | 1,428 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data131.dbf | 492 | 0 | 5.22 | 1.00 | 1,431 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data132.dbf | 473 | 0 | 5.33 | 1.00 | 1,159 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data133.dbf | 443 | 0 | 5.35 | 1.00 | 1,201 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data134.dbf | 441 | 0 | 5.12 | 1.00 | 1,466 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data135.dbf | 452 | 0 | 5.86 | 1.00 | 1,138 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data136.dbf | 463 | 0 | 5.16 | 1.00 | 1,156 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data137.dbf | 545 | 0 | 4.90 | 1.00 | 1,185 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data138.dbf | 465 | 0 | 4.71 | 1.00 | 1,080 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data139.dbf | 482 | 0 | 5.33 | 1.00 | 1,318 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data14.dbf | 297 | 0 | 5.15 | 1.00 | 851 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data140.dbf | 440 | 0 | 5.52 | 1.00 | 1,512 | 0 | 33 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data141.dbf | 309 | 0 | 4.56 | 1.00 | 1,094 | 0 | 174 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data142.dbf | 355 | 0 | 4.65 | 1.00 | 1,321 | 0 | 110 | 0.09 |
OPER_DATA | +DG/vam/datafile/oper_data143.dbf | 340 | 0 | 4.18 | 1.00 | 1,084 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data144.dbf | 448 | 0 | 6.03 | 1.00 | 1,558 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data145.dbf | 421 | 0 | 5.01 | 1.00 | 1,410 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data146.dbf | 404 | 0 | 5.17 | 1.00 | 1,346 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data147.dbf | 439 | 0 | 4.69 | 1.00 | 1,372 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data148.dbf | 411 | 0 | 5.38 | 1.00 | 928 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data149.dbf | 410 | 0 | 5.07 | 1.00 | 861 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data15.dbf | 309 | 0 | 5.34 | 1.00 | 986 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data150.dbf | 419 | 0 | 5.23 | 1.00 | 1,021 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data151.dbf | 401 | 0 | 4.69 | 1.00 | 1,070 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data152.dbf | 448 | 0 | 5.00 | 1.00 | 946 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data153.dbf | 409 | 0 | 4.77 | 1.00 | 823 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data154.dbf | 387 | 0 | 5.14 | 1.00 | 920 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data155.dbf | 427 | 0 | 4.92 | 1.00 | 1,489 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data156.dbf | 453 | 0 | 5.08 | 1.00 | 1,456 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data157.dbf | 412 | 0 | 4.73 | 1.00 | 1,177 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data158.dbf | 403 | 0 | 5.86 | 1.00 | 826 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data159.dbf | 392 | 0 | 5.10 | 1.00 | 863 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data16.dbf | 313 | 0 | 5.65 | 1.00 | 923 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data160.dbf | 414 | 0 | 5.87 | 1.00 | 1,042 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data161.dbf | 450 | 0 | 5.67 | 1.00 | 947 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data162.dbf | 431 | 0 | 4.78 | 1.00 | 1,107 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data163.dbf | 415 | 0 | 5.06 | 1.00 | 1,190 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data164.dbf | 415 | 0 | 5.06 | 1.00 | 993 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data165.dbf | 429 | 0 | 5.76 | 1.00 | 1,073 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data166.dbf | 434 | 0 | 5.07 | 1.00 | 947 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data167.dbf | 445 | 0 | 5.53 | 1.00 | 940 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data168.dbf | 454 | 0 | 4.80 | 1.00 | 961 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data169.dbf | 395 | 0 | 4.51 | 1.00 | 870 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data17.dbf | 321 | 0 | 5.48 | 1.00 | 1,299 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data170.dbf | 401 | 0 | 5.36 | 1.00 | 842 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data171.dbf | 416 | 0 | 4.95 | 1.00 | 996 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data172.dbf | 408 | 0 | 5.00 | 1.00 | 973 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data173.dbf | 382 | 0 | 4.74 | 1.00 | 917 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data174.dbf | 393 | 0 | 4.81 | 1.00 | 936 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data176.dbf | 388 | 0 | 4.66 | 1.00 | 765 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data177.dbf | 378 | 0 | 5.42 | 1.00 | 1,103 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data178.dbf | 377 | 0 | 4.85 | 1.00 | 874 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data179.dbf | 334 | 0 | 4.37 | 1.00 | 808 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data18.dbf | 322 | 0 | 5.96 | 1.00 | 948 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data180.dbf | 374 | 0 | 4.92 | 1.00 | 898 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data181.dbf | 439 | 0 | 4.53 | 1.00 | 953 | 0 | 3 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data182.dbf | 467 | 0 | 4.90 | 1.00 | 1,069 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data183.dbf | 396 | 0 | 5.76 | 1.00 | 1,077 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data184.dbf | 351 | 0 | 4.67 | 1.00 | 938 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data185.dbf | 343 | 0 | 5.04 | 1.00 | 985 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data186.dbf | 405 | 0 | 4.74 | 1.00 | 1,185 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data187.dbf | 405 | 0 | 5.36 | 1.00 | 899 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data188.dbf | 410 | 0 | 4.76 | 1.00 | 1,073 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data189.dbf | 421 | 0 | 5.68 | 1.00 | 934 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data19.dbf | 324 | 0 | 5.80 | 1.00 | 1,080 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data190.dbf | 348 | 0 | 4.74 | 1.00 | 1,096 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data191.dbf | 393 | 0 | 5.29 | 1.00 | 1,224 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data192.dbf | 348 | 0 | 5.80 | 1.00 | 979 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data193.dbf | 379 | 0 | 5.59 | 1.00 | 921 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data194.dbf | 361 | 0 | 4.99 | 1.00 | 876 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data195.dbf | 341 | 0 | 4.66 | 1.00 | 851 | 0 | 38 | 3.42 |
OPER_DATA | +DG/vam/datafile/oper_data196.dbf | 376 | 0 | 4.68 | 1.00 | 971 | 0 | 59 | 17.63 |
OPER_DATA | +DG/vam/datafile/oper_data197.dbf | 362 | 0 | 5.72 | 1.00 | 976 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data198.dbf | 350 | 0 | 5.31 | 1.00 | 1,079 | 0 | 109 | 11.38 |
OPER_DATA | +DG/vam/datafile/oper_data199.dbf | 364 | 0 | 5.60 | 1.00 | 886 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data20.dbf | 317 | 0 | 6.50 | 1.00 | 1,095 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data21.dbf | 294 | 0 | 5.34 | 1.00 | 868 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data22.dbf | 328 | 0 | 5.85 | 1.00 | 918 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data23.dbf | 332 | 0 | 5.87 | 1.00 | 901 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data24.dbf | 312 | 0 | 5.26 | 1.00 | 880 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data25.dbf | 328 | 0 | 6.01 | 1.00 | 1,336 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data26.dbf | 333 | 0 | 6.16 | 1.00 | 963 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data27.dbf | 319 | 0 | 4.95 | 1.00 | 868 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data28.dbf | 309 | 0 | 5.11 | 1.00 | 804 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data29.dbf | 332 | 0 | 5.60 | 1.00 | 795 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data30.dbf | 476 | 0 | 3.82 | 1.00 | 767 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data31.dbf | 319 | 0 | 5.64 | 1.00 | 840 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data32.dbf | 320 | 0 | 5.75 | 1.00 | 916 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data33.dbf | 307 | 0 | 6.61 | 1.00 | 846 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data34.dbf | 338 | 0 | 6.07 | 1.00 | 1,042 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data35.dbf | 339 | 0 | 5.60 | 1.00 | 960 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data36.dbf | 314 | 0 | 5.38 | 1.00 | 950 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data37.dbf | 327 | 0 | 5.99 | 1.00 | 942 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data39.dbf | 347 | 0 | 5.42 | 1.00 | 977 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data40.dbf | 353 | 0 | 5.75 | 1.00 | 990 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data41.dbf | 341 | 0 | 6.07 | 1.00 | 893 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data42.dbf | 334 | 0 | 5.60 | 1.00 | 918 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data43.dbf | 337 | 0 | 5.55 | 1.00 | 780 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data44.dbf | 339 | 0 | 5.55 | 1.00 | 1,186 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data45.dbf | 358 | 0 | 5.59 | 1.00 | 1,215 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data46.dbf | 353 | 0 | 5.30 | 1.00 | 940 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data47.dbf | 308 | 0 | 5.16 | 1.00 | 772 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data48.dbf | 313 | 0 | 5.02 | 1.00 | 869 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data49.dbf | 298 | 0 | 4.87 | 1.00 | 831 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data50.dbf | 304 | 0 | 5.33 | 1.00 | 826 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data51.dbf | 345 | 0 | 5.39 | 1.00 | 797 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data52.dbf | 318 | 0 | 5.94 | 1.00 | 781 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data53.dbf | 338 | 0 | 5.74 | 1.00 | 733 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data54.dbf | 310 | 0 | 5.03 | 1.00 | 776 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data55.dbf | 268 | 0 | 4.81 | 1.00 | 618 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data56.dbf | 285 | 0 | 5.65 | 1.00 | 641 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data57.dbf | 287 | 0 | 4.77 | 1.00 | 966 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data58.dbf | 287 | 0 | 5.40 | 1.00 | 748 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data59.dbf | 333 | 0 | 4.86 | 1.00 | 842 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data60.dbf | 329 | 0 | 5.02 | 1.00 | 712 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data61.dbf | 325 | 0 | 5.48 | 1.00 | 772 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data62.dbf | 336 | 0 | 5.09 | 1.00 | 829 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data63.dbf | 346 | 0 | 5.09 | 1.00 | 1,057 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data64.dbf | 328 | 0 | 5.30 | 1.00 | 936 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data65.dbf | 296 | 0 | 5.41 | 1.00 | 952 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data66.dbf | 314 | 0 | 5.13 | 1.00 | 784 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data67.dbf | 329 | 0 | 5.17 | 1.00 | 721 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data68.dbf | 315 | 0 | 4.79 | 1.00 | 767 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data69.dbf | 307 | 0 | 5.37 | 1.00 | 715 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data70.dbf | 298 | 0 | 3.96 | 1.00 | 710 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data71.dbf | 333 | 0 | 4.86 | 1.00 | 781 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data72.dbf | 339 | 0 | 4.90 | 1.00 | 785 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data73.dbf | 307 | 0 | 5.21 | 1.00 | 691 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data74.dbf | 416 | 0 | 4.90 | 1.00 | 955 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data75.dbf | 425 | 0 | 4.99 | 1.00 | 895 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data76.dbf | 435 | 0 | 5.10 | 1.00 | 916 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data77.dbf | 380 | 0 | 4.87 | 1.00 | 934 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data78.dbf | 335 | 0 | 4.99 | 1.00 | 922 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data79.dbf | 368 | 0 | 5.22 | 1.00 | 882 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data80.dbf | 338 | 0 | 5.15 | 1.00 | 856 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data81.dbf | 371 | 0 | 5.61 | 1.00 | 814 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data82.dbf | 315 | 0 | 4.57 | 1.00 | 946 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data83.dbf | 302 | 0 | 4.90 | 1.00 | 988 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data84.dbf | 268 | 0 | 4.70 | 1.00 | 1,011 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data85.dbf | 278 | 0 | 4.82 | 1.00 | 951 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data86.dbf | 404 | 0 | 5.69 | 1.00 | 1,068 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data87.dbf | 297 | 0 | 4.58 | 1.00 | 1,126 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data88.dbf | 296 | 0 | 4.86 | 1.00 | 995 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data89.dbf | 241 | 0 | 4.19 | 1.00 | 1,096 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data90.dbf | 247 | 0 | 4.25 | 1.00 | 1,104 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data91.dbf | 254 | 0 | 4.69 | 1.00 | 927 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data92.dbf | 250 | 0 | 4.40 | 1.00 | 941 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data93.dbf | 246 | 0 | 4.63 | 1.00 | 833 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data94.dbf | 229 | 0 | 4.41 | 1.00 | 760 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data95.dbf | 227 | 0 | 4.63 | 1.00 | 694 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data96.dbf | 238 | 0 | 4.37 | 1.00 | 873 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data97.dbf | 247 | 0 | 4.21 | 1.00 | 810 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data98.dbf | 261 | 0 | 4.21 | 1.00 | 521 | 0 | 0 | 0.00 |
OPER_DATA | +DG/vam/datafile/oper_data99.dbf | 230 | 0 | 4.22 | 1.00 | 636 | 0 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data01.dbf | 2,424 | 1 | 6.00 | 1.00 | 3,976 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data02.dbf | 2,396 | 1 | 5.65 | 1.00 | 4,119 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data03.dbf | 2,251 | 1 | 6.01 | 1.00 | 4,130 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data04.dbf | 2,197 | 1 | 6.05 | 1.00 | 3,975 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data05.dbf | 2,205 | 1 | 6.04 | 1.00 | 3,819 | 1 | 140 | 16.50 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data06.dbf | 2,425 | 1 | 5.64 | 1.00 | 4,027 | 1 | 28 | 15.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data07.dbf | 2,148 | 1 | 5.81 | 1.00 | 3,943 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data08.dbf | 1,902 | 1 | 5.99 | 1.00 | 3,966 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data09.dbf | 2,245 | 1 | 5.59 | 1.00 | 4,233 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data10.dbf | 2,219 | 1 | 5.70 | 1.00 | 4,001 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data11.dbf | 2,177 | 1 | 5.93 | 1.00 | 4,567 | 1 | 1 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data12.dbf | 2,492 | 1 | 6.15 | 1.00 | 5,281 | 1 | 12 | 3.33 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data13.dbf | 2,446 | 1 | 5.75 | 1.00 | 4,656 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data14.dbf | 2,296 | 1 | 5.57 | 1.00 | 4,353 | 1 | 1 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data15.dbf | 2,317 | 1 | 5.87 | 1.00 | 4,369 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data16.dbf | 2,235 | 1 | 5.83 | 1.00 | 4,092 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data17.dbf | 2,407 | 1 | 5.86 | 1.00 | 4,395 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data18.dbf | 2,230 | 1 | 5.53 | 1.00 | 4,215 | 1 | 1 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data19.dbf | 2,256 | 1 | 5.59 | 1.00 | 4,090 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data20.dbf | 2,627 | 1 | 5.83 | 1.00 | 4,378 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data21.dbf | 1,984 | 1 | 5.83 | 1.00 | 3,743 | 1 | 0 | 0.00 |
OPER_INDEX_DATA | +DG/vam/datafile/oper_index_data22.dbf | 2,195 | 1 | 5.60 | 1.00 | 3,907 | 1 | 0 | 0.00 |
PERF_DATA | +DG/vam/datafile/perf_data01.dbf | 691 | 0 | 6.12 | 1.00 | 8,053 | 2 | 32 | 5.00 |
PERF_DATA | +DG/vam/datafile/perf_data02.dbf | 192 | 0 | 5.10 | 1.00 | 1,664 | 0 | 3 | 33.33 |
PERF_INDEX_DATA | +DG/vam/datafile/perf_index_data01.dbf | 333 | 0 | 5.26 | 1.00 | 600 | 0 | 18 | 1.11 |
PERF_INDEX_DATA | +DG/vam/datafile/perf_index_data02.dbf | 593 | 0 | 5.60 | 1.00 | 1,324 | 0 | 44 | 0.68 |
PERF_INDEX_DATA | +DG/vam/datafile/perf_index_data03.dbf | 396 | 0 | 5.18 | 1.00 | 794 | 0 | 8 | 0.00 |
PERF_INDEX_DATA | +DG/vam/datafile/perf_index_data04.dbf | 551 | 0 | 4.83 | 1.00 | 779 | 0 | 6 | 0.00 |
REP_DATA | +DG/vam/datafile/rep_data01.dbf | 18 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
REP_DATA | +DG/vam/datafile/rep_data02.dbf | 27 | 0 | 0.00 | 1.00 | 11 | 0 | 0 | 0.00 |
REP_DATA | +DG/vam/datafile/rep_data03.dbf | 36 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
REP_DATA | +DG/vam/datafile/rep_data04.dbf | 36 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
REP_INDEX_DATA | +DG/vam/datafile/rep_index_data01.dbf | 18 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
RES_CONF_DATA | +DG/vam/datafile/res_conf_data01.dbf | 3,726 | 1 | 0.52 | 1.01 | 4,906 | 1 | 347 | 1.50 |
RES_CONF_INDEX_DATA | +DG/vam/datafile/res_conf_index_data01.dbf | 73 | 0 | 4.66 | 1.00 | 323 | 0 | 0 | 0.00 |
SYSAUX | +DG/vam/datafile/sysaux.262.702665593 | 489 | 0 | 3.87 | 1.00 | 323 | 0 | 0 | 0.00 |
SYSTEM | +DG/vam/datafile/system.260.702665563 | 168 | 0 | 5.60 | 1.00 | 218 | 0 | 4 | 0.00 |
TEMP | +DG/vam/tempfile/temp06.dbf | 50 | 0 | 3.60 | 11.14 | 0 | 0 | 5 | 10.00 |
UNDOTBS1 | +DG/vam/datafile/undotbs1.261.702665567 | 10 | 0 | 5.00 | 1.00 | 10,632 | 3 | 28 | 0.36 |
UNDOTBS2 | +DG/vam/datafile/undotbs2.264.702665599 | 9 | 0 | 0.00 | 1.00 | 9 | 0 | 10 | 0.00 |
USERS | +DG/vam/datafile/users.265.702665623 | 9 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
VAM_DATA | +DG/vam/datafile/vam_data_01.dbf | 9 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
VAM_INDX_DATA | +DG/vam/datafile/vam_indx_data_01.dbf | 9 | 0 | 0.00 | 1.00 | 9 | 0 | 0 | 0.00 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 628,349 | 100 | -3,169,050,401 | 114,188 | 587,110 | 0 | 0 | 1,315 |
K | 120,897 | 0 | 0 | 0 | 0 | 0 | 0 |
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 | 14 | 46681 | 699449 | 737280 | 737280 | 2284031 | |
E | 0 | 13 | 51363 | 625279 | 737280 | 737280 | 2106505 |
Back to Advisory Statistics
Back to Top
P | Size for Est (M) | Size Factor | Buffers for Estimate | Est Phys Read Factor | Estimated Physical Reads |
---|---|---|---|---|---|
D | 512 | 0.10 | 61,408 | 8.92 | 15,376,337,235 |
D | 1,024 | 0.19 | 122,816 | 1.96 | 3,383,063,122 |
D | 1,536 | 0.29 | 184,224 | 1.30 | 2,248,404,457 |
D | 2,048 | 0.39 | 245,632 | 1.12 | 1,931,651,186 |
D | 2,560 | 0.49 | 307,040 | 1.05 | 1,808,364,648 |
D | 3,072 | 0.58 | 368,448 | 1.02 | 1,765,519,988 |
D | 3,584 | 0.68 | 429,856 | 1.01 | 1,747,085,164 |
D | 4,096 | 0.78 | 491,264 | 1.01 | 1,736,777,611 |
D | 4,608 | 0.88 | 552,672 | 1.00 | 1,730,123,150 |
D | 5,120 | 0.97 | 614,080 | 1.00 | 1,725,623,551 |
D | 5,264 | 1.00 | 631,351 | 1.00 | 1,724,648,844 |
D | 5,632 | 1.07 | 675,488 | 1.00 | 1,722,130,522 |
D | 6,144 | 1.17 | 736,896 | 1.00 | 1,719,751,157 |
D | 6,656 | 1.26 | 798,304 | 1.00 | 1,717,913,062 |
D | 7,168 | 1.36 | 859,712 | 1.00 | 1,716,396,294 |
D | 7,680 | 1.46 | 921,120 | 0.99 | 1,714,642,431 |
D | 8,192 | 1.56 | 982,528 | 0.99 | 1,711,322,117 |
D | 8,704 | 1.65 | 1,043,936 | 0.99 | 1,704,543,161 |
D | 9,216 | 1.75 | 1,105,344 | 0.98 | 1,694,033,530 |
D | 9,728 | 1.85 | 1,166,752 | 0.97 | 1,679,093,712 |
D | 10,240 | 1.95 | 1,228,160 | 0.95 | 1,642,429,054 |
Back to Advisory Statistics
Back to Top
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 5,039 | 0 |
Back to Advisory Statistics
Back to Top
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 | 1,628 | 102 | 3,026.10 | 9.78 | 0.32 | 100.00 | 0.00 | 166,700 |
E | 1,628 | 185 | 2,588.33 | 7.01 | 0.27 | 100.00 | 0.00 | 166,700 |
Back to Advisory Statistics
Back to Top
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 27,584 | 27,584 | 0 | 0 |
64K | 128K | 91 | 91 | 0 | 0 |
256K | 512K | 3 | 3 | 0 | 0 |
512K | 1024K | 2,875 | 2,875 | 0 | 0 |
1M | 2M | 1,737 | 1,737 | 0 | 0 |
64M | 128M | 4 | 4 | 0 | 0 |
Back to Advisory Statistics
Back to Top
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 |
---|---|---|---|---|---|
204 | 0.13 | 6,167,028.35 | 6,812,398.04 | 48.00 | 334,098 |
407 | 0.25 | 6,167,028.35 | 6,809,645.32 | 48.00 | 334,087 |
814 | 0.50 | 6,167,028.35 | 6,419,210.80 | 49.00 | 311,880 |
1,221 | 0.75 | 6,167,028.35 | 1,095,447.32 | 85.00 | 37,403 |
1,628 | 1.00 | 6,167,028.35 | 227,040.68 | 96.00 | 1,209 |
1,954 | 1.20 | 6,167,028.35 | 139,736.23 | 98.00 | 95 |
2,279 | 1.40 | 6,167,028.35 | 139,115.82 | 98.00 | 0 |
2,605 | 1.60 | 6,167,028.35 | 139,115.82 | 98.00 | 0 |
2,930 | 1.80 | 6,167,028.35 | 139,115.82 | 98.00 | 0 |
3,256 | 2.00 | 6,167,028.35 | 139,115.82 | 98.00 | 0 |
4,884 | 3.00 | 6,167,028.35 | 139,115.82 | 98.00 | 0 |
6,512 | 4.00 | 6,167,028.35 | 139,115.82 | 98.00 | 0 |
9,768 | 6.00 | 6,167,028.35 | 139,115.82 | 98.00 | 0 |
13,024 | 8.00 | 6,167,028.35 | 139,115.82 | 98.00 | 0 |
Back to Advisory Statistics
Back to Top
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 |
---|---|---|---|---|---|---|---|---|
256 | 0.15 | 192 | 16,451 | 19,257,367 | 0.74 | 6,844,609 | 99.79 | 1,388,031,010 |
432 | 0.26 | 361 | 30,405 | 22,968,221 | 0.88 | 3,133,755 | 45.69 | 1,391,260,793 |
608 | 0.37 | 533 | 44,624 | 24,835,338 | 0.95 | 1,266,638 | 18.47 | 1,393,027,868 |
784 | 0.47 | 707 | 59,211 | 25,460,882 | 0.98 | 641,094 | 9.35 | 1,393,946,594 |
960 | 0.58 | 882 | 73,691 | 25,713,773 | 0.99 | 388,203 | 5.66 | 1,394,459,281 |
1,136 | 0.68 | 1,057 | 88,319 | 25,823,642 | 0.99 | 278,334 | 4.06 | 1,394,778,882 |
1,312 | 0.79 | 1,232 | 103,621 | 25,913,818 | 1.00 | 188,158 | 2.74 | 1,395,006,236 |
1,488 | 0.89 | 1,407 | 119,176 | 25,967,851 | 1.00 | 134,125 | 1.96 | 1,395,183,684 |
1,664 | 1.00 | 1,582 | 134,110 | 26,033,384 | 1.00 | 68,592 | 1.00 | 1,395,323,971 |
1,840 | 1.11 | 1,757 | 149,484 | 26,066,409 | 1.00 | 35,567 | 0.52 | 1,395,436,381 |
2,016 | 1.21 | 1,932 | 165,336 | 26,104,333 | 1.00 | 1 | 0.00 | 1,395,531,927 |
2,192 | 1.32 | 2,107 | 179,847 | 26,143,384 | 1.00 | 1 | 0.00 | 1,395,613,654 |
2,368 | 1.42 | 2,282 | 195,163 | 26,170,024 | 1.01 | 1 | 0.00 | 1,395,681,590 |
2,544 | 1.53 | 2,457 | 210,890 | 26,191,769 | 1.01 | 1 | 0.00 | 1,395,739,220 |
2,720 | 1.63 | 2,632 | 227,350 | 26,229,515 | 1.01 | 1 | 0.00 | 1,395,793,927 |
2,896 | 1.74 | 2,807 | 243,826 | 26,234,405 | 1.01 | 1 | 0.00 | 1,395,839,852 |
3,072 | 1.85 | 2,984 | 259,968 | 26,246,987 | 1.01 | 1 | 0.00 | 1,395,880,623 |
3,248 | 1.95 | 3,159 | 275,278 | 26,253,145 | 1.01 | 1 | 0.00 | 1,395,915,561 |
3,424 | 2.06 | 3,424 | 303,270 | 26,259,189 | 1.01 | 1 | 0.00 | 1,395,948,563 |
Back to Advisory Statistics
Back to Top
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
2,000 | 0.25 | 55,757,897 | 15,367,654,483 |
4,000 | 0.50 | 11,561,877 | 1,930,571,727 |
6,000 | 0.75 | 10,695,764 | 1,764,488,059 |
8,000 | 1.00 | 10,536,660 | 1,724,648,675 |
10,000 | 1.25 | 10,508,211 | 1,715,508,037 |
12,000 | 1.50 | 10,439,724 | 1,693,087,604 |
14,000 | 1.75 | 10,280,620 | 1,641,520,609 |
16,000 | 2.00 | 10,280,620 | 1,641,520,609 |
Back to Advisory Statistics
Back to Top
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 |
Back to Advisory Statistics
Back to Top
No data exists for this section of the report.
Back to Advisory Statistics
Back to Top
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 1,215 | 6 | 5 |
segment header | 8 | 0 | 6 |
1st level bmb | 52 | 0 | 0 |
undo block | 12 | 0 | 1 |
undo header | 26 | 0 | 0 |
2nd level bmb | 1 | 0 | 0 |
Back to Wait Statistics
Back to Top
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
WF-AWR Flush | 21 | 21 | 0 | 12 | 4 | 319.50 |
FB-Format Block | 8,955 | 8,955 | 0 | 4,536 | 4 | 0.81 |
TC-Tablespace Checkpoint | 3 | 3 | 0 | 1 | 3 | 2,852.00 |
TX-Transaction (index contention) | 336 | 332 | 0 | 202 | 3 | 13.92 |
TM-DML | 398,030 | 398,484 | 0 | 1,141 | 1 | 0.58 |
HW-Segment High Water Mark | 3,672 | 3,672 | 0 | 647 | 0 | 0.74 |
TT-Tablespace | 2,183 | 2,183 | 0 | 477 | 0 | 0.75 |
CF-Controlfile Transaction | 8,727 | 8,725 | 2 | 196 | 0 | 0.99 |
RO-Multiple Object Reuse (fast object reuse) | 820 | 820 | 0 | 396 | 0 | 0.47 |
KO-Multiple Object Checkpoint (fast object checkpoint) | 368 | 368 | 0 | 183 | 0 | 0.52 |
PS-PX Process Reservation | 160 | 160 | 0 | 121 | 0 | 0.78 |
JQ-Job Queue | 46 | 8 | 38 | 40 | 0 | 0.93 |
TA-Instance Undo | 23 | 23 | 0 | 23 | 0 | 1.00 |
SQ-Sequence Cache | 1,915 | 1,915 | 0 | 9 | 0 | 2.33 |
RS-Reclaimable Space (prevent file delete) | 32 | 32 | 0 | 17 | 0 | 1.00 |
US-Undo Segment | 21 | 21 | 0 | 9 | 0 | 1.11 |
WL-Being Written Redo Log | 17 | 17 | 0 | 9 | 0 | 1.11 |
PI-Remote PX Process Spawn Status | 6 | 6 | 0 | 6 | 0 | 0.83 |
TX-Transaction (allocate ITL entry) | 10 | 10 | 0 | 10 | 0 | 0.40 |
TX-Transaction | 292,708 | 293,599 | 0 | 1 | 0 | 4.00 |
BR-Backup/Restore (file shrink) | 5 | 5 | 0 | 2 | 0 | 0.50 |
AF-Advisor Framework (task serialization) | 7 | 7 | 0 | 1 | 0 | 1.00 |
CT-Block Change Tracking (state) | 1 | 1 | 0 | 1 | 0 | 1.00 |
TX-Transaction (row lock contention) | 2 | 2 | 0 | 1 | 0 | 1.00 |
Back to Wait Statistics
Back to Top
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 |
---|
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 |
---|---|---|---|---|---|---|---|
09-Feb 02:08 | 24,294 | 47,364 | 5,948 | 8 | 436 | 0/0 | 0/0/0/0/0/0 |
09-Feb 01:58 | 18,687 | 55,177 | 5,341 | 8 | 438 | 0/0 | 0/0/0/0/0/0 |
09-Feb 01:48 | 26,997 | 24,352 | 4,735 | 9 | 440 | 0/0 | 0/0/0/0/0/0 |
09-Feb 01:38 | 23,455 | 38,719 | 4,128 | 7 | 448 | 0/0 | 0/0/0/0/0/0 |
09-Feb 01:28 | 23,355 | 63,983 | 3,521 | 8 | 450 | 0/0 | 0/0/0/0/0/0 |
09-Feb 01:18 | 23,162 | 58,699 | 2,914 | 7 | 454 | 0/0 | 0/0/0/0/0/0 |
09-Feb 01:08 | 22,690 | 53,583 | 2,307 | 10 | 456 | 0/0 | 0/0/0/0/0/0 |
Back to Undo Statistics
Back to Top
Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
---|---|---|---|---|---|---|
ASM allocation | 1,796 | 0.00 | 0 | 0 | ||
ASM db client latch | 3,252 | 0.00 | 0 | 0 | ||
ASM map headers | 1,161 | 0.00 | 0 | 0 | ||
ASM map load waiting list | 372 | 0.00 | 0 | 0 | ||
ASM map operation freelist | 2,072 | 0.14 | 0.00 | 0 | 0 | |
ASM map operation hash table | 3,240,450 | 0.01 | 0.00 | 0 | 0 | |
ASM network background latch | 2,824 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 85,723 | 0.00 | 0 | 0 | ||
Consistent RBA | 265,363 | 0.00 | 0.00 | 0 | 0 | |
FAL request queue | 105 | 0.00 | 0 | 0 | ||
FAL subheap alocation | 105 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 289 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 51,275 | 0.03 | 0.00 | 0 | 0 | |
JS broadcast add buf latch | 811 | 0.00 | 0 | 0 | ||
JS broadcast drop buf latch | 811 | 0.00 | 0 | 0 | ||
JS broadcast load blnc latch | 709 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 12 | 0.00 | 0 | 0 | ||
JS queue access latch | 12 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 21,270 | 0.00 | 0 | 0 | ||
KCL gc element parent latch | 4,852,483 | 0.06 | 0.04 | 0 | 45,560 | 0.27 |
KFK SGA context latch | 9,950 | 0.00 | 0 | 0 | ||
KFMD SGA | 3,472 | 0.06 | 0.00 | 0 | 0 | |
KJC message pool free list | 209,974 | 0.64 | 0.00 | 0 | 9,165 | 0.50 |
KJCT flow control latch | 2,263,893 | 0.04 | 0.00 | 0 | 0 | |
KMG MMAN ready and startup request latch | 1,180 | 0.00 | 0 | 0 | ||
KSXR large replies | 238 | 0.00 | 0 | 0 | ||
KTF sga latch | 24 | 0.00 | 0 | 1,128 | 0.00 | |
KWQMN job cache list latch | 282 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 2 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 71 | 0.00 | ||
Memory Management Latch | 0 | 0 | 1,180 | 0.00 | ||
OS process | 9,717 | 0.00 | 0 | 0 | ||
OS process allocation | 7,567 | 0.04 | 0.00 | 0 | 0 | |
OS process: request allocation | 6,351 | 0.02 | 0.00 | 0 | 0 | |
PL/SQL warning settings | 3,370 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 749 | 0.53 | 0.00 | 0 | 749 | 0.80 |
SQL memory manager latch | 13 | 0.00 | 0 | 1,179 | 0.00 | |
SQL memory manager workarea list latch | 101,093 | 0.00 | 0.00 | 0 | 0 | |
Shared B-Tree | 129 | 0.00 | 0 | 0 | ||
X$KSFQP | 16 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 277,664 | 3.96 | 0.00 | 0 | 0 | |
active service list | 22,853 | 0.09 | 0.52 | 0 | 4,659 | 0.00 |
archive control | 118 | 0.00 | 0 | 0 | ||
archive process latch | 1,423 | 0.00 | 0 | 0 | ||
begin backup scn array | 104 | 0.00 | 0 | 0 | ||
business card | 24 | 0.00 | 0 | 0 | ||
cache buffer handles | 196,799 | 0.00 | 0.00 | 0 | 0 | |
cache buffers chains | 2,304,165,460 | 1.62 | 0.00 | 0 | 1,584,872 | 0.01 |
cache buffers lru chain | 1,804,425 | 0.20 | 0.00 | 0 | 1,017,697 | 0.10 |
cache table scan latch | 0 | 0 | 54 | 5.56 | ||
channel handle pool latch | 6,359 | 0.05 | 0.00 | 0 | 0 | |
channel operations parent latch | 1,030,315 | 0.00 | 0.00 | 0 | 0 | |
checkpoint queue latch | 12,924,471 | 0.01 | 0.00 | 0 | 783,000 | 0.01 |
client/application info | 17,379 | 0.00 | 0 | 0 | ||
commit callback allocation | 6 | 0.00 | 0 | 0 | ||
compile environment latch | 3,238 | 0.00 | 0 | 0 | ||
dictionary lookup | 6 | 0.00 | 0 | 0 | ||
dml lock allocation | 800,948 | 1.30 | 0.00 | 0 | 0 | |
dummy allocation | 6,567 | 0.11 | 0.00 | 0 | 0 | |
enqueue hash chains | 2,440,829 | 0.10 | 0.00 | 0 | 2,052 | 0.00 |
enqueues | 576,111 | 0.26 | 0.00 | 0 | 0 | |
error message lists | 48 | 0.00 | 0 | 0 | ||
event group latch | 3,130 | 0.00 | 0 | 0 | ||
file cache latch | 4,111 | 0.00 | 0 | 0 | ||
gcs opaque info freelist | 2,253,438 | 0.23 | 0.00 | 0 | 0 | |
gcs partitioned table hash | 14,965,722 | 0.00 | 0 | 252,278 | 0.00 | |
gcs remastering latch | 1,543,948 | 0.00 | 48.44 | 0 | 0 | |
gcs resource freelist | 621,598 | 0.01 | 0.00 | 0 | 284,910 | 0.00 |
gcs resource hash | 7,123,829 | 0.04 | 0.00 | 0 | 90 | 0.00 |
gcs resource scan list | 180 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 1,331,275 | 0.01 | 0.00 | 0 | 1,156,525 | 0.00 |
ges caches resource lists | 866,283 | 0.20 | 0.00 | 0 | 548,408 | 0.07 |
ges deadlock list | 41,136 | 0.00 | 0 | 15 | 0.00 | |
ges domain table | 1,270,824 | 0.01 | 0.00 | 0 | 0 | |
ges enqueue table freelist | 1,337,326 | 0.08 | 0.00 | 0 | 0 | |
ges group table | 1,584,428 | 0.06 | 0.00 | 0 | 0 | |
ges process hash list | 199,902 | 0.00 | 0 | 0 | ||
ges process parent latch | 2,499,804 | 0.00 | 0 | 0 | ||
ges process table freelist | 6,351 | 0.03 | 0.00 | 0 | 0 | |
ges resource hash list | 1,727,163 | 0.04 | 0.00 | 0 | 113,728 | 0.03 |
ges resource scan list | 246 | 0.00 | 0 | 0 | ||
ges resource table freelist | 183,777 | 0.00 | 0.00 | 0 | 0 | |
ges synchronous data | 64 | 0.00 | 0 | 2,586 | 0.15 | |
ges timeout list | 18,416 | 0.01 | 0.00 | 0 | 19,944 | 0.00 |
global KZLD latch for mem in SGA | 3,121 | 0.00 | 0 | 0 | ||
hash table column usage latch | 1,529 | 0.00 | 0 | 184,107 | 0.00 | |
hash table modification latch | 364 | 0.00 | 0 | 0 | ||
internal temp table object number allocation latc | 2 | 0.00 | 0 | 0 | ||
job workq parent latch | 0 | 0 | 16 | 0.00 | ||
job_queue_processes parameter latch | 66 | 0.00 | 0 | 0 | ||
kks stats | 94,432 | 0.03 | 0.00 | 0 | 0 | |
kokc descriptor allocation latch | 496 | 0.00 | 0 | 0 | ||
krbmrosl | 50 | 0.00 | 0 | 0 | ||
ksuosstats global area | 238 | 0.00 | 0 | 0 | ||
ktm global data | 933 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 128 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 266,386 | 0.09 | 0.00 | 0 | 0 | |
library cache | 2,167,566 | 0.22 | 0.00 | 0 | 65,067 | 0.05 |
library cache load lock | 11,658 | 0.01 | 0.00 | 0 | 0 | |
library cache lock | 822,060 | 0.02 | 0.00 | 0 | 0 | |
library cache lock allocation | 37,486 | 0.01 | 0.00 | 0 | 0 | |
library cache pin | 692,009 | 0.03 | 0.00 | 0 | 2 | 0.00 |
library cache pin allocation | 8,452 | 0.00 | 0 | 0 | ||
list of block allocation | 98,973 | 0.00 | 0.00 | 0 | 0 | |
loader state object freelist | 8,374 | 2.01 | 0.00 | 0 | 0 | |
logminer context allocation | 1 | 0.00 | 0 | 0 | ||
longop free list parent | 9,299 | 0.00 | 0 | 10 | 0.00 | |
message pool operations parent latch | 2,333 | 0.00 | 0 | 0 | ||
messages | 1,704,775 | 0.76 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 274,175 | 1.81 | 0.00 | 0 | 0 | |
msg queue | 308 | 0.00 | 0 | 308 | 0.00 | |
multiblock read objects | 6,780 | 0.03 | 0.00 | 0 | 0 | |
name-service memory objects | 25,246 | 0.00 | 0.00 | 0 | 0 | |
name-service namespace bucket | 40,852 | 0.00 | 0 | 0 | ||
name-service namespace objects | 48 | 0.00 | 0 | 0 | ||
name-service pending queue | 13,098 | 0.00 | 0 | 0 | ||
name-service request | 36 | 5.56 | 0.00 | 0 | 0 | |
name-service request queue | 48,081 | 0.01 | 0.00 | 0 | 0 | |
ncodef allocation latch | 95 | 0.00 | 0 | 0 | ||
object queue header heap | 3,472 | 0.00 | 0 | 3,889 | 0.00 | |
object queue header operation | 3,526,846 | 0.07 | 0.02 | 0 | 0 | |
object stats modification | 19 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 1,380 | 0.07 | 0.00 | 0 | 0 | |
parallel query stats | 136 | 0.74 | 0.00 | 0 | 0 | |
parallel txn reco latch | 18,308 | 0.00 | 0 | 0 | ||
parameter list | 19,607 | 0.00 | 0 | 0 | ||
parameter table allocation management | 6,567 | 0.00 | 0 | 0 | ||
post/wait queue | 354,804 | 0.01 | 0.00 | 0 | 239,945 | 0.43 |
process allocation | 34,181 | 0.11 | 0.78 | 0 | 3,127 | 0.10 |
process group creation | 6,351 | 0.03 | 0.00 | 0 | 0 | |
process queue | 378 | 0.00 | 0 | 0 | ||
process queue reference | 9,292 | 0.00 | 0 | 996 | 0.00 | |
qmn state object latch | 2 | 0.00 | 0 | 0 | ||
qmn task queue latch | 522 | 0.00 | 0 | 0 | ||
query server freelists | 284 | 0.35 | 0.00 | 0 | 0 | |
query server process | 6 | 0.00 | 0 | 6 | 0.00 | |
queued dump request | 16,852 | 0.00 | 0 | 0 | ||
redo allocation | 824,076 | 0.26 | 0.00 | 0 | 7,352,297 | 0.29 |
redo copy | 0 | 0 | 7,358,721 | 0.06 | ||
redo writing | 1,094,467 | 0.79 | 0.00 | 0 | 0 | |
resmgr group change latch | 3,522 | 0.00 | 0 | 0 | ||
resmgr:active threads | 6,562 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 3,229 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 6,561 | 0.20 | 0.00 | 0 | 0 | |
resmgr:schema config | 1 | 0.00 | 0 | 0 | ||
row cache objects | 2,657,667 | 0.12 | 0.00 | 0 | 10,661 | 0.32 |
rules engine aggregate statistics | 3 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 106 | 0.00 | 0 | 0 | ||
segmented array pool | 289 | 0.00 | 0 | 0 | ||
sequence cache | 291,066 | 0.29 | 0.00 | 0 | 0 | |
session allocation | 1,218,913 | 0.70 | 0.00 | 0 | 0 | |
session idle bit | 15,893,402 | 0.03 | 0.00 | 0 | 0 | |
session state list latch | 6,704 | 0.07 | 0.00 | 0 | 0 | |
session switching | 95 | 0.00 | 0 | 0 | ||
session timer | 1,959 | 0.00 | 0 | 0 | ||
shared pool | 967,886 | 0.08 | 0.08 | 0 | 0 | |
shared pool simulator | 1,792,066 | 0.01 | 0.01 | 0 | 0 | |
simulator hash latch | 68,847,214 | 0.01 | 0.00 | 0 | 0 | |
simulator lru latch | 0 | 0 | 68,797,072 | 2.48 | ||
slave class | 1,131 | 0.00 | 0 | 0 | ||
slave class create | 665 | 0.15 | 1.00 | 0 | 0 | |
sort extent pool | 1,122 | 0.00 | 0 | 0 | ||
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 336 | 0.00 | 0 | 0 | ||
temporary table state object allocation | 12 | 33.33 | 0.00 | 0 | 0 | |
threshold alerts latch | 601 | 0.00 | 0 | 0 | ||
transaction allocation | 582,322 | 0.00 | 0 | 0 | ||
transaction branch allocation | 1,959 | 0.00 | 0 | 0 | ||
undo global data | 1,177,900 | 0.04 | 0.00 | 0 | 0 | |
user lock | 12,902 | 0.15 | 0.00 | 0 | 0 |
Back to Latch Statistics
Back to Top
Latch Name | Get Requests | Misses | Sleeps | Spin Gets | Sleep1 | Sleep2 | Sleep3 |
---|---|---|---|---|---|---|---|
cache buffers chains | 2,304,165,460 | 37,236,979 | 12,271 | 37,225,604 | 0 | 0 | 0 |
session allocation | 1,218,913 | 8,544 | 3 | 8,541 | 0 | 0 | 0 |
library cache | 2,167,566 | 4,808 | 1 | 4,807 | 0 | 0 | 0 |
session idle bit | 15,893,402 | 4,162 | 8 | 4,154 | 0 | 0 | 0 |
simulator hash latch | 68,847,214 | 4,091 | 2 | 4,089 | 0 | 0 | 0 |
cache buffers lru chain | 1,804,425 | 3,537 | 4 | 3,533 | 0 | 0 | 0 |
row cache objects | 2,657,667 | 3,237 | 1 | 3,236 | 0 | 0 | 0 |
gcs resource hash | 7,123,829 | 2,970 | 2 | 2,968 | 0 | 0 | 0 |
KCL gc element parent latch | 4,852,483 | 2,683 | 108 | 2,576 | 0 | 0 | 0 |
enqueue hash chains | 2,440,829 | 2,510 | 1 | 2,509 | 0 | 0 | 0 |
object queue header operation | 3,526,846 | 2,315 | 38 | 2,277 | 0 | 0 | 0 |
KJC message pool free list | 209,974 | 1,346 | 1 | 1,345 | 0 | 0 | 0 |
shared pool | 967,886 | 744 | 60 | 684 | 0 | 0 | 0 |
shared pool simulator | 1,792,066 | 103 | 1 | 102 | 0 | 0 | 0 |
process allocation | 34,181 | 36 | 28 | 8 | 0 | 0 | 0 |
active service list | 22,853 | 21 | 11 | 12 | 0 | 0 | 0 |
gcs remastering latch | 1,543,948 | 9 | 436 | 0 | 0 | 0 | 0 |
slave class create | 665 | 1 | 1 | 0 | 0 | 0 | 0 |
Back to Latch Statistics
Back to Top
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
KCL gc element parent latch | kclrwrite | 0 | 85 | 116 |
KCL gc element parent latch | kclbla | 0 | 76 | 2 |
KCL gc element parent latch | kclnfndnewm | 0 | 53 | 33 |
KCL gc element parent latch | kclwrt | 0 | 48 | 24 |
KCL gc element parent latch | kclfwrite1 | 0 | 44 | 75 |
KCL gc element parent latch | kclplz | 0 | 12 | 9 |
KCL gc element parent latch | kcllwr | 0 | 6 | 7 |
KCL gc element parent latch | kclfwrite2 | 0 | 5 | 1 |
KCL gc element parent latch | KCLUNLNK | 0 | 2 | 28 |
KCL gc element parent latch | kclnfnd | 0 | 2 | 9 |
KCL gc element parent latch | kclpdc_3 | 0 | 2 | 3 |
KCL gc element parent latch | kclebs | 0 | 1 | 0 |
KCL gc element parent latch | kclexpand | 0 | 1 | 0 |
KCL gc element parent latch | kclgcr | 0 | 1 | 0 |
KCL gc element parent latch | kclpto | 0 | 1 | 0 |
KCL gc element parent latch | kclzcl | 0 | 1 | 5 |
KJC message pool free list | kjcsmpav: allocate a msg buffer | 0 | 1 | 1 |
active service list | ksws_event: ksws event | 0 | 12 | 12 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 68,790 | 64,468 |
cache buffers chains | kcbrls: kslbegin | 0 | 2,676 | 7,682 |
cache buffers chains | kcbgtcr: fast path | 0 | 495 | 53 |
cache buffers chains | kclwrt | 0 | 413 | 1 |
cache buffers chains | kcbgcur: kslbegin | 0 | 93 | 64 |
cache buffers chains | kcbbxsv | 0 | 80 | 484 |
cache buffers chains | kcbget: pin buffer | 0 | 76 | 45 |
cache buffers chains | kclexpand | 0 | 63 | 1 |
cache buffers chains | kclbla | 0 | 49 | 1 |
cache buffers chains | kcbzwb | 0 | 41 | 26 |
cache buffers chains | kcbchg: kslbegin: bufs not pinned | 0 | 28 | 28 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 23 | 0 |
cache buffers chains | kcbnew: new latch again | 0 | 20 | 0 |
cache buffers chains | kcbnlc | 0 | 19 | 21 |
cache buffers chains | kclcls_3 | 0 | 13 | 1 |
cache buffers chains | kclebs_1 | 0 | 11 | 0 |
cache buffers chains | kcllwr | 0 | 7 | 2 |
cache buffers chains | kcbbic1 | 0 | 4 | 3 |
cache buffers chains | kcbchg: kslbegin: call CR func | 0 | 4 | 22 |
cache buffers chains | kclpdc_1 | 0 | 4 | 0 |
cache buffers chains | kcbbic2 | 0 | 3 | 2 |
cache buffers chains | kcbesc: escalate | 0 | 3 | 1 |
cache buffers chains | kclpred | 0 | 3 | 0 |
cache buffers chains | kcbget: exchange | 0 | 2 | 6 |
cache buffers chains | kcbget: exchange rls | 0 | 2 | 4 |
cache buffers chains | kclpto | 0 | 2 | 0 |
cache buffers chains | kcbgkcbcr | 0 | 1 | 11 |
cache buffers chains | kcbgtcr: kslbegin shared | 0 | 1 | 1 |
cache buffers chains | kcbzib: finish free bufs | 0 | 1 | 9 |
cache buffers chains | kclrwrite_1 | 0 | 1 | 0 |
cache buffers lru chain | kcbbxsv: move to being written | 0 | 2 | 4 |
cache buffers lru chain | kcbzgws | 0 | 2 | 0 |
enqueue hash chains | ksqgtl3 | 0 | 1 | 1 |
gcs remastering latch | 59 | 0 | 428 | 0 |
gcs remastering latch | 69 | 0 | 7 | 0 |
gcs remastering latch | 43 | 0 | 1 | 0 |
gcs resource hash | kclfwrite1 | 0 | 1 | 0 |
gcs resource hash | kjblocalfile_nolock | 0 | 1 | 0 |
object queue header operation | kcbo_switch_mq_bg | 0 | 46 | 69 |
object queue header operation | kcbo_switch_q_bg | 0 | 29 | 14 |
object queue header operation | kcbw_link_q | 0 | 11 | 2 |
object queue header operation | kcbw_unlink_q | 0 | 9 | 3 |
object queue header operation | kcbo_switch_cq | 0 | 1 | 8 |
object queue header operation | kcbo_write_q | 0 | 1 | 0 |
object queue header operation | kcbw_unlink_q_bg | 0 | 1 | 2 |
process allocation | ksudlp | 0 | 10 | 12 |
process allocation | ksucrp | 0 | 9 | 0 |
process allocation | ksufap: active procs | 0 | 9 | 9 |
session allocation | ksufap: active sessions | 0 | 2 | 0 |
session allocation | ksuxds: KSUSFCLC not set | 0 | 1 | 0 |
session idle bit | ksupuc: set busy | 0 | 5 | 2 |
session idle bit | ksupuc: clear busy | 0 | 2 | 5 |
session idle bit | ksuxds | 0 | 2 | 2 |
shared pool | kghalo | 0 | 49 | 25 |
shared pool | kghfrunp: alloc: wait | 0 | 5 | 0 |
shared pool | kghupr1 | 0 | 5 | 25 |
shared pool | kghasp | 0 | 1 | 3 |
shared pool | kghfrunp: clatch: nowait | 0 | 1 | 0 |
shared pool | kghfrunp: clatch: wait | 0 | 1 | 0 |
shared pool simulator | kglsim_unpin_simhp | 0 | 1 | 0 |
simulator hash latch | kcbsacc: lookup dba | 0 | 2 | 2 |
slave class create | ksvcreate | 0 | 1 | 0 |
No data exists for this section of the report.
Back to Latch Statistics
Back to Top
No data exists for this section of the report.
Back to Latch Statistics
Back to Top
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
VAMT | ALM_INDEX_DATA | FSTI_ALARM_CURRENT_CLEAR_ID | INDEX | 582,243,280 | 51.32 | |
VAMT | ALM_DATA | FSTI_ALARM_TRANS | TABLE | 462,680,160 | 40.79 | |
VAMT | ALM_DATA | FSTI_ALARM_CURRENT | TABLE | 57,419,408 | 5.06 | |
VAMT | OPER_INDEX_DATA | IND_LC_WAP20_SPDOMAIN | P_20120208 | INDEX PARTITION | 4,522,704 | 0.40 |
VAMT | OPER_DATA | PROD_FZ_PHONENEWSPAPER_STATUS | TABLE | 3,744,480 | 0.33 |
Back to Segment Statistics
Back to Top
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
VAMT | OPER_DATA | LOCAL_WAP20_MSISDN | P_20120205 | INDEX PARTITION | 19,803 | 15.33 |
VAMT | OPER_DATA | LOCAL_WAP20_MSISDN | P_20120204 | INDEX PARTITION | 19,265 | 14.91 |
VAMT | OPER_DATA | LOCAL_WAP20_MSISDN | P_20120208 | INDEX PARTITION | 16,664 | 12.90 |
VAMT | OPER_INDEX_DATA | IND_LC_WAP20_SPDOMAIN | P_20120204 | INDEX PARTITION | 16,556 | 12.82 |
VAMT | OPER_INDEX_DATA | IND_LC_WAP20_SPDOMAIN | P_20120205 | INDEX PARTITION | 15,685 | 12.14 |
Back to Segment Statistics
Back to Top
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
VAMT | OPER_INDEX_DATA | IND_LC_WAP20_SPDOMAIN | P_20120205 | INDEX PARTITION | 48 | 16.90 |
VAMT | OPER_INDEX_DATA | UK_PROD_RES_NE_DETECT_LOG | INDEX | 25 | 8.80 | |
VAMT | OPER_INDEX_DATA | IND_LC_WAP20_SPDOMAIN | P_20120208 | INDEX PARTITION | 23 | 8.10 |
VAMT | OPER_DATA | LOCAL_WAP20_MSISDN | P_20120205 | INDEX PARTITION | 23 | 8.10 |
VAMT | OPER_DATA | LOCAL_WAP20_MSISDN | P_20120208 | INDEX PARTITION | 19 | 6.69 |
Back to Segment Statistics
Back to Top
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
---|---|---|---|---|---|---|
VAMT | OPER_DATA | LOCAL_WAP20_MSISDN | P_20120208 | INDEX PARTITION | 2 | 40.00 |
VAMT | ALM_INDEX_DATA | LOCAL_ALARM_STATUS_LASTNODE | US20120301 | INDEX PARTITION | 1 | 20.00 |
VAMT | ITCOL_INDEX_DATA | PK_HOST_STORAGE_ID | INDEX | 1 | 20.00 | |
VAMT | PERF_INDEX_DATA | PK_PERF_INTERFACE_H_MAX_ID | INDEX | 1 | 20.00 |
Back to Segment Statistics
Back to Top
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
VAMT | OPER_DATA | PROD_FZ_WAP_WAP20TRAFFIC | P_20120208 | TABLE PARTITION | 319 | 56.06 |