| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Set and Return the Heat Map Retention Time in
Days. |
| AUTHID |
DEFINER |
| Constants |
| Name |
Data Type |
Value |
| General |
| RETENTION_TIME |
NUMBER |
1 |
| RETENTION_TIME_INFINITE |
NUMBER |
4294967295 |
|
| Dependencies |
| DBMS_HEAT_MAP_INTERNAL |
HEAT_MAP_PARAM$ |
| DBMS_ILM_ADMIN |
V$PARAMETER |
|
| Documented |
Yes |
| Exceptions |
| Error Code |
Reason |
| ORA-38327 |
Invalid Argument Value |
| ORA-38342 |
Heat map not enabled |
|
| First Available |
26ai |
| Security Model |
Owned by SYS with EXECUTE granted to the DBA role. |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsspu.sql |
| Subprograms |
|
| |
GET_RETENTION_TIME (new 26ai)  |
| Return the currently set retention time |
dbms_heat_map_admin.get_retention_time RETURN NUMBER; |
SELECT dbms_heat_map_admin.get_retention_time; |
| |
| SET_RETENTION_TIME (new 26ai) |
| Set the heat map retention time in days |
dbms_heat_map_admin.set_retention_time(days IN NUMBER); |
exec dbms_heat_map_admin.set_retention_time(10); |