an
idea...
Scott Shafer
San Antonio, TX
210.581.6217
> -Original Message-
> From: Henry Poras [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, October 09, 2002 6:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: cpu on AIX
>
> Dennis,
> Users
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 Wi
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 wa
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:
1) Are interactive users complain
Dennis,
Thanks for the response, and I agree that CPU is there to be used. If you
have got it, you might as well use it (0% idle isn't necessarily a bad
thing). However, 0% idle could also mean you need more than you've got, and
the bottleneck is CPU. (IBM's doc says "typically, the CPU is pacing
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
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