Database Info

----------------------------------
-Database Information
-File Name: db.sql
-Usage: @db
-----------------------------------

col db.name for a10
col HOST_NAME for a30
set line 200
select inst.HOST_NAME,db.name,open_mode,instance_name,inst.status,database_role,to_char(startup_time,'dd-mon-yy hh24:mi:ss') Startup,
sum(df.bytes / (1024*1024*1024)) "DB Size in GB" from v$database db,v$instance inst,v$datafile df group by db.name,open_mode,
instance_name,inst.status,database_role,startup_time,inst.HOST_NAME
/