Bad Transaction Habits-Transactions
Many developers have some bad habits when it comes to transactions. I see this frequently with developers who have worked with […]
Read More →Many developers have some bad habits when it comes to transactions. I see this frequently with developers who have worked with […]
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 →
So far, we’ve looked at read consistency: Oracle’s ability to use undo information to provide nonblocking query and consistent (correct) reads. […]
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 →
Oracle allows you to add a WRITE clause to your COMMIT statements. The WRITE clause allows the commit to either WAIT […]
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 →
It is generally not faster to commit frequently—it is almost always faster to do the work in a single SQL statement. […]
Read More →