Full scans, direct path reads and ORA-8103 error hacking session video here (plus iTunes podcast address!)

I have uploaded the latest hacking session video to blip.tv. I have edited it a little, I cut out the part where I spilled an entire Red Bull onto my desk, with some onto my laptop (some keys are still sticky:)

Also, I do upload all these sessins into iTunes – so you can subscribe to my podcast! That way you can download the videos into your computer, phone or iPad. I have deliberately used 1024×768 resolution so it would look awesome on iPad screen! (so hopefully your commute time gets a bit more fun now ;-)

 

Enjoy!

iTunes video-podcast:

 

 

Note that this year’s only Advanced Oracle Troubleshooting class takes place in the end of April/May 2014, so sign up now if you plan to attend this year!

This entry was posted in Oracle and tagged , , . Bookmark the permalink.

11 Responses to Full scans, direct path reads and ORA-8103 error hacking session video here (plus iTunes podcast address!)

  1. Simon Palmer says:

    Better than “Bull shit” which one finds on other blogs I suppose… LOL! ;-)

  2. Pingback: Log Buffer #233, A Carnival of the Vanities for DBAs | The Pythian Blog

  3. surachart says:

    love it…I downloaded for my iPad -)

  4. Luis says:

    Hi Tanel,
    Great hacking session, but one question remains for me. I will describe:
    Why the number of blocks that we read in the direct path read (#blocks bellow in .trc file) is different from the total number of blocks got from dba_segments?
    Why Oracle will read (in my case) less 3 blocks that the total number of blocks of the table?

    Thanks.
    Luis Marques

  5. Tanel Poder says:

    @Luis
    DBA_SEGMENTS shows the total segment size – which may include some unformatted blocks above high-water mark. The full scan only has to scan up to HWM, no need to read the unformaated blocks.

  6. Pingback: What happens, when you did not do a load test before release upgrades ? « Coskan’s Approach to Oracle

  7. betterNottoreveal says:

    Tanel – Geeks don’t use ipads or ipods. Android mate…

  8. Tanel Poder says:

    @betterNottoreveal
    I use both right now and am waiting for iphone 5 so i can get rid of my android junk (HTC hardware is solid, just android reminds me ’90s too much ;-)

  9. Pingback: ORA-8103 and DDL on a trigger | andriydmytrenko

  10. Andre Espirito Santo says:

    Hello Tanel,

    I’m not able to see this movie, and I’m very interested in it. Any chance on making it available again ?

    Also can’t find it on iTunes… probably my mistake ! :)

    Thank you very much for all the knowledge you share with the community.

    Best regards,
    André

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>