Re: Oracle 8i performance probs

You dont mention what type of system you are running but try the following:

Rn TOP to determine where oracle is waiting (do you have enough RAM or is it swapping). Is it waiting on io? If you have enough RAM have you configured oracle to use this memory.

Check how much memory is allocated to the sort table. This can effect searches.

Check the size of your redo logs. Check if you need to use the redo logs for all your tables.

On Sun, 17 Mar 2002 11:36:52 +0100, "Fax" <mollygog_at_wanadoo.fr> wrote:

>Hi guys, I would be grateful if I could get some help about this problem :
>
>
>Our main Oracle server seems to be more and more laggy, every terminal using
>apps tend to freeze for no apparent reason at some point everyday.
>
>We've ben told the tables would need a cleanup.
>
>Would that solve our problem ?
>
>If yes, what command should be used to initiate a
>cleanup ? (alter, etc..?)
>
>
>Thanks in advance!
>
>
>
>
>
>
Received on Thu Mar 21 2002 - 08:23:42 CET