Verifica Versao do Banco

set pages 200 lines 200
col INSTANCIA for a
col SERVIDOR for a12
col VERSAO for a12
col STATUS for a8
col active_state for a12
col STARTUP_TIME for a12
select    
    INSTANCE_NAME AS INSTANCIA
    ,HOST_NAME AS SERVIDOR
    ,VERSION AS VERSAO
    ,STATUS
    ,ACTIVE_STATE
    ,STARTUP_TIME
from v$instance;



col host_name for a40
col instance_name for a15
col version for a20
col startup_time for a25
col status for a15
set lines 200
set pagesize 80
set timing on
select    
    inst_id
    ,instance_name
    ,host_name
    ,version
    ,to_char(startup_time,'dd/mm/yy hh24:mi') as startup_time
    ,status
from
    gv$instance
order by     1;