Oracle 参数 TIMEZONE_VERSION_UPGRADE_ONLINE 官方解释，作用，如何配置最优化建议
本站中文解释
TIMEZONE_VERSION_UPGRADE_ONLINE参数可以定义在实例启动过程中，oracle数据库是否自动执行时区更新操作，该参数的值为TRUE或FALSE，默认值为TRUE。如果设置为TRUE，在实例启动或者任何之后时间的实例维护时，oracle将会更新数据库到新的时区版本，多数情况下建议设置为TRUE。
正确设置TIMEZONE_VERSION_UPGRADE_ONLINE参数：
1、首先在sqlplus会话环境使用sysdba权限登陆；
2、执行alter system set timezone_version_upgrade_online = true;命令设置timezone_version_upgrade_online参数为TRUE；
3、执行shutdown immediate; 命令关闭实例；
4、重新执行startup，让修改生效；
官方英文解释
TIMEZONE_VERSION_UPGRADE_ONLINE enables you to keep the database running in normal mode while upgrading time zone data using the DBMS_DST package.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
Multiple instances must have the same value. |
In releases prior to Oracle Database 21c, you were required to put the database in UPGRADE mode in order to initiate a time zone data upgrade using the DBMS_DST package. Starting with Oracle Database 21c, you can perform such an upgrade while the database is in normal mode by setting the value of TIMEZONE_VERSION_UPGRADE_ONLINE to true.
Note:
Setting the value of this parameter is only one step in a series of steps for upgrading your time zone data. Refer to Oracle Database
Globalization Support Guide for the complete set of steps before you set this parameter value.
