查看oracle数据库实例的信息

ORACLE 3年前 0 173

1、查看数据库实例orcl的当前状态

SQL> select name,cdb,open_mode from v$database;

NAME      CDB OPEN_MODE
--------- --- --------------------
ORCL      NO  READ WRITE

2、通过v$instance视图查看数据库实例orcl的信息

SQL> select instance_name,host_name,version,startup_time from v$instance;

INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
VERSION           STARTUP_T
----------------- ---------
orcl
worker01
12.2.0.1.0        14-DEC-20

3、通过v$datafile视图，查看数据库的基本信息

SQL> select file#,status,enabled,name from v$datafile;

     FILE# STATUS  ENABLED
---------- ------- ----------
NAME
--------------------------------------------------------------------------------
         1 SYSTEM  READ WRITE
/u01/app/oracle/oradata/orcl/system01.dbf

         2 ONLINE  READ WRITE
/u01/app/oracle/oradata/orcl/sysaux01

         3 ONLINE  READ WRITE
/u01/app/oracle/oradata/orcl/sysaux01.dbf


     FILE# STATUS  ENABLED
---------- ------- ----------
NAME
--------------------------------------------------------------------------------
         4 ONLINE  READ WRITE
/u01/app/oracle/oradata/orcl/undotbs01.dbf

         5 ONLINE  READ WRITE
/u01/app/oracle/oradata/orcl/wxjdb1.dbf

         7 ONLINE  READ WRITE
/u01/app/oracle/oradata/orcl/users01.dbf


     FILE# STATUS  ENABLED
---------- ------- ----------
NAME
--------------------------------------------------------------------------------
         8 ONLINE  READ WRITE
/u01/app/oracle/oradata/orcl/fgedu01.dbf


7 rows selected.

声明：本站所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。

oracle