Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Avg Row size

Re: Avg Row size

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Feb 2003 06:52:55 -0800
Message-ID: <2687bb95.0302190652.28ccc10d@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US