Tuesday, October 15, 2013

Oracle: maximum number of allowed connections

Number of sessions allowed by DB:
SELECT name, value 
FROM v$parameter
WHERE name = 'sessions'
Number of opened sessions:
SELECT COUNT(*)
FROM v$session