Re: What MB/s is pulled from your buffer cache?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 18 Feb 2013 16:40:04 +0000
Message-ID: <CABe10sak6FSvdc8pQBFSLF1DTK3xkMF3D_tKWwLbXjraB2BFMg_at_mail.gmail.com>



The draft that I started writing began
"Rich

so using your query gives me 1.3gb/s for the last 105 days on a tiny little 11.2.0.3 db that is used only for development. Given that this statistic only appears in our 11.2.0.3 db I'd be cautious of using it. "

:)

On Mon, Feb 18, 2013 at 4:36 PM, Rich Jesse < rjoralist2_at_society.servebeer.com> wrote:

> Martijn writes:
>
> > I'm on 11.2.0.1 on redhat(5).
> > When executing this query I get no rows returned.
> >
> > Looking into v$statname I noticed this statistic is not there.
> > Also the (online) documentation (11.2) didn't reveal much.
>
> Interesting! I don't have that version installed, but I see in 10.2 XE
> that
> the names are substantially different from 11.2.0.3.
>
> Not that this helps you though. :( But now I wonder how folks who use
> those views for monitoring deal with the change...
>
> Rich
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 18 2013 - 17:40:04 CET

Original text of this message