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
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