Inactive Sessions In The Database
(Doc ID 2636405.1)
Last updated on AUGUST 04, 2022
Applies to:
Oracle Real-Time Scheduler - Version 2.3.0.0.0 and laterOracle Utilities Mobile Workforce Management - Version 2.3.0.0.0 and later
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |