ITPub博客

首页 > 数据库 > Oracle > trace_enabled 是否产生trace日志--按情况来关闭

trace_enabled 是否产生trace日志--按情况来关闭

原创 Oracle 作者:peng163fj 时间:2015-07-22 11:42:12 0 删除 编辑

TRACE_ENABLED

Property Description
Parameter type Boolean
Default value true
Modifiable ALTER SYSTEM
Range of values true | false
Real Application Clusters The default value is TRUE. Oracle recommends that multiple instances have the same value.

TRACE_ENABLED controls tracing of the execution history, or code path, of Oracle. Oracle Support Services uses this information for debugging.

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 in the event of unexplained instance failures.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/21302630/viewspace-1744274/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: CURSOR_SHARING
下一篇: segment advisor
请登录后发表评论 登录
全部评论

注册时间:2013-11-20

  • 博文量
    155
  • 访问量
    440169