My Oracle Support Banner

Enquiries On Session Parameter (Doc ID 2681506.1)

Last updated on JUNE 18, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 20.1 Beta [Release 11.2 to 20.0]
Information in this document applies to any platform.

Goal

 After updating the parameter "processes" as 2000, the parameter "sessions" is updated itself as 3040.

To set the SESSIONS parameter as 3056 by 'alter system set sessions=3056 scope = spfile; '

However, the parameter become 3072 after restart

1. How to update the SESSIONS parameter with  preferred value?

2. Why the SESSIONS parameter will be updated as another value?

3. The session value 3056 is derived based on 2000 in 11g, why it derived as 3040 by itself?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.