RE: d/b health check
- From: "Nelson, Allan" <anelson@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 25 Aug 2004 12:03:17 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
=46AQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
