dbuptime

set linesize 130
set pagesize 1000

col host_name format a30
col instance_name format a30
col startup_time format a30


SELECT host_name,instance_name,TO_CHAR(startup_time, 'DD-MM-YYYY HH24:MI:SS') startup_time,FLOOR(sysdate-startup_time) days FROM sys.v_$instance;