Where to find MAXxxxxxx control file parameters in Data Dictionary

PURPOSE
How to find  information about the following  controlfile parameters
- MAXLOGFILES

- MAXDATAFILES
- MAXLOGHISTORY
- MAXLOGMEMBERS
- MAXINSTANCES

Explanation

• The values of MAXLOGFILES, MAXLOGMEMBERS, MAXDATAFILES, MAXINSTANCES and MAXLOGHISTORY are set either during CREATE DATABASE, or CREATE CONTROLFILE

• In all Oracle versions, the CREATE CONTROLFILE syntax can be regenerated from the data dictionary using 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE;'  and can be checked from trace
• For  parameters (exepct  MAXLOGMEMBERS) can be seen  from  v$controlfile_record_section
  select decode(TYPE,
    'REDO LOG',    'MAXLOGFILES',
    'DATAFILE',     'MAXDATAFILES',
    'CKPT PROGRESS','MAXINSTANCES',
    'REDO THREAD','MAXINSTANCES',
    'LOG HISTORY','MAXLOGHISTORY') TYPE,RECORDS_TOTAL
  from v$controlfile_record_section
  where type in
  ('REDO LOG','DATAFILE','CKPT PROGRESS','REDO THREAD','LOG HISTORY');
  
  
  TYPE RECORDS_TOTAL
  
  --------------- -------------
  MAXINSTANCES 11
  MAXINSTANCES 8
  MAXLOGFILES 128
  MAXDATAFILES 10000
  MAXLOGHISTORY 10225
• MAXLOGMEMBERS is available via "x$kccdi.dimlm".