SQL & PL/SQL

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!

average row length

elmasduroJun 29 2011 — edited Jun 29 2011

Hi All,

i created various tables in my oracle database and inserted some rows in each table. I analyzed the table to have 10% stats.
what i want to know is what oracle view should i look at to find out the average row length for each table? what columns should i look?

i was told to look at all_tables but have no idea what column to look at or how to compute the average row length.
does any body has a query to get that info or know what oracle built in table i should go to?

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 27 2011

Added on Jun 29 2011

3 comments

452 views