Control file information
From MyWiki
V$CONTROLFILE - Lists the name and status of all control files associated with the instance.
V$PARAMETER - Lists status and location of all parameters.
V$CONTROLFILE_RECORD_SECTION - Provides information about the control file record sections.
show parameters control_file
While control files are small, the size of the file can be significantly influenced by the following CREATE DATABASE or CREATE CONTROLFILE command parameters if they have large values.
- MAXLOGFILES
- MAXLOGMEMBERS
o MAXLOGHISTORY o MAXDATAFILES o MAXINSTANCES
