True,
but somebody on the list talked about "delete <tabnam> nologgin". I did not find immense benifit in this option. Any views on this?
-----Original Message-----
From: Gaja Krishna Vaidyanatha [mailto:oraperfman_at_yahoo.com]
Sent: Tuesday, June 26, 2001 6:10 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: NOLOGGING
Ramon,
That is not true. Setting NOLOGGING at the object
level only reduces the amount of redo generated for
bulk INSERT operations with the /*+ APPEND */ hint,
certain partition administration operations and of
course during the creation of the object itself. It
does not eliminate generation of redo during a delete
operation.
Attached is a sample output from a couple of delete
commands, one with LOGGING and the other with
NOLOGGING:
Cheers,
Gaja
- Ramon Estevez <com.banilejas_at_codetel.net.do>
wrote:
> Hi Greg,
>
> Yes, you should get a improve performance due to the
> nologging option in the
> delete wont write redo log information.
>
>
>
> Ramón Estévez
>
>
>
> *809-565-3121 x 225
>
>
>
> * com.banilejas_at_codetel.net.do
>
>
>
>
>
> -----Mensaje original-----
> De: root_at_fatcity.com [mailto:root_at_fatcity.com]En
> nombre de Greg Solomon
> Enviado el: Monday, 25 June, 2001 9:23 AM
> Para: Multiple recipients of list ORACLE-L
> Asunto: NOLOGGING
>
>
> Hi All
>
> If I have a delete which I know I never want to roll
> back, can I get a
> performance gain by using the nologging option ?
>
> Delete nologging is not, to the best of my
> knowledge, documented on 8.1.6
> ... but the query executes OK.
>
> However, when I used autotrace, the delete with
> nologging seemed to give the
> same or worse results than a normal delete.
>
> Greg
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Greg Solomon
> INET: greg.solomon_at_betfair.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Ramon Estevez
> INET: com.banilejas_at_codetel.net.do
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Gaja Krishna Vaidyanatha
Director, Storage Management Products,
Quest Software, Inc.
Co-author - Oracle Performance Tuning 101
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
Received on Tue Jun 26 2001 - 00:16:23 CDT
