Chapter 2. Oracle Architecture and Concepts

In this chapter we review aspects of the Oracle database architecture that become important when reading the chapters to come, and that are particularly relevant to Oracle performance.

You need to be broadly familiar with these aspects of Oracle database technology:

• The way in which programs interact with the Oracle database server through the APIs implemented within various programming languages

• The Oracle optimizer, which is the software layer concerned with maximizing the performance of SQL statements

• The Oracle server architecture, including the memory, processes, and files that interact to provide database services

• Oracle schema objects, including tables, indexes, partitions, and other ...

Get Oracle now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.