Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Provides an interface to customize Automatic Data Optimization (ADO) policy execution. In combination with partitioning and compression, ADO policies can be used to help implement an Information Lifecycle Management (ILM) strategy.
Clear all or some statistics for a table: deletes rows for the that matches a given pattern or all such rows
dbms_ilm_admin.clear_heat_map_table(
owner IN VARCHAR2,
tablename IN VARCHAR2,
partition IN VARCHAR2 DEFAULT '',
access_date IN DATE DEFAULT NULL,
segment_access_summary IN NUMBER DEFAULT NULL);
dbms_ilm_admin.set_heat_map_start(start_date IN DATE);
exec dbms_ilm_admin.set_heat_map_start(SYSDATE + 1/24);
*
ERROR at line 1:
ORA-38327: invalid argument value
ORA-06512: at "SYS.DBMS_ILM_ADMIN", line 541
ORA-06512: at line 1
-- not sure how this can be an invalid argument ... but why argue with an Oracle exception?
Update or insert heat map rows for the identified segment
dbms_ilm_admin.set_heat_map_table(
owner IN VARCHAR2,
tablename IN VARCHAR2,
partition IN VARCHAR2 DEFAULT '',
access_date IN DATE,
segment_access_summary IN NUMBER);