Re: Help required on enabling traces for events

bhooshanprabhu_at_hotmail.com (Bhooshan) wrote in message news:<99f3c2af.0107250720.5eb2e205_at_posting.google.com>...
> Hello,
>
> We use Oracle 7.3.4 on HP-UX 10.2.
>
> We have following parameters in the init.ora of our database.
>
> event="10046 trace name context forever, level 12"
> event="1036 trace name errorstack level 10"
> event="2112 trace name errorstack level 10"
>
> We were facing some application cursor problems and hence Oracle
> support had asked us to enable tracing on events 1036 and 2112. I feel
> that setting trace to 1036 and 2112 is sufficient and setting of 10046
> event, is an alternate to setting traces for events individually? Is
> that so OR is it that setting of 10046 event is mandatory in case we
> need to enable tracing for any event? 10046 event dumps all SQL
> Access, binding variables etc. and quite bulky trace files are
> generated.

Well 10046 is basically SQL_TRACE with additional info. on bind variables and waits - so unless they want to look at all the sql on your system in great deatil it has nothing to do with the other 2 events which are diagnostic in nature.
>
> So, would it suffice to just have traces for events that are
> problematic OR is it necessary to have trace for event 10046 as well?
> Please respond.
>
> Regards
> Bhooshan
Received on Fri Jul 27 2001 - 18:09:40 CDT