Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inactive sessions

HeshMay 16 2019 — edited May 22 2019

Hi,

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Sometimes this is happening that INACTIVE sessions (600+) are not getting cleared in V$SESSION even after many hours!

What I have observed more is this is happening when the server get overloaded with sessions..

There is no IDLE_TIME is set as of now, not sure if that can help as if client application does not acknowledge ...then session will be there with SNIPPED status.

Regards

Hesh

This post has been answered by AndrewSayer on May 20 2019
Jump to Answer
Comments
Post Details
Added on May 16 2019
40 comments
12,829 views