Is there a way to view the segment advisor results without Enterprise Manager?
I am on Solaris 10 , Oracle 10.2.0.3 enterprise edition. Thx
Printable View
Is there a way to view the segment advisor results without Enterprise Manager?
I am on Solaris 10 , Oracle 10.2.0.3 enterprise edition. Thx
Sure.
Just query dba_advisor* views, like DBA_ADVISOR_RECOMMENDATIONS, DBA_ADVISOR_FINDINGS, DBA_ADVISOR_ACTIONS & DBA_ADVISOR_OBJECTS
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.