开启和关闭force full database caching mode:

1、判断数据库是否是强制全库缓存模式（如果是返回YES）：

SQL> SELECT FORCE_FULL_DB_CACHING FROM V$DATABASE;

FOR

---

NO

2、开启强制全库缓存模式数据库兼容性级别必需是12.0.0或者更高；

3、enabling force full database caching mode:
     1)连接到数据库并有alter database系统权限：

     2）数据库启动到mount状态；

     3)执行下面命令：

     SQL>  ALTER DATABASE FORCE FULL DATABASE CACHING;

          Database altered.

    4）打开数据库：

     SQL> alter database open;

        Database altered.

   SQL> SELECT FORCE_FULL_DB_CACHING FROM V$DATABASE;

        FOR

        ---

        YES

4、disabling  force full database caching mode:

SQL> startup mount;

ORACLE instance started.

Total System Global Area  616562688 bytes

Fixed Size     2927384 bytes

Variable Size   478151912 bytes

Database Buffers   130023424 bytes

Redo Buffers     5459968 bytes

Database mounted.

SQL> ALTER DATABASE NO FORCE FULL DATABASE CACHING;

Database altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL>