Syntax to find Total,Used and Free Space in Oracle Database

Syntax to Find Total Size of Database

Size in Megabytes:

Select sum(bytes)/1024/1024 from dba_data_files;

Syntax to Find Used Size of Database

Select sum(bytes)/1024/1024 from dba_segments;

Syntax to Find Free Size of Database

Select sum(bytes)/1024/1024 from dba_free_space;

Thanks

D.Sasi Kumar

 

0 comments: