It's been a very long time since I last checked to see if anything had
changed, so there may be something more efficient than the method I first
used 15 years ago (and may have published in Oracle Core).
The buffer cache is broken down into working data sets, and each buffer
pool is made up of discrete working data sets, so you can query three x$
structures to get the information you want: x$bh, x$kcbwds, x$kcbwbpd
There's an example at this URL that uses scalar subqueries to pick a
particular buffer pool:
https://jonathanlewis.wordpress.com/2006/11/21/free-buffer-waits/
Regards
Jonathan Lewis
On Mon, 10 Jan 2022 at 22:53, Hameed, Amir <amir.hameed@xxxxxxxxxxxxxxx>
wrote:
Hi Folks,
Is there either a flag available in the X$BH view or another way to
identify buffer headers belonging to the various buffer caches (DEFAULT,
KEEP, etc.)?
Thank you,
Amir
