PRODUCT :
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
What is parallelism?
How it impacts on oracle Performance ?
How one can set the parallelism?
What are the Operations, That can be parallelized?
Operations That Can Be Parallelized
Oracle can parallelize operations that involve processing an entire table or an entire partition. These operations include:
SQL queries requiring at least one full table scan or queries involving an index range scan spanning multiple partitions.
Operations such as creating or rebuilding an index or rebuilding one or more partitions of an index.
Partition operations such as moving or splitting partitions
CREATE TABLE AS SELECT operations, if the SELECT involves
a full table or partition scan.
INSERT INTO . . . SELECT operations, if the SELECT involves a full table or partition scan.
Update and delete operations on partitioned tables
