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
Printable View
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
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]
Before you query from dba_tables/user_tables,
do not forget to analyze the table.