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: [Q] table & used tablespace size?

Re: [Q] table & used tablespace size?

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Thu, 22 Apr 1999 14:26:11 +0200
Message-ID: <371F1563.7FEC52BB@vnl.nl>


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.5046


Received on Thu Apr 22 1999 - 07:26:11 CDT

Original text of this message

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