View Single Post

  #2 (permalink)  
Old 11-26-2007, 10:23 AM
siri6589 siri6589 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 5
siri6589 is on a distinguished road
Size of database

If you are on a unix platform then you can find the size of the database with the following command:
( to know the size in MB) type in the following command

select sum(bytes)/1024/1024 "Meg" from dba_data_files;

If you are on windows platform then size of the datafiles imples the size of the database ( offcourse redo logs also add size of the database)

Hope this is may help you.

Thank you,
Siri6589,
Oracle DBA.
Reply With Quote