Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Any thoughts?
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<c6ttpo$9ck$1_at_hercules.btinternet.com>...
> Session Logical I/Os is most likely to be
> the one that is correct.
>
> If you want to mess yourself up completely,
> take a look at v$buffer_pool_statistics, which
> also records system level 'logical I/O'.
>
> Looking at a 9.2 system that has been idling along
> for a while, I see:
>
> v$buffer_pool
> =============================
> DB_BLOCK_GETS 2,502,196
> CONSISTENT_GETS 1,099,488
>
> v$sysstat
> =============================
> db block gets 1,402,528
> consistent gets 2,131,216
>
>
> There are several hundred routines which could
> be called to perform a 'logical I/O' - it's not too
> surprising that some of them update the wrong
> figure, or both, or neither, about what kind of
> logical I/O they have performed.
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> June 2004 UK - Optimising Oracle Seminar
> July 2004 USA West Coast, Optimising Oracle Seminar
> August 2004 Charlotte NC, Optimising Oracle Seminar
> September 2004 USA East Coast, Optimising Oracle Seminar
> September2004 UK - Optimising Oracle Seminar
>
Thanks Jonathan! That's pretty much what I was looking for. Now I just have to go back and find the set of stats that I was looking at to begin with! Thanks for your always useful comments. I'll be sure and post another note if something truly interesting comes of this.
Have a great weekend all!
John
Received on Sat May 01 2004 - 09:08:19 CDT