CHAPTER 2Oracle Internals

Another name for this chapter could be “The Guts of Oracle.” What is it doing in there? It is obvious that the inside workings of SQL Server and Oracle are not the same, or they wouldn’t be two different database platforms. Understanding how the internal and system structures are set up in Oracle will give you insight into some of the best practices for Oracle.

In this chapter, we will focus on configurations and how the memory and system areas are organized. There are also Oracle processes or services to get to know. Then we will take a look at some of the knobs that can be turned for options of the database. Finally, we will examine how changes and transactions are handled by the logs and processes.

Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.