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?
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
