Re: Calculating effects of increasing PCTUSED

From: Tony Adolph <>
Date: Fri, 5 Dec 2008 11:43:47 +1300
Message-ID: <>

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.


Received on Thu Dec 04 2008 - 16:43:47 CST

Original text of this message