JAS-MIN

Correlation of Instance Statistics with DB Time for Values >= 0.5 and <= -0.5

Instance Statistic Correlation
DML statements retried0.951
parse count (total)0.932
parse count (failures)0.927
ASSM gsp:bump HWM0.922
ASSM gsp:Search steal0.922
ASSM gsp:Search all0.922
enqueue waits0.919
ASSM rsv:clear reserve0.916
DBWR checkpoints0.914
KTFB alloc req0.912
bytes received via SQL*Net from client0.901
DBWR object drop buffers written0.887
sql area purged0.881
root node splits0.880
user calls0.878
index split cancel wait noclean0.874
SQL*Net roundtrips to/from client0.872
Requests to/from client0.872
Heatmap BlkLevel Ranges Flushed0.861
session cursor cache hits0.856
parse count (hard)0.848
execute count0.846
calls to kcmgcs0.842
ASSM rsv:fill reserve0.841
calls to get snapshot scn: kcmgss0.839
IMU contention0.835
KTFB free req0.834
exchange deadlocks0.831
write clones created in background0.830
messages sent0.830
messages received0.830
KTFB commit req0.829
CCursor + sql area evicted0.829
TBS Extension: tasks executed0.828
cleanouts and rollbacks - consistent read gets0.827
Batched IO vector block count0.822
index reclamation/extension switch0.822
LOB table id lookup cache misses0.814
bytes sent via SQL*Net to client0.810
index crx upgrade (positioned)0.798
Batched IO block miss count0.796
Batched IO vector read count0.793
sql area evicted0.791
Batched IO same unit count0.774
ASSM gsp:L2 bitmap full0.766
table fetch by rowid0.762
redo synch long waits0.761
CCursor + sql area evicted - failed0.761
buffer is pinned count0.760
cumulative end requests0.746
commit immediate requested0.738
commit immediate performed0.738
IMU undo allocation size0.738
commit cleanout failures: cannot pin0.729
TBS Extension: tasks created0.725
cursor reload failures0.722
KTFB commit time (ms)0.721
non-idle wait count0.713
Client Time (usec) Round Trip Time Variance0.712
ASSM rsv:alloc from reserve succ0.710
ASSM rsv:alloc from reserve0.710
redo write info find0.705
redo synch time overhead count ( 2ms)0.702
enqueue requests0.697
enqueue releases0.697
opened cursors cumulative0.689
redo synch time overhead (usec)0.685
leaf node 90-10 splits0.676
bytes via SQL*Net vector from client0.674
KTFB apply req0.670
redo synch time (usec)0.669
redo synch time0.669
Client Time (usec) Round Trip Time0.657
Batched IO buffer defrag count0.656
Batched IO slow jump count0.646
Client Total Number of Retransmitted Packets0.637
hot buffers moved to head of LRU0.632
redo write size count ( 8KB)0.624
securefile number of flushes0.620
CR blocks created0.614
user logouts cumulative0.610
logons cumulative0.608
Parallel operations not downgraded0.603
DFO trees parallelized0.602
physical read IO requests0.599
recursive calls0.599
redo synch time overhead count ( 8ms)0.597
cumulative begin requests0.592
IMU Redo allocation size0.589
physical read total IO requests0.584
active txn count during cleanout0.583
Client Time (usec) Last Data Sent0.580
Client Time (usec) Last Data Received0.580
Client Time (usec) Last Ack Received0.580
calls to kcmgas0.579
user logons cumulative0.576
redo write finish time0.575
redo write time (usec)0.574
redo write time0.574
IMU ktichg flush0.572
redo write size count ( 32KB)0.567
redo blocks checksummed by FG (exclusive)0.566
redo write total time0.562
index split cancel op set0.562
enqueue conversions0.560
Batched IO (bound) vector count0.557
Batched IO (full) vector count0.535
redo size for direct writes0.532
bytes via SQL*Net vector to client0.528
redo entries for lost write detection0.517
IMU CR rollbacks0.510
PX local messages sent0.509
transaction rollbacks0.508
PX local messages recv'd0.506
cumulative DB time in requests0.502