Re: space usage

Chuck, what is you percent free and what is the average row length? Make sure pctfree + pctused <= 100. Normally they should add to 100 minus the percentage of usable space that one row consumes for optimal usage (this is from the manual so you can usually add to less and be OK).

We have experienced a wild table growth problem (ver 7.1.3) in the past where we had a table that would take extents, but a group by query on the file_id, block_id of the rowid would show the extents unused. We traced it to inserts done via a packaged pl/sql block using a sequence. There was no problem in sqlplus doing the same SQL. We could duplicate the results but Oracle never did.

Anyway, I hope this helps, and you might want to re-analyze the table with a large sample size.

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:43:15 CDT