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…
April 22, 2024 Parameter Files- Files There are many different parameter files associated with an Oracle database, from a tnsnames.ora file on a client workstation (used to “find” a server…
February 22, 2024 Multitenant RAC Database- Architecture Overview In a multitenant RAC database, you have one or more instances that are connected to a container database. Within the container database, you have…
January 22, 2024 Mechanics of Connecting over TCP/IP- Architecture Overview-2 To use a tnsnames.ora file, you use the name of the entry you placed in the file. The client software (SQL*Plus in this example)…
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…
December 22, 2023 Oracle Database Types- Architecture Overview There are two terms that, when used in an Oracle context, seem to cause a great deal of confusion: database and instance. To be…
November 22, 2023 Solving Problems Simply- Developing Successful Oracle Applications There are always two ways to solve everything: the easy way and the hard way. Time and time again, I see people choosing the…
October 22, 2023 The DBA-Developer Relationship- Developing Successful Oracle Applications It’s certainly true that the most successful information systems are based on a symbiotic relationship between the DBA and the application developer. In this…
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…
September 22, 2023 Summary- Developing Successful Oracle Applications In this chapter, we have taken a somewhat anecdotal look at why you need to know the database. The examples I presented are not…