sagarit2 has asked for the wisdom of the Perl Monks concerning the following question:

I am trying to run multi-threaded perl script. When I run the script with 50 threads, it runs fine.But if I increase the no of threads from 50 to 80 it gives following message : Thread 79 terminated abnormally: Can't locate DBD/Oracle.pm in @INC (@INC contains: /x/perl585/lib/5.8.5/sun4-solaris-thread-multi /x/perl585/lib/5.8.5 /x/perl585/lib/site_perl/5.8.5/sun4-solaris-thread-multi /x/perl585/lib/site_perl/5.8.5 /x/perl585/lib/site_perl .) at (eval 9) line 3. Can you please help me out on this ??

Replies are listed 'Best First'.
Re: Can't locate DBD/Oracle.pm in @INC
by ikegami (Patriarch) on Aug 27, 2008 at 04:05 UTC
    Maybe your threads are gobbling up all available file handles???
      I think "ikegami" has a valid point about threads consuming all available file handles because at the end I am getting "Too many open files" error message. Can you give me any solution to tackle this issue ??
Re: Can't locate DBD/Oracle.pm in @INC
by jethro (Monsignor) on Aug 27, 2008 at 03:56 UTC

    Have you checked the memory usage of your threads? Although if it is memory I would expect either a memory full message or random errors.