Re: Logical IO

  • From: John Glohahi <john.o.golden@xxxxxxxxx>
  • To: yong321@xxxxxxxxx
  • Date: Fri, 20 Nov 2009 08:49:15 +0800

Hi Fuyuncat, Gints, Daniel, Dion, Yong, Tanel and Every Experts,

Thanks everybody so much! I learned a lot from you!.

Best Rgds,
John

On Fri, Nov 20, 2009 at 1:50 AM, Yong Huang <yong321@xxxxxxxxx> wrote:

> > that the only way to find the current mode read is either use
> > event 10046 (when the blocks are not already cached) or check
> > x$bh for increase in touch count (class 4 for segment header,
> > verify with file and block number). There's no event to trace
> > CU read.
>
> I posted that before I read Fuyuncat's posting at
>
> http://www.hellodba.com/Doc/logic_io_secret_FTS_1.html
>
> It looks like setting _trace_pin_time to non-zero unambiguously
> pinpoints the buffers read in current mode. Excellent!
>
> BTW, for the benefit of others, the meanings of some of the
> logical I/O functions Fuyuncat used are explained at
> http://www.jlcomp.demon.co.uk/buffer_usage.html
>
> Yong Huang
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: