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