3 Replies Latest reply: Jul 17, 2012 8:26 AM by Paul M. RSS

    Sessions and Processes

    947787
      Generally for Oracle 11g relation b/w processes and sessions is of ,

      SESSIONS = (1.1 * PROCESSES) + 5

      TRANSACTIONS = 1.1 * SESSIONS

      but for me default number of sessions , processes and Transactions are

      Processes---------150
      Sessions-----------248
      Transactions------270

      Here above values doesn't obey the mentioned relation.

      I got sessions exceeded exception in MyEclipse frequently, shall i alter the sessions by following the above mentioned relationship or any other solution ....?
        • 1. Re: Sessions and Processes
          Paul M.
          SESSIONS = (1.1 * PROCESSES) + 5

          TRANSACTIONS = 1.1 * SESSIONS
          That'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 .

          Your values are perfectly normal.
          • 2. Re: Sessions and Processes
            947787
            Hi Paul M,

            Many Many thanks for valuable information.....shall i alter my processes,sessions and Transactions?
            • 3. Re: Sessions and Processes
              Paul M.
              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.