Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8i performance problem
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