Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback segments take on/offline randomly

Re: Rollback segments take on/offline randomly

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Tue, 21 Sep 1999 15:11:51 -0400
Message-ID: <37E7D877.1E87B293@Unforgettable.com>


Is it possible that some of the rollback segments are PUBLIC rollback segments?

Vincent GRENET wrote:
>
> Hi all.
>
> The rollback segments in the database are taken online or offline randomly
> by the server without any manual action. Why is that ?
>
> I created the database with the installer which creates four rollback
> segments, I added 5 other rollback segments. I switched offline the segments
> created by the installer (I could have dropped them but I didn't.) and
> switched online mine. After a running the applications for a while, I check
> the segments in dba_rollback_segs, and 3 of my segments (allways the same)
> are taken offline, and the 4 segments created by the installer are brought
> back online.
>
> Any help welcome.
>
> Vincent
Received on Tue Sep 21 1999 - 14:11:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US