Resource Kit Guide

10.4

Back Next

Oracle Configuration Parameters

To run the database performance test, prepare the Oracle database environment to be similar to the Informatica benchmark environment. Configure Oracle initialization parameters in the

INIT.ORA

file. You can compare the database performance test results with the benchmark environment only if the configuration of the two database environments are similar.

The following table describes the parameters to configure in the

INIT.ORA

file:

Parameter Name	Description
AUDIT_SYS_OPERATIONS	Enables or disables the auditing of operations issued by the SYS user. The Informatica benchmark environment was set to FALSE to disable the audit of operations. Default is FALSE .
AUDIT_TRAIL	Enables or disables database auditing. The Informatica benchmark environment was set to DB to enable auditing and direct audit records to the database audit trail. Default is NONE .
COMPATIBLE	Allows you to use a new version of Oracle, while guaranteeing backward compatibility with an earlier version. The Informatica benchmark environment was set to 11.2.0.0.0 . Default is 10.0.0 .
CONTROL_FILES	Specifies names of control files. The Informatica benchmark environment was set to D:\ORCL\CONTROL01.CTL, D:\ORCL\CONTROL02.CTL .
CPU_COUNT	Number of CPUs available to the Oracle instance. Set automatically by Oracle. The Informatica benchmark environment had 24 CPUs.
CURSOR_SHARING	Specifies the kind of SQL statements that can share the same cursors. The Informatica benchmark environment was set to EXACT to only allow identical statements to share the same cursor. Default is EXACT .
DB_BLOCK_CHECKING	Controls whether or not block checking is performed for database blocks. The Informatica benchmark environment was set to OFF . Default is OFF .
DB_BLOCK_SIZE	Specifies the size of database blocks in bytes. The Informatica benchmark environment was set to 8192 . Default is 8192 .
DB_FILE_MULTIBLOCK_READ_COUNT	Specifies the maximum number of blocks to read in one input/output operation. The Informatica benchmark environment was set to 128 .
DB_FILES	Specifies the maximum number of database files that can be opened for the database. The Informatica benchmark environment was set to 200 . Default is 200 .
DB_ULTRA_SAFE	Sets the default values for other parameters that control protection levels. The Informatica benchmark environment was set to OFF . Default is OFF .
DB_WRITER_PROCESSES	Specifies the number of background database writer processes to start. The Informatica benchmark environment was set to 3 . Default is 1 or <CPU Count>/8 , whichever is greater.
DBWR_IO_SLAVES	Specifies the number of input/output server processes used by the database writer process. The Informatica benchmark environment was set to 0 . Default is 0 .
DISK_ASYNCH_IO	Controls whether input/output to data files, control files, and log files is asynchronous. The Informatica benchmark environment was set to TRUE . Default is TRUE .
DISPATCHERS	Configures dispatcher processes. The Informatica benchmark environment was set to (PROTOCOL=TCP) (SERVICE=orclXDB) . Default is (PROTOCOL=TCP) .
FAST_START_PARALLEL_ROLLBACK	Specifies the degree of parallelism to use to recover terminated transactions. The Informatica benchmark environment was set to LOW . Default is LOW .
FILESYSTEMIO_OPTIONS	Specifies input/output operations for the file system files. The Informatica benchmark environment was set to SETALL .
GLOBAL_NAMES	Specifies whether a database link must have the same name as the database to which it connects. The Informatica benchmark environment was set to FALSE . Default is FALSE .
LOG_BUFFER	Specifies the redo circular buffer size in bytes. The Informatica benchmark environment was set to 53460992 . Default is 512000 .
LOG_CHECKPOINT_INTERVAL	Specifies the frequency of the redo log file blocks checkpoint interval. The Informatica benchmark environment was set to 0 . Default is 0 .
LOG_CHECKPOINT_TIMEOUT	Specifies the maximum time interval between checkpoints in seconds. The Informatica benchmark environment was set to 1800 . Default is 1800 .
MEMORY_MAX_TARGET	Specifies the maximum size for the memory target initialization parameter. The Informatica benchmark environment was set to 0 . Default is 0 .
MEMORY_TARGET	Specifies the target size of Oracle SGA and PGA memory. The Informatica benchmark environment was set to 0 . Default is 0 .
OPEN_CURSORS	Specifies the maximum number of open cursors in a session. The Informatica benchmark environment was set to 1000 . Default is 50 .
OPTIMIZER_DYNAMIC_SAMPLING	Controls the level of dynamic sampling that the optimizer performs. The Informatica benchmark environment was set to 2 . Default is 2 .
OPTIMIZER_FEATURES_ENABLE	Enables a series of optimizer features based on an Oracle release number. The Informatica benchmark environment was set to 11.2.0.3 . Default is 11.2.0.3 .
PARALLEL_MAX_SERVERS	Specifies the maximum number of parallel query servers for an instance. The Informatica benchmark environment was set to 960 .
PARALLEL_MIN_SERVERS	Specifies the minimum number of parallel query servers for the instance. The Informatica benchmark environment was set to 0 . Default is 0 .
PGA_AGGREGATE_TARGET	Specifies the target aggregate PGA memory available to the instance. The Informatica benchmark environment was set to 10737418240 . Default is 10 MB or 20% of the size of the SGA, whichever is greater.
PROCESSES	Specifies the maximum number of operating system user processes that can connect to Oracle. The Informatica benchmark environment was set to 1000 . Default is 100 .
RECYCLEBIN	Controls whether the dropped tables go into the recycle bin or not. The Informatica benchmark environment was set to OFF . Default is ON .
REMOTE_DEPENDENCIES_MODE	Specifies whether to run dependencies upon remote PL/SQL stored procedures based on time stamp or signature. The Informatica benchmark environment was set to TIMESTAMP . Default is TIMESTAMP .
RESOURCE_MANAGER_PLAN	Specifies the name of the top-level plan that the resource manager must load for an instance.
SESSION_CACHED_CURSORS	Specifies the number of cursors to cache in a session. The Informatica benchmark environment was set to 500 . Default is 50 .
SESSIONS	Specifies the maximum number of user and system sessions that can be created. The Informatica benchmark environment was set to 1536 . Default is a derived value equal to (1.1*PROCESSES)+5 .
SGA_TARGET	Specifies the target size of SGA. The Informatica benchmark environment was set to 32212254720 . Default is 0 .
STATISTICS_LEVEL	Specifies the statistics collection level for the database and operating system. The Informatica benchmark environment was set to ALL . Default is TYPICAL .
TIMED_OS_STATISTICS	Specifies the internal operating system statistic gathering interval in seconds. The Informatica benchmark environment was set to 60 . Default is 5 .
TIMED_STATISTICS	Specifies whether or not to collect statistics related to time. The Informatica benchmark environment was set to TRUE . Default is TRUE .
TRANSACTIONS	Specifies the maximum number of concurrent transactions. The Informatica benchmark environment was set to 500 . Default is a derived value equal to (1.1*SESSIONS) .
TRANSACTIONS_PER_ROLLBACK_SEGMENT	Specifies the number of concurrent transactions that each rollback segment can handle. The Informatica benchmark environment was set to 1 . Default is 5 .
UNDO_MANAGEMENT	Specifies the undo space management mode that the system must use. The Informatica benchmark environment was set to AUTO . Default is AUTO .
UNDO_RETENTION	Specifies the low threshold value of undo retention . The Informatica benchmark environment was set to 900 . Default is 900 .
WORKAREA_SIZE_POLICY	Controls the mode in which work areas are sized. The Informatica benchmark environment was set to AUTO . Default is AUTO .

Rename Saved Search

Table of Contents

Resource Kit Guide

Resource Kit Guide

Oracle Configuration Parameters

Oracle Configuration Parameters