Re: Calculating effects of increasing PCTUSED
Date: Fri, 5 Dec 2008 11:43:47 +1300
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.