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 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…
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…
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…