Database Memory & 4030/4031 (MOSC)

MOSC Banner

Any side effects of storage parameter buffer_pool KEEP instead of DEFAULT if database has no KEEP po

edited Dec 5, 2019 6:01AM in Database Memory & 4030/4031 (MOSC) 2 commentsAnswered ✓

We have 12.1.0.2 database with SGA_TARGET 180G. Several application objects (tables, indexes, table_partitions, index_partitions) are defined with buffer_pool KEEP by former developers (more randomly, not following recommendations, not reasonable).

Database parameter DB_KEEP_CACHE_SIZE and DB_RECYCLE_CACHE_SIZE are both zero, DEFAULT buffer pool used only.

Does buffer_pool KEEP parameter on database objects cause any side effects in a database which does not use KEEP buffer pool? Maybe does optimizer internally use KEEP storage flag? Or does buffer in default cache stay longer in buffer than objects with buffer_pool DEFAULT, maybe other internal differences in LRU management?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center