Re: Oracle8 panic! - lousy performance/high load

From: Tom Karlsson - Remove NOSPAM <tk_at_babylon5.dkNOSPAM>
Date: Tue, 27 Nov 2001 16:33:29 +0100
Message-ID: <Pine.LNX.4.21.0111271631080.13305-100000@sith.ammulti.dk>

Thanks for all the suggestions.

I actually managed to eliminate load almost completely boosting the buffer size (which is extremely low by default) and index a couple of the largest tables (analyze indicated that full table scans was used rather than indexes).

Again, thanks :)

Friendly Regards
Tom

On Sat, 17 Nov 2001, Nuno Souto wrote:

> Jim Kennedy doodled thusly:
>
> >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.
>
> True. And given that he said at the start he had 100-plus processes
> using up CPU, could well be that and/or a combination of the prior
> ideas.
>
> Nope, we need more info. I was hoping it would be provided here, but
> apparently not...
>
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
>
Received on Tue Nov 27 2001 - 09:33:29 CST