Idle Time Limits
Autonomous Database has predefined idle time limits for sessions so that idle sessions do not hold system resources for a long time.
A session may be terminated if it stays idle for more than five (5) minutes and the resources it consumes are needed by other users. This allows other active sessions to proceed without waiting for the idle session.
If you want sessions to be terminated after a certain amount of time,
independent of the consumed resources needed by other users, then set the
MAX_IDLE_TIME
initialization parameter. The
MAX_IDLE_TIME
parameter specifies the maximum
number of minutes that a session can be idle. After the specified amount of
time, MAX_IDLE_TIME
kills sessions.
Sessions that are idle for more than 48 hours are terminated whether they are holding resources or not.
See MAX_IDLE_TIME for more information.
Parent topic: Manage Concurrency and Priorities on Autonomous Database