Re: Help with query to find buffer pool usage

I know this is out of context but can some one please explain the difference between the X$ and V$ views

Thanks,
Sunil.

"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote in message news:a9snef$or2$1_at_news1.xs4all.nl...
> Mayby you could add a join with DBA_SEGMENTS. Oracle stores the buffer
pool
> you have choosen for the segment there.
> Had a quick look on the - very good - site http://www.ixora.com.au but
could
> not find a script so quickly there.
> You will find scripts there that give you insight in the X$-views, that
may
> lead you to a more performing solution.
>
>
> Richard Piasecki <ogo_at_mailcity.com> schreef in berichtnieuws
> n582cu84g3gc1cbnu7rg0nv7ainn3ol61k_at_4ax.com...
> >
> > Greetings.
> >
> > I am currently using the following query to find the
> > objects that are cached in the block buffer pool.
> >
> > select a.status, b.object_name, count(*) total
> > from v$bh a, dba_objects b
> > where a.objd = b.object_id(+)
> > group by a.status, b.object_name;
> >
> > It works fine. But, I'd really like to include the pool
> > in the output (keep, recycle, default). However, there
> > doesn't seem to be a field in v$bh (or even x$bh) that
> > corresponds to the pool.
> >
> > Does anyone know how to get this information? I assume
> > I need to join with another table. Which one is it?
> >
> >
> > --- Rich
> >
>
>
Received on Mon Apr 22 2002 - 01:43:44 CDT