Below script gives the result of the number of allowed connections to the particular database.
SELECT
  'Current Connections, '
 
  || (SELECT COUNT(*) FROM V$SESSION)
  || ' out of ' 
  || VP.VALUE 
  || ' Connections.' AS USAGE_MESSAGE
FROM 
  V$PARAMETER VP
WHERE VP.NAME = 'sessions'
 
 
No comments:
Post a Comment