[20210528]Oracle 19c Max_Idle_Blocker_Time Parameter.txt
[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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【PARAMETER】Oracle引數:MAX_IDLE_BLOCKER_TIME 解釋OracleBloC
- Oracle 19C EMOracle
- [20210528]oracle大表空間預分配問題.txtOracle
- Oracle 19c Broker配置Oracle
- oracle 19c dataguard silent install (oracle 19c dataguard 靜默安裝)Oracle
- oracle 19c 初體驗Oracle
- oracle 19c pdb遷移Oracle
- Oracle 19c Database Management ToolsOracleDatabase
- Oracle 19c的安裝Oracle
- Oracle資料泵(Oracle Data Pump) 19cOracle
- 【19c】Oracle 19c 和 20c 的新特性解密Oracle解密
- 1 Oracle Database 19c 新特性OracleDatabase
- Docker中安裝Oracle 19cDockerOracle
- oracle 19C 靜默安裝Oracle
- Oracle 19c RPM安裝Oracle
- Oracle 19c中的TomcatOracleTomcat
- Sqlcl 連線Oracle DataBase 19cSQLOracleDatabase
- oracle 19c CDB vs pdb 建立Oracle
- Oracle 19c 安裝嚐鮮Oracle
- LGnn 程式介紹(oracle 19c)GNNOracle
- Oracle 19c - 手動升級 Oracle 12.x, 18c CDB 到 Oracle 19c (19.x)Oracle
- Oracle:Oracle RAC 11.2.0.4 升級為 19cOracle
- Oracle 19c Concepts(13):Oracle Database InstanceOracleDatabase
- Oracle 19c Concepts(01):Introduction to Oracle DatabaseOracleDatabase
- Oracle Database 19c安裝Sample SchemasOracleDatabase
- Oracle 19c Concepts(10):TransactionsOracle
- Oracle 19c Concepts(07):SQLOracleSQL
- Oracle 19C 下載和安裝Oracle
- Oracle 19c RAC INS-40724Oracle
- oracle 19c 安裝、解除安裝Oracle
- Oracle 19C下載和安裝(二)Oracle
- Oracle 18C升級到19COracle
- Oracle Linux 7.1 silent install 19cOracleLinux
- Oracle 19c Concepts(05):Data IntegrityOracle
- Oracle Database 19c中的自動索引OracleDatabase索引
- Docker安裝Oracle 19c 詳細教程DockerOracle
- Oracle 19C DELETE_CATALOG_ROLE角色Oracledelete
- openPower伺服器安裝Oracle 19c伺服器Oracle