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

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: "rjoralist2@xxxxxxxxxxxxxxxxxxxxx" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
  • Date: Mon, 18 Feb 2013 16:40:04 +0000

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@xxxxxxxxxxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


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


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


Other related posts: