3

I am creating an application with ASP.Net and I wanted to figure out how many users concurrently connect to our database. (the existing app is a Windows app and there is no way to get this information).

I am not looking for live data but what the max # of users had been at any point. If there is a way to specify a date range than that would be preferred.

Thank you

Right now we are using 11.x but will migrate to 12 (or higher)

5

The below returns the maximum number of concurrent sessions in the instance since it started, example:

SQL> select max_utilization from v$resource_limit where resource_name = 'sessions';

MAX_UTILIZATION
---------------
             94
3

You can also use the V$License view to check out the max sessions since the last startup.

SQL> select sessions_current,sessions_highwater From v$license;

SESSIONS_CURRENT SESSIONS_HIGHWATER
---------------- ------------------
              29                163

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.