Increasing Session and Process on Database
Increasing Session and Process on Database
session=1.5*process
implement the parameter changes :
Parameter Value old Value
sessions 500 335
processes 450 300
sqlnet.ora to include SQLNET.INBOUND_CONNECT_TIMEOUT=0 parameter. [The process will wait and there will be no connection time out]
Implementation Steps:
ALTER SYSTEM SET SESSIONS=500 SCOPE=BOTH;
ALTER SYSTEM SET PROCESSES=450 SCOPE=BOTH;
And We have to Bounce the database;
session=1.5*process
implement the parameter changes :
Parameter Value old Value
sessions 500 335
processes 450 300
sqlnet.ora to include SQLNET.INBOUND_CONNECT_TIMEOUT=0 parameter. [The process will wait and there will be no connection time out]
Implementation Steps:
ALTER SYSTEM SET SESSIONS=500 SCOPE=BOTH;
ALTER SYSTEM SET PROCESSES=450 SCOPE=BOTH;
And We have to Bounce the database;
Comments
Post a Comment
Welcome to the Oracle DBA Blog.
Stay Hungry Stay Foolish