Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to use event 10390?

Re: How to use event 10390?

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Thu, 16 Sep 2004 01:39:39 +0300
Message-ID: <015f01c49b74$e2b104a0$1bfe9fd9@porgand>


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.

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
Received on Wed Sep 15 2004 - 17:35:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US