Re: High CPU and IO Waits

From: HansF <News.Hans_at_telus.net>
Date: Sat, 02 Apr 2005 02:15:10 GMT
Message-Id: <pan.2005.04.02.03.16.48.160086@telus.net>

On Fri, 01 Apr 2005 17:59:00 +0100, Saeed interested us by writing:

>
> I think the correlation between IO Waits and high CPU is ample evidence

Or perhaps a patch to the filesystem / disk-subsystem / cluster ware. In the cdo.server group, there is currently a discussion about dbwr and lgwr that deals with 1 attached storage, 1 instance and different behavious when handling that instance from either of two versions of Solaris. Makes one wonder what your Solaris & h/w configuration happens to be.

Aside from that - I totally concur with Joel ... pick a formal analysis methodology and follow it. Especially in your organization, with the splits in responsibility, documentation is key. The Performance Tuning Guide for your version is your friend here.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Fri Apr 01 2005 - 20:15:10 CST