Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: cpu on AIX
Henry - One idea for you to try is to "nice" the import job when you start
it. Check your O.S. documentation for available values. This has helped me
on some jobs that have tended to overwhelm the online users. Just a thought.
Good luck, sounds as if you may have other system problems.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, October 09, 2002 6:35 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Users are complaining, and at least this time the guilty process seems to be
an import from a database out of my control. What I am trying to do is
control how often this happens. It seems a bit strange that one moderate,
single threaded import should drain both CPUs on the server, so I was trying
to see how much could be pinned on those processes (imp and associated
oracle shadow process)and how much was due to other use and poor
configuration.
As I mentioned, both %wio (wa on vmstat AIX) and %idle were ~0. Everything was split (kind of evenly 50-50 to 40-60) between %usr and %sys. Using ps -o pcpu I could pin about 30% of %CPU on the import. I am not sure if this includes the associated system calls (io) from this process. I don't think so. (I wasn't seeing my %CPU adding up to 100% earlier because I was leaving out the kernal processes. I needed a ps -k flag).
Now I am seeing some other funky stuff (maybe related, maybe not. I haven't looked carefully for this before so I don't know) on the same machine. The import ended and the %usr %sys breakdown was still 40-60. There are two kproc processes (async IO???) each using 44.4%CPU. That's been unchanged for hours and the machine is not being heavily used. Also, some other processes are using 10-20%CPU which puts me up over 100% (I guess it really can give 120%).
I'll let you know what I find.
Henry
-----Original Message-----
WILLIAMS
Sent: Wednesday, October 09, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L
Henry - Here are my reactions, and hopefully someone that knows how to track system CPU usage back to an application will reply. One thought I have is to run each application on a test server and observe the system I/O there. I haven't tried this. Other thoughts:
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
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: 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).
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). Received on Thu Oct 10 2002 - 09:33:41 CDT