This content has been marked as final. Show 3 replies
SESSIONS = (1.1 * PROCESSES) + 5That's 10g. 11g has different defaults. See http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams230.htm#REFRN10197 and http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams258.htm#REFRN10222 .
TRANSACTIONS = 1.1 * SESSIONS
Your values are perfectly normal.
Hi Paul M,
Many Many thanks for valuable information.....shall i alter my processes,sessions and Transactions?
shall i alter my processes,sessions and Transactions?If they are not sufficient, then yes. Increasing processes will be enough (the others are derived).
Remember that those parameters are static, so you'll have to restart your database.