Re: AVG_SPACE of what ??!

From: Sang Ryung Lee <srlee_at_shinsegi.com>
Date: Tue, 19 Jan 1999 12:10:10 +0900
Message-ID: <36A3F792.B17DB8FD@shinsegi.com>

I can find the meaning of AVG_SPACE in the Oracle7 Server Reference Manual.

AVG_SPACE means that Average amount of free space (in bytes) in a data block allocated to the table.

Bye.
S.R. Lee

alt_at_interchange.co.uk wrote:

> Hi
>
> I've analyzed some tables in a schema and I'm trying to make sense of the
> statistics returned.
>
> In the view USER_TABLES there are columns for num_rows, avg_row_len etc which
> are self explanatary but what does the AVG_SPACE relate to? Is it the average
> space used in a block or left in a block or what? I cant find any reference to
> this in a manual.
>
> Please email a reply to alt_at_interchange.co.uk
>
> Thanks for the help.
>
> Al
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Jan 18 1999 - 21:10:10 CST