Friday, August 16, 2013

Get Schemas size in Oracle

select owner, sum(bytes)/1024/1024 tsize
from dba_segments
group by owner
order by tsize desc;

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

ALCATEL 6900

write memory copy running certified reload from working no rollback-timeout