Analyze the table(s) with COMPUTE (dbms_stats.gather_table_stats)
and check the BLOCKS and EMPTY_BLOCKS columns in
DBA,ALL, or USER_TABLES.

For the indexes,
use "ANALYZE INDEX ... VALIDATE STRUCTURE;"
and check USED_SPACE in INDEX_STATS.

-----Original Message-----
From: Edouard Berard
[mailto:oracledba-ezmlmshield-x69918426.[Email address protected]
Sent: Wednesday, May 30, 2007 2:05 PM
To: LazyDBA Discussion
Subject: Determine Disk Space used by tables

Hello,

Is it possible to determine the amount of diskspace used at a table
level?

I thought i would give it a go by determining my block size value 32768
( select * from v$parameter where name = 'db_block_size';

then determining the blocks per table...

Here is one of my tables...
Number of rows:407358629
Number of blocks:1000561
blocks * db_block_size

1000561| 32768|32786382848




Am I even close?



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page