SCHAMA SIZE in BYTES/KB/MB/GB/TB

SCHAMA SIZE in BYTES/KB/MB/GB/TB


SELECT  sum(bytes)/power(1024, 0) BYTES, sum(bytes)/power(1024, 1) KB,
sum(bytes)/power(1024, 2) MB, sum(bytes)/power(1024, 3) GIGA,
sum(bytes)/power(1024, 4) TERA
FROM DBA_DATA_FILES d
WHERE d.tablespace_name in
(select distinct tablespace_name from  dba_segments  Where OWNER = upper('&username'));