Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [Q] table & used tablespace size?
How about pct_free and pct_used - did you account for those?
kkavie wrote:
> Anyone who know this situation and have an answer Reply to me...
> =====================================================================
>
> I computed a users table and index size.
> ===================
> but sum of them was not matched to used tablespace size that I saw in
> Storage manager.
>
> There was a big gap in there.
>
> I did not missed any table and index.
>
> Why are there big gap?
>
> >> I analyzed the tables and indexes by using estimate method..
>
> ref) used table space size : 1.3GB
> but sum of table and index size : 270MB
--
Met vriendelijke groet,
kind regards,
Frank van Bortel
Technical consultant Oracle
V&L Informatica BV
Work Home Postbus 545 Hunzestraat 4 7500 AM Enschede 7555 WB Hengelo (31)53.434.1500 (31)74.242.5046Received on Thu Apr 22 1999 - 07:26:11 CDT