Re: How to monitor table load?

Bear in mind that deleted rows do not immediately translate to space available for inserts. This only happens at a block level as the fill rate falls below the PCTUSED setting that is against each table or similar object. The other way is to export the table, drop or truncate the table, and import the data. this repacks the data to the level of PCTFREE in each block and resets the table High Water Mark HWM.

For information the PCTUSER by default is 40% which means that the data block will only start to refill after entries are deleted to the point where there is 60% or more space in the block.

I trust that is clear.

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)
                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document
are not necessarily those of BOCM PAULS Ltd.
Rajk Kaiser <Rajk.Kaiser_at_alcatel.de> wrote in message
news:3784534F.C1DD6D2C_at_alcatel.de...


> Hi,

>

> I've got to make sure there is always enough space in my db so that new


> entries can be inserted. How to do that best?

>

> Today I

>

> - analyze my table to get average row length and number of rows

> - then I compare avg_row_len*num_rows with initial_extend +

> (max_extends-1) * next_extend

> - when actual load is close to the maximum size I delete some entries

>

> But this apparently doesn't work. Oracle reports "max extends reached"

> (something like that) way before actual load is close to maximum load

> (~4GB). In fact it's only at about 60%.

>

> Any ideas, hints?

>

> Thanks in advance,

> Rajk

>

> --

>

> Rajk Kaiser Alcatel SEL AG Berlin

> Department VB/EFB

> phone:   +49 30 7002 3112 Colditzstrasse 34-36

> telefax:  +49 30 7002 3345 12099 Berlin

> e-mail:   Rajk.Kaiser_at_bln.sel.alcatel.de Germany