| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: space usage
What is your pctfree set at for the table segment?
This will determine up to what point to insert records in a block. This
parameter means the amount of space you want free to reserve for updates
that expand in size. Almost all data regardless of type is stored as
variable size. The pctused parameter is for determining what point of
freeing space due to deletes does the engine put this block back in the
freelist to be chosen by an insert statement.
EX.
PCTFREE 10
PCTUSED 40
This says that I want to continue to insert records into a block in this
table until the amount of free space goes below 10%
this also says that if I delete enough records that less than 40% of the
block is being used then I want to allow inserts to happen again to this
block
HTH
Chuck Hamilton <chuckh_at_dvol.com> wrote in article
<35aa3ff0.7786587_at_news.dvol.com>...
> I have a volatile table who's pctused is set at 97%. It's does a lot
> of inserts and deletes. It's grabbing extents out the wazoo, but when
> I analyze it, it shows avg free space per block is over 75%! Why is it
> wasting so much space when the pctused is so high? What can I do force
> it to use it's space more efficiently?
> --
> Chuck Hamilton
> chuckh_at_dvol.com
>
> If at first you don't succeed, sky diving isn't for you.
>
Received on Tue Jul 14 1998 - 14:52:10 CDT
 |
 |