1.617.682.4508

Pythian Blog

The world discusses #Pythian on Twitter. Have a question? Use our hashtag and ask away.

Emergency

24x7 Support

Not a Pythian client but need help now? No problem. Click here.

Are you aware of an existing DBA opening or consulting requirement in your organization? Enter your email for a chance to win one year's access to Safari Books.

  

Pythian Goodies: Oracle Disk I/O Basics

By: Christo Kutrovsky

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.

4 Responses

  1. Noons says:

    good stuff here, folks.

  2. Annoyed says:

    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:

    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. 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

Start NowWith Pythian - database design, management and emergency handling capabilities...

Pythian Blog

Connecting to Oracle with SQL Server 2005 x64
The quirks of connecting to Oracle from SQL 2005 64
more



Live Updates

pythian: Pythian is now official members of the Microsoft Partner Program. Thanks Peter
more



RSSTestimonials

  • Casey Dyke

    Database Team Manager Service Delivery and Applications , Telstra

    Pythian were recently engaged to take a lead role in a high end infrastructure build project at Telstra. Our requirements were a combination of... more