当前位置：文档视界 › Oracle Database 12c体系架构图

Oracle Database 12c体系架构图

数据库模型优化服务数据库系统性能优化服务数据库迁移服务数据归档服务

数据库培训服务

数据恢复软件与服务

LMS0-z

Global Cache Service

LMON

Global Enqueue Service Monitor

Lnnn

Pooled Server Process

Nnnn

Connection Broker Process

Pnnn

Parallel Query Slaves

Snnn

Shared Server

Dnnn

Dispatchers

Server Process

DWnn

Data Pump Worker

DMnn

Data Pump Master

PING

Interconnect Latency

Measurement

RMSN

RAC

Management Process

LMHB

GlobalCache Enqueue Heartbeat Monitor

LMD0,Z

Global Enqueue Service

LCK0,1

Lock Process

IPC0

IPC Service

RSMN

Remote Slave Monitor

SMCO Wnnn

Space

Management Coordinator

Onnn

ASM Conection Pool

EMNC

ENMO

PRnn

Parallel Recovery Process

DIA0

Diagnostic Process

SCMN

Thread Listener

SCMN

Thread Listener

DIAG

Diagnostic Capture Process

CTWR

Change Tracking Writer

RMAN Process

RVWR

Recovery Writer

TMON

Transport Monitor

FBDA

Flashback Data Archiver

CKPT

Checkpoint Process

ACMS

Atomic Control File to Memory Service

LGWR LG00-99

Redo Log Writer

TT00-zz

Redo Transport Slave

ARCn

Archiver Process n=0..9 or n=a..t

RBAL

ASM Rebalance Master

OCFn

ASM CF

Connection Pool

MARK

Mark AU for

Resynchronization Coordinator

RPnn

Capture Process Worker

RAT Masking Slave

OFSD

Oracle File Server

CJQ0Jnnn

Job Queue Coordinator

Qnnn

AQ Server Class

QMnn

AQ Master Class

VKRM

Virtual Schedule

for Resource Manager

RCBG

Result Cache

MMAN

Memory

Manager

MMON

Manageability Monitor

MMNL

Manageability Monitor Lite

PMON

Process Monitor

SMON

System Monitor

REC0

Recovery Process

SAnn

SGA Allocator

DBRM

Database Resource Manager

Server Process

VKTM

Virtual Keeper of TiMe

GEN0

General Task Execution

PSP0

Process Spawner

AQPC

AQ Process Coordinator

31 possible destinations

Database

Area

Flash Recovery Area

Automatic Diagnostic Repository (ADR)

Recover Table

Dump File

Dedicated Server

Oracle Supplied Common Users/Schemas/Objects

Customer Common Users

Root

Shared Server

Database Resident Connection Pooling

共享池

Library Cache

Shared SQL Area

Hash value SQL source Execution plan

User Global Area(UGA)for Shared Server Result Cache ASH Buffers

Reserved Pool Least Recently Used (LRU) List

Cold

Checkpoint Queue

Low RBA order Hot

In-memory Undo (IMU)

Private Redolog Buffers

Data Dictionary Cache

Enqueues Latches

Global Resource Directory (RAC Only)ges big msg buffers

gcs res hash bucket ges resource

gcs master ship bucket ges shared global area gcs resources ges process array

gcs shadows ges reserved msg buffers

ges enqueues

gcs affinity

heap (1,0)heap (1,2)heap (1,1)heap (1,3)

SUB

Shared Pool

SUB

Shared Pool

系统全局区 (SGA)

插接式数据库(PDB)

SYSTEM

SYSAUX UNDO (global)(global)

TEMP

temp undo 程序全局区 (PGA)

Sort Area

SQL Work Hash Area

Bitmap Merge Area

User Global Area (UGA)Private SQL Area Session Variables

OLAP Pool

Persistent Area

Area

Runtime Redo Thread

Group Files

Redo Log File

Change Tracking Flashback Thread

Flashback Logs

Control Files

Cursor

MML OSB

Tape

Cloud

Large Pool

Response Queues Request Queue

Oracle XA Interface Pool Backup/Recovery Operations Private SQL Area for Shared servers PX msg pool

Shared I/O Pool Pool Streams Java Pool

Used Memory Memory

Free Fixed SGA

Files

Redo Log Archived Flash Cache

Listener

Public

SYS PDB DW

SYSTEM SYSAUX TEMP DW

CDBA

Public

ERP SYS PDB ERP

SYSTEM SYSAUX

ERP

CDBA

EMP

SYS SEED

PDB$

Public

SYSTEM SYSAUX

sys

Public

CDBA

Image Copies

Backup Sets

Far Sync Instance

sync

Stanby Database

12.1async

User Process DBW0..Z Database Writer

BW36..99

代表Oracle 进程表示在多线程模式下，可以作为线程运行的进程表示必须独立运行的进程

代表Oracle 12c 中的新增和变更进程

代表RAC 中的进程

代表文件

SYS CDBA

PDB CRM

Public

CRM

SYSTEM

SYSAUX TEMP CRM

Redo Log Buffer

云和恩墨(北京)信息技术有限公司

YUNHE ENMO (BEIJING) INFORMATION TECHNOLOGY CO.,LTD.

https://www.docsj.com/doc/3b9349240.html,

4006608755

广州办事处成都办事处南京办事处贵阳办事处

上海办事处北京总公司Server Parameter

File

LREG

Listener Registration Process

SUB

Shared Pool

SUB

Shared Pool

Flash back Buffer

SUB

Shared Pool SUB

Shared Pool 体系结构图Oracle 数据库

Oracle Database Architecture

Your

Best Choice

EMON

Coordinator

Flash Buffer Area

DEFAULT flash LRU chain

Keep flash LRU chain

Non Default Buffer Pools

2 k 16 k

32 k

2121M a k e Y o u r D a t a D a n c e

数据缓冲区

In Memory Area

Pure In-Memory Columnar

此图基于Oracle Database 12c Architecture图片修订、重新设计而成，增加中文说明及多租户、IMCS等元素，更加适合中国的技术爱好者浏览。原图链接见：https://www.docsj.com/doc/3b9349240.html,/webfolder/technetwork/tutorials/obe/db/12c/r1/poster/OUTPUT_poster/pdf/Database%20Architecture.pdf

Column Format Data

SMU

SMU SMU

Metadata

IMCU

IMCU IMCU

IMCU Buffer Pools

Default

Recycle

Keep

8 k

Column Format

Row Format

恩墨学院微信：enmoedu

云和恩墨微信：enmotech 支持O R A 错误代码查询