col startup_time    for a20
col instance_name for a15
col host_name for a30
SET lines 200
SELECT instance_name, i.host_name, to_char(startup_time,'dd/mm/yyyy hh24:mi:ss') startup_time,
	d.log_mode, i.status, i.logins, d.open_mode
FROM gv$instance i,gv$database d;

col startup_time    for a20
col instance_name   for a15
col host_name       for a30
SET lines 200
SELECT distinct 
	instance_name, 
	i.host_name, 
	to_char(startup_time,'dd/mm/yyyy hh24:mi:ss') startup_time, 
	d.log_mode, 
	i.status, 
	i.logins, 
	d.open_mode
FROM gv$instance i,gv$database d;