课程第41次

botang

1. BEGIN
   
2. dbms_sqltune.set_auto_tuning_task_parameter( 'ACCEPT_SQL_PROFILES', 'TRUE');
   
3. END;
   
4. 
   

复制代码

1. <p>BEGIN
   
2. DBMS_SCHEDULER.DISABLE(
   
3. name=>'"SYS"."FRIDAY_WINDOW"',
   
4. force=>TRUE);
   
5. END;</p><p>BEGIN
   
6. DBMS_SCHEDULER.SET_ATTRIBUTE(
   
7. name=>'"SYS"."FRIDAY_WINDOW"',
   
8. attribute=>'REPEAT_INTERVAL',
   
9. value=>'FREQ=WEEKLY;BYDAY=FRI;BYHOUR=9;BYMINUTE=51;BYSECOND=10');
   
10. END;</p><p>BEGIN
    
11. DBMS_SCHEDULER.ENABLE(
    
12. name=>'"SYS"."FRIDAY_WINDOW"');
    
13. END;
    
14. </p>

复制代码

上图中incident部分（比较早）来自ADR
下面黄色图标的来自AWR
最后ADDM

1. select * from dba_sql_profiles;
   
2. 
   
3. begin
   
4.    dbms_Sqltune.drop_sql_profile(name => 'SYS_SQLPROF_016c9d4edd8c0000');
   
5. end;
   
6. 
   
7. select  * from dba_outstanding_alerts;
   
8. 
   
9. select  * from dba_alert_history  order by time_suggested  desc;

复制代码