v$instance 、v$database

 SQL> select instance_name,host_name,thread#,status from v$instance;

INSTANCE_NAME    HOST_NAME     THREAD#    STATUS

----------------    ---------------------------------------------------------------- ----------    ------------

orcl                    LESSION6                                                                  1                    OPEN

SQL> select dbid,name,log_mode,current_scn from v$database;

      DBID NAME      LOG_MODE     CURRENT_SCN

---------- --------- ------------ -----------

1181980082 ORCL      ARCHIVELOG       1977951