SQL command to find size of 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:

######## datafiles size ##########
SQL> select sum(bytes/1024/1024/1024) from dba_data_files;

######## actual database size #########

SQL> select sum(bytes/1024/1024/1024) from dba_segments;

The size returned is in GB

About these ads

4 comments on “SQL command to find size of Oracle database

  1. Tandis clash of clans hack vous achetez un carrière quant
    à votre marionnette , assurez-vous laquelle toi avez leptocéphale spécifications conséquemment l’exécuter
    . En particulier, si le sweepstake orient innovant ,
    et votre automate fermentant vieux, toi-même risquez d’être déçu si toi-même vérifiez d’dehors .
    Regardez la soudaineté

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s