Oracle 参数 UNIFORM_LOG_TIMESTAMP_FORMAT 官方解释，作用，如何配置最优化建议
本站中文解释
UNIFORM_LOG_TIMESTAMP_FORMAT参数可以让Oracle数据库在记录操作操作的日志时，使用统一的时间戳格式。此参数可以让用户设置想要的时间戳格式，使得在查看的时候更加方便。
设置此参数的步骤如下：
1. 使用SQL*Plus登陆到Oracle服务器。
2. 使用alter system命令设置UNIFORM_LOG_TIMESTAMP_FORMAT参数，例如：
alter system set UNIFORM_LOG_TIMESTAMP_FORMAT=’YYYY-MM-DD HH:MM:SS,FF3′ scope=spfile;
3.为新值生效，重启Oracle服务器，例如：
Shutdown immediate;
Startup;
官方英文解释
UNIFORM_LOG_TIMESTAMP_FORMAT specifies that a uniform timestamp format be used in Oracle Database trace (.trc) files and log files (such as the alert log).
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
Multiple instances should use the same value. |
When the value of UNIFORM_LOG_TIMESTAMP_FORMAT is TRUE, the format used for timestamps in trace files is standardized on universal time with millisecond precision. For example:
2012-09-26 00:16:47.154When the value of UNIFORM_LOG_TIMESTAMP_FORMAT is FALSE, trace files include a mix of timestamps using different precisions, with some timestamps showing local time and other timestamps showing universal time.
