How can I find the Size of my Database..?
Through OEM it is saying that
Database Size (GB) 22.609 (Home-->Space Summary-->Database Size (GB))
But if I give the following command it is giving the out put as 17.96 GB , why this much of difference, can u pl. explain..?
select ((sum(bytes)/1024)/1024)/1024 from dba_data_files
Thanks in Advance
10g?... you are missing dba_temp_files.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
and redo log files and control files
Click Here to Expand Forum to Full Width