RE: Why this sql is running in parallel ??

What does v$pq_sysstat show? What does v$pq_sesstat show? (If session is still connected).

• Kirti

> -----Original Message-----
> From: Gupta, Brijesh [SMTP:Brijesh.Gupta_at_Airliquide.com]
> Sent: Friday, June 29, 2001 1:01 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Why this sql is running in parallel ??
>
> No, tables are not partitioned
>
> -----Original Message-----
> From: Mohan, Ross [mailto:MohanR_at_STARS-SMI.com]
> Sent: Friday, June 29, 2001 12:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Why this sql is running in parallel ??
>
>
> interesting.....something is off about the query data.....
>
> are the tables partitioned, by chance?
>
> -----Original Message-----
> From: Gupta, Brijesh [mailto:Brijesh.Gupta_at_Airliquide.com]
> Sent: Friday, June 29, 2001 12:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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.
> 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
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).