RE: Why this sql is running in parallel ??

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Fri, 29 Jun 2001 09:17:19 -0700
Message-ID: <F001.0033DB73.20010629091114@fatcity.com>

<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 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 - 11:17:19 CDT