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