Database Administration (MOSC)

MOSC Banner

View v$resource_limit has different session count compared to the view v$sessions

Hi

Oracle 19.16

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT

SQL> select count(1) from v$session;

 COUNT(1)
----------
    410

SQL> select count(1) from v$process;

 COUNT(1)
----------
    431

SQL> col resource_name for a20;
SQL> select resource_name, current_utilization from v$resource_limit where resource_name in ('processes', 'sessions') order by resource_name;

RESOURCE_NAME    CURRENT_UTILIZATION
-------------------- -------------------
processes              431
sessions               460

We can see that processes count match just fine, but sessions are way off. I am currently using v$session and v$process views for noncdb database sessions/process monitoring, and for the CDB databases, I use this view v$resource_limit view.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center