cancel
Showing results for 
Search instead for 
Did you mean: 

Use of SQL Tuning pack in SAP

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

Hello Kapil,

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

Regards

Stefan

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Kapil,

which other options did you expect to find in ST04? SAP note 1028068 speaks only of the "SQL Tuning Advisor" which will be activated:

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.

The other features should be used via the OEM, because they are not integrated in the DBACOCKPIT transaction:

- Automatic SQL Tuning Advisor

- Real-time SQL Monitoring (with OEM you even get a really useful visualization)

- Object Reorganization Wizard -> better use brspace because it is supported by SAP

Regards,

Mark