11g 触发器导致生成大量trc文件-凯发app官方网站

this document is being delivered to you via oracle support's rapid visibility (rav) process and therefore has not been subject to an independent technical review.

applies to:

oracle server - enterprise edition - version: 11.2.0.1.0 and later [release: 11.2 and later ]
information in this document applies to any platform.

symptoms

you are seeing trace files with the following message:

--------dumping sorted master trigger list --------
trigger owner : own
trigger name : trg_xxx
--------dumping trigger sublists --------
trigger sublist 0 :
trigger sublist 1 :
trigger sublist 2 :
trigger sublist 3 :
trigger owner : own
trigger name : trg_xxx
trigger sublist 4 : dumping from triggers is fixed
...

cause

a lot of trace files keep generated,contain dumps for sorted master trigger

solution

1. move to oracle 12.1 where the bug is fixed.
or
2. install patch 9382101 if available for your db version and os platform.

references

- a lot of trace files keep generated,contain dumps for sorted master trigger

阅读(6136) | 评论(1) | 转发(0) |

上一篇：还是归档空间管理的问题又满了

下一篇：dbms_trace 内容

给主人留下些什么吧！~~

chinaunix网友2010-09-18 14:34:49

很好的, 收藏了推荐一个博客，提供很多免费软件编程电子书下载： http://free-ebooks.appspot.com

| | | | |

感谢所有关心和支持过chinaunix的朋友们