11g 触发器导致生成大量trc文件

 

11gR2数据库 windows平台

触发器导致产生大量的trc 文件，属于bug，补丁还没出来，support上说是oracle 12.1能解决。

临时解决办法：写个bat脚本，放到计划任务中，定期删除trc文件和trm文件。

 

support.oracle.com中相关文档

Traces Generated With The Message 'Dumping Sorted Master Trigger List' [ID 1098363.1]
		Modified 11-MAY-2010     Type PROBLEM     Status MODERATED

In this Document
  Symptoms
  Cause
  Solution
  References

---

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