DA Morgan wrote:
> Parallel DML
> ------------
> Parallel execution dramatically reduces response time for data-intensive
> operations on large databases typically associated with decision support
> systems and data warehouses. [deletia]
I would like to see to rephrased to "Parallel execution may reduce
response time" ; I have seen it actually increasing response time,
even when processing 10M row tables, due to excessive waits on PX
block sends. If that is a bug... I don't know.
10.1.0.4 on AIX 5L, 64 bit, 8 proc machine, 16GB, 4 CPU/8GB virtual
partition in use.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Fri Dec 23 2005 - 14:07:03 CST
