0

I see in my 19c Cluster database a lot of sessions (over 350) with SYSRAC user and status INACTIVE with oraagent.bin TNS V1. They can consume my connection pool (how can I make this bigger number).

Why do I see so much those inactive connections and if this is realy so needed? Could this be some PL/SQL dbms monitoring metrics for the Oracle Cloud Control?

Kind regards.

0

These are internal, background processes connecting Oracle RAC Database with Oracle Grid Infrastructure High Availability Services. You can't control them. The status of "INACTIVE" can be misleading; it doesn't mean they don't have a purpose or aren't actually doing anything. Any background or user session will show as "INACTIVE" unless it is actually performing an operation that takes long enough to be recognized from one monitoring cycle to the next, at the exact moment you happen to query gv$session.

What "connection pool" are you trying to grow? These background processes should not count against most application-level pools or limits.

3
  • Hi.The issues is that I had to make a scheduler task to killl inactive session from sysrac (6 hours or more idle) because they made the database closed for other sessions, because the PGA processes limit was reached pretty soon. – ultimo_frogman Dec 18 '20 at 9:46
  • Have you opened a service request with Oracle Support? That many sessions (depending on the size of your RAC) could be a bug. – pmdba Dec 18 '20 at 11:28
  • Yes I did. I need to patch the complete stack , so I will use the fix as temp solution, to kill the idle sessions every 5 hours. – ultimo_frogman Dec 18 '20 at 12:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.