Oracle XS_MTCACHE_INT
Version 26ai

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

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
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