查看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] 下一页 [SyBase]oracle 10G 安装 for Linux86 [ORACLE]Oracle 10G First Release的新特性简介(下) [ORACLE]Oracle 10G First Release的新特性简介(上) [ORACLE]Oracle 10G 中的"回收站" [ORACLE]Installing Oracle 10g on RHEL AS 3 Step-by-Ste… [ORACLE]Apple 开发人员可以用Oracle 10g 了 [ORACLE]Installing Oracle 10g on SuSE 9.1 professional [ORACLE][Oracle 10g] 大文件表空间 [ORACLE]PL/SQL Developer 与 oracle 10g 客户端兼容性问题… [ORACLE]Oracle 10g Release2新功能之Ref Cursor
|