not activated - alter system set event = '10411 trace name context forever,

[Former Member]

As per Note 830576 - Parameter recommendations for Oracle 10g have given the following comand

SQL> alter system set event = '10411 trace name context forever, level 1' scope = spfile;

System altered.

SQL> commit;

Commit complete.

Nothing have changed after issuing the command.

event (10411) add with value "10411 trace name context forever, level 1" A NO 10411 trace name context forever, level 1

Kindly tell me how to activate this

[markus_doehr2 · Accepted solution]

What did you expect to "change"?

Those events are used to force the system to do certain things on a specific way, use specific execution plans, circumventing bugs etc.

There is more than on event to be set. I use something like (10.2.0.2):

alter system set
event='10027 trace name context forever, level 1',
      '10028 trace name context forever, level 1',
      '10162 trace name context forever, level 1',
      '10183 trace name context forever, level 1',
      '10191 trace name context forever, level 1',
      '10629 trace name context forever, level 32',
	'10891 trace name context forever, level 1',
      '14532 trace name context forever, level 1',
      '38068 trace name context forever, level 100',
	'38087 trace name context forever, level 1'
scope=spfile;

Markus

[stefan_koehler]

Hello Vijay,

> SQL> alter system set event = '10411 trace name context forever, level 1' scope = spfile;

>

>Nothing have changed after issuing the command.

If you set values with the SCOPE=spfile, the new settings will only be available after a database restart.

And don't forget to use also the "old" events again by setting a new one, because of the old ones are lost. (take a look at the post of Markus for that)

Regards

Stefan