Re: Identify to which buffer pool a entry in v$bh belongs?

Forgot to include the URL:
Free Buffer Waits | Oracle Scratchpad (wordpress.com) <https://jonathanlewis.wordpress.com/2006/11/21/free-buffer-waits/>

Regards
Jonathan Lewis

On Sat, 20 Jan 2024 at 08:18, Martin Berger <martin.a.berger_at_gmail.com> wrote:

> Dear friends,
>
> I was in a discussion about DEFAULT and KEEP pool.
> A small side question was about counting current buffered blocks for given
> objects, and in which pool they "really" are. The idea was: direct after I
> define a table BUFFER_POOL KEEP (away from previous default), can I somehow
> track if/when this table is using only the keep pool ?
> The discussion went on and I was not forced to go into details, but it
> showed my lack of detailed knowledge in this area.
> Any information - might it be conceptual information or queries to map
> x$bh to pools directly - is very appreciated!
>
>
> thank you,
> Martin
>
> --
> Martin Berger
> Oracle ♠
> martin.a.berger_at_gmail.com _at_martinberx <https://twitter.com/martinberx>
> ^∆x http://berxblog.blogspot.com
>

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