| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why this sql is running in parallel ??
What
is this parameter. I can't find in v$parameter.
<FONT face=Tahoma
size=2>-----Original Message-----From: Mohan, Ross
[mailto:MohanR_at_STARS-SMI.com]Sent: Friday, June 29, 2001 2:17
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Why this sql is running in parallel ??
<FONT face=Arial color=#0000ff
size=2>select from parameters where is_session_adjusted is TRUE. is there
anything?
<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 <FONT
size=2>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' )
size=2>
Lock USERNAME SID SERIAL#
OSUSER
PROGRAM
MACHINE
STATUS wait LOGON_TIME ---------- -----
------- -------- -------------------------- ---------------- -------- ----
 |
 |