LOG_PARALLELISM
来源:互联网 发布:java format日期格式 编辑:程序博客网 时间:2024/05/16 07:28
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.
- LOG_PARALLELISM
- android 之解决同时播放2个音频的方法
- poj_2031Building a Space Station(最小生成树)
- FZU Problem 2102 Solve equation
- HadoopSourceAnalyse --- Mapreduce ApplicationMaster init&startup
- php判断浏览器类型
- LOG_PARALLELISM
- 初探EJS
- Java学习笔记:基础知识2
- GetStringUTFChars()函数导致的程序Crash
- JDK里的设计模式
- MySQL里主键与外键的关系
- dotConnect for Oracle数据设置编辑器的使用教程
- 在类模板的声明和定义中把.h与.cpp分离
- Creational patterns