Obtaining Control File Information

If the control file is something that is important to be able to manage, it is something that you need to be able to find information on. How do you find information about the control files from the database? Table 8.1 provides the data dictionary views that provide information about the control files connected to your database and your instances.

Table 8.1. Data Dictionary Views for Control Files
Data Dictionary ViewDescription
V$DATABASEDisplays database information from the control file including the following:

CONTROLFILE_TYPE

CONTROLFILE_CREATED

CONTROLFILE_SEQUENCE#

CONTROLFILE_CHANGE#

CONTROLFILE_TIME
V$CONTROLFILELists the names and status of all control files
V$CONTROLFILE_RECORD_SECTIONDisplays information ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial