Hi All,
When using intra_partition for loades we get mixed results. Sometimes it takes 45 min and other times 5 hrs. The query plan changes all the time and without being ablt to provide hints we can't do anything.

Is there a way around this? We've stopped using it for loads but plan to try it for large index builds in the near future. Any advise?

Thanks,
Alyx

OOPS! Forgot we are using V8.1.4 64-bit on HP/UX 11i

What are you parms set too :

Degree of parallelism (DFT_DEGREE) =
Maximum query degree of parallelism (MAX_QUERYDEGREE) =
Enable intra-partition parallelism (INTRA_PARALLEL) =

You need to make sure you have atleast 1 cpu for each MAX_QUERYDEGREE,


One of the things we noticed on loads is, while writing it would wait when a bunch of procesess were doing loads at the same time, we now set it at

DFT_DEGREE = 1
MAX_QUERYDEGREE = 4
INTRA_PARALLEL = YES,

Our loads now go quicker and it will use more procesess to build indexes.

I am just testing.

again testing