Jump to content

Session Parameter in RAC

Recommended Posts


Is session parameter database based or session based?

If I set my session parameter to 472 in 2 node RAC environment, what maximum connection can I have in each node?


Share this post

Link to post
Share on other sites

Hi Tim,

the sessions parameter relates to the

maximum  number of processes that can connect to a RAC node.

You never want to set sessions too low, because the instance will freeze, causing processing interruptions.

It is easy to change online:


Sessions = processes * 1.5

Here is now to see the number of connected sessions on a RAC node:


Good luck!

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now