RE: 3rd Party Database health check
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 09 Feb 2004 10:03:02 +0000
That's not a health check, you did stuff. :(=20
> -----Original Message-----
> From: mln@xxxxxxxxxxxx=20
> Sent: 07 February 2004 09:58
> To: mln@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Cc: jvd@xxxxxxxxxxxx
> Subject: Re: 3rd Party Database health check
>=20
>=20
> Can't have enough 9's there :). I was at a customer site the=20
> other day=20
> (a Siebel implementation, but that's not the point), and it was=20
> beautiful to watch:
>=20
> First they showed me OEM displaying a BCHR of 99.99. Yet they had a=20
> problem...
> Then they showed me that a certain piece of SQL took 452=20
> seconds to run.=20
> It had to run every few minutes, so that was a problem.
> Then the IT director informed me that they were about to buy=20
> four GB RAM=20
> on top of the four they already had.
> The IT manager told me they were also going to buy four more disks=20
> because they had four empty slots in the cabinet.
> Then Johannes looked at the query and brought it down to 18=20
> seconds by=20
> moving stuff around and adding a hint, and down to 6 seconds=20
> by adding=20
> an index.
> They are going to buy the disks anyway, but they won't buy=20
> the extra RAM=20
> just yet. Oh well.
>=20
> Johannes - remember to bill the customer, by the way, will you?
>=20
> Mogens
>=20
> Kirtikumar Deshpande wrote:
>=20
> >Sure we monitored that too....=20
> >.... but the warning/alarm threshold was a bit low.... (like=20
> 2 or 5%).=20
> >
> >:)=20
> >
> >- Kirti=20
> >
> >--- Mladen Gogala <mladen@xxxxxxxxxxxxxxx> wrote:
> > =20
> >
> >>On 02/04/2004 01:28:58 PM, Kirtikumar Deshpande wrote:
> >> =20
> >>
> >>>From all those 60-100 "database parameters" Patrol=20
> monitored, we had
> >>>found about 10 or so to be of
> >>>any help to the DBA with Oracle 7 and 8, mainly.
> >>> =20
> >>>
> >>You were supposed to monitor the buffer hit ratio, don't=20
> you know that?
> >> =20
> >>
> >
> >
> >
> >__________________________________
> >Do you Yahoo!?
> >Yahoo! SiteBuilder - Free web site building tool. Try it!
> >http://webhosting.yahoo.com/ps/sb/
> >----------------------------------------------------------------
> >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
> >-----------------------------------------------------------------
> >
> > =20
> >
>=20
>=20
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>=20
>=20
**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************
----------------------------------------------------------------
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:
