Use of SQL Tuning pack in SAP

[Former Member]

We have activated the Oracle 'SQL Tuning pack' however only one function "SQL Tuning Advisor" is activated/visible in ST04

and other functionality is not visible. We have already taken license of 'SQL Tuning pack' .

Other then this we want to use following oracle supported features.

1) Automatic SQL Tuning Advisor

2) Real-time SQL Monitoring

3) Object Reorganization Wizard

As I know we can use "oracle enterprise manager" to use such oracle features, If SAP allow use of OEM in SAP environment.

can someone help here please..?

Thanks,

Kapil Pandey

[stefan_koehler · Accepted solution]

Hello Kapil,

yes you are allowed to use OEM (Database Control & Grid Control) by SAP. For details please check sapnote #355770.

Regards

Stefan