由 macro 发布于: 2001-02-28 19:30

1.V$CONTROLFILE

SQL> select name from v$controlfile;

NAME
----------------------------------------------------
/disk1/oradata/editor/control01.ctl
/disk2/oradata/editor/control02.ctl


The V$PARAMETER view can also be used;hower ,because of column lenghts,the control file names may be truncated.

2.v$controlfile_record_section

SQL> SELECT type , record_size, records_total, records_used
2 FROM v$controlfile_record_section
3 WHERE type='DATAFILE';

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED
----------------- ----------- ------------- ------------
DATAFILE 180 254 17

3.Performance views from the control file:
-V$DATAFILE
-V$TEMPFILE
-V$TABLESPACE
-V$LOG
-V$BACKUP
-V$ARCHIVE
-V$LOGFILE
-V$LOGHIST
-V$ARCHIVED_LOG
-V$DATABASE
-Others

__________________

谢谢你抽时间看我的发言，

Macro Zeng

==================================

我正在学习 Oracle ,坚持每天写读书笔记