Size in Mb and Gb
K. VarunOct 15 2012 — edited Oct 15 2012Hello Forum Mates...
how to get sizes in mb and gb,
for example take this statment
SQL> select tablespace_name,sum(bytes) from dba_free_space group by tablespace_name;
TABLESPACE_NAME SUM(BYTES)
--------------- ----------
UNDOTBS1 7274496
SYSAUX 9306112
USERS 2097152
PROD 5177344
SYSTEM 5111808
EXAMPLE 33292288
may be ists a smaal and silly question but i need to know....
thank you!