• 小知识:enable_ddl_logging参数的设置和日志位置变化


    业务部门需求,要协助客户DBA查truncate操作历史执行情况。

    首先确认数据库已开启enable_ddl_logging, 然后从alert中查找没有记录;
    之前11g版本都是记录到alert日志中,客户使用的19c数据库,怀疑19c有些变化,于是通过查询MOS

    • How to Enable and Monitor DDL Logging in 11g and 12c (Doc ID 2254010.1)

    可以看到相关说明:

    1. ENABLE_DDL_LOGGING is licensed under Oracle Change Management Pack and it is not offered as a standalone option.
    2. You can create an enhancement request, but it is already mentioned that it is part of Oracle Change Management Pack that needs to be purchased as a separate license.
    3. You can set the parameter to TRUE only if you purchased the license for the above mentioned package.
    4. In 11g we have this DDL Logging information under ADR HOME/alert directory only in XML format and Text Format information will be recorded in alert_.log file
    5. In 12c we have this DDL Logging information under ADR HOME/log/ddl_.log ( Text Format ) and ADR HOME/log/ddl/log.xml ( XML format ).

    果然12c以后就改变了ddl的记录位置到ADR HOME/log/ddl_<SID>.log,顺利找到后即可协助业务排查。

  • 相关阅读:
    position中的四种属性
    CSS中link和@import的区别
    隐藏对应元素的办法
    word20161217
    word20161216
    word20161215
    word20161214
    word20161213
    word201612012
    word20161211
  • 原文地址:https://www.cnblogs.com/jyzhao/p/16121294.html
Copyright © 2020-2023  润新知