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.