Re: Metrics for Management

Seriously, how about:

    number of users who phoned up to complain about     slow screen response times in last 24 hours

    number of users who phoned up to complain about     reports taking to long to run in last 24 hours.

    number of times processes crashed because of     database configuration problem.

Have drill downs to (respectively):

    Users who complained that response time     in screen X was in excess of 2 seconds

    Users who complained that report Y took     longer than 3 minutes to appear.

    Number of times process crashed with     'maxextents' reached.

It might focus attention in the right direction, and allow you to say.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
 UK  Sept
 Australia August
 Malaysia September
 USA x 2  November

http://www.jlcomp.demon.co.uk/seminar.html

Vince Laurent wrote in message
<0gldju0d03i1po9e8n69qagmaukp932k6a_at_4ax.com>...


>I got this e-mail the other day from one of our system support folks:

>

>"MANAGER asked me to identify Oracle metrics collected by OVO to be

>displayed on the Metrics database web page.  I'm hoping that the three

>of you could give some direction on which metrics may by useful.  If

>you have time, scan the list below and let me know which of the

>metrics could be used for capacity planning or fault prevention.

>

>Here are some I selected (let me know if you agree or disagree with

>their usefulness)

>

># of segments approaching max extent (E017_SegMaxExtentCnt)

>Disk sort rate (E019_SortDiskRate)

>Total buffer cache hit % (E022_TotBufCacHitPct)

>Rate of background checkpoints completed (E035_BckgndCkptRate)

>Table spaces with low free space ; drill down (E206_TblSpFreePct)"

>

>What I am trying to figure out is what are good metrics both to keep

>MANAGEMENT happy as well as help me do my job?  Right now I track

>database growth and number of users.   What are any of you doing out

>in the real world?

>

>Thanks!

>Vince