Warning: USE THIS AT YOUR OWN RISK. There is a parameter called _disable_logging and if you set this to TRUE this will not generate any redo for your application. But the danger in this is if the instance crashes during the process the database will be in unusable state.
So the best bet is Have a backup, Set this _disable_logging=TRUE and Swich the logs twice and run the update. Then you switch the logs again And set this to false . (You can use this at session level also). ***** This is not SUPPORTED BY ORACLE ******* and ***** The database will not be usable if it crashes during that period**** Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -----Original Message----- Sent: Saturday, November 03, 2001 9:55 AM To: Multiple recipients of list ORACLE-L Hi List, By any chance is it possible to use "nologging" with UPDATE ??, the reason is, there is an update statement within a procedure to update 13 mil rows, after about 20K rows the procedures freezes or just crawls, asked my DBA about sufficient Roll backs and he would not speak to me, so can anyof you help ?? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreeni INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
