MAX_IDLE_BLOCKER_TIME Parameter

 

MAX_IDLE_BLOCKER_TIME

MAX_IDLE_BLOCKER_TIME specifies the maximum number of minutes that a blocking session can be idle. After that point, the session is automatically terminated. 

MAX_IDLE_TIME applies to all sessions (blocking and non-blocking)  MAX_IDLE_BLOCKING_TIME applies only to blocking sessions

DBA's often kill the blocking sessions and from 19c (not sure which patch set) we have new parameter called MAX_IDLE_BLOCKER_TIME parameter which helps to specifies the maximum number of minutes that a blocking session can be idle. After that point, the session is automatically terminated.

A session is considered to be a blocking session when it is holding resources required by other sessions. For example:

• The session is holding a lock required by another session.

Set the initialization parameter MAX_IDLE_BLOCKER_TIME to two minutes

 show parameter max_idle_blocker_time
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- -------------------
max_idle_blocker_time                integer     0
 
alter system set max_idle_blocker_time=2;
 

Nice feature Introduced from DB version 19.12 to 21C- if a session is idle, but it is blocking others, the database can automatically killed the idle session.

Ref Link-

max-idle-blocker_time