Database Caching Mode Oracle Database 12C release 1 (12.1)

This feature is available starting with Oracle Database 12c Release 1 (12.1.0.2)

It enables to force caching of all segments into buffer cache automatically(when the segments are accessed). With this option turned on even FULL scans or NOCACHE LOBs are loaded into buffer cache. In previous releases it was not guaranteed that a given segments will be cached unless you specified KEEP buffer.

When to use it:

  • when you have enough memory to keep all segments in memory
  • when you are limited by I/O system and response time

To enable force full database caching mode, use the following ALTER DATABASE command. It can be executed only when database is in mount mode:

ALTER DATABASE FORCE FULL DATABASE CACHING;

Status of the setting can be checked in the V$DATABASE view as shown:

SELECT FORCE_FULL_DB_CACHING FROM V$DATABASE;

Have a fun 🙂
Tomasz

4 thoughts on “Database Caching Mode Oracle Database 12C release 1 (12.1)

    • I haven’t but I expect the same problems as for 12.1.0.1. I’ll update soon all post about release 12.1.0.2 if it works but I need some time :).

      Regards
      Tomasz

  1. I just want to know that why are we using force full database caching if we have keep pool.is there any major difference?Please answer
    mail id=>premnidhi.sharma@gmail.com

Leave a Reply

Your email address will not be published. Required fields are marked *