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

Hi

Check out the procedures dbms_space.unused_space and dbms_space.free_blocks. They might give you som answers.
These are installed by default when running catproc. They are described in the file $ORACLE_HOME/rdbms/admin/dbmsutil.sql.

You could also use the 'analyze' command if you are using cost-based optimization and then query the user_tables view.

Rgds

Steinar Heggelund

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 Thu Feb 27 1997 - 00:00:00 CST