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?


Oracle LazyDBA home page