RE: 10046 Tracing on Parallel Query
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <charlottejanehammond@xxxxxxxxx>
- Date: Thu, 21 Oct 2004 11:59:30 +0200
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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
