Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Determining table size

Re: Determining table size

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/07/19
Message-ID: <3975AA1B.2E837B78@edcmail.cr.usgs.gov>#1/1

You can use the DBMS_SPACE package. More specifically, try the DBMS_SPACE.UNUSED_SPACE procedure. It will tell you how much space is allocated and how much of that has really been used.

HTH,
Brian

Bhavin Shah wrote:
>
> Hi,
>
> After a user creates a table, how do you tell how much space (bytes) the
> table is occupying? I tried looking at the user_tables, but the fields
> like blocks are blank. Thanks in advance.
>
> Btw, it's on Oracle 8.1.6 Linux if that makes a difference.
>
> Bhavin
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================
Received on Wed Jul 19 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US