The GET_DB_CONNECTIONS_COUNT function is used to get the current number of database user connections.
| Parameter | Description | |
|---|---|---|
| V_CONNECTIONS | Type: | RETURN |
| Datatype: | NUMBER | |
| Default Value: | None | |
| Description | The number of connections to the database excluding the current session. | |
Example
SELECT IN_DB_UTIL.GET_DB_CONNECTIONS_COUNT() AS NUMBER_OF_CONNECTIONS FROM DUAL;