RE: Why this sql is running in parallel ??

Here is output of v$pq_sysstat.
 
 1* select * from v$pq_sysstat
CAdwDEV1>/
Press Enter to Continue ....

STATISTIC                              VALUE
------------------------------ -------------
Servers Busy                               4
Servers Idle                               1
Servers Highwater                          5
Server Sessions                            5
Servers Started                           98
Servers Shutdown                          93
Servers Cleaned Up                         0
Queries Initiated                         26
DML Initiated                              0
DFO Trees                                 26
Sessions Active                            1
Local Msgs Sent                         9319
Distr Msgs Sent                            0
Local Msgs Recv'd                   104,1095
Distr Msgs Recv'd                          0

15 rows selected.

-----Original Message-----
From: Deshpande, Kirti [mailto:kirti.deshpande_at_verizon.com] Sent: Friday, June 29, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L Subject: 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).