OraFAQ Forum: Performance Tuning » alter system set events

Home » RDBMS Server » Performance Tuning » alter system set events (oracle10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

alter system set events [message #356761]

Sun, 02 November 2008 03:45

sasnrock
Messages: 19
Registered: August 2007

Junior Member

Hi,

Can someone send me the documentation of "alter system set events" and its parameters.

"alter system set events '10197 trace name context forever , level 1'; "

The above is set in our DB which has impacted the performance a lot as its skipping the indexes after setting this. I want to know how to switch this off ??

Report message to a moderator

Re: alter system set events [message #356765 is a reply to message #356761]

Sun, 02 November 2008 04:00

sasnrock
Messages: 19
Registered: August 2007

Junior Member

I tried
alter system set events '10197 trace name context off';

But still it would be great if someone can point to documentation related to this.

Report message to a moderator