qaz123 90964 (10/9/2010)

---

I have a select statement in sql 2000, with the select on a linked server (oracle) table.

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?

select  nvl(owner,'SYS') owner, 
        session_id, 
        name,
        mode_held, 
        mode_requested
from    sys.dba_dml_locks
where   name in('YOUR_TABLE_NAME')  
order by 2
;