cancel
Showing results for 
Search instead for 
Did you mean: 

Event parameter - modification - help needed

Former Member
0 Kudos

Dear all,

Customer wants to modify the event and fixcontrol parameters.

I recently upgrade to 10.2.5.6 in Oracle.

I have the following:

EVENT:

10027 trace name context forever, level 1 10027 trace name context forever, level 1

10028 trace name context forever, level 1 10028 trace name context forever, level 1

10142 trace name context forever, level 1 10142 trace name context forever, level 1

10183 trace name context forever, level 1 10183 trace name context forever, level 1

10411 trace name context forever, level 1 10411 trace name context forever, level 1

10629 trace name context forever, level 32 10629 trace name context forever, level 32

14532 trace name context forever, level 1 14532 trace name context forever, level 1

38068 trace name context forever, level 100 38068 trace name context forever, level 100

38085 trace name context forever, level 1 38085 trace name context forever, level 1

38087 trace name context forever, level 1 38087 trace name context forever, level 1

44951 trace name context forever, level 1024 44951 trace name context forever, level 1024

10191 trace name context forever, level 1 10191 trace name context forever, level 1

-


and they want also 10753 trace name context forever, level 2 - proposed by SAP report.

Is it normal to have this 10753 added there ?

Should I only add it in the initSID.ora file ?

And also in FIXCONTROL, I need to deactivate: 9196440:ON , how can I deactivate it ? Set it like 9196440:OFF ?

Thanks in advance,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Daniel,

You can perform the changes in initSID.ora and startup the DB using Pfile and create SPfile from pfile.

When you check initSID.ora you will have a parameter event.You just need to add 10753 trace name in initSID.ora.

For parameter fix_control you need to deactivate it by using OFF 9196440:OFF

If you wish you can directly adjust this in SPFILE as well by using the below commands.

ALTER SYSTEM SET EVENT=' (put all the events in this bracket) 'SCOPE=SPFILE;

The command should look like this

ALTER SYSTEM SET EVENT='10027 trace name context forever, level 1','10028 trace name context forever, level 1','10142 trace name context forever, level 1','10183 trace name context forever, level 1','10191 trace name context forever, level 1','10411 trace name context forever, level 1','10629 trace name context forever, level 32','10753 trace name context forever, level 2','14532 trace name context forever, level 1','38068 trace name context forever, level 100','38085 trace name context forever, level 1','38087 trace name context forever, level 1','44951 trace name context forever, level 1024'SCOPE=SPFILE;

(above command is just a sample command .. please modify it before using on your Database)

For Fix_Control you can use this command

ALTER SYSTEM SET "_FIX_CONTROL"='4728348:OFF','5099019:ON','5705630:ON','5765456:3','6399597:ON','6430500:ON','6440977:ON','6626018:ON','6670551:ON','6972291:ON','7692248:ON','7891471:ON','9196440:ON','9495669:ON'SCOPE=SPFILE;

(above command is just a sample command..Please modify it before using on your Database)

Note : Make sure that you have a backup of initSID.ora and SPFILE before making any changes.

Regards,

Ershad Ahmed.

Former Member
0 Kudos

Erhsad,

Thanks for the complete answer, looks perfect.

But 1 question, Can I modify the parameters using : scope='both' and than restart the instance ?

In this case it will be written to both, pfile and spfile.

WOuld it be OK ?

Thanks in advance,

Dan.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Daniel,

Please download the sql script attached to the note:1171650.

Goto SE38 / SA38 and run RSORADJV

Paste the sql script in there and run.

You can see SAP recommended parameters. Address all the parameters that require changes.

Coming to your query regarding SAP proposed event parameter, please do so. It is Ok if SAP recommends.

If you are using pfile (init<SID>.ora) then, change it directly in the file and restart SAP and Oracle.

If you are using spfile, use alter system set parameter = ' '

You are right about the parameter fixcontrol. optimizer features can be enabled and disabled by on and off.

Br,

Venky

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

You can set this event parameter in init<sid>.ora or spfile. If this event parameter is suggested by SAP report then you can set this parameter. For more information, you can check SAP note 830576.

Also, in order to delete fix_control parameter then either you can delete/comment it from your init<sid>.ora file or use command line to delete it from spfile.

Please make sure that if you are setting event or fix_control parameter from command line then you have to set all event parameters again in one single command otherwise it will overwrite previous set event or fix_control parameters.

Thanks

Sunny