If this is a one time DML activity, one may get creative with TTS and this hidden parameter :)
- Kirti -----Original Message----- Sent: Tuesday, January 07, 2003 4:39 AM To: Multiple recipients of list ORACLE-L In that case, you are pretty much SOL, sorry. nologging option of tables only applies to direct path operations: create as select direct path Sql*Loader insert /*+ APPEND */ Other than that, all other DML will get logged in the redo log, and as several have pointed out, using the _disable_logging parameter is highly risky, and it is a catch-all situation. HTH. Regards: Ferenc Mantfeld -----Original Message----- From: GL2Z/ INF DBA BENLATRECHE [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 7:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: No logging question As I understand, this hidden parameter is for the whole database. In my case It's just for a few tables (I don't care about recovery of these tables). Thank you ! Best Regards Kamel Benlatreche -----Message d'origine----- De : mantfield [mailto:[EMAIL PROTECTED]] Envoye : lundi 6 janvier 2003 19:19 A : Multiple recipients of list ORACLE-L Objet : RE: No logging question 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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).
