Re: Archive Log

No, it would create 16 1 M files or a total storage space of 16 M. So the same disk space would be taken up. Actually, there is probably some header information so smaller files might take up more total space, but probably not a lot more, but not less.
Jim
"kumu" <forlist2001_at_yahoo.com> wrote in message news:a44abd39.0204220751.69f9475b_at_posting.google.com...
> The reason for creating smaller log is one of in one of my friends
> office the system is creating way too many logs and maybe decreasing
> size will help us. As you say it does not really matter what size isnt
> it? It will create the file no matter what with the information filled
> in. Correct me if I am wrong it will create lets say 2 8MB files where
> as if deceased in file size to 1M it will create 8 files anyways isnt
> it? :)
>
>
> "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
 news:<l6rt8.209908$Yv2.67115_at_rwcrnsc54>...
> > 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 Tue Apr 23 2002 - 04:51:24 CEST