Re: how to calculate table/index actual used space

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 05 Dec 1998 07:15:41 +0100
Message-ID: <3668CF8D.34C169F6@sybrandb.demon.nl>

Just use the analyze utilities and results will end up in the datadictionary.
in sqlplus or svrmgr
execute dbms_utility.analyze_schema('<schemaname>','either computer or estimate or delete, delete will reset the statistics')

hth,

Sybrand Bakker, Oracle DBA

dbnerd wrote:

> Does anyone have scripts to calculate space that is actually get used in
> tables/indexes? I can see the allocated space from dba_segments table.
> How about actual used space.
>
> Thanks.
>
> Bob

Received on Sat Dec 05 1998 - 00:15:41 CST