AnsweredAssumed Answered

Oracle inactive Sessions

Question asked by ahmad.b on Mar 27, 2013
Latest reply on Apr 1, 2013 by Dave
Hi,

This is first time use of this community. I need help with Oracle Inactive sessions being waiting on event Sql*Net Message From Client for hours and days.

To clear those sessions out I need to restart the BG (Background Engine) and sometimes the restart is not clearing all sessions out then I have to kill the Oracle Server Process of the sessions.

The long running sessions with the above Event can cause the BG to stale and the Heartbeats are not being synced.

Please shed some light.


Clarity 12.05
Oracle DB 11.1.0.7 64bit , RAC 3 nodes

Outcomes