Database Administration (MOSC)

MOSC Banner

Database size seven days ago

edited Jan 3, 2013 10:12PM in Database Administration (MOSC) 3 comments
I used the following query to calculate my database total size:

select a.data_size + b.temp_size + c.redo_size + d.cont_size "total_size"
from (select sum(bytes) data_size from dba_data_files ) a,
(select nvl(sum(bytes),0) temp_size from dba_temp_files ) b,
(select sum(bytes) redo_size from sys.v_$logfile lf, sys.v_$log l where lf.group# = l.group#) c,
(select sum(block_size*file_size_blks) cont_size from v$controlfile ) d;

How can I use the awr history tables to find out the database total size seven days ago? I can find particular tablespace growth for seven days, but what about controlfiles and temp files all that? Thanks.

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