Session Limits on Oracle

Oracle manages the global(instant level) limit for concurrent session and can be configured to manage per-user session limit through profile

Global concurrent session limit

The SESSIONS of initialization parameter specifies the max. number of sessions that can be created in the system at the same time. The OPEN_CURSORS and SESSIONS specify the max. number of concurrent open cursors for the system.

• http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams191.htm#i1133629
• http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams138.htm#CHDFEAFG

Per-user concurrent session limit

Using profile, Oracle can be configured to manage resource limits to a specific user. The configurable resources include SESSIONS_PER_USER, CPU_PER_SESSION, CPU_PER_CALL, and so on.

• http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/authoriz.htm#i1009631
• http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6010.htm#i2065930