Archive

Archive for November, 2012

Oracle Check Content of Buffer Pool Keep (KEEP CACHE)

November 12th, 2012 Comments off

I tend to need configuration of KEEP_CACHE for static schema objects.
Keep Cache in Oracle is part of the Buffer Pool. Configuring Keep Cache is done with the following command as SYSDBA:

ALTER SYSTEM SET DB_KEEP_CACHE_SIZE=1024M SCOPE=BOTH;

The above will allocate 1GB of SGA Memory to the Keep Cache.

Read more…

Categories: Database, Oracle Tags: