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: Why this sql is running in parallel ??

RE: Why this sql is running in parallel ??

From: Gupta, Brijesh <Brijesh.Gupta_at_Airliquide.com>
Date: Fri, 29 Jun 2001 13:10:00 -0700
Message-ID: <F001.0033E135.20010629130220@fatcity.com>

What
is this parameter. I can't find in v$parameter.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Mohan, Ross   [mailto:MohanR_at_STARS-SMI.com]Sent: Friday, June 29, 2001 2:17   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   Why this sql is running in parallel ??   <FONT face=Arial color=#0000ff
  size=2>select from parameters where is_session_adjusted is TRUE. is there   anything?   

<FONT face=Tahoma

    size=2>-----Original Message-----From: Gupta, Brijesh     [mailto:Brijesh.Gupta_at_Airliquide.com]Sent: Friday, June 29, 2001     12:51 PMTo: Multiple recipients of list     ORACLE-LSubject: Why this sql is running in parallel     ??
    Hi All,   I have a query which
    is running parallel with degree 4. I don't want this     sql to run in parallel. My database is 8.1.6     optimizer_mode = CHOOSE     
    ALL tables are analyzed <FONT
    size=2>Tables and  index have degree =1 No hint     for the parallelism is specified in the query.     Then how is its running in parallel. <FONT     size=2>Any ideas ?          

    SELECT T1.*  FROM
    sd.INVOICE_ITEMS_ALL T1,sd.CP_CUSTOMERS T2, sd.ITEM T3 <FONT

    size=2>WHERE T1.CUSTOMER_NUMBER = T2.CUSTOMER_NUMBER (+) <FONT 
    size=2>  AND T1.PRODUCT_NUMBER = T3.PRODUCT_NUMBER (+) <FONT 
    size=2>  AND MONTH = 'APR1999'   AND 
    BUSINESS_UNIT IN ( 'CYLINDER','BULK','TONNAGE'  ) <FONT     size=2>  AND T2.CATEGORY_CODE IN ( 'Direct','Equity Distributor -     Consolida','Equity Distributor - Non-Conso','Independent     Distributor','Tonnage'  )
    Here is from v$session :
<FONT
    size=2>                                                                                       
    Lock USERNAME     SID SERIAL#
    OSUSER   
    PROGRAM                    
    MACHINE          
    STATUS   wait LOGON_TIME ---------- ----- 
    ------- -------- -------------------------- ---------------- -------- ---- 
Received on Fri Jun 29 2001 - 15:10:00 CDT

Original text of this message

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