I guess you guys need some dba at the site . Post an ad . Good Luck !
"Fax" <mollygog_at_wanadoo.fr> wrote in message news:a72ifg$hue$1_at_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:42:30 CST
