Metrics for Management

From: Vince Laurent <vlaurent_at_NOSPAM.networkusa.net>
Date: Thu, 18 Jul 2002 09:54:13 -0500
Message-ID: <0gldju0d03i1po9e8n69qagmaukp932k6a@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 Received on Thu Jul 18 2002 - 09:54:13 CDT