Result Cache disabled in Oracle 12c Enterprise - BYPASS status
which returns BYPASS.


Then enable it:

SQL&gt; SELECT dbms_result_cache.status() FROM dual;

DBMS_RESULT_CACHE.STATUS()
--------------------------------------------------------------------------------
ENABLED

SQL&gt; exec dbms_result_cache.bypass(true, false);

PL/SQL procedure successfully completed.

SQL&gt; SELECT dbms_result_cache.status() FROM dual;

DBMS_RESULT_CACHE.STATUS()
--------------------------------------------------------------------------------
BYPASS

SQL&gt; exec dbms_result_cache.bypass(false, false);

PL/SQL procedure successfully completed.

SQL&gt; SELECT dbms_result_cache.status() FROM dual;

DBMS_RESULT_CACHE.STATUS()
--------------------------------------------------------------------------------
ENABLED

SQL&gt;


DBMS_RESULT_CACHE.BYPASS