RE: Why this sql is running in parallel ??

From: Adams, Matthew (GEA, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Fri, 29 Jun 2001 10:59:10 -0700
Message-ID: <F001.0033DD0A.20010629103204@fatcity.com>

Whoops, I
sent my earlier message too fast.
You've
already checked the degree on table
and
index.  Hmmm... Puzzling...
<SPAN
class=662592917-29062001> 
I'm curious
to see the answer if you ever get one.
 
----R. Matt Adams  - GE Appliances -
matt.adams_at_appl.ge.com    Give me an hour alone in  a

bank    Pay all my tickets, wipe the slate 
blank    Give me a car, fill up the 
tank    Tell me a boat full of lawyers just 
sank          - Robert 

Cray
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">        

<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 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 (+) 
        AND MONTH = 'APR1999' <FONT 
      size=2>  AND BUSINESS_UNIT IN ( 'CYLINDER','BULK','TONNAGE'  
      )   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:59:10 CDT