v$instance 、v$database

来源:互联网 发布:access管理mysql 编辑:程序博客网 时间:2024/03/29 19:04

 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