Max number of datafiles per tablespace?

[kgb]

Hi, guys!
Could you tell me please max number of datafiles per tablespace for Oracle8i?
Thank you

[pipo]

1023

[jmodic]

From Oracle8i Reference Release2 (8.1.6):

Database files
Maximum per tablespace: Operating system dependent; usually 1022

[julian]

Originally posted by jmodic
From Oracle8i Reference Release2 (8.1.6):

Database files
Maximum per tablespace: Operating system dependent; usually 1022

There are some factors that influence on that number. When you create your DB with CREATE DATABASE, you use a parameter called MAXDATAFILES. It is the limit on the number of datafiles which can be associated with this database. In the init.ora, there is a parameter called DB_FILES. This is the limit on the total number of
files related to this particular INSTANCE of a database.

So, in Oracle Parallel Server you might have 1 DB but 4 instances that use the same DB.

Additionally, the default and the range of values of maxdatafiles and db_files are operating system specific.

In Unix and NT the number for a TS is 1022. There is no limit for VMS however.

Thus, what Pipo and Jmodic told you might not be really the number you are looking for.

[pipo]

anyway, 99.99% of the databases won't even reach 100 datafiles, so 1022 or 1023 is far from being a reachable limit, except if you have 2Tb of data ... in one tablespace, which indicates that there is a slight problem of conception in the architecture ...

[Edited by pipo on 10-02-2001 at 07:39 AM]

[julian]

Originally posted by pipo
anyway, 99.99% of the databases won't even reach 100 datafiles, so 1022 or 1023 is far from being a reachable limit, except if you have 2Tb of data ... in one tablespace, which indicates that there is a slight problem of conception in the architecture ...

[Edited by pipo on 10-02-2001 at 07:39 AM]

If your MAXDATAFILES has the UNIX default of 30, how can (s)he make 31 datafiles in his INDEX tablespace? Only if (s)he recreates the control file first :-)

[kgb]

Thank you guys!
Anyway your answers is confused me.
I had found in different sources different max values (1022 & 1023) as well. I am preparing for taking OCP test for Oracle 8i and I don't know which value is correct for that.
Thank you.

[julian]

Since Oracle 7, 1022 is the number per TS for most common platforms. It used to be much lower for Oracle 6.

I think that it is always power(2,N)-2 for some N.

[jmodic]

Originally posted by julian
Since Oracle 7, 1022 is the number per TS for most common platforms

No, in Oracle7 it used to be 1022 *per database*, not *per TS*. This changed in 8.0.

[julian]

Yes, good remark. In Oracle 6 & 7, there was no limit for a TS, the value was for DB. In Oracle 6, much smaller value than in Oracle 7.