Help required on enabling traces for events

From: Bhooshan <bhooshanprabhu_at_hotmail.com>
Date: 25 Jul 2001 08:20:03 -0700
Message-ID: <99f3c2af.0107250720.5eb2e205@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.

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 Wed Jul 25 2001 - 10:20:03 CDT