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: Nolog writes log ?

Re: Nolog writes log ?

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Tue, 21 Aug 2001 11:53:34 -0700
Message-ID: <F001.00372D7A.20010821104601@fatcity.com>

SQL Statements That Can Use No-Logging Mode       The following operations can make use of no-logging mode:         direct load
(SQL*Loader)         direct-load INSERT
        CREATE TABLE ... AS SELECT
        CREATE INDEX
        ALTER TABLE ... MOVE PARTITION
        ALTER TABLE ... SPLIT PARTITION
        ALTER INDEX ... SPLIT PARTITION
        ALTER INDEX ... REBUILD
        ALTER INDEX ... REBUILD PARTITION
        INSERT, UPDATE, and DELETE on

LOBs in NOCACHE NOLOGGING mode stored out of line hth, joe
>>> RROGERS_at_galottery.org 08/21/01 01:47PM >>>Joe,I do not have the ability to test it at my sight. Would you test this and respond. Thanks,Oracle Performance Tuning Tips & Techniques Page 538. Subject NOLOGGING: "It specifies whether subsequent direct loader (SQL*LOADER) and direct-load INSERT operations against the table, partition, or LOB storage are logged".Sounds like only under "special" conditions the logging is not performed.Thanks,ROR mª¿ªm>>> JTESTA_at_longaberger.com 08/21/01 12:42PM >>>yes.i've tested it and you should
too.joe>>> ipal_at_hotmail.com 08/21/01 11:21AM >>>Hi,I have Emp table NOLOGGING.Does it write to log files the insert,update,delete activity on that table

?TiaAldi_________________________________________________________________Get 
your FREE download of MSN Explorer at <A href="http://explorer.msn.com/intl.asp">http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com">http://www.orafaq.com -- Author: Aldi Barco  INET: ipal_at_hotmail.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing
Lists--------------------------------------------------------------------To 
REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com--Author: Ron Rogers  INET: RROGERS_at_galottery.orgFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing
Lists--------------------------------------------------------------------To 
REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing). Received on Tue Aug 21 2001 - 13:53:34 CDT

Original text of this message

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