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.

Details

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 on 

Published 25th October 2024