How To Find Wasted Space in Table in Oracle

Gaps occur in the blocks due to deletion operations in the tables. These spaces remain as wasted space. These spaces should be determined and shrink or move related table  to make wasted spaces to usable.

Find Wasted Space Size in Tables in Oracle

You can determine the size of wasted space in the tables with the following query. If the waste space in the tables in the query is too large, the corresponding tables must be moved or shrink. Block size is considered 8K in the query. If there is a different block size, you must change the sections indicated by “* 8” to “* block_size”.