查看电脑上的oracle数据库,查看oracle 10g 视图数据库教程

查看电脑上的oracle数据库,查看oracle 10g 视图数据库教程

oracle|视图

查看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/l

/oradata/l

/oradata/l

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

/oradata/hb130000/sysaux01.dbf

346030080

NAME

BYTES

----------

/oradata/hb130000/users01.dbf

5242880

/oradata/hb130000/GFB.DBF

20971520

/oradata/hb130000/YSZX130000002004.DBF

176160768

NAME

BYTES

----------

/oradata/hb130000/rman.dbf

104857600

7 rows selected.

8、查看用户拥有的对象和类型

SQL> select object_name,object_type from dba_objects where wner='SCOTT';

OBJECT_NAME

OBJECT_TYPE

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

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

DEPT

TABLE

PK_DEPT

INDEX

EMP

TABLE

PK_EMP

INDEX

BONUS

TABLE

SALGRADE

TABLE

6 rows selected.

9、查看临时文件的信息

SQL> select name,bytes from v$tempfile;

NAME

BYTES

----------

/oradata/hb130000/temp01.dbf

20971520

10、查看归档日志信息

SQL> select name, FIRST_CHANGE#,next_change# from v$archived_log;

NAME

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

FIRST_CHANGE# NEXT_CHANGE#

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

/oracle/app/oracle/OraHome/dbs/archive/hb130000_1_53_532853380.dbf

1669178     1707392

/oracle/app/oracle/OraHome/dbs/archive/hb130000_1_54_532853380.dbf

1707392     1734524

/oracle/app/oracle/OraHome/dbs/archive/hb130000_1_55_532853380.dbf

1734524     1772848

NAME

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

FIRST_CHANGE# NEXT_CHANGE#

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

/oracle/app/oracle/OraHome/dbs/archive/hb130000_1_56_532853380.dbf

1772848     1798092

/oracle/app/oracle/OraHome/dbs/archive/hb130000_1_57_532853380.dbf

1798092     1831478

/oracle/app/oracle/OraHome/dbs/archive/hb130000_1_58_532853380.dbf

1831478     1865033