Re: Archive Log

You can make the log smaller (by making the redo logs smaller), but you will just have more of them. The total amount of disk space used will be about the same. If you make them smaller then you will have them created faster, and take a performance hit. Why?
Jim

"kumu" <forlist2001_at_yahoo.com> wrote in message news:a44abd39.0204111201.6b3350cb_at_posting.google.com...
> Thanks Jim, One more Question is there a way to change the size of the
> archive log file like lets say squeeze it from 4028k to 1024k...
>
> "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
 news:<skkr8.177007$af7.87469_at_rwcrnsc53>...
> > If the server is in archive log mode it will generate archive logs.
 These
> > are based upon how much work the database is doing in terms of insert,
> > update, delete. No, the application cannot tell the database not to
> > archive. You want archiving on, this is a god thing.
> > Jim
> > "kumu" <forlist2001_at_yahoo.com> wrote in message
> > news:a44abd39.0204050814.64dcc6a3_at_posting.google.com...
> > > Hello,
> > >
> > > Is there any way for an application to generate Archive Log Files on
> > > the server. I have Oracle 8.0.6 server running on the Sun OS and I am
> > > getting a lots of Archive log files... its like one every 4-5 Minutes.
> > > Is there something wrong in what I am doing? I am totally confused
> > > because I always thought an application could not instruct server
> > > explicitly to generate archive log.
> > > Please let me know...
> > >
> > > Thank you
> > > Kumu
Received on Fri Apr 12 2002 - 03:53:21 CEST