Details: MAX_IDLE_BLOCKER_TIME Parameter

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:

  • The MAX_IDLE_TIME resource plan directive in seconds. The default is NULL, which implies unlimited.

    
    SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (PLAN             => 'DAYTIME', -
                                                           GROUP_OR_SUBPLAN => 'REPORTING', -  
                                                           MGMT_P1          => 15, -
                                                           MAX_IDLE_LIMIT   => 600)
    
  • The MAX_IDLE_TIME initialization 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.