9.2.0.4 update and event 10195

Hi!
After the first issues got published for the 9.2.0.4 patch set I'd like to give it a try too.
However, one of the links in the known issues document ("Issues introduced in 9.2.0.4",
bug 3119025) wants me to "disable the use of CHECK constraints to generate additional
query predicatesby setting <EVENT:10195> to level 1." So, how do I do that properly?
In the docs there have been very few examples and the "event" init parameter is really
sparsely documented except for the hands off statement.

Most examples use alter session but shouldn't the event be set for all sessions?
So, do I do "alter system set event='10195 trace name context forever, level 1'"
or does "alter session set events '10195 trace name context forever, level 1'" alter
it permanently for all future sessions?
And what's this "set event='...'" vs. "set events '...'" stuff?

And how do I get rid of it? Even when Tom Kyte deals with event 10053 in his new
book there was nothing about getting rid of that event.

So, is there an "alter system unset events" or do I set the trace level to zero
or the event parameter to ''?

All in all I could not much information on this. Is it just well hidden or am I
missing something obvious?

Lots of Greetings and Thanks!
Volker Received on Wed Sep 17 2003 - 12:06:52 CDT