Home » RDBMS Server » Server Administration » Table size estimation
Table size estimation [message #57398] Thu, 12 June 2003 03:25
Xenofon Grigoriadis
Messages: 33
Registered: May 2002
Member
Hi there,

can anybody explain to me how I can estimate the size of a table, which I am going to create, or say I created it and want to calculate its size, when having, lets say 1000 records.

Creating the table first, seems to be a help. Then you have for instance the AVG_ROW_LEN in SYS.DBA_TABLES. But even this multiplied with the records in the table does not seem to offer an accurate estimation.

How would you solve the problem?

Thanks a lot in advance for helping,

Xenofon Grigoriadis
Previous Topic: BLOB
Next Topic: problem with MTS
Goto Forum:
  


Current Time: Fri Sep 20 07:27:47 CDT 2024