set linesize 132
col INSTANCE_NAME format a10
col HOST_NAME format a15
col VERSION format a10
col STATUS format a7
col LOG_SWITCH_WAIT format a10
col LOGINS format a10
col BLOCKED format a5
select INSTANCE_NAME,HOST_NAME,VERSION,STATUS,LOG_SWITCH_WAIT,LOGINS,BLOCKED from v$instance;
col INSTANCE_NAME format a10
col HOST_NAME format a15
col VERSION format a10
col STATUS format a7
col LOG_SWITCH_WAIT format a10
col LOGINS format a10
col BLOCKED format a5
select INSTANCE_NAME,HOST_NAME,VERSION,STATUS,LOG_SWITCH_WAIT,LOGINS,BLOCKED from v$instance;
Comments