Database Tuning (MOSC)

MOSC Banner

Where can we cross-reference V$IO_OUTLIER

in Database Tuning (MOSC) 9 commentsAnswered ✓

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center