Re: Determining the value of MAXLOGFILES and MAXLOGMEMBERS

From: FC <flavio_at_tin.it>
Date: Fri, 25 Apr 2003 20:26:07 GMT
Message-ID: <zRgqa.5373$3M4.137642@news1.tin.it>

Thanks for the suggestion, I read the note on Metalink and came up with the following query:

select a.records_total as MAXLOGFILES,
       b.records_total as MAXDATAFILES,
       c.records_total as MAXINSTANCES,
       d.records_total as MAXLOGHISTORY,
       e.dimlm         as MAXLOGMEMBERS
  from v$controlfile_record_section a,
       v$controlfile_record_section b,
       v$controlfile_record_section c,
       v$controlfile_record_section d,
       x$kccdi e
where a.type = 'REDO LOG'
  and b.type = 'DATAFILE'

  and c.type = 'CKPT PROGRESS'
  and d.type = 'LOG HISTORY'

it seems to work fine for 8i.

Bye,
Flavio Received on Fri Apr 25 2003 - 15:26:07 CDT