| Table size estimation [message #57400] |
Thu, 12 June 2003 03:45  |
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
|
|
|
|
| Re: Table size estimation [message #57409 is a reply to message #57400] |
Thu, 12 June 2003 22:36  |
Deepa
Messages: 269
Registered: November 2000
|
Senior Member |
|
|
Records per block = (block size - 110 bytes for overhead) * (PCTUSED/100)/Average Record Size
Total blocks = (records in table) / (records per block)
Total table size = blocks * block size
regards,
deepa
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
