If performance degrades, for example, checkouts take longer than usual, you may need to adjust parameters in the init<Encyclopedia database name>.ora in the directory $ORACLE_HOME/dbs.
Alter the values for the following parameters:
The system guidelines for memory with 192MB and greater than 192MB are to set the DB_BLOCK_BUFFERS to 8000 and set the LOG_BUFFER to 1048576.
If you increase the LOG_BUFFER you may also need to increase the size and number of database log files.
|
Copyright © 2013 CA.
All rights reserved.
|
|