Domain Services Cluster
4
4
Database
Member Cluster
Uses ASM
Services
Shared ASM
SEED PDB FILE
APPLICATION CONTAINER
Sys Cdba
Public
Sysaux Undo TempSystem
SYSTEM
SYSAUX
+UNDO
TEMP
SEED
(PDB&SEED)
X86服务器(R930/R730)
HGST
X86服务器(R930/R730)
HGST
X86服务器(R930/R730)
HGST
Automatic Diagnostic
Repository (ADR)
BG Trace
file
HM
Reports
Incident
Packages
AlertLog
File
Incident
Dumps
FG Trace
file
Dump
file
Image Copies
Or
Backup Sets
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
Pool
Java Pool
Used
Memory
Memory
Free
Fixed SGA
Cloud
代表 Oracle 进程
代表 Oracle 12.2 以前版本进程
代表 Oracle 12.2 中的新进程
代表 RAC 中的进程
代表 ASM 中的进程
DB 单实例
广州办事处 成都办事处
南京办事处 贵阳办事处
上海办事处北京总公司
数据和云（OraNews）云和恩墨（enmotech） 恩墨学院（enmoedu）
Make Your Data Dance
Standby Instance 2
Site 30
Site 2
Standby Instance 1
Large Pool
Buffer Cache
Java Pool
Streams Pool
Shared Pool
Large Pool
Buffer Cache
Java Pool
Streams Pool
Shared Pool
SYNC
Lsp0
ASYNC
CONNECTION POOL
(GDS POOL)
Flash Recovery Area
Wallet
COPY
PDB5
COPY
APPLICATION SEED PDB FILE
ASM2
ACFS FS ORACLE BIN & 3RD PARTY FS
漂移
IP
ORACLE
CLUSTERWARE
HOT CLONE
Global
Service
Managers
GDSCTL
Global
Service
Managers
GDSCTL
GDS 目录GDS 目录
Hub Node n
One Node
Instance
Redo Shipping
Lnnn
Pooled Server
Process
Pnnn
Parallel Query
Slaves
Snnn
Shared Server
Dnnn
Dispatchers
Database Resident Connection Pooling
Cursor
Listener
程序全局区 (PGA)
Sort Area
SQL Work Areas
Hash Area
Bitmap Merge Area
User Global Area (UGA) Private SQL Area
Session Variables
OLAP Pool
Persistent Area
Runtime Area
Shared Pool
共享池
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
Library Cache
Shared SQL Area
Hash value SQL source
Execution plan
User Global Area(UGA)
for Shared Server
Domain1
Domain2
Domain3
Domain4
Resource Hash
Table
Resource Hash
Table
Resource Hash
Table
Resource Hash
Table
SUB
Shared Pool
SUB
Shared Pool
SUB
Shared Pool
SUB
Shared Pool
SUB
Shared Pool
SUB
Shared Pool
heap (1,0)
heap (1,2)
heap (1,1)
heap (1,3)
X86服务器(R930/R730)
HGST
X86服务器(R930/R730)
HGST
X86服务器(R930/R730)
HGST
Flash Cache
In-Flash
column Scan
SCM0
DLM Statistics
Collection and
Management
Slave
NFSn
Direct NFS
Dispatcher IO
Slave Process
PXMN
Parallel
Execution
Monitor
RLnn
Reset Logs
Process
Wnnn
Space
Management
Slave Process
JPn
Java Patching
Slave Process
SVCB
Service
Background
Process
Rnnn
ASM Block
Remap Slave
Process
PSP0
Process
Spawner
Process
OCFn
ASM CF
Connection
Pool Process
MMON
Manageability
Monitor
Process
VKTM
Virtual Keeper
of Time
Process
GEN0
General Task
Execution
Process
OFSD
Oracle File
Server
Background
Process
RMSn
Oracle RAC
Management
Process
RSMN
Remote Slave
Monitor
Process
QMnn
AQ Master
Class Process
AQPC
AQ Process
Coordinator
IPC0
IPC Service
Background
Process
DIA0
Diagnostic
Process
LMHB
Global Cache/
Enqueue Service
Heartbeat
Monitor
PING
Interconnect
Latency
Measurement
Process
LCKn
Lock
Process
XDMG
Exadata
Automation
Manager
Vnnn
Volume
I/O
SMCO
Space
Management
Coordinator
Process
VKRM
Virtual Scheduler
for Resource
Manager
Process
Qnnn
AQ Server
Class Process
DBRM
Database
Resource
Manager
Process
CJQ0
Job Queue
Coordinator
Process
RPnn
Capture
Processing
Worker
Process
EMNC
EMON
Coordinator
Process
LMDn
Global Enqueue
Service Daemon
Process
服务：
产品：
shadow copy
VIP
InfiniBand交换机InfiniBand交换机
Leaf Nodes
01
02
03
04
n>32 Reader node
shardgroup B3
DATA CENTER 3
DATA CENTER 1
DATA CENTER 2
shardgroup B1
shardgroup B2
shardgroup A3
shardgroup A1
shardgroup A2
ASM1
SYSTEM
SYSAUX
+UNDO
TEMP
PDB1
SYSTEM
SYSAUX
+UNDO
TEMP
PDB 2
SYSTEM
SYSAUX
+UNDO
TEMP
QUOTA GROUP QGRP1
File Group1
File Group2
QUOTA GROUP QGRP2
File Group3
QUOTA GROUP QGRP2
QUOTA GROUP QGRP1
File Group1 File Group2 File Group3
ACFS
AFD
CRSD
EVMD
OCSSD&OPROCD
ASM INSTANCE 1
Shared
Pool
Large
Pool
ASM
Cache
LMON
LMD0
LMSn
DIAG
LCK0
Free
Memory
Rbal
Arbn
Snnn
Onnn
Mark
Gmon Pnnn
ACFS
AFD
CRSD
EVMD
OCSSD&OPROCD
ASM INSTANCE 2
Shared
Pool
Large
Pool
ASM
Cache
LMON
LMD0
LMSn
DIAG
LCK0
Free
Memory
Rbal
Arbn
Snnn
Onnn
Mark
Gmon Pnnn
Build Your Dream Life
云和恩墨(北京)信息技术有限公司
YUNHE ENMO (BEIJING) INFORMATION TECHNOLOGY CO.,LTD.
www.enmotech.com
4006608755
DMnn
Data Pump
Master
Process
增强安全 保障连续 优化性能 智能集成 数据恢复
IT系统健康自动检查平台
Bethune ZONE z3 zData
性能监控与性能分析平台 SQL质量管控平台 分布式存储管理平台
Cluster Domain
CKPT
Checkpoint
Process
RMS0
Oracle RAC
Management
Process
TMON
Tranport
Monitor
RCBG
Result Cache
Background
Process
FBDA
Flashback
Data Archiver
Process
Or
MML
OSB
Tape
Cloud
Recovery
Buddy
Buffer
IN MEMORY AREA ( Year )
In-Memory
JSON Format
Virtual
columns
SMU
DATA
12 R2
Oracle Database Architecture
体系结构图
Oracle
数据库
12 R2
YH1
YH3
YH4
YH5
YH11
YH10
YH8
YH9
YH7
YH6
1
4
Database
Member Cluster
Uses Local ASM
YH12
Bethune 数据库智能诊断平台
Dell
zData
Mellanox高速网络互联世界
zData
z3 SQL审核优化软件
Flash Buffer Area
Default flash
LRU chain
Keep flash
LRU chain
Non Default
Buffer Pools
2 k
16 k
4k
32 k
Default Buffer Pools
RecycleKeep
8 k
Row Format
IN MEMORY AREA (Month)
In-Memory
Virtual Columns
In-Memory
JSON Format
IMCU
IMCU
IMCU
IMCU
IMCU
IMCU
IMCU
SMU
SMU
SMU
SMU
SMU
SMU
SMU
SMU
Metadata
系统全局区 (SGA)
Ofnn
Oracle File
Server
Background
Process Thread
CLnn
Cleanup
slave
process
CLMN
Cleaup
Main
Process
PMAN
Process
Manager
OCFn
ASM CF
Conneetion
Pool Process
LMFC
Lock Manager
Flash Cache
Process
IMR0
Instance
Membership
Recovery
Slave Process
PMON
Process
Monitor
RECO
Recoverer
Process
ENMO
Your Best
Choice
SMON
System
Monitor
Process
RMVn
ReMastering
slaves
CRn
CR-slaves
LREG
Listener
Registration
Process
Nnnn
Connection
Broker Process
LOCAL
DISKS
LOCAL TEMPPORY
TABLESPACE
Site 1
Redo
Log
Buffer
Redo
Log
Buffer
FAL
Fetch
Archive Log
DMON
Data Guard
Broker Monitor
Process
MRP
Managed
Recovery
Process
Server
Parameter
File
Root (CDB ROOT)
Oracle Supplied Common Users/Schemas/Objects
Customer Common Users
Root
SYSTEM
SYSAUX UNDO TEMP
sys
Public
CDBA
NEW PDB FILE
Multitenant
Archived
Redo
Log files
Instance
Far Sync
Physical
Standby
Database
Archive Log
Change Tracking File
DATAFILE1
Control
File
Data file
FASTSTART
TABLESPACE
SALES
TABLESPACE
Flashback
logs
Dump Files
NEW PDB FILE
PDB 3
SYSTEM
SYSAUX
+UNDO
TEMP
Application
Root
PDB 2 PDB n
PDB 1
2
4
Database
Member Cluster
Gl Only
Shard
Catalog
Shard Directors
Mgmt
Repository
(GIMR)
Service
Trace File
Analyzer
(TFA)
Service
Rapid Home
provisioning
(RHP)
Service
Additional
Optional
Services
ACFS
Services
ASM
Services
ASM
IO Services
SHARDSPACE Ｂ
SHARDSPACE Ａ
Standby
Redo
Logs
Redo
Log
Files
Archived
Redo
Log files
Cloud
3
4
Database
Member Cluster
Uses ASM IO
Services Of DSC
ASM DISKGROUP 1
ASM DISKGROUP 2
Hub Node 64
INSTANCE 2
Shared Pool
Buffer Cache
Java Pool
Large pool
Streams Pool
Shared IO Pool
LCK0LMONLMDLMS
In Memory Area
Column Format
Recovery
Buddy
Buffer
Redo
Log
Buffer
CTWR
Change
Tracking
Writer Process
FASTSTART
DATA
User
Process
Least Recently Used
(LRU) List
Cold
Checkpoint Queue
Low RBA order
Hot
ACMS
Atomic Control
File to Memory
Service Process
Remoted
Archived
Logs
RFS
Remote File
Server
Redo
Log
Files
Redo
Log
Buffer
ARCn
Archiver
Process
Remoted
Archived
Logs
FAL
Fetch
Archive Log
DMON
Data Guard
Broker Monitor
Process
RFS
Remote File
Server
MRP
Managed
Recovery
Process
ARCn
Archiver
Process
LGWR
LG00-99
Redo Log
Writer
Standby
Redo
Logs
LNS
Log Network
Server
LGWR
LG00-99
Redo Log
Writer
ARCn
Archiver
Process
TTnn
Redo Transport
Slave
Process
Redo log
ASH Buffers
In-memory Undo (IMU)
Result Cache
Reserved Pool
Private Redo Log Buffers
Data Dictionary Cache
Enqueues
Latches
MMNL
Manageability
Monitor Lite
Process
Flashback
Buffer
Server
Process
RVWR
Recovery
Writer
Process
Scan
Server
DBW0..Z
Database Writer
BW36..99
LGWR
LG00-99
Redo Log
Writer
RMAN
Process
DIAG
Diagnostic
Capture
Process
DWnn
Data Pump
Worker
Process
Recover Table
Server
Process
Extended RAC
ASM3
Third Site for Voting Disk
YH2
ZONE 数据库性能监控软件
Online Partition
Online Table Move
SAnn
SGA
Allocator
Quest NetVault 备份软件
此图基于Oracle Database 12c Architecture 重新设计而成，涵盖了Oracle 12c R2最核心的新特性，帮助技术爱好者更快掌握Oracle前沿技术。原图链接见：http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/poster/OUTPUT_poster/pdf/Database%20Architecture.pdf
SYSTEM
SYSAUX
+UNDO
TEMP
PDB 4
LMSn
Global Cache
Service
Proeess
评论0