Automatic Segment Advisor

The Automatic Segment Advisor is an automated maintenance task that is configured to run during all maintenance windows.

The Automatic Segment Advisor does not analyze every database object. Instead, it examines database statistics, samples segment data, and then selects the following objects to analyze:

分析的三中對象：太積極的segment，超出規定（臨界值）的tablespace，增長太快的segments。

Tablespaces that have exceeded a critical or warning space threshold

Segments that have the most activity

Segments that have the highest growth rate

In addition, the Automatic Segment Advisor evaluates tables that are at least 10MB and that have at least three indexes to determine the amount of space saved if the tables are compressed with the advanced row compression method.

此外，自動段Advisor會評估至少10MB且至少有三個索引的表，以确定在使用進階行壓縮方法壓縮表時節省的空間量。

If an object is selected for analysis but the maintenance window expires before the Segment Advisor can process the object, the object is included in the next Automatic Segment Advisor run.

如果選擇對象進行分析但維護視窗在Segment Advisor處理對象之前到期，則該對象将包含在下一個Automatic Segment Advisor運作中。也就是說，選擇對象會分析的，不是在這個，就是在下一個。

You cannot change the set of tablespaces and segments that the Automatic Segment Advisor selects for analysis. You can, however, enable or disable the Automatic Segment Advisor task, change the times during which the Automatic Segment Advisor is scheduled to run, or adjust automated maintenance task system resource utilization

無法更改Automatic Segment Advisor選擇用于分析的表空間和段的集合。 但是，您可以啟用或禁用Automatic Segment Advisor 任務，更改Automatic Segment Advisor 計劃運作的時間，或調整自動維護任務系統資源使用率。

隻可以選擇用或不用，什麼時候用，和如何利用資源，至于我怎麼幹，你管不着。