Hi guys,
We have reached to the limit of data files in our production DB and currently we cannot add data files.
Today we have a maintenance window and I want to increase the parameter DB_FILE and boune the DB.
Following some details:
DB version : 10.2.0.4
OS version: Sun Sparc Solaris 5.10 64 bit
DB_FILE=10000
I wanted to consult with you how to configure now the parameter DB_FILE?Code:PROD> ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) 8192 coredump(blocks) unlimited nofiles(descriptors) 65000 vmemory(kbytes) unlimited
Increasing to 15,000? maybe more?
Thanks in advance![]()




Reply With Quote