Re: Oracle 8i performance probs

Fax 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!

Some guesses...

• archiver not keeping up with lgwr
• redo logs too small
• shared pool fragmentation
• poor SQL

all of which can cause "random" freezes in the environment

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."