00051.Oracle控制文件信息获取及常用视图

SQL> select*from v$archived_log;

SQL> select *fromv$backup;

SQL> select*from v$database;

SQL> select*from v$datafile;

SQL> select*from v$log;

SQL> select*from v$logfile;

SQL> select*from v$loghist;

SQL> select*from v$tablespace;

SQL> select*from v$tempfile;

SQL> select * fromv$tempfile;

SQL> select type,record_size,records_total,records_used from v$controlfile_record_sectionwhere rownum<5;

TYPE                 RECORD_SIZE RECORDS_TOTALRECORDS_USED

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

DATABASE                     316             1            1

CKPT PROGRESS               8180            11            0

REDO THREAD                  256             8            1

REDO LOG                      72            16           16

SQL> select type,record_size,records_total,records_used from v$controlfile_record_sectionwhere  type in ('DATABASE','TABLESPACE');

 

TYPE                 RECORD_SIZE RECORDS_TOTALRECORDS_USED

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

DATABASE                     316             1           1

TABLESPACE                    68           1000            6