SQL Tuning Advisor tool

[SAPSupport]

it is necessary to execute an Oracle tool: SQL Tuning Advisor, using the provided SQL IDs in the report. However, the problem is that the tool is not installed. Could you please provide us with the procedure and SQL commands to perform it manually?

Could you please forward the manual sql command to run the SQL Tuning Advisor tool .

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

As of Enhancement Package 1 for Basis Release 7.00 (that is, Basis Release 7.01), the function "SQL Tuning Advisor" is contained in the DBA Cockpit. This optional function requires the Oracle Tuning Pack to be licensed. (If you have purchased the Oracle license from SAP, the tuning package is included in the license.)
The function "SQL Tuning Advisor" is hidden by default, even for the local system. If you require this function and you have a licensed tuning pack, the following procedure is necessary to activate the function.

For details see note
1028068-Required Oracle options for the DBA Cockpit

For single sql analysis see note
1257075 - SQL_ID Data Collector (Oracle 10.2.0.2 or higher)