Re: Oracle MAXDATAFILES

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Tue, 7 Jul 2009 06:09:43 -0700 (PDT)
Message-ID: <0011a482-3491-499d-be1d-503dfd68ae01_at_t13g2000yqt.googlegroups.com>

On Jul 7, 11:46 am, Ming伯 <l..._at_tech-trans.com> wrote:
> Hi,
>
>   How to determine MAXDATAFILES in a Oracle instance?  At the same
> time, how to change MAXDATAFILES?  Thx!
>
> Ming

Oracle version? All releases since 8i automatically expand control file when MAXDATAFILES is exceeded as long as the number of files does not exceed DB_FILES initialization parameter, but for 8i MAXDATAFILES was a hard limit and you had to recreate the control file to change it. Note that DB_FILES still limits the number of data files, but this one can easily be changed. To find out current MAXDATAFILES, you can use this query:

select records_total
  from v$controlfile_record_section
 where type='DATAFILE'

Hth,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Tue Jul 07 2009 - 08:09:43 CDT