查看oracle 10g 视图

1、  查看数据库的名字和归档状态

SQL> select name,log_mode from v$database;

NAME      LOG_MODE

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

HB130000  ARCHIVELOG

2、  查看数据库的instance名字和状态

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS

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

hb130000         OPEN

3、查看表空间名称、状态和管理方式

SQL> select tablespace_name,status,extent_management from dba_tablespaces;

TABLESPACE_NAME                STATUS    EXTENT_MAN

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

SYSTEM                         ONLINE    LOCAL

UNDOTBS1                       ONLINE    LOCAL

SYSAUX                         ONLINE    LOCAL

TEMP                           ONLINE    LOCAL

USERS                          ONLINE    LOCAL

GFB                            ONLINE    LOCAL

YSZX130000002004               ONLINE    LOCAL

RMAN                           ONLINE    LOCAL

8 rows selected.

4、查看控制文件的位置和名字

SQL> select name from v$controlfile;

NAME

/oracle/app/oracle/OraHome/dbs/hb130000/control01.ctl

/oradata/hb130000/control02.ctl

/oradata/hb130000/control03.ctl

5、查看日志文件的组名、成员数量、状态和大小

SQL> select group#,members,bytes,status from v$log;

    GROUP#    MEMBERS      BYTES STATUS

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

         1          2   52428800 INACTIVE

         2          2   52428800 INACTIVE

         3          2   52428800 CURRENT

6、查看日志文件的位置

SQL> select group#,member from v$logfile;

    GROUP#

----------

MEMBER

         3

/oradata/hb130000/redo03.log

         3

/oracle/app/oracle/OraHome/dbs/hb130000/redo03.rdo

         2

/oradata/hb130000/redo02.log

    GROUP#

----------

MEMBER

         2

/oracle/app/oracle/OraHome/dbs/hb130000/redo02.rdo

         1

/oradata/hb130000/redo01.log

         1

/oracle/app/oracle/OraHome/dbs/hb130000/redo01.rdo

6 rows selected.

7、查看数据文件的位置和大小

SQL> select name,bytes from v$datafile;

NAME

     BYTES

----------

/oradata/hb130000/system01.dbf

 492830720

/oradata/hb130000/undotbs01.dbf

  41943040

[1] [2]  下一页