cancel
Showing results for 
Search instead for 
Did you mean: 

Set event 100183 & 10027 in Oracle 11g

Former Member
0 Kudos

Hi

I have upgraded the Oracle 10.2.0.4.0 to Oracle 11.2.0.2.0 . while running the script provided by SAP vide note no. 1171650 (Automated Oracle DB Parameter Check) , following recommendation comes after running the scripts

means change the event to values like 1or 2 or 1024 etc.

event (38087) change value to "38087" 1

event (10183) change value to "10183" 1

event (10027) change value to "10027" 2

event (10028) change value to "10028" 2

event (10142) change value to "10142" 2

event (38068) change value to "38068 level 100" 2

event (38085) change value to "38085" 2

event (44951) change value to "44951 level 1024" 2

event (10191) change value to "10191"

event (10995) change value to "10995 level 2"

when i executed the command on sqlplus / as sysdba level

ALTER SYSTEM SET EVENT=

'10027 trace name context forever, level 2',

'10028 trace name context forever, level 2',

'10191 trace name context forever, level 1',

'38087 trace name context forever, level 1',

'10183 trace name context forever, level 1',

'10142 trace name context forever, level 1',

'38068 trace name context forever, level 100',

'38085 trace name context forever, level 2',

'44951 trace name context forever, level 1024',

'10995 trace name context forever, level 2'

COMMENT='SAP RECOMMENDED SETTINGS - 201108' SCOPE=SPFILE;

thereafter i shutdown the oracle & restart it , it either comes instead of "change" to "add". It also don't give any error.

Can anybody be help in sort out that why these are happening. why it is not changing the values.

Thanks

Regards

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

Hello Ravi,

in addition to Gerd's reply - make sure that you have not set the event parameter for your specific <sid> in the past. If you don't specify the SID parameter - you will set the value of the global parameter (sid='*').

By the way - the check script of sapnote #1171650 is rubbish in my opinion - even the SAP support uses it, but does not look at the kind of system (OLTP / OLAP) and suggests parameter that are just wrong. I've known it to happen.

Regards

Stefan

0 Kudos

> By the way - the check script of sapnote #1171650 is rubbish in my opinion - even the SAP support uses it, but does not look at the kind of system (OLTP / OLAP) and suggests parameter that are just wrong. I've known it to happen.

Hi,

I think this will be the first time I do not agree with you.

probably you have not read the note.

the script cannot diferenciate between OLTP and OLAP, it expects that YOU tell him what typwe is and adjust the recommendations to that.

You can execute the relevant statement without adjustments for OLTP systems. For OLAP systems, you need to replace the string '<OLAP System? [n]>' with 'y'. Depending on the statement, the string may occur several times.

Of course, as it is "automatic" you haqve to understand the recommendations.

But i do really think that from that to say that it is rubbish there is a long way

stefan_koehler
Active Contributor
0 Kudos

Hi Fidel,

I think this will be the first time I do not agree with you.

No problem at all - otherwise it would be boring )

Well that's just my experience with this script - as you are from SAP you can check the service request "667733 / 2011" and go to the replies from "15.08.2011" - there you can see what i mean. Personally i never used this script, because of i think that i am able to set the correct parameters regarding the installed SBP.

Regards

Stefan

Answers (2)

Answers (2)

Former Member
0 Kudos

With 11.2.0.2 there is no 'trace name context forever' anymore.

Look at the readme file from the bundle patch:

ALTER SYSTEM SET EVENT=

'10027',

'10028',

'10142',

'10183',

'10191',

'10995 level 2',

'38068 level 100',

'38085',

'38087',

'44951 level 1024'

COMMENT='SAP_112021_201103 RECOMMENDED SETTINGS'

SCOPE=SPFILE;

Former Member
0 Kudos

Hi Gerd Kirchner

Thanks for your valuable support, but running this command . my Problem solved

Thanks a lot.

Regards

Ravi

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

When you set the event parameters then you have to include Previously set parameters as well in the command because this command simply overwrites previously set parameters as a result when you will restart the system it will show you previous set event parameter as missing. So, add new and old event parameter in one command and then check.

Thanks

Sunny

Former Member
0 Kudos

Hi Sunny

You are right that while adding new parameters , we have to keep in mind for old parameters recommenations also.

I am highly obligued that the support you have given to me.

Thanks

Regards

Ravi Arya