-
Title
Error in SGA Inspector "Your current login does not have access to..." -
Description
When trying to setup an SGA Inspector job, the following error is displayed:
"Your current login does not have access to SYS.V_$SQLAREA and SYS.V_$SQLTEXT_WITH_NEWLINES (or SYS.V_$SQLTEXT) that are required to perform inspection -
Cause
User has insufficent privileges
-
Resolution
The following select privileges are required to run SGA Inspector:
SQL to Collect - Executed SQL from SQL Area:
Access is needed to these system views:
SYS.V_$SQLAREA and SYS.V_$SQLTEXT_WITH_NEWLINES (or SYS.V_$SQLTEXT depending on your version of Oracle)
In Oracle 9 or later, SYS.V$_SQL_PLAN
SQL to Collect: Currently executing SQL- Access is needed to these system views:
SYS.V_$OPEN_CURSOR, SYS.V_$SESSION, SYS.V_$SQLAREA and SYS.V_$SQLTEXT_WITH_NEWLINES (or SYS.V_$SQLTEXT depending on your
version of Oracle)
In Oracle 9 or later, SYS.V$_SQL_PLAN
Flush Oracle shared pool:
ALTER SYSTEM privilege is needed.
Execution Plan Information:
Oracle 9 or above is required.
Access is needed to this system view: SYS.V_$SQL_Plan
* Please also review additional information * -
Additional Information
If the Oracle init parameter O7_DICTIONARY_ACCESSIBILITY (Oracle 8 or above) is set to false, objects under SYS are not accessible, even for a user with the SELECT ANY TABLE privilege granted. In this case, the SELECT ANY DICTIONARY privilege or the SELECT_CATALOG_ROLE role is needed to access the objects under SYS.
Please review Help | Contents | Database Privileges for a full list of privileges required for each module of Optimizer