How to get SQL Tuner option working in SQL Developer

A.JOSH

Hello. How can I enable/use SQL Tuner tool in SQL Developer. Currently it doesn't let me tune queries using this. Do I need to do any setup or need to have any special role in database to use this ?

thatJeffSmith-Oracle

I would be very very careful doing ANYTHING with the APPS account. Best to create an admin account and use that.

thatJeffSmith-Oracle

what happens when you try?

does it need database privileges, it's handled by PL/SQL APIs, so yeah, you need execute on those packages.

A.JOSH

It says, "To run SQL Tuning Advisor, user 'APPS' requires System Privilege 'ADMINISTER SQL TUNING SET'"

Does APPS come with this already ? If not, do we need to create a new dedicated user as such just to use this feature, in case we don't want to grant any additional privileges to existing users ?

thatJeffSmith-Oracle

I would be very very careful doing ANYTHING with the APPS account. Best to create an admin account and use that.

A.JOSH

I understand. Thanks a lot !

A.JOSH

I'll try to have a new account created and will see if that helps. I hope the tuning advisor feature helps in tuning heavy queries as well..