April 22, 2022 Read Consistency and Nonblocking Reads- Developing Successful Oracle Applications Let’s look at the implications of multiversioning: read-consistent queries and nonblocking reads. If you are not familiar with multiversioning, what you see in the…
January 22, 2022 Flashback- Developing Successful Oracle Applications In the past, Oracle always decided the point in time at which our queries would be consistent. That is, Oracle made it such that…
February 22, 2021 Understanding Concurrency Control- Developing Successful Oracle Applications Concurrency control is one area where databases differentiate themselves. It is an area that sets a database apart from a file system and databases…