TO CHECK NO OF CONNECTION ACTIVE ON YOUR ORACLE DATABASE

TO CHECK NO OF CONNECTION ACTIVE ON YOUR ORACLE DATABASE

A simple join query will give you the total as well as the no of connection used on your database

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';



OUTPUT:
USAGE_MESSAGE                                                                                        --------------------------------------------------------------------------------------------
Currently, 41 out of 555 connections are used.