EVENT parameter tuning in init(sid).ora

[Former Member]

Hi all,

our SAP version is 4.7 and oracle 9.2.0.7 ans OS is HP-UX .

In my sap system in init(sid).ora file contain below mentioned EVENT value.

1. EVENT ADDED 26/05/2006#############

event="10183 trace name context forever,level 1"

event="10191 trace name context forever,level 1"

event="10028 trace name context forever,level 1"

################################

Please give your valuable suggestions for recommended event values.

If I add a new event value can I delete old value?

If I will enter a wrong value in EVENT will it effect on database or any other?

Regards

Nani

[lbreddemann · Accepted solution]

HI Nani,

the recommended parameter settings (not only for the event parameter but for all) can be found in note:

<a href="http://service.sap.com/sap/support/notes/124361">#124361</a>

The event parameters are usually independet from each other.

If you enter a parameter wrong the result will depend on "how wrong".

Syntacticly wrong stuff will be ignored, non-existing events as well. If you specify wrong values for "level" then these will be active. What happens by this depends on the event name.

Hope that answers your question.

KR Lars

[Former Member · Accepted solution]

I want enter

EVENT = " event = 38068 trace name context forever, level 100 "

according to SAP note 176754.

1. what is the use of this event?can add this EVENT in init(sid).ora with using vi editor?

2.Is this suitable for SAP 4.7E and Oracle 9.2.0.7?How can I proceed?

Please explain

Regards

Nani

[lbreddemann · Accepted solution]

HI Nani,

the use of this event is explained within the note.

Under certain conditions it may happen that the CBO takes a wrong decision concerning the usage of indexes. This is sometimes due to a rule-based approach in a specific decision path for the optimizer.

To make the cbo able to use a cost-based approach for this decision path as well, one can set the event.

See point "18. In the following circumstances, the CBO does not use an index in spite of lower costs" in the note.

This option is usable from 9.2.0.7 onwards and does not depend on the SAP Version. So you can and should use it.

And of course. the init<sid>.ora file can be changed via VI.

KR Lars

[Former Member · Accepted solution]

Thank you very much for your suggestion Mr.Lars

So I can add this event parameter without any doubt and it will not effect bad.

but

1.What is about my previous existing event parameters?

2.Where can I find complete information about events?about if we use non suitable events what happend and how to decide suitable event parameters and who is main responsible person to edit these parameter(SAP or ORACLE person)?

Regards

Nani

[lbreddemann · Accepted solution]

> So I can add this event parameter without any doubt

> and it will not effect bad.

Yes, that's what SAP notes and recommendations for: safe and secure running your system.

> but

>

> 1.What is about my previous existing event

> parameters?

You can simply add a line just below your existing event-parameters. As I said: they are independent from each other.

But you should make sure that you have only the event parameters set that are recommended in the parameter note I mentioned.

> 2.Where can I find complete information about

> events?about if we use non suitable events what

> happend and how to decide suitable event parameters

> and who is main responsible person to edit these

> parameter(SAP or ORACLE person)?

There is no comprehensive documenation of event parameters. They are ORACLE INTERNAL parameters to change the behaviour of the database or to fix bugs.

They can change with every version of the oracle software. The responsible persons are the oracle developers at SAP that do make the recommendations and decide which events are to be set.

If you follow the SAP recommendations SAP is responsible for the outcome and will fix problems if they arise from the use of the recommendations. That's in your support deal.

KR Lars

[former_member204746]

if you add an event, make sure that they are all grouped together. if one of them is not grouped, it will not be used.

[Former Member]

Nani,

check oss note 596423 - Events & spfile.

You should be careful while changing events parameter values as it cannot be changed in the same way as other parameters.

Better you change it with sqlplus.