You can customize your ADO environment with ILM ADO parameters described in Table 5-2.
Name | Description |
---|---|
|
The The settings of
|
|
The value for |
|
The value for |
|
The value of |
|
The value of |
|
The value for |
|
The value for |
For the values of the TBS_PERCENT
* parameters, ADO makes a best effort, but not a guarantee. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED
, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE
. As an example, assume that TBS_PERCENT_USED
is set to 85 and TBS_PERCENT_FREE
is set to 25
, and that a tablespace becomes 90
percent full. ADO then initiates actions to move data so that the tablespace quota has at least 25
percent free, which can also be interpreted as less than 75
percent used of the tablespace quota.
You can display the parameters with the DBA_ILMPARAMETERS
view. For example, the following query displays the values of the ADO-related parameters.
SQL> SELECT NAME, VALUE FROM DBA_ILMPARAMETERS; NAME VALUE ---------------------------------------------------------------- ---------- ENABLED 1 RETENTION TIME 30 JOB LIMIT 10 EXECUTION MODE 3 EXECUTION INTERVAL 15 TBS PERCENT USED 85 TBS PERCENT FREE 25 7 rows selected.
You can set ILM ADO parameters with the CUSTOMIZE_ILM
procedure in the DBMS_ILM_ADMIN
PL/SQL package, as shown in Example 5-8. For information about setting ILM ADO parameters with Oracle Enterprise Manager Cloud Control, refer to "Managing ILM Heat Map and ADO with Oracle Enterprise Manager".
Oracle Database PL/SQL Packages and Types Reference for information about the constants in the DBMS_ILM_ADMIN
package