Locking issue in linked server

  • qaz123 90964

    SSC Enthusiast

    Points: 107

    hi

    Recently we faced a issue of locking happening to a linked oracle server table, when a sleect operation is done in SQL 2000.

    for example select * from linkserver..dbname.my_table in SQL 2000 reportedly caused locking issues in oracle server where the actual table is located. I guess this is probably imposed by the linkedserver driver used.

    Thought this can be solved by having a view in oracle for the select and calling the view in SQL. While that works, I need to verify if calling the view has indeed prevented the lock from being imposed on the table. I mean, like knowing if lock has been acquired on a table? Any solution ?

    Also, how can i verify that the initial lock on a select on oracle table was imposed by the driver?

  • qaz123 90964

    SSC Enthusiast

    Points: 107

    hi

    does some one know?

    thanks

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply