How to get user tablespace size present

 Get user tablespace size 


select TABLESPACE_NAME, sum(MAXBYTES/1024/1024/1024) from dba_data_files where TABLESPACE_NAME in ('&1') group by TABLESPACE_NAME;

Comments