aha, thanks for that. Well, this has been very helpful - 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.
Cheers | [reply] |
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.
| [reply] |
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] |