How can I calculate the size of the database.
Is it sum of size of all data files ,redo-log files and control files? Please advise.
Printable View
How can I calculate the size of the database.
Is it sum of size of all data files ,redo-log files and control files? Please advise.
select sum(bytes/1024/1024)MB from dba_data_files; and
select sum(bytes/1024/1024)MB from v$log;
Total of this would give the space allocated (not the one used up).
Shiva.
it depends how accurate you want to get
there are many threads about this matter, try a search before we continue
Search no more ! Your answer is waiting for you here: http://www.dbaclick.com/cgi-bin/ib3/...275;hl=db+size
It has ready to use scripts. Check it out.
For more visit the latest Oracle DBA forums: http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi?
Hope that helps,
:)
--clio_usa
Senior Oracle DBA
That link doesn't work!
Think I'll stick with dbasupport.com