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.