Title: 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
Title: Why this sql is running in parallel ??
No,
tables are not partitioned
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001 12:11
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Why this sql is running in parallel ??
Title: Why this sql is running in parallel ??
Whoops, I
sent my earlier message too fast.
You've
already checked the degree on table
and
index. Hmmm... Puzzling...
I'm curious
to see the answer if you ever get one.
R. Matt Adams - GE Appliances -
[EMAIL PROTECTED] Give me an hour
What does v$pq_sysstat show? What does v$pq_sesstat show? (If session is
still connected).
- Kirti
-Original Message-
From: Gupta, Brijesh [SMTP:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Why this sql is
Title: Why this sql is running in parallel ??
select
from parameters where is_session_adjusted is TRUE. is there
anything?
-Original Message-From: Gupta, Brijesh
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001
12:51 PMTo: Multiple recipients of list ORACLE-LSubject:
Title: Why this sql is running in parallel ??
Have you
checked the column DEGREE in DBA_TABLES
for this
table?
R. Matt Adams - GE Appliances -
[EMAIL PROTECTED] 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
Title: 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
Title: Why this sql is running in parallel ??
What
is this parameter. I can't find in v$parameter.
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001 2:17
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Why this sql is running
So, it is clear that there is PQ in use here. Are you sure the query in
question is really using PQ servers?
Can you run that query again via another session? If so, please post
contents of v$pq_sesstat as seen right after the query ends.
Thanks.
- Kirti Deshpande
Verizon Information