Re: How much time can save using _disable_logging on 10g

Juan Carlos, 

 I am sorry, but I have not played with this parameter. 

 So, I can't say what you are trying to do is possible or not. 
 
 - Kirti 

 

--- Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx> wrote:

> Hi Kirtikumar,
> I had been stressing the use of this parameter on 10g release 2.
> I enabled, did an insert drop the table, deleted, commit
> disable, drop the table, did the insert, deleted and then commit, etc.
> 
> The last step was to disable, this is enabling logging, run a delete,
> did a rollback and in that moment did a shutdown immediate.
> There "should be" not pr oblem because the logging was enabled
> 
> Trying to restart the redologs was corrupt, so bye bye test database.
> 
> The question is:
> Is the trick to do a log switch and a shutdown normal , or situation
> unpredictable like this are typical, I mean the redologs can appear
> corrupt.
> My theory is that a normal shutdown should be enough.
> Is there some trick,or this is only a coincidence, and I shouldn't get
> this corruption in logs.
> 
> Thanks in Advance
> 
> On 10/7/05, Kirtikumar Deshpande <kedeshpande@xxxxxxxxx> wrote:
> > 42 %
> >
> >  ;)
> >
> >
> > --- Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx> wrote:
> >
> > > Hi,
> > > To speed process on my personal computer, ONLY FOR MY TESTING
> > > DATABASE, I want to use _disable_logging parameter.
> > > How much can I expect to save in time using it.
> > >
> > > Thank you in advance.
> > > --



                
__________________________________ 
Yahoo! Music Unlimited 
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
--
http://www.freelists.org/webpage/oracle-l

Other related posts: