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

时间：2010-09-15 来源：brjl

11gR2数据库 windows平台触发器导致产生大量的trc 文件，属于bug，补丁还没出来。说是oracle 12.1能解决。临时解决办法：写个计划任务，定期删除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
...