OEM ADDM & Tuning Pack

[Former Member]

Hi Friends,

I'm evaluating the Oracle Diagnostic pack and tuning pack to compliment the already available standard SAP tool for tuning like st04/st03n,etc

Few questions

1. Anyone see the worth of the above 2 pack ?

2.sto4 can show you only so much why certain read/write in DB is slow, will this be the better tool in market for diagnostics

3. Anyone sees negative impact/ horror stories due to this?

4. Oracle has improvised OEM in 11g and 10g significantly, any inputs on this and usage on RAC

5. Any other great inputs are welcomed as well

Thanks & Best Regards,

Naren

[Former Member]

Hi Naren,

From an Oracle DBA perspective, which is where am coming from, these tools are very helpful but because you are on SAP where you are really bound by SAP metrics, these are not going to be helpful to you because SAP recommendation supercedes Oracle's recommednation.

Note also that these packs require a separate license. If you are not licensed to use it, you should not be using them. From Oracle10g onward, Oracle had a record everytime that you use the diagnostic pack. You should have gotten this warning the first time that you try and use the diagnostic pack.

IMHO, most tuning are supposed to be coming from an application end and this is what most of the OEM reports will show you, the most expensive SQLs, you need to put index here and there, log switching, memory not enough etc. Most of these are already discussed in SAP notes. Additional indexes if ever one is identified, you will still have to get SAP Support to approve that, so what's the point?

[Former Member]

I'm looking at this kind of scenario

users are complaining a transaction is slow in SAP r/3

and this problem us happening intermittently

say somedays 9am and somedays 4pm.

St05 trace shows you which SQL statement is taking longer time. Last week

the transaction was working fine without any intermittent issue

how do you find in these kind of situation what where and what is causing

the bottleneck?

Sto4/st05 doesn't tell you why it is slow

The transaction reading and updating table A and B, and what is the intermittent cause

of the slowness is not known in standard sap transaction

[Former Member]

There are so much to say about the diagnostics and tuning pack.

Considering one simple example ...

How would st04/st03 help in tuning sql queries .. Assuming u r running 10g u have utilities like sql_tuning_task and obtain recommedation to help tune the query ..

Moreover addm and AWR snapshot reports are far more helpful in diagnosing problems associated with DB.

Rgrds

Kausik

Edited by: Kausik Mitra on Jun 11, 2010 12:52 PM