- 浏览: 25822 次
- 性别:
- 来自: 北京
最新评论
thanks dukope of itpub.
Consider Multiple Database Writer (DBWR) Processes or I/O Slaves
Configuring multiple database writer processes, or using I/O slaves, is useful when the transaction rates are high or when the buffer cache size is so large that a single DBWn process cannot keep up with the load.
DB_WRITER_PROCESSES
The DB_WRITER_PROCESSES initialization parameter lets you configure multiple database writer processes (from DBW0 to DBW9 and from DBWa to DBWj). Configuring multiple DBWR processes distributes the work required to identify buffers to be written, and it also distributes the I/O load over these processes. Multiple db writer processes are highly recommended for systems with multiple CPUs (at least one db writer for every 8 CPUs) or multiple processor groups (at least as many db writers as processor groups).
Based upon the number of CPUs and the number of processor groups, Oracle either selects an appropriate default setting for DB_WRITER_PROCESSES or adjusts a user-specified setting.
DBWR_IO_SLAVES
If it is not practical to use multiple DBWR processes, then Oracle provides a facility whereby the I/O load can be distributed over multiple slave processes. The DBWR process is the only process that scans the buffer cache LRU list for blocks to be written out. However, the I/O for those blocks is performed by the I/O slaves. The number of I/O slaves is determined by the parameter DBWR_IO_SLAVES.
DBWR_IO_SLAVES is intended for scenarios where you cannot use multiple DB_WRITER_PROCESSES (for example, where you have a single CPU). I/O slaves are also useful when asynchronous I/O is not available, because the multiple I/O slaves simulate nonblocking, asynchronous requests by freeing DBWR to continue identifying blocks in the cache to be written. Asynchronous I/O at the operating system level, if you have it, is generally preferred.
DBWR I/O slaves are allocated immediately following database open when the first I/O request is made. The DBWR continues to perform. all of the DBWR-related work, apart from performing I/O. I/O slaves simply perform. the I/O on behalf of DBWR. The writing of the batch is parallelized between the I/O slaves.
--------------------------------------------------------------------------------
Note:
Implementing DBWR_IO_SLAVES requires that extra shared memory be allocated for I/O buffers and request queues. Multiple DBWR processes cannot be used with I/O slaves. Configuring I/O slaves forces only one DBWR process to start.
--------------------------------------------------------------------------------
Choosing Between Multiple DBWR Processes and I/O Slaves
Configuring multiple DBWR processes benefits performance when a single DBWR process is unable to keep up with the required workload. However, before configuring multiple DBWR processes, check whether asynchronous I/O is available and configured on the system. If the system supports asynchronous I/O but it is not currently used, then enable asynchronous I/O to see if this alleviates the problem. If the system does not support asynchronous I/O, or if asynchronous I/O is already configured and there is still a DBWR bottleneck, then configure multiple DBWR processes.
--------------------------------------------------------------------------------
Note:
If asynchronous I/O is not available on your platform, then asynchronous I/O can be disabled by setting the DISK_ASYNCH_IO initialization parameter to FALSE.
--------------------------------------------------------------------------------
Using multiple DBWRs parallelizes the gathering and writing of buffers. Therefore, multiple DBWn processes should deliver more throughput than one DBWR process with the same number of I/O slaves. For this reason, the use of I/O slaves has been deprecated in favor of multiple DBWR processes. I/O slaves should only be used if multiple DBWR processes cannot be configured
发表评论
-
from string get number data using pl/sql or sql
2012-02-16 17:32 849declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 6761.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7491.netconfig 2./etc/sysconfig/n ... -
FAQS
2012-02-09 15:59 7061.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 760Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 6511.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7101.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11161.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5321.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6131.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 701When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 556A schema is a collection of dat ... -
MANAGE UNDOTABS
2011-12-19 17:15 6511.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4101.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7551.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5371. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6541.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 8671.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 623ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6071.utl_file_dir: indicate the di ...
相关推荐
ORA-01157: 无法标识/锁定数据文件 19 - 请参阅 DBWR 跟踪文件 ORA-01110: 数据文件 19: ''''C:\oracle\oradata\oradb\FYGL.ORA'' 这个提示文件部分根据每个人不同情况有点差别。 继续输入 SQL>alter database data...
http://blog.csdn.net/csucxcc/archive/2010/08/03/5784686.aspx
Display Builder Web运行时 ... DBWR1 , DBWR2 ,...:在起始页上建议的显示URL。 WHITELIST1 , WHITELIST2 ,...:允许显示的正则表达式。 当WHITELIST1条目时,将使用。 .* 。 将dbwr.war放在$
(6)后台进程 PMON,LCLN,RECO,SMON,DBWR,LGWR,CKPT,ARCH PMON 做程序的清洁工作,处理一些不正常退出的事件. SMON 做系统的清洁工作,执行系统出错后自动恢复工作. LCKN Oracle系统表级或行级加锁的进程. ...
回滚段是在磁盘上的一段空间,当一个事务开始的时候,会首先把变化前 的数据和变化后的数据先写入日志缓冲区,然后把变化前的数据写入...时候日志必须写入磁盘,而数据缓冲区中数据依赖于检查点的发生和DBWR 进程的活动
调整DBWR写进程 6 调整LGWR I/O 7 调整Dml_locks 8 调整Open_cursors 8 调整Data_links 8 调整系统进程数Processes 9 调整会话Sessions 9 调整事务transactions 9 调整Job数量 10 调整读取数据最大块数 10 设置lock_...
后台进程 PMON,LCLN,RECO,SMON,DBWR,LGWR,CKPT,ARCH PMON 做程序的清洁工作,处理一些不正常退出的事件. SMON 做系统的清洁工作,执行系统出错后自动恢复工作. LCKN Oracle系统表级或行级加锁的进程. RECO ...
包括用户session及后台进程如DBWR,LGWR,arcchiver等等。 V$SESSION中的常用列 V$SESSION是基础信息视图,用于找寻用户SID或SADDR。不过,它也有一些列会动态的变化,可用于检查用户。如例: SQL_HASH_VALUE,...
checkpoint是的一个内部事件,这个事件激活以后会触发数据库写进程(DBWR)将数据缓冲(DATA BUFFER CACHE)中的脏数据块写出到数据文件中。
Oracle9i初始化参数中文说明 Blank_trimming: 说明: 如果值为TRUE, 即使源长度比目标长度 (SQL92 兼容) 更长, 也允许分配数据。 值范围: TRUE | FALSE 默认值: FALSE serializable: 说明: 确定查询是否获取表级...
01-042-O-O-dba.mp4 02-042-1-O-日常工作.mp4 03-042-1-0-了解体系结构.mp4 03-042-1-1-user-process.mp4 ...03-042-1-12-bg-dbwr.mp4 03-042-1-13-bg-lgwr.mp4 03-042-1-14-bg-ckpt.mp4 03-042-1-16-bg-others.mp4
oracle体系结构 DBWR将数据缓冲区中所有修改过的缓冲块数据写到数据文件中,并使用LRU算法来保持缓冲区中的数据块为最近经常使用的,以减少I/O次数。该进程在启动实例时自动启动。
DBWR C. LGWR D. PMON 2.用来设置系统启动时重做日志缓冲区大小的初始化参数为 C A. SHARED_POOL_SIZE B. LARGE_POOL_SIZE C.LOG_SIZE D. DB_BLOCK_SIZE 3.下面哪一个不是数据库物理存储结构中的对象 D A. 数据文件...
Oracle server由例程和数据库两部分组成,例程是一组内存结构和后台进程的集合,内存结构包括数据...后台进程包括SMON,PMON,DBWR,CKPT,LGWR.ARCH等。数据库是一组OS文件的集合,由数据文件、控制文件和重做日志组成。
(3)DBWR:数据库写入程序 (4)LGWR:日志写入程序 (5)CKPT:检查点进程 (6)ARCH:归档日志 (7)RECO:恢复进程 (8)SNPn:快照进程 (9)LCKn:锁定进程 (10)Dnnn:调度程序进程 (11)Snnn:服务器进程 (12)Pnnn:并行查询...
3、DBWR (数据库写入程序)负责管理数据块缓存区及字典缓存区的内容以批方式把修改块从SGA写入到数据文件 4、LGWR (日志写入程序) 把重做日志缓冲区的内容写入重做日志文件 5、ARCH (检查点进程) 用来减少执行...
§3.4.8 读数据块数(DB_FILE_MULTIBLOCK_READ_COUNT) 73 §3.4.9 数据文件的数目(DB_FILES) 73 §3.4.10 全局数据库名(GLOBAL_NAMES) 74 §3.4.11 数据库实例名(INSTANCE_NAME) 74 §3.4.12 许可的最大会话...
1.DBWR (数据库写入进程) 21 2.LGWR(日志写入进程) 22 3.ARCH(归档进程)-可选进程 22 4.CKPT(检查点进程)-可选进程 22 5.SMON (系统监控进程) 22 6.PMON (进程监控进程) 22 7.RECO (恢复进程) 22 8. Dnnn ...
1.DBWR (数据库写入进程) 21 2.LGWR(日志写入进程) 22 3.ARCH(归档进程)-可选进程 22 4.CKPT(检查点进程)-可选进程 22 5.SMON (系统监控进程) 22 6.PMON (进程监控进程) 22 7.RECO (恢复进程) 22 8. Dnnn ...
被修改的数据已由DBWR进程写入磁盘 b. SMON进程提交了对数据所做的修改 c. 事务所做的修改已由LGWR进程成功写入Redo Log 文件 d. PMON进程提交了对数据所做的修改 题目15、如果发生实例故障,何时会用到回退信息?...