Multi-tread in Oracle Scheduler external job
Hi Gurus,
I have a strange situation. I have a Perl script running impdp or expdp Oracle utility and this script works in multi-thread mode. Namely one thread runs appropriate Oracle utility when the other watches after suspended data pump processes and tries to solve problems or kills a suspended job.
The script was tested and works fine until I run it from the command line. But being executed as Oracle Scheduler external jobs it works like the watching thread does not start at all: it doesn't try to solve suspensions or to kill the job.
Dos anybody know whether external job mechanism allows multi-threaded execution?
I have a strange situation. I have a Perl script running impdp or expdp Oracle utility and this script works in multi-thread mode. Namely one thread runs appropriate Oracle utility when the other watches after suspended data pump processes and tries to solve problems or kills a suspended job.
The script was tested and works fine until I run it from the command line. But being executed as Oracle Scheduler external jobs it works like the watching thread does not start at all: it doesn't try to solve suspensions or to kill the job.
Dos anybody know whether external job mechanism allows multi-threaded execution?
0