The DBMS_RESULT_CACHE package

The Oracle-supplied package DBMS_RESULT_CACHE is used to regulate the Server Result Cache component of the shared pool. The package is owned by SYS and only privileged users should be granted the EXECUTE privilege.

The public constants used in the package are as follows:

DBMS_RESULT_CACHE constants (reference: Oracle documentation)
STATUS_BYPS	CONSTANT VARCHAR(10) := 'BYPASS';
STATUS_DISA	CONSTANT VARCHAR(10) := 'DISABLED';
STATUS_ENAB	CONSTANT VARCHAR(10) := 'ENABLED';
STATUS_SYNC	CONSTANT VARCHAR(10) := 'SYNC';
STATUS_CORR	CONSTANT VARCHAR(10) := 'CORRUPT';

The subprograms used in the package are described in the following table:

DBMS_RESULT_CACHE subprograms (reference: Oracle documentation)
BYPASS procedure	If set to TRUE, the result cache usage is bypassed in the current or every session. Used when modifying and recompiling a PL/SQL function whose results have been cached earlier. In RAC, since each instance has its own server cache, the BYPASS...