cancel
Showing results for 
Search instead for 
Did you mean: 

Parameter event - to be set according to EWA report

Former Member
0 Kudos

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,

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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,

Former Member
0 Kudos

Hello,

Did you check the Notes -

Note 830576 - Parameter recommendations for Oracle 10g

Note 1227227 - SQL statement runs endlessly or times out (kkompr)

If you are already past the bug mentioned in the note, then you can remove the event.

Thanks

Former Member
0 Kudos

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

former_member188883
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

stefan_koehler
Active Contributor
0 Kudos

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