Oracle Database 12c Architecture

笨鸟

2399

1页

5次

2019-09-12

5墨值下载

数据库模型优化服务数据库系统性能优化服务数据库迁移服务数据归档服务数据库培训服务数据恢复软件与服务

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

CJQ0

Jnnn

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)

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

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

Streams

Java Pool

Used

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.1

async

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.

www.enmotech.com

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

Make Your Data Dance

数据缓冲区

In Memory Area

Pure In-Memory Columnar

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

Column Format Data

SMU SMU

Metadata

IMCUIMCU

IMCU

IMCUIMCU

Buffer Pools

Default

RecycleKeep

8 k

Column Format

Row Format

恩墨学院微信：enmoedu

云和恩墨微信：enmotech

支持ORA错误代码查询

数据库模型优化服务数据库系统性能优化服务数据库迁移服务数据归档服务数据库培训服务数据恢复软件与服务

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

CJQ0

Jnnn

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)

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

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

Streams

Java Pool

Used

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.1

async

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.

www.enmotech.com

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

Make Your Data Dance

数据缓冲区

In Memory Area

Pure In-Memory Columnar

Column Format Data

SMU SMU

Metadata

IMCUIMCU

IMCU

IMCUIMCU

Buffer Pools

Default

RecycleKeep

8 k

Column Format

Row Format

恩墨学院微信：enmoedu

云和恩墨微信：enmotech

支持ORA错误代码查询

of 1

5墨值下载

关注

评论