-
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.
Nizar
-
I need to know the record size of all the tables in our database for sizing purposes.
Thanks !
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
|