size of table

Estimating the size of a table
-----------------------------

ANALYZE table COMPUTE / ESTIMATE statistics

Get the AVG_ROW_LEN from DBA_TABLES, ALL_TABLES

Table size = AVG_ROW_LEN * Number of Rows * (1 + PCTFREE/100) * 1.15

01-27-2003, 11:46 PM
agasimani

1. analyze table tablename compute statitics

2. select blocks,empty_blocks from dba_tables where table_name='tablename';

3. So the size of the table is (blocks+empty_blocks)*db_block_size

4. You can find the db_block size by
select value from v$parameter where name='db_block_size'

All times are GMT -4. The time now is 10:07 AM.