Oracle 参数 TRACEFILE_IDENTIFIER 官方解释，作用，如何配置最优化建议
本站中文解释
TRACEFILE_IDENTIFIER参数用于为数据库实例创建独立的跟踪文件，以区分不同的实例的跟踪文件，以及不同的崩溃模块的跟踪文件。
正确设置步骤：
1、确定数据库实例的唯一标识符。
2、在服务器上创建跟踪文件的目录，例如/u01/oracle/admin/test/udump。
3、连接到SYS数据库用户，并将TRACEFILE_IDENTIFIER参数设置为第一步确定的唯一标识符，例如：alter system set TRACEFILE_IDENTIFIER=’TEST’;。
4、将user_dump_dest参数设置为第二步创建的跟踪文件目录，例如：alter system set user_dump_dest=’/u01/oracle/admin/test/udump’;
5、重新启动实例，以使更改生效。
官方英文解释
TRACEFILE_IDENTIFIER specifies a custom identifier that becomes part of the Oracle Trace file name. Such a custom identifier is used to identify a trace file simply from its name and without having to open it or view its contents.
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
|
|
Default value |
There is no default value. |
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
Any characters that can occur as part of a file name on the customer platform |
|
Basic |
No |
Each time this parameter is dynamically modified, the next trace dump will be written to a trace file which has the new parameter value embedded in its name. Trace file continuity information is automatically added to both the old and new trace files to indicate that these trace files belong to the same process.
This parameter can only be used to change the name of the foreground process’ trace file; the background processes continue to have their trace files named in the regular format. For foreground processes, the TRACEID column of the V$PROCESS view contains the current value of the TRACEFILE_IDENTIFIER parameter. When this parameter value is set, the trace file name has the following format:
sid_ora_pid_traceid.trc
In this example, sid is the Oracle instance ID, pid is the process ID, and traceid is the value of the TRACEFILE_IDENTIFIER parameter.
See Also:
-
Oracle Database SQL Tuning
Guide for more information about this parameter -
This parameter is not supported on all operating systems. See your operating system-specific Oracle documentation for more information.
