Re: reclaiming space from recycle bin

  • From: dave <david.best@xxxxxxxxx>
  • To: Sharon.Kovac@xxxxxxxxxxxxxxx
  • Date: Tue, 8 Dec 2009 16:04:35 -0500

On Tue, Dec 8, 2009 at 3:11 PM, <Sharon.Kovac@xxxxxxxxxxxxxxx> wrote:

>
> I've been remiss in deleting old objects from my recycle bin.  At this
> point I have over 2GB of objects in the recycle bin.  I did 
> 'purgedba_recyclebin'
> as sysadmin and now the recycle bin is empty.  However, when I look at the
> space, I don't see that I got 2GB back.  I know when I delete
>

How are you viewing the space?  If your looking at dba_free_space then that
is a view which factors in space within the recyclebin.

Take a look at the source behind the dba_free_space view and you can see
what its doing behind the scenes.

L8r

Other related posts: