Re: How to use event 10390?
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Sep 2004 01:39:39 +0300
Hi Janine,
But if you turn 10046 on your parent session, don't the slaves start to
generate trace as well?
They should, at least. Maybe you've deleted the PQ slave traces, but unix is
keeping them open & writing to deleted ones - that might be the reason why
you're not seeing any trace for PQ slaves.
Btw, v$sql_plan_statistics should be able to show quite detailed stats for
your PQ subqueries as well (but in production system it might give you
misleading results if queries are executed continuously).
Tanel.
----- Original Message -----
From: "Janine Sisk" <janine@xxxxxxxxxx>
To: <tanel.poder.003@xxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, September 15, 2004 11:15 PM
Subject: Re: How to use event 10390?
On Sep 15, 2004, at 4:00 PM, Tanel Põder wrote:
> But is this really what you want to know? Do you just want to see 10046
> trace for your slave processes?
What I want is to see an accurate trace of the query running with
parallel query turned on, so I can be sure that when I turn it off the
query is running at least as efficiently as it was before.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
