Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Assuming, of course, you have licensed this feature (with respect to a production system).
Diagnostics Pack features can also be accessed by way of database server APIs and command-line interfaces:
*The DBMS_WORKLOAD_REPOSITORY package is part of this pack.
*The DBMS_ADVISOR package is part of this pack if you specify ADDM as the value of the advisor_name parameter, or if you specify for the value of the task_name parameter any value starting with the ADDM prefix.
*The V$ACTIVE_SESSION_HISTORY dynamic performance view is part of this pack.
*All data dictionary views beginning with the prefix DBA_HIST_ are part of this pack, along with their underlying tables. *All data dictionary views with the prefix DBA_ADVISOR_ are part of this pack if queries to these views return rows with the value ADDM in the ADVISOR_NAME column or a value of ADDM* in the TASK_NAME column or the corresponding TASK_ID.
*The following reports found in the /rdbms/admin/ directory of the Oracle home directory are part of this pack: awrrpt.sql, awrrpti.sql, addmrtp.sql, addmrpti.sql, awrrpt.sql, awrrpti.sql, addmrpt.sql, addmrpti.sql, ashrpt.sql, ashrpti.sql, awrddrpt.sql, awrddrpi.sql, awrsqrpi.sql, awrsqrpt.sql.
Reply With Quote
Bookmarks