Oracle | DBMS_XS

Oracle DBMS_XS_MTCACHE Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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