Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 27 2014
Added on May 29 2014
3 comments
2,135 views