Re: How to get the statment sql that caused the lock
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 29 Oct 2018 09:19:18 -0400
Message-ID: <480bbaac-9301-011f-dae4-a69bc158db73_at_gmail.com>
Date: Mon, 29 Oct 2018 09:19:18 -0400
Message-ID: <480bbaac-9301-011f-dae4-a69bc158db73_at_gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 29 2018 - 14:19:18 CET