Get Data Moving 1
Results 1 to 6 of 6

Thread: Lock in Oracle RDB

  1. #1
    subangini is offline Junior Member
    Join Date
    Aug 2007
    Posts
    4
    Rep Power
    0

    Lock in Oracle RDB

    Hi,

    If I run a select query in Oracle RDB will it lock the table or row?

    Thanks

  2. #2
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14

    RDB lock

    In short - the answer is NO.
    Under an ordinary 'snapshot transaction' a SELECT query should neither block others nor be blocked by them.
    However - RDB backend and AIS RDBSQL driver provide a variety of means that control and affect the concurrency & sharing for various purposes.
    Using them may affect lock contention as experienced by users.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    subangini is offline Junior Member
    Join Date
    Aug 2007
    Posts
    4
    Rep Power
    0

    lock in Oracle RDB

    Hi,

    I am using visual basic6 to extract data from oracle rdb to mysql. I am using select queries with joint to reterive data from oracle rdb and store in mysql database.

    Few weeks back there was an issue in my company and they said oracle rdb will lock the tables in read only mode with select query.

    So I want to know how whether it is true or not.

    thanks

  4. #4
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14
    if you would like to refer me to the issue # and we can double check what was going on.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  5. #5
    subangini is offline Junior Member
    Join Date
    Aug 2007
    Posts
    4
    Rep Power
    0

    lock in Oracle RDB

    Hi,

    Shall I send my code to find out the problem????

    Thanks

  6. #6
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14
    I think the best way to proceed is to have you contact our support representatives by supplying a sample code, logs etc.. It is more a support issue.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

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