Some events dont actually "trace" anything. They simply change certain functionality which is (usually) too "small" to be made into a full parameter, hence an event is used. Cheers ========================= Stefan P Knecht CEO & Founder s@xxxxxxxx 10046 Consulting GmbH Schwarzackerstrasse 29 CH-8304 Wallisellen Switzerland Phone +41-(0)8400-10046 Cell +41 (0) 79 571 36 27 info@xxxxxxxx http://www.10046.ch ========================= On Fri, Mar 27, 2009 at 9:21 AM, Martin Klier <usn@xxxxxxxxx> wrote: > Hi Jan, > > Jan-Hendrik.Boll@xxxxxxxxxxx schrieb: > > $ORACLE_HOME/rdbms/mesg/oraus.msg states event 38022 as the following: > > 38022, 00000, "CBO disable Distinct Sort Elimination at subquery > unnest" > Thanks for the link to the file, didn't know that it's there - it's a > great insight! > > > This looks like support wants you to enable on error-event tracing. > Mh, but the recommended it as a workaround until 10.2.0.5 is launched, > which fixes this bug. > > I want to avoid heavy trace files from today on, just to get correct > results. FYI, "_COMPLEX_VIEW_MERGING"=FALSE fixes my issue as well. > > Regards > Martin Klier > -- > Usn's IT Blog for Linux, Oracle, Asterisk > http://www.usn-it.de > > -- > //www.freelists.org/webpage/oracle-l > > >