Oracle-L: RE: cpu on AIX

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 09 Oct 2002 09:54:06 -0800
Message-ID: <F001.004E49D1.20021009095406@fatcity.com>

Henry - The issue isn't whether all the CPU is being used, but whether it is being used well. If the O.S. is handling priorities well, servicing your online users crisply, and just giving the excess CPU to a batch-type program, then that is okay. Do you think the O.S. should throw away 10% of the CPU for the heck of it? If users are experiencing sluggish response, then you have a tuning problem to diagnose.

If you use STATSPACK, take a couple of snapshots and see what the waits are. If not, look at V$SESSION_EVENT.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, October 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L

I'm working on an AIX (4.3) box which seems to be CPU bound. vmstat and iostat -t both show idle cpu and iowait at 0%. User and system cpu are about 40/60. While trying to track down the source of this load, I looked at the %cpu (-o pcpu) of the processes. One process, spawned from an import, was using about 30% of the cpu. The sum of all pcpu obtained from ps doesn't break 35-40%. I am assuming that this is user cpu, and that the import process is using 3/4 of the user cpu. Since the import is io intensive, I am guessing it is also using a healthy chunk of the system cpu. Is there any way to track this down? Multiple applications (manned by different teams) run on the same server, and so the more I can irrefutably nail down, the better.

Thanks for the help.

Henry

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Henry Poras
INET: hporas_at_etal.uri.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------