Re: Oracle 8i performance problem

Do you have a DBA?

The immediate answers to your questions are

1. when oracle switches from using one redo log file (group) to another.
2. in the directory specified by the parameter 'background_dump_dest' for your instance. you can find this by issuing the command show parameter dest; in sqlplus. It contains all oracle server critical messages and should therefore be checked regularly (at least daily).

However the reason for asking abut the DBA or not is that your question suggest that you are somewhat in the dark as to how Oracle functions. This is quite a good way to get oracle to perform shall we say sub-optimally. If you don't have a DBA or people with oracle experience on site you could do a lot worse than to get a reputable consultant in to look at your setup, troubleshoot the particular problem that you have and to recommend various changes. Then you can hire a DBA. If no-one is checking the alert log then I'd suggest it is almost a racing certainty that you'll have trouble with your backup and recovery plans as well.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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!

> > >

> > >

> > >

> > >

> >

> >

>

>