Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Parallel Insert into a Partitioned Table

536952May 31 2008 — edited Jun 1 2008
Hi,
I am trying to insert into a Partitioned Table using four Parallel SQLs which brings four different set of data and dump into the Target Table.

The Target table is List Partitioned based on one of its column.

I am using

ALTER SESSION enable PARALLEL DML

ALTER SESSION force parallel query parallel 2

and then the insert using below hint.

/*+ APPEND NOLOGGING parallel(table_name,2)*/


Each of the Four SQL uses the above hint and dump data into a specific partition of a table.Still i see that when i run all the four SQLs at one it takes more time to insert into the table as compared to the situation when i run one SQL.

My problem is that i am taking care of all the measures of Direct insert but still my four SQLs are NOT taking the same amount of time as it should take when one SQL is executed inspite of all four SQLs running in parallel..

Regards
Shrenik

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 29 2008
Added on May 31 2008
17 comments
6,588 views