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

Home -> Community -> Usenet -> c.d.o.misc -> Re: NOLOGGING clause

Re: NOLOGGING clause

From: dean <deanbrown3d_at_yahoo.com>
Date: 9 Dec 2006 22:30:56 -0800
Message-ID: <1165732256.175559.280450@j44g2000cwa.googlegroups.com>


>
> 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. Received on Sun Dec 10 2006 - 00:30:56 CST

Original text of this message

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