SET TRANSACTION

Modify properties for the current transaction.

Syntax:

   SET TRANSACTION READ ONLY
   SET TRANSACTION READ WRITE
   SET TRANSACTION ISOLATION LEVEL {SERIALIZABLE | READ COMMITTED}
   SET TRANSACTION USE ROLLBACK SEGMENT rb_segment

Related Commands:

ALTER SYSTEM ENABLE RESTRICTED SESSION
ALTER SESSION
COMMIT
ROLLBACK


Related Views:

 DBA_PENDING_TRANSACTIONS
                                           USER_RESOURCE_LIMITS
 DBA_ROLLBACK_SEGS
 V$SESSION
 V$TRANSACTION
 V$TRANSACTION_ENQUEUE 



Back to the Top

Simon Sheppard
SS64.com