--
"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
news:WTDKa.25341$e26.17141_at_rwcrnsc52.ops.asp.att.net...
> I agree with Niall. Often high CPU usage is an indication of lack of bind
> variables in an application.
Really? There are soooo many other things I'd consider before looking at
"lack of bind variables" .
A quick/brief list that come to mind, at this time:
- Not tuned Sql
- Not tuned Sql
- Not tuned Sql
- etc. etc. etc.
:)
> 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 Fri Jun 27 2003 - 02:59:24 CDT
