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) | |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The subprograms used in the package are described in the following table:
|
DBMS_RESULT_CACHE subprograms (reference: Oracle documentation) | |
|---|---|
|
|
|
