Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Avg Row size
"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.com> wrote in message news:<TKv4a.165826$be.147856_at_rwcrnsc53>...
> You could analyze the table and look in the data dictionary or determine how
> many rows (select count(*) from mytable and divide it by the table size,
> blocks * block size)
> Jim
> "Subroto Mukherjee" <submukhe_at_cisco.com> wrote in message
> news:1045595633.358106_at_sj-nntpcache-5...
> > Hi SQL gurus,
> >
> > Can somone tell me how to calculate the Avg Row size for any given
> > table.
> >
> > Thanks a bunch in advance
> >
Actually if you analyze or use dbms_stats to create/update the statistics the average row lenght will be calculated for you, see dba_tables.avg_row_len.
HTH -- Mark D Powell -- Received on Wed Feb 19 2003 - 08:52:55 CST
![]() |
![]() |