I saw something similar after an upgrade from 8.0.5 to 8.1.7.2. In that case, the fix
was to explicitly alter table noparallel, and then back to whatever degree you want.
Afraid this is more than a couple of hours...
[EMAIL PROTECTED] 06/09/02 10:38AM
To: Multiple recipients of list
I have just upgraded my 8.0.4 database to 8.1.7.2.
Previously, parallel query would only run on objects that a DEGREE set 1.
I just checked and all of my tables and indexes have DEGREE set to 1.
So are most of my queries now running in parallel? I just checked my
init.ora file and I haven't
Here's my thinking -- it could be way off the mark...
As observed in the output from the 10053 trace, the CBO always considers not
only serial full table scans but also parallel full table scans. The big
question is exactly what degree of parallelism is it using in its
cogitations; I haven't
Tim,
Thanks for replying on a weekend.
After doing some reading, I discovered that parallel_threads_per_cpu is set
to the default of 2 on our database. With 8 CPUs, we are seeing 16
parallel threads on these queries, when they do go to parallel (a few of
them do not). I experimented with
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tim Gorman
Sent: Saturday, June 08, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Why is Parallel Query Running after upgrading to 8.1.7.2
Here's my thinking -- it could be way
PQ will not be used except degree was defined to a value 1 or set to
default. Hints also can trigger that.
I would simply get the execution plan for simple sql that access individual
tables and the check the plan table if it's serial or using PQO .
Waleed
-Original Message-
To: