|
/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 owner=''''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
上一页 [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
| 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
