Database Tuning (MOSC)

MOSC Banner

db_keep_cache_size and db_cache_size parameters in 19c

If these parameters maintain default zero values, does 19c automatically increases the values on demand or these values need to be set with higher values?


SQL> show parameter db_keep_cache_size


NAME                 TYPE    VALUE

------------------------------------ ----------- ------------------------------

db_keep_cache_size          big integer 0

SQL> show parameter db_cache_size


NAME                 TYPE    VALUE

------------------------------------ ----------- ------------------------------

db_cache_size            big integer 0

SQL>                                        

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