Sympoms: auto space advisor job fails with the error:
Errors in file /opt/oracle10/diag/rdbms/rdb3/rdb/trace/rdb_j007_4209.trc:ORA-12012: error on auto execute of job"SYS"."ORA$AT_SA_SPC_SY_12310"ORA-20000: ORU-10027: buffer overflow, limit of 20000 byt
Look at the auto tasks enabled:
select * from dba_autotask_client;
Disable an auto task:
begin
dbms_auto_task_admin.DISABLE(client_name => 'auto space advisor', operation => NULL, window_name => NULL);
end;
Find which task runs failed:
select distinct client_name, window_name, job_status, job_info
from dba_autotask_job_history
where job_status <> 'SUCCEEDED'
order by 1,2;
Look at the results:
select * from DBA_ADVISOR_RECOMMENDATIONS
select * from DBA_ADVISOR_FINDINGS
order by
task_id desc
Retrieve ADDM report:
SELECT DBMS_ADVISOR.GET_TASK_REPORT('ADDM:1989330073_1_39440') from dual
| 
Меню сайта