How to dedicate a rollback segment to a session or a user ?

Problem:
I would like to use a small RollBack Segment for svrmgrl and keep the big Rollback Segment to the other Session. That would allow me to monitor the v$session
without using the production rollback segment.

Unacceptable Solution:
I Cannot use for all the session a ALTER TRANSACTION SET ROLLBACK SEGMENT because my software is written with ODBC an contain Thousand's of
Query's which are automatically committed.

Acceptable Solution:
A way to a rollback to a dedicate a session (from login to logout) or
A way to dedicate a rollback to a user
or
A way to forbid other transaction to use my rollback segment.

I tried:
I create an Private RollBack Segment witch doesn't appear in the init.ora (RollBack_Segment).
To use it I Have to bring it online.
I can use an ALTER TRANSACTION.
But unfortunately Others transactions start to use it

Any suggestions posted to this group will be appreciated. Received on Fri Sep 12 1997 - 00:00:00 CDT