Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 |
