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…
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…
July 22, 2023 Dedicated Server- Architecture Overview If we were to log in to the database using a dedicated server, we would see a new process (or a thread on some…
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…
April 22, 2023 How Do I Make It Run Faster?- Developing Successful Oracle Applications The question in the heading is one I get asked all the time. Everyone is looking for the fast = true switch, assuming “database…
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…