Home > Database, Oracle > Oracle Check Content of Buffer Pool Keep (KEEP CACHE)

Oracle Check Content of Buffer Pool Keep (KEEP CACHE)

November 12th, 2012

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.

In order to check what objects from the ST0MA schema reside in the Keep Cache you can use the DBA_SEGMENTS to find out:

SELECT S.SEGMENT_NAME, S.SEGMENT_TYPE FROM DBA_SEGMENTS S WHERE S.OWNER='ST0MA' AND S.BUFFER_POOL='KEEP';

If something is missing you can easily add it but always make sure you have enough free space in the keep cache before adding.

ALTER INDEX ST0MA.IND5 STORAGE (BUFFER_POOL KEEP);

This should do it.

Categories: Database, Oracle Tags:
Comments are closed.