Hello DBA's,
I noticed that we have bunch of INACTIVE sessions on our DB. The oldest LOGON TIME of these sessions are aroud OCT 2014. LOGON TIME, PID's, SID and Serial# are not changing but the Client_Identifier and Module are constanly changing. We also observe “ORA-00020: maximum number of processes (%s) exceeded" on our Alert Log that appears every 3 days around the same time always. I used a query to check the max process/limit on DB and noticed that the time when the max vaule reached 99%, was the same time that the ORA-20 appeared.
Question:
1. Could This INACTIVE session be the reason why Im seing ORA-20 errors?
2. Since the LOGON TIME is way back OCT 2014, does it mean that the session are just being reused? Is that not good to the DB?
3. As observed, the ORA-20 appears always on the same time and as per our App team there's should be not activity in the system around this time. Could this mean that this is a bug?
4. Are this INACTIVE sessions not good for the DB?
I hope you could share some links (discussion,MOSC)regarding this, for sure there are many out there that I havent read yet.
Thanks So much!