Oracle Database Discussions

Hi,

9.2 AIX5.3

Since I enabled parallel executions, and table monitoring there are performance issues while database (warehouse) is loaded (sqlldr) .

The LRUD root process gets active and maxes up the CPU to extend that performance is trashed.
The process is active even after all db activities are gone.

Is there something that could be done from db side to tune-accommodate the AIX behavior?

The only solution so far is to disable the parallel executions that I'm reluctant to do.

Thx,