All,
Our SA is considering setting the max open files from 2048 to 30K. This sounds like a drastic change. Does anybody have an idea of the negative impacts of increasing the open files too high? Would like to know if this change could negatively impact our system. What test should we run to ensure we don't break production.
In anything fairly contemporary (<10 years old), probably not an issue. The problem with modifying the value in yesteryear had to do with tighter memory constraints... shouldn't be an issue anymore. Our performance team has been asking me to bump that same limit to 32768 (which can be max on some systems).
I am not aware of anything <10 years old that would suffer breakage.... but I could be wrong.
Well, is it even possible on your system? What is it?