Re: Calculating effects of increasing PCTUSED

Is the table growing faster than expected due to parallel inserts using the
append hint? ... inserting 8 rows in parallel 8 append would create 8
extents.

It doesn't answer your performance testing question, just a thought.

Also you might want to think about using a merge statement instead.

Rgds
Tony

Other related posts: