Interested to Buy Any Domain ? << Click Here >> for more details...
What does a Control file Contain ?
- 2 Answers
- 8249 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / orawhiz
A Control file records the physical structure of the
database. It contains the following information.
Database Name
Names and locations of a database's files and redolog files.
Time stamp of database creation.
| Is This Answer Correct ? | 9 Yes | 0 No |
The control files of a database store the status of the
physical structure of the database. The control file is
absolutely crucial to database operation. It contains (but
is not limited to) the following types of information:
* Database information (RESETLOGS SCN and their time
stamp)
* Archive log history
* Tablespace and datafile records (filenames, datafile
checkpoints, read/write status, offline or not)
* Redo threads (current online redo log)
* Database's creation date
* database name
* current archive log mode
* Log records (sequence numbers, SCN range in each log)
* RMAN catalog
* Database block corruption information
* Database ID, which is unique to each DB
| Is This Answer Correct ? | 7 Yes | 1 No |
What is a nested table and how is it different from a normal table?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is meant by raw datatype?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Do View contain Data ?
What is a proxy class?
difference between truncate and delete ,drop?
What is the oracle implicit cursor?
Explain an index segment?
What suggestions do you have to reduce the network traffic?
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
What is different bet native dynamic sql and Dbms_Sql?
Oracle General 
