Where can we cross-reference V$IO_OUTLIER
We are troubleshooting a performance problem on a critical database. We noticed that the V$IO_OUTLIER view has 499 rows that show low io-latency. The IO Latency column records values as high as 17575190
Our Storage team cannot find any indication of such bottlenecks
We would like to know :
a.) What measure is the IO_LATENCY column (milli-second, seconds etc). The docs say ms but the values are so large I'm pretty sure we would have noticed these waits
b.) where we can cross reference the rows in this view to identify when the low latency was experienced.
c.) Is this view dynamic and if so does the view get cleared out at Shutdown as we had 499 prior to a bounce over the weekend, and have 499 rows again