on 01-11-2012 10:57 AM
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,
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.