SQL Performance (MOSC)

MOSC Banner

Sql tuning advisor failed with error ORA-01031: insufficient privileges

I received error during run sql tuning advisor.

DBMS_SQLTUNE.REPORT_TUNING_TASK('8YKNX2KVZXQ9D_TUNING_TASK')

----------------------------------------------------------------------------------------------------


-------------------------------------------------------------------------------

ERRORS SECTION

-------------------------------------------------------------------------------

- ORA-01031: insufficient privileges


user have these privileges:

CONNECT

CWM_USER

OEM_ADVISOR

OEM_MONITOR

OLAP_USER

OWB$CLIENT

OWBR_RRO

OWB_DESIGNCENTER_VIEW

OWB_D_RRO

OWB_O_RRO

OWB_RRO

OWB_USER

ADMINISTER ANY SQL TUNING SET

ADMINISTER SQL TUNING SET

ADVISOR

ALTER ANY SQL PROFILE

ALTER SESSION

CREATE ANY DIRECTORY

CREATE ANY SQL PROFILE

CREATE CREDENTIAL

CREATE DATABASE LINK

CREATE DIMENSION

CREATE INDEXTYPE

CREATE JOB

CREATE MATERIALIZED VIEW

CREATE PROCEDURE

CREATE PUBLIC DATABASE LINK

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