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

Labels: Posted by Sandeep G on Thursday, January 24, 2008 at 11:46 PM

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:

Post a Comment

Subscribe to: Post Comments (Atom)