Re: No logging question

As I've said before. I love that parameter just because it's so dangerous - and personally I've lost two or three databases while having it set.

Rock'n'roll.

Yep, it helps. But what you really want is not possible - I think. I think you want to be able to specify "alter table x disable logging", etc. and thereby avoid redo stuff pertaining (spelling?) to that table. That's what I hoped for when I first saw the syntax for 8: Alter Index/Alter Table/Alter Tablespace/Alter Partition... disable logging;". Unfortunately it only meant that it would do less redo stuff when direct IO stuff was done to the objects.

Mogens

mantfield wrote:

>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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

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