Originally posted by ashley75

Jeff,

thanks for the response.

I have two questions:
1. how does Oracle calculate on the AVG_ROW_LEN, based on what???

2. based on your example, you mentioned that let's say AVG_ROW_LEN=19, what do you mean by "If I expect this row to have 1,000,000 record", you mean 1,000,000 rows to to be inserted into this table????

Thanks
1. When you generate statistics, oracle calculates the size of a row's actual data instead of it's potential data (size of columns). How it does it, I don't know.

2. Yes, I meant if the table will have 1,000,000 rows, your size would be approximately 19,000,000 bytes.