Rollback segments take on/offline randomly

From: Vincent GRENET <vincent.grenet_at_free.fr>
Date: Tue, 21 Sep 1999 18:14:47 GMT
Message-ID: <rWPF3.840$jg4.2619488@nnrp3.proxad.net>

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 - 13:14:47 CDT