Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of Control File ?
- 3 Answers
- 6397 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
control file contains crucial information regarding the
database.Without control file u can't open the database.
It maintains integrity of database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abitha
Control files of a database store the status of the
physical structure of the database. The control file is
absolutely crucial to database operation.
Control file contains:
Database information
Archive log history
Redo threads
database name
Current archive log mode
Database's creation date etc.,
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
Controlfile contains the information about the database like names and locations of datafiles, name of the database, database creation timestamp and apart from this the SCN are also reported into control during the database operation. Especially during the database startup the controlfile is used to gather the information about the database and while opening the database the information in the controlfile is validated to check for the consistency of the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do we display rows from the table without duplicates?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
What is dynamic proxy?
Explain the use of rows option in imp command.
How to retrieve 5th highest sal from emp table?
How to concatenate two text values in oracle?
Can a parameter be passed to a cursor?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to start your 10g xe server?
What are the common oracle dba tasks?
What is tns name?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
Oracle General 
