Jonathan Lewis wrote:
> "Oradba Linux" <oradba_linux_at_verizon.net> wrote in message
> news:K1alh.11$SQ1.5_at_trnddc03...
>> Is there a way to determine how oracle splits the Query? I have looked at
>> v$pq_tqstat after executing the query. It shows me information on
>> consumers,producers and how many each consumers processed. The question
>> that i have is, i have a function as a column in the select list and want
>> to know if the filter is happening for every row using the PQ slaves. I
>> want to make sure if this is happening because of performance.
>> I dont want all rows returned to QC and filter happens there which means
>> the QC executes the function for all the rows.
>>
>> 9206
>> 4 node RAC
>> RHLinux 2.4.21
>>
>>
>>
>>
>
> 9.2.0.6
>
> explain plan for ...
>
> select * from table(dbms_xplan.display)
>
> Check the "predicates" section of the report
> to see what filters are happening where.
>
> However if you have a function-call in the
> select list then that's not a filter. In 9.2.0.6
> the SQL being executed by the slaves is available
> in the 'other' column of the plan_table, which you
> can see through:
>
> select * from table(dbms_xplan.display(null,null,'ALL'));
>
>
Thanks Jonathan for your response.
Received on Fri Dec 29 2006 - 10:05:28 CST
