Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1354762
  • 博文数量: 239
  • 博客积分: 5909
  • 博客等级: 大校
  • 技术积分: 2715
  • 用 户 组: 普通用户
  • 注册时间: 2010-07-24 20:19
文章分类

全部博文(239)

文章存档

2014年(4)

2013年(22)

2012年(140)

2011年(14)

2010年(59)

我的朋友

分类: Oracle

2012-08-10 16:44:38

Changes between 10g and 11g.

Resource Manager:

Subject10g11g
Maintenance Window 2 windows, WEEK and WEEKEND Each day has its own window
Resource manager Not enabled per default Default resource plan specified

 

Sql Tunning Advisory:

Oracle Database 11g, by default, the Automatic Tunning Optimizer runs regularly during the Oracle scheduler Maintenance window, as the new automated maintenance task called the SQL Tunning Advisory task.


So this is a default behavior in Oracle 11g.

Solution

1]. To disable the resource manager you can use the below steps.

++ set the current resource manager plan to null (or another plan that is not restrictive):

alter system set resource_manager_plan='' scope=both

++ change the active windows to use the null resource manager plan (or other nonrestrictive plan) using:

execute dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','RESOURCE_PLAN',''); and
execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');

++ Then, for each window_name (WINDOW_NAME from DBA_SCHEDULER_WINDOWS), run:

SQL> execute dbms_scheduler.set_attribute('','RESOURCE_PLAN','');

 


2]. To disable SQL tunning you can use the below procedure.  

BEGIN
DBMS_AUTO_TASK_ADMIN.DISABLE(
client_name => 'sql tuning advisor',
operation => NULL,
window_name => NULL);
END;
/
阅读(2243) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~