Oracle 11g 自动任务

最新推荐文章于 2025-04-16 21:12:31 发布

dataminer_2007

最新推荐文章于 2025-04-16 21:12:31 发布

阅读量1.3w

点赞数

分类专栏： Oracle 基础文章标签： oracle 11g 自动任务

本文链接：https://blog.csdn.net/dataminer_2007/article/details/41363417

版权

Oracle 11g 自动任务包括Automatic Optimizer Statistics Collection、Automatic Segment Advisor和Automatic SQL Tuning Advisor，用于数据库维护。这些任务在预定的低系统负载时间段——维护窗口内运行。默认维护窗口如周一至周五晚上10点到凌晨2点，周六、日早上6点到下午2点。可以通过dbms_auto_task_admin和dbms_scheduler包来启用、禁用或调整任务和窗口。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Automated maintenance tasks are tasks that are started automatically at regular intervals to perform maintenance operations on the database. An example is a task that gathers statistics on schema objects for the query optimizer. Automated maintenance tasks run in maintenance windows, which are predefined time intervals that are intended to occur during a period of low system load. You can customize maintenance windows based on the resource usage patterns of your database, or disable certain default windows from running. You can also create your own maintenance windows.

oracle 数据库预先定义了自动任务的三个功能：

1. Automatic Optimizer Statistics Collection

对没有统计信息或者过时统计信息的数据库对象进行收集统计信息，用来提高 sql 执行效率

2. Automatic Segment Advisor

建议回收哪些段空间可以回收

3. Automatic SQL Tuning Advisor

检测高负载的 sql 语句性能，并建议如何进行调优

SQL> select client_name, task_name, operation_name, status from dba_autotask_task;

CLIENT_NAME TASK_NAME OPERATION_NAME STATUS
---------------------------------------------------------------------------------------------------------------------------------

sql tuning advisor AUTO_SQL_TUNING_PROG automatic sql tuning task ENABLED

auto optimizer stats collection gather_stats_prog auto optimizer stats job ENABLED

auto space advisor auto_space_advisor_prog auto space advisor job ENABLED