Setting events in the database

Correct way of setting the event dynamically ( only after confirmation from support)

alter system set events ''event name

---- if using spfile ( show parameter pfile)

1) set the event dynamically as mentioned above
2) change the spfile

a) show parameter event
if there is no event set currectly

alter system set event=''event name" scope=spfile

if there is some event already set, we need to include that also

alter system set event=''event name1","event name2'' scope=spfile

confirm the setting in spfile

string -a | grep -i event

---- if using pfile


1) set the event dynamically as mentioned above
2) change the init ora file manually