SET TRANSACTION

Modify properties for the current transaction.

Syntax:

   SET TRANSACTION READ ONLY [NAME 'text']
   SET TRANSACTION READ WRITE [NAME 'text']
   SET TRANSACTION ISOLATION LEVEL {SERIALIZABLE | READ COMMITTED} [NAME 'text']
   SET TRANSACTION USE ROLLBACK SEGMENT rb_segment [NAME 'text']

If used, this should be the first statement in the transaction, the transaction ends with either a COMMIT or ROLLBACK statement. Data definition language (DDL) statements within a transaction will cause an implicit commit of the transaction.

READ ONLY= transaction-level read consistency, all subsequent queries will only see changes committed before the transaction began.

READ WRITE = statement-level read consistency

READ COMMITTED = Oracle waits for Locks to be released

SERIALIZABLE = Oracle does not wait for Locks to be released (statement fails)

Related Oracle Commands:

ALTER SYSTEM ENABLE RESTRICTED SESSION
ALTER SYSTEM SET ISOLATION_LEVEL = {SERIALIZABLE | READ COMMITTED}
ALTER SESSION
COMMIT
ROLLBACK

Related Views:

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

 
Copyright © 1999-2024 SS64.com
Some rights reserved