As I am concerned, the only redo information it generates is related
to the system tablespace, the one refering to the manage of the extents.
Ramon Estevez
*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 Gaja Krishna
Vaidyanatha
Enviado el: Monday, 25 June, 2001 9:10 PM
Para: Multiple recipients of list ORACLE-L
Asunto: 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.
>
>
>
> Ramsn Estivez
>
>
>
> *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/
--
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).
Received on Tue Jun 26 2001 - 08:23:09 CDT
