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: Fax <mollygog_at_wanadoo.fr>
Date: Sun, 17 Mar 2002 18:06:05 +0100
Message-ID: <a72ifg$hue$1@wanadoo.fr>


Well, thanks for your reply :D

Yes, random freeze seems to occur quite often... Pardon my ignorance, but what is a log switch ?

and where do I find this alert.log ? the main oracle directory ?

Thanks again :D

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:st3l8.58707$ZR2.29731_at_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 - 11:06:05 CST

Original text of this message

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