Segment Advisor Results
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Segment Advisor Results

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Segment Advisor Results

    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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Sure.
    Just query dba_advisor* views, like DBA_ADVISOR_RECOMMENDATIONS, DBA_ADVISOR_FINDINGS, DBA_ADVISOR_ACTIONS & DBA_ADVISOR_OBJECTS
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    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.

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    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.
    Last edited by stecal; 03-26-2010 at 11:59 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width