Re: Parallel Query Processing

...of course you are running in cost based mode?

In article <1995Nov22.231730.21585_at_zeus.franklin.edu>, Dipankar <dasdipa_at_zeus.franklin.edu> wrote:
>Hi Oracle Gurus:
>
>We are trying to implement parallel query processing for some of the
>queries and index creation on a table having close to 1 million rows.
>
>We set up parallel_min_servers and para..._max_servers as 8 and 32
>respectively on a machine running 2 SMPs and having around 1G memory.
>Parallel_def..._max_scans is set to 4. We are running Oracle 7.1.4.1
>on AIX 4.11 with distributed and parallel options.
>
>Attempted to run OPQ (oracle parallel query) both by exclusively
>specifying parallel (TAB_NAME, 4) in the hints and also in the
>"create index ....... parallel (degree 4)" stmt. However, it does not use
>the parallel option. We also increased the degree to 8 but it didn't
>work. In either cases, v$pq_sysstat view displays #of servers idle as 8
>and remaining statistics are all 0.
>
>Does anybody have any experience running 7.1 parallel options and can throw
>any light on where is it going wrong?
>
>I would really appreciate if you can kindly email me your reply as I keep
>losing threads at times on our node.
>
>Thanks again,
>
>Dasdipa
>
Received on Thu Nov 23 1995 - 00:00:00 CET