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...
> 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.
>
Received on Fri Aug 31 2001 - 15:58:57 CDT
