-
Hi, guys!
Could you tell me please max number of datafiles per tablespace for Oracle8i?
Thank you
-
-
From Oracle8i Reference Release2 (8.1.6):
Database files
Maximum per tablespace: Operating system dependent; usually 1022
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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.
-
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]
-
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 :-)
-
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.
-
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.
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|