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…
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…
December 22, 2022 Use a Single Connection in Oracle- Developing Successful Oracle Applications-4 So, they don’t know that the following table in particular exists: SQL> create table user_pw The prior USER_PW table looks like a pretty important…
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…
April 22, 2022 Multiversioning- Developing Successful Oracle Applications This is a topic very closely related to concurrency control as it forms the foundation for Oracle’s concurrency control mechanism. Oracle operates a multiversion,…
December 22, 2021 Database Independence?- Developing Successful Oracle Applications By now, you might be able to see where I’m going in this section. I have made references to other databases and how features…
April 22, 2021 The Impact of Standards- Developing Successful Oracle Applications If all databases are SQL99 compliant, then they must be the same. At least that’s often the assumption. In this section, I’d like to…
