Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8i performance problem
Table cleanup? The symptoms you describe are that at some point during the
day every terminal freezes up. I would look to see if a log switch is
occurring at that point in time. Look at the alert.log file.
Jim
"Fax" <mollygog_at_wanadoo.fr> wrote in message news:a71rg7$m5e$1_at_wanadoo.fr...
> 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 Sun Mar 17 2002 - 10:27:04 CST