Oracle Database 12c Architecture


Oracle Database 12c Architecture


Oracle Database 12c Architecture Diagram


Oracle 12c Database Architecture Diagram

Oracle Database Component Explanation.

What is Oracle Instance ?

An Oracle Instance is a combination of  Memory Area + Background Processes.

What Does Oracle Database Memory Area Consists for?

An Oracle Database Memory area consists of 2 parts SGA and PGA

What is SGA ?

SGA is known as System global area. An SGA is a Group of shared Memory Areas that contain data and control information for one Oracle Database instance. All server and background processes share the SGA . did you notice the word Group of Shared Memory.  Yes its Group. Let's explain what all are the component of this Group.

As you can see in the Image above the main Components are

Database Buffer Cache
Shared Pool
Large Pool
Redo Log Buffer
Java Pool
Flashback Buffer etc.

So let us start with the most importent component and discuss each one by one

You can query the V$SGASTAT view for information about SGA components.


Database Buffer Cache

The database buffer cache, also called the buffer cache, is the memory area that stores copies of data blocks read from data files.
A buffer is a main memory address in which the buffer manager temporarily caches a currently or recently used data block.

A buffer could be in one of the following states

Unused
The buffer is available for use because it has never been used or is currently unused. This type of buffer is the easiest for the database to use.
Clean
This buffer was used earlier and now contains a read-consistent version of a block as of a point in time. The block contains data but is "clean" so it does not need to be checkpointed. The database can pin the block and reuse it.
Dirty
The buffer contain modified data that has not yet been written to disk. The database must checkpoint the block before reusing it.


Database buffer cache is futher managed as pools of buffers and these are

default pool
keep pool
recycle pool

for detailed explanation click here

Syatem Global Area


Redo Log Buffer

The redo log buffer is a circular buffer in the SGA that stores redo entries describing changes made to the database.
A redo record is a data structure that contains the information necessary to reconstruct, or redo, changes made to the database by DML or DDL operations.

The database processes copy redo entries from the user memory space to the redo log buffer in the SGA. The redo entries take up continuous, sequential space in the buffer. The background process LGWR (log writer) writes the redo log buffer to the active online redo log group on disk


Shared Pool

Library Cache

The library cache is a shared pool memory structure that stores executable SQL and PL/SQL code.

Data Dictionary Cache

The data dictionary is a collection of database tables and views containing reference information about the database, its structures, and its users.

Server Result Cache

The server result cache is a memory pool within the shared pool. Unlike the buffer pools, the server result cache holds result sets and not data blocks.

Reserved Pool

The reserved pool is a memory area in the shared pool that Oracle Database can use to allocate large contiguous chunks of memory.




Large Pool

The large pool is an optional memory area intended for memory allocations that are larger than is appropriate for the shared pool.

Java Pool

The Java pool is an area of memory that stores all session-specific Java code and data within the Java Virtual Machine (JVM). This memory includes Java objects that are migrated to the Java session space at end-of-call.

Streams Pool

The Streams pool stores buffered queue messages and provides memory for Oracle Streams capture processes and apply processes. The Streams pool is used exclusively by Oracle Streams.

Fixed SGA

The fixed SGA is an internal housekeeping area.
For example, the fixed SGA contains:
  • General information about the state of the database and the instance, which the background processes need to access
  • Information communicated between processes, such as information about locks
The size of the fixed SGA is set by Oracle Database and cannot be altered manually. The fixed SGA size can change from release to release

Program Global Area (PGA)


The PGA is memory specific to an operating process or thread that is not shared by other processes or threads on the system. Because the PGA is process-specific, it is never allocated in the SGA.
PGA

Contents of the PGA


Over View of Oracle Database Processes

Types of Processes

Processes are divided into the following types:

client process

A client process runs the application or Oracle tool code.

Oracle process

An Oracle process is a unit of execution that runs the Oracle database code.

  •             background process


A background process starts with the database instance and perform maintenance tasks such as performing instance recovery, cleaning up processes, writing redo buffers to disk, and so on.

  •            server process

A server process performs work based on a client request.
The V$PROCESS view contains one row for each Oracle process connected to a database instance

