Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How much time can save using _disable_logging on 10g

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

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Mon, 10 Oct 2005 09:22:42 -0400
Message-ID: <cd4305c10510100622r79864141g7b2f29d0c77969f0@mail.gmail.com>


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-l
> >
>
>
>
>
>
> ______________________________________________________
> Yahoo! for Good
> Donate to the Hurricane Katrina relief effort.
> http://store.yahoo.com/redcross-donate3/
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 10 2005 - 08:25:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US