|
- 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_history order by time_suggested desc;
复制代码
|
|