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.
2016-10-17, 472👍, 0💬
Related Topics:
