Oracle database Size depends on the volume of data stored on disk or ASM. You can check size of Oracle database from query mentioned below. As an Oracle DBA this is one of the important task to analyze the growth of the database. In detail, here you will get to know the actual size of the database that comprises of only data files when no redo and temp are generated. In second case, you may asked to find out the overall database size that contains all the data files, temp files and the redo logs (free+used space). Third, is the size occupied by data in this database or you can say Database usage details which you can get using dba_segments.
Query to Check Size of Oracle Database
To Find the Size Occupied by Data in the Database
This query will help you to get the actual size of Oracle database which is occupied by data in this database .
SELECT SUM (bytes)/1024/1024/1024 AS GB FROM dba_segments;
To check allocated Oracle Database Size
Overall database size is the sum of used space plus free space i.e. the size of the data files, temp files, log files and the control files. You can find out the total database size using simple query. This sql gives the total size in GB.
select ( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) + ( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) + ( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) + ( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from v$controlfile) "Size in GB" from dual
Good information on Oracle DB size. helped me a lot.
thanks a lot.
thanks…good info for quick ref
Hi, Is there way to find the total free space in oracle DB?
So clear and concise ..great
Thanks Daarmendra