Re: The disk space used by a certain table??!!

In article <8it9pe$5os$1_at_nnrp1.deja.com>,   ibm_97_at_yahoo.com wrote:
> Thanks for your reply.
> But for my No.3 question, I mistyped. Actually the question I want to
> ask is:
> If the 'bytes' in 'dba_segments' is the allocated disk space by table
> 'tab', why is it much more than 'avg_row_len*num_rows'(even you can
 add
> more space for row header)? Since the pctfree is so small.
>
> Thanks again!

Isn't that obvious? dba_segments.bytes is allocated space. avg_row_len*num_rows is the current used space. Thomas Kyte has an article in the latest issue of Oracle Magazine that discusses this.

--
Yong Huang

(yong321_at_yahoo.com)
(http://www.stormloader.com/yonghuang/)


Sent via Deja.com http://www.deja.com/
Before you buy.