Databe growth status report in excel sheet
658474Apr 5 2010 — edited Apr 5 2010Hi All,
We are running the script to gather the database growth status. this script run everyday set as cronjob and collected the report manually from log to excel sheet.
select instance_name as Database_Name , host_name as Server_Name from v$instance;
select rpad('Actual_Allocated_Size : ',50) as DB_Stat_Info,round((sum(bytes)/(1024)/(1024)/(1024)),4) as Total_GB from dba_data_files
union
select rpad('Actual_Data_Size : ',50),round((sum(bytes)/(1024)/(1024)/(1024)),4) Total_GB from dba_segments where tablespace_name not in (select distinct tablespace_name from DBA_ROLLBACK_SEGS
union
select tablespace_name from dba_tablespaces where contents = 'TEMPORARY' );
I want to collect this report directly in excel sheet. Can you pls suggest some idea how to get this.
Regards,