Skip to Main Content
Forums

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!

How to check the objects size in DBA_RECYCLEBIN

KrishnaAgnihotriDec 2 2013 — edited Dec 3 2013

Hi All,

I want to purge dba_recyclebin, before that i want to check the size of all objects residing in dba_recyclebin.

I am using below query to goup by tablespace.

SELECT TS_NAME, SUM(SPACE*1024)/1024/1024/1024 AS "Size in GB" FROM DBA_RECYCLEBIN GROUP BY TS_NAME order by 2 desc

Kindly inform me is the correct way to check it. for example if the 10gb space is shown from this query, will i able to see 10GB free space after purging. Kindly confirm

Thanks

Krishna
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2013
Added on Dec 2 2013
#general-database-discussions
3 comments
23,954 views