Oracle Database - System Global Area - SGA (Shared Memory)

Card Puncher Data Processing

About

The SGA (System Global Area) is an area of memory allocated when an Oracle Instance starts up.

The SGA memory is shared by all sessions connected to Oracle Instance. See Virtual Memory - Shared Memory (SHM)

A group of shared memory structures that contain data and control information for an Oracle instance.

Oracle Database Sga

where:

Configuration

The SGA's size and function are controlled by initialization (INIT.ORA or SPFILE) parameters.





Discover More
Data System Architecture
Concurrency - Latches (System Lock)

Latches are like semaphores. Latches are used to guarantee physical consistency of data, while locks are used to assure logical consistency of data. Latches are simple, low-level system lock (serialization...
Card Puncher Data Processing
Oracle Database - Buffer cache

For many types of operations, Oracle Database uses the buffer cache to store data blocks read from disk. Oracle Database bypasses the buffer cache for particular operations, such as sorting and parallel...
Oracle Database One Instance By Database
Oracle Database - Instance (Database Start-up)

When you start a database, an instance is created. An instance is comprised of: a memory area called the System Global Area (SGA) and Oracle background processes. The memory and processes of an...
Card Puncher Data Processing
Oracle Database - Memory

Oracle have two Memory spaces: SGA memory which is shared by all sessions connected to Oracle Database. See and PGA memory which is allocated for each session. See With SQLPlus
Card Puncher Data Processing
Oracle Database - PGA_AGGREGATE_TARGET Parameter

PGA_AGGREGATE_TARGET is a database initialization parameter and controls the total amount of execution memory that can be allocated by Oracle for the Process global area (PGA) The Total Memory here refers...
Card Puncher Data Processing
Oracle Database - Process global area (PGA) - Work Area

The PGA memory is a memory allocated for each session. The PGA (Program or Process Global Area) is a memory area that stores data and control information for a single server process. It typically contains...
Card Puncher Data Processing
Oracle Database - Redo Log (Transaction Log Files)

transaction log in Oracle are knwon as the redo log. Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure. To protect against a failure...
Oracle Database Sga
Oracle Database - Shared Pool

The Shared pool is a shared memory area where cursors and PL/SQL objects are stored. The shared pool is a shared memory that store: Cached data dictionary information and Shared Cursors and PL/SQL...
Card Puncher Data Processing
Oracle Database - System Change Numbers (SCNs) - Point in time

A system change number (SCN) is a logical, internal time stamp used by Oracle Database. SCNs order events that occur within the database, which is necessary to satisfy the ACID properties of a transaction....
Card Puncher Data Processing
Oracle Database - Transactions

All Oracle transactions comply with the basic properties of a database transaction, known as ACID properties. A transaction begins when the first executable SQL statement is encountered. An executable...



Share this page:
Follow us:
Task Runner