Why this sql is running in parallel ??

From: Gupta, Brijesh <Brijesh.Gupta_at_Airliquide.com>
Date: Fri, 29 Jun 2001 08:59:53 -0700
Message-ID: <F001.0033DAF9.20010629085103@fatcity.com>

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.
Any ideas ?
    

SELECT T1.*
 FROM sd.INVOICE_ITEMS_ALL T1,sd.CP_CUSTOMERS T2, sd.ITEM T3
WHERE T1.CUSTOMER_NUMBER = T2.CUSTOMER_NUMBER (+)
  AND T1.PRODUCT_NUMBER = T3.PRODUCT_NUMBER (+)
  AND MONTH = 'APR1999'
  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 :

                                                                                       Lock

USERNAME     SID SERIAL# OSUSER   PROGRAM                    MACHINE          STATUS   wait LOGON_TIME
---------- ----- ------- -------- -------------------------- ---------------- -------- ---- --------

SD             8    4167 bernard. oracle_at_IBM-HOU-2 (P002)    US-AIRLIQUIDE\10 INACTIVE No   28-JUN-01
                         juchet                              WM801B                         16:32:37

              12    5030 bernard. oracle_at_IBM-HOU-2 (P003)    US-AIRLIQUIDE\10 INACTIVE No   28-JUN-01
                         juchet                              WM801B                         16:32:37

              15    1810 bernard. oracle_at_IBM-HOU-2 (P001)    US-AIRLIQUIDE\10 ACTIVE   No   28-JUN-01
                         juchet                              WM801B                         16:32:37

              19      74 bernard. C:\Documents and Settings\ US-AIRLIQUIDE\10 ACTIVE   No   28-JUN-01
                         juchet   bernard.juchet\Desktop     WM801B                         16:15:41

              14    4120 bernard. oracle_at_IBM-HOU-2 (P000)    US-AIRLIQUIDE\10 ACTIVE   No   28-JUN-01
                         juchet                              WM801B                         16:32:37

Thanks
Brijesh
Oracle DBA Received on Fri Jun 29 2001 - 10:59:53 CDT