Database Administration (MOSC)

MOSC Banner

Usage of db_keep_cache_size

edited Nov 10, 2014 1:36PM in Database Administration (MOSC) 12 commentsAnswered

I want to test the usage of db_keep_cache_size.

I executed a query and wrote down the time it needed to execute.

Then I issued.

alter system set db_keep_cache_size=100m scope=both;

alter table schema.table storage( buffer_pool keep)

Then I executed the query again and noticed no difference in execution time.

Now I want to make sure that the table is on the keep pool. How can I make sure that the table's data are stored in the keep_pool?

Our database version is 11.2.0.4

Thanks

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center