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: table size

Re: table size

From: G. Napol <napol_at_libero.it>
Date: 2000/07/13
Message-ID: <396DC5A4.747B6BE2@italdata.it>#1/1 






Ciao Corrado



You can use the 'ANALYZA TABLE table_name COMPUTE STATISTICS' statement
and then read the computed statistics from the dictionary tables
USER_TABLES, ALL_TABLES or DBA_TABLES.



Hope this helps



Ciao Gennaro



corrado brambilla wrote:



> Hi, I need to calculate a table size for any tables in my db.

> Please advice how to do so.

>

> Thanks

> Corrado

Received on Thu Jul 13 2000 - 00:00:00 CDT












Original text of this message













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