If memory serves correctly, you have to look at
the SET_DS, which is the working data set address
that the buffer is in, and then look at x$kcbwds to
related working sets to buffer pools.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Kyle Hailey wrote in message
<3be80114.131817243_at_newsfeeds-goliath.1usenet.net>...
>
>
>The fixed table x$bh has all the block in the various buffer caches,
>keep, recycle, and default. Anyone know of a field that indicates
>which buffer pool a block is in or some other way of determining which
>pool a buffer belongs to?
>
>
>Best Wishes
>Kyle Hailey
>
>http://oraperf.sourceforge.net
>___________________________________________________________________________
___
>Posted Via Binaries.net = SPEED+RETENTION+COMPLETION =
http://www.binaries.net
Received on Tue Nov 06 2001 - 15:04:22 CST
