Default Transaction Isolation Level

• wayfinder

  Grasshopper

  Points: 15

  More actions

  March 24, 2005 at 11:12 pm

  #185567

  Is there a way to change the default transaction isolation level, so that all connections to the database use this level?  If not globally, is there a way to set a default for a specific user?

  Thanks.

• Kishore-132325

  Hall of Fame

  Points: 3784

  More actions

  March 29, 2005 at 5:23 am

  #549301

  There are 4 types of transaction isolation levels. Here is the syntax :

  SET TRANSACTION ISOLATION LEVEL

      { READ COMMITTED

          | READ UNCOMMITTED

          | REPEATABLE READ

          | SERIALIZABLE

      }

  Once you set the Isolation level, it will work for that particular connection.

  --Kishore