Hi all,

Does anyone have any SQL to check how much space had been allocated to a
table and how much space it actually required or used? I have a vendor who
did a DEMO and shows us that we have 4.9 GB table when it could have easily
used 500MB instead. Not sure whether am dreaming or sleepy when I saw that
or is it 'coz the high water mark of this table had not been reset. Am
thinking that perhaps if I had done an ALTER TABLE MOVE, I would've recover
the wasted space? If so, I want to know if anyone have a SQL statement that
will easily show allocated space against actual space used/required for all
the tables in my database.



Oracle LazyDBA home page