July 22, 2024 Preventing Lost Updates- Developing Successful Oracle Applications One of the side effects of Oracle’s nonblocking approach is that if you actually want to ensure that no more than one user has…
January 22, 2024 Mechanics of Connecting over TCP/IP- Architecture Overview-1 We’ll investigate the most common networking case: a network-based connection request over TCP/IP. In this case, the client is situated on one machine and…
September 22, 2023 Single-Tenant (Non-container) RAC Database- Architecture Overview In the special case of Oracle Real Application Clusters (RAC), an Oracle option that allows it to function on many computers in a clustered…
June 22, 2023 Knowing What’s Out There- Developing Successful Oracle Applications Not having a full understanding of what is available to you can come back to haunt you in the long run. I was working…
March 22, 2023 Legacy init.ora Parameter Files- Files The legacy init.ora file is a very simple file in terms of its construction. It is a series of variable key/value pairs. A sample…
March 22, 2023 Multitenant Container Database- Architecture Overview Starting with Oracle 12c, Oracle introduced a new type of database, the multitenant container database and the associated pluggable databases. A multitenant container database…
February 22, 2023 Features andFunctions- Developing Successful Oracle Applications A natural extension of the argument that you shouldn’t necessarily strive for database independence is the idea that you should understand exactly what your…
January 22, 2023 What Are Parameters?- Files In simple terms, a database parameter may be thought of as a key/value pair. To see the current value of an instance parameter, you…
December 22, 2022 Use a Single Connection in Oracle- Developing Successful Oracle Applications-4 So, they don’t know that the following table in particular exists: SQL> create table user_pw The prior USER_PW table looks like a pretty important…
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…
