How to check
MAXDATAFILES
MAXLOGHISTORY
MAXINSTANCES
MAXLOGFILES
MAXLOGMEMEBERS
-- MAXDATAFILES
Select 'MAXDATAFILES ' || records_total from v$controlfile_record_section where type = 'DATAFILE';
-- MAXLOGHISTORY
Select 'MAXLOGHISTORY ' || records_total from v$controlfile_record_section where type = 'LOG HISTORY';
-- MAXINSTANCES
Select 'MAXINSTANCES ' || records_total from v$controlfile_record_section where type = 'DATABASE';
-- MAXLOGFILES
Select ' MAXLOGFILES ' || records_total from v$controlfile_record_section where type = 'REDO LOG';
-- MAXLOGMEMBERS
Select 'MAXLOGMEMBERS ' || dimlm from x$kccdi;
