SQL Performance (MOSC)

MOSC Banner

granting SQL tuning Advisor to a user

edited Jul 4, 2017 5:01AM in SQL Performance (MOSC) 3 commentsAnswered

Hello,

I am trying to give running STA (SQL tuning Advisor) to a user tst_user and i have the stored proc under sys schema.

SQL> select * from dba_sys_privs where grantee = 'TST_USER' ;

GRANTEE                        PRIVILEGE                                ADMIN_OPT

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

TST_USER                       ADVISOR                                  NO

TST_USER                       CREATE SESSION                           NO

Log running it as tst_user -

SQL> set serverout on

SQL> sho user

USER is "TST_USER"

SQL> exec sys.CIGNA_STA('1xn0w30cskk5h') ;

GENERAL INFORMATION SECTION

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

Tuning Task Name   : ST_06_21_2017_12_32_05

Tuning Task Owner  :

TST_USER

Workload Type      : Single SQL Statement

Scope              : COMPREHENSIVE

Time Limit(seconds): 500

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