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…
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…
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…
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…
March 22, 2023 The SGA and Background Processes- Architecture Overview As seen in the previous sections in this book, each Oracle instance has a large chunk of memory called the SGA that it uses,…
March 22, 2023 Openness- Developing Successful Oracle Applications I frequently see people doing things the hard way for another reason, and again it relates to the idea that we should strive for…
February 22, 2023 Single-Tenant (Non-container) Database- Architecture Overview A single-tenant database or non-container database is a self-contained set of datafiles, control files, redo log files, parameter files, and so on that include…