So much performance data - which are the key ones to see if DB is tuned

[Former Member]

There is so much metrics in SAP CCMS DB02 and DBAcockpit. WHat are some of the key metrics to look for when trying to determine if my DB is tuned properly.

Some are obvious like cache hit percentage but I wonder if some one could suggest metrics to look at and also if you could explain what they mean...

I am running Oracle 10.2.0.4 on UNIX with 16 CPUs

Thanks

Weyland Yutani

[stefan_koehler · Accepted solution]

Hello Weyland,

some key factors / threshold are mentioned in the "SAP/Oracle Performance Monitoring Strategies":

http://help.sap.com/saphelp_nw70ehp2/helpdata/en/c4/3a71ef505211d189550000e829fbbd/content.htm

The explanation of the metrics is here:

http://help.sap.com/saphelp_nw70ehp2/helpdata/en/c4/3a6fda505211d189550000e829fbbd/frameset.htm

> What are some of the key metrics to look for when trying to determine if my DB is tuned properly.

That is the wrong approach .. if your end users are happy and satisfied with the performance - no need to tune anything.

I have seen several cases in which some DBAs tried to "tune" a well running database just to be "pro-active" and things getting worse.

If you see performance issues the first questions should be: "Is this a general performance issue or just for a specific transaction" ..

Regards

Stefan