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 Wed Nov 22 1995 - 00:00:00 CET