How can you obtain Information about control file?

@ : Home > > Interview Room

  Control file information can be found in initialization parameter file.
  We can query v$controlfile to display the names of control files
- From SQL, we can execute 
  SQL> show parameter control_files;
- The above query gives the name, Location of control files in our physical disk.

In Second way:
- We can edit PFILE using a vi editor and control_files parameter gives us information about the number of and location of control files.

Alert me