Oracle does not support "dirty reads".
Oracle is the only database that handles this properly. Other db's lack this.
Oracle always give you a read consistent view of the data...
Readers don't block writers and writers don't block readers...
You get the right answer at the point in time you query even if it takes a long time to complete and your query will never block.
See server concepts manual, Chapter 10 for more information.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only