Re^5: Too many open files error with DBD Oracle

I think I need to rethink the way I'm using files and Oracle connections to work around this (e.g. re-using the connection rather than disconnecting for each iteration), as my options for changing the Oracle install are limited.

Rather than making wholesale changes to what you have working, if instead of creating 25 new threads, connections & filehandles within the same process to process each new input file; restart(*) the entire process. That way you get a clean slate for everything.

(*)If Solaris is a forky OS, then that might be the way to go.

Comment on Re^5: Too many open files error with DBD Oracle

Replies are listed 'Best First'.
Re^6: Too many open files error with DBD Oracle by JoeW (Novice) on Jun 28, 2010 at 13:56 UTC
Well, well - thank you v much for that. Hadn't used fork before - very useful! Solves my problem, with very little code change. Cheers	[reply]