Thanks to all that replied.

Michael Tom Gregg

I used dba_extents and dba_segments to get the info. thanks!



Edouard Berard
Clinical Information Systems Technology Group
University of California Davis Health System
Office: 916-734-4928
email: edouard.[Email address protected]




"Edouard Berard "
<oracledba-ezmlms
hield-x69918426.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
05/30/2007 12:06
PM 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