DBWn 这个n是从0开始编号的？DBW0 DBW1 DBW2 ？

显示全部楼层 · 2010-3-1 11:20:00

DBWn 这个n是从0开始编号的？DBW0 DBW1 DBW2 ？
是不是表示同时有很多个DB写进程？

千问 · 2010-3-1 11:20:00

可以设置这个数值，查看你的配置DB_WRITER_PROCESSES，可以同是启动几个DBWR进程，不能超过限制20

千问 · 2010-3-1 11:20:00

select paddr,name,description from v$bgprocess
where name like '%DB%';

千问 · 2010-3-1 11:20:00

SQL> select paddr,name,description from v$bgprocess
2where name like '%DB%';
PADDRNAMEDESCRIPTION
-------- ----- ------------------------------------------
47E48AAC DBW0db writer process 0
00 DBW1db writer process 1
00 DBW2db writer process 2
00 DBW3db writer process 3
00 DBW4db writer process 4
00 DBW5db writer process 5
00 DBW6db writer process 6
00 DBW7db writer process 7
00 DBW8db writer process 8
00 DBW9db writer process 9
00 DBWadb writer process 10 (a)
PADDRNAMEDESCRIPTION
-------- ----- ------------------------------------------
00 DBWbdb writer process 11 (b)
00 DBWcdb writer process 12 (c)
00 DBWddb writer process 13 (d)
00 DBWedb writer process 14 (e)
00 DBWfdb writer process 15 (f)
00 DBWgdb writer process 16 (g)
00 DBWhdb writer process 17 (h)
00 DBWidb writer process 18 (i)
00 DBWjdb writer process 19 (j)
不懂

千问 · 2010-3-1 11:20:00

说明你的系统现在用的是DBW0呀。查询结果都这么清楚了。。