Re: Identifying buffers based on DEFAULT, KEEP buffer caches

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_at_sleepnumber.com> 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
>

--
http://www.freelists.org/webpage/oracle-l