-
Title
How to remove or disable the Oracle Tuning Advisor in Toad for Oracle -
Description
How do I remove or disable the Oracle Tuning Advisor in Toad for Oracle since we are not licensed by Oracle to use the Oracle Tuning Advisor?
-
Resolution
Per Help File in Toad for Oracle, use *Toad Security to go to Database | Administer | Toad Security to launch a tool that will allow you to remove the Oracle Tuning Advisor. Once it is removed, no need to disable anything on the toolbar.
NOTE 1: To execute this feature, the DB user must be granted the "advisor" SYS privilege.
*NOTE 2: To use Toad Security, the security mechanism must be set up. Please reference the article in the Help File by going to Help | Contents in the main menu and type "Toad Features Security" (surrounded in double-quotes) and press enter. Click on the only topic displayed to see the article.
-
Additional Information
Here are some additional information about how to disable other Oracle Enterprise Manager (OEM) functionality in SOL50502:
https://support.quest.com/SUPPORT/index?page=solution&id=SOL50502&pmv=true