That's not a health check, you did stuff. :(=20
> -----Original Message-----
> From: mln_at_miracleas.dk=20
> Sent: 07 February 2004 09:58
> To: mln_at_miracleas.dk; oracle-l_at_freelists.org
> Cc: jvd_at_MiracleAS.dk
> 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_at_wangtrading.com> 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_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
> >-----------------------------------------------------------------
> >
> > =20
> >
>=20
>=20
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>=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_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 Mon Feb 09 2004 - 04:03:02 CST
