Connection string


set heading off
set pagesize 0

SELECT
  'Currently, '
  || (SELECT COUNT(*) FROM V$SESSION)
  || ' out of '
  || VP.VALUE
  || ' connections are used.' AS USAGE_MESSAGE
FROM
  V$PARAMETER VP
WHERE 
  VP.NAME = 'sessions';

quit;
Advertisements