How to get size of many schemas in Oracle database

 Get Size of many schemas in Oracle Database


 select sum(bytes)/1024/1024/1000 “SIZE_IN_GB” from dba_segments where owner in ('user1','usern');

Comments