Re: Calculating effects of increasing PCTUSED

  • From: "Tony Adolph" <tony.adolph.dba@xxxxxxxxx>
  • To: rjoralist@xxxxxxxxxxxxxxxxxxxxx
  • 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.

Rgds
Tony

Other related posts: