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