alter session set nls_date_format = 'dd/mm/yyyy hh24:mi:ss';

set linesize 300 
set pagesize 300 

column HOST_NAME format a15
column INSTANCE_NAME format a15
column ARCHIVER format a15
column SH_PEND format a15
column ACTIVE_STATE format a15
column LOGINS format a15
column DATABASE_STATUS format a15
column STATUS format a6
column version format a10
column HOST_NAME format a10
column platform_name format a30
column current_scn format 999999999999999999
column DBNAME format a30

select INST_ID,
INSTANCE_NAME,
HOST_NAME,
VERSION,
STARTUP_TIME,
STATUS,
ARCHIVER,
LOGINS,
SHUTDOWN_PENDING SH_PEND,
DATABASE_STATUS,
ACTIVE_STATE,
BLOCKED
from gv$instance
order by INST_ID;

select dbid,name dbname,created,platform_name,open_mode,current_scn from v$database;
