Database Administration (MOSC)

MOSC Banner

Estimating total size of the database

edited Aug 18, 2014 3:12PM in Database Administration (MOSC) 15 commentsAnswered ✓
I want to estimate a total size of the database prior to decomissioning.

So far I cam up with the following:

select (select sum(bytes)/(1024*1024) from dba_data_files)+
(select sum(bytes)/(1024*1024) from dba_temp_files) +
(select sum(bytes)/(1024*1024) redo_size from v$log ) +
(select sum(block_size*file_size_blks)/(1024*1024) controlfile_size from v$controlfile) "Size in MB" from dual;

Is that about orrect, or do i need to include anything else?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center