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

Thread: Transaction

  1. #1
    Join Date
    Feb 2003
    Location
    Slovakia, Europe
    Posts
    72

    Transaction

    I need use different isolation level by transaction. For what kind of isolation level has oracle support ?

    1. READ_COMMITED
    2. READ_UNCOMMITED
    3. REPEATABLE_READ
    4. SERIALIZABLE

    Or how could I use all types of isolation level ?
    (I want to use it in Java and DatabaseMetaData.supportsIsolationLevel told me, that second and third level doesn't supports. It is possible to use this levels in Oracle9i database ?)

  2. #2
    Join Date
    May 2002
    Posts
    108
    Oracle Supports

    1. Read Committed
    2. Serializable

    And also READ ONLY, which is not one of those standards you have mentioned. For more details, follow the link below.

    http://download- west.oracle.com/docs/cd/B10501_01/server.920/a96524/c21cnsis.htm

    BTW why would u want to use all four Isolation levels?
    (To practice? Or in your projects??!!!)

    - Nandu
    Never give up !

    Nanda Kumar - Vellore

  3. #3
    Join Date
    Feb 2003
    Location
    Slovakia, Europe
    Posts
    72
    Thank you.

    It's just for my practice

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