Re: Parallel Query Option W/Oracle7.1.4

>I am currently in the process of benchmarking the Parallel
>Query Option on our Sun1000 running Solaris 2.3 and I'm having
>a problem with the query server processes. I can see that the
>three query servers that I put in my init.ora file are indeed
>running, but when I execute a full table scan, the query
>servers are not being utilized. I altered the table in
>question to a degree of parallelism of three and I even place a
>hint in the select statement to use three query servers.

set the init params for max_default_scan_size=1 and max_default_degree=3 then alter tables for parallel (degree default). param names from my (foggy) memory, pls interpolate.

-- 
Dave Mausner, Sr. Consultant, Braun Technology Group, Chicago.