Oracle8i Reference Release 2 (8.1.6) Part Number A76961-01 |
|
Initialization Parameters, 31 of 188
Parameter type: |
Integer |
Parameter class: |
Static |
Default value: |
Derived: |
Range of values: |
1 to either ( |
|
|
Typically you should set this parameter to the number of CPUs or a multiple of that number. Each working set is handled entirely by one database writer (DBWn) process. Therefore, if multiple DBWn processes are running, the number of LRU latches should be greater than or equal to the number of DBWn processes. To balance the load evenly between the DBWn processes, the number of LRU latches in each buffer pool should be a multiple of the number of DBWn processes.
If you do not set this parameter, Oracle uses the value |
|
See Also: Oracle8i Designing and Tuning for Performance for more information on setting this parameter. |
|
![]() Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
|