One way is to have a baseline of measurements for each DB at a time when
performance is acceptable and then compare against a base line. (eg % of
sorts to disk is <1% for oltp, but for DW it is 30% and be concerned when
things deviate from norm sorts to disk for oltp >3% or some such thing.)
On the other hand, if you just want to look good you could just report
statistics in a vacumm eg buffer cache hit ratio.
I would suggest looking at the information provided by stats pack. That
should give you a few ideas.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"buckeye234" <member13594_at_dbforums.com> wrote in message
news:2639295.1047564932_at_dbforums.com...
>
> What Performance Metrics are generally used to show to non-techincal
> upper management how databases are performance. Using the latest
> buzz-words, I need to provide Key Performance Indicators, in the form of
> somewhat generic graphs, to show how the database group is providing
> quality customer service.
>
> My quandry is what metrics are generic enough across all types of Oracle
> databases (DSS, OLTP, DW, etc) that they provide real indications of
> how the databases are performing. Obviously, uptime is a no brainer.
> After that, my imagination fails me. Using the various Hit Ratios, I
> feel, aren't true indicators.
>
> I'm sure other people report on database performance and I am wondering
> what you use. If you can, please let me know your thoughts.
>
> Thanks.
> Patrick
>
> PS. We use versions of Oracle from 7.3 to 9.2. We run on Windows,
> Solaris and AIX.
>
> --
> Posted via http://dbforums.com
Received on Thu Mar 13 2003 - 09:49:56 CST
