Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8 panic! - lousy performance/high load
CPU bound can also mean he is NOT using bind or host variables. Too much
parsing. Not using bind variables is very common especially if using MS
tools on the client side.
Jim
"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message
news:3bf68a8e.429291_at_news...
> In a sudden spasm of awareness,
> koert54 doodled thusly:
>
> >not waiting for I/O) - it's bloody CPU bound ! Normally when your
runqueue
> >> 3xCPU the box becomes slow as a snail....
> >This box is getting blown to pieces....
> >
>
> And yet, if they are all running a really, really bad optimizer plan,
> that's exactly what you get: CPU bound, doing buffer cache "I/O"...
> :-)
>
> What we need to know is what is it this box is running. Too scant
> info. The init.ora is useless if we don't know what the nature of the
> app is, how many concurrent connections, is it batch or OLTP, etcetc.
>
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Sat Nov 17 2001 - 10:20:41 CST