Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Value of MAXDATAFILES
Stephane
Thanks for the info - it appears to be the RECORDS_TOTAL field of the view V$CONTROLFILE_RECORD_SECTION. Regards
Alex
Stephane Faroult wrote:
> Alex Hudghton wrote:
> >
> > Is there any way to get the value of MAXDATAFILES from the database (NOT
> > using 'alter database backup controlfile to trace) ??
> >
> > Alex
>
> The MAXDATAFILES is the number of 'slots' reserved in the control files,
> as opposed to the (smaller or equal) storage in SGA which is allocated
> from the init.ora db_files parameter (which you can get from
> V$PARAMETER). With Oracle8 you can get it from one of the new V$ views,
> I am not sure about the name, something like V$CONTROL_HEADER_SECTION or
> similar (I suggest select name from v$fixed_table where type = 'VIEW'
> and name like '%CONTROL%'). With previous version I am not quite sure
> you can get it from the number of rows of a X$ pseudo view as said in
> another post. It may be the case, but I have always had the impression
> that the number of lines in X$ tables rather were connected to init.ora
> values. You can try a few of the X$KCF something tables listed in
> V$fixed_table.
>
> --
> Regards,
>
> Stéphane Faroult
> Oriole Corporation
> ------------------------------------------------------------------
> http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
> ------------------------------------------------------------------
Received on Thu Apr 29 1999 - 02:36:17 CDT