Oracle 参数 INSTANCE_ABORT_DELAY_TIME 官方解释，作用，如何配置最优化建议
本站中文解释
参数
INSTANCE_ABORT_DELAY_TIME参数，数据库即将宕机之前系统会等待多久的时间，这个参数是用于限制系统在强制宕机之前等待多长时间，单位为秒，Oracle在数据库宕机前会尝试回滚还未提交的事务，这个参数指定了Oracle应该等待多久去执行这个操作。一般默认的参数值为600，即10分钟，在终止实例之前，实例会限制自己的活动量，减慢实例的运行速度，花费更长的时间回滚事务。
此参数也可以在实例启动之后进行动态调整，可在参数文件和spfile中进行修改。如果采用spfile，可以使用“ALTER SYSTEM SET INSTANCE_ABORT_DELAY_TIME=secs”语句进行设置和修改，其中secs指定系统要等待多久回滚未提交的事务，secs为30-1800之间的整数。
官方英文解释
INSTANCE_ABORT_DELAY_TIME specifies how much time to delay an internal initiated instance abort (in seconds), such as when a fatal process dies or an unrecoverable instance error occurs.
| Property | Description |
|---|---|
|
Parameter type |
Integer |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
Different instances should use the same value. |
This parameter does not apply to a shutdown abort operation or any abort necessary to implement a user command.
Setting this parameter to a value greater than 0 enables a DBA to take some actions before an abort occurs due to a fatal error. Note that since the instance is in a fatal state, the DBA should not be too ambitious with the actions taken because some processes and/ or resources may be corrupted or unavailable, making complex actions impossible. Oracle does not guarantee what it is possible when an instance is in this state. A message is written to the alert log when the delayed abort is initiated. The value will not apply in the case of PMON death.
The larger the specified value, the longer the instance stays up, and the potential increases for other problems to occur. If you set this parameter, Oracle recommends setting it to a value between 0 and 60.
