O'Reilly logo

Oracle by Guy Harrison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required