Re: how do you tell when a table is almost full?

From: Dan Rippel <jford_at_mail.erols.com>
Date: 1997/02/25
Message-ID: <33124636.1836089@news.erols.com>#1/1

Determining this is going to be very specific to your table, block size, and space in your database.

First, you need to check on the storage options for your table from sys.dba_tables. Initial extent, next extent, max extents, etc. ad nauseum.

Then determine the amount of bytes one row will take from the structure of the table.

Then find a calculator.

For there you
On Fri, 21 Feb 1997 10:09:29 -0800, Jacques Raymond Kilchoer <jrkilch_at_costcare.com> wrote:

>How do I find out how many rows I can add to a table before it runs out
>of extents?
>--
> ___ ___
>(___)=============================================================(___)
>| | Jacques Raymond Kilchoer MIS:Applications Support | |
>| | Assistant DBA /^\ ^ (714) 729-4500 x3733 | |
>| | Cost Care, Inc. /\ _/ \/ \ fax 729-4651 | |
>| | Newport Beach /\ /\/ \// \ \_/\ | |
>| | CA 92660 / \ / / \ / \ Suisse/Schweizer | |
>|___| ____/____\____/_________\___ _\_______ Svizzero |___|
>(___)=============================================================(___)
Received on Tue Feb 25 1997 - 00:00:00 CST