InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 14:27:32 GMT20http://www.sqlservercentral.com/Forums/Topic1001696-1043-1.aspx[quote][b]qaz123 90964 (10/9/2010)[/b][hr]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?[/quote]Oracle does not locks tables when doing a "select" statement. The only way this could happen if statement is coded as "select for update".I would ask Oracle DBA to identify and trace this query and look at how is actually coded.To check locks on specific table you can do...[code="sql"]select nvl(owner,'SYS') owner, session_id, name, mode_held, mode_requestedfrom sys.dba_dml_lockswhere name in('YOUR_TABLE_NAME') order by 2;[/code]Hope this helps.Mon, 11 Oct 2010 08:52:56 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1001696-1043-1.aspxhiI 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?Pls helpThanks /* I have posted this in another sub forum too but i am surprised no has replied yet. */Sat, 09 Oct 2010 03:31:44 GMTqaz123 90964