COL SPID FORMAT a8
COL STID FORMAT a8
SELECT SPID, STID, PROGRAM FROM V$PROCESS ORDER BY SPID;


Importent Background Processes

Process Monitor Process (PMON)


The process monitor (PMON) monitors the other background processes and performs process recovery when a server or dispatcher process terminates abnormally


Listener Registration Process (LREG)


The listener registration process (LREG) registers information about the database instance and dispatcher processes with the Oracle Net Listener

System Monitor Process (SMON)


  • Performing instance recovery, if necessary, at instance startup. In an Oracle RAC database, the SMON process of one database instance can perform instance recovery for a failed instance.
  • Recovering terminated transactions that were skipped during instance recovery because of file-read or tablespace offline errors. SMON recovers the transactions when the tablespace or file is brought back online
  • Cleaning up unused temporary segments. For example, Oracle Database allocates extents when creating an index. If the operation fails, then SMON cleans up the temporary space
  • Coalescing contiguous free extents within dictionary-managed tablespaces.


Database Writer Process (DBW)


The database writer process (DBW) writes the contents of database buffers to data files. DBW processes write modified buffers in the database buffer cache to disk


Log Writer Process (LGWR)

The log writer process (LGWR) manages the online redo log buffer.

In the following circumstances, LGWR writes all redo entries that have been copied into the buffer since the last time it wrote:
  • A user commits a transaction.
  • An online redo log switch occurs.
  • Three seconds have passed since LGWR last wrote.
  • The redo log buffer is one-third full or contains 1 MB of buffered data.
  • DBW must write modified buffers to disk.


Checkpoint Process (CKPT)

The checkpoint process (CKPT) updates the control file and data file headers with checkpoint information and signals DBW to write blocks to disk. Checkpoint information includes the checkpoint position, SCN, and location in online redo log to begin recovery.


Manageability Monitor Processes (MMON and MMNL)

The manageability monitor process (MMON) performs many tasks related to the Automatic Workload Repository (AWR).


Recoverer Process (RECO)

In a distributed database, the recoverer process (RECO) automatically resolves failures in distributed transactions

Archiver Processes (ARCn)

An archiver process (ARCn) copies online redo log files to offline storage after a redo log switch occurs.

Job Queue Processes (CJQ0 and Jnnn)

A queue process runs user jobs, often in batch mode. A job is a user-defined task scheduled to run one or more times.

Flashback Data Archive Process (FBDA)

The flashback data archive process (FBDA) archives historical rows of tracked tables into Flashback Data Archives.

Space Management Coordinator Process (SMCO)

The SMCO process coordinates the execution of various space management related tasks.


I hope you got some idea to start with. If you want to read and understand more in detail just download Database Concepts guide from oracle document library.



14 comments:

  1. It is very good and useful .Learned a lot of new things from your post!Good creation ,thanks for good info oracle training in chennai

    ReplyDelete
  2. Hi.. nowhere you've mentioned/explained about 12c (CDB/PDB) architecture except that diagram in top. We expected atleast some basics on 12c arch & how it is differs from 11g, but in this page, you're posted about only 11g & named as 12c Architecture :) :) :)

    ReplyDelete
  3. Madden 22 coins are game coins used by players to spend in Madden 22 Ultimate Team.

    Attached link: https://www.gamems.com/madden-22-coins

    ReplyDelete
  4. Excellent goods from you, I have understood your stuff previous to and you are simply extremely fantastic. I actually like what you’ve obtained right here, really like what you are saying and the way in which by which you are saying it. You are making it enjoyable and you still care to stay sensible. I can’t wait to read much more from you. This is really a wonderful site. Instrumentation and Control Engineering

    ReplyDelete
  5. We have more than 5 years of experience and work with a client famous architects in pune that is spread across the world.

    ReplyDelete
  6. Tysm for the information.

    ReplyDelete
  7. Thanks for your marvelous posting! I seriously enjoyed reading it, you will be a great author.
    I will make sure to bookmark your blog and may come back later in life. I want to encourage continue your great posts, I have one more post related with roblox Visit here

    ReplyDelete
  8. Informative post. Thank you sharing. Please visit our website to learn new courses.

    ReplyDelete