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

August 11, 2011 by 9 Comments

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:

 

 

Filed Under: Oracle Tagged With: , ,

Comments

  1. Simon Palmer says:
    August 11, 2011 at 1:48 pm

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

    Reply
  2. surachart says:
    August 12, 2011 at 1:49 am

    love it…I downloaded for my iPad -)

    Reply
  3. Luis says:
    August 13, 2011 at 11:31 am

    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

    Reply
  4. Tanel Poder says:
    August 14, 2011 at 5:43 am

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

    Reply
  5. betterNottoreveal says:
    September 12, 2011 at 1:15 pm

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

    Reply
  6. Tanel Poder says:
    September 12, 2011 at 2:48 pm

    @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 ;-)

    Reply

Trackbacks

  1. Log Buffer #233, A Carnival of the Vanities for DBAs | The Pythian Blog says:
    August 12, 2011 at 1:05 am

    [...] Tanel Poder has uploaded Full scans, direct path reads and ORA-8103 error hacking session video on the blip.tv [...]

    Reply
  2. What happens, when you did not do a load test before release upgrades ? « Coskan’s Approach to Oracle says:
    August 15, 2011 at 6:56 pm

    [...] http://blog.tanelpoder.com/2011/08/11/full-scans-direct-path-reads-and-ora-8103-error-hacking-sessio… [...]

    Reply
  3. ORA-8103 and DDL on a trigger | andriydmytrenko says:
    September 9, 2012 at 3:12 pm

    [...] / Troubleshooting, Diagnostic and Solution [ID 8103.1] or a wonderful Tanel Poder’s article. However, the case sounded fantastic: the error fired inside of a job which ran a query on a table, [...]

    Reply

Speak Your Mind

*