Database Configuration Parameters

The use of Lawson applications can influence some Oracle configuration parameters, so it is a good idea to change the values of some parameters when you create your Oracle instance. The following is a portion of a sample init.ora file containing Oracle configuration parameters.

 rollback_segments= (r01,r02,r03,r04,r05,r06,r07,r08,r09,r10)

# tuning parameters

db_files = 300

db_file_multiblock_read_count = 32                  # LARGE

# db_block_buffers = 3200                           # LARGE
  db_block_buffers =  8000

# shared_pool_size = 9000000                        # LARGE
 shared_pool_size = 20000000

# processes = 200                                   # LARGE
processes = 800

dml_locks = 1000 
# dml_locks = 500                                   # LARGE

# log_buffer = 163840
log_buffer = 4096000

sequence_cache_entries = 100                        # LARGE

sequence_cache_hash_buckets = 89                    # LARGE

max_dump_file_size = 10240    # limit trace file size to 5 Meg each

cursor_space_for_time = TRUE
open_cursors = 500
log_simultaneous_copies = 20
use_async_io = TRUE

control_files = (/orahome/oracle/oradata/lawson/control01.ctl,
                 /orahome/oracle/oradata/lawson/control02.ctl,
                  /usr/oracle/oradata/lawson/control03.ctl)

db_block_size           = 4096
db_name                 = law1

The following table provides descriptions of the important Oracle configuration parameters. Keep in mind that these parameters require continuous monitoring and adjusting.

Oracle Configuration Parameter	Parameter Hints
rollback segments	Used to temporarily store "undo" information. Large batch jobs such as PR140 and PR199 might require larger than normal rollback segments to avoid "Snapshot too old" errors.
processes	The maximum number of operating system user processes that can simultaneously connect to an Oracle server. The number of interface processes accessing an Oracle database varies depending on the number of files opened by an application, the use of latm, and DrillArounds.
db_block_size	The size of one Oracle data block. This number should be an even multiple of the OS block size. It is set at database creation time and cannot be changed without recreating the database. Oracle recommends a size of at least 4K. Lawson frequently sets this higher.
dml_locks	This parameter represents the grand total of simultaneous locks on tables by all users. A moderate setting would be 200 to 400. The default value assumes an average of four tables referenced per transaction.
open_cursors	The maximum number of open cursors a session can have at one time. This parameter is application dependent. The default is generally too low because of Lawson's reliance on cursors for all data fetching. Lawson recommends setting this parameter to 800 or greater.
shared_pool_size	The size of the shared pool, which contains the library cache, dictionary cache, and control structures. Set this value large enough to prevent reparsing of Lawson SQL statements. The default value for a large database is not enough for even moderately sized systems.
optimizer_mode	Establishes the default behavior for choosing an optimization approach for the instance.
db_block_buffers	The number of buffers in the database buffer cache. Set this as large as possible, but within your memory restrictions.