Saturday, December 1, 2012

How to check MAXDATAFILES, MAXLOGHISTORY, MAXLOGFILES




SQL> Select '-- MAXDATAFILES -- ' || records_total  from v$controlfile_record_section where type = 'DATAFILE';

-- MAXDATAFILES --  256


SQL> Select '-- MAXLOGHISTORY -- ' || records_total  from v$controlfile_record_section where type = 'LOG HISTORY';

-- MAXLOGHISTORY -- 584

SQL> Select '-- MAXINSTANCES -- ' || records_total  from v$controlfile_record_section where type = 'DATABASE';


-- MAXINSTANCES -- 1

SQL> Select '-- MAXLOGFILES -- ' || records_total  from v$controlfile_record_section where type = 'REDO LOG';

-- MAXLOGFILES -- 255

SQL> Select '--> MAXLOGMEMBERS ' || dimlm from x$kccdi;

-- MAXLOGMEMBERS -- 5

No comments:

Post a Comment