Configuration parameters affect control file size - Oracle Control Files

Q.  Configuration parameters such as MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES affect control file size.
- Published on 19 Oct 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 28 Aug 15
    - Creating Initial Control Files - The initial control files of an Oracle Database are created when you issue the CREATE DATABASE statement.

    - The names of the control files are specified by the CONTROL_FILES parameter in the initialization parameter file used during database creation.

    - The filenames specified in CONTROL_FILES should be fully specified and are operating system specific.

    - The size of the control file changes between some releases of Oracle Database, as well as when the number of files specified in the control file changes.

    - Configuration parameters such as MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES affect control file size.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)