RE: No logging question

From: Burke, William F (Bill) <wbburke_at_avaya.com>
Date: Mon, 06 Jan 2003 13:03:52 -0800
Message-ID: <F001.00527EF2.20030106130352@fatcity.com>

It is an all or nothing shutdown of logging however and cannot be applied to a limited set of DML, correct?

Regards,

Bill Burke
"The Kinder and Gentler DBA"
www.OracleGuru.com
www.KBMotorsports.biz

-----Original Message-----

Sent: Monday, January 06, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L

Welcome to the dark side, heh heh heh !

There is a hidden parameter that will achieve this . it is _disable_logging. Be warned though, if you set it to true, you have lost your ability to recover, and the only way you will recover is with full cold backup and would lose all subsequent work (not generally popular with the users), so the whole point of running in ARCHIVELOG mode becomes moot.

I have used this while still at Siebel, when doing very large installs or upgrades of large databases in a tight time-window, and the customers refused to move the redo logs over to solid state storage, I got about a 40% - 100% performance improvment, especially if the clients were conned into placing the redo logs onto RAID-5 storage (bad for serial write-intensive operations).

Nevertheless, if you have a specific need to disable all redo generation for a specific time, this is the way to do it. BTW, it does not work on Orale for Windows.

You have been warned, don't go trying this in production first thing, it could cost you your job or more.

Regards :

Ferenc Mantfeld

-----Original Message-----

From:	GL2Z/ INF  DBA BENLATRECHE [SMTP:kbenlatreche_at_avl.sonatrach.dz]
Sent:	Monday, January 06, 2003 8:34 PM
To:	Multiple recipients of list ORACLE-L
Subject:	No logging question

Hi All,

      I want to avoid generation of archivelogs against all the DML applied to some tables.

Thank you
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: GL2Z/ INF DBA BENLATRECHE
  INET: kbenlatreche_at_avl.sonatrach.dz

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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.net
--

Author: mantfield
  INET: mantfield_at_connexus.net.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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.net
--

Author: Burke, William F (Bill)
  INET: wbburke_at_avaya.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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 Mon Jan 06 2003 - 15:03:52 CST