DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Size of Data

  1. #1
    Join Date
    Dec 2001
    Posts
    1
    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....



  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    You can get avg_row_len from dba_tables by analyzing your tables.

    This wil give you the average row length of a table.
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Solution

    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
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width