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 →
It is interesting to note that Oracle considers PL/SQL blocks to be statements as well.Consider the following stored procedure and reset […]
Read More →
Consider the following statement:SQL> Insert into t values ( 1 ); It seems fairly clear that if the statement were to […]
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 →
The entire goal of a transaction, a set of SQL statements executed together as a unit of work, is to take […]
Read More →