Re: Space Utilization Problems

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: Tue, 2 Jun 1998 12:42:20 -0400
Message-ID: <6l1a13$pa7@sjx-ixn10.ix.netcom.com>

Check blocks and empty_blocks columns in user_tables or dba_tables after you analyze the schema. Empty_blocks+blocks is the number of allocated database blocks to a table. Blocks shows number of blocks used for data and empty_blocks is free blocks

Venkat

>Now, I have another question. How do I find out the exact amount of raw
data
>(not allocated) that is in each table?
>
>Again, thanks for your help out there!
>
>Stuart
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Tue Jun 02 1998 - 11:42:20 CDT