RE: d/b health check

From: Nelson, Allan <anelson_at_miswaco.com>
Date: Wed, 25 Aug 2004 12:03:17 -0500
Message-ID: <7E0DB3A126BA9146AC30744E2B7E42459743C7@midhouhqxch01.net.smith.com>

I think a set of representative queries with based line response time is good if you can afford the extra load and the deck of queries is reasonably stable. Otherwise cultivate relationships with your most verbal users. They'll call once they know you care.

Allan

-----Original Message-----

=46rom: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Edgar Chupit Sent: Wednesday, August 25, 2004 7:45 AM To: Lord David
Subject: Re: d/b health check

Dear Lord,

LD> is it best to base it on statspack/bstat/estat, some form of=20
LD> response time breakdown (I'm reading Cary's book at the moment) or=20
LD> something else entirely.

Read deeply into it, and You will understand that main point is that You must concentrate on user actions (complains) and not on anything else like values of db "metrics".

The "healthy" database is database that is not doing anything.

--=20

Edgar

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ =46AQ is at http://www.freelists.org/help/fom-serve/cache/1.html

___________________________________________________________________________=

___
This email is intended solely for the person or entity to which it is = addressed and may contain confidential and/or privileged information. = Copying, forwarding or distributing this message by persons or entities = other than the addressee is prohibited. If you have received this email in = error, please contact the sender immediately and delete the material from = any computer. This email may have been monitored for policy compliance. = [021216]

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Aug 25 2004 - 12:28:36 CDT