DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: set transaction

  1. #1
    Join Date
    Jan 2002
    Posts
    111

    Lightbulb

    Hi,
    Can anyone let me know what is set transaction isolation level serializable and set transaction isolation level read committed.

    Thanks
    Murali

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I would point you to Concept Guide, it´s explained very clearly there.

    http://otn.oracle.com/docs/products/...cnsis.htm#2641

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    set transaction isolation level serializable is the highest form of locking. It requires reads of data to be repeatable. Any data that is being updated will not be included in your queury. set transaction isolation level read committed is one level below the above. It allows queries to use data as long as it has been commited. This would include data in the redo log.

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Highest form of locking? The command has to do nothing with locking. It only sets multiple selects from a table to bring up the same information before the transaction is commited. "Set transaction isolation level serializable" influences only the next transaction. After you commit the transaction, the isolation level reverts to the default "read committed".


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width