Skip to Main Content

Oracle Database Discussions

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!

Recycle bin purge not reflected in in dba_free_space

CastellAug 17 2017 — edited Aug 18 2017

DB version: 11.2.0.4

OS : RHEL 6.7

As the schema owner, I ran PURGE RECYCLEBIN and freed up 500GB. This got reflected in dba_recyclebin.space

But, this hasn't made any change to dba_free_space.bytes . I mean, the following query's output remains unchanged before and after the RECYCLEBIN purge.

     select sum(bytes)/1024/1024/1024 gbSize from dba_free_space where tablespace_name='APPS_TBS';

Should I wait for a while to get this reflected in dba_free_space ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2017
Added on Aug 17 2017
15 comments
1,296 views