[20210528]Oracle 19c Max_Idle_Blocker_Time Parameter.txt

lfree發表於2021-06-02

[20210528]Oracle 19c Max_Idle_Blocker_Time Parameter.txt

This parameter differs from the MAX_IDLE_TIME parameter in that MAX_IDLE_TIME applies to all sessions (blocking and
non-blocking), whereas MAX_IDLE_BLOCKERG_TIME applies only to blocking sessions. Therefore, in order for
MAX_IDLE_BLOCKING_TIME to be effective, its limit must be less than the MAX_IDLE_TIME limit.

And the MAX_IDLE_TIME limit parameter is available from 12.2.0.1 version.

--//不知道是否有用,這樣可以不用解決問題,交給資料庫自己解決.做一個記錄.不過我感覺不好用。

> @ prxx
==============================
PORT_STRING                   : x86_64/Linux 2.4.xx
VERSION                       : 19.0.0.0.0
BANNER                        : Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
BANNER_FULL                   : Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.0.0.0
BANNER_LEGACY                 : Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
CON_ID                        : 0
PL/SQL procedure successfully completed.

> show parameter Max_IDLE_
NAME                                 TYPE        VALUE
------------------------------------ ----------- --------
max_idle_blocker_time                integer     0
max_idle_time                        integer     0


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-2775015/,如需轉載,請註明出處,否則將追究法律責任。

相關文章