Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Set event 100183 & 10027 in Oracle 11g

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

Former Member
replied

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 View this answer in context
Not what you were looking for? View more on this topic or Ask a question