There is a hidden init.ora parameter (all hiddedn ones start with an
underscore) which disables the whole rollback subsystem.

The parameter is called
_discrete_transactions_enabled (default true) - dangerous to use but can be
useful!

There is also another one that will disable logging on all DML.
_disable_logging (default false).

These work in 8i - not sure whether 9i will although I suspect Oracle will
have carried them forward for their own internal use.

Regards
Phil



-----Original Message-----
From: Ryan, Dan [mailto:[Email Address Removed] Saturday, 29 June 2002 4:01
To: LazyDBA.com Discussion
Subject: Not using Rollback segments in SQL


Guru's,

Is there a command line parameter in SQL to turn off the use of rollback
segments for a large, one time, update and set command?




--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


----------------------
CONFIDENTIALITY NOTICE
----------------------
This email is intended only to be read or used by the addressee.
The information contained in this e-mail message may be confidential
information. If you are not the intended recipient, any use, interference
with, distribution, disclosure or copying of this material is unauthorised
and prohibited. Confidentiality attached to this communication is not waived
or lost by reason of the mistaken delivery to you.

If you have received this message in error, please delete it and notify us
by return e-mail or telephone Aristocrat Technologies Australia Pty Limited
on +61 2 9413 6300.
Oracle LazyDBA home page