From JTESTA@longaberger.com Tue, 21 Aug 2001 11:53:34 -0700 From: "JOE TESTA" Date: Tue, 21 Aug 2001 11:53:34 -0700 Subject: Re: Nolog writes log ? Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@longaberger.com 08/21/01 12:42PM >>>yes.i've tested it and you should too.joe>>> ipal@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 http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco  INET: ipal@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@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: http://www.orafaq.com--Author: Ron Rogers  INET: RROGERS@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@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).