Database Administration (MOSC)

MOSC Banner

Unable to change sessions parameter

edited Mar 12, 2009 8:57AM in Database Administration (MOSC) 5 commentsAnswered ✓
 My sessions parameter is defaulting to the value of processes * 1.1 + 5, regardless of the spfile setting.  the value is correct in v$spparameter, but incorrect in v$parameter.

From create pfile from spfile:
SID1.sessions=600
SID2.sessions=600
*.sessions=500


SQL>  select name||'  '||value from v$parameter where name in ('processes','sessions') ;

NAME||''||VALUE
--------------------------------------------------------------------------------
processes  650
sessions  720


SQL> select name||'  '||value from v$spparameter where name in ('processes','sessions') and sid='SID1' ;

NAME||''||VALUE
--------------------------------------------------------------------------------
processes  650
sessions  600

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center