Oracle DBMS_XS_MTCACHE
Version 19c

General Information
Library Note Morgan's Library Page Header
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
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
Subprograms
 
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
Built-in Functions
Built-in Packages
XS_MTCACHE_INT
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx