查看oracle 10g 视图

查看Oracle 10g 视图1、; 查看数据库的名字和归档状态SQL> select name,log_mode from v$database;NAME;;;LOG_MODE --------- ------------HB130000; ARCHIVELOG2、; 查看数据库的instance名字和状态SQL> select instance_name,status from v$instance;INSTANCE_NAME;STATUS---------------- ------------hb130000 OPEN3、查看表空间名称、状态和治理方式SQL> select tablespace_name,status,extent_management from dba_tablespaces;TABLESPACE_NAME;;;;;STATUS;EXTENT_MAN------------------------------ --------- ----------SYSTEM ONLINE;LOCALUNDOTBS1;;;;ONLINE;LOCALSYSAUX ONLINE;LOCALTEMPONLINE;LOCALUSERS; ONLINE;LOCALGFB;ONLINE;LOCALYSZX130000002004;;;;ONLINE;LOCALRMANONLINE;LOCAL8 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; 252428800 INACTIVE 2; 252428800 INACTIVE 3; 252428800 CURRENT6、查看日志文件的位置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.rdo6 rows selected.7、查看数据文件的位置和大小SQL> select name,bytes from v$datafile;NAME BYTES----------/oradata/hb130000/system01.dbf492830720/oradata/hb130000/undotbs01.dbf 41943040/oradata/hb130000/sysaux01.dbf346030080NAME BYTES----------/oradata/hb130000/users01.dbf 5242880/oradata/hb130000/GFB.DBF 20971520/oradata/hb130000/YSZX130000002004.DBF176160768NAME BYTES----------/oradata/hb130000/rman.dbf1048576007 rows selected.8、查看用户拥有的对象和类型 SQL> select object_name,object_type from dba_objects where owner='SCOTT';OBJECT_NAME OBJECT_TYPE-------------------------------------------------------------------------------------------------------------------------------- -------------------DEPT TABLEPK_DEPT INDEXEMP TABLEPK_EMP INDEXBONUS TABLESALGRADE TABLE6 rows selected.9、查看临时文件的信息SQL> select name,bytes from v$tempfile;NAME BYTES----------/oradata/hb130000/temp01.dbf 2097152010、查看归档日志信息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;;;1772848NAME--------------------------------------------------------------------------------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