This discussion is archived
3 Replies Latest reply: Jul 17, 2012 6:26 AM by Paul M. RSS

Sessions and Processes

947787 Newbie
Currently Being Moderated
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 ....?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points