Overview
Starting with Tools Release 9.2.26.0, Oracle database sessions are terminated when the session time exceeds the default threshold time. This frees up the database resources which can be utilized for subsequent database sessions.
To enable optimized session management on Oracle database, you must use the Server Manager Console to modify the Database, Kernel Recycling, and Workflow settings for the Enterprise server and Database settings for the HTML server.
Note: Optimized Session Management is only applicable to
Enterprise and HTML servers.
Important: Autonomous Database Serverless can
terminate the Oracle database sessions when the session
MAX_IDLE_TIME
exceeds the default threshold time of 24 hours.
For details, see Idle Time Limits in the Oracle Cloud
document Using Oracle Autonomous Database
Serverless.