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
Sunday, March 29, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment