SatarNag wrote:
>
> 18-AUG-1997
>
> Hi everyone, last week I read a posting in which someone stated that thier
> Database files were maxed out (in this case, he reached his limit of 32
> database files). A few of you replied that he could change the DB_FILES
> parameter to increase the value. According to "Oracle Worldwide Support
> Frequently Asked Questions" (which are found on page 3-91 of the Oracle
> 7:Database Administration
> volume 1- Student Guide), It states:
>
> Q: Why is there a limit on MAXDATAFILES?
> A: Each platform uses a port-specific number of bits to store the Oracle
> file numbers. Thus, MAXDATAFILES is limited by this number. To find the
> number, look in your operating system documentation.
>
> Q: Why would one set DB_FILES to anything less than MAXDATAFILES?
> A: Increasing the value of DB_FILES increases the size of the PGA, which
> is allocated for every process connected to Oracle.
>
> My question to any of you is:
> How many DataFiles can I have on a UNIX system V platform (Sun SPARQ2/Sun
> OS 2.5.1) (Oracle 7.2.2)?
>
> I've looked in all my documentation, but failed to find the answer.
>
> Much Thanks,
> Satar Naghshineh
> SatarNag_at_aol.com
Hi,
In my Unix Installation and Users guide for SPARC Solaris 2.3
the max value is 1022 found on page d-22.
Hope this helps.
Dick
Received on Mon Aug 18 1997 - 00:00:00 CDT
