Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Analyse the size of data in a table
Philippe Leclercq wrote:
>
> How to evaluate the right size of a table ( not the size of the extend, but
> the size of the data) on Oracle 7.3 / NT when the optimizer of database is
> in statistic ?
You can display number of used blocks by querying ALL_TABLES, DBA_TABLES or USER_TABLES. select blocks*db_block_size-avg_space*blocks from dba_tables;
where db_block_size is the DB_BLOCK_SIZE in the initialization parameter file.
in SQL*Plus or Server Manager.
--- Name : Lun Wing San (Certified Oracle Database Administrator) Title : Oracle Database Administrator and System Administrator of QRC Phone : (852)27885841 This posting represents the personal opinions of the author. It is not the official opinion or policy of the author's employer. Warranty expired when you opened this article and I will not be responsible for its contents or use.Received on Sat Apr 12 1997 - 00:00:00 CDT