Re: Logical IO

From: John Glohahi <john.o.golden_at_gmail.com>
Date: Fri, 20 Nov 2009 08:49:15 +0800
Message-ID: <49bc651c0911191649l434d273bpfa99559973c6b186_at_mail.gmail.com>

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_at_yahoo.com> 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
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 19 2009 - 18:49:15 CST