Can someone teach me how to compute the recordsize based on the structure of a table?
Thanks in advance!!
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.
I need to know the record size of all the tables in our database for sizing purposes.
Click Here to Expand Forum to Full Width