Home » RDBMS Server » Performance Tuning » alter system set events (oracle10g)
alter system set events [message #356761] Sun, 02 November 2008 03:45 Go to next message
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 ??
Re: alter system set events [message #356765 is a reply to message #356761] Sun, 02 November 2008 04:00 Go to previous messageGo to next message
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.

Re: alter system set events [message #356797 is a reply to message #356765] Sun, 02 November 2008 08:22 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Oracle event trace types
What is a database EVENT and how does one set it?
icon12.gif  Re: alter system set events [message #356810 is a reply to message #356797] Sun, 02 November 2008 10:15 Go to previous message
sasnrock
Messages: 19
Registered: August 2007
Junior Member
its really useful and good. thnk u
Previous Topic: Insert Oddly Alters Explain Plan
Next Topic: Packaged procedure tuning
Goto Forum:
  


Current Time: Fri Dec 02 13:55:12 CST 2016

Total time taken to generate the page: 0.05225 seconds