This page provides more detailed information about the new initialization parameter,
MAX_IDLE_BLOCKER_TIME, which is used to influence sessions behavior.
In Oracle Database 19c, you can specify an amount of time that a session can be idle, after which it is terminated. You can define the maximum session idle time, by setting:
MAX_IDLE_TIMEresource plan directive in seconds. The default is NULL, which implies unlimited.
MAX_IDLE_TIMEinitialization parameter in minutes. The default value of 0 indicates that there is no limit.
You can also specify a more stringent idle time limit that applies only to sessions that are idle consuming resources and therefore blocking other sessions, by setting the
MAX_IDLE_BLOCKER_TIME resource plan directive that indicates the maximum session idle time of a blocking session. The default is NULL, which implies unlimited.
Oracle Database 21c allows you to set the
MAX_IDLE_BLOCKER_TIME initialization parameter to define the maximum session idle time of a blocking session, in minutes. The default value of 0 indicates that there is no limit.