LOG_PARALLELISM

最新推荐文章于 2023-05-26 16:12:46 发布

转载最新推荐文章于 2023-05-26 16:12:46 发布 · 781 阅读

oracle基础知识专栏收录该内容

33 篇文章

订阅专栏

本文介绍如何通过调整LOG_PARALLELISM参数来优化Oracle redo分配的并发级别，适用于高处理器端服务器，旨在减少redo分配锁的争用并提高更新密集型工作负载的吞吐量。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.