What Are the General Rules on Data Consistency

Q

What Are the General Rules on Data Consistency? - Oracle DBA FAQ - Understanding SQL Transaction Management

✍: FYIcenter.com

A
  • 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.

2007-04-17, 4529👍, 0💬