Oracle I/O Basics
This video covers:
- Disk I/O Concepts
- Async disk I/O concepts – when does Oracle use it
- Monitoring via vmstat – explained
- Monitoring via iostat – explaining the meaning of the
%util(disk busy time) column, queue depth, service time, wait time
- Concepts of larger queue, faster disk I/O, slower response time, more through-put.
As usual, the Goodies are intended to be debates, so please post any questions of follow-ups with the relevant time-index from the video.
N.B.: YouTube decided to limit director’s accounts to 10 minutes and decided to have a new account type called the “10+ minutes” account. Unfortunately, the form to apply for such accounts is disabled until further notice. We had to find an alternative and we picked veoh. It comes in handy as it offers an iPod version for direct download.