Re: AW: What does trace event 38022? (Bug 6405967)

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 27 Mar 2009 10:52:11 +0100
Message-ID: <486b2b610903270252k66bfd93at1f59e2b767927323_at_mail.gmail.com>

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_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

---

On Fri, Mar 27, 2009 at 9:21 AM, Martin Klier <usn_at_usn-it.de> wrote:

> Hi Jan,
>
> Jan-Hendrik.Boll_at_dataport.de 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 27 2009 - 04:52:11 CDT