- 浏览: 981499 次
- 性别:
- 来自: 杭州
文章分类
最新评论
-
孤星119:
好熟悉的数据库字段啊, 上家公司做的项目每天都跟这些字段打招呼 ...
Oracle exp compress参数引起的空间浪费 -
itspace:
quxiaoyong 写道遇到个问题,网上一搜,全他妈这篇文章 ...
数据库连接错误ORA-28547 -
quxiaoyong:
遇到个问题,网上一搜,全他妈这篇文章。你转来转去的有意思吗?
数据库连接错误ORA-28547 -
hctech:
关于version count过高的问题,不知博主是否看过ey ...
某客户数据库性能诊断报告 -
itspace:
invalid 写道写的不错,我根据这个来安装,有点理解错误了 ...
AIX 配置vncserver
在ASM alert日志看到一段话
引用
Fri Mar 5 00:03:10 2010
Starting background process ASMB
ASMB started with pid=13, OS id=42068
Fri Mar 5 00:06:19 2010
NOTE: ASMB process exiting due to lack of ASM file activity
Starting background process ASMB
ASMB started with pid=13, OS id=42068
Fri Mar 5 00:06:19 2010
NOTE: ASMB process exiting due to lack of ASM file activity
于是初步研究了一下该进程的作用,以下摘录来自
http://www.dbasupport.com/oracle/ora10g/ASM01.shtml
引用
Every database instance that uses ASM for file storage will also need two new processes. The Rebalancer background process (RBAL) handles global opens of all ASM disks in the ASM Disk Groups, while the ASM Bridge process (ASMB) connects as a foreground process into the ASM instance when the regular database instance starts. ASMB facilitates communication between the ASM instance and the regular database, including handling physical file changes like data file creation and deletion.
ASMB exchanges messages between both servers for statistics update and instance health validation. These two processes are automatically started by the database instance when a new Oracle file type - for example, a tablespace's datafile -- is created on an ASM disk group. When an ASM instance mounts a disk group, it registers the disk group and connect string with Group Services. The database instance knows the name of the disk group, and can therefore use it to locate connect information for the correct ASM instance.
ASMB exchanges messages between both servers for statistics update and instance health validation. These two processes are automatically started by the database instance when a new Oracle file type - for example, a tablespace's datafile -- is created on an ASM disk group. When an ASM instance mounts a disk group, it registers the disk group and connect string with Group Services. The database instance knows the name of the disk group, and can therefore use it to locate connect information for the correct ASM instance.
附rdbms、asm instance的后台进程
引用
$ ps -ef|grep asmdb
oracle 7534 1 0 00:03:16 - 0:00 ora_rbal_asmdb
oracle 14186 1 0 00:44:53 - 0:00 ora_o000_asmdb
oracle 15268 1 0 00:03:12 - 0:00 ora_reco_asmdb
oracle 16016 1 0 00:03:12 - 0:02 ora_smon_asmdb
oracle 22202 1 0 00:03:12 - 0:01 ora_mmnl_asmdb
oracle 22492 1 0 00:03:12 - 0:03 ora_mmon_asmdb
oracle 23238 1 0 00:03:12 - 0:01 ora_ckpt_asmdb
oracle 26366 1 0 00:03:13 - 0:00 ora_s000_asmdb
oracle 26658 1 0 00:03:12 - 0:00 ora_d000_asmdb
oracle 30206 1 0 00:03:11 - 0:00 ora_dbw0_asmdb
oracle 30734 1 0 00:03:11 - 0:00 ora_mman_asmdb
oracle 35138 1 0 00:03:11 - 0:00 ora_psp0_asmdb
oracle 36398 1 0 00:03:36 - 0:00 ora_qmnc_asmdb
oracle 36646 1 0 00:03:11 - 0:00 ora_pmon_asmdb
oracle 38926 1 0 00:03:19 - 0:00 ora_o001_asmdb
oracle 40296 1 0 00:03:12 - 0:00 ora_lgwr_asmdb
oracle 41306 1 0 00:03:16 - 0:00 ora_asmb_asmdb
oracle 41814 1 0 00:03:12 - 0:05 ora_cjq0_asmdb
oracle 42628 21640 0 00:46:18 pts/2 0:00 grep asmdb
oracle 43624 1 0 00:03:46 - 0:00 ora_q001_asmdb
oracle 43864 1 0 00:03:46 - 0:00 ora_q000_asmdb
$ ps -ef|grep asm_
oracle 10868 1 0 23:47:53 - 0:00 asm_smon_+ASM
oracle 12690 1 0 23:47:53 - 0:00 asm_rbal_+ASM
oracle 15494 1 0 23:47:53 - 0:00 asm_dbw0_+ASM
oracle 17320 1 0 23:47:53 - 0:00 asm_gmon_+ASM
oracle 29354 1 0 23:47:52 - 0:00 asm_mman_+ASM
oracle 31422 1 0 23:47:52 - 0:00 asm_psp0_+ASM
oracle 31506 1 0 23:47:52 - 0:00 asm_pmon_+ASM
oracle 32776 1 0 23:47:53 - 0:00 asm_lgwr_+ASM
oracle 34576 1 0 23:47:53 - 0:00 asm_ckpt_+ASM
oracle 40514 1 0 00:03:10 - 0:00 asm_o000_+ASM
oracle 42630 21640 0 00:46:24 pts/2 0:00 grep asm_
oracle 7534 1 0 00:03:16 - 0:00 ora_rbal_asmdb
oracle 14186 1 0 00:44:53 - 0:00 ora_o000_asmdb
oracle 15268 1 0 00:03:12 - 0:00 ora_reco_asmdb
oracle 16016 1 0 00:03:12 - 0:02 ora_smon_asmdb
oracle 22202 1 0 00:03:12 - 0:01 ora_mmnl_asmdb
oracle 22492 1 0 00:03:12 - 0:03 ora_mmon_asmdb
oracle 23238 1 0 00:03:12 - 0:01 ora_ckpt_asmdb
oracle 26366 1 0 00:03:13 - 0:00 ora_s000_asmdb
oracle 26658 1 0 00:03:12 - 0:00 ora_d000_asmdb
oracle 30206 1 0 00:03:11 - 0:00 ora_dbw0_asmdb
oracle 30734 1 0 00:03:11 - 0:00 ora_mman_asmdb
oracle 35138 1 0 00:03:11 - 0:00 ora_psp0_asmdb
oracle 36398 1 0 00:03:36 - 0:00 ora_qmnc_asmdb
oracle 36646 1 0 00:03:11 - 0:00 ora_pmon_asmdb
oracle 38926 1 0 00:03:19 - 0:00 ora_o001_asmdb
oracle 40296 1 0 00:03:12 - 0:00 ora_lgwr_asmdb
oracle 41306 1 0 00:03:16 - 0:00 ora_asmb_asmdb
oracle 41814 1 0 00:03:12 - 0:05 ora_cjq0_asmdb
oracle 42628 21640 0 00:46:18 pts/2 0:00 grep asmdb
oracle 43624 1 0 00:03:46 - 0:00 ora_q001_asmdb
oracle 43864 1 0 00:03:46 - 0:00 ora_q000_asmdb
$ ps -ef|grep asm_
oracle 10868 1 0 23:47:53 - 0:00 asm_smon_+ASM
oracle 12690 1 0 23:47:53 - 0:00 asm_rbal_+ASM
oracle 15494 1 0 23:47:53 - 0:00 asm_dbw0_+ASM
oracle 17320 1 0 23:47:53 - 0:00 asm_gmon_+ASM
oracle 29354 1 0 23:47:52 - 0:00 asm_mman_+ASM
oracle 31422 1 0 23:47:52 - 0:00 asm_psp0_+ASM
oracle 31506 1 0 23:47:52 - 0:00 asm_pmon_+ASM
oracle 32776 1 0 23:47:53 - 0:00 asm_lgwr_+ASM
oracle 34576 1 0 23:47:53 - 0:00 asm_ckpt_+ASM
oracle 40514 1 0 00:03:10 - 0:00 asm_o000_+ASM
oracle 42630 21640 0 00:46:24 pts/2 0:00 grep asm_
以下简单介绍各个进程的作用
引用
ARBx These are the slave processes that do the rebalance activity (where x
is a number).
CKPT The CKPT process manages cross-instance calls (in RAC).
DBWR This process manages the SGA buffer cache in the ASM instance.
DBWR writes out dirty buffers (changed metadata buffers) from the ASM
buffer cache to disk.
GMON This process is responsible for managing the disk-level activities
(drop/offline) and advancing diskgroup compatibility.
KATE The Konductor or ASM Temporary Errands (KATE) process is used
to process disks online. This process runs in the ASM instance and is started
only when an offlined disk is onlined.
LGWR The LGWR process maintains the ASM Active Change Directory
(ACD) buffers from the ASM instance and flushes ACD change records to
disk.
MARK The Mark Allocation Unit (AU) for Resync Koordinator (MARK)
process coordinates the updates to the Staleness Registry when the disks go
offline. This process runs in the RDBMS instance and is started only when
disks go offline in ASM redundancy diskgroups.
PING The PING process measures network latency and has the same
functionality in RDBMS instances.
PMON This manages processes and process death in the ASM instance.
PSP0 This process spawner process is responsible for creating and
managing other Oracle processes.
PZ9x These processes are parallel slave processes (where x is a number),
used in fetching data on behalf of GV$ queries.
RBAL This opens all device files as part of discovery and coordinates the
rebalance activity.
SMON This process is the system monitor and also acts as a liaison to the
Cluster Synchronization Services (CSS) process (in Oracle Clusterware) for
node monitoring.
VKTM This process is used to maintain the fast timer and has the same
functionality in the RDBMS instances.
is a number).
CKPT The CKPT process manages cross-instance calls (in RAC).
DBWR This process manages the SGA buffer cache in the ASM instance.
DBWR writes out dirty buffers (changed metadata buffers) from the ASM
buffer cache to disk.
GMON This process is responsible for managing the disk-level activities
(drop/offline) and advancing diskgroup compatibility.
KATE The Konductor or ASM Temporary Errands (KATE) process is used
to process disks online. This process runs in the ASM instance and is started
only when an offlined disk is onlined.
LGWR The LGWR process maintains the ASM Active Change Directory
(ACD) buffers from the ASM instance and flushes ACD change records to
disk.
MARK The Mark Allocation Unit (AU) for Resync Koordinator (MARK)
process coordinates the updates to the Staleness Registry when the disks go
offline. This process runs in the RDBMS instance and is started only when
disks go offline in ASM redundancy diskgroups.
PING The PING process measures network latency and has the same
functionality in RDBMS instances.
PMON This manages processes and process death in the ASM instance.
PSP0 This process spawner process is responsible for creating and
managing other Oracle processes.
PZ9x These processes are parallel slave processes (where x is a number),
used in fetching data on behalf of GV$ queries.
RBAL This opens all device files as part of discovery and coordinates the
rebalance activity.
SMON This process is the system monitor and also acts as a liaison to the
Cluster Synchronization Services (CSS) process (in Oracle Clusterware) for
node monitoring.
VKTM This process is used to maintain the fast timer and has the same
functionality in the RDBMS instances.
发表评论
-
buffer cache 的内部结构
2020-03-18 14:21 584BUFFER CACHE作为数据块的 ... -
Oracle OMC介绍
2020-03-18 13:19 495Oracle管理云服务(OMC)的大数据平台,自动收集的企业 ... -
参加Oracle勒索病毒防范专题培训会议
2019-09-27 17:15 5312019年7月22日,受邀参加Oracle勒索病毒防范专题培训 ... -
记一次内存换IO的Oracle优化
2019-09-27 16:50 835某客户数据库从P595物理 ... -
如何定位Oracle SQL执行计划变化的原因
2019-07-03 14:49 1471性能优化最难的是能够 ... -
如何定位Oracle SQL执行计划变化的原因
2018-10-30 09:24 1185性能优化最难的是能够 ... -
数据库性能优化目标
2018-10-08 10:59 528从数据库性能优化的场 ... -
数据库无法打开的原因及解决办法
2018-10-05 20:45 2145数据库的启动是一个相当复杂的过程。比如,Oracle在启动之前 ... -
怎么样彻底删除数据库?
2018-09-18 11:10 608Oracle提供了drop database命令用来删除数据库 ... -
Oracle减少日志量的方法
2018-09-10 10:17 871LGWR进程将LOG BUFFER中的 ... -
如何快速关闭数据库
2018-09-09 13:14 1240“一朝被蛇咬,十年怕井绳”。在没被“蛇”咬之前,很多DBA喜欢 ... -
关于《如何落地智能化运维》PPT
2018-05-17 10:19 1137在DTCC 2018发表《如何落地智能化运维》演讲,主要内容如 ... -
记录在redhat5.8平台安装oracle11.2容易忽视的几个问题
2018-05-11 19:58 587问题一:ping不通问题 在虚拟机上安装好linux系统后, ... -
《Oracle DBA实战攻略》第一章
2018-05-11 10:42 952即日起,不定期更新《OracleDBA实战攻略》一书电子版,请 ... -
Oracle 12c新特性
2018-05-11 10:33 907查询所有pdb [oracle@gj4 ~]$ sqlplu ... -
关于修改memory_target的值后数据库无法启动的问题
2017-02-28 12:24 3990操作系统:RHEL6.5 数据库版本:11.2.0.4 ... -
10g rac安装error while loading shared libraries libpthread.so.0 问题
2017-02-28 12:22 70211g rac安装在二节点跑脚本一般会报此错误: 解决这个问 ... -
记一次Oracle会话共享模式故障处理过程
2017-02-27 19:16 805故障简述 XXX第八人民医院HIS数据库7月13日11点左右从 ... -
RESMGR:cpu quantum等待事件处理过程
2017-02-27 18:23 2654由于数据库上线过程中出现大量的RESMGR:cpu quant ... -
谈谈log file sync
2014-03-19 14:18 1776数据库中的log file sync等待事件指的是,当user ...
相关推荐
主要的后台进程包括ASMB、RBAL等。 #### 四、关键视图和参数 ##### 1. 视图 ASM提供了一系列动态性能视图(Dynamic Performance Views, DPVs),用于查询ASM实例的状态和性能信息。例如: - `V$ASM_DISKGROUP`: ...
#/etc/init.d/oracleasm configure 会有相应的提示,回答 oracle, dba, y, y 就可以了分别对应默认用户,默认组和确认信息。 ASM 是一种灵活的存储解决方案,可以提供高效的存储管理和高可用性。
Oracle ASM实例是数据库实例与ASM磁盘组之间的桥梁,它包括SGA(System Global Area)和后台进程。SGA主要包含Buffer Cache(缓冲区高速缓存)、Share Pool(共享池)、Large Pool(大池)等部分。Share Pool需要...
安装完成后,需要进行初始化配置,执行`/etc/init.d/oracleasm configure`命令。 使用ASMLib配置ASM时,数据库实例必须在ASM实例启动后启动,并且两者需保持同步运行,数据库实例关闭前ASM实例不能停止。这样可以...
ASM实例拥有特定的后台进程(如RBAL)来协调磁盘组的重新平衡,并有两个额外的后台进程(ASMB和RBAL)与数据库实例通信。数据库实例通过ASM实例来获取ASM文件的布局信息。 创建ASM实例通常通过运行Database ...
- **ASMB进程**:在每个数据库实例上运行,作为ASM实例和数据库实例之间的通信桥梁,通过CSS获取ASM实例连接,并保持两者之间的信息交换和心跳监控。 - **RBAL进程**:负责磁盘组的重新平衡活动,规划和协调数据分布...
例如,在Red Hat 4 Update 7上,使用的可能是`oracleasmlib-2.0.4-1.el4.i386.rpm`、`oracleasm-support-2.1.3-1.el4.i386.rpm`和`oracleasm-2.6.9-78.EL-2.0.5-1.el4.i686.rpm`等软件包。安装完成后,ASM实例就能...
使用ASM存储的数据库实例也有两个新进程,RBAL用于打开并写入磁盘组,而ASMB则作为与ASM实例通信的通道,获取和更新ASM磁盘组的信息。 ASM的体系结构还包括Group Services,它登记ASM实例管理的磁盘组信息和连接...
- **工具**:如oracleasm、dd、od等,用于配置、创建、查询和管理ASM磁盘设备。 #### INSTANCE - **后台进程**:ASM实例运行一系列后台进程,如ASMB(ASM Background Process)、RBAL(Rebalance Process)等,用于...
5. **ASMB**:与ASM实例的前端进程通信,检测实例健康,与CSS守护进程交互以获取文件区间映射信息,并提供I/O统计数据。 【CSS集群同步服务】 CSS(Cluster Synchronization Services)是Oracle集群的关键组件,...
- `oracleasm troubleshooting` **2. Device Discovery (设备发现)** - **定义:** 自动发现ASM可以使用的存储设备的过程。 - **工具:** - `/dev/oracleasm` - `/proc/partitions` - `dd` - `od` - `kfod`...
- **ASMB、ARB、GMON、KATE、MARK、RBAL**:这些后台进程负责ASM实例的各种功能,如资源平衡、故障检测和恢复等。 ### 监控与视图 - **V$ASM_OPERATION、V$ASM_DISKGROUP、V$ASM_DISK等视图**:提供了ASM实例运行...
ASM实例与数据库实例之间的通信通过ASMB进程进行,而RBAL进程则负责磁盘组的重新平衡活动。此外,ASM实例还有类似数据库实例的后台进程,如LGWR、SMON、PMON、DBWR和CKPT,以确保正常运行。 管理ASM实例包括创建ASM...
- **定位与管理**: ASM实例负责定位和管理ASM磁盘,而RDBMS实例通过ASMB进程与ASM实例交互,获取磁盘文件的相关信息。 - **会话建立**: ASMB进程借助服务器进程建立RDBMS实例与ASM实例之间的会话。 - **数据传输**: ...
ASM的主要概念包括磁盘组、ASM实例、磁盘和ASMB(ASM后台进程)。 5. **OMF(Oracle Managed Files)**:OMF是Oracle的一个特性,允许数据库自动管理数据文件、重做日志文件和控制文件的创建和位置。通过设置系统...
A、B和C选项都是不正确的,因为ASM_POWER_LIMIT参数直接影响的是ASM实例的重新平衡行为,而不涉及DBWR(数据库写入器)进程、ASMB(ASM背景)进程或DBWR_TO_SLAVES的数量。 以上就是关于OCP考试中回收站操作、增量...