Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: No logging question
That's also my understanding of it.
Not a good way to run a database you care about.
Jared
On Monday 06 January 2003 13:03, Burke, William F (Bill) wrote:
> 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: Jared Still INET: jkstill_at_cybcon.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 - 22:03:44 CST
![]() |
![]() |