"Satish Pennem" <fpennem_at_comcast.net> wrote in message news:<9A4l8.19083$r8.2302730_at_bin4.nnrp.aus1.giganews.com>...
> 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!
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
There could be a lot of variables here.What major things are done on
your system at that time.It could be a lot of different things
CPU,Memory,Lots of sql ,slow network,better tuning of the database
etc.
Did you finally get to your alert log?
If you have more information feel free to update this thread
God bless
Michael Tubuo Ngong(Sr DBA)
Received on Tue Mar 19 2002 - 10:51:49 CST
