See "Why does it seem that a SELECT over a db_link requires a commit after execution ?" at http://www.jlcomp.demon.co.uk/faq/dblink_commit.html Regards Nigel ----- Original Message ---- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx> To: marc.demlenne@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Sent: Tuesday, April 3, 2007 1:25:01 PM Subject: RE: Remote Select opening transaction Hi. I am pretty sure your information is incorrect. I have never seen a select across a db link open a transaction.