| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
> 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_at_yahoo.com> wrote:
> > 42 %
> >
> > ;)
> >
> >
> > --- Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> 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.
> > > --
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 10 2005 - 09:07:59 CDT
 |
 |