O'Reilly logo

Oracle SQL by Carol McCullough-Dieter, Gavin JT Powell

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

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

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