Re: Tables with heavy activity

If you are not doing any updates the the data you may want to set PCTFREE to say 5%.
I typically use the default for PCTUSED - 40. You may even want to set it even lower in this situation.

You could cache the tables but the odds are that they are memory resident anyway if they are that active.
A high use table should not get pushed out of memory, assuming your DATA BUFFER Cache is large enough.
(Among other factors)

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"Carlos Alberto" <calberto2312_at_hotmail.com> wrote in message news:72954535.0206271222.3b1cc457_at_posting.google.com...
> 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
Received on Thu Jun 27 2002 - 16:04:59 CDT