Re: How to use event 10390?

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_at_furfly.net> To: <tanel.poder.003_at_mail.ee> Cc: <oracle-l_at_freelists.org> 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.

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