Inactive Sessions In The Database (Doc ID 2636405.1)

Last updated on FEBRUARY 07, 2020

Applies to:

Goal

On : 2.3.0.2.0 version, Mobile Communications Platform

Inactive sessions in the database

using ORS version 2.3.0.2 and observed many database sessions are in Inactive status which were created almost a month back. These sessions are from the following users: SYS, CISUSER, PUBLIC, CISADM, DBSNMP (Maximum are from CISUSER).
need your help to tackle this as saw inactive sessions if not cleared causes issues in the application performance and normal way of working (for other applications like Siebel).

1) Why do the inactive sessions not get cleared out automatically?
2) For some sessions you see LAST_CALL_ET is not much so it was created in the past for example: 16th June but the LAST_CALL_ET value is '2' or '103'. Does this mean these sessions get Active as well.
3) Based on the application internal behaviour, can you please confirm if user can put an IDLE time setting for such sessions to terminate them from the database? Is there an ideal setting you recommend for ORS v2 application?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.