ITRemote

SELECT DECODE(value, 
               NULL, 
              'PFILE', 
              'SPFILE') "Init File Type"
  FROM sys.v_$parameter 
 WHERE name = 'spfile';

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY MM DD HH24:MI:SS';

set linesize 200 
col host_name for a45 
select INST_ID, 
       INSTANCE_NAME, 
       HOST_NAME,
       STARTUP_TIME DATABASE_STATUS, 
       status 
  from gv\$instance;