ITPub博客

首页 > Linux操作系统 > Linux操作系统 > LOG_PARALLELISM(转)

LOG_PARALLELISM(转)

原创 Linux操作系统 作者:tochar 时间:2007-07-26 00:00:00 0 删除 编辑

LOG_PARALLELISM

Parameter type

Integer

Default value

1

Parameter class

Static

Range of values

1 to 255

LOG_PARALLELISM specifies the level of concurrency for redo allocation within Oracle.

If you are using Oracle on high-end servers that have more than 16 processors, and you are experiencing very high contention on the redo allocation latch, then you should consider enabling parallel redo. This allows the parallel generation of redo and can increase the throughput of certain update-intensive workloads. You can examine the V$LATCH view to observe the cumulative wait times on the redo allocation latch.

To enable parallel redo, set the LOG_PARALLELISM parameter in the initialization parameter file to the desired level of concurrency for redo allocation. Oracle Corporation recommends setting LOG_PARALLELISM to a value between 2 and 8 when running on systems with 16 to 64 processors. You can start with a low value (such as 2) and increment it by 1 until you determine that the redo allocation latch is no longer contended, and that the parameter improves the performance of the application.

Setting LOG_PARALLELISM to values greater than 8 is not currently recommended.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9078678/viewspace-45101/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-11

  • 博文量
    118
  • 访问量
    790699