Re: Calculating effects of increasing PCTUSED
From: Tony Adolph <tony.adolph.dba_at_gmail.com>
Date: Fri, 5 Dec 2008 11:43:47 +1300
Message-ID: <4a38d9060812041443t2725e557y79533b1a13bd5a18@mail.gmail.com>
Date: Fri, 5 Dec 2008 11:43:47 +1300
Message-ID: <4a38d9060812041443t2725e557y79533b1a13bd5a18@mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 04 2008 - 16:43:47 CST