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 Sat Apr 20 2002 - 16:44:13 CDT
