Re: Intra-Partition Parallelism?

Rick Denoire wrote:
> Hello
>
> Supposedly, Oracle 9R2 is able to do parallel dml on non-partitioned
> tables. The term is "intra-partition parallelism".
>
> I could not find any detailed explanation of this feature in the
> Oracle documentation.
>
> I would like to know
> a) if it works automatically
> b) if not, how to enable it
> c) if yes, how to avoid it
> d) what are the trade-offs and pitfalls of using it
> e) if it can be used in a distributed environment (db-link)
> f) how can I confirm that it is being used
>
> Thanks
> Rick Denoire
>

Oracle can do parallel DML on non-partitioned tables, it can also do parallel DML on partitions of a partitioned table. Which one are you asking about?

One good way to determine if parallel DML is being used is the "explain plan" mechanism, available several ways such as TKPROF or Oracle Enterprise Manager (OEM).

Under Unix you can also look for various processes at the OS level (for example those including ora_xxx_P001, ora_xxx_P002) to confirm that parallel processing is taking place.

Trade-offs? Well of course each CPU can only run one process at any given instant, so I wouldn't bother trying to run 10 parallel processes on a two-CPU machine if you expect each one to be very busy... ;-)

--Mark Bole Received on Wed Feb 11 2004 - 20:46:51 CST