Oracle-L: Re: Database Metrics

From: Yechiel Adar <adaryechiel_at_HOTMAIL.COM>
Date: Tue, 30 Apr 2002 04:28:27 -0800
Message-ID: <F001.004530A3.20020430042827@fatcity.com>

Database MetricsHello Yuval Arnon

I will use three graphs:

Number of SQL statements executed per day.
Mean response time.
CPU usage per day.

In both cases add a reference point that is the mean of the last 30-40 days so they can see any abnormal behavior.

The space statistics are for you and use them only quarterly for management.

If you can add a graph for important applications.

Yechiel Adar
Mehish

Original Message ----- From: Yuval Arnon To: Multiple recipients of list ORACLE-L Sent: Monday, April 29, 2002 7:23 PM Subject: Database Metrics

Hi,

I am looking for ideas on what kind of metrics the DBA group should provide the management on a weekly basis so they can understand how the databases are evolving over time.

These metrics should be simple enough as the management is not Oracle savvy.

Thanks in advance!

Yuval.

Sr. DBA - WWF

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Yechiel Adar
INET: adaryechiel_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 30 2002 - 07:28:27 CDT