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.

 

Supported Transaction Isolation Levels in Oracle

Restrictions in a READ ONLY Transaction in Oracle

Understanding SQL Transaction Management in Oracle

⇑⇑ Oracle Database Tutorials

2019-08-19, 1472🔥, 0💬