RE: Locking over a DB link

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Tue, 9 Dec 2008 16:03:30 -0500
Message-ID: <21469B88E0EA11498818517F210335310455BA3E@EPRI17P32001A.csfb.cs-group.com>

I can't think of any reason why any Oracle read would cause a lock--after all, readers never block writers, etc. Even if a DB link is involved that shouldn't change. But I'm sure someone out there will prove me wrong. ;-)  

Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com  

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jason Heinrich Sent: Tuesday, December 09, 2008 3:54 PM To: Oracle List
Subject: Re: Locking over a DB link

Sorry, forgot the db info:

Both databases are 10.2.0.3 EE on Windows 2003. Remote database is a logical standby.

On Tue, Dec 9, 2008 at 2:47 PM, Jason Heinrich <jheinrichdba_at_gmail.com> wrote:

        I was wondering if it was possible for SQL similar to the following to cause a lock to be created on the remote database:         

	insert into localtable
	(select columns from remotetable_at_dblink where <some condition>);
	
	My first reaction was no, but I thought I remembered locking

oddities over links being discussed before. So far I haven't found anything useful in my searches though.         

	-- 
	Jason Heinrich
	

-- 
Jason Heinrich




==============================================================================

Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html


==============================================================================



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

Received on Tue Dec 09 2008 - 15:03:30 CST