I agree with Niall. Often high CPU usage is an indication of lack of bind
variables in an application.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3efb06a3$0$19598$ed9e5944_at_reading.news.pipex.net...
> It isn't clear to me exactly what you are saying but yes Oracle will
> certainly use all available CPUs in a machine. You probably have 4 or more
> active processes (threads) on this instance all doing CPU intensive work.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "moosandl" <ralf.moosandl_at_nkk.de> wrote in message
> news:bdetsd$s9fin$1_at_ID-73934.news.dfncis.de...
> > hi group,
> >
> > I am collecting facts about the topic above
> > regarding oracle 8.1.7 ( .3 SE) and w2k-server and one SID
> > with heavy workload.
> > and I am very interested in your experiences and comments,
> > as I do not understand why one (of 10 different machines)
> > shows a maximum CPU-load of about 100% at a 4-CPU-machine.
> > All the other machines show me 25% as a CPU-load-maximum
> > - by the way, this is what I expect.
> >
> > In my opinion one oracle.exe consumes 100% of only one CPU
> > as a maximum and
> > this CPU-load is shared via the OS with all other CPUs.
> >
> > thank you,
> > ralf moosandl
> >
> >
>
>
Received on Thu Jun 26 2003 - 10:00:06 CDT
