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…
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…
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…
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 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…
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…
September 22, 2022 Layered Programming- Developing Successful Oracle Applications Once you understand that each database will implement features in a different way, another example of defensive programming to allow for portability is to…
