Automatic Segment Advisor

最新推荐文章于 2021-04-06 18:21:18 发布

翻译最新推荐文章于 2021-04-06 18:21:18 发布 · 485 阅读

本内容遵循CC 4.0 BY-SA版权协议

原文链接：https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/managing-space-for-schema-objects.html#GUID-B2876330-007A-4299-9DBA-C1F3C0DCD13B

收录于

萌新

自动段顾问是一项自动化维护任务，分析过于活跃的数据库段、超限的表空间及快速增长的段，评估10MB以上且有三个索引的表进行高级行压缩的节省空间效果。无法修改其分析目标，但可调整运行时间和资源利用。

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 计划运行的时间，或调整自动维护任务系统资源利用率。
只可以选择用或不用，什么时候用，和如何利用资源，至于我怎么干，你管不着。