Summary-Transactions
In this chapter, we looked at many aspects of transaction management in Oracle. Transactions are among the major features that set […]
Read More →In this chapter, we looked at many aspects of transaction management in Oracle. Transactions are among the major features that set […]
Read More →
Let’s now look at the second reason developers are tempted to commit updates in a procedural loop, which arises from their […]
Read More →
The first thing that pops out should be “Our trigger fired twice!” We had a one-row table with a BEFORE FOR […]
Read More →
We understand that the WHERE Y=5 component, the read-consistent phase of the query, will be processed using a consistent read (query […]
Read More →
Another situation where it is vital that you understand read consistency and multiversioning is when you are faced with a query […]
Read More →
It is easier to see a restart than you might, at first, think. We’ll be able to observe one, in fact, […]
Read More →
In Oracle, we also have the ability to defer constraint checking, which can be quite advantageous for various operations. The one […]
Read More →
Since PL/SQL was first introduced in version 6 of Oracle, it has been transparently using an asynchronous commit. That approach has […]
Read More →
It is interesting to note exactly when integrity constraints are checked. By default, integrity constraints are checked after the entire SQL […]
Read More →
This is generally considered the most restrictive level of transaction isolation, but it provides the highest degree of isolation. A SERIALIZABLE […]
Read More →