O'Reilly logo

Advanced Oracle PL/SQL Developer's Guide - Second Edition by Saurabh K. Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required