Sunday, March 29, 2009

Recycle bin - Space Calculation

To determine the space occupied by the objects in recycle bin.

SQL> select sum(space*8)/1024 space_in_MB from dba_recyclebin;

Where space is the number of blocks and 8 is the block size in kb.

Note: The free space calculation (dba_free_space) excludes the recyclebin objects, so the free space reported is accurate.

Thanks

No comments:

Followers

Powered By Blogger
 

Oracle Database Administration. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com