Re: Rollback segs fall offline, why??

In article <4skrp0$d4p_at_scel.sequent.com>, ptmoore_at_sequent.com (Peter Moore) writes:
|> 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.
|>
Actually, at least on NT with versions 7.1, 7.2, 7.3 if it is public rollback segment, it goes online during startup. No matter what init.ora says. Sensitive for ROLLBACK_SEGMENTS are private (created by: CREATE ROLLBACK SEG... command rather then CREATE PUBLIC ROLLBACK SEG... ).

Pawel Kucharczyk
kuchar_at_mimuw.edu.pl Received on Mon Jul 22 1996 - 00:00:00 CEST