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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,252 views