Found the answer on MetaLink.. here is the info for all that is interested:
PURPOSE
This bulletin describes where to find information about following
controlfile parameters in the data dictionary:
- MAXLOGFILES
- MAXDATAFILES
- MAXLOGHISTORY
- MAXLOGMEMBERS
- MAXINSTANCES
SCOPE & APPLICATION
This article is intended for all Oracle DBA's.
RELATED DOCUMENTS
Oracle8 Reference Release 8.0
[NOTE:1038348.6] Additions to the data dictionary views
[NOTE:1066346.6] Is MAXLOGHISTORY etc available from X$ tables at all?
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;'.
The resulting tracefile will contain the current MAX values for the database.
Refer to [NOTE:1012929.6] for additional information.
Using queries against v$controlfile_record_section and x$kccdi the
control file parameters can be retrieved direct from an Oracle8 data
dictionary.
SVRMGR> select TYPE,RECORDS_TOTAL from v$controlfile_record_section;
TYPE RECORDS_TO
REDO LOG 32 --> MAXLOGFILES
DATAFILE 30 --> MAXDATAFILES
DATABASE 1 --> MAXINSTANCES
LOG HISTORY 3317 --> MAXLOGHISTORY
MAXLOGMEMBERS:
MAXLOGMEMBERS is available via "x$kccdi.dimlm". Refer to [NOTE:1066346.6].
.
- Tom Tyson <tomtysonjr_at_yahoo.com> wrote:
> Hello
>
> I am having trouble locating the correct V$ view (If there is one...), to
> tell
> me the following controlfile creation information:
>
> MAXLOGFILES
> MAXLOGMEMBERS
> MAXDATAFILES
> MAXINSTANCES
> MAXLOGHISTORY
>
> I know I could execute an 'alter database backup controlfile to trace;'
> command, and look at the trace file contents, but I needed to query this in a
> PL/SQL block of code. Can someone point me to the correct view(s)?
>
> Thanks!
> Tom Tyson
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tom Tyson
> INET: tomtysonjr_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Received on Wed Sep 20 2000 - 14:24:54 CDT
