Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

Grid Control (dbsnmp) SQL_TUNING_ADVISOR Access fro an 11.1 Database

I am using the 10.2.0.5 version of Grid Control.   One of the databases being monitored is at 11.1.0.7.    I want dbsnmp to be able to use the SQL_TUNING_ADVISOR.   I have set this up and am successful using the advisor  when the statement can be found  under "Top Activity",  but if the statment is no loger there, an "ORA-O1031" error is returned.   The dbsnmp user cannot read the recommendations.   If I temporarily give dbsnmp dba privileges, then it can read the recommendations.   So it looks like an access problem on some view or table

I tried granting dbsnp  "select any table", and also direct grants to the tables and views which  start with v_$, dba_hist, wrh, and wri,  but it still cannot read recommendations from statements not found under Top Activity.  I also granted direct access to dbsnmp to SYSMAN's tables and views.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center