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;

Comments

Popular posts from this blog

ORACLE BACKUP AND RECOVERY