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:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
