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

Home -> Community -> Usenet -> c.d.o.server -> Oracle Parallel Query

Oracle Parallel Query

From: Oradba Linux <oradba_linux_at_verizon.net>
Date: Fri, 29 Dec 2006 14:57:46 GMT
Message-ID: <K1alh.11$SQ1.5@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 Received on Fri Dec 29 2006 - 08:57:46 CST

Original text of this message

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