Oracle | DBMS_XS

Oracle DBMS_XS_MTCACHE Version 21c

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

SET_RETENTION_TIME

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