Using Hint on a partitioned table

[dspxlearn]

Hi,

We are loading about 15-16 mill records in a Oracle table which is partitioned. As of now,we could have all the inserts/joins in less than 2 hrs. So, to increase the records inserts much faster, i am thinking of using a PARALLEL Hint during insert into the table.

But, i read somewhere that /*+PARALLEL/ hint lets us to specify the desired number of concurrent servers that can be used for a parallel operation.

So, my question is how this works on a prepartioned database table?

[chulett]

Basically the same way it does on a non-partitioned table. This is a conversation best had with your Friendly Neighborhood DBA Man. And it's not "concurrent servers" but rather threads.

[dspxlearn]

Thanks Craig.
I will have to speak to our DBA and post his comments here.

Just wanted to know for inserts into a partitioned table what would be the better possible Hint we can make use of?
From most of the few earlier posts, i see that many use /*+APPEND*/ hint. But, we have onlyinserts going every day into the table. So, i have used /*+PARALLEL*/. Please suggest.

[kcbland]

APPEND means add to the existing table without truncating. Your parallel hint isn't a hint. It's just telling Oracle that there could be another simultaneous load occuring against the same table.

If your concern is load performance, consider DIRECT path, partitioned tables, locally managed indexes, no bitmaps, deferred constraints.