ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
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));
