1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | 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; |