RE: 10046 Tracing on Parallel Query
- From: Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Oct 2004 03:06:45 -0700 (PDT)
Hi Christian,
That's it - I was just looking in the wrong place. They were sitting in BDUMP
all along.
Thanks a lot!
- Charlotte
Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote:
Hi
Basically when the coordinator is in trace mode, the slaves are set in trace
mode as well.
Where did you look for the trace files? Since slaves are background processes
they generate their trace files under BDUMP and not UDUMP.
Chris
>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
>Behalf Of Charlotte
>Hammond
>Sent: 21 October 2004 11:43
>To: ORACLE-L
>Subject: 10046 Tracing on Parallel Query
>
>Hi all,
>
>I'm trying to run a 10046 trace on a parallel query. Using ALTER SESSION SET
>EVENTS, I only get
>the trace on the QC session (which just tells me it spends most of its time
>waiting for the slave
>sessions - um, secondary sessions if you're in California :-)
>
>So next run, I tried to manually trace the slaves using DBMS_SYSTEM.SET_EV
>(using the SID,SERIAL#
>for the slaves) after the query had started. But this still didn't produce any
>trace files.
>
>Any suggestions much apprectiated!
>
>Thanks
>- Charlotte
>
>---------------------------------
>Do you Yahoo!?
>vote.yahoo.com - Register online to vote today!
>
>--
>//www.freelists.org/webpage/oracle-l
---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
