Re: Oracle metrics - any useful ideas on what to track?

While I fundementally agree with your sentiment, I get the feeling that the base reasoning is to start establishing some form of benchmarks for SLAs in the future.

The Oracle Press book on StatsPack gives some fairly good ideas on the types of information that are important (to some people), as do the fancy charts from the Enterprise Manager Diagnostics Pack.

/Hans

Niall Litchfield wrote:

> Then I would be very, very tempted to give them regular report.txts filled
> with all those ratios and waits and explain that these are the metrics you
> use to monitor performance and they are documented in the various oracle
> manuals. Quite frankly this sort of daftness needs to be stamped on. Yes it
> is reasonable for our performance to be measured, but you should measure it
> against the job that we are contracted to do. If your user community is only
> interested on uptime then that is all an auditor should be interested in.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "David Van Zandt" <dvanzandt_at_iquest.net> wrote in message
> news:dW%_6.34$q34.32879_at_news1.iquest.net...
> > Thanks John and Niall for your input. Your suggestions well illustrate
 the
> > difficultly of this decision. No, there is no precedent, nor do the user
> > community give a flip as long as we minimize unscheduled outages.
> > Notwithstanding these facts, the auditors "expect" trends as a
 documentation
> > requirement; and that foolishness will not change within the next month, I
> > fear.
> >
> > What I was trolling for were suggestions of what others may have found
> > useful to track, in order to broaden my range of ideas.
> >
> > Thanks again for your input!
> >
> >
> >
> >
> >
  Received on Tue Jul 03 2001 - 01:42:13 CDT