Dimensione DB

Lo spazio allocato

select

(select sum(bytes)/1024/1024 from dba_data_files)+

(select sum(bytes)/1024/1024 from dba_temp_files) "Size in MB"

from dual;

Lo spazio  usato

select sum(bytes)/1024/1024 "DB size in MB"

from dba_segments;

select

"Reserved_Space(MB)", "Reserved_Space(MB)" - "Free_Space(MB)" "Used_Space(MB)","Free_Space(MB)"

from(

select

(select sum(bytes/(1024*1024)) from dba_data_files) "Reserved_Space(MB)",

(select sum(bytes/(1024*1024)) from dba_free_space) "Free_Space(MB)"

from dual

);