What are the possible ways to gain information regarding the Control File?

devquora
devquora

Posted On: Feb 22, 2018

 

  • You can check the information regarding the control file in the initialization parameter file.
  • You can also the query v$controlfile that will show you the information regarding control file.

You can also perform SQL> show parameter control_files form SQL. This query gives you the information such as name, the location of the file in the disk.

You can make changes in the PFILE with the help of vi editor and control_files provide you with the information regarding the location and the name of the control files.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Oracle DBA Interview Questions

    What do you understand by the Oracle?

    Oracle is a database company that stores the data. Oracle stores the data in a very definite way so that client can regain it in a multi-user condition...

    Oracle DBA Interview Questions

    What do you mean by Oracle Database?

    Oracle has the main theme of storing, creating and managing the database...

    Oracle DBA Interview Questions

    What do you mean by Oracle DBA and what is its role?

    DBA stands for the Database administrator. DBA has the proper rights that can add or remove new users...