MAXDATAFILES What files constitute this parameter?

From: Tom A <tashbrk_at_ix.netcom.com>
Date: Tue, 9 Mar 1999 20:18:34 -0500
Message-ID: <7c4ru1$jej@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 Tue Mar 09 1999 - 19:18:34 CST