RE: Calculating effects of increasing PCTUSED

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?

Thanks!
Rich

> 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


--
http://www.freelists.org/webpage/oracle-l


Other related posts: