| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Response to how to stop tracing
Hi, Jacques,
I can't say anything about your last argument setting to "context" or not. But I'm pretty sure your level 15 does not make any sense. The level for the event 10046 is as follows:
1 Standard SQL_TRACE functionality
4 As level 1 plus tracing of bind variables
8 As level 1 plus wait events
12 As level 1 plus bind variables and wait events.
I believe the level 12 is the highest for this event. I don't have Rama Velpuri's book right here but I've read his book more than once.
Yong Huang
yong321_at_yahoo.com
you wrote:
Rama Velpuri's book says "Usually, the LEVEL needs to be set betweeen 1 and 10. A value of 10 would mean to dump all the information for that event. ... Oracle Worldwide Customer Support would advise you on what the value of LEVEL should be." I chose 15 because a fellow employee told me "Use 15 for this event to get the most information."
 |
 |