Can't find what you're looking for? Use of one of the search websites below …

HomeoracleNew Features10gOracle Advisor – DBMS_ADVISOR

Oracle Advisor – DBMS_ADVISOR

Published on Wednesday, September 5, 2007

Some ADDM dumps.

Remove all advisory reports (ADM).

[REMI@DB01.REMIDIAN.COM]
SQL> select 'exec dbms_advisor.delete_task(''' || TASK_NAME || ''' )' from dba_advisor_tasks;
 
'EXECDBMS_ADVISOR.DELETE_TASK('''||TASK_NAME||''')'
----------------------------------------------------------------
exec dbms_advisor.delete_task('SYS_AUTO_SPCADV_1300592007' )
exec dbms_advisor.delete_task('SYS_AUTO_SPCADV_2700592007' )
exec dbms_advisor.delete_task('SYS_AUTO_SPCADV_2220592007' )
exec dbms_advisor.delete_task('ADDM:1488676071_1_33108' )
exec dbms_advisor.delete_task('ADDM:1488676071_1_33113' )
 
[REMI@DB01.REMIDIAN.COM]
SQL>

Leave a Reply