Oracle DBMS_XS_MTCACHE
Version 12.1.0.2

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
Dependencies
DUAL XS$CACHE_ACTIONS XS_MTCACHE_INT
Documented No
First Available Unknown
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtkzrxh.plb
 
GET_RETENTION_TIME
Retrieves the current retention time dbms_xs_mtcache.get_retention_time RETURN NUMBER;
See SET_RETENTION_TIME Demo Below
 
SET_RETENTION_TIME
Sets the retention time dbms_xs_mtcache.set_retention_time(newtime IN NUMBER);
SELECT dbms_xs_mtcache.get_retention_time
FROM dual;

exec dbms_xs_mtcache.set_retention_time(42);

SELECT dbms_xs_mtcache.get_retention_time
FROM dual;


-- an exception is not generated but the retention time is not obviously altered

Related Topics
Packages
What's New In 12cR1
What's New In 12cR2
XS_MTCACHE_INT

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