Isolation levels in oracle

database oracle isolation-level transaction-isolation
Touchstone picture Touchstone · Nov 30, 2012 · Viewed 22.6k times · Source

I would like to know different isolation levels with respect to commit, and would also like to know about row-level and table-level lock.

Answer

markusk picture markusk · Feb 1, 2015

ANSI/ISO SQL defines four isolation levels:

  • serializable
  • repeatable read
  • read committed
  • read uncommitted

According to Oracle's Database Development Guide, chapter 6.6.1: Transaction Interaction and Isolation Level, you can request either isolation level READ COMMITTED (the default) or SERIALIZABLE.

Please note, however, that what Oracle call SERIALIZABLE is actually snapshot isolation.

For more information about row-level and table-level locks, see Overview of the Oracle Database Locking Mechanism and Locking tables explicitly.

Related questions

What is the difference between Non-Repeatable Read and Phantom Read?

What is the difference between non-repeatable read and phantom read? I have read the Isolation (database systems) article from Wikipedia, but I have a few doubts. In the below example, what will happen: the non-repeatable read and phantom read? Transaction …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More