Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
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
Bug 9382101 A LOT OF TRACE FILES KEEP GENERATED,CONTAIN DUMPS FOR SORTED MASTER TRIGGER
Solution
1. Apply Patch 9382101 if available for your DB version and OS platform.
- OR -
2. Upgrade to patch set 11.2.0.2
P.S: For windows Apply 11.2.0.1.0 Patch 4 (11.2.0.1.4P) or higher
For 32-Bit, apply Patch:9888297, For 64-Bit (x64), apply Patch:9888298
References
BUG:9382101 - A LOT OF TRACE FILES KEEP GENERATED,CONTAIN DUMPS FOR SORTED MASTER TRIGGER
NOTE:9382101.8 - Bug 9382101 - Unnecessary trigger traces "Dumping Sorted Master Trigger List"
