What Are Transaction Isolation Levels Supported by Oracle
Q
What Are Transaction Isolation Levels Supported by Oracle? - Oracle DBA FAQ - Understanding SQL Transaction Management
✍: FYIcenter.com
A
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.
2007-04-17, 5299👍, 0💬