Re: 9.2 - Parallel Query Not Working
From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 28 Feb 2008 11:38:32 -0800
Message-ID: <a9c093440802281138s1174e006tb96bbdbceb615f3f@mail.gmail.com>
Date: Thu, 28 Feb 2008 11:38:32 -0800
Message-ID: <a9c093440802281138s1174e006tb96bbdbceb615f3f@mail.gmail.com>
What does v$px_session show for DEGREE and REQ_DEGREE?
If you bounce the instance does it work?
What PQ parameters are set?
First I would determine if it is giving you the requested number of slaves. If it's not, then the fun starts :)
On 2/28/08, David Aldridge <david_at_david-aldridge.com> wrote:
> On a 9.2.0.6 database on Solarix 64, which is created every day from a
> magical SAN-based mirror process thing (excuse the tech talk), we alter a
> particular table to a default degree of parallelsim of 12. A process which
> performs a full scan of that table picks up the degree of 12 and completes
> in a couple of hours.
>
> Later in the day we can no longer prompt the instance to give any
> parallelism.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 28 2008 - 13:38:32 CST