To Check Max Sessions Details
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';
(or)
SELECT STATUS , COUNT(*) FROM V$SESSION group by status;
No comments:
Post a Comment