Re: Average row size ques...

Thank You!!!

Steve

Ari D Kaplan wrote:

> The quickest way is to analyze the table and look at the cost-based
> statistics:
>
> ANALYZE TABLE xxx ESTIMATE STATISTICS;
>
> SELECT TABLE_NAME, AVG_ROW_LEN
> FROM USER_TABLES
> WHERE TABLE_NAME = 'xxx';
>
> Best regards,
>
> -Ari Kaplan
> Independent Oracle DBA Consultant
>
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> <-> For 370+ Oracle tips, visit: <->
> <-> <->
> <-> www.arikaplan.com <->
> <-> <->
> <-> email: akaplan_at_interaccess.com <->
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
> On Mon, 22 May 2000, Stephen J Palmer wrote:
>
> > Hello all,
> > I need to figure out what the average row size of a table is. I'm sure I
> > have come
> > across this a while back, but have been unable to locate it from my
> > notes.
> >
> > Any help with this would be greatly appreciated.
> >
> > Thanks in advance.
> >
> > Steve
> >
> > Stephen Palmer
> > Junior Database Administrator
> > Photronics Inc.
> > 15 Secor Road
> > Brookfield, Conn.
> > 203.740.5331
> > Pager 203-830-0306 or 1-800-706-7109
> > mailto:spalmer_at_brk.photronics.com
> > Home Number 203.270.8159
> > Alpha Pager mailto:spalmer.pager_at_brk.photronics.com
> >
> > --
> > Author: Stephen J Palmer
> > INET: spalmer_at_brk.photronics.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Author: Ari D Kaplan
> INET: akaplan_at_interaccess.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Stephen Palmer
Junior Database Administrator
Photronics Inc.
15 Secor Road
Brookfield, Conn.
203.740.5331
Pager 203-830-0306  or  1-800-706-7109
mailto:spalmer_at_brk.photronics.com