EVENTS are not updated in SPfile.

74 Views

Hi,

I have changed the EVENTs using below command and create P file from SPfile and restarted the Database. but when i am checking using show parametr event it is not showing. please see the commands ,are they correct.

but in initSID.ora it is showing.

ALTER SYSTEM SET

EVENT="10027 trace name context forever, level 1",

"10028 trace name context forever, level 1",

"10949 trace name context forever, level 2",

"10162 trace name context forever, level 1",

"10183 trace name context forever, level 1",

"10191 trace name context forever, level 1",

"10629 trace name context forever, level 32",

"10091 trace name context forever, level 1",

"10891 trace name context forever, level 1",

"14532 trace name context forever, level 1",

"38085 trace name context forever, level 1",

"38068 trace name context forever, level 100",

"44951 trace name context forever, level 1024",

"38087 trace name context forever, level 1",

"10411 trace name context forever, level 1"

SCOPE=SPFILE;

create pfile from spfile;

Best Regards,

Avinash Ravut.