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
- References:
- Calculating effects of increasing PCTUSED
- From: Rich Jesse
- Re: Calculating effects of increasing PCTUSED
- From: Rich Jesse
- RE: Calculating effects of increasing PCTUSED
- From: Mathias Zarick
- RE: Calculating effects of increasing PCTUSED
- From: Rich Jesse
- Calculating effects of increasing PCTUSED
Other related posts:
- » Calculating effects of increasing PCTUSED - Rich Jesse
- » Re: Calculating effects of increasing PCTUSED - Rich Jesse
- » RE: Calculating effects of increasing PCTUSED - Mathias Zarick
- » RE: Calculating effects of increasing PCTUSED - Rich Jesse
- » Re: Calculating effects of increasing PCTUSED - Tony Adolph