Re: MAXDATAFILES - How to tell what files constitute this?

Hi

Another way not to hit the limit is to use the following to RESIZE the existing datafiles as needed:

alter database datafile '/r1/PROD/file1' resize 800M;

HTH Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

Tom A <tashbrk_at_ix.netcom.com> wrote in article <7c4riu$ivu_at_dfw-ixnews5.ix.netcom.com>...
> The parameter MAXDATAFILES that is defined at database creation and in
part
> determines how large the controlfile, PGA, etc.. is easy enough to
> understand.
>
> My question is what files make up the number that goes towards
MAXDATAFILES
> in Oracle 7.3?
>
> We ran up against this limit the other day - no problem fixing it - but I
> would like to be able to determine if we are getting close to that limit
in
> the other databases by periodically querying the databases. The name
> implies 'datafiles' but there were only 20 datafiles (count(*) on
> DBA_DATA_FILES).
>
> Old situation:
>
> MAXDATAFILES = 30
> 20 datafiles. select count(*) from dba_data_files
> 6 log files. select count(*) from v$logfiles - or something like that
> 2 control files. select count(*) from v$controlfiles - or something like
> that
> 2 init.ora files select ?????????????? Is this info stored in the
database
> somewhere?
>
> This makes 30 but is it a coincidence?
>
> TIA,
> Tom.
>
>
>
Received on Thu Mar 11 1999 - 16:26:05 CST