Pythian has openings for MySQL and MS SQL Server DBAs in each of our offices in Ottawa, Canada; Boston, USA; Dubai, UAE; and Hyderabad, India. If you are a MySQL and/or SQL Server DBA and would like to evaluate this opportunity, please send us your résumé with an introductory paragraph to hr@pythian.com.
« VIP Dependencies Lifted in Oracle 10.2.0.3
Log Buffer #32: a Carnival of the Vanities for DBAs »

Pythian Goodies: Oracle Disk I/O Basics

By Christo Kutrovsky — February 12th, 2007 at 2:06 pm
Posted in Group Blog Posts • Oracle • Pythian Goodies

Two weeks ago, I released a video about Flash Recovery Area as part of the Pythian Goodies project. Here is the next video in the sequence.

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.

    • http://www.veoh.com/videos/v237408rJb8XQWX

    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.

    These icons link to social bookmarking sites where readers can share and discover new web pages.
    • Google
    • del.icio.us
    • Facebook
    • bodytext
    • Technorati
    • TwitThis
    • Reddit

    You can follow any responses to this post through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

4 Responses to “Pythian Goodies: Oracle Disk I/O Basics”

  1. Noons Says:
    February 15th, 2007 at 7:28 am

    good stuff here, folks.

  2. Annoyed Says:
    February 20th, 2007 at 1:41 pm

    Not impressed with veoh. It looks like I need to have Windows/Mac, note NO LINUX, to download and view file and I have to use some Veoh player. I appreciate Pythian taking the time to produce these videos for the Oracle community but I would request that the distribution method also support *nix users.

    I’ll crawl back to my Web 1.0 world.

    Ciao
    Annoyed

  3. Paul Vallee Says:
    February 20th, 2007 at 2:46 pm

    Hmm - that’s strange. Did you try downloading the ipod-compatible one, if you have an ipod? It’s in an open format that video players on linux should be able to easily view.

    Also - I am confident that the flash player works in linux - is this only an issue when trying to download it to view it offline?

    Thanks

    Paul

  4. David Edwards Says:
    February 21st, 2007 at 11:44 am

    I can confirm that the Flash player works with Linux, Ubuntu 6.10 to be precise. Shockwave Flash player = 7.0 r63.

Leave a Reply

Filling out the following captcha not only allows us to cut down on automated blogspam but also helps digitize books. Please feel free to send comments on this approach directly to Paul at vallee@pythian.com.

NOTE: After submitting your comment, verify that it is added to the blog. New comments will be marked as "waiting for moderation" (we only moderate for spam). If the level of spam is as low as we hope, we will bypass this step.