"ORA-27486 insufficient privileges" Error When Running SQL Tuning Advisor

(Doc ID 338930.1)

Last updated on JANUARY 13, 2018

Applies to:

Enterprise Manager for Oracle Database - Version to [Release 10.2 to 11.1]
Information in this document applies to any platform.


When trying to run the SQL Tuning Advisor via 10g Grid Control the following error is displayed.

There is a problem tuning the SQL Statement
ORA-27486 insufficient privileges ORA-06512 at SYS.DBMS_ISCHED , line 99 ORA-06512 at SYS.DBMS_SCHEDULER , line 262 ORA-06512 at line 1




Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms