Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Integrity Problems

Although locks can introduce contention and performance degradation, locks are still required to prevent the following integrity problems:

Dirty reads

This type of read occurs when a database allows a transaction to read data that has been changed by another transaction but not yet committed. The changes made by the transaction may be rolled back, so the data read may turn out to be incorrect. Many databases allow dirty reads in order to avoid the contention caused by read locks.

Nonrepeatable reads

This type of read occurs as a result of changes made by another transaction. A transaction performs a query based on a particular condition. After the data has been sent to this transaction, but before this transaction is complete, another transaction changes the data so that some of the previously retrieved data would no longer satisfy the selection condition. If the query were to be repeated in the same transaction, it would return a different set of results, so any changes made on the basis of the original results may no longer be valid. Data that was read once may return different results if it is read again later in the same transaction.

Phantom reads

This type of read also occurs as a result of changes made by another transaction. One transaction performs a query based on a particular condition. After the data has been sent to this transaction, but before this transaction is complete, another transaction inserts new rows into the database that would have been selected ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page