Maximum datafiles reached in 9.2.0.5

[gatetec]

In the init.ora on my UNIX box, I don't see the parameter "DB_FILES" for the limit on the total number of files associated with the db instance. database. I assume the default is 1022 (V7) as to the parameter is left out on init.ora.
- How do you check whether it is V7 or not?
- Is there anyway to change the limit without bouncing the database?
- If bouncing db is required, should I put the "DB_FILES" in init.ora? Then, what should be the # of files to avoid any further issues on the # of "DB_FILES"?
- Do you usually put "DB_FILES" parameter in init.ora when you build a database?

I never expected this type of issue...

thx much

 

[KenCunningham]

According to:

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams049.htm

the default is 200 for 10.2 and it's possible that this is the same for 9.2.0.5, though I can't verify that. According to that document, you have to restart for the changes to take effect.

I want to be good, is that not enough?

 

[DrD123]

Hi gatec.

Default for 9.2.0.6 is 200 as well.

But to answer about putting your new value in the init.ora, the answer is yes. That way it'll take effect on any restart of the dB.

If you want to look at the value of that and other parameters not included in your init.ora you would log into SQLPLUS then:

SQL> show parameters

or to show ones including a specific "word"

SQL> show parameter db

The maximum amount of files, are OS dependent. Also the size of the dB files are OS dependent.

Good Luck
DrD

 

[gatetec]

I have this:

SQL> show PARAMETER DB_FILES;

NAME TYPE VALUE
------------------------------------ ----------- -----------------------
db_files integer 1022

So, in init.ora, what is the exact entry if you want to put 2000 db files?

DB_FILES 2000

thx much

 

[KenCunningham]

It would be:

DB_FILES = 2000

I want to be good, is that not enough?