Home > DB_LEVEL > Sessions and Processes Parameters – Oracle 11g

Sessions and Processes Parameters – Oracle 11g

July 27, 2013

Oracle has changed the way it derives sessions and processes parameters in database.

In 10g, oracle used to derive sessions parameter from processes parameter using following formula

(1.1 * PROCESSES) + 5

In 11g R1 onwards it changed to

(1.5 * PROCESSES) + 22

It has another rule though:

If we set lower value of sessions parameters than derived value, Oracle will automatically bump it to above derived value.
If we set higher value of sessions parameters than derived value, Oracle will consider our set value

Advertisements
Categories: DB_LEVEL Tags:
%d bloggers like this: