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.