December 22, 2022 Use a Single Connection in Oracle- Developing Successful Oracle Applications-3 Executing SQL statements without bind variables is very much like compiling a subroutine before each method call. Imagine shipping Java source code to your…
July 22, 2022 Server Parameter Files (SPFILEs)- Files SPFILEs represent a fundamental change in the way Oracle accesses and maintains parameter settings for the instance. An SPFILE eliminates the two serious issues…
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…
December 22, 2021 Database Independence?- Developing Successful Oracle Applications By now, you might be able to see where I’m going in this section. I have made references to other databases and how features…
June 22, 2021 Implementing Locking- Developing Successful Oracle Applications The database uses locks to ensure that, at most, one transaction is modifying a given piece of data at any given time. Basically, locks…
