General Rules on Data Consistency in Oracle

Q

What Are the General Rules on Data Consistency in Oracle?

✍: FYIcenter.com

A

Here is a list of general rules on data consistency:

  • All SQL statements always work with a snapshot of the database to provide data consistency.
  • For READ WRITE transactions, the snapshot is taken when each statement starts.
  • For READ ONLY transactions, the snapshot is taken when the transaction starts.
  • The snapshot never include uncommitted changes from other transactions.
  • The snapshot always include uncommitted changes from its own transaction.

 

⇒Understanding SQL Transaction Management in Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 327👍, 0💬

General MySQL Oracle SQL Server