What Is a READ ONLY Transaction?
Page 1 of 1
What Is a READ ONLY Transaction?
A READ ONLY transaction is a transaction in which the read consistency is set at the transaction
level. In a READ ONLY transaction, a logical snapshot of the database is created at the beginning
of the transaction and released at the end of the transaction. This guaranties that all reads in all
statements within this transaction get consistent data from the database.
For example, if you have a transaction with many statements that takes 10 hours to be executed,
a snapshot of the database will be created for this transaction for 10 hours. If a query statement is
executed at the beginning of the transaction and at the end of the transaction, it will return the
same result guarantied. In another word, data changes made during this 10 hours by other users
will not impact the execution of statements within this transaction.
level. In a READ ONLY transaction, a logical snapshot of the database is created at the beginning
of the transaction and released at the end of the transaction. This guaranties that all reads in all
statements within this transaction get consistent data from the database.
For example, if you have a transaction with many statements that takes 10 hours to be executed,
a snapshot of the database will be created for this transaction for 10 hours. If a query statement is
executed at the beginning of the transaction and at the end of the transaction, it will return the
same result guarantied. In another word, data changes made during this 10 hours by other users
will not impact the execution of statements within this transaction.
Similar topics
» How To Set a Transaction To Be READ ONLY?
» What Is a READ WRITE Transaction?
» How To Commit the Current Transaction?
» What Is a Transaction?
» How To Start a New Transaction?
» What Is a READ WRITE Transaction?
» How To Commit the Current Transaction?
» What Is a Transaction?
» How To Start a New Transaction?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
Sun Jan 31, 2010 12:35 am by Micheal
» Accessing tables of other users in SQL
Sun Jan 31, 2010 12:34 am by Micheal
» Grouping commands in SQL
Sun Jan 31, 2010 12:32 am by Micheal
» Operations on Result Sets in SQL
Sun Jan 31, 2010 12:31 am by Micheal
» Subqueries in SQL
Sun Jan 31, 2010 12:30 am by Micheal
» Joining Relations in SQL
Sun Jan 31, 2010 12:28 am by Micheal
» Delete comand in SQL
Sun Jan 31, 2010 12:27 am by Micheal
» Update command in SQL
Sun Jan 31, 2010 12:26 am by Micheal
» Insert command in SQL
Sun Jan 31, 2010 12:23 am by Micheal