Size of Oracle database

Answer: There are several ways to measure the size of an Oracle database:

1 – The size of the Oracle database files can be computed several ways:

— get database size from v$datafile:

select round((sum(bytes)/1048576/1024),2) from v$datafile;

— get Oracle database size from dba_data_files:
select
“Reserved_Space(MB)”, “Reserved_Space(MB)” – “Free_Space(MB)” “Used_Space(MB)”,”Free_Space(MB)”
from(
select
(select sum(bytes/(1014*1024)) from dba_data_files) “Reserved_Space(MB)”,
(select sum(bytes/(1024*1024)) from dba_free_space) “Free_Space(MB)”
from dual
);

Advertisements
Leave a comment

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

%d bloggers like this: