Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tables with heavy activity
Carlos Alberto wrote:
> Hi,
>
> I have 2 very small tables with heavy activity during all the day.
> Both of them have consistently a lot of INSERTīs and DELETEīs on them.
> I was wondering
> about PCTFREE, PCTUSED parameters. I think PCTFREE could be very low,
> and
> PCTUSED could be about 50/60, in order to avoid the continuous move of
> blocks
> on the free list. I was also wondering about put this tables in
> memory, is it worth?. What do you think about that?
>
> Thanks in advanced,
> Carlos
If what is happening is only inserts and deletes use 100% of the block: Who cares? The only reason to leave room free in a block is for updates.
Daniel Morgan Received on Thu Jun 27 2002 - 16:06:47 CDT