Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> Serializable distributed transactions
post Mar 27 2012, 03:16 PM
Post #1


Group: Possible Spammers
Posts: 1
Joined: 27-March 12
Member No.: 46,985


here http://www.dba-oracle.com/t_oracle_isolation_level.htm
you wrote that

"The serializable transaction isolation level is not supported with distributed transactions."

Can you please elaborate what is not supported (or example on what is not working properly)? I falied to find confirmation on this in Oracle documentation...

Go to the top of the page
+Quote Post
post Mar 27 2012, 03:26 PM
Post #2

Advanced Member

Group: Members
Posts: 12,560
Joined: 26-January 04
Member No.: 13

Hi Joe,

>> Can you please elaborate what is not supported

The idea is to prevent dirty reads. As I understand it, it's possible in a distributed transaction to get a non-repeatable read bnecause the read consistency does not work across databases.

In the serializable transaction isolation level non-repeatable and phantom reads are not possible.

From the docs, read about "in question" transactions:


Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
+Quote Post
post Mar 28 2012, 02:39 AM
Post #3

Advanced Member

Group: Members
Posts: 642
Joined: 28-August 04
Member No.: 495


An important restriction exists in Oracle's implementation of distributed read consistency. The problem arises because each system has its own SCN, which you can view as the database's internal timestamp. The Oracle database server uses the SCN to decide which version of data is returned from a query.
. . .
One consequence of the SCN gap is that two consecutive SELECT statements can retrieve different data even though no DML has been executed between the two statements.
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 9th October 2015 - 12:39 PM