TPT load NOPI working AMP number=Session number

Database
Enthusiast

TPT load NOPI working AMP number=Session number

Hi,

I have a question about TPT load NOPI table.

I can constate that when a TPT load NOPI table, the working AMP number=session number, which will make the CPU skew of every session almost 100%. Because for every session, there is only one participating AMP...

My question is for loading NOPI table, should we open more sessions than loading PI table? Ideally one session per AMP for having max participating AMPs?

And I don't know when loading PI table, is it also true that the working AMP number=session number?

Tks.

Mike

Tags (1)