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: Andrew Williamson <andrewweb_at_my-deja.com>
Date: 2000/07/24
Message-ID: <964445632.6273.0.nnrp-02.c30bdde2@news.demon.co.uk>#1/1

Also, the blocks in user_tables only fill in when you do ANALYZE TABLE xx COMPUTE STATISTICS; Bhavin Shah <bhavinsh_at_aludra.usc.edu> wrote in message news:Pine.GSO.4.21.0007181834340.899-100000_at_aludra.usc.edu...
> 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
>
>
Received on Mon Jul 24 2000 - 00:00:00 CDT

Original text of this message

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