0
Oracle Database 12c Architecture
1448
1页
2次
墨值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
RM
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)
(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
Or
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
DW
Public ERP
SYS
PDB ERP
SYSTEM
SYSAUX
ERP
CDBA
EMP
SYS
SEED
PDB$
Public
SYSTEM
SYSAUX
sys
Public CDBA
Image Copies
Or
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
4k
21
21
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
SMU SMU
SMU SMU
SMU SMU
Metadata
IMCUIMCU
IMCU
IMCU
IMCU
IMCU
IMCUIMCU
Buffer Pools
Default
RecycleKeep
8 k
Column Format
Row Format
恩墨学院微信:enmoedu
云和恩墨微信:enmotech
支持ORA错误代码查询
of 1
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜
近期活动
全部
暂无活动,敬请期待...
相关课程
全部