x$bh - which buffer pool is a block from

From: Kyle Hailey <oraperf_at_yahoo.com>
Date: Tue, 06 Nov 2001 15:28:04 GMT
Message-ID: <3be80114.131817243@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 - 09:28:04 CST