Re: Oracle 8i performance probs

Based on your posting ... my suspicion is that you have multiple problems and that addressing just one of them will only expose the next.

Hire an expert DBA to spend one week looking at your system to give you a complete evaluation of everything from the operating system parameters to init.ora parameters, to tablespace usage, etc. Then fix them all.

Daniel Morgan

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!
Received on Mon Mar 18 2002 - 17:03:40 CET