devxlogo

Determining the Size of an Oracle Database

Determining the Size of an Oracle Database

The size of the database is the total size of the datafiles that make up the tablespaces of the database. These details are found in the dba_extents view. Type the following lines at the SQL-PLUS prompt:

 select sum(bytes/1048576)from   dba_extents;

size=3>
This will give the total number of Mb used by your database.

devx-admin

Share the Post: