Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8i performance problem

Re: Oracle 8i performance problem

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sun, 17 Mar 2002 16:27:04 GMT
Message-ID: <st3l8.58707$ZR2.29731@rwcrnsc52.ops.asp.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US