on 11-23-2011 8:43 AM
Good day fellas,
I have a problem on my EWA report :
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
10411 trace name context forever, level 1
10629 trace name context forever, level 32
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
10191 trace name context forever, level 1
10753 trace name context forever, level 2
10191 trace name context forever, level 1
10091 trace name context forever, level 1
and a bit below:
The following table lists events we found to be activated in your system, but which should only be activated in special circumstances. Please check whether there are special reasons to set these events. If they are no longer needed, they should be removed.
Event
10091
How can I check these special circumstances and if this parameter is needed ?
Thanks in advance,
Hi Jordy,
You need to add the parameters mentioned in the EWA report in your initSID.ora file.
Additionally you can check the event parameter recommendation based on SAP note mentioned in the EWA report for database parameter tuning.
Apart from this nothing to be done for normal database tuning .
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi deepakkori.
The parameter is already defined in initSID.ora:
*.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, le
vel 1','10411 trace name context forever, level 1','10629 trace name context forever, level 32','14532 trace name context forever, level 1','38068 trace name context forever, le
vel 100','38085 trace name context forever, level 1','38087 trace name context forever, level 1','44951 trace name context forever, level 1024','10191 trace name context forever
, level 1','10753 trace name context forever, level 2','10191 trace name context forever, level 1','10091 trace name context forever, level 1'
and they do not recommned any SAP note. These are the only things recommended in EWA:
Parameter EVENT
To provide special functionality or control system behavior, Oracle has a number of events. These can be activated in the configuration file and/or dynamically in the server manager or sqlplus.
In general, these events and parameters should be activated on request only. When they are no longer needed, they should be removed. However, it might be necessary to activate some events during normal database operation.
The following table displays the values for the parameter "event" as
found in your system:
Parameter Current Value
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
10411 trace name context forever, level 1
10629 trace name context forever, level 32
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
10191 trace name context forever, level 1
10753 trace name context forever, level 2
10191 trace name context forever, level 1
10091 trace name context forever, level 1
The following table lists events we found to be activated in your system, but which should only be activated in special circumstances. Please check whether there are special reasons to set these events. If they are no longer needed, they should be removed.
Event
10091
So I am not sure, how to check if I should remove this 10091 or leave it there. What is that special case that this parameter needs to be present ?
Any idea ?
thanks in advance,
Hello,
First, thank you all for replying.
Second, I am on Oracle 10.2.0.5 that already contains patch 7188932, which means that I can remove the parameter.
Should I just remove from initSID.ora ?
*.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, le
vel 1','10411 trace name context forever, level 1','10629 trace name context forever, level 32','14532 trace name context forever, level 1','38068 trace name context forever, le
vel 100','38085 trace name context forever, level 1','38087 trace name context forever, level 1','44951 trace name context forever, level 1024','10191 trace name context forever
, level 1','10753 trace name context forever, level 2','10191 trace name context forever, level 1','10091 trace name context forever, level 1'
and than restart the DB ?
PS: Thanks Stephan also, you made me laugh with the way you think about EWA.
Unfortunatelly, the customer is checking it weekly.
Thank you all,
Jordan
Edited by: Jordy_tof on Nov 23, 2011 11:27 AM
Hi Jordy,
Refer SAP Note 1171650 - Automated Oracle DB parameter check
Run the script attached to this SAP note. Follow the instructions on how to run the script.
Output of this script is oracle parameter recommendations based on your current Oracle version . In your case its 10.2.0.5
If the parameter output says set particular parameter , then you need to add it in your initSID.ora
Incase there are no recommendation mentioned, ignore those parameters and keep it as it is in your initSID.ora file.
Hope this helps.
Regards,
Deepak Kori
Hello Jordy,
that EWA reports by SAP should be put in the category "useless and for the wastebasket". The EWA is not aware of any installed SBP or previous interim patches - so the suggestions are mostly garbage.
In your special case .... set this event only if you are running one of the following system states:
- 10.2.0.2 or 10.2.0.4 without fix 7188932
- UNIX 10.2.0.4 without SBP and without fix 7188932
- WIN 10.2.0.4.nP (n <= 6 and WIN 32bit) or 10.2.0.4.nP (n <= 8 and WIN 64bit)
Regards
Stefan
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 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.