Max Idle Blocker Time

Parameter Name



MAX_IDLE_BLOCKER_TIME - Sets the maximum number of minutes that a blocking session can be idle. Once the limit is reached the is terminated.


  • A session is a blocking session when it is holding resources needed by other sessions. For example
      • The session is holding a lock needed by another session.
      • The session is a parallel operation reached its maximum parallel server limit or has queued parallel sessions.
      • A PDB or database instance is about to reach its SESSIONS or PROCESSES max setting.
      • It is possible to set the The MAX_IDLE_TIME parameter which applies to all sessions regardless of whether they are blocking. Make sure the MAX_IDLE_BLOCKING_TIME limit should be less than the MAX_IDLE_TIME limit.

Published 1st January 2022

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License