Re: set transaction use rollback seg

Frank Graziano Jr. (frank.graziano_at_teldta.com) wrote:
: Has anyone ever had problems when using
: SET TRANSACTION USE ROLLBACK SEGMENT command.
 

: It seems that when we run COBOL programs with embedded sql and use this
: command after every commit the job/transaction does not use the rollback
: segment it is assigned.

This is exactly correct. Once you do a commit, the rollback segment lock is then released, thereby nulling any guarantee that you will continue to use that rollback segment again.

I know within PL/SQL, you can use the DBMS_TRANSACTION built-in package to grab a rollback segment. Just do the following:

        dbms_transaction.use_rollback_segment(rb_name VARCHAR2)

This is the same as SET TRANSACTION USE ROLLBACK SEGMENT.

Basically, after each commit, you have to reissue the SET TRANSACTION to get a lock on the segment.

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Ivan Samuelson, Consultant   *   GO HORSE!
Profound Consulting          *   bolski_at_indy.net
http://indy.net/~profound    *   http://chaos.taylored.com/home/bolski/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-