Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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));