Oracle DBMS_CLIENT_RESULT_CACHE
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Undocumented
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 11gR2
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthcrc.plb
 
CACHE_CLEANUP
Undocumented dbms_client_result_cache.cache_cleanup(flags IN NUMBER)
RETURN dbms_client_result_cache.crc_trcln;
conn sys@pdbdev as sysdba

SELECT dbms_client_result_cache.cache_cleanup(1)
FROM dual;

Related Topics
Built-in Functions
Built-in Packages
DBMS_RESULT_CACHE
DBMS_RESULT_CACHE_API
DBMS_RESULT_CACHE_INTERNAL
Result Cache (SQL)
Result Cache (PL/SQL)
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved