echo ^||to_char(sysdate,'dd.mm.yyyy hh24:mi:ss')||''','''^ >> sql_script.sql

select  'insert into USER_NAME.report_instance ("date", host_name, instance_name,version,status,volume,sga_max_size_mb,buffer_hit_ratio,users) values ('''
 ||to_char(sysdate,'dd.mm.yyyy hh24:mi:ss')||''','''
 ||z.host_name|| ''','''
 ||z.instance_name|| ''','''
 ||z.version|| ''','''
 ||z.status|| ''','''
 ||round( t.bytes + p2.bytes ,1)|| ''','''
 ||sga_max_size_mb.value/1024/1024|| ''','''
 ||BUFF_HIT_RATIO|| ''','''
 || users|| ''');'
  from   dual, 
     (select sum (bytes)/1024/1024/1024 bytes from v$tempfile ) p2, 
     (select sum(bytes)/1024/1024/1024 bytes from   dba_data_files) t, v$instance z,          
(SELECT ROUND(1-(phy.value/(log.value+con.value)),3)*100 BUFF_HIT_RATIO   
FROM v$sysstat phy, v$sysstat log, v$sysstat con WHERE phy.name = 'physical reads' 
AND log.name='db block gets' AND con.name = 'consistent gets'),
(select count(*) users from dba_users usr),
(select value from v$parameter  where name like 'sga_max_size') sga_max_size_mb;