| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Undocumented utility utilized to clean-up the Client Result Cache |
| AUTHID |
CURRENT_USER |
| Data Types |
TYPE crc_rcln IS RECORD (
regid NUMBER,
username VARCHAR2,
location_name VARCHAR2,
subscription_name VARCHAR2);
TYPE crc_trcln IS TABLE of crc_rcln; |
| Dependencies |
| DBMS_ASSERT |
GV$SESSION_CLIENT_RESULT_CACHE |
PLITBLM |
| DBMS_LOCK |
INVALIDATION_REGISTRY$ |
REG$ |
| DBMS_SYSTEM |
|
|
|
| Documented |
No |
| First Available |
11.2 |
| Security Model |
Owned by SYS with no privileges granted |
| Source |
{ORACLE_HOME}/rdbms/admin/prvthcrc.plb |
| |
| CACHE_CLEANUP |
| Client result cache clean-up |
dbms_client_result_cache.cache_cleanup(flags IN NUMBER)
RETURN dbms_client_result_cache.crc_trcln; |
conn sys@pdbdev as sysdba
SELECT * FROM TABLE(dbms_client_result_cache.cache_cleanup(1));
no rows selected |