Tuesday, October 15, 2013

Oracle: maximum number of allowed connections

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