size of database

[srilata]

howto know the size of database

[siri6589]

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.

[kalyansantosh]

Thanks Siri for ur answer