Re: 3rd Party Database health check

From: Mogens Nørgaard <mln_at_miracleas.dk>
Date: Sat, 07 Feb 2004 10:58:25 +0100
Message-ID: <4024B6C1.3030900@miracleas.dk>

Can't have enough 9's there :). I was at a customer site the other day (a Siebel implementation, but that's not the point), and it was beautiful to watch:

First they showed me OEM displaying a BCHR of 99.99. Yet they had a problem...
Then they showed me that a certain piece of SQL took 452 seconds to run. It had to run every few minutes, so that was a problem. Then the IT director informed me that they were about to buy four GB RAM on top of the four they already had.
The IT manager told me they were also going to buy four more disks because they had four empty slots in the cabinet. Then Johannes looked at the query and brought it down to 18 seconds by moving stuff around and adding a hint, and down to 6 seconds by adding an index.
They are going to buy the disks anyway, but they won't buy the extra RAM just yet. Oh well.

Johannes - remember to bill the customer, by the way, will you?

Mogens

Kirtikumar Deshpande wrote:

>Sure we monitored that too....
>.... but the warning/alarm threshold was a bit low.... (like 2 or 5%).
>
>:)
>
>- Kirti
>
>--- Mladen Gogala <mladen_at_wangtrading.com> wrote:
>
>
>>On 02/04/2004 01:28:58 PM, Kirtikumar Deshpande wrote:
>>
>>
>>>From all those 60-100 "database parameters" Patrol monitored, we had
>>>found about 10 or so to be of
>>>any help to the DBA with Oracle 7 and 8, mainly.
>>>
>>>
>>You were supposed to monitor the buffer hit ratio, don't you know that?
>>
>>
>
>
>
>__________________________________
>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
>-----------------------------------------------------------------
>
>
>

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 Sat Feb 07 2004 - 03:58:25 CST