What Are Transaction Isolation Levels Supported by Oracle?
Page 1 of 1
What Are Transaction Isolation Levels Supported by Oracle?
by Micheal Sun Jan 17, 2010 3:38 am
Oracle supports two transaction isolation levels:
READ COMMITTED (the default option). If the transaction contains DML that requires row locks
held by another transaction, then the DML statement waits until the row locks are released.
SERIALIZABLE. If a serializable transaction contains data manipulation language (DML) that
attempts to update any resource that may have been updated in a transaction uncommitted at the
start of the serializable transaction, then the DML statement fails.
READ COMMITTED (the default option). If the transaction contains DML that requires row locks
held by another transaction, then the DML statement waits until the row locks are released.
SERIALIZABLE. If a serializable transaction contains data manipulation language (DML) that
attempts to update any resource that may have been updated in a transaction uncommitted at the
start of the serializable transaction, then the DML statement fails.
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» Explain different isolation levels
» How To Manage Transaction Isolation Level?
» What Is a Transaction?
» How To Set a Transaction To Be READ ONLY?
» How To Start a New Transaction?
» How To Manage Transaction Isolation Level?
» What Is a Transaction?
» How To Set a Transaction To Be READ ONLY?
» How To Start a New Transaction?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL