oracle 控制文件的查看,oracle查看控制文件的配置情况

1.获取控制文件中全部记录的相关信息

select type,record_size,records_total,records_used from v$controlfile_record_section;

TYPE                         RECORD_SIZE RECORDS_TOTAL RECORDS_USED

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

DATABASE                             316             1            1

CKPT PROGRESS                       8180            11            0

REDO THREAD                          256             8            1

REDO LOG                              72            16            3

DATAFILE                             428           100            5

FILENAME                             524          2298            9

TABLESPACE                            68           100            6

TEMPORARY FILENAME                    56           100            1

.....

record_size:每个记录的字节数

records_total:该段分配的记录个数

records_used:该段所使用的记录个数

2.

SQL> select type,record_size,records_total,records_used from

2  v$controlfile_record_section

3  where type in('DATAFILE','TABLESPACE','REDO LOG');

TYPE                         RECORD_SIZE RECORDS_TOTAL RECORDS_USED

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

REDO LOG                              72            16            3

DATAFILE                             428           100            5

TABLESPACE                            68           100            6

3.怎样查看控制文件的路径？

SQL> select value from v$parameter where name='control_files';

VALUE

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

/oradata/law/law/control01.ctl, /oradata/law/law/control02.ctl, /oradata/law/law

/control03.ctl

SQL> select * from v$controlfile

2  ;

STATUS  NAME                      IS_ BLOCK_SIZE FILE_SIZE_BLKS

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

/oradata/law/law/control0 NO       16384            430

1.ctl

/oradata/law/law/control0 NO       16384            430

2.ctl

/oradata/law/law/control0 NO       16384            430         3.ctl