An Oracle database server consists of an Oracle database and an Oracle instance. Every time a database is started, a system global area (SGA) is allocated and Oracle background processes are started. The combination of the background processes and memory buffers is called an Oracle instance.
Multiple Instance Systems, Real Application Clusters (RAC) takes advantage of such architecture by running multiple instances that share a single physical database. In most applications, RAC enables access to a single database by users on multiple computers with increased performance.
At a very high level,
RAC architectureconsists of these components:
- Physical Nodes or Hosts
- Physical Interconnects and interconnect protocols
- Cluster Manager Software and Cluster Ready Services
- Oracle Instances and Cache Fusion
- Shared Disk System
- Clustered File System, Raw Devices, Automatic Storage Management
- Network Services
- Workload Management Services ? Virtual IP configuration
For example, memory stores program code being run and data shared among users. Two basic memory structures are associated with Oracle: the system global area and the program global area. The following subsections explain each in detail.
System Global Area (SGA)is a shared memory region that contains data and control information for one Oracle instance. Oracle allocates the
SGAwhen an instance starts and deallocates it when the instance shuts down. Each instance has its own
The information stored in the SGA is divided into several types of memory structures, including the
redo log buffer, and
the shared pool.
Database buffersstore the most recently used blocks of data. The set of database buffers in an instance is the database buffer cache. The buffer cache contains modified as well as unmodified blocks. Because the most recently (and often, the most frequently) used data is kept in memory, less disk I/O is necessary, and performance is improved.
With automatic SGA management, you can simply set the
SGA_TARGETinitialization parameter to
1G. If an application needs more shared pool memory, it can obtain that memory by acquiring it from the free memory in the buffer cache.
redo log bufferstores redo entries—a log of changes made to the database. The redo entries stored in the redo log buffers are written to an online redo log, which is used if database recovery is necessary. The size of the redo log is static.
shared poolcontains shared memory constructs, such as shared SQL areas. A shared SQL area is required to process every unique SQL statement submitted to a database. A shared SQL area contains information such as the parse tree and execution plan for the corresponding statement. A single shared SQL area is used by multiple applications that issue the same statement, leaving more shared memory for other uses.
Program Global Area (PGA)is a memory buffer that contains data and control information for a server process. A PGA is created by Oracle when a server process is started. The information in a PGA depends on the Oracle configuration.
It is a nonshared memory created by Oracle when a server process is started. Access to it is exclusive to that server process and is read and written only by Oracle code acting on behalf of it. The total PGA memory allocated by each server process attached to an Oracle instance is also referred to as the aggregated PGA memory allocated by the instance.
License: CC BY-NC-ND 4.0