Re: Multi block rows eating space

From: Oliver Felix Fox <Oliver.Fox_at_Copenhagen.NCR.COM>
Date: 1998/02/16
Message-ID: <01bd24f9$7195a0d0$e62a4699@l174>#1/1

Hi,

Why do you believe that its not a PCTFREE and PCTUSED problem? Anyway, PCTUSED seems pretty low and that may easily be the reason that blocks are not (re)entered into the freelist(s). I would immediately try specifying higher PCTUSED, maybe 80-90, depending on the exact math of the rows and blocksizes (taking overhead like transaction entries into account).
This can be done dynamically, although it will take some time for the table to pulsate into equilibrium.

Regards

---

Oliver Felix Fox, International Oracle CoE NCR SE - Copenhagen
E-mail: Oliver.Fox_at_Copenhagen.ncr.com

SloanAndy <sloanandy_at_aol.com> wrote in article <19980115175100.MAA21321_at_ladder02.news.aol.com>...
> I've got some tables with nasty multi block rows (each taking three 2k
 blocks),
> which are gobbling space at a frightening rate, despite the number of
 rows
> being static.
>
> There are only around 3000 rows, however, there is about 250
 insert/deletes a
> day,
> and the tables grow by about half of these inserts. The database is
 7.1.6
> (soon to
> be 7.3.3).
>
> Oracle support have been their usual wonderful self and not helped much.
>
> I don't think it's a problem with pctfree and pctused ( 10 and 40).
>
> The developers can't help much and I can't reproduce the problem in a
 test
> environment.
>
> I will soon have 100's of these tables, and the headache of garbage
 collecting
> them.
>
> Help please, any ideas? The 7.3.3 upgrade may help but I don't want to
 reply
> on it without evidence.
>
> cheers Andy
>
Received on Mon Feb 16 1998 - 00:00:00 CST