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).

PropertyDescription

Parameter type

Boolean

Default value

true

Modifiable

ALTER SYSTEM

Modifiable in a PDB

No

Range of values

true | false

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.154

When 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.