Actual row size

[shawish_sababa]

Hi All

Can someone please gevi me the select to calculate te actual averge size of a row ina table. When I write actual, I mean, not gust take the data from dba_segment devided by number of rows.

Thank's a lot

[sreddy]

Its little complex calculation if you want to realy find the actual size as you need to query internal(X$) tables and not sure its worth time. Best is insert test data and see the average row length from dba_tables view.

[Edited by sreddy on 02-08-2001 at 09:29 AM]

[sysdba]

Before you query from dba_tables/user_tables,
do not forget to analyze the table.