[code language=”sql”]

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;

[/code]