Re: Logical IO
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: ukja.dion@xxxxxxxxx, daniel.fink@xxxxxxxxxxxxxx
- Date: Wed, 18 Nov 2009 07:25:34 -0800 (PST)
Sheesh Dan, you could have warned us how many files were in that zip! :)
Good stuff though!
Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen
"Go away before I replace you with a very small and efficient shell script..."
--- On Wed, 11/18/09, Daniel Fink <daniel.fink@xxxxxxxxxxxxxx> wrote:
From: Daniel Fink <daniel.fink@xxxxxxxxxxxxxx>
Subject: Re: Logical IO
To: ukja.dion@xxxxxxxxx
Cc: john.o.golden@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Wednesday, November 18, 2009, 5:54 AM
A few years ago, Kirti Deshpande and I did some research into tracing
Logical I/Os. The paper and presentation at are
http://www.optimaldba.com/papers/TracingLogicalIOs.zip
Dion Cho wrote:
> Wouldn't it be better to trace it yourself with 10200 event and/or 10046
> event?
>
> - 10200 event would tell you which blocks are logically read.
> - 10046 event would tell you which blocks are physicall read(when the buffer
> cache was clean).
>
> The number of blocks being read would also be depedent on how the segment
> space is managed(auto vs. manual) , which would be easily verifed with 10046
> and/or 10200 event.
>
>
> ================================
> Dion Cho - Oracle Performance Storyteller
>
> http://dioncho.wordpress.com (english)
> http://ukja.tistory.com (korean)
> http://dioncho.blogspot.com (japanese)
> http://ask.ex-em.com (q&a)
> ================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
