Oracle XS_MTCACHE_INT
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose Internal package supporting Real Application Security
AUTHID CURRENT_USER
Dependencies
DBMS_RXS_LIB XS_ACL_INT XS_PRINCIPAL_INT
DBMS_XS_MTCACHE XS_ADMIN_UTIL_INT XS_SECURITY_CLASS_INT
Documented No
First Available 12.1
Security Model Owned by SYS with EXECUTE granted to the DBA role
Source {ORACLE_HOME}/rdbms/admin/prvtkzrxh.plb
Subprograms
 
MIDTIER_CACHE_DELETE
Undocumented xs_mtcache_int.midtier_cache_delete(
objtype IN BINARY_INTEGER,
id      IN NUMBER,
deltime IN TIMESTAMP);
TBD
MIDTIER_CACHE_UPDATE
Undocumented xs_mtcache_int.midtier_cache_update(
objtype IN BINARY_INTEGER,
modtime IN TIMESTAMP);
TBD
 
SET_RETENTION_TIME
Sets the retention time dbms_xs_mtcache_int.set_retention_time(newtime IN NUMBER);
SELECT dbms_xs_mtcache.get_retention_time;

GET_RETENTION_TIME
------------------
                 0


exec xs_mtcache_int.set_retention_time(42);

PL/SQL procedure successfully completed.

SELECT dbms_xs_mtcache.get_retention_time;

GET_RETENTION_TIME
------------------
                 0


-- no exception but the reported retention time is not altered

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_XS_MTCACHE
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved