View Single Post

   
  #3 (permalink)  
Old 04-08-2008, 11:56 AM
dean
 
Posts: n/a
Default Re: NOLOGGING clause

>
> NOLOGGING is only applicable to certain operations like INSERTS in
> APPEND mode and direct path loads using SQL*Loader.
> Ordinary INSERTS and UPDATES will be logged.
> On a properly tuned system the belief INSERTS and UPDATES are faster
> without logging should be qualified as an unproven superstition.
> Oracle added the FORCE LOGGING clause for standby situations, to
> override any NOLOGGING operations. Any idea why? Do you *really* think
> NOLOGGING is recommended? Or do you like quick job changes?
>
> --
> Sybrand Bakker
> Senior Oracle DBA


Ok thanks a lot Sybrand. Evidently I misunderstood the use.

Reply With Quote