Have you
checked the column DEGREE in DBA_TABLES
for this
table?
----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
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">
<FONT face="Times New Roman"
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 - 13:14:05 CDT
