Home > 11g > ALL PARAMETERS EXPLAINED

ALL PARAMETERS EXPLAINED

July 27, 2013

Derived Parameters: 

Some initialization parameters are derived, meaning that their values are calculated from the values of other parameters.

Operating System-Dependent Parameters:

The valid values or value ranges of some initialization parameters depend upon the host operating system.

 

Variable Parameters:

The variable initialization parameters offer the most potential for improving system performance.

PROCESSES:

PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes.
The default values of the SESSIONS and TRANSACTIONS parameters are derived from this parameter. Therefore, if you change the value of PROCESSES, you should evaluate whether to adjust the values of those derived parameters.

SESSIONS:

SESSIONS specifies the maximum number of sessions that can be created in the system. this is derieved parameter. i.e. no need to set this parameter manually, oracle automatically sets to

in 10g (1.1* processess)+5

in 11g(1.2* processess)+22

TRANSACTIONS:

TRANSACTIONS specifies how many rollback segments to online when UNDO_MANAGEMENT = MANUAL. The maximum number of concurrent transactions is now restricted by undo tablespace size (UNDO_MANAGEMENT = AUTO) or the number of online rollback segments (UNDO_MANAGEMENT = MANUAL).

Its default value is 1.1* sessions.

Advertisements
Categories: 11g
%d bloggers like this: