Re: session and process

Posted by ErmanArslansOracleBlog on Jun 03, 2024; 10:00am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/session-and-process-tp12533p12536.html

Use DBA_HIST_ACTIVE_SESSION_HISTORY and  V$SESSION. Build your query against these..

If you try to find whether or not you are approaching the limits (like process limit) at any time , you can also use v$resource_limit and dba_hist_resource_limit.