Re: Archive Log
Date: 22 Apr 2002 08:51:53 -0700
Message-ID: <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? :)
> 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 Mon Apr 22 2002 - 17:51:53 CEST