Re: ADO/ILM policy

Posted by ErmanArslansOracleBlog on Nov 09, 2018; 7:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ADO-ILM-policy-tp6926p6930.html

Did you read the manual?
There it says :

For TIER TO tablespace

Data will be migrated when data usage of the tablespace quota reaches the percentage defined by TBS_PERCENT_USED. The database will make a best effort to migrate enough data so that the amount of free space within the tablespace quota reaches the percentage defined by TBS_PERCENT_FREE. Refer to Oracle Database PL/SQL Packages and Types Reference for more information on TBS_PERCENT_USED and TBS_PERCENT_FREE, which are constants in the DBMS_ILM_ADMIN package.

Ref: https://docs.oracle.com/database/121/SQLRF/statements_3001.htm