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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment