Re: How much time can save using _disable_logging on 10g
- From: Kirtikumar Deshpande <kedeshpande@xxxxxxxxx>
- To: juancarlosreyesp@xxxxxxxxx
- Date: Mon, 10 Oct 2005 07:05:59 -0700 (PDT)
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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
