Is it safe to kill inactive session?
Hi,
Recently working on production environment I faced issue from client of login problem as follows
sqlplus user/password
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Feb 25 15:46:31 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-00020: maximum number of processes (%s) exceeded
After trying many times I logged in and found about 250 Inactive sessions of only one user in V$session view.
I have questions about this scenario.
1) I assume that inactive session consume processes, which triggered this error. Please correct me if I am wrong.
2) Is it safe to kill those inactive sessions without clients approval because as their status says they are 'INACTIVE'?
3) If no then, though inactive, do these sessions have some long running activities and because of their idleness oracle marks them as inactive?
Apologies for being naive.. :) thanks in advance..