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 |