 |
|
|
Each ADDM tuning task submitted for analysis has the potential to consume significant database time, and the last thing the DBA wants to create is a performance problem. It is recommended that the DBA execute the advisor tasks at times when the database workload is quite low, for example, at night. The dbms_advisor package contains a set of routines that allow tasks to be interpreted, reset, restarted, or deleted: § Procedure interrupt_task stops the currently running task. Recommendations that have already been generated will be preserved in the database. § Procedure reset_task allows the DBA to reset a task to its initial state by removing all the parameter and recommendation data from the database. § Procedure resume_task resumes the previously interrupted task. § Procedure delete_task completely removes a task and all its associated information from the database. § Procedure set_default_task_parameter is useful for setting task parameter defaults for all subsequent advisor tasks. This allows the DBA to specify defaults for common task parameters of a particular advisor. The ADDM Advisor can be extremely beneficial as a tuning tool when properly used. Now it’s time to explore how to use the SQLAccess Advisor tool as a diagnostic aid for Oracle tuning.
|
|
|
