Max Idle Blocker Time

Parameter Name

• MAX_IDLE_BLOCKER_TIME

Description

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.

Notes

• 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