Help - Search - Members - Calendar
Full Version: Table Size
Oracle DBA Forums > Oracle > Oracle Forum
dima
Hi:
Can some tell me how to find out the list of table and their sizes ?
Thank you,
Dima
SteveC
Define what you mean by size.
dima
I mean amonut of data in KB.
SteveC
I can have a monster table with no data in it whatsoever. Pick one or the other: how much space has been allocated for the table, or how many records are in the table.
dima
How many records in the table in bytes
Asma
QUOTE (dima @ Jul 28 2008, 08:20 PM) *
How many records in the table in bytes


you may get this by having sum of avg_row_len * num_rows from dba_tables.
SteveC
I can have zero records in a table with 1GB of space allocated/used by it. You don't get the difference, do you?
burleson
Hi Dima,

There are lots of ways to estimate table size, please read:

http://www.dba-oracle.com/t_script_oracle_table_size.htm

If you just want the estimated row space and your dbms_stats are current, just multiply avg_row_len by num_rows.

You can get the more sophisticated scripts in the Oracle script collection:

http://www.oracle-script.com
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.