This content has been marked as final. Show 2 replies
select owner as "schema" ,round((sum(bytes)/1024/1024/1024),2) as "size GB" from dba_segments
group by owner
Above query will report size by schema.
Edited by: Erman Arslan on 31.Ara.2012 03:26
for archiving and purging, take a look at the documents below.
Reducing Your Oracle E-Business Suite Data Footprint using Archiving, Purging, and Information Lifecycle Management [ID 752322.1]
Edited by: Erman Arslan on 31.Ara.2012 03:35
Edited by: Erman Arslan on 31.Ara.2012 03:37