3

Oracle Database Architecture

In this chapter:

  • What are the basic architectural concepts of Oracle Database?

  • What is the Oracle instance?

  • What is the physical structure of an Oracle database?

  • How do you start up and shut down a database?

  • Enhancing the basic physical architecture of an Oracle database.

Let’s begin with some very basic concepts.

3.1 The Basic Concepts

Oracle Database 10g is a relational database management system (RDBMS), which means that it is a set of software programs that handles the storage of information, the security for access to the information, and the connections between various portions of the information.

Once you have installed the RDBMS software, you can create an Oracle instance and a database. Figure 3.1 shows ...

Get Oracle SQL 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.