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)

2 Answers 2


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

  • It should be noted that this answer and the other one give different results, although both are supposedly showing the max sessions since instance startup (according to the Oracle docs). Anyone know why? Jun 21, 2021 at 11:35
  • 1
    @PaulRussell v$license includes user sessions only. v$resource_limit includes sessions of background processes too. Jun 21, 2021 at 11:40

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;

---------------- ------------------
              29                163

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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