Re: 9.2.0.4 update and event 10195

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Fri, 19 Sep 2003 13:02:05 +0200
Message-ID: <bkenne$5ut$1@news.fujitsu-siemens.com>

"Tanel Poder" <change_to_my_first_name_at_integrid.info> schrieb im Newsbeitrag news:3f698bed$1_1_at_news.estpak.ee...
> 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.

Exactly. I've got a test system and am upgrading that.

> 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;

I tried the alter system scope=spfile first but oracle complained so I did the init file method and recreated the spfile from that.

Thanks a lot!
Volker Received on Fri Sep 19 2003 - 06:02:05 CDT