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@xxxxxxxxxxxxxxxxxx> 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 -- //www.freelists.org/webpage/oracle-l