Oracle 参数 TRACE_ENABLED 官方解释，作用，如何配置最优化建议
本站中文解释
TRACE_ENABLED 参数控制系统全局的 SQL 跟踪活动的开关，默认值为true。
直接修改参数值：
SQL> ALTER SYSTEM SET TRACE_ENABLED=;
通过PFILE/SPFILE修改参数值：
如果系统使用PFILE，则在PFILE中添加如下内容：
trace_enabled =
如果系统使用SPFILE，则运行以下命令：
SQL> ALTER SYSTEM SET TRACE_ENABLED= SCOPE=SPFILE;
官方英文解释
TRACE_ENABLED controls tracing of the execution history, or code path, of Oracle. Oracle Support Services uses this information for debugging.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
The default value is |
When TRACE_ENABLED is set to true, Oracle records information in specific files when errors occur.
Oracle records this information for all instances, even if only one instance terminates. This allows Oracle to retain diagnostics for an entire cluster.
Although the overhead incurred from this processing is not excessive, you can improve performance by setting TRACE_ENABLED to false. You might do this, for example, to meet high-end benchmark requirements. However, if you leave this parameter set to false, you may lose valuable diagnostic information. Therefore, always set TRACE_ENABLED to true to trace system problems and to reduce diagnostic efforts when unexplained instance failures occur.
