Can anyone advise me on how to calculate the exact size of data that is stored in a row.....
i need to find the data in a row as my comp is planninn to charge on basis of data
Hoping to get an answer soon....
Printable View
Can anyone advise me on how to calculate the exact size of data that is stored in a row.....
i need to find the data in a row as my comp is planninn to charge on basis of data
Hoping to get an answer soon....
You can get avg_row_len from dba_tables by analyzing your tables.
This wil give you the average row length of a table.
Hi, 10th Dec 2001 18:25 hrs Mumbai
Remember: an estimation is nothing more than a guess. Hopefully, we are making educated guesses based upon pertinent information such as average row sizes and number of rows. There is no need to calculate down to the byte level how much overhead you will incur when the largest part of your estimation is based on inexact numbers; in my opinion, you would be wasting your time. Instead, be bold…be daring…guess…and round up.
The above content from the below article
http://www.ctel.net/~lopatosky/artic...able_sizes.htm
cheers
Padmam