How big or full is a table?

From: <argosy22_at_my-deja.com>
Date: 2000/05/04
Message-ID: <8esl9a$o1i$1@nnrp1.deja.com>#1/1

Hi all,

This is related to the extents questions that I had recently.

A table will have a MAXEXTENTS property, and will be part of a tablespace, which will also have a MAXEXTENTS property.

The table will only be able to expand to maximum extents of either the table, or the tablespace, whichever is lower. Correct?

But how can we tell just how full a table is? If it can expand to a maximum of 100 extents, how can we tell how many extents that the data is currently taking up? Say, at 90 extents.

A similar idea is that if all tables use the same tablespace, how can we tell which tables are taking up most of the tablespace/datafile?

I've been searching the data dictionary for clues, but haven't found anything yet.

Thanks,

Argosy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu May 04 2000 - 00:00:00 CDT