Re: space usage

From: Winnie Liu <poohland_at_hotmail.com>
Date: Mon, 13 Jul 1998 19:35:24 -0700
Message-ID: <6oeftf$cl7@sjx-ixn9.ix.netcom.com>

would it be possible that the rows that they insert is greater than the free space available on the block? For example, the block is 50% filled by a row. But when another row that we are going to insert cannot fit in the rest of the 50%-PCTFREE of the block and actually had to get another block?

This is only my 2 cents though!

Winnie
poohland_at_hotmail.com

Chuck Hamilton wrote in message <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 Mon Jul 13 1998 - 21:35:24 CDT