Oracle8i Architecture

The Oracle RDBMS architecture is comprised of two parts:

  • The Oracle instance— This consists of the background processes (threads) and memory structures such as the shared global area (SGA) and program global area (PGA). A unique system identifier is used to identify each Oracle instance. We will be discussing each of these components in detail later.

  • The Oracle database— This consists of the physical components such as data files, control files, redo log files, initialization files, and archive logs. It also consists of the logical components such as tables, constraints, procedures, views, and so forth. We will be discussing each of these components in detail later.

Running Oracle on Windows NT

On Windows NT, Oracle uses ...

Get e-Commerce Applications Using Oracle8i and Java from Scratch 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.

Start your free trial