Rollback segment used in exclusive mode : Why ?

From: Emmanuel Guyot <Emmanuel.Guyot._at_wanadoo.fr>
Date: Sat, 19 Jun 1999 16:35:18 +0200
Message-ID: <7kg9kf$hpr$1@wanadoo.fr>

Each of my rollback segment is used in exclusive mode. I mean that only one transaction can use it. For example, if I force the use of one Rollback Segment (set transaction use rollback segment ...) I update a table and I don't quit.
If I do the same thing from another session, the second one is locked!

If I verify with Lock Manager, it confirms that the rollback segment is used in exclusive mode.

The question is Why! I've asked the Oracle support but they don't know.

I've dropped and created back the rollback segment (create rollback segment XXX tablespace YYYY) but the problem still occurs.

Please give me any hint.

N.B. : My OS is Solaris 2.5.1, with Oracle 7.3.3

E.G.

--------------------->>>> Emmanuel Guyot <<<<--------------------------

8 Rue des Montées              | Phone     : [33] (0)2 38 56 42 72
45100 Orléans                  | Email     : emmguyot_at_altavista.net
France                         | ICQ       : 6945538
-----------------------------------------------------------------------

Home Page : http://perso.wanadoo.fr/emmanuel.guyot/belote

Received on Sat Jun 19 1999 - 09:35:18 CDT