Re: calculating space on tables

From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1996/05/11
Message-ID: <4n38ok$253_at_client3.news.psi.net>#1/1


In article <4n1cdn$s98_at_dfw-ixnews9.ix.netcom.com>,

   dcs1_at_ix.netcom.com(david sacks ) wrote:
>Hi....
>
>Was wondering if anyone can help....am putting together some OPO forms
>showing various statistics related to space management. For example,
>tablespace allocation and fragmentation. I could use some help in
>determining how to calculate the amount of space already used in
>tables.

analyze tables, then use the view dba_tables to display the amount of empty space within the allocated segment. from this you could calculate how much is used.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.
Received on Sat May 11 1996 - 00:00:00 CEST

Original text of this message