Re: [C.D.O.S][Long...] How a DBA should handle a load-average-spike?

On 2006-12-17, DA Morgan <damorgan_at_psoug.org> wrote:
> Peter Smith [gjfc] wrote:
>> People,

[deletia]
>> The goal here is to find the application or person who started all
>> these processes.
>> Another goal is to find out if they are obstructed by anything and thus
>> prevented
>> from dying since they cannot finish their jobs.
>>
>>
>> So, that is my initial take on the high-load-average-spike scenario.
>> Do any of you have any comments which would be useful for the
>> DBA who needs a general set of guidelines for dealing with this
>> situation?
>>
>> ...Peter
>
> Is this a version of Oracle with the Resource Management such as

Resource manager will just make this worse. Your sessions will just be waiting on resource manager management rather than the OS itself.

You can keep the box from killing itself this way though. I've seen Linux and AIX boxes kill themselves from overload. Resource manager is a nice way to reign in Oracle so that the system still has something to manage itself with.

Now that only accounts for the situation where you need more cpu cycles.

If you are IO bound than you can have a load average of 30 and it's not really a problem. The end users may be having fits but the system and db will survive it.

> 9i or 10g? If so I would think the appropriate thing to do is refine
> one's policies to make it 'impossible' for it to happen again.>
> Installing the Grid Control and monitoring resources as well as
> using the ADDM should complete the picture.

Have the sysadmins install and monitor sar (or do this yourself).

-- 
	Nothing quite gives you an understanding of mysql's         |||
	popularity as does an attempt to do some simple date       / | \
	manipulations in postgres.

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com