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
Received on Fri Dec 29 2006 - 08:57:46 CST
