Re: 9.2.0.4 update and event 10195

Hi!

Depending whether you want to test the behaviour on your session only or system-wide you should choose setting the event session or system level. I believe that in your case of overall testing you should set it on system level.

"event" is an Oracle initialization parameter for setting events during startup, but "alter session/system set events" is a mechanism to set the event on running system.
If you do "alter session set events", then the event is set only to your session.
If you do "alter system set events", then the event is set only for all new sessions made into database, the existing sessions, including your own and existing background processes remain unaltered.

Since you want to keep this parameter permanently, I'd either put:

event="10195 trace name context forever, level 1" in your init.ora

or in case of spfile:

alter system set event="10195 trace name context forever, level 1" scope=spfile;

and bounce the instance.
(note that this alter system command is only for setting the init parameter in spfile, nothing else. Specifying scope=memory/both doesn't work here)

Tanel.

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:bka4be$nua$1_at_news.fujitsu-siemens.com...
> 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 Thu Sep 18 2003 - 05:41:48 CDT