Re: dbms_space.space_usage and effectiveness of purge operations

  • From: Stalin <stalinsk@xxxxxxxxx>
  • To: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
  • Date: Tue, 5 Nov 2013 15:28:29 -0800

It all started with a question i had posted in Richard Foote blog on Index
rebuild vs. Coalesce vs.
out the question section of the post. Richard was so nice to even perform a
quick test and made a separate blog post
I will have to see where i read that :) and check my notes, if i even made
any references to FS2 blocks getting on freelist.

FYI... using dbms_space.unused_space always returns 0 for unused blocks.


Other related posts: