botang 发表于 2019-8-17 09:47:12

课程第41次

BEGIN
dbms_sqltune.set_auto_tuning_task_parameter( 'ACCEPT_SQL_PROFILES', 'TRUE');
END;


<p>BEGIN
DBMS_SCHEDULER.DISABLE(
name=>'"SYS"."FRIDAY_WINDOW"',
force=>TRUE);
END;</p><p>BEGIN
DBMS_SCHEDULER.SET_ATTRIBUTE(
name=>'"SYS"."FRIDAY_WINDOW"',
attribute=>'REPEAT_INTERVAL',
value=>'FREQ=WEEKLY;BYDAY=FRI;BYHOUR=9;BYMINUTE=51;BYSECOND=10');
END;</p><p>BEGIN
DBMS_SCHEDULER.ENABLE(
name=>'"SYS"."FRIDAY_WINDOW"');
END;
</p>



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


select * from dba_sql_profiles;

begin
   dbms_Sqltune.drop_sql_profile(name => 'SYS_SQLPROF_016c9d4edd8c0000');
end;

select* from dba_outstanding_alerts;

select* from dba_alert_historyorder by time_suggesteddesc;






页: [1]
查看完整版本: 课程第41次