Re: Nologging rbs tablespace?

From: John Darrah <john.darrah_at_spambadusa.net>
Date: 31 Aug 2001 20:43:34 GMT
Message-ID: <999290351.750948@proxy.storm.co.za>

In practice, its not going to make any difference one way or the other because oracle will log changes to rollback segments regardless. If in theory, you were able to turn off logging of rollback segments, your database would most likely be completely unusuable in the event of an instance crash. Direct path table loads, index creates, and CTAS (create table as select) are the only operations where nologging ever comes into play.

Terry Dykstra wrote:

> A tablespace that contains only rollback segments, would it be good or bad
> to set it to NOLOGGING mode?

> --
> Terry Dykstra
> Canadian Forest Oil Ltd.

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Fri Aug 31 2001 - 15:43:34 CDT