Re: Performance metrics
Date: Wed, 11 Apr 2012 20:34:54 +0200
Message-ID: <CALH8A93Yz=9p8L_u99LUmP5ienBL9mr75-2cnQj2x4EeU1V73Q_at_mail.gmail.com>
Hi,
for me it seams there was a dangerous shortcut between [applications]
performance and [database] indicators.
Unfortunately there is no default path for this shortcut. You will
have to find your own.
This can be somehow tricky, but as a simple start you have to find the
main contributor of DB time to your application.
You can then monitor these contributors - if they increase
dramatically in amount or time, it will become dangerous.
Another method is to check for the appearance of 'new' waits - this can also be a sign of an unwanted change within your system.
sorry, no simple answer; such as the question also is not simple :-(
hth
Martin
On Wed, Apr 11, 2012 at 18:17, Orlando L <oralrnr_at_gmail.com> wrote:
> Hi List
> We have been asked to come up with key performance indicators for the
> databases running in our company. The idea is to identify when things start
> to go wrong. Can you please share the methods that are used for such
> purposes.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 11 2012 - 13:34:54 CDT