Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Enabling Keep and Recycle Buffer Pool

user8816444Oct 14 2014 — edited Oct 14 2014

Hi all,

I need to enable Keep and Recycle Buffer Pools on an Oracle DB instance.

Currently, the caches are disabled because I set BUFFER_POOL storage paramater to KEEP for some tables, but the output of the following query

SELECT name, block_size, SUM(buffers)

FROM V$BUFFER_POOL

GROUP BY name, block_size;

is

pastedImage_7.png

Following the current cache parameters configuration:

pastedImage_4.png

Thank you in advance

Ray
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2014
Added on Oct 14 2014
#cache, #general-database-discussions
5 comments
420 views