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

Home -> Community -> Usenet -> c.d.o.server -> Re: space script

Re: space script

From: OraCLeDbA <oracle_dba_at_zdnetmail.com>
Date: Fri, 28 Aug 1998 19:26:02 -0700
Message-ID: <6s7oj8$1q5@sjx-ixn5.ix.netcom.com>


Analyze the table that you want to get the length and then

select avg_row_len from dba_tables where table_name='<...>';

Ed Lufker wrote in message <6s6n49$n7c$1_at_sloth.swcp.com>...
>Hi All;
>
>
>
> Does anyone have a script that will calculate average row
>length????
>
>
>
>thanks in advance
>eddie lufker
>
Received on Fri Aug 28 1998 - 21:26:02 CDT

Original text of this message

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