-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|