37 积分	0 好友	3 主题

发消息

请教oracle11g Scheduler 中作业和自动维护任务的区别

1^#

发表于 2012-7-24 22:37:49 | 查看: 6621| 回复: 5

请教 oracle11g的 oracle scheduler中作业和自动维护任务有什么区别啊？谢谢
自己先了解了一下:
1.11g比10g多了三个维护任务：sql tuning advisor,auto optimizer stats collection ,auto space advisor
2.在10g中是通过scheduler job（作业）来实现的这三个任务的吧，不太确定
3.百度了下，有人认为oracle 11g 中sql tuning advisor,auto optimizer stats collection ,auto space advisor 这三个任务是通过11g中的某个scheduler job（作业)来实现的

请maclean解答一下，表示感谢！

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2012-7-24 22:38:51

延迟到明天回答，请耐心等待

回复只看该作者道具举报

songdeyouxiang

3^#

发表于 2012-7-24 22:42:01

呵呵

一个问题是请教 oracle11g的 oracle scheduler中作业和自动维护任务有什么区别
另外一个问题是11g 和10g实现方式不同的地方（如自动统计搜集，sql调优顾问等）

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2012-7-31 13:24:52

10g中使用scheduler job接口管理自动收集统计信息作业，在11g中更进一步使用专门的 auto task 接口专门管理自动统计信息作业及新加入的SQL TUNING作业

In Oracle10g they were created as separate jobs and visible in DBA_SCHEDULER_JOBS.JOB_NAME.
This has changed in Oracle 11g. The related view is DBA_AUTOTASK_WINDOW_CLIENTS.
The jobs are now only visible in DBA_SCHEDULER_JOBS with their system generated name once they are really executed.

auto collecting statistcs.png

GATHER_STATS_JOB
By default, GATHER_STATS_JOB is created during database creation, executes the
DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC procedure, and uses the Scheduler
(as shown in the diagram). Two windows are also defined by default:
• WEEKNIGHT_WINDOW defined between 10 PM and 6 AM daily from Monday through
Friday
• WEEKEND_WINDOW defined between 12 AM on Saturday and 12 AM on Monday
The default MAINTENANCE_WINDOW_GROUP is also defined to contain these windows.
GATHER_STATS_JOB uses a specific Scheduler class called AUTO_TASKS_JOB_CLASS.
This class is automatically created and is associated with a specific resource consumer group,
called AUTO_TASKS_CONSUMER_GROUP. This ensures that the task uses the
AUTO_TASKS_CONSUMER_GROUP. If you want to control resources used by
GATHER_STATS_JOB, define a resource manager plan for the
MAINTENANCE_WINDOW_GROUP that allocates resources for
AUTO_TASKS_CONSUMER_GROUP.
For GATHER_STATS_JOB to work properly, you must be sure that the STATISTICS_LEVEL
initialization parameter is set to at least TYPICAL.
Note: If GATHER_STATS_JOB exceeds the allocated time window defined by
MAINTENANCE_WINDOW_GROUP, the job continues until it is finished.

Changing the GATHER_STATS_JOB Schedule
You can customize the open times of the defined management windows by changing the time
interval and repeat frequency. You can also add resource plans to these windows to control the
resources used by GATHER_STATS_JOB.
You can perform this customization from Database Control > Server > Oracle Scheduler, and
then click the Windows link. The Scheduler Windows page is displayed, where you can select a
window and click the Edit button to change its characteristics.
Note: Although it is not recommended, you can disable automatic statistics gathering from
Database Control by going to the Jobs page from the Server tab and then disabling the
GATHER_STATS_JOB

回复只看该作者道具举报