spfile script



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;

Leave a Reply

Your email address will not be published. Required fields are marked *