In today’s article, we will be learning how to Control File Location and size information in Oracle.
The information kept in the control file is queried with the “v$controlfile_record_section” parameter.
|
1 |
SQL> select * from v$controlfile_record_section; |
Control file, file locations and size information.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SQL> select * from v$controlfile; STATUS ------- NAME -------------------------------------------------------------------------------- IS_ BLOCK_SIZE FILE_SIZE_BLKS --- ---------- -------------- /u01/app/oracle/oradata/traindb/control01.ctl NO 16384 594 /u01/app/oracle/oradata/traindb/control02.ctl NO 16384 594 |
File location query for control file.
|
1 2 3 4 5 6 7 8 |
SQL> show parameter control_files NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string /u01/app/oracle/oradata/traind b/control01.ctl, /u01/app/orac le/oradata/traindb/control02.c tl |
