| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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;
exec dbms_xs_mtcache.set_retention_time(42);
SELECT dbms_xs_mtcache.get_retention_time;
-- an exception is not generated but the retention time is not obviously altered |