Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Capture average Record length

user40159Dec 5 2009 — edited Dec 5 2009
Dear,

Besides the dba_tab_columns view which can report the average column length in a table, are there any other views that can report the average record length in a table (i.e., average record length is the acutal bytes occupied by all records in that table divided by number of records.)?

I also assume that there is no need to turn on statistics to store the average column length in the dba_tab_columns view. Is it right?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2010
Added on Dec 5 2009
8 comments
1,212 views