Correlation of Instance Statistics with DB Time for Values >= 0.5 and <= -0.5
Instance Statistic | Correlation |
---|---|
DML statements retried | 0.951 |
parse count (total) | 0.932 |
parse count (failures) | 0.927 |
ASSM gsp:bump HWM | 0.922 |
ASSM gsp:Search steal | 0.922 |
ASSM gsp:Search all | 0.922 |
enqueue waits | 0.919 |
ASSM rsv:clear reserve | 0.916 |
DBWR checkpoints | 0.914 |
KTFB alloc req | 0.912 |
bytes received via SQL*Net from client | 0.901 |
DBWR object drop buffers written | 0.887 |
sql area purged | 0.881 |
root node splits | 0.880 |
user calls | 0.878 |
index split cancel wait noclean | 0.874 |
SQL*Net roundtrips to/from client | 0.872 |
Requests to/from client | 0.872 |
Heatmap BlkLevel Ranges Flushed | 0.861 |
session cursor cache hits | 0.856 |
parse count (hard) | 0.848 |
execute count | 0.846 |
calls to kcmgcs | 0.842 |
ASSM rsv:fill reserve | 0.841 |
calls to get snapshot scn: kcmgss | 0.839 |
IMU contention | 0.835 |
KTFB free req | 0.834 |
exchange deadlocks | 0.831 |
write clones created in background | 0.830 |
messages sent | 0.830 |
messages received | 0.830 |
KTFB commit req | 0.829 |
CCursor + sql area evicted | 0.829 |
TBS Extension: tasks executed | 0.828 |
cleanouts and rollbacks - consistent read gets | 0.827 |
Batched IO vector block count | 0.822 |
index reclamation/extension switch | 0.822 |
LOB table id lookup cache misses | 0.814 |
bytes sent via SQL*Net to client | 0.810 |
index crx upgrade (positioned) | 0.798 |
Batched IO block miss count | 0.796 |
Batched IO vector read count | 0.793 |
sql area evicted | 0.791 |
Batched IO same unit count | 0.774 |
ASSM gsp:L2 bitmap full | 0.766 |
table fetch by rowid | 0.762 |
redo synch long waits | 0.761 |
CCursor + sql area evicted - failed | 0.761 |
buffer is pinned count | 0.760 |
cumulative end requests | 0.746 |
commit immediate requested | 0.738 |
commit immediate performed | 0.738 |
IMU undo allocation size | 0.738 |
commit cleanout failures: cannot pin | 0.729 |
TBS Extension: tasks created | 0.725 |
cursor reload failures | 0.722 |
KTFB commit time (ms) | 0.721 |
non-idle wait count | 0.713 |
Client Time (usec) Round Trip Time Variance | 0.712 |
ASSM rsv:alloc from reserve succ | 0.710 |
ASSM rsv:alloc from reserve | 0.710 |
redo write info find | 0.705 |
redo synch time overhead count ( 2ms) | 0.702 |
enqueue requests | 0.697 |
enqueue releases | 0.697 |
opened cursors cumulative | 0.689 |
redo synch time overhead (usec) | 0.685 |
leaf node 90-10 splits | 0.676 |
bytes via SQL*Net vector from client | 0.674 |
KTFB apply req | 0.670 |
redo synch time (usec) | 0.669 |
redo synch time | 0.669 |
Client Time (usec) Round Trip Time | 0.657 |
Batched IO buffer defrag count | 0.656 |
Batched IO slow jump count | 0.646 |
Client Total Number of Retransmitted Packets | 0.637 |
hot buffers moved to head of LRU | 0.632 |
redo write size count ( 8KB) | 0.624 |
securefile number of flushes | 0.620 |
CR blocks created | 0.614 |
user logouts cumulative | 0.610 |
logons cumulative | 0.608 |
Parallel operations not downgraded | 0.603 |
DFO trees parallelized | 0.602 |
physical read IO requests | 0.599 |
recursive calls | 0.599 |
redo synch time overhead count ( 8ms) | 0.597 |
cumulative begin requests | 0.592 |
IMU Redo allocation size | 0.589 |
physical read total IO requests | 0.584 |
active txn count during cleanout | 0.583 |
Client Time (usec) Last Data Sent | 0.580 |
Client Time (usec) Last Data Received | 0.580 |
Client Time (usec) Last Ack Received | 0.580 |
calls to kcmgas | 0.579 |
user logons cumulative | 0.576 |
redo write finish time | 0.575 |
redo write time (usec) | 0.574 |
redo write time | 0.574 |
IMU ktichg flush | 0.572 |
redo write size count ( 32KB) | 0.567 |
redo blocks checksummed by FG (exclusive) | 0.566 |
redo write total time | 0.562 |
index split cancel op set | 0.562 |
enqueue conversions | 0.560 |
Batched IO (bound) vector count | 0.557 |
Batched IO (full) vector count | 0.535 |
redo size for direct writes | 0.532 |
bytes via SQL*Net vector to client | 0.528 |
redo entries for lost write detection | 0.517 |
IMU CR rollbacks | 0.510 |
PX local messages sent | 0.509 |
transaction rollbacks | 0.508 |
PX local messages recv'd | 0.506 |
cumulative DB time in requests | 0.502 |