Record size computation

[hanselrl]

Can someone teach me how to compute the recordsize based on the structure of a table?

Thanks in advance!!

[nabaig]

If by record size, you mean the length of an row:

> analyze table table_name compute statistics;

> select avg_row_len from dba_tables where table_name = "XXX";

This is crude and gives the average length of a row. Can you be more specific and tell us why you eed this; for sizing or for other reasons.

Nizar

[hanselrl]

I need to know the record size of all the tables in our database for sizing purposes.
Thanks !