Can't find what you're looking for? Use of one of the search websites below …
Bing Google Yahoo! Site (Default)
Some ADDM dumps.
[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>
Name (required)
Mail (will not be published) (required)
Website
Oracle Advisor – DBMS_ADVISOR
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>