Identify to which buffer pool a entry in v$bh belongs?
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Sat, 20 Jan 2024 09:17:03 +0100
Message-ID: <CALH8A9210ZfaYwcaGJq3sZDDowDV9GT9xOpKPxO0kVKkteY4bQ_at_mail.gmail.com>
Dear friends,
Date: Sat, 20 Jan 2024 09:17:03 +0100
Message-ID: <CALH8A9210ZfaYwcaGJq3sZDDowDV9GT9xOpKPxO0kVKkteY4bQ_at_mail.gmail.com>
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 Received on Sat Jan 20 2024 - 09:17:03 CET