Since it's management. Give them ratios! I think this is the perfect use for
ratios.
On 10/28/05, Stephane Faroult <sfaroult_at_roughsea.com> wrote:
>
> On Fri, 2005-10-28 at 15:56 -0400, Lou Avrami wrote:
> > Hello all,
> >
> > Upper management has just ask my group to provide performance metrics
> for our database servers and databases. Even after a couple of conversations
> we're not quite sure what they mean by "performance metrics", and I'm sure
> they aren't quite sure what they mean, either. ;)
> >
> > We could give them Statspack report output, but that probably would be
> too much information.
> >
> > If anyone out there has any ideas on what kind of (very) high-level
> Oracle database metrics might be appropriate, it would be very helpful.
> >
> > Thanks,
> > Lou Avrami
> > --
> > http://www.freelists.org/webpage/oracle-l
>
>
>
> Lou,
>
> These values can be found in a Statspack report, but in my view they
> give a fair idea of what's going on:
>
> * Logical I/Os
> * Physical I/Os
> * Number of active users
> * Number of executions
> * Number of hard-parses
> * Amount of redo generated
> * Number of bytes returned
>
> None of the values is very significant by itself. But seeing how they
> evolve can be interesting, and when you compare the profiles (over time)
> of various applications it is often interesting.
>
> HTH
>
> Stephane Faroult
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 28 2005 - 16:22:29 CDT
