Blog from a software professional, Passionate to work in latest cutting edge technologies in order to get better results in business.
The Following SQL is helpful to list the size of All Schemas present in Oracle Database
select owner, sum(bytes)/1024/1024 tsize
from dba_segments
group by owner
order by tsize desc
Trust its helpful…
Regards
Fauzi
Post a Comment
No comments:
Post a Comment