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…
January 22, 2024 Mechanics of Connecting over TCP/IP- Architecture Overview-2 To use a tnsnames.ora file, you use the name of the entry you placed in the file. The client software (SQL*Plus in this example)…
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…
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…
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 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…
July 22, 2022 Server Parameter Files (SPFILEs)- Files SPFILEs represent a fundamental change in the way Oracle accesses and maintains parameter settings for the instance. An SPFILE eliminates the two serious issues…
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,…
