Re: Remote Select opening transaction


A distributed query is always treated like a distributed "transaction", with
the inherent two-phase commit mechanism.
See http://www.jlcomp.demon.co.uk/faq/dblink_commit.html
or the Chapters on Distributed Transactions in the Administrators Gu9ide.
The read-consistency model within an instance relies on the SCNs in the instance. 
When you are running queries across two database instances that ARE running
different SCNs, how do you get read consistency ? I believe that the distributed 
transaction method of using the highest global SCN is used for queries as well.

Hemant

At 08:07 PM Tuesday, Marc Demlenne wrote:

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



Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantscribbles.blogspot.com
and
http://hemantoracledba.blogspot.com

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

Other related posts: