RE: Why this sql is running in parallel ??

From: Gupta, Brijesh <Brijesh.Gupta_at_Airliquide.com>
Date: Fri, 29 Jun 2001 10:11:10 -0700
Message-ID: <F001.0033DBEF.20010629100040@fatcity.com>

No,
tables are not partitioned

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Mohan, Ross   [mailto:MohanR_at_STARS-SMI.com]Sent: Friday, June 29, 2001 12:11   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   Why this sql is running in parallel ??   <FONT face=Arial color=#0000ff
  size=2>interesting.....something is off about the query   data.....
  <FONT face=Arial color=#0000ff
  size=2> 
  are
  the tables partitioned, by chance?   

<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 ---------- ----- 
    ------- -------- -------------------------- ---------------- -------- ---- 

• <FONT size=2>SD             8    4167 bernard. oracle_at_IBM-HOU-2 (P002)    US-AIRLIQUIDE\10 INACTIVE No   28-JUN-01 <FONT size=2>                         juchet                              WM801B                         16:32:37
  <FONT
  size=2>              12    5030 bernard. oracle_at_IBM-HOU-2 (P003)    US-AIRLIQUIDE\10 INACTIVE No   28-JUN-01 <FONT size=2>                         juchet                              WM801B                         16:32:37
  <FONT
  size=2>              15    1810 bernard. oracle_at_IBM-HOU-2 (P001)    US-AIRLIQUIDE\10 ACTIVE   No   28-JUN-01
  <FONT
  size=2>                         juchet                              WM801B                         16:32:37
  <FONT
  size=2>              19      74 bernard. C:\Documents and Settings\ US-AIRLIQUIDE\10 ACTIVE   No   28-JUN-01
  <FONT
  size=2>                         juchet   bernard.juchet\Desktop     WM801B                         16:15:41
  <FONT
  size=2>              14    4120 bernard. oracle_at_IBM-HOU-2 (P000)    US-AIRLIQUIDE\10 ACTIVE   No   28-JUN-01
  <FONT
  size=2>                         juchet                              WM801B                         16:32:37 Thanks Brijesh <FONT size=2>Oracle DBA

Received on Fri Jun 29 2001 - 12:11:10 CDT