Thank you for the clarification, as usual this place has the most authentic answers so far.
We needed a clarification on below problem which has to do with processes and inactive processes vs killed.
select total, active, inactive, system, killed
from
(select count(*) total from v$session)
, (select count(*) system from v$session where username is null)
, (select count(*) active from v$session where status = 'ACTIVE' and username is not null)
, (select count(*) inactive from v$session where status = 'INACTIVE')
, (select count(*) killed from v$session where status = 'KILLED');
Above statement returns the below results.
TOTAL ACTIVE INACTIVE SYSTEM KILLED
1707 5 219 53 1430
As shown majority of the processes are killed however the MAX_UTILIZATION and the CURRENT_UTILIZATION values are as below.
SELECT RESOURCE_NAME, CURRENT_UTILIZATION, MAX_UTILIZATION, LIMIT_VALUE
FROM V$RESOURCE_LIMIT
WHERE RESOURCE_NAME IN ( 'sessions', 'processes');
processes 1902 2005 5500
sessions 1734 1944 8280
Our DB does not accept more processes when the limit is reached. Our question is how to get rid of the KILLED sessions which are occupying our resources?
Thank you in advance.