How to turn off parallel DML?
Environment:
OWB 10g Client on Windows XP Professional
Repository - 9.2.0.4 on UNIX (AIX)
Runtime - 9.2.0.4 on UNIX (AIX)
How do I turn off the parallel DML functionality?
I have set the DEGREE on the tables to '1' via the ALTER TABLE x NOPARALLEL statement but it still is using parallel processing.
The reason I want to turn it off is the incredible amount of wasted space being generated in my tables. By enabling parallel DML and letting the system default the DOP on my 4 processor server, I am seeing eight (8) extents being added to my tables during every load even if there are only a very small number of rows actually being added.
OWB is generating the APPEND PARALLEL hint to cause this action.
I have had to manually do an ALTER TABLE MOVE to reorganize the tablespace so I can then do an ALTER DATABASE DATAFILE x RESIZE to reduce the amount of disk space being used by the data warehouse.
Is anyone else having this same behavior and if so, how did you get around it?
Many thanks for your help.
Gary