Re: TABLE SIZE

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 16 Jul 1999 18:49:26 +0200
Message-ID: <932143739.20824.0.pluto.d4ee154e@news.demon.nl>

The bytes column corresponds to the number of bytes ALLOCATED, which is not necessarily the same as USED.
(sorry for the capitals, I would rather not post html code) That value is always accurate as extents are grabbed one by one and the dictionary will be updated to reflect the change.

Hth,

Sybrand Bakker, Oracle
<dref22_at_my-deja.com> wrote in message news:7mnjbv$igp$1_at_nnrp1.deja.com...
> Does any one of you know if the "bytes" column in
> the "dba_extents" tables correspond precisely to
> the physical table size consumes on disk.
> Does ORACLE server update regularly those values?
>
> Thanks.
>
> BR,
> Frederic
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jul 16 1999 - 11:49:26 CDT