Re: Disable rollbacks

Robert A Peters <peters_at_io.cpg.cdc.com> wrote:
>Barry Roomberg (barry.roomberg_at_compudata.com) wrote:
>: Somebody claimed a while ago to have a method of disabling
>: rollbacks during inserts (and I don't mean using discrete transactions).
>:
>: During an imp, I'd like to do this. I accept the fact that a failure
>: will totally trash the database causing the need for re-initialization.
>
>If you put a _disable_logging = true in the init.ora file, logging will
>be turned off. This may also kill the writing to rollbacks.

Under a 6.0.34 database I swear I was able to disable rollback usage via _corrupted_rollback_segments_=(xyz). I cant replicate this under 7.1.3 however. I'm not sure if I was dreaming or this had just been fixed.

I ran a quick test using _disable_logging and was able to cut a 15 minute test case back to 10 minutes. I'm not sure if we can xlate this to saves 33% but a larger test case may be worthwhile. Anybody done one?

Also depending on what kind of system your using. You may wanting to consider creating you rollbacks on a memory based fs.

-- 
Regards, 

Lee E. Parsons                  		
Systems Oracle DBA	 			lparsons_at_world.std.com