I tend to cache some objects in buffer_pool cache to reduce buffer_gets and increase oracle performance.
Keep cache is a part of oracle instance's buffer_pool.
Configure keep cache is done with following:
ALTER SYSTEM SET DB_KEEP_CACHE=4096M SCOPE=BOTH;
The above command do allocate 4gb size for buffer_pool keep cache. And I can use the following commands to cache the object which I want to cache to buffer_pool cache.
ALTER TABLE table_name STORAGE(BUFFER_POOL KEEP);
ALTER INDEX index_name STORAGE(BUFFER_POOL KEEP);
In order to check how many objects caching buffer_pool kee, it can execute this sql to check:
SELECT DISTINCT SEGMENT_NAME FROM DBA_SEGMENTS WHERE BUFFER_POOL='KEEP';
