RE: Calculating effects of increasing PCTUSED

  • From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 3 Dec 2008 11:58:30 -0600 (CST)

Hi Mathias,

I guess that shows how much I've used PCTUSED -- never!  But my original
question remains -- how do I test the effects of the deletes in order to
predict future performance?


> Hi Rich,
> on ASSM tablespace specification of PCTUSED and FREELISTS is ignored.
> HTH Mathias
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rich Jesse
> Sent: Wednesday, December 03, 2008 4:35 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Calculating effects of increasing PCTUSED
>> What I'm not sure of is how to test the performance impact of this
> change.
>> I had it in my head that I'd need to monitor the freelist size so I
>> can extrapolate performance impact for the next "x" months/years, but
>> I'm not sure how to find that.
> Sorry, the tablespace is ASSM, so I should have said "bitmap" instead of
> "freelist".  I guess I still (incorrectly) think of it terms of a
> freelist.
> Rich


Other related posts: