A distributed query is always treated like a distributed "transaction", with
the inherent two-phase commit mechanism.
or the Chapters on Distributed Transactions in the Administrators Gu9ide.
The read-consistency model within an instance relies on the SCNs in
When you are running queries across two database instances that ARE running
different SCNs, how do you get read consistency ? I believe that the
transaction method of using the highest global SCN is used for queries as well.
At 08:07 PM Tuesday, Marc Demlenne wrote:
>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,
Hemant K Chitale