terça-feira, 31 de março de 2009

ORACLE Show Instance Name, Version, Status, Database Status

SQL> set linesize 10000;
SQL> select instance_name,version,status,database_status from v$instance;

INSTANCE_NAME VERSION STATUS DATABASE_STATUS
---------------- ----------------- ------------ -----------------
orcl 10.2.0.4.0 OPEN ACTIVE