Ask the Expert

Low open file descriptor limit

Help -- the Oracle log shows this message:

    Requires Free Membership to View

instance running on a system with low open file descriptor limit. Tune your system to increase this limit to avoid severe performance degradation.
Environment: SunOS 5.8 Generic_108528-24 sun4u sparc SUNW,Ultra-Enterprise-10000 Oracle 9.20
You will get this message when one of two conditions is met, either your server is not configured properly for the large number of datafiles in your database, or you have defined MAXDATAFILES to be a number larger than your server is configured for. Too see how many files your server is configured for, issue the following:
oracle_ora9i% ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        8192
coredump(blocks)     unlimited
nofiles(descriptors) 256
vmemory(kbytes)      unlimited

Notice the "nofiles" line. This is the number of file descriptors your system is configured for. To see the MAXDATAFILES parameter, dump your control file to trace and look at the resulting trace file in USER_DUMP_DEST.

If you decide to decrease MAXDATAFILES, then you'll have to recreate your control file with a lower number. You'll want this number to be higher than your number of database datafiles though. Personally, I'd rather do the next option than recreate my control file.

If you decide to reconfigure your kernel, you will have to modify the values for rlim_fd_max (the hard limit) and/or rlim_fd_cur (the soft limit) in /etc/system and reboot your server. Make sure you work with your sys admin on this procedure.

This was first published in February 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: