Interested to Buy Any Domain ? << Click Here >> for more details...
What does a Control file Contain ?
- 2 Answers
- 8180 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 |
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
What are the attributes that are found in a cursor?
How to convert a date to char in oracle? Give one example.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is DTS and purpose of DTS ?
What are a cluster and non-cluster index?
Explain the types of exception?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is the use of aggregate functions in oracle?
Which is faster join or subquery in oracle?
How to run queries on external tables?
Oracle General 
