Peoplesoft XML Publisher Guide

Friday 15 November 2013

How to check total number of Allowed connections in Oracle Database?

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