Re: Rollback segs fall offline, why??

gcherer_at_millenium.texas.net (GT Cherer) wrote:

> i've an application that requires a mondo rollback seg.
 

> if there is nobody else on the system, other than oracle coming up or
> going down, what the heck is altering the seg offline unrequested by my
> appl?? no messages, no tracks, no nothing i (not a dba) can see.
 

> is there some automatic condition that would cause this - filling up a
> buffer or something??

Assuming your database is being shutdown and restarted overnight...

If it is a public rollback seg. you need to list it in the ROLLBACK_SEGMENTS section of the init.ora file. Otherwise it will not be put online when starting the database.

--
Peter Moore.
DBA, IS Ops,
Sequent Computer Systems Ltd, Weybridge, UK.