Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Nologging rbs tablespace?
Let's make this 100% clear. A rollback segment tablespace MUST be logged.
Remember the only place we guarantee to write changes is to the redo logs.
Datafiles, including ones for a rollback tablespace, are written to
asynchronously for performance reasons. If we didn't log rollback segment
changes, then we couldn't perform instance recovery reliably for those times
when rollback changes have not made their way to the datafiles yet..
-- HTH. Additions and corrections welcome. Pete Author of "Oracle8i: Architecture and Administration Exam Cram" Now got a life back again that the book is released! "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA "Reid Lai" <reidlai_at_netvigator.com> wrote in message news:3B8FC443.59FA6896_at_netvigator.com...Received on Fri Aug 31 2001 - 15:58:57 CDT
> Of course NOT.
>
> 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.
>