Remote Select opening transaction

From: "Marc Demlenne" <marc.demlenne@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 3 Apr 2007 14:07:34 +0200

Hello,

In Oracle 8, when performing a select query on another database threw DB
link, Oracle opens a transaction that could only be closed by commit or
rollback. That could be harmful when developers are not aware of this and
don't close transaction. (leading to ORA-01562.)

What is the reason of this behaviour ? Is there some docs / faq explaining
this ?
Is this feature also common to later versions of Oracle ?

Thanks a lot for any piece of information given,

--
Marc

Follow-Ups:

RE: Remote Select opening transaction
From: Kerber, Andrew W.

Remote Select opening transaction

Other related posts: