SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help in understanding dbms_space.space_usage

vpolasaMay 29 2014 — edited May 30 2014

Hi,

Can someone please help me understand how below parameters are calculated for dbms_space.space_usage

fs1_blocks

fs2_blocks

fs3_blocks

fs4_blocks

I'm trying to use the below query, but it only give the percent of empty blocks as whole.

SELECT table_name,
       partition_name,
       blocks,
       empty_blocks,
       CEIL ( ( (empty_blocks / blocks) * 100)) perc
FROM dba_tab_partitions
WHERE table_owner = '<schema_name>' AND empty_blocks <> 0;

Currently using: Windows 7

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2014

Added on May 29 2014

3 comments

2,278 views