Re: How to get the statment sql that caused the lock

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: Andy Sayer <andysayer@xxxxxxxxx>
  • Date: Mon, 29 Oct 2018 09:19:18 -0400

Oh yes, queries in the distributed queries do lock tables because it is not possible to ensure that the query will return only the data committed before the start of the query without a lock.  You must have a join with a remote table, but yes, it does happen.

Regards

On 10/29/18 4:11 AM, Andy Sayer wrote:

“Queries do not lock tables, unless the queries are distributed, as in "query over a database link". For everything  else, queries to not lock tables.”

Maybe I’m misunderstanding, but a select over a DB link does not lock the table/row in any way. You do start a transaction and acquire a DX type lock but that does not effect the table.

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
//www.freelists.org/webpage/oracle-l


Other related posts: