HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

Oracle how do I find out the max number of concurrent sessions?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thenumberhowmaxfindoracleconcurrentoutsessions

Problem

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)

Solution

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

Code Snippets

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

MAX_UTILIZATION
---------------
             94

Context

StackExchange Database Administrators Q#258275, answer score: 5

Revisions (0)

No revisions yet.