Re: Average row size ques...

Thank You!!!!

Steve

Lisa_Koivu_at_gelco.com wrote:

> Hi Steve,
>
> analyze the table and look in DBA_TABLES for AVG_ROW_LEN. That's the quickest
> way.
>
> Lisa
>
> "Stephen J Palmer" <spalmer_at_brk.photronics.com> on 05/22/2000 04:16:40 PM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: Lisa Koivu/GELCO)
>
> 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:
> INET: Lisa_Koivu_at_gelco.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
Home Number 203.270.8159