RE: 10046 Tracing on Parallel Query

Hi=20

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_at_freelists.org =

[mailto:oracle-l-bounce_at_freelists.org] 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!
>
>--
>http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l